Bixby's Hextreme HeroScape Spreadsheet

[Bixby]

UPDATE:
I have decided not to update this XLS Sheet any further. There are many other great tools out there and the effort to keep this up to date was rather high considering my limited time these days. Thanks for all of the words of encouragement and compliments on the tool. Here is a link to an online army builder that has some nice features.

http://battleplan.mythacle.com/heroscape/


Happy 'Scaping,
Matt


Introduction:
This spreadsheet has been created as a tool for the board game HeroScape. The spreadsheet has a number of tabs and features that any HeroScape player will find useful. The ideas and content on this sheet come from a variety of sources and much credit goes to the members of the fan site www.heroscapers.com (http://www.heroscapers.com) Their creativity and constant exploration of the game system has been the inspiration for this spreadsheet.

It should be noted that the only cells you should enter values in are all shaded yellow and have a cell border highlighting them.

Current Version:
9

Release Date:
V9 - July 2009
V7.0 - Fall 2008
V5.2 - October 3rd, 2007
V5.0 - September 4th, 2007

Download Location:
Version 9 - http://www.heroscapers.com/community/downloads.php?do=file&id=1615
Version 7.0 - http://www.heroscapers.com/community...do=file&id=921 (http://www.heroscapers.com/community/downloads.php?do=file&id=921)
Version 5.2 - http://www.heroscapers.com/download/?dlid=883
Version 5.0 - http://www.heroscapers.com/download/?dlid=803
Version 3.1 - http://www.heroscapers.com/download/?dlid=649

Products Included in the Spreadsheet:
All official HeroScape Product is included.

Known Issues:
n/a

Major Features...

Roster Tab:
The roster tab contains all of the information about all of the units in the game. This includes all of the officially released information and some great add-on information from the www.heroscapers.com (http://www.heroscapers.com) discussion forums, such as Links to all of the Books of HeroScape and Power Rankings. You can indicate the quantity of each unit you own in the yellow column provided. The Power rankings have been updated to correspond with what has been published on Heroscapers as of June 30th, 2009.

Unit Details Tab:
This part of the spreadsheet is used to examine a unit in detail. All information available for each unit is presented on one screen. This includes the Bio, official errata, card details, special abilities, and a few other odds & ends.

List Builder Tab:
This section of the spreadsheet pulls data from the roster tab and gives you the ability to look at subsets of units by a selection of filter criteria. Unlike most spreadsheets that use filters, this one only has one filter. YES – unit meets my selection criteria, or no it does not. Instructions for using the filters are located on the tab. Give it a spin.

Army Creator Tab:
This section lets you specify a draft amount and then select units for your army. The stats section at the bottom will give you an indication of your army composition as it pertains to movement, attack ratings, defense ratings, etc. The army creator will also alert you to the size of starting zone required to field your army. There are a couple of graphs that analyze your selection by faction.
This page has been formatted to print on a single 11 x 8.5 page for easy use and reference.

Collection Tab:
This tab references the Product and Roster tabs to find out what you inicated you own. It also gives you a place to indicate what you wish to buy to complete your collection. Some basic collection analysis is provided at the end of the sheet. This can be expanded in future releases based on suggestions and feedback.

Stats Tab:
This part of the spreadsheet contains some very basic statistics about the composition of units released by Hasbro. You can see at a glance the distribution of units over the various factions, species, personalities, worlds, etc.

Graphs Tab:
This is a visual representation of some of the information from stats tab.

M/A/MA Rules Tab:
Our gaming group has come up with these rules for epic games and large maps. These rules may not be for everyone, but they have been a staple of our games for over three years. If you like playing with larger groups on larger maps, give this a look.

Red Colored Tabs:
These sheets contain the control information for the sheet. This drives the validation lists, pull down menus, lookup tables etc.
- - - - - - - - - - - - - - - - - - - -
Please feel free to post your comments and suggestions in this thread.
Regards,
Matt

[Aldin]

Oooooooooh - I can't wait to take this for a spin tonight!

~Aldin, spreadsheet slave

[Aldin]

Pretty nifty, Bixby. I can see you've put a lot of work into it and it will remain part of my arsenal in riding herd on my armies.

One note for those less familiar with Excel is that the order of units in the pull down lists for the Unit Details and Army Creator tab is the same as the order of those units in the Roster tab. To make them alphabetical, highlight cells B3 through AB104 and select from the menu Data->Sort. In the box choose Sort by: Column B - Ascending and hit "Okay". This will make your unit lists alphabetical without messing up the data associated with the characters.

I look forward to seeing more knobs and buttons in the next release :D

~Aldin, happy to have more tools with which to play

[Grim]

Very cool. Thank you for your efforts.

[ChilliDog]

Awesome, thanks for this Bixby.

[mecha frog]

I am only posting this because you asked for any other features we might like to see. The spreadsheet already scores 10 out of 10 in any category imaginable!

Pictures? I took a database course back in the day and one assignment was to reference a photo for specific entries. It would be very cool if the unit details tab had the army photo. Not the whole card, just the part with the figures.

frog

[yagyuninja]

Just wanted to say that this is fantastic. :)

[Bixby]

Everyone:
Thanks for your kind words.

Aldin:
Thanks for pointing out the sort for folks. I will add some Sort Macros to the spreadsheet.

Mecha Frog:
I would love to add pictures, alas, this is a spreadsheet and not a database. I honestly do not know how to add images as addressable cell content other than include as a comment but that does not let me use the image easily in page layouts. If anyone more savvy than I can assist in this I would be happy to include pictures. At this point, I really do not see how this is feasible.

[Bixby]

Eureka!! Aha!! Yippee!!

Guess who just figured out how to get clickable images into his spreadsheet. I am pleased as this was bothering me. The solution may not work well for others so I will post some of the details here.

Basically, it is not possible to include an image as row content in a spreadsheet. It is possible to have a comment in a cell that contains an image, but that can be problematic as well. The following line shows how you can have a column that basicaly contains a hyperlink to teh actual picture.

=HYPERLINK("file:///E:\Official HeroScape cards\"&B9&".jpg","Click Here")

The contents of cell B9 is the name of the actual card. The above statement builds a hyperlink to the image. As you guessed, I have a folder called "Official HeroScape Cards" with all of the official HeroScape card images. I named all of the images the exact name as the card title for ease of referencing. This works very well. :)

Now the downside, my directory of Heroscape cards is a folder that is 24MB in size. It works well for me, but anyone wishing this feature will have to have a folder with all of the heroscape card images in JPG format and the image names need to be the same as the card title. I could share my entire folder, but 24MB is rather large.

Any comments...

[bad_calvin]

yes, provide a link! :)
I think for the imagery and quick reference it is worth the heavy download.

[countblah]

Bixby Roxx.

[yagyuninja]

Cool! I'd download that.

[Bixby]

Thanks y'all.

I will make a few more revisions then find a site where I can host the zip file. Give me a week or two to get this packaged up then I will post the update and location of the file.

-Bix

[bad_calvin]

if we have to, I can set up a gmail account that we can all share.

[Bixby]

Ok gang.

I have links to Card images working well and it was easy as pie. I also added a column on the Roster tab that links to the discussion on Heroscapers for the units I found discussions on. I am trying to add as much function and information to the spreadsheet as I can.

I have added a couple of other columns on the spreadsheet, one for unit BIO and another for unit strategy. I was able to get teh PDF documents but I cannot copy the text from those documents. Does anyone have the BIO and/or strategy information in a format that I can copy from? MS Word perhaps? When I have all of this information and get it entered, I will look to share the next version with y'all.

Thanks in advance...
...Bix

[bad_calvin]

ASK MALECHI,
He did a pdf of all the bio's. He may have a text format of those available.

http://www.heroscapers.com/community/profile.php?mode=viewprofile&u=6

[Bixby]

Alrighty then 'scapers:

Version 1.4 of the Spreadsheet is now done, I need to find a way to package it for download. Now that the spreadsheet has linking ability to all of the official card scans, the folder with the images and spreadsheet is now 24MB in size. (Winzip did not compress much as the images are pre-compressed).

What is in this release...
...Added a name to the Army Creator
...Added a column to the roster that links to Card images.
...Added a column for Strategy notes to the Roster.
...Added a column for BIO information on the Roster.
...Added a column to the roster that links to HeroScapers Discussion.
...Added a cell in the Roster that contains path to directory for card images.
...Added a sort Macro to the Roster to control how the units are sorted.

When I find out how and where I can share this, I will post the directions here...


EDIT: Anyone know of a good file sharing site where I can post a file/folder of this size for y'all to download from?

[Bixby]

I have submitted the latest version to the Downloads Section. It is just awaiting approval. I did not include all of the card images as that would make the file huge. If someone knows where I can host a 24MB file I will post there. Until then, if you have images of all of the cards, just make sure the image name is the exact same name as the card name and put all of your images in one folder. When you use the spreadsheet for the first time go to the Roster tab and put the file path in the space provided, then all of the image links will work fine. For example: C:\HeroScape Cards\

Taking suggestions for the next release. I look forward to your feedback and comments.
-Matt

[Bixby]

New version posted. (Version 3.1) See the first post in this thread for link & details.

[LordEntropy]

Thanks Bixby this is absolutely excellent.

I am playing a lot of 'scape but don't own all the figs although I have friends that can lend me. Up till now I have stuck with armies comprised of the figs I own as I never had the stats for the other units to refer to.

This now solves that problem completely. A fantastic piece of work.

[Sir Flak]

Can't wait to see wave 7 included :)

Thanks for your hard work Bixby.

[Bach]

Thanks for doing this, man! :D

[tgskt7]

I also posted a spreadsheet in the downloads section. It sounds like Bixby's has some stuff in it I didn't do. It does have all the figures (as far as I know) up thru wave 7 but without Marvelscape. I'd appreciate any feedback. Now I'm going to download Bixby's and check it out.

Mine is http://www.heroscapers.com/download/index.php?dlid=735

I made it for my own use, just thought I'd post it here and see if anyone else liked it. I did it in Quattro Pro. I saved as Office 97 file type for Excel users, should work OK.

Excel version http://www.heroscapers.com/download/index.php?dlid=736

[Bixby]

Hello All:

I am about to start my updates for the next version. I am planning on adding all of the Wave 7 Units, ComicCon Exclusive, and the Marvel units.

What other features should I consider adding for the next release. I will entertain all suggestions and even try to do some of them. :)

Thanks in advance...
...Matt

[tgskt7]

I tried to download yours, Bixby, but couldn't open it. I have Quattro Pro, which usually is able to open Excel spreadsheets no problem. Any ideas? I'd like to see what yours is like. Does Excel let you save in Wordperfect format?

[Bixby]

Not sure how much effort to put in this tgskt7: I have macros, lookup tables, named ranges, and validation lists in my Excel sheet. Not sure if they would easily transalte into Quattro. Sorry.

[Bixby]

Hello folks:

I have been busy adding information to the next version of the Excel spreadsheet. Included in the next release is Wave 7, MarvelScape, and this year's promo figure.

The spreadsheet is starting to grow in function and complexity. I would like to have a group of about a 1/2 dozen or so people willing to kick the tires on a release before I send it out to the masses. I would like published versions to be realtively clean of errors and omissions.

If you are interested in getting an advance copy of the spreadsheet before mainstream release and do some beta testing for me... PM me your email address and I will add you to my pre-release list.

Thanks,
Matt

[bad_calvin]

The macros were not working for some reason. I am not familiar with macro's nor how to remedy them. So some of the dropdowns and buttons, and sorts were not working for me.

I have to say though. This thing is HUGE. Holy cow did you ever put some work into this. A very valuable resource for the game indeed. I am going to be looking this over more the next few days at work and home.
Thanks for the advance copy.

[TOG]

The macros were not working for some reason. I am not familiar with macro's nor how to remedy them. So some of the dropdowns and buttons, and sorts were not working for me.

I have to say though. This thing is HUGE. Holy cow did you ever put some work into this. A very valuable resource for the game indeed. I am going to be looking this over more the next few days at work and home.
Thanks for the advance copy.

Normally when macros are involved, you will get a popup telling you so. If you clicked the wrong choice, the macros are disabled.

[bad_calvin]

The macros were not working for some reason. I am not familiar with macro's nor how to remedy them. So some of the dropdowns and buttons, and sorts were not working for me.

I have to say though. This thing is HUGE. Holy cow did you ever put some work into this. A very valuable resource for the game indeed. I am going to be looking this over more the next few days at work and home.
Thanks for the advance copy.

Normally when macros are involved, you will get a popup telling you so. If you clicked the wrong choice, the macros are disabled.

It said something around the lines of having to change the security level?

[TOG]

It said something around the lines of having to change the security level?

Tools > Options > Security > Macro Security.... Try setting it to medium.

[Bixby]

It said something around the lines of having to change the security level?

Email me the screen shot BC and I will check into it. Also, let me know what version of MS Excel you are running.

-Matt

[bad_calvin]

Ok, it doesn't give me the error. Now when I click the sort button for example it just highlights as if it were a graphic. If I double click it goes into some gobbilty goop. it looks like the strings of code to make the macros work, it opens a new window for that code.

I have excel 2003

BTW, I can sort by just highlighting it and data->sort I was just trying to say that the "button" ins't working.

I love the links to the books on the forums. Nice touch. :)

[Bixby]

I run Excel 2003 as well and the Macro for the sorts works fine. What values are in the two drop down boxes to the left of the sort when you click it?

[bad_calvin]

I run Excel 2003 as well and the Macro for the sorts works fine. What values are in the two drop down boxes to the left of the sort when you click it?

I don't know why, but it works just fine now. *rolls eyes* . This is freaking sweet.

Criteria Sorting for Unit Roster:
It would be nice if the button allowed you to sort by race, class, and personality though for quick look ups for themed armies. I suppose that is what the list builder does though.

List Builder:
I noticed that Marvel was not on this list yet, I assume since you have "game system" that is something you are planning on adding? The list builder is a an awesome quick resource.

I don't really see the reason why the roster and the list builder are separate. They appear to have the same use, but one has more function then the other depending on the situation.

Army Creator:
With all the sweet facts on the Army Creator sheet (at the bottom) it would be kind of neat if it told you how many "special markers" to grab.

I love the General Statistics page. This shows so much nerdy information I am in heaven. :)

The Mama rules sound very intriguing I want to five this a go on my next game. I wonder though, do you allow folks to put the same number on the same fig? I see the limit of three markers to a card, but not a limitation for having the same number on the card. Unless I am just missing it.

Thanks for the sneak peek on the sheet, this EXTREMELY resourceful. I have not checked stats to check for accuracy, but I assume that has probably been once overred about a billion times. lol

good stuff man, people that have not got the sneak peek of this don't know what they are missing.

[Bixby]

Criteria Sorting for Unit Roster:
It would be nice if the button allowed you to sort by race, class, and personality though for quick look ups for themed armies. I suppose that is what the list builder does though.

List Builder:
I noticed that Marvel was not on this list yet, I assume since you have "game system" that is something you are planning on adding? The list builder is a an awesome quick resource.

I don't really see the reason why the roster and the list builder are separate. They appear to have the same use, but one has more function then the other depending on the situation.

Army Creator:
With all the sweet facts on the Army Creator sheet (at the bottom) it would be kind of neat if it told you how many "special markers" to grab.

I love the General Statistics page. This shows so much nerdy information I am in heaven. :)

The Mama rules sound very intriguing I want to five this a go on my next game. I wonder though, do you allow folks to put the same number on the same fig? I see the limit of three markers to a card, but not a limitation for having the same number on the card. Unless I am just missing it.

Thanks for the sneak peek on the sheet, this EXTREMELY resourceful. I have not checked stats to check for accuracy, but I assume that has probably been once overred about a billion times. lol

good stuff man, people that have not got the sneak peek of this don't know what they are missing.

Thanks BC. I really appreciate your testing and feedback. Appreciate the kind words too man.

You are right with the sort ing on the Roster. I left it to the main things people would use to sort by when drafting an army. The sort on teh roster controls how the units appear in the drop down lists in both the Army Creator and unit details tab. That is the main point of the sort.

The list builder is the newest addition to the spreadsheet and was largely inspired by the definitive lists on this website that RevDyer has started. I tried to think of a way to build the lists automatically so as units were added, the lists could dynamically be recreated. That is where I give the ability to filter by Personality, Species, World, Class, etc...

All of the Marvel units show up in the list builder. For instance, blank out all of the criteria except for Valiant Personality and re-filter and you will notive Silver Surfer in the mix. Let me know if you cannot get it to show and I will look into it further.

Roster is the source data for all of the units. I typically have the source data and the filtering of it on different sheets to keep those functions seperate. Just a design element I have adopted over the years. You will notice that the CONTROL sheet is all data I use in other parts of the spreadsheet to control drop down lists etc. Short answer is: I add all of the units to teh Roster Tab and it feeds the other tabs and drop downs. Hope that makes sense :)

Unit Details
By special markers are you referring to Morsbane and Samurai Markers? Good Idea. I will add that.

Stats
Glad you like the stats. I plan to add synamic graphs in a future release.

M/A/MA Order Marker Rules
Yes limit of three markers per card, they can all be the same number if you like :)

Again. Thanks a ton for your testing efforts and comments. Keep 'em coming...
...Matt

[bad_calvin]

My Brother came down this past weekend and we played some 1,000 point games using your M/A/MA rules. Usually when we play a game of this scale we just double up the order markers. After reading your house rules though we thought this may be a very cool avenue of the game to try. I have one word that comes to mind when describing what we thought about the m/a/ma house rules.

"sold"

Yes, we are sold on the idea and we will continue to use them from now on when playing these large games. At the core it is really "doubling up" on the order markers, however using the move only, attack only, then move attack markers in this manner actually adds more "strategy" to the order marker placements.

Well done, and anybody that wants to play some larger games of HS should check out these very simple rules. They work great and make for a fast paced "epic" game of HS.

[Mycophycophyta]

Is today the general public's release date?

[Bixby]

The New Release (V5.0) is now in the download section. See the first post of this thread for details on the release and download link.

Lots of changes since 3.1, so let me know what you think.
-Matt

[Roland]

Two words
Awesome

[Elimite]

This worksheet is awesome. It really makes building armies easy. Thank you for the time and effort you put into this.

When is SotM going to be added in?
If not soon can you give instructions on how to add it in myself?

Thanks

[Bixby]

New Version is up. See the First post in this thread for download location and specifics included....

[loborocket]

This tool is very nice. I did find one error. When using the list builder and setting the personality filter value to "valiant" the 4th Mass does not appear in the generated list.

[Bixby]

Thanks Lobo. What version of the spreadsheet too do you have. I was going to wait until there is more HeroScape product out before I publish a new release.

If you want you can PM me your email address and I will send you an interim version.

Thanks again for letting me know of the problem. Happy 'scaping...

[yagyuninja]

OK, I'm ready for the new version now... ;)

Seriously, I've grown addicted to this thing and its hard to function without the new units in it. Thanks so much for this though!

[Bixby]

Hey there 'Scapers:

It is high time for me to update my Spreadsheet, (I have received a few gentle prods and motivations). :) I have a question for you:

What features are you most interested in?

There is no shortage of spreadsheet and web tools for HeroScape, so I did not want to recreate what has already been done. Some of you may want an all-in-one resource, while others may want something lean and mean. My spreadsheet is in need of an overhaul as all of the links to the various books no longer function with the new HeroScapers website. I am very interested in getting some feedback from teh community before I commence the journey to get the next version released.

For those of you unfamiliar with the previous version, here is a list of some of the features and highlights...


Major Features...
Roster Tab:
The roster tab contains all of the information about all of the units in the game. This includes all of the officially released information and some great add-on information from the www.heroscapers.com (http://www.heroscapers.com/) discussion forums. The data on this sheet can be sorted via two pull down boxes and a Sort Macro button. Select the primary and secondary sort criteria in the drop down box, then click the sort button. The sort of the units on the roster tab will control how the units appear in various drop down selection boxes used on other tabs within the spreadsheet. You can sort by:
- Character Name
- Unit Cost
- Faction
- Attack Rating
- Defense Rating
- Movement
- Range
- Life Points

Unit Details Tab:
This part of the spreadsheet is used to examine a unit in detail. All information available for each unit is presented on one screen. This includes the Bio, official errata, card details, special abilities, and a few other odds & ends.

List Builder Tab:
This section of the spreadsheet pulls data from the roster tab and gives you the ability to look at subsets of units by a selection of filter criteria. Unlike most spreadsheets that use filters, this one only has one filter. YES – unit meets my selection criteria, or no it does not. Instructions for using the filters are located on the tab. Give it a spin.

Army Creator Tab:
This section lets you specify a draft amount and then select units for your army. The stats section at the bottom will give you an indication of your army composition as it pertains to movement, attack ratings, defense ratings, etc. The army creator will also alert you to the size of starting zone required to field your army. There are a couple of graphs that analyze your selection by faction.

Stats Tab:
This part of the spreadsheet contains some very basic statistics about the composition of units released by Hasbro. You can see at a glance the distribution of units over the various factions, species, personalities, worlds, etc.

Graphs Tab:
This is a visual representation of some of the information from stats tab.

Web Links Tab:
This is a place where I include interesting links pertaining to HeroScape or games in general that I feel are worth book-marking.

M/A/MA Rules Tab:
Our gaming group has come up with these rules for epic games and large maps. These rules may not be for everyone, but they have been a staple of our games for well over a year. If you like playing with larger groups on larger maps, give this a look.

Control Tab:
The control tab is a convention I started a long time ago. It is the sheet where I put “most” of the data for validation lists, pull down menus, lookup tables etc. There is a lot of data here, quite a bit of it is in preparation for future enhancements of the spreadsheet.

Ideas For Consideration
Collection Tab - Enter a number for each product release and have your total hex count, figure count, and dollar count calculated. You may not want to know. :smile:

[Hahnarama]

Hey there 'Scapers:

It is high time for me to update my Spreadsheet, (I have received a few gentle prods and motivations). :)

I have no idea what you are talking about.

[dickflea]

Excellent spreadsheet Bixby. I particularly like the Pics of the characters that appear as notes in their name cell. Keep that if possible.

[yagyuninja]

I don't know what about it I would want changed. I guess I'm in the all-in-one resource camp, though. :)

[Wytefang]

As long as you keep the unit descriptions and the army-building aspect which updates info on the fly, I'm content (of course after you add all the new Wave 8 and Wave 8.5 stuff, that is!)...

:D :D :D

By far your spreadsheet is the best and most feature-filled. Thank you on behalf of all your users!

[Bixby]

Excellent spreadsheet Bixby. I particularly like the Pics of the characters that appear as notes in their name cell. Keep that if possible.

Uh, er, ummmmm. My spreadsheet does not have pictures Dickflea. Not sure whose spreadsheet you are referring to?????

[dickflea]

Excellent spreadsheet Bixby. I particularly like the Pics of the characters that appear as notes in their name cell. Keep that if possible.

Uh, er, ummmmm. My spreadsheet does not have pictures Dickflea. Not sure whose spreadsheet you are referring to?????

Hmmm...interesting, i may indeed be mistaken. Never mind keep up the good work.:D

[S1R_ART0R1US]

The Collection Tab seems cool, and very useful. I've actually never seen this before and it looks quite interesting.

[madmuppet]

Any plans to add wave 8? I need my fix man!

[Bixby]

Any plans to add wave 8? I need my fix man!
Working on it. I am re-architecting some things to make easier maintenance. Also, with the reorg of this website all of the unit links to "the Books of HeroScape" stopped working.

Sorry for the delay, there are a lot of changes in the next release and I am streamlining the sheets.

Cheers,
Matt

[madmuppet]

Ok. Looking forward to it!

[mecha frog]

Any updates available on the new version? Your spreadsheet is in my top three favorite things about Heroscape (it's right up there with the minis and the terrain).

Thanks,
m.frog

[Hahnarama]

The Bixby-man is on holiday for another week or so. He said once he gets back he will start working on the new update.

[bunjee]

Known Issues:
Some people are receiving the error:
“Runtime error '1004'. This operation requires the merged cells to be identically sized.”
This is only happening with a few people and I have not been able to replicate and locate the source of the error. It only happens when using the sort function on the ROSTER tab. Remains a mystery???


Hi Bixby, and thank you for this roster, it rules.

I wanted to let you know that I know the cause of the known issue quoted above.
On the Roster tab, the header section of Columns C and D is a merged cell. If you select a column that isn't part of the autofilter, such as Character Name (B) or Unit Cost (F) and go to Data>Sort Excel will often have the "My list has" radio button for "no header row" selected. If you don't set it to "header row" the sort works without the error.

So the solution is to un-merge the "Heroscaper Discussion Thread" header cell for Columns C and D.

I'm currently using the beta 7.0a version.

[Hahnarama]

FYI I've been trying to break the new version for about a week now. It looks pretty solid.

[Bixby]

Known Issues:
Some people are receiving the error:
“Runtime error '1004'. This operation requires the merged cells to be identically sized.”
This is only happening with a few people and I have not been able to replicate and locate the source of the error. It only happens when using the sort function on the ROSTER tab. Remains a mystery???


Hi Bixby, and thank you for this roster, it rules.

I wanted to let you know that I know the cause of the known issue quoted above.
On the Roster tab, the header section of Columns C and D is a merged cell. If you select a column that isn't part of the autofilter, such as Character Name (B) or Unit Cost (F) and go to Data>Sort Excel will often have the "My list has" radio button for "no header row" selected. If you don't set it to "header row" the sort works without the error.

So the solution is to un-merge the "Heroscaper Discussion Thread" header cell for Columns C and D.

I'm currently using the beta 7.0a version.


Thanks Bunjee.

I do not think the problem will occur on the 7.0a version. I removed all of the macros. It was odd that that error only occured for some people though.

I think I will upload 7.0a for prime time use.

[Bixby]

FYI I've been trying to break the new version for about a week now. It looks pretty solid.

Thanks amigo. Appreciate you being my test subject.

[Fuzzie Fuzz]

Hey, sorry if I'm being blind, but I can't find a working download. This looks really cool, and I'm eagerly anticipating trying it out.

[Bixby]

Hey, sorry if I'm being blind, but I can't find a working download. This looks really cool, and I'm eagerly anticipating trying it out.
No worries. I do not think it has been approved yet.

I just submitted the latest version to the download section earlier tonight. Once it has been approved by an admin, I will post a link directly to the download.

Cheers,
Bixby

[Fuzzie Fuzz]

Cool, thanks!

(By the way, you have my favorite avatar ever.)

[bunjee]

Known Issues:
Some people are receiving the error:
“Runtime error '1004'. This operation requires the merged cells to be identically sized.”
This is only happening with a few people and I have not been able to replicate and locate the source of the error. It only happens when using the sort function on the ROSTER tab. Remains a mystery???


Hi Bixby, and thank you for this roster, it rules.

I wanted to let you know that I know the cause of the known issue quoted above.
On the Roster tab, the header section of Columns C and D is a merged cell. If you select a column that isn't part of the autofilter, such as Character Name (B) or Unit Cost (F) and go to Data>Sort Excel will often have the "My list has" radio button for "no header row" selected. If you don't set it to "header row" the sort works without the error.

So the solution is to un-merge the "Heroscaper Discussion Thread" header cell for Columns C and D.

I'm currently using the beta 7.0a version.


Thanks Bunjee.

I do not think the problem will occur on the 7.0a version. I removed all of the macros. It was odd that that error only occured for some people though.

I think I will upload 7.0a for prime time use.Hmm, not sure I was clear. I am using the 7.0a version (got it from Hahnster) and the sort issue occurs in there. It isn't really a macro problem, this is something that always happens when trying to sort and a merged cell spans non-merged columns.

I tried to go to the downloads to approve your upload, but I'm not finding it. I'll keep my eye on the thread and the downloads to get it approved.

[Bixby]

Hmm, not sure I was clear. I am using the 7.0a version (got it from Hahnster) and the sort issue occurs in there. It isn't really a macro problem, this is something that always happens when trying to sort and a merged cell spans non-merged columns.

I tried to go to the downloads to approve your upload, but I'm not finding it. I'll keep my eye on the thread and the downloads to get it approved.

Bizarre. I never saw this message until today. Not sure why the sort issue would happen in version 7.0a as it no longer has a sort option. I removed the buttons, the macros, and the sort options. (Unless you were manually trying to sort the data).

I added the file to the uploads section but I will try again. Not sure why it did not register. Universe is strange this week.

Thanks again.
-Matt

[bunjee]

The file wouldn't up load because xls was not an allowed extension. I fixed that problem and it is up now. I even pinned it:
http://www.heroscapers.com/community/downloads.php?do=file&id=921

I was sorting manually, I wanted to sort by point cost and that wasn't set with the autosort.

The version of 7.0a that I uploaded still has sort options available for many of the columns in the roster. I don't know why you would want to remove those, but I do suggest making unit cost a sort option, I use that a lot.

[Bixby]

The file wouldn't up load because xls was not an allowed extension. I fixed that problem and it is up now. I even pinned it:
http://www.heroscapers.com/community/downloads.php?do=file&id=921

I was sorting manually, I wanted to sort by point cost and that wasn't set with the autosort.

The version of 7.0a that I uploaded still has sort options available for many of the columns in the roster. I don't know why you would want to remove those, but I do suggest making unit cost a sort option, I use that a lot.
Ahhh. Those are autofilters, not sort. Makes sense now. I used to have a really cool Sort Macro that was awesome on most PC's but it would not work on others so I removed it.

Thanks again.

[bunjee]

Yeah, sorry, my bad with using the wrong words. I knew it was an Autofilter, but kept saying sort.

I would still love to see the points added in.

[spider_poison]

I don't think I've ever "bumped" a thread, but I use this spreadsheet all the time and think it's really awesome. It's got a lot of views as well, so I know I'm not alone. Great work, Bixby :D

[skyknight]

I don't think I've ever "bumped" a thread, but I use this spreadsheet all the time and think it's really awesome. It's got a lot of views as well, so I know I'm not alone. Great work, Bixby :D
Neg rep coming your way SP:shock::o;)

[Hahnarama]

I don't think I've ever "bumped" a thread, but I use this spreadsheet all the time and think it's really awesome. It's got a lot of views as well, so I know I'm not alone. Great work, Bixby :D

Yup it rocks.

I keep copies of my armies stored on another spreadsheet so I can be ready to game with a moments notice. :p

[Bixby]

Thanks gang. Good to know it is getting some use. It was a labour of love. :)

[spider_poison]

I don't think I've ever "bumped" a thread, but I use this spreadsheet all the time and think it's really awesome. It's got a lot of views as well, so I know I'm not alone. Great work, Bixby :D
Neg rep coming your way SP:shock::o;)

Don't even try it...I'll neg rep you into oblivion :twisted:

Mods, could this thread possibly get stickied? I think it's certainly at least as useful as other stickied threads. I don't mean that in a bad way to the other threads at all, but I think lots of people find this one very useful.

[bunjee]

Stickied, I may end up pulling the LandScape sticky as (sadly) Logrey has not been able to continue developing it.

[Bixby]

Gosh. Thanks. I never thought I would be stickied. ;)

Seriously, glad people find this of use.

[southwest ninja]

Gosh. Thanks. I never thought I would be stickied. ;)
be careful what you wish for:twisted:

[patzymur]

Hi Bixby,
Your spreadsheet is one of my favorite resources on the 'scapers site. I'd like to thank you for that. I hope you are planning on updating for Wave 9. Also, if you would find it helpful, I'd like to volunteer to copy the special abilities text from the card previews that Truth is posting into a text document and forward to you. That way you could just copy/paste into your spreadsheet update. It's not a huge help, but if it would make it easier on you, I'd like the chance to do it.

Thanks,
Patzymur

[Bixby]

Patzymur:
Thank you for the kind words. I do plan on updating the spreadsheet. Your offer is very much appreciated and I will gladly take you up on it. Thanks.

Everyone:
Are there any errors, omissions, or other items I should look at adding into the next release? Let me know...

Regards,
Bixby

Hi Bixby,
Your spreadsheet is one of my favorite resources on the 'scapers site. I'd like to thank you for that. I hope you are planning on updating for Wave 9. Also, if you would find it helpful, I'd like to volunteer to copy the special abilities text from the card previews that Truth is posting into a text document and forward to you. That way you could just copy/paste into your spreadsheet update. It's not a huge help, but if it would make it easier on you, I'd like the chance to do it.

Thanks,
Patzymur

[TOG]

Everyone:
Are there any errors, omissions, or other items I should look at adding into the next release? Let me know...

A print feature on the Army Builder would be nice. Restoring the sort features while leaving the Army Builder in Alpha order would be cool as well.

[Bixby]

Everyone:
Are there any errors, omissions, or other items I should look at adding into the next release? Let me know...

A print feature on the Army Builder would be nice. Restoring the sort features while leaving the Army Builder in Alpha order would be cool as well.

What kind of print feature? I print the page and it is optimzed everytime I print my army. Let me know what your thoughts are on this...

As far as the sort goes, that required recording a macro and the macro was one of the things giving people grief before so I removed it. Sorry. :(

Anyone comfortable in Excel can highlight the range in the roster and click the sort button in Excel. Just note that the order of the Roster will ALWAYS be the order the units show up in any of the pull down lists on the other spreadsheet tabs. Just the nature of Excel.

[Hahnarama]

Everyone:
Are there any errors, omissions, or other items I should look at adding into the next release? Let me know...

A print feature on the Army Builder would be nice. Restoring the sort features while leaving the Army Builder in Alpha order would be cool as well.

copy/paste special your armies into a new workbook. You can print form there if you like.

I'm not sure what you are referring to with the sort feature beyond a data filter.

[Bixby]

When I use Print on the Army Creator Tab, I get a perfect 1 page printout showing:

Unit Selection and info about each unit
Army Analysis section
Graph section

Not sure what else is needed?

[patzymur]

Patzymur:
Thank you for the kind words. I do plan on updating the spreadsheet. Your offer is very much appreciated and I will gladly take you up on it. Thanks.

Everyone:
Are there any errors, omissions, or other items I should look at adding into the next release? Let me know...



Hi Bixby,
Just PM'd you for your email address to send text to.

For a feature request: There's only one thing that I'd find useful that may be reasonable to add. I've gotten along without it for plenty of time, so it's not a biggy. I just have to do an occasional manual sanity check. The feature would be to have a personal inventory number in the spread sheet. On the product info tab you have a Quantity Owned field, but that's by pack instead of unit, and doesn't seem to tie in anywhere else. Due to some ebay purchases and trades, I have some units where the quantity of that unit doesn't match that of its pack mate. Maybe allow this to be edited on the Roster tab, and then have a column in the Army Creator and List Builder tabs to utilize the info. I could also imagine some stats/graphs showing how complete your collection is by various categories: common/unique/exclusive, by wave, by faction...
But honestly - if it gets updated with Wave 9, I'm totally happy.

Thanks,
patzymur

[Bixby]

Let me see what I can come up with. Thanks for the feedback and suggestions!!!
-Bixby

[Marcus Decimus Gallus]

FYI, I am in the same boat as patzymur and I echo his suggestions.

[Bixby]

I am auditing / updating the Power Rankings for all of the units in the Roster. Have rankings been established anywhere for the Wave 9 Units?

[Hahnarama]

Nope.

[Bixby]

Ok.

I have got the new wave 9 units added along with all of the support information. I updated the rankings to be current with what is on this site. I have all of the units linked to their appropriate "Book".

Here is a call for help:

I have added a Collection Analysis Tab that I am working on. If the following information exists in a concise format it will expedite my efforts.

MSRP on each of the product releases.
Product # on each of the product releases.
Detailed contents on each of the product releases. (Dice, hex breakdowns, etc).

[madmuppet]

Ok.

I have got the new wave 9 units added along with all of the support information. I updated the rankings to be current with what is on this site. I have all of the units linked to their appropriate "Book".



Cool... can't wait to use it!

[Bixby]

Thanks.

I should be able to finish this by the weekend if I can track down some of the additional information I am looking for.

[Hahnarama]

Weekend?

LAME. :-)

[Bixby]

ha ha ha

[Bixby]

Anyone...

Ok.
Here is a call for help:

I have added a Collection Analysis Tab that I am working on. If the following information exists in a concise format it will expedite my efforts.

MSRP on each of the product releases.
Product # on each of the product releases.
Detailed contents on each of the product releases. (Dice, hex breakdowns, etc).

[Wytefang]

Matt, your best bet might be HouseMouseGames' listings...or the data page at Alliance Distribution.

I'll see what I can find (if anything) in this regard.

[Cavalier]

These threads might be helpfull:
Terrain Types and Master Set Contents -- The Definitive List (http://www.heroscapers.com/community/showthread.php?t=16629)

Terrain in each Expansion -- The Definitive List (http://www.heroscapers.com/community/showthread.php?p=191947)

UPC Bar codes for existing Heroscape sets (http://www.heroscapers.com/community/showthread.php?t=15165)

[Bixby]

Thanks Cav. Precisely waht I was looking for. Very very much appreciated. This will save me a ton of time!!

[Hahnarama]

So since it's all done post it already.

[Bixby]

So since it's all done post it already.

CANADA Day man. No Spreadhseet work today. ;)

[Hahnarama]

So since it's all done post it already.

CANADA Day man. No Spreadhseet work today. ;)

What a Lame A s s excuse! :p Ca-nay-de-ya is so desperate to be like the US of A that they make up some fake holiday to be like Independence Day.

Just put down the beer and post it.

:toast:

[Bixby]

So since it's all done post it already.

CANADA Day man. No Spreadhseet work today. ;)

What a Lame A s s excuse! :p Ca-nay-de-ya is so desperate to be like the US of A that they make up some fake holiday to be like Independence Day.

Just put down the beer and post it.
:toast:

http://www.youtube.com/watch?v=pXtVrDPhHBg

"Hey, I'm not a lumberjack, or a fur trader....
I don't live in an igloo or eat blubber, or own a dogsled....
and I don't know Jimmy, Sally or Suzy from Canada,
although I'm certain they're really really nice.

I have a Prime Minister, not a president.
I speak English and French, not American.
And I pronounce it 'about', not 'a boot'.

I can proudly sew my country's flag on my backpack.
I believe in peace keeping, not policing,
diversity, not assimilation,
and that the beaver is a truly proud and noble animal.
A toque is a hat, a chesterfield is a couch,
and it is pronounced 'zed' not 'zee', 'zed' !!!!

Canada is the second largest landmass!
The first nation of hockey!
and the best part of North America

My name is Joe!!
And I am Canadian!!!"

[Hahnarama]

So says the US of A wanna be!:p

[Bixby]

The latest version has been uploaded and is awaiting approval. When approved, the link on the first page of this thread can be updated. I updated the first post on this thread with a description of the contents.

Enjoy...

[Hahnarama]

Let me know when it's up and running.

You got my digits.

[Bixby]

First Post is now updated with the link to Version 9.

As always, please report any errors or omissions along with feedback in this thread.

[Omichron]

There seem to be a couple of mistakes. Both Charos and Captain America have 'special' Counter Strike abilities that CAN attack Samurai. It seems that you are calling it "counterstrike" to separate it from the samurai "Counter Strike" ability, but I do not see this 'samurai-killing' counterstrike in the special abilities tab.

[Bixby]

There seem to be a couple of mistakes. Both Charos and Captain America have 'special' Counter Strike abilities that CAN attack Samurai. It seems that you are calling it "counterstrike" to separate it from the samurai "Counter Strike" ability, but I do not see this 'samurai-killing' counterstrike in the special abilities tab.

Wow. I never noticed that before. Kind of sucks that the ability is named exactly the same but there are two different wordings. Thanks, great catch. Need to figure out how I will handle that.

Appreciate the feedback.

[bunjee]

Ah, that is like Taelord's special Flying ability (no errata'd to be Stealth flying)

Have I mentioned how much I love this spreadsheet?


Bixby, on the Roster sheet, could you expand the auto filter to include all the columns? I don't know about other people, but when I try to sort the columns, only the ones with sort options sort, which isn't very useful. Filtering is useful, but without filter by cost, it lacks something for me.

[Bixby]

Thanks Bunjee. I will certainly do that.

[TOG]

Do we have another update coming anytime soon?

[Bixby]

Eventually. Sorry, Been busy with a number of projects lately.

[Bixby]

I have decided not to update this XLS Sheet any further. There are many other great tools out there and the effort to keep this up to date was rather high considering my limited time these days. Thanks for all of the words of encouragement and compliments on the tool. Here is a link to an online army builder that has some nice features.

http://battleplan.mythacle.com/heroscape/


Happy 'Scaping,
Matt

[jetjake]

Bixby, Do you mind if others update and post this spreadsheet? I have the latest version updated thru wave 12 and working on wave 13. I don't mind sharing with others if you don't.

[Bixby]

I think that is great news and I fully endorse turning it over to someone who will care for and nurture it.

Thanks Jetjake.

PS. Do you work at Caterpillar? I work at a Caterpillar Dealership, been to Peoria many tiems in the past.

[Nomad]

I have updated Bixby's spreadsheet all the way through wave 12 as well. JetJake, perhaps we could work together on this.

Again, thanks for the invaluable tool and all of your efforts, Bixby.

[ddubois]

Can someone tell me where to find an updated spreadsheet that has all HeroScape units? Even one not as exhaustive as Bixby's would be great, as long as I can sort by wave and filter by squad/hero.

[solomani]

If anyone has a final version with all units would love to get a copy. Please let me know. Thanks.

[Bixby]

I would like a copy as well :D

[lonewolf]

I have something similar....I think it actually originated from Bixby's spreadsheet and then I moved things around a little for my own personal use. It is just one sheet though with a list of all units stats and abilities. Many of the abilities have notes, but some don't. It is updated with all of the units though.

Spreadsheet (http://www.mcmclive.com/hs/units_hs.xls)

[solomani]

I have something similar....I think it actually originated from Bixby's spreadsheet and then I moved things around a little for my own personal use. It is just one sheet though with a list of all units stats and abilities. Many of the abilities have notes, but some don't. It is updated with all of the units though.

Spreadsheet (http://www.mcmclive.com/hs/units_hs.xls)

Great. Thanks. I'll take a look when I get to work.

[Nomad]

I'll have an updated Bixby spreadsheet to share in a day or two. I just need to add in the last D&D wave and Samuel Brown. It is exactly the same as the original . . . I've just included the new info since wave 9.

[solomani]

I'll have an updated Bixby spreadsheet to share in a day or two. I just need to add in the last D&D wave and Samuel Brown. It is exactly the same as the original . . . I've just included the new info since wave 9.

Perfect, thanks.

[lefton4ya]

I'll have an updated Bixby spreadsheet to share in a day or two. I just need to add in the last D&D wave and Samuel Brown. It is exactly the same as the original . . . I've just included the new info since wave 9.
Sweet. I will upload this to the downloads section after you post a link here (or PM me to e-mail the file to me). I think I updated Bixby's up to the D&D master set and cleaned up some formatting at one point, but it is out of date by a year and a half.

[lefton4ya]

Bixby's Hextreme Heroscape Spreadsheet v 10 (http://www.heroscapers.com/community/downloads.php?do=file&id=3279)

Updated as of 7/10/11

Version 10.0 - XLS & ODS versions

Added Wave 10, BftU Master Set, D&D Wave 1-3 Information
Updated Power Rankings
Updated List Builder, Stats, Graphs worksheet, validation tables, formatting
Updated collection sheet to better calculate quantity owned and needed

To Do

Update: Errata & Product Barcode # for Wave9+
Add: Estimated Resale Value, Special Powers By Type, C3V & SoV or other customs


This was a collaborative update. Thanks to Bixby for his great work to start off, and to Nomad for adding Wave 10 & D&D and updating rankings.

Note, I completely changed what fields you can edit and "locked" the XLS spreadsheet although you can unlock it easily if you want to change anything. All you have to do is just change the "Collection" sheet to put what you have and it should change other sheets around. Let me know if there are any errors or issues.

[Nomad]

Thanks Lefton4ya for finishing everything up and uploading the spreadsheet. It looks great!

[solomani]

Brilliant. Thanks to everyone involved. It's really useful to have all this detail in Excel format.

[lefton4ya]

Made a minor correction and re-uploaded. The list builder AutoFilter was locked by default, so unlocked. Plus I changed some behind the scenes formatting to improve filtering/sorting, although some sheets you cannot sort unless you unlock the sheets.

Let me know if I should just remove locking altogether and just have good faith that most people will only change the yellow highlighted text unless they know what they are doing.

[Nomad]

I would leave it locked. If someone wants to do more than the basic stuff, they'll know to unlock it.

Thanks for putting the finishing touches on this.

[solomani]

Not sure if this was an oversight or intentional but the "Fortress of the Archkyrie" isn't listed.

[lefton4ya]

Not sure if this was an oversight or intentional but the "Fortress of the Archkyrie" isn't listed.
It is on the product tab and the collection tab, but not the roster because it was the only set that does not include figures.

P.S. I will do the following updates sometime in the next couple of weeks:

Update: Errata & Product Barcode # for Wave9+
Add: Estimated Resale Value (from AliasQTip's collection calculator (http://heroscape.awardspace.info/collection.htm) with minor tweaks by me).

[solomani]

Perfect, thanks. I only noticed because I just got the set :)

[lefton4ya]

Download Version 11 (http://www.heroscapers.com/community/downloads.php?do=file&id=3396)

New thread: Hextreme Heroscape Spreadsheet With Collection Calculator!