{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["INVOICE DATA","CSV data"],"not_rendered":{"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"INVOICE DATA","index":0,"n_rows":63,"n_cols":19,"rows_kept":63,"merged":[[0,4,0,9],[0,11,0,14],[0,15,0,17],[1,0,1,6],[1,11,1,13],[1,15,1,17],[2,0,2,1],[2,2,2,4],[2,5,2,6],[2,16,2,17],[3,0,3,1],[3,2,3,4],[3,5,3,6],[3,7,3,9],[4,0,4,1],[4,2,4,4],[4,5,4,6],[4,7,4,9],[5,0,5,1],[5,2,5,4],[5,11,5,13],[6,5,6,6],[6,7,6,9],[7,0,7,6],[7,7,7,9],[8,2,8,6],[8,7,8,9],[8,11,8,13],[8,15,8,17],[9,0,9,9],[9,16,9,17],[10,0,10,1],[10,2,10,4],[10,5,10,6],[10,16,10,17],[11,0,11,1],[11,2,11,4],[11,5,11,6],[11,16,11,17],[12,0,12,1],[12,2,12,4],[12,5,12,6],[12,7,12,9],[12,16,12,17],[13,0,13,1],[13,2,13,4],[13,5,13,6],[13,7,13,9],[13,16,13,17],[14,16,14,17],[15,0,15,9],[15,16,15,17],[16,0,16,1],[16,5,16,6],[16,11,16,13],[16,16,16,17],[17,0,17,1],[17,5,17,6],[17,16,17,17],[18,0,18,1],[18,11,18,13],[18,16,18,17],[19,0,19,9],[19,16,19,17],[20,11,20,13],[20,15,20,17],[21,8,21,9],[21,11,21,13],[22,8,22,9],[22,11,22,13],[23,8,23,9],[23,11,23,13],[24,8,24,9],[24,11,24,13],[25,8,25,9],[25,11,25,13],[26,8,26,9],[26,11,26,13],[27,8,27,9],[27,11,27,13],[28,8,28,9],[28,11,28,13],[29,8,29,9],[29,11,29,13],[30,8,30,9],[30,11,30,13],[31,8,31,9],[31,11,31,13],[32,8,32,9],[32,11,32,13],[33,8,33,9],[33,11,33,13],[34,8,34,9],[34,11,34,13],[35,8,35,9],[35,11,35,13],[36,8,36,9],[36,11,36,13],[37,8,37,9],[37,11,37,13],[38,8,38,9],[38,11,38,13],[39,8,39,9],[39,11,39,13],[40,8,40,9],[40,11,40,13],[41,8,41,9],[41,11,41,13],[42,11,42,13],[43,8,43,9],[43,11,43,13],[44,8,44,9],[44,11,44,13],[45,11,45,13],[46,8,46,9],[46,11,46,13],[47,8,47,9],[47,11,47,13]]}
["THE EXCHANGE WEB INVOICE",{"$nulls":3},"VERSION: 15.08.26 (C:\\AAFES_WEBINV)"]
["Invoice Information:",{"$nulls":6},"MM","DD","YYYY",null,"Allowance Codes and Description",{"$nulls":3},"Product/Service ID Qualifier",null,null,{"$f":"TODAY()","v":"2018-11-15"}]
["Partner ID:",{"$nulls":4},"Invoice Date:",{"$nulls":6},"C000","Defective Allowance",null,"QUAL","ITEM ID",null,{"$f":"S2-1","v":"2018-11-14"}]
["Invoice Number:",{"$nulls":4},"Term Net Days:",{"$nulls":6},"H000","Special Allowance",null,"UP",12,"digit Universal Product Code (UPC)",{"$f":"S3-1","v":"2018-11-13"}]
["PO Number:",{"$nulls":4},"Term Due Date:",null,{"$f":"IF(ISBLANK(H3),\"\",NOW()+H4)","v":""},{"$nulls":4},"F800","Promotional Allowance",null,"UA",12,"digits UPC/EAN for Case (case UPC)","2018-11-12"]
["Invoice Amount($):",null,{"$f":"IF(ISBLANK(C5),\"\",SUM(H22:H48)-E17-E18-E19+J17+J18)","v":""},{"$nulls":4},{"$f":"IF(ISBLANK(C5),\"\",(C6*H7)/100)","v":""},{"$f":"IF(ISBLANK(C5),\"\",(C6-H6))","v":""},null,null,"Charge Codes and Description",{"$nulls":3},"EN",13,"digit Global Trade Item Number (GTIN)","2018-11-11"]
[{"$nulls":5},"Discount %:",{"$nulls":6},"G830","Shipping and Handling",null,"UK",14,"digit Global Trade Item Number (GTIN)","2018-11-10"]
["Discount Days Due (must not be greater than the Net Due Days) :",{"$nulls":11},"H090","Special Handling",null,"IB","13","digits International Standard Book Number (ISBN)","2018-11-09"]
[null,null,"Amount subject to terms discount($):",{"$nulls":4},{"$f":"IF(ISBLANK(C5),\"\",SUM(H22:H48)-E17-E18-E19+J17+J18)","v":""},{"$nulls":3},"Important Links",{"$nulls":3},"Instructions",null,null,"2018-11-08"]
["Billing and Shipping Information:",{"$nulls":14},"1.","Create AAFES_WEBINV folder on your drive C:",null,"2018-11-07"]
["PAY TO:",{"$nulls":4},"SHIP TO:",null,"MM","DD","YYYY",{"$nulls":5},"2.","All RED fields on the form are required",null,"2018-11-06"]
["Company Name:",{"$nulls":4},"Ship Date:",{"$nulls":9},"3.","If there are no Allowances or Charges please leave it blank",null,"2018-11-05"]
["DUNS:",{"$nulls":4},"AAFES Store Name:",{"$nulls":9},"4.","When lines items are completed click the  \"CLICK TO SAVE DATA",null,"2018-11-04"]
["Vendor Code (VC):",{"$nulls":4},"AAFES Store Number:",{"$nulls":10},"TO AAFES_WEBINV FOLDER\" button and select \"SAVE\" to save",null,"2018-11-03"]
[{"$nulls":16}," the \".TXT\" file to AAFES_WEBINV FOLDER",null,"2018-11-02"]
["Allowances and Charges:",{"$nulls":14},"5","Please click \"PRODUCTION MAILBOX\" (or TEST MAILBOX for test) ",null,"2018-11-01"]
["Allowance Code:",null,null,"Value($):",null,"Charge Code:",null,null,"Value($):",{"$nulls":7},"and \"sign in\" to \"Sterling\" with provided user ID and password.",null,"2018-10-31"]
["Allowance Code:",null,null,"Value($):",null,"Charge Code:",null,null,"Value($):",{"$nulls":6},"6","Browse AAFES_WEBINV folder on your C: to upload the \".TXT\" file",null,"2018-10-30"]
["Allowance Code:",null,null,"Value($):",{"$nulls":11},"7","DO NOT OPEN the .TXT file before uploading. It may affect ",null,"2018-10-29"]
["Line Items:",{"$nulls":15},"the contents of the file and your invoice will fail.",null,"2018-10-28"]
[null,null,"QUAL","ITEM ID","UOM","PRICE","QUANTITY","TOTAL",{"$nulls":3},"RED TAB BELOW INDICATES ERROR",{"$nulls":3},"E-mail Contacts / Facilities List",null,null,{"$f":"S20-1","v":"2018-10-27"}]
[{"$nulls":4},{"$f":"IF(ISBLANK(C22),\"\",IF(C22=\"UA\",\"CA\",\"EA\"))","v":""},null,null,{"$f":"IF(ISBLANK(G22),\"\",F22*G22)","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(C22),\"PLEASE START ON \"\"QUAL\"\" COLUMN\",IF(VLOOKUP(C22,$P$4:$Q$7,2,FALSE)=LEN(D22),\"\",\"QUAL=\"&UPPER(C22) & \", ITEM ID MUST BE \"& VLOOKUP(C22,$P$4:$Q$7,2,FALSE)&\" DIGITS\"))","v":"PLEASE START ON \"QUAL\" COLUMN"},{"$nulls":5},"EDIROLLOUTREQUEST@AAFES.COM",{"$f":"S21-1","v":"2018-10-26"}]
[{"$nulls":4},"",null,null,{"$f":"IF(ISBLANK(G23),\"\",F23*G23)","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(C23),\"\",IF(VLOOKUP(C23,$P$4:$Q$7,2,FALSE)=LEN(D23),\"\",\"QUAL=\"&UPPER(C23) & \", ITEM ID MUST BE \"& VLOOKUP(C23,$P$4:$Q$7,2,FALSE)&\" DIGITS\"))","v":""},{"$nulls":5},"AAFES FACILITIES (STORES) LIST","2018-10-25"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},{"$f":"IF(ISBLANK(C24),\"\",IF(VLOOKUP(C24,$P$4:$Q$7,2,FALSE)=LEN(D24),\"\",\"QUAL=\"&UPPER(C24) & \", ITEM ID MUST BE \"& VLOOKUP(C24,$P$4:$Q$7,2,FALSE)&\" DIGITS\"))","v":""},{"$nulls":6},"2018-10-24"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},{"$f":"IF(ISBLANK(C25),\"\",IF(VLOOKUP(C25,$P$4:$Q$7,2,FALSE)=LEN(D25),\"\",\"QUAL=\"&UPPER(C25) & \", ITEM ID MUST BE \"& VLOOKUP(C25,$P$4:$Q$7,2,FALSE)&\" DIGITS\"))","v":""},{"$nulls":6},"2018-10-23"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},"",{"$nulls":6},"2018-10-22"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},"",{"$nulls":6},"2018-10-21"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},"",{"$nulls":6},"2018-10-20"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},"",{"$nulls":6},"2018-10-19"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},"",{"$nulls":6},"2018-10-18"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},{"$f":"IF(ISBLANK(C31),\"\",IF(VLOOKUP(C31,$P$4:$Q$7,2,FALSE)=LEN(D31),\"\",\"QUAL=\"&UPPER(C31) & \", ITEM ID MUST BE \"& VLOOKUP(C31,$P$4:$Q$7,2,FALSE)&\" DIGITS\"))","v":""},{"$nulls":6},"2018-10-17"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},"",{"$nulls":6},"2018-10-16"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},"",{"$nulls":6},"2018-10-15"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},"",{"$nulls":6},"2018-10-14"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},"",{"$nulls":6},"2018-10-13"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},"",{"$nulls":6},"2018-10-12"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},"",{"$nulls":6},"2018-10-11"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},"",{"$nulls":6},"2018-10-10"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},"",{"$nulls":6},"2018-10-09"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},"",{"$nulls":6},"2018-10-08"]
[{"$nulls":4},{"$f":"IF(ISBLANK(C41),\"\",IF(C41=\"UA\",\"CA\",\"EA\"))","v":""},null,null,{"$f":"IF(ISBLANK(G41),\"\",F41*G41)","v":""},{"$nulls":3},"",{"$nulls":6},"2018-10-07"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},"",{"$nulls":6},"2018-10-06"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},{"$f":"IF(ISBLANK(C46),\"\",IF(VLOOKUP(C46,$P$4:$Q$7,2,FALSE)=LEN(D46),\"\",\"QUAL=\"&UPPER(C46) & \", ITEM ID MUST BE \"& VLOOKUP(C46,$P$4:$Q$7,2,FALSE)&\" DIGITS\"))","v":""},{"$nulls":6},"2018-10-05"]
[{"$nulls":4},"",null,null,"",{"$nulls":3},"",{"$nulls":6},{"$f":"S43-1","v":"2018-10-04"}]
[{"$nulls":4},"",null,null,"",{"$nulls":3},"",{"$nulls":6},"2018-10-03"]
[{"$nulls":18},"2018-10-02"]
[{"$nulls":4},"",null,null,{"$f":"IF(ISBLANK(G47),\"\",F47*G47)","v":""},{"$nulls":10},"2018-10-01"]
[{"$nulls":4},"",null,null,{"$f":"IF(ISBLANK(G48),\"\",F48*G48)","v":""},{"$nulls":10},"2018-09-30"]
[{"$nulls":18},"2018-09-29"]
[{"$nulls":18},"2018-09-28"]
[{"$nulls":18},"2018-09-27"]
[{"$nulls":18},"2018-09-26"]
[{"$nulls":18},"2018-09-25"]
[{"$nulls":18},"2018-09-24"]
[{"$nulls":18},"2018-09-23"]
[{"$nulls":18},"2018-09-22"]
[{"$nulls":18},"2018-09-21"]
[{"$nulls":18},"2018-09-20"]
[{"$nulls":18},"2018-09-19"]
[{"$nulls":18},"2018-09-18"]
[{"$nulls":18},"2018-09-17"]
[{"$nulls":18},"2018-09-16"]
[{"$nulls":18},{"$f":"S62-1","v":"2018-09-15"}]

{"sheet":"CSV data","index":1,"n_rows":32,"n_cols":9,"rows_kept":32,"hidden":true}
["INVHDR",{"$f":"IF(ISBLANK('INVOICE DATA'!C4),\"\",UPPER('INVOICE DATA'!C4))","v":""},{"$f":"MID('INVOICE DATA'!$J$3,3,2)&'INVOICE DATA'!$H$3&'INVOICE DATA'!$I$3 & \" 000000\"","v":" 000000"},{"$f":"IF(ISBLANK('INVOICE DATA'!C5),\"\",'INVOICE DATA'!C5)","v":""},{"$f":"IF(ISBLANK('INVOICE DATA'!C3),\"\",UPPER('INVOICE DATA'!C3))","v":""},{"$f":"UPPER('INVOICE DATA'!C12)","v":""},{"$f":"'INVOICE DATA'!C13","v":0},{"$f":"'INVOICE DATA'!C14","v":0},{"$f":"'INVOICE DATA'!$H$12&'INVOICE DATA'!$I$12&'INVOICE DATA'!$J$12","v":""}]
["INVDTL",{"$f":"UPPER('INVOICE DATA'!H13)","v":""},{"$f":"IF(ISBLANK('INVOICE DATA'!H14),\"\",'INVOICE DATA'!H14)","v":""},{"$f":"'INVOICE DATA'!C6","v":""},{"$f":"IF(ISBLANK('INVOICE DATA'!H9), \"n\",'INVOICE DATA'!H9)","v":""},{"$f":"IF(ISBLANK('INVOICE DATA'!I6),\"\",'INVOICE DATA'!I6)","v":""},{"$f":"IF(ISBLANK('INVOICE DATA'!H6),\"\",'INVOICE DATA'!H6)","v":""},"n","n"]
["INVDSC","01",{"$f":"IF(ISBLANK('INVOICE DATA'!H8),\"0\",'INVOICE DATA'!H8)","v":"0"},{"$f":"IF(ISBLANK('INVOICE DATA'!H7),\"0.00\",'INVOICE DATA'!H7)","v":"0.00"},{"$f":"IF(ISBLANK('INVOICE DATA'!H4),\"\",'INVOICE DATA'!H4)","v":""},"n","n","n","n"]
["ALWCHG",{"$f":"IF(ISBLANK('INVOICE DATA'!C17),\"NONE\",\"A\")","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!C17),\"\",'INVOICE DATA'!C17)","v":""},{"$f":"IF(ISBLANK('INVOICE DATA'!C17),\"\",'INVOICE DATA'!E17)","v":""},"n","n","n","n","n"]
["ALWCHG",{"$f":"IF(ISBLANK('INVOICE DATA'!C18),\"NONE\",\"A\")","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!C18),\"\",'INVOICE DATA'!C18)","v":""},{"$f":"IF(ISBLANK('INVOICE DATA'!C18),\"\",'INVOICE DATA'!E18)","v":""},"n","n","n","n","n"]
["ALWCHG",{"$f":"IF(ISBLANK('INVOICE DATA'!C19),\"NONE\",\"A\")","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!C19),\"\",'INVOICE DATA'!C19)","v":""},{"$f":"IF(ISBLANK('INVOICE DATA'!C19),\"\",'INVOICE DATA'!E19)","v":""},"n","n","n","n","n"]
["ALWCHG",{"$f":"IF(ISBLANK('INVOICE DATA'!H17),\"NONE\",\"C\")","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!H17),\"\",'INVOICE DATA'!H17)","v":""},{"$f":"IF(ISBLANK('INVOICE DATA'!H17),\"\",'INVOICE DATA'!J17)","v":""},"n","n","n","n","n"]
["ALWCHG",{"$f":"IF(ISBLANK('INVOICE DATA'!H18),\"NONE\",\"C\")","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!H18),\"\",'INVOICE DATA'!H18)","v":""},{"$f":"IF(ISBLANK('INVOICE DATA'!H18),\"\",'INVOICE DATA'!J18)","v":""},"n","n","n","n","n"]
["INVITM",{"$f":"IF(ISBLANK('INVOICE DATA'!C22),\"NONE\",UPPER('INVOICE DATA'!C22))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D22),\"\",'INVOICE DATA'!D22)","v":""},{"$f":"IF(ISBLANK(C9),\"\",UPPER('INVOICE DATA'!E22))","v":""},{"$f":"IF(LEN($D9)=2,'INVOICE DATA'!F22,\"\")","v":""},{"$f":"IF(LEN($D9)=2,'INVOICE DATA'!G22,\"\")","v":""},"n","n","n"]
[{"$f":"IF(LEN($D10)= 2,\"INVITM\",\"\")","v":""},{"$f":"IF(ISBLANK('INVOICE DATA'!C23),\"NONE\",UPPER('INVOICE DATA'!C23))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D23),\"\",'INVOICE DATA'!D23)","v":""},{"$f":"IF(ISBLANK(C10),\"\",UPPER('INVOICE DATA'!E23))","v":""},{"$f":"IF(LEN($D10)=2,'INVOICE DATA'!F23,\"\")","v":""},{"$f":"IF(LEN($D10)=2,'INVOICE DATA'!G23,\"\")","v":""},"n","n","n"]
[{"$f":"IF(LEN($D11)= 2,\"INVITM\",\"\")","v":""},{"$f":"IF(ISBLANK('INVOICE DATA'!C24),\"NONE\",UPPER('INVOICE DATA'!C24))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D24),\"\",'INVOICE DATA'!D24)","v":""},{"$f":"IF(ISBLANK(C11),\"\",UPPER('INVOICE DATA'!E24))","v":""},{"$f":"IF(LEN($D11)=2,'INVOICE DATA'!F24,\"\")","v":""},{"$f":"IF(LEN($D11)=2,'INVOICE DATA'!G24,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C25),\"NONE\",UPPER('INVOICE DATA'!C25))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D25),\"\",'INVOICE DATA'!D25)","v":""},{"$f":"IF(ISBLANK(C12),\"\",UPPER('INVOICE DATA'!E25))","v":""},{"$f":"IF(LEN($D12)=2,'INVOICE DATA'!F25,\"\")","v":""},{"$f":"IF(LEN($D12)=2,'INVOICE DATA'!G25,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C26),\"NONE\",UPPER('INVOICE DATA'!C26))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D26),\"\",'INVOICE DATA'!D26)","v":""},{"$f":"IF(ISBLANK(C13),\"\",UPPER('INVOICE DATA'!E26))","v":""},{"$f":"IF(LEN($D13)=2,'INVOICE DATA'!F26,\"\")","v":""},{"$f":"IF(LEN($D13)=2,'INVOICE DATA'!G26,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C27),\"NONE\",UPPER('INVOICE DATA'!C27))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D27),\"\",'INVOICE DATA'!D27)","v":""},{"$f":"IF(ISBLANK(C14),\"\",UPPER('INVOICE DATA'!E27))","v":""},{"$f":"IF(LEN($D14)=2,'INVOICE DATA'!F27,\"\")","v":""},{"$f":"IF(LEN($D14)=2,'INVOICE DATA'!G27,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C28),\"NONE\",UPPER('INVOICE DATA'!C28))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D28),\"\",'INVOICE DATA'!D28)","v":""},{"$f":"IF(ISBLANK(C15),\"\",UPPER('INVOICE DATA'!E28))","v":""},{"$f":"IF(LEN($D15)=2,'INVOICE DATA'!F28,\"\")","v":""},{"$f":"IF(LEN($D15)=2,'INVOICE DATA'!G28,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C29),\"NONE\",UPPER('INVOICE DATA'!C29))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D29),\"\",'INVOICE DATA'!D29)","v":""},{"$f":"IF(ISBLANK(C16),\"\",UPPER('INVOICE DATA'!E29))","v":""},{"$f":"IF(LEN($D16)=2,'INVOICE DATA'!F29,\"\")","v":""},{"$f":"IF(LEN($D16)=2,'INVOICE DATA'!G29,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C30),\"NONE\",UPPER('INVOICE DATA'!C30))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D30),\"\",'INVOICE DATA'!D30)","v":""},{"$f":"IF(ISBLANK(C17),\"\",UPPER('INVOICE DATA'!E30))","v":""},{"$f":"IF(LEN($D17)=2,'INVOICE DATA'!F30,\"\")","v":""},{"$f":"IF(LEN($D17)=2,'INVOICE DATA'!G30,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C31),\"NONE\",UPPER('INVOICE DATA'!C31))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D31),\"\",'INVOICE DATA'!D31)","v":""},{"$f":"IF(ISBLANK(C18),\"\",UPPER('INVOICE DATA'!E31))","v":""},{"$f":"IF(LEN($D18)=2,'INVOICE DATA'!F31,\"\")","v":""},{"$f":"IF(LEN($D18)=2,'INVOICE DATA'!G31,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C32),\"NONE\",UPPER('INVOICE DATA'!C32))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D32),\"\",'INVOICE DATA'!D32)","v":""},{"$f":"IF(ISBLANK(C19),\"\",UPPER('INVOICE DATA'!E32))","v":""},{"$f":"IF(LEN($D19)=2,'INVOICE DATA'!F32,\"\")","v":""},{"$f":"IF(LEN($D19)=2,'INVOICE DATA'!G32,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C33),\"NONE\",UPPER('INVOICE DATA'!C33))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D33),\"\",'INVOICE DATA'!D33)","v":""},{"$f":"IF(ISBLANK(C20),\"\",UPPER('INVOICE DATA'!E33))","v":""},{"$f":"IF(LEN($D20)=2,'INVOICE DATA'!F33,\"\")","v":""},{"$f":"IF(LEN($D20)=2,'INVOICE DATA'!G33,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C34),\"NONE\",UPPER('INVOICE DATA'!C34))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D34),\"\",'INVOICE DATA'!D34)","v":""},{"$f":"IF(ISBLANK(C21),\"\",UPPER('INVOICE DATA'!E34))","v":""},{"$f":"IF(LEN($D21)=2,'INVOICE DATA'!F34,\"\")","v":""},{"$f":"IF(LEN($D21)=2,'INVOICE DATA'!G34,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C35),\"NONE\",UPPER('INVOICE DATA'!C35))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D35),\"\",'INVOICE DATA'!D35)","v":""},{"$f":"IF(ISBLANK(C22),\"\",UPPER('INVOICE DATA'!E35))","v":""},{"$f":"IF(LEN($D22)=2,'INVOICE DATA'!F35,\"\")","v":""},{"$f":"IF(LEN($D22)=2,'INVOICE DATA'!G35,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C36),\"NONE\",UPPER('INVOICE DATA'!C36))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D36),\"\",'INVOICE DATA'!D36)","v":""},{"$f":"IF(ISBLANK(C23),\"\",UPPER('INVOICE DATA'!E36))","v":""},{"$f":"IF(LEN($D23)=2,'INVOICE DATA'!F36,\"\")","v":""},{"$f":"IF(LEN($D23)=2,'INVOICE DATA'!G36,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C37),\"NONE\",UPPER('INVOICE DATA'!C37))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D37),\"\",'INVOICE DATA'!D37)","v":""},{"$f":"IF(ISBLANK(C24),\"\",UPPER('INVOICE DATA'!E37))","v":""},{"$f":"IF(LEN($D24)=2,'INVOICE DATA'!F37,\"\")","v":""},{"$f":"IF(LEN($D24)=2,'INVOICE DATA'!G37,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C38),\"NONE\",UPPER('INVOICE DATA'!C38))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D38),\"\",'INVOICE DATA'!D38)","v":""},{"$f":"IF(ISBLANK(C25),\"\",UPPER('INVOICE DATA'!E38))","v":""},{"$f":"IF(LEN($D25)=2,'INVOICE DATA'!F38,\"\")","v":""},{"$f":"IF(LEN($D25)=2,'INVOICE DATA'!G38,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C39),\"NONE\",UPPER('INVOICE DATA'!C39))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D39),\"\",'INVOICE DATA'!D39)","v":""},{"$f":"IF(ISBLANK(C26),\"\",UPPER('INVOICE DATA'!E39))","v":""},{"$f":"IF(LEN($D26)=2,'INVOICE DATA'!F39,\"\")","v":""},{"$f":"IF(LEN($D26)=2,'INVOICE DATA'!G39,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C40),\"NONE\",UPPER('INVOICE DATA'!C40))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D40),\"\",'INVOICE DATA'!D40)","v":""},{"$f":"IF(ISBLANK(C27),\"\",UPPER('INVOICE DATA'!E40))","v":""},{"$f":"IF(LEN($D27)=2,'INVOICE DATA'!F40,\"\")","v":""},{"$f":"IF(LEN($D27)=2,'INVOICE DATA'!G40,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C41),\"NONE\",UPPER('INVOICE DATA'!C41))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D41),\"\",'INVOICE DATA'!D41)","v":""},{"$f":"IF(ISBLANK(C28),\"\",UPPER('INVOICE DATA'!E41))","v":""},{"$f":"IF(LEN($D28)=2,'INVOICE DATA'!F41,\"\")","v":""},{"$f":"IF(LEN($D28)=2,'INVOICE DATA'!G41,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C42),\"NONE\",UPPER('INVOICE DATA'!C42))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D42),\"\",'INVOICE DATA'!D42)","v":""},{"$f":"IF(ISBLANK(C29),\"\",UPPER('INVOICE DATA'!E42))","v":""},{"$f":"IF(LEN($D29)=2,'INVOICE DATA'!F42,\"\")","v":""},{"$f":"IF(LEN($D29)=2,'INVOICE DATA'!G42,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C43),\"NONE\",UPPER('INVOICE DATA'!C43))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D43),\"\",'INVOICE DATA'!D43)","v":""},{"$f":"IF(ISBLANK(C30),\"\",UPPER('INVOICE DATA'!E43))","v":""},{"$f":"IF(LEN($D30)=2,'INVOICE DATA'!F43,\"\")","v":""},{"$f":"IF(LEN($D30)=2,'INVOICE DATA'!G43,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C44),\"NONE\",UPPER('INVOICE DATA'!C44))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D44),\"\",'INVOICE DATA'!D44)","v":""},{"$f":"IF(ISBLANK(C31),\"\",UPPER('INVOICE DATA'!E44))","v":""},{"$f":"IF(LEN($D31)=2,'INVOICE DATA'!F44,\"\")","v":""},{"$f":"IF(LEN($D31)=2,'INVOICE DATA'!G44,\"\")","v":""},"n","n","n"]
["",{"$f":"IF(ISBLANK('INVOICE DATA'!C45),\"NONE\",UPPER('INVOICE DATA'!C45))","v":"NONE"},{"$f":"IF(ISBLANK('INVOICE DATA'!D45),\"\",'INVOICE DATA'!D45)","v":""},{"$f":"IF(ISBLANK(C32),\"\",UPPER('INVOICE DATA'!E45))","v":""},{"$f":"IF(LEN($D32)=2,'INVOICE DATA'!F45,\"\")","v":""},{"$f":"IF(LEN($D32)=2,'INVOICE DATA'!G45,\"\")","v":""},"n","n","n"]