All Possible Ability Scores for 22 Points

[rrornyll]

Hi all. Long time lurker, first time contributor.

Since Point Buy can be a bit tricky to compute, I created an Excel spreadsheet of all possible 22-point Point Buy ability score "sets". They range from the most concentrated (18, 14, 11, 10, 10, 8, total of 6 pluses) to the least concentrated (14, 14, 13, 13, 13, 11, total of 5 pluses). There are 70 total. I'd post them inside this block, but it would be pretty darn big.

Two caveats: I assume no wasted points, and I assume the base 8 score will not be increased more than any of the base 10 scores. Those two assumptions helped keep it simple.

You people are great. Thanks for sharing your passion for D&D.

edit: Fixed and replaced the attached file.

 

[Argyuile]

Hi all. Long time lurker, first time contributor.

Since Point Buy can be a bit tricky to compute, I created an Excel spreadsheet of all possible 22-point Point Buy ability score "sets". They range from the most concentrated (18, 14, 11, 10, 10, 8, total of 6 pluses) to the least concentrated (14, 14, 13, 13, 13, 11, total of 5 pluses). There are 70 total. I'd post them inside this block, but it would be pretty darn big.

Two caveats: I assume no wasted points, and I assume the base 8 score will not be increased more than any of the base 10 scores. Those two assumptions helped keep it simple.

You people are great. Thanks for sharing your passion for D&D.

That spreadsheat is supercawsome.

 

[Xsjado]

Very useful, should speed things up. Thanks.

 

[GoodKingJayIII]

Thank you!

I've been trying to figure out how to write a formula in Excel that will calculate the point value of any given ability score, unfortunately my Excel skills are not quite that good.

 

[rrornyll]

The spreadsheet I posted is just the results. If you like, I could post the spreadsheet that works out the numbers, but it's actually a mix of calculations and "check formulas" for hand-entered numbers.

For example, I actually entered the point counts on each line (9, 7, 5, etc.) and at the end of the line it says "TRUE" if the total adds up to 22.

A bit kludgy, but much quicker than trying to work out how to do it all automatically. You know, there might even be a few possible ability arrays missing -- I'll leave that as an exercise for the user.

Anyway, I guess I'll add in the original spreadsheet, as soon as I figure out how...

 

[Harshax]

Thank you!

I've been trying to figure out how to write a formula in Excel that will calculate the point value of any given ability score, unfortunately my Excel skills are not quite that good.

Problem is, one score starts at 8, so you have to pay 2 points to bring it to 10 before raising it higher.

But what you can do is something like this:
column A: List attributes STR through CHA
column B: Titled SCORE: Is the desired Ability Score
column C: Titled COST: is the cost [cells C2 through C7]
=INDEX(H:H,MATCH(B2,G:G,0))

then the total cost [cell C8]
=SUM(C2:C7)+IF(MIN(B2:B7)=9,1,IF(MIN(B2:B7)>9,2,0))

column G: range of scores between 9 and 18
column H: range of costs between 0 and 16. [treat scores 9 and 10 as cost 0)

I would upload it, but I don't have Excel with me at the moment.

 

[silentounce]

Hi all. Long time lurker, first time contributor.

Since Point Buy can be a bit tricky to compute, I created an Excel spreadsheet of all possible 22-point Point Buy ability score "sets". They range from the most concentrated (18, 14, 11, 10, 10, 8, total of 6 pluses) to the least concentrated (14, 14, 13, 13, 13, 11, total of 5 pluses). There are 70 total. I'd post them inside this block, but it would be pretty darn big.

Two caveats: I assume no wasted points, and I assume the base 8 score will not be increased more than any of the base 10 scores. Those two assumptions helped keep it simple.

You people are great. Thanks for sharing your passion for D&D.

I'm not sure where you get your "pluses" from. That first group gives a +4, +2, and -1 for +5 total. The second group gives +2, +2, +1, +1, and +1, for a total of +7.

The most you can squeeze out is +8. 14, 14, 14, 14, 10, 10. You can make the last two in that sequence 12, 8, if you like.

 

[Mr Jack]

Given the spread of points added as you level up, I think the total number of stat points is relevant too. On that front, both 14 14 13 13 13 11 and 15 13 13 13 13 11 give 78 stat points, the former giving a pretty decent +7 total start. The worst stat arrays give just 72 points.

 

[Mr Jack]

The most you can squeeze out is +8. 14, 14, 14, 14, 10, 10. You can make the last two in that sequence 12, 8, if you like.

Aye, there's a fair number of variations on that possibility though not all so bland. The sheet reckons there's some on 9, but it's wrong.

 

[AkaKageWarrior]

Thanks for the work!

I added some autmatic point and plus calculation.

and the 26 superhero point-buy for my future campaign!

AKW