Excel: unknown number of entries

Hi,

I use the experimenter (EndOfReplication) to put all the simulation results in an Excel sheet (from an earlier generated GlobalTable). Here an example for data each FlowItem carries in its labels.

//Experimenter EndOfReplication:
excellaunch(C:/Program Files/...);
excelopen(concat(modeldir(),"RESULTS.xlsx"));
excelsetsheet(concat("ItemReplication",numtostring(replication)));
excelexporttable("GlobalTableFlowItemInformation",1,1,gettablerows("GlobalTableFlowItemInformation"),gettablecols("GlobalTableFlowItemInformation"));
excelclose(1);
excelquit();

I would like Excel calculations to be done automaticly (by making an appropriate template named RESULTS.xlsx). Here, it is unknown how many rows the excel table will have.

Column calculations such as sums are easy: to sum up a column with an unknown number of rows, one can use =SUM(X:X) for column X.

My question is, how to do row calculations for each row/FlowItem (e.g. staytime = time2 - time1). The "staytime" column then can be used for calculations (e.g. =AVERAGE(X:X), with X the staytime column).

One "heavy" solution is to fill the entire column (by copying one cell, selecting the column, and pasting) with the function =IF(NOT(A1="");B1-A1;""). Does somebody have a "lighter" solution?

Thanks

It looks like it is possible to fill two rows which contain numbers that Flexsim could have exported, then to double-click on the cross (right-down corner of the cell with the =B1-A1 code) to expand the code to the entire data (both rows). Then, if no row is left with blank cells, and the rows are filled one by one in the descending order, the code expands automaticly to the freshly created rows.

This doesn't work always - I don't know why.