We are looking for someone who can work with a couple of google sheets and create custom reports.
What we have:
- Google sheet data updated by 6-10 people everyday using Google Forms. It has details about the employee email id, projects(using drop down) they have worked and number of hours they spent on that project that day.
- Same google sheet data as above filled using same google forms as above by same employees - but they also use it to mark their login time and logout time
- A separate google sheet where we enter Per hour cost of each employee - along with their email id.
Reports we want:
- Use data from google form linked google sheet.
- Add some filters (from date, to date), Project drop down, Employee drop down (multi select)
- Calculate the costs per project (with all employees) or calculate the cost per project basis on the selected employees)
- ANOTHER REPORT for attendance - Consolidate login and logout time and show that in one row, calculate the time spent in hours each day, and calculate the total working days between a date range (from date, to date)
- Automated triggers
---Trigger an email if the employee login is not logged-in for any weekday (monday to friday) by 11am.
--- Trigger an email if the employee login is not Logged-out for any weekday (monday to friday) by 9 pm - no email trigger if the log-in was not marked for that day.
Please let me know your experience with google sheets and custom reporting so it helps me shortlist.
Bu iş için 24 freelancer ortalamada $134 teklif veriyor
I have read your project description and think I can help. Let’s chat in more detail about your project needs. Waiting for your good response. Let me know the more details the project.®
Hi, We have extensive experience in video editing, Graphic design, Web Development, Animation , Illustration and every type of Marketing. I have completely seen your project description regarding “ Google Sheets - Daha Fazla
Hello, i have gone through your project description and i can assure you that i am qualified for the project. I have done many data entry tasks inluding copying data froma website and entering to a database, researchin Daha Fazla
Good day Ma'am/ Sir, I am Maristein Joy Salva, an incoming 4th year college taking up a course of BS Entrepreneurship. I have been creating study notes and other projects such as editing text and data encoding, conver Daha Fazla