I need some help with two different projects to make a useful Aurora planning tool, which I will share freely. (Yes, I get the irony.)
My sheets currently allow you to :
- Enter several component types attributes for reference.
- Enter missile Range\WH\Sensors\Speed for reference
- Calculate combined missile salvoes for Time on Target for different speed missiles.
- Enter counts of up to 18 different components for up to 3 different classes of ships that shre those 18, and get the total number of each component to prebuild, and
- Given a %of your total industry available, the percent to assign to each component to have them all finish on time. This one allows you to vary the # and cost of each component, but not yet the # of each kind of ship. (4,4,1 currently)
- Enter the desired end facilities of a colony, cargoship capacity and ship numbers, and find out how much minerals to ship in to have enough to build it all, as well as how many of each mineral in each trip. This is basically done.
Currently, Im having trouble turning these disparate sheets into one Planning tool. Can anyone provide advice\help?
What Id like to end up with is that you enter components as you design them, select each in a dropdown listing for each ship, somehow save those ship invoices, then go to the squadron sheet, enter how many of each ship, and get the preplanning #s and percents, with a spot to enter on-hand numbers for each component to cut down on overproduction, while also incorporating a version of the missile planner.
File is in Excel 2010 format, zipped.