Where is the built in electronic calculator for the Kapex?

[AlexThePalex]

What PDF viewer and version are you using?
Are you using a mobile device?

I use:
Foxit Reader 4.3.0.1110 browser plug-in.
Firefox 26.0
Windows 7.1
Desktop PC

I am well aware of all the compatibility issues with PDF files. I use Foxit because I got sick of Adobe Acrobat reader, bloated piece of junk. Adobe simply doesn't know how to keep their programs lean and mean.

 

[gkaiseril]

I use:
Foxit Reader 4.3.0.1110 browser plug-in.
Firefox 26.0
Windows 7.1
Desktop PC

I am well aware of all the compatibility issues with PDF files. I use Foxit because I got sick of Adobe Acrobat reader, bloated piece of junk. Adobe simply doesn't know how to keep their programs lean and mean.

You have now found another one, calculations.

Also any MacIntosh users do not open a PDF file with Preview or you run a risk of corrupting it.

 

[JeromeM]

Because of these issues, I created a calculator that works in Excel, Open Office, and Numbers. You can find it here:

http://festoolownersgroup.com/festool-tools-accessories/kapex-4-cut-calculator-for-excel-open-office-numbers/msg342828/#msg342828

There is one problem with the calculator. It Will only accept numbers less than 1 in the first 2 fields. So not very good for metric use.

 

[wow]

Because of these issues, I created a calculator that works in Excel, Open Office, and Numbers. You can find it here:

http://festoolownersgroup.com/festool-tools-accessories/kapex-4-cut-calculator-for-excel-open-office-numbers/msg342828/#msg342828

There is one problem with the calculator. It Will only accept numbers less than 1 in the first 2 fields. So not very good for metric use.

Not QUITE true.

The difference between the two numbers must be less than 1. So the first number could be 500 (mm) and the second number could be 500.999, but it must be less than one.

This is controlled by the way the function works within Excel.

 

[Rick Christopherson]

Because of these issues, I created a calculator that works in Excel, Open Office, and Numbers. You can find it here:

http://festoolownersgroup.com/festool-tools-accessories/kapex-4-cut-calculator-for-excel-open-office-numbers/msg342828/#msg342828

There is one problem with the calculator. It Will only accept numbers less than 1 in the first 2 fields. So not very good for metric use.

Not QUITE true.

The difference between the two numbers must be less than 1. So the first number could be 500 (mm) and the second number could be 500.999, but it must be less than one.

This is controlled by the way the function works within Excel.

This statement didn't make any sense, so I decided to take a look at your calculator. I believe you have a missing parenthesis.

This is what is in your spreadsheet:
=0.25*DEGREES(ASIN(B2-B3)/B4)

But I believe it should be this:
=0.25*DEGREES(ASIN((B2-B3)/B4))

Your current version is taking the arcsine of B2-B3 instead of (B2-B3)/B4

 

[JeromeM]

Because of these issues, I created a calculator that works in Excel, Open Office, and Numbers. You can find it here:

http://festoolownersgroup.com/festool-tools-accessories/kapex-4-cut-calculator-for-excel-open-office-numbers/msg342828/#msg342828

There is one problem with the calculator. It Will only accept numbers less than 1 in the first 2 fields. So not very good for metric use.

Not QUITE true.

The difference between the two numbers must be less than 1. So the first number could be 500 (mm) and the second number could be 500.999, but it must be less than one.

This is controlled by the way the function works within Excel.

Really!! Rick has[attachimg=2] fixed it.

 

[wow]

Because of these issues, I created a calculator that works in Excel, Open Office, and Numbers. You can find it here:

http://festoolownersgroup.com/festool-tools-accessories/kapex-4-cut-calculator-for-excel-open-office-numbers/msg342828/#msg342828

There is one problem with the calculator. It Will only accept numbers less than 1 in the first 2 fields. So not very good for metric use.

Not QUITE true.

The difference between the two numbers must be less than 1. So the first number could be 500 (mm) and the second number could be 500.999, but it must be less than one.

This is controlled by the way the function works within Excel.

Really!! Rick has[attachimg=2] fixed it.

I SWEAR that's the formula I entered, but it's not the one that is in my spreadsheet. Obviously the one that Rick posted is correct, and the one in my file isn't/wasn't.

I have updated the file in my post to have the correct formula. Thanks for catching that, Rick!

 

[Rick Christopherson]

Darn. I was hoping to use my boxing gloves.  [poke]

 

[wow]

Darn. I was hoping to use my boxing gloves.  [poke]

I can't fight with you - I bet on you, remember?

[big grin]