Calculo Del ICA
17
Muestra Temperatura Solidos totales Disueltos pH DatosI Temperatura wi q*wi Datos I wi Q*wi Datos I 1 26.7 33.102 ### 4.855 50.5 ### ### 11.02 7.8 100 2 26.9 31.310 ### 4.592 48.7 ### ### 11.13 7.8 100 3 26.1 38.320 ### 5.620 48.4 ### ### 11.14 8.1 ### 4 27.4 26.717 ### 3.918 48.3 ### ### 11.15 8 100 5 26.9 31.310 ### 4.592 67.3 ### ### 10.08 8 100 6 26 39.167 ### 5.744 66.4 ### ### 10.13 7.6 100 7 26 39.167 ### 5.744 68.3 ### ### 10.03 8 100 8 26.8 32.209 ### 4.724 67.8 ### ### 10.06 7.8 100 9 24.7 49.594 ### 7.274 77.9 ### ### 9.532 7.9 100 10 26.7 33.102 ### 4.855 66.5 ### ### 10.13 7.7 100 11 25.9 40.007 ### 5.868 67.5 ### ### 10.07 8 100 12 27.6 24.833 ### 3.642 77.6 ### ### 9.547 7.5 100 13 28.1 20.007 ### 2.934 79.5 ### ### 9.452 7.6 100 14 28.3 18.030 ### 2.644 81.3 ### ### 9.362 8 100 15 28.4 17.031 ### 2.498 117.2 ### ### 7.741 8.2 ### 16 21.2 72.457 ### 10.627 83.4 ### ### 9.259 8.1 ### 17 22.3 66.070 ### 9.690 106.8 ### ### 8.179 7.4 100 18 21.4 71.349 ### 10.465 102.9 ### ### 8.35 7.6 100 19 22 67.883 ### 9.956 102.8 ### ### 8.355 8 100 20 22.5 64.831 ### 9.509 141.9 ### ### 6.792 7.7 100 Parametro Ponderacion Datos Ponderacion calculada Temperatura 0.1 OK 0.147 Solidos Totales disueltos 0.07 OK 0.117 pH 0.11 OK 0.157 Oxigeno Disuelto 0.17 OK 0.217 Coliformes Fecales 0.16 OK 0.207 DBO 0.11 OK 0.157 Fosfatos Totales 0.1 0.28 - Nitratos 0.1 - Turbidez 0.08 - 1 1.000 ICA 59.862 Calidad Media ICA CALIDAD 91 - 100 EXCELENTE 71 - 90 BUENA 51 - 70 MEDIA 26 - 50 MALA
-
Upload
georgina-alejandra-romano -
Category
Documents
-
view
1 -
download
0
description
Calculo del indice de calidad de agua del Río Parana
Transcript of Calculo Del ICA
Hoja1MuestraTemperaturaSolidos totales DisueltospHTurbidezOxigeno DisueltoColiformes fecalesDBOICADatosI Temperaturawiq*wiDatosIwiQ*wiDatosIwiQ*wiDatosIwiQ*wiDatosIwiq*wiDatosIwiq*wiDatosIwiq*wi126.733.1020.1474.85550.594.4670.11711.02112159237.81000.15715.666666666797.76.466.3730.21714.381120031.3250.2076.474536.9140.1575.78358.181226.931.3100.1474.59248.795.3720.11711.12669551677.81000.15715.66666666671036.669.1070.21714.973136826.5180.2075.480354.9940.1578.61660.455326.138.3200.1475.62048.495.5230.11711.14438923288.194.9450.15714.8753513.718.4960.2174.00766953.0410.20710.962155.0300.1570.78847.397427.426.7170.1473.91848.395.5740.11711.150293388581000.15715.66666666674074.840.4670.2178.7682800100.2072.067267.1240.15710.51652.086526.931.3100.1474.59267.386.4240.11710.082818941481000.15715.6666666667414544.0980.2179.55543067.2280.20713.894267.1240.15710.51664.30662639.1670.1475.74466.486.8370.11710.13099669087.61000.15715.6666666667584.228.9030.2176.26296539.5470.2078.173267.1240.15710.51656.49472639.1670.1475.74468.385.9680.11710.029556768681000.15715.666666666737.55.755.9220.21712.1162300100.2072.067267.1240.15710.51656.140826.832.2090.1474.72467.886.1960.11710.05615259247.81000.15715.666666666747.711.7100.9530.21721.873115032.9180.2076.803536.9140.1575.78364.906924.749.5940.1477.27477.981.7060.1179.53234067217.91000.15715.666666666745.16.263.5270.21713.76452561.1830.20712.64538.110.0000.1571.56760.4481026.733.1020.1474.85566.586.7910.11710.12563225967.71000.15715.6666666667323.820.6330.2174.47191241.6810.2078.614536.9140.1575.78349.5151125.940.0070.1475.86867.586.3330.11710.072143926881000.15715.66666666672566.263.5270.21713.764120031.3250.2076.474724.7780.1573.88255.7271227.624.8330.1473.64277.681.8360.1179.54749903877.51000.15715.66666666671439.797.1510.21721.04949962.7810.20712.975536.9140.1575.78368.6641328.120.0070.1472.93479.581.0160.1179.45190157797.61000.15715.66666666679.193.8240.21720.32915987.9580.20718.1787.124.2890.1573.80570.3651428.318.0300.1472.64481.380.2480.1179.36221867681000.15715.666666666710.6100.2490.21721.72120883.7860.20717.316536.9140.1575.78372.4931528.417.0310.1472.498117.266.3520.1177.74106308338.290.1450.15714.122658212811.2101.0530.21721.89511591.8820.20718.989354.9940.1578.61673.8611621.272.4570.14710.62783.479.3600.1179.25866355238.194.9450.15714.87464213584.432.8700.2177.12218485.8040.20717.733536.9140.1575.78365.3981722.366.0700.1479.690106.870.1090.1178.17942876827.41000.15715.66666666674.534.8110.2177.5422304100.2072.067267.1240.15710.51653.6621821.471.3490.14710.465102.971.5730.1178.35014203117.61000.15715.6666666667544.0980.2179.5552040100.2072.067267.1240.15710.51656.619192267.8830.1479.956102.871.6110.1178.354565830281000.15715.66666666676.770.4320.21715.2602400100.2072.06733.2100.1571.56752.8712022.564.8310.1479.509141.958.2150.1176.79180146887.71000.15715.6666666667544.0980.2179.55563055.1320.20711.394630.2440.1574.73857.654ParametroPonderacionDatosPonderacion calculadaMax73.861Temperatura0.1OK0.147Min47.397Solidos Totales disueltos0.07OK0.117pH0.11OK0.157Oxigeno Disuelto0.17OK0.217Coliformes Fecales0.16OK0.207DBO0.11OK0.157Fosfatos Totales0.10.28-Nitratos0.1-Turbidez0.08-11.000ICA59.862Calidad MediaICACALIDAD91 - 100EXCELENTE71 - 90BUENA51 - 70MEDIA26 - 50MALA0 - 25MUY MALA
Hoja1
MESValor del ICA
I TemperaturaTI02.00410011.96610021.92810031.88910041.85110051.81310061.77510071.73710081.69810091.660100101.622100111.584100121.54699.683131.50798.834141.46997.499151.43195.667161.39393.326171.35590.462181.31687.064191.27883.120201.24078.617211.20273.542221.16467.883231.12561.629241.08754.766251.04947.283261.01139.167270.97330.405280.93420.986290.89610300.85810
I Temperatura
TemperaturaValor de I
I ODFuente:http://www.unipamplona.edu.co/unipamplona/portalIG/home_10/recursos/general/pag_contenido/libros/06082010/icatest_capitulo3.pdfODI0101102103103.310424.824544.098660.569774.239885.106993.1721098.43510.51001110012100
I OD
ODValor de I
I pHpHI110210310421.0412535.3928659.5331710081009100.595210100.354311100.2109121013101410
I pH
pHValor de I
I Solitos totalesSTI ST0100101002010030100401005094.71710072.68015055.77120042.79525032.83928028.0143001035010400104501050010
I Solitos totales
STValor I
I Coliformes fecalesCFI098509810093.25920084.45430076.48040069.25950062.71960056.79770051.43580046.57890042.181100038.198110034.591120031.325130028.368140025.689150023.264160021.067170010180010190010200010210010220010230010240010250010260010270010280010290010300010
I Coliformes fecales
Coliformes fecalesValor I
I DBODBOI0100.000181.929267.124354.994445.056536.914630.244724.778820.3019101010
I DBO
DBOValor de I
MBD0005F8A1.unknown
MBD0008EA96.unknown
MBD0009C4E0.unknown
MBD0006E48E.unknown
MBD0001198D.unknown
MBD0004F0FF.unknown
MBD000448E4.unknown
