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	$87.73	Wartime Nickel (1942-1945)	0.06	$1.21
5	Quarter Eagle ($2.50)	0.12	$219.32	Dime	0.07	$1.56
6	Three Dollar ($3.00)	0.15	$263.13	Quarter	0.18	$3.77
7	Half Eagle	0.24	$438.64	Half Dollar	0.36	$7.79
8	Eagle	0.48	$877.17	Half Dollar (40% 1965-1970)	0.15	$3.19
9	Double Eagle	0.97	$1,754.35	Silver Dollar	0.77	$16.67
10				Silver Eagle	1.00	$21.63
11	US GOLD BULLION	OUNCES	VALUE
12	5.00	0.10	$181.33	CANADA SILVER COINS	OUNCES	VALUE
13	10.00	0.25	$453.32	Dime (1920-1967)	0.06	$1.29
14	20.00	0.50	$906.63	Dime (1967)	0.04	$0.81
15	50.00	1.00	$1,813.26	Quarter (1920-1967)	0.15	$3.23
16				Quarter (1967-1968)	0.09	$2.02
17	CANADA GOLD COINS	OUNCES	VALUE	Half Dollar (1920-1967)	0.30	$6.46
18	5.00	0.24	$438.64	Dollar (1935-1967)	0.60	$12.87
19	10.00	0.48	$877.28
20	20.00 (1967)	0.53	$958.60	UK pre-1920 SILVER COINS	OUNCES	VALUE
21	100.00 (1976 = 14kt)	0.25	$453.33	Sixpence	0.08	$1.81
22	100.00 (1976 = 24kt)	0.50	$906.95	Shilling	0.17	$3.62
23				Florin	0.34	$7.25
24	CANADA GOLD BULLION	OUNCES	VALUE	Halfcrown	0.42	$9.06
25	1.00	0.05	$90.65
26	2.00	0.07	$120.68	UK post-1920 SILVER COINS	OUNCES	VALUE
27	5.00	0.10	$182.53	Sixpence	0.05	$0.98
28	10.00	0.25	$454.55	Shilling	0.09	$1.96
29	20.00	0.50	$908.00	Florin	0.18	$3.92
30	50.00	1.00	$1,816.00	Halfcrown	0.23	$4.90
31
32	UK GOLD COINS	OUNCES	VALUE
33	Half Sovereign	0.12	$213.98	Silver (AMEX:SLV)	SLV	$19.91
34	Sovereign	0.24	$426.12	GOLD ETF (NYSE:GLD)	GLD	$169.07
35	Double Sovereign	0.47	$854.06	GOLD ETF (AMEX:IAU)	IAU	$34.45
36	Five Pounds	1.18	$2,141.60
37				((GLD10)+(IAU50))/2		$1,706.60
38
39	Bob Johnson
40	http://www.coinsheetlinks.com			ETFs trade at a discount to spot
41				Added to SLV for better estimate	8.22%	21.55
42				Added to GLD for better estimate	6.25%	1813.26
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