{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Evaluation","Mitchell High Sulfur 2025","Mitchell High Sulfur 2024","Mitchell High Sulfur 2023","Mitchell High Sulfur 2022","Mitchell Low Sulfur 2025","Mitchell Low Sulfur 2024","Mitchell Low Sulfur 2023","Mitchell Low Sulfur 2022"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":30,"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":"Evaluation","index":0,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":true,"merged":[[14,2,15,17],[4,10,5,10],[4,11,5,11],[4,12,5,12],[4,13,5,13],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,14,5,14],[4,17,5,17],[0,1,1,17],[3,4,3,5],[3,7,3,9],[3,10,3,13],[3,14,3,16]]}
[]
[]
[]
[null,null,"Offer / Plant / Year","Mine","Quantity",null,"Coal Price","Transportation ",null,null,"Offered Quality",null,null,null,"Quality Adjusted Delivered Pricing"]
[null,null,null,null,"Tons","BTU","Coal Price","River / Rail","MP / District","Rate","Btu","lbs. SO2","Sulfur %","Ash %","Quality Adj.","Quality Adjusted","Delivered","Comments"]
[null,null,2020,null,null,null,null,null,null,null,null,null,null,null,null,"Delivered Cost ","$MMBTU "]
[null,null,null,null,null,null,null,null,null,{"$f":"GETPIVOTDATA(\"ROUND(AVG(RATE),2)\",#REF!,\"PILE\",$C$5,\"ORIGIN\",I7,\"EXTRACT(YEARFROMMONTH)\",$C$6)","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"+((1-$E$12)*(L7*K7*$E$13)/1000000)+(($E$12*L7*K7*$E$14)/1000000)","v":{"$error":"#REF!"}},{"$f":"G7+J7+O7","v":{"$error":"#REF!"}},{"$f":"P7/(K7/500)","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,null,{"$f":"IF(ISNA(VLOOKUP(C5,Pile,2,0)),\"\",VLOOKUP(C5,Pile,2,0))","v":{"$error":"#REF!"}}]
[null,null,"FGD Removal Efficiency",null,{"$f":"IF(ISNA(VLOOKUP(C11,FGD,2,0)),0,VLOOKUP(C11,FGD,2,0))","v":{"$error":"#REF!"}}]
[null,null,"SO2 Allowance Cost ",null,{"$f":"SO2_Credit","v":{"$error":"#REF!"}}]
[null,null,"Removal Cost $/Ton",null,{"$f":"IF(ISNA(VLOOKUP(C11,FGD,3,0)),0,VLOOKUP(C11,FGD,3,0))","v":{"$error":"#REF!"}}]
[null,null,"Highly Sensitive and Confidential"]

{"sheet":"Mitchell High Sulfur 2025","index":1,"n_rows":15,"n_cols":21,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,1,20],[3,6,5,6],[3,10,3,12],[3,13,3,16],[3,17,3,19],[4,4,5,4],[4,5,5,5],[4,7,5,7],[4,10,5,10],[4,11,5,11],[4,20,5,20],[14,2,15,20],[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,15,5,15],[4,16,5,16],[4,17,5,17]]}
[null,"Mitchell High Sulfur - 2024 NAPP"]
[]
[]
[null,null,"Offer","Mine","Quantity","Coal Price","Severance Tax Discount","Coal Price",null,null,"Transportation ",null,null,"Offered Quality",null,null,null,"Quality Adjusted Delivered Pricing"]
[null,null,null,null,"Tons","As Offered",null,"Less Severance Tax","Severance Tax Rate","Coal Source - State","River / Rail","MP / District","Rate","Btu","lbs. SO2","Sulfur %","Ash %","Quality Adj.","Quality Adjusted","Delivered","Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delivered Cost ","$MMBTU "]
[null,null,"Alliance Coal, LLC.","Tunnel Ridge Mine",1500000,80,{"$f":"-F7*I7","v":-2.4},{"$f":"F7+G7","v":77.599999999999994},0.03,"WV","Barge","Tunnel Ridge LO - Tridelphia, WV",0.95,12600,5.6,3.5299999999999998E-2,9.2499999999999999E-2,{"$f":"+((1-$E$12)*(O7*N7*$E$13)/1000000)+(($E$12*O7*N7*$E$14)/1000000)","v":13.47787368144},{"$f":"F7+M7+R7","v":94.427873681440005},{"$f":"S7/(N7/500)","v":3.7471378445015877},"Proposed purchase; Contract in negotiation"]
[]
[]
[]
[null,null,""]
[null,null,"FGD Removal Efficiency",null,0.9829]
[null,null,"SO2 Allowance Cost ",null,1.5]
[null,null,"Removal Cost $/Ton",null,194.31]
[null,null,"Highly Sensitive and Confidential"]

{"sheet":"Mitchell High Sulfur 2024","index":2,"n_rows":15,"n_cols":21,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,1,20],[3,6,5,6],[3,10,3,12],[3,13,3,16],[3,17,3,19],[4,4,5,4],[4,5,5,5],[4,7,5,7],[4,10,5,10],[4,11,5,11],[4,20,5,20],[14,2,15,20],[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,15,5,15],[4,16,5,16],[4,17,5,17]]}
[null,"Mitchell High Sulfur - 2024 NAPP"]
[]
[]
[null,null,"Offer","Mine","Quantity","Coal Price","Severance Tax Discount","Coal Price",null,null,"Transportation ",null,null,"Offered Quality",null,null,null,"Quality Adjusted Delivered Pricing"]
[null,null,null,null,"Tons","As Offered",null,"Less Severance Tax","Severance Tax Rate","Coal Source - State","River / Rail","MP / District","Rate","Btu","lbs. SO2","Sulfur %","Ash %","Quality Adj.","Quality Adjusted","Delivered","Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delivered Cost ","$MMBTU "]
[null,null,"Alliance Coal, LLC.","Tunnel Ridge Mine",1500000,85,{"$f":"-F7*I7","v":-2.5499999999999998},{"$f":"F7+G7","v":82.45},0.03,"WV","Barge","Tunnel Ridge LO - Tridelphia, WV",0.94,12600,5.6,3.5299999999999998E-2,9.2499999999999999E-2,{"$f":"+((1-$E$12)*(O7*N7*$E$13)/1000000)+(($E$12*O7*N7*$E$14)/1000000)","v":13.47787368144},{"$f":"F7+M7+R7","v":99.41787368144},{"$f":"S7/(N7/500)","v":3.9451537175174605},"Proposed purchase; Contract in negotiation"]
[]
[]
[]
[null,null,""]
[null,null,"FGD Removal Efficiency",null,0.9829]
[null,null,"SO2 Allowance Cost ",null,1.5]
[null,null,"Removal Cost $/Ton",null,194.31]
[null,null,"Highly Sensitive and Confidential"]

{"sheet":"Mitchell High Sulfur 2023","index":3,"n_rows":15,"n_cols":21,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,1,20],[3,6,5,6],[3,10,3,12],[3,13,3,16],[3,17,3,19],[4,4,5,4],[4,5,5,5],[4,7,5,7],[4,10,5,10],[4,11,5,11],[4,20,5,20],[14,2,15,20],[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,15,5,15],[4,16,5,16],[4,17,5,17]]}
[null,"Mitchell High Sulfur - 2023 NAPP"]
[]
[]
[null,null,"Offer","Mine","Quantity","Coal Price","Severance Tax Discount","Coal Price",null,null,"Transportation ",null,null,"Offered Quality",null,null,null,"Quality Adjusted Delivered Pricing"]
[null,null,null,null,"Tons","As Offered",null,"Less Severance Tax","Severance Tax Rate","Coal Source - State","River / Rail","MP / District","Rate","Btu","lbs. SO2","Sulfur %","Ash %","Quality Adj.","Quality Adjusted","Delivered","Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delivered Cost ","$MMBTU "]
[]
[]
[]
[]
[null,null,""]
[null,null,"FGD Removal Efficiency",null,0.9829]
[null,null,"SO2 Allowance Cost ",null,1.5]
[null,null,"Removal Cost $/Ton",null,194.31]
[null,null,"Highly Sensitive and Confidential"]

{"sheet":"Mitchell High Sulfur 2022","index":4,"n_rows":15,"n_cols":21,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,1,20],[3,6,5,6],[3,10,3,12],[3,13,3,16],[3,17,3,19],[4,4,5,4],[4,5,5,5],[4,7,5,7],[4,10,5,10],[4,11,5,11],[4,20,5,20],[14,2,15,20],[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,15,5,15],[4,16,5,16],[4,17,5,17]]}
[null,"Mitchell High Sulfur - 2022 NAPP"]
[]
[]
[null,null,"Offer","Mine","Quantity","Coal Price","Severance Tax Discount","Coal Price",null,null,"Transportation ",null,null,"Offered Quality",null,null,null,"Quality Adjusted Delivered Pricing"]
[null,null,null,null,"Tons","As Offered",null,"Less Severance Tax","Severance Tax Rate","Coal Source - State","River / Rail","MP / District","Rate","Btu","lbs. SO2","Sulfur %","Ash %","Quality Adj.","Quality Adjusted","Delivered","Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delivered Cost ","$MMBTU "]
[]
[]
[]
[]
[null,null,""]
[null,null,"FGD Removal Efficiency",null,0.9829]
[null,null,"SO2 Allowance Cost ",null,1.5]
[null,null,"Removal Cost $/Ton",null,194.31]
[null,null,"Highly Sensitive and Confidential"]

{"sheet":"Mitchell Low Sulfur 2025","index":5,"n_rows":15,"n_cols":21,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,1,20],[3,6,5,6],[3,10,3,12],[3,13,3,16],[3,17,3,19],[4,4,5,4],[4,5,5,5],[4,7,5,7],[4,10,5,10],[4,11,5,11],[4,20,5,20],[14,2,15,20],[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,15,5,15],[4,16,5,16],[4,17,5,17]]}
[null,"Mitchell Low Sulfur - 2024 CAPP"]
[]
[]
[null,null,"Offer","Mine","Quantity","Coal Price","Severance Tax Discount","Coal Price",null,null,"Transportation ",null,null,"Offered Quality",null,null,null,"Quality Adjusted Delivered Pricing"]
[null,null,null,null,"Tons","As Offered",null,"Less Severance Tax","Severance Tax Rate","Coal Source - State","River / Rail","MP / District","Rate","Btu","lbs. SO2","Sulfur %","Ash %","Quality Adj.","Quality Adjusted","Delivered","Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delivered Cost ","$MMBTU "]
[null,null,"Alpha Thermal Coal Sales Company","Pax",300000,95,{"$f":"-F7*I7","v":-2.85},{"$f":"F7+G7","v":92.15},0.03,"WV","Barge","Mammoth Dock LO - Montogomery, WV",9.4600000000000009,12400,1.6,9.9000000000000008E-3,0.1,{"$f":"+((1-$E$12)*(O7*N7*$E$13)/1000000)+(($E$12*O7*N7*$E$14)/1000000)","v":3.7896969081600003},{"$f":"F7+M7+R7","v":108.24969690816},{"$f":"S7/(N7/500)","v":4.3649071333935483},"Proposed purchase. 03-00-25-9M1"]
[]
[]
[]
[null,null,""]
[null,null,"FGD Removal Efficiency",null,0.9829]
[null,null,"SO2 Allowance Cost ",null,1.5]
[null,null,"Removal Cost $/Ton",null,194.31]
[null,null,"Highly Sensitive and Confidential"]

{"sheet":"Mitchell Low Sulfur 2024","index":6,"n_rows":15,"n_cols":21,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,1,20],[3,6,5,6],[3,10,3,12],[3,13,3,16],[3,17,3,19],[4,4,5,4],[4,5,5,5],[4,7,5,7],[4,10,5,10],[4,11,5,11],[4,20,5,20],[14,2,15,20],[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,15,5,15],[4,16,5,16],[4,17,5,17]]}
[null,"Mitchell Low Sulfur - 2024 CAPP"]
[]
[]
[null,null,"Offer","Mine","Quantity","Coal Price","Severance Tax Discount","Coal Price",null,null,"Transportation ",null,null,"Offered Quality",null,null,null,"Quality Adjusted Delivered Pricing"]
[null,null,null,null,"Tons","As Offered",null,"Less Severance Tax","Severance Tax Rate","Coal Source - State","River / Rail","MP / District","Rate","Btu","lbs. SO2","Sulfur %","Ash %","Quality Adj.","Quality Adjusted","Delivered","Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delivered Cost ","$MMBTU "]
[]
[]
[]
[]
[null,null,""]
[null,null,"FGD Removal Efficiency",null,0.9829]
[null,null,"SO2 Allowance Cost ",null,1.5]
[null,null,"Removal Cost $/Ton",null,194.31]
[null,null,"Highly Sensitive and Confidential"]

{"sheet":"Mitchell Low Sulfur 2023","index":7,"n_rows":15,"n_cols":21,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,1,20],[3,6,5,6],[3,10,3,12],[3,13,3,16],[3,17,3,19],[4,4,5,4],[4,5,5,5],[4,7,5,7],[4,10,5,10],[4,11,5,11],[4,20,5,20],[14,2,15,20],[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,15,5,15],[4,16,5,16],[4,17,5,17]]}
[null,"Mitchell Low Sulfur - 2023 CAPP"]
[]
[]
[null,null,"Offer","Mine","Quantity","Coal Price","Severance Tax Discount","Coal Price",null,null,"Transportation ",null,null,"Offered Quality",null,null,null,"Quality Adjusted Delivered Pricing"]
[null,null,null,null,"Tons","As Offered",null,"Less Severance Tax","Severance Tax Rate","Coal Source - State","River / Rail","MP / District","Rate","Btu","lbs. SO2","Sulfur %","Ash %","Quality Adj.","Quality Adjusted","Delivered","Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delivered Cost ","$MMBTU "]
[null,null,"Blackhawk","Qunicy Dock",180000,110,{"$f":"-F7*I7","v":-3.3},{"$f":"F7+G7","v":106.7},0.03,"WV","Barge","Quincy",9.58,12000,1.67,null,0.14000000000000001,{"$f":"+((1-$E$12)*(O7*N7*$E$13)/1000000)+(($E$12*O7*N7*$E$14)/1000000)","v":3.8278994979599994},{"$f":"F7+M7+R7","v":123.40789949796},{"$f":"S7/(N7/500)","v":5.1419958124149998},"Proposed purchase.  03-00-22-9M2"]
[]
[]
[]
[null,null,""]
[null,null,"FGD Removal Efficiency",null,0.9829]
[null,null,"SO2 Allowance Cost ",null,1.5]
[null,null,"Removal Cost $/Ton",null,194.31]
[null,null,"Highly Sensitive and Confidential"]

{"sheet":"Mitchell Low Sulfur 2022","index":8,"n_rows":15,"n_cols":21,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,1,20],[3,10,3,12],[3,13,3,16],[3,17,3,19],[4,20,5,20],[14,2,15,20],[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,15,5,15],[4,16,5,16],[4,17,5,17],[4,4,5,4],[4,5,5,5],[4,10,5,10],[4,11,5,11],[3,6,5,6],[4,7,5,7]]}
[null,"Mitchell Low Sulfur - 2022 CAPP"]
[]
[]
[null,null,"Offer","Mine","Quantity","Coal Price","Severance Tax Discount","Coal Price",null,null,"Transportation ",null,null,"Offered Quality",null,null,null,"Quality Adjusted Delivered Pricing"]
[null,null,null,null,"Tons","As Offered",null,"Less Severance Tax","Severance Tax Rate","Coal Source - State","River / Rail","MP / District","Rate","Btu","lbs. SO2","Sulfur %","Ash %","Quality Adj.","Quality Adjusted","Delivered","Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delivered Cost ","$MMBTU "]
[null,null,"Alpha Thermal Coal Sales Company","Pax",80000,160,{"$f":"-F7*I7","v":-4.8},{"$f":"F7+G7","v":155.19999999999999},0.03,"WV","Barge","Mammoth Dock LO - Montgomery, WV",8.41,12400,1.6,9.92E-3,0.1,{"$f":"+((1-$E$12)*(O7*N7*$E$13)/1000000)+(($E$12*O7*N7*$E$14)/1000000)","v":3.7896969081600003},{"$f":"F7+M7+R7","v":172.19969690816001},{"$f":"S7/(N7/500)","v":6.9435361656516132},"Proposed purchase.  03-00-22-9M2"]
[]
[]
[]
[null,null,""]
[null,null,"FGD Removal Efficiency",null,0.9829]
[null,null,"SO2 Allowance Cost ",null,1.5]
[null,null,"Removal Cost $/Ton",null,194.31]
[null,null,"Highly Sensitive and Confidential"]