Thread: 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.

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.

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?

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 !!!!

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.

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

I never felt the need to know the bevel angle. Am I missing something?