melt - Google Sheets

	C	D	E	I	J	K
1
2
3	US GOLD COINS	OUNCES	VALUE	US SILVER COINS	OUNCES	VALUE
4	Dollar ($1.00)	0.05	$84.63	Wartime Nickel (1942-1945)	0.06	$0.94
5	Quarter Eagle ($2.50)	0.12	$211.57	Dime	0.07	$1.21
6	Three Dollar ($3.00)	0.15	$253.83	Quarter	0.18	$2.92
7	Half Eagle	0.24	$423.13	Half Dollar	0.36	$6.04
8	Eagle	0.48	$846.16	Half Dollar (40% 1965-1970)	0.15	$2.47
9	Double Eagle	0.97	$1,692.32	Silver Dollar	0.77	$12.92
10				Silver Eagle	1.00	$16.77
11	US GOLD BULLION	OUNCES	VALUE
12	5.00	0.10	$174.92	CANADA SILVER COINS	OUNCES	VALUE
13	10.00	0.25	$437.29	Dime (1920-1967)	0.06	$1.00
14	20.00	0.50	$874.58	Dime (1967)	0.04	$0.63
15	50.00	1.00	$1,749.16	Quarter (1920-1967)	0.15	$2.50
16				Quarter (1967-1968)	0.09	$1.57
17	CANADA GOLD COINS	OUNCES	VALUE	Half Dollar (1920-1967)	0.30	$5.01
18	5.00	0.24	$423.13	Dollar (1935-1967)	0.60	$9.98
19	10.00	0.48	$846.26
20	20.00 (1967)	0.53	$924.71	UK pre-1920 SILVER COINS	OUNCES	VALUE
21	100.00 (1976 = 14kt)	0.25	$437.31	Sixpence	0.08	$1.40
22	100.00 (1976 = 24kt)	0.50	$874.88	Shilling	0.17	$2.81
23				Florin	0.34	$5.62
24	CANADA GOLD BULLION	OUNCES	VALUE	Halfcrown	0.42	$7.02
25	1.00	0.05	$87.45
26	2.00	0.07	$116.41	UK post-1920 SILVER COINS	OUNCES	VALUE
27	5.00	0.10	$176.08	Sixpence	0.05	$0.76
28	10.00	0.25	$438.48	Shilling	0.09	$1.52
29	20.00	0.50	$875.90	Florin	0.18	$3.04
30	50.00	1.00	$1,751.80	Halfcrown	0.23	$3.80
31
32	UK GOLD COINS	OUNCES	VALUE
33	Half Sovereign	0.12	$206.42	Silver (AMEX:SLV)	SLV	$15.59
34	Sovereign	0.24	$411.05	GOLD ETF (NYSE:GLD)	GLD	$164.64
35	Double Sovereign	0.47	$823.87	GOLD ETF (AMEX:IAU)	IAU	$16.73
36	Five Pounds	1.18	$2,065.89	AVERAGE		$165.97
37				TIMES 10		$1,659.70
38
39	Bob Johnson
40	http://www.coinsheetlinks.com			ETFs trade at a discount to spot
41				Added to SLV for better estimate	7.14%	16.70
42				Added to GLD for better estimate	5.39%	1749.16
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96