I’ve seen a lot of Soylent Excel templates in the last little while and the one I liked the best and made the most sense to me was the “One Small Step” template. I adapted that and started tweaking it so that it would be a little more intelligent, and have created a polished version of my own.
- A percentage total row, showing the full percentage of the ingredient with no caps (Row 18). So if you’ve got 5g of Vitamin K, the sheet will happily show you that you have 6,250,000% of the necessary amount.
- A Completion Index that uses row 19 (which caps totals at 100%), showing you how much of a percentage of the entire nutrition profile you have completed (defaulting to Rob’s Updated Recommended). This really helped me in terms of determining at any one point in time just how close I was to getting a complete formula and I was surprised to see that few other templates had it.
- An addition to the Total Investment calculator that included tax, because, why do you want surprises? Can be modified to your local tax rate. (Yes, we pay a lot in Canada!)
- Color bars for the Days Per Unit column, for greater visualization of where your weaknesses are in terms of product longevity.
- A Toxicity Alert Row, which contains values for all known tox levels relating to all ingredients. Note that I do not provide references - you are free to reverify all of the numbers. Most of my sources were the NIH, USDA, or FDA.
- A small update to Choline; the “One Small Step” excel sheet did not include a recommended dose here; I was able to determine that the RDI for Choline is 0.55g. (again, feel free to reverify and correct me in the name of science!)
I hope if anyone here likes this template but can also find a way to further improve it, they either give me a suggestion or improve it themselves. Creating Soylent shouldn’t be so hard when we have advanced calculation abilities in Excel / etc to make it easier for us.