Find Jobs
Hire Freelancers

Googlesheets Project which pulls and merge data from 2 sheets

$30-250 SGD

Closed
Posted about 6 years ago

$30-250 SGD

Paid on delivery
Goal is to create a google sheet and custom report that joins data from 2 google sheets. Each month need to verify the work hours/ot/allowances for employees. There are 2 sources of data google sheets (WorkLog & Justlogin Log). The goal is to review help automate a process we carry out every 23rd of the month. Step 1: Generate Monthly Labor Report - pulls data from 2 existing google spreadsheets. Grouped by Project, Shows: - Fields from WorkLog: Name, Date, Start Time, End Time, Public/Rest, Notes, TYPE, Total Hours, Lunch, Dinner, Hours Worked, Normal, OT-1.5, OT-2.0, Meal Allowance - Fields from JustLoginLog: Start Time, End Time - End Time is calculated by taking the out time, If nothing in 2nd out/3rd out/4th Out - use 1st out 2nd Out time The date and name of worker is the data that would link the 2 google sheets. Date and worker name as lookup to join to worksheets Highlight discrepancies - Conditional formatting Monthly Report Sent to PMs for verification - By close of business 23rd 12pm PM to verify by 25th 10am Confirm the overtime PM Update any changes to Work Log PM to highlight any changes required in just login Second Report Generate Monthly OT & Allowance Labour Report grouped by Staff Name Fields to show: Name, Date, Start Time, End Time, Normal, OT-1.5, OT-2.0, Meal Allowance Only records shown as those which have OT or Meal Allowance.
Project ID: 16535857

About the project

21 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
21 freelancers are bidding on average $155 SGD for this job
User Avatar
Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can do the best google sheets merging and reporting project in the least time starting right now. I will do all and extra to ensure that you won't regret giving me this project. Please, message me and let us discuss more about your project. Thanks
$100 SGD in 3 days
4.9 (42 reviews)
4.7
4.7
User Avatar
Self-motivated, positive and enthusiastic • Excellent communication skills and easy to work with • A strong attention to detail and highly organised • Computer literate and proficient with mainstream software suites/system I can help with: - Data entry / input - Data collection - Data validation - Data cleaning - Online research - Transcription I provide a prompt, efficient and accurate service and am available for all kinds of tasks, no matter how big or small. I would be keen to discuss any projects you may require assistance with. I hope to hear from you soon. Kind regards,
$155 SGD in 3 days
5.0 (20 reviews)
3.9
3.9
User Avatar
I'm honest with my work and I have a good grip on Excel and Google docs, can automate reports by the help of formula and functions. Can complete tasks on estimated time mentioned by client, also will not demand to pay for extra hours (if I'll sped extra time on projects).
$111 SGD in 3 days
5.0 (1 review)
2.0
2.0
User Avatar
Hello, I can do this project for you. I have completed this type of project recently. So , It will be easy for me to complete this task. I have more than 2 years of experience in google sheets, google apps script and API. If you are interested, Please contact me ,So I can finish it as soon as possible. Waiting for your response. Thanks in advance.
$150 SGD in 2 days
5.0 (2 reviews)
1.7
1.7
User Avatar
We have a experience in excel spreadsheets. As per your requirement we will work 2 spreadsheets to give analyzed data.
$100 SGD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$222 SGD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hello If you're willing to give your precious work & time to a person, who is completely dedicated to his work, then I would say you've found the right guy. I can completely help you throughout the particular work you're giving Me. One thing i can assure you that I'll not let you down at any cost. you'll get what you are desiring. Completion of a work is all about trust and faith between the owner and worker. If you're giving me the work you'll be totally satisfied. thank you
$155 SGD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Can be done perfectly as per your need. Please provide me more details in PM. Thanks for your time, Abrar Bin Fazal
$36 SGD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi good day I am achad working individual who is willing to show you what
$155 SGD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have a lot of experience for google sheets works. we provide the quality work. contacts with us for detailed disscussion.
$155 SGD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Dear Accurate, fast keying skills and sound knowledge of computer applications. Proven ability to collect and manage information efficiently and accurately. Excellent written skills and a strong desire to work hard and perform well. Skilled in planning and organizing with the ability to complete tasks on deadline. An independent worker who successfully meets the challenges of a fast-paced environment providing data entry and administrative support . Sound knowledge of database management tools and data entry technologies. My name is Marouan from Morocco, Thanks for your time.
$155 SGD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have made many monthly reconciliation reports but of different format though I have keen knowledge of merging data and all.. Still I need more clearance on what is your requirement.
$166 SGD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I run a startup so I manage my team using a similar tool which I built using Gdocs. Can complete this task in 2 Days.
$222 SGD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I've been working as a data entry agent for almost 3 years now. as well as a customer support specialist in both inbound and outbound accounts (US). I work as a verification agent for workers compensation claims in California, calling insurance carriers to gather patients information and collate all the information in the excel sheet. I also work for Movylo as a Customer care specialist, data entry and lead generation/lead scraping in the web.
$222 SGD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SINGAPORE
Singapore, Singapore
0.0
0
Payment method verified
Member since Mar 10, 2017

Client Verification

Other jobs from this client

ReconfigureCiscoUCS
$250-750 SGD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
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.