Announcement

Collapse
No announcement yet.

Advanced Character Generator

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Refhi
    started a topic Advanced Character Generator

    Advanced Character Generator

    Hello,

    Me and Yoyoda worked a big amount of time on this Excel & Libreoffice (v6+) "Character Generator"

    To use it click & save on hard drive, THEN open it (or this pecky read-only mode will mess everything)
    Excel : http://refhi.free.fr/exalted3/Fiche%...b.xlsx
    LibreOffice : http://refhi.free.fr/exalted3/Fiche%...ab.ods

    Its main features :
    - give a user-friendly (a complete newbie should be able to make a character. Almost.) way to quickly/easily build characters throught the initial points repartition, the bonus point part, the XP spending and the printing (if you want).
    - automatic scores and defense calculations including weapons and armors !
    - automatic Charms description
    - Charms Prerequisites ! (abilities and attributes)
    - Upgradable ! (witch means : once your done building your caracter, a simple copy/past of 3 specifics columns allows you to enjoy the futures version of this tool without making all over gain)
    - no macros
    - plenty of advanced but sturdy excel formula for those who like to dig (I really like the custum Vlookup+1 and the [lvl]x[lvl-1]x0,5 for the xp calculation)
    - Crushable formulas ! (ok, it's not a feature, but for some cells we had no choice. Though all important formulas are protected so nothing bad should happen)

    For now it's version 3.9 Charms update !.(Custom charms & DB charms) We'll put any update here and in the discussion.
    Please note that this page might of might not be up to date. Check the lasts posts to check if a new version isn't out !

    We welcome any feedback ! (Constructive or not) or ideas about improving this stuff. As well as filled sheet with your character (just PM me to get my mail) to help us understand how people use the sheet.

    If the devs allows it, please consider that it's under CC license :
    Last edited by Refhi; 04-10-2019, 05:24 PM.

  • Hira Akigi
    replied
    Sadly some (or actually most) of the charms are still incomplete, but I am doing my best to get in what I can over the Christmas holidays.

    Leave a comment:


  • Refhi
    replied
    Hello to all,

    first merry calibration to all,

    Hira Akigi got you a very nice present I couldn't manage to accomplish in due time : an update ! A Lunar one ! (for Lunar charms !)

    MANY thanks to him

    (please note I didn't have time to review his work yet, so I"m putting it here on a temporary link until I merge it with the rest asap)

    => http://refhi.free.fr/exalted3/Fiche%...b%20akagi.xlsx

    have fun !

    Leave a comment:


  • Hira Akigi
    replied
    Originally posted by Refhi View Post

    Very interesting, I'll try to check that today
    The little trick of using the whole column and looking at the own cell for its row via index means, inserting or deleting rows no longer is a problem at all. Before, when I added the lunar charms piecemeal, I had to fix up the lookup table again and again if I had to insert a row... now that table became pretty much "indestructible" but for empty rows.

    though, there's one thing I am concerned about: I got to 89 Dexterity charms for lunars - 100 would break the formatting of the Charm-ID.

    Leave a comment:


  • Refhi
    replied
    Originally posted by Hira Akigi View Post
    More excel Magic that allows inserting lines in the Charms sheet - and automagically updates the CharmPrerequisite table - you can call ROW on a field itself! That allows us to use index on whole columns, allowing to insert or resort whole tables without mucking up the result table at all! It surely isn't the most sleek solution, but it allows to muck around with the Charms sheet much more easily by inserting items or deleting them, reordering them, and not messing up anything.

    Code:
    CharmPrerequisite!A2     =INDEX(Database_Charms_Subtype,ROW(A2))
    CharmPrerequisite!B2     =INDEX(Database_Charms_Names;ROW(A2))
    CharmPrerequisite!C2     =OR(Values!$S$99>=INDEX(Charms!M:M,ROW($A2)),IFERROR(INDEX(Charms!J:J,ROW($A2))=OFFSET(Values!$A$24,MATCH("S",Values!$T$25:$T$50,0),0),FALSE))
    CharmPrerequisite!D2     =VLOOKUP(INDEX(Charms!J:J,ROW($A2)),Values!$A$11:$S$60,19,0)>=INDEX(Charms!L:L,ROW($A2))
    CharmPrerequisite!E2     =OR(ISBLANK(INDEX(Charms!I:I,ROW($A2))),(VLOOKUP(Values!$S$6,Castes!$B$2:$F$25,4,0)=INDEX(Charms!I:I,ROW($A2))))
    
    CharmPrerequisite!L2     =IF(J1889,INDEX(Charms!B:B,ROW($A1889)),"")
    Very interesting, I'll try to check that today

    Leave a comment:


  • Hira Akigi
    replied
    More excel Magic that allows inserting lines in the Charms sheet - and automagically updates the CharmPrerequisite table - you can call ROW on a field itself! That allows us to use index on whole columns, allowing to insert or resort whole tables without mucking up the result table at all! It surely isn't the most sleek solution, but it allows to muck around with the Charms sheet much more easily by inserting items or deleting them, reordering them, and not messing up anything.

    Code:
    CharmPrerequisite!A2     =INDEX(Database_Charms_Subtype,ROW(A2))
    CharmPrerequisite!B2     =INDEX(Database_Charms_Names;ROW(A2))
    CharmPrerequisite!C2     =OR(Values!$S$99>=INDEX(Charms!M:M,ROW($A2)),IFERROR(INDEX(Charms!J:J,ROW($A2))=OFFSET(Values!$A$24,MATCH("S",Values!$T$25:$T$50,0),0),FALSE))
    CharmPrerequisite!D2     =VLOOKUP(INDEX(Charms!J:J,ROW($A2)),Values!$A$11:$S$60,19,0)>=INDEX(Charms!L:L,ROW($A2))
    CharmPrerequisite!E2     =OR(ISBLANK(INDEX(Charms!I:I,ROW($A2))),(VLOOKUP(Values!$S$6,Castes!$B$2:$F$25,4,0)=INDEX(Charms!I:I,ROW($A2))))
    
    CharmPrerequisite!L2     =IF(J1889,INDEX(Charms!B:B,ROW($A2)),"")
    Last edited by Hira Akigi; 12-14-2020, 07:22 AM.

    Leave a comment:


  • Hira Akigi
    replied
    Doing some Excel-magic I managed to automate the Charm-ID generation, Mote-writeup, from the cost columns... and some sub-typing for the lunars...

    Automated CharmID - and misc Charm magic:
    I needed to generate some extra names:
    Code:
    Books:     =CharmsId!$A$44:$A$54
    Books_ID:  =CharmsId!$B$44:$B$54
    Skill:     =CharmsId!$A$2:$A$40
    Skill_ID:  =CharmsId!$B$2:$B$40
    This is field Charms!A1661
    Code:
    =INDEX(Books_ID,MATCH(Charms!C1660,Books,0))&INDEX(Skill_ID,MATCH(J1660,Skill,0))&IF((COUNTIF($A$1:A1659,INDEX(Books_ID,MATCH(Charms!C1660,Books,0))&INDEX(Skill_ID,MATCH(J1660,Skill,0))&"**")+1)<10,"0"&(COUNTIF($A$1:A1659,INDEX(Books_ID,MATCH(Charms!C1660,Books,0))&INDEX(Skill_ID,MATCH(J1660,Skill,0))&"**")+1),(COUNTIF($A$1:A1659,INDEX(Books_ID,MATCH(Charms!C1660,Books,0))&INDEX(Skill_ID,MATCH(J1660,Skill,0))&"**")+1))
    And then, to make entries in the Cost column automated (for most cases super useful) this is the corresponding Charms!E1661
    Code:
    =IF(F1661<>"",F1661&"m",IF(AND(G1661="",OR(LEFT(H1661)="(",LEFT(H1661)="")),"–",""))&IF(G1661<>"",IF(F1661<>"",", ","")&G1661&"wp","")&IF(H1661<>"",IF(LEFT(H1661)="(",IF(OR(F1661<>"",G1661<>"")," ",""),IF(AND(F1661="",G1661=""),"",", ")),"")&IF(H1661="","",H1661)
    And then, Charms!M1661 to pick the number from the Skill and Essence from the columns before it
    Code:
    =J1661&" "&L1661&", Essence "&N1661
    Charm-Subtypes:
    That's part of the CharmAb table... every Subtype entry needs to be in the third column while the second column needs the supertype... but the very first column may not have extra entries... which can be done rather easily - for example, for a lunar, the first rows of columns CharmAb!JKL would look like the following one. Do note, that the trailing letter is mandatory - otherwise, you get one hell of a long lookup table, as lunars have 9 different Hears Blood tables and 2 to 3 of most other charm subtypes.

    .
    List for attribute based characters
    Appearance Appearance Heart's Blood (A)
    Charisma Appearance Influence (A)
    Dexterity Appearance Subterfuge (A)
    Intelligence Appearance Warfare (A)
    Manipulation Charisma Heart's Blood (C)
    Perception Charisma Influence (C)
    Stamina Charisma Warfare (C)
    Strength Charisma Territory (C)
    Universal Dexterity Heart's Blood (D)
    Wits Dexterity Offense (D)
    .

    Then, the columns ABC need to get updated and voila! Sub-types work!

    Universal Charms-Fix:
    Universal Lunar Charms need to have one row added in Values, best after Spell (Row 51):
    Code:
    Values!A52: Universal
    Values!S52: 1
    Open things?
    I haven't figured out how or if one can manage charms with several prerequisites properly...
    Last edited by Hira Akigi; 12-13-2020, 09:55 AM. Reason: Refined something

    Leave a comment:


  • Hira Akigi
    replied
    It's been a few months... Would it be possible to help, possibly by cataloging the Lunar charms or helping in automating some stuff?
    Last edited by Hira Akigi; 12-12-2020, 06:58 PM.

    Leave a comment:


  • Refhi
    replied
    Hey, the tool is currently on hiatus (meaning I won't update it for the next few months), but is by no means abandoned.
    I'll go back to it when I find time & motivation

    here's a few things to come (this post is also a memo for my future self) :
    - external charm databases (most likely in a csv file or something, so we have a lighter main file)
    - bug fixes (thanks Infinity_Master and Jancarius and all other whom I'm forgetting)
    - github repository ?

    please post any idea or bug report meanwhile so I can look into it

    stay tuned !

    Leave a comment:


  • Infinity_Master
    replied
    Hey, reporting a bug of some kind and in need of help here. I'm creating a character that has martial arts, but the list of martial arts doesn't display them (displaying list_martial_arts instead) and the red dot in front of the martial arts skill doesn't disappear even if I have the relevant Martial Artist merit (That shows in the merit list as Martial_Artist). I would link my sheet, but I can't attach it to this reply for some reason.

    Edit: Also, manse is buyable as a 4 point merit, which shouldn't be possible.

    Edit 2: Don't know if it's new or not, but when you select terrestrial sorcery extra slots for your shapping rituals and your control spell don't appear.

    Edit 3: Print Option on Libre Office breaks up pages when resizing for the charm descriptions to fit, chopping pages prematurely. Although this might be intended as a scripted page break on X line, it does not account for resizing of the charm descriptions, nor the background area. (Solution for Libre Office users: View -> Page Break Preview. The printable area and the page divisions will show in a blue outline in the Creation_xp tab. Click and drag to move them around as needed).

    Edit 4: The tool tip in Join Battle calls it Perception + Awareness when it should be Wits + Awareness. But it's calculated properly.

    Edit 5: The charm Terrestrial Circle Sorcery should grant the Thaumaturgist Merit for free.
    Last edited by Infinity_Master; 10-15-2020, 08:32 PM.

    Leave a comment:


  • Refhi
    replied
    Originally posted by Kawou View Post
    Hiya! Onyx Path a FINALEMENT confirmé mon compte XD

    First of all, great work and infinite thanks!

    I've taken upon myself to add the lunar charms. I'm not finished yet, but wanted to let you know!
    Ohhhhhh, un collègue francophone

    Super que vous ayez pu vous y mettre, je n'ai toujours pas trouvé le temps !

    Si vous pouvez me transmettre le tableau mis à jour je me ferais un plaisir de l'intégrer à la fiche en ligne ! En vous créditant du travail accompli bien sûr.

    Si vous êtes motivés l'id du charme se crée ainsi (cf onglet CharmId dans la feuille)
    - les deux premiers chiffres sont le numéro du livre (donc pour les lunaires 05)
    - les 3e et 4e le numéro de la compétence/attribu
    - les 5e et 6e le numéro du charme dans la compétence/attribu donnée

    N'hésitez pas à revenir vers moi si vous souhaitez qu'on en discute (je peux vous envoyer mon mail par PM si vous voulez)

    A bientôt j'espère !

    Leave a comment:


  • Kawou
    replied
    Hiya! Onyx Path a FINALEMENT confirmé mon compte XD

    First of all, great work and infinite thanks!

    I've taken upon myself to add the lunar charms. I'm not finished yet, but wanted to let you know!

    Leave a comment:


  • Refhi
    replied
    Originally posted by iratecmdr View Post
    This is the government,

    You have done a great service to our country.
    LOL thanks!

    Leave a comment:


  • Refhi
    replied
    Originally posted by Jancarius View Post
    I used this character sheet to generate my character for an upcoming game and it's mostly great so far. However, I have some questions on how to get it to do a few things.
    How do I add spells and martial arts gained during CC? I have Terrestial Circle Thaumaturgy and the Martial Arts merit , but the only place I could add them was on the XP spend sheet, where it's counting them as XP spent (which will throw off essence calculations).
    Related, the red arrow on Martial arts saying that I haven't taken the merit won't go away and I'm not sure why.
    I'm not sure how to add hidden lines or additional copies for charms/intimacies etc, but this is a more general future question than something I need to solve immediately

    Also what is the value DC in weapons? And is there a way to put Glorious Solar Blade in so it doesn't commit motes but still appears on the sheet so I know the stats
    Ouch one year away...
    I'll look into it

    Leave a comment:


  • iratecmdr
    replied
    This is the government,

    You have done a great service to our country.

    Leave a comment:

Working...
X