+- Southperry.net (https://www.southperry.net)
+-- Forum: Maplestory (https://www.southperry.net/forumdisplay.php?fid=15)
+--- Forum: Game Mechanics (https://www.southperry.net/forumdisplay.php?fid=33)
+--- Thread: [Calculator] How to tell which equip is better~ (/showthread.php?tid=45915)
[Calculator] How to tell which equip is better~ - shouri - 2011-08-13
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
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/spreadsheet/ccc?key=0AkCUQeSKpJYLdDFjSlJabHREVWtaVnpBYlpXbjZ0QVE&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:
Change
The grey box is in E13, not G12 dur) T.Thttp://localhostr.com/file/F8ff3NU/EquipCompare.xls
[Calculator] How to tell which equip is better~ - ovation - 2011-08-13
http://localhostr.com/ is a good one. No wait times or annoying pomegranate for downloaders too
Aha @below, great minds think alike.
[Calculator] How to tell which equip is better~ - Jon - 2011-08-13
http://localhostr.com/
damnitninjadlol
[Calculator] How to tell which equip is better~ - shouri - 2011-08-13
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
[Calculator] How to tell which equip is better~ - Jon - 2011-08-13
It works.
[Calculator] How to tell which equip is better~ - Raul - 2011-08-13
Can you make this on google spreadsheets?
I'm currently devoid of any version of office, or any emulator.
[Calculator] How to tell which equip is better~ - shouri - 2011-08-13
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/spreadsheet/ccc?key=0AkCUQeSKpJYLdDFjSlJabHREVWtaVnpBYlpXbjZ0QVE&hl=en_US
[Calculator] How to tell which equip is better~ - ShinkuDragon - 2011-08-13
for me the gray box isn't on g12, but on e13
[Calculator] How to tell which equip is better~ - shouri - 2011-08-13
Yeah that's a leftover from when I had the chart much bigger... ignore that.
Updated first post
[Calculator] How to tell which equip is better~ - shouri - 2011-08-13
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
[Calculator] How to tell which equip is better~ - ShinkuDragon - 2011-08-13
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?
[Calculator] How to tell which equip is better~ - Kalovale - 2011-08-13
IT'S CALLED THE EQUIPCOMPARINATOR
[Calculator] How to tell which equip is better~ - shouri - 2011-08-13
ShinkuDragon Wrote: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()
[Calculator] How to tell which equip is better~ - ShinkuDragon - 2011-08-13
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
[Calculator] How to tell which equip is better~ - shouri - 2011-08-13
ShinkuDragon Wrote: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.
[Calculator] How to tell which equip is better~ - ShinkuDragon - 2011-08-13
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.
[Calculator] How to tell which equip is better~ - shouri - 2011-08-13
ShinkuDragon Wrote: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.