|
Download the major source of food
composition data in the United States.
SR22+.xls supercedes USDA SR21+, previously at this URL.
Click here to download Excel file SR22+.xls
(expect ~ 30" delay while loading, then save where you wish)This 16 MB Microsoft Excel v 5-7 Spreadsheet was assembled in 10/2009 from USDA data downloaded from: www.ars.usda.gov/Services/docs.htm?docid=18879 by:
James H. Thompson, video host Vegetarian Society of Hawaii www.vsh.org/video who: 1) loaded the sr22.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/(A smaller 3.5 MB vegan only version, SR22V+.xls can be downloaded at http://www.vsh.org/resources.htm )
To sort any of the databases, simply 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 E2 ( main SR22 DB) or C2 (Vegan data base).
Hold down the right arrow key until the appropriate nutrient column appears, showing the descending values. A quicker method is to copy 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 1st row to highlight the entire label row. "Cntrl-F" (find) then "Cntrl-V" (paste ) drops "Protein/Cal" into the find box and "enter" takes you you quickly to that column.
SR22+.xls consists of 11 sheets: 1. "About", which gives an overview of the entire file, 2. "SR22" ( main USDA data sheet), 3."Vegan Database" (2128 foods with fewer columns). 4. "Vegan Questionnaire" (my scored, self-calculating but subjective guide to healthy diet and exercise .) 5. "Lab Data" (a skeleton for keeping your own Laboratory Records that may become irretrievable over time and changes in medical coverage). 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) 7. "NUTR_DEF" (the 140 nutrients in SR22) 8. "Fatty Acids" (systematic and common names of the extensive fatty acids in SR22. 9. "CFB" (A Table for Coumestrol, Formononetin and Biochanin taken from SR13 of 2001). 10. "ORAC Data" (Oxygen Radical Absorbance Capacity (ORAC) of (278) Selected Foods from 2007) 11. "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 A header row into a new spreadsheet, 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/