[Calculator] How to tell which equip is better~

So I just finished making a calculator for comparing which of two equips is better for your character. I call it.... the EQUIP COMPARIFIER MARK 1 1.01!


For example:

Should I buy these 10 att 10% dex FaceStompers... or these 5 att 15% dex facestomers?

The answer isn't all that obvious!

So I made the calculator!


Notes:
It does not take MW into account.
It ignores secondary stat. It'll only make a difference when both equips are pretty close to being the same boosts but one has all stat instead of %stat.... but at that point you should probably just buy the cheaper one.

The calculations are a lot harder if I try to account for the additive nature of 4*stat+SecondaryStat.... as used in the damage range formula.



Google Spreadsheet:

https://spreadsheets.google.com/spreadsh...E&hl=en_US
Save this under your own google spreadsheets so you can mess around with it on your own... and that way we don't have two people editing the same sheet:

(I believe you can do this via File->"Make a copy" ... haven't used this before though so i'm not certain)



Localhost:

ChangeThe grey box is in E13, not G12 dur) T.T
http://localhostr.com/file/F8ff3NU/EquipCompare.xls

http://localhostr.com/ is a good one. No wait times or annoying pomegranate for downloaders too

Aha @below, great minds think alike.

http://localhostr.com/

damnitninjadlol

here's the link I got, lemme know if it works... if it does, i'll edit the first post:

http://localhostr.com/file/F8ff3NU/EquipCompare.xls

It works.

Can you make this on google spreadsheets?
I'm currently devoid of any version of office, or any emulator.

Do please and save this under your own google docs/spreadsheet. That way we don't have multiple of you using the same exact sheet:

https://spreadsheets.google.com/spreadsh...E&hl=en_US

for me the gray box isn't on g12, but on e13

Yeah that's a leftover from when I had the chart much bigger... ignore that.

Updated first post

8/13 3:20pm PST:Updated all spreadsheets to fix the error of where the damn grey box is lol. New links posted.

No major impact on anything though

you know, i'm wondering, wouldn't it be possible to make a fully functional calculator? i haven't used excel in ages, so remind me, does it have round floor, round ceiling, and rounding as options?

IT'S CALLED THE EQUIPCOMPARINATOR

you know, i'm wondering, wouldn't it be possible to make a fully functional calculator? i haven't used excel in ages, so remind me, does it have round floor, round ceiling, and rounding as options?

Sure does.... though this is OpenOffice I'm talking about.
FLOOR()
CEILING()
ROUND()

go figure, well, i am lazy, but wouldn't it be possible to do:

main and secondary clean stats

list with all equip slots, if you want to compare, say a new shoulder with a new pair of shoes, leave shoulder and shoe slots at zero.

here it branches, side to side, on one side, 2 lines to put the old shoes and new shoulderpads (implying you bought the shoulder), on the other side, new shoes and old shoulderpads (implying you bought the shoes)

this gives you two results side to side, and you can use the actual damage formula to compare, i'd do it myself but i haven't excel'd in so long, i have forgotten almost everything regarding commands :X

go figure, well, i am lazy, but wouldn't it be possible to do:

main and secondary clean stats

list with all equip slots, if you want to compare, say a new shoulder with a new pair of shoes, leave shoulder and shoe slots at zero.

here it branches, side to side, on one side, 2 lines to put the old shoes and new shoulderpads (implying you bought the shoulder), on the other side, new shoes and old shoulderpads (implying you bought the shoes)

this gives you two results side to side, and you can use the actual damage formula to compare, i'd do it myself but i haven't excel'd in so long, i have forgotten almost everything regarding commands :X

It's a slight bit more of a pain due to a lot of extra stuff that goes into calculating your damage range... it's easy to miss 1. Then we'd get people complaining that the derived range doesn't match their window's range and a bunch of other junk.

So I just went with this method. It's the easiest I can think of.


Also, this is about the extent of what I can do with excel. I'm not an excel user. I just learned a thing or two... the bare minimum to do what was required for a class I had to take.

yea, people are going to miss a lot more stuff, but they can't blame the calculator for that <.<

who knows, if i get off my lazy ass i might try doing it for kicks one of these days.

yea, people are going to miss a lot more stuff, but they can't blame the calculator for that <.<

who knows, if i get off my lazy ass i might try doing it for kicks one of these days.

I guess I can do it tomorrow since I have time.