I need some help having a macro or something that can take a data set (45 check points = X and % stock used = Y) and it’s bell curve, compress it to fit a smaller scale such as 1-15 checkpoints and maintain the bell curve shape.
I want to type in a stock amount and weeks and it spits out a new data table that contains a bell curve similar to the original data set.
For example, I want to be able to type in “500 units” in a “Stock” cell and “20 checkpoints” in a “Checkpoints” cell and it makes a table 1-20 in the X column and their respective % used in the Y column.
If not a macro, ANYTHING helps. I’m stumped.
I want to type in a stock amount and weeks and it spits out a new data table that contains a bell curve similar to the original data set.
For example, I want to be able to type in “500 units” in a “Stock” cell and “20 checkpoints” in a “Checkpoints” cell and it makes a table 1-20 in the X column and their respective % used in the Y column.
If not a macro, ANYTHING helps. I’m stumped.