\ B d MbP?"*+_%1 Geneva1 Geneva1 Geneva1 Geneva1 Geneva1 Geneva&?'?(?)?MzHH +7G{HH(d'`@VGeneral00.00#,##0 #,##0.00"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\)"$"#,##0.00_);\("$"#,##0.00\)#""$"#,##0.00_);[Red]\("$"#,##0.00\)0%0.00% 0.00E+00#\ ?/? #\ ??/??m/d/yy d\-mmm\-yyd\-mmmmmm\-yy h:mm\ AM/PMh:mm:ss\ AM/PMh:mmh:mm:ss m/d/yy\ h:mmmmm\ d\,\ yyyymmmm\ d\,\ yyyyddd\,\ mmm\ d\,\ yyyydddd\,\ mmmm\ d\,\ yyyy / / /  / / /cC C C C C C C C C C C C C C C C C C C  C C C C C  C C  } n} } } } n} } } } } } I } n } %} I } } &} ''I } ((%7} )I  h*Single Area Mana saved %:Quick Chant %: Disruption Wind Arrow Ray Blast Rain x 1 Rain x 2 Rain x 3 Rain x 4  Prologue: Instructions:+ Analysis:-1st Strike Damage< Battle Damage CSPRSpell %Q? ףp= ?Q?(\?? ? ?D  ?D  ?D  rjThe purpose of this spreadsheet is for a Batmud blaster (mage, psi, conjurer, etc) to compare the relativef^strengths of the various spells available. It is not intended as an absolute calculation tool.tlEstimate the average amount of spell points saved with mana control and enter the percentage into the sheet.xThe QC percentage is probably close to your actual skill percentage and can be used as such. The Quick Lips boon has notwobeen incorporated into this scheme. Increase QC percentage somewhat to compensate, if you have QL. Note though,`Xthat QL+QC can make spells longer than 3 rounds complete much faster than with QC alone!f^Spell percentages are your trained percentages, but they are used as such, without consideringf^other parameters such as luck, cast generic, cast acid etc. The effects of the cast acid skillnfon spell success rate and power are unknown. However, since all spells are probably treated equally, a5-rough comparision of their power can be made.rjSpell costs vary, but remain approximately constant relative to each other. You should not need to adjust / 'spell costs unless the balance changes.x"pA table lookup is used to determine the effects of QC. The "Rounds" column doesn't include the initial round forn#fentering the spell in battle. Disruption can thus be cast only every two rounds, even though the spellJ$Bcasting time is officially 1 round. QC has no effect on disruptionn&fFull damage will vary on caster abilities and target protection. The relative strengths of the variousu'mspells are more important than there absolute power. Area spells are less powerful per monster, but the powery(qdoes not diminish as the number of monsters increases. For this reason, Acid Rain is considered for 1-4 monsters.q)iIt is assumed to be the same power as acid arrow, so for a single monster, acid arrow is more economical.-q/iBefore the MOB is aggravated, longer spells can be cast. This table does not consider the cost of castingr0jinvisibility (eliminated, if you can trust your conceal spellcasting skill). In many cases, you can choosel1da more complicated spell at this time, since there is no battle round penalty for failing the spell.i3aIdeally, a first strike spell will kill the MOB and end battle immediately. A successful Acid Ray;43level spell will kill a roughly 900-1k exp monster.l6dThe most important columns for first strike hits are average damage and the damage/sp factor, if you<74are limited by your spell point recovery (spr) rate.r9jThe casting rounds column includes fumbles, but ignores regen and invisibility requirements. It's there ton:fgive you some idea of how long it might actually take to successfully cast the spell and start combat.<l>dDuring battle, fumbles can be dangerous, since time this gives more time to the enemy to fight back.\@TThe most important factor is probably the damage / round column. Of course, powerfuljAbspells may not be needed to finish off an enemy, so a less powerful spell may be more appropriate.eE]To optimize spr, use spells with high damage / sp rates, but remember that a prolonged battleiFawill require more spells for 1) protection spells and 2) healing spells, so damage / sp isn't theGonly thing to consider.ffffff?p= ף? Spell Cost0@=@J@W@@e@ ``@ ``@D  ``@D  ``@D   "#$&'()/0134679:>@AEFG( (This is not a skill percentage) Full DamageF@R@b@ DDr@ DD@ DD b@D r@ D D @  |@ D D @ @ D D @  "#$&'()/0134679:>@AEFGRounds?@@@@ @ @ @ @  "#$&'()/0134679:>@AEF w QC+@D%g%gB+@D%g%gB+@D%g%gB+@D%g%gB+ @D%g%gB+  @D%g%gB+  @D%g%gB+  @D%g%gB+  @D%g%gB "#$&'()/0134679:>@AEFSave %  cZ?DD  o_?DD ڊe?DD H.?DD  ףp= ?DD Q?D D  Q?D D  Q?D D  Q?D D  "#$&'()/0134679:>@AEF Success %:M O? DDH}? DDv? DD cZ? DDRQ? DD Gz? D D  Gz? D D  Gz? D D  Gz? D D  "#$&'()/01369:>@AEF            " # & ' ( ) / 0 1 3 6 9 : > @ A E F   Damage (Hp)  1st Strike/ ;C@DDDDD/ P@DDDDD/ a@DDDDD/ VHo@DDDDD/ 5P|@DDDDD/ qQ`@D D D D D / qQp@D D D D D / zx@D D D D D / qQ@D D D D D            " # & ' ( ) / 0 1 3 6 9 : > @ A E F   Battle) ;OJB@DDDD) HzN@DDDD) (\a@DDDD) zGQj@DDDD) U@DDDD) \@D D D D ) l@D D D D ) {u@D D D D ) |@D D D D           " # & ' ( ) / 0 1 3 6 9 : > A E F        " # & ' ( ) / 0 6 9 : >   Single Cast Battle  Cost with MC4 ui.@"DDDDD4 1%h;@"DDDDD4 C9ѮBI@"DDDDD4 )'$T@"DDDDD4 أp= gR@"DDDDD4 On]@"D D D DD 4 On]@"D D D DD 4 On]@"D D D DD 4 On]@"D D D DD       " ' ( )  Damage / SP(o@ D D Pq@ D D @ D D Jq@ D D n? D D  X? D D  X? D D  @ D D  X@ D D  Damage / Round;OJ2@ D D:v8@ D DGzG@ D DQQ@ D D*8@ D D ?@ D D  O@ D D  W@ D D  _@ D D    1st Strike Pre-Battle Cost with MC/0,=5@DDDD/VUUUU8C@DDDD/龥P@DDDD/q`@DDDD/m(f{@DDDD/ ))e@D D D D/ ))e@D D D D/ ))e@D D D D/ ))e@D D D D  Damage / SPOC? D Dgh ? D Dh!f@ D DtI1? D D]g? D D v{'? D D  v{'? D D  昜@ D D  v{'@ D D  Casting Roundsx@ DD98@ DD#<,2@ DD@# @ DD(2@ DD ii@ D D  ii@ D D  ii@ D D  ii@ D D Rounds-> QC%{Gz?{Gz?Q?{Gz?? Q? Q? {Gz?  ףp= ? ?)\(?Q?p= ף?Q?333333?{Gz?(\? ףp= ?RQ??zG?)\(?q= ףp?Q??p= ף?HzG?Q? (\?!333333?"ףp= ?#{Gz?$Q?%(\?&ffffff?' ףp= ?(Gz?)RQ?*(\?+?,= ףp=?-zG?.Q?/)\(?0?1q= ףp?2Gz?3Q?4\(\?5?6RQ?7p= ף?8(\?9HzG?:?;Q?<= ףp=?=(\?>zG??333333?@Q?Aףp= ?B)\(?C{Gz?D?EQ?Fq= ףp?G(\?HGz?Iffffff?JQ?K ףp= ?L\(\?MGz?N?ORQ?Pp= ף?Q(\?RHzG?S?TQ?U= ףp=?V(\?WzG?X333333?YQ?Zףp= ?[)\(?\{Gz?]?^Q?_q= ףp?`(\?aGz?bffffff?cQ?d ףp= ?e\(\?fGz?g?JBNote the table is for up to 14 rounds, but only 4 rounds are used.?????? ? ? ? ? ??????????????????? ?!?"?#?$?%?&?'?(?)?*?+?,?-?.?/?0?1?2?3?4?5?6?7?8?9?:?;?<?=?>???@?A?B?C?D?E?F?G?H?I?J?K?L?M?N?O?P?Q?R?S?T?U?V?W?X?Y?Z?[?\?]?^?_?`?a?b?c?d?e?f?g?@@@@@ffffff? ffffff? ffffff? ffffff? ffffff? ffffff?ffffff?ffffff?ffffff?ffffff?ffffff???????????333333?333333?333333? 333333?!333333?"333333?#333333?$333333?%333333?&?'?(?)?*?+?,?-?.?/?0?1?2?3?4?5?6?7?8?9?:ffffff?;ffffff?<ffffff?=ffffff?>ffffff??ffffff?@ffffff?Affffff?Bffffff?Cffffff?D?E?F?G?H?I?J?K?L?M?N333333?O333333?P333333?Q333333?R333333?S333333?T333333?U333333?V333333?W333333?X?Y?Z?[?\?]?^?_?`?a?b?c?d?e?f?g?@@@333333@333333@333333@ 333333@ 333333@ ffffff@ ffffff@ ffffff@ffffff@ffffff@@@@@@@@@@@@@@@@333333@ 333333@!333333@"333333@#333333@$ffffff@%ffffff@&ffffff@'ffffff@(ffffff@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8ffffff?9ffffff?:ffffff?;ffffff?<ffffff?=?>???@?A?B333333?C333333?D333333?E333333?F333333?G?H?I?J?K?L?M?N?O?P?Qffffff?Rffffff?Sffffff?Tffffff?Uffffff?V?W?X?Y?Z?[333333?\333333?]333333?^333333?_333333?`?a?b?c?d?e?f?g?@@333333@333333@333333@333333@ ffffff@ ffffff@ ffffff@  @  @ @ @ @ @ @ @ @ @333333 @333333 @333333 @333333 @ffffff @ffffff @ffffff @ @ @ @  @!@"@#@$@%@&@'@(333333@)333333@*333333@+333333@,ffffff@-ffffff@.ffffff@/ffffff@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>333333@?333333@@333333@A333333@B333333@Cffffff@Dffffff@Effffff@Fffffff@Gffffff@Hffffff@I@J@K@L@M@N@O@P@Q@R@S@T@U@V@W@X@Y@Z@[@\@]@^@_@`@a@b@c@d@e@f@g@@@@@333333@333333@ 333333@ @ @ ffffff@ ffffff@ffffff@@@@@@333333@333333@333333@@@ffffff@ffffff@ffffff@@@@333333@ 333333@!ffffff@"ffffff@#ffffff@$ @% @& @' @( @) @* @+ @, @-333333 @.333333 @/333333 @0ffffff @1ffffff @2ffffff @3 @4 @5 @6 @7@8@9@:@;@<@=@>333333@?333333@@333333@Affffff@Bffffff@Cffffff@Dffffff@E@F@G@H@I@J@K@L@M@N@O@P@Q@R333333@S333333@T333333@U333333@Vffffff@Wffffff@Xffffff@Yffffff@Zffffff@[@\@]@^@_@`@a@b@c@d@e@f@g@@@@@333333@333333@ @ @ ffffff@ ffffff@ @@@@333333@333333@@@ffffff@ffffff@@@@@333333@333333@@@@ ffffff@!ffffff@"@#@$@%@&333333@'333333@(333333@)@*@+ffffff@,ffffff@-ffffff@.@/@0333333@1333333@2333333@3ffffff@4ffffff@5 @6 @7 @8 @9 @: @; @< @= @>333333 @?333333 @@333333 @Affffff @Bffffff @Cffffff @D @E @F@G@H@I@J@K@L333333@M333333@N333333@Offffff@Pffffff@Qffffff@Rffffff@S@T@U@V@W@X@Y@Z@[333333@\333333@]333333@^ffffff@_ffffff@`ffffff@a@b@c@d@e@f@g@@@@333333@333333@@ ffffff@ ffffff@ @ @ @333333@333333@@@ffffff@ffffff@@@@333333@333333@@@ffffff@ffffff@@@@ 333333@!333333@"@#@$ffffff@%ffffff@&@'@(@)@*333333@+333333@,@-@.ffffff@/ffffff@0@1@2@3@4@5333333@6333333@7@8@9@:ffffff@;ffffff@<@=@>@?333333@@333333@Affffff@Bffffff@Cffffff@D @E @F @G @H @I @J @K @L @M333333 @N333333 @O333333 @P333333 @Qffffff @Rffffff @Sffffff @Tffffff @U @V @W @X @Y@Z@[@\@]@^@_@`@a@b@c@d@e@f@g@   @ @ @ 333333@ @ @ ffffff@ @ @ @ 333333@ @ @ ffffff@ @ @ @ 333333@ 333333@ @ ffffff@ ffffff@ @ @ @ 333333@ 333333@ @ ffffff@ ffffff@! @" @# @$ 333333@% 333333@& @' ffffff@( ffffff@) @* @+ @, @- 333333@. 333333@/ @0 @1 ffffff@2 ffffff@3 @4 @5 @6 333333@7 333333@8 333333@9 @: @; ffffff@< ffffff@= @> @? @@ @A 333333@B 333333@C 333333@D @E @F ffffff@G ffffff@H @I @J @K 333333@L 333333@M 333333@N ffffff@O ffffff@P  @Q  @R  @S  @T  @U  @V  @W  @X  @Y 333333 @Z 333333 @[ 333333 @\ ffffff @] ffffff @^ ffffff @_  @`  @a  @b  @c @d @e @f @g @!!"@!!@!!@!!@!ffffff!@!333333!@ !!@ ! @ ! @ ! @ !ffffff @!333333 @! @! @!@!333333@!@!@!ffffff@!@!@!@!333333@!@!ffffff@!ffffff@!@!@!@ !333333@!!@"!@#!ffffff@$!@%!@&!@'!333333@(!333333@)!@*!ffffff@+!ffffff@,!@-!@.!@/!333333@0!333333@1!@2!ffffff@3!ffffff@4!@5!@6!@7!@8!333333@9!@:!@;!ffffff@<!ffffff@=!@>!@?!@@!@A!333333@B!333333@C!@D!@E!ffffff@F!ffffff@G!@H!@I!@J!@K!@L!333333@M!333333@N!@O!@P!ffffff@Q!ffffff@R!@S!@T!333333@U!333333@V!333333@W!ffffff@X!ffffff@Y! @Z! @[! @\! @]! @^! @_!333333 @`!333333 @a!ffffff @b!ffffff @c! @d! @e!@f!@g!@""$@"#@"#@"ffffff#@"333333#@"333333#@ "#@ ""@ ""@ "ffffff"@ "333333"@""@"!@"!@"!@"ffffff!@"333333!@"!@" @" @"ffffff @"ffffff @"333333 @" @"@"333333@"333333@"@"ffffff@ "@!"@""@#"333333@$"@%"ffffff@&"ffffff@'"@("@)"333333@*"333333@+"@,"ffffff@-"ffffff@."@/"@0"@1"333333@2"@3"@4"ffffff@5"@6"@7"@8"@9"333333@:"@;"@<"ffffff@="ffffff@>"@?"@@"@A"333333@B"333333@C"@D"@E"ffffff@F"ffffff@G"@H"@I"@J"@K"333333@L"333333@M"@N"@O"ffffff@P"ffffff@Q"ffffff@R"@S"@T"@U"@V"@W"333333@X"333333@Y"333333@Z"@["@\"@]"ffffff@^"ffffff@_"ffffff@`"ffffff@a"ffffff@b"@c"@d"@e"@f"@g"@##&@#%@#%@#ffffff%@#333333%@#%@ #$@ #$@ #ffffff$@ #333333$@ #$@##@##@#ffffff#@#333333#@##@#"@#"@#ffffff"@#333333"@#333333"@#"@#!@#!@#ffffff!@#333333!@#!@# @# @ #ffffff @!#ffffff @"#333333 @## @$#@%#333333@&#@'#@(#ffffff@)#@*#@+#333333@,#333333@-#@.#ffffff@/#@0#@1#@2#333333@3#333333@4#@5#ffffff@6#@7#@8#@9#333333@:#333333@;#@<#ffffff@=#ffffff@>#@?#@@#@A#333333@B#333333@C#@D#@E#ffffff@F#@G#@H#@I#@J#333333@K#333333@L#@M#@N#ffffff@O#ffffff@P#@Q#@R#@S#@T#333333@U#333333@V#@W#@X#ffffff@Y#ffffff@Z#@[#@\#@]#@^#@_#333333@`#333333@a#@b#@c#@d#ffffff@e#ffffff@f#@g#@$(@$'@$'@$ffffff'@$333333'@$'@ $&@ $ffffff&@ $333333&@ $&@ $%@$%@$ffffff%@$333333%@$%@$$@$$@$ffffff$@$333333$@$$@$#@$#@$ffffff#@$333333#@$#@$"@$"@$ffffff"@$333333"@ $"@!$!@"$!@#$ffffff!@$$333333!@%$!@&$ @'$ @($ffffff @)$ffffff @*$333333 @+$ @,$@-$333333@.$@/$@0$ffffff@1$@2$@3$333333@4$333333@5$@6$ffffff@7$@8$@9$@:$333333@;$@<$@=$ffffff@>$@?$@@$@A$333333@B$333333@C$@D$ffffff@E$ffffff@F$@G$@H$@I$333333@J$333333@K$@L$ffffff@M$ffffff@N$@O$@P$@Q$@R$333333@S$@T$@U$ffffff@V$ffffff@W$@X$@Y$@Z$333333@[$333333@\$@]$@^$ffffff@_$ffffff@`$@a$@b$@c$333333@d$@e$@f$ffffff@g$@%*@%)@%)@%333333)@%)@%(@ %(@ %ffffff(@ %(@ %'@ %'@%ffffff'@%333333'@%'@%&@%ffffff&@%333333&@%&@%%@%%@%ffffff%@%333333%@%$@%$@%ffffff$@%333333$@%$@%#@%#@ %ffffff#@!%333333#@"%#@#%"@$%"@%%ffffff"@&%333333"@'%"@(%!@)%!@*%ffffff!@+%333333!@,%!@-% @.% @/% @0%ffffff @1%333333 @2% @3%@4%333333@5%333333@6%@7%ffffff@8%@9%@:%@;%333333@<%@=%ffffff@>%ffffff@?%@@%@A%333333@B%333333@C%@D%ffffff@E%ffffff@F%@G%@H%@I%333333@J%@K%@L%ffffff@M%@N%@O%@P%@Q%333333@R%@S%@T%ffffff@U%ffffff@V%@W%@X%@Y%@Z%333333@[%333333@\%333333@]%@^%@_%ffffff@`%ffffff@a%ffffff@b%ffffff@c%@d%@e%@f%@g%@&,@&+@&ffffff+@&333333+@&+@&*@ &ffffff*@ &333333*@ &*@ &)@ &ffffff)@&333333)@&)@&(@&ffffff(@&333333(@&(@&'@&ffffff'@&333333'@&'@&&@&ffffff&@&333333&@&&@&%@&%@&ffffff%@&%@ &$@!&$@"&ffffff$@#&333333$@$&$@%&#@&&#@'&ffffff#@(&333333#@)&#@*&"@+&"@,&ffffff"@-&333333"@.&"@/&!@0&!@1&ffffff!@2&333333!@3&!@4& @5& @6&ffffff @7&ffffff @8&333333 @9& @:&@;&333333@<&@=&ffffff@>&ffffff@?&@@&@A&333333@B&333333@C&@D&ffffff@E&@F&@G&@H&333333@I&@J&@K&ffffff@L&@M&@N&@O&333333@P&333333@Q&@R&@S&ffffff@T&@U&@V&@W&@X&333333@Y&@Z&@[&ffffff@\&ffffff@]&@^&@_&@`&@a&333333@b&333333@c&@d&@e&ffffff@f&ffffff@g&@(#include "stdio.h"((double QuickChant(( double skill,( int rounds) ({( if(rounds < 2)' ( { return (double)rounds; ( } ( else ( { if(rounds == 2)J (B { return 2-skill; // 2 round - 1 QC throw( }( else2(* { double failed = 1 - skill;( X(P return 1 // Obligatory 1 round_(W + skill * // First QC throw succceedsa(Y ( skill * QuickChant(skill, rounds - 3) // Greater hasteW(O + failed * QuickChant(skill, rounds - 2)) // Hastec([ + failed * QuickChant(skill, rounds - 1); // First QC throw fails( } ( } (}(( int main() ({( double skill;"( double averageTime;( int rounds; ( +!(# printf("\nQuick Chant Table:"); "( 7#(/ for(skill = 0.0;skill < 1.01;skill += 0.01)+$(# { printf("\n%4.2lf", skill);4%(, for(rounds = 1;rounds < 15;rounds++)=&(5 { averageTime = QuickChant(skill, rounds);4'(, printf(", %4.1lf", averageTime);(( } )( } *( +( return 0; ,(} ) )= `'@8>