{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Size solar panel","DATA","Solar Insolation Map (World)","Solar Insolation Map (Africa)","1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":17,"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":"Size solar panel","index":0,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,1,1,1],[25,8,25,13],[1,2,1,10],[14,7,14,10],[5,2,5,9],[29,5,29,6],[0,2,0,13],[18,8,23,13],[25,2,25,7],[17,2,17,7],[27,3,27,6],[28,3,28,6]]}
[null,null,"CENTURION QUICK SOLAR PANEL CALCULATOR"]
[null,null,"Please enter the number of operations per day for the system being used. In addition enter the running current and cycle time if different to default."]
[null,"OPERATOR","Items (qty)","No Of CYCLES Per Day","Quiescent current (mA)","Quiescent energy (Ahr)","Default ACTIVE current (A)","Alternate ACTIVE current (A)","Default CYCLE time (Secs)","Alternate CYCLE time (Secs)","Active consumed Ah (per cycle)","Total active energy (Ahrs)","Total energy (Ahr)","Operator SubTotal (Whrs)"]
[null,null,1,1,{"$f":"IFERROR(VLOOKUP(B4,DATA!$1:$1048576,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B4,DATA!$1:$1048576,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B4,DATA!$1:$1048576,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B4,DATA!$1:$1048576,5,FALSE),\"\")","v":""},null,{"$f":"IF(B4<>\"\",IF(H4<>\"\",H4,G4)*IF(J4<>\"\",J4,I4)/3600,\"\")","v":""},{"$f":"IF(B4<>\"\",D4*K4,\"\")","v":""},{"$f":"IF(B4<>\"\",F4+L4,\"\")","v":""},{"$f":"IF(B4<>\"\",IF(C4<>\"\",C4,1)*M4*IFERROR(VLOOKUP(B4,DATA!$1:$1048576,2,FALSE),\"\"),\"\")","v":""}]
[]
[null,null,"^Please enter the quantity of Centurion auxiliaries being used, and number of utilisations per day"]
[null,"ACCESSORY","Items (qty)","No Of CYCLES Per Day","Quiescent current (mA)","Quiescent energy (Ahr)","Default ACTIVE current (A)","Alternate ACTIVE current (A)","Default CYCLE time (Secs)","Alternate CYCLE time (Secs)",null,null,null,"Accessory SubTotals (Whrs)",null,"^Please enter the quantity of Centurion auxiliaries being used, and number of utilisations per day"]
[null,null,1,1,{"$f":"IFERROR(VLOOKUP(B8,DATA!$1:$1048576,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B8,DATA!$1:$1048576,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B8,DATA!$1:$1048576,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B8,DATA!$1:$1048576,5,FALSE),\"\")","v":""},null,{"$f":"IF(B8<>\"\",IF(H8<>\"\",H8,G8)*IF(J8<>\"\",J8,I8)/3600,\"\")","v":""},{"$f":"IF(B8<>\"\",D8*K8,\"\")","v":""},{"$f":"IF(B8<>\"\",F8+L8,\"\")","v":""},{"$f":"IF(B8<>\"\",IF(C8<>\"\",C8,1)*M8*IFERROR(VLOOKUP(B8,DATA!$1:$1048576,2,FALSE),\"\"),\"\")","v":""}]
[null,null,1,1,{"$f":"IFERROR(VLOOKUP(B9,DATA!$1:$1048576,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,DATA!$1:$1048576,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,DATA!$1:$1048576,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B9,DATA!$1:$1048576,5,FALSE),\"\")","v":""},null,"","","",{"$f":"IF(B9<>\"\",IF(C9<>\"\",C9,1)*M9*IFERROR(VLOOKUP(B9,DATA!$1:$1048576,2,FALSE),\"\"),\"\")","v":""}]
[null,null,1,1,{"$f":"IFERROR(VLOOKUP(B10,DATA!$1:$1048576,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,DATA!$1:$1048576,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,DATA!$1:$1048576,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B10,DATA!$1:$1048576,5,FALSE),\"\")","v":""},null,"","","",{"$f":"IF(B10<>\"\",IF(C10<>\"\",C10,1)*M10*IFERROR(VLOOKUP(B10,DATA!$1:$1048576,2,FALSE),\"\"),\"\")","v":""}]
[null,null,1,1,{"$f":"IFERROR(VLOOKUP(B11,DATA!$1:$1048576,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,DATA!$1:$1048576,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,DATA!$1:$1048576,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B11,DATA!$1:$1048576,5,FALSE),\"\")","v":""},null,"","","",{"$f":"IF(B11<>\"\",IF(C11<>\"\",C11,1)*M11*IFERROR(VLOOKUP(B11,DATA!$1:$1048576,2,FALSE),\"\"),\"\")","v":""}]
[null,null,1,1,{"$f":"IFERROR(VLOOKUP(B12,DATA!$1:$1048576,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,DATA!$1:$1048576,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,DATA!$1:$1048576,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B12,DATA!$1:$1048576,5,FALSE),\"\")","v":""},null,"","","",{"$f":"IF(B12<>\"\",IF(C12<>\"\",C12,1)*M12*IFERROR(VLOOKUP(B12,DATA!$1:$1048576,2,FALSE),\"\"),\"\")","v":""}]
[null,null,1,1,{"$f":"IFERROR(VLOOKUP(B13,DATA!$1:$1048576,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,DATA!$1:$1048576,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,DATA!$1:$1048576,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B13,DATA!$1:$1048576,5,FALSE),\"\")","v":""},null,"","","",{"$f":"IF(B13<>\"\",IF(C13<>\"\",C13,1)*M13*IFERROR(VLOOKUP(B13,DATA!$1:$1048576,2,FALSE),\"\"),\"\")","v":""}]
[null,null,1,1,{"$f":"IFERROR(VLOOKUP(B14,DATA!$1:$1048576,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,DATA!$1:$1048576,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,DATA!$1:$1048576,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B14,DATA!$1:$1048576,5,FALSE),\"\")","v":""},null,"","","",{"$f":"IF(B14<>\"\",IF(C14<>\"\",C14,1)*M14*IFERROR(VLOOKUP(B14,DATA!$1:$1048576,2,FALSE),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,"NETT Power Req (Whrs)",null,null,null,null,null,{"$f":"SUM(N8:N14,N4)","v":0}]
[]
[]
[null,"Panel Size:",{"$f":"IF(VLOOKUP(B4,DATA!$1:$1048576,2,FALSE)=12,\"1 x \" & TEXT(D23,\"0.0\"),\"2 x \" & TEXT(D23/2,\"0.0\")) & \"W (min)\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"Notes:","NB - Please do not forget to select a solar regulator for the system."]
[null,"NETT Power Required:",null,{"$f":"+N15","v":0},null,null,"Whrs"]
[null,"Derate due to dust etc.:",0.2,{"$f":"+D20*(1+C21)","v":0},null,null,"Whrs"]
[null,"Provide overhead to fully charge battery:",0.15,{"$f":"+D21*(1+C22)","v":0},null,null,"Whrs"]
[null,"Geographic Insolation (hrs/day):",4.75,{"$f":"+D21/C23","v":0},null,null,"W"]
[]
[]
[null,"Battery Size:",{"$f":"IF(VLOOKUP(B4,DATA!$1:$1048576,2,FALSE)=12,\"1 x \" & TEXT(D31,\"0.0\"),\"2 x \" & TEXT(D31/2,\"0.0\")) & \"Ah (min):-\"","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"TEXT(Autonomy,\"0.0\") & \" day autonomy\"","v":"1.0 day autonomy"}]
[]
[null,"Autonomy:",1,"Days"]
[null,"DoD Allowable for Battery being used:",0.2,"Preferably deep cycle"]
[]
[null,"Total Ah Capacity Needed:",null,{"$f":"IF(OR(ISBLANK(C28),C28=0),\"???\",D22*C28/C29/VLOOKUP(B4,DATA!$1:$1048576,2,FALSE))","v":{"$error":"#N/A"}},null,null,"Ah"]

{"sheet":"DATA","index":1,"n_rows":81,"n_cols":14,"rows_kept":81,"cut":false,"hidden":false,"merged":[[2,2,2,3],[2,5,2,6],[2,7,2,8],[40,2,40,3],[40,5,40,6],[40,7,40,8]]}
[]
[]
[null,"VOLTS","CURRENT",null,"TIME","ENERGY",null,"WATTS"]
["OPERATOR","SYSTEM VOLTAGE","QUIESCENT CURRENT (mA)","ACTIVE CURRENT (A)","TIME / OPERATION - Secs Active (OPEN & CLOSE, etc.)","Quiescent Ah consummed (per 24hrs)","Active Ah consumed (per cycle)","Quiescent W consumed (per 24hrs)","Active W consumed (per cycle)",null,"CONTROLLER","FACTOR"]
["D2 Turbo Sliding Gate Operator",12,95,8,20,{"$f":"IF(C5>0,C5/1000*24,\"\")","v":2.2800000000000002},{"$f":"IF(A5<>\"\",IF(D5>0,D5*E5/(60*60),C5),\"\")","v":4.4444444444444446E-2},{"$f":"IF(C5>0,F5*B5,\"\")","v":27.360000000000003},{"$f":"IF(D5>0,G5*H5,\"\")","v":1.2160000000000002},null,"Controller - D2 Turbo",1]
["D5-EVO Sliding Gate Operator",12,75,8,30,{"$f":"IF(C6>0,C6/1000*24,\"\")","v":1.7999999999999998},{"$f":"IF(A6<>\"\",IF(D6>0,D6*E6/(60*60),C6),\"\")","v":6.6666666666666666E-2},{"$f":"IF(C6>0,F6*B6,\"\")","v":21.599999999999998},{"$f":"IF(D6>0,G6*H6,\"\")","v":1.44},null,"Controller - EVO",1]
["D10 Sliding Gate Operator (24VDC system)",24,80,6,30,1.92,0.05,46.08,2.3039999999999998,null,"Controller - D10",0.65]
["D10 Turbo Sliding Gate Operator (24VDC system)",24,80,10,20,1.92,5.5555555555555552E-2,46.08,2.5599999999999996,null,"Controller - D10",0.65]
["A10 Sliding Gate Operator (using DC convertor)",12,16,20,30,0.38400000000000001,0.16666666666666666,4.6080000000000005,0.76800000000000002,null,"CP201",1]
["R3 Single Swing Gate Operator",12,16,4,35,0.38400000000000001,3.888888888888889E-2,4.6080000000000005,0.17920000000000003,null,"CP75",1]
["R3 Double Swing Gate Operator",12,16,8,35,0.38400000000000001,7.7777777777777779E-2,4.6080000000000005,0.35840000000000005,null,"CP75",1]
["R5 Single Swing Gate Operator",12,16,5,40,0.38400000000000001,5.5555555555555552E-2,4.6080000000000005,0.25600000000000001,null,"CP75",1]
["R5 Double Swing Gate Operator ",12,16,10,40,0.38400000000000001,0.1111111111111111,4.6080000000000005,0.51200000000000001,null,"CP75",1]
["MAXI-MATE Single Swing Gate Operator",12,25,5,40,0.60000000000000009,5.5555555555555552E-2,7.2000000000000011,0.4,null,"CP77",1]
["MAXI-MATE Double Swing Gate Operator",12,25,10,40,0.60000000000000009,0.1111111111111111,7.2000000000000011,0.8,null,"CP77",1]
["VECTOR Single Swing Gate Operator (V400)",12,48,2,28,1.1520000000000001,1.5555555555555555E-2,13.824000000000002,0.21504000000000001,null,"Controller - V-SERIES",1]
["VECTOR Single Swing Gate  Operator (V500)",12,48,2,35,1.1520000000000001,1.9444444444444445E-2,13.824000000000002,0.26880000000000004,null,"Controller - V-SERIES",1]
["VECTOR Double Swing Gate Operator (V400)",12,48,4,28,1.1520000000000001,3.111111111111111E-2,13.824000000000002,0.43008000000000002,null,"Controller - V-SERIES",1]
["VECTOR Double Swing Gate Operator (V500)",12,48,4,35,1.1520000000000001,3.888888888888889E-2,13.824000000000002,0.53760000000000008,null,"Controller - V-SERIES",1]
["VANTAGE Single Swing Gate Operator (VT400)",12,73,2,28,1.7519999999999998,1.5555555555555555E-2,21.023999999999997,0.32703999999999994,null,"Controller - V-SERIES",1]
["VANTAGE Single Swing Gate  Operator (VT500)",12,48,2,35,1.1520000000000001,1.9444444444444445E-2,13.824000000000002,0.26880000000000004,null,"Controller - V-SERIES",1]
["VANTAGE Double Swing Gate Operator (VT400)",12,48,4,28,1.1520000000000001,3.111111111111111E-2,13.824000000000002,0.43008000000000002,null,"Controller - V-SERIES",1]
["VANTAGE Double Swing Gate Operator (VT500)",12,48,4,35,1.1520000000000001,3.888888888888889E-2,13.824000000000002,0.53760000000000008,null,"Controller - V-SERIES",1]
["VERT-X Single Swing Gate Operator (VX300)",12,48,2,25,1.1520000000000001,1.3888888888888888E-2,13.824000000000002,0.192,null,"Controller - V-SERIES",1]
["VERT-X Double Swing Gate Operator (VX300)",12,48,4,32,1.1520000000000001,3.5555555555555556E-2,13.824000000000002,0.49152000000000007,null,"Controller - V-SERIES",1]
["SECTOR barrier (3M)",12,50,2,2.5,1.2000000000000002,1.3888888888888889E-3,14.400000000000002,2.0000000000000004E-2,null,"Controller - SECTOR",1]
["SECTOR barrier (4.5M or 6.0M)",12,50,2,6,1.2000000000000002,3.3333333333333335E-3,14.400000000000002,4.8000000000000008E-2,null,"Controller - SECTOR",1]
["D5-EVO Sliding Gate Operator with Pulse Stretcher",12,75,8.1,30,1.7999999999999998,6.7500000000000004E-2,21.599999999999998,1.458,null,"Controller - EVO",1]
["D5 Smart Sliding Gate Operator (24VDC system)",24,60,8,25,1.44,5.5555555555555552E-2,34.56,1.92,null,"Controller - DX ",1,null,"5 meter gate @ 32m/min 2.5 sec ramp up and down"]
["D10 Smart Sliding Gate Operator (24VDC system)",24,60,9,35,1.44,8.7499999999999994E-2,34.56,3.024,null,"Controller - DX ",1,null,"6 meter gate @ 24m/min 2.5 sec ramp up and down"]
["D10 Turbo Smart Sliding Gate Operator (24VDC system)",24,60,10,20,1.44,5.5555555555555552E-2,34.56,1.92,null,"Controller - DX ",1,null,"6 meter gate @ 42m/min 2.5 sec ramp up and down"]
["D20 Smart Sliding Gate Operator (24VDC system)",24,60,10,40,1.44,0.1111111111111111,34.56,3.84,null,"Controller - DX ",1,null,"6 meter gate @ 18m/min 2.5 sec ramp up and down"]
["R6 Single Swing Gate Operator",12,25,4,30,0.60000000000000009,3.3333333333333333E-2,7.2000000000000011,0.24000000000000002,null,"CP77",1]
["R6 Double Swing Gate Operator ",12,25,8,30,0.60000000000000009,6.6666666666666666E-2,7.2000000000000011,0.48000000000000004,null,"CP77",1]
[null,null,null,null,null,"","","",""]
[null,null,null,null,null,"","","",""]
[null,null,null,null,null,"","","",""]
[null,null,null,null,null,"","","",""]
[null,null,null,null,null,"","","",""]
[]
[null,"VOLTS","CURRENT",null,"TIME","ENERGY",null,"WATTS"]
["ACCESSORIES",{"$f":"+B4","v":"SYSTEM VOLTAGE"},{"$f":"+C4","v":"QUIESCENT CURRENT (mA)"},"ACTIVE CURRENT (A)","TIME / OPERATION - Secs Active (OPEN & CLOSE, etc.)","Quiescent Ah consummed (per 24hrs)","Active Ah consumed (per cycle)","Quiescent W consumed (per 24hrs)","Active W consumed (per cycle)"]
["Solar regulator 20A (ESOLRPG020V1)",12,6,null,null,{"$f":"IF(C43>0,C43/1000*24,\"\")","v":0.14400000000000002},{"$f":"IF(A43<>\"\",IF(D43>0,D43*E43/(60*60),C43),\"\")","v":6},{"$f":"IF(C43>0,F43*B43,\"\")","v":1.7280000000000002},{"$f":"IF(D43>0,G43*H43,\"\")","v":""}]
["I5 infra red beams - Tx & Rx",12,67,null,null,{"$f":"IF(C44>0,C44/1000*24,\"\")","v":1.6080000000000001},{"$f":"IF(A44<>\"\",IF(D44>0,D44*E44/(60*60),C44),\"\")","v":67},{"$f":"IF(C44>0,F44*B44,\"\")","v":19.295999999999999},{"$f":"IF(D44>0,G44*H44,\"\")","v":""}]
["PHOTON Safety Beams",12,30,null,null,0.72,30,8.64,""]
["1 Channel CENTURION receiver",12,11,null,null,0.26400000000000001,11,3.1680000000000001,""]
["4 Channel CENTURION receiver",12,25,0.18,0.5,0.60000000000000009,2.4999999999999998E-5,7.2000000000000011,1.8000000000000001E-4]
["Supa Helix Receiver",12,100,0.27,0.5,2.4000000000000004,3.7500000000000003E-5,28.800000000000004,1.0800000000000002E-3]
["G-Switch 22",12,80,null,null,1.92,80,23.04,""]
["MYGSM 88",12,120,null,null,2.88,120,34.56,""]
["POLOphone Entry Panel",12,35,null,null,0.84000000000000008,35,10.080000000000002,""]
["POLOphone Handset",12,25,null,null,0.60000000000000009,25,7.2000000000000011,""]
["G-Speak Classic (Plus)",12,30,null,null,0.72,30,8.64,""]
["Mkii GSM intercom",12,350,0.15,null,8.3999999999999986,0,100.79999999999998,0]
["SMARTGUARD (Wired)",12,32,0.18,null,0.76800000000000002,0,9.2160000000000011,0]
["SOLO Reader",12,50,0.18,null,1.2000000000000002,0,14.400000000000002,0]
["Lattice Controller",12,50,0.18,null,1.2000000000000002,0,14.400000000000002,0]
["Lattice Slave Reader",12,50,0.18,null,1.2000000000000002,0,14.400000000000002,0]
["FLUX Stand Alone Loop Detector",12,50,null,null,1.2000000000000002,50,14.400000000000002,""]
["FLUX 11 Plug-in Loop Detector",12,50,null,null,1.2000000000000002,50,14.400000000000002,""]
["DC-DC Converter (used with A10 for battery back-up)",12,150,null,null,3.5999999999999996,150,43.199999999999996,""]
["Safety Edge",12,30,null,null,0.72,30,8.64,""]
["Pulse Stretcher",12,7,null,null,0.16800000000000001,7,2.016,""]
["G-ULTRA 2G",12,33,0.35,15,0.79200000000000004,1.4583333333333334E-3,9.5040000000000013,1.3860000000000003E-2]
["G-SPEAK ULTRA 2G",12,130,0.35,15,3.12,1.4583333333333334E-3,37.44,5.4599999999999996E-2]
["G-ULTRA 3G PENTA BAND",12,130,0.35,15,3.12,1.4583333333333334E-3,37.44,5.4599999999999996E-2]
["WiZo",12,30,null,null,0.72,30,8.64,""]
["Traffic Lights",12,20,null,null,{"$f":"IF(C68>0,C68/1000*24,\"\")","v":0.48},20,{"$f":"IF(C68>0,F68*B68,\"\")","v":5.76},{"$f":"IF(D68>0,G68*H68,\"\")","v":""}]
["CLAWS Controller",12,70,null,null,1.6800000000000002,70,20.160000000000004,""]
["No Touch Pushbutton",12,30,null,null,0.72,30,8.64,""]
[null,null,null,null,null,"","","",""]
[null,null,null,null,null,"","","",""]
[null,null,null,null,null,"","","",""]
[null,null,null,null,null,"","","",""]
[null,null,null,null,null,"","","",""]
[null,null,null,null,null,"","","",""]
[null,null,null,null,null,"","","",""]
[]
["System Voltage"]
[12]
[24]

{"sheet":"Solar Insolation Map (World)","index":2,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[[24,0,24,1],[0,0,0,3]]}
["INSOLATION MAP - World"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FRANCE"]
["CITY","Effective Sun Hours"]
["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":"Solar Insolation Map (Africa)","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["INSOLATION MAP - Africa"]

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