how to input table data in look up table from simulink instantaneously

I have a simulink model and i need to input look up table from the simout file in waorkspace during the cource of simulation .Hence how can i input "table data" in look up table from simulink instantaneously.As given in the below MAtlab documentation

https://www.mathworks.com/help/simulink/ug/how-to-import-data-from-an-excel-spreadsheet.html

This example shows how to use the MATLAB xlsread function in a Simulink model to import data into a lookup table.

1. Save the Excel® file in a folder on the MATLAB® path.
2. Open the model containing the lookup table block and in the Modeling tab, select Model Settings.
3. In the Model Properties dialog box, in the Callbacks tab, click PostLoadFcn callback in the model callbacks list.
4. Enter the code to import the Excel Spreadsheet data in the text box. Use the MATLAB xlsread function, as shown in this example for a 2-D lookup table.% Import the data from Excel for a lookup table

data = xlsread('MySpreadsheet','Sheet1');
% Row indices for lookup table
breakpoints1 = data(2:end,1)';
% Column indices for lookup table
breakpoints2 = data(1,2:end);
% Output values for lookup table
table_data = data(2:end,2:end);

1. Click OK.

After you save your changes, the next time you open the model, Simulink® invokes the callback and imports the data.

HEre i have used simout and it produces a 1 x 1 double timeseries data according to the simulation time.How can i use this data as an input to the look up table as mentioned in the below documentation ?

please help

Answer 1

[Sulaymon Eshkabilov]

It looks like that you have 1D look up table data imported from MS Excel. Thus, you'd need to use 1D lookup table and just connect the output ports of MS Excel block with the input port of 1D lookup table. See this help doc: https://www.mathworks.com/help/simulink/slref/1dlookuptable.html

It is quite straightforward, once you set up [From MS Excel] data block settings.

[NN]

I dont have excel data , i have used simout in simulink to get instantaneous values over the course of simulation

[Walter Roberson]

If you need to be able to know what the output of the 1D lookup was at any particular point in the simulation when you go back to review the simulation outputs, then just ask to log the signal.

[NN]

Please help, how to do that ?

My problem is simulation is running in a loop, i need to input the output to look up table as input during the course of simulation , either using simout/From block/Workspace ...

I am not sure how to do that, so that look up table will be automatically updated each time during the simulation

[Walter Roberson]

Sounds to me as if a table is the wrong thing at that point then. Maybe an initialized Memory Store would be better: you could then update it as you run.

[NN]

i iwll try this

[NN]

i do not get the output correctly when i sue memory blco, i believe it applies delay with integration .

[Walter Roberson]

Use a Data Store rather than a Memory block.

https://www.mathworks.com/help/simulink/ug/using-global-data-with-the-matlab-function-block.html

[NN]

Thank you very much for the suggestion .I trued to use the same in the example file to see if it works or not , unfortunately it generates very high value. i tried to implement in third car profile . please find the attached and advice where i did mistake .Any suggestion will be highly appreciated .

[NN]

[Walter Roberson]

Sorry, I do not understand what you are doing well enough to be able to advise on this topic.

[NN]

Thank you very much for th response. now i tried and got it .Data store worksa and it reads and write data . i was trying to analyse why the model shows very less variation in SoC over 24 hour simulation time.In this example MATLAB model, i tried to make changes to third car profile , specifically to input final SoC (which i s given as SE %) instanaeously as input to initial SoC and see the changes .So it should vary SoC asper the model demands each time.It works now with data store, but shows very less SoC %.I dont know why it shows very less % of SoC even during 24 hours of time.