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

×

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,056 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

  • 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

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,
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

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

Am I eligible for food stamps


Search Results Deductions are allowed as follows:
Gross Income Computation Example Determine household size..... 4 people with no elderly or disabled members. Add gross monthly income... $1,500 earned income + $550 social security = $2,050 gross income. 1 more row

Eligibility ' Food and Nutrition Service

https://www.fns.usda.gov/snap/eligibility Feedback
About this result

Eligibility ' Food and Nutrition Service

https://www.fns.usda.gov/snap/eligibility Oct 20, 2016 - Most households must meet both the gross and net income tests, but a household with an elderly person or a person who is receiving certain types of disability payments only has to meet the net income test. Households, except those noted, that have income over the amounts listed below cannot get SNAP benefits.‎IIS7 · ‎Fact Sheet on Resources ... · ‎COLA · ‎Federal Jobs Training Programs Am I eligible for food stamps Google Search

Jan 18, 2017 | Computers & Internet

2 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

Excel is devloped for which operating system


Microsoft Excel has become a crucial tool in the international workplace, providing basic database functionality, along with spreadsheet and calculation tools. While it is currently the market leader for spreadsheets, the history of excel shows that throughout the 1980s and 90s it faced significant competition from rival software platforms like Lotus Notes, Mosaic TWIN and the Paperback VP Planner. The original Microsoft spreadsheet program was called Multiplan - which began development in 1982 - but it was never as financially successful as Lotus Notes.
Interestingly, Excel was first developed for the Macintosh operating system beginning in 1984. It made use of graphical menus and the mouse, innovating strongly relative to the other major competitors at the time. Drop-down menus and a point and click interface helped to make it more usable to non-technical workers, and in turn helped to influence graphical user interfaces in other software and operating systems at the time.
As such, when Windows was launched in 1987, Excel was one of the most important and popular pieces of software for it. The early exploration of the graphical user interface for Windows had already been conducted and market tested by earlier versions of Excel. While it was certainly not the first spreadsheet software package, it was the first to provide a powerful combination of usability and functionality to business clients of all sizes.
Lotus was relatively slow to bring Lotus 123 to Windows, failing to predict the popularity of the operating system.
One of the major turning points in Excel was the inclusion of Visual Basic for Applications in 1993, which greatly increased the functionality of the software. In turn, it also encouraged a generation of professionals to learn the programming language, further solidifying the long term demand for Excel over other spreadsheet suites


Read more: http://www.brighthub.com/office/collaboration/articles/13188.aspx#ixzz1IWkjtDx5

Oct 30, 2010 | Answer Racing Ion Motorcycle Jersey 2010

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

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

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

Answer questions

Manuals & User Guides

Loading...