{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Calculation","Example ","Basis","Basis_Berech.","Geräte","Sprache"],"not_rendered":{"charts":2,"images":19,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Calculation","index":0,"n_rows":41,"n_cols":26,"rows_kept":41,"cut":false,"hidden":false,"merged":[[9,8,11,16],[31,9,31,15],[12,8,28,8]]}
[]
[]
[null,null,null,null,null,null,null,null,""]
[]
[]
[null,{"$f":"Sprache!A4","v":"Power supply typ"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DC"]
[]
[null,{"$f":"Sprache!A5","v":"Voltage"},null,null,{"$f":"MIN(Basis!E5,MAX(Y10,Basis!D7))","v":24}]
[]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Y6,Basis!D2:G3,3,0)&\"\n\"&VLOOKUP(Y6,Basis!D2:G3,4)&TEXT(Y10,\"0.0\")&\" V)\"","v":"Cable length vs. active power valid for DC supply\n(Minimum supply DC 24.0 V)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,240,{"$f":"X10/10","v":24}]
[]
[null,{"$f":"Sprache!A15","v":"MP Master"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"unknown",{"$f":"IF(X12=\"\",\"\",VLOOKUP(X12,Basis!B12:E17,4,0))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"Sprache!A13","v":"Cable length [m]"}]
[null,null,null,null,null," "]
[null,"MP 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(X15=\"\",\"\",VLOOKUP(X15,Geräte!A:D,4,0))","v":""}]
[]
[null,"MP 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(X17=\"\",\"\",VLOOKUP(X17,Geräte!A:D,4,0))","v":""}]
[]
[null,"MP 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(X19=\"\",\"\",VLOOKUP(X19,Geräte!A:D,4,0))","v":""}]
[]
[null,"MP 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(X21=\"\",\"\",VLOOKUP(X21,Geräte!A:D,4,0))","v":""}]
[]
[null,"MP 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X23=\"\",\"\",VLOOKUP(X23,Geräte!A:D,4,0))","v":""}]
[]
[null,"MP 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X25=\"\",\"\",VLOOKUP(X25,Geräte!A:D,4,0))","v":""}]
[]
[null,"MP 7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X27=\"\",\"\",VLOOKUP(X27,Geräte!A:D,4,0))","v":""}]
[]
[null,"MP 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X29=\"\",\"\",VLOOKUP(X29,Geräte!A:D,4,0))","v":""},{"$f":"SUM(Y12:Y29)","v":0}]
[]
[]
[null,{"$f":"Sprache!A16","v":"Cable cross-section"},null,null,null,null,null,null,null,{"$f":"VLOOKUP(Y6,Basis!D2:G3,2,0)","v":"Effective power [W]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"0.75 mm2",{"$f":"VLOOKUP(X32,Basis!C20:D23,2,0)","v":0.75}]
[]
[null,{"$f":"Sprache!A17","v":"Ground"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"doppelt"]
[]
[null,{"$f":"Sprache!A18","v":"max. length"},null,null,{"$f":"IF(Basis_Berech.!I39<=1,\"\",Basis_Berech.!I39)","v":""}]
[]
[null,{"$f":"Sprache!A19","v":"required power "},null,null,{"$f":"IF(Z29<0.1,\"\",ROUNDUP(Z29,0)&\"   \"&VLOOKUP(Y6,Basis!D2:H3,5,0))","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EN"]

{"sheet":"Example ","index":1,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[26,8,27,15]]}
[]
[]
[]
[null,{"$f":"Sprache!A23","v":"Application:"}]
[null,{"$f":"Sprache!A24","v":"The MP wiring calculator calculates the requested power consumption to layout the"}]
[null,{"$f":"Sprache!A25","v":"transformer, as well the maximum cable length of 1 MP-branch."}]
[]
[null,{"$f":"Sprache!A26","v":"The cable lengths are due to:"}]
[null,null,{"$f":"Sprache!A27","v":"- the sum of the power consumption of each connected MP-node"}]
[null,null,{"$f":"Sprache!A28","v":"- type of power supply (AC 24 V over the bus or DC 24 V over the Bus),"}]
[null,null,{"$f":"Sprache!A29","v":"- the selection of the cable diameter"}]
[null,null,{"$f":"Sprache!A30","v":"- the selection of the ground wiring."}]
[]
[null,{"$f":"Sprache!A32","v":"Calculation examples:"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"Sprache!A35","v":"a = Cable length"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"Sprache!B36","v":"ΣP = Total der Leistungsaufnahme auf dem Strang a"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"Sprache!A39","v":"a = Cable length between Master and last node on this branch"}]
[null,null,null,null,null,null,null,null,{"$f":"Sprache!A40","v":"b = Cable length between the junction from branch a to the last node on branch b"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"Sprache!A41","v":"ΣP = Total power consumption of all connected nodes"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"Sprache!A42","v":"The sum of branches a and b must not be greater than the calculated maximum cable length"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"Sprache!A45","v":"a = Cable length between Master and last node on this branch"}]
[null,null,null,null,null,null,null,null,{"$f":"Sprache!A46","v":"b = Cable length between Master and last node on this branch"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"Sprache!A47","v":"The cable length is calculated for each individual branch"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"Sprache!A48","v":"ΣP = Total power consumption of all connected nodes per branch"}]

{"sheet":"Basis","index":2,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Stromversorgung",null,"AC",{"$f":"Sprache!A7","v":"Dimenstional output [VA]"},{"$f":"Sprache!A9","v":"Cable length vs. dimensional output valid for AC supply "},{"$f":"Sprache!A11","v":"(Minimum transformer voltage AC "},"VA"]
[null,null,null,"DC",{"$f":"Sprache!A8","v":"Effective power [W]"},{"$f":"Sprache!A10","v":"Cable length vs. active power valid for DC supply"},{"$f":"Sprache!A12","v":"(Minimum supply DC "},"W"]
[]
[null,"Volt","AC",21.6,28.8]
[null,null,"DC",21.6,28.8]
[null,null,null,{"$f":"IF(Calculation!Y6=Basis!D2,Basis!D5,Basis!D6)","v":21.6},28.8]
[]
[]
[null,null,"AC","DC"]
[null,null,"[VA]","[W]"]
[null,{"$f":"Sprache!A6","v":"unknown"},0,0,{"$f":"IF(Calculation!$Y$6=D$2,C12,D12)","v":0}]
[null,"UK24MOD",3,1.8,{"$f":"IF(Calculation!$Y$6=D$2,C13,D13)","v":1.8}]
[null,"UK24BAC",3,1.8,{"$f":"IF(Calculation!$Y$6=D$2,C14,D14)","v":1.8}]
[]
[]
[]
[]
[]
[null,"Kabel Querschnitt","0.75 mm2",0.75]
[null,null,"1.0   mm2",1]
[null,null,"1.5   mm2",1.5]
[null,null,"2.5   mm2",2.5]
[]
[null,"Ground","einfach"]
[null,null,"doppelt"]
[]
[]
[]
[null,"Sprache","DE"]
[null,null,"EN"]

{"sheet":"Basis_Berech.","index":3,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Power supply typ",{"$f":"Calculation!Y6","v":"DC"},null,null,{"$f":"IF(C2=Basis!D2,1.2,1)","v":1}]
[null,"Volt",{"$f":"Calculation!E8","v":24}]
[null,"Ground",{"$f":"Calculation!X34","v":"doppelt"},null,{"$f":"IF(C4=Basis!C25,1,2)","v":2},{"$f":"E4+1","v":3},null,null,null,null,null,null,null,null,null,null,"Formel AC"]
[null,"Kabelquerschnitt",{"$f":"Calculation!Y32","v":0.75}]
[]
[null,null,"Länge"]
[null,null,"0.75  mm2","1.0  mm2","1.5  mm2","2.5  mm2"]
[null,"VA / W",0.75,1,1.5,2.5]
[null,"Werte_X","Werte_Y"]
[null,1E-3,{"$f":"((($C$3-19.7)*19.7*$E$4*C$9)/($F$4*$B11*0.0205*$F$2))","v":2066097.5609756098},2754796.7479674798,4132195.1219512196,6886991.8699186994]
[null,1,2066.0975609756101,2754.7967479674799,4132.1951219512202,6886.9918699187001]
[null,2,1033.0487804878051,1377.3983739837399,2066.0975609756101,3443.4959349593501]
[null,3,688.69918699186996,918.26558265582662,1377.3983739837399,2295.663956639567]
[null,4,516.52439024390253,688.69918699186996,1033.0487804878051,1721.747967479675]
[null,5,413.21951219512198,550.95934959349597,826.43902439024396,1377.3983739837402]
[null,6,344.34959349593498,459.13279132791331,688.69918699186996,1147.8319783197835]
[null,7,295.15679442508713,393.54239256678284,590.31358885017426,983.85598141695721]
[null,8,258.26219512195127,344.34959349593498,516.52439024390253,860.87398373983751]
[null,9,229.56639566395665,306.08852755194221,459.13279132791331,765.22131887985563]
[null,10,206.60975609756099,275.47967479674799,413.21951219512198,688.69918699187008]
[null,12,172.17479674796749,229.56639566395665,344.34959349593498,573.91598915989175,null,null,null,null,null,null,null,null,null,null,"Formel DC"]
[null,14,147.57839721254356,196.77119628339142,295.15679442508713,491.9279907084786]
[null,16,129.13109756097563,172.17479674796749,258.26219512195127,430.43699186991876]
[null,18,114.78319783197833,153.0442637759711,229.56639566395665,382.61065943992782]
[null,20,103.30487804878049,137.73983739837399,206.60975609756099,344.34959349593504]
[null,25,82.643902439024387,110.1918699186992,165.28780487804877,275.47967479674799]
[null,30,68.869918699186996,91.826558265582662,137.73983739837399,229.56639566395668]
[null,40,51.652439024390247,68.869918699186996,103.30487804878049,172.17479674796752]
[null,50,41.321951219512194,55.095934959349599,82.643902439024387,137.73983739837399]
[null,60,{"$f":"((($C$3-19.7)*19.7*$E$4*C$9)/($F$4*$B31*0.0205*$F$2))","v":34.434959349593498},45.913279132791331,68.869918699186996,114.78319783197834]
[null,70,29.515679442508709,39.354239256678277,59.031358885017418,98.385598141695709]
[null,80,25.826219512195124,34.434959349593498,51.652439024390247,86.08739837398376]
[null,90,22.956639566395665,30.608852755194221,45.913279132791331,76.522131887985552]
[null,100,20.660975609756097,27.547967479674799,41.321951219512194,68.869918699186996]
[null,110,18.782705099778269,25.04360679970436,37.565410199556538,62.609016999260909,null,"Zeiger"]
[null,120,17.217479674796749,22.956639566395665,34.434959349593498,57.391598915989171,null,"X","Y"]
[null,130,15.893058161350845,21.190744215134462,31.786116322701691,52.976860537836153,null,1,{"$f":"I39","v":1}]
[null,140,14.757839721254355,19.677119628339138,29.515679442508709,49.192799070847855,null,{"$f":"MAX(1,Calculation!Z29)","v":1},{"$f":"IF(Calculation!Z29>0.1,((($C$3-19.7)*19.7*$E$4*$C$5)/($F$4*$H39*0.0205*$F$2)),1)","v":1}]
[null,150,13.7739837398374,18.365311653116535,27.547967479674799,45.913279132791338,null,{"$f":"H39","v":1},1]
[null,160,12.913109756097562,17.217479674796749,25.826219512195124,43.04369918699188]
[null,170,12.153515064562411,16.204686752749883,24.307030129124822,40.511716881874705]
[null,180,11.478319783197833,15.30442637759711,22.956639566395665,38.261065943992776]
[null,190,10.874197689345316,14.49893025246042,21.748395378690631,36.24732563115105]
[null,200,10.330487804878048,13.7739837398374,20.660975609756097,34.434959349593498]

{"sheet":"Geräte","index":4,"n_rows":166,"n_cols":6,"rows_kept":166,"cut":false,"hidden":true,"merged":[]}
[null,"AC","DC",{"$f":"Calculation!$Y$6","v":"DC"}]
["MatNr","VA","W","Resultat"]
[null,0,0,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B3,C3)","v":0}]
["22RT-19-1",1,0.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B4,C4)","v":0.5}]
["22RTH-19-1",1,0.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B5,C5)","v":0.5}]
["22RTM-19-1",1,0.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B6,C6)","v":0.5}]
["22PE-1..",3,1.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B7,C7)","v":1.5},null,"new"]
["22PF-1..",2.2000000000000002,1.1000000000000001,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B8,C8)","v":1.1000000000000001},null,"new"]
["P-22RT.-1900.-1",1,0.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B9,C9)","v":0.5},null,"new"]
["P-22RT.-1U00.-2",1,0.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B10,C10)","v":0.5},null,"new"]
["AV24-MFT2",12,6,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B11,C11)","v":6},null,"gelöschtes Produkt"]
["AV24-MFT2-R",12,6,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B12,C12)","v":6},null,"gelöschtes Produkt"]
["AVK24A-MP-RE",9.5,5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B13,C13)","v":5}]
["AVK24A-MP-TPC",9.5,5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B14,C14)","v":5}]
["CM24-MPL-L",1.5,1,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B15,C15)","v":1}]
["CM24-MPL-R",1.5,1,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B16,C16)","v":1}]
["CMV-…-MP",2.5,1.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B17,C17)","v":1.5}]
["CQ24A-MPL",1.1000000000000001,0.6,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B18,C18)","v":0.6}]
["CQK24A-MPL",4,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B19,C19)","v":2.5}]
["CQK24A-MPL-T",4,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B20,C20)","v":2.5}]
["DR24A-MP-7",12,9,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B21,C21)","v":9}]
["EF24A-MP",16,9.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B22,C22)","v":9.5}]
["EP015R2+BAC",6.5,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B23,C23)","v":4},null,"new"]
["EP020R2+BAC",6.5,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B24,C24)","v":4},null,"new"]
["EP025R2+BAC",6.5,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B25,C25)","v":4},null,"new"]
["EP032R2+BAC",7.5,5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B26,C26)","v":5},null,"new"]
["EP040R2+BAC",7.5,5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B27,C27)","v":5},null,"new"]
["EP050R2+BAC",7.5,5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B28,C28)","v":5},null,"new"]
["EP015R+KMP",12,6,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B29,C29)","v":6},null,"gelöschtes Produkt"]
["EP015R+MP",6,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B30,C30)","v":3.5},null,"gelöschtes Produkt"]
["EP015R-R6+BAC",4.5,2,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B31,C31)","v":2}]
["EP020R+KMP",12,6,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B32,C32)","v":6},null,"gelöschtes Produkt"]
["EP020R+MP",6,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B33,C33)","v":3.5},null,"gelöschtes Produkt"]
["EP020R-R6+BAC",4.5,2,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B34,C34)","v":2}]
["EP025R+KMP",12,6,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B35,C35)","v":6}]
["EP025R+MP",6,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B36,C36)","v":3.5}]
["EP032R+KMP",12,6,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B37,C37)","v":6}]
["EP032R+MP",7,4.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B38,C38)","v":4.5}]
["EP040R+KMP",12,6,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B39,C39)","v":6}]
["EP040R+MP",7,4.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B40,C40)","v":4.5}]
["EP050R+KMP",12,6,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B41,C41)","v":6}]
["EP050R+MP",7,4.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B42,C42)","v":4.5}]
["EP065F+KMP",13,9.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B43,C43)","v":9.5}]
["EP065F+MP",13,9.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B44,C44)","v":9.5}]
["EP080F+KMP",13,9.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B45,C45)","v":9.5}]
["EP080F+MP",13,9.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B46,C46)","v":9.5}]
["EP100F+KMP",13,9.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B47,C47)","v":9.5}]
["EP100F+MP",13,9.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B48,C48)","v":9.5}]
["EP125F+KMP",13,9.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B49,C49)","v":9.5}]
["EP125F+MP",13,9.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B50,C50)","v":9.5}]
["EP150F+KMP",13,9.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B51,C51)","v":9.5}]
["EP150F+MP",13,9.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B52,C52)","v":9.5}]
["EV015R2+BAC",6.5,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B53,C53)","v":4},null,"new"]
["EV015R2+KBAC",26,15,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B54,C54)","v":15},null,"new"]
["EV015R2+MID",6.5,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B55,C55)","v":4},null,"new"]
["EV020R2+BAC",6.5,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B56,C56)","v":4},null,"new"]
["EV020R2+KBAC",26,15,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B57,C57)","v":15},null,"new"]
["EV020R2+MID",6.5,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B58,C58)","v":4},null,"new"]
["EV025R2+BAC",6.5,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B59,C59)","v":4},null,"new"]
["EV025R2+KBAC",26,15,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B60,C60)","v":15},null,"new"]
["EV025R2+MID",6.5,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B61,C61)","v":4},null,"new"]
["EV032R2+BAC",7.5,5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B62,C62)","v":5},null,"new"]
["EV032R2+KBAC",26,15,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B63,C63)","v":15},null,"new"]
["EV032R2+MID",7.5,5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B64,C64)","v":5},null,"new"]
["EV040R2+BAC",7.5,5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B65,C65)","v":5},null,"new"]
["EV040R2+KBAC",26,15,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B66,C66)","v":15},null,"new"]
["EV040R2+MID",7.5,5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B67,C67)","v":5},null,"new"]
["EV050R2+BAC",7.5,5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B68,C68)","v":5},null,"new"]
["EV050R2+KBAC",26,15,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B69,C69)","v":15},null,"new"]
["EV050R2+MID",7.5,5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B70,C70)","v":5},null,"new"]
["EV015R+BAC",6.5,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B71,C71)","v":4},null,"gelöschtes Produkt"]
["EV015R+KBAC",26,15,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B72,C72)","v":15},null,"gelöschtes Produkt"]
["EV020R+BAC",6.5,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B73,C73)","v":4},null,"gelöschtes Produkt"]
["EV020R+KBAC",26,15,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B74,C74)","v":15},null,"gelöschtes Produkt"]
["EV025R+BAC",6.5,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B75,C75)","v":4},null,"gelöschtes Produkt"]
["EV025R+KBAC",26,15,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B76,C76)","v":15},null,"gelöschtes Produkt"]
["EV032R+BAC",7.5,5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B77,C77)","v":5},null,"gelöschtes Produkt"]
["EV032R+KBAC",26,15,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B78,C78)","v":15},null,"gelöschtes Produkt"]
["EV040R+BAC",7.5,5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B79,C79)","v":5},null,"gelöschtes Produkt"]
["EV040R+KBAC",26,15,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B80,C80)","v":15},null,"gelöschtes Produkt"]
["EV050R+BAC",7.5,5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B81,C81)","v":5},null,"gelöschtes Produkt"]
["EV050R+KBAC",26,15,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B82,C82)","v":15},null,"gelöschtes Produkt"]
["EV065F+BAC",14,10,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B83,C83)","v":10}]
["EV065F+KBAC",26,15.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B84,C84)","v":15.5}]
["EV080F+BAC",14,10,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B85,C85)","v":10}]
["EV080F+KBAC",26,15.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B86,C86)","v":15.5}]
["EV100F+BAC",14,10,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B87,C87)","v":10}]
["EV100F+KBAC",29,16.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B88,C88)","v":16.5}]
["EV125F+BAC",14,10,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B89,C89)","v":10}]
["EV125F+KBAC",29,16.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B90,C90)","v":16.5}]
["EV150F+BAC",14,10,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B91,C91)","v":10}]
["EV150F+KBAC",29,16.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B92,C92)","v":16.5}]
["EV24A-MP-RE",6,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B93,C93)","v":4}]
["EV24A-MP-TPC",6,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B94,C94)","v":4}]
["GK24A-MP",21,11,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B95,C95)","v":11}]
["GK24G-MP",21,11,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B96,C96)","v":11}]
["GM24A-MP",7,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B97,C97)","v":4}]
["GM24A-MP-TP",7,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B98,C98)","v":4}]
["GM24G-MP-T",7,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B99,C99)","v":4}]
["GR24A-MP-5",7,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B100,C100)","v":4}]
["GR24A-MP-7",7,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B101,C101)","v":4}]
["LF24-MFT2",5,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B102,C102)","v":2.5}]
["LH24A-MP100",5,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B103,C103)","v":2.5}]
["LH24A-MP100-TP",5,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B104,C104)","v":2.5}]
["LH24A-MP200",5,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B105,C105)","v":2.5}]
["LH24A-MP200-TP",5,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B106,C106)","v":2.5}]
["LH24A-MP300",5,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B107,C107)","v":2.5}]
["LH24A-MP300-TP",5,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B108,C108)","v":2.5}]
["LH24A-MP60-TP",5,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B109,C109)","v":2.5}]
["LHK24A-MP100",14,7,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B110,C110)","v":7}]
["LHV-D3-MP",4.5,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B111,C111)","v":2.5}]
["LM24A-MP",5,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B112,C112)","v":2.5}]
["LM24A-MP-TP",5,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B113,C113)","v":2.5}]
["LMV-D3-MP",3.5,2,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B114,C114)","v":2}]
["LR24A-MP",5,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B115,C115)","v":2.5}]
["LRD24A-MP",5,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B116,C116)","v":2.5}]
["LRF24-MP",10,6,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B117,C117)","v":6}]
["LRF24-MP-O",10,6,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B118,C118)","v":6}]
["LU24A-MP",5,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B119,C119)","v":2.5}]
["LV24A-MP-TPC",4,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B120,C120)","v":2.5}]
["LVC24A-MP-TPC",4.5,3,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B121,C121)","v":3}]
["NF24A-MP",9.5,7,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B122,C122)","v":7}]
["NF24G-MP-L",9.5,7,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B123,C123)","v":7}]
["NM24A-MP",6,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B124,C124)","v":3.5}]
["NM24A-MP-TP",6,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B125,C125)","v":3.5}]
["NM24P-MP",6,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B126,C126)","v":3.5}]
["NMC24A-MP",7,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B127,C127)","v":4}]
["NMV-D3-MP",5,3,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B128,C128)","v":3}]
["NR24A-MP",6,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B129,C129)","v":3.5}]
["NRF24A-MP",9.5,7,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B130,C130)","v":7}]
["NV24A-MP-RE",3,1.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B131,C131)","v":1.5}]
["NV24A-MP-TPC",3,1.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B132,C132)","v":1.5}]
["NV24-MFT2",5,3,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B133,C133)","v":3}]
["NVC24A-MP-RE",5.5,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B134,C134)","v":3.5}]
["NVC24A-MP-TPC",5.5,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B135,C135)","v":3.5}]
["NVF24-MFT2",10,5.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B136,C136)","v":5.5},null,"gelöschtes Produkt"]
["NVF24-MFT2-E",10,5.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B137,C137)","v":5.5},null,"gelöschtes Produkt"]
["NVFY24-MFT2",10,5.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B138,C138)","v":5.5},null,"gelöschtes Produkt"]
["NVK24A-MP-RE",6,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B139,C139)","v":2.5}]
["NVK24A-MP-TPC",6,2.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B140,C140)","v":2.5}]
["NVKC24A-MP-RE",9,4.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B141,C141)","v":4.5}]
["NVKC24A-MP-TPC",9,4.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B142,C142)","v":4.5}]
["SF24A-MP",11,8.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B143,C143)","v":8.5}]
["SF24G-MP-L",11,8.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B144,C144)","v":8.5}]
["SH24A-MP100",6,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B145,C145)","v":3.5}]
["SH24A-MP200",6,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B146,C146)","v":3.5}]
["SH24A-MP300",6,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B147,C147)","v":3.5}]
["SHK24A-MP100",21,11,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B148,C148)","v":11}]
["SM24A-MP",6,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B149,C149)","v":3.5}]
["SM24A-MP-TP",6,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B150,C150)","v":3.5}]
["SM24P-MP",6,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B151,C151)","v":3.5}]
["SMC24A-MP",7,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B152,C152)","v":4}]
["SMV-D3-MP",5.5,3,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B153,C153)","v":3}]
["SR24A-MP",6,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B154,C154)","v":3.5}]
["SR24A-MP-5",6,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B155,C155)","v":3.5}]
["SR24P-MP-R",6,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B156,C156)","v":3.5}]
["SV24A-MP-RE",3.5,2,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B157,C157)","v":2}]
["SV24A-MP-TPC",3.5,2,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B158,C158)","v":2}]
["SVC24A-MP-RE",6,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B159,C159)","v":4}]
["SVC24A-MP-TPC",6,4,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B160,C160)","v":4}]
["SVL24A-MP-RE",5,3.5,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B161,C161)","v":3.5}]
["SY2-24-MP-T",72,70,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B162,C162)","v":70},null,"gelöschtes Produkt"]
["SY3-24-MP-T",72,70,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B163,C163)","v":70},null,"gelöschtes Produkt"]
["SY4-24-MP-T",144,180,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B164,C164)","v":180}]
["VRP-M & xMQ24A-SRV-ST",20.6,13.1,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B165,C165)","v":13.1}]
["VRP-M & xx24A-V-ST",10,7,{"$f":"IF(Calculation!$Y$6=Basis!$D$2,B166,C166)","v":7}]

{"sheet":"Sprache","index":5,"n_rows":303,"n_cols":3,"rows_kept":303,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Calculation!X41","v":"EN"}]
[]
[{"$f":"IF(B3=\"\",\"\",HLOOKUP(A$1,$B$3:$G$203,ROW(A3)-2,0))","v":"EN"},"DE","EN"]
["Power supply typ","Stromversorgung","Power supply typ"]
["Voltage","Spannung","Voltage"]
["unknown","unbekannt","unknown"]
["Dimenstional output [VA]","Dimensionierungsleistung [VA]","Dimenstional output [VA]"]
["Effective power [W]","Wirkleistung [W]","Effective power [W]"]
["Cable length vs. dimensional output valid for AC supply ","Kabellänge vs Dimensionierungsleistung gilt für AC-Speisung","Cable length vs. dimensional output valid for AC supply "]
["Cable length vs. active power valid for DC supply","Kabellänge vs Wirkleistung gilt für DC-Speisung","Cable length vs. active power valid for DC supply"]
["(Minimum transformer voltage AC ","(Minimale Trafospannung AC ","(Minimum transformer voltage AC "]
["(Minimum supply DC ","(Minimale Speisung DC ","(Minimum supply DC "]
["Cable length [m]","Kabellänge [m]","Cable length [m]"]
[{"$f":"IF(B14=\"\",\"\",HLOOKUP(A$1,$B$3:$G$203,ROW(A14)-2,0))","v":""}]
["MP Master","MP Master","MP Master"]
["Cable cross-section","Kabel Querschnitt","Cable cross-section"]
["Ground","Ground","Ground"]
["max. length","max. Länge","max. length"]
["required power ","erforderliche Leistung","required power "]
["Language","Sprache","Language"]
[""]
[""]
["Application:","Anwendung:","Application:"]
["The MP wiring calculator calculates the requested power consumption to layout the","Der MP-Kabellängen-Rechner berechnet die erforderliche Transformatorenleistung,","The MP wiring calculator calculates the requested power consumption to layout the"]
["transformer, as well the maximum cable length of 1 MP-branch.","sowie die maximale Leitungslänge eines Mp-Strangs.","transformer, as well the maximum cable length of 1 MP-branch."]
["The cable lengths are due to:","Die Leitungslängen ergeben sich aus:","The cable lengths are due to:"]
["- the sum of the power consumption of each connected MP-node","- der Summe der Leistungsdaten der angeschlossenen MP-Knoten,","- the sum of the power consumption of each connected MP-node"]
["- type of power supply (AC 24 V over the bus or DC 24 V over the Bus),","- der Art der Speisung (AC 24 V über den Bus oder DC 24 V über den Bus),","- type of power supply (AC 24 V over the bus or DC 24 V over the Bus),"]
["- the selection of the cable diameter","- dem verwendeten Leitungsquerschnitt","- the selection of the cable diameter"]
["- the selection of the ground wiring.","- der Auswahl der Groundverdrahtung.","- the selection of the ground wiring."]
[""]
["Calculation examples:","Berechnungsbeispiele:","Calculation examples:"]
[""]
[{"$f":"IF(B34=\"\",\"\",HLOOKUP(A$1,$B$3:$G$203,ROW(A34)-2,0))","v":""}]
["a = Cable length","a = Kabellänge","a = Cable length"]
["ΣP = Total power consumption on branch a","ΣP = Total der Leistungsaufnahme auf dem Strang a","ΣP = Total power consumption on branch a"]
[""]
[""]
["a = Cable length between Master and last node on this branch","a = Kabellänge zwischen dem Master und dem letzten Knoten auf diesem Strang","a = Cable length between Master and last node on this branch"]
["b = Cable length between the junction from branch a to the last node on branch b","b = Kabellänge zwischen der Abzweigung von Strang a bis zum letzten Knoten auf Strang b","b = Cable length between the junction from branch a to the last node on branch b"]
["ΣP = Total power consumption of all connected nodes","ΣP = Total der Leistungsaufnahme aller angeschlossenen Knoten","ΣP = Total power consumption of all connected nodes"]
["The sum of branches a and b must not be greater than the calculated maximum cable length","Die Summe der Leitungslängen der Stränge a und b darf nicht grösser sein als die kalkulierte maximale Leitungslänge","The sum of branches a and b must not be greater than the calculated maximum cable length"]
[""]
[""]
["a = Cable length between Master and last node on this branch","a = Kabellänge zwischen dem Master und dem letzten Knoten auf diesem Strang","a = Cable length between Master and last node on this branch"]
["b = Cable length between Master and last node on this branch","b = Kabellänge zwischen dem Master und dem letzten Knoten auf diesem Strang","b = Cable length between Master and last node on this branch"]
["The cable length is calculated for each individual branch","Die Kabellänge muss für jeden Strang einzeln berechnet werden","The cable length is calculated for each individual branch"]
["ΣP = Total power consumption of all connected nodes per branch","ΣP = Total Der Leistungsaufnahme aller angeschlossener Knoten per Strang","ΣP = Total power consumption of all connected nodes per branch"]
[""]
[""]
[{"$f":"IF(B51=\"\",\"\",HLOOKUP(A$1,$B$3:$G$203,ROW(A51)-2,0))","v":""}]
["Example ","Beispiel","Example "]
["Calculation","Berechnung","Calculation"]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B115=\"\",\"\",HLOOKUP(A$1,$B$3:$G$203,ROW(A115)-2,0))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B179=\"\",\"\",HLOOKUP(A$1,$B$3:$G$203,ROW(A179)-2,0))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B243=\"\",\"\",HLOOKUP(A$1,$B$3:$G$203,ROW(A243)-2,0))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]