{"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":83,"n_cols":15,"rows_kept":83,"cut":false,"hidden":false,"merged":[[81,2,81,3],[82,2,82,3],[83,2,83,3],[84,2,84,3],[76,2,76,3],[77,2,77,3],[78,2,78,3],[79,2,79,3],[80,2,80,3],[69,2,69,3],[70,2,70,3],[73,2,73,3],[74,2,74,3],[75,2,75,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[67,2,67,3],[68,2,68,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[63,2,63,3],[55,2,55,3],[56,2,56,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],[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]]}
["MONTHLY KITCHEN STOCK DIFFERENCE (WEEKLY)"]
[]
["OUTLET :","CCS 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",-3.8600000000000136,-27.440000000000055,null,null,null,null,{"$f":"SUM(D12:H12)","v":-31.300000000000068},{"$f":"+#REF!-J12","v":{"$error":"#REF!"}}]
[]
[{"$f":"+A12+1","v":2},{"$f":"+'[1]K-LUNCH & K DINNER'!O23","v":"CHICKEN WINGS (MARINATED)"},"PCS",15,54,null,null,null,null,{"$f":"SUM(D14:H14)","v":69}]
[null,"CHICKEN WINGS ( NON MARINATED)","PCS",-15,-64,null,null,null,null,{"$f":"SUM(D15:H15)","v":-79}]
[null,null,null,{"$f":"SUM(D14:D15)","v":0},-10,0,0,0,0,-10]
[]
[{"$f":"+A14+1","v":3},{"$f":"+'[1]SIDE ORDER & FOC'!Q17","v":"FISH & CHIP "},"PCS",-1,-83,null,null,null,null,{"$f":"SUM(D18:H18)","v":-84}]
[]
[]
["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",74.14,78,437.55999999999995,465]
[{"$f":"+A28+1","v":2},"CHICKEN WINGS (MARINATED)","PCS",33,18,156,102]
[3,"CHICKEN WINGS (Non-MARINATED)","PCS",0,15,0,64]
[4,"FISH & CHIP ","PCS",13,14,58,141]
[]
[]
["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":3.8599999999999994},null,{"$f":"+G28-F28","v":27.440000000000055},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":-15},null,{"$f":"+G29-F29","v":-54},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":15},null,{"$f":"+G30-F30","v":64},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":1},null,{"$f":"+G31-F31","v":83},null,{"$f":"+I31-H31","v":0},null,{"$f":"+K31-J31","v":0},null,{"$f":"+M31-L31","v":0},null,{"$f":"+O31-N31","v":0}]
[]
[]
["CHICKEN CHOP (MARINATED )"]
[]
[]
["DATE","USAGE","BASED ON OUTLET",null,"DIFFERENCE"]
[null,"BASED ON SYSTEM ","KITCHEN WEEKLY "]
[]
[2,80.2,73,null,{"$f":"+C49-B49","v":-7.2000000000000028}]
[{"$f":"+A49+1","v":3},41.9,50,null,{"$f":"+C50-B50","v":8.1000000000000014}]
[{"$f":"+A50+1","v":4},32.200000000000003,37,null,4.7999999999999972]
[5,69.900000000000006,78,null,8.0999999999999943]
[6,62.9,67,null,4.1000000000000014]
[7,69.8,78,null,8.2000000000000028]
[8,80.7,80,null,-0.70000000000000284]
[]
[]
[]
[]
["DATE","USAGE","BASED ON OUTLET",null,"DIFFERENCE"]
[null,"BASED ON SYSTEM ","KITCHEN WEEKLY "]
[]
[2,9,6,null,{"$f":"+C63-B63","v":-3}]
[{"$f":"+A63+1","v":3},15,12,null,{"$f":"+C64-B64","v":-3}]
[{"$f":"+A64+1","v":4},15,6,null,-9]
[5,39,6,null,-33]
[6,39,26,null,-13]
[7,30,22,null,-8]
[8,39,24,null,-15]
[9]
[]
[]
[]
["DATE","USAGE","BASED ON OUTLET",null,"DIFFERENCE"]
[null,"BASED ON SYSTEM ","KITCHEN WEEKLY "]
[]
[2,1,0,null,{"$f":"+C77-B77","v":-1}]
[{"$f":"+A77+1","v":3},0,0,null,{"$f":"+C78-B78","v":0}]
[{"$f":"+A78+1","v":4},0,2,null,2]
[5,13,94,null,81]
[6,15,15,null,0]
[7,12,12,null,0]
[8,17,18,null,1]