|
Post by heavymetal2000 on Mar 13, 2017 15:36:40 GMT
OK so I've been compiling all the widgets and data that I can for 3t like changes to classes and so on and incorporating it into the nwn CBC project from the NW VAULT. Most recent version will be posted here. 3T CBC V3.06 Clean Macro3T CBC V3.06 Clean No Macro
|
|
|
Post by heavymetal2000 on Mar 13, 2017 15:43:21 GMT
OK so I need the formula to look in the Range of "AV6","AX46" and return how many cells have "weapon focus" on the left side of the Colon and return it as a numerical value. Thanks anyone who can help!
|
|
|
Post by heavymetal2000 on Mar 13, 2017 19:29:56 GMT
OK so I still need some help with that formula guys to get the puissant widget off the ground.
As for right now I'll host a copy of the work in progress so we can start testing it! I encourage you guys to build and report back if you're at all interested. Atm there is a list of all widgets that i know of with a description included.
I included a working Warrior Widget simulator, as well as working Dwarven Wall widget simulator in the 3T widgets Tab to test. I also included so far in the 3T class changes, a working Barbarian Changes table that calculates purity, apr, extra damage etc... It also incorporates the changes to rage and mighty rage and has outputs for duration and amount of hp healed etc... Included a Terrifying Rage simulator also with a DC output based on our current formula. It's hands on so it will require you to use pull down menus to adjust what your end build would be optimally in order to get the DC. This needs testing as i don;t have a 40 terror barb with gear on that i can compare to my results. Lastly There is a BG table that can calculate your harm damage, as well as your cha bonus on Bulls Str etc...
As usual all props for the Base CBC go to Kamyrin of the NWNVault, and all props for the actual widgets and changes here go to the Dev team.
Next updates I'd like to have a working puissant widget, and Re-Scale the bard song in the CBC to match our bards here on 3T. I'll be looking at getting a shifter table in there too when i can. I'll also update the BG summon Table once Chree is done with BG's.
Hope you enjoy. Open to feedback and requests if anyone wants to see some other changes.
|
|
|
Post by heavymetal2000 on Mar 13, 2017 19:49:03 GMT
Some quick notes for using them as i don;t have the pages protected or locked.
Fighter Widget: will draw all of its information from the "Character" Tab so all you need to do is build your character and it will do the rest. The only exception is the Fighter Reward Belt. Once your done building your character select the Widget page and your Warrior Widget will have all the outputs ready. Next to the "Fighter Belt" Cell is a pull down menu you can select Yes/No and it will adjust the output based on if you will be using it or not.
Dwarven Wall Widget: Simple build your character and refer to the widget it for what the Conceal Bonus would be. 100% Automated for your pleasure.
Barbarian Rage/Mighty Rage are 100% automated simply build and refer to the sheet for purity bonus and outcomes. It's kind of broken atm because it refers to the "Character" Sheet con bonus with is capped at 18/+4.
I'll fix that part up tonight and instead put a pull down menu for con bonus and get you a new one asap. outside of that its 100% automated though.
Terrifying Rage requires some manual work, it will self calculate barb levels and HD along with your intimidate and whether you has SF/ESF intimidate. There are pull down menus for Cha modifier and Con modifier as well as intimidate granted from items/feats other then SF/ESF. Simple pull em down adjust the score and the widget does the rest. For an accurate DC read you'll need to manually enter the creatures HD which will allow you to compare the DC based on monster level your facing.
BG Changes are automated and will self calculate
|
|
|
Post by apecraze on Mar 13, 2017 19:51:42 GMT
Could mess around with the SEARCH function (I'm not a great expert either)
=SEARCH("Weapon Focus";AV6) Returns a 1 if there is a plain Weapon Focus Feat on 1st Level in this example
further down for "Epic Weapon Focus" this formula would return a 6 (it Returns the number of the first character of the given string) so you can distinguish
|
|
|
Post by heavymetal2000 on Mar 13, 2017 19:56:47 GMT
OK updated barb rage changes just now instead.
Everything is still the same as above except i added a con modifier pull down menu for barbarian rage changes. (top right) Simply adjust your con modifier there and it will now properly adjust all rages related elements that have con in there formula.
I'll try that out ape, never even thought of that tbh. Tried Vlookup, and some CountIf(S) methods and so far nothing i can use unless i wanna create a *chirp* ton of extra cells. Thanks!
|
|
|
Post by heavymetal2000 on Mar 13, 2017 20:36:00 GMT
my lord... OK another and last update for now. Zero'd the sheet, fixed pull down menus that couldn;t select zero, and added 0's where things were still showing as a bonus.
The barb rage changes will have a few cells that read div/0 errors when your Clvl is zero or you have no barb levels. I'm gonna create a work around for them too. They function properly still though when you do add barb levels on your sheet.
If anyone does use this and finds any more issues just lmk! thanks.
|
|
|
Post by heavymetal2000 on Mar 19, 2017 6:40:31 GMT
OK so I managed to find a formula that will count and compile weapon feats to use in the Puissant widget and I added it in. Now I'm just trying to get more informed on the widget itself so I can incorporate the proper application.
I'll get in touch with thing. Once I confirm a few things the widget will be up and running.
Updated first post with current version
|
|
|
Post by apecraze on Mar 19, 2017 10:07:39 GMT
Great Effort, thanks!
Just a few minor glitches: there are some formulas on 3T class changes sheet that have results in "" quotes thus not doing the calculation but showing the formula as text (for example D9) On Barb DC calculation cell Header for skill focus intimidate read SF Disc
Cant' wait to build my 234th toon with this :-p
|
|
|
Post by heavymetal2000 on Mar 20, 2017 5:25:21 GMT
I'm hoping we can make that dream a reality ape! Haha.
Thanks for the pm and pointing out those issues!
Updated it again this morning.
Replaced a lot of the plain IF statements with IF+AND statements to add some dimension and actually return 0's without breaking EVERYTHING. Places you'll see this now are in the Fighter Widget, barb rage changes across the board, and the dwarven wall widget.
Added in rounddown function to all the cells returning final data in the Fighter Widget, dwarven wall widget and barb rage changes.
Changed esf disc and SF disc in terrifying Rage to intimidate
Added a pull down menu for creature level in terrifying Rage
Fixed up the formula to consider PM levels with fighter Widget
Few other things I can't remember.
Replaced link in first post with the new updated version. I hosted the file via one drive this time on my phone so I'm not sure how it'll work link wise.
Lmk if the download link works, and of course feel free to test it some more and give me feedback if any things broken. I made a few builds with it myself to stress test it a bit.
Hoping to get a functioning puissant widget next update for testing.
Enjoy!
|
|
|
Post by heavymetal2000 on Mar 20, 2017 11:38:54 GMT
Another small update added to what's above.
Puissant widget ready to be tested. Feedback is welcome!
|
|
|
Post by chreelister on Mar 20, 2017 13:19:20 GMT
Great Effort, thanks! Just a few minor glitches: there are some formulas on 3T class changes sheet that have results in "" quotes thus not doing the calculation but showing the formula as text (for example D9) On Barb DC calculation cell Header for skill focus intimidate read SF Disc Cant' wait to build my 234th toon with this :-p They say the 234th time's the charm. Or is it just the third time?
|
|
|
Post by heavymetal2000 on Mar 22, 2017 10:12:27 GMT
New small update.
Fixed broken cells in puissant widget Fixed values and formulas to return zero when necessary and hopefully give the proper calculation. Needs to be tested! Lmk if you can/do.
moved it up with fighter Widget on page and moved the rest down.
Started adding a gear page for those who might like to build theoretical characters right in the CBC.
Uploaded via one drive so lmk if the link works and it's downloadable
|
|
|
Post by heavymetal2000 on Apr 10, 2017 9:24:01 GMT
Update
Revised widgets and added in the most recent ones from the thread here in forums. Included a calculator on the parry widget.
Began working on Shifter changes and included feedback cells to calculate shifter bonuses as well as monk ac bonuses while shifted etc...
Revised the weapons list to be compliant with 3t changes and added a drop down menu in the gear section.
Few other small things.
Should have more to add later this week.
Link is updated feel free to lmk if it works properly.
|
|
|
Post by realzeratul on Jun 28, 2017 16:49:21 GMT
Hey, friendly reminder that this should be stickied as it is great and the most complete overview of current 3T changes I know of and therefore incredibly useful, but also incredibly hard to find.
|
|