[Thief/Archer/Aran] HP Sheet - Printable Version

[Thief/Archer/Aran] HP Sheet - Printable Version

+- Southperry.net (https://www.southperry.net)
+-- Forum: Maplestory (https://www.southperry.net/forumdisplay.php?fid=15)
+--- Forum: Training Center (https://www.southperry.net/forumdisplay.php?fid=32)
+--- Thread: [Thief/Archer/Aran] HP Sheet (/showthread.php?tid=15354)

[Thief/Archer/Aran] HP Sheet - singularity - 2009-08-21

Thief/Archer Version:
Full version works for any levels 31+. Lite Version is only for 4th job/levels 120+.
Aran Version:
Works for levels 31+. NOTE: Currently implemented Min. MP formula = Lvl*4 + 51 // Min. MP formula to reset = Lvl*4 + 55. Use at your own risk. (Pre-GMS-released Aran HP/MP information for each level/AP is taken from this thread: http://www.southperry.net/forums/showthread.php?t=20730)

Download Links:
Containing Folder: http://www.mediafire.com/?sharekey=01237761c49a994d1319771dce87ea6fb343a95b647fcbb4
Thief/Archer Full Version (Lvl 31+): http://www.mediafire.com/download.php?02mhmmgjynv
Thief/Archer Lite Version (Lvl 120+): http://www.mediafire.com/download.php?5zimlfwn0kz
Aran: http://www.mediafire.com/?w1khnlyivyu

Additional Download Locations: (if above links are down)
Containing Folder: http://www.steekr.com/n/50-17/share/LNK92964b20c5fd84f1d/
Thief/Archer Full Version (Lvl 31+): http://www.steekr.com/n/50-17/share/LNK91574b20c5a17da05/
Thief/Archer Lite Version (Lvl 120+): http://www.steekr.com/n/50-17/share/LNK77244b20c5b1cea8b/
Aran: http://www.steekr.com/n/50-17/share/LNK76284b20c58d5e23b/

(If you want an unprotected/unlocked version of the spreadsheet, you can find one by using a containing folder link above.)

Note: The "Job selection" box may not work correctly if you use OpenOffice. (It is a dropdown box in Excel. See this post for information about what to do if you do not have functional dropdown boxes in OpenOffice: http://www.southperry.net/forums/showpost.php?p=266977&postcount=4 .)

Screenshot

[Thief/Archer/Aran] HP Sheet - Shidoshi - 2009-08-21

Seems nice, good for planning ahead how much INT you would need =D

[Thief/Archer/Aran] HP Sheet - KaidaTan - 2009-08-21

Spoiler

Some errors. My dropdown boxes worked just fine, but whatever you put in that column on the left doesn't work at all.

[Thief/Archer/Aran] HP Sheet - singularity - 2009-08-22

Obviously, that box with all errors is supposed to calculate number of resets needed. If I had to guess, OpenOffice doesn't like it when the formula in the cell tells it to calculate/output something, append a text string, then append the output of a calculation, and repeat those last two procedures one more time.

Also, it's strange that the HB output is all 0. That is much less complex than everything else.

[Edit]The stuff that doesn't work for you in OpenOffice works on Google Docs. The dropdown boxes don't work on Google Docs though. :/ (And also the combo box for HB % is broke, but the default of 60% should be what you want anyways.)

So here's the explanation for the dropdown boxes:
(Number on the left is what you put in the cell to choose the option listed on the right.)
Cell F6:
1 = No HP Wash
2 = Normal HP Wash
3 = MP Wash

Cell G9:
1 = 2nd job
2 = 3rd job
3 = 4th job

[Thief/Archer/Aran] HP Sheet - singularity - 2009-12-10

Aran version is up. Currently, it's experimental until I can confirm Aran HP and MP growth.

Unlocked versions of all spreadsheets are now available for download as well.

P.S. I would appreciate it if a mod could rename the thread for me. Thanks. Smile