Proposal: Allow Character Builder summary sheets in place of EW templates - Page 12




+ Log in or register to post
Page 12 of 17 FirstFirst ... 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 LastLast
Results 111 to 120 of 168
  1. #111
    Registered User
    Thaumaturgist (Lvl 9)

    evilbob's Avatar

    Join Date
    Jan 2003
    Location
    US
    Posts
    2,485

    Ignore evilbob
    Quote Originally Posted by elecgraystone View Post
    As I recall, it didn't take me very long at first to get the hang of excel when I started but everyone takes to things differently don't we.
    Yup.

    Quote Originally Posted by ScorpiusRisk
    I thought you said it didn't work. I didn't even look at it.
    They actually released a new one today. Still managed to find another small bug, tho.

    More to the point, I also found it doesn't upload to GoogleDocs because it contains too many rows (over 400,000!!!), so unless we joined forces with those guys, it's a non-starter. Also, it doesn't show powers (or it'd be 10x more complex and they'd get sued).

 

  • #112
    Registered User
    Defender (Lvl 8)

    ScorpiusRisk's Avatar

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

    Ignore ScorpiusRisk
    Don't worry about the cost of 8 vs the others. I'll just adjust the formula slightly for the Str row.

    If you can do it for one of the rows I can make the rest work.
    Current Work: http://stuffershack.com/tag/brian-liberge/

  • #113
    Registered User
    Thaumaturgist (Lvl 9)

    evilbob's Avatar

    Join Date
    Jan 2003
    Location
    US
    Posts
    2,485

    Ignore evilbob
    Quote Originally Posted by ScorpiusRisk View Post
    I need a math formula for that.
    Could you just use some kind of array? There aren't that many values. 11 = 1, 12 = 2, 18 = 16 or whatever, etc.

  • #114
    Registered User
    Defender (Lvl 8)

    ScorpiusRisk's Avatar

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

    Ignore ScorpiusRisk
    Yes. . yes I could. I'm sure I could figure that out.

    I'm gonna home now.

    If people are curious, here's what I'm working on now:

    https://spreadsheets.google.com/ccc?...NWU50NlE&hl=en

    EDIT: Word of warning: Green boxes should not be edited! Blue boxes are for numbers only!
    Current Work: http://stuffershack.com/tag/brian-liberge/

  • #115
    Registered User
    Minor Trickster (Lvl 4)

    Phoenix8008's Avatar

    Join Date
    Jan 2002
    Location
    Frostproof, FL
    Posts
    5,290

    Ignore Phoenix8008
    Those google docs look cool. Of course, I like Excel along with elecgraystone.

  • #116
    Well, it's rather long to do it with 8 and 9 but this works... it's more or less 'if starting is 10 and you spend 0 your total is 0, if starting is 10 and you spend 1 your total is 11, ect'. A pain in the butt to type out but once done it should just be a matter of swapping out the B3 and C3 in the formula with the actual cells and pasting it into the target cell. Also n/a can be replaced with whatever message you wish.

    B3 is starting stat
    C3 is points spent
    It'll pop out an n/a if you put in a points spent total that doesn't work.


    formula
    =IF(B3=10,IF((C3=0),10,IF((C3=1),11,IF((C3=2),12,I F((C3=3),13,IF((C3=4),"invalid",IF((C3=5),14,IF((C 3=6),"invalid",IF((C3=7),15,IF((C3=8),"invalid",IF ((C3=9),16,IF((C3=10),"invalid",IF((C3=11),"invali d",IF((C3=12),17,IF((C3=13),"invalid",IF((C3=14)," invalid",IF((C3=15),"invalid",IF((C3=16),18,"inval id"))))))))))))))))),(IF(B3=8,IF((C3=0),8,IF((C3=1 ),9,IF((C3=2),10,IF((C3=3),11,IF((C3=4),12,IF((C3= 5),13,IF((C3=6),"invalid",IF((C3=7),14,IF((C3=8)," invalid",IF((C3=9),15,IF((C3=10),"invalid",IF((C3= 11),16,IF((C3=12),"invalid",IF((C3=13),"invalid",I F((C3=14),17,IF((C3=15),"invalid",IF((C3=16),"inva lid",IF(C3=17,"invalid",IF(C3=18,18,"invalid"))))) )))))))))))))))))
    Last edited by elecgraystone; Saturday, 27th February, 2010 at 04:01 AM.

  • #117
    Spawn of Khyber/LEB Judge
    Enchanter (Lvl 12)

    stonegod's Avatar

    Join Date
    Sep 2005
    Location
    Starkville, MS
    Posts
    12,534
    Blog Entries
    10

    Ignore stonegod
    elec: Can you wrap that in a CODE or SBLOCK so it doesn't stretch the page so.

    Any spreadsheet should have the goal of helping with the math, but not replicating all of the books (like the dnd4 sheet does). That way lies madness and continuous update. We want something to help do verification, but doesn't have to have a lot of fiddly conditions. (Example: Just let them choose what stat does basic attacks, though default to Str/Dex. SImilar for defenses).
    stonegod -- LEB judge and spawn of Khyber since 2005 (Blog)

    My many characters | LEB Games | EtCR |Rise of a Demon Prince Story Hour

    "You be evil stonegod" -- Bront

  • #118
    Spawn of Khyber/LEB Judge
    Enchanter (Lvl 12)

    stonegod's Avatar

    Join Date
    Sep 2005
    Location
    Starkville, MS
    Posts
    12,534
    Blog Entries
    10

    Ignore stonegod
    SC: the sheet is also making the same error the L4W template did in the powers: Assuming a common layout. The is a fallacy, with many powers having many riders (Secondary or Tertariy attacks, multiple Effects in a certain order, or summoning, different weapons/implements). The LEB approach is likely better here (just let them give numbers and add the corallaries), or just do the math part here.
    stonegod -- LEB judge and spawn of Khyber since 2005 (Blog)

    My many characters | LEB Games | EtCR |Rise of a Demon Prince Story Hour

    "You be evil stonegod" -- Bront

  • #119
    I'm not sure I understand stonegod. It's formatted just like always on my screen. Not that i mind an sblock, just not sure I understand the issue.

    EDIT: Done

    I think the best thing is just have the blank power chart have all all the riders and you just delete what you don't need. The only places you need any math are the attack and damage sections. A section like our sheets now could do the trick and it'd require a lot less maintenance.
    Last edited by elecgraystone; Saturday, 27th February, 2010 at 02:18 AM.

  • #120
    Spawn of Khyber/LEB Judge
    Enchanter (Lvl 12)

    stonegod's Avatar

    Join Date
    Sep 2005
    Location
    Starkville, MS
    Posts
    12,534
    Blog Entries
    10

    Ignore stonegod
    As it's all one line, it's stretched all entries on the page to at least 3x their normal width. I have to scroll Horizontally to read entries, esp on my phone.
    stonegod -- LEB judge and spawn of Khyber since 2005 (Blog)

    My many characters | LEB Games | EtCR |Rise of a Demon Prince Story Hour

    "You be evil stonegod" -- Bront

  • + Log in or register to post
    Page 12 of 17 FirstFirst ... 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 LastLast

    Similar Threads

    1. proposal: not require summaries on character sheets
      By evilbob in forum House Rules, Homebrews, & Conversion Library
      Replies: 11
      Last Post: Monday, 26th April, 2010, 05:50 PM
    2. Any other DDI Character Builder Sheet Templates?
      By mshea in forum D&D and Pathfinder
      Replies: 25
      Last Post: Thursday, 4th February, 2010, 11:23 PM
    3. Custom character sheets for DDI char builder?
      By beverson in forum House Rules, Homebrews, & Conversion Library
      Replies: 13
      Last Post: Monday, 25th May, 2009, 11:06 PM
    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
    •