{"text_format":"1","workbook":"xlsx","n_sheets":30,"sheets":["Cover Page","Instructions","FAQ","Index","0.1 Input Background","0.2 Unit cost  assumptions","0.4 All inputs","0.5 UI backend","0.6 UI Inputs","0.7 UI input conversion","0.8 Assumptions","0.9 Default parameters","1. Enrolment","1.1 Backend","2. human resource","0.3 HR compensation","2.1 Org_Structure","3. Helpdesk,IEC and T&CB","4. Software","5. Facility cost","6. Identity Credential","6.1 Feature cost ","7. Central IT","7.1 backend","8. Model Output","8.1 Scenario 1","8.2 Scenario 2","8.3 Scenario 3","8.4 Scenario 4","9. Graphs"],"not_rendered":{"charts":11,"images":10,"macros":1,"external_links":0,"defined_names":10,"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":"Cover Page","index":0,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]

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

{"sheet":"FAQ","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Index","index":3,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":true,"merged":[[3,3,3,5]]}
[]
[]
[]
[null,null,null,"Cost Reference Model Index"]
[null,null,null,"S.n. ","Sheet name","Description "]
[null,null,null,1,"Instruction","It includes basic instruction and tool features. It also contains interface button to input data and compare multiple scenarios "]
[null,null,null,2,"0.2 Unit cost assumption","Unit cost of items/ service used to estimate cost of national identity program"]
[null,null,null,3,"0.3 HR compensation","Annual compensation for various positions for administrative and operational roles"]
[null,null,null,4,"0.4 All inputs","Contains all the inputs required by model to function properly"]
[null,null,null,5,"0.8 Assumption","Details out estimation methodology and assumptions "]
[null,null,null,6,"0.9 Default parameters","Contains assumed default parameter, it feeds into 0.4 all input sheet"]
[null,null,null,7,"1 Enrolment","Estimation of enrolment station requirement for enrolment, data update and helpdesk "]
[null,null,null,8,"1.1 Enrolment backend","Estimation of enrolment time, cost of enrolment kit and population projection based on input provided by user"]
[null,null,null,9,"2 Human resource","Estimation of cost of human resource"]
[null,null,null,10,"2.1 Org structure ","Assumed organisation structure for administration and operation "]
[null,null,null,11,"3. Helpdesk, IEC and T&CB","Estimation of cost associated with helpdesk, IEC, training and capacity building activities"]
[null,null,null,12,"4. Software","Estimation of software development and maintenance cost "]
[null,null,null,13,"5. Facility cost","Estimation of setting up and maintaining office facilities "]
[null,null,null,14,"6. Identity credential ","Estimation of cost of identity credential"]
[null,null,null,15,"6.1 Feature cost","Estimation of per identity cost based on user input"]
[null,null,null,16,"7 Central IT","Estimation of cost of data center and disaster recovery site "]
[null,null,null,17,"7.1 Backend","Estimation of server, storage requirements for data center "]
[null,null,null,18,"8. Model output","Output of model "]
[null,null,null,19,"8.1 Scenario 1","Saved output for scenario 1 "]
[null,null,null,20,"8.2 Scenario 2","Saved output for scenario 2"]
[null,null,null,21,"8.3 Scenario 1","Saved output for scenario 3"]
[null,null,null,22,"8.4 Scenario 1","Saved output for scenario 4"]
[null,null,null,23,"Graphs","Comparative graphs for all the scenarios "]

{"sheet":"0.1 Input Background","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"0.2 Unit cost  assumptions","index":5,"n_rows":86,"n_cols":8,"rows_kept":86,"cut":false,"hidden":true,"merged":[[0,4,3,7]]}
[null,null,null,null,"Instructions:\nThis sheet list down the unit cost of items / services used in this model to estimate the overall project cost. Cost of these items / services are taken from industry experts, wholesale suppliers and various industry reports. \nKindly read the assumptions and calculation methodology carefully before changing these values. "]
[]
[]
[]
[]
[null,null,null,null,"Name of the item / Service","Unit cost (US $)","Description ","Source (if any)"]
[null,null,null,null,"Computer / Laptop",1200]
[null,null,null,null,"Mobile / tablet",200]
[null,null,null,null,"Camera / webcam",100]
[null,null,null,null,"Multifunction Printer",200]
[null,null,null,null,"Power back up",100]
[null,null,null,null,"Finger print scanner - One finger",200]
[null,null,null,null,"Finger print scanner - Slab scanner",1000,"Greenbit DactyScan84C "]
[null,null,null,null,"Iris scanner - one",300]
[null,null,null,null,"Iris scanner - two",1000,"I Scan 2 from Cross match"]
[null,null,null,null,"Signature pad",150]
[null,null,null,null,"GPS dongle",100]
[null,null,null,null,"Additional Screen",150]
[null,null,null,null,"Voice recording device",150]
[null,null,null,null,"Case for kit",200]
[null,null,null,null,"Annual operating expenditure per enrolment station",2500,"Cost of utilities  (electricity, water, internet), rent for space, maintenance of devices  and space etc. ","estimated based on experience"]
[null,null,null,null,"Enrolment station setup cost",0,"setup cost includes cabling cost, electricity fitting cost, furniture cost , banner cost, first aid kit etc. ","estimated based on experience"]
[null,null,null,null,"Cost per hour for outsourcing call center",14,"this include cost of agent, call center management and other call center related expenditures","based on industry report, subject to high variation as per location "]
[null,null,null,null,"Toll free no. annual cost ",50000,"cost of acquiring and managing toll free no. "]
[null,null,null,null,"Training modules cost ",500000,"Training modules will be required for training and capacity building activities for ID agency staff. This cost includes cost of video modules, pamphlets, assessment modules, information booklets, teacher's notes  etc. ","estimation based on various reports"]
[null,null,null,null,"Per batch training cost",2000,"cost for training batch of 15 people. This includes cost of space, equipment, stationary, snacks, tutor fee, certification and allowance to trainees ","estimation based on various reports"]
[null,null,null,null,"Enrolment client and server",650000,null,"industry experts"]
[null,null,null,null,"Data synchronization software ",50000,null,"industry experts"]
[null,null,null,null,"Data validation tool ",50000,null,"industry experts"]
[null,null,null,null,"CRM tool ",50000,null,"industry experts"]
[null,null,null,null,"Verification client and server",150000,null,"industry experts"]
[null,null,null,null,"Notification system ",25000,null,"industry experts"]
[null,null,null,null,"identity and access management system",50000,null,"industry experts"]
[null,null,null,null,"Portal",200000,null,"industry experts"]
[null,null,null,null,"Fraud detection system",50000,null,"industry experts"]
[null,null,null,null,"Report system ",25000,null,"industry experts"]
[null,null,null,null,"Cost per deduplication (For first biometric)",0.25,null,"industry experts"]
[null,null,null,null,"Add on dedup cost for additional biometric",0.1,null,"industry experts"]
[null,null,null,null,"Per person work station setup cost",1000,"cost of associated technical infrastructure i.e. laptop, landline, stationary etc. ","based on industry reports"]
[null,null,null,null,"Per sq. ft. office setup cost ",75,"cost of office setup","based on industry reports"]
[null,null,null,null,"Per person per year operating expenditure",300,"stationary, snacks etc.","based on industry reports"]
[null,null,null,null,"Per sq. ft. office operating expenditure",7,"Cost of electricity, internet, security, cleaning, admin etc. per year","based on industry reports"]
[null,null,null,null,"Office rent per sq. ft.",5,null,"Subject to high variation as per location"]
[null,null,null,null,"Cost of identity credential components "]
[null,null,null,null,"1D barcode",0.1,null,"industry experts"]
[null,null,null,null,"2D barcode",0.1,null,"industry experts"]
[null,null,null,null,{"$f":"'0.5 UI backend'!A3","v":"Contact Chip "},0.6,"type of chip ","industry experts"]
[null,null,null,null,{"$f":"'0.5 UI backend'!A4","v":"Contactless chip"},0.7,"type of chip ","industry experts"]
[null,null,null,null,{"$f":"'0.5 UI backend'!A5","v":"Dual interface chip "},0.8,"type of chip ","industry experts"]
[null,null,null,null,{"$f":"'0.5 UI backend'!A6","v":"Hybrid chip "},1.2,"type of chip ","industry experts"]
[null,null,null,null,"Mag strip ",0.5,null,"industry experts"]
[null,null,null,null,{"$f":"'0.5 UI backend'!A9","v":"Paper"},0.02,"Type of credential material ","industry experts"]
[null,null,null,null,{"$f":"'0.5 UI backend'!A10","v":"PVC"},0.2,"Type of credential material ","industry experts"]
[null,null,null,null,{"$f":"'0.5 UI backend'!A11","v":"PC"},0.6,"Type of credential material ","industry experts"]
[null,null,null,null,{"$f":"'0.5 UI backend'!A12","v":"PET"},0.4,"Type of credential material ","industry experts"]
[null,null,null,null,{"$f":"'0.5 UI backend'!A13","v":"Teslin "},0.9,"Type of credential material ","industry experts"]
[null,null,null,null,{"$f":"'0.5 UI backend'!A14","v":"Composite (PC+PVC)"},0.4,"Type of credential material ","industry experts"]
[null,null,null,null,"Thermal printing",0.15,null,"industry experts"]
[null,null,null,null,"Printing on PVC and equivalent",0.3,null,"industry experts"]
[null,null,null,null,"Printing on PVC and equivalent smart cards",0.6,null,"industry experts"]
[null,null,null,null,{"$f":"'0.5 UI backend'!A17","v":"Level 1 (overt)"},0.5,"Security feature","industry experts"]
[null,null,null,null,{"$f":"'0.5 UI backend'!A18","v":"Level 2 (covert)"},0.7,"Security feature","industry experts"]
[null,null,null,null,{"$f":"'0.5 UI backend'!A19","v":"Level 3 (forensic)"},0.9,"Security feature","industry experts"]
[null,null,null,null,"Credential Delivery Cost",0.1,"cost of delivering credential to resident","Subjected to high variation as per location"]
[null,null,null,null,"Data center site operating cost",500000,"Security, space, site management, maintenance, WAN etc.","Subjected to high variation as per location"]
[null,null,null,null,"Data center site installation cost",500000]
[null,null,null,null,"Web server cost",15000,"Dell PowerEdge R730, 16 core, 2U","industry experts"]
[null,null,null,null,"Application server cost",30000,"Dell PowerEdge R740, 16 core, 2U","industry experts"]
[null,null,null,null,"Database server cost",50000,"Dell PowerEdge R940, 16 core, 3U","industry experts"]
[null,null,null,null,"Disk array ",10000,"EMC VNX series , 10 TB","industry experts"]
[null,null,null,null,"Load balancer",20000,"Radware","industry experts"]
[null,null,null,null,"Unified threat management",30000,"Fortigate","industry experts"]
[null,null,null,null,"One time password hardware",100000,"Gemalto","industry experts"]
[null,null,null,null,"SAN switch",60000,"Brocade 6520,48 Port Fibre","industry experts"]
[null,null,null,null,"Core switch",10000,"NetApp FAS6200, 1.5 u","industry experts"]
[null,null,null,null,"Tape library",15000,"NetAPP","industry experts"]
[null,null,null,null,"NAS ",20000,"tandberg","industry experts"]
[null,null,null,null,"Middleware software and firewalls",400000,"e.g.. JBOSS","industry experts"]
[null,null,null,null,"Database software",100000,"e.g. Postgresql","industry experts"]
[null,null,null,null,"Biometric verification tool ",200000,"Custom developed","industry experts"]
[null,null,null,null,"demographic verification  tool ",50000,"Custom developed","industry experts"]
[null,null,null,null,"Caching software",100000,"e.g. MemCache","industry experts"]
[null,null,null,null,"Clustering software",100000,"e.g. Apache Mesos","industry experts"]
[null,null,null,null,"Replication software",100000,"e.g. Postgresql,Storage volume replication","industry experts"]
[null,null,null,null,"VM  software",100000,"e.g. VMWare","industry experts"]
[null,null,null,null,"Vehicle for Mobile enrolment ",200000,"e.g Jeep","market research"]

{"sheet":"0.4 All inputs","index":6,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["All inputs required by model"]
[]
[]
[]
["Enrolment Cost Estimation "]
["Current population ","Population growth rate","Birth rate","Current year","Eligible population ","Enrolment start year","Enrolment phase completion year","Target coverage during enrolment phase"]
[{"$f":"'0.7 UI input conversion'!B1","v":17094130},{"$f":"'0.7 UI input conversion'!B2","v":2.9300000000000003E-2},{"$f":"'0.7 UI input conversion'!B3","v":4.1500000000000002E-2},{"$f":"'0.6 UI Inputs'!C1","v":2018},{"$f":"'0.7 UI input conversion'!B23","v":0.7},{"$f":"'0.7 UI input conversion'!B7","v":2019},{"$f":"'0.7 UI input conversion'!B8","v":2021},{"$f":"'0.9 Default parameters'!B7","v":0.9}]
[]
[]
["Rural population ","Finger print required ?","no.of finger print","Iris required","no. of iris","Voice : Biometric (not)","Facial photograph (Biometric)","electronic signature","Demographic fields"]
[{"$f":"'0.7 UI input conversion'!B4","v":0.58619999999999994},{"$f":"'0.7 UI input conversion'!B12","v":1},{"$f":"'0.7 UI input conversion'!C12","v":10},{"$f":"'0.7 UI input conversion'!B13","v":0},{"$f":"'0.7 UI input conversion'!C13","v":0},{"$f":"'0.7 UI input conversion'!B11","v":0},{"$f":"'0.7 UI input conversion'!B9","v":1},{"$f":"'0.7 UI input conversion'!B10","v":0},{"$f":"'0.7 UI input conversion'!B14","v":0}]
[]
[]
["Working hours per day ","Working days per year","Fixed enrolment station working efficiency","mobile enrolment station working efficiency ","% of rural population require mobile enrolment center","Mandatory biometric update required ","Average inflation rate ","Per capita income"]
[{"$f":"'0.9 Default parameters'!C7","v":8},{"$f":"'0.9 Default parameters'!D7","v":250},{"$f":"'0.9 Default parameters'!E7","v":0.7},{"$f":"'0.9 Default parameters'!F7","v":0.5},{"$f":"'0.9 Default parameters'!G7","v":0.2},{"$f":"'0.9 Default parameters'!H7","v":1},{"$f":"'0.9 Default parameters'!D12","v":1.7999999999999999E-2},{"$f":"'0.7 UI input conversion'!B5","v":4000}]
[null,null,null,null,null,"if upon turning to certain age residents are required to update their biometric data then 1 else 0 ",null,"as on 2011, US $ PPP"]
[]
["Human Resources Cost Estimation "]
["no. of employee at each enrolment station ","No. of Regional offices required","No. of district office required","Hiring cost "]
[{"$f":"'0.9 Default parameters'!B12","v":2},{"$f":"'0.7 UI input conversion'!B24","v":20},{"$f":"'0.7 UI input conversion'!B25","v":765},{"$f":"'0.9 Default parameters'!C12","v":0.05}]
[null,null,null,"% of total annual compensation "]
[]
["Helpdesk, IEC , Training and Capacity building Cost estimation "]
["% of people require helpdesk ","out of these people, % of people registering / resolving complain through call center","% of people registering / resolving complain through visit to enrolment station ","no. of operators that will be trained ","Total no. of service provider agencies","Per agency no. of operators who require training","Per person IEC expenditure during enrolment phase"]
[{"$f":"'0.9 Default parameters'!B17","v":0.05},{"$f":"'0.9 Default parameters'!C17","v":0.3},{"$f":"'0.9 Default parameters'!D17","v":0.5},{"$f":"'0.9 Default parameters'!E17","v":1.25},{"$f":"'0.9 Default parameters'!F17","v":100},{"$f":"'0.9 Default parameters'!G17","v":5},{"$f":"'0.9 Default parameters'!H17","v":0.5}]
[null,null,null,"% of actual required staff"]
[]
["Software cost estimation "]
["Software AMC cost","Request require manual deduplication ","Per manual dedup time (in minutes)","Per manual quality check time (in minutes)"]
[{"$f":"'0.9 Default parameters'!B22","v":0.25},{"$f":"'0.9 Default parameters'!C22","v":0.05},{"$f":"'0.9 Default parameters'!D22","v":10},{"$f":"'0.9 Default parameters'!E22","v":5}]
["as percentage of cost of software development","out of all the deduplication request, these many requests will require manual checking"]
[]
["Facility cost estimation"]
["HQ office space requirement","Regional office space requirement","District office space requirement"]
[{"$f":"'0.9 Default parameters'!B27","v":15000},{"$f":"'0.9 Default parameters'!C27","v":5000},{"$f":"'0.9 Default parameters'!D27","v":1000}]
["sq. ft.","sq. ft.","sq. ft."]
[]
["Credential "]
["Credential Choice ","Type of Barcode ","Type of chip based card","Mag strip ","Type of Material ","Type of security ","ID to be reissued"]
[{"$f":"'0.7 UI input conversion'!B15","v":1},{"$f":"'0.7 UI input conversion'!B20","v":2},{"$f":"'0.7 UI input conversion'!B16","v":4},{"$f":"'0.7 UI input conversion'!B19","v":1},{"$f":"'0.7 UI input conversion'!B17","v":3},{"$f":"'0.7 UI input conversion'!B18","v":3},{"$f":"'0.9 Default parameters'!B32","v":0.03}]
["0 = No credential only UIN, 1 = eID, 2 = non electronic ID","0 = no barcode, 1= 1D barcode, 2 = 2D barcode","0 = no chip, 1 = contact, 2 = contactless, 3 = Dual interface, 4 = hybrid","0 = no, 1 = yes","0 = no material, 1 = paper, 2= PVC, 3 = PC, 4 = PET, 5 = Teslin, 6 = Composite (PC+PVC)","0 = no security, 1 = level 1, 2 = level 2, 3 = level 3","Due to lost or damage"]
[]
["Data Center Cost Estimation "]
["per agency per person per year authentication requests","Preferred biometric for authentication","Preferred biometric for deduplication ","Per person raw data size","Per person minutiae size","Capacity of DR as compared to DC","Storage disk minimum size "]
[{"$f":"'0.9 Default parameters'!B37","v":0.2},{"$f":"'0.9 Default parameters'!C37","v":1},{"$f":"'0.9 Default parameters'!D37","v":1},{"$f":"'0.9 Default parameters'!E37","v":4000},{"$f":"'0.9 Default parameters'!F37","v":150},{"$f":"'0.9 Default parameters'!G37","v":1},{"$f":"'0.9 Default parameters'!H37","v":10}]
["used to estimate the authentication volume","0 = no biometric authentication, 1 = finger prints,  2= Iris, 3 = Voice, 4 = face","1 = finger prints,  2= Iris, 3 = Voice, 4 = face","in KB (including data update requests)","in KB",null,"in TB"]
[]
["No . of core in webserver ","no. of core in database server","no. of core in application server","Hardware AMC ","Web server capacity (no. of request per second per core)","Application server capacity (no. of requests per core per second)","Data base server capacity (no. of request per core per second)"]
[{"$f":"'0.9 Default parameters'!B41","v":16},{"$f":"'0.9 Default parameters'!C41","v":16},{"$f":"'0.9 Default parameters'!D41","v":16},{"$f":"'0.9 Default parameters'!E41","v":0.15},{"$f":"'0.9 Default parameters'!F41","v":3000},{"$f":"'0.9 Default parameters'!G41","v":100},{"$f":"'0.9 Default parameters'!H41","v":300}]
[null,null,null,"as % of total cost of hardware",null,"1 request is equivalent to one finger print authentication request"]
[]
["Finger print deduplication matches per core per second","Iris deduplication matches per core per second","Face deduplication matches per core per second","Voice deduplication per core per second"]
[{"$f":"'0.9 Default parameters'!B45","v":37500},{"$f":"'0.9 Default parameters'!C45","v":2500},{"$f":"'0.9 Default parameters'!D45","v":1250},{"$f":"'0.9 Default parameters'!E45","v":1250}]
["for two finger biometric deduplication "]
[]
["Linkages with Civil registration department"]
["Shared infrastructure ","Shared Human Resources","Reduction in infrastructure cost due to shared infra ","Reduction in human resources cost due to share human resources"]
[{"$f":"'0.7 UI input conversion'!C22","v":0},{"$f":"'0.7 UI input conversion'!B22","v":0},{"$f":"'0.9 Default parameters'!B50","v":0.3},{"$f":"'0.9 Default parameters'!C50","v":0.3}]
["yes=1 , no = 0 ","yes=1 , no = 0 "]

{"sheet":"0.5 UI backend","index":7,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
["Type of chip ",null,null,"Linkages with Civil Registration Department"]
["Contact Chip ",null,null,"No linkages with CR department"]
["Contactless chip",null,null,"Only infrastructure is shared"]
["Dual interface chip ",null,null,"Only Human Resources is shared"]
["Hybrid chip ",null,null,"Both infra and Human Resources are shared"]
[]
["Material ",null,null,"No credential, only UIN is provided "]
["Paper",null,null,"Smart card"]
["PVC",null,null,"Non electronic card"]
["PC"]
["PET"]
["Teslin "]
["Composite (PC+PVC)"]
[]
["Security "]
["Level 1 (overt)"]
["Level 2 (covert)"]
["Level 3 (forensic)"]
[]
["Mag strip "]
["Yes"]
["No"]
[]
["Barcode"]
["No barcode"]
["1D barcode"]
["2D barcode"]
[]
["True /False"]
[true]
[false]

{"sheet":"0.6 UI Inputs","index":8,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Q. What is the population of country ?",17094130,2018]
["Q. What is the average population growth rate ?",2.93]
["Q. What is the average birth rate ?",4.1500000000000004]
["Q. What percentage of the population is rural population ?",58.62]
["Q. What is the gross national income (GNI) per capita of the country ? ",4000]
[]
["Q. In which year enrolments will start ?",2019]
["Q. By which year 90% of the eligible population should be enrolled ?",2021]
["Facial Photograph",true]
["Electronic signature",false]
["Voice",false]
["Finger prints",true,10]
["Iris",false]
["Q. How many demographic data points will be captured during enrolment ?",10]
["Please select the type of identity credential to be issued ?","Smart card"]
["Q. Type of chip based to be used ?","Hybrid chip "]
["Q. Card material to be used ?","PC"]
["Q. Level of security in the credential ","Level 3 (forensic)"]
["Q. Will the card include mag strip ?","Yes"]
["Q. Will the card include bar code ?","2D barcode"]
["Is CR department is linked with ID agency ?","No linkages with CR department"]
["Q. What percentage of population is eligible for national identity ?",70]
["Number of regional / province level offices ?",20]
["Number of district / municipality level offices ?",765]

{"sheet":"0.7 UI input conversion","index":9,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Q. What is the population of country ?",{"$f":"'0.6 UI Inputs'!B1","v":17094130},{"$f":"'0.6 UI Inputs'!C1","v":2018}]
["Q. What is the average population growth rate ?",{"$f":"'0.6 UI Inputs'!B2/100","v":2.9300000000000003E-2}]
["Q. What is the average birth rate ?",{"$f":"'0.6 UI Inputs'!B3/100","v":4.1500000000000002E-2}]
["Q. What percentage of the population is rural population ?",{"$f":"'0.6 UI Inputs'!B4/100","v":0.58619999999999994}]
["Q. What is the gross national income (GNI) per of the country ? ",{"$f":"'0.6 UI Inputs'!B5","v":4000}]
["Q. What is the average annual consumer price inflation ?",{"$f":"'0.6 UI Inputs'!B6/100","v":0}]
["Q. In which year enrolments will start ?",{"$f":"'0.6 UI Inputs'!B7","v":2019}]
["Q. By which year 90% of the eligible population should be enrolled ?",{"$f":"'0.6 UI Inputs'!B8","v":2021}]
["Facial Photograph",{"$f":"'0.6 UI Inputs'!B9*1","v":1}]
["Electronic signature",{"$f":"'0.6 UI Inputs'!B10*1","v":0}]
["Voice",{"$f":"'0.6 UI Inputs'!B11*1","v":0}]
["Finger prints",{"$f":"'0.6 UI Inputs'!B12*1","v":1},{"$f":"'0.6 UI Inputs'!C12*1","v":10}]
["Iris",{"$f":"'0.6 UI Inputs'!B13*1","v":0},{"$f":"'0.6 UI Inputs'!C13*1","v":0}]
["Q. How many demographic data points will be captured during enrolment ?",0]
["Please select the type of identity credential to be issued ?",{"$f":"IF('0.6 UI Inputs'!B15='0.5 UI backend'!D8,0,IF('0.6 UI Inputs'!B15='0.5 UI backend'!D9,1,IF('0.6 UI Inputs'!B15='0.5 UI backend'!D10,2,0)))","v":1}]
["Q. Type of chip based to be used ?",{"$f":"IF('0.6 UI Inputs'!B16='0.5 UI backend'!A3,1,IF('0.6 UI Inputs'!B16='0.5 UI backend'!A4,2,IF('0.6 UI Inputs'!B16='0.5 UI backend'!A5,3,IF('0.6 UI Inputs'!B16='0.5 UI backend'!A6,4,0))))","v":4}]
["Q. Card material to be used ?",{"$f":"IF('0.6 UI Inputs'!B17='0.5 UI backend'!A9,1,IF('0.6 UI Inputs'!B17='0.5 UI backend'!A10,2,IF('0.6 UI Inputs'!B17='0.5 UI backend'!A11,3,IF('0.6 UI Inputs'!B17='0.5 UI backend'!A12,4,IF('0.6 UI Inputs'!B17='0.5 UI backend'!A13,5,IF('0.6 UI Inputs'!B17='0.5 UI backend'!A14,6,0))))))","v":3}]
["Q. Level of security in the credential ",{"$f":"IF('0.6 UI Inputs'!B18='0.5 UI backend'!A17,1,IF('0.6 UI Inputs'!B18='0.5 UI backend'!A18,2,IF('0.6 UI Inputs'!B18='0.5 UI backend'!A19,3,0)))","v":3}]
["Q. Will the card include mag strip ?",{"$f":"IF('0.6 UI Inputs'!B19='0.5 UI backend'!A22,1,0)","v":1}]
["Q. Will the card include bar code ?",{"$f":"IF('0.6 UI Inputs'!B20='0.5 UI backend'!A26,0,IF('0.6 UI Inputs'!B20='0.5 UI backend'!A27,1,IF('0.6 UI Inputs'!B20='0.5 UI backend'!A28,2,0)))","v":2}]
[null,"Human Resources","Infra"]
["Is CRVS department is linked with ID agency ? ",{"$f":"IF(OR('0.6 UI Inputs'!B21='0.5 UI backend'!D5,'0.6 UI Inputs'!B21='0.5 UI backend'!D6),1,0)","v":0},{"$f":"IF(OR('0.6 UI Inputs'!B21='0.5 UI backend'!D4,'0.6 UI Inputs'!B21='0.5 UI backend'!D6),1,0)","v":0}]
["Q. What percentage of population is eligible for national identity ?",{"$f":"'0.6 UI Inputs'!B22/100","v":0.7}]
["Number of regional / province level offices ?",{"$f":"'0.6 UI Inputs'!B23","v":20}]
["Number of district / municipality level offices ?",{"$f":"'0.6 UI Inputs'!B24","v":765}]

{"sheet":"0.8 Assumptions","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"0.9 Default parameters","index":11,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["Default Parameters "]
[]
[]
[]
["Enrolment Cost Estimation "]
["Parameter","Target coverage during enrolment phase","Working hours per day ","Working days per year","Fixed enrolment station working efficiency","mobile enrolment station working efficiency ","% of rural population require mobile enrolment center","Mandatory biometric update required "]
["Value ",0.9,8,250,0.7,0.5,0.2,1]
["Description ","% of eligible population to be covered during enrolment phase",null,null,null,null,"this much % of rural population will require mobile enrolment stations. Kindly note that this is % of rural population not entire population","if upon turning to certain age residents are required to update their biometric data then 1 else 0 "]
[]
["Human Resources Cost Estimation "]
["Parameter","no. of employee at each enrolment station ","Hiring cost ","Inflation "]
["Value ",2,0.05,1.7999999999999999E-2]
["Description ","operator and verifier ","% of total annual compensation ","Average inflation for US $"]
[]
["Human Resources Cost Estimation "]
["Parameter","% of people require helpdesk ","out of these people, % of people registering / resolving complain through call center","% of people registering / resolving complain through visit to enrolment station ","no. of operators that will be trained ","Total no. of service provider agencies","Per agency no. of operators who require training","Per person IEC expenditure during enrolment phase"]
["Value ",0.05,0.3,0.5,1.25,100,5,0.5]
["Description ","out of total enrolled population these many people will require helpdesk for issue resolution each year",null,"rest of the people will use online portal for issue resolution ","higher no. of people will be trained for enrolment",null,null,"per person expenditure for IEC campaigns for whole enrolment period. During steady state this amount is reduced to 25% "]
[]
["Software"]
["Parameter","Software AMC cost","Request require manual deduplication ","Per manual dedup time (in minutes)","Time taken per quality check "]
["Value ",0.25,0.05,10,5]
["Description ","as percentage of cost of software development","out of all the deduplication request, these many requests will require manual checking",null,"Min "]
[]
["Facility cost estimation "]
["Parameter","HQ office space requirement","Regional office space requirement","District office space requirement"]
["Value ",15000,5000,1000]
["Description ","sq. ft.","sq. ft.","sq. ft."]
[]
["Facility cost estimation "]
["Parameter","ID to be reissued"]
["Value ",0.03]
["Description ","Due to lost or damage"]
[]
["Central IT"]
["Parameter","per agency per person per year authentication requests","Preferred biometric for authentication","Preferred biometric for deduplication ","Per person raw data size","Per person minutiae size","Capacity of DR as compared to DC","Storage disk minimum size "]
["Value ",0.2,1,1,4000,150,1,10]
["Description ","used to estimate the authentication volume","0 = no biometric authentication, 1 = finger prints,  2= Iris, 3 = Voice, 4 = face","1 = finger prints,  2= Iris, 3 = Voice, 4 = face","in KB (including data update requests)","in KB",null,"in tb"]
[]
["Parameter","No . of core in webserver ","no. of core in database server","no. of core in application server","Hardware AMC ","Web server capacity (no. of request per second per core)","Application server capacity (no. of requests per core per second)","Data base server capacity (no. of request per core per second)"]
["Value ",16,16,16,0.15,3000,100,300]
["Description ",null,null,null,"as % of total cost of hardware",null,"1 request is equivalent to one finger print authentication request"]
[]
["Parameter","Finger print deduplication matches per core per second","Iris deduplication matches per core per second","Face deduplication matches per core per second","Voice deduplication per core per second"]
["Value ",37500,2500,1250,1250]
["Description ","for two finger biometric deduplication "]
[]
["CRVS linkages"]
["Parameter","Reduction in infrastructure cost due to shared infra ","Reduction in Human Resources cost due to shared human resource"]
["Value ",0.3,0.3]
["Description ","IF CRVS and ID agency are sharing infrastructure, then infra structure will be reduced by this %","IF CRVS and ID agency are sharing HR then infra structure will be reduced by this %"]

{"sheet":"1. Enrolment","index":12,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":true,"merged":[[12,0,16,0],[18,0,25,0],[30,0,37,0],[40,0,45,0]]}
["1. Enrolment Station Cost Estimation"]
[]
["Component","Current population ","Population growth rate","Birth rate","Current year","Eligible population ","Enrolment start year","Enrolment phase completion year","Target coverage during enrolment phase","Rural population ","Finger print required ?","no.of finger print","Iris required","no. of iris","Voice : Biometric","Facial photograph","electronic signature","no. of demographic points"]
["Value",{"$f":"'0.4 All inputs'!A7","v":17094130},{"$f":"'0.4 All inputs'!B7","v":2.9300000000000003E-2},{"$f":"'0.4 All inputs'!C7","v":4.1500000000000002E-2},{"$f":"'0.4 All inputs'!D7","v":2018},{"$f":"'0.4 All inputs'!E7","v":0.7},{"$f":"'0.4 All inputs'!F7","v":2019},{"$f":"'0.4 All inputs'!G7","v":2021},{"$f":"'0.4 All inputs'!H7","v":0.9},{"$f":"'0.4 All inputs'!A11","v":0.58619999999999994},{"$f":"'0.4 All inputs'!B11","v":1},{"$f":"'0.4 All inputs'!C11","v":10},{"$f":"'0.4 All inputs'!D11","v":0},{"$f":"'0.4 All inputs'!E11","v":0},{"$f":"'0.4 All inputs'!F11","v":0},{"$f":"'0.4 All inputs'!G11","v":1},{"$f":"'0.4 All inputs'!H11","v":0},{"$f":"'0.4 All inputs'!I11","v":0}]
["Description "]
[]
["Component","Working hours per day ","Working days per year","Fixed enrolment station working efficiency","mobile enrolment station working efficiency ","% of rural population require mobile enrolment center","enrolment time (in minutes) ","Mandatory biometric update required ","Cost of one enrolment kit ","Annual operating expenditure per enrolment station (without human resources)","one enrolment station setup cost (apart from kit )"]
["Value",{"$f":"'0.4 All inputs'!A15","v":8},{"$f":"'0.4 All inputs'!B15","v":250},{"$f":"'0.4 All inputs'!C15","v":0.7},{"$f":"'0.4 All inputs'!D15","v":0.5},{"$f":"'0.4 All inputs'!E15","v":0.2},{"$f":"'1.1 Backend'!D71","v":7.6},{"$f":"'0.4 All inputs'!F15","v":1},{"$f":"'1.1 Backend'!D88","v":3050},{"$f":"'0.2 Unit cost  assumptions'!F21","v":2500},{"$f":"'0.2 Unit cost  assumptions'!F22","v":0}]
["Description "]
[]
[]
[null,null,null,"Development  year"]
["General","S.n.",null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,"year",null,{"$f":"start_year+D13-1","v":2018},2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
[null,"No. of enrolment in a year at one fixed enrolment station ",null,{"$f":"(Work_days*work_hour*Fixed_efficiency*60)/enrol_time","v":11052.631578947368},11052.631578947368,11052.631578947368,11052.631578947368,11052.631578947368,11052.631578947368,11052.631578947368,11052.631578947368,11052.631578947368,11052.631578947368,11052.631578947368,11052.631578947368,11052.631578947368,11052.631578947368,11052.631578947368,11052.631578947368]
[null,"No. of enrolment in a year at one mobile enrolment station ",null,{"$f":"(Work_days*work_hour*mobile_efficiency*60)/enrol_time","v":7894.7368421052633},7894.7368421052633,7894.7368421052633,7894.7368421052633,7894.7368421052633,7894.7368421052633,7894.7368421052633,7894.7368421052633,7894.7368421052633,7894.7368421052633,7894.7368421052633,7894.7368421052633,7894.7368421052633,7894.7368421052633,7894.7368421052633,7894.7368421052633]
[null,"Phase","0 development year, 1  enrolment phase and 2 steady state",{"$f":"IF(D14<start_year,0,IF(D14>completion_year,2,1))","v":0},1,1,1,2,2,2,2,2,2,2,2,2,2,2,2]
[]
["Enrolment phase and steady phase","Eligible population for enrolment ",null,{"$f":"INDEX('1.1 Backend'!$C$15:$AA$15,,MATCH('1. Enrolment'!D14,'1.1 Backend'!$C$12:$AA$12,0))","v":11965891},{"$f":"INDEX('1.1 Backend'!$C$15:$AA$15,,MATCH('1. Enrolment'!E14,'1.1 Backend'!$C$12:$AA$12,0))","v":12316491.606300002},{"$f":"INDEX('1.1 Backend'!$C$15:$AA$15,,MATCH('1. Enrolment'!F14,'1.1 Backend'!$C$12:$AA$12,0))","v":12677364.810364591},{"$f":"INDEX('1.1 Backend'!$C$15:$AA$15,,MATCH('1. Enrolment'!G14,'1.1 Backend'!$C$12:$AA$12,0))","v":13048811.599308275},{"$f":"INDEX('1.1 Backend'!$C$15:$AA$15,,MATCH('1. Enrolment'!H14,'1.1 Backend'!$C$12:$AA$12,0))","v":13431141.779168008},{"$f":"INDEX('1.1 Backend'!$C$15:$AA$15,,MATCH('1. Enrolment'!I14,'1.1 Backend'!$C$12:$AA$12,0))","v":13824674.233297633},{"$f":"INDEX('1.1 Backend'!$C$15:$AA$15,,MATCH('1. Enrolment'!J14,'1.1 Backend'!$C$12:$AA$12,0))","v":14229737.188333252},{"$f":"INDEX('1.1 Backend'!$C$15:$AA$15,,MATCH('1. Enrolment'!K14,'1.1 Backend'!$C$12:$AA$12,0))","v":14646668.487951418},{"$f":"INDEX('1.1 Backend'!$C$15:$AA$15,,MATCH('1. Enrolment'!L14,'1.1 Backend'!$C$12:$AA$12,0))","v":15075815.874648396},{"$f":"INDEX('1.1 Backend'!$C$15:$AA$15,,MATCH('1. Enrolment'!M14,'1.1 Backend'!$C$12:$AA$12,0))","v":15517537.279775595},{"$f":"INDEX('1.1 Backend'!$C$15:$AA$15,,MATCH('1. Enrolment'!N14,'1.1 Backend'!$C$12:$AA$12,0))","v":15972201.122073023},{"$f":"INDEX('1.1 Backend'!$C$15:$AA$15,,MATCH('1. Enrolment'!O14,'1.1 Backend'!$C$12:$AA$12,0))","v":16440186.614949761},{"$f":"INDEX('1.1 Backend'!$C$15:$AA$15,,MATCH('1. Enrolment'!P14,'1.1 Backend'!$C$12:$AA$12,0))","v":16921884.082767792},{"$f":"INDEX('1.1 Backend'!$C$15:$AA$15,,MATCH('1. Enrolment'!Q14,'1.1 Backend'!$C$12:$AA$12,0))","v":17417695.28639289},{"$f":"INDEX('1.1 Backend'!$C$15:$AA$15,,MATCH('1. Enrolment'!R14,'1.1 Backend'!$C$12:$AA$12,0))","v":17928033.7582842},{"$f":"INDEX('1.1 Backend'!$C$15:$AA$15,,MATCH('1. Enrolment'!S14,'1.1 Backend'!$C$12:$AA$12,0))","v":18453325.147401929}]
[null,"Registration phase population distribution ",null,0,{"$f":"IF(E17=1,'1.1 Backend'!C29,0)","v":0.24666175715507732},{"$f":"IF(F17=1,'1.1 Backend'!D29,0)","v":0.40667648568984549},{"$f":"IF(G17=1,'1.1 Backend'!E29,0)","v":0.24666175715507732},{"$f":"IF(H17=1,'1.1 Backend'!F29,0)","v":0},{"$f":"IF(I17=1,'1.1 Backend'!G29,0)","v":0},{"$f":"IF(J17=1,'1.1 Backend'!H29,0)","v":0},{"$f":"IF(K17=1,'1.1 Backend'!I29,0)","v":0},{"$f":"IF(L17=1,'1.1 Backend'!J29,0)","v":0},{"$f":"IF(M17=1,'1.1 Backend'!K29,0)","v":0},{"$f":"IF(N17=1,'1.1 Backend'!L29,0)","v":0},{"$f":"IF(O17=1,'1.1 Backend'!M29,0)","v":0},{"$f":"IF(P17=1,'1.1 Backend'!N29,0)","v":0},{"$f":"IF(Q17=1,'1.1 Backend'!O29,0)","v":0},{"$f":"IF(R17=1,'1.1 Backend'!P29,0)","v":0},{"$f":"IF(S17=1,'1.1 Backend'!Q29,0)","v":0}]
[null,"population to enrol during enrolment phase",null,{"$f":"D20*D19","v":0},{"$f":"E20*E19","v":3038007.4615957192},5155586.1688871868,3218642.7978709335,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"annual births (new enrolments required)","at steady state new enrolments will be equal to new births",{"$f":"INDEX('1.1 Backend'!$C$14:$AA$14,,MATCH('1. Enrolment'!D14,'1.1 Backend'!$C$12:$AA$12,0))","v":709406.39500000002},{"$f":"INDEX('1.1 Backend'!$C$14:$AA$14,,MATCH('1. Enrolment'!E14,'1.1 Backend'!$C$12:$AA$12,0))","v":730192.00237350015},{"$f":"INDEX('1.1 Backend'!$C$14:$AA$14,,MATCH('1. Enrolment'!F14,'1.1 Backend'!$C$12:$AA$12,0))","v":751586.62804304366},{"$f":"INDEX('1.1 Backend'!$C$14:$AA$14,,MATCH('1. Enrolment'!G14,'1.1 Backend'!$C$12:$AA$12,0))","v":773608.11624470493},{"$f":"INDEX('1.1 Backend'!$C$14:$AA$14,,MATCH('1. Enrolment'!H14,'1.1 Backend'!$C$12:$AA$12,0))","v":796274.83405067481},{"$f":"INDEX('1.1 Backend'!$C$14:$AA$14,,MATCH('1. Enrolment'!I14,'1.1 Backend'!$C$12:$AA$12,0))","v":819605.68668835983},{"$f":"INDEX('1.1 Backend'!$C$14:$AA$14,,MATCH('1. Enrolment'!J14,'1.1 Backend'!$C$12:$AA$12,0))","v":843620.13330832857},{"$f":"INDEX('1.1 Backend'!$C$14:$AA$14,,MATCH('1. Enrolment'!K14,'1.1 Backend'!$C$12:$AA$12,0))","v":868338.20321426273},{"$f":"INDEX('1.1 Backend'!$C$14:$AA$14,,MATCH('1. Enrolment'!L14,'1.1 Backend'!$C$12:$AA$12,0))","v":893780.51256844075},{"$f":"INDEX('1.1 Backend'!$C$14:$AA$14,,MATCH('1. Enrolment'!M14,'1.1 Backend'!$C$12:$AA$12,0))","v":919968.28158669604},{"$f":"INDEX('1.1 Backend'!$C$14:$AA$14,,MATCH('1. Enrolment'!N14,'1.1 Backend'!$C$12:$AA$12,0))","v":946923.35223718639},{"$f":"INDEX('1.1 Backend'!$C$14:$AA$14,,MATCH('1. Enrolment'!O14,'1.1 Backend'!$C$12:$AA$12,0))","v":974668.20645773597},{"$f":"INDEX('1.1 Backend'!$C$14:$AA$14,,MATCH('1. Enrolment'!P14,'1.1 Backend'!$C$12:$AA$12,0))","v":1003225.9849069478},{"$f":"INDEX('1.1 Backend'!$C$14:$AA$14,,MATCH('1. Enrolment'!Q14,'1.1 Backend'!$C$12:$AA$12,0))","v":1032620.5062647214},{"$f":"INDEX('1.1 Backend'!$C$14:$AA$14,,MATCH('1. Enrolment'!R14,'1.1 Backend'!$C$12:$AA$12,0))","v":1062876.2870982778},{"$f":"INDEX('1.1 Backend'!$C$14:$AA$14,,MATCH('1. Enrolment'!S14,'1.1 Backend'!$C$12:$AA$12,0))","v":1094018.5623102575}]
[null,"Population distribution during steady state",null,0,{"$f":"IF(E17=2,$I$4,0)","v":0},{"$f":"IF(F17=2,$I$4,0)","v":0},0,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9]
[null,"Population to enrol during steady state",null,{"$f":"D23*D22","v":0},{"$f":"E23*E22","v":0},0,0,716647.35064560734,737645.11801952391,759258.11997749575,781504.38289283647,804402.46131159668,827971.45342802641,852231.01701346773,877201.38581196242,902903.38641625305,929358.45563824929,956588.65838845004,984616.70607923169]
[null,"Yearly population to enrol ",null,{"$f":"D24+D21","v":0},{"$f":"E24+E21","v":3038007.4615957192},5155586.1688871868,3218642.7978709335,716647.35064560734,737645.11801952391,759258.11997749575,781504.38289283647,804402.46131159668,827971.45342802641,852231.01701346773,877201.38581196242,902903.38641625305,929358.45563824929,956588.65838845004,984616.70607923169]
[null,"Cumulative new enrolments ","Population covered with ID",{"$f":"SUM(D25:$D$25)","v":0},{"$f":"SUM($D25:E$25)","v":3038007.4615957192},{"$f":"SUM($D25:F$25)","v":8193593.6304829065},{"$f":"SUM($D25:G$25)","v":11412236.42835384},{"$f":"SUM($D25:H$25)","v":12128883.778999448},{"$f":"SUM($D25:I$25)","v":12866528.897018971},{"$f":"SUM($D25:J$25)","v":13625787.016996467},{"$f":"SUM($D25:K$25)","v":14407291.399889303},{"$f":"SUM($D25:L$25)","v":15211693.861200901},{"$f":"SUM($D25:M$25)","v":16039665.314628927},{"$f":"SUM($D25:N$25)","v":16891896.331642393},{"$f":"SUM($D25:O$25)","v":17769097.717454355},{"$f":"SUM($D25:P$25)","v":18672001.103870608},{"$f":"SUM($D25:Q$25)","v":19601359.559508856},{"$f":"SUM($D25:R$25)","v":20557948.217897307},{"$f":"SUM($D25:S$25)","v":21542564.923976541}]
[]
["Mandatory updates ","Annual requests for mandatory updates",null,0,0,{"$f":"IF($H$8=1,F22,0)","v":751586.62804304366},{"$f":"IF($H$8=1,G22,0)","v":773608.11624470493},796274.83405067481,819605.68668835983,843620.13330832857,868338.20321426273,893780.51256844075,919968.28158669604,946923.35223718639,974668.20645773597,1003225.9849069478,1032620.5062647214,1062876.2870982778,1094018.5623102575]
["helpdesk requests ","Annual requests at enrolment station",null,{"$f":"'3. Helpdesk,IEC and T&CB'!D17","v":0},{"$f":"'3. Helpdesk,IEC and T&CB'!E17","v":30380.074615957194},{"$f":"'3. Helpdesk,IEC and T&CB'!F17","v":81935.936304829069},{"$f":"'3. Helpdesk,IEC and T&CB'!G17","v":114122.36428353841},{"$f":"'3. Helpdesk,IEC and T&CB'!H17","v":121288.83778999448},{"$f":"'3. Helpdesk,IEC and T&CB'!I17","v":128665.28897018971},{"$f":"'3. Helpdesk,IEC and T&CB'!J17","v":136257.87016996468},{"$f":"'3. Helpdesk,IEC and T&CB'!K17","v":144072.91399889303},{"$f":"'3. Helpdesk,IEC and T&CB'!L17","v":152116.93861200902},{"$f":"'3. Helpdesk,IEC and T&CB'!M17","v":160396.65314628926},{"$f":"'3. Helpdesk,IEC and T&CB'!N17","v":168918.96331642393},{"$f":"'3. Helpdesk,IEC and T&CB'!O17","v":177690.97717454354},{"$f":"'3. Helpdesk,IEC and T&CB'!P17","v":186720.01103870608},{"$f":"'3. Helpdesk,IEC and T&CB'!Q17","v":196013.59559508855},{"$f":"'3. Helpdesk,IEC and T&CB'!R17","v":205579.48217897306},{"$f":"'3. Helpdesk,IEC and T&CB'!S17","v":215425.64923976542}]
[]
["Overall","Total enrolments, update and helpdesk request",null,{"$f":"D29+D28+D25","v":0},{"$f":"E29+E28+E25","v":3068387.5362116764},5989108.7332350593,4106373.2783991769,1634211.0224862765,1685916.0936780735,1739136.1234557889,1793915.5001059922,1850299.9124920466,1908336.3881610115,1968073.3325670781,2029560.5694442419,2092849.382361907,2157992.5574980592,2225044.4276657011,2294060.9176292545]
[null,"Handled by mobile stations ",null,{"$f":"D31*$J$4*$F$8","v":0},{"$f":"E31*$J$4*$F$8","v":359737.75474545691},702163.10788447829,481431.20315951947,191594.90027629107,197656.80282281735,203896.31911395668,210318.65323242653,216929.16174056754,223733.358147997,230736.9175101642,237945.68116164292,245365.66158810994,253003.04744107244,260864.20869952679,268955.70198285382]
[null,"handled by fixed stations ",null,{"$f":"D31-D32","v":0},{"$f":"E31-E32","v":2708649.7814662196},5286945.6253505815,3624942.0752396574,1442616.1222099853,1488259.2908552561,1535239.8043418322,1583596.8468735656,1633370.7507514791,1684603.0300130146,1737336.4150569139,1791614.8882825989,1847483.720773797,1904989.5100569867,1964180.2189661744,{"$f":"S31-S32","v":2025105.2156464006}]
[null,"no. of fixed stations required","assuming time for other activities is equal to enrolment time, if no. of required enrolment stations are less then district offices, then district office no. is taken to ensure miminum one enrolment station per district",{"$f":"(D33/D15)","v":0},{"$f":"MAX(E33/E15,'2. human resource'!$D$4)","v":765},{"$f":"MAX(F33/F15,'2. human resource'!$D$4)","v":765},{"$f":"MAX(G33/G15,'2. human resource'!$D$4)","v":765},{"$f":"MAX(H33/H15,'2. human resource'!$D$4)","v":765},{"$f":"MAX(I33/I15,'2. human resource'!$D$4)","v":765},{"$f":"MAX(J33/J15,'2. human resource'!$D$4)","v":765},{"$f":"MAX(K33/K15,'2. human resource'!$D$4)","v":765},{"$f":"MAX(L33/L15,'2. human resource'!$D$4)","v":765},{"$f":"MAX(M33/M15,'2. human resource'!$D$4)","v":765},{"$f":"MAX(N33/N15,'2. human resource'!$D$4)","v":765},{"$f":"MAX(O33/O15,'2. human resource'!$D$4)","v":765},{"$f":"MAX(P33/P15,'2. human resource'!$D$4)","v":765},{"$f":"MAX(Q33/Q15,'2. human resource'!$D$4)","v":765},{"$f":"MAX(R33/R15,'2. human resource'!$D$4)","v":765},{"$f":"MAX(S33/S15,'2. human resource'!$D$4)","v":765}]
[null,"no. of mobile stations required","different formula in first cells",{"$f":"D32/D16","v":0},{"$f":"E32/E16","v":45.566782267757873},88.940660332033914,60.981285733539131,24.268687368330202,25.036528357556865,25.826867087767845,26.640362742774027,27.477693820471888,28.339558698746288,29.226676217954132,30.13978628047477,31.079650467827257,32.047052675869175,33.042799768606727,34.067722251161484]
[null,"Enrolment kits required each year",null,{"$f":"ROUNDUP(D35+D34,0)","v":0},{"$f":"ROUNDUP(E35+E34,0)","v":811},854,826,790,791,791,792,793,794,795,796,797,798,799,800]
[null,"New enrolment kits required due to tech refresh","enrolment kits will be upgraded after 4 year",{"$f":"'1.1 Backend'!C34","v":0},{"$f":"'1.1 Backend'!D34","v":811},{"$f":"'1.1 Backend'!E34","v":43},{"$f":"'1.1 Backend'!F34","v":0},{"$f":"'1.1 Backend'!G34","v":0},{"$f":"'1.1 Backend'!H34","v":748},{"$f":"'1.1 Backend'!I34","v":43},{"$f":"'1.1 Backend'!J34","v":1},{"$f":"'1.1 Backend'!K34","v":1},{"$f":"'1.1 Backend'!L34","v":749},{"$f":"'1.1 Backend'!M34","v":44},{"$f":"'1.1 Backend'!N34","v":2},{"$f":"'1.1 Backend'!O34","v":2},{"$f":"'1.1 Backend'!P34","v":750},{"$f":"'1.1 Backend'!Q34","v":45},{"$f":"'1.1 Backend'!R34","v":3}]
[null,"New enrolment stations required to setup",null,0,{"$f":"IF(E36>D36,E36-D36,0)","v":811},{"$f":"IF(F36>E36,F36-E36,0)","v":43},0,0,1,0,1,1,1,1,1,1,1,1,1]
[]
[]
["Cost","Enrolment station setup cost","Capex",{"$f":"D38*$K$8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Enrolment kits cost","Capex",{"$f":"D37*$I$8","v":0},2473550,131150,0,0,2281400,131150,3050,3050,2284450,134200,6100,6100,2287500,137250,9150]
[null,"Mobile enrolment vehicle cost","Capex, vechile requirement is half the number of mobile enrolment station required during steady state",{"$f":"'0.2 Unit cost  assumptions'!F86*AVERAGEIF(D17:S17,\"=2\",D35:S35)/2","v":2893278.2144795056}]
[null,"Enrolment station operating cost","opex(operating exp+ vehicle maintenance)",{"$f":"D36*$J$8+$D$43*Hardware_AMC","v":433991.73217192583},2461491.7321719257,2568991.7321719257,2498991.7321719257,2408991.7321719257,2411491.7321719257,2411491.7321719257,2413991.7321719257,2416491.7321719257,2418991.7321719257,2421491.7321719257,2423991.7321719257,2426491.7321719257,2428991.7321719257,2431491.7321719257,2433991.7321719257]
[null,"Total capex",null,{"$f":"D41+D42+D43","v":2893278.2144795056},{"$f":"E41+E42","v":2473550},131150,0,0,2281400,131150,3050,3050,2284450,134200,6100,6100,2287500,137250,9150]
[null,"Total opex",null,{"$f":"D44","v":433991.73217192583},{"$f":"E44","v":2461491.7321719257},2568991.7321719257,2498991.7321719257,2408991.7321719257,2411491.7321719257,2411491.7321719257,2413991.7321719257,2416491.7321719257,2418991.7321719257,2421491.7321719257,2423991.7321719257,2426491.7321719257,2428991.7321719257,2431491.7321719257,2433991.7321719257]

{"sheet":"1.1 Backend","index":13,"n_rows":88,"n_cols":27,"rows_kept":88,"cut":false,"hidden":true,"merged":[[63,0,63,3],[66,0,66,3],[68,0,68,3],[41,0,41,3],[53,0,53,3],[56,0,56,3],[58,0,58,3],[60,0,60,3]]}
["Population in 2016 ","Population growth rate ","Birth rate ","Eligible population for NID"]
[{"$f":"'1. Enrolment'!B4","v":17094130},{"$f":"'1. Enrolment'!C4","v":2.9300000000000003E-2},{"$f":"'1. Enrolment'!D4","v":4.1500000000000002E-2},{"$f":"'1. Enrolment'!F4","v":0.7}]
[]
[]
[]
[]
[]
[]
[]
[]
["Population Estimation "]
["Year ",null,{"$f":"'1. Enrolment'!E4","v":2018},{"$f":"C12+1","v":2019},{"$f":"D12+1","v":2020},2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042]
["Projected Population",null,{"$f":"A2","v":17094130},{"$f":"$C$13*(1+$B$2)^(D12-$C$12)","v":17594988.009000003},{"$f":"$C$13*(1+$B$2)^(E12-$C$12)","v":18110521.157663703},18641159.427583251,19187345.398811441,19749534.61899662,20328195.983333219,20923812.125644885,21536879.820926283,22167910.399679422,22817430.174390033,23485980.878499661,24174120.118239705,24882421.83770413,25611476.79754886,26361893.067717046,27134296.534601156,27929331.423064973,28747660.833760776,29589967.296189971,30456953.337968335,31349342.070770811,32267877.793444395,33213326.612792324,34186477.082547143]
["New births",null,{"$f":"C13*$C$2","v":709406.39500000002},{"$f":"D13*$C$2","v":730192.00237350015},751586.62804304366,773608.11624470493,796274.83405067481,819605.68668835983,843620.13330832857,868338.20321426273,893780.51256844075,919968.28158669604,946923.35223718639,974668.20645773597,1003225.9849069478,1032620.5062647214,1062876.2870982778,1094018.5623102575,1126073.306185948,1159067.2540571964,1193027.9246010722,1227983.6427918838,1263963.563525686,1300997.6959369888,1339116.9284279426,1378353.0544308815,1418738.7989257064]
["Eligible population",null,{"$f":"C13*$D$2","v":11965891},{"$f":"D13*$D$2","v":12316491.606300002},12677364.810364591,13048811.599308275,13431141.779168008,13824674.233297633,14229737.188333252,14646668.487951418,15075815.874648396,15517537.279775595,15972201.122073023,16440186.614949761,16921884.082767792,17417695.28639289,17928033.7582842,18453325.147401929,18994007.574220806,19550531.996145479,20123362.58363254,20712977.107332978,21319867.336577833,21944539.449539568,22587514.455411077,23249328.628954627,23930533.957782999]
[]
["Population distribution"]
["Year",null,{"$f":"start_year","v":2019},{"$f":"C18+1","v":2020},{"$f":"D18+1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
["S.n.",null,{"$f":"'1. Enrolment'!E13","v":1},{"$f":"'1. Enrolment'!F13","v":2},{"$f":"'1. Enrolment'!G13","v":3},{"$f":"'1. Enrolment'!H13","v":4},{"$f":"'1. Enrolment'!I13","v":5},{"$f":"'1. Enrolment'!J13","v":6},{"$f":"'1. Enrolment'!K13","v":7},{"$f":"'1. Enrolment'!L13","v":8},{"$f":"'1. Enrolment'!M13","v":9},{"$f":"'1. Enrolment'!N13","v":10},{"$f":"'1. Enrolment'!O13","v":11},{"$f":"'1. Enrolment'!P13","v":12},{"$f":"'1. Enrolment'!Q13","v":13},{"$f":"'1. Enrolment'!R13","v":14},{"$f":"'1. Enrolment'!S13","v":15}]
["Phase",null,{"$f":"'1. Enrolment'!E17","v":1},{"$f":"'1. Enrolment'!F17","v":1},{"$f":"'1. Enrolment'!G17","v":1},{"$f":"'1. Enrolment'!H17","v":2},{"$f":"'1. Enrolment'!I17","v":2},{"$f":"'1. Enrolment'!J17","v":2},{"$f":"'1. Enrolment'!K17","v":2},{"$f":"'1. Enrolment'!L17","v":2},{"$f":"'1. Enrolment'!M17","v":2},{"$f":"'1. Enrolment'!N17","v":2},{"$f":"'1. Enrolment'!O17","v":2},{"$f":"'1. Enrolment'!P17","v":2},{"$f":"'1. Enrolment'!Q17","v":2},{"$f":"'1. Enrolment'!R17","v":2},{"$f":"'1. Enrolment'!S17","v":2}]
["Registration phase year",null,{"$f":"IF(C20=1,C19,\"\")","v":1},{"$f":"IF(D20=1,D19,\"\")","v":2},3,"","","","","","","","","","","",""]
["Mean of years",null,{"$f":"AVERAGE(C21:Q21)","v":2}]
["Deviation from mean",null,{"$f":"IFERROR(C21-$C$22,\"\")","v":-1},{"$f":"IFERROR(D21-$C$22,\"\")","v":0},1,"","","","","","","","","","","",""]
["Square of mean",null,{"$f":"IFERROR(C23^2,\"\")","v":1},{"$f":"IFERROR(D23^2,\"\")","v":0},1,"","","","","","","","","","","",""]
["sum of square",null,{"$f":"SUM(C24:Q24)","v":2}]
["Standard deviation",null,{"$f":"SQRT(C25/(COUNT(C21:Q21)-1))","v":1}]
["normal distribution",null,{"$f":"IFERROR(_xlfn.NORM.DIST(C21,$C$22,$C$26,FALSE),\"\")","v":0.24197072451914337},{"$f":"IFERROR(_xlfn.NORM.DIST(D21,$C$22,$C$26,FALSE),\"\")","v":0.3989422804014327},0.24197072451914337,"","","","","","","","","","","",""]
["Correction required due to target population",null,{"$f":"'1. Enrolment'!$I$4/SUM('1.1 Backend'!C27:Q27)","v":1.0193867776577361}]
["Revised population distribution",null,{"$f":"IFERROR($C$28*C27,\"\")","v":0.24666175715507732},{"$f":"IFERROR($C$28*D27,\"\")","v":0.40667648568984549},0.24666175715507732,"","","","","","","","","","","",""]
[]
["Tech refresh"]
[null,"Year",{"$f":"'1. Enrolment'!D14","v":2018},{"$f":"'1. Enrolment'!E14","v":2019},{"$f":"'1. Enrolment'!F14","v":2020},{"$f":"'1. Enrolment'!G14","v":2021},{"$f":"'1. Enrolment'!H14","v":2022},{"$f":"'1. Enrolment'!I14","v":2023},{"$f":"'1. Enrolment'!J14","v":2024},{"$f":"'1. Enrolment'!K14","v":2025},{"$f":"'1. Enrolment'!L14","v":2026},{"$f":"'1. Enrolment'!M14","v":2027},{"$f":"'1. Enrolment'!N14","v":2028},{"$f":"'1. Enrolment'!O14","v":2029},{"$f":"'1. Enrolment'!P14","v":2030},{"$f":"'1. Enrolment'!Q14","v":2031},{"$f":"'1. Enrolment'!R14","v":2032},{"$f":"'1. Enrolment'!S14","v":2033}]
[null,"Requirement",{"$f":"'1. Enrolment'!D36","v":0},{"$f":"'1. Enrolment'!E36","v":811},{"$f":"'1. Enrolment'!F36","v":854},{"$f":"'1. Enrolment'!G36","v":826},{"$f":"'1. Enrolment'!H36","v":790},{"$f":"'1. Enrolment'!I36","v":791},{"$f":"'1. Enrolment'!J36","v":791},{"$f":"'1. Enrolment'!K36","v":792},{"$f":"'1. Enrolment'!L36","v":793},{"$f":"'1. Enrolment'!M36","v":794},{"$f":"'1. Enrolment'!N36","v":795},{"$f":"'1. Enrolment'!O36","v":796},{"$f":"'1. Enrolment'!P36","v":797},{"$f":"'1. Enrolment'!Q36","v":798},{"$f":"'1. Enrolment'!R36","v":799},{"$f":"'1. Enrolment'!S36","v":800}]
["Year 1","ES to buy ",null,{"$f":"D33","v":811},{"$f":"IF(E33>SUM(E35:E37),E33-SUM(E35:E37),0)","v":43},{"$f":"IF(F33>SUM(F35:F37),F33-SUM(F35:F37),0)","v":0},0,748,43,1,1,749,44,2,2,750,45,{"$f":"IF(R33>SUM(R35:R37),R33-SUM(R35:R37),0)","v":3}]
["Year 2",null,null,null,{"$f":"D34","v":811},{"$f":"E34","v":43},0,0,748,43,1,1,749,44,2,2,750,45]
["Year 3",null,null,null,null,{"$f":"E35","v":811},43,0,0,748,43,1,1,749,44,2,2,750]
["year 4",null,null,null,null,null,{"$f":"F36","v":811},{"$f":"G36","v":43},0,0,748,43,1,1,749,44,2,2]
[]
[]
[]
["Enrolment Time "]
["Time taken for finger prints "]
["Fingers","Time (minutes) ","included or not","Final time "]
[1,0.4,{"$f":"IF('1. Enrolment'!$K$4*'1. Enrolment'!$L$4='1.1 Backend'!A44,1,0)","v":0},{"$f":"C44*B44","v":0}]
[2,0.4,{"$f":"IF('1. Enrolment'!$K$4*'1. Enrolment'!$L$4='1.1 Backend'!A45,1,0)","v":0},{"$f":"C45*B45","v":0}]
[3,0.4,{"$f":"IF('1. Enrolment'!$K$4*'1. Enrolment'!$L$4='1.1 Backend'!A46,1,0)","v":0},0]
[4,0.4,{"$f":"IF('1. Enrolment'!$K$4*'1. Enrolment'!$L$4='1.1 Backend'!A47,1,0)","v":0},0]
[5,0.8,{"$f":"IF('1. Enrolment'!$K$4*'1. Enrolment'!$L$4='1.1 Backend'!A48,1,0)","v":0},0]
[6,1.2,{"$f":"IF('1. Enrolment'!$K$4*'1. Enrolment'!$L$4='1.1 Backend'!A49,1,0)","v":0},0]
[7,1.2,{"$f":"IF('1. Enrolment'!$K$4*'1. Enrolment'!$L$4='1.1 Backend'!A50,1,0)","v":0},0]
[8,1.2,{"$f":"IF('1. Enrolment'!$K$4*'1. Enrolment'!$L$4='1.1 Backend'!A51,1,0)","v":0},0]
[9,1.2,{"$f":"IF('1. Enrolment'!$K$4*'1. Enrolment'!$L$4='1.1 Backend'!A52,1,0)","v":0},0]
[10,1.6,{"$f":"IF('1. Enrolment'!$K$4*'1. Enrolment'!$L$4='1.1 Backend'!A53,1,0)","v":1},1.6]
["Time taken for IRIS"]
[1,1,{"$f":"IF('1. Enrolment'!$M$4*'1. Enrolment'!$N$4='1.1 Backend'!A55,1,0)","v":0},{"$f":"C55*B55","v":0}]
[2,1,{"$f":"IF('1. Enrolment'!$M$4*'1. Enrolment'!$N$4='1.1 Backend'!A56,1,0)","v":0},{"$f":"C56*B56","v":0}]
["Time taken for Voice"]
[null,1,{"$f":"'1. Enrolment'!O4","v":0},{"$f":"C58*B58","v":0}]
["Time taken for electronic signature"]
[null,1,{"$f":"'1. Enrolment'!Q4","v":0},{"$f":"C60*B60","v":0}]
["Time taken for demographics"]
["Points","Time per demographic"]
[1,0.3,{"$f":"'1. Enrolment'!R4","v":0},{"$f":"C63*B63","v":0}]
["Time taken for photograph"]
["Points","Time (in minutes)"]
[null,1,{"$f":"'1. Enrolment'!P4","v":1},{"$f":"C66*B66","v":1}]
["Time taken for Verification by Enrolee"]
[null,1,{"$f":"ROUNDUP(C63/10,0)","v":0},{"$f":"C68*B68","v":0},"(1 minute per 10 demographic fields)"]
["Time taken for Misc. activities (eg. Operator biometric, instructions, printing of acknowledgment Slip)"]
[null,5,1,{"$f":"C70*B70","v":5}]
[null,null,"Total time per enrolment ",{"$f":"D70+D68+D66+D63+D60+D58+D56+D55+SUM(D44:D53)","v":7.6}]
[]
["Enrolment Kit "]
["Computer / Laptop",{"$f":"'0.2 Unit cost  assumptions'!F7","v":1200},1,{"$f":"C74*B74","v":1200}]
["Mobile / tablet",{"$f":"'0.2 Unit cost  assumptions'!F8","v":200},0,{"$f":"C75*B75","v":0}]
["Camera / webcam",{"$f":"'0.2 Unit cost  assumptions'!F9","v":100},{"$f":"C66","v":1},100]
["Multifunction Printer",{"$f":"'0.2 Unit cost  assumptions'!F10","v":200},1,200]
["Power back up",{"$f":"'0.2 Unit cost  assumptions'!F11","v":100},1,100]
["Finger print scanner - One finger",{"$f":"'0.2 Unit cost  assumptions'!F12","v":200},{"$f":"C44","v":0},0]
["Finger print scanner - Slab scanner",{"$f":"'0.2 Unit cost  assumptions'!F13","v":1000},{"$f":"IF(AND('1. Enrolment'!K4=1,'1. Enrolment'!L4>1),1,0)","v":1},1000]
["Iris scanner - one",{"$f":"'0.2 Unit cost  assumptions'!F14","v":300},{"$f":"C55","v":0},0]
["Iris scanner - two",{"$f":"'0.2 Unit cost  assumptions'!F15","v":1000},{"$f":"C56","v":0},0]
["Signature pad",{"$f":"'0.2 Unit cost  assumptions'!F16","v":150},{"$f":"C60","v":0},0]
["GPS dongle",{"$f":"'0.2 Unit cost  assumptions'!F17","v":100},1,100]
["Additional Screen",{"$f":"'0.2 Unit cost  assumptions'!F18","v":150},1,150]
["Voice recording device",{"$f":"'0.2 Unit cost  assumptions'!F19","v":150},{"$f":"C58","v":0},0]
["Case for kit",{"$f":"'0.2 Unit cost  assumptions'!F20","v":200},1,200]
[null,null,"Enrolment kit cost",{"$f":"SUM(D74:D87)","v":3050}]

{"sheet":"2. human resource","index":14,"n_rows":19,"n_cols":18,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Human resource cost estimation "]
[]
["Component","no. of employee at each enrolment station ","No. of Regional offices required","No. of district office required","Hiring cost ","Shared human resources with CRVS","Reduction in human resources cost due to CRVS linkages"]
["Value",{"$f":"'0.4 All inputs'!A20","v":2},{"$f":"'0.4 All inputs'!B20","v":20},{"$f":"'0.4 All inputs'!C20","v":765},{"$f":"'0.4 All inputs'!D20","v":0.05},{"$f":"'0.4 All inputs'!B58","v":0},{"$f":"'0.4 All inputs'!D58","v":0.3}]
["Description ",null,null,null,"% of total annual compensation ","yes=1 , no = 0 ","yes=1 , no = 0 "]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'1. Enrolment'!D13","v":0},{"$f":"'1. Enrolment'!E13","v":1},{"$f":"'1. Enrolment'!F13","v":2},{"$f":"'1. Enrolment'!G13","v":3},{"$f":"'1. Enrolment'!H13","v":4},{"$f":"'1. Enrolment'!I13","v":5},{"$f":"'1. Enrolment'!J13","v":6},{"$f":"'1. Enrolment'!K13","v":7},{"$f":"'1. Enrolment'!L13","v":8},{"$f":"'1. Enrolment'!M13","v":9},{"$f":"'1. Enrolment'!N13","v":10},{"$f":"'1. Enrolment'!O13","v":11},{"$f":"'1. Enrolment'!P13","v":12},{"$f":"'1. Enrolment'!Q13","v":13},{"$f":"'1. Enrolment'!R13","v":14},{"$f":"'1. Enrolment'!S13","v":15}]
[null,null,{"$f":"'1. Enrolment'!D14","v":2018},{"$f":"'1. Enrolment'!E14","v":2019},{"$f":"'1. Enrolment'!F14","v":2020},{"$f":"'1. Enrolment'!G14","v":2021},{"$f":"'1. Enrolment'!H14","v":2022},{"$f":"'1. Enrolment'!I14","v":2023},{"$f":"'1. Enrolment'!J14","v":2024},{"$f":"'1. Enrolment'!K14","v":2025},{"$f":"'1. Enrolment'!L14","v":2026},{"$f":"'1. Enrolment'!M14","v":2027},{"$f":"'1. Enrolment'!N14","v":2028},{"$f":"'1. Enrolment'!O14","v":2029},{"$f":"'1. Enrolment'!P14","v":2030},{"$f":"'1. Enrolment'!Q14","v":2031},{"$f":"'1. Enrolment'!R14","v":2032},{"$f":"'1. Enrolment'!S14","v":2033}]
["Headquarter personnel cost",null,{"$f":"'2.1 Org_Structure'!G58","v":533717.00170357735},{"$f":"'2.1 Org_Structure'!H58","v":533717.00170357735},{"$f":"'2.1 Org_Structure'!I58","v":533717.00170357735},{"$f":"'2.1 Org_Structure'!J58","v":533717.00170357735},{"$f":"'2.1 Org_Structure'!K58","v":533717.00170357735},{"$f":"'2.1 Org_Structure'!L58","v":533717.00170357735},{"$f":"'2.1 Org_Structure'!M58","v":533717.00170357735},{"$f":"'2.1 Org_Structure'!N58","v":533717.00170357735},{"$f":"'2.1 Org_Structure'!O58","v":533717.00170357735},{"$f":"'2.1 Org_Structure'!P58","v":533717.00170357735},{"$f":"'2.1 Org_Structure'!Q58","v":533717.00170357735},{"$f":"'2.1 Org_Structure'!R58","v":533717.00170357735},{"$f":"'2.1 Org_Structure'!S58","v":533717.00170357735},{"$f":"'2.1 Org_Structure'!T58","v":533717.00170357735},{"$f":"'2.1 Org_Structure'!U58","v":533717.00170357735},{"$f":"'2.1 Org_Structure'!V58","v":533717.00170357735}]
["Regional office personnel cost",null,{"$f":"'2.1 Org_Structure'!G77","v":951959.11413969344},{"$f":"'2.1 Org_Structure'!H77","v":951959.11413969344},{"$f":"'2.1 Org_Structure'!I77","v":951959.11413969344},{"$f":"'2.1 Org_Structure'!J77","v":951959.11413969344},{"$f":"'2.1 Org_Structure'!K77","v":951959.11413969344},{"$f":"'2.1 Org_Structure'!L77","v":951959.11413969344},{"$f":"'2.1 Org_Structure'!M77","v":951959.11413969344},{"$f":"'2.1 Org_Structure'!N77","v":951959.11413969344},{"$f":"'2.1 Org_Structure'!O77","v":951959.11413969344},{"$f":"'2.1 Org_Structure'!P77","v":951959.11413969344},{"$f":"'2.1 Org_Structure'!Q77","v":951959.11413969344},{"$f":"'2.1 Org_Structure'!R77","v":951959.11413969344},{"$f":"'2.1 Org_Structure'!S77","v":951959.11413969344},{"$f":"'2.1 Org_Structure'!T77","v":951959.11413969344},{"$f":"'2.1 Org_Structure'!U77","v":951959.11413969344},{"$f":"'2.1 Org_Structure'!V77","v":951959.11413969344}]
["District office personnel cost",null,{"$f":"'2.1 Org_Structure'!G84","v":12041908.00681431},{"$f":"'2.1 Org_Structure'!H84","v":12041908.00681431},{"$f":"'2.1 Org_Structure'!I84","v":12041908.00681431},{"$f":"'2.1 Org_Structure'!J84","v":12041908.00681431},{"$f":"'2.1 Org_Structure'!K84","v":12041908.00681431},{"$f":"'2.1 Org_Structure'!L84","v":12041908.00681431},{"$f":"'2.1 Org_Structure'!M84","v":12041908.00681431},{"$f":"'2.1 Org_Structure'!N84","v":12041908.00681431},{"$f":"'2.1 Org_Structure'!O84","v":12041908.00681431},{"$f":"'2.1 Org_Structure'!P84","v":12041908.00681431},{"$f":"'2.1 Org_Structure'!Q84","v":12041908.00681431},{"$f":"'2.1 Org_Structure'!R84","v":12041908.00681431},{"$f":"'2.1 Org_Structure'!S84","v":12041908.00681431},{"$f":"'2.1 Org_Structure'!T84","v":12041908.00681431},{"$f":"'2.1 Org_Structure'!U84","v":12041908.00681431},{"$f":"'2.1 Org_Structure'!V84","v":12041908.00681431}]
["Operator cost",null,{"$f":"'2.1 Org_Structure'!G86","v":0},{"$f":"'2.1 Org_Structure'!H86","v":3647427.597955707},{"$f":"'2.1 Org_Structure'!I86","v":3840817.7172061326},{"$f":"'2.1 Org_Structure'!J86","v":3714889.2674616692},{"$f":"'2.1 Org_Structure'!K86","v":3552981.2606473593},{"$f":"'2.1 Org_Structure'!L86","v":3557478.70528109},{"$f":"'2.1 Org_Structure'!M86","v":3557478.70528109},{"$f":"'2.1 Org_Structure'!N86","v":3561976.1499148211},{"$f":"'2.1 Org_Structure'!O86","v":3566473.5945485518},{"$f":"'2.1 Org_Structure'!P86","v":3570971.0391822825},{"$f":"'2.1 Org_Structure'!Q86","v":3575468.4838160137},{"$f":"'2.1 Org_Structure'!R86","v":3579965.9284497444},{"$f":"'2.1 Org_Structure'!S86","v":3584463.373083475},{"$f":"'2.1 Org_Structure'!T86","v":3588960.8177172057},{"$f":"'2.1 Org_Structure'!U86","v":3593458.2623509369},{"$f":"'2.1 Org_Structure'!V86","v":3597955.7069846676}]
["Recruitment cost",null,{"$f":"$E$4*SUM(C14:C16)","v":676379.20613287913},{"$f":"IF(D17>C17,(D17-C17)*$E$4,0)","v":182371.37989778537},{"$f":"IF(E17>D17,(E17-D17)*$E$4,0)","v":9669.5059625212798},0,0,224.87223168653438,0,224.87223168655765,224.87223168653438,224.87223168653438,224.87223168655765,224.87223168653438,224.87223168653438,224.87223168653438,224.87223168655765,224.87223168653438]
["Total personnel cost",null,{"$f":"SUM(C14:C18)*(1-$F$4*$G$4)","v":14203963.328790462},{"$f":"SUM(D14:D18)*(1-$F$4*$G$4)","v":17357383.100511074},17378071.345826235,17242473.390119251,17080565.383304942,17085287.700170361,17085062.827938672,17089785.14480409,17094282.589437824,17098780.034071553,17103277.478705283,17107774.923339013,17112272.367972746,17116769.812606476,17121267.257240206,17125764.701873939]

{"sheet":"0.3 HR compensation","index":15,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":true,"merged":[[0,6,3,11]]}
[null,null,null,null,null,null,"Instruction: \nThis section list the level wise salary across various departments. As a benchmark salary for various levels, wage estimates (Column \"H\") of Bureau of Labor statistics is considered. This value is then multiplied with ratio of per capita income for selected country and USA (Column \"I\") to estimate the wage levels for selected country. Additional allowances (Column \"K\") has been also added in the salary. Kindly change the relevant values (column H,J) to changes the salary (Column \"K\"). "]
[]
[]
[]
[]
[null,null,null,null,null,null,"US per capital Income ",58700,"2016, PPP US $, WB databank"]
[null,null,null,null,null,null,"per capita income for selected country",{"$f":"'0.4 All inputs'!H15","v":4000},"2011, PPP US $"]
[null,null,null,null,null,null,"ratio of per capita income ",{"$f":"H7/H6","v":6.8143100511073251E-2}]
[null,null,null,null,null,null,"Allowances ",0.1]
[]
[null,null,null,null,null,null,"Title ","Annual salary in USA","Per capita income ratio","Allowance ","Computed compensation for selected country","Category "]
[null,null,null,null,null,null,"Top Executives "]
[null,null,null,null,null,null,"Executive - 1",230090,{"$f":"$H$8","v":6.8143100511073251E-2},{"$f":"$H$9","v":0.1},{"$f":"(1+J13)*(I13*H13)","v":17246.950596252129},"E1"]
[null,null,null,null,null,null,"Executive - 2",180000,{"$f":"$H$8","v":6.8143100511073251E-2},{"$f":"$H$9","v":0.1},{"$f":"(1+J14)*(I14*H14)","v":13492.333901192505},"E2"]
[null,null,null,null,null,null,"Executive - 3",150000,6.8143100511073251E-2,0.1,11243.611584327087,"E3"]
[null,null,null,null,null,null,"Executive - 4",120000,{"$f":"$H$8","v":6.8143100511073251E-2},0.1,8994.8892674616691,"E4"]
[null,null,null,null,null,null,"Administration "]
[null,null,null,null,null,null,"Level 1",140000,{"$f":"$H$8","v":6.8143100511073251E-2},{"$f":"$H$9","v":0.1},10494.037478705282,"A1"]
[null,null,null,null,null,null,"Level 2",110000,{"$f":"$H$8","v":6.8143100511073251E-2},{"$f":"$H$9","v":0.1},8245.3151618398642,"A2"]
[null,null,null,null,null,null,"Level 3",80000,6.8143100511073251E-2,0.1,5996.5928449744461,"A3"]
[null,null,null,null,null,null,"Level 4",60000,6.8143100511073251E-2,0.1,4497.4446337308345,"A4"]
[null,null,null,null,null,null,"IT and Technology"]
[null,null,null,null,null,null,"Level 1",180000,6.8143100511073251E-2,{"$f":"$H$9","v":0.1},13492.333901192505,"I1"]
[null,null,null,null,null,null,"Level 2",150000,6.8143100511073251E-2,{"$f":"$H$9","v":0.1},11243.611584327087,"I2"]
[null,null,null,null,null,null,"Level 3",110000,6.8143100511073251E-2,0.1,8245.3151618398642,"I3"]
[null,null,null,null,null,null,"Level 4",80000,6.8143100511073251E-2,0.1,5996.5928449744461,"I4"]
[null,null,null,null,null,null,"CRM,Logistics, procurement  "]
[null,null,null,null,null,null,"Level 1",125000,6.8143100511073251E-2,{"$f":"$H$9","v":0.1},9369.6763202725724,"C1"]
[null,null,null,null,null,null,"Level 2",100000,6.8143100511073251E-2,{"$f":"$H$9","v":0.1},7495.7410562180585,"C2"]
[null,null,null,null,null,null,"Level 3",80000,6.8143100511073251E-2,0.1,5996.5928449744461,"C3"]
[null,null,null,null,null,null,"Level 4",60000,6.8143100511073251E-2,0.1,4497.4446337308345,"C4"]
[null,null,null,null,null,null,"Finance accounting "]
[null,null,null,null,null,null,"Level 1",160000,6.8143100511073251E-2,{"$f":"$H$9","v":0.1},11993.185689948892,"F1"]
[null,null,null,null,null,null,"Level 2",130000,6.8143100511073251E-2,{"$f":"$H$9","v":0.1},9744.4633730834757,"F2"]
[null,null,null,null,null,null,"Level 3",100000,6.8143100511073251E-2,0.1,7495.7410562180585,"F3"]
[null,null,null,null,null,null,"Level 4",70000,6.8143100511073251E-2,0.1,5247.0187393526412,"F4"]
[null,null,null,null,null,null,"Operations"]
[null,null,null,null,null,null,"Level 1",150000,6.8143100511073251E-2,{"$f":"$H$9","v":0.1},11243.611584327087,"O1"]
[null,null,null,null,null,null,"Level 2",130000,6.8143100511073251E-2,{"$f":"$H$9","v":0.1},9744.4633730834757,"O2"]
[null,null,null,null,null,null,"Level 3",100000,6.8143100511073251E-2,0.1,7495.7410562180585,"O3"]
[null,null,null,null,null,null,"Level 4",70000,6.8143100511073251E-2,0.1,5247.0187393526412,"O4"]
[null,null,null,null,null,null,"Human resource "]
[null,null,null,null,null,null,"Level 1",140000,6.8143100511073251E-2,{"$f":"$H$9","v":0.1},10494.037478705282,"H1"]
[null,null,null,null,null,null,"Level 2",120000,6.8143100511073251E-2,{"$f":"$H$9","v":0.1},8994.8892674616691,"H2"]
[null,null,null,null,null,null,"Level 3",100000,6.8143100511073251E-2,0.1,7495.7410562180585,"H3"]
[null,null,null,null,null,null,"Level 4",80000,6.8143100511073251E-2,0.1,5996.5928449744461,"H4"]
[null,null,null,null,null,null,"Marketing branding "]
[null,null,null,null,null,null,"Level 1",135000,6.8143100511073251E-2,{"$f":"$H$9","v":0.1},10119.250425894379,"M1"]
[null,null,null,null,null,null,"Level 2",110000,6.8143100511073251E-2,{"$f":"$H$9","v":0.1},8245.3151618398642,"M2"]
[null,null,null,null,null,null,"Level 3",85000,6.8143100511073251E-2,0.1,6371.3798977853494,"M3"]
[null,null,null,null,null,null,"Level 4",60000,6.8143100511073251E-2,0.1,4497.4446337308345,"M4"]
[null,null,null,null,null,null,"Legal "]
[null,null,null,null,null,null,"Level 1",120000,6.8143100511073251E-2,{"$f":"$H$9","v":0.1},8994.8892674616691,"L1"]
[null,null,null,null,null,null,"Level 2",100000,6.8143100511073251E-2,{"$f":"$H$9","v":0.1},7495.7410562180585,"L2"]
[null,null,null,null,null,null,"Level 3",80000,6.8143100511073251E-2,0.1,5996.5928449744461,"L3"]
[null,null,null,null,null,null,"Level 4",60000,6.8143100511073251E-2,0.1,4497.4446337308345,"L4"]
[null,null,null,null,null,null,"Office support staff"]
[null,null,null,null,null,null,"Level 1",45000,6.8143100511073251E-2,{"$f":"$H$9","v":0.1},3373.0834752981264,"S1"]
[null,null,null,null,null,null,"Level 2",35000,6.8143100511073251E-2,{"$f":"$H$9","v":0.1},2623.5093696763206,"S2"]
[null,null,null,null,null,null,"Level 3",30000,6.8143100511073251E-2,0.1,2248.7223168654173,"S3"]
[null,null,null,null,null,null,"Level 4",25000,6.8143100511073251E-2,0.1,1873.9352640545146,"S4"]

{"sheet":"2.1 Org_Structure","index":16,"n_rows":88,"n_cols":22,"rows_kept":88,"cut":false,"hidden":true,"merged":[[0,0,3,6],[28,0,30,0],[12,0,15,0],[16,0,18,0],[19,0,21,0],[22,0,24,0],[25,0,27,0],[31,0,33,0],[34,0,36,0],[37,0,39,0],[40,0,42,0],[43,0,45,0],[68,0,70,0],[63,0,65,0],[40,2,42,2],[71,0,73,0],[49,0,51,0],[52,0,54,0],[55,0,56,0],[60,0,62,0],[66,0,67,0],[46,0,48,0]]}
["Instruction:\nNo. of employees can be changed by changing values in column D. Before changing any values it is advised to kindly read human resources cost estimation methodology. To change the annual compensation, kindly use \"Go to Compensation List\".\nKindly do not change any other column except column D and E \n"]
[]
[]
[]
[]
[]
[]
[]
["Department ","Position","Description ","no. of employees","Level at org. struct","Annual compensation ",{"$f":"'1. Enrolment'!D13","v":0},{"$f":"'1. Enrolment'!E13","v":1},{"$f":"'1. Enrolment'!F13","v":2},{"$f":"'1. Enrolment'!G13","v":3},{"$f":"'1. Enrolment'!H13","v":4},{"$f":"'1. Enrolment'!I13","v":5},{"$f":"'1. Enrolment'!J13","v":6},{"$f":"'1. Enrolment'!K13","v":7},{"$f":"'1. Enrolment'!L13","v":8},{"$f":"'1. Enrolment'!M13","v":9},{"$f":"'1. Enrolment'!N13","v":10},{"$f":"'1. Enrolment'!O13","v":11},{"$f":"'1. Enrolment'!P13","v":12},{"$f":"'1. Enrolment'!Q13","v":13},{"$f":"'1. Enrolment'!R13","v":14},{"$f":"'1. Enrolment'!S13","v":15}]
[null,null,"year",null,null,null,{"$f":"'1. Enrolment'!D14","v":2018},{"$f":"'1. Enrolment'!E14","v":2019},{"$f":"'1. Enrolment'!F14","v":2020},{"$f":"'1. Enrolment'!G14","v":2021},{"$f":"'1. Enrolment'!H14","v":2022},{"$f":"'1. Enrolment'!I14","v":2023},{"$f":"'1. Enrolment'!J14","v":2024},{"$f":"'1. Enrolment'!K14","v":2025},{"$f":"'1. Enrolment'!L14","v":2026},{"$f":"'1. Enrolment'!M14","v":2027},{"$f":"'1. Enrolment'!N14","v":2028},{"$f":"'1. Enrolment'!O14","v":2029},{"$f":"'1. Enrolment'!P14","v":2030},{"$f":"'1. Enrolment'!Q14","v":2031},{"$f":"'1. Enrolment'!R14","v":2032},{"$f":"'1. Enrolment'!S14","v":2033}]
[null,null,"Phase",null,null,null,{"$f":"'1. Enrolment'!D17","v":0},{"$f":"'1. Enrolment'!E17","v":1},{"$f":"'1. Enrolment'!F17","v":1},{"$f":"'1. Enrolment'!G17","v":1},{"$f":"'1. Enrolment'!H17","v":2},{"$f":"'1. Enrolment'!I17","v":2},{"$f":"'1. Enrolment'!J17","v":2},{"$f":"'1. Enrolment'!K17","v":2},{"$f":"'1. Enrolment'!L17","v":2},{"$f":"'1. Enrolment'!M17","v":2},{"$f":"'1. Enrolment'!N17","v":2},{"$f":"'1. Enrolment'!O17","v":2},{"$f":"'1. Enrolment'!P17","v":2},{"$f":"'1. Enrolment'!Q17","v":2},{"$f":"'1. Enrolment'!R17","v":2},{"$f":"'1. Enrolment'!S17","v":2}]
["Headquarter",null,"Enrolment stations",null,null,null,{"$f":"'1. Enrolment'!D36","v":0},{"$f":"'1. Enrolment'!E36","v":811},{"$f":"'1. Enrolment'!F36","v":854},{"$f":"'1. Enrolment'!G36","v":826},{"$f":"'1. Enrolment'!H36","v":790},{"$f":"'1. Enrolment'!I36","v":791},{"$f":"'1. Enrolment'!J36","v":791},{"$f":"'1. Enrolment'!K36","v":792},{"$f":"'1. Enrolment'!L36","v":793},{"$f":"'1. Enrolment'!M36","v":794},{"$f":"'1. Enrolment'!N36","v":795},{"$f":"'1. Enrolment'!O36","v":796},{"$f":"'1. Enrolment'!P36","v":797},{"$f":"'1. Enrolment'!Q36","v":798},{"$f":"'1. Enrolment'!R36","v":799},{"$f":"'1. Enrolment'!S36","v":800}]
["Steering Committee","CEO ",null,1,"E1",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E13,'0.3 HR compensation'!$L$13:$L$61,0))","v":17246.950596252129},{"$f":"$F13*$D13","v":17246.950596252129},17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129]
[null,"Heads",null,2,"E2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E14,'0.3 HR compensation'!$L$13:$L$61,0))","v":13492.333901192505},26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011]
[null,"Minister and other member",null,2,"E2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E15,'0.3 HR compensation'!$L$13:$L$61,0))","v":13492.333901192505},26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011]
[null,"Personal Secretary ",null,2,"A2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E16,'0.3 HR compensation'!$L$13:$L$61,0))","v":8245.3151618398642},16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728]
["Administration and Establishment ","Executive level ",null,1,"A1",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E17,'0.3 HR compensation'!$L$13:$L$61,0))","v":10494.037478705282},10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282]
[null,"Senior employees",null,1,"A2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E18,'0.3 HR compensation'!$L$13:$L$61,0))","v":8245.3151618398642},8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642]
[null,"Junior employees",null,2,"A3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E19,'0.3 HR compensation'!$L$13:$L$61,0))","v":5996.5928449744461},11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892]
["IT & Technology ","Executive level ",null,1,"I1",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E20,'0.3 HR compensation'!$L$13:$L$61,0))","v":13492.333901192505},13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505]
[null,"Senior employees",null,2,"I2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E21,'0.3 HR compensation'!$L$13:$L$61,0))","v":11243.611584327087},22487.223168654175,22487.223168654175,22487.223168654175,22487.223168654175,22487.223168654175,22487.223168654175,22487.223168654175,22487.223168654175,22487.223168654175,22487.223168654175,22487.223168654175,22487.223168654175,22487.223168654175,22487.223168654175,22487.223168654175,22487.223168654175]
[null,"Junior employees",null,2,"I3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E22,'0.3 HR compensation'!$L$13:$L$61,0))","v":8245.3151618398642},16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728]
["CRM and logistics","Executive level ",null,0,"C1",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E23,'0.3 HR compensation'!$L$13:$L$61,0))","v":9369.6763202725724},{"$f":"$F23*$D23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Senior employees",null,1,"C2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E24,'0.3 HR compensation'!$L$13:$L$61,0))","v":7495.7410562180585},7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585]
[null,"Junior employees",null,1,"C3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E25,'0.3 HR compensation'!$L$13:$L$61,0))","v":5996.5928449744461},5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461]
["Training testing and certification ","Executive level ",null,0,"C1",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E26,'0.3 HR compensation'!$L$13:$L$61,0))","v":9369.6763202725724},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Senior employees",null,1,"C2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E27,'0.3 HR compensation'!$L$13:$L$61,0))","v":7495.7410562180585},7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585]
[null,"Junior employees",null,0,"C3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E28,'0.3 HR compensation'!$L$13:$L$61,0))","v":5996.5928449744461},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Procurement ","Executive level ",null,1,"O1",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E29,'0.3 HR compensation'!$L$13:$L$61,0))","v":11243.611584327087},11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087]
[null,"Senior employees",null,1,"O2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E30,'0.3 HR compensation'!$L$13:$L$61,0))","v":9744.4633730834757},9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757]
[null,"Junior employees",null,0,"O3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E31,'0.3 HR compensation'!$L$13:$L$61,0))","v":7495.7410562180585},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Finance and accounting ","Executive level ",null,1,"F1",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E32,'0.3 HR compensation'!$L$13:$L$61,0))","v":11993.185689948892},11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892]
[null,"Senior employees",null,1,"F2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E33,'0.3 HR compensation'!$L$13:$L$61,0))","v":9744.4633730834757},{"$f":"$F33*$D33","v":9744.4633730834757},9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757]
[null,"Junior employees",null,1,"F3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E34,'0.3 HR compensation'!$L$13:$L$61,0))","v":7495.7410562180585},7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585]
["Enrolment and updation ","Executive level ",null,1,"O1",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E35,'0.3 HR compensation'!$L$13:$L$61,0))","v":11243.611584327087},11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087]
[null,"Senior employees",null,2,"O2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E36,'0.3 HR compensation'!$L$13:$L$61,0))","v":9744.4633730834757},19488.926746166951,19488.926746166951,19488.926746166951,19488.926746166951,19488.926746166951,19488.926746166951,19488.926746166951,19488.926746166951,19488.926746166951,19488.926746166951,19488.926746166951,19488.926746166951,19488.926746166951,19488.926746166951,19488.926746166951,19488.926746166951]
[null,"Junior employees",null,2,"O3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E37,'0.3 HR compensation'!$L$13:$L$61,0))","v":7495.7410562180585},14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117]
["Human resource ","Executive level ",null,1,"H1",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E38,'0.3 HR compensation'!$L$13:$L$61,0))","v":10494.037478705282},10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282,10494.037478705282]
[null,"Senior employees",null,1,"H2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E39,'0.3 HR compensation'!$L$13:$L$61,0))","v":8994.8892674616691},8994.8892674616691,8994.8892674616691,8994.8892674616691,8994.8892674616691,8994.8892674616691,8994.8892674616691,8994.8892674616691,8994.8892674616691,8994.8892674616691,8994.8892674616691,8994.8892674616691,8994.8892674616691,8994.8892674616691,8994.8892674616691,8994.8892674616691,8994.8892674616691]
[null,"Junior employees",null,2,"H3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E40,'0.3 HR compensation'!$L$13:$L$61,0))","v":7495.7410562180585},14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117,14991.482112436117]
["Authentication, application and coordination ","Executive level ","software development cost has been already estimated in software section ",1,"I1",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E41,'0.3 HR compensation'!$L$13:$L$61,0))","v":13492.333901192505},13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505]
[null,"Senior employees",null,1,"I2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E42,'0.3 HR compensation'!$L$13:$L$61,0))","v":11243.611584327087},11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087]
[null,"Junior employees",null,2,"I3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E43,'0.3 HR compensation'!$L$13:$L$61,0))","v":8245.3151618398642},{"$f":"$F43*$D43","v":16490.630323679728},16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728,16490.630323679728]
["Marketing and branding","Executive level ",null,0,"M1",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E44,'0.3 HR compensation'!$L$13:$L$61,0))","v":10119.250425894379},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Senior employees",null,1,"M2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E45,'0.3 HR compensation'!$L$13:$L$61,0))","v":8245.3151618398642},8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642]
[null,"Junior employees",null,2,"M3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E46,'0.3 HR compensation'!$L$13:$L$61,0))","v":6371.3798977853494},12742.759795570699,12742.759795570699,12742.759795570699,12742.759795570699,12742.759795570699,12742.759795570699,12742.759795570699,12742.759795570699,12742.759795570699,12742.759795570699,12742.759795570699,12742.759795570699,12742.759795570699,12742.759795570699,12742.759795570699,12742.759795570699]
["Legal ","Executive level ",null,0,"L1",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E47,'0.3 HR compensation'!$L$13:$L$61,0))","v":8994.8892674616691},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Senior employees",null,1,"L2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E48,'0.3 HR compensation'!$L$13:$L$61,0))","v":7495.7410562180585},7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585]
[null,"Junior employees",null,2,"L3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E49,'0.3 HR compensation'!$L$13:$L$61,0))","v":5996.5928449744461},11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892,11993.185689948892]
["External Consultants","Executive level ",null,1,"E1",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E50,'0.3 HR compensation'!$L$13:$L$61,0))","v":17246.950596252129},17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129]
[null,"Senior employees",null,2,"E2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E51,'0.3 HR compensation'!$L$13:$L$61,0))","v":13492.333901192505},26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011,26984.667802385011]
[null,"Junior employees",null,3,"E3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E52,'0.3 HR compensation'!$L$13:$L$61,0))","v":11243.611584327087},33730.83475298126,33730.83475298126,33730.83475298126,33730.83475298126,33730.83475298126,33730.83475298126,33730.83475298126,33730.83475298126,33730.83475298126,33730.83475298126,33730.83475298126,33730.83475298126,33730.83475298126,33730.83475298126,33730.83475298126,33730.83475298126]
["External auditors ","Executive level ",null,1,"E1",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E53,'0.3 HR compensation'!$L$13:$L$61,0))","v":17246.950596252129},17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129,17246.950596252129]
[null,"Senior employees",null,1,"E2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E54,'0.3 HR compensation'!$L$13:$L$61,0))","v":13492.333901192505},13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505]
[null,"Junior employees",null,1,"E3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E55,'0.3 HR compensation'!$L$13:$L$61,0))","v":11243.611584327087},11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087,11243.611584327087]
["Office support staff ","Senior",null,2,"S2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E56,'0.3 HR compensation'!$L$13:$L$61,0))","v":2623.5093696763206},5247.0187393526412,5247.0187393526412,5247.0187393526412,5247.0187393526412,5247.0187393526412,5247.0187393526412,5247.0187393526412,5247.0187393526412,5247.0187393526412,5247.0187393526412,5247.0187393526412,5247.0187393526412,5247.0187393526412,5247.0187393526412,5247.0187393526412,5247.0187393526412]
[null,"Junior",null,2,"S3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E57,'0.3 HR compensation'!$L$13:$L$61,0))","v":2248.7223168654173},4497.4446337308345,4497.4446337308345,4497.4446337308345,4497.4446337308345,4497.4446337308345,4497.4446337308345,4497.4446337308345,4497.4446337308345,4497.4446337308345,4497.4446337308345,4497.4446337308345,4497.4446337308345,4497.4446337308345,4497.4446337308345,4497.4446337308345,4497.4446337308345]
[null,"Total in HQ",null,{"$f":"SUM(D13:D57)","v":56},null,null,{"$f":"SUM(G13:G57)","v":533717.00170357735},{"$f":"SUM(H13:H57)","v":533717.00170357735},533717.00170357735,533717.00170357735,533717.00170357735,533717.00170357735,533717.00170357735,533717.00170357735,533717.00170357735,533717.00170357735,533717.00170357735,533717.00170357735,533717.00170357735,533717.00170357735,533717.00170357735,533717.00170357735]
[]
["Regional Office "]
["Steering Committee","Regional Head ",null,1,"E2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E61,'0.3 HR compensation'!$L$13:$L$61,0))","v":13492.333901192505},{"$f":"$F61*$D61","v":13492.333901192505},13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505,13492.333901192505]
[null,"Vice head",null,0,"E3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E62,'0.3 HR compensation'!$L$13:$L$61,0))","v":11243.611584327087},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Other member ",null,0,"E3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E63,'0.3 HR compensation'!$L$13:$L$61,0))","v":11243.611584327087},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tech support and procurement ","manager ",null,0,"I2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E64,'0.3 HR compensation'!$L$13:$L$61,0))","v":11243.611584327087},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"senior staff",null,1,"I3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E65,'0.3 HR compensation'!$L$13:$L$61,0))","v":8245.3151618398642},8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642,8245.3151618398642]
[null,"Junior staff",null,0,"I4",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E66,'0.3 HR compensation'!$L$13:$L$61,0))","v":5996.5928449744461},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Finance and accounting ","Senior staff",null,1,"F2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E67,'0.3 HR compensation'!$L$13:$L$61,0))","v":9744.4633730834757},9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757,9744.4633730834757]
[null,"Junior staff",null,0,"F3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E68,'0.3 HR compensation'!$L$13:$L$61,0))","v":7495.7410562180585},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["IEC, GR and Marketing division ","Manager",null,0,"M2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E69,'0.3 HR compensation'!$L$13:$L$61,0))","v":8245.3151618398642},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"senior staff",null,1,"M3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E70,'0.3 HR compensation'!$L$13:$L$61,0))","v":6371.3798977853494},6371.3798977853494,6371.3798977853494,6371.3798977853494,6371.3798977853494,6371.3798977853494,6371.3798977853494,6371.3798977853494,6371.3798977853494,6371.3798977853494,6371.3798977853494,6371.3798977853494,6371.3798977853494,6371.3798977853494,6371.3798977853494,6371.3798977853494,6371.3798977853494]
[null,"Junior staff",null,0,"M4",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E71,'0.3 HR compensation'!$L$13:$L$61,0))","v":4497.4446337308345},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Enrolment, updation and operation ","Manager",null,0,"O2",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E72,'0.3 HR compensation'!$L$13:$L$61,0))","v":9744.4633730834757},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"senior staff",null,1,"O3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E73,'0.3 HR compensation'!$L$13:$L$61,0))","v":7495.7410562180585},7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585]
[null,"Junior staff",null,0,"O4",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E74,'0.3 HR compensation'!$L$13:$L$61,0))","v":5247.0187393526412},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Office Support staff",null,null,1,"S3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E75,'0.3 HR compensation'!$L$13:$L$61,0))","v":2248.7223168654173},2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173]
[null,"Total ",null,{"$f":"SUM(D61:D75)","v":6},null,null,{"$f":"SUM(G61:G75)","v":47597.955706984671},{"$f":"SUM(H61:H75)","v":47597.955706984671},47597.955706984671,47597.955706984671,47597.955706984671,47597.955706984671,47597.955706984671,47597.955706984671,47597.955706984671,47597.955706984671,47597.955706984671,47597.955706984671,47597.955706984671,47597.955706984671,47597.955706984671,47597.955706984671]
[null,"Total in all RO",null,{"$f":"D76*'2. human resource'!$C$4","v":120},null,null,{"$f":"G76*'2. human resource'!$C$4","v":951959.11413969344},{"$f":"H76*'2. human resource'!$C$4","v":951959.11413969344},{"$f":"I76*'2. human resource'!$C$4","v":951959.11413969344},{"$f":"J76*'2. human resource'!$C$4","v":951959.11413969344},{"$f":"K76*'2. human resource'!$C$4","v":951959.11413969344},{"$f":"L76*'2. human resource'!$C$4","v":951959.11413969344},{"$f":"M76*'2. human resource'!$C$4","v":951959.11413969344},{"$f":"N76*'2. human resource'!$C$4","v":951959.11413969344},{"$f":"O76*'2. human resource'!$C$4","v":951959.11413969344},{"$f":"P76*'2. human resource'!$C$4","v":951959.11413969344},{"$f":"Q76*'2. human resource'!$C$4","v":951959.11413969344},{"$f":"R76*'2. human resource'!$C$4","v":951959.11413969344},{"$f":"S76*'2. human resource'!$C$4","v":951959.11413969344},{"$f":"T76*'2. human resource'!$C$4","v":951959.11413969344},{"$f":"U76*'2. human resource'!$C$4","v":951959.11413969344},{"$f":"V76*'2. human resource'!$C$4","v":951959.11413969344}]
[]
["District / municipal office"]
[null,"Operations ",null,1,"O3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E80,'0.3 HR compensation'!$L$13:$L$61,0))","v":7495.7410562180585},{"$f":"$F80*$D80","v":7495.7410562180585},7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585,7495.7410562180585]
[null,"GR/ IEC / technical support etc. ",null,1,"I4",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E81,'0.3 HR compensation'!$L$13:$L$61,0))","v":5996.5928449744461},5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461,5996.5928449744461]
[null,"Support staff ",null,1,"S3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E82,'0.3 HR compensation'!$L$13:$L$61,0))","v":2248.7223168654173},2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173,2248.7223168654173]
[null,"Total ",null,{"$f":"SUM(D80:D82)","v":3},null,null,{"$f":"SUM(G80:G82)","v":15741.056218057922},{"$f":"SUM(H80:H82)","v":15741.056218057922},15741.056218057922,15741.056218057922,15741.056218057922,15741.056218057922,15741.056218057922,15741.056218057922,15741.056218057922,15741.056218057922,15741.056218057922,15741.056218057922,15741.056218057922,15741.056218057922,15741.056218057922,15741.056218057922]
[null,"Total in all DO",null,{"$f":"D83*'2. human resource'!$D$4","v":2295},null,null,{"$f":"G83*'2. human resource'!$D$4","v":12041908.00681431},{"$f":"H83*'2. human resource'!$D$4","v":12041908.00681431},{"$f":"I83*'2. human resource'!$D$4","v":12041908.00681431},{"$f":"J83*'2. human resource'!$D$4","v":12041908.00681431},{"$f":"K83*'2. human resource'!$D$4","v":12041908.00681431},{"$f":"L83*'2. human resource'!$D$4","v":12041908.00681431},{"$f":"M83*'2. human resource'!$D$4","v":12041908.00681431},{"$f":"N83*'2. human resource'!$D$4","v":12041908.00681431},{"$f":"O83*'2. human resource'!$D$4","v":12041908.00681431},{"$f":"P83*'2. human resource'!$D$4","v":12041908.00681431},{"$f":"Q83*'2. human resource'!$D$4","v":12041908.00681431},{"$f":"R83*'2. human resource'!$D$4","v":12041908.00681431},{"$f":"S83*'2. human resource'!$D$4","v":12041908.00681431},{"$f":"T83*'2. human resource'!$D$4","v":12041908.00681431},{"$f":"U83*'2. human resource'!$D$4","v":12041908.00681431},{"$f":"V83*'2. human resource'!$D$4","v":12041908.00681431}]
[]
[null,"Enrolment operators",null,null,"S3",{"$f":"INDEX('0.3 HR compensation'!$K$13:$K$61,MATCH('2.1 Org_Structure'!E86,'0.3 HR compensation'!$L$13:$L$61,0))","v":2248.7223168654173},{"$f":"$F$86*'2. human resource'!$B$4*'2.1 Org_Structure'!G12","v":0},{"$f":"$F$86*'2. human resource'!$B$4*'2.1 Org_Structure'!H12","v":3647427.597955707},{"$f":"$F$86*'2. human resource'!$B$4*'2.1 Org_Structure'!I12","v":3840817.7172061326},{"$f":"$F$86*'2. human resource'!$B$4*'2.1 Org_Structure'!J12","v":3714889.2674616692},{"$f":"$F$86*'2. human resource'!$B$4*'2.1 Org_Structure'!K12","v":3552981.2606473593},{"$f":"$F$86*'2. human resource'!$B$4*'2.1 Org_Structure'!L12","v":3557478.70528109},{"$f":"$F$86*'2. human resource'!$B$4*'2.1 Org_Structure'!M12","v":3557478.70528109},{"$f":"$F$86*'2. human resource'!$B$4*'2.1 Org_Structure'!N12","v":3561976.1499148211},{"$f":"$F$86*'2. human resource'!$B$4*'2.1 Org_Structure'!O12","v":3566473.5945485518},{"$f":"$F$86*'2. human resource'!$B$4*'2.1 Org_Structure'!P12","v":3570971.0391822825},{"$f":"$F$86*'2. human resource'!$B$4*'2.1 Org_Structure'!Q12","v":3575468.4838160137},{"$f":"$F$86*'2. human resource'!$B$4*'2.1 Org_Structure'!R12","v":3579965.9284497444},{"$f":"$F$86*'2. human resource'!$B$4*'2.1 Org_Structure'!S12","v":3584463.373083475},{"$f":"$F$86*'2. human resource'!$B$4*'2.1 Org_Structure'!T12","v":3588960.8177172057},{"$f":"$F$86*'2. human resource'!$B$4*'2.1 Org_Structure'!U12","v":3593458.2623509369},{"$f":"$F$86*'2. human resource'!$B$4*'2.1 Org_Structure'!V12","v":3597955.7069846676}]
[]
[null,null,null,null,null,null,{"$f":"(G86+G84+G77+G58)/($D$58+$D$77+$D$84+2*G$12)","v":5474.5382932649054},4196.1914782832373,4156.1143431116816,4182.0211957601869,{"$f":"(K86+K84+K77+K58)/($D$58+$D$77+$D$84+2*K$12)","v":4216.3824693421229},{"$f":"(L86+L84+L77+L58)/($D$58+$D$77+$D$84+2*L$12)","v":4215.4115045493891},4215.4115045493891,4214.4414975517639,4213.4724469327411,4212.5043512786069]

{"sheet":"3. Helpdesk,IEC and T&CB","index":17,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":true,"merged":[[14,0,20,0],[22,0,23,0],[25,0,31,0],[33,0,34,0]]}
["Helpdesk, IEC, Training and capacity building cost estimation "]
[]
["Component","% people with grievances ","helpdesk through call center","helpdesk through enrolment stations ","helpdesk through online","Per hour cost for call center and online portal","Call center fixed cost","Per person IEC cost per year","Cost of training material","no. of operators that will be trained ","Total no. of service provider agencies","Per agency no. of operators who require training","Per training cost"]
["Value",0.02,{"$f":"'0.4 All inputs'!B25","v":0.3},{"$f":"'0.4 All inputs'!C25","v":0.5},{"$f":"1-D4-C4","v":0.2},{"$f":"'0.2 Unit cost  assumptions'!F23","v":14},{"$f":"'0.2 Unit cost  assumptions'!F24","v":50000},{"$f":"'0.4 All inputs'!G25/(completion_year-start_year+1)","v":0.16666666666666666},{"$f":"'0.2 Unit cost  assumptions'!F25","v":500000},{"$f":"'0.4 All inputs'!D25","v":1.25},{"$f":"'0.4 All inputs'!E25","v":100},{"$f":"'0.4 All inputs'!F25","v":5},{"$f":"'0.2 Unit cost  assumptions'!F26","v":2000}]
["Description ",null,null,null,null,null,"for toll free no. ","IEC outsourcing cost, includes print, social, tv, radio mediums","Video module, lecture module, assessment module, information booklet","% of actual required staff",null,null,"Cost of stationary item, cost of tutor, certification and facility cost"]
[]
[]
[]
[]
[]
[]
[null,"S.n",null,{"$f":"'1. Enrolment'!D13","v":0},{"$f":"'1. Enrolment'!E13","v":1},{"$f":"'1. Enrolment'!F13","v":2},{"$f":"'1. Enrolment'!G13","v":3},{"$f":"'1. Enrolment'!H13","v":4},{"$f":"'1. Enrolment'!I13","v":5},{"$f":"'1. Enrolment'!J13","v":6},{"$f":"'1. Enrolment'!K13","v":7},{"$f":"'1. Enrolment'!L13","v":8},{"$f":"'1. Enrolment'!M13","v":9},{"$f":"'1. Enrolment'!N13","v":10},{"$f":"'1. Enrolment'!O13","v":11},{"$f":"'1. Enrolment'!P13","v":12},{"$f":"'1. Enrolment'!Q13","v":13},{"$f":"'1. Enrolment'!R13","v":14},{"$f":"'1. Enrolment'!S13","v":15}]
[null,"Year",null,{"$f":"'1. Enrolment'!D14","v":2018},{"$f":"'1. Enrolment'!E14","v":2019},{"$f":"'1. Enrolment'!F14","v":2020},{"$f":"'1. Enrolment'!G14","v":2021},{"$f":"'1. Enrolment'!H14","v":2022},{"$f":"'1. Enrolment'!I14","v":2023},{"$f":"'1. Enrolment'!J14","v":2024},{"$f":"'1. Enrolment'!K14","v":2025},{"$f":"'1. Enrolment'!L14","v":2026},{"$f":"'1. Enrolment'!M14","v":2027},{"$f":"'1. Enrolment'!N14","v":2028},{"$f":"'1. Enrolment'!O14","v":2029},{"$f":"'1. Enrolment'!P14","v":2030},{"$f":"'1. Enrolment'!Q14","v":2031},{"$f":"'1. Enrolment'!R14","v":2032},{"$f":"'1. Enrolment'!S14","v":2033}]
[null,"population with ID",null,{"$f":"'1. Enrolment'!D26","v":0},{"$f":"'1. Enrolment'!E26","v":3038007.4615957192},{"$f":"'1. Enrolment'!F26","v":8193593.6304829065},{"$f":"'1. Enrolment'!G26","v":11412236.42835384},{"$f":"'1. Enrolment'!H26","v":12128883.778999448},{"$f":"'1. Enrolment'!I26","v":12866528.897018971},{"$f":"'1. Enrolment'!J26","v":13625787.016996467},{"$f":"'1. Enrolment'!K26","v":14407291.399889303},{"$f":"'1. Enrolment'!L26","v":15211693.861200901},{"$f":"'1. Enrolment'!M26","v":16039665.314628927},{"$f":"'1. Enrolment'!N26","v":16891896.331642393},{"$f":"'1. Enrolment'!O26","v":17769097.717454355},{"$f":"'1. Enrolment'!P26","v":18672001.103870608},{"$f":"'1. Enrolment'!Q26","v":19601359.559508856},{"$f":"'1. Enrolment'!R26","v":20557948.217897307},{"$f":"'1. Enrolment'!S26","v":21542564.923976541}]
["Helpdesk","population require helpdesk assistance",null,{"$f":"D14*$B$4","v":0},{"$f":"E14*$B$4","v":60760.149231914387},163871.87260965814,228244.72856707682,242577.67557998895,257330.57794037941,272515.74033992935,288145.82799778605,304233.87722401804,320793.30629257852,337837.92663284787,355381.95434908709,373440.02207741217,392027.19119017711,411158.96435794613,430851.29847953084]
[null,"Call center requests",null,{"$f":"D15*$C$4","v":0},{"$f":"E15*$C$4","v":18228.044769574317},49161.561782897443,68473.418570123045,72773.302673996688,77199.173382113819,81754.722101978798,86443.748399335818,91270.163167205406,96237.991887773547,101351.37798985436,106614.58630472612,112032.00662322364,117608.15735705313,123347.68930738383,129255.38954385924]
[null,"Enrolment stations requests","to enrolment sheet",{"$f":"D15*$D$4","v":0},{"$f":"E15*$D$4","v":30380.074615957194},81935.936304829069,114122.36428353841,121288.83778999448,128665.28897018971,136257.87016996468,144072.91399889303,152116.93861200902,160396.65314628926,168918.96331642393,177690.97717454354,186720.01103870608,196013.59559508855,205579.48217897306,215425.64923976542]
[null,"Online requests",null,{"$f":"D15*$E$4","v":0},{"$f":"E15*$E$4","v":12152.029846382879},32774.374521931626,45648.945713415364,48515.535115997794,51466.115588075889,54503.148067985872,57629.165599557215,60846.775444803614,64158.661258515705,67567.585326569577,71076.39086981742,74688.004415482443,78405.438238035422,82231.792871589234,86170.259695906178]
[null,"Call center hour requirement","time per request is equal to enrolment time ",{"$f":"D16*enrol_time/60","v":0},{"$f":"E16*enrol_time/60","v":2308.8856708127469},{"$f":"F16*enrol_time/60","v":6227.1311591670092},{"$f":"G16*enrol_time/60","v":8673.2996855489182},{"$f":"H16*enrol_time/60","v":9217.9516720395804},{"$f":"I16*enrol_time/60","v":9778.5619617344164},{"$f":"J16*enrol_time/60","v":10355.598132917314},{"$f":"K16*enrol_time/60","v":10949.54146391587},{"$f":"L16*enrol_time/60","v":11560.887334512685},{"$f":"M16*enrol_time/60","v":12190.145639117982},{"$f":"N16*enrol_time/60","v":12837.841212048219},{"$f":"O16*enrol_time/60","v":13504.514265265308},{"$f":"P16*enrol_time/60","v":14190.720838941661},{"$f":"Q16*enrol_time/60","v":14897.03326522673},{"$f":"R16*enrol_time/60","v":15624.040645601952},{"$f":"S16*enrol_time/60","v":16372.349342222171}]
[null,"Online portal support hour","time per request is equal to enrolment time ",{"$f":"D18*enrol_time/60","v":0},{"$f":"E18*enrol_time/60","v":1539.2571138751644},{"$f":"F18*enrol_time/60","v":4151.4207727780058},{"$f":"G18*enrol_time/60","v":5782.1997903659458},{"$f":"H18*enrol_time/60","v":6145.3011146930539},{"$f":"I18*enrol_time/60","v":6519.0413078229458},{"$f":"J18*enrol_time/60","v":6903.732088611544},{"$f":"K18*enrol_time/60","v":7299.6943092772462},{"$f":"L18*enrol_time/60","v":7707.2582230084572},{"$f":"M18*enrol_time/60","v":8126.7637594119888},{"$f":"N18*enrol_time/60","v":8558.5608080321454},{"$f":"O18*enrol_time/60","v":9003.0095101768729},{"$f":"P18*enrol_time/60","v":9460.4805592944413},{"$f":"Q18*enrol_time/60","v":9931.3555101511538},{"$f":"R18*enrol_time/60","v":10416.027097067968},{"$f":"S18*enrol_time/60","v":10914.89956148145}]
[null,"cost for call center and online portal ","opex",{"$f":"SUM(D20+D19)*$F$4+$G$4","v":50000},{"$f":"SUM(E20+E19)*$F$4+$G$4","v":103873.99898563075},195299.7270472302,252376.9926628081,265085.53901425691,278166.44577380305,291630.62310140399,305489.30082470365,319754.03780529601,334436.73157941957,349549.6282811251,365105.33285619057,381116.81957530545,397597.44285529037,414560.94839737884,432021.48465185071]
[]
["IEC","Eligible population for ID",null,{"$f":"'1. Enrolment'!D25","v":0},{"$f":"'1. Enrolment'!E25","v":3038007.4615957192},{"$f":"'1. Enrolment'!F25","v":5155586.1688871868},{"$f":"'1. Enrolment'!G25","v":3218642.7978709335},{"$f":"'1. Enrolment'!H25","v":716647.35064560734},{"$f":"'1. Enrolment'!I25","v":737645.11801952391},{"$f":"'1. Enrolment'!J25","v":759258.11997749575},{"$f":"'1. Enrolment'!K25","v":781504.38289283647},{"$f":"'1. Enrolment'!L25","v":804402.46131159668},{"$f":"'1. Enrolment'!M25","v":827971.45342802641},{"$f":"'1. Enrolment'!N25","v":852231.01701346773},{"$f":"'1. Enrolment'!O25","v":877201.38581196242},{"$f":"'1. Enrolment'!P25","v":902903.38641625305},{"$f":"'1. Enrolment'!Q25","v":929358.45563824929},{"$f":"'1. Enrolment'!R25","v":956588.65838845004},{"$f":"'1. Enrolment'!S25","v":984616.70607923169}]
[null,"Total IEC expenditure ","opex, expenditure will reduce in steady state ",{"$f":"IF(OR('1. Enrolment'!D17=0,'1. Enrolment'!D17=1),D23*$H$4,D23*$H$4*0.25)","v":0},{"$f":"IF(OR('1. Enrolment'!E17=0,'1. Enrolment'!E17=1),E23*$H$4,E23*$H$4*0.25)","v":506334.57693261985},{"$f":"IF(OR('1. Enrolment'!F17=0,'1. Enrolment'!F17=1),F23*$H$4,F23*$H$4*0.25)","v":859264.36148119776},{"$f":"IF(OR('1. Enrolment'!G17=0,'1. Enrolment'!G17=1),G23*$H$4,G23*$H$4*0.25)","v":536440.46631182218},{"$f":"IF(OR('1. Enrolment'!H17=0,'1. Enrolment'!H17=1),H23*$H$4,H23*$H$4*0.25)","v":29860.306276900305},{"$f":"IF(OR('1. Enrolment'!I17=0,'1. Enrolment'!I17=1),I23*$H$4,I23*$H$4*0.25)","v":30735.213250813496},{"$f":"IF(OR('1. Enrolment'!J17=0,'1. Enrolment'!J17=1),J23*$H$4,J23*$H$4*0.25)","v":31635.754999062323},{"$f":"IF(OR('1. Enrolment'!K17=0,'1. Enrolment'!K17=1),K23*$H$4,K23*$H$4*0.25)","v":32562.682620534852},{"$f":"IF(OR('1. Enrolment'!L17=0,'1. Enrolment'!L17=1),L23*$H$4,L23*$H$4*0.25)","v":33516.769221316528},{"$f":"IF(OR('1. Enrolment'!M17=0,'1. Enrolment'!M17=1),M23*$H$4,M23*$H$4*0.25)","v":34498.8105595011},{"$f":"IF(OR('1. Enrolment'!N17=0,'1. Enrolment'!N17=1),N23*$H$4,N23*$H$4*0.25)","v":35509.625708894484},{"$f":"IF(OR('1. Enrolment'!O17=0,'1. Enrolment'!O17=1),O23*$H$4,O23*$H$4*0.25)","v":36550.057742165096},{"$f":"IF(OR('1. Enrolment'!P17=0,'1. Enrolment'!P17=1),P23*$H$4,P23*$H$4*0.25)","v":37620.974434010539},{"$f":"IF(OR('1. Enrolment'!Q17=0,'1. Enrolment'!Q17=1),Q23*$H$4,Q23*$H$4*0.25)","v":38723.268984927054},{"$f":"IF(OR('1. Enrolment'!R17=0,'1. Enrolment'!R17=1),R23*$H$4,R23*$H$4*0.25)","v":39857.860766185418},{"$f":"IF(OR('1. Enrolment'!S17=0,'1. Enrolment'!S17=1),S23*$H$4,S23*$H$4*0.25)","v":41025.696086634649}]
[]
["Training and capacity building","Training material development cost",null,{"$f":"I4","v":500000}]
[null,"no. of operators require training",null,{"$f":"'2.1 Org_Structure'!G12*'2. human resource'!$B$4","v":0},{"$f":"'2.1 Org_Structure'!H12*'2. human resource'!$B$4","v":1622},{"$f":"'2.1 Org_Structure'!I12*'2. human resource'!$B$4","v":1708},{"$f":"'2.1 Org_Structure'!J12*'2. human resource'!$B$4","v":1652},{"$f":"'2.1 Org_Structure'!K12*'2. human resource'!$B$4","v":1580},{"$f":"'2.1 Org_Structure'!L12*'2. human resource'!$B$4","v":1582},{"$f":"'2.1 Org_Structure'!M12*'2. human resource'!$B$4","v":1582},{"$f":"'2.1 Org_Structure'!N12*'2. human resource'!$B$4","v":1584},{"$f":"'2.1 Org_Structure'!O12*'2. human resource'!$B$4","v":1586},{"$f":"'2.1 Org_Structure'!P12*'2. human resource'!$B$4","v":1588},{"$f":"'2.1 Org_Structure'!Q12*'2. human resource'!$B$4","v":1590},{"$f":"'2.1 Org_Structure'!R12*'2. human resource'!$B$4","v":1592},{"$f":"'2.1 Org_Structure'!S12*'2. human resource'!$B$4","v":1594},{"$f":"'2.1 Org_Structure'!T12*'2. human resource'!$B$4","v":1596},{"$f":"'2.1 Org_Structure'!U12*'2. human resource'!$B$4","v":1598},{"$f":"'2.1 Org_Structure'!V12*'2. human resource'!$B$4","v":1600}]
[null,"No. of staff members",null,{"$f":"'2.1 Org_Structure'!$D$58+'2.1 Org_Structure'!$D$77+'2.1 Org_Structure'!$D$84","v":2471},{"$f":"'2.1 Org_Structure'!$D$58+'2.1 Org_Structure'!$D$77+'2.1 Org_Structure'!$D$84","v":2471},{"$f":"'2.1 Org_Structure'!$D$58+'2.1 Org_Structure'!$D$77+'2.1 Org_Structure'!$D$84","v":2471},{"$f":"'2.1 Org_Structure'!$D$58+'2.1 Org_Structure'!$D$77+'2.1 Org_Structure'!$D$84","v":2471},{"$f":"'2.1 Org_Structure'!$D$58+'2.1 Org_Structure'!$D$77+'2.1 Org_Structure'!$D$84","v":2471},{"$f":"'2.1 Org_Structure'!$D$58+'2.1 Org_Structure'!$D$77+'2.1 Org_Structure'!$D$84","v":2471},{"$f":"'2.1 Org_Structure'!$D$58+'2.1 Org_Structure'!$D$77+'2.1 Org_Structure'!$D$84","v":2471},{"$f":"'2.1 Org_Structure'!$D$58+'2.1 Org_Structure'!$D$77+'2.1 Org_Structure'!$D$84","v":2471},{"$f":"'2.1 Org_Structure'!$D$58+'2.1 Org_Structure'!$D$77+'2.1 Org_Structure'!$D$84","v":2471},{"$f":"'2.1 Org_Structure'!$D$58+'2.1 Org_Structure'!$D$77+'2.1 Org_Structure'!$D$84","v":2471},{"$f":"'2.1 Org_Structure'!$D$58+'2.1 Org_Structure'!$D$77+'2.1 Org_Structure'!$D$84","v":2471},{"$f":"'2.1 Org_Structure'!$D$58+'2.1 Org_Structure'!$D$77+'2.1 Org_Structure'!$D$84","v":2471},{"$f":"'2.1 Org_Structure'!$D$58+'2.1 Org_Structure'!$D$77+'2.1 Org_Structure'!$D$84","v":2471},{"$f":"'2.1 Org_Structure'!$D$58+'2.1 Org_Structure'!$D$77+'2.1 Org_Structure'!$D$84","v":2471},{"$f":"'2.1 Org_Structure'!$D$58+'2.1 Org_Structure'!$D$77+'2.1 Org_Structure'!$D$84","v":2471},{"$f":"'2.1 Org_Structure'!$D$58+'2.1 Org_Structure'!$D$77+'2.1 Org_Structure'!$D$84","v":2471}]
[null,"Service agency operator required training",null,null,{"$f":"$K$4*$L$4","v":500}]
[null,"People require training","Training and capacity building",{"$f":"MAX($D$27:$S$27)*$J$4+D28+D29","v":4606},{"$f":"D30*0.25+E29","v":1651.5},{"$f":"(F28+F27)*0.25","v":1044.75},{"$f":"(G28+G27)*0.25","v":1030.75},1012.75,1013.25,1013.25,1013.75,1014.25,1014.75,1015.25,1015.75,1016.25,1016.75,1017.25,1017.75]
[null,"Training per batch ",null,{"$f":"ROUND(D30/15,0)","v":307},{"$f":"ROUND(E30/15,0)","v":110},70,69,68,68,68,68,68,68,68,68,68,68,68,68]
[null,"Training per batch ","opex",{"$f":"D31*$M$4","v":614000},{"$f":"E31*$M$4","v":220000},140000,138000,136000,136000,136000,136000,136000,136000,136000,136000,136000,136000,136000,136000]
[]
["Overall","Capital expenditure",null,{"$f":"D26","v":500000}]
[null,"Operational expenditure",null,{"$f":"D32+D24+D21","v":664000},{"$f":"E32+E24+E21","v":830208.57591825048},1194564.088528428,926817.45897463034,430945.84529115725,444901.65902461653,459266.37810046633,474051.9834452385,489270.80702661257,504935.54213892069,521059.25399001956,537655.39059835568,554737.79400931601,572320.71184021747,590418.80916356423,609047.18073848542]

{"sheet":"4. Software","index":18,"n_rows":39,"n_cols":19,"rows_kept":39,"cut":false,"hidden":true,"merged":[[30,0,36,0],[37,0,38,0]]}
["Software development cost estimation "]
[]
["Component","Deduplication cost for one biometric","Software AMC cost","Request require manual deduplication ","Per manual dedup time (in minutes)","Manual dedup personnel cost per year","No. of biometric captured","Add on cost for additional biometric ","Per dedup cost","Per manual quality check time (in minutes)"]
["Value",{"$f":"'0.2 Unit cost  assumptions'!F37","v":0.25},{"$f":"'0.4 All inputs'!A30","v":0.25},{"$f":"IF(G4=0,0,'0.4 All inputs'!B30)","v":0.05},{"$f":"'0.4 All inputs'!C30","v":10},{"$f":"'0.3 HR compensation'!K59","v":2623.5093696763206},{"$f":"'0.4 All inputs'!B11+'0.4 All inputs'!D11+'0.4 All inputs'!G11","v":2},{"$f":"'0.2 Unit cost  assumptions'!F38","v":0.1},{"$f":"IF(G4=0, 0,IF(G4=1,0.25,B4+H4))","v":0.35},1.728]
["Description ",null,"as percentage of cost of software development",null,null,null,"Facial image not included, cost of deduplication is estimated based on the no. of biometric captured."]
[]
[]
[]
[]
[]
[]
[null,"S.n",null,{"$f":"'3. Helpdesk,IEC and T&CB'!D12","v":0},{"$f":"'3. Helpdesk,IEC and T&CB'!E12","v":1},{"$f":"'3. Helpdesk,IEC and T&CB'!F12","v":2},{"$f":"'3. Helpdesk,IEC and T&CB'!G12","v":3},{"$f":"'3. Helpdesk,IEC and T&CB'!H12","v":4},{"$f":"'3. Helpdesk,IEC and T&CB'!I12","v":5},{"$f":"'3. Helpdesk,IEC and T&CB'!J12","v":6},{"$f":"'3. Helpdesk,IEC and T&CB'!K12","v":7},{"$f":"'3. Helpdesk,IEC and T&CB'!L12","v":8},{"$f":"'3. Helpdesk,IEC and T&CB'!M12","v":9},{"$f":"'3. Helpdesk,IEC and T&CB'!N12","v":10},{"$f":"'3. Helpdesk,IEC and T&CB'!O12","v":11},{"$f":"'3. Helpdesk,IEC and T&CB'!P12","v":12},{"$f":"'3. Helpdesk,IEC and T&CB'!Q12","v":13},{"$f":"'3. Helpdesk,IEC and T&CB'!R12","v":14},{"$f":"'3. Helpdesk,IEC and T&CB'!S12","v":15}]
[null,"Year",null,{"$f":"'3. Helpdesk,IEC and T&CB'!D13","v":2018},{"$f":"'3. Helpdesk,IEC and T&CB'!E13","v":2019},{"$f":"'3. Helpdesk,IEC and T&CB'!F13","v":2020},{"$f":"'3. Helpdesk,IEC and T&CB'!G13","v":2021},{"$f":"'3. Helpdesk,IEC and T&CB'!H13","v":2022},{"$f":"'3. Helpdesk,IEC and T&CB'!I13","v":2023},{"$f":"'3. Helpdesk,IEC and T&CB'!J13","v":2024},{"$f":"'3. Helpdesk,IEC and T&CB'!K13","v":2025},{"$f":"'3. Helpdesk,IEC and T&CB'!L13","v":2026},{"$f":"'3. Helpdesk,IEC and T&CB'!M13","v":2027},{"$f":"'3. Helpdesk,IEC and T&CB'!N13","v":2028},{"$f":"'3. Helpdesk,IEC and T&CB'!O13","v":2029},{"$f":"'3. Helpdesk,IEC and T&CB'!P13","v":2030},{"$f":"'3. Helpdesk,IEC and T&CB'!Q13","v":2031},{"$f":"'3. Helpdesk,IEC and T&CB'!R13","v":2032},{"$f":"'3. Helpdesk,IEC and T&CB'!S13","v":2033}]
["Capital expenditure",{"$f":"'0.2 Unit cost  assumptions'!E27","v":"Enrolment client and server"},null,{"$f":"'0.2 Unit cost  assumptions'!F27","v":650000}]
[null,{"$f":"'0.2 Unit cost  assumptions'!E28","v":"Data synchronization software "},null,{"$f":"'0.2 Unit cost  assumptions'!F28","v":50000}]
[null,{"$f":"'0.2 Unit cost  assumptions'!E29","v":"Data validation tool "},null,{"$f":"'0.2 Unit cost  assumptions'!F29","v":50000}]
[null,{"$f":"'0.2 Unit cost  assumptions'!E30","v":"CRM tool "},null,{"$f":"'0.2 Unit cost  assumptions'!F30","v":50000}]
[null,{"$f":"'0.2 Unit cost  assumptions'!E31","v":"Verification client and server"},null,{"$f":"'0.2 Unit cost  assumptions'!F31","v":150000}]
[null,{"$f":"'0.2 Unit cost  assumptions'!E32","v":"Notification system "},null,{"$f":"'0.2 Unit cost  assumptions'!F32","v":25000}]
[null,{"$f":"'0.2 Unit cost  assumptions'!E33","v":"identity and access management system"},null,{"$f":"'0.2 Unit cost  assumptions'!F33","v":50000}]
[null,{"$f":"'0.2 Unit cost  assumptions'!E34","v":"Portal"},null,{"$f":"'0.2 Unit cost  assumptions'!F34","v":200000}]
[null,{"$f":"'0.2 Unit cost  assumptions'!E35","v":"Fraud detection system"},null,{"$f":"'0.2 Unit cost  assumptions'!F35","v":50000}]
[null,"Caching ",null,{"$f":"'0.2 Unit cost  assumptions'!F82","v":100000}]
[null,"Clustering",null,{"$f":"'0.2 Unit cost  assumptions'!F83","v":100000}]
[null,"Biometric verification",null,{"$f":"'0.2 Unit cost  assumptions'!F80","v":200000}]
[null,"Replication software",null,{"$f":"'0.2 Unit cost  assumptions'!F84","v":100000}]
[null,"Middle ware for DC",null,{"$f":"'0.2 Unit cost  assumptions'!F78","v":400000}]
[null,"VM",null,{"$f":"'0.2 Unit cost  assumptions'!F85","v":100000}]
[null,"Database",null,{"$f":"'0.2 Unit cost  assumptions'!F79","v":100000}]
[null,"Demographic data verification ",null,{"$f":"'0.2 Unit cost  assumptions'!F81","v":50000}]
["Operation expenditure","Software AMC",null,null,{"$f":"SUM($D$14:$D$30)*Software_AMC_cost","v":606250},606250,606250,606250,606250,606250,606250,606250,606250,606250,606250,606250,606250,606250,606250]
[null,"Quality check cost",null,null,{"$f":"(('1. Enrolment'!E25*$J$4/60)/(Fixed_efficiency*Work_days*work_hour))*'0.3 HR compensation'!$K$59","v":163959.24426465487},{"$f":"(('1. Enrolment'!F25*$J$4/60)/(Fixed_efficiency*Work_days*work_hour))*'0.3 HR compensation'!$K$59","v":278243.56018798315},{"$f":"(('1. Enrolment'!G25*$J$4/60)/(Fixed_efficiency*Work_days*work_hour))*'0.3 HR compensation'!$K$59","v":173708.01335017238},{"$f":"(('1. Enrolment'!H25*$J$4/60)/(Fixed_efficiency*Work_days*work_hour))*'0.3 HR compensation'!$K$59","v":38676.981377262084},{"$f":"(('1. Enrolment'!I25*$J$4/60)/(Fixed_efficiency*Work_days*work_hour))*'0.3 HR compensation'!$K$59","v":39810.216931615876},{"$f":"(('1. Enrolment'!J25*$J$4/60)/(Fixed_efficiency*Work_days*work_hour))*'0.3 HR compensation'!$K$59","v":40976.656287712212},{"$f":"(('1. Enrolment'!K25*$J$4/60)/(Fixed_efficiency*Work_days*work_hour))*'0.3 HR compensation'!$K$59","v":42177.272316942188},{"$f":"(('1. Enrolment'!L25*$J$4/60)/(Fixed_efficiency*Work_days*work_hour))*'0.3 HR compensation'!$K$59","v":43413.066395828602},{"$f":"(('1. Enrolment'!M25*$J$4/60)/(Fixed_efficiency*Work_days*work_hour))*'0.3 HR compensation'!$K$59","v":44685.069241226367},{"$f":"(('1. Enrolment'!N25*$J$4/60)/(Fixed_efficiency*Work_days*work_hour))*'0.3 HR compensation'!$K$59","v":45994.341769994309},{"$f":"(('1. Enrolment'!O25*$J$4/60)/(Fixed_efficiency*Work_days*work_hour))*'0.3 HR compensation'!$K$59","v":47341.975983855147},{"$f":"(('1. Enrolment'!P25*$J$4/60)/(Fixed_efficiency*Work_days*work_hour))*'0.3 HR compensation'!$K$59","v":48729.095880182118},{"$f":"(('1. Enrolment'!Q25*$J$4/60)/(Fixed_efficiency*Work_days*work_hour))*'0.3 HR compensation'!$K$59","v":50156.858389471447},{"$f":"(('1. Enrolment'!R25*$J$4/60)/(Fixed_efficiency*Work_days*work_hour))*'0.3 HR compensation'!$K$59","v":51626.454340282966},{"$f":"(('1. Enrolment'!S25*$J$4/60)/(Fixed_efficiency*Work_days*work_hour))*'0.3 HR compensation'!$K$59","v":53139.10945245326}]
[null,"Yearly deduplication request",null,{"$f":"'1. Enrolment'!D25","v":0},{"$f":"'1. Enrolment'!E25","v":3038007.4615957192},{"$f":"'1. Enrolment'!F25","v":5155586.1688871868},{"$f":"'1. Enrolment'!G25","v":3218642.7978709335},{"$f":"'1. Enrolment'!H25","v":716647.35064560734},{"$f":"'1. Enrolment'!I25","v":737645.11801952391},{"$f":"'1. Enrolment'!J25","v":759258.11997749575},{"$f":"'1. Enrolment'!K25","v":781504.38289283647},{"$f":"'1. Enrolment'!L25","v":804402.46131159668},{"$f":"'1. Enrolment'!M25","v":827971.45342802641},{"$f":"'1. Enrolment'!N25","v":852231.01701346773},{"$f":"'1. Enrolment'!O25","v":877201.38581196242},{"$f":"'1. Enrolment'!P25","v":902903.38641625305},{"$f":"'1. Enrolment'!Q25","v":929358.45563824929},{"$f":"'1. Enrolment'!R25","v":956588.65838845004},{"$f":"'1. Enrolment'!S25","v":984616.70607923169}]
[null,"Deduplication cost",null,{"$f":"D33*$I$4","v":0},{"$f":"E33*$I$4","v":1063302.6115585016},{"$f":"F33*$I$4","v":1804455.1591105154},1126524.9792548267,250826.57272596256,258175.79130683336,265740.34199212352,273526.53401249275,281540.86145905883,289790.0086998092,298280.85595471371,307020.4850341868,316016.18524568854,325275.45947338722,334806.03043595748,344615.84712773107]
[null,"Manual deduplication required",null,{"$f":"D33*$D$4","v":0},{"$f":"E33*$D$4","v":151900.37307978596},257779.30844435934,160932.1398935467,35832.367532280368,36882.255900976197,37962.90599887479,39075.219144641822,40220.123065579835,41398.572671401322,42611.55085067339,43860.069290598127,45145.169320812653,46467.922781912464,47829.432919422507,49230.83530396159]
[null,"Personnel required for manual dedup",null,0,{"$f":"ROUNDUP(E35*$E$4/(Work_days*work_hour*Fixed_efficiency*60),0)","v":19},{"$f":"ROUNDUP(F35*$E$4/(Work_days*work_hour*Fixed_efficiency*60),0)","v":31},20,5,5,5,5,5,5,6,6,6,6,6,6]
[null,"Personnel cost",null,{"$f":"D36*$F$4","v":0},{"$f":"E36*$F$4","v":49846.678023850094},81328.790459965938,52470.187393526416,13117.546848381604,13117.546848381604,13117.546848381604,13117.546848381604,13117.546848381604,13117.546848381604,15741.056218057924,15741.056218057924,15741.056218057924,15741.056218057924,15741.056218057924,15741.056218057924]
["Total","Capital expenditure",null,{"$f":"SUM(D14:D30)","v":2425000}]
[null,"operational expenditure",null,{"$f":"D37+D34+D31","v":0},{"$f":"E37+E34+E32+E31","v":1883358.5338470065},{"$f":"F37+F34+F32+F31","v":2770277.5097584645},1958953.1799985254,908871.10095160617,917353.55508683086,926084.54512821732,935071.35317781649,944321.47470326908,953842.62478941714,966266.25394276599,976353.51723609981,986736.33734392864,997423.37408091663,1008423.5409942984,1019746.0127982423]

{"sheet":"5. Facility cost","index":19,"n_rows":27,"n_cols":19,"rows_kept":27,"cut":false,"hidden":true,"merged":[[13,0,15,0],[17,0,19,0],[21,0,23,0],[25,0,26,0]]}
["Administration Cost estimation "]
[]
["Component","No. of Regional offices required","No. of district office required","HQ office space requirement","Regional office space requirement","District office space requirement","Per person work station setup cost","per sq. ft. office setup cost","Per person operating office expenses","Per sq. ft. office operating cost","per sq. ft. rent"]
["Value",{"$f":"'2. human resource'!C4","v":20},{"$f":"'2. human resource'!D4","v":765},{"$f":"'0.4 All inputs'!A35","v":15000},{"$f":"'0.4 All inputs'!B35","v":5000},{"$f":"'0.4 All inputs'!C35","v":1000},{"$f":"'0.2 Unit cost  assumptions'!F39","v":1000},{"$f":"'0.2 Unit cost  assumptions'!F40","v":75},{"$f":"'0.2 Unit cost  assumptions'!F41","v":300},{"$f":"'0.2 Unit cost  assumptions'!F42","v":7},{"$f":"'0.2 Unit cost  assumptions'!F43","v":5}]
["Description ",null,null,"sq. ft.","sq. ft.","sq. ft.","laptop, table chair etc.",null,"stationary , snack etc.","including maintenance, repair, internet , admin , cleaning cost (for RO and DO), excluding rent "]
[]
["Component","no. of personnel at HQ","No. of personnel at RO","No. of personnel at DO","Shared human resources with CRVS","Reduction in human resources cost due to CRVS linkages"]
["Value",{"$f":"'2.1 Org_Structure'!D58","v":56},{"$f":"'2.1 Org_Structure'!D76","v":6},{"$f":"'2.1 Org_Structure'!D83","v":3},{"$f":"'0.4 All inputs'!A58","v":0},{"$f":"'0.4 All inputs'!C58","v":0.3}]
["Description ",null,null,null,"yes=1 , no = 0 ","yes=1 , no = 0 "]
[]
[]
[null,null,null,{"$f":"'4. Software'!D12","v":0},{"$f":"'4. Software'!E12","v":1},{"$f":"'4. Software'!F12","v":2},{"$f":"'4. Software'!G12","v":3},{"$f":"'4. Software'!H12","v":4},{"$f":"'4. Software'!I12","v":5},{"$f":"'4. Software'!J12","v":6},{"$f":"'4. Software'!K12","v":7},{"$f":"'4. Software'!L12","v":8},{"$f":"'4. Software'!M12","v":9},{"$f":"'4. Software'!N12","v":10},{"$f":"'4. Software'!O12","v":11},{"$f":"'4. Software'!P12","v":12},{"$f":"'4. Software'!Q12","v":13},{"$f":"'4. Software'!R12","v":14},{"$f":"'4. Software'!S12","v":15}]
[null,null,null,{"$f":"'4. Software'!D13","v":2018},{"$f":"'4. Software'!E13","v":2019},{"$f":"'4. Software'!F13","v":2020},{"$f":"'4. Software'!G13","v":2021},{"$f":"'4. Software'!H13","v":2022},{"$f":"'4. Software'!I13","v":2023},{"$f":"'4. Software'!J13","v":2024},{"$f":"'4. Software'!K13","v":2025},{"$f":"'4. Software'!L13","v":2026},{"$f":"'4. Software'!M13","v":2027},{"$f":"'4. Software'!N13","v":2028},{"$f":"'4. Software'!O13","v":2029},{"$f":"'4. Software'!P13","v":2030},{"$f":"'4. Software'!Q13","v":2031},{"$f":"'4. Software'!R13","v":2032},{"$f":"'4. Software'!S13","v":2033}]
["headquarter","Headquarter setup cost","Capex",{"$f":"$B$8*G4+H4*D4","v":1181000}]
[null,"Headquarter operating cost  ","opex",{"$f":"$D$4*$J$4+$I$4*$B$8","v":121800},{"$f":"$D$4*$J$4+$I$4*$B$8","v":121800},121800,121800,121800,121800,121800,121800,121800,121800,121800,121800,121800,121800,121800,121800]
[null,"HQ rent","opex",{"$f":"$D$4*$K$4","v":75000},{"$f":"$D$4*$K$4","v":75000},75000,75000,75000,75000,75000,75000,75000,75000,75000,75000,75000,75000,75000,75000]
[]
["Regional office","Setup cost","Capex",{"$f":"(C8*G4+E4*H4)*B4","v":7620000}]
[null,"operating expenditure","opex",{"$f":"($C$8*$I$4+$J$4*$E$4)*$B$4","v":736000},{"$f":"($C$8*$I$4+$J$4*$E$4)*$B$4","v":736000},736000,736000,736000,736000,736000,736000,736000,736000,736000,736000,736000,736000,736000,736000]
[null,"Rent","opex",{"$f":"$B$4*$E$4*$K$4","v":500000},{"$f":"$B$4*$E$4*$K$4","v":500000},500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,{"$f":"$B$4*$E$4*$K$4","v":500000}]
[]
["District office ","Setup cost","Capex",{"$f":"(D8*G4+H4*F4)*C4","v":59670000}]
[null,"operating expenditure","opex",{"$f":"($F$4*$J$4+$I$4*$D$8)*$C$4","v":6043500},{"$f":"($F$4*$J$4+$I$4*$D$8)*$C$4","v":6043500},6043500,6043500,6043500,6043500,6043500,6043500,6043500,6043500,6043500,6043500,6043500,6043500,6043500,6043500]
[null,"Rent","opex",{"$f":"$C$4*$F$4*$K$4","v":3825000},{"$f":"$C$4*$F$4*$K$4","v":3825000},3825000,3825000,3825000,3825000,3825000,3825000,3825000,3825000,3825000,3825000,3825000,3825000,3825000,3825000]
[]
["Overall","Capital expenditure",null,{"$f":"(D22+D18+D14)*(1-$E$8*$F$8)","v":68471000}]
[null,"Operational expenditure",null,{"$f":"(D24+D23+D20+D19+D16+D15)*(1-$E$8*$F$8)","v":11301300},{"$f":"(E24+E23+E20+E19+E16+E15)*(1-$E$8*$F$8)","v":11301300},11301300,11301300,11301300,11301300,11301300,11301300,11301300,11301300,11301300,11301300,11301300,11301300,11301300,11301300]

{"sheet":"6. Identity Credential","index":20,"n_rows":17,"n_cols":18,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Identity Credential Cost Estimation "]
[]
["Component","Credential Choice ","Type of Barcode ","Type of chip based card","Mag strip ","Type of Material ","Type of security ","Delivery Cost","ID to be reissued"]
["Value",{"$f":"'0.4 All inputs'!A40","v":1},{"$f":"'0.4 All inputs'!B40","v":2},{"$f":"'0.4 All inputs'!C40","v":4},{"$f":"'0.4 All inputs'!D40","v":1},{"$f":"'0.4 All inputs'!E40","v":3},{"$f":"'0.4 All inputs'!F40","v":3},{"$f":"'0.2 Unit cost  assumptions'!F64","v":0.1},{"$f":"MIN('0.4 All inputs'!G40,'0.4 All inputs'!A25)","v":0.03}]
["Description ","0 = No credential only UIN, 1 = eID, 2 = non electronic ID","0 = no barcode, 1= 1D barcode, 2 = 2D barcode","0 = no chip, 1 = contact, 2 = contacless, 3 = Dual interface, 4 = hybrid","0 = no, 1 = yes","0 = no material, 1 = paper, 2= PVC, 3 = PC, 4 = PET, 5 = Teslin, 6 = Composite (PC+PVC)","0 = no security, 1 = level 1, 2 = level 2, 3 = level 3",null,"Due to lost or damage"]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'5. Facility cost'!D12","v":0},{"$f":"'5. Facility cost'!E12","v":1},{"$f":"'5. Facility cost'!F12","v":2},{"$f":"'5. Facility cost'!G12","v":3},{"$f":"'5. Facility cost'!H12","v":4},{"$f":"'5. Facility cost'!I12","v":5},{"$f":"'5. Facility cost'!J12","v":6},{"$f":"'5. Facility cost'!K12","v":7},{"$f":"'5. Facility cost'!L12","v":8},{"$f":"'5. Facility cost'!M12","v":9},{"$f":"'5. Facility cost'!N12","v":10},{"$f":"'5. Facility cost'!O12","v":11},{"$f":"'5. Facility cost'!P12","v":12},{"$f":"'5. Facility cost'!Q12","v":13},{"$f":"'5. Facility cost'!R12","v":14},{"$f":"'5. Facility cost'!S12","v":15}]
[null,null,{"$f":"'5. Facility cost'!D13","v":2018},{"$f":"'5. Facility cost'!E13","v":2019},{"$f":"'5. Facility cost'!F13","v":2020},{"$f":"'5. Facility cost'!G13","v":2021},{"$f":"'5. Facility cost'!H13","v":2022},{"$f":"'5. Facility cost'!I13","v":2023},{"$f":"'5. Facility cost'!J13","v":2024},{"$f":"'5. Facility cost'!K13","v":2025},{"$f":"'5. Facility cost'!L13","v":2026},{"$f":"'5. Facility cost'!M13","v":2027},{"$f":"'5. Facility cost'!N13","v":2028},{"$f":"'5. Facility cost'!O13","v":2029},{"$f":"'5. Facility cost'!P13","v":2030},{"$f":"'5. Facility cost'!Q13","v":2031},{"$f":"'5. Facility cost'!R13","v":2032},{"$f":"'5. Facility cost'!S13","v":2033}]
["No. ID to be issued each year",null,{"$f":"'1. Enrolment'!D25","v":0},{"$f":"'1. Enrolment'!E25","v":3038007.4615957192},{"$f":"'1. Enrolment'!F25","v":5155586.1688871868},{"$f":"'1. Enrolment'!G25","v":3218642.7978709335},{"$f":"'1. Enrolment'!H25","v":716647.35064560734},{"$f":"'1. Enrolment'!I25","v":737645.11801952391},{"$f":"'1. Enrolment'!J25","v":759258.11997749575},{"$f":"'1. Enrolment'!K25","v":781504.38289283647},{"$f":"'1. Enrolment'!L25","v":804402.46131159668},{"$f":"'1. Enrolment'!M25","v":827971.45342802641},{"$f":"'1. Enrolment'!N25","v":852231.01701346773},{"$f":"'1. Enrolment'!O25","v":877201.38581196242},{"$f":"'1. Enrolment'!P25","v":902903.38641625305},{"$f":"'1. Enrolment'!Q25","v":929358.45563824929},{"$f":"'1. Enrolment'!R25","v":956588.65838845004},{"$f":"'1. Enrolment'!S25","v":984616.70607923169}]
["No. of ID to be reissued ","due to lost or damage",{"$f":"C14*$I$4","v":0},{"$f":"D14*$I$4","v":91140.223847871574},154667.5850666156,96559.283936128006,21499.420519368221,22129.353540585718,22777.743599324873,23445.131486785092,24132.073839347901,24839.143602840792,25566.930510404032,26316.041574358871,27087.10159248759,27880.753669147478,28697.6597516535,29538.501182376949]
["total id to be issued ",null,{"$f":"C15+C14","v":0},{"$f":"D15+D14","v":3129147.6854435909},5310253.7539538024,3315202.0818070616,738146.77116497559,759774.47156010964,782035.86357682059,804949.5143796216,828534.5351509446,852810.59703086724,877797.94752387179,903517.42738632124,929990.48800874059,957239.20930739678,985286.3181401036,1014155.2072616087]
["Total cost ","opex",{"$f":"C16*'6.1 Feature cost '!$F$32","v":0},{"$f":"D16*'6.1 Feature cost '!$F$32","v":12516590.741774363},{"$f":"E16*'6.1 Feature cost '!$F$32","v":21241015.01581521},{"$f":"F16*'6.1 Feature cost '!$F$32","v":13260808.327228246},{"$f":"G16*'6.1 Feature cost '!$F$32","v":2952587.0846599024},{"$f":"H16*'6.1 Feature cost '!$F$32","v":3039097.8862404386},{"$f":"I16*'6.1 Feature cost '!$F$32","v":3128143.4543072823},{"$f":"J16*'6.1 Feature cost '!$F$32","v":3219798.0575184864},{"$f":"K16*'6.1 Feature cost '!$F$32","v":3314138.1406037784},{"$f":"L16*'6.1 Feature cost '!$F$32","v":3411242.388123469},{"$f":"M16*'6.1 Feature cost '!$F$32","v":3511191.7900954871},{"$f":"N16*'6.1 Feature cost '!$F$32","v":3614069.709545285},{"$f":"O16*'6.1 Feature cost '!$F$32","v":3719961.9520349624},{"$f":"P16*'6.1 Feature cost '!$F$32","v":3828956.8372295871},{"$f":"Q16*'6.1 Feature cost '!$F$32","v":3941145.2725604144},{"$f":"R16*'6.1 Feature cost '!$F$32","v":4056620.8290464347}]

{"sheet":"6.1 Feature cost ","index":21,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
["Input no. ","Type ","Cost per unit ","Included or not","Default value due to selection ","Cost ","Description "]
[0,"No credential ",0,{"$f":"IF('6. Identity Credential'!$B$4='6.1 Feature cost '!A3,1,0)","v":0},{"$f":"D3","v":0},{"$f":"E3*D3*C3","v":0}]
[1,"eID",0,{"$f":"IF('6. Identity Credential'!$B$4='6.1 Feature cost '!A4,1,0)","v":1},{"$f":"D4","v":1},{"$f":"E4*D4*C4","v":0}]
[2,"Non electronic ID",0,{"$f":"IF('6. Identity Credential'!$B$4='6.1 Feature cost '!A5,1,0)","v":0},0,0]
[0,"No barcode",0,{"$f":"IF('6. Identity Credential'!$C$4='6.1 Feature cost '!A6,1,0)","v":0},{"$f":"IF($D$3=1,1,D6)","v":0},0]
[1,"1D barcode",{"$f":"'0.2 Unit cost  assumptions'!F45","v":0.1},{"$f":"IF('6. Identity Credential'!$C$4='6.1 Feature cost '!A7,1,0)","v":0},{"$f":"IF($D$3=1,0,D7)","v":0},0]
[2,"2D barcode",{"$f":"'0.2 Unit cost  assumptions'!F46","v":0.1},{"$f":"IF('6. Identity Credential'!$C$4='6.1 Feature cost '!A8,1,0)","v":1},{"$f":"IF($D$3=1,0,D8)","v":1},0.1]
[0,"no chip ",0,{"$f":"IF('6. Identity Credential'!$D$4='6.1 Feature cost '!A9,1,0)","v":0},{"$f":"IF(OR($D$3=1,$D$5=1),1,D9)","v":0},0]
[1,"contact ",{"$f":"'0.2 Unit cost  assumptions'!F47","v":0.6},{"$f":"IF('6. Identity Credential'!$D$4='6.1 Feature cost '!A10,1,0)","v":0},{"$f":"IF($E$9=1,0,D10)","v":0},0]
[2,"contactless",{"$f":"'0.2 Unit cost  assumptions'!F48","v":0.7},{"$f":"IF('6. Identity Credential'!$D$4='6.1 Feature cost '!A11,1,0)","v":0},{"$f":"IF($E$9=1,0,D11)","v":0},0]
[3,"Dual interface",{"$f":"'0.2 Unit cost  assumptions'!F49","v":0.8},{"$f":"IF('6. Identity Credential'!$D$4='6.1 Feature cost '!A12,1,0)","v":0},0,0]
[4,"Hybrid",{"$f":"'0.2 Unit cost  assumptions'!F50","v":1.2},{"$f":"IF('6. Identity Credential'!$D$4='6.1 Feature cost '!A13,1,0)","v":1},1,1.2]
[0,"No mag strip ",0,{"$f":"IF('6. Identity Credential'!$E$4=A14,1,0)","v":0},{"$f":"IF(D3=1,1,D14)","v":0},0]
[1,"Mag strip ",{"$f":"'0.2 Unit cost  assumptions'!F51","v":0.5},{"$f":"IF('6. Identity Credential'!$E$4=A15,1,0)","v":1},{"$f":"IF(E14=1,0,D15)","v":1},0.5]
[0,"No material ",0,{"$f":"IF(A16='6. Identity Credential'!$F$4,1,0)","v":0},{"$f":"IF(D3=1,1,0)","v":0},0]
[1,"Paper card (laminated)",{"$f":"'0.2 Unit cost  assumptions'!F52","v":0.02},{"$f":"IF(A17='6. Identity Credential'!$F$4,1,0)","v":0},{"$f":"IF($E$16=1,0,D17)","v":0},0]
[2,"PVC",{"$f":"'0.2 Unit cost  assumptions'!F53","v":0.2},{"$f":"IF(A18='6. Identity Credential'!$F$4,1,0)","v":0},0,0]
[3,"PC",{"$f":"'0.2 Unit cost  assumptions'!F54","v":0.6},{"$f":"IF(A19='6. Identity Credential'!$F$4,1,0)","v":1},1,0.6]
[4,"PET",{"$f":"'0.2 Unit cost  assumptions'!F55","v":0.4},{"$f":"IF(A20='6. Identity Credential'!$F$4,1,0)","v":0},0,0]
[5,"Teslin ",{"$f":"'0.2 Unit cost  assumptions'!F56","v":0.9},{"$f":"IF(A21='6. Identity Credential'!$F$4,1,0)","v":0},0,0]
[6,"Composite (PC+PVC)",{"$f":"'0.2 Unit cost  assumptions'!F57","v":0.4},{"$f":"IF(A22='6. Identity Credential'!$F$4,1,0)","v":0},0,0]
[0,"No printing",0,{"$f":"IF(D3=1,1,0)","v":0},{"$f":"D23","v":0},0]
[1,"Thermal",{"$f":"'0.2 Unit cost  assumptions'!F58","v":0.15},{"$f":"IF($D$23=1,0,1)","v":1},{"$f":"IF(D17*E17=1,1,0)","v":0},0]
[2,"Printing on PVC ",{"$f":"'0.2 Unit cost  assumptions'!F59","v":0.3},{"$f":"IF($D$23=1,0,1)","v":1},{"$f":"IF(OR(E23=1,E24=1),0,IF(D5=1,1,0))","v":0},0]
[3,"Printing on PVC smart card",{"$f":"'0.2 Unit cost  assumptions'!F60","v":0.6},1,{"$f":"IF(D4=1,1,0)","v":1},0.6]
[0,"No security ",0,{"$f":"IF(A27='6. Identity Credential'!$G$4,1,0)","v":0},{"$f":"IF(D3=1,1,$D$27)","v":0},0]
[1,"Level 1 (Overt)",{"$f":"'0.2 Unit cost  assumptions'!F61","v":0.5},{"$f":"IF(A28='6. Identity Credential'!$G$4,1,0)","v":0},{"$f":"IF($E$27=1,0,D28)","v":0},0]
[2,"Level 2 (Covert)",{"$f":"'0.2 Unit cost  assumptions'!F62","v":0.7},{"$f":"IF(A29='6. Identity Credential'!$G$4,1,0)","v":0},{"$f":"IF($E$27=1,0,D29)","v":0},0]
[3,"Level 3 (Forensic)",{"$f":"'0.2 Unit cost  assumptions'!F63","v":0.9},{"$f":"IF(A30='6. Identity Credential'!$G$4,1,0)","v":1},{"$f":"IF(E27=1,0,D30)","v":1},0.9]
[null,null,null,null,"Per credential cost",{"$f":"SUM(F3:F30)","v":3.9}]
[null,null,null,null,"Per credential including delivery cost",{"$f":"F31+IF(D3=1,0,'6. Identity Credential'!$H$4)","v":4}]

{"sheet":"7. Central IT","index":22,"n_rows":42,"n_cols":19,"rows_kept":42,"cut":false,"hidden":true,"merged":[[40,0,41,0],[13,0,17,0],[23,0,25,0],[18,0,22,0],[26,0,28,0]]}
["Central IT cost estimation "]
[]
["Component","per agency per person per year authentication request","Preferred biometric for authentication","Preferred biometric for deduplication ","Per person raw data size","Per person minutiae size","DC site operating expenditure","DC site installation cost","Capacity of DR as compared to DC"]
["Value",{"$f":"'0.4 All inputs'!A45","v":0.2},{"$f":"'7.1 backend'!C69","v":1},{"$f":"'7.1 backend'!C66","v":1},{"$f":"'0.4 All inputs'!D45","v":4000},{"$f":"'0.4 All inputs'!E45","v":150},{"$f":"'0.2 Unit cost  assumptions'!F65","v":500000},{"$f":"'0.2 Unit cost  assumptions'!F66","v":500000},{"$f":"'0.4 All inputs'!F45","v":1}]
["Description ",null,"0 = no biometric authentication, 1 = finger prints,  2= Iris, 3 = Voice, 4 = face","1 = finger prints,  2= Iris, 3 = Voice, 4 = face. ","in KB (including data update requests)","in KB","including electricity, security, site management, rent, WAN etc.","hardware installation, cabling etc. cost"]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"'5. Facility cost'!D12","v":0},{"$f":"'5. Facility cost'!E12","v":1},{"$f":"'5. Facility cost'!F12","v":2},{"$f":"'5. Facility cost'!G12","v":3},{"$f":"'5. Facility cost'!H12","v":4},{"$f":"'5. Facility cost'!I12","v":5},{"$f":"'5. Facility cost'!J12","v":6},{"$f":"'5. Facility cost'!K12","v":7},{"$f":"'5. Facility cost'!L12","v":8},{"$f":"'5. Facility cost'!M12","v":9},{"$f":"'5. Facility cost'!N12","v":10},{"$f":"'5. Facility cost'!O12","v":11},{"$f":"'5. Facility cost'!P12","v":12},{"$f":"'5. Facility cost'!Q12","v":13},{"$f":"'5. Facility cost'!R12","v":14},{"$f":"'5. Facility cost'!S12","v":15}]
[null,null,null,{"$f":"'5. Facility cost'!D13","v":2018},{"$f":"'5. Facility cost'!E13","v":2019},{"$f":"'5. Facility cost'!F13","v":2020},{"$f":"'5. Facility cost'!G13","v":2021},{"$f":"'5. Facility cost'!H13","v":2022},{"$f":"'5. Facility cost'!I13","v":2023},{"$f":"'5. Facility cost'!J13","v":2024},{"$f":"'5. Facility cost'!K13","v":2025},{"$f":"'5. Facility cost'!L13","v":2026},{"$f":"'5. Facility cost'!M13","v":2027},{"$f":"'5. Facility cost'!N13","v":2028},{"$f":"'5. Facility cost'!O13","v":2029},{"$f":"'5. Facility cost'!P13","v":2030},{"$f":"'5. Facility cost'!Q13","v":2031},{"$f":"'5. Facility cost'!R13","v":2032},{"$f":"'5. Facility cost'!S13","v":2033}]
["Servers: Requirement","Webserver","no. of servers",{"$f":"'7.1 backend'!D33","v":0},{"$f":"'7.1 backend'!E33","v":1},{"$f":"'7.1 backend'!F33","v":1},{"$f":"'7.1 backend'!G33","v":1},{"$f":"'7.1 backend'!H33","v":1},{"$f":"'7.1 backend'!I33","v":1},{"$f":"'7.1 backend'!J33","v":1},{"$f":"'7.1 backend'!K33","v":1},{"$f":"'7.1 backend'!L33","v":1},{"$f":"'7.1 backend'!M33","v":1},{"$f":"'7.1 backend'!N33","v":1},{"$f":"'7.1 backend'!O33","v":1},{"$f":"'7.1 backend'!P33","v":1},{"$f":"'7.1 backend'!Q33","v":1},{"$f":"'7.1 backend'!R33","v":1},{"$f":"'7.1 backend'!S33","v":1}]
[null,"Enrolment database server","no. of servers",{"$f":"'7.1 backend'!D34","v":0},{"$f":"'7.1 backend'!E34","v":1},{"$f":"'7.1 backend'!F34","v":1},{"$f":"'7.1 backend'!G34","v":1},{"$f":"'7.1 backend'!H34","v":1},{"$f":"'7.1 backend'!I34","v":1},{"$f":"'7.1 backend'!J34","v":1},{"$f":"'7.1 backend'!K34","v":1},{"$f":"'7.1 backend'!L34","v":1},{"$f":"'7.1 backend'!M34","v":1},{"$f":"'7.1 backend'!N34","v":1},{"$f":"'7.1 backend'!O34","v":1},{"$f":"'7.1 backend'!P34","v":1},{"$f":"'7.1 backend'!Q34","v":1},{"$f":"'7.1 backend'!R34","v":1},{"$f":"'7.1 backend'!S34","v":1}]
[null,"Authentication database server","no. of servers",{"$f":"'7.1 backend'!D35","v":0},{"$f":"'7.1 backend'!E35","v":0},{"$f":"'7.1 backend'!F35","v":1},{"$f":"'7.1 backend'!G35","v":1},{"$f":"'7.1 backend'!H35","v":1},{"$f":"'7.1 backend'!I35","v":1},{"$f":"'7.1 backend'!J35","v":1},{"$f":"'7.1 backend'!K35","v":1},{"$f":"'7.1 backend'!L35","v":1},{"$f":"'7.1 backend'!M35","v":1},{"$f":"'7.1 backend'!N35","v":1},{"$f":"'7.1 backend'!O35","v":1},{"$f":"'7.1 backend'!P35","v":1},{"$f":"'7.1 backend'!Q35","v":1},{"$f":"'7.1 backend'!R35","v":1},{"$f":"'7.1 backend'!S35","v":1}]
[null,"Deduplication application server","no. of servers",{"$f":"'7.1 backend'!D38","v":0},{"$f":"'7.1 backend'!E38","v":1},{"$f":"'7.1 backend'!F38","v":5},{"$f":"'7.1 backend'!G38","v":4},{"$f":"'7.1 backend'!H38","v":1},{"$f":"'7.1 backend'!I38","v":2},{"$f":"'7.1 backend'!J38","v":2},{"$f":"'7.1 backend'!K38","v":2},{"$f":"'7.1 backend'!L38","v":2},{"$f":"'7.1 backend'!M38","v":2},{"$f":"'7.1 backend'!N38","v":2},{"$f":"'7.1 backend'!O38","v":2},{"$f":"'7.1 backend'!P38","v":2},{"$f":"'7.1 backend'!Q38","v":2},{"$f":"'7.1 backend'!R38","v":3},{"$f":"'7.1 backend'!S38","v":3}]
[null,"Authentication application server","no. of servers",{"$f":"'7.1 backend'!D37","v":0},{"$f":"'7.1 backend'!E37","v":0},{"$f":"'7.1 backend'!F37","v":1},{"$f":"'7.1 backend'!G37","v":1},{"$f":"'7.1 backend'!H37","v":1},{"$f":"'7.1 backend'!I37","v":1},{"$f":"'7.1 backend'!J37","v":1},{"$f":"'7.1 backend'!K37","v":1},{"$f":"'7.1 backend'!L37","v":1},{"$f":"'7.1 backend'!M37","v":1},{"$f":"'7.1 backend'!N37","v":1},{"$f":"'7.1 backend'!O37","v":1},{"$f":"'7.1 backend'!P37","v":1},{"$f":"'7.1 backend'!Q37","v":1},{"$f":"'7.1 backend'!R37","v":1},{"$f":"'7.1 backend'!S37","v":1}]
["Servers: Addition","Webserver",null,{"$f":"D14","v":0},{"$f":"IF(E14>D14,E14-D14,0)","v":1},{"$f":"IF(F14>E14,F14-E14,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Enrolment database server",null,{"$f":"D15","v":0},{"$f":"IF(E15>D15,E15-D15,0)","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Authentication database server",null,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Deduplication application server",null,0,1,4,0,0,1,0,0,0,0,0,0,0,0,1,0]
[null,"Authentication application server",null,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Storage disk requirement","Storage disk required for enrolment","no. of disks",{"$f":"'7.1 backend'!D42","v":0},{"$f":"'7.1 backend'!E42","v":3},{"$f":"'7.1 backend'!F42","v":7},{"$f":"'7.1 backend'!G42","v":10},{"$f":"'7.1 backend'!H42","v":10},{"$f":"'7.1 backend'!I42","v":11},{"$f":"'7.1 backend'!J42","v":11},{"$f":"'7.1 backend'!K42","v":12},{"$f":"'7.1 backend'!L42","v":13},{"$f":"'7.1 backend'!M42","v":13},{"$f":"'7.1 backend'!N42","v":14},{"$f":"'7.1 backend'!O42","v":15},{"$f":"'7.1 backend'!P42","v":15},{"$f":"'7.1 backend'!Q42","v":16},{"$f":"'7.1 backend'!R42","v":17},{"$f":"'7.1 backend'!S42","v":18}]
[null,"Storage disk required for authentication ","no. of disks",{"$f":"'7.1 backend'!D44","v":0},{"$f":"'7.1 backend'!E44","v":1},{"$f":"'7.1 backend'!F44","v":1},{"$f":"'7.1 backend'!G44","v":1},{"$f":"'7.1 backend'!H44","v":1},{"$f":"'7.1 backend'!I44","v":1},{"$f":"'7.1 backend'!J44","v":1},{"$f":"'7.1 backend'!K44","v":1},{"$f":"'7.1 backend'!L44","v":1},{"$f":"'7.1 backend'!M44","v":1},{"$f":"'7.1 backend'!N44","v":1},{"$f":"'7.1 backend'!O44","v":1},{"$f":"'7.1 backend'!P44","v":1},{"$f":"'7.1 backend'!Q44","v":1},{"$f":"'7.1 backend'!R44","v":1},{"$f":"'7.1 backend'!S44","v":1}]
[null,"storage disk required for deduplication ","no. of disks",{"$f":"'7.1 backend'!D43","v":0},{"$f":"'7.1 backend'!E43","v":1},{"$f":"'7.1 backend'!F43","v":1},{"$f":"'7.1 backend'!G43","v":1},{"$f":"'7.1 backend'!H43","v":1},{"$f":"'7.1 backend'!I43","v":1},{"$f":"'7.1 backend'!J43","v":1},{"$f":"'7.1 backend'!K43","v":1},{"$f":"'7.1 backend'!L43","v":1},{"$f":"'7.1 backend'!M43","v":1},{"$f":"'7.1 backend'!N43","v":1},{"$f":"'7.1 backend'!O43","v":1},{"$f":"'7.1 backend'!P43","v":1},{"$f":"'7.1 backend'!Q43","v":1},{"$f":"'7.1 backend'!R43","v":1},{"$f":"'7.1 backend'!S43","v":1}]
["Storage disk addition","Storage disk required for enrolment",null,{"$f":"D24","v":0},{"$f":"IF(E24>D24,E24-D24,0)","v":3},{"$f":"IF(F24>E24,F24-E24,0)","v":4},{"$f":"IF(G24>F24,G24-F24,0)","v":3},0,1,0,1,1,0,1,1,0,1,1,1]
[null,"Storage disk required for authentication ",null,{"$f":"D25","v":0},{"$f":"IF(E25>D25,E25-D25,0)","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"storage disk required for deduplication ",null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Cost ","Static hardware procurement cost","Capex",{"$f":"'7.1 backend'!F55","v":590000}]
[null,"Static hardware AMC cost","opex",{"$f":"'7.1 backend'!F56","v":88500},{"$f":"D32","v":88500},{"$f":"E32","v":88500},88500,88500,88500,88500,88500,88500,88500,88500,88500,88500,88500,88500,88500]
[null,"Server hardware cost ","Capex",{"$f":"D19*'7.1 backend'!L3+'7.1 backend'!M3*('7. Central IT'!D22+'7. Central IT'!D23)+('7. Central IT'!D20+'7. Central IT'!D21)*'7.1 backend'!N3","v":0},{"$f":"E19*'7.1 backend'!$M$3+'7.1 backend'!$N$3*('7. Central IT'!E22+'7. Central IT'!E23)+('7. Central IT'!E20+'7. Central IT'!E21)*'7.1 backend'!$O$3","v":90000},{"$f":"F19*'7.1 backend'!$M$3+'7.1 backend'!$N$3*('7. Central IT'!F22+'7. Central IT'!F23)+('7. Central IT'!F20+'7. Central IT'!F21)*'7.1 backend'!$O$3","v":260000},{"$f":"G19*'7.1 backend'!$M$3+'7.1 backend'!$N$3*('7. Central IT'!G22+'7. Central IT'!G23)+('7. Central IT'!G20+'7. Central IT'!G21)*'7.1 backend'!$O$3","v":0},{"$f":"H19*'7.1 backend'!$M$3+'7.1 backend'!$N$3*('7. Central IT'!H22+'7. Central IT'!H23)+('7. Central IT'!H20+'7. Central IT'!H21)*'7.1 backend'!$O$3","v":0},{"$f":"I19*'7.1 backend'!$M$3+'7.1 backend'!$N$3*('7. Central IT'!I22+'7. Central IT'!I23)+('7. Central IT'!I20+'7. Central IT'!I21)*'7.1 backend'!$O$3","v":50000},{"$f":"J19*'7.1 backend'!$M$3+'7.1 backend'!$N$3*('7. Central IT'!J22+'7. Central IT'!J23)+('7. Central IT'!J20+'7. Central IT'!J21)*'7.1 backend'!$O$3","v":0},{"$f":"K19*'7.1 backend'!$M$3+'7.1 backend'!$N$3*('7. Central IT'!K22+'7. Central IT'!K23)+('7. Central IT'!K20+'7. Central IT'!K21)*'7.1 backend'!$O$3","v":0},{"$f":"L19*'7.1 backend'!$M$3+'7.1 backend'!$N$3*('7. Central IT'!L22+'7. Central IT'!L23)+('7. Central IT'!L20+'7. Central IT'!L21)*'7.1 backend'!$O$3","v":0},{"$f":"M19*'7.1 backend'!$M$3+'7.1 backend'!$N$3*('7. Central IT'!M22+'7. Central IT'!M23)+('7. Central IT'!M20+'7. Central IT'!M21)*'7.1 backend'!$O$3","v":0},{"$f":"N19*'7.1 backend'!$M$3+'7.1 backend'!$N$3*('7. Central IT'!N22+'7. Central IT'!N23)+('7. Central IT'!N20+'7. Central IT'!N21)*'7.1 backend'!$O$3","v":0},{"$f":"O19*'7.1 backend'!$M$3+'7.1 backend'!$N$3*('7. Central IT'!O22+'7. Central IT'!O23)+('7. Central IT'!O20+'7. Central IT'!O21)*'7.1 backend'!$O$3","v":0},{"$f":"P19*'7.1 backend'!$M$3+'7.1 backend'!$N$3*('7. Central IT'!P22+'7. Central IT'!P23)+('7. Central IT'!P20+'7. Central IT'!P21)*'7.1 backend'!$O$3","v":0},{"$f":"Q19*'7.1 backend'!$M$3+'7.1 backend'!$N$3*('7. Central IT'!Q22+'7. Central IT'!Q23)+('7. Central IT'!Q20+'7. Central IT'!Q21)*'7.1 backend'!$O$3","v":0},{"$f":"R19*'7.1 backend'!$M$3+'7.1 backend'!$N$3*('7. Central IT'!R22+'7. Central IT'!R23)+('7. Central IT'!R20+'7. Central IT'!R21)*'7.1 backend'!$O$3","v":50000},{"$f":"S19*'7.1 backend'!$M$3+'7.1 backend'!$N$3*('7. Central IT'!S22+'7. Central IT'!S23)+('7. Central IT'!S20+'7. Central IT'!S21)*'7.1 backend'!$O$3","v":0}]
[null,"server AMC cost","opex",{"$f":"SUM(D33:$D$33)*Hardware_AMC","v":0},{"$f":"SUM($D33:E$33)*Hardware_AMC","v":13500},{"$f":"SUM($D33:F$33)*Hardware_AMC","v":52500},{"$f":"SUM($D33:G$33)*Hardware_AMC","v":52500},{"$f":"SUM($D33:H$33)*Hardware_AMC","v":52500},{"$f":"SUM($D33:I$33)*Hardware_AMC","v":60000},{"$f":"SUM($D33:J$33)*Hardware_AMC","v":60000},{"$f":"SUM($D33:K$33)*Hardware_AMC","v":60000},{"$f":"SUM($D33:L$33)*Hardware_AMC","v":60000},{"$f":"SUM($D33:M$33)*Hardware_AMC","v":60000},{"$f":"SUM($D33:N$33)*Hardware_AMC","v":60000},{"$f":"SUM($D33:O$33)*Hardware_AMC","v":60000},{"$f":"SUM($D33:P$33)*Hardware_AMC","v":60000},{"$f":"SUM($D33:Q$33)*Hardware_AMC","v":60000},{"$f":"SUM($D33:R$33)*Hardware_AMC","v":67500},{"$f":"SUM($D33:S$33)*Hardware_AMC","v":67500}]
[null,"Storage hardware cost ","Capex",{"$f":"'7.1 backend'!$O$3*SUM('7. Central IT'!D27:D29)","v":0},{"$f":"'7.1 backend'!$O$3*SUM('7. Central IT'!E27:E29)","v":50000},{"$f":"'7.1 backend'!$O$3*SUM('7. Central IT'!F27:F29)","v":40000},{"$f":"'7.1 backend'!$O$3*SUM('7. Central IT'!G27:G29)","v":30000},{"$f":"'7.1 backend'!$O$3*SUM('7. Central IT'!H27:H29)","v":0},{"$f":"'7.1 backend'!$O$3*SUM('7. Central IT'!I27:I29)","v":10000},{"$f":"'7.1 backend'!$O$3*SUM('7. Central IT'!J27:J29)","v":0},{"$f":"'7.1 backend'!$O$3*SUM('7. Central IT'!K27:K29)","v":10000},{"$f":"'7.1 backend'!$O$3*SUM('7. Central IT'!L27:L29)","v":10000},{"$f":"'7.1 backend'!$O$3*SUM('7. Central IT'!M27:M29)","v":0},{"$f":"'7.1 backend'!$O$3*SUM('7. Central IT'!N27:N29)","v":10000},{"$f":"'7.1 backend'!$O$3*SUM('7. Central IT'!O27:O29)","v":10000},{"$f":"'7.1 backend'!$O$3*SUM('7. Central IT'!P27:P29)","v":0},{"$f":"'7.1 backend'!$O$3*SUM('7. Central IT'!Q27:Q29)","v":10000},{"$f":"'7.1 backend'!$O$3*SUM('7. Central IT'!R27:R29)","v":10000},{"$f":"'7.1 backend'!$O$3*SUM('7. Central IT'!S27:S29)","v":10000}]
[null,"storage  AMC cost","opex",{"$f":"SUM(D35:$D$35)*Hardware_AMC","v":0},{"$f":"SUM($D35:E$35)*Hardware_AMC","v":7500},{"$f":"SUM($D35:F$35)*Hardware_AMC","v":13500},{"$f":"SUM($D35:G$35)*Hardware_AMC","v":18000},{"$f":"SUM($D35:H$35)*Hardware_AMC","v":18000},{"$f":"SUM($D35:I$35)*Hardware_AMC","v":19500},{"$f":"SUM($D35:J$35)*Hardware_AMC","v":19500},{"$f":"SUM($D35:K$35)*Hardware_AMC","v":21000},{"$f":"SUM($D35:L$35)*Hardware_AMC","v":22500},{"$f":"SUM($D35:M$35)*Hardware_AMC","v":22500},{"$f":"SUM($D35:N$35)*Hardware_AMC","v":24000},{"$f":"SUM($D35:O$35)*Hardware_AMC","v":25500},{"$f":"SUM($D35:P$35)*Hardware_AMC","v":25500},{"$f":"SUM($D35:Q$35)*Hardware_AMC","v":27000},{"$f":"SUM($D35:R$35)*Hardware_AMC","v":28500},{"$f":"SUM($D35:S$35)*Hardware_AMC","v":30000}]
[null,"Site installation cost ","capex",{"$f":"H4","v":500000}]
[null,"site operational expenditure ","opex",{"$f":"$G$4","v":500000},{"$f":"$G$4","v":500000},500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000]
[null,"Tech Refresh ","Capex",{"$f":"IF(D13-$D$13>=7,IF(AND(D13-$D$13>=7,D13-$D$13<14),INDEX($D$41:$S$41,1,MATCH(D13-7,$D$13:$S$13,0)),INDEX($D$41:$S$41,1,MATCH(D13-14,$D$13:$S$13,0))),0)","v":0},0,0,0,0,0,0,2180000,280000,600000,60000,0,120000,0,2180000,280000]
[]
["Overall","Capital Expenditure","dc+dr",{"$f":"(D37+D35+D33+D31+D39)*(1+$I$4)","v":2180000},{"$f":"(E37+E35+E33+E31+E39)*(1+$I$4)","v":280000},600000,60000,0,120000,0,4380000,580000,1200000,140000,20000,240000,20000,4480000,580000]
[null,"Operational Expenditure","dc+dr",{"$f":"(D38+D36+D34+D32)*(1+$I$4)","v":1177000},{"$f":"(E38+E36+E34+E32)*(1+$I$4)","v":1219000},1309000,1318000,1318000,1336000,1336000,1339000,1342000,1342000,1345000,1348000,1348000,1351000,1369000,1372000]

{"sheet":"7.1 backend","index":23,"n_rows":69,"n_cols":19,"rows_kept":69,"cut":false,"hidden":true,"merged":[[47,0,55,0],[33,0,34,0],[35,0,37,0],[38,0,43,0]]}
[]
["Component","No. of user agencies linked with eID ","Web server capacity (no. of request per second)","Finger print equivalent to one iris ","Finger print equivalent to face","Finger print equivalent to voice ","Finger print equivalent to non biometric based authentication  ","Preferred biometric for authentication","finger print equivalent to preferred authentication medium ","Preferred biometric for deduplication ","Dedup capacity per core  per second as per selected  biometric","Web server cost ","Application server cost","Data base server cost","Cost of storage disk "]
["Value",{"$f":"'3. Helpdesk,IEC and T&CB'!K4","v":100},{"$f":"'0.4 All inputs'!E49","v":3000},4,2,2,1,{"$f":"'7. Central IT'!C4","v":1},{"$f":"IF(H3=0,G3,IF(H3=1,1,IF(H3=2,D3,IF(H3=3,F3,IF(H3=4,E3,0)))))","v":1},{"$f":"'7. Central IT'!D4","v":1},{"$f":"IF(J3=1,G7,IF(J3=2,H7,IF(J3=3,J7,IF(J3=4,I7,0))))","v":37500},{"$f":"'0.2 Unit cost  assumptions'!F67","v":15000},{"$f":"'0.2 Unit cost  assumptions'!F68","v":30000},{"$f":"'0.2 Unit cost  assumptions'!F69","v":50000},{"$f":"'0.2 Unit cost  assumptions'!F70","v":10000}]
["Description ",null,null,"One Iris authentication will be equal to 4 finger print authentication requests","One face authentication request is equal to 2 finger requests","one voice authentication request will be equal to these many finger print requests","one non biometric authentication request will be equal to these many finger print request","0 = no biometric authentication, 1 = finger prints,  2= Iris, 3 = Voice, 4 = face",null,"1 = finger prints,  2= Iris, 3 = Voice, 4 = face"]
[]
["Component","Data base server capacity (no. of request per core per second)","No . of core in webserver ","no. of core in database server","no. of core in application server","Application server capacity (no. of requests per core per second)","Finger print deduplication per core per second","Iris deduplication per core per second","Face deduplication per core per second","Voice deduplication per core per second","Storage disk minimum size ","Hardware AMC "]
["Value",{"$f":"'0.4 All inputs'!G49","v":300},{"$f":"'0.4 All inputs'!A49","v":16},{"$f":"'0.4 All inputs'!B49","v":16},{"$f":"'0.4 All inputs'!C49","v":16},{"$f":"'0.4 All inputs'!F49","v":100},{"$f":"'0.4 All inputs'!A53","v":37500},{"$f":"'0.4 All inputs'!B53","v":2500},{"$f":"'0.4 All inputs'!C53","v":1250},{"$f":"'0.4 All inputs'!D53","v":1250},{"$f":"'0.4 All inputs'!G45","v":10},{"$f":"'0.4 All inputs'!D49","v":0.15}]
["Description ",null,null,null,null,"1 request is equivalent to one finger print authentication request","for two finger biometric deduplication ",null,null,null,"in tb","as % of total cost of hardware"]
[]
[]
[]
[null,null,null,{"$f":"'6. Identity Credential'!C12","v":0},{"$f":"'6. Identity Credential'!D12","v":1},{"$f":"'6. Identity Credential'!E12","v":2},{"$f":"'6. Identity Credential'!F12","v":3},{"$f":"'6. Identity Credential'!G12","v":4},{"$f":"'6. Identity Credential'!H12","v":5},{"$f":"'6. Identity Credential'!I12","v":6},{"$f":"'6. Identity Credential'!J12","v":7},{"$f":"'6. Identity Credential'!K12","v":8},{"$f":"'6. Identity Credential'!L12","v":9},{"$f":"'6. Identity Credential'!M12","v":10},{"$f":"'6. Identity Credential'!N12","v":11},{"$f":"'6. Identity Credential'!O12","v":12},{"$f":"'6. Identity Credential'!P12","v":13},{"$f":"'6. Identity Credential'!Q12","v":14},{"$f":"'6. Identity Credential'!R12","v":15}]
[null,null,null,{"$f":"'6. Identity Credential'!C13","v":2018},{"$f":"'6. Identity Credential'!D13","v":2019},{"$f":"'6. Identity Credential'!E13","v":2020},{"$f":"'6. Identity Credential'!F13","v":2021},{"$f":"'6. Identity Credential'!G13","v":2022},{"$f":"'6. Identity Credential'!H13","v":2023},{"$f":"'6. Identity Credential'!I13","v":2024},{"$f":"'6. Identity Credential'!J13","v":2025},{"$f":"'6. Identity Credential'!K13","v":2026},{"$f":"'6. Identity Credential'!L13","v":2027},{"$f":"'6. Identity Credential'!M13","v":2028},{"$f":"'6. Identity Credential'!N13","v":2029},{"$f":"'6. Identity Credential'!O13","v":2030},{"$f":"'6. Identity Credential'!P13","v":2031},{"$f":"'6. Identity Credential'!Q13","v":2032},{"$f":"'6. Identity Credential'!R13","v":2033}]
[null,"New enrolment ",null,{"$f":"'1. Enrolment'!D25","v":0},{"$f":"'1. Enrolment'!E25","v":3038007.4615957192},{"$f":"'1. Enrolment'!F25","v":5155586.1688871868},{"$f":"'1. Enrolment'!G25","v":3218642.7978709335},{"$f":"'1. Enrolment'!H25","v":716647.35064560734},{"$f":"'1. Enrolment'!I25","v":737645.11801952391},{"$f":"'1. Enrolment'!J25","v":759258.11997749575},{"$f":"'1. Enrolment'!K25","v":781504.38289283647},{"$f":"'1. Enrolment'!L25","v":804402.46131159668},{"$f":"'1. Enrolment'!M25","v":827971.45342802641},{"$f":"'1. Enrolment'!N25","v":852231.01701346773},{"$f":"'1. Enrolment'!O25","v":877201.38581196242},{"$f":"'1. Enrolment'!P25","v":902903.38641625305},{"$f":"'1. Enrolment'!Q25","v":929358.45563824929},{"$f":"'1. Enrolment'!R25","v":956588.65838845004},{"$f":"'1. Enrolment'!S25","v":984616.70607923169}]
[null,"Cumulative enrolment",null,{"$f":"'1. Enrolment'!D26","v":0},{"$f":"'1. Enrolment'!E26","v":3038007.4615957192},{"$f":"'1. Enrolment'!F26","v":8193593.6304829065},{"$f":"'1. Enrolment'!G26","v":11412236.42835384},{"$f":"'1. Enrolment'!H26","v":12128883.778999448},{"$f":"'1. Enrolment'!I26","v":12866528.897018971},{"$f":"'1. Enrolment'!J26","v":13625787.016996467},{"$f":"'1. Enrolment'!K26","v":14407291.399889303},{"$f":"'1. Enrolment'!L26","v":15211693.861200901},{"$f":"'1. Enrolment'!M26","v":16039665.314628927},{"$f":"'1. Enrolment'!N26","v":16891896.331642393},{"$f":"'1. Enrolment'!O26","v":17769097.717454355},{"$f":"'1. Enrolment'!P26","v":18672001.103870608},{"$f":"'1. Enrolment'!Q26","v":19601359.559508856},{"$f":"'1. Enrolment'!R26","v":20557948.217897307},{"$f":"'1. Enrolment'!S26","v":21542564.923976541}]
[null,"Annual enrolments and data update requests",null,{"$f":"'1. Enrolment'!D31","v":0},{"$f":"'1. Enrolment'!E31","v":3068387.5362116764},{"$f":"'1. Enrolment'!F31","v":5989108.7332350593},{"$f":"'1. Enrolment'!G31","v":4106373.2783991769},{"$f":"'1. Enrolment'!H31","v":1634211.0224862765},{"$f":"'1. Enrolment'!I31","v":1685916.0936780735},{"$f":"'1. Enrolment'!J31","v":1739136.1234557889},{"$f":"'1. Enrolment'!K31","v":1793915.5001059922},{"$f":"'1. Enrolment'!L31","v":1850299.9124920466},{"$f":"'1. Enrolment'!M31","v":1908336.3881610115},{"$f":"'1. Enrolment'!N31","v":1968073.3325670781},{"$f":"'1. Enrolment'!O31","v":2029560.5694442419},{"$f":"'1. Enrolment'!P31","v":2092849.382361907},{"$f":"'1. Enrolment'!Q31","v":2157992.5574980592},{"$f":"'1. Enrolment'!R31","v":2225044.4276657011},{"$f":"'1. Enrolment'!S31","v":2294060.9176292545}]
[null,"Per second request ",null,{"$f":"ROUNDUP(D16/(Work_days*work_hour*3600),0)","v":0},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
[null,"Deduplication requests ",null,{"$f":"'4. Software'!D33","v":0},{"$f":"'4. Software'!E33","v":3038007.4615957192},{"$f":"'4. Software'!F33","v":5155586.1688871868},{"$f":"'4. Software'!G33","v":3218642.7978709335},{"$f":"'4. Software'!H33","v":716647.35064560734},{"$f":"'4. Software'!I33","v":737645.11801952391},{"$f":"'4. Software'!J33","v":759258.11997749575},{"$f":"'4. Software'!K33","v":781504.38289283647},{"$f":"'4. Software'!L33","v":804402.46131159668},{"$f":"'4. Software'!M33","v":827971.45342802641},{"$f":"'4. Software'!N33","v":852231.01701346773},{"$f":"'4. Software'!O33","v":877201.38581196242},{"$f":"'4. Software'!P33","v":902903.38641625305},{"$f":"'4. Software'!Q33","v":929358.45563824929},{"$f":"'4. Software'!R33","v":956588.65838845004},{"$f":"'4. Software'!S33","v":984616.70607923169}]
[null,"Effective deduplication requests ","matches per year",{"$f":"D19*D15","v":0},{"$f":"E19*E15","v":9229489336711.2656},42242777994799.82,36731912587721.398,8692132426508.4365,9490932226743.1738,10345489433738.508,11259361374627.76,12236323982668.51,13280385003052.416,14395797990001.662,15587077142379.139,16859013027852.787,18216689248635.184,19665500104977.613,21211169315943.777]
[null,"no. of effective dedup request per second","matches per second",{"$f":"D20/(365*24*60*60)","v":0},{"$f":"E20/(365*24*60*60)","v":292665.18698348763},1339509.7030314505,1164761.3073224695,275625.71113991743,300955.48664203368,328053.31791408255,357032.00705947995,388011.28813636827,421118.24591109896,456487.75970324903,494262.97381973424,534595.796164789,577647.42670710245,623588.9175855408,672601.76674098731]
[null,"No. of dedup requests for web server per second",null,{"$f":"ROUNDUP(D19/(365*24*3600),0)","v":0},{"$f":"ROUNDUP(E19/(365*24*3600),0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
[null,"NID coverage ",null,0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1]
[null,"Service linked with NID",null,0,0,0,0.1,0.2,0.5,0.7,0.9,1,1,1]
[null,"Actual NID coverage ",null,{"$f":"'1. Enrolment'!D26/'1. Enrolment'!D19","v":0},{"$f":"'1. Enrolment'!E26/'1. Enrolment'!E19","v":0.24666175715507732},{"$f":"'1. Enrolment'!F26/'1. Enrolment'!F19","v":0.64631678215839439},{"$f":"'1. Enrolment'!G26/'1. Enrolment'!G19","v":0.87458051957458027},{"$f":"'1. Enrolment'!H26/'1. Enrolment'!H19","v":0.90304189907455301},{"$f":"'1. Enrolment'!I26/'1. Enrolment'!I19","v":0.93069309843331383},{"$f":"'1. Enrolment'!J26/'1. Enrolment'!J19","v":0.95755718019641611},{"$f":"'1. Enrolment'!K26/'1. Enrolment'!K19","v":0.9836565504121958},{"$f":"'1. Enrolment'!L26/'1. Enrolment'!L19","v":1.0090129773195888},{"$f":"'1. Enrolment'!M26/'1. Enrolment'!M19","v":1.0336476095039795},{"$f":"'1. Enrolment'!N26/'1. Enrolment'!N19","v":1.0575809935362248},{"$f":"'1. Enrolment'!O26/'1. Enrolment'!O19","v":1.0808330911095716},{"$f":"'1. Enrolment'!P26/'1. Enrolment'!P19","v":1.1034232956887482},{"$f":"'1. Enrolment'!Q26/'1. Enrolment'!Q19","v":1.1253704486851308},{"$f":"'1. Enrolment'!R26/'1. Enrolment'!R19","v":1.1466928551714644},{"$f":"'1. Enrolment'!S26/'1. Enrolment'!S19","v":1.1674082991492485}]
[null,"Service linked with NID ",null,{"$f":"INDEX($D$25:$N$25,,MATCH(D26,$D$24:$N$24,1))","v":0},{"$f":"INDEX($D$25:$N$25,,MATCH(E26,$D$24:$N$24,1))","v":0},0.7,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Service agencies linked with NID",null,{"$f":"D27*$B$3","v":0},{"$f":"E27*$B$3","v":0},70,100,100,100,100,100,100,100,100,100,100,100,100,100]
[null,"Authentication request per year",null,{"$f":"D28*'7. Central IT'!$B$4*D15","v":0},{"$f":"E28*'7. Central IT'!$B$4*E15","v":0},{"$f":"F28*'7. Central IT'!$B$4*F15","v":114710310.82676069},{"$f":"G28*'7. Central IT'!$B$4*G15","v":228244728.5670768},{"$f":"H28*'7. Central IT'!$B$4*H15","v":242577675.57998896},{"$f":"I28*'7. Central IT'!$B$4*I15","v":257330577.94037941},{"$f":"J28*'7. Central IT'!$B$4*J15","v":272515740.33992934},{"$f":"K28*'7. Central IT'!$B$4*K15","v":288145827.99778605},{"$f":"L28*'7. Central IT'!$B$4*L15","v":304233877.22401804},{"$f":"M28*'7. Central IT'!$B$4*M15","v":320793306.29257852},{"$f":"N28*'7. Central IT'!$B$4*N15","v":337837926.63284785},{"$f":"O28*'7. Central IT'!$B$4*O15","v":355381954.34908712},{"$f":"P28*'7. Central IT'!$B$4*P15","v":373440022.07741213},{"$f":"Q28*'7. Central IT'!$B$4*Q15","v":392027191.19017714},{"$f":"R28*'7. Central IT'!$B$4*R15","v":411158964.35794616},{"$f":"S28*'7. Central IT'!$B$4*S15","v":430851298.47953081}]
[null,"Authentication request per second",null,{"$f":"ROUNDUP(D29/(Work_days*work_hour*60*60),0)","v":0},0,16,32,34,36,38,41,43,45,47,50,52,55,58,60]
[]
[null,"Request per second (web server)",null,{"$f":"(D30+D22+D17)*2","v":0},{"$f":"(E30+E22+E17)*2","v":4},36,68,72,76,80,86,90,94,98,104,108,114,120,124]
["Web server","no. of web servers required",null,{"$f":"ROUNDUP(D32*2/($C$7*$C$3),0)","v":0},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["Database server","Enrolment data base server requirement",null,{"$f":"ROUNDUP(D17*2/($D$7*$B$7),0)","v":0},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Authentication database server ",null,{"$f":"ROUNDUP(D30*2/($D$7*$B$7),0)","v":0},0,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["Application server","no. of effective authentication requests ",null,{"$f":"D30*$I$3","v":0},0,16,32,34,36,38,41,43,45,47,50,52,55,58,60]
[null,"no. of application server required for authentication",null,{"$f":"ROUNDUP(D36*2/($E$7*$F$7),0)","v":0},0,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"no. of application server required for deduplication ",null,{"$f":"ROUNDUP(D21*2/($E$7*$K$3),0)","v":0},{"$f":"ROUNDUP(E21*2/($E$7*$K$3),0)","v":1},5,4,1,2,2,2,2,2,2,2,2,2,3,3]
["Storage","Enrolment and data update storage requirement cumulative","in TB",{"$f":"D15*'7. Central IT'!$E$4*10^(-9)","v":0},{"$f":"E15*'7. Central IT'!$E$4*10^(-9)","v":12.152029846382877},{"$f":"F15*'7. Central IT'!$E$4*10^(-9)","v":32.774374521931627},{"$f":"G15*'7. Central IT'!$E$4*10^(-9)","v":45.648945713415365},{"$f":"H15*'7. Central IT'!$E$4*10^(-9)","v":48.515535115997793},{"$f":"I15*'7. Central IT'!$E$4*10^(-9)","v":51.466115588075887},{"$f":"J15*'7. Central IT'!$E$4*10^(-9)","v":54.503148067985876},{"$f":"K15*'7. Central IT'!$E$4*10^(-9)","v":57.629165599557219},{"$f":"L15*'7. Central IT'!$E$4*10^(-9)","v":60.846775444803605},{"$f":"M15*'7. Central IT'!$E$4*10^(-9)","v":64.158661258515707},{"$f":"N15*'7. Central IT'!$E$4*10^(-9)","v":67.567585326569571},{"$f":"O15*'7. Central IT'!$E$4*10^(-9)","v":71.076390869817416},{"$f":"P15*'7. Central IT'!$E$4*10^(-9)","v":74.688004415482439},{"$f":"Q15*'7. Central IT'!$E$4*10^(-9)","v":78.40543823803543},{"$f":"R15*'7. Central IT'!$E$4*10^(-9)","v":82.231792871589235},{"$f":"S15*'7. Central IT'!$E$4*10^(-9)","v":86.170259695906168}]
[null,"Deduplication storage requirement cumulative","in TB",{"$f":"D15*'7. Central IT'!$F$4*10^(-9)","v":0},{"$f":"E15*'7. Central IT'!$F$4*10^(-9)","v":0.45570111923935791},{"$f":"F15*'7. Central IT'!$F$4*10^(-9)","v":1.229039044572436},{"$f":"G15*'7. Central IT'!$F$4*10^(-9)","v":1.7118354642530762},{"$f":"H15*'7. Central IT'!$F$4*10^(-9)","v":1.8193325668499172},{"$f":"I15*'7. Central IT'!$F$4*10^(-9)","v":1.9299793345528458},{"$f":"J15*'7. Central IT'!$F$4*10^(-9)","v":2.0438680525494703},{"$f":"K15*'7. Central IT'!$F$4*10^(-9)","v":2.1610937099833958},{"$f":"L15*'7. Central IT'!$F$4*10^(-9)","v":2.2817540791801352},{"$f":"M15*'7. Central IT'!$F$4*10^(-9)","v":2.4059497971943395},{"$f":"N15*'7. Central IT'!$F$4*10^(-9)","v":2.5337844497463591},{"$f":"O15*'7. Central IT'!$F$4*10^(-9)","v":2.6653646576181531},{"$f":"P15*'7. Central IT'!$F$4*10^(-9)","v":2.8008001655805912},{"$f":"Q15*'7. Central IT'!$F$4*10^(-9)","v":2.9402039339263291},{"$f":"R15*'7. Central IT'!$F$4*10^(-9)","v":3.0836922326845961},{"$f":"S15*'7. Central IT'!$F$4*10^(-9)","v":3.2313847385964816}]
[null,"Authentication storage requirement cumulative","in TB",{"$f":"D40","v":0},{"$f":"E40","v":0.45570111923935791},1.229039044572436,1.7118354642530762,1.8193325668499172,1.9299793345528458,2.0438680525494703,2.1610937099833958,2.2817540791801352,2.4059497971943395,2.5337844497463591,2.6653646576181531,2.8008001655805912,2.9402039339263291,3.0836922326845961,3.2313847385964816]
[null,"Storage  disk required for enrolment","no. of disks",{"$f":"ROUNDUP(D39*2/$K$7,0)","v":0},{"$f":"ROUNDUP(E39*2/$K$7,0)","v":3},7,10,10,11,11,12,13,13,14,15,15,16,17,18]
[null,"storage disk required for dedup","no. of disks",{"$f":"ROUNDUP(D40*2/$K$7,0)","v":0},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"storage disk required for authentication ","no. of disks",0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
[]
[null,null,null,"per unit cost","no. of unit required","total cost"]
["Static hardware ","Load balancer",null,{"$f":"'0.2 Unit cost  assumptions'!F71","v":20000},2,{"$f":"E48*D48","v":40000}]
[null,"Unified threat management",null,{"$f":"'0.2 Unit cost  assumptions'!F72","v":30000},2,{"$f":"E49*D49","v":60000}]
[null,"One time password hardware",null,{"$f":"'0.2 Unit cost  assumptions'!F73","v":100000},1,100000]
[null,"SAN switch",null,{"$f":"'0.2 Unit cost  assumptions'!F74","v":60000},4,240000]
[null,"Core switch",null,{"$f":"'0.2 Unit cost  assumptions'!F75","v":10000},4,40000]
[null,"Tape library",null,{"$f":"'0.2 Unit cost  assumptions'!F76","v":15000},2,30000]
[null,"NAS ",null,{"$f":"'0.2 Unit cost  assumptions'!F77","v":20000},4,80000]
[null,"Total fixed hardware cost",null,null,null,{"$f":"SUM(F48:F54)","v":590000}]
[null,"hardware maintenance cost",null,null,null,{"$f":"F55*Hardware_AMC","v":88500}]
[]
[null,"Selection of default option for deduplication ","Input or not ","Deduplication  Can be done "]
[1,"Finger prints",{"$f":"'0.4 All inputs'!B11*'0.4 All inputs'!C11","v":10},{"$f":"IF(C59>0,1,0)","v":1}]
[2,"Iris",{"$f":"'0.4 All inputs'!D11*'0.4 All inputs'!E11","v":0},{"$f":"IF(C60>0,1,0)","v":0}]
[3,"Voice",{"$f":"'0.4 All inputs'!F11","v":0},0]
[4,"Face",{"$f":"'0.4 All inputs'!G11","v":1},1]
[null,"Sum",{"$f":"SUM(C59:C62)","v":11},"Is selection right for biometric dedup "]
[null,"Selected biometric for dedup as per input",{"$f":"'0.4 All inputs'!C45","v":1},{"$f":"INDEX(D59:D62,MATCH(C64,A59:A62,0))","v":1}]
[null,"If no input then deduplication can be done using",{"$f":"IF(C59>0,A59,IF(C60>0,A60,IF(C61>0,A61,IF(C62>0,A62,1))))","v":1}]
[null,"Deduplication to be performed using",{"$f":"IF(D64=1,C64,C65)","v":1}]
[]
[null,"Selected biometric for authentication as per input",{"$f":"'0.4 All inputs'!B45","v":1},{"$f":"INDEX(D59:D62,MATCH(C68,A59:A62,0))","v":1}]
[null,"Authentication to be performed using ",{"$f":"IF(D68=1,C68,C65)","v":1}]

{"sheet":"8. Model Output","index":24,"n_rows":85,"n_cols":20,"rows_kept":85,"cut":false,"hidden":true,"merged":[]}
["Average inflation rate ",{"$f":"'0.4 All inputs'!G15","v":1.7999999999999999E-2}]
[]
[]
["Constant Term Output",null,{"$f":"'1. Enrolment'!D13","v":0},{"$f":"'1. Enrolment'!E13","v":1},{"$f":"'1. Enrolment'!F13","v":2},{"$f":"'1. Enrolment'!G13","v":3},{"$f":"'1. Enrolment'!H13","v":4},{"$f":"'1. Enrolment'!I13","v":5},{"$f":"'1. Enrolment'!J13","v":6},{"$f":"'1. Enrolment'!K13","v":7},{"$f":"'1. Enrolment'!L13","v":8},{"$f":"'1. Enrolment'!M13","v":9},{"$f":"'1. Enrolment'!N13","v":10},{"$f":"'1. Enrolment'!O13","v":11},{"$f":"'1. Enrolment'!P13","v":12},{"$f":"'1. Enrolment'!Q13","v":13},{"$f":"'1. Enrolment'!R13","v":14}]
[null,null,{"$f":"'1. Enrolment'!D14","v":2018},{"$f":"'1. Enrolment'!E14","v":2019},{"$f":"'1. Enrolment'!F14","v":2020},{"$f":"'1. Enrolment'!G14","v":2021},{"$f":"'1. Enrolment'!H14","v":2022},{"$f":"'1. Enrolment'!I14","v":2023},{"$f":"'1. Enrolment'!J14","v":2024},{"$f":"'1. Enrolment'!K14","v":2025},{"$f":"'1. Enrolment'!L14","v":2026},{"$f":"'1. Enrolment'!M14","v":2027},{"$f":"'1. Enrolment'!N14","v":2028},{"$f":"'1. Enrolment'!O14","v":2029},{"$f":"'1. Enrolment'!P14","v":2030},{"$f":"'1. Enrolment'!Q14","v":2031},{"$f":"'1. Enrolment'!R14","v":2032},null,"Total expenditure till completion of Enrolment phase","Average per year expenditure in steady phase"]
[null,null,{"$f":"IF('1. Enrolment'!D17=0,\"Development Year\",IF('1. Enrolment'!D17=1,\"Enrolment Phase\",IF('1. Enrolment'!D17=2,\"Steady State\")))","v":"Development Year"},{"$f":"IF('1. Enrolment'!E17=0,\"Development Year\",IF('1. Enrolment'!E17=1,\"Enrolment Phase\",IF('1. Enrolment'!E17=2,\"Steady State\")))","v":"Enrolment Phase"},{"$f":"IF('1. Enrolment'!F17=0,\"Development Year\",IF('1. Enrolment'!F17=1,\"Enrolment Phase\",IF('1. Enrolment'!F17=2,\"Steady State\")))","v":"Enrolment Phase"},{"$f":"IF('1. Enrolment'!G17=0,\"Development Year\",IF('1. Enrolment'!G17=1,\"Enrolment Phase\",IF('1. Enrolment'!G17=2,\"Steady State\")))","v":"Enrolment Phase"},{"$f":"IF('1. Enrolment'!H17=0,\"Development Year\",IF('1. Enrolment'!H17=1,\"Enrolment Phase\",IF('1. Enrolment'!H17=2,\"Steady State\")))","v":"Steady State"},{"$f":"IF('1. Enrolment'!I17=0,\"Development Year\",IF('1. Enrolment'!I17=1,\"Enrolment Phase\",IF('1. Enrolment'!I17=2,\"Steady State\")))","v":"Steady State"},{"$f":"IF('1. Enrolment'!J17=0,\"Development Year\",IF('1. Enrolment'!J17=1,\"Enrolment Phase\",IF('1. Enrolment'!J17=2,\"Steady State\")))","v":"Steady State"},{"$f":"IF('1. Enrolment'!K17=0,\"Development Year\",IF('1. Enrolment'!K17=1,\"Enrolment Phase\",IF('1. Enrolment'!K17=2,\"Steady State\")))","v":"Steady State"},{"$f":"IF('1. Enrolment'!L17=0,\"Development Year\",IF('1. Enrolment'!L17=1,\"Enrolment Phase\",IF('1. Enrolment'!L17=2,\"Steady State\")))","v":"Steady State"},{"$f":"IF('1. Enrolment'!M17=0,\"Development Year\",IF('1. Enrolment'!M17=1,\"Enrolment Phase\",IF('1. Enrolment'!M17=2,\"Steady State\")))","v":"Steady State"},{"$f":"IF('1. Enrolment'!N17=0,\"Development Year\",IF('1. Enrolment'!N17=1,\"Enrolment Phase\",IF('1. Enrolment'!N17=2,\"Steady State\")))","v":"Steady State"},{"$f":"IF('1. Enrolment'!O17=0,\"Development Year\",IF('1. Enrolment'!O17=1,\"Enrolment Phase\",IF('1. Enrolment'!O17=2,\"Steady State\")))","v":"Steady State"},{"$f":"IF('1. Enrolment'!P17=0,\"Development Year\",IF('1. Enrolment'!P17=1,\"Enrolment Phase\",IF('1. Enrolment'!P17=2,\"Steady State\")))","v":"Steady State"},{"$f":"IF('1. Enrolment'!Q17=0,\"Development Year\",IF('1. Enrolment'!Q17=1,\"Enrolment Phase\",IF('1. Enrolment'!Q17=2,\"Steady State\")))","v":"Steady State"},{"$f":"IF('1. Enrolment'!R17=0,\"Development Year\",IF('1. Enrolment'!R17=1,\"Enrolment Phase\",IF('1. Enrolment'!R17=2,\"Steady State\")))","v":"Steady State"},"Category wise Total"]
["Enrolment ","Capital expenditure",{"$f":"'1. Enrolment'!D45","v":2893278.2144795056},{"$f":"'1. Enrolment'!E45","v":2473550},{"$f":"'1. Enrolment'!F45","v":131150},{"$f":"'1. Enrolment'!G45","v":0},{"$f":"'1. Enrolment'!H45","v":0},{"$f":"'1. Enrolment'!I45","v":2281400},{"$f":"'1. Enrolment'!J45","v":131150},{"$f":"'1. Enrolment'!K45","v":3050},{"$f":"'1. Enrolment'!L45","v":3050},{"$f":"'1. Enrolment'!M45","v":2284450},{"$f":"'1. Enrolment'!N45","v":134200},{"$f":"'1. Enrolment'!O45","v":6100},{"$f":"'1. Enrolment'!P45","v":6100},{"$f":"'1. Enrolment'!Q45","v":2287500},{"$f":"'1. Enrolment'!R45","v":137250},{"$f":"SUM(C7:Q7)","v":12772228.214479506},{"$f":"SUMIFS(C7:Q7,$C$6:$Q$6,\"Enrolment Phase\")+SUMIFS(C7:Q7,$C$6:$Q$6,\"Development Year\")","v":5497978.214479506},{"$f":"AVERAGEIF($C$6:$Q$6,\"Steady State\",C7:Q7)","v":661295.45454545459}]
[null,"Operational expenditure",{"$f":"'1. Enrolment'!D46","v":433991.73217192583},{"$f":"'1. Enrolment'!E46","v":2461491.7321719257},{"$f":"'1. Enrolment'!F46","v":2568991.7321719257},{"$f":"'1. Enrolment'!G46","v":2498991.7321719257},{"$f":"'1. Enrolment'!H46","v":2408991.7321719257},{"$f":"'1. Enrolment'!I46","v":2411491.7321719257},{"$f":"'1. Enrolment'!J46","v":2411491.7321719257},{"$f":"'1. Enrolment'!K46","v":2413991.7321719257},{"$f":"'1. Enrolment'!L46","v":2416491.7321719257},{"$f":"'1. Enrolment'!M46","v":2418991.7321719257},{"$f":"'1. Enrolment'!N46","v":2421491.7321719257},{"$f":"'1. Enrolment'!O46","v":2423991.7321719257},{"$f":"'1. Enrolment'!P46","v":2426491.7321719257},{"$f":"'1. Enrolment'!Q46","v":2428991.7321719257},{"$f":"'1. Enrolment'!R46","v":2431491.7321719257},{"$f":"SUM(C8:Q8)","v":34577375.982578896},{"$f":"SUMIFS(C8:Q8,$C$6:$Q$6,\"Enrolment Phase\")+SUMIFS(C8:Q8,$C$6:$Q$6,\"Development Year\")","v":7963466.9286877029},{"$f":"AVERAGEIF($C$6:$Q$6,\"Steady State\",C8:Q8)","v":2419446.2776264716}]
["Human resource","Capital expenditure",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Operational expenditure",{"$f":"'2. human resource'!C19","v":14203963.328790462},{"$f":"'2. human resource'!D19","v":17357383.100511074},{"$f":"'2. human resource'!E19","v":17378071.345826235},{"$f":"'2. human resource'!F19","v":17242473.390119251},{"$f":"'2. human resource'!G19","v":17080565.383304942},{"$f":"'2. human resource'!H19","v":17085287.700170361},{"$f":"'2. human resource'!I19","v":17085062.827938672},{"$f":"'2. human resource'!J19","v":17089785.14480409},{"$f":"'2. human resource'!K19","v":17094282.589437824},{"$f":"'2. human resource'!L19","v":17098780.034071553},{"$f":"'2. human resource'!M19","v":17103277.478705283},{"$f":"'2. human resource'!N19","v":17107774.923339013},{"$f":"'2. human resource'!O19","v":17112272.367972746},{"$f":"'2. human resource'!P19","v":17116769.812606476},{"$f":"'2. human resource'!Q19","v":17121267.257240206},254277016.68483818,66181891.165247031,17099556.865417384]
["Helpdesk, IEC and CB","Capital expenditure",{"$f":"'3. Helpdesk,IEC and T&CB'!D34","v":500000},{"$f":"'3. Helpdesk,IEC and T&CB'!E34","v":0},{"$f":"'3. Helpdesk,IEC and T&CB'!F34","v":0},{"$f":"'3. Helpdesk,IEC and T&CB'!G34","v":0},{"$f":"'3. Helpdesk,IEC and T&CB'!H34","v":0},{"$f":"'3. Helpdesk,IEC and T&CB'!I34","v":0},{"$f":"'3. Helpdesk,IEC and T&CB'!J34","v":0},{"$f":"'3. Helpdesk,IEC and T&CB'!K34","v":0},{"$f":"'3. Helpdesk,IEC and T&CB'!L34","v":0},{"$f":"'3. Helpdesk,IEC and T&CB'!M34","v":0},{"$f":"'3. Helpdesk,IEC and T&CB'!N34","v":0},{"$f":"'3. Helpdesk,IEC and T&CB'!O34","v":0},{"$f":"'3. Helpdesk,IEC and T&CB'!P34","v":0},{"$f":"'3. Helpdesk,IEC and T&CB'!Q34","v":0},{"$f":"'3. Helpdesk,IEC and T&CB'!R34","v":0},500000,500000,0]
[null,"Operational expenditure",{"$f":"'3. Helpdesk,IEC and T&CB'!D35","v":664000},{"$f":"'3. Helpdesk,IEC and T&CB'!E35","v":830208.57591825048},{"$f":"'3. Helpdesk,IEC and T&CB'!F35","v":1194564.088528428},{"$f":"'3. Helpdesk,IEC and T&CB'!G35","v":926817.45897463034},{"$f":"'3. Helpdesk,IEC and T&CB'!H35","v":430945.84529115725},{"$f":"'3. Helpdesk,IEC and T&CB'!I35","v":444901.65902461653},{"$f":"'3. Helpdesk,IEC and T&CB'!J35","v":459266.37810046633},{"$f":"'3. Helpdesk,IEC and T&CB'!K35","v":474051.9834452385},{"$f":"'3. Helpdesk,IEC and T&CB'!L35","v":489270.80702661257},{"$f":"'3. Helpdesk,IEC and T&CB'!M35","v":504935.54213892069},{"$f":"'3. Helpdesk,IEC and T&CB'!N35","v":521059.25399001956},{"$f":"'3. Helpdesk,IEC and T&CB'!O35","v":537655.39059835568},{"$f":"'3. Helpdesk,IEC and T&CB'!P35","v":554737.79400931601},{"$f":"'3. Helpdesk,IEC and T&CB'!Q35","v":572320.71184021747},{"$f":"'3. Helpdesk,IEC and T&CB'!R35","v":590418.80916356423},9195154.2980497945,3615590.1234213086,507233.10678440763]
["Software","Capital expenditure",{"$f":"'4. Software'!D38","v":2425000},{"$f":"'4. Software'!E38","v":0},{"$f":"'4. Software'!F38","v":0},{"$f":"'4. Software'!G38","v":0},{"$f":"'4. Software'!H38","v":0},{"$f":"'4. Software'!I38","v":0},{"$f":"'4. Software'!J38","v":0},{"$f":"'4. Software'!K38","v":0},{"$f":"'4. Software'!L38","v":0},{"$f":"'4. Software'!M38","v":0},{"$f":"'4. Software'!N38","v":0},{"$f":"'4. Software'!O38","v":0},{"$f":"'4. Software'!P38","v":0},{"$f":"'4. Software'!Q38","v":0},{"$f":"'4. Software'!R38","v":0},2425000,2425000,0]
[null,"Operational expenditure",{"$f":"'4. Software'!D39","v":0},{"$f":"'4. Software'!E39","v":1883358.5338470065},{"$f":"'4. Software'!F39","v":2770277.5097584645},{"$f":"'4. Software'!G39","v":1958953.1799985254},{"$f":"'4. Software'!H39","v":908871.10095160617},{"$f":"'4. Software'!I39","v":917353.55508683086},{"$f":"'4. Software'!J39","v":926084.54512821732},{"$f":"'4. Software'!K39","v":935071.35317781649},{"$f":"'4. Software'!L39","v":944321.47470326908},{"$f":"'4. Software'!M39","v":953842.62478941714},{"$f":"'4. Software'!N39","v":966266.25394276599},{"$f":"'4. Software'!O39","v":976353.51723609981},{"$f":"'4. Software'!P39","v":986736.33734392864},{"$f":"'4. Software'!Q39","v":997423.37408091663},{"$f":"'4. Software'!R39","v":1008423.5409942984},17133336.901039165,6612589.2236039964,956431.60703956068]
["Facility cost","Capital expenditure",{"$f":"'5. Facility cost'!D26","v":68471000},{"$f":"'5. Facility cost'!E26","v":0},{"$f":"'5. Facility cost'!F26","v":0},{"$f":"'5. Facility cost'!G26","v":0},{"$f":"'5. Facility cost'!H26","v":0},{"$f":"'5. Facility cost'!I26","v":0},{"$f":"'5. Facility cost'!J26","v":0},{"$f":"'5. Facility cost'!K26","v":0},{"$f":"'5. Facility cost'!L26","v":0},{"$f":"'5. Facility cost'!M26","v":0},{"$f":"'5. Facility cost'!N26","v":0},{"$f":"'5. Facility cost'!O26","v":0},{"$f":"'5. Facility cost'!P26","v":0},{"$f":"'5. Facility cost'!Q26","v":0},{"$f":"'5. Facility cost'!R26","v":0},68471000,68471000,0]
[null,"Operational expenditure",{"$f":"'5. Facility cost'!D27","v":11301300},{"$f":"'5. Facility cost'!E27","v":11301300},{"$f":"'5. Facility cost'!F27","v":11301300},{"$f":"'5. Facility cost'!G27","v":11301300},{"$f":"'5. Facility cost'!H27","v":11301300},{"$f":"'5. Facility cost'!I27","v":11301300},{"$f":"'5. Facility cost'!J27","v":11301300},{"$f":"'5. Facility cost'!K27","v":11301300},{"$f":"'5. Facility cost'!L27","v":11301300},{"$f":"'5. Facility cost'!M27","v":11301300},{"$f":"'5. Facility cost'!N27","v":11301300},{"$f":"'5. Facility cost'!O27","v":11301300},{"$f":"'5. Facility cost'!P27","v":11301300},{"$f":"'5. Facility cost'!Q27","v":11301300},{"$f":"'5. Facility cost'!R27","v":11301300},169519500,45205200,11301300]
["Identity Credential ","Capital expenditure",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Operational expenditure",{"$f":"'6. Identity Credential'!C17","v":0},{"$f":"'6. Identity Credential'!D17","v":12516590.741774363},{"$f":"'6. Identity Credential'!E17","v":21241015.01581521},{"$f":"'6. Identity Credential'!F17","v":13260808.327228246},{"$f":"'6. Identity Credential'!G17","v":2952587.0846599024},{"$f":"'6. Identity Credential'!H17","v":3039097.8862404386},{"$f":"'6. Identity Credential'!I17","v":3128143.4543072823},{"$f":"'6. Identity Credential'!J17","v":3219798.0575184864},{"$f":"'6. Identity Credential'!K17","v":3314138.1406037784},{"$f":"'6. Identity Credential'!L17","v":3411242.388123469},{"$f":"'6. Identity Credential'!M17","v":3511191.7900954871},{"$f":"'6. Identity Credential'!N17","v":3614069.709545285},{"$f":"'6. Identity Credential'!O17","v":3719961.9520349624},{"$f":"'6. Identity Credential'!P17","v":3828956.8372295871},{"$f":"'6. Identity Credential'!Q17","v":3941145.2725604144},84698746.657736927,47018414.084817819,3425484.7793562813]
["Central IT","Capital expenditure",{"$f":"'7. Central IT'!D41","v":2180000},{"$f":"'7. Central IT'!E41","v":280000},{"$f":"'7. Central IT'!F41","v":600000},{"$f":"'7. Central IT'!G41","v":60000},{"$f":"'7. Central IT'!H41","v":0},{"$f":"'7. Central IT'!I41","v":120000},{"$f":"'7. Central IT'!J41","v":0},{"$f":"'7. Central IT'!K41","v":4380000},{"$f":"'7. Central IT'!L41","v":580000},{"$f":"'7. Central IT'!M41","v":1200000},{"$f":"'7. Central IT'!N41","v":140000},{"$f":"'7. Central IT'!O41","v":20000},{"$f":"'7. Central IT'!P41","v":240000},{"$f":"'7. Central IT'!Q41","v":20000},{"$f":"'7. Central IT'!R41","v":4480000},14300000,3120000,1016363.6363636364]
[null,"Operational expenditure",{"$f":"'7. Central IT'!D42","v":1177000},{"$f":"'7. Central IT'!E42","v":1219000},{"$f":"'7. Central IT'!F42","v":1309000},{"$f":"'7. Central IT'!G42","v":1318000},{"$f":"'7. Central IT'!H42","v":1318000},{"$f":"'7. Central IT'!I42","v":1336000},{"$f":"'7. Central IT'!J42","v":1336000},{"$f":"'7. Central IT'!K42","v":1339000},{"$f":"'7. Central IT'!L42","v":1342000},{"$f":"'7. Central IT'!M42","v":1342000},{"$f":"'7. Central IT'!N42","v":1345000},{"$f":"'7. Central IT'!O42","v":1348000},{"$f":"'7. Central IT'!P42","v":1348000},{"$f":"'7. Central IT'!Q42","v":1351000},{"$f":"'7. Central IT'!R42","v":1369000},19797000,5023000,1343090.9090909092]
["Total","Capital expenditure",{"$f":"C19+C17+C15+C13+C11+C9+C7","v":76469278.214479506},{"$f":"D19+D17+D15+D13+D11+D9+D7","v":2753550},731150,60000,0,2401400,131150,4383050,583050,3484450,274200,26100,246100,2307500,4617250,{"$f":"SUM(C21:Q21)","v":98468228.214479506},80013978.214479506,1677659.0909090908]
[null,"Operational expenditure",{"$f":"C20+C18+C16+C14+C12+C10+C8","v":27780255.06096239},{"$f":"D20+D18+D16+D14+D12+D10+D8","v":47569332.684222624},57763219.692100257,48507344.088492572,36401261.14637953,36535432.532694168,36647348.93764656,36772998.271117553,36901804.743943408,37031092.321295284,37169586.508905485,37309145.272890672,37449500.183532879,37596762.467929117,37763046.612130404,{"$f":"SUM(C22:Q22)","v":589198130.52424288},181620151.52577782,37052543.545315012]
["Grand total ",null,{"$f":"C22+C21","v":104249533.2754419},{"$f":"D22+D21","v":50322882.684222624},58494369.692100257,48567344.088492572,36401261.14637953,38936832.532694168,36778498.93764656,41156048.271117553,37484854.743943408,40515542.321295284,37443786.508905485,37335245.272890672,37695600.183532879,39904262.467929117,42380296.612130404,{"$f":"R22+R21","v":687666358.73872232},261634129.74025732,38730202.636224099]
["Year on year enrolments",null,{"$f":"'1. Enrolment'!D25","v":0},{"$f":"'1. Enrolment'!E25","v":3038007.4615957192},{"$f":"'1. Enrolment'!F25","v":5155586.1688871868},{"$f":"'1. Enrolment'!G25","v":3218642.7978709335},{"$f":"'1. Enrolment'!H25","v":716647.35064560734},{"$f":"'1. Enrolment'!I25","v":737645.11801952391},{"$f":"'1. Enrolment'!J25","v":759258.11997749575},{"$f":"'1. Enrolment'!K25","v":781504.38289283647},{"$f":"'1. Enrolment'!L25","v":804402.46131159668},{"$f":"'1. Enrolment'!M25","v":827971.45342802641},{"$f":"'1. Enrolment'!N25","v":852231.01701346773},{"$f":"'1. Enrolment'!O25","v":877201.38581196242},{"$f":"'1. Enrolment'!P25","v":902903.38641625305},{"$f":"'1. Enrolment'!Q25","v":929358.45563824929},{"$f":"'1. Enrolment'!R25","v":956588.65838845004}]
["Cumulative enrolments",null,{"$f":"'1. Enrolment'!D26","v":0},{"$f":"'1. Enrolment'!E26","v":3038007.4615957192},{"$f":"'1. Enrolment'!F26","v":8193593.6304829065},{"$f":"'1. Enrolment'!G26","v":11412236.42835384},{"$f":"'1. Enrolment'!H26","v":12128883.778999448},{"$f":"'1. Enrolment'!I26","v":12866528.897018971},{"$f":"'1. Enrolment'!J26","v":13625787.016996467},{"$f":"'1. Enrolment'!K26","v":14407291.399889303},{"$f":"'1. Enrolment'!L26","v":15211693.861200901},{"$f":"'1. Enrolment'!M26","v":16039665.314628927},{"$f":"'1. Enrolment'!N26","v":16891896.331642393},{"$f":"'1. Enrolment'!O26","v":17769097.717454355},{"$f":"'1. Enrolment'!P26","v":18672001.103870608},{"$f":"'1. Enrolment'!Q26","v":19601359.559508856},{"$f":"'1. Enrolment'!R26","v":20557948.217897307}]
["Enrolment Center required",null,{"$f":"'1. Enrolment'!D36","v":0},{"$f":"'1. Enrolment'!E36","v":811},{"$f":"'1. Enrolment'!F36","v":854},{"$f":"'1. Enrolment'!G36","v":826},{"$f":"'1. Enrolment'!H36","v":790},{"$f":"'1. Enrolment'!I36","v":791},{"$f":"'1. Enrolment'!J36","v":791},{"$f":"'1. Enrolment'!K36","v":792},{"$f":"'1. Enrolment'!L36","v":793},{"$f":"'1. Enrolment'!M36","v":794},{"$f":"'1. Enrolment'!N36","v":795},{"$f":"'1. Enrolment'!O36","v":796},{"$f":"'1. Enrolment'!P36","v":797},{"$f":"'1. Enrolment'!Q36","v":798},{"$f":"'1. Enrolment'!R36","v":799}]
["Cumulative expense",null,{"$f":"SUM(C23:$C$23)","v":104249533.2754419},{"$f":"SUM($C23:D$23)","v":154572415.95966452},{"$f":"SUM($C23:E$23)","v":213066785.65176478},{"$f":"SUM($C23:F$23)","v":261634129.74025735},{"$f":"SUM($C23:G$23)","v":298035390.88663685},{"$f":"SUM($C23:H$23)","v":336972223.41933101},{"$f":"SUM($C23:I$23)","v":373750722.35697758},{"$f":"SUM($C23:J$23)","v":414906770.62809515},{"$f":"SUM($C23:K$23)","v":452391625.37203854},{"$f":"SUM($C23:L$23)","v":492907167.6933338},{"$f":"SUM($C23:M$23)","v":530350954.20223927},{"$f":"SUM($C23:N$23)","v":567686199.47512996},{"$f":"SUM($C23:O$23)","v":605381799.6586628},{"$f":"SUM($C23:P$23)","v":645286062.12659192},{"$f":"SUM($C23:Q$23)","v":687666358.73872232}]
["Cost per ID",null,null,{"$f":"D27/D25","v":50.879537958236305},{"$f":"E27/E25","v":26.004070406797467},22.925754420073542,24.572367607534517,26.189831470195795,27.429661265860844,28.798388198859019,29.739727179621539,30.730514510410597,31.39676823665857,31.947947414206581,32.421902520837484,32.920474733782221,33.450145483879311]
[]
["Current term output",null,1,{"$f":"$C$30*((1+$B$1)^(D5-$C$5))","v":1.018},{"$f":"$C$30*((1+$B$1)^(E5-$C$5))","v":1.036324},{"$f":"$C$30*((1+$B$1)^(F5-$C$5))","v":1.0549778320000001},1.0739674329760001,1.0932988467695681,1.1129782260114203,1.133011834079626,1.1534060470930592,1.1741673559407342,1.1953023683476676,1.2168178109779255,1.2387205315755281,1.2610175011438878,1.2837158161644777]
["Enrolment ","Capital expenditure",{"$f":"C7","v":2893278.2144795056},{"$f":"D7","v":2473550},131150,0,0,2281400,131150,3050,3050,2284450,134200,6100,6100,2287500,137250,{"$f":"SUM(C31:Q31)","v":12772228.214479506},{"$f":"SUMIFS(C31:Q31,$C$6:$Q$6,\"Enrolment Phase\")+SUMIFS(C31:Q31,$C$6:$Q$6,\"Development Year\")","v":5497978.214479506},{"$f":"AVERAGEIF($C$6:$Q$6,\"Steady State\",C31:Q31)","v":661295.45454545459}]
[null,"Operational expenditure",{"$f":"C8*C$30","v":433991.73217192583},2505798.5833510202,2662307.7878513387,2636380.8797926628,2587178.6666610907,2636481.1297779148,2683937.7901139171,2735081.199921167,2787196.17663748,2840301.1262068069,2894414.8023993988,2949556.3133700327,3005745.1283396319,3063001.0844026054,3121344.3934622635,39542716.794459261,8238478.983166947,{"$f":"AVERAGEIF($C$6:$Q$6,\"Steady State\",C32:Q32)","v":2845839.8010265739}]
["Human resource","Capital expenditure",{"$f":"C9","v":0},{"$f":"D9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Operational expenditure",{"$f":"C10*C$30","v":14203963.328790462},17669815.996320274,18009312.409392029,18190427.195425697,18343970.958486736,18679325.339322541,19015302.917532843,19362928.810941231,19716648.909375183,20076829.342418011,20443588.076803751,20817045.232920427,21197323.124120422,21584546.29674815,21978841.570898261,289289869.50949603,68073518.929928467,20110577.325415235]
["Helpdesk, IEC and CB","Capital expenditure",{"$f":"C11","v":500000},{"$f":"D11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,500000,500000,0]
[null,"Operational expenditure",{"$f":"C12*C$30","v":664000},845152.33028477896,1237955.4344801346,977771.87352880451,462821.80321901664,486410.47073748085,511153.47876494721,537106.50721237413,564327.90749059618,592878.83043375763,622823.36034373927,654228.65544837271,687165.09508025576,721706.43389764207,757929.96348426386,10323432.144406164,3724879.638293718,599868.40964658605]
["Software","Capital expenditure",{"$f":"C13","v":2425000},{"$f":"D13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,2425000,2425000,0]
[null,"Operational expenditure",{"$f":"C14*C$30","v":0},1917258.9874562526,2870905.0700229309,2066652.1788243502,976097.96319506748,1002941.5838563957,1030711.9341733964,1059446.9088593156,1089186.0993225859,1119970.8727325597,1154980.341792217,1188044.3495838293,1222290.5603195608,1257768.3307660227,1294529.2489669684,19250784.429871455,6854816.2363035334,1126906.1994152651]
["Facility cost","Capital expenditure",{"$f":"C15","v":68471000},{"$f":"D15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,68471000,68471000,0]
[null,"Operational expenditure",{"$f":"C16*C$30","v":11301300},11504723.4,11711808.4212,11922620.9727816,12137228.15029167,12355698.25699692,12578100.825622864,12804506.640484078,13034987.760012789,13269617.539693018,13508470.655407496,13751623.12720483,13999152.343494516,14251137.085677419,14507657.553219613,192638632.73208681,46440452.793981597,13290743.630736835]
["Identity Credential ","Capital expenditure",{"$f":"C17","v":0},{"$f":"D17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Operational expenditure",{"$f":"C18*C$30","v":0},12741889.375126302,22012573.645249683,13989858.819626803,3170982.3719502869,3322642.2142465035,3481555.5524841556,3648069.3025150374,3822546.9722741451,4005369.4553358895,4196935.8624240225,4397664.3926905207,4607993.246665488,4828381.582871058,5059310.5201876657,93285773.313647553,48744321.840002783,4049222.8612404335]
["Central IT","Capital expenditure",{"$f":"C19","v":2180000},{"$f":"D19","v":280000},600000,60000,0,120000,0,4380000,580000,1200000,140000,20000,240000,20000,4480000,14300000,3120000,1016363.6363636364]
[null,"Operational expenditure",{"$f":"C20*C$30","v":1177000},1240942,1356548.1159999999,1390460.7825760001,1415489.0766623681,1460647.2592841431,1486938.9099512575,1517102.8458326194,1547870.9151988854,1575732.5916724652,1607681.6854276129,1640270.4091982436,1669795.2765638118,1703634.6440453923,1757406.95232917,22547521.464741971,5164950.8985759998,1580233.6878332698]
["Total","Capital expenditure",{"$f":"C43+C41+C39+C37+C35+C33+C31","v":76469278.214479506},{"$f":"D43+D41+D39+D37+D35+D33+D31","v":2753550},731150,60000,0,2401400,131150,4383050,583050,3484450,274200,26100,246100,2307500,4617250,{"$f":"SUM(C45:Q45)","v":98468228.214479506},80013978.214479506,1677659.0909090908]
[null,"Operational expenditure",{"$f":"C44+C42+C40+C38+C36+C34+C32","v":27780255.06096239},{"$f":"D44+D42+D40+D38+D36+D34+D32","v":48425580.672538631},59861410.884196125,51174172.70255591,39093768.990466237,39944146.254221894,40787701.408643387,41664242.215765826,42562764.74031166,43480699.758492507,44428894.784598239,45398432.480416253,46389464.77458369,47410175.458408289,48477020.202548206,{"$f":"SUM(C46:Q46)","v":666878730.38870931},187241419.32025304,43603391.915314198]
["Grand total ",null,{"$f":"C45+C46","v":104249533.2754419},{"$f":"D45+D46","v":51179130.672538631},60592560.884196125,51234172.70255591,39093768.990466237,42345546.254221894,40918851.408643387,46047292.215765826,43145814.74031166,46965149.758492507,44703094.784598239,45424532.480416253,46635564.77458369,49717675.458408289,53094270.202548206,765346958.60318875,267255397.53473258,45281051.006223291]
["Cumulative expense",null,{"$f":"SUM(C47:$C$47)","v":104249533.2754419},{"$f":"SUM($C47:D$47)","v":155428663.94798052},{"$f":"SUM($C47:E$47)","v":216021224.83217666},{"$f":"SUM($C47:F$47)","v":267255397.53473258},{"$f":"SUM($C47:G$47)","v":306349166.52519882},{"$f":"SUM($C47:H$47)","v":348694712.77942073},{"$f":"SUM($C47:I$47)","v":389613564.1880641},{"$f":"SUM($C47:J$47)","v":435660856.40382993},{"$f":"SUM($C47:K$47)","v":478806671.14414161},{"$f":"SUM($C47:L$47)","v":525771820.90263414},{"$f":"SUM($C47:M$47)","v":570474915.68723238},{"$f":"SUM($C47:N$47)","v":615899448.16764867},{"$f":"SUM($C47:O$47)","v":662535012.94223237},{"$f":"SUM($C47:P$47)","v":712252688.40064061},{"$f":"SUM($C47:Q$47)","v":765346958.60318875}]
["Cost per ID",null,null,{"$f":"D48/D25","v":51.161383213437311},{"$f":"E48/E25","v":26.364649575554431},23.418319381355726,25.257820266661884,27.100915528212845,28.593839291783283,30.238914748901191,31.47622319466938,32.779475792621781,33.772106132252432,34.661267440870596,35.482807078717038,36.33690235813863,37.228761863350456]
[]
[]
["Category wise ","Constant","Current"]
["Enrolment ",{"$f":"R7+R8","v":47349604.197058402},{"$f":"R32+R31","v":52314945.008938767}]
["Human resource",{"$f":"R9+R10","v":254277016.68483818},{"$f":"R34+R33","v":289289869.50949603}]
["Helpdesk, IEC and CB",{"$f":"R12+R11","v":9695154.2980497945},{"$f":"R36+R35","v":10823432.144406164}]
["Software",{"$f":"R14+R13","v":19558336.901039165},{"$f":"R38+R37","v":21675784.429871455}]
["Facility ",{"$f":"R16+R15","v":237990500},{"$f":"R40+R39","v":261109632.73208681}]
["Identity Credential ",{"$f":"R18+R17","v":84698746.657736927},{"$f":"R42+R41","v":93285773.313647553}]
["Central IT",{"$f":"R20+R19","v":34097000},{"$f":"R44+R43","v":36847521.464741975}]
[]
["Scenario-Inputs"]
["Enrolment timeline","Input"]
["Enrolment start year ",{"$f":"'0.6 UI Inputs'!B7","v":2019}]
["Enrolment phase  end  year",{"$f":"'0.6 UI Inputs'!B8","v":2021}]
["Biometric data points ","Yes / No"]
["Facial photograph",{"$f":"'0.6 UI Inputs'!B9","v":true}]
["electronic signature",{"$f":"'0.6 UI Inputs'!B10","v":false}]
["Voice biometric ",{"$f":"'0.6 UI Inputs'!B11","v":false}]
["finger prints",{"$f":"IF('0.6 UI Inputs'!B12=TRUE, '0.6 UI Inputs'!B12 & \", no. of fingers \" & '0.6 UI Inputs'!C12, '0.6 UI Inputs'!B12)","v":"TRUE, no. of fingers 10"}]
["iris ",{"$f":"IF('0.6 UI Inputs'!B13=TRUE, '0.6 UI Inputs'!B13 & \", no. of iris \" & '0.6 UI Inputs'!C13, '0.6 UI Inputs'!B13)","v":false}]
["Demographic data  points"]
["no. of demographic data points",{"$f":"'0.6 UI Inputs'!B14","v":10}]
["Identity credential "]
["Type of credential ",{"$f":"'0.6 UI Inputs'!B15","v":"Smart card"}]
["Type of chip ",{"$f":"IF(ISBLANK('0.6 UI Inputs'!B16)=TRUE,\"\",'0.6 UI Inputs'!B16)","v":"Hybrid chip "}]
["Card material ",{"$f":"IF(ISBLANK('0.6 UI Inputs'!B17)=TRUE,\"\",'0.6 UI Inputs'!B17)","v":"PC"}]
["Level of security ",{"$f":"IF(ISBLANK('0.6 UI Inputs'!B18)=TRUE,\"\",'0.6 UI Inputs'!B18)","v":"Level 3 (forensic)"}]
["Mag strip",{"$f":"IF(ISBLANK('0.6 UI Inputs'!B19)=TRUE,\"\",'0.6 UI Inputs'!B19)","v":"Yes"}]
["bar code ",{"$f":"IF(ISBLANK('0.6 UI Inputs'!B20)=TRUE,\"\",'0.6 UI Inputs'!B20)","v":"2D barcode"}]
["Crvs linkages"]
["Crvs linkages ",{"$f":"'0.6 UI Inputs'!B21","v":"No linkages with CR department"}]
["Additional points"]
["Eligible population ",{"$f":"'0.7 UI input conversion'!B23","v":0.7}]
["no. of regional offices",{"$f":"'0.7 UI input conversion'!B24","v":20}]
["no. of district offices",{"$f":"'0.7 UI input conversion'!B25","v":765}]

{"sheet":"8.1 Scenario 1","index":25,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"8.2 Scenario 2","index":26,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"8.3 Scenario 3","index":27,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"8.4 Scenario 4","index":28,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"9. Graphs","index":29,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Scenario-Inputs","Scenario 1","Scenario  2","Scenario 3","Scenario 4"]
[null,"Enrolment timeline"]
[null,"Enrolment start year ",{"$f":"'8.1 Scenario 1'!B63","v":0},{"$f":"'8.2 Scenario 2'!B63","v":0},{"$f":"'8.3 Scenario 3'!B63","v":0},{"$f":"'8.4 Scenario 4'!B63","v":0}]
[null,"Enrolment phase  end  year",{"$f":"'8.1 Scenario 1'!B64","v":0},{"$f":"'8.2 Scenario 2'!B64","v":0},{"$f":"'8.3 Scenario 3'!B64","v":0},{"$f":"'8.4 Scenario 4'!B64","v":0}]
[null,"Biometric data points ",{"$f":"'8.1 Scenario 1'!B64","v":0},{"$f":"'8.2 Scenario 2'!B64","v":0},{"$f":"'8.3 Scenario 3'!B64","v":0},{"$f":"'8.4 Scenario 4'!B64","v":0}]
[null,"Facial photograph",{"$f":"'8.1 Scenario 1'!B66","v":0},{"$f":"'8.2 Scenario 2'!B66","v":0},{"$f":"'8.3 Scenario 3'!B66","v":0},{"$f":"'8.4 Scenario 4'!B66","v":0}]
[null,"electronic signature",{"$f":"'8.1 Scenario 1'!B67","v":0},{"$f":"'8.2 Scenario 2'!B67","v":0},{"$f":"'8.3 Scenario 3'!B67","v":0},{"$f":"'8.4 Scenario 4'!B67","v":0}]
[null,"Voice biometric ",{"$f":"'8.1 Scenario 1'!B68","v":0},{"$f":"'8.2 Scenario 2'!B68","v":0},{"$f":"'8.3 Scenario 3'!B68","v":0},{"$f":"'8.4 Scenario 4'!B68","v":0}]
[null,"finger prints",{"$f":"'8.1 Scenario 1'!B69","v":0},{"$f":"'8.2 Scenario 2'!B69","v":0},{"$f":"'8.3 Scenario 3'!B69","v":0},{"$f":"'8.4 Scenario 4'!B69","v":0}]
[null,"iris ",{"$f":"'8.1 Scenario 1'!B70","v":0},{"$f":"'8.2 Scenario 2'!B70","v":0},{"$f":"'8.3 Scenario 3'!B70","v":0},{"$f":"'8.4 Scenario 4'!B70","v":0}]
[null,"Demographic data  points"]
[null,"no. of demographic data points",{"$f":"'8.1 Scenario 1'!B72","v":0},{"$f":"'8.2 Scenario 2'!B72","v":0},{"$f":"'8.3 Scenario 3'!B72","v":0},{"$f":"'8.4 Scenario 4'!B72","v":0}]
[null,"Identity credential "]
[null,"Type of credential ",{"$f":"'8.1 Scenario 1'!B74","v":0},{"$f":"'8.2 Scenario 2'!B74","v":0},{"$f":"'8.3 Scenario 3'!B74","v":0},{"$f":"'8.4 Scenario 4'!B74","v":0}]
[null,"Type of chip ",{"$f":"'8.1 Scenario 1'!B75","v":0},{"$f":"'8.2 Scenario 2'!B75","v":0},{"$f":"'8.3 Scenario 3'!B75","v":0},{"$f":"'8.4 Scenario 4'!B75","v":0}]
[null,"Card material ",{"$f":"'8.1 Scenario 1'!B76","v":0},{"$f":"'8.2 Scenario 2'!B76","v":0},{"$f":"'8.3 Scenario 3'!B76","v":0},{"$f":"'8.4 Scenario 4'!B76","v":0}]
[null,"Level of security ",{"$f":"'8.1 Scenario 1'!B77","v":0},{"$f":"'8.2 Scenario 2'!B77","v":0},{"$f":"'8.3 Scenario 3'!B77","v":0},{"$f":"'8.4 Scenario 4'!B77","v":0}]
[null,"Mag strip",{"$f":"'8.1 Scenario 1'!B78","v":0},{"$f":"'8.2 Scenario 2'!B78","v":0},{"$f":"'8.3 Scenario 3'!B78","v":0},{"$f":"'8.4 Scenario 4'!B78","v":0}]
[null,"bar code ",{"$f":"'8.1 Scenario 1'!B79","v":0},{"$f":"'8.2 Scenario 2'!B79","v":0},{"$f":"'8.3 Scenario 3'!B79","v":0},{"$f":"'8.4 Scenario 4'!B79","v":0}]
[null,"Crvs linkages"]
[null,"Crvs linkages ",{"$f":"'8.1 Scenario 1'!B80","v":0},{"$f":"'8.2 Scenario 2'!B80","v":0},{"$f":"'8.3 Scenario 3'!B80","v":0},{"$f":"'8.4 Scenario 4'!B80","v":0}]
[null,"Additional points"]
[null,"Eligible population ",{"$f":"'8.1 Scenario 1'!B83","v":0},{"$f":"'8.2 Scenario 2'!B83","v":0},{"$f":"'8.3 Scenario 3'!B83","v":0},{"$f":"'8.4 Scenario 4'!B83","v":0}]
[null,"no. of regional offices",{"$f":"'8.1 Scenario 1'!B84","v":0},{"$f":"'8.2 Scenario 2'!B84","v":0},{"$f":"'8.3 Scenario 3'!B84","v":0},{"$f":"'8.4 Scenario 4'!B84","v":0}]
[null,"no. of district offices",{"$f":"'8.1 Scenario 1'!B85","v":0},{"$f":"'8.2 Scenario 2'!B85","v":0},{"$f":"'8.3 Scenario 3'!B85","v":0},{"$f":"'8.4 Scenario 4'!B85","v":0}]