Kalo's Arelith Build & Gear Calculator (Updated: October 01, 2023)

Discussions related to character builds and mechanics may occur here.

Moderators: Forum Moderators, Active DMs

Kalopsia
General Admin
General Admin
Posts: 1445
Joined: Thu Sep 28, 2017 10:34 am
Location: Concourse Capaneus
Contact:

Re: Kalo's Arelith Build Calculator (CBC Edit)

Post by Kalopsia » Mon Sep 21, 2020 4:51 pm

And here's the update!

Quite a few changes this time, details below:

Code: Select all

New Features:
- Included prospective changes of the upcoming Hexblade rework 
  (see also: http://forum.nwnarelith.com/viewtopic.php?f=23&t=25&start=525#p236473)
- Class level dependent skill bonuses are here: Loremasters, Shadowdancers, Cavaliers and Rogues rejoice!
  Fighters and Spellswords finally get their pureclass Discipline bonus at level 28
  Swashbuckler's panache bonuses are finally working, too!
- Added PDK Fear to the special ability DC calcluations
- Added the Climb skill and relevant class/race bonuses - the related Skill Foci are unavailable for now
- Arelith's 3-level-rule has been added - hopefully this will help new players!

Adjustments:
- Updated races and gifts in line with the most recent updates
- Archer Ranger bonus damage lowered to match the recent balance update
- Ranger/Monks no longer get dual-wield bonus AC - again in line with the recent balance update
- Specialist prerequisite description adjusted: Epic Skill Focus is not a valid prereq feat choice
  Note: I am yet to find a workaround for the dozens of available Skill Foci that can serve as Specialist prerequisites. 
  Unfortunately, you'll need to keep an eye on that yourself, for now.
- Commoner BAB progression fixed. May the powerbuilding begin!

Fixes:
- AB calculation for classes with free Weapon Finesse is now working properly
- Merged Secret Knowledge of Crafting with Secret Knowledge of the Artisan
- (Epic) Skill Focus: Ride is now actually increasing your Ride skill. Promise!
- Corrected a few misaligned hyperlinks
As always, keep the feedback coming guys :)
Have fun!

Kalopsia
General Admin
General Admin
Posts: 1445
Joined: Thu Sep 28, 2017 10:34 am
Location: Concourse Capaneus
Contact:

Re: Kalo's Arelith Build Calculator (CBC Edit)

Post by Kalopsia » Mon Sep 21, 2020 5:09 pm

Curve wrote:
Sun Sep 20, 2020 6:46 pm
It would be awesome if there was an output tab to be able to easily share the build, like on the original.

This is cool, thanks for the work.
Thank you! I've actually included a pretty straightforward way for sharing builds with the sheet: Hyperlinks!
Clicking on the cell titled "Level" in the upper left corner will select all stat- and feat-relevant cells. Press CTRL+C, and you should be able to paste an image file containing all this information in Discord, for example. The result looks like this:

Image

The same thing works for the skill progression. Just click on the cell titled "Skill Points", press CTRL+C and paste the image file in Discord. That's how it looks:

Image

I hope this helps. If people prefer the old output tab, that's fine. I'll try to fix it when I find the time :)

Lewtzy
Posts: 92
Joined: Wed Jan 22, 2020 2:02 pm

Re: Kalo's Arelith Build Calculator (CBC Edit)

Post by Lewtzy » Tue Sep 22, 2020 9:22 am

I never knew :shock:
That's awesome!

Thanks for the updates, can't wait to punch in the numbers :)

Curve
Posts: 549
Joined: Sun Sep 29, 2019 12:47 am

Re: Kalo's Arelith Build Calculator (CBC Edit)

Post by Curve » Tue Sep 22, 2020 2:51 pm

Ooo. I did not know either. Thanks for the heads up, and again all the work.

Lewtzy
Posts: 92
Joined: Wed Jan 22, 2020 2:02 pm

Re: Kalo's Arelith Build Calculator (CBC Edit)

Post by Lewtzy » Tue Sep 22, 2020 11:31 pm

Little thing I noticed, Loremaster only gains 4 "secret knowledge" feats rather than the 5 that the sheet suggests.
At levels: 2,4,6,8.

screenshot of Wiki, (doublechecked on PGCC)
https://i.imgur.com/RrOwAVy.png

Screenshot of sheet:
https://i.imgur.com/GrFGY02.png

Kalopsia
General Admin
General Admin
Posts: 1445
Joined: Thu Sep 28, 2017 10:34 am
Location: Concourse Capaneus
Contact:

Re: Kalo's Arelith Build Calculator (CBC Edit)

Post by Kalopsia » Wed Sep 23, 2020 4:16 pm

Lewtzy wrote:
Tue Sep 22, 2020 11:31 pm
Little thing I noticed, Loremaster only gains 4 "secret knowledge" feats rather than the 5 that the sheet suggests.
At levels: 2,4,6,8.

screenshot of Wiki, (doublechecked on PGCC)
https://i.imgur.com/RrOwAVy.png

Screenshot of sheet:
https://i.imgur.com/GrFGY02.png
Thanks for letting me know! Will be fixed next update.

Anira
Posts: 35
Joined: Fri Nov 24, 2017 3:28 pm
Location: Ireland

Re: Kalo's Arelith Build Calculator (CBC Edit)

Post by Anira » Mon Oct 05, 2020 8:12 am

Kalopsia!

You've just made my day completey with this character builder! I can't tell you what a lifesaver this is as I've been trying to use the original CBC and sheets of paper to make Aerlith characters and driving myself insane!

What a Godsend you are!

Kalopsia
General Admin
General Admin
Posts: 1445
Joined: Thu Sep 28, 2017 10:34 am
Location: Concourse Capaneus
Contact:

Re: Kalo's Arelith Build Calculator (CBC Edit)

Post by Kalopsia » Tue Oct 20, 2020 1:16 pm

Anira wrote:
Mon Oct 05, 2020 8:12 am
Kalopsia!

You've just made my day completey with this character builder! I can't tell you what a lifesaver this is as I've been trying to use the original CBC and sheets of paper to make Aerlith characters and driving myself insane!

What a Godsend you are!
Thanks, it's great to get such positive feedback! <3

On a different note, I've been working on an expansion for the build calculator recently: A gear planner!
You'll be able to see your builds' stats, skills, saves and DCs with whatever gear you input. The sheet will also give subtle recommendations tailored to your builds via dynamic layout changes and can quite reliably predict "hard" 5% dweomercraft rolls as well as item rune requirements.

Image

If you guys have any ideas for more gear calculator features, let me know here!
I'm currently testing this new feature with various builds and gear setups to make sure it's functional when released :)
Last edited by Kalopsia on Tue Oct 20, 2020 2:24 pm, edited 1 time in total.

User avatar
Mattamue
Arelith Silver Supporter
Arelith Silver Supporter
Posts: 468
Joined: Mon Dec 10, 2018 1:45 am

Re: Kalo's Arelith Build Calculator (CBC Edit)

Post by Mattamue » Tue Oct 20, 2020 2:12 pm

Monumental project, kudos for taking it on!

This may already be on your radar, but I suggest you watch things like unisaves carefully. Spellcraft, things like Int adding to SC also, gear Uni, and CoT saves stack up to 20. Feats, racials, stat mods, and divine grace are "hard" and stack over 20. This includes things like school specialization giving saves VS specific types of spells. It all gets very noodle-y. I may even be misunderstanding something.

If you can get this all in one spot and streamlined then I think your efforts would help simplify things for a lot of people.

If you really want to take on a monumental task then I suggest looking into making dweomer coded for soft, hard 5%, and runes. I understand that it's possible using gold value of the item being anything over 10,000 is a hard 5%. Rings have a higher base gold and that's what makes them take a few less dweomers than boots, for example.

This isn't an automatic thing for highlighting dweomer, but here's how I tracked it manually for my own gear:
Image

Who is the audience for this post?


Kalopsia
General Admin
General Admin
Posts: 1445
Joined: Thu Sep 28, 2017 10:34 am
Location: Concourse Capaneus
Contact:

Re: Kalo's Arelith Build Calculator (CBC Edit)

Post by Kalopsia » Tue Oct 20, 2020 2:35 pm

Mattamue wrote:
Tue Oct 20, 2020 2:12 pm
Monumental project, kudos for taking it on!

This may already be on your radar, but I suggest you watch things like unisaves carefully. Spellcraft, things like Int adding to SC also, gear Uni, and CoT saves stack up to 20. Feats, racials, stat mods, and divine grace are "hard" and stack over 20. This includes things like school specialization giving saves VS specific types of spells. It all gets very noodle-y. I may even be misunderstanding something.

If you can get this all in one spot and streamlined then I think your efforts would help simplify things for a lot of people.

If you really want to take on a monumental task then I suggest looking into making dweomer coded for soft, hard 5%, and runes. I understand that it's possible using gold value of the item being anything over 10,000 is a hard 5%. Rings have a higher base gold and that's what makes them take a few less dweomers than boots, for example.
I'm aware of the various caps on item bonuses, yes - it'd be really tough to include all exceptions, though. Gifts and certain server-specific skill bonuses would also count towards the cap and necessitate a lot of changes under the hood - so for now I've settled on just making sure item and buff bonuses don't exceed the +12/+20/+50 caps. However, spellcraft including all stat and item bonuses is being factored into the save cap. I might be able to add an exception for CoT later, too - it's quite easy for them to run into the +20 cap, after all :)

And I've gone for a workaround solution regarding dweomercraft, as it's proven quite difficult to find a reliable formula for NWN's item values. My calculation does not include those for that reason, but rather a system of equations based on common "soft" 5% rolls. It's working fairly accurately so far, but might not be 100% reliable in some cases.

User avatar
NMan7496
Arelith Platinum Supporter
Arelith Platinum Supporter
Posts: 175
Joined: Sat Aug 31, 2019 7:43 pm
Location: Connecticut, USA

Re: Kalo's Arelith Build Calculator (CBC Edit)

Post by NMan7496 » Tue Oct 20, 2020 2:39 pm

This would be really helpful. I've been using a separate spreadsheet that I made for gear (manual inputs except for column sums, so nothing at all complex). It would be really nice to have this all in one spread sheet so you can see the final totals before going through the effort of putting it into PGCC for testing.
Characters:
- Eleanor Allias, Paladin of Selûne

Former:
- Mather Allias, Elrith Ferein, Simone Beregnor-Springscar, Thalia Loreas

Kalopsia
General Admin
General Admin
Posts: 1445
Joined: Thu Sep 28, 2017 10:34 am
Location: Concourse Capaneus
Contact:

Re: Kalo's Arelith Build & Gear Calculator (CBC Edit)

Post by Kalopsia » Sun Nov 01, 2020 3:48 pm

Time's been a bit scarce lately, but here's the big gear calculator update! :)

Detailed changes below:

Code: Select all

New Features:
- Gear Calculator
  (Experimental features include mostly reliable prediction of "hard" 5% rolls, rune requirements and other goodies.)
- Invisible Blade is now available
  (DC calculation will be added soon(tm))
- Feats: Added Climb skill foci

Adjustments:
- Hexblade: Modified the feat prerequisites in line with the recent overhaul
- Shadow Mage: Added alignment limitations, updated prerequisites
- Skills: Renamed Persuade and all related feats to Leadership
- Skills: Renamed Pick Pocket and all related feats to Sleight of Hand
- Misc: Gift dropdown list will now hide "+2" if the ECL doesn't allow for (more) gifts
- Misc: Various usability and layout improvements
  (If you come across any issues, please let me know!)

Fixes:
- Feats: (E)WF: Unarmed is now a valid bonus feat for classes with access to (Epic) Weapon Focus
- Feats: (Epic) Skill Focus now properly increases skills when granted as a bonus feat
- Loremaster: Removed the bonus feat at level 10
- Pale Master: Fixed CL progression and thus caster feat availability
- Specialist: Added Climb skill 
  (If you notice any other classes that should have access to Climb, please let me know!)
- Misc: Fixed displayed spellcasting level; other related changes
If there are any questions about the new Gear Calculator or suggestions for new features/improvements, let me know! :)
Happy building!

User avatar
NMan7496
Arelith Platinum Supporter
Arelith Platinum Supporter
Posts: 175
Joined: Sat Aug 31, 2019 7:43 pm
Location: Connecticut, USA

Re: Kalo's Arelith Build & Gear Calculator (CBC Edit)

Post by NMan7496 » Sun Nov 01, 2020 9:45 pm

Great work! One issue though, Humans can only take one major gift on the calculator, despite being able to take two IG.
Characters:
- Eleanor Allias, Paladin of Selûne

Former:
- Mather Allias, Elrith Ferein, Simone Beregnor-Springscar, Thalia Loreas

User avatar
Jack Oat
Posts: 734
Joined: Mon Sep 08, 2014 3:46 am
Location: The Slanty Shanty

Re: Kalo's Arelith Build & Gear Calculator (CBC Edit)

Post by Jack Oat » Sun Nov 01, 2020 9:55 pm

NMan7496 wrote:
Sun Nov 01, 2020 9:45 pm
Great work! One issue though, Humans can only take one major gift on the calculator, despite being able to take two IG.
Are you certain you aren't using a template (i.e. Tiefling/Aasimar bloodline) where you'd only be able to take 1 gift? I'm not having that issue on my document. Created a Human and was capable of putting on 2 gifts.

"You shall know the truth, and the truth shall make you free."

Garrbear wrote:

quite bluntly we can't balance the server around people who don't play well

Irongron wrote:

My main takeaway from this is that Jack is apparently personable


User avatar
NMan7496
Arelith Platinum Supporter
Arelith Platinum Supporter
Posts: 175
Joined: Sat Aug 31, 2019 7:43 pm
Location: Connecticut, USA

Re: Kalo's Arelith Build & Gear Calculator (CBC Edit)

Post by NMan7496 » Sun Nov 01, 2020 10:30 pm

Image

Worth a double check, but yes, it was base human, no template.
Characters:
- Eleanor Allias, Paladin of Selûne

Former:
- Mather Allias, Elrith Ferein, Simone Beregnor-Springscar, Thalia Loreas

AstralUniverse
Posts: 2723
Joined: Sun Dec 15, 2019 2:54 pm

Re: Kalo's Arelith Build & Gear Calculator (CBC Edit)

Post by AstralUniverse » Mon Nov 02, 2020 3:35 am

-Having that issue as well. Humans can have 1 major gift on the updated CBC (11/2/20)

-Pale Master's spellcasting still excluded. Cannot test wiz/PM builds to see when/where/how many epic spell focuses for example.
Svrtr wrote:

I've spoken with Kenji and warpriest will be allowed to take elemental avatar so keep this in mind too


Kalopsia
General Admin
General Admin
Posts: 1445
Joined: Thu Sep 28, 2017 10:34 am
Location: Concourse Capaneus
Contact:

Re: Kalo's Arelith Build & Gear Calculator (CBC Edit)

Post by Kalopsia » Mon Nov 02, 2020 5:37 pm

I can't replicate the gift issue above. Maybe it's software-specific. Are you guys using Microsoft Excel to open and edit the sheet?

Also, regarding the PM problems: Are you sure your build has access to level 9 spells at the level you're trying to take your first Epic Spell Focus? I'd recommend checking the spells/day section to verify this. Also PMs can't take Epic Spells before PM level 15. Which feat is flagged incorrectly? :)

User avatar
NMan7496
Arelith Platinum Supporter
Arelith Platinum Supporter
Posts: 175
Joined: Sat Aug 31, 2019 7:43 pm
Location: Connecticut, USA

Re: Kalo's Arelith Build & Gear Calculator (CBC Edit)

Post by NMan7496 » Mon Nov 02, 2020 5:39 pm

Kalopsia wrote:
Mon Nov 02, 2020 5:37 pm
I can't replicate the gift issue above. Maybe it's software-specific. Are you guys using Microsoft Excel to open and edit the sheet?
I am using the latest version of Microsoft Excel, yes.
Characters:
- Eleanor Allias, Paladin of Selûne

Former:
- Mather Allias, Elrith Ferein, Simone Beregnor-Springscar, Thalia Loreas

SkipiusEsq
Arelith Platinum Supporter
Arelith Platinum Supporter
Posts: 144
Joined: Wed Feb 06, 2019 2:17 pm

Re: Kalo's Arelith Build & Gear Calculator (CBC Edit)

Post by SkipiusEsq » Mon Nov 02, 2020 7:38 pm

Kalopsia wrote:
Mon Nov 02, 2020 5:37 pm
Also, regarding the PM problems: Are you sure your build has access to level 9 spells at the level you're trying to take your first Epic Spell Focus? I'd recommend checking the spells/day section to verify this. Also PMs can't take Epic Spells before PM level 15. Which feat is flagged incorrectly? :)
I have this issue also - it appears the spreadsheet does not account for PM levels when determining from which circle you may cast. For example, an 11 Wizard, 12 Pale Master can cast level 9 spells (since the PM levels count 1/2 for determining circle). However, in the spreadsheet it only accounts for the 11 Wizard levels (i.e., able to cast 6th level spells).

Since you need to be able to cast 9th level spells for some epic spell feats (e.g., epic foci) they show up as red when selected.

Kalopsia
General Admin
General Admin
Posts: 1445
Joined: Thu Sep 28, 2017 10:34 am
Location: Concourse Capaneus
Contact:

Re: Kalo's Arelith Build & Gear Calculator (CBC Edit)

Post by Kalopsia » Mon Nov 02, 2020 7:54 pm

SkipiusEsq wrote:
Mon Nov 02, 2020 7:38 pm
Kalopsia wrote:
Mon Nov 02, 2020 5:37 pm
Also, regarding the PM problems: Are you sure your build has access to level 9 spells at the level you're trying to take your first Epic Spell Focus? I'd recommend checking the spells/day section to verify this. Also PMs can't take Epic Spells before PM level 15. Which feat is flagged incorrectly? :)
I have this issue also - it appears the spreadsheet does not account for PM levels when determining from which circle you may cast. For example, an 11 Wizard, 12 Pale Master can cast level 9 spells (since the PM levels count 1/2 for determining circle). However, in the spreadsheet it only accounts for the 11 Wizard levels (i.e., able to cast 6th level spells).

Since you need to be able to cast 9th level spells for some epic spell feats (e.g., epic foci) they show up as red when selected.
Thanks for the clarification. I'm quite familiar with the PM progression in that regard, and the recent fix was meant to address that particular issue.
Would you mind sharing a screenshot of a sample PM build with unavailable epic spell foci?

Certain PM builds (Like the popular 11/16/3) unlock 9th circle spells around mid epics, and those builds wouldn't be able to pick Epic Spell Foci until then. The spell slot progression columns are quite easily missed, though, hence the need for additional information to help me replicate and hopefully fix the problem :)

SkipiusEsq
Arelith Platinum Supporter
Arelith Platinum Supporter
Posts: 144
Joined: Wed Feb 06, 2019 2:17 pm

Re: Kalo's Arelith Build & Gear Calculator (CBC Edit)

Post by SkipiusEsq » Mon Nov 02, 2020 8:00 pm

Kalopsia wrote:
Mon Nov 02, 2020 7:54 pm
SkipiusEsq wrote:
Mon Nov 02, 2020 7:38 pm
Kalopsia wrote:
Mon Nov 02, 2020 5:37 pm
Also, regarding the PM problems: Are you sure your build has access to level 9 spells at the level you're trying to take your first Epic Spell Focus? I'd recommend checking the spells/day section to verify this. Also PMs can't take Epic Spells before PM level 15. Which feat is flagged incorrectly? :)
I have this issue also - it appears the spreadsheet does not account for PM levels when determining from which circle you may cast. For example, an 11 Wizard, 12 Pale Master can cast level 9 spells (since the PM levels count 1/2 for determining circle). However, in the spreadsheet it only accounts for the 11 Wizard levels (i.e., able to cast 6th level spells).

Since you need to be able to cast 9th level spells for some epic spell feats (e.g., epic foci) they show up as red when selected.
Thanks for the clarification. I'm quite familiar with the PM progression in that regard, and the recent fix was meant to address that particular issue.
Would you mind sharing a screenshot of a sample PM build with unavailable epic spell foci?

Certain PM builds (Like the popular 11/16/3) unlock 9th circle spells around mid epics, and those builds wouldn't be able to pick Epic Spell Foci until then. The spell slot progression columns are quite easily missed, though, hence the need for additional information to help me replicate and hopefully fix the problem :)
My apologies. The error I had was with a prior version; I didn't realize it was fixed. Just downloaded the new version and can confirm that my error no longer exists. Thanks for the update!

User avatar
Inordinate
Arelith Silver Supporter
Arelith Silver Supporter
Posts: 193
Joined: Fri Dec 30, 2016 5:15 am

Re: Kalo's Arelith Build & Gear Calculator (CBC Edit)

Post by Inordinate » Mon Nov 02, 2020 8:19 pm

I managed to play around with this using a device with Office installed and I was very impressed!

Is there any chance this is being considered to be replicated or converted into Google Docs properly for those who don't have the funds to buy Office for personal use? Work laptops are great but not really a wise use of company resources here :P
If need there comes to shelter my ship on the flood;
The wind I calm upon the waves, and the sea I put to sleep

Kalopsia
General Admin
General Admin
Posts: 1445
Joined: Thu Sep 28, 2017 10:34 am
Location: Concourse Capaneus
Contact:

Re: Kalo's Arelith Build & Gear Calculator (CBC Edit)

Post by Kalopsia » Tue Nov 03, 2020 7:38 pm

Inordinate wrote:
Mon Nov 02, 2020 8:19 pm
I managed to play around with this using a device with Office installed and I was very impressed!

Is there any chance this is being considered to be replicated or converted into Google Docs properly for those who don't have the funds to buy Office for personal use? Work laptops are great but not really a wise use of company resources here :P
Converting the spreadsheet would probably require a significant amount of time, as it makes use of quite a few Excel-specific features and I'm 99% sure a lot of stuff would break in the process.
However, you can install Excel on your smartphone to edit the sheet - that works quite well here. I also think there's a browser-based version of Excel, so that might be an option, too.

User avatar
Ebonstar
Posts: 1471
Joined: Wed Feb 18, 2015 2:17 pm
Location: you may not see me but i see you

Re: Kalo's Arelith Build & Gear Calculator (CBC Edit)

Post by Ebonstar » Thu Nov 05, 2020 2:15 am

you can get free office reading apps that will work

you cannot alter the document but you can read them
Yes I can sign

User avatar
Mattamue
Arelith Silver Supporter
Arelith Silver Supporter
Posts: 468
Joined: Mon Dec 10, 2018 1:45 am

Re: Kalo's Arelith Build & Gear Calculator (CBC Edit)

Post by Mattamue » Thu Nov 05, 2020 2:25 am

I got the human gift error at first, but once you change the fields and come back it works fine.

Who is the audience for this post?


Post Reply