{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["NEO HS2016 - HS2128 ","AUX Power Calculation","PGM1,3,4 Calculation","PGM2 Calculation","Corbus Calculation","Instructions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"NEO HS2016 - HS2128 ","index":0,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[15]
[]
[null,null,null,null,null,null,"Main Panel Power Calculation"]
[null,null,null,null,null,null,"   Maximum (Standby or Alarm)"]
[]
[null,null,null,null,null,null,"AUX +  (700mA max.)",null,null,{"$f":"'AUX Power Calculation'!G27","v":0},null,{"$f":"IF(J6>700,\"CAUTION - OVER 700mA\",\" \")","v":" "}]
[]
[null,null,null,null,null,null,"PGM1  (50mA max.)",null,null,{"$f":"'PGM1,3,4 Calculation'!G10","v":0},null,{"$f":"IF(J8>50,\"CAUTION - OVER  50mA\",\" \")","v":" "}]
[]
[null,null,null,null,null,null,"PGM2  (300mA max.)",null,null,{"$f":"'PGM2 Calculation'!G12","v":0},null,{"$f":"O10","v":""},null,null,{"$f":"IF(O12=\"CAUTION - OVER 90mA\",\"CAUTION - OVER 90mA\",IF(O12=\"CAUTION - OVER 300mA\",\"CAUTION - OVER 300mA\",IF(O12>0,\"\")))","v":""}]
[]
[null,null,null,null,null,null,"PGM3  (50mA max.)",null,null,{"$f":"'PGM1,3,4 Calculation'!G21","v":0},null,{"$f":"IF(J12>50,\"CAUTION - OVER  50mA\",\" \")","v":" "},null,null,{"$f":"'PGM2 Calculation'!D22","v":"0"}]
[]
[null,null,null,null,null,null,"PGM4  (50mA max.)",null,null,{"$f":"'PGM1,3,4 Calculation'!G32","v":0},null,{"$f":"IF(J14>50,\"CAUTION - OVER  50mA\",\" \")","v":" "}]
[]
[null,null,null,null,null,null,"Corbus (700mA max.)",null,null,{"$f":"'Corbus Calculation'!G36","v":85},null,{"$f":"IF(J16>700,\"CAUTION - OVER 700mA\",\" \")","v":" "}]
[]
[null,null,null,null,null,null,"PCLink2 (125mA max.)",null,null,{"$f":"IF(N18>\"NO\",\"125\",\"0\")","v":"125"},null,"Alteritive Communicator",null,"YES"]
[]
[]
[null,null,null,null,null,null,"Total (must not exceed 700mA)",null,null,{"$f":"J6+J8+J12+J14+J10+J16+J18","v":210},null,{"$f":"IF(J21>700,\"CAUTION - OVER 700mA\",\" \")","v":" "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Created by: Daniel Johnson 03/28/2023"]

{"sheet":"AUX Power Calculation","index":1,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"AUX Power Calculation"]
[]
[null,"Part #","Description","Current ",null,"Quantity","Total"]
[null,null,null,"(mA)",null,null,"(mA)"]
[]
[null,"AC-100","Acuity Glass Break",35,"x",null,{"$f":"D7*F7","v":0}]
[null,"AC-500","Acuity Glass Break",32,"x",null,0]
[null,"BV-300DP","Bravo 300 Passive Infrared Detector",18,"x",null,0]
[null,"BV-500 ","Bravo 500 Passive Infrared Detector",18,"x",null,0]
[null,"BV-500GB","Bravo 500 Passive Infrared Detector w/ Glass Break Detector",38,"x",null,0]
[null,"BV-600","Bravo 600 Passive Infrared Detector",17.5,"x",null,0]
[null,"EC-300DP","Encore Passive Infrared Detector",18,"x",null,0]
[null,"ST-300D","Strata Passive Infrared Detector",18,"x",null,0]
[null,"F2-200","Force 2 Dual Tech Infrared Detector",30,"x",null,0]
[null,"LC-100-PI","PIR Motion Detector with Pet Immunity",10,"x",null,0]
[null,"LC-103-PIMSK","Dual Technology Motion Detector with Pet Immunity",25,"x",null,0]
[null,"LC-104-PIMW","Dual Technology Motion Detector with Pet Immunity",25,"x",null,0]
[null,"LC-120-PI","PIR Detector with Pet Immunity",10,"x",null,0]
[null,"LC-124-PIMW","Dual Technology Motion Detector with Pet Immunity",25,"x",null,{"$f":"D20*F20","v":0}]
[null,"LC-151","Dual-Tech Outdoor Motion Sensor (Single PIR & Microwave)",24,"x",null,{"$f":"D21*F21","v":0}]
[null,"LC-171","Outdoor Motion Sensor (Double PIR & Microwave)",24,"x",null,{"$f":"D22*F22","v":0}]
[null,null,null,null,"x",null,0]
[null,null,null,null,"x",null,0]
[null,null,null,null,"x",null,0]
[null,null,null,null,"x",null,0]
[null,null,null,null,null,"Total Aux Current Draw =",{"$f":"SUM(G7:G26)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(G27>500,\"CAUTION - OVER 500mA\",\"  \")","v":"  "}]

{"sheet":"PGM1,3,4 Calculation","index":2,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,3,1,5]]}
[]
[null,"PGM1 Power Calculation"]
[]
[null,"Part #","Description","Current ",null,"Quantity","Total"]
[null,null,null,"(mA)",null,null,"(mA)"]
[]
[null,null,"PGM Output"]
[null,null,null,null,"x",null,{"$f":"D8*F8","v":0}]
[null,null,null,null,"x",null,{"$f":"D9*F9","v":0}]
[null,null,null,null,null,"Total Aux Current Draw =",{"$f":"SUM(G8:G9)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"IF(G10>50,\"CAUTION - OVER 50mA\",\"\")","v":""}]
[]
[]
[null,null,"Description","Current ",null,"Quantity","Total"]
[null,null,null,"(mA)",null,null,"(mA)"]
[]
[null,null,"PGM Output"]
[null,null,null,null,"x",null,{"$f":"D19*F19","v":0}]
[null,null,null,null,"x",null,{"$f":"D20*F20","v":0}]
[null,null,null,null,null,"Total Aux Current Draw =",{"$f":"SUM(G19:G20)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"IF(G21>50,\"CAUTION - OVER 50mA\",\"\")","v":""}]
[null,"PGM4 Power Calculation"]
[]
[null,"Part #","Description","Current ",null,"Quantity","Total"]
[null,null,null,"(mA)",null,null,"(mA)"]
[]
[null,null,"PGM Output"]
[null,null,null,null,"x",null,{"$f":"D30*F30","v":0}]
[null,null,null,null,"x",null,{"$f":"D31*F31","v":0}]
[null,null,null,null,null,"Total Aux Current Draw =",{"$f":"SUM(G30:G31)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"IF(G32>50,\"CAUTION - OVER 50mA\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(C7=\"PGM Output\",G10>300),\"CAUTION - OVER 300mA\",\" \")","v":" "}]

{"sheet":"PGM2 Calculation","index":3,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,3,1,5]]}
[]
[null,"PGM2 Power Calculation"]
[]
[null,"Part #","Description","Current ",null,"Quantity","Total"]
[null,null,null,"(mA)",null,null,"(mA)"]
[]
[null,null,"2-Wire Smoke Detector","    Select"]
[null,null,null,null,"x",null,{"$f":"D8*F8","v":0}]
[null,null,null,null,"x",null,{"$f":"D9*F9","v":0}]
[null,null,null,null,"x",null,{"$f":"D10*F10","v":0}]
[null,null,null,null,"x",null,{"$f":"D11*F11","v":0}]
[null,null,null,null,null,"Total Aux Current Draw =",{"$f":"SUM(G8:G11)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"IF(I37=\"CAUTION - OVER 300mA\",\"CAUTION - OVER 300mA\",IF(C20=\"CAUTION - OVER 90Ma\",\"CAUTION - OVER 90mA\",\"\"))","v":""}]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(AND(C7=\"2-Wire Smoke Detector\",G12>90),\"CAUTION - OVER 90mA\",\" \")","v":" "}]
[]
[null,null,null,{"$f":"IF(I37=\"CAUTION - OVER 300mA\",\"CAUTION - OVER 300mA\",IF(C20=\"CAUTION - OVER 90Ma\",\"CAUTION - OVER 90mA\",\"0\"))","v":"0"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(C7=\"PGM Output\",G12>300),\"CAUTION - OVER 300mA\",\" \")","v":" "}]

{"sheet":"Corbus Calculation","index":4,"n_rows":38,"n_cols":35,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Corbus Power Calculation ",null,null,null,null,null,null,"HSM2204 / HSM2300 Module #1",null,null,null,null,null,null,"HSM2204 / HSM2300 Module #2",null,null,null,null,null,null,"HSM2204 / HSM2300 Module #3",null,null,null,null,null,null,"HSM2204 / HSM2300 Module #4"]
[]
[]
[null,"Item","Description","Current",null,"Quanity","Total",null,"Item","Description","Current",null,"Quanity","Total",null,"Item","Description","Current",null,"Quanity","Total",null,"Item","Description","Current",null,"Quanity","Total",null,"Item","Description","Current",null,"Quanity","Total"]
[null,null,null,"(mA)",null,null,"(mA)",null,null,null,"(mA)",null,null,"(mA)",null,null,null,"(mA)",null,null,"(mA)",null,null,null,"(mA)",null,null,"(mA)",null,null,null,"(mA)",null,null,"(mA)"]
[]
[null,"HS2XXX","NEO Control Panel ~ HS2016 / HS2032 / HS2064 / HS2128",85,"x",1,{"$f":"F10*D10","v":85},null,"HS2LCD","Keypad - all styles",105,"x",null,{"$f":"M10*K10","v":0},null,"HS2LCD","Keypad - all styles",105,"x",null,{"$f":"T10*R10","v":0},null,"HS2LCD","Keypad - all styles",105,"x",null,{"$f":"AA10*Y10","v":0},null,"HS2LCD","Keypad - all styles",105,"x",null,{"$f":"AH10*AF10","v":0}]
[null,"HS2LCD","Keypad - all styles",105,"x",null,0,null,"HS2ICN","Keypad - all styles",105,"x",null,{"$f":"M11*K11","v":0},null,"HS2ICN","Keypad - all styles",105,"x",null,{"$f":"T11*R11","v":0},null,"HS2ICN","Keypad - all styles",105,"x",null,{"$f":"AA11*Y11","v":0},null,"HS2ICN","Keypad - all styles",105,"x",null,{"$f":"AH11*AF11","v":0}]
[null,"HS2ICN","Keypad - all styles",105,"x",null,0,null,"HS2LED","Keypad - all styles",105,"x",null,{"$f":"M12*K12","v":0},null,"HS2LED","Keypad - all styles",105,"x",null,{"$f":"T12*R12","v":0},null,"HS2LED","Keypad - all styles",105,"x",null,{"$f":"AA12*Y12","v":0},null,"HS2LED","Keypad - all styles",105,"x",null,{"$f":"AH12*AF12","v":0}]
[null,"HS2LED","Keypad - all styles",105,"x",null,0,null,"HS2TCHP","Touchscreen - in Standard Mode",160,"x",null,{"$f":"M13*K13","v":0},null,"HS2TCHP","Touchscreen - in Standard Mode",160,"x",null,{"$f":"T13*R13","v":0},null,"HS2TCHP","Touchscreen - in Standard Mode",160,"x",null,{"$f":"AA13*Y13","v":0},null,"HS2TCHP","Touchscreen - in Standard Mode",160,"x",null,{"$f":"AH13*AF13","v":0}]
[null,"HS2TCHP","Touchscreen - in Standard Mode",160,"x",null,0,null,"HS2TCHP","Touchscreen - in Extra Power Mode",230,"x",null,{"$f":"M14*K14","v":0},null,"HS2TCHP","Touchscreen - in Extra Power Mode",230,"x",null,{"$f":"T14*R14","v":0},null,"HS2TCHP","Touchscreen - in Extra Power Mode",230,"x",null,{"$f":"AA14*Y14","v":0},null,"HS2TCHP","Touchscreen - in Extra Power Mode",230,"x",null,{"$f":"AH14*AF14","v":0}]
[null,"HS2TCHP","Touchscreen - in Extra Power Mode",230,"x",null,0,null,null,null,null,"Current required for connected devices = ",null,{"$f":"M15","v":0},null,null,null,null,"Current required for connected devices = ",null,{"$f":"T15","v":0},null,null,null,null,"Current required for connected devices = ",null,{"$f":"AA15","v":0},null,null,null,null,"Current required for connected devices = ",null,{"$f":"AH15","v":0}]
[null,null,null,null,"Current required for connected devices = ",null,{"$f":"F16","v":0},null,"HSM2HOST","Transceiver",35,"x",null,{"$f":"M16*K16","v":0},null,"HSM2HOST","Transceiver",35,"x",null,{"$f":"T16*R16","v":0},null,"HSM2HOST","Transceiver",35,"x",null,{"$f":"AA16*Y16","v":0},null,"HSM2HOST","Transceiver",35,"x",null,{"$f":"AH16*AF16","v":0}]
[null,"HSM2HOST","Transceiver",35,"x",null,{"$f":"F17*D17","v":0},null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"T17*R17","v":0},null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,"HSM2HOST","Transceiver",35,"x",null,{"$f":"F18*D18","v":0}]
[null,null,null,null,null,null,null,null,"HSM2108","8 Zone  Input Expander",30,"x",null,0,null,"HSM2108","8 Zone  Input Expander",30,"x",null,0,null,"HSM2108","8 Zone  Input Expander",30,"x",null,0,null,"HSM2108","8 Zone  Input Expander",30,"x",null,0]
[null,"HSM2108","8 Zone  Input Expander",30,"x",null,{"$f":"F20*D20","v":0},null,null,null,null,"Current required for connected devices = ",null,{"$f":"M20","v":0},null,null,null,null,"Current required for connected devices = ",null,{"$f":"T20","v":0},null,null,null,null,"Current required for connected devices = ",null,{"$f":"AA20","v":0},null,null,null,null,"Current required for connected devices = ",null,{"$f":"AH20","v":0}]
[null,null,null,null,"Current required for connected devices = ",null,{"$f":"F21","v":0},null,"HSM2208","8 PGM Output Expander",40,"x",null,0,null,"HSM2208","8 PGM Output Expander",40,"x",null,0,null,"HSM2208","8 PGM Output Expander",40,"x",null,0,null,"HSM2208","8 PGM Output Expander",40,"x",null,0]
[null,"HSM2208","8 PGM Output Expander",40,"x",null,{"$f":"F22*D22","v":0},null,null,null,null,"Current required for connected devices = ",null,{"$f":"M22","v":0},null,null,null,null,"Current required for connected devices = ",null,{"$f":"T22","v":0},null,null,null,null,"Current required for connected devices = ",null,{"$f":"AA22","v":0},null,null,null,null,"Current required for connected devices = ",null,{"$f":"AH22","v":0}]
[null,null,null,null,"Current required for connected devices = ",null,{"$f":"F23","v":0},null,"HSM2204","1Amp Power Supply with 4 PGM Outputs",35,"x",null,{"$f":"M23*K23","v":0},null,"HSM2204","1Amp Power Supply with 4 PGM Outputs",35,"x",null,{"$f":"T23*R23","v":0},null,"HSM2204","1Amp Power Supply with 4 PGM Outputs",35,"x",null,{"$f":"AA23*Y23","v":0},null,"HSM2204","1Amp Power Supply with 4 PGM Outputs",35,"x",null,{"$f":"AH23*AF23","v":0}]
[null,"HSM2204","1Amp Power Supply with 4 PGM Outputs",35,"x",null,{"$f":"F24*D24","v":0}]
[null,null,null,null,null,null,null,null,"HSM2300","1Amp Power Supply",35,"x",null,{"$f":"M25*K25","v":0},null,"HSM2300","1Amp Power Supply",35,"x",null,{"$f":"T25*R25","v":0},null,"HSM2300","1Amp Power Supply",35,"x",null,{"$f":"AA25*Y25","v":0},null,"HSM2300","1Amp Power Supply",35,"x",null,{"$f":"AH25*AF25","v":0}]
[null,"HSM2300","1Amp Power Supply",35,"x",null,0]
[null,null,null,null,null,null,null,null,"HSM2955","Audio Verification Module ",100,"x",null,0,null,"HSM2955","Audio Verification Module ",100,"x",null,0,null,"HSM2955","Audio Verification Module ",100,"x",null,0,null,"HSM2955","Audio Verification Module ",100,"x",null,0]
[null,"HSM2955","Audio Verification Module ",100,"x",null,0,null,null,"*The HSM2955 supports up to 4 Auto Station units **",null,null,null,null,null,null,"*The HSM2955 supports up to 4 Auto Station units **",null,null,null,null,null,null,"*The HSM2955 supports up to 4 Auto Station units **",null,null,null,null,null,null,"*The HSM2955 supports up to 4 Auto Station units **"]
[null,null,"*The HSM2955 supports up to 4 Auto Station units **",null,null,null,null,null,"PC5961E","Small Audio Station Talk/Listen (1 station = 1 unit**)",100,"x",null,0,null,"PC5961E","Small Audio Station Talk/Listen (1 station = 1 unit**)",100,"x",null,0,null,"PC5961E","Small Audio Station Talk/Listen (1 station = 1 unit**)",100,"x",null,0,null,"PC5961E","Small Audio Station Talk/Listen (1 station = 1 unit**)",100,"x",null,{"$f":"AH29*AF29","v":0}]
[null,"PC5961E","Small Audio Station Talk/Listen (1 station = 1 unit**)",100,"x",null,0,null,"PC5964E","Large Audio Station Talk/Listen (1 station = 2 units**)",190,"x",null,0,null,"PC5964E","Large Audio Station Talk/Listen (1 station = 2 units**)",190,"x",null,0,null,"PC5964E","Large Audio Station Talk/Listen (1 station = 2 units**)",190,"x",null,0,null,"PC5964E","Large Audio Station Talk/Listen (1 station = 2 units**)",190,"x",null,{"$f":"AH30*AF30","v":0}]
[null,"PC5964E","Large Audio Station Talk/Listen (1 station = 2 units**)",190,"x",null,{"$f":"F31*D31","v":0},null,null,null,null,"x",null,0,null,null,null,null,"x",null,0,null,null,null,null,"x",null,0,null,null,null,null,"x",null,0]
[null,null,null,null,"x",null,0,null,null,null,null,"x",null,0,null,null,null,null,"x",null,0,null,null,null,null,"x",null,0,null,null,null,null,"x",null,0]
[null,null,null,null,"x",null,0,null,null,null,null,"x",null,0,null,null,null,null,"x",null,0,null,null,null,null,"x",null,0,null,null,null,null,"x",null,0]
[null,null,null,null,"x",null,{"$f":"F34*D34","v":0},null,null,null,null,"x",null,{"$f":"K34*M34","v":0},null,null,null,null,"x",null,{"$f":"R34*T34","v":0},null,null,null,null,"x",null,{"$f":"Y34*AA34","v":0},null,null,null,null,"x",null,{"$f":"AF34*AH34","v":0}]
[null,null,null,null,"x",null,0,null,null,null,null,"x",null,{"$f":"K35*M35","v":0},null,null,null,null,"x",null,{"$f":"R35*T35","v":0},null,null,null,null,"x",null,{"$f":"Y35*AA35","v":0},null,null,null,null,"x",null,{"$f":"AF35*AH35","v":0}]
[null,null,null,null,null,"Total Keybus Current =",{"$f":"SUM(G10:G35)","v":85},null,null,null,null,null,"Total Keybus Current =",{"$f":"SUM(N10:N35)","v":0},null,null,null,null,null,"Total Keybus Current =",{"$f":"SUM(U10:U35)","v":0},null,null,null,null,null,"Total Keybus Current =",{"$f":"SUM(AB10:AB35)","v":0},null,null,null,null,null,"Total Keybus Current =",{"$f":"SUM(AI10:AI35)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"IF(SUM(G10:G35)>700,\"CAUTION - OVER 700mA\",\"  \")","v":"  "},null,null,null,null,null,null,{"$f":"IF(SUM(N10:N35)>1000,\"CAUTION - OVER 1000mA\",\"  \")","v":"  "},null,null,null,null,null,null,{"$f":"IF(SUM(U10:U35)>1000,\"CAUTION - OVER 1000mA\",\"  \")","v":"  "},null,null,null,null,null,null,{"$f":"IF(SUM(AB10:AB35)>1000,\"CAUTION - OVER 1000mA\",\"  \")","v":"  "},null,null,null,null,null,null,{"$f":"IF(SUM(AI10:AI35)>1000,\"CAUTION - OVER 1000mA\",\"  \")","v":"  "}]

{"sheet":"Instructions","index":5,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[[24,6,25,9],[13,6,14,11]]}
[]
[null,null,null,"This tool is designed to assist with power calculations for the NEO HS2016 / HS2032 / HS2064 / HS2128 panels."]
[]
[null,null,null,null,"TECH TIP: Before starting, SAVE the file with the client's name.  This will provide a reference to the client on each page.   "]
[]
[null,null,null,"The 'NEO HS2016 - HS2128' tab will provide a summary of the system's power calculation. "]
[]
[null,null,null,"Each of the additional tabs will provide specific calculations for the NEO panel.  "]
[]
[null,null,null,"On the 'PGM2 Calculation' tab, select if PGM2 will be used as a 'PGM Output' or as a '2-Wire Smoke Input'."]
[]
[15,null,null,"Hot Buttons: Enable the macros in the spreadsheet for access to the Hot Button functions"]
[]
[null,null,null,null,null,null,"PRINT ALL ~ will print all pages of the workbook."]
[]
[]
[]
[null,null,null,null,null,null,"AUX - CORBUS ~ will jump to the selected Tab within the workbook."]
[]
[]
[]
[null,null,null,null,null,null,"PRINT ~ will print the current page of the workbook."]
[null,null,null,null,null,null,"PRINT #X ~ will print the independent power supply pages."]
[]
[null,null,null,null,null,null,"RESET ~ will clear entries on each Tab."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Created by: Daniel Johnson 03/28/2023"]