Google Sheets - Custom report generation


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.

Taidot: Excel, Tietojenkäsittely, JavaScript, Google Sheets

Näytä lisää: google analytics custom report track conversions hour, civicrm custom report generation, google analytics custom report for specific pages, google sheets custom functions, google analytics custom report limit, google sheets custom menu, google sheets custom number format, google analytics custom report funnel, google sheets custom function not updating, google sheets custom function, google analytics custom report date range, google analytics custom report landing page, google analytics custom report filter or, google sheets custom function examples, google analytics custom report filters, google sheets custom formula examples, google sheets custom formula, google sheets custom sort order, custom report generation, google sheets custom color palette

Tietoa työnantajasta:
( 45 arvostelua ) Delhi, India

Projektin tunnus: #31510416

24 freelanceria on tarjonnut keskimäärin $134 tähän työhön

(132 arvostelua)

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 Lisää

$250 USD 7 päivässä
(116 arvostelua)

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 Lisää

$170 USD 3 päivässä
(15 arvostelua)
(32 arvostelua)

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 Lisää

$150 USD 2 päivässä
(13 arvostelua)

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 Lisää

$170 USD 4 päivässä
(11 arvostelua)

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 Lisää

$200 USD 7 päivässä
(3 arvostelua)

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 Lisää

$150 USD 7 päivässä
(6 arvostelua)

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.®

$30 USD 1 päivässä
(4 arvostelua)

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 Lisää

$150 USD 5 päivässä
(4 arvostelua)

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 Lisää

$30 USD 5 päivässä
(1 arvostelu)

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 Lisää

$100 USD 3 päivässä
(1 arvostelu)

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 - Lisää

$30 USD 1 päivässä
(0 arvostelua)

• 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 Lisää

$140 USD 2 päivässä
(0 arvostelua)

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.

$140 USD 7 päivässä
(0 arvostelua)

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 Lisää

$30 USD 1 päivässä
(0 arvostelua)

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 Lisää

$140 USD 5 päivässä
(1 arvostelu)

Dear valuable client, This is Oanh from Vietnam. I have experience of tracking data and making report through Google Sheet. If you need any similar file like this: [login to view URL] Lisää

$230 USD 7 päivässä
(0 arvostelua)
(0 arvostelua)

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 Lisää

$30 USD 1 päivässä
(0 arvostelua)