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

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

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Need help coding a google doc mining fleet log Parser payout spredsheet

Author
Kratomasy Tucker
Xen Investments
#1 - 2013-12-16 21:03:08 UTC  |  Edited by: Kratomasy Tucker
o/
i need help in coding a Google spreadsheet i think i have a good ideal but for coding it is way past what i can do with my basic knowledge of Google spreadsheet so i need your help.

This spreadsheet would be for paying members based on the fleet loot log
so in big its a log Parser

what gave me the ideal of this are two fleet loot log Parser websites but they are missing options
http://sisterofeve.ru/loot_history/#results
http://enfarious.dyndns.org/eve/?page=loothistoryparser

so i started doing a how the spreadsheet should look and feel this is the options that would be nice to have

Pay out option:
- Splitting the ore from the op
- Splitting the ISK from the op.

would have the option of:
- Pulling data from EVE-central
- Pulls players name from loot log
- Pulls all data from loot log
- Add a corp tax
- Op total ore/ ISK result
- Player total mined ore/ISK result and by %
- Paying members op support Ex: pay player that's in a Orca, Rorqual, Hauler, on Security by % or by % time in fleet
- Pulling pay price from station, Region
- Have Detailed Payout
- Compare how much other members of your corp mined compare to you
- See what ore players gathered ech

Why i think it would be nice to code this spreadsheet :

- Would be easy for all mining corps to use
- Gives detailed info results
- Players would get payed for exactly how much skill, modules and ship grade they have and time they pout in with out needing to enter all the info by hand.

- would be one of the most fair way to pay corp members
- would be a past and pay spreadsheet cant be easier for corps to use.

I think we all need a spreadsheet that is as simple as pasting a fleet log and having just a few settings to configure with out passing more time on a spreadsheet than mining in eve.

this is the spreadsheet with no code in it but jest has the tabs and the how it should work comments and feel.

Alpha mining fleet log Parser payout spredsheet