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

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

From: Mario González <marioglezx@gmail.com>

Date: Fri, 14 Feb 2020 10:27:19 -0600

Delivered-to: trnsys-users-onebuilding.org@pdx1-mailman02.dreamhost.com

Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=FVxMn9VsrNScpyxqcqF7cQymOJHxDB3jiecxe221BZw=; b=KzPNp6N/PMKFXf4hPznczwRIgSI6C5E7VKxABkqGtpZkUIEtWXvN4PtlWZXggNRUw/ 6E++hjTFUeSa9sFK4aR9QGH00/Uyro453us4NBP9rSWAFOXpqDPbHgYhoKrq+MomCn2N r+QDsbgvKkz8mCXUARSSjgjoWgRKlKy1K/F2QaJFSsRYq7xcPxooM/4RKBGmPJpDoaxY Gka4omlxooE7cwd11kDPTiecXw8Bj4SNt03zE1HXdUl/EA4RVdneTmGr5hnBSn2ufkK2 1rBg6miGcH9Msa2ZiQ2iGDNUL996nTbl3m6amnb7Cg2wzfopCXrG5jeJFXGUSsqSxtOF P/ug==

In-reply-to: <mailman.55107.1581652115.5111.trnsys-users-onebuilding.org@lists.onebuilding.org>

List-archive: <http://lists.onebuilding.org/pipermail/trnsys-users-onebuilding.org/>

List-help: <mailto:trnsys-users-request@lists.onebuilding.org?subject=help>

List-id: "TRNSYS users mailing list at OneBuilding.org" <trnsys-users-onebuilding.org>

List-post: <mailto:trnsys-users@lists.onebuilding.org>

List-subscribe: <http://lists.onebuilding.org/listinfo.cgi/trnsys-users-onebuilding.org>, <mailto:trnsys-users-request@lists.onebuilding.org?subject=subscribe>

List-unsubscribe: <http://lists.onebuilding.org/options.cgi/trnsys-users-onebuilding.org>, <mailto:trnsys-users-request@lists.onebuilding.org?subject=unsubscribe>

References: <mailman.55107.1581652115.5111.trnsys-users-onebuilding.org@lists.onebuilding.org>

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