My budget tracking solution still lies in Google Sheets because it contains so many formulas that break when converting to .ods that I’ve been putting it off for about a year now because it will be a lot of work to recreate properly in LibreOffice Calc. So I can’t share a full solution with you.

I can help you consolidate your categories into a drop-down though! I recommend creating a new sheet within your workbook that you can hide/unhide as needed to edit your behind-the-scenes information like categories. Step 1 is to add your list of categories somewhere in the sheet like this:

Step 2 is to define the range of categories so that it’s easier to use in formulas later. Highlight all the categories, then select Sheet > Named Ranges and Expressions > Define, and give it a name (I use “categories”):

Step 3 is to set up your main sheet to use the new list. Highlight the cell where you want the drop-down list to be, then select Data > Validity > Allow = Cell range > Source = “categories” (or whatever you named your list) > OK:

You should end up with something like this:

Great looking ship!

You will be able to interact with landfill like any other entity. It will not be tied to the super force building feature. You can see this in the second to last gif where landfill is manually removed by tile and also by deconstruction planner. They always wanted to add the option to remove landfill but the extra work it would take to fix the code to make it possible made them put it lower on the priority list, but with the introduction of super force building they were kind of forced to address the landfill problem.

That’s a good one! An alternative that does the same but gives you a bit more time to correct the issue before you run out of fuel is to use a chest to buffer the belt. Set up the speaker to alert when the chest is no longer full (indicating belt is no longer saturated).

This solves some of the most frustrating limitations of 1.1. These updates just keep getting more and more exciting, and we still have quite a while until release.

I am stoked for this one almost as much as I am about the new robots! Total game changer for rails.

This has always been one of the most frustrating things, especially in online servers.

Ferrule

Personally I have the most fun starting over whenever I reach a point in the game where I am asking myself that same question. Have you tried out any of the bigger mods like Space Exploration? I’ve heard SE is like a whole new game by itself.