« Consistency - A watchword

Spreadsheets, to use or not to use...that is the question.

10/27/09 | by Malcolm West [mail] | Categories: Software, Reporting

This subject always attracts lots of debate and it affects all of us in one way or another.

The anti spreadsheet lobby rightly point out that most PMs using spreadsheets do so in an uncontrolled way lacking appropriate configuration management, that their approach is often labour intensive and unsuitable for scaling to a team or organisational level.  All very good points but usually they advocate a database centred approach as the solution.

Going to Databases and away from spreadsheets entirely reduces flexibility users have for collecting, managing and reporting the data important to them.  A particular aspect of this is that having things in databases mean they are more difficult to enter and update often with the ability for external contributors to access it being limited.

So is there a best of both worlds?  We think there is....PROJECT in a box allows you to use spreadsheets and configuration manages these for you making sure changes are kept and versions can be compared.  Spreadsheets can easily be shared for viewing or update with whoever you wish using the email facilities.  When it comes to reporting the reporting engine can grab data from your spreadsheets and present this at a project level or roll it up at a portfolio level based on the rules you set.

Of course we provide a range of standard reporting resources but every organisation is different so you can personalise the data you want to collect and how you want to report it.....perfect.

Permalink
"Plans are only good intentions unless they immediately degenerate into hard work"- Peter Drucker. and plans are in them selves just a small part of what is required to enable the project to be delivered successfully. We are exploring the project environment, the people, policies, methods, tools and externalities which affect how projects get delivered in practice.

Search

XML Feeds

powered by b2evolution