{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Letter","SaleData"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Letter","index":0,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"00024"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sr.","Inv. No.","Require output from SaleData sheet","STI.No.","Inv.Date","Amount","Due Date"]
[null,{"$f":"INDEX(InvNo,SMALL(IF(SaleData!$A$2:$A$100=$L$1,ROW(SaleData!$A$2:$A$100)-ROW(SaleData!$A$2)+2),ROWS($B$22:B22)))","v":"GL/1415/C11008014"},"GL/1415/C11008014"]
[null,{"$f":"INDEX(InvNo,SMALL(IF(SaleData!$A$2:$A$100=$L$1,ROW(SaleData!$A$2:$A$100)-ROW(SaleData!$A$2)+2),ROWS($B$22:B23)))","v":"GL/1415/C11008015"},"GL/1415/C11008015"]
[null,{"$f":"INDEX(InvNo,SMALL(IF(SaleData!$A$2:$A$100=$L$1,ROW(SaleData!$A$2:$A$100)-ROW(SaleData!$A$2)+2),ROWS($B$22:B24)))","v":"GL/1415/C11008018"},"GL/1415/C11008018"]
[null,{"$f":"INDEX(InvNo,SMALL(IF(SaleData!$A$2:$A$100=$L$1,ROW(SaleData!$A$2:$A$100)-ROW(SaleData!$A$2)+2),ROWS($B$22:B25)))","v":"GL/1415/C11008020"},"GL/1415/C11008020"]
[null,{"$f":"INDEX(InvNo,SMALL(IF(SaleData!$A$2:$A$100=$L$1,ROW(SaleData!$A$2:$A$100)-ROW(SaleData!$A$2)+2),ROWS($B$22:B26)))","v":"GL/1415/C11008021"},"GL/1415/C11008021"]
[]
["Transporter Name",null,"L.R. Number",null,"L.R.Date","Destination"]

{"sheet":"SaleData","index":1,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Code","Name","Ord. No.","Ord.Date","Prod code","HP","RPM","Qty.","Inv. No.","STI.No.","Inv.Date","Amount","Due Date","Transporter Name","L.R. Number","L.R.Date","Destination"]
["00024",null,null,null,null,null,null,null,"GL/1415/C11008014"]
["00091",null,null,null,null,null,null,null,"GL/1415/C11008013"]
["00093",null,null,null,null,null,null,null,"GL/1415/C11008022"]
["00024",null,null,null,null,null,null,null,"GL/1415/C11008015"]
["00091",null,null,null,null,null,null,null,"GL/1415/C11008016"]
["00024",null,null,null,null,null,null,null,"GL/1415/C11008018"]
["00024",null,null,null,null,null,null,null,"GL/1415/C11008020"]
["00091",null,null,null,null,null,null,null,"GL/1415/C11008017"]
["00024",null,null,null,null,null,null,null,"GL/1415/C11008021"]