Spreadsheet For Your Stack

[WicklowSilver]

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 )

[WicklowSilver]

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   

[Pritchard]

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.

[WicklowSilver]

Just recording video now and ahahah I am new and always open for change. Most of this sheet is a mix of my own creation and a template I found for stock market investing  

[WicklowSilver]

Video is uploading now , have two do in 2 parts as mic stopped working . Only noticed in post.

[WicklowSilver]

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 ?

 

[WicklowSilver]

Part 2

https://www.youtube.com/watch?v=FXpAavXahlM&feature=youtu.be

[SilveradoUK]

@WicklowSilver thank you! Very comprehensive spread sheet. I love it, will get it going tomorrow. 

[SilveradoUK]

It doesn’t work for me for some reason, I am probably doing something wrong...;-(

[The1GramMan]

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