Author Topic: Excel Based Character Sheet  (Read 16527 times)

cjs65

  • Jr. Agent
  • **
  • Posts: 70
    • View Profile
Excel Based Character Sheet
« 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>!  ;)

VisualStatic

  • Control
  • ******
  • Posts: 1168
    • View Profile
Re: Excel Based Character Sheet
« Reply #1 on: March 02, 2012, 12:33:01 PM »
Not to be that guy, but..... link   :P
--
Heroes don't die, they just reload.
--
A Master of the Dark Arts of System Administration.

cjs65

  • Jr. Agent
  • **
  • Posts: 70
    • View Profile
Re: Excel Based Character Sheet
« Reply #2 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!

Dreamstreamer

  • Agent
  • ***
  • Posts: 229
    • View Profile
Re: Excel Based Character Sheet
« Reply #3 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 or Alex. They can tell you exactly what's needed for permission. FYI, it will likely involve inserting a small amount of copyright text.

Crafty_Pat

  • Crafty Staff
  • Control
  • *****
  • Posts: 9781
  • We have all the time in the world.
    • View Profile
    • Crafty Games
Re: Excel Based Character Sheet
« Reply #4 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 or Alex. 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!
Patrick Kapera
Crafty Games

UPDATES/PRESS INFO
Newsletter: http://bit.ly/14FJIw7
Facebook: www.facebook.com/craftygames
Google Plus: https://plus.google.com/+Crafty-Games/
Twitter: www.twitter.com/Crafty_Games
YouTube: www.youtube.com/craftyhomeoffice

In game terms, reality is broken.

Segreant

  • Specialist
  • *
  • Posts: 5
    • View Profile
Re: Excel Based Character Sheet
« Reply #5 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.

cjs65

  • Jr. Agent
  • **
  • Posts: 70
    • View Profile
Re: Excel Based Character Sheet
« Reply #6 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?

Gentry

  • Control
  • ******
  • Posts: 2863
  • It's a Trap!
    • View Profile
    • Wyrmstone Homepage
Re: Excel Based Character Sheet
« Reply #7 on: March 10, 2012, 04:16:56 PM »
I'd believe the latter, simply by virtue of it being simpler.
I'm a secret VAO Control (Shh!)

Check out Wyrmstone for FC Open Source campaigning

Have you joined Knife Rights yet?

Live and game in Flyover Country? Join Tornado Alley Game Guil

Khaalis

  • Operative
  • ****
  • Posts: 332
    • View Profile
Re: Excel Based Character Sheet
« Reply #8 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).



cjs65

  • Jr. Agent
  • **
  • Posts: 70
    • View Profile
Re: Excel Based Character Sheet
« Reply #9 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.

Moebius

  • Agent
  • ***
  • Posts: 123
    • View Profile
    • The Geek Flag
Re: Excel Based Character Sheet
« Reply #10 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?!?!  >:(

cjs65

  • Jr. Agent
  • **
  • Posts: 70
    • View Profile
Re: Excel Based Character Sheet
« Reply #11 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)

Moebius

  • Agent
  • ***
  • Posts: 123
    • View Profile
    • The Geek Flag
Re: Excel Based Character Sheet
« Reply #12 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.

tfwfh

  • Operative
  • ****
  • Posts: 444
    • View Profile
Re: Excel Based Character Sheet
« Reply #13 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.
Who's the more foolish, the fool or tfwfh?

Dreamstreamer

  • Agent
  • ***
  • Posts: 229
    • View Profile
Re: Excel Based Character Sheet
« Reply #14 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.
« Last Edit: March 22, 2012, 08:47:02 AM by Dreamstreamer »