Jump to content
  • The above Banner is a Sponsored Banner.

    Upgrade to Premium Membership to remove this Banner & All Google Ads. For full list of Premium Member benefits Click HERE.

  • Join The Silver Forum

    The Silver Forum is one of the largest and best loved silver and gold precious metals forums in the world, established since 2014. Join today for FREE! Browse the sponsor's topics (hidden to guests) for special deals and offers, check out the bargains in the members trade section and join in with our community reacting and commenting on topic posts. If you have any questions whatsoever about precious metals collecting and investing please join and start a topic and we will be here to help with our knowledge :) happy stacking/collecting. 10,000+ forum members. 

Recommended Posts

Hi guys I am a massive fan of spreadsheets and tracking things ( I understand for some people the less there is on paper about their stack the better) , so for those who are also into that stuff I have a sample template to share .

I use this to track my stack atm and I also have a version that is used on my personal finance spreadsheet (which I can also share later).

This sheet uses Google sheets + Forms . Majority of the data entry is done via google forms and only 4 or so things need to be done on the sheet itslef.

 

Link to folder https://drive.google.com/drive/folders/1GqG2v11OBK4Yfbil0Jb45XpDgYSIG6mw?usp=sharing

NOTE! You make a copy of the folder and then customize yourself . 

HOW TO USE:

[Will add this later , but in the mean time will have a VIDEO explaining it ]

link to video:

 

NOTE! I have a more advanced version which uses google app scripts  but this working on user friendly stuff (I hope to have this out within next few months )

Edited by WicklowSilver

Share this post


Link to post
Share on other sites

Also I am trying to make a database that pulls live value of bars/coins/rounds so that when valuing your stack,this spreadsheet does it in terms of current price of 1 oz  or resale value (and u can adjust for what % u want to take off that price as well when u value your stack/individual item as I personally always am very conservative when I value my items)

 

Any feedback (what u thing needs to be added or taken away )would be greatly appreciated   

Share this post


Link to post
Share on other sites
On 21/01/2019 at 14:35, Pritchard said:

I havent seen your linky (as i am at work) but there a few other chaps who publish their sheets too....

My 6th Sense detects a Speadsheet War coming :) 
all the same, thanks for sharing.

What do u think of mine ?

 

Share this post


Link to post
Share on other sites

Hi Everyone,

How can I download this spreadsheet so I can use it my self, when I open the link I can find anywhere to download them. 

Thanks 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Cookies & terms of service

We have placed cookies on your device to help make this website better. By continuing to use this site you consent to the use of cookies and to our Privacy Policy & Terms of Use