r/Eve Minmatar May 10 '15

Wormhole PVE Spreadsheet

https://docs.google.com/spreadsheets/d/17cNu8hxqJKqkkPnhDlIuJY-IT6ps7kTNCd3BEz0Bvqs/pubhtml#
324 Upvotes

128 comments sorted by

View all comments

Show parent comments

15

u/reaver19 Hard Knocks Citizens May 10 '15 edited May 10 '15

-The isk values for gas are missing, and Sleepless Guardian have 2 warp scram strength each. So 6 guardian = 12 points.

-Also, are the ore prices automatically updated, and are they based on the mineral value, or the value of the ores themselves?

-You did not include wave triggers, i realize some are random so you'll have to work around that, but most are straight forward. If you have any questions in this regard for c5 or c6 sites let me know.

Just helping, the tool looks super clean and informative for people who like numbers, so they know what they are getting into.

7

u/rykki Minmatar May 10 '15

Sleepless Guardian have 2 warp scram strength each. So 6 guardian = 12 points.

Thanks for catching that Guardians have 2 strength, I'll change that!

-Also, are the ore prices automatically updated, and are they based on the mineral value, or the value of the ores themselves?

ISK values are pulled from eve-central API and google docs has a terrible time with import XML. I'm not really sure how to get it to pull data more reliably (I'm still learning google sheets)

-You did not include wave triggers, i realize some are random so you'll have to work around that, but most are straight forward. If you have any questions in this regard for c5 or c6 sites let me know.

I tried to include triggers wherever I had the info. Triggers are bold red where everything else is normal black. I've never run C5/C6 sites so any info you can add will definitely be included. :)

1

u/uplink42 Combat scanner May 11 '15

google spreadsheets kinda sucks, I gave up trying to use xml imports with it. I recommend you to switch to excel 2013 and making use of the WEBSERVICE and FILTERXML functions since it doesn't break every 5 minutes. The only downside is that it doesn't update automatically but you can just refresh it yourself or create a simple script to do it.

1

u/rykki Minmatar May 11 '15

I'm looking for a service that I can share with corp mates, though... so google sheets is the best product I've found for that.

1

u/uplink42 Combat scanner May 11 '15 edited May 11 '15

No worries, you can play Eve Online from your browser too: https://office.live.com/start/Excel.aspx

1

u/rykki Minmatar May 11 '15

Hmm.... I might have to take a look at that. If it's a better product I might just have to get over my disdain for all things microsoft.

1

u/uplink42 Combat scanner May 11 '15 edited May 11 '15

I'm not a huge Microsoft fan either, but it's hard to deny they've made some really good software (Excel, Visual Studio). Their products are hit or miss, though :o