{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Utility"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Utility","index":0,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,8],[4,8,6,8]]}
["ABL  Systemplaner Gruppeninstallation"]
["eMH3","Variante","LGW","EVCC L","EVCC R","Meter L","Meter R","RFID","Werkseinstellung"]
["MASTER","Bitte wählen",{"$f":"IF($B$3=\"Bitte wählen\",\"–\",IF($B$3=\"Steuerzentrale\",\"\",IF($B$3=\"Twin\",\"100\",IF($B$3=\"Single\",\"100\",\"–\"))))","v":"–"},{"$f":"IF($B$3=\"Bitte wählen\",\"–\",IF($B$3=\"Steuerzentrale\",\"\",IF($B$3=\"Single\",\"\",IF($B$3=\"Twin\",\"1\",\"\"))))","v":"–"},{"$f":"IF($B$3=\"Bitte wählen\",\"–\",IF($B$3=\"Steuerzentrale\",\"\",IF($B$3=\"Single\",\"1\",IF($B$3=\"Twin\",\"2\",\"\"))))","v":"–"},{"$f":"IF($B$3=\"Bitte wählen\",\"–\",IF($B$3=\"Steuerzentrale\",\"\",IF($B$3=\"Single\",\"\",IF($B$3=\"Twin\",\"1\",\"\"))))","v":"–"},{"$f":"IF($B$3=\"Bitte wählen\",\"–\",IF($B$3=\"Steuerzentrale\",\"\",IF($B$3=\"Single\",\"1\",IF($B$3=\"Twin\",\"2\",\"\"))))","v":"–"},{"$f":"IF($B$3=\"Bitte wählen\",\"–\",IF($B$3=\"Steuerzentrale\",\"\",IF($B$3=\"Single\",\"1\",IF($B$3=\"Twin\",\"1\",\"\"))))","v":"–"},{"$f":"IF($B$3=\"Bitte wählen\",\"–\",IF($B$3=\"Steuerzentrale\",\"Keine Eingaben notwendig\",IF(B3=\"Single\",IF(J3=0,\"Keine Änderung\",\"Änderung!\"),(IF(B3=\"Twin\",IF(K3=0,\"Keine Änderung\",\"Änderung!\"))))))","v":"–"},{"$f":"SUM($C3+$E3+$G3+$H3)-103","v":{"$error":"#VALUE!"}},{"$f":"SUM($C3+$D3+$E3+$F3+$G3+$H3)-107","v":{"$error":"#VALUE!"}}]
["SLAVE 1","Bitte wählen",{"$f":"IF($B$4=\"Bitte wählen\",\"–\",IF($B$3=\"Steuerzentrale\",\"100\",IF($B$4=\"Twin\",$E3+100,IF($B$4=\"Single\",$E3+100,\"–\"))))","v":"–"},{"$f":"IF($B4=\"Bitte wählen\",\"–\",IF($B4=\"Single\",\"\",IF($B4=\"Twin\",$C4-99)))","v":"–"},{"$f":"IF($B4=\"Bitte wählen\",\"–\",IF($B4=\"Single\",$C4-99,IF($B4=\"Twin\",$D4+1)))","v":"–"},{"$f":"IF($B4=\"Bitte wählen\",\"–\",IF($B4=\"Single\",\"\",IF($B4=\"Twin\",$C4-99)))","v":"–"},{"$f":"IF($B4=\"Bitte wählen\",\"–\",IF($B4=\"Single\",$C4-99,IF($B4=\"Twin\",$D4+1)))","v":"–"},{"$f":"IF($B4=\"Bitte wählen\",\"–\",IF($B4=\"Single\",$G4,IF($B4=\"Twin\",$F4)))","v":"–"},{"$f":"IF(B4=\"Bitte wählen\",\"–\",IF(B4=\"Single\",IF(J4=0,\"Keine Änderung\",\"Änderung!\"),(IF(B4=\"Twin\",IF(K4=0,\"Keine Änderung\",\"Änderung!\")))))","v":"–"},{"$f":"SUM($C4+$E4+$G4+$H4)-111","v":{"$error":"#VALUE!"}},{"$f":"SUM($C4+$D4+$E4+$F4+$G4+$H4)-119","v":{"$error":"#VALUE!"}}]
["SLAVE 2","Bitte wählen",{"$f":"IF($B5=\"Bitte wählen\",\"–\",IF($B4=\"Single\",$C4+1,IF($B4=\"Twin\",$C4+2)))","v":"–"},{"$f":"IF($B5=\"Bitte wählen\",\"–\",IF($B5=\"Single\",\"\",IF($B5=\"Twin\",$E4+1)))","v":"–"},{"$f":"IF($B5=\"Bitte wählen\",\"–\",IF($B5=\"Single\",$E4+1,IF($B5=\"Twin\",$E4+2)))","v":"–"},{"$f":"IF($B5=\"Bitte wählen\",\"–\",IF($B5=\"Single\",\"\",IF($B5=\"Twin\",$G4+1)))","v":"–"},{"$f":"IF($B5=\"Bitte wählen\",\"–\",IF($B5=\"Single\",$G4+1,IF($B5=\"Twin\",$G4+2)))","v":"–"},"–","Ab Slave 2 müssen die Werkseinstellungen immer geändert werden!"]
["SLAVE 3","Bitte wählen","–","–","–","–","–","–"]
["SLAVE 4","Bitte wählen","–","–","–","–","–","–"]
["SLAVE 5","Bitte wählen","–","–","–","–","–","–"]
["SLAVE 6","Bitte wählen","–","–","–","–","–","–"]
["SLAVE 7","Bitte wählen","–","–","–","–","–","–"]
["SLAVE 8","Bitte wählen","–","–","–","–","–","–"]
["SLAVE 9","Bitte wählen","–","–","–","–","–","–"]
["SLAVE 10","Bitte wählen","–","–","–","–","–","–"]
["SLAVE 11","Bitte wählen","–","–","–","–","–","–"]
["SLAVE 12","Bitte wählen","–","–","–","–","–","–"]
["SLAVE 13","Bitte wählen","–","–","–","–","–","–"]
["SLAVE 14","Bitte wählen","–","–","–","–","–","–"]
["SLAVE 15","Bitte wählen","–","–","–","–","–","–"]
[]
[]
[null,null,null,"Kurzanleitung","1. Klicken Sie auf Start, um mit der Eingabe zu beginnen."]
[null,null,null,null,"2. Geben Sie alle Wallbox-Varianten in der gewünschten Reihenfolge ein."]
[null,null,null,null,"3. Klicken Sie nach Abschluss der Eingabe auf Drucken, um die Konfiguration auszudrucken."]