{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Summary","GUINNESS","HEINEKEN","TIGER","CIGARETTES","PAULANAR","STRONGBOW","HOEGAARDEN","TIGER RADLER","APPLE CIDER"],"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":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":"2014"}]
[]
[null,"MONTH"]
[]
[null,"FILE PATH",{"$f":"MID(CELL(\"FILENAME\",$A$1),1,FIND(\"[\",CELL(\"FILENAME\",$A$1))-1)","v":"Z:\\Purchasing\\Beer & EGSR\\EGSR Reports\\YR2014\\TSU\\"}]
[]
[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":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":117},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":3},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$M$17:$M$28\"),$C$14,1),\"\"),\"\")","v":2},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$N$17:$N$28\"),$C$14,1),\"\"),\"\")","v":0},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$P$17:$P$28\"),$C$14,1),\"\"),\"\")","v":75}]
[null,"HEINEKEN",{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$Q$17:$Q$28\"),$C$14,1),\"\"),\"\")","v":840},{"$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":961},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":74},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$M$17:$M$28\"),$C$14,1),\"\"),\"\")","v":63},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$N$17:$N$28\"),$C$14,1),\"\"),\"\")","v":1},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$P$17:$P$28\"),$C$14,1),\"\"),\"\")","v":478}]
[null,"TIGER",1560,0,1691,229,201,44,456]
[null,"CIGARETTES",200,0,223,0,0,0,91]
[null,"PAULANAR",48,0,24,0,0,0,52]
[null,"STRONGBOW",48,0,22,0,0,0,77]
[null,"HOEGAARDEN",24,0,93,0,0,0,45]
[null,"APPLE CIDER","","","","","","",""]
[null,"TIGER RADLER","","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,"TOTAL",{"$f":"SUM(C$21:C$34)","v":2864},{"$f":"SUM(D$21:D$34)","v":0},3131,306,266,45,1274]
[]
[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":"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":"TSU201401 EGSR.xlsx"},92,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},129,0,57,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":164},14,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},6,5,9,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":6},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":170},{"$f":"IFERROR($F17-$N17,\"\")","v":120}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201402 EGSR.xlsx"},164,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},4,0,102,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":66},6,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},24,16,4,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":10},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":76},{"$f":"IFERROR($F18-$N18,\"\")","v":0}]
[null,"MARCH","TSU201403 EGSR.xlsx",66,1,48,0,67,47,10,1,9,19,0,0,47,48]
[null,"APRIL","TSU201404 EGSR.xlsx",47,1,144,0,117,74,0,1,3,2,0,1,75,144]
[null,"MAY","TSU201405 EGSR.xlsx",74,1,73,0,134,13,1,1,11,5,1,6,19,72]
[null,"JUNE","TSU201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TSU201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TSU201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TSU201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TSU201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TSU201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TSU201412 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":92},null,{"$f":"SUM(F$17:F$28)","v":398},{"$f":"SUM(G$17:G$28)","v":0},477,{"$f":"$D$29+$F$29+$G$29-$H$29","v":13},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":14},null,{"$f":"SUM(L$17:L$28)","v":53},{"$f":"SUM(M$17:M$28)","v":47},14,{"$f":"$J$29+$L$29-$M$29-$N$29","v":6},{"$f":"$I29+$O29","v":19},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":"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":"TSU201401 EGSR.xlsx"},374,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},1330,0,1124,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":580},41,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},70,44,10,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":57},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":637},{"$f":"IFERROR($F17-$N17,\"\")","v":1320}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201402 EGSR.xlsx"},580,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},730,0,936,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":374},57,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},73,87,10,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":33},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":407},{"$f":"IFERROR($F18-$N18,\"\")","v":720}]
[null,"MARCH","TSU201403 EGSR.xlsx",374,1,1092,0,900,566,33,1,57,56,12,22,588,1080]
[null,"APRIL","TSU201404 EGSR.xlsx",566,1,841,0,961,446,22,1,74,63,1,32,478,840]
[null,"MAY","TSU201405 EGSR.xlsx",446,1,1084,0,1203,327,32,1,111,74,4,65,392,1080]
[null,"JUNE","TSU201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TSU201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TSU201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TSU201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TSU201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TSU201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TSU201412 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":374},null,{"$f":"SUM(F$17:F$28)","v":5077},{"$f":"SUM(G$17:G$28)","v":0},5124,{"$f":"$D$29+$F$29+$G$29-$H$29","v":327},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":41},null,{"$f":"SUM(L$17:L$28)","v":385},{"$f":"SUM(M$17:M$28)","v":324},37,{"$f":"$J$29+$L$29-$M$29-$N$29","v":65},{"$f":"$I29+$O29","v":392},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":"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":"TSU201401 EGSR.xlsx"},365,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},3176,0,2312,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":1229},208,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},322,229,56,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":245},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":1474},{"$f":"IFERROR($F17-$N17,\"\")","v":3120}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201402 EGSR.xlsx"},1229,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},1041,0,1812,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":458},245,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},209,195,81,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":178},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":636},{"$f":"IFERROR($F18-$N18,\"\")","v":960}]
[null,"MARCH","TSU201403 EGSR.xlsx",449,1,1838,0,1906,381,178,1,311,273,38,178,559,1800]
[null,"APRIL","TSU201404 EGSR.xlsx",381,1,1604,0,1691,294,178,1,229,201,44,162,456,1560]
[null,"MAY","TSU201405 EGSR.xlsx",294,1,2070,0,2111,253,162,1,223,194,30,161,414,2040]
[null,"JUNE","TSU201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TSU201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TSU201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TSU201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TSU201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TSU201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TSU201412 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":365},null,{"$f":"SUM(F$17:F$28)","v":9729},{"$f":"SUM(G$17:G$28)","v":0},9832,{"$f":"$D$29+$F$29+$G$29-$H$29","v":262},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":208},null,{"$f":"SUM(L$17:L$28)","v":1294},{"$f":"SUM(M$17:M$28)","v":1092},249,{"$f":"$J$29+$L$29-$M$29-$N$29","v":161},{"$f":"$I29+$O29","v":423},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":"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":"TSU201401 EGSR.xlsx"},63,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},450,0,236,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":277},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":277},{"$f":"IFERROR($F17-$N17,\"\")","v":450}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201402 EGSR.xlsx"},277,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},0,0,216,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":61},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":61},{"$f":"IFERROR($F18-$N18,\"\")","v":0}]
[null,"MARCH","TSU201403 EGSR.xlsx",61,1,250,0,197,114,0,1,0,0,0,0,114,250]
[null,"APRIL","TSU201404 EGSR.xlsx",114,1,200,0,223,91,0,1,0,0,0,0,91,200]
[null,"MAY","TSU201405 EGSR.xlsx",91,1,290,0,190,191,0,1,0,0,0,0,191,290]
[null,"JUNE","TSU201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TSU201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TSU201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TSU201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TSU201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TSU201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TSU201412 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":63},null,{"$f":"SUM(F$17:F$28)","v":1190},{"$f":"SUM(G$17:G$28)","v":0},1062,{"$f":"$D$29+$F$29+$G$29-$H$29","v":191},{"$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":191},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":"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":"TSU201401 EGSR.xlsx"},50,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},0,0,31,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":19},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":19},{"$f":"IFERROR($F17-$N17,\"\")","v":0}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201402 EGSR.xlsx"},19,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},24,0,17,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":26},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":26},{"$f":"IFERROR($F18-$N18,\"\")","v":24}]
[null,"MARCH","TSU201403 EGSR.xlsx",26,1,24,0,22,28,0,1,0,0,0,0,28,24]
[null,"APRIL","TSU201404 EGSR.xlsx",28,1,48,0,24,52,0,1,0,0,0,0,52,48]
[null,"MAY","TSU201405 EGSR.xlsx",52,1,24,0,16,60,0,1,0,0,0,0,60,24]
[null,"JUNE","TSU201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TSU201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TSU201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TSU201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TSU201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TSU201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TSU201412 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":50},null,{"$f":"SUM(F$17:F$28)","v":120},{"$f":"SUM(G$17:G$28)","v":0},110,{"$f":"$D$29+$F$29+$G$29-$H$29","v":60},{"$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":60},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":"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":"TSU201401 EGSR.xlsx"},70,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},48,0,14,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":104},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":104},{"$f":"IFERROR($F17-$N17,\"\")","v":48}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201402 EGSR.xlsx"},104,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},0,0,17,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":87},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":87},{"$f":"IFERROR($F18-$N18,\"\")","v":0}]
[null,"MARCH","TSU201403 EGSR.xlsx",87,1,0,0,36,51,0,1,0,0,0,0,51,0]
[null,"APRIL","TSU201404 EGSR.xlsx",51,1,48,0,22,77,0,1,0,0,0,0,77,48]
[null,"MAY","TSU201405 EGSR.xlsx",77,1,0,0,5,72,0,1,0,0,0,0,72,0]
[null,"JUNE","TSU201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TSU201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TSU201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TSU201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TSU201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TSU201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TSU201412 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":70},null,{"$f":"SUM(F$17:F$28)","v":96},{"$f":"SUM(G$17:G$28)","v":0},94,{"$f":"$D$29+$F$29+$G$29-$H$29","v":72},{"$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":72},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":"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":"TSU201401 EGSR.xlsx"},55,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},144,0,67,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":132},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":132},{"$f":"IFERROR($F17-$N17,\"\")","v":144}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201402 EGSR.xlsx"},132,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},0,0,90,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":42},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":42},{"$f":"IFERROR($F18-$N18,\"\")","v":0}]
[null,"MARCH","TSU201403 EGSR.xlsx",42,1,144,0,72,114,0,1,0,0,0,0,114,144]
[null,"APRIL","TSU201404 EGSR.xlsx",114,1,24,0,93,45,0,1,0,0,0,0,45,24]
[null,"MAY","TSU201405 EGSR.xlsx",45,1,120,0,107,58,0,1,1,1,0,0,58,120]
[null,"JUNE","TSU201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TSU201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TSU201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TSU201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TSU201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TSU201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TSU201412 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":55},null,{"$f":"SUM(F$17:F$28)","v":432},{"$f":"SUM(G$17:G$28)","v":0},429,{"$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":0},null,{"$f":"SUM(L$17:L$28)","v":1},{"$f":"SUM(M$17:M$28)","v":1},0,{"$f":"$J$29+$L$29-$M$29-$N$29","v":0},{"$f":"$I29+$O29","v":58},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":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":"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":"TSU201401 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":"TSU201402 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","TSU201403 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","TSU201404 EGSR.xlsx",0,1,120,0,36,84,0,1,0,0,0,0,84,120]
[null,"MAY","TSU201405 EGSR.xlsx",84,1,89,0,96,77,0,1,3,0,0,3,80,89]
[null,"JUNE","TSU201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TSU201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TSU201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TSU201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TSU201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TSU201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TSU201412 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":"APPLE CIDER","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":"TSU"}]
[]
[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":"TSU201401 EGSR.xlsx"},30,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},168,0,79,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":119},0,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},3,3,0,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":0},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":119},{"$f":"IFERROR($F17-$N17,\"\")","v":168}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"TSU201402 EGSR.xlsx"},119,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},24,0,121,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":22},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":22},{"$f":"IFERROR($F18-$N18,\"\")","v":24}]
[null,"MARCH","TSU201403 EGSR.xlsx",22,1,216,0,145,93,0,1,0,0,0,0,93,216]
[null,"APRIL","TSU201404 EGSR.xlsx",93,1,120,0,146,67,0,1,3,0,0,3,70,120]
[null,"MAY","TSU201405 EGSR.xlsx",67,1,120,0,118,69,3,1,3,6,0,0,69,120]
[null,"JUNE","TSU201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","TSU201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","TSU201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","TSU201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","TSU201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","TSU201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","TSU201412 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":30},null,{"$f":"SUM(F$17:F$28)","v":648},{"$f":"SUM(G$17:G$28)","v":0},609,{"$f":"$D$29+$F$29+$G$29-$H$29","v":69},{"$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":9},{"$f":"SUM(M$17:M$28)","v":9},0,{"$f":"$J$29+$L$29-$M$29-$N$29","v":0},{"$f":"$I29+$O29","v":69},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"]