[esp-r] Re: export data to excel

[Jon Hand]

Exporting data to 3rd party applications...
________________________________________
I am trying to analyse an adaptive comfort model result. I need to export the two variables ambient temperature and resultant temperature to excel and see how many points lie beyong the adaptive comfort range. Is it possible to export variable value sto excel?

________________________________________

There are several answers to this

a) there may already be sufficient comfort reports within the results analysis
    module  - you can graph and list and do statistics on comfort in terms of
    PMV and PPD and if you have detailed 'block' sensors in the room you can
    also do position-specific comfort.

b) exporting data to a file for use in 3rd party applications is possible. What you
    have to do in the results analysis module is to use the timestep reports menu
    and toggle the reporting to an external file and set the separator to you
    preference (comma  tab  single-space).  You will also want to change the
    reporting of time to use a fraction of a day. Select what you want to see and
    then 'list' the data and it will be sent to that file.  A few minutes exploring this
    facility should indicate whether it is suitable for your purposes.

c) any of the reports in the ESP-r results analysis module can be set to a
    file rather than to the text feedback area of res.  Some users automate the
    process by creating scripts to drive the results analysis module.  Examples
    of this can be found in the source code validation/benchmark/QA/model/cfg
    folder.

d) The folk at Natural Resources Canada have also created a facility to write out
    some performance predictions as an XML file.  The tester folder of the source
    distribution makes frequent use of this.

-Jon Hand