1 / 10

Integrated Spreadsheet for Livelihood Outcomes: Woreda Training Workshop

The Integrated Spreadsheet is a vital tool used in the Livelihoods Integration Unit for analyzing outcomes related to hazard coping mechanisms. Designed for both single zone and multi-zone analysis, the spreadsheet aids in identifying survival needs and protecting livelihoods. It incorporates data from seasonal assessments and baseline studies, ensuring households can access 2100 kilocalories without depleting their assets. Adjustments are made automatically based on food intake and sustainable sales, supporting effective livelihood protection strategies across various wealth groups.

haru
Télécharger la présentation

Integrated Spreadsheet for Livelihood Outcomes: Woreda Training Workshop

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Livelihoods Integration Unit WOREDA TRAINING WORKSHOP The Integrated Spreadsheet - for a Single Livelihood Zone

  2. The Integrated Spreadsheet The integrated spreadsheet is the tool we use for OUTCOME ANALYSIS + HAZARD + COPING = OUTCOME Step 4 Step 5 Step 6 Compiled from data collected during seasonal assessments or monitoring Data collected during baseline + + =

  3. The Integrated Spreadsheet • 2 types of integrated spreadsheets: • A single zone analysis - woreda level or pocket analysis B) Multi-zone analysis for up to: • 20 woredas • 12 livelihood zones • 4 wealth groups (VP, P, M & B/O)

  4. The Excel database - single zone spreadsheet and integrated spreadsheet B & P Baseline data, information on coping strategies & population data C, L, M, O - quantitative monitoring information on crops, livestock, market prices & other data R, G, S - results, graphed results, seasonal analysis of results

  5. C: Entering a problem specification

  6. How does the spreadsheet work The spreadsheet is designed to identify people’s survival needs and to protect people’s livelihoods (livelihood protection). The spreadsheet looks to see if households can access 2100 kcals without reducing their assets. In a baseline year in many livelihood zones, the poor and very poor wealth groups are consuming less than 2100 kilocalories.

  7. The spreadsheet automatically and applies the following corrections • Households must have access to 2100 kcals. • If food intake in the baseline year is below 2100 kilocalories: the computer will adjust the baseline and take food intake to 2100 kilocalories. This is done: • ｷReducing the consumption of a high value crops produced by the households and • ｷUsing the money saved to increase food purchases. • Households are only permitted to make sustainable sales of livestock. • Sustainable off-take rates are set at 40% for the very poor and poor households and 50% for middle and better-off households.

  8. Answers

More Related