{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":1000,"n_cols":26,"rows_kept":1000,"cut":false,"hidden":false,"merged":[[4,5,4,6],[5,5,5,6],[6,5,6,6],[7,5,7,7],[9,5,9,6],[66,7,66,8],[66,9,66,11],[77,1,77,2],[36,2,36,3],[21,2,21,4],[23,7,23,10],[24,6,24,9],[25,6,25,9],[26,8,26,9],[28,7,28,9],[29,7,29,9],[30,7,30,9],[31,7,31,9],[32,7,32,9],[35,2,35,3],[46,2,46,4],[55,7,55,10],[56,6,56,12],[65,7,65,8],[65,9,65,11],[552,3,552,4],[0,0,0,12],[50,6,50,7],[51,6,51,7],[536,3,536,4],[539,3,539,4],[543,3,543,4],[544,3,544,4],[547,3,547,4],[549,3,549,4],[67,7,67,8],[67,9,67,11],[68,7,68,8],[68,9,68,11],[533,3,534,4],[535,3,535,4]]}
["Misc. Power Take-Off  Calculations"]
[]
[null,"Customer"]
[null,"Make Model:",null,null,"Contact Info"]
[null,"Serial No. / VIN:",null,null,"First Name:"]
[null,"Engine:",null,null,"Last Name:"]
[null,"Transmission:",null,null,"Phone"]
[null,"Equipment:",null,null,"E-Mail:"]
[null,"Truck Application: "]
[null,"Desired PTO Operation",null,null,"Allison Voc. Pkg:"]
[null,"Number of PTO"]
[null,"PTO ID",null,null,"Driveshaft PTO",null,"PTO Priority"]
[null,"Clutch Dependent",null,null,"Engagement Requirements",null,"Drop Out Requirements"]
[null,"Desired PTO Speed ",null,"RPM","Park Brake Applied",null,"Park Brake Released"]
[null,"Minimum Engine Set Speed",null,"RPM","Clutch Released",null,"Clutch Pedal Pushed"]
[null,"Maximum Engine Set Speed    ",null,"RPM","Cruise Switch On",null,"Cruise Switch Off"]
[null,"Minimum Road Speed ",null,"MPH","Disable TPS"]
[null,"Maximum Road Speed  ",null,"MPH","PTO Switch On",null,"PTO Switch Off"]
[null,"Jump to Speed  ",null,"RPM","Serv. Brake Released",null,"Serv. Brake Applied"]
[]
[]
[null,null,"Miscellaneous Calculation"]
[null,null,"Fill in white boxes with known data and Green boxes will populate with answer"]
[null,"Constant Demands ",null,null,null,null,null,"Engine Speed Requirements"]
[null,null,"Power (HP)","P=",{"$f":"IF(E38=0,0,E38)","v":0},"HP","Required PTO Drive-line Speed",null,null,null,null,"RPM"]
[null,null,"Equipment Flow Demand","Q= ",null,"GPM","PTO Speed Ratio",null,null,null,null,"%"]
[null,"Selectable Variables","Maximum pressure","p=",null,"psi",null,null,"Engine Speed",null,{"$f":"IF(K26=0,0,K25/K26)","v":0},"RPM"]
[null,null,"PTO Ratio","Z=",null,"Ratio"]
[null,null,"Pump Size ","D=",null,"cu.in. / rev.",null,"Pump Displacement Calculation",null,null,{"$f":"IF(E26=0,0,E26*231/(E28*E30))","v":0},"D > Dreq."]
[null,null,"Engine Working Speed ","Neng=",null,"RPM",null,"Torque Calculation",null,null,{"$f":"IF(E29=0,0,E29*E27)/74","v":0},"lb-ft"]
[null,null,"Torque","T=",{"$f":"E29*E27/74","v":0},"lb-ft",null,"Power Calculation",null,null,{"$f":"IF(E26=0,0,E26*E27)/1680","v":0},"HP"]
[null,null,"Maximum Pump Speed","Np=",{"$f":"(E30*E28)","v":0},"RPM"]
[null,null,null,null,null,null,null,"Misc. Converters"]
[null,"PTO HP Calculator",null,null,null,null,null,null,"cc/Rev","cu in/Rev","G/Rev"]
[null,null,"To determine the PTO output HP at the required speed.",null,null,null,null,null,null,{"$f":"I35*0.061024","v":0},{"$f":"I35/3785.411784","v":0}]
[null,null,"Output Torque Rating",null,null,"Lbs. Ft.",null,null,"MPH","KPH"]
[null,null,"PTO Drive-line Speed",null,null,"RPM",null,null,null,{"$f":"I37*1.609344","v":0}]
[null,null,null,null,{"$f":"(E36*E37)/5252","v":0},"HP ",null,null,{"$f":"(J38/1.609344)","v":0}]
[null,"Torque Calculation",null,null,null,null,null,null,"PSI","KPA"]
[null,null,"Torque","T",null,"Lbs. Ft.",null,null,null,{"$f":"I40/0.145037738","v":0}]
[null,null,"Power (HP)","P",null,"HP ",null,null,{"$f":"J41*0.145037738","v":0}]
[null,null,"PTO Ratio (in decimals) ","Z",null,"%"]
[null,null,"Engine Speed","Neng",null,"RPM",null,null,"CFM","m3/min"]
[null,null,"Maximum Torque Permitted","Tperm",{"$f":"IF(E41=0,0,(E41*5252)/(E42*E43))","v":0},"Lbs. Ft.",null,null,null,{"$f":"(I44/35.32)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"J45*35.32","v":0}]
[]
[null,null,"Blower Applications"]
[null,null,"Pressure Requirements","PSI",null,"PSI",null,null,"Engine Speed",null,null,"RPM"]
[null,null,"Cu.Ft. per Minute","CFM",null,"CFM",null,null,"PTO Ratio",null,null,"%"]
[null,null,"Vacuum","In HG",null,"IN. HG",null,null,"Pump / PTO Speed",null,{"$f":"IF(K48=0,0,K48*K49)","v":0},"RPM"]
[null,null,"Blower speed","RPM",null,"RPM","Available mDrive PTO Ratios"]
[null,null,null,null,null,null,null,null,"Pump /  PTO Speed",null,null,"RPM"]
[null,null,null,null,null,null,null,null,"PTO Ratio",null,null,"%"]
[null,null,null,null,null,null,null,null,"Engine Speed",null,{"$f":"IF(K52=0,0,K52/K53)","v":0},"RPM"]
[]
[null,null,null,null,null,null,null,"Calculation of Pump Bending Moment"]
[null,null,null,null,null,null,"Mb Bending moment at pump connection to power take-off (Nm)"]
[null,null,null,null,null,null,"m Pump weight (kg)","LBS"]
[null,null,null,null,null,null,"g Standard gravity = 9.81 N/kg. "]
[null,null,null,null,null,null,"A Distance between pump center of gravity an anchorage on Power Take Off (m)"]
[null,null,null,null,null,null,null,"m",null,"(kg)"]
[null,null,null,null,null,null,null,"g",9.81,"N/kg"]
[null,null,null,null,null,null,null,"A",null,"(m)"]
[null,null,null,null,null,null,"Bending Moment",null,{"$f":"(I61*I62*I63)","v":0},"Nm"]
[]
[null,null,null,null,null,null,null,"PTO",null,"Maximum Bending Moment"]
[null,null,null,null,null,null,null,"PTR",null,"40 Nm * "]
[null,null,null,null,null,null,null,"PTRD",null,"40 Nm *"]
[]
[null,null,null,null,null,null,null,"Convert Nm to ft/lb and or convert ft/lb to Nm"]
[null,null,null,null,null,null,null,null,"Nm",{"$f":"IF(H71=0,0,H71*0.73756)","v":0},"ft/lb"]
[null,null,null,null,null,null,null,{"$f":"IF(J72=0,0,J72*1.3556)","v":0},"Nm",null,"ft/lb"]
[]
[null,null,null,null,null,null,null,"Convert  lb to Kg and or Convert Kg to lb"]
[null,null,null,null,null,null,null,null,"lb",{"$f":"H75*0.45359237","v":0},"Kg"]
[null,null,null,null,null,null,null,{"$f":"J76/0.45359237","v":0},"lb",null,"Kg"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"V9.1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Pick from List"]
[null,"PTO 0","Automated Side Loader (ASL)"]
[1,"PTO 1","Ambulance"]
[2,"PTO 2","Aerial Bucket Truck"]
[3,"PTO 3","Auger Post-hole digger"]
[4,"PTO 4","Crane Truck"]
[null," ","Concrete Mobile Batch Mixer"]
[null,"Yes","Concrete Mixer"]
[null,"No","Concrete Pumper"]
[null,null,"Defense / Military "]
[null,null,"Dump Truck"]
[null,null,"Line Painter"]
[null,"1-2-3-4","Oil Field Application"]
[null,"2-3-4-1","Refuse Front Loader"]
[null,"3-4-1-2","Refuse Rear Loader"]
[null,"4-1-2-3","Sewer / Vacuum"]
[null,null,"Telebelts / Loop Belt"]
[null,null,"Tow Truck"]
[null,null,"Tractor with Pump or Blower"]
[null,null,"Other"]
[]
[null,null,"Pick from List"]
[null,null,"Allison Transmission ","PTO Position"]
[null,null,"3000 RDS","side / side 4, 8 o'clock            top / side 1 and 8 o'clock",null,"B","Bus Series"]
[null,null,"3500 RDS",null,null,"EVS","Emergency Vehicle Series"]
[null,null,"4000 EVS","1 and 8 o'clock",null,"HS","Highway Series"]
[null,null,"4000 HS","No PTO Provision",null,"MH","Motor Home Series"]
[null,null,"4000 MH",null,null,"OFS","Oil Fiels Series"]
[null,null,"4000 ORS",null,null,"OFR","Off Road Series"]
[null,null,"4000 RDS","1 and 8 o'clock",null,"RDS","Rugged Duty Series"]
[null,null,"4000 SP",null,null,"SP","Specialty Series"]
[null,null,"4000 TRV"]
[null,null,"4430 OFS",null,null,"Base Model"]
[null,null,"4500 EV","1 and 8 o'clock",null,3000,"Close Ratio Models"]
[null,null,"4500 HS","No PTO Provision",null,3500,"Wide Ratio Models"]
[null,null,"4500 OFS",null,null,4000,"Close Ratio Models"]
[null,null,"4500 ORS",null,null,4500,"Wide Ratio Models"]
[null,null,"4500 RDS","1 and 8 o'clock",null,4700,"Deep Ratio Models 7 Speed"]
[null,null,"4500 SP"]
[null,null,"4700 EVS","1 and 8 o'clock"]
[null,null,"4700 OFS"]
[null,null,"4700 ORS"]
[null,null,"4700 RDS","1 and 8 o'clock"]
[null,null,"4700 SP"]
[]
[null,null,"Eaton"]
[null,null,"RTX-13609B                     ",null,0.6]
[null,null,"RTX-14609B ",null,0.77]
[null,null,"RTX-16709B  ",null,0.93]
[null,null,"FRO-12210C ",null,0.98]
[null,null,"FRO-13210B  ",null,1.06]
[null,null,"FRO-13210C  ",null,1.18]
[null,null,"FRO-14210B ",null,1.3]
[null,null,"FRO-14210C   ",null,1.35]
[null,null,"FRO-15210B    ",null,1.65]
[null,null,"FRO-15210C ",null,1.72]
[null,null,"FRO-16210B  ",null,2.1]
[null,null,"FRO-16210C   "]
[null,null,"FRO-18210C "]
[null,null,"RTO-14908LL"]
[null,null,"RTO-16908LL  "]
[null,null,"FR-13210B  "]
[null,null,"FR-14210B"]
[null,null,"RTO-14910B-AS3  "]
[null,null,"RTO-14910C-AS3 "]
[null,null,"RTO-16910B-AS3"]
[null,null,"RTO-16910C-AS3"]
[null,null,"RTO-18910B-AS3 "]
[null,null,"RTO-14910B-DM3"]
[null,null,"RTO-16910B-DM3  "]
[null,null,"RTO-14909ALL "]
[null,null,"RTO-16909ALL"]
[null,null,"RTLO-14913A "]
[null,null,"RTLO-16913A  "]
[null,null,"RTLO-18913A  "]
[null,null,"RTLO-20913A "]
[null,null,"RT-14915    "]
[null,null,"RTO-14915"]
[null,null,"RTO-16915  "]
[null,null,"RTLO-14918A-AS3 "]
[null,null,"RTLO-16918A-AS3   "]
[null,null,"RTLO-14918B "]
[null,null,"RTLO-16918B     "]
[null,null,"RTLO-18918B  "]
[null,null,"RTLO-20918B  "]
[null,null,"RTLO-18918A-AS3 "]
[null,null,"RTLO-20918A-AS3 "]
[]
[null,null,"Mack"]
[null,null,"T306G      "]
[null,null,"TM308          "]
[null,null,"TM308M       "]
[null,null,"TM309                "]
[null,null,"TM309M         "]
[null,null,"T309              "]
[null,null,"T309LR      "]
[null,null,"T310        "]
[null,null,"T310M     "]
[null,null,"T310ME    "]
[null,null,"T310ME21     "]
[null,null,"T310MLR       "]
[null,null,"T313   "]
[null,null,"T313 LR   "]
[null,null,"T313 LR  21     "]
[null,null,"T318      "]
[null,null,"T318LR      "]
[null,null,"T318LR  21    "]
[null,null,"T31821       "]
[null,null,"TmD12AD      "]
[null,null,"TmD12AO       "]
[null,null,"TMD13AFD-HD"]
[null,null,"TMD13AFO-HD"]
[null,null,"TMD14AFO-HD"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Misc_PTO_CALC"]