CHARACTER BUILD CREATOR Excel spreadsheet - highly recommended!

Go down

CHARACTER BUILD CREATOR Excel spreadsheet - highly recommended!

Post by Ramana Jala on Tue Jul 03, 2012 12:48 pm



At the NWN Vault, one can find two very handy Character Build Spreadsheets created by Kamiryn, which I have found indispensable and am always recommending to everyone:



FOR NWN 1:

The CharacterBuildCalculator is an Excel Sheet that allows you to create builds very fast and easily. You just select your race, your class (or classes) and the order of leveling. Then the CBC calculates at which level you gain a feat (regular/bonus) and what class feats you get. Also the CBC calculates your hitpoints, your BAB, your attacks/round, your saving throws, skill points, spell casting, bard song and many more things. Finally the CBC generates a text output of your build ready to post everywhere you like.

The CBC covers races (feats, skill points, ability modifiers), hitpoints (constitution bonus, toughness, epic toughness), BAB, attacks/round, feats (regular, bonus, class, feat prequisites), saving throws (CON/DEX/WIS modifiers, feats), skill point selection (forbidden skills, cross-class skills, class skills) bonus skill points (human, INT modifier).


Character Build Creator for NWN1



FOR NWN 2:

The CharacterBuildCalculator for NWN2 (CBC2) is an Excel Sheet that allows to create character builds for NWN2 fast and easily. You just select your (sub)race, your class (or classes) and the order in which you want your character to level-up. Then the CBC2 tells you at which level your character gains a feat (regular/bonus) and what class feats you get. Also the CBC2 calculates yor BAB, number of attacks, hitpoints, saving throws and skillpoints.

If you take a feat or if you advance in a prestige class the CBC2 tells you if you actually are allowed to do that. And if not it tells you what's required to take the feat/class.


Character Build Creator for NWN2



And, I have found that if I Unprotect the spreadsheet temporarily, I can enter Attribute Points obtained from Tomes (inserted at the level where they were gained) or Stat Buys. Thus from that point onward in the spreadsheet, related skills and characteristics will be properly calculated.



avatar
Ramana Jala
Epic Level
Epic Level

Female Number of posts : 1032
Location : Earth, Sol system, in the Mutter's Spiral galaxy
Main Character : Ramana Domefarar -
Publicly a Ranger, privately an Opportunist.
Lay Follower of Jewel,
Sensate and practitioner of the Way of Pleasure.

Other Character : Ranara Duauth -
A being created by shadow and water, a wizard.
Is actually another persona of Ramana.

Other Character. : Dae, the panther,
companion to both Ramana and Ranara,
and the best real eye-witness to the
strange circumstance of those alternating personae.

Other Character.. : The Personae of Ramana Jala
NWN Username : Ramana Jala
Time Zone : US Eastern Time
Registration date : 2011-08-29

View user profile

Back to top Go down

Re: CHARACTER BUILD CREATOR Excel spreadsheet - highly recommended!

Post by Eric of Atrophy on Wed Jul 18, 2012 4:41 pm

Nice find! Thanks for the recommend!
avatar
Eric of Atrophy
Seriously Epic Level
Seriously Epic Level

. : Dungeon Master
Male Number of posts : 3881
Age : 45
Location : Hollidaysburg, PA, USA
Main Character : The Vault of Atrophy
NWN Username : atrophied_eric
DM Name : Dungeon Mistress Anaurra Lide
Time Zone : GMT - 05:00 EST
Registration date : 2008-06-06

View user profile http://myanimelist.net/profile/Eric_of_Atrophy

Back to top Go down

Re: CHARACTER BUILD CREATOR Excel spreadsheet - highly recommended!

Post by plane_abe on Sun Sep 23, 2012 1:38 pm

I can't get it to work... How do I do this stuff Question
confused
avatar
plane_abe
Prolific Scribe
Prolific Scribe

Male Number of posts : 59
Age : 20
Location : Hollidaysburg :P
Main Character : Ivellios Galonodel + Flash
Other Character : Xanaphia Galonodel
NWN Username : plane_abe
Registration date : 2010-12-04

View user profile

Back to top Go down

Re: CHARACTER BUILD CREATOR Excel spreadsheet - highly recommended!

Post by Eric of Atrophy on Sun Sep 23, 2012 4:09 pm

Get a non-crappy laptop. Twisted Evil
avatar
Eric of Atrophy
Seriously Epic Level
Seriously Epic Level

. : Dungeon Master
Male Number of posts : 3881
Age : 45
Location : Hollidaysburg, PA, USA
Main Character : The Vault of Atrophy
NWN Username : atrophied_eric
DM Name : Dungeon Mistress Anaurra Lide
Time Zone : GMT - 05:00 EST
Registration date : 2008-06-06

View user profile http://myanimelist.net/profile/Eric_of_Atrophy

Back to top Go down

Re: CHARACTER BUILD CREATOR Excel spreadsheet - highly recommended!

Post by Ramana Jala on Sun Sep 23, 2012 5:45 pm

Well, first you have to have a program that will open Excel spreadsheets, like MicroSoft Office Excel, or maybe OpenOffice's spreadsheet version. Then you have to know how to use the spreadsheet program, which if you Google how to use Excel, you'll get lots of help.

After that, you'll have to be more specific as to at which point it's not working for you, in order for me to know how to answer your question.


avatar
Ramana Jala
Epic Level
Epic Level

Female Number of posts : 1032
Location : Earth, Sol system, in the Mutter's Spiral galaxy
Main Character : Ramana Domefarar -
Publicly a Ranger, privately an Opportunist.
Lay Follower of Jewel,
Sensate and practitioner of the Way of Pleasure.

Other Character : Ranara Duauth -
A being created by shadow and water, a wizard.
Is actually another persona of Ramana.

Other Character. : Dae, the panther,
companion to both Ramana and Ranara,
and the best real eye-witness to the
strange circumstance of those alternating personae.

Other Character.. : The Personae of Ramana Jala
NWN Username : Ramana Jala
Time Zone : US Eastern Time
Registration date : 2011-08-29

View user profile

Back to top Go down

Re: CHARACTER BUILD CREATOR Excel spreadsheet - highly recommended!

Post by RustyDios on Tue Oct 09, 2012 6:15 pm

The only problem I have with the CBC is it doesn't cover all the Aenean stat buys/ re-level/ re-incarnation/ascension/custom race modifiers/ custom classes/ custom cleric "domain powers"/ custom feats and Aenean Abilities... or is there a way to put all that data into it ?
avatar
RustyDios
High Epic Level
High Epic Level

Male Number of posts : 2268
Age : 34
Location : England // Getting lost in Aenea
Main Character : Jay Braysin, The Wandering Shadow, Protector of Nektaria, Talon's Eternal Foe
Other Character : Shouri Braysin, The Shimmerstar's Moonlight Sorceress
Other Character. : Grace Fularras, Walking Library , Cleric of Mystara
Other Character.. : See my sig ... And here too ...
NWN Username : RustyDios
Time Zone : GMT (England, DST)
. :
Registration date : 2008-07-28

View user profile

Back to top Go down

Re: CHARACTER BUILD CREATOR Excel spreadsheet - highly recommended!

Post by Angel of Death on Tue Oct 09, 2012 9:44 pm

RustyDios wrote:The only problem I have with the CBC is it doesn't cover all the Aenean stat buys/ re-level/ re-incarnation/ascension/custom race modifiers/ custom classes/ custom cleric "domain powers"/ custom feats and Aenean Abilities... or is there a way to put all that data into it ?

You can manually edit it with excel (either Microsoft's or Open Office or some other excel program) to include all that.
avatar
Angel of Death
Epic Level
Epic Level

Number of posts : 1131
Age : 403
Location : Europe
Main Character : CÚlestin Chevalier; Knight Champion of Dalix. Protector of the Innocent. Slayer of Evil.
Other Character : Angelique Nightstar; Arcane Archer.
Personal Quote: "The way of the bow is simplicity and beauty combined with power and discipline."
Other Character. : Bruce Li; Wanderer and Practitioner of the Dragon Paw Style. & Cherry; Starchild of Jewel n' Chancetaker of Lysis.
Other Character.. : Anna, Weaver of Illusions. - You can read about all of them following this link to their Biographies! =)
NWN Username : I await You in the End
Time Zone : Central European Timezone
Registration date : 2010-12-11

View user profile

Back to top Go down

Re: CHARACTER BUILD CREATOR Excel spreadsheet - highly recommended!

Post by Ramana Jala on Wed Oct 10, 2012 8:18 am

Ramana Jala wrote:
And, I have found that if I Unprotect the spreadsheet temporarily, I can enter Attribute Points obtained from Tomes (inserted at the level where they were gained) or Stat Buys. Thus from that point onward in the spreadsheet, related skills and characteristics will be properly calculated.

You already have to have Excel or Open Office to even open the spreadsheet. To Unprotect, go up to the menu Tools>Protection>Unprotect Sheet. When it's Unprotected, any field can be edited. For numerical data, the spreadsheet will take the new info into account to calculate from that point on. I would suggest reactivating the Protect Sheet after you've made your changes.

For a rebuild, add the stats into the attribute fields at character Level 2.

Special Aenea feats can be typed into any feat field. Of course the calculator can't understand what that special feat comprises and compute any results from it, but it can be entered. I've done that, although I wasn't entering a feat that would have affected anything else. You can probably Unprotect and tweak the related numerical fields to compensate, though. Probably the same for custom domains and all the rest.

avatar
Ramana Jala
Epic Level
Epic Level

Female Number of posts : 1032
Location : Earth, Sol system, in the Mutter's Spiral galaxy
Main Character : Ramana Domefarar -
Publicly a Ranger, privately an Opportunist.
Lay Follower of Jewel,
Sensate and practitioner of the Way of Pleasure.

Other Character : Ranara Duauth -
A being created by shadow and water, a wizard.
Is actually another persona of Ramana.

Other Character. : Dae, the panther,
companion to both Ramana and Ranara,
and the best real eye-witness to the
strange circumstance of those alternating personae.

Other Character.. : The Personae of Ramana Jala
NWN Username : Ramana Jala
Time Zone : US Eastern Time
Registration date : 2011-08-29

View user profile

Back to top Go down

Re: CHARACTER BUILD CREATOR Excel spreadsheet - highly recommended!

Post by RustyDios on Wed Oct 10, 2012 10:57 am

I was reading through the Custom Addition Readme that comes with the download, and I think that absolutely everything "Aenean" could be added to the various sheets calculations (possibly in full) with some time and effort to make an Aenean Character Build Creator .. Maybe it will become one of the basic tools used for creation of Aenean Characters.......
...... the Aenean Build Calculator... the ABC of all Aenean's PC's.....

.... I might start working on that as I side project (one that I could get away with in work too Smile )... needed an excuse to learn a bit about Excel Spreadsheets....
avatar
RustyDios
High Epic Level
High Epic Level

Male Number of posts : 2268
Age : 34
Location : England // Getting lost in Aenea
Main Character : Jay Braysin, The Wandering Shadow, Protector of Nektaria, Talon's Eternal Foe
Other Character : Shouri Braysin, The Shimmerstar's Moonlight Sorceress
Other Character. : Grace Fularras, Walking Library , Cleric of Mystara
Other Character.. : See my sig ... And here too ...
NWN Username : RustyDios
Time Zone : GMT (England, DST)
. :
Registration date : 2008-07-28

View user profile

Back to top Go down

Re: CHARACTER BUILD CREATOR Excel spreadsheet - highly recommended!

Post by Angel of Death on Wed Oct 10, 2012 11:56 am

RustyDios wrote:...... the Aenean Build Calculator... the ABC of all Aenean's PC's.....

lol!
That's funny!
avatar
Angel of Death
Epic Level
Epic Level

Number of posts : 1131
Age : 403
Location : Europe
Main Character : CÚlestin Chevalier; Knight Champion of Dalix. Protector of the Innocent. Slayer of Evil.
Other Character : Angelique Nightstar; Arcane Archer.
Personal Quote: "The way of the bow is simplicity and beauty combined with power and discipline."
Other Character. : Bruce Li; Wanderer and Practitioner of the Dragon Paw Style. & Cherry; Starchild of Jewel n' Chancetaker of Lysis.
Other Character.. : Anna, Weaver of Illusions. - You can read about all of them following this link to their Biographies! =)
NWN Username : I await You in the End
Time Zone : Central European Timezone
Registration date : 2010-12-11

View user profile

Back to top Go down

Re: CHARACTER BUILD CREATOR Excel spreadsheet - highly recommended!

Post by Ramana Jala on Wed Oct 10, 2012 12:10 pm

RustyDios wrote:I was reading through the Custom Addition Readme that comes with the download, and I think that absolutely everything "Aenean" could be added to the various sheets calculations (possibly in full) with some time and effort to make an Aenean Character Build Creator .. Maybe it will become one of the basic tools used for creation of Aenean Characters.......
...... the Aenean Build Calculator... the ABC of all Aenean's PC's.....

.... I might start working on that as I side project (one that I could get away with in work too Smile )... needed an excuse to learn a bit about Excel Spreadsheets....

That would be an extremely useful application for Aeneans! Thanks for looking into that, Rusty!

avatar
Ramana Jala
Epic Level
Epic Level

Female Number of posts : 1032
Location : Earth, Sol system, in the Mutter's Spiral galaxy
Main Character : Ramana Domefarar -
Publicly a Ranger, privately an Opportunist.
Lay Follower of Jewel,
Sensate and practitioner of the Way of Pleasure.

Other Character : Ranara Duauth -
A being created by shadow and water, a wizard.
Is actually another persona of Ramana.

Other Character. : Dae, the panther,
companion to both Ramana and Ranara,
and the best real eye-witness to the
strange circumstance of those alternating personae.

Other Character.. : The Personae of Ramana Jala
NWN Username : Ramana Jala
Time Zone : US Eastern Time
Registration date : 2011-08-29

View user profile

Back to top Go down

Re: CHARACTER BUILD CREATOR Excel spreadsheet - highly recommended!

Post by Eric of Atrophy on Wed Oct 10, 2012 4:53 pm

Absolutely it would! And of course, you'd want to distribute the Aenean version of that if you did it, amirite? Laughing I'd love to have a copy if you do so!
avatar
Eric of Atrophy
Seriously Epic Level
Seriously Epic Level

. : Dungeon Master
Male Number of posts : 3881
Age : 45
Location : Hollidaysburg, PA, USA
Main Character : The Vault of Atrophy
NWN Username : atrophied_eric
DM Name : Dungeon Mistress Anaurra Lide
Time Zone : GMT - 05:00 EST
Registration date : 2008-06-06

View user profile http://myanimelist.net/profile/Eric_of_Atrophy

Back to top Go down

Re: CHARACTER BUILD CREATOR Excel spreadsheet - highly recommended!

Post by Belarric on Wed Oct 10, 2012 5:43 pm

What a cool idea
I use Kamiryns CBC (character creator) all the time, its a great tool

And it sounds as though Rusty's ABC will see as much use as the CBC Smile
avatar
Belarric
Seasoned Explorer
Seasoned Explorer

Male Number of posts : 157
Age : 59
Location : Christchurch, New Zealand
Main Character : Raiden - A warrior monk searches for knowledge in the arts of war
Other Character : Darrius - Shadow Child
Other Character. : Wolfe - A dragon tainted barbarian from the high mountains
Time Zone : GMT + 12:00
. :
Registration date : 2011-10-30

View user profile

Back to top Go down

Re: CHARACTER BUILD CREATOR Excel spreadsheet - highly recommended!

Post by Sponsored content


Sponsored content


Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum