Page 1 of 2 12 LastLast
Results 1 to 10 of 14
Like Tree7Likes

Thread: looking for inputs on spread sheet

  1. #1
    boz
    boz is offline
    Senior Member boz's Avatar
    Join Date
    Aug 2017
    Location
    Loveland, Colorado
    Posts
    224
    Thanked: 41

    Default looking for inputs on spread sheet

    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.Name:  raz2.jpg
Views: 233
Size:  64.0 KBThanks for looking.
    Geezer, Havachat45 and Addison like this.

  2. The Following User Says Thank You to boz For This Useful Post:

    Geezer (12-10-2017)

  3. #2
    Senior Member blabbermouth Geezer's Avatar
    Join Date
    Jul 2010
    Location
    EauClaire,WI
    Posts
    7,685
    Thanked: 3825
    Blog Entries
    1

    Default

    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
    Be yourself; everyone else is already taken.
    - Oscar Wilde

  4. #3
    Skeptical Member Gasman's Avatar
    Join Date
    Nov 2016
    Location
    Colorado Springs
    Posts
    10,473
    Thanked: 2182

    Default

    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.
    Geezer and xiaotuzi like this.
    It's just Sharpening, right?
    Jerry...

  5. #4
    boz
    boz is offline
    Senior Member boz's Avatar
    Join Date
    Aug 2017
    Location
    Loveland, Colorado
    Posts
    224
    Thanked: 41

    Default

    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?

  6. #5
    Skeptical Member Gasman's Avatar
    Join Date
    Nov 2016
    Location
    Colorado Springs
    Posts
    10,473
    Thanked: 2182

    Default

    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.Name:  1512951549497-1983576086.jpg
Views: 193
Size:  55.7 KB

    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.
    Geezer likes this.
    It's just Sharpening, right?
    Jerry...

  7. #6
    Senior Member joamo's Avatar
    Join Date
    Dec 2011
    Location
    Omaha, Ne
    Posts
    468
    Thanked: 259

    Default

    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.

  8. The Following User Says Thank You to joamo For This Useful Post:

    boz (12-11-2017)

  9. #7
    Senior Member Havachat45's Avatar
    Join Date
    May 2011
    Location
    Redbank, Queensland, Australia
    Posts
    1,639
    Thanked: 291

    Default

    Quote Originally Posted by Geezer View Post
    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
    Or when someone breaks in and steals them all
    Hang on and enjoy the ride...

  10. #8
    boz
    boz is offline
    Senior Member boz's Avatar
    Join Date
    Aug 2017
    Location
    Loveland, Colorado
    Posts
    224
    Thanked: 41

    Default

    Thanks Joamo for the info. I have added the hyperlink and am looking at the comment options. New version coming soon.

  11. #9
    boz
    boz is offline
    Senior Member boz's Avatar
    Join Date
    Aug 2017
    Location
    Loveland, Colorado
    Posts
    224
    Thanked: 41

    Default Spread sheet Ver 2

    Thanks for the inputs. I am learning a lot from this little project of mine. Here is the 2nd version. Name:  raz ver2.jpg
Views: 159
Size:  68.9 KB
    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.

  12. #10
    Skeptical Member Gasman's Avatar
    Join Date
    Nov 2016
    Location
    Colorado Springs
    Posts
    10,473
    Thanked: 2182

    Default

    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.
    boz likes this.
    It's just Sharpening, right?
    Jerry...

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •