{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["PE-10SN","Device Database","User Defined"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":10,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PE-10SN","index":0,"n_rows":218,"n_cols":20,"rows_kept":218,"cut":false,"hidden":false,"merged":[[29,3,29,4],[206,3,206,4],[207,3,207,4],[208,3,208,4],[209,3,209,4],[210,3,210,4],[205,3,205,4],[161,3,161,4],[129,3,129,4],[130,3,130,4],[131,3,131,4],[154,3,154,4],[152,3,152,4],[153,3,153,4],[182,3,182,4],[183,3,183,4],[177,3,177,4],[162,2,163,4],[115,2,116,4],[120,3,120,4],[113,3,113,4],[114,3,114,4],[112,3,112,4],[111,3,111,4],[211,2,212,4],[194,3,194,4],[194,6,194,7],[199,1,199,4],[199,5,199,6],[199,7,199,8],[201,3,201,4],[202,3,202,4],[203,3,203,4],[204,3,204,4],[145,3,145,4],[190,6,190,7],[178,3,178,4],[155,3,155,4],[156,3,156,4],[174,3,174,4],[175,3,175,4],[157,3,157,4],[158,3,158,4],[159,3,159,4],[160,3,160,4],[167,6,167,7],[172,1,172,4],[172,5,172,6],[172,7,172,8],[167,3,167,4],[176,3,176,4],[184,2,185,4],[179,3,179,4],[180,3,180,4],[181,3,181,4],[135,3,135,4],[120,6,120,7],[125,1,125,4],[125,5,125,6],[125,7,125,8],[141,6,141,7],[137,2,138,4],[127,3,127,4],[128,3,128,4],[136,3,136,4],[22,1,22,3],[62,3,62,4],[51,3,51,4],[63,3,63,4],[109,3,109,4],[110,3,110,4],[24,3,24,4],[25,3,25,4],[56,1,56,4],[58,3,58,4],[81,3,81,4],[64,3,64,4],[65,3,65,4],[66,3,66,4],[67,3,67,4],[73,3,73,4],[108,3,108,4],[83,3,83,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[30,3,30,4],[82,3,82,4],[59,3,59,4],[17,5,17,6],[13,6,16,8],[17,7,17,8],[5,1,9,3],[1,5,1,6],[3,5,3,6],[5,5,5,6],[7,5,7,6],[17,1,17,3],[13,3,13,4],[15,3,15,4],[216,0,216,8],[47,6,47,7],[98,3,98,4],[98,6,98,7],[103,1,103,4],[103,5,103,6],[103,7,103,8],[87,3,87,4],[51,6,51,7],[56,5,56,6],[56,7,56,8],[73,6,73,7],[78,5,78,6],[78,7,78,8],[86,3,86,4],[214,0,214,8],[215,0,215,8],[145,6,145,7],[150,1,150,4],[150,5,150,6],[150,7,150,8],[132,3,132,4],[133,3,133,4],[134,3,134,4],[94,6,94,7],[105,3,105,4],[106,3,106,4],[107,3,107,4],[90,2,92,4],[84,3,84,4],[85,3,85,4],[60,3,60,4],[61,3,61,4],[68,2,69,4],[78,1,78,4],[88,3,88,4],[89,3,89,4],[80,3,80,4]]}
[]
[null,null,null,null,"Project Name: ",null,null,"Standby Hours: ",24]
[]
[null,null,null,null,null,null,null,"Alarm Mins: ",5]
[]
[null,"PE-10SN\nBattery & Voltage Drop\nCalculations",null,null,"Installed By: ",null,null,"Batt Efficiency %: ",0.8]
[]
[null,null,null,null,"Designed By: "]
[]
[null,null,null,null,"Date: ",null,null,"NAC Source Voltage: ",20.399999999999999]
[]
[null,null,"Model #: ","PE-10SN",null,null,null,"Max Panel Current (amps): ",10]
[]
[null,null,"Panel ID: ",null,null,null,"User assumes all responsibility to ensure the quantities and current draw values in this worksheet are accurate prior to submittal."]
[]
[null,null,"Location: "]
[]
[null,"Panel",null,null,null,"Standby (amps)",null,"Alarm (amps)",null,null,"Class B"]
[null,"Qty","Part #","Description",null,"Each","Total","Each","Total",null,"Class A"]
[null,1,"PE-10SN","NAC Power Expander",null,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2,null,null,null,null,0.8]
[null,null,null,null,null,"Panel Standby: ",{"$f":"G20","v":7.4999999999999997E-2},"Panel Alarm: ",{"$f":"I20","v":7.4999999999999997E-2},null,null,null,null,0.75]
[]
[null,"NAC Circuits (See NAC Configuration below)",null,null,null,null,"Standby (amps)",null,"Alarm (amps)"]
[null,"Ckt","Use","Description",null,null,"Total",null,"Total"]
[null,1,{"$f":"IF(D52<>\"\", D52, \"\")","v":""},{"$f":"IF(G52<>\"\", G52, \"\")","v":""},null,null,{"$f":"G69","v":0},null,{"$f":"I69","v":0}]
[null,2,{"$f":"IF(D74<>\"\", D74, \"\")","v":""},{"$f":"IF(G74<>\"\", G74, \"\")","v":""},null,null,{"$f":"G91","v":0},null,{"$f":"I91","v":0}]
[null,3,{"$f":"IF(D99<>\"\", D99, \"\")","v":""},{"$f":"IF(G99<>\"\", G99, \"\")","v":""},null,null,{"$f":"G116","v":0},null,{"$f":"I116","v":0}]
[null,4,{"$f":"IF(D121<>\"\", D121, \"\")","v":""},{"$f":"IF(G121<>\"\", G121, \"\")","v":""},null,null,{"$f":"G138","v":0},null,{"$f":"I138","v":0}]
[null,5,{"$f":"IF(D146<>\"\", D146, \"\")","v":""},{"$f":"IF(G146<>\"\", G146, \"\")","v":""},null,null,{"$f":"G163","v":0},null,{"$f":"I163","v":0}]
[null,6,{"$f":"IF(D168<>\"\", D168, \"\")","v":""},{"$f":"IF(G168<>\"\", G168, \"\")","v":""},null,null,{"$f":"G185","v":0},null,{"$f":"I185","v":0}]
[null,"AUX",{"$f":"IF(D195<>\"\", D195, \"\")","v":""},{"$f":"IF(G195<>\"\", G195, \"\")","v":""},null,null,{"$f":"G212","v":0},null,{"$f":"I212","v":0},null,null,null,null,"Below is for feet/meters",null,null,"notes"]
[null,null,null,null,null,"NAC Standby:",{"$f":"SUM(G25:G31)","v":0},"NAC Alarm:",{"$f":"SUM(I25:I31)","v":0},null,null,null,null,null,null,null,"meters = ft/3.2808"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Feet",1,null,"feet = meters*3.2808"]
[null,null,"Battery Calculation Summary",null,null,null,"Standby (amps)",null,"Alarm (amps)",null,null,null,null,"Meters"]
[null,null,null,null,null,"Panel Current: ",{"$f":"G21","v":7.4999999999999997E-2},null,{"$f":"I21","v":7.4999999999999997E-2}]
[null,null,null,null,null,"NAC Circuit Current: ",{"$f":"G32","v":0},null,{"$f":"I32","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ohms / 1000ft"]
[null,null,null,{"$f":"IF(I8<>\"\", I8, \"\")","v":""},null,"Total Standby: ",{"$f":"SUM(G35:G36)","v":7.4999999999999997E-2},"Total Alarm: ",{"$f":"SUM(I35:I36)","v":7.4999999999999997E-2},null,null,null,null,"Ohms / km"]
[null,null,null,{"$f":"IF(D38 = \"Class A\", SUM(#REF!), IF(D38=\"Class B\", SUM(#REF!)+(#REF!*2)+SUM(#REF!), \"\"))","v":""},null,"Standby Hours: ",{"$f":"I2","v":24},"Alarm Mins: ",{"$f":"I4","v":5}]
[null,null,null,null,null,"AH Required:",{"$f":"ROUNDUP(G38*G39, 2)","v":1.8}," AH Required:",{"$f":"ROUNDUP((I39/60)*I38, 2)","v":0.01}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O33=1,N37,N38)","v":"Ohms / 1000ft"},null,"<--- this one is for the userform, PLEASE do not change it!!!!"]
[null,null,null,null,null,null,null,"Total Combined Standby & Alarm AmpHours Required: ",{"$f":"I40+G40","v":1.81},null,"Aux Power"]
[null,null,null,null,null,null,null,"Efficiency Factor: ",{"$f":"I6","v":0.8},null,"Notification"]
[null,null,null,null,null,null,null,"Required Battery AmpHours: ",{"$f":"I42/I43","v":2.2624999999999997},null,"Door Holders",null,null,"Coated"]
[null,null,null,null,null,null,null,"Battery AmpHours Provided: ",null,null,"Doors (Low AC Drop)",null,null,"Uncoated"]
[null,null,null,null,null,null,"            PE-10SN can support batteries up to 55.0Ah",null,null,null,"Unused"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"<-- this is for coated selection, do not change"]
[null,"NAC Circuit Configuration & Voltage Drop",null,null,null,null,{"$f":"IF($F$2<>\"\", $F$2, \"\")","v":""},null,{"$f":"IF($F$10<>\"\", $F$10, \"\")","v":""}]
[]
[null,"NAC 1",null,null,"MAX Circuit Current (amps): ",3,null,"Source Voltage Used (VDC): ",{"$f":"$I$10","v":20.399999999999999},null,"Aux Power"]
[null,null,null,null,null,null,null,null,null,null,"Notification"]
[null,null,"Usage:",null,null,"Description: ",null,null,null,null,"Door Holders"]
[null,null,null,{"$f":"IF(D52=\"Door Holder - Low AC Dropout\", \"* Circuit Standby and Alarm Current will be zero\", \"\")","v":""},null,null,null,null,null,null,"Doors (Low AC Drop)"]
[null,null,"Wire Type",{"$f":"IF(O33=1,N37,N38)","v":"Ohms / 1000ft"},"Length 1-Way","Actual Ohms","Max Load (amps)","Volts @ EOL","Min Volts Req'd",null,"City Tie"]
[null,null,"#16 Solid",{"$f":"T75","v":4.8899999999999997},null,{"$f":"((E55*2)/1000)*D55","v":0},{"$f":"IF(SUM(G59:G68)>SUM(I59:I68),SUM(G59:G68),SUM(I59:I68))","v":0},{"$f":"I50-(G55*F55)","v":20.399999999999999},16,null,"Contact Input",null,null,null,null,null,"these values are from NEC Table 8 for uncoated copper @ 75C"]
[null,null,null,null,null,null,null,null,null,null,"Polarity Reversal",null,null,null,null,null,"K/ft",null,"km"]
[null,"Circuit Devices",null,null,null,"Standby (amps)",null,"Alarm (amps)",null,null,"Unused",null,null,null,null,"12 solid",{"$f":"IF(N47=1,2.01,1.93)","v":1.93},null,{"$f":"IF(N47=1,6.57,6.34)","v":6.34}]
[null,"Qty","Lookup Type","Desc",null,"Each","Total","Each","Total",null,null,null,null,null,null,"14 solid",{"$f":"IF(N47=1,3.19,3.07)","v":3.07},null,{"$f":"IF(N47=1,10.4,10.1)","v":10.1}]
[null,null,null,null,null,{"$f":"IF(D59=\"\", \"\", IF(C59=\"User Defined\", VLOOKUP(D59, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D59, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},{"$f":"IF(F59<>\"\", F59*B59, \"\")","v":""},{"$f":"IF(D59=\"\", \"\", IF(C59=\"User Defined\", VLOOKUP(D59, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D59, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},{"$f":"IF(H59<>\"\", H59*B59, \"\")","v":""},null,"Horn Strobes",null,null,null,null,"14 stranded",{"$f":"IF(N47=1,3.26,3.14)","v":3.14},null,{"$f":"IF(N47=1,10.7,10.3)","v":10.3}]
[null,null,null,null,null,{"$f":"IF(D60=\"\", \"\", IF(C60=\"User Defined\", VLOOKUP(D60, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D60, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},{"$f":"IF(F60<>\"\", F60*B60, \"\")","v":""},{"$f":"IF(D60=\"\", \"\", IF(C60=\"User Defined\", VLOOKUP(D60, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D60, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},{"$f":"IF(H60<>\"\", H60*B60, \"\")","v":""},null,"Strobes",null,null,null,null,"16 solid",{"$f":"IF(N47=1,5.08,4.89)","v":4.8899999999999997},null,{"$f":"IF(N47=1,16.7,16)","v":16}]
[null,null,null,null,null,{"$f":"IF(D61=\"\", \"\", IF(C61=\"User Defined\", VLOOKUP(D61, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D61, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D61=\"\", \"\", IF(C61=\"User Defined\", VLOOKUP(D61, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D61, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},"",null,"Horns",null,null,null,null,"16 stranded",{"$f":"IF(N47=1,5.29,4.99)","v":4.99},null,{"$f":"IF(N47=1,17.3,16.4)","v":16.399999999999999}]
[null,null,null,null,null,{"$f":"IF(D62=\"\", \"\", IF(C62=\"User Defined\", VLOOKUP(D62, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D62, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D62=\"\", \"\", IF(C62=\"User Defined\", VLOOKUP(D62, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D62, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},"",null,"MiniHorns",null,null,null,null,"18 solid",{"$f":"IF(N47=1,8.08,7.77)","v":7.77},null,{"$f":"IF(N47=1,26.5,25.5)","v":25.5}]
[null,null,null,null,null,{"$f":"IF(D63=\"\", \"\", IF(C63=\"User Defined\", VLOOKUP(D63, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D63, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D63=\"\", \"\", IF(C63=\"User Defined\", VLOOKUP(D63, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D63, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},"",null,"Other Notification",null,null,null,null,"18 stranded",{"$f":"IF(N47=1,8.45,7.95)","v":7.95},null,{"$f":"IF(N47=1,27.7,26.1)","v":26.1}]
[null,null,null,"User may add devices",null,null,"",null,"",null,"Aux Pwr SLC Devices"]
[null,null,null,"to these bottom 5 rows",null,null,"",null,"",null,"Conv Detectors"]
[null,null,null,"(No lookup function)",null,null,"",null,"",null,"Other Devices"]
[null,null,null,null,null,null,"",null,"",null,"User Defined"]
[null,null,null,null,null,null,"",null,""]
[null,null,{"$f":"IF(D52=\"Doors (Low AC Drop)\", \"No Standby or Alarm current shown as circuit is used for door holders and will drop out during an AC power loss.\", \"\")","v":""},null,null,"Total Standby:",{"$f":"IF(D52=\"Doors (Low AC Drop)\",0,SUM(G59:G68))","v":0},"Total Alarm: ",{"$f":"IF(D52=\"Doors (Low AC Drop)\",0,SUM(I59:I68))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"#12 Solid",{"$f":"IF(O33=1,Q57,S57)","v":1.93}]
[null,null,null,null,null,null,null,null,null,null,"#14 Solid",{"$f":"IF(O33=1,Q58,S58)","v":3.07}]
[null,"NAC 2",null,null,"MAX Circuit Current (amps): ",3,null,"Source Voltage Used (VDC): ",{"$f":"$I$10","v":20.399999999999999},null,"#14 Stranded",{"$f":"IF(O33=1,Q59,S59)","v":3.14}]
[null,null,null,null,null,null,null,null,null,null,"#16 Solid",{"$f":"IF(O33=1,Q60,S60)","v":4.8899999999999997}]
[null,null,"Usage:",null,null,"Description: ",null,null,null,null,"#16 Stranded",{"$f":"IF(O33=1,Q61,S61)","v":4.99}]
[null,null,null,{"$f":"IF(D74=\"Door Holder - Low AC Dropout\", \"* Circuit Standby and Alarm Current will be zero\", \"\")","v":""},null,null,null,null,null,null,"#18 Solid",{"$f":"IF(O33=1,Q62,S62)","v":7.77},null,null,null,"NAC 1",{"$f":"IF(C55=K70,L70,IF(C55=K71,L71,IF(C55=K72,L72,IF(C55=K73,L73,IF(C55=K74,L74,0)))))","v":4.8899999999999997},{"$f":"IF(C55=K75,L75,IF(C55=K76,L76,IF(C55=K77,L77,IF(C55=K78,L78,0))))","v":0},{"$f":"SUM(Q75:R75)","v":4.8899999999999997},{"$f":"IF(S75=0,\"\",S75)","v":4.8899999999999997}]
[null,null,"Wire Type",{"$f":"IF(O33=1,N37,N38)","v":"Ohms / 1000ft"},"Length 1-Way","Actual Ohms","Max Load (amps)","Volts @ EOL","Min Volts Req'd",null,"#18 Stranded",{"$f":"IF(O33=1,Q63,S63)","v":7.95},null,null,null,"NAC 2",{"$f":"IF(C77=K70,L70,IF(C77=K71,L71,IF(C77=K72,L72,IF(C77=K73,L73,IF(C77=K74,L74,0)))))","v":4.8899999999999997},{"$f":"IF(C102=K74,L74,IF(C102=K75,L75,IF(C102=K76,L76,IF(C102=K77,L77,0))))","v":4},8.89,8.89]
[null,null,"#16 Solid",{"$f":"T76","v":8.89},null,{"$f":"((E77*2)/1000)*D77","v":0},{"$f":"IF(SUM(G81:G90)>SUM(I81:I90),SUM(G81:G90),SUM(I81:I90))","v":0},{"$f":"I72-(G77*F77)","v":20.399999999999999},16,null,"2.5 mm wire",4,null,null,null,"NAC 3",{"$f":"IF(C102=K70,L70,IF(C102=K71,L71,IF(C102=K72,L72,IF(C102=K73,L73,IF(C102=K74,L74,0)))))","v":0},{"$f":"IF(C102=K75,L75,IF(C102=K76,L76,IF(C102=K77,L77,IF(C102=K78,L78,0))))","v":4},4,4]
[null,null,null,null,null,null,null,null,null,null,"1.5 mm wire",3,null,null,null,"NAC 4",{"$f":"IF(C124=K70,L70,IF(C124=K71,L71,IF(C124=K72,L72,IF(C124=K73,L73,IF(C124=K74,L74,0)))))","v":4.8899999999999997},{"$f":"IF(C124=K75,L75,IF(C124=K76,L76,IF(C124=K77,L77,IF(C124=K78,L78,0))))","v":0},4.8899999999999997,4.8899999999999997]
[null,"Circuit Devices",null,null,null,"Standby (amps)",null,"Alarm (amps)",null,null,null,null,null,null,null,"NAC 5",{"$f":"IF(C149=K70,L70,IF(C149=K71,L71,IF(C149=K72,L72,IF(C149=K73,L73,IF(C149=K74,L74,0)))))","v":3.07},{"$f":"IF(C149=K75,L75,IF(C149=K76,L76,IF(C149=K77,L77,IF(C149=K78,L78,0))))","v":0},3.07,3.07]
[null,"Qty","Lookup Type","Desc",null,"Each","Total","Each","Total",null,null,null,null,null,null,"NAC 6",{"$f":"IF(C171=K70,L70,IF(C171=K71,L71,IF(C171=K72,L72,IF(C171=K73,L73,IF(C171=K74,L74,0)))))","v":3.07},{"$f":"IF(C171=K75,L75,IF(C171=K76,L76,IF(C171=K77,L77,IF(C171=K78,L78,0))))","v":0},3.07,3.07]
[null,null,"Other Devices",null,null,{"$f":"IF(D81=\"\", \"\", IF(C81=\"User Defined\", VLOOKUP(D81, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D81, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},{"$f":"IF(F81<>\"\", F81*B81, \"\")","v":""},{"$f":"IF(D81=\"\", \"\", IF(C81=\"User Defined\", VLOOKUP(D81, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D81, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},{"$f":"IF(H81<>\"\", H81*B81, \"\")","v":""},null,null,null,null,null,null,"AUX",{"$f":"IF(C198=K70,L70,IF(C198=K71,L71,IF(C198=K72,L72,IF(C198=K73,L73,IF(C198=K74,L74,0)))))","v":0},{"$f":"IF(C198=K75,L75,IF(C198=K76,L76,IF(C198=K77,L77,IF(C198=K78,L78,0))))","v":7.77},7.77,7.77]
[null,null,null,null,null,{"$f":"IF(D82=\"\", \"\", IF(C82=\"User Defined\", VLOOKUP(D82, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D82, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},{"$f":"IF(F82<>\"\", F82*B82, \"\")","v":""},{"$f":"IF(D82=\"\", \"\", IF(C82=\"User Defined\", VLOOKUP(D82, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D82, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},{"$f":"IF(H82<>\"\", H82*B82, \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(D83=\"\", \"\", IF(C83=\"User Defined\", VLOOKUP(D83, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D83, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D83=\"\", \"\", IF(C83=\"User Defined\", VLOOKUP(D83, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D83, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D84=\"\", \"\", IF(C84=\"User Defined\", VLOOKUP(D84, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D84, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D84=\"\", \"\", IF(C84=\"User Defined\", VLOOKUP(D84, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D84, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D85=\"\", \"\", IF(C85=\"User Defined\", VLOOKUP(D85, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D85, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D85=\"\", \"\", IF(C85=\"User Defined\", VLOOKUP(D85, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D85, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,"User may add devices",null,null,"",null,""]
[null,null,null,"to these bottom 5 rows",null,null,"",null,""]
[null,null,null,"(No lookup function)",null,null,"",null,""]
[null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,"",null,""]
[null,null,{"$f":"IF(D74=\"Doors (Low AC Drop)\", \"No Standby or Alarm current shown as circuit is used for door holders and will drop out during an AC power loss.\", \"\")","v":""},null,null,"Total Standby:",{"$f":"IF(D74=\"Doors (Low AC Drop)\",0,SUM(G81:G90))","v":0},"Total Alarm: ",{"$f":"IF(D74=\"Doors (Low AC Drop)\",0,SUM(I81:I90))","v":0}]
[]
[]
[]
[null,"NAC Circuit Configuration & Voltage Drop (cont'd)",null,null,null,null,{"$f":"IF($F$2<>\"\", $F$2, \"\")","v":""},null,{"$f":"IF($F$10<>\"\", $F$10, \"\")","v":""}]
[]
[null,"NAC 3",null,null,"MAX Circuit Current (amps): ",3,null,"Source Voltage Used (VDC): ",{"$f":"$I$10","v":20.399999999999999}]
[]
[null,null,"Usage:",null,null,"Description: "]
[null,null,null,{"$f":"IF(D99=\"Door Holder - Low AC Dropout\", \"* Circuit Standby and Alarm Current will be zero\", \"\")","v":""}]
[null,null,"Wire Type",{"$f":"IF(O33=1,N37,N38)","v":"Ohms / 1000ft"},"Length 1-Way","Actual Ohms","Max Load (amps)","Volts @ EOL","Min Volts Req'd"]
[null,null,"2.5 mm wire",{"$f":"T77","v":4},null,{"$f":"((E102*2)/1000)*D102","v":0},{"$f":"IF(SUM(G106:G115)>SUM(I106:I115),SUM(G106:G115),SUM(I106:I115))","v":0},{"$f":"I97-(G102*F102)","v":20.399999999999999},16]
[]
[null,"Circuit Devices",null,null,null,"Standby (amps)",null,"Alarm (amps)"]
[null,"Qty","Lookup Type","Desc",null,"Each","Total","Each","Total"]
[null,null,null,null,null,{"$f":"IF(D106=\"\", \"\", IF(C106=\"User Defined\", VLOOKUP(D106, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D106, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},{"$f":"IF(F106<>\"\", F106*B106, \"\")","v":""},{"$f":"IF(D106=\"\", \"\", IF(C106=\"User Defined\", VLOOKUP(D106, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D106, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},{"$f":"IF(H106<>\"\", H106*B106, \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(D107=\"\", \"\", IF(C107=\"User Defined\", VLOOKUP(D107, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D107, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},{"$f":"IF(F107<>\"\", F107*B107, \"\")","v":""},{"$f":"IF(D107=\"\", \"\", IF(C107=\"User Defined\", VLOOKUP(D107, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D107, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},{"$f":"IF(H107<>\"\", H107*B107, \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(D108=\"\", \"\", IF(C108=\"User Defined\", VLOOKUP(D108, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D108, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D108=\"\", \"\", IF(C108=\"User Defined\", VLOOKUP(D108, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D108, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D109=\"\", \"\", IF(C109=\"User Defined\", VLOOKUP(D109, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D109, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D109=\"\", \"\", IF(C109=\"User Defined\", VLOOKUP(D109, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D109, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D110=\"\", \"\", IF(C110=\"User Defined\", VLOOKUP(D110, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D110, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D110=\"\", \"\", IF(C110=\"User Defined\", VLOOKUP(D110, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D110, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,"User may add devices",null,null,"",null,""]
[null,null,null,"to these bottom 5 rows",null,null,"",null,""]
[null,null,null,"(No lookup function)",null,null,"",null,""]
[null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,"",null,""]
[null,null,{"$f":"IF(D99=\"Doors (Low AC Drop)\", \"No Standby or Alarm current shown as circuit is used for door holders and will drop out during an AC power loss.\", \"\")","v":""},null,null,"Total Standby:",{"$f":"IF(D99=\"Doors (Low AC Drop)\",0,SUM(G106:G115))","v":0},"Total Alarm: ",{"$f":"IF(D99=\"Doors (Low AC Drop)\",0,SUM(I106:I115))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,1.6]
[null,null,null,null,null,null,null,null,null,null,null,2.5]
[null,"NAC 4",null,null,"MAX Circuit Current (amps): ",3,null,"Source Voltage Used (VDC): ",{"$f":"$I$10","v":20.399999999999999},null,null,2.5]
[null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,"Usage:",null,null,"Description: ",null,null,null,null,null,4]
[null,null,null,{"$f":"IF(D121=\"Door Holder - Low AC Dropout\", \"* Circuit Standby and Alarm Current will be zero\", \"\")","v":""},null,null,null,null,null,null,null,6.4]
[null,null,"Wire Type",{"$f":"IF(O33=1,N37,N38)","v":"Ohms / 1000ft"},"Length 1-Way","Actual Ohms","Max Load (amps)","Volts @ EOL","Min Volts Req'd",null,null,6.4]
[null,null,"#16 Solid",{"$f":"T78","v":4.8899999999999997},null,{"$f":"((E124*2)/1000)*D124","v":0},{"$f":"IF(SUM(G128:G137)>SUM(I128:I137),SUM(G128:G137),SUM(I128:I137))","v":0},{"$f":"I119-(G124*F124)","v":20.399999999999999},16]
[]
[null,"Circuit Devices",null,null,null,"Standby (amps)",null,"Alarm (amps)"]
[null,"Qty","Lookup Type","Desc",null,"Each","Total","Each","Total"]
[null,null,null,null,null,{"$f":"IF(D128=\"\", \"\", IF(C128=\"User Defined\", VLOOKUP(D128, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D128, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},{"$f":"IF(F128<>\"\", F128*B128, \"\")","v":""},{"$f":"IF(D128=\"\", \"\", IF(C128=\"User Defined\", VLOOKUP(D128, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D128, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},{"$f":"IF(H128<>\"\", H128*B128, \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(D129=\"\", \"\", IF(C129=\"User Defined\", VLOOKUP(D129, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D129, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},{"$f":"IF(F129<>\"\", F129*B129, \"\")","v":""},{"$f":"IF(D129=\"\", \"\", IF(C129=\"User Defined\", VLOOKUP(D129, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D129, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},{"$f":"IF(H129<>\"\", H129*B129, \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(D130=\"\", \"\", IF(C130=\"User Defined\", VLOOKUP(D130, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D130, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D130=\"\", \"\", IF(C130=\"User Defined\", VLOOKUP(D130, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D130, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D131=\"\", \"\", IF(C131=\"User Defined\", VLOOKUP(D131, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D131, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D131=\"\", \"\", IF(C131=\"User Defined\", VLOOKUP(D131, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D131, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D132=\"\", \"\", IF(C132=\"User Defined\", VLOOKUP(D132, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D132, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D132=\"\", \"\", IF(C132=\"User Defined\", VLOOKUP(D132, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D132, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,"User may add devices",null,null,"",null,""]
[null,null,null,"to these bottom 5 rows",null,null,"",null,""]
[null,null,null,"(No lookup function)",null,null,"",null,""]
[null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,"",null,""]
[null,null,{"$f":"IF(D121=\"Doors (Low AC Drop)\", \"No Standby or Alarm current shown as circuit is used for door holders and will drop out during an AC power loss.\", \"\")","v":""},null,null,"Total Standby:",{"$f":"IF(D121=\"Doors (Low AC Drop)\",0,SUM(G128:G137))","v":0},"Total Alarm: ",{"$f":"IF(D121=\"Doors (Low AC Drop)\",0,SUM(I128:I137))","v":0}]
[]
[]
[]
[null,"NAC Circuit Configuration & Voltage Drop (cont'd)",null,null,null,null,{"$f":"IF($F$2<>\"\", $F$2, \"\")","v":""},null,{"$f":"IF($F$10<>\"\", $F$10, \"\")","v":""}]
[]
[null,"NAC 5",null,null,"MAX Circuit Current (amps): ",3,null,"Source Voltage Used (VDC): ",{"$f":"$I$10","v":20.399999999999999}]
[]
[null,null,"Usage:",null,null,"Description: "]
[null,null,null,{"$f":"IF(D146=\"Door Holder - Low AC Dropout\", \"* Circuit Standby and Alarm Current will be zero\", \"\")","v":""}]
[null,null,"Wire Type",{"$f":"IF(O33=1,N37,N38)","v":"Ohms / 1000ft"},"Length 1-Way","Actual Ohms","Max Load (amps)","Volts @ EOL","Min Volts Req'd"]
[null,null,"#14 Solid",{"$f":"T79","v":3.07},null,{"$f":"((E149*2)/1000)*D149","v":0},{"$f":"IF(SUM(G153:G162)>SUM(I153:I162),SUM(G153:G162),SUM(I153:I162))","v":0},{"$f":"I144-(G149*F149)","v":20.399999999999999},16]
[]
[null,"Circuit Devices",null,null,null,"Standby (amps)",null,"Alarm (amps)"]
[null,"Qty","Lookup Type","Desc",null,"Each","Total","Each","Total"]
[null,null,null,null,null,{"$f":"IF(D153=\"\", \"\", IF(C153=\"User Defined\", VLOOKUP(D153, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D153, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},{"$f":"IF(F153<>\"\", F153*B153, \"\")","v":""},{"$f":"IF(D153=\"\", \"\", IF(C153=\"User Defined\", VLOOKUP(D153, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D153, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},{"$f":"IF(H153<>\"\", H153*B153, \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(D154=\"\", \"\", IF(C154=\"User Defined\", VLOOKUP(D154, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D154, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},{"$f":"IF(F154<>\"\", F154*B154, \"\")","v":""},{"$f":"IF(D154=\"\", \"\", IF(C154=\"User Defined\", VLOOKUP(D154, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D154, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},{"$f":"IF(H154<>\"\", H154*B154, \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(D155=\"\", \"\", IF(C155=\"User Defined\", VLOOKUP(D155, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D155, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D155=\"\", \"\", IF(C155=\"User Defined\", VLOOKUP(D155, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D155, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D156=\"\", \"\", IF(C156=\"User Defined\", VLOOKUP(D156, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D156, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D156=\"\", \"\", IF(C156=\"User Defined\", VLOOKUP(D156, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D156, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D157=\"\", \"\", IF(C157=\"User Defined\", VLOOKUP(D157, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D157, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D157=\"\", \"\", IF(C157=\"User Defined\", VLOOKUP(D157, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D157, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,"User may add devices",null,null,"",null,""]
[null,null,null,"to these bottom 5 rows",null,null,"",null,""]
[null,null,null,"(No lookup function)",null,null,"",null,""]
[null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,"",null,""]
[null,null,{"$f":"IF(D146=\"Doors (Low AC Drop)\", \"No Standby or Alarm current shown as circuit is used for door holders and will drop out during an AC power loss.\", \"\")","v":""},null,null,"Total Standby:",{"$f":"IF(D146=\"Doors (Low AC Drop)\",0,SUM(G153:G162))","v":0},"Total Alarm: ",{"$f":"IF(D146=\"Doors (Low AC Drop)\",0,SUM(I153:I162))","v":0}]
[]
[]
[null,"NAC 6",null,null,"MAX Circuit Current (amps): ",3,null,"Source Voltage Used (VDC): ",{"$f":"$I$10","v":20.399999999999999}]
[]
[null,null,"Usage:",null,null,"Description: "]
[null,null,null,{"$f":"IF(D168=\"Door Holder - Low AC Dropout\", \"* Circuit Standby and Alarm Current will be zero\", \"\")","v":""}]
[null,null,"Wire Type",{"$f":"IF(O33=1,N37,N38)","v":"Ohms / 1000ft"},"Length 1-Way","Actual Ohms","Max Load (amps)","Volts @ EOL","Min Volts Req'd"]
[null,null,"#14 Solid",{"$f":"T80","v":3.07},null,{"$f":"((E171*2)/1000)*D171","v":0},{"$f":"IF(SUM(G175:G184)>SUM(I175:I184),SUM(G175:G184),SUM(I175:I184))","v":0},{"$f":"I166-(G171*F171)","v":20.399999999999999},16]
[]
[null,"Circuit Devices",null,null,null,"Standby (amps)",null,"Alarm (amps)"]
[null,"Qty","Lookup Type","Desc",null,"Each","Total","Each","Total"]
[null,null,null,null,null,{"$f":"IF(D175=\"\", \"\", IF(C175=\"User Defined\", VLOOKUP(D175, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D175, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},{"$f":"IF(F175<>\"\", F175*B175, \"\")","v":""},{"$f":"IF(D175=\"\", \"\", IF(C175=\"User Defined\", VLOOKUP(D175, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D175, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},{"$f":"IF(H175<>\"\", H175*B175, \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(D176=\"\", \"\", IF(C176=\"User Defined\", VLOOKUP(D176, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D176, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},{"$f":"IF(F176<>\"\", F176*B176, \"\")","v":""},{"$f":"IF(D176=\"\", \"\", IF(C176=\"User Defined\", VLOOKUP(D176, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D176, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},{"$f":"IF(H176<>\"\", H176*B176, \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(D177=\"\", \"\", IF(C177=\"User Defined\", VLOOKUP(D177, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D177, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D177=\"\", \"\", IF(C177=\"User Defined\", VLOOKUP(D177, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D177, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D178=\"\", \"\", IF(C178=\"User Defined\", VLOOKUP(D178, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D178, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D178=\"\", \"\", IF(C178=\"User Defined\", VLOOKUP(D178, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D178, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D179=\"\", \"\", IF(C179=\"User Defined\", VLOOKUP(D179, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D179, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D179=\"\", \"\", IF(C179=\"User Defined\", VLOOKUP(D179, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D179, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,"User may add devices ",null,null,"",null,""]
[null,null,null,"to these bottom 5 rows",null,null,"",null,""]
[null,null,null,"(No lookup function)",null,null,"",null,""]
[null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,"",null,""]
[null,null,{"$f":"IF(D168=\"Doors (Low AC Drop)\", \"No Standby or Alarm current shown as circuit is used for door holders and will drop out during an AC power loss.\", \"\")","v":""},null,null,"Total Standby:",{"$f":"IF(D168=\"Doors (Low AC Drop)\",0,SUM(G175:G184))","v":0},"Total Alarm: ",{"$f":"IF(D168=\"Doors (Low AC Drop)\",0,SUM(I175:I184))","v":0}]
[]
[]
[]
[]
[]
[null,"NAC Circuit Configuration & Voltage Drop (cont'd)",null,null,null,null,{"$f":"IF($F$2<>\"\", $F$2, \"\")","v":""},null,{"$f":"IF($F$10<>\"\", $F$10, \"\")","v":""}]
[]
[null,"AUX Power",null,null,"MAX Circuit Current (amps): ",3,null,"Source Voltage Used (VDC): ",{"$f":"$I$10","v":20.399999999999999}]
[]
[null,null,"Usage:",null,null,"Description: "]
[null,null,null,{"$f":"IF(D195=\"Door Holder - Low AC Dropout\", \"* Circuit Standby and Alarm Current will be zero\", \"\")","v":""}]
[null,null,"Wire Type",{"$f":"IF(O33=1,N37,N38)","v":"Ohms / 1000ft"},"Length 1-Way","Actual Ohms","Max Load (amps)","Volts @ Last Device","Min Volts Req'd"]
[null,null,"#18 Solid",{"$f":"T81","v":7.77},null,{"$f":"((E198*2)/1000)*D198","v":0},{"$f":"IF(SUM(G202:G211)>SUM(I202:I211),SUM(G202:G211),SUM(I202:I211))","v":0},{"$f":"I193-(G198*F198)","v":20.399999999999999},16]
[null,null,null,null,null,null,null,{"$f":"IF(SUM(G202:G211)>SUM(I202:I211),SUM(G202:G211),SUM(I202:I211))","v":0}]
[null,"Circuit Devices",null,null,null,"Standby (amps)",null,"Alarm (amps)"]
[null,"Qty","Lookup Type","Desc",null,"Each","Total","Each","Total"]
[null,null,null,null,null,{"$f":"IF(D202=\"\", \"\", IF(C202=\"User Defined\", VLOOKUP(D202, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D202, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},{"$f":"IF(F202<>\"\", F202*B202, \"\")","v":""},{"$f":"IF(D202=\"\", \"\", IF(C202=\"User Defined\", VLOOKUP(D202, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D202, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},{"$f":"IF(H202<>\"\", H202*B202, \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(D203=\"\", \"\", IF(C203=\"User Defined\", VLOOKUP(D203, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D203, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},{"$f":"IF(F203<>\"\", F203*B203, \"\")","v":""},{"$f":"IF(D203=\"\", \"\", IF(C203=\"User Defined\", VLOOKUP(D203, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D203, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},{"$f":"IF(H203<>\"\", H203*B203, \"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(D204=\"\", \"\", IF(C204=\"User Defined\", VLOOKUP(D204, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D204, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D204=\"\", \"\", IF(C204=\"User Defined\", VLOOKUP(D204, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D204, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D205=\"\", \"\", IF(C205=\"User Defined\", VLOOKUP(D205, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D205, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D205=\"\", \"\", IF(C205=\"User Defined\", VLOOKUP(D205, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D205, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,null,null,{"$f":"IF(D206=\"\", \"\", IF(C206=\"User Defined\", VLOOKUP(D206, 'User Defined'!$B$4:$D$103, 2, FALSE), VLOOKUP(D206, 'Device Database'!$B$4:$D$404, 2, FALSE)))","v":""},"",{"$f":"IF(D206=\"\", \"\", IF(C206=\"User Defined\", VLOOKUP(D206, 'User Defined'!$B$4:$D$103, 3, FALSE), VLOOKUP(D206, 'Device Database'!$B$4:$D$404, 3, FALSE)))","v":""},""]
[null,null,null,"User may add devices",null,null,"",null,""]
[null,null,null,"to these bottom 5 rows",null,null,"",null,""]
[null,null,null,"(No lookup function)",null,null,"",null,""]
[null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,"",null,""]
[null,null,{"$f":"IF(D195=\"Doors (Low AC Drop)\", \"No Standby or Alarm current shown as circuit is used for door holders and will drop out during an AC power loss.\", \"\")","v":""},null,null,"Total Standby:",{"$f":"IF(D195=\"Doors (Low AC Drop)\",0,SUM(G202:G211))","v":0},"Total Alarm: ",{"$f":"IF(D195=\"Doors (Low AC Drop)\",0,SUM(I202:I211))","v":0}]
[]
[]
["Important Notes:"]
[" 1) Ensure to include the devices connected to the SOM output circuit !"]
[" 2) Ensure to include the Remote Test Devices connected to the DH-98AR, DH-99AR, or DH-100 !"]
[null,null,"V1.08"]

{"sheet":"Device Database","index":1,"n_rows":404,"n_cols":4,"rows_kept":404,"cut":false,"hidden":true,"merged":[[390,1,391,3],[392,1,392,3],[367,1,367,3],[368,1,368,3],[0,1,0,3],[1,1,1,3],[186,1,186,3],[187,1,187,3],[357,1,358,3],[359,1,359,3],[378,1,379,3],[380,1,380,3],[331,1,332,3],[333,1,333,3],[346,1,347,3],[348,1,348,3]]}
[null,"Horn Strobes"]
[null,"(Current draws listed are 2400/3000HZ Temporal audible setting)"]
[null,"Description","Standby","Alarm"]
[null,"Hochiki HCC24, 15cd, Horn/Strobe",0,0.14299999999999999]
[null,"Hochiki HCC24, 30cd, Horn/Strobe",0,0.14299999999999999]
[null,"Hochiki HCC24, 75cd, Horn/Strobe",0,0.223]
[null,"Hochiki HCC24, 95cd, Horn/Strobe",0,0.24299999999999999]
[null,"Hochiki HCC24, 115cd, Horn/Strobe",0,0.313]
[null,"Hochiki HCC24, 150cd, Horn/Strobe",0,0.34399999999999997]
[null,"Hochiki HEC3-24, 15cd, Horn/Strobe",0,7.0000000000000007E-2]
[null,"Hochiki HEC3-24, 30cd, Horn/Strobe",0,8.7999999999999995E-2]
[null,"Hochiki HEC3-24, 60cd, Horn/Strobe",0,0.125]
[null,"Hochiki HEC3-24, 75cd, Horn/Strobe",0,0.14399999999999999]
[null,"Hochiki HEC3-24, 110cd, Horn/Strobe",0,0.185]
[null,"Hochiki HEC24, 15/75cd, Horn/Strobe",0,9.4E-2]
[null,"Hochiki HEC24, 177cd, Horn/Strobe",0,0.24]
[null,"Hochiki HHSLF, 15cd Horn/Strobe Temporal 3 520Hz",0,0.124]
[null,"Hochiki HHSLF, 15cd Horn/Strobe Temporal 4 520Hz",0,0.19500000000000001]
[null,"Hochiki HHSLF, 110cd Horn/Strobe Temporal 3 520Hz",0,0.28000000000000003]
[null,"Hochiki HHSLF, 110cd Horn/Strobe Temporal 4 520Hz",0,0.38400000000000001]
[null,"Hochiki HHSLF, 177cd Horn/Strobe Temporal 3 520Hz",0,0.39300000000000002]
[null,"Hochiki HHSLF, 177cd Horn/Strobe Temporal 4 520Hz",0,0.42699999999999999]
[null,"Hochiki WHEC24, 75cd, Horn/Strobe",0,0.20799999999999999]
[null,"Hochiki HSSPK24CLP, 15cd, Speaker/Strobe",0,0.12]
[null,"Hochiki HSSPK24CLP, 30cd, Speaker/Strobe",0,0.12]
[null,"Hochiki HSSPK24CLP, 75cd, Speaker/Strobe",0,0.27200000000000002]
[null,"Hochiki HSSPK24CLP, 95cd Speaker/Strobe",0,0.318]
[null,"Hochiki HSSPK24CLP, 115cd Speaker/Strobe",0,0.36]
[null,"Hochiki HSSPK24WLP, 15cd Speaker/Strobe",0,7.8E-2]
[null,"Hochiki HSSPK24WLP, 30cd Speaker/Strobe",0,9.6000000000000002E-2]
[null,"Hochiki HSSPK24WLP, 60cd Speaker/Strobe",0,0.13700000000000001]
[null,"Hochiki HSSPK24WLP, 75cd Speaker/Strobe",0,0.18]
[null,"Hochiki HSSPK24WLP, 110cd Speaker/Strobe",0,0.224]
[null,"Hochiki HSSPK24WLP, 15/75cd Speaker/Strobe",0,9.6000000000000002E-2]
[null,"Gentex GCC-24, 115cd, Hi db",0,0.313]
[null,"Gentex GCC-24, 150cd, Hi db",0,0.34399999999999997]
[null,"Gentex GCC-24, 15cd, Hi db",0,0.14299999999999999]
[null,"Gentex GCC-24, 30cd, Hi db",0,0.14299999999999999]
[null,"Gentex GCC-24, 75cd, Hi db",0,0.223]
[null,"Gentex GCC-24. 95cd, Hi db",0,0.24299999999999999]
[null,"Gentex GCCA24, GCCB24, GCCG24, 115cd, Hi db",0,0.23499999999999999]
[null,"Gentex GCCA24, GCCB24, GCCG24, 15cd, Hi db",0,0.14699999999999999]
[null,"Gentex GCCA24, GCCB24, GCCG24, 30cd, Hi db",0,0.14699999999999999]
[null,"Gentex GCCA24, GCCB24, GCCG24, 75cd, Hi db",0,0.16200000000000001]
[null,"Gentex GCCA24, GCCB24, GCCG24, 95cd, Hi db",0,0.22800000000000001]
[null,"Gentex GCCR24, 115cd, Hi db",0,0.33600000000000002]
[null,"Gentex GCCR24, 15cd, Hi db",0,0.14699999999999999]
[null,"Gentex GCCR24, 30cd, Hi db",0,0.14699999999999999]
[null,"Gentex GCCR24, 75cd, Hi db",0,0.23499999999999999]
[null,"Gentex GCCR24, 95cd, Hi db",0,0.30599999999999999]
[null,"Gentex GEC-24-177, 177cd, Hi db",0,0.24099999999999999]
[null,"Gentex GEC3-24, 110cd, Hi db",0,0.189]
[null,"Gentex GEC3-24, 15cd, Hi db",0,7.0000000000000007E-2]
[null,"Gentex GEC3-24, 30cd, Hi db",0,8.5999999999999993E-2]
[null,"Gentex GEC3-24, 60cd, Hi db",0,0.125]
[null,"Gentex GEC3-24, 75cd, Hi db",0,0.14399999999999999]
[null,"Gentex GECA24, 110cd, Hi db",0,0.20599999999999999]
[null,"Gentex GECA24, 15cd, Hi db",0,0.75]
[null,"Gentex GECA24, 30cd, Hi db",0,0.92]
[null,"Gentex GECA24, 60cd, Hi db",0,0.14099999999999999]
[null,"Gentex GECA24, 75cd, Hi db",0,0.17299999999999999]
[null,"Gentex GECB24, GECG24, GECR24, 110cd, Hi db",0,0.33800000000000002]
[null,"Gentex GECB24, GECG24, GECR24, 15cd, Hi db",0,0.13300000000000001]
[null,"Gentex GECB24, GECG24, GECR24, 30cd, Hi db",0,0.158]
[null,"Gentex GECB24, GECG24, GECR24, 60cd, Hi db",0,0.23100000000000001]
[null,"Gentex GECB24, GECG24, GECR24, 75cd, Hi db",0,0.27100000000000002]
[null,"Gentex WGEC24-75, 75cd, Hi db",0,0.19800000000000001]
[null,"Gentex WGECA24, 75cd, Hi db",0,0.19800000000000001]
[null,"Gentex WGECB24,WGECG24,WGECR24, 75cd, Hi db",0,0.192]
[null,"Potter CCHS-24A,CCHS-24B,CCHS-24G, 115cd, Hi db",0,0.23499999999999999]
[null,"Potter CCHS-24A,CCHS-24B,CCHS-24G, 15cd, Hi db",0,0.14699999999999999]
[null,"Potter CCHS-24A,CCHS-24B,CCHS-24G, 30cd, Hi db",0,0.14699999999999999]
[null,"Potter CCHS-24A,CCHS-24B,CCHS-24G, 75cd, Hi db",0,0.16200000000000001]
[null,"Potter CCHS-24A,CCHS-24B,CCHS-24G, 95cd, Hi db",0,0.22800000000000001]
[null,"Potter CCHS-24R, 115cd, Hi db",0,0.33600000000000002]
[null,"Potter CCHS-24R, 15cd, Hi db",0,0.14699999999999999]
[null,"Potter CCHS-24R, 30cd, Hi db",0,0.14699999999999999]
[null,"Potter CCHS-24R, 75cd, Hi db",0,0.23499999999999999]
[null,"Potter CCHS-24R, 95cd, Hi db",0,0.30599999999999999]
[null,"Potter CHS-24, 115cd, Hi db",0,0.313]
[null,"Potter CHS-24, 150cd, Hi db",0,0.34399999999999997]
[null,"Potter CHS-24, 15cd, Hi db",0,0.14299999999999999]
[null,"Potter CHS-24, 30cd, Hi db",0,0.14299999999999999]
[null,"Potter CHS-24, 75cd, Hi db",0,0.223]
[null,"Potter CHS-24. 95cd, Hi db",0,0.24299999999999999]
[null,"Potter CHS-24A, 110cd, Hi db",0,0.20599999999999999]
[null,"Potter CHS-24A, 15cd, Hi db",0,0.75]
[null,"Potter CHS-24A, 30cd, Hi db",0,0.92]
[null,"Potter CHS-24A, 60cd, Hi db",0,0.14099999999999999]
[null,"Potter CHS-24A, 75cd, Hi db",0,0.17299999999999999]
[null,"Potter CHS-24A-WP,CHSLP-24A-WP 75cd, Hi db",0,0.19800000000000001]
[null,"Potter CHS-24B,CHS-24G,CHS-24R, 110cd, Hi db",0,0.33800000000000002]
[null,"Potter CHS-24B,CHS-24G,CHS-24R, 15cd, Hi db",0,0.13300000000000001]
[null,"Potter CHS-24B,CHS-24G,CHS-24R, 30cd, Hi db",0,0.158]
[null,"Potter CHS-24B,CHS-24G,CHS-24R, 60cd, Hi db",0,0.23100000000000001]
[null,"Potter CHS-24B,CHS-24G,CHS-24R, 75cd, Hi db",0,0.27100000000000002]
[null,"Potter CHS-24B-WP,CHS-24G-WP,CSH-24R-WP, 75cd, Hi db",0,0.192]
[null,"Potter CHSLP-24B-WP,CHSLP-24G-WP,CHSLP-24R-WP, 75cd, Hi db",0,0.192]
[null,"Potter HS-24, 110cd, Hi db",0,0.189]
[null,"Potter HS-24, 15cd, Hi db",0,7.0000000000000007E-2]
[null,"Potter HS-24, 30cd, Hi db",0,8.5999999999999993E-2]
[null,"Potter HS-24, 60cd, Hi db",0,0.125]
[null,"Potter HS-24, 75cd, Hi db",0,0.14399999999999999]
[null,"Potter HS24-177,177cd, Hi db",0,0.24099999999999999]
[null,"Potter HS-24-WP, HSLP-24-WP 75cd, Hi db",0,0.19800000000000001]
[null,"Potter SH-1224  110cd, Hi db",0,0.28299999999999997]
[null,"Potter SH-1224  110cd, Lo db",0,0.214]
[null,"Potter SH-1224  110cd, Med db",0,0.22600000000000001]
[null,"Potter SH-1224  15cd, Hi db",0,0.14899999999999999]
[null,"Potter SH-1224  15cd, Lo db",0,0.08]
[null,"Potter SH-1224  15cd, Med db",0,9.1999999999999998E-2]
[null,"Potter SH-1224  35cd, Hi db",0,0.189]
[null,"Potter SH-1224  35cd, Lo db",0,0.12]
[null,"Potter SH-1224  35cd, Med db",0,0.13200000000000001]
[null,"Potter SH-1224  60cd, Hi db",0,0.218]
[null,"Potter SH-1224  60cd, Lo db",0,0.14899999999999999]
[null,"Potter SH-1224  60cd, Med db",0,0.161]
[null,"Potter SH-1224  75cd, Hi db",0,0.23300000000000001]
[null,"Potter SH-1224  75cd, Lo db",0,0.16400000000000001]
[null,"Potter SH-1224  75cd, Med db",0,0.17599999999999999]
[null,"Potter SH-1224  95cd, Hi db",0,0.26400000000000001]
[null,"Potter SH-1224  95cd, Lo db",0,0.19500000000000001]
[null,"Potter SH-1224  95cd, Med db",0,0.20699999999999999]
[null,"Potter SH-1224WP 110cd, Hi db",0,0.42799999999999999]
[null,"Potter SH-1224WP 110cd, Lo db",0,0.307]
[null,"Potter SH-1224WP 110cd, Med db",0,0.33500000000000002]
[null,"Potter SH-1224WP 15cd, Hi db",0,0.30299999999999999]
[null,"Potter SH-1224WP 15cd, Lo db",0,0.182]
[null,"Potter SH-1224WP 15cd, Med db",0,0.21]
[null,"Potter SH-1224WP 35cd, Hi db",0,0.33800000000000002]
[null,"Potter SH-1224WP 35cd, Lo db",0,0.217]
[null,"Potter SH-1224WP 35cd, Med db",0,0.245]
[null,"Potter SH-1224WP 60cd, Hi db",0,0.374]
[null,"Potter SH-1224WP 60cd, Lo db",0,0.253]
[null,"Potter SH-1224WP 60cd, Med db",0,0.28100000000000003]
[null,"Potter SH-1224WP 75cd, Hi db",0,0.39300000000000002]
[null,"Potter SH-1224WP 75cd, Lo db",0,0.27200000000000002]
[null,"Potter SH-1224WP 75cd, Med db",0,0.3]
[null,"Potter SH-1224WP 95cd, Hi db",0,0.41399999999999998]
[null,"Potter SH-1224WP 95cd, Lo db",0,0.29299999999999998]
[null,"Potter SH-1224WP 95cd, Med db",0,0.32100000000000001]
[null,"Potter SH24C-177, 177cd, Hi db",0,0.41899999999999998]
[null,"Potter SH24C-177, 177cd, Lo db",0,0.40200000000000002]
[null,"Potter SH24C-3075110 110cd, Hi db",0,0.27300000000000002]
[null,"Potter SH24C-3075110 110cd, Lo db",0,0.25600000000000001]
[null,"Potter SH24C-3075110 30cd, Hi db",0,0.16]
[null,"Potter SH24C-3075110 30cd, Lo db",0,0.13800000000000001]
[null,"Potter SH24C-3075110 75cd, Hi db",0,0.218]
[null,"Potter SH24C-3075110 75cd, Lo db",0,0.20100000000000001]
[null,"Potter SH-24H  110cd, Hi db",0,0.248]
[null,"Potter SH-24H  110cd, Lo db",0,0.17899999999999999]
[null,"Potter SH-24H  110cd, Med db",0,0.191]
[null,"Potter SH-24H  135cd, Hi db",0,0.26500000000000001]
[null,"Potter SH-24H  135cd, Lo db",0,0.19600000000000001]
[null,"Potter SH-24H  135cd, Med db",0,0.20799999999999999]
[null,"Potter SH-24H  150cd, Hi db",0,0.27700000000000002]
[null,"Potter SH-24H  150cd, Lo db",0,0.20799999999999999]
[null,"Potter SH-24H  150cd, Med db",0,0.22]
[null,"Potter SH-24H  177cd, Hi db",0,0.30499999999999999]
[null,"Potter SH-24H  177cd, Lo db",0,0.23599999999999999]
[null,"Potter SH-24H  177cd, Med db",0,0.248]
[null,"Potter SH-24H  185cd, Hi db",0,0.313]
[null,"Potter SH-24H  185cd, Lo db",0,0.24399999999999999]
[null,"Potter SH-24H  185cd, Med db",0,0.25600000000000001]
[null,"Potter SH-24H  95cd, Hi db",0,0.23799999999999999]
[null,"Potter SH-24H  95cd, Lo db",0,0.16900000000000001]
[null,"Potter SH-24H  95cd, Med db",0,0.18099999999999999]
[null,"Potter SH-24H-WP  110cd, Hi db",0,0.248]
[null,"Potter SH-24H-WP  110cd, Lo db",0,0.17899999999999999]
[null,"Potter SH-24H-WP  110cd, Med db",0,0.191]
[null,"Potter SH-24H-WP  135cd, Hi db",0,0.26500000000000001]
[null,"Potter SH-24H-WP  135cd, Lo db",0,0.19600000000000001]
[null,"Potter SH-24H-WP  135cd, Med db",0,0.20799999999999999]
[null,"Potter SH-24H-WP  150cd, Hi db",0,0.27700000000000002]
[null,"Potter SH-24H-WP  150cd, Lo db",0,0.20799999999999999]
[null,"Potter SH-24H-WP  150cd, Med db",0,0.22]
[null,"Potter SH-24H-WP  177cd, Hi db",0,0.30499999999999999]
[null,"Potter SH-24H-WP  177cd, Lo db",0,0.23599999999999999]
[null,"Potter SH-24H-WP  177cd, Med db",0,0.248]
[null,"Potter SH-24H-WP  185cd, Hi db",0,0.313]
[null,"Potter SH-24H-WP  185cd, Lo db",0,0.24399999999999999]
[null,"Potter SH-24H-WP  185cd, Med db",0,0.25600000000000001]
[null,"Potter SH-24H-WP  95cd, Hi db",0,0.23799999999999999]
[null,"Potter SH-24H-WP  95cd, Lo db",0,0.16900000000000001]
[null,"Potter SH-24H-WP  95cd, Med db",0,0.18099999999999999]
[]
[null,"Strobes"]
[]
[null,"Description","Standby","Alarm"]
[null,"Hochiki HCS24 or HCC24, 15cd, Strobe",0,0.12]
[null,"Hochiki HCS24 or HCC24, 30cd, Strobe",0,0.12]
[null,"Hochiki HCS24 or HCC24, 75cd, Strobe",0,0.2]
[null,"Hochiki HCS24 or HCC24, 95cd, Strobe",0,0.22]
[null,"Hochiki HCS24 or HCC24, 115cd, Strobe",0,0.28999999999999998]
[null,"Hochiki HCS24 or HCC24, 150cd, Strobe",0,0.32100000000000001]
[null,"Hochiki HES3-24 or HEC3-24, 15cd, Strobe",0,4.2000000000000003E-2]
[null,"Hochiki HES3-24 or HEC3-24, 15cd, Strobe",0,4.2000000000000003E-2]
[null,"Hochiki HES3-24 or HEC3-24, 30cd, Strobe",0,0.06]
[null,"Hochiki HES3-24 or HEC3-24, 60cd, Strobe",0,9.7000000000000003E-2]
[null,"Hochiki HES3-24 or HEC3-24, 75cd, Strobe",0,0.11600000000000001]
[null,"Hochiki HES3-24 or HEC3-24, 110cd, Strobe",0,0.157]
[null,"Hochiki HES24 or HEC24 177cd, Strobe",0,0.21299999999999999]
[null,"Hochiki WHES24 75cd, Strobe",0,0.18]
[null,"Gentex GCS24 Strobe, 115cd",0,0.28999999999999998]
[null,"Gentex GCS24 Strobe, 150cd",0,0.32100000000000001]
[null,"Gentex GCS24 Strobe, 15cd",0,0.12]
[null,"Gentex GCS24 Strobe, 30cd",0,0.12]
[null,"Gentex GCS24 Strobe, 75cd",0,0.2]
[null,"Gentex GCS24 Strobe, 95cd",0,0.22]
[null,"Gentex GCSA24, GCSB24, GCSG24 Strobe, 115cd",0,0.21199999999999999]
[null,"Gentex GCSA24, GCSB24, GCSG24 Strobe, 15cd",0,0.124]
[null,"Gentex GCSA24, GCSB24, GCSG24 Strobe, 30cd",0,0.124]
[null,"Gentex GCSA24, GCSB24, GCSG24 Strobe, 75cd",0,0.13900000000000001]
[null,"Gentex GCSA24, GCSB24, GCSG24 Strobe, 95cd",0,0.20499999999999999]
[null,"Gentex GCSR24 Strobe, 110cd",0,0.313]
[null,"Gentex GCSR24 Strobe, 15cd",0,0.124]
[null,"Gentex GCSR24 Strobe, 30cd",0,0.124]
[null,"Gentex GCSR24 Strobe, 75cd",0,0.21199999999999999]
[null,"Gentex GCSR24 Strobe, 95cd",0,0.28299999999999997]
[null,"Gentex GES24-177 Strobe, 177cd",0,0.21299999999999999]
[null,"Gentex GES3-24 Strobe, 110cd",0,0.161]
[null,"Gentex GES3-24 Strobe, 110cd",0,0.157]
[null,"Gentex GES3-24 Strobe, 15cd",0,4.2000000000000003E-2]
[null,"Gentex GES3-24 Strobe, 30cd",0,0.06]
[null,"Gentex GES3-24 Strobe, 60cd",0,9.7000000000000003E-2]
[null,"Gentex GES3-24 Strobe, 75cd",0,0.11600000000000001]
[null,"Gentex GESA24 Strobe, 30cd",0,6.4000000000000001E-2]
[null,"Gentex GESA24 Strobe, 60cd",0,0.113]
[null,"Gentex GESA24 Strobe,110cd",0,0.17799999999999999]
[null,"Gentex GESA24 Strobe,75cd",0,0.14499999999999999]
[null,"Gentex GESB24, GESG24, GESR24 Strobe, 110cd",0,0.31]
[null,"Gentex GESB24, GESG24, GESR24 Strobe, 15cd",0,0.105]
[null,"Gentex GESB24, GESG24, GESR24 Strobe, 30cd",0,0.13]
[null,"Gentex GESB24, GESG24, GESR24 Strobe, 60cd",0,0.20300000000000001]
[null,"Gentex GESB24, GESG24, GESR24 Strobe, 75cd",0,0.24299999999999999]
[null,"Gentex SSPK24CLP Strobe, 115cd",0,0.28999999999999998]
[null,"Gentex SSPK24CLP Strobe, 15cd",0,0.12]
[null,"Gentex SSPK24CLP Strobe, 30cd",0,0.12]
[null,"Gentex SSPK24CLP Strobe, 75cd",0,0.2]
[null,"Gentex SSPK24CLP Strobe, 95cd",0,0.22]
[null,"Gentex SSPK24WLP Strobe, 110cd",0,0.224]
[null,"Gentex SSPK24WLP Strobe, 15cd",0,7.8E-2]
[null,"Gentex SSPK24WLP Strobe, 30cd",0,9.6000000000000002E-2]
[null,"Gentex SSPK24WLP Strobe, 60cd",0,0.13700000000000001]
[null,"Gentex SSPK24WLP Strobe, 75cd",0,0.18]
[null,"Gentex SSPKA24 Strobe, 15/75cd",0,0.14799999999999999]
[null,"Gentex SSPKB24 Strobe, 15/75cd",0,0.28000000000000003]
[null,"Gentex SSPKG24 Strobe, 15/75cd",0,0.36]
[null,"Gentex SSPKR24 Strobe, 15/75cd",0,0.39700000000000002]
[null,"Gentex WGES24-75 Strobe, 75cd",0,0.17]
[null,"Gentex WGESA24 Strobe, 75cd",0,0.17]
[null,"Gentex WGESB24, WGESG24, WGESR24 Strobe, 75cd",0,0.16400000000000001]
[null,"Potter CCS-24A,CCS-24B,CCS-24G Strobe, 115cd",0,0.21199999999999999]
[null,"Potter CCS-24A,CCS-24B,CCS-24G Strobe, 15cd",0,0.124]
[null,"Potter CCS-24A,CCS-24B,CCS-24G Strobe, 30cd",0,0.124]
[null,"Potter CCS-24A,CCS-24B,CCS-24G Strobe, 75cd",0,0.13900000000000001]
[null,"Potter CCS-24A,CCS-24B,CCS-24G Strobe, 95cd",0,0.20499999999999999]
[null,"Potter CCS-24R Strobe, 110cd",0,0.313]
[null,"Potter CCS-24R Strobe, 15cd",0,0.124]
[null,"Potter CCS-24R Strobe, 30cd",0,0.124]
[null,"Potter CCS-24R Strobe, 75cd",0,0.21199999999999999]
[null,"Potter CCS-24R Strobe, 75cd",0,0.17]
[null,"Potter CCS-24R Strobe, 95cd",0,0.28299999999999997]
[null,"Potter CS-24 Strobe, 115cd",0,0.28999999999999998]
[null,"Potter CS-24 Strobe, 150cd",0,0.32100000000000001]
[null,"Potter CS-24 Strobe, 15cd",0,0.12]
[null,"Potter CS-24 Strobe, 30cd",0,0.12]
[null,"Potter CS-24 Strobe, 75cd",0,0.2]
[null,"Potter CS-24 Strobe, 95cd",0,0.22]
[null,"Potter CS-24A-WP,CS-24B-WP,CS-24G-WP,CS-24R-WP Strobe, 75cd",0,0.16400000000000001]
[null,"Potter CS-24WA Strobe, 15cd",0,4.7E-2]
[null,"Potter CS-24WA Strobe, 30cd",0,6.4000000000000001E-2]
[null,"Potter CS-24WA Strobe, 60cd",0,0.113]
[null,"Potter CS-24WA Strobe,110cd",0,0.17799999999999999]
[null,"Potter CS-24WA Strobe,75cd",0,0.14499999999999999]
[null,"Potter CS-24WB,CS-24WG,CS-24WR Strobe, 110cd",0,0.31]
[null,"Potter CS-24WB,CS-24WG,CS-24WR Strobe, 15cd",0,0.105]
[null,"Potter CS-24WB,CS-24WG,CS-24WR Strobe, 30cd",0,0.13]
[null,"Potter CS-24WB,CS-24WG,CS-24WR Strobe, 60cd",0,0.20300000000000001]
[null,"Potter CS-24WB,CS-24WG,CS-24WR Strobe, 75cd",0,0.24299999999999999]
[null,"Potter CSLP-24A-WP,CS-24B-WP,CS-24G-WP,CS-24R-WP Strobe, 75cd",0,0.16400000000000001]
[null,"Potter CSPKSTR-24A Strobe, 15/75cd",0,0.14799999999999999]
[null,"Potter CSPKSTR-24B Strobe, 15/75cd",0,0.28000000000000003]
[null,"Potter CSPKSTR-24G Strobe, 15/75cd",0,0.36]
[null,"Potter CSPKSTR-24R Strobe, 15/75cd",0,0.39700000000000002]
[null,"Potter S-24 Strobe, 110cd",0,0.161]
[null,"Potter S-24 Strobe, 15cd",0,4.2000000000000003E-2]
[null,"Potter S-24 Strobe, 30cd",0,5.8000000000000003E-2]
[null,"Potter S-24 Strobe, 60cd",0,9.7000000000000003E-2]
[null,"Potter S-24 Strobe, 75cd",0,0.11600000000000001]
[null,"Potter S24-177 Strobe, 177cd",0,0.21299999999999999]
[null,"Potter S-24-WP Strobe, 75cd",0,0.17]
[null,"Potter SL-1224 Strobe 110cd",0,0.19600000000000001]
[null,"Potter SL-1224 Strobe 15cd",0,6.0999999999999999E-2]
[null,"Potter SL-1224 Strobe 35cd",0,0.10100000000000001]
[null,"Potter SL-1224 Strobe 60cd",0,0.13100000000000001]
[null,"Potter SL-1224 Strobe 75cd",0,0.14499999999999999]
[null,"Potter SL-1224 Strobe 95cd",0,0.17599999999999999]
[null,"Potter SL-1224WP Strobe 110cd",0,0.28399999999999997]
[null,"Potter SL-1224WP Strobe 15cd",0,0.1]
[null,"Potter SL-1224WP Strobe 35cd",0,0.13500000000000001]
[null,"Potter SL-1224WP Strobe 60cd",0,0.17100000000000001]
[null,"Potter SL-1224WP Strobe 75cd",0,0.19]
[null,"Potter SL-1224WP Strobe 95cd",0,0.21099999999999999]
[null,"Potter SL24C-177 Strobe 177cd",0,0.34699999999999998]
[null,"Potter SL24C-3075110 Strobe 110cd",0,0.23400000000000001]
[null,"Potter SL24C-3075110 Strobe 30cd",0,0.11600000000000001]
[null,"Potter SL24C-3075110 Strobe 75cd",0,0.17199999999999999]
[null,"Potter SL-24H Strobe 110cd",0,0.161]
[null,"Potter SL-24H Strobe 135cd",0,0.17799999999999999]
[null,"Potter SL-24H Strobe 150cd",0,0.19]
[null,"Potter SL-24H Strobe 177cd",0,0.218]
[null,"Potter SL-24H Strobe 185cd",0,0.22600000000000001]
[null,"Potter SL-24H Strobe 95cd",0,0.151]
[null,"Potter SL-24H-WP Strobe 110cd",0,0.161]
[null,"Potter SL-24H-WP Strobe 135cd",0,0.17799999999999999]
[null,"Potter SL-24H-WP Strobe 150cd",0,0.19]
[null,"Potter SL-24H-WP Strobe 177cd",0,0.218]
[null,"Potter SL-24H-WP Strobe 185cd",0,0.22600000000000001]
[null,"Potter SL-24H-WP Strobe 95cd",0,0.151]
[null,"Potter SPKSTR-24CLP Strobe 15cd",0,0.12]
[null,"Potter SPKSTR-24CLP Strobe, 115cd",0,0.28999999999999998]
[null,"Potter SPKSTR-24CLP Strobe, 30cd",0,0.12]
[null,"Potter SPKSTR-24CLP Strobe, 75cd",0,0.2]
[null,"Potter SPKSTR-24CLP Strobe, 95cd",0,0.22]
[null,"Potter SPKSTR-24WLP Strobe, 110cd",0,0.224]
[null,"Potter SPKSTR-24WLP Strobe, 30cd",0,9.6000000000000002E-2]
[null,"Potter SPKSTR-24WLP Strobe, 60cd",0,0.13700000000000001]
[null,"Potter SPKSTR-24WLP Strobe, 75cd",0,0.18]
[null,"Potter SPKSTR-24WLP, 15cd",0,7.8E-2]
[]
[null,"Horns"]
[]
[]
[null,"Description","Standby","Alarm"]
[null,"Hochiki HCC24, All Candelas, Horn",0,2.3E-2]
[null,"Hochiki HEH24 or HEC24, All Candelas, Horn",0,2.8000000000000001E-2]
[null,"Hochiki WHEC24, Horn",0,2.8000000000000001E-2]
[null,"Hochiki HHLF Temporal 3 520Hz",0,7.1999999999999995E-2]
[null,"Hochiki HHLF Temporal 4 520Hz",0,7.5999999999999998E-2]
[null,"Gentex GEH24 Horn, High db",0,2.9000000000000001E-2]
[null,"Potter EH-24 Horn, High db",0,2.9000000000000001E-2]
[null,"Potter H-1224 Horn, Hi db",0,8.6999999999999994E-2]
[null,"Potter H-1224 Horn, Lo db",0,1.7999999999999999E-2]
[null,"Potter H-1224 Horn, Med db",0,2.8000000000000001E-2]
[]
[null,"MiniHorns"]
[]
[]
[null,"Description","Standby","Alarm"]
[null,"Hochiki HX-91 Mini Horn",0,1.0999999999999999E-2]
[null,"Hochiki HX-93 Mini Horn",0,1.7999999999999999E-2]
[null,"Gentex GX-93 Mini Horn",0,1.7999999999999999E-2]
[null,"Potter HP-25T Mini Horn, Synchable",0,1.6400000000000001E-2]
[null,"Potter MH-12/24 Mini Horn",0,1.4999999999999999E-2]
[null,"Potter MHT-1224 Mini Horn",0,0.18]
[]
[null,"Other Notification"]
[]
[]
[null,"Description","Standby","Alarm"]
[null,"Potter MBA-246 Bell",0,0.06]
[null,"Potter MBA-248 Bell",0,0.06]
[null,"Potter MBA-2410 Bell",0,0.06]
[null,"Federal FHEX Explsn Proof Horn",0,1.2]
[null,"Federal FSEX Explsn Proof Strobe",0,1.9]
[]
[null,"SLC Aux Power"]
[]
[null,"Description","Standby","Alarm"]
[null,"ASB Analog Sounder Base",5.5000000000000003E-4,1.7999999999999999E-2]
[null,"ASBL Analog Low Frequency Sounder Base",2.8E-3,0.14000000000000001]
[null,"DH-98AR Analog Duct w/relay",0.01,0.06]
[null,"DH-99AR Analog Duct w/relay",0.01,5.5E-2]
[null,"DH-100AR",0.01,0.05]
[null,"SOM Supervised Output Module",1.5E-3,1.5E-3]
[null,"SOM-A/AI Supervised Output Module",5.0000000000000002E-5,5.0000000000000002E-5]
[null,"CZM Conventional Zone Module",2E-3,0.06]
[null,"Conventional Detectors"]
[]
[]
[null,"Description","Standby","Alarm"]
[null,"Hochiki DH-100-P Conventional Duct Detector w/relay",2E-3,7.8E-2]
[null,"Hochiki SPC-24, Emitter",5.0000000000000002E-5,0.02]
[null,"Hochiki SPC-24, Receiver",2.0000000000000001E-4,0.02]
[null,"Xtralis OSID Imager",0.01,0.01]
[null,"Xtralis OSID Emitter (Low Power)",3.5E-4,3.5E-4]
[null,"Xtralis OSID Emitter (High Power)",0.8,0.8]
[]
[]
[null,"Other Devices"]
[]
[]
[null,"Description","Standby","Alarm"]
[null,"DH Series Door Holder",2.0000000000000002E-5,0]
[null,"TCF-142-M-ST Fiber Optic Module",7.1999999999999995E-2,7.1999999999999995E-2]
[null,"MS-RA Remote Alarm Indicator",0,1.4999999999999999E-2]
[null,"MS-KA/R Remote Alarm Indicator, Test/Reset",0,1.4999999999999999E-2]
[null,"MS-RA/P Remote Alarm Indicator, Pilot ",1.4999999999999999E-2,0.03]
[null,"MS-KA/P/R Remote Alarm Indicator, Pilot, Test/Reset",1.4999999999999999E-2,0.03]
[null,"MS-RA/R Remote Alarm Indicator, Test/Reset, PB",0,1.4999999999999999E-2]
[null,"MS-RA/P/R Remote Alarm Indicator, Pilot, Test/Reset, PB",1.4999999999999999E-2,0.03]
[null,"FN-LCD-N Network Annunciator",0.27,0.27]
[null,"FN-LCD-S Serial LCD Annunciator",0.02,0.02]

{"sheet":"User Defined","index":2,"n_rows":103,"n_cols":4,"rows_kept":103,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"User Defined Parts"]
[]
[null,"Description","Standby","Alarm"]
[null,"User Defined 1"]
[null,"User Defined 2"]
[null,"User Defined 3"]
[null,"User Defined 4"]
[null,"User Defined 5"]
[null,"User Defined 6"]
[null,"User Defined 7"]
[null,"User Defined 8"]
[null,"User Defined 9"]
[null,"User Defined 10"]
[null,"User Defined 11"]
[null,"User Defined 12"]
[null,"User Defined 13"]
[null,"User Defined 14"]
[null,"User Defined 15"]
[null,"User Defined 16"]
[null,"User Defined 17"]
[null,"User Defined 18"]
[null,"User Defined 19"]
[null,"User Defined 20"]
[null,"User Defined 21"]
[null,"User Defined 22"]
[null,"User Defined 23"]
[null,"User Defined 24"]
[null,"User Defined 25"]
[null,"User Defined 26"]
[null,"User Defined 27"]
[null,"User Defined 28"]
[null,"User Defined 29"]
[null,"User Defined 30"]
[null,"User Defined 31"]
[null,"User Defined 32"]
[null,"User Defined 33"]
[null,"User Defined 34"]
[null,"User Defined 35"]
[null,"User Defined 36"]
[null,"User Defined 37"]
[null,"User Defined 38"]
[null,"User Defined 39"]
[null,"User Defined 40"]
[null,"User Defined 41"]
[null,"User Defined 42"]
[null,"User Defined 43"]
[null,"User Defined 44"]
[null,"User Defined 45"]
[null,"User Defined 46"]
[null,"User Defined 47"]
[null,"User Defined 48"]
[null,"User Defined 49"]
[null,"User Defined 50"]
[null,"User Defined 51"]
[null,"User Defined 52"]
[null,"User Defined 53"]
[null,"User Defined 54"]
[null,"User Defined 55"]
[null,"User Defined 56"]
[null,"User Defined 57"]
[null,"User Defined 58"]
[null,"User Defined 59"]
[null,"User Defined 60"]
[null,"User Defined 61"]
[null,"User Defined 62"]
[null,"User Defined 63"]
[null,"User Defined 64"]
[null,"User Defined 65"]
[null,"User Defined 66"]
[null,"User Defined 67"]
[null,"User Defined 68"]
[null,"User Defined 69"]
[null,"User Defined 70"]
[null,"User Defined 71"]
[null,"User Defined 72"]
[null,"User Defined 73"]
[null,"User Defined 74"]
[null,"User Defined 75"]
[null,"User Defined 76"]
[null,"User Defined 77"]
[null,"User Defined 78"]
[null,"User Defined 79"]
[null,"User Defined 80"]
[null,"User Defined 81"]
[null,"User Defined 82"]
[null,"User Defined 83"]
[null,"User Defined 84"]
[null,"User Defined 85"]
[null,"User Defined 86"]
[null,"User Defined 87"]
[null,"User Defined 88"]
[null,"User Defined 89"]
[null,"User Defined 90"]
[null,"User Defined 91"]
[null,"User Defined 92"]
[null,"User Defined 93"]
[null,"User Defined 94"]
[null,"User Defined 95"]
[null,"User Defined 96"]
[null,"User Defined 97"]
[null,"User Defined 98"]
[null,"User Defined 99"]
[null,"User Defined 100"]