Back to Crafty Games Welcome, Guest. Please login or register.
Did you miss your activation email?
July 29, 2014, 01:54:48 PM
Home Help Search Login Register
News: Welcome to the Crafty Games Forums!

Note to New Members: To combat spam, we have instituted new rules: you must post 5 replies to existing threads before you can create new threads.

  Show Posts
Pages: 1 [2] 3 4 5
16  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.
17  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.
18  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.
19  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...
20  Products / Fantasy Craft / Re: Excel Based Character Sheet on: November 07, 2012, 03:27:15 PM
A quick update on this: The problem was due to Antilles using Norwegian regional settings and typing 5.5 into an equipment weight field. The problem is that with Norwegian and several other settings, the decimal point character is , <comma> not . <full stop/period> and . <full stop/period> is used as a date separator.

Thus 5.5 is interpreted by Windows/Excel as 5th May of the current year. Using 5,5 causes no problems and is interpreted as 'five point five'. I tried to 'fix' this with a cell format change but realised afterwards that this was for display purposes only and had no effect on entry of values. So, to cut a long story short, I don't propose to issue a new version yet. People using UK/US/several other regional settings will never even see this.
21  Products / Fantasy Craft / Re: Excel Based Character Sheet on: November 06, 2012, 07:04:13 PM
I've discovered something of an annoyance... in the Equipment section, if you enter say, 5.5, it defaults to date (may 5th) rather than numbers, and since the sheet is locked I cannot change the formatting. This kinda buggers up the rather nifty weight section sadly...

That's odd, doesn't happen for me... Can I ask what regional settings you use and which version of Excel and Windows? I have used the sheet for more than a dozen characters, and they all have fractional equipment weights and this has never happened. It may be that a cell format change will do the job. If you PM me your email address I can try a fix and send it to you to test.
22  Products / Fantasy Craft / Re: Excel Based Character Sheet on: October 31, 2012, 07:35:08 AM
The new version (1.01) is now live on the downloads page. Thanks Pat!
23  Products / Fantasy Craft / Re: Excel Based Character Sheet on: October 27, 2012, 01:44:33 PM
Didn't know anyone was actually using this. I found a couple of errors recently, including one which replaces the level/class based Initiative bonus with the Defence bonus... I'll fire off a new version to Pat/Alex now.
24  Products / Fantasy Craft / Re: DR Calculation Check on: September 29, 2012, 09:59:07 AM
Interesting, thanks. I'd missed the whole halving thing.  Embarrassed
25  Products / Fantasy Craft / Re: DR Calculation Check on: September 29, 2012, 09:19:43 AM
Trip him. A lot of armor benfits go away when you're sprawled...

Can you give an example please? I'm struggling to find any benefit that is lost.
26  Products / Fantasy Craft / DR Calculation Check on: September 13, 2012, 07:55:24 AM
Hi, I just wanted to check the DR of a character in my current game.

14th Level Soldier with:
Moderate Platemail 5
Heavy Fittings +2
Fortunes of War II +2
Armour Basics/Mastery/Supremacy +2

Total DR 11

Is this correct? Does Fortunes of War stack with the armour (I believe it does)? This seems like a very high value, especially considering that killing machine the Tarasque is only listed as having DR 10.  Undecided
27  Products / Fantasy Craft / Re: Make a bard... on: August 04, 2012, 04:36:41 AM
When I converted a bard to FC recently, he ended up as a Sage 8/Mage 5. OK, that's high level, but Sage is a great choice for a bard, I think.
28  Products / Fantasy Craft / Re: Walk me through Grapple:Screaming Club on: August 03, 2012, 11:10:15 AM
If Wrestling/grappling became powered by Unarmed attack, I could easily see an equivalent of the Eagle Eye trick allowing you to substitute your Athletics (Str) bonus for your Unarmed Attack bonus x number of times per combat.

I like that. You get a basic ability with grappling equivalent to your other attacks, but if you make a commitment to learning a technique (wrestling, Judo or whatever) then you get better. Without giving it a great deal of thought, it makes a whole heap of sense to me.  Cool
29  Products / Fantasy Craft / Re: Walk me through Grapple:Screaming Club on: August 02, 2012, 09:18:00 AM
An interesting question from a re-read of the grappling rules:

As Grapple is listed as an 'Unarmed/1-Handed Melee Attack Action', I guess that means that Unarmed (or 1-Handed? Is this right?) proficiency is applied to the Athletics roll? So not being trained in Unarmed gives a -4 penalty and having a forte gives a +1? I hope this is the case, as it would mitigate some of my concerns over using Athletics for grappling...
30  Products / Fantasy Craft / Re: Walk me through Grapple:Screaming Club on: August 02, 2012, 08:01:50 AM
FWIW, the training for your body to swim and climb and such is good for wrestling.  When I wrestled in high school a big chunk of each practice was running up and down the stairs.  (The building has 10 stories, it was a whole bunch of stairs.)

Of course, that makes perfect sense. But in game terms wouldn't that be increasing Strength (ie. one aspect of general fitness) which is useful in all three disciplines? Rather than learning skills & techniques for a specific purpose. For instance, learning backstroke isn't going to help you wrestle somebody to the floor. Knowing Judo doesn't help with abseiling. Other than the generally increased fitness level that accompanies continued pursuit of these activities.

I do understand the advantages of having a compact list of skills, and therefore a general 'Athletics' skill, but why is grappling (I believe) the only physical (non-magical) attack technique that doesn't work off of attack bonus? Seems inconsistent. Also, to quote an earlier example, it's good to have a courtier who can learn wrestling, yes, but why can't he learn boxing in the same way?
Pages: 1 [2] 3 4 5


Powered by MySQL Powered by PHP Powered by SMF 1.1.13 | SMF © 2006-2011, Simple Machines LLC Valid XHTML 1.0! Valid CSS!