{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Cover Sheet","Keywords","Utilities","Data Sheet","Summary Sheet","Pivot"],"not_rendered":{"charts":6,"images":3,"macros":1,"external_links":0,"defined_names":8,"comments":1,"pivot_tables":5},"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 Sheet","index":0,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,1,26,11],[15,1,15,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4]]}
[]
[]
[]
[]
[]
[null,"Nutrition Budget Analysis Tool"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Version control"]
[null,"Date file last updated:",{"$f":"TODAY()","v":"2018-04-27"}]
[null,"Name of person who made the last update:"]
[]
[]
[]
[]
[null,"This Excel tool is made possible by the generous support of the American people through the United States Agency for International Development (USAID) under the terms of Cooperative Agreement AID-OAA-A-11-00031 (SPRING), managed by JSI Research & Training Institute, Inc. (JSI) with partners Helen Keller International, The Manoff Group, Save the Children, and the International Food Policy Research Institute. The contents are the responsibility of JSI, and do not necessarily reflect the views of USAID or the U.S. Government. \n\nFor more information, please visit https://www.spring-nutrition.org."]

{"sheet":"Keywords","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,1,6,1],[1,1,3,14]]}
[]
[null,"INSTRUCTIONS: Use this worksheet to store your master list of keywords. We strongly suggest you organize these by Nutrition Plan Reference Number, which correspond to the National Nutrition Policy Objectives, strategies, or activity listings. The description should be VERY SHORT, and align with the key action undertaken. This is because this list is used to aggregrate totals on your summary sheet, so only use keywords that are useful for this purpose. For instance, if you want to track 'Objective 1: Improving micro-nutrient supplementation for mothers and adolescent girls', your reference code would be \"1\" and your keyword would be \"Women's Supplementation\". The full objective can go in the description column for easy reference."]
[]
[]
[]
[null,"Example","Nutrition Plan Reference Number","Keyword (1-2 words maximum)","Description"]
[null,null,1,"Women's supplementation","Improving micro-nutrient supplementation for mothers and adolescent girls"]
[]
[null,null,"Nutrition Plan Reference Number","Keyword (1-2 words maximum)","Description"]

{"sheet":"Utilities","index":2,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,2,10]]}
[]
[null,"INSTRUCTIONS: Use this worksheet to create the dropdown list for the Data Sheet. Enter your data sources in the 'Data Source' table and donors in the 'Donor' table. Using these tables will ensure consistency in spelling and formatting for data entry and accurate representation of data."]
[]
[]
[null,"Data Source",null,null,"Donor"]

{"sheet":"Data Sheet","index":3,"n_rows":12,"n_cols":21,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,1,10,1],[9,2,10,10],[10,12,10,13],[10,16,10,17]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BudgetData[Nutrition-related Funding Amount])","v":0}]
[]
[]
[null,"EXAMPLE"]
[null,"Project Name","Project Code\n(optional)","Data Source",null,"Description\n(optional)","Ministry","Unit\n(if applicable)","Sector","Funding Source","Donor\n(if applicable)","On- or Off-Budget Funds (if applicable)","Nutrition Plan Reference(s)","Key Word","Allocated Budget for Year of Analysis","Integrated or Standalone","Percent to Count","Amount to Count","Specific or Sensitive","Nutrition-related Funding Amount","Notes"]
[null,"Nutrition messaging project","Vote 13, Project 12","Ministry workplan FY16/17, page 365",null,"Messaging for communities to better understand nutrition.","Ministry of Health","Communications Department","Health","Government",null,"On-budget",1.3,"Food Consumption",100000,"Integrated",0.5,null,"Specific",{"$f":" IF(P7=\"Integrated\", IF(R7>0,R7,IF(Q7>0,Q7*O7,)), O7)","v":50000},"This project plans to expand next year."]
[]
[null,"DATA ENTRY"]
[null,"Section A: Complete during data extraction, verify during data validation","Additional guidance can be found in the User Guide or in some cases by selecting the header cell. \nSome cells will allow only pre-set responses, please choose from the drop-down menu. ",null,null,null,null,null,null,null,null,null,null,null,null,"Section B: Complete during data validation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Select code and keywod to which this activity relates",null,null,null,"Integrated projects only; fill out ONLY ONE of columns below, for which you have most accurate information"]
[null,"Project Name","Project Code\n(optional)","Data Source","Data Source Access Date (Month/Year)","Description\n(optional)","Ministry","Unit\n(if applicable)","Sector","Funding source","Donor\n(if applicable)","On- or Off-Budget Funds (if applicable)","Nutrition Plan Reference Number (if applicable)","Key Word","Allocated Budget for Year of Analysis","Integrated or Standalone","Percent to Count","Amount to Count","Specific or Sensitive","Nutrition-related Funding Amount","Notes"]

{"sheet":"Summary Sheet","index":4,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[23,5,23,8],[6,1,6,17],[9,1,9,3],[11,1,11,3],[13,1,13,3],[15,1,15,3]]}
[]
[]
[]
[]
[]
[null,"Nutrition Budget Summary Sheet"]
[null,"This sheet pulls information from 'Data Sheet' to provide a snapshot of the nutrition budget allocations in your entity. The graphs will only reflect data that has been entered. To make changes, please return to the 'Data Sheet'. If this sheet does not populate, plese chekc that you have enabled macros."]
[]
[null,"Total Nutrition Budget Allocations for\nIncludes all budget allocations identified as nutrition-specific or nutrition-sensitive.",{"$f":"SUM(BudgetData[Nutrition-related Funding Amount])","v":0},{"$f":"IF('Data Sheet'!G2=\"\",\"\",'Data Sheet'!G2)","v":""}]
[]
[null,"Total Nutrition-specific Budget Allocations:",{"$f":"SUMIF((BudgetData[Specific or Sensitive]),\"Specific\",(BudgetData[Nutrition-related Funding Amount]))","v":0},{"$f":"IF('Data Sheet'!G2=\"\",\"\",'Data Sheet'!G2)","v":""}]
[]
[null,"Total Nutrition-sensitive Budget Allocations:",{"$f":"SUMIF((BudgetData[Specific or Sensitive]),\"Sensitive\",(BudgetData[Nutrition-related Funding Amount]))","v":0},{"$f":"IF('Data Sheet'!G2=\"\",\"\",'Data Sheet'!G2)","v":""}]
[]
[null,"Total Government-funded Nutrition Allocations:",{"$f":"SUMIF((BudgetData[Funding source]),\"Government\", BudgetData[Nutrition-related Funding Amount])","v":0},{"$f":"IF('Data Sheet'!G2=\"\",\"\",'Data Sheet'!G2)","v":""}]
[]
[null,"Total External-funded Nutrition Allocations:",{"$f":"SUMIF(BudgetData[Funding source],\"External\",BudgetData[Nutrition-related Funding Amount])","v":0},{"$f":"IF('Data Sheet'!G2=\"\",\"\",'Data Sheet'!G2)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Funded Activity Areas"]
[null,null,null,null,null,null,"Total"]
[null,null,null,null,null,"Total"]

{"sheet":"Pivot","index":5,"n_rows":6,"n_cols":25,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Sum of Nutrition-related funding amount","Column Labels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum of Nutrition-related funding amount","Column Labels",null,null,null,"Sum of Nutrition-related funding amount","Column Labels"]
["Row Labels","Grand Total",null,null,null,null,null,"Specific or Sensitive",null,null,null,null,null,null,null,null,null,null,"Row Labels","Grand Total",null,null,null,"Row Labels","Grand Total"]
["Grand Total",null,null,null,null,null,null,"(blank)","Grand Total",null,null,null,null,null,null,null,null,null,"Grand Total",null,null,null,null,"Grand Total"]
[null,null,null,null,null,null,"Funding by Keyword"]