Heroscape Collection Calculator - V1.2 with D3 up now

[Dragonmaster384]

I recently decided I wanted to be able to keep track of the number of figures/cards/hexes in my collection, and had enough free time to make a tool to do just that. Basically what I have is a spreadsheet, with pages for each set that currently exists(Classic, Marvel, and D&D, up-to-date through Wave D2 as of now). You simply input the number of each set that you own on the corresponding page, and view the page named "Totals", which will tell you how many figures, cards, and hexes you have, broken down by series(Classic/Marvel/D&D) and type(Common/Uncommon/Unique, Grass/Road/Lava/etc.).

Edit: If it isn't entirely clear to anyone, the only fields you need to change on any of the pages(except 'Extras') are the ones highlighted yellow, these tell the spreadsheet how many of that set you own.

I have now added an 'Extras' page, on this sheet simply input the numbers of each unit/hex/card type that are unaccounted for on the other pages, and it counts them into your totals. /Edit

I plan on keeping this spreadsheet updated as information on each new set comes out, and will post here with any changes I make. I would appreciate any feedback you have on bugs or issues I've missed or any typos I may have made.

I don't plan on this becoming some sort of ultimate spreadsheet, and right now it's just good for tracking a few numbers, however, if you have any feature requests please post them here, and I will see about implementing any I think fit in.

I hope some of you find this as useful as I do.

Current Version: 1.2 - 11/15/2010
Download Links: http://dl.dropbox.com/u/8693356/Hero...tor%20V1.2.ods <----OpenOffice file.
http://dl.dropbox.com/u/8693356/Heroscape%20Collection%20Calculator%20V1.2.xls <----Excel file.

[Deadmaxx]

Dosen't open with Excel.

Originally Posted by Dragonmaster384

I recently decided I wanted to be able to keep track of the number of figures/cards/hexes in my collection, and had enough free time to make a tool to do just that. Basically what I have is a spreadsheet, with pages for each set that currently exists(Classic, Marvel, and D&D, up-to-date through Wave D2 as of now). You simply input the number of each set that you own on the corresponding page, and view the page named "Totals", which will tell you how many figures, cards, and hexes you have, broken down by series(Classic/Marvel/D&D) and type(Common/Uncommon/Unique, Grass/Road/Lava/etc.).

I plan on keeping this spreadsheet updated as information on each new set comes out, and will post here with any changes I make. I would appreciate any feedback you have on bugs or issues I've missed or any typos I may have made.

I don't plan on this becoming some sort of ultimate spreadsheet, and right now it's just good for tracking a few numbers, however, if you have any feature requests please post them here, and I will see about implementing any I think fit in.

I hope some of you find this as useful as I do.

Current Version: 1.0 - 09/06/2010
Download Link: http://dl.dropbox.com/u/8693356/Hero...Calculator.ods
This file should be compatible with pretty much any modern spreadsheet program(Excel, OpenOffice, GoogleDocs, etc.)

[Dragonmaster384]

Originally Posted by Deadmaxx

Dosen't open with Excel.

Hmm. I use OpenOffice and GoogleDocs personally.... I'll see if I can get on a PC that has Excel and try to find something that works for it.

EDIT: Alright, I uploaded a second file in .xls format, see if this one will work:
http://dl.dropbox.com/u/8693356/Hero...Calculator.xls

[Filthy the Clown]

Confirmed: it opened up fine for me, with MS Excel 2007 (of course, older versions should open up the .xls format). I recommend downloading it to your local hard drive first, and then opening the downloaded version.

[Onacara]

I didnt DL it but....does it calculate the terrain that came in booster packs or do you need to add it in manually?

Aslo does it count by unit or by booster or both?

[Dragonmaster384]

Originally Posted by Onacara

I didnt DL it but....does it calculate the terrain that came in booster packs or do you need to add it in manually?

Aslo does it count by unit or by booster or both?

I did count the terrain that comes in the boosters, though there were one or two numbers I wasn't positive on, so if you notice any inaccuracies let me know.

It counts by booster/master set/terrain set, I currently do not have a way to add individual units(eg: You can add the "Golem & Wyrmlings" booster, but I do not currently have a way to tell it that you purchased extra wyrmlings individually). If it is a feature you are interested in, I should be able to add spaces to manually enter in additional numbers, so let me know if this is something you guys want to see. Also, it doesn't tell you how many of each specific unit you have, it simply breaks it down into Common Squad figures, Unique Squad Figures, Common Hero Figures.... you get the idea.

The reason I originally made this was to have an easier way to track my figure/hex counts for their respective threads in General Heroscape Discussion, but if anyone has any other features they'd like added that may not be specifically suited to this purpose I may add them, depending on how much work it would take to implement.

[Onacara]

Originally Posted by Dragonmaster384

I did count the terrain that comes in the boosters, though there were one or two numbers I wasn't positive on, so if you notice any inaccuracies let me know.

It counts by booster/master set/terrain set, I currently do not have a way to add individual units(eg: You can add the "Golem & Wyrmlings" booster, but I do not currently have a way to tell it that you purchased extra wyrmlings individually). If it is a feature you are interested in, I should be able to add spaces to manually enter in additional numbers, so let me know if this is something you guys want to see. Also, it doesn't tell you how many of each specific unit you have, it simply breaks it down into Common Squad figures, Unique Squad Figures, Common Hero Figures.... you get the idea.

The reason I originally made this was to have an easier way to track my figure/hex counts for their respective threads in General Heroscape Discussion, but if anyone has any other features they'd like added that may not be specifically suited to this purpose I may add them, depending on how much work it would take to implement.

Being that alot of people buy/trade for extra squads of figure they like then there should be a way to document it.

[Dragonmaster384]

Originally Posted by Onacara

Being that alot of people buy/trade for extra squads of figure they like then there should be a way to document it.

Not sure when I will have time, but I will try to get this added in later this week, will update the link when I do.

[Dragonmaster384]

Alright, I finally got some time to work work on this. V1.1 is up now, let me know what you guys think.

Originally Posted by Dragonmaster384

I have now added an 'Extras' page, on this sheet simply input the numbers of each unit/hex/card type that are unaccounted for on the other pages, and it counts them into your totals.

[Dragonmaster384]

Just finished adding D3 in, download links in the first post point to the new version.

[El T]

This is good stuff! Just came across it, nice work.