{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["1_22 Budget"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":27,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1_22 Budget","index":0,"n_rows":68,"n_cols":50,"rows_kept":68,"cut":false,"hidden":false,"merged":[[4,42,4,45],[4,46,4,49],[4,18,4,21],[4,22,4,25],[4,26,4,29],[4,30,4,33],[4,34,4,37],[4,2,4,5],[4,6,4,9],[4,10,4,13],[4,14,4,17],[4,38,4,41]]}
["2020 KPCo Labor Budget Breakout"]
["By Department by Month"]
[]
[]
[null,null,"(01) Jan",null,null,null,"(02) Feb",null,null,"(02) Feb Total","(03) Mar",null,null,"(03) Mar Total","(04) Apr",null,null,"(04) Apr Total","(05) May",null,null,"(05) May Total","(06) Jun",null,null,"(06) Jun Total","(07) Jul",null,null,"(07) Jul Total","(08) Aug",null,null,"(08) Aug Total","(09) Sep",null,null,"(09) Sep Total","(10) Oct",null,null,"(10) Oct Total","(11) Nov",null,null,"(11) Nov Total","(12) Dec",null,null,"(12) Dec Total"]
["Department ID","Department Description","Capital","O&M","Other","Jan Total","Capital","O&M","Other","Feb Total","Capital","O&M","Other","Mar Total","Capital","O&M","Other","Apr Total","Capital","O&M","Other","May Total","Capital","O&M","Other","Jun Total","Capital","O&M","Other","Jul Total","Capital","O&M","Other","Aug Total","Capital","O&M","Other","Sep Total","Capital","O&M","Other","Oct Total","Capital","O&M","Other","Nov Total","Capital","O&M","Other","Dec Total"]
[10107,"Big Sandy Plant Stores",null,null,7396,7396,null,null,7749,7749,null,null,7749,7749,null,null,7749,7749,null,null,7942,7942,null,null,7942,7942,null,null,7942,7942,null,null,7942,7942,null,null,7942,7942,null,null,7942,7942,null,null,7942,7942,null,null,7942,7942]
[10129,"Pikeville Meter Revenue Opers",3295,29292,1356,33943,3295,29292,1356,33943,3295,29292,1356,33943,3295,29292,1356,33943,3405,30138,1403,34946,3405,30138,1403,34946,3405,30138,1403,34946,3405,30138,1403,34946,3405,30138,1403,34946,3405,30138,1403,34946,3405,30138,1403,34946,3405,30138,1403,34946]
[10216,"Ashland Const",121822,120623,16080,258525,121822,120623,16080,258525,121822,120623,16080,258525,122481,121387,16212,260080,124328,123531,16583,264442,124328,123531,16583,264442,124328,123531,16583,264442,124328,123531,16583,264442,124328,123531,16583,264442,124328,123531,16583,264442,124328,123531,16583,264442,124328,123531,16583,264442]
[10218,"Big Sandy Plant",0,249635,37616,287251,0,240664,36317,276981,0,240664,36317,276981,0,244326,36636,280962,0,249088,37588,286676,0,249088,37588,286676,0,249149,37588,286737,0,249149,37588,286737,null,249149,37588,286737,null,249272,37588,286860,null,249272,37588,286860,null,248988,37603,286591]
[10425,"Transmission Line Projects",null,null,null,null,0,null,null,0]
[10495,"Turbine Engineering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[10502,"Water & Ecolog Resource Svcs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[10512,"Hazard Meter Revenue Opers",2130,24858,742,27730,2130,24858,742,27730,2130,24858,742,27730,2130,24858,742,27730,2205,25635,768,28608,2205,25635,768,28608,2205,25635,768,28608,2205,25635,768,28608,2205,25635,768,28608,2205,25635,768,28608,2205,25635,768,28608,2205,25635,768,28608]
[10578,"Project Engineering & EWC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[10594,"Plant Engineering Region 1",1603,6765,620,8988,1603,6765,620,8988,1603,6765,620,8988,1603,6765,642,9010,1603,6765,642,9010,1603,6765,642,9010,1603,6765,642,9010,1603,6765,642,9010,1603,6765,642,9010,1603,6765,642,9010,1603,6765,642,9010,1603,6765,642,9010]
[10642,"Mitchell Plant",30947,1400976,519615,1951538,30393,1349808,501251,1881452,30393,1349808,501251,1881452,30569,1365088,504734,1900391,30569,1365088,504734,1900391,31455,1397042,518791,1947288,31455,1397042,518791,1947288,31455,1397042,518791,1947288,31455,1397042,518791,1947288,31455,1397042,518791,1947288,31495,1397042,518791,1947328,31600,1396362,518107,1946069]
[10657,"Geotechnical Engineering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[10695,"Pikeville Const",89253,98492,17088,204833,89253,98492,17088,204833,89253,98492,17088,204833,89606,99047,17204,205857,90930,101137,17640,209707,90930,101137,17640,209707,90930,101137,17640,209707,90930,101137,17640,209707,90930,101137,17640,209707,90930,101137,17640,209707,90930,101137,17640,209707,90930,101137,17640,209707]
[10752,"Cust Sol Ctr Network Services",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[10887,"Kammer Plant",0,null,0,0]
[10995,"I&C Engineering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[11115,"Trans Station Projs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[11242,"BOP Engineering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[11266,"Ashland Meter Revenue Opers",6906,35481,677,43064,6906,35481,677,43064,6906,35481,677,43064,6906,35481,677,43064,7143,36583,701,44427,7143,36583,701,44427,7143,36583,701,44427,7143,36583,701,44427,7143,36583,701,44427,7143,36583,701,44427,7143,36583,701,44427,7143,36583,701,44427]
[11364,"Program Engineering",9013,34213,0,43226,9013,34213,0,43226,9013,34213,0,43226,9013,34213,0,43226,9013,34213,0,43226,9013,34213,0,43226,9013,34213,0,43226,9013,34213,0,43226,9013,34213,null,43226,9013,34213,null,43226,9013,34213,null,43226,9013,34213,null,43226]
[11386,"Mitchell Plant Stores",null,null,60095,60095,null,null,60095,60095,null,null,60095,60095,null,null,61053,61053,null,null,61053,61053,null,null,62197,62197,null,null,62197,62197,null,null,62197,62197,null,null,62197,62197,null,null,62197,62197,null,null,62197,62197,null,null,62197,62197]
[11439,"Kentucky Power Co Headquarters",null,26657,0,26657,null,26657,0,26657,null,26657,0,26657,null,27589,0,27589,null,27589,0,27589,null,27589,0,27589,null,27589,0,27589,null,27589,null,27589,null,27589,null,27589,null,27589,null,27589,null,27589,null,27589,null,27589,null,27589]
[11637,"TFS Line E WV/KY",null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,0,null,0]
[11680,"Pikeville Design",41173,6026,5971,53170,41173,6026,5971,53170,41173,6026,5971,53170,41176,6167,6166,53509,41176,6167,6166,53509,41176,6167,6166,53509,41176,6167,6166,53509,41176,6167,6166,53509,41176,6167,6166,53509,41176,6167,6166,53509,41176,6167,6166,53509,41176,6167,6166,53509]
[11683,"Hazard Const",94406,120608,21337,236351,94406,120608,21337,236351,94406,120608,21337,236351,95022,121413,21509,237944,96624,123504,21956,242084,96624,123504,21956,242084,96624,123504,21956,242084,96624,123504,21956,242084,96624,123504,21956,242084,96624,123504,21956,242084,96624,123504,21956,242084,96624,123504,21956,242084]
[11685,"Paintsville Construction",39275,30721,5406,75402,39275,30721,5406,75402,39275,30721,5406,75402,39537,30902,5446,75885,40348,31466,5571,77385,40348,31466,5571,77385,40348,31466,5571,77385,40348,31466,5571,77385,40348,31466,5571,77385,40348,31466,5571,77385,40348,31466,5571,77385,40348,31466,5571,77385]
[11783,"Regulatory Services - Kentucky",null,27265,0,27265,null,27265,0,27265,null,27265,0,27265,null,28219,0,28219,null,28219,0,28219,null,28219,0,28219,null,28219,0,28219,null,28219,0,28219,null,28219,null,28219,null,28219,null,28219,null,28219,null,28219,null,28219,null,28219]
[12144,"Ashland Telecom Ops",19011,45210,0,64221,19011,45210,0,64221,19011,45210,0,64221,19653,46703,0,66356,19653,46703,0,66356,19653,46703,0,66356,19653,46703,0,66356,19653,46703,0,66356,19653,46703,null,66356,19653,46703,null,66356,19653,46703,null,66356,19653,46703,null,66356]
[12315,"Steam Process and Welding Eng",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[12365,"AP/KP Safety & Health",1340,6766,null,8106,1341,6766,null,8107,1340,6766,null,8106,1359,6857,null,8216,1358,6857,null,8215,1359,6857,null,8216,1358,6857,null,8215,1359,6857,null,8216,1359,6857,null,8216,1359,6857,null,8216,1359,6857,null,8216,1359,6859,null,8218]
[12389,"Hazard Design",35756,8490,2858,47104,35756,8490,2858,47104,35756,8490,2858,47104,36175,8682,2958,47815,36175,8682,2958,47815,36175,8682,2958,47815,36175,8682,2958,47815,36175,8682,2958,47815,36175,8682,2958,47815,36175,8682,2958,47815,36175,8682,2958,47815,36175,8682,2958,47815]
[12390,"Kentucky Gov & Envir Aff",null,30381,0,30381,null,30381,0,30381,null,30381,0,30381,0,31445,0,31445,0,31445,0,31445,0,31445,0,31445,null,31445,0,31445,null,31445,null,31445,null,31445,null,31445,null,31445,null,31445,null,31445,null,31445,null,31445,null,31445]
[12392,"Kentucky Bus Oper Support",18681,33778,2772,55231,18681,33778,2772,55231,18681,33778,2772,55231,19313,34961,2869,57143,19313,34961,2869,57143,19313,34961,2869,57143,19313,34961,2869,57143,19313,34961,2869,57143,19313,34961,2869,57143,19313,34961,2869,57143,19313,34961,2869,57143,19313,34961,2869,57143]
[12393,"Ashland Design",22085,6202,3068,31355,22085,6202,3068,31355,22085,6202,3068,31355,22826,6399,3175,32400,22826,6399,3175,32400,22826,6399,3175,32400,22826,6399,3175,32400,22826,6399,3175,32400,22826,6399,3175,32400,22826,6399,3175,32400,22826,6399,3175,32400,22826,6399,3175,32400]
[12394,"Kentucky Corp Comm",null,10528,0,10528,null,10528,0,10528,null,10528,0,10528,null,10897,0,10897,null,10897,0,10897,null,10897,null,10897,null,10897,null,10897,null,10897,null,10897,null,10897,null,10897,null,10897,null,10897,null,10897,null,10897,null,10897,null,10897]
[12396,"Kentucky Region Support",125530,-42648,67461,150343,125530,-42648,67461,150343,125530,-42648,67461,150343,127479,-40173,68193,155499,127479,-40173,68193,155499,127479,-40173,68193,155499,127479,-40173,68193,155499,127479,-40173,68193,155499,127479,-40173,68193,155499,127479,-40173,68193,155499,127479,-40173,68193,155499,127479,-40173,68193,155499]
[12491,"GET ENG Project & FGD Eng",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[12539,"Trans Charge-Offs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[12660,"New Project Development",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[12681,"KY Forestry Support",2490,9484,0,11974,2490,9484,0,11974,2490,9484,0,11974,2513,9484,0,11997,2513,9484,0,11997,2513,9484,0,11997,2513,9484,0,11997,2513,9484,0,11997,2513,9484,null,11997,2513,9484,null,11997,2513,9484,null,11997,2513,9484,null,11997]
[12682,"Kentucky Distribution Dispatch",53970,42571,10422,106963,53970,42571,10422,106963,53970,42571,10422,106963,55721,43959,10756,110436,55721,43959,10756,110436,55721,43959,10756,110436,55721,43959,10756,110436,55721,43959,10756,110436,55721,43959,10756,110436,55721,43959,10756,110436,55721,43959,10756,110436,55721,43959,10756,110436]
[12748,"Int Emission Controls&Chem Eng",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[12778,"SC Kentucky District Ops",null,0,58062,58062,null,null,58062,58062,null,null,58062,58062,null,0,58769,58769,null,0,60026,60026,null,0,60026,60026,null,null,60026,60026,null,null,60026,60026,null,null,60026,60026,null,null,60026,60026,null,null,60026,60026,null,null,60026,60026]
[12961,"Pikeville Meter Electricians",2909,23159,282,26350,2909,23159,282,26350,2909,23159,282,26350,2928,23380,286,26594,2966,23823,292,27081,2966,23823,292,27081,2966,23823,292,27081,2966,23823,292,27081,2966,23823,292,27081,2966,23823,292,27081,2966,23823,292,27081,2966,23823,292,27081]
[12962,"Ashland Meter Electricians",1015,12959,170,14144,1015,12959,170,14144,1015,12959,170,14144,1015,12959,170,14144,1035,13362,176,14573,1035,13362,176,14573,1035,13362,176,14573,1035,13362,176,14573,1035,13362,176,14573,1035,13362,176,14573,1035,13362,176,14573,1035,13362,176,14573]
[12963,"Hazard Meter Electricians",620,12884,136,13640,620,12884,136,13640,620,12884,136,13640,620,12884,136,13640,635,13314,141,14090,635,13314,141,14090,635,13314,141,14090,635,13314,141,14090,635,13314,141,14090,635,13314,141,14090,635,13314,141,14090,635,13314,141,14090]
[13134,"Fleet Operations - KY",null,0,75588,75588,null,null,75588,75588,null,null,75588,75588,null,null,76660,76660,null,null,78128,78128,null,null,78128,78128,null,0,78128,78128,null,0,78128,78128,null,null,78128,78128,null,null,78128,78128,null,null,78128,78128,null,null,78128,78128]
[13158,"AppalachnKentuckyPwrTelecomOps",914,8201,0,9115,914,8201,0,9115,914,8201,0,9115,946,8488,0,9434,946,8488,0,9434,946,8488,0,9434,946,8488,0,9434,946,8488,0,9434,946,8488,null,9434,946,8488,null,9434,946,8488,null,9434,946,8488,null,9434]
[13403,"Mitchell Alloc/WPCo Billing",-15473,-718510,-52581,-786564,-15196,-692935,-51106,-759237,-15196,-692939,-51106,-759241,-15284,-701166,-51416,-767866,-15284,-701208,-51416,-767908,-15728,-717174,-52894,-785796,-15728,-717146,-52894,-785768,-15728,-717161,-52894,-785783,-15728,-717147,-52894,-785769,-15728,-717144,-52894,-785766,-15748,-717147,-52894,-785789,-15799,-716845,-52512,-785156]
[13448,"Ashland District Support",10469,6520,341,17330,10469,6520,341,17330,10469,6520,341,17330,10835,6748,353,17936,10835,6748,353,17936,10835,6748,353,17936,10835,6748,353,17936,10835,6748,353,17936,10835,6748,353,17936,10835,6748,353,17936,10835,6748,353,17936,10835,6748,353,17936]
[13449,"Hazard District Support",10477,6525,342,17344,10477,6525,342,17344,10477,6525,342,17344,10844,6754,353,17951,10844,6754,353,17951,10844,6754,353,17951,10844,6754,353,17951,10844,6754,353,17951,10844,6754,353,17951,10844,6754,353,17951,10844,6754,353,17951,10844,6754,353,17951]
[13450,"Pikeville District Support",9546,5310,520,15376,9546,5310,520,15376,9546,5310,520,15376,9881,5496,538,15915,9881,5496,538,15915,9881,5496,538,15915,9881,5496,538,15915,9881,5496,538,15915,9881,5496,538,15915,9881,5496,538,15915,9881,5496,538,15915,9881,5496,538,15915]
[13453,"KY Customer Services",9590,65388,1627,76605,9590,65388,1627,76605,9590,65388,1627,76605,9926,67677,1684,79287,9926,67677,1684,79287,9926,67677,1684,79287,9926,67677,1684,79287,9926,67677,1684,79287,9926,67677,1684,79287,9926,67677,1684,79287,9926,67677,1684,79287,9926,67677,1684,79287]
[13454,"KY Reliability",35893,24175,1224,61292,35893,24175,1224,61292,35893,24175,1224,61292,37149,25022,1267,63438,37149,25022,1267,63438,37149,25022,1267,63438,37149,25022,1267,63438,37149,25022,1267,63438,37149,25022,1267,63438,37149,25022,1267,63438,37149,25022,1267,63438,37149,25022,1267,63438]
[13455,"KY Reliability Design",16841,2036,2009.9999999999998,20887,16841,2036,2009.9999999999998,20887,16841,2036,2009.9999999999998,20887,17430,2108,2080,21618,17430,2108,2080,21618,17430,2108,2080,21618,17430,2108,2080,21618,17430,2108,2080,21618,17430,2108,2080,21618,17430,2108,2080,21618,17430,2108,2080,21618,17430,2108,2080,21618]
[13555,"F Hazard Forestry",2297,8413,0,10710,2297,8413,0,10710,2297,8413,0,10710,2318,8413,0,10731,2318,8413,0,10731,2318,8413,0,10731,2318,8413,0,10731,2318,8413,0,10731,2318,8413,null,10731,2318,8413,null,10731,2318,8413,null,10731,2318,8413,null,10731]
[13556,"G Pikeville Forestry",2503,9185,0,11688,2503,9185,0,11688,2503,9185,0,11688,2527,9185,0,11712,2527,9185,0,11712,2527,9185,0,11712,2527,9185,0,11712,2527,9185,null,11712,2527,9185,null,11712,2527,9185,null,11712,2527,9185,null,11712,2527,9185,null,11712]
[13557,"K Ashland Forestry",2330,8545,0,10875,2330,8545,0,10875,2330,8545,null,10875,2351,8545,0,10896,2351,8545,0,10896,2351,8545,0,10896,2351,8545,0,10896,2351,8545,0,10896,2351,8545,null,10896,2351,8545,null,10896,2351,8545,null,10896,2351,8545,null,10896]
[13580,"APKP TOps Project Delivery",17912,7655,0,25567,17912,7655,0,25567,17912,7655,0,25567,18539,7923,0,26462,18539,7923,0,26462,18539,7923,0,26462,18539,7923,0,26462,18539,7923,0,26462,18539,7923,null,26462,18539,7923,null,26462,18539,7923,null,26462,18539,7923,null,26462]
[13655,"Kentucky ContinuousImprovement",0,29133,0,29133,0,29133,0,29133,0,29133,0,29133,0,30153,0,30153,0,30153,0,30153,0,30153,0,30153,0,30153,0,30153,0,30153,0,30153,null,30153,null,30153,null,30153,null,30153,null,30153,null,30153,null,30153,null,30153]
[13736,"Kentucky Meter Group",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Grand Total",null,{"$f":"SUM(C7:C67)","v":826529},{"$f":"SUM(D7:D67)","v":1873952},868301,3568782,826253,1839388,850466,3516107,826252,1839384,850466,3516102,838402,1868530,858957,3565889,844480,1884140,864320,3592940,844923,1900128,878043,3623094,844922,1900217,878043,3623182,844923,1900202,878043,3623168,844923,1900216,878043,3623182,844923,1900342,878043,3623308,844943,1900339,878043,3623325,844997,1899679,877756,3622432]