Re: [TRNSYS-users] How to change the way of showing results in TRNSYS

To: Numan Kaya <numankaya001@hotmail.com>

Subject: Re: [TRNSYS-users] How to change the way of showing results in TRNSYS

From: leen peeters <l.f.r.peeters@gmail.com>

Date: Tue, 17 Apr 2012 11:05:58 +0200

Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=o2etT5kPvJZB2iGy9mceioTfo8yJioNZA5X7JgclD0Y=; b=V+RiWU9ztw+3cEyFKFHJeyoweSztN7MHnLFP2465JRCfKFo/1pwIH/rJV4vuks7Pd3 miZJ+/CpLH9mq+vfnKR/G5HDRfnUb9irMvMUsuHrmFqlRq0b9SA4EIyJvWZ1HNZY4uC0 I4jJ+q9jK+MB9X8IkRr21ZLN8YGmN1HLmckPUcPJT8fkmzCxyVEJ38fYDnHcn3VbvJ8+ Z6Wia8Go1Da/4dU4TjXWMrmTYGu8mMWmZb583OiVeBpEpjsjUI2SQ3Ckniwbx0pVGAlk iwKSIrzmCH/Ge5pHb/9isL0LeMA9pjLaTenuameSARfKyRbBO7eDJaq5dXmt+XzEkuhl lyuw==

In-reply-to: <SNT111-W21CFF69562EAFD4B104E3F953F0@phx.gbl>

List-archive: <http://mailman.cae.wisc.edu/pipermail/trnsys-users>

List-help: <mailto:trnsys-users-request@cae.wisc.edu?subject=help>

List-id: "TRNSYS users mailing list at the Solar Energy Lab, UW-Madison" <trnsys-users.cae.wisc.edu>

List-post: <mailto:trnsys-users@cae.wisc.edu>

List-subscribe: <https://mailman.cae.wisc.edu/listinfo/trnsys-users>, <mailto:trnsys-users-request@cae.wisc.edu?subject=subscribe>

List-unsubscribe: <https://mailman.cae.wisc.edu/options/trnsys-users>, <mailto:trnsys-users-request@cae.wisc.edu?subject=unsubscribe>

References: <SNT111-W21CFF69562EAFD4B104E3F953F0@phx.gbl>

Numan,

in excel do a CTRL A (select all) and use a right mouse click to go to 'format cell' and opt for number.

That should solve it

Also, check the settings of your printer (I assume you have one in your model, if not: go to 'output' select 'printer' and pick one out), . in the parameter tab of your printer, you can select the delimiter and stuff ...

leen

On Tue, Apr 17, 2012 at 10:41 AM, Numan Kaya <numankaya001@hotmail.com> wrote:

Hello,

I have simulated a wind energy production prediction system in TRNSYS. I can see hourly energy production amounts in graphic. I need numerical total lannual energy production amount, mean energy production values. If i open outfile text file after simulation (calculate-open-external files,xxx.dat), the results are there shown as XXXX +E0x (exmp. 2.21064E+05,1.23064E+04) so i can't coppy them to excel too. How can i make it to show results as normal numbers (examp. 22222.235, 56456465465,89 ) without +-EX . And is there any other way to transfer results to excel?.

Regards.

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