Project Reports in MS Excel

Using ExFormDesigner (‘TurboPlanner’ tab)  allows you to easy analyze project data spending minimal time. Once created report relo...




Using ExFormDesigner (‘TurboPlanner’ tab)  allows you to easy analyze project data spending minimal time. Once created report reloads data from other projects leaving the same analytical sense. It is closer to the Visual Reports in MS Project but more flexible and ‘self-sufficient’.

INSTALLATION


After instating Construction project the ‘ReportSamples’ report-schema has been created in ExForm Designer. You may create its copy (Copy Schema) and use it as an example to create reports for your existing (none-construction) projects. ReportSamples contains PivotTables on several Excel sheets showing:
-          Tasks and assigned resources Work, Cost (baselined, actual, planned) in compact view over the time. Filtering\Sorting\Grouping etc are available because of PivotTable native functionality  
-          Resource and task  Works, Costs (baselined, actual, planned) in the same way as above.
-          Resource Usage parameters with unusual but important ‘maximum day-consumption’ value
-          Gantt –style MS Excel view for tasks. Just for fun, but customers often use it.
-          EVM diagram with EV, PV, AC data from project  
Modify ‘Report Samples’ and corresponding Excel template (read ReadMe sheet of report) to get report you exactly need.
Please,  use Export-Import bottoms on ExForm  Designer to backup schemas and for copying schemas between computers.

More powerful reports are used in construction projects (C-projects) analysis. Sample of C-project and report examples is loaded form ‘Start Page’ (‘Construction‘ tab).

 Enjoy Advanced Tasks >>