Google Doc Spreadsheet of World Wide Blu-ray SteelBooks

[kennerado]

Need to add WWE: Smackdown vs Raw 2008 for PS3, Australia

[mr. b]

Nice job xradman.

I would take the country out of the Title since you have a column for Country already. I would probably also take out the Movie release year or the Exclusive stuff and put that in the 2nd and 3rd columns, and move the country to the 4th. That's just me though, it looks pretty good the way it is.

As for your formula error for release count, try this:
=COUNTIF(D10: D2102,"<="&TODAY())

I had to add a space between D10: and D2102 or else a smiley face would show. Kill the space and it should work.

That should give you the same result without having to enter the date into the formula to get it to work every time.

[xradman]

Originally Posted by mr. b

Nice job xradman.

I would take the country out of the Title since you have a column for Country already. I would probably also take out the Movie release year or the Exclusive stuff and put that in the 2nd and 3rd columns, and move the country to the 4th. That's just me though, it looks pretty good the way it is.

As for your formula error for release count, try this:
=COUNTIF(D10: D2102,"<="&TODAY())

I had to add a space between D10: and D2102 or else a smiley face would show. Kill the space and it should work.

That should give you the same result without having to enter the date into the formula to get it to work every time.

That did the trick. Thank you very much.

[mr. b]

Originally Posted by xradman

That did the trick. Thank you very much.

Your welcome. I like the way you laid out the spreadsheet also. Personally, I just use DVD Profiler to keep up with my collection. I created a SteelBook tag, and I can filter my collection to just show my steelbook collection. I can then filter it several other ways including country of release, type of media, actor, director, etc. Upcoming releases don't always pop up before they come out though, so I'll either choose a similar release as a filler, add it manually to my database, or simply wait it out. It also helps me keep track of my wishlist, my orders, what I've watched, how much I've spent, and I put notes in some of them to let me know which ones I have extras of or other information (such as exclusive info). I can also rearrange the collection to view it in ascending or descending order by title, release date, purchase date, and a few others that I can't think of right now. I think also that I can export data to a spreadsheet, but I haven't tried that yet. If I wanted to know what the current count was for blu-ray steelbooks worldwide, all I'd have to do is filter it with the steelbook tag, then filter only blus, and then view everything (my collection, my orders, and my wishlist) together. This would give me a total count. I can't say for certain though that EVERY blu-ray steelbook is in DVD Profiler 'cos I haven't looked for them all in there. I don't think it would take much for me to check the few that I don't have on my wishlist, and submit them to the database if needed.

If I didn't have DVD Profiler, I'd definitely "borrow" your spreadsheet.

[xradman]

Originally Posted by mr. b

Your welcome. I like the way you laid out the spreadsheet also. Personally, I just use DVD Profiler to keep up with my collection. I created a SteelBook tag, and I can filter my collection to just show my steelbook collection. I can then filter it several other ways including country of release, type of media, actor, director, etc. Upcoming releases don't always pop up before they come out though, so I'll either choose a similar release as a filler, add it manually to my database, or simply wait it out. It also helps me keep track of my wishlist, my orders, what I've watched, how much I've spent, and I put notes in some of them to let me know which ones I have extras of or other information (such as exclusive info). I can also rearrange the collection to view it in ascending or descending order by title, release date, purchase date, and a few others that I can't think of right now. I think also that I can export data to a spreadsheet, but I haven't tried that yet. If I wanted to know what the current count was for blu-ray steelbooks worldwide, all I'd have to do is filter it with the steelbook tag, then filter only blus, and then view everything (my collection, my orders, and my wishlist) together. This would give me a total count. I can't say for certain though that EVERY blu-ray steelbook is in DVD Profiler 'cos I haven't looked for them all in there. I don't think it would take much for me to check the few that I don't have on my wishlist, and submit them to the database if needed.

If I didn't have DVD Profiler, I'd definitely "borrow" your spreadsheet.

I also use DVD Profiler. I think every SteelBook I have is in the database. I made the spreadsheet when DVDSpot went away and I needed a better online way to track my purchases. In my personal Google spreadsheet, I keep track of all by Blu-ray/HD DVD purchases (1,240), ordered items (57), and extra SteelBooks (145).

[victors]

I prefer using MS Access but nice Excel

[xradman]

Originally Posted by kennerado

Need to add WWE: Smackdown vs Raw 2008 for PS3, Australia

Do you have a UPC or release date for this? PS3 games are a pain to track fro this sort of information.

[Wreck]

Originally Posted by xradman

Do you have a UPC or release date for this? PS3 games are a pain to track fro this sort of information.

http://www.collect-that-game.com/200...-steelbookps3/

Click on pic to get excact UPC # if you like...

[jojo2351]

i think you can remove De l'autre côté du lit (2008) 7/8/2009 France
from the list,
its not a steelbook

[jojo2351]

Hello,

I am missing on the list Sweeny Todd Play.com exclusive Steelbook.

tne normal Sweeny Tood Steelbook has the UPC 7321900211253

and play.com sold the Sweeny Todd Steelbook with a exclusive Booklet,
the UPC: 7321905211258

[crashkelly]

Originally Posted by jojo2351

Hello,

I am missing on the list Sweeny Todd Play.com exclusive Steelbook.

tne normal Sweeny Tood Steelbook has the UPC 7321900211253

and play.com sold the Sweeny Todd Steelbook with a exclusive Booklet,
the UPC: 7321905211258

Awe crap. Another one for the list

[tiger_qc]

Originally Posted by jojo2351

Hello,

I am missing on the list Sweeny Todd Play.com exclusive Steelbook.

tne normal Sweeny Tood Steelbook has the UPC 7321900211253

and play.com sold the Sweeny Todd Steelbook with a exclusive Booklet,
the UPC: 7321905211258

Are you serious about Sweeney Todd?
Both of my copy have the first UPC.

This was already hard enough to find.
Are you sure about this jojo?

[crashkelly]

Originally Posted by tiger_qc

Are you serious about Sweeney Todd?
Both of my copy have the first UPC.

This was already hard enough to find.
Are you sure about this jojo?

Thank you tiger, I am breathing again

Yes, please confirm this jojo, thanks.

This does bring up the point of "what is different" again.

Upcoming Gladiator release from play.com will have art cards and the release from amazon.co.uk most likely will not. This equates directly with the FNAC Exlusives and their booklets and the amazon.fr releases that are just the steelbook.

Where do we draw the line?

Cheers
CrashKelly

[jojo2351]

Originally Posted by tiger_qc

Are you serious about Sweeney Todd?
Both of my copy have the first UPC.

This was already hard enough to find.
Are you sure about this jojo?

I have only the normal sweeney Steelbook,
http://www.bluray-disc.de/blu-ray-fi...t-blu-ray-disc

but cc077 (ADMIN from bluray-disc.de)
has the play.com Edition and he said they have different UPC Codes (they look similar, only 2 numbers are different), so a new entry in the database:
http://www.bluray-disc.de/blu-ray-fi...t-blu-ray-disc

but i can ask cc007 again