{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Inventory - Stock Control","Inventory - Stock Track Sheet","Inventory - item Stock Sheet ","Inventory - Stock Vendor List"],"not_rendered":{"images":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Inventory - Stock Control","index":0,"n_rows":41,"n_cols":15,"rows_kept":41,"merged":[[1,1,2,5],[1,8,1,11],[1,13,1,14],[2,9,2,11],[40,2,40,13]]}
[]
[null,"INVENTORY - STOCK CONTROL",{"$nulls":6},"TOTAL INVENTORY VALUE",{"$nulls":4},"GRID KEY"]
[{"$nulls":8},{"$f":"SUM(Table14[TOTAL VALUE])","v":{"v":13550,"d":"$13,550.00"}},"*Based upon TOTAL VALUE fields below",{"$nulls":3},"DISCONTINUED","REORDER"]
[]
[null,"REORDER (auto-fill)","ITEM NO.","DATE OF LAST ORDER","ITEM NAME","VENDOR","STOCK LOCATION","DESCRIPTION","COST PER ITEM","STOCK QUANTITY","TOTAL VALUE","REORDER LEVEL","DAYS PER REORDER","ITEM REORDER QUANTITY","ITEM DISCONTINUED?"]
[null,{"$f":"IF(J6<L6,\"REORDER\",\"OK\")","v":"OK"},"A123","2018-05-20","ITEM A","Cole","Store Room A, Shelf 2","Item A Description",{"v":10,"d":"$10.00"},200,{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":2000,"d":"$2,000.00"}},50,14,100,"Yes"]
[null,"OK","B123","2018-05-20","ITEM B","Cole","Outdoor Pallet","Item B Description",{"v":20,"d":"$20.00"},100,{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":2000,"d":"$2,000.00"}},50,30,20]
[null,"REORDER","C123","2018-05-20","ITEM C","Cole","Basement, Shelf 4","Item C Description",{"v":30,"d":"$30.00"},45,{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":1350,"d":"$1,350.00"}},50,2,50]
[null,"REORDER","D123","2018-05-20","ITEM D","Cole","Store Room A, Shelf 2","Item D Description",{"v":10,"d":"$10.00"},25,{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":250,"d":"$250.00"}},50,14,10]
[null,"OK","E123","2018-05-20","ITEM E","Cole","Outdoor Pallet","Item E Description",{"v":20,"d":"$20.00"},200,{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":4000,"d":"$4,000.00"}},50,30,100]
[null,"OK","F123","2018-05-20","ITEM F","Cole","Basement, Shelf 4","Item F Description",{"v":30,"d":"$30.00"},100,{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":3000,"d":"$3,000.00"}},50,2,20]
[null,"REORDER","G123","2018-05-20","ITEM G","Cole","Store Room A, Shelf 2","Item G Description",{"v":10,"d":"$10.00"},45,{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":450,"d":"$450.00"}},50,14,50,"Yes"]
[null,"REORDER","H123","2018-05-20","ITEM H","Cole","Basement, Shelf 4","Item H Description",{"v":20,"d":"$20.00"},25,{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":500,"d":"$500.00"}},50,30,10]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"IF(J36<L36,\"REORDER\",\"OK\")","v":"OK"},{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[null,"OK",{"$nulls":8},{"$f":"Table14[[#This Row],[COST PER ITEM]]*Table14[[#This Row],[STOCK QUANTITY]]","v":{"v":0,"d":"$0.00"}}]
[]
[null,null,"CLICK HERE TO CREATE INVENTORY CONTROL TEMPLATES IN SMARTSHEET"]

{"sheet":"Inventory - Stock Track Sheet","index":1,"n_rows":14,"n_cols":12,"rows_kept":14,"merged":[[0,1,2,5],[4,1,4,3],[4,4,4,5],[4,6,4,8],[4,9,4,11]]}
[null,"INVENTORY - STOCK TRACK SHEET"]
[]
[{"$nulls":6},"DATE",null,null,"EMPLOYEE SIGNATURE"]
[]
[null,"ITEM",null,null,"STOCK LOCATION",null,"PURCHASE",null,null,"INVENTORY"]
[null,"ITEM NO.","ITEM NAME","DESCRIPTION","AREA","SHELF / BIN","VENDOR","VENDOR ITEM NO.","UNIT","QTY","ITEM AREA","ITEM SHELF / BIN"]
[null,"A123","ITEM A","Item A Description","Store Room A","Shelf 2","Cole","VA123","Each",10,"Store Room A","Shelf 2"]
["f","B123","ITEM B","Item B Description","Outdoor Pallet","Pallet 5","Cole","VB123","Pkg of 10",20,"Outdoor Pallet","Pallet 5"]
[null,"C123","ITEM C","Item C Description","Basement","Shelf 4","Cole","VC123","5 lbs",50,"Basement","Shelf 4"]
[null,"D123","ITEM D","Item D Description","Store Room A","Bin 7","Cole","VD123","Each",100,"Store Room A","Bin 7"]
[null,"E123","ITEM E","Item E Description","Outdoor Pallet","Shelf 2","Cole","VE123","Pkg of 10",10,"Outdoor Pallet","Shelf 2"]
[null,"F123","ITEM F","Item F Description","Basement","Pallet 5","Cole","VF123","5 lbs",20,"Basement","Pallet 5"]
[null,"G123","ITEM G","Item G Description","Store Room A","Shelf 4","Cole","VG123","Each",50,"Store Room A","Shelf 4"]
[null,"H123","ITEM H","Item H Description","Outdoor Pallet","Bin 7","Cole","VH123","Pkg of 10",100,"Outdoor Pallet","Bin 7"]

{"sheet":"Inventory - item Stock Sheet ","index":2,"n_rows":25,"n_cols":6,"rows_kept":25,"merged":[[0,1,2,5],[5,1,5,6],[6,2,6,6],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[14,1,14,6],[15,1,15,3],[15,4,15,6],[16,2,16,3],[16,5,16,6],[17,2,17,3],[17,5,17,6],[26,1,26,6]]}
[null,"INVENTORY - ITEM STOCK SHEET"]
[]
[]
[null,"Your Company Name"]
[]
[null,"ITEM INFO"]
[null,"ITEM NAME","ITEM A "]
[null,"ITEM NO.","A123"]
[null,"LOCATION","Store Room A, Shelf 2"]
[null,"PRICE",{"v":10,"d":"$10.00"}]
[null,"ITEM QUANTITY",200]
[null,"MATERIAL","-"]
[null,"DESCRIPTION","Item A Description"]
[]
[null,"EMPLOYEE INFO"]
[null,"COUNTED BY",null,null,"CHECKED BY"]
[null,"EMPLOYEE NAME","John Smith",null,"EMPLOYEE NAME","Chris Johnson"]
[null,"EMPLOYEE ID","XY123",null,"EMPLOYEE ID","XY456"]
[]
[]
[]
[]
[]
[]
[null,"DATE",null,null,"EMPLOYEE SIGNATURE"]

{"sheet":"Inventory - Stock Vendor List","index":3,"n_rows":6,"n_cols":16,"rows_kept":6,"merged":[[0,1,2,5],[3,1,3,6],[3,7,3,15]]}
[null,"INVENTORY - VENDOR LIST"]
[]
[]
[null,"VENDOR",{"$nulls":5},"CONTACT"]
[null,"VENDOR NAME","PRODUCT NAME","WEB LINK","DESCRIPTION","COST","LEAD TIME IN DAYS","CONTACT NAME","EMAIL ADDRESS","PHONE","FAX","MAILING ADDRESS","CITY","STATE","ZIP","COUNTRY"]
[null,"Cole","ITEM A","www.cole.com/itemA","Item A Description",{"v":10,"d":"$10.00"},15,"Ms. Kelly Thomas","kelly@cole.com","321-456-7890","321-456-7891","123 Main Street","Hamilton","OH","44416","USA"]