Re: [TRNSYS-users] TRNSYS-users Digest, Vol 182, Issue 24

[Amin HADDAD <itshaddad1@gmail.com>]

Thank you Mario.

Amin 

On Fri, 14 Feb 2020, 17:27 Mario González, <marioglezx@gmail.com> wrote:

Dear Amin HADDAD,

You can follow this video to build your own excel file with the macro to automate your simulation. It was very helpful for me:

https://www.youtube.com/watch?v=wao0ll-0L1U

Hope it helps you.

Best regards,

El jue., 13 feb. 2020 a las 22:26, <trnsys-users-request@lists.onebuilding.org> escribió:

---------- Forwarded message ----------
From: Amin HADDAD <itshaddad1@gmail.com>
To: TRNSYS-users@lists.onebuilding.org
Cc: 
Bcc: 
Date: Fri, 14 Feb 2020 01:53:14 +0100
Subject: [TRNSYS-users] Automated parametric analysis using an Excel VBA code

Hello,

I need to run an automated parametric analysis.

I am using type56a (Multi-zone building) and type34 (Overhang and wing wall shading). Type34 is linked to type56 to define windows and overhang dimensions. 

The thing is that it is time-consuming to run over 80 simulations to determine the best windows and overhangs dimensions manually, where each time I have to change the parameters in type34 and open TRNBuild to change windows dimensions so it corresponds to what is in type34.

Can you guys help me out automate this using Excel VBA code? I will be grateful.

Kind regards

Amin HADDAD

--

M.C. Mario González