{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Tabelle1"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":9,"n_cols":20,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7],[0,8,0,9]]}
[null,null,"Gerät A",null,"Gerät B",null,"Gerät C",null,"Gerät D"]
["Land","Währung"," A min"," A max"," B min"," B max"," C min"," C max"," D min"," D max",null,"Irland","min","diff","max"]
["Österreich","EUR",1000,2000,1800,3500,3400,4500,4300,5500,null,{"$f":"_xlfn.LET(_xlpm.xA,_xlfn._xlws.FILTER(A3:J9,A3:A9=L2),\n_xlpm.xB,TRANSPOSE(_xlfn._xlws.FILTER(C1:J1,C1:J1<>\"\")),\n_xlpm.xC,_xlfn.VSTACK(INDEX(_xlpm.xA,,3),INDEX(_xlpm.xA,,5),INDEX(_xlpm.xA,,7),INDEX(_xlpm.xA,,9)),\n_xlpm.xD,_xlfn.VSTACK(INDEX(_xlpm.xA,,4)-INDEX(_xlpm.xA,,3),INDEX(_xlpm.xA,,6)-INDEX(_xlpm.xA,,5),INDEX(_xlpm.xA,,8),INDEX(_xlpm.xA,,10)-INDEX(_xlpm.xA,,9)),\n_xlpm.xE,_xlfn.VSTACK(INDEX(_xlpm.xA,,4),INDEX(_xlpm.xA,,6),INDEX(_xlpm.xA,,8),INDEX(_xlpm.xA,,10)),\n_xlfn.HSTACK(_xlpm.xB,_xlpm.xC,_xlpm.xD,_xlpm.xE))","v":"Gerät A"},1000,1000,2000,null,{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(A3:A100,A3:A100>\"\"),,1)","v":"Belgien"},{"$f":"_xlfn.LET(_xlpm.xA,_xlfn._xlws.FILTER(C3:J100,A3:A100=L2),\nMAX(_xlpm.xA+3000))","v":8500}]
["Belgien","EUR",1000,2000,1800,3500,3400,4500,4300,5500,null,"Gerät B",1800,1700,3500,null,"Deutschland",null,null," "]
["Schweiz","CHF",2700,3900,4100,5900,5400,7800,7500,8800,null,"Gerät C",3400,4500,4500,null,"Frankreich",null,null," "]
["Deutschland","EUR",1100,2100,1850,3400,3200,4400,4200,6000,null,"Gerät D",4300,1200,5500,null,"GB"]
["Frankreich","EUR",1200,2200,2000,3600,3450,4500,4300,6700,null,null,null,null,null,null,"Irland"]
["GB","GBP",1100,2100,1850,3400,3200,4400,4200,6000,null,null,null,null,null,null,"Österreich"]
["Irland","EUR",1000,2000,1800,3500,3400,4500,4300,5500,null,null,null,null,null,null,"Schweiz"]

{"sheet":"Tabelle1","index":1,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Gerät D"]
["Land + Währung",{"$f":"A1&\": min\"","v":"Gerät D: min"},{"$f":"A1&\": max\"","v":"Gerät D: max"}]
[{"$f":"_xlfn.LET(_xlpm.xA,_xlfn._xlws.FILTER(Sheet1!A3:J500,Sheet1!A3:A500<>\"\"),\n_xlpm.xB,INDEX(_xlpm.xA,,1)&\" \"&INDEX(_xlpm.xA,,2),\n_xlpm.xC,_xlfn.XMATCH(A1,Sheet1!C1:J1,0)+2,\n_xlpm.xD,INDEX(_xlpm.xA,,_xlpm.xC),\n_xlpm.xE,INDEX(_xlpm.xA,,_xlpm.xC+1)-INDEX(_xlpm.xA,,_xlpm.xC),\n_xlpm.xF,INDEX(_xlpm.xA,,_xlpm.xC+1),\n_xlfn.HSTACK(_xlpm.xB,_xlpm.xD,_xlpm.xE,_xlpm.xF))","v":"Österreich EUR"},4300,1200,5500,null,{"$f":"A1&\": Bereich nach Landeswährung\"","v":"Gerät D: Bereich nach Landeswährung"}," "]
["Belgien EUR",4300,1200,5500,null,{"$f":"MAX(D3:D9)+2000","v":10800}]
["Schweiz CHF",7500,1300,8800,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(Sheet1!C1:J1,Sheet1!C1:J1<>\"\"))","v":"Gerät A"}]
["Deutschland EUR",4200,1800,6000,null,"Gerät B"]
["Frankreich EUR",4300,2400,6700,null,"Gerät C"]
["GB GBP",4200,1800,6000,null,"Gerät D"]
["Irland EUR",4300,1200,5500]