{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","BC19 Requirements","BC19 Page 1","BC19 Page 2","BC19 Page 3","Lists"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Instructions","index":0,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[[11,0,11,11],[13,0,13,11],[15,0,15,11],[16,0,16,11],[19,0,19,11]]}
["BC-19"]
["MARKETABLE GAS AND BY-PRODUCT OWNER ALLOCATIONS REPORT"]
[]
[]
["1.  When this file was downloaded from the Ministry's website, the \"Enable Macros\" option should have been selected. "]
["     This will have activated an essential macro.  If you did not select \"Enable Macros\", please start again by"]
["     re-downloading the BC-19 spreadsheet from our website, select \"Enable Macros\" and then follow the next two instructions."]
[]
["To enable the macros:  While in Excel, select Tools/Macro/Security and ensure that Security Level"]
["is not High.  This will allow the essential macro to activate."]
[]
["Before entering data, save this workbook to your desktop or hard drive and re-open in Microsoft Excel."]
["It is now ready for data entry."]
[]
["4.  Enter data in BC-19 worksheet."]
[]
["5.  When you are finished data entry, ensure that the Excel file is saved for the production month."]
[]
["6.  Click on the grey command button (\"Submit BC-19\")  at the bottom of the BC19 Page 3 worksheet."]

{"sheet":"BC19 Requirements","index":1,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,0,11,11],[13,0,13,11],[15,0,15,11],[18,0,18,11]]}
["BC-19"]
["MARKETABLE GAS AND BY-PRODUCT OWNER ALLOCATIONS REPORT"]
[]
[]
["1.  When this file was downloaded from the Ministry's website, the \"Enable Macros\" option should have been selected. "]
["     This will have activated an essential macro.  If you did not select \"Enable Macros\", please start again by"]
["     re-downloading the BC-19 spreadsheet from our website, select \"Enable Macros\" and then follow the next two instructions."]
[]
["To enable the macros:  While in Excel, select Tools/Macro/Security and ensure that Security Level"]
["is not High.  This will allow the essential macro to activate."]
[]
["Before entering data, save this workbook to your desktop or hard drive and re-open in Microsoft Excel."]
["It is now ready for data entry."]
[]
["2.  Enter data in BC-19 worksheet. Note: to add additional rows to the Natural Gas By-Product Splits table on Page 3 you have to "]
["     right click the grey column that numbers the rows, rows cannot be added by selecting a cell. If copying and pasting into "]
["     the excel sheet, paste special needs to be used otherwise unlocked cells will become locked. "]
[]
["3.  When you are finished data entry, ensure that the Excel file is saved for the production month."]
[]
["4.  Click on the grey command button (\"Submit BC-19\")  at the bottom of the BC19 Page 3 worksheet."]

{"sheet":"BC19 Page 1","index":2,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[11,0,11,8],[12,0,12,8],[21,3,21,8],[15,3,15,8],[16,3,16,8],[17,3,17,8],[18,3,18,8],[19,3,19,8],[20,3,20,8],[21,0,21,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[5,0,5,8],[7,0,7,8],[8,0,8,8],[9,0,9,8],[10,0,10,8],[31,5,31,6],[32,5,32,6],[34,5,34,6],[35,5,35,6],[31,0,31,4],[32,0,32,4],[33,0,33,4],[34,0,34,4],[35,0,35,4],[33,5,33,6],[22,3,22,8],[29,0,30,4],[29,5,29,6],[30,5,30,6],[25,6,25,8],[26,6,26,8],[6,0,6,8],[41,5,41,6],[40,0,40,4],[41,0,41,4],[36,0,36,4],[37,0,37,4],[38,0,38,4],[39,0,39,4],[40,5,40,6],[36,5,36,6],[38,5,38,6],[37,5,37,6],[39,5,39,6],[22,0,22,2],[25,0,25,5],[26,0,26,5]]}
[]
[]
[]
[]
[]
["Province of British Columbia"]
["BC-19"]
["MONTHLY NATURAL GAS PLANT AND PROCESSING STATEMENT"]
["Freedom of Information and Protection of Privacy Act (FOIPPA) - The personal information on this form is collected "]
["under the authority of the Petroleum and Natural Gas Act, and will be used for the purpose of administering the Petroleum"]
["and Natural Gas Royalty and Freehold Production Tax Regulation. Questions about the collection or use of information can be "]
["directed to the Manager, Natural Resource Revenue Operations, (telephone: Victoria at 250 952-0192 or toll-free at 1 800 667-1182). "]
["PO Box 9328 Stn Prov Govt, Victoria BC V8W 9N3 Email: Oil&GasRoyaltyQuestions@gov.bc.ca"]
[]
["HEADER AND CONTACT INFORMATION"]
["Contact Name"]
["Contact Phone"]
["Contact Email"]
["Production Year and Month"]
["Client Name"]
["Plant Location"]
["Plant Name"]
["Comments (Optional)"]
[]
[]
["Entry Date-Time"]
["Access Key"]
[]
["NATURAL GAS (103m3)"]
["Gathering System:",null,null,null,null,"BC",null,"Non-BC","Total"]
[null,null,null,null,null,"Volume",null,"Volume","Volume"]
["Receipt of Gathering System",null,null,null,null,null,null,null,{"$f":"SUM(F32:H32)","v":0}]
["Other RECEIPTS (specify here)",null,null,null,null,null,null,null,{"$f":"SUM(F33:H33)","v":0}]
["Other RECEIPTS (specify here)",null,null,null,null,null,null,null,0]
["Other RECEIPTS (specify here)",null,null,null,null,null,null,null,{"$f":"SUM(F35:H35)","v":0}]
["Other RECEIPTS (specify here)",null,null,null,null,null,null,null,0]
["Other DELIVERIES (specify here)",null,null,null,null,null,null,null,0]
["Flared Gas",null,null,null,null,null,null,null,0]
["Fuel Gas",null,null,null,null,null,null,null,0]
["Metering Difference",null,null,null,null,null,null,null,0]
["To (From) Linepack",null,null,null,null,null,null,null,0]
["Measured Volume at Plant Inlet",null,null,null,null,{"$f":"SUM(F32+F33-F34-F35-F36-F37-F38-F39-F40-F41)","v":0},null,{"$f":"SUM(H32+H33-H34-H35-H36-H37-H38-H39-H40-H41)","v":0},{"$f":"SUM(I32+I33-I34-I35-I36-I37-I38-I39-I40-I41)","v":0}]

{"sheet":"BC19 Page 2","index":3,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,0,1,1],[26,0,26,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[24,0,24,1],[25,0,25,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[36,1,39,1],[36,2,39,2],[26,2,26,3],[25,2,25,3],[24,2,24,3],[33,2,33,3],[23,2,23,3],[22,2,22,3],[21,2,21,3],[36,3,39,3],[36,4,39,4],[36,5,39,5],[36,6,39,6],[19,4,20,5],[19,2,20,3],[19,6,20,6],[31,4,31,5],[26,4,26,5],[33,4,33,5],[32,4,32,5],[32,2,32,3],[31,2,31,3],[25,4,25,5],[24,4,24,5],[27,2,27,3],[1,2,2,3],[1,4,2,5],[1,6,2,6],[35,0,35,3],[33,0,33,1],[16,4,16,5],[16,2,16,3],[30,0,30,1],[31,0,31,1],[32,0,32,1],[28,0,28,1],[29,0,29,1],[27,0,27,1],[7,0,7,1],[8,0,8,1],[2,0,2,1],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[11,4,11,5],[9,2,9,3],[8,2,8,3],[7,2,7,3],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[15,4,15,5],[15,2,15,3],[14,2,14,3],[11,2,11,3],[10,2,10,3],[10,4,10,5],[12,2,12,3],[12,4,12,5],[13,4,13,5],[13,2,13,3],[14,4,14,5],[30,4,30,5],[29,4,29,5],[30,2,30,3],[29,2,29,3],[28,2,28,3],[23,4,23,5],[22,4,22,5],[21,4,21,5],[28,4,28,5],[27,4,27,5]]}
[]
[null,null,"BC Volume ",null,"Non-BC Volume",null,"Total Volume"]
["Plant Facility:"]
["Plant Flared (Metered)",null,null,null,null,null,{"$f":"SUM(C4:F4)","v":0}]
["Plant Flared (Estimated)",null,null,null,null,null,{"$f":"SUM(C5:F5)","v":0}]
["Plant Fuel",null,null,null,null,null,0]
["Field Fuel from Plant",null,null,null,null,null,0]
["Plant Fuel Gas Buy Back",null,null,null,null,null,0]
["Plant Metering Difference",null,null,null,null,null,0]
["Residual Gas to Storage",null,null,null,null,null,0]
["Acid Gas",null,null,null,null,null,0]
["Natural Gas Liquids",null,null,null,null,null,0]
["Other RECEIPTS ","(specify here)",null,null,null,null,0]
["Other RECEIPTS ","(specify here)",null,null,null,null,0]
["Other DISPOSITIONS","(specify here)",null,null,null,null,0]
["Other DISPOSITIONS ","(specify here)",null,null,null,null,0]
["Gas Available for Sale",null,{"$f":"SUM(ROUND('BC19 Page 1'!F42-C4-C5-C6-C7-C8-C9-C10-C11-C12+C13+C14-C15-C16,1))","v":0},null,{"$f":"SUM(ROUND('BC19 Page 1'!H42-E4-E5-E6-E7-E8-E9-E10-E11-E12+E13+E14-E15-E16,1))","v":0},null,{"$f":"SUM(ROUND('BC19 Page 1'!I42-G4-G5-G6-G7-G8-G9-G10-G11-G12+G13+G14-G15-G16,1))","v":0}]
[]
["Details of Shipments (pipeline):"]
[null,null,"BC Volume ",null,"Non-BC Volume",null,"Total Volume"]
[]
["Alliance",null,null,null,null,null,{"$f":"SUM(C22:F22)","v":0}]
["Spectra",null,null,null,null,null,0]
["Trans-Canada",null,null,null,null,null,0]
["Storage",null,null,null,null,null,0]
["Oth PPL specify",null,null,null,null,null,0]
["Oth PPL specify",null,null,null,null,null,0]
["Oth PPL specify",null,null,null,null,null,0]
["Oth PPL specify",null,null,null,null,null,0]
["Oth PPL specify",null,null,null,null,null,0]
["Oth PPL specify",null,null,null,null,null,0]
["Total Marketable Gas for Sale",null,{"$f":"SUM(ROUND(C22:D31,1))","v":0},null,{"$f":"SUM(ROUND(E22:F31,1))","v":0},null,{"$f":"SUM(ROUND(G22:G31,1))","v":0}]
["Check Gas:  Available vs. Shipment",null,{"$f":"IF(C17=VALUE(C32),\"0.0\",\"MUST EQUAL 0\")","v":"0.0"},null,{"$f":"IF(E17=VALUE(E32),\"0.0\",\"MUST EQUAL 0\")","v":"0.0"},null,{"$f":"IF(G17=VALUE(G32),\"0.0\",\"MUST EQUAL 0\")","v":"0.0"}]
["BC Energy in GJ"]
[]
["BC Natural Gas By-Products m3:   ***PLANT BY-PRODUCT only (no field condensates)***"]
[null,"Ethane Volume","Propane Volume","Butane Volume","(NGL) Pentanes* Volume","(Plant Inlet Separator) Condensate Volume","Sulphur Tonnes      "]
[]
[]
["Supply"]
["Opening Inventory",null,null,null,null,null,0]
["Monthly Production",null,null,null,null,null,0]
["From Other Sources (specify here)",null,null,null,null,null,0]
["Total By-Product Supply",{"$f":"SUM(ROUND(B41:B43,1))","v":0},{"$f":"SUM(ROUND(C41:C43,1))","v":0},{"$f":"SUM(ROUND(D41:D43,1))","v":0},{"$f":"SUM(ROUND(E41:E43,1))","v":0},{"$f":"SUM(ROUND(F41:F43,1))","v":0},{"$f":"SUM(ROUND(G41:G43,1))","v":0}]
["Disposition"]
["Losses and Adjustments",null,null,null,null,null,0]
["To Other Sources (specify here)",null,null,null,null,null,0]
["Closing Inventory",null,null,null,null,null,0]
["Shipments",null,null,null,null,null,0]
["Total By-Product Disposition",{"$f":"SUM(ROUND(B46:B49,1))","v":0},{"$f":"SUM(ROUND(C46:C49,1))","v":0},{"$f":"SUM(ROUND(D46:D49,1))","v":0},{"$f":"SUM(ROUND(E46:E49,1))","v":0},{"$f":"SUM(ROUND(F46:F49,1))","v":0},{"$f":"SUM(ROUND(G46:G49,1))","v":0}]
["***Check By-Prod:  Supply vs Disposition",{"$f":"IF(B44=VALUE(B50),\"0.0\",\"MUST EQUAL 0\")","v":"0.0"},{"$f":"IF(C44=VALUE(C50),\"0.0\",\"MUST EQUAL 0\")","v":"0.0"},{"$f":"IF(D44=VALUE(D50),\"0.0\",\"MUST EQUAL 0\")","v":"0.0"},"0.0","0.0",{"$f":"IF(G44-G50=0,\"0.0\",\"MUST EQUAL 0\")","v":"0.0"}]

{"sheet":"BC19 Page 3","index":4,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[[39,0,39,5],[40,0,40,5],[41,0,41,5],[1,0,1,5]]}
[]
["Natural Gas and By-Product Splits *** BC Production Only ***"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NGL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pentanes *"]
["Row","Owner","Owner","Shipper","Shipper","Pipeline","Raw Gas","Mrk","Mrk","Ethane","Propane","Butane","& Inlet","Sulphur"]
["No","Code","Name","Code","Name","Name","103m3","Gas","Gas Energy","m3","m3","m3","Separator","Tonnes"]
[null,null,null,null,null,null,null,"103m3","GJ",null,null,null,"Condensate"]
[null,null,null,null,null,null,null,null,null,null,null,null,"m3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Totals",null,null,null,null,null,{"$f":"SUM(ROUND(G9:G39,1))","v":0},{"$f":"SUM(ROUND(H9:H39,1))","v":0},{"$f":"SUM(ROUND(I9:I39,1))","v":0},{"$f":"SUM(ROUND(J9:J39,1))","v":0},{"$f":"SUM(ROUND(K9:K39,1))","v":0},{"$f":"SUM(ROUND(L9:L39,1))","v":0},{"$f":"SUM(ROUND(M9:M39,1))","v":0},{"$f":"SUM(ROUND(N9:N39,1))","v":0}]
["Comparison",null,null,null,null,null,{"$f":"ROUND('BC19 Page 1'!F42,1)","v":0},{"$f":"ROUND('BC19 Page 2'!C32, 1)","v":0},{"$f":"ROUND('BC19 Page 2'!C34,1)","v":0},{"$f":"ROUND('BC19 Page 2'!B49,1)","v":0},{"$f":"ROUND('BC19 Page 2'!C49, 1)","v":0},{"$f":"ROUND('BC19 Page 2'!D49, 1)","v":0},{"$f":"ROUND('BC19 Page 2'!E49+'BC19 Page 2'!F49,1)","v":0},{"$f":"ROUND('BC19 Page 2'!G49,1)","v":0}]
["*** Check ***",null,null,null,null,null,{"$f":"IF(AND(G41>=G40-1,G41<=G40+1),\"0.0\",\"MUST EQUAL 0\")","v":"0.0"},{"$f":"IF(AND(H41>=H40-1,H41<=H40+1),\"0.0\",\"MUST EQUAL 0\")","v":"0.0"},{"$f":"IF(AND(I41>=I40-10,I41<=I40+10),\"0.0\",\"MUST EQUAL 0\")","v":"0.0"},"0.0","0.0","0.0","0.0","0.0"]

{"sheet":"Lists","index":5,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
["British Columbia"]
["Alberta"]