{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Eingabe","Daten"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Eingabe","index":0,"n_rows":23,"n_cols":107,"rows_kept":23,"cut":false,"hidden":false,"merged":[[9,9,22,47]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APZ","Nr.","Typ","Benennung","Best.-Nr.","(Zeichnungsnummer)Part_Number","Part Name","UVB_315","UVB_315_Aussen_1","UVB_315_Innen_1","UVB_315_Aussen_2","UVB_315_Innen_2","UVB_400","UVB_400_Aussen_1","UVB_400_Innen_1","UVB_400_Aussen_2","UVB_400_Innen_2","GBK_400","WAK_400_Sonder_P1\nPosition_1","WAK_400_Sonder_P1_Aussen_1\nPosition_1","WAK_400_Sonder_P1_Innen_1\nPosition_1","WAK_400_Sonder_P1_Aussen_2\nPosition_1","WAK_400_Sonder_P1_Innen_2\nPosition_1","WAK_400_Sonder_P2\nPosition_2","WAK_400_Sonder_P2_Aussen_1\nPosition_2","WAK_400_Sonder_P2_Innen_1\nPosition_2","WAK_400_Sonder_P2_Aussen_2\nPosition_2","WAK_400_Sonder_P2_Innen_2\nPosition_2","WAKS_400_20_P1\nPosition_1","WAKS_400_20_P1_Aussen_1\nPosition_1","WAKS_400_20_P1_Innen_1\nPosition_1","WAKS_400_20_P1_Aussen_2\nPosition_1","WAKS_400_20_P1_Innen_2\nPosition_1","WAKS_400_20_P2\nPosition_2","WAKS_400_20_P2_Aussen_1\nPosition_2","WAKS_400_20_P2_Innen_1\nPosition_2","WAKS_400_20_P2_Aussen_2\nPosition_2","WAKS_400_20_P2_Innen_2\nPosition_2","Spann_D1","Spann_T1\n(Spannlänge)","X1","Spann_D2","Spann_T2\n(Spannlänge)","X2","H\n(Backenhöhe\nab Futter)","Futter-D","Abstand 1\nFutter außen","Abstand 2\nFutter außen","Spannweg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B4","v":"424-04"},{"$f":"B8","v":100},{"$f":"B5","v":"UVB 400"},{"$f":"B6","v":"Weiche Blockbacken"},{"$f":"B10","v":815},{"$f":"B9","v":4711},{"$f":"_xlfn.CONCAT(BG2,\"-\",BH2)","v":"424-04-100"},{"$f":"E4","v":0},{"$f":"E5","v":0},{"$f":"E6","v":0},{"$f":"E7","v":0},{"$f":"E8","v":0},{"$f":"E11","v":1},{"$f":"E12","v":0},{"$f":"E13","v":1},{"$f":"E14","v":1},{"$f":"E15","v":0},{"$f":"E23+H9+H16+H23","v":0},{"$f":"E18","v":0},{"$f":"E19","v":0},{"$f":"E20","v":0},{"$f":"E21","v":0},{"$f":"E22","v":0},{"$f":"H4","v":0},{"$f":"H5","v":0},{"$f":"H6","v":0},{"$f":"H7","v":0},{"$f":"H8","v":0},{"$f":"H11","v":0},{"$f":"H12","v":0},{"$f":"H13","v":0},{"$f":"H14","v":0},{"$f":"H15","v":0},{"$f":"H18","v":0},{"$f":"H19","v":0},{"$f":"H20","v":0},{"$f":"H21","v":0},{"$f":"H22","v":0},{"$f":"$B12","v":15},{"$f":"$B13","v":55},{"$f":"DA2-DC2","v":650},{"$f":"$B14","v":13},{"$f":"$B15","v":48},{"$f":"DB2-DC2","v":76},{"$f":"$B16","v":777},{"$f":"$B17","v":54},{"$f":"$B18","v":652},{"$f":"$B19","v":78},{"$f":"$B20","v":2}]
[]
["Arbeitsplatz","424-04",null,{"$f":"IF($B$5&$B$7=BG5&BH5,BI5,\"\")","v":""},null,null,{"$f":"IF($B$5&$B$7=BG26&BH26,BI26,\"\")","v":""},null,null,{"$f":"BN2","v":0},0,0,0,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,15,55,650,13,48,76,777,54]
["Typ","UVB 400",null,{"$f":"IF($B$5&$B$7=BG6&BH6,BI6,\"\")","v":""},null,null,""]
["Benennung",{"$f":"VLOOKUP(B5,Daten!C2:D888,2,FALSE)","v":"Weiche Blockbacken"},null,{"$f":"IF($B$5&$B$7=BG7&BH7,BI7,\"\")","v":""},null,null,""]
["Spannposition",0,null,{"$f":"IF($B$5&$B$7=BG8&BH8,BI8,\"\")","v":""},null,null,"",null,null,{"$f":"J4","v":0},{"$f":"K4","v":0},0,0,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,15,55,650,13,48,76,777,54]
["Nr.",100,null,{"$f":"IF($B$5&$B$7=BG9&BH9,BI9,\"\")","v":""},null,null,""]
["Zeichnungsnummer",4711,null,null,null,null,""]
["Bestellnummer",815,null,null,null,null,null,null,null,{"$f":"IF($B$5=BB2,BA2,IF(B5=BB3,BA2,IF(B5=BB4,BA4,IF(B5=BB5,BA5,IF(B5=BB6,BA6,IF(B5=BB7,BA7,\"\"))))))","v":""}]
[null,null,null,{"$f":"IF($B$5&$B$7=BG12&BH12,BI12,\"\")","v":""},1,null,{"$f":"IF($B$5&$B$7=BG33&BH33,BI33,\"\")","v":""}]
["Spannen D1",15,null,{"$f":"IF($B$5&$B$7=BG13&BH13,BI13,\"\")","v":""},0,null,""]
["Spannen T1 (Spannlänge)",55,null,{"$f":"IF($B$5&$B$7=BG14&BH14,BI14,\"\")","v":""},1,null,""]
["Spannen D2",13,null,{"$f":"IF($B$5&$B$7=BG15&BH15,BI15,\"\")","v":""},1,null,""]
["Spannen T2 (Spannlänge)",48,null,{"$f":"IF($B$5&$B$7=BG16&BH16,BI16,\"\")","v":""},0,null,""]
["H (Backenhöhe ab Futter)",777,null,null,null,null,""]
["Futter Ø",54]
["Abstand 1 \nFutter außen",652,null,{"$f":"IF($B$5&$B$7=BG19&BH19,BI19,\"\")","v":""},null,null,{"$f":"IF($B$5&$B$7=BG40&BH40,BI40,\"\")","v":""}]
["Abstand 2 \nFutter außen",78,null,"",null,null,""]
["Spannweg",2,null,"",null,null,""]
[null,null,null,"",null,null,""]
[null,null,null,"",null,null,""]
[null,null,null,"",null,null,""]

{"sheet":"Daten","index":1,"n_rows":9,"n_cols":49,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["APZ","Nr.","Typ","Benennung","Best.-Nr.","Part_Number","Part Name","UVB_315","UVB_315_Aussen_1","UVB_315_Innen_1","UVB_315_Aussen_2","UVB_315_Innen_2","UVB_400","UVB_400_Aussen_1","UVB_400_Innen_1","UVB_400_Aussen_2","UVB_400_Innen_2","GBK_400","WAK_400_Sonder_P1\nPosition_1","WAK_400_Sonder_P1_Aussen_1\nPosition_1","WAK_400_Sonder_P1_Innen_1\nPosition_1","WAK_400_Sonder_P1_Aussen_2\nPosition_1","WAK_400_Sonder_P1_Innen_2\nPosition_1","WAK_400_Sonder_P2\nPosition_2","WAK_400_Sonder_P2_Aussen_1\nPosition_2","WAK_400_Sonder_P2_Innen_1\nPosition_2","WAK_400_Sonder_P2_Aussen_2\nPosition_2","WAK_400_Sonder_P2_Innen_2\nPosition_2","WAKS_400_20_P1\nPosition_1","WAKS_400_20_P1_Aussen_1\nPosition_1","WAKS_400_20_P1_Innen_1\nPosition_1","WAKS_400_20_P1_Aussen_2\nPosition_1","WAKS_400_20_P1_Innen_2\nPosition_1","WAKS_400_20_P2\nPosition_2","WAKS_400_20_P2_Aussen_1\nPosition_2","WAKS_400_20_P2_Innen_1\nPosition_2","WAKS_400_20_P2_Aussen_2\nPosition_2","WAKS_400_20_P2_Innen_2\nPosition_2","Spann_D1","Spann_T1\n(Spannlänge)","X1","Spann_D2","Spann_T2\n(Spannlänge)","X2","H\n(Backenhöhe\nab Futter)","Futter-D","Abstand 1\nFutter außen","Abstand 2\nFutter außen","Spannweg"]
["424-04",21,"UVB 400","Weiche Blockbacken","012451","161280-021","424-04-21",0,0,0,0,0,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,153,11,{"$f":"AU2-AW2","v":15},160,20,{"$f":"AV2-AW2","v":18},65.8,400,17,20,2]
["424-04",22,"WAK 400 Sonder","Weiche Aufsatzbacken","213124","161280-022","424-04-22",0,0,0,0,0,0,0,0,0,0,1,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,335,11.9,23.5,0,0,0,123.3,400,25.5,null,2]
["424-04",23,"UVB 400","Weiche Blockbacken","012451","161280-023","424-04-23",0,0,0,0,0,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,160,45,7.1,240,45,{"$f":"AV4-AW4","v":46},65.8,400,9.1,48,2]
["424-04",24,"WAKS 400-20","Weiche Aufsatzbacken","080951","161280-024","424-04-24",0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,91,96.4,-14,0,0,0,62.7,400,-12,null,2]
["424-04",25,"UVB 400","Weiche Blockbacken","012451","161280-025","424-04-25",0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,290.7,40,6.6999999999999993,0,0,0,66.2,400,8.6999999999999993,null,2]
["424-04",26,"WAK 400 Sonder","Weiche Aufsatzbacken","231124","161280-026","424-04-26",0,0,0,0,0,0,0,0,0,0,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"130 innen",40,-26,0,0,0,123.1,400,-24,null,2]
["424-04",27,"WAKS 400-20","Weiche Aufsatzbacken","080951","161280-027","424-04-27",0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,365,12,17.5,0,0,0,62.7,400,19.5,null,2]
["424-04",28,"WAKS 400-20","Weiche Aufsatzbacken","080951","161280-028","424-04-28",0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,112,96.4,-3.9,0,0,0,62.7,400,-1.9,null,2]