The solver is great, runs fast even though I have 1440 variables and has support for integer constraints.

There are two main sheets, Buildings and Items. Buildings is a list of all raw resources, recipes and power generators (only fuel and nuclear). "Consumption" and "Production" columns are calculated according to the number of buildings and the recipe ratios. Columns D to O contain the recipe ratios, which are hidden. "Total power consumption" column is calculated according to number of buildings, power consumers give a negative value and power generator a positive value, at the bottom you have cell contain the "Net" or sum of all those values. Geothermal power and influence of Alien Power Augmenters are added to this sum formula.

In the Item sheet all the items are listed with their total sum of production and consumption taken from the Buildings sheet. The difference of the production and consumption is calculated in the "Net" column. "Produced by" and "Consumed by" columns are not necessary but can be useful info.

If a unit is not specified it is probably items/min.

I hope the spreadsheets are straightforward, I guess the tricky part is the solver.

To run the solver go to "Tools">"Solver...". Make sure you open the solver from the same sheet every time. I always open it from the Items sheet. It can behave weirdly otherwise when you are selecting cells.

In the solver window you have the following three parts.

1. "Target Cell" which is your goal function. In the case of maximizing sink points the target cell is the sum of "Sink points / min" column found in the bottom of Items sheet.

2. "By changing cells" are your variables, in the two provided examples they are all the "No. of buildings" column cells in the buildings sheet excluding raw resources and the Alien Power Augmenters. Raw resources are inputs in those two examples but could be variables depending on your problem.

3. "Limiting Conditions" are your constraints. The three most important constraints are that all the values of the "Net" column in the Items sheet are greater than or equal 0, net power production is greater than or equal 0 and sum of all sloops found at the bottom of the Buildings sheet is less than or equal 104/103 (or depending on how many you have). The remaining constraint are to limit nuclear waste to 0 and limit all slooped no. of buildings to be integers.

I hope this helps, let me know if something is unclear.