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

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

Wormholes

 
  • Topic is locked indefinitely.
 

[Software] EVE Payouts calculator
Author
Previous Topic Next Topic
Merch BAYLOR
Deep Core Mining Inc.
Caldari State
#1 - 2012-07-12 10:25:10 UTC  |  Edited by: Merch BAYLOR
Hello everyone,

I'm posting this app on this forum section since the Wormhole dwellers will likely find it most useful. I have also posted it in the EVE Tech Lab, but I feel the wormhole dwellers are missing out on it a bit :)

Each time you run a sleeper op, you have to do the payouts eventually. At first i had a spreadsheet I made for our directors to make the process easier and less time consuming, but it grew so much that it was getting slow.
So I have come up with this app to simplify things even more.

Link to ZIP file.


Please note that if you do not have MS Office 2010 installed on your system you will need the MS Access 2010 DB Engine. Besides that the application also requires .NET Framework 4.0 to function.

This is the first time this app sees 'the light of the forums', and my first application ever to work with a database behind it, but I will gladly take both positive and constructive feedback into consideration. So don't hold back, if the ideas are good I'll try to implement them.

Short brief on how to use the app:

  • Export fleet loot history
  • Open up the app and load that loot log
  • Choose the prices you want to use for payouts calculation
  • Set the corp tax applied (if any)
  • Add the pilots who participated in the fleet op
  • Edit the payout percentage for pilots if needed (maybe you want alts to receive a reduced share or a pilot did not participate to the entire op?)
  • Hit calculate and then do the payouts!


Screenshots.

You also have a quick guide option in the menus where you can find a lot more details about features.

I'm planning to update the app this weekend and make it resize-able to make it more accessible for those of you running on low resolutions (small laptop users mainly).
Khanh'rhh
Sparkle Motion.
#2 - 2012-07-12 12:20:56 UTC
Not trolling, but how is this more effective than simply selling all the loot, and splitting the total between x pilots corrected for time Y?

The app still asks you to calculate the pilots percentage contribution, which is effectively the same calculation as above but output as a percentage weight and not carried through by a multiplication of the ISK amount.

So, if I could suggest come features:

Add pilot 1 - input time spent on the OP
Add pilot 2 - ^^
Add n pilots

Total up all the time spent then divide it down to work out the weighted contribution of each pilot.

This way, once you had entered n pilots plus the loot log, it would spit out the ISK values with no other calculations.

The general problem with the APP as it is, is people come and go during a lot of longer OPs, so assuming a 100% contribution might end up not saving much time typically.

"Do not touch anything unnecessarily. Beware of pretty girls in dance halls and parks who may be spies, as well as bicycles, revolvers, uniforms, arms, dead horses, and men lying on roads -- they are not there accidentally." -Soviet infantry manual,

Merch BAYLOR
Deep Core Mining Inc.
Caldari State
#3 - 2012-07-12 13:02:01 UTC  |  Edited by: Merch BAYLOR
Khanh'rhh wrote:
Not trolling, but how is this more effective than simply selling all the loot, and splitting the total between x pilots corrected for time Y?

The app still asks you to calculate the pilots percentage contribution, which is effectively the same calculation as above but output as a percentage weight and not carried through by a multiplication of the ISK amount.

So, if I could suggest come features:

Add pilot 1 - input time spent on the OP
Add pilot 2 - ^^
Add n pilots

Total up all the time spent then divide it down to work out the weighted contribution of each pilot.

This way, once you had entered n pilots plus the loot log, it would spit out the ISK values with no other calculations.

The general problem with the APP as it is, is people come and go during a lot of longer OPs, so assuming a 100% contribution might end up not saving much time typically.


To answer your first question, our corp doesn't sell stuff after each op, we stack them up and sell more in one batch (I assumed more corps do the same), and selling multiple op loot at once made it a bit difficult to figure out how much was on each op. Sure we had the loot log, but you would still have to do some additional number crunching to figure out the numbers.

I understand your point of view, but that 100% share value can be edited. So if a pilot only stayed half the op, you can change that value to 50% share, he stayed more, you alter that to more estimate value.
I could make it where you enter the time the pilot spent in the op and take that into consideration when calculating the payout, but it would just be a different format, instead of a percentage of how long of the op the pilot took part in you would have a number representing hours for example.

I'll take look at implementing that in future updates, or maybe add a switch in it, where you choose if you wish to calculate payouts based on percentages or participation time input by the user.
Khanh'rhh
Sparkle Motion.
#4 - 2012-07-13 16:17:04 UTC
Merch BAYLOR wrote:
To answer your first question, our corp doesn't sell stuff after each op, we stack them up and sell more in one batch (I assumed more corps do the same), and selling multiple op loot at once made it a bit difficult to figure out how much was on each op. Sure we had the loot log, but you would still have to do some additional number crunching to figure out the numbers.

Not to tell you how to run your own stuff, but you can make this very easy by just tossing all the loot into a secure container and naming it, and noting who was there for can #1/#2 etc. Sell can #1, plug in, repeat.
Sleeper loot is tiny tiny, so even 10's of billions will fit in a GSC.

I haven't delved into the APP deeply, but what index is it using for sale prices? Buy or sell? Are taxes being counted?

"Do not touch anything unnecessarily. Beware of pretty girls in dance halls and parks who may be spies, as well as bicycles, revolvers, uniforms, arms, dead horses, and men lying on roads -- they are not there accidentally." -Soviet infantry manual,

Merch BAYLOR
Deep Core Mining Inc.
Caldari State
#5 - 2012-07-13 20:46:23 UTC
Khanh'rhh wrote:
[quote=Merch BAYLOR]

I haven't delved into the APP deeply, but what index is it using for sale prices? Buy or sell? Are taxes being counted?


You can choose the Max Buy or Min Sell price from the options. I was thinking to add the median as well, but I thought that most WH corps sell at one of those prices.
You can also select from options what system to take the prices from. Current options to choose from are Jita, Rens, Amarr, Hek, Dodixie. It doesn't take into account sales and broker taxes as I would have to go deeper with the development and implement EVE API support, and I thought it would ask a bit too much from players for just payouts calculations.


PS - I have just propped an update for those already using the app. Run the updater (the updated one in the 7z file not the self extracter I had initially posted as it was broken, apologies for any inconvenience) and you will be asked if you wish to update :)

Screenshots also linked in the main post
Khanh'rhh
Sparkle Motion.
#6 - 2012-07-16 10:11:52 UTC
Perhaps the quick solution would be to add the percentage tax you know you'll face when selling?

"Do not touch anything unnecessarily. Beware of pretty girls in dance halls and parks who may be spies, as well as bicycles, revolvers, uniforms, arms, dead horses, and men lying on roads -- they are not there accidentally." -Soviet infantry manual,

Merch BAYLOR
Deep Core Mining Inc.
Caldari State
#7 - 2012-07-16 18:16:43 UTC
Khanh'rhh wrote:
Perhaps the quick solution would be to add the percentage tax you know you'll face when selling?


Hmm, you're right, lol. I'll add a box/option where users can enter that in the next update.
Thanks!
Gibbo3771
AQUILA INC
Verge of Collapse
#8 - 2012-07-18 15:33:51 UTC
I think most WH'ers out there with half a brain just use a google spreadsheet but this is a nice idea.
Ayeson
State War Academy
Caldari State
#9 - 2012-07-18 15:49:42 UTC
Gibbo3771 wrote:
I think most WH'ers out there with half a brain just use a google spreadsheet but this is a nice idea.


We overcomplicated it, but most could get away with a spreadsheet probs

I ♥ the orthrus
BobFenner
Black Hole Runners
#10 - 2012-07-18 16:22:15 UTC
Yep,

Googledocs does it for me. All I need to do now is figure out how to get the damned thing to automatically update the prices off Eve Central and I am happy.
My missus thinks of EvE as 'the other woman'. :)
Merch BAYLOR
Deep Core Mining Inc.
Caldari State
#11 - 2012-07-19 07:20:54 UTC  |  Edited by: Merch BAYLOR
BobFenner wrote:
Yep,

Googledocs does it for me. All I need to do now is figure out how to get the damned thing to automatically update the prices off Eve Central and I am happy.


I had a spreadsheet which could do that as well. The problem was that it was getting slow. Updating prices for at least 50-60 unique items was kind of slow, and this solution is not. Cool

LE: Besides, this is not the first situation where people used to have spreadsheets, but in time moved to a smoother stand-alone tool. PI tools anyone?Smile
Nebu Retski
Lead Farmers
#12 - 2012-07-19 09:09:54 UTC
BobFenner wrote:
All I need to do now is figure out how to get the damned thing to automatically update the prices off Eve
Central and I am happy.


Don't use eve central for auto updating prices, but use eve market data. Check out the developers page for learning how to import items into googles docs. With a single importXML call you can easily and quickly import 200 items.
Durzel
Questionable Ethics.
Ministry of Inappropriate Footwork
#13 - 2012-07-19 09:14:38 UTC  |  Edited by: Durzel
Use the IG calendar to record who did sites, assume a base cost for combat sites, add a modifier for Mag & Radar, modify for capital or utility pilots (e.g. webbing ships), done.

With the greatest of respect I don't really see why you need to cross-reference loot with up-to-the-minute market prices, etc. So long as the guy distributing the total ISK that actually ends up in the corp wallet is trustworthy I can't see why you can't just do this with a spreadsheet that records who did what sites, and when.

I couldn't care less personally whether I got 205,540,120 ISK for a site or 200m.