{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tool Room List","Aux"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":"Tool Room List","index":0,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"GRI","Air"]
[]
[]
[]
[null,"CCode","Loc","BCode","Description","VPN","Invty","Order","Ship","Return","Lost","Price","CostT","LostT"]
[null,"W1-802","B23","AIR0001","AIR CHIPPING HAMMER-(WITH CHISELS)","CH3",{"$f":"RANDBETWEEN(10,99)","v":47},45,99,98,25,360.2,{"$f":"Table1[[#This Row],[Ship]]*Table1[[#This Row],[Price]]","v":35659.799999999996},{"$f":"Table1[[#This Row],[Lost]]*Table1[[#This Row],[Price]]","v":9005}]
[null,"W1-400","R.R.","BME 001","SEED SPREADER",null,95,61,85,46,82,0,{"$f":"Table1[[#This Row],[Ship]]*Table1[[#This Row],[Price]]","v":0},{"$f":"Table1[[#This Row],[Lost]]*Table1[[#This Row],[Price]]","v":0}]
[null,"W1-400","CUB.1","CNS0001","DUCK TAPE \"ROLLS\"","ELE206",52,36,93,74,90,3.11,{"$f":"Table1[[#This Row],[Ship]]*Table1[[#This Row],[Price]]","v":289.22999999999996},{"$f":"Table1[[#This Row],[Lost]]*Table1[[#This Row],[Price]]","v":279.89999999999998}]
[null,"W1-802","B12","FIT0002","CHICAGO FITTINGS - Y","DIXAM10",78,22,48,89,49,9.9600000000000009,{"$f":"Table1[[#This Row],[Ship]]*Table1[[#This Row],[Price]]","v":478.08000000000004},{"$f":"Table1[[#This Row],[Lost]]*Table1[[#This Row],[Price]]","v":488.04}]
[null,"W1-400","B12","GRI0001","BURR BITS  - CHRISTMAS TREE 1/4\" ARBOR","DRI SG-1",27,56,79,57,61,6.78,{"$f":"Table1[[#This Row],[Ship]]*Table1[[#This Row],[Price]]","v":535.62},{"$f":"Table1[[#This Row],[Lost]]*Table1[[#This Row],[Price]]","v":413.58000000000004}]
[null,"W1-850","E31","HTL0001","ALLEN PACK (METRIC)","13609",46,10,23,99,84,8.44,{"$f":"Table1[[#This Row],[Ship]]*Table1[[#This Row],[Price]]","v":194.11999999999998},{"$f":"Table1[[#This Row],[Lost]]*Table1[[#This Row],[Price]]","v":708.95999999999992}]
[null,"W1-802","C26","LIT0001","BOILER LIGHT",null,76,85,84,99,91,0,{"$f":"Table1[[#This Row],[Ship]]*Table1[[#This Row],[Price]]","v":0},{"$f":"Table1[[#This Row],[Lost]]*Table1[[#This Row],[Price]]","v":0}]
[null,"Q1-250","F.CAB","QC0001","DYE CHECK - CLEANER","MAGNAFLUX",38,88,71,90,46,2.2400000000000002,{"$f":"Table1[[#This Row],[Ship]]*Table1[[#This Row],[Price]]","v":159.04000000000002},{"$f":"Table1[[#This Row],[Lost]]*Table1[[#This Row],[Price]]","v":103.04}]
[null,"W1-802","A12","RIG0001","BEAM CLAMP",null,73,26,34,80,67,0,{"$f":"Table1[[#This Row],[Ship]]*Table1[[#This Row],[Price]]","v":0},{"$f":"Table1[[#This Row],[Lost]]*Table1[[#This Row],[Price]]","v":0}]
[null,"W1-400","SAFE","STY0001","AIR MONITOR 4 GAS LEL,CO2,H2S,O2",null,61,66,33,73,73,0,{"$f":"Table1[[#This Row],[Ship]]*Table1[[#This Row],[Price]]","v":0},{"$f":"Table1[[#This Row],[Lost]]*Table1[[#This Row],[Price]]","v":0}]
[null,"W1-802","B00-C.C.","TIG0001","TIG RIG WP-17FV 25' COMPLETE W/50' GAS HOSE",null,98,94,76,88,77,0,{"$f":"Table1[[#This Row],[Ship]]*Table1[[#This Row],[Price]]","v":0},{"$f":"Table1[[#This Row],[Lost]]*Table1[[#This Row],[Price]]","v":0}]
[null,"W1-802","B42","WLD0001","ARC GOUGE RIG K3000",null,68,94,51,30,12,0,{"$f":"Table1[[#This Row],[Ship]]*Table1[[#This Row],[Price]]","v":0},{"$f":"Table1[[#This Row],[Lost]]*Table1[[#This Row],[Price]]","v":0}]
[null,"W1-802","B12","FIT0002","SEED",null,57,83,52,33,31,null,{"$f":"Table1[[#This Row],[Ship]]*Table1[[#This Row],[Price]]","v":0},{"$f":"Table1[[#This Row],[Lost]]*Table1[[#This Row],[Price]]","v":0}]
[null,"W1-802","B12","GRI0001","Clamp",null,{"$f":"RANDBETWEEN(10,99)","v":35},19,54,33,42,null,{"$f":"Table1[[#This Row],[Ship]]*Table1[[#This Row],[Price]]","v":0},{"$f":"Table1[[#This Row],[Lost]]*Table1[[#This Row],[Price]]","v":0}]
[null,"W1-802","E31","HTL0001","Duck",null,67,50,79,76,38,null,{"$f":"Table1[[#This Row],[Ship]]*Table1[[#This Row],[Price]]","v":0},{"$f":"Table1[[#This Row],[Lost]]*Table1[[#This Row],[Price]]","v":0}]
[null,"W1-802","C26","LIT0001","Dye",null,63,29,22,73,22,null,{"$f":"Table1[[#This Row],[Ship]]*Table1[[#This Row],[Price]]","v":0},{"$f":"Table1[[#This Row],[Lost]]*Table1[[#This Row],[Price]]","v":0}]
[null,"Total",null,{"$f":"SUBTOTAL(103,Table1[BCode])","v":16},null,null,{"$f":"SUBTOTAL(109,Table1[Invty])","v":981},{"$f":"SUBTOTAL(109,Table1[Order])","v":864},{"$f":"SUBTOTAL(109,Table1[Ship])","v":983},{"$f":"SUBTOTAL(109,Table1[Return])","v":1138},{"$f":"SUBTOTAL(109,Table1[Lost])","v":890},{"$f":"SUBTOTAL(109,Table1[Price])","v":390.72999999999996},{"$f":"SUBTOTAL(109,Table1[CostT])","v":37315.890000000007},{"$f":"SUBTOTAL(109,Table1[LostT])","v":10998.52}]

{"sheet":"Aux","index":1,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Term","Key"]
[null,"AIR","Duck"]
[null,"BME","Seed"]
[null,"CNS","Dye"]
[null,"FIT","Clamp"]
[null,"GRI","Bits"]
[null,"HTL","Air"]
[null,"LIT"]
[null,"QC"]
[null,"RIG"]
[null,"STY"]
[null,"TIG"]
[null,"WLD"]