hoja de calculo - volumen de represa

3
Z COTA VOLUMEN 0 3949 0.19 2.85 0.000 1 3950 923.25 13,387.13 0.013 2 3951 4,365.86 58,939.11 0.059 3 3952 9,201.64 115,020.50 0.115 4 3953 11,731.00 134,906.50 0.135 5 3954 12,837.62 134,795.01 0.135 6 3955 13,207.17 125,468.12 0.125 7 3956 13,434.44 114,192.74 0.114 8 3957 14,950.50 112,128.75 0.112 9 3958 21,534.98 139,977.37 0.140 10 3959 33,224.31 182,733.71 0.183 11 3960 28,321.03 127,444.64 0.127 12 3961 32,600.43 114,101.51 0.114 13 3962 37,270.86 93,177.15 0.093 14 3963 29,823.94 44,735.91 0.045 15 3964 33,299.05 16,649.53 0.017 1,527,660.50 1.528 296,726.27 296,726.93 ALTURA DE REPRESA AREA ACUMULADA VOLUMEN ACUMULADO MILLONES DE M3 3940 3945 3950 3955 3960 3965 3970 Column C 0 0 0 3940 3945 3950 3955 3960 3965 3970 f(x) = − 235.452338028628 x² + 53.5500030385124 x + 3954.15094386161 R² = 0.0445229310063648 Column C Polynomial (Column C)

Upload: cosme-segovia

Post on 18-Dec-2015

20 views

Category:

Documents


11 download

DESCRIPTION

Hoja de Calculo - Volumen de Represa

TRANSCRIPT

Hoja1ZALTURA DE REPRESACOTAAREA ACUMULADAVOLUMENVOLUMEN ACUMULADO MILLONES DE M3039490.192.850.00013950923.2513,387.130.013239514,365.8658,939.110.059339529,201.64115,020.500.1154395311,731.00134,906.500.1355395412,837.62134,795.010.1356395513,207.17125,468.120.1257395613,434.44114,192.740.1148395714,950.50112,128.750.1129395821,534.98139,977.370.14010395933,224.31182,733.710.18311396028,321.03127,444.640.12712396132,600.43114,101.510.11413396237,270.8693,177.150.09314396329,823.9444,735.910.04515396433,299.0516,649.530.0171,527,660.501.528296,726.27296,726.93

ALTURA VOLUMEN

ALTURA DE REPRESACOTAAREA ACUMULADADIFERENCIA DE COTASVOLUMENVOLUMEN ACUMULADOVOLUMEN MILLONES DE M3VOL. ACUMULADO Mm303949.00.19 m21.000.00 m30.000 m30.000 Mm30.000 Mm313950.0923.44 m21.00312.29 m3312.292 m30.000 Mm30.000 Mm323951.05,289.30 m21.002,807.60 m33,119.891 m30.003 Mm30.003 Mm333952.014,490.94 m21.009,511.69 m312,631.579 m30.010 Mm30.013 Mm343953.026,221.94 m21.0020,068.66 m332,700.235 m30.020 Mm30.033 Mm353954.039,059.56 m21.0032,428.30 m365,128.534 m30.032 Mm30.065 Mm363955.052,266.73 m21.0045,503.14 m3110,631.675 m30.046 Mm30.111 Mm373956.065,701.17 m21.0058,856.04 m3169,487.714 m30.059 Mm30.169 Mm383957.080,651.67 m21.0073,048.82 m3242,536.529 m30.073 Mm30.243 Mm393958.0102,186.65 m21.0091,207.05 m3333,743.583 m30.091 Mm30.334 Mm32.000.005000ERROR:#VALUE!103959.0135,410.96 m21.00118,409.74 m3452,153.318 m30.118 Mm30.452 Mm3113960.0163,731.99 m21.00149,347.53 m3601,500.851 m30.149 Mm30.602 Mm3123961.0196,332.42 m21.00179,785.73 m3781,286.578 m30.180 Mm30.781 Mm3133962.0233,603.28 m21.00214,698.09 m3995,984.672 m30.215 Mm30.996 Mm3143963.0263,427.22 m21.00248,365.99 m31,244,350.657 m30.248 Mm31.244 Mm3153964.0296,726.27 m21.00279,911.64 m31,524,262.297 m30.280 Mm31.524 Mm3163965.0356,667.59 m21.00326,237.72 m31,850,500.013 m30.326 Mm31.851 Mm3173966.0383,488.43 m21.00369,996.99 m32,220,497.003 m30.370 Mm32.220 Mm3TOTAL2,220,497.002.220 Mm3