[REGISTER] or [LOGIN] to browse without adverts

27 posts / 0 new
Last post
Cthulhu Netobvious
Cthulhu Netobvious's picture
Character Generator for 7th Sea 2e
game tool, characters, character creation

Thanks to James Anderson.

This is an editable Character Generator Spreadsheet. It also converts the computations to printable form.

Click the links below to download (v1.20 updates previous v1.10 with major NEW additions including Nations of Theah)

v1.12 7thSea2e_character_sheet_v1.20 (includes Nations of Theah Volume 1 and Volume 2)

v1.10 7thSea2e_character_sheet_v1.10 (includes Pirate Nations and Heroes & Villains)

v1.06 7thSea2e_character_sheet_v1.06 (updates and bug fixes from v1.05)

v1.05 7thSea2e_character_sheet_v1.05 (updates and bug fixes from v1.04)

v1.04 7thSea2e_character_sheet_v1.04 (fixes spelling and other errors in v1.03)

v1.03 7thSea2e_character_sheet_v1.03 (fixes graphics problem in v1.02)

v1.02 7thSea2e_character_sheet_v1.02 (inculdes character advancement)

v1.01 7thSea2e_character_sheet_v1.01 (includes dueling)

v1.0 7thSea2e_character_sheet_v1 

6 votes
+
Vote up!
-
Vote down!

TAJ-07: Technopriest And Justicar Of 7thSea2e

Harliquinn Whit...
Harliquinn Whiteshadow's picture

I downloaded this. The 'builder' part looks pretty solid, but the 'sheet view' had some problems with alignment of the 'dots' on the page I noticed. It may be my operating system (Mac).

Cthulhu Netobvious
Cthulhu Netobvious's picture
We just updated @JamesAnderson's character generator to v1.02. Hopefully, it fixes the minor problems that you discovered.

TAJ-07: Technopriest And Justicar Of 7thSea2e

James Anderson
James Anderson's picture

That's an operating system / software issue.  I suspect anything that's not the actual Microsoft Excel 2010 product will have trouble with the graphics lining up.

The "print" tab is what I'll be using myself, as I like in-depth character sheets.  "Sheet" was included for those liking the original.  Hmm, I just got an idea on how I might be able to replicate it better....

DaWaterRat
DaWaterRat's picture
Ah, I was afraid of that. Since I use LibreOffice (which admittedly I haven't updated in a while), I can't even open it. Ah well, thanks anyway.
James Anderson
James Anderson's picture

OpenOffice or Google Spreadsheets should open it just fine, they just won't have the graphics lining up.  The work-around I came up with yesterday is panning out well but I'm working through a few other comments from testers before I release again.

So, next version should be a lot more accessible!

DaWaterRat
DaWaterRat's picture
Hmm. Maybe I'll find time to update. When I tried to open it, OpenCalc (well, LibreCalc) kept crashing.
James Anderson
James Anderson's picture

Ok, newest version uses standard excel shading to mimic the official sheet instead of using a graphical underlay.  It should work on all platforms now.  There's still a graphic for the death spiral, but it doesn't interact with anything so you can just move it around / scale it if you need to.

 

Allen Hueffmeier
Allen Hueffmeier's picture

I have a pdf form to contribute, how do you attach to a post?

Cthulhu Netobvious
Cthulhu Netobvious's picture

Thank you, @AllenHueffmeier, you can attach them like "images" if you select "Text Format: Forum HTML" below any thread reply. There is no special file optoin. Or if you have them PDF hosted somewhere, then post a link like a URL instead. 

I also just sent you a Private Message with the email address. Private messages can be seen at the very bottom of the screen if you scroll down that low. yes

TAJ-07: Technopriest And Justicar Of 7thSea2e

Mark Lundequist
Mark Lundequist's picture

About a week ago I sent a few mispellings here and there that I picked up, but the big issue I found is when I picked Large advantage, it gave me the description of Foreign Born...wondering if you ever got around fixing that. Also when I print out the "official character sheet style", it doesn't print the Swordsman style & bonus maneuver, but it will when you print out the 4-5 pg character sheet style.

James Anderson
James Anderson's picture

I never got your list of mispellings.  Can you please send it to me directly?  I'm looking into the other things you mentioned now.  Thanks for pointing them out.

 

Notably, most words that start with F will have a typo somewhere in them.  It's something to do with how the text was copied from the pdf.

Cthulhu Netobvious
Cthulhu Netobvious's picture

@JamesAnderson, I think @MarkLundequist sent the message to me so I just messaged you with the details.

TAJ-07: Technopriest And Justicar Of 7thSea2e

Mateo Leviathon
Mateo Leviathon's picture

Interesting work. Have you a plan to tackle the extra "health" when someone takes the Hard to Kill advantage?

James Anderson
James Anderson's picture

The detailed sheet already has this incorporated - if you select Hard to Kill, the extra line will show up.  Adding it to the "official" style sheet would be difficult as it would need to replace the death spiral graphic and I'm not sure if I can tie that to a formula.

BG Mike
BG Mike's picture

Thanks for this awesome tool!

One bug that I found: When selecting the Background Knight Errant, the Advantage Direction Sense appears below the listing, but does not populate in the Advantages section, nor on the Character Sheet.

 

Thanks again!

Mike

James Anderson
James Anderson's picture

Thanks for pointing it out.  Turns out it's a general problem of having 3 advantages on the first background.  I've now fixed it for the next update.

If you want to continue with the sheet you're working on you can type Direction Sense into cell B64 and it should carry through.

Tec Goblin
Tec Goblin's picture

The sheet is fantastically useful.

I found out a small bug though. The calculation of the free advantages twice awarded has issues with blank cells. Try first background Aristocrat, Second Duelist, and you get a N/A on A35. For the moment I did a lazy fix on H30 =IFNA(AC34,0)+IFNA(AC35,0)+IFNA(AC36,0)

 

James Anderson
James Anderson's picture

Thanks for the catch.  Fix is in cell AB35.  Add =IF(E31="",0, to the start of the formula and close the parentheses on the end.  This will also be included in the next update, which I'll try to send in tomorrow.

Donovan Morningfire
Donovan Morningfire's picture

Very handy.  Thanks indeed to James Anderson for creating this.

Dono's Gaming & Etc Blog
http://jedimorningfire.blogspot.com/

Donovan Morningfire
Donovan Morningfire's picture

One bug I found, is that it's treating Cast Iron Stomach as being the Camaraderie advantage, both in terms of point cost (3pts instead of 1pt) and the description of what Cast Iron Stomach does.

Other than that, this has been pretty handy, so thanks again to the creator for putting this together.

Dono's Gaming & Etc Blog
http://jedimorningfire.blogspot.com/

James Anderson
James Anderson's picture

Sorry it took me a while to get back to this.  Was a simple alphabetizing issue.  Got it fixed for the next version.

James Anderson
James Anderson's picture

I just sent in the update for Heroes & Villains and for Pirate Nations.

Leads me to a formating question for people.  How do you want me to flag things from non-core books?  Internally, they're highlighted in different colors, but so far I don't have anything user-facing to designate it.  The easiest is for me to keep it that way - new things just appear in the dropdowns as if they'd always been there.  Is that sufficient, or is there demand for knowing which book an ability comes from?  If so, how would you like that to look?

Redcig
Redcig's picture

Thank you guys for the great Generator! I noticed a couple of things while using it recently:

  • Seize Your Glory Advantage: does not give appropriate discount to Numa characters.
  • Foul Weather Jack Advantage: as far as I can tell, it doesn't allow me to actually create a 2nd Story.
  • Print worksheet: Does not seem to include Stories. [edit] Scratch that, I see it now. Kind of hard to read, though.
  • Mystirios: I found a bug with this Sorcery. It seems to be an error in referencing within the hidden cells. Here's a breakdown of my findings:
    • Selecting Theonoa Dianoia as a Mystirio does not allow me to select the associated Apokalypsi.
    • Selecting the Hecteba Mystirio allows me to select the Theonoa Apokalypsi.
    • The problem seems to stem from improper references on cells S144:T154 and the associated table on the styles sheet.
    • In my case, cell S147 is Theonoa. Cell T147 tries to reference cell styles!I104, which is Hecteba, and due to the COUNTIF structure returns FALSE.
    • Conversely, cell S151 is Hecteba (if creating a Villain). Cell T151 references cell styles!108, which is Theonoa. Due to the COUNTIF structure, returns Theonoa as the associated Apokalypsi.

It'd be interesting if you had some way of tracking/archiving past Stories as the PC advances.

As for the flagging, I'd advise against it. You either keep everything as simple as possible or go whole-hog and add source books and pages numbers for everything, which will turn into quite a bookkeeping exercise (especially since some mechanics pop up in different sourcebooks). On the other hand, if you want to go the librarian route, now's the time to set the structure for it.

Donovan Morningfire
Donovan Morningfire's picture

One bug I just noticed is that if you select Highlands as your Nation, the Seanchaidh background doen't appear on the list of selectable options.

Same is true for Avalon with the Puritan background and Inismore with the Saoi background.

Dono's Gaming & Etc Blog
http://jedimorningfire.blogspot.com/

Cthulhu Netobvious
Cthulhu Netobvious's picture

And the latest updated Character Generator by James Anderson is version 1.12, which fixes most bugs found so far and adds new sourcebooks (no Crescent Empire yet).

TAJ-07: Technopriest And Justicar Of 7thSea2e

Giasone Vodocci
Giasone Vodocci's picture

Any plans on updating this for the New World book or Lands of Gold and Fire?

share buttons