{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["input"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":12,"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":"input","index":0,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Input",null,null,null,"Output"]
[]
[null,null,null,null,"filter","limit","sort by",null,null,"chartCols"]
[null,null,null,null,"Anna",5,"Index",null,null,1,3]
["ID","Value","Index",null,{"$f":"TRANSPOSE(_xlfn.ANCHORARRAY(L20))","v":"ID"},"Value","Index",null,null,"chartData_1","chartData_2"]
["Anna",1000,0.42,null,{"$f":"_xlfn.LET(_xlpm.data,_xlfn._xlws.FILTER(input[],input[ID]=ID_filter),\n_xlpm.sortby,_xlfn.XMATCH(G4,_xlfn.ANCHORARRAY(ChosenCols)),\n_xlpm.sorted,_xlfn.CHOOSECOLS(_xlfn._xlws.SORT(_xlpm.data,_xlpm.sortby),_xlfn.ANCHORARRAY(ChosenColsNums)),\n_xlpm.output,_xlfn.TAKE(_xlpm.sorted,Top),\n_xlpm.output\n)","v":"Anna"},1347,0.11,null,null,{"$f":"INDEX(_xlfn.ANCHORARRAY(E6),,J4)","v":"Anna"},{"$f":"INDEX(_xlfn.ANCHORARRAY(E6),,K4)","v":0.11}]
["Anna",1000,0.42,null,"Anna",1347,0.11,null,null,"Anna",0.11]
["Maria",800,0.42,null,"Anna",1000,0.42,null,null,"Anna",0.42]
["Anna",800,0.47,null,"Anna",1000,0.42,null,null,"Anna",0.42]
["Jane",1252,0.47,null,"Anna",800,0.47,null,null,"Anna",0.47]
["Jane",1252,0.47]
["Anna",1347,0.47,null,null,null,null,null,"Anna",0.11]
["Joe",1347,0.47,null,null,null,null,null,"Anna",0.11]
["Joe",1347,0.11,null,null,null,null,null,"Anna",0.42]
["Anna",1347,0.11,null,null,null,null,null,"Anna",0.42]
["Anna",1347,0.11,null,null,null,null,null,"Anna",0.47]
[]
[]
[null,null,null,"Bakground Calculations","ID",null,"Choose","Header",null,null,"ChosenCols"]
[null,null,null,null,{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(input[ID]))","v":"Anna"},null,1,{"$f":"TRANSPOSE(input[#Headers])","v":"ID"},null,null,{"$f":"_xlfn.LET(_xlpm.input,_xlfn.HSTACK(INDEX(input!G20:_xlfn.ANCHORARRAY(input!$H$20),,1),ROW(_xlfn.ANCHORARRAY(input!$H$20))-ROW(input!$H$20)+1),\n_xlpm.data,_xlfn._xlws.SORT(_xlpm.input),\n_xlpm.output,_xlfn._xlws.FILTER(INDEX(_xlpm.data,,2),INDEX(_xlpm.data,,1)>0),\n_xlpm.output\n)","v":1},{"$f":"INDEX(_xlfn.ANCHORARRAY(H20),_xlfn.ANCHORARRAY(ChosenColsNums))","v":"ID"}]
[null,null,null,null,"Jane",null,2,"Value",null,null,2,"Value"]
[null,null,null,null,"Joe",null,3,"Index",null,null,3,"Index"]
[null,null,null,null,"Maria"]