11
FAMILIA TIPO DE DESASTRE REGION HABITANTES CASEN Rodriguez Volcan 10 125000 2.9 Moran Aluvion 3 121000 3.2 Toledo Maremoto 7 124365 3.5 Gonzalez Maremoto 7 124365 3.8 Jeria Maremoto 7 124365 4.1 Jerez Maremoto 9 265000 4.4 Perez Aluvion 2 681000 4.7 Gutierrez Volcan 9 467200 5 Casas Aluvion 10 253400 5.3 Alvarez Volcan 3 253900 5.6 Quintero Maremoto 10 254400 5.9 Quitral Volcan 7 254900 6.2 Quintana Aluvion 7 255400 6.5 Peñailillo Maremoto 9 255900 6.8 Escobar Maremoto 2 256400 7.1 Marin Maremoto 9 256900 7.4 Martinez Maremoto 7 257400 7.7 Rivera Aluvion 7 257900 8 Caceres Volcan 9 258400 8.3 Astete Aluvion 2 258900 8.6 Opazo Volcan 10 259400 8.9 Jordan Maremoto 9 259900 9.2 Leiva Volcan 3 294000 9.5 Andrade Aluvion 7 328100 9.8 Aguilar Maremoto 7 362200 10.1 Rivas Maremoto 7 396300 10.4 Jadue Maremoto 9 430400 10.7 Cornejo Maremoto 3 464500 11 Rojas Aluvion 2 498600 11.3 Ramirez Volcan 10 532700 11.6 Vergara Aluvion 3 566800 11.3 Sanchez Volcan 10 600900 11 Jurado Maremoto 2 635000 10.7 Aguilera Maremoto 7 737300 9.8 Contreras Maremoto 9 805500 9.2 Albornoz Maremoto 3 839600 8.9 Gatica Aluvion 7 873700 8.6 Delgado Volcan 10 907800 8.3 Cuevas Volcan 9 976000 7.7 Reyes Maremoto 3 1010100 7.4 Alaluf Aluvion 2 1044200 7.1 Vallejo Maremoto 3 1112400 6.5 Curubeto Maremoto 2 1180600 7.3 Correa Volcan 1 1248800 8.0999999999999 Aedo Aluvion 3 1282900 8.4999999999999

Trial

  • Upload
    brandon

  • View
    212

  • Download
    0

Embed Size (px)

DESCRIPTION

tablas dinamicas

Citation preview

DatosFAMILIATIPO DE DESASTREREGIONHABITANTESCASENDAOSESTADO DECLARADOPRIORIDADSUBSIDIORodriguezVolcan101250002.9$ 4,180,000ExcepcionNADA300000Estado DeclaradoSuma CasenCantidad HabitantesPromedio CasenMoranAluvion31210003.2$ 4,530,000Alerta amarillaNADA300000Excepcion179.8136826657.82ToledoMaremoto71243653.5$ 4,880,000Alerta naranjaNO IMPORTANTE200000Alerta roja71.653317657.96GonzalezMaremoto71243653.8$ 5,230,000Alerta RojaNO IMPORTANTE200000Alerta naranja64.838086658.10JeriaMaremoto71243654.1$ 5,580,000ExcepcionNO IMPORTANTE200000Alerta amarilla69.752823008.31JerezMaremoto92650004.4$ 5,930,000ExcepcionNO IMPORTANTE200000PerezAluvion26810004.7$ 6,280,000ExcepcionNADA300000GutierrezVolcan94672005$ 6,630,000Alerta amarillaNADA300000CasasAluvion102534005.3$ 6,980,000Alerta naranjaNADA200000FamiliaCASENHabitantesTipo de desastreAlvarezVolcan32539005.6$ 7,330,000Alerta RojaNADA350000Moran3.2121000AluvionQuinteroMaremoto102544005.9$ 7,680,000ExcepcionNO IMPORTANTE200000QuitralVolcan72549006.2$ 8,030,000ExcepcionNADA300000QuintanaAluvion72554006.5$ 8,380,000ExcepcionNADA200000Subsidio por ReginPeaililloMaremoto92559006.8$ 8,730,000Alerta amarillaNO IMPORTANTE2000001 a 45 a 10EscobarMaremoto22564007.1$ 9,080,000Alerta naranjaIMPORTANTE300000Aluvion$ 300,000$ 200,000MarinMaremoto92569007.4$ 9,430,000Alerta RojaNO IMPORTANTE200000Volcan$ 350,000$ 300,000MartinezMaremoto72574007.7$ 9,780,000ExcepcionNO IMPORTANTE200000Maremoto$ 280,000$ 420,000RiveraAluvion72579008$ 10,130,000ExcepcionNADA200000CaceresVolcan92584008.3$ 9,900,000ExcepcionNADA300000AsteteAluvion22589008.6$ 9,670,000Alerta amarillaNADA300000OpazoVolcan102594008.9$ 9,440,000Alerta naranjaNADA300000JordanMaremoto92599009.2$ 9,210,000Alerta RojaNO IMPORTANTE200000LeivaVolcan32940009.5$ 8,980,000ExcepcionNADA350000AndradeAluvion73281009.8$ 8,750,000ExcepcionNADA200000AguilarMaremoto736220010.1$ 8,520,000Alerta naranjaNO IMPORTANTE200000RivasMaremoto739630010.4$ 8,290,000Alerta RojaNO IMPORTANTE200000JadueMaremoto943040010.7$ 8,060,000Alerta amarillaNO IMPORTANTE200000CornejoMaremoto346450011$ 7,830,000ExcepcionIMPORTANTE300000Rojas Aluvion249860011.3$ 7,600,000Alerta amarillaNADA300000RamirezVolcan1053270011.6$ 7,370,000Alerta naranjaNADA300000VergaraAluvion356680011.3$ 7,140,000Alerta RojaNADA300000SanchezVolcan1060090011$ 6,910,000ExcepcionNADA300000JuradoMaremoto263500010.7$ 6,680,000ExcepcionIMPORTANTE300000AguileraMaremoto77373009.8$ 6,578,000Alerta naranjaNO IMPORTANTE200000ContrerasMaremoto98055009.2$ 7,294,000ExcepcionNO IMPORTANTE200000AlbornozMaremoto38396008.9$ 7,652,000ExcepcionIMPORTANTE300000GaticaAluvion78737008.6$ 8,010,000ExcepcionNADA200000DelgadoVolcan109078008.3$ 8,368,000Alerta amarillaNADA300000CuevasVolcan99760007.7$ 9,084,000Alerta RojaNADA300000ReyesMaremoto310101007.4$ 9,442,000ExcepcionIMPORTANTE300000AlalufAluvion210442007.1$ 9,800,000ExcepcionNADA300000VallejoMaremoto311124006.5$ 10,516,000Alerta amarillaIMPORTANTE300000CurubetoMaremoto211806007.3$ 11,232,000Alerta RojaIMPORTANTE300000CorreaVolcan112488008.1$ 11,948,000ExcepcionNADA350000AedoAluvion312829008.5$ 12,306,000Alerta naranjaNADA300000RuizVolcan1013170008.9$ 12,664,000Alerta RojaNADA300000GaeteMaremoto813511009.3$ 13,022,000Alerta amarillaNO IMPORTANTE200000GarayVolcan613852009.7$ 13,380,000ExcepcionNADA300000AravenaVolcan5141930010.1$ 13,738,000ExcepcionNADA300000

Tabla Dinmica 1Promedio de CASENEtiquetas de columnaEtiquetas de fila1235678910Total generalAluvion7.937.678.235.307.74Maremoto8.378.457.069.307.955.907.78Volcan8.107.5510.109.706.207.008.608.12Total general8.108.117.9910.109.707.389.307.637.857.88

Grfico Dinmico 1Etiquetas de filaSuma de DAOSAluvion99576000Maremoto180646000Volcan137952000Total general418174000