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