{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cover","Template- BTAT","Input 1- NHM","Input 2- DDGs","Input 3- Budget & Pop.","Output Sheet","Budget Adequacy","Charts","Export Charts to PDF"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Version 1: 2017"]
[null,"Budget Tracking and Analysis Tool (BTAT)"]
[]
[null,"To use this budget tracking and analysis tool, please see the Training Manual and follow the instructions below."]
[]
[null,"Instructions"]
[]
[null,"If asked to \"Enable macros\"  at the top of your screen in a yellow command bar, please click \"enable\" (this will enable automatic updates on the summary tab)"]

{"sheet":"Template- BTAT","index":1,"n_rows":103,"n_cols":16,"rows_kept":103,"cut":false,"hidden":false,"merged":[[7,0,7,4],[6,0,6,6],[7,5,8,5],[7,6,8,6]]}
["Template: BTAT"]
["Instructions:"]
["1. Please note that this a pre-designed template for reference. However, the user can add/delete Direct Nutrition Interventions (DNIs) as per their requirement."]
["2. Please enter DNIs under respective \"Category of DNIs\" in columns A to E. These would be reflected in the subsequent sheets."]
["3. Please enter the year/s and kind of estimates to be used in columns F and G respectively. These would be reflected in subsequent sheets."]
[]
[]
["Categories of DNIs",null,null,null,null,"Year of Analysis","Estimates of Budget"]
["Behaviour Change Interventions   ","Micronutrient Supplementation and Deworming Interventions ","Supplementary Feeding ","Severe Acute Malnutrition Treatment ","Others"]
["BCC for breastfeeding, complementary feeding and hand washing","Adolescent: IFA","Supplementary Feeding: Children and P & L Women","SAM Treatment","Conditional Cash Transfers for P & L Women","2014-15","Approved Budget"]
[null,"Adolescent: Deworming","Supplementary Feeding: Adolescent Girls",null,"Insecticide Treated Bed-nets for PW","2015-16","Proposed Budget"]
[null,"Child: Deworming",null,null,null,"2016-17","Actual Expenditure"]
[null,"Child: IFA",null,null,null,"2017-18","Budget Estimates"]
[null,"Child: Diarrhoea Control (ORS + Zinc)",null,null,null,null,"Revised Estimates"]
[null,"Child Vit. A"]
[null,"P and L Women: Calcium and IFA"]
[null,"Pregnant Women: Deworming"]
[null,"Salt iodisation for general population"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"BCC for breastfeeding, complementary feeding and hand washing","Adolescent: IFA","Supplementary Feeding: Children and P & L Women","SAM Treatment","Conditional Cash Transfers for P & L Women","Adolescent: Deworming","Supplementary Feeding: Adolescent Girls","Insecticide Treated Bed-nets for PW","Child: Deworming","Child: IFA","Child: Diarrhoea Control (ORS + Zinc)","Child Vit. A","P and L Women: Calcium and IFA","Pregnant Women: Deworming","Salt iodisation for general population"]
[null,"2014-15","2015-16","2016-17","2017-18"]
[null,"Approved Budget","Proposed Budget","Actual Expenditure","Budget Estimates","Revised Estimates"]

{"sheet":"Input 1- NHM","index":2,"n_rows":59,"n_cols":19,"rows_kept":59,"cut":false,"hidden":false,"merged":[[7,0,8,0],[7,1,8,1],[7,3,8,3],[7,2,8,2],[0,0,0,3]]}
["NHM-ROP Budget Data (values in INR lakh)"]
["Instructions:"]
["1. Fill in the FMR Codes and Programmatic Interventions from SPIP/ROP/FMR."]
["2. For each entry, choose the relevant DNI Category and DNIs  in column C and D from the Drop-Down list."]
["3. Choose the relevant years from the Drop-Down list from Column E onwards."]
["4. Choose the estimates of budget from the Drop Down list from Column E onwards."]
[]
["FMR Codes","Programmatic Interventions","DNIs Category","DNIs","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29"]
[null,null,null,null,"Approved Budget","Approved Budget","Approved Budget","Approved Budget","Approved Budget","Approved Budget","Actual Expenditure","Budget Estimates","Proposed Budget"]
["Annexure A","Reproductive and Child Health"]
["A.1.3","Janani Suraksha Yojana","Others","Conditional Cash Transfers for P & L Women",null,null,34339.71,34414.71]
["A.1.6.1","Drugs and Consumables under JSSK","Micronutrient Supplementation and Deworming Interventions ","P and L Women: Calcium and IFA",null,null,1120]
["A.2.4","Infant and Young Child Feeding/IYCF","Behaviour Change Interventions   ","BCC for breastfeeding, complementary feeding and hand washing",null,null,0,3.8]
["A.2.5","Care of Sick Children and Severe Malnutrition (e.g. NRCs, CDNCs, Community Based Programme etc.)","Severe Acute Malnutrition Treatment ","SAM Treatment",null,null,734.69,452.4]
["A.2.6","Management of Diarrhoea & ARI & micronutrient malnutrition","Micronutrient Supplementation and Deworming Interventions ","Child Vit. A",null,null,380,517.30999999999995]
["A.2.7","Micronutrient Supplementation Programme (cost of activities except cost of procurement of supplements)","Micronutrient Supplementation and Deworming Interventions ","Child Vit. A",null,null,31.16,272.5]
["A.2.11","National Iron Plus Initiative ( procurement to be budgeted under B.16.2.6 & printing under IEC)","Micronutrient Supplementation and Deworming Interventions ","Child: IFA",null,null,38.06,260.60000000000002]
["A.4.3","Weekly Iron and Folic Acid Supplementation Programme activities (procurement to be budgeted under B16.2.6)","Micronutrient Supplementation and Deworming Interventions ","Adolescent: IFA",null,null,0,0]
["A4.5.9","WIFS-Supply Chain management","Micronutrient Supplementation and Deworming Interventions ","Adolescent: IFA",null,null,100,0]
["A9.2.2.1","Training NIPI","Micronutrient Supplementation and Deworming Interventions ","Child: IFA",null,null,236.6]
["A9.2.2.2","Training on facility based management of SAM for NRC staff","Severe Acute Malnutrition Treatment ","SAM Treatment",null,null,9.82]
["A9.2.2.4","Orientation of district, block And below functionaries for NDD",null,null,null,null,76.7]
["A9.5.4","Care of sick children and severe malnutrition at FRUs","Severe Acute Malnutrition Treatment ","SAM Treatment",null,null,null,9.82]
["A.9.5.5.2.c","4 day Training on IYCF for MOs, SNs, ANMs, of all DPs and SCs","Others","BCC for breastfeeding, complementary feeding and hand washing",null,null,78.34,86.64]
["A.9.5.2.d","Orientation on National Deworming Day","Micronutrient Supplementation and Deworming Interventions ","Child: Deworming",null,null,null,226.08]
["A.9.7.3","WIFS Training","Micronutrient Supplementation and Deworming Interventions ","Adolescent: IFA",null,null,4.8,6.7]
["Annexure HR","NIDDCP - PMU","Micronutrient Supplementation and Deworming Interventions ","Salt iodisation for general population",null,null,null,218.05]
["ANNEXURE B","Mission Flexible Pool"]
["B1.1.3.2.8","Incentives to ASHAs for Alternate Service deliveries for Vit. A round",null,null,null,null,240]
["B1.1.3.2.4","Incentive for referral of SAM cases to NRC","Severe Acute Malnutrition Treatment ","SAM Treatment",null,null,null,0]
["B1.1.3.2.5","Incentive for follow-up of discharged SAM children from NRCs","Severe Acute Malnutrition Treatment ","SAM Treatment",null,null,null,22.5]
["B1.1.3.2.6","ASHA incentive under MAA programme @Rs. 100 per ASHA for quarterly mother's meeting","Behaviour Change Interventions   ","BCC for breastfeeding, complementary feeding and hand washing",null,null,null,348]
["B1.1.3.2.7","Incentive for National Deworming Day for mobilising out of school children ","Micronutrient Supplementation and Deworming Interventions ","Child: Deworming",null,null,null,174]
["B1.1.3.2.8","Incentive for IDCF for distribution of ORS to family with under five children","Micronutrient Supplementation and Deworming Interventions ","Child: Diarrhoea Control (ORS + Zinc)",null,null,null,87]
["B1.1.3.2.9","ASHA / Other incentive for Vit. A bi-annual round ","Micronutrient Supplementation and Deworming Interventions ","Child Vit. A",null,null,null,240]
["B1.1.3.5.2","Incentive for mobilising children and / or ensuring compliance (0-6years)","Micronutrient Supplementation and Deworming Interventions ","Child: IFA",null,null,null,1044]
["B1.1.3.6.9","Incentive for mobilising and ensuring every eligible child (1-19 years) is administered albendazole during NDD ","Micronutrient Supplementation and Deworming Interventions ","Child: Deworming",null,null,190]
["B4.1.5.4.3","Infrastructure IYCF Counselling Centres ","Behaviour Change Interventions   ","BCC for breastfeeding, complementary feeding and hand washing",null,null,4,6]
["B10.6.7","Health Education and Publicity for NIDDCP","Micronutrient Supplementation and Deworming Interventions ","Salt iodisation for general population",null,null,null,8]
["B10.7.2","Printing of WIFS cards","Micronutrient Supplementation and Deworming Interventions ","Adolescent: IFA",null,null,0,0]
["B10.7.4.1","Printing of NIPI cards","Micronutrient Supplementation and Deworming Interventions ","Child: IFA",null,null,137.63,137.63]
["B10.7.4.7","Printing of IEC material and reporting formats etc. for NDD","Micronutrient Supplementation and Deworming Interventions ","Child: Deworming",null,null,null,265.44]
["B10.7.4.8","Printing of IEC materials and reporting formats for IDCF","Micronutrient Supplementation and Deworming Interventions ","Child: Diarrhoea Control (ORS + Zinc)",null,null,null,122.5]
["B16. 1.2.2","Procurement of equipment for IYCF counselling centres","Behaviour Change Interventions   ","BCC for breastfeeding, complementary feeding and hand washing",null,null,null,0]
["B16.1.2.5","Equipment for IYCF counseling ","Behaviour Change Interventions   ","BCC for breastfeeding, complementary feeding and hand washing",null,null,12.45]
["B16.2.2.2","Vit A solution ","Micronutrient Supplementation and Deworming Interventions ","Child Vit. A",null,null,null,399.59]
["B16.2.2.3","ORS ","Micronutrient Supplementation and Deworming Interventions ","Child: Diarrhoea Control (ORS + Zinc)",null,null,null,930.86]
["B16.2.2.4","Zinc tablet for Diarrhoea programme","Micronutrient Supplementation and Deworming Interventions ","Child: Diarrhoea Control (ORS + Zinc)",null,null,178.52,178.52]
["B16.2.2.5","ORS packet for Diarrhoea program","Micronutrient Supplementation and Deworming Interventions ","Child: Diarrhoea Control (ORS + Zinc)",null,null,930.86]
["B.16.2.6.1.a","IFA Syrup with auto dispenser","Micronutrient Supplementation and Deworming Interventions ","Child: IFA",null,null,1176.19,1517.63]
["B.16.2.6.1.b","Albendazole Tablets","Micronutrient Supplementation and Deworming Interventions ","Child: Deworming",null,null,294.05,328.54]
["B.16.2.6.3.a","IFA tablets  ","Micronutrient Supplementation and Deworming Interventions ","Adolescent: IFA",null,null,2549.39,0]
["B.16.2.6.3.b","Albendazole Tablets","Micronutrient Supplementation and Deworming Interventions ","Adolescent: Deworming",null,null,437.65,426.59]
[]
["B.30.8","Staff for NRC","Severe Acute Malnutrition Treatment ","SAM Treatment",null,null,null,409.68]
["IEC-FMR B10.7. 4.8","IDCF related IEC (adding up heads)","Micronutrient Supplementation and Deworming Interventions ","Child: Diarrhoea Control (ORS + Zinc)",null,null,null,49.51]
["Annexure D","NATIONAL IODINE DEFICIENCY DISORDERS CONTROL PROGRAMME (NIDDCP): TOTAL","Micronutrient Supplementation and Deworming Interventions ","Salt iodisation for general population",null,null,13.52,17.399999999999999]
["Annexure F","National Vector Borne Disease Control Programme ","Others","Insecticide Treated Bed-nets for PW"]
["F.1.1.c.iii","Impregnation of bed-nets ","Others","Insecticide Treated Bed-nets for PW",null,null,0,0]

{"sheet":"Input 2- DDGs","index":3,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,12],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,8,9,8],[8,7,9,7]]}
["Detailed Demand for Grants (DDGs) Budget Data (values in INR lakh)"]
["Department/Demand Number:"]
["Instructions:"]
["1. Fill in the relevant budget heads in Columns A to G from the State Budget Documents. "]
["2. For each entry, choose the relevant DNI Category and DNIs  in column C and D from the Drop-Down list."]
["3. Choose the relevant years from the Drop-Down list from Column E onwards."]
["4. Choose the estimates of budget from the Drop Down list from Column E onwards."]
[]
["Major Head","Sub-Major Head","Minor head","Sub Minor Head","Detailed Head","Object Head","Scheme Head Name","DNI Category","DNI","2014-15","2015-16","2016-17","2017-18","2018-19"]
[null,null,null,null,null,null,null,null,null,"Actual Expenditure","Actual Expenditure","Revised Estimates","Budget Estimates","Budget Estimates"]
["Revenue Expenditure"]
["2235 Social Security and Welfare","02 Social Welfare","102 Child Welfare","0002 Special Nutritious Meal Scheme",null,2235021020002,"Special Nutritious meal scheme","Supplementary Feeding ","Supplementary Feeding: Children and P & L Women",null,39.26,45.01,56.34]
[null,null,null,"0222 ICDS",null,"2235-02-102-0222-20","Training","Behaviour Change Interventions   ","BCC for breastfeeding, complementary feeding and hand washing",null,872.74906999999996,3511.79,3939.41]
[null,null,null,"0222 ICDS",null,"2235-02-102-0222-26","Advertising and printing","Behaviour Change Interventions   ","BCC for breastfeeding, complementary feeding and hand washing",null,294.32972000000001,1672.18,2239.5500000000002]
[null,null,null,"0224 Rajiv Gandhi Scheme for empowerment of adolescent girls - SABLA",null,2235021020224,"SABLA Diet","Supplementary Feeding ","Supplementary Feeding: Adolescent Girls",null,880.56057999999996,12899.72,154]
[null,null,null,"0322 ICDS",null,"0322-20-03","Training","Behaviour Change Interventions   ","BCC for breastfeeding, complementary feeding and hand washing",null,485.33969000000002,1003,1212.79]
[null,null,null,"0322 ICDS",null,"2235-02-102-0322-26","Advertising and printing","Behaviour Change Interventions   ","BCC for breastfeeding, complementary feeding and hand washing",null,25.583839999999999,3,769.04]
[null,null,null,"0324 Rajiv Gandhi Scheme for empowerment of adolescent girls - SABLA",null,2235021020324,"SABLA Diet","Supplementary Feeding ","Supplementary Feeding: Adolescent Girls",null,436.26227,2823.79,3827]
[null,null,null,"0219 Indira Gandhi Matritva Sahyog Yojana and NMEW",null,2235021030219,"IGMSY","Others","Conditional Cash Transfers for P & L Women",null,2961.4647399999999,7016,5153.46]
[null,null,null,"0319 Indira Gandhi Matritva Sahyog Yojana and NMEW",null,2235021030319,"IGMSY","Others","Conditional Cash Transfers for P & L Women",null,1407.3779999999999,1386.74,2576.73]
[null,null,null,"0312 Rajiv Gandhi Scheme for empowerment of adolescent girls - SABLA",null,2235027890312,"SABLA Diet","Supplementary Feeding ","Supplementary Feeding: Adolescent Girls",null,139.40702999999999,1411.69,1275.6600000000001]
[null,null,null,"0319 Indira Gandhi Matritva Sahyog Yojana and NMEW",null,2235027890313,"IGMSY","Others","Conditional Cash Transfers for P & L Women",null,345.16399999999999,693.26,858.91]
[null,null,null,"0203 ICDS",null,2236021010203,"SNP-ICDS","Supplementary Feeding ","Supplementary Feeding: Children and P & L Women",null,46388.329899999997,59663.88,70691.5]
[null,null,null,"0303 ICDS",null,2236021010303,"SNP-ICDS","Supplementary Feeding ","Supplementary Feeding: Children and P & L Women",null,26456.014190000002,841,26940.91]
[null,null,null,"0204 ICDS",null,2236027890204,"SNP-ICDS-SCSP","Supplementary Feeding ","Supplementary Feeding: Children and P & L Women",null,0,33680.68,23563.84]
[null,null,null,"0304 ICDS",null,2236027890304,"SNP-ICDS-SCSP","Supplementary Feeding ","Supplementary Feeding: Children and P & L Women",null,33407.167759999997,21089.96,48692]
[null,null,null,"0305 ICDS",null,2236027960305,"SNP-ICDS-TSP","Supplementary Feeding ","Supplementary Feeding: Children and P & L Women",null,1629.2007599999999,7247.94,8776.9599999999991]
[null,null,null,"0101 Refund of unpaid amount of advance pay, travel allowance advance and other items",null,2236029110101,"Recoveries","Supplementary Feeding ","Supplementary Feeding: Children and P & L Women",null,-76.754559999999998,0,0]
[null,null,null,"0102 Return of excess, unexpected withdrawal",null,2236029110102,"Recoveries","Supplementary Feeding ","Supplementary Feeding: Children and P & L Women",null,-220.40700000000001,0,0]
[null,null,null,"0602 Return of excess, unexpected withdrawa ",null,2236029110602,"Recoveries","Supplementary Feeding ","Supplementary Feeding: Children and P & L Women",null,-97.689220000000006,0,0]
[]
[]
[]
["Capital Expenditure"]
[]
[]
[]
["Loans and Advances"]

{"sheet":"Input 3- Budget & Pop.","index":4,"n_rows":88,"n_cols":9,"rows_kept":88,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Total State Budget",null,null,null,"State population for computing per capita DNI budget"]
[null,"(values in INR crore)",null,null,null,"(values in INR crore)"]
[]
[null,"Instructions:",null,null,null,"Instructions:"]
[null,"1. Choose the relevant years from the Drop-Down list from Column B.",null,null,null,"1. Choose the relevant years from the Drop-Down list from Column F."]
[null,"2. Choose the estimates of budget from the Drop Down list from Column C.",null,null,null,"2. Enter the relevant population in Columns G and H."]
[null,"3. Enter values for Total State Budget from the State Budget Documents in Column D."]
[]
[null,"Year","Estimates of Expenditure","Total State Budget ",null,"Year","Children (0-6 years)","Female (11-49 years)","Total"]
[null,"2014-15","Actual Expenditure",94698.04,null,"2014-15 ",1.9133964000000001,2.7817647000000001,{"$f":"G10+H10","v":4.6951611}]
[null,"2015-16","Actual Expenditure",112328.03,null,"2015-16",1.9133964000000001,2.7817647000000001,{"$f":"G11+H11","v":4.6951611}]
[null,"2016-17","Revised Estimates",154327.47,null,"2016-17",1.9133964000000001,2.7817647000000001,4.6951611]
[null,"2017-18","Budget Estimates",160085.69,null,"2017-18",1.9133964000000001,2.7817647000000001,4.6951611]
[null,"2018-19",null,null,null,"2018-19",1.9,2.8,4.6999999999999993]
[null,"2019-20",null,null,null,"2019-20",null,null,0]
[null,"2020-21",null,null,null,"2020-21",null,null,0]
[null,"2021-22",null,null,null,"2021-22",null,null,0]
[null,"2022-23",null,null,null,"2022-23",null,null,0]
[null,"2023-24",null,null,null,"2023-24",null,null,0]
[null,"2024-25",null,null,null,"2024-25",null,null,0]
[null,"2025-26",null,null,null,"2025-26",null,null,0]
[null,"2026-27",null,null,null,"2026-27",null,null,0]
[null,"2027-28",null,null,null,"2027-28",null,null,0]
[null,"2028-29",null,null,null,"2028-29",null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Actual Expenditure"]
[null,null,null,"Budget Estimates"]
[null,null,null,"Revised Estimates"]

{"sheet":"Output Sheet","index":5,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[10,0,11,0],[10,1,11,1],[10,2,10,17],[39,0,41,0],[14,0,14,1],[26,0,26,1],[33,0,33,1],[38,0,38,1],[30,0,30,1]]}
["DNI Budget (values in INR crore)"]
["Instructions:"]
["1. The present template provides a list of Direct Nutrition Interventions (DNIs), which can be amended as per user's discretion."]
["2. Choose the relevant DNI in Column B from the Drop-Down list, for each entry in Column A. Also ensure that relevant DNIs are added / chosen for correct DNI Category as in Category Sheet of the tool."]
["3. Additional DNIs can be added to any DNI category by inserting additional rows below the Category Sub-Total."]
["4. Choose the relevant years from the Drop-Down list from Column C onwards."]
["5. The sheet will compute the total budget outlays for DNIs entered on pressing the \"UPDATE\" button"]
[]
[]
[]
["Direct Nutrition Interventions","Interventions","Budget Outlays"]
[null,null,"2014-15","2015-16","2016-17","2017-18"]
["I. Behaviour Change Interventions"]
["Combined budget outlays for three interventions : \n(i) Counselling for mothers during pregnancy\n(ii) Counselling for optimal breastfeeding to caregivers of children 0–6months\n(iii) Counselling for complementary feeding and hand washing to caregivers of children 6 -23 months, under schemes IYCF and IEC-ICDS.","BCC for breastfeeding, complementary feeding and hand washing",0,16.780023199999999,62.8476,86.052300000000002]
["I. Behaviour Change Interventions (Sub-Total)   ",null,{"$f":"SUM($C$14:$C$14)","v":0},{"$f":"SUM($D$14:$D$14)","v":16.780023199999999},{"$f":"SUM($E$14:$E$14)","v":62.8476},{"$f":"SUM($F$14:$F$14)","v":86.052300000000002}]
["II. Micronutrient Supplementation and Deworming Interventions "]
["Vitamin A supplementation for children 6–59 months","Child Vit. A",0,0,4.1116000000000001,14.293999999999999]
["Treatment of diarrhoea for children under 5 years (ORS + Zinc)","Child: Diarrhoea Control (ORS + Zinc)",0,0,11.093800000000002,13.683900000000001]
["Deworming for children 12–59 months","Child: Deworming",0,0,4.8405000000000005,9.9405999999999999]
["Deworming for adolescents 10–19 years","Adolescent: Deworming",0,0,4.3765000000000001,4.2658999999999994]
["Deworming for pregnant women","Pregnant Women: Deworming"]
["Iron folic acid supplements (IFA) for children 6–59 months","P and L Women: IFA "]
["Iron-folic acid supplements (IFA) for adolescents 10-19 years","Adolescent: IFA",0,0,26.541900000000002,6.7000000000000004E-2]
["Iron folic acid supplements for pregnant women and breastfeeding mothers of children 0-6 months","P and L Women: IFA "]
["Calcium supplementation for pregnant women and breastfeeding mothers ","P and L Women: Calcium "]
["Salt iodization for general population","Salt iodisation for general population",0,0,0.13519999999999999,2.4345000000000003]
["II. Micronutrient Supplementation and Deworming Interventions (Sub-Total)",null,{"$f":"SUM($C$16:$C$26)","v":0},{"$f":"SUM($D$16:$D$26)","v":0},{"$f":"SUM($E$16:$E$26)","v":51.099500000000006},{"$f":"SUM($F$16:$F$26)","v":44.685899999999997}]
["III. Supplementary Feeding "]
["(i) Complementary food supplements for children 6–36 months of age\n(ii) Supplementary food for pregnant and lactating women for 6 months after delivery\n(iii) Additional food ration for severely underweight (WAZ< -3) children 6–59 months","Supplementary Feeding: Children and P & L Women",0,1075.2512182999999,1225.6846999999998,1787.2155000000002]
["Adolescent Supplementary Feeding","Supplementary Feeding: Adolescent Girls",0,14.562298800000001,171.35199999999998,52.566600000000001]
["III. Supplementary Feeding (Sub-Total)",null,{"$f":"SUM($C$28:$C$30)","v":0},{"$f":"SUM($D$28:$D$30)","v":1089.8135170999999},{"$f":"SUM($E$28:$E$30)","v":1397.0366999999997},{"$f":"SUM($F$28:$F$30)","v":1839.7821000000004}]
["IV. Severe Acute Malnutrition Treatment "]
["Facility-based treatment for children 6–59 months for children with severe acute malnutrition","SAM Treatment",0,0,7.4451000000000009,8.9439999999999991]
["IV. Severe Acute Malnutrition Treatment (Sub-Total)",null,{"$f":"SUM($C$32:$C$33)","v":0},{"$f":"SUM($D$32:$D$33)","v":0},{"$f":"SUM($E$32:$E$33)","v":7.4451000000000009},{"$f":"SUM($F$32:$F$33)","v":8.9439999999999991}]
["V. Others "]
["Facility-based treatment for children 6–59 months for children with severe acute malnutrition","Insecticide Treated Bed-nets for PW",0,0,0,0]
["Conditional Cash Transfers for P and L women","Conditional Cash Transfers for P & L Women",150,47.140067399999992,434.35709999999995,430.03809999999993]
[]
["V. Others (Sub-Total)",null,{"$f":"SUM($C$35:$C$38)","v":150},{"$f":"SUM($D$35:$D$38)","v":47.140067399999992},{"$f":"SUM($E$35:$E$38)","v":434.35709999999995},{"$f":"SUM($F$35:$F$38)","v":430.03809999999993}]
[null,"Total DNI Budget (I + II + III + IV + V)",150,1153.7336076999998,1952.7859999999998,2409.5024000000003]
[null,"Total DNI budget as a % of Total State Budget",0.15839820972007446,1.0271110493970204,1.2653521761226305,1.5051329072573572]
[null,"Per Capita DNI Budget (in INR)",31.947785561607247,245.72822596012728,415.91458917139175,513.18843990252014]

{"sheet":"Budget Adequacy","index":6,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,12],[9,0,10,0]]}
["Resource Gap Analysis for DNIs (values in INR crore)"]
[]
["Instructions:"]
["1. Choose the relevant DNIs for which analysis has to be done in Column A, from the Drop-Down list."]
["2. Select the year/s from the Drop-Down list."]
["3. Enter manually the Resource Requirement / Cost Estimates for each DNI in respective columns, in INR crore."]
["4. Press the UPDATE button to automatically fill-in the Budget Outlays and compute the associated Resource Gap. "]
[]
[]
["Direct Nutrition Interventions",null,null,0]
[null,"Resource Requirement","Budget Outlays ","Resource Gap ","Percentage of Resource Gap ","Resource Requirement","Budget Outlays ","Resource Gap ","Percentage of Resource Gap ","Resource Requirement","Budget Outlays ","Resource Gap ","Percentage of Resource Gap ","Resource Requirement","Budget Outlays ","Resource Gap ","Percentage of Resource Gap "]
["Adolescent: IFA"]
["Adolescent: Deworming"]
["SAM Treatment"]
["Child: IFA"]
["Child Vit. A"]
["BCC for breastfeeding, complementary feeding and hand washing"]
["Conditional Cash Transfers for P & L Women"]
["Supplementary Feeding: Adolescent Girls"]
["Supplementary Feeding: Children and P & L Women"]
["Adolescent: IFA"]
["SAM Treatment"]

{"sheet":"Charts","index":7,"n_rows":504,"n_cols":96,"rows_kept":504,"cut":false,"hidden":false,"merged":[[6,5,6,6],[6,8,6,9],[2,5,2,6],[3,5,3,6],[6,11,6,13]]}
[]
["Instructions:",null,null,null,null,"Instructions:",null,null,"Instructions:",null,null,"Instructions:"]
["1. Select the year/s from the Drop-Down list in Column A",null,null,null,null,"1. Select the year/s from the Drop-Down list in Column B",null,null,"1. Select the interventions in Column A from the Drop-Down list",null,null,"1. Select the interventions in Column A from the Drop-Down list. These should befromas the ones selected in \"Budget Adequacy\" sheet"]
["2. Press the UPDATE button to fill-in the tables",null,null,null,null,"2. Press the ADD CHART button to create the respective charts",null,null,"2. Select the year/s from the Drop-Down list in Column B",null,null,"2. Select the year/s from the Drop-Down list in Column B"]
["3. Press the ADD CHART button to create the respective charts",null,null,null,null,null,null,null,"3. Press the ADD CHART button to create the respective charts",null,null,"3. Press the ADD CHART button to create the respective charts"]
[]
[null,"Chart 1: Total DNI Budget (in INR Crore)","Chart 2: DNI Budget as a % of Total State Budget","Chart 3: Per Capita DNI Budget (in INR)",null,"Chart 4: Composition of DNIs Budget (in %)",null,null,"5. Intervention-wise budget outlays",null,null,"Chart 6: Adequacy of Budgets for DNIs (in INR Crore)"]
[]
[]
[null,null,null,null,null,null,"Add Year Drop-Down",null,null,"Add Year Drop-Down",null,null,"Add Year Drop-Down"]
[]
["Year","Total DNI Budget (in INR Crore)","DNI Budget as a % of Total State Budget","Per Capita DNI budget (In INR)",null,"Categories","Composition of DNI Budget(%)",null,"Interventions","Amount (in INR crore)",null,"Direct Nutrition Interventions","Resource Requirement (in INR Crore)","Budget Outlays (In INR Crore)"]
["2014-15",null,null,null,null,"Behaviour Change Interventions",16.420397885919424,null,"Adolescent: IFA",0,null,"Adolescent: IFA",35,11.5]
["2015-16",null,null,null,null,"Micronutrient Supplementation and Deworming Interventions ",23.104058635819705,null,"Adolescent Calcium",null,null,"Adolescent Calcium"]
["2016-17",null,null,null,null,"Supplementary Feeding ",18.263736537694459,null,"P and L Women: Calcium ",null,null,"P and L Women: Calcium "]
["2017-18",null,null,null,null,"Severe Acute Malnutrition Treatment ",29.297965696051058,null,"Child: IFA",null,null,"Child: IFA",59]
[null,null,null,null,null,"Others",12.913841244515359,null,"Child Vit. A",0,null,"Child Vit. A",100,42]
[null,null,null,null,null,null,null,null,"BCC for breastfeeding, complementary feeding and hand washing",16.780023199999999,null,"BCC for breastfeeding, complementary feeding and hand washing",150,805]
[null,null,null,null,null,null,null,null,"Conditional Cash Transfers for P & L Women",47.140067399999992,null,"Conditional Cash Transfers for P & L Women",1600,1000]
[null,null,null,null,null,null,null,null,"SAM Treatment",0,null,"SAM Treatment",100,655.4]
[null,null,null,null,null,null,null,null,"Supplementary Feeding: Children and P & L Women",1075.2512182999999,null,"Supplementary Feeding: Children and P & L Women",160,173.25]
[null,null,null,null,null,null,null,null,"Supplementary Feeding: Adolescent Girls",14.562298800000001,null,"Supplementary Feeding: Adolescent Girls",1550,1291.94]
[null,null,null,null,null,null,null,null,null,null,null,"BCC for breastfeeding, complementary feeding and hand washing",150,805]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year","Per Capita DNI budget (In INR)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-15",2.572423076923077E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-16",2.7402692307692308E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-17",2.9081153846153847E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"I. Behaviour Change Interventions (Sub-Total)   "]
[null,null,null,null,null,"II. Micronutrient Supplementation and Deworming Interventions (Sub-Total)"]
[null,null,null,null,null,"III. Supplementary Feeding (Sub-Total)"]
[null,null,null,null,null,"IV. Severe Acute Malnutrition Treatment (Sub-Total)"]
[null,null,null,null,null,"V. Others (Sub-Total)"]

{"sheet":"Export Charts to PDF","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}