Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 9th 18, 01:22 PM
Junior Member
 
First recorded activity by ExcelBanter: Jun 2018
Posts: 1
Unhappy 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?

Thank you in advance!!

Teddy

  #2   Report Post  
Old June 9th 18, 07:27 PM posted to microsoft.public.excel.misc
dpb dpb is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2018
Posts: 61
Default 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   Report Post  
Old June 9th 18, 11:39 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2018
Posts: 6
Default 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?

Thank you in advance!!

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   Report Post  
Old June 10th 18, 03:28 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 947
Default 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?

Thank you in advance!!

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to divide the number in one cell into multiple cells Ramya[_2_] Excel Worksheet Functions 2 November 20th 09 05:03 PM
Enter number in cell and have it divide by 4 Chey Excel Discussion (Misc queries) 10 September 19th 07 03:08 AM
Divide number and add remainder in another cell rhon101 Excel Discussion (Misc queries) 4 November 30th 05 02:02 AM
How do I divide a number by another number when there is no divis. Ursula New Users to Excel 1 April 4th 05 04:20 PM
Divide one row over other row I dont wont to divide one number Rick Excel Discussion (Misc queries) 0 March 4th 05 07:13 PM


All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017