1. J

    Forecasting resourcing using S-Curve and Polynomials

    Hi everyone, I'm trying to create a worksheet that will allow me to dynamically forecast resource requirements for projects. The idea is that the sheet requires data relating to project start and end dates, as well as the estimated resource effort at the project's maximum. Using a 'standard'...
  2. I

    Raising or discounting the price of inventory against a curve that represents the average temperature in a certain area.

    Hi all. Firstly im new here and English isnt my native tongue so I would like to apologize beforehand if my explanations aren't very clear. Truly appreciate if anyone can help me with the following: I generally have two sets of data: 1.First one is an inventory list of clothes with their...
  3. D

    Recovery Curve VBA Code help to reduce repetitive Parts

    HI Everyone, I have some vba code that I’ve been using for years that I use to project the recoveries of an asset over some period of time according to a vector. So if I have cash outlay in period 1, I have a curve that recovers that cash amount over some period time (let’s say 24 months)...
  4. T

    How to calculate the area under a Weibull curve

    Hi all, I'm practising my survival analysis skills and I'm trying to conduct a partitioned survival model by means of a Weibull distribution. I can easily manage to do so for exponential distributions, where the survival function is denoted as s(t)=EXP(-(EXP(-intercept)*t)). The area under the...
  5. M

    input construction costs into a development appraisal

    I want to be able to automatically enter the value of monthly construction costs following an s curve spend profile. I want the ability to simply enter the contract value and monthly term to create a spend profile that follows the s curve principle. Anybody cracked this?
  6. T

    Index function complications

    Ok, so I've gotten a lot of use from this forum and now I have a question I haven't been able to find an answer to, I'm totally shocked by that fact...I'll probably learn I wasn't using the right search terms lol. Lots of detail here, possibly too much but hopefully better than not-enough :rofl...
  7. 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...
  8. D

    Find greater x value of a curve that corresponds to a y value

    I want to find the x value which corresponds which half the maximum of the y value, and i want the x value to be greater than the x value which corresponds to the maximum y value So if you had a curve, and you looked at where the y corresponds to the x there would be 2 values. I want to find...
  9. P

    Normal Distribution not working properly Bell Curve

    Hi everyone, I'm trying to do a normal distribution bell curve on a range of salaries. The x-axis seems not to be reading the salaries and hence I am not getting the right bell curve shape even though my data is normally distributed. I've done this before and it worked so I'm confused why its...
  10. M

    Defining Points Along Exponential Trendline

    I let Excel provide an Exponential Curve for a set of data points (in blue). Is there a way to know the value of the points along the curve at each X axis value? I tried using exponential decay and a few other methods. No luck getting the table set up correctly.
  11. J

    Formula / equation help

    Hello,<o:p></o:p> I am trying to replicate the formula below in excel, but can't quite get it right. The aim is to use the formula to help drive data that I can graph into an s-shaped sales curve. The formula I have is:<o:p></o:p>...
  12. J

    Apex of a bell curve

    I have a scatter chart with smooth lines that creates a bell curve. Is there a formula i can make based off of the data to calculate the apex of the bell curve or is there an excel function to show the apex number and label it?
  13. M

    fitting excel data with normal curve

    Hi, I have a graph of data, and when I put this into a chart there is the option to fit the data to a curve. The options are Linear Exponential Polynomial These are OK, but the problem is that I have a curve that is most closely resembling a "Beta" distribution. Is there any way to fit the...
  14. W

    Plotted graph from a table. Read value from the curve?

    Hi I wonder if you can help. I have a table which has been used to create graph curve in excel. Is there a way of reading a value from the curve? Many thanks in advance
  15. T

    how to get the curve maxima?!

    How can I get the value of the point that I have circled on the attached graph? i have the data, I will plot the curve, then how can I get the value?
  16. U

    How Do I create a (Pretty) Bell Curve in Excel 2010

    Hey guys. I have been having the worse time figuring this out. I am trying to create an attractive bell curve in Excel. My boss has put a lot of pressure on me but I just can't seem to do this. I am trying to create a bell curve based on total sqft of a store. Here is an example the data...
  17. 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...
  18. K

    Force Vs Displacement Curve

    Hi all, I have done Analysis in Abaqus for Body and Mattress contact. I have imported my data into Excel sheet, I just want to see the Force vs Displacement curve. I gave Load from 1-500 N so that I get displacement --0.000,.............108 mm,,, I made a non linear Graph for my datas. I...
  19. T

    how to build a bell curve with infinite degrees of freedom?!

    Hi Guys, i'm trying to create a bell curve for returns given a level of volatility. I need to calculate the infinite degrees of freedom for every point on the bell curve. I've search all over and found various methods for calculating the various deviations but cant find out how to work out...
  20. H

    Really need help generating cash flow values.

    Good afternoon, I am in a very tight pickle in which I am hoping someone can help me, or point me in the right direction. I am given total contract values of for say maybe 30 contractors, as well as the duration they are on the job. The job has begun so there are actual values for roughly 5...

Watch MrExcel Video

This Week's Hot Topics

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