Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts

Monday, October 18, 2010

Google Docs spreadsheet

I've been tinkering with the Google Docs spreadsheet as an alternative to Excel - I wanted to work on listing various collecting topics cards [I've picked up in 2010] in my collecting topics file /database.

However the mouse on my desktop computer has gotten wonky and it is easier working from my laptop - even though it doesn't have any of the Microsoft Office programs like Word and Excel.

I imported a copy of my Excel collecting topics file to Google and there is about a 1MB limit when doing so
- the size of my file is less than 1MB but I assume I'm probably going to export my file back to Excel once I reach the 1MB mark.

Besides worrying about the file size limit, I was having a problem sorting the rows in descending or ascending order - because the field names on the header row would be sorted along with the data I'd put into the spreadsheet.

What helped me figure things out was figuring out how to freeze the header row - as noted on this Web site.

Now the header row with the various field names stay on top - with the actual data being sorted.

Hopefully with the help of Google Docs, I'll get a little more motivated to update and list more cards in the database - I really feel like I'd gotten away from the database work I'd been doing my collecting topics cards during the past several years.

Sunday, October 26, 2008

Collecting topics cards

Infamous - a tragic figure perhaps

Awesome action - The Human Vacuum Cleaner

Awesome action - making a Web Gem

Inking it up - obliging the fans

Awesome action - dirt is the name of the game

Cards like these is what makes up a bulk of my 'active thinking' collection - cards picked up here and there, not worth much at all, but are always guaranteed to make me smile and/or think a little deeper.

I've been getting back into collecting topics and database work - maybe it is the most cost-effective, yet interesting way to collect sports cards [though baseball is still the only one I actively collect] if you are on the sidelines as far as busting new product or picking up new singles.

I sort these cards out pack-war style - using unique collecting topics classifications, which may not be original, but ones I've adopted them for my own collecting use. I only store these cards in boxes, but it is a moral victory to see cards featuring the same theme, coming to life.

I look through the diversity, the numbers and enjoy rank-and-file cards and what they now represent - besides just the thousands of base cards I have no use for.

Any card maybe a collecting topic card and the idea almost no card is a common in my eyes is something challenging - but also encourages me to collect something, without resorting to having to pick up something like 7th Inning Stench repack boxes at my local retail store.

Thursday, June 05, 2008

Database work
W
hen you are supposed to put a priority on what you are collecting, it seems I'm trying to do the opposite, trying to find unique features in the thousands of commons out there. I think what makes the experience worth it is when I'm actually looking at the cards in-hand and see there is a theme, an oracle among cards from different years and different brands.

I'm trying to list all the applicable collection topic cards in a database on Excel - the task keeps me sane and gives my collecting endeavors a purpose, but it gets tedious and sometimes you have to take a step back.

These are merely the collecting topics subjects I'd like to work on as far as putting into the database I created - I probably listed over 1,500 cards already as far as cards from other collection topics are concerned, but need to list some more.

He's hitting over .400, just collected his 400th home run with a 4-for-5 performance Thursday, in a 7-5 Atlanta Braves win against the Florida Marlins. Chipper, wanna go to Hooters?

I'm trying to work on a collection of 'infamous' players - from public urination to murder and everything in-between]. I'm not glorifying these athletes, but keeping a note on what they did that maybe a 'no-no' among society.

There are also other topics such as a collection of cards - featuring players from different nations, featuring players involved in the steroid era, featuring pitchers showing the type of grips they are using during their pitching motion, uncorrected error cards and cards featuring interesting facts on the back.

Edit: I just found a binder of cards featuring players 'inking it up' for the fans and also 'bonus babies,' where star players make cameos on common players' cards - more stuff to work on and keep me busy.