DPS Craft: Warriors/Knights

[Creep]

Am I doing somethign wrong?

Every time I click Run on the EP calculator I get an error relating to Sheet2.

Im assuming you need to use this run function to get some sort of calculation out.

[Ezmode]

I more than likely broke the EP macro when I inputted the gear lists in as it doesn't sort the gear at the moment. I am working on expanding the gear lists and updating the macro so it works as intended. Just in case, could you perhaps take a screenshot of the error so I can make sure it is what I believe it is?

Another thing is, I would like some tanks to give the spreadsheet a run if possible. I know some abilities/talents for tanks aren't in properly, specifically Sonic/Blade Barrier and Crushing Blow/Guardian Slash and hope to work on them very soon. Any other input on the Effective Health calculations would be greatly appreciated as well. I mainly did that from researched material and I am not sure if it is correctly applied.

[zaelem]

Yeah I can't even do a Juggernaut(or Republic) spreadsheet, everything breaks down. Marauders work though.

[Ezmode]

Breaks down how? Could you post a screenshot please. Also, if you are getting #N/A all over the place, that is because you have to reselect the gear so you are using Heavy Armor instead of Medium Armor.

[Lazy]

When I tried using the spreadsheet, after selecting Empire Juggernaut, Shien Form was not located under the Form dropdown.

EDIT: Think I figured out why some people that try to Juggernaut are broken, at least this was the problem for me. After opening it near the top was a Security Warning: some content has been disabled with an Options button. Clicking that I selected Enable this content. Seems to work fine now as far as setting up what Juggernaut forms for Vengeance/Rage.

Different question, was wondering how you setup gear that we obtain through leveling and put better Armoring/Mod/Enhancement?

[Creep]

(01-23-2012 02:05 PM)Ezmode Wrote:  I more than likely broke the EP macro when I inputted the gear lists in as it doesn't sort the gear at the moment. I am working on expanding the gear lists and updating the macro so it works as intended. Just in case, could you perhaps take a screenshot of the error so I can make sure it is what I believe it is?

Another thing is, I would like some tanks to give the spreadsheet a run if possible. I know some abilities/talents for tanks aren't in properly, specifically Sonic/Blade Barrier and Crushing Blow/Guardian Slash and hope to work on them very soon. Any other input on the Effective Health calculations would be greatly appreciated as well. I mainly did that from researched material and I am not sure if it is correctly applied.

[Ezmode]

(01-24-2012 11:16 AM)Lazy Wrote:  When I tried using the spreadsheet, after selecting Empire Juggernaut, Shien Form was not located under the Form dropdown.

EDIT: Think I figured out why some people that try to Juggernaut are broken, at least this was the problem for me. After opening it near the top was a Security Warning: some content has been disabled with an Options button. Clicking that I selected Enable this content. Seems to work fine now as far as setting up what Juggernaut forms for Vengeance/Rage.

Different question, was wondering how you setup gear that we obtain through leveling and put better Armoring/Mod/Enhancement?

Enabling content is very key, I'll add a giant line in the OP next time, thank you for reminding me.

Also for the gear through leveling, I finished adding mod lists for all epic mods (there are too many Prototype/Premium quality ones to type out). I have some small issues to deal with with perma-Armor modded gear and Orange gear (need to find an easier way to pick one cell over the other without making the formula too cluttered, I will have it for the next release).


Creep, thank you. I believe I found what the problem was and made some changes, hopefully it was right, but we won't know for sure until someone tests it after I'm done with other changes.

[Mertox]

Can't seem to get this to finish loading with OpenOffice

[Ezmode]

I haven't even began considering use for OpenOffice. I want to fix the overall layout and structure before I do that. Honestly, I'm not even sure what I would have to do for it to be compatible, so it requires research and more self-teaching.

[Lyra]

Very impressive spreadsheet Ezmode Keep up the good work, spreadsheets like this are so damn useful! GJ