1. Same story, different day...........year ie more of the same fiat floods the world
    Dismiss Notice
  2. There are no markets
    Dismiss Notice
  3. Week of 6/24/2017 Closing prices & Chg Over Last Wk---- Gold $1256.40 Silver $16.64 Oil $43.01 USD $96.94
  4. "Spreading the ideas of freedom loving people on matters regarding high finance, politics, constructionist Constitution, and mental masturbation of all types"
    Dismiss Notice

Testing Zone

Discussion in 'Test postings' started by Silver Buck, Apr 17, 2011.



  1. Silver Buck

    Silver Buck Gold Member Gold Chaser

    Joined:
    Oct 22, 2010
    Messages:
    2,351
    Likes Received:
    1,506
    Trophy Points:
    113
    Occupation:
    Gin Bottler
    Location:
    Western Shores of Lake Erie
    Here's a pic of the basic structure of the sheet.

    [​IMG]

    I simply copy the info from CoinInfo and 'Paste Special - Text' onto the indicated cell in the sheet.

    [​IMG]

    [​IMG]

    The sheet will update all information.

    To add new purchase entries, simply highlight the row under the metal you purchased and 'Insert' a fresh row. In this case you would be clicking on '13'.

    [​IMG]

    Right Click and select 'Insert'.

    [​IMG]

    You will now have a fresh row to enter your information.

    [​IMG]

    As you enter your info, it will be bolded and will look like this.

    [​IMG]

    Once you are satisfied that your info is correct, you can un-bold your entry by highlighting the row and clicking on the 'Bold' button (you may have to click it twice).

    [​IMG]

    [​IMG]

    Here's your updated purchase with the sheet automatically updating the rest of your data.

    [​IMG]

    I can customize this sheet some more. I created it with entering all of the data by hand; however, I can have the sheet do any desired calculations.

    Any input is greatly appreciated.
     

Share This Page