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.

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.