Project Management is a critical business process for any organization. In this respect, professionals seek for the best way to optimize the implementation of their projects. There are many commercial and open source software packages that allow organizations to manage project management and collaborate among team members. However, the type of project and requirements varies so much accross industries, countries and size of organizations that makes it practically impossible to apply a single project management software.
SpreadsheetWEB offers an alternative to managing projects, collaborating across team members, and building custom workflow with ultimate flexibility. It distinctively enables you to view and manage completed projects, ongoing projects, approved projects waiting to start; projects waiting for approval and canceled projects of your company, from all departments, on your Web browser.
Let’s assume that you are about to start a human resources project called ‘Employee Engagement Survey’. After uploading the data file to SpreadsheetWEB, you will open it on your Web browser and start entering the relevant information. Below, it shows the name of the project/department and name of the project manager. You type in the estimated start and end days of the project, as well as the budget for it. The dashboard offers five basic phases, namely ‘Requirements and Specifications’, ‘System Analysis and Planning’, ‘Development’, ‘Testing’ and ‘Deployment’. You enter the data such as estimated start/end dates and the duration to each section. Note that with SpreadsheetWEB, each field can be customized. You can build a project template with as many fields as your projects require. It is also flexible to change the look-and-feel of the template to reflect your corporate identity and style.
Figure 1. Data Collection
Figure 2. Project Details
An important aspect of project management is collaboration with team members. Typically, number of people need to review, add/edit data, change project status, etc. SpreadsheetWEB supports such collaboration requirements. Suppose that you are collaborating with someone called Jennifer Myers on this project. Since you are the admin of the program, you have all rights to authorize new users to contribute your files with limited restrictions or free access. Supposedly, Jennifer is a co-worker and already user of SpreadsheetWEB. She has to work over your files too. So you transfer the project data to her along with your notes.
Figure 3. Data transfer to Jennifer
Then Jennifer signs in to her account and receives the pending file. She opens it and enters some new data. She will then transfer the account back to you with her notes and status change. This way, you will be carrying on with your project, recording the essential data and collaborating with other team members in real time. You can manage as many projects as you wish and add as many contributors to your projects as desired!
Figure 4. Received data from Jennifer
As the number of projects increase, it could get more dificult to oversee especially for senior managers and department heads. It is not uncommon for a medium size company to have hudreds of projects at any given time. Project management dashboards are extremely useful in those situations. Dashboards present a summary of all projects along with numerous key indicators including number of projects in different statuses i.e. completed, ongoing, approved and canceled, project budgets, estimated and actual. Project dashboards can also be built with various realtime calculations i.e. deviations from estimated budget, uptodate expenses, etc.
Figure 5. Project Management Dashboard
SpreadsheetWEB offers a flexible and highly customizable platform to automate project management process. It can handle every aspect of project management including template creation, data collection, workflow, collaboration among team members, management reporting and dashboards.
Posted by spreadsheetweb 
