I need a google sheets expert

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/-


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

Skills: Excel, Google Sheets, Data Processing, Mobile App Development

See more: need google api expert, need google adwords expert, i have an excel spreadsheet that needs some final touches to be ready i need an absolute expert at working an excel, i need a facebook expert uk, i need a lightroom expert in the uk, i need a numbers expert, i need a photoshop expert, i need a wamp expert, i need a wordpress expert, i need an excel expert to come to my office, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s, i need an excel expert, I need an SEO expert, i need google adsense, i want to develop a cricket club web site, i need google earth, i need a facebook expert, i need a facebook expert to help, i need a marketing expert, i need a marketing expert to promote my product

About the Employer:
( 0 reviews ) Mumbai, India

Project ID: #32299357

17 freelancers are bidding on average ₹8025 for this job


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 More

₹7400 INR in 2 days
(24 Reviews)

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 man More

₹15000 INR in 4 days
(28 Reviews)

I am an engineer with a lot of experience in the manufacturing industry. I have been developing systems from the ground up in Google Sheets for the last 7 years. You can read about the complete Human Resource Manage More

₹5000 INR in 3 days
(14 Reviews)

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

₹3000 INR in 2 days
(5 Reviews)

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.

₹20000 INR in 5 days
(3 Reviews)

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. H More

₹10000 INR in 7 days
(3 Reviews)

Hello there, Besides your requirements, we could have it automatically fire emails, containing the list of players confirmed before the game, emails to the individuals who have not paid and any other type of reporting More

₹10000 INR in 3 days
(1 Review)

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

₹7000 INR in 7 days
(0 Reviews)

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

₹5000 INR in 7 days
(0 Reviews)

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

₹7000 INR in 7 days
(0 Reviews)

i am data entry operator and your work completed in four days and you are happy in my [login to view URL] give me a [login to view URL] sir/madam.

₹11111 INR in 4 days
(0 Reviews)

Before joining this platform, I'm working for a local firm where I am doing such work excellently. Thanks

₹1800 INR in 3 days
(0 Reviews)

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 c More

₹7000 INR in 7 days
(0 Reviews)

Dear sir , I am happy to let you know that I am looking forward to work with you. I am good in writing, reading and speaking skills. So it will be more easy for me to complete your work within stipula More

₹10000 INR in 3 days
(0 Reviews)

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. Stro More

₹7000 INR in 7 days
(0 Reviews)

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.

₹7000 INR in 7 days
(0 Reviews)

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 More

₹3120 INR in 14 days
(0 Reviews)