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.
 

Mining Calculator (automatic evaluation of mining events)
Author
Previous Topic Next Topic
Nexuscrawler
Evil Moustache
#1 - 2012-04-19 20:03:59 UTC  |  Edited by: Nexuscrawler
I recently read a thread at eveger, where someone asked about a possibilty to evaluate the amount of ISK that have to be payed to the members of a mining event automatically.

Most of the suggestions here leaded to Excel spreadsheets....but because I am to lacy for that, we came up with this program: http://killboards.de/download.php?f=mining_calculator.zip

The program evaluates the loot logs of a fleet.
It picks out the minerals, assigns them to the members and divides them into Hauler and Miner.

Then it lists a detailed overview of the mined ores, their minerals content, the mined cubic meters and the ISK value of the ores or minerals.
Same procedure with ice and fuel possible.

It also provides an overview of the activities of each member of the event.



How to use this program correct?

Loot logs are pretty stupid ...
If you mined ore, the loot log just contains the time, your name, and the amount of the ore.
If you throw these ore out in a can now and it is collected afterwards, the hauler also receives an entry for these ore in the log.
As the ore would be doubled in the loot log, because you can not tell apart, whether this ore is mined or hauled, you should be sure that there is an ordered structure in your fleet, to not falsify the result.
If you want to use this program, the "switching" between miner and hauler should be taboo in your mining fleet.


After clicking at "Calculate >", you can now also specify in the tab "Calculation and Payout" how the members should be rewarded.


Options are:

Pay everyone the same amount
The ISK value is divided by the number of miners and haulers, and each member receives the same proportion.

Pay miners and haulers based on percentage
Here you can specify how many percentages of the total profit goes to the miners, and how many percent will be paid to the haulers.

Pay based on activity of each miner/hauler
Will pay the members based on their activity WHILE the mining.
This will check the total time of the Miners/Haulers activity and compares it with the total time of the event.

Pay based on ore mined / hauled (m³)
Reward the members based on mined or hauled cubic meters of ore or minerals.

Pay based on ore mined / hauled (ISK)
Reward the members based on the worth of their mined or hauled ore or minerals.



For each of this options, there is the possibility to exclude the haulers from the calculation.
The profit is then distributed only to the miners.
This is useful if the calculation for the haulers is different.

There is also a corporation tax that can be set and is deducted from the calculation.

Another feature is to copy a corporation-mail with the most important information to the clipboard.
That is possible for the English and German language.


Soooo....just my release here, after i got some response at eveger.
Hope you like it.

The clan's are marching `gainst the law, Bagpipers play the tunes of war, Death or glory i will find, Rebellion on my mind.
Galandriel
Vae-Victus
#2 - 2012-05-20 09:56:05 UTC
Pretty awesome little tool. The isk amount looks way off to me though. After mining 1.3 million m3 of ore I'm getting a payout around 20 billion isk. Seems a bit high even for ABC ores. Thoughts?
Nexuscrawler
Evil Moustache
#3 - 2012-05-20 17:48:41 UTC
Well, the prices fetched trough eve-central dont have to be accurate.
You will have to check them before clicking on "calculate".
Maybe you can find the reason for that high ISK amount in the price listing on the first page.

The clan's are marching `gainst the law, Bagpipers play the tunes of war, Death or glory i will find, Rebellion on my mind.
nortelslug
Dune Exploration Co.
#4 - 2012-05-26 06:42:59 UTC
Hey hey!

Love the application, but I have to agree, the math is way out in left field.

doing the math by hand, a mining op from tonight generated:

Mineral refined qty(100%) m^3
Tritanium 10,575,657 105,756.57 m³
Pyerite 2,904,250 29,042.50 m³
Mexallon 1,131,950 11,319.50 m³
Nocxium 86,331 863.31 m³
Zydrine 1,944 19.44 m³

based on the current prices, this should have totaled to 230,098,361.625 on the payout page, but is instead:

21,159,379,851.00 ISK (ore)
21,098,783,171.00 ISK (minerals)

any ideas? (as a wild guess, it KINDA looks like the m^3*price instead of the qty*price)
Nexuscrawler
Evil Moustache
#5 - 2012-05-28 14:20:07 UTC  |  Edited by: Nexuscrawler
Hmm, i see.
Will check that.

Think you can send me the loot log for debugging?

EDIT:
Figured out the problem.
The number format is different in german and english.

German: 1.000.000,00
English: 1,000,000.00

The program has problems with the point as dezimal seperator and includes the 2 zeros to the calculation.
I will change that.


EDIT:

Problem should be fixed.
The program will check the culture info now, before calculating.
Please redownload it and try again.

The clan's are marching `gainst the law, Bagpipers play the tunes of war, Death or glory i will find, Rebellion on my mind.
Nexuscrawler
Evil Moustache
#6 - 2012-06-03 13:02:39 UTC
UPDATE


In addition to choose between the calculation of "Ore" or "Ice" in a loot log, there is now a possibility to calculate them together.
Useful, if a mining fleet has mined Ore and Ice in one event.

Just use the Option "Both" when selecting a loot log file on the first page.

The clan's are marching `gainst the law, Bagpipers play the tunes of war, Death or glory i will find, Rebellion on my mind.
Tonto Auri
Vhero' Multipurpose Corp
#7 - 2012-06-06 10:13:09 UTC
How do you handle container moves?

Two most common elements in the universe are hydrogen and stupidity. -- Harlan Ellison
Nexuscrawler
Evil Moustache
#8 - 2012-06-06 15:21:57 UTC  |  Edited by: Nexuscrawler
To handle the container moves, the members of an event have to be seperated into miners and haulers before calculating the log.
This is done on the first page, right after selecting the log file.

By seperating the members, the program can distinguish which ore has been mined by miners, and which ore has been taken by haulers (out of can)....which would normally double the ore in the log.
For the calculation of the ore, only the ore of the miners will be taken.....cause the haulers did not make any "profit" effectively....they are payed for transporting the miners ores.
But, like written in my first post, if you want to use this program correctly, the "switching" between miner and hauler should be taboo in your mining fleet....otherwise those seperating into miners and haulers would be useless.

The program is also not mentioned for solo mining.
If you mined ore, changed the ship and hauled it yourself afterwards, the miner and hauler would be the same character....but to solve that problem, you could just divide the calculated amount by 2.
Maybe i'll put that in mind for an update.

The clan's are marching `gainst the law, Bagpipers play the tunes of war, Death or glory i will find, Rebellion on my mind.
Nexuscrawler
Evil Moustache
#9 - 2012-06-06 15:23:20 UTC
*double post*

The clan's are marching `gainst the law, Bagpipers play the tunes of war, Death or glory i will find, Rebellion on my mind.
Galandriel
Vae-Victus
#10 - 2012-06-12 09:41:44 UTC
Excellent! After the update the isk values are exact now. Thanks for that! Could we have the option to set the refine % ourselves? I live in a wormhole and we only yield 75% refining rate. Keep up the great work!
Nexuscrawler
Evil Moustache
#11 - 2012-06-12 15:49:29 UTC  |  Edited by: Nexuscrawler
I will add that option to the next Update.
I've Expected this weekend for the next release.

When I have some time for it, i will also write an updater to automate this and don't force anyone into a forum to keep up to date.


EDIT:
Yep, i had some time for it. Smile
New Download will bring an automatic Updater with it.

Link: http://killboards.de/download.php?f=mining_calculator.zip

The clan's are marching `gainst the law, Bagpipers play the tunes of war, Death or glory i will find, Rebellion on my mind.
Nexuscrawler
Evil Moustache
#12 - 2012-06-15 21:42:23 UTC  |  Edited by: Nexuscrawler
UPDATE


It is now possible, to change the Refining percentage at the first form below the Calculation Button.
I also discovered a bug in the Updater, so might be, that you have to download this version via the link....but the Update should work for further releases. (I hope Smile)

The clan's are marching `gainst the law, Bagpipers play the tunes of war, Death or glory i will find, Rebellion on my mind.
Runaway Radiostar
Erda Prima
#13 - 2012-07-11 20:08:56 UTC
I was looking for a simple way to record activity during a mining op and I came up with this on a google search. It's really really simple and easy to use, which is exactly what i was looking for.

I have just one question: Will there be an option included in the future to specify an orca pilot for the payout calculation? It's easy enough now to just subtract a fixed percentage from the total, but an option to include the orca pilot natively in the final calcs would be handy.
Nexuscrawler
Evil Moustache
#14 - 2012-07-13 16:46:12 UTC
You can include a hauler on the first form, but the only option you currently have there, is to add a time of his activity and not the amount of ore he has effectively hauled....I decided, that this would be too much against the automatication purpose.
The thought behind it was: "The more you can add manually, the more you can go back to an excel sheet." Smile

Currently there is no way around that, I'm sorry....I'm looking forward to add that option in the next update.

The clan's are marching `gainst the law, Bagpipers play the tunes of war, Death or glory i will find, Rebellion on my mind.
Runaway Radiostar
Erda Prima
#15 - 2012-07-13 19:59:18 UTC
"The more you can add manually, the more you can go back to an excel sheet."

It's a great way to approach it, and not a worry. Like I said, even an option box to subtract the orca pilot from the total by a fixed % was all i was curious about.

Again, great work!
Sir Striker
Hideaway Hunters
The Hideaway.
#16 - 2012-07-14 07:14:17 UTC
Looks like a great app. Will be trying it in our op tomorrow. Cheers!

Scarly Memore
Legion Of Patriots
#17 - 2012-08-14 21:50:31 UTC
How about possibly changing so you can specify amount mined instead of looking through the logs?
Runaway Radiostar
Erda Prima
#18 - 2012-08-16 17:03:31 UTC
Scarly Memore wrote:
How about possibly changing so you can specify amount mined instead of looking through the logs?


Because there are already 100 programs on the internet that do that. The program here was specifically coded to use the logs.