{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["data","calculations","selected data","images","dashboard"],"not_rendered":{"charts":5,"images":10,"macros":1,"external_links":0,"defined_names":19,"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":"data","index":0,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[0,7,0,8],[0,9,0,10],[0,11,0,12],[2,7,2,8],[2,9,2,10],[2,11,2,12],[1,7,1,8],[1,9,1,10],[1,11,1,12]]}
[]
[null,"KPI","Base","Corresp:","Current","Proportionate","Proportionate","Variance",null,"Variance",null,"Variance",null,"Target"]
[null,null," ","Month","Month","Target","Target","with Base",null,"with Corresp. Month",null,"with Target",null,"December"]
[null,null,"31.12.2014","31.08.2014","31.08.2015","31.08.2015","30.09.2015","Amount ","%","Amount","%","Amount","%",2015,"Short Name"]
[null,"Absolute Deposit",6266.4949999999999,0,8359.8739999999998,6389.1091277222222,6526.8667209444438,2093.3789999999999,0.33405899150960783,8359.8739999999998,0,1970.7648722777776,0.30845691204845233,6966.2267019999999,"Abs. Deposit"]
[null,"CASA Deposit",5407.5510000000004,3934.1880000000001,4160.8440000000001,5387.4560903888887,5507.3750539444436,-1246.7070000000003,-0.23054928192078081,226.65599999999995,5.7611888399842597E-2,-1226.6120903888886,-0.22767927381851696,5893.2191459999995,"CASA Deposit"]
[null,"Average Deposit",5433.8267692307691,5482.2396666666664,5791.8329211455548,5862.5331629228385,5930.5292193333335,358.00615191478573,6.5884719391867227E-2,309.59325447888841,5.6472039404130717E-2,-70.700241777283736,-1.2059674514836392E-2,6206.569702702991,"Average Deposit"]
[null,"Weekly Deposit  10-09-2015",6266.4949999999999,4908.91,8776.6949999999997,6389.1091277222222,6526.8667209444438,2510.1999999999998,0.40057480297997522,3867.7849999999999,0.78791116561517727,2387.5858722777775,0.37369621093464944,6966.2267019999999,"Week. Dep. 10-09"]
[null,"No of Current A/Cs Opened during Month",2280,20,41,190,190,-2239,-0.98201754385964912,21,1.05,-149,-0.78421052631578947,2280,"A/Cs Opened during Month"]
[null,"No of Current A/cs Opened Progressive",157,340,263,2280,2280,106,0.67515923566878977,-77,-0.22647058823529412,-2017,-0.88464912280701757,2280,"A/cs Opened Progressive"]
[null,"Number of Depositors Accounts (CASA)",0,0,0,0,0,0,0,0,0,0,0,0,"Dep.Accounts (CASA)"]
[null,"Profit/Loss",-26.512000000000036,-13.201999999999984,32.36953931,25.347089431938741,28.869012333795538,58.881539310000036,-2.2209391713186464,45.571539309999984,-3.4518663316164249,7.0224498780612592,0.27705152881232126,39.416257913547,"Profit/Loss"]
[null,"Advances",1220.9970000000003,1135.671,1224.3410000000001,1281.4566666666667,1280.0202499999996,3.3439999999998236,2.738745467842937E-3,88.670000000000073,7.8077189608610306E-2,-57.115666666666584,-4.4570891979700121E-2,1311.6860000000001,"Advances"]
[null,"Performing Adances",0,0,0,0,0,0,0,0,0,0,0,0,"Performing Adances"]
[null,"Classified Advances",361.96300000000002,365.63200000000001,352.93899999999996,280.12166666666661,260.89774999999997,-9.0240000000000578,-2.4930724963601412E-2,-12.69300000000004,-3.4715232802380647E-2,72.817333333333352,0.25994895075354174,239.20099999999999,"Classified Advances"]
[null,"Non Fund Base Advances",4252.1737499999999,389.19399999999996,337.64073760999997,4677.3911249999992,4730.5432968750001,-3914.5330123899998,-0.92059573350924329,-51.553262389999986,-0.13246160626833917,-4339.7503873899996,-0.92781430319022129,4889.9998125000002,"Non Fund Base Adv."]
[null,"Non Fund Base Income",103.71600000000001,68.13300000000001,75.643999999999991,88.603333333333339,99.678750000000008,-28.072000000000017,-0.27066219291141208,7.5109999999999815,0.11024026536333319,-12.959333333333348,-0.14626236785673993,132.90499999999997,"Non Fund Base Income"]
[null,"Home Remittance",25.082000000000001,6.8319999999999999,33.171999999999997,18.393466666666669,20.69265,8.0899999999999963,0.32254206203652008,26.339999999999996,3.8553864168618261,14.778533333333328,0.80346644823161817,27.590200000000003,"Home Remittance"]
[null,"Cost of Fund",0.46765950483202856,0.45019240133302296,0.30679659430275508,0.37312554501983897,0.37277152167500527,-0.16086291052927348,-0.34397442769189812,-0.14339580703026789,-0.31852116252000667,-6.632895071708389E-2,-0.1777657724119564,0.36997216594049387,"Cost of Fund"]
[null,"Intermediation Cost",0.36029260368930105,0.3032710583161099,0.26046597949500777,0.29487225093083114,0.29182775642501518,-9.9826624194293279E-2,-0.27707097834397659,-4.2805078821102127E-2,-0.14114462177424433,-3.4406271435823366E-2,-0.11668195744839389,0.28158883475773244,"Intermediation Cost"]
[null,"Imports",1473.2370000000001,1473.2370000000001,0,1080.3738000000001,1215.4205250000002,-1473.2370000000001,-1,-1473.2370000000001,-1,-1080.3738000000001,-1,1620.5607000000002,"Imports"]
[null,"Exports",78.792000000000002,76.043999999999997,2.2519999999999998,63.0336,70.912800000000004,-76.540000000000006,-0.97141841811351415,-73.792000000000002,-0.97038556625111783,-60.781599999999997,-0.96427302264189252,94.550399999999996,"Exports"]
[null,"NBP Adv: Sal: O/S",128.208,116.77300000000001,137.208,143.01933333333332,146.40150000000003,9,7.0198427555222764E-2,20.434999999999988,0.17499764500355378,-5.811333333333323,-4.0633201105677953E-2,156.54799999999997,"NBP Adv: Sal: O/S"]
[null,"Overdue Adv: Sal: over 90 Days",12.245999999999999,11.138000000000002,12.362,10.612666666666668,10.4085,0.11600000000000144,9.4724808100605466E-3,1.2239999999999984,0.10989405638355165,1.7493333333333325,0.16483447452729433,9.7959999999999994,"Adv: Sal: over 90 Days"]
[null,"Agr: Finance O/S",5.0599999999999996,5.1379999999999999,4.75,11.629333333333335,12.450500000000002,-0.30999999999999961,-6.1264822134387283E-2,-0.3879999999999999,-7.5515764889061879E-2,-6.8793333333333351,-0.59155010318734247,14.914000000000001,"Agr: Finance O/S"]
[null,"NBP Karobar O/S",0,0,0,0,0,0,0,0,0,0,0,0,"NBP Karobar O/S"]
[null,"Recovery of Stuck-up",0,0,0,0,0,0,0,0,0,0,0,0,"Recovery of Stuck-up"]
[null,"Recovery in Charge Off A/Cs",0,0,0,0,0,0,0,0,0,0,0,0,"Recovery in Charge Off A/Cs"]
[null,"Write Off",0,0,0,0,0,0,0,0,0,0,0,0,"Write Off"]
[null,"Income",560.92399999999998,409.78899999999999,345.67500000000001,415.29262304999429,469.80591138754562,-215.24899999999997,-0.38374004321441046,-64.113999999999976,-0.15645612742167306,-69.617623049994279,-0.16763510639487925,636.32481825229695,"Income"]
[null,"Expenditure Excluding Administrative Exp.",346.73,271.05599999999998,177.08499999999998,222.14426695138889,252.16047405374999,-169.64500000000004,-0.48927119084013504,-93.971000000000004,-0.34668481789740868,-45.059266951388906,-0.20283785654143882,345.20666033874994,"Exp.Excl. Admin. Exp."]
[null,"Personal Expenses",158.91,107.09499999999998,95.575999999999993,115.26666666666668,129.67500000000004,-63.334000000000003,-0.39855263985903971,-11.518999999999991,-0.10755870955693536,-19.690666666666687,-0.17082706766917308,172.9,"Personal Expenses"]
[null,"Other Expenses",81.796000000000006,44.839999999999996,40.643000000000001,52.534600000000005,59.101424999999999,-41.153000000000006,-0.50311751185877063,-4.1969999999999956,-9.359946476360384E-2,-11.891600000000004,-0.2263574863042643,78.801899999999989,"Other Expenses"]

{"sheet":"calculations","index":1,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[null,"KPI","KPI selection","Button Selection"]
["Base Month (31/12/2014)","Absolute Deposit",2,"Base Month (31/12/2014)"]
["Corresp. Month (31/08/2014)","CASA Deposit",{"$f":"INDEX($B$3:$B$31,C3)","v":"CASA Deposit"},{"$f":"MATCH(clicked_button,A3:A5)","v":1}]
["Target (31/08/2015)","Average Deposit"]
[null,"Weekly Deposit  10-09-2015"]
[null,"No of Current A/Cs Opened during Month"]
[null,"No of Current A/cs Opened Progressive"]
[null,"Number of Depositors Accounts (CASA)"]
[null,"Profit/Loss"]
[null,"Advances"]
[null,"Performing Adances"]
[null,"Classified Advances"]
[null,"Non Fund Base Advances"]
[null,"Non Fund Base Income"]
[null,"Home Remittance"]
[null,"Cost of Fund"]
[null,"Intermediation Cost"]
[null,"Imports"]
[null,"Exports"]
[null,"NBP Adv: Sal: O/S"]
[null,"Overdue Adv: Sal: over 90 Days"]
[null,"Agr: Finance O/S"]
[null,"NBP Karobar O/S"]
[null,"Recovery of Stuck-up"]
[null,"Recovery in Charge Off A/Cs"]
[null,"Write Off"]
[null,"Income"]
[null,"Expenditure Excluding Administrative Exp."]
[null,"Personal Expenses"]
[null,"Other Expenses"]

{"sheet":"selected data","index":2,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":true,"merged":[[16,2,16,6]]}
[]
[]
[null,null,null,null,"Base/Corresp/Target Data",null,null,null,null,null,null,null,"short name"]
[null,null,"KPI Selected","Current Month",{"$f":"INDEX(selecteddata,1,0,calculations!$D$4)","v":"Base"},"Current Month","Base Month","Corresponding Month","target 31/08/2015","vs target 31/08/2015","var %",{"$f":"\"Variance \"&INDEX(selectvar,1,1,calculations!$D$4)","v":"Variance with Base"},{"$f":"INDEX(data!$O$5:$O$33,calculations!$C$3)","v":"CASA Deposit"}]
[null,null,{"$f":"calculations!C4","v":"CASA Deposit"},{"$f":"INDEX(data!$E$5:$E$33,calculations!$C$3)","v":4160.8440000000001},{"$f":"INDEX(selecteddata,calculations!$C$3+3,0,calculations!$D$4)","v":5407.5510000000004},{"$f":"INDEX(data!$E$5:$E$33,calculations!$C$3)","v":4160.8440000000001},{"$f":"INDEX(data!$C$5:$C$33,calculations!$C$3)","v":5407.5510000000004},{"$f":"INDEX(data!$D$5:$D$33,calculations!$C$3)","v":3934.1880000000001},{"$f":"INDEX(data!$F$5:$F$33,calculations!$C$3)","v":5387.4560903888887},{"$f":"IFERROR(D5/I5,\"\")","v":0.77232072618148306},{"$f":"INDEX(selectvar,calculations!$C$3+2,2,calculations!$D$4)","v":-0.23054928192078081},{"$f":"INDEX(selectvar,calculations!$C$3+2,1,calculations!$D$4)","v":-1246.7070000000003},"(vs 31/08/2015)"]
[null,null,null,{"$f":"\"Current: \"","v":"Current: "},null,{"$f":"I5","v":5387.4560903888887},{"$f":"I5","v":5387.4560903888887},{"$f":"I5","v":5387.4560903888887},{"$f":"I5","v":5387.4560903888887},{"$f":"IFERROR(IF(1-J5<0,0,1-J5),\"\")","v":0.22767927381851694}]
[null,null,null,{"$f":"D5","v":4160.8440000000001},null,null,null,null,null,{"$f":"J5","v":0.77232072618148306}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Diagram"]
[null,null,0,0.09,{"$f":"IF(K5<C18,1,#N/A)","v":1},{"$f":"IF(AND(K5<C19,K5>=C18),2,#N/A)","v":{"$error":"#N/A"}},{"$f":"IF(K5>=C20,3,#N/A)","v":{"$error":"#N/A"}}]
[null,null,0.2]
[null,null,0.2]

{"sheet":"images","index":3,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Base Month"]
[null,"Corresp. Month"]
[null,"Target Month"]
[]
[null,null,null,null,null,null,null,"Current Month","Base Month","Corresp. Month","Target Month"]
[null,null,null,null,null,null,null,"2015-08-31"," 31/12/2014","2014-08-31","2015-08-31"]

{"sheet":"dashboard","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}