Estimation Formula Based on Available Data

[MikeMikeMike]

Ok so say I have two columns:

<table style="width: 373px; height: 178px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 67pt;" width="89"> <col style="width: 48pt;" span="2" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 67pt;" height="20" width="89">Company</td> <td style="width: 48pt;" width="64"> Score
</td> <td style="width: 48pt;" width="64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Person1
</td> <td class="xl63" align="right">100,000</td> <td class="xl63">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Person2
</td> <td class="xl63" align="right">200,000</td> <td class="xl63">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Person3
</td> <td class="xl63" align="right">300,000</td> <td class="xl63">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td class="xl63" align="right">
</td> <td class="xl63">
</td> </tr> </tbody></table>Now say that above those three fields I have in three columns:

Person1 in column A and the ACTUAL Score...actual because I am person 1 and above is an estimated score for all people. Since I know my own score and I know the estimated for mine and everyone else I want to calculate the difference between my actual score and the estimated score.

Then using that difference and the estimates for everyone else create a third column that displays a more accurate estimation. Or at least another number to look at.

Any ideas on how to turn this into an excel formula?

All help is most appreciated!!

-Mike

 

[AlphaFrog]

Excel Workbook
	A	B	C	D
1	Company	Est Score	Actual score	Updated est
2	Person1	100,000	110,000
3	Person2	200,000		220,000
4	Person3	300,000		330,000
...

Cell Formulas
Range	Formula
D3	=$C$2/$B$2*B3
D4	=$C$2/$B$2*B4

Take the ratio of person1 (est / actual) and multiply that by the est, of each of the other persons.