Find Jobs
Hire Freelancers

I need a google sheets expert

₹1500-12500 INR

Closed
Posted over 2 years ago

₹1500-12500 INR

Paid on delivery
We have a cricket club comprising of some friends. I want to simplify how we maintain our attendance cum fine register. some details are as follows: Total Number of members: 25 to 28 We play weekly once on Wednesday, from 10 PM to 12 PM. We take attendance on Monday from 1 PM on our whatsapp group. The first sixteen who reply yes get to play. In order to maintain discipline we have formed certain rules and fines: 1. If a person doesnt report before 9.55 PM he has to pay a fine or Rs. 100. 2. If a person says yes and then say no or doesnt turn up, then he has to pay Rs. 300. 3. If the total number of players is less then 16 on ground, the remaining players have to pay a fine of Rs. 100 4. If a person doesnt wear the team t-shirt, he has to pay a fine of Rs. 100 5. If the total number of players playing is less than 16, that group fund will contribute Rs. 1000/- towards total expenses. 6. If a person doesnt come for consecutive 3 weeks, he has to pay a fine of Rs. 1000/- Requirements: 1. i want to use a google form to take attendance on monday afternoon. 2. another google form is needed to take attendance on the playing day, which is wednesday, this form should also let admin enter details like, late fine, no t-shirt, person who has backed off. 3. the sheet should automatically calculate fine as per above set rules. 4. there should be 2 levels of control, once is admin, second is assitant. 5. admin has full control 6. assitant can issue form on Monday to take the count, and he can then take attendance on Wednesday. I have given more or less all the details, if you think that a small app can be more efficient than google sheets, you are free to advice. Thank you
Project ID: 32299357

About the project

16 proposals
Remote project
Active 2 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average ₹7,902 INR for this job
User Avatar
Hello, Utilizing my expertise in google forms and google sheets and all relevant techniques such as usage of advanced formulas, I will create the tool as described on this job post. Please revert to discuss further in order to finalize ASAP. Look forward to work together soon. Thanks, Devashish
₹7,400 INR in 2 days
5.0 (27 reviews)
6.7
6.7
User Avatar
Hi There, I have understood your requirement for Google Form development with automation in calculation With combination of forms and sheets, we can establish 100% automated procedure as you mentioned I have done many projects in Google Sheet automation Please contact me for further discussions Thanks & Regards,
₹15,000 INR in 4 days
5.0 (37 reviews)
5.2
5.2
User Avatar
Hello... I read your project description. I am interested in your project. I understand your project very clearly. I am expert in this field. Send me message and let's discuss further. Thanks
₹3,000 INR in 2 days
4.9 (5 reviews)
2.8
2.8
User Avatar
hi my name is Ganesh i am android developer i had developed many android apps i had seen your requirement. I can give you better results as per your requirement.
₹20,000 INR in 5 days
4.8 (3 reviews)
2.8
2.8
User Avatar
Hi there, I am an experienced Software Engineer with more than three years of experience. I can develop a robust solution for you that can manage your club members, track attendance and charge penalties accordingly. Here's a proposal for you to consider instead of Google App Script: 1. A desktop Electron application that you can install on your computer and it can manage all your data 2. Add, remove and edit member details 3. Gather attendance data from Google Sheets (attendance via Google Form as you wanted) 4. Fine calculation if rules are broken 5. Email notification when user is added and when fines are accrued The application will also offer an export option that will export the data in excel sheets. Let me know what you think of my proposal. Thanks for your time and consideration.
₹10,000 INR in 7 days
5.0 (3 reviews)
2.3
2.3
User Avatar
I AM A GOOD DATA ENTRY EXPERT ,I am able to do your project you can beleve me i am so much excited to compelete your project
₹7,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am an expert in Data Entry with good command over eccel and Google sheets. Let's connect for a wonderful experience and hassale free project delivery
₹5,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I can able to do this work. I have very good knowledge in spreadsheet. I understand the the project proposal. If you give me I will finish it in a week
₹7,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Before joining this platform, I'm working for a local firm where I am doing such work excellently. Thanks
₹1,800 INR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Sir, that is the good question you asked me, If you will give me opportunity to work in your company at this post I think that, by using my skills and knowledge I will play an important role in the upliftment of your company and I will prove it. I am quick learner and very honest with my work surely Sir, one day you will feel proud for appointing me here
₹7,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Greetings! For this job, what you will get when you hire me? 1. Fast results 2. Detail-oriented workmanship 3. Excellent organizational skills 4. Highly proficient in e-mail handling, typing, and transcription 5. Strong Microsoft Office skills (Word, Excel, PowerPoint, Outlook) I'm new here in Freelance but I've done some works outside the platform. Please consider me for this job and you will not regret it. I'm looking forward to working with you. Thanks! Cheers, Loren
₹7,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I have worked with google forms and google sheets for making quiz and feedback and also surfed with all the features over there so I can be sure that I can make your work done properly.
₹7,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! This seems rather doable, I'd suggest you'd use Google sheets to complete this task as through sheets your data will be far more acsessable, primarily for assistants. In my free time I do things of very similar topics! Primarily in google sheet data sheets focused around large groups and collecting data. This will not be too difficult. Will you primarily be using a phone or computer for data management? I can make the sheet further availible for whichever you would prefer.
₹3,120 INR in 14 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Mumbai, India
0.0
0
Member since Jun 28, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.