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 - Mineral to Ore Counts miscalculated #47

Closed wytsa closed 6 years ago

wytsa commented 6 years ago

uncompressed/compressed values on back-end sheets miscalculated more info to come

FootyMD commented 6 years ago

uncompressed ore is:

=SUM(D31/'Cap Build Requirement Backend'!AN23)

Should be

=SUM(D31/'Cap Build Requirement Backend'!AN23)*100

compressed ore is:

=roundup(SUM(D30/'Cap Build Requirement Backend'!AM24/100))

Should be:

=roundup(SUM(D30/'Cap Build Requirement Backend'!AM24))

gbrann commented 6 years ago

Pushing for hot ticket on 1.1.3 release, I will fix on that version update tomorrow evening. Be as detailed as possible with how it is fixed in current release as dev is widely different. Thank you!!

wytsa commented 6 years ago

formulas for uncompressed ore has been changed to the correct formulas compressed or formula references uncompressed ore value for calculations.

will start work on other backend tabs to finish fixing bug

gbrann commented 6 years ago

Ok, we are NOT doing this hot fix on 1.1.3 as it would be .. hell.

We will push CMM and the Production Modules as quick as we can muster and go from there.

wytsa commented 6 years ago

ore counts on capital and citadel master sheets have been fixed and are in order for later changes.

wytsa commented 6 years ago

uncompressed formula has been changed to: =SUM(D31/'Capital Backend'!BO23)*100

compressed formula has been changed to: =roundup(SUM(B36/100))

this has currently fixed the present issue with the numbers.