Welcome to the Forum Archive!

Years of conversation fill a tonne of digital pages, and we've kept all of it accessible to browse or copy over. Whether you're looking for reveal articles for older champions, or the first time that Rammus rolled into an "OK" thread, or anything in between, you can find it here. When you're finished, check out Boards to join in the latest League of Legends discussions.

GO TO BOARDS


Full Magic Penetration spreadsheet

1
Comment below rating threshold, click here to show it.

Mgaak

Junior Member

07-22-2011

Heys,
Ive made a spreadsheet cause Ive found myself often baffled how does my items improve my gameplay mathwise.

There are lots of predefined stuff to see the larger picture, you can choose wheter you have Abyssal Scepter or not and you can input your spells dmg, ap and ap ratio to check how much dmg youll do after all the processes.

% M pen is applied too, in 15% (Archaic Knowledge) and 49% (AK + Void Staff) forms.

Ive made those spreadsheets in Excel 2010 but in zip file there are 2 versions, 2003 and 2010 excels if someone doest have the newest version.

Enjoy and feel free to leave some feedback.

M pen spreadsheets.zip

Comment below rating threshold, click here to show it.

FantasticMoose

Senior Member

07-22-2011

You sir, are awesome. +1


Comment below rating threshold, click here to show it.

Panwaffle

Junior Member

07-23-2011

Good job, thanks for sharing man


Comment below rating threshold, click here to show it.

ShadowDancer7

Senior Member

07-23-2011

Awesome!

*Gives cookies*


Comment below rating threshold, click here to show it.

Exhale

Member

07-24-2011

You deserve a cookie


Comment below rating threshold, click here to show it.

Mgaak

Junior Member

07-28-2011

Back with new, improved and even more user-friendly version of my M pen spreadsheet !

Inspired by option of choosing to have or not to have Abyssal Scepter I put more items inside, made everything clearer and with mini calc giving info about other less important things like CD reduction or mp/5. Hope you'll like it, enjoy and feel free to leave some feedback.

Excel 2010/2003 (Im not sure if 2003 supports some equations Ive made but I dont have any possibility to check whether it does, it doesn't work in OpenOffice though ).

M pen spreadsheets v2 by Mgaak.zip

1