Author Topic: TormekCalc - calculations in Excel spreadsheet  (Read 386 times)

Offline jvh

  • Newbie
  • *
  • Posts: 4
  • I'm a sharp craftsman!
    • View Profile
TormekCalc - calculations in Excel spreadsheet
« on: March 15, 2019, 11:45:27 pm »
Hello everyone,

for precise grinding I am using TormekCalc - Excel spreadsheet which I made for:

- Height calculation of universal support bar (USB) from defined point on the Tormek housing.
- Height calculation of universal support bar (USB) from the wheel surface.
- Reverse calculation of bevel angle through "marker method".
- Knife database with the ability to load stored data from previous grinding.

Calculation is made for all used wheels (unused wheels can be hidden by column hiding).
Calculation is made for all USB's (vertical, horizontal and frontal).

Help is in comments (sorry for my bad English), drawing with used symbols and dimensions is included.

Table is locked (without password) by default, only input cells are editable. Feel free to unlock it if you know what you are doing. Improvement ideas are welcome.

Credit goes to Ton Nillesen and his book "More math for the Tormek grinder" which inspired and helped me a lot.

Enjoy!


jvh


Note: File is compressed to zip format (forum restriction), you have to unzip it before using.

Offline BobD

  • Newbie
  • *
  • Posts: 3
  • I'm a sharp craftsman!
    • View Profile
Re: TormekCalc - calculations in Excel spreadsheet
« Reply #1 on: March 16, 2019, 01:11:04 am »
Thanks for sharing this, looks like a lot of effort was put into making it. I'm excited to try it out

Offline cbwx34

  • Hero Member
  • *****
  • Posts: 1234
    • View Profile
Re: TormekCalc - calculations in Excel spreadsheet
« Reply #2 on: March 16, 2019, 03:01:39 am »
Took me a bit to get my bearings... but this spreadsheet is slick!

Wow!

Thanks for doing this.

Edit:  One thing I’ve run across, on the “Bevel Angle” sheet, the first entry for “Wheel Diameter...” has a strange drop down menu that shows up...

« Last Edit: March 16, 2019, 05:05:22 am by cbwx34 »

Online john.jcb

  • Newbie
  • *
  • Posts: 46
    • View Profile
Re: TormekCalc - calculations in Excel spreadsheet
« Reply #3 on: March 16, 2019, 02:51:33 pm »
Thank you for providing this useful spreadsheet.
I think I might spend some time today building the knife table based on the "X" dimension and bevel angle. My goal will be to have a standard set of "X" and bevel angle for a variety of knives to reduce setup time.

Offline Jan

  • Hero Member
  • *****
  • Posts: 1132
  • Iron sharpens iron, and one man sharpens another
    • View Profile
Re: TormekCalc - calculations in Excel spreadsheet
« Reply #4 on: March 16, 2019, 08:44:38 pm »
Jvh, thanks for sharing your TormekCalc - Excel spreadsheet! It is quite sophisticated script.

I have checked the numerical accuracy of your TormekCalc by calculating the height of the USB above Tormek housing and also the distance between the USB and the wheel surface. I can confirm that your results are identical with my results with an accuracy of 0.001 mm.  Congratulations!  :)

Jan

Offline jvh

  • Newbie
  • *
  • Posts: 4
  • I'm a sharp craftsman!
    • View Profile
Re: TormekCalc - calculations in Excel spreadsheet
« Reply #5 on: March 16, 2019, 09:15:27 pm »
Quote from: cbwx34
Edit:  One thing I’ve run across, on the “Bevel Angle” sheet, the first entry for “Wheel Diameter...” has a strange drop down menu that shows up...

It looks like a compatibility issue. Do you use MS Excel or other app?

It is dynamic drop down menu which shows wheels from "USB height" sheet in all visible columns. If you hide a column, corresponding wheel is exluded from drop down menu. Excel doesn't provide a function  how to do it directly, therefore auxiliary formulas are used, unfortunately they can be incompatible with other apps.

Here is slightly modified version with static drop down menu, which has limited functionality and always offer all wheels...



Quote from: Jan
I can confirm that your results are identical with my results with an accuracy of 0.001 mm.  Congratulations!

Thanks for verifying, I really appreciate it.
« Last Edit: March 16, 2019, 09:21:32 pm by jvh »

Offline cbwx34

  • Hero Member
  • *****
  • Posts: 1234
    • View Profile
Re: TormekCalc - calculations in Excel spreadsheet
« Reply #6 on: March 16, 2019, 11:25:05 pm »
Quote from: cbwx34
Edit:  One thing I’ve run across, on the “Bevel Angle” sheet, the first entry for “Wheel Diameter...” has a strange drop down menu that shows up...

It looks like a compatibility issue. Do you use MS Excel or other app?

It is dynamic drop down menu which shows wheels from "USB height" sheet in all visible columns. If you hide a column, corresponding wheel is exluded from drop down menu. Excel doesn't provide a function  how to do it directly, therefore auxiliary formulas are used, unfortunately they can be incompatible with other apps.

Here is slightly modified version with static drop down menu, which has limited functionality and always offer all wheels...


I used Excel (but the Office 365 version, if that matters).  The drop down menu to select a knife on the other page works OK.  I haven't unlocked, modified or hidden anything.

If I'm the only one seeing it... no biggie... just thought I'd let you know.  I'll give the new version a shot.

Thanks!

Edit:  Modified version appears to work... thanks!
« Last Edit: March 17, 2019, 12:18:40 am by cbwx34 »

Offline Viking

  • Newbie
  • *
  • Posts: 1
  • I'm a sharp craftsman!
    • View Profile
Re: TormekCalc - calculations in Excel spreadsheet
« Reply #7 on: March 17, 2019, 02:16:18 pm »
Thank you for sharing this, awesome!

Online john.jcb

  • Newbie
  • *
  • Posts: 46
    • View Profile
Re: TormekCalc - calculations in Excel spreadsheet
« Reply #8 on: March 17, 2019, 09:17:34 pm »
Took me a bit to get my bearings... but this spreadsheet is slick!

Wow!

Thanks for doing this.

Edit:  One thing I’ve run across, on the “Bevel Angle” sheet, the first entry for “Wheel Diameter...” has a strange drop down menu that shows up...




I see the list of wheels from the USB Height worksheet. I use Office 365.

You might try deleting the file and downloading a fresh copy. Since the workbook is locked I doubt that a cell was inadvertently changed.

Offline SHARPCO

  • Sr. Member
  • ****
  • Posts: 340
    • View Profile
Re: TormekCalc - calculations in Excel spreadsheet
« Reply #9 on: March 18, 2019, 12:51:11 pm »
Great job!

Offline cbwx34

  • Hero Member
  • *****
  • Posts: 1234
    • View Profile
Re: TormekCalc - calculations in Excel spreadsheet
« Reply #10 on: March 18, 2019, 02:23:43 pm »
I see the list of wheels from the USB Height worksheet. I use Office 365.

You might try deleting the file and downloading a fresh copy. Since the workbook is locked I doubt that a cell was inadvertently changed.

Thanks.  I did try that... and also put a fresh copy on an iPad with Excel... saw the same thing.  (Just lucky that way I guess). :)

No biggie... works fine regardless.