{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["2017-2020 Employee Count"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"2017-2020 Employee Count","index":0,"n_rows":63,"n_cols":45,"rows_kept":63,"cut":false,"hidden":false,"merged":[[3,2,3,13],[3,14,3,25],[3,26,3,37],[3,38,3,44]]}
["KPCO Employee Count by Department by Month"]
["January 2017 - July 2020"]
[]
[null,null,2017,null,null,null,null,null,null,null,null,null,null,null,2018,null,null,null,null,null,null,null,null,null,null,null,2019,null,null,null,null,null,null,null,null,null,null,null,2020]
["Department ID","Department Description","(01) Jan","(02) Feb","(03) Mar","(04) Apr","(05) May","(06) Jun","(07) Jul","(08) Aug","(09) Sep","(10) Oct","(11) Nov","(12) Dec","(01) Jan","(02) Feb","(03) Mar","(04) Apr","(05) May","(06) Jun","(07) Jul","(08) Aug","(09) Sep","(10) Oct","(11) Nov","(12) Dec","(01) Jan","(02) Feb","(03) Mar","(04) Apr","(05) May","(06) Jun","(07) Jul","(08) Aug","(09) Sep","(10) Oct","(11) Nov","(12) Dec","(01) Jan","(02) Feb","(03) Mar","(04) Apr","(05) May","(06) Jun","(07) Jul"]
["10107","Big Sandy Plant Stores",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["10129","Pikeville Meter Revenue Opers",6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,5,5,6,6,6,6,6,6,6,6,6,8,8,8,8,8,7,7,7,7,7,7,7,7,7,7,7,7]
["10216","Ashland Const",29,29,29,29,28,27,26,29,29,29,29,29,29,29,29,28,27,27,27,27,27,27,27,27,27,27,26,26,25,25,25,25,25,25,28,28,29,29,29,30,30,30,30]
["10218","Big Sandy Plant",37,39,39,38,38,38,37,38,38,37,37,37,37,37,37,37,37,36,36,36,35,36,35,34,33,33,32,32,32,32,32,32,33,29,29,29,23,22,22,23,23,23,23]
["10512","Hazard Meter Revenue Opers",5,5,4,5,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
["10594","Plant Engineering Region 1",7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,1,1,1,1,1,1,1,1,1,2,2,2]
["10642","Mitchell Plant",247,247,246,244,244,244,244,243,243,242,243,244,242,242,240,233,228,226,223,220,217,216,216,217,217,211,199,199,197,191,192,192,190,190,192,191,190,190,191,188,188,185,184]
["10695","Pikeville Const",29,29,29,29,29,28,28,28,28,26,26,27,27,27,27,27,27,27,27,28,28,27,27,27,27,26,25,25,24,25,24,21,21,22,23,23,23,23,25,25,25,25,23]
["10887","Kammer Plant",3,3]
["11266","Ashland Meter Revenue Opers",7,7,7,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,6,6,6,6,6,6,5,5,5,5,5,5,5,5,5,5,5]
["11364","Program Engineering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,5,5,5,5,5,5,5,5,5,5]
["11386","Mitchell Plant Stores",7,7,7,7,7,7,7,7,7,6,6,6,6,6,6,6,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,3,3,3]
["11439","Kentucky Power Co Headquarters",2,3,2,2,2,2,2,2,2,2,2,2,2,2,2,3,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
["11680","Pikeville Design",6,6,6,6,6,6,6,6,6,7,7,6,6,6,6,6,6,7,7,8,8,8,7,7,7,8,8,8,6,6,6,7,7,7,8,10,10,10,9,9,9,9,9]
["11683","Hazard Const",30,30,30,30,30,30,30,29,29,29,29,28,28,27,28,28,28,28,28,28,28,29,29,29,29,29,29,29,29,29,29,27,27,27,27,30,30,30,30,29,29,28,28]
["11685","Paintsville Construction",10,10,10,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,8,8,8,8,9,10,10,10,9,9,8,8,10,10,10,10,10]
["11783","Regulatory Services - Kentucky",4,4,4,4,4,4,3,3,3,3,3,2,2,2,2,2,3,4,4,4,4,3,3,3,2,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
["11834","ED DSM Compliance",3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
["12144","Ashland Telecom Ops",10,10,10,10,10,9,8,9,10,10,10,10,9,9,9,9,10,10,10,10,10,10,10,10,9,9,9,9,9,9,9,9,9,10,10,10,10,10,9,9,9,9,9]
["12389","Hazard Design",5,5,5,5,5,4,5,5,5,5,5,5,5,5,5,5,5,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,7,7,7,7,7,7]
["12390","Kentucky Gov & Envir Aff",2,2,2,2,2,2,2,2,2,2,2,2,1,1,1,1,1,2,2,2,2,2,2,2,2,2,2,2,2,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
["12392","Kentucky Bus Oper Support",7,8,9,9,9,9,9,9,8,8,8,8,8,8,8,9,7,7,7,6,7,7,6,6,6,6,6,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7]
["12393","Ashland Design",5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,4,6,6,5,5,6,6,6,6,6,6,6,6,6,6,7,7,7,7,7,7,8,7,7,7,7]
["12394","Kentucky Corp Comm",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["12396","Kentucky Region Support",12,12,12,15,17,19,19,20,20,22,22,21,22,21,21,21,19,19,19,17,17,19,20,20,19,17,15,11,10,12,12,11,11,11,11,12,12,12,13,14,14,14,14]
["12632","Transmission Forestry",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["12639","GIS Roanoke Graphics",2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
["12681","KY Forestry Support",7,7,7,2,2,2,2,2,2,2,2,2,2,2,1,1,1,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
["12682","Kentucky Distribution Dispatch",12,12,12,12,12,11,11,11,11,11,11,11,12,12,12,12,12,12,12,12,13,13,13,13,13,13,13,13,12,12,12,12,11,11,13,13,13,12,12,12,12,12,12]
["12763","Fleet Operations - East",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1]
["12778","SC Kentucky District Ops",9,9,10,10,10,9,9,9,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,9,8,8,8,9,10,10,10,10,10,10,11,11,11,11,11,10,11,11,11]
["12961","Pikeville Meter Electricians",3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,2,3,3,3,3,3]
["12962","Ashland Meter Electricians",2,1,1,1,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
["12963","Hazard Meter Electricians",2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,1,1,1,1,1,1,2,2,2,2,2,2,2,2,1,1,1,1,1]
["13134","Fleet Operations - KY",10,10,10,9,9,9,10,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,10,9,9,10,10,10,10,10,11,11,11,11,12,12,11,11,11]
["13158","AppalachnKentuckyPwrTelecomOps",3,3,3,2,3,3,3,3,3,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["13448","Ashland District Support",2,2,2,2,2,3,3,2,2,2,2,2,2,1,1,null,1,1,1,1,2,2,2,2,2,3,4,4,4,4,4,4,5,5,5,5,6,6,6,6,6,6,6]
["13449","Hazard District Support",2,2,2,2,2,2,2,2,2,2,2,1,1,2,2,2,2,2,2,2,2,2,2,2,2,2,4,4,4,4,4,5,5,5,5,5,6,6,6,6,5,5,5]
["13450","Pikeville District Support",2,2,2,2,2,3,3,2,2,2,2,2,2,2,2,2,2,3,3,3,4,4,4,4,4,4,4,4,4,5,5,6,6,6,6,6,6,5,6,6,6,6,6]
["13453","KY Customer Services",12,13,14,7,8,8,8,8,8,8,8,8,8,7,8,8,10,9,10,10,10,10,10,9,9,10,10,10,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11]
["13454","KY Reliability",7,7,7,7,7,7,7,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,6,6,5,5,5,5,5,5,6,6,6,6,6,6]
["13455","KY Reliability Design",3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,2,2,2,2,2,2,2,2,2,2,2,2,2,1,1,1,1,1,1]
["13555","F Hazard Forestry",null,null,null,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
["13556","G Pikeville Forestry",null,null,null,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
["13557","K Ashland Forestry",null,null,null,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
["13580","APKP TOps Project Delivery",null,null,null,null,null,null,null,null,null,2,2,2,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
["13655","Kentucky ContinuousImprovement\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,4,4,4,4,4,3,3,3]
["13736","Kentucky Meter Group\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,5,6,6,8,8,8,8,8,8,8,8,7,7,7,7]
["Grand Total",null,{"$f":"SUM(C6:C53)","v":554},{"$f":"SUM(D6:D53)","v":558},555,548,550,549,547,551,552,550,551,548,547,544,543,533,526,527,527,523,522,523,522,520,514,509,494,495,490,489,491,487,486,484,493,499,494,491,498,493,490,486,483]
[]
["Mitchell Plant"]
["10642","Mitchell Plant",247,247,246,244,244,244,244,243,243,242,243,244,242,242,240,233,228,226,223,220,217,216,216,217,217,211,199,199,197,191,192,192,190,190,192,191,190,190,191,188,188,185,184]
["11386","Mitchell Plant Stores",7,7,7,7,7,7,7,7,7,6,6,6,6,6,6,6,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,3,3,3]
["Mitchell Plant Total",null,{"$f":"SUM(C57:C58)","v":254},{"$f":"SUM(D57:D58)","v":254},253,251,251,251,251,250,250,248,249,250,248,248,246,239,233,231,228,225,222,221,221,222,222,216,204,204,202,196,197,197,195,195,197,196,195,195,196,193,191,188,187]
[]
["Exclude 50% of Mitchell",null,{"$f":"C59/2","v":127},{"$f":"D59/2","v":127},126.5,125.5,125.5,125.5,125.5,125,125,124,124.5,125,124,124,123,119.5,116.5,115.5,114,112.5,111,110.5,110.5,111,111,108,102,102,101,98,98.5,98.5,97.5,97.5,98.5,98,97.5,97.5,98,96.5,95.5,94,93.5]
[]
["KPCO Total Employee Count",null,{"$f":"C54-C61","v":427},{"$f":"D54-D61","v":431},428.5,422.5,424.5,423.5,421.5,426,427,426,426.5,423,423,420,420,413.5,409.5,411.5,413,410.5,411,412.5,411.5,409,403,401,392,393,389,391,392.5,388.5,388.5,386.5,394.5,401,396.5,393.5,400,396.5,394.5,392,389.5]