LinkBack URL
About LinkBacks
Rotor _Mode _ Gauge 1 _ Gauge 2 _ Gauge 3
0______ 1 ______ 1 ______ 4 ______ 4
0______ 2 ______ 6 ______ 5 ______ 5
0______ 3 ______ 8 ______ 4 ______ 7
0______ 4 ______ 8 ______ 6 ______ 8
1______ 1 ______ 7 ______ 5 ______ 7
1______ 2 ______ 9 ______ 4 ______ 8
2______ 1 ______ 8 ______ 5 ______ 9
2______ 2 ______ 5 ______ 4 ______ 1
2______ 3 ______ 5 ______ 8 ______ 5
I have the above table in a spreadsheet (please ignore the lines they are just to spce out the columns!). The first column shows the rotor stage in a turbine compressor. For each rotor stage there are a number of modes of vibration indicated in the second column. Each stage has gauges in three positions, these positions have different allowable strains for a given mode, on a given rotor stage, and these are indicated in the 3rd-5th columns. So for instance for rotor stage 2 vibrating at mode 1 the allowable strain at gauge position 3 is 9.
In another sheet (in the same book) I have this spreadsheet:
Rotor 0
Mode Gauge Highest recorded strain
1 _____ 1 ______ 7
_______ 2 ______ 6
_______ 3 ______ 5
2 _____ 3 ______ 9
_______ 2 ______ 8
_______ 1 ______ 6
3 _____ 2 ______ 8
_______ 1 ______ 7
_______ 3 ______ 1
This table is for rotor stage 0, there are also separate spreadsheets for the other rotor stages that follow the same format. So I have found the highest recorded strain at each gauge position for a given mode of vibration. So for instance, the highest recorded strain for mode 3 at gauge position 1 is 7. I would like to add another column in this sheet that tells me if that gauge position is the best, 2nd best, worst, joint best, joint 2nd best position. The better a gauge position, the higher the allowable strain it has. So for instance for the example of gauge 1 for mode 3 (for rotor 0) this is the best gauge position (by seeing that it has the highest allowable strain of all the gauges for that mode and rotor stage in the first table i.e. it has an allowable strain of 8 which is better than 4 and 7).
How do I get excel to automatically tell me the second table if I am at the best, worst etc gauge position for each row.
Max showed me how to look up the allowable strain for a given gauge position, stage and mode:
http://www.excelforum.com/showthread...ight=turnipboy
The beauty of his method was that I could add information into the first table e.g. extra modes, and the spreadsheet did not have a problem with this. Could a similar thing be done here?
Thanks.
Register To Reply
Bookmarks