Kreg Jig Mini Measurements? - Kreg Owners' Community2024-03-29T12:01:46Zhttps://kregjig.ning.com/forum/topics/kreg-jig-mini-measurements?commentId=2900167%3AComment%3A950898&x=1&feed=yes&xn_auth=noUsing simple linear regressio…tag:kregjig.ning.com,2018-04-14:2900167:Comment:9508982018-04-14T16:58:08.894ZKen Kortchhttps://kregjig.ning.com/profile/KenKortge
<p>Using simple linear regression (fitting a line of best fit through points on a graph):</p>
<p></p>
<p>Thickness = Material Thickness</p>
<p><br></br>Distance_from_Edge = -1.076923077 + (1.538461538 x Thickness)</p>
<p></p>
<p>Drill_Collar_Depth = 2.814903846 + (0.951923077 x Thickness)</p>
<p></p>
<p>Screw_Length = 0.826923077 + (0.461538462 x Thickness)</p>
<p></p>
<p>A negative Distance_from_Edge means that the jig is hanging over the material.</p>
<p><br></br>Actual:</p>
<p>Thkns, Edge, Colr,…</p>
<p>Using simple linear regression (fitting a line of best fit through points on a graph):</p>
<p></p>
<p>Thickness = Material Thickness</p>
<p><br/>Distance_from_Edge = -1.076923077 + (1.538461538 x Thickness)</p>
<p></p>
<p>Drill_Collar_Depth = 2.814903846 + (0.951923077 x Thickness)</p>
<p></p>
<p>Screw_Length = 0.826923077 + (0.461538462 x Thickness)</p>
<p></p>
<p>A negative Distance_from_Edge means that the jig is hanging over the material.</p>
<p><br/>Actual:</p>
<p>Thkns, Edge, Colr, Scrw</p>
<p>0.5, -0.25, 3.3125, 1</p>
<p>0.75, 0, 3.5, 1.25,</p>
<p>1.5, 1.25, 4.25, 1.5</p>
<p></p>
<p>Estimated:</p>
<p>Thkns, Edge, Colr, Scrw,</p>
<p>0.5, -0.31, 3.29, 1.06</p>
<p>0.75, 0.08, 3.53, 1.17</p>
<p>1.5, 1.23, 4.24, 1.52</p>
<p></p>
<p>Not too bad. I hope this helps you until/if Kreg can give better information.</p>
<p></p>
<p>Ken</p> John,
Sorry for posting to th…tag:kregjig.ning.com,2018-04-14:2900167:Comment:9507912018-04-14T13:31:32.516ZJoe Wicklinehttps://kregjig.ning.com/profile/JoeWickline
<p>John,</p>
<p>Sorry for posting to this old thread but like others I too having purchased the Kreg mini-jig and set out to solve this trig problem. I was in process of doing a search to see if jig dimensions (those that you provided as “z” - 70 mm and “x” – 35.45 mm) were public knowledge anywhere to ensure my calculations were correct when I came across your post. I believe there is an error in your sketch however in that you should reverse positions of “w” and “≈x” where they appear along…</p>
<p>John,</p>
<p>Sorry for posting to this old thread but like others I too having purchased the Kreg mini-jig and set out to solve this trig problem. I was in process of doing a search to see if jig dimensions (those that you provided as “z” - 70 mm and “x” – 35.45 mm) were public knowledge anywhere to ensure my calculations were correct when I came across your post. I believe there is an error in your sketch however in that you should reverse positions of “w” and “≈x” where they appear along the drill bit centerline such that the sketch will align with the assumption you stated as:</p>
<p></p>
<ul>
<li>“<em>that the depth of wood left from the bottom of the pocket to the timber face is equal to the thickness of the timber</em>”</li>
</ul>
<p></p>
<p>The way you have it sketched is showing the depth of wood <strong><u>removed</u></strong> as equal to thickness of lumber when in fact the “face” being referred to in the assumption is the face of the joint and not the face where the bit first enters the wood. Reversing positions of these two variables makes sense because it is the wood that remains (not wood removed) that resist tear out of the joint. It is also why the problem is not as simple as adding 70mm to the thickness of wood being used as one reader suggested (although that reason would align with the drawing provided). In fact ≈x must be calculated as I supsect you have done.</p>
<p>The other assumption needed to solve this problem with certainty (which you show in your sketch and use in the equations but did not explicitly state) is:</p>
<p></p>
<ul>
<li>“the longitudinal axis of the screw should pass through the midpoint of the drilled wood’s thickness”</li>
</ul>
<p></p>
<p>Starting with dimensions you provided together with both assumptions it’s easy to visualize that Y is defined by the position necessary to make the centerline of the bit pass through the midpoint of thickness (using mm for constant and degrees for the angle*):</p>
<p></p>
<ul>
<li>Y= ((1/2W) / Tan(15)) – 35.45 mm</li>
<li>* noting that Excel trig functions require conversion to radians in place of angles</li>
</ul>
<p></p>
<p>then, having defined Y, solve for “≈x” necessary to add to 70 mm such that it leaves “w” length of wood to resist tear out (again using mm for the constant and degrees for the angle)</p>
<p></p>
<ul>
<li> ≈x = ((x + y) / Cos(15)) – w</li>
<li>Collar offset = ≈x + 70 mm</li>
</ul>
<p></p>
<p>Finally these calculated values give the ideal dimensions for setting the stop collar and jig offset which will be rounded (down for ≈x and up for Y to avoid screw protruding through second workpiece) to the nearest measuring tape increment. Then screw choice would be the longest standard screw available that does not exceed 2 times “w”.</p>
<p></p>
<p>I’ve restated equations above since I come up with slightly different values than your original spreadsheet. I wasn’t sure if those differences though were attributable to equation differences or simply due to rounding choices (metric vs. imperial or decimal vs. measuring increments) and hence the request that you confirm the above is what your spreadsheet uses or repost a new version of your very well formatted spreadsheet as may be appropriate. I'll attach my more rudimentary spreadsheet in case it makes that easier to do.</p>
<p></p>
<p><a href="http://storage.ning.com/topology/rest/1.0/file/get/1935486139?profile=original" target="_self">KregMini_Joe.xlsx</a></p>
<p><br/> <br/> <cite>John James said:</cite></p>
<blockquote cite="http://kregjig.ning.com/forum/topics/kreg-jig-mini-measurements?commentId=2900167%3AComment%3A811669#2900167Comment811739"><div><div class="xg_user_generated"><p>Hi Peter again,</p>
<p></p>
<p>Having cracked my spreadsheet passwords, you're quite right; I had mis-typed the two formulae noted on the spreadsheet, though the actual calculation was right*. I've updated the spreadsheet, and uploaded the revised version together with the diagram, with this reply.</p>
<p></p>
<p>* it still gives -11mm - rather than Kreg's own figure of -6mm - for 13mm or ½inch timber.</p>
</div>
</div>
</blockquote> Thanks one again really helpf…tag:kregjig.ning.com,2016-06-16:2900167:Comment:8296082016-06-16T01:59:38.902ZPeter Taylorhttps://kregjig.ning.com/profile/PeterTaylor
<p>Thanks one again really helpful<br></br> <br></br> <cite>Klrock said:</cite></p>
<blockquote cite="http://kregjig.ning.com/forum/topics/kreg-jig-mini-measurements?commentId=2900167%3AComment%3A828922&xg_source=msg_com_forum#2900167Comment829599"><div><div class="xg_user_generated"><p>Here are the values in a table.</p>
<table border="0" cellspacing="0" width="273">
<colgroup><col width="81"></col><col span="3" width="64"></col></colgroup><tbody><tr><td height="19" width="81">Material…</td>
</tr>
</tbody>
</table>
</div>
</div>
</blockquote>
<p>Thanks one again really helpful<br/> <br/> <cite>Klrock said:</cite></p>
<blockquote cite="http://kregjig.ning.com/forum/topics/kreg-jig-mini-measurements?commentId=2900167%3AComment%3A828922&xg_source=msg_com_forum#2900167Comment829599"><div><div class="xg_user_generated"><p>Here are the values in a table.</p>
<table width="273" border="0" cellspacing="0">
<colgroup><col width="81"></col><col width="64" span="3"></col></colgroup><tbody><tr><td width="81" height="19">Material</td>
<td width="64">Kreg Jig</td>
<td width="64">Screw</td>
<td width="64">Collar </td>
</tr>
<tr><td height="19">Thickness</td>
<td>Offset</td>
<td>Length</td>
<td>Setting</td>
</tr>
<tr><td height="19" align="right" class="xl63"> 1/2</td>
<td align="right" class="xl63">- 1/2</td>
<td align="right" class="xl63">1 </td>
<td align="right" class="xl63">3 5/16</td>
</tr>
<tr><td height="19" align="right" class="xl63"> 3/4</td>
<td align="right" class="xl63">0 </td>
<td align="right" class="xl63">1 1/4</td>
<td align="right" class="xl63">3 1/2</td>
</tr>
<tr><td height="19" align="right" class="xl63">1 </td>
<td align="right" class="xl63"> 1/2</td>
<td align="right" class="xl63">1 1/2</td>
<td align="right" class="xl63">3 3/4</td>
</tr>
<tr><td height="19" align="right" class="xl63">1 1/4</td>
<td align="right" class="xl63"> 15/16</td>
<td align="right" class="xl63">2 </td>
<td align="right" class="xl63">4 </td>
</tr>
<tr><td height="19" align="right" class="xl63">1 1/2</td>
<td align="right" class="xl63">1 1/4</td>
<td align="right" class="xl63">2 1/2</td>
<td align="right" class="xl63">4 1/4</td>
</tr>
</tbody>
</table>
</div>
</div>
</blockquote> Here are the values in a tabl…tag:kregjig.ning.com,2016-06-15:2900167:Comment:8295992016-06-15T20:52:38.553ZKlrockhttps://kregjig.ning.com/profile/Klrock
<p>Here are the values in a table.</p>
<table border="0" cellspacing="0" width="273">
<colgroup><col width="81"></col><col span="3" width="64"></col></colgroup><tbody><tr><td height="19" width="81">Material</td>
<td width="64">Kreg Jig</td>
<td width="64">Screw</td>
<td width="64">Collar </td>
</tr>
<tr><td height="19">Thickness</td>
<td>Offset</td>
<td>Length</td>
<td>Setting</td>
</tr>
<tr><td align="right" class="xl63" height="19"> 1/2</td>
<td align="right" class="xl63">- 1/2…</td>
</tr>
</tbody>
</table>
<p>Here are the values in a table.</p>
<table border="0" cellspacing="0" width="273">
<colgroup><col width="81"></col><col width="64" span="3"></col></colgroup><tbody><tr><td height="19" width="81">Material</td>
<td width="64">Kreg Jig</td>
<td width="64">Screw</td>
<td width="64">Collar </td>
</tr>
<tr><td height="19">Thickness</td>
<td>Offset</td>
<td>Length</td>
<td>Setting</td>
</tr>
<tr><td height="19" class="xl63" align="right"> 1/2</td>
<td class="xl63" align="right">- 1/2</td>
<td class="xl63" align="right">1 </td>
<td class="xl63" align="right">3 5/16</td>
</tr>
<tr><td height="19" class="xl63" align="right"> 3/4</td>
<td class="xl63" align="right">0 </td>
<td class="xl63" align="right">1 1/4</td>
<td class="xl63" align="right">3 1/2</td>
</tr>
<tr><td height="19" class="xl63" align="right">1 </td>
<td class="xl63" align="right"> 1/2</td>
<td class="xl63" align="right">1 1/2</td>
<td class="xl63" align="right">3 3/4</td>
</tr>
<tr><td height="19" class="xl63" align="right">1 1/4</td>
<td class="xl63" align="right"> 15/16</td>
<td class="xl63" align="right">2 </td>
<td class="xl63" align="right">4 </td>
</tr>
<tr><td height="19" class="xl63" align="right">1 1/2</td>
<td class="xl63" align="right">1 1/4</td>
<td class="xl63" align="right">2 1/2</td>
<td class="xl63" align="right">4 1/4</td>
</tr>
</tbody>
</table> Thanks, This is really useful…tag:kregjig.ning.com,2016-06-15:2900167:Comment:8291092016-06-15T08:41:52.739ZPeter Taylorhttps://kregjig.ning.com/profile/PeterTaylor
<p>Thanks, This is really useful.</p>
<p>Would it be possible to post the values in a Table.</p>
<p>Her in Australia we have metric building materials and I'll make one up for the standard thicknesses we use.</p>
<p>Peter</p>
<p></p>
<p>Thanks, This is really useful.</p>
<p>Would it be possible to post the values in a Table.</p>
<p>Her in Australia we have metric building materials and I'll make one up for the standard thicknesses we use.</p>
<p>Peter</p>
<p></p> I have used the data provided…tag:kregjig.ning.com,2016-06-14:2900167:Comment:8289222016-06-14T00:54:16.835ZKlrockhttps://kregjig.ning.com/profile/Klrock
<p>I have used the data provided by various contributors in this forum and other sources to make a graphical representation of the setting for the Kreg Jig as a function of material thickness. When the offset is negative, it means that the jig overhangs the material by that amount. …</p>
<p></p>
<p></p>
<p><a href="http://storage.ning.com/topology/rest/1.0/file/get/1935480568?profile=original" target="_self"><img class="align-full" src="http://storage.ning.com/topology/rest/1.0/file/get/1935480568?profile=RESIZE_1024x1024" width="721"></img></a></p>
<p>I have used the data provided by various contributors in this forum and other sources to make a graphical representation of the setting for the Kreg Jig as a function of material thickness. When the offset is negative, it means that the jig overhangs the material by that amount. </p>
<p></p>
<p></p>
<p><a href="http://storage.ning.com/topology/rest/1.0/file/get/1935480568?profile=original" target="_self"><img width="721" src="http://storage.ning.com/topology/rest/1.0/file/get/1935480568?profile=RESIZE_1024x1024" width="721" class="align-full"/></a></p> Hello David,
It is working.…tag:kregjig.ning.com,2016-03-22:2900167:Comment:8137762016-03-22T16:02:14.336ZJohn Jameshttps://kregjig.ning.com/profile/JohnJames
<p>Hello David,</p>
<p></p>
<p>It is working. I've just run it, from this forum, in Excel 2007 on a different machine, under Win10 (this machine is still Good 'Ole XP and Office 2003) and it worked just fine. What problem are you having? You'll get a Security Warning (just above the grid) because the spinner is an ActiveX control and is regarded by more recent versions of Excel as potentially dangerous by default. Same would apply if it contained macros (but it doesn't).</p>
<p></p>
<p>When…</p>
<p>Hello David,</p>
<p></p>
<p>It is working. I've just run it, from this forum, in Excel 2007 on a different machine, under Win10 (this machine is still Good 'Ole XP and Office 2003) and it worked just fine. What problem are you having? You'll get a Security Warning (just above the grid) because the spinner is an ActiveX control and is regarded by more recent versions of Excel as potentially dangerous by default. Same would apply if it contained macros (but it doesn't).</p>
<p></p>
<p>When you get the warning, just click on the 'Options' button next to the message, and allow the content to run.</p>
<p></p>
<p>Alternatively, download it to a <a rel="nofollow" href="https://technet.microsoft.com/en-us/library/cc179039.aspx" target="_blank">Trusted Space</a> to run it from, then it won't bother with the warning.</p>
<p></p>
<p>HTH</p>
<p></p>
<p>John</p> Can you email me ( KB2HPR@TDS…tag:kregjig.ning.com,2016-03-22:2900167:Comment:8135112016-03-22T15:20:24.316ZDavid Jacksonhttps://kregjig.ning.com/profile/DavidJackson237
<p>Can you email me ( KB2HPR@TDS.NET ) a working, unlocked copy of the XLS file. I don't seem to be able to get them working, the old OR new version 33kb.</p>
<p>I have tried Excel 2007 and 2013.</p>
<p></p>
<p>Can you email me ( KB2HPR@TDS.NET ) a working, unlocked copy of the XLS file. I don't seem to be able to get them working, the old OR new version 33kb.</p>
<p>I have tried Excel 2007 and 2013.</p>
<p></p> Great thanks John - makes muc…tag:kregjig.ning.com,2016-03-17:2900167:Comment:8116602016-03-17T02:50:43.908ZPeter Taylorhttps://kregjig.ning.com/profile/PeterTaylor
<p>Great thanks John - makes much more sense now.</p>
<p>It would be a lot better if Kreg simply said Collar Settings is just timber width plus 70 mm.</p>
<p>Then, in the absence of a table for other wood dimensions - users could then set Jig Offset by trial and near the standard settings.</p>
<p>This way there is only one variable. I cant understand why they don't make it that simple</p>
<p><br></br> <br></br> <cite>John James said:…</cite></p>
<p>Great thanks John - makes much more sense now.</p>
<p>It would be a lot better if Kreg simply said Collar Settings is just timber width plus 70 mm.</p>
<p>Then, in the absence of a table for other wood dimensions - users could then set Jig Offset by trial and near the standard settings.</p>
<p>This way there is only one variable. I cant understand why they don't make it that simple</p>
<p><br/> <br/> <cite>John James said:</cite></p>
<blockquote cite="http://kregjig.ning.com/forum/topics/kreg-jig-mini-measurements?id=2900167%3ATopic%3A396103&page=2#2900167Comment811739"><div><div class="xg_user_generated"><p>Hi Peter again,</p>
<p></p>
<p>Having cracked my spreadsheet passwords, you're quite right; I had mis-typed the two formulae noted on the spreadsheet, though the actual calculation was right*. I've updated the spreadsheet, and uploaded the revised version together with the diagram, with this reply.</p>
<p></p>
<p>* it still gives -11mm - rather than Kreg's own figure of -6mm - for 13mm or ½inch timber.</p>
</div>
</div>
</blockquote> Nice Job John,
I found your s…tag:kregjig.ning.com,2016-03-16:2900167:Comment:8117442016-03-16T21:50:00.301ZTroyhttps://kregjig.ning.com/profile/Troy681
<p>Nice Job John,</p>
<p>I found your spreadsheet very useful. Thanks for all your effort on it!</p>
<p></p>
<p>--</p>
<p>Cheers</p>
<p>Nice Job John,</p>
<p>I found your spreadsheet very useful. Thanks for all your effort on it!</p>
<p></p>
<p>--</p>
<p>Cheers</p>