{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"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":"Sheet1","index":0,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[12,6,12,9],[12,11,12,14]]}
[]
[]
["INPUT TABLE1 (having some blank rows as well)",null,null,null,null,"INPUT TABLE2"]
["BL#_MAWB#","Invoice#",null,null,null,"Invoice#","NO_CTNS",null,"CBM_CH_WT"]
[null,null,null,null,null,"DS120529-LA-1-A",3.5,null,10]
[null,null,null,null,null,"DS-29-05-12",6.5,null,22]
[null,null,null,null,null,"DW20120529-02",8,null,11]
["ABC1","DS120529-LA-1-A",null,null,null,"DS120530-LA-1-A",4,null,12]
["ABC1","DS120529-LA-1-A",null,null,null,"DS1-29-05-12",3,null,16]
["XYZ1","DW20120529-02"]
["XYZ1","DW20120529-02"]
["XYZ1","DW20120529-02"]
["PQR1","DS-29-05-12",null,null,null,null,"DESIRED RESULT with formula",null,null,null,null,"DESIRED RESULT manual"]
["PQR1","DS-29-05-12",null,null,null,null,"BL#_MAWB#","NO_CTNS",null,"CBM_CH_WT",null,"BL#_MAWB#","NO_CTNS",null,"CBM_CH_WT"]
["PQR1","DS1-29-05-12",null,null,null,null,"ABC1",{"$f":"GetTotal(G15,$A$5:$B$21,$F$4:$G$9,2,0)","v":7.5},null,{"$f":"GetTotal(G15,$A$8:$B$18,$F$4:$I$9,2,0.5)","v":6.5},null,"ABC1",{"$f":"G5+G8","v":7.5},null,{"$f":"I5+I8","v":22}]
["ABC1","DS120530-LA-1-A",null,null,null,null,"PQR1",{"$f":"GetTotal(G16,$A$5:$B$21,$F$4:$G$9,2,0)","v":9.5},null,{"$f":"GetTotal(G16,$A$8:$B$18,$F$4:$I$9,2,0.5)","v":8.5},null,"PQR1",{"$f":"G6+G9","v":9.5},null,{"$f":"I6+I9","v":38}]
["XYZ1","DW20120529-02",null,null,null,null,"XYZ1",{"$f":"GetTotal(G17,$A$5:$B$21,$F$4:$G$9,2,0)","v":8},null,{"$f":"GetTotal(G17,$A$8:$B$18,$F$4:$I$9,2,0.5)","v":7.5},null,"XYZ1",{"$f":"G7","v":8},null,{"$f":"I7","v":11}]
["PQR1","DS-29-05-12"]

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

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}