Instructions           Purpose Instructions           Purpose       This model is designed to estimate the impact of resource allocation decisions on the achievement of the goals of the strategic plan.         General instructions     A light purple background (like this row) indicates cells where you need to enter data or assumptions.   A light green background indicates cells that contain default values that you do not have to change, but you can enter you own estimates if you prefer.   A yellow background (like this row) is used to highlight worksheet titles and areas of special interest.         Entering assumptions     Data and assumptions are entered in the purple cells in the following worksheets:   Country-specific values must be entered in following worksheets. Go through each worksheet in order.     Set up-Inputs   In the following worksheets the standard values based on international studies can be used, or country-specific data can be entered, if available.         Making the projection     1. Examine the results in the Summary worksheet.   2. Select the budget you want to use by entering A, B or C in the purple cell at the top of the budget column labelled Plan Budget   3. To override the budget values and enter your own value for a particular category, type the new value in the appropriate cell      in the column labeled "Interactive budget'   4. To remove a custom budget figure just delete it.   5. The coverage column shows the proportion of the population in need that receives the information or utilizes the service.   6. Additional output charts are available in the following worksheets.     Prevalence 15-49 Saving your work     Remember to save the spreadsheet regularly.         For more help       If you need additional assistance, please contact:       John Stover or Lori Bollinger       The Futures Group International       80 Glastonbury Blvd       Glastonbury, CT 06033       USA           Telephone: 860-633-3501       Fax: 860-657-3918       E-mail: j.stover@tfgi.com                 Instructions           Purpose       This model is designed to estimate the impact of resource allocation decisions on the achievement of the goals of the strategic plan.         General instructions     A light purple background (like this row) indicates cells where you need to enter data or assumptions.   A light green background indicates cells that contain default values that you do not have to change, but you can enter you own estimates if you prefer.   A yellow background (like this row) is used to highlight worksheet titles and areas of special interest.         Entering assumptions     Data and assumptions are entered in the purple cells in the following worksheets:   Country-specific values must be entered in following worksheets. Go through each worksheet in order.     Budget-Inputs   In the following worksheets the standard values based on international studies can be used, or country-specific data can be entered, if available.     Care costs-Inputs Making the projection     1. Examine the results in the Summary worksheet.   2. Select the budget you want to use by entering A, B or C in the purple cell at the top of the budget column labelled Plan Budget   3. To override the budget values and enter your own value for a particular category, type the new value in the appropriate cell      in the column labeled "Interactive budget'   4. To remove a custom budget figure just delete it.   5. The coverage column shows the proportion of the population in need that receives the information or utilizes the service.   6. Additional output charts are available in the following worksheets.     Prevalence 15-49 Saving your work     Remember to save the spreadsheet regularly.         For more help       If you need additional assistance, please contact:       John Stover or Lori Bollinger       The Futures Group International       80 Glastonbury Blvd       Glastonbury, CT 06033       USA           Telephone: 860-633-3501       Fax: 860-657-3918       E-mail: j.stover@tfgi.com                                 This model is designed to estimate the impact of resource allocation decisions on the achievement of the goals of the strategic plan.         General instructions     A light purple background (like this row) indicates cells where you need to enter data or assumptions.   A light green background indicates cells that contain default values that you do not have to change, but you can enter you own estimates if you prefer.   A yellow background (like this row) is used to highlight worksheet titles and areas of special interest.         Entering assumptions     Data and assumptions are entered in the purple cells in the following worksheets:   Country-specific values must be entered in following worksheets. Go through each worksheet in order.   In the following worksheets the standard values based on international studies can be used, or country-specific data can be entered, if available. Making the projection     1. Examine the results in the Summary worksheet.   2. Select the budget you want to use by entering A, B or C in the purple cell at the top of the budget column labelled Plan Budget   3. To override the budget values and enter your own value for a particular category, type the new value in the appropriate cell      in the column labeled "Interactive budget'   4. To remove a custom budget figure just delete it.   5. The coverage column shows the proportion of the population in need that receives the information or utilizes the service.   6. Additional output charts are available in the following worksheets. Saving your work     Remember to save the spreadsheet regularly.         For more help       If you need additional assistance, please contact:       John Stover or Lori Bollinger       The Futures Group International       80 Glastonbury Blvd       Glastonbury, CT 06033       USA           Telephone: 860-633-3501       Fax: 860-657-3918       E-mail: j.stover@tfgi.com                 Instructions           Purpose       This model is designed to estimate the impact of resource allocation decisions on the achievement of the goals of the strategic plan.         General instructions     A light purple background (like this row) indicates cells where you need to enter data or assumptions.   A light green background indicates cells that contain default values that you do not have to change, but you can enter you own estimates if you prefer.   A yellow background (like this row) is used to highlight worksheet titles and areas of special interest.         Entering assumptions     Data and assumptions are entered in the purple cells in the following worksheets:   Country-specific values must be entered in following worksheets. Go through each worksheet in order.     Budget-Inputs   In the following worksheets the standard values based on international studies can be used, or country-specific data can be entered, if available.     Care costs-Inputs Making the projection     1. Examine the results in the Summary worksheet.   2. Select the budget you want to use by entering A, B or C in the purple cell at the top of the budget column labelled Plan Budget   3. To override the budget values and enter your own value for a particular category, type the new value in the appropriate cell      in the column labeled "Interactive budget'   4. To remove a custom budget figure just delete it.   5. The coverage column shows the proportion of the population in need that receives the information or utilizes the service.   6. Additional output charts are available in the following worksheets.     Prevalence 15-49         Saving your work     Remember to save the spreadsheet regularly.         For more help       If you need additional assistance, please contact:       John Stover or Lori Bollinger       The Futures Group International       80 Glastonbury Blvd       Glastonbury, CT 06033       USA           Telephone: 860-633-3501       Fax: 860-657-3918       E-mail: j.stover@tfgi.com                 Email: