{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Names","Year","Data1"]
["Name1",2022,59.053233809981684]
["Name1",2023,55.21930178100547]
["Name1",2024,76.795934200589883]
["Name1",2025,16.051332385413573]
["Name2",2022,90.057719531646853]
["Name2",2023,26.518466680168363]
["Name2",2024,76.372629475305502]
["Name2",2025,67.754385228652524]
["Name3",2022,99.797999935317279]
["Name3",2023,72.540082890853441]
["Name3",2024,75.905094265959548]
["Name3",2025,99.789061371726106]
["Name4",2022,62.881978846784349]
["Name4",2023,47.295037904473446]
["Name4",2024,27.447021178684871]
["Name4",2025,99.146654077063403]
[]
[]
["Filter Function Result"]
["Name","Name2"]
[]
[null,{"$f":"_xlfn.FORMULATEXT(B26)","v":"{=IFERROR(TRANSPOSE(FILTER(DataTable[Data1],\n((DataTable[Year]=INDEX(INDEX(B25:L25,B24:L24),,1))*(DataTable[Names]=$B$21))\n)),0)}"}]
[null,1,2,3,4,5,6,7,8,9,10,11]
[null,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,{"$f":"IFERROR(TRANSPOSE(_xlfn._xlws.FILTER(DataTable[Data1],\n((DataTable[Year]=INDEX(INDEX(B25:L25,B24:L24),,1))*(DataTable[Names]=$B$21))\n)),0)","v":0},0,90.057719531646853,26.518466680168363,76.372629475305502,67.754385228652524,0,0,0,0,0]