[TRNSYS-users] Can TRNSYS simulation results imported in spreadsheet program?

Graham Linn grahamjlinn at gmail.com
Mon Nov 7 08:29:07 PST 2011


Hi D. Marini,

I like to use the 'Get External Data' feature in Excel to easily load
data from a TRNSYS text file. I have Office 2007. If you go to the
Data tab, click on the 'From Text' button within the 'Get External
Data' group. Once you've set up the link, you can quickly hit 'Refresh
All' to update your data with the most recent results of your
simulation.

Regards,
Graham



On Mon, Nov 7, 2011 at 10:22 AM, David BRADLEY <d.bradley at tess-inc.com> wrote:
> Dear D. Marini,
>   If you open Excel and choose the File: Open command, then select your
> TRNSYS simulation output file, Excel will ask you a few questions about how
> the output file is delimited (spaces, tabs, etc.) and then open it. Also,
> all of TRNSYS's output files are text based but if you use the extension
> *.xls for one of your output files, you can trick Excel into thinking that
> it is able to open the file directly.
> Kind regards,
>  David
>
>
> On 11/7/2011 06:07, Dashamir Marini wrote:
>
> Hi all,
> I'm a new user of TRNSYS and would like to ask your help during software
> learning.
> I wold like to ask, if is possible to import simulation result of program at
> a spreadsheet program?
> If yeas, how it can be done ?
> thanks in advance
> D. Marini
>
> _______________________________________________
> TRNSYS-users mailing list
> TRNSYS-users at cae.wisc.edu
> https://mailman.cae.wisc.edu/listinfo/trnsys-users
>
> --
> ***************************
> David BRADLEY
> Principal
> Thermal Energy Systems Specialists, LLC
> 22 North Carroll Street - suite 370
> Madison, WI  53703 USA
>
> P:+1.608.274.2577
> F:+1.608.278.1475
> d.bradley at tess-inc.com
>
> http://www.tess-inc.com
> http://www.trnsys.com
>
> _______________________________________________
> TRNSYS-users mailing list
> TRNSYS-users at cae.wisc.edu
> https://mailman.cae.wisc.edu/listinfo/trnsys-users
>
>



More information about the TRNSYS-users mailing list