{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Form","Modules","Regulator","Calculation table","Version","Language"],"not_rendered":{"charts":2,"images":9,"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":"Form","index":0,"n_rows":42,"n_cols":21,"rows_kept":42,"cut":false,"hidden":false,"merged":[[16,7,16,8],[5,7,5,8],[34,9,34,10],[34,7,34,8],[0,2,1,6],[17,4,17,5],[17,7,17,8]]}
[null,null,"Blue Solar charge controller MPPT",null,null,null,null,null,null,null,null,null,{"$f":"IF(J3=6,INDEX(Language!B4:G41,29,6),IF(J3=5,INDEX(Language!B4:F35,29,1),IF(J3=4,INDEX(Language!B4:F35,29,2),IF(J3=3,INDEX(Language!B4:F35,29,3),IF(J3=2,INDEX(Language!B4:F35,29,4),INDEX(Language!B4:F35,29,5))))))","v":"Faixa de voltagem"},null,null,null,null,null,null,null,{"$f":"IF(J3=6,INDEX(Language!B4:G41,30,6),IF(J3=5,INDEX(Language!B4:F35,30,1),IF(J3=4,INDEX(Language!B4:F35,30,2),IF(J3=3,INDEX(Language!B4:F35,30,3),IF(J3=2,INDEX(Language!B4:F35,30,4),INDEX(Language!B4:F35,30,5))))))","v":"Faixa de corrente"}]
[]
[null,null,null,null,null,null,null,null,null,6]
[null,{"$f":"IF(J3=6,INDEX(Language!B4:G35,1,6),IF(J3=5,INDEX(Language!B4:G35,1,1),IF(J3=4,INDEX(Language!B4:G35,1,2),IF(J3=3,INDEX(Language!B4:G35,1,3),IF(J3=2,INDEX(Language!B4:G35,1,4),INDEX(Language!B4:G35,1,5))))))","v":"Módulo FV"},null,23]
[]
[null,{"$f":"IF(J3=6,INDEX(Language!B4:G35,2,6),IF(J3=5,INDEX(Language!B4:F35,2,1),IF(J3=4,INDEX(Language!B4:F35,2,2),IF(J3=3,INDEX(Language!B4:F35,2,3),IF(J3=2,INDEX(Language!B4:F35,2,4),INDEX(Language!B4:F35,2,5))))))","v":"Quantos módulos? Em serie:"},null,2,null,null,{"$f":"IF(J3=6,INDEX(Language!B4:G35,3,6),IF(J3=5,INDEX(Language!B4:F35,3,1),IF(J3=4,INDEX(Language!B4:F35,3,2),IF(J3=3,INDEX(Language!B4:F35,3,3),IF(J3=2,INDEX(Language!B4:F35,3,4),INDEX(Language!B4:F35,3,5))))))","v":"Em paralelo"},3]
[]
[null,{"$f":"IF(J3=6,INDEX(Language!B4:G35,4,6),IF(J3=5,INDEX(Language!B4:F35,4,1),IF(J3=4,INDEX(Language!B4:F35,4,2),IF(J3=3,INDEX(Language!B4:F35,4,3),IF(J3=2,INDEX(Language!B4:F35,4,4),INDEX(Language!B4:F35,4,5))))))","v":"Potência total FV @STC"},null,{"$f":"D6*H6*INDEX(Modules!B3:J34,Form!D4,3)","v":2400},{"$f":"IF(J3=6,INDEX(Language!B4:G35,5,6),IF(J3=5,INDEX(Language!B4:F35,5,1),IF(J3=4,INDEX(Language!B4:F35,5,2),IF(J3=3,INDEX(Language!B4:F35,5,3),IF(J3=2,INDEX(Language!B4:F35,5,4),INDEX(Language!B4:F35,5,5))))))","v":"Wp"}]
[null,{"$f":"IF(G24=\"N.A.\",\"\",IF('Calculation table'!C49>1.3,IF(J3=6,INDEX(Language!B4:G51,39,6),IF(J3=5,INDEX(Language!B4:F42,39,1),IF(J3=4,INDEX(Language!B4:F42,39,2),IF(J3=3,INDEX(Language!B4:F42,39,3),IF(J3=2,INDEX(Language!B4:F42,39,4),INDEX(Language!B4:F42,39,5)))))),\"\"))","v":""}]
[null,{"$f":"IF(G25=\"N.A.\",\"\",IF('Calculation table'!E50=TRUE,IF(J3=6,INDEX(Language!B4:G52,49,6),IF(J3=5,INDEX(Language!B4:F52,49,1),IF(J3=4,INDEX(Language!B4:F52,49,2),IF(J3=3,INDEX(Language!B4:F52,49,3),IF(J3=2,INDEX(Language!B4:F52,49,4),INDEX(Language!B4:F52,49,5)))))),\"\"))","v":""}]
[null,{"$f":"IF(J3=6,INDEX(Language!B4:G35,6,6),IF(J3=5,INDEX(Language!B4:F35,6,1),IF(J3=4,INDEX(Language!B4:F35,6,2),IF(J3=3,INDEX(Language!B4:F35,6,3),IF(J3=2,INDEX(Language!B4:F35,6,4),INDEX(Language!B4:F35,6,5))))))","v":"Temp. módulo FV "},"°C",{"$f":"IF(J3=6,INDEX(Language!B4:G35,7,6),IF(J3=5,INDEX(Language!B4:F35,7,1),IF(J3=4,INDEX(Language!B4:F35,7,2),IF(J3=3,INDEX(Language!B4:F35,7,3),IF(J3=2,INDEX(Language!B4:F35,7,4),INDEX(Language!B4:F35,7,5))))))","v":"Min."},{"$f":"IF(B12=1, F12, ((F12)*9/5)+32)","v":0},{"$f":"IF(B12=1, \"°C\", \"°F\")","v":"°C"},{"$f":"IF(J3=6,INDEX(Language!B4:G35,8,6),IF(J3=5,INDEX(Language!B4:F35,8,1),IF(J3=4,INDEX(Language!B4:F35,8,2),IF(J3=3,INDEX(Language!B4:F35,8,3),IF(J3=2,INDEX(Language!B4:F35,8,4),INDEX(Language!B4:F35,8,5))))))","v":"Max."},{"$f":"IF(B12=1, H12, (H12*9/5)+32)","v":70},{"$f":"IF(B12=1, \"°C\", \"°F\")","v":"°C"},null,null,null,null,2.5]
[null,1,"°F",null,40,{"$f":"E12-40","v":0},null,70,null,null,null,null,{"$f":"INDEX(Regulator!K2:N18,Form!$D$13,1)","v":12},4]
[null,{"$f":"IF(J3=6,INDEX(Language!B4:G35,9,6),IF(J3=5,INDEX(Language!B4:F35,9,1),IF(J3=4,INDEX(Language!B4:F35,9,2),IF(J3=3,INDEX(Language!B4:F35,9,3),IF(J3=2,INDEX(Language!B4:F35,9,4),INDEX(Language!B4:F35,9,5))))))","v":"Controlador"},null,9,null,null,null,null,null,null,null,null,{"$f":"INDEX(Regulator!K2:N18,Form!$D$13,2)","v":24},6]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Regulator!K2:N18,Form!$D$13,3)","v":36},10]
[null,{"$f":"IF(J3=6,INDEX(Language!B4:G35,10,6),IF(J3=5,INDEX(Language!B4:F35,10,1),IF(J3=4,INDEX(Language!B4:F35,10,2),IF(J3=3,INDEX(Language!B4:F35,10,3),IF(J3=2,INDEX(Language!B4:F35,10,4),INDEX(Language!B4:F35,10,5))))))","v":"Voltagem do sistema "},null,null,4,null,"Volt",null,null,null,null,null,{"$f":"INDEX(Regulator!K2:N18,Form!$D$13,4)","v":48},16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,{"$f":"IF(J3=6,INDEX(Language!B4:G35,31,6),IF(J3=5,INDEX(Language!B4:F35,31,1),IF(J3=4,INDEX(Language!B4:F35,31,2),IF(J3=3,INDEX(Language!B4:F35,31,3),IF(J3=2,INDEX(Language!B4:F35,31,4),INDEX(Language!B4:F35,31,5))))))","v":"Comprimento do cabo entre o modulo e o MPPT *"},null,null,null,null,null,10,null,3,null,null,null,35]
[null,{"$f":"IF(J3=6,INDEX(Language!B4:G35,32,6),IF(J3=5,INDEX(Language!B4:F35,32,1),IF(J3=4,INDEX(Language!B4:F35,32,2),IF(J3=3,INDEX(Language!B4:F35,32,3),IF(J3=2,INDEX(Language!B4:F35,32,4),INDEX(Language!B4:F35,32,5))))))","v":"Corte transversal:"},null,null,null,null,null,{"$f":"INDEX(N11:N17,J17,1)","v":6}]
[null,{"$f":"IF(J3=6,INDEX(Language!B4:G36,33,6),IF(J3=5,INDEX(Language!B4:F36,33,1),IF(J3=4,INDEX(Language!B4:F36,33,2),IF(J3=3,INDEX(Language!B4:F36,33,3),IF(J3=2,INDEX(Language!B4:F36,33,4),INDEX(Language!B4:F36,33,5))))))","v":" * Distância de um só cabo"}]
[null,{"$f":"IF(J3=6,INDEX(Language!B4:G36,11,6),IF(J3=5,INDEX(Language!B4:F35,11,1),IF(J3=4,INDEX(Language!B4:F35,11,2),IF(J3=3,INDEX(Language!B4:F35,11,3),IF(J3=2,INDEX(Language!B4:F35,11,4),INDEX(Language!B4:F35,11,5))))))","v":"Voltagem máxima de entrada "},null,null,null,null,{"$f":"INDEX(Regulator!$B$2:$H$18,Form!$D$13,7)","v":150}]
[null,{"$f":"IF(J3=6,INDEX(Language!B4:G36,12,6),IF(J3=5,INDEX(Language!B4:F35,12,1),IF(J3=4,INDEX(Language!B4:F35,12,2),IF(J3=3,INDEX(Language!B4:F35,12,3),IF(J3=2,INDEX(Language!B4:F35,12,4),INDEX(Language!B4:F35,12,5))))))","v":"Voltagem max FV@Temp min "},null,null,null,null,{"$f":"'Calculation table'!F30","v":106.57199999999999}]
[null,{"$f":"IF(J3=6,INDEX(Language!B4:G36,13,6),IF(J3=5,INDEX(Language!B4:F35,13,1),IF(J3=4,INDEX(Language!B4:F35,13,2),IF(J3=3,INDEX(Language!B4:F35,13,3),IF(J3=2,INDEX(Language!B4:F35,13,4),INDEX(Language!B4:F35,13,5))))))","v":"Voltagem min. de entrada  @ MPPT"},null,null,null,null,{"$f":"'Calculation table'!C20","v":49}]
[null,{"$f":"IF(J3=6,INDEX(Language!B4:G36,14,6),IF(J3=5,INDEX(Language!B4:F35,14,1),IF(J3=4,INDEX(Language!B4:F35,14,2),IF(J3=3,INDEX(Language!B4:F35,14,3),IF(J3=2,INDEX(Language!B4:F35,14,4),INDEX(Language!B4:F35,14,5))))))","v":"Voltagem min. FV @ Temperatura max."},null,null,null,null,{"$f":"'Calculation table'!K37","v":69.101767872000011}]
[null,{"$f":"IF(J3=6,INDEX(Language!B4:G36,15,6),IF(J3=5,INDEX(Language!B4:F35,15,1),IF(J3=4,INDEX(Language!B4:F35,15,2),IF(J3=3,INDEX(Language!B4:F35,15,3),IF(J3=2,INDEX(Language!B4:F35,15,4),INDEX(Language!B4:F35,15,5))))))","v":"Corrente max. de saida"},null,null,null,null,{"$f":"INDEX(Regulator!B2:P18,Form!$D$13,15)","v":45}]
[null,{"$f":"IF(J3=6,INDEX(Language!B4:G36,16,6),IF(J3=5,INDEX(Language!B4:F35,16,1),IF(J3=4,INDEX(Language!B4:F35,16,2),IF(J3=3,INDEX(Language!B4:F35,16,3),IF(J3=2,INDEX(Language!B4:F35,16,4),INDEX(Language!B4:F35,16,5))))))","v":"Corrente max. @ MPPT temp. min."},null,null,null,null,{"$f":"IF('Calculation table'!E20=0,\"N.A.\",'Calculation table'!F40)","v":45}]
[null,null,null,null,null,null,{"$f":"IF(G25=\"N.A.\",\"\",IF('Calculation table'!F40=G24,IF(J3=6,INDEX(Language!B4:G36,27,6),IF(J3=5,INDEX(Language!B4:F35,27,1),IF(J3=4,INDEX(Language!B4:F35,27,2),IF(J3=3,INDEX(Language!B4:F35,27,3),IF(J3=2,INDEX(Language!B4:F35,27,4),INDEX(Language!B4:F35,27,5)))))),\"\"))","v":"* Redução de potência @ Temp. baixa"}]
[null,{"$f":"IF(J3=6,INDEX(Language!B4:G36,17,6),IF(J3=5,INDEX(Language!B4:F35,17,1),IF(J3=4,INDEX(Language!B4:F35,17,2),IF(J3=3,INDEX(Language!B4:F35,17,3),IF(J3=2,INDEX(Language!B4:F35,17,4),INDEX(Language!B4:F35,17,5))))))","v":"Corrente max. @ MPPT temp. max."},null,null,null,null,{"$f":"IF('Calculation table'!E20=0,\"N.A.\",'Calculation table'!G47)","v":42.631130620511996}]
[null,null,null,null,null,null,{"$f":"IF(G27=\"N.A.\",\"\",IF('Calculation table'!G47=G24,IF(J3=6,INDEX(Language!B4:G41,28,6),IF(J3=5,INDEX(Language!B4:F35,28,1),IF(J3=4,INDEX(Language!B4:F35,28,2),IF(J3=3,INDEX(Language!B4:F35,28,3),IF(J3=2,INDEX(Language!B4:F35,28,4),INDEX(Language!B4:F35,28,5)))))),\"\"))","v":""}]
[null,{"$f":"IF(J3=6,INDEX(Language!B4:G36,18,6),IF(J3=5,INDEX(Language!B4:F35,18,1),IF(J3=4,INDEX(Language!B4:F35,18,2),IF(J3=3,INDEX(Language!B4:F35,18,3),IF(J3=2,INDEX(Language!B4:F35,18,4),INDEX(Language!B4:F35,18,5))))))","v":"Configuração do módulo FV"},null,null,null,null,{"$f":"IF('Calculation table'!E50=FALSE,IF(G21<=G20,IF(G25<=G24,IF(G23>G22,H29,J29),J29),J29),J29)","v":"Aceito "},{"$f":"IF(J3=6,INDEX(Language!B4:G40,37,6),IF(J3=5,INDEX(Language!B4:F40,37,1),IF(J3=4,INDEX(Language!B4:F40,37,2),IF(J3=3,INDEX(Language!B4:F40,37,3),IF(J3=2,INDEX(Language!B4:F40,37,4),INDEX(Language!B4:F40,37,5))))))","v":"Aceito "},null,{"$f":"IF(J3=6,INDEX(Language!B4:G41,38,6),IF(J3=5,INDEX(Language!B4:F41,38,1),IF(J3=4,INDEX(Language!B4:F41,38,2),IF(J3=3,INDEX(Language!B4:F41,38,3),IF(J3=2,INDEX(Language!B4:F41,38,4),INDEX(Language!B4:F41,38,5))))))","v":"NÃO aceito "}]
[]
[null,null,null,null,null,null,null,null,null,null,"BHO 05-2020 3.6"]
[]
[{"$f":"IF(J3=6,INDEX(Language!B4:G41,34,6),IF(J3=5,INDEX(Language!B4:F37,34,1),IF(J3=4,INDEX(Language!B4:F37,34,2),IF(J3=3,INDEX(Language!B4:F37,34,3),IF(J3=2,INDEX(Language!B4:F37,34,4),INDEX(Language!B4:F37,34,5))))))","v":" ¿Vai cair neve nos modulos ?"},null,null,null,null,null,null,null,null,{"$f":"IF(M33=TRUE,IF(J3=6,INDEX(Language!B4:G41,35,6),IF(J3=5,INDEX(Language!B4:F38,35,1),IF(J3=6,INDEX(Language!B4:G41,35,6),IF(J3=4,INDEX(Language!B4:F38,35,2),IF(J3=3,INDEX(Language!B4:F38,35,3),IF(J3=2,INDEX(Language!B4:F38,35,4),INDEX(Language!B4:F38,35,5))))))),IF(J3=6,INDEX(Language!B4:G41,36,6),IF(J3=5,INDEX(Language!B4:F39,36,1),IF(J3=4,INDEX(Language!B4:F39,36,2),IF(J3=3,INDEX(Language!B4:F39,36,3),IF(J3=2,INDEX(Language!B4:F39,36,4),INDEX(Language!B4:F39,36,5)))))))","v":"Não"},null,null,false]
[]
[{"$f":"IF(J3=6,INDEX(Language!B4:G41,19,6),IF(J3=5,INDEX(Language!B4:F35,19,1),IF(J3=4,INDEX(Language!B4:F35,19,2),IF(J3=3,INDEX(Language!B4:F35,19,3),IF(J3=2,INDEX(Language!B4:F35,19,4),INDEX(Language!B4:F35,19,5))))))","v":"Exemplos de localização com temperaturas previstas:"},null,null,null,null,null,null,{"$f":"IF(J3=5,INDEX(Language!B4:F35,7,1),IF(J3=4,INDEX(Language!B4:F35,7,2),IF(J3=3,INDEX(Language!B4:F35,7,3),IF(J3=2,INDEX(Language!B4:F35,7,4),INDEX(Language!B4:F35,7,5)))))","v":"Min."},null,{"$f":"IF(J3=5,INDEX(Language!B4:F35,8,1),IF(J3=4,INDEX(Language!B4:F35,8,2),IF(J3=3,INDEX(Language!B4:F35,8,3),IF(J3=2,INDEX(Language!B4:F35,8,4),INDEX(Language!B4:F35,8,5)))))","v":"Max."}]
[{"$f":"IF(J3=6,INDEX(Language!B4:G41,20,6),IF(J3=5,INDEX(Language!B4:F35,20,1),IF(J3=4,INDEX(Language!B4:F35,20,2),IF(J3=3,INDEX(Language!B4:F35,20,3),IF(J3=2,INDEX(Language!B4:F35,20,4),INDEX(Language!B4:F35,20,5))))))","v":"Num plano reto no motorhome, durante todo o ano (má ventilação)"},null,null,null,null,null,null,{"$f":"IF($B$12=1, M36, ((M36)*9/5)+32)","v":0},{"$f":"IF(B12=1, \"°C\", \"°F\")","v":"°C"},{"$f":"IF(B12=1, 70, ((70)*9/5)+32)","v":70},{"$f":"IF(B12=1, \"°C\", \"°F\")","v":"°C"},null,{"$f":"IF(M33=TRUE,-10,0)","v":0}]
[{"$f":"IF(J3=6,INDEX(Language!B4:G41,21,6),IF(J3=5,INDEX(Language!B4:F35,21,1),IF(J3=4,INDEX(Language!B4:F35,21,2),IF(J3=3,INDEX(Language!B4:F35,21,3),IF(J3=2,INDEX(Language!B4:F35,21,4),INDEX(Language!B4:F35,21,5))))))","v":"Num plano reto no motorhome, somente no verão (má ventilação)"},null,null,null,null,null,null,15,{"$f":"IF(B12=1, \"°C\", \"°F\")","v":"°C"},{"$f":"IF(B12=1, 70, ((70)*9/5)+32)","v":70},{"$f":"IF(B12=1, \"°C\", \"°F\")","v":"°C"},null,{"$f":"IF(M33=TRUE,5,15)","v":15}]
[{"$f":"IF(J3=6,INDEX(Language!B4:G41,22,6),IF(J3=5,INDEX(Language!B4:F35,22,1),IF(J3=4,INDEX(Language!B4:F35,22,2),IF(J3=3,INDEX(Language!B4:F35,22,3),IF(J3=2,INDEX(Language!B4:F35,22,4),INDEX(Language!B4:F35,22,5))))))","v":"Num plano reto no barco (má ventilação)"},null,null,null,null,null,null,10,{"$f":"IF(B12=1, \"°C\", \"°F\")","v":"°C"},{"$f":"IF(B12=1, 65, ((65)*9/5)+32)","v":65},{"$f":"IF(B12=1, \"°C\", \"°F\")","v":"°C"},null,{"$f":"IF(M33=TRUE,0,10)","v":10}]
[{"$f":"IF(J3=6,INDEX(Language!B4:G41,23,6),IF(J3=5,INDEX(Language!B4:F35,23,1),IF(J3=4,INDEX(Language!B4:F35,23,2),IF(J3=3,INDEX(Language!B4:F35,23,3),IF(J3=2,INDEX(Language!B4:F35,23,4),INDEX(Language!B4:F35,23,5))))))","v":"Inclinado no barco (boa ventilação)"},null,null,null,null,null,null,5,{"$f":"IF(B12=1, \"°C\", \"°F\")","v":"°C"},{"$f":"IF(B12=1, 60, ((60)*9/5)+32)","v":60},{"$f":"IF(B12=1, \"°C\", \"°F\")","v":"°C"},null,{"$f":"IF(M33=TRUE,-5,5)","v":5}]
[{"$f":"IF(J3=6,INDEX(Language!B4:G41,24,6),IF(J3=5,INDEX(Language!B4:F35,24,1),IF(J3=4,INDEX(Language!B4:F35,24,2),IF(J3=3,INDEX(Language!B4:F35,24,3),IF(J3=2,INDEX(Language!B4:F35,24,4),INDEX(Language!B4:F35,24,5))))))","v":"Teto inclinado numa região quente (boa ventilação)"},null,null,null,null,null,null,5,{"$f":"IF(B12=1, \"°C\", \"°F\")","v":"°C"},{"$f":"IF(B12=1, 70, ((70)*9/5)+32)","v":70},{"$f":"IF(B12=1, \"°C\", \"°F\")","v":"°C"},null,{"$f":"IF(M33=TRUE,-5,5)","v":5}]
[{"$f":"IF(J3=6,INDEX(Language!B4:G41,25,6),IF(J3=5,INDEX(Language!B4:F35,25,1),IF(J3=4,INDEX(Language!B4:F35,25,2),IF(J3=3,INDEX(Language!B4:F35,25,3),IF(J3=2,INDEX(Language!B4:F35,25,4),INDEX(Language!B4:F35,25,5))))))","v":"Teto inclinado numa região templada (boa ventilação)"},null,null,null,null,null,null,0,{"$f":"IF(B12=1, \"°C\", \"°F\")","v":"°C"},{"$f":"IF(B12=1, 65, ((65)*9/5)+32)","v":65},{"$f":"IF(B12=1, \"°C\", \"°F\")","v":"°C"},null,{"$f":"IF(M33=TRUE,-10,0)","v":0}]
[{"$f":"IF(J3=6,INDEX(Language!B4:G41,26,6),IF(J3=5,INDEX(Language!B4:F35,26,1),IF(J3=4,INDEX(Language!B4:F35,26,2),IF(J3=3,INDEX(Language!B4:F35,26,3),IF(J3=2,INDEX(Language!B4:F35,26,4),INDEX(Language!B4:F35,26,5))))))","v":"Teto inclinado nas montanha - frio (boa ventilação)"},null,null,null,null,null,null,-5,{"$f":"IF(B12=1, \"°C\", \"°F\")","v":"°C"},{"$f":"IF(B12=1, 60, ((60)*9/5)+32)","v":60},{"$f":"IF(B12=1, \"°C\", \"°F\")","v":"°C"},null,{"$f":"IF(M33=TRUE,-10,-5)","v":-5}]

{"sheet":"Modules","index":1,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,"Manufacturer","Type","Power","Vmpp","Impp","Voc","Isc","V temp coeff","I temp coeff","Art.Nr."]
[null,"[name]","[name]","[W]","[V]","[A]","[V]","[A]","[%/°C]","[%/°C]"]
[{"$f":"B3&\" \"&C3&\" (\"&K3&\")\"","v":"Victron Energy SPM20-12 (SPM040201200)"},"Victron Energy","SPM20-12",20,"18,5",1.0900000000000001,22.6,1.19,-0.35,0.04,"SPM040201200"]
[{"$f":"B4&\" \"&C4&\" (\"&K4&\")\"","v":"Victron Energy SPM30-12 (SPM040301200)"},"Victron Energy","SPM30-12",30,18.7,1.61,22.87,1.76,-0.34,3.6999999999999998E-2,"SPM040301200"]
["Victron Energy SPM40-12 (SPM040401200)","Victron Energy","SPM40-12",40,18.3,2.19,22.45,2.4,-0.35,0.04,"SPM040401200"]
["Victron Energy SPM55-12 (SPM040551200)","Victron Energy","SPM55-12",55,18.8,2.94,22.9,3.22,-0.35,0.04,"SPM040551200"]
["Victron Energy SPM90-12 (SPM040901200 )","Victron Energy","SPM90-12",90,19.600000000000001,4.59,24.06,5.03,-0.35,0.04,"SPM040901200 "]
["Victron Energy SPM115-12 (SPM041151200)","Victron Energy","SPM115-12",115,19,6.04,23.32,6.61,-0.35,0.04,"SPM041151200"]
["Victron Energy SPM175-12 (SPM041751200)","Victron Energy","SPM175-12",175,19.399999999999999,9.0299999999999994,23.7,9.89,-0.35,0.04,"SPM041751200"]
[{"$f":"B10&\" \"&C10&\" (\"&K10&\")\"","v":"Victron Energy SPM215-24 (SPM042152400)"},"Victron Energy","SPM215-24",215,37.4,5.75,45.82,6.3,-0.35,0.04,"SPM042152400"]
["Victron Energy SPM305-20 (SPM043052000)","Victron Energy","SPM305-20",305,32.5,9.3800000000000008,39.700000000000003,10.27,-0.35,0.04,"SPM043052000"]
["Victron Energy SPM360-24 (SPM043602400)","Victron Energy","SPM360-24",360,38.4,9.3800000000000008,47.4,10.24,-0.35,0.04,"SPM043602400"]
["Victron Energy SPP20-12 (SPP040201200)","Victron Energy","SPP20-12",20,18.399999999999999,1.0900000000000001,21.96,1.18,-0.35,0.04,"SPP040201200"]
["Victron Energy SPP30-12 (SPP040301200)","Victron Energy","SPP30-12",30,18.2,1.66,21.8,1.8,-0.35,0.04,"SPP040301200"]
[{"$f":"B15&\" \"&C15&\" (\"&K15&\")\"","v":"Victron Energy SPP45-12 (SPP040451200)"},"Victron Energy","SPP45-12",45,19.100000000000001,2.36,22.9,2.5499999999999998,-0.35,0.04,"SPP040451200"]
["Victron Energy SPP60-12 (SPP040601200)","Victron Energy","SPP60-12",60,19.3,3.12,23.1,3.37,-0.35,0.04,"SPP040601200"]
["Victron Energy SPP90-12 (SPP040901200)","Victron Energy","SPP90-12",90,19.5,4.6100000000000003,23.44,4.9800000000000004,-0.35,0.04,"SPP040901200"]
["Victron Energy SPP100-12 (SPP041001200)","Victron Energy","SPP100-12",100,18.2,5.5,21.85,5.94,-0.35,3.6999999999999998E-2,"SPP041001200"]
[{"$f":"B19&\" \"&C19&\" (\"&K19&\")\"","v":"Victron Energy SPP115-12 (SPP041151200)"},"Victron Energy","SPP115-12",115,18.940000000000001,6.08,22.73,6.56,-0.35,0.04,"SPP041151200"]
["Victron Energy SPP175-12 (SPP041751200)","Victron Energy","SPP175-12",175,18.3,9.56,21.9,10.24,-0.35,0.04,"SPP041751200"]
["Victron Energy SPP260-20 (SPP032602000)","Victron Energy","SPP260-20",260,30,8.66,36.75,9.3000000000000007,-0.34,4.4999999999999998E-2,"SPP032602000"]
[{"$f":"B22&\" \"&C22&\" (\"&K22&\")\"","v":"Victron Energy SPP270-20 (SPP042702000)"},"Victron Energy","SPP270-20",270,31.7,8.52,38.04,9.2100000000000009,-0.34,4.4999999999999998E-2,"SPP042702000"]
["Victron Energy SPP330-24 (SPP043302400)","Victron Energy","SPP330-24",330,37.299999999999997,8.86,44.72,9.57,-0.35,0.04,"SPP043302400"]
["PAINEL BYD 335W - POLICRISTALINO 72 CÉLULAS","BYD",null,335,37.35,8.9700000000000006,47.28,9.39,-0.31,7.0000000000000007E-2]
["PAINEL JINKO 400W -MONO CRISTALINO 144  HALF CELL","JINKO","JKM400M-72H-V",400,41.7,9.6,49.8,10.36,-0.28000000000000003,4.8000000000000001E-2]
["PAINEL CANADIAN 350W - POLI 144 CÉLULAS","CANADIAN","CS3U-350PB-AG",350,39.200000000000003,8.94,46.6,9.51,-0.28000000000000003,0.05]
["PAINEL CANADIAN 400W - POLI 144 CÉLULAS","CANADIAN","CS3W-400PB-AG",400,38.700000000000003,10.34,47.2,10.9,-0.28000000000000003,0.05]
["PAINEL CANADIAN 435W - POLI 144 CÉLULAS","CANADIAN","CS3W-435P",435,40.1,10.85,48.6,11.35,-0.28000000000000003,0.05]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(Form!J3=6,INDEX(Language!B4:G51,40,6),IF(Form!J3=5,INDEX(Language!B4:F51,40,1),IF(Form!J3=4,INDEX(Language!B4:F51,40,2),IF(Form!J3=3,INDEX(Language!B4:F51,40,3),IF(Form!J3=2,INDEX(Language!B4:F51,40,4),INDEX(Language!B4:F51,40,5))))))","v":"Calculo do coeficiente de temperatura"}]
[{"$f":"IF(Form!J3=6,INDEX(Language!B4:G51,41,6),IF(Form!J3=5,INDEX(Language!B4:F51,41,1),IF(Form!J3=4,INDEX(Language!B4:F51,41,2),IF(Form!J3=3,INDEX(Language!B4:F51,41,3),IF(Form!J3=2,INDEX(Language!B4:F51,41,4),INDEX(Language!B4:F51,41,5))))))","v":"Caso tiver o coeficiente de temperatura de voltagem em mV/°C, pode ser trocado para %/°C"}]
[{"$f":"IF(Form!J3=6,INDEX(Language!B4:G51,42,6),IF(Form!J3=5,INDEX(Language!B4:F51,42,1),IF(Form!J3=4,INDEX(Language!B4:F51,42,2),IF(Form!J3=3,INDEX(Language!B4:F51,42,3),IF(Form!J3=2,INDEX(Language!B4:F51,42,4),INDEX(Language!B4:F51,42,5))))))","v":"Escreve o valor do Voc (voltagem do circuito abierto) em volts"},null,24.1,"V"]
[{"$f":"IF(Form!J3=6,INDEX(Language!B4:G51,43,6),IF(Form!J3=5,INDEX(Language!B4:F51,43,1),IF(Form!J3=4,INDEX(Language!B4:F51,43,2),IF(Form!J3=3,INDEX(Language!B4:F51,43,3),IF(Form!J3=2,INDEX(Language!B4:F51,43,4),INDEX(Language!B4:F51,43,5))))))","v":"Escreve o valor do coeficiente em mV/°C:"},null,-77,"mV/°C"]
[{"$f":"IF(Form!J3=6,INDEX(Language!B4:G51,44,6),IF(Form!J3=5,INDEX(Language!B4:F51,44,1),IF(Form!J3=4,INDEX(Language!B4:F51,44,2),IF(Form!J3=3,INDEX(Language!B4:F51,44,3),IF(Form!J3=2,INDEX(Language!B4:F51,44,4),INDEX(Language!B4:F51,44,5))))))","v":"O valor do coeficiente en %/°C agora:"},null,{"$f":"(C39/1000)/(C38/100)","v":-0.31950207468879666},"%/°C"]
[]
[{"$f":"IF(Form!J3=6,INDEX(Language!B4:G51,45,6),IF(Form!J3=5,INDEX(Language!B4:F51,45,1),IF(Form!J3=4,INDEX(Language!B4:F51,45,2),IF(Form!J3=3,INDEX(Language!B4:F51,45,3),IF(Form!J3=2,INDEX(Language!B4:F51,45,4),INDEX(Language!B4:F51,45,5))))))","v":"Se tem o coeficiente de temperatura atual em mA/°C, pode ser trocado para %/°C"}]
[{"$f":"IF(Form!J3=6,INDEX(Language!B4:G51,46,6),IF(Form!J3=5,INDEX(Language!B4:F51,46,1),IF(Form!J3=4,INDEX(Language!B4:F51,46,2),IF(Form!J3=3,INDEX(Language!B4:F51,46,3),IF(Form!J3=2,INDEX(Language!B4:F51,46,4),INDEX(Language!B4:F51,46,5))))))","v":"Escreve o valor do Isc (corrente de curtocircuito) em ampers"},null,8.7200000000000006,"A"]
[{"$f":"IF(Form!J3=6,INDEX(Language!B4:G51,47,6),IF(Form!J3=5,INDEX(Language!B4:F51,47,1),IF(Form!J3=4,INDEX(Language!B4:F51,47,2),IF(Form!J3=3,INDEX(Language!B4:F51,47,3),IF(Form!J3=2,INDEX(Language!B4:F51,47,4),INDEX(Language!B4:F51,47,5))))))","v":"Escreve o valor do coeficiente em mA/°C:"},null,4.7,"mA/°C"]
[{"$f":"IF(Form!J3=6,INDEX(Language!B4:G51,48,6),IF(Form!J3=5,INDEX(Language!B4:F51,48,1),IF(Form!J3=4,INDEX(Language!B4:F51,48,2),IF(Form!J3=3,INDEX(Language!B4:F51,48,3),IF(Form!J3=2,INDEX(Language!B4:F51,48,4),INDEX(Language!B4:F51,48,5))))))","v":"O coeficiente em %/°C :"},null,{"$f":"(C44/1000)/(C43/100)","v":5.3899082568807342E-2},"%/°C"]

{"sheet":"Regulator","index":2,"n_rows":18,"n_cols":20,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,10,0,13]]}
[null,"Manufacturer","Type","Power @ 12V","Power @ 24V","Power @ 36V","Power @ 48V","Voc max","Voc min","Vmpp min","System Voltage",null,null,null,"IPV max","Ibat max","Efficiency@12","Efficiency@24","Efficiency@36","Efficiency@48"]
[{"$f":"B2&\" \"&C2","v":"Victron Energy Blue-/ SmartSolar MPPT 75/10"},"Victron Energy","Blue-/ SmartSolar MPPT 75/10",135,270,0,0,75,5,1,12,24,"N.A.","N.A.",13,10,0.98,0.98,0,0]
["Victron Energy Blue-/ SmartSolar MPPT 75/15","Victron Energy","Blue-/ SmartSolar MPPT 75/15",200,400,0,0,75,5,1,12,24,"N.A.","N.A.",15,15,0.98,0.98,0,0]
["Victron Energy Blue-/ SmartSolar MPPT 100/15","Victron Energy","Blue-/ SmartSolar MPPT 100/15",200,400,0,0,100,5,1,12,24,"N.A.","N.A.",15,15,0.98,0.98,0,0]
["Victron Energy Smart Solar MPPT 100/20","Victron Energy","Smart Solar MPPT 100/20",290,580,0,0,100,5,1,12,24,"N.A.","N.A.",20,20,0.98,0.98,0,0]
["Victron Energy Smart Solar MPPT 100/20 48V","Victron Energy","Smart Solar MPPT 100/20 48V",0,0,0,1160,100,5,1,"N.A.","N.A.","N.A.",48,20,20,0,0,0,0.98]
["Victron Energy Blue-/ SmartSolar MPPT 100/30","Victron Energy","Blue-/ SmartSolar MPPT 100/30",440,880,0,0,100,5,1,12,24,"N.A.","N.A.",30,30,0.98,0.98,0,0]
["Victron Energy Blue-/ SmartSolar MPPT 100/50","Victron Energy","Blue-/ SmartSolar MPPT 100/50",700,1400,0,0,100,5,1,12,24,"N.A.","N.A.",50,50,0.98,0.98,0,0]
["Victron Energy Blue-/ SmartSolar MPPT 150/35","Victron Energy","Blue-/ SmartSolar MPPT 150/35",500,1000,1500,2000,150,5,1,12,24,36,48,40,35,0.98,0.98,0.98,0.98]
["Victron Energy Blue-/ SmartSolar MPPT 150/45 Tr/MC4","Victron Energy","Blue-/ SmartSolar MPPT 150/45 Tr/MC4",650,1300,null,2600,150,5,1,12,24,36,48,50,45,0.98,0.98,0.98,0.98]
["Victron Energy Blue-/ SmartSolar MPPT 150/60 Tr/MC4","Victron Energy","Blue-/ SmartSolar MPPT 150/60 Tr/MC4",860,1720,null,3440,150,5,1,12,24,36,48,50,60,0.98,0.98,0.98,0.98]
["Victron Energy Blue-/ SmartSolar MPPT 150/70 Tr/Tr VE.Can/MC4","Victron Energy","Blue-/ SmartSolar MPPT 150/70 Tr/Tr VE.Can/MC4",1000,2000,null,4000,150,5,1,12,24,36,48,50,70,0.98,0.98,0.98,0.98]
["Victron Energy SmartSolar MPPT 150/85 Tr/Tr VE.Can/MC4","Victron Energy","SmartSolar MPPT 150/85 Tr/Tr VE.Can/MC4",1200,2400,null,4900,150,5,1,12,24,36,48,70,85,0.98,0.98,0.98,0.98]
["Victron Energy SmartSolar MPPT 150/100 Tr/Tr VE.Can/MC4","Victron Energy","SmartSolar MPPT 150/100 Tr/Tr VE.Can/MC4",1450,2900,null,5800,150,5,1,12,24,36,48,70,100,0.98,0.98,0.98,0.98]
["Victron Energy SmartSolar MPPT 250/60 Tr/MC4","Victron Energy","SmartSolar MPPT 250/60 Tr/MC4",860,1720,null,3440,250,5,1,12,24,36,48,35,60,0.99,0.99,0.99,0.99]
["Victron Energy SmartSolar MPPT 250/70 Tr/Tr VE.Can/MC4","Victron Energy","SmartSolar MPPT 250/70 Tr/Tr VE.Can/MC4",1000,2000,null,4000,250,5,1,12,24,36,48,35,70,0.99,0.99,0.99,0.99]
["Victron Energy SmartSolar MPPT 250/85 Tr/Tr VE.Can/MC4","Victron Energy","SmartSolar MPPT 250/85 Tr/Tr VE.Can/MC4",1200,2400,null,4900,250,5,1,12,24,36,48,70,85,0.99,0.99,0.99,0.99]
["Victron Energy SmartSolar MPPT 250/100 Tr/Tr VE.Can/MC4","Victron Energy","SmartSolar MPPT 250/100 Tr/Tr VE.Can/MC4",1450,2900,null,5800,250,5,1,12,24,36,48,70,100,0.99,0.99,0.99,0.99]

{"sheet":"Calculation table","index":3,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
["DATA:"]
[]
["Location:",null,{"$f":"Form!F12","v":0},"min",{"$f":"Form!E11","v":0}]
[null,null,{"$f":"Form!H12","v":70},"max",{"$f":"Form!H11","v":70}]
[]
["Module info:",null,{"$f":"INDEX(Modules!B3:J34,Form!D4,6)*Form!D6","v":99.6},"Voc @25°C"]
[null,null,{"$f":"INDEX(Modules!B3:J34,Form!D4,4)*Form!D6","v":83.4},"Vmpp @25°C"]
[null,null,{"$f":"INDEX(Modules!B3:J34,Form!D4,7)*Form!H6","v":31.08},"Isc PV@25°C"]
[null,null,{"$f":"INDEX(Modules!B3:J34,Form!D4,5)*Form!H6","v":28.799999999999997},"Impp PV @25°C"]
[null,null,{"$f":"$C$10*$C$8/E20","v":50.04},"Impp output @25°C"]
[null,null,{"$f":"INDEX(Modules!B3:J34,Form!D4,8)","v":-0.28000000000000003},"Temp. Coeff. Voc"]
[null,null,{"$f":"(C7/100)*C12","v":-0.27888000000000002},"Temp. Coeff. Voc absolute"]
[null,null,{"$f":"INDEX(Modules!B3:J34,Form!D4,9)","v":4.8000000000000001E-2},"Temp. Coeff. Isc"]
[null,null,{"$f":"C9*(C14/100)","v":1.49184E-2},"Temp. Coeff. Isc absolute"]
[null,null,{"$f":"Form!D8","v":2400},"Choosen PV power"]
[]
["Regulator info:",null,{"$f":"INDEX(Regulator!$B$2:$H$18,Form!$D$13,7)","v":150},"Voc max",{"$f":"INDEX(Regulator!B2:P18,Form!$D$13,15)","v":45},"Ibat max"]
[null,null,{"$f":"INDEX(Regulator!B2:J18,Form!D13,8)+E20","v":53},"Voc min",{"$f":"INDEX(Regulator!B2:P18,Form!$D$13,14)","v":50},"IPV max"]
[null,null,{"$f":"INDEX(Regulator!$B$2:$J$29,Form!$E$15,9)+E20","v":49},"Vmpp min",{"$f":"IF(INDEX(Form!$M$12:$M$15,Form!$E$15,1)=\"N.A.\",0,INDEX(Form!$M$12:$M$15,Form!$E$15,1))","v":48},"System voltage",{"$f":"IF(E20=12,16,IF(E20=24,17,IF(E20=36,18,19)))","v":19}]
[null,null,{"$f":"IF(E20=48,INDEX(Regulator!D2:G18,Form!D13,4),IF(E20=36,INDEX(Regulator!D2:G18,Form!D13,3),IF(E20=24,INDEX(Regulator!D2:G18,Form!D13,2),IF(E20=12,INDEX(Regulator!D2:G18,Form!D13,1),0))))","v":2600},"Possible charge power (from datasheet) without limiting PV power",{"$f":"INDEX(Regulator!B2:T18,Form!$D$13,G20)","v":0.98},"Max. Efficiency"]
[]
["Voltage drop: ",null,1.78E-2,"Cupper resistance"]
[null,null,{"$f":"((Form!H17+Form!H17)*C23)/Form!H18","v":5.9333333333333328E-2},"Factor"]
[]
[]
["RESULTS:"]
[]
["Temperature",null,"Voc max.","Voc START min.","Vmpp RUN min.","String Voc max.","String Vmpp max.","String Vmpp corr.max.","String Voc min.","String Vmpp min.","String Vmpp corr. min."]
[{"$f":"IF(Form!$B$12=1,B30, ((B30)*9/5)+32)","v":0},{"$f":"C4","v":0},{"$f":"$C$18","v":150},{"$f":"$C$19","v":53},{"$f":"$C$20","v":49},{"$f":"$C$7+($C$13*-(25-B30))","v":106.57199999999999},{"$f":"$C$8+($C$13*-(25-B30))","v":90.372},{"$f":"($C$8+($C$13*-(25-B30))-($C$24*D40))","v":88.685328960000007}]
[{"$f":"IF(Form!$B$12=1,B31, ((B31)*9/5)+32)","v":5},{"$f":"B30+5","v":5},{"$f":"$C$18","v":150},{"$f":"$C$19","v":53},{"$f":"$C$20","v":49},{"$f":"$C$7+($C$13*-(25-B31))","v":105.1776},{"$f":"$C$8+($C$13*-(25-B31))","v":88.97760000000001},{"$f":"($C$8+($C$13*-(25-B31))-($C$24*D41))","v":87.28650316800001}]
[{"$f":"IF(Form!$B$12=1,B32, ((B32)*9/5)+32)","v":10},{"$f":"B31+5","v":10},150,53,49,{"$f":"$C$7+($C$13*-(25-B32))","v":103.78319999999999},87.583200000000005,85.887677375999999]
[{"$f":"IF(Form!$B$12=1,B33, ((B33)*9/5)+32)","v":15},{"$f":"B32+5","v":15},150,53,49,{"$f":"$C$7+($C$13*-(25-B33))","v":102.38879999999999},86.188800000000001,{"$f":"($C$8+($C$13*-(25-B33))-($C$24*D43))","v":84.488851584000003}]
[{"$f":"IF(Form!$B$12=1,B34, ((B34)*9/5)+32)","v":55},{"$f":"B35-5","v":55},150,53,49,null,null,null,{"$f":"$C$7+($C$13*-(25-B34))","v":91.233599999999996},{"$f":"$C$8+($C$13*-(25-B34))","v":75.033600000000007},{"$f":"$C$8+($C$13*-(25-B34))-($C$24*D44)","v":73.298245248000001}]
[{"$f":"IF(Form!$B$12=1,B35, ((B35)*9/5)+32)","v":60},{"$f":"B36-5","v":60},150,53,49,null,null,null,{"$f":"$C$7+($C$13*-(25-B35))","v":89.839199999999991},{"$f":"$C$8+($C$13*-(25-B35))","v":73.639200000000002},{"$f":"$C$8+($C$13*-(25-B35))-($C$24*D45)","v":71.899419456000004}]
[{"$f":"IF(Form!$B$12=1,B36, ((B36)*9/5)+32)","v":65},{"$f":"B37-5","v":65},150,53,49,null,null,null,88.444799999999987,72.244799999999998,70.500593663999993]
[{"$f":"IF(Form!$B$12=1,B37, ((B37)*9/5)+32)","v":70},{"$f":"C5","v":70},150,53,49,null,null,null,87.050399999999996,70.850400000000008,69.101767872000011]
[]
["Temperature",null,"Ibat max.","Impp PV max.","System Voltage","Ibat max. @ Impp","Ibat min. @ Impp"]
[{"$f":"IF(Form!$B$12=1,B40, ((B40)*9/5)+32)","v":0},{"$f":"C4","v":0},{"$f":"$E$18","v":45},{"$f":"$C$10+($C$15*-(25-B40))","v":28.427039999999998},{"$f":"$E$20","v":48},{"$f":"IF((((D40*G30)/E40)*$E$21)>$E$18,$E$18,(((D40*G30)/E40)*$E$21))","v":45}]
[{"$f":"IF(Form!$B$12=1,B41, ((B41)*9/5)+32)","v":5},{"$f":"B40+5","v":5},{"$f":"$E$18","v":45},{"$f":"$C$10+($C$15*-(25-B41))","v":28.501631999999997},{"$f":"$E$20","v":48},{"$f":"IF((((D41*G31)/E41)*$E$21)>$E$18,$E$18,(((D41*G31)/E41)*$E$21))","v":45}]
[{"$f":"IF(Form!$B$12=1,B42, ((B42)*9/5)+32)","v":10},{"$f":"B41+5","v":10},45,28.576223999999996,48,{"$f":"IF((((D42*G32)/E42)*$E$21)>$E$18,$E$18,(((D42*G32)/E42)*$E$21))","v":45}]
[{"$f":"IF(Form!$B$12=1,B43, ((B43)*9/5)+32)","v":15},{"$f":"B42+5","v":15},45,28.650815999999995,48,{"$f":"IF((((D43*G33)/E43)*$E$21)>$E$18,$E$18,(((D43*G33)/E43)*$E$21))","v":45}]
[{"$f":"IF(Form!$B$12=1,B44, ((B44)*9/5)+32)","v":55},{"$f":"B45-5","v":55},45,29.247551999999999,48,null,{"$f":"IF(((D44*J34)/E44*$E$21)>$E$18,$E$18,((D44*J34)/E44*$E$21))","v":44.805377820672}]
[{"$f":"IF(Form!$B$12=1,B45, ((B45)*9/5)+32)","v":60},{"$f":"B46-5","v":60},45,29.322143999999998,48,null,{"$f":"IF(((D45*J35)/E45*$E$21)>$E$18,$E$18,((D45*J35)/E45*$E$21))","v":44.084875873247995}]
[{"$f":"IF(Form!$B$12=1,B46, ((B46)*9/5)+32)","v":65},{"$f":"B47-5","v":65},45,29.396735999999997,48,null,{"$f":"IF(((D46*J36)/E46*$E$21)>$E$18,$E$18,((D46*J36)/E46*$E$21))","v":43.360126806527994}]
[{"$f":"IF(Form!$B$12=1,B47, ((B47)*9/5)+32)","v":70},{"$f":"C5","v":70},45,29.471327999999996,48,null,{"$f":"IF(((D47*J37)/E47*$E$21)>$E$18,$E$18,((D47*J37)/E47*$E$21))","v":42.631130620511996}]
[]
["PV Power ratio",null,{"$f":"C16/C21","v":0.92307692307692313},"If more than 1.3 the user becomes an alert that he/ she is oversizing the PV generator with more than 30%"]
["Maximum power point PV current is higher than maximum regulator input current",null,null,null,{"$f":"IF(C10>E19, TRUE, FALSE)","v":false}]

{"sheet":"Version","index":4,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["History"]
[]
["3.6","'- Added Portuguese language"]
["3.5","'- Added new VE.Can MPPT's 150/85 & 250/85 VE.Can"]
["3.4","'- Added new VE.Can MPPT's 250/70 & 250/100 VE.Can"]
["3.3","'- Added new VE.Can MPPT's and deleted old VE.Can MPPT's 150/70 & 150/85"]
["3.2","'- Added new Victron solar modules inserted new VE.Can MPPT's and deleted old VE.Can MPPT's 150/70 & 150/85"]
["3.1","'- Added new Victron solar modules"]
["3.0","- Added Imperial system and reduced min. solar module temperature to -40°C"]
["2.9","- Added new Victron solar modules"]
[2.8,"- Added MPPT 100/20 48V & exchanged new solar modules mono 160/200/340 & poly 150/260/320Wp"]
[2.7,"- Added 150Wp mono module, SmartSolar 250/60 & 70 and maximum input current"]
[2.6,"- Added Smart Regulators and SmartSolar 100/20"]
[2.5,"- Added translations for 'coefficient support' in the modules TAB"]
[2.4,"- Bug fixed for max. charge current calculations"]
[2.2999999999999998,"- Replaced solar modules according newest list. Added 2 SmartSolar MPPT's 250/85 & 250/100 & a remark when the PV generator is oversized. "]
[2.2000000000000002,"- Added the MPPT 150/85 Tr/MC4 and 150/100 Tr/MC4 & added two cable sizes 16mm² & 35mm²"]
["2.1","- Added the Poly module with 190Wp & added the new VE.Direct MPPT's 150/45, 150/60 & 150/70, small correction in cable loss voltage"]
["2.0","- Added the MPPT 75/10 and took out the discontinued 75/50"]
["1.9","- Added new solar modules, and now 10 additional modules can be added instead of 3."]
["1.8","- Added a small calculation on the 'Modules' TAB  to help when temperature coefficiences are not in %/°C or %/°K but in mV/°C or mA/°C"]
["1.7","- Added new solar modules, voltage drop correction and an option to rise the cell temperature in the example list, when the solar modules do not see snow and therefor temperatures will not be so low."]
["1.6","- Inserted 4 new regulators and 2 more custom module."]
["1.5","- Inserted 4 languages @ updated not applicable (N.A.) voltages for 75/15, 75/50 & 100/15."]
["1.4","- Changed texts and Module temperature window."]
["1.3","- Power reduction comment set @ highest temperature."]
["1.2","- Reduced output current to maximum output current at low & high temperatures. Now a system will show 'power loss' only wenn the output current exceeds the max. at low & high temperatures."]
["1.1","- Inserted BlueSolar MPPT 100/15. Inserted custom module"]
["1.0","- First version"]
[0.1,"- This Excel gives an indication how to calculate Victron Energy MPPT's"]

{"sheet":"Language","index":5,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"IF(Form!J3=5,\"V\",\" \")","v":" "},{"$f":"IF(Form!J3=4,\"V\",\" \")","v":" "},{"$f":"IF(Form!J3=3,\"V\",\" \")","v":" "},{"$f":"IF(Form!J3=2,\"V\",\" \")","v":" "},{"$f":"IF(Form!J3=1,\"V\",\" \")","v":" "}]
["Pos.","ENGLISH","DUTCH","ESPANGOL","DEUTSCH","FRANCAIS","PORTUGUÊS"]
[]
[1,"Module:","Paneel:","Módulo FV:","Modul:","Panneau:","Módulo FV"]
[2,"In series:","In serie:","Cuantos módulos? En Serie:","In Reihe:","En serie:","Quantos módulos? Em serie:"]
[3,"Parallel:","Parallel:","En paralelo:","Parallel:","Parallèle:","Em paralelo"]
[4,"Total PV power @STC:","Totale PV vermogen @STC:","Potencia total FV @STC:","PV Leistung insgesamt @STC:","Puissance PV totale @STC:","Potência total FV @STC"]
[5,"Wp","Wp","Wp","Wp","Wc","Wp"]
[6,"Module temperature:","Paneel temperatuur:","Temp. módulo FV ","Modul Temperatur:","Température Paneau:","Temp. módulo FV "]
[7,"Min.","Min.","Min.","Min.","Min.","Min."]
[8,"Max. ","Max.","Max.","Max.","Max.","Max."]
[9,"Controller:","Regelaar:","Reguladorr:","Regler:","Régulateur:","Controlador"]
[10,"System voltage:","Systeem spanning:","Voltaje del sistema:","System Spannung:","Tension du système:","Voltagem do sistema "]
[11,"Max. input voltage","Max. ingangsspanning","Voltaje max. de entrada","Max. Eingangspannung:","Tension d'entrée max.:","Voltagem máxima de entrada "]
[12,"Max. PV voltage @ min. temperature","Max. PV spanning @ min. temp.","Voltaje max. FV @ Temperatura min.","Max. PV Spannung @ min. Temp.","PV tension max. @ temp. min.","Voltagem max FV@Temp min "]
[13,"Min. input voltage @ MPP","Min. ingangsspanning @ MPP","Voltaje min. de entrada  @ PMP","Min. Eingangspannung @ MPP","Tension d'entrée min. @ MPP","Voltagem min. de entrada  @ MPPT"]
[14,"Min. PV voltage @ max. temperature","Min. PV spanning @ max. Temp.","Voltaje min. FV @ Temperatura max.","Min. PV Spannung @ max. Temp.","PV tension min. @ temp. max.","Voltagem min. FV @ Temperatura max."]
[15,"Max. output current","Max. uitgangsstroom","Corriente max. de salida","Max. Ausgangstrom","Courant de sortie max.","Corrente max. de saida"]
[16,"Max. current @ MPP min. temp.","Max. stroom @ MPP min. temp.","Corriente max. @ PMP temp. min.","Max. Strom @ MPP min. Temp.","Courant max. @ MPP temp. min.","Corrente max. @ MPPT temp. min."]
[17,"Max. current @ MPP max. temp.","Max. stroom @ MPP max. temp.","Corriente max. @ PMP temp. max.","Max. Strom @ MPP max. Temp.","Courant max. @ MPP temp. max.","Corrente max. @ MPPT temp. max."]
[18,"Solar module configuration","Zonne-paneel configuratie","Configuración del módulo FV","Solar Modul Auslegung","Configuration du panneau","Configuração do módulo FV"]
[19,"Example locations with expected temperatures:","Voorbeeld lokaties en verwachte temperatuur:","Ejemplos de lugares con temperaturas previstas:","Beispiel Standort und erwartete Temperatur:","Exemple de localisation de site avec la température attendue:","Exemplos de localização com temperaturas previstas:"]
[20,"Flat on mobile home, all year (poor ventilation)","Vlak op camper, gehele jaar (slechte ventilatie)","Plano sobre una autocaravana, durante todo el año (mala ventilación)","Flach auf Wohnmobil, ganze Jahr (schlechte Hinterlüftung)","À plat sur toit de camping-car  toute l'année (mauvaise ventilation)","Num plano reto no motorhome, durante todo o ano (má ventilação)"]
[21,"Flat on mobile home, only summer (poor ventilation)","Vlak op camper, alleen zomers (slechte ventilatie)","Plano sobre una autocaravana, sólo en verano (mala ventilación)","Flach auf Wohnmobil, nur Sommer (schlechte Hinterlüftung)","À plat sur camping-car , seulement l'été (mauvaise ventilation)","Num plano reto no motorhome, somente no verão (má ventilação)"]
[22,"Flat on boat (poor ventilation)","Vlak op boot (slechte ventilatie)","Plano sobre el techo de un barco (mala ventilación)","Flach auf Boot (schlechte Hinterlüftung)","À plat sur ​​le bateau (mauvaise ventilation)","Num plano reto no barco (má ventilação)"]
[23,"Pitched on boat (good ventilation)","Onder helling op boot (goede ventilatie)","Inclinado sobre el techo de un barco (buena ventilación)","Geneigt auf Boot (gute Hinterlüftung)","Inclinée sur bateau (bonne ventilation)","Inclinado no barco (boa ventilação)"]
[24,"Pitched roof in warm region (good ventilation)","Op schuin dak warme omgeving (goede ventilatie)","Techo inclinado en una región cálida (buena ventilación)","Schrägdach, warme Umgebung (gute Hinterlüftung)","Toit en pente, en région chaude (bonne ventilation)","Teto inclinado numa região quente (boa ventilação)"]
[25,"Pitched roof in average region (good ventilation)","Op schuin dak gemiddelde omgeving (goede ventilatie)","Techo inclinado en una región templada (buena ventilación)","Schrägdach, mittlere Regio (gute Hinterlüftung)","Toit en pente, région tempérée (bonne ventilation)","Teto inclinado numa região templada (boa ventilação)"]
[26,"Pitched roof on mountain (good ventilation)","Op schuin dak in de bergen (goede ventilatie)","Techo inclinado en las montañas (buena ventilación)","Schrägdach, in Bergen (gute Hinterlüftung)","Toit en pente, en montagne (bonne ventilation)","Teto inclinado nas montanha - frio (boa ventilação)"]
[27,"* Power limiting @ low temp.","* Vermogens begrenzing @ lage temp.","* Reducción de potencia @ Temp. baja","* Leistung Begrenzung @ niedrige Temp.","* Limitation de puissance @ basse temp.","* Redução de potência @ Temp. baixa"]
[28,"** Power limiting @ high temp.","** Vermogens begrenzing @ hoge temp.","** Reducción de potencia @ Temp. alta","** Leistung Begrenzung @ hohe Temp.","** Limitation de puissance @ haute temp.","** Redução de potência @ Temp. alta"]
[29,"Input voltage window","Ingangspanning venster","Ventana de voltaje","Eingangspannungsfenster","Fourchette de tension","Faixa de voltagem"]
[30,"Charge current window","Laadstroom venster","Ventana de corriente","Ladestromfenster","Fourchette de courant","Faixa de corrente"]
[31,"Cable length, Module to MPPT *","Kabel lengte, paneel tot MPPT *","Largo de cable entre modulo y MPPT *","Kabel Länge, Modul zum MPPT *","Longueur cable, Paneaux à MPPT *","Comprimento do cabo entre o modulo e o MPPT *"]
[32,"Cross-section:","Doorsnede:","Sección:","Querschnitt:","Section:","Corte transversal:"]
[33,"* One way length","* Enkele afstand"," * Longitud de un solo cable","* Einfache Distanz","* La distance simple"," * Distância de um só cabo"]
[34,"Are the solar modules covered with snow many periods a year?","Zijn de panelen gedurende veel periodes bedekt met sneeuw?"," ¿Los módulos están cubiertos con nieve durante muchos períodos del año?","Sind die Solar Module öfters im Jahr bedeckt mit Schnee?","Les panneaux PV sont-ils souvent couverts de neige ?"," ¿Vai cair neve nos modulos ?"]
[35,"Yes","Ja","Si","Ja","Oui","Sim"]
[36,"No","Nee","No","Nein","Non","Não"]
[37,"Accepted","Toegestaan","Aceptado","Erlaubt","Accepté","Aceito "]
[38,"NOT accepted","NIET toegestaan","NO aceptado","NICHT erlaubt","PAS accepté","NÃO aceito "]
[39,"Attention: More than 30% oversized PV generator","Attentie: Meer dan 30% overgedimensioneerde PV generator","Atención, se ha sobredimensionado el generador FV más del 30%","Achtung: Mehr als 30% überdimensionierte PV Generator","Attention, surdimensionnement PV supérieur à 30% ! Non recommandé financièrement !","Nota: existe sobredimensionamento do gerador FV  de mais do 30%"]
[40,"Coefficient support:","Koefficient berekening:","Calculación de coeficiente de temperatura","Koeffizientenberechnung:","Coefficients de température:","Calculo do coeficiente de temperatura"]
[41,"If you have the voltage temperature coefficient in mV/°C, here is how to change it to %/°C","Hier kunt U de spanning koeffizient van mV/°C naar %/°C omrekenen","Si tiene el coeficiente de temperatura de voltaje en mV/°C, aquí es cómo cambiarlo a %/°C","Hier können Sie die Spannungskoeffizient von mV/°C in %/°C wandeln","Si vous avez le Coefficient de température à tension de circuit ouvert  en mV/°C , voici comment changer ce coefficient en %/°C","Caso tiver o coeficiente de temperatura de voltagem em mV/°C, pode ser trocado para %/°C"]
[42,"Write the Voc value in Volt:","Schrijf hier de Voc waarde in Volt:","Escribir el valor de Voc (voltage de circuito abierto) en voltios","Schreiben Sie den Voc Wert in Volt:","Ecrire la valeur de la VOC en Volt:","Escreve o valor do Voc (voltagem do circuito abierto) em volts"]
[43,"Write the coefficient value in mV/°C:","Schrijf hier de koefficient waarde in mV/°C:","Escribir el valor de coeficiente en mV/°C:","Schreiben Sie den Koeffizient Wert in mV/°C:","Ecrire la valeur du coefficient en mV/°C:","Escreve o valor do coeficiente em mV/°C:"]
[44,"The coefficent value in %/°C is now:","De berekende koefficient in %/°C is nu:","El valor de coeficiente en %/°C es ahora:","Der errechneter Koeffizient in %/°C ist jetzt:","La valeur du coefficient en %/°C est de:","O valor do coeficiente en %/°C agora:"]
[45,"If you have the current temperature coefficient in mA/°C, here is how to change it to %/°C","Hier kunt U de stroom koeffizient van mA/°C naar %/°C omrekenen","Si tiene el coeficiente de temperatura actual en mA/°C, aquí es cómo cambiarlo a %/°C","Hier können Sie die Stromkoeffizient von mA/°C in %/°C wandeln","Si vous avez le Coefficient de température à Courant de Court-Cicuit en mA/°C, voici comment changer ce coefficient en %/°C","Se tem o coeficiente de temperatura atual em mA/°C, pode ser trocado para %/°C"]
[46,"Write the Isc value in Ampere:","Schrijf hier de Isc waarde in Ampere:","Escribir el valor de Isc (corriente de cortocircuito) en amperios","Schreiben Sie den Isc Wert in Ampere:","Ecrire la valeur de Isc en Ampère:","Escreve o valor do Isc (corrente de curtocircuito) em ampers"]
[47,"Write the coefficient value in mA/°C:","Schrijf hier de koefficient waarde in mA/°C:","Escribir el valor de coeficiente en mA/°C:","Schreiben Sie den Koeffizient Wert in mA/°C:","Ecrire la valeur du coefficient en mA/°C:","Escreve o valor do coeficiente em mA/°C:"]
[48,"The coefficent value in %/°C is now:","De berekende koefficient in %/°C is nu:","El valor de coeficiente en %/°C es ahora:","Der errechneter Koeffizient in %/°C ist jetzt:","La valeur du coefficient en %/°C est de :","O coeficiente em %/°C :"]
[49,"Warning: PV current is higher than MPPT max. input current","Waarschuwing: PV stroom is hoger dan max. ingangstroom MPPT","Atención: la corriente FV es superior a la máxima corriente de entrada MPPT","Warnung: PV Strom ist höher als max. erlaubter Eingangstrom MPPT","Attention! Le courant PV est supérieur au courant d’entrée maximum du MPPT ","Cuidado: A corrente FV é superior à máxima corrente de entrada do MPPT"]