I was unsuccessfully looking for a perfect App for calories counting, where you can put your ingridients and stuff, and this is it. You´re the life saver. Thank you.
Dang man thanks for going through the actual process of creating the spreadsheet. Came here looking for a quick solution, ended up leaving with learning some new functions!
Hey man, i really think more people need to know about this. I have used this to lose over 45kg. Absolutely mad props. My fitness pal and apps like it make it clunky to switch to different foods, this suits me absolutely perfect so honestly thank you! Just a quick question, how do i add more foods than 50 to the database?
Hey, nice results! I just checked the formulas and it's set up to do roughly 500 rows, so it's just a case of writing in the new values in the food database underneath the last row. I can't remember why I highlighted them green but it has no functional purpose
I'm having a hard time with getting the vlookup formula to cooperate. I can't wait to get this working and start tracking my macros properly. Thank you for making this and sharing it!
Okay so kind of a dumb question cause I don't use excel. What do you do on day 2 and week 2? Just delete the stuff daily or do you make a new copy everyday?
Thank you so much for this, I've learned so much on Sheets now because of the tinkering I've done with your sheet. I use it everyday for macro's, do you have Patreon or another way I can send money, this is a big part of my life and want to thank you.
Thank you so much for this spreadsheet and tutorial! One question- when you want to start logging a new day, how would you do that? Do you copy the rows and add more above?
It's set up so that you would copy the totals for that day and paste them somewhere else, then delete all the entries and start again. If you were interested in keeping a full record of each day I'd probably: - Create a new sheet - highlight the info from the day you've just filled in and copy it - in the new sheet use Ctrl-Shift-V to copy the values from that day, leaving the original untouched It can get quite messy if you start copying and pasting formulas so it's best to leave the original sheet intact and copy the values to another sheet. Hope that makes sense!
@@9to5strength Wow, that is such a helpful tip. I've been doing it manually the past three months- selecting and adding 50 rows above, copy and pasting the formulas, individually deleting all of the ingredients and portion sizes, retyping the date, and it has become quite messy/tedious. Since I still want to have an overall look at how my macros have been (and kind of check the specifics of the day by using a dropdown, maybe grouping the rows), do you think I should have a separate sheet with just the daily totals? Or could that somehow be all on one? Not sure if my question is clear, but I appreciate your help. You're really a lifesaver.
This is amazing, thanks but does anyone know how to make a formula when you add to the "food database" for example 100g and it automatically generates a portion in the "food diary sheet" 100=1 portion so if we do that it would calculate rest aswell if I add 150g it would directly add 1,5 portion and do the math for rest of macros. Any ideas for a formula like this?
Thank you so much! I was trying to make something similar for some time now, and this is a lifesaver! I have a question. If I want to set a goal of not a fixed amount of intake but an interval, lets say not 150g Protein a day but anything between 130-160g is good, how can I adjust that in the counter?
The Target cell is just a reference, so instead of writing 150g you could just write 130-160 as a reminder to yourself. I also prefer to work with a range so I don't get too obsessed about finding the perfect meal to fit my macros for the day/week
For ranges i like to use conditional highlighting with colors red orange green, 145 being the average of your range in green and 130 and 160 the extremes low and high in red
Amazing work. Thank you so much. I have been wanting to let go of services like MFP for a while now and I think it's really possible thanks to your tracker. I am curious about one thing and maybe you can help me figure it out: why is it that, in most of the nutrition information labels, the calorie/100g value from the label is higher compared to the value we have in your tracker if we just do the function: 4xprot + 4xcarbs + 9xfat?
I believe there are slightly more precise methods of calculating total kcal, but also some of them don't count insoluble fibre because it passes through your system.
I figured it out. You insert the columns and then you make the formula this (if you added fiber after fat) =IF(D3 > 0,D3*VLOOKUP(B3,'Food Database'!$A$3:$G$500,6, False),0)
@@anitabarry9278 It has been a long time since I did this. I think I just inserted a column and filled it out like all the others. What problem are you running into?
@@yeeoldeseabass ahh right ok, I appreciate your response! I've just inserted another column but idk how to input the right formula into the column. Essentially the calories aren't totalling up so I'm having to manually type it in.
@@anitabarry9278 I am going to assume you mean the calories in the diary since the database will still use same formula. In the diary since you changed the calories to column 7 you have to make the 6 before , False),0) 7.
![[Live] : ONE FIGHT NIGHT 25 วันนี้!! "อเล็กซิส vs รีเกียน"](http://i.ytimg.com/vi/suVr9a6BM2g/mqdefault.jpg)
This is exactly what I was trying to create for the last 2 days! Thanks mate!
I was unsuccessfully looking for a perfect App for calories counting, where you can put your ingridients and stuff, and this is it. You´re the life saver. Thank you.
Dang man thanks for going through the actual process of creating the spreadsheet. Came here looking for a quick solution, ended up leaving with learning some new functions!
Found this shortly after your first video and this has been massively helpful. Many thanks. :)
I learned so much from this video. Thank you so much! Now I can loose weight and get better on my spreadsheet creations. You rock!
I searched for this a few hours.. finally damn
thank you so much! so useful !! you saved me a LOT of time, was gonna try to figure out how to do this from scratch and I found your video ! 🙏🏽
Very generous of you, thanks so much.
You've gained a new subscriber, thank you for making that tool and sharing it!
Dude, you're amazing. Thank you very much.
god bless u u saved my life
God bless you.
Thank you for your help, it was a a great tutorial.
Hey man, i really think more people need to know about this. I have used this to lose over 45kg. Absolutely mad props. My fitness pal and apps like it make it clunky to switch to different foods, this suits me absolutely perfect so honestly thank you!
Just a quick question, how do i add more foods than 50 to the database?
Hey, nice results! I just checked the formulas and it's set up to do roughly 500 rows, so it's just a case of writing in the new values in the food database underneath the last row. I can't remember why I highlighted them green but it has no functional purpose
I'm having a hard time with getting the vlookup formula to cooperate. I can't wait to get this working and start tracking my macros properly. Thank you for making this and sharing it!
Got that working - and now I'm stuck with the portion formula not cooperating. I'll get that right soon. Can't wait!
Amazing. Thank you so much that was very very helpful
You're my fucking hero.
I love you! This is amazing!
incredible stuff
Hey man thank you so much for this excelent content bro keep it up!
thanks so much for the template, it's very helpful :)
Thank you so much for this!
Thanks
SO GRATEFUL
Thank you so much!
Okay so kind of a dumb question cause I don't use excel. What do you do on day 2 and week 2? Just delete the stuff daily or do you make a new copy everyday?
ty bro ur awesome
Thank you so much for this, I've learned so much on Sheets now because of the tinkering I've done with your sheet. I use it everyday for macro's, do you have Patreon or another way I can send money, this is a big part of my life and want to thank you.
Comments are enough, I'm glad it's helped you that's why I do all this :-)
Thank you so much for this spreadsheet and tutorial! One question- when you want to start logging a new day, how would you do that? Do you copy the rows and add more above?
It's set up so that you would copy the totals for that day and paste them somewhere else, then delete all the entries and start again. If you were interested in keeping a full record of each day I'd probably:
- Create a new sheet
- highlight the info from the day you've just filled in and copy it
- in the new sheet use Ctrl-Shift-V to copy the values from that day, leaving the original untouched
It can get quite messy if you start copying and pasting formulas so it's best to leave the original sheet intact and copy the values to another sheet. Hope that makes sense!
@@9to5strength Wow, that is such a helpful tip. I've been doing it manually the past three months- selecting and adding 50 rows above, copy and pasting the formulas, individually deleting all of the ingredients and portion sizes, retyping the date, and it has become quite messy/tedious.
Since I still want to have an overall look at how my macros have been (and kind of check the specifics of the day by using a dropdown, maybe grouping the rows), do you think I should have a separate sheet with just the daily totals? Or could that somehow be all on one?
Not sure if my question is clear, but I appreciate your help. You're really a lifesaver.
Anyone know how to clear a drop down menu item without messing up the formula Please?
This is amazing, thanks but does anyone know how to make a formula when you add to the "food database" for example 100g and it automatically generates a portion in the "food diary sheet" 100=1 portion so if we do that it would calculate rest aswell if I add 150g it would directly add 1,5 portion and do the math for rest of macros. Any ideas for a formula like this?
Thank you so much! I was trying to make something similar for some time now, and this is a lifesaver!
I have a question. If I want to set a goal of not a fixed amount of intake but an interval, lets say not 150g Protein a day but anything between 130-160g is good, how can I adjust that in the counter?
The Target cell is just a reference, so instead of writing 150g you could just write 130-160 as a reminder to yourself. I also prefer to work with a range so I don't get too obsessed about finding the perfect meal to fit my macros for the day/week
For ranges i like to use conditional highlighting with colors red orange green, 145 being the average of your range in green and 130 and 160 the extremes low and high in red
This is how you get 0 dislikes. Thank you
Amazing work. Thank you so much. I have been wanting to let go of services like MFP for a while now and I think it's really possible thanks to your tracker.
I am curious about one thing and maybe you can help me figure it out: why is it that, in most of the nutrition information labels, the calorie/100g value from the label is higher compared to the value we have in your tracker if we just do the function: 4xprot + 4xcarbs + 9xfat?
I believe there are slightly more precise methods of calculating total kcal, but also some of them don't count insoluble fibre because it passes through your system.
Is this possible on Numbers for a Mac? NEED DESPERATELY!
I don't know what compatibility Numbers has but you could try downloading the sheet and seeing if it will convert to a Numbers file
What would I have to do to add a cell for fiber?
I figured it out. You insert the columns and then you make the formula this (if you added fiber after fat)
=IF(D3 > 0,D3*VLOOKUP(B3,'Food Database'!$A$3:$G$500,6, False),0)
@@yeeoldeseabass exactly what I was looking for! How did you enter a fibre column on the food database?
@@anitabarry9278 It has been a long time since I did this. I think I just inserted a column and filled it out like all the others. What problem are you running into?
@@yeeoldeseabass ahh right ok, I appreciate your response! I've just inserted another column but idk how to input the right formula into the column. Essentially the calories aren't totalling up so I'm having to manually type it in.
@@anitabarry9278 I am going to assume you mean the calories in the diary since the database will still use same formula. In the diary since you changed the calories to column 7 you have to make the 6 before , False),0) 7.