So… Being a programmer, and having a few spare hours at work I decided to create a simple dovetail calculator tool using Microsoft Excel (and VBA coding) – here is my first version of this:
When I have more free time, I am thinking of having the measurements display on the screen, so you could print out the results. Any thoughts on this application welcome (and I hope you can download and run the application – and yes, having Macros in it you will need to trust the macros).Note that the illustrations generated by the code was meant for quick and easy responses to questions such as:
- What if I had 4 tails instead of 3
- or perhaps I should use 14 mm Pins instead of 12 mm pins
Credit for the mathematics of this goes to Norman Havens, not that I know who he is, where he lives or what he does, but I found his web page a great source (thanks Norm): http://www2.gol.com/users/nhavens/htmlfile/dt1-e.html
For those of you who like to do this by hand in the shed – so do I, but if you are stuck at work (like I was) at a computer with the skills to create something as simple as this, then why not?
While I could find apps online that perform this job already, no one seems willing to share the formulas they have used. So if you know anything about VBA, feel free to look at my formulas.
-- I know what the tools are, I know what they are used for, now I just have to learn how to apply the fine art and start using them.