Advanced Character Generator

[Refhi]

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 !

[Hira Akigi]

It's been a few months... Would it be possible to help, possibly by cataloging the Lunar charms or helping in automating some stuff?

[Hira Akigi]

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:

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

=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

=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

=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):

[B]Values!A52: Universal[/B]
[B]Values!S52: 1[/B]

Open things?
I haven't figured out how or if one can manage charms with several prerequisites properly...

[Hira Akigi]

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.

[B]CharmPrerequisite![/B]A2     =INDEX(Database_Charms_Subtype,ROW(A2))
[B]CharmPrerequisite![/B]B2     =INDEX(Database_Charms_Names;ROW(A2))
[B]CharmPrerequisite![/B]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))
[B]CharmPrerequisite![/B]D2     =VLOOKUP(INDEX(Charms!J:J,ROW($A2)),Values!$A$11:$S$60,19,0)>=INDEX(Charms!L:L,ROW($A2))
[B]CharmPrerequisite![/B]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))))

[B]CharmPrerequisite![/B]L2     =IF(J1889,INDEX(Charms!B:B,ROW($A2)),"")

[Refhi]

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.

[B]CharmPrerequisite![/B]A2     =INDEX(Database_Charms_Subtype,ROW(A2))
[B]CharmPrerequisite![/B]B2     =INDEX(Database_Charms_Names;ROW(A2))
[B]CharmPrerequisite![/B]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))
[B]CharmPrerequisite![/B]D2     =VLOOKUP(INDEX(Charms!J:J,ROW($A2)),Values!$A$11:$S$60,19,0)>=INDEX(Charms!L:L,ROW($A2))
[B]CharmPrerequisite![/B]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))))

[B]CharmPrerequisite![/B]L2     =IF(J1889,INDEX(Charms!B:B,ROW($A1889)),"")

Very interesting, I'll try to check that today

[Hira Akigi]

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.

[Refhi]

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 !

[Hira Akigi]

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.