How to create a Nutrition Calculator in Excel

Рет қаралды 37,140

Күн бұрын

Пікірлер

@mathewshackelford8037 7 ай бұрын

I have Microsoft® Excel® for Microsoft 365 MSO (Version 2404 Build 16.0.17531.20140) 64-bit but I cannot find the nutrition calculator in my data types drop down. Am I missing something?

@excelhighway3549 7 ай бұрын

Unfortunately Excel removed those data types. A workaround is to download data from online databases and save in the file + keep updating it.

@mathewshackelford8037 7 ай бұрын

@@excelhighway3549 that sucks. I'll stick with fitness pal at that point. That's for responding.

@kimberlyschroeder7821 3 ай бұрын

@@excelhighway3549 I'm so bummed about this! Is there a database for nutrition information that you can suggest?

@mennojelierse9407 13 күн бұрын

How can i make nutrilabels with this for food products?

@excelhighway3549 12 күн бұрын

You would need to add a sheet with a label design and you could use any lookup or filter function to extract the data dynamically per food selection.

@Iamlindagraham Жыл бұрын

This exactly what I've been looking for. Thank you so much!

@excelhighway3549 Жыл бұрын

You're very welcome!

@edwardchau5818 Жыл бұрын

How did you add the "Activities" and "Anatomy" data types to the Data tab?

@excelhighway3549 Жыл бұрын

Unfortunately Excel has removed the data types. I replaced this method with a database I downloaded online and saved to my file.

@edwardchau5818 Жыл бұрын

@@excelhighway3549 Can you provide a link to the database?

@reggie90009 2 жыл бұрын

This is exactly the project I'd like to work on. However, to my shock, I found out the Excel 2021 does NOT have the food data type built in. Do you know of a workaround?

@excelhighway3549 2 жыл бұрын

You could build the database yourself, it would be time consuming but that is a possible workaround.

@TheLoadedLongboard 6 ай бұрын

There's data available from the USDA called "SR Legacy Foods" It is a zip file with several related data sets. You can recreate this database, pretty much, using 4 data sets from that zip file. Nice video, I like how you thought about this problem.

@Momo33Egy 4 ай бұрын

Could you send to me downloadable link for this excel sheet to use it directly?

@excelhighway3549 4 ай бұрын

The file is available on m Patreon page: www.patreon.com/ExcelHighway

@greekfitness2811 2 жыл бұрын

This what im looking for to build my client meal plans. This looks so much easier than looking up each macro as I input their meal options. Can I use thos program to do that?

@excelhighway3549 2 жыл бұрын

Yes, it would be perfect for them.

@JuanMartinez-k7d Жыл бұрын

I do not have the "Food " Data Type. How do you add it?

@excelhighway3549 Жыл бұрын

Unfortunatly Excel removed the data type functionality. I downloaded a food database from MyFoodData.com into a static sheet. I pulled the info from that sheet . If needed, you can add / change the data.

@ANDREWGEN_ Жыл бұрын

How could I make this in google sheets. Any ideas of workaround?

@excelhighway3549 Жыл бұрын

The quickest way is to upload the excel to Google sheets. Most of the functionality will work. The missing parts can be added in sheets.

@ANDREWGEN_ Жыл бұрын

@@excelhighway3549 So i"d have to pay for an excel subscription, create my calculator, and then export to sheets? My whole goal is to avoid paying for anything here

@excelhighway3549 Жыл бұрын

@@ANDREWGEN_ you can follow the steps in the video and build the file on your own.

@hubertszefer4346 Жыл бұрын

Did you watch your video? I think since 5:00 you've seen something that is not visible in this video 🤔

@excelhighway3549 Жыл бұрын

Thanks I missed that :). In any case the data types feature has been removed by Excel. To bypass that I added a database of foods I pulled online.

@Thatfitnessdad Жыл бұрын

@@excelhighway3549 I am looking to build something similar where did you pull you database from now that the data type functionality is gone

@excelhighway3549 Жыл бұрын

@@Thatfitnessdad I used a database at MyFoodData.com

@الصعيدىفىالاحياءوالجيولوجيا Жыл бұрын

@@excelhighway3549 ممكن ملف البرنامج بس بالغة العربية تبعته ليا

@mloook_a2a Жыл бұрын

Is there a calorie calculator in this file? Where do I put my weight and height in order to calculate my calories?

@excelhighway3549 Жыл бұрын

This calculator will allow you to track your daily calory intake. You can add your daily target and keep track.

@giuseppeboo42 2 жыл бұрын

Hi i am trying to make this sheet (which is an amazing piece of informational content thanks) however i cant get the blue colums to automaticly fill, how do i do that could you help?

@excelhighway3549 2 жыл бұрын

Thanks for the feedback, did you define the range as a Table?

@giuseppeboo42 2 жыл бұрын

@@excelhighway3549 no i have not, ill try now thanks :)

@nutripedia.by.sanjana 2 ай бұрын

how to make this on google sheets?

@excelhighway3549 2 ай бұрын

You can follow the steps and create on Google sheets, perhaps some minor changes will be needed. I can look into creating in google sheets.

@nutripedia.by.sanjana 2 ай бұрын

@@excelhighway3549 ok

@nutripedia.by.sanjana Ай бұрын

@@excelhighway3549 what if we create on excel sheets and upload that file on google sheets. will that work?

@soccersinger101 Жыл бұрын

THANK YOU! Exactly what I’ve been looking for! I’ve been trying to add some info in my fitness app but don’t know jack about how many calories some of my home made food is and it take me a minute to go through and calculate it but God I couldn’t find ANY TEMPLATES for this

@excelhighway3549 Жыл бұрын

I'm glad this helped you.

@almaldonado4224 5 ай бұрын

The video does not show some of the steps you take, or what screens you are looking at.

@excelhighway3549 5 ай бұрын

Sorry about that, what part are you missing?

@stha26 4 ай бұрын

So nice and easy way u shared thanks

@excelhighway3549 4 ай бұрын

Thank you

@valeenoi2284 Жыл бұрын

This is useless if you need to enter nutritional facts yourself. Everything you buy has different entries. Using this "database" on the web doesn't cut it. I tried to give the problem to AI and it has failed me miserably so far. Seems like Excel gurus also are no help. How hard is it to have a worksheet that you input a specific ingredient/food with all 40+ nutritional facts with a given weight, then in another worksheet enter the same ingredient/food name, and just give it some weight, then it calculates the percentage of weight with respect to nutritional facts worksheet, and auto fill the rest for that ingredient and given weight?

@excelhighway3549 Жыл бұрын

You can do that with this file. The web database is an example and can be used. You can delete it / add your own data. Once you do that you can select that food and track your nutrition.