{"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 :","KDA 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",110,33.700000000000003,29.979999999999905,69.8,null,{"$f":"SUM(D12:H12)","v":243.4799999999999}]
[]
[{"$f":"+A12+1","v":2},{"$f":"+'[1]K-LUNCH & K DINNER'!O23","v":"CHICKEN WINGS (MARINATED)"},"PCS",25,49,6,23,null,{"$f":"SUM(D14:H14)","v":103}]
[null,"CHICKEN WINGS ( NON MARINATED)","PCS",-47,-15,-19,-43,null,{"$f":"SUM(D15:H15)","v":-124}]
[null,null,null,{"$f":"SUM(D14:D15)","v":-22},34,-13,-20,0,-21]
[]
[{"$f":"+A14+1","v":3},{"$f":"+'[1]SIDE ORDER & FOC'!Q17","v":"FISH & CHIP "},"PCS",8,49,-19,-17,null,{"$f":"SUM(D18:H18)","v":21}]
[]
[]
["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",549.9,439,618.72,585,631,660.9799999999999,529.79999999999995,460]
[{"$f":"+A28+1","v":2},"CHICKEN WINGS (MARINATED)","PCS",249,224,183,134,300,306,225,202]
[3,"CHICKEN WINGS (Non-MARINATED)","PCS",25,72,26,41,60,41,56,99]
[4,"FISH & CHIP ","PCS",130,122,163,114,183,164,113,130]
[]
[]
["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":-110.89999999999998},null,{"$f":"G28-F28","v":-33.720000000000027},null,{"$f":"I28-H28","v":29.979999999999905},null,{"$f":"K28-J28","v":-69.799999999999955},null,{"$f":"M28-L28","v":0}]
[{"$f":"+A37+1","v":2},"CHICKEN WINGS (MARINATED)",null,null,{"$f":"E29-D29","v":-25},null,{"$f":"G29-F29","v":-49},null,{"$f":"I29-H29","v":6},null,{"$f":"K29-J29","v":-23},null,{"$f":"M29-L29","v":0}]
[3,"CHICKEN WINGS (Non-MARINATED)",null,null,47,null,15,null,-19,null,43,null,0]
[4,"FISH & CHIP ",null,null,-8,null,-49,null,-19,null,17,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,45,21,null,{"$f":"+C48-B48","v":-24},null,1,50.6,91,{"$f":"I48-H48","v":40.4}]
[2,36,18,null,{"$f":"+C49-B49","v":-18},null,2,47.6,69,{"$f":"I49-H49","v":21.4}]
[3,33,15,null,{"$f":"+C50-B50","v":-18},null,3,69.599999999999994,41,-28.599999999999994]
[4,48,74,null,26,null,4,128.9,85,-43.900000000000006]
[5,66,63,null,-3,null,5,134.6,54,-80.599999999999994]
[6,21,33,null,12,null,6,118.6,99,-19.599999999999994]
[7,18,6,null,-12,null,7,53.3,108,54.7]
[8,12,18,null,6,null,8,53.2,35,-18.200000000000003]
[{"$f":"A55+1","v":9},30,31,null,1,null,{"$f":"G55+1","v":9},88.9,146,57.099999999999994]
[{"$f":"A56+1","v":10},15,19,null,4,null,{"$f":"G56+1","v":10},59.6,62,2.3999999999999986]
[11,33,22,null,-11,null,11,111.6,83,-28.599999999999994]
[12,36,20,null,-16,null,12,143.5,73,-70.5]
[13,39,18,null,-21,null,13,106.9,78,-28.900000000000006]
[14,108,42,null,-66,null,14,189.8,70,-119.80000000000001]
[15,42,45,null,3,null,15,158.6,108,-50.599999999999994]
[16,18,78,null,60,null,16,66.3,66,-0.29999999999999716]
[17,42,42,null,0,null,17,33.9,113,79.099999999999994]
[18,33,36,null,3,null,18,112.6,81,-31.599999999999994]
[19,63,95,null,32,null,19,90.9,191,100.1]
[20,57,43,null,-14,null,20,71.599999999999994,83,11.400000000000006]
[21,30,32,null,2,null,21,51.9,59,7.1000000000000014]
[22,18,21,null,3,null,22,42.6,45,2.3999999999999986]
[23,27,24,null,-3,null,23,64.900000000000006,43,-21.900000000000006]
[24,30,22,null,-8,null,24,49.3,57,7.7000000000000028]
[25,36,41,null,5,null,25,111.6,95,-16.599999999999994]
[26,60,41,null,-19,null,26,120.6,94,-26.599999999999994]
[27,24,21,null,-3,null,27,87.9,62,-25.900000000000006]
[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,15,19,null,{"$f":"+C88-B88","v":4}]
[2,14,12,null,{"$f":"+C89-B89","v":-2}]
[3,17,17,null,{"$f":"+C90-B90","v":0}]
[4,31,28,null,{"$f":"+C91-B91","v":-3}]
[5,28,18,null,{"$f":"+C92-B92","v":-10}]
[6,25,28,null,{"$f":"+C93-B93","v":3}]
[7,13,17,null,4]
[8,16,12,null,-4]
[{"$f":"A95+1","v":9},17,12,null,-5]
[{"$f":"A96+1","v":10},14,12,null,-2]
[11,28,19,null,-9]
[12,44,14,null,-30]
[13,31,28,null,-3]
[14,31,22,null,-9]
[15,37,44,null,7]
[16,13,18,null,5]
[17,15,21,null,6]
[18,33,39,null,6]
[19,35,24,null,-11]
[20,7,15,null,8]
[21,13,11,null,-2]
[22,5,12,null,7]
[23,9,15,null,6]
[24,14,12,null,-2]
[25,22,26,null,4]
[26,36,38,null,2]
[27,14,16,null,2]
[28,null,null,null,0]
[29,null,null,null,0]
[30,null,null,null,0]