Phaethon
June 10th, 2008, 10:33 AM
Here (http://www.heroscapers.com/community/downloads.php?do=file&id=596)is a link to the Heroscape spreadsheet that I have just uploaded. This spreadsheet includes information from Wave 8, Aquilla's Alliance and Ticalla's Jungle.
Yes, yet another Heroscape spreadsheet. "What's so special about this one", you ask? Well, this spreadsheet has almost all of the information from the unit's card and more! The spreadsheet has 5 separate worksheets: Creatures, Special Powers, One-Page Summary, Hasbro FAQ & Wave Identification. The individual worksheets are explained in detail:
The "Creatures" worksheet has all the information from the Unit Card, plus a simple way to track the number of figures you have. The "expansion" column lists which expansion the figure came in. The next 3 columns list the # of units per set (column D), the number of sets I own (Column E) and the # of figures I have (Column F). If you enter the number of sets that you own, the number of figures is automatically calculated in Column F and totalled at the bottom of the sheet. Also, if you enter any number other than zero into the "# of sets I own" column, the text color in the "Name" column changes to red. The special powers are listed and if you hover over that cell, a comment block appears with the special power/attack wording. Next to the Special Powers is a link to the Hasbro FAQ for that unit (which very well may be out of date by now). Next to the FAQ is the "Grade" column, which is taken from Spider Poison's most awesome "Heroscape Power Ranking" thread (http://www.heroscapers.com/community/showthread.php?t=6171). As with the Special Powers, hovering over the Grade brings up a comment with the text associated with the Grade. Note that Wave 8/AA/TJ releases have not yet been graded.
The "Special Powers" worksheet lists the wording of all the special powers and special attacks from the cards in alphabetical order.
The "One Page Summary" is a much abbreviated version of the "Creatures" worksheet optimized for printing in "landscape" mode.
The "Hasbro FAQ" worksheet has each FAQ entry for each Figure. Unfortunately, this may already be out of date. If it's not out of date as of now, I'm almost positive it will be soon.
The "Wave Identification" worksheet has each of the packages in each Wave. There are several columns that need some explaining. If you have a set, change the "no" in column C to "yes" Column E will be updated automatically. THen type in the number of sets you have in column H (highlighted in yellow) and the total number of figures will be totalled in colum I. Row 79 contains the totals from these columns. In cell E80, the "percent complete" will be calculated (from what now seems to be the defunct "heroscape percent complete" thread).
This spreadsheet is the creation of Slyde. I have only updated it with some information that I found useful. In his sheet, he included photos of each of the figures. Since we now have upwards of 150 units, that added greatly to the size of the file and I have deleted them from this sheet. Slyde plans on updating his sheet when he gets Wave 8 and will include the photos of the new units.
Slyde has given me permission to post this sheet.
If you find this spreadsheet useful, please let us know! Thanks, and we hope you enjoy!
Phaethon & Slyde
PS, some caveats:
The spreadsheet was written in Excel, but works with OpenOffice 2.0 (although some formatting issues with the comment blocks may exist).
Marvel Heroscape figures are NOT included in the spreadsheet except on the "Wave Identification" sheet.
The Hasbro FAQ may be out of date...
The "Creatures" worksheet does not have the information from the Basic side of the card (Realm, # in Expansion)
I have tried to make the sheet as accurate as possible. With that said, if you find an error, please let me know!
Yes, yet another Heroscape spreadsheet. "What's so special about this one", you ask? Well, this spreadsheet has almost all of the information from the unit's card and more! The spreadsheet has 5 separate worksheets: Creatures, Special Powers, One-Page Summary, Hasbro FAQ & Wave Identification. The individual worksheets are explained in detail:
The "Creatures" worksheet has all the information from the Unit Card, plus a simple way to track the number of figures you have. The "expansion" column lists which expansion the figure came in. The next 3 columns list the # of units per set (column D), the number of sets I own (Column E) and the # of figures I have (Column F). If you enter the number of sets that you own, the number of figures is automatically calculated in Column F and totalled at the bottom of the sheet. Also, if you enter any number other than zero into the "# of sets I own" column, the text color in the "Name" column changes to red. The special powers are listed and if you hover over that cell, a comment block appears with the special power/attack wording. Next to the Special Powers is a link to the Hasbro FAQ for that unit (which very well may be out of date by now). Next to the FAQ is the "Grade" column, which is taken from Spider Poison's most awesome "Heroscape Power Ranking" thread (http://www.heroscapers.com/community/showthread.php?t=6171). As with the Special Powers, hovering over the Grade brings up a comment with the text associated with the Grade. Note that Wave 8/AA/TJ releases have not yet been graded.
The "Special Powers" worksheet lists the wording of all the special powers and special attacks from the cards in alphabetical order.
The "One Page Summary" is a much abbreviated version of the "Creatures" worksheet optimized for printing in "landscape" mode.
The "Hasbro FAQ" worksheet has each FAQ entry for each Figure. Unfortunately, this may already be out of date. If it's not out of date as of now, I'm almost positive it will be soon.
The "Wave Identification" worksheet has each of the packages in each Wave. There are several columns that need some explaining. If you have a set, change the "no" in column C to "yes" Column E will be updated automatically. THen type in the number of sets you have in column H (highlighted in yellow) and the total number of figures will be totalled in colum I. Row 79 contains the totals from these columns. In cell E80, the "percent complete" will be calculated (from what now seems to be the defunct "heroscape percent complete" thread).
This spreadsheet is the creation of Slyde. I have only updated it with some information that I found useful. In his sheet, he included photos of each of the figures. Since we now have upwards of 150 units, that added greatly to the size of the file and I have deleted them from this sheet. Slyde plans on updating his sheet when he gets Wave 8 and will include the photos of the new units.
Slyde has given me permission to post this sheet.
If you find this spreadsheet useful, please let us know! Thanks, and we hope you enjoy!
Phaethon & Slyde
PS, some caveats:
The spreadsheet was written in Excel, but works with OpenOffice 2.0 (although some formatting issues with the comment blocks may exist).
Marvel Heroscape figures are NOT included in the spreadsheet except on the "Wave Identification" sheet.
The Hasbro FAQ may be out of date...
The "Creatures" worksheet does not have the information from the Basic side of the card (Realm, # in Expansion)
I have tried to make the sheet as accurate as possible. With that said, if you find an error, please let me know!