{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Cálculo secciones CC"],"not_rendered":{"images":1,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Cálculo secciones CC","index":0,"n_rows":29,"n_cols":20,"rows_kept":29,"merged":[[0,0,2,1],[0,2,0,5],[0,6,28,6],[0,7,0,10],[0,11,28,11],[0,12,0,13],[0,14,28,14],[0,20,28,20],[1,2,1,3],[1,4,1,5],[1,7,1,8],[1,9,1,10],[1,12,1,13],[1,15,2,16],[1,18,2,19],[2,2,2,3],[2,4,2,5],[2,7,2,8],[2,9,2,10],[2,12,2,13],[3,0,4,0],[3,2,3,3],[3,4,3,5],[3,7,3,8],[3,9,3,10],[3,12,3,13],[4,18,4,19],[5,2,5,3],[5,4,5,5],[5,7,5,8],[5,9,5,10],[5,12,5,13],[5,18,5,19],[6,2,6,3],[6,4,6,5],[6,7,6,8],[6,9,6,10],[6,12,6,13],[6,18,6,19],[7,2,7,3],[7,4,7,5],[7,7,7,8],[7,9,7,10],[7,12,7,13],[7,18,7,19],[8,2,8,3],[8,4,8,5],[8,7,8,8],[8,9,8,10],[8,12,8,13],[8,18,8,19],[9,0,10,0],[9,2,9,3],[9,4,9,5],[9,7,9,8],[9,9,9,10],[9,12,9,13],[9,18,9,19],[10,2,10,3],[10,4,10,5],[10,7,10,8],[10,9,10,10],[10,12,10,13],[10,18,10,19],[11,0,13,0],[11,2,11,3],[11,4,11,5],[11,7,11,8],[11,9,11,10],[11,12,11,13],[11,18,11,19],[12,2,12,3],[12,4,12,5],[12,7,12,8],[12,9,12,10],[12,12,12,13],[12,18,12,19],[13,2,13,3],[13,4,13,5],[13,7,13,8],[13,9,13,10],[13,12,13,13],[13,18,13,19],[14,2,14,3],[14,4,14,5],[14,7,14,8],[14,9,14,10],[14,12,14,13],[14,18,14,19],[15,0,17,0],[15,18,15,19],[16,2,16,3],[16,4,16,5],[16,7,16,8],[16,9,16,10],[16,12,16,13],[16,18,16,19],[17,2,17,3],[17,4,17,5],[17,7,17,8],[17,9,17,10],[17,12,17,13],[17,18,17,19],[18,0,19,0],[18,2,18,3],[18,4,18,5],[18,7,18,8],[18,9,18,10],[18,12,18,13],[18,18,18,19],[19,2,19,3],[19,4,19,5],[19,7,19,8],[19,9,19,10],[19,12,19,13],[19,18,19,19],[20,0,21,0],[20,2,20,3],[20,4,20,5],[20,7,20,8],[20,9,20,10],[20,12,20,13],[20,18,20,19],[21,2,21,3],[21,4,21,5],[21,7,21,8],[21,9,21,10],[21,12,21,13],[22,0,24,0],[22,15,27,16],[22,18,22,19],[23,2,23,3],[23,4,23,5],[23,7,23,8],[23,9,23,10],[23,12,23,13],[24,2,24,3],[24,4,24,5],[24,7,24,8],[24,9,24,10],[24,12,24,13],[25,0,26,0],[25,2,25,3],[25,4,25,5],[25,7,25,8],[25,9,25,10],[25,12,25,13],[26,2,26,3],[26,4,26,5],[26,7,26,8],[26,9,26,10],[26,12,26,13],[27,0,28,0],[27,2,27,3],[27,4,27,5],[27,7,27,8],[27,9,27,10],[27,12,27,13],[28,2,28,3],[28,4,28,5],[28,7,28,8],[28,9,28,10],[28,12,28,13]]}
["Cálculo automático de secciones CC  ",null,"A W G  -  C O B R E",{"$nulls":4},"R T B  -  C O B R E",{"$nulls":4},"RTB - ALUMINIO"]
[null,null,"BATERIAS",null,"Placas",null,null,"PANELES",null,"REGULADOR-BAT",null,null,"PANELES",null,null,"AWG",null,null," R T B"]
[null,null,"MOLINETE",null,"MidNite",null,null,"REGULADOR",{"$nulls":4},"REGULADOR"]
["Datos constantes","  Nº de cables (+ y -)",2,null,2,null,null,2,null,2,null,null,2]
[null,"  Resistividad del Conductor","Cu",{"$f":"1/IF($S$29=1,56,IF($S$29=2,54,IF($S$29=3,52,IF($S$29=4,50,48))))","v":{"v":0.017857142857142856,"d":"0.0179"}},"Cu",{"$f":"1/IF($S$29=1,56,IF($S$29=2,54,IF($S$29=3,52,IF($S$29=4,50,48))))","v":{"v":0.017857142857142856,"d":"0.0179"}},null,"Cu",{"$f":"1/IF($S$29=1,56,IF($S$29=2,54,IF($S$29=3,52,IF($S$29=4,50,48))))","v":{"v":0.017857142857142856,"d":"0.0179"}},"Cu",{"$f":"1/IF($S$29=1,56,IF($S$29=2,54,IF($S$29=3,52,IF($S$29=4,50,48))))","v":{"v":0.017857142857142856,"d":"0.0179"}},null,"Al",{"$f":"1/IF($S$29=1,35,IF($S$29=2,33.75,IF($S$29=3,32.5,IF($S$29=4,31.25,30))))","v":{"v":0.02857142857142857,"d":"0.0286"}},null,"AWG 13",{"v":2.63,"d":"2.63 mm2"},null,{"v":0.75,"d":"0.75 mm2"}]
["...la potencia de trabajo en W","  Vatios Totales",{"v":1000,"d":"1000 w"},null,{"v":780,"d":"780 w"},null,null,{"v":1600,"d":"1600 w"},null,{"v":1600,"d":"1600 w"},null,null,{"v":1600,"d":"1600 w"},null,null,"AWG 12",{"v":3.31,"d":"3.31 mm2"},null,{"v":1,"d":"1.00 mm2"}]
["...longitud de un punto a otro","  Metros de Cable",{"v":11.4,"d":"11.40 m"},null,{"v":5.1,"d":"5.10 m"},null,null,{"v":52,"d":"52.00 m"},null,{"v":1.3,"d":"1.30 m"},null,null,{"v":52,"d":"52.00 m"},null,null,"AWG 11",{"v":4.15,"d":"4.15 mm2"},null,{"v":1.5,"d":"1.50 mm2"}]
["...en voltios, siempre > 0","  Caida de Tension en %",{"v":3,"d":"3.00%"},null,{"v":1,"d":"1.00%"},null,null,{"v":2,"d":"2.00%"},null,{"v":1,"d":"1.00%"},null,null,{"v":2,"d":"2.00%"},null,null,"AWG 10",{"v":5.27,"d":"5.27 mm2"},null,{"v":2.5,"d":"2.50 mm2"}]
["...voltaje de trabajo ","  Voltaje de Trabajo",{"v":12,"d":"12 v"},null,{"v":24,"d":"24 v"},null,null,{"v":48,"d":"48 v"},null,{"v":24,"d":"24 v"},null,null,{"v":48,"d":"48 v"},null,null,"AWG 9",{"v":6.62,"d":"6.62 mm2"},null,{"v":4,"d":"4.00 mm2"}]
["Resultados estrictos","  Amperios",{"$f":"C6/C9","v":{"v":83.33333333333333,"d":"83.33 A"}},null,{"$f":"E6/E9","v":{"v":32.5,"d":"32.50 A"}},null,null,{"$f":"H6/H9","v":{"v":33.333333333333336,"d":"33.33 A"}},null,{"$f":"J6/J9","v":{"v":66.66666666666667,"d":"66.67 A"}},null,null,{"$f":"M6/M9","v":{"v":33.333333333333336,"d":"33.33 A"}},null,null,"AWG 8",{"v":8.35,"d":"8.35 mm2"},null,{"v":6,"d":"6.00 mm2"}]
[null,"  Sección  total",{"$f":"(C4*C7*C10*D5)/(C9*C8/100)","v":{"v":94.24603174603173,"d":"94.25 mm2"}},null,{"$f":"(E4*E7*E10*F5)/(E9*E8/100)","v":{"v":24.66517857142857,"d":"24.67 mm2"}},null,null,{"$f":"(H4*H7*H10*I5)/(H9*H8/100)","v":{"v":64.48412698412699,"d":"64.48 mm2"}},null,{"$f":"(J4*J7*J10*K5)/(J9*J8/100)","v":{"v":12.896825396825397,"d":"12.90 mm2"}},null,null,{"$f":"(M4*M7*M10*N5)/(M9*M8/100)","v":{"v":103.17460317460318,"d":"103.17 mm2"}},null,null,"AWG 7",{"v":10.6,"d":"10.60 mm2"},null,{"v":10,"d":"10.00 mm2"}]
["Caída de tensión y pérdida real de vatios en función de la sección estricta","  Diámetro del cable",{"$f":"2*SQRT(C11/PI())","v":{"v":10.95434957235769,"d":"10.95 mm"}},null,{"$f":"2*SQRT(E11/PI())","v":{"v":5.603987931383971,"d":"5.60 mm"}},null,null,{"$f":"2*SQRT(H11/PI())","v":{"v":9.061111437561856,"d":"9.06 mm"}},null,{"$f":"2*SQRT(J11/PI())","v":{"v":4.0522522252178295,"d":"4.05 mm"}},null,null,{"$f":"2*SQRT(M11/PI())","v":{"v":11.461500110119216,"d":"11.46 mm"}},null,null,"AWG 6",{"v":13.3,"d":"13.30 mm2"},null,{"v":16,"d":"16.00 mm2"}]
[null,"  Caída de Tension (v)",{"$f":"C9*C8/100","v":{"v":0.36,"d":"0.36 v"}},null,{"$f":"E9*E8/100","v":{"v":0.24,"d":"0.24 v"}},null,null,{"$f":"H9*H8/100","v":{"v":0.96,"d":"0.96 v"}},null,{"$f":"J9*J8/100","v":{"v":0.24,"d":"0.24 v"}},null,null,{"$f":"M9*M8/100","v":{"v":0.96,"d":"0.96 v"}},null,null,"AWG 5",{"v":16.8,"d":"16.80 mm2"},null,{"v":25,"d":"25.00 mm2"}]
[null,"  Pérdida de Vatios",{"$f":"C6*C8/100","v":{"v":30,"d":"30.00 w"}},null,{"$f":"E6*E8/100","v":{"v":7.8,"d":"7.80 w"}},null,null,{"$f":"H6*H8/100","v":{"v":32,"d":"32.00 w"}},null,{"$f":"J6*J8/100","v":{"v":16,"d":"16.00 w"}},null,null,{"$f":"M6*M8/100","v":{"v":32,"d":"32.00 w"}},null,null,"AWG 4",{"v":21.2,"d":"21.20 mm2"},null,{"v":35,"d":"35.00 mm2"}]
["Sección varios cables ","  mm2 de Seccion estricta por cada cable",{"$f":"C11/C16","v":{"v":94.24603174603173,"d":"94.25 mm2"}},null,{"$f":"E11/E16","v":{"v":24.66517857142857,"d":"24.67 mm2"}},null,null,{"$f":"H11/H16","v":{"v":64.48412698412699,"d":"64.48 mm2"}},null,{"$f":"J11/J16","v":{"v":12.896825396825397,"d":"12.90 mm2"}},null,null,{"$f":"M11/M16","v":{"v":103.17460317460318,"d":"103.17 mm2"}},null,null,"AWG 3",{"v":27,"d":"27.00 mm2"},null,{"v":50,"d":"50.00 mm2"}]
[" Sección comercial","  Mínimo núm. de pares de cable  (1 + y 1 -)",{"$f":"INT(C11/Q21+1)","v":1},"AWG 0000",{"$f":"INT(E11/Q21+1)","v":1},"AWG 3",null,{"$f":"INT(H11/S21+1)","v":1},"RBT   de",{"$f":"INT(J11/S21+1)","v":1},"RBT   de",null,{"$f":"INT(M11/S21+1)","v":1},"RBT   de",null,"AWG 2",{"v":33.6,"d":"33.60 mm2"},null,{"v":70,"d":"70.00 mm2"}]
[null,"  mm2 de Seccion comercial por cada cable",{"v":107.2,"d":"107.20 mm2"},null,{"v":27,"d":"27.00 mm2"},null,null,{"v":70,"d":"70.00 mm2"},null,{"v":16,"d":"16.00 mm2"},null,null,{"v":120,"d":"120.00 mm2"},null,null,"AWG 1",{"v":42.4,"d":"42.40 mm2"},null,{"v":95,"d":"95.00 mm2"}]
[null,"  mm2 de Seccion total por polo",{"$f":"C17*C16","v":{"v":107.2,"d":"107.20 mm2"}},null,{"$f":"E17*E16","v":{"v":27,"d":"27.00 mm2"}},null,null,{"$f":"H17*H16","v":{"v":70,"d":"70.00 mm2"}},null,{"$f":"J17*J16","v":{"v":16,"d":"16.00 mm2"}},null,null,{"$f":"M16*M17","v":{"v":120,"d":"120.00 mm2"}},null,null,"AWG 0",{"v":53.47,"d":"53.47 mm2"},null,{"v":120,"d":"120.00 mm2"}]
["Resultados definitivos","  Diámetro de los cables",{"$f":"2*SQRT(C17/PI())","v":{"v":11.682948223612456,"d":"11.68 mm"}},null,{"$f":"2*SQRT(E17/PI())","v":{"v":5.863230142835039,"d":"5.86 mm"}},null,null,{"$f":"2*SQRT(H17/PI())","v":{"v":9.440697438826296,"d":"9.44 mm"}},null,{"$f":"2*SQRT(J17/PI())","v":{"v":4.51351666838205,"d":"4.51 mm"}},null,null,{"$f":"2*SQRT(M17/PI())","v":{"v":12.360774464742066,"d":"12.36 mm"}},null,null,"AWG 00",{"v":67.42,"d":"67.42 mm2"},null,{"v":150,"d":"150.00 mm2"}]
[null,"  Caida total de Tensión en Voltios",{"$f":"C4*C7*C10*D5/C18","v":{"v":0.3164978678038379,"d":"0.32 v"}},null,{"$f":"E4*E7*E10*F5/E18","v":{"v":0.21924603174603174,"d":"0.22 v"}},null,null,{"$f":"H4*H7*H10*I5/H18","v":{"v":0.8843537414965986,"d":"0.88 v"}},null,{"$f":"J4*J7*J10*K5/J18","v":{"v":0.19345238095238096,"d":"0.19 v"}},null,null,{"$f":"M4*M7*M10*N5/M18","v":{"v":0.8253968253968255,"d":"0.83 v"}},null,null,"AWG 000",{"v":85,"d":"85.00 mm2"},null,{"v":185,"d":"185.00 mm2"}]
["Caída de tensión y pérdida real de vatios en función de la sección requerida","  Caida total de Tensión en %",{"$f":"C20/C9","v":{"v":0.02637482231698649,"d":"2.64%"}},null,{"$f":"E20/E9","v":{"v":0.009135251322751323,"d":"0.91%"}},null,null,{"$f":"H20/H9","v":{"v":0.018424036281179137,"d":"1.84%"}},null,{"$f":"J20/J9","v":{"v":0.008060515873015874,"d":"0.81%"}},null,null,{"$f":"M20/M9","v":{"v":0.0171957671957672,"d":"1.72%"}},null,null,"AWG 0000",{"v":107.2,"d":"107.20 mm2"},null,{"v":240,"d":"240.00 mm2"}]
[null,"  Pérdida total de Vatios",{"$f":"C6*C21","v":{"v":26.37482231698649,"d":"26.37 w"}},null,{"$f":"E6*E21","v":{"v":7.125496031746032,"d":"7.13 w"}},null,null,{"$f":"H6*H21","v":{"v":29.47845804988662,"d":"29.48 w"}},null,{"$f":"J6*J21","v":{"v":12.896825396825399,"d":"12.90 w"}},null,null,{"$f":"M6*M21","v":{"v":27.513227513227516,"d":"27.51 w"}}]
["Cambio de sección","  Número de pares de cable  (1 + y 1 -)",{"$f":"INT(C11/C24+0.9)","v":2},"AWG 0",{"$f":"INT(E11/E24+0.9)","v":10},"AWG 13",null,{"$f":"INT(H11/H24+0.9)","v":2},"RBT   de",{"$f":"INT(J11/J24+0.9)","v":1},"RBT   de",null,{"$f":"INT(M11/M24+0.9)","v":2},"RBT   de",{"$nulls":4},"TEMPERATURA"]
[null,"  mm2 de Seccion elegida por cada cable",{"$f":"VLOOKUP(D23,$P$5:$Q$21,2,FALSE)","v":{"v":53.47,"d":"53.47 mm2"}},null,{"$f":"VLOOKUP(F23,$P$5:$Q$21,2,FALSE)","v":{"v":2.63,"d":"2.63 mm2"}},null,null,{"v":35,"d":"35.00 mm2"},null,{"v":25,"d":"25.00 mm2"},null,null,{"v":50,"d":"50.00 mm2"},{"$nulls":6},"20º"]
[null,"  mm2 de la seccion elegida por polo",{"$f":"C24*C23","v":{"v":106.94,"d":"106.94 mm2"}},null,{"$f":"E24*E23","v":{"v":26.299999999999997,"d":"26.30 mm2"}},null,null,{"$f":"H23*H24","v":{"v":70,"d":"70.00 mm2"}},null,{"$f":"J23*J24","v":{"v":25,"d":"25.00 mm2"}},null,null,{"$f":"M23*M24","v":{"v":100,"d":"100.00 mm2"}},{"$nulls":6},"30º"]
["Resultados definitivos","  Diámetro de los cables",{"$f":"2*SQRT(C24/PI())","v":{"v":8.25106771618008,"d":"8.25 mm"}},null,{"$f":"2*SQRT(E24/PI())","v":{"v":1.8299234963936273,"d":"1.83 mm"}},null,null,{"$f":"2*SQRT(H24/PI())","v":{"v":6.6755811781245455,"d":"6.68 mm"}},null,{"$f":"2*SQRT(J24/PI())","v":{"v":5.641895835477563,"d":"5.64 mm"}},null,null,{"$f":"2*SQRT(M24/PI())","v":{"v":7.978845608028654,"d":"7.98 mm"}},{"$nulls":6},"40º"]
[null,"  Caida total de Tensión en Voltios",{"$f":"C4*C7*C10*D5/C25","v":{"v":0.3172673595340511,"d":"0.32 v"}},null,{"$f":"E4*E7*E10*F5/E25","v":{"v":0.22508147745790333,"d":"0.23 v"}},null,null,{"$f":"H4*H7*H10*I5/H25","v":{"v":0.8843537414965986,"d":"0.88 v"}},null,{"$f":"J4*J7*J10*K5/J25","v":{"v":0.12380952380952381,"d":"0.12 v"}},null,null,{"$f":"M4*M7*M10*N5/M25","v":{"v":0.9904761904761905,"d":"0.99 v"}},{"$nulls":6},"50º"]
["Caída de tensión y pérdida real de vatios en función de la sección elegida","  Caida total de Tensión en %",{"$f":"C27/C9","v":{"v":0.026438946627837592,"d":"2.64%"}},null,{"$f":"E27/E9","v":{"v":0.009378394894079305,"d":"0.94%"}},null,null,{"$f":"H27/H9","v":{"v":0.018424036281179137,"d":"1.84%"}},null,{"$f":"J27/J9","v":{"v":0.005158730158730159,"d":"0.52%"}},null,null,{"$f":"M27/M9","v":{"v":0.020634920634920634,"d":"2.06%"}},{"$nulls":6},"60º"]
[null,"  Pérdida total de Vatios",{"$f":"C6*C28","v":{"v":26.43894662783759,"d":"26.44 w"}},null,{"$f":"E6*E28","v":{"v":7.315148017381858,"d":"7.32 w"}},null,null,{"$f":"H6*H28","v":{"v":29.47845804988662,"d":"29.48 w"}},null,{"$f":"J6*J28","v":{"v":8.253968253968253,"d":"8.25 w"}},null,null,{"$f":"M6*M28","v":{"v":33.01587301587301,"d":"33.02 w"}},{"$nulls":5},1]