{"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":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,7],[4,7,6,7]]}
["ABL System Planning Tool for Group Installations"]
["eMH3","Model variant","EVCC L","EVCC R","Meter L","Meter R","RFID","Factory setting"]
["MASTER","Please choose",{"$f":"IF($B$3=\"Please choose\",\"–\",IF($B$3=\"Control unit\",\"\",IF($B$3=\"Single\",\"\",IF($B$3=\"Twin\",\"1\",\"\"))))","v":"–"},{"$f":"IF($B$3=\"Please choose\",\"–\",IF($B$3=\"Control unit\",\"\",IF($B$3=\"Single\",\"1\",IF($B$3=\"Twin\",\"2\",\"\"))))","v":"–"},{"$f":"IF($B$3=\"Please choose\",\"–\",IF($B$3=\"Control unit\",\"\",IF($B$3=\"Single\",\"\",IF($B$3=\"Twin\",\"1\",\"\"))))","v":"–"},{"$f":"IF($B$3=\"Please choose\",\"–\",IF($B$3=\"Control unit\",\"\",IF($B$3=\"Single\",\"1\",IF($B$3=\"Twin\",\"2\",\"\"))))","v":"–"},{"$f":"IF($B$3=\"Please choose\",\"–\",IF($B$3=\"Steuerzentrale\",\"\",IF($B$3=\"Single\",\"1\",IF($B$3=\"Twin\",\"1\",\"\"))))","v":"–"},{"$f":"IF($B$3=\"Please choose\",\"–\",IF($B$3=\"Control unit\",\"No input necessary\",IF(B3=\"Single\",IF(I3=0,\"No changes required\",\"Changes required!\"),(IF(B3=\"Twin\",IF(J3=0,\"No changes required\",\"Changes required!\"))))))","v":"–"},{"$f":"SUM($D3+$F3+$G3)-3","v":{"$error":"#VALUE!"}},{"$f":"SUM($C3+$D3+$E3+$F3+$G3)-7","v":{"$error":"#VALUE!"}},{"$f":"IF($B$3=\"Please choose\",\"\",IF($B$3=\"Control unit\",\"0\",IF($B$3=\"Single\",\"1\",IF($B$3=\"Twin\",\"2\",\"\"))))","v":""},{"$f":"IF($B$3=\"Please choose\",\"\",IF($B$3=\"Control unit\",\"0\",IF($B$3=\"Single\",\"1\",IF($B$3=\"Twin\",\"2\",\"\"))))","v":""}]
["SLAVE 1","Please choose",{"$f":"IF($B4=\"Please choose\",\"–\",IF($B4=\"Single\",\"\",IF($B4=\"Twin\",$L3+1)))","v":"–"},{"$f":"IF($B4=\"Please choose\",\"–\",IF($B4=\"Single\",1+$K3,IF($B4=\"Twin\",$C4+1)))","v":"–"},{"$f":"IF($B4=\"Please choose\",\"–\",IF($B4=\"Single\",\"\",IF($B4=\"Twin\",$L3+1)))","v":"–"},{"$f":"IF($B4=\"Please choose\",\"–\",IF($B4=\"Single\",$L3+1,IF($B4=\"Twin\",$E4+1)))","v":"–"},{"$f":"IF($B4=\"Please choose\",\"–\",IF($B4=\"Single\",$F4,IF($B4=\"Twin\",$E4)))","v":"–"},{"$f":"IF(B4=\"Please choose\",\"–\",IF(B4=\"Single\",IF(I4=0,\"No changes required\",\"Changes required!\"),(IF(B4=\"Twin\",IF(J4=0,\"No changes required\",\"Changes required!\")))))","v":"–"},{"$f":"SUM($D4+$F4+$G4)-11","v":{"$error":"#VALUE!"}},{"$f":"SUM($C4+$D4+$E4+$F4+$G4)-19","v":{"$error":"#VALUE!"}}]
["SLAVE 2","Please choose",{"$f":"IF($B5=\"Please choose\",\"–\",IF($B5=\"Single\",\"\",IF($B5=\"Twin\",$D4+1)))","v":"–"},{"$f":"IF($B5=\"Please choose\",\"–\",IF($B5=\"Single\",$D4+1,IF($B5=\"Twin\",$D4+2)))","v":"–"},{"$f":"IF($B5=\"Please choose\",\"–\",IF($B5=\"Single\",\"\",IF($B5=\"Twin\",$F4+1)))","v":"–"},{"$f":"IF($B5=\"Please choose\",\"–\",IF($B5=\"Single\",$F4+1,IF($B5=\"Twin\",$F4+2)))","v":"–"},"–","From Slave 2 on, the factory settings must always be changed!"]
["SLAVE 3","Please choose","–","–","–","–","–"]
["SLAVE 4","Please choose","–","–","–","–","–"]
["SLAVE 5","Please choose","–","–","–","–","–"]
["SLAVE 6","Please choose","–","–","–","–","–"]
["SLAVE 7","Please choose","–","–","–","–","–"]
["SLAVE 8","Please choose","–","–","–","–","–"]
["SLAVE 9","Please choose","–","–","–","–","–"]
["SLAVE 10","Please choose","–","–","–","–","–"]
["SLAVE 11","Please choose","–","–","–","–","–"]
["SLAVE 12","Please choose","–","–","–","–","–"]
["SLAVE 13","Please choose","–","–","–","–","–"]
["SLAVE 14","Please choose","–","–","–","–","–"]
["SLAVE 15","Please choose","–","–","–","–","–"]
[]
[]
[null,null,"Quick start guide",null,"1. Click Start to begin entering."]
[null,null,null,null,"2. Enter all Wallbox variants in the desired order."]
[null,null,null,null,"3. When input is complete, click Print to print the configuration."]