Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Thief/Archer/Aran] HP Sheet
#1
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=01237...5b647fcbb4
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/LNK9...c5fd84f1d/
Thief/Archer Full Version (Lvl 31+): http://www.steekr.com/n/50-17/share/LNK9...c5a17da05/
Thief/Archer Lite Version (Lvl 120+): http://www.steekr.com/n/50-17/share/LNK7...c5b1cea8b/
Aran: http://www.steekr.com/n/50-17/share/LNK7...c58d5e23b/

(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/showpos...ostcount=4 .)

Screenshot
[Image: 82504090.th.png][Image: 31391071.th.png][Image: 62312329.th.png]
Reply
#2
Seems nice, good for planning ahead how much INT you would need =D
Reply
#3
 Spoiler
Some errors. My dropdown boxes worked just fine, but whatever you put in that column on the left doesn't work at all.
Reply
#4
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
Reply
#5
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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)