Forum Settings
       
Reply To Thread

Discy mathsFollow

#1 Jul 07 2010 at 11:05 AM Rating: Excellent
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
#2 Jul 07 2010 at 11:21 AM Rating: Excellent
****
4,074 posts
Error, file not found.

I hate math. But I adore spreadsheets. Is there a pivot table? You need a pivot table.
#3 Jul 07 2010 at 11:46 AM Rating: Good
Fixed the link. I apparently fail at Copy&Paste.


There's no Pivot Table needed. At least I don't think there is.
#4 Jul 07 2010 at 12:23 PM Rating: Excellent
****
4,074 posts
That's like saying frosting isn't needed. Of course it's not needed. But it's awesome.
#5 Jul 07 2010 at 1:12 PM Rating: Good
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.
#6 Jul 07 2010 at 1:18 PM Rating: Excellent
****
4,074 posts
Kalivha wrote:
I've used one in my public transportation spreadsheet, for what it's worth.


Okay then, you're excused.

I want to look at your spreadsheet, but, my daughter? Left the bathroom sink running? With the drain stopped? So I have to go dry the ceiling below it with a hair dryer now. I will have to educate myself on Disc math later.
#7 Jul 08 2010 at 10:27 AM Rating: Excellent
Meat Popsicle
*****
13,666 posts
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? Smiley: oyvey) 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. Smiley: frown

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! Smiley: thumbsup
____________________________
That monster in the mirror, he just might be you. -Grover
#8 Jul 08 2010 at 11:03 AM Rating: Excellent
****
4,074 posts
Yeah, I can't get anything I have to open it.
#9 Jul 08 2010 at 11:22 AM Rating: Excellent
Meat Popsicle
*****
13,666 posts
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. Smiley: lol

Edited, Jul 8th 2010 10:24am by someproteinguy
____________________________
That monster in the mirror, he just might be you. -Grover
#10 Jul 08 2010 at 11:41 AM Rating: Good
Thanks Protein, I actually implemented that. Made C15 the FHeal/BHeal cast time and used the IF function in C13. It looks like this: =IF(C15<1; 1; C15)

I was too lazy to look into that earlier, I suspected it was possible, thanks for the pointer.

I attached an XML file at the end of the OP, btw. Checked it in Excel as well, it's functional.
Edit: I don't use Excel because I haven't got a legal copy of MS Office and Open Office does the job, plus it comes with standard fonts that can do IPA and such. Usually saving stuff in MS compatible formats doesn't damage the files at all, either. I just forget sometimes.

Plus the whole thing is free! And in my opinion much easier to use than the newest incarnation of MS Office.

Edited, Jul 8th 2010 5:46pm by Kalivha
#11 Jul 08 2010 at 2:32 PM Rating: Decent
****
4,684 posts
...

But what does it do, Holmes?
#12 Jul 08 2010 at 5:10 PM Rating: Good
What, that function?

If over haste cap, it shows the GCD as 1 second.
#13 Jul 09 2010 at 2:22 PM Rating: Good
****
7,732 posts
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
____________________________
Hellbanned

idiggory wrote:
Drinking at home. But I could probably stand to get laid.
#14 Nov 03 2010 at 3:08 PM Rating: Good
****
7,732 posts
Can you reput up the sheet.

I want to modify it to the current state of things.
____________________________
Hellbanned

idiggory wrote:
Drinking at home. But I could probably stand to get laid.
Necro Warning: This post occurred more than thirty days after the prior, and may be a necropost.
Reply To Thread

Colors Smileys Quote OriginalQuote Checked Help

 

Recent Visitors: 107 All times are in CST
Anonymous Guests (107)