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.

Beceriler: Excel, Veri İşleme, JavaScript, Google Sheets

Daha fazlasını gör: 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

İşveren Hakkında:
( 44 değerlendirme ) Delhi, India

Proje NO: #31510416

Bu iş için 24 freelancer ortalamada $134 teklif veriyor

(132 Değerlendirme)

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 Daha Fazla

$250 USD in 7 gün içinde
(116 Değerlendirme)

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 Daha Fazla

$170 USD in 3 gün içinde
(15 Değerlendirme)
(32 Değerlendirme)

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 Daha Fazla

$150 USD in 2 gün içinde
(13 Değerlendirme)

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 Daha Fazla

$170 USD in 4 gün içinde
(11 Değerlendirme)

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 Daha Fazla

$200 USD in 7 gün içinde
(3 Değerlendirme)

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 Daha Fazla

$150 USD in 7 gün içinde
(6 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)

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 Daha Fazla

$150 USD in 5 gün içinde
(4 Değerlendirme)

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 Daha Fazla

$30 USD in 5 gün içinde
(1 Yorum)

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 Daha Fazla

$100 USD in 3 gün içinde
(1 Yorum)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

• 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 Daha Fazla

$140 USD in 2 gün içinde
(0 Değerlendirme)

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 in 7 gün içinde
(0 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

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 Daha Fazla

$140 USD in 5 gün içinde
(1 Yorum)

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] Daha Fazla

$230 USD in 7 gün içinde
(0 Değerlendirme)
(0 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)