Sorry if I made this sound confusing. :(
This is what I'm trying to do. I have a plan for the whole business and
a number of teams working towards that plan. None of the team have the
same level of experience so I'm trying to add a weighting to each team.
Then work out what percentage of the workforce each team is. Then split
the whole plan by the percentage for each team and then add the
weightings to each team.
The stretched plan & over acheiveing plan are the same thing, that just
me getting mixed up in my own terminology. It all goes wrong when I add
the weightings

I've attached the spreadsheet I've made if its any help.
The top part is the basic plan split out between each team. The middle
part adds on the stretched target. The bottom part applys the
weighting. The total of the weighted section should equal the stretched
plan. My problem is it doesn't.

I really appreciate your help with this.


+-------------------------------------------------------------------+
|Filename: Planning Test.xls.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3692 |
+-------------------------------------------------------------------+

--
Homer J
------------------------------------------------------------------------
Homer J's Profile: http://www.excelforum.com/member.php...o&userid=26166
View this thread: http://www.excelforum.com/showthread...hreadid=395256