- Setting decimals in primavera p3 how to#
- Setting decimals in primavera p3 software#
- Setting decimals in primavera p3 download#
Setting decimals in primavera p3 how to#
One of the most popular discussion in planning forum is how to have an integrated project control system, every practitioner has a different opinion how it must be done, and of course you get a lot of marketing from people trying to sells their systems
Setting decimals in primavera p3 download#
You can download the template here, you need Excel 2013+, if you don’t have it, you can always download PowerBI desktop for free, and import the Excel file, but you need to redo the charts though. Now a Pivot table with conditional formatting will show a Gantt like chart.Īnd a pivot chart to show the Budget per Period and the cumulative. As we are using a calendar table, we can show the budget per day, Month, year or any time period. Then we load some dimensions table in order to slice and dice the pivot table and WE add a measure to calculate cumulative Budget time. Now to spread the budget, just multiply the budget by % per day. The % by day = working hours per day/ Total working hours per task.Now we sum the total working hours per id.Merge the list of date with the calendar table to get the working hours per day.We use the List.Dates to generate the list of dates between the start and finish of every task.
![setting decimals in primavera p3 setting decimals in primavera p3](https://docplayer.net/docs-images/42/16320305/images/page_2.jpg)
First we calculate the duration ( Finish-Start).Let’s load the table Task and generate the spread. Let say you have a list of tasks, with a start and finish date, and some kind of budget, (cost, revenue, quantities, Effort required etc). In this case, count will be the durations in days, and step will be 1 day List.Dates( start as date, count as number, step as duration) (I have yet to see a cost controller or QS using a planning software, even MS Project).
![setting decimals in primavera p3 setting decimals in primavera p3](https://online.fliphtml5.com/bwdv/gays/files/large/101.jpg)
Setting decimals in primavera p3 software#
Obviously Planning software handle this scenario very well, but contrary to popular belief, Excel is still the most widely used planning software among non-planners. There are plenty of templates on the internet on how to spread a budget using Excel formula, in this blog post we will use the Powerquery function “List.Dates”, and a calendar table to account for holidays and periods with less working hours, for example under extreme weather conditions, the working hours per day will be less than standard working hours.