{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Info","Settings","Drilling Power","Bulk Data Drilling","Fracking Inputs","Fracking Outputs","Pipe Spec"],"not_rendered":{"charts":0,"images":0,"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":"Info","index":0,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["GHGfrack v1.0"]
[]
["A model for computing greenhouse gas (GHG) emissions from hydraulic fracturing operations"]
[]
["Author:",null,"Kourosh Vafi",null,"Department of Energy Resources Engineering, Stanford University",null,null,null,null,null,null,null,"vafi@stanford.edu"]
["Supervisor: ",null,"Adam R. Brandt",null,"Department of Energy Resources Engineering, Stanford University",null,null,null,null,null,null,null,"abrandt@stanford.edu"]
[]
["Release date: ",null,"September 2015"]
[]
["Acknowledgements:",null,"Funding for GHGfrack development has been provided by:"]
[null,null,"California Air Resources Board, as part of agreement number 13-408"]
[]
["Copyright statement:",null,"Copyright © 2015 The Board of Trustees of the Leland Stanford Junior University"]
[null,null,"All rights reserved."]
[]
[null,null,"The GHGfrack, source code, binary files, and operating manuals are being provided free of charge.  Software may be downloaded, modified and redistributed freely under the following terms and conditions: "]
[null,null,"Redistributions of any of the following: Software's source code, executables, and any other materials provided must"]
[null,null,"retain the above copyright notice;"]
[null,null,"require that the source and executable with any modifications be made publicly available under these same terms and conditions and;"]
[null,null,"be sent to: Adam Brandt, Department of Energy Resources Engineering, Stanford University:  abrandt@stanford.edu."]
[null,null,"Include this entire Agreement with any redistribution."]
[null,null,"Neither the name of Stanford University nor the names of the contributors may be used to endorse or promote products derived from this Software without specific prior written permission."]
[null,null,"Software is being provided “AS IS” and With All Faults. Users acknowledge that Stanford or contributors will not provide any maintenance or support for Software."]
[null,null,"Stanford makes no representations and extends no warranties of any kind, either express or implied."]
[null,null,"Stanford disclaims any express or implied warranty of merchantability, or fitness for a particular purpose, of non-infringement, or arising out of any course of dealing."]
[null,null,"Stanford is not liable for any special, consequential, lost profits, expectation, punitive or other indirect damages in connection with any claim arising out of or related to the use of Software whether grounded in tort (including negligence), strict liability, contract, or otherwise; and,"]
[null,null,"Users will indemnify, hold harmless and defend Stanford against any claim of any kind arising out of or related to the exercise of any rights in this Agreement."]

{"sheet":"Settings","index":1,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Program settings"]
[]
["Parameter",null,null,null,null,null,"User","Default",null,"Sources and notes"]
["Bingham plastic turbulent annular flow",null,null,null,null,null,2,2]
[null,"1 = Approximation with Newtonian turbulent flow  ",null,null,null,null,null,null,null,"1: Azar & Samuel"]
[null,"2 = Empirical equation                                         ",null,null,null,null,null,null,null,"2: Petroleum Engineering Hanbook Vol. II"]
[]
[]
["Bingham plastic turbulent pipe flow",null,null,null,null,null,2,2]
[null,"1 = Approximation with Newtonian turbulent flow    ",null,null,null,null,null,null,null,"1: Azar & Samuel"]
[null,"2 = Empirical equation                                           ",null,null,null,null,null,null,null,"2: Petroleum Engineering Hanbook Vol. II"]
[]
[]
["Mud flow rate",null,null,null,null,null,1,1,null,"For power law fluids , mud flow rate must be set as manual."]
[null,"1 = Automatic"]
[null,"2 = Manual"]

{"sheet":"Drilling Power","index":2,"n_rows":194,"n_cols":13,"rows_kept":194,"cut":false,"hidden":false,"merged":[]}
["Rotational Energy via Rotary Table: Input Data"]
[null,"User","Example","Units","Notes"]
["Is rotary table active?","Yes","Yes",null,"Yes/No"]
["User defined torque value","Yes","Yes",null,"Yes/No","No for automatic mode: automatic estimation based on Azar and Samuel "]
["Length of drill string at top of the section",0,50,"ft",null,"method pages 23 and 24"]
["Length of drill string at bottom of the section",50,4250,"ft"]
["Rate of drill penetration (ROP)",0.22,1,"ft/min"]
["Rotationl speed",20,60,"rpm"]
["Inclination angle ",0,0,"degree","Vertical =0 , Horizontal = 90,  Directional > 0 "]
[]
["Engine Efficiency",45,45,"%"]
[]
["Torque factors: ",1.625,{"$f":"(1.5+1.75)/2","v":1.625},null,"for shallow holes less than 10,000 ft with light drill string = 1.5 to 1.75",null,null,null,null,null,null,null,"Azar and Samuel page 24"]
["(Automatic mode) ",1.875,{"$f":"AVERAGE(1.75,2)","v":1.875},null,"for 10,000 ft - 15,000 ft wells with average conditions = 1.75 to 2.0"]
[null,2.125,{"$f":"AVERAGE(2,2.25)","v":2.125},null,"for deep holes with heavy drill string = 2.0 to 2.25"]
[null,2.625,{"$f":"AVERAGE(2.25,3)","v":2.625},null,"for high torque torque = 2.25 to 3.0"]
[]
["Torque values:",38500,8500,"ft-lbf","vertical",null,"less than 15,000 ft-lbf",null,null,null,null,null,"Azar and Samuel page 23"]
["(Applied torque is known)",15000,15800,"ft-lbf","horizontal",null,"may exceed 80,000 ft-lbf"]
[null,15000,13700,"ft-lbf","inclined"]
[]
["Rotaional Energy via Rotary Table: Results"]
[]
["Drilling time",3.7878787878787881,"h"]
["Drilling power segment 1",325.62962962962962,"hp",null,"Drilling string length less than 10,000 ft or directional well "]
["Drilling power segment 2","NA","hp",null,"Drilling string length 10,000 to 15,000 ft"]
["Drilling power segment 3","NA","hp",null,"Drilling string length more than 15,000 ft"]
["Drilling energy required ",3.1384201313606064,"MMBtu"]
["Max HP",{"$f":"MAX(B25:B27)","v":325.62962962962962},"hp"]
[]
[]
["Mud Circulation: Input Data"]
[]
[null,"User","Example"]
["Mud Characteristics:"]
[]
["Fluid type:",2,2]
["(1) Newtonian  "]
["(2) Bingham plastic       "]
["(3) Power law             ","."]
[]
["Mud viscosity:"]
["Dynamic viscosity (Newtonian fluid)",null,1,"cp"]
["Plasic viscosity",25,25,"cp"]
["Consistency index K (Power law fluid)",6.6000000000000003E-2,6.6000000000000003E-2,"equivalent cp"]
["Power law index  n",0.28999999999999998,0.28999999999999998]
["Yield stress",15,15,"lbs/100 ft^2"]
[]
["Mud density ",12,12,"lbs/gal"]
[]
["Drill cuttings characteristics: "]
[]
["Drill cuttings sieve diameter ",0.5,0.5,"in",null,null,"1/8 to 5/8 in. in normal drilling and larger when sloughing "]
["Drill cuttings density",25.036213355328613,25.036213355328613,"lbs/gal"]
[]
["Geometry:"]
[]
["Length of drill collar",700,700,"ft"]
["Hole diameter",24,12.25,"inch"]
["Drill pipe OD",6.625,6.625,"inch"]
["Drill pipe ID",5.9649999999999999,5.9649999999999999,"inch"]
["Drill collar OD",18.48,9.5,"inch"]
["Drill collar ID",8.6855999999999991,4.4332750000000001,"inch"]
["Number of segments of the drilling section",100,100,null,null,null,null,null," "]
["Drill pipe roughness",8.0000000000000007E-5,8.0000000000000007E-5,"inch"]
[]
[]
[]
["Pump:"]
["Mud pump efficiency",65,65,"%"]
[]
["Drill bit:"]
["Number of nozzles",5,3]
["Size of nozzles",0.5,{"$f":"11/32","v":0.34375},"in",null,null,"Azar and Samuel 2007 page 93 : Example 3-2 "]
["nozzle discharge coefficient Cd",0.95,0.95,null,null,null,"Azar and Samuel 2007 page 93 "]
[]
["Is downhole motor in place?","Yes","Yes","Yes/No"]
[null,1]
[]
[]
[]
["Mud flow rate & downhole motor: "]
[]
["Pressure drop across downhole motor",700,500,"psi"]
["Downhole motor rpm",100,100,"rpm"]
["Mud flow rate","NA",500,"gpm"]
["Other sources of pressure drop",0,0,"psi"]
[]
["Modified cuttings transport ratio ",2.21,2.21,null,null,null,"2 to 2.22 for vertical wells  Azar and Samuel page 173"]
[]
[]
["Mud Circulation: Results"]
[]
["Average velocity  in annulus (hole - drill pipe)",2.3481575885820045,"ft/s","seg #","time(hr)","DP_friction","DP","BHP","E(MMBtu)"]
["Average velocity  in annulus (hole - collar)",5.3284950243502376,"ft/s",1,3.787878787878788E-2,3.7787982360837163E-2,11412.503842280754,31316.635135783497,3.0182989879762063]
["Average velocity in drill pipe",35.116179020308543,"ft/s",2,7.575757575757576E-2,7.5575964721674327E-2,11412.541630263115,31316.738828406294,3.0183089818767992]
["Average velocity in drill collar",16.562599516131645,"ft/s",3,0.11363636363636365,0.11336394708251149,11412.579418245476,31316.842521029095,3.0183189757773921]
["Mud flow rate",3057.1611354484116,"gpm",4,0.15151515151515152,0.15115192944334865,11412.617206227837,31316.946213651892,3.0183289696779854]
["Re in pipe",55556.840363149196,null,5,0.18939393939393939,0.18893991180418582,11412.654994210197,31317.049906274689,3.0183389635785782]
["Re in collar",20686.468301585963,null,6,0.22727272727272727,0.22672789416502298,11412.692782192558,31317.153598897494,3.018348957479172]
["Re  hole - pipe annulus",639.25791623132773,null,7,0.26515151515151514,0.26451587652586017,11412.730570174919,31317.257291520291,3.0183589513797648]
["Re  hole - collar annulus",2602.6254795828509,null,8,0.30303030303030304,0.30230385888669731,11412.76835815728,31317.360984143092,3.0183689452803577]
["Pressure drop in drill pipe ",0.33640896976051621,"psi/ft",9,0.34090909090909094,0.34009184124753444,11412.806146139641,31317.464676765881,3.0183789391809501]
["Pressure drop in drill collar",5.8746477543588985E-2,"psi/ft",10,0.37878787878787884,0.37787982360837163,11412.843934122002,31317.568369388682,3.018388933081543]
["Pressure drop in annulus ( hole - drill pipe )",4.511001094235868E-3,"psi/ft",11,0.41666666666666674,0.41566780596920883,11412.881722104363,31317.672062011487,3.0183989269821363]
["Pressure drop in annulus ( hole - drill collar) ",1.6829487178085342E-2,"psi/ft",12,0.45454545454545464,0.45345578833004596,11412.919510086724,31317.775754634284,3.0184089208827292]
["Pressure drop across the downhole motor",700,"psi",13,0.49242424242424254,0.4912437706908831,11412.957298069085,31317.879447257088,3.0184189147833234]
["Pressure drop across the bit nozzles",10712.466054298393,"psi",14,0.53030303030303039,0.52903175305172034,11412.995086051445,31317.983139879878,3.0184289086839153]
["Pressure drop due to friction (max)",3.7787982360837162,"psi",15,0.56818181818181823,0.56681973541255748,11413.032874033805,31318.086832502679,3.0184389025845082]
["Total pressure drop (max)",11416.244852534477,"psi",16,0.60606060606060608,0.60460771777339462,11413.070662016165,31318.190525125476,3.0184488964851011]
["Mud pump BHP (max)",31326.900705440614,"hp",17,0.64393939393939392,0.64239570013423175,11413.108449998526,31318.294217748273,3.0184588903856944]
["Drilling time",3.7878787878787881,"h",18,0.68181818181818177,0.68018368249506889,11413.146237980887,31318.397910371077,3.0184688842862877]
["Energy consumption by mud pump",301.87936860555624,"MMBtu",19,0.71969696969696961,0.71797166485590613,11413.184025963248,31318.501602993871,3.0184788781868801]
[null,null,null,20,0.75757575757575746,0.75575964721674327,11413.221813945609,31318.605295616675,3.0184888720874734]
[null,null,null,21,0.7954545454545453,0.7935476295775804,11413.25960192797,31318.708988239472,3.0184988659880663]
[null,null,null,22,0.83333333333333315,0.83133561193841765,11413.297389910331,31318.812680862276,3.0185088598886596]
[null,null,null,23,0.87121212121212099,0.86912359429925479,11413.335177892692,31318.916373485074,3.0185188537892533]
[null,null,null,24,0.90909090909090884,0.90691157666009192,11413.372965875053,31319.020066107874,3.0185288476898462]
[null,null,null,25,0.94696969696969668,0.94469955902092906,11413.410753857414,31319.123758730671,3.0185388415904391]
[null,null,null,26,0.98484848484848453,0.98248754138176619,11413.448541839774,31319.227451353468,3.0185488354910319]
[null,null,null,27,1.0227272727272725,1.0202755237426033,11413.486329822135,31319.331143976273,3.0185588293916252]
[null,null,null,28,1.0606060606060603,1.0580635061034407,11413.524117804496,31319.434836599066,3.0185688232922177]
[null,null,null,29,1.0984848484848482,1.0958514884642778,11413.561905786857,31319.538529221871,3.018578817192811]
[null,null,null,30,1.136363636363636,1.133639470825115,11413.599693769218,31319.642221844668,3.0185888110934038]
[null,null,null,31,1.1742424242424239,1.1714274531859521,11413.637481751579,31319.745914467472,3.0185988049939976]
[null,null,null,32,1.2121212121212117,1.2092154355467892,11413.67526973394,31319.849607090269,3.0186087988945909]
[null,null,null,33,1.2499999999999996,1.2470034179076264,11413.713057716301,31319.95329971307,3.0186187927951837]
[null,null,null,34,1.2878787878787874,1.2847914002684635,11413.750845698662,31320.056992335867,3.0186287866957766]
[null,null,null,35,1.3257575757575752,1.3225793826293006,11413.788633681022,31320.160684958671,3.0186387805963699]
[null,null,null,36,1.3636363636363631,1.3603673649901378,11413.826421663383,31320.264377581469,3.0186487744969628]
[null,null,null,37,1.4015151515151509,1.3981553473509751,11413.864209645744,31320.368070204262,3.0186587683975552]
[null,null,null,38,1.4393939393939388,1.4359433297118123,11413.901997628105,31320.471762827059,3.0186687622981481]
[null,null,null,39,1.4772727272727266,1.4737313120726494,11413.939785610466,31320.57545544986,3.0186787561987409]
[null,null,null,40,1.5151515151515145,1.5115192944334865,11413.977573592827,31320.679148072661,3.0186887500993347]
[null,null,null,41,1.5530303030303023,1.5493072767943237,11414.015361575188,31320.782840695461,3.018698743999928]
[null,null,null,42,1.5909090909090902,1.5870952591551608,11414.053149557549,31320.886533318266,3.0187087379005213]
[null,null,null,43,1.628787878787878,1.6248832415159979,11414.09093753991,31320.990225941056,3.0187187318011137]
[null,null,null,44,1.6666666666666659,1.6626712238768353,11414.128725522271,31321.093918563856,3.0187287257017066]
[null,null,null,45,1.7045454545454537,1.7004592062376724,11414.166513504631,31321.197611186661,3.0187387196022999]
[null,null,null,46,1.7424242424242415,1.7382471885985096,11414.204301486992,31321.301303809458,3.0187487135028928]
[null,null,null,47,1.7803030303030294,1.7760351709593467,11414.242089469353,31321.404996432262,3.0187587074034865]
[null,null,null,48,1.8181818181818172,1.8138231533201838,11414.279877451712,31321.508689055048,3.018768701304078]
[null,null,null,49,1.8560606060606051,1.851611135681021,11414.317665434073,31321.612381677853,3.0187786952046713]
[null,null,null,50,1.8939393939393929,1.8893991180418581,11414.355453416434,31321.71607430065,3.0187886891052642]
[null,null,null,51,1.9318181818181808,1.9271871004026953,11414.393241398795,31321.819766923447,3.018798683005858]
[null,null,null,52,1.9696969696969686,1.9649750827635324,11414.431029381156,31321.923459546251,3.0188086769064513]
[null,null,null,53,2.0075757575757565,2.0027630651243697,11414.468817363517,31322.027152169045,3.0188186708070437]
[null,null,null,54,2.0454545454545445,2.0405510474852067,11414.506605345878,31322.130844791849,3.018828664707637]
[null,null,null,55,2.0833333333333326,2.078339029846044,11414.544393328239,31322.234537414646,3.0188386586082299]
[null,null,null,56,2.1212121212121207,2.1161270122068814,11414.582181310599,31322.338230037451,3.0188486525088232]
[null,null,null,57,2.1590909090909087,2.1539149945677183,11414.61996929296,31322.441922660248,3.0188586464094165]
[null,null,null,58,2.1969696969696968,2.1917029769285556,11414.657757275321,31322.545615283048,3.0188686403100093]
[null,null,null,59,2.2348484848484849,2.2294909592893926,11414.695545257682,31322.649307905845,3.0188786342106022]
[null,null,null,60,2.2727272727272729,2.2672789416502299,11414.733333240043,31322.753000528643,3.0188886281111951]
[null,null,null,61,2.310606060606061,2.3050669240110668,11414.771121222404,31322.856693151447,3.0188986220117888]
[null,null,null,62,2.3484848484848491,2.3428549063719042,11414.808909204765,31322.96038577424,3.0189086159123812]
[null,null,null,63,2.3863636363636371,2.3806428887327411,11414.846697187126,31323.064078397045,3.0189186098129746]
[null,null,null,64,2.4242424242424252,2.4184308710935785,11414.884485169487,31323.167771019842,3.0189286037135674]
[null,null,null,65,2.4621212121212133,2.4562188534544158,11414.922273151848,31323.271463642639,3.0189385976141603]
[null,null,null,66,2.5000000000000013,2.4940068358152527,11414.960061134208,31323.37515626544,3.0189485915147531]
[null,null,null,67,2.5378787878787894,2.5317948181760901,11414.997849116569,31323.478848888233,3.0189585854153456]
[null,null,null,68,2.5757575757575775,2.569582800536927,11415.03563709893,31323.582541511034,3.0189685793159393]
[null,null,null,69,2.6136363636363655,2.6073707828977644,11415.073425081291,31323.686234133835,3.0189785732165322]
[null,null,null,70,2.6515151515151536,2.6451587652586013,11415.111213063652,31323.789926756639,3.0189885671171259]
[null,null,null,71,2.6893939393939417,2.6829467476194386,11415.149001046013,31323.893619379436,3.0189985610177188]
[null,null,null,72,2.7272727272727297,2.7207347299802755,11415.186789028374,31323.997312002233,3.0190085549183117]
[null,null,null,73,2.7651515151515178,2.7585227123411129,11415.224577010735,31324.101004625034,3.0190185488189045]
[null,null,null,74,2.8030303030303059,2.7963106947019503,11415.262364993096,31324.204697247835,3.0190285427194983]
[null,null,null,75,2.8409090909090939,2.8340986770627872,11415.300152975457,31324.308389870635,3.0190385366200911]
[null,null,null,76,2.878787878787882,2.8718866594236245,11415.337940957816,31324.412082493429,3.0190485305206831]
[null,null,null,77,2.9166666666666701,2.9096746417844614,11415.375728940176,31324.515775116226,3.019058524421276]
[null,null,null,78,2.9545454545454581,2.9474626241452988,11415.413516922537,31324.619467739023,3.0190685183218693]
[null,null,null,79,2.9924242424242462,2.9852506065061357,11415.451304904898,31324.723160361827,3.0190785122224626]
[null,null,null,80,3.0303030303030343,3.0230385888669731,11415.489092887259,31324.826852984625,3.0190885061230559]
[null,null,null,81,3.0681818181818223,3.0608265712278104,11415.52688086962,31324.930545607429,3.0190985000236492]
[null,null,null,82,3.1060606060606104,3.0986145535886473,11415.564668851981,31325.034238230222,3.0191084939242416]
[null,null,null,83,3.1439393939393985,3.1364025359494847,11415.602456834342,31325.137930853027,3.0191184878248349]
[null,null,null,84,3.1818181818181865,3.1741905183103216,11415.640244816703,31325.241623475824,3.0191284817254278]
[null,null,null,85,3.2196969696969746,3.211978500671159,11415.678032799064,31325.345316098621,3.0191384756260211]
[null,null,null,86,3.2575757575757627,3.2497664830319959,11415.715820781425,31325.449008721425,3.0191484695266144]
[null,null,null,87,3.2954545454545507,3.2875544653928332,11415.753608763785,31325.552701344219,3.0191584634272068]
[null,null,null,88,3.3333333333333388,3.3253424477536706,11415.791396746146,31325.656393967023,3.0191684573278001]
[null,null,null,89,3.3712121212121269,3.3631304301145075,11415.829184728507,31325.76008658982,3.0191784512283935]
[null,null,null,90,3.4090909090909149,3.4009184124753449,11415.866972710868,31325.863779212625,3.0191884451289868]
[null,null,null,91,3.446969696969703,3.4387063948361818,11415.904760693229,31325.967471835422,3.0191984390295801]
[null,null,null,92,3.4848484848484911,3.4764943771970191,11415.94254867559,31326.071164458222,3.0192084329301729]
[null,null,null,93,3.5227272727272791,3.5142823595578561,11415.980336657951,31326.17485708102,3.0192184268307658]
[null,null,null,94,3.5606060606060672,3.5520703419186934,11416.018124640312,31326.278549703813,3.0192284207313578]
[null,null,null,95,3.5984848484848553,3.5898583242795303,11416.055912622673,31326.382242326617,3.0192384146319515]
[null,null,null,96,3.6363636363636433,3.6276463066403677,11416.093700605034,31326.485934949415,3.0192484085325444]
[null,null,null,97,3.6742424242424314,3.665434289001205,11416.131488587394,31326.589627572212,3.0192584024331373]
[null,null,null,98,3.7121212121212195,3.703222271362042,11416.169276569755,31326.693320195012,3.0192683963337301]
[null,null,null,99,3.7500000000000075,3.7410102537228793,11416.207064552116,31326.797012817813,3.0192783902343239]
[null,null,null,100,3.7878787878787956,3.7787982360837162,11416.244852534477,31326.900705440614,3.0192883841349167]

{"sheet":"Bulk Data Drilling","index":3,"n_rows":116,"n_cols":13,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
["Rotation Energy via Rotary Table: Input Data"]
["Number of sections",5,"Example",1,2,3,4,5,6,7,8,9,10]
["Is rotary table active?","Yes/No","Yes","Yes","Yes","Yes","Yes","Yes"]
["User defined torque value?","Yes/No","Yes","Yes","Yes","Yes","Yes","Yes"]
["Length of drill string at top of the section","ft",0,50,4250,8500,10855,0]
["Length of drill string at bottom of the section","ft",10000,4250,8500,10855,14500,50]
["Rate of penetration of drill bit (ROP)","ft/min",1,2.5,2.5,1.25,1.25,0.22]
["Rotational speed","rpm",60,60,60,60,60,20]
["Inclination angle","degree",0,0,0,45,90,0]
[]
["Mechanical power transmission efficiency","%",45,45,45,45,45,45]
[]
["Torque factor : ",null,{"$f":"(1.5+1.75)/2","v":1.625},1.625,1.625,1.625,1.625,1.625]
[null,null,{"$f":"AVERAGE(1.75,2)","v":1.875},1.875,1.875,1.875,1.875,1.875]
[null,null,{"$f":"AVERAGE(2,2.25)","v":2.125},2.125,2.125,2.125,2.125,2.125]
[null,null,{"$f":"AVERAGE(2.25,3)","v":2.625},2.625,2.625,2.625,2.625,2.625]
["Torque value:"]
["Vertical well","ft-lbf",9000,13000,13000,13000,13000,38500]
["Horizontal well","ft-lbf",11000,15000,15000,15000,15000,15000]
["Inclined well","ft-lbf",11000,15000,15000,15000,15000,15000]
[]
["Rotaion Energy via  Rotary Table: Results"]
[null,null,null,1,2,3,4,5,6,7,8,9,10]
["Drilling time","h",null,28,28.333333333333332,31.4,48.6,3.7878787878787881]
["Drilling power segment 1","hp",null,329.85858585858585,329.85858585858585,380.60606060606062,380.60606060606062,325.62962962962962]
["Drilling power segment 2","hp",null,"NA","NA","NA","NA","NA"]
["Drilling power segment 3","hp",null,"NA","NA","NA","NA","NA"]
["Drilling energy required ","MMBtu",null,23.500489943628217,23.780257681052362,30.408600998485962,47.065541672815861,3.1384201313606064]
["Drilling power max","hp",null,329.85858585858585,329.85858585858585,380.60606060606062,380.60606060606062,325.62962962962962]
["Fuel efficiency","Btu/hp.h",null,7093.5937939393934,7093.5937939393934,7071.777454545454,7071.777454545454,7095.4118222222214]
["Diesel fuel used","gallon",null,510.05620001478695,516.12829763401055,657.96050336426083,1018.3719892835376,68.133937382282753]
["GHG emissions","tonne CO2",null,5.1686794701008347,5.2302113685544152,6.6674749680083769,10.319722402713603,0.69043858961959714]
[]
["Mud Circulation: Input Data"]
[]
[null,null,"Example",1,2,3,4,5,6,7,8,9,10]
["Fluid type:",null,2,2,2,2,2,2]
["(1) Newtonian  "]
["(2) Bingham plastic       "]
["(3) Power law             ",null,null,null,null,null,null,"."]
[]
["Mud viscosity:"]
["Dynamic viscosity (Newtonian fluids)","cp"]
["Plastic viscosity","cp",25,25,25,25,25,25]
["Consistency index K (power law fluid)",null,0.95,6.6000000000000003E-2,6.6000000000000003E-2,6.6000000000000003E-2,6.6000000000000003E-2,6.6000000000000003E-2]
["Power law index  n",null,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998]
["Yield stress (Yield point)","lbf/100 ft^2",15,15,15,15,15,15]
[]
["Mud density ","lbm/gal",12,12,12,12,12,12]
[]
[]
[]
["Drill cuttings sieve diameter ","in",1,0.5,0.5,0.5,0.5,0.5]
["Drill cuttings density","lbm/gal",{"$f":"0.0022046226218/ 0.00026417205236*3","v":25.036213355328613},25.036213355328613,25.036213355328613,25.036213355328613,25.036213355328613,25.036213355328613]
[]
[]
[]
["Length of drill collar","ft",1000,700,700,700,700,700]
["Hole diameter","inch",{"$f":"8+7/8","v":8.875},12.25,8.75,8.75,8.75,24]
["Drill pipe OD","inch",6.625,6.625,5,5,5,6.625]
["Drill pipe ID","inch",5.9649999999999999,5.9649999999999999,4,4,4,5.9649999999999999]
["Drill collar OD","inch",9.5,9.5,6.75,6.75,6.75,18.48]
["Drill collar ID","inch",4.4332750000000001,4.4332750000000001,3.25,3.25,3.25,8.6855999999999991]
["Number of segments of the drilling section",null,100,100,100,100,100,100]
["Drill pipe roughness","inch",8.0000000000000007E-5,8.0000000000000007E-5,8.0000000000000007E-5,8.0000000000000007E-5,8.0000000000000007E-5,8.0000000000000007E-5]
[]
[]
[]
[]
["Mud pump efficiency","%",65,65,65,65,65,65]
[]
["Drill bit:"]
["Number of nozzles",null,5,5,5,5,5,5]
["Size of nozzles","in",0.5,0.5,0.5,0.5,0.5,0.5]
["Nozzle discharge coefficient Cd",null,0.95,0.95,0.95,0.95,0.95,0.95]
[]
["Is downhole motor active?",null,"Yes","Yes","Yes","Yes","Yes","Yes"]
["Downhole motor type:",null,1,1,1,1,1,1]
["(1) Turbine        "]
["(2) Positive displacement"]
["(3) Electrical"]
[]
[]
["Pressure drop across downhole motor","psi",500,500,500,700,700,700]
["Downhole motor rpm","rpm",100,100,100,100,100,100]
["Mud flow rate","gpm",null,"NA","NA","NA","NA","NA"]
["Other sources of pressure drop","psi",0,0,0,0,0,0]
[]
["Modified cuttings transport ratio",null,2.21,2.21,2.21,2.21,2.21,2.21]
[]
[]
["Mud Circulation: Results"]
[null,null,null,1,2,3,4,5,6,7,8,9,10]
["Average velocity  in annulus (hole-drill pipe)","ft/s",null,2.3481575885820045,2.3481575885820045,2.3481575885820045,4.9839882659035766,2.3481575885820045]
["Average velocity  in annulus (hole-collar)","ft/s",null,4.1681637446224462,3.9057056664922452,3.9057056664922452,8.2898998374404247,5.3284950243502376]
["Average velocity in drill pipe","ft/s",null,7.0067372322124939,7.5673047288287227,7.5673047288287227,16.061680935040815,35.116179020308543]
["Average velocity in drill collar","ft/s",null,12.684909795034711,11.46289947088848,11.46289947088848,24.330120232961239,16.562599516131645]
["Mud flow rate","gpm",null,609.99588651804299,296.24524290059475,296.24524290059475,628.78352868042862,3057.1611354484116]
["Re in pipe",null,null,4226.1080678884891,4329.3403942640807,4329.3403942640807,14336.558324395231,55556.840363149196]
["Re in collar",null,null,10446.188453505438,7775.9527206821604,7775.9527206821604,22956.28966445339,20686.468301585963]
["Re  hole-pipe ",null,null,586.45089361279099,552.69438144813626,552.69438144813626,2085.6404188619413,639.25791623132773]
["Re  hole-collar",null,null,1398.4412550494342,1119.4970982186721,1119.4970982186721,3496.0589721074039,2602.6254795828509]
["Pressure drop in drill pipe ","psi/ft",null,2.3764827621019523E-2,4.636507922267008E-2,4.636507922267008E-2,0.15980879206810839,0.33640896976051621]
["Pressure drop in drill collar","psi/ft",null,9.4299041665386885E-2,0.11281610313496564,0.11281610313496564,0.37916195397001878,5.8746477543588985E-2]
["Pressure drop in annulus (hole-drill pipe)","psi/ft",null,1.5188667724311707E-2,2.417450237970134E-2,2.417450237970134E-2,2.8860423583828579E-2,4.511001094235868E-3]
["Pressure drop in annulus (hole-drill collar) ","psi/ft",null,1.6626697279701685E-2,2.6943476740430659E-2,2.6943476740430659E-2,0.13786322472091417,1.6829487178085342E-2]
["Pressure drop across the downhole motor","psi",null,500,500,700,700,700]
["Pressure drop across the bit nozzles","psi",null,426.48779928701583,100.59017628608666,100.59017628608666,453.16369794077275,10712.466054298393]
["Pressure drop due to friction (max)","psi",null,215.93292573748784,648.0404424112744,814.16115708485927,2965.5528010803828,3.7787982360837162]
["Total pressure drop (max)","psi",null,1142.4207250245036,1248.6306186973611,1614.751333370946,4118.7164990211559,11416.244852534477]
["Mud pump BHP (max)","hp",null,625.50214786635627,332.01766531650628,429.37115248050912,2324.5499451474943,31326.900705440614]
["Drilling time","h",null,28,28.333333333333332,31.4,48.6,3.7878787878787881]
["Energy consumption by mud pump","MMBtu",null,41.272104764397639,21.091168000584798,32.557762450935847,263.69469780682851,301.87936860555624]
["Fuel efficiency","Btu/hp.h",null,6966.4966266322526,7092.6656056804331,7050.8133415486291,6236.0759785810915,6113.1137822275896]
["Diesel fuel used","gallon",null,879.72279892544759,457.70421809791105,702.37422617061884,5031.3855035391434,5646.387910718925]
["GHG emissions","tonne CO2",null,8.9147140453420324,4.6381680987166574,7.1175436021183378,50.985791286434306,57.217948283958457]

{"sheet":"Fracking Inputs","index":4,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Fracking Inputs"]
[]
[null,null,null,null,"User","Example","Unit"]
["Fluid density",null,null,null,9.0368211772637146,9.0368211772637146,"lbm/gal"]
["Viscosity",null,null,null,1,1,"cp"]
["Fracture gradient",null,null,null,0.9,0.9,"psi/ft"]
[]
["Pipe roughness",null,null,null,8.0000000000000007E-5,8.0000000000000007E-5,"in"]
["g (gravitational acceleration)",null,null,null,32.174048999999997,32.174048999999997,"ft/s2"]
[]
["Length of the fracking stage",null,null,null,300,300,"ft"]
["Number of segments",null,null,null,100,100,"NA"]
[]
["Pump efficiency",null,null,null,65,65,"%"]
["Volume fluid injected",null,null,null,4871500.6303320564,4871500.6303320564,"gal"]
["Injection time",null,null,null,48,48,"hr"]
[]
["Number of sections",null,null,null,3,null,"Last section is the horizontal section"]
[]
["Table 1. Geometry"]
[null,null,null,null," Section No.","Net length(ft)","Inclination angle          ( degree)","pipe ID (in)"]
[null,null,null,null,1,8500,0,5]
[null,null,null,null,2,2355,45,5]
[null,null,null,null,3,3645,90,5]
[null,null,null,null,4]
[null,null,null,null,5]
[null,null,null,null,6]
[null,null,null,null,7]
[null,null,null,null,8]
[null,null,null,null,9]
[null,null,null,null,10]

{"sheet":"Fracking Outputs","index":5,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Fracking Results"]
[null,null,null,null,null,null,null,"Units"]
["Flow rate",null,null,null,null,null,1691.4932744208529,"gpm"]
["Pressure drop due friction in non-horizontal section",null,null,null,null,null,1705.97820775644,"psi"]
["Pressure drop due friction in horizontal section",null,null,null,null,null,"See Table 2","psi"]
["Hydrostatic pressure ",null,null,null,null,null,4772.3332337079837,"psi"]
["Pressure drop due hydraulic fracturing",null,null,null,null,null,9149.3094364998797,"psi"]
["Pump discharge pressure",null,null,null,null,null,"See Table 2","psi"]
["Pump BHP",null,null,null,null,null,9711.5334859098275,"hp","Average value in case of multi-stage fracturing"]
["Pump energy consumption",null,null,null,null,null,1186.0968209172895,"MMBtu"]
["Fuel efficiency",null,null,null,null,null,6191.652938601841,"Btu LHV Diesel/hp.hr"]
["Fuel consumption",null,null,null,null,null,22469.921001786071,"gal diesel"]
["Emissions",null,null,null,null,null,227.70004437423216,"tonne CO2"]
[]
[]
["Table 1:","Non-horizontal section",null,null,null,null,null,null,"Table 2: Horizontal Section"]
["Section No.","Net vertical distance (ft)","Pipe cs area (ft2)","Velocity (ft/s)","Re","Press drop (psi/ft)",null,null,"Fracking stage or segments","Horizontal section flow length(ft)","Velocity (ft/s)","Re","Press drop (psi/ft)","BHP ","Press drop (psi)","Pump DP (psi)"]
[1,8500,0.13628472222222224,27.652862050166718,1159508.0179552101,0.15716059030460064,null,null,1,3645,27.652862050166718,1159508.0179552101,0.15716059030460064,10105.240993747546,572.85035166026933,6655.8047622086051]
[2,1665.8993738887555,0.13628472222222224,27.652862050166718,1159508.0179552101,0.15716059030460064,null,null,2,3345,27.652862050166718,1159508.0179552101,0.15716059030460064,10033.657810504321,525.70217456888918,6608.6565851172245]
[3,null,null,null,null,null,null,null,3,3045,27.652862050166718,1159508.0179552101,0.15716059030460064,9962.0746272611032,478.55399747750897,6561.5084080258448]
[4,null,null,null,null,null,null,null,4,2745,27.652862050166718,1159508.0179552101,0.15716059030460064,9890.49144401788,431.40582038612877,6514.3602309344642]
[5,null,null,null,null,null,null,null,5,2445,27.652862050166718,1159508.0179552101,0.15716059030460064,9818.9082607746586,384.25764329474856,6467.2120538430845]
[6,null,null,null,null,null,null,null,6,2145,27.652862050166718,1159508.0179552101,0.15716059030460064,9747.3250775314373,337.10946620336836,6420.0638767517039]
[7,null,null,null,null,null,null,null,7,1845,27.652862050166718,1159508.0179552101,0.15716059030460064,9675.7418942882159,289.96128911198815,6372.9156996603233]
[8,null,null,null,null,null,null,null,8,1545,27.652862050166718,1159508.0179552101,0.15716059030460064,9604.1587110449946,242.81311202060797,6325.7675225689436]
[9,null,null,null,null,null,null,null,9,1245,27.652862050166718,1159508.0179552101,0.15716059030460064,9532.5755278017732,195.6649349292278,6278.619345477563]
[10,null,null,null,null,null,null,null,10,945,27.652862050166718,1159508.0179552101,0.15716059030460064,9460.9923445585518,148.51675783784759,6231.4711683861833]
[null,null,null,null,null,null,null,null,11,645,27.652862050166718,1159508.0179552101,0.15716059030460064,9389.4091613153305,101.36858074646742,6184.3229912948027]
[null,null,null,null,null,null,null,null,12,345,27.652862050166718,1159508.0179552101,0.15716059030460064,9317.8259780721091,54.220403655087217,6137.174814203423]

{"sheet":"Pipe Spec","index":6,"n_rows":53,"n_cols":15,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Pipe specifications"]
[null,"No.",1,2,3,4,5,6,7,8,9,10,11,12,13]
[]
[null,"Table 1: Drill collar dimensions  API-RP-7G"]
[null,"Weight ( lbf/ft)"]
["No.","OD/ID(in)",1,1.25,1.5,{"$f":"1+3/4","v":1.75},2,2.25,2.5,{"$f":"2+13/16","v":2.8125},3,3.25,3.5,3.75,4]
[1,{"$f":"2+7/8","v":2.875},19,18,16,0,0,0,0,0,0,0,0,0,0]
[2,3,21,20,18,0,0,0,0,0,0,0,0,0,0]
[3,{"$f":"3+1/8","v":3.125},22,22,20,0,0,0,0,0,0,0,0,0,0]
[4,{"$f":"3+1/4","v":3.25},26,24,22,0,0,0,0,0,0,0,0,0,0]
[5,{"$f":"3+1/2","v":3.5},30,29,27,0,0,0,0,0,0,0,0,0,0]
[6,{"$f":"3+3/4","v":3.75},35,33,32,0,0,0,0,0,0,0,0,0,0]
[7,4,40,39,37,35,32,29,0,0,0,0,0,0,0]
[8,{"$f":"4+1/8","v":4.125},43,41,39,37,35,32,0,0,0,0,0,0,0]
[9,{"$f":"4+1/4","v":4.25},46,44,42,40,38,35,0,0,0,0,0,0,0]
[10,{"$f":"4+1/2","v":4.5},51,50,48,46,43,41,0,0,0,0,0,0,0]
[11,{"$f":"4+3/4","v":4.75},0,0,54,52,50,47,44,0,0,0,0,0,0]
[12,5,0,0,61,59,56,53,50,0,0,0,0,0,0]
[13,{"$f":"5+1/4","v":5.25},0,0,68,65,63,60,57,0,0,0,0,0,0]
[14,{"$f":"5+1/2","v":5.5},0,0,75,73,70,67,64,60,0,0,0,0,0]
[15,{"$f":"5+3/4","v":5.75},0,0,82,80,78,75,72,67,64,60,0,0,0]
[16,6,0,0,90,88,85,83,79,75,72,68,0,0,0]
[17,{"$f":"6+1/4","v":6.25},0,0,98,96,94,94,88,83,80,76,72,0,0]
[18,{"$f":"6+1/2","v":6.5},0,0,107,105,102,99,96,91,89,85,80,0,0]
[19,{"$f":"6+3/4","v":6.75},0,0,116,114,111,108,105,100,98,93,89,0,0]
[20,7,0,0,125,123,120,117,114,110,107,103,98,93,84]
[21,{"$f":"7+1/4","v":7.25},0,0,134,132,130,127,124,119,116,112,108,103,93]
[22,{"$f":"7+1/2","v":7.5},0,0,144,142,139,137,133,129,126,122,117,113,102]
[23,{"$f":"7+3/4","v":7.75},0,0,154,152,150,147,144,139,136,132,128,123,112]
[24,8,0,0,165,163,160,157,154,150,147,143,138,133,122]
[25,{"$f":"8+1/4","v":8.25},0,0,176,174,171,168,165,160,158,154,149,144,133]
[26,{"$f":"8+1/2","v":8.5},0,0,187,185,182,179,176,172,169,165,160,155,150]
[27,9,0,0,210,208,206,203,200,195,192,188,184,179,174]
[28,{"$f":"9+1/2","v":9.5},0,0,234,232,230,227,224,220,216,212,209,206,198]
[29,{"$f":"9+3/4","v":9.75},0,0,248,245,243,240,237,232,229,225,221,216,211]
[30,10,0,0,261,259,257,254,251,246,243,239,235,230,225]
[31,11,0,0,317,315,313,310,307,302,299,295,291,286,281]
[32,12,0,0,379,377,374,371,368,364,361,357,352,347,342]
[]
[]
[]
[null,"Table 2: Parameters for automatic case"]
[null,"Drill collar OD = a * hole size"]
[null,"Drill collar ID = b * collar OD"]
[null,"Drill pipe OD = c * collar OD"]
[null,"Drill pipe ID = d * pipe OD"]
[]
[]
[null,null,"a","b","c","d"]
[null,"default",0.77,0.47,0.67,0.82]
[null,"user",0.77,0.47,0.67,0.82]
[]
[null,"Automatic?",null,0,"Set = 1 for Automatic 0 for Manual"]