{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Charging Requirements","Daily intermitent useage","Pull down list"],"not_rendered":{"images":1,"external_links":1,"defined_names":7,"comments":34},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Charging Requirements","index":0,"n_rows":624,"n_cols":6,"rows_kept":624,"merged":[[0,2,0,5],[1,4,5,5],[7,2,7,4],[8,2,8,4],[9,2,9,4],[11,2,11,5],[12,2,12,5],[14,0,14,3],[20,2,20,3],[22,2,22,3],[24,2,24,3],[25,2,25,4],[26,0,26,3],[32,2,32,3],[33,2,33,3],[34,2,34,4],[37,3,37,4],[38,3,38,4],[40,2,40,4],[43,3,43,4],[44,3,44,4],[46,2,46,4],[49,2,49,3],[50,2,50,4],[54,4,54,5],[55,4,55,5],[59,4,59,5],[60,4,60,5],[67,1,69,1],[67,3,69,3],[67,5,69,5],[77,1,80,1],[77,3,80,3],[77,5,80,5],[81,3,81,4],[82,1,84,4]],"flags":["formulas_cached_only"]}
[null,null,"DB1 Load Calculation Worksheet"]
[{"$nulls":4},"PGI Division - Parker Hannifin\n16101 Vallen Drive\nHouston, TX  77041\nwww.parker.com/pgi"]
[]
[]
[]
[]
["Date:"]
["Customer:"]
["Location:"]
["Tag ID:"]
[]
[null,null,"Red triangles indicate input tips and help"]
[null,null,"NOTE: Enter required values into yellow fields"]
[]
["Step 1: Determine the Intermittent Power Requirements"]
[null,"Description [i.e. radio]","Electrical Load (Amps)","Hours/Day","AmpHours/ Day"]
["Load 1",{"$nulls":3},{"v":0,"d":"0.000"}]
["Load 2",{"$nulls":3},{"v":0,"d":"0.000"}]
["Load 3",{"$nulls":3},{"v":0,"d":"0.000"}]
[]
[null,null,"Total Daily Intermittent AmpHours/Day",null,"=",{"v":0,"d":"0.000"}]
[]
[null,null,"Total Average Intermittent Amp required",null,"=",{"v":0,"d":"0.000"}]
[]
[null,null,"System Voltage (VDC)  =  ",null,12]
[null,null,"Intermittent Watts required  =  ",null,null,". Watts"]
["Step 2: Determine the Constant Power Requirements"]
[null,"Description [i.e. flow computer]","Electrical Load (Amps)","Number of devices","Amp/Day"]
["Load 1",{"$nulls":3},{"v":0,"d":"0.000"}]
["Load 2",{"$nulls":3},{"v":0,"d":"0.000"}]
["Load 3",null,null,0,{"v":0,"d":"0.000"}]
[]
[null,null,"Total Constant Amps required",null,"=",{"v":0,"d":"0.000"}]
[null,null,"System Voltage (VDC)  =  ",null,12]
[null,null,"Constant Watts required  =  ",null,null,". Watts"]
[]
["Step 3: Combine Intermittent and Constant Current Requirements"]
[{"$nulls":3},"Intermittent Load (Amps)  =  ",null,{"v":0,"d":"0.000"}]
[{"$nulls":3},"Constant Load (Amps)  =  ",null,{"v":0,"d":"0.000"}]
[]
[null,null,"Total Load  =  ",null,null,". Amps"]
[]
["Step 4: Combine Intermittent and Constant Power Requirements"]
[{"$nulls":3},"Intermittent (Watts)  =  ",null,{"v":0,"d":"0.000"}]
[{"$nulls":3},"Constant (Watts)  =  ",null,{"v":0,"d":"0.000"}]
[]
[null,null,"Total Watts @ 68oF (20oC) Ambient Temp.  =  ",null,null,". Watts"]
[]
["Step 5: Apply Safety Factor to Charging Requirements.  PGI recommends a minimum safety factor of 10%:"]
[null,null,"Safety Factor  =  ",null,{"v":0.1,"d":"10%"}]
[null,null,"Combined load and safety factor requirements  =  ",null,null,". Watts"]
[]
["Step 6: Battery Capacity"]
[]
[null,"Avg. Load (Amps)","Battery Reserve (Days)","24Hrs/Day","Battery Capacity (A/Hr)"]
[null,{"v":0,"d":"0.000"},null,24,0]
[]
["Step 7: Approximate* Discharge Cycle Time"]
[]
[null,"% of Discharge","Battery Capacity (A/Hr)","Avg. Load (Amps)","Discharge Cycle Time (Hrs)"]
[null,{"v":0.2,"d":"20%"},0,{"v":0,"d":"0.000"},""]
[]
["Step 8: Approximate* Charge Cycle Time"]
[]
["10 Watts",null,"20 Watts",null,"50 Watts"]
["Discharge Cycle Time (Hrs)","","Discharge Cycle Time (Hrs)","","Discharge Cycle Time (Hrs)",""]
["Charge Cycle Time (Hrs)","","Charge Cycle Time (Hrs)","","Charge Cycle Time (Hrs)",""]
[null,"",null,"",null,""]
[]
[]
[]
["Step 9: Approximate* Total Cycle Time"]
[]
["10 Watts",null,"20 Watts",null,"50 Watts"]
["Discharge Cycle Time (Hrs)","","Discharge Cycle Time (Hrs)","","Discharge Cycle Time (Hrs)",""]
["Charge Cycle Time (Hrs)","","Charge Cycle Time (Hrs)","","Charge Cycle Time (Hrs)",""]
["Total Cycle Time (Hrs)","","Total Cycle Time (Hrs)","","Total Cycle Time (Hrs)",""]
[null,"",null,"",null,""]
[]
[]
[]
[]
[null,"* Values are meant to give approximate cycle times in ideal conditions and temperature. Actual cycle times will vary based on actual operating conditions and overall battery health."]
{"$rows_empty":532}
[null,null,10]
[null,{"v":0.1,"d":"10%"},20]
[null,{"v":0.2,"d":"20%"}]
[null,{"v":0.3,"d":"30%"}]
[null,{"v":0.4,"d":"40%"}]
[null,{"v":0.5,"d":"50%"}]
[null,{"v":0.6,"d":"60%"}]
[null,{"v":0.7,"d":"70%"}]
[null,{"v":0.8,"d":"80%"}]

{"sheet":"Daily intermitent useage","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[0,2,2,6],[14,4,14,6]],"flags":["formulas_cached_only"]}
["Daily Intermittent Load Calculations",null,"Enter load duration and how often the loads takes place.\nThen enter Hours / Day into the Charging Requirements worksheet"]
[]
[]
[]
[]
[{"$nulls":5},"Load on:","Times a day","Hours / Day"]
["Load is on for ",0,"second(s) for",0,"times a Minute."," ","0 ","0.0000 "]
[]
["Load is on for ",0,"second(s) for",0,"times a Hour.","",0,"0.0000"]
[]
["Load is on for ",0,"second(s) for",0,"times a Day."," ",0,"0.0000"]
[]
[]
[]
[{"$nulls":4},"Click to return to Charging Requirements Worksheet"]

{"sheet":"Pull down list","index":2,"n_rows":17,"n_cols":4,"rows_kept":17,"hidden":true,"flags":["formulas_cached_only"]}
[]
["System Voltage",null,null,12]
[{"$nulls":3},24]
[]
[]
["Safety Factor",null,null,{"v":0.3,"d":"30%"}]
[{"$nulls":3},{"v":0.4,"d":"40%"}]
[{"$nulls":3},{"v":0.5,"d":"50%"}]
[{"$nulls":3},{"v":0.6,"d":"60%"}]
[{"$nulls":3},{"v":0.7,"d":"70%"}]
[{"$nulls":3},{"v":0.8,"d":"80%"}]
[{"$nulls":3},{"v":0.9,"d":"90%"}]
[{"$nulls":3},{"v":1,"d":"100%"}]
[]
[{"$nulls":3},"mA"]
[{"$nulls":3},"Amps"]
["Amps"]