Two left sensors?

Something you never want to hear from a doctor....."Oops"

Another fix for next revision.   Thx

Thanks a lot for sharing.

Regards- Ali M. Al-Shurafa

You bet....hope you find it useful.  Please let me know of any technical issues you may find. 

To that end, rev 4 fixes an issue brought up with sensor orientation on Static/Couple sheet (Left Horiz/Vert and Right Horiz/Vert) and also includes some quantitative information about percentage of static vs. dynamic on that same sheet.

Regards

Jim P

IVBR8

thanks a lot for sharing.

regards,

IVBR8,

thank you very much for sharing!

dear sir,

can we use this software for correction of 1x shaft vibrations on both planes of the rotor.

regards,

D.Ravishanker

I assume you mean two plane balancing....Yes

The Excel file has a tab at the bottom called 2PlaneBalancing

Enter data in the green boxes and the results are presented in the two graphs below the data entry boxes. Your trial weights in red squares and the calculated correction weights in green circles.

You may also wish to use the "Static Couple" tab once you get your original balance data. It doesnt solve for balance but gives you a graphic view of how much is due to static or couple 

As my understanding, intial run-1, tw-1 on plane -, take run,  and  remove tw-1 on plane -1, tw2 on plane-2, take run  and remove tw-2 on plane 2 and last is correction run.Total 4 runs required, and this is only at one particular speed only can done.

Can any tell me this  software is working properly, any one tried and got good result?

If we want to select multiple speeds, any software is there?

I used Static Couple method only to reduce housing vibrations/pedestal vibrations,

This can be checked  for 1X shaft vibrations also?

Regards,

D. Ravishanker

It should be used only on 1xTS

It's for single speed static or couple

It works fine.

If you want multiple speed u guess you could do one sheet per speed.

Hello Jim,

A very good Effort Indeed. Really Appreciate.

Your welcome. I am working on a revision to include a new tab to include some basic vibe calculations (Level I and II stuff) and a tab that will include Severity Chart images). 

Jim P

Wonderful but why not use Metric system all through instead of mixing. 

Thanks a lot for your effort!

Gisli

Gisli A. Gudm posted:

Wonderful but why not use Metric system all through instead of mixing. 

Thanks a lot for your effort!

Gisli

Gisli, Jim's profile says he is from New York State (USA).

We are changing to metric, just doing it inch by inch.  

    Perhaps the next revision will include metric units in the drop-down list....millimeter by millimeter  

😁😁

If you would like to extend the 4-run method to using unequal trial weights or more that three trial runs, the attachment has details.  Not too difficult to implement.

Bill _Thank you!  Always looking to improve this file.   Will go over the details and try it all out and incorporate
Regards

Jim P

Jim, when you open your latest revision you get presented with a message reading "This workbook contains links to one or more external sources that could be unsafe".  You are then presented with the options to Update, Don't Update, and Help.

When you examine the link or links being referred to, you will find it is the spreadsheet I sent you some time ago for the static couple tab.  You can examine what the workbook is after by going to the Data tab, then Edit Links, and you will see what I think was my old workbook (static_couple balancing worksheet.xls)  listed.  

For the next revision I suggest while on that page (Data tab > Edit Links) you select "Break Link" and then save the workbook.  That should eliminate the message in the future.

Regards,

John

Will do!

Thanks

OK  folks     Here is the latest (hopefully last) revision

1. It fixes the bug with the Weight Splitting Sheet. It now references the proper user-input cells and adds more metric units in a few of the drop-down menus

2. It adds two new sheets, Basic Calculations and Severity Charts. I did not go into details on the Severity Charts. The user should be familiar with the contractual and technical requirements for your own balancing jobs.  I simply attached images for convenience, which I consider to be "fair use" of images normally found on the web

3. The latest file is macro-enabled which was needed to automate scaling for the 4-run balancing method.  Previous revisions required the user to manually adjust scaling of the X and Y axis parameters (i.e. min and max bounds) for some balancing examples. This can still be done but a macro was introduced to automate this process and ensure both the X and Y axis scales were identical. See the amplifying instructions on how to use.

Unless there are technical bugs to fix, I am done putting any more effort into this file. It should be sufficient for most common balance jobs and met my intent of having a one-stop shop.......more important things to start on    .  Feel free to edit and improve if any of you have some other ideas  

Stay safe and healthy out there while we get thru this rough patch of time

Regards
Jim Powers, P.E.    Owner Upstate NY PdM Services, LLC

fburgos found an error ......see below

furbos, You are correct ....thanks for finding this

Rather than send another revision, message to everyone......

On the Weight Vector Addition sheet in cell I23, the  ".....IMSUM(H7:H19) ..... should read

....IMSUM(H7:H19) .....

or simply copy and paste this formula into the cell

=+CONCATENATE(ROUND(IMABS(IMSUM(H7:H19)),2)," ",$F$7," ",$D$7)


regards
Jim

ivibr8 posted:

fburgos found an error ......see below

furbos, You are correct ....thanks for finding this

Rather than send another revision, message to everyone......

On the Weight Vector Addition sheet in cell I23, the  ".....IMSUM(H7:H19) ..... should read

....IMSUM(H7:H19) .....

or simply copy and paste this formula into the cell

=+CONCATENATE(ROUND(IMABS(IMSUM(H7:H19)),2)," ",$F$7," ",$D$7)


regards
Jim

I think "ivibr8" intended "On the Weight Vector Addition sheet in cell I23, the  ".....IMSUM(H7:H18) ..... should read

....IMSUM(H7:H19) .....

Yes.....correct

and my brain if "fried"

ivibr8 posted:

Yes.....correct

and my brain if "fried"

Jim, I have found that self-dosing with quinine mixed with an organic solvent seems to work wonders in eliminating anxiety and stress. Should you chose to do so, you can additionally supplement with a naturally occurring source of ascorbic acid which has some indication of reducing the incidence of respiratory problems. That however is unproven. Even before Covid-19 I found these measures to have a late day positive benefit in relieving stress so I've upped my dosage in light of the current situation.

By the way, should you not be into chemistry, this is sometimes known as an orange blossom if you use orange juice (ascorbic acid); leave it out and you have a simple gin & tonic.