distribution

  1. P

    Value Distribution Based on Dates

    I am trying to estimate ticket sales for about 10 events, Scenario : 1st Event Ticket Sales Start Date : Oct 1st , Event Date : Dec 31st -- Which means we have 13 weeks to sell tickets. My estimate is to sell 100 tickets, logic is 10% of the tickets will sell on the first 10 weeks and...
  2. S

    Distribution based on dates

    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...
  3. M

    Distribution Lists

    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...
  4. N

    Look for help with random number sets and equal distribution

    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...
  5. N

    Generating multiple random number sets with even distribution

    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...
  6. M

    Two Questions:Roundup to the max value of

    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...
  7. M

    Continue the trend out another 30 rows and cloumns

    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...
  8. L

    Reverse Poisson?

    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...
  9. pedie

    Distributing TYV in table - I think VBA can handle this. Thanks for helping!

    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...
  10. H

    Selective data from each column, sum, convert to %

    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...
  11. E

    Normal Distribution in Excel

    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 $...
  12. R

    Spreading revenue over time

    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...
  13. S

    Bell Curve Distribution

    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?
  14. M

    macro workbook other users

    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...
  15. M

    Negative Exponential Distribution in VBA?

    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
  16. N

    Creating a distribution model

    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...
  17. S

    reverse distribution of excel totals

    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...
  18. R

    Powerful Histogram Concept!

    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...
  19. U

    Distributing value in cells using defined profile

    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"...
  20. P

    In desperate need of grading formula

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top