Crafty Games Forum

Products => Fantasy Craft => Topic started by: cjs65 on March 02, 2012, 12:20:44 PM

Title: Excel Based Character Sheet
Post by: cjs65 on March 02, 2012, 12:20:44 PM
I'm currently working on an Excel based character sheet for Fantasy Craft, and as I've not seen anything other than the form-fillable PDF I wondered if anyone else would be interested once it's done?

I've done this many times before for other games (D&D 3.5, D&D 4, Pathfinder, Mongoose Traveller and others) because I hate having to track through a sheet updating it when an attribute score or other vital number changes; I'd rather just let Excel do the work for me. Plus, I just love playing with Excel! I would be interested in any feedback/critique, as I've never shared any of my previous efforts and don't know if there's a 'better' way of doing things. Also, I'm not experienced with FC and may have missed something vital!

The current state is 'mostly done' and it should be ready next week. The difficult stuff has been cracked and I'm just finishing off the boring stuff, really. It's NOT a character generator by any stretch of the imagination but it does cross-reference and auto-update numbers when base values change. I'm already looking ahead to develop it further, having more selectable/auto-filled values, but to do this I would need to use text from the rulebook and don't want to infringe on any copyrights. I must have a good read of the OGL...  As it is I've swiped a copy of the Fantasy Craft logo as appears on the PDF character sheet and I'm using that currently. If I make this public, would I need to strip that out?

Of course, I now fully expect someone to say <A. Person> has already made one and you can find it <here>!  ;)
Title: Re: Excel Based Character Sheet
Post by: VisualStatic on March 02, 2012, 12:33:01 PM
Not to be that guy, but..... link (http://www.crafty-games.com/forum/index.php?topic=3441.0)   :P
Title: Re: Excel Based Character Sheet
Post by: cjs65 on March 02, 2012, 12:40:37 PM
I saw that one, but according to the last few posts it was never finished. Mine's nothing like that ambitious, by the way!
Title: Re: Excel Based Character Sheet
Post by: Dreamstreamer on March 02, 2012, 12:51:29 PM
As it is I've swiped a copy of the Fantasy Craft logo as appears on the PDF character sheet and I'm using that currently. If I make this public, would I need to strip that out?

Fire it off to Pat (pat@crafty-games.com) or Alex (alex@crafty-games.com). They can tell you exactly what's needed for permission. FYI, it will likely involve inserting a small amount of copyright text.
Title: Re: Excel Based Character Sheet
Post by: Crafty_Pat on March 02, 2012, 05:35:41 PM
As it is I've swiped a copy of the Fantasy Craft logo as appears on the PDF character sheet and I'm using that currently. If I make this public, would I need to strip that out?

Fire it off to Pat (pat@crafty-games.com) or Alex (alex@crafty-games.com). They can tell you exactly what's needed for permission. FYI, it will likely involve inserting a small amount of copyright text.

Pretty much, and from the sound of it the spreadsheet's something we could host on our Downloads page, if you like.

Let us know, and good luck with the remaining revisions!
Title: Re: Excel Based Character Sheet
Post by: Segreant on March 03, 2012, 11:30:43 AM
I've done this sort of thing before (including macro scripting), for 3.5 and Legend of the 5 rings, among others, though only for personal use. I look forward to seeing what you've done and helping out where possible. So far all I've done for FC is simple worksheets for attributes and skills. I'm an FC novice and have been learning the system while working on a character for the new FTF 'FC in Golarion' campaign that Krensky will be starting in a few weeks.
Title: Re: Excel Based Character Sheet
Post by: cjs65 on March 10, 2012, 03:01:59 PM
I'm still working on this, but had a bit of a setback when my perfectionist half suddenly hated what I'd done. So I've scrapped that and put in many hours on getting it redesigned. It was not helped by the fact that the rules are quite deep, with a few subtle twists I'd missed first time round. Doing this sort of thing is an excellent way of learning the rules! Anyway, I'm now about back to where I was with the first try and now hope to have it done by next week and sent off to Pat for feedback.

One rules question has arisen that I couldn't find an answer to and would appreciate help with:
Exotic weapons require a forte for proficiency, so does that mean the forte bonus is lost when using one of these weapons? In other words, is the progression A) Untrained -4, Proficient -4, Forte (actually Proficient) +0, or is it B) Untrained -4, Proficient -4, Forte +1 ? Or even something else?
Title: Re: Excel Based Character Sheet
Post by: Gentry on March 10, 2012, 04:16:56 PM
I'd believe the latter, simply by virtue of it being simpler.
Title: Re: Excel Based Character Sheet
Post by: Khaalis on March 11, 2012, 07:48:29 AM
The way I read the rules is as follows:

1) You spend Proficiencies to acquire skill with an ENTIRE Group of Weapons from either: Blunt, Edged, Hurled, Bows, Black Powder or Siege Weapons. You can spend points to attain 2 levels of skill: Trained and Forte.

2) For any Weapon Group you spend 0 Proficiency Points in, means you are considered Untrained, thus take a -4 non-proficiency penalty to Attacks.

3) For any Weapon Group you spend 1 Proficiency Point in, means you are considered Trained, thus cancelling the non-proficiency penalty to Attacks with the chosen weapon group only.

4) For any Weapon Group you spend 2 Proficiency Points in, means you are considered to have Forte (aka Mastery or Well Trained), thus gaining a +1 bonus to Attacks with the chosen weapon group.

5) Certain exotic weapons in a Weapon Group require you to have Forte in the Weapon Group before you may use them. This does not change the fact that you gain your +1 to Attack with these weapons. It simply means that until you have become "well trained" (aka gained Forte), some weapons are still just too complicated to use effectively.


For instance, this is how I look at it. Simply being Trained (Proficient) in basic blunt weapons is not enough skill to allow you to correctly utilize exotic blunt weapons. Once you have achieved mastery (Forte) with basic blunt weapons, you have enough skill o broaden the types of weapons you understand the use of (gain access to exotic weapons).


Title: Re: Excel Based Character Sheet
Post by: cjs65 on March 21, 2012, 03:06:56 PM
The character sheet is now done and ready for people to try to break it. I've fired off a message to Crafty Games asking if somebody will check it over, and maybe host the file, and I'm waiting to hear something back before going any further.

If all is OK, is there anybody who would be interested in doing some 'beta' testing?

Just so you're aware, I'm an IT professional who uses Excel daily in my job, including developing relatively complex spreadsheets, so I hope I've made a fair job of it. This character sheet does quite a lot for you, but not everything, and I'm very open to suggestions for improvement; bear in mind though, it is 'just' a character sheet NOT a character generator.
Title: Re: Excel Based Character Sheet
Post by: Moebius on March 21, 2012, 07:59:06 PM
I suppose it's not very good in LibreOffice? They usually aren't. Why can't they be compatible?!?!  >:(
Title: Re: Excel Based Character Sheet
Post by: cjs65 on March 22, 2012, 12:28:32 AM
I have no idea, I'm afraid.  :(  It's only been tested with Excel 2007 and 2010.

To be honest, this is just something I made for myself, as I do for every system I'm getting into seriously, so I'm not going out of my way to make it compatible with software I don't have or don't use unless there's a big demand. This time I thought I'd try to share my work with others who might find it useful. Of course, it could be that nobody else likes to use Excel, which is fine...  8)
Title: Re: Excel Based Character Sheet
Post by: Moebius on March 22, 2012, 02:50:27 AM
no worries. I think it's great what you're doing and daring that you share it. I apologize you ended up in my... venting... cone.
Title: Re: Excel Based Character Sheet
Post by: tfwfh on March 22, 2012, 08:03:31 AM
I have no idea, I'm afraid.  :(  It's only been tested with Excel 2007 and 2010.

To be honest, this is just something I made for myself, as I do for every system I'm getting into seriously, so I'm not going out of my way to make it compatible with software I don't have or don't use unless there's a big demand. This time I thought I'd try to share my work with others who might find it useful. Of course, it could be that nobody else likes to use Excel, which is fine...  8)

I think it's not so much people not liking excel as it is them (us) being unwilling to buy it and unwilling to steal it.  Spreadsheets were the "killer app" for the Apple II over 30 years ago, and by now they should be included with the operating system the way that image viewers, media players, and web browsers are.

More to the point, I can't test your sheet either, and for the same reason.
Title: Re: Excel Based Character Sheet
Post by: Dreamstreamer on March 22, 2012, 08:43:05 AM
Well, have you guys tried the Excel Viewer from Microsoft?

Link: http://www.microsoft.com/download/en/details.aspx?id=10

I don't believe that you will be able to save anything, but you could probably still test out the sheet.

Edit: I forgot about SkyDrive. I believe that you can view Excel files if you have a Live Account from Microsoft. Just drop it in your SkyDrive. It should automatically save the file, too.
Title: Re: Excel Based Character Sheet
Post by: Sletchman on March 22, 2012, 09:32:38 AM
Google Docs does a pretty good Excel in my experience - could be worth a try.  Also I haven't had problems using Open Office on Excel documents, but I've not tried anything really complex so... who knows?  What does LibreOffice do better then Open Office?  Just curious - Open Office came with my Linux distro, so I just use it out of laziness.
Title: Re: Excel Based Character Sheet
Post by: Moebius on March 22, 2012, 09:44:25 AM
From what I understand Open Office is finished. No longer updated. LibreOffice was exactly Open Office, however, will continue to get updated. Much of the same people, just changing names because Open Office became corporate or something like that.

*edit...
http://en.wikipedia.org/wiki/LibreOffice#Initial_release
Title: Re: Excel Based Character Sheet
Post by: tfwfh on March 22, 2012, 09:48:54 AM
What does LibreOffice do better then Open Office?  Just curious - Open Office came with my Linux distro, so I just use it out of laziness.

At this stage, the answer is most things.  LibreOffice is a fork of OpenOffice(.org) started by the community because they finally got fed up with Sun and later Oracle stifling the development and providing only minimal support and direction for it.  LibreOffice now has a substantially larger and more active developer community that OOo, and they just recently completed a major code cleanup, so it is now leaner, faster, more responsive, etc.
Title: Re: Excel Based Character Sheet
Post by: Sletchman on March 22, 2012, 09:59:30 AM
See - this is what I get for not updating anything that works for me.  Sooo outta the loop.  Cheers guys.
Title: Re: Excel Based Character Sheet
Post by: royalfa on March 22, 2012, 04:37:29 PM
Hi cjs65

I have already a functional Excel sheet for characters. In the past 3 weeks I "make some format" to print.


The page is a "raw" one. Because I create it for me and each "sheet" has specifical info for each one of my PCs

I will gladly beta test yours :)

Cya
Title: Re: Excel Based Character Sheet
Post by: Moebius on March 22, 2012, 05:16:49 PM
I've been playing around with this one by Erik A. Dewey (http://www.erikdewey.com/gaming.htm) which does translate quite a bit into LibreOffice. I haven't thoroughly looked to see how accurate it does. I know one major hang up was a feature with a drop down list for Classes, but I found a work around by simply entering the number that designates that class found in the Data page.


I don't have a lot of experience creating spreadsheets of this kind of complexity with any of the flavors (Excel, OO/LibreOffice, Google Docs). Is something with that much interwoven formulas even possible with Google Docs?

*edit- the above link is referring to the Spycraft 2.0 sheet
Title: Re: Excel Based Character Sheet
Post by: Fastidious Monk on April 06, 2012, 07:24:21 PM
The character sheet is now done and ready for people to try to break it. I've fired off a message to Crafty Games asking if somebody will check it over, and maybe host the file, and I'm waiting to hear something back before going any further.

If all is OK, is there anybody who would be interested in doing some 'beta' testing?

What is the latest with this?  Are you still looking for testers?

Thanks
Title: Re: Excel Based Character Sheet
Post by: cjs65 on April 07, 2012, 12:45:09 PM
I sent an email to Crafty some time ago but have not had a reply yet. Since then I have done quite a lot of testing myself and have found a few problems that need to be fixed. Creating a stack of characters and converting some high level characters from another system showed up a couple of things I had missed, as well as showing I hadn't allowed enough space for feats, tricks and studies. I'll be working on the sheet as soon as I get some time, hopefully over the next couple of weeks. Until Crafty have given it the ok from a legal point of view (I've used the FC logo for instance) I'm not willing to make it public, otherwise I'd be happy to send it out to anybody who's interested, just to get some initial feedback...
Title: Re: Excel Based Character Sheet
Post by: Crafty_Pat on April 07, 2012, 04:19:32 PM
I sent an email to Crafty some time ago but have not had a reply yet. Since then I have done quite a lot of testing myself and have found a few problems that need to be fixed. Creating a stack of characters and converting some high level characters from another system showed up a couple of things I had missed, as well as showing I hadn't allowed enough space for feats, tricks and studies. I'll be working on the sheet as soon as I get some time, hopefully over the next couple of weeks. Until Crafty have given it the ok from a legal point of view (I've used the FC logo for instance) I'm not willing to make it public, otherwise I'd be happy to send it out to anybody who's interested, just to get some initial feedback...

My apologies. That's been sitting in my inbox for a bit and I've been so swamped with projects that I haven't had the chance to follow up. I'm catching up a bit with email today though, and will go reply now. Expect an email shortly.
Title: Re: Excel Based Character Sheet
Post by: cjs65 on April 08, 2012, 02:36:24 AM
My apologies. That's been sitting in my inbox for a bit and I've been so swamped with projects that I haven't had the chance to follow up. I'm catching up a bit with email today though, and will go reply now. Expect an email shortly.

Hey, no problem at all Pat. I haven't chased it up because I assumed you guys were still busy. I got your mail and I'll send the sheet to you now for a first look, though I know for sure I need to make some changes.
Title: Re: Excel Based Character Sheet
Post by: Crafty_Pat on April 08, 2012, 02:50:43 PM
My apologies. That's been sitting in my inbox for a bit and I've been so swamped with projects that I haven't had the chance to follow up. I'm catching up a bit with email today though, and will go reply now. Expect an email shortly.

Hey, no problem at all Pat. I haven't chased it up because I assumed you guys were still busy. I got your mail and I'll send the sheet to you now for a first look, though I know for sure I need to make some changes.

All good, and thanks so much for understanding about our schedules. :)
Title: Re: Excel Based Character Sheet
Post by: The_Grand_User on April 18, 2012, 08:42:35 PM
So any further word on this little project?
Title: Re: Excel Based Character Sheet
Post by: Crafty_Pat on April 19, 2012, 10:56:42 AM
So any further word on this little project?

We've responded and as I understand, the OP is tinkering again. I may be wrong there, but I believe we gave him everything he needed for now.

If not, of course, we're happy to take another look. He has our email addresses. :)
Title: Re: Excel Based Character Sheet
Post by: cjs65 on April 20, 2012, 02:24:15 AM
So any further word on this little project?

We've responded and as I understand, the OP is tinkering again. I may be wrong there, but I believe we gave him everything he needed for now.

If not, of course, we're happy to take another look. He has our email addresses. :)

Ah, I was just waiting on the legal text. I sent you the updated/fixed version which Alex said was OK. Just let me know what words to add and I'm done for now, though I'm sure others will find improvements/problems!
Title: Re: Excel Based Character Sheet
Post by: Crafty_Pat on April 20, 2012, 10:37:44 AM
Ah, I was just waiting on the legal text. I sent you the updated/fixed version which Alex said was OK. Just let me know what words to add and I'm done for now, though I'm sure others will find improvements/problems!

We do owe you something then. My apologies. I'll go send that along now. :)
Title: Re: Excel Based Character Sheet
Post by: Crafty_Pat on April 20, 2012, 10:46:55 AM
We do owe you something then. My apologies. I'll go send that along now. :)

Done!
Title: Re: Excel Based Character Sheet
Post by: cjs65 on April 20, 2012, 02:06:32 PM
The 'Final' (for now) version has just been sent to Pat & Alex.  :)

Once it's made available for download, I'd very much appreciate any feedback, suggestions or bug reports from anyone who takes a look!

Title: Re: Excel Based Character Sheet
Post by: Crafty_Pat on April 20, 2012, 06:09:26 PM
The 'Final' (for now) version has just been sent to Pat & Alex.  :)

Once it's made available for download, I'd very much appreciate any feedback, suggestions or bug reports from anyone who takes a look!

It's now live. (http://www.crafty-games.com/downloads) Have at!
Title: Re: Excel Based Character Sheet
Post by: Antilles on April 21, 2012, 01:15:12 AM
I'm running through re-creating one of my PbP characters in this now, and first impressions is: Awesome! This is definitely one of the better excel setups I've tried, so well done mr cjs65 :)
Title: Re: Excel Based Character Sheet
Post by: ice_117 on April 21, 2012, 03:33:49 AM
I'm trying to make  a saurian character but I can't seem to figure out how to apply the attribute modifiers. There's some red text on page one that says I need to apply them but I don't know how.
Title: Re: Excel Based Character Sheet
Post by: cjs65 on April 21, 2012, 07:00:08 AM
I'm trying to make  a saurian character but I can't seem to figure out how to apply the attribute modifiers. There's some red text on page one that says I need to apply them but I don't know how.

Hi Ice, the key is that anything in a green cell can be changed. If you take a look at the table of species underneath the talent & specialty sections, you will see that the attribute modifiers for saurians, unborn are green. That's where you apply the attribute modifiers. This also needs to be done for some human talents in the Talents table.

Hope that clears things up!
Title: Re: Excel Based Character Sheet
Post by: ice_117 on April 21, 2012, 07:08:19 AM
Hi Ice, the key is that anything in a green cell can be changed. If you take a look at the table of species underneath the talent & specialty sections, you will see that the attribute modifiers for saurians, unborn are green. That's where you apply the attribute modifiers. This also needs to be done for some human talents in the Talents table.

Hope that clears things up!

Sorted. Thank you, I'll post more if I need help.
Title: Re: Excel Based Character Sheet
Post by: Bhurano on April 24, 2012, 01:50:24 AM
@cjs65

Damn great excel sheet. :)

I may have found a minor bug, or my english failed me. ::)

For a mage build I set the campaign quality to "fast proficiencies" but it doesn't seem to register. If I am not mistaken a mage with fast proficiencies should end up with 22 proficiencies. I had listed 12 instead of the 22 proficiencies.

I hope that helps... and thanks for sharing your awesome work. :)
Title: Re: Excel Based Character Sheet
Post by: cjs65 on April 24, 2012, 09:10:16 AM
@cjs65

Damn great excel sheet. :)

I may have found a minor bug, or my english failed me. ::)

For a mage build I set the campaign quality to "fast proficiencies" but it doesn't seem to register. If I am not mistaken a mage with fast proficiencies should end up with 22 proficiencies. I had listed 12 instead of the 22 proficiencies.

I hope that helps... and thanks for sharing your awesome work. :)

Hi, thanks for the positive feedback, glad you like the sheet. I just checked the problem you reported and you are absolutely correct about the proficiencies. Somehow I just got the formula wrong...

I'm in Germany on business at the moment but as soon as I get back home to the UK I'll get it fixed. I must admit I don't know how Pat and Alex want to handle updates/fixes - I don't want to swamp them with new versions every other day. Watch this space...

Carl.
Title: Re: Excel Based Character Sheet
Post by: Crafty_Pat on April 24, 2012, 10:32:34 AM
I'm in Germany on business at the moment but as soon as I get back home to the UK I'll get it fixed. I must admit I don't know how Pat and Alex want to handle updates/fixes - I don't want to swamp them with new versions every other day. Watch this space...

We appreciate the consideration. Uploading a new version once we have one up isn't much of a hassle, but keeping it to no more than one update every couple weeks would be great. :)
Title: Re: Excel Based Character Sheet
Post by: cjs65 on April 25, 2012, 11:50:40 AM
Back home and able to make changes now. What I'll do is aim to send an updated version to Crafty on about 4th May. Any problems reported by the end of this month will be fixed in that release.

Of course, I'm not just looking for problems; any ideas/suggestions to make it better are very welcome - No guarantee I'll run with every suggestion but I'll certainly review each one and give it serious consideration.

Thanks to all who are looking and trying out the sheet!

Carl.
Title: Re: Excel Based Character Sheet
Post by: The_Grand_User on April 25, 2012, 12:52:02 PM
I note that the list of Specialty names seems to be hard coded, could you add an option for custom specialty names? Also, the Feats and Abilities section is waaay too small, my character is only 6th level and he's already filled most of it (thank you, Crafty guys ;) )
Title: Re: Excel Based Character Sheet
Post by: Arakor on April 25, 2012, 01:19:56 PM
I'll second that call for customisation.
I'd like to use some of the classes and specialities from the Adventure Companion.
Title: Re: Excel Based Character Sheet
Post by: cjs65 on April 25, 2012, 01:21:03 PM
I note that the list of Specialty names seems to be hard coded, could you add an option for custom specialty names? Also, the Feats and Abilities section is waaay too small, my character is only 6th level and he's already filled most of it (thank you, Crafty guys ;) )

1. Specialty names. Good idea, shouldn't be a problem.

2. Feats and abilities. This is one I've been concerned about and I've mentioned previously. One thing I've done when using the sheet is not list origin/class abilities that only provide a bonus, just put the bonus in the right place and forget it. Also, multiple abilities can be combined into one entry (but not feats) if you can fit enough text in. The only sheet change solution I have currently is to overflow to a second sheet, which is certainly possible. I've been looking for a spot to add in sight & hearing range info, and another sheet would provide the required space...

Any thoughts welcome!

Carl.
Title: Re: Excel Based Character Sheet
Post by: cjs65 on April 25, 2012, 01:25:00 PM
I'll second that call for customisation.
I'd like to use some of the classes and specialities from the Adventure Companion.

Already there! Let me know if I missed anything though...
Title: Re: Excel Based Character Sheet
Post by: Sletchman on April 25, 2012, 01:31:46 PM
If it's possible, I also support custom origin options.  I use plenty of custom material in my games which makes giving this sheet to my players a little tricky.

Otherwise it's fantastic, and looks like it'd be a great tool for both new players and quickly putting a character together.  Great work man.
Title: Re: Excel Based Character Sheet
Post by: cjs65 on April 25, 2012, 01:39:12 PM
If it's possible, I also support custom origin options.  I use plenty of custom material in my games which makes giving this sheet to my players a little tricky.

Otherwise it's fantastic, and looks like it'd be a great tool for both new players and quickly putting a character together.  Great work man.

Thanks for the feedback!

There is already the option to add custom species, and I'll be adding custom specialties, which just leaves human talents. I seem to recall there was a reason why I didn't allow custom talents but I'll check again and add them if possible.

Anything else in the origin area that needs work?
Title: Re: Excel Based Character Sheet
Post by: Sletchman on April 25, 2012, 02:07:12 PM
You can easily put a custom human talent into the species space (as a user I mean), so custom talents aren't strictly necessary.  It's really just custom specialties that are missing, really.
Title: Re: Excel Based Character Sheet
Post by: cjs65 on April 26, 2012, 12:49:56 PM
Thanks to Antilles and Arakor for pointing out that the Adventure Companion Specialties were missing from the table. My bad, got lost in a re-hash of the sheet some time ago - I thought they were still there.  :-[

I'll add them back into the next release.
Title: Re: Excel Based Character Sheet
Post by: cjs65 on April 30, 2012, 12:24:08 PM
New version going out Friday. Changes so far:

Fixes:
- Corrected proficiency bonus from level when using non-standard proficiency gain rate campaign quality. (Class and Level)

Enhancements:
- Added Adventure Companion Specialties (Origin)
- Added space for 10 custom Specialties. (Origin)
- Added space for 10 custom Talents. (Origin)

I'll probably also be addressing the lack of space for feats/abilities, adding in some highlighting options for feats/abilities and also adding in vision & hearing ranges.

Last call for any other problems/suggestions...
Title: Re: Excel Based Character Sheet
Post by: ScrivenTwigz on April 30, 2012, 02:14:18 PM
Minor thing - the entry for Razor is missing from the weapons; Razor Sword is duplicated instead.

Regardless, this is great stuff; I hope more customization options are to come! Any chance of getting an unprotected version for modification in individual campaigns?
Title: Re: Excel Based Character Sheet
Post by: cjs65 on April 30, 2012, 02:25:38 PM
Minor thing - the entry for Razor is missing from the weapons; Razor Sword is duplicated instead.

Regardless, this is great stuff; I hope more customization options are to come! Any chance of getting an unprotected version for modification in individual campaigns?

Thanks for the feedback, Razor entry corrected. The stats were OK, just the name was wrong (Excel duplicating an earlier entry in the column without me noticing...)

Any suggestions for further customisation are welcome. Sorry, no, I don't wish to issue an unprotected version.
Title: Re: Excel Based Character Sheet
Post by: cjs65 on May 30, 2012, 01:08:27 PM
I've just fired off the latest version of this to Pat & Alex, so hopefully it will make its way to the downloads page sometime soon.

Changes from Version 0.3 to Version 1.0 are as follows:

Fixes:
- Corrected proficiency bonus from level when using non-standard proficiency gain rate campaign quality. (Class and Level)
- Changed Razor entry in weapons table to 'Razor' instead of 'Razor Sword'. (Weapons)
- Corrected omission of Charisma as a Lifestyle modifier. (Lifestyle and Reputation)
- Corrected various missile weapon damage types to 'Ammo' to fix lookup problem. (Weapons)

Enhancements:
- Added Adventure Companion Specialties. (Origin)
- Added space for 10 custom Specialties. (Origin)
- Added space for 10 custom Talents. (Origin)
- Added space for 28 extra feats/abilities. (Feats and Abilities)
- Added Feats and Abilities Overflow sheet. (Character Sheets)
- Allowed cells to be formatted on the character sheets so that some format customisation can be carried out. (Character Sheets)

Sorry it's about a month late, had a busy time at work.  :(

As usual any bug reports/feedback/suggestions are very welcome.
Title: Re: Excel Based Character Sheet
Post by: Crafty_Pat on May 30, 2012, 10:35:35 PM
New version's live.
Title: Re: Excel Based Character Sheet
Post by: Takeru on October 27, 2012, 09:52:35 AM
Hi. Been using this Excel-Based sheet for quite some time, but I have to ask;

How do you add a Character Image to it? There's two places where it says "insert character image here", but trying to add an image just pops up a protected error.
Title: Re: Excel Based Character Sheet
Post by: Takeru on October 27, 2012, 09:58:37 AM
and wouldn't ya know it, right after I post this I figure it out on my own.  ::)

IGNORE ME!
Title: Re: Excel Based Character Sheet
Post by: cjs65 on October 27, 2012, 11:44:33 AM
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.
Title: Re: Excel Based Character Sheet
Post by: cjs65 on October 31, 2012, 05:35:08 AM
The new version (1.01) is now live on the downloads page. Thanks Pat!
Title: Re: Excel Based Character Sheet
Post by: Crafty_Pat on October 31, 2012, 11:22:15 AM
The new version (1.01) is now live on the downloads page. Thanks Pat!

Oh crap. I meant to come back and post when it went up but I got swamped here. Sorry about that!
Title: Re: Excel Based Character Sheet
Post by: Antilles on November 06, 2012, 04:36:06 AM
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...
Title: Re: Excel Based Character Sheet
Post by: cjs65 on November 06, 2012, 04: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.
Title: Re: Excel Based Character Sheet
Post by: Crafty_Pat on November 06, 2012, 04:17:51 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.

In my experience that problem is solved by changing the cell format to "text."
Title: Re: Excel Based Character Sheet
Post by: cjs65 on November 07, 2012, 12: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.
Title: Re: Excel Based Character Sheet
Post by: VisualStatic on November 16, 2012, 11:50:57 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.
Title: Re: Excel Based Character Sheet
Post by: cjs65 on November 17, 2012, 11:39:12 AM
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.
Title: Re: Excel Based Character Sheet
Post by: cjs65 on November 17, 2012, 02: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.
Title: Re: Excel Based Character Sheet
Post by: Bill Whitmore on November 17, 2012, 02:38:48 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.

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.
Title: Re: Excel Based Character Sheet
Post by: cjs65 on November 17, 2012, 04: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.
Title: Re: Excel Based Character Sheet
Post by: Bill Whitmore on November 17, 2012, 08:05:16 PM
It was actually picking up the Sneak value as the range lookup (TRUE) uses the next smallest value.

You, sir, are correct.  I misread the description in the vlookup docs.  It said "next largest value that is less than lookup_value" but I just read "next largest value" while I was skimming it and missed the "less than" portion.
Title: Re: Excel Based Character Sheet
Post by: cjs65 on November 25, 2012, 11:22:02 PM
The new version is live on the Downloads page. Thanks Pat!
Title: Re: Excel Based Character Sheet
Post by: cjs65 on February 03, 2013, 02: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.
Title: Re: Excel Based Character Sheet
Post by: cjs65 on February 03, 2013, 11:33:14 AM
Well, that was an easy change after all. The new version (1.10) has been sent to Pat to go onto the downloads page.
Title: Re: Excel Based Character Sheet
Post by: Crafty_Pat on February 03, 2013, 04:29:54 PM
Well, that was an easy change after all. The new version (1.10) has been sent to Pat to go onto the downloads page.

Updated.
Title: Re: Excel Based Character Sheet
Post by: Salvatos on February 03, 2013, 04:55:53 PM
Thank you very much to both :)
Title: Re: Excel Based Character Sheet
Post by: Antilles on March 06, 2013, 05:30:39 AM
I've been working on converting some Pre-gens to FC using the sheet, and there is a couple of things I can't find, or that I'm sure how to input... The first is mostly cosmetic, but still useful, namely type. The second is natural attacks. The NPC I was converting got Gore I from Devilish Heritage, but it's not in the weapons list and I can't input it because the table won't accept a weapon that requires 0 hands...
Title: Re: Excel Based Character Sheet
Post by: cjs65 on March 06, 2013, 10:24:25 AM
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.
Title: Re: Excel Based Character Sheet
Post by: Antilles on March 06, 2013, 11:54:19 AM
A bit clunky, especially when with the right build you could end up as 'Ogre [Folk, Fey, Outsider, Horror]', but I can understand it'd be a bloody pain to redesign the sheet for such a minor payoff.
Title: Re: Excel Based Character Sheet
Post by: Daeryth on April 11, 2013, 09:09:55 AM
Hello:

First off, I find this character exceptionally useful as a new FC player -

Question: Has anyone found a way to store this out on the cloud where it will open without having to have excel present and have it look 'ok'? I don't plan on updating it during a session, I would just like to call it up on my tablet as needed.

- Google docs flips the sheets to landscape (this appears to be a known issue with excel that hasn't been addressed)
- SkyDrive doesn't want to open it due to the workbook's encryption

Regardless it is still an awesome piece of excel magic, so thanks for spending the time on it!
Title: Re: Excel Based Character Sheet
Post by: Sletchman on April 11, 2013, 09:15:17 AM
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?
Title: Re: Excel Based Character Sheet
Post by: Daeryth on April 11, 2013, 09:23:43 AM
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?

Thanks for the advice!  That looks like it will work out just fine.
Title: Re: Excel Based Character Sheet
Post by: cjs65 on April 11, 2013, 01: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'.
Title: Re: Excel Based Character Sheet
Post by: parsious on June 07, 2013, 07:58:25 PM
well i have to say im new to the Fantasy craft system but so far im liking what i see and read but in the top post i noticed you had a excel sheet for Mongoose traveller, i have been putting off doing a MgT sheet foe a year or so now and was wondering id there was any chance of getting a copy of your one  ;D

cheers
Josh
Title: Re: Excel Based Character Sheet
Post by: cjs65 on June 08, 2013, 06: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!
Title: Re: Excel Based Character Sheet
Post by: Takeru on June 08, 2013, 09:31:14 PM
I think this sheet needs a place to list what prizes you have, and possibly a format for those prizes. I keep running into the issue of wondering exactly how I've -spent- the reputation that I've spent, and the "Equipment" page just doesn't seem to cut it for things like Holdings and Contacts.

But that aside, this is an AMAZING sheet and you're doing great things with it.
Title: Re: Excel Based Character Sheet
Post by: TheVastator on July 22, 2013, 03:21:47 AM
hey guys, is the sheet link the one in the Downloads section in the Crafty main site, or a different one?

-edit: found the answer in the previous page :)
Title: Re: Excel Based Character Sheet
Post by: Arakor on March 31, 2015, 03:44:53 PM
Anyone know if there will be an update to the Character Sheet to accomodate the new Call To Arms classes: the Shinobi, the Skirmisher and the Witch Hunter?
Title: Re: Excel Based Character Sheet
Post by: cjs65 on April 18, 2015, 04:11:42 PM
Hi all, I've had a couple of questions now about whether the sheet will be updated with new classes.

I'm afraid the answer is no. I no longer play Fantasy Craft and it seems unlikely I'll ever go back to it. If there's anyone out there who's good with Excel and feels they'd like to take it over, I'd be happy to pass it on and provide the necessary passwords to allow editing. I'm afraid I don't have any technical documentation to go with it though.

Anybody who understands Excel's condition checks, conditional formatting, table lookups and database functions as well as cell formatting and protection should be able to get along with it OK. I'd also be happy to provide limited email support.

If you have good Excel skills and feel you'd like to take this on, send me a PM. My ideal would be to hand it over to the Crafty guys, but I suspect they have enough work on their plates and wouldn't want to add this.

Carl.
Title: Re: Excel Based Character Sheet
Post by: Jingles on April 23, 2015, 12:28:45 PM
Hi Carl,

My group uses your sheet. I'm not an excel master, but I have added Shinobi, Skirmisher and Witch Hunter and intend to add all the Spellbound classes when they come out. I was wondering if you'd mind if I posted the updated version. Otherwise I'll keep edits just among my group.

-Victoria
Title: Re: Excel Based Character Sheet
Post by: Takeru on October 31, 2015, 02:08:28 PM
Bit of thread necromancy but I find myself needing this sheet: How did you edit it, and could you share your version? I'm playing a Burglar/Shinobi and would greatly prefer to use this sheet.
Title: Re: Excel Based Character Sheet
Post by: Takeru on January 08, 2016, 09:21:04 PM
Does anyone know the password to this sheet? I desperately need to add the Shinobi to this sheet and can't get it edited.  :-[
Title: Re: Excel Based Character Sheet
Post by: RadicalEdward on January 08, 2016, 09:31:58 PM
AAAAAAABBBA7
Title: Re: Excel Based Character Sheet
Post by: mmgarcia30 on March 02, 2016, 08:05:05 AM
Hi mates

Since the change in the main Crafty Games page where can I find the Excel? It's anybody maintaing it?

Best regards, and thank for your work from Spain.
Title: Re: Excel Based Character Sheet
Post by: Salvatos on March 19, 2016, 08:31:04 PM
I don't know if this is the most up-to-date version, but this one says 1.10 inside (although it says v5 on the file name):

http://www.mediafire.com/download/diwel6760wd6646/Fantasy_Craft_Character_Sheet-v5.xls
Title: Re: Excel Based Character Sheet
Post by: Broken Twin on November 10, 2017, 05:13:32 PM
Could this possibly be readded to the downloads page? Really makes character creation a lot easier, especially for new players.
Title: Re: Excel Based Character Sheet
Post by: Crafty_Pat on November 12, 2017, 11:04:05 AM
Could this possibly be readded to the downloads page? Really makes character creation a lot easier, especially for new players.

We no longer have a dedicated Downloads page. All official freebies will be added to the new webstore, which you can see is now live at the homepage (https://www.crafty-games.com).

We've added some but not all of the sheets created for each game in the Support Materials section. Click here (https://www.crafty-games.com/product-category/game-support/spycraft-2-0-downloads/) for the Spycraft 2.0 agent sheets we're hosting.

Sorry, but we can't host every sheet created for every game. There's a real potential for harmful clutter with this set-up, and so we have to keep things pretty streamlined.

Anyone is, of course, welcome to host any versions of any character sheets made for any of our games, anywhere on the web, and link back to them here in the forums.