calculos excel trabajo colaborativo nev 20 nov

3

Click here to load reader

Upload: sgcconsultoriayproyectos

Post on 18-Dec-2015

228 views

Category:

Documents


0 download

DESCRIPTION

calculos materia y energia

TRANSCRIPT

CalInicialesDepartamentoBolivarMunicipioMunicipioPoblacin8,754Poblacin con servicios de saneamiento bsicoNo atendida550Atendida8,204% de cobertura de aseo93.72%Basura recolectadaPeriodoCantidadUnidadMes123.43Ton4.1143333333Semana30,858kgProduccin per cpitalppc0.5373337048

ProyeccionAoPoblacin(hab)ppckg/(hab*da)Cantidad de residuos slidosVolumen (m3)rea requerida (m2)Diaria(kg/da)Anual(Ton/ao)Acumulado(Ton)Residuos slidos compactosMaterial de cobertura(m3)Residuos estabilizados(m3/ao)Relleno sanitarioRellenoARTotal ATDiaria(m3)Anual(m3)Diaria(m3)Anual(m3)(m3)Acumulada08,7540.53733370484,7041,7171,717124,29228583,4344,2924,2921,7172,23218,7610.53733370484,7081,7183,435124,29628593,4374,2968,5883,4354,46628,7820.53733370484,7191,7225,158124,30628613,4454,30612,8945,1586,70538,7930.53733370484,7251,7256,882124,31128623,4494,31117,2056,8828,94748,8030.53733370484,7301,7278,609124,31628633,4534,31621,5218,60911,19158,8150.53733370484,7371,72910,337124,32228643,4584,32225,84410,33713,43968,8270.53733370484,7431,73112,069124,32828663,4624,32830,17212,06915,68978,8420.53733370484,7511,73413,803124,33528673,4684,33534,50713,80317,94488,8590.53733370484,7601,73715,540124,34428693,4754,34438,85115,54020,20298,8820.53733370484,7731,74217,282124,35528713,4844,35543,20617,28222,467108,8990.53733370484,7821,74519,028124,36328733,4914,36347,56919,02824,736Densidad de la basuraTipo de basuraNomenclaturaBajoAltoSueltaDs200300CompactaDc400500EstabilizadaDE500600

Hoja3