Data Calculation

[tmgresham]

Hello

Maybe someone can help me out with a problem.
I'm looking for a method of creating a formula that will calculate the data in this chart with only the first and last values entered. This chart is a sample of one that will calculate performance figures for an aircraft engine. the actual chart will require calculation of a couple of thousand figures.

Thanks.

Tim.


-1000 -750 -500 -250 0 250 500 750
-2 26.75 25.25
-1
0
1
2
3
4
5 26.25 24.75

 

[Norie]

Tim

Could you give some more information?

I'm not very up on my aeronautic engineering.

 

[tmgresham]

Hello

It should be a more easily understood posted as HTML.

Thanks.

Tim.


[HtmlMaker 2.42]



--------------------------------------------------------------------------------


Microsoft Excel - Sample Chart.xls ___Running: 11.0 : OS = Windows XP

(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout

J11 =


B C D E F G H I
2 -1000 -750 -500 -250 0 250 500 750
3 26.75 25.25
4
5
6
7
8
9
10 26.25 24.75
Sheet1


[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.



--------------------------------------------------------------------------------


This free code was written by Colo and Ivan F Moala:[HtmlMaker 2.42] - 15th May 2003
Code mods by Ivan F Moala - 15th May 2003

 

[Norie]

Tim

I'm afraid the HTML didn't work.

 

[tmgresham]

Microsoft Hello Had a problem getting the HTML to work properly but figured it out now i think. Hopefully this looks a little better. Thanks Tim. Excel - Sample Chart.xls
	A	B	C	D	E	F	G	H	I
2		-1000	-750	-500	-250	0	250	500	750
3	-2	26.75							25.25
4	-1
5	0
6	1
7	2
8	3
9	4
10	5	26.25							24.75
Sheet1

 

[Norie]

Tim

It certainly looks better, but I'm afraid I still don't know what you want to do.

I assume it's something to do with filling in the blank values?

 

[tmgresham]

Hello

Yes

I am interested in finding a way to fill in the blank cells in between.

Thanks

Tim.

 

[Norie]

Tim

But how should they be filled in? Like I said I know nothing about aeronautic engineering.

 

[tmgresham]

Hello

The cell values need to be calculated in this manner only knowing the first and last values in a row or column to start. I could do this using the fill handle but a formula would be much more accurate and efficient.

Thank you for any help you can offer.

Tim.

Sample Chart.xls
	A	B	C	D	E	F	G	H	I
2		-1000	-750	-500	-250	0	250	500	750
3	-2	26.75	26.536	26.322	26.108	25.894	25.68	25.466	25.252
4	-1	26.678	26.464	26.25	26.036	25.822	25.608	25.394	25.18
5	0	26.606
6	1	26.534
7	2	26.462
8	3	26.39
9	4	26.318
10	5	26.246							24.75
Sheet1

 

[joelnichols]

Come on guys this isnt rocket science...oh wait..it is nevermind