{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":51,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Material","Measurements"]
["A",1.1000000000000001,1.2,1.3,1.4,1.5,100.1,100.2,100.3,100.4,100.5]
["Include",1,1,1,1,1,0,0,0,0,0]
[]
["Mean",{"$f":"AVERAGEIF(B3:K3,1,B2:K2)","v":1.3}]
["SD",{"$f":"_xlfn.STDEV.S(IF(B3:K3=1,B2:K2))","v":0.15811388300842008}]
[]
[]
[null,"LIST",null,null,null,"LIST+"]
[null,{"$f":"_xlfn.LET(_xlpm.in,B2:K2,\n_xlpm.n,5,\n_xlpm.sortin, _xlfn._xlws.SORT(TRANSPOSE(_xlpm.in)),\n_xlpm.start, _xlfn.SEQUENCE(ROWS(_xlpm.sortin)-_xlpm.n),\n_xlpm.stdlist, _xlfn.SCAN(0,_xlpm.start,_xlfn.LAMBDA(_xlpm.p,_xlpm.i,_xlfn.STDEV.P(INDEX(_xlpm.sortin,_xlpm.start+_xlpm.i-1)))),\n_xlpm.findLow,MATCH(MIN(_xlpm.stdlist),_xlpm.stdlist,0),\nINDEX(_xlpm.sortin,_xlpm.start+_xlpm.findLow-1)\n)","v":1.1000000000000001},"mean",{"$f":"AVERAGE(_xlfn.ANCHORARRAY(B10))","v":1.3},null,{"$f":"_xlfn.LET(_xlpm.in,B2:K2,\n_xlpm.n,5,\n_xlpm.sortin, _xlfn._xlws.SORT(TRANSPOSE(_xlpm.in)),\n_xlpm.start, _xlfn.SEQUENCE(ROWS(_xlpm.sortin)-_xlpm.n),\n_xlpm.stdlist, _xlfn.SCAN(0,_xlpm.start,_xlfn.LAMBDA(_xlpm.p,_xlpm.i,_xlfn.STDEV.P(INDEX(_xlpm.sortin,_xlpm.start+_xlpm.i-1)))),\n_xlpm.findLow,MATCH(MIN(_xlpm.stdlist),_xlpm.stdlist,0),\n_xlpm.ans,INDEX(_xlpm.sortin,_xlpm.start+_xlpm.findLow-1),\n_xlpm.out,_xlfn.VSTACK(_xlpm.ans,\"Avg\",AVERAGE(_xlpm.ans),\"SD\",_xlfn.STDEV.P(_xlpm.ans)),\n_xlpm.out)","v":1.1000000000000001}]
[null,1.2,"sd",{"$f":"_xlfn.STDEV.P(_xlfn.ANCHORARRAY(B10))","v":0.1414213562373095},null,1.2]
[null,1.3,null,null,null,1.3]
[null,1.4,null,null,null,1.4]
[null,1.5,null,null,null,1.5]
[null,null,null,null,null,"Avg"]
[null,null,null,null,null,1.3]
[null,null,null,null,null,"SD"]
[null,null,null,null,null,0.1414213562373095]