|
5 years ago ::
Jul 27, 2008 - 11:52PM
#51
|
Date Joined:
Jul 14, 2008
|
I'm not trying to start a flamewar, but I'm not really sure what generated this post. I'm not trying to push my character sheet on anyone and I don't see any reason to try to force my way into a "stickied" thread. This all started with someone asking for help, which I offered with a disclaimer saying that I was doing this for my play group and maybe someone else would find it helpful.
It's not a competition. I've only kept this thread alive because some very helpful people have told me about bugs, asked for new features, and so on.
As for the question about feats being done, I've been working on that this weekend. I picked up Improved Initiative on my own character, so I guess that makes feats a little higher of a priority to me.
I'll look more into that warlock bug. I had a friend of mine that ran into a similar issue with it printing "N/A" for certain powers of his. Maybe his was related to yours.
I do apologize about being slow at fully populating the data for powers and feats though. It's just so time consuming to copy from the book into the spreadsheet, and my mind is prone to wandering. That's another reason I wouldn't post this in the stickied thread... people might expect me to work harder on it.
Ski
Don't apologize. You are doing an awesome job. I've already prepared 6 characters with this in no time. It's incredibly user friendly.
It has really helped my friend who has just started playing. He understands what everything on the character sheet thanks to this.
|
|
|
|
5 years ago ::
Jul 28, 2008 - 8:16AM
#52
|
Date Joined:
Aug 27, 2007
|
No offence meant, was aimed mostly at the original poster, just pointing out that there's a megathread where everyone's posted their character sheet/generators. I wasn't trying to say that you shouldn't support your writing/get feedback at all.
Good luck with your sheet, mate
Your encounter stuff saves me a ton. But his char sheet is great :D
|
|
|
|
5 years ago ::
Jul 28, 2008 - 10:53AM
#53
|
Date Joined:
Nov 22, 2006
|
Version 0.9 is up and available for download. It includes some relatively important changes regarding feats. Certain feats give bonuses to skills or attributes such as initiative or number of healing surges per day. What I've done is I've incorporated all those Heroic level feats into the skills and HPandDef calculations pages. Ski's4thEdCharGenI plan on doing the same with Paragon tier feats as I have time, but some of them are slightly more complicated (such as the armor specialization feats). I'll continue to work on it throughout the week. I hate to keep putting out small incremental changes like this because I know that some of you are having to re-type your characters each time I put out a new version. I don't know how to get around that though. I think I've double checked to make sure the CharSheets are still importing the right cells after I shifted some things around, but it's possible I missed one or two. Please let me know if you spot any errors.
|
|
|
|
5 years ago ::
Jul 28, 2008 - 2:04PM
#54
|
Date Joined:
Jul 11, 2008
|
I hate to keep putting out small incremental changes like this because I know that some of you are having to re-type your characters each time I put out a new version. I don't know how to get around that though.
Keep doing it how you're doing it. It identifies the sheet as a living document to have many small updates. Otherwise folks would wonder whether you had abandoned it or were working on a big update. Small ones also make it easier for others to spot-check, and you get a typo every once in a while instead of a bunch swarming you at a time.
Anyone using it for their character has probably found workarounds for where yours was lacking (feats affecting the worksheet for example). If they update every time you do, instead of when a truly big improvement for them comes out that's silly.
Some parts of the sheet that are pending just seem to be lists. Do you want to keep this as fully your work, or if others have free time would you like for them to work on filling those out?
|
|
|
|
5 years ago ::
Jul 29, 2008 - 12:26AM
#55
|
Date Joined:
Jul 14, 2008
|
Version 0.9 is up and available for download. It includes some relatively important changes regarding feats.
Certain feats give bonuses to skills or attributes such as initiative or number of healing surges per day. What I've done is I've incorporated all those Heroic level feats into the skills and HPandDef calculations pages.
Ski's4thEdCharGen
I plan on doing the same with Paragon tier feats as I have time, but some of them are slightly more complicated (such as the armor specialization feats). I'll continue to work on it throughout the week.
I hate to keep putting out small incremental changes like this because I know that some of you are having to re-type your characters each time I put out a new version. I don't know how to get around that though.
I think I've double checked to make sure the CharSheets are still importing the right cells after I shifted some things around, but it's possible I missed one or two. Please let me know if you spot any errors.
It really takes no time to retype it over. You are doing great.
|
|
|
|
5 years ago ::
Jul 29, 2008 - 12:57AM
#56
|
|
|
I would love you forever and ever if you could add some of the MM racesto that sheet. It's not as pretty as some, but damn if it doesn't save me time when I need to cobble something together.
|
|
|
|
5 years ago ::
Jul 29, 2008 - 8:15AM
#57
|
Date Joined:
Jul 13, 2007
|
The people that put together Hero Forge have always made great stuff. They already have an interactive Excell spread sheet that takes a bit of a learning curve. Once you got the hang of it, however, the design is really easy to use.
http://www.nzcomputers.net/heroforge/default4e.asp
I second this recommendation. This is by far the best modifiable character sheet I've seen.
Great job on your effort so far, sandersn! I'd put your work just behind the stuff Matthias Schaefer has made. I really like the layout and flow of your sheet. It's very easy to follow and it makes logical sense.
|
|
|
|
5 years ago ::
Jul 30, 2008 - 12:41PM
#58
|
|
|
Yeah, I can understand why it takes awhile to update. That's a lot of data to input. Especially for the cards.
As for bugs/mistakes/whatever, I noticed that Toughness does not automatically add the hitpoints. No big deal, I just use the "Notes" and "Other Modifiers" to track it, but I figured you'd want to know. Not sure how hard it is to make sure it scales to the tiers, either.
Again, thanks for the hard work! Anyone want to take bets on whether sandersn completes his character sheet before the Insider Character Builder is ready? :D
|
|
|
|
5 years ago ::
Jul 31, 2008 - 9:57AM
#59
|
|
|
Oh, another bug find for sandersn.
On the CardOutput page, the first column's 3rd row is off. If you pick something past row 563 on the datapage (which is through the Warlock's Eyebite), then it will give the ol' N/A instead of the Action type, etc. Works fine for the 2nd column. I found it because I was completing the Warlord and Wizard data in my copy and found the discrepency when I checked my work. Anyway, thought you would like to know.
The offending formula is =IF(A1="","",VLOOKUP(A1,Data!$A$493:$BB$563,29,0)) I'm guessing (because I'm not a spreadsheet guru and most of this is Greek to me) that it needs to read =IF(A1="","",VLOOKUP(A1,Data!$A$493:$BB$609,29,0)).
|
|
|
|
5 years ago ::
Jul 31, 2008 - 11:39AM
#60
|
Date Joined:
Nov 22, 2006
|
Oh, another bug find for sandersn.
On the CardOutput page, the first column's 3rd row is off. If you pick something past row 563 on the datapage (which is through the Warlock's Eyebite), then it will give the ol' N/A instead of the Action type, etc. Works fine for the 2nd column. I found it because I was completing the Warlord and Wizard data in my copy and found the discrepency when I checked my work. Anyway, thought you would like to know.
The offending formula is =IF(A1="","",VLOOKUP(A1,Data!$A$493:$BB$563,29,0)) I'm guessing (because I'm not a spreadsheet guru and most of this is Greek to me) that it needs to read =IF(A1="","",VLOOKUP(A1,Data!$A$493:$BB$609,29,0)).
You are absolutely right and I thought I had caught all those mistakes already. I introduced them (somehow) when I added in placeholders for a lot of the powers. Then I fixed them in some parts of the Card Output, but not in all of them. I apologize and I'll upload the fix ASAP.
As for working this as a team, I'm all for it. I'm not sure how I can coordinate data entry volunteers, but there has to be some easy mechanism for it. Maybe people just volunteer for a certain class's powersets, etc., and then I just import them into the master. I dunno.
Anyway, thanks again for the encouragement and the comments. I'll continue to work on this as long as I feel it's helping people.
Ski
|
|
|
