|
4 years ago ::
Dec 08, 2008 - 9:38PM
#161
|
Date Joined:
Oct 13, 2008
|
1. Though Dire Radiance is back in the data sheet, it was not added back to the named range so it doesn't show up in the drop down menu. Just a heads up! 2. Also "Ethereal Slide" should be "Ethereal Stride" 3. It would be cool if the "proficiency" field automatically filled in based on your class. This is one of few advantages that this sheet has. 4. Also would be nice if there was a way for Warlocks and Wizards to have a workspace showing attack bonuses for magical attacks with their implements. For example, my wife uses the attack workspace on the other sheet to calculate her CON and CHA based attack bonuses for her Warlock powers. 5. A way to choose pacts for warlocks and builds (like inspiring warlord) would be cool. 6. On the second page, it would be awesome if the big blank column on the right side of the page had all the places to fill in the Role Play stuff like the other sheet has (Portrait, Personality traits, Mannerisms and appearance, Character Background, Companions and Allies, Session Campaign notes). I have no idea how difficult or even possible any of this is, but just thought I'd deliver the feedback! Hope you don't mind! I'm really pushing your sheet as the best one so anything I can do to help, just let me know! That other sheet only has a few functions that yours doesn't!
|
|
|
|
4 years ago ::
Dec 09, 2008 - 4:36AM
#162
|
|
|
3. It would be cool if the "proficiency" field automatically filled in based on your class. This is one of few advantages that this sheet has.
Sandersn's character creator has one major advantage over that sheet: it works perfectly in OpenOffice. Those of us who lack Excel don't have a lot of options; which is a big part of why I'm such a supporter of Ski's work.
|
|
|
|
4 years ago ::
Dec 09, 2008 - 7:26AM
#163
|
Date Joined:
Nov 10, 2004
|
Sandersn's character creator has one major advantage over that sheet: it works perfectly in OpenOffice. Those of us who lack Excel don't have a lot of options; which is a big part of why I'm such a supporter of Ski's work.
Agreed. There are, also, always going to be things that people want, that don't make it. This project is great, and Ski has a lot of support here.
just wanted to throw that in there. 
|
|
|
|
4 years ago ::
Dec 09, 2008 - 8:02AM
#164
|
Date Joined:
Oct 13, 2008
|
Oh let me be clear in that I think Ski's sheet is the best thing there is. I'm just giving my feedback and that of my gaming group. It is in NO way a criticism. These are just my opinions and I realize that there may be perfectly valid reasons that Ski or others may NOT want to implement certain things that others may want.
Luckily I think I've learned enough from messing with his sheet that I've customized it and added some of the things me or my wife needed. Again I'm just trying to be helpful and give feedback (I used to work in QA). I am eternally grateful to Ski for this awesome sheet!
|
|
|
|
4 years ago ::
Dec 22, 2008 - 7:22AM
#165
|
Date Joined:
Sep 10, 2008
|
First of all...best sheet ever. Thanks again for all your work!
I have been changing my copy a little to suit the needs of my group (mostly new players, trying to automate as much as possible for them). I had a few questions for anyone who's better with excel than I (this is not a critique of the sheet, just trying to customize it a bit):
1) Under HPandDef, is there a way to automate the bonus from the toughness feat (5 hp per tier)? I think I can figure out how to get it to do a static addition, but because it ramps up by tier, I'm not sure how to code that ....any ideas? (i.e. if I select toughness, I'd like it to automatically give me 5 bonus hp, then 10 at level 11, 15 at level 21, etc)
2) I'm trying to figure out what to do about two-weapon fighting/two-weapon defense. Obviously these feats are dependant on holding two weapons, and do not give benefit if someone switched to ranged, etc.
A) is there a way to have them give the bonus automatically if you select the feat?
B) if so, could one then change one of the cells on the charsheet1 under AC to display the text "(AC-1) if two weapons are not held
C) if not, the same as B, expect (AC+1) if two weapons held.
(again, inexperienced group, tryint to keep from having people have to remember whenever possible)
3) Feats:
A) How would one set up the bonus feat boxes (Ranger, Human) to draw only from applicable feats? i.e. the ranger box could ONLY bring up toughness/def mobility/whatever the beast equiv is, Human bring up only human qualified feats of heroic tier?
B) How would one set up the level boxes to only draw from applicable feats? (i.e. for the 1/2/4/6/8/10, only draw from heroic tier feats, 11-20 from heroic + paragon, etc)
4) Powers - how would one get the human/half-elf bonus to draw from at-will powers? (currently have to fill it in)
5) Rituals - How does one make a drop down menu for rituals?
6) equip - is there a way to automate:
A) Dwarven weapon training and similar static feats
B) Weapon focus, scalable (i.e. adds 1 at 1-10, 2 at 11-20, etc)
Just some ideas I had for our group, to make it as easy as possible. Any help appreciated.
|
|
|
|
4 years ago ::
Dec 22, 2008 - 7:45AM
#166
|
Date Joined:
Nov 22, 2006
|
First of all...best sheet ever. Thanks again for all your work!
I have been changing my copy a little to suit the needs of my group (mostly new players, trying to automate as much as possible for them). I had a few questions for anyone who's better with excel than I (this is not a critique of the sheet, just trying to customize it a bit):
1) Under HPandDef, is there a way to automate the bonus from the toughness feat (5 hp per tier)? I think I can figure out how to get it to do a static addition, but because it ramps up by tier, I'm not sure how to code that ....any ideas? (i.e. if I select toughness, I'd like it to automatically give me 5 bonus hp, then 10 at level 11, 15 at level 21, etc)
I just now added that feature in. What timing. I know it's been slow, but I blame the holidays. I had to go from Ohio to Georgia, and tomorrow I have to go from Ohio to Kansas. After I get back though, I have a mandatory week off work so I can get some more work done on the sheet.
The way I did it was a simple double comparison. It checked for the presence of Toughness and then, if it was there, it did multiple checks for levels (>1, >10, >20). Not a big deal and I'm glad it will help someone.
2) I'm trying to figure out what to do about two-weapon fighting/two-weapon defense. Obviously these feats are dependant on holding two weapons, and do not give benefit if someone switched to ranged, etc.
A) is there a way to have them give the bonus automatically if you select the feat?
B) if so, could one then change one of the cells on the charsheet1 under AC to display the text "(AC-1) if two weapons are not held
C) if not, the same as B, expect (AC+1) if two weapons held.
(again, inexperienced group, tryint to keep from having people have to remember whenever possible)
I understand what you are saying, and I believe it's theoretically possible... but it would depend on the person creating the character sheet to do some manual checking. I can give them the bonus if they have the feat automatically... or I can give them the bonus if they have a weapon in the first two weapon slots. But it's still up to the person to make sure the two weapons meet the requirements for granting the bonuses.
3) Feats:
A) How would one set up the bonus feat boxes (Ranger, Human) to draw only from applicable feats? i.e. the ranger box could ONLY bring up toughness/def mobility/whatever the beast equiv is, Human bring up only human qualified feats of heroic tier?
B) How would one set up the level boxes to only draw from applicable feats? (i.e. for the 1/2/4/6/8/10, only draw from heroic tier feats, 11-20 from heroic + paragon, etc)
Those are good questions, and I don't have an easy solution to either. Maybe I can add another section of data with those feats and have a smaller list to use. I hate duplicating sections in the data chart, but I can't think of an easier way to split it. I might be able to do it with some kind of macro, but that's a lot of effort.
4) Powers - how would one get the human/half-elf bonus to draw from at-will powers? (currently have to fill it in)
Yeah, I understand what you are saying. I know there's a lot of manual entry still instead of pull-downs. I can look into just an overhaul of all of those manual entry points, but it would take time.
5) Rituals - How does one make a drop down menu for rituals?
That one is easy, but I didn't know people were interested. I can easily add a data ranger of rituals and then just use the standard methods for making the pull-downs. People actually use rituals?
6) equip - is there a way to automate:
A) Dwarven weapon training and similar static feats
B) Weapon focus, scalable (i.e. adds 1 at 1-10, 2 at 11-20, etc)
Just some ideas I had for our group, to make it as easy as possible. Any help appreciated.
The short answer is yes, I can automate all those. The long answer is... I just haven't done the in-depth analysis it would take to find all the bonuses for calculation purposes. It's the same way as Warlock power selection and fighter "techniques". There are so many minor character customization options, I have been letting people add generic/miscellaneous bonuses to represent them. But I agree, that's not automation and it's not simple.
I'll add all of these things to my to-do list (except the first one, because it's already done!).
Ski
|
|
|
|
4 years ago ::
Dec 22, 2008 - 7:50AM
#167
|
Date Joined:
Aug 27, 2007
|
I just now added that feature in. What timing. I know it's been slow, but I blame the holidays. I had to go from Ohio to Georgia, and tomorrow I have to go from Ohio to Kansas. After I get back though, I have a mandatory week off work so I can get some more work done on the sheet.
The way I did it was a simple double comparison. It checked for the presence of Toughness and then, if it was there, it did multiple checks for levels (>1, >10, >20). Not a big deal and I'm glad it will help someone.
I understand what you are saying, and I believe it's theoretically possible... but it would depend on the person creating the character sheet to do some manual checking. I can give them the bonus if they have the feat automatically... or I can give them the bonus if they have a weapon in the first two weapon slots. But it's still up to the person to make sure the two weapons meet the requirements for granting the bonuses.
Those are good questions, and I don't have an easy solution to either. Maybe I can add another section of data with those feats and have a smaller list to use. I hate duplicating sections in the data chart, but I can't think of an easier way to split it. I might be able to do it with some kind of macro, but that's a lot of effort.
Yeah, I understand what you are saying. I know there's a lot of manual entry still instead of pull-downs. I can look into just an overhaul of all of those manual entry points, but it would take time.
That one is easy, but I didn't know people were interested. I can easily add a data ranger of rituals and then just use the standard methods for making the pull-downs. People actually use rituals?
The short answer is yes, I can automate all those. The long answer is... I just haven't done the in-depth analysis it would take to find all the bonuses for calculation purposes. It's the same way as Warlock power selection and fighter "techniques". There are so many minor character customization options, I have been letting people add generic/miscellaneous bonuses to represent them. But I agree, that's not automation and it's not simple.
I'll add all of these things to my to-do list (except the first one, because it's already done!).
Ski
Sanderson You are the man:D :D
|
|
|
|
4 years ago ::
Jan 17, 2009 - 9:14PM
#168
|
|
|
I like sheet also but with the weapon tab, I see green areas for bonuses. I picked 2 feats that affect the weapon bonuses, should be auto added or not? I have Power Attack and Power Charge. On the Character Sheet summary, you a lot of space for feats. Could you add the stats info on the Character sheet?
|
|
|
|
4 years ago ::
Jan 18, 2009 - 7:22AM
#169
|
Date Joined:
Nov 22, 2006
|
I know it's been a while since I posted, but I wanted to give an update on how things are going. I started a version 2.0 of the spreadsheet. I know this slows down the data entry part of the sheet, but I believe the 2.0 version has many many improvements built-in. I don't have to try to work around things because I'm using "lessons learned" from all the previous versions. Some of the improvements: Being able to pick your class's specializations (Ranger two-weapon vs beast master, wizard implements, warlock pacts, etc.). These are auto-populated in a pull-down menu and can be factored into other parts of the character. A good example of this is on the feats tab, which now has a "Class Feat" that is automatically populated (toughness if a ranger picks two-weapons, etc.). This may be minor but the skill sheet now has a simple pull-down YES/NO for trained vs. untrained. This will help new players because typing in "5" to represent a trained skill is not really intuitive. Variable points buy ability. In case your DM lets you built a character with more than 22 points, you can type this in now. This is extremely minor, since you could have just ignored the warnings when you went over 22 points on the old sheet. Removal of "Pre-Requisites" from the feat tab. I know this is a downgrade, but it speeds up data entry and I wasn't really using it for anything. It's a lot of work for the sheet to really check for pre-reqs. Better explanation of calculations, and the automatic inclusion of more and more feats into the final numbers. For example, toughness is factored in based on your level. You'll be able to see anything that affects your AC or to-hit numbers and then choose to fill in the bonuses yourself. Some of it will still be automated, but things that are on/off (such as two-weapon defense) will be listed and you can type in the value. This helps because you used to have to try to figure out what the sheet was automating and what it was missing. Complete overhaul of the DATA tab to make future entry easier and less-likely to miss things. New Card Output. Not much of a change, but it looks a little cleaner to me now. Improved equipment page. It's still a work in progress, but it's better than it was. Something else... something minor... oh yeah! Paragon and Epic stuff finally! :D And, most importantly, more descriptions and instructions. I want to make this the easiest sheet for helping out new players, while still being flexible enough for experienced DMs. Sorry about the delays. I'm working hard on this and hope to have a beta of 2.0 out very very soon. But like Blizzard and Starcraft 2, it'll be done when it's done.
|
|
|
|
4 years ago ::
Jan 22, 2009 - 7:05AM
#170
|
Date Joined:
Nov 22, 2006
|
The early early early beta of Version 2.0 is now available on the website: http://skisgamingresources.blogspot.com/I hesitate to post this, but I want people to comment on the new features that I'm adding. The data for the powers isn't populated, so you can't really play with it too much... but you can see where I'm going with it. You can see the new Item cards, the way I'm incorporating class specializations, and the new flow of character generation. Yesterday I worked extremely hard on getting weapon specializations, weapon focuses, and other modifiers to add up correctly automatically. I had to do some additional calculations regarding weapon focus because they increase as you go up in levels. Please look it over and feel free to comment. There is still a lot of work to be done, but the foundation is there and I hope that you'll be excited about it. Ski
|
|
|
