{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Summary","GUINNESS","HEINEKEN","TIGER","PAULANAR","HOEGAARDEN","STRONGBOW","APPLE CIDER","CIGARETTES"],"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":38,"n_cols":9,"rows_kept":38,"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":"TMA"}]
[]
[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\\TMA\\"}]
[]
[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":96},{"$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":134},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":10},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$M$17:$M$28\"),$C$14,1),\"\"),\"\")","v":6},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$N$17:$N$28\"),$C$14,1),\"\"),\"\")","v":6},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$P$17:$P$28\"),$C$14,1),\"\"),\"\")","v":71}]
[null,"HEINEKEN",{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$Q$17:$Q$28\"),$C$14,1),\"\"),\"\")","v":1392},{"$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":1440},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":101},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$M$17:$M$28\"),$C$14,1),\"\"),\"\")","v":106},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$N$17:$N$28\"),$C$14,1),\"\"),\"\")","v":0},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$P$17:$P$28\"),$C$14,1),\"\"),\"\")","v":305}]
[null,"TIGER",3264,0,3453,282,177,24,381]
[null,"CIGARETTES",216,0,133,0,0,0,173]
[null,"PAULANAR",24,0,14,0,0,0,47]
[null,"APPLE CIDER","","","","","","",""]
[null,"HOEGAARDEN",144,0,146,0,0,1,32]
[null,"STRONGBOW",48,0,33,0,0,0,51]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,"TOTAL",{"$f":"SUM(C$21:C$35)","v":5184},{"$f":"SUM(D$21:D$35)","v":0},5353,393,289,31,1060]
[]
[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":"TMA"}]
[]
[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":"TMA201301 EGSR.xlsx"},61,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},126,0,113,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":74},24,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},29,32,6,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":15},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":89},{"$f":"IFERROR($F17-$N17,\"\")","v":120}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TMA201302 EGSR.xlsx"},74,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},99,0,129,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":44},15,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},24,27,3,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":9},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":53},{"$f":"IFERROR($F18-$N18,\"\")","v":96}]
[null,"MARCH","TMA201303 EGSR.xlsx",44,1,168,0,138,74,9,1,16,18,0,7,81,168]
[null,"APRIL","TMA201304 EGSR.xlsx",74,1,171,0,167,78,7,1,10,4,3,10,88,168]
[null,"MAY","TMA201305 EGSR.xlsx",78,1,216,0,189,105,10,1,27,1,0,36,141,216]
[null,"JUNE","TMA201306 EGSR.xlsx",105,1,81,0,142,44,36,1,35,41,9,21,65,72]
[null,"JULY","TMA201307 EGSR.xlsx",44,1,113,0,126,31,21,1,9,2,17,11,42,96]
[null,"AUGUST","TMA201308 EGSR.xlsx",31,1,171,0,176,26,11,1,9,12,3,5,31,168]
[null,"SEPTEMBER","TMA201309 EGSR.xlsx",26,1,289,0,274,41,5,1,35,21,1,18,59,288]
[null,"OCTOBER","TMA201310 EGSR.xlsx",41,1,225,0,225,41,18,1,48,35,9,22,63,216]
[null,"NOVEMBER","TMA201311 EGSR.xlsx",41,1,195,0,146,90,22,1,28,32,3,15,105,192]
[null,"DECEMBER","TMA201312 EGSR.xlsx",90,1,102,0,134,58,15,1,10,6,6,13,71,96]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":61},null,{"$f":"SUM(F$17:F$28)","v":1956},{"$f":"SUM(G$17:G$28)","v":0},1959,{"$f":"$D$29+$F$29+$G$29-$H$29","v":58},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":24},null,{"$f":"SUM(L$17:L$28)","v":280},{"$f":"SUM(M$17:M$28)","v":231},60,{"$f":"$J$29+$L$29-$M$29-$N$29","v":13},{"$f":"$I29+$O29","v":71},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":"TMA"}]
[]
[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":"TMA201301 EGSR.xlsx"},569,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},1330,0,1525,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":374},58,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},145,76,10,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":117},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":491},{"$f":"IFERROR($F17-$N17,\"\")","v":1320}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TMA201302 EGSR.xlsx"},374,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},1720,0,1589,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":505},117,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},275,253,40,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":99},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":604},{"$f":"IFERROR($F18-$N18,\"\")","v":1680}]
[null,"MARCH","TMA201303 EGSR.xlsx",505,1,1218,0,1447,276,99,1,168,172,18,77,353,1200]
[null,"APRIL","TMA201304 EGSR.xlsx",276,1,1882,0,1737,421,77,1,144,85,34,102,523,1848]
[null,"MAY","TMA201305 EGSR.xlsx",421,1,1569,0,1485,505,102,1,131,143,9,81,586,1560]
[null,"JUNE","TMA201306 EGSR.xlsx",505,1,1074,0,1300,279,81,1,97,92,18,68,347,1056]
[null,"JULY","TMA201307 EGSR.xlsx",279,1,1099,0,1140,238,68,1,101,78,19,72,310,1080]
[null,"AUGUST","TMA201308 EGSR.xlsx",238,1,1471,0,1518,191,72,1,107,97,7,75,266,1464]
[null,"SEPTEMBER","TMA201309 EGSR.xlsx",191,1,1774,0,1624,341,75,1,86,55,22,84,425,1752]
[null,"OCTOBER","TMA201310 EGSR.xlsx",341,1,1352,0,1466,227,84,1,104,122,8,58,285,1344]
[null,"NOVEMBER","TMA201311 EGSR.xlsx",227,1,1348,0,1286,289,58,1,113,98,4,69,358,1344]
[null,"DECEMBER","TMA201312 EGSR.xlsx",289,1,1392,0,1440,241,69,1,101,106,0,64,305,1392]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":569},null,{"$f":"SUM(F$17:F$28)","v":17229},{"$f":"SUM(G$17:G$28)","v":0},17557,{"$f":"$D$29+$F$29+$G$29-$H$29","v":241},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":58},null,{"$f":"SUM(L$17:L$28)","v":1572},{"$f":"SUM(M$17:M$28)","v":1377},189,{"$f":"$J$29+$L$29-$M$29-$N$29","v":64},{"$f":"$I29+$O29","v":305},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":"TMA"}]
[]
[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":"TMA201301 EGSR.xlsx"},120,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},2199,0,2015,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":304},199,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},303,197,39,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":266},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":570},{"$f":"IFERROR($F17-$N17,\"\")","v":2160}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TMA201302 EGSR.xlsx"},304,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},1864,0,1801,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":367},266,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},222,250,64,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":174},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":541},{"$f":"IFERROR($F18-$N18,\"\")","v":1800}]
[null,"MARCH","TMA201303 EGSR.xlsx",367,1,2093,0,2108,352,174,1,212,197,53,136,488,2040]
[null,"APRIL","TMA201304 EGSR.xlsx",352,1,1960,0,1856,456,136,1,167,141,40,122,578,1920]
[null,"MAY","TMA201305 EGSR.xlsx",456,1,1776,0,1670,562,122,1,227,187,24,138,700,1752]
[null,"JUNE","TMA201306 EGSR.xlsx",562,1,1829,0,2182,209,138,1,227,146,29,190,399,1800]
[null,"JULY","TMA201307 EGSR.xlsx",209,1,2198,0,2358,49,190,1,249,196,38,205,254,2160]
[null,"AUGUST","TMA201308 EGSR.xlsx",49,1,2605,0,2494,160,205,1,301,261,61,184,344,2544]
[null,"SEPTEMBER","TMA201309 EGSR.xlsx",160,1,2838,0,2656,342,184,1,230,208,54,152,494,2784]
[null,"OCTOBER","TMA201310 EGSR.xlsx",342,1,2749,0,2818,273,152,1,203,240,13,102,375,2736]
[null,"NOVEMBER","TMA201311 EGSR.xlsx",273,1,3265,24,3207,355,102,1,230,197,25,110,465,3240]
[null,"DECEMBER","TMA201312 EGSR.xlsx",355,1,3288,0,3453,190,110,1,282,177,24,191,381,3264]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":120},null,{"$f":"SUM(F$17:F$28)","v":28664},{"$f":"SUM(G$17:G$28)","v":24},28618,{"$f":"$D$29+$F$29+$G$29-$H$29","v":190},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":199},null,{"$f":"SUM(L$17:L$28)","v":2853},{"$f":"SUM(M$17:M$28)","v":2397},464,{"$f":"$J$29+$L$29-$M$29-$N$29","v":191},{"$f":"$I29+$O29","v":381},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":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":"TMA"}]
[]
[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":"TMA201301 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":"TMA201302 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","TMA201303 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","TMA201304 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"MAY","TMA201305 EGSR.xlsx",0,1,72,0,22,50,0,1,0,0,0,0,50,72]
[null,"JUNE","TMA201306 EGSR.xlsx",50,1,48,0,54,44,0,1,0,0,0,0,44,48]
[null,"JULY","TMA201307 EGSR.xlsx",44,1,24,0,10,58,0,1,0,0,0,0,58,24]
[null,"AUGUST","TMA201308 EGSR.xlsx",58,1,0,0,15,43,0,1,0,0,0,0,43,0]
[null,"SEPTEMBER","TMA201309 EGSR.xlsx",43,1,24,0,13,54,0,1,0,0,0,0,54,24]
[null,"OCTOBER","TMA201310 EGSR.xlsx",54,1,0,0,12,42,0,1,0,0,0,0,42,0]
[null,"NOVEMBER","TMA201311 EGSR.xlsx",42,1,0,0,5,37,0,1,0,0,0,0,37,0]
[null,"DECEMBER","TMA201312 EGSR.xlsx",37,1,24,0,14,47,0,1,0,0,0,0,47,24]
[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":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":"TMA"}]
[]
[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":"TMA201301 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":"TMA201302 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","TMA201303 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","TMA201304 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"MAY","TMA201305 EGSR.xlsx",0,1,72,0,32,40,0,1,0,0,0,0,40,72]
[null,"JUNE","TMA201306 EGSR.xlsx",40,1,144,0,154,30,0,1,4,0,0,4,34,144]
[null,"JULY","TMA201307 EGSR.xlsx",30,1,120,0,118,32,4,1,1,2,0,3,35,120]
[null,"AUGUST","TMA201308 EGSR.xlsx",32,1,122,0,103,51,3,1,1,1,2,1,52,120]
[null,"SEPTEMBER","TMA201309 EGSR.xlsx",51,1,25,0,60,16,1,1,0,0,1,0,16,24]
[null,"OCTOBER","TMA201310 EGSR.xlsx",16,1,96,0,70,42,0,1,1,0,0,1,43,96]
[null,"NOVEMBER","TMA201311 EGSR.xlsx",42,1,72,0,81,33,1,1,0,0,0,1,34,72]
[null,"DECEMBER","TMA201312 EGSR.xlsx",33,1,145,0,146,32,1,1,0,0,1,0,32,144]
[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":"TMA"}]
[]
[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":"TMA201301 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":"TMA201302 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","TMA201303 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","TMA201304 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"MAY","TMA201305 EGSR.xlsx",0,1,24,0,6,18,0,1,0,0,0,0,18,24]
[null,"JUNE","TMA201306 EGSR.xlsx",18,1,24,0,27,15,0,1,0,0,0,0,15,24]
[null,"JULY","TMA201307 EGSR.xlsx",15,1,72,0,13,74,0,1,0,0,0,0,74,72]
[null,"AUGUST","TMA201308 EGSR.xlsx",74,1,0,0,13,61,0,1,3,3,0,0,61,0]
[null,"SEPTEMBER","TMA201309 EGSR.xlsx",61,1,48,0,51,58,0,1,0,0,0,0,58,48]
[null,"OCTOBER","TMA201310 EGSR.xlsx",58,1,0,0,21,37,0,1,4,4,0,0,37,0]
[null,"NOVEMBER","TMA201311 EGSR.xlsx",37,1,24,0,25,36,0,1,0,0,0,0,36,24]
[null,"DECEMBER","TMA201312 EGSR.xlsx",36,1,48,0,33,51,0,1,0,0,0,0,51,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":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":"TMA"}]
[]
[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":"TMA201301 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":"TMA201302 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","TMA201303 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","TMA201304 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"MAY","TMA201305 EGSR.xlsx",0,1,48,0,28,20,0,1,0,0,0,0,20,48]
[null,"JUNE","TMA201306 EGSR.xlsx",20,1,72,0,35,57,0,1,0,0,0,0,57,72]
[null,"JULY","TMA201307 EGSR.xlsx",57,1,48,0,91,14,0,1,4,4,0,0,14,48]
[null,"AUGUST","TMA201308 EGSR.xlsx",14,1,120,0,88,46,0,1,5,1,0,4,50,120]
[null,"SEPTEMBER","TMA201309 EGSR.xlsx",46,1,50,0,58,38,4,1,1,2,2,1,39,48]
[null,"OCTOBER","TMA201310 EGSR.xlsx",38,1,48,0,58,28,1,1,9,1,0,9,37,48]
[null,"NOVEMBER","TMA201311 EGSR.xlsx",28,1,97,0,105,20,9,1,0,2,1,6,26,96]
[null,"DECEMBER","TMA201312 EGSR.xlsx",20,1,102,0,84,38,6,1,2,0,6,2,40,96]
[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":"CIGARETTES","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":"TMA"}]
[]
[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":"TMA201301 EGSR.xlsx"},119,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},130,0,165,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":84},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":84},{"$f":"IFERROR($F17-$N17,\"\")","v":130}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TMA201302 EGSR.xlsx"},84,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},290,0,175,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":199},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":199},{"$f":"IFERROR($F18-$N18,\"\")","v":290}]
[null,"MARCH","TMA201303 EGSR.xlsx",199,1,160,0,192,167,0,1,0,0,0,0,167,160]
[null,"APRIL","TMA201304 EGSR.xlsx",167,1,80,0,159,88,0,1,0,0,0,0,88,80]
[null,"MAY","TMA201305 EGSR.xlsx",88,1,125,0,168,45,0,1,0,0,0,0,45,125]
[null,"JUNE","TMA201306 EGSR.xlsx",45,1,110,0,119,36,0,1,0,0,0,0,36,110]
[null,"JULY","TMA201307 EGSR.xlsx",36,1,140,0,116,60,0,1,0,0,0,0,60,140]
[null,"AUGUST","TMA201308 EGSR.xlsx",60,1,240,0,139,161,0,1,0,0,0,0,161,240]
[null,"SEPTEMBER","TMA201309 EGSR.xlsx",161,1,70,0,153,78,0,1,0,0,0,0,78,70]
[null,"OCTOBER","TMA201310 EGSR.xlsx",78,1,157,0,114,121,0,1,0,0,0,0,121,157]
[null,"NOVEMBER","TMA201311 EGSR.xlsx",121,1,90,0,121,90,0,1,0,0,0,0,90,90]
[null,"DECEMBER","TMA201312 EGSR.xlsx",90,1,216,0,133,173,0,1,0,0,0,0,173,216]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":119},null,{"$f":"SUM(F$17:F$28)","v":1808},{"$f":"SUM(G$17:G$28)","v":0},1754,{"$f":"$D$29+$F$29+$G$29-$H$29","v":173},{"$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":173},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"]