Hi Akira, first thanks for this great tool ! To be honest I tried it for a bit but was confused, so I want to make sure I'm doing this correctly: I'm a hero who wants around 18-20k hp by level 150 Current level: 70 Current Hp: 4516 Current Mp: 465 Current Base Int: 4 Int Gear: +53 Int Appreciate the help you are providing everyone here !
omg this is amazing!!!!!!!!!!! can i please head your fan club Spoiler: spoiler if youre looking for a new challenge try making some algorithm for cheapest washing, taking into account mp washing. this spreadsheet really saved my life
Just add a little bit more AP in your int to get 17 base int and you'll be able to get your goal of 20k HP by level 150 easily! You're almost there!! Sooo happy this helped you!! It always excites me that this adventure into learning Excel is useful for people! I'm actually developing a way to automatically find the base int and MP washing combination that gets people to achieve their HP washing goal with the lowest cost! It's my last major goal to achieve here and it's definitely a very difficult one haha! This is what I have so far! At present, I've been able to devise a way to find the cheapest base int and MP wash combination for the user to reach their goal HP if their manual input is insufficient. So for a person who wants to have a 30k HP BM at level 135, the cheapest way to get the MP required would be to have a base int of 324 or 334 and MP wash from either 70-135 or 72-135. The cost in AP Resets is exactly the same. However, I still have to solve the following: 1. Adjust the number of total MP washes available to the character. Currently, the number of MP washes available is calculated by the level to reset base int - level to reach target base int input by the player in cell B5. With more base int needed for MP washing, this window of available MP washes gets more and more narrow. 2. In a future update after 1. I want to be able to create a formula that factors in MP washing while still adding base int. This means a rework of the instructions I automated in the main page, but the main challenge is how to calculate the total cost of MP washing at varying total base ints if I need to factor in MP washing at levels before the total base int is reached. So that way this MP washing calculator correctly returns the cheapest way to MP wash, not just arbitrarily invalidating base ints insufficient to achieve the needed MP if the window is too narrow to do all MP washing at only that base int amount. 3. I need to account for total int gains at these base ints. As in base int + int gear int. And I have to do this level by level as base int is being added. So I have to figure out the total MP gained by merely adding base int. In the example, the user wants to stop adding base int after the get to 214. But to get their goal, my current MP washing formula tells them to add base int until they get to 324 base int. So after they have 214 base int, every two levels I have to account for 1 more MP that they naturally get from adding more base int. This reduces overall costs. 4. I need to account for Maple Warrior 10 and Maple Warrior 20 at these base ints. Should have only a minor effect, but if I want to make this perfect, I have to automatically find the MP benefit of Maple Warrior throughout all these base ints, including level by level MP gains as base int is being increased to the target. 5. I have to figure out a way to automate 3. and 4. Currently, 3. and 4. automatically factor in from the user inputs but to return a simple and clear instruction to do this much base int, start MP washing here, I have to calculate this separately outside of the user's view. It's entirely possible for someone to look at my current MP washing page and see to do this much base int, start MP washing at this level, but it's not the true lowest cost to HP wash to that goal because of all these moving parts. I don't want to make people manually tinker with numbers themselves either to find the lowest cost they can find. I want to make this absolutely perfect and automatic, so it's a work in progress!
Hej, I got a question for you. I'm about to hit 120 on my NL. I have to use all my AP points before I can job advance right? Should I just dump all 60 AP into HP and reset it out of MP later? I don't have the resets to do it right now.
You don't have to use you AP now at all if you don't want to! Saving AP or putting them all in HP now, either way is perfectly fine! When you job advance, you only have to make sure you used up the correct number of SP.
!!! I will look forward to the finished product then! (I just went through it briefly, will read it more thoroughly when i have some time, and maybe i can be of some help(?) hehe) thanks for you hard work
For some reason the "Level to start MP washing" cell (D8) shows a yes / no dropdown menu now. As a result, I cannot make the error message go away. Is this intended?
Is there any particular reason why MP washing is almost always recommended to start at 70 instead of as early as possible?
Someone put data validation (the dropdown menu) there. I removed it and now it works as it should! Thank you Photon! MP washing is best when done as late as possible because MP washing is most effective with more base int! I just put an arbitrary number in my pop up instructions when the user doesn't have enough MP because it'll almost always make the error message go away and the user can increase the MP wash start level to find the cheapest HP washing route!
Sorry again but how much Health would i be able to gain if i kept doing this till lvl 200 by using level up ap. Is it possible to reach 9.2k and if possible whats the earliest level i can do this by
9.9 for HT * and at lvl 200 youll have like 6K hp noramly. So it wouldnt be that much costs. Just keep wearing int stuffs till lvl 200 .
Not possible to reach 9.2k HP. And the new required HP for HT is 9.8k HP. 9.8k damage comes from buffed leg stomp attack. With keeping your base int at 4 and just wearing your 70 int gear, at level 200 if you HP washed all your MP out, you'd end up with 7836 HP, using all available level up AP.
Hi Yui! Your hp washing guide seems the most simple. I've tried to use but still dont understand so much I pretty bad at math and all the calculating things so can you please help me with these numbers please before i mess them up I am a lv35 Marksman, aiming for 13k hp at lv155 and will stop leeching and remove int at lv135 My current hp is 1205, current mp is 1090, 162 base int and 87 int gear. I also use MW10 and my target base int is 280. Is it even possible to get the 13k hp goal without mp washing and if cant how much base int that i need more? Thank you very much i always admire good at math people
Hey AHI shiyui lol , i think im missed smth with my calculating xDD can you help me to calculate again please? Current Level 85 Current HP - 4033 Current MP - 2256 Current Base Int 135 Int Gear - 109 Hp goal 10K by level 135 .. i think i should mp wash but i dk from what lvl .. ill be happy if you can help me ! thank you Ahi
From level 123 to level 135, put all your level up AP in MP and you'll get to your goal! Happy to help Ahi!
Hello i need some help doing this. Current level: 1 Class: NL Current Hp: 50 Current Mp: 5 Current Base Int: 4 Int Gear: +101 int by lvl 50 My goal is 30k hp thx
Hi! Trying to figure this out with the calc. Any help would be much appreciated. Current Level: 31 Current HP: 1242 Current MP: 1076 Current Base Int: 142 Int Gear: 77 Trying to figure out when I should start double washing so I can get to 15k or so. Dont have an exact level in mind, but hopefully by 120? Im a Bowmaster Thanks,
