Debated whether to An Corp this piece of garbage or let it lie, but since it still pops up on a Google search I figured I'd warn everyone else not to rely on it.
I haven't gone through it exhaustively, and while I found Mikel to be a douche while he played here, I'm not sure if he was just reposting this or if this is a product of his own lack of math skills. As I'm scrolling down, it looks like Bazookas echoed some of this already.
Look at Row 3 (halberds) for an example of the errors. First, posts by Derrick himself show that the damage values for Ruin-Vanq are +1, +3, +5, +7, and +9, whole numbers in other words. I haven't seen any evidence from Mikel or anyone else that the fractional values are correct, but this chart calculates each as a decimal value, each somewhat less than those posted by the staff.
Second, the tactics values are wrong. Tactics is simply a 1/1 percentage added to the damage:
http://wiki.uosecondage.com/Tactics
Here, the average base damage for a halberd is 27 (he got that right at least), an additional 5% of that would be 1.35. Inexplicably, he has 0.7 for a +5 tactics, yet 1.4 for +10 tactics. +10 tactics would be 2.7, which he has for +20, and so forth. The +25 tactics should be 6.75, much more than his 3.4. I assume the rest of the weapons are similarly miscalculated.
Soooo... the list of which Halberd is boss-er is suspect as well.
Magic vs. GM
-
Pixelclicker
- Posts: 538
- Joined: Tue Dec 28, 2010 6:55 pm
Re: Magic vs. GM
<@BoomlandJenkins> I got home, got on UO right away and I knew something was up before I even made it to the spawner, because there were 35+ in the Justice woods and not one person was PKing one another.
Re: Magic vs. GM
Thanks for the An Corp. Before we get started: I have no idea who you are/were. So, bummer you thought I was a douche, but rest assured I harbored no such ill feelings towards you.
Indeed this was my own math, and indeed it looks like you ignored my response to Bazooka. For someone who calls my post a "piece of garbage", you have a profound lack of understanding of what's actually being detailed in it. I'll reiterate what I said to Bazooka: Tactics adds 1:1, as you and Bazooka mention, but all damage is halved. So 25% Tactics = 12.5% actual damage increase to players.
With respect to the Ruin-Vanq values... the +1 through +9 are *base* damage values. These are modified by things like Tactics, Anatomy, Strength, and the fact that damage is halved. So when a Vanq weapon gets "+9" to its damage, the actual amount of damage being dealt to players is only +4.5. Then when you factor in standard modifiers (100 Tactics, etc.), it nets out to 8.6. The reason this is important is because it puts the damage on a proper scale with the tactics bonus, which I turned into actual damage as well. So you're adding apples-to-apples, and the damages correspond directly to HP.
I don't know how things are rounded, so maybe Kaivan/Derrick/Batlin could weigh in on that.
Indeed this was my own math, and indeed it looks like you ignored my response to Bazooka. For someone who calls my post a "piece of garbage", you have a profound lack of understanding of what's actually being detailed in it. I'll reiterate what I said to Bazooka: Tactics adds 1:1, as you and Bazooka mention, but all damage is halved. So 25% Tactics = 12.5% actual damage increase to players.
With respect to the Ruin-Vanq values... the +1 through +9 are *base* damage values. These are modified by things like Tactics, Anatomy, Strength, and the fact that damage is halved. So when a Vanq weapon gets "+9" to its damage, the actual amount of damage being dealt to players is only +4.5. Then when you factor in standard modifiers (100 Tactics, etc.), it nets out to 8.6. The reason this is important is because it puts the damage on a proper scale with the tactics bonus, which I turned into actual damage as well. So you're adding apples-to-apples, and the damages correspond directly to HP.
I don't know how things are rounded, so maybe Kaivan/Derrick/Batlin could weigh in on that.
Re: Magic vs. GM
I really like your data, I have a question about the spreadsheet though.
What is the difference between the columns "GMTankDam" and "GMDexDam"? It seems to be based on the average damage, so is it the difference between someone with 100 str and 100 dex?
Edit: Also, are your DamLow and DamHigh columns already altered for the "damage is halved when applied"?
I'm interested in creating a similar spreadsheet that would allow filtering and sorting so that people can see exactly what weapon is best for their situation. Enter str/dex and it changes the values, etc.
What is the difference between the columns "GMTankDam" and "GMDexDam"? It seems to be based on the average damage, so is it the difference between someone with 100 str and 100 dex?
Edit: Also, are your DamLow and DamHigh columns already altered for the "damage is halved when applied"?
I'm interested in creating a similar spreadsheet that would allow filtering and sorting so that people can see exactly what weapon is best for their situation. Enter str/dex and it changes the values, etc.
Re: Magic vs. GM
Tanks typically have 100 STR and 100 Tactics, while Dexers have 100 Anatomy as well (an extra 20% damage bonus).
I found the old file, but I don't know how to get Excel to paste the *formulas* into text, I can only seem to get it to paste the resulting values. Tried attaching the file, but am not allowed to attach .xls files, and I can't get the formulas in any other format (to my knowledge). My file does allow for some customization like that (more along the lines of adjusting swing delay based on Dex or Stamina), but I think I hardcoded 100 STR because, well, who doesn't have 100 STR?
I found the old file, but I don't know how to get Excel to paste the *formulas* into text, I can only seem to get it to paste the resulting values. Tried attaching the file, but am not allowed to attach .xls files, and I can't get the formulas in any other format (to my knowledge). My file does allow for some customization like that (more along the lines of adjusting swing delay based on Dex or Stamina), but I think I hardcoded 100 STR because, well, who doesn't have 100 STR?
Re: Magic vs. GM
Try pasting this in Excel, then doing Data -> Text to Columns -> Delimited -> check Comma -> Finish
Then, in the formula cells, select all of them and Find/Replace a space with nothing.
Those two steps should get it to display the results of the formulas I used, but give you the formulas in the cells to play around with.
Weapon Name, Skill, Speed, Formula, DamLow, DamHigh, AvgDam, 25%, 75%, Dice, AvgGMdam, GMTankDam, GMDexDam, +25vanqTankDam, +25vanqDexDam0%, +25vanqDexDam25%, +25vanqDexDamAvg, +25vanqDexDam75%, +25vanqDexDam100%, Delay25dex, Delay34dex, Delay100dex, Delay120dex, ruin, might, force, power, vanq, +5, +10, +15, +20, +25,
Heavy Crossbow (2-H), Archery, 10, 5d10+6, 11, 56, =SUM(E2:F2)/2, =G2-I2+G2, 38.4566115702479, 5, =(G2+4), =(($G2*(1.5+0.2))+4)/2, =(($G2*(1.5+0.2+0.2))+4)/2, =((($G2)*(1.5+0.2))+9)/2, =P2-Q2+P2, =((($H2+9)*(1.5+0.2+0.2)))/2, =((($G2)*(1.5+0.2+0.2))+9)/2, =((($I2)*(1.5+0.2+0.2))+9)/2, =R2-Q2+R2, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C2),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C2),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C2),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C2),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, 0, 0, 0, 0, 0,
Halberd(2-H), Swords, 25, 2d23+3, 5, 49, =SUM(E3:F3)/2, =G3-I3+G3, 34.2343234323432, 2, =(G3+4), =(($G3*(1.5+0.2))+4)/2, =(($G3*(1.5+0.2+0.2))+4)/2, =((($G3)*(1.5+0.2+0.25))+9)/2, =P3-Q3+P3, =((($H3+9)*(1.5+0.2+0.25+0.2)))/2, =((($G3)*(1.5+0.2+0.2+0.25))+9)/2, =((($I3)*(1.5+0.2+0.2+0.25))+9)/2, =R3-Q3+R3, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C3),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C3),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C3),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C3),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G3)*(1.55+0.2)))/2-(($G3*(1.5+0.2)))/2, =((($G3)*(1.6+0.2)))/2-(($G3*(1.5+0.2)))/2, =((($G3)*(1.65+0.2)))/2-(($G3*(1.5+0.2)))/2, =((($G3)*(1.7+0.2)))/2-(($G3*(1.5+0.2)))/2, =((($G3)*(1.75+0.2)))/2-(($G3*(1.5+0.2)))/2,
Crossbow (2-H), Archery, 18, 5d8+3, 8, 43, =SUM(E4:F4)/2, =G4-I4+G4, 29.5602605863192, 5, =(G4+4), =(($G4*(1.5+0.2))+4)/2, =(($G4*(1.5+0.2+0.2))+4)/2, =((($G4)*(1.5+0.2))+9)/2, =P4-Q4+P4, =((($H4+9)*(1.5+0.2+0.2)))/2, =((($G4)*(1.5+0.2+0.2))+9)/2, =((($I4)*(1.5+0.2+0.2))+9)/2, =R4-Q4+R4, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C4),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C4),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C4),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C4),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, 0, 0, 0, 0, 0,
Bow (2-H), Archery, 20, 4d9+5, 9, 41, =SUM(E5:F5)/2, =G5-I5+G5, 29.1066433566434, 4, =(G5+4), =(($G5*(1.5+0.2))+4)/2, =(($G5*(1.5+0.2+0.2))+4)/2, =((($G5)*(1.5+0.2))+9)/2, =P5-Q5+P5, =((($H5+9)*(1.5+0.2+0.2)))/2, =((($G5)*(1.5+0.2+0.2))+9)/2, =((($I5)*(1.5+0.2+0.2))+9)/2, =R5-Q5+R5, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C5),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C5),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C5),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C5),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, 0, 0, 0, 0, 0,
Bardiche (2-H), Swords, 26, 2d20+3, 5, 43, =SUM(E6:F6)/2, =G6-I6+G6, 30.3571428571429, 2, =(G6+4), =(($G6*(1.5+0.2))+4)/2, =(($G6*(1.5+0.2+0.2))+4)/2, =((($G6)*(1.5+0.2+0.25))+9)/2, =P6-Q6+P6, =((($H6+9)*(1.5+0.2+0.25+0.2)))/2, =((($G6)*(1.5+0.2+0.2+0.25))+9)/2, =((($I6)*(1.5+0.2+0.2+0.25))+9)/2, =R6-Q6+R6, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C6),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C6),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C6),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C6),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G6)*(1.55+0.2)))/2-(($G6*(1.5+0.2)))/2, =((($G6)*(1.6+0.2)))/2-(($G6*(1.5+0.2)))/2, =((($G6)*(1.65+0.2)))/2-(($G6*(1.5+0.2)))/2, =((($G6)*(1.7+0.2)))/2-(($G6*(1.5+0.2)))/2, =((($G6)*(1.75+0.2)))/2-(($G6*(1.5+0.2)))/2,
Two-handed Axe (2-H), Swords, 30, 2d18+3, 5, 39, =SUM(E7:F7)/2, =G7-I7+G7, 27.7686567164179, 2, =(G7+4), =(($G7*(1.5+0.2))+4)/2, =(($G7*(1.5+0.2+0.2))+4)/2, =((($G7)*(1.5+0.2+0.25))+9)/2, =P7-Q7+P7, =((($H7+9)*(1.5+0.2+0.25+0.2)))/2, =((($G7)*(1.5+0.2+0.2+0.25))+9)/2, =((($I7)*(1.5+0.2+0.2+0.25))+9)/2, =R7-Q7+R7, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C7),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C7),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C7),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C7),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G7)*(1.55+0.2)))/2-(($G7*(1.5+0.2)))/2, =((($G7)*(1.6+0.2)))/2-(($G7*(1.5+0.2)))/2, =((($G7)*(1.65+0.2)))/2-(($G7*(1.5+0.2)))/2, =((($G7)*(1.7+0.2)))/2-(($G7*(1.5+0.2)))/2, =((($G7)*(1.75+0.2)))/2-(($G7*(1.5+0.2)))/2,
Large Battle Axe (2-H), Swords, 30, 2d17+4, 6, 38, =SUM(E8:F8)/2, =G8-I8+G8, 27.4795180722892, 2, =(G8+4), =(($G8*(1.5+0.2))+4)/2, =(($G8*(1.5+0.2+0.2))+4)/2, =((($G8)*(1.5+0.2+0.25))+9)/2, =P8-Q8+P8, =((($H8+9)*(1.5+0.2+0.25+0.2)))/2, =((($G8)*(1.5+0.2+0.2+0.25))+9)/2, =((($I8)*(1.5+0.2+0.2+0.25))+9)/2, =R8-Q8+R8, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C8),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C8),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C8),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C8),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G8)*(1.55+0.2)))/2-(($G8*(1.5+0.2)))/2, =((($G8)*(1.6+0.2)))/2-(($G8*(1.5+0.2)))/2, =((($G8)*(1.65+0.2)))/2-(($G8*(1.5+0.2)))/2, =((($G8)*(1.7+0.2)))/2-(($G8*(1.5+0.2)))/2, =((($G8)*(1.75+0.2)))/2-(($G8*(1.5+0.2)))/2,
Battle Axe (2-H), Swords, 30, 2d17+4, 6, 38, =SUM(E9:F9)/2, =G9-I9+G9, 27.4795180722892, 2, =(G9+4), =(($G9*(1.5+0.2))+4)/2, =(($G9*(1.5+0.2+0.2))+4)/2, =((($G9)*(1.5+0.2+0.25))+9)/2, =P9-Q9+P9, =((($H9+9)*(1.5+0.2+0.25+0.2)))/2, =((($G9)*(1.5+0.2+0.2+0.25))+9)/2, =((($I9)*(1.5+0.2+0.2+0.25))+9)/2, =R9-Q9+R9, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C9),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C9),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C9),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C9),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G9)*(1.55+0.2)))/2-(($G9*(1.5+0.2)))/2, =((($G9)*(1.6+0.2)))/2-(($G9*(1.5+0.2)))/2, =((($G9)*(1.65+0.2)))/2-(($G9*(1.5+0.2)))/2, =((($G9)*(1.7+0.2)))/2-(($G9*(1.5+0.2)))/2, =((($G9)*(1.75+0.2)))/2-(($G9*(1.5+0.2)))/2,
War Hammer (2-H), Mace *, 31, 7d5+1, 8, 36, =SUM(E10:F10)/2, =G10-I10+G10, 25.0735483870968, 7, =(G10+4), =(($G10*(1.5+0.2))+4)/2, =(($G10*(1.5+0.2+0.2))+4)/2, =((($G10)*(1.5+0.2+0.25))+9)/2, =P10-Q10+P10, =((($H10+9)*(1.5+0.2+0.25+0.2)))/2, =((($G10)*(1.5+0.2+0.2+0.25))+9)/2, =((($I10)*(1.5+0.2+0.2+0.25))+9)/2, =R10-Q10+R10, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C10),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C10),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C10),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C10),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G10)*(1.55+0.2)))/2-(($G10*(1.5+0.2)))/2, =((($G10)*(1.6+0.2)))/2-(($G10*(1.5+0.2)))/2, =((($G10)*(1.65+0.2)))/2-(($G10*(1.5+0.2)))/2, =((($G10)*(1.7+0.2)))/2-(($G10*(1.5+0.2)))/2, =((($G10)*(1.75+0.2)))/2-(($G10*(1.5+0.2)))/2,
Black Staff (2-H), Mace *, 35, 5d6+3, 8, 33, =SUM(E11:F11)/2, =G11-I11+G11, 23.6594982078853, 5, =(G11+4), =(($G11*(1.5+0.2))+4)/2, =(($G11*(1.5+0.2+0.2))+4)/2, =((($G11)*(1.5+0.2+0.25))+9)/2, =P11-Q11+P11, =((($H11+9)*(1.5+0.2+0.25+0.2)))/2, =((($G11)*(1.5+0.2+0.2+0.25))+9)/2, =((($I11)*(1.5+0.2+0.2+0.25))+9)/2, =R11-Q11+R11, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C11),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C11),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C11),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C11),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G11)*(1.55+0.2)))/2-(($G11*(1.5+0.2)))/2, =((($G11)*(1.6+0.2)))/2-(($G11*(1.5+0.2)))/2, =((($G11)*(1.65+0.2)))/2-(($G11*(1.5+0.2)))/2, =((($G11)*(1.7+0.2)))/2-(($G11*(1.5+0.2)))/2, =((($G11)*(1.75+0.2)))/2-(($G11*(1.5+0.2)))/2,
Double Axe (2-H), Swords, 37, 1d31+4, 5, 35, =SUM(E12:F12)/2, =G12-I12+G12, 28.250773993808, 1, =(G12+4), =(($G12*(1.5+0.2))+4)/2, =(($G12*(1.5+0.2+0.2))+4)/2, =((($G12)*(1.5+0.2+0.25))+9)/2, =P12-Q12+P12, =((($H12+9)*(1.5+0.2+0.25+0.2)))/2, =((($G12)*(1.5+0.2+0.2+0.25))+9)/2, =((($I12)*(1.5+0.2+0.2+0.25))+9)/2, =R12-Q12+R12, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C12),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C12),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C12),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C12),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G12)*(1.55+0.2)))/2-(($G12*(1.5+0.2)))/2, =((($G12)*(1.6+0.2)))/2-(($G12*(1.5+0.2)))/2, =((($G12)*(1.65+0.2)))/2-(($G12*(1.5+0.2)))/2, =((($G12)*(1.7+0.2)))/2-(($G12*(1.5+0.2)))/2, =((($G12)*(1.75+0.2)))/2-(($G12*(1.5+0.2)))/2,
Viking Sword, Swords, 30, 4d8+2, 6, 34, =SUM(E13:F13)/2, =G13-I13+G13, 23.6183879093199, 4, =(G13+4), =(($G13*(1.5+0.2))+4)/2, =(($G13*(1.5+0.2+0.2))+4)/2, =((($G13)*(1.5+0.2+0.25))+9)/2, =P13-Q13+P13, =((($H13+9)*(1.5+0.2+0.25+0.2)))/2, =((($G13)*(1.5+0.2+0.2+0.25))+9)/2, =((($I13)*(1.5+0.2+0.2+0.25))+9)/2, =R13-Q13+R13, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C13),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C13),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C13),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C13),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G13)*(1.55+0.2)))/2-(($G13*(1.5+0.2)))/2, =((($G13)*(1.6+0.2)))/2-(($G13*(1.5+0.2)))/2, =((($G13)*(1.65+0.2)))/2-(($G13*(1.5+0.2)))/2, =((($G13)*(1.7+0.2)))/2-(($G13*(1.5+0.2)))/2, =((($G13)*(1.75+0.2)))/2-(($G13*(1.5+0.2)))/2,
Gnarled Staff (2-H), Mace *, 33, 5d5+5, 10, 30, =SUM(E14:F14)/2, =G14-I14+G14, 22.705078125, 5, =(G14+4), =(($G14*(1.5+0.2))+4)/2, =(($G14*(1.5+0.2+0.2))+4)/2, =((($G14)*(1.5+0.2+0.25))+9)/2, =P14-Q14+P14, =((($H14+9)*(1.5+0.2+0.25+0.2)))/2, =((($G14)*(1.5+0.2+0.2+0.25))+9)/2, =((($I14)*(1.5+0.2+0.2+0.25))+9)/2, =R14-Q14+R14, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C14),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C14),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C14),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C14),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G14)*(1.55+0.2)))/2-(($G14*(1.5+0.2)))/2, =((($G14)*(1.6+0.2)))/2-(($G14*(1.5+0.2)))/2, =((($G14)*(1.65+0.2)))/2-(($G14*(1.5+0.2)))/2, =((($G14)*(1.7+0.2)))/2-(($G14*(1.5+0.2)))/2, =((($G14)*(1.75+0.2)))/2-(($G14*(1.5+0.2)))/2,
War Mace, Mace *, 32, 5d5+5, 10, 30, =SUM(E15:F15)/2, =G15-I15+G15, 22.705078125, 5, =(G15+4), =(($G15*(1.5+0.2))+4)/2, =(($G15*(1.5+0.2+0.2))+4)/2, =((($G15)*(1.5+0.2+0.25))+9)/2, =P15-Q15+P15, =((($H15+9)*(1.5+0.2+0.25+0.2)))/2, =((($G15)*(1.5+0.2+0.2+0.25))+9)/2, =((($I15)*(1.5+0.2+0.2+0.25))+9)/2, =R15-Q15+R15, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C15),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C15),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C15),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C15),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G15)*(1.55+0.2)))/2-(($G15*(1.5+0.2)))/2, =((($G15)*(1.6+0.2)))/2-(($G15*(1.5+0.2)))/2, =((($G15)*(1.65+0.2)))/2-(($G15*(1.5+0.2)))/2, =((($G15)*(1.7+0.2)))/2-(($G15*(1.5+0.2)))/2, =((($G15)*(1.75+0.2)))/2-(($G15*(1.5+0.2)))/2,
Mace, Mace *, 30, 6d5+2, 8, 32, =SUM(E16:F16)/2, =G16-I16+G16, 23.03, 6, =(G16+4), =(($G16*(1.5+0.2))+4)/2, =(($G16*(1.5+0.2+0.2))+4)/2, =((($G16)*(1.5+0.2+0.25))+9)/2, =P16-Q16+P16, =((($H16+9)*(1.5+0.2+0.25+0.2)))/2, =((($G16)*(1.5+0.2+0.2+0.25))+9)/2, =((($I16)*(1.5+0.2+0.2+0.25))+9)/2, =R16-Q16+R16, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C16),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C16),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C16),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C16),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G16)*(1.55+0.2)))/2-(($G16*(1.5+0.2)))/2, =((($G16)*(1.6+0.2)))/2-(($G16*(1.5+0.2)))/2, =((($G16)*(1.65+0.2)))/2-(($G16*(1.5+0.2)))/2, =((($G16)*(1.7+0.2)))/2-(($G16*(1.5+0.2)))/2, =((($G16)*(1.75+0.2)))/2-(($G16*(1.5+0.2)))/2,
Maul, Mace *, 30, 5d5+5, 10, 30, =SUM(E17:F17)/2, =G17-I17+G17, 22.705078125, 5, =(G17+4), =(($G17*(1.5+0.2))+4)/2, =(($G17*(1.5+0.2+0.2))+4)/2, =((($G17)*(1.5+0.2+0.25))+9)/2, =P17-Q17+P17, =((($H17+9)*(1.5+0.2+0.25+0.2)))/2, =((($G17)*(1.5+0.2+0.2+0.25))+9)/2, =((($I17)*(1.5+0.2+0.2+0.25))+9)/2, =R17-Q17+R17, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C17),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C17),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C17),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C17),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G17)*(1.55+0.2)))/2-(($G17*(1.5+0.2)))/2, =((($G17)*(1.6+0.2)))/2-(($G17*(1.5+0.2)))/2, =((($G17)*(1.65+0.2)))/2-(($G17*(1.5+0.2)))/2, =((($G17)*(1.7+0.2)))/2-(($G17*(1.5+0.2)))/2, =((($G17)*(1.75+0.2)))/2-(($G17*(1.5+0.2)))/2,
Executioner's Axe (2-H), Swords, 37, 3d10+3, 6, 33, =SUM(E18:F18)/2, =G18-I18+G18, 23.5238095238095, 3, =(G18+4), =(($G18*(1.5+0.2))+4)/2, =(($G18*(1.5+0.2+0.2))+4)/2, =((($G18)*(1.5+0.2+0.25))+9)/2, =P18-Q18+P18, =((($H18+9)*(1.5+0.2+0.25+0.2)))/2, =((($G18)*(1.5+0.2+0.2+0.25))+9)/2, =((($I18)*(1.5+0.2+0.2+0.25))+9)/2, =R18-Q18+R18, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C18),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C18),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C18),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C18),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G18)*(1.55+0.2)))/2-(($G18*(1.5+0.2)))/2, =((($G18)*(1.6+0.2)))/2-(($G18*(1.5+0.2)))/2, =((($G18)*(1.65+0.2)))/2-(($G18*(1.5+0.2)))/2, =((($G18)*(1.7+0.2)))/2-(($G18*(1.5+0.2)))/2, =((($G18)*(1.75+0.2)))/2-(($G18*(1.5+0.2)))/2,
Axe (2-H), Swords, 37, 3d10+3, 6, 33, =SUM(E19:F19)/2, =G19-I19+G19, 23.5238095238095, 3, =(G19+4), =(($G19*(1.5+0.2))+4)/2, =(($G19*(1.5+0.2+0.2))+4)/2, =((($G19)*(1.5+0.2+0.25))+9)/2, =P19-Q19+P19, =((($H19+9)*(1.5+0.2+0.25+0.2)))/2, =((($G19)*(1.5+0.2+0.2+0.25))+9)/2, =((($I19)*(1.5+0.2+0.2+0.25))+9)/2, =R19-Q19+R19, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C19),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C19),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C19),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C19),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G19)*(1.55+0.2)))/2-(($G19*(1.5+0.2)))/2, =((($G19)*(1.6+0.2)))/2-(($G19*(1.5+0.2)))/2, =((($G19)*(1.65+0.2)))/2-(($G19*(1.5+0.2)))/2, =((($G19)*(1.7+0.2)))/2-(($G19*(1.5+0.2)))/2, =((($G19)*(1.75+0.2)))/2-(($G19*(1.5+0.2)))/2,
Hammer Pick, Mace *, 30, 3d10+3, 6, 33, =SUM(E20:F20)/2, =G20-I20+G20, 23.5238095238095, 3, =(G20+4), =(($G20*(1.5+0.2))+4)/2, =(($G20*(1.5+0.2+0.2))+4)/2, =((($G20)*(1.5+0.2+0.25))+9)/2, =P20-Q20+P20, =((($H20+9)*(1.5+0.2+0.25+0.2)))/2, =((($G20)*(1.5+0.2+0.2+0.25))+9)/2, =((($I20)*(1.5+0.2+0.2+0.25))+9)/2, =R20-Q20+R20, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C20),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C20),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C20),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C20),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G20)*(1.55+0.2)))/2-(($G20*(1.5+0.2)))/2, =((($G20)*(1.6+0.2)))/2-(($G20*(1.5+0.2)))/2, =((($G20)*(1.65+0.2)))/2-(($G20*(1.5+0.2)))/2, =((($G20)*(1.7+0.2)))/2-(($G20*(1.5+0.2)))/2, =((($G20)*(1.75+0.2)))/2-(($G20*(1.5+0.2)))/2,
Spear (2-H), Fencing, 46, 2d18, 2, 36, =SUM(E21:F21)/2, =G21-I21+G21, 24.7686567164179, 2, =(G21+4), =(($G21*(1.5+0.2))+4)/2, =(($G21*(1.5+0.2+0.2))+4)/2, =((($G21)*(1.5+0.2+0.25))+9)/2, =P21-Q21+P21, =((($H21+9)*(1.5+0.2+0.25+0.2)))/2, =((($G21)*(1.5+0.2+0.2+0.25))+9)/2, =((($I21)*(1.5+0.2+0.2+0.25))+9)/2, =R21-Q21+R21, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C21),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C21),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C21),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C21),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G21)*(1.55+0.2)))/2-(($G21*(1.5+0.2)))/2, =((($G21)*(1.6+0.2)))/2-(($G21*(1.5+0.2)))/2, =((($G21)*(1.65+0.2)))/2-(($G21*(1.5+0.2)))/2, =((($G21)*(1.7+0.2)))/2-(($G21*(1.5+0.2)))/2, =((($G21)*(1.75+0.2)))/2-(($G21*(1.5+0.2)))/2,
Longsword, Swords, 35, 2d15+3, 5, 33, =SUM(E22:F22)/2, =G22-I22+G22, 23.8854805725971, 2, =(G22+4), =(($G22*(1.5+0.2))+4)/2, =(($G22*(1.5+0.2+0.2))+4)/2, =((($G22)*(1.5+0.2+0.25))+9)/2, =P22-Q22+P22, =((($H22+9)*(1.5+0.2+0.25+0.2)))/2, =((($G22)*(1.5+0.2+0.2+0.25))+9)/2, =((($I22)*(1.5+0.2+0.2+0.25))+9)/2, =R22-Q22+R22, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C22),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C22),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C22),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C22),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G22)*(1.55+0.2)))/2-(($G22*(1.5+0.2)))/2, =((($G22)*(1.6+0.2)))/2-(($G22*(1.5+0.2)))/2, =((($G22)*(1.65+0.2)))/2-(($G22*(1.5+0.2)))/2, =((($G22)*(1.7+0.2)))/2-(($G22*(1.5+0.2)))/2, =((($G22)*(1.75+0.2)))/2-(($G22*(1.5+0.2)))/2,
War Fork, Fencing, 45, 1d29+3, 4, 32, =SUM(E23:F23)/2, =G23-I23+G23, 25.7507246376812, 1, =(G23+4), =(($G23*(1.5+0.2))+4)/2, =(($G23*(1.5+0.2+0.2))+4)/2, =((($G23)*(1.5+0.2+0.25))+9)/2, =P23-Q23+P23, =((($H23+9)*(1.5+0.2+0.25+0.2)))/2, =((($G23)*(1.5+0.2+0.2+0.25))+9)/2, =((($I23)*(1.5+0.2+0.2+0.25))+9)/2, =R23-Q23+R23, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C23),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C23),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C23),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C23),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G23)*(1.55+0.2)))/2-(($G23*(1.5+0.2)))/2, =((($G23)*(1.6+0.2)))/2-(($G23*(1.5+0.2)))/2, =((($G23)*(1.65+0.2)))/2-(($G23*(1.5+0.2)))/2, =((($G23)*(1.7+0.2)))/2-(($G23*(1.5+0.2)))/2, =((($G23)*(1.75+0.2)))/2-(($G23*(1.5+0.2)))/2,
Short Spear (2-H), Fencing, 50, 2d15+2, 4, 32, =SUM(E24:F24)/2, =G24-I24+G24, 22.8854805725971, 2, =(G24+4), =(($G24*(1.5+0.2))+4)/2, =(($G24*(1.5+0.2+0.2))+4)/2, =((($G24)*(1.5+0.2+0.25))+9)/2, =P24-Q24+P24, =((($H24+9)*(1.5+0.2+0.25+0.2)))/2, =((($G24)*(1.5+0.2+0.2+0.25))+9)/2, =((($I24)*(1.5+0.2+0.2+0.25))+9)/2, =R24-Q24+R24, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C24),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C24),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C24),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C24),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G24)*(1.55+0.2)))/2-(($G24*(1.5+0.2)))/2, =((($G24)*(1.6+0.2)))/2-(($G24*(1.5+0.2)))/2, =((($G24)*(1.65+0.2)))/2-(($G24*(1.5+0.2)))/2, =((($G24)*(1.7+0.2)))/2-(($G24*(1.5+0.2)))/2, =((($G24)*(1.75+0.2)))/2-(($G24*(1.5+0.2)))/2,
Quarterstaff (2-H), Mace *, 48, 5d5+3, 8, 28, =SUM(E25:F25)/2, =G25-I25+G25, 20.705078125, 5, =(G25+4), =(($G25*(1.5+0.2))+4)/2, =(($G25*(1.5+0.2+0.2))+4)/2, =((($G25)*(1.5+0.2+0.25))+9)/2, =P25-Q25+P25, =((($H25+9)*(1.5+0.2+0.25+0.2)))/2, =((($G25)*(1.5+0.2+0.2+0.25))+9)/2, =((($I25)*(1.5+0.2+0.2+0.25))+9)/2, =R25-Q25+R25, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C25),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C25),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C25),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C25),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G25)*(1.55+0.2)))/2-(($G25*(1.5+0.2)))/2, =((($G25)*(1.6+0.2)))/2-(($G25*(1.5+0.2)))/2, =((($G25)*(1.65+0.2)))/2-(($G25*(1.5+0.2)))/2, =((($G25)*(1.7+0.2)))/2-(($G25*(1.5+0.2)))/2, =((($G25)*(1.75+0.2)))/2-(($G25*(1.5+0.2)))/2,
War Axe, Mace *, 40, 6d4+3, 9, 27, =SUM(E26:F26)/2, =G26-I26+G26, 20.4123989218329, 6, =(G26+4), =(($G26*(1.5+0.2))+4)/2, =(($G26*(1.5+0.2+0.2))+4)/2, =((($G26)*(1.5+0.2+0.25))+9)/2, =P26-Q26+P26, =((($H26+9)*(1.5+0.2+0.25+0.2)))/2, =((($G26)*(1.5+0.2+0.2+0.25))+9)/2, =((($I26)*(1.5+0.2+0.2+0.25))+9)/2, =R26-Q26+R26, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C26),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C26),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C26),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C26),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G26)*(1.55+0.2)))/2-(($G26*(1.5+0.2)))/2, =((($G26)*(1.6+0.2)))/2-(($G26*(1.5+0.2)))/2, =((($G26)*(1.65+0.2)))/2-(($G26*(1.5+0.2)))/2, =((($G26)*(1.7+0.2)))/2-(($G26*(1.5+0.2)))/2, =((($G26)*(1.75+0.2)))/2-(($G26*(1.5+0.2)))/2,
Scimitar, Swords, 43, 2d14+2, 4, 30, =SUM(E27:F27)/2, =G27-I27+G27, 21.6, 2, =(G27+4), =(($G27*(1.5+0.2))+4)/2, =(($G27*(1.5+0.2+0.2))+4)/2, =((($G27)*(1.5+0.2+0.25))+9)/2, =P27-Q27+P27, =((($H27+9)*(1.5+0.2+0.25+0.2)))/2, =((($G27)*(1.5+0.2+0.2+0.25))+9)/2, =((($I27)*(1.5+0.2+0.2+0.25))+9)/2, =R27-Q27+R27, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C27),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C27),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C27),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C27),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G27)*(1.55+0.2)))/2-(($G27*(1.5+0.2)))/2, =((($G27)*(1.6+0.2)))/2-(($G27*(1.5+0.2)))/2, =((($G27)*(1.65+0.2)))/2-(($G27*(1.5+0.2)))/2, =((($G27)*(1.7+0.2)))/2-(($G27*(1.5+0.2)))/2, =((($G27)*(1.75+0.2)))/2-(($G27*(1.5+0.2)))/2,
Broad Sword, Swords, 45, 2d13+3, 5, 29, =SUM(E28:F28)/2, =G28-I28+G28, 21.3058161350844, 2, =(G28+4), =(($G28*(1.5+0.2))+4)/2, =(($G28*(1.5+0.2+0.2))+4)/2, =((($G28)*(1.5+0.2+0.25))+9)/2, =P28-Q28+P28, =((($H28+9)*(1.5+0.2+0.25+0.2)))/2, =((($G28)*(1.5+0.2+0.2+0.25))+9)/2, =((($I28)*(1.5+0.2+0.2+0.25))+9)/2, =R28-Q28+R28, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C28),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C28),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C28),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C28),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G28)*(1.55+0.2)))/2-(($G28*(1.5+0.2)))/2, =((($G28)*(1.6+0.2)))/2-(($G28*(1.5+0.2)))/2, =((($G28)*(1.65+0.2)))/2-(($G28*(1.5+0.2)))/2, =((($G28)*(1.7+0.2)))/2-(($G28*(1.5+0.2)))/2, =((($G28)*(1.75+0.2)))/2-(($G28*(1.5+0.2)))/2,
Cutlass, Swords, 45, 2d12+4, 6, 28, =SUM(E29:F29)/2, =G29-I29+G29, 21, 2, =(G29+4), =(($G29*(1.5+0.2))+4)/2, =(($G29*(1.5+0.2+0.2))+4)/2, =((($G29)*(1.5+0.2+0.25))+9)/2, =P29-Q29+P29, =((($H29+9)*(1.5+0.2+0.25+0.2)))/2, =((($G29)*(1.5+0.2+0.2+0.25))+9)/2, =((($I29)*(1.5+0.2+0.2+0.25))+9)/2, =R29-Q29+R29, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C29),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C29),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C29),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C29),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G29)*(1.55+0.2)))/2-(($G29*(1.5+0.2)))/2, =((($G29)*(1.6+0.2)))/2-(($G29*(1.5+0.2)))/2, =((($G29)*(1.65+0.2)))/2-(($G29*(1.5+0.2)))/2, =((($G29)*(1.7+0.2)))/2-(($G29*(1.5+0.2)))/2, =((($G29)*(1.75+0.2)))/2-(($G29*(1.5+0.2)))/2,
Club, Mace *, 40, 4d5+4, 8, 24, =SUM(E30:F30)/2, =G30-I30+G30, 18.4963235294118, 4, =(G30+4), =(($G30*(1.5+0.2))+4)/2, =(($G30*(1.5+0.2+0.2))+4)/2, =((($G30)*(1.5+0.2+0.25))+9)/2, =P30-Q30+P30, =((($H30+9)*(1.5+0.2+0.25+0.2)))/2, =((($G30)*(1.5+0.2+0.2+0.25))+9)/2, =((($I30)*(1.5+0.2+0.2+0.25))+9)/2, =R30-Q30+R30, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C30),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C30),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C30),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C30),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G30)*(1.55+0.2)))/2-(($G30*(1.5+0.2)))/2, =((($G30)*(1.6+0.2)))/2-(($G30*(1.5+0.2)))/2, =((($G30)*(1.65+0.2)))/2-(($G30*(1.5+0.2)))/2, =((($G30)*(1.7+0.2)))/2-(($G30*(1.5+0.2)))/2, =((($G30)*(1.75+0.2)))/2-(($G30*(1.5+0.2)))/2,
Kryss, Fencing, 53, 1d26+2, 3, 28, =SUM(E31:F31)/2, =G31-I31+G31, 22.5, 1, =(G31+4), =(($G31*(1.5+0.2))+4)/2, =(($G31*(1.5+0.2+0.2))+4)/2, =((($G31)*(1.5+0.2+0.25))+9)/2, =P31-Q31+P31, =((($H31+9)*(1.5+0.2+0.25+0.2)))/2, =((($G31)*(1.5+0.2+0.2+0.25))+9)/2, =((($I31)*(1.5+0.2+0.2+0.25))+9)/2, =R31-Q31+R31, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C31),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C31),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C31),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C31),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G31)*(1.55+0.2)))/2-(($G31*(1.5+0.2)))/2, =((($G31)*(1.6+0.2)))/2-(($G31*(1.5+0.2)))/2, =((($G31)*(1.65+0.2)))/2-(($G31*(1.5+0.2)))/2, =((($G31)*(1.7+0.2)))/2-(($G31*(1.5+0.2)))/2, =((($G31)*(1.75+0.2)))/2-(($G31*(1.5+0.2)))/2,
Katana, Swords, 58, 3d8+2, 5, 26, =SUM(E32:F32)/2, =G32-I32+G32, 18.809756097561, 3, =(G32+4), =(($G32*(1.5+0.2))+4)/2, =(($G32*(1.5+0.2+0.2))+4)/2, =((($G32)*(1.5+0.2+0.25))+9)/2, =P32-Q32+P32, =((($H32+9)*(1.5+0.2+0.25+0.2)))/2, =((($G32)*(1.5+0.2+0.2+0.25))+9)/2, =((($I32)*(1.5+0.2+0.2+0.25))+9)/2, =R32-Q32+R32, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C32),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C32),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C32),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C32),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G32)*(1.55+0.2)))/2-(($G32*(1.5+0.2)))/2, =((($G32)*(1.6+0.2)))/2-(($G32*(1.5+0.2)))/2, =((($G32)*(1.65+0.2)))/2-(($G32*(1.5+0.2)))/2, =((($G32)*(1.7+0.2)))/2-(($G32*(1.5+0.2)))/2, =((($G32)*(1.75+0.2)))/2-(($G32*(1.5+0.2)))/2,
Dagger, Fencing, 55, 3d5, 3, 15, =SUM(E33:F33)/2, =G33-I33+G33, 11.25, 3, =(G33+4), =(($G33*(1.5+0.2))+4)/2, =(($G33*(1.5+0.2+0.2))+4)/2, =((($G33)*(1.5+0.2+0.25))+9)/2, =P33-Q33+P33, =((($H33+9)*(1.5+0.2+0.25+0.2)))/2, =((($G33)*(1.5+0.2+0.2+0.25))+9)/2, =((($I33)*(1.5+0.2+0.2+0.25))+9)/2, =R33-Q33+R33, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C33),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C33),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C33),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C33),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G33)*(1.55+0.2)))/2-(($G33*(1.5+0.2)))/2, =((($G33)*(1.6+0.2)))/2-(($G33*(1.5+0.2)))/2, =((($G33)*(1.65+0.2)))/2-(($G33*(1.5+0.2)))/2, =((($G33)*(1.7+0.2)))/2-(($G33*(1.5+0.2)))/2, =((($G33)*(1.75+0.2)))/2-(($G33*(1.5+0.2)))/2,
Wrestling, Wrestling, 50, 1d8, 1, 8, =SUM(E34:F34)/2, =G34-I34+G34, 7, 1, =(G34+4), =(($G34*(1.5+0.2))+4)/2, =(($G34*(1.5+0.2+0.2))+4)/2, =((($G34)*(1.5+0.2+0.25))+9)/2, =P34-Q34+P34, =((($H34+9)*(1.5+0.2+0.25+0.2)))/2, =((($G34)*(1.5+0.2+0.2+0.25))+9)/2, =((($I34)*(1.5+0.2+0.2+0.25))+9)/2, =R34-Q34+R34, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C34),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C34),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C34),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C34),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G34)*(1.55+0.2)))/2-(($G34*(1.5+0.2)))/2, =((($G34)*(1.6+0.2)))/2-(($G34*(1.5+0.2)))/2, =((($G34)*(1.65+0.2)))/2-(($G34*(1.5+0.2)))/2, =((($G34)*(1.7+0.2)))/2-(($G34*(1.5+0.2)))/2, =((($G34)*(1.75+0.2)))/2-(($G34*(1.5+0.2)))/2,
Then, in the formula cells, select all of them and Find/Replace a space with nothing.
Those two steps should get it to display the results of the formulas I used, but give you the formulas in the cells to play around with.
Weapon Name, Skill, Speed, Formula, DamLow, DamHigh, AvgDam, 25%, 75%, Dice, AvgGMdam, GMTankDam, GMDexDam, +25vanqTankDam, +25vanqDexDam0%, +25vanqDexDam25%, +25vanqDexDamAvg, +25vanqDexDam75%, +25vanqDexDam100%, Delay25dex, Delay34dex, Delay100dex, Delay120dex, ruin, might, force, power, vanq, +5, +10, +15, +20, +25,
Heavy Crossbow (2-H), Archery, 10, 5d10+6, 11, 56, =SUM(E2:F2)/2, =G2-I2+G2, 38.4566115702479, 5, =(G2+4), =(($G2*(1.5+0.2))+4)/2, =(($G2*(1.5+0.2+0.2))+4)/2, =((($G2)*(1.5+0.2))+9)/2, =P2-Q2+P2, =((($H2+9)*(1.5+0.2+0.2)))/2, =((($G2)*(1.5+0.2+0.2))+9)/2, =((($I2)*(1.5+0.2+0.2))+9)/2, =R2-Q2+R2, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C2),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C2),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C2),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C2),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, 0, 0, 0, 0, 0,
Halberd(2-H), Swords, 25, 2d23+3, 5, 49, =SUM(E3:F3)/2, =G3-I3+G3, 34.2343234323432, 2, =(G3+4), =(($G3*(1.5+0.2))+4)/2, =(($G3*(1.5+0.2+0.2))+4)/2, =((($G3)*(1.5+0.2+0.25))+9)/2, =P3-Q3+P3, =((($H3+9)*(1.5+0.2+0.25+0.2)))/2, =((($G3)*(1.5+0.2+0.2+0.25))+9)/2, =((($I3)*(1.5+0.2+0.2+0.25))+9)/2, =R3-Q3+R3, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C3),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C3),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C3),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C3),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G3)*(1.55+0.2)))/2-(($G3*(1.5+0.2)))/2, =((($G3)*(1.6+0.2)))/2-(($G3*(1.5+0.2)))/2, =((($G3)*(1.65+0.2)))/2-(($G3*(1.5+0.2)))/2, =((($G3)*(1.7+0.2)))/2-(($G3*(1.5+0.2)))/2, =((($G3)*(1.75+0.2)))/2-(($G3*(1.5+0.2)))/2,
Crossbow (2-H), Archery, 18, 5d8+3, 8, 43, =SUM(E4:F4)/2, =G4-I4+G4, 29.5602605863192, 5, =(G4+4), =(($G4*(1.5+0.2))+4)/2, =(($G4*(1.5+0.2+0.2))+4)/2, =((($G4)*(1.5+0.2))+9)/2, =P4-Q4+P4, =((($H4+9)*(1.5+0.2+0.2)))/2, =((($G4)*(1.5+0.2+0.2))+9)/2, =((($I4)*(1.5+0.2+0.2))+9)/2, =R4-Q4+R4, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C4),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C4),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C4),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C4),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, 0, 0, 0, 0, 0,
Bow (2-H), Archery, 20, 4d9+5, 9, 41, =SUM(E5:F5)/2, =G5-I5+G5, 29.1066433566434, 4, =(G5+4), =(($G5*(1.5+0.2))+4)/2, =(($G5*(1.5+0.2+0.2))+4)/2, =((($G5)*(1.5+0.2))+9)/2, =P5-Q5+P5, =((($H5+9)*(1.5+0.2+0.2)))/2, =((($G5)*(1.5+0.2+0.2))+9)/2, =((($I5)*(1.5+0.2+0.2))+9)/2, =R5-Q5+R5, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C5),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C5),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C5),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C5),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, 0, 0, 0, 0, 0,
Bardiche (2-H), Swords, 26, 2d20+3, 5, 43, =SUM(E6:F6)/2, =G6-I6+G6, 30.3571428571429, 2, =(G6+4), =(($G6*(1.5+0.2))+4)/2, =(($G6*(1.5+0.2+0.2))+4)/2, =((($G6)*(1.5+0.2+0.25))+9)/2, =P6-Q6+P6, =((($H6+9)*(1.5+0.2+0.25+0.2)))/2, =((($G6)*(1.5+0.2+0.2+0.25))+9)/2, =((($I6)*(1.5+0.2+0.2+0.25))+9)/2, =R6-Q6+R6, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C6),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C6),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C6),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C6),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G6)*(1.55+0.2)))/2-(($G6*(1.5+0.2)))/2, =((($G6)*(1.6+0.2)))/2-(($G6*(1.5+0.2)))/2, =((($G6)*(1.65+0.2)))/2-(($G6*(1.5+0.2)))/2, =((($G6)*(1.7+0.2)))/2-(($G6*(1.5+0.2)))/2, =((($G6)*(1.75+0.2)))/2-(($G6*(1.5+0.2)))/2,
Two-handed Axe (2-H), Swords, 30, 2d18+3, 5, 39, =SUM(E7:F7)/2, =G7-I7+G7, 27.7686567164179, 2, =(G7+4), =(($G7*(1.5+0.2))+4)/2, =(($G7*(1.5+0.2+0.2))+4)/2, =((($G7)*(1.5+0.2+0.25))+9)/2, =P7-Q7+P7, =((($H7+9)*(1.5+0.2+0.25+0.2)))/2, =((($G7)*(1.5+0.2+0.2+0.25))+9)/2, =((($I7)*(1.5+0.2+0.2+0.25))+9)/2, =R7-Q7+R7, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C7),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C7),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C7),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C7),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G7)*(1.55+0.2)))/2-(($G7*(1.5+0.2)))/2, =((($G7)*(1.6+0.2)))/2-(($G7*(1.5+0.2)))/2, =((($G7)*(1.65+0.2)))/2-(($G7*(1.5+0.2)))/2, =((($G7)*(1.7+0.2)))/2-(($G7*(1.5+0.2)))/2, =((($G7)*(1.75+0.2)))/2-(($G7*(1.5+0.2)))/2,
Large Battle Axe (2-H), Swords, 30, 2d17+4, 6, 38, =SUM(E8:F8)/2, =G8-I8+G8, 27.4795180722892, 2, =(G8+4), =(($G8*(1.5+0.2))+4)/2, =(($G8*(1.5+0.2+0.2))+4)/2, =((($G8)*(1.5+0.2+0.25))+9)/2, =P8-Q8+P8, =((($H8+9)*(1.5+0.2+0.25+0.2)))/2, =((($G8)*(1.5+0.2+0.2+0.25))+9)/2, =((($I8)*(1.5+0.2+0.2+0.25))+9)/2, =R8-Q8+R8, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C8),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C8),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C8),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C8),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G8)*(1.55+0.2)))/2-(($G8*(1.5+0.2)))/2, =((($G8)*(1.6+0.2)))/2-(($G8*(1.5+0.2)))/2, =((($G8)*(1.65+0.2)))/2-(($G8*(1.5+0.2)))/2, =((($G8)*(1.7+0.2)))/2-(($G8*(1.5+0.2)))/2, =((($G8)*(1.75+0.2)))/2-(($G8*(1.5+0.2)))/2,
Battle Axe (2-H), Swords, 30, 2d17+4, 6, 38, =SUM(E9:F9)/2, =G9-I9+G9, 27.4795180722892, 2, =(G9+4), =(($G9*(1.5+0.2))+4)/2, =(($G9*(1.5+0.2+0.2))+4)/2, =((($G9)*(1.5+0.2+0.25))+9)/2, =P9-Q9+P9, =((($H9+9)*(1.5+0.2+0.25+0.2)))/2, =((($G9)*(1.5+0.2+0.2+0.25))+9)/2, =((($I9)*(1.5+0.2+0.2+0.25))+9)/2, =R9-Q9+R9, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C9),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C9),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C9),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C9),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G9)*(1.55+0.2)))/2-(($G9*(1.5+0.2)))/2, =((($G9)*(1.6+0.2)))/2-(($G9*(1.5+0.2)))/2, =((($G9)*(1.65+0.2)))/2-(($G9*(1.5+0.2)))/2, =((($G9)*(1.7+0.2)))/2-(($G9*(1.5+0.2)))/2, =((($G9)*(1.75+0.2)))/2-(($G9*(1.5+0.2)))/2,
War Hammer (2-H), Mace *, 31, 7d5+1, 8, 36, =SUM(E10:F10)/2, =G10-I10+G10, 25.0735483870968, 7, =(G10+4), =(($G10*(1.5+0.2))+4)/2, =(($G10*(1.5+0.2+0.2))+4)/2, =((($G10)*(1.5+0.2+0.25))+9)/2, =P10-Q10+P10, =((($H10+9)*(1.5+0.2+0.25+0.2)))/2, =((($G10)*(1.5+0.2+0.2+0.25))+9)/2, =((($I10)*(1.5+0.2+0.2+0.25))+9)/2, =R10-Q10+R10, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C10),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C10),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C10),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C10),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G10)*(1.55+0.2)))/2-(($G10*(1.5+0.2)))/2, =((($G10)*(1.6+0.2)))/2-(($G10*(1.5+0.2)))/2, =((($G10)*(1.65+0.2)))/2-(($G10*(1.5+0.2)))/2, =((($G10)*(1.7+0.2)))/2-(($G10*(1.5+0.2)))/2, =((($G10)*(1.75+0.2)))/2-(($G10*(1.5+0.2)))/2,
Black Staff (2-H), Mace *, 35, 5d6+3, 8, 33, =SUM(E11:F11)/2, =G11-I11+G11, 23.6594982078853, 5, =(G11+4), =(($G11*(1.5+0.2))+4)/2, =(($G11*(1.5+0.2+0.2))+4)/2, =((($G11)*(1.5+0.2+0.25))+9)/2, =P11-Q11+P11, =((($H11+9)*(1.5+0.2+0.25+0.2)))/2, =((($G11)*(1.5+0.2+0.2+0.25))+9)/2, =((($I11)*(1.5+0.2+0.2+0.25))+9)/2, =R11-Q11+R11, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C11),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C11),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C11),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C11),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G11)*(1.55+0.2)))/2-(($G11*(1.5+0.2)))/2, =((($G11)*(1.6+0.2)))/2-(($G11*(1.5+0.2)))/2, =((($G11)*(1.65+0.2)))/2-(($G11*(1.5+0.2)))/2, =((($G11)*(1.7+0.2)))/2-(($G11*(1.5+0.2)))/2, =((($G11)*(1.75+0.2)))/2-(($G11*(1.5+0.2)))/2,
Double Axe (2-H), Swords, 37, 1d31+4, 5, 35, =SUM(E12:F12)/2, =G12-I12+G12, 28.250773993808, 1, =(G12+4), =(($G12*(1.5+0.2))+4)/2, =(($G12*(1.5+0.2+0.2))+4)/2, =((($G12)*(1.5+0.2+0.25))+9)/2, =P12-Q12+P12, =((($H12+9)*(1.5+0.2+0.25+0.2)))/2, =((($G12)*(1.5+0.2+0.2+0.25))+9)/2, =((($I12)*(1.5+0.2+0.2+0.25))+9)/2, =R12-Q12+R12, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C12),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C12),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C12),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C12),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G12)*(1.55+0.2)))/2-(($G12*(1.5+0.2)))/2, =((($G12)*(1.6+0.2)))/2-(($G12*(1.5+0.2)))/2, =((($G12)*(1.65+0.2)))/2-(($G12*(1.5+0.2)))/2, =((($G12)*(1.7+0.2)))/2-(($G12*(1.5+0.2)))/2, =((($G12)*(1.75+0.2)))/2-(($G12*(1.5+0.2)))/2,
Viking Sword, Swords, 30, 4d8+2, 6, 34, =SUM(E13:F13)/2, =G13-I13+G13, 23.6183879093199, 4, =(G13+4), =(($G13*(1.5+0.2))+4)/2, =(($G13*(1.5+0.2+0.2))+4)/2, =((($G13)*(1.5+0.2+0.25))+9)/2, =P13-Q13+P13, =((($H13+9)*(1.5+0.2+0.25+0.2)))/2, =((($G13)*(1.5+0.2+0.2+0.25))+9)/2, =((($I13)*(1.5+0.2+0.2+0.25))+9)/2, =R13-Q13+R13, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C13),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C13),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C13),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C13),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G13)*(1.55+0.2)))/2-(($G13*(1.5+0.2)))/2, =((($G13)*(1.6+0.2)))/2-(($G13*(1.5+0.2)))/2, =((($G13)*(1.65+0.2)))/2-(($G13*(1.5+0.2)))/2, =((($G13)*(1.7+0.2)))/2-(($G13*(1.5+0.2)))/2, =((($G13)*(1.75+0.2)))/2-(($G13*(1.5+0.2)))/2,
Gnarled Staff (2-H), Mace *, 33, 5d5+5, 10, 30, =SUM(E14:F14)/2, =G14-I14+G14, 22.705078125, 5, =(G14+4), =(($G14*(1.5+0.2))+4)/2, =(($G14*(1.5+0.2+0.2))+4)/2, =((($G14)*(1.5+0.2+0.25))+9)/2, =P14-Q14+P14, =((($H14+9)*(1.5+0.2+0.25+0.2)))/2, =((($G14)*(1.5+0.2+0.2+0.25))+9)/2, =((($I14)*(1.5+0.2+0.2+0.25))+9)/2, =R14-Q14+R14, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C14),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C14),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C14),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C14),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G14)*(1.55+0.2)))/2-(($G14*(1.5+0.2)))/2, =((($G14)*(1.6+0.2)))/2-(($G14*(1.5+0.2)))/2, =((($G14)*(1.65+0.2)))/2-(($G14*(1.5+0.2)))/2, =((($G14)*(1.7+0.2)))/2-(($G14*(1.5+0.2)))/2, =((($G14)*(1.75+0.2)))/2-(($G14*(1.5+0.2)))/2,
War Mace, Mace *, 32, 5d5+5, 10, 30, =SUM(E15:F15)/2, =G15-I15+G15, 22.705078125, 5, =(G15+4), =(($G15*(1.5+0.2))+4)/2, =(($G15*(1.5+0.2+0.2))+4)/2, =((($G15)*(1.5+0.2+0.25))+9)/2, =P15-Q15+P15, =((($H15+9)*(1.5+0.2+0.25+0.2)))/2, =((($G15)*(1.5+0.2+0.2+0.25))+9)/2, =((($I15)*(1.5+0.2+0.2+0.25))+9)/2, =R15-Q15+R15, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C15),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C15),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C15),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C15),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G15)*(1.55+0.2)))/2-(($G15*(1.5+0.2)))/2, =((($G15)*(1.6+0.2)))/2-(($G15*(1.5+0.2)))/2, =((($G15)*(1.65+0.2)))/2-(($G15*(1.5+0.2)))/2, =((($G15)*(1.7+0.2)))/2-(($G15*(1.5+0.2)))/2, =((($G15)*(1.75+0.2)))/2-(($G15*(1.5+0.2)))/2,
Mace, Mace *, 30, 6d5+2, 8, 32, =SUM(E16:F16)/2, =G16-I16+G16, 23.03, 6, =(G16+4), =(($G16*(1.5+0.2))+4)/2, =(($G16*(1.5+0.2+0.2))+4)/2, =((($G16)*(1.5+0.2+0.25))+9)/2, =P16-Q16+P16, =((($H16+9)*(1.5+0.2+0.25+0.2)))/2, =((($G16)*(1.5+0.2+0.2+0.25))+9)/2, =((($I16)*(1.5+0.2+0.2+0.25))+9)/2, =R16-Q16+R16, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C16),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C16),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C16),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C16),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G16)*(1.55+0.2)))/2-(($G16*(1.5+0.2)))/2, =((($G16)*(1.6+0.2)))/2-(($G16*(1.5+0.2)))/2, =((($G16)*(1.65+0.2)))/2-(($G16*(1.5+0.2)))/2, =((($G16)*(1.7+0.2)))/2-(($G16*(1.5+0.2)))/2, =((($G16)*(1.75+0.2)))/2-(($G16*(1.5+0.2)))/2,
Maul, Mace *, 30, 5d5+5, 10, 30, =SUM(E17:F17)/2, =G17-I17+G17, 22.705078125, 5, =(G17+4), =(($G17*(1.5+0.2))+4)/2, =(($G17*(1.5+0.2+0.2))+4)/2, =((($G17)*(1.5+0.2+0.25))+9)/2, =P17-Q17+P17, =((($H17+9)*(1.5+0.2+0.25+0.2)))/2, =((($G17)*(1.5+0.2+0.2+0.25))+9)/2, =((($I17)*(1.5+0.2+0.2+0.25))+9)/2, =R17-Q17+R17, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C17),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C17),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C17),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C17),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G17)*(1.55+0.2)))/2-(($G17*(1.5+0.2)))/2, =((($G17)*(1.6+0.2)))/2-(($G17*(1.5+0.2)))/2, =((($G17)*(1.65+0.2)))/2-(($G17*(1.5+0.2)))/2, =((($G17)*(1.7+0.2)))/2-(($G17*(1.5+0.2)))/2, =((($G17)*(1.75+0.2)))/2-(($G17*(1.5+0.2)))/2,
Executioner's Axe (2-H), Swords, 37, 3d10+3, 6, 33, =SUM(E18:F18)/2, =G18-I18+G18, 23.5238095238095, 3, =(G18+4), =(($G18*(1.5+0.2))+4)/2, =(($G18*(1.5+0.2+0.2))+4)/2, =((($G18)*(1.5+0.2+0.25))+9)/2, =P18-Q18+P18, =((($H18+9)*(1.5+0.2+0.25+0.2)))/2, =((($G18)*(1.5+0.2+0.2+0.25))+9)/2, =((($I18)*(1.5+0.2+0.2+0.25))+9)/2, =R18-Q18+R18, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C18),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C18),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C18),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C18),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G18)*(1.55+0.2)))/2-(($G18*(1.5+0.2)))/2, =((($G18)*(1.6+0.2)))/2-(($G18*(1.5+0.2)))/2, =((($G18)*(1.65+0.2)))/2-(($G18*(1.5+0.2)))/2, =((($G18)*(1.7+0.2)))/2-(($G18*(1.5+0.2)))/2, =((($G18)*(1.75+0.2)))/2-(($G18*(1.5+0.2)))/2,
Axe (2-H), Swords, 37, 3d10+3, 6, 33, =SUM(E19:F19)/2, =G19-I19+G19, 23.5238095238095, 3, =(G19+4), =(($G19*(1.5+0.2))+4)/2, =(($G19*(1.5+0.2+0.2))+4)/2, =((($G19)*(1.5+0.2+0.25))+9)/2, =P19-Q19+P19, =((($H19+9)*(1.5+0.2+0.25+0.2)))/2, =((($G19)*(1.5+0.2+0.2+0.25))+9)/2, =((($I19)*(1.5+0.2+0.2+0.25))+9)/2, =R19-Q19+R19, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C19),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C19),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C19),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C19),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G19)*(1.55+0.2)))/2-(($G19*(1.5+0.2)))/2, =((($G19)*(1.6+0.2)))/2-(($G19*(1.5+0.2)))/2, =((($G19)*(1.65+0.2)))/2-(($G19*(1.5+0.2)))/2, =((($G19)*(1.7+0.2)))/2-(($G19*(1.5+0.2)))/2, =((($G19)*(1.75+0.2)))/2-(($G19*(1.5+0.2)))/2,
Hammer Pick, Mace *, 30, 3d10+3, 6, 33, =SUM(E20:F20)/2, =G20-I20+G20, 23.5238095238095, 3, =(G20+4), =(($G20*(1.5+0.2))+4)/2, =(($G20*(1.5+0.2+0.2))+4)/2, =((($G20)*(1.5+0.2+0.25))+9)/2, =P20-Q20+P20, =((($H20+9)*(1.5+0.2+0.25+0.2)))/2, =((($G20)*(1.5+0.2+0.2+0.25))+9)/2, =((($I20)*(1.5+0.2+0.2+0.25))+9)/2, =R20-Q20+R20, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C20),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C20),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C20),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C20),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G20)*(1.55+0.2)))/2-(($G20*(1.5+0.2)))/2, =((($G20)*(1.6+0.2)))/2-(($G20*(1.5+0.2)))/2, =((($G20)*(1.65+0.2)))/2-(($G20*(1.5+0.2)))/2, =((($G20)*(1.7+0.2)))/2-(($G20*(1.5+0.2)))/2, =((($G20)*(1.75+0.2)))/2-(($G20*(1.5+0.2)))/2,
Spear (2-H), Fencing, 46, 2d18, 2, 36, =SUM(E21:F21)/2, =G21-I21+G21, 24.7686567164179, 2, =(G21+4), =(($G21*(1.5+0.2))+4)/2, =(($G21*(1.5+0.2+0.2))+4)/2, =((($G21)*(1.5+0.2+0.25))+9)/2, =P21-Q21+P21, =((($H21+9)*(1.5+0.2+0.25+0.2)))/2, =((($G21)*(1.5+0.2+0.2+0.25))+9)/2, =((($I21)*(1.5+0.2+0.2+0.25))+9)/2, =R21-Q21+R21, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C21),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C21),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C21),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C21),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G21)*(1.55+0.2)))/2-(($G21*(1.5+0.2)))/2, =((($G21)*(1.6+0.2)))/2-(($G21*(1.5+0.2)))/2, =((($G21)*(1.65+0.2)))/2-(($G21*(1.5+0.2)))/2, =((($G21)*(1.7+0.2)))/2-(($G21*(1.5+0.2)))/2, =((($G21)*(1.75+0.2)))/2-(($G21*(1.5+0.2)))/2,
Longsword, Swords, 35, 2d15+3, 5, 33, =SUM(E22:F22)/2, =G22-I22+G22, 23.8854805725971, 2, =(G22+4), =(($G22*(1.5+0.2))+4)/2, =(($G22*(1.5+0.2+0.2))+4)/2, =((($G22)*(1.5+0.2+0.25))+9)/2, =P22-Q22+P22, =((($H22+9)*(1.5+0.2+0.25+0.2)))/2, =((($G22)*(1.5+0.2+0.2+0.25))+9)/2, =((($I22)*(1.5+0.2+0.2+0.25))+9)/2, =R22-Q22+R22, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C22),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C22),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C22),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C22),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G22)*(1.55+0.2)))/2-(($G22*(1.5+0.2)))/2, =((($G22)*(1.6+0.2)))/2-(($G22*(1.5+0.2)))/2, =((($G22)*(1.65+0.2)))/2-(($G22*(1.5+0.2)))/2, =((($G22)*(1.7+0.2)))/2-(($G22*(1.5+0.2)))/2, =((($G22)*(1.75+0.2)))/2-(($G22*(1.5+0.2)))/2,
War Fork, Fencing, 45, 1d29+3, 4, 32, =SUM(E23:F23)/2, =G23-I23+G23, 25.7507246376812, 1, =(G23+4), =(($G23*(1.5+0.2))+4)/2, =(($G23*(1.5+0.2+0.2))+4)/2, =((($G23)*(1.5+0.2+0.25))+9)/2, =P23-Q23+P23, =((($H23+9)*(1.5+0.2+0.25+0.2)))/2, =((($G23)*(1.5+0.2+0.2+0.25))+9)/2, =((($I23)*(1.5+0.2+0.2+0.25))+9)/2, =R23-Q23+R23, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C23),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C23),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C23),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C23),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G23)*(1.55+0.2)))/2-(($G23*(1.5+0.2)))/2, =((($G23)*(1.6+0.2)))/2-(($G23*(1.5+0.2)))/2, =((($G23)*(1.65+0.2)))/2-(($G23*(1.5+0.2)))/2, =((($G23)*(1.7+0.2)))/2-(($G23*(1.5+0.2)))/2, =((($G23)*(1.75+0.2)))/2-(($G23*(1.5+0.2)))/2,
Short Spear (2-H), Fencing, 50, 2d15+2, 4, 32, =SUM(E24:F24)/2, =G24-I24+G24, 22.8854805725971, 2, =(G24+4), =(($G24*(1.5+0.2))+4)/2, =(($G24*(1.5+0.2+0.2))+4)/2, =((($G24)*(1.5+0.2+0.25))+9)/2, =P24-Q24+P24, =((($H24+9)*(1.5+0.2+0.25+0.2)))/2, =((($G24)*(1.5+0.2+0.2+0.25))+9)/2, =((($I24)*(1.5+0.2+0.2+0.25))+9)/2, =R24-Q24+R24, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C24),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C24),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C24),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C24),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G24)*(1.55+0.2)))/2-(($G24*(1.5+0.2)))/2, =((($G24)*(1.6+0.2)))/2-(($G24*(1.5+0.2)))/2, =((($G24)*(1.65+0.2)))/2-(($G24*(1.5+0.2)))/2, =((($G24)*(1.7+0.2)))/2-(($G24*(1.5+0.2)))/2, =((($G24)*(1.75+0.2)))/2-(($G24*(1.5+0.2)))/2,
Quarterstaff (2-H), Mace *, 48, 5d5+3, 8, 28, =SUM(E25:F25)/2, =G25-I25+G25, 20.705078125, 5, =(G25+4), =(($G25*(1.5+0.2))+4)/2, =(($G25*(1.5+0.2+0.2))+4)/2, =((($G25)*(1.5+0.2+0.25))+9)/2, =P25-Q25+P25, =((($H25+9)*(1.5+0.2+0.25+0.2)))/2, =((($G25)*(1.5+0.2+0.2+0.25))+9)/2, =((($I25)*(1.5+0.2+0.2+0.25))+9)/2, =R25-Q25+R25, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C25),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C25),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C25),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C25),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G25)*(1.55+0.2)))/2-(($G25*(1.5+0.2)))/2, =((($G25)*(1.6+0.2)))/2-(($G25*(1.5+0.2)))/2, =((($G25)*(1.65+0.2)))/2-(($G25*(1.5+0.2)))/2, =((($G25)*(1.7+0.2)))/2-(($G25*(1.5+0.2)))/2, =((($G25)*(1.75+0.2)))/2-(($G25*(1.5+0.2)))/2,
War Axe, Mace *, 40, 6d4+3, 9, 27, =SUM(E26:F26)/2, =G26-I26+G26, 20.4123989218329, 6, =(G26+4), =(($G26*(1.5+0.2))+4)/2, =(($G26*(1.5+0.2+0.2))+4)/2, =((($G26)*(1.5+0.2+0.25))+9)/2, =P26-Q26+P26, =((($H26+9)*(1.5+0.2+0.25+0.2)))/2, =((($G26)*(1.5+0.2+0.2+0.25))+9)/2, =((($I26)*(1.5+0.2+0.2+0.25))+9)/2, =R26-Q26+R26, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C26),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C26),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C26),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C26),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G26)*(1.55+0.2)))/2-(($G26*(1.5+0.2)))/2, =((($G26)*(1.6+0.2)))/2-(($G26*(1.5+0.2)))/2, =((($G26)*(1.65+0.2)))/2-(($G26*(1.5+0.2)))/2, =((($G26)*(1.7+0.2)))/2-(($G26*(1.5+0.2)))/2, =((($G26)*(1.75+0.2)))/2-(($G26*(1.5+0.2)))/2,
Scimitar, Swords, 43, 2d14+2, 4, 30, =SUM(E27:F27)/2, =G27-I27+G27, 21.6, 2, =(G27+4), =(($G27*(1.5+0.2))+4)/2, =(($G27*(1.5+0.2+0.2))+4)/2, =((($G27)*(1.5+0.2+0.25))+9)/2, =P27-Q27+P27, =((($H27+9)*(1.5+0.2+0.25+0.2)))/2, =((($G27)*(1.5+0.2+0.2+0.25))+9)/2, =((($I27)*(1.5+0.2+0.2+0.25))+9)/2, =R27-Q27+R27, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C27),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C27),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C27),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C27),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G27)*(1.55+0.2)))/2-(($G27*(1.5+0.2)))/2, =((($G27)*(1.6+0.2)))/2-(($G27*(1.5+0.2)))/2, =((($G27)*(1.65+0.2)))/2-(($G27*(1.5+0.2)))/2, =((($G27)*(1.7+0.2)))/2-(($G27*(1.5+0.2)))/2, =((($G27)*(1.75+0.2)))/2-(($G27*(1.5+0.2)))/2,
Broad Sword, Swords, 45, 2d13+3, 5, 29, =SUM(E28:F28)/2, =G28-I28+G28, 21.3058161350844, 2, =(G28+4), =(($G28*(1.5+0.2))+4)/2, =(($G28*(1.5+0.2+0.2))+4)/2, =((($G28)*(1.5+0.2+0.25))+9)/2, =P28-Q28+P28, =((($H28+9)*(1.5+0.2+0.25+0.2)))/2, =((($G28)*(1.5+0.2+0.2+0.25))+9)/2, =((($I28)*(1.5+0.2+0.2+0.25))+9)/2, =R28-Q28+R28, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C28),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C28),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C28),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C28),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G28)*(1.55+0.2)))/2-(($G28*(1.5+0.2)))/2, =((($G28)*(1.6+0.2)))/2-(($G28*(1.5+0.2)))/2, =((($G28)*(1.65+0.2)))/2-(($G28*(1.5+0.2)))/2, =((($G28)*(1.7+0.2)))/2-(($G28*(1.5+0.2)))/2, =((($G28)*(1.75+0.2)))/2-(($G28*(1.5+0.2)))/2,
Cutlass, Swords, 45, 2d12+4, 6, 28, =SUM(E29:F29)/2, =G29-I29+G29, 21, 2, =(G29+4), =(($G29*(1.5+0.2))+4)/2, =(($G29*(1.5+0.2+0.2))+4)/2, =((($G29)*(1.5+0.2+0.25))+9)/2, =P29-Q29+P29, =((($H29+9)*(1.5+0.2+0.25+0.2)))/2, =((($G29)*(1.5+0.2+0.2+0.25))+9)/2, =((($I29)*(1.5+0.2+0.2+0.25))+9)/2, =R29-Q29+R29, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C29),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C29),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C29),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C29),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G29)*(1.55+0.2)))/2-(($G29*(1.5+0.2)))/2, =((($G29)*(1.6+0.2)))/2-(($G29*(1.5+0.2)))/2, =((($G29)*(1.65+0.2)))/2-(($G29*(1.5+0.2)))/2, =((($G29)*(1.7+0.2)))/2-(($G29*(1.5+0.2)))/2, =((($G29)*(1.75+0.2)))/2-(($G29*(1.5+0.2)))/2,
Club, Mace *, 40, 4d5+4, 8, 24, =SUM(E30:F30)/2, =G30-I30+G30, 18.4963235294118, 4, =(G30+4), =(($G30*(1.5+0.2))+4)/2, =(($G30*(1.5+0.2+0.2))+4)/2, =((($G30)*(1.5+0.2+0.25))+9)/2, =P30-Q30+P30, =((($H30+9)*(1.5+0.2+0.25+0.2)))/2, =((($G30)*(1.5+0.2+0.2+0.25))+9)/2, =((($I30)*(1.5+0.2+0.2+0.25))+9)/2, =R30-Q30+R30, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C30),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C30),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C30),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C30),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G30)*(1.55+0.2)))/2-(($G30*(1.5+0.2)))/2, =((($G30)*(1.6+0.2)))/2-(($G30*(1.5+0.2)))/2, =((($G30)*(1.65+0.2)))/2-(($G30*(1.5+0.2)))/2, =((($G30)*(1.7+0.2)))/2-(($G30*(1.5+0.2)))/2, =((($G30)*(1.75+0.2)))/2-(($G30*(1.5+0.2)))/2,
Kryss, Fencing, 53, 1d26+2, 3, 28, =SUM(E31:F31)/2, =G31-I31+G31, 22.5, 1, =(G31+4), =(($G31*(1.5+0.2))+4)/2, =(($G31*(1.5+0.2+0.2))+4)/2, =((($G31)*(1.5+0.2+0.25))+9)/2, =P31-Q31+P31, =((($H31+9)*(1.5+0.2+0.25+0.2)))/2, =((($G31)*(1.5+0.2+0.2+0.25))+9)/2, =((($I31)*(1.5+0.2+0.2+0.25))+9)/2, =R31-Q31+R31, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C31),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C31),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C31),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C31),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G31)*(1.55+0.2)))/2-(($G31*(1.5+0.2)))/2, =((($G31)*(1.6+0.2)))/2-(($G31*(1.5+0.2)))/2, =((($G31)*(1.65+0.2)))/2-(($G31*(1.5+0.2)))/2, =((($G31)*(1.7+0.2)))/2-(($G31*(1.5+0.2)))/2, =((($G31)*(1.75+0.2)))/2-(($G31*(1.5+0.2)))/2,
Katana, Swords, 58, 3d8+2, 5, 26, =SUM(E32:F32)/2, =G32-I32+G32, 18.809756097561, 3, =(G32+4), =(($G32*(1.5+0.2))+4)/2, =(($G32*(1.5+0.2+0.2))+4)/2, =((($G32)*(1.5+0.2+0.25))+9)/2, =P32-Q32+P32, =((($H32+9)*(1.5+0.2+0.25+0.2)))/2, =((($G32)*(1.5+0.2+0.2+0.25))+9)/2, =((($I32)*(1.5+0.2+0.2+0.25))+9)/2, =R32-Q32+R32, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C32),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C32),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C32),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C32),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G32)*(1.55+0.2)))/2-(($G32*(1.5+0.2)))/2, =((($G32)*(1.6+0.2)))/2-(($G32*(1.5+0.2)))/2, =((($G32)*(1.65+0.2)))/2-(($G32*(1.5+0.2)))/2, =((($G32)*(1.7+0.2)))/2-(($G32*(1.5+0.2)))/2, =((($G32)*(1.75+0.2)))/2-(($G32*(1.5+0.2)))/2,
Dagger, Fencing, 55, 3d5, 3, 15, =SUM(E33:F33)/2, =G33-I33+G33, 11.25, 3, =(G33+4), =(($G33*(1.5+0.2))+4)/2, =(($G33*(1.5+0.2+0.2))+4)/2, =((($G33)*(1.5+0.2+0.25))+9)/2, =P33-Q33+P33, =((($H33+9)*(1.5+0.2+0.25+0.2)))/2, =((($G33)*(1.5+0.2+0.2+0.25))+9)/2, =((($I33)*(1.5+0.2+0.2+0.25))+9)/2, =R33-Q33+R33, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C33),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C33),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C33),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C33),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G33)*(1.55+0.2)))/2-(($G33*(1.5+0.2)))/2, =((($G33)*(1.6+0.2)))/2-(($G33*(1.5+0.2)))/2, =((($G33)*(1.65+0.2)))/2-(($G33*(1.5+0.2)))/2, =((($G33)*(1.7+0.2)))/2-(($G33*(1.5+0.2)))/2, =((($G33)*(1.75+0.2)))/2-(($G33*(1.5+0.2)))/2,
Wrestling, Wrestling, 50, 1d8, 1, 8, =SUM(E34:F34)/2, =G34-I34+G34, 7, 1, =(G34+4), =(($G34*(1.5+0.2))+4)/2, =(($G34*(1.5+0.2+0.2))+4)/2, =((($G34)*(1.5+0.2+0.25))+9)/2, =P34-Q34+P34, =((($H34+9)*(1.5+0.2+0.25+0.2)))/2, =((($G34)*(1.5+0.2+0.2+0.25))+9)/2, =((($I34)*(1.5+0.2+0.2+0.25))+9)/2, =R34-Q34+R34, =MIN(MAX((ROUNDDOWN(60000/((25+100)*$C34),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((30+100)*$C34),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((100+100)*$C34),0))*0.25,1.25),10), =MIN(MAX((ROUNDDOWN(60000/((120+100)*$C34),0))*0.25,1.25),10), =1/2, =3/2, =5/2, =7/2, =9/2, =((($G34)*(1.55+0.2)))/2-(($G34*(1.5+0.2)))/2, =((($G34)*(1.6+0.2)))/2-(($G34*(1.5+0.2)))/2, =((($G34)*(1.65+0.2)))/2-(($G34*(1.5+0.2)))/2, =((($G34)*(1.7+0.2)))/2-(($G34*(1.5+0.2)))/2, =((($G34)*(1.75+0.2)))/2-(($G34*(1.5+0.2)))/2,
-
Pixelclicker
- Posts: 538
- Joined: Tue Dec 28, 2010 6:55 pm
Re: Magic vs. GM
There was some trade forum thing some months ago where you acted like an anus. I don't remember what exactly it was now, so no hard feelings on my end eitherMikel123 wrote:Thanks for the An Corp. Before we get started: I have no idea who you are/were. So, bummer you thought I was a douche, but rest assured I harbored no such ill feelings towards you.
Indeed this was my own math, and indeed it looks like you ignored my response to Bazooka. For someone who calls my post a "piece of garbage", you have a profound lack of understanding of what's actually being detailed in it. I'll reiterate what I said to Bazooka: Tactics adds 1:1, as you and Bazooka mention, but all damage is halved. So 25% Tactics = 12.5% actual damage increase to players.
With respect to the Ruin-Vanq values... the +1 through +9 are *base* damage values. These are modified by things like Tactics, Anatomy, Strength, and the fact that damage is halved. So when a Vanq weapon gets "+9" to its damage, the actual amount of damage being dealt to players is only +4.5. Then when you factor in standard modifiers (100 Tactics, etc.), it nets out to 8.6. The reason this is important is because it puts the damage on a proper scale with the tactics bonus, which I turned into actual damage as well. So you're adding apples-to-apples, and the damages correspond directly to HP.
I don't know how things are rounded, so maybe Kaivan/Derrick/Batlin could weigh in on that.
Anyway, after reading your response to Bazooka and the one above, I see the source of the issue, you ARE mixing apples and oranges as you say, and you acknowledge that in one of the other posts. In columns D-F, you're listing the FULL damage before the halving. I assume G-J (GMTankDam et al.) and M-P (vanqDam60 et al.) are likewise full damage? It's not clear. It sounds like you intended to switch this convention and put the half-damage numbers for columns R-V (ruin et al.) and W-AA (tactics), but see Issue #2.
So issue #1 is that your own chart is purportedly mixing full and half damage numbers. Even if these were correct (but see issue #2) it's confusing to say the least which applies. If you're in the mood to correct it, perhaps do full damages all the way across with a note that the final damage is halved. On the Wiki Combat description, that appears to be the very last step:
http://web.archive.org/web/199910120547 ... combat.htm (See Step 10)
Issue #2 is that the numbers can't be right in either convention (half or full). Ruin is not .9 it's 1. If you're halving it, it would be .5, not .9. Might is not 2.9 it's 3 (or 1.5 if you halve it) and so on. I think the same applies with regards to the tactics values. Is there some other explanation for the decimal values for the ruin, might, etc.?
If the above Wiki link is correct, then ALL damage gets halved at the end, whatever it's source. You should be able to add average damage, bonuses for tactics, strength, and anatomy, assume 0 armor, and then halve that sum and come up with a total average damage for each weapon class based on its characteristics. You seem to agree that all damage is halved in your last post. In some other posts, however, you seem to indicate that the whole ball of wax is not treated equally, and that some of the damage is halved but some is not. If it's not, then I'm curious as to the source of the other information that contradicts the wiki steps.
Finally (Issue #3) if all damage is halved before application, the list of boss hallys is wrong too. For example, you have a +25 hally ranked lower than GM, but by any math the average damage is significantly better with the +25. Someone else posted another hally ranking that seemed more accurate.
Anyway, interested to hear your thoughts.
<@BoomlandJenkins> I got home, got on UO right away and I knew something was up before I even made it to the spawner, because there were 35+ in the Justice woods and not one person was PKing one another.
Re: Magic vs. GM
I was curious about the source of your angst, given that I haven't played in about a year, and it appears it's because youPixelclicker wrote:There was some trade forum thing some months ago where you acted like an anus. I don't remember what exactly it was now, so no hard feelings on my end either
And I instructed others in the thread to ignore your offer, which was an offer for some point in time in the future, and I wanted to do the deal in the present. What an anus I am!Offers buyout, takes 10 minutes on IRC to explain why he doesn't have the time to do a 1 minute trade.
Now then... back to the present and ignoring year-old grudges that you hold against players who have long since quit.
This was because at the time that first post was written, I believed Ruin>Vanq damage bonuses were modified by Tactics and Strength. I believe at some point since then, I was told they weren't, because my file now has them calculated without factoring in Tactics and Strength. The most recent data dump above correctly does that, so I deleted the original one on page 1 of this thread.Pixelclicker wrote:Issue #2 is that the numbers can't be right in either convention (half or full). Ruin is not .9 it's 1. If you're halving it, it would be .5, not .9. Might is not 2.9 it's 3 (or 1.5 if you halve it) and so on. I think the same applies with regards to the tactics values. Is there some other explanation for the decimal values for the ruin, might, etc.?
I'll double check the rest later today if I have time, but I'm sure it is mixing the halved damage and whole damage in a confusing way. That said, I'm also pretty sure it's right; it's just hard to follow. It made sense to me, I didn't intend this file to be shared, so readability wasn't my top priority.
Last edited by Mikel123 on Tue Jul 16, 2013 8:48 am, edited 1 time in total.
Re: Magic vs. GM
Columns D-G are base values. This is what you'll find in the UOSA web pages (if they're still around). H and I are my attempts at trying to quantify the variance of weapon damage, which is pretty important in fights (I have another post somewhere in which I detail why this is). This was a huge pain to compute, so I didn't bother doing other percentiles like 10% and 90%.Pixelclicker wrote:Anyway, after reading your response to Bazooka and the one above, I see the source of the issue, you ARE mixing apples and oranges as you say, and you acknowledge that in one of the other posts. In columns D-F, you're listing the FULL damage before the halving. I assume G-J (GMTankDam et al.) and M-P (vanqDam60 et al.) are likewise full damage? It's not clear. It sounds like you intended to switch this convention and put the half-damage numbers for columns R-V (ruin et al.) and W-AA (tactics), but see Issue #2.
Columns K through AG are all *actual* damage. And it is quite clear, because the formula for GMTankDam is:
=(($G2*(1.5+0.2))+4)/2
See the "/2" at the end? That's dividing by two. You'll see that for all columns after I, which are the actual damage columns.
Unfortunately the section of my file where I ordered this stuff seems to be just values, so I don't know how I derived it.Pixelclicker wrote:Finally (Issue #3) if all damage is halved before application, the list of boss hallys is wrong too. For example, you have a +25 hally ranked lower than GM, but by any math the average damage is significantly better with the +25. Someone else posted another hally ranking that seemed more accurate.
That said, let's test your claim of +25 vs. GM.
GM adds 4 damage. Tactics and STR don't modify this (I think I learned this midway through this thread), so that's 4/2 = 2 actual damage.
Base halberd damage averages 27. Actual halberd damage is (27 + 27*(.5 + .2))/2 = 22.95 actual damage.
+25 halberd would use the following formula: (27 + 27*(.75 + .2))/2 = 26.325 actual damage. 26.325 - 22.95 = 3.375.
So indeed, assuming my order of operations are correct (I think I confirmed this a while back with Kaivan), it looks like 2 actual extra damage from a GM and 3.375 actual extra damage from a +25. Again though, if there's rounding at some stage or another, I'd really want to take that into account.
Last edited by Mikel123 on Tue Jul 16, 2013 8:15 am, edited 1 time in total.
-
Pixelclicker
- Posts: 538
- Joined: Tue Dec 28, 2010 6:55 pm
Re: Magic vs. GM
The overall result you're coming up with (that +25 is > GM) is in line with what I came up with. Can you add callouts for each value in the formulas you use above?GM adds 4 damage. Tactics and STR don't modify this (I think I learned this midway through this thread), so that's 4/2 = 2 actual damage.
Base halberd damage averages 27. Actual halberd damage is (27 + 27*(.5 + .2))/2 = 22.95 actual damage.
+25 halberd would use the following formula: (27 + 27*(.75 + .2))/2 = 26.325 actual damage. 26.325 - 22.95 = 3.375.
So indeed, assuming my order of operations are correct (I think I confirmed this a while back with Kaivan), it looks like 2 actual extra damage from a GM and 3.375 actual extra damage from a +25. Again though, if there's rounding at some stage or another, I'd really want to take that into account.
Also, you appear to have another post with an entirely different ranking of halberds here:
viewtopic.php?f=9&t=42668
<@BoomlandJenkins> I got home, got on UO right away and I knew something was up before I even made it to the spawner, because there were 35+ in the Justice woods and not one person was PKing one another.
Re: Magic vs. GM
27 is avg base damage of weapon
.5 is the 50% tactics bonus (.75 with a +25 weapon)
.2 is the 20% bonus for 100 STR
you'd add another .2 in there for Anatomy, if assuming GM Anatomy
then divide by two because that happens to everything.
Your link to my other post is the exact same list and order as what I edited earlier this thread to be. I'm not sure what differences you're seeing.
Amusingly, in the other thread:
.5 is the 50% tactics bonus (.75 with a +25 weapon)
.2 is the 20% bonus for 100 STR
you'd add another .2 in there for Anatomy, if assuming GM Anatomy
then divide by two because that happens to everything.
Your link to my other post is the exact same list and order as what I edited earlier this thread to be. I'm not sure what differences you're seeing.
Amusingly, in the other thread:
...if I remembered that, this thread would be much cleaner. Maybe this thread should be deleted in favor of that one, which is more complete and more accurate.As for magic weapons... it's recently come to my attention that magic damage bonuses (ruin through vanquishing) are not considered part of the "base damage" of a weapon, and thus are not increased by Tactics, Strength, and Anatomy bonuses. Since all damage is halved before being applied to players (see Combat guide), the actual increase in damage by various magic weapon properties is:
-
Pixelclicker
- Posts: 538
- Joined: Tue Dec 28, 2010 6:55 pm
Re: Magic vs. GM
Ok, so another thing in the mix is that you seem to be using different formulas from what is provided by the staff. The pertinent steps in the wiki link I cited:
http://web.archive.org/web/199910120547 ... combat.htm
Says the damage for a non-magical GM Hally against a human player with no armor, shield, or magical defense (like RA) is calculated as follows:
3) Randomly determine base damage, within weapon's damage range.
4a) Determine Tactics Modifier to Damage Dealt to base damage.
4b) Add STR Bonuses to Damage Dealt to base damage.
4c) Add Anatomy Bonuses to Damage Dealt to base damage.
10) Halve all remaining damage.
11) Apply final damage.
That means an average hally hit according to this would be:
3) 27 (let's stick with the avg base damage like you use)
4a) For a 100 Tac player in that same link, this means base damage becomes 150% or 40.5
4b) For a 100 Str player, you next add 20%. 8.1 is 20% of 40.5, and so the total = 48.9 so far
4c) 0 Anat Tank mage gives no additional bonus
<NOT SHOWN> We have to add in the bonus for the weapon, so +4 for a GM, so 52.9 total.
10) halving 52.9 gives us 26.45 average damage, but you have 24.95 by your formula.
Is the UOSA damage calculation different from the wiki formula?
http://web.archive.org/web/199910120547 ... combat.htm
Says the damage for a non-magical GM Hally against a human player with no armor, shield, or magical defense (like RA) is calculated as follows:
3) Randomly determine base damage, within weapon's damage range.
4a) Determine Tactics Modifier to Damage Dealt to base damage.
4b) Add STR Bonuses to Damage Dealt to base damage.
4c) Add Anatomy Bonuses to Damage Dealt to base damage.
10) Halve all remaining damage.
11) Apply final damage.
That means an average hally hit according to this would be:
3) 27 (let's stick with the avg base damage like you use)
4a) For a 100 Tac player in that same link, this means base damage becomes 150% or 40.5
4b) For a 100 Str player, you next add 20%. 8.1 is 20% of 40.5, and so the total = 48.9 so far
4c) 0 Anat Tank mage gives no additional bonus
<NOT SHOWN> We have to add in the bonus for the weapon, so +4 for a GM, so 52.9 total.
10) halving 52.9 gives us 26.45 average damage, but you have 24.95 by your formula.
Is the UOSA damage calculation different from the wiki formula?
<@BoomlandJenkins> I got home, got on UO right away and I knew something was up before I even made it to the spawner, because there were 35+ in the Justice woods and not one person was PKing one another.
Re: Magic vs. GM
Key phrase there being "base damage".
You're applying the STR bonus to the base damage, *and* to the Tactics bonus damage.
Base damage is 27.
Tactics bonus is 50% of 27, so 13.5
STR bonus is 20% of 27, so 5.4
GM bonus of 4
27 + 13.5 + 5.4 + 4 = 49.9
49.9/2 = 24.95
You're applying the STR bonus to the base damage, *and* to the Tactics bonus damage.
Base damage is 27.
Tactics bonus is 50% of 27, so 13.5
STR bonus is 20% of 27, so 5.4
GM bonus of 4
27 + 13.5 + 5.4 + 4 = 49.9
49.9/2 = 24.95