Coins spreadsheet

I just started to make an Excel document, documenting all my coins, as I feel it will keep me better organized, and Numista does not have enough options to document each coin.

Here is my spreadsheet so far:


Excuse the colors, I wanted a clearer difference between the countries.

So yeah so far, details about the coin, NR = Numista Rating. I like seeing the rarity on this site.
Album just tells me which album it's in. Then at the end has the Krause values.
Am I missing anything? Or should I do anything extra?

If you have an amazing spreadsheet, any chance I can have a look for inspiration?

Each year has an entry currently, I might change that. And I have written a program, which does most of the importing for me, so no I don't have to enter all of those details.

Denomination  Country  State  Qty  Year  Grade  Krause  Price  Description  Swap  

Code  Size  Metal  Edge  Mintmark  Theme  Inverted

 Those are the headings of the spreadsheet I created; the first row above is from a site somewhere and I added those others after it. I use Edge for plain or milled, Mintmark if it has a letter on coin, Theme says if it has bird or ship etc on (if someone asks if I have any ship coins I can easily see).



 The only colours I use are for the Quantity column, and then only yellow for more than 1 coin. I use coloured numbers for year ranges - before 1960, before 1900, before 1800.  

Not bad, here's mine



I like to have my coins in VF or better so I've coloured the coins that are below that grade red and the ones that are at or above VF green.

The "coin description" field is hyperlinked to the relevant Numista page and the "NGC values" field is hyperlinked to the relevant NGC page so if I upgrade my coin to a better copy I can easily access my collection on Numista to update it and then look up the values.

The "AG value" field contains a formula that multiplies the ASW (average silver weight) of the coin by the current spot value and the number of coins I own.

Country|Official name (Ruler) |Value |Name |Symbol |Year |Mintmark+City |Quantity|Diameter |Orientation|Validity|Annotations |KM#|Price

I like list and numismatic which goes quite well with another   My list contains columns that are not really necessary but are informative and others like mintage and grade are still missing. So when I don't have coins to sort through I can edit and improve my little list so that there is always something to do.

Right now the colors indicate the kind of storage (2x2s, capsules, setholders) or if the coin identification isn't completed and if a coin is a double.

Hyperlinking will be the next greater step but the NGC site is really slow so it will take a while.  

Thanks for sharing guys, I have adopted some of your good ideas, hope you don't mind.
Decided to use a color grading system for years; basically goes from green to red, red representing older. Same scale used for Numista rarity too.

Also colored all quantity values over 1, to signify my doubles better, thanks for that.

Will update it to show conditions soon, but I have the assumption that 95% of my coins are VF+ anyway.

Will add Hyperlinks to the KM#  fields, good idea that !

And I've added a bit more design.

For my point of view the beginning and ending date of issuing is important


I really think that the export file should be configurable with each Numista database field in order to please all of us. The only thing that can't appear is the price cause there's no field for that

If somebody has any influence on Xavier, he can push for that software implementation

Great things to share! Here's mine. I have additional columns for
- Collecting scope [A]; Europe and overseas 1900-1950 is a 1, Other Europe is a 2, World = 3/4, Euro = 8, do not want = 9.
- damage indication (scratches, dents, corrosion) [J]
- catalogue or exchange value [N]; in case I do not possess the coin yet it contains the lowest value of the type in quality VF.
- actual silver/gold weight and bullion value for silver/gold [O-P]; BV is calculated with a formula, so I can easily update silver/gold spot prices.
- collection value [R]; If I populate the year (means I've got it), it fills this column with the highest of either catalogue or bullion value.
- some swap supporting colums [S-T]; I add the initials of a swapper here and indicate with one or more + how much I would like to have that coin in the swap. Autofiltering - build swaps in seconds. Magic!

The header row contains some totals (total number of coins [H], total collection value* [R])
(* that's NGC-dollars, not real dollars)

I keep my duplicates in a copy sheet.

Enjoy!

Just a note ArnoV, The coins you've got listed under "Papua New Guinea" are actually "Territory of New Guinea", one half of Papua New Guinea

Quote: neilithicJust a note ArnoV, The coins you've got listed under "Papua New Guinea" are actually "Territory of New Guinea", one half of Papua New Guinea

Neil, you made me dive into history (http://en.wikipedia.org/wiki/Territory_of_Papua, http://en.wikipedia.org/wiki/Territory_of_New_Guinea).

I always thought it was just British New Guinea all the way, but after 1906 it became Territory of Papua and in 1920 Territory of New Guinea, annexed by Australia. Wow!

I have the funny habit to list coins of countries which no longer exist under the modern country in which their territory currently is continued.
British New Guinea and its successors Territory of Papua and Territory of New Guinea are continued in modern Papua New Guinea, that's why I list my coins there. Coins for German New Guinea would go here as well (under a separate caption, sure) if ever I could lay hands on them.

Good luck with that.  if you've got a spare couple of thousand....

In my spreadsheet, I list each coin by nation, denomination, year, and mintmark/variety.  I record each coin's mintage, catalog number, composition, diameter, thickness, weight, shape (round, 12-sided, scalloped, etc.), edge (smooth, reeded, security), which bin I stored it in, and when and where I first got it.

Quote: CeruleanI record each coin's mintage, catalog number, composition, diameter, thickness, weight, shape (round, 12-sided, scalloped, etc.), edge (smooth, reeded, security).

I was thinking about adding some of those to my spreadsheet too, but I decided that hyperlinking to the Numista page was easier as that had all the relevant information on it.  The only one of these I included was the one that would change if I purchased a coin of a different year, and that is the mintage.

This is how I order my collection in excel:

Excuse me for typing in Dutch!  

Spam - a scummy way to have this topic resurrected, but I'm actually glad.. by reading this after it popped up, I liked Neil's way of hyperlinking entries to the corresponding NGC or Numista pages to make alterations a lot easier. It just goes to show you never know from where you will find a helpful nugget of information or how it will come to you!

Dates and calendars like AH SH etc... are not well managed in the current Numista excel export.
There is a new collection excel conversion developed by Franche92 with everything you might dream


Numista excel export :

And after conversion :

Quote: "Frenchlover"​Dates and calendars like AH SH etc... are not well managed in the current Numista excel export.
​There is a new collection excel conversion developed by Franche92 with everything you might dream
​
​
​Numista excel export :
​
​And after conversion :
​

​Where can I obtain this alternative excel conversion method? Do I have to contact the developer directly?