<html>
<head>
<title>Player Resource Consortium :: Manual :: PrC building :: New Spellbooks</title>
</head>
<body>
<br>How to use the new spellbook generator excel spreadsheet
<br>
<br>First, make sure you have the latest spells.2da file imported into the excel spreadsheet. To do this:
<ol><li>File</li>
<li>Open</li>
<li>[select spells.2da]</li>
<li>Open</li>
<li>Delimited</li>
<li>Next</li>
<li>Space</li>
<li>Finish</li>
<li>[select cell a4]</li>
<li>{End}</li>
<li>{Shift+RightArrow}</li>
<li>{End}</li>
<li>{Shift+DownArrow}</li>
<li>{Ctrl+C}</li>
<li>[select cell a4 in the "input spells" worksheet in the newspellbooks spreadsheet]</li>
<li>{Ctrl+V}</li></ol>
<br>
<br>Make sure the Location reference (Location!B3) points to a valid location on your hard disk,
preferably NOT where the PRC 2da files are. Make sure you keep the trailing slash.
<br>
<br>Fill out the spells.2da, feat.2da, iprp_feats.2da, and tlk starting row locations.
<br>
<br>Switch to the "spellbooks" worksheet. Here every class is listed with ALL its spells
even those not created yet. Create a new section on the far right hand side following
the layout of the others.
<br>
<br>Copy the 3 columns you just created, except for the header row, and copy'n'paste
them into "Location" worksheet just below the Label, Spelllist and Level columns.
<br>
<br>Delete any spells that arent created yet and move spells below those up to create a single
continuous block.
<br>
<br>For the first spell in your list, fill out the "spellscript prefix" and "lable prefix" columns.
Then duplicate them down the list by selecting each in turn and double-clicking in the
small box that appears to the bottom right of the cell. Fill in cls_feat_start in the same
manner.
<br>
<br>At this point, the 2da files are ready to be exported. Select each of the following worksheets
in turn, iprp_feats feat spells cls_spell cls_feat_template, and for each of them press Ctrl+Shift+M
then select "Write 2da file".
<br>This will output the 2da files into the location you specified earlier. Rename the cls_spell.2da
file to have the same ending as that classes cls_feat_*.2da file, for example cls_spell_barb.2da for
the barbarian. For iprp_feats.2da, feat.2da, and cls_feat_template.2da, you have to splice the rows
into the PRC versions of those files, removing any spare end rows as apropriate.
<br>
<br>For the spells per day, you have to make a cls_spbk_*.2da file manually. I suggest copying
one of the existing ones and then editing that. Remember that 0 spells for a level can have
bonus spells added to it, but a null value (****) cannot.
<br>
<br>Each spellbook needs to have its own set of scripts. I suggest you make a copy of the
prc_ocu_*.nss files and edit/rename them for your class. You need to replace the class constant
inside the file and rename the file to match the "spellscript prefix" you specified in the
spreadsheet
<br>
<br>There are several functions that need to be expanded to include any new spellbook.
<br>inc_newspellbook needs the constants updating at the top, SPELLBOOK_ROW_COUNT,
SPELLBOOK_IPRP_FEATS_START, and SPELLBOOK_IPRP_FEATS_END, as well as updating GetAbilityForClass()
to include the new class.
<br>inc_lookups needs MakeLookupLoopMaster() updating following the example of the other spellbooks.
<br>prc_inc_spells needs GetIsArcaneClass() and/or GetIsDivineClass() updating to include the new
spellbook.
<br>
<br>To do: Tlk entries
</body>
</html>
6ec137a24e