For a start this is probably the wrong institution to ask, it is more likely that somebody will have this in the IMechE. But also, there are so many other questions: is this for business use? If so, are you prepared to pay for it? And which Excel sheet do you mean? What is it calculating? What are you going to use it for? Do you think there is already one? What have you already done to try to find one?

If you explain all that in your question you are much more likely to get a useful answer. Do please remember that this is a forum for busy engineers to help each other!

Thanks,

Andy

Hi Millar. Generally, I am looking for an Excel spread sheet (basically a calculation sheet) to derive the compressor stages, motor rating, etc. by inputting some process data. I am going to use this in my daily job activities. There are lots of calculation spread sheets available for pumps at various sites, but for compressors, I couldn't find them. Although we are doing manual calculations, sometimes it will be easy to have a calculation spread sheet to get a quick output.

Apart from the above, I have the impression that IET is a professional authority for all engineering backgrounds and not specific to any department. I have read this in some articles as well. From your first line of response, I'm worried now that IET is not for mechanical engineers. I was planning to apply for professional registration with IET.

Generally Excel is intended for accounting spreadsheets.and although the VBA in the background can be pressed into service as a general purpose programming language, it is only really suited for simpler problems, being run-time interpreted rather than compiled. It is of course possible to make it call other programmes either as DLL calls, or for things that expose an active -X interface. You may find it worthwhile to learn how to do this, as  if you have already paid for Office then Excel is free. However, the fact that many people have excel is about the only argument in its favour. 

I suspect many of us have odd snippets of code for different functions, in various states and programming languages, although if these have been commercially developed then sharing may be an issue.  I'd be surprised if what you describe above  exists exactly. however.

And, as Andy alludes, this discussion board is not the IET - I do not actually have  a professional  membership at all for example, and yet I post here quite often, but rather it is a point of exchange of ideas and discussion among  a mixed bag of professionals and amateurs. If  we charged our various  going rates for time spent on here it would be a quiet place.

Mike.

Sunil Francis said:

IET is a professional authority for all engineering backgrounds and not specific to any department

It's interesting (and a very fair point). If you look at the discussions on these forums you will see that most of them are about electrical engineering, because the IET grew out of the IEE. The IET itself does cater for all engineering specialisms in its professional registration, which makes sense as many of us move across them anyway. But you will find much more information here about electrical engineering than anything else. I'm not an electrical engineer, but I didn't fit into any of the other institutes either!

So I agree it is a bit strange.

Re commercial use, I do see where you are starting from that if someone has what you want already written then it saves you the time repeating what they've done, but I suspect it would only be compressor suppliers who would be happy to make this freely available (and if they did you would probably have found it). Anyone who's developed it for their own work would probably not want the hassle of trying to support you understanding their application. And there's also the risk that you come back and complain that the compressor it specified blew up in practice -  all of us who have been around for a while know that however much people say that they understand information is freely given "with no guarantee" things can still get nasty if it goes wrong. But you may get lucky and find someone who has something they are happy to share.

P.S. I slightly disagree with Mike, I probably would use Excel to do what you're asking for, but that's just because I tend to use Excel for everything these days! Years ago I might have used MathCAD or MATLAB, but I'm way too out of practice now. I assume you're meaning something as simple as this https://www.myengineeringtools.com/Excel/Compressor_Power_Calculator_28_05_20.xlsx

Good luck, and thanks for posting the fuller explanation,

Andy