{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["1","2","3","4","5","6","Output"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":96,"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","index":0,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[25,1,25,2],[26,1,26,2],[21,4,21,7],[13,1,13,5],[14,1,14,5],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[9,5,9,7],[10,5,10,7],[11,5,11,7],[12,5,12,7],[1,1,1,7],[3,1,3,7],[5,1,6,7],[8,5,8,7],[8,1,8,2]]}
[]
[null,"COAL PROPOSAL FORM"]
[]
[null,"Details concerning the supply of coal being offered herein to the American Electric Power Service Corporation (AEPSC) are provided below:"]
[]
[null,"1.  Seller:  (Include full names, addresses, and telephone numbers of Seller and Producer.  If Seller is a Sales Agent, please attach Producer's signed authorization for Sales Agent to “exclusively” make an offer on behalf of Producer.)"]
[]
[]
[null,"(a) Seller:",null,null,null,"(b) Producer:"]
[]
[]
[]
[]
[]
[null,"2.  Specification offered:"]
[]
[null,null,null,"CAPP"]
[null,null,null,"PRB"]
[null,null,null,"ILB"]
[null,null,null,"NAPP"]
[]
[null,"3.  Term:"]
[null,"The actual length of Term shall be designated by AEPSC in the event of its acceptance of offer.  "]
[null,"Seller is to specify the earliest month coal is available."]
[]
[null,"4.  Quantity offered:",null,"Year",2021,{"$f":"Year1+1","v":2022},{"$f":"Year2+1","v":2023},{"$f":"Year3+1","v":2024}]
[null,"       (Tons per Month)",null,"Jan"]
[null,1,null,"Feb"]
[null,{"$f":"CHOOSE(B28,\"CAPP\",\"PRB\",\"ILB\",\"NAPP\")","v":"CAPP"},null,"Mar"]
[null,null,null,"Apr"]
[null,null,null,"May"]
[null,null,null,"Jun"]
[null,null,null,"Jul"]
[null,null,null,"Aug"]
[null,null,null,"Sep"]
[null,null,null,"Oct"]
[null,null,null,"Nov"]
[null,null,null,"Dec"]
[]
[null,null,null,"Total",{"$f":"SUM(E27:E38)","v":0},{"$f":"SUM(F27:F38)","v":0},{"$f":"SUM(G27:G38)","v":0},{"$f":"SUM(H27:H38)","v":0}]
[]
[null,"5.  Pricing ($/short ton):",null,"FOB Rail:"]
[null,null,null,"FOB Barge:"]

{"sheet":"2","index":1,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[23,6,23,7],[24,6,24,7],[11,6,11,7],[10,6,10,7],[28,1,33,7],[17,3,17,7],[14,3,14,7],[18,3,18,7],[19,3,19,7],[20,3,20,7],[1,1,1,8],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[4,1,4,3],[5,1,5,3],[6,1,6,3],[7,1,7,3]]}
[]
[null,"6.  Mine Information"]
[]
[null,"Name:",null,null,"County:",null,"State:","MSHA ID:"]
[]
[]
[]
[]
[]
[]
[null,"7.  Type of Mine(s):",null,null,null,"Surface:",null,null,"%"]
[null,null,null,null,null,"Underground:",null,null,"%"]
[]
[]
[null,"8.  Mine District:"]
[]
[]
[null,"9.  Name of Seam(s):"]
[]
[]
[]
[]
[]
[null,"10.  Preparation:",null,null,null,"Crushed, run-of-mine:",null,null,"%"]
[null,null,null,null,null,"Washed:",null,null,"%"]
[]
[]
[null,"11.  Comments:"]

{"sheet":"3","index":2,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[10,5,10,6],[11,5,11,6],[12,5,12,6],[15,2,17,2],[18,2,20,2],[15,5,17,5],[18,6,20,6],[21,2,23,2],[24,2,26,2],[10,3,10,4],[11,3,11,4],[12,3,12,4],[18,4,20,4],[21,4,23,4],[15,3,17,3],[42,2,44,2],[42,4,44,4],[42,6,44,6],[33,6,35,6],[27,2,29,2],[45,2,47,2],[45,6,47,6],[7,1,8,6],[49,1,49,6],[50,1,50,6],[33,5,35,5],[39,2,41,2],[21,6,23,6],[24,5,26,5],[27,5,29,5],[9,1,14,1],[30,4,32,4],[30,6,32,6],[30,2,32,2],[33,2,35,2],[36,2,38,2]]}
[]
[null,"12.  Guaranteed coal specifications “As-Received”:"]
[]
[null,{"$f":"\"The quality of coal being offered herein is intended to meet Coal Specification \" &'1'!B29&\": \"","v":"The quality of coal being offered herein is intended to meet Coal Specification CAPP: "}]
[]
[]
[]
[null,"Table 1"]
[]
[null,"Parameter"]
[null,null,"Contracted","Suspension ",null,"Rejection"]
[null,null,"Monthly","Half-Month",null,"Applicable Lot***"]
[null,null,"Weighted","Wtd. Avg ",null,"Wtd. Avg "]
[null,null,"Average"]
[null,null,null,"minimum","maximum","minimum","maximum"]
[]
[null,"Calorific Value (Btu/lb.)",null,null,"N/A",null,"N/A"]
[]
[]
[null,"Moisture (%)",null,"N/A",null,"N/A"]
[]
[]
[null,"Ash (%)",null,"N/A",null,"N/A"]
[]
[]
[null,"Volatile Matter (%)",null,"N/A","N/A",null,"N/A"]
[]
[]
[null,"Hardgrove Grindability",null,"N/A","N/A",null,"N/A"]
[]
[]
[null,"**Sulfur Dioxide",null,"N/A",null,"N/A"]
[null,"(lbs. SO2 per mmBtu)"]
[]
[null,"Ash Fusion Temp.",null,"N/A","N/A"]
[null,"(H=½W) oF Red. Atm."]
[]
[null,"**Ash Loading",null,"N/A","N/A","N/A","N/A"]
[null,"(lbs. Ash/mmBtu)"]
[]
[null,"Mercury (lbs. Hg per TBtu)",null,"N/A","N/A","N/A","N/A"]
[]
[]
[null,"Chlorine (%)",null,"N/A",null,"N/A"]
[]
[null,null,"” x 0",null,null,null,"” x 0"]
[null,"Sizing",null,"N/A","N/A"]
[]
[]
[null,"** Half-Month Suspension should be reasonably close to the contracted specification"]
[null,"*** Applicable Lot refers to each barge load of coal, or at Buyer’s election, a composite of two or more barges, or a unit train"]

{"sheet":"4","index":3,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[28,2,28,10],[20,2,20,10],[22,2,22,10],[24,2,24,10],[26,2,26,10],[14,2,14,10],[16,2,16,10],[18,2,18,10],[5,2,5,10],[7,2,7,10],[9,2,9,10]]}
[]
[null,"Barge Deliveries"]
[]
[null,null,null,null,null,"Shipping Point(s):"]
[null,null,"Loading Dock (Dock):"]
[]
[null,null,"River:"]
[]
[null,null,"Milepost:"]
[]
[]
[null,"BARGE TRANSPORTATION FACILITIES INFORMATION"]
[]
[null,"1)","How many Jumbo Barges can be loaded in an eight-hour shift at the Dock?"]
[]
[null,"2)","How many shifts per day are barges loaded?"]
[]
[null,"3)","How many days per week are barges loaded?"]
[]
[null,"4)","How many loaded and empty Jumbo Barges can the Dock harbor accommodated?"]
[]
[null,"5)","What type of weighing system does the Dock have?"]
[]
[null,"6)","Is the weighing system certified? Yes/No"]
[]
[null,"7)","Does this Dock require the use of a harbor service for fleeting and switching? Yes/No"]
[]
[null,"8)","If the answer to No. 7 is “Yes”, please identify the required harbor service and any added fees."]

{"sheet":"5","index":4,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[5,2,5,10],[7,2,7,10],[26,2,26,10],[28,2,28,10],[24,2,24,10],[20,2,20,10],[12,2,12,10],[14,2,14,10],[16,2,16,10],[18,2,18,10],[22,2,22,10]]}
[]
[null,"Rail Deliveries (minimum 90 cars)"]
[]
[null,null,null,null,null,"Shipping Point(s):"]
[null,null,"Origin Station:"]
[]
[null,null,"FSAC Number:"]
[]
[]
[null,"RAIL TRANSPORTATION FACILITIES INFORMATION"]
[]
[null,"1)","What is the maximum number of rail cars per shipment? "]
[]
[null,"2)","What is the Origin Station load time for the shipment size above? "]
[]
[null,"3)","How many shifts per day are trains loaded? "]
[]
[null,"4)","How many days per week are trains loaded? "]
[]
[null,"5)","What type of weighing system does the Origin Station have?"]
[]
[null,"6)","Is the weighing system certified? Yes/No"]
[]
[null,"7)","Is the assistance of the Railroad's locomotive and crew required to load the train? "]
[]
[null,"8)","Are there any restrictions that would prevent your ability to load Buyer's railcars?"]
[]
[null,"9)","Is equipment available for applying freeze-proofing and/or side release agents?  Yes/No                                                                                                                                                               "]

{"sheet":"6","index":5,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[12,1,12,5],[15,1,15,5],[18,1,18,5]]}
[]
[null,"THIS IS A FIRM OFFER TO SUPPLY COAL UNDER ALL TERMS AND CONDITIONS INCLUDED IN THIS "]
[null,"COAL PROPOSAL PACKAGE, AND SHALL BE HELD OPEN BY SELLER FOR AEPSC’S ACCEPTANCE "]
[null,"THROUGH 5:00 P.M., FRIDAY, JUNE 11, 2021.  UNTIL AEPSC’S ACCEPTANCE HEREOF, "]
[null,"WHICH SHALL BE AT ITS SOLE DISCRETION, THIS PROPOSAL SHALL NOT CONSTITUTE A VALID  "]
[null,"AND ENFORCEABLE AGREEMENT, BUT UPON AEPSC'S ACCEPTANCE, SUCH PROPOSAL SHALL "]
[null,"CONSTITUTE A VALID AND ENFORCEABLE AGREEMENT BETWEEN AEPSC AND SELLER."]
[]
[null,"Proposal submitted by: "]
[]
[]
[]
[]
[null,"Signature"]
[]
[]
[null,"Title"]
[]
[]
[null,"Company"]

{"sheet":"Output","index":6,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":true,"merged":[[2,9,2,10],[2,6,2,7],[2,11,2,14]]}
[]
[]
[null,null,"Specification","Year","Counterparty Name","Mine Name(s)","Quantity",null,"Coal Price","Transportation",null,"Offered Quality",null,null,null,"Term / Comments"]
[null,null,null,null,null,null,"Tons","BTU","$/Ton","Barge/Rail","Dock / Rail District","BTU/LB","lbs. SO2","Sulfur %","Ash %","Term"]
[null,null,{"$f":"Specification","v":"CAPP"},{"$f":"Year1","v":2021},{"$f":"Seller_1","v":0},{"$f":"Mine_1","v":0},{"$f":"Year1_Tons","v":0},{"$f":"G5*L5/500","v":0},{"$f":"MAX(Year1_Rail,Year1_Barge)","v":0},{"$f":"IF(River=\"\",\"Rail\",\"Barge\")","v":"Rail"},{"$f":"IF(River=\"\",Rail_Station,Dock)","v":0},{"$f":"BTU_LB","v":0},{"$f":"LBS_SO2_MMBTU","v":0},{"$f":"M5*L5/2000000","v":0},{"$f":"Ash","v":0},{"$f":"Term","v":0}]
[null,null,{"$f":"Specification","v":"CAPP"},{"$f":"Year2","v":2022},{"$f":"Seller_1","v":0},{"$f":"Mine_1","v":0},{"$f":"Year2_Tons","v":0},{"$f":"G6*L6/500","v":0},{"$f":"MAX(Year2_Rail,Year2_Barge)","v":0},{"$f":"IF(River=\"\",\"Rail\",\"Barge\")","v":"Rail"},{"$f":"IF(River=\"\",Rail_Station,Dock)","v":0},{"$f":"BTU_LB","v":0},{"$f":"LBS_SO2_MMBTU","v":0},{"$f":"M6*L6/2000000","v":0},{"$f":"Ash","v":0},{"$f":"Term","v":0}]
[null,null,{"$f":"Specification","v":"CAPP"},{"$f":"Year3","v":2023},{"$f":"Seller_1","v":0},{"$f":"Mine_1","v":0},{"$f":"Year3_Tons","v":0},{"$f":"G7*L7/500","v":0},{"$f":"MAX(Year3_Rail,Year3_Barge)","v":0},{"$f":"IF(River=\"\",\"Rail\",\"Barge\")","v":"Rail"},{"$f":"IF(River=\"\",Rail_Station,Dock)","v":0},{"$f":"BTU_LB","v":0},{"$f":"LBS_SO2_MMBTU","v":0},0,{"$f":"Ash","v":0},{"$f":"Term","v":0}]
[null,null,{"$f":"Specification","v":"CAPP"},{"$f":"Year4","v":2024},{"$f":"Seller_1","v":0},{"$f":"Mine_1","v":0},{"$f":"Year4_Tons","v":0},{"$f":"G8*L8/500","v":0},{"$f":"MAX(Year4_Rail,Year4_Barge)","v":0},{"$f":"IF(River=\"\",\"Rail\",\"Barge\")","v":"Rail"},{"$f":"IF(River=\"\",Rail_Station,Dock)","v":0},{"$f":"BTU_LB","v":0},{"$f":"LBS_SO2_MMBTU","v":0},{"$f":"M8*L8/2000000","v":0},{"$f":"Ash","v":0},{"$f":"Term","v":0}]