Torque Factors, Kinematics, and Dynamometer Analys...

This Excel workbook has a spreadsheet page for the four common pumping units (Conventional, Mark II, Air Balanced, and Reverse Mark) and a page that can be used to compare the motion of the four types. Each page is protected so that only the data input cells can be changed. Each page can be used a variety of ways based on Chapter 8.

• As a torque factor and motion calculator. By entering the measurements for a given pumping unit plus the pumping speed and the direction of crank rotation the torque factors, polished rod position, velocity, and acceleration are computed for every 5 degrees of crank rotation. The polished rod position, velocity, and acceleration are plotted versus crank angle.
• As a dynamometer calculator. In addition to part (1) if the polished rod load at every 5 degrees of crank rotation and the effective counterbalance at 90 degrees can be input from a dynamometer then the gear box torque is computed and plotted. The polished rod dynamometer shape is also plotted and compared to permissible loads that represent the maximum gear box torque or beam rating. The counterbalance can be adjusted to determine the best balance for the unit and to see what difference the new balance makes to the gear box torque.