Excel spreedsheets

[mikeweatherley@gmail.com]

I’m new to collecting has anyone got an excel/pages spreadsheet I can use to records coins, thanks Mike

[Mr T]

Not sure about others but I just started with a blank spreadsheet and add a row for each coin I acquire. Not perfect (especially when trying to see where gaps are) but keeping track of what constitutes a complete set for some series is a challenge in itself.

[Paddy]

I have sent Mike a copy of my spreadsheet direct. @mikeweatherley@gmail.com, please let me know if you don't get it.

 

[secret santa]

And I've sent him a blank version of the Word document that I use.

[The Bee]

So I've been at it for about a year now

1) I have been building a list of coins I'm missing and those I'd like to upgrade in a spreadsheet : Crowns to Farthings 

And then (like Paddy)

2) I've been photographing all my current Bronze and Copper date runs and part date runs and am putting them in Powerpoint

That way I quickly open the relevant slide deck, Copper Farthings 1672 to 1850, flick through the slides to find a high res image of the current "best" obverse and reverse 

I find this an easier method to spot if I've found a potential minor or major upgrade

[Given my collection is at the other end of the scale of the Penny Collection

There is usually more opportunity for a major rather than minor upgrade, it remains a bit of a Spaghetti Western as in " the Good, the Bad, and the Ugly"]

Best Regards 

 

 

[Peckris 2]

I created my own database set of tables using FileMaker Pro - this is just four of the tables showing one of the coins:

 

 

[ozjohn]

If you are looking for a spreadsheet it's hard to go past OpenOffice. It's virtually the same as Excel and costs nothing also runs on Win10/11.

[Coinery]

I just open the album to see if I have one or not?  

[The Bee]

On 2/9/2025 at 9:57 PM, Peckris 2 said:

I created my own database set of tables using FileMaker Pro - this is just four of the tables showing one of the coins:

Phew, What a comprehensive system and such a lot of information on "historic" and current prices. I guess at some point you need something like that to avoid duplication (I should have done this for my newspapers) and if you decide to sell bits off, it would to keep the Tax authorities happy, not to mention your insurer  

 

    

[Peckris 2]

On 2/11/2025 at 8:51 AM, The Bee said:

Phew, What a comprehensive system and such a lot of information on "historic" and current prices. I guess at some point you need something like that to avoid duplication (I should have done this for my newspapers) and if you decide to sell bits off, it would to keep the Tax authorities happy, not to mention your insurer 

Creating those historic prices was a right bit of hard work! So I've only done it for coins in my collection, but luckily I've got all the relevant Seaby/Spinks for the years listed.