{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Diagramme"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":[]}
[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"]
["Österreich","EUR",1000,2000,1800,3500,3400,4500,4300,5500]
["Belgien","EUR",1000,2000,1800,3500,3400,4500,4300,5500,null,null,null,null,null,null,null,null,null," "]
["Schweiz","CHF",2700,3900,4100,5900,5400,7800,7500,8800,null,null,null,null,null,null,null,null,null," "]
["Deutschland","EUR",1100,2100,1850,3400,3200,4400,4200,6000]
["Frankreich","EUR",1200,2200,2000,3600,3450,4500,4300,6700]
["GB","GBP",1100,2100,1850,3400,3200,4400,4200,6000]
["Irland","EUR",1000,2000,1800,3500,3400,4500,4300,5500]

{"sheet":"Diagramme","index":1,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Gerät D",null,null,null,null,null,null,null,"Belgien"]
["Land + Währung",{"$f":"A1&\": min\"","v":"Gerät D: min"},{"$f":"A1&\": max\"","v":"Gerät D: max"},null,null,null,null,null,{"$f":"_xlfn.LET(_xlpm.xA,_xlfn._xlws.FILTER(Sheet1!C3:J100,Sheet1!A3:A100=I1),\n_xlpm.xB,TRANSPOSE(_xlfn._xlws.FILTER(Sheet1!C1:J1,Sheet1!C1:J1<>\"\")),\n_xlpm.xC,_xlfn.VSTACK(INDEX(_xlpm.xA,,1),INDEX(_xlpm.xA,,3),INDEX(_xlpm.xA,,5),INDEX(_xlpm.xA,,7)),\n_xlpm.xD,_xlfn.VSTACK(INDEX(_xlpm.xA,,2)-INDEX(_xlpm.xA,,1),INDEX(_xlpm.xA,,4)-INDEX(_xlpm.xA,,3),INDEX(_xlpm.xA,,6)-INDEX(_xlpm.xA,,5),INDEX(_xlpm.xA,,8)-INDEX(_xlpm.xA,,7)),\n_xlpm.xE,_xlfn.VSTACK(INDEX(_xlpm.xA,,2),INDEX(_xlpm.xA,,4),INDEX(_xlpm.xA,,6),INDEX(_xlpm.xA,,8)),\n_xlfn.HSTACK(_xlpm.xB,_xlpm.xC,_xlpm.xD,_xlpm.xE))","v":"Gerät A"},1000,1000,2000,{"$f":"_xlfn.LET(_xlpm.xA,_xlfn.ANCHORARRAY(I2),\n_xlpm.xB,INDEX(_xlpm.xA,,1),\n_xlpm.xC,INDEX(_xlpm.xA,ROW(_xlpm.xA)-2,1),\n_xlpm.xd,IF(INDEX(_xlpm.xB,,1)=INDEX(_xlpm.xC,,1),INDEX(_xlpm.xB,,1),INDEX(_xlpm.xC,,1)&\"/\"&INDEX(_xlpm.xB,,1)),\n_xlpm.xF,INDEX(_xlpm.xA,ROW(_xlpm.xA)-2,4)-INDEX(_xlpm.xA,,4),\n_xlpm.xG,IF(INDEX(_xlpm.xF,,1)<0,INDEX(_xlpm.xF,,1),#N/A),\n_xlfn.HSTACK(_xlpm.xd,_xlpm.xG))","v":"Gerät A"},{"$error":"#N/A"},{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(Sheet1!A3:A100,Sheet1!A3:A100>\"\"),,1)","v":"Belgien"},{"$f":"_xlfn.LET(_xlpm.xA,_xlfn._xlws.FILTER(Sheet1!C3:J100,Sheet1!A3:A100=I1),\nMAX(_xlpm.xA+2000))","v":7500}]
[{"$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"}," ",null,"Gerät B",1800,1700,3500,"Gerät A/Gerät B",-1500,"Deutschland"]
["Belgien EUR",4300,1200,5500,null,{"$f":"MAX(D3:D9)+2000","v":10800},null,null,"Gerät C",3400,1100,4500,"Gerät B/Gerät C",-1000,"Frankreich"]
["Schweiz CHF",7500,1300,8800,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(Sheet1!C1:J1,Sheet1!C1:J1<>\"\"))","v":"Gerät A"},null,null,"Gerät D",4300,1200,5500,"Gerät C/Gerät D",-1000,"GB"]
["Deutschland EUR",4200,1800,6000,null,"Gerät B",null,null,null,null,null,null,null,null,"Irland"]
["Frankreich EUR",4300,2400,6700,null,"Gerät C",null,null,null,null,null,null,null,null,"Österreich"]
["GB GBP",4200,1800,6000,null,"Gerät D",null,null,null,null,null,null,null,null,"Schweiz"]
["Irland EUR",4300,1200,5500]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.LET(_xlpm.xA,_xlfn.ANCHORARRAY(I2),\n_xlpm.xB,INDEX(_xlpm.xA,,1),\n_xlpm.xC,INDEX(_xlpm.xA,ROW(_xlpm.xA)-2,1),\n_xlpm.xd,IF(INDEX(_xlpm.xB,,1)=INDEX(_xlpm.xC,,1),INDEX(_xlpm.xB,,1),INDEX(_xlpm.xC,,1)&\"/\"&INDEX(_xlpm.xB,,1)),\n_xlpm.xF,INDEX(_xlpm.xA,ROW(_xlpm.xA)-2,4)-INDEX(_xlpm.xA,,4),\n_xlpm.xG,IF(INDEX(_xlpm.xF,,1)<0,INDEX(_xlpm.xF,,1),#N/A),\n_xlfn.HSTACK(_xlpm.xd,_xlpm.xG))","v":"Gerät A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gerät A/Gerät B",-1500]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gerät B/Gerät C",-1000]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gerät C/Gerät D",-1000]