How do I make a compressor map with efficiency islands?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

erfigge - 14 Apr 2008 23:13 GMT

I can make standard compressor maps in excel very easily, but does anybody
know how to add efficiency islands to the map?

Reply to this Message

Del Cotter - 15 Apr 2008 08:02 GMT

>I can make standard compressor maps in excel very easily, but does anybody
>know how to add efficiency islands to the map?

This is a newsgroup of Excel experts, not necessarily experts in
whatever your field is. Most people here will have no idea what you're
talking about, so it's a courtesy to include some brief explanation of
what a compressor map is. I googled and found this:

http://en.wikipedia.org/wiki/Compressor_map

I assume that what you mean by "efficiency island" is that you want to
calculate contours. Excel is not well designed for contour mapping, and
you may want to try another package instead. If you can calculate the
efficiency levels for a range of pressures and flows, you could use the
"3-D Surface Chart" type, but the results will be blocky, and
integrating it with your original line curves will be difficult.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Reply to this Message

Del Cotter - 15 Apr 2008 08:36 GMT

>erfigge <erfigge@discussions.microsoft.com> said:
>>I can make standard compressor maps in excel very easily, but does anybody
>>know how to add efficiency islands to the map?

>Excel is not well designed for contour mapping, and you may want to try
>another package instead. If you can calculate the efficiency levels for
>a range of pressures and flows, you could use the "3-D Surface Chart"
>type, but the results will be blocky, and integrating it with your
>original line curves will be difficult.

If you're not prepared to abandon Excel or 2-D XY charts, you could use
one of the third-party chart labeling utilities. Google "excel chart
labeler" and "excel chart tools" to find the two popular free add-ins by
Rob Bovey (AppsPro) and John Walkenbach ("J-Walk"). This will let you
show the efficiency of each point on the pressure-flow curve as a
number.

Alternatively, are you prepared to abandon the compressor map
arrangement of pressure against flow, and plot efficiency against flow
instead? You could use the technique above to label the curves with the
pressure at each point. It might be worth showing two graphs next to
each other, one pressure-flow, and the other efficiency-flow.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Reply to this Message

erfigge - 15 Apr 2008 17:33 GMT

Thanks for your response, and I apologize for not explaining better. After
doing some thinking on this, is there any reason I couldn't make two charts,
one xy scatter and one contour with the islands and then just superimpose
them? I would obviously have to do some macro's to get the data in the
correct layout for both graphs...............

> >erfigge <erfigge@discussions.microsoft.com> said:
> >>I can make standard compressor maps in excel very easily, but does anybody
[quoted text clipped - 18 lines]
> pressure at each point. It might be worth showing two graphs next to
> each other, one pressure-flow, and the other efficiency-flow.

Reply to this Message