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!