Sorry, this content is no longer available
3

Cool Tools Type Mismatch Error

I am trying to create a set of bi-quadratic curves for a series counter flow 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, but there isn't a way to attach it to this post.

Thanks.

image description image description

crduggin's avatar
800
crduggin
asked 2019-07-08 16:28:51 -0500
edit flag offensive 0 remove flag close merge delete

Comments

You might want to use the VBA debugger and see the values of the variables at that point and at previous points that set CAPFTcoeff(4,1).

JasonGlazer's avatar JasonGlazer (2019-07-09 07:20:44 -0500) edit
add a comment see more comments

1 Answer

0

Solved the problem. The LINEST function was returning a non-value causing the error. This was because the manufacturer data I was provided did not account for the actual changes in operational capacity as CWT and flow changed, so an error was generated while trying to create the CAPft curve. Thanks to @DancingDavidE for the help troubleshooting the VBA.

crduggin's avatar
800
crduggin
answered 2019-07-11 13:54:38 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments