We have a requirement to integrate the excel with PPM. The excel is being used to enter the forecast hours which calculates the forecast amount. This forecast amount have to be populated to financial summary of the project.
We thought of using staffing profile to allow the users to enter the planned hours but the forecast cost are being caluculated using many different formulae which we are not sure whether it can be implementted in PPM. The client wants the excel(has many tabs for each cost category) to be integrated in PPM and cost be populated to Financial summary from the excel.
Please let us know how can this be achieved in PPM.
Staffing Profile / Work plan forecast costs (depending on the project settings) are calculated by cost rules and rolled up to the Financial Summary depending on the cost factoring for those rules.
Even if you were to submit the forecast hours to be summed up to the financial summary, the cost calculations would still be based on the PPM calculation and not by the customer cost rules. This is of course a design and would cause a lot of problems if you try to enter your own calculation formulae.
I suggest the customer to make himself familiar with cost factors and cost rules as well as the mechanisms that will roll those costs up to the financial summary.