Thanks for your suggestion.
For those of us who are challenged in these matters, how do you get the image placed on the spreadsheet where you want it.
Do you use one spread sheet for each tray or one long list?
I use a
Mac which simply allows me to drag the jpg photo file onto the spread sheet, resize it on the sheet ( by dragging the corner of the images diagonally in or out) to about postage stamp size then drag it onto the cell where I want it. The same principles apply for Windows based operating systems although the details may be slightly different. If you want to be more technical I think you can go directly to the cell where you want the image then use Insert from the drop down menu to insert the image file then resize it on the sheet to fit the cell size. Also remember you can make the cell sizes as wide and high as you want by setting the cell size for each
column or simply dragging the borders of each row/
column on the sheet. You will have to greatly enlarge the
standard cell size from the
standard that opens up when you open Excel. Just fiddle around to get something that suits your need.
Tip - I have my sheet fairly large and then just print it at 60 %
scale ( using print set up) to get it
standard A4 page width on printing. When printed it runs to about 18 pages for a couple of hundred coins -so it's one long list that prints out over multiple pages - just
scale it to get the correct page width on printing and the rest takes care of itself.
You could of course make a separate list for each tray or insert a title Tray 1, Tray 2 etc at the appropriate point in the list. I don't bother as things get moved around in and across trays with each acquisition so one long list is easier for me to manage and it meets my needs just
fine.
That said my coins list does contain headings such as
Peloponnesos,
Asia minor, Hellenistic, etc. and subheading such as
Seleukid,
Bactria etc. - you can cut and dice the list any way you want once you've made it. A grab shot of a
bit of my list is attached below to show what I mean.
You can even save the list as a PDF and load it into your iBook
library if you want! Carry a virtual copy of your
collection wherever you and your iPad go - pretty cool to have to impress other geeks at the pub! Maybe I should build a coin
collection app?
