Freelancer logo How It Works Browse Jobs
Log In Sign Up
Post a Project
Profile cover photo
You're now following
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar
$10 USD / hour
Flag of PHILIPPINES
calamba, philippines
$10 USD / hour
It's currently 3:38 PM here
Joined November 15, 2009
0 Recommendations

Tristan Louie P.

@engrtan

 5.0 (9 reviews)
4.2
4.2
100%
100%
$10 USD / hour
Flag of PHILIPPINES
calamba, philippines
$10 USD / hour
100%
Jobs Completed
100%
On Budget
100%
On Time
N/A
Repeat Hire Rate

B.Sc. Civil Eng., M.Eng. Geotech.

I am a Civil Engineer. My primary work focus is in the preparation of CAD drawings, specifications, technical reports, and materials/quantity surveying. I have been able to apply my skills in spreadsheets, documents, CAD drawings, and PDF editing much less than before. Taking up some freelance work would help me maintain, if not further, my skills. I love spreadsheets, both MS Excel and Google Sheets. But, I am more drawn to furthering my skills with Google Sheets, especially with the preparation of scripts to automate data processing. SQL is also within my sight, as part of data analysis. On the side, I also do some image manipulation, and copy typing taking advantage of my touch typing skills in both English and French - with 65wpm speeds, as well as some Python programming.
Freelancer Excel Experts Philippines
See all Excel Experts in Philippines

Contact Tristan Louie P. about your job

Log in to discuss any details over chat.

Portfolio

3357240
Processes on Google Spreadsheet tend to slow down with alternating read-write processes. This project involved two processes that should be completed within the 6-min mark, or at least set a system that would allow the script to identify where to continue next when the script is run again. Two processes were involved in this project. The first is to copy pre-identified rows of data (running into thousands) on to another sheet. Once this copy process is complete, it is required to deleted this copied rows from the original sheet. Screenshot shows the original, and revised script for the "copy" segment of the script, along with a screenshot of the spreadsheet.
Google Sheets Script Improvement
Processes on Google Spreadsheet tend to slow down with alternating read-write processes. This project involved two processes that should be completed within the 6-min mark, or at least set a system that would allow the script to identify where to continue next when the script is run again. Two processes were involved in this project. The first is to copy pre-identified rows of data (running into thousands) on to another sheet. Once this copy process is complete, it is required to deleted this copied rows from the original sheet. Screenshot shows the original, and revised script for the "copy" segment of the script, along with a screenshot of the spreadsheet.
Google Sheets Script Improvement
Processes on Google Spreadsheet tend to slow down with alternating read-write processes. This project involved two processes that should be completed within the 6-min mark, or at least set a system that would allow the script to identify where to continue next when the script is run again. Two processes were involved in this project. The first is to copy pre-identified rows of data (running into thousands) on to another sheet. Once this copy process is complete, it is required to deleted this copied rows from the original sheet. Screenshot shows the original, and revised script for the "copy" segment of the script, along with a screenshot of the spreadsheet.
Google Sheets Script Improvement
4293257
It is undeniable that live excel files tend to lose their formatting as entries (presumably by different users) are entered, and uniqueness of entries start to become doubtful as the list grows. Data (email, names, positions) were not ideally entered with a one-entry one-cell correspondence. Over one thousand rows of data entry was filtered, and duplicates remove, while identifying the key person and email address of the person with the highest rank/position in the company. Over one thousand rows of entries ended up as 900 valid entries. The left screenshot shows the original file, in Portuguese, while the one on the right is the filtered file, ready for use by the Client.
Clean up MS Excel File
3311162
Started out as a contest here on Freelancer, with a follow up work requested by client. For the contest, the client wanted a script to process the data collected by an active form. Function to copy the responses from the "From Responses 1" sheet was prepared to transfer data into "Sheet1a". A different function was then prepared to take in one row of data, from Columns A to G, from "Sheet1a" and transfer to "Sheet2 into six different corresponding rows. A process status marker (Column H) is written to by the script verifying that data was successfully copied. Column I shows to which rows the data from "Sheet1a" was copied to. For the follow up work, client requested to patch the Google Spreadsheet to call from/write data to an online database, working with an API script (developed by another). Column C on "Sheet2" is from a response value from the database, assigned to each row of data in "Sheet1a".
Google Form Responses Processing using Javascript
Started out as a contest here on Freelancer, with a follow up work requested by client. For the contest, the client wanted a script to process the data collected by an active form. Function to copy the responses from the "From Responses 1" sheet was prepared to transfer data into "Sheet1a". A different function was then prepared to take in one row of data, from Columns A to G, from "Sheet1a" and transfer to "Sheet2 into six different corresponding rows. A process status marker (Column H) is written to by the script verifying that data was successfully copied. Column I shows to which rows the data from "Sheet1a" was copied to. For the follow up work, client requested to patch the Google Spreadsheet to call from/write data to an online database, working with an API script (developed by another). Column C on "Sheet2" is from a response value from the database, assigned to each row of data in "Sheet1a".
Google Form Responses Processing using Javascript
Started out as a contest here on Freelancer, with a follow up work requested by client. For the contest, the client wanted a script to process the data collected by an active form. Function to copy the responses from the "From Responses 1" sheet was prepared to transfer data into "Sheet1a". A different function was then prepared to take in one row of data, from Columns A to G, from "Sheet1a" and transfer to "Sheet2 into six different corresponding rows. A process status marker (Column H) is written to by the script verifying that data was successfully copied. Column I shows to which rows the data from "Sheet1a" was copied to. For the follow up work, client requested to patch the Google Spreadsheet to call from/write data to an online database, working with an API script (developed by another). Column C on "Sheet2" is from a response value from the database, assigned to each row of data in "Sheet1a".
Google Form Responses Processing using Javascript
3357262
It's a fast-paced project. It's a collaboration wherein client had requested assistance in encoding the text of a French mathematics textbook, including equations. Graphs, and tables were not included in the task. Two chapters, around 30 - 40 pages each, were converted into two MS Word files every two or three days. Samples of the original handwritten text, and the corresponding MS Word file are shown as screenshots.
Copy-typing French Mathematics Textbook
It's a fast-paced project. It's a collaboration wherein client had requested assistance in encoding the text of a French mathematics textbook, including equations. Graphs, and tables were not included in the task. Two chapters, around 30 - 40 pages each, were converted into two MS Word files every two or three days. Samples of the original handwritten text, and the corresponding MS Word file are shown as screenshots.
Copy-typing French Mathematics Textbook
It's a fast-paced project. It's a collaboration wherein client had requested assistance in encoding the text of a French mathematics textbook, including equations. Graphs, and tables were not included in the task. Two chapters, around 30 - 40 pages each, were converted into two MS Word files every two or three days. Samples of the original handwritten text, and the corresponding MS Word file are shown as screenshots.
Copy-typing French Mathematics Textbook
It's a fast-paced project. It's a collaboration wherein client had requested assistance in encoding the text of a French mathematics textbook, including equations. Graphs, and tables were not included in the task. Two chapters, around 30 - 40 pages each, were converted into two MS Word files every two or three days. Samples of the original handwritten text, and the corresponding MS Word file are shown as screenshots.
Copy-typing French Mathematics Textbook
3318156
It's one of the first contests I joined. Admittedly, I don't have that much flair for graphics design. But once in a while, as I would like to think about it, I do get it right once in a while. Simple and clear requirements from the client who wishes to use three (or similar to) images recommended to make a massage shop banner. It shall cover a portion of the five-panel glass frontage of the store, at the top. Rights to use the images were procured by the client. Main requirement was to make the banner design to appear as if there's continuity through the five panels, i.e. to make it appear that there are no divisions in the glass frontage. Image shown here are the panels, in order, from left to right.
Store Front Sticker
It's one of the first contests I joined. Admittedly, I don't have that much flair for graphics design. But once in a while, as I would like to think about it, I do get it right once in a while. Simple and clear requirements from the client who wishes to use three (or similar to) images recommended to make a massage shop banner. It shall cover a portion of the five-panel glass frontage of the store, at the top. Rights to use the images were procured by the client. Main requirement was to make the banner design to appear as if there's continuity through the five panels, i.e. to make it appear that there are no divisions in the glass frontage. Image shown here are the panels, in order, from left to right.
Store Front Sticker
It's one of the first contests I joined. Admittedly, I don't have that much flair for graphics design. But once in a while, as I would like to think about it, I do get it right once in a while. Simple and clear requirements from the client who wishes to use three (or similar to) images recommended to make a massage shop banner. It shall cover a portion of the five-panel glass frontage of the store, at the top. Rights to use the images were procured by the client. Main requirement was to make the banner design to appear as if there's continuity through the five panels, i.e. to make it appear that there are no divisions in the glass frontage. Image shown here are the panels, in order, from left to right.
Store Front Sticker
It's one of the first contests I joined. Admittedly, I don't have that much flair for graphics design. But once in a while, as I would like to think about it, I do get it right once in a while. Simple and clear requirements from the client who wishes to use three (or similar to) images recommended to make a massage shop banner. It shall cover a portion of the five-panel glass frontage of the store, at the top. Rights to use the images were procured by the client. Main requirement was to make the banner design to appear as if there's continuity through the five panels, i.e. to make it appear that there are no divisions in the glass frontage. Image shown here are the panels, in order, from left to right.
Store Front Sticker
It's one of the first contests I joined. Admittedly, I don't have that much flair for graphics design. But once in a while, as I would like to think about it, I do get it right once in a while. Simple and clear requirements from the client who wishes to use three (or similar to) images recommended to make a massage shop banner. It shall cover a portion of the five-panel glass frontage of the store, at the top. Rights to use the images were procured by the client. Main requirement was to make the banner design to appear as if there's continuity through the five panels, i.e. to make it appear that there are no divisions in the glass frontage. Image shown here are the panels, in order, from left to right.
Store Front Sticker
3203928
Data scraped from Philippine Stock Exchange of last trade price for the day, to compute the current market holdings of securities in portfolio, and comparing with closing price of previous trading day, as well as FOREX data from Bangko Sentral ng Pilipinas (the central bank of the Philippines), using Google SpreadSheet
Data Scraping from PSE
3357240
Processes on Google Spreadsheet tend to slow down with alternating read-write processes. This project involved two processes that should be completed within the 6-min mark, or at least set a system that would allow the script to identify where to continue next when the script is run again. Two processes were involved in this project. The first is to copy pre-identified rows of data (running into thousands) on to another sheet. Once this copy process is complete, it is required to deleted this copied rows from the original sheet. Screenshot shows the original, and revised script for the "copy" segment of the script, along with a screenshot of the spreadsheet.
Google Sheets Script Improvement
Processes on Google Spreadsheet tend to slow down with alternating read-write processes. This project involved two processes that should be completed within the 6-min mark, or at least set a system that would allow the script to identify where to continue next when the script is run again. Two processes were involved in this project. The first is to copy pre-identified rows of data (running into thousands) on to another sheet. Once this copy process is complete, it is required to deleted this copied rows from the original sheet. Screenshot shows the original, and revised script for the "copy" segment of the script, along with a screenshot of the spreadsheet.
Google Sheets Script Improvement
Processes on Google Spreadsheet tend to slow down with alternating read-write processes. This project involved two processes that should be completed within the 6-min mark, or at least set a system that would allow the script to identify where to continue next when the script is run again. Two processes were involved in this project. The first is to copy pre-identified rows of data (running into thousands) on to another sheet. Once this copy process is complete, it is required to deleted this copied rows from the original sheet. Screenshot shows the original, and revised script for the "copy" segment of the script, along with a screenshot of the spreadsheet.
Google Sheets Script Improvement
4293257
It is undeniable that live excel files tend to lose their formatting as entries (presumably by different users) are entered, and uniqueness of entries start to become doubtful as the list grows. Data (email, names, positions) were not ideally entered with a one-entry one-cell correspondence. Over one thousand rows of data entry was filtered, and duplicates remove, while identifying the key person and email address of the person with the highest rank/position in the company. Over one thousand rows of entries ended up as 900 valid entries. The left screenshot shows the original file, in Portuguese, while the one on the right is the filtered file, ready for use by the Client.
Clean up MS Excel File
3311162
Started out as a contest here on Freelancer, with a follow up work requested by client. For the contest, the client wanted a script to process the data collected by an active form. Function to copy the responses from the "From Responses 1" sheet was prepared to transfer data into "Sheet1a". A different function was then prepared to take in one row of data, from Columns A to G, from "Sheet1a" and transfer to "Sheet2 into six different corresponding rows. A process status marker (Column H) is written to by the script verifying that data was successfully copied. Column I shows to which rows the data from "Sheet1a" was copied to. For the follow up work, client requested to patch the Google Spreadsheet to call from/write data to an online database, working with an API script (developed by another). Column C on "Sheet2" is from a response value from the database, assigned to each row of data in "Sheet1a".
Google Form Responses Processing using Javascript
Started out as a contest here on Freelancer, with a follow up work requested by client. For the contest, the client wanted a script to process the data collected by an active form. Function to copy the responses from the "From Responses 1" sheet was prepared to transfer data into "Sheet1a". A different function was then prepared to take in one row of data, from Columns A to G, from "Sheet1a" and transfer to "Sheet2 into six different corresponding rows. A process status marker (Column H) is written to by the script verifying that data was successfully copied. Column I shows to which rows the data from "Sheet1a" was copied to. For the follow up work, client requested to patch the Google Spreadsheet to call from/write data to an online database, working with an API script (developed by another). Column C on "Sheet2" is from a response value from the database, assigned to each row of data in "Sheet1a".
Google Form Responses Processing using Javascript
Started out as a contest here on Freelancer, with a follow up work requested by client. For the contest, the client wanted a script to process the data collected by an active form. Function to copy the responses from the "From Responses 1" sheet was prepared to transfer data into "Sheet1a". A different function was then prepared to take in one row of data, from Columns A to G, from "Sheet1a" and transfer to "Sheet2 into six different corresponding rows. A process status marker (Column H) is written to by the script verifying that data was successfully copied. Column I shows to which rows the data from "Sheet1a" was copied to. For the follow up work, client requested to patch the Google Spreadsheet to call from/write data to an online database, working with an API script (developed by another). Column C on "Sheet2" is from a response value from the database, assigned to each row of data in "Sheet1a".
Google Form Responses Processing using Javascript
3357262
It's a fast-paced project. It's a collaboration wherein client had requested assistance in encoding the text of a French mathematics textbook, including equations. Graphs, and tables were not included in the task. Two chapters, around 30 - 40 pages each, were converted into two MS Word files every two or three days. Samples of the original handwritten text, and the corresponding MS Word file are shown as screenshots.
Copy-typing French Mathematics Textbook
It's a fast-paced project. It's a collaboration wherein client had requested assistance in encoding the text of a French mathematics textbook, including equations. Graphs, and tables were not included in the task. Two chapters, around 30 - 40 pages each, were converted into two MS Word files every two or three days. Samples of the original handwritten text, and the corresponding MS Word file are shown as screenshots.
Copy-typing French Mathematics Textbook
It's a fast-paced project. It's a collaboration wherein client had requested assistance in encoding the text of a French mathematics textbook, including equations. Graphs, and tables were not included in the task. Two chapters, around 30 - 40 pages each, were converted into two MS Word files every two or three days. Samples of the original handwritten text, and the corresponding MS Word file are shown as screenshots.
Copy-typing French Mathematics Textbook
It's a fast-paced project. It's a collaboration wherein client had requested assistance in encoding the text of a French mathematics textbook, including equations. Graphs, and tables were not included in the task. Two chapters, around 30 - 40 pages each, were converted into two MS Word files every two or three days. Samples of the original handwritten text, and the corresponding MS Word file are shown as screenshots.
Copy-typing French Mathematics Textbook
3318156
It's one of the first contests I joined. Admittedly, I don't have that much flair for graphics design. But once in a while, as I would like to think about it, I do get it right once in a while. Simple and clear requirements from the client who wishes to use three (or similar to) images recommended to make a massage shop banner. It shall cover a portion of the five-panel glass frontage of the store, at the top. Rights to use the images were procured by the client. Main requirement was to make the banner design to appear as if there's continuity through the five panels, i.e. to make it appear that there are no divisions in the glass frontage. Image shown here are the panels, in order, from left to right.
Store Front Sticker
It's one of the first contests I joined. Admittedly, I don't have that much flair for graphics design. But once in a while, as I would like to think about it, I do get it right once in a while. Simple and clear requirements from the client who wishes to use three (or similar to) images recommended to make a massage shop banner. It shall cover a portion of the five-panel glass frontage of the store, at the top. Rights to use the images were procured by the client. Main requirement was to make the banner design to appear as if there's continuity through the five panels, i.e. to make it appear that there are no divisions in the glass frontage. Image shown here are the panels, in order, from left to right.
Store Front Sticker
It's one of the first contests I joined. Admittedly, I don't have that much flair for graphics design. But once in a while, as I would like to think about it, I do get it right once in a while. Simple and clear requirements from the client who wishes to use three (or similar to) images recommended to make a massage shop banner. It shall cover a portion of the five-panel glass frontage of the store, at the top. Rights to use the images were procured by the client. Main requirement was to make the banner design to appear as if there's continuity through the five panels, i.e. to make it appear that there are no divisions in the glass frontage. Image shown here are the panels, in order, from left to right.
Store Front Sticker
It's one of the first contests I joined. Admittedly, I don't have that much flair for graphics design. But once in a while, as I would like to think about it, I do get it right once in a while. Simple and clear requirements from the client who wishes to use three (or similar to) images recommended to make a massage shop banner. It shall cover a portion of the five-panel glass frontage of the store, at the top. Rights to use the images were procured by the client. Main requirement was to make the banner design to appear as if there's continuity through the five panels, i.e. to make it appear that there are no divisions in the glass frontage. Image shown here are the panels, in order, from left to right.
Store Front Sticker
It's one of the first contests I joined. Admittedly, I don't have that much flair for graphics design. But once in a while, as I would like to think about it, I do get it right once in a while. Simple and clear requirements from the client who wishes to use three (or similar to) images recommended to make a massage shop banner. It shall cover a portion of the five-panel glass frontage of the store, at the top. Rights to use the images were procured by the client. Main requirement was to make the banner design to appear as if there's continuity through the five panels, i.e. to make it appear that there are no divisions in the glass frontage. Image shown here are the panels, in order, from left to right.
Store Front Sticker
3203928
Data scraped from Philippine Stock Exchange of last trade price for the day, to compute the current market holdings of securities in portfolio, and comparing with closing price of previous trading day, as well as FOREX data from Bangko Sentral ng Pilipinas (the central bank of the Philippines), using Google SpreadSheet
Data Scraping from PSE

Reviews

Changes saved
Showing 1 - 5 out of 9 reviews
Filter reviews by:
5.0
€10.00 EUR
Match columns in CSV file - 24/05/2023 09:08 EDT
Super easy to work with, thanks!
Excel
LibreOffice
Spreadsheets
User Avatar
Flag of Martin E.
@qvistenmartin
•
1 year ago
5.0
$25.00 USD
Organize 1000 Entries Email Database For Mass Send
Simple job, but long. Done.
Data Processing
Data Entry
Excel
Portuguese (Brazil) Translator
Portuguese Translator
User Avatar
Flag of Ricardo R.
@ricardoroque
•
6 years ago
5.0
$10.00 USD
Excel for business model analysis
It was a great please to work with him. He was responsive, patience, and had the staying power to work until the solutions was found. This freelancer will not let you done! Very good indeed.
Excel
Financial Analysis
User Avatar
Flag of Fraser B.
@fraserbsquared
•
7 years ago
5.0
$160.00 AUD
Calculate the correlations between 238 individual items
Fast and no fuss Freelancer. Accurate work. Offered to make any changes I wanted. Thank you!
Statistical Analysis
C
Flag of Justine P.
@coffeeandacoach
•
7 years ago
5.0
$192.50 USD
Type handwritten Transcript
Great job done on short notice
Data Entry
Word
User Avatar
Flag of Moosa B.
@gr8tech
•
7 years ago

Education

MEng Geotechnical and Earth Resources Engineering

Asian Institute of Technology, Thailand 2014 - 2017
(3 years)

BS Civil Engineering

University of the Philippines, Philippines 1999 - 2005
(6 years)

Contact Tristan Louie P. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected

Certifications

us_eng_1.png US English 1 100%
numeracy_1.png Basic Numeracy 1 91%
academic_wr.png Academic Writing 1 88%
vworker.png Foundation vWorker Member

Top Skills

Excel 4
JavaScript 2
Data Entry 2
Data Processing 1
Photo Editing 1

Browse Similar Freelancers

Excel Experts in Philippines
Excel Experts
Javascript Developers
Data Entry Clerks

Browse Similar Showcases

Excel
JavaScript
Data Entry
Data Processing
Previous User Next User
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Freelancer logo Singapore / English Help & Support Freelancer Categories Projects Contests Freelancers Enterprise Membership Preferred Freelancer Program Project Management Local Jobs Photo Anywhere Showcase API for Developers Get Verified Desktop App About About us How it Works Security Investor Sitemap Stories News Team Awards Press Releases Careers Terms Privacy Policy Terms and Conditions Copyright Policy Code of Conduct Fees and Charges Partners Escrow.com Loadshift Warrior Forum Apps Apple App Store logoGoogle Play logo
Copy to clipboard failed, please try again after adjusting your permissions.
Copied to clipboard.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.