Question about Computers & Internet

2 Answers

How i get the nutrition facts for any recipe by excel program ?? plz help me to get a inclusive program

Posted by on

  • A1_A1 Apr 24, 2010

    i"m sorry i don"t have an excel file containing all my info .. but i need a ready excel file program ,, to add to it my ingredients for my recipe .. then i can get my nutrition facts for my recipe

    ok .. So.. u think that i succeeded to explain what i need ?

    Regards

  • A1_A1 May 06, 2010

    thank you soooo much

×

Ad

2 Answers

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Computers & ... Master
  • 5,416 Answers

The USDA has nutrition label information in an Access database format.
http://www.ars.usda.gov/Services/docs.htm?docid=15867
If you have Access, you can create a new query and build new tables to export into Excel.

  1. Enable any stupid security warnings (or turn it off for this task).
  2. Create a new query in Design View.
  3. Add these tables:
    • NUTR_DEF
    • NUT_DATA
    • FOOD_DES

  4. Select the following fields:
    • FOOD_DES.Shrt_Desc
    • NUTR_DEF.NutrDesc
    • NUT_DATA.Nutr_Val

  5. Make the query a Crosstab.

  6. In the query design grid, set the fields to:
    • Shrt_Desc to Row Heading
    • NutrDesc to Column Heading
    • Nutr_Val to Value, and make it Sum under Total
    It should look like this when you're done.

  7. Click View or Run

  8. Export to Excel
It's also available as a PDF but you have to click through to the serving table. http://www.nal.usda.gov/fnic/foodcomp/Data/SR20/SR20_doc.pdf The USDA source file is set up giving facts for 100 g per food item. Remember portion sizes usually don't match that 100 g per item.

Most of the cooking/recipe programs and sites do not have nice excel versions of the nutrition facts info.

I wish that I could be of more help. Access is part of the MS Office Suite Professional or higher or can be purchased separately. It is not in the Home and Student version. OpenOffice Base matches some of the Access features and will read the Access database. However, the query and new tables above may need to be restructured.

Cindy Wells

Posted on Apr 24, 2010

Ad
  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 787 Answers

So you have an excel file containing all your info but you don't know how to access specific data?

Posted on Apr 24, 2010

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

What types of nutritional facts is provided by Beard Czar facial hair complex?


Some of the most beneficial nutritional facts provided by this Beard Czar facial hair complex are given below:
a. Vitamin A
b. Vitamin C
c. Vitamin E
d. Biotin
e. Vitamin B5
f. Vitamin B6
g. Niacin
h. Daily complex for hair, nails, skin.
This beard product has many other well-proven benefits when consuming.


facial-hair-complex-192x300-vqboekzaxvzaomlqmpw03hal-5-0.png

Aug 19, 2017 | Health & Beauty

1 Answer

Do Wilton pans take longer for baking than typical recipes call for? My cakes are sinking during cooling even after baking 10-15 longer than recipe calls for.


I am not familiar with Wilton pans, but as a former professional baker, the main reason for cakes sinking, after baking, is under or insufficient baking. The structure of the cake, which is aerated by the baking powder releasing carbon dioxide to "push it up" or by the inclusion of air during the mixing process, (as in egg sponges or madeira cakes,) needs to be fully set to ensure it stays put as the cake cools. If the structure is not fully baked, as the cake cools the raising agents dissipate and the cake collapses.

Collapsing during baking is caused by fundamentally different reasons, usually as a result of unbalanced recipes.

Hope this helps.

Jul 18, 2017 | Baking

3 Answers

Cowpea nutriants


The seed has got the lifespan of 5 years. Cowpea is loaded with various types of nutrients. It is rich in fiber, protein, iron, potassium, low in fat and calories. The cup of cowpea possesses 11.1 g fiber, 13.22 g protein, 4.29 mg iron, 475 mg potassium, 0.91 g fat and 198 calories.

Cowpea Facts, Health Benefits and Nutritional Value

https://www.healthbenefitstimes.com/cowpeas/ Feedback
About this result

Cowpeas, common (blackeyes, crowder, southern), mature seeds ...

nutritiondata.self.com/facts/legumes-and-legume-products/4332/2?mbid=ndhp Nutrition facts and Information for Cowpeas, common (blackeyes, crowder, southern), mature seeds, cooked, ... Nutritional Target Map Estimated Glycemic Load.

Cowpeas, leafy tips, raw Nutrition Facts & Calories

nutritiondata.self.com/facts-001-02s01vn.html Nutrition facts and Information for Cowpeas, leafy tips, raw. ... Nutritional Target Map Estimated Glycemic Load. NUTRITIONAL ... NUTRIENT BALANCE. 73.

Cowpea Facts, Health Benefits and Nutritional Value

https://www.healthbenefitstimes.com > Vegetables The seed has got the lifespan of 5 years. Cowpea is loaded with various types of nutrients. It is rich in fiber, protein, iron, potassium, low in fat and calories. The cup of cowpea possesses 11.1 g fiber, 13.22 g protein, 4.29 mg iron, 475 mg potassium, 0.91 g fat and 198 calories. Major nutrients‎: ‎Vitamin B9 89.00%; Iron 53.63...
Calories‎: ‎198 Kcal Kcal./cup
Health benefits‎: ‎Prevents cancer, Prevents an...
Scientific Name‎: ‎Vigna unguiculata

Health Benefits of Cowpeas ' Organic Facts

https://www.organicfacts.net > Lentils For more than 4,000 years, cowpeas have likely been cultivated in these regions of the world, but there is far more to the story than that. Given the high nutrient ...

Cowpea

https://www.hort.purdue.edu/newcrop/afcm/cowpea.html The protein in cowpea seed is rich in the amino acids, lysine and tryptophan, compared to cereal grains; however, it is deficient in methionine and cystine when compared to animal proteins. Therefore, cowpea seed is valued as a nutritional supplement to cereals and an extender of animal proteins. Protein‎: ‎24.8%
Fat‎: ‎1.9%
Carbohydrate‎: ‎63.6%
Fiber‎: ‎6.3%
Cowpea nutrient Google Search

Jan 09, 2017 | Miscellaneous

1 Answer

Are the recipe book or the owners manual available?


The owner's manual should be available online. Any good juice recipe book will work with this juicer. I've found amazing recipes online and especially at countless Nutritional/ Vegan websites.This type of juicer is a "juice extractor", meaning it doesn't completely liquify all of the pulp like the new Ninja does. Look for recipes that work for a juice extractor.

Mar 13, 2016 | Jack Lalanne Juicers

1 Answer

Where can I find Chocolate Boost Nutritional Energy Drink without Iron?


I suggest that you will check out this link: http://www.fixya.com/support/t23547769-find_chocolate_boost_nutritional_energy
It has all the nutrition facts (click the red link: Full Nutritional Information) and you can see if it has iron.

Feb 16, 2014 | Nestl? Boost Nutritional Supplement...

3 Answers

Can anyone suggest a recipe for homemade pasta?


Here is a recipe from Jamie Oliver's website. http://www.jamieoliver.com/recipes/pasta-recipes/a-basic-recipe-for-fresh-egg-pasta

He has some good recipes that are very easy to follow.

Feb 20, 2013 | Cooking

1 Answer

Im looking for a homemade meal replacement drink recipe. I am on a high protein, medium carbohydrate diet. What would you recommend?


I am on a similar diet as you and I use the following meal replacement recipe from time to time in order to support my nutritional needs. What I do is take about .5 liter of 1% or skim milk, one serving of my chocolate protein powder (I usually use Optimum Nutrition Whey Gold Standard), and half a cup of oats (Quaker) and put them in a blender. I mix them all and then have a delicious, nutritional meal replacement! It comes out to be around 450 calories with 45 grams of protein and 55 grams of carbs.

Feb 04, 2013 | Health & Beauty

1 Answer

Can nutrition bars be consumed by people who do not work out?


It is absolutely fine to consume nutrition bars even if you're not active. These bars are healthy nonetheless and can help support a healthy diet. Protein bars are excellent in supporting your protein needs and low calorie energy bars like Nestle Fitness are great for providing you with energy.

Jan 24, 2013 | Health & Beauty

1 Answer

How i get data from html form to ms access or excel file...????


this needs to be programmed - i.e. when you submit the form it needs to be submitted to something (e.g. java servlet, php script, etc.) that will take the data and insert it into a data store (access, excel, mysql, oracle, etc.)

Apr 09, 2009 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

108 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...