{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Summary","GUINNESS","HEINEKEN","TIGER","CIGARETTES","PAULANAR","STRONGBOW","HOEGAARDEN","APPLE CIDER"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":16,"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":"Summary","index":0,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,2,5,3],[7,2,7,3],[9,2,9,3],[11,2,11,6],[13,2,13,3]]}
[]
[]
[null,null,"SUMMARY OF STOCK IN / OUT BY MONTH"]
[]
[]
[null,"OUTLET",{"$f":"MID(CELL(\"FILENAME\",$A$1),FIND(\"[\",CELL(\"FILENAME\",$A$1))+1,3)","v":"TSU"}]
[]
[null,"YEAR",{"$f":"MID(CELL(\"FILENAME\",$A$1),FIND(\"[\",CELL(\"FILENAME\",$A$1))+4,4)","v":"2013"}]
[]
[null,"MONTH"]
[]
[null,"FILE PATH",{"$f":"MID(CELL(\"FILENAME\",$A$1),1,FIND(\"[\",CELL(\"FILENAME\",$A$1))-1)","v":"D:\\Purchasing\\Beer & EGSR\\EGSR Reports\\YR2013\\TSU\\"}]
[]
[null,"CELL LINK",12]
[]
[]
[null,"TYPE OF PRODUCT","STOCK IN / OUT",null,null,null,null,null,"CLOSING STOCK"]
[null,null,"PURCHASED","INCENTIVE","SOLD","DEPOSITED","REDEEMED","FORFEITED","AT MONTH END"]
[null,null,"exclude forfeited"]
[null,null,"( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )"]
[null,"GUINNESS",{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$Q$17:$Q$28\"),$C$14,1),\"\"),\"\")","v":144},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$G$17:$G$28\"),$C$14,1),\"\"),\"\")","v":0},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$H$17:$H$28\"),$C$14,1),\"\"),\"\")","v":109},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":32},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$M$17:$M$28\"),$C$14,1),\"\"),\"\")","v":23},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$N$17:$N$28\"),$C$14,1),\"\"),\"\")","v":3},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$P$17:$P$28\"),$C$14,1),\"\"),\"\")","v":106}]
[null,"HEINEKEN",{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$Q$17:$Q$28\"),$C$14,1),\"\"),\"\")","v":1320},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$G$17:$G$28\"),$C$14,1),\"\"),\"\")","v":0},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$H$17:$H$28\"),$C$14,1),\"\"),\"\")","v":1133},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":61},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$M$17:$M$28\"),$C$14,1),\"\"),\"\")","v":34},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$N$17:$N$28\"),$C$14,1),\"\"),\"\")","v":11},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$P$17:$P$28\"),$C$14,1),\"\"),\"\")","v":415}]
[null,"TIGER",2856,0,2706,313,321,86,563]
[null,"CIGARETTES",100,0,250,0,0,0,63]
[null,"PAULANAR",0,0,16,0,0,0,50]
[null,"STRONGBOW",72,0,2,0,0,0,70]
[null,"HOEGAARDEN",48,0,73,0,0,1,55]
[null,"APPLE CIDER","","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,"TOTAL",{"$f":"SUM(C$21:C$34)","v":4540},{"$f":"SUM(D$21:D$34)","v":0},4289,406,378,101,1322]
[]
[null,"Copyright © 2012 by Oracle Symphony Sdn Bhd"]

{"sheet":"GUINNESS","index":1,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,3,5,5],[7,3,7,5],[9,3,9,5]]}
[]
[]
[null,null,null,"ANNUAL STOCK SUMMARY OF ESSENTIAL GOODS BY TYPE"]
[]
[]
[null,"OUTLET",null,{"$f":"Summary!C6","v":"TSU"}]
[]
[null,"YEAR",null,{"$f":"Summary!C8","v":"2013"}]
[]
[null,"TYPE OF BEER",null,{"$f":"MID(CELL(\"FILENAME\",$A$1),FIND(\"]\",CELL(\"FILENAME\",$A$1))+1,256)","v":"GUINNESS"}]
[]
[]
[null,"MONTH","FILE NAME","FOR REGULAR STOCK",null,null,null,null,null,"FOR CUSTODY STOCK",null,null,null,null,null,"CLOSING","PURCHASED","LOSSES ( - )  /  GAINS ( + )"]
[null,null,null,"OPENING","ROW","IN ( + )",null,"OUT ( - )","BALANCE","OPENING","ROW","IN ( + )","OUT ( - )",null,"BALANCE",null,"excluding ","REGULAR","CUSTODY"]
[null,null,null,null,null,"PURCHASED *","INCENTIVE","SOLD","STOCK",null,null,"DEPOSITED","REDEEMED","FORFEITED","STOCK",null,"forfeited","STOCK","STOCK"]
[null,null,null,"( bottles )",null,"( bottles )","( bottles )","( bottles )","( bottles )","( bottles )",null,"( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )"]
[null,"JANUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B17)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201301 EGSR.xlsx"},57,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},104,0,115,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":46},22,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},26,27,8,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":13},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":59},{"$f":"IFERROR($F17-$N17,\"\")","v":96}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201302 EGSR.xlsx"},46,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},124,0,143,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":27},13,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},15,5,4,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":19},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":46},{"$f":"IFERROR($F18-$N18,\"\")","v":120}]
[null,"MARCH","TSU201303 EGSR.xlsx",27,1,126,0,121,32,19,1,13,13,6,13,45,120]
[null,"APRIL","TSU201304 EGSR.xlsx",32,1,144,0,121,55,13,1,17,13,0,17,72,144]
[null,"MAY","TSU201305 EGSR.xlsx",55,1,145,0,104,96,17,1,5,13,1,8,104,144]
[null,"JUNE","TSU201306 EGSR.xlsx",96,1,127,0,178,45,8,1,24,18,7,7,52,120]
[null,"JULY","TSU201307 EGSR.xlsx",45,1,122,0,101,66,7,1,4,7,2,2,68,120]
[null,"AUGUST","TSU201308 EGSR.xlsx",66,1,146,0,163,49,2,1,11,7,2,4,53,144]
[null,"SEPTEMBER","TSU201309 EGSR.xlsx",49,1,170,0,151,68,4,1,23,10,2,15,83,168]
[null,"OCTOBER","TSU201310 EGSR.xlsx",68,1,219,0,220,67,15,1,48,50,3,10,77,216]
[null,"NOVEMBER","TSU201311 EGSR.xlsx",67,1,121,0,134,54,10,1,5,6,1,8,62,120]
[null,"DECEMBER","TSU201312 EGSR.xlsx",54,1,147,0,109,92,8,1,32,23,3,14,106,144]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":57},null,{"$f":"SUM(F$17:F$28)","v":1695},{"$f":"SUM(G$17:G$28)","v":0},1660,{"$f":"$D$29+$F$29+$G$29-$H$29","v":92},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":22},null,{"$f":"SUM(L$17:L$28)","v":223},{"$f":"SUM(M$17:M$28)","v":192},39,{"$f":"$J$29+$L$29-$M$29-$N$29","v":14},{"$f":"$I29+$O29","v":106},null,{"$f":"SUM(R$17:R$28)","v":0},{"$f":"SUM(S$17:S$28)","v":0}]
[null,"* STOCK PURCHASED INCLUDES STOCK FORFEITED FROM CUSTODY"]
[null,"Copyright © 2012 by Oracle Symphony Sdn Bhd"]

{"sheet":"HEINEKEN","index":2,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,3,5,5],[7,3,7,5],[9,3,9,5]]}
[]
[]
[null,null,null,"ANNUAL STOCK SUMMARY OF ESSENTIAL GOODS BY TYPE"]
[]
[]
[null,"OUTLET",null,{"$f":"Summary!C6","v":"TSU"}]
[]
[null,"YEAR",null,{"$f":"Summary!C8","v":"2013"}]
[]
[null,"TYPE OF BEER",null,{"$f":"MID(CELL(\"FILENAME\",$A$1),FIND(\"]\",CELL(\"FILENAME\",$A$1))+1,256)","v":"HEINEKEN"}]
[]
[]
[null,"MONTH","FILE NAME","FOR REGULAR STOCK",null,null,null,null,null,"FOR CUSTODY STOCK",null,null,null,null,null,"CLOSING","PURCHASED","LOSSES ( - )  /  GAINS ( + )"]
[null,null,null,"OPENING","ROW","IN ( + )",null,"OUT ( - )","BALANCE","OPENING","ROW","IN ( + )","OUT ( - )",null,"BALANCE",null,"excluding ","REGULAR","CUSTODY"]
[null,null,null,null,null,"PURCHASED *","INCENTIVE","SOLD","STOCK",null,null,"DEPOSITED","REDEEMED","FORFEITED","STOCK",null,"forfeited","STOCK","STOCK"]
[null,null,null,"( bottles )",null,"( bottles )","( bottles )","( bottles )","( bottles )","( bottles )",null,"( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )"]
[null,"JANUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B17)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201301 EGSR.xlsx"},483,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},1103,0,1263,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":323},139,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},126,147,26,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":92},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":415},{"$f":"IFERROR($F17-$N17,\"\")","v":1077}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201302 EGSR.xlsx"},323,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},1592,0,1705,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":210},92,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},156,123,32,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":93},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":303},{"$f":"IFERROR($F18-$N18,\"\")","v":1560}]
[null,"MARCH","TSU201303 EGSR.xlsx",210,1,1583,0,1774,19,93,1,217,155,23,132,151,1560]
[null,"APRIL","TSU201304 EGSR.xlsx",19,1,1827,0,1584,262,132,1,159,123,27,141,403,1800]
[null,"MAY","TSU201305 EGSR.xlsx",262,1,1602,0,1394,470,141,1,177,163,42,113,583,1560]
[null,"JUNE","TSU201306 EGSR.xlsx",470,1,1213,0,1560,123,113,1,107,87,37,96,219,1176]
[null,"JULY","TSU201307 EGSR.xlsx",123,1,1264,0,1244,143,96,1,154,67,64,119,262,1200]
[null,"AUGUST","TSU201308 EGSR.xlsx",143,1,1631,0,1602,172,119,1,116,111,23,101,273,1608]
[null,"SEPTEMBER","TSU201309 EGSR.xlsx",172,1,1355,0,1496,31,101,1,165,70,59,137,168,1296]
[null,"OCTOBER","TSU201310 EGSR.xlsx",31,1,1938,0,1708,261,137,1,116,159,18,76,337,1920]
[null,"NOVEMBER","TSU201311 EGSR.xlsx",261,1,1026,0,1111,176,75,1,52,84,18,25,201,1008]
[null,"DECEMBER","TSU201312 EGSR.xlsx",176,1,1331,0,1133,374,25,1,61,34,11,41,415,1320]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":483},null,{"$f":"SUM(F$17:F$28)","v":17465},{"$f":"SUM(G$17:G$28)","v":0},17574,{"$f":"$D$29+$F$29+$G$29-$H$29","v":374},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":139},null,{"$f":"SUM(L$17:L$28)","v":1606},{"$f":"SUM(M$17:M$28)","v":1323},380,{"$f":"$J$29+$L$29-$M$29-$N$29","v":42},{"$f":"$I29+$O29","v":416},null,{"$f":"SUM(R$17:R$28)","v":0},{"$f":"SUM(S$17:S$28)","v":0}]
[null,"* STOCK PURCHASED INCLUDES STOCK FORFEITED FROM CUSTODY"]
[null,"Copyright © 2012 by Oracle Symphony Sdn Bhd"]

{"sheet":"TIGER","index":3,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,3,5,5],[7,3,7,5],[9,3,9,5]]}
[]
[]
[null,null,null,"ANNUAL STOCK SUMMARY OF ESSENTIAL GOODS BY TYPE"]
[]
[]
[null,"OUTLET",null,{"$f":"Summary!C6","v":"TSU"}]
[]
[null,"YEAR",null,{"$f":"Summary!C8","v":"2013"}]
[]
[null,"TYPE OF BEER",null,{"$f":"MID(CELL(\"FILENAME\",$A$1),FIND(\"]\",CELL(\"FILENAME\",$A$1))+1,256)","v":"TIGER"}]
[]
[]
[null,"MONTH","FILE NAME","FOR REGULAR STOCK",null,null,null,null,null,"FOR CUSTODY STOCK",null,null,null,null,null,"CLOSING","PURCHASED","LOSSES ( - )  /  GAINS ( + )"]
[null,null,null,"OPENING","ROW","IN ( + )",null,"OUT ( - )","BALANCE","OPENING","ROW","IN ( + )","OUT ( - )",null,"BALANCE",null,"excluding ","REGULAR","CUSTODY"]
[null,null,null,null,null,"PURCHASED *","INCENTIVE","SOLD","STOCK",null,null,"DEPOSITED","REDEEMED","FORFEITED","STOCK",null,"forfeited","STOCK","STOCK"]
[null,null,null,"( bottles )",null,"( bottles )","( bottles )","( bottles )","( bottles )","( bottles )",null,"( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )"]
[null,"JANUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B17)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201301 EGSR.xlsx"},298,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},1404,0,1605,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":97},223,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},192,169,84,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":162},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":259},{"$f":"IFERROR($F17-$N17,\"\")","v":1320}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201302 EGSR.xlsx"},97,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},1867,0,1875,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":89},162,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},277,134,67,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":238},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":327},{"$f":"IFERROR($F18-$N18,\"\")","v":1800}]
[null,"MARCH","TSU201303 EGSR.xlsx",89,1,1631,0,1581,139,238,1,257,232,71,192,331,1560]
[null,"APRIL","TSU201304 EGSR.xlsx",139,1,1499,0,1351,287,192,1,119,122,59,130,417,1440]
[null,"MAY","TSU201305 EGSR.xlsx",287,1,1640,0,1683,244,130,1,249,129,80,170,414,1560]
[null,"JUNE","TSU201306 EGSR.xlsx",244,1,1732,0,1861,115,170,1,326,310,28,158,273,1704]
[null,"JULY","TSU201307 EGSR.xlsx",115,1,2178,0,2073,220,158,1,279,175,42,220,440,2136]
[null,"AUGUST","TSU201308 EGSR.xlsx",220,1,2581,0,2782,19,220,1,301,326,37,158,177,2544]
[null,"SEPTEMBER","TSU201309 EGSR.xlsx",19,1,2465,0,2352,132,158,1,287,195,41,209,341,2424]
[null,"OCTOBER","TSU201310 EGSR.xlsx",132,1,3337,0,3110,359,209,1,424,339,25,269,628,3312]
[null,"NOVEMBER","TSU201311 EGSR.xlsx",359,1,2927,0,3167,119,268,1,493,363,96,302,421,2831]
[null,"DECEMBER","TSU201312 EGSR.xlsx",119,1,2942,0,2706,355,302,1,313,321,86,208,563,2856]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":298},null,{"$f":"SUM(F$17:F$28)","v":26203},{"$f":"SUM(G$17:G$28)","v":0},26146,{"$f":"$D$29+$F$29+$G$29-$H$29","v":355},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":223},null,{"$f":"SUM(L$17:L$28)","v":3517},{"$f":"SUM(M$17:M$28)","v":2815},716,{"$f":"$J$29+$L$29-$M$29-$N$29","v":209},{"$f":"$I29+$O29","v":564},null,{"$f":"SUM(R$17:R$28)","v":0},{"$f":"SUM(S$17:S$28)","v":0}]
[null,"* STOCK PURCHASED INCLUDES STOCK FORFEITED FROM CUSTODY"]
[null,"Copyright © 2012 by Oracle Symphony Sdn Bhd"]

{"sheet":"CIGARETTES","index":4,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,3,5,5],[7,3,7,5],[9,3,9,5]]}
[]
[]
[null,null,null,"ANNUAL STOCK SUMMARY OF ESSENTIAL GOODS BY TYPE"]
[]
[]
[null,"OUTLET",null,{"$f":"Summary!C6","v":"TSU"}]
[]
[null,"YEAR",null,{"$f":"Summary!C8","v":"2013"}]
[]
[null,"TYPE OF BEER",null,{"$f":"MID(CELL(\"FILENAME\",$A$1),FIND(\"]\",CELL(\"FILENAME\",$A$1))+1,256)","v":"CIGARETTES"}]
[]
[]
[null,"MONTH","FILE NAME","FOR REGULAR STOCK",null,null,null,null,null,"FOR CUSTODY STOCK",null,null,null,null,null,"CLOSING","PURCHASED","LOSSES ( - )  /  GAINS ( + )"]
[null,null,null,"OPENING","ROW","IN ( + )",null,"OUT ( - )","BALANCE","OPENING","ROW","IN ( + )","OUT ( - )",null,"BALANCE",null,"excluding ","REGULAR","CUSTODY"]
[null,null,null,null,null,"PURCHASED *","INCENTIVE","SOLD","STOCK",null,null,"DEPOSITED","REDEEMED","FORFEITED","STOCK",null,"forfeited","STOCK","STOCK"]
[null,null,null,"( bottles )",null,"( bottles )","( bottles )","( bottles )","( bottles )","( bottles )",null,"( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )"]
[null,"JANUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B17)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201301 EGSR.xlsx"},201,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},410,0,327,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":284},0,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},0,0,0,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":0},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":284},{"$f":"IFERROR($F17-$N17,\"\")","v":410}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201302 EGSR.xlsx"},284,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},350,0,397,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":237},0,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},0,0,0,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":0},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":237},{"$f":"IFERROR($F18-$N18,\"\")","v":350}]
[null,"MARCH","TSU201303 EGSR.xlsx",237,1,300,0,391,146,0,1,0,0,0,0,146,300]
[null,"APRIL","TSU201304 EGSR.xlsx",146,1,420,0,357,209,0,1,0,0,0,0,209,420]
[null,"MAY","TSU201305 EGSR.xlsx",209,1,300,0,350,159,0,1,0,0,0,0,159,300]
[null,"JUNE","TSU201306 EGSR.xlsx",159,1,370,0,385,144,0,1,0,0,0,0,144,370]
[null,"JULY","TSU201307 EGSR.xlsx",144,1,280,0,292,132,0,1,0,0,0,0,132,280]
[null,"AUGUST","TSU201308 EGSR.xlsx",132,1,340,0,314,158,0,1,0,0,0,0,158,340]
[null,"SEPTEMBER","TSU201309 EGSR.xlsx",158,1,240,0,328,70,0,1,0,0,0,0,70,240]
[null,"OCTOBER","TSU201310 EGSR.xlsx",70,1,300,0,264,106,0,1,0,0,0,0,106,300]
[null,"NOVEMBER","TSU201311 EGSR.xlsx",106,1,350,0,243,213,0,1,0,0,0,0,213,350]
[null,"DECEMBER","TSU201312 EGSR.xlsx",213,1,100,0,250,63,0,1,0,0,0,0,63,100]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":201},null,{"$f":"SUM(F$17:F$28)","v":3760},{"$f":"SUM(G$17:G$28)","v":0},3898,{"$f":"$D$29+$F$29+$G$29-$H$29","v":63},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":0},null,{"$f":"SUM(L$17:L$28)","v":0},{"$f":"SUM(M$17:M$28)","v":0},0,{"$f":"$J$29+$L$29-$M$29-$N$29","v":0},{"$f":"$I29+$O29","v":63},null,{"$f":"SUM(R$17:R$28)","v":0},{"$f":"SUM(S$17:S$28)","v":0}]
[null,"* STOCK PURCHASED INCLUDES STOCK FORFEITED FROM CUSTODY"]
[null,"Copyright © 2012 by Oracle Symphony Sdn Bhd"]

{"sheet":"PAULANAR","index":5,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,3,5,5],[7,3,7,5],[9,3,9,5]]}
[]
[]
[null,null,null,"ANNUAL STOCK SUMMARY OF ESSENTIAL GOODS BY TYPE"]
[]
[]
[null,"OUTLET",null,{"$f":"Summary!C6","v":"TSU"}]
[]
[null,"YEAR",null,{"$f":"Summary!C8","v":"2013"}]
[]
[null,"TYPE OF BEER",null,{"$f":"MID(CELL(\"FILENAME\",$A$1),FIND(\"]\",CELL(\"FILENAME\",$A$1))+1,256)","v":"PAULANAR"}]
[]
[]
[null,"MONTH","FILE NAME","FOR REGULAR STOCK",null,null,null,null,null,"FOR CUSTODY STOCK",null,null,null,null,null,"CLOSING","PURCHASED","LOSSES ( - )  /  GAINS ( + )"]
[null,null,null,"OPENING","ROW","IN ( + )",null,"OUT ( - )","BALANCE","OPENING","ROW","IN ( + )","OUT ( - )",null,"BALANCE",null,"excluding ","REGULAR","CUSTODY"]
[null,null,null,null,null,"PURCHASED *","INCENTIVE","SOLD","STOCK",null,null,"DEPOSITED","REDEEMED","FORFEITED","STOCK",null,"forfeited","STOCK","STOCK"]
[null,null,null,"( bottles )",null,"( bottles )","( bottles )","( bottles )","( bottles )","( bottles )",null,"( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )"]
[null,"JANUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B17)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201301 EGSR.xlsx"},{"$error":"#REF!"},{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":""},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":""},{"$f":"IFERROR($F17-$N17,\"\")","v":""}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201302 EGSR.xlsx"},{"$error":"#REF!"},{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":""},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":""},{"$f":"IFERROR($F18-$N18,\"\")","v":""}]
[null,"MARCH","TSU201303 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","TSU201304 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"MAY","TSU201305 EGSR.xlsx",0,1,24,0,7,17,0,1,0,0,0,0,17,24]
[null,"JUNE","TSU201306 EGSR.xlsx",17,1,72,0,36,53,0,1,0,0,0,0,53,72]
[null,"JULY","TSU201307 EGSR.xlsx",53,1,0,0,11,42,0,1,0,0,0,0,42,0]
[null,"AUGUST","TSU201308 EGSR.xlsx",42,1,72,0,46,68,0,1,0,0,0,0,68,72]
[null,"SEPTEMBER","TSU201309 EGSR.xlsx",68,1,0,0,13,55,0,1,0,0,0,0,55,0]
[null,"OCTOBER","TSU201310 EGSR.xlsx",55,1,0,0,14,41,0,1,0,0,0,0,41,0]
[null,"NOVEMBER","TSU201311 EGSR.xlsx",41,1,72,0,47,66,0,1,0,0,0,0,66,72]
[null,"DECEMBER","TSU201312 EGSR.xlsx",66,1,0,0,16,50,0,1,0,0,0,0,50,0]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":0},null,{"$f":"SUM(F$17:F$28)","v":{"$error":"#REF!"}},{"$f":"SUM(G$17:G$28)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$D$29+$F$29+$G$29-$H$29","v":{"$error":"#REF!"}},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":0},null,{"$f":"SUM(L$17:L$28)","v":{"$error":"#REF!"}},{"$f":"SUM(M$17:M$28)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$J$29+$L$29-$M$29-$N$29","v":{"$error":"#REF!"}},{"$f":"$I29+$O29","v":{"$error":"#REF!"}},null,{"$f":"SUM(R$17:R$28)","v":0},{"$f":"SUM(S$17:S$28)","v":0}]
[null,"* STOCK PURCHASED INCLUDES STOCK FORFEITED FROM CUSTODY"]
[null,"Copyright © 2012 by Oracle Symphony Sdn Bhd"]

{"sheet":"STRONGBOW","index":6,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,3,5,5],[7,3,7,5],[9,3,9,5]]}
[]
[]
[null,null,null,"ANNUAL STOCK SUMMARY OF ESSENTIAL GOODS BY TYPE"]
[]
[]
[null,"OUTLET",null,{"$f":"Summary!C6","v":"TSU"}]
[]
[null,"YEAR",null,{"$f":"Summary!C8","v":"2013"}]
[]
[null,"TYPE OF BEER",null,{"$f":"MID(CELL(\"FILENAME\",$A$1),FIND(\"]\",CELL(\"FILENAME\",$A$1))+1,256)","v":"STRONGBOW"}]
[]
[]
[null,"MONTH","FILE NAME","FOR REGULAR STOCK",null,null,null,null,null,"FOR CUSTODY STOCK",null,null,null,null,null,"CLOSING","PURCHASED","LOSSES ( - )  /  GAINS ( + )"]
[null,null,null,"OPENING","ROW","IN ( + )",null,"OUT ( - )","BALANCE","OPENING","ROW","IN ( + )","OUT ( - )",null,"BALANCE",null,"excluding ","REGULAR","CUSTODY"]
[null,null,null,null,null,"PURCHASED *","INCENTIVE","SOLD","STOCK",null,null,"DEPOSITED","REDEEMED","FORFEITED","STOCK",null,"forfeited","STOCK","STOCK"]
[null,null,null,"( bottles )",null,"( bottles )","( bottles )","( bottles )","( bottles )","( bottles )",null,"( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )"]
[null,"JANUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B17)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201301 EGSR.xlsx"},{"$error":"#REF!"},{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":""},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":""},{"$f":"IFERROR($F17-$N17,\"\")","v":""}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201302 EGSR.xlsx"},{"$error":"#REF!"},{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":""},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":""},{"$f":"IFERROR($F18-$N18,\"\")","v":""}]
[null,"MARCH","TSU201303 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","TSU201304 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"MAY","TSU201305 EGSR.xlsx",0,1,24,0,8,16,0,1,0,0,0,0,16,24]
[null,"JUNE","TSU201306 EGSR.xlsx",16,1,72,0,37,51,0,1,0,0,0,0,51,72]
[null,"JULY","TSU201307 EGSR.xlsx",51,1,24,0,35,40,0,1,0,0,0,0,40,24]
[null,"AUGUST","TSU201308 EGSR.xlsx",40,1,72,0,59,53,0,1,0,0,0,0,53,72]
[null,"SEPTEMBER","TSU201309 EGSR.xlsx",53,1,24,0,55,22,0,1,0,0,0,0,22,24]
[null,"OCTOBER","TSU201310 EGSR.xlsx",22,1,48,0,35,35,0,1,0,0,0,0,35,48]
[null,"NOVEMBER","TSU201311 EGSR.xlsx",35,1,0,0,35,0,0,1,0,0,0,0,0,0]
[null,"DECEMBER","TSU201312 EGSR.xlsx",0,1,72,0,2,70,0,1,0,0,0,0,70,72]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":0},null,{"$f":"SUM(F$17:F$28)","v":{"$error":"#REF!"}},{"$f":"SUM(G$17:G$28)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$D$29+$F$29+$G$29-$H$29","v":{"$error":"#REF!"}},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":0},null,{"$f":"SUM(L$17:L$28)","v":{"$error":"#REF!"}},{"$f":"SUM(M$17:M$28)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$J$29+$L$29-$M$29-$N$29","v":{"$error":"#REF!"}},{"$f":"$I29+$O29","v":{"$error":"#REF!"}},null,{"$f":"SUM(R$17:R$28)","v":0},{"$f":"SUM(S$17:S$28)","v":0}]
[null,"* STOCK PURCHASED INCLUDES STOCK FORFEITED FROM CUSTODY"]
[null,"Copyright © 2012 by Oracle Symphony Sdn Bhd"]

{"sheet":"HOEGAARDEN","index":7,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,3,5,5],[7,3,7,5],[9,3,9,5]]}
[]
[]
[null,null,null,"ANNUAL STOCK SUMMARY OF ESSENTIAL GOODS BY TYPE"]
[]
[]
[null,"OUTLET",null,{"$f":"Summary!C6","v":"TSU"}]
[]
[null,"YEAR",null,{"$f":"Summary!C8","v":"2013"}]
[]
[null,"TYPE OF BEER",null,{"$f":"MID(CELL(\"FILENAME\",$A$1),FIND(\"]\",CELL(\"FILENAME\",$A$1))+1,256)","v":"HOEGAARDEN"}]
[]
[]
[null,"MONTH","FILE NAME","FOR REGULAR STOCK",null,null,null,null,null,"FOR CUSTODY STOCK",null,null,null,null,null,"CLOSING","PURCHASED","LOSSES ( - )  /  GAINS ( + )"]
[null,null,null,"OPENING","ROW","IN ( + )",null,"OUT ( - )","BALANCE","OPENING","ROW","IN ( + )","OUT ( - )",null,"BALANCE",null,"excluding ","REGULAR","CUSTODY"]
[null,null,null,null,null,"PURCHASED *","INCENTIVE","SOLD","STOCK",null,null,"DEPOSITED","REDEEMED","FORFEITED","STOCK",null,"forfeited","STOCK","STOCK"]
[null,null,null,"( bottles )",null,"( bottles )","( bottles )","( bottles )","( bottles )","( bottles )",null,"( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )"]
[null,"JANUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B17)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201301 EGSR.xlsx"},{"$error":"#REF!"},{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":""},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":""},{"$f":"IFERROR($F17-$N17,\"\")","v":""}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201302 EGSR.xlsx"},{"$error":"#REF!"},{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":""},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":""},{"$f":"IFERROR($F18-$N18,\"\")","v":""}]
[null,"MARCH","TSU201303 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","TSU201304 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"MAY","TSU201305 EGSR.xlsx",0,1,48,0,15,33,0,1,0,0,0,0,33,48]
[null,"JUNE","TSU201306 EGSR.xlsx",33,1,144,0,131,46,0,1,0,0,0,0,46,144]
[null,"JULY","TSU201307 EGSR.xlsx",46,1,48,0,67,27,0,1,0,0,0,0,27,48]
[null,"AUGUST","TSU201308 EGSR.xlsx",27,1,168,0,151,44,0,1,2,0,0,2,46,168]
[null,"SEPTEMBER","TSU201309 EGSR.xlsx",44,1,98,0,95,47,2,1,0,0,2,0,47,96]
[null,"OCTOBER","TSU201310 EGSR.xlsx",47,1,120,0,111,56,0,1,3,0,0,3,59,120]
[null,"NOVEMBER","TSU201311 EGSR.xlsx",56,1,96,0,73,79,3,1,0,2,0,1,80,96]
[null,"DECEMBER","TSU201312 EGSR.xlsx",79,1,49,0,73,55,1,1,0,0,1,0,55,48]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":0},null,{"$f":"SUM(F$17:F$28)","v":{"$error":"#REF!"}},{"$f":"SUM(G$17:G$28)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$D$29+$F$29+$G$29-$H$29","v":{"$error":"#REF!"}},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":0},null,{"$f":"SUM(L$17:L$28)","v":{"$error":"#REF!"}},{"$f":"SUM(M$17:M$28)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$J$29+$L$29-$M$29-$N$29","v":{"$error":"#REF!"}},{"$f":"$I29+$O29","v":{"$error":"#REF!"}},null,{"$f":"SUM(R$17:R$28)","v":0},{"$f":"SUM(S$17:S$28)","v":0}]
[null,"* STOCK PURCHASED INCLUDES STOCK FORFEITED FROM CUSTODY"]
[null,"Copyright © 2012 by Oracle Symphony Sdn Bhd"]

{"sheet":"APPLE CIDER","index":8,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,3,5,5],[7,3,7,5],[9,3,9,5]]}
[]
[]
[null,null,null,"ANNUAL STOCK SUMMARY OF ESSENTIAL GOODS BY TYPE"]
[]
[]
[null,"OUTLET",null,{"$f":"Summary!C6","v":"TSU"}]
[]
[null,"YEAR",null,{"$f":"Summary!C8","v":"2013"}]
[]
[null,"TYPE OF BEER",null,{"$f":"MID(CELL(\"FILENAME\",$A$1),FIND(\"]\",CELL(\"FILENAME\",$A$1))+1,256)","v":"APPLE CIDER"}]
[]
[]
[null,"MONTH","FILE NAME","FOR REGULAR STOCK",null,null,null,null,null,"FOR CUSTODY STOCK",null,null,null,null,null,"CLOSING","PURCHASED","LOSSES ( - )  /  GAINS ( + )"]
[null,null,null,"OPENING","ROW","IN ( + )",null,"OUT ( - )","BALANCE","OPENING","ROW","IN ( + )","OUT ( - )",null,"BALANCE",null,"excluding ","REGULAR","CUSTODY"]
[null,null,null,null,null,"PURCHASED *","INCENTIVE","SOLD","STOCK",null,null,"DEPOSITED","REDEEMED","FORFEITED","STOCK",null,"forfeited","STOCK","STOCK"]
[null,null,null,"( bottles )",null,"( bottles )","( bottles )","( bottles )","( bottles )","( bottles )",null,"( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )","( bottles )"]
[null,"JANUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B17)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201301 EGSR.xlsx"},{"$error":"#REF!"},{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":""},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":""},{"$f":"IFERROR($F17-$N17,\"\")","v":""}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201302 EGSR.xlsx"},{"$error":"#REF!"},{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":""},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":""},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":""},{"$f":"IFERROR($F18-$N18,\"\")","v":""}]
[null,"MARCH","TSU201303 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","TSU201304 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"MAY","TSU201305 EGSR.xlsx",0,1,46,0,23,23,0,1,0,0,0,0,23,46]
[null,"JUNE","TSU201306 EGSR.xlsx",23,1,144,0,146,21,0,1,2,0,0,2,23,144]
[null,"JULY","TSU201307 EGSR.xlsx",21,1,96,0,83,34,2,1,7,3,0,6,40,96]
[null,"AUGUST","TSU201308 EGSR.xlsx",34,1,150,0,143,41,6,1,8,5,6,3,44,144]
[null,"SEPTEMBER","TSU201309 EGSR.xlsx",41,1,120,0,138,23,3,1,3,6,0,0,23,120]
[null,"OCTOBER","TSU201310 EGSR.xlsx",23,1,120,0,122,21,0,1,0,0,0,0,21,120]
[null,"NOVEMBER","TSU201311 EGSR.xlsx",21,1,144,0,95,70,0,1,2,0,0,2,72,144]
[null,"DECEMBER","TSU201312 EGSR.xlsx",70,1,74,0,114,30,2,1,2,2,2,0,30,72]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":0},null,{"$f":"SUM(F$17:F$28)","v":{"$error":"#REF!"}},{"$f":"SUM(G$17:G$28)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$D$29+$F$29+$G$29-$H$29","v":{"$error":"#REF!"}},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":0},null,{"$f":"SUM(L$17:L$28)","v":{"$error":"#REF!"}},{"$f":"SUM(M$17:M$28)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$J$29+$L$29-$M$29-$N$29","v":{"$error":"#REF!"}},{"$f":"$I29+$O29","v":{"$error":"#REF!"}},null,{"$f":"SUM(R$17:R$28)","v":0},{"$f":"SUM(S$17:S$28)","v":0}]
[null,"* STOCK PURCHASED INCLUDES STOCK FORFEITED FROM CUSTODY"]
[null,"Copyright © 2012 by Oracle Symphony Sdn Bhd"]