Results 1 to 5 of 5

Construction Industry S curve

This is a discussion on Construction Industry S curve within the Excel Questions forums, part of the Question Forums category; Hi All Can anyone advise if there is a function or series of functions that I can use to create ...

  1. #1
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    9,372

    Default Construction Industry S curve

    Hi All
    Can anyone advise if there is a function or series of functions that I can use to create the standard "S" curve or Logistic curve used in the construction industry.
    In my case, I simply want to know:
    How much I have spent at what period in the construction process to see whether I am in front or behind my projections by looking at a created chart.

    Any advise / assistance would be appreciated.
    One thing I am no good at is financial stuff !!

    Regards
    Michael M
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    work 2003, Home 2007

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  2. #2
    MrExcel MVP tusharm's Avatar
    Join Date
    May 2002
    Posts
    10,883

    Default Re: Construction Industry S curve

    Search google for 'logistic function' (w/o the quotes) or sigmoid. You could also use the equation =a*(1+m*EXP(-x/tau))/(1+n*EXP(-x/tau)) where a, m, n, and tau are parameters.

  3. #3
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    9,372

    Default Re: Construction Industry S curve

    Hi Tushar
    Thanks for the response.
    I'll give the search a try
    Just looking at the equation has freaked me out.
    Ultimately I'd like to create some VBA that would plot the graph and then let the boss read the chart each month when I update it.

    Regards
    Michael M
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    work 2003, Home 2007

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  4. #4
    Board Regular
    Join Date
    Oct 2006
    Location
    日本
    Posts
    2,457

    Default Re: Construction Industry S curve

    It would be much easier to plot out the points using an equation like tusharm's and then plot the resulting data points dynamically rather than to make a VBA function to do the same.

    Could you give some sample data if you have it? There are many types of S curves, and we don't know your inputs or what you expect to come out.

  5. #5
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    9,372

    Default Re: Construction Industry S curve

    Hi Sal
    On doing a bit more searching I have found out that @RISK for Excel will do the S curve.
    One of our other departments has this software so i'm going to beg them to take over the request or at the very least show me the steps to process it.

    I blame this board for getting me into VBA.......all I want to do now is create code and functions. lol


    Thank you for responding though.

    Regards
    Michael M
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    work 2003, Home 2007

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com