Every Project Management Spreadsheet (PMSS) requires some amount of management data to allow the software to do its job properly. The data that must be stored on the sheet can be divided into two parts, “management information” user input” which is where your future understanding of project management starts.
Management information is the all-important data that allows the PMSS to understand what a project is and how it is being managed. The spreadsheet will store and save the management information in a way that makes sense for the PMSS. That means that the data will be structured so that data types are easier to work with and the information structure is easier to read and understand.
User input, or the future understanding of project management, is the kind of data that will allow you to decide how you want the sheet to be used. A user input sheet may allow you to define some key metrics which will be used by the spreadsheet to evaluate how the project is being managed.
In other words, the sheet’s input matrix will contain key metrics to allow you to have a better picture of how the project is being managed. To make sure that the sheet is still easy to read and understand, user input sheets are organized in three layers. These layers consist of:
The top layer contains the most crucial data for the sheet. This data contains the sheet name, an icon for accessing the sheet and a link to the sheet in the form of an Internet shortcut or hyperlink. The sheet will also have an icon for sending a new post and this will be followed by a link to share the sheet and an icon for new entries in the sheet.
The second layer will contain additional useful data including number of users accessing the sheet, number of updated entries in the sheet, number of new posts in the sheet, number of unread entries in the sheet, number of pages created in the sheet, number of pages modified in the sheet, number of page headers created in the sheet, and the number of page footers created in the sheet. This layer also includes an icon for switching between the sheet’s history (which is the default state when the sheet first came into existence), an icon for exporting the sheet and all of the fields from the sheet (including non-readable fields) and an icon for opening the sheet’s code in the sheet’s editor.
The next layer is a list of fields for the management data. This layer will include fields like time. This is where you will put your management time.
Finally, the last layer of management time will contain fields for daily rates. This layer will be a list of fields containing daily rates, weekly rates, monthly rates, and annual rates. Again, you will want to use the Google Docs online editor to create your management time matrix.