Discy mathsFollow

I made a spreadsheet that can predict the GCD and cast time for all our relevant spells when you put in your haste rating, relevant talents and buffs.

Go check it, I think the maths works out but other people checking it can't hurt.

Also tell me if I forgot something important so that I can add it, or if my instructions are unclear or something


I'm also working on a more comprehensive Disc spreadsheet that actually gives useful information and I've given numbers off that recently in other threads but it's nowhere near presentable. And leaves out some spells and such. So more news on that one later.


In other news, I've now mathematically proven that haste softcap for Disc is somewhere between 153 and 154 haste rating with raid buffs and Borrowed Time up.

EDIT: I've been informed that the file format I've saved it in caused problems with MS Excel, I believe this will work better.[/i]

Edited, Jul 8th 2010 6:05am by Kalivha

Fixed the link. I apparently fail at Copy&Paste.


There's no Pivot Table needed. At least I don't think there is.

I have no idea where I would put one in any theorycrafting spreadsheet in any case. The whole combat log analysis comes down to a similar thing, but that goes beyond Excel skills and I'm far from that.

I've used one in my public transportation spreadsheet, for what it's worth.

Ooo Question!

I'm not too familiar to what limitations you have with .ods files (you didn't just jump on the xml bandwagon did you? ) Honestly I just found a converter myself to get it into something excel can read, and all the writing is in dutch or something. I'm hoping that users agreement, if it was one, wasn't written by a wacko, 'cause who knows what I just agreed to do or not do.

Anyway, the question, can you do logical tests in that format? For example, excel gives you the option to do things like: =if(C13>1, C13, 1.0). So if your GCD is greater than 1.0 seconds it will display it, but if it's less than that (0.96 or something) it will display 1.0 instead. Just a thought.

Other than that, I stuck my friend's priest in there and things looked pretty accurate at first glance. Her GCD came out to 1.008, despite the total lack of haste buffs in our raid. So that part at least looks good from what I can tell, and the spell casting times looked familiar.

So for what it's worth, it looks great to a non-priest!

I'm pretty sure this is one I grabbed. I was able to get it open in excel 2003, and to convert to an .xlsx file.

I <3 Sourceforge.

Edited, Jul 8th 2010 10:24am by someproteinguy

...

But what does it do, Holmes?

Is it just me or does any one else keep seeing the title as, 'Dicey Maths'?

edit:

Open Office is teh shiznit.

Edited, Jul 9th 2010 10:33am by Horsemouth