{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Calendar","Your notes","Instructions","Client","Description","Terms","TOC","Invoice1"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":9,"comments":3,"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":"Calendar","index":0,"n_rows":39,"n_cols":25,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,1,1,25],[2,2,2,24],[3,2,3,24],[4,2,4,8],[4,9,11,9],[4,10,4,16],[4,17,11,17],[4,18,4,24],[12,2,12,24],[13,2,13,8],[13,9,20,9],[13,10,13,16],[13,17,20,17],[13,18,13,24],[21,2,21,24],[22,2,22,8],[22,9,29,9],[22,10,22,16],[22,17,29,17],[22,18,22,24],[39,2,39,24],[30,2,30,24],[31,2,31,8],[31,9,38,9],[31,10,31,16],[31,17,38,17],[31,18,31,24]]}
[]
[]
[null,null,2023]
[]
[null,null,{"$f":"DATE(theyear,1,1)","v":"2023-01-01"},null,null,null,null,null,null,null,{"$f":"DATE(theyear,2,1)","v":"2023-02-01"},null,null,null,null,null,null,null,{"$f":"DATE(theyear,3,1)","v":"2023-03-01"}]
[null,null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07",null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07",null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07"]
[null,null,{"$f":"IF(MONTH(DATE(YEAR(C5),MONTH(C5),1))<>MONTH(DATE(YEAR(C5),MONTH(C5),1)-(WEEKDAY(DATE(YEAR(C5),MONTH(C5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(C5),MONTH(C5),1)-(WEEKDAY(DATE(YEAR(C5),MONTH(C5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":"2023-01-01"},"2023-01-02","2023-01-03","2023-01-04","2023-01-05","2023-01-06","2023-01-07",null,{"$f":"IF(MONTH(DATE(YEAR(K5),MONTH(K5),1))<>MONTH(DATE(YEAR(K5),MONTH(K5),1)-(WEEKDAY(DATE(YEAR(K5),MONTH(K5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(K5),MONTH(K5),1)-(WEEKDAY(DATE(YEAR(K5),MONTH(K5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","","2023-02-01","2023-02-02","2023-02-03","2023-02-04",null,{"$f":"IF(MONTH(DATE(YEAR(S5),MONTH(S5),1))<>MONTH(DATE(YEAR(S5),MONTH(S5),1)-(WEEKDAY(DATE(YEAR(S5),MONTH(S5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(S5),MONTH(S5),1)-(WEEKDAY(DATE(YEAR(S5),MONTH(S5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","","2023-03-01","2023-03-02","2023-03-03","2023-03-04"]
[null,null,"2023-01-08","2023-01-09","2023-01-10","2023-01-11","2023-01-12","2023-01-13","2023-01-14",null,"2023-02-05","2023-02-06","2023-02-07","2023-02-08","2023-02-09","2023-02-10","2023-02-11",null,"2023-03-05","2023-03-06","2023-03-07","2023-03-08","2023-03-09","2023-03-10","2023-03-11"]
[null,null,"2023-01-15","2023-01-16","2023-01-17","2023-01-18","2023-01-19","2023-01-20","2023-01-21",null,"2023-02-12","2023-02-13","2023-02-14","2023-02-15","2023-02-16","2023-02-17","2023-02-18",null,"2023-03-12","2023-03-13","2023-03-14","2023-03-15","2023-03-16","2023-03-17","2023-03-18"]
[null,null,"2023-01-22","2023-01-23","2023-01-24","2023-01-25","2023-01-26","2023-01-27","2023-01-28",null,"2023-02-19","2023-02-20","2023-02-21","2023-02-22","2023-02-23","2023-02-24","2023-02-25",null,"2023-03-19","2023-03-20","2023-03-21","2023-03-22","2023-03-23","2023-03-24","2023-03-25"]
[null,null,"2023-01-29","2023-01-30","2023-01-31","","","","",null,"2023-02-26","2023-02-27","2023-02-28","","","","",null,"2023-03-26","2023-03-27","2023-03-28","2023-03-29","2023-03-30","2023-03-31",""]
[null,null,"","","","","","","",null,"","","","","","","",null,"","","","","","",""]
[]
[null,null,{"$f":"DATE(theyear,4,1)","v":"2023-04-01"},null,null,null,null,null,null,null,{"$f":"theyear=DATE(theyear,5,1)","v":false},null,null,null,null,null,null,null,{"$f":"DATE(theyear,6,1)","v":"2023-06-01"}]
[null,null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07",null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07",null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07"]
[null,null,{"$f":"IF(MONTH(DATE(YEAR(C14),MONTH(C14),1))<>MONTH(DATE(YEAR(C14),MONTH(C14),1)-(WEEKDAY(DATE(YEAR(C14),MONTH(C14),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(C14),MONTH(C14),1)-(WEEKDAY(DATE(YEAR(C14),MONTH(C14),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","","","","","2023-04-01",null,{"$f":"IF(MONTH(DATE(YEAR(K14),MONTH(K14),1))<>MONTH(DATE(YEAR(K14),MONTH(K14),1)-(WEEKDAY(DATE(YEAR(K14),MONTH(K14),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(K14),MONTH(K14),1)-(WEEKDAY(DATE(YEAR(K14),MONTH(K14),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07",null,{"$f":"IF(MONTH(DATE(YEAR(S14),MONTH(S14),1))<>MONTH(DATE(YEAR(S14),MONTH(S14),1)-(WEEKDAY(DATE(YEAR(S14),MONTH(S14),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(S14),MONTH(S14),1)-(WEEKDAY(DATE(YEAR(S14),MONTH(S14),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","","","2023-06-01","2023-06-02","2023-06-03"]
[null,null,"2023-04-02","2023-04-03","2023-04-04","2023-04-05","2023-04-06","2023-04-07","2023-04-08",null,"1900-01-08","1900-01-09","1900-01-10","1900-01-11","1900-01-12","1900-01-13","1900-01-14",null,"2023-06-04","2023-06-05","2023-06-06","2023-06-07","2023-06-08","2023-06-09","2023-06-10"]
[null,null,"2023-04-09","2023-04-10","2023-04-11","2023-04-12","2023-04-13","2023-04-14","2023-04-15",null,"1900-01-15","1900-01-16","1900-01-17","1900-01-18","1900-01-19","1900-01-20","1900-01-21",null,"2023-06-11","2023-06-12","2023-06-13","2023-06-14","2023-06-15","2023-06-16","2023-06-17"]
[null,null,"2023-04-16","2023-04-17","2023-04-18","2023-04-19","2023-04-20","2023-04-21","2023-04-22",null,"1900-01-22","1900-01-23","1900-01-24","1900-01-25","1900-01-26","1900-01-27","1900-01-28",null,"2023-06-18","2023-06-19","2023-06-20","2023-06-21","2023-06-22","2023-06-23","2023-06-24"]
[null,null,"2023-04-23","2023-04-24","2023-04-25","2023-04-26","2023-04-27","2023-04-28","2023-04-29",null,"1900-01-29","1900-01-30","1900-01-31","","","","",null,"2023-06-25","2023-06-26","2023-06-27","2023-06-28","2023-06-29","2023-06-30",""]
[null,null,"2023-04-30","","","","","","",null,"","","","","","","",null,"","","","","","",""]
[]
[null,null,{"$f":"DATE(theyear,7,1)","v":"2023-07-01"},null,null,null,null,null,null,null,{"$f":"DATE(theyear,8,1)","v":"2023-08-01"},null,null,null,null,null,null,null,{"$f":"DATE(theyear,9,1)","v":"2023-09-01"}]
[null,null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07",null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07",null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07"]
[null,null,{"$f":"IF(MONTH(DATE(YEAR(C23),MONTH(C23),1))<>MONTH(DATE(YEAR(C23),MONTH(C23),1)-(WEEKDAY(DATE(YEAR(C23),MONTH(C23),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(C23),MONTH(C23),1)-(WEEKDAY(DATE(YEAR(C23),MONTH(C23),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","","","","","2023-07-01",null,{"$f":"IF(MONTH(DATE(YEAR(K23),MONTH(K23),1))<>MONTH(DATE(YEAR(K23),MONTH(K23),1)-(WEEKDAY(DATE(YEAR(K23),MONTH(K23),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(K23),MONTH(K23),1)-(WEEKDAY(DATE(YEAR(K23),MONTH(K23),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","2023-08-01","2023-08-02","2023-08-03","2023-08-04","2023-08-05",null,{"$f":"IF(MONTH(DATE(YEAR(S23),MONTH(S23),1))<>MONTH(DATE(YEAR(S23),MONTH(S23),1)-(WEEKDAY(DATE(YEAR(S23),MONTH(S23),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(S23),MONTH(S23),1)-(WEEKDAY(DATE(YEAR(S23),MONTH(S23),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","","","","2023-09-01","2023-09-02"]
[null,null,"2023-07-02","2023-07-03","2023-07-04","2023-07-05","2023-07-06","2023-07-07","2023-07-08",null,"2023-08-06","2023-08-07","2023-08-08","2023-08-09","2023-08-10","2023-08-11","2023-08-12",null,"2023-09-03","2023-09-04","2023-09-05","2023-09-06","2023-09-07","2023-09-08","2023-09-09"]
[null,null,"2023-07-09","2023-07-10","2023-07-11","2023-07-12","2023-07-13","2023-07-14","2023-07-15",null,"2023-08-13","2023-08-14","2023-08-15","2023-08-16","2023-08-17","2023-08-18","2023-08-19",null,"2023-09-10","2023-09-11","2023-09-12","2023-09-13","2023-09-14","2023-09-15","2023-09-16"]
[null,null,"2023-07-16","2023-07-17","2023-07-18","2023-07-19","2023-07-20","2023-07-21","2023-07-22",null,"2023-08-20","2023-08-21","2023-08-22","2023-08-23","2023-08-24","2023-08-25","2023-08-26",null,"2023-09-17","2023-09-18","2023-09-19","2023-09-20","2023-09-21","2023-09-22","2023-09-23"]
[null,null,"2023-07-23","2023-07-24","2023-07-25","2023-07-26","2023-07-27","2023-07-28","2023-07-29",null,"2023-08-27","2023-08-28","2023-08-29","2023-08-30","2023-08-31","","",null,"2023-09-24","2023-09-25","2023-09-26","2023-09-27","2023-09-28","2023-09-29","2023-09-30"]
[null,null,"2023-07-30","2023-07-31","","","","","",null,"","","","","","","",null,"","","","","","",""]
[]
[null,null,{"$f":"DATE(theyear,10,1)","v":"2023-10-01"},null,null,null,null,null,null,null,{"$f":"DATE(theyear,11,1)","v":"2023-11-01"},null,null,null,null,null,null,null,{"$f":"DATE(theyear,12,1)","v":"2023-12-01"}]
[null,null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07",null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07",null,{"$f":"TRANSPOSE({1;2;3;4;5;6;7})","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07"]
[null,null,{"$f":"IF(MONTH(DATE(YEAR(C32),MONTH(C32),1))<>MONTH(DATE(YEAR(C32),MONTH(C32),1)-(WEEKDAY(DATE(YEAR(C32),MONTH(C32),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(C32),MONTH(C32),1)-(WEEKDAY(DATE(YEAR(C32),MONTH(C32),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":"2023-10-01"},"2023-10-02","2023-10-03","2023-10-04","2023-10-05","2023-10-06","2023-10-07",null,{"$f":"IF(MONTH(DATE(YEAR(K32),MONTH(K32),1))<>MONTH(DATE(YEAR(K32),MONTH(K32),1)-(WEEKDAY(DATE(YEAR(K32),MONTH(K32),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(K32),MONTH(K32),1)-(WEEKDAY(DATE(YEAR(K32),MONTH(K32),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","","2023-11-01","2023-11-02","2023-11-03","2023-11-04",null,{"$f":"IF(MONTH(DATE(YEAR(S32),MONTH(S32),1))<>MONTH(DATE(YEAR(S32),MONTH(S32),1)-(WEEKDAY(DATE(YEAR(S32),MONTH(S32),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),\"\",DATE(YEAR(S32),MONTH(S32),1)-(WEEKDAY(DATE(YEAR(S32),MONTH(S32),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)","v":""},"","","","","2023-12-01","2023-12-02"]
[null,null,"2023-10-08","2023-10-09","2023-10-10","2023-10-11","2023-10-12","2023-10-13","2023-10-14",null,"2023-11-05","2023-11-06","2023-11-07","2023-11-08","2023-11-09","2023-11-10","2023-11-11",null,"2023-12-03","2023-12-04","2023-12-05","2023-12-06","2023-12-07","2023-12-08","2023-12-09"]
[null,null,"2023-10-15","2023-10-16","2023-10-17","2023-10-18","2023-10-19","2023-10-20","2023-10-21",null,"2023-11-12","2023-11-13","2023-11-14","2023-11-15","2023-11-16","2023-11-17","2023-11-18",null,"2023-12-10","2023-12-11","2023-12-12","2023-12-13","2023-12-14","2023-12-15","2023-12-16"]
[null,null,"2023-10-22","2023-10-23","2023-10-24","2023-10-25","2023-10-26","2023-10-27","2023-10-28",null,"2023-11-19","2023-11-20","2023-11-21","2023-11-22","2023-11-23","2023-11-24","2023-11-25",null,"2023-12-17","2023-12-18","2023-12-19","2023-12-20","2023-12-21","2023-12-22","2023-12-23"]
[null,null,"2023-10-29","2023-10-30","2023-10-31","","","","",null,"2023-11-26","2023-11-27","2023-11-28","2023-11-29","2023-11-30","","",null,"2023-12-24","2023-12-25","2023-12-26","2023-12-27","2023-12-28","2023-12-29","2023-12-30"]
[null,null,"","","","","","","",null,"","","","","","","",null,"2023-12-31","","","","","",""]

{"sheet":"Your notes","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Instructions","index":2,"n_rows":73,"n_cols":3,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["Steps","Sheet name and instructions","Additional notes"]
[]
["Navigate to","TOC sheet","! Important"]
[null,"Specify the initial invoice number in cell D3 ","It's crucial to input the starting invoice number in cell D3."]
[]
[]
[]
[]
["Navigate to","Invoice1 and then select the \"Create a new invoice\" button","This action will generate a new invoice within the template."]
[]
[]
[null,"The new invoice will be created"]
[null,"Upon creating a new invoice, the sheet will automatically be named after the Invoice Number indicated in cell F5."]
[]
["Modify the details for the new invoice as follows:","Update the invoice date in cell F4"]
[null,"Update the recipient's information in cell A11"]
[null,"Choose the description from the dropdown list"]
[null,"Add any extra information, date, or time as needed"]
[null,"Notes this field auto-updates based on changes in the 'Notes' column (Column G) within the 'Client' tab. However, you have the option to manually input your information here and/or override the automatic update. This column is hidden on invoice or leave this cell empty.\nNote: This column is hidden on the invoice and you can unhide it when needed"]
[null,"Enter the rate information as required."]
[null,"Enter the unit information as required."]
[]
["If you want to calculate: PST of 7% and GST of 5%","Select the \"Add GST and PST\" button"]
[null,"Additional information: \nWhen the values in cells E34 and E35 are both 'yes,' the formula will automatically calculate a PST and GST. This update occurs instantly upon pressing the designated button."]
[]
[null,"If you made a mistake and you don't want to calculate PST and GST click 'Hide GST and PST\" button. This will hide both GST and PST rows"]
[]
[]
["If you want to calculate: GST of 5%","If you want to calculate GST only click \"Add GST only\""]
[]
[]
[]
["To print the invoice:","Click on File, then select Print."]
[null,"Choose your printer or opt for \"Print to PDF\" from the Printer Dropdown."]
[null,"Click Print and save it in your Invoices folder using the Invoice Number (e.g., 4001)."]
[null,"You can then send the PDF invoice to your clients."]
[]
[]
[]
["If you want to create another invoice:","Click the \"Go back\" hyperlink to go back to original template - Invoice1"]
[]
[]
["Navigate to TOC tab if the work is completed","Click the \"Update TOC\" button"]
[]
[]
["Additional notes:"]
[]
[null,"Please don't add new sheets in front of TOC tab"]
[]
[null,"Kindly note that Invoice1 serves as your template. Whenever you need to generate a new invoice, simply click the \"Create a new invoice\" button within the Invoice1 template."]
[null,"You have the freedom to generate multiple invoices within this template. Each new invoice will automatically use the next sequential number based on the previous invoice number."]
[null,"Once you've made a new invoice, return to Invoice1 and select \"Create a new invoice\" to generate another one."]
[]
["Update client information in the tab \"Client\"","You can add, sort, or remove clients. \nTo include the serviced place's location on the invoice, update Column G, labeled 'Notes,' with your notes"]
[]
["Update tasks descriptions in the tab \"Description\"","You can add, sort, or remove any additional tasks."]
[]
["After completion, save the invoices as:","Invoices_template_Janaury"]
[null,"Invoices_template_February"]
[null,"etc"]
[]
[]
[null,"Use a new template for each month"]
[]
["Copy client and description information from tabs to a new template","By selecting the range, then right-clicking to copy Open the new monthly template and go to the Client tab, then paste the information"]
[null,"Repeat the steps for Description if you updated this tab"]
[]
[]
[]
[]
[]
[]
["Template designed by: absfinances\n\nVisit our website at www.absfinances.com for more products/services\n\nContact us at: Info@absfinances.com"]

{"sheet":"Client","index":3,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Client","Client Name","Address","City","Postal Code","Province","Notes","Additional contact","Email","Phone #","Notes","Check customer"]
["Client business name","Client Name","101 Hastings Street","Vancouver","V1Y 0J9","BC",null,null,null,null,null,{"$f":"IF(COUNTIF($A$2:$A$498,A2)=1,\"\",\"Customer exists\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]
[null,null,null,null,null,null,null,null,null,null,null,"Customer exists"]

{"sheet":"Description","index":4,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Type","Description"]
["Management Consulting","Guiding organizations to boost performance and operational efficiency."]
["Financial Consulting","Offering counsel on financial management, risk assessment, investments, and M&A."]
["IT Consulting","Helping businesses optimize technology use: IT strategy, software development, cybersecurity, cloud computing, and integration services."]
["Human Resources Consulting","Supporting companies with HR tasks: recruitment, training, engagement, performance, and labor law compliance."]
["Marketing Consulting","Assisting businesses with marketing: strategies, branding, research, digital and social media, and customer engagement."]
["Legal Consulting","Providing legal guidance: contracts, compliance, IP, regulations, and litigation support."]
["Real Estate Consulting","Guiding property investments, development, analysis, management, and feasibility studies."]
["Sales Consulting","Guiding sales strategies, CRM, training, and optimization for revenue growth."]

{"sheet":"Terms","index":5,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Terms"]
["Net 7"]
["Due upon receipt"]

{"sheet":"TOC","index":6,"n_rows":97,"n_cols":10,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[null,"Table of Contents"]
["Index","Sheet","Hyperlink","Invoice #","Printed","Invoice to","Date","Amount due","GST","Note"]
[8,{"$f":"IF(ISERROR(INDEX(SheetNames,A3))=TRUE,\"\",INDEX(SheetNames,A3))","v":"Invoice1"},{"$f":"HYPERLINK(\"#'\"&B3&\"'!A10\",\"Go To Sheet\")","v":"Go To Sheet"},1000,null,"TEMPLATE",null,null,null,"Enter the last invoice # from previous month"]
[{"$f":"A3+1","v":9},{"$f":"IF(ISERROR(INDEX(SheetNames,A4))=TRUE,\"\",INDEX(SheetNames,A4))","v":"1001"},{"$f":"HYPERLINK(\"#'\"&B4&\"'!A10\",\"Go To Sheet\")","v":"Go To Sheet"},{"$f":"D3+1","v":1001},null,{"$f":"IF(B4=\"\",\"\",(INDIRECT(\"'\"&B4&\"'!A11\")))","v":{"$error":"#REF!"}},{"$f":"IF(B4=\"\",\"\",(INDIRECT(\"'\"&B4&\"'!F4\")))","v":{"$error":"#REF!"}},{"$f":"IF(B4=\"\",\"\",(INDIRECT(\"'\"&B4&\"'!F38\")))","v":{"$error":"#REF!"}},{"$f":"IF(B4=\"\",\"\",(INDIRECT(\"'\"&B4&\"'!F37\")))","v":{"$error":"#REF!"}}]
[{"$f":"A4+1","v":10},{"$f":"IF(ISERROR(INDEX(SheetNames,A5))=TRUE,\"\",INDEX(SheetNames,A5))","v":"Invoice1 (2)"},{"$f":"HYPERLINK(\"#'\"&B5&\"'!A10\",\"Go To Sheet\")","v":"Go To Sheet"},{"$f":"D4+1","v":1002},null,{"$f":"IF(B5=\"\",\"\",(INDIRECT(\"'\"&B5&\"'!A11\")))","v":{"$error":"#REF!"}},{"$f":"IF(B5=\"\",\"\",(INDIRECT(\"'\"&B5&\"'!F4\")))","v":{"$error":"#REF!"}},{"$f":"IF(B5=\"\",\"\",(INDIRECT(\"'\"&B5&\"'!F38\")))","v":{"$error":"#REF!"}},{"$f":"IF(B5=\"\",\"\",(INDIRECT(\"'\"&B5&\"'!F37\")))","v":{"$error":"#REF!"}}]
[11,{"$f":"IF(ISERROR(INDEX(SheetNames,A6))=TRUE,\"\",INDEX(SheetNames,A6))","v":""},"Go To Sheet",1003,null,"","","",""]
[12,{"$f":"IF(ISERROR(INDEX(SheetNames,A7))=TRUE,\"\",INDEX(SheetNames,A7))","v":""},"Go To Sheet",1004,null,"","","",""]
[13,{"$f":"IF(ISERROR(INDEX(SheetNames,A8))=TRUE,\"\",INDEX(SheetNames,A8))","v":""},"Go To Sheet",1005,null,"","","",""]
[14,{"$f":"IF(ISERROR(INDEX(SheetNames,A9))=TRUE,\"\",INDEX(SheetNames,A9))","v":""},"Go To Sheet",1006,null,"","","",""]
[15,{"$f":"IF(ISERROR(INDEX(SheetNames,A10))=TRUE,\"\",INDEX(SheetNames,A10))","v":""},"Go To Sheet",1007,null,"","","",""]
[16,{"$f":"IF(ISERROR(INDEX(SheetNames,A11))=TRUE,\"\",INDEX(SheetNames,A11))","v":""},"Go To Sheet",1008,null,"","","",""]
[17,{"$f":"IF(ISERROR(INDEX(SheetNames,A12))=TRUE,\"\",INDEX(SheetNames,A12))","v":""},"Go To Sheet",1009,null,"","","",""]
[18,{"$f":"IF(ISERROR(INDEX(SheetNames,A13))=TRUE,\"\",INDEX(SheetNames,A13))","v":""},"Go To Sheet",1010,null,"","","",""]
[19,{"$f":"IF(ISERROR(INDEX(SheetNames,A14))=TRUE,\"\",INDEX(SheetNames,A14))","v":""},"Go To Sheet",1011,null,"","","",""]
[20,{"$f":"IF(ISERROR(INDEX(SheetNames,A15))=TRUE,\"\",INDEX(SheetNames,A15))","v":""},"Go To Sheet",1012,null,"","","",""]
[21,{"$f":"IF(ISERROR(INDEX(SheetNames,A16))=TRUE,\"\",INDEX(SheetNames,A16))","v":""},"Go To Sheet",1013,null,"","","",""]
[22,{"$f":"IF(ISERROR(INDEX(SheetNames,A17))=TRUE,\"\",INDEX(SheetNames,A17))","v":""},"Go To Sheet",1014,null,"","","",""]
[23,{"$f":"IF(ISERROR(INDEX(SheetNames,A18))=TRUE,\"\",INDEX(SheetNames,A18))","v":""},"Go To Sheet",1015,null,"","","",""]
[24,{"$f":"IF(ISERROR(INDEX(SheetNames,A19))=TRUE,\"\",INDEX(SheetNames,A19))","v":""},"Go To Sheet",1016,null,"","","",""]
[{"$f":"A19+1","v":25},{"$f":"IF(ISERROR(INDEX(SheetNames,A20))=TRUE,\"\",INDEX(SheetNames,A20))","v":""},"Go To Sheet",1017,null,"","","",""]
[26,{"$f":"IF(ISERROR(INDEX(SheetNames,A21))=TRUE,\"\",INDEX(SheetNames,A21))","v":""},"Go To Sheet",1018,null,"","","",""]
[27,{"$f":"IF(ISERROR(INDEX(SheetNames,A22))=TRUE,\"\",INDEX(SheetNames,A22))","v":""},"Go To Sheet",1019,null,"","","",""]
[28,{"$f":"IF(ISERROR(INDEX(SheetNames,A23))=TRUE,\"\",INDEX(SheetNames,A23))","v":""},"Go To Sheet",1020,null,"","","",""]
[29,{"$f":"IF(ISERROR(INDEX(SheetNames,A24))=TRUE,\"\",INDEX(SheetNames,A24))","v":""},"Go To Sheet",1021,null,"","","",""]
[30,{"$f":"IF(ISERROR(INDEX(SheetNames,A25))=TRUE,\"\",INDEX(SheetNames,A25))","v":""},"Go To Sheet",1022,null,"","","",""]
[31,{"$f":"IF(ISERROR(INDEX(SheetNames,A26))=TRUE,\"\",INDEX(SheetNames,A26))","v":""},"Go To Sheet",1023,null,"","","",""]
[32,{"$f":"IF(ISERROR(INDEX(SheetNames,A27))=TRUE,\"\",INDEX(SheetNames,A27))","v":""},"Go To Sheet",1024,null,"","","",""]
[33,{"$f":"IF(ISERROR(INDEX(SheetNames,A28))=TRUE,\"\",INDEX(SheetNames,A28))","v":""},"Go To Sheet",1025,null,"","","",""]
[34,{"$f":"IF(ISERROR(INDEX(SheetNames,A29))=TRUE,\"\",INDEX(SheetNames,A29))","v":""},"Go To Sheet",1026,null,"","","",""]
[35,{"$f":"IF(ISERROR(INDEX(SheetNames,A30))=TRUE,\"\",INDEX(SheetNames,A30))","v":""},"Go To Sheet",1027,null,"","","",""]
[36,{"$f":"IF(ISERROR(INDEX(SheetNames,A31))=TRUE,\"\",INDEX(SheetNames,A31))","v":""},"Go To Sheet",1028,null,"","","",""]
[37,{"$f":"IF(ISERROR(INDEX(SheetNames,A32))=TRUE,\"\",INDEX(SheetNames,A32))","v":""},"Go To Sheet",1029,null,"","","",""]
[38,{"$f":"IF(ISERROR(INDEX(SheetNames,A33))=TRUE,\"\",INDEX(SheetNames,A33))","v":""},"Go To Sheet",1030,null,"","","",""]
[39,{"$f":"IF(ISERROR(INDEX(SheetNames,A34))=TRUE,\"\",INDEX(SheetNames,A34))","v":""},"Go To Sheet",1031,null,"","","",""]
[40,{"$f":"IF(ISERROR(INDEX(SheetNames,A35))=TRUE,\"\",INDEX(SheetNames,A35))","v":""},"Go To Sheet",1032,null,"","","",""]
[41,{"$f":"IF(ISERROR(INDEX(SheetNames,A36))=TRUE,\"\",INDEX(SheetNames,A36))","v":""},"Go To Sheet",1033,null,"","","",""]
[42,{"$f":"IF(ISERROR(INDEX(SheetNames,A37))=TRUE,\"\",INDEX(SheetNames,A37))","v":""},"Go To Sheet",1034,null,"","","",""]
[43,{"$f":"IF(ISERROR(INDEX(SheetNames,A38))=TRUE,\"\",INDEX(SheetNames,A38))","v":""},"Go To Sheet",1035,null,"","","",""]
[44,{"$f":"IF(ISERROR(INDEX(SheetNames,A39))=TRUE,\"\",INDEX(SheetNames,A39))","v":""},"Go To Sheet",1036,null,"","","",""]
[45,{"$f":"IF(ISERROR(INDEX(SheetNames,A40))=TRUE,\"\",INDEX(SheetNames,A40))","v":""},"Go To Sheet",1037,null,"","","",""]
[46,{"$f":"IF(ISERROR(INDEX(SheetNames,A41))=TRUE,\"\",INDEX(SheetNames,A41))","v":""},"Go To Sheet",1038,null,"","","",""]
[47,{"$f":"IF(ISERROR(INDEX(SheetNames,A42))=TRUE,\"\",INDEX(SheetNames,A42))","v":""},"Go To Sheet",1039,null,"","","",""]
[48,{"$f":"IF(ISERROR(INDEX(SheetNames,A43))=TRUE,\"\",INDEX(SheetNames,A43))","v":""},"Go To Sheet",1040,null,"","","",""]
[49,{"$f":"IF(ISERROR(INDEX(SheetNames,A44))=TRUE,\"\",INDEX(SheetNames,A44))","v":""},"Go To Sheet",1041,null,"","","",""]
[50,{"$f":"IF(ISERROR(INDEX(SheetNames,A45))=TRUE,\"\",INDEX(SheetNames,A45))","v":""},"Go To Sheet",1042,null,"","","",""]
[51,{"$f":"IF(ISERROR(INDEX(SheetNames,A46))=TRUE,\"\",INDEX(SheetNames,A46))","v":""},"Go To Sheet",1043,null,"","","",""]
[52,{"$f":"IF(ISERROR(INDEX(SheetNames,A47))=TRUE,\"\",INDEX(SheetNames,A47))","v":""},"Go To Sheet",1044,null,"","","",""]
[53,{"$f":"IF(ISERROR(INDEX(SheetNames,A48))=TRUE,\"\",INDEX(SheetNames,A48))","v":""},"Go To Sheet",1045,null,"","","",""]
[54,{"$f":"IF(ISERROR(INDEX(SheetNames,A49))=TRUE,\"\",INDEX(SheetNames,A49))","v":""},"Go To Sheet",1046,null,"","","",""]
[55,{"$f":"IF(ISERROR(INDEX(SheetNames,A50))=TRUE,\"\",INDEX(SheetNames,A50))","v":""},"Go To Sheet",1047,null,"","","",""]
[56,{"$f":"IF(ISERROR(INDEX(SheetNames,A51))=TRUE,\"\",INDEX(SheetNames,A51))","v":""},"Go To Sheet",1048,null,"","","",""]
[57,{"$f":"IF(ISERROR(INDEX(SheetNames,A52))=TRUE,\"\",INDEX(SheetNames,A52))","v":""},"Go To Sheet",1049,null,"","","",""]
[58,{"$f":"IF(ISERROR(INDEX(SheetNames,A53))=TRUE,\"\",INDEX(SheetNames,A53))","v":""},"Go To Sheet",1050,null,"","","",""]
[59,{"$f":"IF(ISERROR(INDEX(SheetNames,A54))=TRUE,\"\",INDEX(SheetNames,A54))","v":""},"Go To Sheet",1051,null,"","","",""]
[60,{"$f":"IF(ISERROR(INDEX(SheetNames,A55))=TRUE,\"\",INDEX(SheetNames,A55))","v":""},"Go To Sheet",1052,null,"","","",""]
[61,{"$f":"IF(ISERROR(INDEX(SheetNames,A56))=TRUE,\"\",INDEX(SheetNames,A56))","v":""},"Go To Sheet",1053,null,"","","",""]
[62,{"$f":"IF(ISERROR(INDEX(SheetNames,A57))=TRUE,\"\",INDEX(SheetNames,A57))","v":""},"Go To Sheet",1054,null,"","","",""]
[63,{"$f":"IF(ISERROR(INDEX(SheetNames,A58))=TRUE,\"\",INDEX(SheetNames,A58))","v":""},"Go To Sheet",1055,null,"","","",""]
[64,{"$f":"IF(ISERROR(INDEX(SheetNames,A59))=TRUE,\"\",INDEX(SheetNames,A59))","v":""},"Go To Sheet",1056,null,"","","",""]
[65,{"$f":"IF(ISERROR(INDEX(SheetNames,A60))=TRUE,\"\",INDEX(SheetNames,A60))","v":""},"Go To Sheet",1057,null,"","","",""]
[66,{"$f":"IF(ISERROR(INDEX(SheetNames,A61))=TRUE,\"\",INDEX(SheetNames,A61))","v":""},"Go To Sheet",1058,null,"","","",""]
[67,{"$f":"IF(ISERROR(INDEX(SheetNames,A62))=TRUE,\"\",INDEX(SheetNames,A62))","v":""},"Go To Sheet",1059,null,"","","",""]
[68,{"$f":"IF(ISERROR(INDEX(SheetNames,A63))=TRUE,\"\",INDEX(SheetNames,A63))","v":""},"Go To Sheet",1060,null,"","","",""]
[69,{"$f":"IF(ISERROR(INDEX(SheetNames,A64))=TRUE,\"\",INDEX(SheetNames,A64))","v":""},"Go To Sheet",1061,null,"","","",""]
[70,{"$f":"IF(ISERROR(INDEX(SheetNames,A65))=TRUE,\"\",INDEX(SheetNames,A65))","v":""},"Go To Sheet",1062,null,"","","",""]
[71,{"$f":"IF(ISERROR(INDEX(SheetNames,A66))=TRUE,\"\",INDEX(SheetNames,A66))","v":""},"Go To Sheet",1063,null,"","","",""]
[72,{"$f":"IF(ISERROR(INDEX(SheetNames,A67))=TRUE,\"\",INDEX(SheetNames,A67))","v":""},"Go To Sheet",1064,null,"","","",""]
[73,{"$f":"IF(ISERROR(INDEX(SheetNames,A68))=TRUE,\"\",INDEX(SheetNames,A68))","v":""},"Go To Sheet",1065,null,"","","",""]
[74,{"$f":"IF(ISERROR(INDEX(SheetNames,A69))=TRUE,\"\",INDEX(SheetNames,A69))","v":""},{"$f":"HYPERLINK(\"#'\"&B69&\"'!A10\",\"Go To Sheet\")","v":"Go To Sheet"},{"$f":"D68+1","v":1066},null,{"$f":"IF(B69=\"\",\"\",(INDIRECT(\"'\"&B69&\"'!A11\")))","v":""},{"$f":"IF(B69=\"\",\"\",(INDIRECT(\"'\"&B69&\"'!F4\")))","v":""},{"$f":"IF(B69=\"\",\"\",(INDIRECT(\"'\"&B69&\"'!F38\")))","v":""},{"$f":"IF(B69=\"\",\"\",(INDIRECT(\"'\"&B69&\"'!F37\")))","v":""}]
[75,{"$f":"IF(ISERROR(INDEX(SheetNames,A70))=TRUE,\"\",INDEX(SheetNames,A70))","v":""},"Go To Sheet",1067,null,"","","",""]
[76,{"$f":"IF(ISERROR(INDEX(SheetNames,A71))=TRUE,\"\",INDEX(SheetNames,A71))","v":""},"Go To Sheet",1068,null,"","","",""]
[77,{"$f":"IF(ISERROR(INDEX(SheetNames,A72))=TRUE,\"\",INDEX(SheetNames,A72))","v":""},"Go To Sheet",1069,null,"","","",""]
[78,{"$f":"IF(ISERROR(INDEX(SheetNames,A73))=TRUE,\"\",INDEX(SheetNames,A73))","v":""},"Go To Sheet",1070,null,"","","",""]
[79,{"$f":"IF(ISERROR(INDEX(SheetNames,A74))=TRUE,\"\",INDEX(SheetNames,A74))","v":""},"Go To Sheet",1071,null,"","","",""]
[80,{"$f":"IF(ISERROR(INDEX(SheetNames,A75))=TRUE,\"\",INDEX(SheetNames,A75))","v":""},"Go To Sheet",1072,null,"","","",""]
[81,{"$f":"IF(ISERROR(INDEX(SheetNames,A76))=TRUE,\"\",INDEX(SheetNames,A76))","v":""},"Go To Sheet",1073,null,"","","",""]
[82,{"$f":"IF(ISERROR(INDEX(SheetNames,A77))=TRUE,\"\",INDEX(SheetNames,A77))","v":""},"Go To Sheet",1074,null,"","","",""]
[83,{"$f":"IF(ISERROR(INDEX(SheetNames,A78))=TRUE,\"\",INDEX(SheetNames,A78))","v":""},"Go To Sheet",1075,null,"","","",""]
[84,{"$f":"IF(ISERROR(INDEX(SheetNames,A79))=TRUE,\"\",INDEX(SheetNames,A79))","v":""},"Go To Sheet",1076,null,"","","",""]
[85,{"$f":"IF(ISERROR(INDEX(SheetNames,A80))=TRUE,\"\",INDEX(SheetNames,A80))","v":""},"Go To Sheet",1077,null,"","","",""]
[86,{"$f":"IF(ISERROR(INDEX(SheetNames,A81))=TRUE,\"\",INDEX(SheetNames,A81))","v":""},"Go To Sheet",1078,null,"","","",""]
[87,{"$f":"IF(ISERROR(INDEX(SheetNames,A82))=TRUE,\"\",INDEX(SheetNames,A82))","v":""},"Go To Sheet",1079,null,"","","",""]
[88,{"$f":"IF(ISERROR(INDEX(SheetNames,A83))=TRUE,\"\",INDEX(SheetNames,A83))","v":""},"Go To Sheet",1080,null,"","","",""]
[{"$f":"A83+1","v":89},{"$f":"IF(ISERROR(INDEX(SheetNames,A84))=TRUE,\"\",INDEX(SheetNames,A84))","v":""},"Go To Sheet",1081,null,"","","",""]
[90,{"$f":"IF(ISERROR(INDEX(SheetNames,A85))=TRUE,\"\",INDEX(SheetNames,A85))","v":""},"Go To Sheet",1082,null,"","","",""]
[91,{"$f":"IF(ISERROR(INDEX(SheetNames,A86))=TRUE,\"\",INDEX(SheetNames,A86))","v":""},"Go To Sheet",1083,null,"","","",""]
[92,{"$f":"IF(ISERROR(INDEX(SheetNames,A87))=TRUE,\"\",INDEX(SheetNames,A87))","v":""},"Go To Sheet",1084,null,"","","",""]
[93,{"$f":"IF(ISERROR(INDEX(SheetNames,A88))=TRUE,\"\",INDEX(SheetNames,A88))","v":""},"Go To Sheet",1085,null,"","","",""]
[94,{"$f":"IF(ISERROR(INDEX(SheetNames,A89))=TRUE,\"\",INDEX(SheetNames,A89))","v":""},"Go To Sheet",1086,null,"","","",""]
[95,{"$f":"IF(ISERROR(INDEX(SheetNames,A90))=TRUE,\"\",INDEX(SheetNames,A90))","v":""},"Go To Sheet",1087,null,"","","",""]
[96,{"$f":"IF(ISERROR(INDEX(SheetNames,A91))=TRUE,\"\",INDEX(SheetNames,A91))","v":""},"Go To Sheet",1088,null,"","","",""]
[97,{"$f":"IF(ISERROR(INDEX(SheetNames,A92))=TRUE,\"\",INDEX(SheetNames,A92))","v":""},"Go To Sheet",1089,null,"","","",""]
[98,{"$f":"IF(ISERROR(INDEX(SheetNames,A93))=TRUE,\"\",INDEX(SheetNames,A93))","v":""},"Go To Sheet",1090,null,"","","",""]
[99,{"$f":"IF(ISERROR(INDEX(SheetNames,A94))=TRUE,\"\",INDEX(SheetNames,A94))","v":""},"Go To Sheet",1091,null,"","","",""]
[100,{"$f":"IF(ISERROR(INDEX(SheetNames,A95))=TRUE,\"\",INDEX(SheetNames,A95))","v":""},"Go To Sheet",1092,null,"","","",""]
[101,{"$f":"IF(ISERROR(INDEX(SheetNames,A96))=TRUE,\"\",INDEX(SheetNames,A96))","v":""},"Go To Sheet",1093,null,"","","",""]
[102,{"$f":"IF(ISERROR(INDEX(SheetNames,A97))=TRUE,\"\",INDEX(SheetNames,A97))","v":""},"Go To Sheet",1094,null,"","","",""]

{"sheet":"Invoice1","index":7,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[[41,0,41,5]]}
[null,null,null,null,null,"INVOICE"]
[]
["From",null,null,"Invoice #",null,{"$f":"VLOOKUP((RIGHT(CELL(\"filename\"),LEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))),TOC!B:D,3,FALSE)","v":1000},null,{"$f":"HYPERLINK(\"[Invoices_template.xlsm]Invoice1!A2\",\"Go back\")","v":"Go back"}]
["Company Name",null,null,"Date"]
["Company Address",null,null,"Due date",null,{"$f":"IF(F4=\"\",\"\",F4+7)","v":""}]
["Company Address",null,null,"Terms",null,"Net 7"]
["Company GST number",null,null,"Project"]
["Company Email address"]
[]
["Invoice to"]
["Client business name"]
[{"$f":"IF(ISNA(VLOOKUP(A11,Client!A:B,2,FALSE))=TRUE,\"\",IF(VLOOKUP(A11,Client!A:B,2,FALSE)=\"\",\"\",VLOOKUP(A11,Client!A:B,2,FALSE)))","v":"Client Name"}]
[{"$f":"IF(ISNA(VLOOKUP(A11,Client!A:F,3,FALSE)&\" \"&VLOOKUP(A11,Client!A:F,4,FALSE)&\" \"&VLOOKUP(A11,Client!A:F,5,FALSE)&\" \"&VLOOKUP(A11,Client!A:F,6,FALSE))=TRUE,\"\",VLOOKUP(A11,Client!A:F,3,FALSE)&\" \"&VLOOKUP(A11,Client!A:F,4,FALSE)&\" \"&VLOOKUP(A11,Client!A:F,5,FALSE)&\" \"&VLOOKUP(A11,Client!A:F,6,FALSE))","v":"101 Hastings Street Vancouver V1Y 0J9 BC"}]
[]
[]
[]
["Description","Additional information","Notes\nif applicable","Rate","Unit","Total"]
[]
["Guiding organizations to boost performance and operational efficiency.","Streamlining processes and implementing improvements",{"$f":"IF(ISNA(VLOOKUP($A$11,Client!A:Z,7,FALSE))=TRUE,\"\",IF(A19=\"\",\"\",IF(VLOOKUP($A$11,Client!A:Z,7,FALSE)=\"\",\"\",(VLOOKUP($A$11,Client!A:Z,7,FALSE)))))","v":""},100,1,{"$f":"IF(D19=\"\",\"\",IF(D19<>\"\",IF(E19=\"\",D19,E19*D19)))","v":100}]
[null,null,null,null,null,{"$f":"IF(D20=\"\",\"\",IF(D20<>\"\",IF(E20=\"\",D20,E20*D20)))","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,"Subtotal",null,{"$f":"SUM(F19:F30)","v":100}]
[null,null,null,"GST","yes",{"$f":"IF(E34=\"yes\",F33*5%,0)","v":5}]
[null,null,null,"PST","no",{"$f":"IF(E35=\"yes\",F33*7%,0)","v":0}]
[]
[]
[null,null,null,"Amount due",null,{"$f":"SUM(F33:F35)","v":105}]
[]
[]
[]
["Thank You. We appreciate your business!"]
[]
[]
[]
["Terms and Conditions:"]
[]
["Please send payment within 7 days of receiving this invoice."]
[]
["Payment terms: cheque or e-transfer payable to:  "]