Back to Crafty Games Welcome, Guest. Please login or register.
Did you miss your activation email?
July 24, 2014, 02:05:06 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.

+  Crafty Games Forum
|-+  Products
| |-+  Fantasy Craft
| | |-+  Excel Based Character Sheet
« previous next »
Pages: [1] 2 3 ... 6 Go Down Print
Author Topic: Excel Based Character Sheet  (Read 8223 times)
cjs65
Jr. Agent
**
Posts: 69


View Profile
« on: March 02, 2012, 03: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>!  Wink
Logged
VisualStatic
Control
******
Posts: 1142



View Profile
« Reply #1 on: March 02, 2012, 03:33:01 PM »

Not to be that guy, but..... link   Tongue
Logged

--
Heroes don't die, they just reload.
--
A Master of the Dark Arts of System Administration.
cjs65
Jr. Agent
**
Posts: 69


View Profile
« Reply #2 on: March 02, 2012, 03: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!
Logged
Dreamstreamer
Agent
***
Posts: 181



View Profile
« Reply #3 on: March 02, 2012, 03: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.
Logged
Crafty_Pat
Crafty Staff
Control
*****
Posts: 9425


End of the World? Donít believe the hype.


View Profile WWW
« Reply #4 on: March 02, 2012, 08: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!
Logged

Patrick Kapera
Crafty Games
www.crafty-games.com

UPDATES/PRESS INFO
Mailing List: http://bit.ly/14FJIw7
RSS: www.crafty-games.com/needtoknow
Facebook: www.facebook.com/craftygames
Twitter: www.twitter.com/Crafty_Games

In game terms, reality is broken.
Segreant
Crafty n00b

Posts: 4


View Profile
« Reply #5 on: March 03, 2012, 02:30:43 PM »

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.
Logged
cjs65
Jr. Agent
**
Posts: 69


View Profile
« Reply #6 on: March 10, 2012, 06: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?
Logged
Gentry
Powered By Publisher
Control
******
Posts: 2815


It's a Trap!


View Profile WWW
« Reply #7 on: March 10, 2012, 07:16:56 PM »

I'd believe the latter, simply by virtue of it being simpler.
Logged

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: 322




View Profile
« Reply #8 on: March 11, 2012, 09: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).


Logged
cjs65
Jr. Agent
**
Posts: 69


View Profile
« Reply #9 on: March 21, 2012, 05: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.
Logged
Moebius
Agent
***
Posts: 118



View Profile WWW
« Reply #10 on: March 21, 2012, 09:59:06 PM »

I suppose it's not very good in LibreOffice? They usually aren't. Why can't they be compatible?!?!  Angry
Logged

cjs65
Jr. Agent
**
Posts: 69


View Profile
« Reply #11 on: March 22, 2012, 02:28:32 AM »

I have no idea, I'm afraid.  Sad  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...  Cool
Logged
Moebius
Agent
***
Posts: 118



View Profile WWW
« Reply #12 on: March 22, 2012, 04: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.
Logged

tfwfh
Operative
****
Posts: 443



View Profile
« Reply #13 on: March 22, 2012, 10:03:31 AM »

I have no idea, I'm afraid.  Sad  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...  Cool

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.
Logged

Who's the more foolish, the fool or tfwfh?
Dreamstreamer
Agent
***
Posts: 181



View Profile
« Reply #14 on: March 22, 2012, 10: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, 10:47:02 AM by Dreamstreamer » Logged
Pages: [1] 2 3 ... 6 Go Up Print 
« previous next »
Jump to:  


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