[en] Using the transfer matrix method, we created the Excel worksheet ''Beam'' for analyzing vibrations in centrifugal contactors. With this worksheet, a user can calculate the first natural frequency of the motor/rotor system for a centrifugal contactor. We determined a typical value for the bearing stiffness (k_B) of a motor after measuring the k_B value for three different motors. The k_B value is an important parameter in this model, but it is not normally available for motors. The assumptions that we made in creating the Beam worksheet were verified by comparing the calculated results with those from a VAX computer program, BEAM IV. The Beam worksheet was applied to several contactor designs for which we have experimental data and found to work well