CMM - Capital Backend 2.0

[gbrann]

Reason for Dev Work Cleaning up the Backend sheets and moving all required computations from the build sheets to the backend, as so to streamline data in modules.

Module Corporate Management Module

Currently we need the do the JFs on the backend. This has been setup in the lower right corner. Just need component data at this time.

[wytsa]

numbers added for: Crystalline Carbonide, Sylramic Fibers, Fermionic Condensates, Ferrogel, Phenolic Composites, Hypersynaptic Fibers, Nanotransistors, Fullerides, Photonic Metamaterials, Terahertz Metamaterials, Tungsten Carbide, Fernite Carbide, Plasmonic Metamaterials, Nonlinear Metamaterials, Titanium Carbide to the buyback backend and to the cap backend.

[gbrann]

Need to add in Needed columns for capital parts, simple formula should be something like:

=SUM(H5*Production!B18-'Material Stock'!C13)

whereas, H5 refers to the Component Needed for that Hull Production!B18 refers to the total number of orders for that hull Material Stock!C13 refers to the total number of components on-hand.

so..

Required x Order Amount - Onhand = Needed

This way the needed amounts for easy management can be done without each and every build sheet being needed.

[gbrann]

Currently working on this.

[gbrann]

Yet another change. As I want the CCM to see a total and not a per item count, (that's what modules are for) then I am changing the new needed column on all cap parts to simply: =MAX(AL40*Production!B37,0)

That example just takes the total needed and times it by how many standing orders are pending.

Later on this backend I will take the total needed per cap part and subtract the total on hand to find total needed to build.

[gbrann]

Capital Component Needed items is done. Holding on closing this ticket until we verify Captial Backend works without issue.

[gbrann]

Need to input Null Buyback Costs and Total Cost into the Jump Freighter area.