{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Summary","GUINNESS","HEINEKEN","TIGER","HOEGAARDEN","PAULANAR","STRONGBOW","CIGARETTES","APPLE CIDER"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":16,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":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":"SBA"}]
[]
[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\\SBA\\"}]
[]
[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":168},{"$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":180},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":17},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$M$17:$M$28\"),$C$14,1),\"\"),\"\")","v":15},{"$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":55}]
[null,"HEINEKEN",{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$Q$17:$Q$28\"),$C$14,1),\"\"),\"\")","v":504},{"$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":526},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":15},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$M$17:$M$28\"),$C$14,1),\"\"),\"\")","v":9},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$N$17:$N$28\"),$C$14,1),\"\"),\"\")","v":6},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$P$17:$P$28\"),$C$14,1),\"\"),\"\")","v":270}]
[null,"TIGER",4368,0,3985,149,111,13,740]
[null,"CIGARETTES",85,40,147,0,0,0,109]
[null,"HOEGAARDEN","","","","","","",""]
[null,"PAULANAR",24,0,34,0,0,0,3]
[null,"STRONGBOW",24,0,17,0,0,0,8]
[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":5173},{"$f":"SUM(D$21:D$35)","v":40},4889,181,135,19,1185]
[]
[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":"SBA"}]
[]
[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":"SBA201301 EGSR.xlsx"},94,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},72,0,120,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":46},2,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},0,2,0,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":0},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":46},{"$f":"IFERROR($F17-$N17,\"\")","v":72}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"SBA201302 EGSR.xlsx"},46,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},72,0,43,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":75},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":75},{"$f":"IFERROR($F18-$N18,\"\")","v":72}]
[null,"MARCH","SBA201303 EGSR.xlsx",75,1,144,0,142,77,0,1,3,2,0,1,78,144]
[null,"APRIL","SBA201304 EGSR.xlsx",77,1,168,0,160,85,1,1,3,0,0,4,89,168]
[null,"MAY","SBA201305 EGSR.xlsx",85,1,147,0,167,65,4,1,0,1,3,0,65,144]
[null,"JUNE","SBA201306 EGSR.xlsx",65,1,168,0,176,57,0,1,2,0,0,2,59,168]
[null,"JULY","SBA201307 EGSR.xlsx",57,1,192,0,160,89,2,1,5,4,0,3,92,192]
[null,"AUGUST","SBA201308 EGSR.xlsx",89,1,96,0,148,37,3,1,6,9,0,0,37,96]
[null,"SEPTEMBER","SBA201309 EGSR.xlsx",37,1,0,0,155,-118,0,1,36,27,0,9,-109,0]
[null,"OCTOBER","SBA201310 EGSR.xlsx",74,1,144,0,192,26,9,1,20,22,0,7,33,144]
[null,"NOVEMBER","SBA201311 EGSR.xlsx",26,1,0,0,0,26,7,1,8,8,0,7,33,0]
[null,"DECEMBER","SBA201312 EGSR.xlsx",58,1,168,0,180,46,7,1,17,15,0,9,55,168]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":94},null,{"$f":"SUM(F$17:F$28)","v":1371},{"$f":"SUM(G$17:G$28)","v":0},1643,{"$f":"$D$29+$F$29+$G$29-$H$29","v":-178},{"$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":100},{"$f":"SUM(M$17:M$28)","v":90},3,{"$f":"$J$29+$L$29-$M$29-$N$29","v":9},{"$f":"$I29+$O29","v":-169},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":"SBA"}]
[]
[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":"SBA201301 EGSR.xlsx"},161,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},659,0,745,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":75},30,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},43,31,11,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":31},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":106},{"$f":"IFERROR($F17-$N17,\"\")","v":648}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"SBA201302 EGSR.xlsx"},75,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},697,0,655,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":117},31,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},26,34,1,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":22},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":139},{"$f":"IFERROR($F18-$N18,\"\")","v":696}]
[null,"MARCH","SBA201303 EGSR.xlsx",117,1,1038,0,915,240,22,1,90,58,6,48,288,1032]
[null,"APRIL","SBA201304 EGSR.xlsx",240,1,982,0,1072,150,48,1,141,84,22,83,233,960]
[null,"MAY","SBA201305 EGSR.xlsx",150,1,976,0,916,210,83,1,66,88,16,45,255,960]
[null,"JUNE","SBA201306 EGSR.xlsx",210,1,883,0,1011,82,45,1,48,35,19,39,121,864]
[null,"JULY","SBA201307 EGSR.xlsx",82,1,1067,0,966,183,39,1,53,42,11,39,222,1056]
[null,"AUGUST","SBA201308 EGSR.xlsx",183,1,793,0,826,150,39,1,37,32,1,43,193,792]
[null,"SEPTEMBER","SBA201309 EGSR.xlsx",150,1,774,0,694,230,43,1,28,41,6,24,254,768]
[null,"OCTOBER","SBA201310 EGSR.xlsx",230,1,463,0,503,190,24,1,18,13,7,22,212,456]
[null,"NOVEMBER","SBA201311 EGSR.xlsx",190,1,1012,0,937,265,22,1,27,24,4,21,286,1008]
[null,"DECEMBER","SBA201312 EGSR.xlsx",265,1,510,0,526,249,21,1,15,9,6,21,270,504]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":161},null,{"$f":"SUM(F$17:F$28)","v":9854},{"$f":"SUM(G$17:G$28)","v":0},9766,{"$f":"$D$29+$F$29+$G$29-$H$29","v":249},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":30},null,{"$f":"SUM(L$17:L$28)","v":592},{"$f":"SUM(M$17:M$28)","v":491},110,{"$f":"$J$29+$L$29-$M$29-$N$29","v":21},{"$f":"$I29+$O29","v":270},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":"SBA"}]
[]
[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":"SBA201301 EGSR.xlsx"},277,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},3523,0,3322,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":478},140,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},102,133,19,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":90},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":568},{"$f":"IFERROR($F17-$N17,\"\")","v":3504}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"SBA201302 EGSR.xlsx"},478,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},2807,0,2987,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":298},90,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},94,78,23,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":83},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":381},{"$f":"IFERROR($F18-$N18,\"\")","v":2784}]
[null,"MARCH","SBA201303 EGSR.xlsx",298,1,3275,0,3242,331,83,1,110,95,35,63,394,3240]
[null,"APRIL","SBA201304 EGSR.xlsx",331,1,3586,0,3226,691,63,1,125,69,10,109,800,3576]
[null,"MAY","SBA201305 EGSR.xlsx",691,1,2870,0,2999,562,109,1,141,103,38,109,671,2832]
[null,"JUNE","SBA201306 EGSR.xlsx",562,1,2522,0,3037,47,109,1,107,105,26,85,132,2496]
[null,"JULY","SBA201307 EGSR.xlsx",47,1,3486,0,3294,239,85,1,149,146,6,82,321,3480]
[null,"AUGUST","SBA201308 EGSR.xlsx",239,1,4115,0,4078,276,82,1,92,106,11,57,333,4104]
[null,"SEPTEMBER","SBA201309 EGSR.xlsx",276,1,3314,0,3382,208,57,1,110,69,26,72,280,3288]
[null,"OCTOBER","SBA201310 EGSR.xlsx",208,1,3801,0,3688,321,72,1,218,108,9,173,494,3792]
[null,"NOVEMBER","SBA201311 EGSR.xlsx",321,1,2920,0,3013,228,173,1,115,181,16,91,319,2904]
[null,"DECEMBER","SBA201312 EGSR.xlsx",228,1,4381,0,3985,624,91,1,149,111,13,116,740,4368]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":277},null,{"$f":"SUM(F$17:F$28)","v":40600},{"$f":"SUM(G$17:G$28)","v":0},40253,{"$f":"$D$29+$F$29+$G$29-$H$29","v":624},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":140},null,{"$f":"SUM(L$17:L$28)","v":1512},{"$f":"SUM(M$17:M$28)","v":1304},232,{"$f":"$J$29+$L$29-$M$29-$N$29","v":116},{"$f":"$I29+$O29","v":740},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":"SBA"}]
[]
[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":"SBA201301 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":"SBA201302 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","SBA201303 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","SBA201304 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"MAY","SBA201305 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"JUNE","SBA201306 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"JULY","SBA201307 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"AUGUST","SBA201308 EGSR.xlsx",0,1,72,0,25,47,0,1,0,0,0,0,47,72]
[null,"SEPTEMBER","SBA201309 EGSR.xlsx",47,1,72,0,83,36,0,1,0,0,0,0,36,72]
[null,"OCTOBER","SBA201310 EGSR.xlsx",36,1,96,0,80,52,0,1,0,0,0,0,52,96]
[null,"NOVEMBER","SBA201311 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"DECEMBER","SBA201312 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":"SBA"}]
[]
[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":"SBA201301 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":"SBA201302 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","SBA201303 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","SBA201304 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"MAY","SBA201305 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"JUNE","SBA201306 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"JULY","SBA201307 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"AUGUST","SBA201308 EGSR.xlsx",0,1,48,0,5,43,0,1,0,0,0,0,43,48]
[null,"SEPTEMBER","SBA201309 EGSR.xlsx",43,1,0,0,16,27,0,1,0,0,0,0,27,0]
[null,"OCTOBER","SBA201310 EGSR.xlsx",27,1,0,0,7,20,0,1,0,0,0,0,20,0]
[null,"NOVEMBER","SBA201311 EGSR.xlsx",20,1,24,0,31,13,0,1,0,0,0,0,13,24]
[null,"DECEMBER","SBA201312 EGSR.xlsx",13,1,24,0,34,3,0,1,0,0,0,0,3,24]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":0},null,{"$f":"SUM(F$17:F$28)","v":{"$error":"#REF!"}},{"$f":"SUM(G$17:G$28)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$D$29+$F$29+$G$29-$H$29","v":{"$error":"#REF!"}},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":0},null,{"$f":"SUM(L$17:L$28)","v":{"$error":"#REF!"}},{"$f":"SUM(M$17:M$28)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$J$29+$L$29-$M$29-$N$29","v":{"$error":"#REF!"}},{"$f":"$I29+$O29","v":{"$error":"#REF!"}},null,{"$f":"SUM(R$17:R$28)","v":0},{"$f":"SUM(S$17:S$28)","v":0}]
[null,"* STOCK PURCHASED INCLUDES STOCK FORFEITED FROM CUSTODY"]
[null,"Copyright © 2012 by Oracle Symphony Sdn Bhd"]

{"sheet":"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":"SBA"}]
[]
[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":"SBA201301 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":"SBA201302 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","SBA201303 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","SBA201304 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"MAY","SBA201305 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"JUNE","SBA201306 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"JULY","SBA201307 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"AUGUST","SBA201308 EGSR.xlsx",0,1,72,0,9,63,0,1,0,0,0,0,63,72]
[null,"SEPTEMBER","SBA201309 EGSR.xlsx",63,1,0,0,19,44,0,1,0,0,0,0,44,0]
[null,"OCTOBER","SBA201310 EGSR.xlsx",44,1,0,0,7,37,0,1,0,0,0,0,37,0]
[null,"NOVEMBER","SBA201311 EGSR.xlsx",37,1,0,0,36,1,0,1,0,0,0,0,1,0]
[null,"DECEMBER","SBA201312 EGSR.xlsx",1,1,24,0,17,8,0,1,0,0,0,0,8,24]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":0},null,{"$f":"SUM(F$17:F$28)","v":{"$error":"#REF!"}},{"$f":"SUM(G$17:G$28)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$D$29+$F$29+$G$29-$H$29","v":{"$error":"#REF!"}},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":0},null,{"$f":"SUM(L$17:L$28)","v":{"$error":"#REF!"}},{"$f":"SUM(M$17:M$28)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"$J$29+$L$29-$M$29-$N$29","v":{"$error":"#REF!"}},{"$f":"$I29+$O29","v":{"$error":"#REF!"}},null,{"$f":"SUM(R$17:R$28)","v":0},{"$f":"SUM(S$17:S$28)","v":0}]
[null,"* STOCK PURCHASED INCLUDES STOCK FORFEITED FROM CUSTODY"]
[null,"Copyright © 2012 by Oracle Symphony Sdn Bhd"]

{"sheet":"CIGARETTES","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":"SBA"}]
[]
[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":"SBA201301 EGSR.xlsx"},102,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},121,0,147,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":76},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":76},{"$f":"IFERROR($F17-$N17,\"\")","v":121}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"SBA201302 EGSR.xlsx"},76,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},191,0,138,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":129},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":129},{"$f":"IFERROR($F18-$N18,\"\")","v":191}]
[null,"MARCH","SBA201303 EGSR.xlsx",129,1,195,0,163,161,0,1,0,0,0,0,161,195]
[null,"APRIL","SBA201304 EGSR.xlsx",161,1,113,0,168,106,0,1,0,0,0,0,106,113]
[null,"MAY","SBA201305 EGSR.xlsx",106,1,171,0,177,100,0,1,0,0,0,0,100,171]
[null,"JUNE","SBA201306 EGSR.xlsx",100,1,163,0,168,95,0,1,0,0,0,0,95,163]
[null,"JULY","SBA201307 EGSR.xlsx",95,1,142,0,164,73,0,1,0,0,0,0,73,142]
[null,"AUGUST","SBA201308 EGSR.xlsx",73,1,207,0,155,125,0,1,0,0,0,0,125,207]
[null,"SEPTEMBER","SBA201309 EGSR.xlsx",125,1,135,0,160,100,0,1,0,0,0,0,100,135]
[null,"OCTOBER","SBA201310 EGSR.xlsx",100,1,115,0,138,77,0,1,0,0,0,0,77,115]
[null,"NOVEMBER","SBA201311 EGSR.xlsx",77,1,100,100,146,131,0,1,0,0,0,0,131,100]
[null,"DECEMBER","SBA201312 EGSR.xlsx",131,1,85,40,147,109,0,1,0,0,0,0,109,85]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":102},null,{"$f":"SUM(F$17:F$28)","v":1738},{"$f":"SUM(G$17:G$28)","v":140},1871,{"$f":"$D$29+$F$29+$G$29-$H$29","v":109},{"$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":109},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":"SBA"}]
[]
[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":"SBA201301 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":"SBA201302 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","SBA201303 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"APRIL","SBA201304 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"MAY","SBA201305 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"JUNE","SBA201306 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"JULY","SBA201307 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"AUGUST","SBA201308 EGSR.xlsx",0,1,72,0,51,21,0,1,0,0,0,0,21,72]
[null,"SEPTEMBER","SBA201309 EGSR.xlsx",21,1,96,0,97,20,0,1,0,0,0,0,20,96]
[null,"OCTOBER","SBA201310 EGSR.xlsx",20,1,120,0,89,51,0,1,0,0,0,0,51,120]
[null,"NOVEMBER","SBA201311 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"DECEMBER","SBA201312 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"]