Closed HP Washing Spreadsheets

Discussion in 'Giving' started by Shiyui, Jul 17, 2016.

  1. KawaiiPotato
    Offline

    KawaiiPotato Donator

    Joined:
    Jul 2, 2016
    Messages:
    35
    Likes Received:
    12
    Country Flag:
    IGN:
    KawaiPotato
    Level:
    150
    Guild:
    Quackers
    1. Character level and job: 33, Gunslinger
    2. Character base int: 157
    3. Int gear, with amount of int and level requirement per item:
    Ragged red cape lvl 25 : 9 int
    Green Bandana lvl 10: 14 int
    Bathrob [M] lvl 20: 15 int
    Fallen Leaf Earing lvl 25: 3
    41 equip int
    total: 157+41: 198 int

    4. Goal HP: around 9.1k
    5. Level to hit goal HP: prefer lvl 155
     
    PleeBoy likes this.
  2. Shiyui
    Offline

    Shiyui Donator

    Joined:
    Jan 24, 2016
    Messages:
    1,285
    Likes Received:
    5,196
    Gender:
    Female
    Country Flag:
    IGN:
    Shiyui
    Level:
    200
    Guild:
    Fryslan
    Done! Download here! https://ufile.io/1cc0b

    You actually need 163 base int or 7 int more from int gear to get enough washable MP to wash to 9.1k HP at 155. So with 209 HP washes and 159 base int to reset, you'll need a total of 368 AP Resets, costing you 3.68b if you assume AP Resets at 10m each. :D
     
    Last edited: Aug 7, 2016
  3. liomio
    Offline

    liomio Well-Known Member

    Joined:
    Dec 9, 2015
    Messages:
    582
    Likes Received:
    1,507
    Gender:
    Male
    Country Flag:
    IGN:
    Liomio
    Level:
    162
    With that much int wouldn't there be a non multiple of 10 for the total int? I haven't looked at your algorithm and don't know if you've taken into account that int can't be calculated as a decimal. Just wanted to point that out :p
     
  4. Shiyui
    Offline

    Shiyui Donator

    Joined:
    Jan 24, 2016
    Messages:
    1,285
    Likes Received:
    5,196
    Gender:
    Female
    Country Flag:
    IGN:
    Shiyui
    Level:
    200
    Guild:
    Fryslan
    The MP gained per level takes into account the sum of base int with MW 20 and int from int gear. So with 157 base int with MW 20, that's 172 int. But adding the base int with MW 20 (172) with the int gear (41), you get 213. That's 21 MP gained per level, and he needs 22 MP gained per level to hit the washable MP to wash to 9.1k HP at level 155. So he either needs 163 base int or 7 int from int gear more to hit that threshold. And sorry, I made a typo above. Said 8 int from int gear, meant 7. Edited above! <3
     
  5. Sen
    Offline

    Sen Donator

    Joined:
    Jul 14, 2016
    Messages:
    2,361
    Likes Received:
    30,616
    Location:
    Shoutbox
    IGN:
    Sentenial
    1. Level & Job : 1, Archer

    2. Base INT
    : 4

    3. Gear INT
    :
    - Wooden Wand, 7 INT (Level 8)
    - Green Bandana, 17 INT (Level 10)
    - Yellow Work Gloves, 8 INT (Level 10)
    - Single Earring, 8 INT (Level 15)
    - Maple Shield, 7 INT (Level 20)
    - Bathrobe for Men, 23 INT (Level 20)
    - White Raccoon Mask, 8 INT (Level 30)
    - Silver Deputy Star, 5 INT (Level 50)
    - Yellow Snowshoes, 3 INT (Level 50)
    - Adventurer Cape, 15 INT (Level 50)

    4. Goal & Level
    : Just wondering what my HP will be by the time I hit 155. Want to see if I'll need more INT gear or if this will be okay. Thanks so much!
     
  6. Shiyui
    Offline

    Shiyui Donator

    Joined:
    Jan 24, 2016
    Messages:
    1,285
    Likes Received:
    5,196
    Gender:
    Female
    Country Flag:
    IGN:
    Shiyui
    Level:
    200
    Guild:
    Fryslan
    Done! Download here! https://ufile.io/9a2b8

    I calculated the MP you would have as a beginner as well, if you're curious!

    So you'll have 4503 HP naturally at level 155, and 1813 washable MP. That gives you 151 HP washes and with the 2718 HP you gain by HP washing, you'll end up with a total of 7221 HP. :D
     
    Sen likes this.
  7. Sen
    Offline

    Sen Donator

    Joined:
    Jul 14, 2016
    Messages:
    2,361
    Likes Received:
    30,616
    Location:
    Shoutbox
    IGN:
    Sentenial
    Ahhh thank you so so much! I'm assuming if I MP wash as well (adding natural INT as you level and then resetting all of those at the end), I'd have more washable MP?
     
  8. Shiyui
    Offline

    Shiyui Donator

    Joined:
    Jan 24, 2016
    Messages:
    1,285
    Likes Received:
    5,196
    Gender:
    Female
    Country Flag:
    IGN:
    Shiyui
    Level:
    200
    Guild:
    Fryslan
    Correct! MP washing is very expensive though, costing 5 AP Resets per level.
     
    Sen likes this.
  9. Martin
    Offline

    Martin Donator

    Joined:
    Dec 3, 2015
    Messages:
    858
    Likes Received:
    2,571
    IGN:
    Alumina
    Level:
    160
    1. Character level and job: Erhu - 159
    2. Character base int: 770
    3. Int gear, with amount of int and level requirement per item: alot
    4. Goal HP: 30000
    4.5 Goal MP: 30000
    5. Level to hit goal HP 200
     
    Shiyui likes this.
  10. Shiyui
    Offline

    Shiyui Donator

    Joined:
    Jan 24, 2016
    Messages:
    1,285
    Likes Received:
    5,196
    Gender:
    Female
    Country Flag:
    IGN:
    Shiyui
    Level:
    200
    Guild:
    Fryslan
    Sorry, I don't make spreadsheets for noob mages who die when we duo Zak.

    Screen Shot 2016-08-07 at 7.23.23 PM.png

    But you can see my spreadsheet for my 7.5k HP, 30k MP bishop here! https://ufile.io/8c4e7
     
    Martin likes this.
  11. Martin
    Offline

    Martin Donator

    Joined:
    Dec 3, 2015
    Messages:
    858
    Likes Received:
    2,571
    IGN:
    Alumina
    Level:
    160
    [​IMG]
     
    Last edited: Aug 8, 2016
  12. Maximum
    Offline

    Maximum Donator

    Joined:
    Jul 10, 2015
    Messages:
    135
    Likes Received:
    194
    Gender:
    Male
    Location:
    Canadia
    Country Flag:
    IGN:
    Walrein
    Level:
    Six
    1. Character level and job: Level 1, Warrior (Dark Knight)
    2. Character base int: 4
    3. Int gear, with amount of int and level requirement per item:
    - Wooden Wand, 6 INT (Level 8)
    - Bathrobe for Men, 19 INT (Level 20)
    - Single Earring, 7 INT (Level 15)
    - Yellow Work Gloves, 4 INT (Level 10) (I'll probably be replacing these with something much better, but I just want to see the process for achieving my goal without the upgrade)
    - Green Bandana, 14 INT (Level 10)
    - Yellow Adventurer Cape, 12 INT (Level 50)
    - Silver Deputy Star, 5 INT (Level 50)
    4. Goal HP : 30,000 HP (With HB)
    5. Level to hit goal HP: 155
     
    Last edited: Aug 23, 2016
  13. FlameHaze
    Offline

    FlameHaze Well-Known Member

    Joined:
    Jul 7, 2016
    Messages:
    133
    Likes Received:
    23
    Gender:
    Male
    Country Flag:
    IGN:
    FairyFire
    Level:
    50
    1. Character level and job: Archer, level 1
    2. Character base int: 269 (assuming I keep adding int until level 50+)
    3. Int gear, with amount of int and level requirement per item
    Wooden wand (Level 8) 15 int
    Raccoon mask (Level 35) 10 int
    Silver Deputy Star (Level 50) 5 int
    Single Earrings (Level 15) 12 int
    Bathrobe (Level 20) 30 int
    Yellow Work Gloves (Level 10) 17 int
    Red Ragged Cape (Level 25) 11 int
    Maple Shield (Level 20) 11 int
    Green Bandana (Level 10) 20 int
    Total int from equips = 131
    4. Goal HP: 11.5k
    5. Level to hit goal HP: 155
    6. Details: I plan to reset at level 125 and continue leveling without wearing these int equips. Just wondering if I'll have enough mp to wash to 11.5k by level 155. Please factor out mw20. Kindly advise if there's a more efficient way to wash. :xD:
     
  14. yuguo
    Offline

    yuguo Well-Known Member

    Joined:
    Dec 4, 2015
    Messages:
    160
    Likes Received:
    109
    Gender:
    Male
    Location:
    Singapore
    Country Flag:
    1. Character level and job:Level 44, Assasin
    2. Character base int:160
    3. Int gear, with amount of int and level requirement per item:
    Green Bandana(level10) 18int
    Single Earring(level15) 6int
    Blue Maple Flag(level0) 7int
    *Ragged Red Cape(level25) 7int>will change to a Yellow Adventure Cape(level50) 12int
    Maple Shield(level20) 10int
    Yellow Work Gloves(level10) 6int
    *Bathrobe(level20)17int>Changing to a 20int one at level 44
    Yellow Snow Shoe(level50) 2int
    White Raccoon Mask(level45) 10int
    Silver Deputy Star (Level 50) 5 int
    *MW level 10 not 20 :<
    4. Goal HP:18k
    5. Level to hit goal HP:NIL
    Thanks alot for helping out :). May i ask how much more int do i need if i want 9.5k by 120?I'll get those int by pumping more base int. Would like to buy a HTP at around level 120.
     
  15. Meikyu
    Offline

    Meikyu Donator

    Joined:
    Jun 11, 2016
    Messages:
    370
    Likes Received:
    1,031
    IGN:
    Lieve
    Guild:
    Banana
    Hello Shiyui! ~f2

    1. Character level and job: Level 42 Hunter
    2. Character base int: 160
    3. Int gear, with amount of int and level requirement per item:
    - Wooden Wand, 6 INT (Level 8)
    - Single Earring, 7 INT (Level 15)
    - Red Marker, 6 INT (Level 20)
    - Bathrobe for Women, 17 INT (Level 20)
    - Silver Deputy Star, 5 INT (Level 50)
    - Amos's Royal Cape, 9 INT (Level 50)
    - Zakum Helmet, 13 INT (Level 60)
    4. Goal HP: 9,000
    5. Level to hit goal HP: 155

    Additional info:
    I used to have other equips which I used while leveling to 42. My current HP = 1352 and MP = 1294 without equips. Also could you factor in MW10 instead of MW20?
     
    Last edited: Aug 24, 2016
  16. jpreme
    Offline

    jpreme Member

    Joined:
    Aug 22, 2016
    Messages:
    21
    Likes Received:
    10
    Gender:
    Male
    Country Flag:
    1. Character level and job: 139 corsair
    2. Character base int: 4
    3. Int gear, with amount of int and level requirement per item:
    - Maple Leaf, 6 INT (Level 0)
    - Wooden Wand, 5 INT (Level 8)
    - Red Emerald Earring, 6 INT (Level 30)
    - Yellow Work Glove, 2 INT (Level 10)
    - Bathrobe for Men, 14 INT (Level 20)
    - Silver Deputy Star, 5 INT (Level 50)
    - Amos's Spirit Cape, 9 INT (Level 50)
    - Zakum Helmet, 13 INT (Level 50)
    4. Goal HP: 7k
    5. Level to hit goal HP: 155

    Clean current HP/MP: 4634/3534

    thank you <3
     
  17. Bacon
    Offline

    Bacon GM

    Joined:
    Apr 13, 2016
    Messages:
    3,427
    Likes Received:
    1,138
    Gender:
    Male
    Location:
    Baconville, USA
    Country Flag:
    IGN:
    BaconLord01
    Level:
    200
    Guild:
    Tenacity
    1. Character level and job: 44(for now), assasin.
    2. Character base int: 203
    3. Int gear, with amount of int and level requirement per item:
    1)Green Dana: 14 int|lvl 10
    2)Amethyst Earings: 11 int|lvl 15
    3)Raggedy Yellow Cape: 8 int|lvl 25
    4)Bathrobe for men: 19 int|lvl 20
    5)Wooden Wand: 8int|lvl 8
    6)Red Marker: 7 int|lvl 20
    *7)Yellow Adventurer Cape: 10 int|lvl 50(Will equip at lvl 50)
    *8)Raccoon Mask: 9 int|lvl45(Will equip at 45)
    *9)Been using mw20 since lvl 30 also. Not sure if that plays into it.

    4. Goal HP: 10.5-12k (preferably 11k for PB preparation. but anything above 10.5)
    5. Level to hit goal HP:As long as I am at 9.2(i think its that) for ht at 155 idc when I get to 10.5-12k.
    Thank you Akira! :)
     
  18. JaeIsMyHo
    Offline

    JaeIsMyHo Donator

    Joined:
    Jul 30, 2016
    Messages:
    104
    Likes Received:
    21
    Country Flag:
    IGN:
    JaeIsMyHo
    Guild:
    NewPlanet
    I can't say perfectly, but you will definitely hit 10k earlier than 155. I think maybe around 140?
     
    Bacon likes this.
  19. LeonEuler
    Offline

    LeonEuler Donator

    Joined:
    Sep 27, 2016
    Messages:
    188
    Likes Received:
    66
    Gender:
    Male
    Country Flag:
    IGN:
    LeonEuler
    Level:
    147
    good job,pro. Akira
     
  20. mrWone
    Offline

    mrWone Well-Known Member

    Joined:
    Feb 6, 2017
    Messages:
    63
    Likes Received:
    11
    Gender:
    Male
    Country Flag:
    IGN:
    mrWone
    Level:
    0
    Hi! Shiyui-sama, are you still helping out? :D
    1. Character level and job:
    Level 1, Pirate
    2. Character base int: 4
    3. Int gear, with amount of int and level requirement per item:
    - Wooden Wand, 8 INT (Level 8)
    -Maple Shield, 7 INT (Level 20)
    - Bathrobe for Men, 23 INT (Level 20)
    -White Raccoon Mask, 9 INT (Level 45)
    - Single Earring, 6 INT (Level 15)
    -Red Marker, 9 INT (Level 20)
    - Green Bandana, 12 INT (Level 10)
    - Old Raggedy Cape, 9 INT (Level 50)
    - Silver Deputy Star, 5 INT (Level 50)
    4. Goal HP : 30,000 HP (Without HB)
    5. Level to hit goal HP: 155
    Btw, I wish to know how much base INT do I need with the said INT eqs?
    I am doing double wash.
    Thank you for your help! you are so KIND~~ <3
     

Share This Page