20160906AVU to Staff 124 Attachment A - SR Clearing.xls

Macro1
PM&E Transactions
Macro1
Macro10
Macro2
Macro3
Macro4
Macro5
Macro6
Macro7
Macro8
Macro9
Recover
TableName
Dummy
Note: Overhead Burdens and Transportation are excluded from Variance Reporting by Organization.
Accounting Period:<All>
Report Category:<All>
Mac:<All>
Organization:AVA
Expenditure Organization:<All>
Accounting Year
Ferc Acct
Project Number
Project Desc
Task Number
Task Name
Summary Exp Category
Expenditure Category
Transaction Amt SUM
184400
77705130
Spokane River License Imple
184401
Fisheries
Non-Labor
Contractor
184402
Recreation
184403
Terr Wtlnd & Rip Hab
184404
Water Quality
184405
Cultural Resources
184406
Admin Expense
Employee Expenses
Labor
Overhead
Voucher
184900
77705156
CDA Tribe Settlement CDR Fund
184906
CDA Tribe Settlmnt
77705131
Post Falls Implem Spok Riv lic
184901
184902
184907
184905
2010
Material
Transportation
Vehicle
184903
184904
2011
184408
Land Use
184409
Aquatic Weeds
184410
Bald Eagles
184411
Erosion
184413
Interprtv & Educ
184916
CDA Tribe Implemntn
184910
184909
184911
184912
184914
2012
184407
Aesthetics
2013
Contributions
184412
Transmission Lines
2014
2015
Macro1
Macro10
Macro2
Macro3
Macro4
Macro5
Macro6
Macro7
Macro8
Macro9
Recover
Auto_Open
Page of
186721.49
80432.00
23818.23
271300.16
28631.54
28641.56
28.00
1939.30
62.41
486.55
21.19
307.45
22311.04
29265.78
14109.52
62774.46
11961.39
78100.58
19.33
17247.05
15023.35
10900.32
49188.99
9445.75
62405.43
446.70
198.45
27.34
72.00
759.55
6.96
892.81
173.03
780.78
945.00
153.13
10.76
147557.33
162191.99
51038.76
78949.94
13584.84
35745.65
41.00
650.75
637.40
571.83
538.28
13.62
14138.01
11722.38
30903.29
13974.69
34736.16
47545.68
11145.51
9180.24
24200.57
11012.99
27739.98
37879.22
96.30
233.18
6966.54
24.58
5.63
13.37
174.12
151858.76
30002.27
10850.00
109357.93
24237.15
13369.39
25753.17
15320.55
0.00
41003.25
432.00
203.50
2194.84
351.32
569.58
1352.25
4366.83
978.14
1703.75
64.27
23288.64
16559.23
11650.61
57476.14
7071.33
67577.84
307.71
10524.56
244.52
7531.81
449.31
82.92
18802.41
13497.53
9315.62
46423.02
5734.93
54663.82
254.98
8589.73
193.17
6062.36
375.55
408.00
338.80
947.90
42.75
79.00
180.06
13.10
993.69
30.00
226.75
0.92
778.56
74.82
540.64
2274.34
20843.90
159.71
153318.54
415055.87
27608.14
13006.51
37427.67
5229.52
28255.44
197.50
1357.70
545.89
419.11
1086.94
3534.70
408.42
86.61
77.15
115.20
19172.96
11671.44
19500.85
8371.27
16525.68
67368.17
6007.86
1937.50
8955.71
449.31
15503.97
9352.07
15568.51
6709.51
13023.73
54472.47
4845.16
1562.36
7189.63
375.55
690.80
62.73
55.00
8.81
16.15
46.71
1115.11
9.24
116619.13
114565.47
120043.97
141610.11
46871.82
11388.82
8737.50
29425.50
18784.51
9708.75
9522.91
91.64
1326.00
246.44
395.69
175.49
5957.72
2.22
266.29
98.80
168.72
21.67
27121.59
17833.10
15534.47
32797.35
11960.97
81974.64
5537.49
7739.15
300.00
4927.76
23354.71
15550.02
13568.95
28319.42
10454.68
70501.02
4738.67
6675.25
27.00
4097.11
49.05
663.20
82.91
754.00
3151.66
421.67
22.77
1999.19
150.00
524.65
3375.78
441.70
1605.85
34796.99
4.33
110.25
96842.57
104288.85
-10000.00
2842.24
13995.24
2988.00
18236.25
18784.54
81237.08
9522.93
363.65
1556.92
144.15
3862.90
745.93
222.69
61.05
443.54
27598.02
2477.17
26480.47
8558.03
14877.30
81289.18
4816.91
5767.76
7297.56
23857.15
2213.64
22836.28
7420.12
12426.32
69881.59
4201.94
5052.96
6023.70
55.49
1394.49
0.43
301.37
192.40
4758.80
706.52
111892.19
85075.00
-105000.00
329932.72
31450.86
9061.12
7037.67
41528.33
21183.95
13292.50
451.25
-2800.00
512.19
413.48
78.10
2217.03
640.69
2515.55
412.74
181.42
26.56
35.00
141.15
22650.60
11038.67
6246.95
55950.39
14343.79
82556.63
5705.40
8278.48
499.56
7122.78
249.78
23455.50
11429.67
6498.06
57680.27
15024.88
82473.22
5820.03
8431.14
503.93
7181.92
252.90
7760.00
174.15
153.74
123.27
329.39
146.79
25815.84
34.34
1148.40
95.12
56.52
2.40
0.43
2102.26
979.64
3195.11
45905.64
198.81
4.45
231491.08
125514.60
8500.00
59231.07
98189.87
6376.00
19329.00
21183.95
0.00
2631.25
523.95
148.45
964.42
64.69
845.27
141.82
587.64
692.30
200.92
19885.38
1283.01
2055.60
5382.09
13065.16
88203.88
4325.06
10582.04
8530.04
20199.12
1336.73
2210.26
5574.22
13942.17
90702.08
4571.10
10882.86
8956.81
56.00
2000.00
154.33
655.68
0.00
2259.70
11.36
275642.66
246817.69
380312.76
32396.53
2473.75
24418.10
25782.75
20595.03
1850.27
306.08
1275.90
52.08
293.30
1121.88
1047.42
213.36
143.92
56.24
26078.37
7387.11
6712.90
48676.49
8958.10
80835.21
4509.31
6813.11
510.00
3648.06
255.00
356.94
22453.61
6682.40
5940.64
42726.14
7432.02
66394.45
3667.36
5774.18
448.80
3263.73
227.59
296.27
295.00
735.00
7780.00
181.72
107.36
739.89
-104.49
1.85
1165.34
27.71
206.52
71.45
306.51
777.54
3301.19
38129.87
3.04
14.99
114584.68
185298.51
9517.83
27122.00
128927.49
2695.50
33991.50
20595.06
0.00
5750.27
467.04
336.98
118.16
836.73
248.44
187.60
491.12
341.20
10387.14
6824.93
4829.09
8024.85
5967.90
78418.57
7535.30
16248.50
10716.21
9303.66
6227.38
4163.59
6986.88
5522.24
68722.15
6562.23
13916.55
9235.65
23.86
149.35
34.43
1.74
52.38
185.41
7.07
246157.45
215252.74
10354.50
267234.82
25504.23
1705.00
21556.74
56900.73
13954.08
129.61
1387.20
72.80
1061.91
614.67
3987.89
1040.84
125.19
255.89
39491.85
33122.92
4451.71
60377.83
12475.73
107736.97
20839.86
7897.65
1399.65
4598.14
515.10
280.17
34117.69
28484.49
3778.59
52380.99
10362.32
92102.60
18784.80
6798.70
1255.04
3967.73
474.64
860.00
796.00
8506.60
308.00
653.75
819.32
313.14
112.14
416.47
1739.15
743.54
22.82
354.97
534.19
125.00
9875.00
485.06
1592.31
3783.26
19126.24
75.65
33.77
38110.09
135034.84
1345.33
39209.00
91484.43
524.00
1561.36
8093.22
13659.11
694.04
1022.06
192.02
112.70
1241.38
877.13
57.50
56.00
385.31
241.50
820.52
7757.16
8626.99
19096.13
80603.55
9860.36
20096.23
9801.91
7.72
714.83
6683.53
7491.53
16762.51
69622.54
8358.06
17474.31
8544.90
81.00
1536.25
467.57
183.55
159.45
26.96
0.00
86.34
80.64
500.00
740.98
127.17
$11,643,490.69
9.00