Was actually working on a spell input thing a while ago. Have dug it up and will post it shortly.
The main pain with adding new spells is redoing the description so it works with the sheet. This involves
a) if the spell says "like this other spell but here are the differences", I've been copying in the description of the original spell and making necessary changes (there are older spells that could use this)
b) if the spell has any dice effects, I replace them with a <dice> tag and add the dice to a new column. This is so we can calculate things like Maximized spell
c) if the spell has effects that depend on caster level, I replace them with a tag, and put a formula look-up code in corresponding column. This is so when you are a 5th level caster, Acid Arrow description will say that it lasts for 2 rounds. The <dice> columns can also have tags. Eg. FIreball does <dice> damage, when dice is d6 and is "<i>x1[,10]" (where the<i> means that Intensified spell works on it, and the "x1[,10]" is a code that means 1 times caster level to a max of 10)
d) Finally, I need to edit the description down so that it fits into our boxes. This can be the most annoying thing as for some spells its often hard to keep all the relevant info there.</dice></dice></dice>
For examples of part c), you can unhide the "Spell Data" tab, and take a look at existing spells. The relevant columns are BE:BN.
Unhide "CL Formula" if you want to look at the formula names - I try to be consistent when naming the numeric ones so that I can reuse them.
But really, I wouldn't bother with the formula stuff. If you just replace stuff that is "bla bla per caster level" with a tag, I can do the formula bit
===
Last edit: Daniel 2017-02-23
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Current Tasks (Updated 5th November 2017)
Obedience Data - Copy Obedience and Boon data from Inner Sea Gods/Inner Sea Faiths into tablesSpell Descriptions - Rewrite spell descriptions
Conditional Modifiers for Wondrous Items - Go through descriptions for wondrous items, record conditional modifiers
Last edit: Daniel 2017-11-05
View and moderate all "Data Entry" comments posted by this user
Mark all as spam, and block user from posting to "Discussion"
So.... how do we help out?
I am... er ... was .... Anonymous!
Would you be willing to supply or describe what you need as far as data elements for new spells?
Was actually working on a spell input thing a while ago. Have dug it up and will post it shortly.
The main pain with adding new spells is redoing the description so it works with the sheet. This involves
a) if the spell says "like this other spell but here are the differences", I've been copying in the description of the original spell and making necessary changes (there are older spells that could use this)
b) if the spell has any dice effects, I replace them with a <dice> tag and add the dice to a new column. This is so we can calculate things like Maximized spell
c) if the spell has effects that depend on caster level, I replace them with a tag, and put a formula look-up code in corresponding column. This is so when you are a 5th level caster, Acid Arrow description will say that it lasts for 2 rounds. The <dice> columns can also have tags. Eg. FIreball does <dice> damage, when dice is d6 and is "
<i>x1[,10]" (where the<i>means that Intensified spell works on it, and the "x1[,10]" is a code that means 1 times caster level to a max of 10)d) Finally, I need to edit the description down so that it fits into our boxes. This can be the most annoying thing as for some spells its often hard to keep all the relevant info there.</dice></dice></dice>
For examples of part c), you can unhide the "Spell Data" tab, and take a look at existing spells. The relevant columns are BE:BN.
Unhide "CL Formula" if you want to look at the formula names - I try to be consistent when naming the numeric ones so that I can reuse them.
But really, I wouldn't bother with the formula stuff. If you just replace stuff that is "bla bla per caster level" with a tag, I can do the formula bit
===
Last edit: Daniel 2017-02-23
Also got a couple of other tasks, I need to make the time to create input sheets.
I would like to help as well.