Construcción Sobre de pago semanal por paquete programa en excel

Con este programa calcule el salario semanal por paquete según el Contrato Colectivo de la Construcción 2015 2017 y el aumento vigente. Es un Programa fácil de manejar, con realizar estos tres sencillos pasos:

Introduzca: 1) datos del patrono 2) datos del trabajador 3) datos de la relación laboral, el programa le calcula el Pago de salario semanal por paquete según Contrato Colectivo de la Construcción 2015 2017 , con su recibo de pago elaborado y listo de imprimir.





DENOMINACIÓN: 01/10/2017Salario5 Dias TrabajadosB. Asistencia Semanal2 Dias de DescansoB. AlimentPago Semanal
OBRERO DE 1RA5,900.5429,502.718,260.7615,105.3944,100.0096,968.85
AYUDANTE6,317.7031,588.498,844.7816,173.3144,100.00100,706.58
VIGILANTE5,900.5429,502.718,260.7615,105.3944,100.0096,968.85
SOLDADOR DE 3RA6,994.1034,970.529,791.7417,904.9144,100.00106,767.17
CAPORAL7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
ALBAÑIL DE 2DA7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
CARPINTERO DE 2DA7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
CABILLERO DE 2DA7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
PLOMERO DE 2DA7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
ELECTRICISTA DE 2DA7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
GRANITERO DE 2DA7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
PINTOR DE 2DA7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
IMPERMEABILIZADOR DE 2DA7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
GÜINCHERO7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
MAQUINISTA DE CONCRETO DE 1RA7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
OPERADOR DE PLANTA FIJA DE 2DA7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
OPERADOR DE EQUIPO LIVIANO7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
MECANICO DE GASOLINA DE 2DA7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
SOLDADOR DE 2DA7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
LATONERO DE 2DA7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
INSTALADOR ELECTROMECANICO DE 2DA7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
OPERADOR DE EQUIPO DE SANDBLASTING7,083.1635,415.789,916.4218,132.8844,100.00107,565.07
OPERADOR DE PAVIMENTADORA7,162.7835,813.9010,027.8918,336.7144,100.00108,278.50
CHOFER DE 1RA ( DE 8 A 15 TON)7,177.0735,885.3710,047.9018,373.3144,100.00108,406.58
MECANICO DE GASOLINA DE 1RA7,247.1536,235.7410,146.0118,552.7044,100.00109,034.44
OPERADOR DE PLANTA FIJA DE 1RA7,331.5836,657.8810,264.2118,768.8444,100.00109,790.92
CHOFER DE CAMION DE MAS DE 15 TON7,364.9736,824.8510,310.9618,854.3344,100.00110,090.14
CHOFER DE CAMION MEZCLADOR8,683.0543,415.2412,156.2722,228.6044,100.00121,900.12
DINAMITERO8,767.4843,837.3912,274.4722,444.7444,100.00122,656.60
OPERADOR DE PALA HASTA 1 YARDA CUB7,835.0539,175.2410,969.0720,057.7244,100.00114,302.03
ALBAÑIL DE 1RA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
CARPINTERO DE 1RA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
CABILLERO DE 1RA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
PLOMERO DE 1RA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
ELECTRICISTA DE 1RA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
GRANITERO DE 1RA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
PINTOR DE 1RA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
IMPERMEABILIZADOR DE 1RA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
OPERADOR DE EQUIPO PESADO DE 2DA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
TRACTORISTA DE 2DA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
OPERADOR DE MOTOTRAILLA DE 2DA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
OPERADOR DE MOTONIVELADORA DE 2DA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
OPERADOR DE GRUA (GRUERO) DE 2DA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
MECANICO DE EQUIPO PESADO DE 2DA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
OPERADOR DE MAQUINAS-HERRAMIENTAS DE 2DA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
SOLDADOR DE 1RA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
TUBERO FABRICADOR7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
MONTADOR7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
LATONERO DE 1RA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
INSTALADOR ELECTROMECANICO DE 1RA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
LINIERO DE 1RA7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
ALBAÑIL REFRACTARIO7,922.4039,611.9811,091.3620,281.3444,100.00115,084.68
AYUDANTE DE OPERADORES6,317.7031,588.498,844.7816,173.3144,100.00100,706.58
AYUDANTE DE MECANICO DIESEL6,317.7031,588.498,844.7816,173.3144,100.00100,706.58
CAUCHERO6,994.1034,970.529,791.7417,904.9144,100.00106,767.17
OPERADOR DE PALA DE MAS 1 YARDA CUB. DE 8,087.6140,438.0311,322.6520,704.2744,100.00116,564.94
CHOFER DE GANDOLA DE 2DA (15 A 40 TON)8,200.5641,002.8111,480.7920,993.4444,100.00117,577.04
MAESTRO CARPINTERO DE 2DA8,261.1541,305.7311,565.6121,148.5444,100.00118,119.88
OPERADOR DE GRUA (GRUERO) DE 1RA8,261.1541,305.7311,565.6121,148.5444,100.00118,119.88
OPERADOR DE MAQUINAS-HERRAMIENTAS DE 1RA8,261.1541,305.7311,565.6121,148.5444,100.00118,119.88
CHOFER DE GANDOLA DE 1RA (TODO TON.)8,683.0543,415.2412,156.2722,228.6044,100.00121,900.12
MAESTRO ALBAÑIL8,767.6043,838.0012,274.6422,445.0544,100.00122,657.69
MAESTRO CARPINTERO DE 1RA8,767.4843,837.3912,274.4722,444.7444,100.00122,656.60
MAESTRO CABILLERO8,767.4843,837.3912,274.4722,444.7444,100.00122,656.60
MAESTRO PLOMERO DE 1RA8,767.4843,837.3912,274.4722,444.7444,100.00122,656.60
MAESTRO ELECTRICISTA8,767.4843,837.3912,274.4722,444.7444,100.00122,656.60
MAESTRO GRANITERO8,767.4843,837.3912,274.4722,444.7444,100.00122,656.60
MAESTRO PINTOR8,767.4843,837.3912,274.4722,444.7444,100.00122,656.60
MAESTRO IMPERMEABILIZADOR8,767.4843,837.3912,274.4722,444.7444,100.00122,656.60
MAESTRO DE OBRA DE 2DA8,767.4843,837.3912,274.4722,444.7444,100.00122,656.60
MAESTRO DE VOLADURAS10,105.9350,529.6614,148.3125,871.1944,100.00134,649.16
OPERADOR DE EQUIPO PESADO DE 1RA10,105.9350,529.6614,148.3125,871.1944,100.00134,649.16
TRACTORISTA DE 1RA10,105.9350,529.6614,148.3125,871.1944,100.00134,649.16
OPERADOR DE MOTOTRAILLA DE 1RA10,105.9350,529.6614,148.3125,871.1944,100.00134,649.16
OPERADOR DE PALA DE MAS 1 YARDA CUB. DE 10,105.9350,529.6614,148.3125,871.1944,100.00134,649.16
OPERADOR DE MOTONIVELADORA DE 1RA10,105.9350,529.6614,148.3125,871.1944,100.00134,649.16
CAPORAL DE EQUIPO8,767.4843,837.3912,274.4722,444.7444,100.00122,656.60
MECANICO DE EQUIPO PESADO DE 1RA8,767.4843,837.3912,274.4722,444.7444,100.00122,656.60
MAESTRO DE OBRAS ELECTROMECANICAS8,767.4843,837.3912,274.4722,444.7444,100.00122,656.60
MAESTRO DE OBRA DE 1RA10,105.9350,529.6614,148.3125,871.1944,100.00134,649.16
MAESTRO MECANICO10,105.9350,529.6614,148.3125,871.1944,100.00134,649.16
AUXILIAR DE DEPOSITO6,402.1332,010.648,962.9816,389.4544,100.00101,463.06
OPERADOR DE MARTILLO PERFORADOR6,402.1332,010.648,962.9816,389.4544,100.00101,463.06
AYUDANTE DE TOPOGRAFO6,402.1332,010.648,962.9816,389.4544,100.00101,463.06
RASTRILLERO6,402.1332,010.648,962.9816,389.4544,100.00101,463.06
CHOFER DE 4TA6,444.9532,224.759,022.9316,499.0744,100.00101,846.75
ESPESORISTA6,486.4332,432.179,081.0116,605.2744,100.00102,218.45
MAQUINISTA DE CONCRETO DE 2DA6,570.9232,854.629,199.2916,821.5744,100.00102,975.48
CHOFER DE 3RA (HASTA 3 TON)6,593.6132,968.079,231.0616,879.6544,100.00103,178.77
ENGRASADOR6,593.6132,968.079,231.0616,879.6544,100.00103,178.77
CHOFER DE 2DA (DE 3 A 8 TON)6,739.6033,698.009,435.4417,253.3844,100.00104,486.82
OPERADOR DE EQUIPO PERFORADOR6,909.6134,548.079,673.4617,688.6144,100.00106,010.14
CUADRILLA DE ELABORACION DE CONCRETO35,738.04178,690.2250,033.2691,489.3944,100.00364,312.87
CUADRILLA DE CARPINTERIA14,240.0371,200.1719,936.0536,454.4944,100.00171,690.71
CUADRILLA DE CABILLA129,771.39648,856.97181,679.95332,214.7744,100.001,206,851.68
CUADRILLA DE IMPERMEABILIZACION42,314.14211,570.6959,239.79108,324.1944,100.00423,234.67
CUADRILLA DE ALBAÑILERIA34,797.89173,989.4448,717.0489,082.5944,100.00355,889.08
CUADRILLA DE GRANITO60,010.41300,052.0484,014.57153,626.6544,100.00581,793.26
CUADRILLA DE PINTURA27,567.16137,835.8238,594.0370,571.9444,100.00291,101.80
CUADRILLA DE TUBEROS ELECTRICOS28,069.30140,346.4939,297.0271,857.4044,100.00295,600.91
CUADRILLA DE PLOMERIA48,209.63241,048.1567,493.48123,416.6544,100.00476,058.29
CUADRILLA DE EXCAVACION MECANICA34,808.78174,043.8848,732.2989,110.4744,100.00355,986.64
CUADRILLA DE COMPACTACION MECANICA33,969.66169,848.2847,557.5286,962.3244,100.00348,468.13
CUADRILLA DE MOV. TIERRAS C/EQUIPO LIVIA33,969.66169,848.2847,557.5286,962.3244,100.00348,468.13
CUADRILLA DE MOVIMIENTO DE TIERRAS MANUA30,684.95153,424.7742,958.9478,553.4844,100.00319,037.20
CUADRILLA DE ELECTRICIDAD23,007.57115,037.8632,210.6058,899.3944,100.00250,247.85
CUADRILLA DE DEMOLICION MANUAL30,684.95153,424.7742,958.9478,553.4844,100.00319,037.20
CUADRILLA DE DEMOLICION CON COMPRESOR45,088.80225,443.9963,124.32115,427.3244,100.00448,095.63
CUADRILLA DE ESTRUCTURAS METALICAS63,371.02316,855.1288,719.43162,229.8244,100.00611,904.37
CUADRILLA DE FABRICACION ESTRUC. METALIC49,547.84247,739.2169,366.98126,842.4844,100.00488,048.67
CUADRILLA DE MONTAJE DE ESTRUCT. METALIC77,193.84385,969.20108,071.38197,616.2344,100.00735,756.80
CUADRILLA PARA TRABAJOS DE HERRERIA32,694.34163,471.7045,772.0883,697.5144,100.00337,041.29
CUADRILLA DE OBREROS ESPECIALISTAS26,469.16132,345.8137,056.8367,761.0544,100.00281,263.69
CUADRILLA DE COLOC. TUBERIA DE ACERO43,492.01217,460.0460,888.81111,339.5444,100.00433,788.39
CUADRILLA DE SOLDADURA DE TUBERIA50,387.27251,936.3370,542.17128,991.4044,100.00495,569.90
CUADRILLA DE ALCANTARILLA42,464.75212,323.7459,450.65108,709.7544,100.00424,584.14
CUADRILLA DE COLOCACION DE CONCRETO48,884.70244,423.4968,438.58125,144.8344,100.00482,106.89
CUADRILLA PARA DRENAJES DE CONCRETO80,232.98401,164.90112,326.17205,396.4344,100.00762,987.50
CUADRILLA DE CONCRETO PAVIMENTOS98,351.52491,757.58137,692.12251,779.8844,100.00925,329.59
CUADRILLA DE CONCRETO PUENTES / PONTONES89,342.67446,713.37125,079.74228,717.2544,100.00844,610.36
CUADRILLA DE CONCRETO P/OBRAS DE ARTE105,183.03525,915.14147,256.24269,268.5544,100.00986,539.93
CUADRILLA DE CONCRETO86,555.54432,777.72121,177.76221,582.1944,100.00819,637.67
CUADRILLA DE CONCRETO PARA CUNETAS67,597.10337,985.4894,635.94173,048.5744,100.00649,769.98
CUADRILLA DE BOCA DE VISITA44,834.84224,174.2162,768.78114,777.2044,100.00445,820.19
CUADRILLA DE TUBERIA H.F.D.42,464.75212,323.7459,450.65108,709.7544,100.00424,584.14
CUADRILLA DE TUBERIA P.V.C.25,193.91125,969.5335,271.4764,496.4044,100.00269,837.40
CUADRILLA DE TUBERIA DE CONCRETO48,365.47241,827.3667,711.66123,815.6144,100.00477,454.62
CUADRILLA DE TUBERIA DE FIBROCEMENTO50,387.27251,936.3370,542.17128,991.4044,100.00495,569.90
CUADRILLA CONCRETO ANCLAJES51,917.69259,588.4772,684.77132,909.3044,100.00509,282.54
CUADRILLA DE PINTURA TUBERIAS37,248.46186,242.2952,147.8495,356.0544,100.00377,846.19
CUADRILLA DE CANALIZACION63,022.91315,114.5388,232.07161,338.6444,100.00608,785.24
INGENIERO CIVIL P-736,755.45183,777.2551,457.6394,093.9544,100.00373,428.82
ARQUITECTO P2 (4 A 5 AÑOS EXPER.)21,750.69108,753.4430,450.9655,681.7644,100.00238,986.16
ARQUITECTO PAISAJISTA P3 (6 A 7 AÑOS EX24,655.76123,278.8234,518.0763,118.7544,100.00265,015.64
INGENIERO SANITARIO P-736,755.45183,777.2551,457.6394,093.9544,100.00373,428.82
INGENIERO ELECTRICISTA P-736,755.45183,777.2551,457.6394,093.9544,100.00373,428.82
INGENIERO GEODESTA P-736,755.45183,777.2551,457.6394,093.9544,100.00373,428.82
INGENIERO MECÁNICO P-736,755.45183,777.2551,457.6394,093.9544,100.00373,428.82
INGENIERO P-736,755.45183,777.2551,457.6394,093.9544,100.00373,428.82
PASAJE Y TRASLADOS70,221.94351,109.6998,310.71179,768.1644,100.00673,288.57
VIATICOS46,814.67234,073.3365,540.53119,845.5544,100.00463,559.41
BUZO30,429.54152,147.6942,601.3577,899.6244,100.00316,748.67
ARQUITECTO P5 (10 A 11 AÑOS EXPER.)30,705.70153,528.4942,987.9878,606.5944,100.00319,223.05
ARQUITECTO P7 (14 A 15 AÑOS EXPER.)36,755.45183,777.2551,457.6394,093.9544,100.00373,428.82
INGENIERO HIDRAULICO P7 (14 A 15 AÑOS EX36,755.45183,777.2551,457.6394,093.9544,100.00373,428.82
PROFESIONAL CIV P-9 (19 A 20 AÑOS EXPER42,740.60213,703.0159,836.84109,415.9444,100.00427,055.79
PROFESIONAL CIV P-9A (24 A 25 AÑOS EXPE50,050.58250,252.9270,070.82128,129.5044,100.00492,553.23
PROFESIONAL CIV P-7 (14 A 15 AÑOS EXPER35,542.54177,712.7149,759.5690,988.9144,100.00362,561.18
ASISTENTE DE INGENIERO9,362.9246,814.6113,108.0923,969.0844,100.00127,991.77
ASISTENTE DE ARQUITECTO9,362.9246,814.6113,108.0923,969.0844,100.00127,991.77
TOPOGRAFO CON EQUIPO Y AUXILIAR64,820.31324,101.5390,748.43165,939.9944,100.00624,889.95
DISEÑADOR GRAFICO14,404.5172,022.5620,166.3236,875.5544,100.00173,164.43
TOPOGRAFO23,407.39117,036.9732,770.3559,922.9344,100.00253,830.25
DIBUJANTE9,002.8845,014.4112,604.0323,047.3844,100.00124,765.82
COMPUTISTA9,002.8845,014.4112,604.0323,047.3844,100.00124,765.82
CALCULISTA9,002.8845,014.4112,604.0323,047.3844,100.00124,765.82
CERRAJERO15,917.0079,584.9822,283.7940,747.5144,100.00186,716.29
JARDINERO14,044.4170,222.0619,662.1835,953.6944,100.00169,937.93
OFICIAL ESPECIALISTA DE 2DA10,227.1051,135.5114,317.9426,181.3844,100.00135,734.83
CHEQUEADOR10,227.1051,135.5114,317.9426,181.3844,100.00135,734.83
JEFE DE PLANTA51,496.10257,480.4872,094.53131,830.0144,100.00505,505.02
CAPATAZ DE GALVANIZADO23,731.36118,656.8133,223.9160,752.2944,100.00256,733.01
GALVANIZADOR11,235.5156,177.5315,729.7128,762.8944,100.00144,770.13
ACEITERO DE BARCO (SECTOR PETROLERO)6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
AFORADOR DE TANQUES (SECTOR PETROLERO)6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
AISLADOR "A" (SECTOR PETROLERO)6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
AISLADOR "B" (SECTOR PETROLERO)6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
ALBAÑIL "A" (SECTOR PETROLERO)6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
ALBAÑIL "B" (SECTOR PETROLERO)6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
ALBAÑIL AYUDANTE (SECTOR PETROLERO)6,813.5734,067.839,538.9917,442.7344,100.00105,149.56
APAREJADOR REFINERIA "A" (SECT PETROLERO6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
APAREJADOR REFINERIA "B" (SECT PETROLERO6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
ARMADOR CABRIAS "A" (SECTOR PETROLERO)6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
ARMADOR CABRIAS "B" (SECTOR PETROLERO)6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
ARMADOR TUBERIAS "A" (SECTOR PETROLERO)6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
ARMADOR TUBERIAS "B" (SECTOR PETROLERO)6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
ARMADOR TUBERIAS "C" (SECTOR PETROLERO)6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
ARMADOR TUBERIAS AYUD. (SECTOR PETROLERO6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
AUXILIAR COMISARIATO (SECTOR PETROLERO)6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
BOMBERO CONTRA INCENDIO "A" (SECT. PETRO6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
BOMBERO CONTRA INCENDIO "B" (SECT. PETRO6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
BUZO INDUSTRIAL (SECTOR PETROLERO)6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
CABILLERO (SECTOR PETROLERO)6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
CABILLERO AYUDANTE (SECTOR PETROLERO)6,809.8634,049.289,533.8017,433.2344,100.00105,116.31
CABILLERO B (SECTOR PETROLERO)6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
CAMARERO "A" (SECTOR PETROLERO)6,809.8634,049.289,533.8017,433.2344,100.00105,116.31
CAPORAL "A" (SECTOR PETROLERO)6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
CAPORAL "B" (SECTOR PETROLERO)6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
CARPINTERO "A" (SECTOR PETROLERO)6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
CARPINTERO "B" (SECTOR PETROLERO)6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
CARRETERO/CADENERO TALADRO (SECT. PETROL6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
CHOFER "A" (SECTOR PETROLERO)6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
CHOFER "B" (SECTOR PETROLERO)6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
CHOFER ABASTECEDOR AEROPUERTO (SECT. PET6,822.8134,114.069,551.9417,466.4044,100.00105,232.40
CHOFER COBRADOR ESPECIAL (SECTOR PETROLE6,822.8134,114.069,551.9417,466.4044,100.00105,232.40
CHOFER ESPECIAL 30 TON (SECT PETROLERO)6,819.7134,098.559,547.5917,458.4644,100.00105,204.60
COCINERO "A" (SECTOR PETROLERO)6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
COCINERO "B" (SECTOR PETROLERO)6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
COCINERO "C" (SECTOR PETROLERO)6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
DESPACHADOR HERRAMIEMTAS "A" (SECT PETRO6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
DESPACHADOR HERRAMIENTAS "B" (SECT PETRO6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
DINAMITERO (SECTOR PETROLERO)6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
ELECTRICISTA "A" (SECTOR PETROLERO)6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
ELECTRICISTA "B" (SECTOR PETROLERO)6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
ELECTRICISTA "C" (SECTOR PETROLERO)6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
ELECTRICISTA AYUDANTE (SECTOR PETROLERO)6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
EMBARC. DESEMB. DE PETROLEO (SECTOR PETR6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
ENCUELLADOR (SECTOR PETROLERO)6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
ESTIBADOR (SECTOR PETROLERO)6,809.8634,049.289,533.8017,433.2344,100.00105,116.31
FABRICADOR DE ESTRUCT METAL. AYUD (SECT 6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
FABRICADOR DE ESTR. METALICA "A" (SECT P6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
FABRICADOR DE ESTR. METALICA "B" (SECT. 6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
FABRICADOR DE ESTR. METALICA "C" (SECT. 6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
INSTALADOR GAS "A" (SECTOR PETROLERO)6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
INSTALADOR GAS "B" (SECTOR PETROLERO)6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
LIMPIADOR (SECTOR PETROLERO)6,813.5734,067.839,538.9917,442.7344,100.00105,149.56
MAESTRO DE VOLADURAS (SECTOR PETROLERO)6,822.8134,114.069,551.9417,466.4044,100.00105,232.40
MAQUINISTA UNIDADES PESADAS (SECTOR PETR6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
MARINERO (SECTOR PETROLERO)6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
MECANICO AUTOMOTRIZ "A" (SECTOR PETROLER6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
MECANICO AUTOMOTRIZ "B" (SECTOR PETROLER6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
MECANICO AUTOMOTRIZ "C" (SECTOR PETROLER6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
MECANICO AYUDANTE (SECTOR PETROLERO)6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
INSTRUMENTISTA AYUDANTE (SECTOR PETROLER6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
INSTRUMENTISTA DE MATENIMIENTO A (SECT P6,822.8134,114.069,551.9417,466.4044,100.00105,232.40
INSTRUMENTISTA DE MANTENIMIENTO B (SECT 6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
INSTRUMENTISTA DE MANTENIMIENTO C (SECT 6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
MECANICO DE REFRIGERACION "A" (SECT PETR6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
MECANICO DE REFRIGERACION "B" (SECT PETR6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
MECANICO DE REFRIGERACION "C" (SECT PETR6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
MECANICO DE REFRIGERACION AYUD (SECT PET6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
MOLDEADOR DE PARAFINA (SECTOR PETROLERO)6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
MOTORISTA (SECTOR PETROLERO)6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
MOTORISTA REMOLCADOR (SECTOR PETROLERO)6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
OBRERO (SECTOR PETROLERO)6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
OBRERO DE COMEDOR (SECTOR PETROLERO)6,809.8634,049.289,533.8017,433.2344,100.00105,116.31
OBRERO DE SISMOGRAFO (SECTOR PETROLERO)6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
OBRERO DE TALADRO (SECTOR PETROLERO)6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
OFICIAL IMPERMEABILIZADOR "A" (SECTOR PE6,822.8134,114.069,551.9417,466.4044,100.00105,232.40
OPERADOR EQUIPO LIMPIAR POZOS (SEC PETRO6,822.8134,114.069,551.9417,466.4044,100.00105,232.40
OPERADOR EQUIPO LIMP. POZOS AYUD. (SEC P6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
OPERADOR DE GRUA PESADA MOVIBLE (SECT PE6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
OPER. INST. AGRIMENSURA "A" (SECTOR PETR6,818.9234,094.609,546.4917,456.4344,100.00105,197.52
OPER. INST. AGRIMENSURA "B" (SECTOR PETR6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
OPER. MOV. PETROLEO (SECTOR PETROLERO)6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
OPERADOR DE PLANTA "A" (SECTOR PETROLERO6,822.8134,114.069,551.9417,466.4044,100.00105,232.40
OPERADOR DE PLANTA "B" (SECTOR PETROLERO6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
OPERADOR RETROEXCAVADORA/CARGADORA (SECT6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
OPERADOR DE TRACTOR DE CADENAS (SECT PET6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
OPERADOR TRACTOR PLUMA LATER. SIDEBOOM 6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
OPERADOR DE PRODUCCION "A" (SECTOR PETRO6,822.8134,114.069,551.9417,466.4044,100.00105,232.40
OPERADOR DE PRODUCCION "B" (SECTOR PETRO6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
OPERADOR DE PRODUCCION "C" (SECTOR PETRO6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
OPERADOR DE PRODUCCION "D" (SECTOR PETRO6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
OPERADOR DE PRODUCCION "E" (SECTOR PETRO6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
OPERADOR DE REFINACION "A" (SECTOR PETRO6,822.8134,114.069,551.9417,466.4044,100.00105,232.40
OPERADOR DE REFINACION "B" (SECTOR PETRO6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
OPERADOR DE REFINACION "C" (SECTOR PETRO6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
OPERADOR DE REFINACION "D" (SECTOR PETRO6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
OPERADOR DE REFINACION "E" (SECTOR PETRO6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
MECANICO DE MANTENIMIENTO "A" (SECTOR PE6,822.8134,114.069,551.9417,466.4044,100.00105,232.40
MECANICO DE MANTENIMIENTO "B" (SECTOR PE6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
MECANICO DE MANTENIMIENTO "C" (SECTOR PE6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
MECANICO DE MANTENIMIENTO AYUD. (SECTOR 6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
OPERADOR DE EQUIPOS "A" (SECTOR PETROLER6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
OPERADOR DE EQUIPOS "B" (SECTOR PETROLER6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
OPERADOR DE EQUIPOS "C" (SECTOR PETROLER6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
OPERADOR DE GRUA FLOTANTE "A" (SECTOR PE6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
OPERADOR DE GRUA FLOTANTE "B" (SECTOR PE6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
OPERADOR DE GRUA PESADA (SECTOR PETROLER6,822.8134,114.069,551.9417,466.4044,100.00105,232.40
OPERARIO "A" (SECTOR PETROLERO)6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
OPERARIO "B" (SECTOR PETROLERO)6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
OPERADOR EQUIP. MOVER TIERRA "A" (SECT P6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
OPERADOR EQUIP. MOVER TIERRA "B" (SECT P6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
OPERADOR EQUIP. MOVER TIERRA "C" (SECT P6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
PATRON (SECTOR PETROLERO)6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
PATRON DE LANCHA REMOLCADOR (SECTOR PETR6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
PERFORADOR (SECTOR PETROLERO)6,822.8134,114.069,551.9417,466.4044,100.00105,232.40
PERFORADOR AYUDANTE (SECTOR PETROLERO)6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
PINTOR "A" (SECTOR PETROLERO)6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
PINTOR "B" (SECTOR PETROLERO)6,813.5734,067.839,538.9917,442.7344,100.00105,149.56
PLOMERO (SECTOR PETROLERO)6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
PLOMERO AYUDANTE (SECTOR PETROLERO)6,813.5734,067.839,538.9917,442.7344,100.00105,149.56
REPAR. EQUIPO COMUNICACION "A" (SECT. PE6,822.8134,114.069,551.9417,466.4044,100.00105,232.40
REPAR. EQUIPO COMUNICACION "B" (SECT. PE6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
REPAR. EQUIPO COMUNICACION "C" (SECT. PE6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
REPAR. EQUIPO COMUNICACION AYUD. (SECT. 6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
REPARADOR DE POZO DE PRODUCCION (SECT PE6,822.8134,114.069,551.9417,466.4044,100.00105,232.40
REVISOR DE POZO DE PRODUCCION (SECTOR PE6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
SOLDADOR "A" (SECTOR PETROLERO)6,822.8134,114.069,551.9417,466.4044,100.00105,232.40
SOLDADOR "B" (SECTOR PETROLERO)6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
SOLDADOR "C" (SECTOR PETROLERO)6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
SOLDADOR AYUDANTE (SECTOR PETROLERO)6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
SOPLADOR/SAMBLASISTA (SECTOR PETROLERO)6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
TIMONEL (SECTOR PETROLERO)6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
VIGILANTE "A" (SECTOR PETROLERO)6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
VIGILANTE "B" (SECTOR PETROLERO)6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
MANTENEDOR INST. DE REFINIRIA (SECTOR PE6,815.7034,078.489,541.9717,448.1844,100.00105,168.63
OPERADOR EQUIPO LIMP. POZOS "B" (SEC PET6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
OPERADOR DE VIBROCOMPACTADORA (SECT PETR6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
OPER. DE MOVIMIENTO DE PETROLEO (SECTOR 6,821.3534,106.769,549.8917,462.6644,100.00105,219.32
OPERADOR DE PAVIMENTADORA (SECTOR PETROL6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
OPERARIO PROYECTISTA REFRACTARIO (SECT P6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
OPERADOR DE PLANTA "C" (SECTOR PETROLERO6,819.4734,097.339,547.2517,457.8444,100.00105,202.42
OPERADOR DE PLANTA "D" (SECTOR PETROLERO6,818.4334,092.169,545.8117,455.1944,100.00105,193.16
OPERADOR DE PLANTA "E" (SECTOR PETROLERO6,816.9734,084.869,543.7617,451.4544,100.00105,180.08
PERFORADOR SISMOGRAFO MECANIZADO (SECT P6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
REPARADOR CABLE SISMOGRAFICO (SEC PETROL6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
PERFORADOR SISMOGRAFO PORTATIL (SECT PET6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
TAQUEADOR (SECTOR PETROLERO)6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
TUBERO FABRICADOR AYUDANTE (SECTOR PETRO6,814.3034,071.489,540.0217,444.6044,100.00105,156.10
OPER. DE REFINACION "A" (SECTOR PETROLER6,402.1332,010.648,962.9816,389.4544,100.00101,463.06
OPER. DE REFINACION "B" (SECTOR PETROLER6,402.1332,010.648,962.9816,389.4544,100.00101,463.06
OPER. DE REFINACION "C" (SECTOR PETROLER6,402.1332,010.648,962.9816,389.4544,100.00101,463.06
OPER. DE REFINACION "D" (SECTOR PETROLER6,402.1332,010.648,962.9816,389.4544,100.00101,463.06
OPERADOR DE GRUA BRAZO ARTICULADO (SEC P6,819.4734,097.339,547.2517,457.8444,100.00105,202.42

Con este programa calcule y pague El Salario Semanal según el Contrato Colectivo de la Construcción y el aumento vigente, pague lo justo, ni más, ni menos, no peque de tonto, ni de vivo Con este grupo de programas realizados en hojas de Cálculo de Excel puede convertirse en un experto en Cálculo de Prestaciones Sociales.

¿Qué hace este programa de cálculo de Salario Semanal

1) Calcula Salario Semanal.
2)Calcula las Horas extras.
3)Calcula el Dia  de descanso trabajado.
4)Calcula el acumulado de vacaciones de esa Semana laborada.
5)Calcula el acumulado de Utilidades de esa Semana laborada.
6)Calcula el acumulado de Antiguedad de esa Semana laborada.
7) Calcula la cesta Ticket
8)calcula el bono de asistencia
9) Emite un informe, el cual puede utilizar como sobre de pago listo de imprimir

¿Como funcionan estos programa de cálculo de Salarios Semanales

El programa consta de 5 hojas, la 1ra hoja es para introducir datos, está aprovisionada de botoneras que le minimizan la tarea, más del 90% de los datos a introducir en esta hoja son seleccionados mediante un botón. A mano solamente va a introducir fechas de comienzo, fin y pago, datos del patrono y trabajador. Esta actividad no debería llevarle más de 5 minutos con sobres en la mano.

¿Puedo personalizar el programa?

El programa tiene datos identificativos de nuestro Escritorio Jurídico tales como: El logo, nombre del abogado y del calculista, estas celdas están libres y en ellas usted puede colocar datos que lo identifiquen como profesional o relativos a su empresa.

¿El Programa se puede modificar?

Este programa lo entregamos sin clave, el usuario puede modificar fórmulas, si usted tiene capacidad para modificar y/o necesita modificar alguna fórmulas, Hágalo

¿El Programa se puede actualizar?

El programa tiene hojas ocultas donde se pueden actualizar los salarios y otras prestaciones, si tiene tiempo, capacidad y paciencia puede hacerlo. El programa siempre lo suministramos actualizado y cada vez que se requiera se actualiza