Creating Spreadsheets Clause Samples
Creating Spreadsheets. Spreadsheets can contain any desired data so long as the data to be imported is in compliance with the limitations listed below. It is not necessary to fill in all the data in all of the columns or even to use all of the headings. Use only the column headings for which you have data and put the import data columns in the left most columns of the spreadsheet. To create an importable file from an existing spreadsheet, use one of the supplied Excel .xlt templates and save it as the desired file name and in the .xls file format. You will then be able to enter data and delete unneeded columns. To change the format of the supplied master template, save the template under a different file name and in the .xls format. Cut and paste the column headings as desired and then save this new spreadsheet as a new master template. It is also possible to create your own spreadsheet using the headings and definitions found in Appendix B. Do not change the text in the master template column headings! This will cause the import to fail for that column. It is not advisable to put more than one harness into a spreadsheet.
