Find Jobs
Hire Freelancers

Google Sheets - Custom report generation

$30-250 USD

Lezárt
Kiadva ekkor: több mint 2 évvel ezelőtt

$30-250 USD

Teljesítéskor fizetve
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.
Projektazonosító: 31510416

A projektről

24 ajánlat
Távolról teljesíthető projekt
Aktiválva: 2 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
24 szabadúszó adott átlagosan $134 USD összegű árajánlatot erre a munkára
Felhasználó avatár
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 screenshots of some of my works.
$250 USD 7 napon belül
4,9 (116 értékelés)
6,4
6,4
Felhasználó avatár
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 sheet, API's and google forms and have done few projects previously using google app scripts and google sheet functions and so I believe I can surely help you as well. Also previously I have done a similar project where I have written a logic using google app script to send automated email on google sheet data change/update. Let's connect over chat to discuss further on this. Looking forward to hear from you. Thank you.
$170 USD 3 napon belül
5,0 (15 értékelés)
4,8
4,8
Felhasználó avatár
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 after project delivery and I can work for you on further projects after this one as I am trying to build strong long term relations with my clients. I can produce all the reports you need and filter data by dates and I can send automated E-mails by the trigger you want so please contact me, I can start working now, can probably finish in less than 2 days too.
$150 USD 2 napon belül
5,0 (13 értékelés)
3,8
3,8
Felhasználó avatár
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 you use instead of form: where this is much dynamic we can integrate approval mechanism , invoice creation with email trigger etc Let me know if interested , lets discus.
$200 USD 7 napon belül
5,0 (3 értékelés)
3,2
3,2
Felhasználó avatár
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 required product. So I am looking forward to discuss more details. I can start the work right now, then we have more than enough time to do the bug fixing and final touchups. You can check my profile for more details and feel free to contact me anytime. Thank you
$150 USD 7 napon belül
5,0 (6 értékelés)
3,0
3,0
Felhasználó avatár
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 napon belül
5,0 (4 értékelés)
2,6
2,6
Felhasználó avatár
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 you became true. I am able to do the whole things fetching data from google sheets prepare it for reports and apply formula for salary and finally dipatch email to employee. We can discuss further about it as well. You can check my portfolio for better understanding about my jobs. I hope you consider me for this job :-) Thanks
$150 USD 5 napon belül
5,0 (4 értékelés)
1,8
1,8
Felhasználó avatár
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 and calculate derived parameters. I would be able to generate the reports and trigger emails as per your requirement. Thank you.
$30 USD 5 napon belül
5,0 (1 értékelés)
1,8
1,8
Felhasználó avatár
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 make sure your task is done perfectly, timely and error-free. Kindly give me a chance to prove myself!
$100 USD 3 napon belül
5,0 (1 értékelés)
1,4
1,4
Felhasználó avatár
• 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 market possibilities which can reflect your business for good result. With our competitive cost Search Engine Optimization (SEO) services you can get a large bunch of profits at a very small investment. Along with SEO we do care about how we can influence your smart business with our SEM services, SMO services, branding services and much more.
$140 USD 2 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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, researching for specific information and many more. Kindly contact me so that we can discuss more on your project. Thank you
$30 USD 1 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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 project.
$140 USD 5 napon belül
5,0 (1 értékelés)
0,0
0,0
Felhasználó avatár
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, converting pdfs into word and many other things. and I have been doing this kind of works for more than 5 years being a student. It is one of the requirements, reporting, and projects we do in school and I also accept some commission as my part-time job as a student. I always bring out the best results and I don't stop working until my client is 100% satisfied. I am willing to work for more than 50 hours per week for your project as soon as you hire me. I agree with your job price and all other terms. Please free to contact me on e-mail if you have any questions. I hope that I will be hired for your project as I'm the best one for this job. Looking forward to hearing from you. Sincerely, Maristein Joy C. Salva Applicant
$30 USD 1 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hi, I can work with google sheets and create custom reports right now with 100% accuracy. If you need any sample please let me know. Thanks! I am an expert in Data Entry, JavaScript , google sheets, PDF, Word, Copy Typing and I am really interested in your project. I am available to start working on it now. I work efficiently and will finish in a timely manner and will provide high quality work. I am waiting to your quick positive reply and if you have any questions, feel free to ask me
$70 USD 3 napon belül
5,0 (1 értékelés)
0,0
0,0
Felhasználó avatár
I have a prior experience of creating a similar tool for one of my client in while i am working in MNC. That tool worked mainly to find out how may FT's are aligned on a project and what's the budget we are running on. Your request is quite similar to it. I am confident enough to accomplish this project with perfection.
$180 USD 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I have a great typing skill with a good knowledge of computer . I am good management person . I am capable to complete the work before the time period .
$130 USD 6 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I have 3 years of work experience of Microsoft excel and Google Sheet, Google Apps Script but I am fresher on freelancer, I thing you give me a chance.
$180 USD 7 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

INDIA zászlója
Delhi, India
5,0
45
Fizetési mód hitelesítve
Tagság kezdete: aug. 4, 2008

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.