Need accuracy check on my math for Soraka

[quote=Pwnzor1130]Hey guys! I made a guide for Soraka using a little spreadsheet that I made to calculate her HPS. I need some to check if my math is correct or not, as well as to inform me of any nuances in the way that the items are implemented. My guide is here:[url]http://www.mobafire.com/league-of-legends/build/mad-heals-with-soraka-50699[/url] Direct link to spreadsheet: [url]http://www.mediafire.com/?f62hf25x2e4x5or[/url][/quote]

[quote=nand]Your spreadsheet is very unorganized and hard to work with, so I'll skip it for now, but I can assure you that the formula is very straightforward and quirk-free: Base Heal = (Base Amount) + (Total AP) × (AP Ratio) Base HPS = (Base Heal) / (Cooldown) Total AP is the sum of all flat AP values, times all AP multipliers (Rabadon's Deathcap). To get the Total AP I recommend using leaguecraft.com's builder to input runes/masteries/items, as I believe mobafire's has some quirks. I'm not sure whether heal-reducing or buffing effects stack additively or multiplicatively, however.[/quote]

[quote=Pwnzor1130]Sorry about the messy spreadsheet, it was originally made to prevent me from running calculations manually. I'm just starting to work with Excel so I really don't know too much about it. I'm sure I could "hide" a lot of the math so that all you would need to do would be to input the items, masteries, and runes. The only problem is my inexperience. On the actual formulas, I'm glad that I got them correct.[/quote]

[quote=nand]You shouldn't hide the math, but you should list them in order (from top to bottom), with one field being the name and the adjacent field being the value - resize the name cells to make sure all names fit. Here's an example of what I consider a clearly laid out spreadsheet: [img]http://ompldr.org/vNzFzdw/loldamage.png[/img][/quote]