This script provides code for pop up windows.
How to Order XLRotor
Support for XLRotor

From my own experience,
in creating XLRotor I wanted a comprehensive analysis tool for rotordynamics where user productivity is paramount. It was absolutely essential that the program execute lightning fast, be extremely easy to use, and avoid the use of model size reduction so as to always deliver maximum accuracy.

I’m confident that engineers who use XLRotor will be very pleased with the software and the results it delivers.

—Dr. Brian T. Murphy, PhD, PE




The following files are provided free of charge.

Rotordynamics Engineering Utilities

Several programs which you might find educational and useful are available for free download. The first three are MathCAD balancing programs for single speed influence coefficient balancing. You type in original vibration vectors, vibration vectors with trial weights added, and the trial weights themselves, and the correction weights are computed automatically. The 4th file is a MathCAD file of 2 plane multispeed least squares balancing, where the response data is read from data files. Since these are MathCAD documents, all the formulas are displayed which greatly aids in understanding exactly what the program is doing. There is also a document for calculating the split of a desired balance weight between two locations (e.g., holes). All these documents should work with all MathCAD versions 6 or later, on a PC or Macintosh (except the least squares one, PC only, version 7 or later).

The following zip file contains an Excel workbook with spreasheets for single plane rotor balancing by the 4-run method without phase, plus single-plane and two-plane balancing by the influence coefficient method. The 4-run and single-plane I.C. sheets do not use visual basic macros. The two-plane sheets do use a visual basic macro to perform the balancing calculations.

  • (75,526 bytes. Right-click, and go to Save File, or Save Target).

The following Excel workbook file contains a data base of common bearing lubricants, with density and viscosity and thermal properties. The file also displays graphs of these properties versus temperature.

Excel Related Tools and Sites

Chartool is a utility for Excel xy scatter charts which provides:
  • Enhanced mouse cursor
  • Zoom and pan of chart scales
  • Copy/paste chart scales between charts
  • Edit all series formats for one or more charts

To download Chartool, click here ( 177,496 bytes, last updated December 28, 2012). This zip file contains one Excel addin file, and one Word document. Chartool works with Excel 2003 or later. The VBA source code is viewable within the addin.

FindInFiles is a utility for Excel VBA development which searches the currently active VBA project for a string, and lists all lines containing the string (along with module name, routine name, and line #). You can then double click a line in the list to jump to that line. This allows searching for strings at the start and end of lines which the Excel VBE cannot do. Download by clicking here ( 63,394 bytes, last updated Aug 27, 2003). This zip file contains one Excel addin file. The VBA source code is viewable within the addin.

Smooth_curve_bezier_example_file.xls solves one of the long standing mysteries of Excel. This file demonstrates that it is possible to compute a curve that matches the one Excel draws for its "smooth curve" feature on xy scatter charts. This algorithm is also used in Chartool to enable its cursor to follow Excel's smooth curve. Download by clicking here ( 23,750 bytes, last updated Mar 15, 2003).

There are a great many other outstanding Excel specific sites on the web. Here are links to some that have helped a great deal in the development of XLRotor.

John Walkenbach's site includes a very complete list of Excel related sites of all kinds:

Rob Bovey's company, Application Professionals, site includes several free utilities:

Stephen Bullen's site: Office Automation, Ltd..

    Contact      Privacy Policy 2014 Rotating Machinery Analysis, Inc. All rights reserved.


Rotating Machinery Analysis, Inc.
36 Amayi Court, Brevard, NC 28712
Ph: 512.592.7606 Fax: 512.918.9140
Untitled Document