Mage damage google sheet

Hey everyone, I made this sheet which tells you exactly how many hits it takes for you to kill certain mobs.
You can edit cell B2, B3 and B4, Just fill in your magic, your int and the element of attack (holy, fire or ice) and this sheet will do the rest.

Since this is hosted online, it may take a couple of seconds to update the table after you change a value.



Alternatively, you can download the sheet here:

Code:

https://drive.google.com/file/d/0B56X9ymsHbBnU2dqekRCcUdyMHM/view?usp=sharing

EDIT: Removed editable mastery, since that seems to be 60% regardless of skill level (in the case of genesis, blizzard and meteor shower)

 

This is great Chris, I will definitly be using it

 

Is there a way to edit on a phone browser? Or download it and save it as excel file or anything?

And that's great stuff. I was looking just for this!

 

I added a download link in the first post.

 

Awesome man thanks!

 

This is my own personal version I tweaked so I could plan equipment and such. All credit for original calculations goes to Chrizz.

https://drive.google.com/open?id=0B0hEdoGbEe4wLXJXU0NiS1JnVXc

Edit: Added calculations for magic defense

 

I made an Android app based on these two google sheets, more info here: https://royals.ms/forum/threads/magic-damage-calculator-for-android.88241/.

 

Updated arch mage damage for the new source.

Spoiler

Blizzard	.	Meteor strike	.
lvl	base damage	lvl	base damage
1	330	1	330
2	340	2	340
3	350	3	350
4	360	4	360
5	370	5	370
6	380	6	380
7	390	7	390
8	400	8	400
9	410	9	410
10	420	10	420
11	430	11	430
12	440	12	440
13	450	13	450
14	460	14	460
15	470	15	470
16	480	16	480
17	490	17	490
18	500	18	500
19	510	19	510
20	520	20	520
21	530	21	530
22	540	22	540
23	550	23	550
24	560	24	560
25	570	25	570
26	580	26	580
27	585	27	590
28	590	28	600
29	595	29	610
30	600	30	620

 

Can't seem to get either sheet working for some reason~
Looks really good though!

 

Google docs had an inherent change that made editing via embedded sheets not possible anymore. Just download it from the included link and that should work.

 

Looks like the other spreadsheets people linked to have sheet protection and forgot to make exceptions!

Fixed it.

Link here!!

 

Thanks! It's definitely a great work. However, when I examine the petrifighter perhaps you forget to consider the magic defense of a mob? Could you please update it later? Thank you again~

 

Would be great if it worked!