distribution

I am trying to distribute an amount in some months based on a StartDate and EndDate. I guess I've found a method to do it manually, but I want to do it all in automatically in VBA only based on the three 'variables'. I've tried to parse what I've done down below. I hope it's understandable. I...

Hi I am looking for help to help me build a distribution list from a list of email addresses in another excel spreadsheet. I am aware this probably has already been posted, but I have tried looking for the code on here all day and still unable to find one. I really need this now asap. I am...

Hey everyone, I’ve been working on some VBA for a week or two now and am still running into a few issues. I’m looking to make a random number generator that outputs sets based on pre-required input. IN ADDITION to that, I also want it to distribute the numbers output across the sets evenly...

Hey all. I’m pretty new to all this VBA still and was looking for a little help. So far, I’ve managed to write a random number generator that produces multiple sets with no repeating numbers per a set. Now, to step it up a notch, I’m trying to create an even distribution of the numbers...

Hi, I have thought out an example that may help clarify what I am looking for. Say I wished to purhcase 200 bananas for 25 retail outlets. I can only ship whole bananas. Is there a function that will split the bananas out to each store in a whole number to a max of 200 for all stores...

Below, I have included the table in which I use to select the number of days the task within the project will take to complete and the anticipated percent completed each day. I have been requested to expand this table out another 30 days. This 20/80 curve will complete 20% of the work in the...

Not sure if anyone can help with this. Basically I'm trying to find out how to apply the reverse of the Poisson function in excel. So as of now I have poisson(x value, mean, true-cumulative) and that lets me get the probability for that occurence. Basically I want to know how I can get the...

In the table below i have hilighted four cells in each row. What I am wanting to do here in that, in the way/patern it is hilighted i want the word 'TYV' to be inserted in the cells where it is hilighted. My table has 52 rows starting from c2. I dont want the code to look for the background...

have a database of properties with their local market price listed by location and price, have to be distributed between two,, in different % ( Eg 40:60, 50:50 and any % b/w 2 columns) i can play around by placing properties on both the side but should total it up to 100% the properties...

Hi, everyone, I have a quick question for normal distribution in Excel. There's a construction project with the following monthly expenditures: JUL 2008 $ 4,903 AUG 2008 $ 3,591 SEP 2008 $ 15,452 OCT 2008 $ 12,806 NOV 2008 $ 59,988 DEC 2008 $...

I am building an excel file to track revenue over time. We get paid at the end of a project but i want to spread the cash out over the life of the project. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Example:<o:p></o:p> <o:p></o:p> Start...

How can I calculate a bell curve distribution of a value across a specified number of cells? If the value is 20,000, can I ask Excel to distribute 20,000 across five cells so that the resulting values form a bell curve?

Hello. I have a workbook (not Personal.xls) that contains my macros, called My_Macros.xls and another workbook with data, let's say its called Data.xls. When I am logged on, I open both workbooks, and from Data.xls I run the macro stored in My_Macros.xls and it works fine. These files are stored...

Hello all, I was wondering if anyone has any vba for a negative exponential distribution. In particular, I'd like to generate a number with a mean as a parameter. I'm using vba to build a schedule based on statistical data. Thanks

Folks, I'm new to designing / creating spreadsheets, so please be gentle. Here's a question that I would like a suggestion on: Scenario: I have 1000 software modules to migrate to another language. I've been asked to group the 1000 modules into three buckets (Hard, moderate, easy). The...

I have an Excel problem, that I need help with.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I have the following table. I require 25 man days of work to be done at a given location. I calculate that I will need to make 10 visits to that...

I am looking to create a chart detailing the distribution of an equation that has a random number generator as a component. So, the end result would be the above mentioned equation showing a normal distribution curve (or some other distribution curve - not sure yet!!). Here is the catch...

Hi, What is the formula for distributing a value in number of cells based on defined distribution profile. Say for example using profile defined as below to be distribute value=1000 in cells. <script language="JavaScript"...

Freshman-year calculus 29 years ago was the last serious mathematical thinking I engaged in, so please bear with me. My school has a new grading formula which requires not only a given grade median, but also a set grade distribution. If I have a column of grades which range from 4.0 to 8.5...