Advanced Character Generator

[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.

[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]

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]

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]

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)),"")

[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]

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

[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 !

[Infinity_Master]

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.

[Refhi]

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 !

[Kawou]

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!

[Refhi]

This is the government,

You have done a great service to our country.

LOL thanks!

[Refhi]

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

[iratecmdr]

This is the government,

You have done a great service to our country.

[Jancarius]

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