20150729AVU to Staff 36 Attachment A.xls

Macro1
Transaction Detail
Sheet1
Macro1
Macro10
Macro2
Macro3
Macro4
Macro5
Macro6
Macro7
Macro8
Macro9
Recover
TableName
Dummy
Transaction Detail Selection: Gl Ferc Account : '%'
Er
Ferc Acct
Service
Voucher Number
Organization Desc
Accounting Period
Subledger Transaction Id
Expenditure Organization
Prn Number
Project Number
Stock Number
Vehicle Number
Ticket Number
Jurisdiction
Journal Name
Transaction Desc
Ava Jet
Expenditure Category
Invoice Number
Report Category
Summary Exp Category
Accounting Year
Task Number
FERC
Expenditure Type
Source Id
Transaction Amount
Electric Amt SUM
Gas North Amt SUM
Not Assigned Amt SUM
Project Desc
Company
Statind
Vendor Number
Employee Number
Gas South Amt SUM
Job Title
Vendor Name
3008
107000
GD
-
G08 - Gas Construction Management
201404
PA.14334502.833.14334502
G08
98405239
02080
OR
Usage Cost USD
Transportation
CAP
Non-Labor
2014
300100
107
550 Company Aircraft
PA
AA OR STTR major Medford West
001
DL
3000
B51 - Gas Engineering
201401
PA.13760714.1457.13760714
B51
98405124
Reg sta 6047 instl Talent Or
930200
CD
Z88 - Transportation Loaders
201407
PA.14957255.537.14957255
Z88
09903691
AA
OPER
930
Corporate Planning-099
201409
PA.15398338.985.15398338
921000
201412
PA.16058115.257.16058115
921
PA.14334510.849.14334510
201411
PA.15847040.121.15847040
09900162
Admin Activities-Common to All
928000
201406
PA.14753126.91.14753126
03805343
ID
928010
928
CDID General Rate Case Activ
PA.14957241.509.14957241
02805810
WA
CDWA General Rate Case Activ
PA.15398326.961.15398326
09900020
Board Of Director Activities
PA.14753120.79.14753120
09900010
Analysts Meetings
201405
PA.14524868.883.14524868
ED
PA.14753118.75.14753118
09800310
AN
Elect-Trade/Professional Assoc
PA.13759725.1479.13759725
PA.15398339.987.15398339
02800300
930220
Wa Charitable/Civic - Ops
417120
ZZ
PA.14957246.519.14957246
77703430
NONOP
417
Avista Subsidiary Support
107060
PA.14334506.841.14334506
77700242
OTHER
Gas Construction Overheads
201408
PA.15194468.963.15194468
4140
E07 - Generation Engineers
PA.15398332.973.15398332
E07
20505040
Nine Mile HED-Sed Bypass Enh
880000
PA.13759794.1617.13759794
09900165
880
Gas Ops Admin Activity - 099
870000
PA.15194465.957.15194465
870
557000
201402
PA.13939480.987.13939480
09802202
557
Elect Other PS Expense -098
426100
201403
PA.14126319.665.14126319
77700300
426120
426
Charitable and Civic Expense
PA.15842967.975.15842967
PA.14753124.87.14753124
PA.15398334.977.15398334
PA.15847039.119.15847039
09903410
Risk Mgmt Admin Activity-099CM
PA.14957254.535.14957254
09903370
Treasury Activities-099
PA.14957253.533.14957253
09900540
Common Regulatory Activities
PA.14334494.817.14334494
09900330
Common-Company Communications
PA.13939482.991.13939482
PA.15842970.981.15842970
PA.15842969.979.15842969
PA.14334490.809.14334490
03800545
Id Gas Regulatory Activities
PA.15194470.967.15194470
03800540
Id Elect Regulatory Activities
PA.14524877.901.14524877
02800545
Wa Gas Regulatory Activities
PA.15194467.961.15194467
107010
PA.15194471.969.15194471
77700240
Admin Construction Overheads
PA.13759792.1613.13759792
PA.14334497.823.14334497
PA.14126310.647.14126310
PA.16058119.265.16058119
PA.14334491.811.14334491
PA.14957247.521.14957247
PA.16058116.259.16058116
PA.14957250.527.14957250
926100
PA.16058114.255.16058114
09902811
926102
926
A and G Common Training
PA.15194466.959.15194466
09902800
921320
Employment 099 CM
PA.14334503.835.14334503
921300
PA.14753115.69.14753115
09900310
Com - Trade/Professional Assoc
PA.14753127.93.14753127
PA.15398330.969.15398330
06805169
GDOR General Rate Case Activ
PA.14334496.821.14334496
PA.15398344.997.15398344
PA.14524874.895.14524874
PA.14524871.889.14524871
PA.15398337.983.15398337
PA.14753119.77.14753119
PA.14334489.807.14334489
PA.13759595.1219.13759595
02800540
Wa Elect Regulatory Activities
PA.15194469.965.15194469
PA.15194472.971.15194472
PA.13760717.1463.13760717
98405238
AA OR main major White City W
PA.13759793.1615.13759793
500000
PA.13939478.983.13939478
41002100
500
Elect Joint Projects -410
PA.14957251.529.14957251
PA.15842971.983.15842971
PA.14126312.651.14126312
920000
PA.13939481.989.13939481
09900510
920
Common-Environmental Expense
PA.13939479.985.13939479
PA.14126317.661.14126317
PA.15402445.199.15402445
09900311
Gas - Trade/Professional Assoc
PA.14753116.71.14753116
426500
PA.14334488.805.14334488
77705228
Project Chinook
PA.14957245.517.14957245
PA.15398328.965.15398328
PA.14126313.653.14126313
PA.14126316.659.14126316
PA.16058117.261.16058117
PA.15398335.979.15398335
PA.15842963.967.15842963
PA.15842962.965.15842962
PA.13759600.1229.13759600
PA.14524876.899.14524876
PA.15398342.993.15398342
PA.14957244.515.14957244
426400
PA.14957257.541.14957257
77700521
Government Relations Non-Op
PA.13760718.1465.13760718
PA.14334504.837.14334504
PA.14334495.819.14334495
PA.14334493.815.14334493
PA.14524867.881.14524867
PA.14957256.539.14957256
PA.13759798.1625.13759798
926408
PA.13759795.1619.13759795
PA.13939483.993.13939483
PA.14126314.655.14126314
PA.15398343.995.15398343
PA.15194460.947.15194460
935000
PA.15842964.969.15842964
09900110
935
Aircraft Operations-Maint
PA.14957248.523.14957248
PA.14524865.877.14524865
186200
PA.13783672.1.13783672
77705216
186
Project Glacier Suspense Bill
PA.15194459.945.15194459
PA.14957258.543.14957258
PA.15194458.943.15194458
PA.14334498.825.14334498
09905690
Company Utility Initiatives
PA.14126320.667.14126320
PA.14524875.897.14524875
PA.14957252.531.14957252
PA.13759799.1627.13759799
PA.14334509.847.14334509
PA.15194461.949.15194461
PA.14524869.885.14524869
PA.16058118.263.16058118
PA.15398340.989.15398340
PA.14753122.83.14753122
PA.14126308.643.14126308
PA.14753121.81.14753121
PA.15398341.991.15398341
PA.14126311.649.14126311
107050
PA.14334499.827.14334499
PA.15194464.955.15194464
PA.14334507.843.14334507
107500
PA.14334505.839.14334505
PA.14126318.663.14126318
PA.15398336.981.15398336
PA.13759796.1621.13759796
PA.14334492.813.14334492
PA.14957249.525.14957249
PA.14524872.891.14524872
PA.14753125.89.14753125
PA.16058120.267.16058120
PA.14126309.645.14126309
PA.15842968.977.15842968
PA.15842965.971.15842965
925100
PA.13759705.1439.13759705
06803410
925130
925
Risk Mgmt Admin Activity-068G
PA.14957242.511.14957242
06800545
Or Gas Regulatory Activities
PA.15194463.953.15194463
06805173
Oregon PGA Labor
PA.15398331.971.15398331
PA.15842972.985.15842972
PA.15194462.951.15194462
PA.14334508.845.14334508
PA.14334501.831.14334501
PA.14126315.657.14126315
PA.14524870.887.14524870
PA.14957243.513.14957243
PA.13759797.1623.13759797
PA.15194473.973.15194473
PA.14524873.893.14524873
PA.14753128.95.14753128
PA.15398345.999.15398345
PA.14753117.73.14753117
PA.13939484.995.13939484
PA.15842966.973.15842966
PA.15398333.975.15398333
PA.16053390.807.16053390
PA.14524866.879.14524866
PA.15398329.967.15398329
PA.13759599.1227.13759599
PA.15398327.963.15398327
PA.13759594.1217.13759594
PA.13760079.187.13760079
PA.14334500.829.14334500
Macro1
Macro10
Macro2
Macro3
Macro4
Macro5
Macro6
Macro7
Macro8
Macro9
Recover
Auto_Open
Grand Total
Sum of Transaction Amount
(All)
427.50
427.50
780.00
780.00
2360.00
1682.44
467.80
209.76
6772.50
4828.12
1342.44
601.94
3584.00
2555.03
710.42
318.55
1687.50
1203.02
334.50
149.98
5155.50
3675.36
1021.92
458.22
3360.00
2642.34
717.66
8136.00
6398.23
1737.77
1428.00
1018.02
283.06
126.92
616.00
439.15
122.10
54.75
6030.00
4298.79
1195.27
535.94
1848.00
1848.00
13800.00
13800.00
1414.00
1111.98
302.02
3120.00
3120.00
306.00
306.00
630.00
630.00
3220.00
3220.00
780.00
536.11
243.89
304.50
209.29
95.21
1760.00
1760.00
12000.00
12000.00
1960.00
1397.28
388.51
174.21
1440.00
1026.58
285.44
127.98
4392.50
3131.41
870.68
390.41
20160.00
14372.06
3996.12
1791.82
4720.00
3364.89
935.60
419.51
2360.00
1682.44
467.80
209.76
2070.00
1475.70
410.32
183.98
4350.00
3420.88
929.12
4410.00
3143.89
874.15
391.96
1470.00
1470.00
2484.00
2484.00
3213.00
3213.00
3825.00
3825.00
185.50
185.50
798.00
798.00
350.00
240.56
109.44
427.50
293.83
133.67
1930.00
1326.53
603.47
2870.00
2870.00
3186.00
3186.00
15428.00
15428.00
7322.00
5219.85
1451.37
650.78
4144.00
2954.26
821.42
368.32
3780.00
2694.76
749.27
335.97
2579.50
1838.93
511.31
229.26
666.00
474.79
132.01
59.20
3080.00
2195.73
610.52
273.75
7680.00
5475.07
1522.33
682.60
3108.00
3108.00
5062.50
5062.50
3829.00
3829.00
3636.00
2859.39
776.61
2038.50
1603.10
435.40
4602.50
3281.12
912.31
409.07
1848.00
1848.00
1296.00
1296.00
5150.00
5150.00
1533.00
1533.00
4032.00
4032.00
2230.00
2230.00
745.00
512.05
232.95
2635.00
2635.00
2072.00
1477.13
410.71
184.16
1470.00
1047.96
291.38
130.66
2960.00
2110.18
586.73
263.09
880.00
627.35
174.43
78.22
880.00
627.35
174.43
78.22
1950.00
1390.16
386.53
173.31
9870.00
6783.85
3086.15
3080.00
2195.73
610.52
273.75
4320.00
4320.00
3840.00
3840.00
1260.00
898.25
249.76
111.99
1815.00
1293.91
359.77
161.32
1950.00
1390.16
386.53
173.31
19775.00
14097.60
3919.80
1757.60
430.50
306.90
85.33
38.27
2310.00
2310.00
2730.00
2730.00
4250.00
4250.00
1935.00
1935.00
1344.00
1056.94
287.06
3600.00
3600.00
640.00
640.00
1560.00
1560.00
522.00
358.78
163.22
2070.00
2070.00
2070.00
2070.00
6345.00
4523.35
1257.71
563.94
2360.00
1682.44
467.80
209.76
780.00
556.06
154.61
69.33
1560.00
1112.12
309.22
138.66
6100.00
4348.69
1209.14
542.17
1815.00
1293.91
359.77
161.32
3829.00
3829.00
3118.50
2452.42
666.08
3150.00
2245.64
624.39
279.97
3600.00
3600.00
3456.00
3456.00
-4800.00
-4800.00
350.00
350.00
320.00
320.00
700.00
700.00
427.50
304.76
84.74
38.00
14700.00
14700.00
3825.00
2726.84
758.19
339.97
2072.00
1477.13
410.71
184.16
1490.00
1062.22
295.35
132.43
828.00
590.28
164.13
73.59
3185.00
2189.11
995.89
6030.00
4144.54
1885.46
5022.50
5022.50
2842.00
2234.98
607.02
1520.00
1083.61
301.29
135.10
26300.00
26300.00
3040.00
3040.00
1414.00
1111.98
302.02
2100.00
2100.00
427.50
427.50
1260.00
1260.00
522.00
522.00
522.00
372.13
103.47
46.40
1950.00
1390.16
386.53
173.31
861.00
613.81
170.67
76.52
745.00
531.11
147.67
66.22
3996.00
2848.75
792.09
355.16
2072.00
1477.13
410.71
184.16
1521.00
1084.32
301.49
135.19
2832.00
2832.00
3430.00
3430.00
4320.00
3397.29
922.71
3605.00
2570.00
714.58
320.42
1960.00
1960.00
4650.00
4650.00
3792.00
3792.00
3528.00
3528.00
6090.00
6090.00
2898.00
2898.00
2730.00
2730.00
522.00
522.00
427.50
427.50
1815.00
1293.91
359.77
161.32
6030.00
4298.79
1195.27
535.94
3752.00
2674.80
743.72
333.48
745.00
531.11
147.67
66.22
2660.00
1896.31
527.27
236.42
3708.00
2643.43
735.00
329.57
7680.00
5475.07
1522.33
682.60
5040.00
3593.02
999.03
447.95
5872.00
4186.15
1163.95
521.90
7600.00
5418.04
1506.47
675.49
1960.00
1397.28
388.51
174.21
4392.50
3131.41
870.68
390.41
1792.00
1277.52
355.21
159.27
6345.00
4523.35
1257.71
563.94
2310.00
2310.00
2200.00
2200.00
2730.00
2730.00
2200.00
2200.00
4800.00
4800.00
427.50
427.50
Page of
$4,172.00
$4,172.00
$20,604.00
$20,604.00
$21,993.00
$21,993.00
$24,805.00
$24,805.00
$4,509.00
$4,509.00
$4,794.00
$4,794.00
$6,996.00
$6,996.00
$3,792.00
$3,792.00
$4,650.00
$4,650.00
$28,121.00
$28,121.00
$3,528.00
$3,528.00
$52,576.00
$52,576.00
$3,830.00
$3,830.00
$55,638.50
$55,638.50
$2,688.00
$2,688.00
$6,755.00
$6,755.00
$39,027.50
$39,027.50
$4,279.00
$4,279.00
$780.00
$780.00
$14,049.00
$14,049.00
$19,085.00
$19,085.00
$6,715.00
$6,715.00
$880.00
$880.00
$14,528.00
$14,528.00
$10,083.50
$10,083.50
$6,050.00
$6,050.00
$8,864.00
$8,864.00
$20,160.00
$20,160.00
$3,584.00
$3,584.00
$58,486.50
$58,486.50
$949.50
$949.50
$4,705.00
$4,705.00
$48,184.00
$48,184.00
$2,010.00
$2,010.00
$9,450.00
$9,450.00
$7,152.00
$7,152.00
$248,458.50
$6,996.00
$28,977.00
$61,111.00
$4,509.00
$20,604.00
$24,144.00
$4,794.00
$40,091.00
$21,993.00
$66,796.00
$528,473.50