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

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

Missions & Complexes

 
  • Topic is locked indefinitely.
 

Exploration/Wormhole Spreadsheet

Author
Brian Halleck
Federal Navy Academy
Gallente Federation
#1 - 2012-03-13 01:14:27 UTC
Hey fellow EVE players,

I just recently began playing EVE and have so far do not have one complaint; something that I think will change relatively soon if the forums are any indication. What? Anyways, I have taken to exploration in particular, and have just gotten into a Vexor equipped with everything an explorer could want. After roaming around for a few days, my wallet has had the good fortune of staying in the black - even after growing a pair and praying my way through low security space to reach a high security cluster.

The EVE community is fantastic with providing noobs like me information that will help me not only decide what I want to do, but excel in doing it. After some forum reading and googling, I have come to understand why some call this game Spreadsheets Online. I have found more spreadsheets for activities I know exist in this game. After some intensive searching, though, I have been unable to find a sheet that is geared towards exploration.

I've taken it upon myself to create one. I'm no expert in Spreadsheets Online yet, but I do think that others may want to use what I made this afternoon. It's basically just a profit calculator that factors in the time it takes to scan down and clean out anomalies, accounting for possible bounty rewards. It breaks down each individual site and then gives a total ISK/hour rate as well.

You do have to enter in the scanning time, the amount of time it takes you to clear each site, what drops in each site, and how much bounty you've collected at each site (if there is a bounty to collect). There is enough room to enter in 16 different exploration sites. I figured this is large enough even for wormholes, though I may expand it in the future. It's not anything like Dedaf's Industrial Tool (major kudos to Dedaf) where it utilizes the API code and has fancy drop down menus for selecting items, but it gets the job done nice and easy.

Anyways, here is the link to the spreadsheet. It was done in Excel 2010.

Any criticisms and suggestions would be wonderful.


Thanks,

Brian Halleck
Broken Thoughts
Caldari Provisions
Caldari State
#2 - 2012-03-13 01:40:19 UTC
inb4 "random drops are random" and "exploration isnt about isk/h"
Brian Halleck
Federal Navy Academy
Gallente Federation
#3 - 2012-03-13 01:51:44 UTC
Broken Thoughts wrote:
inb4 "random drops are random" and "exploration isnt about isk/h"



I can see that being an argument seeing as how I made 16,000,000 ISK in one Radar site and 500,000 ISK in the next one. This project started out as a way for me to monitor how long it takes to scan/clear exploration sites to chart my progress, and it ended up being something that charts everything I can think about exploration right now. Sure, the ISK/hour will never be constant among most everything else in exploration, but that doesn't mean you can't track it!
mxzf
Shovel Bros
#4 - 2012-03-13 02:29:50 UTC
If this is about personal book-keeping to figure out what sites are more often worth the time then that's fine. However, as the previous poster mentioned, exploration can't really be boiled down to ISK/h. Due to the randomness of the drops, the standard deviation of ISK/site is so insanely large that any statistical analysis of ISK/h is completely meaningless.
Brian Halleck
Federal Navy Academy
Gallente Federation
#5 - 2012-03-13 03:43:52 UTC
mxzf wrote:
If this is about personal book-keeping to figure out what sites are more often worth the time then that's fine. However, as the previous poster mentioned, exploration can't really be boiled down to ISK/h. Due to the randomness of the drops, the standard deviation of ISK/site is so insanely large that any statistical analysis of ISK/h is completely meaningless.



You hit the nail on the head there. The Profit/hour aspect of the sheet comes in at (literally) the end. It's mostly about keeping track of efficiency in scanning and clearing sites and what sorts of sites are worth doing more than others.

For instance, this has helped me to realize that combat exploration sites (Serpentis Dens, Hideaways for instance) are not worth the amount of time it takes to clear them with my current skills. The chance for escalation is larger than my chance of actually living through one.
Powie XIII
Center for Advanced Studies
Gallente Federation
#6 - 2012-03-13 05:58:31 UTC
Want efficiency? It's simple, DO NOT RUN drones sites and Hisec Mag sites.

For everything else it's up to you.

Want statistics? Ask St. Mio. She logs every site she runs, and i tell you it ain't pretty.

“They see me trollin', they hatin'”

St Mio
Imperial Academy
Amarr Empire
#7 - 2012-03-13 06:33:05 UTC
Want loot? Spoof your name so that the game thinks you're Powie :D
Brian Halleck
Federal Navy Academy
Gallente Federation
#8 - 2012-03-13 07:19:46 UTC
Well, based on what I've seen so far, drone sites have some nice salvage and mag sites have been rather generous to me as well.

Though it may very well be a rare thing, seeing as how much of exploration looks that way.
Keilateau Shakor
Shakor Freight and Mining Service
#9 - 2012-03-13 09:46:00 UTC
Powie XIII wrote:
Want efficiency? It's simple, DO NOT RUN drones sites and Hisec Mag sites.

For everything else it's up to you.

Want statistics? Ask St. Mio. She logs every site she runs, and i tell you it ain't pretty.

Got three Intact Armor Plates in a row from three mag sites, in a single highsec system. Just saying.
mxzf
Shovel Bros
#10 - 2012-03-13 16:11:20 UTC
Keilateau Shakor wrote:
Powie XIII wrote:
Want efficiency? It's simple, DO NOT RUN drones sites and Hisec Mag sites.

For everything else it's up to you.

Want statistics? Ask St. Mio. She logs every site she runs, and i tell you it ain't pretty.

Got three Intact Armor Plates in a row from three mag sites, in a single highsec system. Just saying.


But how many sites did you run where you didn't find any? This is exactly the kind of thing I'm talking about with regards to the MASSIVE standard deviation in exploration drops.
Keilateau Shakor
Shakor Freight and Mining Service
#11 - 2012-03-13 17:07:21 UTC
Tens, if not hundreds. Not lately though. I find the hisec mag sites worth doing. I am not contradicting your point. I am merely pointing out Powie's mistake where he advises to skip hisec mag sites.
El Deuce
The Scope
Gallente Federation
#12 - 2012-03-17 14:27:22 UTC
do em all, the jackpot nature makes it fun :) If i have to choose I take drone sites last though. the sometiems give tasty salvage, but they seem to take longer than mag/radar sites and pay less that rated combat plexes

feel free to use my very detailed formula for fun in eve:

pvp > exploration > scrubing the toilet > ratting > scrubbing grandma's back.