{"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":1,"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":[[109,2,109,3],[110,2,110,3],[111,2,111,3],[102,2,102,3],[103,2,103,3],[104,2,104,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],[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],[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],[86,2,86,3],[87,2,87,3],[88,2,88,3],[79,2,79,3],[80,2,80,3],[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]]}
["MONTHLY KITCHEN STOCK DIFFERENCE (WEEKLY)"]
[]
["OUTLET :","SBA 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",41.2,20.8,39.799999999999997,32,null,{"$f":"SUM(D12:H12)","v":133.80000000000001}]
[]
[{"$f":"+A12+1","v":2},{"$f":"+'[1]K-LUNCH & K DINNER'!O23","v":"CHICKEN WINGS (MARINATED)"},"PCS",-39,34,3,1,null,{"$f":"SUM(D14:H14)","v":-1}]
[null,"CHICKEN WINGS ( NON MARINATED)","PCS",-129,-12,-4,-9,null,{"$f":"SUM(D15:H15)","v":-154}]
[null,null,null,{"$f":"SUM(D14:D15)","v":-168},22,-1,-8,0,-155]
[]
[{"$f":"+A14+1","v":3},{"$f":"+'[1]SIDE ORDER & FOC'!Q17","v":"FISH & CHIP "},"PCS",-24,-36,-20,-14,null,{"$f":"SUM(D18:H18)","v":-94}]
[]
[]
["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",601.20000000000005,560,596.79999999999995,576,638.79999999999995,599,530,498]
[{"$f":"+A28+1","v":2},"CHICKEN WINGS (MARINATED)","PCS",150,189,186,152,240,237,189,188]
[3,"CHICKEN WINGS (Non-MARINATED)","PCS",41,170,27,39,24,28,30,39]
[4,"FISH & CHIP ","PCS",130,160,133,169,147,167,132,146]
[]
[]
["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":-41.200000000000045},null,{"$f":"G28-F28","v":-20.799999999999955},null,{"$f":"I28-H28","v":-39.799999999999955},null,{"$f":"K28-J28","v":-32},null,{"$f":"M28-L28","v":0}]
[{"$f":"+A37+1","v":2},"CHICKEN WINGS (MARINATED)",null,null,{"$f":"E29-D29","v":39},null,{"$f":"G29-F29","v":-34},null,{"$f":"I29-H29","v":-3},null,{"$f":"K29-J29","v":-1},null,{"$f":"M29-L29","v":0}]
[3,"CHICKEN WINGS (Non-MARINATED)",null,null,129,null,12,null,4,null,9,null,0]
[4,"FISH & CHIP ",null,null,30,null,36,null,20,null,14,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,36,37,null,{"$f":"+C48-B48","v":1},null,1,58.1,58,{"$f":"I48-H48","v":-0.10000000000000142}]
[2,9,9,null,{"$f":"+C49-B49","v":0},null,2,82.06,74,{"$f":"I49-H49","v":-8.0600000000000023}]
[3,27,26,null,{"$f":"+C50-B50","v":-1},null,3,99.68,91,-8.6800000000000068]
[4,33,35,null,2,null,4,160.96,151,-9.960000000000008]
[5,24,20,null,-4,null,5,99.72,93,-6.7199999999999989]
[6,1,61,null,60,null,6,95.68,93,-2.6800000000000068]
[7,24,-12,null,-36,null,7,61.12,62,0.88000000000000256]
[8,9,11,null,2,null,8,74.38,73,-1.3799999999999955]
[{"$f":"A55+1","v":9},72,30,null,-42,null,{"$f":"G55+1","v":9},129.47999999999999,60,-69.47999999999999]
[{"$f":"A56+1","v":10},42,42,null,0,null,{"$f":"G56+1","v":10},62.44,64,1.5600000000000023]
[11,30,32,null,2,null,11,145.66,134,-11.659999999999997]
[12,30,28,null,-2,null,12,112.28,162,49.72]
[13,12,21,null,9,null,13,69.900000000000006,21,-48.900000000000006]
[14,33,38,null,5,null,14,118,101,-17]
[15,24,25,null,1,null,15,129.6,122,-7.5999999999999943]
[16,27,23,null,-4,null,16,48.82,48,-0.82000000000000028]
[17,45,45,null,0,null,17,75.08,72,-3.0799999999999983]
[18,27,30,null,3,null,18,84.12,83,-1.1200000000000045]
[19,51,48,null,-3,null,19,101.44,98,-3.4399999999999977]
[20,27,28,null,1,null,20,70.739999999999995,75,4.2600000000000051]
[21,12,6,null,-6,null,21,43.5,44,0.5]
[22,24,24,null,0,null,22,39.92,37,-2.9200000000000017]
[23,27,27,null,0,null,23,55.76,43,-12.759999999999998]
[24,27,27,null,0,null,24,63.76,60,-3.759999999999998]
[25,36,37,null,1,null,25,133.6,129,-4.5999999999999943]
[26,42,42,null,0,null,26,94.76,92,-2.7600000000000051]
[27,21,20,null,-1,null,27,97.68,93,-4.6800000000000068]
[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,7,6,null,{"$f":"+C88-B88","v":-1}]
[2,11,16,null,{"$f":"+C89-B89","v":5}]
[3,23,32,null,{"$f":"+C90-B90","v":9}]
[4,34,38,null,{"$f":"+C91-B91","v":4}]
[5,36,36,null,{"$f":"+C92-B92","v":0}]
[6,19,26,null,{"$f":"+C93-B93","v":7}]
[7,12,18,null,6]
[8,15,21,null,6]
[{"$f":"A95+1","v":9},27,9,null,-18]
[{"$f":"A96+1","v":10},19,18,null,-1]
[11,40,63,null,23]
[12,26,27,null,1]
[13,13,17,null,4]
[14,28,29,null,1]
[15,27,36,null,9]
[16,20,22,null,2]
[17,21,27,null,6]
[18,19,19,null,0]
[19,20,19,null,-1]
[20,12,15,null,3]
[21,8,25,null,17]
[22,6,-10,null,-16]
[23,12,4,null,-8]
[24,26,34,null,8]
[25,37,38,null,1]
[26,24,41,null,17]
[27,19,14,null,-5]
[28,null,null,null,0]
[29,null,null,null,0]
[30,null,null,null,0]