Auto fill my whole grid

[leisuredog]

I have a grid and I know the costs of the item, in all of the four corners I want excel to calculate the mean averages & fill in the other cells

 

[shg]

You're welcome.

 

[keithmct]

what if....
instead of averaging the entries between the corners, I wanted to "weight" a certain section of the grid. Could I input one entry somewhere in the grid and average out towards the corner numbers?

 

[shg]

I don't know what that means.

 

[keithmct]

what I mean by weighted is, say I wanted a 3x3 or 4x4 range of the table to have slightly increased (7%) values but not exceed the values of the non affected cells. Or if it did exceed those cells have the grid recalculate the averages from there to the corner values. I'll try and insert an example.

1000	956	912	867	823	778	734	689	645	600
975	928	880	832	784	737	689	641	593	545
950	899	848	797	746	695	644	593	542	490
925	871	817	762	708	653	599	544	490	435
900	843	785	727	669	612	554	496	438	380
875	814	753	692	631	570	509	448	387	325
850	786	722	657	593	528	464	399	335	270
825	758	690	622	554	487	419	351	283	215
800	729	658	587	516	445	374	303	232	160
775	701	627	552	478	403	329	254	180	105
750	673	595	517	439	362	284	206	128	50
				107%
1000	956	912	867	823	778	734	689	645	600
975	928	880	832	784	737	689	641	593	545
950	962	907	853	746	695	644	593	542	490
925	932	874	815	708	653	599	544	490	435
900	902	840	778	669	612	554	496	438	380
875	814	753	692	631	570	509	448	387	325
850	786	722	657	593	528	464	399	335	270
825	758	690	622	554	487	419	351	283	215
800	729	658	587	516	445	374	303	232	160
775	701	627	552	478	403	329	254	180	105
750	673	595	517	439	362	284	206	128	50

I've increased the filled section by 7% but all numbers must increase towards the left and the top so the filled section needs to remain the same but the other cells need to be recalculated.

 

[shg]

Dunno.

 

[keithmct]

thanks for responding anyway. what I ended up doing is making a table (table 2) with percentages (what I call weighting) to apply to the output grid (table 1) and show the result in table 3. sort of changed my mind how I wanted it to work towards the corners but this will give me a starting point.

table 1
	a	b	c	d	e	f	g	h	i	j
1	1000	956	912	867	823	778	734	689	645	600
2	950	906	862	817	773	728	684	639	595	550
3	900	856	812	767	723	678	634	589	545	500
4	850	806	762	717	673	628	584	539	495	450
5	800	756	712	667	623	578	534	489	445	400
6	750	706	662	617	573	528	484	439	395	350
7	700	656	612	567	523	478	434	389	345	300
8	650	606	562	517	473	428	384	339	295	250
9	600	556	512	467	423	378	334	289	245	200
10	550	506	462	417	373	328	284	239	195	150
11	500	456	412	367	323	278	234	189	145	100
table 2
	a	b	c	d	e	f	g	h	i	j
1	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%
2	100%	105%	105%	105%	105%	100%	100%	100%	100%	100%
3	100%	105%	105%	105%	105%	100%	100%	100%	100%	100%
4	100%	105%	110%	110%	95%	95%	95%	95%	100%	100%
5	100%	105%	110%	110%	95%	95%	95%	95%	100%	100%
6	100%	105%	110%	110%	95%	95%	95%	100%	100%	100%
7	100%	105%	120%	120%	95%	95%	100%	100%	100%	100%
8	100%	105%	105%	105%	105%	100%	100%	100%	100%	100%
9	100%	105%	105%	105%	105%	105%	105%	105%	105%	100%
10	100%	105%	105%	105%	105%	105%	105%	105%	105%	100%
11	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%
table 3	a	b	c	d	e	f	g	h	i	j
1	1000	956	912	867	823	778	734	689	645	600
2	950	951	905	858	812	728	684	639	595	550
3	900	899	853	805	759	678	634	589	545	500
4	850	846	838	789	639	597	555	512	495	450
5	800	794	783	734	592	549	507	465	445	400
6	750	741	728	679	544	502	460	439	395	350
7	700	689	734	680	497	454	434	389	345	300
8	650	636	590	543	497	428	384	339	295	250
9	600	584	538	490	444	397	351	303	257	200
10	550	531	485	438	392	344	298	251	205	150
11	500	456	412	367	323	278	234	189	145	100