Soylent Editor (Spreadsheet) Official Thread / Updates


#1

All posts on the Soylent Editor will be made on this thread from now on.

I’ve changed this to a permanent link to the folder, let me know if it doesn’t work

I make changes quickly, let me know if there’s anything you want to change.

VERSION 4.1.3.2

Looks prettier.

VERSION 4.1.3

You can add cost information to USDA foods, now.

VERSION 4.1.2.3

Fixed a problem where clearing the sheet results in an error.

VERSION 4.1.2.2

Upper Limit and Daily Value for copper listed incorrectly, this has been fixed, I strongly suggest downloading the updated version.

VERSION 4.1.2.1

only allows import when another soylent editor spreadsheet is open (trying to import otherwise causes an error)
relocked formula cells and worksheets.

VERSION 4.1.2

Added ability to import recipes from older versions of Soylent Editor (v3 and up)
You can also import recipes from other peoples Soylent Editor spreadsheets (As long as the file name isn’t the same)

VERSION 4.1.1

Fixed an issue where the popup menu doesn’t go away after pressing delete/update/open.

VERSION 4.1

Added clarity to the update/delete/save process.

VERSION 4

Total calories, tutorial, locked portions of the spreadsheet which are not meant to be edited directly.

VERSION 3

I’ve added support for opening, saving, deleting, and updating recipes.
You no longer have to list your ingredients in alphabetical order, Excel will rearrange them for you.
There is also no longer a limit on the number of custom ingredients.

Keep in mind to use the new features you’ll need to open it in Excel, and may also have to disable some security features of Excel.

VERSION 2

Adjusts for: ketogenic diet, pregnancy, age, weight, activity level.
Allows up to 43 custom foods, and contains 8,600 foods from the USDA nutrient database.

VERSION 1

Basic meal editor.
Only includes customs foods.


Soylent Recipe Editor (Spreadsheet) V2
Pictures of my 'Gourmet' soylent
#2

Why not use makesoylent.com? And if it doesn’t fit your needs, why not contribute to its development?


#3

Because I’m extremely busy and my work experience is in VBA and Excel Functions. I can create something like this in a matter of hours, whereas helping with the development of MakeSoylent would be more of a learning process for me, since JavaScript, while I do understand it and can program in it, is not a language I’ve actually worked with.

If there are opportunities to help with the development of MakeSoylent, though, count me in! Reproducing some of the features from my spreadsheet on MakeSoylent I think would have a more lasting benefit than continuing development of the spreadsheet, since anyone can access the internet, but not everyone has MS Office.


#4

Basically we have two Soylent recipe “managers” and one has considerably more traction than the other.


#5

I see no reason why there can’t be more than a single solution.


#6

You are right, there is no reason for there to not be two or twenty.


#7

Mine was thrown together in a couple of hours. My intention was to speed up the process of creating food-based soylents using the USDA nutrient database. If MakeSoylent was more responsive and included foods from this database, then I would use it.

I’m sure looking at the skill of the developer that he would have no problem implementing something to this effect.


#8

Dude, just stick to the one thread. We don’t need three different threads just for different versions of your spreadsheet, regardless of how useful it may or may not be! :stuck_out_tongue_winking_eye:


#9

Because of the way the threads work more people will see it if I post each new one in another thread. It’s useless to anyone but me if no-one sees it, and people are unlikely to be aware of new versions if I simply update the original thread.


#10

Then bump it - let the topic gain its own momentum. Update the title and post updates - continuity in a topic is good for discussion purposes, otherwise the content is constantly shallow, socially speaking.


#11

Can you explain to me how switching the ingredients works? How are the ingredients in the nutrition section connected to the soylent tab? If I input all of my ingredients that I have now, and then want to switch one out, does it have a function to automatically switch all the info, or do I just copy/paste it? (I don’t know much about Excel beyond simple spreadsheets, so I’m not sure if what I want it to do is magic beyond it’s capabilities.

Edit: The link you provided was for skyline. Do I need to get the fully functioning one off of dropbox?


#12

Any ingredient you add to the nutrition facts page you can then select as part of your recipe on the soylent page.

Excel will update all the values automatically when you change/add/remove a food item from a drop-down.

I’ll try to work on it to make it a little more apparent how it’s used.
I’m going to add a link sometime today.

There is no magic beyond Excels capabilities. It can literally do anything.

Here’s the link:


#13

Really, thank you so much for putting this together. Makesoylent is a great resource, but your spreadsheet is going to help me in a more unique way. I’m running into a problem with finding an appropriate carb source because I’ve got a lot of food limitations, so I’m going to be making a soylent without one - but then just eating my carbs throughout the day. (It’s not the point of soylent, obviously, but my goals are a bit different) So I need to be able to easily switch food sources out to see what I’m getting for the day there, and then adjusting my soylent accordingly. (and honestly, I’d think that would be a handy feature for anyone to have who wasn’t eating soylent exclusively throughout the day, to make sure you weren’t going over or under values). Anyway, thanks. Very helpful.


#14

haha, thanks and no problem.
Here’s the new link:

Sorry but I tend to make a lot of changes very quickly and update the sheet about 1/day.

Let me know if there are any issues.


#15

Can you describe the changes with each version? Also…wouldn’t it be more helpful to have a cost/day function rather than a cost/g function? It seems as it is now, I would have to do some calculations to figure out how much my recipe would cost me per day, unless I’m missing something.

Edit: Also, if I input all my data, and you update it/make it better - is there a way for me to export my data from the old to the new, or do I have to re-enter everything?


#16

I guess you’d have to do some addition. You’ll notice I ran out of room in the top-left lol.
I don’t want to fundamentally change the layout so I’ve been having some trouble deciding what to do there.

I’m adding a short tutorial right now, in the next version, which should be up in a few minutes, I’ll also have cost per day.

I think it used to and I ran out of room lol.


#17

There is, and it’s easy, it just wouldn’t be fun to explain to anyone who doesn’t use Excel.
I’ll add an import feature to the next Soylent Editor.

For now here’s the new link with cost/day.


I’ll also add a way to add cost information to USDA foods.


#18

Advice taken. This is now the official Soylent Editor thread.


#19

Changelog is included as part of the post introduction now


#20

You can import from soylentv3 or above now.
It’s completely possible even to download another persons Soylent Editor and import all of their recipes.