How to deal with NaN in 'from spreadsheet' block in Simulink? How do I make Simulink ignore NaNs?

Question

Pratyush Das 2019-8-25

回答： Sulaymon Eshkabilov 2019-8-28

I have a spreadsheet which has certain 'NaN' values under different variables. This spreadsheet is exported from MATLAB.

I am using the spreadsheet to export values of Irradiance and temperature to a Simulink PV model. The model screenshot is attached:

I am using 'from spreadsheet block' from the Simulink library.

The spreadsheet data looks like this

While running the model I am getting the following errors:

How do I make SIMULINK ignore the NaN values and run the simulation?

Answer 1

Sulaymon Eshkabilov 2019-8-28

Hi,

I would suggest to try two different ways:

Substitute all NaNs with "0"s or something else with relational operator before using/feeding the data to the Simulink model.
A bit more complicated way is to use logic and bit operators to sort out all NaNs.

Good luck