These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

Yet another Mining Op Spreadsheet (Mining Paycheck V0.7)
Author
Previous Topic Next Topic
Lisbeth Hancook
Institute of Applied Astrogeology
#1 - 2015-09-22 13:12:59 UTC  |  Edited by: Lisbeth Hancook
Hi Capsuleers,

i've made a spreadsheet Roll, to easily calculate payout of Mining Operation members.
The calculation includes mining time and the mining yield of the specific miner.
You can adjust various things, such as orca pilot skills, refiner skills, security, ship loadout etc.

So if you running a small Mining Op, you may find this useful, feel free to use (just create a copy and use it).

Mining Paycheck V.07

Fly save o7
L.Hancook

P.S. I'm much appreciate for any suggestion or point out errors in calculations!

Known-Issues:

  • Delta-time passing midnight.
  • The ingame ore/minerals values are rouded, on higher values there is divergence between ingame refining yield and my spreadsheet. Maybe someone has the correct value?


Todo:

  • Mining Drones
  • Gas
  • auto load eve-central prices


Update:

  • 24.09.15 added ice and gas calculations
GODS H4ND
Imperial Shipment
Amarr Empire
#2 - 2015-09-22 14:04:08 UTC
Will take a look now. I was also considering putting something together for this but haven't yet had time.

Might give it a crack this evening :)
Lisbeth Hancook
Institute of Applied Astrogeology
#3 - 2015-09-24 15:22:32 UTC
-Added Gas and Ice calculations.
-Some smaller fixes
Mr Grape Drink
Doomheim
#4 - 2015-09-24 15:30:48 UTC  |  Edited by: Mr Grape Drink
Might want to protect the cells that shouldnt be changed before somebody breaks something :)

Ore-ventory

you missed an E on Zydine!

When scrolling to the right to look at stuff like the high ends, you lose the stuff on the left like what minerals the numbers match up to and such. Maybe freeze the first column to fix
Lisbeth Hancook
Institute of Applied Astrogeology
#5 - 2015-09-24 15:38:08 UTC  |  Edited by: Lisbeth Hancook
Mr Grape Drink wrote:
Might want to protect the cells that shouldnt be changed before somebody breaks something :)

Ore-ventory - you missed an E on Zydine!


I did, but somehow it does not work atm... (it is the copy anyways)

Edit: good point, I fixed the 2 columns