Remember Me?

#1
June 9th 18, 01:22 PM
 Junior Member First recorded activity by ExcelBanter: Jun 2018 Posts: 1
Divide a number in one cell into several others UNEVENLY

Good day, Banters,

I am not new to excel, however I am trying to divide a number of consignments randomly to a number of clients, but it now seems impossible to me.
Let me exemplify:

I am not allowed to use the real company data for a project, so:
I have a number of consignments - 30000
which i am trying to divide UNEVENLY to a number of clients - 120

All i could achieve at the moment is obtaining either an even spread throughout the sheet (250), or get a randomization for the first 50 clients or so, afterwards getting a repetitive amount.

Is there any formula/combination that can divide my sum to the clients without noticing an actual pattern?

Teddy

#2
June 9th 18, 07:27 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jan 2018 Posts: 63
Divide a number in one cell into several others UNEVENLY

On 6/9/2018 7:22 AM, tdi93 wrote:
Good day, Banters,

I am not new to excel, however I am trying to divide a number of
consignments randomly to a number of clients, but it now seems
impossible to me.
Let me exemplify:

I am not allowed to use the real company data for a project, so:
I have a number of consignments - 30000
which i am trying to divide UNEVENLY to a number of clients - 120

....

For what working definition of "UNEVENLY"?

One each to 119 and 30000-119 to one is about as uneven as gets in one
sense but I suspect that isn't what you're looking for presuming that
everybody does get at least one.

Or another way to ask the question -- what criterion would you use to
disallow a solution?

Just out of curiosity that has nothing really to do with the answer to
the question, just why is an even solution unacceptable?

--
#3
June 9th 18, 11:39 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Apr 2018 Posts: 6
Divide a number in one cell into several others UNEVENLY

On Sunday, 10 June 2018 00:49:08 UTC+12, tdi93 wrote:
Good day, Banters,

I am not new to excel, however I am trying to divide a number of
consignments randomly to a number of clients, but it now seems
impossible to me.
Let me exemplify:

I am not allowed to use the real company data for a project, so:
I have a number of consignments - 30000
which i am trying to divide UNEVENLY to a number of clients - 120

All i could achieve at the moment is obtaining either an even spread
throughout the sheet (250), or get a randomization for the first 50
clients or so, afterwards getting a repetitive amount.

Is there any formula/combination that can divide my sum to the clients
without noticing an actual pattern?

Teddy

--
tdi93

Just use a probability distributions. Beta is bounded so seems like a suitable one. For example, client ID = INT(BETA.INV(RAND(), 1, 3, 0, 120)+1)

http://www.statisticshowto.com/beta-distribution/
#4
June 10th 18, 03:28 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Apr 2015 Posts: 952
Divide a number in one cell into several others UNEVENLY

Good day, Banters,

I am not new to excel, however I am trying to divide a number of
consignments randomly to a number of clients, but it now seems
impossible to me.
Let me exemplify:

I am not allowed to use the real company data for a project, so:
I have a number of consignments - 30000
which i am trying to divide UNEVENLY to a number of clients - 120

All i could achieve at the moment is obtaining either an even spread
throughout the sheet (250), or get a randomization for the first 50
clients or so, afterwards getting a repetitive amount.

Is there any formula/combination that can divide my sum to the clients
without noticing an actual pattern?

Teddy

Use a helper column and assign a "weight" to clients which you'll use to
determine how many consignments they get. Since the mean is 250 per (3000/120)
you can use the 'Weight" value to set the variance per client. In the end, the
distribution should equal the total number of consignments.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Ramya[_2_] Excel Worksheet Functions 2 November 20th 09 05:03 PM Chey Excel Discussion (Misc queries) 10 September 19th 07 03:08 AM rhon101 Excel Discussion (Misc queries) 4 November 30th 05 02:02 AM Ursula New Users to Excel 1 April 4th 05 04:20 PM Rick Excel Discussion (Misc queries) 0 March 4th 05 07:13 PM

All times are GMT +1. The time now is 09:15 PM.