Preparing a template document in Excel
Download the latest Excel master template from iSpec If you have not done so already, download the sample master template
Colour legend
The following table lists the colour coding or an exported document
Edit requirement
Check any paragraph that is marked as draft and in red colour, edit as required and set the status to final once the text editing is completed. Only paragraphs marked as such are editable.
Edit evaluation options
Set items for scoring and weighting to assist with the evaluation process.
Edit vendor response options
The vendor response options are applicable only on items were a requirement text have been entered. Set the various options as required.
Commercial options
Set the various commercial options to allow the vendor to provide a price for the item
General response options
Set the options for compliance and if the vendor needs to provide a detailed response on an item
Delivery options
Set the options if the vendor needs to specify when he can deliver or commission an item. You may specify that the vendor must deliver or commission the item with a certain amount of days after the contract is awarded or on a specific date. These values are optional.
Importing into iSpec
After the Excel document has been edited it can be imported into iSpec. You can either import it to append data to a document or import it to append data to a heading.
Importing to append data to a document
Open the template in iSpec, select the document, select the batch update icon at the top of the document 
, scroll to the bottom and click the Import from Excel button
Note: Data will not be overwritten by this action, data will only be appended to the document.
