{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["Input","Processing","Output","Instructions"],"not_rendered":{"images":2,"macros":1,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Input","index":0,"n_rows":42,"n_cols":7,"rows_kept":42,"merged":[[0,0,0,2],[0,4,0,6],[1,0,1,2],[1,4,1,6],[2,0,2,2],[2,4,2,6],[3,0,3,2],[3,4,3,6]],"flags":["formulas_cached_only"]}
["Vendor:",{"$nulls":3},"Date:"]
[{"$nulls":3},"Invoice Number:"]
["Material Document Number:",{"$nulls":3},"Purchase Order Number:"]
[]
[]
["Quantity","DOT Number","Manufacturer   Number","Description","Unit Price","Total","Storage / Bin  Location"]
{"$rows_empty":32}
[{"$nulls":4},"Taxes"]
[{"$nulls":4},"Freight"]
[{"$nulls":4},"Additional Costs"]
[{"$nulls":4},"Total   >"]

{"sheet":"Processing","index":1,"n_rows":38,"n_cols":12,"rows_kept":38,"merged":[[1,4,2,4],[1,5,2,5],[1,9,1,10],[36,4,36,5],[37,4,37,5]],"flags":["formulas_cached_only"]}
[null,"                 THIS FORM WILL BE THE SOURCE TO KEY INVENTORY RECEIPTS USING FUNCTION ME21N"]
[{"$nulls":4},"Assigned Freight and Other Costs [By %Cost]","Assigned Freight and Other Costs [By %Quantity]",{"$nulls":3},"Extra Penny Check"]
["Quantity","Unit Price","Total","Assigned Taxes",null,null,"New Line Item Total","Unit Price Check","Total Check","Added Fraction","Round","Final Line Item Price"]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,"","","","","","","","",null,{"v":0,"d":"$0.00"},""]
[0,null,0,0,0,0,{"v":0,"d":"$0.00"},null,0,{"v":0,"d":"$0.0000000000"},null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"Freight and Other Cost Assignments"]
[{"$nulls":4},1]

{"sheet":"Output","index":2,"n_rows":43,"n_cols":7,"rows_kept":43,"merged":[[1,0,1,2],[1,4,1,6],[2,0,2,2],[2,4,2,6],[3,0,3,2],[3,4,3,6],[4,0,4,2],[4,4,4,6],[40,3,40,4],[41,2,41,4],[42,2,42,4]],"flags":["formulas_cached_only"]}
[{"$nulls":3},"Inventory Receipt Report - TD-21"]
["Vendor:",{"$nulls":3},"Date:"]
["",null,null,"Invoice Number:",""]
["Material Document Number:",null,null,"","Purchase Order Number:"]
["",{"$nulls":3},""]
[]
["Quantity","DOT Number","Manufacturer   Number","Description","Unit Price","Total","Storage / Bin  Location"]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
["","","","","","",""]
[0,"< Total Qty.",null,null,"Total   >",{"v":0,"d":"$0.00"}]
[{"$nulls":3},"Included Taxes",null,{"v":0,"d":"$0.00"}]
[null,null,"Included Freight Distributed by % of Total Cost",null,null,{"v":0,"d":"$0.00"}]
[null,null,"Included Additional Costs Distributed by % of Total Cost",null,null,{"v":0,"d":"$0.00"}]

{"sheet":"Instructions","index":3,"n_rows":1,"n_cols":6,"rows_kept":1,"merged":[[0,0,1,4],[0,5,1,9]],"flags":["formulas_cached_only"]}
["Automated TD-21 Template Instructions",{"$nulls":4},"Version 1.1: Thursday, October 21st 2010"]