{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Summary","GUINNESS","HEINEKEN","TIGER","PAULANAR","HOEGAARDEN","STRONGBOW","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":"STP"}]
[]
[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\\STP\\"}]
[]
[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":72},{"$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":94},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":25},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$M$17:$M$28\"),$C$14,1),\"\"),\"\")","v":27},{"$f":"IFERROR(IF($B21<>\"\",INDEX(INDIRECT($B21&\"!$N$17:$N$28\"),$C$14,1),\"\"),\"\")","v":3},{"$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":768},{"$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":826},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$L$17:$L$28\"),$C$14,1),\"\"),\"\")","v":79},{"$f":"IFERROR(IF($B22<>\"\",INDEX(INDIRECT($B22&\"!$M$17:$M$28\"),$C$14,1),\"\"),\"\")","v":59},{"$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":79}]
[null,"TIGER",3480,0,3403,213,144,52,502]
[null,"CIGARETTES",120,0,113,0,0,0,93]
[null,"PAULANAR",48,0,25,0,0,0,37]
[null,"APPLE CIDER","","","","","","",""]
[null,"HOEGAARDEN",24,0,48,1,0,0,26]
[null,"STRONGBOW",48,0,18,0,0,0,61]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,null,"","","","","","",""]
[null,"TOTAL",{"$f":"SUM(C$21:C$35)","v":4560},{"$f":"SUM(D$21:D$35)","v":0},4527,318,230,57,860]
[]
[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":"STP"}]
[]
[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":"STP201401 EGSR.xlsx"},146,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},0,0,0,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":146},1,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},1,1,0,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":1},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":147},{"$f":"IFERROR($F17-$N17,\"\")","v":0}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"STP201402 EGSR.xlsx"},307,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},49,0,90,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":266},1,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},0,0,1,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":0},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":266},{"$f":"IFERROR($F18-$N18,\"\")","v":48}]
[null,"MARCH","STP201403 EGSR.xlsx",266,1,0,0,0,266,0,1,9,2,0,7,273,0]
[null,"APRIL","STP201404 EGSR.xlsx",79,1,75,0,94,60,7,1,25,27,3,2,62,72]
[null,"MAY","STP201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","STP201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","STP201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","STP201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","STP201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","STP201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","STP201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","STP201412 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":146},null,{"$f":"SUM(F$17:F$28)","v":124},{"$f":"SUM(G$17:G$28)","v":0},184,{"$f":"$D$29+$F$29+$G$29-$H$29","v":86},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":1},null,{"$f":"SUM(L$17:L$28)","v":35},{"$f":"SUM(M$17:M$28)","v":30},4,{"$f":"$J$29+$L$29-$M$29-$N$29","v":2},{"$f":"$I29+$O29","v":88},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":"STP"}]
[]
[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":"STP201401 EGSR.xlsx"},432,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},120,0,340,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":212},2,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},18,12,0,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":8},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":220},{"$f":"IFERROR($F17-$N17,\"\")","v":120}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"STP201402 EGSR.xlsx"},212,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},624,0,636,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":200},8,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},29,26,0,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":11},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":211},{"$f":"IFERROR($F18-$N18,\"\")","v":624}]
[null,"MARCH","STP201403 EGSR.xlsx",200,1,438,0,545,93,11,1,47,28,6,24,117,432]
[null,"APRIL","STP201404 EGSR.xlsx",93,1,770,0,826,37,24,1,79,59,2,42,79,768]
[null,"MAY","STP201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","STP201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","STP201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","STP201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","STP201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","STP201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","STP201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","STP201412 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":432},null,{"$f":"SUM(F$17:F$28)","v":1952},{"$f":"SUM(G$17:G$28)","v":0},2347,{"$f":"$D$29+$F$29+$G$29-$H$29","v":37},{"$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":173},{"$f":"SUM(M$17:M$28)","v":125},8,{"$f":"$J$29+$L$29-$M$29-$N$29","v":42},{"$f":"$I29+$O29","v":79},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":"STP"}]
[]
[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":"STP201401 EGSR.xlsx"},451,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},4152,0,4099,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":504},27,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},185,75,0,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":137},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":641},{"$f":"IFERROR($F17-$N17,\"\")","v":4152}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"STP201402 EGSR.xlsx"},504,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},3765,0,3567,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":702},137,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},130,86,45,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":136},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":838},{"$f":"IFERROR($F18-$N18,\"\")","v":3720}]
[null,"MARCH","STP201403 EGSR.xlsx",702,1,2785,0,3294,193,136,1,185,121,25,175,368,2760]
[null,"APRIL","STP201404 EGSR.xlsx",193,1,3532,0,3403,322,163,1,213,144,52,180,502,3480]
[null,"MAY","STP201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","STP201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","STP201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","STP201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","STP201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","STP201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","STP201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","STP201412 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":451},null,{"$f":"SUM(F$17:F$28)","v":14234},{"$f":"SUM(G$17:G$28)","v":0},14363,{"$f":"$D$29+$F$29+$G$29-$H$29","v":322},{"$f":"IFERROR(INDEX($J$17:$J$28,MATCH(1,$K$17:$K$28,0),1),0)","v":27},null,{"$f":"SUM(L$17:L$28)","v":713},{"$f":"SUM(M$17:M$28)","v":426},122,{"$f":"$J$29+$L$29-$M$29-$N$29","v":192},{"$f":"$I29+$O29","v":514},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":"STP"}]
[]
[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":"STP201401 EGSR.xlsx"},43,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},0,0,7,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":36},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":36},{"$f":"IFERROR($F17-$N17,\"\")","v":0}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"STP201402 EGSR.xlsx"},36,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},0,0,16,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":20},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":20},{"$f":"IFERROR($F18-$N18,\"\")","v":0}]
[null,"MARCH","STP201403 EGSR.xlsx",20,1,24,0,30,14,0,1,0,0,0,0,14,24]
[null,"APRIL","STP201404 EGSR.xlsx",14,1,48,0,25,37,0,1,0,0,0,0,37,48]
[null,"MAY","STP201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","STP201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","STP201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","STP201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","STP201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","STP201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","STP201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","STP201412 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":43},null,{"$f":"SUM(F$17:F$28)","v":72},{"$f":"SUM(G$17:G$28)","v":0},78,{"$f":"$D$29+$F$29+$G$29-$H$29","v":37},{"$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":37},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":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":"STP"}]
[]
[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":"STP201401 EGSR.xlsx"},55,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},24,0,75,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":4},0,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},1,0,0,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":1},{"$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":"STP201402 EGSR.xlsx"},4,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},96,0,59,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":41},1,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},0,0,0,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":1},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":42},{"$f":"IFERROR($F18-$N18,\"\")","v":96}]
[null,"MARCH","STP201403 EGSR.xlsx",41,1,49,0,41,49,1,1,0,0,1,0,49,48]
[null,"APRIL","STP201404 EGSR.xlsx",49,1,24,0,48,25,0,1,1,0,0,1,26,24]
[null,"MAY","STP201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","STP201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","STP201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","STP201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","STP201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","STP201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","STP201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","STP201412 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":55},null,{"$f":"SUM(F$17:F$28)","v":193},{"$f":"SUM(G$17:G$28)","v":0},223,{"$f":"$D$29+$F$29+$G$29-$H$29","v":25},{"$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":2},{"$f":"SUM(M$17:M$28)","v":0},1,{"$f":"$J$29+$L$29-$M$29-$N$29","v":1},{"$f":"$I29+$O29","v":26},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":"STP"}]
[]
[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":"STP201401 EGSR.xlsx"},0,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},48,0,13,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":35},0,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},2,0,0,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":2},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":37},{"$f":"IFERROR($F17-$N17,\"\")","v":48}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"STP201402 EGSR.xlsx"},35,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},0,0,13,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":22},2,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},0,2,0,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":0},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":22},{"$f":"IFERROR($F18-$N18,\"\")","v":0}]
[null,"MARCH","STP201403 EGSR.xlsx",22,1,24,0,15,31,0,1,0,0,0,0,31,24]
[null,"APRIL","STP201404 EGSR.xlsx",31,1,48,0,18,61,0,1,0,0,0,0,61,48]
[null,"MAY","STP201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","STP201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","STP201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","STP201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","STP201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","STP201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","STP201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","STP201412 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"TOTAL",null,{"$f":"IFERROR(INDEX($D$17:$D$28,MATCH(1,$E$17:$E$28,0),1),0)","v":0},null,{"$f":"SUM(F$17:F$28)","v":120},{"$f":"SUM(G$17:G$28)","v":0},59,{"$f":"$D$29+$F$29+$G$29-$H$29","v":61},{"$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":2},{"$f":"SUM(M$17:M$28)","v":2},0,{"$f":"$J$29+$L$29-$M$29-$N$29","v":0},{"$f":"$I29+$O29","v":61},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":"STP"}]
[]
[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":"STP201401 EGSR.xlsx"},33,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},72,0,49,{"$f":"IFERROR(IF($D17<>\"\",$D17+$F17+$G17-$H17,\"\"),\"\")","v":56},0,{"$f":"IFERROR(IF($J17<>\"\",1,\"\"),\"\")","v":1},1,1,0,{"$f":"IFERROR(IF($J17<>\"\",$J17+$L17-$M17-$N17,\"\"),\"\")","v":0},{"$f":"IFERROR(IF($D17<>\"\",$I17+$O17,\"\"),\"\")","v":56},{"$f":"IFERROR($F17-$N17,\"\")","v":72}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"STP201402 EGSR.xlsx"},56,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},72,0,80,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":48},0,{"$f":"IFERROR(IF($J18<>\"\",1,\"\"),\"\")","v":1},10,7,0,{"$f":"IFERROR(IF($J18<>\"\",$J18+$L18-$M18-$N18,\"\"),\"\")","v":3},{"$f":"IFERROR(IF($D18<>\"\",$I18+$O18,\"\"),\"\")","v":51},{"$f":"IFERROR($F18-$N18,\"\")","v":72}]
[null,"MARCH","STP201403 EGSR.xlsx",48,1,48,0,70,26,3,1,2,2,0,3,29,48]
[null,"APRIL","STP201404 EGSR.xlsx",26,1,96,0,90,32,3,1,0,3,0,0,32,96]
[null,"MAY","STP201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","STP201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","STP201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","STP201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","STP201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","STP201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","STP201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","STP201412 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":33},null,{"$f":"SUM(F$17:F$28)","v":288},{"$f":"SUM(G$17:G$28)","v":0},289,{"$f":"$D$29+$F$29+$G$29-$H$29","v":32},{"$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":13},{"$f":"SUM(M$17:M$28)","v":13},0,{"$f":"$J$29+$L$29-$M$29-$N$29","v":0},{"$f":"$I29+$O29","v":32},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":"STP"}]
[]
[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":"STP201401 EGSR.xlsx"},49,{"$f":"IFERROR(IF($D17<>\"\",1,\"\"),\"\")","v":1},140,0,118,{"$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":140}]
[null,"FEBRUARY",{"$f":"$D$6&$D$8&TEXT(ROW($B18)-ROW($B$16),\"00\")&\" EGSR.xlsx\"","v":"STP201402 EGSR.xlsx"},71,{"$f":"IFERROR(IF($D18<>\"\",1,\"\"),\"\")","v":1},90,0,99,{"$f":"IFERROR(IF($D18<>\"\",$D18+$F18+$G18-$H18,\"\"),\"\")","v":62},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":62},{"$f":"IFERROR($F18-$N18,\"\")","v":90}]
[null,"MARCH","STP201403 EGSR.xlsx",62,1,140,0,116,86,0,1,0,0,0,0,86,140]
[null,"APRIL","STP201404 EGSR.xlsx",86,1,120,0,113,93,0,1,0,0,0,0,93,120]
[null,"MAY","STP201405 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JUNE","STP201406 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"JULY","STP201407 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"AUGUST","STP201408 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"SEPTEMBER","STP201409 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"OCTOBER","STP201410 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"NOVEMBER","STP201411 EGSR.xlsx",null,"",null,null,null,"",null,"",null,null,null,"","",0]
[null,"DECEMBER","STP201412 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":490},{"$f":"SUM(G$17:G$28)","v":0},446,{"$f":"$D$29+$F$29+$G$29-$H$29","v":93},{"$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":93},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"]