help to complete a Holley Jet calculation using VLOOKUP

portcity05

New Member
Joined
Jun 2, 2009
Messages
10
Hi I am need of some help to complete a Holley Jet calculation to determine a Jet change for a given weather condition using ADR (Air Density Ratio) from a Race-air Pro computer.
This is normaly a simple calculation but in this case we have to calculate a Jet change to include a drilled hole (non removeable Jet) and a removable Jet
(1) I need to find a way to extract the fuel flow from a Holley Jet chart.
(2) I need to find a way to extract the correct Jet size from the fuel flow on the chart.
The problem being the chart only contains whole numbers.
For example; The Jet chart reads as per below.
Holley Jet 80 flows 56.2 lb/hr
Holley Jet 81 flows 58.5 lb/hr
I need to get the fuel flow for a 80.6 calculated Jet size, the answer should be 57.6
I can get an answer if I add fuel flow calculations to the Holley Jet chart for every .1 of a Jet size
=VLOOKUP(B17,'Holley Jet Chart'!$A$4:$G$404,6)
But, I still need to return a final Jet size according to the new fuel flow calculation?
Again, the numbers are not whole numbers to find with VLOOKUP
I am hoping a calculation can be added to find and calculate numbers that are not whole numbers?????
I hope I have explained in away that I have not overcomplicated the question and totally confuse you.
regards Terry

[TABLE="width: 909"]
<TBODY>[TR]
[TD="colspan: 11"]Jetting calculation for a Holley carby with an extra hole above the main Jets (Jetting is compensated by changing the removable Jets only)</SPAN>[/TD]
[/TR]
[TR]
[TD="colspan: 7"](1) Enter the Dyno ADR, Jet-A and Jet-B data</SPAN>[/TD]
[TD][/TD]
[TD]Dyno</SPAN>[/TD]
[TD]Main </SPAN>[/TD]
[TD]Fixed</SPAN>[/TD]
[/TR]
[TR]
[TD="colspan: 7"](2) Add the new Race-Air Jet-A and Jet-B to the chart according to the new ADR</SPAN>[/TD]
[TD][/TD]
[TD]ADR</SPAN>[/TD]
[TD]Jet-A</SPAN>[/TD]
[TD]Jet-B</SPAN>[/TD]
[/TR]
[TR]
[TD="colspan: 7"](3) Read the new Jet calculation according to the new ADR (green list)</SPAN>[/TD]
[TD][/TD]
[TD]96.6</SPAN>[/TD]
[TD]80.0</SPAN>[/TD]
[TD]86.0</SPAN>[/TD]
[/TR]
[TR]
[TD="colspan: 7"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="colspan: 3"]Main Jet - removable (A)</SPAN>[/TD]
[TD="colspan: 3"]Drilling above Main Jet (B)</SPAN>[/TD]
[TD] [/TD]
[TD="colspan: 3"]Main Jet compensated (A+)</SPAN>[/TD]
[/TR]
[TR]
[TD]Dyno</SPAN>[/TD]
[TD]Main </SPAN>[/TD]
[TD]LB/HR</SPAN>[/TD]
[TD]Flow</SPAN>[/TD]
[TD]Fixed</SPAN>[/TD]
[TD]LB/HR</SPAN>[/TD]
[TD]Flow</SPAN>[/TD]
[TD]Dyno</SPAN>[/TD]
[TD]New Main</SPAN>[/TD]
[TD]LB/HR</SPAN>[/TD]
[TD]Flow</SPAN>[/TD]
[/TR]
[TR]
[TD]ADR</SPAN>[/TD]
[TD]Jet-A</SPAN>[/TD]
[TD]Flow</SPAN>[/TD]
[TD]difference</SPAN>[/TD]
[TD]Jet-B</SPAN>[/TD]
[TD]Flow</SPAN>[/TD]
[TD]difference</SPAN>[/TD]
[TD]ADR</SPAN>[/TD]
[TD]Jet-A+</SPAN>[/TD]
[TD]Flow</SPAN>[/TD]
[TD]difference</SPAN>[/TD]
[/TR]
[TR]
[TD]96.6</SPAN>[/TD]
[TD]80.0</SPAN>[/TD]
[TD]56.2</SPAN>[/TD]
[TD] [/TD]
[TD]86.0</SPAN>[/TD]
[TD]71.2</SPAN>[/TD]
[TD] [/TD]
[TD]96.6</SPAN>[/TD]
[TD]80.0</SPAN>[/TD]
[TD]56.2</SPAN>[/TD]
[TD]Combined</SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]ADR</SPAN>[/TD]
[TD]New Jet</SPAN>[/TD]
[TD="colspan: 2"]lb's per hour fuel flow</SPAN>[/TD]
[TD]New Jet</SPAN>[/TD]
[TD="colspan: 2"]lb's per hour fuel flow</SPAN>[/TD]
[TD]ADR</SPAN>[/TD]
[TD]New Jet</SPAN>[/TD]
[TD="colspan: 2"]lb's per hour fuel flow</SPAN>[/TD]
[/TR]
[TR]
[TD]Race-Air</SPAN>[/TD]
[TD]Race-Air</SPAN>[/TD]
[TD]jet flow</SPAN>[/TD]
[TD]difference</SPAN>[/TD]
[TD]Race-Air</SPAN>[/TD]
[TD]jet flow</SPAN>[/TD]
[TD]difference</SPAN>[/TD]
[TD]Race-Air</SPAN>[/TD]
[TD]Calculation</SPAN>[/TD]
[TD]jet flow</SPAN>[/TD]
[TD]difference</SPAN>[/TD]
[/TR]
[TR]
[TD]86</SPAN>[/TD]
[TD]77.4</SPAN>[/TD]
[TD]50.2</SPAN>[/TD]
[TD]-6.0</SPAN>[/TD]
[TD]82.8</SPAN>[/TD]
[TD]63.1</SPAN>[/TD]
[TD]-8.1</SPAN>[/TD]
[TD]86</SPAN>[/TD]
[TD]73.4</SPAN>[/TD]
[TD]42.1</SPAN>[/TD]
[TD]-14.1</SPAN>[/TD]
[/TR]
[TR]
[TD]87</SPAN>[/TD]
[TD]77.7</SPAN>[/TD]
[TD]50.9</SPAN>[/TD]
[TD]-5.3</SPAN>[/TD]
[TD]83.1</SPAN>[/TD]
[TD]63.8</SPAN>[/TD]
[TD]-7.4</SPAN>[/TD]
[TD]87</SPAN>[/TD]
[TD]74.1</SPAN>[/TD]
[TD]43.5</SPAN>[/TD]
[TD]-12.7</SPAN>[/TD]
[/TR]
[TR]
[TD]88</SPAN>[/TD]
[TD]77.9</SPAN>[/TD]
[TD]51.4</SPAN>[/TD]
[TD]-4.8</SPAN>[/TD]
[TD]83.4</SPAN>[/TD]
[TD]64.5</SPAN>[/TD]
[TD]-6.7</SPAN>[/TD]
[TD]88</SPAN>[/TD]
[TD]74.7</SPAN>[/TD]
[TD]44.7</SPAN>[/TD]
[TD]-11.5</SPAN>[/TD]
[/TR]
[TR]
[TD]89</SPAN>[/TD]
[TD]78.2</SPAN>[/TD]
[TD]52.1</SPAN>[/TD]
[TD]-4.1</SPAN>[/TD]
[TD]83.7</SPAN>[/TD]
[TD]65.2</SPAN>[/TD]
[TD]-6.0</SPAN>[/TD]
[TD]89</SPAN>[/TD]
[TD]75.5</SPAN>[/TD]
[TD]46.1</SPAN>[/TD]
[TD]-10.1</SPAN>[/TD]
[/TR]
[TR]
[TD]90</SPAN>[/TD]
[TD]78.4</SPAN>[/TD]
[TD]52.6</SPAN>[/TD]
[TD]-3.6</SPAN>[/TD]
[TD]84.0</SPAN>[/TD]
[TD]65.9</SPAN>[/TD]
[TD]-5.3</SPAN>[/TD]
[TD]90</SPAN>[/TD]
[TD]76.2</SPAN>[/TD]
[TD]47.3</SPAN>[/TD]
[TD]-8.9</SPAN>[/TD]
[/TR]
[TR]
[TD]91</SPAN>[/TD]
[TD]78.7</SPAN>[/TD]
[TD]53.4</SPAN>[/TD]
[TD]-2.8</SPAN>[/TD]
[TD]84.3</SPAN>[/TD]
[TD]66.7</SPAN>[/TD]
[TD]-4.5</SPAN>[/TD]
[TD]91</SPAN>[/TD]
[TD]76.9</SPAN>[/TD]
[TD]48.9</SPAN>[/TD]
[TD]-7.3</SPAN>[/TD]
[/TR]
[TR]
[TD]92</SPAN>[/TD]
[TD]78.9</SPAN>[/TD]
[TD]53.9</SPAN>[/TD]
[TD]-2.3</SPAN>[/TD]
[TD]84.6</SPAN>[/TD]
[TD]67.5</SPAN>[/TD]
[TD]-3.7</SPAN>[/TD]
[TD]92</SPAN>[/TD]
[TD]77.5</SPAN>[/TD]
[TD]50.3</SPAN>[/TD]
[TD]-5.9</SPAN>[/TD]
[/TR]
[TR]
[TD]93</SPAN>[/TD]
[TD]79.1</SPAN>[/TD]
[TD]54.4</SPAN>[/TD]
[TD]-1.8</SPAN>[/TD]
[TD]84.9</SPAN>[/TD]
[TD]68.3</SPAN>[/TD]
[TD]-2.9</SPAN>[/TD]
[TD]93</SPAN>[/TD]
[TD]78.0</SPAN>[/TD]
[TD]51.5</SPAN>[/TD]
[TD]-4.7</SPAN>[/TD]
[/TR]
[TR]
[TD]94</SPAN>[/TD]
[TD]79.4</SPAN>[/TD]
[TD]55.0</SPAN>[/TD]
[TD]-1.2</SPAN>[/TD]
[TD]85.2</SPAN>[/TD]
[TD]69.1</SPAN>[/TD]
[TD]-2.1</SPAN>[/TD]
[TD]94</SPAN>[/TD]
[TD]78.5</SPAN>[/TD]
[TD]52.9</SPAN>[/TD]
[TD]-3.3</SPAN>[/TD]
[/TR]
[TR]
[TD]95</SPAN>[/TD]
[TD]79.6</SPAN>[/TD]
[TD]55.4</SPAN>[/TD]
[TD]-0.8</SPAN>[/TD]
[TD]85.5</SPAN>[/TD]
[TD]69.9</SPAN>[/TD]
[TD]-1.3</SPAN>[/TD]
[TD]95</SPAN>[/TD]
[TD]79.0</SPAN>[/TD]
[TD]54.1</SPAN>[/TD]
[TD]-2.1</SPAN>[/TD]
[/TR]
[TR]
[TD]96</SPAN>[/TD]
[TD]79.9</SPAN>[/TD]
[TD]56.0</SPAN>[/TD]
[TD]-0.2</SPAN>[/TD]
[TD]85.8</SPAN>[/TD]
[TD]70.7</SPAN>[/TD]
[TD]-0.5</SPAN>[/TD]
[TD]96</SPAN>[/TD]
[TD]79.7</SPAN>[/TD]
[TD]55.5</SPAN>[/TD]
[TD]-0.7</SPAN>[/TD]
[/TR]
[TR]
[TD]97</SPAN>[/TD]
[TD]80.1</SPAN>[/TD]
[TD]56.4</SPAN>[/TD]
[TD]0.2</SPAN>[/TD]
[TD]86.1</SPAN>[/TD]
[TD]71.5</SPAN>[/TD]
[TD]0.3</SPAN>[/TD]
[TD]97</SPAN>[/TD]
[TD]80.2</SPAN>[/TD]
[TD]56.7</SPAN>[/TD]
[TD]0.5</SPAN>[/TD]
[/TR]
[TR]
[TD]98</SPAN>[/TD]
[TD]80.3</SPAN>[/TD]
[TD]56.9</SPAN>[/TD]
[TD]0.7</SPAN>[/TD]
[TD]86.4</SPAN>[/TD]
[TD]72.2</SPAN>[/TD]
[TD]1.0</SPAN>[/TD]
[TD]98</SPAN>[/TD]
[TD]80.8</SPAN>[/TD]
[TD]57.9</SPAN>[/TD]
[TD]1.7</SPAN>[/TD]
[/TR]
[TR]
[TD]99</SPAN>[/TD]
[TD]80.6</SPAN>[/TD]
[TD]57.6</SPAN>[/TD]
[TD]1.4</SPAN>[/TD]
[TD]86.7</SPAN>[/TD]
[TD]73.0</SPAN>[/TD]
[TD]1.8</SPAN>[/TD]
[TD]99</SPAN>[/TD]
[TD]81.4</SPAN>[/TD]
[TD]59.4</SPAN>[/TD]
[TD]3.2</SPAN>[/TD]
[/TR]
[TR]
[TD]100</SPAN>[/TD]
[TD]80.8</SPAN>[/TD]
[TD]58.0</SPAN>[/TD]
[TD]1.8</SPAN>[/TD]
[TD]87.0</SPAN>[/TD]
[TD]73.8</SPAN>[/TD]
[TD]2.6</SPAN>[/TD]
[TD]100</SPAN>[/TD]
[TD]81.8</SPAN>[/TD]
[TD]60.6</SPAN>[/TD]
[TD]4.4</SPAN>[/TD]
[/TR]
[TR]
[TD]101</SPAN>[/TD]
[TD]81.1</SPAN>[/TD]
[TD]58.8</SPAN>[/TD]
[TD]2.6</SPAN>[/TD]
[TD]87.3</SPAN>[/TD]
[TD]74.5</SPAN>[/TD]
[TD]3.3</SPAN>[/TD]
[TD]101</SPAN>[/TD]
[TD]82.4</SPAN>[/TD]
[TD]62.1</SPAN>[/TD]
[TD]5.9</SPAN>[/TD]
[/TR]
[TR]
[TD]102</SPAN>[/TD]
[TD]81.3</SPAN>[/TD]
[TD]59.3</SPAN>[/TD]
[TD]3.1</SPAN>[/TD]
[TD]87.6</SPAN>[/TD]
[TD]75.2</SPAN>[/TD]
[TD]4.0</SPAN>[/TD]
[TD]102</SPAN>[/TD]
[TD]82.9</SPAN>[/TD]
[TD]63.4</SPAN>[/TD]
[TD]7.1</SPAN>[/TD]
[/TR]
[TR]
[TD]103</SPAN>[/TD]
[TD]81.5</SPAN>[/TD]
[TD]59.9</SPAN>[/TD]
[TD]3.7</SPAN>[/TD]
[TD]87.9</SPAN>[/TD]
[TD]76.0</SPAN>[/TD]
[TD]4.8</SPAN>[/TD]
[TD]103</SPAN>[/TD]
[TD]83.5</SPAN>[/TD]
[TD]64.6</SPAN>[/TD]
[TD]8.4</SPAN>[/TD]
[/TR]
[TR]
[TD]104</SPAN>[/TD]
[TD]81.8</SPAN>[/TD]
[TD]60.7</SPAN>[/TD]
[TD]4.5</SPAN>[/TD]
[TD]88.2</SPAN>[/TD]
[TD]76.8</SPAN>[/TD]
[TD]5.6</SPAN>[/TD]
[TD]104</SPAN>[/TD]
[TD]84.1</SPAN>[/TD]
[TD]66.2</SPAN>[/TD]
[TD]10.0</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=11></COLGROUP>[/TABLE]
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Forum statistics

Threads
1,223,237
Messages
6,170,930
Members
452,367
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top