{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Macro","Site Details","Loop1","Loop2","Loop3","Loop4","Device QTY","Help","Parameters"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":9,"comments":5,"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":"Macro","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Site Details","index":1,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[[6,2,6,6],[1,1,1,6],[2,2,2,6],[3,2,3,6],[4,2,4,6],[5,2,5,6]]}
[]
[null,"Details"]
[null,"CONTACT NAME:-",""]
[null,"CONTACT NUMBER:-",""]
[null,"COMPANY NAME:-                                        ",""]
[null,"SITE NAME:-",""]
[null,"SITE ADDRESS:-",""]

{"sheet":"Loop1","index":2,"n_rows":144,"n_cols":14,"rows_kept":144,"cut":false,"hidden":true,"merged":[[2,1,2,6],[7,2,7,6],[3,2,3,6],[4,2,4,6],[5,2,5,6],[6,2,6,6]]}
[null,{"$f":"\"Build Version: \" & Parameters!$D$2","v":"Build Version: 5"},null,null,"LOOP 1"]
[]
[null,"Details"]
[null,"CONTACT NAME:-",{"$f":"IF(LEN('Site Details'!$C$3:$G$3)>0,'Site Details'!$C$3:$G$3,\"\")","v":""}]
[null,"CONTACT NUMBER:-",{"$f":"IF(LEN('Site Details'!$C$4:$G$4)>0,'Site Details'!$C$4:$G$4,\"\")","v":""}]
[null,"COMPANY NAME:-                                        ",{"$f":"IF(LEN('Site Details'!$C$5:$G$5)>0,'Site Details'!$C$5:$G$5,\"\")","v":""}]
[null,"SITE NAME:-",{"$f":"IF(LEN('Site Details'!$C$6:$G$6)>0,'Site Details'!$C$6:$G$6,\"\")","v":""}]
[null,"SITE ADDRESS:-",{"$f":"IF(LEN('Site Details'!$C$7:$G$7)>0,'Site Details'!$C$7:$G$7,\"\")","v":""}]
[]
[null,"Example"]
["Device\nAddress\nNumber","Device Type","Associated\nRCC\nNumber\n1-31",null,"Loop Number","Zone Number","LOCATION TEXT                                                                                                 MAX 40 CHARACTERS "]
[1,"Wireless Call Point",1,null,1,1,"GROUND FLOOR RECEPTION AREA"]
[2,"Wireless Radio Sounder",1,null,1,1,"GROUND FLOOR RECEPTION AREA"]
[3,"Wireless Optical Detector",1,null,1,1,"MAIN ENTRANCE LOBBY"]
[4,"Wireless Combined Detector Sounder",1,null,1,2,"FIRST FLOOR LANDING"]
[5,"Wireless Combined Optical Detector",null,null,1,2,"FIRST FLOOR LANDING"]
[]
["Device Address Number","Device Type","Associated\nRCC\nNumber\n1-31",null,"Loop Number","Zone Number","LOCATION TEXT                                                                                                 MAX 40 CHARACTERS ","Additional Comments",null,null,null,null,"Type","Qty"]
[1,null,null,null,1,null,null,null,null,null,null,null,"Wireless Call Point",{"$f":"COUNTIF($B$19:$B$144,M19)","v":0}]
[2,null,null,null,1,null,null,null,null,null,null,null,"Wireless Optical Detector",{"$f":"COUNTIF($B$19:$B$144,M20)","v":0}]
[3,null,null,null,1,null,null,null,null,null,null,null,"Wireless Heat Detector CS",0]
[4,null,null,null,1,null,null,null,null,null,null,null,"Wireless Heat Detector A1R",{"$f":"COUNTIF($B$19:$B$144,M22)","v":0}]
[5,null,null,null,1,null,null,null,null,null,null,null,"Wireless Multisensor",{"$f":"COUNTIF($B$19:$B$144,M23)","v":0}]
[6,null,null,null,1,null,null,null,null,null,null,null,"Wireless Input Output Unit",{"$f":"COUNTIF($B$19:$B$144,M24)","v":0}]
[7,null,null,null,1,null,null,null,null,null,null,null,"Wireless Combined Detector Sounder",0]
[8,null,null,null,1,null,null,null,null,null,null,null,"Wireless Combined Optical Detector",0]
[9,null,null,null,1,null,null,null,null,null,null,null,"Wireless Combined Heat Detector CS",0]
[10,null,null,null,1,null,null,null,null,null,null,null,"Wireless Combined Heat Detector A1R",0]
[11,null,null,null,1,null,null,null,null,null,null,null,"Wireless Combined Multisensor",0]
[12,null,null,null,1,null,null,null,null,null,null,null,"Wireless Combined Detector Sounder - Visual Indicator",0]
[13,null,null,null,1,null,null,null,null,null,null,null,"Wireless Combined Visual Indicator - Optical Detector",0]
[14,null,null,null,1,null,null,null,null,null,null,null,"Wireless Combined Visual Indicator - Heat Detector CS",0]
[15,null,null,null,1,null,null,null,null,null,null,null,"Wireless Combined Visual Indicator - Heat Detector A1R",0]
[16,null,null,null,1,null,null,null,null,null,null,null,"Wireless Combined Visual Indicator - Multisensor",0]
[17,null,null,null,1,null,null,null,null,null,null,null,"Wireless Sounder",0]
[18,null,null,null,1,null,null,null,null,null,null,null,"Wireless Sounder Beacon",0]
[19,null,null,null,1,null,null,null,null,null,null,null,"Wireless Beacon",0]
[20,null,null,null,1,null,null,null,null,null,null,null,"Wireless Weather Resistant Sounder",0]
[21,null,null,null,1,null,null,null,null,null,null,null,"Wireless Weather Resistant Sounder Beacon",0]
[22,null,null,null,1,null,null,null,null,null,null,null,"Wireless Weather Resistant Beacon",0]
[23,null,null,null,1,null,null,null,null,null,null,null,"Wireless Remote Indicator",0]
[24,null,null,null,1,null,null,null,null,null,null,null,"Wireless Radio Cluster Communicator",0]
[25,null,null,null,1,null,null,null,null,null,null,null,"Wireless Radio HUB",0]
[26,null,null,null,1,null,null,null,null,null,null,null,null,0]
[27,null,null,null,1,null,null,null,null,null,null,null,"Total",{"$f":"SUM(N19:N44)","v":0}]
[28,null,null,null,1]
[29,null,null,null,1]
[30,null,null,null,1]
[31,null,null,null,1]
[32,null,null,null,1]
[33,null,null,null,1]
[34,null,null,null,1]
[35,null,null,null,1]
[36,null,null,null,1]
[37,null,null,null,1]
[38,null,null,null,1]
[39,null,null,null,1]
[40,null,null,null,1]
[41,null,null,null,1]
[42,null,null,null,1]
[43,null,null,null,1]
[44,null,null,null,1]
[45,null,null,null,1]
[46,null,null,null,1]
[47,null,null,null,1]
[48,null,null,null,1]
[49,null,null,null,1]
[50,null,null,null,1]
[51,null,null,null,1]
[52,null,null,null,1]
[53,null,null,null,1]
[54,null,null,null,1]
[55,null,null,null,1]
[56,null,null,null,1]
[57,null,null,null,1]
[58,null,null,null,1]
[59,null,null,null,1]
[60,null,null,null,1]
[61,null,null,null,1]
[62,null,null,null,1]
[63,null,null,null,1]
[64,null,null,null,1]
[65,null,null,null,1]
[66,null,null,null,1]
[67,null,null,null,1]
[68,null,null,null,1]
[69,null,null,null,1]
[70,null,null,null,1]
[71,null,null,null,1]
[72,null,null,null,1]
[73,null,null,null,1]
[74,null,null,null,1]
[75,null,null,null,1]
[76,null,null,null,1]
[77,null,null,null,1]
[78,null,null,null,1]
[79,null,null,null,1]
[80,null,null,null,1]
[81,null,null,null,1]
[82,null,null,null,1]
[83,null,null,null,1]
[84,null,null,null,1]
[85,null,null,null,1]
[86,null,null,null,1]
[87,null,null,null,1]
[88,null,null,null,1]
[89,null,null,null,1]
[90,null,null,null,1]
[91,null,null,null,1]
[92,null,null,null,1]
[93,null,null,null,1]
[94,null,null,null,1]
[95,null,null,null,1]
[96,null,null,null,1]
[97,null,null,null,1]
[98,null,null,null,1]
[99,null,null,null,1]
[100,null,null,null,1]
[101,null,null,null,1]
[102,null,null,null,1]
[103,null,null,null,1]
[104,null,null,null,1]
[105,null,null,null,1]
[106,null,null,null,1]
[107,null,null,null,1]
[108,null,null,null,1]
[109,null,null,null,1]
[110,null,null,null,1]
[111,null,null,null,1]
[112,null,null,null,1]
[113,null,null,null,1]
[114,null,null,null,1]
[115,null,null,null,1]
[116,null,null,null,1]
[117,null,null,null,1]
[118,null,null,null,1]
[119,null,null,null,1]
[120,null,null,null,1]
[121,null,null,null,1]
[122,null,null,null,1]
[123,null,null,null,1]
[124,null,null,null,1]
[125,null,null,null,1]
[126,null,null,null,1]

{"sheet":"Loop2","index":3,"n_rows":144,"n_cols":14,"rows_kept":144,"cut":false,"hidden":true,"merged":[[7,2,7,6],[2,1,2,6],[3,2,3,6],[4,2,4,6],[5,2,5,6],[6,2,6,6]]}
[null,{"$f":"\"Build Version: \" & Parameters!$D$2","v":"Build Version: 5"},null,null,"LOOP 2"]
[]
[null,"Details"]
[null,"CONTACT NAME:-",{"$f":"IF(LEN(Loop1!C4)>0,Loop1!C4,\"\")","v":""}]
[null,"CONTACT NUMBER:-",{"$f":"IF(LEN(Loop1!C5)>0,Loop1!C5,\"\")","v":""}]
[null,"COMPANY NAME:-                                        ",{"$f":"IF(LEN(Loop1!C6)>0,Loop1!C6,\"\")","v":""}]
[null,"SITE NAME:-",{"$f":"IF(LEN(Loop1!C7)>0,Loop1!C7,\"\")","v":""}]
[null,"SITE ADDRESS:-",{"$f":"IF(LEN(Loop1!C8)>0,Loop1!C8,\"\")","v":""}]
[]
[null,"Example"]
[null,"Device Type","Associated\nRCC\nNumber\n1-31","Device Address Number","Loop Number","Zone Number","LOCATION TEXT                                                                                                 MAX 40 CHARACTERS "]
[null,"Wireless Call Point",1,1,1,1,"GROUND FLOOR RECEPTION AREA"]
[null,"Wireless Radio Sounder",1,2,1,1,"GROUND FLOOR RECEPTION AREA"]
[null,"Wireless Optical Detector",1,3,1,1,"MAIN ENTRANCE LOBBY"]
[null,"Wireless Combined Detector Sounder",1,4,1,2,"FIRST FLOOR LANDING"]
[null,"Wireless Combined Optical Detector",null,5,1,2,"FIRST FLOOR LANDING"]
[]
["Device Address Number","Device Type","Associated\nRCC\nNumber\n1-31",null,"Loop Number","Zone Number","LOCATION TEXT                                                                                                 MAX 40 CHARACTERS ","Additional Comments",null,null,null,null,"Type","Qty"]
[1,null,null,null,2,null,null,null,null,null,null,null,"Wireless Call Point",{"$f":"COUNTIF($B$19:$B$144,M19)","v":0}]
[2,null,null,null,2,null,null,null,null,null,null,null,"Wireless Optical Detector",0]
[3,null,null,null,2,null,null,null,null,null,null,null,"Wireless Heat Detector CS",0]
[4,null,null,null,2,null,null,null,null,null,null,null,"Wireless Heat Detector A1R",0]
[5,null,null,null,2,null,null,null,null,null,null,null,"Wireless Multisensor",0]
[6,null,null,null,2,null,null,null,null,null,null,null,"Wireless Input Output Unit",0]
[7,null,null,null,2,null,null,null,null,null,null,null,"Wireless Combined Detector Sounder",0]
[8,null,null,null,2,null,null,null,null,null,null,null,"Wireless Combined Optical Detector",0]
[9,null,null,null,2,null,null,null,null,null,null,null,"Wireless Combined Heat Detector CS",0]
[10,null,null,null,2,null,null,null,null,null,null,null,"Wireless Combined Heat Detector A1R",0]
[11,null,null,null,2,null,null,null,null,null,null,null,"Wireless Combined Multisensor",0]
[12,null,null,null,2,null,null,null,null,null,null,null,"Wireless Combined Detector Sounder - Visual Indicator",0]
[13,null,null,null,2,null,null,null,null,null,null,null,"Wireless Combined Visual Indicator - Optical Detector",0]
[14,null,null,null,2,null,null,null,null,null,null,null,"Wireless Combined Visual Indicator - Heat Detector CS",0]
[15,null,null,null,2,null,null,null,null,null,null,null,"Wireless Combined Visual Indicator - Heat Detector A1R",0]
[16,null,null,null,2,null,null,null,null,null,null,null,"Wireless Combined Visual Indicator - Multisensor",0]
[17,null,null,null,2,null,null,null,null,null,null,null,"Wireless Sounder",0]
[18,null,null,null,2,null,null,null,null,null,null,null,"Wireless Sounder Beacon",0]
[19,null,null,null,2,null,null,null,null,null,null,null,"Wireless Beacon",0]
[20,null,null,null,2,null,null,null,null,null,null,null,"Wireless Weather Resistant Sounder",0]
[21,null,null,null,2,null,null,null,null,null,null,null,"Wireless Weather Resistant Sounder Beacon",0]
[22,null,null,null,2,null,null,null,null,null,null,null,"Wireless Weather Resistant Beacon",0]
[23,null,null,null,2,null,null,null,null,null,null,null,"Wireless Remote Indicator",0]
[24,null,null,null,2,null,null,null,null,null,null,null,"Wireless Radio Cluster Communicator",0]
[25,null,null,null,2,null,null,null,null,null,null,null,"Wireless Radio HUB",0]
[26,null,null,null,2,null,null,null,null,null,null,null,null,0]
[27,null,null,null,2,null,null,null,null,null,null,null,"Total",{"$f":"SUM(N19:N44)","v":0}]
[28,null,null,null,2]
[29,null,null,null,2]
[30,null,null,null,2]
[31,null,null,null,2]
[32,null,null,null,2]
[33,null,null,null,2]
[34,null,null,null,2]
[35,null,null,null,2]
[36,null,null,null,2]
[37,null,null,null,2]
[38,null,null,null,2]
[39,null,null,null,2]
[40,null,null,null,2]
[41,null,null,null,2]
[42,null,null,null,2]
[43,null,null,null,2]
[44,null,null,null,2]
[45,null,null,null,2]
[46,null,null,null,2]
[47,null,null,null,2]
[48,null,null,null,2]
[49,null,null,null,2]
[50,null,null,null,2]
[51,null,null,null,2]
[52,null,null,null,2]
[53,null,null,null,2]
[54,null,null,null,2]
[55,null,null,null,2]
[56,null,null,null,2]
[57,null,null,null,2]
[58,null,null,null,2]
[59,null,null,null,2]
[60,null,null,null,2]
[61,null,null,null,2]
[62,null,null,null,2]
[63,null,null,null,2]
[64,null,null,null,2]
[65,null,null,null,2]
[66,null,null,null,2]
[67,null,null,null,2]
[68,null,null,null,2]
[69,null,null,null,2]
[70,null,null,null,2]
[71,null,null,null,2]
[72,null,null,null,2]
[73,null,null,null,2]
[74,null,null,null,2]
[75,null,null,null,2]
[76,null,null,null,2]
[77,null,null,null,2]
[78,null,null,null,2]
[79,null,null,null,2]
[80,null,null,null,2]
[81,null,null,null,2]
[82,null,null,null,2]
[83,null,null,null,2]
[84,null,null,null,2]
[85,null,null,null,2]
[86,null,null,null,2]
[87,null,null,null,2]
[88,null,null,null,2]
[89,null,null,null,2]
[90,null,null,null,2]
[91,null,null,null,2]
[92,null,null,null,2]
[93,null,null,null,2]
[94,null,null,null,2]
[95,null,null,null,2]
[96,null,null,null,2]
[97,null,null,null,2]
[98,null,null,null,2]
[99,null,null,null,2]
[100,null,null,null,2]
[101,null,null,null,2]
[102,null,null,null,2]
[103,null,null,null,2]
[104,null,null,null,2]
[105,null,null,null,2]
[106,null,null,null,2]
[107,null,null,null,2]
[108,null,null,null,2]
[109,null,null,null,2]
[110,null,null,null,2]
[111,null,null,null,2]
[112,null,null,null,2]
[113,null,null,null,2]
[114,null,null,null,2]
[115,null,null,null,2]
[116,null,null,null,2]
[117,null,null,null,2]
[118,null,null,null,2]
[119,null,null,null,2]
[120,null,null,null,2]
[121,null,null,null,2]
[122,null,null,null,2]
[123,null,null,null,2]
[124,null,null,null,2]
[125,null,null,null,2]
[126,null,null,null,2]

{"sheet":"Loop3","index":4,"n_rows":144,"n_cols":14,"rows_kept":144,"cut":false,"hidden":true,"merged":[[7,2,7,6],[2,1,2,6],[3,2,3,6],[4,2,4,6],[5,2,5,6],[6,2,6,6]]}
[null,{"$f":"\"Build Version: \" & Parameters!$D$2","v":"Build Version: 5"},null,null,"LOOP 3"]
[]
[null,"Details"]
[null,"CONTACT NAME:-",{"$f":"IF(LEN(Loop1!C4)>0,Loop1!C4,\"\")","v":""}]
[null,"CONTACT NUMBER:-",{"$f":"IF(LEN(Loop1!C5)>0,Loop1!C5,\"\")","v":""}]
[null,"COMPANY NAME:-                                        ",{"$f":"IF(LEN(Loop1!C6)>0,Loop1!C6,\"\")","v":""}]
[null,"SITE NAME:-",{"$f":"IF(LEN(Loop1!C7)>0,Loop1!C7,\"\")","v":""}]
[null,"SITE ADDRESS:-",{"$f":"IF(LEN(Loop1!C8)>0,Loop1!C8,\"\")","v":""}]
[]
[null,"Example"]
[null,"Device Type","Associated\nRCC\nNumber\n1-31","Device Address Number","Loop Number","Zone Number","LOCATION TEXT                                                                                                 MAX 40 CHARACTERS "]
[null,"Wireless Call Point",1,1,1,1,"GROUND FLOOR RECEPTION AREA"]
[null,"Wireless Radio Sounder",1,2,1,1,"GROUND FLOOR RECEPTION AREA"]
[null,"Wireless Optical Detector",1,3,1,1,"MAIN ENTRANCE LOBBY"]
[null,"Wireless Combined Detector Sounder",1,4,1,2,"FIRST FLOOR LANDING"]
[null,"Wireless Combined Optical Detector",null,5,1,2,"FIRST FLOOR LANDING"]
[]
["Device Address Number","Device Type","Associated\nRCC\nNumber\n1-31",null,"Loop Number","Zone Number","LOCATION TEXT                                                                                                 MAX 40 CHARACTERS ","Additional Comments",null,null,null,null,"Type","Qty"]
[1,null,null,null,3,null,null,null,null,null,null,null,"Wireless Call Point",{"$f":"COUNTIF($B$19:$B$144,M19)","v":0}]
[2,null,null,null,3,null,null,null,null,null,null,null,"Wireless Optical Detector",{"$f":"COUNTIF($B$19:$B$144,M20)","v":0}]
[3,null,null,null,3,null,null,null,null,null,null,null,"Wireless Heat Detector CS",0]
[4,null,null,null,3,null,null,null,null,null,null,null,"Wireless Heat Detector A1R",0]
[5,null,null,null,3,null,null,null,null,null,null,null,"Wireless Multisensor",0]
[6,null,null,null,3,null,null,null,null,null,null,null,"Wireless Input Output Unit",{"$f":"COUNTIF($B$19:$B$144,M24)","v":0}]
[7,null,null,null,3,null,null,null,null,null,null,null,"Wireless Combined Detector Sounder",0]
[8,null,null,null,3,null,null,null,null,null,null,null,"Wireless Combined Optical Detector",0]
[9,null,null,null,3,null,null,null,null,null,null,null,"Wireless Combined Heat Detector CS",0]
[10,null,null,null,3,null,null,null,null,null,null,null,"Wireless Combined Heat Detector A1R",0]
[11,null,null,null,3,null,null,null,null,null,null,null,"Wireless Combined Multisensor",0]
[12,null,null,null,3,null,null,null,null,null,null,null,"Wireless Combined Detector Sounder - Visual Indicator",0]
[13,null,null,null,3,null,null,null,null,null,null,null,"Wireless Combined Visual Indicator - Optical Detector",0]
[14,null,null,null,3,null,null,null,null,null,null,null,"Wireless Combined Visual Indicator - Heat Detector CS",0]
[15,null,null,null,3,null,null,null,null,null,null,null,"Wireless Combined Visual Indicator - Heat Detector A1R",0]
[16,null,null,null,3,null,null,null,null,null,null,null,"Wireless Combined Visual Indicator - Multisensor",0]
[17,null,null,null,3,null,null,null,null,null,null,null,"Wireless Sounder",0]
[18,null,null,null,3,null,null,null,null,null,null,null,"Wireless Sounder Beacon",0]
[19,null,null,null,3,null,null,null,null,null,null,null,"Wireless Beacon",0]
[20,null,null,null,3,null,null,null,null,null,null,null,"Wireless Weather Resistant Sounder",0]
[21,null,null,null,3,null,null,null,null,null,null,null,"Wireless Weather Resistant Sounder Beacon",0]
[22,null,null,null,3,null,null,null,null,null,null,null,"Wireless Weather Resistant Beacon",0]
[23,null,null,null,3,null,null,null,null,null,null,null,"Wireless Remote Indicator",0]
[24,null,null,null,3,null,null,null,null,null,null,null,"Wireless Radio Cluster Communicator",0]
[25,null,null,null,3,null,null,null,null,null,null,null,"Wireless Radio HUB",0]
[26,null,null,null,3,null,null,null,null,null,null,null,null,0]
[27,null,null,null,3,null,null,null,null,null,null,null,"Total",{"$f":"SUM(N19:N44)","v":0}]
[28,null,null,null,3]
[29,null,null,null,3]
[30,null,null,null,3]
[31,null,null,null,3]
[32,null,null,null,3]
[33,null,null,null,3]
[34,null,null,null,3]
[35,null,null,null,3]
[36,null,null,null,3]
[37,null,null,null,3]
[38,null,null,null,3]
[39,null,null,null,3]
[40,null,null,null,3]
[41,null,null,null,3]
[42,null,null,null,3]
[43,null,null,null,3]
[44,null,null,null,3]
[45,null,null,null,3]
[46,null,null,null,3]
[47,null,null,null,3]
[48,null,null,null,3]
[49,null,null,null,3]
[50,null,null,null,3]
[51,null,null,null,3]
[52,null,null,null,3]
[53,null,null,null,3]
[54,null,null,null,3]
[55,null,null,null,3]
[56,null,null,null,3]
[57,null,null,null,3]
[58,null,null,null,3]
[59,null,null,null,3]
[60,null,null,null,3]
[61,null,null,null,3]
[62,null,null,null,3]
[63,null,null,null,3]
[64,null,null,null,3]
[65,null,null,null,3]
[66,null,null,null,3]
[67,null,null,null,3]
[68,null,null,null,3]
[69,null,null,null,3]
[70,null,null,null,3]
[71,null,null,null,3]
[72,null,null,null,3]
[73,null,null,null,3]
[74,null,null,null,3]
[75,null,null,null,3]
[76,null,null,null,3]
[77,null,null,null,3]
[78,null,null,null,3]
[79,null,null,null,3]
[80,null,null,null,3]
[81,null,null,null,3]
[82,null,null,null,3]
[83,null,null,null,3]
[84,null,null,null,3]
[85,null,null,null,3]
[86,null,null,null,3]
[87,null,null,null,3]
[88,null,null,null,3]
[89,null,null,null,3]
[90,null,null,null,3]
[91,null,null,null,3]
[92,null,null,null,3]
[93,null,null,null,3]
[94,null,null,null,3]
[95,null,null,null,3]
[96,null,null,null,3]
[97,null,null,null,3]
[98,null,null,null,3]
[99,null,null,null,3]
[100,null,null,null,3]
[101,null,null,null,3]
[102,null,null,null,3]
[103,null,null,null,3]
[104,null,null,null,3]
[105,null,null,null,3]
[106,null,null,null,3]
[107,null,null,null,3]
[108,null,null,null,3]
[109,null,null,null,3]
[110,null,null,null,3]
[111,null,null,null,3]
[112,null,null,null,3]
[113,null,null,null,3]
[114,null,null,null,3]
[115,null,null,null,3]
[116,null,null,null,3]
[117,null,null,null,3]
[118,null,null,null,3]
[119,null,null,null,3]
[120,null,null,null,3]
[121,null,null,null,3]
[122,null,null,null,3]
[123,null,null,null,3]
[124,null,null,null,3]
[125,null,null,null,3]
[126,null,null,null,3]

{"sheet":"Loop4","index":5,"n_rows":144,"n_cols":14,"rows_kept":144,"cut":false,"hidden":true,"merged":[[7,2,7,6],[2,1,2,6],[3,2,3,6],[4,2,4,6],[5,2,5,6],[6,2,6,6]]}
[null,{"$f":"\"Build Version: \" & Parameters!$D$2","v":"Build Version: 5"},null,null,"LOOP 4"]
[]
[null,"Details"]
[null,"CONTACT NAME:-",{"$f":"IF(LEN(Loop1!C4)>0,Loop1!C4,\"\")","v":""}]
[null,"CONTACT NUMBER:-",{"$f":"IF(LEN(Loop1!C5)>0,Loop1!C5,\"\")","v":""}]
[null,"COMPANY NAME:-                                        ",{"$f":"IF(LEN(Loop1!C6)>0,Loop1!C6,\"\")","v":""}]
[null,"SITE NAME:-",{"$f":"IF(LEN(Loop1!C7)>0,Loop1!C7,\"\")","v":""}]
[null,"SITE ADDRESS:-",{"$f":"IF(LEN(Loop1!C8)>0,Loop1!C8,\"\")","v":""}]
[]
[null,"Example"]
[null,"Device Type","Associated\nRCC\nNumber\n1-31","Device Address Number","Loop Number","Zone Number","LOCATION TEXT                                                                                                 MAX 40 CHARACTERS "]
[null,"Wireless Call Point",1,1,1,1,"GROUND FLOOR RECEPTION AREA"]
[null,"Wireless Radio Sounder",1,2,1,1,"GROUND FLOOR RECEPTION AREA"]
[null,"Wireless Optical Detector",1,3,1,1,"MAIN ENTRANCE LOBBY"]
[null,"Wireless Combined Detector Sounder",1,4,1,2,"FIRST FLOOR LANDING"]
[null,"Wireless Combined Optical Detector",null,5,1,2,"FIRST FLOOR LANDING"]
[]
["Device Address Number","Device Type","Associated\nRCC\nNumber\n1-31",null,"Loop Number","Zone Number","LOCATION TEXT                                                                                                 MAX 40 CHARACTERS ","Additional Comments",null,null,null,null,"Type","Qty"]
[1,null,null,null,4,null,null,null,null,null,null,null,"Wireless Call Point",{"$f":"COUNTIF($B$19:$B$144,M19)","v":0}]
[2,null,null,null,4,null,null,null,null,null,null,null,"Wireless Optical Detector",{"$f":"COUNTIF($B$19:$B$144,M20)","v":0}]
[3,null,null,null,4,null,null,null,null,null,null,null,"Wireless Heat Detector CS",0]
[4,null,null,null,4,null,null,null,null,null,null,null,"Wireless Heat Detector A1R",0]
[5,null,null,null,4,null,null,null,null,null,null,null,"Wireless Multisensor",0]
[6,null,null,null,4,null,null,null,null,null,null,null,"Wireless Input Output Unit",{"$f":"COUNTIF($B$19:$B$144,M24)","v":0}]
[7,null,null,null,4,null,null,null,null,null,null,null,"Wireless Combined Detector Sounder",0]
[8,null,null,null,4,null,null,null,null,null,null,null,"Wireless Combined Optical Detector",0]
[9,null,null,null,4,null,null,null,null,null,null,null,"Wireless Combined Heat Detector CS",0]
[10,null,null,null,4,null,null,null,null,null,null,null,"Wireless Combined Heat Detector A1R",0]
[11,null,null,null,4,null,null,null,null,null,null,null,"Wireless Combined Multisensor",0]
[12,null,null,null,4,null,null,null,null,null,null,null,"Wireless Combined Detector Sounder - Visual Indicator",0]
[13,null,null,null,4,null,null,null,null,null,null,null,"Wireless Combined Visual Indicator - Optical Detector",0]
[14,null,null,null,4,null,null,null,null,null,null,null,"Wireless Combined Visual Indicator - Heat Detector CS",0]
[15,null,null,null,4,null,null,null,null,null,null,null,"Wireless Combined Visual Indicator - Heat Detector A1R",0]
[16,null,null,null,4,null,null,null,null,null,null,null,"Wireless Combined Visual Indicator - Multisensor",0]
[17,null,null,null,4,null,null,null,null,null,null,null,"Wireless Sounder",0]
[18,null,null,null,4,null,null,null,null,null,null,null,"Wireless Sounder Beacon",0]
[19,null,null,null,4,null,null,null,null,null,null,null,"Wireless Beacon",0]
[20,null,null,null,4,null,null,null,null,null,null,null,"Wireless Weather Resistant Sounder",0]
[21,null,null,null,4,null,null,null,null,null,null,null,"Wireless Weather Resistant Sounder Beacon",0]
[22,null,null,null,4,null,null,null,null,null,null,null,"Wireless Weather Resistant Beacon",0]
[23,null,null,null,4,null,null,null,null,null,null,null,"Wireless Remote Indicator",0]
[24,null,null,null,4,null,null,null,null,null,null,null,"Wireless Radio Cluster Communicator",0]
[25,null,null,null,4,null,null,null,null,null,null,null,"Wireless Radio HUB",0]
[26,null,null,null,4,null,null,null,null,null,null,null,null,0]
[27,null,null,null,4,null,null,null,null,null,null,null,"Total",{"$f":"SUM(N19:N44)","v":0}]
[28,null,null,null,4]
[29,null,null,null,4]
[30,null,null,null,4]
[31,null,null,null,4]
[32,null,null,null,4]
[33,null,null,null,4]
[34,null,null,null,4]
[35,null,null,null,4]
[36,null,null,null,4]
[37,null,null,null,4]
[38,null,null,null,4]
[39,null,null,null,4]
[40,null,null,null,4]
[41,null,null,null,4]
[42,null,null,null,4]
[43,null,null,null,4]
[44,null,null,null,4]
[45,null,null,null,4]
[46,null,null,null,4]
[47,null,null,null,4]
[48,null,null,null,4]
[49,null,null,null,4]
[50,null,null,null,4]
[51,null,null,null,4]
[52,null,null,null,4]
[53,null,null,null,4]
[54,null,null,null,4]
[55,null,null,null,4]
[56,null,null,null,4]
[57,null,null,null,4]
[58,null,null,null,4]
[59,null,null,null,4]
[60,null,null,null,4]
[61,null,null,null,4]
[62,null,null,null,4]
[63,null,null,null,4]
[64,null,null,null,4]
[65,null,null,null,4]
[66,null,null,null,4]
[67,null,null,null,4]
[68,null,null,null,4]
[69,null,null,null,4]
[70,null,null,null,4]
[71,null,null,null,4]
[72,null,null,null,4]
[73,null,null,null,4]
[74,null,null,null,4]
[75,null,null,null,4]
[76,null,null,null,4]
[77,null,null,null,4]
[78,null,null,null,4]
[79,null,null,null,4]
[80,null,null,null,4]
[81,null,null,null,4]
[82,null,null,null,4]
[83,null,null,null,4]
[84,null,null,null,4]
[85,null,null,null,4]
[86,null,null,null,4]
[87,null,null,null,4]
[88,null,null,null,4]
[89,null,null,null,4]
[90,null,null,null,4]
[91,null,null,null,4]
[92,null,null,null,4]
[93,null,null,null,4]
[94,null,null,null,4]
[95,null,null,null,4]
[96,null,null,null,4]
[97,null,null,null,4]
[98,null,null,null,4]
[99,null,null,null,4]
[100,null,null,null,4]
[101,null,null,null,4]
[102,null,null,null,4]
[103,null,null,null,4]
[104,null,null,null,4]
[105,null,null,null,4]
[106,null,null,null,4]
[107,null,null,null,4]
[108,null,null,null,4]
[109,null,null,null,4]
[110,null,null,null,4]
[111,null,null,null,4]
[112,null,null,null,4]
[113,null,null,null,4]
[114,null,null,null,4]
[115,null,null,null,4]
[116,null,null,null,4]
[117,null,null,null,4]
[118,null,null,null,4]
[119,null,null,null,4]
[120,null,null,null,4]
[121,null,null,null,4]
[122,null,null,null,4]
[123,null,null,null,4]
[124,null,null,null,4]
[125,null,null,null,4]
[126,null,null,null,4]

{"sheet":"Device QTY","index":6,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":true,"merged":[[6,1,6,9],[1,0,1,9],[2,1,2,9],[3,1,3,9],[4,1,4,9],[5,1,5,9]]}
[{"$f":"\"Build Version: \" & Parameters!$D$2","v":"Build Version: 5"}]
["Details"]
["CONTACT NAME:-",{"$f":"IF(LEN(Loop1!C4)>0,Loop1!C4,\"\")","v":""}]
["CONTACT NUMBER:-",{"$f":"IF(LEN(Loop1!C5)>0,Loop1!C5,\"\")","v":""}]
["COMPANY NAME:-                                        ",{"$f":"IF(LEN(Loop1!C6)>0,Loop1!C6,\"\")","v":""}]
["SITE NAME:-",{"$f":"IF(LEN(Loop1!C7)>0,Loop1!C7,\"\")","v":""}]
["SITE ADDRESS:-",{"$f":"IF(LEN(Loop1!C8)>0,Loop1!C8,\"\")","v":""}]
[]
["Type","Loop 1 ","Loop 2","Loop 3","Loop 4","Totals"]
["Wireless Call Point",{"$f":"IF(ISNA(VLOOKUP($A10,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A10,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A10,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A10,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A10,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A10,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A10,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A10,Loop4!$M$19:$N$45,2,FALSE))","v":0},{"$f":"SUM(B10:E10)","v":0}]
["Wireless Optical Detector",{"$f":"IF(ISNA(VLOOKUP($A11,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A11,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A11,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A11,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A11,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A11,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A11,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A11,Loop4!$M$19:$N$45,2,FALSE))","v":0},{"$f":"SUM(B11:E11)","v":0}]
["Wireless Heat Detector CS",{"$f":"IF(ISNA(VLOOKUP($A12,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A12,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A12,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A12,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A12,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A12,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A12,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A12,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Heat Detector A1R",{"$f":"IF(ISNA(VLOOKUP($A13,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A13,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A13,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A13,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A13,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A13,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A13,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A13,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Multisensor",{"$f":"IF(ISNA(VLOOKUP($A14,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A14,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A14,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A14,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A14,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A14,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A14,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A14,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Input Output Unit",{"$f":"IF(ISNA(VLOOKUP($A15,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A15,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A15,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A15,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A15,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A15,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A15,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A15,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Combined Detector Sounder",{"$f":"IF(ISNA(VLOOKUP($A16,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A16,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A16,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A16,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A16,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A16,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A16,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A16,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Combined Optical Detector",{"$f":"IF(ISNA(VLOOKUP($A17,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A17,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A17,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A17,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A17,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A17,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A17,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A17,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Combined Heat Detector CS",{"$f":"IF(ISNA(VLOOKUP($A18,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A18,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A18,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A18,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A18,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A18,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A18,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A18,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Combined Heat Detector A1R",{"$f":"IF(ISNA(VLOOKUP($A19,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A19,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A19,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A19,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A19,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A19,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A19,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A19,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Combined Multisensor",{"$f":"IF(ISNA(VLOOKUP($A20,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A20,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A20,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A20,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A20,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A20,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A20,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A20,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Combined Detector Sounder - Visual Indicator",{"$f":"IF(ISNA(VLOOKUP($A21,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A21,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A21,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A21,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A21,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A21,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A21,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A21,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Combined Visual Indicator - Optical Detector",{"$f":"IF(ISNA(VLOOKUP($A22,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A22,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A22,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A22,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A22,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A22,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A22,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A22,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Combined Visual Indicator - Heat Detector CS",{"$f":"IF(ISNA(VLOOKUP($A23,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A23,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A23,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A23,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A23,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A23,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A23,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A23,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Combined Visual Indicator - Heat Detector A1R",{"$f":"IF(ISNA(VLOOKUP($A24,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A24,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A24,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A24,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A24,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A24,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A24,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A24,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Combined Visual Indicator - Multisensor",{"$f":"IF(ISNA(VLOOKUP($A25,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A25,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A25,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A25,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A25,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A25,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A25,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A25,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Sounder",{"$f":"IF(ISNA(VLOOKUP($A26,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A26,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A26,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A26,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A26,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A26,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A26,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A26,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Sounder Beacon",{"$f":"IF(ISNA(VLOOKUP($A27,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A27,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A27,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A27,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A27,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A27,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A27,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A27,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Beacon",{"$f":"IF(ISNA(VLOOKUP($A28,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A28,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A28,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A28,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A28,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A28,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A28,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A28,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Weather Resistant Sounder",{"$f":"IF(ISNA(VLOOKUP($A29,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A29,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A29,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A29,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A29,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A29,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A29,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A29,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Weather Resistant Sounder Beacon",{"$f":"IF(ISNA(VLOOKUP($A30,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A30,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A30,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A30,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A30,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A30,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A30,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A30,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Weather Resistant Beacon",{"$f":"IF(ISNA(VLOOKUP($A31,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A31,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A31,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A31,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A31,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A31,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A31,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A31,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Remote Indicator",{"$f":"IF(ISNA(VLOOKUP($A32,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A32,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A32,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A32,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A32,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A32,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A32,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A32,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Radio Cluster Communicator",{"$f":"IF(ISNA(VLOOKUP($A33,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A33,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A33,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A33,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A33,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A33,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A33,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A33,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Wireless Radio HUB",{"$f":"IF(ISNA(VLOOKUP($A34,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A34,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A34,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A34,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A34,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A34,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A34,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A34,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
[null,{"$f":"IF(ISNA(VLOOKUP($A35,Loop1!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A35,Loop1!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A35,Loop2!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A35,Loop2!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A35,Loop3!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A35,Loop3!$M$19:$N$45,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($A35,Loop4!$M$19:$N$45,2,FALSE)),0,VLOOKUP($A35,Loop4!$M$19:$N$45,2,FALSE))","v":0},0]
["Total",{"$f":"SUM(B10:B35)","v":0},{"$f":"SUM(C10:C35)","v":0},0,0,0]

{"sheet":"Help","index":7,"n_rows":111,"n_cols":2,"rows_kept":111,"cut":false,"hidden":true,"merged":[[2,0,2,11]]}
[]
[]
["How to Fill in the Firecell System Address Schedule"]
[]
["Step 1. Familiarise yourself with the information required to be added into the relevant fields of the schedule"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 2.Enter your details followed by the site details"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 3. Add the devices to the schedule ensuring to include the Radio Hub and all RCC's"]
[]
[null,"Clicking  to the right off the device type column with each row will present a drop down box to be able to select the device type"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 4. Checklist"]
[]
[null,"1. Device quantities must match quatities on order"]
[null,"2. Radio hub must be included in the schedule"]
[null,"3. All Radio cluster communicators (RCC) must be included in the schedule"]
[null,"4. All devices associated to correct RCC address"]

{"sheet":"Parameters","index":8,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Named Range: DeviceList [Care To Be Taken When Changing This Range]",null,"Parameter","Value","Date","Comments",null,"Parameter","Value","Comments"]
["Wireless Radio Cluster Communicator",null,"Current Version",{"$f":"MAX(D3:D741)","v":5},{"$f":"MAX(E3:E741)","v":"2018-07-25"},"Current Version deployed",null,"HelpOrigin","Loop1","Sheet Name That The Help Button Was Pressed From"]
["Wireless Radio HUB",null,"Version",1,"2017-11-29","Initial Release after Alpha Testing.\nBased On Ver 13 of the Full Address Schedule Spreadsheet."]
["Wireless Call Point",null,"Verison",2,"2017-12-18","Added MACRO MUST BE ENABLED To Loop 1 Sheet Cell G1"]
["Wireless Optical Detector",null,"Version",3,"2018-01-25","Added Macro Enable Landing Page. Added Site Details Page. Modified Print Areas and re-formatted sheet to enable easier interpritaion of data when printed. "]
["Wireless Heat Detector CS",null,"Version",4,"2018-05-03","Resequenced Device List:\nWireless Radio Cluster Communicator\nWireless Radio HUB\nplaced at top of dropdown list"]
["Wireless Heat Detector A1R",null,"Version",5,"2018-07-25","Added Additional Code To Ensure The 'Enter loop Info' Button has focus when a user has entered the address schedule info"]
["Wireless Multisensor"]
["Wireless Input Output Unit"]
["Wireless Combined Detector Sounder"]
["Wireless Combined Detector Sounder - Visual Indicator"]
["Wireless Sounder"]
["Wireless Sounder Beacon"]
["Wireless Beacon"]
["Wireless Weather Resistant Sounder"]
["Wireless Weather Resistant Sounder Beacon"]
["Wireless Weather Resistant Beacon"]
["Wireless Remote Indicator"]