Quotation Spreadsheet, Version 2.09 (7 July 2010)

From this page you can download a free Excel XP/2003/2007/2010 spreadsheet for producing general quotations and Bills of Materials. You can enter your own price lists in different categories (see below). If you register (below), the output will be personalized with your company name and details. By using this file you accept the entire liability for its use (see Disclaimer and Revision History below).

The file consists of five sheets:

Instructions - as below on this sheet.
Prices - your personalized Price List (normally hidden).
Input - where you select the items for the quote. Prices are looked up in your Price List.
Quote - Your quote ready for printing.
BOM - for manufacturers, a Bill of Materials (you specify which items in the price list are Materials).

Links below:

Download and Installation Instructions

Instructions for use (also given in the Instructions sheet in the file)

Download and Installation Instructions

Click Here to download QuoteSys209.exe (855 KB self-extracting Zip).

When you click the above link your Browser should ask if you want to Run or Save the file. Choose Run.
(for multiple PCs, you can Save it, and then Run it later on each PC)
Wait until the program has downloaded. If the Download window does not close automatically, close it.
The WinZip Self-Extractor will appear, ask for an "Unzip to" folder, and offer C:\Quotes as the default, which will be created if need be. Change this if you prefer it elsewhere, or already have a previous version of C:\Quotes\QuoteSys.xlt that you do not want to overwrite.
Click the Unzip button.

Close when the Unzip is complete.

Run Excel.

Open the file you have just unzipped (Excel 2003 File menu > Open > C:\Quotes\QuoteSys.xlt)
(in Excel 2007 use the round button at top left, then Open).

If asked, click [Enable Macros]. If you are not asked, see the section below on Security.

Follow the instructions on the spreadsheet (given below), including setting up your prices and saving as a template.

Important: If you are running Excel 2007 or 2010, see the section directly below headed "Security - Important".

This is version 2.09: Your version number is given at the top of the Instructions sheet. If you have already entered your prices into a previous version, open that too, and copy the prices from the old version to the new version. Then close the old version and save the new template over it. Make backups on CD-ROM or flash drive first if you are unsure.

Security – Important (also given in the spreadsheet)

Excel XP and 2003:

Open the file with Macro Security set to Medium (not High). When you open the file you should be asked: "<Filename> contains Macros: [Disable Macros] [Enable Macros] [More Info]." Click [Enable Macros], otherwise the buttons and lists will not work.

If the above question does not appear, click the Tools menu and choose Macro > Security. Under "Security Level", click "Medium", and OK; then close the file and open it again.

Excel 2007 and 2010:

When you open the file you should see a message under the ribbon: "Security Warning: Macros have been disabled".

Click the "Options..." button.
In the "Microsoft Office Security Options" window, choose "Enable this content" and click OK.

Unless you do the above, the buttons and lists will not work (if you click a button you will get the warning:
"Cannot run the macro Quotesys.xlt!cmdXxx_Click. The macro may not be available in this workbook or all macros may be disabled").

If the Security Warning message above does not appear,

Click the round button at top left of the Excel window, then
Click the button "Excel Options" (at bottom right of the menu window).
In the "Excel Options" window, click the button "Trust Center Settings".
In the "Trust Center" window, click the second option, "Disable all macros with notification",
Click OK; then
Close the file and open it again.

Instructions for Use:

Setting Up

You will want to set up the Prices sheet with your own price list. You can set up categories of item, item names, units (e.g. metre, sq m, ft, hour, each, etc), and price per unit. The file gives more detailed instructions. Click [Finished Editing] to update the lists.

Click on the Input Sheet and fill in your standard mark-up (+) or discount (-) in the cell near the top.

Click the File menu, choose Save As…, Save as type = Template (*.xlt) to your default templates folder.

When prices change, either edit the template, or create a new quote and save it as type = Template over the old one.

Creating a Quote

To create a new quotation, click File > New and choose the QuoteSys template.

Click on the Input sheet and fill in the data at the top, then select the necessary items from the pull-down lists. Fill in the quantities of each item. Use the lower 10 rows for non-standard items (ones that do not appear in the lists). On the quote sheet, click the [Recalculate Quote] button, then the [Print Quote] button. For a Bill of Materials, on the BOM sheet click [Recalculate Bill], then [Print Bill]. To Save the Quote on your Quotes folder, click [Save File] on the Input sheet.

The input data sheet looks like this:

Registering

When you register, the Quote and Bill of Materials will be personalized with your details. An e-mail will be sent to Software Africa with your information. This will enable us to send you our FREE monthly e-newsletter and keep you informed of updates, etc. If you do not have an e-mail program installed, the program will let you export to a text file, which you can e-mail from another PC, or fax.

To register, do the following:

Open the Template or create a new file (NB: Double-clicking a template creates a new file, it does not open it.).
Fill in your Company Name, Contact Person, Telephone, Fax, and/or e-mail address on the "Instructions" sheet in the file.
Click File > Save As…, Save as type = Template (*.xlt) to your default templates folder.
Click the [Register Now] button. An e-mail will be created – click SEND.
Within an hour you should receive a Key code by e-mail.
Drag over the Key code to select it in the e-mail.
Copy to the clipboard (Ctrl+C).
Close the e-mail.
If you closed the new Template, open it again.
Click the button [Enter Unlocking Code]. Press Ctrl+Vto paste from the clipboard.
Click OK.
Save the template and close it.

If you register by fax, allow 2 working days for a response, and do not expect to be informed of updates.

After registering, if your details change (or if a friend gave you a copy personalized with their details), simply register again.

Further Development

If this Quotation system doesn't quite meet all of your needs, we will be delighted to customize it for your specific industry. Please contact us with your requirements, for a cost estimate:

Disclaimer

The file is provided "as is" without warranty of any kind. Please satisfy yourself that calculations are correct, and report any bugs to us. Always virus check files: We can't accept liability.

Revision History (newest at the top):

Ver 2.09 RIR 2010-07-07 Added block at bottom of Input sheet for Notes to appear at end of Quotation. Added Security for Excel 2007 and 2010.
Ver 2.08 RIR 2010-04-21 Detailed error reporting on Checksum Failed.
Ver 2.07 RIR 2009-02-19 New [Make Registration File] button to write Registration Details to file instead of e-mail.
Ver 2.06 RIR 2008-02-20 Make it easier to add extra rows (Sub MakeQuoteBOM). Wrap output. "Clear All Input" button.
Ver 2.05 RIR 2008-01-08: Added code to debug problem with Serial Number sometimes 19 digits instead of 20.
Ver 2.04 RIR 2007-12-10 Added button on Prices sheet to change currency to local settings.
Ver 2.03 RIR 2007-10-17: Catered for details starting/ending in spaces, which caused Key to fail.
Ver 2.02 RIR 2007-07-03: Fixed Registration date bug “Type mismatch”. Company details updated.
Ver 2.01 CRD 2003-12-12: Registration system modified.
Ver 2.00 CRD 2003-10-20: New Registration system with Serial Number and Unlocking Code.
Ver 1.04 RIR 2003-08-01: You can now Export just the Quote and/or BOM Sheets to separate files.
Ver 1.03 RIR 2002-08-26: Widened Item column in Price list.
Ver 1.02 RIR 2002-05-17: Fixed Price List bugs:- last category was ignored, row directly under headings was ignored. Added date to output sheets.

Do you want to remember this page?