The SPIDER - Power Data Standardization 3.0 (i12)


LJHalfbreed

 

Posted

Hi!

How are you?

I am fine.

After getting the powerup and beating the game of the Unpossible Market, I have decided to delve deeper into the game mechanics.

Which is, quite humorously, the exact opposite of what people desire. I'm terrible at the maths, and have difficulty counting past twelve without removing my socks and shoes.

However, now that the new VEATS have been out for a bit, and some of us number crunchers (ok... YOU numbercrunchers)like having an easy-to-reference guide for all things related to the main numbers behind powers, their datum, and standardization thereof.

Unfortunately, Iakona has taken a leave of absence, and not all of this information is easy to reference in that awesome other-reference on the web, Red Tomax' City of Data.

So, I'm running numbers to learn more about the game. Feel free to laugh or cry or whatever.

So, in the spirit of Iakona's previous endeavours (located here), I now present to you,

the SPIDER.

Most of the information is cross-referenced throughout each sheet, but I'm afraid my main strengths lie within the evil Excel, and not so much OOO's Calc. I've left all of Iakona's commentary in, and added my own to explain some of the various numbers/calcs/formulae/etc.

However, I've tried to make two separate versions available. One usable through Excel, the other through Calc. Some minor problems might reside on either, but hey, at least I got both drop-downs to work correctly.

So, without further ado, for all you number-types out there, I humbly present to you the new SPIDER worksheet for Power Data Standardization. Or somesuch.

SPIDER 1.2, Excel 2003 style
SPIDER 1.2, OOO style

I'd advise using the excel version, but I'll try to learn more about how calc works so I can have both running. Unfortunately, due to the data involved, googledocs seems to hate any sort of uploading of the file, and tends to crash when cut-n-pasting past a certain filesize.


INSTRUCTIONS
As per Iakona's setup (found here) all you really have to do is punch in the desired level, and then choose the 'class' you wish to view from the drop down. The sheet should auto-populate everything relatively quickly, and allow you to view such things as the average melee damage of a lvl35 archvillain or a lvl 50 Controller, or almost anything you wish. Keep in mind that some things aren't meant to be over 50, so some errors may crop up.

Again, nearly all of the actual information for these numbers can be found in Iakona's original thread (here), but as this is mainly an update/upgrade to Iakona's work, I feel it unnecessary to parrot everything everyone said in that previous thread.

Please contact me via this thread or by PM to let me know if there's any problems with the shared files above, or if you have any suggestions or comments.




The Caveat
To put it quickly and simply, if it works and you like it, credit goes to Iakona. If it's all yucky and broken and don't work right, blame LJHalfbreed.

Thanks for your time, and happy CoX'ing!