{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Job Summary Sheet","Main Panel Calculations","NAC Calculations","Voltage Drops"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":8,"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":"Job Summary Sheet","index":0,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[38,5,38,6],[37,1,37,4],[38,1,38,4],[47,1,47,6],[42,1,42,4],[42,5,42,6],[43,1,43,4],[43,5,43,6],[44,1,44,4],[44,5,44,6],[45,1,45,4],[45,5,45,6],[39,1,39,4],[39,5,39,6],[40,1,40,4],[40,5,40,6],[37,5,37,6],[30,1,30,4],[28,1,28,4],[29,5,30,6],[35,1,35,4],[28,5,28,6],[35,5,35,6],[33,5,33,6],[33,1,33,4],[4,1,4,6],[8,3,8,6],[9,3,9,6],[10,3,10,6],[7,1,7,2],[7,3,7,6],[11,3,11,6],[20,5,20,6],[22,5,22,6],[24,2,24,3],[16,1,16,4],[16,5,16,6],[17,1,17,4],[22,2,22,3],[13,3,13,6],[14,3,14,6],[20,2,20,3],[17,5,17,6],[18,1,18,4],[18,5,18,6],[25,2,25,3],[29,1,29,4],[26,2,26,3],[24,5,24,6],[25,5,25,6],[26,5,26,6]]}
[]
[]
[]
[]
[null,"Elite® Fire Alarm Voltage Calc Summary Page"]
[]
[]
[null,"Jobsite Name:"]
[null,"Jobsite Address:"]
[null,"Jobsite City, State, Zip:"]
[null,"Jobsite Phone Number:"]
[null,"Jobsite Contact Name:"]
[]
[null,"Control Panel Location",null,"Main Building"]
[null,"Control Panel Node ID",null,"Panel #1"]
[]
[null,"Required Standby Time in Hours (24 OR 60)",null,null,null,24]
[null,"Required Alarm Time in Hours (5 minutes = 0.0833 - 15 minutes = 0.25)",null,null,null,8.3299999999999999E-2]
[null,"Multiply by the Derating Factor",null,null,null,1.2]
[]
[null,"Total Standby Current (Amps)",{"$f":"'Main Panel Calculations'!G60","v":0},null," X     Required Standby Time in Hours=",{"$f":"SUM(C21*F17)","v":0}]
[null,null,null,null," +"]
[null,"Alarm Condition Current (Amps)",{"$f":"SUM('Main Panel Calculations'!J61+'NAC Calculations'!L53)","v":0},null," X     Required Alarm Time in Hours=",{"$f":"SUM(C23*F18)","v":0}]
[]
[null,null,null,null," =      Total Current Load",{"$f":"SUM(F21+F23)","v":0}]
[null,null,null,null," X     The Derating Factor",{"$f":"F19","v":1.2}]
[null,null,null,null," =      Total Ampere Hours Required",{"$f":"SUM(F25*F26)","v":0}]
[]
[null,"System Checks",null,null,null,"Recommended Batteries"]
[null,{"$f":"IF(ROUNDUP(F27,0)>18,\"YOU NEED A SEPARATE BATTERY CABINET TO HOUSE YOUR BATTERIES\",\"THE BATTERIES CAN BE STORED INSIDE THE  FACP.\")","v":"THE BATTERIES CAN BE STORED INSIDE THE  FACP."},null,null,null,{"$f":"IF(F27<=7,\"Two 12 volt 7 ah batteries\",(IF(F27<=12,\"Two 12 volt 12 ah batteries\",(IF(F27<=18,\"Two 12 volt 18 ah batteries\",(IF(F27<=26,\"Two 12 volt 26 ah batteries\",(IF(F27<=33,\"Two 12 volt 33 ah batteries\",\"Power requirement exceeds the limits on this panel\")))))))))","v":"Two 12 volt 7 ah batteries"}]
[null,{"$f":"IF(SUM('NAC Calculations'!L53,0)>=2.5,\"YOU NEED TO USE AN AUXILIARY NAC POWER SUPPLY\",\"Elite FACP CAN HANDLE YOUR NAC POWER REQUIRMENTS.\")","v":"Elite FACP CAN HANDLE YOUR NAC POWER REQUIRMENTS."}]
[]
[]
[null,"TOTAL FIRE ALARM DEVICES",null,null,null,{"$f":"SUM('Main Panel Calculations'!E26:E59)","v":0}]
[]
[null,"ADDITIONAL NAC REQUIREMENTS (Amps)",null,null,null,{"$f":"IF((SUM('NAC Calculations'!L53)<=4),0,('NAC Calculations'!L53-4))","v":0},{"$f":"IF((SUM(#REF!)<=2.5),0,(rng_Total_Notification))","v":{"$error":"#REF!"}}]
[]
[null,"TOTAL NOTIFICATION APPLIANCES NAC 1",null,null,null,{"$f":"SUM('NAC Calculations'!E13:E49)","v":0}]
[null,"TOTAL NOTIFICATION APPLIANCES NAC 2",null,null,null,{"$f":"SUM('NAC Calculations'!F13:F49)","v":0}]
[null,"TOTAL NOTIFICATION APPLIANCES NAC 3 (Not on all FACPs)",null,null,null,{"$f":"SUM('NAC Calculations'!G13:G49)","v":0}]
[null,"TOTAL NOTIFICATION APPLIANCES NAC 4 (Not on all FACPs)",null,null,null,{"$f":"SUM('NAC Calculations'!H13:H49)","v":0}]
[]
[null,"Voltage Drop for NAC Circuit 1",null,null,null,{"$f":"'Voltage Drops'!B12","v":0}]
[null,"Voltage Drop for NAC Circuit 2",null,null,null,{"$f":"'Voltage Drops'!E12","v":0}]
[null,"Voltage Drop for NAC Circuit 3",null,null,null,{"$f":"'Voltage Drops'!B22","v":0}]
[null,"Voltage Drop for NAC Circuit 4",null,null,null,{"$f":"'Voltage Drops'!E22","v":0}]
[]
[null,"VES, LLC hereby disclaims all warranties relating to this software utility, whether expressed or implied, including without limitations any implied warranties of merchantability or fitness for a particular purpose.  VES cannot and will not be liable for any special, incidental, consequential, indirect or similar damages for any reason.  It is the sole responsibility of the user to ascertain the accuracy and the reliability of any and all information generated or provided by this software utility."]

{"sheet":"Main Panel Calculations","index":1,"n_rows":95,"n_cols":13,"rows_kept":95,"cut":false,"hidden":false,"merged":[[60,4,60,7],[91,14,91,15],[69,14,69,15],[80,14,80,15],[3,1,3,9],[5,4,5,5],[5,6,5,9],[14,14,14,17],[7,14,7,18],[9,4,9,6],[9,7,9,9],[9,14,9,17],[10,14,10,17],[12,17,13,17],[7,1,7,9]]}
[]
[]
[]
[null,"Elite® Hochiki Fire Alarm Control Panel Battery Calculation"]
[]
[null,{"$f":"'Job Summary Sheet'!B14","v":"Control Panel Location"},{"$f":"'Job Summary Sheet'!D14","v":"Main Building"},null,{"$f":"'Job Summary Sheet'!B15","v":"Control Panel Node ID"},null,{"$f":"'Job Summary Sheet'!D15","v":"Panel #1"}]
[]
[null,"You have the ability to add/modify devices and their current draws and therefore fully responsible for verifying these calculations. "]
[]
[null,null,null,null,"24 hour Standby Current (S)",null,null,"Alarm Condition Current (A)"]
[null,"Part #","Elite Fire Alarm Control Panel with Releasing - UL 864 9th Edition",null,"Qty","Current Draw","Total ","Qty","Current Draw","Total "]
[null,"VF081x","Control Panel RS, 127 Pt One Loop",null,0,0.2,{"$f":"IF(E12>0,PRODUCT(E12,F12),\"\")","v":""},{"$f":"E12","v":0},0.22,{"$f":"IF(H12>0,PRODUCT(H12,I12),\"\")","v":""}]
[null,"VF082x","Control Panel RS, 254 Pt Two Loop",null,0,0.27,"",0,0.28999999999999998,""]
[null,"VF142x","Control Panel, 254 Pt Two Loop",null,0,0.35499999999999998,"",0,0.65,""]
[null,"VF144x","Control Panel, 508 Pt Four Loop",null,0,0.45500000000000002,"",0,0.76500000000000001,""]
[null,"VF1055-00","DACT Module",null,0,0.02,{"$f":"IF(E16>0,PRODUCT(E16,F16),\"\")","v":""},{"$f":"E16","v":0},0.02,{"$f":"IF(H16>0,PRODUCT(H16,I16),\"\")","v":""}]
[null,"VF1170-00","eNET Interface",null,0,0.04,{"$f":"IF(E17>0,PRODUCT(E17,F17),\"\")","v":""},{"$f":"E17","v":0},0.04,{"$f":"IF(H17>0,PRODUCT(H17,I17),\"\")","v":""}]
[null,"VF1595-00","Guide Software Interface",null,0,7.0000000000000007E-2,"",0,7.0000000000000007E-2,""]
[null,"Part #","Remote Displays & LEDs"]
[null,"VF1172","eVIEW Serial Annunciator",null,0,0.03,{"$f":"IF(E20>0,PRODUCT(E20,F20),\"\")","v":""},{"$f":"E20","v":0},0.11,{"$f":"IF(H20>0,PRODUCT(H20,I20),\"\")","v":""}]
[null,"Part #","Serial Devices"]
[null,"VF1171","16 Channel Input/Output Card (Card Only)",null,0,0.02,{"$f":"IF(E22>0,PRODUCT(E22,F22),\"\")","v":""},{"$f":"E22","v":0},0.02,{"$f":"IF(H22>0,PRODUCT(H22,I22),\"\")","v":""}]
[null,"VF1171","I/O Card Outputs (Add current consumption of all outputs)",null,0,0,{"$f":"IF(E23>0,PRODUCT(E23,F23),\"\")","v":""},{"$f":"E23","v":0},0,{"$f":"IF(H23>0,PRODUCT(H23,I23),\"\")","v":""}]
[null,"VF13XX","eMATRIX 8 LED Base board or 16 LED Expansion Board",null,0,1.2999999999999999E-2,null,0,4.4999999999999998E-2]
[null,"Part #","Analog Addressable Sensors"]
[null,"VF2010-00","Fixed Temperature/Rate of Rise Heat Sensor",null,0,3.5E-4,{"$f":"IF(E26>0,PRODUCT(E26,F26),\"\")","v":""},{"$f":"E26","v":0},5.0000000000000001E-4,{"$f":"IF(H26>0,PRODUCT(H26,I26),\"\")","v":""}]
[null,"VF2011-00","Photoelectric Smoke Sensor",null,0,4.4999999999999999E-4,{"$f":"IF(E27>0,PRODUCT(E27,F27),\"\")","v":""},{"$f":"E27","v":0},5.4000000000000001E-4,{"$f":"IF(H27>0,PRODUCT(H27,I27),\"\")","v":""}]
[null,"VF2012-00","Multi Criteria Sensor",null,0,4.4999999999999999E-4,{"$f":"IF(E28>0,PRODUCT(E28,F28),\"\")","v":""},{"$f":"E28","v":0},5.4000000000000001E-4,{"$f":"IF(H28>0,PRODUCT(H28,I28),\"\")","v":""}]
[null,"VF2014-00","Multi Criteria Smoke/Heat/CO Sensor",null,0,5.9999999999999995E-4,{"$f":"IF(E29>0,PRODUCT(E29,F29),\"\")","v":""},{"$f":"E29","v":0},0.03,{"$f":"IF(H29>0,PRODUCT(H29,I29),\"\")","v":""}]
[null,"VF5013-00","Analog Duct Sensor",null,0,2E-3,{"$f":"IF(E30>0,PRODUCT(E30,F30),\"\")","v":""},{"$f":"E30","v":0},8.0000000000000002E-3,{"$f":"IF(H30>0,PRODUCT(H30,I30),\"\")","v":""}]
[null,null,null,null,0,0,"",0,0,""]
[null,null,null,null,0,0,{"$f":"IF(E32>0,PRODUCT(E32,F32),\"\")","v":""},{"$f":"E32","v":0},0,{"$f":"IF(H32>0,PRODUCT(H32,I32),\"\")","v":""}]
[null,null,null,null,0,0,"",0,0,""]
[null,null,null,null,0,0,{"$f":"IF(E34>0,PRODUCT(E34,F34),\"\")","v":""},{"$f":"E34","v":0},0,{"$f":"IF(H34>0,PRODUCT(H34,I34),\"\")","v":""}]
[null,"Part #","Addressable Modules"]
[null,"VF3001/VF3002","Addressable Pull Station, Single or Dual Action,SIGCOM",null,0,3.39E-4,{"$f":"IF(E36>0,PRODUCT(E36,F36),\"\")","v":""},{"$f":"E36","v":0},3.5799999999999997E-4,{"$f":"IF(H36>0,PRODUCT(H36,I36),\"\")","v":""}]
[null,"VF3029/VF3031/VF3032","Addressable Pull Station, Single or Dual Action,RSG",null,0,5.5000000000000003E-4,{"$f":"IF(E37>0,PRODUCT(E37,F37),\"\")","v":""},{"$f":"E37","v":0},6.6E-4,{"$f":"IF(H37>0,PRODUCT(H37,I37),\"\")","v":""}]
[null,"VF6003-00","Short Circuit Isolator Module",null,0,2.7E-4,{"$f":"IF(E38>0,PRODUCT(E38,F38),\"\")","v":""},{"$f":"E38","v":0},0.01,{"$f":"IF(H38>0,PRODUCT(H38,I38),\"\")","v":""}]
[null,"VF6007-00","Dual Input Contact Module",null,0,5.9999999999999995E-4,{"$f":"IF(E39>0,PRODUCT(E39,F39),\"\")","v":""},{"$f":"E39","v":0},0.03,{"$f":"IF(H39>0,PRODUCT(H39,I39),\"\")","v":""}]
[null,"VF6011-00","Conventional Zone Module",null,0,4.0000000000000002E-4,"",0,4.0000000000000002E-4,""]
[null,"VF6013-00","Fast Response Contact Module with Pigtails",null,0,5.5000000000000003E-4,"",0,6.6E-4,""]
[null,"VF6020/VF6021","Fast Response Contact Module - Class A (No Isolator/Isolator)",null,0,6.3000000000000003E-4,{"$f":"IF(E42>0,PRODUCT(E42,F42),\"\")","v":""},{"$f":"E42","v":0},6.3E-3,{"$f":"IF(H42>0,PRODUCT(H42,I42),\"\")","v":""}]
[null,"VF6024-00","Fast Response Contact Module",null,0,3.39E-4,{"$f":"IF(E43>0,PRODUCT(E43,F43),\"\")","v":""},{"$f":"E43","v":0},3.5799999999999997E-4,{"$f":"IF(H43>0,PRODUCT(H43,I43),\"\")","v":""}]
[null,"VF6040-00","Supervised Output Module (Class A)",null,0,2.2000000000000001E-4,"",0,6.0000000000000001E-3,""]
[null,"VF6041-00","Supervised Output Module w/Isolator (Class A)",null,0,4.2000000000000002E-4,"",0,6.0000000000000001E-3,""]
[null,"VF6052/VF6053/VF6054/VF6055","Dual Relay Module",null,0,3.5E-4,"",0,4.0499999999999998E-4,""]
[null,null,null,null,0,0,"",0,0,""]
[null,null,null,null,0,0,"",0,0,""]
[null,null,null,null,0,0,"",0,0,""]
[null,null,null,null,0,0,{"$f":"IF(E50>0,PRODUCT(E50,F50),\"\")","v":""},{"$f":"E50","v":0},0,{"$f":"IF(H50>0,PRODUCT(H50,I50),\"\")","v":""}]
[null,null,null,null,0,0,{"$f":"IF(E51>0,PRODUCT(E51,F51),\"\")","v":""},{"$f":"E51","v":0},0,{"$f":"IF(H51>0,PRODUCT(H51,I51),\"\")","v":""}]
[null,null,null,null,0,0,"",0,0,""]
[null,"Part #","AUX Powered Devices"]
[null,"VF5014-00","Analog Addressable Duct Sensor with 2 relays ",null,0,0.01,{"$f":"IF(E54>0,PRODUCT(E54,F54),\"\")","v":""},{"$f":"E54","v":0},5.5E-2,{"$f":"IF(H54>0,PRODUCT(H54,I54),\"\")","v":""}]
[null,"VF7005-00","Low Frequency Analog Sounder Base",null,0,1.54E-4,{"$f":"IF(E55>0,PRODUCT(E55,F55),\"\")","v":""},{"$f":"E55","v":0},9.5000000000000001E-2,{"$f":"IF(H55>0,PRODUCT(H55,I55),\"\")","v":""}]
[null,"VF7008-00","Analog Sounder Base",null,0,1.1E-4,{"$f":"IF(E56>0,PRODUCT(E56,F56),\"\")","v":""},{"$f":"E56","v":0},1.7999999999999999E-2,{"$f":"IF(H56>0,PRODUCT(H56,I56),\"\")","v":""}]
[null,null,null,null,0,0,null,0,0]
[null,null,null,null,0,0,null,0,0]
[null,null,null,null,0,0,{"$f":"IF(E59>0,PRODUCT(E59,F59),\"\")","v":""},{"$f":"E59","v":0},0,{"$f":"IF(H59>0,PRODUCT(H59,I59),\"\")","v":""}]
[null,null,"Total Standby Current",null,null,null,{"$f":"SUM(G12:G59)","v":0}]
[null,null,"Total Panel Alarm Current (Without NAC)",null,null,null,null,null,null,{"$f":"SUM(J12:J59)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P39/1000)","v":0},{"$f":"SUM(J64/1000)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P86/1000)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P75/1000)","v":0}]

{"sheet":"NAC Calculations","index":2,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[56,2,56,4],[28,16,28,17],[51,4,51,7],[54,1,54,2],[54,4,54,5],[4,16,4,17],[8,13,8,17],[2,16,2,17],[11,16,11,17],[52,6,52,8],[52,11,52,12],[2,2,2,3],[2,4,2,5],[2,13,2,14],[28,13,28,14],[4,2,4,8],[4,13,4,14],[9,4,9,7],[9,9,9,12],[18,13,18,14],[10,6,10,7]]}
[" NAC Circuit Calculations"]
[]
[]
[]
[null,null,"You have the ability to add/modify devices and current draws and therefore fully responsible for verifying these calculations."]
[null,null," "]
[null,"Control Panel Location:",{"$f":"'Job Summary Sheet'!D14","v":"Main Building"}]
[]
[]
[null,"Part #","Notification Appliances",null,"Notification Appliance Circuits",null,null,null," ","Alarm Condition Per Circuit"]
[null,null,null,null,null,null,"NAC 3 & 4 not on all panels"]
[null,null,null,null,"NAC 1","NAC 2","NAC 3","NAC 4","Alarm Current Draw","NAC 1","NAC 2","NAC 3","NAC 4"]
[null,"VF4000","Commander3 Horn Temp 3 Mechanical",null,0,0,0,0,2.5000000000000001E-2,{"$f":"IF(E13>0,SUM(E13*I13),\"\")","v":""},{"$f":"IF(F13>0,SUM(F13*I13),\"\")","v":""},{"$f":"IF(G13>0,SUM(G13*I13),\"\")","v":""},{"$f":"IF(H13>0,SUM(H13*I13),\"\")","v":""}]
[null,"VF4001","Commander3 Strobe Only 15CD",null,0,0,0,0,0.03,"","","",""]
[null,"VF4001","Commander3 Strobe Only 30CD",null,0,0,0,0,3.5000000000000003E-2,"","","",""]
[null,"VF4001","Commander3 Strobe Only 60CD",null,0,0,0,0,6.6000000000000003E-2,"","","",""]
[null,"VF4001","Commander3 Strobe Only 75CD",null,0,0,0,0,0.08,"","","",""]
[null,"VF4001","Commander3 Strobe Only 110CD",null,0,0,0,0,0.10299999999999999,"","","",""]
[null,"VF4002","Commander3 Horn/Strobe High Volume 15 CD",null,0,0,0,0,5.5E-2,"","","",""]
[null,"VF4002","Commander3 Horn/Strobe High Volume 30 CD",null,0,0,0,0,0.06,"","","",""]
[null,"VF4002","Commander3 Horn/Strobe High Volume 60 CD",null,0,0,0,0,9.0999999999999998E-2,"","","",""]
[null,"VF4002","Commander3 Horn/Strobe High Volume 75 CD",null,0,0,0,0,0.105,"","","",""]
[null,"VF4002","Commander3 Horn/Strobe High Volume 110 CD",null,0,0,0,0,0.128,"","","",""]
[null,"VF4003","Commander4 Strobe Only 30 CD",null,0,0,0,0,0.12,"","","",""]
[null,"VF4003","Commander4 Strobe Only 75 CD",null,0,0,0,0,0.2,"","","",""]
[null,"VF4003","Commander4 Strobe Only 115 CD",null,0,0,0,0,0.28999999999999998,"","","",""]
[null,"VF4004","Commander4 Horn/Strobe 30 CD Temp 3",null,0,0,0,0,0.14199999999999999,"","","",""]
[null,"VF4004","Commander4 Horn/Strobe 75 CD Temp 3",null,0,0,0,0,0.222,"","","",""]
[null,"VF4004","Commander4 Horn/Strobe 115 CD Temp 3",null,0,0,0,0,0.312,"","","",""]
[null,"VF4006","Commander Outdoor Strobe",null,0,0,0,0,0.112,"","","",""]
[null,"VF4007","Commander Outdoor Horn/Strobe Temp 3 Mechanical",null,0,0,0,0,0.13700000000000001,"","","",""]
[null,"VF4027","Low Current Mini-Horn",null,0,0,0,0,1.7999999999999999E-2,"","","",""]
[null,"VF4029","Commander Outdoor Horn Temp 3 Mechanical",null,0,0,0,0,2.5000000000000001E-2,"","","",""]
[null,null,null,null,0,0,0,0,0,{"$f":"IF(E34>0,SUM(E34*I34),\"\")","v":""},{"$f":"IF(F34>0,SUM(F34*I34),\"\")","v":""},{"$f":"IF(G34>0,SUM(G34*I34),\"\")","v":""},{"$f":"IF(H34>0,SUM(H34*I34),\"\")","v":""}]
[null,null,null,null,0,0,0,0,0,"","","",""]
[null,null,null,null,0,0,0,0,0,"","","",""]
[null,null,null,null,0,0,0,0,0,"","","",""]
[null,null,null,null,0,0,0,0,0,"","","",""]
[null,null,null,null,0,0,0,0,0,"","","",""]
[null,null,null,null,0,0,0,0,0,"","","",""]
[null,null,null,null,0,0,0,0,0,"","","",""]
[null,null,null,null,0,0,0,0,0,"","","",""]
[null,null,null,null,0,0,0,0,0,"","","",""]
[null,null,null,null,0,0,0,0,0,"","","",""]
[null,null," ",null,0,0,0,0,0,{"$f":"IF(E45>0,SUM(E45*I45),\"\")","v":""},{"$f":"IF(F45>0,SUM(F45*I45),\"\")","v":""},{"$f":"IF(G45>0,SUM(G45*I45),\"\")","v":""},{"$f":"IF(H45>0,SUM(H45*I45),\"\")","v":""}]
[null,null," ",null,0,0,0,0,0,"","","",""]
[null,null," ",null,0,0,0,0,0,"","","",""]
[null,null," ",null,0,0,0,0,0,"","","",""]
[null,null," ",null,0,0,0,0,0,"","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J13:J49)","v":0},{"$f":"SUM(K13:K49)","v":0},{"$f":"SUM(L13:L49)","v":0},{"$f":"SUM(M13:M49)","v":0}]
[]
[]
[null,null,null,null,null,null,"Total NAC Current",null,null,null,null,{"$f":"SUM(J50:M50)","v":0}]

{"sheet":"Voltage Drops","index":3,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,4],[13,0,13,1],[13,3,13,4],[22,0,22,1],[22,3,22,4],[3,0,3,1],[3,3,3,4],[12,0,12,1],[12,3,12,4]]}
["Voltage Drop Calculations for NAC Circuits"]
["Control Panel Location:",{"$f":"'Job Summary Sheet'!D14","v":"Main Building"}]
[]
["NAC Circuit 1",null,null,"NAC Circuit 2"]
["Total Amps",{"$f":"'NAC Calculations'!J50","v":0},null,"Total Amps",{"$f":"'NAC Calculations'!K50","v":0}]
["Circuit Distance (In Feet) ",400,null,"Circuit Distance (In Feet)",400]
["Wire Size (12, 14, 16, OR 18)",16,null,"Wire Size (12, 14, 16, OR 18)",16]
["Wire Resistance Per 1,000 ft",{"$f":"SUM(IF(B7=12,1.59,(IF(B7=14,2.54,(IF(B7=16,4.02,(IF(B7=18,6.32))))))))","v":4.0199999999999996},null,"Wire Resistance Per 1,000 ft",{"$f":"SUM(IF(E7=12,1.59,(IF(E7=14,2.54,(IF(E7=16,4.02,(IF(E7=18,6.32))))))))","v":4.0199999999999996}]
["Total Wire Resistance (Calculating In & Out)",{"$f":"SUM(B8*((B6*2)/1000))","v":3.2159999999999997},null,"Total Wire Resistance (Calculating In & Out)",{"$f":"SUM(E8*((E6*2)/1000))","v":3.2159999999999997}]
["End of Line Voltage",{"$f":"SUM(B11-(B5*B9))","v":24},null,"End of Line Voltage",{"$f":"SUM(E11-(E5*E9))","v":24}]
["Panel Voltage Output",24,null,"Panel Voltage Output",24]
["Voltage Drop Percentage",{"$f":"SUM(B5*B9)/(B11*100%)","v":0},null,"Voltage Drop Percentage",{"$f":"SUM(E5*E9)/(E11*100%)","v":0}]
[]
["NAC Circuit 3",null,null,"NAC Circuit 4"]
["Total Amps",{"$f":"'NAC Calculations'!L50","v":0},null,"Total Amps",{"$f":"'NAC Calculations'!M50","v":0}]
["Circuit Distance (In Feet)",400,null,"Circuit Distance (In Feet)",400]
["Wire Size (12, 14, 16, OR 18)",16,null,"Wire Size (12, 14, 16, OR 18)",16]
["Wire Resistance Per 1,000 ft",{"$f":"SUM(IF(B17=12,1.59,(IF(B17=14,2.54,(IF(B17=16,4.02,(IF(B17=18,6.32))))))))","v":4.0199999999999996},null,"Wire Resistance Per 1,000 ft",{"$f":"SUM(IF(E17=12,1.59,(IF(E17=14,2.54,(IF(E17=16,4.02,(IF(E17=18,6.32))))))))","v":4.0199999999999996}]
["Total Wire Resistance (Calculating In & Out)",{"$f":"SUM(B18*((B16*2)/1000))","v":3.2159999999999997},null,"Total Wire Resistance (Calculating In & Out)",{"$f":"SUM(E18*((E16*2)/1000))","v":3.2159999999999997}]
["End of Line Voltage",{"$f":"SUM(B21-(B15*B19))","v":24},null,"End of Line Voltage",{"$f":"SUM(E21-(E15*E19))","v":24}]
["Panel Voltage Output",24,null,"Panel Voltage Output",24]
["Voltage Drop Percentage",{"$f":"SUM(B15*B19)/(B21*100%)","v":0},null,"Voltage Drop Percentage",{"$f":"SUM(E15*E19)/(E21*100%)","v":0}]