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