I created this to address John’s comment about inserting photos.

 

Using EXCEL with photos

 

[log in to unmask]

 

From: Conchologists List <[log in to unmask]> On Behalf Of John Varner
Sent: Thursday, May 7, 2020 10:26 AM
To: [log in to unmask]
Subject: Re: [CONCH-L] document your collection

 

I have also been re-cataloguing my collection using Excel, and discovered the hard way that Excel is not as intuitive or easily used as I thought.  (e.g.: I updated genus/specie names using Worms, then tried to alphabetically sort my 140 species of cones by specie name.  The result was a nearly hopeless scrambling of rows & columns that I couldn't undo, and  I wound up having to re-enter nearly the entire file of 140 specimens).

Some lessons from my Excel fiasco: 

Excel is a more complicated and powerful program than is necessary for cataloguing shells.

Work on a copy, not the original document, just in case. 

Back up often, and/or use "Time Machine" or a similar system back up

Find out how to use 'sort' and 'filter' options before trying to use them, as empty cells in your catalogue will throw off these functions.

'Undo' only works until you close the program, at which time changes are locked in.

 

Any input is welcomed!

 

I am still trying to figure out the best way to attach small file size thumbnail photos of specimens to their entries, but that may have to wait until the next pandemic...

 

- John


---------------------------------------------------------------------- [log in to unmask] - a forum for informal discussions on molluscs To leave this list, click on the following web link: http://listserv.uga.edu/cgi-bin/wa?SUBED1=conch-l&A=1 Type your email address and name in the appropriate box and click leave the list. ----------------------------------------------------------------------