Ogre's Sheet - Excel Character Creator


Homebrew and House Rules

251 to 300 of 330 << first < prev | 1 | 2 | 3 | 4 | 5 | 6 | 7 | next > last >>

Kor - Orc Scrollkeeper wrote:


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.

Great work so far and I appriciate the hard work you have done so far. I am running into an error that I can't seem to wrap my head around. I'm building a level 8 Human Ranger. 25 point buy stats (13,16,14,14,13,9) with a +2 to Dex for being human. Level four Stat bump Wis & Level 8 Stat bump Dex)

Feats are Human-Point Blank Shot; 1st-Percise Shot; 3rd-Deadly Aim; 5th- Weapon Focus Longbow; 7th-Manyshot.

Archery as Combat Style, 1st-Rapid Shot.

I get a "Run-Time Error '13' Type missmatch"

When i go to the Debug sectino I have this:

Private Sub Worksheet_Calculate()
If Range("A2").Value = 0 And Not IsEmpty(Range("A2")) Then
ThisWorkbook.Worksheets("Page2+").Visible = xlSheetHidden
Else
ThisWorkbook.Worksheets("Page2+").Visible = xlSheetVisible
End If
End Sub

The Highlighted section is: If Range ("A2").Value = 0 And Not IsEmpty(range("A2")) Then

Not sure on this coding as I don't use VB on my excel sheets I work on. Any help from the comunity or Kor would be nice. Thanks in advance!

R/

Janack42


You have a feat or feature from level selection that's not valid. Look at your levels and see if there's something out of place. If you still can't figure it out, send me a copy of your sheet and I'll try to find it.


Stupid question:
How do I make the sheet count weight properly for small characters? I'm using the newest version. It doesn't adjust the gear weight. It is adjusting the weight for weapons and armor properly.


quirthanon wrote:

You have a feat or feature from level selection that's not valid. Look at your levels and see if there's something out of place. If you still can't figure it out, send me a copy of your sheet and I'll try to find it.

Okay, found where the error is occuring. When I select at level 6 Point Blank Master that's when the error occurs. Aside from that worksheet is perfect. Still haven't figured a work around for this issue.

R/

Janack42


Janack42 wrote:


Okay, found where the error is occuring. When I select at level 6 Point Blank Master that's when the error occurs. Aside from that worksheet is perfect. Still haven't figured a work around for this issue.
Janack42

I've found the error.

Sheet: Classes_DATA2
Cell: G365
Issue: the name in this cell does not match the name in the feats data section.
Fix: change cell value to "Point-blank master"

This should fix the issue, let me know if it works.


Thanks for sourcing out that error. I blame the APG for having the hyphen in the name on the Feat list, but not in the Feat description.


quirthanon wrote:


I've found the error.

Sheet: Classes_DATA2
Cell: G365
Issue: the name in this cell does not match the name in the feats data section.
Fix: change cell value to "Point-blank master"

This should fix the issue, let me know if it works.

Thanks, that seems to have fixed my issue. Thanks for the quick reply and problem solving.

Great sheet and continue the good work my friend.

R/

Janack42

Shadow Lodge

Just bumping this really as it had slipped in to the archive.

Will there be another update? I'm happy if any of the new stuff mentioned isn't 100%. Beggers can't be choosers after all and I appreciate all the hard work that has gone into this.


Between working out of town and doing house reno's its been so hard to find any time for the sheet. I also spent the last 3 days trying to source out a virus I got on my computer.

I only have done a few fixes on the sheet, and have been working behind the scenes on the Eidolon stuff. I will do my best to get an update out tonight.

Summer time is always so busy for me. Once the snow falls and the temperature drops in about 1-2 months, then I will be working a lot more on the sheet.


*------------------------------------*
====== New Revision =======
*------------------------------------*

Version Beta 1.70 now released.

- fixed the issues identified in the last version.
- oracle class is complete

I have constructed a new SpellList entry page (not yet active) which will allows me to add in bonus spells, such as many of the favored class bonus that human casters get. I hope to have this active for next update.

Shadow Lodge

Thanks for the update :)

I put in a custom Cavalier class, and when I selected it the mount and order class abilities appeared :)

It seems you have been busy with that class in the background too.


I didn't see anything about the oracle curse.

Grand Lodge

Kor - Orc Scrollkeeper wrote:

*------------------------------------*

====== New Revision =======
*------------------------------------*

Version Beta 1.70 now released.

- fixed the issues identified in the last version.
- oracle class is complete

I have constructed a new SpellList entry page (not yet active) which will allows me to add in bonus spells, such as many of the favored class bonus that human casters get. I hope to have this active for next update.

Thanks mate!


dunelord3001 wrote:
I didn't see anything about the oracle curse.

Whoops. I have it all there, I just didn't link in the ability. Quick fix :)

Grand Lodge

Kor - Orc Scrollkeeper wrote:
dunelord3001 wrote:
I didn't see anything about the oracle curse.

Whoops. I have it all there, I just didn't link in the ability. Quick fix :)

lol - so version 1.71?


Should the app have the version number 1.70 and a August date? The one I downloaded is 1.62 and a july date. Thanks for all your work.

Shadow Lodge

I had to follow the link in the first page of this thread as my favourited link took me to the older July sheet.


ok. Ogresheet.zip does show as version 1.70. ogresheet2.zip shows up as 1.64. Thanks.


Sorry about the mix up. I'll look into that tomorrow. Not sure what happened. I was just going to post the latest update, but I am having a lot of trouble trying to get the oracle curses to work without Circular Errors *curses Excel*.


*------------------------------------*
====== New Revision =======
*------------------------------------*

Version Beta 1.71 now released.

- oracle curse ability should now be working


Is it updated for the Witch yet? Had a close call with a handwritten sheet a week ago.


Ogresheet2 now showing correct version. Thanks :). Have you changed the way the level screen works? It now goes across instead off up and down in earlier versions.

Shadow Lodge

Certainly by no means an urgent error to correct, but the stone oracle rock throwing Revalation causes an error on the 2nd page of the character sheet so that only "#value!" appears.

Enjoying the sheet, thanks for the good work :)

Grand Lodge

Kor - Orc Scrollkeeper wrote:

*------------------------------------*

====== New Revision =======
*------------------------------------*

Version Beta 1.71 now released.

- oracle curse ability should now be working

Love your work!!!!!

Grand Lodge

Cavalier is one of the things I am hoping to see next edition but you've driven this a long way in the last 2 months!! Great stuff!


Helaman wrote:
Cavalier is one of the things I am hoping to see next edition but you've driven this a long way in the last 2 months!! Great stuff!

Wierd, I have no idea what happened to the cavalier. It is there, but it seems to have vanished from my data sheet. I will add that back in tonight as an available selection.


Svipdag wrote:

Certainly by no means an urgent error to correct, but the stone oracle rock throwing Revalation causes an error on the 2nd page of the character sheet so that only "#value!" appears.

Enjoying the sheet, thanks for the good work :)

Thanks for reporting that. Fortunately that's a quick fix :)


Darnizhaan wrote:
Ogresheet2 now showing correct version. Thanks :). Have you changed the way the level screen works? It now goes across instead off up and down in earlier versions.

Yes it scrolls across, but you shouldn't need to scroll. Just click on the number which corresponds to the level you wish to look at.


Treantmonk wrote:


Is it updated for the Witch yet? Had a close call with a handwritten sheet a week ago.

Ah yes, the tragic loss of the Witch sheet. Sadly, I have not yet started it, but I think it should be quite quick. I might even take some time away from the Eidolon page, to quickly slap the witch together.


Kor - Orc Scrollkeeper wrote:
Treantmonk wrote:


Is it updated for the Witch yet? Had a close call with a handwritten sheet a week ago.

Ah yes, the tragic loss of the Witch sheet. Sadly, I have not yet started it, but I think it should be quite quick. I might even take some time away from the Eidolon page, to quickly slap the witch together.

If I remember correctly, the entire group was pretty upset that the lost witch sheet happened to have the party treasure written on it.

Since found, it turns out that the party treasure sheet was pretty unimpressive, so in fact, the loss wasn't nearly as tragic as originally believed.

Grand Lodge

Treantmonk wrote:


If I remember correctly, the entire group was pretty upset that the lost witch sheet happened to have the party treasure written on it.

Since found, it turns out that the party treasure sheet was pretty unimpressive, so in fact, the loss wasn't nearly as tragic as originally believed.

:)

Grand Lodge

Cavalier still not working


I can't imagine how much effort went into this sheet. Much appreciation. I was messing with it today and transfering my Magus over and I noticed that while studded leather shows correctly on the arms page it is incorrect on the page#1. My character has a +5 dex mod and it only shows on page #1 as a +3 dex mod for the armor.

Also, I am not sure how to get the spells to work?? Dervish dance is available as a feat but doesn't seem to calculate correctly.

I am not meaning to nit pick, this is a great sheet.

Grand Lodge

Amric wrote:

I can't imagine how much effort went into this sheet. Much appreciation. I was messing with it today and transfering my Magus over and I noticed that while studded leather shows correctly on the arms page it is incorrect on the page#1. My character has a +5 dex mod and it only shows on page #1 as a +3 dex mod for the armor.

Also, I am not sure how to get the spells to work?? Dervish dance is available as a feat but doesn't seem to calculate correctly.

I am not meaning to nit pick, this is a great sheet.

Didnt even know it was up at all so to have the magus exceeds expectations.


Amric wrote:

I can't imagine how much effort went into this sheet. Much appreciation. I was messing with it today and transfering my Magus over and I noticed that while studded leather shows correctly on the arms page it is incorrect on the page#1. My character has a +5 dex mod and it only shows on page #1 as a +3 dex mod for the armor.

Also, I am not sure how to get the spells to work?? Dervish dance is available as a feat but doesn't seem to calculate correctly.

I am not meaning to nit pick, this is a great sheet.

Thank you for reporting these errors. Correcting any error, even a spelling mistake, is very important for me. I'm just finalizing adding in the witch and then will look at these further.

I have not been able to reproduce the studded leather problem, so I suspect that it may be due to something else, such as being over-encumbered. Could you please check your encumbrance.

I do not have any Magus information entered into the sheet at this time.

I also have not been able to reproduce the Dervish Dance problem. Could you tell me what is being shown for totals, and what you believe it should be.

Thanks.


Helaman wrote:
Cavalier still not working

Hoping to have the update out tomorrow.


Treantmonk wrote:


Is it updated for the Witch yet? Had a close call with a handwritten sheet a week ago.

With any luck the Witch should ne ready to go for tomorrow.


Kor - Orc Scrollkeeper wrote:
Treantmonk wrote:


Is it updated for the Witch yet? Had a close call with a handwritten sheet a week ago.

With any luck the Witch should ne ready to go for tomorrow.

You've been busy. Must be locked in your house or something :P


A very small bug present from the first versions...

Under the sheet "Stats" in the "Region" field there is written "Nitmathas" instead of "Nirmathas".

P.S. I'm using your sheet from the beginning of your campaign... thanks a lot for the effort you have put in it


I figured out what I was doing wrong on the armor. I am not the brightest of bulbs. My character has a +5 dex mod and Dervish dance but under the BAB it only shows str for melee.

So as a 3rd level Bladebound magus I should have a BAB of +8 but it only shows as being 4. So the dex mod wasn't factored in even though I have weapon finesse and dervish.

The Magus class slot might have been from me putting in as a custom class making it available as selectable.

I messed with the sheet more yesterday and it is great. My group is going to start using it now after they saw what it does.

I am still having some issues wiht the spells though, can't seem to figure that out. Do I need to have a viable class selected first?

Grand Lodge

Looking forward to the next update


Helaman wrote:
Looking forward to the next update

I'll post what I have done this afternoon. I wanted to finish my spell list revamp so that I could activate the witch changes, but this week has been too busy for me.

Grand Lodge

Kor - Orc Scrollkeeper wrote:
Helaman wrote:
Looking forward to the next update

I'll post what I have done this afternoon. I wanted to finish my spell list revamp so that I could activate the witch changes, but this week has been too busy for me.

I'll be stoked that the Cavalier thing will be in too.

Liberty's Edge

Pathfinder Adventure Path Subscriber

Just a couple of suggestions for future developement

1) Implementation of monster feats from the Bestiaries. With abilities like dragon claws available to sorcerers and animal fury granting bite attacks to barbarians it means feats like multiattack and improved natural weapon become viable feats as well as feats like implroved nat armor.

2)Implementation of the monsters from the Bestiaries. That way when a DM needs to add class levels to a creature they just need to select the creature for race and go.

Otherwise love the sheet it has been invaluable in doing conversions from older 3.5 stuff.

Thanks for your efforts

Liberty's Edge

Wonderful sheet. I used it to create my first Pathfinder character, which I am playing in Pathfinder Society and it helped VERY much. I'm looking forward to being able to use it to create my Summoner, as I'm struggling a bit with the creation process for this one.


dracomancer wrote:

Just a couple of suggestions for future developement

1) Implementation of monster feats from the Bestiaries. With abilities like dragon claws available to sorcerers and animal fury granting bite attacks to barbarians it means feats like multiattack and improved natural weapon become viable feats as well as feats like implroved nat armor.

2)Implementation of the monsters from the Bestiaries. That way when a DM needs to add class levels to a creature they just need to select the creature for race and go.

Otherwise love the sheet it has been invaluable in doing conversions from older 3.5 stuff.

Thanks for your efforts

Thanks for the feedback.

Once I complete the Summoner class's eidolon, it should give be a good framework for fully implementing natural attacks within the spreadsheet for player characters.

I would like to add more monsters from the Bestaries, but with so little time on my hands, my focus is solely on the Player guides right now.


*------------------------------------*
====== New Revision =======
*------------------------------------*

Version Beta 1.74 now released.

- minor fixes including re-activating the Cavalier

Although the witch is available, spell selection is not. I am hoping to be ready to introduce my new spell selection tab in the next update which will take care of this.

Liberty's Edge

Pathfinder Adventure Path Subscriber
Kor - Orc Scrollkeeper wrote:
dracomancer wrote:

Just a couple of suggestions for future developement

1) Implementation of monster feats from the Bestiaries. With abilities like dragon claws available to sorcerers and animal fury granting bite attacks to barbarians it means feats like multiattack and improved natural weapon become viable feats as well as feats like implroved nat armor.

2)Implementation of the monsters from the Bestiaries. That way when a DM needs to add class levels to a creature they just need to select the creature for race and go.

Otherwise love the sheet it has been invaluable in doing conversions from older 3.5 stuff.

Thanks for your efforts

Thanks for the feedback.

Once I complete the Summoner class's eidolon, it should give be a good framework for fully implementing natural attacks within the spreadsheet for player characters.

I would like to add more monsters from the Bestaries, but with so little time on my hands, my focus is solely on the Player guides right now.

Would be glad to help out as a data monkey if you need one. My excel-fu isn't that strong but i have plenty of time to sit and type in the basic info.

Grand Lodge

Kor - Orc Scrollkeeper wrote:

*------------------------------------*

====== New Revision =======
*------------------------------------*

Version Beta 1.74 now released.

- minor fixes including re-activating the Cavalier

Although the witch is available, spell selection is not. I am hoping to be ready to introduce my new spell selection tab in the next update which will take care of this.

Huzzah!!!!

Adding of course that you already have the Magus in, its a bright bright day for me.

Its still a ways down the road but I can see this getting closer and closer to "completion" of the Core,AP and UM/UC

Liberty's Edge

Helaman wrote:
Its still a ways down the road but I can see this getting closer and closer to "completion" of the Core,AP and UM/UC

I have a feeling that, by the time Kor gets to that point, Paizo will put out something else that will require the poor guy to do more work!

I am not knocking you at all, Kor. Your work is great. It's just that Paizo puts out so much awesomeness so fast that ANYONE would have trouble keeping up!

1 to 50 of 330 << first < prev | 1 | 2 | 3 | 4 | 5 | 6 | 7 | next > last >>
Community / Forums / Pathfinder / Pathfinder First Edition / Homebrew and House Rules / Ogre's Sheet - Excel Character Creator All Messageboards

Want to post a reply? Sign in.