From spreadsheet in simulink ....How to deal with inf problem

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?

Answer 1

[Ankit]

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

[Ill ch]

Thank you very much. Yes it was the power of -7.

But perfect answer

[Ill ch]

Dear Ankit,

your suggested correction works but i do not understand why its not plotting in signal form. I gave my 500 points signal but result is zickzak single rather than smoorth curve. DO you have idea?

coud you please tell me what is the timing scale for simulink run for it? how to decide that

Thank you

[Ankit]

hi,

could you please attached the result what you are getting as image file?

mysim.slx is built 2019a version but unfortunately I am using 2018b.

I would like to know your Solver Configuration (may be screen shot); Solver, Solver Type, Time Step

Thanks

Ankit

[Ill ch]

Hello Ankit,

here is at attached photos. I took running time max(timevector)

Thankx for your kind support

[Ankit]

Now I understood why your are facing this problem. Please answer the following question

a) Type (Fixed or Variable)

b) Time-step

c) Solver

or I would like you to upload the snapshot of configuration window (see below)

another possibility to attach mysim.slx (2018b). You can go to File --> Export Model to --> Previous Version --> 2018b.

[Ill ch]

Thank you for your fast reply. 2018b conversion not possible in my laptop i tried but i am sending u screenshot

[Ankit]

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!

[Ill ch]

no there are not any reason. I will try it . Thank you very much

if i will have any question will late you know