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.
24 freelances font une offre moyenne de 134 $ pour ce travail
Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel and Google Sheets. These are scr Plus
Hi greetings from Tushar!! I am interested in taking up your project of creating a custom report for your google forms collected employee data. I have hands on experience of working with google app script, google s Plus
Hello, I Have 5 years of experience in google sheets/excel and 2 years of experience in google apps script. I've read your requirements and I can fulfill them for you, no upfront payment required, free maintenance afte Plus
I have completed a very similar project in a company. It is part of the Human Resource Management system I developed in Google Sheets. I have 7 years experience with Google Sheets. Pl see my reviews. Please read about Plus
HI This is Dilip Natarajan here An expert in Google sheet and Apps script -> have done many similar kind of project I can deliver your requirement with in 7 days and for upgrade -> i can even build a webApp which y Plus
Dear Employer, I have done many similar projects recently with Google App Scripts and Google sheets, I have more than 6 year of experience with data analyzing and spreadsheets so I am capable enough to deliver the requ Plus
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 myself Avnish Tomar and i have 5+ years experience in full stack development. As you mentioned in your requirements you need a panel where you get all details(reports) of employees and email if condition given by yo Plus
Hello, I'm a modeling and simulation engineer and I have used excel/google sheets and VBA/App script. The past projects that I have completed. - Created a google sheet that can fetch stock data using google finance a Plus
Hello! I am an experienced Google sheets and Google forms expert who specializes in Data processing. I can get you those reports and triggers accurately. I am reliable, committed to work and detail oriented, and will m Plus
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 - Plus
• DW Solution Online is providing Search Engine Optimization(SEO) Services. We at DW Solution Online having certified and technical SEO leaders that do have cognitive and familiarizes with the on-going and coming marke Plus
I am here to ready to work on your project I am good at excel,PDF and ms word typing I will wait for your response thanks.
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 Plus
I am Qualified Advance Excel MS word and power BI, courses and vast experience in multiple organization. in these organization i was Finance Head, responsible in Financial auditor, i could help you to complete your pr Plus
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 Plus