Google Sheets Expert To Create Formula For Data Collection
- or -
Post a project like this$$
- Posted:
- Proposals: 5
- Remote
- #2028171
- Expired
Description
Experience Level: Intermediate
Hi,
I am an online coach offering nutrition and training programmes online.
I am looking to create a way of collecting data on google sheets to make the process easier for my clients, and for me to give weekly feedback on their numbers without having to manually go through their food diaries.
Each client would receive a link with no information in it, just the relevant tables which would hold all over their data. I would need this to have the capability to hold a years worth of data minimum. They would then input the relevant information and the table would reflect the appropriate changes. E.f If the goal was for them to eat 100g of protein it would say 20g remaining if they put their total in as 80 for the day.
I would like the document to do the following
- Space to Record Date
- Space to Record Daily Weight ( they input this information)
- Space to give clients their targets at top
- Space to Record Daily Macros and give me the daily calorie based off that (Macros- protein, fat, carbs, fiber) (and give me totals for the day and for the week)
- Record Daily Cardio (and give me a total for the week)
- Record Daily Steps (and give me a total for the week)
- Record Daily amount of sleep and weekly amount
- Show the different in KG between 1st day weigh in and end of week weigh in (Monday-Sunday)
- Show a weekly remaining for all data categories
- Comments box next to the days data for them to input any notes
- Every Four weeks, a box to collect their body measurements
- A link next to the weeks entries to a weekly check in form (I will make the form and provide the link, i just need the space created)
- A box at the bottom of the weeks data for me to provide any comments/changes
- A graph showing the timeline of their weightloss
I have already got 2 examples on google sheets of a similar process that you can use as a reference.
Thanks!
I am an online coach offering nutrition and training programmes online.
I am looking to create a way of collecting data on google sheets to make the process easier for my clients, and for me to give weekly feedback on their numbers without having to manually go through their food diaries.
Each client would receive a link with no information in it, just the relevant tables which would hold all over their data. I would need this to have the capability to hold a years worth of data minimum. They would then input the relevant information and the table would reflect the appropriate changes. E.f If the goal was for them to eat 100g of protein it would say 20g remaining if they put their total in as 80 for the day.
I would like the document to do the following
- Space to Record Date
- Space to Record Daily Weight ( they input this information)
- Space to give clients their targets at top
- Space to Record Daily Macros and give me the daily calorie based off that (Macros- protein, fat, carbs, fiber) (and give me totals for the day and for the week)
- Record Daily Cardio (and give me a total for the week)
- Record Daily Steps (and give me a total for the week)
- Record Daily amount of sleep and weekly amount
- Show the different in KG between 1st day weigh in and end of week weigh in (Monday-Sunday)
- Show a weekly remaining for all data categories
- Comments box next to the days data for them to input any notes
- Every Four weeks, a box to collect their body measurements
- A link next to the weeks entries to a weekly check in form (I will make the form and provide the link, i just need the space created)
- A box at the bottom of the weeks data for me to provide any comments/changes
- A graph showing the timeline of their weightloss
I have already got 2 examples on google sheets of a similar process that you can use as a reference.
Thanks!
Alma W.
100% (10)Projects Completed
14
Freelancers worked with
11
Projects awarded
30%
Last project
3 Nov 2019
Spain
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Can you share the references.
650929
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies