Turbo Sizing pre calcs, but I need a Microsoft Excel expert

[ciper]

Im going to apply the following data on top of a compressor map for the stock turbo. It will also be useful for sizing others. All of this calculation was done on paper so it was quite a bit of work to type all of it, which I have not. If any important figures are missing tell me so I can post them as well. You should see my room, it looks like a filing cabinet exploded!First some data

Volumetric Efficiency estimates. Numbers of this are figured using information I have read about many other engines (trust me that I read ALOT of good and bad info!)

Using calculator for density ratio at http://www.stealth316.com/2-turbotemp.htm with the following data:

75 degree fahrenheit outside temp (or in other words intake temp)
14.7 psi of ambient air pressure (sea level)
70% compressor efficiency (most turbos are between 65 and 75)

9psi 1.34 dr
11psi 1.37
13psi 1.47
15psi 1.54



2.2 is 2212 cubic centimeter or 134.984521937548 cubic inches

3000 rpm 96%
3500 rpm 95%
4000 rpm 94%
4500 rpm 92%
5000 rpm 90%
5500 rpm 87%
6000 rpm 84%
6500 rpm 80%
7000 rpm 75%

Output of that used in formula for total air flow volume at a specific RPM "VAF = (CI/1728) x (RPM/2) x VE"

Which after calculating half of them I found a java aplication to do it http://www.stealth316.com/2-air-fuel-flow.htm Oh well, it was math excersize for my brain


15 psi boost, values in CFM. First number is at 3k rpm, 500 rpm incraments (last is 7k rpm)
173 or 4.9 m3/m
200
226
249
271
288
303
312
316 or 8.9 m3/m

13 psi boost, values in CFM
165
191
216
238
258
275
290
299
301

11 psi boost, values in CFM
154
177
201
221
241
256
270
278
281

9 psi boost, values in CFM
151 or 4.3 m3/m
174
197
217
236
250
263
272
275 or 7.8 m3/m


I need someone who can help me to use all of this information on a single graph (cant figure out how to combine them and I dont want 4 graphs)

I cannot post the Compressor maps I have, the person who shared them wished the data to remain confidential. I will take the graph and apply this against the stock maps privatly and post the information.

Here is an example


Looking at the ball bearing IHI turbo of similar spec they rate it for upto 205 hp before stepping to the next larger model. Conversion from metric horsepower PS to standard HP at http://www.mr2ownersclub.com/converter.htm

[Dr Nick]

Hope this comes up - I haven't uploaded an image before. Is this what you're looking for Ciper? If not, let me know what's missing off the graph and I'll try and add it.

If there's no image go here (http://homepage.ntlworld.com/robert.gri ... /korg.html) to view.

RobGT