- Index
- » Usage and Applications
- » OpenModelica Usage and Applications
- » Values into Excel
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
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
- ceraolo
- 147 Posts
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
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
- sjoelund.se
- 1700 Posts
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/
- ceraolo
- 147 Posts
- Index
- » Usage and Applications
- » OpenModelica Usage and Applications
- » Values into Excel