• Same story, different day...........year ie more of the same fiat floods the world
  • There are no markets
  • "Spreading the ideas of freedom loving people on matters regarding high finance, politics, constructionist Constitution, and mental masturbation of all types"

*TEST* Spreadsheet Layout

JayDubya

Platinum Bling
Platinum Bling
Joined
Apr 5, 2010
Messages
4,317
Likes
4,592
#1
Country & Denomination Years Minted Gross Weight Grams Fineness Net Gold Weight Grams Gold Weight Troy Ounces $1,284.70

UNITED STATES
50 Dollars 1915 83.592 0.9 75.2328 2.4188 $3,107.43
20 Dollars 1850-1933 33.437 0.9 30.0933 0.9675 $1,242.95
10 Dollars 1795-1804 17.4957 0.9167 16.0377 0.5156 $662.39
10 Dollars 1838-1933 16.7185 0.9 15.0467 0.4838 $621.54
5 Dollars 1795-1833 8.748 0.9167 8.019 0.2578 $331.20
5 Dollars 1834-1836 8.3592 0.8993 7.5174 0.2417 $310.51
5 Dollars 1837-1929 8.3592 0.9 7.5233 0.2419 $310.77
4 Dollars 1879-1880 6.6872 0.9 6.0185 0.1935 $248.59
3 Dollars 1854-1889 5.0154 0.9 4.5139 0.1451 $186.41
2½ Dollars 1796-1833 4.374 0.9167 4.0095 0.1289 $165.60
2½ Dollars 1834-1836 4.1796 0.9 3.7616 0.1209 $155.32
2½ Dollarn 1837-1929 4.1796 0.9 3.7616 0.1209 $155.32
1 Dollar 1849-1889 1.6718 0.9 1.5046 0.0484 $62.18
 

JayDubya

Platinum Bling
Platinum Bling
Joined
Apr 5, 2010
Messages
4,317
Likes
4,592
#2
Country & Denomination Years Minted Gross Weight Grams Fineness Net Gold Weight Grams Gold Weight Troy Ounces $1,284.70
UNITED STATES
50 Dollars 1915 83.592 0.9 75.2328 2.4188 $3,107.43
20 Dollars 1850-1933 33.437 0.9 30.0933 0.9675 $1,242.95
10 Dollars 1795-1804 17.4957 0.9167 16.0377 0.5156 $662.39
10 Dollars 1838-1933 16.7185 0.9 15.0467 0.4838 $621.54
5 Dollars 1795-1833 8.748 0.9167 8.019 0.2578 $331.20
5 Dollars 1834-1836 8.3592 0.8993 7.5174 0.2417 $310.51
5 Dollars 1837-1929 8.3592 0.9 7.5233 0.2419 $310.77
4 Dollars 1879-1880 6.6872 0.9 6.0185 0.1935 $248.59
3 Dollars 1854-1889 5.0154 0.9 4.5139 0.1451 $186.41
2½ Dollars 1796-1833 4.374 0.9167 4.0095 0.1289 $165.60
2½ Dollars 1834-1836 4.1796 0.9 3.7616 0.1209 $155.32
2½ Dollarn 1837-1929 4.1796 0.9 3.7616 0.1209 $155.32
1 Dollar 1849-1889 1.6718 0.9 1.5046 0.0484 $62.18
 

JayDubya

Platinum Bling
Platinum Bling
Joined
Apr 5, 2010
Messages
4,317
Likes
4,592
#4
I've created an excel spreadsheet that I think others would find helpful.

It shows Country & Denomination, Years Minted, Gross Weight in Grams, Fineness, Net Gold Weight Grams, and Gold Weight in Troy Ounces for every gold coin that has ever been minted (as far as I can determine). Although I'm still missing the stats for a few of them.

Anyway, I've included a cell that is dynamic, where one can enter today's spot price and the melt value for the coins will automatically be calculated.

The layout above is a portion of the U.S. coins section of the spreadsheet. I was trying to show the concept here to ask if others would be interested in the spreadsheet but the data will not stay in columns no matter how I type it into the "quick reply" box.
 

blueice

Gold Chaser
Platinum Bling
Joined
Jun 16, 2013
Messages
3,126
Likes
1,327
#5
The layout above is a portion of the U.S. coins section of the spreadsheet. I was trying to show the concept here to ask if others would be interested in the spreadsheet but the data will not stay in columns no matter how I type it into the "quick reply" box.
It will if you pay a tribute..
 

<===Foolsgold

Gold Chaser
Platinum Bling
Site Supporter ++
Joined
Mar 31, 2010
Messages
3,898
Likes
3,445
Location
Pennsyltucky
#6
What is a - 50 Dollars 1915

Please?
 

PhucilliJerry

Gold Member
Gold Chaser
Joined
Feb 3, 2011
Messages
1,021
Likes
772
#8
I have a few similar spreadsheets I use for general reference and coin shows and another one for the eBay deals thread when there are eBay bucks offers. You can do tables on this forum, but I have been unable to make them dynamic......


[TABLE="class: grid, width: 589"]
[TR]
[TD]Denomination[/TD]
[TD]Years Minted[/TD]
[TD]Gross Weight[/TD]
[TD]Fineness[/TD]
[TD]Net Gold[/TD]
[TD]Gold Weight[/TD]
[TD] $1,284.70[/TD]
[/TR]
[TR]
[TD]UNITED STATES[/TD]
[TD][/TD]
[TD]Grams[/TD]
[TD][/TD]
[TD]Weight Grams[/TD]
[TD]Troy Ounces[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]50 Dollars[/TD]
[TD]1915[/TD]
[TD]83.592[/TD]
[TD]0.9[/TD]
[TD]75.2328[/TD]
[TD]2.4188[/TD]
[TD] $3,107.43
[/TD]
[/TR]
[TR]
[TD]20 Dollars[/TD]
[TD]1850-1933[/TD]
[TD]33.437[/TD]
[TD]0.9[/TD]
[TD]30.0933[/TD]
[TD]0.9675[/TD]
[TD] $1,242.95[/TD]
[/TR]
[TR]
[TD]10 Dollars[/TD]
[TD]1795-1804[/TD]
[TD]17.4957[/TD]
[TD]0.9167[/TD]
[TD]16.0377[/TD]
[TD]0.5156[/TD]
[TD] $662.39[/TD]
[/TR]
[TR]
[TD]10 Dollars[/TD]
[TD]1838-1933[/TD]
[TD]16.7185[/TD]
[TD]0.9[/TD]
[TD]15.0467[/TD]
[TD]0.4838[/TD]
[TD] $621.54[/TD]
[/TR]
[TR]
[TD]5 Dollars[/TD]
[TD]1795-1833[/TD]
[TD]8.748[/TD]
[TD]0.9167[/TD]
[TD]8.019[/TD]
[TD]0.2578[/TD]
[TD] $331.20[/TD]
[/TR]
[TR]
[TD]5 Dollars[/TD]
[TD]1834-1836[/TD]
[TD]8.3592[/TD]
[TD]0.8993[/TD]
[TD]7.5174[/TD]
[TD]0.2417[/TD]
[TD] $310.51[/TD]
[/TR]
[TR]
[TD]5 Dollars[/TD]
[TD]1837-1929[/TD]
[TD]8.3592[/TD]
[TD]0.9[/TD]
[TD]7.5233[/TD]
[TD]0.2419[/TD]
[TD] $310.77[/TD]
[/TR]
[TR]
[TD]4 Dollars[/TD]
[TD]1879-1880[/TD]
[TD]6.6872[/TD]
[TD]0.9[/TD]
[TD]6.0185[/TD]
[TD]0.1935[/TD]
[TD] $248.59[/TD]
[/TR]
[TR]
[TD]3.0 Dollars[/TD]
[TD]1854-1889[/TD]
[TD]5.0154[/TD]
[TD]0.9[/TD]
[TD]4.5139[/TD]
[TD]0.1451[/TD]
[TD] $186.41[/TD]
[/TR]
[TR]
[TD]2.5 Dollars[/TD]
[TD]1796-1833[/TD]
[TD]4.374[/TD]
[TD]0.9167[/TD]
[TD]4.0095[/TD]
[TD]0.1289[/TD]
[TD] $165.60[/TD]
[/TR]
[TR]
[TD]2.5 Dollars[/TD]
[TD]1834-1836[/TD]
[TD]4.1796[/TD]
[TD]0.9[/TD]
[TD]3.7616[/TD]
[TD]0.1209[/TD]
[TD] $155.32[/TD]
[/TR]
[TR]
[TD]2.5 Dollars[/TD]
[TD]1837-1929[/TD]
[TD]4.1796[/TD]
[TD]0.9[/TD]
[TD]3.7616[/TD]
[TD]0.1209[/TD]
[TD] $155.32[/TD]
[/TR]
[TR]
[TD]1.0 Dollar[/TD]
[TD]1849-1889[/TD]
[TD]1.6718[/TD]
[TD]0.9[/TD]
[TD]1.5046[/TD]
[TD]0.0484[/TD]
[TD] $62.18[/TD]
[/TR]
[/TABLE]

Go advanced, copy and paste your data in from Excel. Highlight the data pasted, click Table Properties, choose full grid under table style if so desired. The alignment option seems to only move the entire table left, center or right, not the data in each field. Align your data in Excel before copying (still doesn't always carry over). You can insert working links as well, as I do in the eBay thread for a quick link to the deal on each coin......
 

JayDubya

Platinum Bling
Platinum Bling
Joined
Apr 5, 2010
Messages
4,317
Likes
4,592
#12
Well Jerry, you've nailed the layout. But like you said, there's no way to make it dynamic. In the excel spreadsheet all one has to do is type today's spot price in the cell that currently shows $1284.70 and the melt values for all the coins automatically adjust.

I've compiled just shy of 2,500 gold coins from throughout the world. I do not have full/complete info for some coins from Brunei, China, India, Iran, Netherlands, Switzerland and Transylvania. Mostly missing years minted, but actual weights for some of them.

Nobody in their right mind would sell many of them for melt value, but after compiling the list of coins and their weights, it just seemed like a logical exerise to do something with all that data.
 
Last edited:

pre-64'

Slaying Debt for Gold
Gold Chaser
Joined
Mar 31, 2010
Messages
1,298
Likes
1,091
#13
Another way is to export it as .jpg file. But again it isn't dynamic.
 

mayhem

Другая перспектива
Silver Miner
Site Supporter
Joined
Mar 30, 2010
Messages
3,769
Likes
5,230
#16
I have a few similar spreadsheets I use for general reference and coin shows and another one for the eBay deals thread when there are eBay bucks offers. You can do tables on this forum, but I have been unable to make them dynamic......


[TABLE="class: grid, width: 589"]
[TR]
[TD]Denomination[/TD]
[TD]Years Minted[/TD]
[TD]Gross Weight[/TD]
[TD]Fineness[/TD]
[TD]Net Gold[/TD]
[TD]Gold Weight[/TD]
[TD] $1,284.70[/TD]
[/TR]
[TR]
[TD]UNITED STATES[/TD]
[TD][/TD]
[TD]Grams[/TD]
[TD][/TD]
[TD]Weight Grams[/TD]
[TD]Troy Ounces[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]50 Dollars[/TD]
[TD]1915[/TD]
[TD]83.592[/TD]
[TD]0.9[/TD]
[TD]75.2328[/TD]
[TD]2.4188[/TD]
[TD] $3,107.43
[/TD]
[/TR]
[TR]
[TD]20 Dollars[/TD]
[TD]1850-1933[/TD]
[TD]33.437[/TD]
[TD]0.9[/TD]
[TD]30.0933[/TD]
[TD]0.9675[/TD]
[TD] $1,242.95[/TD]
[/TR]
[TR]
[TD]10 Dollars[/TD]
[TD]1795-1804[/TD]
[TD]17.4957[/TD]
[TD]0.9167[/TD]
[TD]16.0377[/TD]
[TD]0.5156[/TD]
[TD] $662.39[/TD]
[/TR]
[TR]
[TD]10 Dollars[/TD]
[TD]1838-1933[/TD]
[TD]16.7185[/TD]
[TD]0.9[/TD]
[TD]15.0467[/TD]
[TD]0.4838[/TD]
[TD] $621.54[/TD]
[/TR]
[TR]
[TD]5 Dollars[/TD]
[TD]1795-1833[/TD]
[TD]8.748[/TD]
[TD]0.9167[/TD]
[TD]8.019[/TD]
[TD]0.2578[/TD]
[TD] $331.20[/TD]
[/TR]
[TR]
[TD]5 Dollars[/TD]
[TD]1834-1836[/TD]
[TD]8.3592[/TD]
[TD]0.8993[/TD]
[TD]7.5174[/TD]
[TD]0.2417[/TD]
[TD] $310.51[/TD]
[/TR]
[TR]
[TD]5 Dollars[/TD]
[TD]1837-1929[/TD]
[TD]8.3592[/TD]
[TD]0.9[/TD]
[TD]7.5233[/TD]
[TD]0.2419[/TD]
[TD] $310.77[/TD]
[/TR]
[TR]
[TD]4 Dollars[/TD]
[TD]1879-1880[/TD]
[TD]6.6872[/TD]
[TD]0.9[/TD]
[TD]6.0185[/TD]
[TD]0.1935[/TD]
[TD] $248.59[/TD]
[/TR]
[TR]
[TD]3.0 Dollars[/TD]
[TD]1854-1889[/TD]
[TD]5.0154[/TD]
[TD]0.9[/TD]
[TD]4.5139[/TD]
[TD]0.1451[/TD]
[TD] $186.41[/TD]
[/TR]
[TR]
[TD]2.5 Dollars[/TD]
[TD]1796-1833[/TD]
[TD]4.374[/TD]
[TD]0.9167[/TD]
[TD]4.0095[/TD]
[TD]0.1289[/TD]
[TD] $165.60[/TD]
[/TR]
[TR]
[TD]2.5 Dollars[/TD]
[TD]1834-1836[/TD]
[TD]4.1796[/TD]
[TD]0.9[/TD]
[TD]3.7616[/TD]
[TD]0.1209[/TD]
[TD] $155.32[/TD]
[/TR]
[TR]
[TD]2.5 Dollars[/TD]
[TD]1837-1929[/TD]
[TD]4.1796[/TD]
[TD]0.9[/TD]
[TD]3.7616[/TD]
[TD]0.1209[/TD]
[TD] $155.32[/TD]
[/TR]
[TR]
[TD]1.0 Dollar[/TD]
[TD]1849-1889[/TD]
[TD]1.6718[/TD]
[TD]0.9[/TD]
[TD]1.5046[/TD]
[TD]0.0484[/TD]
[TD] $62.18[/TD]
[/TR]
[/TABLE]

Go advanced, copy and paste your data in from Excel. Highlight the data pasted, click Table Properties, choose full grid under table style if so desired. The alignment option seems to only move the entire table left, center or right, not the data in each field. Align your data in Excel before copying (still doesn't always carry over). You can insert working links as well, as I do in the eBay thread for a quick link to the deal on each coin......
OK, this formatting probably worked with VB. I know it works in SMF, but doesn't seem to work with XenForo.
 

ttazzman

Midas Member
Midas Member
Site Supporter ++
Joined
Apr 2, 2010
Messages
4,818
Likes
4,248
Location
mid-usa
#17
i did a excel spread sheet with similar parameters as your doing ...i added a user multiplier on each item which i called "premium" ...point was i wanted to be able to assign rare coins a premium over spot value and have that added to the total....

i use mine for inventory and value......i can change the spot price and it updates everything etc..
 

Goldhedge

Moderator
Site Mgr
Sr Site Supporter
Joined
Mar 28, 2010
Messages
30,526
Likes
37,228
Location
Planet Earth
#18
Sounds as if you'll need to create a website and embed the excel sheet.

Then you can share the link?

Here's one idea with MSFTs One Drive

Better Ways to Embed Tables and Spreadsheets in Web Pages

Don't know if this will work here, but worth a look see...
 

mayhem

Другая перспектива
Silver Miner
Site Supporter
Joined
Mar 30, 2010
Messages
3,769
Likes
5,230
#19
Sounds as if you'll need to create a website and embed the excel sheet.

Then you can share the link?

Here's one idea with MSFTs One Drive

Better Ways to Embed Tables and Spreadsheets in Web Pages

Don't know if this will work here, but worth a look see...
That would always be the best way, even if the software says it supports tables, there still are errors.

I know someone who uses google doc's and then links to the spread sheet. I don't use google anything so I don't know if it is interactive or not.
 

Goldhedge

Moderator
Site Mgr
Sr Site Supporter
Joined
Mar 28, 2010
Messages
30,526
Likes
37,228
Location
Planet Earth
#20
I think it is interactive.