food and science

profileshazuanzhe
ProjectPart1BFoodLogTemplateAU182.xlsx
Home>Applied Sciences homework help>food and science

DAY 1

DAY 1
Item 1 Item 2 Item 3 Item 4 Item 5 Item 6 Item 7 Item 8 Item 9 Item 10
FOOD or BEVERAGE Item
Portion Amount
USDA NDB No. DAY 1
NUTRIENT Units Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts TOTALS NUTRIENT
Water g 0 Water
ENERGY kcal 0 ENERGY
Protein g 0 Protein
Total lipid (fat) g 0 Total lipid (fat)
Carbs, by diff g 0 Carbs, by diff
Fiber, total dietary g 0 Fiber, total dietary
Sugars, total g 0 Sugars, total
MINERALS MINERALS MINERALS
Calcium, Ca mg 0 Calcium, Ca
Iron, Fe mg 0 Iron, Fe
Magnesium, Mg mg 0 Magnesium, Mg
Phosphorus, P mg 0 Phosphorus, P
Potassium, K mg 0 Potassium, K
Sodium, Na mg 0 Sodium, Na
Zinc, Zn mg 0 Zinc, Zn
VITAMINS VITAMINS VITAMINS
Vit C, total ascorbic acid mg 0 Vitamin C, total ascorbic acid
Thiamin mg 0 Thiamin
Riboflavin mg 0 Riboflavin
Niacin mg 0 Niacin
Vitamin B-6 mg 0 Vitamin B-6
Folate, DFE mcg 0 Folate, DFE
Vitamin B-12 mcg 0 Vitamin B-12
Vitamin A, IU IU 0 Vitamin A, IU
Vitamin E (alpha-tocopherol) mg 0 Vitamin E (alpha-tocopherol)
Vitamin D IU 0 Vitamin D
DO NOT use units in the columns C-L. Enter only Numeric values.
Otherwise the spreadsheet will not compute correctly.

&"Calibri,Regular"&K000000Autumn 2018 FDSCTE 2200 Online

DAY 2

DAY 2
Item 1 Item 2 Item 3 Item 4 Item 5 Item 6 Item 7 Item 8 Item 9 Item 10
FOOD or BEVERAGE Item
Portion Amount
USDA NDB No. DAY 2
NUTRIENT Units Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts TOTALS NUTRIENT
Water g 0 Water
ENERGY kcal 0 ENERGY
Protein g 0 Protein
Total lipid (fat) g 0 Total lipid (fat)
Carbs, by diff g 0 Carbs, by diff
Fiber, total dietary g 0 Fiber, total dietary
Sugars, total g 0 Sugars, total
MINERALS MINERALS MINERALS
Calcium, Ca mg 0 Calcium, Ca
Iron, Fe mg 0 Iron, Fe
Magnesium, Mg mg 0 Magnesium, Mg
Phosphorus, P mg 0 Phosphorus, P
Potassium, K mg 0 Potassium, K
Sodium, Na mg 0 Sodium, Na
Zinc, Zn mg 0 Zinc, Zn
VITAMINS VITAMINS VITAMINS
Vit C, total ascorbic acid mg 0 Vitamin C, total ascorbic acid
Thiamin mg 0 Thiamin
Riboflavin mg 0 Riboflavin
Niacin mg 0 Niacin
Vitamin B-6 mg 0 Vitamin B-6
Folate, DFE mcg 0 Folate, DFE
Vitamin B-12 mcg 0 Vitamin B-12
Vitamin A, IU IU 0 Vitamin A, IU
Vitamin E (alpha-tocopherol) mg 0 Vitamin E (alpha-tocopherol)
Vitamin D IU 0 Vitamin D
DO NOT use units in the columns C-L. Enter only Numeric values.
Otherwise the spreadsheet will not compute correctly.

DAY 3

DAY 3
Item 1 Item 2 Item 3 Item 4 Item 5 Item 6 Item 7 Item 8 Item 9 Item 10
FOOD or BEVERAGE Item
Portion Amount
USDA NDB No.
DAY 3
NUTRIENT Units Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts TOTALS NUTRIENT
Water g 0 Water
ENERGY kcal 0 ENERGY
Protein g 0 Protein
Total lipid (fat) g 0 Total lipid (fat)
Carbs, by diff g 0 Carbs, by diff
Fiber, total dietary g 0 Fiber, total dietary
Sugars, total g 0 Sugars, total
MINERALS MINERALS MINERALS
Calcium, Ca mg 0 Calcium, Ca
Iron, Fe mg 0 Iron, Fe
Magnesium, Mg mg 0 Magnesium, Mg
Phosphorus, P mg 0 Phosphorus, P
Potassium, K mg 0 Potassium, K
Sodium, Na mg 0 Sodium, Na
Zinc, Zn mg 0 Zinc, Zn
VITAMINS VITAMINS VITAMINS
Vit C, total ascorbic acid mg 0 Vitamin C, total ascorbic acid
Thiamin mg 0 Thiamin
Riboflavin mg 0 Riboflavin
Niacin mg 0 Niacin
Vitamin B-6 mg 0 Vitamin B-6
Folate, DFE mcg 0 Folate, DFE
Vitamin B-12 mcg 0 Vitamin B-12
Vitamin A, IU IU 0 Vitamin A, IU
Vitamin E (alpha-tocopherol) mg 0 Vitamin E (alpha-tocopherol)
Vitamin D IU 0 Vitamin D
DO NOT use units in the columns C-M. Enter only Numeric values.
Otherwise the spreadsheet will not compute correctly.

DAILY AVG

MY CONSUMPTION LOG DATA SUMMARY DIETARY REFERENCE INTAKE (DRI) VALUES
NUTRIENT Units Total Day 1 Total Day 2 Total Day 3 3- day Totals My Daily Avgs RDA/AI UL Adult NUTRIENT
Water g 0.00 0.00 0.00 0.00 0.00 Water
ENERGY kcal 0.00 0.00 0.00 0.00 0.00 ENERGY
Protein g 0.00 0.00 0.00 0.00 0.00 Protein
Total lipid (fat) g 0.00 0.00 0.00 0.00 0.00 Total lipid (fat)
Carbohydrates g 0.00 0.00 0.00 0.00 0.00 Carbohydrates
Fiber, total dietary g 0.00 0.00 0.00 0.00 0.00 Fiber, total dietary
Sugars, total g 0.00 0.00 0.00 0.00 0.00 Sugars, total
MINERALS
Calcium, Ca mg 0.00 0.00 0.00 0.00 0.00 2500.0 Calcium, Ca
Iron, Fe mg 0.00 0.00 0.00 0.00 0.00 45.0 Iron, Fe
Magnesium, Mg mg 0.00 0.00 0.00 0.00 0.00 350.0 Magnesium, Mg
Phosphorus, P mg 0.00 0.00 0.00 0.00 0.00 4000.0 Phosphorus, P
Potassium, K mg 0.00 0.00 0.00 0.00 0.00 ND Potassium, K
Sodium, Na mg 0.00 0.00 0.00 0.00 0.00 2300.0 Sodium, Na
Zinc, Zn mg 0.00 0.00 0.00 0.00 0.00 40.0 Zinc, Zn
VITAMINS VITAMINS
Vit C, ascorbic acid mg 0.00 0.00 0.00 0.00 0.00 2000.0 Vit C, ascorbic acid
Thiamin (B1) mg 0.00 0.00 0.00 0.00 0.00 ND Thiamin (B1)
Riboflavin (B2) mg 0.00 0.00 0.00 0.00 0.00 ND Riboflavin (B2)
Niacin(B3) mg 0.00 0.00 0.00 0.00 0.00 35.0 Niacin(B3)
Vit B6 mg 0.00 0.00 0.00 0.00 0.00 100.0 Vit B6
Folate, DFE mcg 0.00 0.00 0.00 0.00 0.00 1000.0 Folate, DFE
Vit B12 mcg 0.00 0.00 0.00 0.00 0.00 ND Vit B12
Vit A, IU IU 0.00 0.00 0.00 0.00 0.00 10000.0 Vit A, IU
Vit E mg 0.00 0.00 0.00 0.00 0.00 1000.0 Vit E
Vit D IU 0.00 0.00 0.00 0.00 0.00 4000.0 Vit D
RDA /AI Values by age and gender
Nutrient Males Males Males Males Females Females Females Females Pregnant Lactating
Age 14-18 19-30 31-50 >50 14-18 19-30 31-50 >50
Water(g) 3300 3700 3700 3700 2300 2700 2700 2700 3000 3800
Proteins (g) 52 56 56 56 46 46 46 46 71 71
Carbohydrates (g) 130 130 130 130 130 130 130 130 175 210
Fiber (g) 38 38 38 30 26 25 25 25 21 28 29
Calcium 1300 1000 1000 1000 1300 1000 1000 1200 1000 1000
Iron 8 8 8 8 15 18 18 8 27 9
Sodium 1500 1500 1500 1300 1500 1500 1500 1300 1500 1500
Vitamin C 75 90 90 90 65 75 75 75 85 120
Vitamin A 3000 3000 3000 3000 2300 2300 2300 2300 2600 4300
Vitamin D 600 600 600 600 600 600 600 600 600 600
There is no RDA for Fat or sugars Find the RDA value based on your gender and age. Enter the appropriate values in RDA row.
End of Summary End of Summary

Example sheet 1

Example Sheet 1
Item 1 Item 2 Item 3 Item 4 Item 5 Item 6 Item 7 Item 8 Item 9 Item 10 Item 9 Item 10 Item 10
FOOD or BEVERAGE Item eggs whole wheat toast coffee kiwi Grilled cheese sandwich Cream of tomato soup cooked quinoa tofu bell pepper carrots broccoli soy sauce water
Portion Amount 2 1 1 2 1 1/3 cup 3 oz 1/4 cup 1/4 cup 1/4 cup 1stp 32 Fl oz
USDA NDB No. 01132 N/a 14179 09148 45261709 45135804 20137 16212
DAY -Example
NUTRIENT Units Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts TOTALS NUTRIENT
Water g 0 Water
ENERGY kcal 0 ENERGY
Protein g 0 Protein
Total lipid (fat) g 0 Total lipid (fat)
Carbs, by diff g 0 Carbs, by diff
Fiber, total dietary g 0 Fiber, total dietary
Sugars, total g 0 Sugars, total
MINERALS MINERALS MINERALS
Calcium, Ca mg 0 Calcium, Ca
Iron, Fe mg 0 Iron, Fe
Magnesium, Mg mg 0 Magnesium, Mg
Phosphorus, P mg 0 Phosphorus, P
Potassium, K mg 0 Potassium, K
Sodium, Na mg 0 Sodium, Na
Zinc, Zn mg 0 Zinc, Zn
VITAMINS VITAMINS VITAMINS
Vit C, total ascorbic acid mg 0 Vitamin C, total ascorbic acid
Thiamin mg 0 Thiamin
Riboflavin mg 0 Riboflavin
Niacin mg 0 Niacin
Vitamin B-6 mg 0 Vitamin B-6
Folate, DFE mcg 0 Folate, DFE
Vitamin B-12 mcg 0 Vitamin B-12
Vitamin A, IU IU 0 Vitamin A, IU
Vitamin E (alpha-tocopherol) mg 0 Vitamin E (alpha-tocopherol)
Vitamin D IU 0 Vitamin D
DO NOT use units in the columns C-M. Enter only Numeric values.
Otherwise the spreadsheet will not compute correctly.

Example sheet 2

EXAMPLE SHEET 2
Example Example Example Example Example Item 7 Item 8 Item 9 Item 10
FOOD or BEVERAGE Item Cottage cheese Subway Burrito from Clif bar 5-Hr Energy
Portion Amount 1 cup 6" Tuna curl market 1 Shot
USDA NDB No. 01012 21214 n/a n/a n/a
NUTRIENT Units Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts TOTALS NUTRIENT
Water g 179.53 137.86 0 0 0 317.39 Water
ENERGY kcal 220 524 978 240 1962 ENERGY
Protein g 25.02 29.22 39.94 10 0 104.18 Protein
Total lipid (fat) g 9.68 28.53 45.5 5 0 88.71 Total lipid (fat)
Carbs, by diff g 7.6 37.8 100.93 43 0 189.33 Carbs, by diff
Fiber, total dietary g 0 1.7 7.5 5 0 14.2 Fiber, total dietary
Sugars, total g 6.01 4.57 4 22 0 36.58 Sugars, total
MINERALS MINERALS
Calcium, Ca mg 187 322 520 250 0 1279 Calcium, Ca
Iron, Fe mg 0.16 3.72 7.2 4.5 0 15.58 Iron, Fe
Magnesium, Mg mg 18 52 0 40 0 110 Magnesium, Mg
Phosphorus, P mg 358 258 0 10 0 626 Phosphorus, P
Potassium, K mg 234 419 0 0 0 653 Potassium, K
Sodium, Na mg 819 780 2125 120 18 3862 Sodium, Na
Zinc, Zn mg 0.9 1.59 0 1.5 0 3.99 Zinc, Zn
VITAMINS VITAMINS
Vit C, total ascorbic acid mg 0 0 25.8 30 0 55.8 Vitamin C, total ascorbic acid
Thiamin mg 0.061 0.45 0 0.15 0 0.661 Thiamin
Riboflavin mg 0.367 0.514 0 0.255 0 1.136 Riboflavin
Niacin mg 0.223 18.313 0 3 30 51.536 Niacin
Vitamin B-6 mg 0.103 0.642 0 0.4 40 41.145 Vitamin B-6
Folate, DFE mcg 27 0 80 400 507 Folate, DFE
Vitamin B-12 mcg 0.97 2.51 0 0.9 500 504.38 Vitamin B-12
Vitamin A, IU IU 315 185 3300 500 0 4300 Vitamin A, IU
Vitamin E (alpha-tocopherol) mg 0.18 3.72 0 15 0 18.9 Vitamin E (alpha-tocopherol)
Vitamin D IU 7 0 40 0 47 Vitamin D

Calculator

MICRONUTRIENT CALCULATOR TOOL
You only need to use this tool if you use a food label or OSU dining services and it lists %DVs and not actual nutrient amounts. To use this tool:
1) Enter the value listed on the label as % Daily Value (without % symbol). In the EXAMPLE, the label lists niacin (B3) as
having a % Daily Value of 150%. (Note: This label also lists 30 mg so you would NOT need to use the calculator.)
2) Find the result in the "Calculated Nutrient Amt" column. Enter this value into your Consumption Log worksheet.
Reference Values
Nutrient Label %DV Conversion Factor Calculated Nutrient Amt UNITS 100% of DV = Units EXAMPLE. Label on Food Package
VITS
A 50 0 IU 5000 IU
C 0.6 ERROR:#VALUE! mg 60 mg
D 4 ERROR:#VALUE! IU 400 IU
E 0.3 ERROR:#VALUE! IU 30 IU
K 0.8 ERROR:#VALUE! mcg 80 mcg
B1 0.015 ERROR:#VALUE! mg 1.5 mg
B2 0.017 ERROR:#VALUE! mg 1.7 mg
B3 150 0.2 30 mg 20 mg
B6 2000 0.02 40 mg 2 mg
Folate 100 4 400 mcg 400 mcg
B12 8333 0.06 499.98 mcg 6 mcg
MINS
Ca 10 ERROR:#VALUE! mg 1000 mg
Fe 0.18 ERROR:#VALUE! mg 18 mg
Mg 4 ERROR:#VALUE! mg 400 mg
P 10 ERROR:#VALUE! mg 1000 mg
K 35 ERROR:#VALUE! mg 3500 mg
Na 24 ERROR:#VALUE! mg 2400 mg
Zn 0.15 ERROR:#VALUE! mg 15 mg
Note: The Reference Values in the table on this page are those used by FDA for labeling. Some of this values differ from the IOM
values used in the worksheet. They are close enough for this exercise.
Reference Values
Nutrient Label %DV Conversion Factor Calculated Nutrient Amt UNITS 100% of DV = Units
VITS
A 66 50 3300 IU 5000 IU
C 43 0.6 25.8 mg 60 mg
D 4 ERROR:#VALUE! IU 400 IU
E 0.3 ERROR:#VALUE! IU 30 IU Burrito from Curl Market- OSU Dining Services
K 0.8 ERROR:#VALUE! mcg 80 mcg
B1 0.015 ERROR:#VALUE! mg 1.5 mg
B2 0.017 ERROR:#VALUE! mg 1.7 mg
B3 0.2 0 mg 20 mg
B6 0.02 0 mg 2 mg
Folate 4 0 mcg 400 mcg
B12 0.06 0 mcg 6 mcg
MINS
Ca 52 10 520 mg 1000 mg
Fe 40 0.18 7.2 mg 18 mg
Mg 4 ERROR:#VALUE! mg 400 mg
P 10 ERROR:#VALUE! mg 1000 mg
K 35 ERROR:#VALUE! mg 3500 mg
Na 24 ERROR:#VALUE! mg 2400 mg
Zn 0.15 ERROR:#VALUE! mg 15 mg
Clif bar
Reference Values
Nutrient Label %DV Conversion Factor Calculated Nutrient Amt UNITS 100% of DV = Units
VITS
A 10 50 500 IU 5000 IU
C 50 0.6 30 mg 60 mg
D 10 4 40 IU 400 IU
E 50 0.3 15 IU 30 IU
K 25 0.8 20 mcg 80 mcg
B1 10 0.015 0.15 mg 1.5 mg
B2 15 0.017 0.255 mg 1.7 mg
B3 15 0.2 3 mg 20 mg
B6 20 0.02 0.4 mg 2 mg
Folate 20 4 80 mcg 400 mcg
B12 15 0.06 0.9 mcg 6 mcg
MINS
Ca 25 10 250 mg 1000 mg
Fe 25 0.18 4.5 mg 18 mg
Mg 10 4 40 mg 400 mg
P 10 10 100 mg 1000 mg
K 0 35 0 mg 3500 mg
Na 5 24 120 mg 2400 mg
Zn 10 0.15 1.5 mg 15 mg

AMDR

Grams Calories Percent calories
Grams of fat 0.00 0 % calories from fat ERROR:#DIV/0!
Grams of Protein 0.00 0 % calories from protein ERROR:#DIV/0!
Grams of carbohydrates 0.00 0 % calories from carbohydrates ERROR:#DIV/0!
Total calories 0
% calories from fat % calories from protein % calories from carbohydrates 0.0 0.0 0.0