Spreadsheet: 675037d1588111656-sumifs-for-visible-cells-staff-time
Sheet: Dictiionary

 | Amalia
 | Amelia
 | Anna
 | [NAME]
 | [NAME]
 | Brooke
 | [NAME]
 | 1. Exploration / Research
 | 2. Internal draft / review
 | 3. Submitted
 | 4. Client approved
 | 5. Client rejection
 | Other
 | 3 | Total revenue (30%): >$80k | Total revenue per month (30%): >$20k | Estimated Partner time (20%): Minimal involvement (<10%) expected from partners | Other projects (10%): - Expected long-term client relationship, - Strong client financial stability, and  - 50% probability that project leads to new projects within 18 months
Opportunity assessment and scoring: Alignment with capabilities | 1 | Level of impact (40%): Work is outside our core capabilities, but within existing relationship as trusted advisor: - Data and policy analysis and research - Systems and institutional reforms - General strategy and management advice | Competitive advantage (40%): Unlikely for Instiglio to beat competition, but potentially worth trying our luck | Meeting personnel requirements (20%): We do not have the time or knowledge to formulate the right team
 | 2 | Level of impact (40%): We can creatively adapt and extend our capabilities to serve client needs - Service design/delivery support for NGOs in familiar sectors - WfD advisory services | Competitive advantage (40%): Opportunity is not in comfort zone, but expect that we can innovate to be competitive on costs | Meeting personnel requirements (20%): We need to find the right partners to complete the team, but we are confident we can pull them in
 | 3 | Level of impact (40%): Work is squarely within Instiglio capabilities: - Service delivery improvement - M&E and impact investing - Due-diligence support | Competitive advantage (40%): Instiglio expected to easily beat competition on value-for-money | Meeting personnel requirements (20%): We fulfill all requirements (including language requirements)
Opportunity assessment and scoring: COVID-19 risks | 1 | Risk of delayed invoices (40%): More than 30% of budget risks being delayed | Extent of delays (40%): >2 months | Travel dependent (20%): Required trips to locations with active [NAME] or high risk
 | 2 | Risk of delayed invoices (40%): Up to 30% of budget risk being delayed | Extent of delays (40%): >0.5 months but <2 months | Travel dependent (20%): Requires trips to locations with limited/low COVID-19 risks
 | 3 | Risk of delayed invoices (40%): No risks of delays | Extent of delays (40%): <0.5 months | Travel dependent (20%): No travel needed/can be delivered locally
Opportunity assessment and scoring: Impact & strategic alignment | 1 | Importance of project in client's strategy (10%): Project is not central to client’s strategy and internal resources are mobilized accordingly | Political & legal risks (10%): Large/likely political or legal risks associated with the context/environment of the project | Client (30%):  •INGO | Geography (30%): Other | Sector (20%): Other sectors
 | 2 | Importance of project in client's strategy (10%): Project is somewhat central to clients’ strategy and internal resources are mobilized accordingly | Political & legal risks (10%): Identified risks regarding political and legal environments (external context) are manageable | Client (30%):  •Non-key foundations and IDOs | Geography (30%): •MENA •Other Africa •Other LatAm | Sector (20%): •Climate, energy, water •Agriculture
 | 3 | Importance of project in client's strategy (10%): Project is central to client’s strategy and internal resources are mobilized accordingly | Political & legal risks (10%): No major risks identified regarding political and legal environments (external context) | Client (30%):  •Governments •Key foundations •Key IDOs | Geography (30%): •Kenya •Morocco •Colombia •Peru | Sector (20%): •Education •Livelihoods •Health •WfD
 | Avnish Gungadurdoss
 | Siegrid Holler
 | [NAME]
 | Ayoub Lahlou
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Mariona Tres Vilanova
 | Dalal Azzouzi
 | [NAME]
 | [NAME]
 | [NAME]
 | Ana [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Ana [NAME]
 | Camila Muñoz
 | Nazly Frias
 | Julia Loraque
 | Wanjiku Ngare
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]