Skip to content

Instantly share code, notes, and snippets.

@jueyang
Last active November 23, 2016 21:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jueyang/9bd225eb58d4d9524b92 to your computer and use it in GitHub Desktop.
Save jueyang/9bd225eb58d4d9524b92 to your computer and use it in GitHub Desktop.
[
// the following is a sample of a donor country
{'name': 'core_total', 'value':10000,'donor-country':'JPN'}, // from core-fund.csv, the sum of all core contribution
{'name': 'noncore_total', 'value': 50000,'donor-country':'JPN'}, // from fund-modality.csv, the sum of all 5 types of funding
{'name': 'cost_sharing', 'value': 10000, 'donor-country':'JPN'}, // from fund-modality.csv, sum of the respective type
{'name': 'thematic_trust_funds', 'value': 10000, 'donor-country':'JPN'},
{'name': 'trust_funds', 'value': 10000, 'donor-country':'JPN'},
{'name': 'special_activities', 'value': 10000, 'donor-country':'JPN'},
{'name': 'unv', 'value': 10000, 'donor-country':'JPN'},
...
// the following is the total value of the same name/structure for ALL donors
{'name': 'core_total', 'value':1000000,'donor-country':'all'},
{'name': 'noncore_total', 'value': 6000000,'donor-country':'all'},
{'name': 'cost_sharing', 'value': 150000, 'donor-country':'all'},
{'name': 'thematic_trust_funds', 'value': 150000, 'donor-country':'all'},
{'name': 'trust_funds', 'value': 150000, 'donor-country':'all'},
{'name': 'special_activities', 'value': 150000,'donor-country':'all'},
{'name': 'unv', 'value': 150000, 'donor-country':'all'}
]
fund_modalities.csv
-----
key,
Fund Rollup Level 3, // used, eg "Trust Fund"
Donor,
Donor Description,
Donor Rollup Level 3, // used, eg "JPN"
Donor Rollup Level 3 Descr,
Donor Rollup Level 4,
Donor Rollup Level 4 Descr,
Contribution Revenue // used, eg "100000"
core_fund.csv
-----
Business Unit,
Fund Rollup Level 1,
Fund Rollup Level 2, // used, only one value "CORE"
Donor,
Donor Desc,
Donor Short Desc,
Donor Level 3, // same as the Donor Rollup Level 3 above, eg "JPN"
Donor Level 3 Desc,
Donor Level 4,
Donor Level 4 Desc,
CONTRIBUTION REVENUES // used, eg "100000"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment