|
Download the major source of food
composition data in the United States.
SR21+.xls supercedes USDA SR13, previously at this URL.
Click here to download Excel file SR21+.xls
(expect 30" delay while loading, then save where you wish)
This 18 MB Microsoft Excel v 5-7 Spreadsheet was assembled in 2008 from USDA data downloaded from
James H. Thompson, video host Vegetarian Society of Hawaii www.vsh.org/video who: 1) loaded the sr21.mdb
file into Microsoft Access, 2) exported each table in the database as a tab delimited file, 3) wrote a custom
Perl program (http://www.perl.org/) to extract and combine data from the extracted tab delimited files, 4) ran
the program to generate the spreadsheet. He also converted USDA ORAC07.pdf to .xls
and by
William Harris, M.D., Vegetarian Society of Hawaii secretary and video coordinator, Author of The Scientific
Basis of Vegetarianism harrismdw001@hawaii.rr.com , www.vegsource.com/harris/
It contains data on 7415 food items in 196 columns including macro nutrients (carbohydrate, fat, and protein),
vitamins, minerals, fatty acids, amino acids, and miscellany. Column headers in regular type indicate nutrient
values per 100 grams of food. Headers in italics indicate nutrient values per Calories of food (in other words,
the nutrient/Calorie ratio, derived by dividing the nutrient/100 gm columns by the Calorie/100 gm column D).
To sort any of the databases, put the cursor in A1 (NDB_No) and go Data/Sort, select "my list has header
row", and "sort by descending". Then left-click the small down carat and pick, from the choices in the "sort
by" box, the desired column (e.g. Calcium/wt or Calcium/Cal) and click "OK". Excel will sort the file in a few
seconds and Cntrl-Home will bring the pointer back to the "freeze pane" cell in column C.
Hold down the right arrow key until the appropriate nutrient column appears, showing the descending values. A quicker method is to double click in the "sort by" box (e.g. "Cntrl-C" (copy) "Protein/Cal", hit "enter" to begin the sort, "Cntrl-Home" after the sort is done, and then left click in the far left 2nd row to highlight the entire row. "Cntrl-F" (find) followed by "Cntrl- V" (paste) then drops "Protein/Cal" into the find box and "enter" takes you quickly to that column in row 2. "Cntrl-Z" or Edit/Undo Sort undoes the sort and returns the sheet to its its original condition.
SR21.xls consists of 12 sheets:
1. this sheet "About", which gives an overview of the entire file,
2. "SR21" (the main USDA data sheet),
3. "Vegan Database" (1164 foods excluding candies, cholesterol, cookies, crackers, fried, honey, mixed, proprietary, salted, sauces, soups, sugared, trans fat, etc. found in SR21). This sheet has also moved some of the SR21 columns to the end to provide easier access to the more common nutrients.
4. "Vegan Questionnaire" (my scored, self-calculating but subjective guide to healthy diet and exercise.)
5. "Lab Data" (a skeleton for starting your own Laboratory Records that often become irretrievable over time and changes in medical coverage, so keep your own just in case.)
6. "Health Diary" ( the frame for a daily health diary, which the user can edit to personal preferences. Note: additional daily dates are added from Edit/Fill/Series)
8. "NUTR_DEF" (the 140 nutrients in SR21 sorted by Nutrient Number)
9. "Fatty Acids" (systematic and common names of the extensive fatty acids in SR21
10. "CFB" (A Table for Coumestrol, Formononetin and Biochanin taken from SR13 of 2001). 51748 is highest NDB NO. in SR21, however the highest CFB values are in NDBs above 51748, so this data is not included in the main SR21 data sheet.
11. "ORAC Data" (Oxygen Radical Absorbance Capacity (ORAC) of Selected Foods – 2007)
12. "About ORAC" (Explanation of ORAC)Other Uses:
It is advisable not to save "SR21.xls" unless it is renamed since any changes made will disrupt the original data. No provision is made for individual nutritional analysis, however it could be done by copying the A2 header row into a new spreadsheet and then selecting all of the foods eaten in a given period of time and copying those rows into the new spreadsheet. Standard spreadsheet methods could then be used to adjust the food quantities and summarize the nutrient intake.
William Harris, M.D.
1765 Ala Moana Blvd. #1880
Honolulu, HI 96815
Author of The Scientific Basis of Vegetarianism
http://www.vegsource.com/harris/
