{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Intro","Power Calculator","Loop Calculator","Templates","Data","Loop Calculation AutroSafe","Loop Calculation Autroprime","Data Own Units","Report","Temp"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":2,"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":"Intro","index":0,"n_rows":67,"n_cols":3,"rows_kept":67,"cut":false,"hidden":true,"merged":[[0,0,1,1],[0,2,1,3]]}
["Powercalc",null,"V 1.0.5"]
[]
[]
["Disclaimer"]
["Using this PowerCalc Tool is a theoretical approach to calculate the power consumption in an AutroSafe system, thus the result may not  "]
["be 100% accurate. In a real installation there are many factors that influence the calculation, for example, cable length, resistance, "]
["connectors etc. that are not taken into consideration in this calculation."]
["The result from the calculation must always be reviewed and compared to a real installation."]
[]
["Instructions"]
[]
["There are two tools in this spreadsheet:"]
["Power Calculator","Calculates power for up to 10 AutroSafe systems."]
["Loop Calculator","Calculates power for a detector loop."]
[]
["Power Calculator"]
["Menu"]
[]
[null,"Will add a system, system must be given a name."]
[]
[null,"Will add a power, power must be given a name."]
[]
[null,"Will delete a system. Select system to delete from the dropdown list."]
[]
[null,"Will delete a power. Select power to delete from the dropdown list."]
[]
[null,"Will create a summary report formated for printout on a seperate sheet. "]
[]
[null,"               Toggles between automatic and manual calculation. (Usefull when working with a large number of systems and powers, when the response and calculations feels slov)"]
[]
[null,"Calculates manually (only available when manual calculation has been selected)."]
[]
[]
["How to calculate power consumption for a system"]
[]
["1.","Add systems to your project"]
["2. ","Add powers to your procject"]
["3.","Add the correct number of panels, modules, loop units etc. you are going to use."]
["4.","From the power dropdown list, connect panels and other units to the power you are going to use for that unit."]
["5.","From the output dropdown list, select the output on the power you are going to use."]
["6.","Check the calculation in the power block and review the results."]
[]
["How to calculate power consumption for a AutroSafe detection loop"]
[]
["1.","Add the numbers of AutroGuard detectors you have,"]
["2.","Specify the numbers of AutroGuard add-on cards you have."]
["3.","Add the numbers of other loop units you have."]
["4.","Check that the number of loop units are within the loop capacity, total power consumption is within the limit and the installed cable length for the chosen loop driver does not exceed the maximum length."]
[]
["How to calculate power consumption for a Autroprime detection loop"]
[]
["1.","Add the numbers of AutroGuard detectors you have,"]
["2.","Specify the numbers of AutroGuard add-on cards you have."]
["3.","Add the numbers of other loop units you have."]
["4.","Check that the number of loop units and addresses are within the loop capacity, total power consumption is within the limit and the installed cable length for the chosen loop driver does not exceed the maximum length."]
[]
["Tips"]
[]
["BS-420 and BC-420 in the same system, must be connected to the same power"]
["If BS-420 and BC-420 needs to be connected to different powers, please add 2 systems, 1 with BS-420 and 1 with BC-420"]
[]
["Please check the power connections after deleting a power."]
["When a power is deleted, all units previously using that power will automatically be assigned another power."]
[]
["The Elmdene powers (Power Cabinet STX) have only one output. Output A is used. (Does not matter which output is defined in the system power calculation)"]
[]
["Own units can be added. Please add data for own unit to \"Data Own Units\" sheet"]

{"sheet":"Power Calculator","index":1,"n_rows":108,"n_cols":10,"rows_kept":108,"cut":false,"hidden":true,"merged":[[0,0,1,1]]}
["Powercalc",null,null,null,"Project","(Insert Project Name)"]
[null,null,{"$f":"Intro!C1","v":"V 1.0.5"},null,"Date","(Insert date)"]
[null,"Dummy"]
[]
["System Name","AutroSafe_1"]
["Panels","Panel Type","Amount",null,"Load quiescent","Load alarm","Connect To Power",null,"Output"]
[null,"BS-420",null,null,{"$f":"IF($C7>0,VLOOKUP($B7,Data!$A$2:$C$139,2,FALSE)*$C7,\"\")","v":""},{"$f":"IF($C7>0,VLOOKUP($B7,Data!$A$2:$C$139,3,FALSE)*$C7,\"\")","v":""},null,false,"A1",false]
[null,"BC-420",null,null,{"$f":"IF($C8>0,VLOOKUP($B8,Data!$A$2:$C$139,2,FALSE)*$C8,\"\")","v":""},{"$f":"IF($C8>0,VLOOKUP($B8,Data!$A$2:$C$139,3,FALSE)*$C8,\"\")","v":""},null,false,"A1",false]
[null,"BC-440",null,null,{"$f":"IF($C9>0,VLOOKUP($B9,Data!$A$2:$C$139,2,FALSE)*$C9,\"\")","v":""},{"$f":"IF($C9>0,VLOOKUP($B9,Data!$A$2:$C$139,3,FALSE)*$C9,\"\")","v":""},null,false,"A1",false]
[null,"BS-430",null,null,{"$f":"IF($C10>0,VLOOKUP($B10,Data!$A$2:$C$139,2,FALSE)*$C10,\"\")","v":""},{"$f":"IF($C10>0,VLOOKUP($B10,Data!$A$2:$C$139,3,FALSE)*$C10,\"\")","v":""},null,false,"A1",false]
[null,"BU-420/BV-420",null,null,{"$f":"IF($C11>0,VLOOKUP($B11,Data!$A$2:$C$139,2,FALSE)*$C11,\"\")","v":""},{"$f":"IF($C11>0,VLOOKUP($B11,Data!$A$2:$C$139,3,FALSE)*$C11,\"\")","v":""},null,false,"A1",false]
["Modules","Module","Amount",null,"Load quiescent","Load alarm","Connect To Power",null,"Output"]
[null,"BSS-310A",null,null,{"$f":"IF($C13>0,VLOOKUP($B13,Data!$A$2:$C$139,2,FALSE)*$C13,\"\")","v":""},{"$f":"IF($C13>0,VLOOKUP($B13,Data!$A$2:$C$139,3,FALSE)*$C13,\"\")","v":""},null,false,"A1",false]
[null,"BSS-311",null,null,{"$f":"IF($C14>0,VLOOKUP($B14,Data!$A$2:$C$139,2,FALSE)*$C14,\"\")","v":""},{"$f":"IF($C14>0,VLOOKUP($B14,Data!$A$2:$C$139,3,FALSE)*$C14,\"\")","v":""},null,null,"A1"]
[null,"BSL-310",null,null,{"$f":"IF($C15>0,VLOOKUP($B15,Data!$A$2:$C$139,2,FALSE)*$C15,\"\")","v":""},{"$f":"IF($C15>0,VLOOKUP($B15,Data!$A$2:$C$139,3,FALSE)*$C15,\"\")","v":""}]
[null,"BSD-310",null,null,{"$f":"IF($C16>0,VLOOKUP($B16,Data!$A$2:$C$139,2,FALSE)*$C16,\"\")","v":""},{"$f":"IF($C16>0,VLOOKUP($B16,Data!$A$2:$C$139,3,FALSE)*$C16,\"\")","v":""}]
[null,"BSD-310/N",null,null,{"$f":"IF($C17>0,VLOOKUP($B17,Data!$A$2:$C$139,2,FALSE)*$C17,\"\")","v":""},{"$f":"IF($C17>0,VLOOKUP($B17,Data!$A$2:$C$139,3,FALSE)*$C17,\"\")","v":""}]
[null,"BSD-311",null,null,{"$f":"IF($C18>0,VLOOKUP($B18,Data!$A$2:$C$139,2,FALSE)*$C18,\"\")","v":""},{"$f":"IF($C18>0,VLOOKUP($B18,Data!$A$2:$C$139,3,FALSE)*$C18,\"\")","v":""}]
[null,"BSB-310A",null,null,{"$f":"IF($C19>0,VLOOKUP($B19,Data!$A$2:$C$139,2,FALSE)*$C19,\"\")","v":""},{"$f":"IF($C19>0,VLOOKUP($B19,Data!$A$2:$C$139,3,FALSE)*$C19,\"\")","v":""}]
[null,"BSB-310A Load",null,null,null,null,null,null,"A1"]
[null,"BSJ-310",null,null,{"$f":"IF($C21>0,VLOOKUP($B21,Data!$A$2:$C$139,2,FALSE)*$C21,\"\")","v":""},{"$f":"IF($C21>0,VLOOKUP($B21,Data!$A$2:$C$139,3,FALSE)*$C21,\"\")","v":""}]
[null,"BSE-310",null,null,{"$f":"IF($C22>0,VLOOKUP($B22,Data!$A$2:$C$139,2,FALSE)*$C22,\"\")","v":""},{"$f":"IF($C22>0,VLOOKUP($B22,Data!$A$2:$C$139,3,FALSE)*$C22,\"\")","v":""}]
[null,"BSE-320",null,null,{"$f":"IF($C23>0,VLOOKUP($B23,Data!$A$2:$C$139,2,FALSE)*$C23,\"\")","v":""},{"$f":"IF($C23>0,VLOOKUP($B23,Data!$A$2:$C$139,3,FALSE)*$C23,\"\")","v":""}]
["Loop Units","Detectors","Amount","Total Activated simultanisly","Load quiescent","Load alarm","Connect To Power",null,"Output"]
[null,"MultiSensors",null,null,{"$f":"IF($C25>0,VLOOKUP($B25,Data!$A$2:$C$139,2,FALSE)*$C25,\"\")","v":""},{"$f":"IF($C25>0,VLOOKUP($B25,Data!$A$2:$C$139,3,FALSE)*$C25,\"\")","v":""}]
[null,"Heat detectors",null,null,{"$f":"IF($C26>0,VLOOKUP($B26,Data!$A$2:$C$139,2,FALSE)*$C26,\"\")","v":""},{"$f":"IF($C26>0,VLOOKUP($B26,Data!$A$2:$C$139,3,FALSE)*$C26,\"\")","v":""}]
[null,"Optical detectors",null,null,{"$f":"IF($C27>0,VLOOKUP($B27,Data!$A$2:$C$139,2,FALSE)*$C27,\"\")","v":""},{"$f":"IF($C27>0,VLOOKUP($B27,Data!$A$2:$C$139,3,FALSE)*$C27,\"\")","v":""}]
[null,"Manual callpoints",null,null,{"$f":"IF($C28>0,VLOOKUP($B28,Data!$A$2:$C$139,2,FALSE)*$C28,\"\")","v":""},{"$f":"IF($C28>0,VLOOKUP($B28,Data!$A$2:$C$139,3,FALSE)*$C28,\"\")","v":""}]
[null,"Flame (BG-201)",null,null,{"$f":"IF($C29>0,VLOOKUP($B29,Data!$A$2:$C$139,2,FALSE)*$C29,\"\")","v":""},{"$f":"IF($C29>0,VLOOKUP($B29,Data!$A$2:$C$139,3,FALSE)*$C29,\"\")","v":""}]
[null,"AutroSafe Total No Of LEDs per loop",null,null,{"$f":"IF($C30>0,VLOOKUP($B30,Data!$A$2:$C$139,2,FALSE)*$C30,0)","v":0},{"$f":"IF($D30>0,VLOOKUP($B30,Data!$A$2:$C$139,3,FALSE)*$D30*(C16+C17+C18),\"\")","v":""}]
[null,"Autroguard® Protectors","Amount","Total Activated simultanisly","Load quiescent","Load alarm","Connect To Power",null,"Output"]
["For AutroGuard®","Total no. of AutroGuard®",null,null,{"$f":"IF($C32>0,VLOOKUP($B32,Data!$A$2:$C$139,2,FALSE)*$C32,\"\")","v":""},{"$f":"IF($C32>0,VLOOKUP($B32,Data!$A$2:$C$139,3,FALSE)*$C32,\"\")","v":""}]
[" 1. Add total number of","Sounders Low Volume",null,null,{"$f":"IF($C33>0,VLOOKUP($B33,Data!$A$2:$C$139,2,FALSE)*$C33,\"\")","v":""},{"$f":"IF($D33>0,VLOOKUP($B33,Data!$A$2:$C$139,3,FALSE)*$D33+(($C33-$D33)*VLOOKUP($B33,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
["      detectors","Sounders High Volume",null,null,{"$f":"IF($C34>0,VLOOKUP($B34,Data!$A$2:$C$139,2,FALSE)*$C34,\"\")","v":""},{"$f":"IF($D34>0,VLOOKUP($B34,Data!$A$2:$C$139,3,FALSE)*$D34+(($C34-$D34)*VLOOKUP($B34,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"VAD White High Int. (C-3-12) 0,5Hz",null,null,{"$f":"IF($C35>0,VLOOKUP($B35,Data!$A$2:$C$139,2,FALSE)*$C35,\"\")","v":""},{"$f":"IF($D35>0,VLOOKUP($B35,Data!$A$2:$C$139,3,FALSE)*$D35+(($C35-$D35)*VLOOKUP($B35,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
["2. Add total number of","VAD White Med. Int. (C-3-9) 0,5Hz",null,null,{"$f":"IF($C36>0,VLOOKUP($B36,Data!$A$2:$C$139,2,FALSE)*$C36,\"\")","v":""},{"$f":"IF($D36>0,VLOOKUP($B36,Data!$A$2:$C$139,3,FALSE)*$D36+(($C36-$D36)*VLOOKUP($B36,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
["     additional protectors","VAD White Low Int. (C-3-6) 0,5Hz",null,null,{"$f":"IF($C37>0,VLOOKUP($B37,Data!$A$2:$C$139,2,FALSE)*$C37,\"\")","v":""},{"$f":"IF($D37>0,VLOOKUP($B37,Data!$A$2:$C$139,3,FALSE)*$D37+(($C37-$D37)*VLOOKUP($B37,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"VAD White Open Int. (O-2,5-4) 0,5Hz",null,null,{"$f":"IF($C38>0,VLOOKUP($B38,Data!$A$2:$C$139,2,FALSE)*$C38,\"\")","v":""},{"$f":"IF($D38>0,VLOOKUP($B38,Data!$A$2:$C$139,3,FALSE)*$D38+(($C38-$D38)*VLOOKUP($B38,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
["3. Add total number of","VAD Red High Int. (C-3-8) 0,5Hz",null,null,{"$f":"IF($C39>0,VLOOKUP($B39,Data!$A$2:$C$139,2,FALSE)*$C39,\"\")","v":""},{"$f":"IF($D39>0,VLOOKUP($B39,Data!$A$2:$C$139,3,FALSE)*$D39+(($C39-$D39)*VLOOKUP($B39,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
["     additional protectors","VAD Red Low Int. (C-3-5) 0,5Hz",null,null,{"$f":"IF($C40>0,VLOOKUP($B40,Data!$A$2:$C$139,2,FALSE)*$C40,\"\")","v":""},{"$f":"IF($D40>0,VLOOKUP($B40,Data!$A$2:$C$139,3,FALSE)*$D40+(($C40-$D40)*VLOOKUP($B40,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
["     which shall be ","VAD Red Open Int. (O-2,5-4) 0,5Hz",null,null,{"$f":"IF($C41>0,VLOOKUP($B41,Data!$A$2:$C$139,2,FALSE)*$C41,\"\")","v":""},{"$f":"IF($D41>0,VLOOKUP($B41,Data!$A$2:$C$139,3,FALSE)*$D41+(($C41-$D41)*VLOOKUP($B41,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
["     activated simultanisly","AutroGuard® No Of LEDs per loop",null,null,{"$f":"IF($C42>0,VLOOKUP($B42,Data!$A$2:$C$139,2,FALSE)*$C42,0)","v":0},{"$f":"IF($D42>0,VLOOKUP($B42,Data!$A$2:$C$139,3,FALSE)*$D42*(C16+C17+C18)+$E42,\"\")","v":""}]
[null,"I/O Units","Amount",null,"Load quiescent","Load alarm","Connect To Power",null,"Output"]
[null,"BN-303",null,null,{"$f":"IF($C44>0,VLOOKUP($B44,Data!$A$2:$C$139,2,FALSE)*$C44,\"\")","v":""},{"$f":"IF($C44>0,VLOOKUP($B44,Data!$A$2:$C$139,3,FALSE)*$C44,\"\")","v":""}]
[null,"BN-304",null,null,{"$f":"IF($C45>0,VLOOKUP($B45,Data!$A$2:$C$139,2,FALSE)*$C45,\"\")","v":""},{"$f":"IF($C45>0,VLOOKUP($B45,Data!$A$2:$C$139,3,FALSE)*$C45,\"\")","v":""}]
[null,"BN-305",null,null,{"$f":"IF($C46>0,VLOOKUP($B46,Data!$A$2:$C$139,2,FALSE)*$C46,\"\")","v":""},{"$f":"IF($C46>0,VLOOKUP($B46,Data!$A$2:$C$139,3,FALSE)*$C46,\"\")","v":""}]
[null,"BN-303/LS",null,null,{"$f":"IF($C47>0,VLOOKUP($B47,Data!$A$2:$C$139,2,FALSE)*$C47,\"\")","v":""},{"$f":"IF($C47>0,VLOOKUP($B47,Data!$A$2:$C$139,3,FALSE)*$C47,\"\")","v":""}]
[null,"BN-320/2",null,null,{"$f":"IF($C48>0,VLOOKUP($B48,Data!$A$2:$C$139,2,FALSE)*$C48,\"\")","v":""},{"$f":"IF($C48>0,VLOOKUP($B48,Data!$A$2:$C$139,3,FALSE)*$C48,\"\")","v":""}]
[null,"BN-320/3",null,null,{"$f":"IF($C49>0,VLOOKUP($B49,Data!$A$2:$C$139,2,FALSE)*$C49,\"\")","v":""},{"$f":"IF($C49>0,VLOOKUP($B49,Data!$A$2:$C$139,3,FALSE)*$C49,\"\")","v":""}]
[null,"BN-320/4",null,null,{"$f":"IF($C50>0,VLOOKUP($B50,Data!$A$2:$C$139,2,FALSE)*$C50,\"\")","v":""},{"$f":"IF($C50>0,VLOOKUP($B50,Data!$A$2:$C$139,3,FALSE)*$C50,\"\")","v":""}]
[null,"BN-320/5",null,null,{"$f":"IF($C51>0,VLOOKUP($B51,Data!$A$2:$C$139,2,FALSE)*$C51,\"\")","v":""},{"$f":"IF($C51>0,VLOOKUP($B51,Data!$A$2:$C$139,3,FALSE)*$C51,\"\")","v":""}]
[null,"BN-221/01",null,null,{"$f":"IF($C52>0,VLOOKUP($B52,Data!$A$2:$C$139,2,FALSE)*$C52,\"\")","v":""},{"$f":"IF($C52>0,VLOOKUP($B52,Data!$A$2:$C$139,3,FALSE)*$C52,\"\")","v":""}]
[null,"BN-300",null,null,{"$f":"IF($C53>0,VLOOKUP($B53,Data!$A$2:$C$139,2,FALSE)*$C53,\"\")","v":""},{"$f":"IF($C53>0,VLOOKUP($B53,Data!$A$2:$C$139,3,FALSE)*$C53,\"\")","v":""}]
[null,"GAPB (BN-320/4)",null,null,{"$f":"IF($C54>0,VLOOKUP($B54,Data!$A$2:$C$139,2,FALSE)*$C54,\"\")","v":""},{"$f":"IF($C54>0,VLOOKUP($B54,Data!$A$2:$C$139,3,FALSE)*$C54,\"\")","v":""}]
[null,"BN-221/02",null,null,{"$f":"IF($C55>0,VLOOKUP($B55,Data!$A$2:$C$139,2,FALSE)*$C55,\"\")","v":""},{"$f":"IF($C55>0,VLOOKUP($B55,Data!$A$2:$C$139,3,FALSE)*$C55,\"\")","v":""}]
[null,"BN-201",null,null,{"$f":"IF($C56>0,VLOOKUP($B56,Data!$A$2:$C$139,2,FALSE)*$C56,\"\")","v":""},{"$f":"IF($C56>0,VLOOKUP($B56,Data!$A$2:$C$139,3,FALSE)*$C56,\"\")","v":""}]
[null,"BN-310",null,null,{"$f":"IF($C57>0,VLOOKUP($B57,Data!$A$2:$C$139,2,FALSE)*$C57,\"\")","v":""},{"$f":"IF($C57>0,VLOOKUP($B57,Data!$A$2:$C$139,3,FALSE)*$C57,\"\")","v":""}]
[null,"BN-221/02 (AlCom)",null,null,{"$f":"IF($C58>0,VLOOKUP($B58,Data!$A$2:$C$139,2,FALSE)*$C58,\"\")","v":""},{"$f":"IF($C58>0,VLOOKUP($B58,Data!$A$2:$C$139,3,FALSE)*$C58,\"\")","v":""}]
[null,"BN-221/02 Load",null,null,null,null,null,null,"A1"]
[null,"Sounders/Strobes","Amount","Total Activated simultanisly","Load quiescent","Load alarm","Connect To Power",null,"Output"]
[null,"BBL-100",null,null,{"$f":"IF($C61>0,VLOOKUP($B61,Data!$A$2:$C$139,2,FALSE)*$C61,\"\")","v":""},{"$f":"IF($D61>0,VLOOKUP($B61,Data!$A$2:$C$139,3,FALSE)*$D61+(($C61-$D61)*VLOOKUP($B61,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"BBL-100",null,null,{"$f":"IF($C62>0,VLOOKUP($B62,Data!$A$2:$C$139,2,FALSE)*$C62,\"\")","v":""},{"$f":"IF($D62>0,VLOOKUP($B62,Data!$A$2:$C$139,3,FALSE)*$D62+(($C62-$D62)*VLOOKUP($B62,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"BBR-200",null,null,{"$f":"IF($C63>0,VLOOKUP($B63,Data!$A$2:$C$139,2,FALSE)*$C63,\"\")","v":""},{"$f":"IF($D63>0,VLOOKUP($B63,Data!$A$2:$C$139,3,FALSE)*$D63+(($C63-$D63)*VLOOKUP($B63,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"BBQ-130 LP",null,null,{"$f":"IF($C64>0,VLOOKUP($B64,Data!$A$2:$C$139,2,FALSE)*$C64,\"\")","v":""},{"$f":"IF($D64>0,VLOOKUP($B64,Data!$A$2:$C$139,3,FALSE)*$D64+(($C64-$D64)*VLOOKUP($B64,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"BBR-130 HP",null,null,{"$f":"IF($C65>0,VLOOKUP($B65,Data!$A$2:$C$139,2,FALSE)*$C65,\"\")","v":""},{"$f":"IF($D65>0,VLOOKUP($B65,Data!$A$2:$C$139,3,FALSE)*$D65+(($C65-$D65)*VLOOKUP($B65,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"BBQ-130 HP",null,null,{"$f":"IF($C66>0,VLOOKUP($B66,Data!$A$2:$C$139,2,FALSE)*$C66,\"\")","v":""},{"$f":"IF($D66>0,VLOOKUP($B66,Data!$A$2:$C$139,3,FALSE)*$D66+(($C66-$D66)*VLOOKUP($B66,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"BBQ-230 Indicator+LP",null,null,{"$f":"IF($C67>0,VLOOKUP($B67,Data!$A$2:$C$139,2,FALSE)*$C67,\"\")","v":""},{"$f":"IF($D67>0,VLOOKUP($B67,Data!$A$2:$C$139,3,FALSE)*$D67+(($C67-$D67)*VLOOKUP($B67,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"BBQ-230 Indicator+HP",null,null,{"$f":"IF($C68>0,VLOOKUP($B68,Data!$A$2:$C$139,2,FALSE)*$C68,\"\")","v":""},{"$f":"IF($D68>0,VLOOKUP($B68,Data!$A$2:$C$139,3,FALSE)*$D68+(($C68-$D68)*VLOOKUP($B68,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,false]
[null,"BN-307 (AlCom)",null,null,{"$f":"IF($C69>0,VLOOKUP($B69,Data!$A$2:$C$139,2,FALSE)*$C69,\"\")","v":""},{"$f":"IF($D69>0,VLOOKUP($B69,Data!$A$2:$C$139,3,FALSE)*$D69+(($C69-$D69)*VLOOKUP($B69,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"BN-307 Load",null,null,null,null,null,null,"A1"]
[null,"Other Loop Units","Amount",null,"Load quiescent","Load alarm","Connect To Power",null,"Output"]
[null,"BU-110/BV-110",null,null,{"$f":"IF($C72>0,VLOOKUP($B72,Data!$A$2:$C$139,2,FALSE)*$C72,\"\")","v":""},{"$f":"IF($C72>0,VLOOKUP($B72,Data!$A$2:$C$139,3,FALSE)*$C72,\"\")","v":""}]
[null,"BU-111",null,null,{"$f":"IF($C73>0,VLOOKUP($B73,Data!$A$2:$C$139,2,FALSE)*$C73,\"\")","v":""},{"$f":"IF($C73>0,VLOOKUP($B73,Data!$A$2:$C$139,3,FALSE)*$C73,\"\")","v":""}]
[null,"BU-200",null,null,{"$f":"IF($C74>0,VLOOKUP($B74,Data!$A$2:$C$139,2,FALSE)*$C74,\"\")","v":""},{"$f":"IF($C74>0,VLOOKUP($B74,Data!$A$2:$C$139,3,FALSE)*$C74,\"\")","v":""}]
[null,"BN-180 (Alcom)",null,null,{"$f":"IF($C75>0,VLOOKUP($B75,Data!$A$2:$C$139,2,FALSE)*$C75,\"\")","v":""},{"$f":"IF($C75>0,VLOOKUP($B75,Data!$A$2:$C$139,3,FALSE)*$C75,\"\")","v":""},null,null,null,false]
[null,"BN-180 (External)",null,null,{"$f":"IF($C76>0,VLOOKUP($B76,Data!$A$2:$C$139,2,FALSE)*$C76,\"\")","v":""},{"$f":"IF($C76>0,VLOOKUP($B76,Data!$A$2:$C$139,3,FALSE)*$C76,\"\")","v":""},null,false,"A1"]
[null,"BNB-330A (Alcom)",null,null,{"$f":"IF($C77>0,VLOOKUP($B77,Data!$A$2:$C$139,2,FALSE)*$C77,\"\")","v":""},{"$f":"IF($C77>0,VLOOKUP($B77,Data!$A$2:$C$139,3,FALSE)*$C77,\"\")","v":""}]
[null,"BNB-330A (External)",null,null,{"$f":"IF($C78>0,VLOOKUP($B78,Data!$A$2:$C$139,2,FALSE)*$C78,\"\")","v":""},{"$f":"IF($C78>0,VLOOKUP($B78,Data!$A$2:$C$139,3,FALSE)*$C78,\"\")","v":""},null,false,"A1",false]
[null,"BNB-330/BNB-331 (AlCom)",null,null,{"$f":"IF($C79>0,VLOOKUP($B79,Data!$A$2:$C$139,2,FALSE)*$C79,\"\")","v":""},{"$f":"IF($C79>0,VLOOKUP($B79,Data!$A$2:$C$139,3,FALSE)*$C79,\"\")","v":""}]
[null,"BNB-330/BNB-331 (External)",null,null,{"$f":"IF($C80>0,VLOOKUP($B80,Data!$A$2:$C$139,2,FALSE)*$C80,\"\")","v":""},{"$f":"IF($C80>0,VLOOKUP($B80,Data!$A$2:$C$139,3,FALSE)*$C80,\"\")","v":""},null,false,"A1",false]
[null,"BW-200/BW-201",null,null,{"$f":"IF($C81>0,VLOOKUP($B81,Data!$A$2:$C$139,2,FALSE)*$C81,\"\")","v":""},{"$f":"IF($C81>0,VLOOKUP($B81,Data!$A$2:$C$139,3,FALSE)*$C81,\"\")","v":""},null,false,null,false]
[null,"BW-202/BW-203",null,null,{"$f":"IF($C82>0,VLOOKUP($B82,Data!$A$2:$C$139,2,FALSE)*$C82,\"\")","v":""},{"$f":"IF($C82>0,VLOOKUP($B82,Data!$A$2:$C$139,3,FALSE)*$C82,\"\")","v":""},null,false,null,false]
["Special Detection",null,"Amount",null,"Load quiescent","Load alarm","Connect To Power",null,"Output"]
[null,"AutroSense 200 Stl. Cmd.Mod.",null,null,{"$f":"IF($C84>0,VLOOKUP($B84,Data!$A$2:$C$139,2,FALSE)*$C84,\"\")","v":""},{"$f":"IF($C84>0,VLOOKUP($B84,Data!$A$2:$C$139,3,FALSE)*$C84,\"\")","v":""},null,false,"A1"]
[null,"AutroSense Micra 25",null,null,{"$f":"IF($C85>0,VLOOKUP($B85,Data!$A$2:$C$139,2,FALSE)*$C85,\"\")","v":""},{"$f":"IF($C85>0,VLOOKUP($B85,Data!$A$2:$C$139,3,FALSE)*$C85,\"\")","v":""},null,false,"A1"]
[null,"AutroSense Micra 10",null,null,{"$f":"IF($C86>0,VLOOKUP($B86,Data!$A$2:$C$139,2,FALSE)*$C86,\"\")","v":""},{"$f":"IF($C86>0,VLOOKUP($B86,Data!$A$2:$C$139,3,FALSE)*$C86,\"\")","v":""},null,false,"A1"]
[null,"AutroSense Micra 10",null,null,{"$f":"IF($C87>0,VLOOKUP($B87,Data!$A$2:$C$139,2,FALSE)*$C87,\"\")","v":""},{"$f":"IF($C87>0,VLOOKUP($B87,Data!$A$2:$C$139,3,FALSE)*$C87,\"\")","v":""},null,false,"A1"]
[null,"AutroSense Micra 10",null,null,{"$f":"IF($C88>0,VLOOKUP($B88,Data!$A$2:$C$139,2,FALSE)*$C88,\"\")","v":""},{"$f":"IF($C88>0,VLOOKUP($B88,Data!$A$2:$C$139,3,FALSE)*$C88,\"\")","v":""},null,false,"A1"]
[null,"AutroSense Micra 10",null,null,{"$f":"IF($C89>0,VLOOKUP($B89,Data!$A$2:$C$139,2,FALSE)*$C89,\"\")","v":""},{"$f":"IF($C89>0,VLOOKUP($B89,Data!$A$2:$C$139,3,FALSE)*$C89,\"\")","v":""},null,false,"A1"]
[null,"AutroSense Micra 10",null,null,{"$f":"IF($C90>0,VLOOKUP($B90,Data!$A$2:$C$139,2,FALSE)*$C90,\"\")","v":""},{"$f":"IF($C90>0,VLOOKUP($B90,Data!$A$2:$C$139,3,FALSE)*$C90,\"\")","v":""},null,false,"A1"]
[null,"AutroSense Micra 10",null,null,{"$f":"IF($C91>0,VLOOKUP($B91,Data!$A$2:$C$139,2,FALSE)*$C91,\"\")","v":""},{"$f":"IF($C91>0,VLOOKUP($B91,Data!$A$2:$C$139,3,FALSE)*$C91,\"\")","v":""},null,false,"A1"]
["Ex Equipment",null,"Amount",null,"Load quiescent","Load alarm","Connect To Power",null,"Output"]
[null,"BZ-500",null,null,{"$f":"IF($C93>0,VLOOKUP($B93,Data!$A$2:$C$139,2,FALSE)*$C93,\"\")","v":""},{"$f":"IF($C93>0,VLOOKUP($B93,Data!$A$2:$C$139,3,FALSE)*$C93,\"\")","v":""},null,false,"A1",false]
["Communication","Switches","Amount",null,"Load quiescent","Load alarm","Connect To Power",null,"Output"]
[null,"FL SWITCH LM 4TX/2FX",null,null,{"$f":"IF($C95>0,VLOOKUP($B95,Data!$A$2:$C$139,2,FALSE)*$C95,\"\")","v":""},{"$f":"IF($C95>0,VLOOKUP($B95,Data!$A$2:$C$139,3,FALSE)*$C95,\"\")","v":""},null,false,"A1",false]
[null,"FL SWITCH LM 4TX/2FX SM",null,null,{"$f":"IF($C96>0,VLOOKUP($B96,Data!$A$2:$C$139,2,FALSE)*$C96,\"\")","v":""},{"$f":"IF($C96>0,VLOOKUP($B96,Data!$A$2:$C$139,3,FALSE)*$C96,\"\")","v":""},null,false,"A1",false]
[null,"FL SWITCH LM 4TX/2FX SM",null,null,{"$f":"IF($C97>0,VLOOKUP($B97,Data!$A$2:$C$139,2,FALSE)*$C97,\"\")","v":""},{"$f":"IF($C97>0,VLOOKUP($B97,Data!$A$2:$C$139,3,FALSE)*$C97,\"\")","v":""},null,false,"A1",false]
[null,"FL SWITCH LM 4TX/2FX SM",null,null,{"$f":"IF($C98>0,VLOOKUP($B98,Data!$A$2:$C$139,2,FALSE)*$C98,\"\")","v":""},{"$f":"IF($C98>0,VLOOKUP($B98,Data!$A$2:$C$139,3,FALSE)*$C98,\"\")","v":""},null,false,"A1",false]
["Miscellaneous"]
[null,"BSL-321",null,null,{"$f":"IF($C100>0,VLOOKUP($B100,Data!$A$2:$C$139,2,FALSE)*$C100,\"\")","v":""},{"$f":"IF($C100>0,VLOOKUP($B100,Data!$A$2:$C$139,3,FALSE)*$C100,\"\")","v":""},null,false,"A1"]
[null,"BSL-322",null,null,{"$f":"IF($C101>0,VLOOKUP($B101,Data!$A$2:$C$139,2,FALSE)*$C101,\"\")","v":""},{"$f":"IF($C101>0,VLOOKUP($B101,Data!$A$2:$C$139,3,FALSE)*$C101,\"\")","v":""},null,null,"A1"]
[null,"BSL-337",null,null,{"$f":"IF($C102>0,VLOOKUP($B102,Data!$A$2:$C$139,2,FALSE)*$C102,\"\")","v":""},{"$f":"IF($C102>0,VLOOKUP($B102,Data!$A$2:$C$139,3,FALSE)*$C102,\"\")","v":""},null,null,"A1"]
[null,"BSD-321/1",null,null,{"$f":"IF($C103>0,VLOOKUP($B103,Data!$A$2:$C$139,2,FALSE)*$C103,\"\")","v":""},{"$f":"IF($C103>0,VLOOKUP($B103,Data!$A$2:$C$139,3,FALSE)*$C103,\"\")","v":""},null,null,"A1"]
["Own Units",null,"Amount",null,"Load quiescent","Load alarm","Connect To Power",null,"Output"]
[null,"Example",null,null,{"$f":"IF($C105>0,VLOOKUP($B105,'Data Own Units'!$A$2:$C$103,2,FALSE)*$C105,\"\")","v":""},{"$f":"IF($C105>0,VLOOKUP($B105,'Data Own Units'!$A$2:$C$103,3,FALSE)*$C105,\"\")","v":""},null,false,"A1"]
[null,"Example",null,null,{"$f":"IF($C106>0,VLOOKUP($B106,'Data Own Units'!$A$2:$C$103,2,FALSE)*$C106,\"\")","v":""},{"$f":"IF($C106>0,VLOOKUP($B106,'Data Own Units'!$A$2:$C$103,3,FALSE)*$C106,\"\")","v":""},null,null,"A1"]
[null,"Example",null,null,{"$f":"IF($C107>0,VLOOKUP($B107,'Data Own Units'!$A$2:$C$103,2,FALSE)*$C107,\"\")","v":""},{"$f":"IF($C107>0,VLOOKUP($B107,'Data Own Units'!$A$2:$C$103,3,FALSE)*$C107,\"\")","v":""},null,null,"A1"]
[null,"Example",null,null,{"$f":"IF($C108>0,VLOOKUP($B108,'Data Own Units'!$A$2:$C$103,2,FALSE)*$C108,\"\")","v":""},{"$f":"IF($C108>0,VLOOKUP($B108,'Data Own Units'!$A$2:$C$103,3,FALSE)*$C108,\"\")","v":""},null,null,"A1"]

{"sheet":"Loop Calculator","index":2,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":true,"merged":[[0,0,1,1],[4,5,4,6]]}
["Loop Calculator"]
[null,null,null,null,null,"Total load quiescent","Total load  alarm"]
[null,null,"Loop Driver   ","BSD-310",null,{"$f":"SUM(E9:E60)","v":0},{"$f":"SUM(F9:F60)","v":0}]
[null,null,"Maximum available loop current   ",{"$f":"IF(D3=\"BSD-310\",\"100 mA\",\"200 mA\")","v":"100 mA"},null,"Within Capacity",{"$f":"IF(D3=\"BSD-310\",IF(G3<100,\"OK\",\"No Fix\"),IF(G3<200,\"OK\",\"No Fix\"))","v":"OK"}]
[null,15,null,null,null,"Maximum loop cable length"]
[null,42,null,null,"Cable  Cross Section  ","BSD-310","BSD-311"]
[null,2,null,0.8,"0,75 mm2",{"$f":"VLOOKUP($E$7,Data!$J$2:$L$6,2,FALSE)","v":"1100 m"},{"$f":"VLOOKUP($E$7,Data!$J$2:$L$6,3,FALSE)","v":"430 m"}]
["Loop Units","AutroSafe Detectors","Amount","Total Activated simultanisly","Load quiescent","Load alarm"]
[null,"MultiSensors",null,null,{"$f":"IF($C9>0,VLOOKUP($B9,Data!$A$2:$C$139,2,FALSE)*$C9,\"\")","v":""},{"$f":"IF($C9>0,VLOOKUP($B9,Data!$A$2:$C$139,3,FALSE)*$C9,\"\")","v":""}]
[null,"Heat detectors",null,null,{"$f":"IF($C10>0,VLOOKUP($B10,Data!$A$2:$C$139,2,FALSE)*$C10,\"\")","v":""},{"$f":"IF($C10>0,VLOOKUP($B10,Data!$A$2:$C$139,3,FALSE)*$C10,\"\")","v":""}]
[null,"Optical detectors",null,null,{"$f":"IF($C11>0,VLOOKUP($B11,Data!$A$2:$C$139,2,FALSE)*$C11,\"\")","v":""},{"$f":"IF($C11>0,VLOOKUP($B11,Data!$A$2:$C$139,3,FALSE)*$C11,\"\")","v":""}]
[null,"Manual callpoints",null,null,{"$f":"IF($C12>0,VLOOKUP($B12,Data!$A$2:$C$139,2,FALSE)*$C12,\"\")","v":""},{"$f":"IF($C12>0,VLOOKUP($B12,Data!$A$2:$C$139,3,FALSE)*$C12,\"\")","v":""}]
[null,"Flame (BG-201)",null,null,{"$f":"IF($C13>0,VLOOKUP($B13,Data!$A$2:$C$139,2,FALSE)*$C13,\"\")","v":""},{"$f":"IF($C13>0,VLOOKUP($B13,Data!$A$2:$C$139,3,FALSE)*$C13,\"\")","v":""}]
[null,"AutroSafe Total No Of LEDs per loop",null,null,{"$f":"IF($D14>0,VLOOKUP($B14,Data!$A$2:$C$139,2,FALSE)*$C14,\"\")","v":""},{"$f":"IF($D14>0,VLOOKUP($B14,Data!$A$2:$C$139,3,FALSE)*$D14,\"\")","v":""}]
[null,"AutroGuard® Protectors","Amount","Total Activated simultanisly","Load quiescent","Load alarm"]
["For AutroGuard®","Total no. of AutroGuard®",null,null,{"$f":"IF($C16>0,VLOOKUP($B16,Data!$A$2:$C$139,2,FALSE)*$C16,\"\")","v":""},{"$f":"IF($C16>0,VLOOKUP($B16,Data!$A$2:$C$139,3,FALSE)*$C16,\"\")","v":""}]
[" 1. Add total number of","Sounders low volume",null,null,{"$f":"IF($C17>0,VLOOKUP($B17,Data!$A$2:$C$139,2,FALSE)*$C17,\"\")","v":""},{"$f":"IF($D17>0,VLOOKUP($B17,Data!$A$2:$C$139,3,FALSE)*$D17+(($C17-$D17)*VLOOKUP($B17,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
["      detectors","Sounders high volume",null,null,{"$f":"IF($C18>0,VLOOKUP($B18,Data!$A$2:$C$139,2,FALSE)*$C18,\"\")","v":""},{"$f":"IF($D18>0,VLOOKUP($B18,Data!$A$2:$C$139,3,FALSE)*$D18+(($C18-$D18)*VLOOKUP($B18,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"VAD White Low Int. (C-3-6) 1Hz",null,null,{"$f":"IF($C19>0,VLOOKUP($B19,Data!$A$2:$C$139,2,FALSE)*$C19,\"\")","v":""},{"$f":"IF($D19>0,VLOOKUP($B19,Data!$A$2:$C$139,3,FALSE)*$D19+(($C19-$D19)*VLOOKUP($B19,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
["2. Add total number of","VAD White Med. Int. (C-3-9) 1Hz",null,null,{"$f":"IF($C20>0,VLOOKUP($B20,Data!$A$2:$C$139,2,FALSE)*$C20,\"\")","v":""},{"$f":"IF($D20>0,VLOOKUP($B20,Data!$A$2:$C$139,3,FALSE)*$D20+(($C20-$D20)*VLOOKUP($B20,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
["     additional protectors","VAD White Low Int. (C-3-6) 0,5Hz",null,null,{"$f":"IF($C21>0,VLOOKUP($B21,Data!$A$2:$C$139,2,FALSE)*$C21,\"\")","v":""},{"$f":"IF($D21>0,VLOOKUP($B21,Data!$A$2:$C$139,3,FALSE)*$D21+(($C21-$D21)*VLOOKUP($B21,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"VAD White Open Int. (O-2,5-4) 0,5Hz",null,null,{"$f":"IF($C22>0,VLOOKUP($B22,Data!$A$2:$C$139,2,FALSE)*$C22,\"\")","v":""},{"$f":"IF($D22>0,VLOOKUP($B22,Data!$A$2:$C$139,3,FALSE)*$D22+(($C22-$D22)*VLOOKUP($B22,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
["3. Add total number of","VAD Red High Int. (C-3-8) 0,5Hz",null,null,{"$f":"IF($C23>0,VLOOKUP($B23,Data!$A$2:$C$139,2,FALSE)*$C23,\"\")","v":""},{"$f":"IF($D23>0,VLOOKUP($B23,Data!$A$2:$C$139,3,FALSE)*$D23+(($C23-$D23)*VLOOKUP($B23,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
["     additional protectors","VAD Red Low Int. (C-3-5) 0,5Hz",null,null,{"$f":"IF($C24>0,VLOOKUP($B24,Data!$A$2:$C$139,2,FALSE)*$C24,\"\")","v":""},{"$f":"IF($D24>0,VLOOKUP($B24,Data!$A$2:$C$139,3,FALSE)*$D24+(($C24-$D24)*VLOOKUP($B24,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
["     which shall be ","VAD Red Open Int. (O-2,5-4) 0,5Hz",null,null,{"$f":"IF($C25>0,VLOOKUP($B25,Data!$A$2:$C$139,2,FALSE)*$C25,\"\")","v":""},{"$f":"IF($D25>0,VLOOKUP($B25,Data!$A$2:$C$139,3,FALSE)*$D25+(($C25-$D25)*VLOOKUP($B25,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
["     activated simultanisly","AutroGuard® No Of LEDs per loop",null,null,{"$f":"IF($D26>0,VLOOKUP($B26,Data!$A$2:$C$139,2,FALSE)*$D26,\"\")","v":""},{"$f":"IF($D26>0,VLOOKUP($B26,Data!$A$2:$C$139,3,FALSE)*$D26+$E26,\"\")","v":""}]
[null,"I/O Units","Amount",null,"Load quiescent","Load alarm"]
[null,"BN-303",null,null,{"$f":"IF($C28>0,VLOOKUP($B28,Data!$A$2:$C$139,2,FALSE)*$C28,\"\")","v":""},{"$f":"IF($C28>0,VLOOKUP($B28,Data!$A$2:$C$139,3,FALSE)*$C28,\"\")","v":""}]
[null,"BN-304",null,null,{"$f":"IF($C29>0,VLOOKUP($B29,Data!$A$2:$C$139,2,FALSE)*$C29,\"\")","v":""},{"$f":"IF($C29>0,VLOOKUP($B29,Data!$A$2:$C$139,3,FALSE)*$C29,\"\")","v":""}]
[null,"BN-305",null,null,{"$f":"IF($C30>0,VLOOKUP($B30,Data!$A$2:$C$139,2,FALSE)*$C30,\"\")","v":""},{"$f":"IF($C30>0,VLOOKUP($B30,Data!$A$2:$C$139,3,FALSE)*$C30,\"\")","v":""}]
[null,"BN-303/LS",null,null,{"$f":"IF($C31>0,VLOOKUP($B31,Data!$A$2:$C$139,2,FALSE)*$C31,\"\")","v":""},{"$f":"IF($C31>0,VLOOKUP($B31,Data!$A$2:$C$139,3,FALSE)*$C31,\"\")","v":""}]
[null,"BN-320/2",null,null,{"$f":"IF($C32>0,VLOOKUP($B32,Data!$A$2:$C$139,2,FALSE)*$C32,\"\")","v":""},{"$f":"IF($C32>0,VLOOKUP($B32,Data!$A$2:$C$139,3,FALSE)*$C32,\"\")","v":""}]
[null,"BN-320/3",null,null,{"$f":"IF($C33>0,VLOOKUP($B33,Data!$A$2:$C$139,2,FALSE)*$C33,\"\")","v":""},{"$f":"IF($C33>0,VLOOKUP($B33,Data!$A$2:$C$139,3,FALSE)*$C33,\"\")","v":""}]
[null,"BN-320/4",null,null,{"$f":"IF($C34>0,VLOOKUP($B34,Data!$A$2:$C$139,2,FALSE)*$C34,\"\")","v":""},{"$f":"IF($C34>0,VLOOKUP($B34,Data!$A$2:$C$139,3,FALSE)*$C34,\"\")","v":""}]
[null,"BN-320/5",null,null,{"$f":"IF($C35>0,VLOOKUP($B35,Data!$A$2:$C$139,2,FALSE)*$C35,\"\")","v":""},{"$f":"IF($C35>0,VLOOKUP($B35,Data!$A$2:$C$139,3,FALSE)*$C35,\"\")","v":""}]
[null,"BN-221/01",null,null,{"$f":"IF($C36>0,VLOOKUP($B36,Data!$A$2:$C$139,2,FALSE)*$C36,\"\")","v":""},{"$f":"IF($C36>0,VLOOKUP($B36,Data!$A$2:$C$139,3,FALSE)*$C36,\"\")","v":""}]
[null,"BN-300",null,null,{"$f":"IF($C37>0,VLOOKUP($B37,Data!$A$2:$C$139,2,FALSE)*$C37,\"\")","v":""},{"$f":"IF($C37>0,VLOOKUP($B37,Data!$A$2:$C$139,3,FALSE)*$C37,\"\")","v":""}]
[null,"GAPB (BN-320/4)",null,null,{"$f":"IF($C38>0,VLOOKUP($B38,Data!$A$2:$C$139,2,FALSE)*$C38,\"\")","v":""},{"$f":"IF($C38>0,VLOOKUP($B38,Data!$A$2:$C$139,3,FALSE)*$C38,\"\")","v":""}]
[null,"BN-221/02",null,null,{"$f":"IF($C39>0,VLOOKUP($B39,Data!$A$2:$C$139,2,FALSE)*$C39,\"\")","v":""},{"$f":"IF($C39>0,VLOOKUP($B39,Data!$A$2:$C$139,3,FALSE)*$C39,\"\")","v":""}]
[null,"BN-201",null,null,{"$f":"IF($C40>0,VLOOKUP($B40,Data!$A$2:$C$139,2,FALSE)*$C40,\"\")","v":""},{"$f":"IF($C40>0,VLOOKUP($B40,Data!$A$2:$C$139,3,FALSE)*$C40,\"\")","v":""}]
[null,"BN-310",null,null,{"$f":"IF($C41>0,VLOOKUP($B41,Data!$A$2:$C$139,2,FALSE)*$C41,\"\")","v":""},{"$f":"IF($C41>0,VLOOKUP($B41,Data!$A$2:$C$139,3,FALSE)*$C41,\"\")","v":""}]
[null,"BN-221/02 (AlCom)",null,null,{"$f":"IF($C42>0,VLOOKUP($B42,Data!$A$2:$C$139,2,FALSE)*$C42,\"\")","v":""},{"$f":"IF($C42>0,VLOOKUP($B42,Data!$A$2:$C$139,3,FALSE)*$C42,\"\")","v":""}]
[null,"Sounders/Strobes","Amount","Total Activated simultanisly","Load quiescent","Load alarm"]
[null,"BBL-100",null,null,{"$f":"IF($C44>0,VLOOKUP($B44,Data!$A$2:$C$139,2,FALSE)*$C44,\"\")","v":""},{"$f":"IF($D44>0,VLOOKUP($B44,Data!$A$2:$C$139,3,FALSE)*$D44+(($C44-$D44)*VLOOKUP($B44,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"BBR-130 LP",null,null,{"$f":"IF($C45>0,VLOOKUP($B45,Data!$A$2:$C$139,2,FALSE)*$C45,\"\")","v":""},{"$f":"IF($D45>0,VLOOKUP($B45,Data!$A$2:$C$139,3,FALSE)*$D45+(($C45-$D45)*VLOOKUP($B45,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"BBR-230 LP",null,null,{"$f":"IF($C46>0,VLOOKUP($B46,Data!$A$2:$C$139,2,FALSE)*$C46,\"\")","v":""},{"$f":"IF($D46>0,VLOOKUP($B46,Data!$A$2:$C$139,3,FALSE)*$D46+(($C46-$D46)*VLOOKUP($B46,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"BBQ-130 Indicator+HP",null,null,{"$f":"IF($C47>0,VLOOKUP($B47,Data!$A$2:$C$139,2,FALSE)*$C47,\"\")","v":""},{"$f":"IF($D47>0,VLOOKUP($B47,Data!$A$2:$C$139,3,FALSE)*$D47+(($C47-$D47)*VLOOKUP($B47,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"BBQ-230 LP",null,null,{"$f":"IF($C48>0,VLOOKUP($B48,Data!$A$2:$C$139,2,FALSE)*$C48,\"\")","v":""},{"$f":"IF($D48>0,VLOOKUP($B48,Data!$A$2:$C$139,3,FALSE)*$D48+(($C48-$D48)*VLOOKUP($B48,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"BBR-230 HP",null,null,{"$f":"IF($C49>0,VLOOKUP($B49,Data!$A$2:$C$139,2,FALSE)*$C49,\"\")","v":""},{"$f":"IF($D49>0,VLOOKUP($B49,Data!$A$2:$C$139,3,FALSE)*$D49+(($C49-$D49)*VLOOKUP($B49,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"BBQ-130 Indicator",null,null,{"$f":"IF($C50>0,VLOOKUP($B50,Data!$A$2:$C$139,2,FALSE)*$C50,\"\")","v":""},{"$f":"IF($D50>0,VLOOKUP($B50,Data!$A$2:$C$139,3,FALSE)*$D50+(($C50-$D50)*VLOOKUP($B50,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""}]
[null,"BN-307 (AlCom)",null,null,{"$f":"IF($C51>0,VLOOKUP($B51,Data!$A$2:$C$139,2,FALSE)*$C51,\"\")","v":""},{"$f":"IF($C51>0,VLOOKUP($B51,Data!$A$2:$C$139,3,FALSE)*$C51,\"\")","v":""}]
[null,"Other Loop Units","Amount",null,"Load quiescent","Load alarm"]
[null,"BU-110/BV-110",null,null,{"$f":"IF($C53>0,VLOOKUP($B53,Data!$A$2:$C$139,2,FALSE)*$C53,\"\")","v":""},{"$f":"IF($C53>0,VLOOKUP($B53,Data!$A$2:$C$139,3,FALSE)*$C53,\"\")","v":""}]
[null,"BU-111",null,null,{"$f":"IF($C54>0,VLOOKUP($B54,Data!$A$2:$C$139,2,FALSE)*$C54,\"\")","v":""},{"$f":"IF($C54>0,VLOOKUP($B54,Data!$A$2:$C$139,3,FALSE)*$C54,\"\")","v":""}]
[null,"BU-200",null,null,{"$f":"IF($C55>0,VLOOKUP($B55,Data!$A$2:$C$139,2,FALSE)*$C55,\"\")","v":""},{"$f":"IF($C55>0,VLOOKUP($B55,Data!$A$2:$C$139,3,FALSE)*$C55,\"\")","v":""}]
[null,"BN-180 (Alcom)",null,null,{"$f":"IF($C56>0,VLOOKUP($B56,Data!$A$2:$C$139,2,FALSE)*$C56,\"\")","v":""},{"$f":"IF($C56>0,VLOOKUP($B56,Data!$A$2:$C$139,3,FALSE)*$C56,\"\")","v":""},false]
[null,"BNB-330A (Alcom)",null,null,{"$f":"IF($C57>0,VLOOKUP($B57,Data!$A$2:$C$139,2,FALSE)*$C57,\"\")","v":""},{"$f":"IF($C57>0,VLOOKUP($B57,Data!$A$2:$C$139,3,FALSE)*$C57,\"\")","v":""},false]
[null,"BNB-330/BNB-331 (AlCom)",null,null,{"$f":"IF($C58>0,VLOOKUP($B58,Data!$A$2:$C$139,2,FALSE)*$C58,\"\")","v":""},{"$f":"IF($C58>0,VLOOKUP($B58,Data!$A$2:$C$139,3,FALSE)*$C58,\"\")","v":""},false]
[null,"BW-200/BW-201",null,null,{"$f":"IF($C59>0,VLOOKUP($B59,Data!$A$2:$C$139,2,FALSE)*$C59,\"\")","v":""},{"$f":"IF($C59>0,VLOOKUP($B59,Data!$A$2:$C$139,3,FALSE)*$C59,\"\")","v":""}]
[null,"BW-202/BW-203",null,null,{"$f":"IF($C60>0,VLOOKUP($B60,Data!$A$2:$C$139,2,FALSE)*$C60,\"\")","v":""},{"$f":"IF($C60>0,VLOOKUP($B60,Data!$A$2:$C$139,3,FALSE)*$C60,\"\")","v":""}]

{"sheet":"Templates","index":3,"n_rows":105,"n_cols":25,"rows_kept":105,"cut":false,"hidden":true,"merged":[[3,12,3,14],[40,24,41,24],[40,20,41,20],[40,21,41,21],[40,22,41,22],[40,23,41,23]]}
["System Template",null,null,null,null,null,null,null,null,null,null,"Power Template",null,null,null,null,null,null,null,null,"Report Template Heading"]
["System Name",null,null,null,null,null,null,null,null,null,null,"Power Name",null,null,null,null,null,null,null,null,"Power Calculation Report"]
["Panels","Panel Type","Amount",null,"Load quiescent","Load alarm","Connect To Power",null,"Output"]
[null,"BS-420",null,null,{"$f":"IF($C4>0,VLOOKUP($B4,Data!$A$2:$C$139,2,FALSE)*$C4,\"\")","v":""},{"$f":"IF($C4>0,VLOOKUP($B4,Data!$A$2:$C$139,3,FALSE)*$C4,\"\")","v":""},null,false,"A1",false,null,"Type","BPS-405 W/Battery",null,null,{"$f":"PowerCapacity(M4)","v":"      2A Each output, 3A total and 2A charging"},null,null,null,null,"Project",null,null,"Date   "]
[null,"BC-420",null,null,{"$f":"IF($C5>0,VLOOKUP($B5,Data!$A$2:$C$139,2,FALSE)*$C5,\"\")","v":""},{"$f":"IF($C5>0,VLOOKUP($B5,Data!$A$2:$C$139,3,FALSE)*$C5,\"\")","v":""},null,false,"A1",false,null,"Load","A1","A2","B1","B2","C1","C2","Totally"]
[null,"BC-440",null,null,{"$f":"IF($C6>0,VLOOKUP($B6,Data!$A$2:$C$139,2,FALSE)*$C6,\"\")","v":""},{"$f":"IF($C6>0,VLOOKUP($B6,Data!$A$2:$C$139,3,FALSE)*$C6,\"\")","v":""},null,false,"A1",false,null,"Load Quiescent",{"$f":"CalculatePower($M4,\"Quiescent\",$M2,M5)","v":0},{"$f":"CalculatePower($M4,\"Quiescent\",$M2,N5)","v":0},{"$f":"CalculatePower($M4,\"Quiescent\",$M2,O5)","v":0},{"$f":"CalculatePower($M4,\"Quiescent\",$M2,P5)","v":0},{"$f":"CalculatePower($M4,\"Quiescent\",$M2,Q5)","v":0},{"$f":"CalculatePower($M4,\"Quiescent\",$M2,R5)","v":0},{"$f":"SUM(M6:R6)","v":0}]
[null,"BS-430",null,null,{"$f":"IF($C7>0,VLOOKUP($B7,Data!$A$2:$C$139,2,FALSE)*$C7,\"\")","v":""},{"$f":"IF($C7>0,VLOOKUP($B7,Data!$A$2:$C$139,3,FALSE)*$C7,\"\")","v":""},null,false,"A1",false,null,"Load Alarm",{"$f":"CalculatePower($M4,\"Alarm\",$M2,M5)","v":0},{"$f":"CalculatePower($M4,\"Alarm\",$M2,N5)","v":0},{"$f":"CalculatePower($M4,\"Alarm\",$M2,O5)","v":0},{"$f":"CalculatePower($M4,\"Alarm\",$M2,P5)","v":0},{"$f":"CalculatePower($M4,\"Alarm\",$M2,Q5)","v":0},{"$f":"CalculatePower($M4,\"Alarm\",$M2,R5)","v":0},{"$f":"SUM(M7:R7)","v":0}]
[null,"BU-420/BV-420",null,null,{"$f":"IF($C8>0,VLOOKUP($B8,Data!$A$2:$C$139,2,FALSE)*$C8,\"\")","v":""},{"$f":"IF($C8>0,VLOOKUP($B8,Data!$A$2:$C$139,3,FALSE)*$C8,\"\")","v":""},null,false,"A1",false,null,"Within capacity",{"$f":"CalculateA1(M4,M7)","v":"Yes"},{"$f":"IF(N7>2000,\"No, Fix\",\"Yes\")","v":"Yes"},"Yes","Yes","Yes","Yes"]
["Modules","Module","Amount",null,"Load quiescent","Load alarm","Connect To Power",null,"Output",null,null,"Totally Alarm",{"$f":"S7","v":0}]
[null,"BSS-310A",null,null,{"$f":"IF($C10>0,VLOOKUP($B10,Data!$A$2:$C$139,2,FALSE)*$C10,\"\")","v":""},{"$f":"IF($C10>0,VLOOKUP($B10,Data!$A$2:$C$139,3,FALSE)*$C10,\"\")","v":""},null,false,"A1",false,null,"Within capacity",{"$f":"WithinCapacity(M4,M9)","v":"Yes"},null,null,null,null,null,null,null,"Report Template System"]
[null,"BSS-311",null,null,{"$f":"IF($C11>0,VLOOKUP($B11,Data!$A$2:$C$139,2,FALSE)*$C11,\"\")","v":""},{"$f":"IF($C11>0,VLOOKUP($B11,Data!$A$2:$C$139,3,FALSE)*$C11,\"\")","v":""},null,null,"A1",null,null,"Battery",null,null,null,null,null,null,null,null,"System"]
[null,"BSL-310",null,null,{"$f":"IF($C12>0,VLOOKUP($B12,Data!$A$2:$C$139,2,FALSE)*$C12,\"\")","v":""},{"$f":"IF($C12>0,VLOOKUP($B12,Data!$A$2:$C$139,3,FALSE)*$C12,\"\")","v":""},null,null,null,null,null,"Hour req. Std.by",24,null,"Min Battery Size (AH)",null,null,null,{"$f":"MinBatterySize(M4,M12,M13,S6,S7)","v":"3"},null,"Type","Number","Load quiescent","Load alarm"]
[null,"BSD-310",null,null,{"$f":"IF($C13>0,VLOOKUP($B13,Data!$A$2:$C$139,2,FALSE)*$C13,\"\")","v":""},{"$f":"IF($C13>0,VLOOKUP($B13,Data!$A$2:$C$139,3,FALSE)*$C13,\"\")","v":""},null,null,null,null,null,"Hour req. Alarm",0.5,null,"Availible For Charging",null,null,null,{"$f":"ChargingAvail(M4,S6)","v":"2000"},null,"Panels"]
[null,"BSD-310/N",null,null,{"$f":"IF($C14>0,VLOOKUP($B14,Data!$A$2:$C$139,2,FALSE)*$C14,\"\")","v":""},{"$f":"IF($C14>0,VLOOKUP($B14,Data!$A$2:$C$139,3,FALSE)*$C14,\"\")","v":""},null,null,null,null,null,null,null,null,"Max battery 24 hour charging (AH)",null,null,null,{"$f":"MaxBattery24HCharging(S13)","v":"38"},null,"Modules"]
[null,"BSD-311",null,null,{"$f":"IF($C15>0,VLOOKUP($B15,Data!$A$2:$C$139,2,FALSE)*$C15,\"\")","v":""},{"$f":"IF($C15>0,VLOOKUP($B15,Data!$A$2:$C$139,3,FALSE)*$C15,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Detectors"]
[null,"BSB-310A",null,null,{"$f":"IF($C16>0,VLOOKUP($B16,Data!$A$2:$C$139,2,FALSE)*$C16,\"\")","v":""},{"$f":"IF($C16>0,VLOOKUP($B16,Data!$A$2:$C$139,3,FALSE)*$C16,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AutroGuard®"]
[null,"BSB-310A Load",null,null,null,null,null,null,"A1",null,null,null,null,null,null,null,null,null,null,null,"I/O Units"]
[null,"BSJ-310",null,null,{"$f":"IF($C18>0,VLOOKUP($B18,Data!$A$2:$C$139,2,FALSE)*$C18,\"\")","v":""},{"$f":"IF($C18>0,VLOOKUP($B18,Data!$A$2:$C$139,3,FALSE)*$C18,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sounders/Strobes"]
[null,"BSE-310",null,null,{"$f":"IF($C19>0,VLOOKUP($B19,Data!$A$2:$C$139,2,FALSE)*$C19,\"\")","v":""},{"$f":"IF($C19>0,VLOOKUP($B19,Data!$A$2:$C$139,3,FALSE)*$C19,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Loop Units"]
[null,"BSE-320",null,null,{"$f":"IF($C20>0,VLOOKUP($B20,Data!$A$2:$C$139,2,FALSE)*$C20,\"\")","v":""},{"$f":"IF($C20>0,VLOOKUP($B20,Data!$A$2:$C$139,3,FALSE)*$C20,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special Detection"]
["Loop Units","Detectors","Amount","Total Activated simultanisly","Load quiescent","Load alarm","Connect To Power",null,"Output",null,null,null,null,null,null,null,null,null,null,null,"Ex Equipment"]
[null,"MultiSensors",null,null,{"$f":"IF($C22>0,VLOOKUP($B22,Data!$A$2:$C$139,2,FALSE)*$C22,\"\")","v":""},{"$f":"IF($C22>0,VLOOKUP($B22,Data!$A$2:$C$139,3,FALSE)*$C22,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Communication"]
[null,"Heat detectors",null,null,{"$f":"IF($C23>0,VLOOKUP($B23,Data!$A$2:$C$139,2,FALSE)*$C23,\"\")","v":""},{"$f":"IF($C23>0,VLOOKUP($B23,Data!$A$2:$C$139,3,FALSE)*$C23,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Miscellaneous"]
[null,"Optical detectors",null,null,{"$f":"IF($C24>0,VLOOKUP($B24,Data!$A$2:$C$139,2,FALSE)*$C24,\"\")","v":""},{"$f":"IF($C24>0,VLOOKUP($B24,Data!$A$2:$C$139,3,FALSE)*$C24,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Own Units"]
[null,"Manual callpoints",null,null,{"$f":"IF($C25>0,VLOOKUP($B25,Data!$A$2:$C$139,2,FALSE)*$C25,\"\")","v":""},{"$f":"IF($C25>0,VLOOKUP($B25,Data!$A$2:$C$139,3,FALSE)*$C25,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Flame (BG-201)",null,null,{"$f":"IF($C26>0,VLOOKUP($B26,Data!$A$2:$C$139,2,FALSE)*$C26,\"\")","v":""},{"$f":"IF($C26>0,VLOOKUP($B26,Data!$A$2:$C$139,3,FALSE)*$C26,\"\")","v":""}]
[null,"AutroSafe Total No Of LEDs per loop",null,null,{"$f":"IF($C27>0,VLOOKUP($B27,Data!$A$2:$C$139,2,FALSE)*$C27,0)","v":0},{"$f":"IF($D27>0,VLOOKUP($B27,Data!$A$2:$C$139,3,FALSE)*$D27*(C13+C14+C15),\"\")","v":""}]
[null,"Autroguard® Protectors","Amount","Total Activated simultanisly","Load quiescent","Load alarm","Connect To Power",null,"Output"]
["For AutroGuard®","Total no. of AutroGuard®",null,null,{"$f":"IF($C29>0,VLOOKUP($B29,Data!$A$2:$C$139,2,FALSE)*$C29,\"\")","v":""},{"$f":"IF($C29>0,VLOOKUP($B29,Data!$A$2:$C$139,3,FALSE)*$C29,\"\")","v":""}]
[" 1. Add total number of","Sounders Low Volume",null,null,{"$f":"IF($C30>0,VLOOKUP($B30,Data!$A$2:$C$139,2,FALSE)*$C30,\"\")","v":""},{"$f":"IF($D30>0,VLOOKUP($B30,Data!$A$2:$C$139,3,FALSE)*$D30+(($C30-$D30)*VLOOKUP($B30,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Report Template Power"]
["      detectors","Sounders High Volume",null,null,{"$f":"IF($C31>0,VLOOKUP($B31,Data!$A$2:$C$139,2,FALSE)*$C31,\"\")","v":""},{"$f":"IF($D31>0,VLOOKUP($B31,Data!$A$2:$C$139,3,FALSE)*$D31+(($C31-$D31)*VLOOKUP($B31,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Power",null,"Type   "]
[null,"VAD White High Int. (C-3-12) 0,5Hz",null,null,{"$f":"IF($C32>0,VLOOKUP($B32,Data!$A$2:$C$139,2,FALSE)*$C32,\"\")","v":""},{"$f":"IF($D32>0,VLOOKUP($B32,Data!$A$2:$C$139,3,FALSE)*$D32+(($C32-$D32)*VLOOKUP($B32,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output","Load quiescent","Load alarm","Within capacity"]
["2. Add total number of","VAD White Med. Int. (C-3-9) 0,5Hz",null,null,{"$f":"IF($C33>0,VLOOKUP($B33,Data!$A$2:$C$139,2,FALSE)*$C33,\"\")","v":""},{"$f":"IF($D33>0,VLOOKUP($B33,Data!$A$2:$C$139,3,FALSE)*$D33+(($C33-$D33)*VLOOKUP($B33,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A1"]
["     additional protectors","VAD White Low Int. (C-3-6) 0,5Hz",null,null,{"$f":"IF($C34>0,VLOOKUP($B34,Data!$A$2:$C$139,2,FALSE)*$C34,\"\")","v":""},{"$f":"IF($D34>0,VLOOKUP($B34,Data!$A$2:$C$139,3,FALSE)*$D34+(($C34-$D34)*VLOOKUP($B34,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A2"]
[null,"VAD White Open Int. (O-2,5-4) 0,5Hz",null,null,{"$f":"IF($C35>0,VLOOKUP($B35,Data!$A$2:$C$139,2,FALSE)*$C35,\"\")","v":""},{"$f":"IF($D35>0,VLOOKUP($B35,Data!$A$2:$C$139,3,FALSE)*$D35+(($C35-$D35)*VLOOKUP($B35,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B1"]
["3. Add total number of","VAD Red High Int. (C-3-8) 0,5Hz",null,null,{"$f":"IF($C36>0,VLOOKUP($B36,Data!$A$2:$C$139,2,FALSE)*$C36,\"\")","v":""},{"$f":"IF($D36>0,VLOOKUP($B36,Data!$A$2:$C$139,3,FALSE)*$D36+(($C36-$D36)*VLOOKUP($B36,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B2"]
["     additional protectors","VAD Red Low Int. (C-3-5) 0,5Hz",null,null,{"$f":"IF($C37>0,VLOOKUP($B37,Data!$A$2:$C$139,2,FALSE)*$C37,\"\")","v":""},{"$f":"IF($D37>0,VLOOKUP($B37,Data!$A$2:$C$139,3,FALSE)*$D37+(($C37-$D37)*VLOOKUP($B37,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C1"]
["     which shall be ","VAD Red Open Int. (O-2,5-4) 0,5Hz",null,null,{"$f":"IF($C38>0,VLOOKUP($B38,Data!$A$2:$C$139,2,FALSE)*$C38,\"\")","v":""},{"$f":"IF($D38>0,VLOOKUP($B38,Data!$A$2:$C$139,3,FALSE)*$D38+(($C38-$D38)*VLOOKUP($B38,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C2"]
["     activated simultanisly","AutroGuard® No Of LEDs per loop",null,null,{"$f":"IF($C39>0,VLOOKUP($B39,Data!$A$2:$C$139,2,FALSE)*$C39,0)","v":0},{"$f":"IF($D39>0,VLOOKUP($B39,Data!$A$2:$C$139,3,FALSE)*$D39*(C13+C14+C15)+$E39,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"I/O Units","Amount",null,"Load quiescent","Load alarm","Connect To Power",null,"Output"]
[null,"BN-303",null,null,{"$f":"IF($C41>0,VLOOKUP($B41,Data!$A$2:$C$139,2,FALSE)*$C41,\"\")","v":""},{"$f":"IF($C41>0,VLOOKUP($B41,Data!$A$2:$C$139,3,FALSE)*$C41,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hour req. Std.by","Hour req. Alarm","Min Battery Size (AH)","Available For Charging","Max. battery with 24 hour charging (AH)"]
[null,"BN-304",null,null,{"$f":"IF($C42>0,VLOOKUP($B42,Data!$A$2:$C$139,2,FALSE)*$C42,\"\")","v":""},{"$f":"IF($C42>0,VLOOKUP($B42,Data!$A$2:$C$139,3,FALSE)*$C42,\"\")","v":""}]
[null,"BN-305",null,null,{"$f":"IF($C43>0,VLOOKUP($B43,Data!$A$2:$C$139,2,FALSE)*$C43,\"\")","v":""},{"$f":"IF($C43>0,VLOOKUP($B43,Data!$A$2:$C$139,3,FALSE)*$C43,\"\")","v":""}]
[null,"BN-303/LS",null,null,{"$f":"IF($C44>0,VLOOKUP($B44,Data!$A$2:$C$139,2,FALSE)*$C44,\"\")","v":""},{"$f":"IF($C44>0,VLOOKUP($B44,Data!$A$2:$C$139,3,FALSE)*$C44,\"\")","v":""}]
[null,"BN-320/2",null,null,{"$f":"IF($C45>0,VLOOKUP($B45,Data!$A$2:$C$139,2,FALSE)*$C45,\"\")","v":""},{"$f":"IF($C45>0,VLOOKUP($B45,Data!$A$2:$C$139,3,FALSE)*$C45,\"\")","v":""}]
[null,"BN-320/3",null,null,{"$f":"IF($C46>0,VLOOKUP($B46,Data!$A$2:$C$139,2,FALSE)*$C46,\"\")","v":""},{"$f":"IF($C46>0,VLOOKUP($B46,Data!$A$2:$C$139,3,FALSE)*$C46,\"\")","v":""}]
[null,"BN-320/4",null,null,{"$f":"IF($C47>0,VLOOKUP($B47,Data!$A$2:$C$139,2,FALSE)*$C47,\"\")","v":""},{"$f":"IF($C47>0,VLOOKUP($B47,Data!$A$2:$C$139,3,FALSE)*$C47,\"\")","v":""}]
[null,"BN-320/5",null,null,{"$f":"IF($C48>0,VLOOKUP($B48,Data!$A$2:$C$139,2,FALSE)*$C48,\"\")","v":""},{"$f":"IF($C48>0,VLOOKUP($B48,Data!$A$2:$C$139,3,FALSE)*$C48,\"\")","v":""}]
[null,"BN-221/01",null,null,{"$f":"IF($C49>0,VLOOKUP($B49,Data!$A$2:$C$139,2,FALSE)*$C49,\"\")","v":""},{"$f":"IF($C49>0,VLOOKUP($B49,Data!$A$2:$C$139,3,FALSE)*$C49,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Report Template Heading"]
[null,"BN-300",null,null,{"$f":"IF($C50>0,VLOOKUP($B50,Data!$A$2:$C$139,2,FALSE)*$C50,\"\")","v":""},{"$f":"IF($C50>0,VLOOKUP($B50,Data!$A$2:$C$139,3,FALSE)*$C50,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loop Calculation Report"]
[null,"GAPB (BN-320/4)",null,null,{"$f":"IF($C51>0,VLOOKUP($B51,Data!$A$2:$C$139,2,FALSE)*$C51,\"\")","v":""},{"$f":"IF($C51>0,VLOOKUP($B51,Data!$A$2:$C$139,3,FALSE)*$C51,\"\")","v":""}]
[null,"BN-221/02",null,null,{"$f":"IF($C52>0,VLOOKUP($B52,Data!$A$2:$C$139,2,FALSE)*$C52,\"\")","v":""},{"$f":"IF($C52>0,VLOOKUP($B52,Data!$A$2:$C$139,3,FALSE)*$C52,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loop Driver   ",null,"Cable Cross Section  "]
[null,"BN-201",null,null,{"$f":"IF($C53>0,VLOOKUP($B53,Data!$A$2:$C$139,2,FALSE)*$C53,\"\")","v":""},{"$f":"IF($C53>0,VLOOKUP($B53,Data!$A$2:$C$139,3,FALSE)*$C53,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum Current   ",null,"Cable Length"]
[null,"BN-310",null,null,{"$f":"IF($C54>0,VLOOKUP($B54,Data!$A$2:$C$139,2,FALSE)*$C54,\"\")","v":""},{"$f":"IF($C54>0,VLOOKUP($B54,Data!$A$2:$C$139,3,FALSE)*$C54,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BSD-310","BSD-311"]
[null,"BN-221/02 (AlCom)",null,null,{"$f":"IF($C55>0,VLOOKUP($B55,Data!$A$2:$C$139,2,FALSE)*$C55,\"\")","v":""},{"$f":"IF($C55>0,VLOOKUP($B55,Data!$A$2:$C$139,3,FALSE)*$C55,\"\")","v":""}]
[null,"BN-221/02 Load",null,null,null,null,null,null,"A1"]
[null,"Sounders/Strobes","Amount","Total Activated simultanisly","Load quiescent","Load alarm","Connect To Power",null,"Output"]
[null,"BBL-100",null,null,{"$f":"IF($C58>0,VLOOKUP($B58,Data!$A$2:$C$139,2,FALSE)*$C58,\"\")","v":""},{"$f":"IF($D58>0,VLOOKUP($B58,Data!$A$2:$C$139,3,FALSE)*$D58+(($C58-$D58)*VLOOKUP($B58,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Report Template Loop"]
[null,"BBL-100",null,null,{"$f":"IF($C59>0,VLOOKUP($B59,Data!$A$2:$C$139,2,FALSE)*$C59,\"\")","v":""},{"$f":"IF($D59>0,VLOOKUP($B59,Data!$A$2:$C$139,3,FALSE)*$D59+(($C59-$D59)*VLOOKUP($B59,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loop"]
[null,"BBR-200",null,null,{"$f":"IF($C60>0,VLOOKUP($B60,Data!$A$2:$C$139,2,FALSE)*$C60,\"\")","v":""},{"$f":"IF($D60>0,VLOOKUP($B60,Data!$A$2:$C$139,3,FALSE)*$D60+(($C60-$D60)*VLOOKUP($B60,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type","Number","Load quiescent","Load alarm"]
[null,"BBQ-130 LP",null,null,{"$f":"IF($C61>0,VLOOKUP($B61,Data!$A$2:$C$139,2,FALSE)*$C61,\"\")","v":""},{"$f":"IF($D61>0,VLOOKUP($B61,Data!$A$2:$C$139,3,FALSE)*$D61+(($C61-$D61)*VLOOKUP($B61,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AutroGuard®"]
[null,"BBR-130 HP",null,null,{"$f":"IF($C62>0,VLOOKUP($B62,Data!$A$2:$C$139,2,FALSE)*$C62,\"\")","v":""},{"$f":"IF($D62>0,VLOOKUP($B62,Data!$A$2:$C$139,3,FALSE)*$D62+(($C62-$D62)*VLOOKUP($B62,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total no. of AutroGuard®"]
[null,"BBQ-130 HP",null,null,{"$f":"IF($C63>0,VLOOKUP($B63,Data!$A$2:$C$139,2,FALSE)*$C63,\"\")","v":""},{"$f":"IF($D63>0,VLOOKUP($B63,Data!$A$2:$C$139,3,FALSE)*$D63+(($C63-$D63)*VLOOKUP($B63,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sounders Low Volume"]
[null,"BBQ-230 Indicator+LP",null,null,{"$f":"IF($C64>0,VLOOKUP($B64,Data!$A$2:$C$139,2,FALSE)*$C64,\"\")","v":""},{"$f":"IF($D64>0,VLOOKUP($B64,Data!$A$2:$C$139,3,FALSE)*$D64+(($C64-$D64)*VLOOKUP($B64,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sounders High Volume"]
[null,"BBQ-230 Indicator+HP",null,null,{"$f":"IF($C65>0,VLOOKUP($B65,Data!$A$2:$C$139,2,FALSE)*$C65,\"\")","v":""},{"$f":"IF($D65>0,VLOOKUP($B65,Data!$A$2:$C$139,3,FALSE)*$D65+(($C65-$D65)*VLOOKUP($B65,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,false,null,null,null,null,null,null,null,null,null,null,null,null,"VAD White  (O-2,5-4)"]
[null,"BN-307 (AlCom)",null,null,{"$f":"IF($C66>0,VLOOKUP($B66,Data!$A$2:$C$139,2,FALSE)*$C66,\"\")","v":""},{"$f":"IF($D66>0,VLOOKUP($B66,Data!$A$2:$C$139,3,FALSE)*$D66+(($C66-$D66)*VLOOKUP($B66,Data!$A$2:$C$139,2,FALSE)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAD White  (C-3-6)"]
[null,"BN-307 Load",null,null,null,null,null,null,"A1",null,null,null,null,null,null,null,null,null,null,null,"VAD White  (C-3-9)"]
[null,"Other Loop Units","Amount",null,"Load quiescent","Load alarm","Connect To Power",null,"Output",null,null,null,null,null,null,null,null,null,null,null,"VAD White  (C-3-12)"]
[null,"BU-110/BV-110",null,null,{"$f":"IF($C69>0,VLOOKUP($B69,Data!$A$2:$C$139,2,FALSE)*$C69,\"\")","v":""},{"$f":"IF($C69>0,VLOOKUP($B69,Data!$A$2:$C$139,3,FALSE)*$C69,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAD Red (O-2,5-4)"]
[null,"BU-111",null,null,{"$f":"IF($C70>0,VLOOKUP($B70,Data!$A$2:$C$139,2,FALSE)*$C70,\"\")","v":""},{"$f":"IF($C70>0,VLOOKUP($B70,Data!$A$2:$C$139,3,FALSE)*$C70,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAD Red (C-3-5)"]
[null,"BU-200",null,null,{"$f":"IF($C71>0,VLOOKUP($B71,Data!$A$2:$C$139,2,FALSE)*$C71,\"\")","v":""},{"$f":"IF($C71>0,VLOOKUP($B71,Data!$A$2:$C$139,3,FALSE)*$C71,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAD Red (C-3-8)"]
[null,"BN-180 (Alcom)",null,null,{"$f":"IF($C72>0,VLOOKUP($B72,Data!$A$2:$C$139,2,FALSE)*$C72,\"\")","v":""},{"$f":"IF($C72>0,VLOOKUP($B72,Data!$A$2:$C$139,3,FALSE)*$C72,\"\")","v":""},null,null,null,false,null,null,null,null,null,null,null,null,null,null,"Total no. of LEDs"]
[null,"BN-180 (External)",null,null,{"$f":"IF($C73>0,VLOOKUP($B73,Data!$A$2:$C$139,2,FALSE)*$C73,\"\")","v":""},{"$f":"IF($C73>0,VLOOKUP($B73,Data!$A$2:$C$139,3,FALSE)*$C73,\"\")","v":""},null,false,"A1"]
[null,"BNB-330A (Alcom)",null,null,{"$f":"IF($C74>0,VLOOKUP($B74,Data!$A$2:$C$139,2,FALSE)*$C74,\"\")","v":""},{"$f":"IF($C74>0,VLOOKUP($B74,Data!$A$2:$C$139,3,FALSE)*$C74,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary Loop Units"]
[null,"BNB-330A (External)",null,null,{"$f":"IF($C75>0,VLOOKUP($B75,Data!$A$2:$C$139,2,FALSE)*$C75,\"\")","v":""},{"$f":"IF($C75>0,VLOOKUP($B75,Data!$A$2:$C$139,3,FALSE)*$C75,\"\")","v":""},null,false,"A1",false,null,null,null,null,null,null,null,null,null,null,"AutroSafe Detectors"]
[null,"BNB-330/BNB-331 (AlCom)",null,null,{"$f":"IF($C76>0,VLOOKUP($B76,Data!$A$2:$C$139,2,FALSE)*$C76,\"\")","v":""},{"$f":"IF($C76>0,VLOOKUP($B76,Data!$A$2:$C$139,3,FALSE)*$C76,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Autroguard®"]
[null,"BNB-330/BNB-331 (External)",null,null,{"$f":"IF($C77>0,VLOOKUP($B77,Data!$A$2:$C$139,2,FALSE)*$C77,\"\")","v":""},{"$f":"IF($C77>0,VLOOKUP($B77,Data!$A$2:$C$139,3,FALSE)*$C77,\"\")","v":""},null,false,"A1",false,null,null,null,null,null,null,null,null,null,null,"I/O Units"]
[null,"BW-200/BW-201",null,null,{"$f":"IF($C78>0,VLOOKUP($B78,Data!$A$2:$C$139,2,FALSE)*$C78,\"\")","v":""},{"$f":"IF($C78>0,VLOOKUP($B78,Data!$A$2:$C$139,3,FALSE)*$C78,\"\")","v":""},null,false,null,false,null,null,null,null,null,null,null,null,null,null,"Sounders/Strobes"]
[null,"BW-202/BW-203",null,null,{"$f":"IF($C79>0,VLOOKUP($B79,Data!$A$2:$C$139,2,FALSE)*$C79,\"\")","v":""},{"$f":"IF($C79>0,VLOOKUP($B79,Data!$A$2:$C$139,3,FALSE)*$C79,\"\")","v":""},null,false,null,false,null,null,null,null,null,null,null,null,null,null,"Other Loop Units"]
["Special Detection",null,"Amount",null,"Load quiescent","Load alarm","Connect To Power",null,"Output",null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"AutroSense 200 Stl. Cmd.Mod.",null,null,{"$f":"IF($C81>0,VLOOKUP($B81,Data!$A$2:$C$139,2,FALSE)*$C81,\"\")","v":""},{"$f":"IF($C81>0,VLOOKUP($B81,Data!$A$2:$C$139,3,FALSE)*$C81,\"\")","v":""},null,false,"A1"]
[null,"AutroSense Micra 25",null,null,{"$f":"IF($C82>0,VLOOKUP($B82,Data!$A$2:$C$139,2,FALSE)*$C82,\"\")","v":""},{"$f":"IF($C82>0,VLOOKUP($B82,Data!$A$2:$C$139,3,FALSE)*$C82,\"\")","v":""},null,false,"A1"]
[null,"AutroSense Micra 10",null,null,{"$f":"IF($C83>0,VLOOKUP($B83,Data!$A$2:$C$139,2,FALSE)*$C83,\"\")","v":""},{"$f":"IF($C83>0,VLOOKUP($B83,Data!$A$2:$C$139,3,FALSE)*$C83,\"\")","v":""},null,false,"A1"]
[null,"AutroSense Micra 10",null,null,{"$f":"IF($C84>0,VLOOKUP($B84,Data!$A$2:$C$139,2,FALSE)*$C84,\"\")","v":""},{"$f":"IF($C84>0,VLOOKUP($B84,Data!$A$2:$C$139,3,FALSE)*$C84,\"\")","v":""},null,false,"A1"]
[null,"AutroSense Micra 10",null,null,{"$f":"IF($C85>0,VLOOKUP($B85,Data!$A$2:$C$139,2,FALSE)*$C85,\"\")","v":""},{"$f":"IF($C85>0,VLOOKUP($B85,Data!$A$2:$C$139,3,FALSE)*$C85,\"\")","v":""},null,false,"A1"]
[null,"AutroSense Micra 10",null,null,{"$f":"IF($C86>0,VLOOKUP($B86,Data!$A$2:$C$139,2,FALSE)*$C86,\"\")","v":""},{"$f":"IF($C86>0,VLOOKUP($B86,Data!$A$2:$C$139,3,FALSE)*$C86,\"\")","v":""},null,false,"A1"]
[null,"AutroSense Micra 10",null,null,{"$f":"IF($C87>0,VLOOKUP($B87,Data!$A$2:$C$139,2,FALSE)*$C87,\"\")","v":""},{"$f":"IF($C87>0,VLOOKUP($B87,Data!$A$2:$C$139,3,FALSE)*$C87,\"\")","v":""},null,false,"A1"]
[null,"AutroSense Micra 10",null,null,{"$f":"IF($C88>0,VLOOKUP($B88,Data!$A$2:$C$139,2,FALSE)*$C88,\"\")","v":""},{"$f":"IF($C88>0,VLOOKUP($B88,Data!$A$2:$C$139,3,FALSE)*$C88,\"\")","v":""},null,false,"A1"]
["Ex Equipment",null,"Amount",null,"Load quiescent","Load alarm","Connect To Power",null,"Output"]
[null,"BZ-500",null,null,{"$f":"IF($C90>0,VLOOKUP($B90,Data!$A$2:$C$139,2,FALSE)*$C90,\"\")","v":""},{"$f":"IF($C90>0,VLOOKUP($B90,Data!$A$2:$C$139,3,FALSE)*$C90,\"\")","v":""},null,false,"A1",false]
["Communication","Switches","Amount",null,"Load quiescent","Load alarm","Connect To Power",null,"Output"]
[null,"FL SWITCH LM 4TX/2FX",null,null,{"$f":"IF($C92>0,VLOOKUP($B92,Data!$A$2:$C$139,2,FALSE)*$C92,\"\")","v":""},{"$f":"IF($C92>0,VLOOKUP($B92,Data!$A$2:$C$139,3,FALSE)*$C92,\"\")","v":""},null,false,"A1",false]
[null,"FL SWITCH LM 4TX/2FX SM",null,null,{"$f":"IF($C93>0,VLOOKUP($B93,Data!$A$2:$C$139,2,FALSE)*$C93,\"\")","v":""},{"$f":"IF($C93>0,VLOOKUP($B93,Data!$A$2:$C$139,3,FALSE)*$C93,\"\")","v":""},null,false,"A1",false]
[null,"FL SWITCH LM 4TX/2FX SM",null,null,{"$f":"IF($C94>0,VLOOKUP($B94,Data!$A$2:$C$139,2,FALSE)*$C94,\"\")","v":""},{"$f":"IF($C94>0,VLOOKUP($B94,Data!$A$2:$C$139,3,FALSE)*$C94,\"\")","v":""},null,false,"A1",false]
[null,"FL SWITCH LM 4TX/2FX SM",null,null,{"$f":"IF($C95>0,VLOOKUP($B95,Data!$A$2:$C$139,2,FALSE)*$C95,\"\")","v":""},{"$f":"IF($C95>0,VLOOKUP($B95,Data!$A$2:$C$139,3,FALSE)*$C95,\"\")","v":""},null,false,"A1",false]
["Miscellaneous"]
[null,"BSL-321",null,null,{"$f":"IF($C97>0,VLOOKUP($B97,Data!$A$2:$C$139,2,FALSE)*$C97,\"\")","v":""},{"$f":"IF($C97>0,VLOOKUP($B97,Data!$A$2:$C$139,3,FALSE)*$C97,\"\")","v":""},null,false,"A1"]
[null,"BSL-322",null,null,{"$f":"IF($C98>0,VLOOKUP($B98,Data!$A$2:$C$139,2,FALSE)*$C98,\"\")","v":""},{"$f":"IF($C98>0,VLOOKUP($B98,Data!$A$2:$C$139,3,FALSE)*$C98,\"\")","v":""},null,null,"A1"]
[null,"BSL-337",null,null,{"$f":"IF($C99>0,VLOOKUP($B99,Data!$A$2:$C$139,2,FALSE)*$C99,\"\")","v":""},{"$f":"IF($C99>0,VLOOKUP($B99,Data!$A$2:$C$139,3,FALSE)*$C99,\"\")","v":""},null,null,"A1"]
[null,"BSD-321/1",null,null,{"$f":"IF($C100>0,VLOOKUP($B100,Data!$A$2:$C$139,2,FALSE)*$C100,\"\")","v":""},{"$f":"IF($C100>0,VLOOKUP($B100,Data!$A$2:$C$139,3,FALSE)*$C100,\"\")","v":""},null,null,"A1"]
["Own Units",null,"Amount",null,"Load quiescent","Load alarm","Connect To Power",null,"Output"]
[null,"Example",null,null,{"$f":"IF($C102>0,VLOOKUP($B102,'Data Own Units'!$A$2:$C$103,2,FALSE)*$C102,\"\")","v":""},{"$f":"IF($C102>0,VLOOKUP($B102,'Data Own Units'!$A$2:$C$103,3,FALSE)*$C102,\"\")","v":""},null,false,"A1"]
[null,"Example",null,null,{"$f":"IF($C103>0,VLOOKUP($B103,'Data Own Units'!$A$2:$C$103,2,FALSE)*$C103,\"\")","v":""},{"$f":"IF($C103>0,VLOOKUP($B103,'Data Own Units'!$A$2:$C$103,3,FALSE)*$C103,\"\")","v":""},null,null,"A1"]
[null,"Example",null,null,{"$f":"IF($C104>0,VLOOKUP($B104,'Data Own Units'!$A$2:$C$103,2,FALSE)*$C104,\"\")","v":""},{"$f":"IF($C104>0,VLOOKUP($B104,'Data Own Units'!$A$2:$C$103,3,FALSE)*$C104,\"\")","v":""},null,null,"A1"]
[null,"Example",null,null,{"$f":"IF($C105>0,VLOOKUP($B105,'Data Own Units'!$A$2:$C$103,2,FALSE)*$C105,\"\")","v":""},{"$f":"IF($C105>0,VLOOKUP($B105,'Data Own Units'!$A$2:$C$103,3,FALSE)*$C105,\"\")","v":""},null,null,"A1"]

{"sheet":"Data","index":4,"n_rows":133,"n_cols":14,"rows_kept":133,"cut":false,"hidden":true,"merged":[]}
["Item","Data quiescent","Data quiescent",null,null,"Power supply","Power Outputs","Power Names","Loop Driver","Cable  Cross Section","Length 310 BSD-310","Length BSD-311","VAD Variants","Sounders"]
["BC-420",156,340,null,null,"BPS-405 W/Battery","A1",null,"BSD-310","0,75 mm2","1100 m","430 m","VAD White High Int. (C-3-12) 0,5Hz","BBL-100"]
["BC-440",125,125,null,null,"BPS-410 W/Battery","A2",null,"BSD-311","1 mm2","1470 m","580 m","VAD White High Int. (C-3-12) 1Hz","BBR-110"]
["BS-420",156,340,null,null,"BPS-405 WO/Battery","B1",null,null,"1,5 mm2","2200 m","870 m","VAD White Med. Int. (C-3-9) 0,5Hz","BBR-130 LP"]
["BS-430",156,340,null,null,"BPS-410 WO/Battery","B2",null,null,"2 mm2","2940 m","1160 m","VAD White Med. Int. (C-3-9) 1Hz","BBR-130 HP"]
["BU-420/BV-420",156,220,null,null,"Power Cabinet STX 24V/2A","C1",null,null,"2,5 mm2","3670 m","1450 m","VAD White Low Int. (C-3-6) 0,5Hz","BBR-200"]
[null,null,null,null,null,"Power Cabinet STX 24V/5A","C2",null,null,null,null,null,"VAD White Low Int. (C-3-6) 1Hz","BBR-230 LP"]
["BSE-310",15,15,null,null,"Power Cabinet STX 24V/10A",null,null,null,null,null,null,"VAD White Open Int. (O-2,5-4) 0,5Hz","BBR-230 HP"]
["BSE-320",7,7,null,null,null,null,null,null,null,null,null,"VAD White Open Int. (O-2,5-4) 1Hz","BBQ-130 LP"]
["BSJ-310",10,20,null,null,null,null,null,null,null,null,null,"VAD Red High Int. (C-3-8) 0,5Hz","BBQ-130 HP"]
["BSB-310A",37,80,null,null,null,null,null,null,null,null,null,"VAD Red High Int. (C-3-8) 1Hz","BBQ-130 Indicator"]
["BSS-311",14,14,null,null,null,null,null,null,null,null,null,"VAD Red Low Int. (C-3-5) 0,5Hz","BBQ-130 Indicator+LP"]
["BSS-310A",40,40,null,null,null,null,null,null,null,null,null,"VAD Red Low Int. (C-3-5) 1Hz","BBQ-130 Indicator+HP"]
["BSL-310",15,15,null,null,null,null,null,null,null,null,null,"VAD Red Open Int. (O-2,5-4) 0,5Hz","BBQ-230 LP"]
["BSD-330",12,12,null,null,null,null,null,null,null,null,null,"VAD Red Open Int. (O-2,5-4) 1Hz","BBQ-230 HP"]
["BSD-310",10,10,null,null,null,null,null,null,null,null,null,null,"BBQ-230 Indicator"]
["BSD-310/N",10,10,null,null,null,null,null,null,null,null,null,null,"BBQ-230 Indicator+LP"]
["BSD-311",10,10,null,null,null,null,null,null,null,null,null,null,"BBQ-230 Indicator+HP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"BN-307 (AlCom)"]
["Multisensors",0.3,0.3]
["Heat detectors",0.3,0.3]
["Optical detectors",0.3,0.3]
["Manual callpoints",0.3,0.3]
["Flame (BG-201)",0.1,0.1]
["No Of Led Pr Loop",0,6]
["AutroSafe Total No Of LEDs per loop",0,6]
[]
["Total no. of AutroGuard®",0.12,0.12]
["No. of LEDs per loop",0,2.1]
["AutroGuard® No Of LEDs per loop",0,2.1]
["Sounders Low Volume",0,2.2000000000000002]
["Sounders High Volume",0,5.8]
["VAD White High Int. (C-3-12) 0,5Hz",0,20]
["VAD White High Int. (C-3-12) 1Hz",0,40]
["VAD White Med. Int. (C-3-9) 0,5Hz",0,12.7]
["VAD White Med. Int. (C-3-9) 1Hz",0,25.4]
["VAD White Low Int. (C-3-6) 0,5Hz",0,9.5]
["VAD White Low Int. (C-3-6) 1Hz",0,19]
["VAD White Open Int. (O-2,5-4) 0,5Hz",0,4.8]
["VAD White Open Int. (O-2,5-4) 1Hz",0,7.6]
["VAD Red High Int. (C-3-8) 0,5Hz",0,18.7]
["VAD Red High Int. (C-3-8) 1Hz",0,37.4]
["VAD Red Low Int. (C-3-5) 0,5Hz",0,11.8]
["VAD Red Low Int. (C-3-5) 1Hz",0,23.6]
["VAD Red Open Int. (O-2,5-4) 0,5Hz",0,7.5]
["VAD Red Open Int. (O-2,5-4) 1Hz",0,15]
[]
["BN-303",0.1,0.1]
["BN-304",0.1,0.1]
["BN-305",0.1,0.1]
["BN-303/LS",0.9,0.9]
["BN-320/2",0.3,0.3]
["BN-320/3",0.3,0.3]
["BN-320/4",0.3,0.3]
["BN-320/5",0.3,0.3]
["BN-221/01",0.3,0.3]
["BN-300",0.3,0.3]
["GAPB (BN-320/4)",0.3,0.3]
["BN-221/02 (AlCom)",0.3,0.3]
["BN-201",0.3,0.3]
["BN-310",0.3,0.3]
[]
["BU-110/BV-110",1,6]
["BU-111",1,6]
["BU-200",0.3,0.3]
["BN-180 (Alcom)",5,5]
["BN-180 (External)",40,40]
["BN-330 (Alcom)",0.3,0.3]
["BN-330 (External)",20,80]
["BNB-330A (Alcom)",0.3,0.3]
["BNB-330A (External)",10,20]
["BNB-331 (Alcom)",0.3,0.3]
["BNB-331 (External)",10,20]
["BW-200/BW-201",0.3,0.3]
["BW-202/BW-203",0.3,0.3]
[]
["BBL-100",0.3,5.35]
["BBR-110",0,0.3]
["BBR-130 LP",0.3,2.15]
["BBR-130 HP",0.3,4.3]
["BBR-200",0.3,5]
["BBR-230 LP",0.3,2.1800000000000002]
["BBR-230 HP",0.3,4.4400000000000004]
["BBQ-130 LP",0.3,2.15]
["BBQ-130 HP",0.3,4.3]
["BBQ-130 Indicator",0.3,4.5599999999999996]
["BBQ-130 Indicator+LP",0.3,6.71]
["BBQ-130 Indicator+HP",0.3,8.56]
["BBQ-230 LP",0.3,2.1800000000000002]
["BBQ-230 HP",0.3,4.4400000000000004]
["BBQ-230 Indicator",0.3,4.68]
["BBQ-230 Indicator+LP",0.3,6.86]
["BBQ-230 Indicator+HP",0.3,8.6]
["BN-307 (AlCom)",0.3,0.3]
[]
["BZ-500",50,50]
["BZ-600",50,50]
[]
["FL SWITCH LM 4TX/2FX",400,400]
["FL SWITCH LM 4TX/2FX SM",400,400]
["FL SWITCH LM 4TX/FX",380,380]
["FL SWITCH LM 4TX/FX SM",380,380]
["FL SWITCH LM 5TX",150,150]
["FL SWITCH SFN 4TX/FX",140,140]
["FL SWITCH SFN 6TX/2FX",230,230]
["FL SWITCH SFN 7TX/FX",190,190]
["FL SWITCH SFNB 4TX/FX SM 20",185,185]
["FL SWITCH SFNB 5TX",180,180]
["FL SWITCH SFNB 8TX",138,138]
["FL SWITCH SFNT 4TX/FX",160,160]
["FL SWITCH SFNT 5TX",120,120]
["FL SWITCH SFNT 7TX/FX",175,175]
["FL SWITCH SFNT 8TX",153,153]
[]
["BSL-321",100,100]
["BSL-322",135,135]
["BSL-337",200,200]
["BSD-321/1",200,200]
[]
["AutroSense Micra 10",250,250]
["AutroSense Micra 25",250,250]
["AutroSense Micra 100",400,400]
["AutroSense 200 Detector",400,400]
["AutroSense 200 Stl. Cmd.Mod.",450,450]
["AutroSense 200 Cmd. Mod. Det.",850,850]
["Fireray 3000",30,30]
["Fireray 5000",52,52]
["Alarmline (LHD)",70,100]
[]
["BN-221/02",0.3,0.3]
[]
["BNB-330/BNB-331 (AlCom)",0.4,0.4]
["BNB-330/BNB-331 (External)",10,60]

{"sheet":"Loop Calculation AutroSafe","index":5,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Loop Calculator AutroSafe"]
["Loop Unit Type","No Of Units","Current Consumption/unit (mA)","Current Consumption (mA)"]
["AutroGuard"]
["V-430",null,0.12,{"$f":"IF(B4<>\"\",B4*C4,\"\")","v":""}]
["V-430-CO",null,0.3,{"$f":"IF(B5<>\"\",B5*C5,\"\")","v":""}]
["AutroGuard AddOn *"]
[" -S              Sounder Low Volume",null,2.5099999999999998,{"$f":"IF(B7<>\"\",B7*C7,\"\")","v":""}]
[" -S              Sounder High Volume",null,6.13,""]
[" -VADW      VAD White  Open Class (O-2,5-4)  ",null,4.8,""]
[" -VADW      VAD White  Low intensity  (C-3-6)",null,10.6,""]
[" -VADW      VAD White  Normal intensity  (C-3-9)",null,13.8,""]
[" -VADW      VAD White  high intensity  (C-3-12)",null,21,""]
[" -VADR       VAD Red  Open Class  (O-2,5-4)",null,8.5,""]
[" -VADR       VAD Red Low intensity  (C-3-5)",null,12.8,""]
[" -VADR       VAD Red High intensity  (C-3-8)",null,19.7,""]
["Other Units"]
[" BN-303, BN-303/LS",null,0.06,{"$f":"IF(B17<>\"\",B17*C17,\"\")","v":""}]
[" BN-304",null,0.06,""]
[" BN-305",null,0.1,""]
[" BN-307",null,0.06,""]
[" Other I/O-units, Manual Callpoints, BG-201",null,0.3,""]
[" BHH/BDH series detectors incl. BD-200PT",null,0.3,""]
[" BU-110/BV-110 Loop Panels ",null,6,""]
[" BBR-130/BBR-230 Sounder    (Sounder high Volume)",null,5,""]
[" BBQ-130 Sounder/VAD        (Sounder High Volume)",null,8.56,""]
[" BBQ-230 Sounder/VAD Red   (Sounder High Volume)",null,8.6,""]
[" BBL-100 VAD",null,5.35,""]
["Led Indication On detectors"]
["Alarm indication on detectors **",3,3,{"$f":"IF(B29<>\"\",B29*C29,\"\")","v":9}]
["Totally",{"$f":"SUM(B18:B27)+B4+B5","v":0},null,{"$f":"SUM(D4:D29)","v":9}]
[]
["* Current Consuption VAD is for 0.5 HZ"]
["** 3 LEDs are standard"]
[]
["AutroSafe recommended cable length"]
["Cable Cross Section","Current Consumption 0-100 mA","Current Consumption 101-200 mA"]
["0,75 mm²","1100 m","430 m"]
["1 mm²","1470 m","580 m"]
["1,5 mm²","2200 m","870 m"]
["2 mm²","2940 m","1160 m"]
["2,5 mm²","3670 m","1450 m"]
[]
["Result Loop Calculation:"]
["Loop driver to use:",{"$f":"IF(D30>200,\"NOT POSSIBLE\",IF(D30>100,\"BSD-311\",IF(D30>=0,\"BSD-310\")))","v":"BSD-310"}]
["No Of Units",{"$f":"IF(B30>127,\"TOO MANY\",IF(B30<128,\"OK\"))","v":"OK"}]
["Current Consumption",{"$f":"IF(D30>200,\"TOO HIGH\",IF(D30<=200,\"OK\"))","v":"OK"}]

{"sheet":"Loop Calculation Autroprime","index":6,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Loop Calculator Autroprime"]
["Loop Unit Type","No Of Units","Addresses/Unit","Total No. Of Addresses","Current Consumption/unit (mA)","Current Consumption (mA)"]
["AutroGuard"]
[" V-430 - detector",null,1,{"$f":"IF(B4<>\"\",B4*C4,\"\")","v":""},0.12,{"$f":"IF(B4<>\"\",B4*E4,\"\")","v":""}]
[" V-430-CO - detector",null,1,{"$f":"IF(B5<>\"\",B5*C5,\"\")","v":""},0.3,{"$f":"IF(B5<>\"\",B5*E5,\"\")","v":""}]
[" V-430-S - detector with/sounder",null,3,{"$f":"IF(B6<>\"\",B6*C6,\"\")","v":""},6.25,{"$f":"IF(B6<>\"\",B6*E6,\"\")","v":""}]
[" V-430-VADW - detector with/VAD white",null,3,"",4.9800000000000004,{"$f":"IF(B7<>\"\",B7*E7,\"\")","v":""}]
[" V-430-VADR - detector with/VAD red",null,3,"",8.68,""]
[" V-430-S-VADW - detector with/sounder and VAD white",null,3,"",10.95,""]
[" V-430-S-VADR - detector with/sounder and  VAD red",null,3,"",14.65,""]
["Other Units"]
[" BN-303, BN-303/LS",null,2,{"$f":"IF(B12<>\"\",B12*C12,\"\")","v":""},0.06,{"$f":"IF(B12<>\"\",B12*E12,\"\")","v":""}]
[" BN-304",null,3,"",0.06,""]
[" BN-305",null,5,"",0.1,""]
[" BN-307",null,1,"",0.06,""]
[" Other I/O-units, Manual Callpoints, BG-201",null,1,"",0.3,""]
[" BHH/BDH series detectors incl. BD-200PT",null,1,"",0.3,""]
[" BBR-130/BBR-230 Sounder ",null,1,"",5,""]
[" BBQ-130 Sounder/VAD ",null,1,"",8.56,""]
[" BBQ-230 Sounder/VAD Red ",null,1,"",8.6,""]
[" BBL-100 VAD",null,1,"",5.35,""]
["Led Indication On detectors"]
["Alarm indication on detectors *",3,null,null,3,{"$f":"IF(B23<>\"\",B23*E23,\"\")","v":9}]
["Totally",{"$f":"SUM(B4:B21)","v":0},null,{"$f":"SUM(D4:D21)","v":0},null,{"$f":"SUM(F4:F23)","v":9}]
[]
["Limits",{"$f":"IF(B24<=127,\"OK\",\"To Many Loop Units\")","v":"OK"},null,{"$f":"IF(D24<120,\"OK\",IF(D24>135,\"To Many Addresses\",\"Not Recommended\"))","v":"OK"},null,{"$f":"IF(F24<=250,\"OK\",\"High Current Consumption\")","v":"OK"}]
[]
["* 3 LEDs are standard"]
[]
["Autroprime recommended cable length"]
["Cable Cross Section","Current Consumption 0-100 mA","Current Consumption 101-150 mA","Current Consumption 151-200 mA","Current Consumption 201-250 mA"]
["0,75 mm²","1100 m","660 m","430 m","215 m"]
["1 mm²","1470 m","880 m","580 m","290 m"]
["1,5 mm²","2200 m","1320 m","870 m","430 m"]
["2 mm²","2940 m","1760 m","1160 m","580 m"]
["2,5 mm²","3670 m","2200 m","1450 m","725 m"]

{"sheet":"Data Own Units","index":7,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[null,"Load quiecent","Load Alarm"]
["Example",10,20]

{"sheet":"Report","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Temp","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}