{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Home","Monthly input sheet","Quarterly input sheet","Annual input sheet","Annual SPM Dashboard"],"not_rendered":{"charts":4,"images":9,"macros":0,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Home","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[{"$nulls":5},"SOCIAL PERFORMANCE MANAGEMENT REPORTING TEMPLATE"]
{"$rows_empty":11}
[null,null,null,"Click the Input Sheet that needs to be filled"]
[]
[]
[]
[]
[null,null,null,"Instructions to be fill the template:"]
[null,null,null,"1. Fill the cells which are in green colour"]
[null,null,null,"2. No need to enter any data in the blue colour cells"]

{"sheet":"Monthly input sheet","index":1,"n_rows":108,"n_cols":30,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"SOCIAL PERFORMANCE MANAGEMENT: MONTHLY REPORT INPUT SHEET"]
[]
[{"$nulls":26},"List 1: Branches","List 2: Areas","List 3: Category of complaints"]
[null,"Indicate the Period","2014-01-01",null,"2014-02-01",null,"2014-03-01",null,"2014-04-01",null,"2014-05-01",null,"2014-06-01",null,"2014-07-01",null,"2014-08-01",null,"2014-09-01",null,"2014-10-01",null,"2014-11-01",null,"2014-12-01",null,"AGOO",null,"Staff attitude & Behaviour","List 4"]
[{"$nulls":26},"ALICIA",null,"Insurance - Life","Staff Attitude & Behavior"]
[{"$nulls":26},"ANGELES",null,"Insurance - Health","Salary & Benefits"]
[null,"OPERATIONS",{"$nulls":24},"APARRI",null,"Insurance - Crop","HR Policies"]
[{"$nulls":26},"ARITAO",null,"Insurance - Others","Operations Policies"]
[null,"% of active borrowers: ",{"$nulls":24},"BAGABAG",null,"Loan application & renewal","Audit Policies"]
[null,"Female",0.73043319398622286,null,0.72294905995259906,null,0.7350292612348025,null,0.74242695823624305,null,0.74242695823624305,null,0.74,null,0.73,null,0.74,null,0.74,null,0.75,null,0.75,null,0.74,null,"BAGGAO",null,"Loan approval or disapproval","Administrative Policies"]
[null,"Male",{"$f":"1-C13","v":0.26956680601377714},null,{"$f":"1-E13","v":0.27705094004740094},null,{"$f":"1-G13","v":0.2649707387651975},null,{"$f":"1-I13","v":0.25757304176375695},null,{"$f":"1-K13","v":0.25757304176375695},null,0.26,null,0.27,null,0.26,null,0.26,null,0.25,null,0.25,null,0.26,null,"BALER",null,"Loan release","Fraud"]
[null," Rural",0.84,null,0.85,null,0.84560000000000002,null,0.84,null,0.84,null,0.83,null,0.84,null,0.85,null,0.85,null,0.85,null,0.85,null,0.85,null,"BAMBANG",null,"Loan utilization check"]
[null,"Urban",{"$f":"1-C15","v":0.16000000000000003},null,{"$f":"1-E15","v":0.15000000000000002},null,{"$f":"1-G15","v":0.15439999999999998},null,{"$f":"1-I15","v":0.16000000000000003},null,{"$f":"1-K15","v":0.16000000000000003},null,0.17,null,0.16,null,0.15,null,0.15,null,0.15,null,0.15,null,0.15,null,"CABAGAN",null,"Collection of dues"]
[{"$nulls":26},"CABANATUAN",null,"Policies on delinquent accounts & corresponding penalties"]
[null,"% of targeted minority borrowers",{"$nulls":24},"CABARROGUIS",null,"Capital Build-Up"]
[null,"Small Farmers",{"$nulls":24},"CABATUAN",null,"Fraud"]
[null,"Farmer",{"$nulls":24},"CABIAO"]
[null,"Fisherfolk",{"$nulls":24},"CALASIAO"]
[null,"Indigenous People",{"$nulls":4},0.01,{"$nulls":19},"CAMILING"]
[null,"Displaced workers",{"$nulls":24},"CAUAYAN"]
[null,"Persons with Disability",{"$nulls":24},"CONCEPCION"]
[null,"Urban Poor",{"$nulls":24},"CUYAPO"]
[{"$nulls":26},"DICADI"]
[null,"% of clients without access to formal financial services before joining ASKI",{"$nulls":24},"ECHAGUE"]
[{"$nulls":26},"GABALDON"]
[null,"% of  poor incoming / new clients (various poverty lines: <1.25$ a day, <2 $ a day, <5 $ a day)",{"$nulls":24},"GAPAN"]
[null,"% of clients living under the 1.25$ a day",8.3699999999999997E-2,null,8.5000000000000006E-2,null,8.14E-2,null,7.4200000000000002E-2,null,7.3099999999999998E-2,null,null,null,8.7900000000000006E-2,null,8.8599999999999998E-2,null,9.2100000000000001E-2,null,7.7200000000000005E-2,null,7.5399999999999995E-2,null,6.5600000000000006E-2,null,"GATTARAN"]
[null,"% of clients living under the 2.5$ a day",0.3301,null,0.32719999999999999,null,0.3196,null,0.30130000000000001,null,0.30149999999999999,null,null,null,0.33639999999999998,null,0.33329999999999999,null,0.34089999999999998,null,0.2984,null,0.2969,null,0.27110000000000001,null,"GUIMBA"]
[null,"% of clients living under the 5$ a day",0.65810000000000002,null,0.65039999999999998,null,0.6492,null,0.61980000000000002,null,0.63049999999999995,null,null,null,0.66239999999999999,null,0.6593,null,0.66520000000000001,null,0.61850000000000005,null,0.62050000000000005,null,0.59030000000000005,null,"ILAGAN"]
[{"$nulls":26},"JONES"]
[{"$nulls":26},"LAGAWE"]
[null,"Average Loan Size per borrower (Exposure to ASKI loans) in Pesos",15903.860351520101,null,15789.206962187533,null,15350.493545219941,null,14602.532827982164,null,14590.779431773366,null,null,null,14675.88,null,14548.29,null,14098.36,{"$nulls":7},"LOURDES"]
[{"$nulls":26},"MADDELA"]
[{"$nulls":26},"MALLIG"]
[null,"Client retention rate (borrowers only): Overall",{"$f":"C41/(C40+C42)","v":0.96548039012243203},null,{"$f":"E41/(E40+E42)","v":0.97173248154991176},null,{"$f":"G41/(G40+G42)","v":0.96902923389206275},null,{"$f":"I41/(I40+I42)","v":0.94916263490882025},null,{"$f":"K41/(K40+K42)","v":0.95874781538190967},null,{"$f":"M41/(M40+M42)","v":0.99548540280239439},null,{"$f":"O41/(O40+O42)","v":0.98604954367666231},null,{"$f":"Q41/(Q40+Q42)","v":0.98295491022705384},null,{"$f":"S41/(S40+S42)","v":0.99040493701919008},null,{"$f":"U41/(U40+U42)","v":0.96944325548862609},null,{"$f":"W41/(W40+W42)","v":0.98360172613409114},null,{"$f":"Y41/(Y40+Y42)","v":0.99690523058137459},null,"MANGALDAN"]
[{"$nulls":26},"MARIA"]
[null,"Number of active borrowers as at beginning of period",94145,null,{"$f":"C41","v":93053},null,{"$f":"E41","v":93091},null,{"$f":"G41","v":92614},null,{"$f":"I41","v":89264},null,{"$f":"K41","v":87224},null,{"$f":"M41","v":89304},null,{"$f":"O41","v":90756},null,{"$f":"Q41","v":91865},null,{"$f":"S41","v":93724},null,{"$f":"U41","v":92862},null,{"$f":"W41","v":93452},null,"MEXICO"]
[null,"Number of active borrowers as at end of period",93053,null,93091,null,92614,null,89264,null,87224,null,89304,null,90756,null,91865,null,93724,null,92862,null,93452,null,94705,null,"MUÑOZ"]
[null,"Number of new borrowers during the period",2235,null,2746,null,2483,null,1431,null,1713,null,2485,null,2736,null,2702,null,2767,null,2065,null,2148,null,1547,null,"PALAYAN"]
[{"$nulls":26},"PANIQUI"]
[{"$nulls":26},"PLARIDEL"]
[null,"AKP retention rate",{"$f":"C47/(C46+C48)","v":{"$error":"#DIV/0!"}},null,{"$f":"E47/(E46+E48)","v":{"$error":"#DIV/0!"}},null,{"$f":"G47/(G46+G48)","v":{"$error":"#DIV/0!"}},null,{"$f":"I47/(I46+I48)","v":{"$error":"#DIV/0!"}},null,{"$f":"K47/(K46+K48)","v":{"$error":"#DIV/0!"}},null,{"$f":"M47/(M46+M48)","v":{"$error":"#DIV/0!"}},null,{"$f":"O47/(O46+O48)","v":0.95350449225519207},null,{"$f":"Q47/(Q46+Q48)","v":0.96925722885090826},null,{"$f":"S47/(S46+S48)","v":0.98486104795784635},null,{"$f":"U47/(U46+U48)","v":0},null,{"$f":"W47/(W46+W48)","v":{"$error":"#DIV/0!"}},null,{"$f":"Y47/(Y46+Y48)","v":{"$error":"#DIV/0!"}},null,"QUEZON"]
[null,"Number of active borrowers as at beginning of period - AKP",null,null,{"$f":"C47","v":0},null,{"$f":"E47","v":0},null,{"$f":"G47","v":0},null,{"$f":"I47","v":0},null,{"$f":"K47","v":0},null,{"$f":"M47","v":36214},null,{"$f":"O47","v":35765},null,{"$f":"Q47","v":36068},null,{"$f":"S47","v":36821},null,{"$f":"U47","v":0},null,{"$f":"W47","v":0},null,"RIZAL"]
[null,"Number of active borrowers as at end of period - AKP",{"$nulls":10},36214,null,35765,null,36068,null,36821,{"$nulls":7},"ROSALES"]
[null,"Number of new borrowers during the period - AKP",{"$nulls":12},1295,null,1447,null,1319,{"$nulls":7},"ROXAS"]
[{"$nulls":26},"SAN FERNANDO"]
[null,"AMP retention rate",{"$f":"C52/(C51+C53)","v":{"$error":"#DIV/0!"}},null,{"$f":"E52/(E51+E53)","v":{"$error":"#DIV/0!"}},null,{"$f":"G52/(G51+G53)","v":{"$error":"#DIV/0!"}},null,{"$f":"I52/(I51+I53)","v":{"$error":"#DIV/0!"}},null,{"$f":"K52/(K51+K53)","v":{"$error":"#DIV/0!"}},null,{"$f":"M52/(M51+M53)","v":{"$error":"#DIV/0!"}},null,{"$f":"O52/(O51+O53)","v":1.0355782892867291},null,{"$f":"Q52/(Q51+Q53)","v":1.0029500136574707},null,{"$f":"S52/(S51+S53)","v":0.98614205749687522},null,{"$f":"U52/(U51+U53)","v":0},null,{"$f":"W52/(W51+W53)","v":{"$error":"#DIV/0!"}},null,{"$f":"Y52/(Y51+Y53)","v":{"$error":"#DIV/0!"}},null,"SAN JOSE"]
[null,"Number of active borrowers as at beginning of period - AMP",null,null,{"$f":"C52","v":0},null,{"$f":"E52","v":0},null,{"$f":"G52","v":0},null,{"$f":"I52","v":0},null,{"$f":"K52","v":0},null,{"$f":"M52","v":17330},null,{"$f":"O52","v":18221},null,{"$f":"Q52","v":18359},null,{"$f":"S52","v":18146},null,{"$f":"U52","v":0},null,{"$f":"W52","v":0},null,"SAN MATEO"]
[null,"Number of active borrowers as at end of period - AMP",{"$nulls":10},17330,null,18221,null,18359,null,18146,{"$nulls":7},"SAN MIGUEL"]
[null,"Number of new borrowers during the period - AMP",{"$nulls":12},265,null,84,null,42,{"$nulls":7},"SAN RAFAEL"]
[{"$nulls":26},"SANTIAGO"]
[null,"ILP retention rate",{"$f":"C57/(C56+C58)","v":{"$error":"#DIV/0!"}},null,{"$f":"E57/(E56+E58)","v":{"$error":"#DIV/0!"}},null,{"$f":"G57/(G56+G58)","v":{"$error":"#DIV/0!"}},null,{"$f":"I57/(I56+I58)","v":{"$error":"#DIV/0!"}},null,{"$f":"K57/(K56+K58)","v":{"$error":"#DIV/0!"}},null,{"$f":"M57/(M56+M58)","v":{"$error":"#DIV/0!"}},null,{"$f":"O57/(O56+O58)","v":0.99319414003922024},null,{"$f":"Q57/(Q56+Q58)","v":0.98381658799730276},null,{"$f":"S57/(S56+S58)","v":0.99771965492609482},null,{"$f":"U57/(U56+U58)","v":0},null,{"$f":"W57/(W56+W58)","v":{"$error":"#DIV/0!"}},null,{"$f":"Y57/(Y56+Y58)","v":{"$error":"#DIV/0!"}},null,"SOLANO"]
[null,"Number of active borrowers as at beginning of period - ILP",null,null,{"$f":"C57","v":0},null,{"$f":"E57","v":0},null,{"$f":"G57","v":0},null,{"$f":"I57","v":0},null,{"$f":"K57","v":0},null,{"$f":"M57","v":33539},null,{"$f":"O57","v":34440},null,{"$f":"Q57","v":35016},null,{"$f":"S57","v":36315},null,{"$f":"U57","v":0},null,{"$f":"W57","v":0},null,"STA. IGNACIA"]
[null,"Number of active borrowers as at end of period - ILP",{"$nulls":10},33539,null,34440,null,35016,null,36315,{"$nulls":7},"STA. MARIA"]
[null,"Number of new borrowers during the period - ILP",{"$nulls":12},1137,null,1152,null,1382,{"$nulls":7},"STA. ROSA"]
[{"$nulls":26},"TALAVERA"]
[{"$nulls":26},"TARLAC"]
[null,"PEOPLE / EMPLOYEES",{"$nulls":24},"TAYUG"]
[{"$nulls":26},"TUGUEGARAO NORTH"]
[null,"% of staff complaints resolved",{"$f":"C66/C65","v":1},null,{"$f":"E66/E65","v":{"$error":"#DIV/0!"}},null,{"$f":"G66/G65","v":0.5},null,{"$f":"I66/I65","v":1},null,{"$f":"K66/K65","v":1},null,{"$f":"M66/M65","v":0.2},null,{"$f":"O66/O65","v":0.8},null,{"$f":"Q66/Q65","v":1},null,{"$f":"S66/S65","v":0.8571428571428571},null,{"$f":"U66/U65","v":1},null,{"$f":"W66/W65","v":1},null,{"$f":"Y66/Y65","v":0.75},null,"TUGUEGARAO SOUTH"]
[{"$nulls":26},"TUMAUINI"]
[null,"No. of staff complaints received",4,null,0,null,2,null,2,null,2,null,5,null,5,null,2,null,7,null,9,null,6,null,8,null,"URDANETA"]
[null,"No. of staff complaints resolved",4,null,0,null,1,null,2,null,2,null,1,null,4,null,2,null,6,null,9,null,6,null,6,null,"ZARAGOZA"]
[]
[null,"Staff retention rate",{"$f":"(C71-C72)/C70","v":0.97417355371900827},null,{"$f":"(E71-E72)/E70","v":0.97074190177638453},null,{"$f":"(G71-G72)/G70","v":0.96736842105263154},null,{"$f":"(I71-I72)/I70","v":0.97568710359408028},null,{"$f":"(K71-K72)/K70","v":0.97872340425531912},null,{"$f":"(M71-M72)/M70","v":0.97857142857142854},null,{"$f":"(O71-O72)/O70","v":0.97715988083416083},null,{"$f":"(Q71-Q72)/Q70","v":0.98050682261208577},null,{"$f":"(S71-S72)/S70","v":0.96899224806201545},null,{"$f":"(U71-U72)/U70","v":0.9783889980353635},null,{"$f":"(W71-W72)/W70","v":0.97751710654936463},null,{"$f":"(Y71-Y72)/Y70","v":0.988360814742968}]
[]
[null,"Number of employees as at beginning of period",968,null,{"$f":"C71","v":957},null,{"$f":"E71","v":950},null,{"$f":"G71","v":946},null,{"$f":"I71","v":940},null,{"$f":"K71","v":980},null,{"$f":"M71","v":1007},null,{"$f":"O71","v":1026},null,{"$f":"Q71","v":1032},null,{"$f":"S71","v":1018},null,{"$f":"U71","v":1023},null,{"$f":"W71","v":1031}]
[null,"Number of employees as at end of period",957,null,950,null,946,null,940,null,980,null,1007,null,1026,null,1032,null,1018,null,1023,null,1031,null,1020]
[null,"Number of new employees during the period",14,null,21,null,27,null,17,null,60,null,48,null,42,null,26,null,18,null,27,null,31,null,1]
[]
[null,"PROCESS"]
[]
[null,"% of clients complaints resolved (Komento Mo – text)",{"$f":"C79/C78","v":0.72727272727272729},null,{"$f":"E79/E78","v":1},null,{"$f":"G79/G78","v":1},null,{"$f":"I79/I78","v":0.83333333333333337},null,{"$f":"K79/K78","v":0.88235294117647056},null,{"$f":"M79/M78","v":0.9375},null,{"$f":"O79/O78","v":0.82352941176470584},null,{"$f":"Q79/Q78","v":1},null,{"$f":"S79/S78","v":0.92},null,{"$f":"U79/U78","v":0.89655172413793105},null,{"$f":"W79/W78","v":0.9642857142857143},null,{"$f":"Y79/Y78","v":0.72}]
[]
[null,"No. of client complaints received",22,null,6,null,5,null,6,null,17,null,16,null,17,null,16,null,25,null,29,null,28,null,25]
[null,"No. of client complaints resolved",16,null,6,null,5,null,5,null,15,null,15,null,14,null,16,null,23,null,26,null,27,null,18]
[]
[null,"Top 3 sub-categories of complaints received","Sub-category 1",null,"Sub-category 1",null,"Sub-category 1",null,"Sub-category 1",null,"Sub-category 1",null,"Sub-category 1",null,"Sub-category 1",null,"Sub-category 1",null,"Sub-category 1",null,"Sub-category 1",null,"Sub-category 1",null,"Sub-category 1"]
[null,null,"Staff attitude & Behaviour",null,"Staff attitude & Behaviour",null,"Staff attitude & Behaviour",null,"Staff attitude & Behaviour",null,"Capital Build-Up",null,"Loan application & renewal",null,"Loan release",null,"Insurance - Life",null,"Loan application & renewal",null,"Capital Build-Up",null,"Capital Build-Up",null,"Loan release"]
[]
[null,null,"Sub-category 2",null,"Sub-category 2",null,"Sub-category 2",null,"Sub-category 2",null,"Sub-category 2",null,"Sub-category 2",null,"Sub-category 2",null,"Sub-category 2",null,"Sub-category 2",null,"Sub-category 2",null,"Sub-category 2",null,"Sub-category 2"]
[null,null,"Collection of dues",null,"Loan release",null,"Insurance - Crop",null,"Insurance - Life",null,"Loan application & renewal",null,"Staff attitude & Behaviour",null,"Loan application & renewal",null,"Capital Build-Up",null,"Capital Build-Up",null,"Loan application & renewal",null,"Collection of dues",null,"Capital Build-Up"]
[]
[null,null,"Sub-category 3",null,"Sub-category 3",null,"Sub-category 3",null,"Sub-category 3",null,"Sub-category 3",null,"Sub-category 3",null,"Sub-category 3",null,"Sub-category 3",null,"Sub-category 3",null,"Sub-category 3",null,"Sub-category 3",null,"Sub-category 3"]
[null,null,"Insurance - Life",null,"Capital Build-Up",null,"Loan approval or disapproval",null,"Loan application & renewal",null,"Insurance - Crop",null,"Loan release",null,"Insurance - Life",null,"Collection of dues",null,"Staff attitude & Behaviour",null,"Loan release",null,"Loan release",null,"Collection of dues"]
[]
[null,"Top 3 Branches with highest complaints","Branch 1",null,"Branch 1",null,"Branch 1",null,"Branch 1",null,"Branch 1",null,"Branch 1",null,"Branch 1",null,"Branch 1",null,"Branch 1",null,"Branch 1",null,"Branch 1",null,"Branch 1"]
[null,null,"GUIMBA",null,"GUIMBA",{"$nulls":9},"CALASIAO",null,"PALAYAN",null,"CABIAO",null,"MANGALDAN",null,"CALASIAO",null,"CAMILING"]
[]
[null,null,"Branch 2",null,"Branch 2",null,"Branch 2",null,"Branch 2",null,"Branch 2",null,"Branch 2",null,"Branch 2",null,"Branch 2",null,"Branch 2",null,"Branch 2",null,"Branch 2",null,"Branch 2"]
[null,null,"CALASIAO",null,"ROXAS",{"$nulls":9},"CABARROGUIS",null,"DICADI",null,"CALASIAO",null,"SANTIAGO",null,"ROSALES",null,"BALER"]
[]
[null,null,"Branch 3",null,"Branch 3",null,"Branch 3",null,"Branch 3",null,"Branch 3",null,"Branch 3",null,"Branch 3",null,"Branch 3",null,"Branch 3",null,"Branch 3",null,"Branch 3",null,"Branch 3"]
[null,null,"PALAYAN",null,"SAN RAFAEL",{"$nulls":9},"MARIA",null,null,null,"GUIMBA",null,"MEXICO",null,null,null,"GUIMBA"]
[]
[null,"Top 3 areas with highest complaints","Area 1",null,"Area 1",null,"Area 1",null,"Area 1",null,"Area 1",null,"Area 1",null,"Area 1",null,"Area 1",null,"Area 1",null,"Area 1",null,"Area 1",null,"Area 1"]
[null,null,"Area 3",null,"Area 3",null,"Area 3",null,"Area 3",null,"Tarlac Area",null,"Pangasinan Area",null,"Isabela South",null,"Pangasinan",null,"Pangasinan",null,"Pangasinan",null,"Pangasinan",null,"Tarlac"]
[]
[null,null,"Area 2",null,"Area 2",null,"Area 2",null,"Area 2",null,"Area 2",null,"Area 2",null,"Area 2",null,"Area 2",null,"Area 2",null,"Area 2",null,"Area 2",null,"Area 2"]
[null,null,"Area 1",null,"Area 1",null,"Area 1",null,"Area 4",null,"Nueva Ecija North Area",null,"Pampanga Area",null,"Pangasinan",null,"Isabela North, Isabela South, NE South, NE North, tarlac",null,"Nueva Ecija South",null,"Bulacan",null,"Pampanga",null,"Aurora"]
[]
[null,null,"Area 3",null,"Area 3",null,"Area 3",null,"Area 3",null,"Area 3",null,"Area 3",null,"Area 3",null,"Area 3",null,"Area 3",null,"Area 3",null,"Area 3",null,"Area 3"]
[null,null,"Area 2",null,"Area 4",null,"Area 2",null,"Area 1",null,"Bulacan Area",null,"Nueva Vizcaya and Ifuagao Area",null,"Aurora",null,"Bulacan, Cagayan, Nueva Vizcaya Ifugao",null,"Nueva Ecija North",null,"Isabela South",null,null,null,"Nueva Ecija North"]
[]
[null,"SP audit report"]

{"sheet":"Quarterly input sheet","index":2,"n_rows":156,"n_cols":10,"rows_kept":156,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"SOCIAL PERFORMANCE MANAGEMENT: QUARTERLY REPORT INPUT SHEET"]
[]
[]
[null,null,"Indicate the Period","Jan - March 2021",null,"April - June 2021",null,"July - September 2021",null,"October - December 2014"]
[null,null,null,"Q1",null,"Q2",null,"Q3",null,"Q4"]
[]
[null,null,"OPERATIONS"]
[]
[null,null,"% of active borrowers: "]
[null,null,"Female",0.7359,null,0.73560000000000003,null,0.73519999999999996,null,0.7349]
[null,null,"Male",0.2641,null,0.26440000000000002,null,0.26479999999999998,null,0.2651]
[null,null," Rural",0.86839999999999995,null,0.86919999999999997,null,0.87070000000000003,null,0.87170000000000003]
[null,null,"Urban",0.13159999999999999,null,0.1308,null,0.1293,null,0.1283]
[]
[null,null,"% of targeted minority borrowers",{"$f":"SUM(D19:D25)","v":0.52710000000000012},null,{"$f":"SUM(F19:F25)","v":0.52249999999999996},null,{"$f":"SUM(H19:H25)","v":0.5161},null,{"$f":"SUM(J19:J25)","v":0.51340000000000008}]
[null,null,"Small Farmers",0.18490000000000001,null,0.17860000000000001,null,0.1739,null,0.17169999999999999]
[null,null,"Farmer",0.13420000000000001,null,0.13639999999999999,null,0.13400000000000001,null,0.13350000000000001]
[null,null,"Fisherfolk",5.7999999999999996E-3,null,5.1999999999999998E-3,null,4.7999999999999996E-3,null,4.7000000000000002E-3]
[null,null,"Indigenous People",1.8499999999999999E-2,null,1.78E-2,null,1.7500000000000002E-2,null,1.7399999999999999E-2]
[null,null,"Displaced workers",0.1086,null,0.10780000000000001,null,0.1079,null,0.1081]
[null,null,"Persons with Disability",2.9999999999999997E-4,null,4.0000000000000002E-4,null,4.0000000000000002E-4,null,4.0000000000000002E-4]
[null,null,"Urban Poor",7.4800000000000005E-2,null,7.6300000000000007E-2,null,7.7600000000000002E-2,null,7.7600000000000002E-2]
[]
[null,null,"% of clients without access to formal financial services before joining ASKI","Loan Application",null,"Loan Application ",null,"Loan Application",null,"Loan Application"]
[]
[null,null,"% of  poor incoming / new clients (various poverty lines: <1.25$ a day, <2 $ a day, <5 $ a day)"]
[null,null,"% of clients living under the 1.25$ a day",4.1200000000000001E-2,null,3.2500000000000001E-2,null,3.2599999999999997E-2,null,2.93E-2]
[null,null,"% of clients living under the 2.5$ a day",0.19839999999999999,null,0.1744,null,0.17710000000000001,null,0.16669999999999999]
[null,null,"% of clients living under the 5$ a day",0.51349999999999996,null,0.48620000000000002,null,0.49640000000000001,null,0.48620000000000002]
[]
[]
[null,null,"Average Loan Size per client (Exposure to ASKI loans)",21918.42,null,21717.65,null,21667.18,null,21733.07]
[]
[]
[null,null,"Client retention rate (borrowers only): Overall",0.80420000000000003,null,0.79620000000000002,null,0.85,null,0.82]
[]
[null,null,"Number of active borrowers as at beginning of period",104949,null,106265,null,105622,null,103396]
[null,null,"Number of active borrowers as at end of period",94742,null,97213,null,100564,null,100848]
[null,null,"Number of new borrowers during the period",2032,null,2068,null,1758,null,19084]
[]
[]
[null,null,"AKP retention rate",0.86070000000000002,null,0.85709999999999997,null,0.87839999999999996,null,0.86760000000000004]
[null,null,"Number of active borrowers as at beginning of period - AKP",20882,null,20778,null,20348,null,19885]
[null,null,"Number of active borrowers as at end of period - AKP",18965,null,19016,null,18974,null,18732]
[null,null,"Number of new borrowers during the period - AKP",240,null,210,null,138,null,1706]
[]
[null,null,"AMP retention rate",0.67879999999999996,null,0.69579999999999997,null,0.90090000000000003,null,0.73029999999999995]
[null,null,"Number of active borrowers as at beginning of period - AMP",16672,null,16474,null,16989,null,16307]
[null,null,"Number of active borrowers as at end of period - AMP",12177,null,12212,null,12363,null,12356]
[null,null,"Number of new borrowers during the period - AMP",23,null,154,null,47,null,612]
[]
[null,null,"ILP retention rate",0.80289999999999995,null,0.81269999999999998,null,0.84230000000000005,null,0.8407]
[null,null,"Number of active borrowers as at beginning of period - ILP",61059,null,60254,null,59818,null,59148]
[null,null,"Number of active borrowers as at end of period - ILP",56560,null,58895,null,62031,null,62774]
[null,null,"Number of new borrowers during the period - ILP",1622,null,1551,null,1476,null,15522]
[]
[null,null,"PEOPLE / EMPLOYEES"]
[]
[null,null,"% of staff complaints resolved",1,null,1,null,1,null,1]
[]
[null,null,"No. of staff complaints received",3,null,7,null,2,null,2]
[null,null,"No. of staff complaints resolved",3,null,5,null,2,null,2]
[]
[null,null,"Top 3 sub-categories of staff complaints received","Sub-category 1"]
[null,null,null,"HR Policies",null,null,null,"HR Policies"]
[null,null,null,"Last Pay and Clearance Processing",null,"Salary & Benefits",null,"Last Pay and Clearance Processing",null,"Salary & Benefits"]
[null,null,null,"Other Category"]
[]
[null,null,null,"Sub-category 2"]
[{"$nulls":9},"Operations Policies"]
[{"$nulls":5},"Last Pay and Clearance Processing"]
[]
[null,null,null,"Sub-category 3"]
[{"$nulls":5},"Administrative Policies",null,null,null,"Staff Attitude & Behavior"]
[{"$nulls":5},"Other Category"]
[]
[]
[null,null,"Staff retention rate",0.92610000000000003,null,0.91390000000000005,null,0.94810000000000005,null,0.88859999999999995]
[]
[null,null,"Number of employees as at beginning of period",812,null,801,null,751,null,781]
[null,null,"Number of employees as at end of period",763,null,756,null,754,null,745]
[null,null,"Number of new employees during the period",10,null,24,null,21,null,48]
[]
[null,null,"Staff Turnover Rate",0.14560000000000001,null,0.1593,null,0.1368,null,0.15490000000000001]
[]
[null,null,"Number of staff resigned",28,null,54,null,27,null,118]
[null,null,"Number of employees at the beginning of the period",812,null,801,null,751,null,{"$f":"J83","v":781}]
[null,null,"Number of employees at the end of the period",763,null,756,null,754,null,{"$f":"J84","v":745}]
[]
[null,null,"Turnover Rate: Permanent Staff",8.7599999999999997E-2,null,0.11559999999999999,null,0.1249,null,0.1431]
[null,null,"Turnover Rate: Non-permanent Staff",5.8000000000000003E-2,null,4.3700000000000003E-2,null,1.1900000000000001E-2,null,1.18E-2]
[]
[null,null,"Top 3 reasons for staff exits","Reason 1",null,"Reason 1",null,"Reason 1",null,"Reason 1"]
[null,null,null,"Other Job Opportunity",null,"Other Job Opportunity",null,"Other Job Opportunity",null,"Personal Matters"]
[]
[null,null,null,"Reason 2",null,"Reason 2",null,"Reason 2",null,"Reason 2"]
[null,null,null,"Family / Personal matters",null,"Family / Personal Matters",null,"Family / Personal Matters",null,"Other Job Opportunity"]
[]
[null,null,null,"Reason 3",null,"Reason 3",null,"Reason 3",null,"Reason 3"]
[null,null,null,"Transfer to other BU",null,"Put up Business",null,"Health Conditions",null,"Working Abroad"]
[]
[null,null,"Average number of days of staff training",2,null,1,null,1.5,null,1]
[]
[]
[null,null,"PROCESS"]
[]
[null,null,"% of clients complaints resolved (Komento Mo – text)",1,null,{"$f":"F113/F112","v":0.9285714285714286},null,1,null,{"$f":"J113/J112","v":0.83333333333333337}]
[]
[null,null,"No. of client complaints received",6,null,14,null,17,null,6]
[null,null,"No. of client complaints resolved",6,null,13,null,17,null,5]
[]
[null,null,"Top 3 sub-categories of complaints received","Sub-category 1",null,"Sub-category 1",null,"Sub-category 1",null,"Sub-category 1"]
[null,null,null,"Loan release",null,"Insurance - Life",null,"Insurance - Life",null,"Staff attitude & Behaviour"]
[{"$nulls":9},"Loan release"]
[{"$nulls":9},"Other Category"]
[]
[null,null,null,"Sub-category 2",null,"Sub-category 2",null,"Sub-category 2",null,"Sub-category 2"]
[null,null,null,"Insurance - Life",null,"Loan release",null,"Loan release"]
[]
[null,null,null,"Sub-category 3",null,"Sub-category 3",null,"Sub-category 3",null,"Sub-category 3"]
[null,null,null,"Staff attitude & Behaviour",null,"Collection of dues",null,"Collection of dues"]
[{"$nulls":5},"Staff attitude & Behaviour",null,"Staff attitude & Behaviour"]
[]
[null,null,"Top 3 Branches with highest complaints","Branch 1",null,"Branch 1",null,"Branch 1",null,"Branch 1"]
[null,null,null,"SAN MATEO",null,"PLARIDEL",null,"PANIQUI",null,"GABALDON"]
[{"$nulls":7},"BALIUAG, ECHAGUE, ALICIA, CABATUAN, CONCEPCION, SAN MIGUEL, TUGUEGARAO SOUTH, STA. MARIA, GENERAL TINIO",null,"ALLACAPAN, GUIMBA, MANGALDAN"]
[]
[null,null,null,"Branch 2",null,"Branch 2",null,"Branch 2",null,"Branch 2"]
[null,null,null,"PANIQUI",null,"CABATUAN"]
[null,null,null,"Arayat",null,"TUMAUINI, PORAC, MARIA, LASAM"]
[]
[null,null,null,"Branch 3",null,"Branch 3",null,"Branch 3",null,"Branch 3"]
[]
[]
[null,null,"Top 3 areas with highest complaints","Area 1",null,"Area 1",null,"Area 1",null,"Area 1"]
[null,null,null,"ISABELA CENTRAL",null,"BULACAN, NE NORTH",null,"ISABELA CENTRAL, BULACAN",null,"CAGAYAN 2, NE NORTH, NE NORTHEAST, PANGASINAN"]
[]
[null,null,null,"Area 2",null,"Area 2",null,"Area 2",null,"Area 2"]
[null,null,null,"PAMPANGA, TARLAC",null,"ISABELA CENTRAL, PAMPANGA, ISABELA NORTH, CAGAYAN 2",null,"PAMPANGA, TARLAC, CAGAYAN 1, ISABELA SOUTH/QUIRINO, NE SOUTH",null,"n/a"]
[]
[null,null,null,"Area 3",null,"Area 3",null,"Area 3",null,"Area 3"]
[null,null,null,"n/a",null,"n/a",null,"n/a",null,"n/a"]
[]
[null,null,"SP audit report","n/a",null,"n/a",null,"n/a",null,"n/a"]
[]
[null,null,"FINANCE"]
[]
[null,null,"Return on Assets",-7.3499999999999996E-2,null,-9.6000000000000002E-2,null,-9.9299999999999999E-2,null,-0.1074]
[]
[]
[null,null,"CLIENTS"]
[]
[null,null,"Total numbers of employees reported (jobs created)",763,null,756,null,751,null,745]

{"sheet":"Annual input sheet","index":3,"n_rows":266,"n_cols":6,"rows_kept":266,"cut":false,"hidden":false,"merged":[[197,5,199,5],[256,2,257,2],[256,4,257,4]]}
[]
[]
[]
[null,"SOCIAL PERFORMANCE MANAGEMENT: ANNUAL REPORT INPUT SHEET"]
[]
[]
[null,"Indicate the Period","Year 2021",null,"Year 2020"]
[null,null,"Current Year",null,"Previour Year"]
[]
[null,"OPERATIONS"]
[]
[null,"% of active borrowers: "]
[null,"Female",0.7349,null,0.73409999999999997]
[null,"Male",0.2651,null,0.26590000000000003]
[null," Rural",0.87170000000000003,null,0.86570000000000003]
[null,"Urban",0.1283,null,0.1343]
[]
[null,"% of targeted minority borrowers ",{"$f":"SUM(C19:C25)","v":0.51340000000000008},null,{"$f":"SUM(E19:E25)","v":0.53920000000000001}]
[null,"Small Farmers",0.17169999999999999,null,0.1988]
[null,"Farmer",0.13350000000000001,null,0.13389999999999999]
[null,"Fisherfolk",4.7000000000000002E-3,null,6.4000000000000003E-3]
[null,"Indigenous People",1.7399999999999999E-2,null,1.9E-2]
[null,"Displaced workers",0.1081,null,0.10340000000000001]
[null,"Persons with Disability",4.0000000000000002E-4,null,4.0000000000000002E-4]
[null,"Urban Poor",7.7600000000000002E-2,null,7.7299999999999994E-2]
[]
[null,"% of clients without access to formal financial services before joining ASKI","n/a",null,"n/a","*ASKI temporarily stop the Client Transformation Survey due to pandemic"]
[]
[null,"% of  poor incoming / new clients (various poverty lines: <1.25$ a day, <2 $ a day, <5 $ a day)"]
[null,"% of clients living under the 1.25$ a day",3.27E-2,null,4.0899999999999999E-2]
[null,"% of clients living under the 2.5$ a day",0.1762,null,0.1991]
[null,"% of clients living under the 5$ a day",0.49359999999999998,null,0.51590000000000003]
[]
[]
[null,"Average Loan Size per client (Exposure to ASKI loans)"]
[null,"AKP",7520.58,null,7611.25]
[null,"AMP",32729.25,null,32176.65]
[null,"ILP",24949.38,null,26795.57]
[]
[null,"Client retention rate (borrowers only): Overall",0.82,null,0.85]
[]
[null,"Number of active borrowers as at beginning of period",103396,null,105223]
[null,"Number of active borrowers as at end of period",100848,null,103396]
[null,"Number of new borrowers during the period",19084,null,3440]
[]
[]
[null,"AKP retention rate",0.86760000000000004,null,0.87839999999999996]
[null,"AMP retention rate",0.73029999999999995,null,0.90090000000000003]
[null,"ILP retention rate",0.8407,null,0.84230000000000005]
[]
[null,"Top 3 reasons for client exit","Reason 1",null,"Reason 1"]
[null,null,"Some business owners stop borrowing capital for the recovery of their business due to pandemic",null,"Some business owners stop borrowing capital for the recovery of their business due to pandemic"]
[]
[null,null,"Reason 2",null,"Reason 2"]
[null,null,"I only need to borrow in a seasonal basis",null,"I only need to borrow in a seasonal basis"]
[]
[null,null,"Reason 3",null,"Reason 3"]
[null,null,"Have a enough capital for business",null,"Have a enough capital for business"]
[]
[]
[null,"PEOPLE / EMPLOYEES"]
[]
[null,"% of staff complaints resolved",1,null,1]
[]
[null,"No. of staff complaints received",14,null,23]
[null,"No. of staff complaints resolved",12,null,20]
[]
[null,"Top 3 sub-categories of staff complaints received","Sub-category 1",null,"Sub-category 1"]
[]
[null,null,"Last Pay and Clearance Processing",null,"Last Pay and Clearance Processing"]
[]
[null,null,"Sub-category 2",null,"Sub-category 2"]
[]
[null,null,"Benefits",null,"Administrative Policies, Other Category"]
[]
[null,null,"Sub-category 3",null,"Sub-category 3"]
[]
[null,null,"HR Policies, Administrative Policies and Other Category"]
[]
[null,"Staff retention rate",0.88859999999999995,null,0.93559999999999999]
[]
[null,"Number of employees as at beginning of period",781,null,819]
[null,"Number of employees as at end of period",745,null,781]
[null,"Number of new employees during the period",48,null,14]
[]
[null,"Staff Turnover Rate",{"$f":"SUM(C88:C89)","v":0.15490000000000001},null,{"$f":"SUM(E88:E89)","v":0.14860000000000001}]
[]
[null,"Turnover Rate: Permanent Staff",0.1431,null,8.7400000000000005E-2]
[null,"Turnover Rate: Non-permanent Staff",1.18E-2,null,6.1199999999999997E-2]
[]
[null,"Top 3 reasons for staff exits","Reason 1",null,"Reason 1"]
[null,null,"Other Job Opportunity",null,"Other Job Opportunity"]
[]
[null,null,"Reason 2",null,"Reason 2"]
[null,null,"Family Matters",null,"End of Contract"]
[]
[null,null,"Reason 3",null,"Reason 3"]
[null,null,"Transfer to Other BU",null,"Family and Personal Matters"]
[]
[null,"Average number of days of staff training",1,null,2]
[]
[]
[null,"PROCESS"]
[]
[null,"% of clients complaints resolved (Komento Mo – text)",1,null,1]
[]
[null,"No. of client complaints received",44,null,41]
[null,"No. of client complaints resolved",43,null,34]
[]
[null,"Top 3 sub-categories of client complaints received","Sub-category 1",null,"Sub-category 1"]
[null,null,"Loan release",null,"Loan release"]
[null,null,"Insurance - Life"]
[]
[null,null,"Sub-category 2",null,"Sub-category 2"]
[null,null,"Staff attitude & Behaviour",null,"Insurance - Life"]
[]
[null,null,"Sub-category 3",null,"Sub-category 3"]
[null,null,"Other Category",null,"Capital Build-Up"]
[]
[]
[null,"Top 3 Branches with highest complaints","Branch 1",null,"Branch 1"]
[null,null,"PANIQUI",null,"MEXICO"]
[null,null,"San Mateo, Cabatuan, Plaridel, Cabanatuan"]
[]
[null,null,"Branch 2",null,"Branch 2"]
[null,null,"ALICIA",null,"CABANATUAN"]
[null,null,"Arayat, Baliuag, Echague, Concepcion, San Miguel, Tuguegarao South, Sta. Maria, Gen. Tinio, Tumauini, Porac, Maria, Lasam, Allacapan, Gabaldon, Guimba, Mangaldan",null,"Porac, Santiago, Talavera"]
[]
[null,null,"Branch 3",null,"Branch 3"]
[null,null,"n/a",null,"BAGGAO"]
[{"$nulls":4},"Abulug, Alcala, Cabiao, Cauayan, Concepcion, Echague, General Tinio, Maria, Piat, Sta. Rosa, Tarlac, San Mateo, San Rafael, Solano, Angeles, Palayan, Gattaran, Cabatuan, Calasiao"]
[]
[null,"Top 3 areas with highest complaints","Area 1",null,"Area 1"]
[null,null,"Isabela Central",null,"Nueva Ecija"]
[]
[null,null,"Area 2",null,"Area 2"]
[null,null,"Bulacan",null,"Pampanga"]
[]
[null,null,"Area 3",null,"Area 3"]
[null,null,"Pampanga, Nueva Ecija North",null,"Cagayan"]
[]
[null,"SP audit report","n/a",null,"n/a","Due to limited number of ASKI Auditors, the SP audit is temporarily stop since 2020"]
[]
[null,"Branch Compliance Rating","ASKI stop giving Audit Ratings among branches due to pandemic but the Internal Audit continuously conducted financial and operation audit remotely. The giving of Audit Ratings started this January 2022",null,"ASKI stop giving Audit Ratings among branches due to pandemic but the Internal Audit continuously conducted financial and operation audit remotely. The giving of Audit Ratings started this January 2022"]
[]
[null,"Client Protection Principle; Adherence Rating; Ranking importance of CPP","Yes",null,"Yes"]
[]
[null,"Range of financial and non-financial services offered","financial - 9\nnon-financial - 12     ",null,"financial - 9\nnon-financial - 12"]
[]
[null,"Are client exit interviews conducted?","No",null,"No"]
[]
[null,"Are products, services modified as a result of client surveys, focus groups etc?","Yes",null,"Yes"]
[]
[null,"Do you have a standard measure of client satisfaction?","Yes",null,"Yes"]
[]
[null,"Does the organisation report to: MIX Market, Smart Campaign, MFT etc","No",null,"No"]
[]
[null,"Has a rating been done of your organisation in the last 2 years?","Yes",null,"Yes"]
[]
[null,"Do you have mechanisms in place to handle client complaints?","Yes",null,"Yes"]
[]
[]
[]
[null,"FINANCE"]
[]
[null,"Effective Interest Rate (EIR) for most prolific (largest portfolio) group loan",0.64949999999999997,null,0.64949999999999997]
[]
[null,"Average EIR in country for group loan","Not Applicable",null,"Not Applicable"]
[]
[null,"Return on Assets",-0.10970000000000001,null,-1.9800000000000002E-2,"Negative ROA was due decrease in revenue because of hard lockdowns implemented during the height of Covid-19 our field officers were unable to collect payments of clients. Most of the clients were force to closed their business due to limitations and restrictions implemented by the government."]
[]
[]
[null,"CLIENTS"]
[]
[null,"% of clients reporting an increased net promoter (client satisfaction) score ","n/a",null,"n/a"]
[]
[null,"Top 3 Branches with highest NPS Scores","Branch 1",null,"Branch 1"]
[]
[]
[null,null,"Branch 2",null,"Branch 2"]
[]
[]
[null,null,"Branch 3",null,"Branch 3"]
[]
[]
[null,"Top 3 feedback received","Reason 1",null,"Reason 1"]
[null,null,"n/a",null,"n/a"]
[]
[null,null,"Reason 2",null,"Reason 2"]
[null,null,"n/a",null,"n/a"]
[]
[null,null,"Reason 3",null,"Reason 3"]
[null,null,"n/a",null,"n/a"]
[]
[null,"Total numbers of employees reported (jobs created)","No Data",null,"No Data"]
[]
[null,"% of clients (tracked) who present increase, status quo or decrease in their poverty score",0,null,0]
[null,"% of clients who have increased poverty scores",0.64700000000000002,null,0.51749999999999996]
[null,"% of clients who have poverty scores as status quo",0.2631,null,0.36859999999999998]
[null,"% of clients who have decreased poverty scores",8.9899999999999994E-2,null,0.1139]
[]
[null,"% of clients who have increased their saving in the last 12 months","Not yet available",null,"Not yet available"]
[]
[null,"% of clients who used their loans for various purposes"]
[null,null,"Not yet available",null,"Not yet available"]
[]
[]
[]
[]
[]
[]
[null,"% of clients who used their business loans for various purposes","Unable to quantify due to the limitations of pandemic",null,"Unable to quantify due to the limitations of pandemic"]
[]
[]
[]
[]
[]
[null,"% of clients who have other sources of Income","Client Rapid Assessment Survey",null,0.63070000000000004]
[]
[]
[]
[]
[]
[]
[null,"% of Clients with who have other financial contributors in that household","Unable to quantify due to the limitations of pandemic",null,"Unable to quantify due to the limitations of pandemic","ASKI is currently shifting to digital transaction and because of this we are not able to quantify data."]
[]
[null,"% increase in Business Sales  after joining (client level data)","Will come from cashflow and laf (not yet finalized)",null,"Will come from cashflow and laf (not yet finalized)"]
[]
[null,"% of  clients with increase in Business Sales","Will come from cashflow and laf (not yet finalized)",null,"Will come from cashflow and laf (not yet finalized)"]
[]
[null,"% of clients with increase in  net income from business","Will come from cashflow and laf (not yet finalized)",null,"Will come from cashflow and laf (not yet finalized)"]
[]
[null,"% increase in agriculture yield","Unable to quantify due to the limitations of pandemic",null,"Unable to quantify due to the limitations of pandemic"]
[]
[null,"% of clients with increased yield","Unable to quantify due to the limitations of pandemic",null,"Unable to quantify due to the limitations of pandemic"]
[]
[null,"% of clients who report having experienced a serious medical condition/illness in the last 6 months within their household","Unable to quantify due to the limitations of pandemic",null,"Unable to quantify due to the limitations of pandemic"]
[]
[null,"% of clients who had access to a qualified health practitioner or health facility for treatment for this illness/condition.","Unable to quantify due to the limitations of pandemic",null,"Unable to quantify due to the limitations of pandemic"]
[]
[null,"% of clients who have access to a constructed toilet: Types of Toilet","Unable to quantify due to the limitations of pandemic",null,"Unable to quantify due to the limitations of pandemic"]
[]
[null,"% of clients unable to provide adequate food for their family for the last 6 months","Unable to quantify due to the limitations of pandemic",null,"Unable to quantify due to the limitations of pandemic"]
[]
[null,"% of clients who have had to sell assets to provide for their family in the last 6 months?","Unable to quantify due to the limitations of pandemic",null,"Unable to quantify due to the limitations of pandemic"]
[]
[null,"% of Clients with access to their own drinking water","Unable to quantify due to the limitations of pandemic",null,"Unable to quantify due to the limitations of pandemic"]
[]
[null,"% of clients who have school age (5-15) children who attend school regularly","Unable to quantify due to the limitations of pandemic",null,"Unable to quantify due to the limitations of pandemic"]
[]
[null,"% of clients who feel able to participate in key community decisions","Unable to quantify due to the limitations of pandemic",null,"Unable to quantify due to the limitations of pandemic"]
[]
[null,"% of clients who participate in key household spending decisions","Unable to quantify due to the limitations of pandemic",null,"Unable to quantify due to the limitations of pandemic"]
[]
[null,"% of clients whose children have the possibility of attending college or university","Unable to quantify due to the limitations of pandemic",null,"Unable to quantify due to the limitations of pandemic"]
[]
[null,"% of Clients with who --- number of household members","Unable to quantify due to the limitations of pandemic",null,"Unable to quantify due to the limitations of pandemic"]
[]
[]
[]
[]
[null,"Number of clients who attended the environment-related orientation programme","No Training Conducted",null,"No Training Conducted","ASKI were unable to conduct environmental training to clients due to restrictions of Covid-19"]
[]
[null,"% of clients who feel greater spiritual support after joining the programme?","No Training Conducted",null,2.16E-3]
[]
[null,"Number of clients who attended spiritual transformation activities","Transformation Activities started this 2022",null,246]

{"sheet":"Annual SPM Dashboard","index":4,"n_rows":102,"n_cols":12,"rows_kept":102,"cut":false,"hidden":false,"merged":[[34,1,35,1],[34,2,35,2],[34,4,35,5],[61,2,61,4]]}
[]
[{"$nulls":4},"ANNUAL SPM DASHBOARD - FOR THE BOARD"]
[]
[{"$nulls":7},"OPERATIONS"]
[]
[null,"% of active borrowers"]
{"$rows_empty":9}
[null,"Benchmarks:  Female (75%); Rural (85%)"]
[]
[null,"% of targeted minority borrowers ",null,null,{"$f":"'Annual input sheet'!C18","v":0.51340000000000008}]
[]
[]
[]
[]
[]
[]
[{"$nulls":8},"Poverty Line considered for this graph: 2.5$ a day"]
[]
[]
[null,"Benchmarks: 20%"]
[]
[]
[null,null,"       Benchmarks: 2%",null,null,"CTS"]
[]
[null,"Client Borrowing Capacity (Exposure to ASKI loans)"]
[null,"Average Loan Size of Clients"]
[null,"Benchmarks","AMP: Php 30,000                             AKP: Php 5,000                     ILP:  Php15,000",null,"AMP: Php 30,940.95                                        AKP: Php 3,966.95                               ILP:  Php 13,902.69"]
[]
[]
[{"$nulls":4},"PROCESS"]
[]
[null,"% of clients complaints resolved (Komento Mo – text)",{"$nulls":4},"Top 3 sub-categories of complaints received"]
[null,null,{"$f":"'Annual input sheet'!C105","v":1}]
[null,null,"Benchmark: 85%",null,null,null,1,{"$f":"'Annual input sheet'!C111","v":"Loan release"}]
[null,"Complaints Received",null,{"$f":"'Annual input sheet'!C107","v":44},null,null,2,{"$f":"'Annual input sheet'!C115","v":"Staff attitude & Behaviour"}]
[null,"Complaints Resolved",null,{"$f":"'Annual input sheet'!C108","v":43},null,null,3,{"$f":"'Annual input sheet'!C118","v":"Other Category"}]
[]
[null,"Top 3 Branches with highest complaints",{"$nulls":4},"Top 3 areas with highest complaints"]
[]
[null,1,{"$f":"'Annual input sheet'!C122","v":"PANIQUI"},null,null,null,1,{"$f":"'Annual input sheet'!C134","v":"Isabela Central"}]
[null,2,{"$f":"'Annual input sheet'!C126","v":"ALICIA"},null,null,null,2,{"$f":"'Annual input sheet'!C137","v":"Bulacan"}]
[null,3,{"$f":"'Annual input sheet'!C130","v":"n/a"},null,null,null,3,{"$f":"'Annual input sheet'!C140","v":"Pampanga, Nueva Ecija North"}]
[]
[]
[null,"SP audit report",null,null,{"$f":"'Annual input sheet'!C142","v":"n/a"},null,null,"Adherence to client protection",null,null,null,{"$f":"'Annual input sheet'!C146","v":"Yes"}]
[]
[null,"Client Retention Rate",{"$nulls":4},"Client Satisfaction Score (Net Promoter Score)"]
[]
[null,{"$f":"'Annual input sheet'!C40","v":0.82},null,{"$f":"('Annual input sheet'!C40-'Annual input sheet'!E40)","v":-3.0000000000000027E-2}]
[]
[null,"Benchmark: 85%"]
[null,"Top 3 reasons for client drop out:",{"$nulls":7},{"$f":"'Annual input sheet'!C175","v":"n/a"}]
[null,1,{"$f":"'Annual input sheet'!C52","v":"Some business owners stop borrowing capital for the recovery of their business due to pandemic"}]
[null,2,{"$f":"'Annual input sheet'!C55","v":"I only need to borrow in a seasonal basis"},null,null,null,"Benchmark: 85%"]
[null,3,{"$f":"'Annual input sheet'!C58","v":"Have a enough capital for business"},{"$nulls":4},"Top 3 feedback received"]
[{"$nulls":7},1,{"$f":"'Annual input sheet'!C187","v":"n/a"}]
[null,"Product-wise Retention Rates",{"$nulls":5},2,{"$f":"'Annual input sheet'!C190","v":"n/a"}]
[{"$nulls":7},3,{"$f":"'Annual input sheet'!C193","v":"n/a"}]
[null,null,"Current","Previous "]
[null,"AKP",{"$f":"'Annual input sheet'!C47","v":0.86760000000000004},{"$f":"'Annual input sheet'!E47","v":0.87839999999999996},null,null,null,"Top 3 branches with highest NPS Score"]
[{"$nulls":7},1,{"$f":"'Annual input sheet'!C179","v":0}]
[null,"AMP",{"$f":"'Annual input sheet'!C48","v":0.73029999999999995},{"$f":"'Annual input sheet'!E48","v":0.90090000000000003},null,null,null,2,{"$f":"'Annual input sheet'!C182","v":0}]
[{"$nulls":7},3,{"$f":"'Annual input sheet'!C185","v":0}]
[null,"ILP",{"$f":"'Annual input sheet'!C49","v":0.8407},{"$f":"'Annual input sheet'!E49","v":0.84230000000000005}]
[]
[]
[{"$nulls":4},"FINANCE"]
[]
[null,"Effective Interest Rate on",null,null,"Industry Average for group loans",{"$nulls":4},"Return on Assets"]
["AKP - Alalay sa Kabuhayan Program (Group Loans)",null,null,null,"APR, by loan purpose"]
[]
[]
[null,{"$f":"'Annual input sheet'!C166","v":0.64949999999999997},null,null,{"$f":"'Annual input sheet'!C168","v":"Not Applicable"},{"$nulls":4},{"$f":"'Annual input sheet'!C170","v":-0.10970000000000001},"p.a."]
[]
[null,"Benchmark: 70%",null,null,"Source: goo.gl/BdtiJ4",{"$nulls":4},"Benchmark: 3 to 4 % p.a."]
[]
[{"$nulls":4},"EMPLOYEES"]
[]
[null,"Staff Retention Rate",{"$nulls":5},"% of staff complaints resolved (Komento Mo – text)"]
[null,null,{"$f":"'Annual input sheet'!C80","v":0.88859999999999995},{"$nulls":5},{"$f":"'Annual input sheet'!C63","v":1}]
[null,null,"Benchmark: 85%",{"$nulls":5},"Benchmark: 85%"]
[{"$nulls":7},"Complaints Received",null,{"$f":"'Annual input sheet'!C65","v":14}]
[null,"Staff Turnover Rate",null,null,"Top 3 reasons for staff exits:",null,null,"Complaints Resolved",null,{"$f":"'Annual input sheet'!C66","v":12}]
[{"$nulls":4},1,{"$f":"'Annual input sheet'!C92","v":"Other Job Opportunity"}]
[null,null,{"$f":"'Annual input sheet'!C86","v":0.15490000000000001},null,2,{"$f":"'Annual input sheet'!C95","v":"Family Matters"},null,"Top 3 sub-categories of complaints received"]
[null,"Permanent Staff ",null,{"$f":"'Annual input sheet'!C88","v":0.1431},3,{"$f":"'Annual input sheet'!C98","v":"Transfer to Other BU"}]
[null,"Non-Permanent Staff ",null,{"$f":"'Annual input sheet'!C89","v":1.18E-2},null,null,null,1,{"$f":"'Annual input sheet'!C71","v":0}]
[{"$nulls":7},2,{"$f":"'Annual input sheet'!C75","v":0}]
[{"$nulls":7},3,{"$f":"'Annual input sheet'!C79","v":0}]
[]
[]
[{"$nulls":7},"Average Number of Days for Staff Training"]
[{"$nulls":8},{"$f":"'Annual input sheet'!C100","v":1},"days"]
[{"$nulls":8},"Benchmark: 0.30"]