{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["3 Sections","4 Sections"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"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":"3 Sections","index":0,"n_rows":49,"n_cols":35,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,13,1,13],[0,12,1,12],[7,8,8,8],[0,16,0,24],[0,0,0,1],[6,2,6,5],[1,2,1,5],[0,2,0,5],[0,14,1,14],[6,0,6,1],[1,0,1,1],[4,8,4,14],[0,9,0,11],[1,9,1,11],[3,8,3,13],[2,8,2,13],[15,0,15,1],[3,3,4,3],[5,8,5,14],[5,0,5,5],[14,0,14,5],[9,1,11,1],[7,9,8,9],[7,2,7,3],[9,5,11,5],[11,8,12,8],[9,0,11,0],[9,9,10,9],[11,9,12,9],[9,8,10,8],[12,2,12,3],[9,4,11,4],[18,0,20,0],[33,3,34,4],[35,3,35,4],[42,3,42,4],[43,3,43,4],[24,2,24,5],[21,2,21,3],[23,0,23,5],[33,2,34,2],[27,5,29,5],[24,0,24,1],[22,2,22,3],[43,0,46,0],[18,4,20,4],[27,0,29,0],[18,1,20,1],[43,6,47,8],[47,3,47,4],[40,3,40,4],[41,3,41,4],[29,9,30,9],[35,6,38,8],[44,3,44,4],[45,3,45,4],[46,3,46,4],[36,3,36,4],[37,3,37,4],[39,3,39,4],[32,0,32,14],[23,8,24,8],[13,2,13,3],[19,9,20,9],[15,9,16,9],[17,9,18,9],[21,9,22,9],[21,8,22,8],[15,2,15,5],[13,8,14,8],[19,8,20,8],[18,5,20,5],[17,8,18,8],[23,9,24,9],[16,2,16,3],[13,9,14,9],[15,8,16,8],[25,9,26,9],[39,0,42,0],[25,2,25,3],[35,0,38,0],[27,1,29,1],[27,4,29,4],[39,6,42,8],[33,6,34,8],[33,0,34,1],[30,2,30,3],[33,5,34,5],[27,8,28,8],[29,8,30,8],[27,9,28,9],[25,8,26,8],[38,3,38,4]]}
["Operator",null,null,null,null,null,null,1,"CD#",null,null,null,null,"NAD  ",27,null,"Procedure"]
["Well",null,null,null,null,null,null,null,"API",null,null,null,null,null,null,null,"1) Enter in yellow cells",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,"Has 1002A been filed?",null,null,null,null,null,"No",null,"2) Answer questions about 1002A status",null,null,"yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,83]
[null,null,null,"SHL","X",null,null,null,"Does data on 1002A match with location Exception?",null,null,null,null,null,"NA",null,"3) Enter X, Y coordinate for surface location",null,null,"No"]
[null,null,null,null,"Y",null,null,null,"If not, Please correct. Both documents should match ",null,null,null,null,null,null,null,"4) Enter X, Y coordinate for each corner",null,null,"NA"]
["Step I- Staking plat / Entry point",null,null,null,null,null,null,null,"Step II- Survey data / Interpolation ",null,null,null,null,null,null,null,"5) After entering X, Y coordinates, verify if the length of each section line is within acceptable unit size"]
["Surface",null,null,null,null,null,null,null,"Depth","Name","Survey","MD","TVD","N+/S-","E+/W-",null,"6) Enter the depth(md) for each point of interest in the first section"]
["X",null,{"$f":"F8-B8","v":0},null,"X",null,null,null,{"$f":"D9","v":0},null,"Above",null,null,null,null,null,"7) Repeat  steps 4, 5 for other sections"]
["Y",null,"Entry 1, md",null,"Y",null,null,null,null,null,"Below",null,null,null,null,null,"8) Use directional survey. Enter the survey data in \"above/below\" for each entry point to interpolate"]
[null,{"$f":"B9-B14","v":0},"Entry 2, md",null,{"$f":"F9-F14","v":0},null,null,null,{"$f":"D10","v":0},null,"Above",null,null,null,null,null,"9) When we have exact survey data for entry point (md), adjust the \"above/below\"depth to +/- 1 ft"]
[null,null,"Entry 3, md",null,null,null,null,null,null,null,"Below",null,null,null,null,null,"10) Check the results, calculated automatically "]
[null,null,"Entry 4, md",null,null,null,null,null,{"$f":"D11","v":0},null,"Above",null,null,null,null,null,"11) Review any of sample calculations at the bottom of worksheet to complete the form"]
["X",null,{"$f":"F13-B13","v":0},null,"X",null,null,null,null,null,"Below",null,null,null,null,null,"12) For any further questions, please call (405) 521-4456"]
["Y",null,null,null,"Y",null,null,null,{"$f":"D12","v":0},null,"Above"]
[null,null,null,null,null,null,null,null,null,null,"Below",null,null,null,null,null,"Comments:"]
["Middle 1",null,null,null,null,null,null,null,{"$f":"D18","v":0},null,"Above"]
["X",null,{"$f":"F17-B17","v":0},null,"X",null,null,null,null,null,"Below",null,null,null,null,null,"1) OCC-Technical Department requires Grid North shall be used to maintain consistency and accuracy "]
["Y",null,"Entry 1, md",null,"Y",null,null,null,{"$f":"D19","v":0},null,"Above"]
[null,{"$f":"B18-B23","v":0},"Entry 2, md",null,{"$f":"F18-F23","v":0},null,null,null,null,null,"Below",null,null,null,null,null,"2) Using True North could cause inconsistencies and delay processing of the final order"]
[null,null,"Entry 3, md",null,null,null,null,null,{"$f":"D20","v":0},null,"Above"]
[null,null,"Entry 4, md",null,null,null,null,null,null,null,"Below",null,null,null,null,null,"3) Caution: Using Spreadsheet might have a slight variance in SHL versus the Plat. "]
["X",null,{"$f":"F22-B22","v":0},null,"X",null,null,null,{"$f":"D21","v":0},null,"Above",null,null,null,null,null,"     Well Permit must Match Order"]
["Y",null,null,null,"Y",null,null,null,null,null,"Below"]
[null,null,null,null,null,null,null,null,{"$f":"D27","v":0},null,"Above"]
["Bottom",null,null,null,null,null,null,null,null,null,"Below"]
["X",null,{"$f":"F26-B26","v":0},null,"X",null,null,null,{"$f":"D28","v":0},null,"Above"]
["Y",null,"Entry 1, md",null,"Y",null,null,null,null,null,"Below"]
[null,{"$f":"B27-B32","v":0},"Entry 2, md",null,{"$f":"F27-F32","v":0},null,null,null,{"$f":"D29","v":0},null,"Above"]
[null,null,"Entry 3, md",null,null,null,null,null,null,null,"Below"]
[null,null,"Entry 4, md",null,null,null,null,null,{"$f":"D30","v":0},null,"Above"]
["X",null,{"$f":"F31-B31","v":0},null,"X",null,null,null,null,null,"Below"]
["Y",null,"BHL",null,"Y",null,null,null,{"$f":"D32","v":0},"BHL/TD","Final"]
["Step III- Calculation / Results"]
["Section / MD",null,"TVD","N+/S-",null,"E+/W-","SHL",null,null,"X","Y","FNL","FSL","FWL","FEL"]
[null,null,null,null,null,null,null,null,null,{"$f":"F4","v":0},{"$f":"F5","v":0},{"$f":"IFERROR(ABS(($F$9-$B$9)*J35-($F$8-$B$8)*K35+$F$8*$B$9-$F$9*$B$8)/((($F$9-$B$9)^2+($F$8-$B$8)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$14-$B$14)*J35-($F$13-$B$13)*K35+$F$13*$B$14-$F$14*$B$13)/((($F$14-$B$14)^2+($F$13-$B$13)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($B$9-$B$14)*J35-($B$8-$B$13)*K35+$B$8*$B$14-$B$9*$B$13)/((($B$9-$B$14)^2+($B$8-$B$13)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$9-$F$14)*J35-($F$8-$F$13)*K35+$F$8*$F$14-$F$9*$F$13)/((($F$9-$F$14)^2+($F$8-$F$13)^2)^0.5),\" \")","v":" "}]
["Surface",{"$f":"D9","v":0},{"$f":"IFERROR(M8+(I8-L8)*(M9-M8)/(L9-L8),\" \")","v":" "},{"$f":"IFERROR(N8+(I8-L8)*(N9-N8)/(L9-L8),\" \")","v":" "},null,{"$f":"IFERROR(O8+(I8-L8)*(O9-O8)/(L9-L8),\" \")","v":" "},{"$f":"C7","v":0},null,null,{"$f":"IFERROR($F$4+F36,\" \")","v":" "},{"$f":"IFERROR($F$5+D36,\" \")","v":" "},{"$f":"IFERROR(ABS(($F$9-$B$9)*J36-($F$8-$B$8)*K36+$F$8*$B$9-$F$9*$B$8)/((($F$9-$B$9)^2+($F$8-$B$8)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$14-$B$14)*J36-($F$13-$B$13)*K36+$F$13*$B$14-$F$14*$B$13)/((($F$14-$B$14)^2+($F$13-$B$13)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($B$9-$B$14)*J36-($B$8-$B$13)*K36+$B$8*$B$14-$B$9*$B$13)/((($B$9-$B$14)^2+($B$8-$B$13)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$9-$F$14)*J36-($F$8-$F$13)*K36+$F$8*$F$14-$F$9*$F$13)/((($F$9-$F$14)^2+($F$8-$F$13)^2)^0.5),\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"D10","v":0},{"$f":"IFERROR(M10+(I10-L10)*(M11-M10)/(L11-L10),\" \")","v":" "},{"$f":"IFERROR(N10+(I10-L10)*(N11-N10)/(L11-L10),\" \")","v":" "},null,{"$f":"IFERROR(O10+(I10-L10)*(O11-O10)/(L11-L10),\" \")","v":" "},null,null,null," "," ",{"$f":"IFERROR(ABS(($F$9-$B$9)*J37-($F$8-$B$8)*K37+$F$8*$B$9-$F$9*$B$8)/((($F$9-$B$9)^2+($F$8-$B$8)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$14-$B$14)*J37-($F$13-$B$13)*K37+$F$13*$B$14-$F$14*$B$13)/((($F$14-$B$14)^2+($F$13-$B$13)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($B$9-$B$14)*J37-($B$8-$B$13)*K37+$B$8*$B$14-$B$9*$B$13)/((($B$9-$B$14)^2+($B$8-$B$13)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$9-$F$14)*J37-($F$8-$F$13)*K37+$F$8*$F$14-$F$9*$F$13)/((($F$9-$F$14)^2+($F$8-$F$13)^2)^0.5),\" \")","v":" "}]
[null,{"$f":"D11","v":0},{"$f":"IFERROR(M12+(I12-L12)*(M13-M12)/(L13-L12),\" \")","v":" "},{"$f":"IFERROR(N12+(I12-L12)*(N13-N12)/(L13-L12),\" \")","v":" "},null,{"$f":"IFERROR(O12+(I12-L12)*(O13-O12)/(L13-L12),\" \")","v":" "},null,null,null," "," ",{"$f":"IFERROR(ABS(($F$9-$B$9)*J38-($F$8-$B$8)*K38+$F$8*$B$9-$F$9*$B$8)/((($F$9-$B$9)^2+($F$8-$B$8)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$14-$B$14)*J38-($F$13-$B$13)*K38+$F$13*$B$14-$F$14*$B$13)/((($F$14-$B$14)^2+($F$13-$B$13)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($B$9-$B$14)*J38-($B$8-$B$13)*K38+$B$8*$B$14-$B$9*$B$13)/((($B$9-$B$14)^2+($B$8-$B$13)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$9-$F$14)*J38-($F$8-$F$13)*K38+$F$8*$F$14-$F$9*$F$13)/((($F$9-$F$14)^2+($F$8-$F$13)^2)^0.5),\" \")","v":" "}]
[null,{"$f":"D12","v":0},{"$f":"IFERROR(M14+(I14-L14)*(M15-M14)/(L15-L14),\" \")","v":" "},{"$f":"IFERROR(N14+(I14-L14)*(N15-N14)/(L15-L14),\" \")","v":" "},null,{"$f":"IFERROR(O14+(I14-L14)*(O15-O14)/(L15-L14),\" \")","v":" "},null,null,null," "," ",{"$f":"IFERROR(ABS(($F$9-$B$9)*J39-($F$8-$B$8)*K39+$F$8*$B$9-$F$9*$B$8)/((($F$9-$B$9)^2+($F$8-$B$8)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$14-$B$14)*J39-($F$13-$B$13)*K39+$F$13*$B$14-$F$14*$B$13)/((($F$14-$B$14)^2+($F$13-$B$13)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($B$9-$B$14)*J39-($B$8-$B$13)*K39+$B$8*$B$14-$B$9*$B$13)/((($B$9-$B$14)^2+($B$8-$B$13)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$9-$F$14)*J39-($F$8-$F$13)*K39+$F$8*$F$14-$F$9*$F$13)/((($F$9-$F$14)^2+($F$8-$F$13)^2)^0.5),\" \")","v":" "}]
["Middle 1",{"$f":"D18","v":0},{"$f":"IFERROR(M16+(I16-L16)*(M17-M16)/(L17-L16),\" \")","v":" "},{"$f":"IFERROR(N16+(I16-L16)*(N17-N16)/(L17-L16),\" \")","v":" "},null,{"$f":"IFERROR(O16+(I16-L16)*(O17-O16)/(L17-L16),\" \")","v":" "},{"$f":"C16","v":0},null,null," "," ",{"$f":"IFERROR(ABS(($F$18-$B$18)*J40-($F$17-$B$17)*K40+$F$17*$B$18-$F$18*$B$17)/((($F$18-$B$18)^2+($F$17-$B$17)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$23-$B$23)*J40-($F$22-$B$22)*K40+$F$22*$B$23-$F$23*$B$22)/((($F$23-$B$23)^2+($F$22-$B$22)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($B$18-$B$23)*J40-($B$17-$B$22)*K40+$B$17*$B$23-$B$18*$B$22)/((($B$18-$B$23)^2+($B$17-$B$22)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$18-$F$23)*J40-($F$17-$F$22)*K40+$F$17*$F$23-$F$18*$F$22)/((($F$18-$F$23)^2+($F$17-$F$22)^2)^0.5),\" \")","v":" "}]
[null,{"$f":"D19","v":0},{"$f":"IFERROR(M18+(I18-L18)*(M19-M18)/(L19-L18),\" \")","v":" "},{"$f":"IFERROR(N18+(I18-L18)*(N19-N18)/(L19-L18),\" \")","v":" "},null,{"$f":"IFERROR(O18+(I18-L18)*(O19-O18)/(L19-L18),\" \")","v":" "},null,null,null," "," ",{"$f":"IFERROR(ABS(($F$18-$B$18)*J41-($F$17-$B$17)*K41+$F$17*$B$18-$F$18*$B$17)/((($F$18-$B$18)^2+($F$17-$B$17)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$23-$B$23)*J41-($F$22-$B$22)*K41+$F$22*$B$23-$F$23*$B$22)/((($F$23-$B$23)^2+($F$22-$B$22)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($B$18-$B$23)*J41-($B$17-$B$22)*K41+$B$17*$B$23-$B$18*$B$22)/((($B$18-$B$23)^2+($B$17-$B$22)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$18-$F$23)*J41-($F$17-$F$22)*K41+$F$17*$F$23-$F$18*$F$22)/((($F$18-$F$23)^2+($F$17-$F$22)^2)^0.5),\" \")","v":" "}]
[null,{"$f":"D20","v":0},{"$f":"IFERROR(M20+(I20-L20)*(M21-M20)/(L21-L20),\" \")","v":" "},{"$f":"IFERROR(N20+(I20-L20)*(N21-N20)/(L21-L20),\" \")","v":" "},null,{"$f":"IFERROR(O20+(I20-L20)*(O21-O20)/(L21-L20),\" \")","v":" "},null,null,null," "," ",{"$f":"IFERROR(ABS(($F$18-$B$18)*J42-($F$17-$B$17)*K42+$F$17*$B$18-$F$18*$B$17)/((($F$18-$B$18)^2+($F$17-$B$17)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$23-$B$23)*J42-($F$22-$B$22)*K42+$F$22*$B$23-$F$23*$B$22)/((($F$23-$B$23)^2+($F$22-$B$22)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($B$18-$B$23)*J42-($B$17-$B$22)*K42+$B$17*$B$23-$B$18*$B$22)/((($B$18-$B$23)^2+($B$17-$B$22)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$18-$F$23)*J42-($F$17-$F$22)*K42+$F$17*$F$23-$F$18*$F$22)/((($F$18-$F$23)^2+($F$17-$F$22)^2)^0.5),\" \")","v":" "}]
[null,{"$f":"D21","v":0},{"$f":"IFERROR(M22+(I22-L22)*(M23-M22)/(L23-L22),\" \")","v":" "},{"$f":"IFERROR(N22+(I22-L22)*(N23-N22)/(L23-L22),\" \")","v":" "},null,{"$f":"IFERROR(O22+(I22-L22)*(O23-O22)/(L23-L22),\" \")","v":" "},null,null,null," "," ",{"$f":"IFERROR(ABS(($F$18-$B$18)*J43-($F$17-$B$17)*K43+$F$17*$B$18-$F$18*$B$17)/((($F$18-$B$18)^2+($F$17-$B$17)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$23-$B$23)*J43-($F$22-$B$22)*K43+$F$22*$B$23-$F$23*$B$22)/((($F$23-$B$23)^2+($F$22-$B$22)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($B$18-$B$23)*J43-($B$17-$B$22)*K43+$B$17*$B$23-$B$18*$B$22)/((($B$18-$B$23)^2+($B$17-$B$22)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$18-$F$23)*J43-($F$17-$F$22)*K43+$F$17*$F$23-$F$18*$F$22)/((($F$18-$F$23)^2+($F$17-$F$22)^2)^0.5),\" \")","v":" "}]
["Bottom",{"$f":"D27","v":0},{"$f":"IFERROR(M24+(I24-L24)*(M25-M24)/(L25-L24),\" \")","v":" "},{"$f":"IFERROR(N24+(I24-L24)*(N25-N24)/(L25-L24),\" \")","v":" "},null,{"$f":"IFERROR(O24+(I24-L24)*(O25-O24)/(L25-L24),\" \")","v":" "},{"$f":"C25","v":0},null,null," "," ",{"$f":"IFERROR(ABS(($F$27-$B$27)*J44-($F$26-$B$26)*K44+$F$26*$B$27-$F$27*$B$26)/((($F$27-$B$27)^2+($F$26-$B$26)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$32-$B$32)*J44-($F$31-$B$31)*K44+$F$31*$B$32-$F$32*$B$31)/((($F$32-$B$32)^2+($F$31-$B$31)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($B$27-$B$32)*J44-($B$26-$B$31)*K44+$B$26*$B$32-$B$27*$B$31)/((($B$27-$B$32)^2+($B$26-$B$31)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$27-$F$32)*J44-($F$26-$F$31)*K44+$F$26*$F$32-$F$27*$F$31)/((($F$27-$F$32)^2+($F$26-$F$31)^2)^0.5),\" \")","v":" "}]
[null,{"$f":"D28","v":0},{"$f":"IFERROR(M26+(I26-L26)*(M27-M26)/(L27-L26),\" \")","v":" "},{"$f":"IFERROR(N26+(I26-L26)*(N27-N26)/(L27-L26),\" \")","v":" "},null,{"$f":"IFERROR(O26+(I26-L26)*(O27-O26)/(L27-L26),\" \")","v":" "},null,null,null," "," ",{"$f":"IFERROR(ABS(($F$27-$B$27)*J45-($F$26-$B$26)*K45+$F$26*$B$27-$F$27*$B$26)/((($F$27-$B$27)^2+($F$26-$B$26)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$32-$B$32)*J45-($F$31-$B$31)*K45+$F$31*$B$32-$F$32*$B$31)/((($F$32-$B$32)^2+($F$31-$B$31)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($B$27-$B$32)*J45-($B$26-$B$31)*K45+$B$26*$B$32-$B$27*$B$31)/((($B$27-$B$32)^2+($B$26-$B$31)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$27-$F$32)*J45-($F$26-$F$31)*K45+$F$26*$F$32-$F$27*$F$31)/((($F$27-$F$32)^2+($F$26-$F$31)^2)^0.5),\" \")","v":" "}]
[null,{"$f":"D29","v":0},{"$f":"IFERROR(M28+(I28-L28)*(M29-M28)/(L29-L28),\" \")","v":" "},{"$f":"IFERROR(N28+(I28-L28)*(N29-N28)/(L29-L28),\" \")","v":" "},null,{"$f":"IFERROR(O28+(I28-L28)*(O29-O28)/(L29-L28),\" \")","v":" "},null,null,null," "," ",{"$f":"IFERROR(ABS(($F$27-$B$27)*J46-($F$26-$B$26)*K46+$F$26*$B$27-$F$27*$B$26)/((($F$27-$B$27)^2+($F$26-$B$26)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$32-$B$32)*J46-($F$31-$B$31)*K46+$F$31*$B$32-$F$32*$B$31)/((($F$32-$B$32)^2+($F$31-$B$31)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($B$27-$B$32)*J46-($B$26-$B$31)*K46+$B$26*$B$32-$B$27*$B$31)/((($B$27-$B$32)^2+($B$26-$B$31)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$27-$F$32)*J46-($F$26-$F$31)*K46+$F$26*$F$32-$F$27*$F$31)/((($F$27-$F$32)^2+($F$26-$F$31)^2)^0.5),\" \")","v":" "}]
[null,{"$f":"D30","v":0},{"$f":"IFERROR(M30+(I30-L30)*(M31-M30)/(L31-L30),\" \")","v":" "},{"$f":"IFERROR(N30+(I30-L30)*(N31-N30)/(L31-L30),\" \")","v":" "},null,{"$f":"IFERROR(O30+(I30-L30)*(O31-O30)/(L31-L30),\" \")","v":" "},null,null,null," "," ",{"$f":"IFERROR(ABS(($F$27-$B$27)*J47-($F$26-$B$26)*K47+$F$26*$B$27-$F$27*$B$26)/((($F$27-$B$27)^2+($F$26-$B$26)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$32-$B$32)*J47-($F$31-$B$31)*K47+$F$31*$B$32-$F$32*$B$31)/((($F$32-$B$32)^2+($F$31-$B$31)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($B$27-$B$32)*J47-($B$26-$B$31)*K47+$B$26*$B$32-$B$27*$B$31)/((($B$27-$B$32)^2+($B$26-$B$31)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$27-$F$32)*J47-($F$26-$F$31)*K47+$F$26*$F$32-$F$27*$F$31)/((($F$27-$F$32)^2+($F$26-$F$31)^2)^0.5),\" \")","v":" "}]
["TD",{"$f":"L32","v":0},{"$f":"M32","v":0},{"$f":"N32","v":0},null,{"$f":"O32","v":0},null,null,null,{"$f":"IF($F$4+F48=J35,\" \", $F$4+F48)","v":" "},{"$f":"IF($F$5+D48=K35,\" \", $F$5+D48)","v":" "},{"$f":"IFERROR(ABS(($F$27-$B$27)*J48-($F$26-$B$26)*K48+$F$26*$B$27-$F$27*$B$26)/((($F$27-$B$27)^2+($F$26-$B$26)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$32-$B$32)*J48-($F$31-$B$31)*K48+$F$31*$B$32-$F$32*$B$31)/((($F$32-$B$32)^2+($F$31-$B$31)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($B$27-$B$32)*J48-($B$26-$B$31)*K48+$B$26*$B$32-$B$27*$B$31)/((($B$27-$B$32)^2+($B$26-$B$31)^2)^0.5),\" \")","v":" "},{"$f":"IFERROR(ABS(($F$27-$F$32)*J48-($F$26-$F$31)*K48+$F$26*$F$32-$F$27*$F$31)/((($F$27-$F$32)^2+($F$26-$F$31)^2)^0.5),\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\\"]

{"sheet":"4 Sections","index":1,"n_rows":61,"n_cols":35,"rows_kept":61,"cut":false,"hidden":false,"merged":[[55,0,58,0],[55,3,55,4],[55,6,59,8],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[51,0,54,0],[51,3,51,4],[51,6,54,8],[52,3,52,4],[53,3,53,4],[54,3,54,4],[47,0,50,0],[47,3,47,4],[47,6,50,8],[48,3,48,4],[49,3,49,4],[50,3,50,4],[43,0,46,0],[43,3,43,4],[43,6,46,8],[44,3,44,4],[45,3,45,4],[46,3,46,4],[37,9,38,9],[38,2,38,3],[40,0,40,14],[41,0,42,1],[41,2,42,2],[41,3,42,4],[41,5,42,5],[41,6,42,8],[33,2,33,3],[33,8,34,8],[33,9,34,9],[35,0,37,0],[35,1,37,1],[35,4,37,4],[35,5,37,5],[35,8,36,8],[35,9,36,9],[37,8,38,8],[29,2,29,3],[29,8,30,8],[29,9,30,9],[30,2,30,3],[31,0,31,5],[31,8,32,8],[31,9,32,9],[32,0,32,1],[32,2,32,5],[25,8,26,8],[25,9,26,9],[26,0,28,0],[26,1,28,1],[26,4,28,4],[26,5,28,5],[27,8,28,8],[27,9,28,9],[21,2,21,3],[21,8,22,8],[21,9,22,9],[22,2,22,3],[23,0,23,1],[23,2,23,5],[23,8,24,8],[23,9,24,9],[24,2,24,3],[17,8,18,8],[17,9,18,9],[18,0,20,0],[18,1,20,1],[18,4,20,4],[18,5,20,5],[19,8,20,8],[19,9,20,9],[13,2,13,3],[13,8,14,8],[13,9,14,9],[14,0,14,5],[15,0,15,1],[15,2,15,5],[15,8,16,8],[15,9,16,9],[16,2,16,3],[9,0,11,0],[9,1,11,1],[9,4,11,4],[9,5,11,5],[9,8,10,8],[9,9,10,9],[11,8,12,8],[11,9,12,9],[12,2,12,3],[5,0,5,5],[5,8,5,14],[6,0,6,1],[6,2,6,5],[7,2,7,3],[7,8,8,8],[7,9,8,9],[0,16,0,24],[1,0,1,1],[1,2,1,5],[1,9,1,11],[2,8,2,13],[3,3,4,3],[3,8,3,13],[4,8,4,14],[0,0,0,1],[0,2,0,5],[0,9,0,11],[0,12,1,12],[0,13,1,13],[0,14,1,14]]}
["Operator",null,null,null,null,null,null,1,"CD#",null,null,null,null,"NAD  ",83,null,"Procedure"]
["Well",null,null,null,null,null,null,null,"API",null,null,null,null,null,null,null,"1) Enter in yellow cells",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,"Has 1002A been filed?",null,null,null,null,null,"No",null,"2) Answer questions about 1002A status",null,null,"yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,83]
[null,null,null,"SHL","X",null,null,null,"Does data on 1002A match with location Exception?",null,null,null,null,null,"NA",null,"3) Enter X, Y coordinate for surface location",null,null,"No"]
[null,null,null,null,"Y",null,null,null,"If not, Please correct. Both documents should match ",null,null,null,null,null,null,null,"4) Enter X, Y coordinate for each corner",null,null,"NA"]
["Step I- Staking plat / Entry point",null,null,null,null,null,null,null,"Step II- Survey data / Interpolation ",null,null,null,null,null,null,null,"5) After entering X, Y coordinates, verify if the length of each section line is within acceptable unit size"]
["Surface",null,null,null,null,null,null,null,"Depth","Name","Survey","MD","TVD","N+/S-","E+/W-",null,"6) Enter the depth(md) for each point of interest in the first section"]
["X",null,0,null,"X",null,null,null,0,null,"Above",null,null,null,null,null,"7) Repeat  steps 4, 5 for other sections"]
["Y",null,"Entry 1, md",null,"Y",null,null,null,null,null,"Below",null,null,null,null,null,"8) Use directional survey. Enter the survey data in \"above/below\" for each entry point to interpolate"]
[null,0,"Entry 2, md",null,0,null,null,null,0,null,"Above",null,null,null,null,null,"9) When we have exact survey data for entry point (md), adjust the \"above/below\"depth to +/- 1 ft"]
[null,null,"Entry 3, md",null,null,null,null,null,null,null,"Below",null,null,null,null,null,"10) Check the results, calculated automatically "]
[null,null,"Entry 4, md",null,null,null,null,null,0,null,"Above",null,null,null,null,null,"11) Review any of sample calculations at the bottom of worksheet to complete the form"]
["X",null,0,null,"X",null,null,null,null,null,"Below",null,null,null,null,null,"12) For any further questions, please call (405) 521-4456"]
["Y",null,null,null,"Y",null,null,null,0,null,"Above"]
[null,null,null,null,null,null,null,null,null,null,"Below",null,null,null,null,null,"Comments:"]
["Middle 1",null,null,null,null,null,null,null,0,null,"Above"]
["X",null,0,null,"X",null,null,null,null,null,"Below",null,null,null,null,null,"1) OCC-Technical Department requires Grid North shall be used to maintain consistency and accuracy "]
["Y",null,"Entry 1, md",null,"Y",null,null,null,0,null,"Above"]
[null,0,"Entry 2, md",null,0,null,null,null,null,null,"Below",null,null,null,null,null,"2) Using True North could cause inconsistencies and delay processing of the final order"]
[null,null,"Entry 3, md",null,null,null,null,null,0,null,"Above"]
[null,null,"Entry 4, md",null,null,null,null,null,null,null,"Below",null,null,null,null,null,"3) Caution: Using Spreadsheet might have a slight variance in SHL versus the Plat. "]
["X",null,0,null,"X",null,null,null,0,null,"Above",null,null,null,null,null,"     Well Permit must Match Order"]
["Y",null,null,null,"Y",null,null,null,null,null,"Below"]
["Middle 2",null,null,null,null,null,null,null,0,null,"Above",null,null,null,null,null,"4) Caution: Measurements should be from nearest boundary unit "]
["X",null,0,null,"X",null,null,null,null,null,"Below"]
["Y",null,"Entry 1, md",null,"Y",null,null,null,0,null,"Above"]
[null,0,"Entry 2, md",null,0,null,null,null,null,null,"Below"]
[null,null,"Entry 3, md",null,null,null,null,null,0,null,"Above"]
[null,null,"Entry 4, md",null,null,null,null,null,null,null,"Below"]
["X",null,0,null,"X",null,null,null,0,null,"Above"]
["Y",null,null,null,"Y",null,null,null,null,null,"Below"]
[null,null,null,null,null,null,null,null,0,null,"Above"]
["Bottom",null,null,null,null,null,null,null,null,null,"Below"]
["X",null,0,null,"X",null,null,null,0,null,"Above"]
["Y",null,"Entry 1, md",null,"Y",null,null,null,null,null,"Below"]
[null,0,"Entry 2, md",null,0,null,null,null,0,null,"Above"]
[null,null,"Entry 3, md",null,null,null,null,null,null,null,"Below"]
[null,null,"Entry 4, md",null,null,null,null,null,0,null,"Above"]
["X",null,0,null,"X",null,null,null,null,null,"Below"]
["Y",null,"BHL",null,"Y",null,null,null,0,"BHL/TD","Final"]
["Step III- Calculation / Results"]
["Section / MD",null,"TVD","N+/S-",null,"E+/W-","SHL",null,null,"X","Y","FNL","FSL","FWL","FEL"]
[null,null,null,null,null,null,null,null,null,0,0," "," "," "," "]
["Surface",0," "," ",null," ",0,null,null," "," "," "," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,0," "," ",null," ",null,null,null," "," "," "," "," "," "]
[null,0," "," ",null," ",null,null,null," "," "," "," "," "," "]
[null,0," "," ",null," ",null,null,null," "," "," "," "," "," "]
["Middle 1",0," "," ",null," ",0,null,null," "," "," "," "," "," "]
[null,0," "," ",null," ",null,null,null," "," "," "," "," "," "]
[null,0," "," ",null," ",null,null,null," "," "," "," "," "," "]
[null,0," "," ",null," ",null,null,null," "," "," "," "," "," "]
["Middle 2",0," "," ",null," ",0,null,null," "," "," "," "," "," "]
[null,0," "," ",null," ",null,null,null," "," "," "," "," "," "]
[null,0," "," ",null," ",null,null,null," "," "," "," "," "," "]
[null,0," "," ",null," ",null,null,null," "," "," "," "," "," "]
["Bottom",0," "," ",null," ",0,null,null," "," "," "," "," "," "]
[null,0," "," ",null," ",null,null,null," "," "," ",{"$f":"IFERROR(ABS(($F$40-$B$40)*J57-($F$39-$B$39)*K57+$F$39*$B$40-$F$40*$B$39)/((($F$40-$B$40)^2+($F$39-$B$39)^2)^0.5),\" \")","v":" "}," "," "]
[null,0," "," ",null," ",null,null,null," "," "," "," "," "," "]
[null,0," "," ",null," ",null,null,null," "," "," "," "," "," "]
["TD",0,0,0,null,0,null,null,null," "," "," "," "," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\\"]