Show Posts
|
|
Pages: [1] 2 3 ... 5
|
|
1
|
Products / Fantasy Craft / Re: Excel Based Character Sheet
|
on: June 08, 2013, 08:50:58 AM
|
|
Hi Josh, glad you're finding the sheet useful. I have a few sheets I've developed for various systems including MGT and Pathfinder. I'll see about finding somewhere to put them and I'll post a link. Be aware though - None of them are as well developed as the FC sheet. Very rough & ready and not intended for public consumption!
|
|
|
|
|
2
|
Products / Fantasy Craft / Re: Excel Based Character Sheet
|
on: April 11, 2013, 03:24:51 PM
|
I haven't tried this (I don't have excel and things could go screwey), but maybe print to PDF and upload that? If you don't need to update it mid session you can just replace the PDF with an updated one each time you meet?
That's the way to do it. Whenever I update a character for a live campaign, I print as PDF and download to my phone so I have a copy 'just in case'.
|
|
|
|
|
3
|
Products / Fantasy Craft / Re: NPC Caster Level
|
on: March 09, 2013, 02:11:08 PM
|
|
It's in the errata document:
Signature Skills (page 228): As noted in the natural spell quality (see page 234), the Casting Level of an NPC with the Spellcasting Signature Skill is equal to the NPC’s Threat Level.
|
|
|
|
|
4
|
Products / Fantasy Craft / Re: Excel Based Character Sheet
|
on: March 06, 2013, 01:24:25 PM
|
|
If you mean Type as in Folk, Outsider etc. then my suggestion is to use the 'Substitute Species Names' table on Sheet 1 Origin. For instance, if you have a human of the Outsider type, change the 'Human' entry to 'Human [Outsider]'.
As far as the natural attack is concerned, for now just enter it as a 1 or 2 handed weapon. It has no mechanical effect. I will add this to the change list for the next release though.
|
|
|
|
|
6
|
Products / Fantasy Craft / Re: Acid damage
|
on: February 17, 2013, 03:16:56 PM
|
|
I think Doomed is giving an example of what would happen if a target was hit for 20 fresh acid damage over several rounds - And the maths seems correct according to the RAW.
Round 1: 20 damage Round 2: Another 20 damage from a fresh hit + half of Round 1's damage = 30 damage Round 3: Another 20 damage from a new hit + 10 + 5 = 35 damage
That's a lot of damage over 3 rounds, but whether it's too much I'm not sure...
|
|
|
|
|
9
|
Products / Fantasy Craft / Re: Excel Based Character Sheet
|
on: February 03, 2013, 05:21:48 AM
|
|
Antilles has kindly given me a reminder that the new classes need to be added to the character sheet. I'll get onto it as soon as possible and try to get a new version to Pat by the end of the week at the latest.
|
|
|
|
|
12
|
Products / Fantasy Craft / Re: Excel Based Character Sheet
|
on: November 17, 2012, 07:20:53 PM
|
There is an optional TRUE/FALSE argument that can be used for vlookup. If the argument is omitted or set to TRUE, excel assumes the list is sorted and, if it can't find the lookup value, it looks up the next highest value on the search list.
If that argument is set to false, it will only return a value based on an exact match and throw an error if there is no such match. In this case, the look up values do not need to be sorted.
If "Spellcasting" was appended to the end of an otherwise sorted skill list, vlookup was probably pulling information from Survival since Spellcraft should have been after Sneak but before Survival in the list.
You're absolutely right, I left the 'FALSE' off of the Vlookup in this function. Why, I don't know as it has been used extensively in other parts of the workbook to make customised lists work! It was actually picking up the Sneak value as the range lookup (TRUE) uses the next smallest value.
|
|
|
|
|
13
|
Products / Fantasy Craft / Re: Excel Based Character Sheet
|
on: November 17, 2012, 05:18:35 PM
|
|
OK, problem found and fixed. I think it was due to Excel's Vlookup function expecting lookup table keys to be in alphabetical order, and Spellcasting is the oddity as it's on the end of the list. I've coded in a specific check for Spellcasting, and it seems to work now.
I've sent a replacement copy to Pat and Alex to go onto the downloads page. VisualStatic, if you'd like a copy immediately, PM me your email address and I'll send it to you.
|
|
|
|
|
14
|
Products / Fantasy Craft / Re: Excel Based Character Sheet
|
on: November 17, 2012, 02:39:12 PM
|
I think I found a bug on linked skills. I'm trying to create a mage with the sorcerer specialty which pairs Intimidate and spellcasting. When I select spellcasting from the drop down in the linked from column it does bring in my skill ranks. But it I use another skill it works fine.
Good spot. I've managed to replicate the problem and I'll investigate and fix it as soon as possible. I have an idea what the problem may be.
|
|
|
|
|
15
|
Products / Fantasy Craft / Re: Prerequisites: How do they have to be met?
|
on: November 09, 2012, 02:34:18 PM
|
|
The way the Career Level rules on p.27 are written suggests that the table 1.4 benefits (feats, interests etc.) are gained first and then you advance a class level. So yes, you could gain a prerequisite feat and then an expert class level at the same career level. That's how I read it...
|
|
|
|
|
|