{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Prices","Input","Quote","BOM"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":124,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":166,"n_cols":10,"rows_kept":166,"cut":false,"hidden":false,"merged":[[1,1,4,9],[99,3,99,7],[100,3,100,7],[101,3,101,7],[51,1,51,6],[53,1,53,9],[105,3,105,7],[132,3,132,5],[102,3,102,7],[103,3,103,7],[104,3,104,7]]}
[]
[null,"Software Africa Quotation System, Version 4.00"]
[]
[]
[]
[]
[]
[null,"Welcome to the Free Software Africa Quotation system for Excel XP, 2003, 2007 and 2010!"]
[null,"The file consists of five sheets (click on a Tab at the bottom of the screen):"]
[null,"Instructions - this sheet."]
[null,"Prices - your personalized Price List (normally hidden)."]
[null,"Input - where you select the items for the quote.  Prices are looked up in your Price List."]
[null,"Quote - Your quote ready for printing."]
[null,"BOM - for manufacturers, a Bill of Materials (you specify which items in the price list are Materials)."]
[]
[null,"You can enter your own price lists (see \"Setting Up\" below).",null,null,null,null,null,null,"Setting Up"]
[null,"If you register (see below), the file will be personalized with your name and details.",null,null,null,null,null,null,"Registering"]
[null,"By using this file you accept the entire liability for its use (see Disclaimer below).",null,null,null,null,null,null,"Disclaimer"]
[null,"To see more, hold in the Ü {down arrow} key, or scroll down using the mouse…",null,null,null,null,null,null,"Instructions"]
[]
[null,"Important: Once-Off Security Settings for Excel XP and 2003"]
[]
[null,"Open this file with Macro Security set to Medium (not High)."]
[null,"When you open the file you should be asked: "]
[null,"\"<Filename> contains Macros: [Disable Macros] [Enable Macros] [More Info].\""]
[null,"Click [Enable Macros], otherwise the buttons will not work."]
[null,"If the above question does not appear, click the Tools menu, choose Macro > Security."]
[null,"Under \"Security Level\", click \"Medium\", and OK.  Close the file and open it again."]
[]
[null,"Click here for further Instructions."]
[]
[null,"Important: Once-Off Security Settings for Excel 2007 and 2010:"]
[]
[null,"When you open the file you may see a message under the ribbon: \"Security Warning: Macros have been disabled\"."]
[null,"If you see this message, do the next two steps.  Otherwise go down to the \"Test Macros\" button."]
[null,"► Click the \"Options...\" button."]
[null,"► In the \"Microsoft Office Security Options\" window, choose \"Enable this content\" and click OK."]
[]
[null,"Unless you do the above, the buttons and lists will not work (if you click a button you will get the warning:"]
[null,"\"Cannot run the macro Quotesys.xlt!cmdXxx_Click. The macro may not be available in this workbook"]
[null,"or all macros may be disabled\")."]
[]
[null,"Click this button now to test whether your macros work:"]
[]
[null,"If you got the message \"Cannot run the macro…\", do the following: "]
[null,"► In Excel 2007, click the round button at top left. In Excel 2010, click the File menu at top left.  Then"]
[null,"► Click the button \"Excel Options\" (at bottom right of the menu window)."]
[null,"► In the \"Excel Options\" window, click the button \"Trust Center Settings\"."]
[null,"► In the \"Trust Center\" window, click the second option, \"Disable all macros with notification\","]
[null,"► Close the file and open it again. Start again at \"Once-Off Security Settings for Excel 2007 and 2010\" above."]
[]
[null,"If the \"Test Macros\" button said \"Congratulations\", continue here:"]
[null,"You need to set the Template folder"]
[null,"C:\\Users\\Administrator\\AppData\\Roaming\\Microsoft\\Templates\\"]
[null,"to be a Trusted Location.  Do this:"]
[null,"► In Excel 2007, click the round button at top left. In Excel 2010, click the File menu at top left."]
[null,"► Click the button \"Excel Options\" (at bottom right of the menu window)."]
[null,"► In the \"Excel Options\" window, click the tab \"Trust Center\". Click the button \"Trust Center Settings\"."]
[null,"► Click the tab \"Trusted Locations\" and  button \"Add New Location\""]
[null,"► Type or Paste into the top box, \"Path\", the Template folder (above) as a trusted location."]
[null,"► Click OK, OK, OK, and proceed below."]
[]
[null,"Instructions:"]
[]
[null,"Save this file now as a Template: Click this button:"]
[]
[null,"Setting Up"]
[null,"Click on the Input Sheet and fill in your standard mark-up (+) or discount (-) in the cell near the top."]
[]
[null,"You will want to set up the spreadsheet with your own price list."]
[null,"To do so, click here and follow instructions:"]
[]
[null,"Click the \"Save Template\" button above to save this to your default templates folder."]
[null,"When prices change, click \"Edit Prices\", \"Finshed Editing\", then \"Save Template\" to save the new template over the old one."]
[]
[null,"Creating a Quote - in a nutshell"]
[null,"To create a new quotation, click File > New and choose this template (QuoteSys.xlt or QuoteSys.xltm)."]
[]
[null,"Click on the Input sheet and fill in the data at the top, then select the necessary items from the pull down lists."]
[null,"Fill in the quantities of each item.  Use the lower 10 rows for non-standard items (ones that do not appear in the lists)."]
[null,"On the quote sheet, click the [Recalculate Quote] button, then the [Print Quote] button."]
[null,"For a Bill of Materials, on the BOM sheet click [Recalculate Bill], then [Print Bill]."]
[null,"To Export a Quote or Bill of Materials to a new Workbook that you can e-mail, click [Export Sheet] on that sheet."]
[null,"To Save the Quote on your Quotes folder, click [Save Quote file] on the Input sheet."]
[]
[null,"Please Register!"]
[1,"When you register, an e-mail message will be created with your Registration details (below)."]
[2,"Once the message is created, send it as you send any e-mail."]
[3,"This will enable us to send you our FREE monthly newsletter and keep you informed of updates."]
[4,"Software Africa will then e-mail you a Key Code."]
[5,"If you use internet e-mail (gmail, hotmail, webmail) a message will be put on the Clipboard for you to paste into an e-mail."]
[6,"If you can not send e-mail, you can register by fax (but you will not be informed of updates). Use \"Make Regsitration File\"."]
[7,"When you receive the Key Code, copy it from the e-mail.  Click the \"Enter Key Code\" button, and paste the code."]
[8,"When you enter the Key Code, the Quote and BOM sheets will be personalized with your details."]
[9,"NB: If you move the template to a different drive or computer, or if you change the company name or e-mail address,"]
[null,"you will have to register again!"]
[]
[10,"To register, fill in the white blocks below:"]
[]
[null,"Company Name: *",null,null,null,null,null,null,"Company","* If these change,"]
[null,"Contact Person:",null,null,null,null,null,null,"Contact","or to use this"]
[null,"Telephone:",null,null,null,null,null,null,"Tel","on another PC,"]
[null,"Fax:",null,null,null,null,null,null,"Fax","please"]
[null,"e-mail address: *",null,null,null,null,null,null,null,"register again."]
[null,"Serial Number:"]
[null,"Key Code:",null,""]
[]
[11,"Now save as a Template: click the \"Save Template\" button"]
[12,"Now click [Register by e-mail], create and send the e-mail:"]
[]
[]
[13,"If this PC does not have e-mail, click the [Make Registration File] button to save a file that you can e-mail from another PC."]
[14,"When you receive the Key, copy it from the e-mail (Ctrl+C).  Click the [Enter Key Code] button, and paste the code."]
[15,"Save the template."]
[16,"To create a new quote, just click File > New and select this template."]
[17,"If your details change (or if a friend gave you this copy containing their details), simply register again."]
[]
[]
[null,"Further Development:"]
[null,"If this Quotation system doesn't quite meet all of your needs, we will be delighted to customize it"]
[null,"for your specific industry.  For a cost estimate, please contact us with your requirements:"]
[]
[null,"If you outgrow this system, please contact us to buy QuickBooks, the easy, affordable, yet sophisticated accounting"]
[null,"program for small business!",null,"Click here to e-mail us about QuickBooks."]
[]
[null,null,null,null,null,"Communication in Action cc, t/a Software Africa "]
[null,null,null,null,null,"for your custom PC programs, databases, templates and training."]
[null,null,null,null,null,"126 Kelvin Drive, Morningside Manor, Sandton, 2191 South Africa."]
[null,null,null,null,null,"Tel  in South Africa: 011 802-6440,  International: +27 11 802-2685."]
[null,null,null,null,null,"Fax-to-email in South Africa: 086 635-7902"]
[null,null,"E-mail:","rick@softwareafrica.co.za",null,null,"Web:","www.softwareafrica.co.za"]
[null,null,null,null,null,"To subscribe to our monthly e-newsletter of computer news, hints and tips, e-mail"]
[null,null,null,"newsletter@softwareafrica.co.za",null,null,"with \"Subscribe\" in the subject line."]
[]
[]
[null,"Disclaimer:"]
[null,"This file is provided \"as is\" without warranty of any kind."]
[null,"Please satisfy yourself that calculations are correct, and report any bugs to us."]
[null,"Always check files for viruses:  We can't accept liability."]
[]
[]
[null,"Revision History:"]
[]
[null,"Ver 4.00  RIR 2018-01-26",null,"Fixed bug: The \"Enter Key code\" button sometimes asked for details if they were filled in."]
[null,"Ver 3.03  RIR 2012-09-23",null,"License button, check if Required Information was blanked after application."]
[null,"Ver 3.02  RIR 2012-09-17",null,"Refuse to let user enter Key Code if file has not been saved."]
[null,"Ver 3.01  RIR 2012-02-16",null,"Send back user and machine information with Registration to help with debugging."]
[null,"Ver 3.00  RIR 2011-11-07",null,"Test Macros; Save Template; web-based e-mail option; improved instructions and Saving."]
[null,"Ver 2.11  RIR 2011-09-07",null,"Improved Notes for Excel 2010."]
[null,"Ver 2.10  RIR 2011-02-07",null,"Detailed error reporting on Checksum Failed.  Remind user to save as template."]
[null,"Ver 2.09  RIR 2010-07-08",null,"Added Notes at end of Quote.  Added Security for Excel 2007 and 2010.  More reg details."]
[null,"Ver 2.08  RIR 2010-04-21",null,"Detailed error reporting on Checksum Failed."]
[null,"Ver 2.07  RIR 2009-02-19",null,"New [Make Registration File] button to write Registration Details to file instead of e-mail."]
[null,"Ver 2.06  RIR 2008-02-20",null,"Make it easier to add extra rows (Sub MakeQuoteBOM).  Wrap output. \"Clear All Input\" button."]
[null,"Ver 2.05  RIR 2008-01-08",null,"Added code to debug problem with Serial Number sometimes 19 digits instead of 20."]
[null,"Ver 2.04  RIR 2007-12-10",null,"Added button on Prices sheet to change currency to local settings."]
[null,"Ver 2.03  RIR 2007-10-17",null,"Catered for details starting/ending in spaces, which caused Unlocking Key to fail."]
[null,"Ver 2.02  RIR 2007-07-03",null,"Fixed Registration date bug “Type mismatch”. Company details updated."]
[null,"Ver 2.01  CRD 2003-12-12",null,"Registration system modified."]
[null,"Ver 2.00  CRD 2003-10-20",null,"New Registration system with Serial Number and Unlocking Code."]
[null,"Ver 1.04  RIR 2003-08-01",null,"You can now Export just the Quote and/or BOM Sheets to separate files."]
[null,"Ver 1.03  RIR 2002-08-26",null,"Widened Item column in Price list."]
[null,"Ver 1.02  RIR 2002-05-17",null,"Price List - last category was ignored, row directly under headings was ignored."]
[null,null,null,"Added date to output sheets."]
[]
[null,"Back to Top"]

{"sheet":"Prices","index":1,"n_rows":78,"n_cols":8,"rows_kept":78,"cut":false,"hidden":true,"merged":[[0,0,0,4]]}
["Price List as at 26 January 2018.",null,null,null,null,null," ","Prices!B2:E2"]
[null,null,null,null,null,null,"Accessories","Prices!$B$67:$E$70"]
["Instructions:",null,null,null,null,null,"Finishing","Prices!$B$73:$E$78"]
["All items in the same Category must be together.",null,null,null,null,null,"Fixings","Prices!$B$49:$E$65"]
["Category may be duplicated or omitted for more items of the same type.",null,null,null,null,null,"Labour","Prices!$B$30:$E$38"]
["Use the Category column for main categories, e.g. Materials, Labour, Plant, etc.",null,null,null,null,null,"Materials","Prices!$B$17:$E$28"]
["Use the Item column for details, e.g. specific materials, different labour rates, etc.",null,null,null,null,null,"Parts","Prices!$B$40:$E$46"]
["Unit may be any unit you like, e.g. m, metre, kg, sq m, ft, sq ft, hours, each, etc."]
["Unit Price is the price per unit, i.e. per m, kg, etc."]
["In the column \"BOM?\", put \"Y\" or \"Yes\" for items that must appear in the Bill of Materials."]
["Blank lines are allowed anywhere, but not more than 20 in succession."]
[]
["Remember to click [Finished Editing] to update the lists!"]
[]
["Category","Item","Unit","Unit Price","BOM?"]
[]
["Materials","Channel","metres",3.98,"Yes"]
[null,"Angle Iron","metres",4.92,"Yes"]
[null,"I-section 1","m",7.02,"Yes"]
[null,"I-section 2","m",9.1199999999999992,"Yes"]
[null,"Steel sheet","sq m",11.22,"Yes"]
[null,"vinyl","sq m",13.32,"Yes"]
[null,"plastic sheet","m²",15.42,"Yes"]
[null,"4 mm glass","m2",17.52,"Yes"]
[null,"6 mm glass","m2",19.62,"Yes"]
[null,"Putty, industrial strength","kg",5,"No"]
[null,"Rabbit's feet (slightly used)","pair",110]
[null,"Earthfill","m³",43,"Yes"]
[]
["Labour","Senior Engineer","hr",500]
[null,"Engineer","hr",400]
[null,"Junior Engineer","hr",200]
[null,"Senior Technician","hr",300]
[null,"Technician","hr",200]
[null,"Junior Technician","hr",100]
[null,"Packer","hr",20]
[null,"Sweeper","day",120]
[null,"Tea Person","day",200]
[]
["Parts","Widget","each",2.5,"Yes"]
["Parts","Dingbat","each",3.75,"Yes"]
["Parts","Wossename","each",4,"Yes"]
["Parts","Dingus","each",7.88,"Yes"]
[null,"Flange","each",24,"Yes"]
[null,"Fidget","each",18,"Yes"]
[null,"Squrrox ","each",123.66,"Yes"]
[]
[]
["Fixings","Dome Nut","each",1,"Yes"]
[null,"Wingnut","each",0.34,"Yes"]
[null,"Rivet","each",0.55000000000000004,"Yes"]
[null,"Big Bolt","each",0.67,"Yes"]
[null,"Small Bolt","each",0.79,"Yes"]
[null,"Nail","kg",0.91,"Yes"]
[null,"Nut","each",1.03,"Yes"]
[null,"Dome Nut","each",1.1499999999999999,"Yes"]
[null,"Dowel Pins","each",1.27,"Yes"]
[null,"Galv Flat Washer","each",1.39,"Yes"]
[null,"Galv Nuts","each",1.51,"Yes"]
[null,"Galv Threaded Rod","each",1.63,"Yes"]
[null,"Minarb","each",1.75,"Yes"]
[null,"Minoff","each",1.87,"Yes"]
[null,"Nyloc Nut","each",1.99,"Yes"]
[null,"Pan Slot S. Tapper","each",2.11,"Yes"]
[null,"Pop Rivets Aluminium with little fiddly bit on the end","each",2.23,"Yes"]
[]
["Accessories","S/Steel Trim","m",43,"Y"]
["Accessories","Al Trim","metre",67.5,"Y"]
["Accessories","Collar","each",324.56,"Y"]
["Accessories","Spindle","each",782,"Yes"]
[]
[]
["Finishing","Painting","sq m",45]
[null,"Galvanizing","sq m",23]
[null,"Anodizing","kg",43]
[null,"Plating","sq m",12]
[null,"Sanding","sq m",4.55]
[null,"Throwing away","kg",1.02]

{"sheet":"Input","index":2,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,2,32,7],[23,1,23,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[29,5,29,6],[30,5,30,6],[28,5,28,6],[25,1,25,2],[23,15,23,16],[26,1,26,2],[27,1,27,2],[6,16,7,16],[6,15,7,15],[6,7,7,7],[22,1,22,2],[6,2,7,2],[6,1,7,1],[24,1,24,2],[2,2,2,7],[1,2,1,7],[6,6,7,6],[6,5,7,5],[6,4,7,4],[6,3,7,3]]}
[null,"Input for Quote"]
[null,"Customer Name:"]
[null,"Quotation on:"]
[null,"+Mark-up/-Discount",0.1]
[null,"Total Cost:",{"$f":"F29*(1+C4)","v":0},null,{"$f":"Prices!A1","v":"Price List as at 26 January 2018."}]
[]
[null,"Category","Item","No. of Units ","Unit"," Price   per unit","Extended Price","BOM?"]
[null,null,null,null,null,null,null,null,null,"Instructions for Quote:"]
[1,1,null,null,{"$f":"T(INDEX(AccList1,C9,2))","v":""},{"$f":"IF(C9,INDEX(AccList1,C9,3),0)","v":0},{"$f":"QtyRef1*unitprc1","v":0},{"$f":"T(INDEX(AccList1,C9,4))","v":""},{"$f":"LEFT(H9,1)","v":""},"Fill in white cells only."]
[2,1,null,null,{"$f":"T(INDEX(AccList2,C10,2))","v":""},{"$f":"IF(C10,INDEX(AccList2,C10,3),0)","v":0},{"$f":"QtyRef2*unitprc2","v":0},{"$f":"T(INDEX(AccList2,C10,4))","v":""},{"$f":"LEFT(H10,1)","v":""},"Make sure prices are correct first (see Instructions sheet)."]
[3,1,null,null,{"$f":"T(INDEX(AccList3,C11,2))","v":""},{"$f":"IF(C11,INDEX(AccList3,C11,3),0)","v":0},{"$f":"D11*F11","v":0},{"$f":"T(INDEX(AccList3,C11,4))","v":""},"","From the Category list, select the category of Item."]
[4,1,null,null,{"$f":"T(INDEX(AccList4,C12,2))","v":""},{"$f":"IF(C12,INDEX(AccList4,C12,3),0)","v":0},{"$f":"D12*F12","v":0},{"$f":"T(INDEX(AccList4,C12,4))","v":""},"","The Item list will change to suit the category."]
[5,1,null,null,{"$f":"T(INDEX(AccList5,C13,2))","v":""},{"$f":"IF(C13,INDEX(AccList5,C13,3),0)","v":0},{"$f":"D13*F13","v":0},{"$f":"T(INDEX(AccList5,C13,4))","v":""},"","From the Item list, select the correct Item."]
[6,1,null,null,{"$f":"T(INDEX(AccList6,C14,2))","v":""},{"$f":"IF(C14,INDEX(AccList6,C14,3),0)","v":0},{"$f":"D14*F14","v":0},{"$f":"T(INDEX(AccList6,C14,4))","v":""},"","Fill in the number of units for each item."]
[7,1,null,null,{"$f":"T(INDEX(AccList7,C15,2))","v":""},{"$f":"IF(C15,INDEX(AccList7,C15,3),0)","v":0},{"$f":"D15*F15","v":0},{"$f":"T(INDEX(AccList7,C15,4))","v":""},""]
[8,1,null,null,{"$f":"T(INDEX(AccList8,C16,2))","v":""},{"$f":"IF(C16,INDEX(AccList8,C16,3),0)","v":0},{"$f":"D16*F16","v":0},{"$f":"T(INDEX(AccList8,C16,4))","v":""},"","The lower 10 rows may be used for non-standard items."]
[9,1,null,null,{"$f":"T(INDEX(AccList9,C17,2))","v":""},{"$f":"IF(C17,INDEX(AccList9,C17,3),0)","v":0},0,{"$f":"T(INDEX(AccList9,C17,4))","v":""},""]
[10,1,null,null,{"$f":"T(INDEX(AccList10,C18,2))","v":""},{"$f":"IF(C18,INDEX(AccList10,C18,3),0)","v":0},0,{"$f":"T(INDEX(AccList10,C18,4))","v":""},"","Click on the [Save File] button above to Save or"]
[11,null,null,null,null,null,0,null,"","re-save the file using the Customer and/or Quote Names."]
[12,null,null,null,null,null,0,null,""]
[13,null,null,null,null,null,0,null,"","Click on the buttons above to go to the"]
[14,null,null,null,null,null,0,null,"","Quote Printout or the Bill of Materials."]
[15,null,null,null,null,null,0,null,""]
[16,null,null,null,null,null,0,null,"","If you add new items to prices,"]
[17,null,null,null,null,null,0,null,"","you must re-select all lists."]
[18,null,null,null,null,null,0,null,""]
[19,null,null,null,null,null,0,null,""]
[20,null,null,null,null,null,0,null,""]
[null,"Total Price before Discount or Mark-up:",null,{"$f":"COUNTA(D9:D28)","v":0},null,{"$f":"SUM(G9:G28)","v":0}]
[null,"Subtotal: Items in Price Lists",null,{"$f":"COUNTA(D9:D18)","v":0},null,{"$f":"SUM(G9:G18)","v":0},null,"SubTot"]
[null,"Subtotal: Materials (for Bill of Materials)",null,{"$f":"COUNTIF(I9:I28,\"Y\")","v":0},null,{"$f":"SUMIF(I9:I28,\"Y\",G9:G28)","v":0},null,"MatTot"]
[]
[null,"Notes for Quote:","Prices include VAT at 14%. E&OE.\n",null,null,null,null,null,null,"Add any notes that must appear at the end of the quote, here."]

{"sheet":"Quote","index":3,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,0,19,5],[12,0,12,5],[0,0,0,5],[7,4,7,5],[16,4,16,5]]}
[{"$f":"Instructions!B2","v":"Software Africa Quotation System, Version 4.00"}]
[]
["Contact: ","Software Africa for updates and customization"]
["Tel No: ","(South Africa) 011 802-6440,  (International) +27 11 802-2685"]
["Fax No: ","(South Africa) 086 635-7902,  (International) +27 11 802-4576"]
["E-mail: ","info@softwareafrica.co.za"]
[]
["Customer Name:",{"$f":"T(Customer)","v":""},null,null,{"$f":"TODAY()","v":"2018-01-26"}]
["Quotation on:",{"$f":"T(QuoteName)","v":""}]
[]
[null,{"$f":"IF(ABS(QuoteTot-TotCost)>0.01,\"Please Recalculate!\",\"\")","v":""}]
[]
["Quotation"]
[]
["Category","Item","No. Of Units","Unit","Price per Unit","Extended Price"]
["No Items Found."]
["Total",null,null,null,{"$f":"SUM(F16:F16)","v":0}]
[]
["Price List as at 8 July 2010."]
["Prices include VAT at 14%. E&OE.\n"]

{"sheet":"BOM","index":4,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,4,16,5],[12,0,12,5],[0,0,0,5],[7,4,7,5]]}
[{"$f":"Instructions!B2","v":"Software Africa Quotation System, Version 4.00"}]
[]
["Contact: ","Software Africa for updates and customization"]
["Tel No: ","(South Africa) 011 802-6440,  (International) +27 11 802-2685"]
["Fax No: ","(South Africa) 086 635-7902,  (International) +27 11 802-4576"]
["E-mail: ","info@softwareafrica.co.za"]
[]
["Customer Name:",{"$f":"T(Customer)","v":""},null,null,{"$f":"TODAY()","v":"2018-01-26"}]
["Quotation on:",{"$f":"T(QuoteName)","v":""}]
[]
[null,{"$f":"IF(ABS(BOMTot-MatTot)>0.01,\"Please Recalculate!\",\"\")","v":""}]
[]
["Bill of Materials"]
[]
["Category","Item","No. Of Units","Unit","Price per Unit","Extended Price"]
["No Items Found."]
["Total",null,null,null,{"$f":"SUM(F16:F16)","v":0}]
[]
["Price List as at 10 December 2007."]