Any Excel gurus?

Welcome to the NWN forums!
Post Reply
RR_Texan
Posts: 100
Joined: 06 Sep 2016, 08:38

Any Excel gurus?

Post by RR_Texan » 10 Jun 2018, 08:35

I've been adding all the server specific feats, classes, races, etc to the character builder spreadsheet. I just add the Warlock, Psion, Favored Soul and Shaman. My last ones.

I've got everything working but the ability bonues for these classes. Looking at the spreadsheet it seems to have been coded up as only supporting RDD. Has anyone modified it yet to support the other servers specific classes?

If so maybe you can give me a hint on how you did it? I think we need to match the class name then look up the ability based on the match. I'm just not too good with spreadsheets.

Or if someone has already done all this maybe I can get a copy :)

thanks
david
0 x

User avatar
Sathias
Posts: 1848
Joined: 05 Nov 2015, 16:59
Contact:

Re: Any Excel gurus?

Post by Sathias » 10 Jun 2018, 13:01

I've added a few custom things to mine but not to the extent it sounds like you have. I think you would copy the blank ability bonus columns and paste them to the 6 columns to the right, then edit the ones you copied, if some of the other sheets are any indication. It should be possible according to the Custom Content text file that comes with the spreadsheet.
0 x
"Put the damn gun down, boy. It aint no toy." - Lite

RR_Texan
Posts: 100
Joined: 06 Sep 2016, 08:38

Re: Any Excel gurus?

Post by RR_Texan » 10 Jun 2018, 13:35

I tried that, but the ability bonus portion of the character tab is hard coded to just the RDD in any of the three class option sheets. I'll need to do something a bit smarter to get this to work.

david
0 x

André Axe'm
Posts: 754
Joined: 03 Dec 2015, 16:59

Re: Any Excel gurus?

Post by André Axe'm » 10 Jun 2018, 13:47

Since the ability bonuses are just the Great Ability feats, doesn't just using those work?
0 x

User avatar
Sathias
Posts: 1848
Joined: 05 Nov 2015, 16:59
Contact:

Re: Any Excel gurus?

Post by Sathias » 10 Jun 2018, 14:49

Good point Andre, you could do it with the BonusFeats tab
0 x
"Put the damn gun down, boy. It aint no toy." - Lite

RR_Texan
Posts: 100
Joined: 06 Sep 2016, 08:38

Re: Any Excel gurus?

Post by RR_Texan » 10 Jun 2018, 22:15

I tried that first, using the ClassFeats tab, and it does display it, but it doesn't adjust the ability score. The only place to adjust the ability score is on its tab.
0 x

RR_Texan
Posts: 100
Joined: 06 Sep 2016, 08:38

Re: Any Excel gurus?

Post by RR_Texan » 11 Jun 2018, 05:55

I got it working. Turns out that he had $H$45 so when I inserted more classes the index range didn't change.

I'm sure there are errors, and I've only added elemental warrior for prestige classes.

If anyone would like it let me know and I'll see if I can upload it somewhere.

david
0 x

User avatar
Sathias
Posts: 1848
Joined: 05 Nov 2015, 16:59
Contact:

Re: Any Excel gurus?

Post by Sathias » 11 Jun 2018, 09:10

Yeah I'd be keen! I can put it on my cloud storage for people to download if you like.
0 x
"Put the damn gun down, boy. It aint no toy." - Lite

RR_Texan
Posts: 100
Joined: 06 Sep 2016, 08:38

Re: Any Excel gurus?

Post by RR_Texan » 11 Jun 2018, 11:41

Try this:

https://drive.google.com/open?id=1pWIuV ... fSSaVHWSew

I'm sure there are issues, but it works
0 x

RR_Texan
Posts: 100
Joined: 06 Sep 2016, 08:38

Re: Any Excel gurus?

Post by RR_Texan » 18 Jun 2018, 05:29

OK I found some more issues.

One question. Has anyone figure out what the two columns mean on the Feats tab? It looks like the second column denotes any level limitations for the feat. I think this will enable me to clean this up a bit, as I made separate feats for each of the classes, Shaman, Psion, etc.

I'm not sure exactly what the first column means. I think -1 means you cannot take the feat, 1 means you can, 2 means it is a bonus feat, but I"m not sure. I've not been able to figure out where this information is used. If someone know that would be good and I can clean this up a bit more.

david
0 x

RR_Texan
Posts: 100
Joined: 06 Sep 2016, 08:38

Re: Any Excel gurus?

Post by RR_Texan » 23 Jun 2018, 21:51

OK I figured out the feats tab, and fixed all the Shaman, Psion, etc feats.

https://drive.google.com/open?id=1eWLlx ... ZdOHxVdNl8
0 x

Post Reply