PlaystationTrophies Got a news tip? tips@x360a.org
Username
Password
 

Go Back   XboxAchievements.com > Xbox 360 Retail Games > Sports and Fitness > UEFA Champions League 2006-2007
Subscribe    Donate

Reply
 
Thread Tools Display Modes
Old 02-18-2009, 08:06 AM   #1
Uranium Deposit
 
Uranium Deposit's Avatar
 
Join Date: Mar 2007
Location: Oklahoma
Posts: 179

Uranium Deposit's Gamercard
Collector's Album Spreadsheet

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

__________________




Last edited by Uranium Deposit; 03-02-2009 at 02:57 AM. Reason: New Version
Uranium Deposit is offline   Reply With Quote
Old 02-18-2009, 12:02 PM   #2
Janchii
 
Join Date: Jun 2007
Posts: 186

ajaxan's Gamercard
Thank you very much! But it isnīt completed! At the Badges/Shirts section, i see at some clubs Gold or Silver or Bronze, but not at all clubs.
__________________
Completed: NBA 2K6, Harry Potter OOTP, FIFA 06 RTFWC, Viva Pinata.
Working on: FM2006, PES6, POTC, PES08,PGR 4.
Janchii is offline   Reply With Quote
Old 02-18-2009, 02:24 PM   #3
Uranium Deposit
 
Uranium Deposit's Avatar
 
Join Date: Mar 2007
Location: Oklahoma
Posts: 179

Uranium Deposit's Gamercard
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
__________________



Uranium Deposit is offline   Reply With Quote
Old 02-18-2009, 06:45 PM   #4
GLOCKGLOCK
 
Join Date: Jul 2007
Posts: 334

DRUNKZ 27's Gamercard

Awards Showcase NBA Live 07 - 1000 People Online...Again
Total Awards: 1 (more» ...)
Wow, this is amazing work! Huge thanks goes out to Uranium Deposit and EOU Findub for all the work on this!
__________________
GT - DRUNKZ 27

No blank friend requests! Please send a message with the game/achievement you want to boost!
GLOCKGLOCK is offline   Reply With Quote
Old 02-18-2009, 08:38 PM   #5
EOU Findub
 
EOU Findub's Avatar
 
Join Date: Apr 2008
Location: United States
Posts: 1,975

EOU Findub's Gamercard

Awards Showcase 1,000 Posts
Total Awards: 1 (more» ...)
Is there anyway to not have it as a zip file? Just as a normal excel document?
__________________
HOORAY!!!
EOU Findub is offline   Reply With Quote
Old 02-18-2009, 08:39 PM   #6
Uranium Deposit
 
Uranium Deposit's Avatar
 
Join Date: Mar 2007
Location: Oklahoma
Posts: 179

Uranium Deposit's Gamercard
Quote:
Originally Posted by EOU Findub View Post
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
__________________



Uranium Deposit is offline   Reply With Quote
Old 02-19-2009, 02:47 AM   #7
EOU Findub
 
EOU Findub's Avatar
 
Join Date: Apr 2008
Location: United States
Posts: 1,975

EOU Findub's Gamercard

Awards Showcase 1,000 Posts
Total Awards: 1 (more» ...)
Ah, okie dokey then. I wasn't aware.
__________________
HOORAY!!!
EOU Findub is offline   Reply With Quote
Old 02-20-2009, 04:26 PM   #8
Uranium Deposit
 
Uranium Deposit's Avatar
 
Join Date: Mar 2007
Location: Oklahoma
Posts: 179

Uranium Deposit's Gamercard
Version 1.1

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 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.
__________________



Uranium Deposit is offline   Reply With Quote
Old 02-21-2009, 09:01 AM   #9
Janchii
 
Join Date: Jun 2007
Posts: 186

ajaxan's Gamercard
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!
__________________
Completed: NBA 2K6, Harry Potter OOTP, FIFA 06 RTFWC, Viva Pinata.
Working on: FM2006, PES6, POTC, PES08,PGR 4.

Last edited by Janchii; 02-21-2009 at 10:32 AM.
Janchii is offline   Reply With Quote
Old 02-21-2009, 09:28 PM   #10
Uranium Deposit
 
Uranium Deposit's Avatar
 
Join Date: Mar 2007
Location: Oklahoma
Posts: 179

Uranium Deposit's Gamercard
Quote:
Originally Posted by Janchii View Post
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
__________________




Last edited by Uranium Deposit; 02-23-2009 at 11:38 PM.
Uranium Deposit is offline   Reply With Quote
Old 02-23-2009, 11:06 PM   #11
Janchii
 
Join Date: Jun 2007
Posts: 186

ajaxan's Gamercard
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 !
__________________
Completed: NBA 2K6, Harry Potter OOTP, FIFA 06 RTFWC, Viva Pinata.
Working on: FM2006, PES6, POTC, PES08,PGR 4.
Janchii is offline   Reply With Quote
Old 02-23-2009, 11:36 PM   #12
Uranium Deposit
 
Uranium Deposit's Avatar
 
Join Date: Mar 2007
Location: Oklahoma
Posts: 179

Uranium Deposit's Gamercard
Quote:
Originally Posted by Janchii View Post
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 is the fixed file. I included updates to badges/kits which are numerous.
__________________




Last edited by Uranium Deposit; 03-02-2009 at 02:57 AM.
Uranium Deposit is offline   Reply With Quote
Old 04-06-2009, 04:25 PM   #13
Bolooen
 
Join Date: May 2008
Posts: 25

Bolooen's Gamercard
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?
Bolooen is offline   Reply With Quote
Old 04-06-2009, 04:27 PM   #14
Uranium Deposit
 
Uranium Deposit's Avatar
 
Join Date: Mar 2007
Location: Oklahoma
Posts: 179

Uranium Deposit's Gamercard
Quote:
Originally Posted by Bolooen View Post
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.
__________________



Uranium Deposit is offline   Reply With Quote
Old 04-06-2009, 04:45 PM   #15
Bolooen
 
Join Date: May 2008
Posts: 25

Bolooen's Gamercard
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.
Bolooen is offline   Reply With Quote
Old 01-21-2010, 04:57 PM   #16
GLOCKGLOCK
 
Join Date: Jul 2007
Posts: 334

DRUNKZ 27's Gamercard

Awards Showcase NBA Live 07 - 1000 People Online...Again
Total Awards: 1 (more» ...)
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.
__________________
GT - DRUNKZ 27

No blank friend requests! Please send a message with the game/achievement you want to boost!
GLOCKGLOCK is offline   Reply With Quote
Old 01-25-2010, 07:33 PM   #17
onemorechanc
 
onemorechanc's Avatar
 
Join Date: Jul 2007
Location: Canada
Posts: 415

onemorechanc's Gamercard

Awards Showcase NBA Live 07 - 1000 People Online...Again   Submit - Bronze
Total Awards: 2 (more» ...)
Quote:
Originally Posted by GLOCKGLOCK View Post
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).
onemorechanc is offline   Reply With Quote
Old 10-17-2010, 01:24 PM   #18
VENTIEEEEEE
 
Join Date: Oct 2008
Posts: 80
Is there any chance getting this spreadsheet when i click the link its not working
VENTIEEEEEE is offline   Reply With Quote
Old 10-20-2010, 12:05 AM   #19
Uranium Deposit
 
Uranium Deposit's Avatar
 
Join Date: Mar 2007
Location: Oklahoma
Posts: 179

Uranium Deposit's Gamercard
Quote:
Originally Posted by VENTIEEEEEE View Post
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...bum-ver11.xlsx
__________________



Uranium Deposit is offline   Reply With Quote
Old 10-20-2010, 01:35 PM   #20
VENTIEEEEEE
 
Join Date: Oct 2008
Posts: 80
Thanks man this will help me
VENTIEEEEEE is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT. The time now is 08:06 AM.