Vontre's Mage DPS Spreadsheet - Page 29

Hudini · 02/04/08, 12:42 PM

Anyone else having trouble downloading the spreadsheet? I think the homegirlsguild.com domain name expired today, Vontre. Anyone have a mirror of the current spreadsheet up somewhere?

Vontre · 02/04/08, 12:50 PM

I'm working on uploading to a new domain, hold on.

Vontre · 02/04/08, 12:53 PM

Here we are.

http://www.starlinkmmo.net/mage_dps.zip

Vontre · 02/04/08, 6:31 PM

Bah, I'd been waiting for someone to improve the interface a little bit but oh well. It's BETA hahaha. Here.

http://www.magegraf.com

Simulator type thing. It makes graphs. It should have enough output modes to verify accuracy as well. Let me know about any bugs or problems. Oh and you can click on the bolded texts to open/close objects. No it doesn't save those for you, sorry.

Kavan · 02/04/08, 7:34 PM

I haven't done any number checking yet, but one thing strikes me as having potential problems in general modeling. You can get away with greedy optimization in most cases, but one case where that won't be sufficient is spell selection. The arcane specs don't seem to be working yet, but I'm just wondering how you plan to select different spell cycles during different cooldowns for arcane.

Akuman · 02/04/08, 7:55 PM

Hello Vontre.

First of all, thanks a lot for your work regarding theorycrafting, spreadsheet modeling, and the recent graphs.
They have all helped me understand theorycraft to a higher level, and ultimately made me a better mage.

Second of all, I was wondering if you could implement two cells in the gear selector sheet that display your hp and mana.

I do understand that you display intellect, and that stamina has nothing to do with the way you model your dps.

Nevertheless I use your spreadsheet to help me choose which gear would suit me better, and find it better once I add two cells that calculate my hp and mana.

I do realise this could be misinterpreted as a selfish move that allows me to be lazy and not change every updated version of your spreadsheet, and satisfy my demands at the same time.

However, I do believe that this addition to the spreadsheet could benefit other users of the spreadsheet, and perhaps would promote new novice users to use the spreadsheet to make better decisions regarding choices in game.

Third of all, I have noticed some small errors in the spreadsheet regarding the item database.
- There seems to be around 8 extra band of eternity rings listed, which all have +37 stamina and no other stats.
- Maelstrom's Fury does not seem to be included in the item database.
- Some epic gems have not been added
- Noble Veiled Topaz and Great Dawnstone do not have their names attached to the gems

I hope you don't take offence and don't stop theorycrafting

Stirius · 02/05/08, 3:49 AM

Originally Posted by Vontre

Bah, I'd been waiting for someone to improve the interface a little bit but oh well. It's BETA hahaha. Here.

http://www.magegraf.com

Looks very promising. Thanks for your work.

I noticed a strange thing about the "cast sequence" for the "fire" build:
"Fire Vulnerability (from another mage)"=off, cast sequence reports 3xscorch then fireball until death, no reapplying of scorch
"Fire Vulnerability (from another mage)"=on, cast sequence reports only fireball (correct)
"Fire Vulnerability (from another mage)"=on, "encounter duration" > "New target" results in 3 scorches for each new target (but not for the first target)

Baruk · 02/05/08, 4:31 AM

Hey Vontre, thanks for the marvelous work. However one thing is unclear to me..
Does "Stats (without trinkets)" mean that also the passive stats should be ignored?
I just ask because iirc in your spreadsheet the passive stats counted as base stats and only the "active" part
was part of the "trinket".

edit: bad wording. Clarified

galzohar · 02/05/08, 5:05 AM

I thought the spreadsheet assumes you included the static damage from the trinkets in your spell damage and only model the "use" effect... Isn't that the case?

manly · 02/05/08, 1:31 PM

The spreadsheet assumes you input passive stats from the trinkets, and the options are for the procs themselves. However, the web tool assumes you don't enter passive stats from trinkets. You can see the passive stats are removed if you use the import option.

The web tool always assume 2 fire mages. Hence why only 3 scorch.

Baruk · 02/06/08, 9:33 AM

True, couldn't test the import yesterday as armory seemed to be down...

thanks anyway for clarifing

Cryic · 02/10/08, 10:01 AM

Vontre,

Much thanks for your continued hard work. Couple quick questions: When did you create the new web tool? I've been following your spreadsheet for a while and use it to whack my guildies over the head with

Will your web tool have an option to turn on spell pushbacks for the simulator? The reason I ask is because one of the bigger advantages that I see for spell haste is reducing the amount of time you spend in the .5 to 2.5 <or whatever your cast time is>, increasing the value of spell haste even more.

Also, it would be awesome if your web tool showed the relative values of spell damage = haste = hit = crit.

Thanks again for all your work!

Sguz · 02/10/08, 1:12 PM

Hi,
I appriciate your really nice work.

As I see the new Items of 2.4, i want to have them in your xls. How do I include them to your xls? Just paste in the Stats and Names in for example for the new t6 wirst I go to the tab "Wrist" and add the name and the stats? Or ist there an easier way? (I dont want to wait till they are included)^^

Thx

Vontre · 02/10/08, 10:33 PM

Originally Posted by Sguz

Hi,
I appriciate your really nice work.

As I see the new Items of 2.4, i want to have them in your xls. How do I include them to your xls? Just paste in the Stats and Names in for example for the new t6 wirst I go to the tab "Wrist" and add the name and the stats? Or ist there an easier way? (I dont want to wait till they are included)^^

Thx

Easiest way is to find some crappy item in the list that you'll obviously never use, and replace the name and stats.

Aswen · 02/12/08, 9:53 AM

Vontre.. I love this spreadsheet. Thanks for the the effort you've put into building it.

Here's a little VBA macro to import Armory data into Excel 2003. I've tried to make it work the same as if you did a copy and paste.

Paste your character sheet URL into cell E6 and then run the macro. You could even stick a button on the page if you wanted to be really user friendly.

Sub importArmoryData()

' Switch to the armory tab incase you run the macro from somewhere else
Application.Sheets("Armory").Select

Dim url As String
' E6 here is the cell where your character sheet url is
url = Application.Range("E6").Text

' E19 is where we're going to stick the data
Application.Range("E19").Select

' Open a XMLHTTP connection to the Armory URL and get the Reponse
Set XML = CreateObject("Microsoft.XMLHTTP")
XML.Open "GET", url, False
XML.Send
response = XML.responseText

' Split the reponse by line breaks and dump it into excel
Dim strArray As Variant
strArray = Split(XML.responseText, Chr(10))
For i = 0 To UBound(strArray)
    ActiveCell.FormulaR1C1 = strArray(i)
    ActiveCell.Offset(1, 0).Select
Next i

Set XML = Nothing

End Sub