HeroForge!

[Greylock]

Probably a wise move.

I'm loving this sheet a lot. It's not good for the customising I've seen on other's, but it's very user friendly and (I'm just guessing here) fully tested.

You'd have my vote if this were a poll.

 

[GakToid]

BlackBart,

First, thanks.

Second, you posted a quick'n'dirty how-to on adding feats on the first page. Could you post a quick'n'dirty how-to on adding races?

So far I've found:
1) Add race to the 'Race Info' sheet.
2) ?? It has something to do with changing the drop down to include the line with the new race, but I'm not sure the correct way to do it. (Excel newbie)
3) ?? Are there other things to do?

Thanks again.

-Gak Toid

 

[BlackBart]

BlackBart,

First, thanks.

Second, you posted a quick'n'dirty how-to on adding feats on the first page. Could you post a quick'n'dirty how-to on adding races?

So far I've found:
1) Add race to the 'Race Info' sheet.
2) ?? It has something to do with changing the drop down to include the line with the new race, but I'm not sure the correct way to do it. (Excel newbie)
3) ?? Are there other things to do?

Thanks again.

-Gak Toid

General rule of thumb in HeroForge - Don't add data to the end of a list, insert it into the list. Insertion into the list will ensure that all tables are properly adjusted so that those new races, classes, weapons, etc appear in any drop downs or are searched for, etc. That said, formulas in the row above insertion will often need adjustment, as they may have a formula that should point at your newly inserted row, but instead point at the row below (which is the same data it pointed to before).

Also, in the case of races, there is a racial abilities sheet.

 

[GakToid]

Thanks!

It looks like the sheets I need to modify are:
Class Info
Racial Abilities
Race Info

I noticed F7 on Racial Abilities is a pretty full field. Other than that I think it worked pretty well.

-Gak Toid

 

[Ghostwind]

Shannon-

Kudos to the fantastic job you're doing. Any idea when the next update is coming out? I could really use that Epic level support for a campaign I am running.

 

[getyourspotusa]

Quick question

First, Shannon I LOVE the sheet! Heroforge is DA BOMB!

My Question: Maybe it's a quick fix, maybe I'm just dense.

Setup: I usually insert a scratchpad worksheet for preparing item lists, party treasure tracking, etc. For example, let's say I put "Rope, 50 feet" in Sheet1, cell A1.

On Character Sheet II, I go to the first cell in the Equipment listing ("Other Possessions"), and put "='Sheet1'!A1" It reflects the Formula [='Sheet1'!A1], not the value [Rope, 50 feet]...

I tried pushing Ctrl-`, doesn't work.
Am I foolishly missing something? I feel like its a 2-second fix, just can't see it...

Finally, would you accept an Amazon Gift Cert as a token of appreciation for the awesome work you've done, and I have benefitted from, with this program? PM Me.


Sincerely,
Mike Prieto

 

[Mercule]

Hey, Shannon, one general Excel question (that's probably in the Excel help file I'm too lazy to search) that'd help some of us customize HeroForge for our own campaigns:

You use a lot of named regions in HF. Is there a quick way to locate one of those? I just find it a pain to try to figure out some of the formulas you're using.

Thanks.

 

[BlackBart]

First, Shannon I LOVE the sheet! Heroforge is DA BOMB!

My Question: Maybe it's a quick fix, maybe I'm just dense.

Setup: I usually insert a scratchpad worksheet for preparing item lists, party treasure tracking, etc. For example, let's say I put "Rope, 50 feet" in Sheet1, cell A1.

On Character Sheet II, I go to the first cell in the Equipment listing ("Other Possessions"), and put "='Sheet1'!A1" It reflects the Formula [='Sheet1'!A1], not the value [Rope, 50 feet]...

I tried pushing Ctrl-`, doesn't work.
Am I foolishly missing something? I feel like its a 2-second fix, just can't see it...

Finally, would you accept an Amazon Gift Cert as a token of appreciation for the awesome work you've done, and I have benefitted from, with this program? PM Me.


Sincerely,
Mike Prieto

You're missing the fact that I've formatted the cell as a Text cell, so formulas don't work. You can re-format the cells as General and you should be good to go.

 

[BlackBart]

Hey, Shannon, one general Excel question (that's probably in the Excel help file I'm too lazy to search) that'd help some of us customize HeroForge for our own campaigns:

You use a lot of named regions in HF. Is there a quick way to locate one of those? I just find it a pain to try to figure out some of the formulas you're using.

Thanks.

Agreed, a lot of named cells.

There's a couple ways to determined what those names are referring to. If you're lucky (or more to the point, if the sheet that contains the named reference is visible) you can just type the name into the top left are where it indicates the active cell and you'll go right there. Since, more often than not, those sheets are hidden you'll have to generally use a different means. Here you have two options: 1) Insert->Name->Define will bring up a list you can scroll through, though the interface sucks and it's very unwieldy; 2) Insert->Name->Paste->Paste List(It works best if you insert a blank worksheet first) will list all of the names, and their associated references. From there you can first figure out what sheet things are on and go from there.

 

[Mercule]

Groovy. Thanks!