Page 1 of 4 1234 LastLast
Results 1 to 10 of 32

Thread: BWG Online Character Sheet "The Scribe" v1.0

  1. #1
    Join Date
    Jul 2011
    Location
    Seoul
    Posts
    513
    Rep Power
    174

    Default BWG Online Character Sheet "The Scribe" v1.1

    NOTE: Version 1.1 has now been released, which includes a couple of bug fixes and some minor formatting cleanup.

    Ladies and gentlemen, boys and girls, brought to you by somewhat popular demand, I am pleased to introduce to you the newest member of our character sheet family: The Scribe (v1.0).

    This is an online character sheet for Burning Wheel Gold, in the form of a Google Docs spreadsheet template. It's still a little rough around the edges, but it works serviceably. I'm by no means a spreadsheet expert, all self-taught in that regard, so go easy on me!

    Features:
    • Up to 98 skills! (Upgradable to an infinite skill list, but really, 98 is overboard already...)
    • Automatic calculation of tests needed for advancement
    • Automatic statblock generation


    To access this template:
    1. Log in to your google account, and open Google Documents.
    2. Click on CREATE --> From template...
    3. Do one of the following:
    4. Copy/paste the following url into the address bar: http://tinyurl.com/BWGsheet
    5. Alternatively, copy/paste the following template name into the search field: Burning Wheel Gold Online Character Sheet ("The Scribe" v1.1)
  2. Click Use this template


I apologize for the pain in the ass of having to follow these steps, but I currently have no way to link to the template itself.

More information is provided on sheet 1 of the template (which you can delete after reading). Any feedback you can give me would be greatly appreciated! I will update this spreadsheet with more functions at a later date, once I finish designing my regular-old pencil and paper character sheet (which is something I'm a bit better at doing).

Edit: It may not be readily apparent what the automatic statblock generation is all about, as the statblock sheet is empty when you first open the template. Here's what it looks like once you've filled in the other three pages:


Still a bit of work to be done to clean it up nice, but you get the idea. Enjoy! ^^
Last edited by Dean; 04-23-2015 at 08:48 AM.
Reply With Quote Reply With Quote

  • #2
    Join Date
    Jun 2009
    Location
    Nova Scotia, Canada
    Posts
    248
    Rep Power
    67

    Default

    I've tried it multiple times and any time I try to use the template it tells me that the spreadsheet can't be copied.

    Edit: It works if you create a new document using the "from template" option, but not if you click the "use this template" button on the page linked above.
    Last edited by FigureFour; 08-26-2011 at 09:13 PM.

  • #3
    Join Date
    Jul 2011
    Location
    Seoul
    Posts
    513
    Rep Power
    174

    Default

    Ack! Thanks for letting me know! I have no way of determining that myself; since I was the one who created the template, I can create a document with it directly via the link. I updated the first post with instructions on how to access this template. Do they work for you?

    For the record, I'm not really the hugest fan of Google Docs. The site's a bit buggy and slow at times, and doesn't play well with my Mac. However, it does serve a very useful purpose, so I use it when I need to.

    I created this template primarily because I will soon be starting an online solo campaign with a friend of mine. He lives nearby, so we might be able to meet for the odd session, yet we'll be doing most of our gaming via the internet, and will both be using a range of ways to connect (desktops [home and work], laptops, smartphones, iPad). Google Docs is perfect for our needs, and with the option to print a character sheet from the statblock, can be used for tabletop as well. I hope there are other Burning Wheel players that will find this template useful for similar purposes.

  • #4
    Join Date
    Jul 2011
    Location
    Seoul
    Posts
    513
    Rep Power
    174

    Default

    I've updated the first post with an image of what the fully generated statblock looks like. I couple of errors I noticed:

    1. The three Instincts are supposed to be separated by line breaks, but instead show up all on one line. It's an issue with the CHAR(10) and CHAR(13) functions. I'll get it sorted out and fixed up for v1.1

    2. The first cell of the statblock notes is formatted as right-aligned, boldface, and 8-point font. You can fix this yourself by reformatting as left-aligned, regular typeface, 10-point font to match the rest of the document. Will be fixed for v1.1

  • #5
    Join Date
    Jun 2009
    Location
    Nova Scotia, Canada
    Posts
    248
    Rep Power
    67

    Default

    Since we're noticing errors: I've got one character with a statblock that reports a Reflexes of B4.666666666667 despite me entering B4.

    Other than that, it's pretty useful so far!

  • #6
    Join Date
    Jul 2011
    Location
    Seoul
    Posts
    513
    Rep Power
    174

    Default

    Yikes! Another one to add to the list... I know what the problem is though. I had started to code in some automatic calculation for stuff like Reflexes, but then quit because my BWG book hasn't arrived yet, and I'd rather wait to get it right.

    I'll upload v1.1 early next week, with fixes for all the issues detected thus far. If you absolutely need the statblock before then, you can try and fix it yourself by accessing the hidden formulas sheet. The formulas sheet is pretty well organized, shouldn't be too much of a hassle. Just find the Reflexes box, and replace the code there with the following:

    =CONCATENATE(SHADE,EXPONENT)

    With "shade" and "exponent" being assigned to the corresponding cells on the stat sheet. (Note: when writing a formula, you can navigate to the other sheet and select the cell you want to reference. This will put the correct sheet/cell reference into the formula.)

    Quote Originally Posted by FigureFour View Post
    Other than that, it's pretty useful so far!
    Thank you! Positive feedback is the best kind. ^^

  • #7
    Join Date
    Jul 2011
    Location
    Seoul
    Posts
    513
    Rep Power
    174

    Default

    Version 1.1 has been released. The bugs involving Instincts and Reflexes have been fixed. The formatting for the first statblock notes cell has been fixed. I also formatted the weapons list on the statblock so that you only get the alternating grey lines if you actually have multiple weapons.

    A minor revision, except for the Reflexes bug. That was a big one.

    Enjoy!

  • #8
    Join Date
    Sep 2005
    Location
    Los Angeles
    Posts
    42
    Rep Power
    0

    Default

    Dean-

    This is awesome. Really useful.

    Works great on the iPad too which is a major plus.

    Jaime

  • #9
    Join Date
    May 2005
    Location
    Astoria, NY
    Posts
    820
    Rep Power
    523

    Default

    The neurotic diseased proofreader in me would like Character traits to be (Ch), Die traits to be (Dt) and Call-On traits to be (C-O). Also weapon speed either in full or WS as abbreviated in the text.

    </nitpick>
    I was Iskander. It is entirely possible that I may be wrong on the Internet while posting. I have a blog about my brain damage.

  • #10
    Join Date
    Jul 2011
    Location
    Seoul
    Posts
    513
    Rep Power
    174

    Default

    Thanks! Great to hear it's ipad compatible. Do you have to do a lot of scrolling around, or do the sheet borders fit on the ipad screen nicely? I set it up to fit a fairly low screen resolution for desktop PCs. Dunno about how it looks on other devices yet though, so let me know!

    Oh, and I do plan on getting an ipad sometime soonish, and will likely do a new char sheet in Numbers eventually. Stay tuned! ^^
    Last edited by Dean; 08-31-2011 at 07:16 AM.

  • Page 1 of 4 1234 LastLast

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •