PDA

View Full Version : Collector's Album Spreadsheet


Uranium Deposit
02-18-2009, 08:06 AM
I've compiled an excel spreadsheet that lists all of the cards in the game for the collectors album. It was created using Excel 2007, but the format here is .xls, Microsoft Office 1997-2003, so it should be compatible with most systems. Big thanks goes out to EOU Findub for all his work on this game, especially the collector's album section. The England and France sections of the list came directly from his postings. Let me know if there are any compatibility issues or anything major. File is attached to this posting.

P.S. The everything on the spreadsheet is locked except for the owned column to begin with so that you don't accidentally delete some important info. In Excel 2007 to disable this go to the Review Tab then Unprotect Sheet on each page, the password is blank.

New Version Out, see note down lower.

http://www.seanbenton.org/wp-content/uploads/2009/03/champions-league-collectors-album-ver11.xlsx (http://www.seanbenton.org/wp-content/uploads/2009/03/champions-league-collectors-album-ver11.xlsx)

Janchii
02-18-2009, 12:02 PM
Thank you very much! But it isnīt completed! :p At the Badges/Shirts section, i see at some clubs Gold or Silver or Bronze, but not at all clubs.

Uranium Deposit
02-18-2009, 02:24 PM
That is because it would only be possible to complete those sections by find all of those cards, whereas with the players the level can be predicted by their individual attributes, the only basis for predicting the level of the badges/kits is completely guesswork

GLOCKGLOCK
02-18-2009, 06:45 PM
Wow, this is amazing work! Huge thanks goes out to Uranium Deposit and EOU Findub for all the work on this!

EOU Findub
02-18-2009, 08:38 PM
Is there anyway to not have it as a zip file? Just as a normal excel document?

Uranium Deposit
02-18-2009, 08:39 PM
Is there anyway to not have it as a zip file? Just as a normal excel document?

From what I could tell, on our forums Excel files aren't allowed as attachments

EOU Findub
02-19-2009, 02:47 AM
Ah, okie dokey then. I wasn't aware. :)

Uranium Deposit
02-20-2009, 04:26 PM
I just happen to really love spreadsheets. I've made available a new version of the checklist. Changes include:


Better statistics: See at a glance how many players you have left for each team and what your percentage collected overall is.
Colors: See in a color representation just how close you are to finished your clubs. Red for a long ways away. Green you're almost there. And yellow in the middle.
More Badges and Kit Levels: And for the first time, kit colors, seeing as how the cards themselves don't say home or away, you don't need to buy the same one twice.
Club page links: From the overall view you can click on any team name and it will take you to that page in the workbook.

The updated file is too large for our forum attachment service so its being hosted offsite. Visit here (http://www.filehosting.org/file/details/14441/Champions%20League%20Collectors%20Album.xlsx) for the new version.



Of note: This version is Microsoft Office 2007 only, due to the conditional formatting involved, that is not compatible with Office 97-03. If there is enough demand I may make an xls version available.


Also: If you've already started to put your collection into the old list, you should be able to just copy the owned columns over from the old to the new and everything still be fine.

Janchii
02-21-2009, 09:01 AM
Error:
(en) Please come back later
(fr) SVP veuillez revenir plus tard
(de) Bitte versuchen sie es spaeter nocheinmal
(at) Konnten's bitt'schoen spaeter nochmal reinschauen
(no) Vennligst prov igjen senere
(dk) Venligst prov igen senere
(pl) Prosze sprobowac pozniej

Sow, how to get this excel? Thanks!

Uranium Deposit
02-21-2009, 09:28 PM
Error:
(en) Please come back later
(fr) SVP veuillez revenir plus tard
(de) Bitte versuchen sie es spaeter nocheinmal
(at) Konnten's bitt'schoen spaeter nochmal reinschauen
(no) Vennligst prov igjen senere
(dk) Venligst prov igen senere
(pl) Prosze sprobowac pozniej

Sow, how to get this excel? Thanks!

My apologies. Seems I made a poor selection of who should host the file. I've put it somewhere else as well: try here (http://www.mediafire.com/?sharekey=141102ec0ce6922b7f7ec40ada4772a6e04e75f6 e8ebb871)

Janchii
02-23-2009, 11:06 PM
Some tips for you: Fix some problems:

England calculator is not good, just test it by putting at the first Arsenal player "1". And look at Totals, then you should understand me.

There is no 222 cards each country? There is 11 players and badge, shirts, thats put total at 13 each team. 20x13 = 260

Sorry, but thanks !

Uranium Deposit
02-23-2009, 11:36 PM
Some tips for you: Fix some problems:

England calculator is not good, just test it by putting at the first Arsenal player "1". And look at Totals, then you should understand me.

There is no 222 cards each country? There is 11 players and badge, shirts, thats put total at 13 each team. 20x13 = 260

Sorry, but thanks !

Hm, that England problem never came up on mine, but looking at the uploaded spreadsheet I do see it. Probably came from locking the formulas somehow, I'll fix it and change the upload link. Thanks for pointing that out.

I did not include the Badges & Kits in the calculations because there is not any variance in the number per team. In other words its easy to search for them as long as you know if they are Bronze, Silver or Gold which I"ve tried to note. Also, some teams have 3rd kits which would complicate the process. One thing I do to know a team is has all players and all badges/kits is to highlight in the same blue color for zero the owned and teamname when completed. It also helps a lot to do the same in the individual team listings.

Just so you know: everything I do is in my own personal spreadsheet and then copy over any changes to the template spreadsheet which you all get so sometimes there are errors like this.

Here (http://www.seanbenton.org/wp-content/uploads/2009/03/champions-league-collectors-album-ver11.xlsx) is the fixed file. I included updates to badges/kits which are numerous.

Bolooen
04-06-2009, 04:25 PM
Sorry, I'm not an expert at Excel yet. When I extract the zip (last post after fixes, 2/23/9) into a folder, all I seem to see is XL files. How do I make this into a usable spreadsheet. I saw the old version (2/21/9 post) which was great, but I can't seem to do anything with the .zip file. What am I doing wrong?

Uranium Deposit
04-06-2009, 04:27 PM
Sorry, I'm not an expert at Excel yet. When I extract the zip (last post after fixes, 2/23/9) into a folder, all I seem to see is XL files. How do I make this into a usable spreadsheet. I saw the old version (2/21/9 post) which was great, but I can't seem to do anything with the .zip file. What am I doing wrong?
The newest versions require Microsoft Office 2007. In 2007 they changed the file type structure. Pretty much all of the changes are things which are only available in 2007 anyways.

Bolooen
04-06-2009, 04:45 PM
Doh, I just figured it out. I do have Office 2007. I was trying to extract the zip files into a folder than open a spreadsheet the old fashion way, looking for an .xlsx file. When I actually opened the zip itself using Excel your spreadsheet appeared. woot. thanks.

GLOCKGLOCK
01-21-2010, 04:57 PM
Since so many people have jumped into this game with the server shutting down this thread deserves a bump! This spreadsheet is one of the main reasons I completed the album. Big thanks to those who created it.

onemorechanc
01-25-2010, 07:33 PM
Since so many people have jumped into this game with the server shutting down this thread deserves a bump! This spreadsheet is one of the main reasons I completed the album. Big thanks to those who created it.

I agree. I just started playing this last week, and the spreadsheet is a must ... especially with the reduced timeline!

Anybody who wants to trade cards or online matches for credits, send me a friend request (GT: onemorechanc).

VENTIEEEEEE
10-17-2010, 01:24 PM
Is there any chance getting this spreadsheet when i click the link its not working

Uranium Deposit
10-20-2010, 12:05 AM
Is there any chance getting this spreadsheet when i click the link its not working
Sorry for the file being missing. I forgot to pay my server bill. However it's back up now. You'll find it at http://www.seanbenton.org/wp-content/uploads/2009/03/champions-league-collectors-album-ver11.xlsx

VENTIEEEEEE
10-20-2010, 01:35 PM
Thanks man this will help me