Ashe Damage Spreadsheet, by ME!

With this you can calculate your damage per auto attack and damage per second (With and without passive).

Just a few easy steps (Not in any particular order)

• Save a copy of this to your google docs

NOTE: To be able to use this yourself and try out your own stuff, log into Google, view the spreadsheet, click "File", click "Save as Copy" and rename. It will save to your Google Drive!

• Insert AD, Crit Chance, Crit Damage, Attack Speed and Flat armor pen values from rune page into Setup 1 Runes section

• Insert AD, Crit Chance, Crit Damage, Armor Pen %, Flat armor pen and Attack Speed values from build into Setup 1 Items section

• Insert your level

• Insert the enemy's armor, and this will calculate the damage per auto and damage per second for you!

And SHAZAM, it's done.

It calculates damage on 0 armor targets by using the average ADC masteries (3 points Brute Force, 1 point Martial Mastery, 3 points Warlord, 1 point Havoc), and it also calculates damage on a target with armor (Doesn't include double-edged sword, ninja tabi, or any other form of extra damage reduction) using the formula for damage reduction

1-(100/(100+EffectiveArmor))

Effective armor is calculated like ingame league of legends (%armor pen -> Flat armor pen)

EffectiveArmor = (Armor*(1-%ArmorPen)) - FlatArmorPen

This spreadsheet also calculates DPS with attack speed. This takes into account 4 points in fury for masteries, but not frenzy. It also takes in Ashe's Attack Speed per level (3.33%), and item\rune attack speed. This does not take into account attack speed slows.

Attack speed formula

BaseAtkSpd + BaseAtkSpd*(((Level*AtkSpdPerLvl)\100)+(RuneAtkSpd\100)+(ItemAtkSpd\100)+.05 (Fury mastery)

Everything is divided by 100 because you are taking the number (3.33, 13.5, 55, 100000) and dividing it by 100 to make it a percentage, and you multiply that by BaseAtkSpd to get the bonus attack speed.

DPS Formula

DamagePerAuto * AtkSpd

With this spreadsheet, you can find the most optimal rune pages and item builds to make the best of your experience on Ashe .

I provided 2 recent pro ashe games (1 from Sneaky, 1 from Altec), and provided the links so you can see for yourself. I copied their runes and build into the spreadsheet, and you can see the difference in damage per auto. As you can see, Altec does more damage per autoattack, but since Sneaky has more attack speed, he does more DPS with his passive.

NOTE: There's a Damage per auto without passive because things like Morgana's Black Shield block the slow from Ashe's passive, effectively nullifying her passive for the duration of Black Shield on the target

Of course, you can edit it to your pleasing.

• You could change the modifiers so you calculate with the double-edged sword mastery

• You can add a poro to make the confusing numbers look cuter!

• Change stuff to be general (for almost all champions), add your own modifiers, and more!