Archived OpenModelica forums. Posting is disabled.

Alternative forums include GitHub discussions or StackOverflow (make sure to read the Stack Overflow rules; you need to have well-formed questions)


Forgot password? | Forgot username? | Register

Values into Excel

Values into Excel

Hi guys,

i have to do a heat simulation of a room. For comparison of different parameters and a nice visualisation, i want my x and y coordinates from the simulated graph translate in excel. I read something about the csv format but i cant find the generated file.

I hope you can understand my english and help me current/smile

Thanks, Raymond


Using: OpenModelica Connection Editor connected to OpenModelica 1.9.2

Re: Values into Excel

If you use omedit, you will find the csv file in the working directory.The working directory is indicated in Options|General|Working directory

Re: Values into Excel

Thank you! I found it.

Now the problem is, that the file has a size of over 300 MB. i cant handle this in excel. It is because i have to simulate 14 days (1.209.600 seconds) is there an option to reduce this big amount of values. i think the value of every 5 minutes will be enough for my results.

Another question: Is it possible to reduce the output on specific variables? I only need two temperatures.

Kind regards, raymond


https://openmodelica.org/images/agorapro/attachments/4525/mini_example-airload1-T-and-star1-T.PNG

Edited by: Raymond_om - Jul-07-15 13:45:30

Re: Values into Excel

https://openmodelica.org/doc/OpenModeli … ionresults can reduce the number of output points, but it does not reduce the number of output points for CSV files. You can use the variableFilter option to regex only the two desired variables, or filter the file afterwards.

You can also try some of the dassl options to only output every nth step or simply select a lower number of intervals to simulate: https://openmodelica.org/doc/OpenModeli … nttimegrid

Re: Values into Excel

Ok, thank you.

What is the exact term i have to put in the variablefilter. i dont get it.

https://openmodelica.org/images/agorapro/attachments/4525/mini_Unbenannt2.JPG


Attachments:

Re: Values into Excel

Just in case you like, you can also use a program of mine that should be able to read your large CSV file.

It allows more than OMEdit allows for visualization, and allows also to perform some post processing (summing or subtracting variables, integrating variables, finding Fourier polynomial coefficients, etc.) Included there is a pdf that explains everything you can do and how.

Loading large CSV files is slow (377MB file created by OM I measured 50 s). Once the file is loaded, plotting is nearly instantaneous.

This program is named PlotXY and you can get it from the following URL.

http://www.dsea.unipi.it/Members/ceraol … re/plotxy/



There are 0 guests and 0 other users also viewing this topic