Enter into column A, F, and K the number of servings consumed of each food group from Row E in Nutrient Analysis Day 2 Copy the numbers entered in Column A to Columns F and K
Multiply columns A x B and enter the total in column C Multiply columns C x D and enter the total in column E
Add together all the numbers in column C and enter in "Total gms CHO Consumed" Multiply columns F x G and enter the total in column H Multiply columns H x I and enter the total in column J
Add together all the numbers in column H and enter in "Total gms PRO consumed" Multiply columns K x L and enter the total in column M Multiply columns M x N and enter the total in column O
Add together all the numbers in column M and enter in "Total gms FAT consumed" Add together all numbers in Column E and enter total in yellow box at bottom of column Add together all numbers in Column J and enter total in yellow box at bottom of column Add together all numbers in Column O and enter total in yellow box at bottom of column
Add together all the numbers in the three yellow boxes and enter the blue total in "Total CALORIES consumed" box CARBOHYDRATE