I'm struggling with major issues. Last night, I linked my model with excel in order to write down different time measurements that I'm taking throughout a simulation run. The different kind of measurements belong to certain columns, but one simulation run is written down in on row only. So before the run starts, I'd like to go down one row.
I have implemented this by using the global variable "row". I declared the variable in the atom-editor in my model, in the section "Events" and "Init", in one of the sources.
Code: Select all
dim([Row],vbvalue,5)
Code: Select all
Row:=row+1
Code: Select all
3 Compile error: "Row" is not a valid expression. Reference: Excelwrite(Row,3,(time/60))
4 Could not set expression to attribute 'EntryTrigger' on atom 'Source'.
And second of all, every single "excelwrite-code" is not working properly either. So in the end, after one run is over, only a few times are written down in row. It seems like one or two excel-write codes are working correctly, but the rest of the 3/4 are not. Moreover, it's written down in row 5 instead of row 6.
I really need some help on this. Thanks!!