{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Configurator","Values"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Configurator","index":0,"n_rows":33,"n_cols":39,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,2,32,5],[32,6,32,7],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[29,2,29,4],[30,2,30,7],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[14,2,14,4],[9,2,9,7],[11,2,11,4],[12,2,12,4],[22,2,22,4],[15,3,17,3],[18,3,20,3],[15,2,20,2],[12,5,12,6],[11,5,11,6]]}
[]
[null,null,null,null,null,"POWERBOX Defense Line"]
[null,null,null,null,null,"Part Number Configurator"]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"CONCATENATE(J10,K10,L10,M10,N10,O10,P10,Q10,R10,S10,T10,U10,V10,W10,X10,Y10,Z10,AA10,AB10,AC10,AD10,AE10,AF10,AG10,AH10,AI10,AJ10,AK10,AL10,AM10)","v":"Dxx-xx"},null,null,null,null,null,null,"D",{"$f":"IF(LEFT(F12,2)=\"AC\",\"B\",IF(LEFT(F12,2)=\"DC\",\"A\",\"x\"))","v":"x"},{"$f":"IF(AND(F13<>\"\",OR(F13=Values!B12,F13=Values!B13,F13=Values!B14,F13=Values!B15)),VLOOKUP(F13,Values!B12:E15,4,FALSE),\"x\")","v":"x"},{"$f":"IF(F12=\"\",\"\",IF(VLOOKUP(F12,Values!B3:E8,4,FALSE)=0,\"\",VLOOKUP(F12,Values!B3:E8,4,FALSE)))","v":""},"-",{"$f":"IF(AND(P10<>\"\",P10<>\"x\",F16<>\"\"),F16,\"x\")","v":"x"},{"$f":"IF(G16=\"\",\"x\",IF(G16=\"N\",\"N\",RIGHT(G16,SUM(LEN(G16) - LEN(SUBSTITUTE(G16, {\"0\";\"1\";\"2\";\"3\";\"4\";\"5\";\"6\";\"7\";\"8\";\"9\"},\"\"))))))","v":"x"},{"$f":"IF(R10<>\"\",\"-\",\"\")","v":""},{"$f":"IF(S10<>\"\",F17,\"\")","v":""},{"$f":"IF(OR(F17=\"\",E17=\"\"),\"\",IF(G17=\"N\",\"N\",RIGHT(G17,SUM(LEN(G17) - LEN(SUBSTITUTE(G17, {\"0\";\"1\";\"2\";\"3\";\"4\";\"5\";\"6\";\"7\";\"8\";\"9\"},\"\"))))))","v":""},{"$f":"IF(U10<>\"\",\"-\",\"\")","v":""},{"$f":"IF(V10<>\"\",F18,\"\")","v":""},{"$f":"IF(OR(F18=\"\",E18=\"\"),\"\",IF(G18=\"N\",\"N\",RIGHT(G18,SUM(LEN(G18) - LEN(SUBSTITUTE(G18, {\"0\";\"1\";\"2\";\"3\";\"4\";\"5\";\"6\";\"7\";\"8\";\"9\"},\"\"))))))","v":""},{"$f":"IF(X10<>\"\",\"-\",\"\")","v":""},{"$f":"IF(Y10<>\"\",F19,\"\")","v":""},{"$f":"IF(OR(F19=\"\",E19=\"\"),\"\",IF(G19=\"N\",\"N\",RIGHT(G19,SUM(LEN(G19) - LEN(SUBSTITUTE(G19, {\"0\";\"1\";\"2\";\"3\";\"4\";\"5\";\"6\";\"7\";\"8\";\"9\"},\"\"))))))","v":""},{"$f":"IF(AA10<>\"\",\"-\",\"\")","v":""},{"$f":"IF(AB10<>\"\",F20,\"\")","v":""},{"$f":"IF(OR(F20=\"\",E20=\"\"),\"\",IF(G20=\"N\",\"N\",RIGHT(G20,SUM(LEN(G20) - LEN(SUBSTITUTE(G20, {\"0\";\"1\";\"2\";\"3\";\"4\";\"5\";\"6\";\"7\";\"8\";\"9\"},\"\"))))))","v":""},{"$f":"IF(AD10<>\"\",\"-\",\"\")","v":""},{"$f":"IF(AE10<>\"\",F21,\"\")","v":""},{"$f":"IF(OR(F21=\"\",E21=\"\"),\"\",IF(G21=\"N\",\"N\",RIGHT(G21,SUM(LEN(G21) - LEN(SUBSTITUTE(G21, {\"0\";\"1\";\"2\";\"3\";\"4\";\"5\";\"6\";\"7\";\"8\";\"9\"},\"\"))))))","v":""},{"$f":"IF(F12=\"DC 24V wide (9-36VDC)\",\"W\",\"\")","v":""},{"$f":"IF(AND(AH10=\"\",AI10=\"\",AJ10=\"\",AK10=\"\"),\"\",\"-\")","v":""},{"$f":"IF(F24=\"Yes\",\"M\",\"\")","v":""},{"$f":"IF(OR(F24=\"Yes\",F25=\"Yes\"),\"T\",\"\")","v":""},{"$f":"IF(OR(F24=\"Yes\",F26=\"Yes\"),\"V\",\"\")","v":""},{"$f":"IF(OR(F27=\"No\",F27=\"\"),\"\",F27)","v":""},{"$f":"IF(AM10=\"\",\"\",\"-\")","v":""},{"$f":"IF(F28=\"Yes\",\"IP\",\"\")","v":""}]
[]
[null,null,"Input"]
[null,null,"Chassis",null,null,null,null,{"$f":"IF(OR(F13=\"\",F13=Values!B12,F13=Values!B13,F13=Values!B14,F13=Values!B15),\"\",\"Chassis not available\")","v":""}]
[]
[null,null,"Outputs",null,null,"Voltage [VDC]","Power [W]"]
[null,null,{"$f":"IF(LEFT(F13,3)=\"DBA\",\"Board\",\"\")","v":""},{"$f":"IF(LEFT(F13,3)=\"DBA\",\"A\",\"\")","v":""},{"$f":"\"Output \"&D16&\"1\"","v":"Output 1"},null,null,{"$f":"IF(AND(E16<>\"\",F16<>\"\"),\nIF(AND(Values!B20=\"\",Values!C20=\"\",Values!D20=\"\",Values!E20=\"\",Values!H20=\"\",Values!J20=\"\"),\"Voltage not available\",\nIF(AND(G16<>Values!B20,G16<>Values!C20,G16<>Values!D20,G16<>Values!E20,G16<>Values!F20,G16<>Values!G20,G16<>Values!H20,G16<>Values!I20,G16<>Values!J20,G16<>Values!K20),\"Power level not available\",\"\")),\n\"\")","v":""}]
[null,null,null,null,{"$f":"IF(F13<>\"\",IF(AND(VALUE(LEFT(RIGHT(F$13,4),1))>=2,LEFT(G$16,2)<>\"MM\",LEFT(G$16,2)<>\"M:\",NOT(AND(LEFT(F13,3)=\"DBC\",LEFT(G16,2)=\"n:\"))),\"Output \"&D16&\"2\",\"\"),\"\")","v":""},null,null,{"$f":"IF(AND(E17<>\"\",F17<>\"\"),\nIF(AND(Values!B21=\"\",Values!C21=\"\",Values!D21=\"\",Values!E21=\"\",Values!H21=\"\",Values!J21=\"\"),\"Voltage not available\",\nIF(AND(G17<>Values!B21,G17<>Values!C21,G17<>Values!D21,G17<>Values!E21,G17<>Values!F21,G17<>Values!G21,G17<>Values!H21,G17<>Values!I21,G17<>Values!J21,G17<>Values!K21),\"Power level not available\",\"\")),\n\"\")","v":""}]
[null,null,null,null,{"$f":"IF(F13<>\"\",IF(AND(VALUE(LEFT(RIGHT(F$13,4),1))>=3,OR(LEFT(G$16,1)=\"µ\",G$16=\"N\"),OR(LEFT(G$17,1)=\"µ\",G$17=\"N\")),\"Output \"&D16&\"3\",\"\"),\"\")","v":""},null,null,{"$f":"IF(AND(E18<>\"\",F18<>\"\"),\nIF(AND(Values!B22=\"\",Values!C22=\"\",Values!D22=\"\",Values!E22=\"\",Values!H22=\"\",Values!J22=\"\"),\"Voltage not available\",\nIF(AND(G18<>Values!B22,G18<>Values!C22,G18<>Values!D22,G18<>Values!E22,G18<>Values!F22,G18<>Values!G22,G18<>Values!H22,G18<>Values!I22,G18<>Values!J22,G18<>Values!K22),\"Power level not available\",\"\")),\n\"\")","v":""}]
[null,null,null,{"$f":"IF(LEFT(F13,3)=\"DBA\",\"B\",\"\")","v":""},{"$f":"IF(F13<>\"\",IF(AND(VALUE(LEFT(RIGHT(F$13,4),1))>=4,LEFT(G$16,2)<>\"MM\"),\"Output B1\",\"\"),\"\")","v":""},null,null,{"$f":"IF(AND(E19<>\"\",F19<>\"\"),\nIF(AND(Values!B23=\"\",Values!C23=\"\",Values!D23=\"\",Values!E23=\"\",Values!H23=\"\",Values!J23=\"\"),\"Voltage not available\",\nIF(AND(G19<>Values!B23,G19<>Values!C23,G19<>Values!D23,G19<>Values!E23,G19<>Values!F23,G19<>Values!G23,G19<>Values!H23,G19<>Values!I23,G19<>Values!J23,G19<>Values!K23),\"Power level not available\",\"\")),\n\"\")","v":""}]
[null,null,null,null,{"$f":"IF(F13<>\"\",IF(AND(VALUE(LEFT(RIGHT(F$13,4),1))>=5,LEFT(G$16,2)<>\"MM\",LEFT(G$19,2)<>\"M:\"),\"Output B2\",\"\"),\"\")","v":""},null,null,{"$f":"IF(AND(E20<>\"\",F20<>\"\"),\nIF(AND(Values!B24=\"\",Values!C24=\"\",Values!D24=\"\",Values!E24=\"\",Values!H24=\"\",Values!J24=\"\"),\"Voltage not available\",\nIF(AND(G20<>Values!B24,G20<>Values!C24,G20<>Values!D24,G20<>Values!E24,G20<>Values!F24,G20<>Values!G24,G20<>Values!H24,G20<>Values!I24,G20<>Values!J24,G20<>Values!K24),\"Power level not available\",\"\")),\n\"\")","v":""}]
[null,null,null,null,{"$f":"IF(F13<>\"\",IF(AND(VALUE(LEFT(RIGHT(F$13,4),1))>=6,LEFT(G$16,2)<>\"MM\",OR(LEFT(G$19,1)=\"µ\",G$19=\"N\"),OR(LEFT(G$20,1)=\"µ\",G$20=\"N\")),\"Output B3\",\"\"),\"\")","v":""},null,null,{"$f":"IF(AND(E21<>\"\",F21<>\"\"),\nIF(AND(Values!B25=\"\",Values!C25=\"\",Values!D25=\"\",Values!E25=\"\",Values!H25=\"\",Values!J25=\"\"),\"Voltage not available\",\nIF(AND(G21<>Values!B25,G21<>Values!C25,G21<>Values!D25,G21<>Values!E25,G21<>Values!F25,G21<>Values!G25,G21<>Values!H25,G21<>Values!I25,G21<>Values!J25,G21<>Values!K25),\"Power level not available\",\"\")),\n\"\")","v":""}]
[]
[null,null,"Options"]
[null,null,"Ruggedizing (M)"]
[null,null,"-40C operation (T)"]
[null,null,"Coating (V)"]
[null,null,"Heat sink (H, H1)"]
[null,null,"IP65 enclosure (IP)"]
[]
[null,null,"Notes"]
[null,null,{"$f":"\nIF(H13<>\"\",\"- Chassis selection does not match the input.\"&CHAR(10),\"\")&\nIF(COUNTIF(H16:H21,\"Voltage not available\")>0,\"- One or more selected output voltages are not available in this configuration.\"&CHAR(10),\"\")&\nIF(COUNTIF(H16:H21,\"Power level not available\")>0,\"- One or more selected output power levels are not available in this configuration.\"&CHAR(10),\"\")&\nIF(AND(F24=\"Yes\",OR(F25=\"No\",F26=\"No\")),\"- Option M is always bundled with options T and V.\"&CHAR(10),\"\")","v":""}]
[]
[null,null,"www.prbx.com",null,null,null,"Rev. 2020-09-15"]

{"sheet":"Values","index":1,"n_rows":47,"n_cols":35,"rows_kept":47,"cut":false,"hidden":true,"merged":[[4,32,4,33],[5,34,18,34],[19,34,32,34],[33,34,46,34],[4,13,4,15],[4,16,4,18],[4,19,4,20],[4,21,4,22],[4,25,4,27],[4,28,4,30]]}
[]
[null,"Input",null,null,null,null,null,null,null,null,null,null,"Power levels table"]
[null,"AC Universal",null,"B",null,null,null,null,null,null,null,null,"AC/DC tables",null,null,null,null,null,null,null,null,null,null,"DC/DC tables"]
[null,"DC 24V wide (9-36VDC)",null,"A",24,null,null,null,null,null,null,null,"Column number",2,3,4,5,6,7,8,9,10,11,1,2,3,4,5,6,7,8,9,10,11]
[null,"DC 24V (18-36VDC)",null,null,24,null,null,null,null,null,null,null,null,"MM",null,null,"M",null,null,"m",null,"u",null,null,"24W",24,null,null,48,null,null,72,110]
[null,"DC 48V (36-75VDC)",null,null,48,null,null,null,null,null,null,null,"N",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"N",{"$f":"\"\"","v":""},"N",{"$f":"\"\"","v":""},{"$f":"M6","v":"N"},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"DAA"]
[null,"DC 72V (43-110VDC)",null,null,72,null,null,null,null,null,null,null,2,"MM: 320",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"M: 160",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"n: 100",{"$f":"\"\"","v":""},"µ: 50",{"$f":"\"\"","v":""},{"$f":"M7","v":2},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,"DC 110V (66-143VDC)",null,null,110,null,null,null,null,null,null,null,"3V3","MM: 528","MM: 400",{"$f":"\"\"","v":""},"M: 264","M: 200",{"$f":"\"\"","v":""},"n: 150","n: 100","µ: 75","µ: 50","3V3",150,{"$f":"\"\"","v":""},264,200,264,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},264,200,150]
[null,null,null,null,null,null,null,null,null,null,null,null,5,"MM: 800","MM: 600",{"$f":"\"\"","v":""},"M: 400","M: 300",{"$f":"\"\"","v":""},"n: 200","n: 150","µ: 100","µ: 50",5,175,{"$f":"\"\"","v":""},400,300,400,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},300,300,200]
[null,"Chassis",null,null,null,null,null,null,null,null,null,null,"6V5",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"6V5",200,{"$f":"\"\"","v":""},400,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,"Chassis collection area","AC chassis table","DC chassis table",null,null,null,null,null,null,null,null,8,"MM: 800","MM: 600",{"$f":"\"\"","v":""},"M: 400","M: 300",{"$f":"\"\"","v":""},"n: 200",{"$f":"\"\"","v":""},"µ: 100",{"$f":"\"\"","v":""},8,200,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},300,400,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},300,300,200]
[null,{"$f":"IF(LEFT(Configurator!F$12,2)=\"AC\",Values!C12,IF(LEFT(Configurator!F$12,2)=\"DC\",Values!D12,\"\"))","v":""},"DBA: ≤1200W, 1-6 OP","DAA: ≤500W, 1 OP","A",null,null,null,null,null,null,null,12,"MM: 1200","MM: 800",{"$f":"\"\"","v":""},"M: 600","M: 400",{"$f":"\"\"","v":""},"n: 300","n: 200","µ: 150","µ: 75",12,200,500,400,300,500,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},400,400,300]
[null,{"$f":"IF(LEFT(Configurator!F$12,2)=\"AC\",Values!C13,IF(LEFT(Configurator!F$12,2)=\"DC\",Values!D13,\"\"))","v":""},"DBB: ≤600W, 1-3 OP","DAB: ≤300W, 1 OP","B",null,null,null,null,null,null,null,15,"MM: 1200","MM: 800",{"$f":"\"\"","v":""},"M: 600","M: 400",{"$f":"\"\"","v":""},"n: 300","n: 200","µ: 150","µ: 75",15,200,{"$f":"\"\"","v":""},400,300,500,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},400,400,300]
[null,{"$f":"IF(LEFT(Configurator!F$12,2)=\"AC\",Values!C14,IF(LEFT(Configurator!F$12,2)=\"DC\",Values!D14,\"\"))","v":""},"DBC: ≤300W, 1-2 OP","DAC: ≤150W, 1 OP","C",null,null,null,null,null,null,null,24,"MM: 1200","MM: 800",{"$f":"\"\"","v":""},"M: 600","M: 400",{"$f":"\"\"","v":""},"n: 300","n: 200","µ: 150","µ: 75",24,200,500,400,300,500,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},400,400,300]
[null,{"$f":"IF(LEFT(Configurator!F$12,2)=\"AC\",Values!C15,IF(LEFT(Configurator!F$12,2)=\"DC\",\"\",\"\"))","v":""},"DBD: ≤150W, 1 OP",null,{"$f":"IF(B15=\"\",\"\",\"D\")","v":""},null,null,null,null,null,null,null,28,"MM: 1200","MM: 800",{"$f":"\"\"","v":""},"M: 600","M: 400",{"$f":"\"\"","v":""},"n: 300","n: 200","µ: 150","µ: 75",28,200,500,400,300,500,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},400,400,300]
[null,null,null,null,null,null,null,null,null,null,null,null,32,"MM: 1200",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"M: 600",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},32,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,36,"MM: 1200","MM: 1000","MM: 800","M: 600","M: 500","M: 400","n: 300","n: 200","µ: 150","µ: 75",36,200,{"$f":"\"\"","v":""},400,300,500,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},400,400,300]
[null,"Power",null,null,null,null,null,null,null,null,null,null,48,"MM: 1200","MM: 800",{"$f":"\"\"","v":""},"M: 600","M: 400",{"$f":"\"\"","v":""},"n: 300","n: 200","µ: 150","µ: 75",48,200,{"$f":"\"\"","v":""},400,300,500,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},400,400,300]
[null,"Available power levels collection area",null,null,null,null,null,null,null,null,null,null,54,"MM: 1200",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"M: 600",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},54,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[1,{"$f":"IF(AND(Configurator!$F16<>\"\",LEFT(Configurator!F13,3)=\"DBA\"),VLOOKUP(Configurator!$F16,Values!$M$6:$W$19,2,FALSE),IF(OR(B26=\"\",Configurator!F16=\"\"),\"\",VLOOKUP(Configurator!F16,INDIRECT($B27),B26,FALSE)))","v":""},{"$f":"IF(AND(Configurator!$F16<>\"\",LEFT(Configurator!F13,3)=\"DBA\"),VLOOKUP(Configurator!$F16,Values!$M$6:$W$19,3,FALSE),IF(OR(C26=\"\",Configurator!F16=\"\"),\"\",VLOOKUP(Configurator!F16,INDIRECT($B27),C26,FALSE)))","v":""},{"$f":"IF(AND(Configurator!$F16<>\"\",LEFT(Configurator!F13,3)=\"DBA\"),VLOOKUP(Configurator!$F16,Values!$M$6:$W$19,4,FALSE),IF(OR(D26=\"\",Configurator!F16=\"\"),\"\",VLOOKUP(Configurator!F16,INDIRECT($B27),D26,FALSE)))","v":""},{"$f":"IF(AND(Configurator!$F16<>\"\",OR(LEFT(Configurator!F13,3)=\"DBA\",LEFT(Configurator!F13,3)=\"DBB\")),VLOOKUP(Configurator!$F16,Values!$M$6:$W$19,5,FALSE),\"\")","v":""},{"$f":"IF(AND(Configurator!$F16<>\"\",OR(LEFT(Configurator!F13,3)=\"DBA\",LEFT(Configurator!F13,3)=\"DBB\")),VLOOKUP(Configurator!$F16,Values!$M$6:$W$19,6,FALSE),\"\")","v":""},{"$f":"IF(AND(Configurator!$F16<>\"\",OR(LEFT(Configurator!F13,3)=\"DBA\",LEFT(Configurator!F13,3)=\"DBB\")),VLOOKUP(Configurator!$F16,Values!$M$6:$W$19,7,FALSE),\"\")","v":""},{"$f":"IF(AND(Configurator!$F16<>\"\",LEFT(Configurator!F13,3)<>\"DBD\",LEFT(Configurator!G17,2)<>\"µ:\",Configurator!F13<>\"\",LEFT(Configurator!F12,2)=\"AC\"),VLOOKUP(Configurator!$F16,Values!$M$6:$W$19,8,FALSE),\"\")","v":""},{"$f":"IF(AND(Configurator!$F16<>\"\",LEFT(Configurator!F13,3)<>\"DBD\",LEFT(Configurator!G17,2)<>\"µ:\",Configurator!F13<>\"\",LEFT(Configurator!F12,2)=\"AC\"),VLOOKUP(Configurator!$F16,Values!$M$6:$W$19,9,FALSE),\"\")","v":""},{"$f":"IF(OR(Configurator!$F16=\"\",LEFT(Configurator!G17,2)=\"n:\",LEFT(Configurator!F13,2)=\"DA\",Configurator!F12=\"\",Configurator!F13=\"\"),\"\",VLOOKUP(Configurator!$F16,Values!$M$6:$W$19,10,FALSE))","v":""},{"$f":"IF(OR(Configurator!$F16=\"\",LEFT(Configurator!G17,2)=\"n:\",LEFT(Configurator!F13,2)=\"DA\",Configurator!F12=\"\",Configurator!F13=\"\"),\"\",VLOOKUP(Configurator!$F16,Values!$M$6:$W$19,11,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M6","v":"N"},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"DAB"]
[2,null,null,null,null,null,null,{"$f":"IF(OR(Configurator!$F17=\"\",Configurator!$E17=\"\",LEFT(Configurator!F13,3)=\"DBC\",LEFT(Configurator!G16,2)=\"µ:\"),\"\",VLOOKUP(Configurator!$F17,Values!$M$6:$W$19,8,FALSE))","v":""},{"$f":"IF(OR(Configurator!$F17=\"\",Configurator!$E17=\"\",LEFT(Configurator!F13,3)=\"DBC\",LEFT(Configurator!G16,2)=\"µ:\"),\"\",VLOOKUP(Configurator!$F17,Values!$M$6:$W$19,9,FALSE))","v":""},{"$f":"IF(OR(Configurator!$F17=\"\",Configurator!$E17=\"\",LEFT(Configurator!G16,2)=\"n:\"),\"\",VLOOKUP(Configurator!$F17,Values!$M$6:$W$19,10,FALSE))","v":""},{"$f":"IF(OR(Configurator!$F17=\"\",Configurator!$E17=\"\",LEFT(Configurator!G16,2)=\"n:\"),\"\",VLOOKUP(Configurator!$F17,Values!$M$6:$W$19,11,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M7","v":2},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[3,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Configurator!$F18<>\"\",Configurator!$E18<>\"\"),VLOOKUP(Configurator!$F18,Values!$M$6:$W$19,10,FALSE),\"\")","v":""},{"$f":"IF(AND(Configurator!$F18<>\"\",Configurator!$E18<>\"\"),VLOOKUP(Configurator!$F18,Values!$M$6:$W$19,11,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"3V3",75,{"$f":"\"\"","v":""},150,100,150,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},100,100,75]
[4,null,null,null,{"$f":"IF(AND(Configurator!$F19<>\"\",Configurator!$E19<>\"\"),VLOOKUP(Configurator!$F19,Values!$M$6:$W$19,5,FALSE),\"\")","v":""},{"$f":"IF(AND(Configurator!$F19<>\"\",Configurator!$E19<>\"\"),VLOOKUP(Configurator!$F19,Values!$M$6:$W$19,6,FALSE),\"\")","v":""},{"$f":"IF(AND(Configurator!$F19<>\"\",Configurator!$E19<>\"\"),VLOOKUP(Configurator!$F19,Values!$M$6:$W$19,7,FALSE),\"\")","v":""},{"$f":"IF(AND(Configurator!$F19<>\"\",Configurator!$E19<>\"\",LEFT(Configurator!G20,2)<>\"µ:\"),VLOOKUP(Configurator!$F19,Values!$M$6:$W$19,8,FALSE),\"\")","v":""},{"$f":"IF(AND(Configurator!$F19<>\"\",Configurator!$E19<>\"\",LEFT(Configurator!G20,2)<>\"µ:\"),VLOOKUP(Configurator!$F19,Values!$M$6:$W$19,9,FALSE),\"\")","v":""},{"$f":"IF(AND(Configurator!$F19<>\"\",Configurator!$E19<>\"\",LEFT(Configurator!G20,2)<>\"n:\"),VLOOKUP(Configurator!$F19,Values!$M$6:$W$19,10,FALSE),\"\")","v":""},{"$f":"IF(AND(Configurator!$F19<>\"\",Configurator!$E19<>\"\",LEFT(Configurator!G20,2)<>\"n:\"),VLOOKUP(Configurator!$F19,Values!$M$6:$W$19,11,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,5,75,{"$f":"\"\"","v":""},200,150,200,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},150,150,100]
[5,null,null,null,null,null,null,{"$f":"IF(AND(Configurator!$F20<>\"\",Configurator!$E20<>\"\",LEFT(Configurator!G19,2)<>\"µ:\"),VLOOKUP(Configurator!$F20,Values!$M$6:$W$19,8,FALSE),\"\")","v":""},{"$f":"IF(AND(Configurator!$F20<>\"\",Configurator!$E20<>\"\",LEFT(Configurator!G19,2)<>\"µ:\"),VLOOKUP(Configurator!$F20,Values!$M$6:$W$19,9,FALSE),\"\")","v":""},{"$f":"IF(AND(Configurator!$F20<>\"\",Configurator!$E20<>\"\",LEFT(Configurator!G19,2)<>\"n:\"),VLOOKUP(Configurator!$F20,Values!$M$6:$W$19,10,FALSE),\"\")","v":""},{"$f":"IF(AND(Configurator!$F20<>\"\",Configurator!$E20<>\"\",LEFT(Configurator!G19,2)<>\"n:\"),VLOOKUP(Configurator!$F20,Values!$M$6:$W$19,11,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"6V5",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},200,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[6,null,null,null,null,null,null,null,null,{"$f":"IF(Configurator!$E21<>\"\",VLOOKUP(Configurator!$F21,Values!$M$6:$W$19,10,FALSE),\"\")","v":""},{"$f":"IF(Configurator!$E21<>\"\",VLOOKUP(Configurator!$F21,Values!$M$6:$W$19,11,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},200,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},150,150,{"$f":"\"\"","v":""}]
["Column number",{"$f":"IF(B27<>\"\",IF(AND(Configurator!M10=24,Configurator!AF10=\"W\"),2,IF(AND(Configurator!M10=24,Configurator!AF10=\"\"),3,IF(Configurator!M10=48,6,IF(Configurator!M10=72,9,IF(Configurator!M10=110,10,\"\"))))),\"\")","v":""},{"$f":"IF(B27<>\"\",IF(AND(Configurator!M10=24,Configurator!AF10=\"\"),4,IF(Configurator!M10=48,7,IF(Configurator!M10=110,11,\"\"))),\"\")","v":""},{"$f":"IF(B27<>\"\",IF(AND(Configurator!M10=24,Configurator!AF10=\"\"),5,IF(Configurator!M10=48,8,\"\")),\"\")","v":""},"<- VLOOKUP columns for DC/DC convertrs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,125,250,200,150,250,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},250,200,150]
["Table range",{"$f":"IF(LEFT(Configurator!F13,3)=\"DAA\",\"X6:AH19\",IF(LEFT(Configurator!F13,3)=\"DAB\",\"X20:AH33\",IF(LEFT(Configurator!F13,3)=\"DAC\",\"X34:AH47\",\"\")))","v":""},null,null,"<- VLOOKUP table range for DC/DC convertrs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,150,{"$f":"\"\"","v":""},200,150,250,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},250,200,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,150,250,200,150,250,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},250,200,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,150,250,200,150,250,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},250,200,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,150,{"$f":"\"\"","v":""},200,150,250,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},250,200,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,150,250,200,150,300,250,{"$f":"\"\"","v":""},250,200,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","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":"M6","v":"N"},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},"DAC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M7","v":2},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3V3",50,{"$f":"\"\"","v":""},75,50,{"$f":"\"\"","v":""},75,50,75,{"$f":"\"\"","v":""},50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,50,125,100,50,100,75,50,100,{"$f":"\"\"","v":""},75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6V5",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},100,{"$f":"\"\"","v":""},150,100,{"$f":"\"\"","v":""},100,{"$f":"\"\"","v":""},75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,100,150,100,50,150,75,{"$f":"\"\"","v":""},150,100,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,100,150,100,50,150,75,{"$f":"\"\"","v":""},150,100,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,100,150,100,50,150,75,{"$f":"\"\"","v":""},150,100,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,100,150,100,50,150,75,{"$f":"\"\"","v":""},150,100,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,100,{"$f":"\"\"","v":""},100,50,150,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},150,100,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,100,150,100,50,150,75,{"$f":"\"\"","v":""},150,150,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]