{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Summary","GUINNESS","HEINEKEN","TIGER","HOEGAARDEN","PAULANAR","APPLE CIDER","STRONGBOW","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":"KDA"}]
[]
[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\\KDA\\"}]
[]
[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":0},{"$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":0},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":12},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$M$17:$M$28\"),$C$14,1),\"\"),\"\")","v":11},{"$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":36}]
[null,"HEINEKEN",{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$Q$17:$Q$28\"),$C$14,1),\"\"),\"\")","v":1272},{"$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":850},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":32},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$M$17:$M$28\"),$C$14,1),\"\"),\"\")","v":27},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$N$17:$N$28\"),$C$14,1),\"\"),\"\")","v":17},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$P$17:$P$28\"),$C$14,1),\"\"),\"\")","v":500}]
[null,"TIGER",6882,0,6072,281,312,72,1105]
[null,"CIGARETTES",151,0,171,0,0,0,86]
[null,"HOEGAARDEN","","","","","","",""]
[null,"PAULANAR",0,0,23,0,0,0,20]
[null,"STRONGBOW",14,0,26,2,0,0,10]
[null,"APPLE CIDER","","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,"TOTAL",{"$f":"SUM(C$21:C$35)","v":8319},{"$f":"SUM(D$21:D$35)","v":0},7142,327,350,89,1757]
[]
[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":"KDA"}]
[]
[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":"KDA201301 EGSR.xlsx"},157,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},192,0,210,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":139},2,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},4,2,0,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":4},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":143},{"$f":"IFERROR($F17-$N17,\"\")","v":192}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"KDA201302 EGSR.xlsx"},139,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},194,0,228,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":105},4,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},7,4,2,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":5},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":110},{"$f":"IFERROR($F18-$N18,\"\")","v":192}]
[null,"MARCH","KDA201303 EGSR.xlsx",105,1,146,0,178,73,5,1,0,3,2,0,73,144]
[null,"APRIL","KDA201304 EGSR.xlsx",73,1,264,0,226,111,0,1,28,17,0,11,122,264]
[null,"MAY","KDA201305 EGSR.xlsx",111,1,192,0,189,114,11,1,12,16,0,7,121,192]
[null,"JUNE","KDA201306 EGSR.xlsx",114,1,246,0,317,43,7,1,17,12,6,6,49,240]
[null,"JULY","KDA201307 EGSR.xlsx",43,1,264,0,268,39,6,1,27,30,0,3,42,264]
[null,"AUGUST","KDA201308 EGSR.xlsx",39,1,216,0,219,36,3,1,10,4,0,9,45,216]
[null,"SEPTEMBER","KDA201309 EGSR.xlsx",36,1,245,0,237,44,9,1,32,19,5,17,61,240]
[null,"OCTOBER","KDA201310 EGSR.xlsx",44,1,288,0,270,62,17,1,12,22,0,7,69,288]
[null,"NOVEMBER","KDA201311 EGSR.xlsx",62,1,219,0,254,27,7,1,16,12,3,8,35,216]
[null,"DECEMBER","KDA201312 EGSR.xlsx",27,1,0,0,0,27,8,1,12,11,0,9,36,0]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":157},null,{"$f":"SUM(F$17:F$28)","v":2466},{"$f":"SUM(G$17:G$28)","v":0},2596,{"$f":"$D$29+$F$29+$G$29-$H$29","v":27},{"$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":177},{"$f":"SUM(M$17:M$28)","v":152},18,{"$f":"$J$29+$L$29-$M$29-$N$29","v":9},{"$f":"$I29+$O29","v":36},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":"KDA"}]
[]
[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":"KDA201301 EGSR.xlsx"},368,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},917,0,908,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":377},82,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},74,83,29,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":44},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":421},{"$f":"IFERROR($F17-$N17,\"\")","v":888}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"KDA201302 EGSR.xlsx"},377,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},1374,0,1462,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":289},44,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},90,75,6,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":53},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":342},{"$f":"IFERROR($F18-$N18,\"\")","v":1368}]
[null,"MARCH","KDA201303 EGSR.xlsx",289,1,1332,0,1400,221,53,1,59,55,12,45,266,1320]
[null,"APRIL","KDA201304 EGSR.xlsx",221,1,1325,0,1274,272,45,1,59,40,5,59,331,1320]
[null,"MAY","KDA201305 EGSR.xlsx",272,1,1646,0,1627,291,59,1,156,102,14,99,390,1632]
[null,"JUNE","KDA201306 EGSR.xlsx",291,1,1453,0,1642,102,99,1,167,193,13,60,162,1440]
[null,"JULY","KDA201307 EGSR.xlsx",102,1,1569,0,1429,242,60,1,58,68,9,41,283,1560]
[null,"AUGUST","KDA201308 EGSR.xlsx",242,1,1127,0,1108,261,41,1,46,35,23,29,290,1104]
[null,"SEPTEMBER","KDA201309 EGSR.xlsx",261,1,1011,0,1015,257,29,1,47,35,3,38,295,1008]
[null,"OCTOBER","KDA201310 EGSR.xlsx",257,1,729,0,729,257,38,1,24,26,9,27,284,720]
[null,"NOVEMBER","KDA201311 EGSR.xlsx",257,1,878,0,1108,27,27,1,59,26,14,46,73,864]
[null,"DECEMBER","KDA201312 EGSR.xlsx",27,1,1289,0,850,466,46,1,32,27,17,34,500,1272]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":368},null,{"$f":"SUM(F$17:F$28)","v":14650},{"$f":"SUM(G$17:G$28)","v":0},14552,{"$f":"$D$29+$F$29+$G$29-$H$29","v":466},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":82},null,{"$f":"SUM(L$17:L$28)","v":871},{"$f":"SUM(M$17:M$28)","v":765},154,{"$f":"$J$29+$L$29-$M$29-$N$29","v":34},{"$f":"$I29+$O29","v":500},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":"KDA"}]
[]
[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":"KDA201301 EGSR.xlsx"},317,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},5456,0,4744,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":1029},183,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},172,144,32,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":179},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":1208},{"$f":"IFERROR($F17-$N17,\"\")","v":5424}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"KDA201302 EGSR.xlsx"},1029,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},5519,0,5381,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":1167},179,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},213,150,47,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":195},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":1362},{"$f":"IFERROR($F18-$N18,\"\")","v":5472}]
[null,"MARCH","KDA201303 EGSR.xlsx",1167,1,4979,0,5842,304,195,1,242,219,59,159,463,4920]
[null,"APRIL","KDA201304 EGSR.xlsx",304,1,5329,0,5446,187,159,1,248,200,49,158,345,5280]
[null,"MAY","KDA201305 EGSR.xlsx",187,1,5919,0,5226,880,158,1,270,221,39,168,1048,5880]
[null,"JUNE","KDA201306 EGSR.xlsx",880,1,5615,0,6468,27,168,1,303,208,47,216,243,5568]
[null,"JULY","KDA201307 EGSR.xlsx",27,1,6377,0,5409,995,216,1,274,208,41,241,1236,6336]
[null,"AUGUST","KDA201308 EGSR.xlsx",995,1,6382,0,6868,509,241,1,318,236,94,229,738,6288]
[null,"SEPTEMBER","KDA201309 EGSR.xlsx",509,1,6151,0,6150,510,229,1,395,283,55,286,796,6096]
[null,"OCTOBER","KDA201310 EGSR.xlsx",510,1,6444,0,7160,-206,286,1,537,357,36,430,224,6408]
[null,"NOVEMBER","KDA201311 EGSR.xlsx",-206,1,5751,0,5560,-15,430,1,352,402,39,341,326,5712]
[null,"DECEMBER","KDA201312 EGSR.xlsx",-15,1,6954,0,6072,867,341,1,281,312,72,238,1105,6882]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":317},null,{"$f":"SUM(F$17:F$28)","v":70876},{"$f":"SUM(G$17:G$28)","v":0},70326,{"$f":"$D$29+$F$29+$G$29-$H$29","v":867},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":183},null,{"$f":"SUM(L$17:L$28)","v":3605},{"$f":"SUM(M$17:M$28)","v":2940},610,{"$f":"$J$29+$L$29-$M$29-$N$29","v":238},{"$f":"$I29+$O29","v":1105},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":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":"KDA"}]
[]
[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":"KDA201301 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":"KDA201302 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","KDA201303 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","KDA201304 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"MAY","KDA201305 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"JUNE","KDA201306 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"JULY","KDA201307 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"AUGUST","KDA201308 EGSR.xlsx",0,1,72,0,38,34,0,1,0,0,0,0,34,72]
[null,"SEPTEMBER","KDA201309 EGSR.xlsx",34,1,72,0,72,34,0,1,0,0,0,0,34,72]
[null,"OCTOBER","KDA201310 EGSR.xlsx",34,1,72,0,86,20,0,1,3,0,0,3,23,72]
[null,"NOVEMBER","KDA201311 EGSR.xlsx",20,1,96,0,67,49,3,1,0,0,0,3,52,96]
[null,"DECEMBER","KDA201312 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[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":"KDA"}]
[]
[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":"KDA201301 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":"KDA201302 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","KDA201303 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","KDA201304 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"MAY","KDA201305 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"JUNE","KDA201306 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"JULY","KDA201307 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"AUGUST","KDA201308 EGSR.xlsx",0,1,48,0,0,48,0,1,0,0,0,0,48,48]
[null,"SEPTEMBER","KDA201309 EGSR.xlsx",48,1,0,0,15,33,0,1,0,0,0,0,33,0]
[null,"OCTOBER","KDA201310 EGSR.xlsx",33,1,24,0,22,35,0,1,0,0,0,0,35,24]
[null,"NOVEMBER","KDA201311 EGSR.xlsx",35,1,24,0,16,43,0,1,0,0,0,0,43,24]
[null,"DECEMBER","KDA201312 EGSR.xlsx",43,1,0,0,23,20,0,1,0,0,0,0,20,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":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":"KDA"}]
[]
[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":"KDA201301 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":"KDA201302 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","KDA201303 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","KDA201304 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"MAY","KDA201305 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"JUNE","KDA201306 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"JULY","KDA201307 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"AUGUST","KDA201308 EGSR.xlsx",0,1,72,0,50,22,0,1,0,0,0,0,22,72]
[null,"SEPTEMBER","KDA201309 EGSR.xlsx",22,1,120,0,128,14,0,1,0,0,0,0,14,120]
[null,"OCTOBER","KDA201310 EGSR.xlsx",14,1,168,0,146,36,0,1,0,0,0,0,36,168]
[null,"NOVEMBER","KDA201311 EGSR.xlsx",36,1,96,0,109,23,0,1,0,0,0,0,23,96]
[null,"DECEMBER","KDA201312 EGSR.xlsx",23,1,144,0,154,13,0,1,0,0,0,0,13,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":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":"KDA"}]
[]
[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":"KDA201301 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":"KDA201302 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","KDA201303 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","KDA201304 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"MAY","KDA201305 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"JUNE","KDA201306 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"JULY","KDA201307 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"AUGUST","KDA201308 EGSR.xlsx",0,1,72,0,6,66,0,1,0,0,0,0,66,72]
[null,"SEPTEMBER","KDA201309 EGSR.xlsx",66,1,0,0,40,26,0,1,0,0,0,0,26,0]
[null,"OCTOBER","KDA201310 EGSR.xlsx",26,1,24,0,25,25,0,1,0,0,0,0,25,24]
[null,"NOVEMBER","KDA201311 EGSR.xlsx",25,1,0,0,5,20,0,1,0,0,0,0,20,0]
[null,"DECEMBER","KDA201312 EGSR.xlsx",20,1,14,0,26,8,0,1,2,0,0,2,10,14]
[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":"KDA"}]
[]
[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":"KDA201301 EGSR.xlsx"},141,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},155,40,216,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":120},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":120},{"$f":"IFERROR($F17-$N17,\"\")","v":155}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"KDA201302 EGSR.xlsx"},120,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},160,20,183,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":117},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":117},{"$f":"IFERROR($F18-$N18,\"\")","v":160}]
[null,"MARCH","KDA201303 EGSR.xlsx",117,1,187,0,214,90,0,1,0,0,0,0,90,187]
[null,"APRIL","KDA201304 EGSR.xlsx",90,1,130,60,201,79,0,1,0,0,0,0,79,130]
[null,"MAY","KDA201305 EGSR.xlsx",79,1,172,0,183,68,0,1,0,0,0,0,68,172]
[null,"JUNE","KDA201306 EGSR.xlsx",68,1,229,0,212,85,0,1,0,0,0,0,85,229]
[null,"JULY","KDA201307 EGSR.xlsx",85,1,136,0,192,29,0,1,0,0,0,0,29,136]
[null,"AUGUST","KDA201308 EGSR.xlsx",29,1,170,0,180,19,0,1,0,0,0,0,19,170]
[null,"SEPTEMBER","KDA201309 EGSR.xlsx",19,1,190,0,197,12,0,1,0,0,0,0,12,190]
[null,"OCTOBER","KDA201310 EGSR.xlsx",12,1,210,0,178,44,0,1,0,0,0,0,44,210]
[null,"NOVEMBER","KDA201311 EGSR.xlsx",44,1,168,100,206,106,0,1,0,0,0,0,106,168]
[null,"DECEMBER","KDA201312 EGSR.xlsx",106,1,151,0,171,86,0,1,0,0,0,0,86,151]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":141},null,{"$f":"SUM(F$17:F$28)","v":2058},{"$f":"SUM(G$17:G$28)","v":220},2333,{"$f":"$D$29+$F$29+$G$29-$H$29","v":86},{"$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":86},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"]