Trial

Preview:

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