Announcement

Collapse
No announcement yet.

Advanced Character Generator

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

  • #91
    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 !


    French Exalt & ST & ToolMaker [Website]
    Advanced Character Generator Thread, Excel Version & LibreOffice Version
    Familiar Generator Thread & Libreoffice Version

    Comment


    • #92
      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.

      Comment


      • #93
        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

        Comment


        • #94
          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.

          Comment


          • #95
            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(&quot;S&quot;,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)),&quot;&quot;)
            Very interesting, I'll try to check that today


            French Exalt & ST & ToolMaker [Website]
            Advanced Character Generator Thread, Excel Version & LibreOffice Version
            Familiar Generator Thread & Libreoffice Version

            Comment


            • #96
              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.

              Comment


              • #97
                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 !


                French Exalt & ST & ToolMaker [Website]
                Advanced Character Generator Thread, Excel Version & LibreOffice Version
                Familiar Generator Thread & Libreoffice Version

                Comment


                • #98
                  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.

                  Comment

                  Working...
                  X