Copyright: Copyright ©, RMA, Inc.


Beams Worksheet
Beams Worksheet       [image]      About this worksheet


Beams worksheet about box
About the Beams Worksheet

This is the "Beams" worksheet.  This is an "output" worksheet since it shows a table of values computed for each of the beams on the "Shaft Input" worksheet.

You can simply type in any units in the column headings conforming to any consistent set you prefer.


Brg's Worksheet
Brg's Worksheet       [image]      About this worksheet


C chart
A chart of the damping coefficients is generated automatically on a separate sheet.  As with all Excel charts, it can be easily copied to a word processor document.


Contents
XLRotor Demo Contents

How to Operate the Demo
Overview of XLRotor
Go to the XLRotor Worksheet
Go to the XLJrnl Worksheet
List of All Topics In this Demo
How to Order XLRotor

Click on a picture


Contents a
TM

Welcome to the XLRotor Tour

Spreadsheets for Rotordynamic Analysis

Analysis of rotors has never been this convenient,

this easy, or this powerful.


Curve Fits Worksheet
This is the "Curve Fits" worksheet, where you perform polynomial curve fits of the stiffness and damping values, versus rotor speed.  There are two input cells, for specifying the starting power and degree of the curve fits.  Clicking the "Update Curve Fits" button causes the curve fits to be recalculated from the current stiffness and damping values appearing on the previous worksheet.


Ending
TM

Thank you for viewing the XLRotor Demo

XLRotor is the best and easiest way to perform

rotordynamic analyses of real world rotor/bearing systems

For more information, you can reach RMA, Inc by

phone, fax, email or regular mail

email: info@xlrotor.com


Geo Plot
Geometry Chart       [image]      About this chartsheet


Geo plot about box
About the Geo Plot Chartsheet

This "Geo Plot" sheet is an example of an Excel chartsheet.  This one shows the geometry of the rotor model.  Note that bearings are conveniently depicted as springs.  If the rotor model contains any added weights, they can also be shown on the chart.  For the added weights, there is an option in the Options|General dialog box for whether to show them here on the geometry chart.

One the handiest features of XLRotor is that you can customize the formats of the charts using all of the formatting controls available in Excel (and there are many).  You can change colors, axis titles, line thickness, grid appearance, symbols, add company logos, etc.  The list is practically endless.


How To Operate the Demo

This demo is a hypertext document in the vein of a standard Windows Help File.  At the heart of the demo is a series of screens which show an XLRotor rotor model file as it actually appears within Microsoft Excel.  Also part of the demo are screens showing an XLJrnl file.  XLJrnl is used to model standard hydrodynamic journal bearings, and this type of file would be "Linked" to the rotor model file to form a complete rotor/bearing model.

If you are not familiar with Windows help files, go to the Help menu now and select How to Use Help.  Or, if you want to get started right away, here's a brief list of ways to move around the demo file.

Moving Around The Demo

You can move around the demo as you would any Windows help file.

Click on the Contents button show above (or press C)

Click on the Next or Previous browse buttons (or press N or P)

Click on the Back button (or press B)

Click on Jump hot spots (solid underlined phrases)

Click on Popup hot spots (dashed underlined phrases)

Click on graphic hot spots (regions on pictures, both jumps and popups)

Click on the See Also popup for a list of related topics

Or click one of these buttons now


How to Order XLRotor
How to Order XLRotor  (use the File|Print command to print this form)

The XLRotor package includes the rotor analysis module, and all bearing modules described in this demo.  Phone and email support and software upgrades are included for 12 months from the date of purchase.  Support beyond the first year will cost 10% per year of the going price of XLRotor.

To order XLRotor please email or fax a request for a quotation.  Specify the number of licenses you desire, and to where you would like them delivered.  Discounts are available for purchases of multiple licenses.  Educational institutions get a 50% discount on commercial prices.

To upgrade XLRotor: for existing users an upgrade to the latest release of version 3 is $1000 (US)+shipping.  This is only necessary if you don't have a 12 month maintenance term in place.  A Texas state sales tax of 8.25% may apply if your delivery address is in Texas.

Please fax your quotation request to 512-918-9140, or send it by email.

Your Name  ______________________________________________

Title  ____________________________________________________

Department  ______________________________________________

Company Name  __________________________________________

Address1 ________________________________________________

Address2 ________________________________________________

Country _________________________

Number of licenses  __________

We accept company purchase orders.  Payment can be by check drawn on a US bank, or wire transfer.  We presently do not accept credit cards.


Imb's Worksheet
Imb's Worksheet       [image]      About this worksheet


K chart
A chart of the stiffness coefficients is generated automatically on a separate sheet.  As with all Excel charts, it can be easily copied to a word processor document.


List of All Topics In this Demo

Contents

How To Operate the Demo

Overview of XLRotor

XLRotor Worksheet

Shaft Input Worksheet

Beams Worksheet

Stations Worksheet

Geometry Plot

Brg's Worksheet

Roots Damped Worksheet

Roots UCS Worksheet

Shapes Worksheet

Imb's Worksheet

Response Worksheet

XLJrnl Worksheet

How to Order XLRotor


Overview of XLRotor

(click on an element of the picture for more information)

XLRotor consists of; a collection of Excel workbook templates, an Excel Addin file of custom macros, and Windows Dynamic Link Libraries (DLL).

Using the various templates, you set up a model of a rotating machine, and set up bearings and seals for their stiffness and damping.  Rotors, bearings and seals are in separate files which are linked together.  With the click of the mouse, you then analyze the complete system for critical speeds, stability, mode shapes, imbalance response, or operating deflected shapes.  The analysis results are appended to the rotor model workbook file, and are saved in that file, along with the rotor model.

XLRotor has a pull down menu which provides access to all the features of XLRotor.  These range from setting and changing options and running the analyses, to manipulating the results.

Everything is done within the Excel environment - from setting up your inputs to viewing the results.  The entire process is incredibly easy and fast.  Input and output formats can be user customized.  Plots are especially easy to customize, and are easily copied to any Windows word processor.  The benefits of using a full featured spreadsheet program as the working environment are practically endless.


Response Worksheet
Response Worksheet       [image]      About this worksheet


Roots Damped Worksheet
Roots Damped Worksheet       [image]      About this worksheet


Roots UCS
Roots UCS Worksheet       [image]      About this worksheet


Shaft Input
Shaft Input Worksheet       [image]       About this worksheet


Shaft Input about box
About the Shaft Input Worksheet

This is the "Shaft Input" worksheet.  This is where you enter parameters to define your rotor model.  The rotor model is made up of stations.  Each station is made up of beams, and, optionally, an added concentrated weight.

A special feature unique to XLRotor is that you can define as many beams as desired for any and all stations.  You also get to define the material properties separately for each and every beam.  This provides virtually unlimited flexibility for constructing accurate rotor models in the easiest way possible.  You'll never again have to combine multiple layers of different materials to get effective densities and moduli.  XLRotor does the work for you.

Entering your data values into this table is quick and easy thanks to an incredible assortment of convenience features in Excel.  Like copying and pasting, inserting and deleting rows, and using cell formulas to have the values in one cell be computed from values in other cells (that one is especially useful).

You can change the units in the column headings on this worksheet to any units you prefer by simply typing them in to replace those shown.  All you need to be sure of is that you stick to a consistent set of units.  On the "XLRotor" worksheet you get to enter a gravity constant which allows you to work with weights instead of mass, if you so choose.

This worksheet takes in inputs from the user.  The next two worksheets show intermediate values computed from these beam and station definitions.


Shapes Worksheet
Shapes Worksheet       [image]      About this worksheet


Stations Worksheet
Stations Worksheet       [image]      About this worksheet


Stations about box
About the Stations Worksheet

This is the "Stations" worksheet.  This is another "output" worksheet since it shows a table of computed values.  This time, however, multiple beams which have been defined for individual stations have been added together to get the composite beam properties for the station.  The three columns with "Beam" at the top show these composite values.

The five columns with "Station" at the top show the station properties.  In this case the beam inertia properties are split between adjacent stations. For example, the weight for station 5 would be the sum of 1) half the beam weight for station 4, 2) half the beam weight for station 5, and 3) any added weights input for station 5.

Again, you can simply type in any units in the column headings to any consistent set you prefer.


XLJrnl Worksheet
XLJrnl Hydrodynamic Bearing Spreadsheet      [image]      About this worksheet


XLRotor Worksheet
XLRotor Worksheet        [image]        About this worksheet


XLRotor Worksheet see also
Overview of XLRotor

Shaft Input Worksheet

XLJrnl Worksheet for Bearings


added weights popup
Concentrated added weights can be shown right on the geometry chart.  Like bearings, they can be deleted by selecting them, and pressing the Delete key.


another worksheet
You are already on this worksheet.  Click on a different sheet tab to jump to another worksheet.  Or click on the arrows in the lower left corner of Excel's window.


beams see also
Shaft Input Worksheet

Stations Worksheet

Geometry Chart


beams table popup
This table displays intermediate values computed for each individual beam in the rotor model.  There is a command on the XLRotor pull down menu for updating this table after you make changes to the rotor model.


brgs about box
About the Brg's Worksheet

This is the "Brg's" worksheet.  This is where you define at which stations the bearings are located.  The same goes for seals and impellers, or any other device for which you want to account for stiffness and damping.  You can define as many bearings as you want, there is no limit.

One of the most powerful features of XLRotor is that bearings are defined via links to other Excel worksheet files.  XLJrnl, included with XLRotor, is one example of a bearing worksheet file.   Bearing worksheet files can be as simple or as complex as they need to be, but they need to contain a table of the stiffness and damping properties for the bearing.

Whenever XLRotor computes eigenvalues, mode shapes or response, it will go to the bearing worksheet (open it, if necessary) and retrieve the stiffness and damping table.  It will do this automatically for all bearings in the model.  This way the latest values for bearing properties will always be used when you conduct a rotor analysis.

The cells shown here in the "Link" column contain live links to the title string cells located within their respective bearing worksheet files.  The title strings are displayed here on this worksheet, but the cells actually contain formulas referencing the file name and cell address for the title in the bearing file.

Creating these Links is a snap, you just copy and paste the title cell from the bearing file to here in the rotor model file.


brgs popup links
Bearings are modeled with spreadsheets that can be stored in separate files, or within the rotor model file.  However it's done, the bearing worksheets are Linked to the rotor model here in this column.  This column displays the contents of a Title cell which actually resides within the bearing spreadsheet file.

These Links allow XLRotor to fetch the stiffness and damping values for all bearings when you perform an analysis.

Instead of linking to a bearing worksheet, you can also enter the words PINNED, RIGID or GUIDED to create these kinds of constraints.

You can also enter a numerical value, which the program will use for an undamped isotropic lateral stiffness value (called "Quick Bearings").


brgs popup loads
This column allows you to designate which bearings you want see bearing load charts for, when performing imbalance response analyses.


brgs popup stn num
In this column you enter the stations at which the bearings are located.  The model can contain as many bearings as you want.

If you wish, you can enter references to other cells.  A reference to a cell on the "Shaft Input" worksheet would cause the bearing's station number to update automatically if you insert or delete stations.


brgs popup type
The types of bearings currently shipping with XLRotor include

XLUserKC	user defined

XLJrnl	hydrodynamic brg's

XLBallB	ball bearings

XLCylind	cylindrical roller bearings

XLImplr	centrifugal impellers

XLAlford	axial flow impellers

XLHydrst	pocketed hydrostatic bearings

XLShSeal	incompressible annular seals

XLSFD	squeeze film dampers


brgs popup ucsfactor
The two parameters UCSFactor and UCSConstant give you complete independent control over the stiffness of each bearing for undamped critical speed calculations.


brgs see also
Geometry Chart

XLJrnl Bearing Worksheet


chart menu
This is XLRotor's custom pull down menu for chart editing.

See Also     Menu for dealing with worksheets.


click on a column popup
Click on one of the data columns or other items in this worksheet for more information.


click on a tab popup
Click on any of the named sheet tabs for a look at what is on the other sheets.


contents brg popup
This is a worksheet where you define the bearing specifications for a rotor model.  It resides within an XLRotor rotor model file.  The sheet contains the station numbers where the bearings are located, and links to the bearing spreadsheet file(s).

To jump immediately to a sample bearing specification spreadsheet, click [image].


contents defl popup
This is a chart of an imbalance response deflected shape.  It shows the entire rotor's deflected axis at one value of shaft speed.

To jump immediately to a sample worksheet showing one of these charts, click [image].


contents geo popup
This is a model geometry chartsheet.  It's created automatically from the rotor model inputs.

To jump immediately to a sample geometry chart, click [image].


contents imbs popup
This is a worksheet where you specify imbalance response parameters.  This includes where and how much imbalance to apply, at what speeds to compute response, and which stations to generate response charts for.  This worksheet resides within an XLRotor rotor model file.

To jump immediately to a sample worksheet showing imbalance specifications, click [image].


contents load popup
This is a chart of bearing load response at one bearing.  It is created automatically when you perform an imbalance response analysis.

To jump immediately to a sample worksheet showing the results of an imbalance response analysis, click [image].


contents nfmap popup
This is a damped natural frequency map.  It is created automatically (along with a table showing the eigenvalues) when you perform a damped eigenvalue analysis.

To jump immediately to a sample worksheet showing the results of a damped eigenvalue analysis, click [image].


contents overview popup
This picture of icons provides a graphic overview of the XLRotor analysis system for rotordynamics.

To go to the Overview screen of this demo, click this button [image].


contents polar popup
This is a chart of displacement response at one station.  It is created automatically when you perform an imbalance response analysis.  The format for this chart is polar, and it can be toggled back and forth between polar and bode formats.

Response analysis results are stored within the XLRotor rotor model file.

To jump immediately to a sample worksheet showing the results of an imbalance response analysis, click [image].


contents rlocus popup
This is a root locus chart.  It is created along with a damped natural frequency map when you perform a damped eigenvalue analysis.

To jump immediately to a sample worksheet showing the results of a damped eigenvalue analysis, click [image].


contents shapes popup
This is a 3D mode shape chart.  Mode shapes charts are created by selecting a group of eigenvalues appearing in an eigenvalue table, and executing a Run|Mode Shape command from the pull down menu.  XLRotor can create 2D and/or 3D mode shape charts with a single command, for just the eigenvalues you select.

XLRotor can also animate 3D mode shapes (this demo can't, however).

To jump immediately to a sample worksheet which shows mode shape charts, click [image].


contents ucs popup
This is an undamped critical speed chart.  It is created automatically (along with a table showing the critical speeds) when you perform an undamped critical speed analysis.

To jump immediately to a sample worksheet showing the results of an undamped critical speed analysis, click [image].


contents xljrnl wks popup
This is an XLJrnl bearing worksheet.  XLJrnl is used to model many types of hydrodynamic bearings.  Bearings are modeled in files separate from - and are linked to - the rotor model file.

XLRotor also has modules for computing impeller cross coupling, and for user defined bearings.

To jump immediately to a sample XLJrnl bearing file, click [image].


contents xlrotor worksheet popup
This is an XLRotor worksheet - it is the central worksheet within an XLRotor rotor model file.  There are other worksheets stored within a rotor model file, some of which are shown here.

To jump immediately to one of these worksheets, click [image].


eigen speeds
These are rotor speed values you enter for calculating damped eigenvalues.  You can enter as many values as you want, in any order or spacing that you want.


geo see other
Click your mouse on another part of the geometry chart see other information about the item.


geo shaft popup
The chart of the rotor model geometry is generated automatically.


geo title popup
The text of the title which appears on the geometry chart is a live reference to the text appearing in the two title cells on the XLRotor worksheet.  If you change the text in the title cells, the geometry chart's title updates automatically.


geometry see also
Shaft Input Worksheet

Beams Worksheet

Stations Worksheet

Brg's Worksheet


imbs about box
About the Imb's Worksheet

This worksheet is where you define the mass imbalances to be applied to the rotor.  You can specify as many imbalances as you want, there is no limit. The units of the imbalance can be selected from a drop down list in the Options|Response dialog box.

The station number at which the imbalance is applied can be a reference to a cell on the "Shaft Input" worksheet.  By referring to a station number in that way, if you change the rotor model by inserting or deleting stations, the imbalance station number will update automatically (of course, as long as you don't delete it).

The column of "Response Speeds" can contain as many speed values as you want, and they do not have to be evenly spaced.  These speed values are used for calculations of response versus rotor speed.  Excel's built in range filling features make it easy to fill a cell range with a regular series of values.

The column of "Deflected Shape Speeds" can also contain as many values as you want.  These speed values are used for calculating complete rotor deflected shapes.

The column of "Output Stations" specifies the stations for which you want to generate tables and charts of response versus rotor speed.  Again, you can specify as many stations as you want, and they can be references to cells on other sheets.

As for bearing loads, tables and charts of bearing load versus rotor speed are taken care of on the "Brg's" worksheet where you place a "yes" in the "Output Loads" column.  That causes loads to be output for those bearings.


imbs amount and phases
The imbalance amount can be entered in any of several units including gm-in and oz-in.  You select what type of unit in the dialog box for Response Options.

Imbalance phase angles are always in degrees.


imbs output stations
In this column you list the station numbers for which you want to compute charts of displacement response versus rotor speed.

Like for bearing stations, these station numbers can be references to cells on the "Shaft Input" worksheet.  That way they will update automatically if you insert or delete stations from the model.


imbs output titles
These titles are copied to charts of displacement versus rotor speed which are created when you perform an imbalance response analysis.


imbs see also
Response Worksheet

Options|Response Dialog Box


imbs speed ranges
You can enter two different speed ranges for performing response analyses.  One is for generating charts of response versus rotor speed at selected stations (also used for bearing loads).  The other speed range is used for generating complete rotor deflected shapes (i.e., like a mode shape).

You can enter as many speeds as you want, in any order or spacing that you want.


imbs stations
In this column you enter the stations at which the imbalances are located.  The model can contain as many imbalances as you want.

Just like for bearing stations, you can enter references to other cells.  A reference to a cell on the "Shaft Input" worksheet would cause the imbalance's station number to update automatically if you insert or delete stations.


jump to xlrotor.hlp file
To close this demo file and jump to XLROTOR.HLP online manual/help file, click [image].

If you later wish to return to this demo from the online help file, you will have to restart the demo by using File Manager.


link popup
Bearing spreadsheet files are connected to the rotor model spreadsheet file by way of standard spreadsheet Links.  Whenever you perform an analysis, the latest values for bearing stiffness and damping are used automatically.


options eigenanalysis popup
These are options which apply to the various types of eigenvalue analyses.  The options are saved with the rotor model file.

See also:
Options|General
Options|Response
Options|Transient


options general popup
These are general options which apply to all analyses.  The options are saved with the rotor model file.

See also:
Options|Eigenanalysis
Options|Response
Options|Transient


options response dialog popup
These are options which apply to imbalance response analyses.  The options are saved with the rotor model file.  Note that you have full control over the style of display units used for creating charts.

See also:
Options|General
Options|Eigenanalysis
Options|Transient


overview see also
How to Operate the Demo

Go to the XLRotor Worksheet

Go to the XLJrnl Worksheet


overview xlalford popup
This icon represents an XLAlford spreadsheet file used to compute aerodynamic cross coupling for axial flow impellers.  It is based on a relationship derived by J.S. Alford.


overview xlballb popup
This icon represents an XLBallB ball bearing analysis spreadsheet file.  XLBallB is used to compute the stiffness of ball bearings.  It is based on the classic analysis of A.B. Jones.

XLBallB is a complete analysis tool which also computes ball bearing stresses and deflections.  XLBallB also computes bearing defect frequencies.


overview xlhydrost popup
This icon represents an XLHydst hydrostatic bearing analysis spreadsheet file.

This is used to model pressure-fed pocketed hydrostatic bearings.


overview xlimplr popup
This icon represents an XLImplr spreadsheet file used to compute aerodynamic cross coupling for centrifugal flow impellers.  It is based on an empirical relationship derived by J.C. Wachel.


overview xljrnl popup
This icon represents an XLJrnl spreadsheet file.  XLJrnl files are used to analyze standard hydrodynamic bearings for their stiffness and damping coefficients.  The resulting XLJrnl file would be linked to an XLRotor rotor model file so that the bearing coefficients can be fetched when doing a rotor analysis.

To jump immediately to a sample XLJrnl bearing file, click [image].


overview xlrotor popup
The big box on top represents an XLRotor rotor model file.  It is the central file when doing a rotordynamic analysis job for any given rotating machine.  Among other things, this file contains the shaft geometry, bearing locations, and imbalance distribution.  The file also will contain the results for all rotor analyses (eigenvalues, mode shapes and response).

This demo contains most of the elements of a rotor model file.  To jump to the start of the sample rotor model file, click [image].


overview xluserkc popup
This icon represents an XLUserKC file for user defined bearings.  It is similar in function to an XLJrnl file.  You use XLUserKC when you are using your own programs to compute stiffness and damping for bearings, seals, etc.

XLUserKC can also be used as a template for creating Excel spreadsheet drivers for your own bearing programs.  This allows you to integrate your programs into the XLRotor analysis system.


resp about box
About the Resp Worksheet

This worksheet shows the results of computing imbalance responses.  The charts and tables are created automatically.  Charts of displacement come first, followed by charts of bearing load.  These charts are generated when you execute a Run|Response command.  This worksheet also shows charts of deflected shapes computed when you execute a Run|Deflected Shape command, located on the pull down menu.

Be sure to click on the zoom buttons to get closer looks at what's on this worksheet.  The Excel zoom factor had been set to about 25% so that all the charts could be viewed at once.

The charts of response versus rotor speed are initially created in xy format (Bode).  These charts can be easily toggled to Polar format with a command on the pull down menu.  You also have the option of whether to label the points on the polar charts with corresponding rpm values.


resp bode chart
This is a close up of an imbalance response Bode chart showing rotor displacement versus rotor speed.  As with all of XLRotor's charts, you control the chart format both before and after the chart is created.  For this particular chart you even have control over the units (i.e., pk, p-p, rms, mils, inches, whatever you want).


resp bode table
This is a close up of a Bode response table.  XLRotor gives you complete control over the displacement units used to create this table.  The data in this table goes with the accompanying chart.

Displacement Response at Station Number = 4

4 inch Bearing

Speed	Horz Amp	Horz Phs	Vert Amp	Vert Phs	Major Amp	Minor Amp	Ell Ang
rpm	mils p-p	degrees	mils p-p	degrees	mils p-p	mils p-p	degrees
500	3E-04	324.3	2E-04	53.61	3E-04	2E-04	0.537
1000	0.002	332.1	1E-03	60.78	0.002	1E-03	0.982
1500	0.005	337.2	0.003	64.76	0.005	0.003	1.824
2000	0.011	342.7	0.006	68.17	0.011	0.006	3.318
2500	0.023	351.2	0.012	72.52	0.023	0.012	6.071
3000	0.046	8.345	0.024	80.22	0.047	0.022	11.74
3500	0.082	43.17	0.052	98.55	0.089	0.04	25.19
4000	0.089	80.86	0.095	145.2	0.11	0.069	139.5
4500	0.079	101.1	0.083	188	0.084	0.078	155.1
5000	0.073	110.9	0.066	204.3	0.073	0.066	164
5500	0.07	116.5	0.059	211.1	0.071	0.058	168.2
6000	0.071	120.5	0.056	214.6	0.071	0.056	171.6
6500	0.073	124	0.056	216.9	0.073	0.056	174.8
7000	0.076	127.6	0.058	218.8	0.076	0.057	178
7500	0.08	131.4	0.06	220.7	0.08	0.06	1.349
8000	0.084	135.5	0.064	222.8	0.084	0.064	4.877
8500	0.087	139.6	0.069	225.5	0.087	0.068	8.428
9000	0.089	143.5	0.074	228.6	0.09	0.073	11.76
9500	0.091	146.9	0.079	232.2	0.092	0.078	14.5
10000	0.093	149.8	0.083	235.9	0.094	0.082	16.06


resp defl chart
This chart show a complete rotor deflected shape due to rotating imbalance.  The chart shows major axis amplitude, which can be compared directly against available bearing, seal and impeller clearances, as required by API purchase specifications.  Note that discontinuities in the horizontal and vertical curves are due to corkscrewing of the rotor.


resp defl table
This is a close up of a deflected shaped table.  The data in this table goes with the accompanying chart.

Complete Rotor Deflected Shape at Speed = 8000 rpm

Stn. No.	Ax. Loc.	Horz Amp	Horz Phs	Vert Amp	Vert Phs	Major Amp	Ell Ang
	inches	mils pk	degrees	mils pk	degrees	mils pk	degrees
1	0	0.037	168.5	-0.03	271.2	0.038	161.4
2	0.688	0.037	163.7	-0.03	264.1	0.037	165
3	2.688	0.038	150.2	-0.03	243.2	0.038	175.5
4	4.813	0.042	137.9	-0.03	224.9	0.042	5.486
5	9.188	0.055	119.9	-0.05	203.1	0.056	21.78
6	11.44	0.059	115.8	-0.05	199	0.061	26.35
7	16.5	0.064	110.6	-0.06	194.4	0.066	33.29
8	20.47	0.065	108.4	-0.06	192.7	0.067	37.29
9	24.5	0.064	106.7	-0.06	191.6	0.066	41.29
10	29.65	0.061	105.1	-0.06	190.7	0.063	137
11	32.06	0.059	104.4	-0.06	190.5	0.062	140.3
12	34.22	0.058	103.9	-0.06	190.3	0.06	143.7
13	36.38	0.056	103.3	-0.06	190.2	0.058	147.7
14	38.6	0.054	102.8	-0.06	190.1	0.057	152.6
15	40.99	0.052	102.3	-0.05	190.1	0.055	158.4
16	42.12	0.051	102	-0.05	190.1	0.054	161.3
17	43.24	0.05	101.8	-0.05	190.1	0.053	164.3
18	49.59	0.043	100.5	-0.05	190.5	0.047	179.9
19	55.94	0.036	99.32	-0.04	191.6	0.04	11.24
20	59.16	0.032	98.67	-0.04	192.4	0.036	15.65
21	60.57	0.031	98.28	-0.03	192.7	0.035	17.39


resp load chart
This chart shows bearing load versus rotor speed.  On the Imb's Worksheet you designate which bearings you want to create load charts for when you perform an imbalance response analysis.  Again, you control the format used to create this chart via the XLRGRPH.XLS chart template file.


resp load table
This is a close up of a table of bearing loads.  The data in this table goes with the accompanying chart.

Bearing Load Response at Station Number = 37

5 Pad Tilting Pad Bearing, LBP, 5 inch

Speed	Horz Load	Horz Phs	Vert Load	Vert Phs	Max Load	Min Load	Ell Ang
rpm	lbf pk	degrees	lbf pk	degrees	lbf pk	lbf pk	degrees
500	0.419	280.2	0.417	10.1	0.419	0.417	8.892
1000	1.764	281.4	1.739	10.93	1.766	1.737	14.06
1500	4.367	284.1	4.216	12.65	4.384	4.199	17.71
2000	9.007	289.1	8.426	15.62	9.107	8.318	21.25
2500	17.48	298.4	15.69	20.61	17.98	15.1	25.74
3000	33.47	317.1	29.34	29.65	36.24	25.85	33.15
3500	54.77	354.3	58.81	49.6	71.26	37.16	138.6
4000	54.09	35.34	98.87	98.64	102.6	46.55	162.5
4500	42.67	58.81	78.17	144.5	78.26	42.5	176.6
5000	34.14	71.7	56.1	163.9	56.13	34.1	2.128
5500	28.05	80.23	44.21	173.9	44.27	27.95	3.857
6000	23.01	86.51	37	180.5	37.06	22.92	4.006
6500	18.23	90.56	31.97	185.5	32.03	18.13	4.178
7000	13.36	89.98	27.94	189.7	28.06	13.12	5.913
7500	8.942	75.45	24.2	193	24.59	7.801	10.8
8000	8.312	35.07	20.17	194.7	21.65	2.695	21.47
8500	13.84	11.04	15.48	191.6	20.77	-0.1	41.79
9000	22.26	8.057	11.01	172.1	24.69	2.727	154.2
9500	32.06	11.99	12.33	129.1	32.62	10.79	168.8
10000	42.93	18.09	22.6	109	42.93	22.59	179.4


resp polar chart
This is a close up of a Polar style imbalance response chart of rotor displacement.  This chart format is created via a menu command which switches Bode format to Polar format, and vice versa.  XLRotor gives you control over the creation of rpm tags, both before and after the chart is created.


resp polar table
This is a close up of a Polar response table.  The data in this table goes with the accompanying chart.

Displacement Response at Station Number = 37

5 inch Bearing

Speed	Horz:c	Horz:s	Vert:c	Vert:s	Major Amp	Minor Amp	Ell Ang
rpm	mils p-p	mils p-p	mils p-p	mils p-p	mils p-p	mils p-p	degrees
500	2E-04	-0	2E-04	9E-05	4E-04	2E-04	0.207
1000	0.001	-0	9E-04	7E-04	0.002	0.001	0.731
1500	0.004	-0	0.002	0.002	0.006	0.003	1.64
2000	0.011	-0.01	0.004	0.005	0.013	0.007	3.196
2500	0.024	-0.01	0.007	0.011	0.027	0.013	5.996
3000	0.051	-0	0.01	0.024	0.052	0.024	11.66
3500	0.07	0.048	0.002	0.053	0.092	0.039	25.07
4000	0.02	0.082	-0.07	0.06	0.106	0.063	139.3
4500	-0.01	0.065	-0.07	-0.01	0.074	0.065	155.3
5000	-0.02	0.048	-0.05	-0.02	0.053	0.052	150.2
5500	-0.02	0.036	-0.03	-0.02	0.043	0.041	156.7
6000	-0.02	0.026	-0.03	-0.02	0.036	0.034	136
6500	-0.02	0.019	-0.02	-0.02	0.03	0.027	16.26
7000	-0.01	0.014	-0.02	-0.02	0.027	0.019	13.45
7500	-0.01	0.011	-0.01	-0.02	0.024	0.011	18.69
8000	0.001	0.012	-0.01	-0.02	0.022	0.004	31.59
8500	0.01	0.017	-0.01	-0.01	0.024	4E-05	143.7
9000	0.016	0.026	-0.01	-0.01	0.032	0.003	162.5
9500	0.02	0.039	-0.01	1E-04	0.044	0.01	173
10000	0.02	0.053	-0.02	0.007	0.057	0.02	179.6


resp see also
Imb's Worksheet

Options|Response Dialog Box

XLJrnl Bearing Worksheet


roots damped about box
About the Roots Damped Worksheet

This worksheet show the results of performing a damped eigenanalysis.  This worksheet is automatically created when you perform the analysis.  You start the analysis by choosing the "Run|Eigenvalues" command from the XLRotor pull down menu located on Excel's pull down menu bar.  As you can see, this worksheet contains a table showing the damped natural frequencies and damping factors, and two embedded charts showing the damped natural frequency map versus rotor speed, and a root locus plot (i.e., roots shown in complex plane).

As discussed earlier, you have total control over the formats of these charts. You can customize the individual charts after they're created, and you can also customize the templates stored in XLRGRPH.XLS.

There are also commands in the XLRotor pull down menu for changing the style of the damping factor between damping ratio and complex exponent.


roots damped nfmap
This is a damped natural frequency map.  It shows the damped whirl frequencies as a function of rotor speed.  This chart is created automatically when you perform a damped eigenanalysis.  The format for this chart is copied from the XLRGRPH.XLS template file, which you can customize.


roots damped root locus
This is a root locus chart.  It shows the damping ratio versus the whirl frequency.  It shows where the roots are going in the complex plane as rotor speed changes.  The format for this chart is copied from the XLRGRPH.XLS template file, which you can customize.


roots damped see also
Roots UCS Worksheet

Mode Shapes Worksheet

Options|Eigenanalysis Dialog Box


roots damped table popup
This is a close up of part of the table of damped eigenvalues.  This table is created automatically when you perform a damped eigenanalysis.  The table now shows damping ratio, but you can switch it to damping exponent via a menu command.

Speed	zeta1	cpm1	zeta2	cpm2	zeta3	cpm3	zeta4	cpm4	zeta5
1000.	1.000	0.0	0.069	4610.8	0.129	4486.7	0.028	15056.6	0.048
1200.	1.000	0.0	0.081	4569.1	0.151	4403.4	0.034	15063.1	0.057
1400.	1.000	0.0	0.092	4523.5	0.172	4310.6	0.039	15072.2	0.064
1600.	1.000	0.0	0.102	4474.6	0.190	4210.2	0.045	15084.1	0.070
1800.	1.000	0.0	0.111	4423.4	0.205	4105.6	0.050	15099.0	0.075
2000.	1.000	0.0	0.119	4370.8	0.217	4001.0	0.056	15117.1	0.078
2200.	1.000	0.0	0.126	4317.9	0.224	3901.5	0.061	15138.4	0.081
2400.	1.000	0.0	0.131	4265.9	0.228	3810.9	0.066	15163.1	0.082
2600.	1.000	0.0	0.135	4215.6	0.228	3731.6	0.070	15191.1	0.083
2800.	1.000	0.0	0.138	4167.9	0.226	3663.9	0.075	15221.9	0.084
3000.	0.938	4486.2	0.139	4123.2	0.223	3607.2	0.079	15255.0	0.084
3200.	0.834	6449.4	0.140	4081.9	0.218	3560.0	0.082	15289.4	0.084
3400.	0.769	7053.6	0.140	4044.1	0.213	3520.7	0.086	15323.7	0.084
3600.	0.722	7335.9	0.140	4009.6	0.208	3488.2	0.088	15356.5	0.083
3800.	0.685	7485.6	0.139	3978.4	0.202	3461.0	0.091	15386.2	0.083
4000.	0.656	7567.7	0.138	3950.2	0.197	3438.4	0.092	15411.8	0.083
4200.	0.632	7611.1	0.136	3924.8	0.192	3419.4	0.094	15432.8	0.082
4400.	0.611	7631.3	0.134	3901.9	0.186	3403.5	0.094	15448.7	0.082
4600.	0.593	7637.0	0.133	3881.2	0.182	3390.2	0.095	15459.6	0.082
4800.	0.576	7634.1	0.131	3862.5	0.177	3379.0	0.095	15465.7	0.082


shaft input see also
Beams Worksheet

Stations Worksheet

Geometry Chart


shaft input table popup
You enter your rotor model definition into this table.  Material properties can be different for every beam.  Note that you can define multiple beams for each station.  Multiple beams are superimposed.


shapes 2d graphic
This is a close up view of a damped 2D mode shape.


shapes 3d damped graphic
This is a 3D view of a damped mode shape.  XLRotor can animate these mode shapes.


shapes 3d ucs graphic
This is a 3D view of an undamped critical speed mode shape.


shapes about box
About the Shapes Worksheet

This worksheet shows the mode shapes of the rotor.  You compute mode shapes by going to a worksheet of damped or undamped eigenvalues, using the mouse to select one or more eigenvalues, and executing the "Run Mode Shapes" command found in the XLRotor pull down menu (or you can click the button on the XLRotor custom toolbar).

There is a setting in the Options|Eigenvalues dialog box for specifying whether you want the mode shape plots to be 2D, 3D, or both.  You have total control over the formats of these charts.  You can customize the individual charts after they're created, and you can also customize their source templates stored in XLRGRPH.XLS.

Excel has a handy worksheet Zoom feature.  This worksheet is currently zoom'ed to 40% of full size.  You can zoom out to see more of the worksheet at one time, or zoom in to see the details.  Excel makes it easy to zoom in on a chart or a range of cells, or both, and then zoom back out again.


shapes see also
Roots UCS Worksheet

Roots Damped Worksheet

Options|Eigenanalysis Dialog Box


shapes table popup
This is close up view of a mode shape table.  It's created automatically along with the chart(s) when you compute mode shapes.
Speed=	7000

Re(root)=	0.457693

Im(root)=	7551.354

Ax. Stn. No.	Ax. Loc.	Re(x)	Im(x)	Re(y)	Im(y)	Re(ax)	Im(ax)	Re(ay)	Im(ay)
1	0	0.499002	0	0.020531	0.047458	-0.011461	0.033007	-0.004979	6.53E-05
2	0.6875	0.491119	0.022686	0.017108	0.047502	-0.01146	0.033008	-0.004979	6.57E-05
3	2.6875	0.468173	0.088658	0.007157	0.047632	-0.011414	0.033071	-0.00498	7.54E-05
4	4.8125	0.443887	0.158859	-0.003416	0.04779	-0.011368	0.033142	-0.004982	8.54E-05
5	9.1875	0.394403	0.305388	-0.025362	0.048284	-0.009645	0.017529	-0.002682	-0.00032
6	11.4375	0.372835	0.343878	-0.031253	0.04755	-0.008781	0.009226	-0.001466	-0.000545
7	16.5	0.329954	0.375733	-0.036502	0.044413	-0.007684	-0.001457	0.000104	-0.000838
8	20.47075	0.299795	0.367073	-0.035681	0.041028	-0.007339	-0.004911	0.000613	-0.000935
9	24.502	0.270603	0.344321	-0.032803	0.037206	-0.007072	-0.00775	0.001031	-0.001018
10	29.649	0.234678	0.301065	-0.027044	0.031907	-0.006905	-0.009785	0.00133	-0.001083
11	32.0645	0.218118	0.277139	-0.023811	0.029304	-0.006863	-0.010396	0.001418	-0.001104
12	34.2205	0.203369	0.254716	-0.020761	0.026934	-0.00686	-0.010467	0.001428	-0.001107
13	36.3765	0.188656	0.232036	-0.017683	0.024558	-0.006857	-0.010536	0.001435	-0.001109
14	38.6045	0.173594	0.20793	-0.014455	0.0221	-0.006856	-0.010882	0.001464	-0.001124
15	40.9905	0.157609	0.18031	-0.010859	0.019418	-0.006882	-0.011808	0.001541	-0.001168
16	42.1155	0.149949	0.166856	-0.009119	0.018112	-0.006887	-0.011883	0.001547	-0.001172
17	43.2405	0.142287	0.1533	-0.00737	0.016801	-0.006892	-0.011955	0.001552	-0.001176
18	49.5905	0.098825	0.068483	0.003011	0.009012	-0.007238	-0.013936	0.001679	-0.001321
19	55.9405	0.052298	-0.027523	0.014066	0.000204	-0.007856	-0.01537	0.001759	-0.00149
20	59.1625	0.026445	-0.080899	0.019901	-0.004857	-0.008751	-0.016458	0.001809	-0.001692


springs popup
Bearing and seals are conveniently shown right on the geometry chart.  They can also be deleted from the chart by simply selecting them and pressing the Delete key.


stations beam columns popup
The three columns with the word "Beam" at the top show the results of adding together multiple beams which you may have defined for single stations.  If the model only has one beam at each station, then these values would be identical to those on the "Beams" worksheet.


stations see also
Beams Worksheet

Geometry Chart


stations station columns popup
The five columns of this table with the word "Station" at the top show the final values computed for each station in the rotor model.  These are the actual values which will be used to perform all rotordynamic eigenvalue and response analyses.

Note that beam inertias have been split evenly and lumped at adjoining stations.


toolbar
This is the XLRotor custom toolbar.  These buttons provide quick access to some of the commands in the XLRotor pull down menu.


ucs about box
About the UCS Worksheet

This worksheet shows the results of performing an Undamped Critical Speed eigenanalysis.  This worksheet is automatically created when you perform the analysis.  You start the analysis by choosing the "Run UCS" command from the XLRotor pull down menu located on Excel's pull down menu bar.  As you can see, this worksheet contains a table showing the undamped critical speeds, and an embedded chart showing the critical speed map versus bearing stiffness.

You have total control over the format of the chart.  As always, you can customize it in any way after it is created.  You can also customize the template from which it is derived.  When creating charts, XLRotor uses chart templates located in a regular worksheet file named XLRGRPH.XLS.

You can open the XLRGRPH.XLS file yourself, and modify the formats of any or all of the charts it contains, and re-save the file to save your changes. From then on your custom formats will be reflected in new charts created by XLRotor.  For example, you can change the undamped critical speed map to have a linear y axis, or you can put your company logo on all charts.


ucs chart popup
This undamped critical speed chart is created automatically when you perform the analysis.

The formats for the chart are copied from the XLRGRPH.XLS template file.  That gives you total control over the appearance of the chart before it is created.  After it is created, you can use any of Excel's chart editing tools to modify the appearance of the chart.


ucs see also
Options|Eigenanalysis Dialog Box

Roots Damped Worksheet

Mode Shapes Worksheet


ucs stiffnesses
These are bearing stiffness values you enter to perform undamped critical speed calculations.


ucs table popup
This table of undamped critical speeds is created automatically when you perform the analysis.


wfr and ecc chart
A chart of the Whirl Frequency Ratio and Static Eccentricity Ratio is generated automatically on a separate sheet.  As with all Excel charts, it can be easily copied to a word processor document.


worksheet menu
This is XLRotor's custom pull down menu.  It provides access to all the functionality of XLRotor.  The menu shown here applies to worksheets.

See Also    Menu for editing charts.


xljrnl about box
About the XLJrnl Worksheet

This worksheet shows the journal bearing analysis spreadsheet, XLJrnl, as it appears in Microsoft Excel.  An XLJrnl spreadsheet file would be "Linked" to the rotor model file to provide the stiffness and damping coefficients for performing a rotor analysis.

XLJrnl uses a table lookup approach to determine the stiffness and damping properties for a variety of standard hydrodynamic journal bearing designs.  This method is described in the highly regarded journal bearing data reference book published in Japan.

All the bearing input parameters appear on this single worksheet.  The drop down menus allow you to pick your choice for the most convenient way to enter the inputs.  Stiffness and damping coefficients are then computed by simply clicking on the "Run" button.  Along with stiffness and damping, there are also columns for Static Eccentricity, Sommerfeld Number, and Whirl Frequency Ratio.


xljrnl clearance drop down
There are two ways to define the bearing clearance.


xljrnl diameter drop down
There are two choices for entering the bearing size.


xljrnl ecc somm popup
Ecc is the journal's static eccentricity within the bearing clearance, and Somm is the standard Sommerfeld number.


xljrnl help button popup
Clicking on this Help button brings up the XLRotor Windows Help File, which will automatically be at the lead topic for XLJrnl.


xljrnl kcm popup
This table of stiffness and damping coefficients is generated automatically when you click on the Run button.

This table is automatically fetched by XLRotor when conducting a rotor analysis which requires these coefficients.


xljrnl length drop down
There are two ways to define the bearing length.


xljrnl load drop down
There are two ways to specify the static load on the bearing.


xljrnl run popup
You simply click on this Run button to update the table of stiffness and damping coefficients for the currently defined set of bearing parameters.


xljrnl s.g. drop down
The density is required if dynamic viscosity in stokes or centistokes is selected for viscosity units.


xljrnl see also
Overview of XLRotor

XLRotor Worksheet

Brg's Worksheet


xljrnl speed popup
In this column you enter a list of journal speeds (in rpm) for which to compute the rotordynamic coefficients.  You can enter as many speeds as you want, in any order that you want.


xljrnl title popup
You enter a descriptive title for the bearing in this cell.  This title will appear within XLRotor rotor model file(s) to which this bearing is Linked.  It will also be copied to any charts of bearing load created later during an imbalance response analysis.


xljrnl type drop down

You simply select a bearing type from this drop down list.


xljrnl visc drop down
There are multiple choices for the units for entering the lubricant viscosity.


xljrnl wfr popup
The Whirl Frequency Ratio is a rotor stability parameter computed from the stiffness and damping coefficients as follows:


xlrotor titles
These are project titles you enter which are copied to charts and tables created when you perform various analyses.


xlrotor worksheet about box
About the XLRotor Worksheet

This screen shows the worksheet named "XLRotor".  On this sheet you enter parameters to control the eigenanalysis.  For example, speed and stiffness ranges for damped eigenvalue and undamped critical speed analyses, respectively.

XLRotor also does imbalance response, but that is controlled by parameters entered on another worksheet, named "Imb's", presented later.

Be sure to click your mouse button on regions of the screen where the mouse cursor changes to a pointing finger in order to see pop up messages.


zoom
Click on one of the [image] zoom buttons to get a closer look at part of this worksheet.


xljrnl lube dropdown

Xlrotor comes with an extensive library of industrial lubricants.


xljrnl lubricant conditions
The lubricant film viscosity is used to compute the Sommerfeld number.

The lubricant film viscosity can be entered directly, or computed from the film temperature for the selected oil type.

It is also possible to have the viscosity vary with speed.


overview xlshseal popup
This icon represents an XLShSeal spreadsheet file.  XLShSeal files are used to analyze short incompressible annular seals.  Generally for pumps.  The resulting file would be linked to an XLRotor rotor model file so that the stiffness and damping coefficients can be fetched when doing a rotor analysis.


overview xlsfd popup
This icon represents an XLSFD spreadsheet file.  These files are used to compute the damping in a squeeze film damper.

The resulting file would be linked to an XLRotor rotor model file so that the stiffness and damping coefficients can be fetched when doing a rotor analysis.


overview xlcylind popup
This icon represents an XLCylind cylindrical roller bearing analysis spreadsheet file.  XLCylind is used to compute the stiffness of a roller bearing.  It is based on the classic analysis of A.B. Jones.

XLCylind is a complete analysis tool which also computes bearing stresses and deflections.  XLCylind also computes bearing defect frequencies.


overview xlpocket popup
This icon represents an XLPocket file used for analyzing as well as designing fixed geometry journal bearings.

This program is optional, and is not included with the standard Xlrotor package.

XLPocket was developed by Dr. John Nicolas of RMT, Inc.


overview xltltpad popup
This icon represents an XLTltpad file used for analyzing as well as designing tilting pad journal bearings.

This program is optional, and is not included with the standard Xlrotor package.

XLTltpad was developed by Dr. John Nicolas of RMT, Inc.


options transient dialog popup
These are options which apply to transient response analyses.  The options are saved with the rotor model file.

See also:
Options|General
Options|Eigenanalysis
Options|Response