Skip to Content
0
May 16, 2016 at 05:28 AM

CJR2 Excel Upload Layout

355 Views

Hi Experts,

My client needs to have a layout to upload cost plan in CJR2 which supports the below template

Project Version 0 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2018 2019 2020 2021 WBS Element Cost element 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 12 12 12 12 P-6500109.01.01 406999 P-6500109.01 406998

i.e- we need WBS and cost element as lead columns and then we need period 1-12 for current year and period 1-12 for next year. Post that we need period 12 only for next 3 years. It is required that the system should be able to derive current and next years.

I tried to achieve this but couldn't find a way to meet the requirement. Can anyone help me with this, whether it is technically feasible at all if yes, how.

Any help will be appreciated.

Regards,

Mohammad