<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">This is also posted on <a href="https://unmethours.com/question/39460/cool-tools-type-mismatch-error/">
unmet hours</a>, but I know there are a lot of folks who follow this list that aren’t on unmet hours. Thanks in advance for the help.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.5pt;margin-left:0in;background:white">
<span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#4B4B4B">I am trying to create a set of bi-quadratic curves for a series counter flow chiller branch using the Cool Tools spreadsheet. I have entered all the data, but I am getting a Run Time
Error '13': Type Mismatch when I click create regression models.<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.5pt;margin-left:0in;background:white;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;text-align:start;widows: 2;-webkit-text-stroke-width: 0px;text-decoration-style: initial;text-decoration-color: initial;word-spacing:0px">
<span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#4B4B4B">I did have to modify the entering temp CWST to match the performance data. I didn't think that would affect the curve fit though. Does anyone know how to resolve this error? I'm not
familiar enough with the underlying VBA to troubleshoot it very far. I would be glad to send the spreadsheet for anyone willing to take a look.<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.5pt;margin-left:0in;background:white">
<span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#4B4B4B"><o:p> </o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.5pt;margin-left:0in;background:white">
<img border="0" width="368" height="202" id="Picture_x0020_1" src="cid:image001.png@01D535AF.082F3C80"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#4B4B4B"><o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:10.5pt;margin-left:0in;background:white">
<img border="0" width="687" height="589" id="Picture_x0020_2" src="cid:image002.png@01D535AF.082F3C80"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#4B4B4B"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<FONT style="FONT-SIZE: 12.5pt"
face=Calibri><STRONG>Cory Duggin,
PE, LEED AP BD+C, BEMP</STRONG></FONT> <BR><FONT
style="FONT-SIZE: 10pt" color=#808080
face=Calibri><EM>Principal</EM> |
<EM>PEAK Institute</EM></FONT> <BR><FONT style="FONT-SIZE: 10pt"
face=Calibri><A title=mailto:cory.duggin@tlc-eng.com style="COLOR: #808080"
href="mailto:cory.duggin@tlc-eng.com">cory.duggin@tlc-eng.com</A></FONT> <BR>
<FONT style="FONT-SIZE: 16pt" color=#00aeef
face=Calibri><STRONG>TLC</STRONG></FONT> <FONT style="FONT-SIZE: 12.5pt"
color=#00aeef face=Calibri><STRONG>ENGINEERING</STRONG></FONT> <FONT
style="FONT-SIZE: 12.5pt" color=#808080
face=Calibri><STRONG>SOLUTIONS</STRONG></FONT> <BR><FONT style="FONT-SIZE: 10pt"
face=Calibri>12 Cadillac Dr., Ste 150</FONT> <BR><FONT style="FONT-SIZE: 10pt"
size=1 face=Calibri>Brentwood, TN 37027</FONT> <BR><FONT
style="FONT-SIZE: 10pt" size=1 face=Calibri><STRONG>Main: </STRONG>615.297.4554
<BR></FONT><FONT style="FONT-SIZE: 10pt" size=1
face=Calibri><STRONG>Office: </STRONG>615.346.1939
<BR></FONT><FONT style="FONT-SIZE: 10pt" size=1
face=Calibri><STRONG>Cell: </STRONG>931.273.8396
<BR></FONT><FONT style="FONT-SIZE: 8pt"
face=Calibri></FONT> <BR><A
href="https://www.tlc-engineers.com"><U><STRONG><FONT style="FONT-SIZE: 12pt"
color=#00aeef face=Calibri>www.tlc-engineers.com</FONT></STRONG></U></A>
<BR><FONT style="FONT-SIZE: 10pt" size=1 face=Calibri>USGBC MidTN Branch Leadership Group Co-chair
<BR></FONT><FONT style="FONT-SIZE: 10pt" size=1
face=Calibri></FONT><FONT
style="FONT-SIZE: 10pt" size=1 face=Calibri></FONT> <BR><FONT style="FONT-SIZE: 11pt" color=#0000ff><A
class=socialLink href="https://www.tlc-engineers.com"><IMG class=socialLink
border=0
src="cid:TLCtriangle_48_9b0b2127-1fd8-4dd1-8210-7b9e72ba4dda.png"></A></FONT> <FONT
style="FONT-SIZE: 11pt" color=#0000ff> <A class=socialLink
href="https://www.linkedin.com/company/tlcengineeringsolutions "><IMG
class=socialLink border=0
src="cid:LinkedIn_d77bd78f-26ef-4f20-a83e-d6bea9af9afa.png"></A></FONT> <FONT
style="FONT-SIZE: 11pt" color=#0000ff> <A class=socialLink
href="https://www.facebook.com/TLCengineeringsolutions"><IMG class=socialLink
border=0 src="cid:Facebook_8e703d49-6367-43ed-b9af-b0d3399f9ce5.png"></A></FONT>
<FONT style="FONT-SIZE: 11pt" color=#0000ff> <A class=socialLink
href="https://twitter.com/TLC_Engineering"><IMG class=socialLink border=0
src="cid:Twitter_009986bf-8b3b-4a60-972d-6224dff1b1bb.png"></A></FONT>
</body>
</html>