Distribute People across Teams to balance strength/points

Hi All,
I searched for my requirement a bit but could not find anything specific or something that i could work on. Hence, posting this query.

I have a list of people(say 100) with different points per person.
I need to divide them to different teams where in, the number of people and points and balanced to the best possible limit.
I've a file with sample data for your reference.

The number of people, points and the number of teams are variable.

If there is a way where i can do initial padding ( strengthen a team beforehand) and then divide, that would be great. Eg: Adding more people and points to a team

Please help me. I am tired of doing this manually!

Regards,
hrshv

Simple way to get close. Sort by points, and then assign A-B-B-A:

	A	B	C	D	E	F	G
1	Person	Points	Team?		Team
2	P6	8	A		A	25	F2: =SUMIF($C$2:$C$17, E2, $B$2:$B$17)
3	P8	8	B		B	27
4	P9	7	B
5	P13	6	A
6	P1	4	A
7	P14	4	B
8	P4	2	B
9	P5	2	A
10	P10	2	A
11	P11	2	B
12	P15	2	B
13	P2	1	A
14	P3	1	A
15	P7	1	B
16	P12	1	B
17	P16	1	A

Another way:

	A	B	C	D	E	F	G
1				A	B
2	Person	Points	Team?	0	0		D2:E2: Input
3	P6	8	A	8	0		C3 and down: {=INDEX($D$1:$E$1, MATCH(MIN(D2:E2), D2:E2, 0))}
4	P8	8	B	8	8		D3 and across and down: =D2 + $B3 * ($C3=D$1)
5	P9	7	A	15	8
6	P13	6	B	15	14
7	P1	4	B	15	18
8	P14	4	A	19	18
9	P4	2	B	19	20
10	P5	2	A	21	20
11	P10	2	B	21	22
12	P11	2	A	23	22
13	P15	2	B	23	24
14	P2	1	A	24	24
15	P3	1	A	25	24
16	P7	1	B	25	25
17	P12	1	A	26	25
18	P16	1	B	26	26

You're welcome.