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

Change Buyback for new AMC Style #30

Closed gbrann closed 6 years ago

gbrann commented 6 years ago

The idea is simple, use weight and times to calculate the weekly buyback payouts to active miners. The sheet will be a backend where a simple Google Sites or Google Form is used to input the data into the sheet. The Sheet can then pull from Week Numbers to show who gets what paid out.

I'm basing this on the AMC Buyback sheet. I want it to be simple and easy to use.

gbrann commented 6 years ago

Added Gases, Moon, Compressed and Raw values for Ice and Ore to current Ore Buyback sheet.

Renamed Ore Buyback to Buyback Values

Redesigned Buyback Values Sheet.

gbrann commented 6 years ago

Using =IMPORTRANGE(Configuration!$B$2,"Buyback Values!D22") where it pulls the sheet's ID number from a new tab called "Configuration", the second part of the formula pulls from the location specified on the Production workbook.

gbrann commented 6 years ago

Refining Yield Modifier (1 + (Structure Bonus/100) Structure Security Modifier (1+ (Refining Skill level .03)) (1+ (Reprocessing Efficiency skill level .02)) (1+(Ore specific/ice processing skill level .02)) * (1 + (Processing Implant Percentage/100))

gbrann commented 6 years ago

@wytsa We need the weight number in Participation to go off the values set in Configuration based on what ship they select in the drop down. Care to assist?

wytsa commented 6 years ago

formulas for "weight number in participation" has been set and tested for use.

gbrann commented 6 years ago

Released as EPS Buyback Module v1.0