ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '657952' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '657952' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '657952' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '657952' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '657952']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '657952'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 657952 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 657952]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 657952 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 657952

Título del libro:
Título del capítulo: Three-Level System to Determine and Correct Real Time Drillstring Vibration

Autores UNAM:
JUAN PEDRO MORALES SALAZAR;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2024

---

Palabras clave:

Axial flow; Brinell Hardness; Gasoline; Infill drilling; Rock drilling; Rockwell hardness; Vibration analysis; Well drilling; Drilling analysis; Energy; Performance; Rate of penetration; Ratio factors; Real- time; Specific mechanical energy; Strength ratios; Three level systems; Weight on bits; Drill strings

---

Resumen:

This paper aims to identify the impact of parameters: Rate of Penetration (ROP), Torque, and Weight on Bit (WOB) on the Specific Mechanical Energy (MSE). This concept has been implemented to evaluate bit performance, determine drilling efficiency, and analyze if the bit adequately utilizes the energy and is not dissipated elsewhere (vibration). However, MSE alone does not differentiate between the causes of inefficiency and additional energy used in drilling. Various studies have analyzed this parameter along with the MSE/DS (MSE/Drilling Strength) ratio to determine if drilling inefficiency is due to rock hardness, vibrations, bit wear, or bit balling (Raul Flores, CMP 2024). Continuing with the study, we have the following: 1. A three-way protocol to determine and correct drill string vibration is presented with a simplified methodology. 2. When using the original MSE equation, there are two terms: torsional load and axial load. Studies concluded that the axial load can be omitted, yielding the same result. Also, in terms of trend analysis, MSE behaves the same over the drilling time. 3. The MSE/DS ratio led us to a simplified equation called the Ratio Factor (RF), a quick-to-calculate optimized factor. The RF is the ratio between the rotational forces and the normal axial forces on the bit. 4. 3 case studies are shown, where based on the behavior of the MSE and the RF, the problems presented were identified and corrected, Well 1: vibrations, well 2: Bit wear and well-3: Impact of the MSE values. Copyright 2024, Society of Petroleum Engineers.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781959025375
Editorial:
Society of Petroleum Engineers (SPE)

Tipo de producto:
Conference Paper

DOI:
10.2118/220747-MS