When populating the Spreadsheet, please note
- The Red columns indicate vital and essential information for the system to serve well;
- The Green columns are very important but the column works with codes as indicated on the Spreadsheet’s KEY page;
- The Black columns need information, but can be NULL if no information is available.
- Date Columns need to be specific format as indicated at the top of the column
When done with inserting the data, the one can use the ‘Search’ and ‘Replace’ feature in Excel to fill the blank spaces with NULL.
