If it wasn't detrimental to their battleship skill, I'd definitely give it a shot . Maybe I'll try a bandit.
So today I decided to do a ton of math to see whether doing a 30k HP 30k MP mage was best done as a beginner or advancing normally as a magician. I uploaded my spreadsheets in the links here: Beginner: 36.14b total cost 3614 AP Resets total (785 MP washing, 2829 HP washing) Level 129 for 30k HP, do first, second, third, fourth job advancements at level 129 after HP washing Level 173 for 30k MP MP washing from levels 17 to 173 Magician: 28.41b total cost 2841 AP Resets total (930 MP washing, 1911 HP washing) Level 161 for 30k HP Level 196 for 30k MP MP washing from levels 11 to 196 So doing 30k/30k job advancing normally gets you there cheaper, but slower. Staying as a beginner costs 7.73b more but gets you there faster. I assumed all AP was put in int every level on time, with MW 20 at each level up. All levels for MP washing are assumed to have all AP per level up put into MP and then reset into int before the next level up. I also noted what int gear I assumed in my calculations. It's important to note that I only calced for what gear I would personally use, so it's worth checking what your own int gear would yield. The correct magician formulas are in the spreadsheets, but also noted here for information purposes. MP gained per level: 22-24 +(2*Improving Max MP Increase level+total INT/10) MP gained per fresh AP in MP: 18-20 +(2*Improving Max MP Increase level) First job minimum MP: Level*22+38 Second, third, fourth job minimum MP: Level*22+488 MP lost per AP Reset: -30 MP @LinDan Since you asked, here you go! @Martin I dare you!! @Selma Super duper perfect bishop? ouo @FM69 I saw your inbox message from a few days ago, but I only did the spreadsheets tonight. You must MP wash to get a 30k HP beginner. It's absolutely impossible to get a 30k HP beginner without MP washing, even by going full int every single level, with MW 20 and godly int gear. You can see how MP washing would work in column N. MP washing is your base int divided by 10, the result of which is subtracted by 8. MW 20 and int gear do not play a role in MP washing. Every time you take AP out of MP, you lose 8 MP. So your net gain per MP wash is (base int/10)-8. Doing this with all 5 level up AP per level means per level, your MP washing results in (base int/10)*5-(8*5). You'll have 30k HP at level 129 and 30k MP at level 189. This requires you to MP wash from levels 17 to 189. This will cost you 36.94b total, 3694 AP Resets. 865 of these are for MP washing and 2829 are needed for HP washing. And yes, this assumes full int. Your spreadsheet is here.
Can you show the formula in column G? It doesn't show for me in excel. I want to know, because I'm quite sure there is a mistake.
For level 30, row 31, it is: =ROUNDDOWN(G30+(D31)+E31+((B31*1.1)/10)) In other words, it is: =ROUNDDOWN (Total MP of Previous Level + (Natural MP) + Int Gear MP Gains + ((Base Int * 1.1)/10)) You're probably concerned with how I wrote "+ (Natural MP) +" in the formula, so let me explain. Column D is labeled as Natural MP, but for levels where the character is a magician, the column is actually MP gained per level. I was able to find the formula for magician's MP gain per level but not the natural MP itself. This formula is: 22-24 +(2*Improving Max MP Increase level+total INT/10). For levels where the character is a beginner, say at level 2, row 3, the formula is: =ROUNDDOWN(G2+(D3-D2)+E3+((B3*1.1)/10)) You'll notice that I wrote instead of "+ (Natural MP +," I wrote "Natural MP for that level - Natural MP for the previous level." The main goal of the formula in column G is to account for the amount of MP naturally gained by level up. As the beginner class, it is with the standard natural MP formula and after job advancing to a magician, it's adjusted since I only know the formula for the natural MP gained per level up itself. Hopefully this clarifies things Chris! Oh and the cell value of G2 is just 5, the base MP of every level 1 character. Edit to say that after HP washing, I edited the G cell such that the MP of the previous level was manually changed to the minimum MP of the previous level. So if we were to HP wash at level 30, the formula for level 31, which is row 32 column G would be =ROUNDDOWN(1148+(D31)+E31+((B31*1.1)/10)). This manual edit for the level after the one where you HP washed out all available washable MP only has to occur in this level after HP washing. The rest of column G works fine for calculating total MP from this point to level 200.
Thanks for the clarification, I now understand what you're doing in the beginner sheet. However, there are some minor mistakes (in both sheets): When a character is lvl 3, he has 30 MP and 23 base int. When he levels up, he gets 11MP + the int bonusses that he had at lvl 3. You can't add your 5 lvl-up AP into int before you get your lvl-up MP. So in this case you would get rounddown(23*1.1/10) = 2MP instead of rounddown(28*1.1/10)=3MP Thus, the MP at lvl 4 is 43 instead of 44. The difference at lvl 128 is 70MP, so it doesn't affect the final conclusion very much, but it's worth noting. Another thing worth mentioning is that you won't have MW on maple island, though this won't affect the final conclusion very much either. I'm not 100% sure, but I think maplewarrior doesn't round down, but rounds half-up. If this is true, then it shouldn't be: rounddown(23*1.1/10), but rounddown(round(23*1.1)/10)). The difference at lvl 128 is 5MP, so it's pretty insignificant, but it shouldn't be hard to figure out whether MW rounds half-up, up or down (I don't have MW though). Also, you calculate the MP gained from equips separately from the MP gained from base int. However, I don't think that's how maple does it. This can make a difference. For example if you have 18 base int and 3 equip int (let's ignore MW for now) your total int is 21, so you will get 2 MP. However, the way you calculate it, you would only get 1+0= 1 MP. In column J you have washable MP, but it seems like you haven't taken into account that the minimum MP for washing is 175*. For example in the beginner sheet, at lvl 17, you wouldn't have 278 - 162 = 116 washable MP, but 278 - 175 = 103 washable MP. * I haven't seen anyone mention this, but from my own testing, the absolute minimum MP for MP washing is somewhere in between 173 and 182. I expect 175, but I'm not 100% certain it's exactly that. I'm still confused about the mage sheet. At lvl 9 the natural MP is 47. But according to the formula you gave, shouldn't it be 23+(2*0 + 48/10) = 28?
Thank you for pointing out my mistakes!! I'm grateful; I checked myself but it's easy to glance over things without thinking them through from a fresh perspective. When a character is level 3, he has 23 base int and 17 MP actually. I realized this is confusing, so in my revised spreadsheets, I edited the levels at which to wash to the HP and MP targets by bumping them up one. So you see, in row 4 column G, the formula is =ROUNDDOWN(MP after leveling up from level 2 to level 3+(Natural MP at level 3 - Natural MP at level 2)+(Total int at level 3/10)). The formula itself is " =ROUNDDOWN(G3+(D4-D3)+((F4)/10))". Row 4 column G thus tells you the total MP you would have when leveling up from level 3 to level 4, which just means it's the total MP you'd have at level 4, not level 3 like you'd think. Sorry for it being so counterintuitive hahaha! I overlooked how I was calculating for Maple Warrior on Maple Island! Thank you!! The earliest a character can leave Maple Island is at level 7, so I started factoring in Maple Warrior beginning at when you level up from level 7 to 8. This would be in row 8 column F. I do believe Maple Warrior rounds down though. I'll check this later today and get back to you on what exactly Maple Warrior totals to with various base stat values. THANK YOU! I made a spreadsheet for a friend who was HP washing her bucc some time ago and she pointed out the very same thing to me, how I shouldn't calculate base int and int gear MP gains separately. I took a break from spreadsheets for a while and I redownloaded one that I had sent her to use as a template when I was calcing for 30k HP 30k bishops. I realize now I had downloaded an old version with this error. It has now been recorrected as you can see in column F. At level 30, in row 31 column F, the formula is now a straightforward =ROUNDDOWN(B31*1.1)+C31. The corresponding row's total int formula, row 31 column G, is thus =ROUNDDOWN(G30+(D31-D30)+((F31)/10)). So total int is divided by 10 to give an accurate total MP gain from both base int and int gear. I do believe my column J formulas are correct though. The minimum MP for a beginner, at least from what I read here (hyperlink), is minimum MP for a beginner = 10*Level + 2. I have not tested this myself at all, but until I have data that says otherwise, I'll keep this formula in. Typically, minimum MP values will increase as level increases. I don't think the minimum MP for a level 1 and level 200 beginner are both somewhere in between 173 and 182, but please feel welcome to provide data to clarify exactly how minimum MP for beginners work!! You're very correct that I made a mistake in calculating the natural MP gains of a magician from levels 8 through 12. I have corrected the natural MP gains of the first five levels of a first job magician in both spreadsheets. I assumed that 5 SP was put in Improving MP Recovery first in order to fulfill the prerequisite for Improved MaxMP Increase. Improved MaxMP Increase was then maxed, and the spreadsheet continues as normal. Thank you for catching this!! Also, added one extra AP Reset for resetting the last AP in HP to int. I also edited the 13 AP you start with at level 1 and proceeded with 12 AP in int at level 1, assuming you put the requisite 1 AP in HP at level 1. Revised results: Beginner: 36.05b total cost 3605 AP Resets total (775 MP washing, 2829 HP washing) Level 130 for 30k HP, do first, second, third, fourth job advancements at level 130 after HP washing Level 172 for 30k MP MP washing from levels 17 to 171 Magician: 27.81b total cost 2781 AP Resets total (870 MP washing, 1910 HP washing) Level 157 for 30k HP Level 190 for 30k MP MP washing from levels 16 to 189
A level 1 character has 5 mp and 13 int. He levels up and gets 11 natural and 1 bonus mp. 5+11+1 = 17 MP. This character is now level 2 (not 3), and has 17 MP. The general formula for minimum MP for MP washing for beginner is indeed 10*Level+ 2. However the actual minimum is never lower than 175 (from my testing, which I should do more of), so the excel formula would be: =MAX(10*Level+ 2, 175). Here's how I would do it (assuming that maple warrior rounds half-up, which may not be the case, but other than that it should be correct): Code: https://docs.google.com/spreadsheets/d/1kSWrmm72U8gm3PNUZP2OOZocCbXp8PoiRqRL_ZIE1vY/pub?output=xlsx
Btw, since the new source, beginners can't add points to HP or MP until lvl 20. I made a feedback thread about that a few months ago. You probably would be able to add HP using an AP reset, if AP resets were working... EDIT: No, you can't even use AP resets before lvl 20 anymore.
Turns out I wasn't completely right, but I was onto something. There is indeed a general minimum MP for all classes. So even if you expect to be able to take out MP according to the class-specific minimum MP, if your MP is under this general minMP, you won't be able to take out MP. https://royals.ms/forum/threads/the-true-minimum-maxmp.45740/ IIRC putting AP in MP only gives you 1*Improving Max MP Increase level. I will test this later today. This would be make a huge difference. So big in fact that it would even be cheaper to stay a beginner until you have 30k HP. EDIT: I tested it, and I found that adding a fresh AP into MP indeed only gives 18-20 + 1*Improving Max MP Increase level. This means that the only viable option to get a 30K/30K mage is to stay beginner until you have 30K HP. EDIT2: It is still possible to do it as a mage but you'll need very good int equips and you'll have to MP wash from lvl 20 to 200.
This thread was extremely helpful. Thank you to all who took the time to make your calculations and answers.
