From spreadsheet in simulink ....How to deal with inf problem
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Ill ch
el 25 de Sept. de 2019
Comentada: Ill ch
el 28 de Sept. de 2019
Dear Simulink user,
i am using from spreadsheet block to uplad on simulink my signal. However i found there limitaions of spreadsheet block is it? anybody know solution to deal with from spreadsheet block?
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/239781/image.png)
0 comentarios
Respuesta aceptada
Ankit
el 26 de Sept. de 2019
Editada: Ankit
el 26 de Sept. de 2019
hello,
there is problem in your spreadsheet.
I would like to confirm that if your time values are correct.
You just need to replace the "." with ",". (Its german formatted excelsheet)
I just did the above changes and there is no error, model is able to simulate (just use the attached sheet) but my concern is with your time values which are to the power of 7.
Thanks
Ankit
8 comentarios
Ankit
el 27 de Sept. de 2019
Editada: Ankit
el 27 de Sept. de 2019
Is there any reason you are using Variable-step solver?
One way you can avoid this is by setting the Sample time in Spreadsheet block to small value (for e.g. 1e-8) as your time values are very small.
The Sample time parameter specifies the sample time that the From Spreadsheet block uses to read data from the spreadsheet.
-1 value inherits the value the from the block into which the From Spreadsheet block feeds data.
Just for your understanding try changing the sample time from 1e-5, 1e-7 and 1e-8 and see the corresponding plots.
I think most of your settings are auto. I would recommend you go through this page:
Choose a Solver: https://de.mathworks.com/help/simulink/ug/choose-a-solver.html
All the best!
Más respuestas (0)
Ver también
Categorías
Más información sobre Sources en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!