{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Auswahl in Gehäuse","Auswahl Komponenten","Artikelnummer Logik","Konfiguration in Gehäuse","Foto","Aufbau","Auswahldiagramm","Artikelnummer Logik 2025"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":6,"comments":2,"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":"Auswahl in Gehäuse","index":0,"n_rows":44,"n_cols":19,"rows_kept":44,"cut":false,"hidden":true,"merged":[[43,4,43,7],[40,6,40,7],[31,13,31,16],[30,13,30,17],[22,4,22,10],[30,4,30,7],[31,4,31,7],[32,4,32,7]]}
[null,"Konfiguration Gehäuse- / Hybrid USV "]
[null,"Auszug aus der  J. Schneider Elektrotechnik  Preisliste 2024",null,null,null,null,null,null,null,"Rab. AT "]
[null,null,null,null,null,null,null,null,null,"Rab. Batt.",null,null,null,null,null,null,null,null,"Passwort"]
[null,null,null,null,null,null,null,null,null,null,null,"Preise 2024",null,null,null,null,null,null,2060]
[null,"Stück","Art.-Nr.  ","Type","Prim.","Sek. ","I Aus  |  I Puffer 2)","Kapazität ","Abmessungen","Gewicht","Gewicht","Preis/Stück ","Pos S €"]
[null,null,null,null,"V","V DC","A","Ah","H x B x T (mm)","kg"," S",null,"Netto"]
[null,null,null,"AKKUTEC 2403 VdS    8h, Abschaltung ","AC 115-230",24,3,"-","153x72x125",0.95,{"$f":"IF(ISNUMBER(B7),(B7*J7),\"\")","v":""},248.7,{"$f":"IF(ISNUMBER(B7),(ROUNDUP(B7*((1-$K$2)*L7),1)),\"\")","v":""},{"$f":"IF(AND(ISBLANK(B7),ISBLANK(B9)),\"Sie haben kein AKKUTEC ausgewählt\",\"\")","v":""}]
[]
[null,1,null,"AKKUTEC 2412 VdS  8h, Abschaltung ","AC 230  ",24,12,"-","155x95x183",1.56,{"$f":"IF(ISNUMBER(B9),(B9*J9),\"\")","v":1.56},467.8,{"$f":"IF(ISNUMBER(B9),(ROUNDUP(B9*((1-$K$2)*L9),1)),\"\")","v":467.8}]
[]
[null,1,"NCPA1301G10002","C-TEC 2425 P   bis 21,6 V Notpufferung","DC 24  ",24,25,"1,4 kJ","123 x 65 x 145",0.8,{"$f":"IF(ISNUMBER(B11),(B11*J11),\"\")","v":0.8},241.6,{"$f":"IF(ISNUMBER(B11),(ROUNDUP(B11*((1-$K$2)*L11),1)),\"\")","v":241.6}]
[]
[null,null,"NCPA1034G01003 1)","C-TEC 2440 P   bis 21,6 V Notpufferung ","DC 24  ",24,40,"4 kJ","188 x 84 x 194",2,{"$f":"IF(ISNUMBER(B13),(B13*J13),\"\")","v":""},484.1,{"$f":"IF(ISNUMBER(B13),(ROUNDUP(B13*((1-$K$2)*L13),1)),\"\")","v":""}]
[null,null,"1) nur mit IP 54 Gehäuse",null,null,null,"IPuffer 2)","2) Strom bei 8 h  Pufferzeit, inkl. 20 % Alterungsreserve der Batterie"]
[null,null,"452011.22","Batterie  12 Ah - 12 V",null,12,1.1000000000000001,12,"94x151x98",4.0999999999999996,{"$f":"IF(ISNUMBER(B15),(B15*J15),\"\")","v":""},43,{"$f":"IF(ISNUMBER(B15),(ROUNDUP(B15*((1-$K$3)*L15),1)),\"\")","v":""}]
[null,null,"452011.2","Batterie  17 Ah - 12 V",null,12,1.6,17,"167x76x181",6.1,{"$f":"IF(ISNUMBER(B16),(B16*J16),\"\")","v":""},65,{"$f":"IF(ISNUMBER(B16),(ROUNDUP(B16*((1-$K$3)*L16),1)),\"\")","v":""}]
[null,null,"452011.4","Batterie  24 Ah - 12 V",null,12,2.5,24,"125x175x166",8.9,{"$f":"IF(ISNUMBER(B17),(B17*J17),\"\")","v":""},89,{"$f":"IF(ISNUMBER(B17),(ROUNDUP(B17*((1-$K$3)*L17),1)),\"\")","v":""}]
[null,2,"452011.8","Batterie  40 Ah - 12 V",null,12,4.0999999999999996,40,"197x165x170",15.7,{"$f":"IF(ISNUMBER(B18),(B18*J18),\"\")","v":31.4},156,{"$f":"IF(ISNUMBER(B18),(ROUNDUP(B18*((1-$K$3)*L18),1)),\"\")","v":312}]
[null,null,"452011.9","Batterie  65 Ah - 12 V",null,12,6.7,65,"350x166x174",24,{"$f":"IF(ISNUMBER(B19),(B19*J19),\"\")","v":""},219,{"$f":"IF(ISNUMBER(B19),(ROUNDUP(B19*((1-$K$3)*L19),1)),\"\")","v":""}]
[]
[null,{"$f":"IF(OR(IF(ISBLANK(B7),0,1),IF(ISBLANK(B9),0,1)),SUM(B7,B9),\"\")","v":1},"MTIAQ33G3M01","Temperatursensor ","für AKKUTEC VdS",null,null,null,null,null,null,12.3,{"$f":"IF(ISNUMBER(B21),(ROUNDUP(B21*((1-$K$2)*L21),1)),\"\")","v":12.3}]
[]
[null,{"$f":"IF(OR(IF(ISBLANK(B7),0,1),IF(ISBLANK(B9),0,1)),SUM(B7,B9),\"\")","v":1},"NBP40848G01001","Fusebridge","mit Sicherungen 15A, 25A, 30A     (Kabelschuhe für M5 & M6 ) bis 65 Ah",null,null,null,null,null,null,15,{"$f":"IF(ISNUMBER(B23),(ROUNDUP(B23*((1-$K$2)*L23),1)),\"\")","v":15}]
[]
[null,{"$f":"IF(IF(ISBLANK(B7),0,1),B7,\"\")","v":""},null,"FB 2405-5 P      Sicherungsplatine","für FKS-Sicherungen mit max. 6,3 A, (5 x 1 A ) ",null,null,null,"110x58x100",0.23,{"$f":"IF(ISNUMBER(B25),(B25*J25),\"\")","v":""},79.5,{"$f":"IF(ISNUMBER(B25),(ROUNDUP(B25*((1-$K$2)*L25),1)),\"\")","v":""}]
[null,{"$f":"IF(IF(ISBLANK(B9),0,1),B9,\"\")","v":1},null,"FB 2410-10 P    Sicherungsplatine","für FKS-Sicherungen mit max. 15 A, ( 10 x 1 A) ",null,null,null,"110x84x100",0.2,{"$f":"IF(ISNUMBER(B26),(B26*J26),\"\")","v":0.2},92.7,{"$f":"IF(ISNUMBER(B26),(ROUNDUP(B26*((1-$K$2)*L26),1)),\"\")","v":92.7}]
[]
[null,null,"42118.1","Option:  \"ON\" Taster",null,null,null,null,null,null,null,53.1,{"$f":"IF(ISNUMBER(B28),(ROUNDUP(B28*((1-$K$2)*L28),1)),\"\")","v":""}]
[null,null,"PMDV1710G01001","Gateway  Ethernetanbindung für AKKUTEC",null,null,null,null,"99x45x114",0.2,null,305.7,{"$f":"IF(ISNUMBER(B29),(ROUNDUP(B29*((1-$K$2)*L29),1)),\"\")","v":""}]
[]
[null,null,{"$f":"IF(ISBLANK(B9),\"\",\"Nicht möglich!\")","v":"Nicht möglich!"},"Gehäuse  IP 31           bis 40Ah","für AkkuTEC 2403   und Akkus bis 24 Ah",null,null,null,"424x508x189",9,{"$f":"IF(ISNUMBER(B31),(B31*J31),\"\")","v":""},146.69999999999999,{"$f":"IF(ISNUMBER(B31),(ROUNDUP(B31*((1-$K$2)*L31),1)),\"\")","v":""},{"$f":"IF(OR(IF(ISBLANK(B18),0,1),IF(ISBLANK(B19),0,1)),\"Nicht möglich, da Gehäuse zu klein ist.\",\"\")","v":"Nicht möglich, da Gehäuse zu klein ist."}]
[null,1,{"$f":"IF(ISBLANK(B7),\"\",\"Nicht möglich!\")","v":""},"Gehäuse  IP 31           bis 80Ah","für AkkuTEC 2412   und Akkus bis 80 Ah",null,null,null,"608x464x213",11,{"$f":"IF(ISNUMBER(B32),(B32*J32),\"\")","v":11},210.9,{"$f":"IF(ISNUMBER(B32),(ROUNDUP(B32*((1-$K$2)*L32),1)),\"\")","v":210.9},{"$f":"IF(ISBLANK(B13),\"\",\"Nicht möglich da CT2440 zu groß ist!\")","v":""}]
[null,null,null,"Gehäuse  IP 54           bis 65Ah","für AkkuTEC 2412 VdS und Akkus bis 4x 120 Ah",null,null,null,"1000x800x300",23,{"$f":"IF(ISNUMBER(B33),(B33*J33),\"\")","v":""},568.6,{"$f":"IF(ISNUMBER(B33),(ROUNDUP(B33*((1-$K$2)*L33),1)),\"\")","v":""}]
[]
[null,"Irrtümer vorbehalten!",null,null,null,null,"2) Strom bei 8 h  Pufferzeit,",null,null,"Gewicht USV ca.",{"$f":"ROUNDUP(SUM(K7:K13)+SUM(K25:K33),0)","v":14},null,{"$f":"SUM(M7:M13)+SUM(M21:M33)","v":1040.3}]
[null,null,null,null,null,null,"    inkl. 20 % Alterungsreserve der Batterie",null,null,"Gewicht Batterie ca.",{"$f":"ROUNDUP(SUM(K15:K19),0)","v":32},null,{"$f":"SUM(M15:M19)","v":312}]
[]
[null,null,null,null,"Art. Nr.:",null,{"$f":"IF(AND(ISBLANK($B$31),ISBLANK($B$32),ISBLANK($B$33)),\"\",'Artikelnummer Logik'!$C$4)","v":"NKPG2108G01051"}]
[]
[null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B15),ISBLANK(B16),ISBLANK(B17),ISBLANK(B18),ISBLANK(B19)),\"\",IF(AND(ISBLANK(B31),ISBLANK(B32),ISBLANK(B33)),\"\",\"+\"))","v":"+"},{"$f":"IF(AND(ISBLANK(B15),ISBLANK(B16),ISBLANK(B17),ISBLANK(B18),ISBLANK(B19)),\"\",IF(AND(ISBLANK(B31),ISBLANK(B32),ISBLANK(B33)),\"\",'Artikelnummer Logik'!U38))","v":2},{"$f":"IF(AND(ISBLANK(B15),ISBLANK(B16),ISBLANK(B17),ISBLANK(B18),ISBLANK(B19)),\"\",IF(AND(ISBLANK(B31),ISBLANK(B32),ISBLANK(B33)),\"\",'Artikelnummer Logik'!Y38))","v":"452011.8"}]
[]
[]
[]
[null,null,"Sonderwunsch"]

{"sheet":"Auswahl Komponenten","index":1,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":true,"merged":[[28,4,28,10],[39,4,40,5],[39,6,40,7]]}
[null,"Konfiguration Gehäuse- / Hybrid USV "]
[null,"Auszug aus der  J. Schneider Elektrotechnik  Preisliste 2024",null,null,null,null,null,null,null,"Rab. AT "]
[null,null,null,null,null,null,null,null,null,"Rab. Batt."]
[null,null,null,null,null,null,null,null,null,null,null,"Preise 2024"]
[null,"Stück","Art.-Nr.  ","Type","Prim.","Sek. ","I Aus  |  I Puffer 2)","Kapazität ","Abmessungen","Gewicht","Gewicht","Preis/Stück ","Pos S €"]
[null,null,null,null,"V","V DC","A","Ah","H x B x T (mm)","kg"," S",null,"Netto"]
[null,null,"NBPA0844G01016","AKKUTEC 2403 VdS    8h, Abschaltung ","AC 115-230",24,3,"-","153x72x125",0.95,{"$f":"IF(ISNUMBER(B7),(B7*J7),\"\")","v":""},248.7,{"$f":"IF(ISNUMBER(B7),(ROUNDUP(B7*((1-$K$2)*L7),1)),\"\")","v":""}]
[]
[null,null,"NBPA0812G01019","AKKUTEC 2412 VdS  8h, Abschaltung ","AC 230  ",24,12,"-","155x95x183",1.56,{"$f":"IF(ISNUMBER(B9),(B9*J9),\"\")","v":""},467.8,{"$f":"IF(ISNUMBER(B9),(ROUNDUP(B9*((1-$K$2)*L9),1)),\"\")","v":""}]
[]
[null,null,"NCPA1301G10002","C-TEC 2425 P   bis 21,6 V Notpufferung","DC 24  ",24,25,"1,4 kJ","123 x 65 x 145",0.8,{"$f":"IF(ISNUMBER(B11),(B11*J11),\"\")","v":""},241.6,{"$f":"IF(ISNUMBER(B11),(ROUNDUP(B11*((1-$K$2)*L11),1)),\"\")","v":""}]
[]
[null,null,"NCPA1034G01003 1)","C-TEC 2440 P   bis 21,6 V Notpufferung ","DC 24  ",24,40,"4 kJ","188 x 84 x 194",2,{"$f":"IF(ISNUMBER(B13),(B13*J13),\"\")","v":""},484.1,{"$f":"IF(ISNUMBER(B13),(ROUNDUP(B13*((1-$K$2)*L13),1)),\"\")","v":""}]
[null,null,"1) nur mit IP 54 Gehäuse",null,null,null,"IPuffer 2)","2) Strom bei 8 h  Pufferzeit, inkl. 20 % Alterungsreserve der Batterie"]
[null,null,"452011.22","Batterie  12 Ah - 12 V",null,12,1.1000000000000001,12,"94x151x98",4.0999999999999996,{"$f":"IF(ISNUMBER(B15),(B15*J15),\"\")","v":""},43,{"$f":"IF(ISNUMBER(B15),(ROUNDUP(B15*((1-$K$3)*L15),1)),\"\")","v":""}]
[null,null,"452011.2","Batterie  17 Ah - 12 V",null,12,1.6,17,"167x76x181",6.1,{"$f":"IF(ISNUMBER(B16),(B16*J16),\"\")","v":""},65,{"$f":"IF(ISNUMBER(B16),(ROUNDUP(B16*((1-$K$3)*L16),1)),\"\")","v":""}]
[null,null,"452011.4","Batterie  24 Ah - 12 V",null,12,2.5,24,"125x175x166",8.9,{"$f":"IF(ISNUMBER(B17),(B17*J17),\"\")","v":""},89,{"$f":"IF(ISNUMBER(B17),(ROUNDUP(B17*((1-$K$3)*L17),1)),\"\")","v":""}]
[null,null,"452011.8","Batterie  40 Ah - 12 V",null,12,4.0999999999999996,40,"197x165x170",15.7,{"$f":"IF(ISNUMBER(B18),(B18*J18),\"\")","v":""},156,{"$f":"IF(ISNUMBER(B18),(ROUNDUP(B18*((1-$K$3)*L18),1)),\"\")","v":""}]
[null,null,"452011.9","Batterie  65 Ah - 12 V",null,12,6.7,65,"350x166x174",24,{"$f":"IF(ISNUMBER(B19),(B19*J19),\"\")","v":""},219,{"$f":"IF(ISNUMBER(B19),(ROUNDUP(B19*((1-$K$3)*L19),1)),\"\")","v":""}]
[]
[null,null,"NBBHL33G1M02","NBBH 2412   Batteriemodul 24V 12 Ah","inkl. Sicherung",24,1.1000000000000001,12,"115x241x159",9.4,{"$f":"IF(ISNUMBER(B21),(B21*J21),\"\")","v":""},153,{"$f":"IF(ISNUMBER(B21),(ROUNDUP(B21*((1-$K$3)*L21),1)),\"\")","v":""}]
[null,null,"NBBH0336G01001","NBBH 2417   Batteriemodul 24V 17 Ah","*Fusebridge",24,1.6,17,"170x155x182",18,{"$f":"IF(ISNUMBER(B22),(B22*J22),\"\")","v":""},183,{"$f":"IF(ISNUMBER(B22),(ROUNDUP(B22*((1-$K$3)*L22),1)),\"\")","v":""}]
[null,null,"NBBH0336G01002","NBBH 2424   Batteriemodul 24V 24 Ah","*Fusebridge",24,2.5,24,"137x335x200",20,{"$f":"IF(ISNUMBER(B23),(B23*J23),\"\")","v":""},228,{"$f":"IF(ISNUMBER(B23),(ROUNDUP(B23*((1-$K$3)*L23),1)),\"\")","v":""}]
[null,null,"NBBH0336G01003","NBBH 2440   Batteriemodul 24V 40 Ah","*Fusebridge",24,4.0999999999999996,40,"170x335x200",33,{"$f":"IF(ISNUMBER(B24),(B24*J24),\"\")","v":""},360,{"$f":"IF(ISNUMBER(B24),(ROUNDUP(B24*((1-$K$3)*L24),1)),\"\")","v":""}]
[null,null,"NBBH0336G01004","NBBH 2465   Batteriemodul 24V 65 Ah","*Fusebridge",24,6.7,65,"2x(170x397x200)",56,{"$f":"IF(ISNUMBER(B25),(B25*J25),\"\")","v":""},459,{"$f":"IF(ISNUMBER(B25),(ROUNDUP(B25*((1-$K$3)*L25),1)),\"\")","v":""}]
[]
[null,null,"MTIAQ33G3M01","Temperatursensor ","für AKKUTEC VdS",null,null,null,null,null,null,12.3,{"$f":"IF(ISNUMBER(B27),(ROUNDUP(B27*((1-$K$2)*L27),1)),\"\")","v":""}]
[]
[null,null,"NBP40848G01003","Fusebridge","mit Sicherungen 15A, 25A, 30A     (Kabelschuhe für M5 & M6 ) bis 65 Ah",null,null,null,null,null,null,15,{"$f":"IF(ISNUMBER(B29),(ROUNDUP(B29*((1-$K$2)*L29),1)),\"\")","v":""}]
[]
[null,null,"NBP20902G02004 ","FB 2405-5 P      Sicherungsplatine","für FKS-Sicherungen mit max. 6,3 A, (5 x 1 A ) ",null,null,null,"110x120x68",0.23,{"$f":"IF(ISNUMBER(B31),(B31*J31),\"\")","v":""},79.5,{"$f":"IF(ISNUMBER(B31),(ROUNDUP(B31*((1-$K$2)*L31),1)),\"\")","v":""}]
[null,null,"NBP20901G02003 ","FB 2410-10 P    Sicherungsplatine","für FKS-Sicherungen mit max. 15 A, ( 10 x 1 A) ",null,null,null,"110x120x68",0.2,{"$f":"IF(ISNUMBER(B32),(B32*J32),\"\")","v":""},92.7,{"$f":"IF(ISNUMBER(B32),(ROUNDUP(B32*((1-$K$2)*L32),1)),\"\")","v":""}]
[]
[null,null,null,"Option:  \"ON\" Taster",null,null,null,null,null,null,null,53.1,{"$f":"IF(ISNUMBER(B34),(ROUNDUP(B34*((1-$K$2)*L34),1)),\"\")","v":""}]
[null,null,"PMDV1710G01001","Gateway  Ethernetanbindung für AKKUTEC",null,null,null,null,"99x45x114",0.2,null,305.7,{"$f":"IF(ISNUMBER(B35),(ROUNDUP(B35*((1-$K$2)*L35),1)),\"\")","v":""}]
[]
[null,"Irrtümer vorbehalten!",null,null,null,null,"2) Strom bei 8 h  Pufferzeit,",null,null,"Gewicht   ca.  ",{"$f":"ROUNDUP(SUM(K7:K35),0)","v":0},null,{"$f":"SUM(M7:M35)","v":0}]
[null,null,null,null,null,null,"    inkl. 20 % Alterungsreserve der Batterie"]

{"sheet":"Artikelnummer Logik","index":2,"n_rows":46,"n_cols":33,"rows_kept":46,"cut":false,"hidden":true,"merged":[[1,8,1,13],[37,1,37,2]]}
[null,null,"Hybrid-USV im Gehäuse,  Artikel-Nummern"]
[null,null,"USV im Gehäuse immer mit Temperatursensor und Fusebridge ( + 12,- € + 15,- € )",null,null,null,null,null,"1 - 6 ",null,null,null,null,null,7,8,null,10,11,12,13,14]
[]
[null,null,{"$f":"I6&J6&K6&L6&M6&N6&O6&P6&Q6&R6&S6&T6&U6&V6","v":"NKPG2108G01051"},null,null,null,null,"Beispiel : ","N","K","P","G",2,1,0,8,"G",0,1,0,5,4]
[]
[null,null,null,null,null,null,null,null,"N",{"$f":"J8","v":"K"},"P","G",{"$f":"SUM(M10:M31)","v":2},{"$f":"SUM(N10:N31)","v":1},{"$f":"SUM(O10:O31)","v":0},{"$f":"SUM(P10:P31)","v":8},"G",{"$f":"SUM(R29:R31)","v":0},{"$f":"SUM(S29:S31)","v":1},{"$f":"SUM(T20:T22)","v":0},{"$f":"SUM(U20:U22)","v":5},{"$f":"SUM(V24:V27)","v":1}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(IF(B10=\"x\",0,1),IF(B11=\"x\",0,1),IF(B12=\"x\",0,1),IF(B13=\"x\",0,1)),\"K\",\"B\")","v":"K"}]
[null,"Auswahl","  Leistung / Kombination"]
[null,{"$f":"IF(AND(IF(ISBLANK('Auswahl in Gehäuse'!B7),0,1),IF(ISBLANK('Auswahl in Gehäuse'!$B$11),1,0),IF(ISBLANK('Auswahl in Gehäuse'!$B$13),1,0),IF(ISBLANK('Auswahl in Gehäuse'!$B$31),0,1)),\"x\",\"\")","v":""},"B:    AKKUTEC 2403 VdS 8h      IP31",4,4,0,8,null,null,{"$f":"IF(ISBLANK($J$8),\"\",$J$8)","v":"K"},null,null,{"$f":"IF($B10=\"x\",F10,\"\")","v":""},"",{"$f":"IF($B10=\"x\",D10,\"\")","v":""},""]
[null,{"$f":"IF(AND(IF(ISBLANK('Auswahl in Gehäuse'!B9),0,1),IF(ISBLANK('Auswahl in Gehäuse'!$B$11),1,0),IF(ISBLANK('Auswahl in Gehäuse'!$B$13),1,0),IF(ISBLANK('Auswahl in Gehäuse'!$B$32),0,1)),\"x\",\"\")","v":""},"B:    AKKUTEC 2412 VdS 8h      IP31",1,2,0,8,null,null,{"$f":"IF(ISBLANK($J$8),\"\",$J$8)","v":"K"},null,null,"","","",""]
[null,{"$f":"IF(AND(IF(ISBLANK('Auswahl in Gehäuse'!B7),0,1),IF(ISBLANK('Auswahl in Gehäuse'!$B$11),1,0),IF(ISBLANK('Auswahl in Gehäuse'!$B$13),1,0),IF(ISBLANK('Auswahl in Gehäuse'!$B$33),0,1)),\"x\",\"\")","v":""},"B:    AKKUTEC 2403 VdS 8h      IP54",0,3,0,9,null,null,{"$f":"IF(ISBLANK($J$8),\"\",$J$8)","v":"K"},null,null,"","","",""]
[null,{"$f":"IF(AND(IF(ISBLANK('Auswahl in Gehäuse'!B9),0,1),IF(ISBLANK('Auswahl in Gehäuse'!$B$11),1,0),IF(ISBLANK('Auswahl in Gehäuse'!$B$13),1,0),IF(ISBLANK('Auswahl in Gehäuse'!$B$33),0,1)),\"x\",\"\")","v":""},"B:    AKKUTEC 2412 VdS 8h      IP54",0,1,0,9,null,null,{"$f":"IF(ISBLANK($J$8),\"\",$J$8)","v":"K"},null,null,"","","",""]
[]
[null,{"$f":"IF(AND(IF(ISBLANK('Auswahl in Gehäuse'!B7),0,1),IF(ISBLANK('Auswahl in Gehäuse'!B11),0,1)),\"x\",\"\")","v":""}," 07 : AKKUTEC 2403 VdS + C-TEC 2425 P",0,7,2,1,null,null,{"$f":"IF(ISBLANK($J$8),\"\",$J$8)","v":"K"},null,null,{"$f":"IF($B15=\"x\",F15,\"\")","v":""},"",{"$f":"IF($B15=\"x\",D15,\"\")","v":""},""]
[null,{"$f":"IF(AND(IF(ISBLANK('Auswahl in Gehäuse'!B9),0,1),IF(ISBLANK('Auswahl in Gehäuse'!B11),0,1)),\"x\",\"\")","v":"x"}," 08 : AKKUTEC 2412 VdS + C-TEC 2425 P",0,8,2,1,null,null,{"$f":"IF(ISBLANK($J$8),\"\",$J$8)","v":"K"},null,null,2,1,0,8]
[null,{"$f":"IF(AND(IF(ISBLANK('Auswahl in Gehäuse'!B7),0,1),IF(ISBLANK('Auswahl in Gehäuse'!B13),0,1)),\"x\",\"\")","v":""}," 09 : AKKUTEC 2403 VdS + C-TEC 2440 P",0,9,2,1,null,null,{"$f":"IF(ISBLANK($J$8),\"\",$J$8)","v":"K"},null,null,"","","",""]
[null,{"$f":"IF(AND(IF(ISBLANK('Auswahl in Gehäuse'!B9),0,1),IF(ISBLANK('Auswahl in Gehäuse'!B13),0,1)),\"x\",\"\")","v":""},"w",1,0,2,1,null,null,{"$f":"IF(ISBLANK($J$8),\"\",$J$8)","v":"K"},null,null,"","","",""]
[null,null,"   8 h / 21,6 V   un Si Platine"]
[null,{"$f":"IF(AND(ISBLANK('Auswahl in Gehäuse'!B25),ISBLANK('Auswahl in Gehäuse'!B26)),\"x\",\"\")","v":""},"  03 : keine Sicherungsplatine, nach 8 h Lastabwurf",0,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B20=\"x\",D20,\"\")","v":""},""]
[null,{"$f":"IF(OR(B15=\"x\",B17=\"x\",B10=\"x\",B12=\"x\"),\"x\",\"\")","v":""},"  04 : FB2405-5 (P) Sicherungsplatine, nach 8 h Lastabwurf",0,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,{"$f":"IF(OR(B16=\"x\",B18=\"x\",B11=\"x\",B13=\"x\"),\"x\",\"\")","v":"x"},"  05 : FB24105-10 P Sicherungsplatine, nach 8 h Lastabwurf",0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,5]
[null,null,"   Optionen:"]
[null,{"$f":"IF(AND(ISBLANK('Auswahl in Gehäuse'!B28),ISBLANK('Auswahl in Gehäuse'!B29)),\"x\",\"\")","v":"x"},"  1 :  keine",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B24=\"x\",D24,\"\")","v":1}]
[null,{"$f":"IF(AND(ISBLANK('Auswahl in Gehäuse'!B29),IF(ISBLANK('Auswahl in Gehäuse'!B28),0,1)),\"x\",\"\")","v":""},"  2 :  ON - Taster",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B25=\"x\",D25,\"\")","v":""}]
[null,{"$f":"IF(AND(ISBLANK('Auswahl in Gehäuse'!B28),IF(ISBLANK('Auswahl in Gehäuse'!B29),0,1)),\"x\",\"\")","v":""},"  3 :  Gateway",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B26=\"x\",D26,\"\")","v":""}]
[null,{"$f":"IF(AND(IF(ISBLANK('Auswahl in Gehäuse'!B28),0,1),IF(ISBLANK('Auswahl in Gehäuse'!B29),0,1)),\"x\",\"\")","v":""},"  4 :  ON-Taster + Gateway",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B27=\"x\",D27,\"\")","v":""}]
[null,null,"   Gehäuse :"]
[null,{"$f":"IF(ISBLANK('Auswahl in Gehäuse'!B31),\"\",\"x\")","v":""},"   00 :  IP 31 -> klein 424x508x189 mm,  bis 40 Ah",0,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B29=\"x\",D29,\"\")","v":""},""]
[null,{"$f":"IF(ISBLANK('Auswahl in Gehäuse'!B32),\"\",\"x\")","v":"x"},"   01 :   IP 31 -> 608x464x213 mm,  bis 65 Ah",0,1,null,null,null,null,null,null,null,null,null,null,null,null,0,1]
[null,{"$f":"IF(IF(ISBLANK('Auswahl in Gehäuse'!B33),1,0),\"\",\"x\")","v":""},"   02:    IP 54  -> 1000x800x300 mm, bis 170 Ah",0,{"$f":"IF(B34=\"x\",2,IF(B34=\"\",1,\"\"))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,{"$f":"IF(OR(AND(B31=\"x\",B18=\"x\"),AND(B31=\"x\",B17=\"x\"),AND(B31=\"x\",B12),AND(B31=\"x\",B13=\"x\")),1,\"2\")","v":"2"}]
[]
[]
[null,{"$f":"IF(OR(AND(B31=\"x\",B16=\"x\"),AND(B31=\"x\",B15=\"x\")),\"x\",\"\")","v":""}]
[]
[]
[]
[null,"Batterieauswahl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('Auswahl in Gehäuse'!B15:B19)","v":2},null,"x",null,{"$f":"CONCATENATE(X46,Y46,Z46,AA46,AB46,AC46,AD46,AE46,AF46)","v":"452011.8"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(U38,V38,W38,X38,Y38)","v":"2x452011.8"}]
[]
[null,{"$f":"IF(ISBLANK('Auswahl in Gehäuse'!B15),\"\",\"x\")","v":""},"Batterie  12 Ah - 12 V",null,null,null,null,"452011.22",null,null,null,null,null,4,5,2,0,1,1,".",2,2,null,{"$f":"IF($B40=\"x\", N40,\"\")","v":""},{"$f":"IF($B40=\"x\", O40,\"\")","v":""},"","","","","","",""]
[null,{"$f":"IF(ISBLANK('Auswahl in Gehäuse'!B16),\"\",\"x\")","v":""},"Batterie  17 Ah - 12 V",null,null,null,null,"452011.2",null,null,null,null,null,4,5,2,0,1,1,".",2,null,null,{"$f":"IF($B41=\"x\", N41,\"\")","v":""},{"$f":"IF($B41=\"x\", O41,\"\")","v":""},"","","","","",""]
[null,{"$f":"IF(ISBLANK('Auswahl in Gehäuse'!B17),\"\",\"x\")","v":""},"Batterie  24 Ah - 12 V",null,null,null,null,"452011.4",null,null,null,null,null,4,5,2,0,1,1,".",4,null,null,{"$f":"IF($B42=\"x\", N42,\"\")","v":""},"","","","","","",""]
[null,{"$f":"IF(ISBLANK('Auswahl in Gehäuse'!B18),\"\",\"x\")","v":"x"},"Batterie  40 Ah - 12 V",null,null,null,null,"452011.8",null,null,null,null,null,4,5,2,0,1,1,".",8,null,null,{"$f":"IF($B43=\"x\", N43,\"\")","v":4},5,2,0,1,1,".",8]
[null,{"$f":"IF(ISBLANK('Auswahl in Gehäuse'!B19),\"\",\"x\")","v":""},"Batterie  65 Ah - 12 V",null,null,null,null,"452011.9",null,null,null,null,null,4,5,2,0,1,1,".",9,null,null,{"$f":"IF($B44=\"x\", N44,\"\")","v":""},"","","","","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X40:X44)","v":4},{"$f":"SUM(Y40:Y44)","v":5},2,0,1,1,".",8,{"$f":"IF(B40 = \"x\", \"2\", \"\")","v":""}]

{"sheet":"Konfiguration in Gehäuse","index":3,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[[37,13,37,14],[37,5,37,12],[21,6,21,7],[28,8,28,9],[32,6,32,9],[33,6,33,9],[35,6,35,9],[34,6,34,9]]}
[null,null,null,"Konfiguration Gehäuse- / Hybrid USV "]
[null,null,null,"Auszug aus der  J. Schneider Elektrotechnik  Preisliste 2025"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Preise 2025"]
[null,null,null,"Stück","Art.-Nr.  ","Type","Prim.","Sek. ","I Aus  |  I Puffer 2)","Kapazität ","Abmessungen","Gewicht","Gewicht","Preis/Stück ","Pos S €"]
[null,null,null,null,null,null,"V","V DC","A","Ah","H x B x T (mm)","kg"," S",null,"Netto"]
[null,null,null,null,null,"AKKUTEC 2403 VdS  8h, Abschaltung ","AC 115-230",24,3,"-","153x72x125",0.95,{"$f":"IF(ISNUMBER(D7),(D7*L7),\"\")","v":""},248.7,{"$f":"IF(ISNUMBER(D7),(ROUNDUP(D7*((1-$M$2)*N7),1)),\"\")","v":""}]
[null,null,null,null,null,"AKKUTEC 2412 VdS  8h, Abschaltung ","AC 230  ",24,12,"-","155x95x183",1.56,{"$f":"IF(ISNUMBER(D8),(D8*L8),\"\")","v":""},467.8,{"$f":"IF(ISNUMBER(D8),(ROUNDUP(D8*((1-$M$2)*N8),1)),\"\")","v":""}]
[]
[null,null,null,null,null,"Isolationsüberwachung ( x=Ja)"]
[]
[null,null,null,null,"NCPA1301G10002","C-TEC 2425 P   bis 21,6 V Notpufferung","DC 24  ",24,25,"1,4 kJ","123 x 65 x 145",0.8,{"$f":"IF(ISNUMBER(D12),(D12*L12),\"\")","v":""},241.6,{"$f":"IF(ISNUMBER(D12),(ROUNDUP(D12*((1-$M$2)*N12),1)),\"\")","v":""}]
[null,null,null,null,"NCPA1034G01003 1)","C-TEC 2440 P   bis 21,6 V Notpufferung ","DC 24  ",24,40,"4 kJ","188 x 84 x 194",2,{"$f":"IF(ISNUMBER(D13),(D13*L13),\"\")","v":""},484.1,{"$f":"IF(ISNUMBER(D13),(ROUNDUP(D13*((1-$M$2)*N13),1)),\"\")","v":""}]
[null,null,null,null,"1) nur mit IP 54 Gehäuse",null,null,null,"IPuffer 2)","2) Strom bei 8 h  Pufferzeit, inkl. 20 % Alterungsreserve der Batterie"]
[]
[null,null,null,null,"452011.22","Batterie  12 Ah - 12 V",null,12,1.1000000000000001,12,"94x151x98",4.0999999999999996,{"$f":"IF(ISNUMBER(D16),(D16*L16),\"\")","v":""},43,{"$f":"IF(ISNUMBER(D16),(ROUNDUP(D16*((1-$M$3)*N16),1)),\"\")","v":""}]
[null,null,null,null,"452011.2","Batterie  17 Ah - 12 V",null,12,1.6,17,"167x76x181",6.1,{"$f":"IF(ISNUMBER(D17),(D17*L17),\"\")","v":""},65,{"$f":"IF(ISNUMBER(D17),(ROUNDUP(D17*((1-$M$3)*N17),1)),\"\")","v":""}]
[null,null,null,null,"452011.4","Batterie  24 Ah - 12 V",null,12,2.5,24,"125x175x166",8.9,{"$f":"IF(ISNUMBER(D18),(D18*L18),\"\")","v":""},89,{"$f":"IF(ISNUMBER(D18),(ROUNDUP(D18*((1-$M$3)*N18),1)),\"\")","v":""}]
[null,null,null,null,"452011.8","Batterie  40 Ah - 12 V",null,12,4.0999999999999996,40,"197x165x170",15.7,{"$f":"IF(ISNUMBER(D19),(D19*L19),\"\")","v":""},156,{"$f":"IF(ISNUMBER(D19),(ROUNDUP(D19*((1-$M$3)*N19),1)),\"\")","v":""}]
[null,null,null,null,"452011.9","Batterie  65 Ah - 12 V",null,12,6.7,65,"350x166x174",24,{"$f":"IF(ISNUMBER(D20),(D20*L20),\"\")","v":""},219,{"$f":"IF(ISNUMBER(D20),(ROUNDUP(D20*((1-$M$3)*N20),1)),\"\")","v":""}]
[]
[null,null,null,{"$f":"IF(OR(IF(ISBLANK(D7),0,1),IF(ISBLANK(D8),0,1)),SUM(D7,D8),\"\")","v":""},"MTIAQ33G3M01","Temperatursensor ","für AKKUTEC VdS",null,null,null,null,null,null,12.3,{"$f":"IF(ISNUMBER(D22),(ROUNDUP(D22*((1-$M$2)*N22),1)),\"\")","v":""}]
[]
[null,null,null,null,"NBP40848G01001","Fusebridge","mit Sicherungen 15A, 25A, 30A     (Kabelschuhe für M5 & M6 ) bis 65 Ah",null,null,null,null,null,null,15,{"$f":"IF(ISNUMBER(D24),(ROUNDUP(D24*((1-$M$2)*N24),1)),\"\")","v":""}]
[]
[null,null,null,null,null,"FB 2405-5 P      Sicherungsplatine","für FKS-Sicherungen mit max. 6,3 A, (5 x 1 A ) ",null,null,null,"110x58x100",0.23,{"$f":"IF(ISNUMBER(D26),(D26*L26),\"\")","v":""},79.5,{"$f":"IF(ISNUMBER(D26),(ROUNDUP(D26*((1-$M$2)*N26),1)),\"\")","v":""}]
[null,null,null,null,null,"FB 2410-10 P    Sicherungsplatine","für FKS-Sicherungen mit max. 15 A, ( 10 x 1 A) ",null,null,null,"110x84x100",0.2,{"$f":"IF(ISNUMBER(D27),(D27*L27),\"\")","v":""},92.7,{"$f":"IF(ISNUMBER(D27),(ROUNDUP(D27*((1-$M$2)*N27),1)),\"\")","v":""}]
[]
[null,null,null,null,null,"DC-DC Wandler 24V-12V","24V DC","12V DC",null,null,"134x58x147",0.6,null,null,{"$f":"IF(ISNUMBER(D29),(ROUNDUP(D29*((1-$M$2)*N29),1)),\"\")","v":""}]
[]
[null,null,null,null,"PMDV1710G01001","Gateway  Ethernetanbindung für AKKUTEC",null,null,null,null,"99x45x114",0.2,null,305.7,{"$f":"IF(ISNUMBER(D31),(ROUNDUP(D31*((1-$M$2)*N31),1)),\"\")","v":""}]
[]
[null,null,null,null,{"$f":"IF(ISBLANK(D8),\"\",\"Nicht möglich!\")","v":""},"Gehäuse  IP 31           bis 40Ah","für AkkuTEC 2403   und Akkus bis 24 Ah",null,null,null,"424x508x189",9,{"$f":"IF(ISNUMBER(D33),(D33*L33),\"\")","v":""},146.69999999999999,{"$f":"IF(ISNUMBER(D33),(ROUNDUP(D33*((1-$M$2)*N33),1)),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK(D7),\"\",\"Nicht möglich!\")","v":""},"Gehäuse  IP 31           bis 80Ah","für AkkuTEC 2412   und Akkus bis 80 Ah",null,null,null,"608x464x213",11,{"$f":"IF(ISNUMBER(D34),(D34*L34),\"\")","v":""},210.9,{"$f":"IF(ISNUMBER(D34),(ROUNDUP(D34*((1-$M$2)*N34),1)),\"\")","v":""}]
[null,null,null,null,null,"Gehäuse  IP 54           bis 40Ah","für AkkuTEC 2403 VdS und Akkus bis 40Ah",null,null,null,"500x500x300",19]
[null,null,null,null,null,"Gehäuse  IP 54           bis 65Ah","für AkkuTEC 2412 VdS und Akkus bis 4x 120 Ah",null,null,null,"1000x800x300",23,{"$f":"IF(ISNUMBER(D36),(D36*L36),\"\")","v":""},568.6,{"$f":"IF(ISNUMBER(D36),(ROUNDUP(D36*((1-$M$2)*N36),1)),\"\")","v":""}]
[]
[null,null,null,null,"Sonderwunsch:",null,null,null,null,null,null,null,null,"auf Anfrage"]
[null,null,null,"Irrtümer vorbehalten!",null,null,null,null,"2) Strom bei 8 h  Pufferzeit,",null,"Gewicht USV ca.",{"$f":"ROUNDUP(SUM(M7:M13)+SUM(M26:M36),0)","v":0},null,null,{"$f":"SUM(O7:O13)+SUM(O22:O36)","v":0}]
[null,null,null,null,null,null,null,null,"    inkl. 20 % Alterungsreserve der Batterie",null,"Gewicht Batterie",{"$f":"SUM(M16:M20)","v":0},null,null,{"$f":"SUM(O16:O20)","v":0}]
[]
[null,null,null,null,null,null,"Artikelnummer:",null,{"$f":"IF(AND(D33=\"\",D34=\"\",D36=\"\"),\"\",'Artikelnummer Logik 2025'!D5)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(D16<>\"\",D17<>\"\",D18<>\"\",D19<>\"\",D20<>\"\"),\"+\",\"\")","v":""},{"$f":"IF(OR(D16<>\"\",D17<>\"\",D18<>\"\",D19<>\"\",D20<>\"\"),'Artikelnummer Logik 2025'!V43,\"\")","v":""},{"$f":"IF(OR(D16<>\"\",D17<>\"\",D18<>\"\",D19<>\"\",D20<>\"\"),'Artikelnummer Logik 2025'!Z43,\"\")","v":""}]

{"sheet":"Foto","index":4,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Beispiel  Hybrid-USV im Gehäuse  IP 31,   mit Batterien und Ultracaps-Energiespeicher  "]

{"sheet":"Aufbau","index":5,"n_rows":37,"n_cols":26,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Schematischer Aufbau   DC-USV Hybrid  für Batterien und Ultracaps        UIN = 230 V AC    UOUT = 24 V DC "]
[]
[]
[]
[]
[]
[]
[null,null,null,"L  ",null,null,null," +",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"      +"]
[]
[null,null,null,"N  ",null,null,null," -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"      -"]
[]
[null,null,null,"     PE"]
[null,null,null,null,null,null,null," +"]
[]
[null,null,null,null,null,null,null,"  -"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Irrtümer vorbehalten!"]

{"sheet":"Auswahldiagramm","index":6,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":true,"merged":[[11,2,18,2],[3,2,10,2],[3,3,10,3],[1,7,2,7],[3,7,6,7],[3,6,6,6],[1,5,2,5],[1,6,2,6],[3,5,10,5],[1,2,2,2],[1,3,2,3],[1,4,2,4],[23,2,26,2],[19,3,22,3],[19,4,22,4],[11,7,14,7],[11,8,18,8],[11,5,18,5],[11,6,14,6],[19,5,22,5],[23,6,26,6],[23,7,26,7],[23,8,26,8],[15,6,18,6],[15,7,18,7],[19,6,22,6],[19,7,22,7],[19,2,22,2],[1,9,2,9],[19,8,22,8],[23,3,26,3],[23,4,26,4],[23,5,26,5],[7,6,10,6],[7,7,10,7],[3,8,10,8],[1,8,2,8],[11,3,18,3],[11,4,18,4],[3,4,10,4],[29,2,32,2],[29,3,32,3],[29,4,32,4],[29,5,32,5],[29,6,32,6],[33,2,36,2],[33,3,36,3],[33,4,36,4],[33,5,36,5],[33,6,36,6],[29,7,32,7],[29,8,32,8],[33,8,36,8],[37,7,40,7],[37,8,40,8],[33,7,36,7],[41,8,44,8],[37,2,40,2],[41,2,44,2],[41,3,44,3],[41,4,44,4],[41,5,44,5],[41,6,44,6],[41,7,44,7],[37,3,40,3],[37,4,40,4],[37,5,40,5],[37,6,40,6]]}
[]
[null,null,"Bezeichnung","AKKUTEC /            C-TEC","Abschal-tung","Sicherungs-     platine   ","Schrank variante","Artikelnummer","On-Taster / Gateway","Art. Nr."]
[]
[null,null,"NKPG 2403-25","AKKUTEC 2403 VdS      C-TEC 2425 P","Nach 8h / Lastabwurf 21,6 V DC","FB 2405-5 P","IP31","NKPG2107G0004*","1: -                   2: On-Taster 3: Gateway         4: On-Taster + Gateway","NKPG2107G01041"]
[null,null,null,null,null,null,null,null,null,"NKPG2107G01042"]
[null,null,null,null,null,null,null,null,null,"NKPG2107G01043"]
[null,null,null,null,null,null,null,null,null,"NKPG2107G01044"]
[null,null,null,null,null,null,"IP54","NKPG2107G0204*",null,"NKPG2107G02041"]
[null,null,null,null,null,null,null,null,null,"NKPG2107G02042"]
[null,null,null,null,null,null,null,null,null,"NKPG2107G02043"]
[null,null,null,null,null,null,null,null,null,"NKPG2107G02044"]
[null,null,"NKPG 2412-25","AKKUTEC 2412 VdS      C-TEC 2425 P","Nach 8h / Lastabwurf 21,6 V DC","FB 2410-10 P","IP31","NKPG2108G0105*","1: -                   2: On-Taster 3: Gateway         4: On-Taster + Gateway","NKPG2108G01051"]
[null,null,null,null,null,null,null,null,null,"NKPG2108G01052"]
[null,null,null,null,null,null,null,null,null,"NKPG2108G01053"]
[null,null,null,null,null,null,null,null,null,"NKPG2108G01054"]
[null,null,null,null,null,null,"IP54","NKPG2108G0205*",null,"NKPG2108G02051"]
[null,null,null,null,null,null,null,null,null,"NKPG2108G02052"]
[null,null,null,null,null,null,null,null,null,"NKPG2108G02053"]
[null,null,null,null,null,null,null,null,null,"NKPG2108G02054"]
[null,null,"NKPG 2403-40","AKKUTEC 2403 VdS     C-TEC 2440 P","Nach 8h / Lastabwurf 21,6 V DC","FB 2405-5 P","IP54","NKPG2109G0104*","1: -                   2: On-Taster 3: Gateway         4: On-Taster + Gateway","NKPG2109G01041"]
[null,null,null,null,null,null,null,null,null,"NKPG2109G01042"]
[null,null,null,null,null,null,null,null,null,"NKPG2109G01043"]
[null,null,null,null,null,null,null,null,null,"NKPG2109G01044"]
[null,null,"NKPG 2412-40","AKKUTEC 2412 VdS     C-TEC 2440 P","Nach 8h / Lastabwurf 21,6 V DC","FB2410-10 P","IP54","NKPG2110G0105*","1: -                   2: On-Taster 3: Gateway         4: On-Taster + Gateway","NKPG2110G01051"]
[null,null,null,null,null,null,null,null,null,"NKPG2110G01052"]
[null,null,null,null,null,null,null,null,null,"NKPG2110G01053"]
[null,null,null,null,null,null,null,null,null,"NKPG2110G01054"]
[]
[]
[null,null,"NBPG 2403C 8h","AKKUTEC 2403 VdS 8h","Nach 8h / Lastabwurf 21,6 V DC","FB 2405-5 P","IP31","NBPG0844G0104*","1: -                   2: On-Taster 3: Gateway         4: On-Taster + Gateway","NBPG0844G01041"]
[null,null,null,null,null,null,null,null,null,"NBPG0844G01042"]
[null,null,null,null,null,null,null,null,null,"NBPG0844G01043"]
[null,null,null,null,null,null,null,null,null,"NBPG0844G01044"]
[null,null,"NBPG 2412C 8h","AKKUTEC 2412 VdS 8h","Nach 8h / Lastabwurf 21,6 V DC","FB2410-10 P","IP31","NBPG0812G0105*","1: -                   2: On-Taster 3: Gateway         4: On-Taster + Gateway","NBPG0812G01051"]
[null,null,null,null,null,null,null,null,null,"NBPG0812G01052"]
[null,null,null,null,null,null,null,null,null,"NBPG0812G01053"]
[null,null,null,null,null,null,null,null,null,"NBPG0812G01054"]
[null,null,"NBPG 2403C 8h","AKKUTEC 2403 VdS 8h","Nach 8h / Lastabwurf 21,6 V DC","FB 2405-5 P","IP54","NBPG0903G0104*","1: -                   2: On-Taster 3: Gateway         4: On-Taster + Gateway","NBPG0903G01041"]
[null,null,null,null,null,null,null,null,null,"NBPG0903G01042"]
[null,null,null,null,null,null,null,null,null,"NBPG0903G01043"]
[null,null,null,null,null,null,null,null,null,"NBPG0903G01044"]
[null,null,"NBPG 2412C 8h","AKKUTEC 2412 VdS 8h","Nach 8h / Lastabwurf 21,6 V DC","FB2410-10 P","IP54","NBPG0901G0205*","1: -                   2: On-Taster 3: Gateway         4: On-Taster + Gateway","NBPG0901G01051"]
[null,null,null,null,null,null,null,null,null,"NBPG0901G01052"]
[null,null,null,null,null,null,null,null,null,"NBPG0901G01053"]
[null,null,null,null,null,null,null,null,null,"NBPG0901G01054"]

{"sheet":"Artikelnummer Logik 2025","index":7,"n_rows":51,"n_cols":34,"rows_kept":51,"cut":false,"hidden":true,"merged":[[42,2,42,3]]}
[]
[]
[]
[]
[null,null,null,{"$f":"N5&O5&P5&Q5&R5&S5&T5&U5&V5&W5&X5&Y5&Z5&AA5","v":"NKPG0000G00001"},null,null,null,null,null,null,null,null,null,"N",{"$f":"IF(AND(IF(C7=\"x\",0,1),IF(C8=\"x\",0,1),IF(C13=\"x\",0,1),IF(C14=\"x\",0,1)),\"K\",\"B\")","v":"K"},"P","G",{"$f":"SUM(R7:R34)","v":0},{"$f":"SUM(S7:S34)","v":0},{"$f":"SUM(T7:T34)","v":0},{"$f":"SUM(U7:U34)","v":0},"G",{"$f":"IF($C$39=\"x\",W39,SUM(W7:W35))","v":0},{"$f":"IF($C$39=\"x\",W39,SUM(X7:X34))","v":0},{"$f":"IF($C$39=\"x\",W39,SUM(Y7:Y34))","v":0},{"$f":"IF($C$39=\"x\",W39,SUM(Z7:Z34))","v":0},{"$f":"IF($C$39=\"x\",W39,SUM(AA7:AA34))","v":1}]
[null,null,null,"AKKUTEC","C-TEC","Iso Überwachung"]
[null,"x",{"$f":"IF(AND('Konfiguration in Gehäuse'!D8<>\"\",'Konfiguration in Gehäuse'!D10<>\"\",'Konfiguration in Gehäuse'!D12=\"\",'Konfiguration in Gehäuse'!D13=\"\"),\"x\",\"\")","v":""},"AKKUTEC 2412",null,"Ja",2,5,1,1,null,"B",null,null,{"$f":"IF($C7=\"x\",L7,\"\")","v":""},null,null,{"$f":"IF($C7=\"x\",G7,\"\")","v":""},{"$f":"IF($C7=\"x\",H7,\"\")","v":""},{"$f":"IF($C7=\"x\",I7,\"\")","v":""},{"$f":"IF($C7=\"x\",J7,\"\")","v":""}]
[null,"x",{"$f":"IF(AND('Konfiguration in Gehäuse'!D8<>\"\",'Konfiguration in Gehäuse'!D10=\"\",'Konfiguration in Gehäuse'!D12=\"\",'Konfiguration in Gehäuse'!D13=\"\"),\"x\",\"\")","v":""},"AKKUTEC 2412",null,"Nein",2,5,1,2,null,"B",null,null,{"$f":"IF($C8=\"x\",L8,\"\")","v":""},null,null,"","","",""]
[null,"x",{"$f":"IF(AND('Konfiguration in Gehäuse'!D8<>\"\",'Konfiguration in Gehäuse'!D10<>\"\",'Konfiguration in Gehäuse'!D12<>\"\"),\"x\",\"\")","v":""},"AKKUTEC 2412","2425P","Ja",2,5,0,1,null,"K",null,null,"",null,null,"","","",""]
[null,"x",{"$f":"IF(AND('Konfiguration in Gehäuse'!D8<>\"\",'Konfiguration in Gehäuse'!D12<>\"\",'Konfiguration in Gehäuse'!D10=\"\"),\"x\",\"\")","v":""},"AKKUTEC 2412","2425P","Nein",2,5,0,2,null,"K",null,null,"",null,null,"","","",""]
[null,"x",{"$f":"IF(AND('Konfiguration in Gehäuse'!D8<>\"\",'Konfiguration in Gehäuse'!D10<>\"\",'Konfiguration in Gehäuse'!D13<>\"\"),\"x\",\"\")","v":""},"AKKUTEC 2412","2440P","Ja",2,5,0,3,null,"K",null,null,"",null,null,"","","",""]
[null,"x",{"$f":"IF(AND('Konfiguration in Gehäuse'!D8<>\"\",'Konfiguration in Gehäuse'!D13<>\"\",'Konfiguration in Gehäuse'!D10=\"\"),\"x\",\"\")","v":""},"AKKUTEC 2412","2440P","Nein",2,5,0,4,null,"K",null,null,"",null,null,"","","",""]
[null,"x",{"$f":"IF(AND('Konfiguration in Gehäuse'!D7<>\"\",'Konfiguration in Gehäuse'!D10<>\"\",'Konfiguration in Gehäuse'!D12=\"\",'Konfiguration in Gehäuse'!D13=\"\"),\"x\",\"\")","v":""},"AKKUTEC 2403",null,"Ja",2,5,1,3,null,"B",null,null,"",null,null,{"$f":"IF($C13=\"x\",G13,\"\")","v":""},{"$f":"IF($C13=\"x\",H13,\"\")","v":""},{"$f":"IF($C13=\"x\",I13,\"\")","v":""},{"$f":"IF($C13=\"x\",J13,\"\")","v":""}]
[null,"x",{"$f":"IF(AND('Konfiguration in Gehäuse'!D7<>\"\",'Konfiguration in Gehäuse'!D10=\"\",'Konfiguration in Gehäuse'!D12=\"\",'Konfiguration in Gehäuse'!D13=\"\"),\"x\",\"\")","v":""},"AKKUTEC 2403",null,"Nein",2,5,1,4,null,"B",null,null,"",null,null,"","","",""]
[null,"x",{"$f":"IF(AND('Konfiguration in Gehäuse'!D7<>\"\",'Konfiguration in Gehäuse'!D10<>\"\",'Konfiguration in Gehäuse'!D12<>\"\"),\"x\",\"\")","v":""},"AKKUTEC 2403","2425P","Ja",2,5,0,5,null,"K",null,null,"",null,null,"","","",""]
[null,"x",{"$f":"IF(AND('Konfiguration in Gehäuse'!D7<>\"\",'Konfiguration in Gehäuse'!D12<>\"\",'Konfiguration in Gehäuse'!D10=\"\"),\"x\",\"\")","v":""},"AKKUTEC 2403","2425P","Nein",2,5,0,6,null,"K",null,null,"",null,null,"","","",""]
[null,"x",{"$f":"IF(AND('Konfiguration in Gehäuse'!D7<>\"\",'Konfiguration in Gehäuse'!D10<>\"\",'Konfiguration in Gehäuse'!D13<>\"\"),\"x\",\"\")","v":""},"AKKUTEC 2403","2440P","Ja",2,5,0,7,null,"K",null,null,"",null,null,"","","",""]
[null,"x",{"$f":"IF(AND('Konfiguration in Gehäuse'!D7<>\"\",'Konfiguration in Gehäuse'!D13<>\"\",'Konfiguration in Gehäuse'!D10=\"\"),\"x\",\"\")","v":""},"AKKUTEC 2403","2440P","Nein",2,5,0,8,null,"K",null,null,"",null,null,"","","",""]
[]
[null,"x",{"$f":"IF(AND('Konfiguration in Gehäuse'!D26=\"\",'Konfiguration in Gehäuse'!D27=\"\"),\"x\",\"\")","v":"x"},"ohne Sicherungsplatine",null,null,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C20=\"x\",$G20,\"\")","v":0},{"$f":"IF($C20=\"x\",$H20,\"\")","v":1}]
[null,"x",{"$f":"IF('Konfiguration in Gehäuse'!D26<>\"\",\"x\",\"\")","v":""},"5er Sicherungsplatine",null,null,0,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C21=\"x\",$G21,\"\")","v":""},{"$f":"IF($C21=\"x\",$H21,\"\")","v":""}]
[null,null,{"$f":"IF('Konfiguration in Gehäuse'!D27<>\"\",\"x\",\"\")","v":""},"10er Sicherungsplatine",null,null,0,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C22=\"x\",$G22,\"\")","v":""},""]
[]
[null,"x",{"$f":"IF(AND('Konfiguration in Gehäuse'!D24=\"\",'Konfiguration in Gehäuse'!D31=\"\"),\"x\",\"\")","v":"x"},"ohne Fusebridge oder Gateway",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C24=\"x\",$G24,\"\")","v":0}]
[null,null,{"$f":"IF(AND('Konfiguration in Gehäuse'!D24<>\"\",'Konfiguration in Gehäuse'!D31=\"\"),\"x\",\"\")","v":""},"Fusebridge",null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C25=\"x\",$G25,\"\")","v":""}]
[null,null,{"$f":"IF(AND('Konfiguration in Gehäuse'!D24=\"\",'Konfiguration in Gehäuse'!D31<>\"\"),\"x\",\"\")","v":""},"Gateway",null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C26=\"x\",$G26,\"\")","v":""}]
[null,"x",{"$f":"IF(AND('Konfiguration in Gehäuse'!D24<>\"\",'Konfiguration in Gehäuse'!D31<>\"\"),\"x\",\"\")","v":""},"Fusebridge + Gateway",null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C27=\"x\",$G27,\"\")","v":""}]
[]
[null,"x",{"$f":"IF('Konfiguration in Gehäuse'!D29=\"\",\"x\",\"\")","v":"x"},"ohne DC-DC Wandler",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C29=\"x\",$G29,\"\")","v":0}]
[null,"x",{"$f":"IF('Konfiguration in Gehäuse'!D29<>\"\",\"x\",\"\")","v":""},"DC-DC Wandler 24V auf 12V",null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C30=\"x\",$G30,\"\")","v":""}]
[]
[null,"x",{"$f":"IF('Konfiguration in Gehäuse'!D33<>\"\",\"x\",\"\")","v":""},"IP31 klein AKKUTEC 2403",null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C32=\"x\",$G32,\"\")","v":""}]
[null,"x",{"$f":"IF('Konfiguration in Gehäuse'!D34<>\"\",\"x\",\"\")","v":""},"IP31 groß AKKUTEC 2412",null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C33=\"x\",$G33,\"\")","v":""}]
[null,"x",{"$f":"IF('Konfiguration in Gehäuse'!D35<>\"\",\"x\",\"\")","v":""},"IP54 AKKUTEC 2403",null,"ohne HZ",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"x",{"$f":"IF('Konfiguration in Gehäuse'!D36<>\"\",\"x\",\"\")","v":""},"IP54 AKKUTEC 2412",null,"ohne HZ",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"IP54 AKKUTEC 2403",null,"mit HZ"]
[null,null,null,"IP54 AKKUTEC 2412",null,"mit HZ"]
[]
[null,"x",{"$f":"IF('Konfiguration in Gehäuse'!D38<>\"\",\"x\",\"\")","v":""},"Sondereinstellung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X","X","X","X","X"]
[]
[]
[]
[null,null,"Batterieauswahl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('Konfiguration in Gehäuse'!D16:D20)","v":0},null,"x",null,{"$f":"CONCATENATE(Y51,Z51,AA51,AB51,AC51,AD51,AE51,AF51,AG51)","v":"000000.0"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(V43,W43,X43,Y43,Z43)","v":"0x000000.0"}]
[]
[null,null,{"$f":"IF('Konfiguration in Gehäuse'!D16<>\"\",\"x\",\"\")","v":""},"Batterie  12 Ah - 12 V",null,null,null,null,"452011.22",null,null,null,null,null,4,5,2,0,1,1,".",2,2,null,{"$f":"IF($C45<>\"\",O45,\"\")","v":""},{"$f":"IF($C45<>\"\",P45,\"\")","v":""},"","","","","","",""]
[null,null,{"$f":"IF('Konfiguration in Gehäuse'!D17<>\"\",\"x\",\"\")","v":""},"Batterie  17 Ah - 12 V",null,null,null,null,"452011.2",null,null,null,null,null,4,5,2,0,1,1,".",2,null,null,{"$f":"IF($C46<>\"\",O46,\"\")","v":""},{"$f":"IF($C46<>\"\",P46,\"\")","v":""},{"$f":"IF($C46<>\"\",Q46,\"\")","v":""},{"$f":"IF($C46<>\"\",R46,\"\")","v":""},{"$f":"IF($C46<>\"\",S46,\"\")","v":""},{"$f":"IF($C46<>\"\",T46,\"\")","v":""},{"$f":"IF($C46<>\"\",U46,\"\")","v":""},{"$f":"IF($C46<>\"\",V46,\"\")","v":""}]
[null,null,{"$f":"IF('Konfiguration in Gehäuse'!D18<>\"\",\"x\",\"\")","v":""},"Batterie  24 Ah - 12 V",null,null,null,null,"452011.4",null,null,null,null,null,4,5,2,0,1,1,".",4,null,null,"","","","","","","",""]
[null,null,{"$f":"IF('Konfiguration in Gehäuse'!D19<>\"\",\"x\",\"\")","v":""},"Batterie  40 Ah - 12 V",null,null,null,null,"452011.8",null,null,null,null,null,4,5,2,0,1,1,".",8,null,null,"","","","","","","",""]
[null,null,{"$f":"IF('Konfiguration in Gehäuse'!D20<>\"\",\"x\",\"\")","v":""},"Batterie  65 Ah - 12 V",null,null,null,null,"452011.9",null,null,null,null,null,4,5,2,0,1,1,".",9,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":"SUM(Y45:Y49)","v":0},{"$f":"SUM(Z45:Z49)","v":0},0,0,0,0,".",0,{"$f":"IF(C45 = \"x\", \"2\", \"\")","v":""}]