{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Welcome","Temp Admin","ClientsData","ProductsData","DocsData","LinesData","PayData","EmailData","LabelsData","ConfigData","Home","Builder","Agreement","Settings","Clients","Products","Labels","About","Reports"],"not_rendered":{"charts":0,"images":70,"macros":1,"external_links":0,"defined_names":12,"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":"Welcome","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Temp Admin","index":1,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,false]

{"sheet":"ClientsData","index":2,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"ClientID","CompanyName","ContactName","Email","Phone","Addr1","Addr2","City","State","Postal","Country","DefaultTermsDays","Notes","Active","CreatedDate"]

{"sheet":"ProductsData","index":3,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"ProductID","SKU","Category","Description","UnitCost","UnitPrice","DefaultPricingMode","DefaultMarkupValue","Taxable","Active","CreatedDate"]

{"sheet":"DocsData","index":4,"n_rows":10,"n_cols":58,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,"Documents - system data, do not edit"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"DocID","DocType","DocNumber","NumberIsManual","SourceDocID","ClientID","DocDate","DueDate","Status","ShipToSame","ShipToName","ShipToAddr1","ShipToAddr2","ShipToCity","ShipToState","ShipToPostal","ShipToCountry","TaxRate","TaxLabel","DiscountMode","DiscountValue","ShippingAmount","AdjustmentLabel","AdjustmentAmount","Subtotal","DiscountCalc","TaxCalc","GrandTotal","ShowItemName","ShowItemDesc","ShowUnits","ShowPrice","ShowAmount","ItemsLabel","UnitsLabel","PriceLabel","AmountLabel","TermsText","InternalNotes","Locked","RevisionNum","CreatedDate","ModifiedDate","HideDiscount","HideTax","HideShipping","HideAdjustment","MarginMode","BlanketMarginPct","ShippingTaxable","AdjustmentTaxable","ShowLinePrices","SubtotalOverride","ShowSKU"]

{"sheet":"LinesData","index":5,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,"Document lines - system data, do not edit"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"LineID","DocID","LineSeq","ProductID","SKU","Description","Qty","UnitCost","PricingMode","MarkupValue","UnitPrice","Taxable","LineTotal"]

{"sheet":"PayData","index":6,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,"Payments - system data, do not edit"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"PaymentID","DocID","PayDate","Amount","Method","Reference","Notes"]

{"sheet":"EmailData","index":7,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,"Email log - system data, do not edit"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"EmailID","DocID","SentDate","ToAddr","CCAddr","BCCAddr","Subject","TemplateUsed","Method","Status"]
[null,null,null,null,1,165,"2026-07-24T13:10:06",null,null,null,"Quote DEMO-Q-165 from LGPSM 11","Quote","Default email app","Drafted"]
[null,null,null,null,2,999,"2026-07-24T13:10:30","test@test.com",null,null,"diag","Quote","Desktop Outlook","Drafted"]
[null,null,null,null,3,165,"2026-07-24T13:12:42",null,null,null,"Quote DEMO-Q-165 from LGPSM 11","Quote","Desktop Outlook","Drafted"]
[null,null,null,null,4,165,"2026-07-24T13:29:38",null,null,null,"Quote DEMO-Q-165 from LGPSM 11","Quote","Desktop Outlook","Drafted"]
[null,null,null,null,5,165,"2026-07-24T13:30:07",null,null,null,"Quote DEMO-Q-165 from LGPSM 11","Quote","Desktop Outlook","Drafted"]
[null,null,null,null,6,165,"2026-07-24T13:34:53",null,null,null,"Quote DEMO-Q-165 from LGPSM 11","Quote","Desktop Outlook","Drafted"]
[null,null,null,null,7,165,"2026-07-24T13:57:50",null,null,null,"Quote DEMO-Q-165 from LGPSM 11","Quote","Default email app","Drafted"]
[null,null,null,null,8,11,"2026-07-24T15:18:51","sergio@mtnviewcafe.com",null,null,33,"Invoice","Default email app","Drafted"]
[null,null,null,null,9,11,"2026-07-24T15:34:13","sergio@mtnviewcafe.com",null,null,33,"Invoice","Default email app","Drafted"]
[null,null,null,null,10,11,"2026-07-24T15:37:38","sergio@mtnviewcafe.com",null,null,33,"Invoice","Default email app","Drafted"]
[null,null,null,null,11,152,"2026-07-24T15:44:21","lucia@greenfieldscapes.com",null,null,33,"Invoice","Default email app","Drafted"]
[null,null,null,null,12,152,"2026-07-24T15:44:32","lucia@greenfieldscapes.com",null,null,33,"Invoice","Default email app","Drafted"]
[null,null,null,null,13,11,"2026-07-24T15:45:50","sergio@mtnviewcafe.com",null,null,"Reminder: Invoice INV-1002 from LGPSM is overdue","Reminder","Default email app","Drafted"]
[null,null,null,null,14,171,"2026-07-24T15:47:20","yusuf@lakelandoffice.com",null,null,33,"Invoice","Default email app","Drafted"]
[null,null,null,null,15,154,"2026-07-24T15:48:50","jane@email.com",null,null,33,"Invoice","Default email app","Drafted"]
[null,null,null,null,16,154,"2026-07-24T15:49:03","jane@email.com",null,null,33,"Invoice","Default email app","Drafted"]
[null,null,null,null,17,152,"2026-07-24T15:49:30","lucia@greenfieldscapes.com",null,null,33,"Invoice","Default email app","Drafted"]
[null,null,null,null,18,152,"2026-07-24T15:50:34","lucia@greenfieldscapes.com",null,null,"Reminder: Invoice DEMO-INV-152 from LGPSM is overdue","Reminder","Default email app","Drafted"]
[null,null,null,null,19,171,"2026-07-27T11:32:26","yusuf@lakelandoffice.com",null,null,33,"Invoice","Default email app","Drafted"]
[null,null,null,null,20,171,"2026-07-27T11:32:38","yusuf@lakelandoffice.com",null,null,33,"Invoice","Default email app","Drafted"]
[null,null,null,null,21,170,"2026-07-27T11:40:01","tom@harborpointre.com",null,null,33,"Invoice","Desktop Outlook","Drafted"]
[null,null,null,null,22,14,"2026-07-27T13:14:01","priya@sunrisedental.com",null,null,"Reminder: Invoice INV-1005 from LGPSM is overdue","Reminder","Desktop Outlook","Drafted"]
[null,null,null,null,23,152,"2026-07-27T13:15:51","lucia@greenfieldscapes.com",null,null,"Reminder: Invoice DEMO-INV-152 from LGPSM is overdue","Reminder","Desktop Outlook","Drafted"]
[null,null,null,null,24,14,"2026-07-27T15:05:34","priya@sunrisedental.com",null,null,"Reminder: Invoice INV-1005 from LGPSM is overdue","Reminder","Desktop Outlook","Drafted"]
[null,null,null,null,25,14,"2026-07-27T17:49:00","priya@sunrisedental.com",null,null,"Reminder: Invoice INV-1005 from LGPSM is overdue","Reminder","Default email app","Drafted"]

{"sheet":"LabelsData","index":8,"n_rows":43,"n_cols":13,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,"Labels - system data, do not edit"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"LabelKey","DefaultText","UserText","Text_en","Text_es","Text_fr","Text_de","Text_it","Text_pl"]
[null,null,null,null,"QUOTE_TITLE","Quote","","Quote","Presupuesto","Devis","Angebot","Preventivo","Oferta"]
[null,null,null,null,"INVOICE_TITLE","Invoice","","Invoice","Factura","Facture","Rechnung","Fattura","Faktura"]
[null,null,null,null,"BILL_TO","Bill To","","Bill To","Facturar a","Facturer à","Rechnung an","Fatturare a","Nabywca"]
[null,null,null,null,"SHIP_TO","Ship To","","Ship To","Enviar a","Livrer à","Lieferung an","Spedire a","Odbiorca"]
[null,null,null,null,"DOC_NUMBER","Number","","Number","Número","Numéro","Nummer","Numero","Numer"]
[null,null,null,null,"DOC_DATE","Date","","Date","Fecha","Date","Datum","Data","Data"]
[null,null,null,null,"DUE_DATE","Due Date","","Due Date","Fecha de vencimiento","Date d'échéance","Fälligkeitsdatum","Scadenza","Termin płatności"]
[null,null,null,null,"VALID_UNTIL","Valid Until","","Valid Until","Válido hasta","Valable jusqu'au","Gültig bis","Valido fino al","Ważne do"]
[null,null,null,null,"SUBTOTAL","Subtotal","","Subtotal","Subtotal","Sous-total","Zwischensumme","Subtotale","Suma częściowa"]
[null,null,null,null,"DISCOUNT","Discount","","Discount","Descuento","Remise","Rabatt","Sconto","Rabat"]
[null,null,null,null,"SHIPPING","Shipping","","Shipping","Envío","Livraison","Versand","Spedizione","Wysyłka"]
[null,null,null,null,"GRAND_TOTAL","Total","","Total","Total","Total","Gesamt","Totale","Razem"]
[null,null,null,null,"AMOUNT_PAID","Amount Paid","","Amount Paid","Importe pagado","Montant payé","Bezahlter Betrag","Importo pagato","Zapłacono"]
[null,null,null,null,"BALANCE_DUE","Balance Due","","Balance Due","Saldo pendiente","Solde dû","Restbetrag","Saldo dovuto","Do zapłaty"]
[null,null,null,null,"NOTES","Notes","","Notes","Notas","Notes","Anmerkungen","Note","Uwagi"]
[null,null,null,null,"TERMS","Terms & Conditions","","Terms & Conditions","Términos y condiciones","Conditions générales","Geschäftsbedingungen","Termini e condizioni","Warunki"]
[null,null,null,null,"PHONE","Phone","","Phone","Teléfono","Téléphone","Telefon","Telefono","Telefon"]
[null,null,null,null,"EMAIL","Email","","Email","Correo","E-mail","E-Mail","Email","E-mail"]
[null,null,null,null,"WEBSITE","Web","","Web","Web","Site web","Web","Sito web","Strona"]
[null,null,null,null,"THANK_YOU","Thank you for your business","","Thank you for your business","Gracias por su confianza","Merci de votre confiance","Vielen Dank für Ihren Auftrag","Grazie per la fiducia","Dziękujemy za współpracę"]
[null,null,null,null,"COL_SKU","SKU",null,"SKU","SKU","Réf.","Art.-Nr.","Cod.","SKU"]
[null,null,null,null,"COL_DESC","Description","","Description","Descripción","Description","Beschreibung","Descrizione","Opis"]
[null,null,null,null,"COL_QTY","Quantity","","Quantity","Cantidad","Quantité","Menge","Quantità","Ilość"]
[null,null,null,null,"COL_UNIT","Unit","","Unit","Unidad","Unité","Einheit","Unità","Jedn."]
[null,null,null,null,"COL_PRICE","Price","","Price","Precio","Prix","Preis","Prezzo","Cena"]
[null,null,null,null,"COL_AMOUNT","Amount","","Amount","Importe","Montant","Betrag","Importo","Wartość"]
[null,null,null,null,"COL_COST","Cost","","Cost","Coste","Coût","Kosten","Costo","Koszt"]
[null,null,null,null,"COL_MODE","Mode","","Mode","Modo","Mode","Modus","Modalità","Tryb"]
[null,null,null,null,"COL_VALUE","Value","","Value","Valor","Valeur","Wert","Valore","Wartość"]
[null,null,null,null,"COL_MARGIN","Margin","","Margin","Margen","Marge","Marge","Margine","Marża"]
[null,null,null,null,"COL_TAXABLE","Taxable","","Taxable","Imponible","Taxable","Steuerpflichtig","Imponibile","Opodatk."]
[null,null,null,null,"TAX","Tax","","Tax","IVA","TVA","MwSt.","IVA","VAT"]
[null,null,null,null,"ADJUSTMENT","Adjustment","","Adjustment","Ajuste","Ajustement","Anpassung","Rettifica","Korekta"]

{"sheet":"ConfigData","index":9,"n_rows":75,"n_cols":6,"rows_kept":75,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,"Settings - system data, do not edit"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"SettingKey","SettingValue"]
[null,null,null,null,"CompanyName",""]
[null,null,null,null,"CompanyAddr1",""]
[null,null,null,null,"CompanyAddr2",""]
[null,null,null,null,"CompanyCity",""]
[null,null,null,null,"CompanyState",""]
[null,null,null,null,"CompanyPostal",""]
[null,null,null,null,"CompanyCountry",""]
[null,null,null,null,"CompanyPhone",""]
[null,null,null,null,"CompanyEmail",""]
[null,null,null,null,"CompanyWebsite",""]
[null,null,null,null,"LogoPath",""]
[null,null,null,null,"QuotePrefix","Q-"]
[null,null,null,null,"InvoicePrefix","INV-"]
[null,null,null,null,"QuoteNextNum","1"]
[null,null,null,null,"InvoiceNextNum","1"]
[null,null,null,null,"NumPadding","0"]
[null,null,null,null,"QuoteNumberPattern","{PREFIX}{SEQ}"]
[null,null,null,null,"InvoiceNumberPattern","{PREFIX}{SEQ}"]
[null,null,null,null,"DefaultTaxRate","5"]
[null,null,null,null,"DefaultTaxLabel","Tax"]
[null,null,null,null,"CurrencySymbol","$"]
[null,null,null,null,"DateFormat","mm/dd/yyyy"]
[null,null,null,null,"DefaultTermsDays","30"]
[null,null,null,null,"DefaultPricingMode","Price"]
[null,null,null,null,"DefaultItemsLabel","Items"]
[null,null,null,null,"DefaultUnitsLabel","Quantity"]
[null,null,null,null,"DefaultPriceLabel","Price"]
[null,null,null,null,"DefaultAmountLabel","Amount"]
[null,null,null,null,"DefaultShowItemName","TRUE"]
[null,null,null,null,"DefaultShowItemDesc","TRUE"]
[null,null,null,null,"DefaultShowUnits","TRUE"]
[null,null,null,null,"DefaultShowPrice","TRUE"]
[null,null,null,null,"DefaultShowAmount","TRUE"]
[null,null,null,null,"DefaultValidDays","30"]
[null,null,null,null,"HomeCreateCollapsed","0"]
[null,null,null,null,"NumberMode","Sequential"]
[null,null,null,null,"QuoteLastNumber","IINV-10001"]
[null,null,null,null,"InvoiceLastNumber","INV-1007"]
[null,null,null,null,"InvoiceContentW","572.25"]
[null,null,null,null,"SkuColW","104.625"]
[null,null,null,null,"ShowSKU","Yes"]
[null,null,null,null,"PdfFolder",""]
[null,null,null,null,"CurrencyPosition","Prefix"]
[null,null,null,null,"PriceColW","65.25"]
[null,null,null,null,"AmountColW","70.875"]
[null,null,null,null,"LanguageCode","English"]
[null,null,null,null,"PdfOpenAfter","Yes"]
[null,null,null,null,"PdfNameTemplate","{Type}_{Number}"]
[null,null,null,null,"ShippingTaxable","FALSE"]
[null,null,null,null,"AdjustmentTaxable","FALSE"]
[null,null,null,null,"DefaultMarginMode","PerItem"]
[null,null,null,null,"DefaultBlanketMargin","30"]
[null,null,null,null,"ExportFolder","D:\\ExcelGurus\\0-Excel-Gurus.com\\26-06-08-ExcelGurus Quote & Invoice\\Reports"]
[null,null,null,null,"EmailMethod","Default email app"]
[null,null,null,null,"EmailQuoteBody","Hi {Client},\n\nPlease find {Type} {Number} attached, for {Total}. Valid until {ValidUntil}.\n\nThank you,\n{Company}"]
[null,null,null,null,"EmailQuoteSubject","{Type} {Number} from {Company}"]
[null,null,null,null,"EmailInvoiceSubject","{Type} {Number} from {Company}"]
[null,null,null,null,"EmailInvoiceBody","Hi {Client},\n\nPlease find {Type} {Number} attached, for {Total}. Due by {DueDate}.\n\nThank you,\n{Company}"]
[null,null,null,null,"EmailReminderSubject","Reminder: {Type} {Number} from {Company} is overdue"]
[null,null,null,null,"EmailReminderBody","Hi {Client},\r\n\r\nOur records show invoice {Number} for {Total} is now {DaysOverdue} days overdue (due {DueDate}). Please arrange payment at your earliest convenience.\r\n\r\nThank you,\r\n{Company}"]
[null,null,null,null,"DemoProductIDs",""]
[null,null,null,null,"DemoClientIDs",""]
[null,null,null,null,"DemoDocIDs",""]
[null,null,null,null,"DemoBrandingLoaded",""]
[null,null,null,null,"ShowSampleDataButton",""]

{"sheet":"Home","index":10,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Number","Client","Date ▼","Status","Total","Balance","Due date","Open","Duplicate","Delete","Remind"]
[null,null,null,"No documents yet."]

{"sheet":"Builder","index":11,"n_rows":83,"n_cols":27,"rows_kept":83,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,null,"SKU1","Product1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invoice",null,null,null,"LBR-STD","Standard labor (per hour)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INV-200009",null,null,null,"LBR-EMG","Emergency labor (per hour)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Draft",null,null,null,"CON-PVC2","2in PVC pipe (10ft length)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"CON-PVC4","4in PVC pipe (10ft length)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,"ELE-WIRE","12-gauge copper wire (250ft)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-07-23",null,null,null,"ELE-BRKR","20A circuit breaker"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-09-06",null,null,null,"HVAC-FLT","HVAC filter (MERV 13)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"PLM-VLV","Brass shutoff valve"]
[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,"FAB-SHT","Steel sheet (4x8, 16ga)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($K$25:$K$74)-SUM($T$25:$T$74)","v":317},null,null,null,"PNT-GAL","Interior paint (per gallon)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$K$76+$K$77-$V$11","v":237},null,null,null,"SVC-DIAG","Diagnostic / inspection fee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($K$76+$K$77)=0,0,$V$12/($K$76+$K$77))","v":0.42779783393501802},null,null,null,"SVC-TRIP","Trip / dispatch charge"]
[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,"EQP-RENT","Equipment rental (per day)"]
[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,"MISC-DISP","Disposal / haul-away fee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"($K$76+$K$77)*$V$27/100","v":166.2},null,null,null,"abc123","Test1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"($K$76+$K$77)-$V$16","v":387.8},null,null,null,"def","Test2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PerItem"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"From your per-line costs: about \"&TEXT($V$12,\"\"\"$\"\"#,##0\")&\" profit (\"&TEXT($V$13,\"0%\")&\" margin). Customer pays \"&TEXT($K$81,\"\"\"$\"\"#,##0\")&\".\"","v":"From your per-line costs: about $237 profit (43% margin). Customer pays $562."}]
[]
[]
[]
[]
[null,null,null,null,null,"SKU","Description","Quantity","Unit","Price","Amount",null,null,null,null,"Taxable","Cost","Mode","Value","Margin"]
[null,null,null,null,null,"LBR-STD","Standard labor (per hour)",5,null,{"$f":"IF(R25=\"\",\"\",IF(R25=\"Price\",IF(ISBLANK(S25),\"\",S25),IF(ISBLANK(Q25),\"\",IF(R25=\"Markup %\",Q25*(1+S25/100),IF(R25=\"Margin %\",IF(S25<100,Q25/(1-S25/100),0),Q25+S25)))))","v":85},{"$f":"IF(OR(H25=\"\",J25=\"\"),\"\",H25*J25)","v":425},null,null,null,null,false,52,"Price",85,{"$f":"IF(OR(H25=\"\",J25=\"\"),\"\",(J25-Q25)*H25)","v":165}]
[null,null,null,null,null,"ELE-BRKR","20A circuit breaker",6,null,21.5,129,null,null,null,null,true,9.5,"Markup $",12,72]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,"",null,30]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,"",null,true]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,"",null,true]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(R57=\"\",\"\",IF(R57=\"Price\",IF(ISBLANK(S57),\"\",S57),IF(ISBLANK(Q57),\"\",IF(R57=\"Markup %\",Q57*(1+S57/100),IF(R57=\"Margin %\",IF(S57<100,Q57/(1-S57/100),0),Q57+S57)))))","v":""},{"$f":"IF(OR(H57=\"\",J57=\"\"),\"\",H57*J57)","v":""},null,null,null,null,false,null,null,null,{"$f":"IF(OR(H57=\"\",J57=\"\"),\"\",(J57-Q57)*H57)","v":""}]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,false,null,null,null,""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($V$29,\"\",IF($P$75=\"\",\"\",\"Line item tot\"))","v":""},{"$f":"IF($V$29,\"\",IF($P$75=\"\",\"\",SUM($K$25:$K$74)))","v":""},null,null,null,null,null,"← Subtotal override (requires: 'Prices: Off')"]
[null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"IF(AND(NOT($V$29),$P$75<>\"\"),$P$75,SUM($K$25:$K$74))","v":554},null,null,null,null,"On/Off","Amount","Option"]
[null,null,null,null,null,null,null,null,null,"Discount",{"$f":"IF($P$77,IF($R$77=\"%\",-$K$76*$Q$77/100,-$Q$77),0)","v":0},null,null,null,null,true,0,"$"]
[null,null,null,null,null,null,null,null,null,"Shipping",{"$f":"IF($P$78,$Q$78,0)","v":0},null,null,null,null,true,0,"No tax"]
[null,null,null,null,null,null,null,null,null,"Adjustment",{"$f":"IF($P$79,$Q$79,0)","v":0},null,null,null,null,true,0,"No tax"]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Tax \"&$Q$80&\"%\"","v":"Tax 6.5%"},{"$f":"IF($P$80,ROUND((IF($V$29,IF($K$76=0,0,SUMIFS($K$25:$K$74,$P$25:$P$74,TRUE)*(1-(-$K$77)/$K$76)),$K$76+$K$77)+IF($R$78=\"Taxable\",$K$78,0)+IF($R$79=\"Taxable\",$K$79,0))*$Q$80/100,2),0)","v":8.39},null,null,null,null,true,6.5,"%"]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"$K$76+$K$77+$K$78+$K$79+$K$80","v":562.39},null,null,null,null,{"$f":"IF($V$18=\"Blanket\",\"Est. profit  \"&TEXT($V$16,\"\"\"$\"\"#,##0\")&\"  (\"&TEXT($V$27,\"0\")&\"%)\",\"Profit  \"&TEXT($V$12,\"\"\"$\"\"#,##0\")&\"  (\"&TEXT($V$13,\"0.0%\")&\")\")","v":"Profit  $237  (42.8%)"}]
[null,null,null,null,null,null,null,null,null,"Amount Paid",{"$f":"$V$32","v":0}]
[null,null,null,null,null,null,null,null,null,"Balance Due",{"$f":"ROUND($K$81-$V$32,2)","v":562.39}]

{"sheet":"Agreement","index":12,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,"END USER LICENSE AGREEMENT"]
[]
[null,"EG Quote & Invoice\r\nCopyright (c) 2026 ExcelGurus, LLC. All rights reserved."]
[]
[null,"IMPORTANT - READ CAREFULLY. This End User License Agreement (\"Agreement\") is a legal agreement between you (either an individual or a single entity, \"you\") and ExcelGurus, LLC (\"ExcelGurus\", \"we\", or \"us\") for the EG Quote & Invoice software product, including all associated files, templates, and documentation (the \"Software\"). By installing, activating, opening, or otherwise using the Software, you agree to be bound by the terms of this Agreement. If you do not agree, do not use the Software."]
[]
[null,"1. LICENSE GRANT. Subject to your compliance with this Agreement and payment of any applicable fees, ExcelGurus grants you a limited, non-exclusive, non-transferable, revocable license to install and use the Software on the number of computers permitted by your license, solely for your own internal business or personal purposes. A free tier, where offered, is licensed on the same terms but is limited in functionality (for example, generated documents may carry ExcelGurus branding, and certain features such as data export may be restricted)."]
[]
[null,"2. RESTRICTIONS. You may NOT, and may not permit any third party to: (a) copy, reproduce, or distribute the Software except as expressly permitted herein; (b) sell, rent, lease, sublicense, lend, or otherwise transfer the Software or your license key to any third party; (c) share, publish, or disclose your license key or activation credentials; (d) use the Software on more computers than your license permits, or circumvent any license, activation, machine-count, or feature-flag limitation; (e) reverse engineer, decompile, disassemble, unlock, or otherwise attempt to derive the source code or underlying ideas of the Software, except to the extent this restriction is prohibited by applicable law; (f) modify, adapt, translate, or create derivative works based on the Software; or (g) remove, alter, or obscure any copyright, trademark, or other proprietary notices."]
[]
[null,"3. OWNERSHIP. The Software is licensed, not sold. ExcelGurus and its licensors retain all right, title, and interest in and to the Software, including all intellectual property rights. No rights are granted except as expressly set forth in this Agreement."]
[]
[null,"4. ACTIVATION AND VERIFICATION. The Software may require online activation and may periodically verify your license over the internet. You consent to the transmission of limited license and machine-identification data for these purposes. The Software may limit or disable licensed features if a valid license cannot be verified. In addition, when you first accept this Agreement, the Software sends a one-time message to ExcelGurus indicating that an installation has been activated; this message includes the Software version, an anonymous installation identifier, your IP address, and a timestamp, and is used solely to understand how many installations are in active use. It contains no personal information and no data from your spreadsheets."]
[]
[null,"5. NO WARRANTY. THE SOFTWARE IS PROVIDED \"AS IS\" AND \"AS AVAILABLE\", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON-INFRINGEMENT. EXCELGURUS DOES NOT WARRANT THAT THE SOFTWARE WILL BE ERROR-FREE OR UNINTERRUPTED, OR THAT IT WILL MEET YOUR REQUIREMENTS. YOU ASSUME THE ENTIRE RISK AS TO THE RESULTS AND PERFORMANCE OF THE SOFTWARE. YOU ARE SOLELY RESPONSIBLE FOR MAINTAINING BACKUPS OF YOUR DATA."]
[]
[null,"6. LIMITATION OF LIABILITY. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, IN NO EVENT WILL EXCELGURUS BE LIABLE FOR ANY INDIRECT, INCIDENTAL, SPECIAL, CONSEQUENTIAL, OR PUNITIVE DAMAGES, OR FOR ANY LOSS OF PROFITS, DATA, BUSINESS, OR GOODWILL, ARISING OUT OF OR RELATED TO THE SOFTWARE OR THIS AGREEMENT, WHETHER IN CONTRACT, TORT, OR OTHERWISE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. EXCELGURUS'S TOTAL CUMULATIVE LIABILITY ARISING OUT OF OR RELATED TO THE SOFTWARE OR THIS AGREEMENT WILL NOT EXCEED THE AMOUNT YOU ACTUALLY PAID TO EXCELGURUS FOR THE SOFTWARE. Some jurisdictions do not allow certain limitations, so portions of the above may not apply to you."]
[]
[null,"7. TERMINATION. This Agreement is effective until terminated. It terminates automatically if you breach any term. Upon termination, you must stop using the Software and destroy all copies in your possession. ExcelGurus may disable or revoke a license that is used in violation of this Agreement. Sections 2, 3, 5, 6, 8, and 9 survive termination."]
[]
[null,"8. GOVERNING LAW. This Agreement is governed by the laws of the State of Florida, USA, without regard to its conflict-of-laws rules. The exclusive venue for any dispute will be the state or federal courts located in Florida, and you consent to their jurisdiction."]
[]
[null,"9. ENTIRE AGREEMENT. This Agreement is the entire agreement between you and ExcelGurus regarding the Software and supersedes all prior understandings. If any provision is held unenforceable, the remaining provisions will remain in full force. Our failure to enforce any right is not a waiver of that right."]
[]
[null,"By clicking \"I Agree\" you acknowledge that you have read this Agreement and agree to be bound by its terms."]
[]
[null,"ExcelGurus, LLC  -  Excel-Gurus.com"]

{"sheet":"Settings","index":13,"n_rows":145,"n_cols":110,"rows_kept":145,"cut":false,"hidden":true,"merged":[[141,2,141,4],[76,2,76,4],[9,2,9,4],[30,2,30,4],[49,2,49,4],[57,2,57,4],[62,2,62,4],[121,2,121,4],[124,2,133,4],[89,2,89,4],[92,2,101,4],[104,2,104,4],[107,2,116,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,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,"v4"]
[]
[]
[]
[]
[]
[]
[null,null,"Company"]
[null,null,"Logo: 200px by 50px maximum (will scale automatically).  Accepted: .png, .jpg, .jpeg, .gif, .bmp"]
[null,null,""]
[]
[]
[null,null,"Company name",null,"Website"]
[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,"S:CompanyName",null,"S:CompanyWebsite"]
[]
[null,null,"Address line 1",null,"Address line 2"]
[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,"S:CompanyAddr1",null,"S:CompanyAddr2"]
[]
[null,null,"City",null,"State"]
[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,"S:CompanyCity",null,"S:CompanyState"]
[]
[null,null,"Postal",null,"Country"]
[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,"S:CompanyPostal",null,"S:CompanyCountry"]
[]
[null,null,"Phone",null,"Email"]
[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,"S:CompanyPhone",null,"S:CompanyEmail"]
[]
[]
[null,null,"Branding"]
[null,null,"Thank-you tagline"]
[null,null,"Thank you for your business",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,"L:THANK_YOU"]
[]
[]
[null,null,"Quote / invoice defaults"]
[null,null,"Numbering mode",null,"Date format"]
[null,null,"Sequential",null,"mm/dd/yyyy",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,"S:NumberMode",null,"S:DateFormat"]
[]
[null,null,"Valid days",null,"Terms days"]
[null,null,"30",null,"30",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,"N:DefaultValidDays",null,"N:DefaultTermsDays"]
[]
[]
[null,null,"Currency & tax"]
[null,null,"Currency symbol",null,"Symbol position"]
[null,null,"$",null,"Prefix",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,"S:CurrencySymbol",null,"S:CurrencyPosition"]
[]
[null,null,"Default tax rate %   also editable within quote / invoice",null,"Shipping taxable   also editable within quote / invoice"]
[null,null,"5",null,"No",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,"N:DefaultTaxRate",null,"S:ShippingTaxable"]
[]
[null,null,"Adjustment taxable   also editable within quote / invoice"]
[null,null,"No",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,"S:AdjustmentTaxable"]
[]
[]
[null,null,"Pricing defaults"]
[null,null,"Margin mode   also editable within quote / invoice",null,"Blanket margin %   also editable within quote / invoice"]
[null,null,"Per-item",null,"30",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,"S:DefaultMarginMode",null,"N:DefaultBlanketMargin"]
[]
[null,null,"Show SKU column"]
[null,null,"No",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,"S:ShowSKU"]
[]
[]
[null,null,"PDF / output"]
[null,null,"Save folder"]
[null,null,""]
[]
[]
[null,null,"File name template",null,"Open PDF after creating"]
[null,null,"{Type}_{Number}",null,"No",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,"S:PdfNameTemplate",null,"S:PdfOpenAfter"]
[]
[]
[null,null,"Available tokens:"]
[null,null,"{Type}  -  becomes \"Quote\" or \"Invoice\""]
[null,null,"{Number}  -  becomes the quote / invoice number"]
[null,null,"{Client}  -  becomes the client's name"]
[]
[null,null,"Email"]
[null,null,"Email method"]
[null,null,"Default email app",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,"S:EmailMethod"]
[]
[null,null,"Available tokens:"]
[null,null,"{Type}  -  becomes \"Quote\" or \"Invoice\""]
[null,null,"{Number}  -  the quote / invoice number"]
[null,null,"{Client}  -  the client's name"]
[null,null,"{Total}  -  the amount owed, formatted"]
[null,null,"{Company}  -  your business name"]
[null,null,"{Date}  -  the document date"]
[null,null,"{ValidUntil}  -  quote valid-until date (blank on invoices)"]
[null,null,"{DueDate}  -  invoice due date (blank on quotes)"]
[]
[null,null,"Quote subject"]
[null,null,"{Type} {Number} from {Company}"]
[]
[null,null,"Quote body"]
[null,null,"Hi {Client},\n\nPlease find {Type} {Number} attached, for {Total}. Valid until {ValidUntil}.\n\nThank you,\n{Company}"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Invoice subject"]
[null,null,"{Type} {Number} from {Company}"]
[]
[null,null,"Invoice body"]
[null,null,"Hi {Client},\n\nPlease find {Type} {Number} attached, for {Total}. Due by {DueDate}.\n\nThank you,\n{Company}"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Reminder subject (overdue invoices)"]
[null,null,"Reminder: {Type} {Number} from {Company} is overdue"]
[]
[null,null,"Reminder body (overdue invoices)"]
[null,null,"Hi {Client},\r\n\r\nOur records show invoice {Number} for {Total} is now {DaysOverdue} days overdue (due {DueDate}). Please arrange payment at your earliest convenience.\r\n\r\nThank you,\r\n{Company}"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Language:  Fills the quote / invoice labels - still editable per label in Labels & language editor."]
[]
[null,null,"Language"]
[null,null,"English",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,"S:LanguageCode"]
[]
[]
[null,null,"More"]

{"sheet":"Clients","index":14,"n_rows":11,"n_cols":60,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[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,0]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Company","Contact","Email","Phone","Addr1","Addr2","City","State","Postal","Country","Terms","Notes","Edit","Archive"]
[null,"No active clients."]

{"sheet":"Products","index":15,"n_rows":11,"n_cols":60,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[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,0]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SKU","Category","Description","Cost","Price","Pricing mode","Value","Taxable","Edit","Archive"]
[null,"No active products."]

{"sheet":"Labels","index":16,"n_rows":50,"n_cols":60,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,"Language:",null,"English",null,"Pick a language to fill the middle column. Your text (right) always wins on the document."]
[]
[]
[null,"Label",null,"Default (English)",null,"English (translation)",null,"Your text (override)"]
[null,"Document titles"]
[null,"Quote title",null,"Quote",null,"Quote",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,"QUOTE_TITLE"]
[null,"Invoice title",null,"Invoice",null,"Invoice",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,"INVOICE_TITLE"]
[null,"Parties"]
[null,"Bill-to heading",null,"Bill To",null,"Bill To",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,"BILL_TO"]
[null,"Ship-to heading",null,"Ship To",null,"Ship To",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,"SHIP_TO"]
[null,"Document info"]
[null,"Number label",null,"Number",null,"Number",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,"DOC_NUMBER"]
[null,"Date label",null,"Date",null,"Date",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,"DOC_DATE"]
[null,"Due-date label",null,"Due Date",null,"Due Date",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,"DUE_DATE"]
[null,"Valid-until label",null,"Valid Until",null,"Valid Until",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,"VALID_UNTIL"]
[null,"Line item headers"]
[null,"SKU column",null,"SKU",null,"SKU",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,"COL_SKU"]
[null,"Description column",null,"Description",null,"Description",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,"COL_DESC"]
[null,"Quantity column",null,"Quantity",null,"Quantity",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,"COL_QTY"]
[null,"Unit column",null,"Unit",null,"Unit",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,"COL_UNIT"]
[null,"Price column",null,"Price",null,"Price",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,"COL_PRICE"]
[null,"Amount column",null,"Amount",null,"Amount",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,"COL_AMOUNT"]
[null,"Taxable column",null,"Taxable",null,"Taxable",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,"COL_TAXABLE"]
[null,"Totals"]
[null,"Subtotal",null,"Subtotal",null,"Subtotal",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"]
[null,"Discount",null,"Discount",null,"Discount",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,"DISCOUNT"]
[null,"Shipping",null,"Shipping",null,"Shipping",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,"SHIPPING"]
[null,"Adjustment",null,"Adjustment",null,"Adjustment",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,"ADJUSTMENT"]
[null,"Tax",null,"Tax",null,"Tax",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,"TAX"]
[null,"Total",null,"Total",null,"Total",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,"GRAND_TOTAL"]
[null,"Amount paid",null,"Amount Paid",null,"Amount Paid",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,"AMOUNT_PAID"]
[null,"Balance due",null,"Balance Due",null,"Balance Due",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,"BALANCE_DUE"]
[null,"Footer"]
[null,"Notes heading",null,"Notes",null,"Notes",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,"NOTES"]
[null,"Terms heading",null,"Terms & Conditions",null,"Terms & Conditions",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,"TERMS"]
[null,"Thank-you message",null,"Thank you for your business",null,"Thank you for your business",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,"THANK_YOU"]
[null,"Contact"]
[null,"Phone label",null,"Phone",null,"Phone",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,"PHONE"]
[null,"Email label",null,"Email",null,"Email",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,"EMAIL"]
[null,"Website label",null,"Web",null,"Web",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,"WEBSITE"]
[null,"Admin (internal - not printed)"]
[null,"Cost column",null,"Cost",null,"Cost",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,"COL_COST"]
[null,"Mode column",null,"Mode",null,"Mode",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,"COL_MODE"]
[null,"Value column",null,"Value",null,"Value",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,"COL_VALUE"]
[null,"Margin column",null,"Margin",null,"Margin",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,"COL_MARGIN"]

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

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