Download the Excel file here:
tinyurl .com / yygv3o3r

Download the Google Drive file here:
tinyurl. com / yy7ah9p4

You must download the files or copy the Google Drive file to your own Drive. You cannot edit them directly otherwise. Remove the spaces to download the files, as Steam will not let me link to download sites directly.

If you download the Google Doc, do not edit anything on the Products sheet unless you know what you're doing! Google Docs, unfortunately, does not give me an easy way to lock cells, so you should try to only edit the yellow and gray cells unless you know what you are doing to avoid messing up the formulas. If you accidentally break the spreadsheet beyond your ability to repair it, simply redownload another copy of the original.

If you download the Excel file, you'll notice that everything in the file has been protected except for the gray and yellow boxes. That was done intentionally to prevent anyone (including myself) from accidentally deleting the formulas. If you unprotect the sheets and edit anything make sure you know what you're doing! If you accidentally break the spreadsheet beyond your ability to repair it, simply redownload another copy of the original.

• Make sure you have the Calculators sheet open, not the Products sheet.
  
• Start with the "Goals" boxes on the top. If a store tells you it wants 5 products per every 15 days, put 5 in the first box and 15 in the second. The box underneath those boxes will tell you what your production rate per day needs to be in order to meet the store's demand.
  
• Scroll down to the type of product boxes that the store is requesting. For instance, if the store is asking for Chocolate Cake, scroll down to "Tier 2."
  
• At your type of product boxes, pull down the dropbox in the gray cell and select the product you want to sell to the store.
  
• In the next cell, which is yellow, keep adding factories until the production rate of your product in bold at the bottom of the product boxes is as close to the production rate per day you calculated in the goal boxes at the top as you can get it.
  
• Once you have product production rate more or less equal to the rate you calculated in the goal boxes, note that the boxes above the double lines contain the product's ingredients. For instance, if you put Chocolate Cake in a Tier 2 box, it will tell you that you need to produce a certain amount of Cocoa, Eggs, and Flour per day.
  
• For each ingredient, complete a box for the type of product it is. So if you're making Chocolate Cake, you need to complete boxes for Cocoa at "Farm," Eggs at "Livestock," and Flour at "Tier 1."
  
• For each of the ingredient boxes, do what you did for the product box: try to match the production rate of the ingredient to the production rate the product box told you needed.
  
• If you have ingredients that also have their own ingredients, keep filling out boxes according to the steps above until you have the total rate of production you need of all the raw and farm ingredients.
  
• That's it! Just build whatever numbers of factories or fields and collectors you put into the yellow boxes to equalize the production rates and you'll be meeting production demands while avoiding having warehouses full of water and wheat.

05/16/18 - Version 1.0 - All boxes working, production rates compatible with ROI 1.0.

• Efficiency adjusters for each box.
  
• Pollution rate trackers linked to each type of factory and efficiency rate.
  
• Scrubbing calculating boxes for pollution and pollution types.
  
• Cost trackers for building costs.
  
• Revenue trackers for product types, adjustable by percentages.
  
• Profit and return-on-investment trackers calculated from cost and revenue trackers.
  
• Cost, revenue, and profit trackers that account for pollution scrubbers and efficiency adjustments.
  
• Autopopulating boxes that fill ingredients from the bottom up once a higher tier product is selected.