jimmy2times
Board Regular
- Joined
- Aug 8, 2014
- Messages
- 69
Hello,
I have data showing different contracts with different clients. Each contract is of different value and duration. Is it possible to show the "stacked value" of different contracts?
By that I mean say if a contract is 24 months start June then divide by 24 to get monthly value and plots that from start to finish date so each contract stacks on top of each other to show monthly loading?
So in April the combined income is £491,525. In May it would be £841,525 & June it would be £1584,383. It would remain the same for Jul-Oct. Then in Nov it would drop to £841,525 as the 7 month contract ended. So the income amount goes up and down as different contracts start and end.
I envisage a chart that is either stacked/bucket/funnel. With different stacks or layers representing different amounts of income. On the axis financial year on the horizontal and financial month on the vertical and data labels in the stacks.
See sample data below.
Can anyone help?
Thanks
<colgroup><col><col><col><col span="2"><col><col><col span="2"><col span="2"><col></colgroup><tbody>
</tbody>
I have data showing different contracts with different clients. Each contract is of different value and duration. Is it possible to show the "stacked value" of different contracts?
By that I mean say if a contract is 24 months start June then divide by 24 to get monthly value and plots that from start to finish date so each contract stacks on top of each other to show monthly loading?
So in April the combined income is £491,525. In May it would be £841,525 & June it would be £1584,383. It would remain the same for Jul-Oct. Then in Nov it would drop to £841,525 as the 7 month contract ended. So the income amount goes up and down as different contracts start and end.
I envisage a chart that is either stacked/bucket/funnel. With different stacks or layers representing different amounts of income. On the axis financial year on the horizontal and financial month on the vertical and data labels in the stacks.
See sample data below.
Can anyone help?
Thanks
| Client Name | Est Value | Est Start Date | Est Completion Date | Contract Term (Months) | Monthly Income | Start Month | Fiscal Year (Start) | Fiscal Year (End) | Financial Year (Start) | Financial Year (End) | Duration |
| Company A | £3,500,000 | 01/05/2016 | 01/03/2017 | 10 | £350,000 | May | 2017 | 2017 | 16-17 | 16-17 | 16-17 16-17 |
| Company B | £5,200,000 | 01/06/2016 | 01/01/2017 | 7 | £742,857 | Jun | 2017 | 2017 | 16-17 | 16-17 | 16-17 16-17 |
| Company C | £20,000,000 | 01/04/2016 | 01/03/2021 | 59 | £338,983 | Apr | 2017 | 2021 | 16-17 | 20-21 | 16-17 20-21 |
| Company D | £9,000,000 | 01/04/2016 | 01/03/2021 | 59 | £152,542 | Apr | 2017 | 2021 | 16-17 | 20-21 | 16-17 20-21 |
<colgroup><col><col><col><col span="2"><col><col><col span="2"><col span="2"><col></colgroup><tbody>
</tbody>
