Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question

Cool Tools Type Mismatch Error

asked 2019-07-08 16:28:51 -0500

crduggin's avatar

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.


image description image description

edit retag flag offensive close merge delete


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

1 Answer

Sort by ยป oldest newest most voted

answered 2019-07-11 13:54:38 -0500

crduggin's avatar

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.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Training Workshops

Question Tools

1 follower


Asked: 2019-07-08 16:28:51 -0500

Seen: 350 times

Last updated: Jul 11 '19