dakz
Wed, January 28th, 2004, 06:46 AM
I canīt figure out some formulae used by John in his spreadsheet. :confused:
Under the "Meal Planner (John)" tab, you will find the daily food intake table. Under that table there are two rows: TOTALS and PERCENT.
The total is just the sum of the rows above for that day; but the percent varies:
In the "Fat" column, the formula is =D137*9/C137
In the "Carbs" column, the formula is =F137*4/C137
In the "Protein" column, the formula is =I137*4/C137
Why does he use 9 and 4 ?!? Where does that come from?
Under the "Meal Planner (John)" tab, you will find the daily food intake table. Under that table there are two rows: TOTALS and PERCENT.
The total is just the sum of the rows above for that day; but the percent varies:
In the "Fat" column, the formula is =D137*9/C137
In the "Carbs" column, the formula is =F137*4/C137
In the "Protein" column, the formula is =I137*4/C137
Why does he use 9 and 4 ?!? Where does that come from?