Post-BB Bowmaster SP Distribution

I just realized I made a mistake. I forgot the new Final Attack. D:

FA has effect on the Hurricane formula, changing 140 + 2 sp to 140 + 2 sp + 0.4*150 = 200 + 2 sp. This has effect because now the +2 per sp has a less overall damage increase in %, and will make the breakpoint of when to add in Bow Expert much sooner.

Even worse, the breakpoint now depends on the Bowmasters attack from equips, since the +W.atk from Bow Expert has a significant contribution now. Let me try to explain. First the boring calculations, after that the results.

Let me first explain how I discovered it. Looking at 31 SP to distribute, what is better, 1 Hur 30 BE, or 30 Hur 1 BE? Here P2 are my own stats.

Code:

P2 = {131, 637, 110, 65, 45, 120, 150, 0, 0};
Hurricane[1, Expert[30, P2]]
Hurricane[30, Expert[1, P2]]

8.43557*10^8
8.0107*10^8

So 30 BE is stronger then 30 Hurricane! But what if I increase my attack to 300 (was 131 before)

Code:

P2 = {300, 637, 110, 65, 45, 120, 150, 0, 0};
Hurricane[1, Expert[30, P2]]
Hurricane[30, Expert[1, P2]]

1.72903*10^9
1.82668*10^9

Now 30 Hurricane is stronger! So now I changed my attack in a variable atk, and did the same for my dex and str. Then I calculated if I start with putting points in Hurricane, at how much SP in Hurricane I should put my first 2 points in Bow Expert? (2 points because the mastery of Bow Expert only increases every odd SP)

Code:

P1 = {atk, dex, str, 65, 45, 120, 150, 0, 0};
Table[Solve[Hurricane[i + 2, Expert[1, P1]] == Hurricane[i, Expert[3, P1]], atk][[1, 1, 2]], {i, 1, 28}]

{166.93, 169.691, 172.488, 175.321, 178.192, 181.101, 184.049,
187.037, 190.066, 193.135, 196.247, 199.402, 202.601, 205.845,
209.135, 212.471, 215.856, 219.289, 222.773, 226.307, 229.894,
233.534, 237.228, 240.979, 244.786, 248.652, 252.577, 256.564}

And the same vice versa: If I start with putting points in Bow Expert, when should I start with Hurricane?

Code:

Table[Solve[Hurricane[1, Expert[i + 2, P1]] == Hurricane[3, Expert[i, P1]], atk][[1, 1, 2]], {i, 1, 28}]

{166.93, 165.93, 164.396, 163.396, 161.871, 160.871, 159.355,
158.355, 156.847, 155.847, 154.348, 153.348, 151.857, 150.857,
149.374, 148.374, 146.898, 145.898, 144.431, 143.431, 141.97,
140.97, 139.517, 138.517, 137.071, 136.071, 134.632, 133.632}

Now we know in what attack range it becomes interesting: between 133 and 257 atk. Now I'm redoing the calculations in the first post, with an extra variable atk. Since whatever your attack is, Bow Expert and Hurricane are the first skills you will max, I do only the calculations where you can only put points in Bow Expert and Hurricane, and where you have 1 point in Concentrate (1 point in Sharp Eyes isn't recommended). Then calculate the best skillbuild for all possible attacks between 130 and 260.

Code:

AtkTruth[n_, stats_] := Table[If[{Element[n/2, Integers], i == If[n > 30, 30, n]} == {False, True} || i > n || n - i > 30, 0,
((Concentrate[1, stats][[8]]/360)*Hurricane[i, Expert[n - i, Concentrate[1, stats]]] +
((360 - Concentrate[1, stats][[8]])/360)*Hurricane[i, Expert[n - i, stats]])],
{i, 0, If[n > 30, 30, n]}]

AtkLazy[sp_, stats_, a_] := Module[{table, max, pos}, {table = AtkTruth[sp, stats] /. {atk -> a}; max = Max[table];
pos = Flatten[Position[table, max] - 1]; Delete[pos, 0], sp - pos[[1]]}]

AtkVeryLazy[stats_, a_] := Table[Join[{i}, AtkLazy[i, stats, a]], {i, 1, 60}]

AtkVeryVeryLazy = Table[Join[{a}, AtkVeryLazy[P3, a]] // TableForm, {a, 130, 260}]

As with the first post, AtkTruth calculates the damage of all possible skillbuilds, AtkLazy finds the maximum, AtkVeryLazy finds the maximum for all possible available SP, and AtkVeryVeryLazy finds the maximum for all possible available SP and all attacks between 130 and 260. Here are the results:

Atk
0-133	29 BE		30 Hur
134	27 BE	1 Hur 2 BE	30 Hur
135-137	25 BE	1 Hur 2 BE	30 Hur
138-139	23 BE	1 Hur 2 BE	30 Hur
140-142	21 BE	1 Hur 2 BE	30 Hur
143-144	19 BE	1 Hur 2 BE	30 Hur
145-147	17 BE	1 Hur 2 BE	30 Hur
148-150	15 BE	1 Hur 2 BE	30 Hur
151-152	13 BE	1 Hur 2 BE	30 Hur
153-154	11 BE	1 Hur 2 BE	30 Hur
155-157	9 BE	1 Hur 2 BE	30 Hur
158-159	7 BE	1 Hur 2 BE	30 Hur
160-162	5 BE	1 Hur 2 BE	30 Hur
163-164	3 BE	1 Hur 2 BE	30 Hur
165-167	2 Hur	2 BE 1 Hur	30 Hur
167-170	3 Hur	2 BE 1 Hur	30 Hur
171-172	4 Hur	2 BE 1 Hur	30 Hur
173-175	5 Hur	2 BE 1 Hur	30 Hur
176-178	6 Hur	2 BE 1 Hur	30 Hur
179-181	7 Hur	2 BE 1 Hur	30 Hur
182-184	8 Hur	2 BE 1 Hur	30 Hur
185-187	9 Hur	2 BE 1 Hur	30 Hur
188-190	10 Hur	2 BE 1 Hur	30 Hur
191-193	11 Hur	2 BE 1 Hur	30 Hur
194-197	12 Hur	2 BE 1 Hur	30 Hur
198-200	13 Hur	2 BE 1 Hur	30 Hur
201-203	14 Hur	2 BE 1 Hur	30 Hur
204-206	15 Hur	2 BE 1 Hur	30 Hur
207-210	16 Hur	2 BE 1 Hur till 28 Hur	29 BE	30 Hur
211-213	17 Hur	2 BE 1 Hur till 28 Hur	29 BE	30 Hur
214-216	18 Hur	2 BE 1 Hur till 28 Hur	29 BE	30 Hur
217-220	19 Hur	2 BE 1 Hur till 28 Hur	29 BE	30 Hur
221-223	20 Hur	2 BE 1 Hur till 28 Hur	29 BE	30 Hur
224-227	21 Hur	2 BE 1 Hur till 28 Hur	29 BE	30 Hur
228-231	22 Hur	2 BE 1 Hur till 28 Hur	29 BE	30 Hur
232-234	23 Hur	2 BE 1 Hur till 28 Hur	29 BE	30 Hur
235-238	24 Hur	2 BE 1 Hur till 28 Hur	29 BE	30 Hur
239-242	25 Hur	2 BE 1 Hur till 28 Hur	29 BE	30 Hur
243-246	26 Hur	2 BE 1 Hur till 28 Hur	29 BE	30 Hur
247-250	27 Hur	2 BE 1 Hur till 28 Hur	29 BE	30 Hur
251+	28 Hur		29 BE	30 Hur

So for example, if you have an total attack of 175, then the skillbuild that will give you the best Hurricane damage will be 1 Concentrate -> 1 Bow Expert -> 5 Hurricane -> Every level 2 SP in BE and 1 in Hur -> Max Hurricane.

An easy way to calculate your attack without looking at your equips is using this formula, where MaxDamage is the highest damage in your damage range, as seen in your stats window, including attack potions and equips, excluding Concentrate:

Attack = MaxDamage/(4*DEX + STR) * 200/3

So for example, I have a MaxDamage of 5223, and I have a total of 637 Dex and 110 Str, then my attack is 5223/(4*637+110) * 200/3 = 131, so I should max Bow Expert first, and then Hurricane.


I hope I made it a bit clear. It is quite a bit more complicated then I thought. :S