{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["STOCK ANALYSIS"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"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":"STOCK ANALYSIS","index":0,"n_rows":117,"n_cols":13,"rows_kept":117,"cut":false,"hidden":false,"merged":[[23,9,23,10],[23,11,23,12],[53,2,53,3],[54,2,54,3],[47,2,47,3],[23,3,23,4],[23,5,23,6],[45,2,45,3],[23,7,23,8],[46,2,46,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[86,2,86,3],[87,2,87,3],[88,2,88,3],[79,2,79,3],[80,2,80,3],[67,2,67,3],[68,2,68,3],[69,2,69,3],[105,2,105,3],[106,2,106,3],[94,2,94,3],[76,2,76,3],[77,2,77,3],[78,2,78,3],[75,2,75,3],[70,2,70,3],[71,2,71,3],[72,2,72,3],[73,2,73,3],[74,2,74,3],[85,2,85,3],[116,2,116,3],[117,2,117,3],[89,2,89,3],[90,2,90,3],[91,2,91,3],[92,2,92,3],[93,2,93,3],[95,2,95,3],[96,2,96,3],[97,2,97,3],[98,2,98,3],[99,2,99,3],[100,2,100,3],[101,2,101,3],[112,2,112,3],[113,2,113,3],[114,2,114,3],[115,2,115,3],[55,2,55,3],[56,2,56,3],[57,2,57,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[63,2,63,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[107,2,107,3],[108,2,108,3],[109,2,109,3],[110,2,110,3],[111,2,111,3],[102,2,102,3],[103,2,103,3],[104,2,104,3]]}
["MONTHLY KITCHEN STOCK DIFFERENCE (WEEKLY)"]
[]
["OUTLET :","CCS OUTLET"]
["MONTH :","2013-10-01"]
[]
["STOCK DIFFERENCE "]
[]
["NO","MATERIAL ","UOM","01.10.13-06.10.13","07.10.13-13.10.13","14.10.13-20.10.13","21.10.13-27.10.13","28.10.13-31.10.13","TOTAL "]
[null,null,null,null,null,null,null,null,"STOCK DIFFERENCE"]
[]
[null,"MAIN COURSE MATERIAL"]
[1,"CHICKEN CHOP (MARINATED)","PCS",19.8,null,null,null,null,{"$f":"SUM(D12:H12)","v":19.8}]
[]
[{"$f":"+A12+1","v":2},{"$f":"+'[1]K-LUNCH & K DINNER'!O23","v":"CHICKEN WINGS (MARINATED)"},"PCS",32,null,null,null,null,{"$f":"SUM(D14:H14)","v":32}]
[null,"CHICKEN WINGS ( NON MARINATED)","PCS",-51,null,null,null,null,{"$f":"SUM(D15:H15)","v":-51}]
[null,null,null,{"$f":"SUM(D14:D15)","v":-19},0,0,0,0,-19]
[]
[{"$f":"+A14+1","v":3},{"$f":"+'[1]SIDE ORDER & FOC'!Q17","v":"FISH & CHIP "},"PCS",1,null,null,null,null,{"$f":"SUM(D18:H18)","v":1}]
[]
[]
["USAGE DIFFERENCE "]
[]
[]
["NO","MATERIAL ","UOM","01.10.13-06.10.13",null,"07.10.13-13.10.13",null,"14.10.13-20.10.13",null,"21.10.13-27.10.13",null,"28.10.13-31.10.13"]
[]
[null,null,null,"EXCEL FORMAT","MANUAL RECORD","EXCEL FORMAT","MANUAL RECORD","MANUAL RECORD","EXCEL FORMAT","EXCEL FORMAT","MANUAL RECORD","EXCEL FORMAT","MANUAL RECORD"]
[null,"MAIN COURSE MATERIAL"]
[1,"CHICKEN CHOP (MARINATED)","PCS",390.82,371]
[{"$f":"+A28+1","v":2},"CHICKEN WINGS (MARINATED)","PCS",90,58]
[3,"CHICKEN WINGS (Non-MARINATED)","PCS",0,51]
[4,"FISH & CHIP ","PCS",67,66]
[]
[]
["USAGE DIFFERENCE BETWEEN EXCEL FORMAT & MANUAL RECORD"]
[]
[null,"MAIN COURSE MATERIAL",null,null,"DIFFERENCE",null,"DIFFERENCE",null,"DIFFERENCE",null,"DIFFERENCE",null,"DIFFERENCE"]
[1,"CHICKEN CHOP (MARINATED)",null,null,{"$f":"E28-D28","v":-19.819999999999993},null,{"$f":"G28-F28","v":0},null,{"$f":"I28-H28","v":0},null,{"$f":"K28-J28","v":0},null,{"$f":"M28-L28","v":0}]
[{"$f":"+A37+1","v":2},"CHICKEN WINGS (MARINATED)",null,null,{"$f":"E29-D29","v":-32},null,{"$f":"G29-F29","v":0},null,{"$f":"I29-H29","v":0},null,{"$f":"K29-J29","v":0},null,{"$f":"M29-L29","v":0}]
[3,"CHICKEN WINGS (Non-MARINATED)",null,null,51,null,0,null,0,null,0,null,0]
[4,"FISH & CHIP ",null,null,-1,null,0,null,0,null,0,null,0]
[]
[]
["CKN WINGS MARINATED",null,null,null,null,null,"CKN.CHOP"]
[]
[]
["DATE","USAGE","BASED ON OUTLET",null,"DIFFERENCE",null,"DATE","USAGE","BASED ON OUTLET","DIFFERENCE"]
[null,"BASED ON SYSTEM ","KITCHEN WEEKLY ",null,null,null,null,"BASED ON SYSTEM ","KITCHEN WEEKLY "]
[1,12,6,null,{"$f":"+C48-B48","v":-6},null,1,39.619999999999997,22,{"$f":"I48-H48","v":-17.619999999999997}]
[2,9,8,null,{"$f":"+C49-B49","v":-1},null,2,40.58,28,{"$f":"I49-H49","v":-12.579999999999998}]
[3,9,9,null,{"$f":"+C50-B50","v":0},null,3,61.84,78,16.159999999999997]
[4,12,3,null,-9,null,4,72.2,71,-1.2000000000000028]
[5,30,23,null,-7,null,5,85.14,87,1.8599999999999994]
[6,18,9,null,-9,null,6,87.44,85,-2.4399999999999977]
[7,null,null,null,0,null,7,null,null,0]
[8,null,null,null,0,null,8,null,null,0]
[{"$f":"A55+1","v":9},null,null,null,0,null,{"$f":"G55+1","v":9},null,null,0]
[{"$f":"A56+1","v":10},null,null,null,0,null,{"$f":"G56+1","v":10},null,null,0]
[11,null,null,null,0,null,11,null,null,0]
[12,null,null,null,0,null,12,null,null,0]
[13,null,null,null,0,null,13,null,null,0]
[14,null,null,null,0,null,14,null,null,0]
[15,null,null,null,0,null,15,null,null,0]
[16,null,null,null,0,null,16,null,null,0]
[17,null,null,null,0,null,17,null,null,0]
[18,null,null,null,0,null,18,null,null,0]
[19,null,null,null,0,null,19,null,null,0]
[20,null,null,null,0,null,20,null,null,0]
[21,null,null,null,0,null,21,null,null,0]
[22,null,null,null,0,null,22,null,null,0]
[23,null,null,null,0,null,23,null,null,0]
[24,null,null,null,0,null,24,null,null,0]
[25,null,null,null,0,null,25,null,null,0]
[26,null,null,null,0,null,26,null,null,0]
[27,null,null,null,0,null,27,null,null,0]
[28,null,null,null,0,null,28,null,null,0]
[29,null,null,null,0,null,29,null,null,0]
[{"$f":"A76+1","v":30},null,null,null,0,null,30,null,null,0]
[{"$f":"A77+1","v":31},null,null,null,0,null,31,null,null,0]
[]
[]
[]
[]
["FISH n CHIP"]
[]
[]
["DATE","USAGE","BASED ON OUTLET",null,"DIFFERENCE"]
[null,"BASED ON SYSTEM ","KITCHEN WEEKLY "]
[1,5,4,null,{"$f":"+C88-B88","v":-1}]
[2,4,4,null,{"$f":"+C89-B89","v":0}]
[3,17,17,null,{"$f":"+C90-B90","v":0}]
[4,12,13,null,{"$f":"+C91-B91","v":1}]
[5,14,14,null,{"$f":"+C92-B92","v":0}]
[6,15,14,null,{"$f":"+C93-B93","v":-1}]
[7,null,null,null,0]
[8,null,null,null,0]
[{"$f":"A95+1","v":9},null,null,null,0]
[{"$f":"A96+1","v":10},null,null,null,0]
[11,null,null,null,0]
[12,null,null,null,0]
[13,null,null,null,0]
[14,null,null,null,0]
[15,null,null,null,0]
[16,null,null,null,0]
[17,null,null,null,0]
[18,null,null,null,0]
[19,null,null,null,0]
[20,null,null,null,0]
[21,null,null,null,0]
[22,null,null,null,0]
[23,null,null,null,0]
[24,null,null,null,0]
[25,null,null,null,0]
[26,null,null,null,0]
[27,null,null,null,0]
[28,null,null,null,0]
[29,null,null,null,0]
[30,null,null,null,0]