{"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":15,"rows_kept":117,"cut":false,"hidden":false,"merged":[[76,2,76,3],[77,2,77,3],[78,2,78,3],[75,2,75,3],[55,8,55,9],[56,8,56,9],[57,8,57,9],[58,8,58,9],[59,8,59,9],[60,8,60,9],[61,8,61,9],[62,8,62,9],[63,8,63,9],[64,8,64,9],[65,8,65,9],[66,8,66,9],[67,8,67,9],[68,8,68,9],[69,8,69,9],[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],[105,2,105,3],[106,2,106,3],[94,2,94,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],[80,8,80,9],[85,2,85,3],[86,2,86,3],[87,2,87,3],[88,2,88,3],[51,8,51,9],[52,8,52,9],[53,8,53,9],[54,8,54,9],[79,8,79,9],[70,8,70,9],[71,8,71,9],[72,8,72,9],[73,8,73,9],[74,8,74,9],[75,8,75,9],[76,8,76,9],[77,8,77,9],[78,8,78,9],[23,9,23,10],[23,13,23,14],[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],[45,8,45,9],[46,8,46,9],[47,8,47,9],[48,8,48,9],[49,8,49,9],[50,8,50,9],[79,2,79,3],[80,2,80,3],[46,2,46,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[67,2,67,3],[68,2,68,3],[69,2,69,3],[70,2,70,3],[71,2,71,3],[72,2,72,3],[73,2,73,3],[74,2,74,3]]}
["MONTHLY KITCHEN STOCK DIFFERENCE (WEEKLY)"]
[]
["OUTLET :","SBA OUTLET"]
["MONTH :","2013-09-01"]
[]
["STOCK DIFFERENCE "]
[]
["NO","MATERIAL ","UOM","01.09.13","02.09.13-08.09.13","09.09.13-15.09.13","16.09.13-22.09.13","23.09.13-29.09.13","30.09.13","TOTAL "]
[null,null,null,null,null,null,null,null,null,"STOCK DIFFERENCE"]
[]
[null,"MAIN COURSE MATERIAL"]
[1,"CHICKEN CHOP (MARINATED)","PCS",-90,84.9,null,null,null,null,{"$f":"SUM(D12:H12)","v":-5.0999999999999943},{"$f":"+#REF!-J12","v":{"$error":"#REF!"}}]
[]
[{"$f":"+A12+1","v":2},{"$f":"+'[1]K-LUNCH & K DINNER'!O23","v":"CHICKEN WINGS (MARINATED)"},"PCS",-4,-22,null,null,null,null,{"$f":"SUM(D14:H14)","v":-26}]
[null,"CHICKEN WINGS ( NON MARINATED)","PCS",-19,-7,null,null,null,null,{"$f":"SUM(D15:H15)","v":-26}]
[null,null,null,{"$f":"SUM(D14:D15)","v":-23},-29,0,0,0,0,-52]
[]
[{"$f":"+A14+1","v":3},{"$f":"+'[1]SIDE ORDER & FOC'!Q17","v":"FISH & CHIP "},"PCS",-4,-18,null,null,null,null,{"$f":"SUM(D18:H18)","v":-22}]
[]
[]
["USAGE DIFFERENCE "]
[]
[]
["NO","MATERIAL ","UOM","01.09.13",null,"02.09.13-08.09.13",null,"09.09.13-15.09.13",null,"16.09.13-22.09.13",null,"23.09.13-29.09.13",null,"30.09.13"]
[]
[null,null,null,"EXCEL FORMAT","MANUAL RECORD","EXCEL FORMAT","MANUAL RECORD","EXCEL FORMAT","MANUAL RECORD","EXCEL FORMAT","MANUAL RECORD","EXCEL FORMAT","MANUAL RECORD","EXCEL FORMAT","MANUAL RECORD"]
[null,"MAIN COURSE MATERIAL"]
[1,"CHICKEN CHOP (MARINATED)","PCS",86,176,583.9,499]
[{"$f":"+A28+1","v":2},"CHICKEN WINGS (MARINATED)","PCS",30,34,144,166]
[3,"CHICKEN WINGS (Non-MARINATED)","PCS",2,21,26,33]
[4,"FISH & CHIP ","PCS",24,28,127,145]
[]
[]
["USAGE DIFFERENCE BETWEEN EXCEL FORMAT & MANUAL RECORD"]
[]
[null,"MAIN COURSE MATERIAL",null,null,"DIFFERENCE",null,"DIFFERENCE",null,"DIFFERENCE",null,"DIFFERENCE",null,"DIFFERENCE",null,"DIFFERENCE"]
[1,"CHICKEN CHOP (MARINATED)",null,null,{"$f":"+E28-D28","v":90},null,{"$f":"+G28-F28","v":-84.899999999999977},null,{"$f":"+I28-H28","v":0},null,{"$f":"+K28-J28","v":0},null,{"$f":"+M28-L28","v":0},null,{"$f":"+O28-N28","v":0}]
[{"$f":"+A37+1","v":2},"CHICKEN WINGS (MARINATED)",null,null,{"$f":"+E29-D29","v":4},null,{"$f":"+G29-F29","v":22},null,{"$f":"+I29-H29","v":0},null,{"$f":"+K29-J29","v":0},null,{"$f":"+M29-L29","v":0},null,{"$f":"+O29-N29","v":0}]
[3,"CHICKEN WINGS (Non-MARINATED)",null,null,{"$f":"+E30-D30","v":19},null,{"$f":"+G30-F30","v":7},null,{"$f":"+I30-H30","v":0},null,{"$f":"+K30-J30","v":0},null,{"$f":"+M30-L30","v":0},null,{"$f":"+O30-N30","v":0}]
[4,"FISH & CHIP ",null,null,{"$f":"+E31-D31","v":4},null,{"$f":"+G31-F31","v":18},null,{"$f":"+I31-H31","v":0},null,{"$f":"+K31-J31","v":0},null,{"$f":"+M31-L31","v":0},null,{"$f":"+O31-N31","v":0}]
[]
[]
["CKN WINGS MARINATED",null,null,null,null,null,"CKN.CHOP"]
[]
[]
["DATE","USAGE","BASED ON OUTLET",null,"DIFFERENCE",null,"DATE","USAGE","BASED ON OUTLET",null,"DIFFERENCE"]
[null,"BASED ON SYSTEM ","KITCHEN WEEKLY ",null,null,null,null,"BASED ON SYSTEM ","KITCHEN WEEKLY "]
[]
[2,21,22,null,{"$f":"+C49-B49","v":1},null,2,52.9,-37,null,{"$f":"+I49-H49","v":-89.9}]
[3,24,31,null,{"$f":"+C50-B50","v":7},null,3,58.8,80,null,{"$f":"+I50-H50","v":21.200000000000003}]
[4,12,3,null,-9,null,4,75.3,43,null,-32.299999999999997]
[5,18,32,null,14,null,5,85.5,82,null,-3.5]
[6,18,18,null,0,null,6,120.9,113,null,-7.9000000000000057]
[7,33,34,null,1,null,7,113.6,108,null,-5.5999999999999943]
[8,18,26,null,8,null,8,76.7,110,null,33.299999999999997]
[{"$f":"A55+1","v":9},18,18,null,0,null,{"$f":"G55+1","v":9},25,25,null,0]
[{"$f":"A56+1","v":10},21,26,null,5,null,{"$f":"G56+1","v":10},44,44,null,0]
[11,9,9,null,0,null,11,99.96,88,null,-11.959999999999994]
[12,27,25,null,-2,null,12,90.68,81,null,-9.6800000000000068]
[13,30,30,null,0,null,13,99.74,89,null,-10.739999999999995]
[14,48,48,null,0,null,14,57.16,52,null,-5.1599999999999966]
[15,42,42,null,0,null,15,131.28,120,null,-11.280000000000001]
[16,27,30,null,3,null,16,114.98,103,null,-11.980000000000004]
[17,9,9,null,0,null,17,56.84,56,null,-0.84000000000000341]
[18,18,19,null,1,null,18,28.88,23,null,-5.879999999999999]
[19,3,8,null,5,null,19,62.84,60,null,-2.8400000000000034]
[20,24,25,null,1,null,20,103.04,100,null,-3.0400000000000063]
[21,30,31,null,1,null,21,118.96,118,null,-0.95999999999999375]
[22,30,30,null,0,null,22,84.38,86,null,1.6200000000000045]
[23,null,null,null,null,null,23]
[24,null,null,null,null,null,24]
[25,null,null,null,null,null,25]
[26,null,null,null,null,null,26]
[27,null,null,null,null,null,27]
[28,null,null,null,null,null,28]
[29,null,null,null,null,null,29]
[{"$f":"A76+1","v":30},null,null,null,null,null,30]
[]
[]
[]
[]
[]
["FISH n CHIP"]
[]
[]
["DATE","USAGE","BASED ON OUTLET",null,"DIFFERENCE"]
[null,"BASED ON SYSTEM ","KITCHEN WEEKLY "]
[]
[2,8,-25,null,{"$f":"+C89-B89","v":-33}]
[3,13,13,null,{"$f":"+C90-B90","v":0}]
[4,16,18,null,{"$f":"+C91-B91","v":2}]
[5,17,18,null,{"$f":"+C92-B92","v":1}]
[6,29,46,null,{"$f":"+C93-B93","v":17}]
[7,33,39,null,6]
[8,11,36,null,25]
[{"$f":"A95+1","v":9},8,4,null,-4]
[{"$f":"A96+1","v":10},14,15,null,1]
[11,17,18,null,1]
[12,18,22,null,4]
[13,28,23,null,-5]
[14,16,19,null,3]
[15,35,36,null,1]
[16,31,33,null,2]
[17,7,8,null,1]
[18,5,6,null,1]
[19,13,13,null,0]
[20,26,23,null,-3]
[21,25,25,null,0]
[22,28,30,null,2]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]