{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["TAMAÑO DE PANEL SOLAR","DATOS","MAPA SOLAR MUNDIAL","MAPA SOLAR AFRICA","1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"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":"TAMAÑO DE PANEL SOLAR","index":0,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,2,3,6],[27,2,27,5],[24,2,24,7],[16,2,16,7],[17,5,20,7],[21,5,21,7],[21,1,21,4],[8,2,8,7],[9,3,9,7],[10,3,14,7]]}
[null,"CENTURIÓN SELECCIÓN RÁPIDA",null,null,null,null,null,null,null,null,null,"FOR CALCULATION PURPOSES ONLY - NORMALLY HIDDEN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Factors","Potential losses due to dust etc",0.2]
[null,"TAMAÑO DEL PANEL",null,null,null,null,null,null,null,null,null,null,null,null,"Maximum charging voltage",18,"Volts"]
[null,null,"Introduzca el número de operaciones diarias del sistema utilizado. Además, introduzca la corriente de funcionamiento y la duración del ciclo, si son diferentes a la nominal"]
[null,"MOTOR","NUMERO DE OPERACIONES POR DIA","Corriente nominal de funcionamiento - Amperios\n","Corriente de funcionamiento si es diferente a la nominal\n","Tiempo de ciclo nominal (apertura y cierre) - segundos\n","Tiempo de ciclo si es diferente al nominal (abrir y cerrar)\n","VOLTAJE DEL SISTEMA","ENERGIA CONSUMIDA Ah",null,null,"Running Current","Cycle Time","Energy consumed","Controller","Total Energy consumed","System Voltage"]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B6,DATOS!$1:$1048576,2,FALSE),\" \")","v":" "},null,{"$f":"IFERROR(VLOOKUP(B6,DATOS!$1:$1048576,3,FALSE),\" \")","v":" "},null,null,{"$f":"+P6","v":0},"Ah",null,{"$f":"IF(OR(E6=0,E6=\" \"),D6,E6)","v":" "},{"$f":"IF(OR(G6=0,F6=\" \"),F6,F6)","v":" "},{"$f":"+IFERROR(M6*L6/3600*C6,0)","v":0},{"$f":"IFERROR(VLOOKUP(B6,DATOS!$1:$1048576,8,FALSE)*VLOOKUP(B6,DATOS!$1:$1048576,9,FALSE),0)","v":0},{"$f":"+O6+N6","v":0},{"$f":"IFERROR(VLOOKUP(B6,DATOS!$1:$1048576,5,FALSE),H6)","v":0}]
[]
[]
[null,"ACCESORIOS","Por favor, introduzca la cantidad de auxiliares Centurion que se utilizan     \n"]
[null,null,"CANTIDAD",{"$f":"O10","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q6=12,\"12V System Factor\", IF(Q6=24,\"24V System Factor\",0))","v":0}]
[null,null,null,"NB - Es aconsejable seleccionar un regulador para el sistema. El sistema D10 24V requiere 2 reguladores, uno con cada panel. Introduzca sólo una cantidad de 1 cuando calcule la demanda de energía. NB El regulador puede manejar una potencia de panel de < 500W    \n    \n    \n    \n    \n",null,null,null,null,{"$f":"+P11","v":0},"Ah",null,null,null,{"$f":"IFERROR(VLOOKUP(B11,DATOS!$A$42:$F$73,4,FALSE),0)","v":0},{"$f":"IF(AND($Q$6=24,B11=\"Solar regulator (TES – 30A)\"),1,IF($Q$6=12,1,IF($Q$6=24,0.65,0)))","v":0},{"$f":"+N11*C11*O11","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"+P12","v":0},"Ah",null,null,null,{"$f":"IFERROR(VLOOKUP(B12,DATOS!$A$42:$F$73,4,FALSE),0)","v":0},{"$f":"IF(AND($Q$6=24,B12=\"Solar regulator (TES – 30A)\"),1,IF($Q$6=12,1,IF($Q$6=24,0.65,0)))","v":0},{"$f":"+N12*C12*O12","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"+P13","v":0},"Ah",null,null,null,{"$f":"IFERROR(VLOOKUP(B13,DATOS!$A$42:$F$73,4,FALSE),0)","v":0},0,{"$f":"+N13*C13*O13","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"+P14","v":0},"Ah",null,null,null,{"$f":"IFERROR(VLOOKUP(B14,DATOS!$A$42:$F$73,4,FALSE),0)","v":0},0,{"$f":"+N14*C14*O14","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"+P15","v":0},"Ah",null,null,null,{"$f":"IFERROR(VLOOKUP(B15,DATOS!$A$42:$F$73,4,FALSE),0)","v":0},0,{"$f":"+N15*C15*O15","v":0}]
[null,null,null,null,null,null,null,"TOTAL",{"$f":"+P17","v":0},"Ah"]
[null,null,"Energía total necesaria para cubrir la carga, 20% para pérdidas como suciedad en el panel, etc. y 15% para recargar la batería  \n  \n  \n  \n\n",null,null,null,null,null,null,null,null,null,null,null,"TOTAL ENERGY",{"$f":"SUM(P6:P16)","v":0}]
[null,"Horas de sol efectivas ( Insolación )\n",null,"Horas / día",null,"Energía total necesaria para cubrir la carga, 20% para pérdidas como suciedad en el panel, etc. y 15% para recargar la batería  \n  \n  \n  \n",null,null,null,null,null,null,null,null,"ADD FOR INEFFICIENCY",{"$f":"+P17/(1-Q18)","v":0},{"$f":"+P2","v":0.2}]
[]
[null,null,null,null,null,null,null,null,{"$f":"+P20","v":0},"Ah",null,null,null,null,"ADD TO RECHARGE BATTERY",{"$f":"+P18/(1-Q20)","v":0},{"$f":"+I22","v":0}]
[null,"Tamaño mínimo del panel solar\n",{"$f":"IF(OR(P20=0,C18=0),\" \",P20*P3/C18)","v":" "},"Watts"]
[null,{"$f":"IF(B6=\"D10 sliding gate (24VDC system)\",\"24V System - Require 2 panels, sized as per above, each with its own Solar regulator\",\" \")","v":" "},null,null,null,"¿Quieres cambiar el exceso permitido para recargar la batería?  \n"]
[]
[null,"TAMAÑO DE LA BATERÍA\n"]
[null,null,"Introduzca el número de días consecutivos que el sistema debe trabajar con un mínimo de luz solar.     \n"]
[null,"Días Autonomía\n",null,"DÍAS"]
[null,"DoD Permitido para la batería que se utiliza",0.4]
[null,null,"Tamaño de la batería   \n"]
[null,"Capacidad total de Ah necesaria\n",{"$f":"IF(OR(ISBLANK(C26),C26=0),\"???\",P17*C26/C27)","v":"???"},"Ah","Preferiblemente ciclo profundo"]

{"sheet":"DATOS","index":1,"n_rows":77,"n_cols":9,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9]
[]
["MOTOR","CORRIENTE NOMINAL - Amp","TIEMPO POR OPERACIÓN - SEGUNDOS ABIERTO Y CERRADO","ENERGÍA CONSUMIDA POR OPERACIÓN (CICLO COMPLETO) - Ah","VOLTAJE DEL SISTEMA","MOTOR","CONSUMO DE CORRIENTE QUIESCENTE - mA","ENERGÍA CONSUMIDA - Ah","FACTOR"]
["D2 Turbo Sliding Gate Operator",8,10,{"$f":"+B4*C4/3600","v":2.2222222222222223E-2},12,"Controller - D2 Turbo",95,{"$f":"+G4*24/1000","v":2.2799999999999998},1]
["D5-EVO Sliding Gate Operator",8,30,6.6666666666666666E-2,12,"Controller - EVO",75,1.8,1]
["D10 Sliding Gate Operator (24VDC system)",6,30,0.05,24,"Controller - D10",80,1.92,0.65]
["D10 Turbo Sliding Gate Operator (24VDC system)",10,20,{"$f":"+B7*C7/3600","v":5.5555555555555552E-2},24,"Controller - D10",80,{"$f":"+G7*24/1000","v":1.92},0.65]
["A10 Sliding Gate Operator (using DC convertor)",20,30,0.16666666666666666,12,"CP201",16,0.38400000000000001,1]
["R3 Single Swing Gate Operator",4,35,{"$f":"+B9*C9/3600","v":3.888888888888889E-2},12,"CP75",16,{"$f":"+G9*24/1000","v":0.38400000000000001},1]
["R3 Double Swing Gate Operator",8,35,{"$f":"+B10*C10/3600","v":7.7777777777777779E-2},12,"CP75",16,{"$f":"+G10*24/1000","v":0.38400000000000001},1]
["R5 Single Swing Gate Operator",5,40,5.5555555555555552E-2,12,"CP75",16,0.38400000000000001,1]
["R5 Double Swing Gate Operator ",10,40,0.1111111111111111,12,"CP75",16,0.38400000000000001,1]
["MAXI-MATE Single Swing Gate Operator",5,40,5.5555555555555552E-2,12,"CP77",25,0.6,1]
["MAXI-MATE Double Swing Gate Operator",10,40,0.1111111111111111,12,"CP77",25,0.6,1]
["VECTOR Single Swing Gate Operator (V400)",2,28,{"$f":"+B15*C15/3600","v":1.5555555555555555E-2},12,"Controller - V-SERIES",48,{"$f":"+G15*24/1000","v":1.1519999999999999},1]
["VECTOR Single Swing Gate  Operator (V500)",2,35,1.9444444444444445E-2,12,"Controller - V-SERIES",48,1.1519999999999999,1]
["VECTOR Double Swing Gate Operator (V400)",4,28,3.111111111111111E-2,12,"Controller - V-SERIES",48,1.1519999999999999,1]
["VECTOR Double Swing Gate Operator (V500)",4,35,3.888888888888889E-2,12,"Controller - V-SERIES",48,1.1519999999999999,1]
["VANTAGE Single Swing Gate Operator (VT400)",2,28,{"$f":"+B19*C19/3600","v":1.5555555555555555E-2},12,"Controller - V-SERIES",73,{"$f":"+G19*24/1000","v":1.752},1]
["VANTAGE Single Swing Gate  Operator (VT500)",2,35,1.9444444444444445E-2,12,"Controller - V-SERIES",48,1.1519999999999999,1]
["VANTAGE Double Swing Gate Operator (VT400)",4,28,3.111111111111111E-2,12,"Controller - V-SERIES",48,1.1519999999999999,1]
["VANTAGE Double Swing Gate Operator (VT500)",4,35,3.888888888888889E-2,12,"Controller - V-SERIES",48,1.1519999999999999,1]
["VERT-X Single Swing Gate Operator (VX300)",2,25,{"$f":"+B23*C23/3600","v":1.3888888888888888E-2},12,"Controller - V-SERIES",48,{"$f":"+G23*24/1000","v":1.1519999999999999},1]
["VERT-X Double Swing Gate Operator (VX300)",4,32,3.5555555555555556E-2,12,"Controller - V-SERIES",48,1.1519999999999999,1]
["SECTOR barrier (3M)",2,2.5,{"$f":"+B25*C25/3600","v":1.3888888888888889E-3},12,"Controller - SECTOR",50,{"$f":"+G25*24/1000","v":1.2},1]
["SECTOR barrier (4.5M or 6.0M)",2,6,3.3333333333333335E-3,12,"Controller - SECTOR",50,1.2,1]
["D5-EVO Sliding Gate Operator with Pulse Stretcher",8.1,30,6.7500000000000004E-2,12,"Controller - EVO",75,1.8,1]
[null,null,null,{"$f":"+B28*C28/3600","v":0},null,null,null,{"$f":"+G28*24/1000","v":0}]
[null,null,null,{"$f":"+B29*C29/3600","v":0},null,null,null,{"$f":"+G29*24/1000","v":0}]
[null,null,null,0,null,null,null,0]
[null,null,null,0,null,null,null,0]
[null,null,null,0,null,null,null,0]
[null,null,null,0,null,null,null,0]
[null,null,null,0,null,null,null,0]
[null,null,null,0,null,null,null,0]
[null,null,null,0,null,null,null,0]
[null,null,null,0,null,null,null,0]
[null,null,null,0,null,null,null,0]
[]
[]
["ACCESORIOS","QUIESCENT CURRENT DRAW  - mA",null,"ENERGÍA CONSUMIDA - Ah","VOLTAJE DEL SISTEMA","CONSUMO PICO"]
["Regulador solar (TES - 30A)",10,null,{"$f":"+B42*24/1000","v":0.24},12]
["Regulador solar 20A (ESOLRPG020V1)",6,null,{"$f":"+B43*24/1000","v":0.14399999999999999},12]
["I5 Sensores infrarrojos - Tx & Rx",67,null,{"$f":"+B44*24/1000","v":1.6080000000000001},12]
["PHOTON Ssensores infrarrojos",30,null,0.72,12]
["Receptor CENTURION de 1 canal",11,null,{"$f":"+B46*24/1000","v":0.26400000000000001},12]
["Receptor CENTURION de 4 canales",25,null,0.6,12,180]
["Supa Helix Receiver",100,null,2.4,12,270]
["G-Switch 22",80,null,1.92,12]
["MYGSM 88",120,null,2.88,12]
["Panel de entrada de POLOphone",35,null,0.84,12]
["Auricular POLOphone",25,null,0.6,12]
["G-Speak Classic (Plus)",30,null,0.72,12]
["Mkii GSM intercomunicador",350,null,8.4,12,150]
["SMARTGUARD (cableado)",32,null,0.76800000000000002,12,180]
["SOLO Lector",50,null,1.2,12,180]
["Lattice Controlador",50,null,1.2,12,180]
["Lattice Lector Esclavo",50,null,{"$f":"+B58*24/1000","v":1.2},12,180]
["Detector de bucle autónomo FLUX",50,null,{"$f":"+B59*24/1000","v":1.2},12]
["Detector de bucle enchufable FLUX 11",50,null,1.2,12]
["Convertidor DC-DC (usado con A10 para respaldo de batería)",150,null,3.6,12]
["Borde de seguridad",30,null,{"$f":"+B62*24/1000","v":0.72},12]
["Ensanchador de pulsos",7,null,{"$f":"+B63*24/1000","v":0.16800000000000001},12]
["G-ULTRA 2G",33,null,{"$f":"+B64*24/1000","v":0.79200000000000004},12]
["G-SPEAK ULTRA 2G",72,null,1.728,12]
["G-ULTRA 3G PENTA BAND",40,null,0.96,12]
[null,null,null,0]
[null,null,null,{"$f":"+B68*24/1000","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[]
["Voltaje del sistema"]
[12]
[24]

{"sheet":"MAPA SOLAR MUNDIAL","index":2,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[[24,0,24,1],[0,0,0,3]]}
["MAPA SOLAR MUNDIAL"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FRANCE"]
["CIUDAD","EFECTIVO"]
["RENNE",1.24]
["NANTES",1.46]
["LE HAVRE",1.18]
["BORDEAUX",1.81]
["TOULOUSE",2.5299999999999998]
["MARSEILLE",2.97]
["NICE",2.58]
["MONTPELLIER",1.65]
["LYON",1.56]
["REIMS",0.95]
["PARIS",1.1100000000000001]

{"sheet":"MAPA SOLAR AFRICA","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["MAPA SOLAR AFRICA"]

{"sheet":"1","index":4,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["solar"]