{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["SETTINGS","PRODUCTS","CUSTOMERS","INVOICE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":18,"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":"SETTINGS","index":0,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"ENTER BUSINESS INFORMATION"]
[null,null,null,"Business Name:"]
[]
[null,null,null,"Shipping Address:"]
[]
[null,null,null,"Billing Address:"]
[]
[null,null,null,"Tag Line:"]
[]
[null,null,null,"Responsible Email:"]
[]
[null,null,null,"Responsible Sales Director : Mr. Yasser Albanna"]
[]
[null,null,null,"Website:"]

{"sheet":"PRODUCTS","index":1,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["PRODUCTS"]
["Product ID","Product Name","Product Description ","Sales Price","Unit of measurement","Choose NO if not taxable. Leave Blank if taxable","Rename & Use this field to store any information you would need"]
["AX CODE","Description Of The Item Group","Product Description ","PRICE","Quantity inside carton","TAXABLE","Group Code"]
["1090101","مستحضرات تجميل","شامبو",45.65,12,"NO","109"]
["1090102","مستحضرات تجميل","شاور",38.18,12,"NO","109"]
["1090103","مستحضرات تجميل","صابون",10.25,48,"NO","109"]
["1090104","مستحضرات تجميل","مسحوق",75.150000000000006,4,"NO","109"]

{"sheet":"CUSTOMERS","index":2,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["CUSTOMERS"]
[]
["ID","CUSTOMER NAME","DELIVERY ADDRESS","CUSTOMER ADDRESS","RECIPIENT NAME","RECIPIENT PHONE","COMPANYS OWNER NAME","COMPANYS OWNER PHONE"]

{"sheet":"INVOICE","index":3,"n_rows":105,"n_cols":10,"rows_kept":105,"cut":false,"hidden":false,"merged":[[12,7,13,9],[17,5,17,6],[19,5,19,6],[21,5,21,6],[3,1,3,10],[4,6,11,9],[23,5,23,6],[23,3,25,3],[92,8,92,9],[82,7,82,8],[84,7,84,8],[86,7,86,8],[87,7,87,8],[25,5,25,6],[92,4,92,5],[90,4,90,5],[84,2,88,5],[91,4,91,5],[91,8,91,9],[19,3,21,3]]}
[]
[]
[]
[null,"Invoice"]
[null,null,null,null,null,null,{"$f":"IF(LEN(I_BN)=0,\"\",I_BN)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(LEN(I_TAG)=0,\"\",I_TAG)","v":""}]
[]
[null,null,null,null,null,null,null,null,"Invoice NO:"]
[null,null,null,"CUSTOMER NAME"]
[null,null,null,null,null,null,"RECIPIENT NAME",null,null,"Invoice DATE"]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(T_PA[],MATCH(I_CUST,L_PA,0),MATCH(G17,T_PA[#Headers],0)),\"\")","v":""}]
[null,null,null,"DELIVERY ADDRESS",null,null,"RECIPIENT PHONE",null,null,"DELIVERY DATE"]
[null,null,null,{"$f":"IFERROR(INDEX(T_PA[],MATCH(I_CUST,L_PA,0),MATCH(D19,T_PA[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PA[],MATCH(I_CUST,L_PA,0),MATCH(G19,T_PA[#Headers],0)),\"\")","v":""}]
[null,null,null,null,null,null,"COMPANYS OWNER NAME",null,null,"PAYMENT DUE DATE"]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(T_PA[],MATCH(I_CUST,L_PA,0),MATCH(G21,T_PA[#Headers],0)),\"\")","v":""},null,null,null,"Cash"]
[null,null,null,"CUSTOMER ADDRESS",null,null,"COMPANYS OWNER PHONE"]
[null,null,null,{"$f":"IFERROR(INDEX(T_PA[],MATCH(I_CUST,L_PA,0),MATCH(D23,T_PA[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PA[],MATCH(I_CUST,L_PA,0),MATCH(G23,T_PA[#Headers],0)),\"\")","v":""}]
[]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(T_PA[],MATCH(I_CUST,L_PA,0),MATCH(G25,T_PA[#Headers],0)),\"\")","v":""}]
[]
[null,null,"AX CODE","Product Description ","Quantity inside carton","Quantity required by carton","Description Of The Item Group","Price of the carton","TAXABLE","AMOUNT BEFORE TAX"]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C29,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C29,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C29,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C29,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C29,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(IF($J$28=\"AMOUNT BEFORE TAX\",ROUND(IF(C29=\"\",\"\",F29*H29),2),ROUND(IF(C29=\"\",\"\",F29*H29*(1+IF(I29=\"NO\",0,I_TAXRATE))),2)),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C30,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C30,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C30,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C30,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C30,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C31,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C31,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C31,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C31,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C31,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C32,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C32,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C32,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C32,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C32,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C33,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C33,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C33,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C33,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C33,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C34,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C34,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C34,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C34,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C34,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C35,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C35,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C35,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C35,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C35,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C36,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C36,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""}," ",{"$f":"IFERROR(INDEX(T_PR[],MATCH($C36,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C36,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C36,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C37,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C37,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C37,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C37,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C37,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C38,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C38,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C38,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C38,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C38,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C39,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C39,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C39,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C39,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C39,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C40,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C40,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C40,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C40,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C40,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C41,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C41,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C41,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C41,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C41,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C42,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C42,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C42,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C42,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C42,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C43,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C43,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C43,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C43,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C43,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C44,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C44,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C44,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C44,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C44,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C45,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C45,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C45,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C45,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C45,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C46,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C46,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C46,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C46,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C46,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C47,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C47,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C47,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C47,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C47,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C48,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C48,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C48,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C48,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C48,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C49,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C49,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C49,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C49,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C49,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C50,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C50,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C50,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C50,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C50,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C51,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C51,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C51,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C51,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C51,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C52,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C52,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C52,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C52,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C52,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C53,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C53,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C53,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C53,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C53,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C54,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C54,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C54,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C54,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C54,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C55,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C55,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C55,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C55,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C55,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C56,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C56,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C56,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C56,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C56,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C57,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C57,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C57,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C57,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C57,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C58,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C58,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C58,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C58,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C58,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C59,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C59,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C59,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C59,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C59,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C60,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C60,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C60,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C60,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C60,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C61,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C61,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C61,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C61,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C61,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C62,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C62,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C62,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C62,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C62,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C63,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C63,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C63,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C63,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C63,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C64,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C64,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C64,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C64,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C64,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C65,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C65,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C65,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C65,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C65,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C66,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C66,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C66,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C66,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C66,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C67,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C67,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C67,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C67,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C67,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C68,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C68,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C68,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C68,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C68,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C69,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C69,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C69,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C69,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C69,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(IF($J$28=\"AMOUNT BEFORE TAX\",ROUND(IF(C69=\"\",\"\",F69*H69),2),ROUND(IF(C69=\"\",\"\",F69*H69*(1+IF(I69=\"NO\",0,I_TAXRATE))),2)),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C70,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C70,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C70,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C70,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C70,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C71,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C71,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C71,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C71,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C71,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C72,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C72,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C72,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C72,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C72,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C73,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C73,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C73,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C73,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C73,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C74,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C74,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C74,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C74,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C74,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C75,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C75,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C75,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C75,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C75,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C76,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C76,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C76,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C76,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C76,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C77,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C77,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C77,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C77,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C77,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C78,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C78,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C78,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C78,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C78,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C79,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C79,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C79,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C79,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C79,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C80,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C80,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C80,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C80,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C80,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C81,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C81,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C81,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C81,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C81,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C82,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(D$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[],MATCH($C82,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(E$28,T_PR[#Headers],0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_PR[],MATCH($C82,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0),MATCH(G$28,T_PR[#Headers],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[PRICE],MATCH($C82,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(T_PR[TAXABLE],MATCH($C82,INDEX(T_PR[],,MATCH($C$28,T_PR[#Headers],0)),0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"SUBTOTAL BEFORE TAX",null,{"$f":"IFERROR(ROUND(SUMPRODUCT(--(LEN($F$29:$F$82)>0),$H$29:$H$82,$F$29:$F$82),2),\"\")","v":0}]
[null,null,"NOTES:",null,null,null,null,"TAX RATE",null,{"$f":"IFERROR(ROUND(SUMPRODUCT(--(LEN($F$29:$F$82)>0),--($I$29:$I$82<>\"No\"),$H$29:$H$82,$F$29:$F$82)*I_TAXRATE,2),\"\")","v":0}]
[null,null,"Please contact if there are any questions. ",null,null,null,null,"SUBTOTAL + TAX",null,{"$f":"IFERROR(ROUND(J83+J84,2),\"\")","v":0}]
[null,null,null,null,null,null,null,"DISCOUNT %",null,{"$f":"IFERROR(-ROUND(IF(H86=\"DISCOUNT %\",I_DISCOUNT*J85,IF(H86=\"DISCOUNT AMT\",I_DISCOUNT,\"\")),2),\"\")","v":0}]
[null,null,null,null,null,null,null,"OTHER CHARGES"]
[null,null,null,null,null,null,null,"ORDER TOTAL",null,{"$f":"IFERROR(ROUND(J85+IF(J86=\"\",0,J86)+J87,2),\"\")","v":0}]
[]
[]
[null,null,null,null,"THANK YOU"]
[null,null,{"$f":"SETTINGS!D14","v":"Responsible Sales Director : Mr. Yasser Albanna"},null,{"$f":"SETTINGS!D16","v":"Website:"},null,null,null,{"$f":"SETTINGS!D12","v":"Responsible Email:"}]
[null,null,{"$f":"IF(LEN(I_PH)=0,\"\",I_PH)","v":""},null,{"$f":"IF(LEN(I_WB)=0,\"\",I_WB)","v":""},null,null,null,{"$f":"IF(LEN(I_EM)=0,\"\",I_EM)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"="]