search

gbrann / EVEProductionSuite

Eve Online - Production Suite is a set of Google and ESI tools to quickly and easily manage production, budget and basic corporate management with installing servers or adding any RL costs to your game play.
GNU General Public License v3.0
3 stars 0 forks source link

CMM - Add Job Costs to backend #38

Closed gbrann closed 6 years ago

gbrann commented 6 years ago

We want to add job costs to the backend as the main suite will no longer house production sheets. These will be moved to modules. For this reason, Orders needs to pull information from backend sheets.

gbrann commented 6 years ago

Job Costs calculated on Capital Backend. Had to find the estimated value of each component, than add the total for each build. Also needed to find the Mineral Amounts per build, and the value of minerals for each build. Once that was finished we did the formula as such:

=SUMIF('Corporate Fleet'!A:A,A11,'Corporate Fleet'!B:B)+Z31+AJ31*Configuration!$B$11-Configuration!$D$11+Configuration!$E$11

At this time, Tier-1 and Structures needs to be completed, as well the the new backend sheets for Tier-2 and Tier-3.

gbrann commented 6 years ago

Merging with Capital Backend 2.0. The new backends will have this feature.