1. Before posting any MODs, please contact us at support@portalarium.com to ensure your MOD is acceptable to the Terms of Service and EULA of the game. Portalarium is not responsible for use of MODs and possible adverse effects on your client or computer, and we may take action on accounts using MODs that are deemed illegal. Whether submitted here or elsewhere in the community, use MODs at your own risk!
    Dismiss Notice

XP Planner

Discussion in 'Player Created Resources' started by Rosemourne, May 8, 2018.

  1. Tazar

    Tazar Bug Brigade - Bug Hunter

    Messages:
    541
    Likes Received:
    1,600
    Trophy Points:
    75
    Gender:
    Male
    Location:
    Dallas Texas
    :) OK. Well - now you have a detail list! lol
     
    Rosemourne likes this.
  2. Brielle McFerson

    Brielle McFerson Avatar

    Messages:
    69
    Likes Received:
    143
    Trophy Points:
    8
    Gender:
    Female
    Location:
    Minnesota
    Looking at the spreadsheet just now. Column L4 has #Ref! What should be populating that?
     
  3. Rosemourne

    Rosemourne Avatar

    Messages:
    333
    Likes Received:
    1,103
    Trophy Points:
    43
    I'm really not sure what happened there. It's fixed now. Bizarre.
     
  4. Brielle McFerson

    Brielle McFerson Avatar

    Messages:
    69
    Likes Received:
    143
    Trophy Points:
    8
    Gender:
    Female
    Location:
    Minnesota
    thank you so much! It's working now and I am sad to see how much XP I need to get to where I want to be. lol
     
  5. Ryodin Stormwind

    Ryodin Stormwind Avatar

    Messages:
    251
    Likes Received:
    430
    Trophy Points:
    28
    I have a couple questions about using this tool:
    1. Are my changes being shared with others who are also trying to use the tool at the same time? If so, is there a way I can work on a local copy without overwriting other people's changes?

    2. Am I doing something wrong here, or is this a bug:
      [​IMG]

      Notice the required experience column when both the current and required level are set to the same value here...
    Thanks for the work on the tool!



    *EDIT* Regarding the bug in bullet point 2 above: The formula for the Bladed Combat Required XP cell seems to be using the values from the Rend row (J19 instead of J15).
     
    Last edited: May 30, 2018
  6. Daigoji Gai

    Daigoji Gai Avatar

    Messages:
    475
    Likes Received:
    963
    Trophy Points:
    55
    Gender:
    Male
    Location:
    NYC & CT
    It is being publicly shared, so anyone with a link can edit.
    I would recommend downloading the file in a format of your choice (or saving a copy to Google Sheets if you don't have a desktop spreedsheet app) for edits and changes.
     
  7. Lesni

    Lesni Avatar

    Messages:
    941
    Likes Received:
    2,094
    Trophy Points:
    105
    Gender:
    Male
    Location:
    Novia
    I downloaded a copy in Excel format and saved it to my OneDrive folder.
    I can view/edit it for my own avatar.
    One note, the downloaded Excel version comes up with some errors that Excel can fix automatically.
    Also, I 'auto' set the row height to a better size for viewing for me.

    Thanks for a fantastic tool.
     
    Rentier and CatherineRose like this.
  8. Rosemourne

    Rosemourne Avatar

    Messages:
    333
    Likes Received:
    1,103
    Trophy Points:
    43
    It will work, mostly, in Excel. It does use the FILTER function in a couple of spots for simplicity vs. an array. The problem there being it's a google only function. It shouldn't affect anything but the drop-down menus, however.
     
  9. Lesni

    Lesni Avatar

    Messages:
    941
    Likes Received:
    2,094
    Trophy Points:
    105
    Gender:
    Male
    Location:
    Novia
    Everything works as far as I can tell so far.
    If it does not, I work with Excel a lot so I'm sure I can fix it.
    It is an amazing tool.
     
    Sara Dreygon and CatherineRose like this.
  10. Glepo

    Glepo Avatar

    Messages:
    32
    Likes Received:
    11
    Trophy Points:
    8
    Gender:
    Male
    Location:
    Finland
    Are we getting update on this? New fishing skills are missing.
     
  11. Magnus Zarwaddim

    Magnus Zarwaddim Avatar

    Messages:
    883
    Likes Received:
    1,751
    Trophy Points:
    93
    I'm curious how the Attunement calculation works. It seems to be off. It's saying my Death Attune is 111, but I am currently seeing 172 in game (also says my desired is 120, when it should probably closer to 200). I notice that it is calculating Life skills, which was supposed to be the antithesis of Death - however, I thought this was removed from the game (opposing skill reducing power of main skill) and was only supposed to work with Specialization of a skill.
     
  12. Rosemourne

    Rosemourne Avatar

    Messages:
    333
    Likes Received:
    1,103
    Trophy Points:
    43
    Attunement shown in game will include gear and spell effects. The spreadsheet will only show attunement gained by skills. Attunement is calculated by taking the highest 10 skills and averaging them. To get 172 attunement from skills you would need 10 skills averaging 172 in level. If you strip your character of all effects and items you will see what is listed on the sheet.

    I fixed that. The sheet hasn't been updated in a while. There are new skills and changes to how things work since May (When I last worked on the sheet). In the very least I fixed the attunement.
     
    Sara Dreygon likes this.
  13. Magnus Zarwaddim

    Magnus Zarwaddim Avatar

    Messages:
    883
    Likes Received:
    1,751
    Trophy Points:
    93
    Ahhh, thanks for pointing this out and for the work going into the spreadsheet. I use it quite often. :)
     
  14. Rosemourne

    Rosemourne Avatar

    Messages:
    333
    Likes Received:
    1,103
    Trophy Points:
    43
    Alrighty. I've gone ahead and updated it to include fishing skills (Only half a year late, no big) and attunement / specialization changes.
     
    Glepo and Jaesun like this.