Excel Combat Record Sheet

[dbsousa]

I have written an HD Export Template and Excel Macro that will take files exported from HD and sort them into a Combat Record Sheet. Here are instructions to use them

Download and unzip the attached file (hd-xl.zip)
Place the Export Template (SPD Chart.hde) in the Export Template Folder in Hero Designer
Place the Excel Template in the Template folder in Microsoft Office
Open HD, and Export as many characters as you want to place in a combat sheet using the SPD chart Export Template
Open a New Excel Sheet, using the Combat Order Chart
Type CTRL-Shift A, and an open window will appear.
Select the character file you wish to add to the chart and click open.
The macro reads the character file, inserts in in the chart, and sorts the chart by descending DEX and SPD.

Currently, the chart only sorts 50 characters. If you have more than 50 separate DEXes to keep track of, the macro can be altered to do so. (and good luck running that combat!)

DISCLAIMER These files are offered as is, and by downloading them, you agree to absolve the author of all responsibility for whatever happens to your software, hardware, the Internet at large, or any other consequences. Use at your own risk, etc.

(Addendum) The Zip file was too large to attach, so I will provide a link to the zip file HERE (http://home.attbi.com/~dbsousa/hd-xl.ZIP)

[Derek Hiemforth]

Very nice! One thing you might want to consider tweaking...

It's currently using base DEX and SPD instead of total. So for a character that (for example) gets extra DEX and SPD from a Focus or Only In Heroic Identity or something, it's inserting them in the speed chart at their "normal" DEX and SPD rather than their "super" DEX and SPD...

It's an easy change, BTW. Just replace DEX_VAL and SPD_VAL with DEX_TOTAL and SPD_TOTAL. :)

[dbsousa]

I tried that, but it seems that using SPD_TOTAL generates a fraction (3/4, for example) which Excel reads as a date.

This macro also provides awkward formatting for dual PD and ED scores.

What would really be cool is a Secondary Tag for Characteristics. If Mr. Simon were to add a CHA_SECONDARY tag, I could clean this up with little difficulty. In the meantime, I am experimenting with stripping the primary value from these characteristics in Excel. Don't hold your breath, though. Or wait up. Or check back anytime this week.

[Derek Hiemforth]

Originally posted by dbsousa
IIf Mr. Simon were to add a CHA_SECONDARY tag, I could clean this up with little difficulty.It's already there. It's been there since version 1.09.

I just tested it, and DEX_SECONDARY and SPD_SECONDARY behave as expected, putting only the higher value in the file. :)

[dbsousa]

Cool. I was working from the original manual, so I didn't know they were available...

Is there a current list of available tags?

[Derek Hiemforth]

Originally posted by dbsousa
Is there a current list of available tags? I don't think there's a single master list, no. But the tags that have been added since 1.0 are all listed on the updates page in the description of the version they were added in.

[dbsousa]

I have updated the zip file above to include a Primary and Secondary Characteristic Export Template, and reformatted the PD and ED to accomodate Primary and Secondary Characteristics.

[dbsousa]

If anyone has used this, let me know if it is working for you. I have some ideas for refinements, but I want to know if I should bother to distribute them outside my own gaming group...

[Nato]

Hey, just used it and it does the trick great. I will definitely continue using the sheet so please continue to distribute any updates.

One thing I noticed is that it doesn't insert a character in DEX order until you insert another character. Nothing major.

Just curious, what kind of enhancements are you thinking about?

[dbsousa]

Darn. I thought I fixed that...

I was thinking of adding a second sheet that had a brief summary of levels, martial arts, etc. for each character, similar to the old MetaCreator sheet.

[dbsousa]

I fixed the sort bug.

[Nato]

Sweet.

Yeah, I think those additions you mentioned above would be very cool. I hope you do 'em!