[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [TRNSYS-users] HELP: How to do an "IF" (logical test) not usingtype62 (call Excel)



Rui,

You can do this using an equation, but you have to be creative.  Please consider the following.  This is an equation I made that sets the flow rate of a collector.  If the solar radiation is greater than 0.01, it sets the flow rate to 75.  If the solar radiation is less than 0.01, the flow rate is 5. "solar" is the input of the equation. In my case, I used total horizontal radiation.

flow_rate=GT(solar,0.01)*75+LT(solar,0.01)*5

Using the Excel syntax: IF(SOLAR>0.01,75,5)

I hope this helps. Good luck!

Best,


Matt Duffy
----- Original Message -----
From: "Rui Jorge Marques Santos"
Sent: Tue, August 26, 2008 10:11
Subject: [TRNSYS-users] HELP: How to do an "IF" (logical test) not usingtype62 (call Excel)

Hi again,

I've posted yesterday one request for help because of the problem that I'm having with the Type 62, as stated in the email below. But since I've no solutions for that till now, my doubt is now different.

Is there anyway to do an "IF(logical_test, [value_if_true] , [value_if_false])" besides trough the Type 62? Because if there is, I can bypass the problem with the type 62 by replacing it by something else...

Many thanks

Rui Santos


Yesterday post:
"Hi

I'm currently using the TRNSYS 16 and when I run one of the examples
from the TRNSYS to call the Excel ("Excel Schedule" or "Excel Sun
Position" in the folder C:\Program Files\Trnsys16\Examples) I get an
anoying error stating: "Access violation at address 10300096 in module
'TRNDLL.DLL'. Read of address 00000000." and after pressing the "OK"!
button on that box another one shows up stating "An unexpected error
was encountered and TRNSYS will abort".

How do I solve this? Do I need to install a compiler or something
else, besides TRNSYS? In my previous laptop (a Compaq) this type (62)
work fine with no problems, unfortunately I have no longer that laptop
and I'm currently working on a DELL. In this computer I was never able
to call the Excel for TRNSYS!! I'm using Excel 2003.

Please help me with this because I'm finishing my master thesis about
solar assisted air conditioning, and all my work was done in the
previous computer in which the type62 worked. Now I need to put the
program running again and I'm not being capable to do so because of
that error with the Type62.

Thank you very much in advance!

Rui Santos"


________________________________________________________________________________
SEGURO AUTOMÓVEL Sempre Seguros
Faça uma simulação e veja QUANTO PODE POUPAR!

_______________________________________________
TRNSYS-users mailing list
TRNSYS-users@cae.wisc.edu
https://www-old.cae.wisc.edu/mailman/listinfo/trnsys-users