Construction Budget distribution using GAMMADIST Function

[ibrahimdaas]

Hi Guys


I am creating a Construction Budget for one of the real estate development project, but I wanted to use distribution for the payments to not to follow the usual normal distribution ( a.k.a : S Curve distribution ) so for me the solution was to use the Function GAMMADIST in order to have a curve that is front loaded or back loaded with cost – is in attached Excel file- , but my problem is that I will get always more than 100% , and that is not the correct way to go for distributing the entire number of cost and not to have any leftover.

To under stand my problem, you can chose to set the distribution to be : S-curve and will see that the total cost amount is entirely distributed , but when you try to use one of the : Right Skewed or Left Skewed options , you will have a remaining difference in Red Color at the cells B27,B28, & B29.

How can I make both Right Skewed or Left Skewed formula be like the s-curve and not to have any remaining numbers out.


Construction Phasing

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Construction Budget distribution using GAMMADIST Function
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Fluff]

Now also posted here Construction Budget distribution using GAMMADIST Function

@ibrahimdaas please note what I said earlier

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

 

[ibrahimdaas]

What should I do now ?!!! the reason why I posted the same question in different forum is because no one answer the question

 

[ibrahimdaas]

Here are the links for my post in another sites :

Construction Budget distribution using GAMMADIST Function

Construction Budget distribution using GAMMADIST Function