A lot of GMs (myself included) will 'bill you' (in terms of Wealth by level) for any permanent spells on you or wishes used to improve attributes. Is there any convenient way to work this into the accounting on your spreadsheets?
Sorry, I can't really think of any way to account for this on the sheet.
I was just looking at the 75ep version and noticed that the code that showed the custom Feats doesn't appear to be passing it over to the Levels tab any longer. It was working on the ef version which is the most current version I am using. Didn't check any of the other items yet as my system has frozen up at the moment.
Thanks Sethvir. This will be fixed on the next revision.
I'm not an expert on Excel so forgive me if I'm wrong here but couldn't you write the Macro so that it picks the cell that it is pasting too based on the information in another cell? For example column A has the cell that it is being copied to, and then column B has the data. If that would work you'd be able to write one macro and when a new input cell was included you'd just need to list it on the export sheet in the column that has the cell names column and a equal too formula on the data column.
This was the method I was going to use, however it doesn't remove the labor involved in having the all the info copied and pasted onto each sheet. Basically 3 macros are needed:
1. Macro #1 (Save Macro) copies all the info from the DATA sheet into a stand alone save file.
2. Macro #2 (Load Macro) copies all the info from the save file onto the DATA sheet.
3. Macro #3 (Copy Macro) copies all the info from the DATA sheet, into each of the seperate sheets.
Any time I make a change to the sheet, adding in a new data entry selection, I would then have to edit each of these 3 macros. What's worse, is that the Macro references are not relative. So if I have a macro that grabs data from cells A1, A2, and A3, and then later I insert in a line between A1 and A2 for a new date entry cell (which now becomes A2), I now have to go into the macro and manually change the old references from A2 to A3, and from A3 to A4. I then have to add in the code for A2.
All of that is very time consuming and I suspect that given that it can take a a couple minutes for a "Clear" macro to clear a sheet (like the levels or arms page) I suspect a Copy Macro could take up to 10 minutes to execute.
Having said all that, some day I may yet attempt it, but currently I am so far behind in trying to keep up with new content, that I'm just unable to start a project like this at this time :(
I understand if it is going to take a while but are you ever going to include templates?
I do plan to. I will likely incorporate them into adding in monsters as well.
Are there any specific templates you are looking for?
A lot of GMs (myself included) will 'bill you' (in terms of Wealth by level) for any permanent spells on you or wishes used to improve attributes. Is there any convenient way to work this into the accounting on your spreadsheets?Sorry, I can't really think of any way to account for this on the sheet.
Sure you can, in fact, the sheet can already do that. Just use the custom magic items tables underneath the main magic tables in the items tab. Write in "Enlarged Permanent", weigh it as 0, cost it at 8000gp. Done.
A lot of GMs (myself included) will 'bill you' (in terms of Wealth by level) for any permanent spells on you or wishes used to improve attributes. Is there any convenient way to work this into the accounting on your spreadsheets?Sorry, I can't really think of any way to account for this on the sheet.
Sure you can, in fact, the sheet can already do that. Just use the custom magic items tables underneath the main magic tables in the items tab. Write in "Enlarged Permanent", weigh it as 0, cost it at 8000gp. Done.
Or, do that :)
*------------------------------------*
====== New Revision =======
*------------------------------------*
The latest release is now available at www.d20.ca
Alpha version 0.75et
Revised:
- Languages display fixed (for good this time)
- A 2nd Page2 will appear when you have enough abilities that they exceed the limit of column 2 on Page2.
- A second Page3 will appear if you have more than 6 weapons selected on the Arms page.
- coins now displaying correctly
- fixed an error that was not displaying all available feats
- poison spell text corrected
On Hold:
- speed-based acrobatics penalty for jumping (hoping to get an official rules clarification on it.
To Do:
- Review resistance bonus stacking problem
- Review equipment weight tally problem
- Considering how to better display Spell-Like Abilities
- Adding in natural attacks ability so that monsters can be added in later as a selectable race
So I noticed a problem last night with Resistance bonus to saves stacking. I have a cloak of resistance +1 equipped. Then I made a custom bonus for Shield Other which gives a resistance bonus to Reflex saves. It was adding both resistance bonuses to my Reflex save, which it shouldn't be. Obviously an easy fix is to just adjust the Shield Other bonus to not include the resistance bonus to saves, but it's something you may want to take a look at (perhaps other things might be stacking that aren't supposed to?)
Thanks for reporting this. I was tired and forgot to look into it for today's revision. I'll get it fixed for the next one.
Also, I don't know if it would take too much room or not, but I think it might be nice to list the bonuses from magic items to saves as magic item vs. lumping it into misc in the breakdown.
I really have to do an overhall on some of my "bonuses". I have different categories such as "bonuses" "magic" "misc" that I need to better define. Because of the way I handle the bonuses though, I can't really differentiate between magic items or not. (Although it is something I could build in, but it affects an area that I know is already "calculation intensive".)
1. Macro #1 (Save Macro) copies all the info from the DATA sheet into a stand alone save file.
2. Macro #2 (Load Macro) copies all the info from the save file onto the DATA sheet.
3. Macro #3 (Copy Macro) copies all the info from the DATA sheet, into each of the seperate sheets.
Any time I make a change to the sheet, adding in a new data entry selection, I would then have to edit each of these 3 macros.
Forgive me if I am missing something horribly important, I know just enough about Excel to be dangerous. If you put all the relevant information in say one column (or row or whatever) couldn't the copy Macro just copy that entire area? Then you wouldn't have to change those Macros every time you did a change. I'm not sure how much it would slow down the process though.
Reading through some of the stuff and its sounding the ticket for me - is any of the Advanced Player guide new classes added or the optional changes for core classes?
I'm just about to start with adding the APG info. I'm guessing about mid November I should have some APG content in the sheet. Hopefully by January 1st, 2011, I should have all the APG included.
Forgive me if I am missing something horribly important, I know just enough about Excel to be dangerous. If you put all the relevant information in say one column (or row or whatever) couldn't the copy Macro just copy that entire area? Then you wouldn't have to change those Macros every time you did a change. I'm not sure how much it would slow down the process though.
Example:
Lets say in Sheet1, Cell A1, I have a validation list that lets a person select "Classes". Lets say the user selects "Cleric" from that validation list. The value for cell A1 is now "Cleric".
Now, on Sheet2 (the data sheet), in cell B1 I link it to Sheet1: "=Sheet1!A1"
I can then do this for all other data on all other sheets, so that Sheet2 now has all that data. I can now write a Macro to save that data onto a seperate data/save sheet.
Here's where the problem in your example is (provided that I read it correctly):
Now, when I want to "Import" that data, I can write a Macro that will copy the data from the data/save sheet onto Sheet2, however now when I do this, all the formulas on Sheet2 will get wiped out, when the data from the data/save sheet gets copied and pasted over them.
So in my example, "Cleric" appears on A1 of Sheet1. The value "Cleric" displays on B1 of Sheet2 because of the formula in B1. The value "Cleric" would be saved onto the data/save sheet. When I import that information back from the data/save sheet though, B1 on Sheet2 is going to be changed from "=Sheet1!A1" to "Cleric".
There is nothing linking the value in B1 on Sheet2, to A1 on Sheet1.
I would have to build a macro, that would then copy all the info from Sheet2, to copy and paste the info on Sheet1, and all the other sheets that Sheet2 gathers the info from. Furthermore, since Sheet2 now has all its formulas wiped out, I would have to have the macro add those formulas back in.
So in my example, after the Import, I would now have "Cleric" displaying in Sheet2, B1 instead of "=Sheet1!A1". The macro would copy this value to Sheet1, A1 and then would replace the contents of B1 of "Cleric" with "=Sheet1!A1"
Sorry I'm explaining this poorly. The bold is too show my main point since I'm uncertain on the rest.
By having the save file import information to different location(s) then it exports them from the process may be simpler. This way at no time will any Macro need to recreate any formulas, since they remain unaltered.
Macro 1 will only copy the value(s) from Sheet2 (the data sheet), in cell B1 to the save file. If you set this to do a large enough area then you won't have to change Macro 1 very often/at all.
Macro 2 would then import the data to the import area, which is different then the export area. Call it Sheet 2 cell D for the example. Since it is importing the same area every time it won't have to be changed often/at all.
Macro 3 will then copy and paste the import data from the import area to Sheet 1 A1. Then the relevant formulas automatically fill in the information in the export area. Macro 3 may have to be changed as often as you were worried about but it should be much less work to change a single Macro the a trio.
The import data will be cleaned out every time when the file is closed without being saved. And closing without saving is the point of the save function. You could have Macro 3 delete the import area after it is done but that is more to go wrong.
I hope that made more sense.
EDIT:
Are there any specific templates you are looking for?
I'd really love the various lycanthrope and half-dragon templates.
Your Excel mastery is most impressive and your turnaround time on fixing bugs is excellent. Would I be correct in surmising that you're proficient in at least two programming languages?
In any case, I have to extend my congratulations to you on solid work here. Were the company I work for looking to hire people, I'd definitely look on this sheet of yours as solid evidence that you'd make a good developer.
Well done!
Thanks EWHM,
Sadly my progamming skills are very dated. The last formal language I learnt was Turbo Pascal in 1987 (a forerunner for C ).
There is indeed a lot of languages I would love to learn (C+, Virtual Basic, Java), but alas I just don't have the time right now.
Being a bit of a perfectionist and efficiency expert, I feel I am adept at being able to analyze existing products and improve them... which is what I did with my spreadsheet. I would love to start up a software company that created character generators, which has always been a passion of mine. The unfortunate reality is, is that there is very little money in it and I would not be able to do any of the programming -- so that means having staff. Add in licensing fees and well I suspect I would be lucky to make $1 for every $4 I spent. Now if I ever win the lotto, this will be a priority for me :)
Kor
Should a touch attack be applying a damage penalty? (Damage bonus is not being applied).
I did not think it should, but then again I could well be wrong (It's not like that has not happened before).
Cheers
Alan
Nope, it shouldn't be. I'll fix that. Thanks.
A third level cleric isn't showing as able to take Arcane Armor Training, when any third level cleric will always meet them.
A third level cleric isn't showing as able to take Arcane Armor Training, when any third level cleric will always meet them.
no they don't. Clerics aren't arcane casters.
The Prerequisites say: Light Armor Proficiency, caster level 3rd.Obviously this mean arcane caster level 3rd.
no they don't. Clerics aren't arcane casters.
The Prerequisites say: Light Armor Proficiency, caster level 3rd.
Obviously this mean arcane caster level 3rd.
There is nothing I know of in the books, errata, or statements by company employees to back your viewpoint. If you have something to support it please do share, but the RAW don't seem to support it.
I understand why this could be really annoying to put into the sheet but I'm just making sure it was known with a Mystic Theurge you don't seem to be able to select the spells from both spell lists to prepare.
There is nothing I know of in the books, errata, or statements by company employees to back your viewpoint. If you have something to support it please do share, but the RAW don't seem to support it.no they don't. Clerics aren't arcane casters.
The Prerequisites say: Light Armor Proficiency, caster level 3rd.
Obviously this mean arcane caster level 3rd.
Some things are so obvious they don't need statements by company employees. If they had to spell out everything the book would have been 2000 pages. I guess they count on people using some common sense.
Benefit: As a swift action, reduce the arcane spell failure chance due to the armor you are wearing by 10% for any spells you cast this round.
Divine spells don't have spell failure. You you think it's a problem hit the FAQ.
I understand why this could be really annoying to put into the sheet but I'm just making sure it was known with a Mystic Theurge you don't seem to be able to select the spells from both spell lists to prepare.
You still need 3 levels arcena caster to pick 1 level Mystic Theurge. I don't see the problem.
Some things are so obvious they don't need statements by company employees. If they had to spell out everything the book would have been 2000 pages. I guess they count on people using some common sense.
Benefit: As a swift action, reduce the arcane spell failure chance due to the armor you are wearing by 10% for any spells you cast this round.
Divine spells don't have spell failure. You you think it's a problem hit the FAQ.
You're the one who thinks the feat means something other then what it says. I already went back and double checked everything I could think of that might show you as correct. The closest I found was the book art work showing a caster who doesn't seem to be wearing armor next to the Mystic Theurge. No so much as a thread with anyone asking if you are right much less something semi-official.
http://www.d20pfsrd.com/feats/combat-feats/arcane-armor-training-combat.
Arcane Armor Training (Combat)
You have learned how to cast spells while wearing armor.
Prerequisites: Light Armor Proficiency, caster level 3rd.
Benefit: As a swift action, reduce the arcane spell failure chance due to the armor you are wearing by 10% for any spells you cast this round.
Arcane Strike, Arcane Blast, Arcane Shield, and every other feat that requires you to either be arcane spell caster in general or requires a certain amount of arcane caster levels before it may be taken flat out says so. This one doesn't.
As for common sense why disallow this? Worried Wizards will do a three level dip into Cleric? I mean the character in question has to carry around a feat that he won't be able to use till after he levels again. Allowing it follows both the RAW and won't make anyone OP. It flows in character that someone who knows divine magic, and is studying arcane magic (the only divine casters benefit from this feat) has found a way too start blending them together.
You still need 3 levels arcena caster to pick 1 level Mystic Theurge. I don't see the problem.
This statement while true, is irrelevant. Mystic Theurges are able to prepare and/or spontaneously cast spells at one spell level higher with slots from the other spell list. I have posted the details below.
http://www.d20pfsrd.com/classes/prestige-classes/mystic-theurgeCombined Spells (Su)
A mystic theurge can prepare and cast spells from one of his spellcasting classes using the available slots from any of his other spellcasting classes. Spells prepared or cast in this way take up a slot one level higher than they originally occupied. This ability cannot be used to cast a spell at a lower level if that spell exists on both spell lists. At 1st level, a mystic theurge can prepare 1st-level spells from one of his spellcasting classes using the 2nd-level slots of the other spellcasting class. Every two levels thereafter, the level of spells that can be cast in this way increases by one, to a maximum of 5th-level spells at 9th level (these spells would take up 6th-level spell slots). The components of these spells do not change, but they otherwise follow the rules for the spellcasting class used to cast the spell.
Spontaneous spellcasters can only select spells that they have prepared that day using non-spontaneous classes for this ability, even if the spells have already been cast. For example, a cleric/sorcerer/mystic theurge can use this ability to spontaneously cast a bless spell using a 2nd-level sorcerer spell slot, if the character had a prepared bless spell using a 1st-level cleric spell slot, even if that spell had already been cast that day.
The problem is that the sheet at this point doesn't support that feature. Depending on the sheet's set up till this point I'm sure it could really annoying and time consuming to include, so I understand why it might be excluded.
Hi Zark / Dunelord,
Thanks for bring this feat's pre-requisites to my attention.
When I considered how to code the pre-requisite, I did believe that the feat meant "arcane CL" as well. (Actually, I still do).
I really didn't see any reason why a non-arcane caster would take the feat, until Dunelord pointed out that technically a cleric planning to go the route of Mystic Theurge, may want to "pre-select" this feat, for when it becomes useful later.
I was still leaning towards keeping the pre-requisite as Arcane CL, however in reviewing HeroLabs sheet, I noticed that they use only CL as well. To be consistant with this other sheet, I think I will change the pre-req to CL... which does follow what the rules currently state, although I do believe its an error. I have always tried to code this sheet based on what the rules say, even though some references were blatantly wrong (thankfully most were fixed in the latest errata -- many of which were posted by me based on rules inconsistancies I found while coding this sheet). I will also add this to the Errata thread to get claficiation as I think it could benefit from it.
Hi Zark / Dunelord...
Again thanks for all the time you put in, you do great work here.
Is the Mystic Theurge spell selection a known issue?
I'm sure your aware (or maybe not, I didn't see a post about it) but gems aren't showing up on the printed pages.
Thanks for teaching me how to put in custom feats, I missed it before >< doh!
Along the lines of custom things, is there any way to do custom domains (and have the domain spell list and ability show up on the list of options)?
I only ask because I allow the APG (subdomains), and I know you haven't that far yet :P So I figure If I can do it until the time that you are able to address it it would be no problem.
Kor
I'm not sure if I have already pointed this out, but Detect Poison is missing from the o level lists in the Wizard's spell book section.
(Although I do wonder what it is doing in the list in the first place!)
Cheers
Alan
Thanks, I'll get this added in while I too ponder why it's on their list.
Kor
When the Sorcerer ability Elemental Ray prints out on page 2, it is shown as a Su when the book states it is a Sp.
Cheers
Alan
Thanks for noting this. I had all the bloodline Sp powers as Su's. I have changed them all now for the next revision.
I'm sure your aware (or maybe not, I didn't see a post about it) but gems aren't showing up on the printed pages.
Thanks for teaching me how to put in custom feats, I missed it before >< doh!
Along the lines of custom things, is there any way to do custom domains (and have the domain spell list and ability show up on the list of options)?
I only ask because I allow the APG (subdomains), and I know you haven't that far yet :P So I figure If I can do it until the time that you are able to address it it would be no problem.
I do plan to add in custom domains and bloodlines support. I should be able to include it for the next revision.
Is the Mystic Theurge spell selection a known issue?
Hrmm... that is going to be a tricky one. I'll have to put some thought into how best to implement that.
|
stuff
I know Kor has already commented but -
RAW state that any caster (arcane or divine) can take this feat so long as they are a 3rd level caster. no divine caster would take this though unless they intended going the multiclass approach & therefore be able to use their existing armour proficiency. since pathfinder makes multiclassing less palatable (IMHO) then this is less likely but it should not prohibit them from taking the feat
I actually considered this idea with a cleric I made & was intending to take a few levels of wizard or sorceror but we ended up getting a new player who took an arcane caster so my idea was made redundant
when taking the skill focus feet i noticed a miscalculation. it was fine at lower levels giving the +3 bonus, but once i had 10 ranks in the skill it jumped to a +9 bonus instead of the +6 it should be at.
I don't know much about excel but i would think it would be an easy fix for you.
Kor
I'm not sure if I have already pointed this out, but Detect Poison is missing from the o level lists in the Wizard's spell book section.
(Although I do wonder what it is doing in the list in the first place!)
Cheers
Alan
Thanks, I'll get this added in while I too ponder why it's on their list.
Perhaps do to the feeble nature of young wizards they have developed a paranoia for poisons. Instead of working out and building their tolerance for such an attack they have taken the easy way out, like they normally do, and added this spell to their list of tricks.
Okay, so it's 3rd of November already; where's the first APG release? ;P
...just kidding ;) - hope you're still having fun making the character sheet motherload.
Hi all. I've been out of town working and have returned now. I can now return to updating the sheet :)
Hi,
When I go into Items, Rod/staves/Wands. I try to setup my second wand of cure light wounds and I can not setup the number of charges left. I get a list_itemsDATA2_charges50 as the choice. This happens with the rest of my wands I enter. Thanks.
|
|
Kor I just downloaded the latest version I could find - 0.75et & I made a sorceror & found a few things for you
1) the spells I have chosen in spell list tab still dont show up on the spell tab page unless I am not doing something right but I have clicked in lots of places on the sheet - my druid sheet works fine though
2) 3rd level spells on spell list tab are showing up funny - they have a line between each one with a number on it
3) bloodline spells for 2nd, 3rd & 4th are showing ## for DC - arcane bloodline
Cee
Hi all I am resuming working in the sheet now. Life has been so busy lately.
I will address all the items posted since the last update.
Sorry for the long delay. I should hopefully have a revision out before next weekend.
Hi,
When I go into Items, Rod/staves/Wands. I try to setup my second wand of cure light wounds and I can not setup the number of charges left. I get a list_itemsDATA2_charges50 as the choice. This happens with the rest of my wands I enter. Thanks.
Thanks for reporting this. This is fixed now for the next release.
Kor I just downloaded the latest version I could find - 0.75et & I made a sorceror & found a few things for you
1) the spells I have chosen in spell list tab still dont show up on the spell tab page unless I am not doing something right but I have clicked in lots of places on the sheet - my druid sheet works fine though2) 3rd level spells on spell list tab are showing up funny - they have a line between each one with a number on it
3) bloodline spells for 2nd, 3rd & 4th are showing ## for DC - arcane bloodline
Cee
Thanks for mentioning all these, I've got them all working now.
*------------------------------------*
====== New Revision =======
*------------------------------------*
The latest release is now available at www.d20.ca
Alpha version 0.75ey
Revised:
- All problems identified prior to this post.
Please let me know if I missed any thing, but I think I got them all. (Although I now realize I didn't fix a problem with the equipment weight tally).
Hi Kor,
I am running a cleric in Legacy of Fire and have picked the Achievement Feat Healer's Touch. In the sheet this is not a choice under feats. Was wondering if this correct? Thanks for all great work.
|
[b]*------------------------------------*
====== New Revision =======Please let me know if I missed any thing, but I think I got them all. (Although I now realize I didn't fix a problem with the equipment weight tally).
I had emailed these a couple weeks ago but they may have gotten missed
Bard - I made a 1st level bard and no spells are comming up on the spell list.
Cleric - there is no option to get selective channeling for a level 1 charatcer even with the appropriate prerequirements
Ranger- Is the Boon companion feat available for hunters in your sheet yet. It is in the Seekers of Secrerets book pg 16. I tested a Ranger up to level 5 and it did not come up as an option.
