Hi Sneaky, want to try entering ALL the APG feats using the same format? I am still working with the traits.
In the afternoon I'll try to see if everything I should do is well clear for me, if not I'll ask for some explanation if instead is everything ok I'll try to understand how much time I could need to perform the task and inform you with that
Helaman I have some questions for you?
1. You asked me to insert all the APG Feats in the same format... Well in the Feats_DATA hidden sheet there are all these feats reported already with a lot of info... what is still missing I think are just the prerequisites for almost all of these feats... then do you need I just insert the prerequisites?
2. Assuming the answer to 1. is yes then I have a problem, how the sheet is working at the moment, if I'm not wrong, I could be able to add only about 50%-70% of the APG feats prerequisites because to add the others I should need to change the sheet format to add specific references to races-generic caster level... Do you want I start adding what I can or is better if some1 who is knowing better all the references to this sheet (KOR?!?) prepares before the main format and then I could help him with this job?
3. If the answer to the 2nd question is "start adding what you can do" this seems a quite simple task and I could do it in very few days. If instead the worksheet expert (KOR) tell us that I can add some rows to the prerequisites checks ("AZ:BK") without making any trouble to macros or other references I could also try to insert new specific APG prerequisite categories by myself.
4. If instead you prefer I can do other tasks...
Hi all,
Thanks for helping out!
I am out of town right now but will be back on Sunday. I will then be able to look at emails and will be able to better coordinate efforts.
I also created a Google Group so that we have a place for coordinating these efforts. I will provide this info on Sunday.
As for feats, I was planning to do up a data entry summary, similar to what I did for traits. For the most part everything I mentioned there pretty much applies to feats as well.
I have added a new reference feature to the Levels page where you can query the description of many features, such as feats, traits, alternative racial features and certain class powers. Because of this, I now have added a "raw description" column to most of these tables as well. Because of this I now want full descriptive elements of all text.
Prerequisites is certainly one area that will be very helpful on feats. Don't worry about any feats that will need cell references, I will code them when the info is sent to me.
As for the Oracle. *shakes fist* It has been a very labor intensive chore and due to some circular errors that have come up I have tried to do some patchwork to get around those. The introduction of feats that give you extra class abilities, such as the Oracle's Extra Revelation feat, has been difficult for me to integrate into the sheet. Its actually been the hold up for the latest release, so I think I will just release without activating the Oracle at this time.
Thanks again.
Prerequisites is certainly one area that will be very helpful on feats. Don't worry about any feats that will need cell references, I will code them when the info is sent to me.
Hi Kor, looking better at the "Feats_DATA" sheet I discover the AZ Column (Other Custom) so probably I could be able to put specific reference to cells too and so mainly (I hope) put almost all the data in...
So I started filling the info (for prerequisites) and I think I could finish with APG data quite soon... then I'll send you that sheet by mail and you could give me indication about how to improve that work or expand it for other sources.
P.S. Kor, why when "Precise Shot" is requested as a prerequisite you also add "Point Blank Shot" that is already a prerequisite of the first feet? Shouldn't the reference be already automatic with the specifing of the first one?
Wont this be an issue for the good people of Paizo? Your current sheet has mostly mechanical/crunch text - adding full text may cause some hassles... then again, the Paizo staff have been very supportive of this sort of thing so maybe not.Because of this, I now have added a "raw description" column to most of these tables as well. Because of this I now want full descriptive elements of all text.
I've still stuck with referring to the same mechanical/crunch text, however right now most of the bonuses that are calculation based, I just show the calculated amount (i.e. +2 bonus...) as opposed to the descriptive text (i.e. +1 bonus per every 4 levels...) This is really the only change in the display of the information for the query.
I do not plan to reference the actual text (full published text) for the concern you noted. I want the focus of this sheet to continue to be assisting in the quick generation of a character -- yet not nullifying the need for the sourcebooks.
Hi Kor, looking better at the "Feats_DATA" sheet I discover the AZ Column (Other Custom) so probably I could be able to put specific reference to cells too and so mainly (I hope) put almost all the data in...
So I started filling the info (for prerequisites) and I think I could finish with APG data quite soon... then I'll send you that sheet by mail and you could give me indication about how to improve that work or expand it for other sources.
P.S. Kor, why when "Precise Shot" is requested as a prerequisite you also add "Point Blank Shot" that is already a prerequisite of the first feet? Shouldn't the reference be already automatic with the specifing of the first one?
Sounds great!
I just include the prerequisite feats as noted under each feat. However, as you have noted many of the feats do have prerequisites which are mutually exclusive. Originally I was only going to list the "top tier" prerequisite feat. However sometimes a character can gain a feat without needing to meet the prerequisites, yet the next feat in the tier does require the character to meet all of the prerequisites. So because of this, I try to include all if I can. If more than 5 feats are listed as prerequisites, then I do not list the lowest tiered feat(s).
Not sure if this has been reported but here it is anyways:
Rogue talent: Minor and Major Magic qualifiers met? formulas in Classes_DATA2 (Y347 & Y348), they refer to cell_intmod instead of cell_int, thereby requiring 30 int to take minor magic, and 32 int for major magic.
Great sheet, im using it to learn more about excel, had my own sheet that was very simplistic, and this sheet is helping a ton. Probably won't use my sheet for characters anymore, but will keep playing with it to learn :)
Thanks for reporting this. This has gone undetected for over a year now.
I forgot to write it here... yesterday in the evening I sent you the excel file with APG feats prerequisites filled... find it in your mail...
and don't forget telling me what else you need now and if everything I did was right.
I'm having some trouble understanding the CL chart (ACL, DCL, CL, Highest) in Spells_DATA, and therefore don't know the fix, but caster level won't increase past the straight caster level of my PC from casting class..
PC is lvl 9 EK (1 ftr, 6 sorc, 2 EK) with magical knack (sorc). Should show as a lvl 9 CL for sorc, but will only show as a 7.
Have magical knack selected in talents, but it doesn't modify the chart at all.. even tried to make a custom bonus to CL (sorc) at +10 to test, and it does not modify CL either. Assuming the "Highest" cell should have reference to magical knack and the custom CL modifier, but i dont know how to do such. Hope that was clear enough :)
I'll have to look into that tomorrow. I thought I had that area working well. Thanks for reporting it.
*------------------------------------*
====== New Revision =======
*------------------------------------*
Version Beta 1.53 now released.
Good news... mostly :)
Bad News:
- not a lot of new content added
- still fighting some big roadblocks the Oracle has created
- the sheet is still big and slow to load
Good News:
- I have done some needed behind the scenes alterations which will more easily allow me to incorporate rules variant option (classes / races)
- Race variants have been added. (Race favored class options have not)
- Levels page has been revamped, with a query window for various abilities. I still believe that the "level based build" is the best approach to character creation and I think this new sheet really does it justice.
- I tried to address most of the errors posted in the last few months, but it is very possible I may have missed some. (I forgot to fix an error I noticed on the Spells page in how sorcerer spells per day are displayed).
- added custom experience tables and point buy tables to the Customs tab.
- added a traits query window similar to the Level query window.
- APG traits added.
EDIT:
Whoops... error on the Stats page with regards to Ability Point Buy. I just fixed it now and reloaded the sheet. If you downloaded it in the last 10 minutes, you will need to redownload. (I did not change the version number).
Started playing with the new version and it is interesting. Couple of things I did notice adding up my 9th level ranger is that the ability increase drop down is missing at 4th and 8th. Also doesn't look like it is getting the bonus feats at the various levels where it should.
Also seeing some things in the Pre-Reqs box. At level 3 it shows Prepared. At level 4 it shows table_spells_rangerDATA_available, at level 5-9 it shows #VALUE!
The way you have built it is interesting. Takes a little getting used to, but it looks fairly flexible.
High Kor
Glad you are back.
I was playing about with the new sheet.
My third level Dwarven fighter was not being given the option to select a feat at third level. The only selection I was being offered was the favoured class bonus.
Maybe I am missing something?
Cheers
Alan
Yep. Exact same issue I has having one post up as well.
Yep. Exact same issue I has having one post up as well.
Ah yes, I see the problem. Will have it fixed right away.
Started playing with the new version and it is interesting. Couple of things I did notice adding up my 9th level ranger is that the ability increase drop down is missing at 4th and 8th. Also doesn't look like it is getting the bonus feats at the various levels where it should.
Also seeing some things in the Pre-Reqs box. At level 3 it shows Prepared. At level 4 it shows table_spells_rangerDATA_available, at level 5-9 it shows #VALUE!
The way you have built it is interesting. Takes a little getting used to, but it looks fairly flexible.
Thanks for noting this. I have fixed this, and I have changed this so that the pre-requisite only shows up for Level 1 of the selected class/prc.
This may need updatingOGRE'S SHEET
A Pathfinder Roleplaying Game Character Sheet Creator for ExcelLatest Version for Download - Beta Release v1.2 (January 11, 2011):
ogresheet.zip (.xls sheet - Works with Excel versions 2002 to 2007)
ogresheet2.zip (.xlsm sheet - Works with Excel versions 2007 to current)
I think this not updating because of your browser settings. Try selecting "Refresh" and you should see it update with the current information.
*------------------------------------*
====== New Revision =======
*------------------------------------*
Version Beta 1.54 now released.
- fixed the issues identified in the last version.
Kor have you seen my mail with APG feat's prerequisites? Was it wrong? If so (I have seen you didn't introduce it on last versions) if you tell me how to do that in the right way I'll try to correct myself.
on 1.54, sorcerer lvl 1 with option "standard max hps + con" is giving me a 10 on the roll, when max should be 6.
I am not able to reproduce this error. Could you please tell me what is displayed in the "Hit Points (HD)" cell.
Kor have you seen my mail with APG feat's prerequisites? Was it wrong? If so (I have seen you didn't introduce it on last versions) if you tell me how to do that in the right way I'll try to correct myself.
Hi Sneaky. It looks like you have saved a copy of the entire sheet. I did try to download it from the site it is posted at... but all the instructions are in Italian I think.
Could you please just copy and paste the feat information only into a seperate spreadsheet (best to just "Paste as" "Values".) This way it will also be small enough to e-mail.
Thank you, I look foward to seeing the work you have done :)
Could you please just copy and paste the feat information only into a seperate spreadsheet (best to just "Paste as" "Values".) This way it will also be small enough to e-mail. Thank you, I look forward to seeing the work you have done :)
Sent it the way you suggested... (I hope)
Heya Kor. Couple of things.
Some of the Dwarven racial traits (such as "Clearheaded") as well as other traits (such as "Princess") are outright missing. Also, there appears to be no way to select a race trait of another race if the "Adopted" trait is selected.
Also, the "New Arcana" bloodline ability for a Sorcerer doesn't appear to be able to add extra spells to a Sorcerer's spells known (though I might be doing it wrong). Also on that note, the feat Expanded Arcana doesn't be able to add new spells to a Sorcerer's spells known as well.
Also, is there anyway you can make the stat blocks the generator produces more like the stat blocks Paizo produces for their NPC's/Villains? Finally, is there a way to copy the stat block to word perfect? I've tried to highlight the block and then shift-c but that doesn't appear to work at all due to being unable to highlight the block.
Sorry to be a bother. Hope everything is well. ^_^
I've only played with the sheet for a few minutes, but it looks like it's not adding in the Monk's wisdom modifier for AC or CMD, it's catching the level dependent AC bonus ok, though.
I think I've found a bug. When I've selected "Rolled HPs" for the levels tab, level 1's hit point box shows the data for level 2. But only if there's a number in the box for level 2, if level two is blank the data for level 1 is correct.
I think I may have found a bug as well - I entered custom classes on the Custom tab, but the classes are not showing up in the various class dropdown lists. The classes are flagged via dropdown on the Custom tab as "Class" not "PrC" and have been fully populated with HD, skill points, BAB and saves.
I think I may have found a bug as well - I entered custom classes on the Custom tab, but the classes are not showing up in the various class dropdown lists. The classes are flagged via dropdown on the Custom tab as "Class" not "PrC" and have been fully populated with HD, skill points, BAB and saves.
I've isolated the cause for the absence of custom classes - in the classes_DATA tab, the function that checks to see if the class should be displayed is checking the active sources against a source list that doesn't include a "Custom" flag. (Classes_DATA column DY, comparing against "list_optionsDATA_shortsources")
Do the class Archetypes work yet? If they do, I've got something screwed up. When selecting fighter, the archetype selection is available but there's nothing in the dropbox, in fact the box doesn't work. It doesn't even open empty.
I think I've found a bug. When I've selected "Rolled HPs" for the levels tab, level 1's hit point box shows the data for level 2. But only if there's a number in the box for level 2, if level two is blank the data for level 1 is correct.
I've found the the solution to this issue. The formula in sheet "Classes_DATA3" cell AQ5 should be:
"=IF(H5=1,IF(INDEX(index_levels_levelinfo,Levels!$C$114,D5*8-6)>0,INDEX( index_levels_levelinfo,Levels!$C$114,D5*8-6),0),0)"
The 'D5' cell references were set to 'D6' making it use level 2's entry instead of level 1's.
version 1.54
New bug, for wizards. Sheet 'Attributes_DATA' cells AC430, AD430, & AG430 should be blank. They have copied data from the wizard's spell ability row in the wizard's weapon proficiency row. This shows up on the spell casting sheet as double the caster level.
Thanks for identifying all the bugs. I'm hoping to have some time later this week to address them all.
Do the class Archetypes work yet? If they do, I've got something screwed up. When selecting fighter, the archetype selection is available but there's nothing in the dropbox, in fact the box doesn't work. It doesn't even open empty.
The archetypes are not yet coded in.
Luck to you... seems the new format etc has led to a few.Thanks for identifying all the bugs. I'm hoping to have some time later this week to address them all.
Yeah, seems like a big mess. The wierd thing is I did some "light" testing and everything 'seemed' to work fine.
I am fearful I have pushed Excel to its limit. I have twice now gotten lost data errors. This requires me to go back to an earlier version and re-do work I have already done. And I have very little time to do this. Unfortunately this means even more delays in getting this sheet done.
I will try to upload a "basic" fix now to at least get the sheet working, but I have to start from scratch again on all the coded content I did over the last few days. *sighs*
*------------------------------------*
====== New Revision =======
*------------------------------------*
Version Beta 1.55 now released.
- fixed the main issues identified since last version. Sorry, no new content due to the above reason.
Sheet: Skills_DATA
Cells: G89:G93
Issue: These cells have #REF! error, should point to Skills!AR58:AR62
Shows up as a #REF! error on Skills entry sheet in the custom skills section.