{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Summary","GUINNESS","HEINEKEN","TIGER","PAULANAR","STRONGBOW","HOEGAARDEN","APPLE CIDER","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":"CCS"}]
[]
[null,"YEAR",{"$f":"MID(CELL(\"FILENAME\",$A$1),FIND(\"[\",CELL(\"FILENAME\",$A$1))+4,4)","v":"2014"}]
[]
[null,"MONTH"]
[]
[null,"FILE PATH",{"$f":"MID(CELL(\"FILENAME\",$A$1),1,FIND(\"[\",CELL(\"FILENAME\",$A$1))-1)","v":"Z:\\Purchasing\\Beer & EGSR\\EGSR Reports\\YR2014\\CCS\\"}]
[]
[null,"CELL LINK",5]
[]
[]
[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":214},{"$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":278},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":10},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$M$17:$M$28\"),$C$14,1),\"\"),\"\")","v":10},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$N$17:$N$28\"),$C$14,1),\"\"),\"\")","v":2},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$P$17:$P$28\"),$C$14,1),\"\"),\"\")","v":15}]
[null,"HEINEKEN",{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$Q$17:$Q$28\"),$C$14,1),\"\"),\"\")","v":710},{"$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":751},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":35},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$M$17:$M$28\"),$C$14,1),\"\"),\"\")","v":76},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$N$17:$N$28\"),$C$14,1),\"\"),\"\")","v":10},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$P$17:$P$28\"),$C$14,1),\"\"),\"\")","v":175}]
[null,"TIGER",4793,0,5005,253,274,13,424]
[null,"CIGARETTES",92,0,85,0,0,0,42]
[null,"PAULANAR",0,0,7,0,0,0,21]
[null,"STRONGBOW",0,0,19,0,0,0,14]
[null,"HOEGAARDEN","","","","","","",""]
[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":5809},{"$f":"SUM(D$21:D$35)","v":0},6145,298,360,25,691]
[]
[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":"CCS"}]
[]
[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":"CCS201401 EGSR.xlsx"},67,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},485,0,288,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":264},17,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},27,10,5,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":29},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":293},{"$f":"IFERROR($F17-$N17,\"\")","v":480}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"CCS201402 EGSR.xlsx"},264,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},10,0,170,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":104},29,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},27,19,10,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":27},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":131},{"$f":"IFERROR($F18-$N18,\"\")","v":0}]
[null,"MARCH","CCS201403 EGSR.xlsx",104,1,155,0,201,58,27,1,11,16,11,11,69,144]
[null,"APRIL","CCS201404 EGSR.xlsx",58,1,216,0,205,69,11,1,20,21,0,10,79,216]
[null,"MAY","CCS201405 EGSR.xlsx",69,1,216,0,278,7,10,1,10,10,2,8,15,214]
[null,"JUNE","CCS201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","CCS201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","CCS201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","CCS201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","CCS201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","CCS201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","CCS201412 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":67},null,{"$f":"SUM(F$17:F$28)","v":1082},{"$f":"SUM(G$17:G$28)","v":0},1142,{"$f":"$D$29+$F$29+$G$29-$H$29","v":7},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":17},null,{"$f":"SUM(L$17:L$28)","v":95},{"$f":"SUM(M$17:M$28)","v":76},28,{"$f":"$J$29+$L$29-$M$29-$N$29","v":8},{"$f":"$I29+$O29","v":15},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":"CCS"}]
[]
[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":"CCS201401 EGSR.xlsx"},397,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},854,0,665,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":586},24,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},32,23,14,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":19},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":605},{"$f":"IFERROR($F17-$N17,\"\")","v":840}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"CCS201402 EGSR.xlsx"},586,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},128,0,617,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":97},19,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},53,20,8,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":44},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":141},{"$f":"IFERROR($F18-$N18,\"\")","v":120}]
[null,"MARCH","CCS201403 EGSR.xlsx",97,1,903,0,843,157,44,1,75,75,15,29,186,888]
[null,"APRIL","CCS201404 EGSR.xlsx",157,1,753,0,716,194,29,1,126,83,9,63,257,744]
[null,"MAY","CCS201405 EGSR.xlsx",194,1,720,0,751,163,63,1,35,76,10,12,175,710]
[null,"JUNE","CCS201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","CCS201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","CCS201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","CCS201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","CCS201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","CCS201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","CCS201412 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":397},null,{"$f":"SUM(F$17:F$28)","v":3358},{"$f":"SUM(G$17:G$28)","v":0},3592,{"$f":"$D$29+$F$29+$G$29-$H$29","v":163},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":24},null,{"$f":"SUM(L$17:L$28)","v":321},{"$f":"SUM(M$17:M$28)","v":277},56,{"$f":"$J$29+$L$29-$M$29-$N$29","v":12},{"$f":"$I29+$O29","v":175},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":"CCS"}]
[]
[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":"CCS201401 EGSR.xlsx"},230,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},7913,0,6719,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":1424},199,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},278,204,41,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":232},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":1656},{"$f":"IFERROR($F17-$N17,\"\")","v":7872}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"CCS201402 EGSR.xlsx"},1424,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},5090,0,5922,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":592},232,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},232,200,74,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":190},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":782},{"$f":"IFERROR($F18-$N18,\"\")","v":5016}]
[null,"MARCH","CCS201403 EGSR.xlsx",592,1,4392,0,4808,176,190,1,281,216,72,183,359,4320]
[null,"APRIL","CCS201404 EGSR.xlsx",176,1,4477,0,4202,451,183,1,263,203,37,206,657,4440]
[null,"MAY","CCS201405 EGSR.xlsx",451,1,4806,0,5005,252,206,1,253,274,13,172,424,4793]
[null,"JUNE","CCS201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","CCS201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","CCS201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","CCS201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","CCS201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","CCS201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","CCS201412 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":230},null,{"$f":"SUM(F$17:F$28)","v":26678},{"$f":"SUM(G$17:G$28)","v":0},26656,{"$f":"$D$29+$F$29+$G$29-$H$29","v":252},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":199},null,{"$f":"SUM(L$17:L$28)","v":1307},{"$f":"SUM(M$17:M$28)","v":1097},237,{"$f":"$J$29+$L$29-$M$29-$N$29","v":172},{"$f":"$I29+$O29","v":424},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":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":"CCS"}]
[]
[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":"CCS201401 EGSR.xlsx"},49,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},0,0,1,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":48},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":48},{"$f":"IFERROR($F17-$N17,\"\")","v":0}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"CCS201402 EGSR.xlsx"},48,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},0,0,9,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":39},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":39},{"$f":"IFERROR($F18-$N18,\"\")","v":0}]
[null,"MARCH","CCS201403 EGSR.xlsx",39,1,0,0,6,33,0,1,0,0,0,0,33,0]
[null,"APRIL","CCS201404 EGSR.xlsx",33,1,0,0,5,28,0,1,0,0,0,0,28,0]
[null,"MAY","CCS201405 EGSR.xlsx",28,1,0,0,7,21,0,1,0,0,0,0,21,0]
[null,"JUNE","CCS201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","CCS201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","CCS201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","CCS201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","CCS201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","CCS201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","CCS201412 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":49},null,{"$f":"SUM(F$17:F$28)","v":0},{"$f":"SUM(G$17:G$28)","v":0},28,{"$f":"$D$29+$F$29+$G$29-$H$29","v":21},{"$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":21},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":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":"CCS"}]
[]
[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":"CCS201401 EGSR.xlsx"},48,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},0,0,8,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":40},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":40},{"$f":"IFERROR($F17-$N17,\"\")","v":0}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"CCS201402 EGSR.xlsx"},40,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},0,0,19,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":21},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":21},{"$f":"IFERROR($F18-$N18,\"\")","v":0}]
[null,"MARCH","CCS201403 EGSR.xlsx",21,1,0,0,6,15,0,1,0,0,0,0,15,0]
[null,"APRIL","CCS201404 EGSR.xlsx",15,1,24,0,6,33,0,1,0,0,0,0,33,24]
[null,"MAY","CCS201405 EGSR.xlsx",33,1,0,0,19,14,0,1,0,0,0,0,14,0]
[null,"JUNE","CCS201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","CCS201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","CCS201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","CCS201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","CCS201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","CCS201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","CCS201412 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":48},null,{"$f":"SUM(F$17:F$28)","v":24},{"$f":"SUM(G$17:G$28)","v":0},58,{"$f":"$D$29+$F$29+$G$29-$H$29","v":14},{"$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":14},null,{"$f":"SUM(R$17:R$28)","v":0},{"$f":"SUM(S$17:S$28)","v":0}]
[null,"* STOCK PURCHASED INCLUDES STOCK FORFEITED FROM CUSTODY"]
[null,"Copyright © 2012 by Oracle Symphony Sdn Bhd"]

{"sheet":"HOEGAARDEN","index":6,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,3,5,5],[7,3,7,5],[9,3,9,5]]}
[]
[]
[null,null,null,"ANNUAL STOCK SUMMARY OF ESSENTIAL GOODS BY TYPE"]
[]
[]
[null,"OUTLET",null,{"$f":"Summary!C6","v":"CCS"}]
[]
[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":"CCS201401 EGSR.xlsx"},49,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},0,0,29,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":20},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":20},{"$f":"IFERROR($F17-$N17,\"\")","v":0}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"CCS201402 EGSR.xlsx"},20,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},72,0,48,{"$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":72}]
[null,"MARCH","CCS201403 EGSR.xlsx",44,1,48,0,33,59,0,1,0,0,0,0,59,48]
[null,"APRIL","CCS201404 EGSR.xlsx",59,1,0,0,22,37,0,1,0,0,0,0,37,0]
[null,"MAY","CCS201405 EGSR.xlsx",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"",{"$error":"#REF!"},"",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"","",""]
[null,"JUNE","CCS201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","CCS201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","CCS201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","CCS201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","CCS201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","CCS201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","CCS201412 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":49},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":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":"CCS"}]
[]
[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":"CCS201401 EGSR.xlsx"},54,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},72,0,94,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":32},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":32},{"$f":"IFERROR($F17-$N17,\"\")","v":72}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"CCS201402 EGSR.xlsx"},32,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},72,0,83,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":21},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":21},{"$f":"IFERROR($F18-$N18,\"\")","v":72}]
[null,"MARCH","CCS201403 EGSR.xlsx",21,1,96,0,76,41,0,1,1,0,0,1,42,96]
[null,"APRIL","CCS201404 EGSR.xlsx",42,1,73,0,82,33,1,1,0,0,1,0,33,72]
[null,"MAY","CCS201405 EGSR.xlsx",33,1,72,0,95,10,0,1,0,0,0,0,10,72]
[null,"JUNE","CCS201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","CCS201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","CCS201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","CCS201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","CCS201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","CCS201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","CCS201412 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":54},null,{"$f":"SUM(F$17:F$28)","v":385},{"$f":"SUM(G$17:G$28)","v":0},430,{"$f":"$D$29+$F$29+$G$29-$H$29","v":9},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":0},null,{"$f":"SUM(L$17:L$28)","v":1},{"$f":"SUM(M$17:M$28)","v":0},1,{"$f":"$J$29+$L$29-$M$29-$N$29","v":0},{"$f":"$I29+$O29","v":9},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":"CCS"}]
[]
[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":"CCS201401 EGSR.xlsx"},48,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},160,0,95,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":113},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":113},{"$f":"IFERROR($F17-$N17,\"\")","v":160}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"CCS201402 EGSR.xlsx"},113,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},50,0,110,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":53},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":53},{"$f":"IFERROR($F18-$N18,\"\")","v":50}]
[null,"MARCH","CCS201403 EGSR.xlsx",53,1,70,0,68,55,0,1,0,0,0,0,55,70]
[null,"APRIL","CCS201404 EGSR.xlsx",55,1,70,0,90,35,0,1,0,0,0,0,35,70]
[null,"MAY","CCS201405 EGSR.xlsx",35,1,92,0,85,42,0,1,0,0,0,0,42,92]
[null,"JUNE","CCS201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","CCS201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","CCS201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","CCS201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","CCS201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","CCS201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","CCS201412 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":48},null,{"$f":"SUM(F$17:F$28)","v":442},{"$f":"SUM(G$17:G$28)","v":0},448,{"$f":"$D$29+$F$29+$G$29-$H$29","v":42},{"$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":42},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"]