{"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":"2014"}]
[]
[null,"MONTH"]
[]
[null,"FILE PATH",{"$f":"MID(CELL(\"FILENAME\",$A$1),1,FIND(\"[\",CELL(\"FILENAME\",$A$1))-1)","v":"D:\\Purchasing\\Beer & EGSR\\EGSR Reports\\YR2014\\KDA\\"}]
[]
[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":192},{"$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":186},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":7},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$M$17:$M$28\"),$C$14,1),\"\"),\"\")","v":12},{"$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":62}]
[null,"HEINEKEN",{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$Q$17:$Q$28\"),$C$14,1),\"\"),\"\")","v":1032},{"$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":941},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":90},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$M$17:$M$28\"),$C$14,1),\"\"),\"\")","v":93},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$N$17:$N$28\"),$C$14,1),\"\"),\"\")","v":2},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$P$17:$P$28\"),$C$14,1),\"\"),\"\")","v":479}]
[null,"TIGER",6360,0,5750,352,215,69,1281]
[null,"CIGARETTES",264,0,172,0,0,0,186]
[null,"HOEGAARDEN",144,0,94,0,0,0,58]
[null,"PAULANAR",48,0,40,0,0,0,29]
[null,"STRONGBOW",48,0,27,0,0,0,34]
[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":8088},{"$f":"SUM(D$21:D$35)","v":0},7210,449,320,71,2129]
[]
[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":"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":"KDA201401 EGSR.xlsx"},109,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},0,0,0,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":109},9,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},45,16,4,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":34},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":143},{"$f":"IFERROR($F17-$N17,\"\")","v":-4}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"KDA201402 EGSR.xlsx"},66,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},169,0,183,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":52},34,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},10,37,1,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":6},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":58},{"$f":"IFERROR($F18-$N18,\"\")","v":168}]
[null,"MARCH","KDA201403 EGSR.xlsx",52,1,266,0,263,55,6,1,6,4,2,6,61,264]
[null,"APRIL","KDA201404 EGSR.xlsx",55,1,192,0,186,61,6,1,7,12,0,1,62,192]
[null,"MAY","KDA201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","KDA201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","KDA201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","KDA201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","KDA201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","KDA201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","KDA201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","KDA201412 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":109},null,{"$f":"SUM(F$17:F$28)","v":627},{"$f":"SUM(G$17:G$28)","v":0},632,{"$f":"$D$29+$F$29+$G$29-$H$29","v":104},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":9},null,{"$f":"SUM(L$17:L$28)","v":68},{"$f":"SUM(M$17:M$28)","v":69},7,{"$f":"$J$29+$L$29-$M$29-$N$29","v":1},{"$f":"$I29+$O29","v":105},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":"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":"KDA201401 EGSR.xlsx"},466,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},1138,0,1140,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":464},34,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},92,45,10,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":71},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":535},{"$f":"IFERROR($F17-$N17,\"\")","v":1128}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"KDA201402 EGSR.xlsx"},464,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},567,0,730,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":301},71,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},20,56,15,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":20},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":321},{"$f":"IFERROR($F18-$N18,\"\")","v":552}]
[null,"MARCH","KDA201403 EGSR.xlsx",301,1,1250,0,1194,357,20,1,92,76,2,34,391,1248]
[null,"APRIL","KDA201404 EGSR.xlsx",357,1,1034,0,941,450,34,1,90,93,2,29,479,1032]
[null,"MAY","KDA201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","KDA201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","KDA201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","KDA201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","KDA201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","KDA201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","KDA201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","KDA201412 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":466},null,{"$f":"SUM(F$17:F$28)","v":3989},{"$f":"SUM(G$17:G$28)","v":0},4005,{"$f":"$D$29+$F$29+$G$29-$H$29","v":450},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":34},null,{"$f":"SUM(L$17:L$28)","v":294},{"$f":"SUM(M$17:M$28)","v":270},29,{"$f":"$J$29+$L$29-$M$29-$N$29","v":29},{"$f":"$I29+$O29","v":479},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":"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":"KDA201401 EGSR.xlsx"},873,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},8369,0,7172,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":2070},238,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},301,235,65,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":239},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":2309},{"$f":"IFERROR($F17-$N17,\"\")","v":8304}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"KDA201402 EGSR.xlsx"},2070,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},3877,0,5198,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":749},239,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},337,278,37,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":261},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":1010},{"$f":"IFERROR($F18-$N18,\"\")","v":3840}]
[null,"MARCH","KDA201403 EGSR.xlsx",749,1,5447,0,5880,316,261,1,234,230,47,218,534,5400]
[null,"APRIL","KDA201404 EGSR.xlsx",316,1,6429,0,5750,995,218,1,352,215,69,286,1281,6360]
[null,"MAY","KDA201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","KDA201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","KDA201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","KDA201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","KDA201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","KDA201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","KDA201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","KDA201412 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":873},null,{"$f":"SUM(F$17:F$28)","v":24122},{"$f":"SUM(G$17:G$28)","v":0},24000,{"$f":"$D$29+$F$29+$G$29-$H$29","v":995},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":238},null,{"$f":"SUM(L$17:L$28)","v":1224},{"$f":"SUM(M$17:M$28)","v":958},218,{"$f":"$J$29+$L$29-$M$29-$N$29","v":286},{"$f":"$I29+$O29","v":1281},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":"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":"KDA201401 EGSR.xlsx"},62,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},48,0,103,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":7},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":7},{"$f":"IFERROR($F17-$N17,\"\")","v":48}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"KDA201402 EGSR.xlsx"},7,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},96,0,63,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":40},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":40},{"$f":"IFERROR($F18-$N18,\"\")","v":96}]
[null,"MARCH","KDA201403 EGSR.xlsx",40,1,48,0,80,8,0,1,0,0,0,0,8,48]
[null,"APRIL","KDA201404 EGSR.xlsx",8,1,144,0,94,58,0,1,0,0,0,0,58,144]
[null,"MAY","KDA201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","KDA201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","KDA201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","KDA201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","KDA201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","KDA201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","KDA201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","KDA201412 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":62},null,{"$f":"SUM(F$17:F$28)","v":336},{"$f":"SUM(G$17:G$28)","v":0},340,{"$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":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":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":"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":"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":"KDA201401 EGSR.xlsx"},20,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},72,0,21,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":71},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":71},{"$f":"IFERROR($F17-$N17,\"\")","v":72}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"KDA201402 EGSR.xlsx"},71,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},0,0,17,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":54},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":54},{"$f":"IFERROR($F18-$N18,\"\")","v":0}]
[null,"MARCH","KDA201403 EGSR.xlsx",54,1,0,0,33,21,0,1,0,0,0,0,21,0]
[null,"APRIL","KDA201404 EGSR.xlsx",21,1,48,0,40,29,0,1,0,0,0,0,29,48]
[null,"MAY","KDA201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","KDA201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","KDA201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","KDA201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","KDA201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","KDA201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","KDA201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","KDA201412 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":20},null,{"$f":"SUM(F$17:F$28)","v":120},{"$f":"SUM(G$17:G$28)","v":0},111,{"$f":"$D$29+$F$29+$G$29-$H$29","v":29},{"$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":29},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":"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":"KDA201401 EGSR.xlsx"},13,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},97,0,54,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":56},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":56},{"$f":"IFERROR($F17-$N17,\"\")","v":97}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"KDA201402 EGSR.xlsx"},56,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},96,0,112,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":40},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":40},{"$f":"IFERROR($F18-$N18,\"\")","v":96}]
[null,"MARCH","KDA201403 EGSR.xlsx",40,1,96,0,111,25,0,1,0,0,0,0,25,96]
[null,"APRIL","KDA201404 EGSR.xlsx",25,1,96,0,78,43,0,1,0,0,0,0,43,96]
[null,"MAY","KDA201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","KDA201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","KDA201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","KDA201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","KDA201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","KDA201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","KDA201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","KDA201412 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":13},null,{"$f":"SUM(F$17:F$28)","v":385},{"$f":"SUM(G$17:G$28)","v":0},355,{"$f":"$D$29+$F$29+$G$29-$H$29","v":43},{"$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":43},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":"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":"KDA201401 EGSR.xlsx"},8,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},24,0,27,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":5},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":5},{"$f":"IFERROR($F17-$N17,\"\")","v":24}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"KDA201402 EGSR.xlsx"},5,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},48,0,9,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":44},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":44},{"$f":"IFERROR($F18-$N18,\"\")","v":48}]
[null,"MARCH","KDA201403 EGSR.xlsx",44,1,0,0,31,13,0,1,0,0,0,0,13,0]
[null,"APRIL","KDA201404 EGSR.xlsx",13,1,48,0,27,34,0,1,0,0,0,0,34,48]
[null,"MAY","KDA201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","KDA201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","KDA201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","KDA201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","KDA201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","KDA201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","KDA201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","KDA201412 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":8},null,{"$f":"SUM(F$17:F$28)","v":120},{"$f":"SUM(G$17:G$28)","v":0},94,{"$f":"$D$29+$F$29+$G$29-$H$29","v":34},{"$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":0},{"$f":"SUM(M$17:M$28)","v":2},0,{"$f":"$J$29+$L$29-$M$29-$N$29","v":0},{"$f":"$I29+$O29","v":34},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":"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":"KDA201401 EGSR.xlsx"},86,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},163,0,194,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":55},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":55},{"$f":"IFERROR($F17-$N17,\"\")","v":163}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"KDA201402 EGSR.xlsx"},55,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},171,0,150,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":76},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":76},{"$f":"IFERROR($F18-$N18,\"\")","v":171}]
[null,"MARCH","KDA201403 EGSR.xlsx",76,1,163,60,205,94,0,1,0,0,0,0,94,163]
[null,"APRIL","KDA201404 EGSR.xlsx",94,1,264,0,172,186,0,1,0,0,0,0,186,264]
[null,"MAY","KDA201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","KDA201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","KDA201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","KDA201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","KDA201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","KDA201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","KDA201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","KDA201412 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":86},null,{"$f":"SUM(F$17:F$28)","v":761},{"$f":"SUM(G$17:G$28)","v":60},721,{"$f":"$D$29+$F$29+$G$29-$H$29","v":186},{"$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":186},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"]