Greetings! For a long time I have been working on a HP and MP wash calculator for myself using Excel, and I figured I might as well share with you guys what I have done so far as it can be useful. Before I post the link, I want you guys to understand that this was made for myself, and so even though I am happy to share with you guys the calculator, there are many things about it that might not be working for you or be useful for you. -------------------------------------------------------------- HP and MP wash calculator HERE (Make sure to download it first to be able to use it.) -------------------------------------------------------------- How to use it: You can modify almost everything in the file if you wish, but all you really need to do is enter the right value for Maple Warrior and also what is the maximum amount of INT you want when wearing your INT gear. All the blue squares can be modified to the values that you prefer. You can change the values for the INT on your gear to the right. Remember that MP washing takes into account Base INT only. For example, you want to aim for 200 total INT, you do not have Maple Warrior and you have a 10 int overall. You just need to enter 200 to where it asks you to put the Total INT that you are aiming for, Maple Warrior as 1.0 since it will not multiply your Base INT (i.e. Maple Warrior 10 would be 1.05). Finally, just add 10 to the overall slot and the table right under will calculate everything for you. -------------------------------------------------------------- Column explanation: Level - Your character's level Base INT - Your Base INT Total INT - Your Total INT including your Base INT, Maple Warrior and your gear HP - Your HP without HP washing MP - Your MP without MP washing(however your INT is affecting it) Min MP - The minimum of MaxMP your class can have at your level HP with HPWash - Your HP if you were to HP Wash as much as possible ExtraMP from MPWash - The extra MP you would get from MP washing 5 times at your current level MP with MPWash - Your MP if you were to MP Wash since level 10(refer to the next section about how MP Washing and AP resets are calculated) HP with HPWash and MPWash - Your HP if you were to HP Wash as much as possible after MP Washing -------------------------------------------------------------- A few things to note: - I have made a page for each classes that use different values for HP/MP at level up, per AP spent and at job advancements( as well as other stuff). - At levels 1 to 9, in the Base INT section, I calculate how much INT you can have as early as possible while also taking into account how many points you need in STR or DEX to change jobs. - The values for HP and MP at job advancements, level ups and AP spent are averages, if you want to make it truly random, you will have to add a function yourself. You can find formulas to calculate gain of HP and MP HERE and HERE. - I did include extra AP, HP and MP at ALL job advancements where it is relevant. - For warriors, brawlers and magicians, I took into account the max HP and MP increase in the HP/MP level up cells and subtracted at specific levels to take into account that you need to level the skill first. - The magician page is a bit different, I did not include HP wash, only MP wash and there is no limit to base INT. - The INT from the gear is added into the Total INT column at the levels that suited me(they are written in the gear section next to the item slot). For example, I have chosen that at level 20, my shield will add to the total of INT that I currently possess. If you want to change at what level your gear starts being calculated, you will have to change the formulas in the Total INT column. - The way I calculated the number of AP resets that you need with MP washing, it starts counting as if you have been MP washing from level 10. Therefore if you start washing at level 50, the values that you will see will be much higher than what they are supposed to be, since you gain way more MP at level 50 than at level 10 if you have kept increasing your base INT(you need less AP resets). - There may be some errors or formulas that aren't correct, but for the most part it is pretty accurate, so I apologize in advance. -------------------------------------------------------------- Let me know if you have trouble using the file or if you have trouble downloading it. Feedback on the calculator and this thread is also welcome! Thanks!
I re-uploaded the file since there was a mistake in the calculation of AP resets when you MP wash. So if anyone downloaded it, they should re-download and replace the old one. My apologies.
