{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Summary","GUINNESS","HEINEKEN","TIGER","TIGER RADLER","PAULANAR","HOEGAARDEN","STRONGBOW","APPLE CIDER","CIGARETTES"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":18,"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":"2014"}]
[]
[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\\YR2014\\TMA\\"}]
[]
[null,"CELL LINK",4]
[]
[]
[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":216},{"$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":217},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":40},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$M$17:$M$28\"),$C$14,1),\"\"),\"\")","v":31},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$N$17:$N$28\"),$C$14,1),\"\"),\"\")","v":2},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$P$17:$P$28\"),$C$14,1),\"\"),\"\")","v":85}]
[null,"HEINEKEN",{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$Q$17:$Q$28\"),$C$14,1),\"\"),\"\")","v":1584},{"$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":1532},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":146},{"$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":26},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$P$17:$P$28\"),$C$14,1),\"\"),\"\")","v":594}]
[null,"TIGER",2832,0,2676,274,241,63,682]
[null,"CIGARETTES",165,0,128,0,0,0,103]
[null,"PAULANAR",24,0,53,0,0,0,8]
[null,"APPLE CIDER","","","","","","",""]
[null,"HOEGAARDEN",96,0,91,2,2,0,53]
[null,"STRONGBOW",24,0,30,0,0,0,51]
[null,"TIGER RADLER","","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,"TOTAL",{"$f":"SUM(C$21:C$35)","v":4941},{"$f":"SUM(D$21:D$35)","v":0},4727,462,380,91,1576]
[]
[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":"2014"}]
[]
[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":"TMA201401 EGSR.xlsx"},58,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},222,0,174,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":106},13,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},15,15,6,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":7},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":113},{"$f":"IFERROR($F17-$N17,\"\")","v":216}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TMA201402 EGSR.xlsx"},106,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},96,0,152,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":50},7,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},20,16,0,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":11},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":61},{"$f":"IFERROR($F18-$N18,\"\")","v":96}]
[null,"MARCH","TMA201403 EGSR.xlsx",50,1,197,0,184,63,11,1,15,7,5,14,77,192]
[null,"APRIL","TMA201404 EGSR.xlsx",63,1,218,0,217,64,14,1,40,31,2,21,85,216]
[null,"MAY","TMA201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","TMA201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TMA201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TMA201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TMA201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TMA201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TMA201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TMA201412 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":58},null,{"$f":"SUM(F$17:F$28)","v":733},{"$f":"SUM(G$17:G$28)","v":0},727,{"$f":"$D$29+$F$29+$G$29-$H$29","v":64},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":13},null,{"$f":"SUM(L$17:L$28)","v":90},{"$f":"SUM(M$17:M$28)","v":69},13,{"$f":"$J$29+$L$29-$M$29-$N$29","v":21},{"$f":"$I29+$O29","v":85},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":"2014"}]
[]
[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":"TMA201401 EGSR.xlsx"},241,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},1927,0,1546,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":622},64,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},128,41,31,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":120},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":742},{"$f":"IFERROR($F17-$N17,\"\")","v":1896}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TMA201402 EGSR.xlsx"},622,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},1500,0,1678,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":444},120,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},163,75,60,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":148},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":592},{"$f":"IFERROR($F18-$N18,\"\")","v":1440}]
[null,"MARCH","TMA201403 EGSR.xlsx",444,1,1444,0,1493,395,148,1,132,121,52,107,502,1392]
[null,"APRIL","TMA201404 EGSR.xlsx",395,1,1610,0,1532,473,107,1,146,106,26,121,594,1584]
[null,"MAY","TMA201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","TMA201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TMA201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TMA201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TMA201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TMA201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TMA201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TMA201412 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":241},null,{"$f":"SUM(F$17:F$28)","v":6481},{"$f":"SUM(G$17:G$28)","v":0},6249,{"$f":"$D$29+$F$29+$G$29-$H$29","v":473},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":64},null,{"$f":"SUM(L$17:L$28)","v":569},{"$f":"SUM(M$17:M$28)","v":343},169,{"$f":"$J$29+$L$29-$M$29-$N$29","v":121},{"$f":"$I29+$O29","v":594},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":"2014"}]
[]
[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":"TMA201401 EGSR.xlsx"},190,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},4529,0,3540,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":1179},191,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},402,281,17,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":295},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":1474},{"$f":"IFERROR($F17-$N17,\"\")","v":4512}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TMA201402 EGSR.xlsx"},1179,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},2418,0,3073,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":524},295,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},367,315,66,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":281},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":805},{"$f":"IFERROR($F18-$N18,\"\")","v":2352}]
[null,"MARCH","TMA201403 EGSR.xlsx",523,1,2408,0,2665,266,281,1,311,261,104,227,493,2304]
[null,"APRIL","TMA201404 EGSR.xlsx",266,1,2895,0,2676,485,227,1,274,241,63,197,682,2832]
[null,"MAY","TMA201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","TMA201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TMA201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TMA201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TMA201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TMA201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TMA201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TMA201412 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":190},null,{"$f":"SUM(F$17:F$28)","v":12250},{"$f":"SUM(G$17:G$28)","v":0},11954,{"$f":"$D$29+$F$29+$G$29-$H$29","v":486},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":191},null,{"$f":"SUM(L$17:L$28)","v":1354},{"$f":"SUM(M$17:M$28)","v":1098},250,{"$f":"$J$29+$L$29-$M$29-$N$29","v":197},{"$f":"$I29+$O29","v":683},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 RADLER","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":"2014"}]
[]
[null,"TYPE OF BEER",null,{"$f":"MID(CELL(\"FILENAME\",$A$1),FIND(\"]\",CELL(\"FILENAME\",$A$1))+1,256)","v":"TIGER RADLER"}]
[]
[]
[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":"TMA201401 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":"TMA201402 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","TMA201403 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","TMA201404 EGSR.xlsx",0,1,120,0,32,88,0,1,0,0,0,0,88,120]
[null,"MAY","TMA201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","TMA201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TMA201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TMA201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TMA201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TMA201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TMA201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TMA201412 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",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":"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":"TMA"}]
[]
[null,"YEAR",null,{"$f":"Summary!C8","v":"2014"}]
[]
[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":"TMA201401 EGSR.xlsx"},47,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},24,0,26,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":45},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":45},{"$f":"IFERROR($F17-$N17,\"\")","v":24}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TMA201402 EGSR.xlsx"},45,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},0,0,12,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":33},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":33},{"$f":"IFERROR($F18-$N18,\"\")","v":0}]
[null,"MARCH","TMA201403 EGSR.xlsx",33,1,48,0,44,37,0,1,0,0,0,0,37,48]
[null,"APRIL","TMA201404 EGSR.xlsx",37,1,24,0,53,8,0,1,0,0,0,0,8,24]
[null,"MAY","TMA201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","TMA201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TMA201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TMA201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TMA201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TMA201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TMA201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TMA201412 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":47},null,{"$f":"SUM(F$17:F$28)","v":96},{"$f":"SUM(G$17:G$28)","v":0},135,{"$f":"$D$29+$F$29+$G$29-$H$29","v":8},{"$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":8},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":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":"2014"}]
[]
[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":"TMA201401 EGSR.xlsx"},32,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},144,0,115,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":61},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":61},{"$f":"IFERROR($F17-$N17,\"\")","v":144}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TMA201402 EGSR.xlsx"},61,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},48,0,84,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":25},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":25},{"$f":"IFERROR($F18-$N18,\"\")","v":48}]
[null,"MARCH","TMA201403 EGSR.xlsx",25,1,96,0,75,46,0,1,2,0,0,2,48,96]
[null,"APRIL","TMA201404 EGSR.xlsx",46,1,96,0,91,51,2,1,2,2,0,2,53,96]
[null,"MAY","TMA201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","TMA201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TMA201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TMA201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TMA201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TMA201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TMA201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TMA201412 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":32},null,{"$f":"SUM(F$17:F$28)","v":384},{"$f":"SUM(G$17:G$28)","v":0},365,{"$f":"$D$29+$F$29+$G$29-$H$29","v":51},{"$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":4},{"$f":"SUM(M$17:M$28)","v":2},0,{"$f":"$J$29+$L$29-$M$29-$N$29","v":2},{"$f":"$I29+$O29","v":53},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":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":"2014"}]
[]
[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":"TMA201401 EGSR.xlsx"},51,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},0,0,24,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":27},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":27},{"$f":"IFERROR($F17-$N17,\"\")","v":0}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TMA201402 EGSR.xlsx"},27,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},0,0,24,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":3},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":3},{"$f":"IFERROR($F18-$N18,\"\")","v":0}]
[null,"MARCH","TMA201403 EGSR.xlsx",3,1,72,0,18,57,0,1,0,0,0,0,57,72]
[null,"APRIL","TMA201404 EGSR.xlsx",57,1,24,0,30,51,0,1,0,0,0,0,51,24]
[null,"MAY","TMA201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","TMA201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TMA201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TMA201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TMA201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TMA201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TMA201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TMA201412 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":51},null,{"$f":"SUM(F$17:F$28)","v":96},{"$f":"SUM(G$17:G$28)","v":0},96,{"$f":"$D$29+$F$29+$G$29-$H$29","v":51},{"$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":51},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":"TMA"}]
[]
[null,"YEAR",null,{"$f":"Summary!C8","v":"2014"}]
[]
[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":"TMA201401 EGSR.xlsx"},38,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},96,0,92,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":42},2,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},2,2,0,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":2},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":44},{"$f":"IFERROR($F17-$N17,\"\")","v":96}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TMA201402 EGSR.xlsx"},42,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},72,0,67,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":47},2,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},0,2,0,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":0},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":47},{"$f":"IFERROR($F18-$N18,\"\")","v":72}]
[null,"MARCH","TMA201403 EGSR.xlsx",47,1,96,0,80,63,0,1,2,0,0,2,65,96]
[null,"APRIL","TMA201404 EGSR.xlsx",63,1,144,0,160,47,2,1,1,0,0,3,50,144]
[null,"MAY","TMA201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","TMA201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TMA201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TMA201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TMA201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TMA201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TMA201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TMA201412 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":38},null,{"$f":"SUM(F$17:F$28)","v":408},{"$f":"SUM(G$17:G$28)","v":0},399,{"$f":"$D$29+$F$29+$G$29-$H$29","v":47},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":2},null,{"$f":"SUM(L$17:L$28)","v":5},{"$f":"SUM(M$17:M$28)","v":4},0,{"$f":"$J$29+$L$29-$M$29-$N$29","v":3},{"$f":"$I29+$O29","v":50},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":9,"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":"2014"}]
[]
[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":"TMA201401 EGSR.xlsx"},173,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},170,0,122,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":221},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":221},{"$f":"IFERROR($F17-$N17,\"\")","v":170}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TMA201402 EGSR.xlsx"},221,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},0,0,141,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":80},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":80},{"$f":"IFERROR($F18-$N18,\"\")","v":0}]
[null,"MARCH","TMA201403 EGSR.xlsx",80,1,100,0,114,66,0,1,0,0,0,0,66,100]
[null,"APRIL","TMA201404 EGSR.xlsx",66,1,165,0,128,103,0,1,0,0,0,0,103,165]
[null,"MAY","TMA201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","TMA201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TMA201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TMA201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TMA201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TMA201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TMA201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TMA201412 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":173},null,{"$f":"SUM(F$17:F$28)","v":435},{"$f":"SUM(G$17:G$28)","v":0},505,{"$f":"$D$29+$F$29+$G$29-$H$29","v":103},{"$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":103},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"]