Advanced Google Sheets Dietary Macro-Alternatives
Budget: £10 – £20 GBP
I am in need of a Google Sheets specialist able to deliver quickly. I have a fitness brand and require the application of complex formulae to perform the following tasks:
- I have a database which when I select a food it gives me the macros depending what grams I input.
- I want to Enable the calculations to propose different food alternatives with the same macro attributes to automatically adjust so I can give other options (i.e., equivalent quantities of rice and potato)(i.e., equivalent quantities of chicken and mince). not exact but give or take 10% Kcal
- Maintain the fundamentals of data validation rules and conditional formatting rules throughout the sheet.
The ideal freelancer should be highly competent in Google Sheets functions and have experience with nutritional database handling. Knowledge in dietary macros would be an additional advantage. Punctuality is a must, as the project requires immediate attention.
- I have a database which when I select a food it gives me the macros depending what grams I input.
- I want to Enable the calculations to propose different food alternatives with the same macro attributes to automatically adjust so I can give other options (i.e., equivalent quantities of rice and potato)(i.e., equivalent quantities of chicken and mince). not exact but give or take 10% Kcal
- Maintain the fundamentals of data validation rules and conditional formatting rules throughout the sheet.
The ideal freelancer should be highly competent in Google Sheets functions and have experience with nutritional database handling. Knowledge in dietary macros would be an additional advantage. Punctuality is a must, as the project requires immediate attention.