Whether you're a new player who has no idea how much int you need to HP wash or you're a player who messed up and wants to see if you can still reach your HP washing goals or you're a player who just wants to check their math, I'm offering custom HP washing spreadsheets. See here for reference: https://uploadfiles.io/b1c8117. You can change the base int and int gear cells and the spreadsheet will recalculate all other values automatically. :3 There are HP washing guides that explain exactly how to HP wash, with AP Reset mechanics and whatnot, so my focus is on simplifying the HP washing process by doing the math so people know exactly how much base int and, in some cases, MP washing, is required to reach their goals. I assume every level up (except for levels 1-9) has MW 20, but this can be factored out if asked. I also assume the int gear stats you provide me. If requested, I can calculate goal MP and level to hit goal MP. I require the following in the following format: 1. Character level and job 2. Character base int 3. Int gear, with amount of int and level requirement per item 4. Goal HP 5. Level to hit goal HP I look forward to helping you all with HP washing!
This is a great thing to give to the community! Here's a little something for people that want to give a stab at calculating their own HP Washing journey. Note that the formulas in the spreadsheet will calculate the extra HP/MP gained assuming your "Equipment Int" applies starting from level 1. Of course, this is impossible, so in order to get a more accurate measure of the exact excess HP/HP gained, you would have to properly weight the int gear. Double Washing (to the upper right of the spreadsheet) refers to MP Washing, and the quantity that you input into the cell refers to the number of fresh AP points you added into MP AFTER reaching your goal base int (which you should be doing anyway). For more information on MP/double washing, check out Jake's guide at https://royals.ms/forum/threads/how-to-mp-wash-double-wash.18158/#post-104978. Example Calculation Spoiler Let's assume you have a 7 int Wooden Wand (lvl. 8), 20 int Green Bandana (lvl. 10), 7 int Amethyst Earrings (lvl. 15), 20 int Bathrobe (lvl. 20), 10 int Raggedy Cape (lvl. 25), and 7 int White Raccoon Mask (lvl. 45). As the total int from equipment changes over time, assuming a washing plan from lvl. 1 to 135 (135 inclusive) . . . Levels 1-7 : 0 int Levels 8-9: 7 int Levels 10-14: 27 int Levels 15-19: 34 int Levels 20-24: 54 int Levels 25-44: 64 int Levels 45-135: 71int To find the appropriate excess MP gained from having your int equips by using this spreadsheet (assuming no "oh shoot I leveled up without X!"), you simply weight the total int from equips by adding up the products of the total equipment int and the # of levels for which you have that specific amount of int from gear. Then, you divide that sum by the total number of levels that your washing plan entails. In this particular case, the "average" equipment int would be ~61.7 Spoiler [(0 int * 7 lvl.)+(7 int * 2 lvl.)+(27 int * 5 lvl.)+(34 int * 5 lvl.)+(54 int * 5 lvl.)+(64 int * 20 lvl.)+(71 int *91 lvl.)]/135 A couple of things to note that are not completely accurate on the spreadsheet. 1) Pirate (gunslinger) - HP gained per wash should be 20 instead of 18 (gunslingers get a fixed value of 20 HP per wash if you use the AP reset to directly move excess MP into HP - as such, slingers should always aim to use AP resets to increase HP rather than fresh AP). 2) Thief (assassin) - Unlike gunslingers, Night Lords (assassins) gain more HP from fresh AP points (ranging from 20-24). If you intend to optimize your HP gains through fresh AP points, you should use the average value of 22 for "HP gain per AP reset" instead of the chart's listed 18. PRO TIP: If you don't want to deal with everyone simultaneously editing the public spreadsheet, just download it as an Excel Spreadsheet! Then you can have your own private version to tinker with.
I have made similar spreadsheets for my hp washing bucc and hero, but nowhere near as organized as yours! Kudos for sharing this. I noticed something I believe to be a minor mistake: the mp gained at a certain level should be calculated from the total int (base+mw20+equip) rather than separate. For example, on row 25 of your sample spreadsheet, 9 base int = 0 mp, 43 equip int = 4 mp, giving a total of 4 mp. When these are combined, 52 total int = 5 mp. I know this is a minor difference, but I think it could matter in some instances.
THANK YOU! It skipped my mind how there would be occasions when base int, MW 20, and int gear int values would add up to a higher multiple to ten, therefore giving one extra MP. I can't believe I didn't realize sooner, and I appreciate you telling me so much! I fixed it now, of course! XD Revising all my old work, my mistaken methodology had a small effect on total MP such that people would reach their target washable MP at most a level earlier, and my earlier base int recommendations could have been reduced by small amounts. I'll be fixing all my completed spreadsheets, finding the most efficient base int values, and PMing the fixed documents to the people who requested them tomorrow. I also completed a spreadsheet for a user who PMed me, and I included MP washing with the according side notes. Put the link in my original post. <3
Thanks so much for doing this Akira! 1. Character level and job : 44, Fighter 2. Character base int : 5 base int 3. Int gear, with amount of int and level requirement per item : - Green Bandana, 17 INT (Level 10) - Maple Shield, 9 INT (Level 20) - Wooden Wand, 7 INT (Level 8) - Yellow Work Gloves, 8 INT (Level 10) - Rudolph Shiny Nose, 5 INT (Level 30) - Bathrobe for Women, 19 INT (Level 20) - Single Earring, 10 INT (Level 15) - Silver Deputy Star, 5 INT (Level 50) - Yellow Snowshoes, 3 INT (Level 50) - Purple Gaia Cape, 10 INT (Level 65) 4. Goal HP I do not have a Goal HP, I would just like to know how much HP I'll have by the time I reach Level 155, assuming I do each and every HP wash possible. 5. Level to hit goal HP 155. Additional Notes: I currently have 80 INT (base + equips) per level up, but at level 50 it will change to 88 INT. I will be adding 2 fresh AP into INT to make it 90. From 65 onwards, I will be levelling with 100 INT due to the added Purple Gaia cape. Thank you so much once again for your help Akira <3
Hello, thank you for doing this: I just am starting to wash for the next level and am trying to reach 18,750 HP as I have HB. 1. Level 59, Spearman 2. Base int = 4 3. Just got the int equips today. I have 43 total int (39 from equips) 4. 18,750 5. Earliest possible but 155 latest. Thank you! Don't have MW20
Hello hello! Happy to make a spreadsheet for you, but I do need the following: 3. Int gear, with amount of int and level requirement per item And this includes all int gear you're going to use, from level 59 to level 155. <3
Oh, sorry! Here you go: Wooden Wand, 6 int, level 8 Red emerald earrings, 7 int, level 30 Zak Helm, 15 int, level 50 White Justice Cape, 11 int, level 55
Done! Download here: https://uploadfiles.io/9385415. You actually need 3 more AP into into for 7 int total. XD Staying with 4 base int and not making up that 3 int in int gear results in 566 washable MP at level 155, 74 MP short of the 640 washable MP you need to wash to 18,750 HP by then. So you'll make your latest level goal, as long as you eek out that last 3 int. <3
Thank you for making this! I really appreciate it! I have a question though. You put 14 int at level 20? What is that from? And also, you mean I need to get to 50 int total? Or?
14 int at level 20? I'm looking at my spreadsheet, and rows 2 through 59 from columns A through S should be empty. o: Yup! You need 50 int total. With your current 47 int, you have to make up 3 int either in base int or int gear upgrades.
I just saw it on the right side where it breaks down int by level? Ah okay, well I have 43 currently so I guess I needa find 7 int somehow. Thank you so much
That's a weird glitch. XD I downloaded the file again from the link I gave you, but I really don't see that 14 int at level 20 you mentioned! It doesn't affect any of the calculations, so don't worry about it. <3 Happy to help! And you're always welcome to ask for another spreadsheet whenever. I enjoy the math, haha! Happy Mapling!
haha weird. It's under "Assumes following int gear" Thanks though So basically, if I get 50 int, Ill reach 18750 at 155 right?
OHHH. LOL. I don't know why I wrote that. Fixed! https://uploadfiles.io/ade8337. Don't worry; it has nothing to do with the calcs. That section is just for your own reference about what I assumed. <3 Correct! You just need to level with 50 int from this point forward and once you hit 155, you can HP wash to 18,750 HP!
