{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Read Me","Revision History","Flaring Waiver","Sheet2","Test"],"not_rendered":{"charts":0,"images":3,"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":"Read Me","index":0,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Note: Please follow following three steps to raise flaring waiver form"]
[]
[]
[1,"Enable Macros, by clicking the button on top."]
[]
[null,null,null,null,null,null,null,null,null,"Click Here"]
[2]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Click Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[3,"Following Form will open up. Please complete the form to raise the waiver"]

{"sheet":"Revision History","index":1,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Version","By","Description","Date"]
[null,"Rev 1","Harshit Agrawal","This tool is created to simplify and standardize the Flaring waivers and to include the economic ALARP of the waiver decision","2016-02-15"]
[null,"Rev 1.2","Harshit Agrawal","- Updated the tool with additional inputs for Oil, Deferred Oil and Gas Price\n- Added the conclusion statement","2016-02-22"]

{"sheet":"Flaring Waiver","index":2,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":false,"merged":[[39,0,39,2],[39,3,39,8],[28,1,28,2],[29,1,29,2],[29,3,29,5],[29,6,29,8],[28,0,29,0],[28,3,28,5],[28,6,28,8],[30,4,30,8],[31,7,31,8],[41,0,41,8],[0,15,0,17],[0,5,0,8],[6,0,6,8],[4,0,4,8],[2,0,2,8],[9,5,9,6],[8,0,8,8],[7,5,7,6],[7,7,7,8],[7,0,7,1],[7,2,7,4],[33,7,33,8],[17,0,22,8],[23,0,23,8],[32,7,32,8],[24,0,27,8],[16,0,16,8],[15,0,15,8],[13,0,13,8],[9,0,9,1],[9,2,9,4],[9,7,9,8],[10,0,10,8],[11,0,11,8],[12,0,12,8],[14,0,14,1],[14,4,14,5],[14,2,14,3],[14,6,14,8],[1,11,1,16],[1,1,1,7],[3,0,3,8],[5,0,5,1],[5,2,5,8],[3,10,3,13],[4,10,4,13],[3,15,3,17],[4,15,4,17],[5,15,5,17],[20,15,20,17],[5,11,5,13],[13,11,13,13],[6,11,6,13],[14,11,14,13],[11,10,11,13],[11,15,11,17],[12,10,12,13],[12,15,12,17],[13,15,13,17],[7,10,8,17],[9,10,9,17],[15,10,16,17],[17,10,18,17],[20,10,20,13],[24,10,25,17],[41,10,41,17],[28,10,29,17],[32,10,32,13],[33,11,33,13],[33,15,33,17],[34,11,34,13],[26,10,26,17],[31,10,31,17],[32,14,32,17],[37,10,37,13],[37,14,37,17],[35,10,36,13],[35,14,36,17],[34,15,34,17],[21,15,21,17],[22,11,22,13],[22,15,22,17],[23,11,23,13],[21,10,21,13]]}
["Rev 1.2",null,null,null,null,"Revision Date: 22/03/2016",null,null,null,null,"Rev 1.2",null,null,null,null,"Revision Date: 22/03/2016"]
[null,"Operations Flaring Variance Form",null,null,null,null,null,null,null,null,null,"Endorsement and Approval"]
[]
["Subject:  Request for Waiver for Temporary Flaring",null,null,null,null,null,null,null,null,null,"Reviewed By ",null,null,null,"Name:"]
[null,null,null,null,null,null,null,null,null,null,"Production Coordinator",null,null,null,"Ref. Ind"]
["Facility Name:",null,{"$f":"Sheet2!A2","v":"Hawqa"},null,null,null,null,null,null,null,null,"Approved",null,null,"Date"]
[null,null,null,null,null,null,null,null,null,null,null,"Rejected"]
["Requestor Name:",null,{"$f":"Sheet2!B2","v":"Khamis Al Kindy"},null,null,"Requestor Ref. Indicator",null,{"$f":"Sheet2!C2","v":"OSO3"},null,null,"Comments"]
[]
["Requestor Position/ Title",null,{"$f":"Sheet2!D2","v":"Programming Team Leader"},null,null,"Date of Request",null,{"$f":"Sheet2!F2","v":"2016-03-22"},null,null,"Signature"]
[]
[null,null,null,null,null,null,null,null,null,null,"Approved By",null,null,null,"Name:"]
["Flaring Required for Period",null,null,null,null,null,null,null,null,null,"Delivery Team Leader",null,null,null,"Ref. Ind"]
[null,null,null,null,null,null,null,null,null,null,null,"Approved",null,null,"Date"]
["From Date: ",null,{"$f":"Sheet2!G2","v":"2016-04-01"},null,"To Date:",null,{"$f":"Sheet2!H2","v":"2017-04-01"},null,null,null,null,"Rejected"]
[null,null,null,null,null,null,null,null,null,null,"Comments"]
["Brief Description of the Waiver (use separte sheet in case of insufficient space below)"]
[{"$f":"Sheet2!K2","v":"This waiver is to seek approval to flare gas from Hawqa by producing closed NFA wells through mobile test unit. This will allow the production of additional oil in 2016"},null,null,null,null,null,null,null,null,null,"Signature"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Authorised By",null,null,null,"Name:"]
[null,null,null,null,null,null,null,null,null,null,"Operations Manager",null,null,null,"Ref. Ind"]
[null,null,null,null,null,null,null,null,null,null,null,"Approved",null,null,"Date"]
["Justification of the Waiver (use separte sheet in case of insufficient space below)",null,null,null,null,null,null,null,null,null,null,"Rejected"]
[{"$f":"Sheet2!L2","v":"Production test HW existing wells to deliver addtional oil production in 2016 and to test new appraisal well using the new WTU to test each HQ well for 2-3 months each"},null,null,null,null,null,null,null,null,null,"Comments"]
[]
[null,null,null,null,null,null,null,null,null,null,"Signature"]
[]
["Assumed:","Oil Cost ($/BBL)",null,"Deferred Oil Cost ($/BBL)",null,null,"Gas Cost ($/MMBTU)",null,null,null,"If identified by respective Cluster Flaring policy,  get endorsement from Operations Director and Technical Director"]
[null,{"$f":"Sheet2!N2","v":65},null,{"$f":"Sheet2!O2","v":25},null,null,{"$f":"Sheet2!P2","v":6.5}]
["Flaring Limit/ Target ","Expected flaring above Target","Expected Oil Deferment","Expected Oil revenue ","Cost/benefit associated  with avoiding any Flaring"]
[null,"(yearly avg.) ","(yearly avg.) ",null,"Oil Deferred – cost  ","Gas Conserved - Saving ","Environmental Benefit ","Total Cost of Decision to avoid Flaring (oil - gas)",null,null,"Endorsed By"]
["Sm3/day ","Sm3/day","m3/day ","1000 USD/yr","1000 USD/yr","1000 USD/yr","1000 USD/yr","1000 USD/yr",null,null,"Operations Director\nApproved\nRejected",null,null,null,"Technical Director\nApproved\nRejected"]
[{"$f":"Sheet2!E2*1000","v":0},{"$f":"Sheet2!D10*1000","v":119917.86447638605},{"$f":"Sheet2!D13","v":299.79466119096509},{"$f":"Sheet2!D15","v":44769.075000000004},{"$f":"-Sheet2!D16","v":-17218.875},{"$f":"Sheet2!D11","v":10607.160427500003},{"$f":"Sheet2!D18","v":1120.0328542094458},{"$f":"E34+F34","v":-6611.7145724999973},null,null,"Name",null,null,null,"Name"]
["Conclusion: The total revenue of",null,null,{"$f":"D34","v":44769.075000000004},"Thousand USD will be made if oil is produced.",null,null,null,null,null,"Date",null,null,null,"Date"]
["However,  In order to avoid any flaring:",null,null,null,{"$f":"-E34","v":17218.875},"thousand USD, worth of Oil will be ",null,null,null,null,"Comments",null,null,null,"Comments"]
["deferred. ",{"$f":"F34","v":10607.160427500003},"thousand USD, worth of gas will be saved.",null,null,null,{"$f":"-H34","v":6611.7145724999973},"Thousand USD"]
["will be the total cost to the company to avoid flaring.",null,null,null,null,"Avoiding the flaring will lead to ",null,null,null,null,"Signature",null,null,null,"Signature"]
["estimated Environmental Benefit worth ",null,null,null,{"$f":"G34","v":1120.0328542094458},"Thousand USD."]
["Signature of Requestor"]
[]
["Please contact MSE/22 for any queries related to the form.",null,null,null,null,null,null,null,null,null,"Please contact MSE/22 for any queries related to the form."]

{"sheet":"Sheet2","index":3,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Facility Name","Requestor Name","Requestor Ref Id","Requester Title","Flaring Limit","Request Date","Flaring From","Flaring To","Flaring daily rate","Oil daily rate","Description","Justification","Noe","Oil Price","Def Oil Price","Gas Price"]
["Hawqa","Khamis Al Kindy","OSO3","Programming Team Leader",0,"2016-03-22","2016-04-01","2017-04-01",120,300,"This waiver is to seek approval to flare gas from Hawqa by producing closed NFA wells through mobile test unit. This will allow the production of additional oil in 2016","Production test HW existing wells to deliver addtional oil production in 2016 and to test new appraisal well using the new WTU to test each HQ well for 2-3 months each","22/03/2016 15:28:42",65,25,6.5]
[]
[]
[null,"Input Daily Flaring Rate","km3/day",{"$f":"I2","v":120}]
[null,"Input Reduction in Oil rate expected (Daily Average)","m3/day",{"$f":"J2","v":300}]
[null,"Expected days of flaring","days",{"$f":"H2-G2","v":365}]
[]
["Output"]
["Flaring Data","Flaring rate (Averaged Yearly)","km3/day",{"$f":"D5*D7/365.25","v":119.91786447638604}]
[null,"Cost of Gas lost due to flaring ","1000 USD/yr",{"$f":"D10*1000*D31*D30*D26*365.25*0.000000000001*1000","v":10607.160427500003}]
[]
["Oil Data","Reduction in oil rate (Averaged Yearly)","m3/day",{"$f":"D6*D7/365.25","v":299.79466119096509}]
[null,"Reduction in oil rate (Averaged Yearly)","bbl/day",{"$f":"D13*D32","v":1885.7084188911704}]
[null,"Oil revenue Lost (not considering deferment)","1000 USD/yr",{"$f":"D14*D27*365.25*0.000001*1000","v":44769.075000000004}]
[null,"Oil revenue Lost (considering deferment)","1000 USD/yr",{"$f":"D14*D28*365.25*0.000001*1000","v":17218.875}]
[]
["Emissions Data","Environmental cost of CO2 emissions from Flaring","1000 USD/yr",{"$f":"D10*1000*D25*0.000001*D29*1000","v":1120.0328542094458}]
[]
["Cost conclusions","Total cost of the decision to avoid any flaring",{"$f":"C21","v":"1000 USD/yr"},{"$f":"D16-D11","v":6611.7145724999973}]
[null,"Money not made this year because of revnue of oil lost",{"$f":"C15","v":"1000 USD/yr"},{"$f":"D15","v":44769.075000000004}]
[]
[]
[]
["Factors","CO2 emissions (tonnes/yr) from flaring (m3/day)","(tonnes/yr )/ (m3/day)",0.93400000000000005]
[null,"Base cost of gas","$/MM Btu",{"$f":"P2","v":6.5}]
[null,"Oil Price ","$/bbl",{"$f":"N2","v":65}]
[null,"Defered Oil Price ","$/bbl",{"$f":"O2","v":25}]
[null,"Base cost of CO2","$/ton",10]
[null,"GHV for sweet gas export","Btu/Scf",1055]
[null,"1 SCM to SCF","SCF/SCM",35.314999999999998]
[null,"1 scm oil to BBL","bbl/scm",6.29]

{"sheet":"Test","index":4,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":true,"merged":[[20,0,21,0],[20,3,21,3],[20,4,20,7]]}
["Input"]
[null,"Input Daily Flaring Rate","km3/day",5]
[null,"Input Reduction in Oil rate expected (Daily Average)","m3/day",100]
[null,"Expected days of flaring","days",2]
[]
["Output"]
["Flaring Data","Flaring rate (Averaged Yearly)","km3/day",{"$f":"D2*D4/365.25","v":2.7378507871321012E-2}]
[null,"Cost of Gas lost due to flaring ","1000 USD/yr",{"$f":"D7*1000*D32*D31*D27*365.25*0.000000000001*1000","v":2.4217261249999993}]
[]
["Oil Data","Reduction in oil rate (Averaged Yearly)","m3/day",{"$f":"D3*D4/365.25","v":0.54757015742642023}]
[null,"Reduction in oil rate (Averaged Yearly)","bbl/day",{"$f":"D10*D33","v":3.4442162902121831}]
[null,"Oil revenue Lost (not considering deferment)","1000 USD/yr",{"$f":"D11*D28*365.25*0.000001*1000","v":81.769999999999982}]
[null,"Oil revenue Lost (considering deferment)","1000 USD/yr",{"$f":"D11*D29*365.25*0.000001*1000","v":31.45}]
[]
["Emissions Data","Environmental cost of CO2 emissions from Flaring","1000 USD/yr",{"$f":"D7*1000*D26*0.000001*D30*1000","v":0.25571526351813822}]
[]
["Cost conclusions","Total cost of the decision to avoid any flaring",{"$f":"C18","v":"1000 USD/yr"},{"$f":"D13-D8","v":29.028273875}]
[null,"Money not made this year because of revnue of oil lost",{"$f":"C12","v":"1000 USD/yr"},{"$f":"D12","v":81.769999999999982}]
[]
[]
["Flaring Limit/ Target ","Expected flaring above Target","Expected Oil Deferment","Expected Oil revenue ","Cost/benefit associated  with avoiding any Flaring  "]
[null,"(yearly avg.) ","(yearly avg.) ",null,"Oil Deferred – cost  ","Gas Conserved - Saving ","Environmental Benefit ","Total Cost of Decision to avoid flaring (oil - gas)"]
["Sm3/day ","Sm3/day","m3/day ","1000 USD/yr","1000 USD/yr","1000 USD/yr","1000 USD/yr","1000 USD/yr"]
[145000,{"$f":"D2","v":5},{"$f":"D3","v":100},{"$f":"D18","v":81.769999999999982},{"$f":"-D13","v":-31.45},{"$f":"D8","v":2.4217261249999993},{"$f":"D15","v":0.25571526351813822},{"$f":"E24+F24","v":-29.028273875}]
[]
["Factors","CO2 emissions (tonnes/yr) from flaring (m3/day)","(tonnes/yr )/ (m3/day)",0.93400000000000005]
[null,"Base cost of gas","$/MM Btu",6.5]
[null,"Oil Price ","$/bbl",65]
[null,"Defered Oil Price ","$/bbl",{"$f":"50*0.5","v":25}]
[null,"Base cost of CO2","$/ton",10]
[null,"GHV for sweet gas export","Btu/Scf",1055]
[null,"1 SCM to SCF","SCF/SCM",35.314999999999998]
[null,"1 scm oil to BBL","bbl/scm",6.29]