Indicator Coverage.xlsx

	A	B	C	D	E	F	G	H
1	IATI Coverage Calculation
2		A	B	C	D	E	F	G
3	Publisher Name	2014 IATI Spend	2015 IATI Spend	2014 Reference Spend	2015 Reference Spend	2015 Official Forecast	Spend Ratio (%)	Coverage (%)
4		Total of all Disbursements + Expenditure reported through IATI for 2014	Total of all Disbursements + Expenditure reported through IATI for 2015	Total operational spend for 2014 as published in an official report or by a recognised third party. CRS data will be used for bilateral agencies matching the IATI publisher. Data will be manually collected and stored on the Dashboard.	Total operational spend for 2015 as published in an official report or by a recognised third party. CRS data will be used for bilateral agencies matching the IATI publisher. Data will be manually collected and stored on the Dashboard.	(eg DAC 2015 forecasts are available in March 2016)	The highest result from A/C B/D B/C B/E	F raised to the top of its quintile
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100