Google Sheets - Custom report generation
Budget: $30 – $250 USD
Hello,
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.
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.