[WiP] Excell design document

Calculate optimal ratios for feeding recipes, search through the research-tree, specialized tools to view game-information.
Post Reply
The_1ndiegamer
Burner Inserter
Burner Inserter
Posts: 5
Joined: Fri Oct 30, 2015 8:43 am
Contact:

[WiP] Excell design document

Post by The_1ndiegamer »

Heya everyone

This is a document i've been working on for a few days in a google excell document, the intent is to allow people to plan designs and further down the line recipes and research will be added. I made it for myself to get some aid with planning.

Reason for google excell is because i'm not much of a programmer. Got a few things to add and improve. Right now the focus is on getting all the vanilla stuff into the spreadsheet.

https://docs.google.com/spreadsheets/d/ ... =507240676

Coming changes are going to be
- Recipes added
- Outputs for furnaces and the like added (need to tinker around)
- Research list

The tool is currently for planning only, not calculating output.

Hakusho
Inserter
Inserter
Posts: 48
Joined: Fri Oct 23, 2015 2:39 pm
Contact:

Re: [WiP] Excell design document

Post by Hakusho »

Hey there,
i like the idea behind this !
I'm looking forward to see additional updates on this.

A few things i noticed will looking over it:
- Passive provider chest and Requester Chest models are missing borders
- Splitter borders and underground down model borders are displaced(?)

Hope i can help a bit ;)

€dit:
I just noticed i only looked at the "models and performance" page. I might need to take a closer look at it later :)

The_1ndiegamer
Burner Inserter
Burner Inserter
Posts: 5
Joined: Fri Oct 30, 2015 8:43 am
Contact:

Re: [WiP] Excell design document

Post by The_1ndiegamer »

Thank you very much :)

Took a look at what you mentioned and spaced the splitter models. Hopefully this makes things easier. Also fixed the border on the RQ and APC.
Thanks for bringing this to my attention :)

Added a few more things today such as oil production, reorganized liquids to have pipes and storage tanks in the same cathegory. Aswell as added Chemical plant.

Will look into some larger overhauls and move things into more neatly and orderly placement during the weekend. Will try to start getting recipes added this weekend.

Keep the feedback coming :)

Hakusho
Inserter
Inserter
Posts: 48
Joined: Fri Oct 23, 2015 2:39 pm
Contact:

Re: [WiP] Excell design document

Post by Hakusho »

When i looked at the Furnace Setup i feel it can be hard to identify borders and directions.
I don't know if you plan to, but you could give things different background colors to make it more clear.
But i have no idea about the direction thing if you could use one of this guys: ^, <, >, v
I am sure there are better ways for the directions.

The_1ndiegamer
Burner Inserter
Burner Inserter
Posts: 5
Joined: Fri Oct 30, 2015 8:43 am
Contact:

Re: [WiP] Excell design document

Post by The_1ndiegamer »

The furnace setup i made for myself based on a design a saw, but indeed that is a solution, how do you make that downwards pointing arrow, because i could use it for some of the models.

Background colors are a great idea, i'll tinker around with them and see what works and what doesn't. Useability is the main prospect here more than anying else.

Thanks again for the feedback :)

Hakusho
Inserter
Inserter
Posts: 48
Joined: Fri Oct 23, 2015 2:39 pm
Contact:

Re: [WiP] Excell design document

Post by Hakusho »

Uhm, the downward arrow i actually a letter :D :D
V v (on my Keyboard it's between C and B ;) don't know if there are different Keyboard Layouts)

The_1ndiegamer
Burner Inserter
Burner Inserter
Posts: 5
Joined: Fri Oct 30, 2015 8:43 am
Contact:

Re: [WiP] Excell design document

Post by The_1ndiegamer »

Oh lol.... yes , and now i feel like an idiot

Also added some background to the transport belt with directions, tell me how it is now :)

Hakusho
Inserter
Inserter
Posts: 48
Joined: Fri Oct 23, 2015 2:39 pm
Contact:

Re: [WiP] Excell design document

Post by Hakusho »

I think it is better, but i would suggest to put different backgrounds for different buildings.
You could for example make yellow belts bright yellow, yellow inserters a bit darker yellow and so on.
Or are there restrictions? I can't test at the moment.

I Like how you put the in and out arrows on the oil refinery and pumpjack.

The_1ndiegamer
Burner Inserter
Burner Inserter
Posts: 5
Joined: Fri Oct 30, 2015 8:43 am
Contact:

Re: [WiP] Excell design document

Post by The_1ndiegamer »

That's the plan, i'm going to look at the buildings and then give them backgrounds corresponding to their IG colorations same for chests and inserters. Great call on the belts giving them a lighter tone, on it now.

Post Reply

Return to “Cheatsheets / Calculators / Viewers”