I am fearful I have pushed Excel to its limit.Mate I've seen entire call centers run on Excel as well as erlang charts for computing work arrival and scheduling over months of work data...
I think you still have a ways to go.
He he, good to hear :)
Sheet: Skills_DATA
Cells: G89:G93
Issue: These cells have #REF! error, should point to Skills!AR58:AR62Shows up as a #REF! error on Skills entry sheet in the custom skills section.
Thanks for noticing that. Fixed for next update.
Are there any add-ins or other tools you use to manage the data, formulas, or formatting? Or is Excel it?
Are there any add-ins or other tools you use to manage the data, formulas, or formatting? Or is Excel it?
I just use Excel.
Sheet: Skills_DATA2
Cell(s): AJ9
Issue: Gift of Tongues always counts extra languages if ranks in linguistics are taken.
Fix: =IF(ISERROR(FIND(SUBSTITUTE(AI9,"#",""),SUBSTITUTE(cell_racesDATA2_variants selected,"#",""),1)),0,AJ7)
I'm not sure if this is how you would have done it, but it works.
Sheet: Skills_DATA2
Cell(s): AJ9Issue: Gift of Tongues always counts extra languages if ranks in linguistics are taken.
Fix: =IF(ISERROR(FIND(SUBSTITUTE(AI9,"#",""),SUBSTITUTE(cell_racesDATA2_variants selected,"#",""),1)),0,AJ7)
I'm not sure if this is how you would have done it, but it works.
Thanks for noticing that. Adding in these variant options has been fun :)
I regret not knowing a darned thing about Excel. Otherwise, Kor, I'd try to help. You are doing a wonderful job though. Keep it up!
Thanks, no worries. Its just good knowing that someone is still using it even after all the time its been taking me to get the APG incorporated :)
Can't wait until the Oracle and Witch arrives :P
Can't wait for the Barbarian's Archetypes :)
And btw - It seems like the Extra-Armor-Bonus (The one you can add to your armor on the Arms page) won't be taken over to the summary-page Page3.
Is that "Extra" field currently the only way to specify a magic armor/weapon?
sincerely
huppi
Is that "Extra" field currently the only way to specify a magic armor/weapon?
huppi
You can add armor and weapons on the "Items" sheet. Click the "Arms" button, and you can enter both armor and weapons in these cells. Use the "Special / Magical Properties" section to right of the basic data.
Sheet: CharSheet_DATA
Cell(s): B132
Issue: Extra armor from Arms sheet not counted on final character sheet.
Fix: Change B132 to "=Arms_DATA!D103"
Is it just my version, or has the Warrior NPC class vanished from this version of the sheet?
Great work though, still remain very impressed with all the work you have done.
It seems that is has vanished. Thanks for reporting this. I'm hoping to have an update out today.
Side note: I also noticed that HP's for favored class are not calculated in. I have fixed this as well for the next version.
Sheet: CharSheet_DATA
Cell(s): B132Issue: Extra armor from Arms sheet not counted on final character sheet.
Fix: Change B132 to "=Arms_DATA!D103"
Thanks that indeed will fix it :)
Still tinkering in what little free time I have. 1 more day of work until 4 days off, so the update might be a little delayed.
I'm just working on race favored class variable benefits right now. I wasn't sure how I could incorporate them, but I have a smoothly running system for them right now.
So what will we see when it comes out?Still tinkering in what little free time I have. 1 more day of work until 4 days off, so the update might be a little delayed.
I'm just working on race favored class variable benefits right now. I wasn't sure how I could incorporate them, but I have a smoothly running system for them right now.
Any selected favored class benefit will be calculated in to its effected stats / notes. Additionally, the total benefit provided will appear on Abilities sheet, including your tallies of hit points and skill points chosen.
After I finish the favored options, then I will return to the classes.
I have put many hours into the Oracle and its been a great pain. (And still will be).
Part of it, is due to the incorporation of the "Extra" feats, such as "Extra Revelation".
I needed to take a break from working on the Oracle as my annoyance level was getting to high... almost to the point that I did not want to work on the sheet any more. Alas, part of why I continue to work on the sheet is that I like challenges and I like problem solving.
Most of the Oracle content is in the sheet though, so I'm hoping to get it finished soon.
And before I forget, cell DT17 on the Arms_DATA page only looks for the combat expertise flag in the first six weapons.
Is that intentional?
Nope. I originally only had 6 weapons there. Although, now I am thinking I should remove the AC adjustment combat expertise provides. The problem is, is that if it is selected for 1 weapon, then the AC bonus will be factored in, regardless of which weapon is used.
For those that use the sheet for "live" play, perhaps I will instead add Combat Expertise as an available selection under the Bonuses page.
Could you have a selection option on the Arms tab to include Combat Expertise in the AC calculation in much the same way you do with a shield?
Or is that just making things way too complicated?
I did consider that but I figured that it was too conditional of a bonus that many characters would not have, so I thought the Bonuses page would be the best spot for it.
When I load up to medium or heavy loads (after selecting the option to have items affect enc), although it applies the correct skill check penalties for the loads, it does not affect my Max Dex, allowing my +4 bonus to AC from an 18 Dex to still apply in both cases.
It appears I completely forgot to calculate that in. I also noticed that I incorporate the skill check penalty for encumbrance incorrectly. This is all fixed now on the next revision.
I cannot see the dwarven fighter favoured class bonus of +1 to CMD vs trip/bull rush applied to the sheet anywhere after I select it. Is this still to be done?
Favored bonuses have just been added now on the next revision. (Hope to have it out in about 1 hour.)
*------------------------------------*
====== New Revision =======
*------------------------------------*
Version Beta 1.62 now released.
- fixed the issues identified in the last version.
- added the favored class options from APG. (Note: selections for additional spells is currently not functional)
I am planning to return to finishing the classes now (Oracle, Summoner, Witch). I ran into some major problems with the Oracle. I had 1 final issue I could not resolve, however I think I can follow a similar "work around" that I had to design in when I added in the favored class options.
I am planning to return to finishing the classes now (Oracle, Summoner, Witch).
Huzzah!
Can't wait :)
At the risk of sounding Dumb but it seems many of the challenges you face with the Oracle will also impact on the Magus... is that going to delay the Magus release?
It shouldn't. Whenever I encounter new mechanics I try to adjust the inner workings of the sheet so it can accept the new mechanics in case future material also requires it.
I've been using this sheet for a while now and I just wanted to say thank you Kor. Your hard work is appreciated.
Thanks, glad to hear you are finding it useful.
RPG Superstar 2014 Top 16
|
*------------------------------------*
====== New Revision =======
*------------------------------------*Version Beta 1.62 now released.
- fixed the issues identified in the last version.
- added the favored class options from APG. (Note: selections for additional spells is currently not functional)I am planning to return to finishing the classes now (Oracle, Summoner, Witch). I ran into some major problems with the Oracle. I had 1 final issue I could not resolve, however I think I can follow a similar "work around" that I had to design in when I added in the favored class options.
One thing that I noticed that needs fixed is when I choose Extra Discovery (or Extra Hex or Extra Rage Power, etc.) as a feat for an Alchemist, it doesn't give me the choice of Discoveries, or any way to type one in. I know you're working on the APG stuff so no super hurry. Thanks! Thanks for all the hard work!
One thing that I noticed that needs fixed is when I choose Extra Discovery (or Extra Hex or Extra Rage Power, etc.) as a feat for an Alchemist, it doesn't give me the choice of Discoveries, or any way to type one in. I know you're working on the APG stuff so no super hurry. Thanks! Thanks for all the hard work!
I have not yet coded any of the APG feats for stat changes and such. I want to complete the classes first since many of the feats are stat specific.
One of my biggest problems was to find a way to allow the "Extra" feats to work without creating circular errors. I have finally found a work around for these, so they should all be fine.
Thanks.
|
RPG Superstar 2014 Top 16
|
One thing that I noticed that needs fixed is when I choose Extra Discovery (or Extra Hex or Extra Rage Power, etc.) as a feat for an Alchemist, it doesn't give me the choice of Discoveries, or any way to type one in. I know you're working on the APG stuff so no super hurry. Thanks! Thanks for all the hard work!I have not yet coded any of the APG feats for stat changes and such. I want to complete the classes first since many of the feats are stat specific.
One of my biggest problems was to find a way to allow the "Extra" feats to work without creating circular errors. I have finally found a work around for these, so they should all be fine.
Thanks.
Is the Witch data going to be in there soon? I noticed that if you take a level of witch there are no class abilities at all.
Update: Still working away on APG material. Oracle is finally done. Working on Summoner now.
I have realized that in order to incorporate the favored race/class bonuses that grant extra spells, and to accomodate the increasing amount of spellcasting classes (especially those like the Witch that use a "spellbook" method for their spells, I will have to reconstruct a new "SpellList" page which can better handle all that. I have been working on that today and I think I have a very good solution. Its going to take some time to get it built though and it is a big job to do it. Once it is done, then I will resume with Summoner and Witch. (I have summoner completed, except for the Eidolon).
I will try to put out an update later this week with the completed Oracle class.
Thanks for all the hard work.
Love the sheet. Can't wait till APG is fully implemented.
Specifically looking for subdomains and elemetalists
One bug I have noticed in that Domains for deities do not show up correctly on stats tab under diety info. The same domains show up no matter which diety is chosen.
Thanks for reporting that. Oddly enough I have not changed anything in that area, yet I see it is not working correctly. A nice puzzle to solve now before I go to bed :)
I will try to put out an update later this week with the completed Oracle class.
Eagerly awaited :)
Sorry about the update delay, I have not had a chance to work on the spreadsheet all week. I got bogged down on adding support for the Summoner's Eidolon. This is going to take a lot of work not only due to the number of powers that an eidolon can get, but also because any of those powers can also affect the summoner.
I did finish the spell entry revamp that I wanted to do, I just haven't linked it to the Spell display sheet at this time. Although the new method works great I still miss the appearance of the old way I had it set up. For now I will use the new method for spell selection but I will likely change this in the future once I have added the rest of the APG content into the sheet.