CashCreate Gantt Chart and cash flow using excel with sample file. Read more ... » flowCreate Gantt Chart and cash flow using excel with sample file. Read more ... » could be created by primaveraTop 10 steps you should do to be a successful planning engineer. Read more ... » 6 versionHow to convert Primavera version in 30 seconds. Read more ... » 7 using theHeads Up WHAT'S THE FIRST WORD YOU SEE?. Read more ... » reports section, However i found primavera 6 v7 reports are not very clear that every one can do it simply, Therefore we are going to see step by step how to createL1-Create,Define Activities and WBS from Bill of Quantities BOQ. Read more ... » planned values and earned values using primavera p6Differences Between Primavera P6 and MS Project in planning. Read more ... » v7 reports.
To create Cash Flow Statement using primavera follow the following steps:
1- Open reports section from tools tap then reports then reports as per photo below :
2- From the report group Tabular select the report called CT-01 Monthly Project Cash flow and then click on wizard icon on the right as per photo below
3- The report wizard window will open, just click next as per photo below
4- From configure selected subject area under activitiesL1-Create,Define Activities and WBS from Bill of Quantities BOQ. Read more ... » click columns
5-from available options on the left under earned valueEVM earned value management. Read more ... » group select planned valueEVM earned value management. Read more ... » cost and earned value cost (double click to move items from available option on the the left to the selected options in the right) Then click apply Then OK
6- Then click next
7- from the date options click time interval fields.
8- from available options on the left under earned value group select earned value cost, cum earned value cost, planned value cost and cum planned value cost then click OK
9- click next
10- put your report title then click next
11- Congratulations !! report generated click run report
12- choose HTML fileCreate Gantt Chart and cash flow using excel with sample file. Read more ... » and from output file select the location the report will be saved then click OK
13- now the internet explorer should open and this step is tricky one , if your internet explorer not your default browser like if you are using Firefox or Google chrome, go to the location the report saved and right click the open with internet explorer, otherwise the copy and paste will not work probably.
You should should see something like this
14- Copy values of Earned Value, Cum. Earned Value, Planned Value and Cum Planned Value from internet explorer to any excelTop 10 steps you should do to be a successful planning engineer. Read more ... » sheet and create cash flow5-Year Financial Plan free template. Read more ... » easily, Or download the attached sampleCreate Gantt Chart and cash flow using excel with sample file. Read more ... » and it will create the cash flow based on the values from primavera
Download the cash flow report:
Copy values from internet explorer to the excel sheetTrack Changes in Excel 2010. Read more ... »
You will get the cash flow chartCreate Gantt Chart and cash flow using excel with sample file. Read more ... » based on your inputs
Recommended Materials to Learn Primavera
Oracle Primavera P6 Version 8
Project Planning and Control Using Oracle Primavera P6
Project Planning & Control Using Primavera P6