Page 1 of 2 12 LastLast
Results 1 to 10 of 20
Like Tree16Likes

Thread: Spreadsheet formula

  1. #1
    Skeptical Member Gasman's Avatar
    Join Date
    Nov 2016
    Location
    Colorado Springs
    Posts
    10,539
    Thanked: 2190

    Default Spreadsheet formula

    I was given an excel spreadsheet that also figures out bevel angles from a fine member here on the forum. Now i want to make my own. I have a friend stopping by for brats and beer on monday who is a retired computer programmer. And he said that when he worked for Hp he fixed excel and its issuesmany years ago. So i think im in good hands.

    But today he asked me if i had the formula for the bevel angle to input. I had to tell him no but id try to.get it. So... anyone have this info? What would be needed to input into excel? He said he ould most likely come up with it but if i could find it would be quicker.

    Thanks for any help.
    It's just Sharpening, right?
    Jerry...

  2. #2
    Skeptical Member Gasman's Avatar
    Join Date
    Nov 2016
    Location
    Colorado Springs
    Posts
    10,539
    Thanked: 2190

    Default

    I told him i asked for it on the forum. He said not to worry as he can come up with it but if someone already knows it it would be helpful.
    It wasnt too long ago that i learned that / was the same as ÷ so he knows my limits. Great friend and doesnt make me feel stupid when it would be so easy for him to do.

    Thanks again for any help.
    It's just Sharpening, right?
    Jerry...

  3. #3
    Senior Member jmabuse's Avatar
    Join Date
    Nov 2016
    Posts
    250
    Thanked: 122

    Default

    Hi Jerry, do you want to calculate the bevel angle given the spine width and the blade's width, or do you want to figure out the blade's width to aim for (like if you're making a blade) given a spine width and a bevel angle you want to end up with?
    Last edited by jmabuse; 11-04-2017 at 08:07 PM.

  4. #4
    At this point in time... gssixgun's Avatar
    Join Date
    Jun 2007
    Location
    North Idaho Redoubt
    Posts
    27,031
    Thanked: 13246
    Blog Entries
    1

    Default

    This is the Google box calculation


    (2 * asin(.181 / (2 * .620)) * 180) / pi = 16.786646


    Blue = Spine width
    Red = Blade height

    Plug in the numbers, Copy it to the Google Search box and Boom Math !!!!
    Substance and joelkerr like this.
    "No amount of money spent on a Stone can ever replace the value of the time it takes learning to use it properly"
    Very Respectfully - Glen

    Proprietor - GemStar Custom Razors Honing/Restores/Regrinds Website

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

    Default

    Thanks Glen. Ill give it to him and see what he comes up with. Its beyond me. Theres letters in that. Not the kind of math i know.
    gssixgun and 32t like this.
    It's just Sharpening, right?
    Jerry...

  6. #6
    Senior Member blabbermouth
    Join Date
    Mar 2012
    Location
    Thunder Bay, Ontario, Canada
    Posts
    17,307
    Thanked: 3227

    Default

    You can download the excel file from here http://coticule.be/wedges.html to calculate bevel angles. Just plug in the measurements for your answer. Close enough for horse shoes and hand grenades. for me anyway.

    Bob
    Substance likes this.
    Life is a terminal illness in the end

  7. The Following 2 Users Say Thank You to BobH For This Useful Post:

    joamo (11-04-2017), Substance (11-05-2017)

  8. #7
    Senior Member blabbermouth Kees's Avatar
    Join Date
    Jun 2006
    Location
    The Netherlands
    Posts
    5,475
    Thanked: 656

    Default

    I never felt the need to know the bevel angle. Am I missing something?
    Plus ça change, plus c'est la même chose. Jean-Baptiste Alphonse Karr.

  9. #8
    32t
    32t is offline
    Senior Member blabbermouth 32t's Avatar
    Join Date
    Oct 2010
    Location
    50 miles west of randydance
    Posts
    9,668
    Thanked: 1354

    Default

    Quote Originally Posted by Kees View Post
    I never felt the need to know the bevel angle. Am I missing something?
    If you buy a good razor someone else has already thought about it and you probably don't need to know.

    But like many things here can be carried to the extreme!
    sharptonn likes this.

  10. The Following User Says Thank You to 32t For This Useful Post:

    Kees (11-05-2017)

  11. #9
    Skeptical Member Gasman's Avatar
    Join Date
    Nov 2016
    Location
    Colorado Springs
    Posts
    10,539
    Thanked: 2190

    Default

    Thanks Bob. We tried that and my program was too old so you hooked me up with the one I have now. Now I want to change things around and dont know enough to do it so I'll have a friend do it for me and make a new one. That's the plan anyhow.

    I'm not making blades or anything like that. I just like to know the angles of my razors. Its just because. No real reason. Just more info on what I have. Hoping that maybe it will some day tell me something about the razors I own and what I like more. If not then its just to have the info.

    And your right Kees. I see no need except I just want it.

    Bob, He might be able to pull the info off the file I have now but I'm afraid it could be off. As most of my razors as way high according to that program. Could be right. I'm just wanting to be more sure and with the help of a local friend I'll be able to compare and know whats right on wrong.
    Kees likes this.
    It's just Sharpening, right?
    Jerry...

  12. #10
    'with that said' cudarunner's Avatar
    Join Date
    Aug 2010
    Location
    Walla Walla in WA State USA
    Posts
    11,230
    Thanked: 4237

    Default

    Quote Originally Posted by Gasman View Post

    I'm not making blades or anything like that. I just like to know the angles of my razors. Its just because. No real reason. Just more info on what I have. Hoping that maybe it will some day tell me something about the razors I own and what I like more. If not then its just to have the info.

    And your right Kees. I see no need except I just want it.
    Be careful for what you wish for my friend, you might not like the answers you get. And remember what can happen with curiosity.

    Name:  Curiosity.jpg
Views: 111
Size:  62.4 KB
    Speedster and MikeB52 like this.
    Our house is as Neil left it- an Aladdins cave of 'stuff'.

    Kim X

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
  •