Cataloging your collection

[Birdseye]

I have sort of related arms/armor/book collections and I began cataloging the books about 5 years ago. I found that I was buying the same things over and over again.

Anyway, I use Excel and I wondered what other people used.

I also found this cute trick out a couple of days ago ...

Compare the two images.

You get the image when you place your cursor over the cell.

 

[Fuzeman]

Hi Birdseye
I use Pen and Pencil to catalouge the collection , then i now use word pad on the computer, it takes ages , i really need a leggy blonde ,busty,young female secretary
it will take longer but it will be worth it Ha ha

 

[jayteepee_1999]

I would like to make a database for myself. However, as you have already made a start in excel, any chance of a copy, empty of data (or 1 or two records) so that I can make a start?

PM me if you are willing

 

[Birdseye]

excel

no prob. What are you including?

I do books, arms, armor, and projectiles.

 

[jayteepee_1999]

munitions mainly,

Bombs
Missile
Mortar
Grenade
Mines
LSA
Subminition
etc etc..

 

[sgtlynn]

Now thats a neat little trick using Excel, now I will need to spend about six hours trying to figure out how you did that!!

Thanks..........I think.........

Cheers
Darryl

 

[Birdseye]

It took me a while. Let me see if I can explain it.

Right click a cell.

Choose "Insert Comment"

A comment appears

The comment should look have little boxes around it. If it does not, click it. It makes the little boxes appear.

Put the cursor (which looks like a little +) ON THE LINES OF THE BOX

Right click

On the format choices, pick the "Colors and lines" tab

First choice is Fill Color. Left click the arrow thingie next to the pale yellow (current background color)

Choose "Fill Effects"

Choose "Picture"

Choose "Select Picture"

Easy as pie:tinysmile_hmm_t:

 

[sgtlynn]

Thanks muchly, I will give it a shot!!:bigsmile:

 

[Burney Davis]

I have to say Birdseye, your 'trick' with xl is a class act!! The trouble is it would take me the rest of this century to catologue my stuff as speed on the magic box is not something I 'xl' at!

ATB

BD

 

[Birdseye]

I have to say Birdseye, your 'trick' with xl is a class act!! The trouble is it would take me the rest of this century to catologue my stuff as speed on the magic box is not something I 'xl' at!

ATB

BD

Thanks.

I gotta say though that while cataloging is a pain, it is a good exercise. I did my books over a period of about 4 years. I just grabbed an armload whenever I sat at the computer and entered them. Fact is that it probably increases the value of my library as well as allowing me to actually find stuff.

Take it slow and steady and it won't be that awful.

 

[Birdseye]

I did screen grabs of the captions on my projectile spread sheet. It was sort of a laundry list of everything that came to mind as I started entering things. Seemed to me you could have a projectile and/or a case so you had to allow for all of them. Dealing with my Hotchkiss Shell made me realize that I didn't allow for any columns on fuses, per se.