{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["CoderSetting","Home","Sales","Customers","Sales Report","Login","template - Basic Invoice","template - Sales Invoice","template - Price List Invoice","template - Remittance Invoice","template - Parts and Labor","Deposit Invoice","template - Service Invoice","template - Service Hourly","template - Serv. Hourly op. Tax","Price List","Settings","HELP","Users","EULA"],"not_rendered":{"charts":2,"images":40,"macros":1,"external_links":1,"defined_names":155,"comments":0,"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":"CoderSetting","index":0,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
[null,"check wether Admin exist or not",{"$f":"IF(ISERROR(MATCH(\"Admin\", Settings!H83:$H183, 0)), FALSE, TRUE)","v":false}]
[null,"Check from where user has move on Help sheet","Home"]

{"sheet":"Home","index":1,"n_rows":33,"n_cols":27,"rows_kept":33,"cut":false,"hidden":true,"merged":[[1,3,1,13],[3,3,3,13],[5,3,5,4],[14,3,14,4],[8,8,18,8],[10,10,10,13],[12,10,12,13],[16,3,16,4],[16,10,16,13],[12,3,12,4],[8,10,8,13],[18,10,18,13],[14,10,14,13],[8,3,8,4],[10,3,10,4],[18,3,18,4],[20,3,20,4],[20,8,30,8],[32,3,33,4],[32,5,35,13],[30,10,30,13],[28,3,28,4],[28,10,28,13],[26,3,26,4],[30,3,30,4],[26,10,26,13],[24,10,24,13],[22,10,22,13],[20,10,20,13],[24,3,24,4],[22,3,22,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,"INVOICE MANAGER PRO™"]
[null,null,null,"Support: ","support@spreadsheet123.com",null,null,null,null,null,null,null,null,null,{"$f":"\"© \"&YEAR(TODAY())&\" Spreadsheet123 LTD. All rights reserved\"","v":"© 2017 Spreadsheet123 LTD. All rights reserved"}]
[null,null,null,{"$f":"IF(ISERROR(INDEX(_paymentTermsSet,MATCH(_paymentDue,_paymentTerms,0),2)),\"\",INDEX(_paymentTermsSet,MATCH(_paymentDue,_paymentTerms,0),2))","v":""}]
[]
[null,null,null,"Welcome User",null,"Alex",null,{"$f":"IF(ISBLANK(Home!$F$6),\"\",INDEX(Sales_Rep,MATCH(Home!$F$6,Sales_Rep_Name,0),4))","v":{"$error":"#N/A"}},null,null,null,null,"Role:","Admin"]
[]
[]
[null,null,null,"Customer is",null,"Person",null,null,"Billing Address",null,{"$f":"IF(OR(ISBLANK(Home!$F$11),ISERROR(INDEX(Customers,MATCH(Home!$F$11,IF(Home!$F$9=\"Company\",Company,Person),0),IF(Home!$F$9=\"Company\",3,2)))),\"\",INDEX(Customers,MATCH(Home!$F$11,IF(Home!$F$9=\"Company\",Company,Person),0),IF(Home!$F$9=\"Company\",3,2)))","v":""}]
[]
[null,null,null,"Customer",null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(Home!$F$11),ISERROR(INDEX(Customers,MATCH(Home!$F$11,IF(Home!$F$9=\"Company\",Company,Person),0),4))),\"\",INDEX(Customers,MATCH(Home!$F$11,IF(Home!$F$9=\"Company\",Company,Person),0),4))","v":""}]
[]
[null,null,null,"Customer ID",null,{"$f":"IF(OR(ISBLANK(F9),ISBLANK(F11),ISERROR(INDEX(Customers,MATCH($F$11,IF(Home!$F$9=\"Company\",Company,Customer_Name),0),1))),\"\",INDEX(Customers,MATCH($F$11,IF(Home!$F$9=\"Company\",Company,Customer_Name),0),1))","v":""},null,null,null,null,{"$f":"IF(OR(ISBLANK(Home!$F$11),ISERROR(INDEX(Customers,MATCH(Home!$F$11,IF(Home!$F$9=\"Company\",Company,Person),0),5)&\", \"&INDEX(Customers,MATCH(Home!$F$11,IF(Home!$F$9=\"Company\",Company,Person),0),6)&\", \"&INDEX(Customers,MATCH(Home!$F$11,IF(Home!$F$9=\"Company\",Company,Person),0),7))),\"\",INDEX(Customers,MATCH(Home!$F$11,IF(Home!$F$9=\"Company\",Company,Person),0),5)&\", \"&INDEX(Customers,MATCH(Home!$F$11,IF(Home!$F$9=\"Company\",Company,Person),0),6)&\", \"&INDEX(Customers,MATCH(Home!$F$11,IF(Home!$F$9=\"Company\",Company,Person),0),7))","v":""}]
[]
[null,null,null,"Purchase Order #",null,null,"(Optional)",null,null,null,{"$f":"IF(OR(ISBLANK(Home!$F$11),ISERROR(INDEX(Customers,MATCH(Home!$F$11,IF(Home!$F$9=\"Company\",Company,Person),0),8))),\"\",\"P: \"&INDEX(Customers,MATCH(Home!$F$11,IF(Home!$F$9=\"Company\",Company,Person),0),8))","v":""}]
[]
[null,null,null,"Invoice Date",null,"2017-03-26",null,null,null,null,{"$f":"IF(OR(ISBLANK(Home!$F$11),ISERROR(INDEX(Customers,MATCH(Home!$F$11,IF(Home!$F$9=\"Company\",Company,Person),0),9))),\"\",\"F: \"&INDEX(Customers,MATCH(Home!$F$11,IF(Home!$F$9=\"Company\",Company,Person),0),9))","v":""}]
[]
[null,null,null,"Payment Terms",null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(Home!$F$11),ISERROR(INDEX(Customers,MATCH(Home!$F$11,IF(Home!$F$9=\"Company\",Company,Person),0),10))),\"\",\"E: \"&INDEX(Customers,MATCH(Home!$F$11,IF(Home!$F$9=\"Company\",Company,Person),0),10))","v":""}]
[]
[null,null,null,"Due Date",null,{"$f":"IF(ISERROR(DATE(YEAR(_invoiceDate),MONTH(_invoiceDate),DAY(_invoiceDate)+_paymentTermsDay)),\"\",IF(_paymentTermsDay=0,_invoiceDate,DATE(YEAR(_invoiceDate),MONTH(_invoiceDate),DAY(_invoiceDate)+_paymentTermsDay)))","v":""},null,null,"Shipping Address",null,"[Name]"]
[]
[null,null,null,{"$f":"Settings!B25","v":"Sales Tax Rate"},null,0.2,null,null,null,null,"[Company Name]"]
[]
[null,null,null,"Invoice Number",null,{"$f":"_NextInvoice","v":1},null,null,null,null,"[Street Address]"]
[]
[null,null,null,"Alt. Shipping Address",null,"NO",null,null,null,null,"[City, ST  ZIP Code]"]
[]
[null,null,null,"Service & Handling",null,null,"(Optional)",null,null,null,"[Phone]"]
[]
[null,null,null,"Discount",null,0.1,"(Optional)",null,null,null,"[Contact Name]"]
[]
[null,null,null,"Special Notes and Instructions"]

{"sheet":"Sales","index":2,"n_rows":11,"n_cols":23,"rows_kept":11,"cut":false,"hidden":true,"merged":[[2,0,2,14],[0,0,0,14],[1,12,1,14]]}
["INVOICE MANAGER PRO™",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(W1=0),ROW(),0)","v":1},{"$f":"Settings!C66","v":"Draft"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"© \"&YEAR(TODAY())&\" Spreadsheet123 LTD. All rights reserved\"","v":"© 2017 Spreadsheet123 LTD. All rights reserved"},null,null,null,null,null,null,null,null,2,{"$f":"Settings!C67","v":"In Progress"}]
["SALES - OVERVIEW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"Settings!C68","v":"With Balance"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"Settings!C69","v":"Paid"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"Settings!C70","v":"Closed"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Settings!C71","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Settings!C72","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Settings!C73","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Settings!C74","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Settings!C75","v":0}]
["Refresh Data","Invoice #","Date","Customer ID","Customer Name","Invoice Total","Sales Tax","Service & Handling","Discount","Amount Due","Due Date","Total Paid","Outstanding \nBalance","Overdue","Invoice Status"]

{"sheet":"Customers","index":3,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":true,"merged":[[5,0,5,11],[0,0,0,11],[1,9,1,11]]}
["INVOICE MANAGER PRO™"]
[null,null,null,null,null,null,null,null,null,{"$f":"\"© \"&YEAR(TODAY())&\" Spreadsheet123 LTD. All rights reserved\"","v":"© 2017 Spreadsheet123 LTD. All rights reserved"}]
[]
[]
[]
["CUSTOMER DATABASE"]
["ID","Name","Company Name","Address Line 1","Address Line 2","State","ZIP/Post Code","Phone","Fax","E-mail","Payment Terms","Date"]

{"sheet":"Sales Report","index":4,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":true,"merged":[[0,0,0,11],[4,0,4,11],[7,6,7,9],[39,0,39,4]]}
["Sales Report"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Year To Date"]
[null,"Net Sales","Sales Tax","Total","Number of Sales","Average Net Sale","Net Sales","Number of Sales","Average Net Sales","Revenue Share"]
["January",{"$f":"SUMIF(Sales_Date,\"<=31/01\",Subtotal)","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/01\",Sales_Tax)","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/01\",Sales_Total)","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/01\",Sales_Quantity)","v":{"$error":"#NAME?"}},{"$f":"IF(B10=0,0,B10/E10)","v":0},{"$f":"B10","v":0},{"$f":"E10","v":{"$error":"#NAME?"}},{"$f":"IF(G10=0,0,G10/H10)","v":0},{"$f":"IF(B10=0,0,B10/SUM($B$10:$B$21))","v":0}]
["February",{"$f":"SUMIF(Sales_Date,\"<=28/02\",Subtotal)-B10","v":0},{"$f":"SUMIF(Sales_Date,\"<=28/02\",Sales_Tax)-C10","v":0},{"$f":"SUMIF(Sales_Date,\"<=28/02\",Sales_Total)-D10","v":0},{"$f":"SUMIF(Sales_Date,\"<=28/02\",Sales_Quantity)-E10","v":{"$error":"#NAME?"}},{"$f":"IF(B11=0,0,B11/E11)","v":0},{"$f":"G10+B11","v":0},{"$f":"H10+E11","v":{"$error":"#NAME?"}},{"$f":"IF(G11=0,0,G11/H11)","v":0},{"$f":"IF(B11=0,0,B11/SUM($B$10:$B$21))","v":0}]
["March",{"$f":"SUMIF(Sales_Date,\"<=31/03\",Subtotal)-B10-B11","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/03\",Sales_Tax)-C10-C11","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/03\",Sales_Total)-D10-D11","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/03\",Sales_Quantity)-E10-E11","v":{"$error":"#NAME?"}},{"$f":"IF(B12=0,0,B12/E12)","v":0},0,{"$error":"#NAME?"},0,0]
["April",{"$f":"SUMIF(Sales_Date,\"<=30/04\",Subtotal)-B10-B11-B12","v":0},{"$f":"SUMIF(Sales_Date,\"<=30/04\",Sales_Tax)-C10-C11-C12","v":0},{"$f":"SUMIF(Sales_Date,\"<=30/04\",Sales_Total)-D10-D11-D12","v":0},{"$f":"SUMIF(Sales_Date,\"<=30/04\",Sales_Quantity)-E10-E11-E12","v":{"$error":"#NAME?"}},{"$f":"IF(B13=0,0,B13/E13)","v":0},0,{"$error":"#NAME?"},0,0]
["May",{"$f":"SUMIF(Sales_Date,\"<=31/05\",Subtotal)-B10-B11-B12-B13","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/05\",Sales_Tax)-C10-C11-C12-C13","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/05\",Sales_Total)-D10-D11-D12-D13","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/05\",Sales_Quantity)-E10-E11-E12-E13","v":{"$error":"#NAME?"}},{"$f":"IF(B14=0,0,B14/E14)","v":0},0,{"$error":"#NAME?"},0,0]
["June",{"$f":"SUMIF(Sales_Date,\"<=30/06\",Subtotal)-B10-B11-B12-B13-B14","v":0},{"$f":"SUMIF(Sales_Date,\"<=30/06\",Sales_Tax)-C10-C11-C12-C13-C14","v":0},{"$f":"SUMIF(Sales_Date,\"<=30/06\",Sales_Total)-D10-D11-D12-D13-D14","v":0},{"$f":"SUMIF(Sales_Date,\"<=30/06\",Sales_Quantity)-E10-E11-E12-E13-E14","v":{"$error":"#NAME?"}},0,0,{"$error":"#NAME?"},0,0]
["July",{"$f":"SUMIF(Sales_Date,\"<=31/07\",Subtotal)-B10-B11-B12-B13-B14-B15","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/07\",Sales_Tax)-C10-C11-C12-C13-C14-C15","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/07\",Sales_Total)-D10-D11-D12-D13-D14-D15","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/07\",Sales_Quantity)-E10-E11-E12-E13-E14-E15","v":{"$error":"#NAME?"}},0,0,{"$error":"#NAME?"},0,0]
["August",{"$f":"SUMIF(Sales_Date,\"<=31/08\",Subtotal)-B10-B11-B12-B13-B14-B15-B16","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/08\",Sales_Tax)-C10-C11-C12-C13-C14-C15-C16","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/08\",Sales_Total)-D10-D11-D12-D13-D14-D15-D16","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/08\",Sales_Quantity)-E10-E11-E12-E13-E14-E15-E16","v":{"$error":"#NAME?"}},0,0,{"$error":"#NAME?"},0,0]
["September",{"$f":"SUMIF(Sales_Date,\"<=30/09\",Subtotal)-B10-B11-B12-B13-B14-B15-B16-B17","v":0},{"$f":"SUMIF(Sales_Date,\"<=30/09\",Sales_Tax)-C10-C11-C12-C13-C14-C15-C16-C17","v":0},{"$f":"SUMIF(Sales_Date,\"<=30/09\",Sales_Total)-D10-D11-D12-D13-D14-D15-D16-D17","v":0},{"$f":"SUMIF(Sales_Date,\"<=30/09\",Sales_Quantity)-E10-E11-E12-E13-E14-E15-E16-E17","v":{"$error":"#NAME?"}},0,0,{"$error":"#NAME?"},0,0]
["October",{"$f":"SUMIF(Sales_Date,\"<=31/10\",Subtotal)-B10-B11-B12-B13-B14-B15-B16-B17-B18","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/10\",Sales_Tax)-C10-C11-C12-C13-C14-C15-C16-C17-C18","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/10\",Sales_Total)-D10-D11-D12-D13-D14-D15-D16-D17-D18","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/10\",Sales_Quantity)-E10-E11-E12-E13-E14-E15-E16-E17-E18","v":{"$error":"#NAME?"}},0,0,{"$error":"#NAME?"},0,0]
["November",{"$f":"SUMIF(Sales_Date,\"<=30/11\",Subtotal)-B10-B11-B12-B13-B14-B15-B16-B17-B18-B19","v":0},{"$f":"SUMIF(Sales_Date,\"<=30/11\",Sales_Tax)-C10-C11-C12-C13-C14-C15-C16-C17-C18-C19","v":0},{"$f":"SUMIF(Sales_Date,\"<=30/11\",Sales_Total)-D10-D11-D12-D13-D14-D15-D16-D17-D18-D19","v":0},{"$f":"SUMIF(Sales_Date,\"<=30/11\",Sales_Quantity)-E10-E11-E12-E13-E14-E15-E16-E17-E18-E19","v":{"$error":"#NAME?"}},0,0,{"$error":"#NAME?"},0,0]
["December",{"$f":"SUMIF(Sales_Date,\"<=31/12\",Subtotal)-B10-B11-B12-B13-B14-B15-B16-B17-B18-B19-B20","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/12\",Sales_Tax)-C10-C11-C12-C13-C14-C15-C16-C17-C18-C19-C20","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/12\",Sales_Total)-D10-D11-D12-D13-D14-D15-D16-D17-D18-D19-D20","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/12\",Sales_Quantity)-E10-E11-E12-E13-E14-E15-E16-E17-E18-E19-E20","v":{"$error":"#NAME?"}},0,0,{"$error":"#NAME?"},0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Accounts Recivable"]
[]
["January",{"$f":"SUMIF(Sales_Date,\"<=31/01\",Sales!L12:L250)","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/01\",Sales!$M$12:$M$250)","v":0}]
["February",{"$f":"SUMIF(Sales_Date,\"<=28/02\",Sales!$L$12:$L$250)-SUM($B$42:B42)","v":0},{"$f":"SUMIF(Sales_Date,\"<=28/02\",Sales!$M$12:$M$250)-SUM($C$42:C42)","v":0}]
["March",{"$f":"SUMIF(Sales_Date,\"<=31/03\",Sales!$L$12:$L$250)-SUM($B$42:B43)","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/03\",Sales!$M$12:$M$250)-SUM($C$42:C43)","v":0}]
["April",{"$f":"SUMIF(Sales_Date,\"<=30/04\",Sales!$L$12:$L$250)-SUM($B$42:B44)","v":0},{"$f":"SUMIF(Sales_Date,\"<=30/04\",Sales!$M$12:$M$250)-SUM($C$42:C44)","v":0}]
["May",{"$f":"SUMIF(Sales_Date,\"<=31/05\",Sales!$L$12:$L$250)-SUM($B$42:B45)","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/05\",Sales!$M$12:$M$250)-SUM($C$42:C45)","v":0}]
["June",{"$f":"SUMIF(Sales_Date,\"<=30/06\",Sales!$L$12:$L$250)-SUM($B$42:B46)","v":0},{"$f":"SUMIF(Sales_Date,\"<=30/06\",Sales!$M$12:$M$250)-SUM($C$42:C46)","v":0}]
["July",{"$f":"SUMIF(Sales_Date,\"<=31/07\",Sales!$L$12:$L$250)-SUM($B$42:B47)","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/07\",Sales!$M$12:$M$250)-SUM($C$42:C47)","v":0}]
["August",{"$f":"SUMIF(Sales_Date,\"<=31/08\",Sales!$L$12:$L$250)-SUM($B$42:B48)","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/08\",Sales!$M$12:$M$250)-SUM($C$42:C48)","v":0}]
["September",{"$f":"SUMIF(Sales_Date,\"<=30/09\",Sales!$L$12:$L$250)-SUM($B$42:B49)","v":0},{"$f":"SUMIF(Sales_Date,\"<=30/09\",Sales!$M$12:$M$250)-SUM($C$42:C49)","v":0}]
["October",{"$f":"SUMIF(Sales_Date,\"<=31/10\",Sales!$L$12:$L$250)-SUM($B$42:B50)","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/10\",Sales!$M$12:$M$250)-SUM($C$42:C50)","v":0}]
["November",{"$f":"SUMIF(Sales_Date,\"<=30/11\",Sales!$L$12:$L$250)-SUM($B$42:B51)","v":0},{"$f":"SUMIF(Sales_Date,\"<=30/11\",Sales!$M$12:$M$250)-SUM($C$42:C51)","v":0}]
["December",{"$f":"SUMIF(Sales_Date,\"<=31/12\",Sales!$L$12:$L$250)-SUM($B$42:B52)","v":0},{"$f":"SUMIF(Sales_Date,\"<=31/12\",Sales!$M$12:$M$250)-SUM($C$42:C52)","v":0}]

{"sheet":"Login","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"template - Basic Invoice","index":6,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":true,"merged":[[35,0,35,6],[36,0,40,6],[49,0,49,10],[46,0,46,10],[47,0,47,10],[48,0,48,10],[33,0,33,8],[33,9,33,10],[26,0,26,8],[26,9,26,10],[27,0,27,8],[27,9,27,10],[28,0,28,8],[28,9,28,10],[31,0,31,8],[31,9,31,10],[32,0,32,8],[32,9,32,10],[29,0,29,8],[29,9,29,10],[30,0,30,8],[30,9,30,10],[23,0,23,8],[23,9,23,10],[25,0,25,8],[25,9,25,10],[24,0,24,8],[24,9,24,10],[22,0,22,8],[22,9,22,10],[21,0,21,8],[21,9,21,10],[19,0,19,8],[19,9,19,10],[20,0,20,8],[20,9,20,10],[18,0,18,8],[18,9,18,10],[10,0,10,3],[10,7,10,10],[11,0,11,3],[11,7,11,10],[17,0,17,8],[17,9,17,10],[15,0,15,3],[15,7,15,10],[12,0,12,3],[12,7,12,10],[14,0,14,3],[14,7,14,10],[13,0,13,3],[13,7,13,10],[9,0,9,3],[9,7,9,10],[5,9,5,10],[0,0,0,3],[3,0,3,3],[3,9,3,10],[4,0,4,3],[4,9,4,10],[6,9,6,10],[7,9,7,10]]}
[{"$f":"_companyName","v":"Company Name"},null,null,null,null,null,null,null,null,null,"INVOICE"]
[{"$f":"_companySlogan","v":"Company Slogan"}]
[]
[null,null,null,null,null,null,null,"Date:",null,{"$f":"_invoiceDate","v":"2017-03-26"}]
[null,null,null,null,null,null,null,"Invoice #:",null,{"$f":"_newInvoice","v":1}]
[null,null,null,null,null,null,null,"Customer ID:",null,{"$f":"rngCustID","v":""}]
[null,null,null,null,null,null,null,"Purchase Order #",null,{"$f":"_purchaseOrder","v":""}]
[null,null,null,null,null,null,null,"Payment Due by:",null,{"$f":"_invoiceDueDate","v":""}]
[]
["Bill To:",null,null,null,null,null,null,"Ship To:"]
[{"$f":"rngCustName","v":""},null,null,null,null,null,null,{"$f":"rngShippingAddress","v":"[Name]"}]
[{"$f":"address_line1","v":""},null,null,null,null,null,null,{"$f":"altComName","v":"[Company Name]"}]
[{"$f":"address_line2","v":""},null,null,null,null,null,null,{"$f":"altAddress_line1","v":"[Street Address]"}]
[{"$f":"phone","v":""},null,null,null,null,null,null,{"$f":"altAddress_line2","v":"[City, ST  ZIP Code]"}]
[{"$f":"fax","v":""},null,null,null,null,null,null,{"$f":"altPhone","v":"[Phone]"}]
[{"$f":"email","v":""},null,null,null,null,null,null,{"$f":"altContactName","v":"[Contact Name]"}]
[]
["Description",null,null,null,null,null,null,null,null,"Line Total"]
["Printing and Binding (160*$1.75/each)",null,null,null,null,null,null,null,null,{"$f":"160*1.75","v":280}]
["A4 Printing Paper (10*$15.20/5*500 Sheets)",null,null,null,null,null,null,null,null,{"$f":"10*15.2","v":152}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Special Notes and Instructions",null,null,null,null,null,null,null,"Subtotal",{"$f":"IF(ISBLANK($K36),\"\",Settings!$C$26)","v":"$"},{"$f":"SUM($J$19:$J$34)","v":432}]
[{"$f":"IF(ISBLANK(Home!$F$33),\"\",Home!$F$33)","v":""},null,null,null,null,null,null,null,{"$f":"\"Discount \"&TEXT(_dicount,\"0%\")","v":"Discount 10%"},{"$f":"IF(ISBLANK($K37),\"\",Settings!$C$26)","v":"$"},{"$f":"Home!F31*K36","v":43.2}]
[null,null,null,null,null,null,null,null,{"$f":"Settings!$C$24&\" Rate\"","v":"Sales Tax Rate"},"%",{"$f":"_taxRate*100","v":20}]
[null,null,null,null,null,null,null,null,{"$f":"Settings!$C$24","v":"Sales Tax"},{"$f":"IF(ISBLANK($K39),\"\",Settings!$C$26)","v":"$"},{"$f":"IF(K36>0,(K36-rngDiscount)*(K38/100),0)","v":77.760000000000005}]
[null,null,null,null,null,null,null,null,"S&H",{"$f":"IF(ISBLANK($K40),\"\",Settings!$C$26)","v":"$"},{"$f":"_service_handl","v":0}]
[null,null,null,null,null,null,null,null,"Total",{"$f":"IF(ISBLANK($K41),\"\",Settings!$C$26)","v":"$"},{"$f":"SUM($K$36-$K$37,$K$39,$K$40)","v":466.56}]
[]
[{"$f":"\"Make all checks payable to \"&Settings!C5","v":"Make all checks payable to Company Name"},null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$39&\": \"&Settings!$C$39,\"\")","v":"Bank Name: Your Bank Name"}]
["Thank you for your business!",null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$40&Settings!$C$40,\"\")","v":"Account #00000000"}]
[null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$41&Settings!$C$41,\"\")","v":"Routing/Sort Code #12-34-56"}]
[]
[{"$f":"IF(ISBLANK(Home!$F$6),\"\",\"Should you have any enquiries concerning this invoice, please contact \"&Home!$F$6&\" on \"&Settings!$C$17&IF(ISBLANK(INDEX(Sales_Rep,MATCH(Home!$F$6,Sales_Rep_Name,0),6)),\"\",\", ext.\"&INDEX(Sales_Rep,MATCH(Home!$F$6,Sales_Rep_Name,0),6)))","v":{"$error":"#N/A"}}]
[]
[{"$f":"Settings!C10&\", \"&IF(ISBLANK(Settings!C11),\"\",Settings!C11&\", \")&Settings!C12&\", \"&Settings!C14&\", \"&Settings!C15&\", \"&Settings!C13&IF(Company_Reg=\"Yes\",\", \"&Settings!B34&Settings!$C$34&\", \"&Settings!B35&Settings!C35,\"\")","v":"111, Street, Town/City, ST, 00000, Country, Company Reg. #123456, Sales Tax ID123456"}]
[{"$f":"\"Phone: \"&Settings!$C$17&\", Fax: \"&Settings!$C$18&\", E-Mail: \"&Settings!$C$19&\", Web: \"&Settings!$C$20","v":"Phone: 0-000-000-0000, Fax: 0-000-000-0000, E-Mail: info@yourcompanysite.com, Web: www.yourcompanysite.com"}]

{"sheet":"template - Sales Invoice","index":7,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":true,"merged":[[22,10,22,11],[14,8,14,11],[11,8,11,11],[12,8,12,11],[7,10,7,11],[13,8,13,11],[21,10,21,11],[20,10,20,11],[17,6,17,9],[17,10,17,11],[15,8,15,11],[18,10,18,11],[18,6,18,9],[22,1,22,7],[18,3,18,5],[27,10,27,11],[23,10,23,11],[26,10,26,11],[25,10,25,11],[24,10,24,11],[3,10,3,11],[4,10,4,11],[5,10,5,11],[13,0,13,3],[3,8,3,9],[4,8,4,9],[3,0,3,2],[11,0,11,3],[10,0,10,3],[5,8,5,9],[6,10,6,11],[6,8,6,9],[7,8,7,9],[10,8,10,11],[9,8,9,11],[0,0,0,3],[29,1,29,7],[23,1,23,7],[21,1,21,7],[25,1,25,7],[4,0,4,2],[12,0,12,3],[9,0,9,3],[14,0,14,3],[15,0,15,3],[17,0,17,2],[18,0,18,2],[26,1,26,7],[27,1,27,7],[17,3,17,5],[20,1,20,7],[24,1,24,7],[40,14,40,17],[39,14,39,17],[35,1,35,7],[35,10,35,11],[36,10,36,11],[38,0,38,7],[36,1,36,7],[31,1,31,7],[33,1,33,7],[29,10,29,11],[30,10,30,11],[31,10,31,11],[28,1,28,7],[30,1,30,7],[28,10,28,11],[51,0,51,11],[49,0,49,11],[50,0,50,11],[39,0,43,7],[32,1,32,7],[34,10,34,11],[34,1,34,7],[33,10,33,11],[32,10,32,11]]}
[{"$f":"_companyName","v":"Company Name"},null,null,null,null,null,null,null,null,null,null,"INVOICE"]
[{"$f":"_companySlogan","v":"Company Slogan"}]
[]
[null,null,null,null,null,null,null,null,"Date:",null,{"$f":"_invoiceDate","v":"2017-03-26"}]
[null,null,null,null,null,null,null,null,"Invoice #:",null,{"$f":"_newInvoice","v":1}]
[null,null,null,null,null,null,null,null,"Customer ID:",null,{"$f":"rngCustID","v":""}]
[null,null,null,null,null,null,null,null,"Purchase Order #",null,{"$f":"_purchaseOrder","v":""}]
[null,null,null,null,null,null,null,null,"Payment Due by:",null,{"$f":"_invoiceDueDate","v":""}]
[]
["Bill To:",null,null,null,null,null,null,null,"Ship To:"]
[{"$f":"rngCustName","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Home!$K$21),\"\",Home!$K$21)","v":"[Name]"}]
[{"$f":"address_line1","v":""},null,null,null,null,null,null,null,{"$f":"altComName","v":"[Company Name]"}]
[{"$f":"address_line2","v":""},null,null,null,null,null,null,null,{"$f":"altAddress_line1","v":"[Street Address]"}]
[{"$f":"phone","v":""},null,null,null,null,null,null,null,{"$f":"altAddress_line2","v":"[City, ST  ZIP Code]"}]
[{"$f":"fax","v":""},null,null,null,null,null,null,null,{"$f":"altPhone","v":"[Phone]"}]
[{"$f":"email","v":""},null,null,null,null,null,null,null,{"$f":"altContactName","v":"[Contact Name]"}]
[]
["Shipping Method",null,null,"Shipping Terms",null,null,"Payment Terms",null,null,null,"Delivery Date"]
[null,null,null,null,null,null,{"$f":"_paymentDue","v":0}]
[]
["Item #","Description",null,null,null,null,null,null,"Qty","Unit Price","Line Total"]
[112233,"Product 6",null,null,null,null,null,null,5,15,{"$f":"IF(OR(ISBLANK($I22),$I22=0),0,$I22*$J22)","v":75}]
[445566,"Product 2",null,null,null,null,null,null,3,21,{"$f":"IF(OR(ISBLANK($I23),$I23=0),0,$I23*$J23)","v":63}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[]
["Special Notes and Instructions",null,null,null,null,null,null,null,null,"Subtotal",{"$f":"IF(ISBLANK($J39),\"\",Settings!$C$26)","v":"$"},{"$f":"SUM($K$22:$K$37)","v":138}]
[{"$f":"IF(ISBLANK(Home!$F$33),\"\",Home!$F$33)","v":""},null,null,null,null,null,null,null,null,{"$f":"\"Discount \"&TEXT(_dicount,\"0%\")","v":"Discount 10%"},{"$f":"IF(ISBLANK($J40),\"\",Settings!$C$26)","v":"$"},{"$f":"Home!F31*L39","v":13.8}]
[null,null,null,null,null,null,null,null,null,{"$f":"Settings!$C$24&\" Rate\"","v":"Sales Tax Rate"},"%",{"$f":"_taxRate*100","v":20}]
[null,null,null,null,null,null,null,null,null,{"$f":"Settings!$C$24","v":"Sales Tax"},{"$f":"IF(ISBLANK($J42),\"\",Settings!$C$26)","v":"$"},{"$f":"IF(L39>0,(L39-rngDiscount)*(L41/100),0)","v":24.840000000000003}]
[null,null,null,null,null,null,null,null,null,"S&H",{"$f":"IF(ISBLANK($J43),\"\",Settings!$C$26)","v":"$"},{"$f":"_service_handl","v":0}]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"IF(ISBLANK($J44),\"\",Settings!$C$26)","v":"$"},{"$f":"SUM($L$39-$L$40,$L$42,$L$43)","v":149.04000000000002}]
[]
[{"$f":"\"Make all checks payable to \"&Settings!C5","v":"Make all checks payable to Company Name"},null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$39&\": \"&Settings!$C$39,\"\")","v":"Bank Name: Your Bank Name"}]
["Thank you for your business!",null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$40&Settings!$C$40,\"\")","v":"Account #00000000"}]
[null,null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$41&Settings!$C$41,\"\")","v":"Routing/Sort Code #12-34-56"}]
[]
[{"$f":"IF(ISBLANK(Home!$F$6),\"\",\"Should you have any enquiries concerning this invoice, please contact \"&Home!$F$6&\" on \"&Settings!$C$17&IF(ISBLANK(INDEX(Sales_Rep,MATCH(Home!$F$6,Sales_Rep_Name,0),6)),\"\",\", ext.\"&INDEX(Sales_Rep,MATCH(Home!$F$6,Sales_Rep_Name,0),6)))","v":{"$error":"#N/A"}}]
[{"$f":"Settings!C10&\", \"&IF(ISBLANK(Settings!C11),\"\",Settings!C11&\", \")&Settings!C12&\", \"&Settings!C14&\", \"&Settings!C15&\", \"&Settings!C13&IF(Company_Reg=\"Yes\",\", \"&Settings!B34&Settings!$C$34&\", \"&Settings!B35&Settings!C35,\"\")","v":"111, Street, Town/City, ST, 00000, Country, Company Reg. #123456, Sales Tax ID123456"}]
[{"$f":"\"Phone: \"&Settings!$C$17&\", Fax: \"&Settings!$C$18&\", E-Mail: \"&Settings!$C$19&\", Web: \"&Settings!$C$20","v":"Phone: 0-000-000-0000, Fax: 0-000-000-0000, E-Mail: info@yourcompanysite.com, Web: www.yourcompanysite.com"}]

{"sheet":"template - Price List Invoice","index":8,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":true,"merged":[[4,0,4,2],[4,8,4,9],[4,10,4,11],[0,0,0,3],[3,0,3,2],[3,8,3,9],[3,10,3,11],[14,0,14,3],[14,8,14,11],[9,0,9,3],[9,8,9,11],[10,0,10,3],[10,8,10,11],[11,0,11,3],[11,8,11,11],[12,0,12,3],[12,8,12,11],[13,0,13,3],[13,8,13,11],[5,10,5,11],[6,8,6,9],[6,10,6,11],[7,8,7,9],[7,10,7,11],[5,8,5,9],[15,0,15,3],[15,8,15,11],[17,0,17,2],[17,3,17,5],[17,6,17,9],[17,10,17,11],[18,6,18,9],[18,10,18,11],[26,1,26,7],[26,10,26,11],[21,1,21,7],[21,10,21,11],[23,1,23,7],[23,10,23,11],[22,1,22,7],[22,10,22,11],[20,1,20,7],[20,10,20,11],[18,0,18,2],[18,3,18,5],[36,1,36,7],[36,10,36,11],[35,1,35,7],[30,1,30,7],[30,10,30,11],[31,10,31,11],[32,1,32,7],[32,10,32,11],[29,1,29,7],[29,10,29,11],[24,1,24,7],[24,10,24,11],[35,10,35,11],[27,1,27,7],[27,10,27,11],[25,1,25,7],[25,10,25,11],[28,1,28,7],[28,10,28,11],[34,1,34,7],[34,10,34,11],[33,1,33,7],[33,10,33,11],[31,1,31,7],[40,15,40,18],[38,0,38,7],[39,15,39,18],[51,0,51,11],[39,0,43,7],[50,0,50,11],[49,0,49,11]]}
[{"$f":"_companyName","v":"Company Name"},null,null,null,null,null,null,null,null,null,null,"INVOICE"]
[{"$f":"_companySlogan","v":"Company Slogan"}]
[]
[null,null,null,null,null,null,null,null,"Date:",null,{"$f":"_invoiceDate","v":"2017-03-26"}]
[null,null,null,null,null,null,null,null,"Invoice #:",null,{"$f":"_newInvoice","v":1}]
[null,null,null,null,null,null,null,null,"Customer ID:",null,{"$f":"rngCustID","v":""}]
[null,null,null,null,null,null,null,null,"Purchase Order #",null,{"$f":"_purchaseOrder","v":""}]
[null,null,null,null,null,null,null,null,"Payment Due by:",null,{"$f":"_invoiceDueDate","v":""}]
[]
["Bill To:",null,null,null,null,null,null,null,"Ship To:"]
[{"$f":"rngCustName","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Home!$K$21),\"\",Home!$K$21)","v":"[Name]"}]
[{"$f":"address_line1","v":""},null,null,null,null,null,null,null,{"$f":"altComName","v":"[Company Name]"}]
[{"$f":"address_line2","v":""},null,null,null,null,null,null,null,{"$f":"altAddress_line1","v":"[Street Address]"}]
[{"$f":"phone","v":""},null,null,null,null,null,null,null,{"$f":"altAddress_line2","v":"[City, ST  ZIP Code]"}]
[{"$f":"fax","v":""},null,null,null,null,null,null,null,{"$f":"altPhone","v":"[Phone]"}]
[{"$f":"email","v":""},null,null,null,null,null,null,null,{"$f":"altContactName","v":"[Contact Name]"}]
[]
["Shipping Method",null,null,"Shipping Terms",null,null,"Payment Terms",null,null,null,"Delivery Date"]
[null,null,null,null,null,null,{"$f":"_paymentDue","v":0}]
[]
["Item #","Description",null,null,null,null,null,null,"Qty","Unit Price","Line Total"]
[{"$f":"IF(ISBLANK($B22),\"\",INDEX(code,MATCH($B22,product,0)))","v":"11Z2233"},"Product 2",null,null,null,null,null,null,5,{"$f":"IF(ISBLANK(B22),\"\",INDEX(unit_price,MATCH(B22,product,0)))","v":7},{"$f":"IF(OR(ISBLANK(B22),ISBLANK($I22),$I22=0),0,$I22*$J22)","v":35}]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
[]
["Special Notes and Instructions",null,null,null,null,null,null,null,null,"Subtotal",{"$f":"IF(ISBLANK($J39),\"\",Settings!$C$26)","v":"$"},{"$f":"SUM($K$22:$K$37)","v":35}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Discount \"&TEXT(_dicount,\"0%\")","v":"Discount 10%"},{"$f":"IF(ISBLANK($J40),\"\",Settings!$C$26)","v":"$"},{"$f":"Home!F31*L39","v":3.5}]
[null,null,null,null,null,null,null,null,null,{"$f":"Settings!$C$24&\" Rate\"","v":"Sales Tax Rate"},"%",{"$f":"_taxRate*100","v":20}]
[null,null,null,null,null,null,null,null,null,{"$f":"Settings!$C$24","v":"Sales Tax"},{"$f":"IF(ISBLANK($J42),\"\",Settings!$C$26)","v":"$"},{"$f":"IF(L39>0,(L39-rngDiscount)*(L41/100),0)","v":6.3000000000000007}]
[null,null,null,null,null,null,null,null,null,"S&H",{"$f":"IF(ISBLANK($J43),\"\",Settings!$C$26)","v":"$"},{"$f":"_service_handl","v":0}]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"IF(ISBLANK($J44),\"\",Settings!$C$26)","v":"$"},{"$f":"SUM($L$39-$L$40,$L$42,$L$43)","v":37.799999999999997}]
[]
[{"$f":"\"Make all checks payable to \"&Settings!C5","v":"Make all checks payable to Company Name"},null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$39&\": \"&Settings!$C$39,\"\")","v":"Bank Name: Your Bank Name"}]
["Thank you for your business!",null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$40&Settings!$C$40,\"\")","v":"Account #00000000"}]
[null,null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$41&Settings!$C$41,\"\")","v":"Routing/Sort Code #12-34-56"}]
[]
[{"$f":"IF(ISBLANK(Home!$F$6),\"\",\"Should you have any enquiries concerning this invoice, please contact \"&Home!$F$6&\" on \"&Settings!$C$17&IF(ISBLANK(INDEX(Sales_Rep,MATCH(Home!$F$6,Sales_Rep_Name,0),6)),\"\",\", ext.\"&INDEX(Sales_Rep,MATCH(Home!$F$6,Sales_Rep_Name,0),6)))","v":{"$error":"#N/A"}}]
[{"$f":"Settings!C10&\", \"&IF(ISBLANK(Settings!C11),\"\",Settings!C11&\", \")&Settings!C12&\", \"&Settings!C14&\", \"&Settings!C15&\", \"&Settings!C13&IF(Company_Reg=\"Yes\",\", \"&Settings!B34&Settings!$C$34&\", \"&Settings!B35&Settings!C35,\"\")","v":"111, Street, Town/City, ST, 00000, Country, Company Reg. #123456, Sales Tax ID123456"}]
[{"$f":"\"Phone: \"&Settings!$C$17&\", Fax: \"&Settings!$C$18&\", E-Mail: \"&Settings!$C$19&\", Web: \"&Settings!$C$20","v":"Phone: 0-000-000-0000, Fax: 0-000-000-0000, E-Mail: info@yourcompanysite.com, Web: www.yourcompanysite.com"}]

{"sheet":"template - Remittance Invoice","index":9,"n_rows":63,"n_cols":12,"rows_kept":63,"cut":false,"hidden":true,"merged":[[47,0,47,11],[62,0,62,11],[50,0,50,11],[55,2,55,4],[55,10,55,11],[61,0,61,11],[48,0,48,11],[34,0,34,7],[35,0,39,7],[45,0,45,11],[25,1,25,7],[25,10,25,11],[26,1,26,7],[26,10,26,11],[29,1,29,7],[29,10,29,11],[27,1,27,7],[30,1,30,7],[30,10,30,11],[32,1,32,7],[32,10,32,11],[31,1,31,7],[31,10,31,11],[27,10,27,11],[15,0,15,3],[28,1,28,7],[28,10,28,11],[23,1,23,7],[23,10,23,11],[21,1,21,7],[24,1,24,7],[24,10,24,11],[21,10,21,11],[22,1,22,7],[17,6,17,9],[20,1,20,7],[20,10,20,11],[22,10,22,11],[17,10,17,11],[18,10,18,11],[18,0,18,2],[18,3,18,5],[18,6,18,9],[17,0,17,2],[17,3,17,5],[15,8,15,11],[12,0,12,3],[12,8,12,11],[13,0,13,3],[13,8,13,11],[14,0,14,3],[9,0,9,3],[9,8,9,11],[14,8,14,11],[5,10,5,11],[6,10,6,11],[10,0,10,3],[10,8,10,11],[11,0,11,3],[11,8,11,11],[3,0,3,3],[3,10,3,11],[4,0,4,3],[4,10,4,11],[7,10,7,11]]}
[{"$f":"_companyName","v":"Company Name"},null,null,null,null,null,null,null,null,null,null,"INVOICE"]
[{"$f":"_companySlogan","v":"Company Slogan"}]
[]
[null,null,null,null,null,null,null,null,"Date:",null,{"$f":"_invoiceDate","v":"2017-03-26"}]
[null,null,null,null,null,null,null,null,"Invoice #:",null,{"$f":"_newInvoice","v":1}]
[null,null,null,null,null,null,null,null,"Customer ID:",null,{"$f":"rngCustID","v":""}]
[null,null,null,null,null,null,null,null,"Purchase Order #",null,{"$f":"_purchaseOrder","v":""}]
[null,null,null,null,null,null,null,null,"Payment Due by:",null,{"$f":"_invoiceDueDate","v":""}]
[]
["Bill To:",null,null,null,null,null,null,null,"Ship To:"]
[{"$f":"rngCustName","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Home!$K$21),\"\",Home!$K$21)","v":"[Name]"}]
[{"$f":"address_line1","v":""},null,null,null,null,null,null,null,{"$f":"altComName","v":"[Company Name]"}]
[{"$f":"address_line2","v":""},null,null,null,null,null,null,null,{"$f":"altAddress_line1","v":"[Street Address]"}]
[{"$f":"phone","v":""},null,null,null,null,null,null,null,{"$f":"altAddress_line2","v":"[City, ST  ZIP Code]"}]
[{"$f":"fax","v":""},null,null,null,null,null,null,null,{"$f":"altPhone","v":"[Phone]"}]
[{"$f":"email","v":""},null,null,null,null,null,null,null,{"$f":"altContactName","v":"[Contact Name]"}]
[]
["Shipping Method",null,null,"Shipping Terms",null,null,"Payment Terms",null,null,null,"Delivery Date"]
[null,null,null,null,null,null,{"$f":"_paymentDue","v":0}]
[]
["Item #","Description",null,null,null,null,null,null,"Qty","Unit Price","Line Total"]
[{"$f":"IF(ISBLANK($B22),\"\",INDEX(code,MATCH($B22,product,0)))","v":555555},"Product 18",null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(B22),\"\",INDEX(unit_price,MATCH(B22,product,0)))","v":35},{"$f":"IF(OR(ISBLANK(B22),ISBLANK(I22),I22=0),0,I22*J22)","v":70}]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
["",null,null,null,null,null,null,null,null,"",0]
[]
["Special Notes and Instructions",null,null,null,null,null,null,null,null,"Subtotal",{"$f":"IF(ISBLANK($J35),\"\",Settings!$C$26)","v":"$"},{"$f":"SUM($K$22:$K$33)","v":70}]
[{"$f":"IF(ISBLANK(Home!$F$33),\"\",Home!$F$33)","v":""},null,null,null,null,null,null,null,null,{"$f":"\"Discount \"&TEXT(_dicount,\"0%\")","v":"Discount 10%"},{"$f":"IF(ISBLANK($J36),\"\",Settings!$C$26)","v":"$"},{"$f":"Home!F31*L35","v":7}]
[null,null,null,null,null,null,null,null,null,{"$f":"Settings!$C$24&\" Rate\"","v":"Sales Tax Rate"},"%",{"$f":"_taxRate*100","v":20}]
[null,null,null,null,null,null,null,null,null,{"$f":"Settings!$C$24","v":"Sales Tax"},{"$f":"IF(ISBLANK($J38),\"\",Settings!$C$26)","v":"$"},{"$f":"IF(L35>0,(L35-rngDiscount)*(L37/100),0)","v":12.600000000000001}]
[null,null,null,null,null,null,null,null,null,"S&H",{"$f":"IF(ISBLANK($J39),\"\",Settings!$C$26)","v":"$"},{"$f":"_service_handl","v":0}]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"IF(ISBLANK($J40),\"\",Settings!$C$26)","v":"$"},{"$f":"SUM($L$35-$L$36,$L$38,$L$39)","v":75.599999999999994}]
[]
[{"$f":"\"Make all checks payable to \"&Settings!C5","v":"Make all checks payable to Company Name"},null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$39&\": \"&Settings!$C$39,\"\")","v":"Bank Name: Your Bank Name"}]
["Thank you for your business!",null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$40&Settings!$C$40,\"\")","v":"Account #00000000"}]
[null,null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$41&Settings!$C$41,\"\")","v":"Routing/Sort Code #12-34-56"}]
[]
[{"$f":"IF(ISBLANK(Home!$F$6),\"\",\"Should you have any enquiries concerning this invoice, please contact \"&Home!$F$6&\" on \"&Settings!$C$17&IF(ISBLANK(INDEX(Sales_Rep,MATCH(Home!$F$6,Sales_Rep_Name,0),6)),\"\",\", ext.\"&INDEX(Sales_Rep,MATCH(Home!$F$6,Sales_Rep_Name,0),6)))","v":{"$error":"#N/A"}}]
[]
[{"$f":"Settings!C10&\", \"&IF(ISBLANK(Settings!C11),\"\",Settings!C11&\", \")&Settings!C12&\", \"&Settings!C14&\", \"&Settings!C15&\", \"&Settings!C13&IF(Company_Reg=\"Yes\",\", \"&Settings!B34&Settings!$C$34&\", \"&Settings!B35&Settings!C35,\"\")","v":"111, Street, Town/City, ST, 00000, Country, Company Reg. #123456, Sales Tax ID123456"}]
[{"$f":"\"Phone: \"&Settings!$C$17&\", Fax: \"&Settings!$C$18&\", E-Mail: \"&Settings!$C$19&\", Web: \"&Settings!$C$20","v":"Phone: 0-000-000-0000, Fax: 0-000-000-0000, E-Mail: info@yourcompanysite.com, Web: www.yourcompanysite.com"}]
[]
["Please return this slip along with your payment"]
[]
[{"$f":"IF(Settings!$F$5=\"Enable\",Settings!$C$5,\"\")","v":"Company Name"},null,null,null,null,null,null,null,null,null,null,"Remittance Slip"]
[{"$f":"IF(Settings!$F$6=\"Enable\",Settings!$C$6,\"\")","v":"Company Slogan"}]
[]
["Check No.",null,null,null,null,null,null,null,null,"Date"]
[]
[{"$f":"I6","v":"Customer ID:"},null,{"$f":"K6","v":""},null,null,null,null,null,null,"Amount Enclosed:",{"$f":"IF(ISBLANK($J58),\"\",Settings!$C$26)","v":"$"}]
[]
[{"$f":"I5","v":"Invoice #:"},null,{"$f":"K5","v":1},null,null,null,null,null,null,"Balance to Pay:",{"$f":"IF(ISBLANK($J60),\"\",Settings!$C$26)","v":"$"}]
[]
[{"$f":"Settings!C10&\", \"&IF(ISBLANK(Settings!C11),\"\",Settings!C11&\", \")&Settings!C12&\", \"&Settings!C14&\", \"&Settings!C15&\", \"&Settings!C13&IF(Company_Reg=\"Yes\",\", \"&Settings!B34&Settings!$C$34&\", \"&Settings!B35&Settings!C35,\"\")","v":"111, Street, Town/City, ST, 00000, Country, Company Reg. #123456, Sales Tax ID123456"}]
[{"$f":"\"Phone: \"&Settings!$C$17&\", Fax: \"&Settings!$C$18&\", E-Mail: \"&Settings!$C$19&\", Web: \"&Settings!$C$20","v":"Phone: 0-000-000-0000, Fax: 0-000-000-0000, E-Mail: info@yourcompanysite.com, Web: www.yourcompanysite.com"}]

{"sheet":"template - Parts and Labor","index":10,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":true,"merged":[[15,8,15,11],[0,0,0,3],[3,0,3,2],[3,8,3,9],[11,0,11,3],[11,8,11,11],[4,10,4,11],[3,10,3,11],[4,0,4,2],[4,8,4,9],[5,10,5,11],[9,0,9,3],[9,8,9,11],[5,8,5,9],[6,8,6,9],[6,10,6,11],[18,10,18,11],[12,0,12,3],[12,8,12,11],[19,10,19,11],[7,10,7,11],[18,0,18,6],[10,0,10,3],[14,0,14,3],[14,8,14,11],[17,0,17,6],[15,0,15,3],[13,0,13,3],[17,10,17,11],[13,8,13,11],[7,8,7,9],[10,8,10,11],[23,10,23,11],[25,0,25,6],[24,10,24,11],[25,10,25,11],[20,0,20,6],[20,10,20,11],[32,10,32,11],[31,0,31,6],[32,0,32,6],[27,0,27,6],[19,0,19,6],[28,10,28,11],[28,0,28,6],[26,10,26,11],[27,10,27,11],[22,0,22,6],[22,10,22,11],[23,0,23,6],[24,0,24,6],[26,0,26,6],[21,0,21,6],[21,10,21,11],[29,10,29,11],[30,10,30,11],[29,0,29,6],[30,0,30,6],[31,10,31,11],[49,0,49,11],[37,0,37,7],[50,0,50,11],[51,0,51,11],[38,0,43,7],[38,14,38,17],[39,14,39,17],[33,10,33,11],[35,0,35,6],[35,10,35,11],[34,10,34,11],[33,0,33,6],[34,0,34,6]]}
[{"$f":"_companyName","v":"Company Name"},null,null,null,null,null,null,null,null,null,null,"INVOICE"]
[{"$f":"_companySlogan","v":"Company Slogan"}]
[]
[null,null,null,null,null,null,null,null,"Date:",null,{"$f":"_invoiceDate","v":"2017-03-26"}]
[null,null,null,null,null,null,null,null,"Invoice #:",null,{"$f":"_newInvoice","v":1}]
[null,null,null,null,null,null,null,null,"Customer ID:",null,{"$f":"rngCustID","v":""}]
[null,null,null,null,null,null,null,null,"Purchase Order #",null,{"$f":"_purchaseOrder","v":""}]
[null,null,null,null,null,null,null,null,"Payment Due by:",null,{"$f":"_invoiceDueDate","v":""}]
[]
["Bill To:",null,null,null,null,null,null,null,"Ship To:"]
[{"$f":"rngCustName","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Home!$K$21),\"\",Home!$K$21)","v":"[Name]"}]
[{"$f":"address_line1","v":""},null,null,null,null,null,null,null,{"$f":"altComName","v":"[Company Name]"}]
[{"$f":"address_line2","v":""},null,null,null,null,null,null,null,{"$f":"altAddress_line1","v":"[Street Address]"}]
[{"$f":"phone","v":""},null,null,null,null,null,null,null,{"$f":"altAddress_line2","v":"[City, ST  ZIP Code]"}]
[{"$f":"fax","v":""},null,null,null,null,null,null,null,{"$f":"altPhone","v":"[Phone]"}]
[{"$f":"email","v":""},null,null,null,null,null,null,null,{"$f":"altContactName","v":"[Contact Name]"}]
[]
["Description",null,null,null,null,null,null,"Taxed","Qty","Unit Price","Line Total"]
["Printing materials and parts",null,null,null,null,null,null,"x",5,15,{"$f":"IF(OR(ISBLANK($I19),$I19=0),0,$I19*$J19)","v":75}]
["Printer serviceing ",null,null,null,null,null,null,null,1,20,{"$f":"IF(OR(ISBLANK($I20),$I20=0),0,$I20*$J20)","v":20}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[]
["Special Notes and Instructions",null,null,null,null,null,null,null,null,"Subtotal",{"$f":"IF(ISBLANK($J38),\"\",Settings!$C$26)","v":"$"},{"$f":"SUM($K$19:$K$36)","v":95}]
[{"$f":"IF(ISBLANK(Home!$F$33),\"\",Home!$F$33)","v":""},null,null,null,null,null,null,null,null,{"$f":"\"Discount \"&TEXT(_dicount,\"0%\")","v":"Discount 10%"},{"$f":"IF(ISBLANK($J39),\"\",Settings!$C$26)","v":"$"},{"$f":"Home!F31*L38","v":9.5}]
[null,null,null,null,null,null,null,null,null,"Taxable",{"$f":"IF(ISBLANK($J40),\"\",Settings!$C$26)","v":"$"},{"$f":"SUMIF($H$19:$H$36,\"x\",$K$19:$L$36)","v":75}]
[null,null,null,null,null,null,null,null,null,{"$f":"Settings!$C$24&\" Rate\"","v":"Sales Tax Rate"},"%",{"$f":"_taxRate*100","v":20}]
[null,null,null,null,null,null,null,null,null,{"$f":"Settings!$C$24","v":"Sales Tax"},{"$f":"IF(ISBLANK($J42),\"\",Settings!$C$26)","v":"$"},{"$f":"IF(L40>0,L40*(L41/100),0)","v":15}]
[null,null,null,null,null,null,null,null,null,"S&H",{"$f":"IF(ISBLANK($J43),\"\",Settings!$C$26)","v":"$"},{"$f":"_service_handl","v":0}]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"IF(ISBLANK($J44),\"\",Settings!$C$26)","v":"$"},{"$f":"IF(L38>0,L38+L42+L43-L39,0)","v":100.5}]
[]
[{"$f":"\"Make all checks payable to \"&Settings!C5","v":"Make all checks payable to Company Name"},null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$39&\": \"&Settings!$C$39,\"\")","v":"Bank Name: Your Bank Name"}]
["Thank you for your business!",null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$40&Settings!$C$40,\"\")","v":"Account #00000000"}]
[null,null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$41&Settings!$C$41,\"\")","v":"Routing/Sort Code #12-34-56"}]
[]
[{"$f":"IF(ISBLANK(Home!$F$6),\"\",\"Should you have any enquiries concerning this invoice, please contact \"&Home!$F$6&\" on \"&Settings!$C$17&IF(ISBLANK(INDEX(Sales_Rep,MATCH(Home!$F$6,Sales_Rep_Name,0),6)),\"\",\", ext.\"&INDEX(Sales_Rep,MATCH(Home!$F$6,Sales_Rep_Name,0),6)))","v":{"$error":"#N/A"}}]
[{"$f":"Settings!C10&\", \"&IF(ISBLANK(Settings!C11),\"\",Settings!C11&\", \")&Settings!C12&\", \"&Settings!C14&\", \"&Settings!C15&\", \"&Settings!C13&IF(Company_Reg=\"Yes\",\", \"&Settings!B34&Settings!$C$34&\", \"&Settings!B35&Settings!C35,\"\")","v":"111, Street, Town/City, ST, 00000, Country, Company Reg. #123456, Sales Tax ID123456"}]
[{"$f":"\"Phone: \"&Settings!$C$17&\", Fax: \"&Settings!$C$18&\", E-Mail: \"&Settings!$C$19&\", Web: \"&Settings!$C$20","v":"Phone: 0-000-000-0000, Fax: 0-000-000-0000, E-Mail: info@yourcompanysite.com, Web: www.yourcompanysite.com"}]

{"sheet":"Deposit Invoice","index":11,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":true,"merged":[[45,1,45,6],[38,1,38,6],[35,1,35,6],[44,1,44,6],[34,1,34,6],[43,1,43,6],[42,1,42,6],[36,1,36,6],[47,1,47,6],[48,1,48,6],[64,0,64,8],[54,3,54,4],[58,0,58,8],[60,0,60,8],[62,0,62,8],[63,0,63,8],[18,0,18,2],[21,7,21,8],[53,3,53,4],[25,1,25,6],[39,1,39,6],[28,1,28,6],[29,1,29,6],[46,1,46,6],[40,1,40,6],[41,1,41,6],[37,1,37,6],[50,1,50,6],[31,1,31,6],[30,1,30,6],[49,1,49,6],[33,1,33,6],[21,2,21,3],[32,1,32,6],[22,7,22,8],[26,1,26,6],[27,1,27,6],[24,1,24,6],[22,0,22,1],[22,4,22,6],[22,2,22,3],[17,0,17,2],[21,4,21,6],[7,0,7,3],[9,0,9,2],[10,0,10,2],[12,0,12,2],[14,0,14,2],[14,6,14,7],[13,0,13,2],[13,6,13,7],[16,0,16,2],[16,6,16,7],[15,0,15,2],[15,6,15,7],[18,6,18,7],[21,0,21,1]]}
[]
[]
[]
[]
[]
[]
[]
["Your Logo Here",null,null,null,null,null,null,null,"Invoice"]
[null,null,null,null,null,null,null,null,null,null,"Customer is:"]
[{"$f":"IF(ISBLANK(Settings!C5),\"\",Settings!C5)","v":"Company Name"},null,null,null,null,null,null,"Date:",{"$f":"IF(ISBLANK(L13),TODAY(),L13)","v":"2017-03-26"}]
[{"$f":"IF(ISBLANK(Settings!C6),\"\",Settings!C6)","v":"Company Slogan"},null,null,null,null,null,null,"Invoice #:",70001,null,"Customer:"]
[null,null,null,null,null,null,null,"Customer ID:",{"$f":"IF(ISBLANK($L$11),\"\",INDEX(Customers,MATCH($L$11,IF($L$9=\"Company\",Company,Person),0),1))","v":""}]
["To:",null,null,null,null,null,null,null,null,null,"Enter Invoice Date:"]
[{"$f":"IF(ISBLANK($L$11),\"\",INDEX(Customers,MATCH($L$11,IF($L$9=\"Company\",Company,Person),0),IF($L$9=\"Company\",3,2)))","v":""}]
[{"$f":"IF(ISBLANK($L$11),\"\",INDEX(Customers,MATCH($L$11,IF($L$9=\"Company\",Company,Person),0),4))","v":""}]
[{"$f":"IF(ISBLANK($L$11),\"\",INDEX(Customers,MATCH($L$11,IF($L$9=\"Company\",Company,Person),0),5)&\", \"&INDEX(Customers,MATCH($L$11,IF($L$9=\"Company\",Company,Person),0),6)&\", \"&INDEX(Customers,MATCH($L$11,IF($L$9=\"Company\",Company,Person),0),7))","v":""},null,null,null,null,null,"Deposit Received"]
[{"$f":"IF(ISBLANK($L$11),\"\",\"Phone: \"&INDEX(Customers,MATCH($L$11,IF($L$9=\"Company\",Company,Person),0),8))","v":""}]
[{"$f":"IF(ISBLANK($L$11),\"\",\"Fax: \"&INDEX(Customers,MATCH($L$11,IF($L$9=\"Company\",Company,Person),0),9))","v":""}]
[{"$f":"IF(ISBLANK($L$11),\"\",\"E-Mail: \"&INDEX(Customers,MATCH($L$11,IF($L$9=\"Company\",Company,Person),0),10))","v":""},null,null,null,null,null,"Total Amount Due",null,{"$f":"IF(SUM(I26:I51)>0,I57-I16,\"\")","v":""}]
[]
[]
["Salesperson",null,"Job",null,"Payment Terms",null,null,"Due Date"]
[null,null,{"$f":"IF(ISBLANK($A$23),\"\",INDEX(Sales_Rep,MATCH($A$23,Sales_Rep_Name,0),2))","v":""},null,{"$f":"IF(ISBLANK($L$11),\"\",\"Due within  \"&INDEX(Customers,MATCH($L$11,IF($L$9=\"Company\",Company,Person),0),12)&\" days from receipt.\")","v":""},null,null,{"$f":"IF(ISBLANK($L$11),\"\",I10+INDEX(Customers,MATCH($L$11,IF($L$9=\"Company\",Company,Person),0),12))","v":""}]
[]
["Qty","Description",null,null,null,null,null,"Unit Price","Line Total"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(A26)>0,SUM(A26*H26),\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(A27)>0,SUM(A27*H27),\"\")","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"IF(SUM(I25:I51)>0,SUM(I25:I51),\"\")","v":""}]
[null,null,null,null,null,null,null,"Tax Rate",{"$f":"IF(ISBLANK($L$11),\"\",INDEX(Customers,MATCH($L$11,IF($L$9=\"Company\",Company,Person),0),11))","v":""}]
[{"$f":"IF(Settings!C30=\"Yes\",Settings!B39,\"\")","v":"Bank Name"},{"$f":"IF(Settings!C30=\"Yes\",Settings!C39,\"\")","v":"Your Bank Name"},null,{"$f":"IF(Settings!C30=\"Yes\",Settings!B34,\"\")","v":"Company Reg. #"},null,{"$f":"IF(Settings!C30=\"Yes\",Settings!C34,\"\")","v":123456},null,"Tax",{"$f":"IF(SUM(I25:I51)>0,SUM(I52*I53),\"\")","v":""}]
[{"$f":"IF(Settings!C30=\"Yes\",Settings!B40,\"\")","v":"Account #"},{"$f":"IF(Settings!C30=\"Yes\",Settings!C40,\"\")","v":"00000000"},null,{"$f":"IF(Settings!C30=\"Yes\",Settings!B35,\"\")","v":"Sales Tax ID"},null,{"$f":"IF(Settings!C30=\"Yes\",Settings!C35,\"\")","v":123456}]
[{"$f":"IF(Settings!C30=\"Yes\",Settings!B41,\"\")","v":"Routing/Sort Code #"},{"$f":"IF(Settings!C30=\"Yes\",Settings!C41,\"\")","v":"12-34-56"}]
[null,null,null,null,null,null,null,"Total",{"$f":"IF(SUM(I26:I51)>0,SUM(I52+I54-I55),\"\")","v":""}]
[]
[{"$f":"\"Make all checks payable to \"&+A10","v":"Make all checks payable to Company Name"}]
[]
["Thank you for your business!"]
[]
[{"$f":"IF(ISBLANK($A$23),\"\",\"If you have any questions concerning this invoice, contact \"&+A23&\" Ext.\"&INDEX(Sales_Rep,MATCH($A$23,Sales_Rep_Name,0),3))","v":""}]
[{"$f":"Settings!C10&\", \"&IF(ISBLANK(Settings!C11),\"\",Settings!C11&\", \")&Settings!C12&\", \"&Settings!C13&\", \"&Settings!C14","v":"111, Street, Town/City, Country, ST"}]
[{"$f":"\"Phone: \"&Settings!C15&\", Fax: \"&Settings!C18&\", E-Mail: \"&Settings!C19&\", Web Site: \"&Settings!C20","v":"Phone: 00000, Fax: 0-000-000-0000, E-Mail: info@yourcompanysite.com, Web Site: www.yourcompanysite.com"}]

{"sheet":"template - Service Invoice","index":12,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":true,"merged":[[9,0,9,3],[9,7,9,10],[5,9,5,10],[0,0,0,3],[3,0,3,3],[3,9,3,10],[4,0,4,3],[4,9,4,10],[6,9,6,10],[7,9,7,10],[18,0,18,8],[18,9,18,10],[10,0,10,3],[10,7,10,10],[11,0,11,3],[11,7,11,10],[17,0,17,8],[17,9,17,10],[15,0,15,3],[15,7,15,10],[12,0,12,3],[12,7,12,10],[14,0,14,3],[14,7,14,10],[13,0,13,3],[13,7,13,10],[19,0,19,8],[19,9,19,10],[20,0,20,8],[20,9,20,10],[22,0,22,8],[22,9,22,10],[21,0,21,8],[21,9,21,10],[23,0,23,8],[23,9,23,10],[25,0,25,8],[25,9,25,10],[24,0,24,8],[24,9,24,10],[33,0,33,8],[33,9,33,10],[26,0,26,8],[26,9,26,10],[27,0,27,8],[27,9,27,10],[28,0,28,8],[28,9,28,10],[31,0,31,8],[31,9,31,10],[32,0,32,8],[32,9,32,10],[29,0,29,8],[29,9,29,10],[30,0,30,8],[30,9,30,10],[35,0,35,6],[36,0,40,6],[49,0,49,10],[46,0,46,10],[47,0,47,10],[48,0,48,10],[10,15,10,18],[4,15,4,18],[5,15,5,18],[6,15,6,18],[7,15,7,18],[8,15,8,18],[9,15,9,18]]}
[{"$f":"_companyName","v":"Company Name"},null,null,null,null,null,null,null,null,null,"INVOICE"]
[{"$f":"_companySlogan","v":"Company Slogan"}]
[]
[null,null,null,null,null,null,null,"Date:",null,{"$f":"_invoiceDate","v":"2017-03-26"}]
[null,null,null,null,null,null,null,"Invoice #:",null,{"$f":"_newInvoice","v":1}]
[null,null,null,null,null,null,null,"Customer ID:",null,{"$f":"rngCustID","v":""}]
[null,null,null,null,null,null,null,"Work Order #",null,{"$f":"_purchaseOrder","v":""}]
[null,null,null,null,null,null,null,"Payment Due by:",null,{"$f":"_invoiceDueDate","v":""}]
[]
["Bill To:"]
[{"$f":"rngCustName","v":""}]
[{"$f":"address_line1","v":""}]
[{"$f":"address_line2","v":""}]
[{"$f":"phone","v":""}]
[{"$f":"fax","v":""}]
[{"$f":"email","v":""}]
[]
["Description",null,null,null,null,null,null,null,null,"Line Total"]
["Printing and Binding (160*$1.75/each)",null,null,null,null,null,null,null,null,{"$f":"160*1.75","v":280}]
["A4 Printing Paper (10*$15.20/5*500 Sheets)",null,null,null,null,null,null,null,null,{"$f":"10*15.2","v":152}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Special Notes and Instructions",null,null,null,null,null,null,null,"Subtotal",{"$f":"IF(ISBLANK($K36),\"\",Settings!$C$26)","v":"$"},{"$f":"SUM($J$19:$J$34)","v":432}]
[{"$f":"IF(ISBLANK(Home!$F$33),\"\",Home!$F$33)","v":""},null,null,null,null,null,null,null,{"$f":"\"Discount \"&TEXT(_dicount,\"0%\")","v":"Discount 10%"},{"$f":"IF(ISBLANK($K37),\"\",Settings!$C$26)","v":"$"},{"$f":"Home!F31*K36","v":43.2}]
[null,null,null,null,null,null,null,null,{"$f":"Settings!$C$24&\" Rate\"","v":"Sales Tax Rate"},"%",{"$f":"_taxRate*100","v":20}]
[null,null,null,null,null,null,null,null,{"$f":"Settings!$C$24","v":"Sales Tax"},{"$f":"IF(ISBLANK($K39),\"\",Settings!$C$26)","v":"$"},{"$f":"IF(K36>0,(K36-rngDiscount)*(K38/100),0)","v":77.760000000000005}]
[null,null,null,null,null,null,null,null,"Total",{"$f":"IF(ISBLANK($K40),\"\",Settings!$C$26)","v":"$"},{"$f":"SUM($K$36-$K$37,$K$39)","v":466.56}]
[]
[]
[{"$f":"\"Make all checks payable to \"&Settings!C5","v":"Make all checks payable to Company Name"},null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$39&\": \"&Settings!$C$39,\"\")","v":"Bank Name: Your Bank Name"}]
["Thank you for your business!",null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$40&Settings!$C$40,\"\")","v":"Account #00000000"}]
[null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$41&Settings!$C$41,\"\")","v":"Routing/Sort Code #12-34-56"}]
[]
[{"$f":"IF(ISBLANK(Home!$F$6),\"\",\"Should you have any enquiries concerning this invoice, please contact \"&Home!$F$6&\" on \"&Settings!$C$17&IF(ISBLANK(INDEX(Sales_Rep,MATCH(Home!$F$6,Sales_Rep_Name,0),6)),\"\",\", ext.\"&INDEX(Sales_Rep,MATCH(Home!$F$6,Sales_Rep_Name,0),6)))","v":{"$error":"#N/A"}}]
[]
[{"$f":"Settings!C10&\", \"&IF(ISBLANK(Settings!C11),\"\",Settings!C11&\", \")&Settings!C12&\", \"&Settings!C14&\", \"&Settings!C15&\", \"&Settings!C13&IF(Company_Reg=\"Yes\",\", \"&Settings!B34&Settings!$C$34&\", \"&Settings!B35&Settings!C35,\"\")","v":"111, Street, Town/City, ST, 00000, Country, Company Reg. #123456, Sales Tax ID123456"}]
[{"$f":"\"Phone: \"&Settings!$C$17&\", Fax: \"&Settings!$C$18&\", E-Mail: \"&Settings!$C$19&\", Web: \"&Settings!$C$20","v":"Phone: 0-000-000-0000, Fax: 0-000-000-0000, E-Mail: info@yourcompanysite.com, Web: www.yourcompanysite.com"}]

{"sheet":"template - Service Hourly","index":13,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":true,"merged":[[50,0,50,11],[48,0,48,11],[49,0,49,11],[38,0,42,7],[33,0,33,7],[34,0,34,7],[37,0,37,7],[35,0,35,7],[33,10,33,11],[39,14,39,17],[38,14,38,17],[34,10,34,11],[35,10,35,11],[0,0,0,3],[4,0,4,2],[12,0,12,3],[9,0,9,3],[10,0,10,3],[10,8,10,11],[28,10,28,11],[29,10,29,11],[32,10,32,11],[31,10,31,11],[30,10,30,11],[28,0,28,7],[3,0,3,2],[11,0,11,3],[13,8,13,11],[5,8,5,9],[9,8,9,11],[12,8,12,11],[6,10,6,11],[6,8,6,9],[7,10,7,11],[3,10,3,11],[4,10,4,11],[5,10,5,11],[11,8,11,11],[3,8,3,9],[4,8,4,9],[27,10,27,11],[26,10,26,11],[20,10,20,11],[25,10,25,11],[24,10,24,11],[22,10,22,11],[23,10,23,11],[21,10,21,11],[17,0,17,7],[13,0,13,3],[23,0,23,7],[7,8,7,9],[14,0,14,3],[15,0,15,3],[15,8,15,11],[18,10,18,11],[17,10,17,11],[19,10,19,11],[14,8,14,11],[30,0,30,7],[31,0,31,7],[32,0,32,7],[18,0,18,7],[19,0,19,7],[20,0,20,7],[21,0,21,7],[27,0,27,7],[26,0,26,7],[22,0,22,7],[24,0,24,7],[25,0,25,7],[29,0,29,7]]}
[{"$f":"_companyName","v":"Company Name"},null,null,null,null,null,null,null,null,null,null,"INVOICE"]
[{"$f":"_companySlogan","v":"Company Slogan"}]
[]
[null,null,null,null,null,null,null,null,"Date:",null,{"$f":"_invoiceDate","v":"2017-03-26"}]
[null,null,null,null,null,null,null,null,"Invoice #:",null,{"$f":"_newInvoice","v":1}]
[null,null,null,null,null,null,null,null,"Customer ID:",null,{"$f":"rngCustID","v":""}]
[null,null,null,null,null,null,null,null,"Purchase Order #",null,{"$f":"_purchaseOrder","v":""}]
[null,null,null,null,null,null,null,null,"Payment Due by:",null,{"$f":"_invoiceDueDate","v":""}]
[]
["Bill To:"]
[{"$f":"rngCustName","v":""}]
[{"$f":"address_line1","v":""}]
[{"$f":"address_line2","v":""}]
[{"$f":"phone","v":""}]
[{"$f":"fax","v":""}]
[{"$f":"email","v":""}]
[]
["Description",null,null,null,null,null,null,null,"Hours","Unit Price","Line Total"]
["Traning Fee",null,null,null,null,null,null,null,5.75,150,{"$f":"IF(OR(ISBLANK($I19),$I19=0),0,$I19*$J19)","v":862.5}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK($I20),$I20=0),0,$I20*$J20)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[]
["Special Notes and Instructions",null,null,null,null,null,null,null,null,"Subtotal",{"$f":"IF(ISBLANK($J38),\"\",Settings!$C$26)","v":"$"},{"$f":"SUM($K$19:$K$36)","v":862.5}]
[{"$f":"IF(ISBLANK(Home!$F$33),\"\",Home!$F$33)","v":""},null,null,null,null,null,null,null,null,{"$f":"\"Discount \"&TEXT(_dicount,\"0%\")","v":"Discount 10%"},{"$f":"IF(ISBLANK($J39),\"\",Settings!$C$26)","v":"$"},{"$f":"Home!F31*L38","v":86.25}]
[null,null,null,null,null,null,null,null,null,{"$f":"Settings!$C$24&\" Rate\"","v":"Sales Tax Rate"},"%",{"$f":"_taxRate*100","v":20}]
[null,null,null,null,null,null,null,null,null,{"$f":"Settings!$C$24","v":"Sales Tax"},{"$f":"IF(ISBLANK($J41),\"\",Settings!$C$26)","v":"$"},{"$f":"IF(L38>0,(L38-rngDiscount)*(L40/100),0)","v":155.25}]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"IF(ISBLANK($J42),\"\",Settings!$C$26)","v":"$"},{"$f":"SUM($L$38-$L$39,$L$41,$N$41)","v":931.5}]
[]
[]
[{"$f":"\"Make all checks payable to \"&Settings!C5","v":"Make all checks payable to Company Name"},null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$39&\": \"&Settings!$C$39,\"\")","v":"Bank Name: Your Bank Name"}]
["Thank you for your business!",null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$40&Settings!$C$40,\"\")","v":"Account #00000000"}]
[null,null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$41&Settings!$C$41,\"\")","v":"Routing/Sort Code #12-34-56"}]
[]
[{"$f":"IF(ISBLANK(Home!$F$6),\"\",\"Should you have any enquiries concerning this invoice, please contact \"&Home!$F$6&\" on \"&Settings!$C$17&IF(ISBLANK(INDEX(Sales_Rep,MATCH(Home!$F$6,Sales_Rep_Name,0),6)),\"\",\", ext.\"&INDEX(Sales_Rep,MATCH(Home!$F$6,Sales_Rep_Name,0),6)))","v":{"$error":"#N/A"}}]
[{"$f":"Settings!C10&\", \"&IF(ISBLANK(Settings!C11),\"\",Settings!C11&\", \")&Settings!C12&\", \"&Settings!C14&\", \"&Settings!C15&\", \"&Settings!C13&IF(Company_Reg=\"Yes\",\", \"&Settings!B34&Settings!$C$34&\", \"&Settings!B35&Settings!C35,\"\")","v":"111, Street, Town/City, ST, 00000, Country, Company Reg. #123456, Sales Tax ID123456"}]
[{"$f":"\"Phone: \"&Settings!$C$17&\", Fax: \"&Settings!$C$18&\", E-Mail: \"&Settings!$C$19&\", Web: \"&Settings!$C$20","v":"Phone: 0-000-000-0000, Fax: 0-000-000-0000, E-Mail: info@yourcompanysite.com, Web: www.yourcompanysite.com"}]

{"sheet":"template - Serv. Hourly op. Tax","index":14,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":true,"merged":[[29,0,29,6],[30,0,30,6],[31,0,31,6],[32,0,32,6],[20,0,20,6],[21,0,21,6],[27,0,27,6],[28,0,28,6],[22,0,22,6],[23,0,23,6],[7,10,7,11],[6,10,6,11],[6,7,6,8],[7,7,7,8],[26,0,26,6],[24,0,24,6],[25,0,25,6],[14,0,14,3],[15,0,15,3],[18,0,18,6],[19,0,19,6],[10,7,10,11],[18,10,18,11],[17,10,17,11],[19,10,19,11],[27,10,27,11],[26,10,26,11],[20,10,20,11],[23,10,23,11],[22,10,22,11],[24,10,24,11],[25,10,25,11],[21,10,21,11],[3,10,3,11],[4,10,4,11],[5,10,5,11],[17,0,17,6],[13,0,13,3],[3,7,3,8],[4,7,4,8],[3,0,3,2],[11,0,11,3],[13,7,13,11],[5,7,5,8],[9,7,9,11],[15,7,15,11],[14,7,14,11],[11,7,11,11],[12,7,12,11],[0,0,0,3],[4,0,4,2],[12,0,12,3],[9,0,9,3],[10,0,10,3],[39,14,39,17],[38,14,38,17],[34,10,34,11],[35,10,35,11],[37,0,37,6],[35,0,35,6],[33,10,33,11],[50,0,50,11],[48,0,48,11],[49,0,49,11],[38,0,42,6],[33,0,33,6],[34,0,34,6],[28,10,28,11],[29,10,29,11],[32,10,32,11],[31,10,31,11],[30,10,30,11]]}
[{"$f":"_companyName","v":"Company Name"},null,null,null,null,null,null,null,null,null,null,"INVOICE"]
[{"$f":"_companySlogan","v":"Company Slogan"}]
[]
[null,null,null,null,null,null,null,"Date:",null,null,{"$f":"_invoiceDate","v":"2017-03-26"}]
[null,null,null,null,null,null,null,"Invoice #:",null,null,{"$f":"_newInvoice","v":1}]
[null,null,null,null,null,null,null,"Customer ID:",null,null,{"$f":"rngCustID","v":""}]
[null,null,null,null,null,null,null,"Purchase Order #",null,null,{"$f":"_purchaseOrder","v":""}]
[null,null,null,null,null,null,null,"Payment Due by:",null,null,{"$f":"_invoiceDueDate","v":""}]
[]
["Bill To:"]
[{"$f":"rngCustName","v":""}]
[{"$f":"address_line1","v":""}]
[{"$f":"address_line2","v":""}]
[{"$f":"phone","v":""}]
[{"$f":"fax","v":""}]
[{"$f":"email","v":""}]
[]
["Description",null,null,null,null,null,null,"Hours","Unit Price","Tax","Line Total"]
["Traning Fee",null,null,null,null,null,null,15,150,"x",{"$f":"IF(OR(ISBLANK($H19),$H19=0),0,$H19*$I19)","v":2250}]
["Health $ Safety Workshop",null,null,null,null,null,null,2,250,null,500]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[]
["Special Notes and Instructions",null,null,null,null,null,null,null,"Subtotal",null,{"$f":"IF(ISBLANK($I38),\"\",Settings!$C$26)","v":"$"},{"$f":"SUM($K$19:$K$36)","v":2750}]
[{"$f":"IF(ISBLANK(Home!$F$33),\"\",Home!$F$33)","v":""},null,null,null,null,null,null,null,{"$f":"\"Discount \"&TEXT(_dicount,\"0%\")","v":"Discount 10%"},null,{"$f":"IF(ISBLANK($I39),\"\",Settings!$C$26)","v":"$"},{"$f":"Home!F31*L38","v":275}]
[null,null,null,null,null,null,null,null,"Taxable",null,{"$f":"IF(ISBLANK($I40),\"\",Settings!$C$26)","v":"$"},{"$f":"SUMIF(J19:J36,\"x\",K19:K36)","v":2250}]
[null,null,null,null,null,null,null,null,{"$f":"Settings!$C$24&\" Rate\"","v":"Sales Tax Rate"},null,"%",{"$f":"_taxRate*100","v":20}]
[null,null,null,null,null,null,null,null,{"$f":"Settings!$C$24","v":"Sales Tax"},null,{"$f":"IF(ISBLANK($I42),\"\",Settings!$C$26)","v":"$"},{"$f":"IF(L40>0,L40*(L41/100),0)","v":450}]
[null,null,null,null,null,null,null,null,"Total",null,{"$f":"IF(ISBLANK($I43),\"\",Settings!$C$26)","v":"$"},{"$f":"SUM($L$38-$L$39,$L$42)","v":2925}]
[]
[{"$f":"\"Make all checks payable to \"&Settings!C5","v":"Make all checks payable to Company Name"},null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$39&\": \"&Settings!$C$39,\"\")","v":"Bank Name: Your Bank Name"}]
["Thank you for your business!",null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$40&Settings!$C$40,\"\")","v":"Account #00000000"}]
[null,null,null,null,null,null,{"$f":"IF(Company_Reg=\"Yes\",Settings!$B$41&Settings!$C$41,\"\")","v":"Routing/Sort Code #12-34-56"}]
[]
[{"$f":"IF(ISBLANK(Home!$F$6),\"\",\"Should you have any enquiries concerning this invoice, please contact \"&Home!$F$6&\" on \"&Settings!$C$17&IF(ISBLANK(INDEX(Sales_Rep,MATCH(Home!$F$6,Sales_Rep_Name,0),6)),\"\",\", ext.\"&INDEX(Sales_Rep,MATCH(Home!$F$6,Sales_Rep_Name,0),6)))","v":{"$error":"#N/A"}}]
[{"$f":"Settings!C10&\", \"&IF(ISBLANK(Settings!C11),\"\",Settings!C11&\", \")&Settings!C12&\", \"&Settings!C14&\", \"&Settings!C15&\", \"&Settings!C13&IF(Company_Reg=\"Yes\",\", \"&Settings!B34&Settings!$C$34&\", \"&Settings!B35&Settings!C35,\"\")","v":"111, Street, Town/City, ST, 00000, Country, Company Reg. #123456, Sales Tax ID123456"}]
[{"$f":"\"Phone: \"&Settings!$C$17&\", Fax: \"&Settings!$C$18&\", E-Mail: \"&Settings!$C$19&\", Web: \"&Settings!$C$20","v":"Phone: 0-000-000-0000, Fax: 0-000-000-0000, E-Mail: info@yourcompanysite.com, Web: www.yourcompanysite.com"}]

{"sheet":"Price List","index":15,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}
["Price List"]
[]
["Catalog #","Description","Unit Price"]
["A223311","Product 1",5]
["11Z2233","Product 2",7]
[331122,"Product 3",1.85]
[332211,"Product 4",2.25]
[112233,"Product 5",9]
[113322,"Product 6",5.6]
[221133,"Product 7",5.7]
[333333,"Product 8",12]
[222222,"Product 9",22]
[111111,"Product 10",8]
[445566,"Product 11",1.25]
[554466,"Product 12",1.25]
[664455,"Product 13",3.35]
[665544,"Product 14",4.5]
[446655,"Product 15",1.4]
[556644,"Product 16",1.8]
[444444,"Product 17",32]
[555555,"Product 18",35]
[225544,"Product 19",12]
[551133,"Product 20",21]

{"sheet":"Settings","index":16,"n_rows":81,"n_cols":9,"rows_kept":81,"cut":false,"hidden":true,"merged":[[2,0,2,6],[7,0,7,6],[31,1,31,5],[36,1,36,5],[21,0,21,6],[27,0,27,6],[6,1,6,4],[5,2,5,3],[4,2,4,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[17,2,17,3],[12,4,12,5],[13,2,13,3],[76,0,76,6],[80,4,80,5],[80,0,80,1],[19,2,19,3],[39,2,39,3],[38,2,38,3],[13,4,13,5],[18,2,18,3],[16,2,16,3],[87,4,87,5],[46,0,46,6],[63,0,63,6],[86,4,86,5],[40,2,40,3],[85,4,85,5],[50,0,50,6],[42,0,42,6],[44,2,44,3],[84,4,84,5],[83,4,83,5],[14,2,14,3],[82,4,82,5]]}
[null,"Settings"]
[]
["Company Information"]
[]
[null,"Company Name","Company Name",null,null,"Enable"]
[null,"Company Slogan (Optional)","Company Slogan",null,null,"Enable"]
[]
["Company Address"]
[]
[null,"Building/House Number",111]
[null,"Street","Street"]
[null,"Town/City","Town/City"]
[null,"County/Province","Country",null,"Optional"]
[null,"State/Province","ST",null,"Optional"]
[null,"ZIP/Postal Code","00000"]
[]
[null,"Tel.","0-000-000-0000"]
[null,"Fax","0-000-000-0000"]
[null,"E-mail","info@yourcompanysite.com"]
[null,"Website","www.yourcompanysite.com"]
[]
["Country Specific Settings"]
[]
[null,"Select Relevant","Sales Tax"]
[null,{"$f":"C24&\" Rate\"","v":"Sales Tax Rate"},0.2]
[null,"Currency Symbol","$"]
[]
["Company Registration and Bank Account Information"]
[]
[null,"Display on the invoice","Yes"]
[]
[null,"Company Registration Info"]
[]
[null,"Company Reg. #",123456]
[null,{"$f":"C24&\" ID\"","v":"Sales Tax ID"},123456]
[]
[null,"Company Bank Account Info"]
[]
[null,"Bank Name","Your Bank Name"]
[null,"Account #","00000000"]
[null,"Routing/Sort Code #","12-34-56"]
[]
["Invoice archive directory"]
[]
[null,"Archive Directory Name","My Invoices"]
[]
["Customer ID Settings"]
[]
[null,"Customer ID Format","AA-00000"]
[]
["Payment Terms"]
[]
[null,"Due upon completion",0]
[null,"Due upon delivery",0]
[null,"Due upon receipt",0]
[null,"15 days",15,"days from the invoice date "]
[null,"28 days",28,"days from the invoice date "]
[null,"30 days",30,"days from the invoice date "]
[null,"60 days",60,"days from the invoice date "]
[]
[]
[]
[]
["Invoice Status"]
[]
[null,"Invoice Created","Draft"]
[null,"Invoice Sent","In Progress"]
[null,"Invoice Partially Paid","With Balance"]
[null,"Invoice Paid","Paid"]
[null,"Invoice Closed","Closed"]
[]
[]
[]
[]
[]
[]
["Admin Login"]
[]
[null,"Default Password",1234]
[]
["Sales Rep. Name",null,"ID","Password","Position",null,"Phone Ext.","Role",{"$f":"IF(ISERROR(MATCH(\"Admin\", H83:$H183, 0)), FALSE, TRUE)","v":false}]

{"sheet":"HELP","index":17,"n_rows":330,"n_cols":8,"rows_kept":330,"cut":false,"hidden":true,"merged":[[287,0,287,10],[172,0,172,10],[316,2,316,7],[325,3,325,4],[236,0,236,10],[253,0,253,10],[280,0,280,10],[320,1,320,2],[324,1,324,2],[299,3,299,7],[143,0,143,10],[82,0,82,10],[24,0,24,10],[26,0,26,10],[328,3,328,4],[55,0,55,10],[98,0,98,10],[105,0,105,10],[127,0,127,10],[58,0,58,10],[27,0,27,10],[112,0,112,10],[184,0,184,10],[158,0,158,10],[296,2,296,7],[301,2,301,7],[329,3,329,4],[327,1,327,2],[328,1,328,2],[318,7,329,9],[329,1,329,2],[324,3,324,4],[327,3,327,4],[325,1,325,2],[326,1,326,2],[326,3,326,4],[2,1,2,9],[3,1,3,9],[19,0,19,10],[21,0,21,10],[22,0,22,10],[4,2,4,9],[5,2,5,9],[6,2,6,9],[7,2,7,9],[8,2,8,9],[9,2,9,9],[10,2,10,9],[11,1,11,9],[12,1,12,9],[13,1,13,9]]}
["Invoice Manager Pro V-1.0.0 - HELP"]
[]
[null,"1. How to begin using Invoice Manager Pro V-1.0.0 for the first time"]
[null,"2. General settings, what can I change?"]
[null,2.1,"Company Information and Country Specific Settings"]
[null,2.2000000000000002,"Invoice Archive Directory"]
[null,2.2999999999999998,"Customer ID Settings"]
[null,2.4,"Payment Terms"]
[null,2.5,"Invoice Status"]
[null,2.6,"Admin/User Login Credentials"]
[null,2.7,"How can I Insert my company logo?"]
[null,"3. Creating your first invoice"]
[null,"4. How can I continue using software after the trial period has ended?"]
[null,"5. How can I add my own invoice template to the software?"]
[]
[]
[]
["1. How to begin using Invoice Manager Pro V-1.0.0 for the first time"]
[]
["When you download the trial version of Invoice Manager Pro V-1.0.0 and open it for the first time, you will be prompted with warning to inform you, that this spreadsheet uses macros, you will need to click Enable Macros button to be able to use the software."]
[]
["Once macros is enabled, you should see the simple user form on your screen, that gives you several options and awaits for some action, which we will \nexplain step-by-step here."]
["The following image shows the screen that you will be presented with, where you can make you choices, such as proceed to purchase license, enter the \nlicense key, Later button, to proceed to the trial version of the software or Exit button to exit software entirely, if you do not want to use it at this time. You will also see the message, which informs you of the amount of time you have left for use your trial version. The trial version will let you to fully test drive the software without any limitation for 31 days, beginning from the day when you first open it on your computer. "]
[]
["Click Later button to proceed to the next step in which you will be prompted to create your Administrative User. The administrative privileges differ from \nregular user privileges, for your own security reasons, so that the only user with administrative privileges can change all settings of the software as well as create regular users or add new invoice templates into the existing software."]
[]
["At this stage, you will not be asked to create password for your administrative user, once user ID is created, the default password 1234 is automatically \nassigned to a newly created user, which can be changed at any time and by any user, using his/her default password. It all works in the very usual way, prior to making any changes to the password, user is prompted to enter their existing password first and then make any changes. Users with regular privileges, will not be able to see passwords of any other user, which adds an additional level of security to the software, this is different for user with administrative rights. The information box will appear to inform you that the Admin info has been successfully added, click OK to proceed further."]
["After clicking OK, you will be taken to the Home tab of the software, where you can see the details of the logged in user. The Home tab is place, from where you can run most of the operations, such as adding new users, adding customers and creating your invoices, but before you begin, you would need to proceed to the Settings tab, to change or update your settings."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2. General settings, what can I change?"]
[]
["The Settings tab is only available to the user with administrative privileges, this adds additional layer of security and ensures that no other user is going to be able to change any or all of the critical settings including user names or passwords."]
[]
["2.1 Company Information and Country Specific Settings"]
["Changing settings that control information displayed on the invoices is actually pretty easy, you can also control what you need to display and what's not. Enter the information in the fields as shown by replacing the current values of the cells with your own. Some cells are optional as indicated and some can be enabled or disabled.\nMaking changes to the country specific settings, helps to customize the invoice templates and the software to your country, meaning that you can have relevant currency symbol, which is displayed across all the invoice templates or change the name of the Sales Tax to VAT (applicable to European Countries) as well as set Sales Tax/VAT rate. The Sales Tax/VAT rate can also be changed on the home page at any time, when creating new invoice."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Displaying company registration, Sales tax ID/VAT and company bank account details on every invoice is legally required by some countries, but for some it is not. If displaying the above mentioned information is required in your country, select Yes, then update information in the rest of the cells with your own information."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2.2 Invoice Archive Directory"]
["The software will automatically create an archive directory with the name \"My Invoices\" to store the invoices, which you will be creating. You can specify different name for your archive directory, by replacing the current name with your own. You would need to do this prior to creating invoices or if directory My Invoices has been created already and it contains invoices, you would also have to rename the directory with new name, otherwise the software will create new directory, but all existing invoices will remain inside the old directory, which will result in errors when you try to update the information on your Sales report."]
[]
[]
[]
[]
[]
["2.3 Customer ID Settings"]
["The allowed format is two letters, hyphen and five numbers a.e AA-00000, this will give you an option to have plenty of customers in your customers data base. You can change the letters and numbers as you need as long as you are keeping the same format."]
[]
[]
[]
[]
[]
["2.4 Payment Terms"]
["We already created some payment terms, but if you need to add more or amend exiting terms, you are able to do so following the same principal. You can assign a default payment terms to every customer in your database, but you can always change the default terms, when creating new invoice to any other then default terms."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2.5 Invoice Status"]
["The invoice status information can also be changed upon your requirements. Using status helps to indicate the current status of your invoice. As an example, if your invoice is created but not yet sent, the status of your invoice, on the Sales tab, is set to Draft by default. You should change the status to In Progress, once invoice is sent. Same rule will apply, when you receive payments on your invoices, you would need to change the status accordingly."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2.6 Admin/User Login Credentials"]
["The default password that you need use to access the software for the first time is 1234, which you can change at any time. The same password is automatically assigned to every new user added to the software. Both, user with administrative and regular rights can change their own password, when necessary. User with regular rights are not able to see passwords of any other users, only administrator has this privileges. Also, only administrator can change the user names, when required to do so. Administrator can change the default password to any combination of digits and letters using both upper and lower case letters, with one exception, default password should never be 0000, because Excel will automatically transform to a single 0 and this is simply is not a good practice to have in place."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Phone Extension"]
["Some organizations may use phone extensions appointed to different departments and/or users, therefore, we have also included this in to the software on the new user form as mandatory field. Phone extensions are also displayed at the bottom part of every invoice, when available. Unless of course this is something that you rather not use in your organization, you, as administrative user can always delete any and every phone extension from the form."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2.7 How can I Insert my company logo?"]
[]
["You can add your own company logo to every invoice template within the software. To do this, you need to have your logo image file. Before inserting your logo, you should remove the logo place holder, which you can view every invoice template. Click on the place holder image and hit Delete button on your keyboard. Once deleted, click on the INSERT tab in the ribbon, then click on the picture icon, in the window that opens, find and select your image then click Insert button at the bottom right corner. You have to repeat the same procedure on every invoice template, where you want your company logo inserted. To change position of the image, simply click on it and drag the image to any place, where it needs to be. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3. Creating your first invoice"]
[]
["Creating your first invoice isn't hard, but before you begin, you need to create new customer by adding customer details to your database. On the Home tab, click Add New Customer button. In the New Customer Details form that opens, enter the details of your customer and click the Add button. All fields of the form are mandatory. Your customer ID is assigned automatically to every customer, that you add to the list and will be displayed on every invoice. Also, don't forget to assign the default Payment Terms to you new customer, which you can change every time, when you create new invoice."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Once your customers list contains details of at least one customer, you are ready to proceed further to create your first invoice. You can select your customer using two different approaches by selecting a Person or a Company in the drop down menu of the \"Customer is\" cell. In the next cell, you will be presented with either names of your customers to select from or the names of the companies on your list, all depends upon the selection made in the step above. When customer is selected, the cells containing Billing Address, Customer ID, Payment Terms and the Due Date are automatically updated with information of the customer, that you have selected. You can now change the payment terms from default to any other, available payment terms in the drop down list. Here you can also enter Purchase order number, add service and handling fee, add total purchase discount or even enter the alternative shipping address, when required to do so. Do not worry about deleting the information entered into these cells, it is being deleted automatically, once invoice is created. When customer and invoice information is updated, click on Create New Invoice button. You will be presented with few options to select from, where you can make a simple choice and select the invoice template that you would want to use, then click on the Add button."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["If the directory for storing your invoice has not yet been created, the software will prompt you to create the directory. When this has been accomplished, the software will issue the notice, to inform you of the location of the new directory."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["When invoice is created, it opens up immediately, so that you can update it with all the rest of the details, such as your products and services and prices for those as usual. When you are ready, save and close your invoice, then go back to your Sales tab, place your cursor in the column Refresh Data right beside the invoice you want to refresh then click on the refresh button that appears within the cell. You will see that the cells that were empty before, will now contain data copied from your newly created invoice. You can follow the same procedure, when you amend any information on any of your invoices, just be sure to refresh the data every time you do so.  If payment is overdue, the cell in the column Overdue will inform you of this and will also display the exact number of days by which the payment is overdue. Once your invoice is sent, you must change the status from Draft to In Progress, so that you know that invoice is awaiting payment. You should change status every time you receive full or partial payment accordingly. When invoice is paid and payment was successfully received than you should change the status to closed. Column Total Paid holds information about the amounts paid, when Outstanding Balance column will display the amount that is left to pay by the customer if any."]
[]
[]
[]
[]
["4. How can I continue using software after the trial period has ended?"]
[]
["To continue using this software after the trial period is over, you would have to purchase the product key. The product key can be obtained from Spreadsheet123.com, by clicking on the purchase button below, but before you do so, you need to know that this software is licensed only to one computer. After making a purchase, you will download an Excel file (Invoice Manager Pro - Product Code), which will guide you through the process of generating the unique product key for your software."]
[]
[null,null,null,null,null,null,"Email Your User Name to:"]
[null,null,null,null,null,null,"support@spreadsheet123.com"]
[]
[]
["5. How can I add my own invoice template to the software?"]
[]
[]
[null,null,"HOW TO ADD NEW INVOICE TEMPLATE TO THE EXISTING TOOL"]
[null,null,null,"FROM EXCEL","MOVE/COPY INVOICE SHEET TO EXISTING TOOL"]
[null,null,null,"FROM OTHER","INSERT NEW SHEET AND COPY CONTENT HERE"]
[null,null,null,"After all formulas and name ranges are created, the last step is to re-name the template in this format               template - Anyname"]
[]
[null,null,"*MANDATORY NAME RANGES/INFORMATION TO INSERT TO THE NEW TEMPLATE SHEET"]
[null,null,null,"*Name ranges should be sheet specific"]
[null,null,null,"For the cell:","Name it as:","Enter Formula: equals to"]
[null,null,"*","Invoice Date","Sheet1!rngInvoiceDate","_invoiceDate"]
[null,null,"*","Invoice Number",null,"_newInvoice"]
[null,null,"*","Customer/Company Name","Sheet1!rngCompanyName","rngCustName"]
[null,null,"*","Sub Total","Sheet1!rngSubTotal","(sum formula: refer to other templates)"]
[null,null,null,"Sales Tax Rate",null,"_taxRate*100"]
[null,null,null,"Sales Tax","Sheet1!rngSalesTax","subtotal * (Salestax rate/100)"]
[null,null,null,"Service & Handling","Sheet1!rngSH","_service_handl"]
[null,null,null,"Discount","Sheet1!rngDiscount","_dicount"]
[null,null,"*","Total","Sheet1!rngTotal","(sum formula: refer to other templates)"]
[null,null,"*","Due Date","Sheet1!rngDueDt ","_invoiceDueDate"]
[]
[]
[null,null,"If you select 'YES' for alternate shipping address on Home sheet, Copy paste cells I10:I16 from already built template in the desired cells on the new template. All formulas will be picked up automatically"]
[]
[null,null,"Main information that is needed on the new template",null,null,null,null,"SIGNING OFF INVOICE                                                                                        For the closing information for the new template, simply copy paste cells (A49,A50,A51) last 3 lines from the already built template. Formulas will be picked up automatically                                                                                                                                                                                                                                                                                                                    "]
[null,"Information",null,"Formula equals to:"]
[null,"Your Company Name",null,"_companyName"]
[null,"Company Slogan",null,"_companySlogan"]
[]
[null,"Bill To: Information",null,"Formula Equals to",null,"Range Name"]
[null,"Customer/CompanyName",null,"rngCustName",null,"Sheet1!rngCompanyName"]
[null,"Address Line 1",null,"address_line1"]
[null,"Address Line 2",null,"address_line2"]
[null,"Phone",null,"phone"]
[null,"Fax",null,"fax"]
[null,"Email",null,"email"]

{"sheet":"Users","index":18,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Username","Password","Name","Position","Phone Ext.","Role"]
["AlekoB77","Datuna77","David","Sales Manager","1111","admin",{"$f":"INDEX(_system_log,MATCH(Home!#REF!,_userName,0),2)=Home!#REF!","v":{"$error":"#REF!"}}]
["NinukaB77","alekob77",null,null,null,"user"]

{"sheet":"EULA","index":19,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}