Crafting Costs!
-
Alright "Spell Value" and "Cost of Wand" Can I get those words translated?
Is one of those XP loss and the other GP loss?
Sorry if I'm just being unobservant. :)
Cost of wand equals the amount of gold that will be sucked from your inventory.
Spell value is harmless. I could actually hide that inside the formula itself to make it invisible and cause less confusion, but this way makes updates easier.
-
XP cost is rarely in the triple digits for anything, and number of crafting sessions doesn't affect character mechanics. Just time.
This was made from DM posted information so people wouldn't have to trial and error their way through 20k in gold guesstimating gold costs.
If you can get me the /exact/ XP and crafting session formulas, I'll add them in and repost new uploads.
Time is important for at least some players, too, 5 sessions means you're probably not getting that wand finished the same gaming session, so you have to hope you find your customer online again next time. Anyway, I have no idea what is actually programmed, but the formulae I described seem to be right for the wands I've made, if my notes didn't get messed up too much. Translating them into excel I'll 'leave as an exercise to the reader', not because I can't be arsed, but because I haven't got it installed on this PC.
-
The wand values change as you get higher in level, for example a level 12 barksin wand costs alot more then a level 3 one
-
The wand values change as you get higher in level, for example a level 12 barksin wand costs alot more then a level 3 one
That's accounted for. That's why some spells have multiple spell values assigned.
-
These are what I think are the excel formulae for wand-costs (put in columns D, E and F, on row 4, then use the black little square to extend them to the whole column) FLOOR(x,y) is used to round x down to the nearest multiple of y (as that is what seems to happen for the fractional amounts IG, and MAX(x,y,…) returns the largest of its arguments.
WAND GP COST:
=FLOOR(($A$2*$C4*11)/1000,1)WAND XP COST:
=FLOOR($C4/50,1)WAND CRAFTING ATTEMPTS NEEDED:
=MAX(FLOOR($D4/1000,1),1)