software

I have a list of numbers in 1 column that total to a specific number. I want
to create two separate columns whose indidvdual totals are as close as
possible to the original total and the two new column lengths are as close as
possible.
Please supply more details........

Vaya con Dios,
Chuck, CABGx3
quot;jimFquot; wrote:

gt; I have a list of numbers in 1 column that total to a specific number. I want
gt; to create two separate columns whose indidvdual totals are as close as
gt; possible to the original total and the two new column lengths are as close as
gt; possible.
gt;
gt;

My single column is a list 20 random entries(in seconds) that total 2000 sec
.. From that single list, I want to create two separate lists that total
close to 1000 seconds each and, if possible, have the two new lists with
close to equal number of entries.

quot;CLRquot; wrote:

gt; Please supply more details........
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;jimFquot; wrote:
gt;
gt; gt; I have a list of numbers in 1 column that total to a specific number. I want
gt; gt; to create two separate columns whose indidvdual totals are as close as
gt; gt; possible to the original total and the two new column lengths are as close as
gt; gt; possible.
gt; gt;
gt; gt;

So, ideally, you would wind up with two new lists, each of 10 items,
extracted from the 20 item list in column A and each totalling 1000
sec.............is that it?

Vaya con Dios,
Chuck, CABGx3

quot;jimFquot; wrote:

gt; My single column is a list 20 random entries(in seconds) that total 2000 sec
gt; . From that single list, I want to create two separate lists that total
gt; close to 1000 seconds each and, if possible, have the two new lists with
gt; close to equal number of entries.
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Please supply more details........
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;jimFquot; wrote:
gt; gt;
gt; gt; gt; I have a list of numbers in 1 column that total to a specific number. I want
gt; gt; gt; to create two separate columns whose indidvdual totals are as close as
gt; gt; gt; possible to the original total and the two new column lengths are as close as
gt; gt; gt; possible.
gt; gt; gt;
gt; gt; gt;

Correct, that would be ideal with more emphasis on each list totaling 1000
sec and less emphasis. on each being 10 items long.

Thanks for your assistance

quot;CLRquot; wrote:

gt; So, ideally, you would wind up with two new lists, each of 10 items,
gt; extracted from the 20 item list in column A and each totalling 1000
gt; sec.............is that it?
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt;
gt; quot;jimFquot; wrote:
gt;
gt; gt; My single column is a list 20 random entries(in seconds) that total 2000 sec
gt; gt; . From that single list, I want to create two separate lists that total
gt; gt; close to 1000 seconds each and, if possible, have the two new lists with
gt; gt; close to equal number of entries.
gt; gt;
gt; gt; quot;CLRquot; wrote:
gt; gt;
gt; gt; gt; Please supply more details........
gt; gt; gt;
gt; gt; gt; Vaya con Dios,
gt; gt; gt; Chuck, CABGx3
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;jimFquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have a list of numbers in 1 column that total to a specific number. I want
gt; gt; gt; gt; to create two separate columns whose indidvdual totals are as close as
gt; gt; gt; gt; possible to the original total and the two new column lengths are as close as
gt; gt; gt; gt; possible.
gt; gt; gt; gt;
gt; gt; gt; gt;

I was afraid you were going to say that lt;ggt;........I don't have a clue how
to do that automatically, but with only a 20 item list, I was able to set up
the three columns and put the =SUM(B1:B20) in cell B21 and =SUM(C1:C20) in
cell C21 and then just moving the values back and forth from column A to
columns B and C to balance B21 and C21.........in my sample it didn't take
too long.

Maybe some quot;statisticalquot; type guy can see this and give you a better answer.

hth
Vaya con Dios,
Chuck, CABGx3
quot;jimFquot; wrote:

gt; Correct, that would be ideal with more emphasis on each list totaling 1000
gt; sec and less emphasis. on each being 10 items long.
gt;
gt; Thanks for your assistance
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; So, ideally, you would wind up with two new lists, each of 10 items,
gt; gt; extracted from the 20 item list in column A and each totalling 1000
gt; gt; sec.............is that it?
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;jimFquot; wrote:
gt; gt;
gt; gt; gt; My single column is a list 20 random entries(in seconds) that total 2000 sec
gt; gt; gt; . From that single list, I want to create two separate lists that total
gt; gt; gt; close to 1000 seconds each and, if possible, have the two new lists with
gt; gt; gt; close to equal number of entries.
gt; gt; gt;
gt; gt; gt; quot;CLRquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Please supply more details........
gt; gt; gt; gt;
gt; gt; gt; gt; Vaya con Dios,
gt; gt; gt; gt; Chuck, CABGx3
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;jimFquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I have a list of numbers in 1 column that total to a specific number. I want
gt; gt; gt; gt; gt; to create two separate columns whose indidvdual totals are as close as
gt; gt; gt; gt; gt; possible to the original total and the two new column lengths are as close as
gt; gt; gt; gt; gt; possible.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;