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 - Orders #41

Closed gbrann closed 5 years ago

gbrann commented 6 years ago

Update the following:

'Estimated Cost' should come from backend (Job Costs + Buyback Costs)

gbrann commented 6 years ago

Also need to the following edits:

'Current Costs' = remove the *$B$7 from the formula

'Projected Profit' = add *B## to the formula

This is due to incorrect costs and profits being calculated.

gbrann commented 6 years ago

Renamed Orders to Production Orders

Removed Current Costs from Production Orders,

Estimated Cost now includes Mineral Value for a much more accurate cost calculation. (idk how we missed that part..) Formula is : =SUMIF('Capital Backend'!A:A,A3,'Capital Backend'!E:E)

Changed Projected Profit to : =MAX(0,F3-G3) and color-coded for positive profit. Now shows Projected Profit per 1 vs Order Number.

Added Tier-2 and Tier-3 Hulls to Production Orders.

Sheet is ready for 1.2 release once Tier-2 and Tier-3 Backends are created and pulled.

gbrann commented 5 years ago

Currently working on this.

gbrann commented 5 years ago

We want Current Orders column to be pulled from the Orders tab if Orders!E:E matches Production!A:A AND Orders!B:B has a NO in the cell, then I need to show the total quantity from Orders!F:F.

Basically, as new orders are entered, i.e. Joe Blow orders and Apostle, and the order is NOT complete, then the 1 in quanitity should port over to Production, to show 1 needed Apostle.

gbrann commented 5 years ago

Final Code : =SUMIFS(Orders!$F:$F,Orders!$E:$E,$A3,Orders!$B:$B,"NO")