{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,{"$f":"MATCH(E12,Table_ExternalData_18[SHPONO],0)","v":2}]
[]
[]
[]
[]
[]
[]
[null,"ACCOUNT NUMBER","ORDER NUMBER","ORDER DATE","PO NUMBER"]
[null,111684,{"$f":"INDEX(Table_ExternalData_18[SHUS02],$B$4)","v":"54525013-001"},{"$f":"TODAY()","v":"2020-03-25"},"4248635"]
[]
[]
[]
[null,"SOLD TO: ",null,{"$f":"INDEX(Table_ExternalData_18[SHSNAM],$B$4)","v":"Jack Crown"}]
[null,{"$f":"INDEX(Table_ExternalData_18[SHSNAM],$B$4)","v":"Jack Crown"},null,{"$f":"INDEX(Table_ExternalData_18[SHSAD1],$B$4)","v":"456 Uphill Way"}]
[null,{"$f":"INDEX(Table_ExternalData_18[SHSAD1],$B$4)","v":"456 Uphill Way"},null,{"$f":"INDEX(Table_ExternalData_18[SHSAD2],$B$4)","v":""}]
[null,{"$f":"INDEX(Table_ExternalData_18[SHSAD2],$B$4)","v":""},null,{"$f":"INDEX(Table_ExternalData_18[Column1],$B$4)","v":"KEIZER, OR 97303"}]
[null,{"$f":"INDEX(Table_ExternalData_18[Column1],$B$4)","v":"KEIZER, OR 97303"}]
[]
[]
[]
["QTY","ITEM NUMBER","DESCRIPTION","UNIT PRICE","AMOUNT"]
[{"$f":"INDEX(Table_ExternalData_18[SDQYOR],$B$4)","v":1},{"$f":"INDEX(Table_ExternalData_18[SDITEM],$B$4)","v":"017941R"},{"$f":"INDEX(Table_ExternalData_18[SDDESC],$B$4)","v":"FIGURINE, SPIDERMAN-WEBSLINGER-MV2"},{"$f":"VLOOKUP($B$25,Sheet3!A:B,2,FALSE)","v":199.99},{"$f":"A25*D25","v":199.99}]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total Amount",{"$f":"SUM(E25:E31)","v":199.99}]
[]
[]
[]
[null,null,null,"For order inquiries, please contact"]
[]
[]
[null,null,null,"Guest.Services@shopdisney.com"]

{"sheet":"Sheet2","index":1,"n_rows":3,"n_cols":15,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["SHRCID","SHSNAM","SHSAD1","SHSAD2","SHSAD3","SHSCTY","SHSSTE","SHSZIP","SHPONO","SDQYOR","SDUPRC","SDDESC","SDITEM","SHUS02","Column1"]
["","Mary Mary","123 Quite Contrary Road","","","MURFREESBORO","TN",37128,"4247272",1,54.45,"FIGURINE, STORM TROOPER","017862R","54516148-001",{"$f":"F2&\", \"&G2&\" \"&H2","v":"MURFREESBORO, TN 37128"}]
["","Jack Crown","456 Uphill Way","","","KEIZER","OR",97303,"4248635",1,110,"FIGURINE, SPIDERMAN-WEBSLINGER-MV2","017941R","54525013-001","KEIZER, OR 97303"]

{"sheet":"Sheet3","index":2,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["017982R",950]
["016021R",49.99]
["ES7069A",299.99]
["ES6970B",299.99]
["ES2970C",299.99]
["017919",299.99]
["017926",449.99]
["017861R",99.99]
["017863R",99.99]
["017862R",99.99]
["016819R",129]
["016812R",299.99]
["016808R",129.99]
["017933",549.99]
["016830",179.99]
["017927E",499.99]
["017937R",499.99]
["017940R",199.99]
["017938",499.99]
["017923",699.99]
["017922E",699.99]
["017941R",199.99]
["017939R",224.99]
["017921",699.99]
["ES6970C",299.99]