{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Voltage Drop Calc","Voltage Drop Help"],"not_rendered":{"images":2,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Voltage Drop Calc","index":0,"n_rows":28,"n_cols":12,"rows_kept":28,"merged":[[4,1,4,4],[4,6,4,10],[12,6,12,10],[22,2,22,4],[22,6,26,8],[23,2,23,4],[24,2,24,4],[26,2,26,4]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":4},"Voltage Drop Calculator"]
[]
[]
[null,"General Information",{"$nulls":4},"Wire Run Information"]
[]
[null,null,"Start Voltage",null,"Volts",{"$nulls":3},"Wire Length (One Way)",null,"Feet"]
[null,null,"Temperature",75,"Deg. F.",{"$nulls":3},"Wire Gauge",null,"AWG"]
[null,null,"Allowable Drop",{"v":10,"d":"10.0"},"%",{"$nulls":3},"Current through Wire Run",null,"Amps"]
[]
[null,null,"Low Battery",{"v":10.2,"d":"10.20"},"Volts"]
[]
[{"$nulls":6},"Results"]
[]
[{"$nulls":8},"Wire Resistance",0,"Ohms"]
[{"$nulls":8},"Voltage Drop",{"v":0,"d":"0.00"},"Volts"]
[{"$nulls":8},"End Voltage",{"v":0,"d":"0.00"},"Volts"]
[{"$nulls":8},"% Drop","Error","%"]
[{"$nulls":8},"End Voltage at Low battery",{"v":10.2,"d":"10.20"},"Volts"]
[]
[]
[{"$nulls":6},"Notes:"]
[null,"Job:"]
[null,"Location:"]
[null,"Power Supply ID:"]
[]
[null,"Date:","2010-02-15"]
[{"$nulls":11},"Help"]

{"sheet":"Voltage Drop Help","index":1,"n_rows":21,"n_cols":5,"rows_kept":21,"merged":[[4,1,5,13],[7,2,9,13],[11,2,13,13],[15,2,16,13],[18,2,18,13],[20,2,26,13]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":4},"Help for Voltage Drop Calculator"]
[]
[]
[null,"The Voltage Drop Calculator calculates the voltage through a given wire run based on wire size, length, load current, and other factors."]
[]
[]
[null,"Step 1:  ","Enter the starting voltage, ambient temperature in degrees fahernheit, and allowable voltage drop in percentage into the cells in the \"General Information\" box.  Use 75 degrees if the ambient temperature is not known."]
[]
[]
[]
[null,"Step 2:  ","Enter the wire length in feet, wire gauge in AWG, and current drawn through the wire in amps into the \"Wire Run Information\" box.  The wire length should be entered as a \"one way\" length and should not be doubled to account for source and return wires."]
[]
[]
[]
[null,"Step 3:  ","Click the blue \"Calculate\" button.  The results appear in the \"Results\" box.  The \"End Voltage at Low Battery\" cell gives the voltage the load will see when the battery set is fully discharged (by UL definition)."]
[]
[]
[null,"Note:","This calculator is intended for use with solid wire only."]
[]
[null,"Note:","This calculator assumes one bulk load at the end of the wire run.  Distributed loads (with loads at different points along the wire run) can be calculated one of two ways with this calculator.  The voltage drop can be calculated as if the entire load is at the end of the wire run, however this will give a much higher voltage drop than you will see in the real world.  The other method involves breaking the wire run into sections, each calculated independently.  The entire current will be drawn through the first section.  For the second section, the first load value will be subtracted from the total load and the ending voltage of the first section will be used as the starting voltage.  This will be continued until all sections are calculated."]