LumberJocks

Dovetail Calculator #1: My First Post in a Long, Long Time!

  • Advertise with us
Blog entry by Andrew Wood posted 07-09-2013 05:39 AM 1511 reads 0 times favorited 1 comment Add to Favorites Watch
no previous part Part 1 of Dovetail Calculator series Part 2: Slowly Getting There »

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:

Office 2010 Excel Document here: https://www.box.com/s/s0cdmjj4b3cj9bjsg1cv
Office 2003 Excel Document here: https://www.box.com/s/g6q3g92nsgebf0tkkzin

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.



1 comment so far

View Andrew Wood's profile

Andrew Wood

19 posts in 2515 days


#1 posted 07-19-2013 04:26 AM

Please note that these files are now out of date. Refer to later postings for newer versions with more functionality.

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

Have your say...

You must be signed in to post the comments.

DISCLAIMER: Any posts on LJ are posted by individuals acting in their own right and do not necessarily reflect the views of LJ. LJ will not be held liable for the actions of any user.

Latest Projects | Latest Blog Entries | Latest Forum Topics

HomeRefurbers.com