I have finally completed my formula (so I think). The spreadsheet is available from my Dropbox and Google Drive.
Hey everyone - I have updated the Google Drive link. I now realize that I had to rebuild the entire workbook in Google Drive before anyone could use it!
I've spent several weeks tinkering with this formula. I noticed that many who had uploaded theirs were comfortable with allowing their intake levels of certain ingredients to hover between 75% and 90% for the purposes of cost, and thought that I could definitely do better than that. The only ingredient I have in there that is under 100% is Calcium, which is missing 7.5% of its requirement.
The spreadsheet uses a completion index and a toxicity alert system of which both tools were very helpful in ensuring that my formula was perfect. I have included links to all of the items I will be purchasing. Even though I am buying 12 / 13 of the ingredients locally, it's still important that you can see what I'm buying. Where I was unable to find the item online, I provided a picture coming from my Dropbox.
With that said, please critique the hell out of this formula. I may have spent weeks designing it and ensuring that it was perfect, but I would be happy to spend months in continuation of this effort so that I have not omitted any major information or overlooked some glaring error. I already know that it's not 100% perfect and therefore any feedback that you folks can provide would be extremely useful.
I used this nutrition guide from the NIH to determine my specific values, using Rob's Updated Recommended for those not listed (of which there were few). Under the PDF's provided at that link, I am classified as Male, 19 - 30 years old. Again, if you happen to be familiar with those values and see any errors, please let me know, as I would highly appreciate it.
Ultimately my goal in sharing this formula is to help other Canadians and Ontarians (sic?) find good sources for their formulas and also to provide a few tools that will make building a formula easier. I found that while many super automation apps have cropped up over the last few weeks, simply obtaining and inputting the raw data myself was a lot less of a headache and gave me greater peace of mind.
I also would like to add that keeping the cost below $5.00 / Day is something I'm very proud of so far
Thank you to everyone on this board for your invaluable feedback and thank you in advance for any and all feedback or input you can provide here!