{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["1","2","3","4","5","Output"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":46,"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":[[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[1,1,1,7],[3,1,3,7],[5,1,6,7],[8,5,8,7],[25,1,25,3],[21,5,21,7],[13,1,13,5],[14,1,14,5],[9,5,9,7],[10,5,10,7],[11,5,11,7],[12,5,12,7],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[16,4,16,5],[19,1,19,3],[19,4,19,5],[17,4,17,5],[18,4,18,5],[16,1,16,3],[17,1,17,3],[18,1,18,3]]}
[]
[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.  Mine Information"]
[null,"Name:",null,null,"County:",null,"State:","MSHA ID:"]
[]
[]
[]
[]
[]
[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 (tons per month):",null,null,"Year",2019,2020,2021]
[null,null,null,null,"Jan"]
[null,1,{"$f":"CHOOSE(B28,\"A\",\"B\",\"C\",\"D\")","v":"A"},null,"Feb"]
[null,"Specification A",null,null,"Mar"]
[null,"Specification B",null,null,"Apr"]
[null,"Specification C",null,null,"May"]
[null,"Specification D",null,null,"Jun"]
[null,null,null,null,"Jul"]
[null,null,null,null,"Aug"]
[null,null,null,null,"Sep"]
[null,null,null,null,"Oct"]
[null,null,null,null,"Nov"]
[null,null,null,null,"Dec"]
[]
[null,null,null,null,"Total",{"$f":"SUM(F27:F38)","v":0},{"$f":"SUM(G27:G38)","v":0},{"$f":"SUM(H27:H38)","v":0}]
[]
[null,"5.  Pricing ($/short ton):",null,null,"FOB Rail:"]
[null,null,null,null,"FOB Barge:"]

{"sheet":"2","index":1,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[10,3,10,4],[11,3,11,4],[12,3,12,4],[10,5,10,6],[11,5,11,6],[12,5,12,6],[27,2,29,2],[18,4,20,4],[15,5,17,5],[21,4,23,4],[18,6,20,6],[15,3,17,3],[15,2,17,2],[18,2,20,2],[21,2,23,2],[24,2,26,2],[30,6,32,6],[30,2,32,2],[33,2,35,2],[36,2,38,2],[42,2,44,2],[42,4,44,4],[42,6,44,6],[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],[36,4,38,4],[39,4,41,4],[36,6,38,6],[39,6,41,6],[21,6,23,6],[24,5,26,5],[27,5,29,5],[9,1,14,1],[30,4,32,4]]}
[]
[null,"6.  Guaranteed coal specifications “As-Received”:"]
[]
[null,{"$f":"\"The quality of coal being offered herein is intended to meet Coal Specification \" &'1'!C28&\": \"","v":"The quality of coal being offered herein is intended to meet Coal Specification A: "}]
[]
[]
[]
[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,"N/A"]
[null,"(H=½W) oF Red. Atm."]
[]
[null,"**Ash Loading",null,"N/A",null,"N/A"]
[null,"(lbs. Ash/mmBtu)"]
[]
[null,"Mercury (lbs. Hg per TBtu)",null,"N/A",null,"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":"3","index":2,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[33,1,37,4]]}
[]
[null,"7.  Bidder’s Shipping Point:"]
[]
[null,"Rail Deliveries (minimum 90 cars)"]
[]
[null,"Shipping Point(s):",null,"Origin Station:"]
[null,null,null,"FSAC Number:"]
[]
[null,"Barge Deliveries"]
[]
[null,"Shipping Point(s):",null,"Loading Dock (Dock):"]
[null,null,null,"River:"]
[null,null,null,"Milepost:"]
[]
[]
[null,"8.  Type of Mine(s):",null,"Surface:",null,"%"]
[null,null,null,"Underground:",null,"%"]
[]
[]
[null,"9.  Mine District:"]
[]
[]
[null,"10.  Name of Seam(s):"]
[]
[]
[]
[]
[]
[null,"11.  Preparation:",null,"Crushed, run-of-mine:",null,"%"]
[null,null,null,"Washed:",null,"%"]
[]
[]
[null,"12.  Comments:"]

{"sheet":"4","index":3,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[[29,4,29,10],[10,6,10,10],[13,2,13,10],[4,6,4,10],[5,6,5,10],[7,2,7,10],[9,2,9,10],[3,9,3,10],[19,7,19,10],[20,8,20,10],[22,6,22,10],[27,2,27,10],[24,2,24,10],[21,6,21,10],[25,6,25,10]]}
[]
[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."]
[]
[]
[]
[]
[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 be 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 4,000 cubic feet "]
[null,null,"AEPX hopper cars?"]
[null,"9)","Is equipment available for applying freeze-proofing and/or side release agents?  Yes/No                                                                                                                                                               "]

{"sheet":"5","index":4,"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, MARCH 22, 2019.  UNTIL AEPSC’S ACCEPTANCE HEREOF, WHICH"]
[null,"SHALL BE AT ITS SOLE DISCRETION, THIS PROPOSAL SHALL NOT CONSTITUTE A VALID AND "]
[null,"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":5,"n_rows":7,"n_cols":15,"rows_kept":7,"cut":false,"hidden":true,"merged":[[2,8,2,9],[2,5,2,6],[2,10,2,13]]}
[]
[]
[null,null,"Year","Counterparty Name","Mine Name(s)","Quantity",null,"Coal Price","Transportation",null,"Offered Quality",null,null,null,"Term / Comments"]
[null,null,null,null,null,"Tons","BTU","$/Ton","Barge/Rail","River & MP / Rail District","BTU/LB","lbs. SO2","Sulfur %","Ash %","Term"]
[null,null,{"$f":"Year1","v":2019},{"$f":"Seller_1","v":0},{"$f":"Mine_1","v":0},{"$f":"Year1_Tons","v":0},{"$f":"F5*K5/500","v":0},{"$f":"Year1_Rail","v":0},{"$f":"IF(River=\"\",\"Rail\",\"Barge\")","v":"Rail"},{"$f":"IF(River=\"\",Rail_Station,River)","v":0},{"$f":"BTU_LB","v":0},{"$f":"LBS_SO2_MMBTU","v":0},null,{"$f":"Ash","v":0},{"$f":"Term","v":0}]
[null,null,{"$f":"Year2","v":2020},{"$f":"Seller_1","v":0},{"$f":"Mine_1","v":0},{"$f":"Year2_Tons","v":0},{"$f":"F6*K6/500","v":0},{"$f":"Year2_Rail","v":0},{"$f":"IF(River=\"\",\"Rail\",\"Barge\")","v":"Rail"},{"$f":"IF(River=\"\",Rail_Station,River)","v":0},{"$f":"BTU_LB","v":0},{"$f":"LBS_SO2_MMBTU","v":0},null,{"$f":"Ash","v":0},{"$f":"Term","v":0}]
[null,null,{"$f":"Year3","v":2021},{"$f":"Seller_1","v":0},{"$f":"Mine_1","v":0},{"$f":"Year3_Tons","v":0},{"$f":"F7*K7/500","v":0},{"$f":"Year3_Rail","v":0},{"$f":"IF(River=\"\",\"Rail\",\"Barge\")","v":"Rail"},{"$f":"IF(River=\"\",Rail_Station,River)","v":0},{"$f":"BTU_LB","v":0},{"$f":"LBS_SO2_MMBTU","v":0},null,{"$f":"Ash","v":0},{"$f":"Term","v":0}]