|
Post by starlandra on Jul 20, 2010 16:30:04 GMT
that is a lot of spaces to clear lol... an auto reset would be great if possible
|
|
|
Post by arek on Jul 20, 2010 17:03:50 GMT
I just noticed a couple of bugs: - Attempting to enter a pure rogue build into the tool gives me an AB of #N/A. Investigation into the cause led me to AB,E9, which is the lookup routine for LBAB, and also said #N/A (should say 0.6). Now, manually setting LBAB to 0.6 (to get the sheet to display the proper AB value for the rogue) revealed the following additional bug:
- Shortswords are treated by your sheet as being non-finessable. This is because Shordsword is listed as "short sword" in the finessable weapons list, while it's listed as "shortsword" in the dropdown weapon selector.
Hope this helps. :-) --Arek EDIT: Running a pure ranger through the tool gave me the LBAB bug again, adding a paladin splash for testing fixed it, meaning that this is probably going to happen for any pure build atm. You might want to look at your calculations and make sure that they're not doing something stupid when only one class is involved. :-)
|
|
|
Post by shardelay on Jul 21, 2010 10:53:48 GMT
One minor bug: If you take LSA, you cannot take the skill it enables as a class skill until the next level. Thanks, fixed now. To see the issue with subraces, try entering Gnome as your race and Svirfneblin as your subrace, and/or getting that combination to appear in the list of available subraces. Sorry, I am not able to reproduce this. Perhaps, as you say, it is an open office issue. Not sure how I can help with this one. You can just highlight the areas with info in them and delete the contents (not formatting and such, tho). A "quick-erase" feature would be nice, tho...along with a feature to turn off dual-wielding and flurry/rapidshot. :-) I'm not sure if i can build a quick-erase feature w/out adding in some VB-code and last time I had some vb code (it sorted the subraces in the dropdown box) I had some combatibility issues when others tried the sheets. If someone know show to do this w/out vb (dont think we can) let me know, else you'll hvae to deal with the task of highlighting all the cells and hitting backspace once. I have also added in a toggle to disengage flurry, rapid shot, and dual wielding in row 15. Note: This will only work if you have the feats... i.e. if you have flurry engaged = yes but you dont actually have the flurry feat (from feats or from row 12 gear feat options) it should still not flurry). Let me know if it's not working as expected. As to dual wielding, i have added a dual wield check in row 15 also, but alternately you can simply choose a shield other than "none" and it will not calc dual wielding. Although I suppose that this was missing things like standards and torches so I added this in as well. I just noticed a couple of bugs: - Attempting to enter a pure rogue build into the tool gives me an AB of #N/A. Investigation into the cause led me to AB,E9, which is the lookup routine for LBAB, and also said #N/A (should say 0.6). Now, manually setting LBAB to 0.6 (to get the sheet to display the proper AB value for the rogue) revealed the following additional bug:
- Shortswords are treated by your sheet as being non-finessable. This is because Shordsword is listed as "short sword" in the finessable weapons list, while it's listed as "shortsword" in the dropdown weapon selector.
Hope this helps. :-) --Arek EDIT: Running a pure ranger through the tool gave me the LBAB bug again, adding a paladin splash for testing fixed it, meaning that this is probably going to happen for any pure build atm. You might want to look at your calculations and make sure that they're not doing something stupid when only one class is involved. :-) Fixed both. The problem, as you mention, was not rogues but was with not having 2nd and third classes and a missing exception handler for an excel error. Fixed now. Shortsword finesse also fixed. Unfortunately, I do not have access to an FTP client from work, so I will upload these fixes today when I get home. Thank you very much for the feedback. These bugs are easy to fix, but hard to find. thanks,
|
|
|
Post by kaldair on Jul 21, 2010 19:01:56 GMT
I don't know if this will help - I'm not sure how well named ranges translate between versions & to Open Office? Here's the basic steps: 1) Highlight the cells you want the to clear all at once, holding down the "Ctrl" key during the process to select cells that are separated from each other, 2) Depending on the version and type of the spreadsheet software you are using, you will need to name this area. In Excel 2007, you would click on the "Formulas" tab, then click on the "Define name" icon, then type in a name (without spaces!) in the "New name" box. Earlier versions use the "Insert name" menu option, and I don't know how Open Office does it? 3) Once you've named the range, hit the "F5" function key in Excel (all versions). Click on the name that you gave the range. Then hit the "Delete" key. Voila - all the cells which you defined in the name are cleared simultaneously! Note that you can edit the range you defined if you added a wrong one or need to add another one(s), rather than starting over. In Excel 2007, use the "Name Manager" icon under the "Formulas" icon. I think this may be basic enough to work across platforms. It would be simplicity itself to create a macro to use this named range to automatically clear these cells, but again, I don't know if a macro (simple as it would be) will translate over to other versions & Open Office? Sincerely, Kaldair
|
|
|
Post by arek on Jul 21, 2010 22:30:05 GMT
Standard excel macros tend to work reasonably well in OpenOffice. A few of the more complicated ones don't (like the one Shard uses for the subrace filter), but that can usually be worked around.
In any case, thinking about it, a quick-erase feature isn't really what's needed here. What would be really nice is to just have a blank sheet to start from (and that's achieved easily enough by simply clearing the sheet and re-saving it while it's blank).
--Arek
|
|
|
Post by shardelay on Jul 22, 2010 17:50:37 GMT
I have cleared the values on the version I'll be uploading when I get home. I also reset all the selections to no, none, blank, n/a, 0, etc... The only selections I left were Open Lock of 1 because I always put one point there and therefore I dictate that you should too! and I left the skill formula in one skill column so that you could cut and paste that formula into cells to max skills w/out having to re-write the formula. Using this formula is just a convenience, you can just type the values in manually if you want.
Once again, I'm attempting to build this sheet with absolutely no macros (perhaps that's foolish), but if you want an auto-clear macro should be easy to add.
|
|
|
Post by shardelay on Jul 22, 2010 21:06:17 GMT
uploaded and updated. I'm suspicious of my hp calcs, but haven't tested and debugged yet.
|
|
|
Post by arek on Jul 23, 2010 4:20:03 GMT
No, an auto-clear macro shouldn't be necessary. Being able to start from a blank sheet is enough, since it makes good sense to save a separate copy of the sheet for each character you're making anyway - just start from the blank sheet and use "save as" the first time you save it. :-)
--Arek
|
|
|
Post by shardelay on Jul 23, 2010 6:34:55 GMT
well, ive been cutting and pasting values and formats for saving my characters as it's a HUGE sheet to save for each char. Not really a smooth way of doing that w/out macros or manual work either.
|
|
|
Post by arek on Jul 23, 2010 11:53:58 GMT
Yes, it's big, but not so big that I couldn't find room on my HD for 100+ copies if I needed to. :-)
--Arek
|
|
|
Post by shardelay on Aug 5, 2010 18:35:22 GMT
Updated to fix a few bugs, add some dwarven war-axe ac, and make some changes with new smite updates.
|
|
|
Post by buddhamind on Sept 1, 2010 21:26:04 GMT
In the "Total Ability Mod" section of the Subrace tab you have Wis and Int flipped. This may only affect the labels on this particular section, though, since the calculations seem to work as far as I can tell.
|
|
|
Post by shardelay on Sept 3, 2010 6:25:05 GMT
just a labeling issue and wont effect the working of the tool, but i have corrected for my next upload.
|
|
|
Post by buddhamind on May 25, 2011 14:10:52 GMT
Bumping this thread because it's getting hard to find. This is an awesome tool and I use it on nearly all of my builds now.
|
|
|
Post by arek on Jun 24, 2011 3:05:31 GMT
Shard, I've been seeing a problem with your sheet in OpenOffice.org that's had me pulling my hair out for months. The problem: If an ability modifier should be negative, OpenOffice returns ERR:502 instead of the correct number. This isn't a problem, since usually you're looking at your character with +12 or even +14 ability modifiers, but it still happens with a nekkid toon. Today, I finally figured out how to properly fix the problem. Here goes:
The function you use for STR is currently FLOOR((L5-10)/2 ;1) (in excel) Changing this to FLOOR((L5-10)/2 ;SIGN(L5-10)) fixes it for OpenOffice. Basically, in OpenOffice, the significance must have the same sign as the number being rounded. I tested in OpenOffice for what would happen with FLOOR(0;0), which happens if (SCORE-10=0), and that returns 0, which is correct. I don't have MS Excel to test in, but excel does have the Sign function to test with. If this works in excel, would you please change the function in your sheet? Thanks :-)
--Arek
P.S. If the modified function doesn't work in excel, I can just fix it myself when updating, so it's not a huge deal.
|
|