Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19

Thread: Updated Ecxel Character Sheet?

  1. #11
    UN Basic Recipient
    Join Date
    Feb 2018
    Posts
    9

    Re: Updated Ecxel Character Sheet?

    Hi hansnery
    you need to right-click one of the tabs at the bottom (e.g. "Instructions"), select "unhide" and then unhide the "tables" tab. You will need to translate everything there to make it work correctly as there are a lot of cross-references which require an exact match between 2 cells. Make sure to not accidentally add leading or trailing blanks.

    Have fun!

  2. #12
    UN Basic Recipient
    Join Date
    Oct 2018
    Posts
    3

    Re: Updated Ecxel Character Sheet?

    Quote Originally Posted by Adair View Post
    Hi hansnery
    you need to right-click one of the tabs at the bottom (e.g. "Instructions"), select "unhide" and then unhide the "tables" tab. You will need to translate everything there to make it work correctly as there are a lot of cross-references which require an exact match between 2 cells. Make sure to not accidentally add leading or trailing blanks.

    Have fun!


    Hello Adair, thank you for the reply! My translation is on the way. However, I noticed that some Benefits don't seem to work even if they have the requirements. Like Warg, Skinchanger, Water Dancer, Shield Mastery. Do you know how I can fix it?

  3. #13
    UN Basic Recipient
    Join Date
    Feb 2018
    Posts
    9

    Re: Updated Ecxel Character Sheet?

    You can see all requirements and if they triggered in column AG to AK on tab "Tables".
    I checked on "Warg" and it works OK in the English excel. Remember that "Warg" will require "Animal Cohort" as well as "Warg Dreams" as prerequisites, which have prerequisites on their own.

  4. #14
    UN Basic Recipient
    Join Date
    Oct 2018
    Posts
    3

    Re: Updated Ecxel Character Sheet?

    Quote Originally Posted by Adair View Post
    You can see all requirements and if they triggered in column AG to AK on tab "Tables".
    I checked on "Warg" and it works OK in the English excel. Remember that "Warg" will require "Animal Cohort" as well as "Warg Dreams" as prerequisites, which have prerequisites on their own.
    That's odd because I put the requirements but still it doesn't show even Animal Cohort.
    3 Animal Handling and 1B in Train.
    ,
    https://pasteboard.co/HK1ubv5.png
    Could you send me your file? I tested both on 3.6 and 3.1.

    EDIT:

    Nevermind! I have found out what the problem is. I need to spend all the experience first, then all the relevant benefits to my abilities will show up.

    Thank you for your help!
    Last edited by hansnery; 10-24-2018 at 08:59 PM.

  5. #15
    UN Basic Recipient
    Join Date
    Feb 2018
    Posts
    9

    Re: Updated Ecxel Character Sheet?

    I fixed a bug which prevented benefits to recognize attributes which where raised by XP. The sheet was only looking for attributes coming from the character generation sheet.

    Here are the files:
    http://www.mediafire.com/file/zelxyo...Charsheet.xlsx
    http://www.mediafire.com/file/rxv5sb...ith_Magic.xlsx

  6. #16
    UN Basic Recipient
    Join Date
    Feb 2019
    Posts
    2

    Re: Updated Ecxel Character Sheet?

    Hi,

    Thanks for the update it will really help my game! But i think i notice an issue with some of the stats regarding the shield!

    When i put specialty in shield without taking the shield mastery. It still applies the bonus to def in weapon qualities as if i had shield mastery!

    Or maybe there something i don't understand im quite new to this system

    Thanks!

  7. #17
    UN Basic Recipient
    Join Date
    Feb 2018
    Posts
    9

    Re: Updated Ecxel Character Sheet?

    Hi mickaelhb,
    can you provide an example? Shield bonus dice should not be taken into CD at all, even with shield mastery, As the sheet cannot know if you have the shield equipped, it will not be calculated. Wher eit shos up is in column "Test" for weapons but that is correct. That is actually showing the value if you attack with the shield.

  8. #18
    UN Basic Recipient
    Join Date
    Feb 2019
    Posts
    2

    Re: Updated Ecxel Character Sheet?

    yeah you missunderstand what i mean. im not talking directly on the CD stats but in the ''Item'' description.

    This is a copy of my character weapon. I do not have the shield mastery benefits but it shows the shield at def +4 shield large at +8 and tower at +10. This is affected by my +4 bonus dice specialty in shield. But it shouldn't because i don't have shield mastery.


    WEAPONS
    Weapon Quality Test Weapon Qualities Dmg Bulk
    Bastard Sword 5D+1B Adaptable 5 -
    Shield, Large 5D+3B Bulk 1, Def+8 2 1
    Shield 5D+4B Def+4 2 -
    Shield, Tower 5D+2B Bulk 2, Def+10 2 2

  9. #19
    UN Basic Recipient
    Join Date
    Feb 2018
    Posts
    9

    Thumbs up Re: Updated Ecxel Character Sheet?

    Good catch! I have fixed it. :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •