erian_7's Excel-based Character Sheet


Homebrew and House Rules

1,001 to 1,050 of 1,732 << first < prev | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | next > last >>

Antonio Sciancalepore wrote:

I also tried this:

I reset the printing area to include the first 96 rows (so I expected that the print was correct)but again it didn't print the last rows.
erian_7 wrote:


Hmm, I'll fiddle around with OO a bit and see what I can come up with. I don't actually have any A4 paper on hand for a test, however...

I can see the problem also in the print preview so I think you don't need the paper.

the strange thing is the different behaviour of the "twins sheet" the print preview of the front sheet is ok while the print preview of the spells sheet is ko.

p.s.
I tried the portrait version and the print in A4 module is perfect.


In the weapon blocks, Imp TWF is not being picked up. it is looking for "Two-Weapon Fighting, Improved" while the Feats_Known cell is calling it "Improved Two-Weapon Fighting"


DustinGebhardt wrote:
In the weapon blocks, Imp TWF is not being picked up. it is looking for "Two-Weapon Fighting, Improved" while the Feats_Known cell is calling it "Improved Two-Weapon Fighting"

Thanks, fixed it!

And here is the latest version:

PRPG_CS_v_0_8_2.zip

Note that as of this version, both portrait and landscape formats are in the same file. The Front portrait tab is not quite full functional yet, but the rest should be good to go. You can, of course, hide any tabs you won't use. I'm checking now on what effect there is from deleting the tabs.

In addition to bug fixes and the format consolidation, this version also has a (hopefully) fully functional race and class for Rite Publishing's Jotunnar from In the Company of Giants.


First bug - L-Spells and P-Spells: The VLOOKUP that pulls up the number of bonus spells from the table Table_Abilities is pulling up a #REF error.

This appears to be because the INDIRECT() call is using the short name for the spellcasting stat (Int, Wis, Cha) and you changed the names to Int_L, Wis_L and Cha_L at some point when you forked, and didn't rename them back.

One solution is to change the names back, the other is to concatenate the ability name with _L in the formulas to match the names. I've done the latter on my working sheet and confirm that it works.

You may want to build the tables that cross reference spells per level so that they have a dash rather than 0 when the caster level doesn't permit it, and build some logic in to the summation function for spells per day so that it's aware of spells available by level. I suspect that this is a partially implemented feature.


AdAstraGames wrote:

First bug - L-Spells and P-Spells: The VLOOKUP that pulls up the number of bonus spells from the table Table_Abilities is pulling up a #REF error.

This appears to be because the INDIRECT() call is using the short name for the spellcasting stat (Int, Wis, Cha) and you changed the names to Int_L, Wis_L and Cha_L at some point when you forked, and didn't rename them back.

One solution is to change the names back, the other is to concatenate the ability name with _L in the formulas to match the names. I've done the latter on my working sheet and confirm that it works.

You may want to build the tables that cross reference spells per level so that they have a dash rather than 0 when the caster level doesn't permit it, and build some logic in to the summation function for spells per day so that it's aware of spells available by level. I suspect that this is a partially implemented feature.

Thanks, fixed it (used the concatenation route) for the next iteration. The entire Spells tab needs some reworking (as per previous discussions) to allow for selection of the relevant class. With the class selected, it should then flow through and fill out relevant sections.


There was one thing I found. Natural Armor and Deflect Armor bonuses aren't coming up. Now I am still only working with .8.0; I haven't started using .8.2 yes so this might have already been cleared.

Liberty's Edge

When using the portrait in the newest one, I have a level 1 character with weapon finesse. This is making all melee weapons use dex for attack bonus. On the Landscape one, when I only have a scimitar as my only item, total gold value is listed as 13.5 when I change the scimitar to cold iron, it correctly doubles to 27 gold. I checked in the data area and the scimitar is listed as 15. Not sure what is causing it to drop to 13.5

**Studded leather is showing 22.5. Something is taking 10% off. Not sure if I have something checked


RE: v8.2 - In fully-patched Excel 2003 on Win XP I'm getting "too many formats" and "Excel found unreadable content" errors. Recovery was not possible.

Zo

EDIT: Also just noticed: congratulations on a 1000-post thread. I think it shows the dedication you've got and the interest of your user base that the thread has gone on this long.


Erian, I've got a structural suggestion

I'm going to suggest that you move the weapon block data entry forms and the skill list and character information data entry forms on to the Getting Started Tab, and just use the Landscape and Portrait tabs as report generator tools rather than data entry tools.

This will GREATLY simplify the amount of version checking you'll have to do.

Then see about doing the same thing for Back tabs, though it's not as critical there, and the same thing for Spells.

Or create a Data Entry - Back tab, and a Data Entry - Spells tab.

This way you can separate data entry from display.

As an added bonus, if you do decide to make a separate tool for copying data from one copy of the sheet to another, you can minimize the number of sheets it has to pull from.


Found the mysterious 10% discount on armor.

In cell AX78 on the landscape tab, the final *0.9 should be inside a parentheses somewhere in there. Probably in the IF statement before it.

Same problem and solution on cell BJ4 in P-Back


AdAstraGames wrote:

Erian, I've got a structural suggestion

I'm going to suggest that you move the weapon block data entry forms and the skill list and character information data entry forms on to the Getting Started Tab, and just use the Landscape and Portrait tabs as report generator tools rather than data entry tools.

This will GREATLY simplify the amount of version checking you'll have to do.

Then see about doing the same thing for Back tabs, though it's not as critical there, and the same thing for Spells.

Or create a Data Entry - Back tab, and a Data Entry - Spells tab.

This way you can separate data entry from display.

As an added bonus, if you do decide to make a separate tool for copying data from one copy of the sheet to another, you can minimize the number of sheets it has to pull from.

I second this option. I'd prefer that the actual "character sheet" be static, as it were; I'd prefer to enter nothing beyond my character's name and biographical data on this page.


CulinaryMadman wrote:
There was one thing I found. Natural Armor and Deflect Armor bonuses aren't coming up. Now I am still only working with .8.0; I haven't started using .8.2 yes so this might have already been cleared.

When you say they aren't coming up, what do you mean exactly? I haven't corrected anything related to AC, but check it in the latest version and let me know.

Shar Tahl wrote:
When using the portrait in the newest one, I have a level 1 character with weapon finesse. This is making all melee weapons use dex for attack bonus.

I'm not sure if you mean this is broken in some way? I just checked with a short sword vs. longsword and Dex was only applied to the short sword as appropriate.

Shar Tahl wrote:

On the Landscape one, when I only have a scimitar as my only item, total gold value is listed as 13.5 when I change the scimitar to cold iron, it correctly doubles to 27 gold. I checked in the data area and the scimitar is listed as 15. Not sure what is causing it to drop to 13.5

**Studded leather is showing 22.5. Something is taking 10% off. Not sure if I have something checked

Heh, that's actually a problem introduced by my wife--we had used a prior sheet to build her Legacy of Fire character and one of her feats grants a 10% reduction in equipment cost...Fixed it!

DigMarx wrote:

RE: v8.2 - In fully-patched Excel 2003 on Win XP I'm getting "too many formats" and "Excel found unreadable content" errors. Recovery was not possible.

Zo

EDIT: Also just noticed: congratulations on a 1000-post thread. I think it shows the dedication you've got and the interest of your user base that the thread has gone on this long.

Thanks! As for the formats error, that is a bit surprising as one of the things I did with the last few versions was consolidate formating to standard sets. I'll try again...

GuJiaXian wrote:
AdAstraGames wrote:

Erian, I've got a structural suggestion

I'm going to suggest that you move the weapon block data entry forms and the skill list and character information data entry forms on to the Getting Started Tab, and just use the Landscape and Portrait tabs as report generator tools rather than data entry tools.

This will GREATLY simplify the amount of version checking you'll have to do.

Then see about doing the same thing for Back tabs, though it's not as critical there, and the same thing for Spells.

Or create a Data Entry - Back tab, and a Data Entry - Spells tab.

This way you can separate data entry from display.

As an added bonus, if you do decide to make a separate tool for copying data from one copy of the sheet to another, you can minimize the number of sheets it has to pull from.

I second this option. I'd prefer that the actual "character sheet" be static, as it were; I'd prefer to enter nothing beyond my character's name and biographical data on this page.

This is actually counter to the direction I'm going--I want the Front tab to be as dynamic as possible for use during the game. All but one person at my table uses their character sheet from the laptop and makes changes mid-game as necessary. I am looking at moving some of the more static data on the Front--name, description, etc.--to Getting Started as that won't impact usability, but the weapons and skills will definitely stay. I could see moving skill ranks off at some point, but I'd have to figure out a way to dynamically display the skills on the front to all changes in misc. mods.

Now, part of the process I'm going through right now is figuring out the named cells from the Front that are used elsewhere in the sheet. My goal is to move those that don't have to be there, so they can stay out of the L/P split, and incorporate logic for all others that works regardless of which sheet is used (another option would be to make one of the Front tabs static, pulling data from the other). I've already done this with the Back tab fairly successfully from what I can see--I just need to work out the Weight field. Switching all the names to having a _L is actually part of the plan, giving me a specific criteria for searching other sheets...


Okay, maybe I explained my "preference" in a way opposite to what I actually meant. Currently the vast majority of character creation (and updating) is done on the "Getting Started" tab--I like this (like your players, I'll likely never print off the sheet and will use the file as my active character sheet).

However, skills have to be updated on the "P-Front" tab. Can skills be integrated onto the "Getting Started" tab so that all of the "P" tabs are purely for displaying the rendered character sheet? Granted the "Getting Started" tab is already pretty crazy/full...

With regard to the biographical data, I was referring to the character name, gender (should this be a drop-down?), age, etc. on the "P-Front" tab; I don't mind it here, since it has no mechanical effect on the character and you really only touch those cells once. Now that I think about it, age does have a mechanical effect (which you've programmed in). Since age affects ability scores (which affect a million other things), perhaps it needs to be spelled out earlier in the process (a place to enter the character's "maximum age" would also be nice).

Basically, I'd like to see everything character-building-related (from a mechanical standpoint) off the "P" tabs as much as possible. Really, ideally I'd like to only have to hit one tab in order to create or level up a character (whereas right now I have to hit two).


For some reason, the special materials for armor is not affecting character speed. If you choose a 30ft base speed class with mithral chainmail, the character should have a speed of 30.


Quick post to get v.0.8.3 up:

PRPG_CS_v_0_8_3.zip

Bug fixes, plus continuing to move static character info to Getting Started. I'll think more on the Skills section--I can probably work out getting the leveling items over to Getting Started and have the other mods on the Front.

Temp fix to the material issue--I'm actually looking to break armor out as selections by material type in the drop down. Thoughts?


erian_7 wrote:


Temp fix to the material issue--I'm actually looking to break armor out as selections by material type in the drop down. Thoughts?

Bug fixes sent by email.

I prefer two drop down lists - one for armor type, one for material. They're easier to navigate.

If there were a way to make the weapon drop downs smart enough to read Ranged/Melee/Thrown, and the Wielded As drop down lists so that if you, say, selected ranged and Two Handed, it would only show you the weapons that fit that requirement, I'd love it.

I recommend the following, as a modifier on the structural change I made earlier:

1) Move 'Skills' (including the ability to choose the sort order) to Getting Started.

2) Move Weapons, Armor and Magic Items to a Combat Equipment tab and pull their contents into the appropriate space on the display tabs.


Wow, I apologize, I should have far more specific. I was referring to deflection bonuses or natural armor bonuses for magic item. Now, in the current iteration, I suppose you could simulate by using the misc bonus boxes, so I may be way off base here.

Sovereign Court

Hi Erian !

Tried to download the latest version, but Excel refused to open it, saying it was "too damaged" whatever that means.


Stereofm wrote:

Hi Erian !

Tried to download the latest version, but Excel refused to open it, saying it was "too damaged" whatever that means.

I'm having the same issue. Are you running Excel 2003 SP3 and/or Win XP SP3?

Also to Erian: I agree with AdAstraGames re: moving skills and choosing sort method. Trained/Untrained makes sense but I prefer alphabetically, personally.

Zo


I may have another error here, this seems odd. Trying to put a character together from level 1 (human rogue) and I'm getting nothing but an ERR:502 in the Feat dropdown menu, and for human Bonus feats I get a list entirely filled with NULL. What gives here?


Actually,I'm still having problems opening the file in Excel. I have OpenOffice 3.2 though, and OpenOffice Calc opens it just fine.


erian_7 wrote:

Quick post to get v.0.8.3 up:

PRPG_CS_v_0_8_3.zip

Bug fixes, plus continuing to move static character info to Getting Started. I'll think more on the Skills section--I can probably work out getting the leveling items over to Getting Started and have the other mods on the Front.

Temp fix to the material issue--I'm actually looking to break armor out as selections by material type in the drop down. Thoughts?

Hello Erian

I am getting to many cell formats error when I open the spreadsheet in excel. :-(


Doggone it. Another error. Fighter level 1/Wizard 1 (Universalist). Hand of the Apprentice isn't populating (I get an Err:502 in the Class Abilities Tab), and the Scribe Scroll feat does apply, but it says Create magic scrolls000000000000000000000000000000000000. On the plus side it does populate the bonus spells correctly for the INT bonus (once I tell it which attribute to look for, of course).


Just tried making a Bard 8/Arcane Archer 1 but when I add the AA level the class abilities goes to N/A. I double checked that I met all of the requirements for the PrC.


Open Office 32 Version 8 does not work fine, Class ablilties has ERR508

Weapon Finesse has 000000000000000000000000000000 in it.

Feat Skills-Perception is getting a bonus of +6 but has only one rank, should be +3

Flurry of blows is not correct. 7 levels with 2 in monk, Weapon Finesse, dx 16, +7 total with one attack, the 2 weapon Prim/off hand Flurry of blows is -2 for both.

How do you get the Natural Armor to work?

Trying 8.3 to see if this works

Liberty's Edge

The formula for calculating speed is not taking not wearing any armor into account. Only light armor grants full speed.

I did get around it by creating a custom armor called "No Armor" that didn't have any penalties and was light category.


I have one more, so let me try to condense all I have and add then:

1) Natural Armor bonuses and Deflection bonuses to AC that come from magic items: Currently you only have the Amulets of Natural Armor listed on the Excelerator. In the past those bonuses were taken into account on the AC, and they don't seem to be now. Keeping in mind they can be simulated using the Misc Bonus tabs in that box, so it's not a total loss.

2) Universalist Wizards' abilities are not coming up at all again (no Hand of the Apprentice in Class Abilities, for example).

3) In the .8.3 variant (when I tried it anyway, using latest version of OO), the Feat dropdown in Getting Started gave me an Err:502, and the Human Bonus Feat dropdown gave me a list composed completely of NULL.

and now 4) Rogue Talents are not being listed in Class Abilities. I see a line for Rogue Talents and it shows that I've gained the appropriate number, but it does not list what talents I picked (though it does show the Weapon Focus I picked up over in the Feats box). (Ed. Note: I am going to make sure I actually picked these in Getting Started to be sure I'm not mistaken here... yeah, comfirmed. If the talent turns into a feat, that feat is listed in the Feat box, but I have Fast Stealth and Bleeding Attack, and they are not listed.)


Man, lot's of broke stuff...

Didn't get to do anything with the sheet over the weekend, but I'll dig through all the posts and start fixing things.

Thanks for all the detective work!


On P-Front, weapon bonus damage (due to Strength) is broken - throws a #NAME? in the Attacks and Damage bonus fields.

But, on in P-Front, L-Front seems to be working fine for this.

CJ


Any word? I'm reluctant to "upgrade" my sheet until I know things are generally working.


It's been a hectic week at work, so I haven't been able to get to anything as yet. Hoping to have something out tonight or tomorrow, though, as I'm just wrapping up a big budget review.


No worries; this week (and last week) have been, well, not the most enjoyable work weeks ever for me as well, so I know where you're coming from.


Okay, I've started reformatting the tabs "from the ground up" by taking them all back to defaults, then only using formatting when needed. This should fix the Excel 2003 and earlier problems, but is taking a bit. I'll post that cleaned up version ASAP, then switch to a focus on the bug fixes.


Having read in another thread that your sheet is intended to work fine in Excel alternatives, I gave it a shot. (Version 0.8.3)

I haven't scoured it just yet, this was the "smoke test" stage. Open Office 3.2 under Ubuntu 10.04 did choke on loading it. Several times.

But it did load, and after I tried a few things appeared to work fine. I'll give it a more thorough work out tomorrow and let you know how it works under my environment of choice.

(Yes, I did see there are errors in this version. But you did claim it should work fine under Open Office.)

And while I am at it, thank you for making a less Microsoft heavy sheet.

Scarab Sages

Let me start off by saying I love the spreadsheet, It has made things so much easier on everyone that I game with.

I decided to try the witch out and the companion sheet didn't really work for the familiars. So (on one of your older revisions) I made a familiar sheet that works pretty well. If you would like to take a look at it I can send you what I did. I used your basic frame work to keep everything standardized, so it should be fairly easy to integrate.

The version I was using didn't have witch support, so I decided to your sheet to make it work for me. I too ran into a lot of formatting errors and corrupted sheets on earlier versions of excel. What I found is most of the formatting errors and damaged spreadsheets was due to color incompatibility between 2007 and earlier versions. I proved this issue by clearing the colors of what I worked on and the formatting errors went away and I was able to open it with Excel 2003 as well. And sadly, compatibility mode doesn't correct this issue (Thanks for over looking that little detail Microsoft LOL). I hope this bit of information helps you more in your future endeavors.

Now to the part I hate to tell you, is the front (portrait) has bugs in the weapon area. I was wondering if I might make a suggestion that may make things a bit easier on you. Do you think it would be easier to create one front and one back settings page where the user makes all his selections. You could do all the formatting and calculations on this page. You could still allow the user to print portrait or landscape by having those pages pull the information from the formatting pages. It would cut your calculation work in half as well as cutting down on the amount of errors you might run into. This is just a suggestion and I mean no offense by it. I just thought it might be easier on you.

Keep up the excellent work.


Yay, new folks! First up, no worries on any comments/criticisms/corrections you might bring to this thread--that's it's purpose, after all! And I must say the sheet is much better off thanks to honest and open review. So again, hack away!

Now, for the current compatibility issue I've found several things in these sheet rebuilds. Color compatibility is indeed one area that I'm looking to correct by using only three specific shades of gray plus black and white. This is what had been in the previous sheets, but it looks like some errant colors sneaked into various places...I have also found several tabs that were noting a font issue, but only if you actually select the entire page and then check the Fonts window. I think this is from Excel being "helpful" at times when new rows/fields are added, and have looked to correct this by setting all pages to the Normal font. Finally, I've actually found a few drop-downs and other such objects noted on some pages. I'm unsure on where these might be from, except perhaps for some legacy items from my old sheets. They have been axed. So, the sum total should be a clean (and slightly smaller) sheet that won't choke older Excel apps.

Disenchanter, yours would be the first report of an OO issue on this one, so do please let me know any specifics that come up once I get the clean version out for testing.

For the Front page suggestions, and possibly using a data entry page, that is counter to one of my goals for this sheet, specifically that I want it to function equally well as both a printed and laptop-ready sheet. Part of what I started (that broke the compatibility) with 0.8.2 and .3 is a better integration of the data that is capture and/or used on the various tabs so that everything that logically can be centralized will be (likely on the Getting Started tab) and this effort will continue once I get the clean-up done. This does mean some areas will have duplicated functionality (like the weapon blocks) and require double duty to maintain. However, I'm also looking to streamline and simplify a lot of the legacy formulas that are in the sheet from before I was thinking better on structure, so that should help.

Summary, keep on smacking this thing around, and I should have to clean version out in a few hours...

Thanks!


Is there anywhere inside the file where the version number is noted?


GuJiaXian wrote:
Is there anywhere inside the file where the version number is noted?

No, just in the name of the file itself.


I routinely rename my files to the name of my character, so I would find it helpful to have the version number recorded somewhere else.


Alright, first and foremost: I don't expect anything to be done to improve the sheet for my environment of choice. I want that out there, so you (erian_7) know that you don't have to do anything extra to get the sheet to work for me.

Next, I am still using 0.8.3, so some of these reported problems could be cleared up.

Also, as a reminder, I am using OpenOffice 3.2 in Ubuntu 10.04.

Now:

Quite a bit of it works fine. My system does choke on it (I need to remember to turn off the autosave feature...), but that isn't a big surprise since this machine isn't "top shelf." (3Ghz Pentium 4, 1GB Ram)

I have found some areas that don't work right. I'll try and list these by tab.

Getting Started:
The drop downs for Bonus Feat under Step-2 pick your race are all listed as NULL and the selected race is Human.
There is no + symbol to open up the class option sections.

L-Front:
Error 508 (Pair missing - missing bracket) in the cells for AC Total and Flat Footed

P-Front:
Error 508 (Pair missing - missing bracket) in cells for all Attribute Scores and Mods, initiative total and mod, all AC totals, AC Dex and Natural, Attack Type totals, CMD Total Str and Dex, all Save Totals and Abilities, Skill Points X of <Err: 508>.
Perception is wrong - it seems to only be listing the ranks and not the total.

And that is about where I stopped.

After you get your next clean version up, I'll dive in again and let you know what I find.


Okay, I've completed the reformat, and fixed a few of the errors along the way. Note this does not address all items reported so far--I wanted to get it out to see if my efforts are successful in helping the Excel 2003 folks. If you recheck an error you've already reported and it's still there, you can let me know, or else know that I'm heading back into the errors for v.0.8.5.

Thanks!

PRPG_CS_v_0_8_4.zip


Well, I show the Universalist Wizard Hand of the Apprentice coming up, excellent.... rogue tricks are being listed correctly, we're good there.... still getting an Err:502 when picking feats in the Getting Started Tab in the Step Three dropdown menus. I do not get a similar error now, however, for picking a Half-Elf's Skill Focus, but I get a list of NULL when trying to pick a human's bonus feat yet.


I'm still having trouble with my Bard 8/Arcane Archer 1 with the class abilities coming up as #N/A. I tried a similar build with Bard 8/Dragon Disciple 1 and got the same thing. I'm pretty sure I have all the prereqs correct in the build.


erian_7 wrote:
...I'm heading back into the errors for v.0.8.5

Calculations in 8_4 on the Barbarian Rage powers are off. Have a 7th level barbarian with Powerful Blow (shows +8, should be +2), Renewed Vigor (shows 7d8, should be 2d8), and Guarded Stance (shows +8, should be +2).


erian_7 wrote:
stuff about new sheet...

No errors thrown on opening in MSO 2003. Amazingly fast bugfix turnaround. I'm creating a level 5 conjuror after my rogue/wizard was killed in what seems like DM-related shenanigans last week, and I'm not getting the +3 bonus from adding the first rank to a class skill.

Zo


Okay, I've started working issues from the bottom up...

Morin Steelbrow wrote:

Let me start off by saying I love the spreadsheet, It has made things so much easier on everyone that I game with.

I decided to try the witch out and the companion sheet didn't really work for the familiars. So (on one of your older revisions) I made a familiar sheet that works pretty well. If you would like to take a look at it I can send you what I did. I used your basic frame work to keep everything standardized, so it should be fairly easy to integrate.

What aspects didn't work? And I'd love to see any fixes you have. You can send them to:

erian dot 7 at gmail dot com

GuJiaXian wrote:
I routinely rename my files to the name of my character, so I would find it helpful to have the version number recorded somewhere else.

I've added a Sheet Version field at the top of the Getting Started tab.

Disenchanter wrote:
Alright, first and foremost: I don't expect anything to be done to improve the sheet for my environment of choice. I want that out there, so you (erian_7) know that you don't have to do anything extra to get the sheet to work for me.

No problem on this--anything I correct for you is likely going to improve the overall sheet. I actually like it when I get a new mix of OS/app, as it helps me find even more bugs. So, you've got a "friendly developer" in me as far as this goes!

Disenchanter wrote:

Getting Started:

The drop downs for Bonus Feat under Step-2 pick your race are all listed as NULL and the selected race is Human.
There is no + symbol to open up the class option sections.

The first is an error CulinaryMadman had noted--fixed it!

For the + not being there, this is trickier. I've checked using OO 3.1.1 on my XP laptop and it looks okay. Can you see if there are any patches/updates that might address this?

Disenchanter wrote:

L-Front:

Error 508 (Pair missing - missing bracket) in the cells for AC Total and Flat Footed

P-Front:
Error 508 (Pair missing - missing bracket) in cells for all Attribute Scores and Mods, initiative total and mod, all AC totals, AC Dex and Natural, Attack Type totals, CMD Total Str and Dex, all Save Totals and Abilities, Skill Points X of <Err: 508>.

Problem with the Magic_Item_Summary field. Fixed it!

Disenchanter wrote:
Perception is wrong - it seems to only be listing the ranks and not the total.

I'm getting a full calculation on this, but perhaps some other area I fixed corrected a problem

CulinaryMadman wrote:
Well, I show the Universalist Wizard Hand of the Apprentice coming up, excellent.... rogue tricks are being listed correctly, we're good there.... still getting an Err:502 when picking feats in the Getting Started Tab in the Step Three dropdown menus. I do not get a similar error now, however, for picking a Half-Elf's Skill Focus, but I get a list of NULL when trying to pick a human's bonus feat yet.

This was a hard one to track down! There was an error in the Custom Prestige Class caster level calculations that was throwing the whole thing off (and OO was better at finding the error than Excel...)!

Tem wrote:
I'm still having trouble with my Bard 8/Arcane Archer 1 with the class abilities coming up as #N/A. I tried a similar build with Bard 8/Dragon Disciple 1 and got the same thing. I'm pretty sure I have all the prereqs correct in the build.

This was an error in the caster level increase functionality. Corrected for the next iteration.

seaan wrote:
Calculations in 8_4 on the Barbarian Rage powers are off. Have a 7th level barbarian with Powerful Blow (shows +8, should be +2), Renewed Vigor (shows 7d8, should be 2d8), and Guarded Stance (shows +8, should be +2).

Error when adding in the Custom Class rage boost. Fixed!

DigMarx wrote:

No errors thrown on opening in MSO 2003. Amazingly fast bugfix turnaround. I'm creating a level 5 conjuror after my rogue/wizard was killed in what seems like DM-related shenanigans last week, and I'm not getting the +3 bonus from adding the first rank to a class skill.

Zo

Yay for the fix working! Now, for this class skills I just did a check on a Wiz 5 and everything worked okay. Can you confirm if this is happening on other classes for you?

Scarab Sages

The portrait front sheet still has problems with the weapons. I tried dagger, 1 handed, melee and the "Attacks" field shows "#NAME?". I then changed it to Morning Star and got the same thing.

Also, I chose "Leather Armor" on P-Back, but the added AC didn't show up on P-Front.


Morin Steelbrow wrote:

The portrait front sheet still has problems with the weapons. I tried dagger, 1 handed, melee and the "Attacks" field shows "#NAME?". I then changed it to Morning Star and got the same thing.

Also, I chose "Leather Armor" on P-Back, but the added AC didn't show up on P-Front.

Yep, the Portrait views are very buggy right now--Landscape should be working well. I actually just fixed some of the weapon block and armor issues (including the ones you've noted), and am working through the logic to shift common data off both the L and P Front tabs to facilitate easier maintenance.

Thanks!

CulinaryMadman wrote:
Natural Armor bonuses and Deflection bonuses to AC that come from magic items: Currently you only have the Amulets of Natural Armor listed on the Excelerator. In the past those bonuses were taken into account on the AC, and they don't seem to be now. Keeping in mind they can be simulated using the Misc Bonus tabs in that box, so it's not a total loss.

I wanted to pull this one out specifically as an FYI. These are working "as intended" at present, basically setting the various fields as "read only" so that magic items can flow to them properly. You are exactly right in that using the Misc boxes to cover other non-automated AC items is the way to go. I could change the Applies to? drop-down to reference the bonus type instead of Touch/Flat-Footed, although that would limit some of the more "out there" AC bonuses that I might not have considered. Any thoughts?


The class skill rank problem only occurs in the portrait view sheet if I add a skill rank to a class skill in portrait view without adding it in landscape view as well (which I should have stated previously, since you've told us that the portrait view is still buggy).

Adding a rank to a class skill in landscape view works fine, and if I then look at the portrait view sheet, the "calc mod" field is calculated correctly, though the skill rank doesn't show up (I'm sure you'll fix that in the future).

Zo


Ah thanks, that is indeed a problem--it's because the DataSkills tab only looks at the Landscape view right now. I'm shifting the allocation of skill ranks to the Getting Started tab per previous suggestions, and that will fix this error as well.

Speaking of fixing the portrait view, I have v.0.8.5 ready and it corrects all of the items noted to date (except the skill issue). So, the weapon blocks and armor/shield should be good to go, as should the OO 502/508 errors. I also tweaked the Misc AC boxes after thinking about it a bit--you can now specifically tell it to apply to one of the calculated fields.

PRPG_CS_v_0_8_5.zip

1,001 to 1,050 of 1,732 << first < prev | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | next > last >>
Community / Forums / Pathfinder / Pathfinder First Edition / Homebrew and House Rules / erian_7's Excel-based Character Sheet All Messageboards

Want to post a reply? Sign in.