|
Post by heavymetal2000 on Jun 28, 2017 17:14:16 GMT
Totally forgot to pin it. Thanks for the reminder. It's pinned now. Also I have an updated version on my desktop at home ready to be uploaded.
Hopefully over the next few weeks or so I'll have a complete built in character builder that will include gear options to see final stats L40 geared with widgets.
|
|
|
Post by heavymetal2000 on Jun 29, 2017 21:11:08 GMT
Updated the download link. Used tiny upload this time and the link is working atm. If it ever doesn't lmk here.
V3.06 notes
updated the widget sheet to be output only now as well as the class changes with the exception of Enemie HD and gear related intimidate for terrifying rage.
You'll need to select enemy HD in order to get an accurate DC calculation. This DC still needs in game verification as I don't have a barb to test it against. If anyone can do this that would be great.
Updated fighter and puissant widgets again for certain cells returning #Value/Name
Finished adding in updated hard song values
Added a 3T misc sheet to keep track of 3T specific changes as well as other resources for use in the character builder I'm working in within the CBC.
Added a calculations section. This sheet allows you to manually adjust what your final stats and other character related instances will be to forecast L40 "geared" outputs. As of right now you can use the character attributes freely and all class changes/widgets have been modified to incorporate these values. The output cells on this page "blue cells" consider you're initial build and will pull from the original "character" sheet totals.
Build your character first on page 2 "character" then see the "3T calculations" sheet to further sculpt your build.
There is a plethora of other options on the calculations sheet, some working, some in progress and others still untouched. Feel free to experiment. I'll continue updating when more options are complete.
|
|
|
Post by donojono on Jul 13, 2017 17:53:03 GMT
You can use the COUNTIF(AV6:AX46,"Weapon Focus:") it is case sensitive so therefore it is better you must include the colon.
you can also use an if and else statement to return a value such as IF(A1="Weapon Focus:"1,"None") this is the generic formula IF(test, true result, false result) so you can show or return anyvalue you want or point it to a cell with a prepopulated value for the answer.
The good thing I like about if/else statement is you can embed them as long as you like so you can have If If if if else in the same cell to cover 3 values such (weapon focus, Improved Crit, Weapon Specialization) as an exampl returning whichever value you want based on what is the range cell.
|
|
|
Post by heavymetal2000 on Jul 13, 2017 19:01:00 GMT
For puissant I ended up using a countif equation and pointed it at the range of selected feats to avoid nesting a ridiculous amount of IF statements.
It now simply looks for the prefix and counts it without looking for specific weapons.
The data sheet now has a function to look for specific weapons also to decide if you are focused or unfocused.
Got an update soon that simplified a lot, adds in more customization, and is much neater.
Should have it up this week for testing.
The next release will also feature dependent drop downs for weapons and an error box that will inform you if your build is not "legal" as well as explain why.
Anyone interested in messing with the sheets can of course feel free. All the original content as well as the stuff I added is password free. Just unprotect the page and you can see/modify anything within. Just keep in mind that it can and will break things haha.
|
|
|
Post by heavymetal2000 on Aug 1, 2017 17:04:19 GMT
Alright so version 3.07 is available on page 1 today. On top of adding in quite a few extras I cleaned up the "3T Character Build" Page and simplified it. All other calculations/Data is collected and tallied in the 2 separate data pages which you are of course free to look at but try to avoid editing them as it will break the whole thing.
So as I mentioned before. Build your character in the "Character" sheet like you always would. Once you have completed your build here move over to the "3T Character Builder". Here you can pick weapons, shields, and armor as well as widgets, haste and so on. (Not EVERYTHING from NWN is included yet) I'm open to including suggestions of what players would like most from this simply lmk here or via PM)
3.07 Updates -Cleaner Interface for "3T Character Builder" Page. -Added Totalizer for AB and AC on builder page -Updated CoT Changes -Widget Page is complete and should hold the most current and up to date information. (If not lmk what needs to be fixed) -"3T Data, and "3T Calculations Data" are now organized better, moved the majority of the clutter onto these pages. (You can refer to these for specific data on your build.) -Most if not all drop downs should be dependent now -Updated Error Output logs to identify problems in your build and tell you why. -So much more behind the scenes crap and formulas.
Please Enjoy! If you do use this feedback is welcome in all forms. If anything is broken or you notice something is off lmk and I'll fix it.
|
|
|
Post by shufflebottom on Feb 6, 2018 0:20:13 GMT
Could you reupload the 3.07 version please? It seems to have gone.
"File was deleted from server.
File was deleted by owner or exceeded maximum storage time (100 days from last download)."
|
|
|
Post by angryanderson on Mar 17, 2018 18:48:28 GMT
Same message when trying to download here too.
Want to try to figure out what the warrior widget (and ftr belt) will add to AB and damage to the following builds: Monk 20 Ftr 18 Assassin 2 Monk 21 Ftr 18 SD 1 Monk 20 Ftr 19 SD 1 Monk 20 Ftr 18 SD 2
It is the addition to AB I'm most interested in, rather than damage (which would be nice to know too).
|
|
|
Post by angryanderson on Mar 18, 2018 17:38:40 GMT
The fancy formula that looks at Ftr levels, non-ftr levels, are there 10 Druid or SD levels, etc. Is that just for the additional damage calculation, or does it affect the addition to AB too, as if having say a level of SD doesn't affect the widgets impact on AB, that is all I really need to know.
Thanks
|
|
|
Post by jonlun on Mar 18, 2018 18:28:32 GMT
if you have 16 druid or 1 sd, monk doesnt count. It only affects dmg and ac.
|
|
|
Post by spamtastic79 on Apr 17, 2018 19:22:38 GMT
Any luck on getting this file re-uploaded somewhere?
|
|
|
Post by jasconine on Apr 21, 2018 8:12:13 GMT
I'd also love to get my hands on the CBC for 3T if anyone has a copy of it. Please post a link here if you do
- Jasc
|
|
|
Post by shufflebottom on May 10, 2018 15:04:20 GMT
I'm guessing no one still has a copy of this character builder :-(
|
|
|
Post by apecraze on May 10, 2018 15:14:26 GMT
|
|
|
Post by heavymetal2000 on May 18, 2018 14:20:03 GMT
Hey guys. Didn't realize the file was no longer available, which is odd.
I'll re up .07 this evening if I get a chance as it is nicer looking and a bit more functional then .06.
Also I'm always open to adding to it. If there are any changes server side that need to be updated in the CBC let me know here.
Also, if there are things you would like to see added or that are broken lmk here too.
I'll do my best to fix/add what I can.
|
|
|
Post by heavymetal2000 on May 20, 2018 23:00:58 GMT
Uploaded V3.07 again this evening. Just click the link in the opening post.
There are still quite a few things i haven't completed and there may be some glitches haha, but it has more to offer then V3.06 and it's layed out a little better for now.
Now that I'm around again a bit more I'll try to sit down with it and get some more work into it.
|
|