{"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":148,"n_cols":15,"rows_kept":148,"cut":false,"hidden":false,"merged":[[69,2,69,3],[70,2,70,3],[71,2,71,3],[72,2,72,3],[63,2,63,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[67,2,67,3],[105,2,105,3],[106,2,106,3],[107,2,107,3],[108,2,108,3],[90,2,90,3],[91,2,91,3],[92,2,92,3],[93,2,93,3],[94,2,94,3],[80,2,80,3],[81,2,81,3],[82,2,82,3],[83,2,83,3],[84,2,84,3],[73,2,73,3],[74,2,74,3],[75,2,75,3],[76,2,76,3],[68,2,68,3],[147,2,147,3],[126,2,126,3],[127,2,127,3],[128,2,128,3],[129,2,129,3],[130,2,130,3],[131,2,131,3],[132,2,132,3],[133,2,133,3],[134,2,134,3],[135,2,135,3],[136,2,136,3],[137,2,137,3],[138,2,138,3],[139,2,139,3],[124,2,124,3],[125,2,125,3],[145,2,145,3],[146,2,146,3],[119,2,119,3],[120,2,120,3],[121,2,121,3],[122,2,122,3],[123,2,123,3],[140,2,140,3],[141,2,141,3],[142,2,142,3],[143,2,143,3],[144,2,144,3],[110,2,110,3],[111,2,111,3],[116,2,116,3],[117,2,117,3],[118,2,118,3],[85,2,85,3],[86,2,86,3],[87,2,87,3],[88,2,88,3],[89,2,89,3],[109,2,109,3],[100,2,100,3],[101,2,101,3],[102,2,102,3],[103,2,103,3],[104,2,104,3],[95,2,95,3],[96,2,96,3],[97,2,97,3],[98,2,98,3],[99,2,99,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[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],[46,2,46,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[55,2,55,3],[56,2,56,3],[57,2,57,3]]}
["MONTHLY KITCHEN STOCK DIFFERENCE (WEEKLY)"]
[]
["OUTLET :","KDA 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",4.3,-418.1,58,69.980000000000018,54.28,113.5,{"$f":"SUM(D12:I12)","v":-118.03999999999999},{"$f":"+#REF!-J12","v":{"$error":"#REF!"}}]
[]
[{"$f":"+A12+1","v":2},{"$f":"+'[1]K-LUNCH & K DINNER'!O23","v":"CHICKEN WINGS (MARINATED)"},"PCS",0,-116.1,16,-25,67,4,{"$f":"SUM(D14:I14)","v":-54.099999999999994}]
[null,"CHICKEN WINGS ( NON MARINATED)","PCS",0,-36,-36,-21,-23,-8,-124]
[null,null,null,{"$f":"SUM(D14:D15)","v":0},-152.1,-20,-46,44,-4,-178.1]
[]
[{"$f":"+A14+1","v":3},{"$f":"+'[1]SIDE ORDER & FOC'!Q17","v":"FISH & CHIP "},"PCS",1,-96,-15,-10,-14,-1,{"$f":"SUM(D18:I18)","v":-135}]
[]
[]
["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",102.3,98,121.9,540,572.9,514,647.98,578,637.28000000000009,583]
[{"$f":"+A28+1","v":2},"CHICKEN WINGS (MARINATED)","PCS",42,42,57,173,291,275,219,244,186,119]
[3,"CHICKEN WINGS (Non-MARINATED)","PCS",10,10,9,45,28,64,24,45,23,46]
[4,"FISH & CHIP ","PCS",31,30,32,128,163,178,153,163,141,155]
[]
[]
["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":-4.2999999999999972},null,{"$f":"+G28-F28","v":418.1},null,{"$f":"+I28-H28","v":-58.899999999999977},null,{"$f":"+K28-J28","v":-69.980000000000018},null,{"$f":"+M28-L28","v":-54.280000000000086},null,{"$f":"+O28-N28","v":0}]
[{"$f":"+A37+1","v":2},"CHICKEN WINGS (MARINATED)",null,null,{"$f":"+E29-D29","v":0},null,{"$f":"+G29-F29","v":116},null,{"$f":"+I29-H29","v":-16},null,{"$f":"+K29-J29","v":25},null,{"$f":"+M29-L29","v":-67},null,{"$f":"+O29-N29","v":0}]
[3,"CHICKEN WINGS (Non-MARINATED)",null,null,{"$f":"+E30-D30","v":0},null,{"$f":"+G30-F30","v":36},null,{"$f":"+I30-H30","v":36},null,{"$f":"+K30-J30","v":21},null,{"$f":"+M30-L30","v":23},null,{"$f":"+O30-N30","v":0}]
[4,"FISH & CHIP ",null,null,{"$f":"+E31-D31","v":-1},null,{"$f":"+G31-F31","v":96},null,{"$f":"+I31-H31","v":15},null,{"$f":"+K31-J31","v":10},null,{"$f":"+M31-L31","v":14},null,{"$f":"+O31-N31","v":0}]
[]
[]
["CHICKEN CHOP (MARINATED )"]
[]
[]
["DATE","USAGE","BASED ON OUTLET",null,"DIFFERENCE"]
[null,"BASED ON SYSTEM ","KITCHEN WEEKLY "]
[]
[2,54.4,47,null,{"$f":"+C49-B49","v":-7.3999999999999986}]
[{"$f":"+A49+1","v":3},46.8,70,null,{"$f":"+C50-B50","v":23.200000000000003}]
[{"$f":"+A50+1","v":4},60.4,26,null,-34.4]
[5,61.5,51,null,-10.5]
[6,138.19999999999999,141,null,2.8000000000000114]
[7,117,81,null,-36]
[8,121.9,124,null,2.0999999999999943]
[9,48.6,28,null,-20.6]
[10,73.3,97,null,23.700000000000003]
[11,49.9,40,null,-9.8999999999999986]
[12,50.6,33,null,-17.600000000000001]
[13,124.9,122,null,-2.9000000000000057]
[14,105.5,82,null,-23.5]
[15,120.6,112,null,-8.5999999999999943,{"$f":"SUM(E56:E62)","v":-59.4}]
[16,134.6,131,null,-3.5999999999999943]
[17,59.9,53,null,-6.8999999999999986]
[18,69.599999999999994,56,null,-13.599999999999994]
[19,40.299999999999997,36,null,-4.2999999999999972]
[20,112.2,149,null,36.799999999999997]
[21,118.2,94,null,-24.200000000000003]
[22,113.2,89,null,-24.200000000000003]
[23,62.3,58,null,-4.2999999999999972]
[24,53.5,65,null,11.5]
[25,74.599999999999994,60,null,-14.599999999999994]
[26,81.3,64,null,-17.299999999999997]
[27,133.19999999999999,138,null,4.8000000000000114]
[28,100.2,94,null,-6.2000000000000028]
[29,129.9,104,null,-25.900000000000006]
[30]
[]
["CHICKEN WINGS (MARINATED )"]
[]
["DATE","USAGE","BASED ON OUTLET",null,"DIFFERENCE"]
[null,"BASED ON SYSTEM ","KITCHEN WEEKLY "]
[]
[2,15,17,null,{"$f":"+C84-B84","v":2}]
[{"$f":"+A84+1","v":3},18,21,null,{"$f":"+C85-B85","v":3}]
[{"$f":"+A85+1","v":4},39,30,null,-9]
[5,9,12,null,3]
[6,39,9,null,-30]
[7,30,54,null,24]
[8,57,30,null,-27]
[9,51,60,null,9]
[10,42,38,null,-4]
[11,18,33,null,15]
[12,36,21,null,-15]
[13,57,75,null,18]
[14,45,39,null,-6]
[15,42,30,null,-12]
[16,51,44,null,-7]
[17,18,24,null,6]
[18,27,32,null,5]
[19,27,15,null,-12]
[20,24,15,null,-9]
[21,33,102,null,69]
[22,39,12,null,-27]
[23,15,16,null,1]
[24,12,4,null,-8]
[25,18,3,null,-15]
[26,27,4,null,-23]
[27,39,7,null,-32]
[28,48,4,null,-44]
[29,17,8,null,-9]
[30]
[]
[]
["FISH N CHIPS"]
[]
["DATE","USAGE","BASED ON OUTLET",null,"DIFFERENCE"]
[null,"BASED ON SYSTEM ","KITCHEN WEEKLY "]
[]
[2,15,10,null,{"$f":"+C120-B120","v":-5}]
[{"$f":"+A120+1","v":3},11,7,null,{"$f":"+C121-B121","v":-4}]
[{"$f":"+A121+1","v":4},3,20,null,17]
[5,6,13,null,7]
[6,33,8,null,-25]
[7,38,42,null,4]
[8,32,28,null,-4]
[9,1,33,null,32]
[10,14,13,null,-1]
[11,16,11,null,-5]
[12,20,6,null,-14]
[13,31,25,null,-6]
[14,28,40,null,12]
[15,46,90,null,44]
[16,32,24,null,-8]
[17,10,41,null,31]
[18,16,12,null,-4]
[19,16,27,null,11]
[20,29,29,null,0]
[21,34,48,null,14]
[22,16,35,null,19]
[23,15,16,null,1]
[24,4,34,null,30]
[25,17,11,null,-6]
[26,18,27,null,9]
[27,32,31,null,-1]
[28,21,28,null,7]
[29,27,35,null,8]
[30]