programacion11

Embed Size (px)

DESCRIPTION

programación de obra

Citation preview

Hoja1ActividadesCuadrillaPresupuesto (%)1255023.00VALORIZACION 1VALORIZACION 2VALORIZACION 3VALORIZACION 4VALORIZACION 5VALORIZACION 6VALORIZACION 79/8/159/9/159/10/159/8/159/8/159/9/159/8/159/9/15CapatazOperarioOficial PeonM1M2MetradoProduccionDiasDias corregidosN de cuadrillasPresupuesto(S/.)123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596A0.100.51101502759.3880.56275.12B10627.5115627.5115627.5115627.5115627.5115627.5115627.5115627.5115627.5115627.5115B0.521222150115010150.22510.05A10251.0046251.0046251.0046251.0046251.0046251.0046251.0046251.0046251.0046251.0046C0.300.511015011501510112550.23C15836.682836.682836.682836.682836.682836.682836.682836.682836.682836.682836.682836.682836.682836.682836.682D0.52240170710101562751.15D106275.1156275.1156275.1156275.1156275.1156275.1156275.1156275.1156275.1156275.115E0.3211001407205410125502.30E525100.4625100.4625100.4625100.4625100.46F0.321100210730568100401.84F520080.36820080.36820080.36820080.36820080.368G0.6224011562.52.5110125502.30K1125502.3H0.622402135622.57.5335439258.05I587851.6187851.6187851.6187851.6187851.61I0.422401100425552.531375.58L215687.787515687.7875J0.422401100425552.531375.58J56275.1156275.1156275.1156275.1156275.115K0.2111006120.50.51112550.23G62091.7052091.7052091.7052091.7052091.7052091.705L0.21110040202210.56275.1223137.55753137.5575M0.4211006506108.3310.8310562751.15N512550.2312550.2312550.2312550.2312550.23N0.41100010042555112550.23M111140.931140.931140.931140.931140.931140.931140.931140.931140.931140.931140.930.62120050510252.6533258.11H84157.26368754157.26368754157.26368754157.26368754157.26368754157.26368754157.26368754157.2636875O0.321100480.50.51675301.38P135792.41384615385792.41384615385792.41384615385792.41384615385792.41384615385792.41384615385792.41384615385792.41384615385792.41384615385792.41384615385792.41384615385792.41384615385792.4138461538P0.3110006506108.3313.548112550.23O112550.23I0.422401100425552.531375.58I56275.1156275.1156275.1156275.1156275.115L0.21110040202210.56275.12L23137.55753137.5575J0.422401100425552.531375.58J56275.1156275.1156275.1156275.1156275.1150.62120050510252.6533258.11216629.0547516629.05475CorreccinCapataz7.57.57.57.57.57.57.57.57.57.50.80.80.80.80.80.80.80.80.80.83333333333333330.50.50.50.50.50.50.50.50.50.53.25.25.2552.62.62.62.62.62.64.84.87.87.87.87.87.85.8A0.804880Operario30.030.030.030.030.030.030.030.030.030.00.00.00.00.00.00.00.00.00.00.0000000000000000222222222221313130301212121212121616313131313126B7.53015303030Oficial15.015.015.015.015.015.015.015.015.015.04.04.04.04.04.04.04.04.04.04.0555555555555555222222222211212120201212121212121111212121212116C30510100Pen30.030.030.030.030.030.030.030.030.030.08.08.08.08.08.08.08.08.08.08.0101010101010101010101010101010444444444411313130302424242424242222222222222222D0.522401M130.030.030.030.030.030.030.030.030.030.08.08.08.08.08.08.08.08.08.08.010101010101010101010101010101000000000000000000000000000000E1.284400M230.030.030.030.030.030.030.030.030.030.00.00.00.00.00.00.00.00.00.00.000000000000000011111111110555566666666666666F1.8126600G0.622401CD1255023.007028.12886777.124232630.598870149.28153150.837149567.14661538535719.8853846154H1.8661206CIG.G. (10%)125502.3702.81288677.712423263.059887014.92815315.083714956.71466153853571.9885384615I210102005UTILIDAD62751.15351.40644338.856211631.529943507.4647657.541857478.35733076921785.9942692308J210102005CT1443276.458082.348127793.6928337525.18771000671.672176123.46255172002.21860769241077.8681923077K0.211100IGV(18%)259789.7611454.82266161402.86470946754.533786180120.9009631702.22325930960.39934938467394.0162746154L0.211100CTOTAL1703066.219537.17078169196.557539444279.7214861180792.57296207825.685809202962.61795707748471.8844669231M420101000N255000% AVANCE PARCIAL0.56%0.54%2.60%69.33%12.20%11.92%2.85%31051000% AVANCE ACUMULADO0.56%1.10%3.70%73.03%85.24%97.15%100.00%O0.321100P2.488000I210102005L0.211100J21010200531051000

CURVA S

VALORIZACION 1VALORIZACION 2VALORIZACION 3VALORIZACION 4VALORIZACION 5VALORIZACION 6PROGRAMADOCT8082.348127793.6928337525.18771000671.672176123.46255172002.21860769241077.8681923077% PARCIAL0.56%0.54%2.60%69.33%12.20%11.92%2.85%% ACUMULADO0.56%1.10%3.70%73.03%85.24%97.15%100.00%EJECUTADOCT% PARCIAL% ACUMULADOADELANTORETRASADO