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

Cool Tools Type Mismatch Error

asked 5 years ago

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.

Thanks.

image description image description

Preview: (hide)

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  ( 5 years ago )

1 Answer

Sort by » oldest newest most voted
0

answered 5 years ago

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.

Preview: (hide)
link

Your Answer

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

Add Answer

Training Workshops

Careers

Question Tools

1 follower

Stats

Asked: 5 years ago

Seen: 449 times

Last updated: Jul 11 '19