darkSpyro

Several people asked me to make a specific thread linking to the spreadsheet I created with images of all of the figurines, including variants, items, etc.

https://www.dropbox.com/s/7oq1...ers%20List.xlsm

As I said earlier, things are colour-coded and there is facility for people to record which figurines they have in a local copy.

Please remember to tactfully point out any errors or omissions.

I now have made following amendments:

Code changes:
• Added Compare functionality to compare two this workbook to a another copy.
• Moved buttons to Quick Access to ensure that they are document specific.

Item changes:
• Added possible Colour Shift Shroomboom
• Renamed Colour Shift figs to conform. WARNING: These items will not import across automatically to this version! This affects Hot Dog, Gill Grunt and Wash Buckler.
• Added Colour Shift column in summary.
• Fixed Horn Blast Whirlwind modifier - this entry will not import across automatically to this version!
• Added green Translucent Chop Chop and Scorp and Employee Gold Fire Kraken
• Frito Fright Rider and Colour Shift Wash Buckler images have been updated

Data changes:
• Target UFO pre-order card arrived
• My replacement Stone Whirlwind and Metallic Chop Chop arrived
• Wave 2 swappers found
• Colour Shift Hot Dog came home
• Bought a Frito Fright Rider but not delivered yet (so 1/2 right now)
• Got Colour Shift Wash Buckler
• Metallic Eye Brawl and the flocked Giants trio arrived

Well, since you have your own thread now, I'll make the same comment here I made before, LOL!

-------------

Sounds cool! But first tip: LOSE the xlsx format/file extension. Immediately. Never use it unless you NEED a feature that requires the new format. The new format causes problems (same goes for docx in Word). I'm a computer support tech, I've dealt with these problems directly and indirectly many times over the years. Conversely, xls works on all versions of Excel, it's much friendlier. In fact, on computers where I have to use Office 2007 or 2010 - where this format is the default - I change the default back to the classic xls and doc formats, no more issues, no more remembering to change the format every damn time. And what you lose are some advanced things that nobody tends to use anyway (like the limit of 256 columns and 65536 rows being increased, it's rare you need more than this, and when you do you can usually just organize differently and use multiple sheets, which is probably better anyway).

This is such an issue that Microsoft even came out with a Compatibility Pack for people (such as myself) who have the sense to stick with Office 2003, the best version of Office to date, to allow it to open xlsx/docx files, and there are STILL problems. Including now, I can't open this file.

BTW, when I force the issue, which makes it complain that it doesn't recognize the file format, it also pops an error that this has macros which cannot be disabled. Macros cause people discomfort as they can be risky, I hope they're very necessary, and not sure how you made them un-disable-able (though that might be part of the compatibility problem).

Please refer to where you originally posted this for my in-depth discussion of my rationale behind xlsx.

Also, please remember that it would need to be xlsm to contain macros.

Whilst your mileage may vary, I don't have any clients who have issues with <ext>x Office files but do have sundry clients requiring my assistance in getting seamless integration of earlier document types with SharePoint, etc.

No, actually macros have been around for years, they can be stored in regular Excel files. I've actually never seen an xlsm file, but I've often seen the warning "This contains macros". I've even programmed the macro which triggered the warning, though I avoid them just for this reason. I would suspect that xlsm is for a file that's ONLY macro(s), most macros are tied to the spreadsheet they are to be used with, automating tasks, that kind of thing.

And I see in the topic list that there's a new reply on the topic I just referenced, so you probably found it, LOL!

I'll go see your rationale there I guess, but unless you're deeply dependant on one of the newer features I doubt they'll be sufficient to argue "Often doesn't work and can't be opened by a large number of people", at least when trying to share it like this.

I will give you the benefit of the doubt that you did not mean to be condescending but please try to ensure your language does not convey that.

I know macros have been around for years - so have I.

Please refer to this handy link (came up first in Google search so not a M$ link but will do in a pinch):

http://www.ehow.com/info_81342...-docm-docx.html

Whilst someone in the know can generate <ext>x files with macros in them, the macros will never run in Office 2007+ as macros are only enabled in <ext>m files.

As using Office 2003 + Compat. Pack is a rarity in this day and age, I don't know if it bends this rule? Given that the support cycle for Office 2003 (and also Windows XP) terminates at the end of Q1 next year, it will fast become a moot point, commercially.

I wasn't being condescending, I was being informative, as you said something which is incorrect (to my knowledge). Please don't mistake my use of smileys as condescension, it's in an effort to keep the conversation light, friendly, and unconfrontational. As far as I've seen, macros do indeed still work in Office 2007 and 2010 in Excel files, though when you open them you get the warning, with the option to Disable Macros. AFAIK. That link perplexes me, as it doesn't sound right (it's also talking about Word files, we're talking about Excel, in which macros can be more important, as Excel lends itself to automation better). Unfortunately, none of my computers have Office 2007 or 2010, so I cannot check any of this myself, as I would so like to right now.

And as far as I've seen, Office 2003 has been given extended life by how bad 2007 and 2010 are, with the silly ribbon and the fact that it doesn't include access to all commands and features like the menus did. They even admit this, when modifying the custom toolbar, there's a category of commands entitled "Commands not in the ribbon". Hogging more screen space to give you less, brilliant. Many companies aren't updating their Office because of this stuff. So yes, many people still only have "just" Office 2003. No, it isn't a rarity. The last company I did support for ended up forcing through an upgrade to Office 2010 despite complaints, And some departments had to re-"downgrade" due to necessities of their jobs, including compatibility with other programs.

Nice work.

The only thing that should be fixed: There is no such thing as a Crystal Whirlwind. Rock Whirlwind exists, though.

Quote: Matteomax

Nice work.

The only thing that should be fixed: There is no such thing as a Crystal Whirlwind. Rock Whirlwind exists, though.

Pretty impressive fake, then, wouldn't you say?

Quote: UncleBob

Quote: Matteomax

Nice work.

The only thing that should be fixed: There is no such thing as a Crystal Whirlwind. Rock Whirlwind exists, though.

Pretty impressive fake, then, wouldn't you say?

That's just a prototype.

A fully-packaged prototype? That'd be pretty unusual, wouldn't you say? I suppose they could have repackaged it...

What's your source on the figure being a prototype?

Quote: UncleBob

A fully-packaged prototype? That'd be pretty unusual, wouldn't you say? I suppose they could have repackaged it...

What's your source on the figure being a prototype?

I'll contact Toys for Bob about it.

That is why I put the question mark on the Crystal Whirlie for the time being; happy to remove it, depending on outcome.

As for the docx example I gave, it was merely a handy example - the rule applies to Excel xlsx/xlsm as well. It was a conscious security "feature" added by M$.

I have done IT consulting work for well over 100 organisations in the past five, or so, years and can literally count on one hand how many were still using Office 2003 in that time. And that includes "cheapskate" not-for-profits with little to no discretionary IT budget. Given that the later versions can still save as prior versions, the only compatibility issues are bespoke developments wrt integration.

Do I personally like how the interface is evolving? Hell no but you can't stop City Hall... But then again, I do like being able to save as PDF with no 3rd party addons and consistent metadata capabilites in the app when integrating with a DMS (the latter of which I had to hand code in Office 2003 using OLE containers).

One must also remember that the UI is designed for average users, not "techies"; M$ spend a small fortune on market research in that space. Anyway, enough diatribe on Office - this is a Skylanders forum, my friend.

This is cool. I think you are missing the S2 Double Trouble in the S1 pose.

I cover that with the Royal Double Trouble. Yes, I know that there is a S1 normal D/Trouble with an orange base (I actually had one as the Oz Skylanders Battlegrounds did not come with Royal DT) but I don't consider it a variant as it simply reads like a normal one.

What do the ticks, -, x and what not mean at the bottom of each character?

EDIT: never mind its on sheet 2

EDIT: dark blast zone has the wrong pic, GITD and quickdraw rattle shake are same character.

Thanks for that - I had fixed the Dark Blast Zone image but must have undone my change.

As for Q/Draw R Shake, I was not sure if there was going to be a "normal" Q/Draw variant and a GITD Frito special one? I will fix that.

Cheers.

Quote: chaosworrier

I cover that with the Royal Double Trouble. Yes, I know that there is a S1 normal D/Trouble with an orange base (I actually had one as the Oz Skylanders Battlegrounds did not come with Royal DT) but I don't consider it a variant as it simply reads like a normal one.

I haven't downloaded your spreadsheet, but doesn't that same thing apply to virtually all of the Generation 1 variants? Blue Bash, WERDS, all off of the chase variants?

Yeah, but it looks the same?

As I was saying in another forum, the nomenclature (S1, Giants as an ability, etc) is what is convenient to me.

For example, I make no reference to the Arena Tour exclusive Dark Syro, simply Dark Spyro as an item.

People are encouraged to freely get a local copy and mutate it to their own req's.

Do you have the same pic for both Blast Zones? Great spreadsheet btw!

Yes, I had fixed it but accidentally reversed the fix last time.

The correct Dark B/Zone will be shown in the next version.

Just to bump this: Crystal Whirlwind is 100% real.

Yeah, fixed that in the spreadsheet:

• Fixed Dark Blast Zone image
  
• Added version date (but not automated from last save date/time as that mean a scary macro)
  
• Cleaned up (and coloured) tabs
  
• Added Summary tab - matrix by ownership and by variant type
  
• Removed superfluous GITD Quickdraw Rattle Shake item
  
• Crystal Whirlwind is now official!
  
• Minor amendments to my ownership statuses
  
• Volcanic Vault moved to Levels type
  

I really like and appreciate this spreadsheet. Is there a way to just "upgrade" my existing one without having to fill it out completely with every new version?

Oh, poo!

I had never thought of that - not really, no...

Let me dwell on it and try to think of something which does not take too much programming effort on my part.

Quote: chaosworrier

Oh, poo!

I had never thought of that - not really, no...

Let me dwell on it and try to think of something which does not take too much programming effort on my part.

no worries. not sure how much you can do in excel dealing with verison upgrades and not losing data.

I really like this new spreadsheet how a percentage is decided etc. however it would be nice to be able to upgrade our original one to the new version. the quickdraw rattle shake image is the wrong one it should be the white one the green one is fanmade.

Upgrades: Yeah, Excel isn't great at that type of thing. You need to be able to separate UI from data, and that's a Non-Excel type of thing.

I think you'd probably have to do it to where the users data is stored on an additional sheet of just data. When the user changes something it'd set a value on the new sheet. Your calcs and such would pull from the data sheet, not the main UI one.

Then when a new upgrade comes out, they could copy and paste values from the data sheet and hopefully be good to go.

That's how I approach Skylister, where I have a data file that stores the users information, a data file for the figures and then the UI/Code just manage that relationship, so even if I change the UI entirely the data stays and if I change the data file (with limits) it all still flows together.

That's my 2 bits.

Worksheet is still killer though. I'm wondering how you found all those images.

Quote: Xerxxees

Upgrades: Yeah, Excel isn't great at that type of thing. You need to be able to separate UI from data, and that's a Non-Excel type of thing.

I think you'd probably have to do it to where the users data is stored on an additional sheet of just data. When the user changes something it'd set a value on the new sheet. Your calcs and such would pull from the data sheet, not the main UI one.

Then when a new upgrade comes out, they could copy and paste values from the data sheet and hopefully be good to go.

That's how I approach Skylister, where I have a data file that stores the users information, a data file for the figures and then the UI/Code just manage that relationship, so even if I change the UI entirely the data stays and if I change the data file (with limits) it all still flows together.

That's my 2 bits.

Worksheet is still killer though. I'm wondering how you found all those images.

If there was an export/import format we could use from the old excel to the new excel to save the data that would work.

It would be cool to get those images into skylister...

Quote: jstewie23

It would be cool to get those images into skylister...

If it's ok with him to use those images I'll seriously consider it. It'd require me to copy and paste all of the images into Microsoft Paint and create new images which would be painful

If I had a .zip of each image though, I could make that happen. The latest Skylister builds support unique images per figure, so I can have a different pic for each Chill for example.

1/. Quickdraw Rattle Shake - now this is confusing me? I originally had two Q/draw items -> one GITD and one which did not look like it was? I got told that the non-GITD did not exist so removed it (and figured that image which is not GITD actually is but not glowing). If no non-GITD version exists, then how does that image exist?

2/. Nearly all of the images are from two Skylanders sites with lists. Given that they share the images, I did to. Some I Google searched for the indicative image (like Springtime T/Happy) but worked out that one of the lists I referred to also used them. A couple of images like the Target csrd and Frito based ones were from advertising material.

3/. I can easily write a macro to import/export but:
a/. Spreadsheets with macros are considered "scary" and suspect.
b/. It won't help existing people right now.

I CAME IN LIKE A WRECKING BALL.

This is the right Quickdraw Rattle Shake. The other is fanmade.


http://www.skylanders.com/cont...eshake-main.png

Thanks - will use it.

Okay, big news!

Added functionality to allow users to clear the ownership data or import it from another workbook.

NOTE:

1. It only recognises prior versions of my spreadsheet, of course.
   
2. The last version had two or three items which were missing their modifier which meant they were not unique - for example, Gnarly T/Rex was missing Gnarly. These will cause an issue when you try to import them but the code will detail each one when you encounter it and handle it semi-gracefully.
   
3. This means people have to accept and allow macros to run. This has a further implication in that the dropbox URL to download the spreadsheet is now different, given that the filename had to change to extension .xlsm for macros.
   
4. Error handling is still rudimentary right now so if you mucked around with the spreadsheet and how it hangs together, the error you get may not be as meaningful as desired.
   
5. Right now when an item's ownership is cleared it is set to an empty cell, not "x". This is an easy change but I think it is more logical to denote no value rather than an intrinsic default of not owning it (however, as I don't need to import data or clear it, I will be swayed by majority vote).
   

New dropbox URL is:

https://www.dropbox.com/s/7oq1...ers%20List.xlsm

Managed to import the data from previous version

on the previous version you first need to manually type Gnarly into Gnarley tree rex's box
then go to Legendery slam bam and from the drop down select legendery.

once you have done these steps it should import fine

Yeah, when I added the summary grids, I lost the modifier info and had to re-enter it.

These two got missed. Further imports will be fine as the names/modifiers are all correct now.

Another version - you can now compare the ownership values between workbooks. This is also great for finding out what items are new (even though I state it in the version history).

Code changes:
• Added Compare functionality to compare two this workbook to a another copy.
• Moved buttons to Quick Access to ensure that they are document specific.

Item changes:
• Added possible Colour Shift Shroomboom
• Renamed Colour Shift figs to conform. WARNING: These items will not import across automatically to this version! This affects Hot Dog, Gill Grunt and Wash Buckler.
• Added Colour Shift column in summary.
• Fixed Horn Blast Whirlwind modifier - this entry will not import across automatically to this version!
• Added green Translucent Chop Chop and Scorp and Employee Gold Fire Kraken
• Frito Fright Rider and Colour Shift Wash Buckler images have been updated

Data changes:
• Target UFO pre-order card arrived
• My replacement Stone Whirlwind and Metallic Chop Chop arrived
• Wave 2 swappers found
• Colour Shift Hot Dog came home
• Bought a Frito Fright Rider but not delivered yet (so 1/2 right now)
• Got Colour Shift Wash Buckler
• Metallic Eye Brawl and the flocked Giants trio arrived

Hi @all
Is there a way to try this excel-sheet? The dropbox-link seems to be deaktivated.
Thanks for help.

Tux

Quote: Tux

Hi @all
Is there a way to try this excel-sheet? The dropbox-link seems to be deaktivated.
Thanks for help.

Tux

I am having the same issue.

I also get that the link has been disabled, he probably took it down this is an older thread.

Yes: This is extremely outdated, and the user hasn't made a post in a while.

No one has a copy of this excelfile? That's too bad.

Oh hmm. I have a file on my computer named "Skylanders List" and I took a look at it; looks like it could be a *somewhat* newer version of the file.

I popped it up onto my own dropbox account

Looks like most everything is in order. I've never really made anything this elaborate on excel before, but I might be able to update some of the images and some new listings if anyone can tell me what might be missing. (i'm not really seeing anything off the top of my head lol)

The 3 swap force chase figures are missing (silver, gold, copper) Stink Bomb, Doomstone and Trap Shadow.

Quote: spyroflame0487

Oh hmm. I have a file on my computer named "Skylanders List" and I took a look at it; looks like it could be a *somewhat* newer version of the file.

I popped it up onto my own dropbox account

Looks like most everything is in order. I've never really made anything this elaborate on excel before, but I might be able to update some of the images and some new listings if anyone can tell me what might be missing. (i'm not really seeing anything off the top of my head lol)

Thank you very much. Lets have a look at this file - because i don't have a overview of my (152) skylanders

Dropbox? I prefer One Drive.

Can anybody post the latest version or point to where it is?

chaosworrier

non of the links i have tried work.
een the one in your at the end of all your post's don't work

How can we get the definitive spreadsheet of doom now?

I am in the process of creating a web version instead.

I have the database created and now creating the screens via AngularJS and JSON web services. I admit that I have not done anything on it for the better part of a fortnight now as I have been busy on work-related projects.

Long story, short - watch this space!