Printable View
I want to be able to keep track of my razors and their usage. Last month Gasman indicated he used a spread sheet to track his so I decided to follow him. This is version one of my spread sheet. What suggestions do you have that would improve the usability of the spread sheet.Attachment 280011Thanks for looking.
Makes me wish that i had started one about ten years back! It can help a lot with taxes when selling time comes around or for those that follow you.
Great idea and my best wishes for your follow through.
~Richard
On mine i have a couple more things. Going by memory here... somewhere in the program is a way to put a link to where a picture of the razor is. I cant tell you at this time as im at work. I also have a place for notes. Chick on it and it opens up a bubble with all the notes you made like when bought, what i did the restore, if its pitted or wonky, etc... the angle of the bevel is another.
Most of tbis stuff is not important. I just like to have the info.
Gasman said "link to where a picture of the razor is". Trying to make sure I know about the picture. So you click on the link and a picture of the razor shows up, do you have to manually close the picture. Is the picture full screen or smaller?
The picture opens in another window and full size. Im at home now so...
Under insert tab. Hyperlink. Find your pic in your files on your computer and go from there. Then you can change the "text to display"for the name of the hyperlink.Attachment 280048
All of mine are marked as pic. Under image and in blue.
Sorry, i had a lot of help building this so i dont know much.
Wow, that a wierd shot. Dont know what happened.
You can insert a comment into any cell. right click and select 'Insert Comment' Type the information in and size the comment box so that all text is visible. A cell with a comment will have a small red triangle in the corner and hovering over the cell with the mouse will open the comment for reading. Comments can also be edited by a right click, 'Edit Comment'.
There are several ways to insert a hyperlink into a cell, I can detail that for you tomorrow. The hyper link can point to a file or folder on your pc or to a web page such as Imgur if that is where you prefer to keep your photo's.
Or when someone breaks in and steals them allQuote:
Originally Posted by Geezer
Thanks Joamo for the info. I have added the hyperlink and am looking at the comment options. New version coming soon.
Thanks for the inputs. I am learning a lot from this little project of mine. Here is the 2nd version. Attachment 280106
The picture of the razor will appear full screen until you close it. The note area can be expanded as needed and appears and disappears when you move the cursor.
Its coming along fine. I also use the notes window like that. Im just not smart enough to know how to make the stuff/options. Thats why i got computer smart friends close at hand.
It has been a couple of weeks since m last post. Nothing new to add to the spreadsheet so I will add some instructions so others can create there own.
I wanted the top row to be stationary so I went to the horizontal tabs select VIEW then FREEZE FRAME TOP ROW.
Notes right click on the cell you want to note to be in and select COMMENT then adjust the box size
Insert pictures select the horizontal tab INSERT then HYPERLINK select the picture you want and click on OK
Thanks for the suggestions.
Al
I've got a row that shows what I paid for the razor and what I think its worth if I was to sell it. Its all just info on anything I can come up with. Lots of the info I have on rows are not real important info but stuff I just wanted so I dont forget.
You can also filter your columns. This would create a drop menu of the contents of each column you have, say that you select 6/8 blades, every row that doesn't have 6/8 in this column will be hidden. The remaining rows could also be filtered by whatever columns of data in your sheet, for example, wedge blades, then Wade & Butcher, date last used etc.
It's an interesting way of choosing your shave of the day or just seeing how many 6/8 Sheffield wedges you have. :hmmm:
Ive heard of doing this. Filtering. If a guy had a couple hundred razors it would be a nice option.
