prog mant

Oct-04 PROGRAMA DE MANTENIMIENTO R/M "SHIP FOR SHEYLA"update :7/7/14DiferenciaDas de TrabajoFrec.Tabla de CoversinNCODIGOEQUIPOTRABAJOSFrecuenciaP/MLRSMot.Ultimo TrabajoPrximoDatos ActualesFecha Actuala Sumar a FechaenFrecuencia en Meses Ctrl + Mayusc + R = Modo ReporteHoras Prox.EquipoItemDE MANTENIMIENTOFechaHrs.TrabTrabajoFechaHrs. Trab.menos AGO 97Actual ( Q8 )DasFrecuencia en dasCtrl + Mayusc + D = Modo NormalServicioAug-97Jul-14A01HORAS TOTALES=60,000MOTOR PRINCIPALTabla 1A01MOTOR PRINCIPAL BRA01A0101MOT.PPL.BRRecorrido Integral Motor Principal10,000HrsRX28-Jan-1445,000Feb-13Jul-14600006170-514263-5,000A0102MOT.PPL.BRRecorrido Turbo-Soplante10,000HrsRX1er Ing26-Jan-1445,000Feb-13Jul-14600006170-514392-5,00003MOT.PPL.BRRecorrido del Gobernador10,000HrsRX1er Ing15-Jan-1455,000Dec-15Jul-1460000617051441235,000A0104MOT.PPL.BRBomba Agua de Refrigeracion20,000HrsRX1er Ing26-Jan-1443,000May-15Jul-1460000617030961843,000A0105MOT.PPL.BRBomba Aceite de Lubricacion20,000HrsRX1er Ing27-Jan-1443,000May-15Jul-14600006170309123663,000A0106MOT.PPL.BRInspeccin y/o Recorr. Arrancador Neumat.8,000Hrs23-Jun-1440,000Feb-11Jul-14600006170-1234-12,000A0107MOT.PPL.BRCambio de Aceite del Gobernador4,000HrsRX1er Ing10-Aug-1429,341Jan-07Jul-14600006170-274124731-26,659A0108MOT.PPL.BRInspeccion Valv. Desc. Bbas. de inyeccin4,000Hrs11-Aug-1429,346Jan-07Jul-14600006170-274130915-26,654A0109MOT.PPL.BRRecorrido de Inyectores2,500Hrs19-Mar-1427,930Mar-06Jul-14600006170-3041601827-29,570A0110MOT.PPL.BRPrueba Dispositivos de Seguridad1,000HrsRX1er Ing10-Mar-1427,964Oct-05Jul-14600006170-3192131-31,036A0111MOT.PPL.BRFlexiones de Eje Cigeal1,000HrsRX1er Ing23-Aug-1429,400Mar-06Jul-14600006170-3044-29,600A0112MOT.PPL.BRPrueba de Inyectores1,000HrsRX1er Ing19-Mar-1427,956Oct-05Jul-14600006170-3192-31,044.13MOT.PPL.BRLimpiar Filtros Valv. de Seguridad Carter1,000Hrs11-Aug-1429,346Mar-06Jul-14600006170-3049-29,65414MOT.PPL.BRInspeccion Cadena Eje de Levas1,000Hrs1er Ing11-Aug-1429,346Mar-06Jul-14600006170-3049-29,65415MOT.PPL.BRPrueba de Sobrevelocidad1,000HrsRX1er Ing24-Nov-1430,010May-06Jul-14600006170-2981-28,99016MOT.PPL.BRCambio Filtros de Combustible1,000Hrs30-Nov-1430,048May-06Jul-14600006170-2977-28,95217MOT.PPL.BRCambio de Aceite y Filtros Aceite Carter1,000Hrs25-Set-1429,650Apr-06Jul-14600006170-3018-29,350A0118MOT.PPL.BRCambio Aceite y Limp. Filtro Aceite Caja Red.1,000Hrs12-Nov-1429,946May-06Jul-14600006170-2988-29,05419MOT.PPL.BRVerificar Luces de Valvulas800Hrs12-Agto-1429,351Feb-06Jul-14600006170-3069-29,84920MOT.PPL.BRLimpieza Filtro de Aire800Hrs23-Dec-1430,227May-06Jul-14600006170-2979-28,973A0121MOT.PPL.BRInspeccion Engranajes Gobernador800Hrs29-Oct-1429,860Apr-06Jul-14600006170-3017-29,340A0122MOT.PPL.BRInspeccion Cadena de Bomba800Hrs11-Dec-1430,133Apr-06Jul-14600006170-2989-29,067A0123MOT.PPL.BRLimpiar Filtro Respiradero de Carter800Hrs5-Dec-1430,093Apr-06Jul-14600006170-2993-29,107HORAS TOTALES=30,324MOTOR PRINCIPALTabla 1MOTOR PRINCIPAL ER01MOT.PPL.ERRecorrido Integral Motor Principal10,000HrsRX28-Jan-0325,034Feb-17Jul-143032461709582634,710A0102MOT.PPL.ERRecorridoTurbo Soplante10,000HrsRX1er Ing26-Jan-0325,034Feb-17Jul-143032461709583924,710A0103MOT.PPL.ERRecorrido del Gobernador10,000HrsRX1er Ing15-Jan-0222,516Sep-15Jul-1430324617044641232,192A0104MOT.PPL.ERBomba agua de Refrigeracion20,000HrsRX1er Ing26-Jan-0325,034Sep-22Jul-143032461702993618414,71005MOT.PPL.ERBomba Aceite de Lubricacion20,000HrsRX1er Ing27-Jan-0325,034Sep-22Jul-1430324617029931236614,71006MOT.PPL.ERInspeccin y/o Recorr. Arrancador Neumat.8,000Hrs29-Mar-0327,000Feb-17Jul-143032461709514,67607MOT.PPL.ERCambio de Aceite del Gobernador4,000HrsRX1er Ing10-Aug-0429,391Mar-16Jul-14303246170624247313,06708MOT.PPL.ERInspeccion Valv. Desc. Bbas. de inyeccin4,000Hrs10-Aug-0429,391Mar-16Jul-14303246170624309153,06709MOT.PPL.ERRecorrido de Inyectores2,500Hrs3-Apr-0428,034Aug-14Jul-1430324617043601827210A15A10MOT.PPL.ERPrueba Dispositivos de Seguridad1,000HrsRX1er Ing10-Mar-0428,069Oct-13Jul-14303246170-255131-1,255A15A11MOT.PPL.ERFlexiones de Eje Cigeal1,000HrsRX1er Ing21-Aug-0429,441Jul-14Jul-1430324617024117A15A12MOT.PPL.ERPrueba de Inyectores1,000HrsRX1er Ing24-Oct-0429,873Oct-14Jul-14303246170112549A15A13MOT.PPL.ERLimpiar Filtros Valv. de Seguridad Carter1,000Hrs11-Aug-0429,396Jul-14Jul-143032461701572A15A14MOT.PPL.ERInspeccion Cadena Eje de Levas1,000Hrs1er Ing11-Aug-0429,396Jul-14Jul-143032461701572A15A15MOT.PPL.ERPrueba de Sobrevelocidad1,000HrsRX1er Ing24-Nov-0430,060Dec-14Jul-14303246170150736A15A16MOT.PPL.ERCambio Filtros de Combustible1,000Hrs30-Nov-0430,098Dec-14Jul-14303246170157774A15A17MOT.PPL.ERCambio de Aceite y Filtros Aceite Carter1,000Hrs.02-Set-0429,519Aug-14Jul-1430324617040195A15A18MOT.PPL.ERCambio Aceite y Limp. Filtro Aceite Caja Red.1,000Hrs12-Nov-0429,995Nov-14Jul-1430324617013767119MOT.PPL.ERVerificar Luces de Valvulas800Hrs12-Agsto-0429,401Jun-14Jul-14303246170-25-123A15A20MOT.PPL.ERLimpieza Filtro de Aire800Hrs11-Dec-0430,184Nov-14Jul-14303246170134660A15A21MOT.PPL.ERInspeccion Engranajes Gobernador800Hrs29-Oct-0429,909Sep-14Jul-143032461707838522MOT.PPL.ERInspeccion Cadena de Bomba800Hrs12-Dec-0430,193Nov-14Jul-14303246170136669A15A23MOT.PPL.ERLimpiar Filtro Respiradero de Carter800Hrs16-Dec-0430,226Nov-14Jul-14303246170143702A15AHORAS TOTALES=34,143A15AGRUPO ELECTROG. PROAA15AGRUPO ELECTROG. Nro. BRA15A01G/E PRRecorrido Integral del Motor10,000Hrs2do Ing6-Aug-0227835May-16Jul-143414361706673,692A15A02G/E PRRecorrido del Alternador10,000Hrs6-Aug-0227835May-16Jul-143414361706673,692A15A03G/E PRRecorrido del Turbo - Soplante5,000Hrs2do Ing6-Aug-0227835Nov-13Jul-14341436170-236-1,308A15A04G/E PRLimpieza del Enfriador de Agua2,400Hrs2do Ing.15-Set-0433,610Jun-15Jul-143414361703371,867A15A05G/E PRBomba Agua/Mar Cambio Impelente2,400Hrs2do Ing.26-Set-0433,707Jun-15Jul-143414361703551,964A15A06G/E PRLimpieza del Enfriador de Aceite2,400Hrs2do Ing20-Jun-0432,131Sep-14Jul-1434143617070388A15A07G/E PRVerificar Bomba de Inyeccion2,400Hrs2do Ing29-Set-0433,709Jun-15Jul-143414361703551,96608G/E PRVerificar Luces de Valvulas1,200Hrs2do Ing5-Aug-0432,949Jul-14Jul-1434143617016A15A09G/E PRCambio Filtro de Aire1,200Hrs2do Ing02-Set-0433,362Sep-14Jul-143414361707641910G/E PRCambio Filtros de Combustible1,200Hrs2do Ing02-Set-0433,362Sep-14Jul-1434143617076419A15A11G/E PRInspeccion de Arrancador Neumatico1,200Hrs2do Ing12-Agto-0433,117Aug-14Jul-1434143617031174A15A12G/E PRPrueba de Inyectores600HrsElect24-Set-0433,705Aug-14Jul-143414361702916213G/E PRCambio de Aceite y Filtro Aceite400Hrs5-Jan-0534,210Sep-14Jul-1434143617084467A15AA15AHORAS TOTALES=29,517GRUPO ELECTROG. POPAGRUPO ELECTROG. Nro. BR01G/E PPRecorrido Integral del Motor10,000Hrs2do Ing6-Aug-0223319Sep-16Jul-142951761707953,802A15C02G/E PPRecorrido del Alternador10,000Hrs6-Aug-0223319Sep-16Jul-142951761707953,802A15C03G/E PPRecorrido del Turbo - Soplante5,000Hrs2do Ing6-Aug-0223319Oct-13Jul-14295176170-250-1,198A15C04G/E PPLimpieza del Enfriador de Agua2,400Hrs2do Ing10-Set-0428,835Jul-15Jul-142951761703591,718A15C05G/E PPBomba Agua/Mar Cambio Impelente2,400Hrs2do Ing16-Apr-0227126Jul-14Jul-1429517617029A15C06G/E PPLimpieza del Enfriador de Aceite2,400Hrs2do Ing16-Apr-0227262Aug-14Jul-1429517617030145A15C07G/E PPVerificar Bomba de Inyeccion2,400Hrs2do Ing12-Jlio-0428,700Jun-15Jul-142951761703311,583A15C08G/E PPVerificar Luces de Valvulas1,200Hrs2do Ing22-Set-0428,863Oct-14Jul-14295176170114546A15C09G/E PPCambio Filtro de Aire1,200Hrs2do Ing15-Jun-0428515Aug-14Jul-1429517617041198A15C10G/E PPCambio Filtros de Combustible1,200Hrs2do Ing1-Jul-0428515Aug-14Jul-1429517617041198A15C11G/E PPInspeccion de Arrancador Neumatico1,200Hrs2do Ing29-Set-0428,919Nov-14Jul-1429517617012660212G/E PPPrueba de Inyectores600HrsElect22-Set-0428,863Jun-14Jul-14295176170-11-5413G/E PPCambio de Aceite y Filtro Aceite400Hrs31-Dec-0429,517Sep-14Jul-1429517617084400A15C

&R&P

HorasPETROLERA TRANSOCEANICA S.A.R/M "BALLESTAS"MES :Jul-02HORAS DE TRABAJO EQUIPOS PRINCIPALESNEQUIPOSMensualParcialTotalUltimo RecorridoFechaHrs. Trab01MAIN ENGINE Cyl N 1394,61525,41713.02.0120802Cyl N 2394,61525,41713.02.0120802Cyl N 3394,61525,41713.02.0120802Cyl N 4394,61525,41713.02.0120802Cyl N 5394,61525,41713.02.0120802Cyl N 6394,61525,41713.02.012080202TURBOCHARGER MAIN ENGINE394,61525,41713.02.012080203GRUPO ELECTROGENO BR275,39922,32916.09.001693004GRUPO ELECTROGENO ER825,64329,08128.06.022343805GRUPO ELECTROGENO DE PUERTO4536,54416,17906.06.029635

Mes2PETROLERA TRANSOCEANICA S.A.DPTO. INGENIERIATRABAJOS MANTENIMIENTOEQUIPOTRABAJOSFrec.PrximoDia - Realiz.

INDICEPROGRAMA DE MANTENIMIENTO B/T "PAVAYACU"I N D I C ECODIGOEQUIPOSPAG.CODIGOEQUIPOSPAG.A01MOTOR PRINCIPAL1.0D01COMPRESOR PRINCIPAL AIRE8.0A02TURBO SOPLANTE MOTOR PPL.2.0D02COMPRESOR AIRE INSTRUMENTOS8.0A03TURBO SOPLANTE AUXILIAR MOTOR PPL.2.0D03COMPRESOR AIRE EMERGENCIA9.0A04VIRADOR MOTOR PPL.3.0D04BOTELLA DE AIRE PRINCIPAL9.0A05CHUMACERA DE EMPUJE MOTOR PPL.3.0D05BOTELLA DE AIRE GRUPOS ELECTROGENOS9.0A10SELLO SIMPLEX3.0D06BOTELLA DE AIRE G/E EMERGENCIA9.0A11EJE INTERMEDIO MOTOR PPL.3.0D07BOTELLA DE AIRE INSTRUMENTOS9.0A12SISTEMA DE GOBIERNO3.0E01TURBINAS9.0A15CASCO , ANCLAS , CADENAS3.0E03BOMBAS DE CARGA10.0A17GRUPOS ELECTROGENOS3.0E05SISTEMA AUTOCEBADO BBAS. COMERC.10.0A20GRUPO ELECTROGENO DE EMERGENCIA5.0E06BOMBA STRIPPING11.0A21ALTERNADORES5.0F01BOMBA COMBUSTIBLE MOTOR PPL.11.0B01CALDERA PRINCIPAL5.0F02BOMBA TRANSFERENCIA F.O.11.0B03BOMBA ALIMENTACION CALD. PPL.5.0F03BOMBA TRANSFERENCIA D.O.11.0B04CALDERA AUXILIAR5.0F04BOMBA TRANSFERENCIA ACEITE11.0B06BOMBA ALIMENTACION CALDERA AUX.6.0F05BOMBA TRANSFERENCIA F.O. PROA11.0B10EVAPORADORA6.0F06BOMBA TRANSFERENCIA D.O. G/E11.0B11BOMBA EYECTORA EVAPORADORA6.0F08BOMBA ACEITE MOTOR PPL.11.0B12BOMBA EXTRACCION EVAPORADORA6.0F12PURIFICADOR F. O.12.0B16BOMBA EXTRACCION CONDENSO6.0F13PURIFICADOR D. O. - ACEITE12.0B18BOMBA TRANSF. AGUA ALIMENTACION6.0F15BOMBA COMBUSTIBLE CALD. PPAL.12.0B19BOMBA DE SULFITOS6.0F16SISTEMA HIDRAULICO VVS. COMERCIALES12.0C01BOMBA CONTRAINCENDIO7.0H06SALINOMETRO PRINCIPAL13.0C02BOMBA CEBADO BBA. C.I.7.0H07VISCOSIMETRO13.0C05BOMBA ESPUMA AGUA SALADA7.0H10TABLEROS ELECTRICOS13.0C06BOMBA CONTRAINCENDIO EMERGENCIA7.0H14TRANSFORMADORES13.0C17GAS INERTE7.0J01BOMBA CIRCULADORA13.0C18BOMBA DE SELLOS7.0J02BOMBA DE PUERTO13.0C19BOMBA ALIMENTACION GAS INERTE8.0J03BOMBA DE CAMISAS13.0C21PESCANTES BOTES SALVAVIDAS8.0J04BOMBA DE PISTONES14.0C22MOTOR BOTES SALVAVIDAS8.0J05BOMBA DE INYECTORES14.0CODIGOEQUIPOSPAG.CODIGOEQUIPOSPAG.J10ENFRIADOR DE PISTONES M.P.14.0M01BOMBA DE AGUA POTABLE16.0J11CALENTADOR PURIFICADOR ACEITE14.0M02BOMBA DE AGUA SANITARIA17.0J12CALENTADOR PURIFICADOR F.O.14.0M07BOMBA ACHIQUE SENTINA SALA MAQUINAS17.0J13CALENTADOR PURIFICADOR D.O.14.0M09BOMBA DE LODOS17.0J14CALENTADOR COMBUSTIBLE MOTOR PPL.14.0M10BOMBA SENTINA SALA BOMBAS POPA17.0J15CALENTADOR COMBUSTIBLE CALDERA PPL.14.0M14PLANTA DE AGUAS SERVIDAS17.0J16CALENTADOR CAMISAS MOTOR PPL.14.0M15SEPARADOR AGUA SENTINAS18.0J17CALENTADOR AGUA POTABLE15.0M16GRUA SALA DE MAQUINAS18.0K01PLANTA FRIGORIFICA15.0M17TORNO18.0K02COMPRESOR FRIGORIFICO15.0M18TALADRO18.0K03BOMBA REFRIGERACION FRIGORIFICA15.0M20MAQUINA DE SOLDAR ELECTRICA18.0K05PLANTA AIRE ACONDICIONADO15.0N01CABRESTANTES18.0L01VENTILADORES SALA DE MAQUINAS16.0N02WINCHES DE AMARRE POPA18.0L02VENTILADORES SALA DE CALDERAS16.0N03WINCHES EN CUBIERTA PRINCIPAL19.0L03VENTILADORES T.F. CALDERA PPL.16.0P01SIRENA TIFON PROA19.0L07VENTILADORES AIRE ACONDICIONADO16.0P08RADAR ARPA19.0L08VENTILADOR COCINA16.0P10RADAR AUXILIAR19.0L10EXTRACTOR SALA PURIFICADORES16.0P11GIROCOMPAS19.0L11EXTRACTOR SALA DE BOMBAS16.0P12COMPAS MAGNETICO19.0L13EXTRACTOR COCINA16.0P14RADIOGONIOMETRO19.0L15EXTRACTOR DE BAOS16.0

&APgina &P&APgina &P&APgina &P

Attribute VB_Name = "Mdulo1"

'' Reportes Macro' Reportes Mensuales a seleccionar''Sub Reportes()Attribute Reportes.VB_Description = "Reportes Mensuales a seleccionar"Attribute Reportes.VB_ProcData.VB_Invoke_Func = "R\n14" ActiveSheet.Unprotect Range("C1:E1").Select Selection.EntireColumn.Hidden = False Range("I1:K1").Select Selection.EntireColumn.Hidden = True Application.Goto Reference:="Reporte" Selection.AutoFilter Range("B1").SelectEnd Sub'' Deshacer Macro' Deshace presentacion Reporte''Sub Deshacer()Attribute Deshacer.VB_Description = "Deshace presentacion Reporte"Attribute Deshacer.VB_ProcData.VB_Invoke_Func = "D\n14" Selection.AutoFilter Range("D1").Select Selection.EntireColumn.Hidden = True Range("H1:L1").Select Selection.EntireColumn.Hidden = False Range("B1").Select ActiveSheet.Protect DrawingObjects:=True, Contents:= _ True, Scenarios:=TrueEnd Sub

Attribute VB_Name = "Mdulo3"

'''' Normal Macro' Presentacin Normal''Sub Normal()Attribute Normal.VB_Description = "Presentacin Normal"Attribute Normal.VB_ProcData.VB_Invoke_Func = "N\n14" ActiveSheet.Unprotect Range("IS1:A1").Select Selection.EntireColumn.Hidden = False Range("D1").Select Selection.ClearContents Range("D1").Select Selection.EntireColumn.Hidden = True Range("A1").Select Selection.EntireColumn.Hidden = True Selection.AutoFilter Field:=12 Application.Goto Reference:="sort" Selection.Sort Key1:=ActiveCell, Order1:=xlAscending, _ Header:=xlGuess, OrderCustom:=1, MatchCase _ :=False, Orientation:=xlTopToBottom Selection.AutoFilter Range("Q1:Z1").Select Selection.EntireColumn.Hidden = True Range("A1").Select With Selection .HorizontalAlignment = xlCenterAcrossSelection .VerticalAlignment = xlBottom .WrapText = False .Orientation = xlHorizontal End With ActiveCell.Select With ActiveSheet.PageSetup .PrintTitleRows = "1:5" .PrintTitleColumns = "" End With ActiveSheet.PageSetup.PrintArea = "$B$7:$P$685" With ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = "" .RightHeader = "&P" .LeftFooter = "" .CenterFooter = "" .RightFooter = "" .LeftMargin = Application.InchesToPoints(0.42) .RightMargin = Application.InchesToPoints(0.2) .TopMargin = Application.InchesToPoints(0.590551181102362) .BottomMargin = Application.InchesToPoints(0.3937007874016) .HeaderMargin = Application.InchesToPoints(0.511811023622047) .FooterMargin = Application.InchesToPoints(0.511811023622047) .PrintHeadings = False .PrintGridlines = False .PrintNotes = False .CenterHorizontally = False .CenterVertically = False .Orientation = xlLandscape .Draft = False .PaperSize = xlPaperA4 .FirstPageNumber = xlAutomatic .Order = xlDownThenOver .BlackAndWhite = False End With Range("AA1:AE1").Select Selection.EntireColumn.Hidden = True ActiveSheet.Protect DrawingObjects:=True, Contents:= _ True, Scenarios:=TrueEnd Sub

Attribute VB_Name = "Mdulo2"

'' Primer_Ing Macro' Reporte 1er. Ing''Sub Primer_Ing()Attribute Primer_Ing.VB_Description = "Reporte 1er. Ing"Attribute Primer_Ing.VB_ProcData.VB_Invoke_Func = "F\n14" ActiveSheet.Unprotect Range("C1:E1").Select Selection.EntireColumn.Hidden = False ActiveCell.Offset(0, -1).Range("A1:B1").Select Selection.EntireColumn.Hidden = True ActiveCell.Offset(2, 10).Range("A1").Select Application.Goto Reference:="Reporte" Selection.AutoFilter ActiveCell.Offset(0, 11).Range("A1").Select Selection.AutoFilter Field:=12, Criteria1:="1er Ing" Application.Goto Reference:="sort" Selection.Sort Key1:=ActiveCell.Offset(0, 15).Range("A1"), _ Order1:=xlAscending, Header:=xlGuess, OrderCustom _ :=1, MatchCase:=False, Orientation:= _ xlTopToBottom ActiveWindow.SmallScroll Down:=-3 ActiveCell.Offset(-7, 6).Range("A1:I1").Select Selection.EntireColumn.Hidden = True ActiveCell.Offset(0, 21).Range("A1").Select Selection.Copy ActiveCell.Offset(0, -24).Range("A1").Select ActiveSheet.Paste Application.CutCopyMode = False ActiveCell.Range("A1:M1").Select With Selection .HorizontalAlignment = xlCenterAcrossSelection .VerticalAlignment = xlBottom .WrapText = False .Orientation = xlHorizontal End With ActiveCell.Select With ActiveSheet.PageSetup .PrintTitleRows = "1:5" .PrintTitleColumns = "" End With ActiveSheet.PageSetup.PrintArea = "$B$7:$P$685" With ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = "" .RightHeader = "&P" .LeftFooter = "" .CenterFooter = "" .RightFooter = "" .LeftMargin = Application.InchesToPoints(1) .RightMargin = Application.InchesToPoints(0.15748031496063) .TopMargin = Application.InchesToPoints(0.590551181102362) .BottomMargin = Application.InchesToPoints(0.9842519685039) .HeaderMargin = Application.InchesToPoints(0.511811023622047) .FooterMargin = Application.InchesToPoints(0.511811023622047) .PrintHeadings = False .PrintGridlines = False .PrintNotes = False .CenterHorizontally = False .CenterVertically = False .Orientation = xlPortrait .Draft = False .PaperSize = xlPaperA4 .FirstPageNumber = xlAutomatic .Order = xlDownThenOver .BlackAndWhite = False End With ActiveSheet.Protect DrawingObjects:=True, Contents:= _ True, Scenarios:=TrueEnd Sub

'' Segundo_Ing Macro' Reporte 2do. Ing''Sub Segundo_Ing()Attribute Segundo_Ing.VB_ProcData.VB_Invoke_Func = "S\n14" ActiveSheet.Unprotect Range("C1:E1").Select Selection.EntireColumn.Hidden = False ActiveCell.Offset(0, -1).Range("A1:B1").Select Selection.EntireColumn.Hidden = True ActiveCell.Offset(2, 10).Range("A1").Select Application.Goto Reference:="Reporte" Selection.AutoFilter ActiveCell.Offset(0, 11).Range("A1").Select Selection.AutoFilter Field:=12, Criteria1:="2do Ing" Application.Goto Reference:="sort" Selection.Sort Key1:=ActiveCell.Offset(0, 15).Range("A1"), _ Order1:=xlAscending, Header:=xlGuess, OrderCustom _ :=1, MatchCase:=False, Orientation:= _ xlTopToBottom ActiveWindow.SmallScroll Down:=-3 ActiveCell.Offset(-7, 6).Range("A1:I1").Select Selection.EntireColumn.Hidden = True ActiveCell.Offset(0, 22).Range("A1").Select Selection.Copy ActiveCell.Offset(0, -25).Range("A1").Select ActiveSheet.Paste Application.CutCopyMode = False ActiveCell.Range("A1:M1").Select With Selection .HorizontalAlignment = xlCenterAcrossSelection .VerticalAlignment = xlBottom .WrapText = False .Orientation = xlHorizontal End With ActiveCell.Select With ActiveSheet.PageSetup .PrintTitleRows = "1:5" .PrintTitleColumns = "" End With ActiveSheet.PageSetup.PrintArea = "$B$7:$P$685" With ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = "" .RightHeader = "&P" .LeftFooter = "" .CenterFooter = "" .RightFooter = "" .LeftMargin = Application.InchesToPoints(1) .RightMargin = Application.InchesToPoints(0.15748031496063) .TopMargin = Application.InchesToPoints(0.590551181102362) .BottomMargin = Application.InchesToPoints(0.9842519685039) .HeaderMargin = Application.InchesToPoints(0.511811023622047) .FooterMargin = Application.InchesToPoints(0.511811023622047) .PrintHeadings = False .PrintGridlines = False .PrintNotes = False .CenterHorizontally = False .CenterVertically = False .Orientation = xlPortrait .Draft = False .PaperSize = xlPaperA4 .FirstPageNumber = xlAutomatic .Order = xlDownThenOver .BlackAndWhite = False End With ActiveSheet.Protect DrawingObjects:=True, Contents:= _ True, Scenarios:=TrueEnd Sub

'' Tercer_Ing Macro' Reporte 3er. Ing''Sub Tercer_Ing()Attribute Tercer_Ing.VB_ProcData.VB_Invoke_Func = "T\n14" ActiveSheet.Unprotect Range("C1:E1").Select Selection.EntireColumn.Hidden = False ActiveCell.Offset(0, -1).Range("A1:B1").Select Selection.EntireColumn.Hidden = True ActiveCell.Offset(2, 10).Range("A1").Select Application.Goto Reference:="Reporte" Selection.AutoFilter ActiveCell.Offset(0, 11).Range("A1").Select Selection.AutoFilter Field:=12, Criteria1:="3er Ing" Application.Goto Reference:="sort" Selection.Sort Key1:=ActiveCell.Offset(0, 15).Range("A1"), _ Order1:=xlAscending, Header:=xlGuess, OrderCustom _ :=1, MatchCase:=False, Orientation:= _ xlTopToBottom ActiveWindow.SmallScroll Down:=-3 ActiveCell.Offset(-7, 6).Range("A1:I1").Select Selection.EntireColumn.Hidden = True ActiveCell.Offset(0, 23).Range("A1").Select Selection.Copy ActiveCell.Offset(0, -26).Range("A1").Select ActiveSheet.Paste Application.CutCopyMode = False ActiveCell.Range("A1:M1").Select With Selection .HorizontalAlignment = xlCenterAcrossSelection .VerticalAlignment = xlBottom .WrapText = False .Orientation = xlHorizontal End With ActiveCell.Select ActiveCell.Select With ActiveSheet.PageSetup .PrintTitleRows = "1:5" .PrintTitleColumns = "" End With ActiveSheet.PageSetup.PrintArea = "$B$7:$P$685" With ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = "" .RightHeader = "&P" .LeftFooter = "" .CenterFooter = "" .RightFooter = "" .LeftMargin = Application.InchesToPoints(1) .RightMargin = Application.InchesToPoints(0.15748031496063) .TopMargin = Application.InchesToPoints(0.590551181102362) .BottomMargin = Application.InchesToPoints(0.9842519685039) .HeaderMargin = Application.InchesToPoints(0.511811023622047) .FooterMargin = Application.InchesToPoints(0.511811023622047) .PrintHeadings = False .PrintGridlines = False .PrintNotes = False .CenterHorizontally = False .CenterVertically = False .Orientation = xlPortrait .Draft = False .PaperSize = xlPaperA4 .FirstPageNumber = xlAutomatic .Order = xlDownThenOver .BlackAndWhite = False End With ActiveSheet.Protect DrawingObjects:=True, Contents:= _ True, Scenarios:=TrueEnd Sub

'' Elect Macro' Reporte Electricista''Sub Elect()Attribute Elect.VB_ProcData.VB_Invoke_Func = "E\n14" ActiveSheet.Unprotect Range("C1:E1").Select Selection.EntireColumn.Hidden = False ActiveCell.Offset(0, -1).Range("A1:B1").Select Selection.EntireColumn.Hidden = True ActiveCell.Offset(2, 10).Range("A1").Select Application.Goto Reference:="Reporte" Selection.AutoFilter ActiveCell.Offset(0, 11).Range("A1").Select Selection.AutoFilter Field:=12, Criteria1:="Elect" Application.Goto Reference:="sort" Selection.Sort Key1:=ActiveCell.Offset(0, 15).Range("A1"), _ Order1:=xlAscending, Header:=xlGuess, OrderCustom _ :=1, MatchCase:=False, Orientation:= _ xlTopToBottom ActiveWindow.SmallScroll Down:=-3 ActiveCell.Offset(-7, 6).Range("A1:I1").Select Selection.EntireColumn.Hidden = True ActiveCell.Offset(0, 24).Range("A1").Select Selection.Copy ActiveCell.Offset(0, -27).Range("A1").Select ActiveSheet.Paste Application.CutCopyMode = False ActiveCell.Range("A1:M1").Select With Selection .HorizontalAlignment = xlCenterAcrossSelection .VerticalAlignment = xlBottom .WrapText = False .Orientation = xlHorizontal End With ActiveCell.Select ActiveCell.Select ActiveCell.Select With ActiveSheet.PageSetup .PrintTitleRows = "1:5" .PrintTitleColumns = "" End With ActiveSheet.PageSetup.PrintArea = "$B$7:$P$685" With ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = "" .RightHeader = "&P" .LeftFooter = "" .CenterFooter = "" .RightFooter = "" .LeftMargin = Application.InchesToPoints(1) .RightMargin = Application.InchesToPoints(0.15748031496063) .TopMargin = Application.InchesToPoints(0.590551181102362) .BottomMargin = Application.InchesToPoints(0.9842519685039) .HeaderMargin = Application.InchesToPoints(0.511811023622047) .FooterMargin = Application.InchesToPoints(0.511811023622047) .PrintHeadings = False .PrintGridlines = False .PrintNotes = False .CenterHorizontally = False .CenterVertically = False .Orientation = xlPortrait .Draft = False .PaperSize = xlPaperA4 .FirstPageNumber = xlAutomatic .Order = xlDownThenOver .BlackAndWhite = False End With ActiveSheet.Protect DrawingObjects:=True, Contents:= _ True, Scenarios:=TrueEnd Sub

Attribute VB_Name = "ThisWorkbook"Attribute VB_Base = "0{00020819-0000-0000-C000-000000000046}"Attribute VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute VB_TemplateDerived = FalseAttribute VB_Customizable = True

Attribute VB_Name = "Hoja2"Attribute VB_Base = "0{00020820-0000-0000-C000-000000000046}"Attribute VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute VB_TemplateDerived = FalseAttribute VB_Customizable = True