{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Parameter","VarCondition","GradingCond"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Parameter","index":0,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["BranchCode","Net NPL%","Location","Loan Growth Vs Target%","BM Level","Blacklisted Accounts","Audited last 3 years","Dedicated RM","Age of Branch","Risky assets (RW>100%)","CRO's Adjustment"]
["Head Office Branch",0,"Valley",0.12,"Manager",0,"No","Yes",23,0.04,"Add"]
["Siddharthanagar Branch",5.0000000000000001E-3,"Madesh",{"$f":"D2+5%","v":0.16999999999999998},"Officer",2,"Yes","Yes",10,0.27500000000000002,"Less"]
["Bardibas Branch",6.0000000000000001E-3,"Madesh",{"$f":"D3+5%","v":0.21999999999999997},"Assistant",4,"Yes","Yes",10,0.27,"Less"]
["Koteshwor Branch",6.9999999999999993E-3,"Others",0.26999999999999996,"Officer",6,"Yes","Yes",10,0.26500000000000001,"No"]
["Bouddha Branch",8.0000000000000002E-3,"Valley",0.31999999999999995,"Manager",8,"Yes","Yes",5,0.06,"No"]
["Rajbiraj Branch",8.9999999999999993E-3,"Madesh",0.36999999999999994,"Assistant",10,"Yes","Yes",6,0.255,"Less"]
["Kalopul Branch",9.9999999999999985E-3,"Valley",0.41999999999999993,"Manager",12,"Yes","Yes",7,0.25,"Add"]
["Jaulakhel Branc",1.2E-2,"Valley",0.46999999999999992,"Officer",16,"Yes","Yes",3,0.14000000000000001,"No"]
["Surunga Branch",1.3000000000000001E-2,"Koshi",0.51999999999999991,"Assistant",18,"Yes","Yes",1,0.23499999999999999,"Less"]
["Chabahil Branch",1.4000000000000002E-2,"Valley",0.56999999999999995,"Officer",20,"Yes","Yes",6,0.22999999999999998,"Add"]
["Parsa Branch",1.5000000000000003E-2,"Madesh",0.62,"Officer",0,"Yes","Yes",23,0.22499999999999998,"Less"]
["Jadibuti Branch",1.6000000000000004E-2,"Valley",0.67,"Officer",0,"No","Yes",23,0.04,"No"]
["Khotang Branch",0.11700000000000001,"Koshi",0.72000000000000008,"Officer",0,"Yes","Yes",23,0.21499999999999997,"Less"]
["Hakimchowk Branch",0.158,"Others",0.77000000000000013,"Assistant",39,"Yes","Yes",23,0.20999999999999996,"No"]
["Biratnagar Branch",1.9000000000000006E-2,"Koshi",0.82000000000000017,"Officer",80,"No","No",23,0.105,"Less"]
["Sundhara Branch",2.0000000000000004E-2,"Valley",0.87000000000000022,"Officer",54,"Yes","No",23,0.19999999999999996,"Add"]
["Birauta Branch",2.1000000000000005E-2,"Others",0.92000000000000026,"Officer",50,"Yes","No",23,0.19499999999999995,"No"]
["Nepalgunj Branch",2.2000000000000006E-2,"Others",0.97000000000000031,"Officer",65,"Yes","No",23,0.09,"No"]
["Simara Branch",0.1,"Madesh",0.7,"Assistant",78,"Yes","No",3,8.5000000000000006E-2,"Less"]
["Baneshwor Branch",2.4000000000000007E-2,"Valley",0.75,"Officer",45,"No","Yes",23,0.26,"No"]
["Kalanki Branch",0.125,"Valley",0.8,"Officer",0,"Yes","Yes",4,0,"No"]
["Kohalpur Branch",2.6000000000000009E-2,"Others",0.85000000000000009,"Officer",2,"Yes","No",4,0,"Less"]
["Putalisadak Branch",2.700000000000001E-2,"Valley",0.90000000000000013,"Officer",1,"Yes","No",4,6.5000000000000002E-2,"No"]
["Bagdula Branch",2.8000000000000011E-2,"Others",0.95000000000000018,"Officer",3,"No","No",4,0.15999999999999992,"No"]
["Jhumka Branch",3.3000000000000015E-2,"Madesh",1.0000000000000002,"Assistant",5,"No","No",6,0.15499999999999992,"Less"]
["Surkhet Branch",3.4000000000000016E-2,"Others",1.0500000000000003,"Assistant",7,"No","No",6,0.14999999999999991,"No"]
["Lamki Branch",3.5000000000000017E-2,"Others",1.1000000000000003,"Assistant",9,"No","No",6,4.4999999999999998E-2,"Less"]
["Hetauda Branch",0.23699999999999999,"Others",1.1500000000000004,"Assistant",11,"No","Yes",6,0,"No"]
["Dhangadhi Branch",3.9000000000000021E-2,"Others",1.2000000000000004,"Assistant",15,"Yes","Yes",4,0.12999999999999989,"No"]
["Ramnagar Branch",4.1000000000000016E-2,"Madesh",1.2500000000000004,"Assistant",17,"No","Yes",4,0.12499999999999989,"Less"]
["Phaparbari Branch",0.122,"Others",1.3000000000000005,"Assistant",19,"No","Yes",4,0.11999999999999988,"No"]
["Nepaltar Branch",4.300000000000001E-2,"Valley",1.3500000000000005,"Assistant",21,"No","Yes",4,0.11499999999999988,"No"]
["Tulsipur Branch",8.5000000000000006E-2,"Others",1.4000000000000006,"Assistant",23,"No","Yes",4,0,"No"]
["Gulariya Branch",4.5999999999999999E-2,"Others",1.4500000000000006,"Assistant",25,"Yes","Yes",4,0,"No"]
["Tikapur Branch",4.6999999999999993E-2,"Others",1.5000000000000007,"Assistant",27,"Yes","Yes",4,0,"No"]
["Shamsergunj Branch",4.8999999999999988E-2,"Others",1.5500000000000007,"Assistant",29,"No","Yes",4,0.06,"No"]
["Damak Branch",4.9999999999999982E-2,"Koshi",1.6000000000000008,"Officer",31,"No","Yes",4,8.9999999999999858E-2,"Less"]
["Pepsicola Branch",5.0999999999999976E-2,"Valley",1.6500000000000008,"Officer",33,"Yes","Yes",4,8.4999999999999853E-2,"No"]
["Thamel Branch",5.1999999999999977E-2,"Valley",1.7000000000000008,"Officer",35,"Yes","Yes",1,7.9999999999999849E-2,"No"]
["Tripureshwor Branch",5.2999999999999971E-2,"Valley",1.7500000000000009,"Officer",37,"Yes","Yes",1,0,"No"]

{"sheet":"VarCondition","index":1,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Column Name","Operator","Value","Score"]
["Net NPL%",">",0.1,3]
["Net NPL%",">",0.05,5]
["Net NPL%",">",0.01,10]
["Net NPL%","<=",0.01,15,{"$f":"D5","v":15}]
["Location","Contains","Madesh",2]
["Location","Contains","Koshi",5]
["Location","Contains","Others",10]
["Location","Contains","Valley",15,{"$f":"D9","v":15}]
["Loan Growth Vs Target%",">",1.5,1,null,null,null,"Note"]
["Loan Growth Vs Target%",">",1,5]
["Loan Growth Vs Target%","<=",1,10,{"$f":"D12","v":10},null,null,"1. Input the Variable conditions on First sheet, Grading Condition on Second and the input on last sheet"]
["BM Level","Contains","Assistant",2,null,null,null,"2. Click on the Compute grading button"]
["BM Level","Contains","Officer",5]
["BM Level","Contains","Manager",15,{"$f":"D15","v":15}]
["Blacklisted Accounts",">",20,1]
["Blacklisted Accounts",">",0,5]
["Blacklisted Accounts","<=",0,10,{"$f":"D18","v":10}]
["Audited last 3 years","Contains","No",7]
["Audited last 3 years","Contains","Yes",10,{"$f":"D20","v":10}]
["Dedicated RM","Contains","No",4]
["Dedicated RM","Contains","Yes",5,{"$f":"D22","v":5}]
["Age of Branch","<",5,2]
["Age of Branch",">=",5,5,{"$f":"D24","v":5}]
["Risky assets (RW>100%)",">",0.1,2]
["Risky assets (RW>100%)",">",0.05,8]
["Risky assets (RW>100%)","<=",0.05,15,{"$f":"D27","v":15}]
["CRO's Adjustment","Contains","Add",5]
["CRO's Adjustment","Contains","Less",-5]
["CRO's Adjustment","Contains","No",0]

{"sheet":"GradingCond","index":2,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Min Score","Max Score","Grade"]
[{"$f":"B3+1","v":101},1000,"Error"]
[{"$f":"B4+1","v":71},{"$f":"SUM(VarCondition!E:E)","v":100},"A"]
[{"$f":"B5+1","v":41},70,"B"]
[{"$f":"B6+1","v":1},40,"C"]
[-1000,0,"Error"]