Dado Spreadsheet

Dado Excel Spreadsheet

I have had a few queries about the original Excel spreadsheet that I created to generate my precise dado table (the one with 3000 or so combinations).

I have attached it, but here is the disclaimer:  it is nowhere as neat as Excel spreadsheets can be, but this was the easiest way I could make it to deal with the number of combinations.  Someone familiar with the latest versions of Excel would be able to do a much better job, but I haven’t used it since the XLSX format came out, so there have been a lot of changes since the last time I did use it.

Column A: All combinations must include the combination of the two outside blades, so this column is always “1”
Column B: The number of 1/8″ chipper blades used in the stack. The set I had provided 4
Column C: Whether or not the 1/16″ chipper blade is included.
Column D – G: The number and size of the various shims included in the stack.

Column H: This is the theoretical width. Add to this the additional width that is created by the runout of the saw and blades. This is easily achieved by setting up a basic stack, with the theoretical thickness from the spreadsheet. Make a dado cut, and measure the actual width. The difference is caused by the combination of runout from the various blades, and the saw.

Column I: This is the runout. At this stage I only have calculated the runout for one setup. If you wanted to be even more exact, you could calculate the runout for each blade the same way, and amend column I accordingly.

Column J: This is the money column – the final size of the stack that is built.

Column K – Q: These are the calculating columns – leave these alone.

Columns R – X: Input each of the widths of the various blades and shims.

As I said: it is not the most eloquent spreadsheet. But it works, for me at least!

Dado Excel Spreadsheet

Click here to see the dado blade at Toolstoday.com

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: