David Empey's page

David Empey wrote:

D'oh! Thanks, Andre.

Not problem.

Too be honest it took me about 5 minutes (despite having wrote a review a while back) to remember how to do it.

...and now my review, such as it was, seems to have vanished. Grr.

David Empey wrote:

Hmm. I don't seem to see a way to post a review, perhaps because I bought it from d20pfsrd.com instead of Paizo?

You can post a review even if you nought the product elsewhere.

Under the product review tab, look down for the Average product rating with the star rating.

Just below that, above the title of the first review, there a sentence "Write a review of [product name]!". Notice how the first half of the sentence is hyperlinked. Click on it and the review menu will open.

D'oh! Thanks, Andre.

Also, the first supplement for Starjammer should release this weekend, Medical Marvels by Michael Riter which adds new tech, old tech, pharmaceuticals, cybernetics and more! Everyone who posts a review of Starjammer here on Paizo will get a discount code to get Medical Marvels 100% FREE. NOTE! You don't have to post a good review, any review counts!

Hmm. I don't seem to see a way to post a review, perhaps because I bought it from d20pfsrd.com instead of Paizo?

David Empey wrote:

Formulas...

Interesting...I'll try this out on a test run and see what's what...

One disadvantage is that this won't necessarily break the line on the last space before hitting the cell border. It might break too soon, if the line has a lot of narrow letters, or too late, if the line has wide letters. You could use a fixed-width font, but those look pretty ugly, especially when combined with proportional fonts.

David Empey wrote:

It's not exactly "easy", but I have a set of formulas that can break up a long string into pieces of N letters or less, breaking on spaces or line-feeds (i.e. between words). You could use this to put the abilities summary string into a column of cells, instead of one big merged cell. You'd need two more columns of cells plus a couple more single cells to hold the formulas.

Hmm, I would indeed be interested! If it'll fix my problem, I'm up for the work...

Formulas:

Explanation:

Column A will hold the running total of how many characters we have processed, so in A2 we put the value 0, meaning we haven't processed anything yet.

B2: =MID(long_text,A2+1,wrap_length)&CHAR(10)
This is the next bit of long_text to process. The CHAR(10) at the end will be used later.

C2: =LEN(B2)-LEN(SUBSTITUTE(B2," ",""))
Counts the spaces in B2.

D2: =MIN(FIND(CHAR(10),B2),IF(LEN(long_text)-A2<wrap_length,LEN(long_text)-A 2,IF(C2=0,wrap_length,FIND("|",SUBSTITUTE(B2," ","|",C2)))))
This formula finds the first occurrence in B2 of either the next line-feed or the last space before the wrap_length.
Working from the inside out, the last Find function,
FIND("|",SUBSTITUTE(B2," ","|",C2)),
finds the location of the last space in B2. It assumes that "|" does not occur in B2. SUBSTITUTE() changes the C2-th space, i.e. the last space, to a "|", and FIND() finds the location of the "|", i.e. of the last space.
IF(C2=0, then there are no spaces and we just wrap at wrap_length, otherwise do the FIND.
IF(LEN(long_text...) takes care of the case where the last part of the long_text is shorter than the wrap_length.
FIND(CHAR(10),B2), finds the next line-feed, if any. If there's no line-feed, then it finds the end of B2, thanks to the CHAR(10) added to the end of B2.
MIN() picks the earliest of the next line-feed (if any) and the last space.

E2:=MID(long_text,A2+1,D2)
This gives the "wrapped" text.

Next line:
A3:=A2+D2
Computes how many characters have been processed.

etc.

DigMarx wrote:

PJOsano wrote:

Request for future version:

I tend to use the portrait orientation for the character sheets and I noticed that the description for feats, class abilities, etc. are set for the landscape; The portrait version has some of the descriptors run outside of the box.

Thanks

I've mentioned this problem to Erian_7 before and he's working on it. Are you using Excel 2003 like I am? My wife's got 2007 on her laptop and it doesn't have the same issue.

Zo

Yep, and right now I have absolutely no idea how to easily fix this. Something about Excel 2003 is causing the text to not wrap properly. It seems to be tied to a overall character count for the cell, as the text wraps fine up to a point. Very irritating...

It's not exactly "easy", but I have a set of formulas that can break up a long string into pieces of N letters or less, breaking on spaces or line-feeds (i.e. between words). You could use this to put the abilities summary string into a column of cells, instead of one big merged cell. You'd need two more columns of cells plus a couple more single cells to hold the formulas.

David Empey wrote:

Should the same changes be made for STR, CON, DEX, WIS, and CHA?

The new sheet uses the same approach for all abilities. It looks like AT&T has changed something on my service, so now I can't FTP into my own freaking site!

I wonder if they're trying to save bandwidth for the iPhone 4 folks...

Anyway, this pretty much does it for me and AT&T's site, I think. I'm looking into switching over to something else right now, and will have the new file up shortly...

You might want to take a look at the formula for computing Eidolon Evolution Descriptions, in P-Eidolons!A46, where I think you have an erroneous IF() clause, specifically IF(ISTEXT(BH14), which I think should be IF(BH14="",""

As it stands, the formula gives a result of FALSE when no evolutions are selected.

CulinaryMadman wrote:

Running 8.9 now, and I see the Headband of Vast Intellect and how you handled the granted skills, and I like it, quite elegant. But there's a problem. 16 Base INT + 4 for the headband gives a 20 INT. Bonus spells on your Spells page still only show a bonus to cast per day for an INT 16. Does the Headband not increase that, or did I misread a rule somewhere?

The headband should increase bonus spells if it is worn for more than 24 hours (which we assume it is). http://www.d20pfsrd.com/basics-ability-scores/ability-scores#TOC-Ability-Sc ore-Bonuses

Fix:
Change L-Front:AV34 from "=Int_L-MAX(Enhancement_Int_L,Magic_Item_Ability_Enhancement_Int)"
to "=Int_L - IF(Enhancement_Int_L>Magic_Item_Ability_Enhancement_Int,Enhancement_Int_ L-Magic_Item_Ability_Enhancement_Int,0)"

and P-Front:I25 from "=Int_P_14-MAX(Enhancement_Int_P_14,Magic_Item_Ability_Enhancement_Int)"
to "=Int_P_14 - IF(Enhancement_Int_P_14>Magic_Item_Ability_Enhancement_Int,Enhancement_I nt_P_14-Magic_Item_Ability_Enhancement_Int,0)"

Should the same changes be made for STR, CON, DEX, WIS, and CHA?

Solitude wrote:

What would make me happier is a "how to" for adding more magical items : I tried adding more in the "DataMagicItems" sheet, but they don't appear in the choices by type (ex : I added a "body slot" magic item, but can't see it in the dropdown menu for Body magic items).

Upping my question... :D

Solitude, my guess is that you probably need to add items by inserting a row *above* the last row of items, and putting the item info in the new blank row. This should automatically update the magic item range names to include all the items. You'll want to check you can still pick Wings of Flying, though.

David Empey wrote:

KSAC wrote:

KSAC wrote:

Hello there. We're just starting up a Kingmaker campaign and I'm amazed of what you've been able to accomplish in Excel. Wow.

Anyway, here's my questions:

[snip]

2) For my Eidolon, when I select Improved Bite Damage, it changes the die for my CLAWS from d4 to d6. Instead it should change the BITE damage from d6 to d8.

Any idea what can I do to fix these issues?

[snip]

[snip]Any idea about #2?

I can't quite figure out what you're seeing. Where is the CLAW damage for the eidolon listed? I only see bite damage, in the "Attacks" cell on the P-Eidolons sheet. Admittedly this doesn't change when I pick improved bite. I must not be using the same settings you are.

KSAC wrote:

Hello there. We're just starting up a Kingmaker campaign and I'm amazed of what you've been able to accomplish in Excel. Wow.

Anyway, here's my questions:

1) I am creating a first level Summoner. Unfortunately on both my P-Abilities & Feat tabs and L-Abilities & Feat tabs, the Class Abilities says "#NAME?"

2) For my Eidolon, when I select Improved Bite Damage, it changes the die for my CLAWS from d4 to d6. Instead it should change the BITE damage from d6 to d8.

Any idea what can I do to fix these issues?

I forgot to mention that I'm using version 0_8_9

If erian_7 hasn't tracked it down yet, here's a fix (I think it's in fact *the* fix) for 1):

I don't know about Open Office or Mac, but I expect the fix is very similar.

Whew...finally done.

Very nice! Thanks for doing this.