Discussion: Use of Google Spreadsheets in Place of Wiki Character Sheets - Page 2





+ Log in or register to post
Page 2 of 10 FirstFirst 12345678910 LastLast
Results 11 to 20 of 99
  1. #11
    Registered User
    Waghalter (Lvl 7)

    Mewness's Avatar

    Join Date
    Oct 2003
    Location
    Alameda
    Posts
    1,904
    Reviews
    Read 0 Reviews

    Ignore Mewness
    I may have mistook the intention. I was thinking about powers like the warlock's Chains of Levistus, where you get an additional 2d6 (without the stat modifier) if the target moves.
    Papolstaanas (babbling kobold); Pharodeys (living statue); Scarmiglione (singing kenku)

 

  • #12
    Registered User
    Defender (Lvl 8)

    ScorpiusRisk's Avatar

    Join Date
    Jun 2006
    Location
    Roslindale MA 02131
    Posts
    2,499
    Reviews
    Read 0 Reviews

    Ignore ScorpiusRisk
    THB, read my intention correctly. That line is for attacks that have two different sized dice in one damage roll.

    If you have a second damage roll, you probably want to copy and paste those lines, so you have two separate math areas.
    Current Work: http://stuffershack.com/tag/brian-liberge/

  • #13
    Registered User
    Defender (Lvl 8)

    ScorpiusRisk's Avatar

    Join Date
    Jun 2006
    Location
    Roslindale MA 02131
    Posts
    2,499
    Reviews
    Read 0 Reviews

    Ignore ScorpiusRisk
    Started importing a possible 2nd LEB PC.

    Fixed a minor code issue with the new Surge Value Math line.

    Changed the defenses block to include neck items with armor. Neck items felt really silly under Misc, but theres not space for much more there.
    Current Work: http://stuffershack.com/tag/brian-liberge/

  • #14
    Registered User
    Acolyte (Lvl 2)

    Dunamin's Avatar

    Join Date
    Nov 2007
    Location
    Denmark
    Posts
    1,149
    Reviews
    Read 0 Reviews

    Ignore Dunamin
    I've tested around a bit and so far have a couple very nitpickery comments:

    • This was mentioned sometime before, I think, but it might be slightly smoother with titles for each section of the sheet written with white text in the black blocks that separate each section. (Basic Attacks, Senses, etc)
    • Under Health, there's a column named "Base HP", which applies fine to the "Hit Points" row but might be a bit misleading with the "Surges" row. Perhaps just rename it to "Base"?
    • Perhaps add a comment at the top, that you can freely add and delete math-free rows without messing up the sheet? Obvious, I know, but I figure being very explicit on instructions could prevent confusion.

  • #15
    Registered User
    Defender (Lvl 8)

    ScorpiusRisk's Avatar

    Join Date
    Jun 2006
    Location
    Roslindale MA 02131
    Posts
    2,499
    Reviews
    Read 0 Reviews

    Ignore ScorpiusRisk
    Ok. I added titles for each. Renamed some stuff because of that. I'd appreciate if someone looked that over for clarity and spelling.

    I moved languages closer to the top. This I think makes the initial filling out of the sheet easier, and should help checkers as well.

    Added to lines to the instructions at the top. I'd like to be clear without being intimidating so if someone wants to check the wording that would be great.
    Current Work: http://stuffershack.com/tag/brian-liberge/

  • #16
    Registered User
    Acolyte (Lvl 2)

    Dunamin's Avatar

    Join Date
    Nov 2007
    Location
    Denmark
    Posts
    1,149
    Reviews
    Read 0 Reviews

    Ignore Dunamin
    Typo: Instruction #5 has mispelled "row" with "low"

    Hmm, how about renaming the first section from "Quick Stats" to "Overview", "Basis" or leave that one without a title? It doesn't really give that much "stats" in terms of numbers, and Quick Stats seems to imply a summarized version of the PC's powers and such - like what you would include in a combat post.

    Otherwise, looks good.

  • #17
    Registered User
    Acolyte (Lvl 2)

    Dunamin's Avatar

    Join Date
    Nov 2007
    Location
    Denmark
    Posts
    1,149
    Reviews
    Read 0 Reviews

    Ignore Dunamin
    Oh, and under Character Background, "Benefit" is mispelled as "Benefeit". (Cell L199)

  • #18
    Registered User
    Defender (Lvl 8)

    ScorpiusRisk's Avatar

    Join Date
    Jun 2006
    Location
    Roslindale MA 02131
    Posts
    2,499
    Reviews
    Read 0 Reviews

    Ignore ScorpiusRisk
    Okie dokie.
    Current Work: http://stuffershack.com/tag/brian-liberge/

  • #19
    Registered User
    Myrmidon (Lvl 10)



    Join Date
    Jan 2002
    Location
    montreal
    Posts
    3,834
    Reviews
    Read 0 Reviews

    Ignore Mal Malenkirk
    Hey, this is promising! Good job.

    I am reasonably handy with Excel though I admit a bit put off by the google presentation.

    I noted the shield bonus isn't adding up. Easy enough to modify on my copy but I can't modify the master copy, right?

    Here's my contribution:

    Use the following line to calculate automatically defenses bases on level and attribute

    Fortitude
    =10+IF(D17>D18,D17,D18)+rounddown(AC11/2,0)

    Where D17 is STR modifier, D18 is CON modifier and AC11 is level.

    Reflex
    =10+IF(D19>D20,D19,D20)+rounddown(AC11/2,0)

    Will
    =10+IF(D21>D22,D21,D22)+rounddown(AC11/2,0)

    With that conditional, you get rid of the need to enter the best attribute modifier and it'll upgrade with level automatically when your stats increase.

    With that line, you get automatically the corect fortitude based on level and the better of Strenght or Constitution. Then you add the other modifiers, of course.

    For armor, you'd need a check mark to indicate if the armor is heavy not.

    =10+IF(*cell with the heavy armor marker*='yes',0,(IF(D19>D20,D19,D20)+rounddown(AC1 1/2,0))

    The most immediate source of improvement I see for this great sheet would be the use of scroll down lists to select class and races. I am sure these list could be used to enter classes and races so that the modifier to those automatically are applied to stats, defenses and skills and so on. That might be a little complex for poor little me, though. The only way that comes to my mind right now is a very lenghty set of conditionals but there are 25 classes and I am pretty sure the formula would end up being too large for the cell (I tried something like that once).
    Last edited by Mal Malenkirk; Sunday, 14th March, 2010 at 07:41 PM.

  • #20
    Registered User
    Minor Trickster (Lvl 4)

    Rapida's Avatar

    Join Date
    Mar 2005
    Location
    Fairfax, Virginia
    Posts
    911
    Reviews
    Read 0 Reviews
    I Defended The Walls!

    Ignore Rapida
    When you say dragdown you mean dropdowns? I don't think google docs support them at the moment.

  • + Log in or register to post
    Page 2 of 10 FirstFirst 12345678910 LastLast

    Similar Threads

    1. Discuss: Redesign wiki character sheets using variables
      By weldon in forum House Rules, Homebrews, & Conversion Library
      Replies: 11
      Last Post: Thursday, 13th May, 2010, 01:41 AM
    2. Proposal: Include Spreadsheets as an alternative to Wiki Sheets
      By ScorpiusRisk in forum Living Eberron
      Replies: 4
      Last Post: Thursday, 6th May, 2010, 07:22 PM
    3. Proposal: Include Spreadsheets as an alternative to Wiki Sheets
      By ScorpiusRisk in forum Living 4th Edition
      Replies: 30
      Last Post: Monday, 5th April, 2010, 11:12 AM
    4. Where are the best place to find modifiable & savable character sheets?
      By Emirikol in forum House Rules, Homebrews, & Conversion Library
      Replies: 10
      Last Post: Monday, 21st January, 2008, 03:55 AM
    5. Where's a good place for character sheets?
      By kaiscomet in forum House Rules, Homebrews, & Conversion Library
      Replies: 8
      Last Post: Thursday, 20th March, 2003, 05:55 PM

    Posting Permissions

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