Cool Tools Type Mismatch Error

1 post / 0 new

This is also posted on unmet hours, 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
12 Cadillac Dr., Ste 150
Brentwood, TN 37027
Main: 615.297.4554
Office: 615.346.1939
Cell: 931.273.8396
USGBC MidTN Branch Leadership Group Co-chair

[cid:TLCtriangle_48_9b0b2127-1fd8-4dd1-8210-7b9e72ba4dda.png] [cid:LinkedIn_d77bd78f-26ef-4f20-a83e-d6bea9af9afa.png] [cid:Facebook_8e703d49-6367-43ed-b9af-b0d3399f9ce5.png] [cid:Twitter_009986bf-8b3b-4a60-972d-6224dff1b1bb.png]

crduggin's picture
Joined: 2013-04-16
Reputation: 0