Hi
So i am working on a project and i am trying to distribute data among months between two dates (Start Date & End Date) using S -Curve with little to no knowledge about the subject , so here is the scenrio i have multiple projects in my data set each having 3 phases i.e. Phase1, Phase2, Phase3. every phase has its own start and end date and a budget amount alloted to that phase as following:
| Projects | Phases | Budget | START | END |
| Example1 | Phase1 | 1,000.00 | 01-Jan-23 | 01-Mar23 |
| Exmaple1 | Phase2 | 2,000.00 | 01-Mar-23 | 01-Apr-24 |
| Example 1 | Phase3 | 5,000.00 | 01-Apr-24 | 01-Jan-27 |
| Example 2 | Phase1 | 3,000.00 | 01-Feb-22 | 01-Mar23 |
| Example 2 | Phase2 | 5,000.00 | 01-Mar-23 | 01-Oct-23 |
| Example 2 | Phase3 | 9,000.00 | 01-Oct-23 | 01-Jan-26 |
I have cerated a Calender table with Date column(MonthYear) selecting minimum Monthyear from [StartDate] and maximum from [EndDate] and then created a new table cross joining my project table and date table to spread it across all the months for each project and phase between start and end date:
| Projects | Phases | Budget | START | END | Date |
| Example 1 | Phase1 | 1,000.00 | 01-Jan-23 | 01-Mar-23 | Jan-23 |
| Example 1 | Phase1 | 1,000.00 | 01-Jan-23 | 01-Mar-23 | Feb-23 |
| Example 1 | Phase1 | 1,000.00 | 01-Jan-23 | 01-Mar-23 | Mar-23 |
Can't paste all above data here but basic understanding is clear in mty opnion data continues across all the months
Now what i want to achieve is to distribute Budget across all the months for each project and its phases using S-Curve distribution,
I want to use standard s-cruve equation to distribute my data as discussed here :https://blog.arkieva.com/basics-on-s-curves/
The end result would be as follows(Just an idea, not real results)
| Projects | Phases | Budget | START | END | Date | Budget Per Month |
| Example 1 | Phase1 | 1,000.00 | 01-Jan-23 | 01-Mar-23 | Jan-23 | 200 |
| Example 1 | Phase1 | 1,000.00 | 01-Jan-23 | 01-Mar-23 | Feb-23 | 700 |
| Example 1 | Phase1 | 1,000.00 | 01-Jan-23 | 01-Mar-23 | Mar-23 | 100 |
Can any body please help me here?
Thanks in advance!
