Healthy Diet 2017v19 Excel spreadsheet Weekly Diet Tool
Further to the recent v18 update I have added Camembert cheese and included the USDA Food List reference number (NDB No.) to the Stilton cheese entry which was omitted in v18. The blue stilton data that I have used is from a commercial supplier Coombe Castle. The data in the USDA Food List that includes commercial products is from the labelled product and may not include all the entries that the Food List normally lists. In the case of cheese I have copied missing data from the Cheddar cheese entry to the Stilton entry. This is preferable to entering a zero quantity. I will consider adding a comment to entries that have data from labelled products which does not supply the usual complete Food List nutrients.
USDA Food List
The USDA Food List requires the user to select the data source from Select Source. The options are: All data sources, Branded food products and Standard Reference.
To read the Food List entries as used in the Healthy Diet spreadsheet the user would normally select Standard Reference except when the entry is for a branded product.
Excel conditional formatting
So far the conditional formatting that I have employed is working but may need further information. Conditional formatting is used so a check can readily be seen that the target RDA (recommended Daily Allowance) is not met. The spreadsheet cell's background colour remains light pink, or for those nutrients that do not have an RDA remain uncoloured. When a nutrient meets the target RDA it's background colour will be removed. If a nutrient's RDA is met and exceeded the adjoining cell's background colour will change to dark pink.
I have re-included a muesli meal to provide an example of how the spreadsheet displays data. The user can delete the entries and enter their own.
Note that each nutrient has its own spreadsheet for the data. These eighteen spreadsheets are unlocked. I have left them unlocked as it is a real chore to unlock them for editing the workbook and then lock them again. By all means refer to the individual nutrient lists but beware not to change anything. Always when downloading an update make a copy as a Save As for your working weekly diet spreadsheet. Healthy Diet 2017v19
Earlier versions are below. Version 16 has a list of the features. Link