distribution

  1. T

    How do I redistribute sales fairly if I want to increase the growth percentage?

    I am working on a sales forecast for 2020. The forecast has 92 locations and I have sales by week by site for Period 1 2019 and a forecast of sales by week for Period 1 2020. Period 1 2019 Sales Total: $11,586,579 Period 1 2020 Sales Forecast: $11,57,090 Dollar Change in sales 2019 to 2020...
  2. T

    Evenly assign workload to available employees following priority

    Hello! I have a spreadsheet with a list of items each day pertaining to cases employees work. Each case has an assigned owner but cases pile up and need to be evenly distributed. I’ve attached a dumbed down version of my spreadsheet without sensitive information. I need to assign the list...
  3. S

    Macro to pull members from distribution list.

    Hi All, New to the Excel world. Need your help in providing me the excel macro to pull the member details from outlook distribution list. Can any one help me. Thank You !! Regards, Santy
  4. M

    Which histogram formula is correct?

    Poking around on the web I find various formulas for creating histograms. I'm getting different results for each formula and I want to know which one is accurate. I have a table of purchase orders and I want to get the distribution of how many POs are in various dollar ranges (e.g. how many...
  5. A

    Email distribution list

    Is there any way to be able to access a spreadsheet based distribution list from outlook without having to create and then edit (as changes are made in the original spreadsheet) a static contact list in outlook?
  6. T

    [Excel] Need help in generating formula for Distribution Fitting(Gumbel)

    Hello, I'm currently updating a distribution fitting template used in simulation based on historical data. I found the formula for Gumbel distribution from this thread, which is Location - Scale * LN(-LN(RAND())), for generating x...
  7. U

    Degree Of Freedom For Student T Distribution

    I need help on how to estimate the degree of freedom using Maximum Likelihood procedure for student t distribution. I am working with multivariate random variables.
  8. F

    Frequency Distribution of streaks

    Hello, I need the frequency distribution of streaks like 0 -1 -1 -> 2 0 0 -1 -1 -1 -> 3 0 Is there a way to create a column like column 2 in excel so that I can create a histogram that shows the data. Thanks for any help.
  9. H

    Forecasting Curve Distribution

    Hello, I am working on a forecasting model and have run into some trouble when trying to extend the X-Axis of a 12-month Curve Distribution to a longer time frame. Given a distribution of 12 percentages (one for each month), how can I spread the 12 months or periods to say 18 months while...
  10. D

    Cell Distribution

    Hello, Just want to ask if there is an easy way to distribute the data from Column A to Column B, the result will be on Column D&E.
  11. E

    Exponential distribution

    Hi there, How do i generate a set of data using exponential distribution with a mean of 10? Thank you!
  12. J

    Formula/UDF for Variance for Folded Normal distribution

    I am looking for a formula/UDF for computing the Variance of Folded-Normal distribution. The formula for the same can be referenced at https://en.wikipedia.org/wiki/Folded_normal_distribution
  13. S

    Excel - Outlook Connection

    Hi I put together an Excel report each morning that takes up one worksheet (about 55 rows & 26 columns). Once compiled, I have to email it out to a distribution list. Is there some way (may code based) that I can have a button on that worksheet that I activate that then automatically places...
  14. M

    Multiple based prorate distribution by weights

    I'd need to proportionally distribute (prorate) a value (integer number of products for a promotion) - by multiple of n - across a list, based on the relative weights (i.e. distribution of the sales) of "basis" values in the list.
  15. M

    Why my data does not give a bell curve graph? normal distribution formulas used

    Hi Guys, I have been trying to create a bell curve / normal distribution chart but my data does not give a belle curve. What do I do wrong ? Given X values, I use formula z= STANDARDIZE Fx = NORM.DIST <colgroup><col span="3"></colgroup><tbody> X z f(x) 490 0.9 0.029 490 0.9 0.029...
  16. N

    modeling Monte Carlo with non-standard distribution

    Hello everybody, I'm using the NORMINV() function to calculate likely random outcomes of specific variables in a Monte Carlo simulation. (Modeling this after the example from the excellent book, How To Measure Anything.) However, NORMINV() uses standard distribution. What if my distribution is...
  17. M

    Extracting from a column

    IV:9710388235LADD DISTRIBUTION LLC Did a search on extract, but couldnt find a solution, so I wanted to see if someone could help out. I want to populate 3 columns from 1 column. Column 1 would have IV: - simple enough as I can trim 3 characters. Column 2 would have 9710388235 - Anything...
  18. L

    Powerpivot distribution by Zone/Area - security options

    Hi, I am new to powerpivots. I have an Excel report with Data Model that I am looking to distribute to different Zone owners. There are 7 Zones, and the source data has all of them. How do I limit the report that I distribute only to one Zone since I do not want other Zone owners to see other...
  19. S

    Dynamic bins for mulitple data sets

    Hi Everyone, I'm not that technical and I'm hoping someone wouldn't mind helping. I have multiple data sets which vary both in range (lower and upper bounds?). Each data set will also change for each new scenario, for example on any given date Set 1 might have a range of -4 to +4 and the next...
  20. I

    Multiple Budgets over a range of months and years, with monthly cost/estimate showing by month for each project

    I have hundreds of rows of data. Each row is a project and cost with start date and end date. Some projects are old and complete, others have started and are ongoing and some have not even started. Using the full range of dates, I want to show the cost of each project by month. I've added the...

Some videos you may like

This Week's Hot Topics

Top