[Bldg-sim] Cool Tools Type Mismatch Error

Duggin, Cory Cory.Duggin at tlc-eng.com
Mon Jul 8 15:03:17 PDT 2019


This is also posted on unmet hours<https://unmethours.com/question/39460/cool-tools-type-mismatch-error/>, 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.


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.

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.



[cid:image001.png at 01D535AF.082F3C80]

[cid:image002.png at 01D535AF.082F3C80]

Cory Duggin, PE, LEED AP BD+C, BEMP
Principal | PEAK Institute
cory.duggin at tlc-eng.com<mailto:cory.duggin at tlc-eng.com>
TLC ENGINEERING SOLUTIONS
12 Cadillac Dr., Ste 150
Brentwood, TN 37027
Main: 615.297.4554
Office: 615.346.1939
Cell: 931.273.8396

www.tlc-engineers.com<https://www.tlc-engineers.com>
USGBC MidTN Branch Leadership Group Co-chair

[cid:TLCtriangle_48_9b0b2127-1fd8-4dd1-8210-7b9e72ba4dda.png]<https://www.tlc-engineers.com>  [cid:LinkedIn_d77bd78f-26ef-4f20-a83e-d6bea9af9afa.png] <https://www.linkedin.com/company/tlcengineeringsolutions>   [cid:Facebook_8e703d49-6367-43ed-b9af-b0d3399f9ce5.png] <https://www.facebook.com/TLCengineeringsolutions>   [cid:Twitter_009986bf-8b3b-4a60-972d-6224dff1b1bb.png] <https://twitter.com/TLC_Engineering>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190708/ef997f70/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 22453 bytes
Desc: image001.png
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190708/ef997f70/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 323136 bytes
Desc: image002.png
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190708/ef997f70/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: TLCtriangle_48_9b0b2127-1fd8-4dd1-8210-7b9e72ba4dda.png
Type: image/png
Size: 1754 bytes
Desc: TLCtriangle_48_9b0b2127-1fd8-4dd1-8210-7b9e72ba4dda.png
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190708/ef997f70/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: LinkedIn_d77bd78f-26ef-4f20-a83e-d6bea9af9afa.png
Type: image/png
Size: 455 bytes
Desc: LinkedIn_d77bd78f-26ef-4f20-a83e-d6bea9af9afa.png
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190708/ef997f70/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Facebook_8e703d49-6367-43ed-b9af-b0d3399f9ce5.png
Type: image/png
Size: 352 bytes
Desc: Facebook_8e703d49-6367-43ed-b9af-b0d3399f9ce5.png
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190708/ef997f70/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Twitter_009986bf-8b3b-4a60-972d-6224dff1b1bb.png
Type: image/png
Size: 606 bytes
Desc: Twitter_009986bf-8b3b-4a60-972d-6224dff1b1bb.png
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190708/ef997f70/attachment-0005.png>


More information about the Bldg-sim mailing list