RecordatorioAutofiltroMenuDatosFiltroAutofiltroDatos:http://www.ine.cl/canales/chile_estadistico/home.php

LISTADO.1Graba el archivo con el siguiente nombre = 1406.NombreApellidoAl terminar enva el archivo a la profe = cecilia.tinoco@ucentral.clNOMBRE =Claudia InostrozaRUT (sin.digito)Grupo12,345,67810CUADRO 10.2: PERSONAS EN VIVIENDAS OCUPADAS Y POBLACION EN TRANSITO, SEGN DIVISION POLITICO ADMINISTRATIVA, AREA URBANA-RURAL, GRUPOS DE EDAD Y TIPO DE VIVIENDA.50%40%30%20%10%RegionAreaAosTipoTotPersonasPermanentesSemipermanentesOtrosViviendasColectivasPobl.en transito13Urbana y Rural14Casa1,201,882600,941480,753360,565240,376120,18813Urbana y Rural14Departamento218,263109,13287,30565,47943,65321,82613Urbana y Rural14Pieza en casa antigua20,15010,0758,0606,0454,0302,01513Urbana y Rural14Mejora, mediagua56,63128,31622,65216,98911,3265,66313Urbana y Rural14Rancho, choza7823913132351567813Urbana y Rural14Ruca7873943152361577913Urbana y Rural14Mvil126635038251313Urbana y Rural14Otro tipo de vivienda3,6781,8391,4711,10373636813Urbana y Rural14Colectiva3,6831,8421,4731,10573736813Urbana y Rural14Personas en trnsito3,6881,8441,4751,10673836913Urbana y Rural29Casa1,154,987577,494461,995346,496230,997115,49913Urbana y Rural29Departamento243,574121,78797,43073,07248,71524,35713Urbana y Rural29Pieza en casa antigua21,19510,5988,4786,3594,2392,12013Urbana y Rural29Mejora, mediagua41,97120,98616,78812,5918,3944,19713Urbana y Rural29Rancho, choza6683342672001346713Urbana y Rural29Ruca6733372692021356713Urbana y Rural29Mvil155786247311613Urbana y Rural29Otro tipo de vivienda3,7571,8791,5031,12775137613Urbana y Rural29Colectiva3,7621,8811,5051,12975237613Urbana y Rural29Personas en trnsito3,7671,8841,5071,13075337713Urbana y Rural29Ruca3,7721,8861,5091,13275437713Urbana y Rural29Mvil155786247311613Urbana y Rural29Otro tipo de vivienda3,7571,8791,5031,12775137613Urbana y Rural29Colectiva3,7621,8811,5051,12975237613Urbana y Rural29Personas en trnsito3,7671,8841,5071,13075337713Urbana y Rural44Casa1,131,689565,845452,676339,507226,338113,16913Urbana y Rural44Departamento243,717121,85997,48773,11548,74324,37213Urbana y Rural44Pieza en casa antigua20,77410,3878,3106,2324,1552,07713Urbana y Rural44Mejora, mediagua42,94421,47217,17812,8838,5894,29413Urbana y Rural44Rancho, choza8004003202401608013Urbana y Rural44Ruca8054033222421618113Urbana y Rural44Mvil2021018161402013Urbana y Rural44Otro tipo de vivienda3,9301,9651,5721,17978639313Urbana y Rural44Colectiva3,9351,9681,5741,18178739413Urbana y Rural44Personas en trnsito3,9401,9701,5761,18278839413Urbana y Rural59Casa747,195373,598298,878224,159149,43974,72013Urbana y Rural59Departamento138,03169,01655,21241,40927,60613,80313Urbana y Rural59Pieza en casa antigua8,5944,2973,4382,5781,71985913Urbana y Rural59Mejora, mediagua17,4968,7486,9985,2493,4991,75013Urbana y Rural59Rancho, choza6093052441831226113Urbana y Rural59Ruca6143072461841236113Urbana y Rural59Mvil142715743281413Urbana y Rural59Otro tipo de vivienda1,95797978358739119613Urbana y Rural59Colectiva1,96298178558939219613Urbana y Rural59Personas en trnsito1,96798478759039319713Urbana y Rural74Casa390,625195,313156,250117,18878,12539,06313Urbana y Rural74Departamento73,37736,68929,35122,01314,6757,33813Urbana y Rural74Pieza en casa antigua4,2992,1501,7201,29086043013Urbana y Rural74Mejora, mediagua7,9153,9583,1662,3751,58379213Urbana y Rural74Rancho, choza478239191143964813Urbana y Rural74Ruca483242193145974813Urbana y Rural74Mvil472419149513Urbana y Rural74Otro tipo de vivienda8854433542661778913Urbana y Rural74Colectiva8904453562671788913Urbana y Rural74Personas en trnsito8954483582691799013Urbana y Rural80Casa138,31569,15855,32641,49527,66313,83213Urbana y Rural80Departamento33,45616,72813,38210,0376,6913,34613Urbana y Rural80Pieza en casa antigua1,65782966349733116613Urbana y Rural80Mejora, mediagua2,3871,19495571647723913Urbana y Rural80Rancho, choza135685441271413Urbana y Rural80Ruca140705642281413Urbana y Rural80Mvil95432113Urbana y Rural80Otro tipo de vivienda27914011284562813Urbana y Rural80Colectiva28414211485572813Urbana y Rural80Personas en trnsito28914511687582913Urbana14Casa1,155,798577,899462,319346,739231,160115,58013Urbana14Departamento218,248109,12487,29965,47443,65021,82513Urbana14Pieza en casa antigua19,7039,8527,8815,9113,9411,97013Urbana14Mejora, mediagua53,02226,51121,20915,90710,6045,30213Urbana14Rancho, choza6763382702031356813Urbana14Ruca6813412722041366813Urbana14Mvil6734272013713Urbana14Otro tipo de vivienda3,5821,7911,4331,07571635813Urbana14Colectiva3,5871,7941,4351,07671735913Urbana14Personas en trnsito3,5921,7961,4371,07871835913Urbana29Casa1,117,692558,846447,077335,308223,538111,76913Urbana29Departamento243,562121,78197,42573,06948,71224,35613Urbana29Pieza en casa antigua20,73610,3688,2946,2214,1472,07413Urbana29Mejora, mediagua39,19719,59915,67911,7597,8393,92013Urbana29Rancho, choza5762882301731155813Urbana29Ruca5812912321741165813Urbana29Mvil102514131201013Urbana29Otro tipo de vivienda3,6611,8311,4641,09873236613Urbana29Colectiva3,6661,8331,4661,10073336713Urbana29Personas en trnsito3,6711,8361,4681,10173436713Urbana44Casa1,091,169545,585436,468327,351218,234109,11713Urbana44Departamento243,706121,85397,48273,11248,74124,37113Urbana44Pieza en casa antigua20,28110,1418,1126,0844,0562,02813Urbana44Mejora, mediagua40,23520,11816,09412,0718,0474,02413Urbana44Rancho, choza6623312651991326613Urbana44Ruca6673342672001336713Urbana44Mvil149756045301513Urbana44Otro tipo de vivienda3,8011,9011,5201,14076038013Urbana44Colectiva3,8061,9031,5221,14276138113Urbana44Personas en trnsito3,8111,9061,5241,14376238113Urbana59Casa723,382361,691289,353217,015144,67672,33813Urbana59Departamento138,02169,01155,20841,40627,60413,80213Urbana59Pieza en casa antigua8,3384,1693,3352,5011,66883413Urbana59Mejora, mediagua16,0768,0386,4304,8233,2151,60813Urbana59Rancho, choza455228182137914613Urbana59Ruca460230184138924613Urbana59Mvil97493929191013Urbana59Otro tipo de vivienda1,88694375456637718913Urbana59Colectiva1,89194675656737818913Urbana59Personas en trnsito1,89694875856937919013Urbana74Casa377,768188,884151,107113,33075,55437,77713Urbana74Departamento73,37436,68729,35022,01214,6757,33713Urbana74Pieza en casa antigua4,1172,0591,6471,23582341213Urbana74Mejora, mediagua7,2043,6022,8822,1611,44172013Urbana74Rancho, choza30515312292613113Urbana74Ruca31015512493623113Urbana74Mvil361814117413Urbana74Otro tipo de vivienda8584293432571728613Urbana74Colectiva8634323452591738613Urbana74Personas en trnsito8684343472601748713Urbana80Casa134,30567,15353,72240,29226,86113,43113Urbana80Departamento33,45516,72813,38210,0376,6913,34613Urbana80Pieza en casa antigua1,57578863047331515813Urbana80Mejora, mediagua2,1601,08086464843221613Urbana80Rancho, choza8744352617913Urbana80Ruca9246372818913Urbana80Mvil84322113Urbana80Otro tipo de vivienda27113610881542713Urbana80Colectiva27613811083552813Urbana80Personas en trnsito28114111284562813Rural14Casa46,08423,04218,43413,8259,2174,60813Rural14Departamento158653213Rural14Pieza en casa antigua447224179134894513Rural14Mejora, mediagua3,6091,8051,4441,08372236113Rural14Rancho, choza106534232211113Rural14Ruca111564433221113Rural14Mvil5930241812613Rural14Otro tipo de vivienda96483829191013Rural14Colectiva101514030201013Rural14Personas en trnsito106534232211113Rural29Casa37,29518,64814,91811,1897,4593,73013Rural29Departamento126542113Rural29Pieza en casa antigua459230184138924613Rural29Mejora, mediagua2,7741,3871,11083255527713Rural29Rancho, choza9246372818913Rural29Ruca97493929191013Rural29Mvil5327211611513Rural29Otro tipo de vivienda96483829191013Rural29Colectiva101514030201013Rural29Personas en trnsito106534232211113Rural44Casa40,52020,26016,20812,1568,1044,05213Rural44Departamento116432113Rural44Pieza en casa antigua493247197148994913Rural44Mejora, mediagua2,7091,3551,08481354227113Rural44Rancho, choza138695541281413Rural44Ruca143725743291413Rural44Mvil5327211611513Rural44Otro tipo de vivienda129655239261313Rural44Colectiva134675440271313Rural44Personas en trnsito139705642281413Rural59Casa23,81311,9079,5257,1444,7632,38113Rural59Departamento105432113Rural59Pieza en casa antigua25612810277512613Rural59Mejora, mediagua1,42071056842628414213Rural59Rancho, choza154776246311513Rural59Ruca159806448321613Rural59Mvil452318149513Rural59Otro tipo de vivienda7136282114713Rural59Colectiva7638302315813Rural59Personas en trnsito8141322416813Rural74Casa12,8576,4295,1433,8572,5711,28613Rural74Departamento32111013Rural74Pieza en casa antigua182917355361813Rural74Mejora, mediagua7113562842131427113Rural74Rancho, choza173876952351713Rural74Ruca178897153361813Rural74Mvil116432113Rural74Otro tipo de vivienda27141185313Rural74Colectiva321613106313Rural74Personas en trnsito371915117413Rural80Casa4,0102,0051,6041,20380240113Rural80Departamento11000013Rural80Pieza en casa antigua8241332516813Rural80Mejora, mediagua2271149168452313Rural80Rancho, choza4824191410513Rural80Ruca5327211611513Rural80Mvil11000013Rural80Otro tipo de vivienda84322113Rural80Colectiva137543113Rural80Personas en trnsito1897542

Prg11.- Copia la planilla de la hoja LISTADO, solo copiando los "valores" desde la fila 8 hacia abajo.RegionAreaAosTipoTotPersonasPermanentesSemipermanentesOtrosViviendasColectivasPobl.en transito13Urbana y Rural14Casa1,201,882600,941480,753360,565240,376120,18813Urbana y Rural14Departamento218,263109,13287,30565,47943,65321,82613Urbana y Rural14Pieza en casa antigua20,15010,0758,0606,0454,0302,01513Urbana y Rural14Mejora, mediagua56,63128,31622,65216,98911,3265,66313Urbana y Rural14Rancho, choza7823913132351567813Urbana y Rural14Ruca7873943152361577913Urbana y Rural14Mvil126635038251313Urbana y Rural14Otro tipo de vivienda3,6781,8391,4711,10373636813Urbana y Rural14Colectiva3,6831,8421,4731,10573736813Urbana y Rural14Personas en trnsito3,6881,8441,4751,10673836913Urbana y Rural29Casa1,154,987577,494461,995346,496230,997115,49913Urbana y Rural29Departamento243,574121,78797,43073,07248,71524,35713Urbana y Rural29Pieza en casa antigua21,19510,5988,4786,3594,2392,12013Urbana y Rural29Mejora, mediagua41,97120,98616,78812,5918,3944,19713Urbana y Rural29Rancho, choza6683342672001346713Urbana y Rural29Ruca6733372692021356713Urbana y Rural29Mvil155786247311613Urbana y Rural29Otro tipo de vivienda3,7571,8791,5031,12775137613Urbana y Rural29Colectiva3,7621,8811,5051,12975237613Urbana y Rural29Personas en trnsito3,7671,8841,5071,13075337713Urbana y Rural29Ruca3,7721,8861,5091,13275437713Urbana y Rural29Mvil155786247311613Urbana y Rural29Otro tipo de vivienda3,7571,8791,5031,12775137613Urbana y Rural29Colectiva3,7621,8811,5051,12975237613Urbana y Rural29Personas en trnsito3,7671,8841,5071,13075337713Urbana y Rural44Casa1,131,689565,845452,676339,507226,338113,16913Urbana y Rural44Departamento243,717121,85997,48773,11548,74324,37213Urbana y Rural44Pieza en casa antigua20,77410,3878,3106,2324,1552,07713Urbana y Rural44Mejora, mediagua42,94421,47217,17812,8838,5894,29413Urbana y Rural44Rancho, choza8004003202401608013Urbana y Rural44Ruca8054033222421618113Urbana y Rural44Mvil2021018161402013Urbana y Rural44Otro tipo de vivienda3,9301,9651,5721,17978639313Urbana y Rural44Colectiva3,9351,9681,5741,18178739413Urbana y Rural44Personas en trnsito3,9401,9701,5761,18278839413Urbana y Rural59Casa747,195373,598298,878224,159149,43974,72013Urbana y Rural59Departamento138,03169,01655,21241,40927,60613,80313Urbana y Rural59Pieza en casa antigua8,5944,2973,4382,5781,71985913Urbana y Rural59Mejora, mediagua17,4968,7486,9985,2493,4991,75013Urbana y Rural59Rancho, choza6093052441831226113Urbana y Rural59Ruca6143072461841236113Urbana y Rural59Mvil142715743281413Urbana y Rural59Otro tipo de vivienda1,95797978358739119613Urbana y Rural59Colectiva1,96298178558939219613Urbana y Rural59Personas en trnsito1,96798478759039319713Urbana y Rural74Casa390,625195,313156,250117,18878,12539,06313Urbana y Rural74Departamento73,37736,68929,35122,01314,6757,33813Urbana y Rural74Pieza en casa antigua4,2992,1501,7201,29086043013Urbana y Rural74Mejora, mediagua7,9153,9583,1662,3751,58379213Urbana y Rural74Rancho, choza478239191143964813Urbana y Rural74Ruca483242193145974813Urbana y Rural74Mvil472419149513Urbana y Rural74Otro tipo de vivienda8854433542661778913Urbana y Rural74Colectiva8904453562671788913Urbana y Rural74Personas en trnsito8954483582691799013Urbana y Rural80Casa138,31569,15855,32641,49527,66313,83213Urbana y Rural80Departamento33,45616,72813,38210,0376,6913,34613Urbana y Rural80Pieza en casa antigua1,65782966349733116613Urbana y Rural80Mejora, mediagua2,3871,19495571647723913Urbana y Rural80Rancho, choza135685441271413Urbana y Rural80Ruca140705642281413Urbana y Rural80Mvil95432113Urbana y Rural80Otro tipo de vivienda27914011284562813Urbana y Rural80Colectiva28414211485572813Urbana y Rural80Personas en trnsito28914511687582913Urbana14Casa1,155,798577,899462,319346,739231,160115,58013Urbana14Departamento218,248109,12487,29965,47443,65021,82513Urbana14Pieza en casa antigua19,7039,8527,8815,9113,9411,97013Urbana14Mejora, mediagua53,02226,51121,20915,90710,6045,30213Urbana14Rancho, choza6763382702031356813Urbana14Ruca6813412722041366813Urbana14Mvil6734272013713Urbana14Otro tipo de vivienda3,5821,7911,4331,07571635813Urbana14Colectiva3,5871,7941,4351,07671735913Urbana14Personas en trnsito3,5921,7961,4371,07871835913Urbana29Casa1,117,692558,846447,077335,308223,538111,76913Urbana29Departamento243,562121,78197,42573,06948,71224,35613Urbana29Pieza en casa antigua20,73610,3688,2946,2214,1472,07413Urbana29Mejora, mediagua39,19719,59915,67911,7597,8393,92013Urbana29Rancho, choza5762882301731155813Urbana29Ruca5812912321741165813Urbana29Mvil102514131201013Urbana29Otro tipo de vivienda3,6611,8311,4641,09873236613Urbana29Colectiva3,6661,8331,4661,10073336713Urbana29Personas en trnsito3,6711,8361,4681,10173436713Urbana44Casa1,091,169545,585436,468327,351218,234109,11713Urbana44Departamento243,706121,85397,48273,11248,74124,37113Urbana44Pieza en casa antigua20,28110,1418,1126,0844,0562,02813Urbana44Mejora, mediagua40,23520,11816,09412,0718,0474,02413Urbana44Rancho, choza6623312651991326613Urbana44Ruca6673342672001336713Urbana44Mvil149756045301513Urbana44Otro tipo de vivienda3,8011,9011,5201,14076038013Urbana44Colectiva3,8061,9031,5221,14276138113Urbana44Personas en trnsito3,8111,9061,5241,14376238113Urbana59Casa723,382361,691289,353217,015144,67672,33813Urbana59Departamento138,02169,01155,20841,40627,60413,80213Urbana59Pieza en casa antigua8,3384,1693,3352,5011,66883413Urbana59Mejora, mediagua16,0768,0386,4304,8233,2151,60813Urbana59Rancho, choza455228182137914613Urbana59Ruca460230184138924613Urbana59Mvil97493929191013Urbana59Otro tipo de vivienda1,88694375456637718913Urbana59Colectiva1,89194675656737818913Urbana59Personas en trnsito1,89694875856937919013Urbana74Casa377,768188,884151,107113,33075,55437,77713Urbana74Departamento73,37436,68729,35022,01214,6757,33713Urbana74Pieza en casa antigua4,1172,0591,6471,23582341213Urbana74Mejora, mediagua7,2043,6022,8822,1611,44172013Urbana74Rancho, choza30515312292613113Urbana74Ruca31015512493623113Urbana74Mvil361814117413Urbana74Otro tipo de vivienda8584293432571728613Urbana74Colectiva8634323452591738613Urbana74Personas en trnsito8684343472601748713Urbana80Casa134,30567,15353,72240,29226,86113,43113Urbana80Departamento33,45516,72813,38210,0376,6913,34613Urbana80Pieza en casa antigua1,57578863047331515813Urbana80Mejora, mediagua2,1601,08086464843221613Urbana80Rancho, choza8744352617913Urbana80Ruca9246372818913Urbana80Mvil84322113Urbana80Otro tipo de vivienda27113610881542713Urbana80Colectiva27613811083552813Urbana80Personas en trnsito28114111284562813Rural14Casa46,08423,04218,43413,8259,2174,60813Rural14Departamento158653213Rural14Pieza en casa antigua447224179134894513Rural14Mejora, mediagua3,6091,8051,4441,08372236113Rural14Rancho, choza106534232211113Rural14Ruca111564433221113Rural14Mvil5930241812613Rural14Otro tipo de vivienda96483829191013Rural14Colectiva101514030201013Rural14Personas en trnsito106534232211113Rural29Casa37,29518,64814,91811,1897,4593,73013Rural29Departamento126542113Rural29Pieza en casa antigua459230184138924613Rural29Mejora, mediagua2,7741,3871,11083255527713Rural29Rancho, choza9246372818913Rural29Ruca97493929191013Rural29Mvil5327211611513Rural29Otro tipo de vivienda96483829191013Rural29Colectiva101514030201013Rural29Personas en trnsito106534232211113Rural44Casa40,52020,26016,20812,1568,1044,05213Rural44Departamento116432113Rural44Pieza en casa antigua493247197148994913Rural44Mejora, mediagua2,7091,3551,08481354227113Rural44Rancho, choza138695541281413Rural44Ruca143725743291413Rural44Mvil5327211611513Rural44Otro tipo de vivienda129655239261313Rural44Colectiva134675440271313Rural44Personas en trnsito139705642281413Rural59Casa23,81311,9079,5257,1444,7632,38113Rural59Departamento105432113Rural59Pieza en casa antigua25612810277512613Rural59Mejora, mediagua1,42071056842628414213Rural59Rancho, choza154776246311513Rural59Ruca159806448321613Rural59Mvil452318149513Rural59Otro tipo de vivienda7136282114713Rural59Colectiva7638302315813Rural59Personas en trnsito8141322416813Rural74Casa12,8576,4295,1433,8572,5711,28613Rural74Departamento32111013Rural74Pieza en casa antigua182917355361813Rural74Mejora, mediagua7113562842131427113Rural74Rancho, choza173876952351713Rural74Ruca178897153361813Rural74Mvil116432113Rural74Otro tipo de vivienda27141185313Rural74Colectiva321613106313Rural74Personas en trnsito371915117413Rural80Casa4,0102,0051,6041,20380240113Rural80Departamento11000013Rural80Pieza en casa antigua8241332516813Rural80Mejora, mediagua2271149168452313Rural80Rancho, choza4824191410513Rural80Ruca5327211611513Rural80Mvil11000013Rural80Otro tipo de vivienda84322113Rural80Colectiva137543113Rural80Personas en trnsito1897542

Prg22.- Copia la planilla anterior y ordena por : Ao y TipoRegionAreaAosTipoTotPersonasPermanentesSemipermanentesOtrosViviendasColectivasPobl.en transito13Urbana y Rural14Casa1,201,882600,941480,753360,565240,376120,18813Urbana y Rural14Departamento218,263109,13287,30565,47943,65321,82613Urbana y Rural14Pieza en casa antigua20,15010,0758,0606,0454,0302,01513Urbana y Rural14Mejora, mediagua56,63128,31622,65216,98911,3265,66313Urbana y Rural14Rancho, choza7823913132351567813Urbana y Rural14Ruca7873943152361577913Urbana y Rural14Mvil126635038251313Urbana y Rural14Otro tipo de vivienda3,6781,8391,4711,10373636813Urbana y Rural14Colectiva3,6831,8421,4731,10573736813Urbana y Rural14Personas en trnsito3,6881,8441,4751,10673836913Urbana y Rural29Casa1,154,987577,494461,995346,496230,997115,49913Urbana y Rural29Departamento243,574121,78797,43073,07248,71524,35713Urbana y Rural29Pieza en casa antigua21,19510,5988,4786,3594,2392,12013Urbana y Rural29Mejora, mediagua41,97120,98616,78812,5918,3944,19713Urbana y Rural29Rancho, choza6683342672001346713Urbana y Rural29Ruca6733372692021356713Urbana y Rural29Mvil155786247311613Urbana y Rural29Otro tipo de vivienda3,7571,8791,5031,12775137613Urbana y Rural29Colectiva3,7621,8811,5051,12975237613Urbana y Rural29Personas en trnsito3,7671,8841,5071,13075337713Urbana y Rural29Ruca3,7721,8861,5091,13275437713Urbana y Rural29Mvil155786247311613Urbana y Rural29Otro tipo de vivienda3,7571,8791,5031,12775137613Urbana y Rural29Colectiva3,7621,8811,5051,12975237613Urbana y Rural29Personas en trnsito3,7671,8841,5071,13075337713Urbana y Rural44Casa1,131,689565,845452,676339,507226,338113,16913Urbana y Rural44Departamento243,717121,85997,48773,11548,74324,37213Urbana y Rural44Pieza en casa antigua20,77410,3878,3106,2324,1552,07713Urbana y Rural44Mejora, mediagua42,94421,47217,17812,8838,5894,29413Urbana y Rural44Rancho, choza8004003202401608013Urbana y Rural44Ruca8054033222421618113Urbana y Rural44Mvil2021018161402013Urbana y Rural44Otro tipo de vivienda3,9301,9651,5721,17978639313Urbana y Rural44Colectiva3,9351,9681,5741,18178739413Urbana y Rural44Personas en trnsito3,9401,9701,5761,18278839413Urbana y Rural59Casa747,195373,598298,878224,159149,43974,72013Urbana y Rural59Departamento138,03169,01655,21241,40927,60613,80313Urbana y Rural59Pieza en casa antigua8,5944,2973,4382,5781,71985913Urbana y Rural59Mejora, mediagua17,4968,7486,9985,2493,4991,75013Urbana y Rural59Rancho, choza6093052441831226113Urbana y Rural59Ruca6143072461841236113Urbana y Rural59Mvil142715743281413Urbana y Rural59Otro tipo de vivienda1,95797978358739119613Urbana y Rural59Colectiva1,96298178558939219613Urbana y Rural59Personas en trnsito1,96798478759039319713Urbana y Rural74Casa390,625195,313156,250117,18878,12539,06313Urbana y Rural74Departamento73,37736,68929,35122,01314,6757,33813Urbana y Rural74Pieza en casa antigua4,2992,1501,7201,29086043013Urbana y Rural74Mejora, mediagua7,9153,9583,1662,3751,58379213Urbana y Rural74Rancho, choza478239191143964813Urbana y Rural74Ruca483242193145974813Urbana y Rural74Mvil472419149513Urbana y Rural74Otro tipo de vivienda8854433542661778913Urbana y Rural74Colectiva8904453562671788913Urbana y Rural74Personas en trnsito8954483582691799013Urbana y Rural80Casa138,31569,15855,32641,49527,66313,83213Urbana y Rural80Departamento33,45616,72813,38210,0376,6913,34613Urbana y Rural80Pieza en casa antigua1,65782966349733116613Urbana y Rural80Mejora, mediagua2,3871,19495571647723913Urbana y Rural80Rancho, choza135685441271413Urbana y Rural80Ruca140705642281413Urbana y Rural80Mvil95432113Urbana y Rural80Otro tipo de vivienda27914011284562813Urbana y Rural80Colectiva28414211485572813Urbana y Rural80Personas en trnsito28914511687582913Urbana14Casa1,155,798577,899462,319346,739231,160115,58013Urbana14Departamento218,248109,12487,29965,47443,65021,82513Urbana14Pieza en casa antigua19,7039,8527,8815,9113,9411,97013Urbana14Mejora, mediagua53,02226,51121,20915,90710,6045,30213Urbana14Rancho, choza6763382702031356813Urbana14Ruca6813412722041366813Urbana14Mvil6734272013713Urbana14Otro tipo de vivienda3,5821,7911,4331,07571635813Urbana14Colectiva3,5871,7941,4351,07671735913Urbana14Personas en trnsito3,5921,7961,4371,07871835913Urbana29Casa1,117,692558,846447,077335,308223,538111,76913Urbana29Departamento243,562121,78197,42573,06948,71224,35613Urbana29Pieza en casa antigua20,73610,3688,2946,2214,1472,07413Urbana29Mejora, mediagua39,19719,59915,67911,7597,8393,92013Urbana29Rancho, choza5762882301731155813Urbana29Ruca5812912321741165813Urbana29Mvil102514131201013Urbana29Otro tipo de vivienda3,6611,8311,4641,09873236613Urbana29Colectiva3,6661,8331,4661,10073336713Urbana29Personas en trnsito3,6711,8361,4681,10173436713Urbana44Casa1,091,169545,585436,468327,351218,234109,11713Urbana44Departamento243,706121,85397,48273,11248,74124,37113Urbana44Pieza en casa antigua20,28110,1418,1126,0844,0562,02813Urbana44Mejora, mediagua40,23520,11816,09412,0718,0474,02413Urbana44Rancho, choza6623312651991326613Urbana44Ruca6673342672001336713Urbana44Mvil149756045301513Urbana44Otro tipo de vivienda3,8011,9011,5201,14076038013Urbana44Colectiva3,8061,9031,5221,14276138113Urbana44Personas en trnsito3,8111,9061,5241,14376238113Urbana59Casa723,382361,691289,353217,015144,67672,33813Urbana59Departamento138,02169,01155,20841,40627,60413,80213Urbana59Pieza en casa antigua8,3384,1693,3352,5011,66883413Urbana59Mejora, mediagua16,0768,0386,4304,8233,2151,60813Urbana59Rancho, choza455228182137914613Urbana59Ruca460230184138924613Urbana59Mvil97493929191013Urbana59Otro tipo de vivienda1,88694375456637718913Urbana59Colectiva1,89194675656737818913Urbana59Personas en trnsito1,89694875856937919013Urbana74Casa377,768188,884151,107113,33075,55437,77713Urbana74Departamento73,37436,68729,35022,01214,6757,33713Urbana74Pieza en casa antigua4,1172,0591,6471,23582341213Urbana74Mejora, mediagua7,2043,6022,8822,1611,44172013Urbana74Rancho, choza30515312292613113Urbana74Ruca31015512493623113Urbana74Mvil361814117413Urbana74Otro tipo de vivienda8584293432571728613Urbana74Colectiva8634323452591738613Urbana74Personas en trnsito8684343472601748713Urbana80Casa134,30567,15353,72240,29226,86113,43113Urbana80Departamento33,45516,72813,38210,0376,6913,34613Urbana80Pieza en casa antigua1,57578863047331515813Urbana80Mejora, mediagua2,1601,08086464843221613Urbana80Rancho, choza8744352617913Urbana80Ruca9246372818913Urbana80Mvil84322113Urbana80Otro tipo de vivienda27113610881542713Urbana80Colectiva27613811083552813Urbana80Personas en trnsito28114111284562813Rural14Casa46,08423,04218,43413,8259,2174,60813Rural14Departamento158653213Rural14Pieza en casa antigua447224179134894513Rural14Mejora, mediagua3,6091,8051,4441,08372236113Rural14Rancho, choza106534232211113Rural14Ruca111564433221113Rural14Mvil5930241812613Rural14Otro tipo de vivienda96483829191013Rural14Colectiva101514030201013Rural14Personas en trnsito106534232211113Rural29Casa37,29518,64814,91811,1897,4593,73013Rural29Departamento126542113Rural29Pieza en casa antigua459230184138924613Rural29Mejora, mediagua2,7741,3871,11083255527713Rural29Rancho, choza9246372818913Rural29Ruca97493929191013Rural29Mvil5327211611513Rural29Otro tipo de vivienda96483829191013Rural29Colectiva101514030201013Rural29Personas en trnsito106534232211113Rural44Casa40,52020,26016,20812,1568,1044,05213Rural44Departamento116432113Rural44Pieza en casa antigua493247197148994913Rural44Mejora, mediagua2,7091,3551,08481354227113Rural44Rancho, choza138695541281413Rural44Ruca143725743291413Rural44Mvil5327211611513Rural44Otro tipo de vivienda129655239261313Rural44Colectiva134675440271313Rural44Personas en trnsito139705642281413Rural59Casa23,81311,9079,5257,1444,7632,38113Rural59Departamento105432113Rural59Pieza en casa antigua25612810277512613Rural59Mejora, mediagua1,42071056842628414213Rural59Rancho, choza154776246311513Rural59Ruca159806448321613Rural59Mvil452318149513Rural59Otro tipo de vivienda7136282114713Rural59Colectiva7638302315813Rural59Personas en trnsito8141322416813Rural74Casa12,8576,4295,1433,8572,5711,28613Rural74Departamento32111013Rural74Pieza en casa antigua182917355361813Rural74Mejora, mediagua7113562842131427113Rural74Rancho, choza173876952351713Rural74Ruca178897153361813Rural74Mvil116432113Rural74Otro tipo de vivienda27141185313Rural74Colectiva321613106313Rural74Personas en trnsito371915117413Rural80Casa4,0102,0051,6041,20380240113Rural80Departamento11000013Rural80Pieza en casa antigua8241332516813Rural80Mejora, mediagua2271149168452313Rural80Rancho, choza4824191410513Rural80Ruca5327211611513Rural80Mvil11000013Rural80Otro tipo de vivienda84322113Rural80Colectiva137543113Rural80Personas en trnsito1897542

Prg33.- Copia la planilla de la Prg1 y crea un autofiltro de tal manera que contenga solo los elementos que contengan area ruralRegionAreaAosTipoTotPersonasPermanentesSemipermanentesOtrosViviendasColectivasPobl.en transito13Urbana y Rural14Casa1,201,882600,941480,753360,565240,376120,18813Urbana y Rural14Departamento218,263109,13287,30565,47943,65321,82613Urbana y Rural14Pieza en casa antigua20,15010,0758,0606,0454,0302,01513Urbana y Rural14Mejora, mediagua56,63128,31622,65216,98911,3265,66313Urbana y Rural14Rancho, choza7823913132351567813Urbana y Rural14Ruca7873943152361577913Urbana y Rural14Mvil126635038251313Urbana y Rural14Otro tipo de vivienda3,6781,8391,4711,10373636813Urbana y Rural14Colectiva3,6831,8421,4731,10573736813Urbana y Rural14Personas en trnsito3,6881,8441,4751,10673836913Urbana y Rural29Casa1,154,987577,494461,995346,496230,997115,49913Urbana y Rural29Departamento243,574121,78797,43073,07248,71524,35713Urbana y Rural29Pieza en casa antigua21,19510,5988,4786,3594,2392,12013Urbana y Rural29Mejora, mediagua41,97120,98616,78812,5918,3944,19713Urbana y Rural29Rancho, choza6683342672001346713Urbana y Rural29Ruca6733372692021356713Urbana y Rural29Mvil155786247311613Urbana y Rural29Otro tipo de vivienda3,7571,8791,5031,12775137613Urbana y Rural29Colectiva3,7621,8811,5051,12975237613Urbana y Rural29Personas en trnsito3,7671,8841,5071,13075337713Urbana y Rural29Ruca3,7721,8861,5091,13275437713Urbana y Rural29Mvil155786247311613Urbana y Rural29Otro tipo de vivienda3,7571,8791,5031,12775137613Urbana y Rural29Colectiva3,7621,8811,5051,12975237613Urbana y Rural29Personas en trnsito3,7671,8841,5071,13075337713Urbana y Rural44Casa1,131,689565,845452,676339,507226,338113,16913Urbana y Rural44Departamento243,717121,85997,48773,11548,74324,37213Urbana y Rural44Pieza en casa antigua20,77410,3878,3106,2324,1552,07713Urbana y Rural44Mejora, mediagua42,94421,47217,17812,8838,5894,29413Urbana y Rural44Rancho, choza8004003202401608013Urbana y Rural44Ruca8054033222421618113Urbana y Rural44Mvil2021018161402013Urbana y Rural44Otro tipo de vivienda3,9301,9651,5721,17978639313Urbana y Rural44Colectiva3,9351,9681,5741,18178739413Urbana y Rural44Personas en trnsito3,9401,9701,5761,18278839413Urbana y Rural59Casa747,195373,598298,878224,159149,43974,72013Urbana y Rural59Departamento138,03169,01655,21241,40927,60613,80313Urbana y Rural59Pieza en casa antigua8,5944,2973,4382,5781,71985913Urbana y Rural59Mejora, mediagua17,4968,7486,9985,2493,4991,75013Urbana y Rural59Rancho, choza6093052441831226113Urbana y Rural59Ruca6143072461841236113Urbana y Rural59Mvil142715743281413Urbana y Rural59Otro tipo de vivienda1,95797978358739119613Urbana y Rural59Colectiva1,96298178558939219613Urbana y Rural59Personas en trnsito1,96798478759039319713Urbana y Rural74Casa390,625195,313156,250117,18878,12539,06313Urbana y Rural74Departamento73,37736,68929,35122,01314,6757,33813Urbana y Rural74Pieza en casa antigua4,2992,1501,7201,29086043013Urbana y Rural74Mejora, mediagua7,9153,9583,1662,3751,58379213Urbana y Rural74Rancho, choza478239191143964813Urbana y Rural74Ruca483242193145974813Urbana y Rural74Mvil472419149513Urbana y Rural74Otro tipo de vivienda8854433542661778913Urbana y Rural74Colectiva8904453562671788913Urbana y Rural74Personas en trnsito8954483582691799013Urbana y Rural80Casa138,31569,15855,32641,49527,66313,83213Urbana y Rural80Departamento33,45616,72813,38210,0376,6913,34613Urbana y Rural80Pieza en casa antigua1,65782966349733116613Urbana y Rural80Mejora, mediagua2,3871,19495571647723913Urbana y Rural80Rancho, choza135685441271413Urbana y Rural80Ruca140705642281413Urbana y Rural80Mvil95432113Urbana y Rural80Otro tipo de vivienda27914011284562813Urbana y Rural80Colectiva28414211485572813Urbana y Rural80Personas en trnsito28914511687582913Urbana14Casa1,155,798577,899462,319346,739231,160115,58013Urbana14Departamento218,248109,12487,29965,47443,65021,82513Urbana14Pieza en casa antigua19,7039,8527,8815,9113,9411,97013Urbana14Mejora, mediagua53,02226,51121,20915,90710,6045,30213Urbana14Rancho, choza6763382702031356813Urbana14Ruca6813412722041366813Urbana14Mvil6734272013713Urbana14Otro tipo de vivienda3,5821,7911,4331,07571635813Urbana14Colectiva3,5871,7941,4351,07671735913Urbana14Personas en trnsito3,5921,7961,4371,07871835913Urbana29Casa1,117,692558,846447,077335,308223,538111,76913Urbana29Departamento243,562121,78197,42573,06948,71224,35613Urbana29Pieza en casa antigua20,73610,3688,2946,2214,1472,07413Urbana29Mejora, mediagua39,19719,59915,67911,7597,8393,92013Urbana29Rancho, choza5762882301731155813Urbana29Ruca5812912321741165813Urbana29Mvil102514131201013Urbana29Otro tipo de vivienda3,6611,8311,4641,09873236613Urbana29Colectiva3,6661,8331,4661,10073336713Urbana29Personas en trnsito3,6711,8361,4681,10173436713Urbana44Casa1,091,169545,585436,468327,351218,234109,11713Urbana44Departamento243,706121,85397,48273,11248,74124,37113Urbana44Pieza en casa antigua20,28110,1418,1126,0844,0562,02813Urbana44Mejora, mediagua40,23520,11816,09412,0718,0474,02413Urbana44Rancho, choza6623312651991326613Urbana44Ruca6673342672001336713Urbana44Mvil149756045301513Urbana44Otro tipo de vivienda3,8011,9011,5201,14076038013Urbana44Colectiva3,8061,9031,5221,14276138113Urbana44Personas en trnsito3,8111,9061,5241,14376238113Urbana59Casa723,382361,691289,353217,015144,67672,33813Urbana59Departamento138,02169,01155,20841,40627,60413,80213Urbana59Pieza en casa antigua8,3384,1693,3352,5011,66883413Urbana59Mejora, mediagua16,0768,0386,4304,8233,2151,60813Urbana59Rancho, choza455228182137914613Urbana59Ruca460230184138924613Urbana59Mvil97493929191013Urbana59Otro tipo de vivienda1,88694375456637718913Urbana59Colectiva1,89194675656737818913Urbana59Personas en trnsito1,89694875856937919013Urbana74Casa377,768188,884151,107113,33075,55437,77713Urbana74Departamento73,37436,68729,35022,01214,6757,33713Urbana74Pieza en casa antigua4,1172,0591,6471,23582341213Urbana74Mejora, mediagua7,2043,6022,8822,1611,44172013Urbana74Rancho, choza30515312292613113Urbana74Ruca31015512493623113Urbana74Mvil361814117413Urbana74Otro tipo de vivienda8584293432571728613Urbana74Colectiva8634323452591738613Urbana74Personas en trnsito8684343472601748713Urbana80Casa134,30567,15353,72240,29226,86113,43113Urbana80Departamento33,45516,72813,38210,0376,6913,34613Urbana80Pieza en casa antigua1,57578863047331515813Urbana80Mejora, mediagua2,1601,08086464843221613Urbana80Rancho, choza8744352617913Urbana80Ruca9246372818913Urbana80Mvil84322113Urbana80Otro tipo de vivienda27113610881542713Urbana80Colectiva27613811083552813Urbana80Personas en trnsito28114111284562813Rural14Casa46,08423,04218,43413,8259,2174,60813Rural14Departamento158653213Rural14Pieza en casa antigua447224179134894513Rural14Mejora, mediagua3,6091,8051,4441,08372236113Rural14Rancho, choza106534232211113Rural14Ruca111564433221113Rural14Mvil5930241812613Rural14Otro tipo de vivienda96483829191013Rural14Colectiva101514030201013Rural14Personas en trnsito106534232211113Rural29Casa37,29518,64814,91811,1897,4593,73013Rural29Departamento126542113Rural29Pieza en casa antigua459230184138924613Rural29Mejora, mediagua2,7741,3871,11083255527713Rural29Rancho, choza9246372818913Rural29Ruca97493929191013Rural29Mvil5327211611513Rural29Otro tipo de vivienda96483829191013Rural29Colectiva101514030201013Rural29Personas en trnsito106534232211113Rural44Casa40,52020,26016,20812,1568,1044,05213Rural44Departamento116432113Rural44Pieza en casa antigua493247197148994913Rural44Mejora, mediagua2,7091,3551,08481354227113Rural44Rancho, choza138695541281413Rural44Ruca143725743291413Rural44Mvil5327211611513Rural44Otro tipo de vivienda129655239261313Rural44Colectiva134675440271313Rural44Personas en trnsito139705642281413Rural59Casa23,81311,9079,5257,1444,7632,38113Rural59Departamento105432113Rural59Pieza en casa antigua25612810277512613Rural59Mejora, mediagua1,42071056842628414213Rural59Rancho, choza154776246311513Rural59Ruca159806448321613Rural59Mvil452318149513Rural59Otro tipo de vivienda7136282114713Rural59Colectiva7638302315813Rural59Personas en trnsito8141322416813Rural74Casa12,8576,4295,1433,8572,5711,28613Rural74Departamento32111013Rural74Pieza en casa antigua182917355361813Rural74Mejora, mediagua7113562842131427113Rural74Rancho, choza173876952351713Rural74Ruca178897153361813Rural74Mvil116432113Rural74Otro tipo de vivienda27141185313Rural74Colectiva321613106313Rural74Personas en trnsito371915117413Rural80Casa4,0102,0051,6041,20380240113Rural80Departamento11000013Rural80Pieza en casa antigua8241332516813Rural80Mejora, mediagua2271149168452313Rural80Rancho, choza4824191410513Rural80Ruca5327211611513Rural80Mvil11000013Rural80Otro tipo de vivienda84322113Rural80Colectiva137543113Rural80Personas en trnsito1897542

Prg44.- Copia la planilla de la Prg1 y crea un autofiltro de tal manera que contenga solo los elementos que contengan Permantes bajo 500RegionAreaAosTipoTotPersonasPermanentesSemipermanentesOtrosViviendasColectivasPobl.en transito13Urbana y Rural14Casa1201882600941480752.8360564.6240376.4120188.213Urbana y Rural14Departamento218263109131.587305.265478.943652.621826.313Urbana y Rural14Pieza en casa antigua2015010075806060454030201513Urbana y Rural14Mejora, mediagua5663128315.522652.416989.311326.25663.113Urbana y Rural14Rancho, choza782391312.8234.6156.478.213Urbana y Rural14Ruca787393.5314.8236.1157.478.713Urbana y Rural14Mvil1266350.437.825.212.613Urbana y Rural14Otro tipo de vivienda367818391471.21103.4735.6367.813Urbana y Rural14Colectiva36831841.51473.21104.9736.6368.313Urbana y Rural14Personas en trnsito368818441475.21106.4737.6368.813Urbana y Rural29Casa1154987577493.5461994.8346496.1230997.4115498.713Urbana y Rural29Departamento24357412178797429.673072.248714.824357.413Urbana y Rural29Pieza en casa antigua2119510597.584786358.542392119.513Urbana y Rural29Mejora, mediagua4197120985.516788.412591.38394.24197.113Urbana y Rural29Rancho, choza668334267.2200.4133.666.813Urbana y Rural29Ruca673336.5269.2201.9134.667.313Urbana y Rural29Mvil15577.56246.53115.513Urbana y Rural29Otro tipo de vivienda37571878.51502.81127.1751.4375.713Urbana y Rural29Colectiva376218811504.81128.6752.4376.213Urbana y Rural29Personas en trnsito37671883.51506.81130.1753.4376.713Urbana y Rural29Ruca377218861508.81131.6754.4377.213Urbana y Rural29Mvil15577.56246.53115.513Urbana y Rural29Otro tipo de vivienda37571878.51502.81127.1751.4375.713Urbana y Rural29Colectiva376218811504.81128.6752.4376.213Urbana y Rural29Personas en trnsito37671883.51506.81130.1753.4376.713Urbana y Rural44Casa1131689565844.5452675.6339506.7226337.8113168.913Urbana y Rural44Departamento243717121858.597486.873115.148743.424371.713Urbana y Rural44Pieza en casa antigua20774103878309.66232.24154.82077.413Urbana y Rural44Mejora, mediagua429442147217177.612883.28588.84294.413Urbana y Rural44Rancho, choza8004003202401608013Urbana y Rural44Ruca805402.5322241.516180.513Urbana y Rural44Mvil20210180.860.640.420.213Urbana y Rural44Otro tipo de vivienda393019651572117978639313Urbana y Rural44Colectiva39351967.515741180.5787393.513Urbana y Rural44Personas en trnsito394019701576118278839413Urbana y Rural59Casa747195373597.5298878224158.514943974719.513Urbana y Rural59Departamento13803169015.555212.441409.327606.213803.113Urbana y Rural59Pieza en casa antigua859442973437.62578.21718.8859.413Urbana y Rural59Mejora, mediagua1749687486998.45248.83499.21749.613Urbana y Rural59Rancho, choza609304.5243.6182.7121.860.913Urbana y Rural59Ruca614307245.6184.2122.861.413Urbana y Rural59Mvil1427156.842.628.414.213Urbana y Rural59Otro tipo de vivienda1957978.5782.8587.1391.4195.713Urbana y Rural59Colectiva1962981784.8588.6392.4196.213Urbana y Rural59Personas en trnsito1967983.5786.8590.1393.4196.713Urbana y Rural74Casa390625195312.5156250117187.57812539062.513Urbana y Rural74Departamento7337736688.529350.822013.114675.47337.713Urbana y Rural74Pieza en casa antigua42992149.51719.61289.7859.8429.913Urbana y Rural74Mejora, mediagua79153957.531662374.51583791.513Urbana y Rural74Rancho, choza478239191.2143.495.647.813Urbana y Rural74Ruca483241.5193.2144.996.648.313Urbana y Rural74Mvil4723.518.814.19.44.713Urbana y Rural74Otro tipo de vivienda885442.5354265.517788.513Urbana y Rural74Colectiva8904453562671788913Urbana y Rural74Personas en trnsito895447.5358268.517989.513Urbana y Rural80Casa13831569157.55532641494.52766313831.513Urbana y Rural80Departamento334561672813382.410036.86691.23345.613Urbana y Rural80Pieza en casa antigua1657828.5662.8497.1331.4165.713Urbana y Rural80Mejora, mediagua23871193.5954.8716.1477.4238.713Urbana y Rural80Rancho, choza13567.55440.52713.513Urbana y Rural80Ruca140705642281413Urbana y Rural80Mvil94.53.62.71.80.913Urbana y Rural80Otro tipo de vivienda279139.5111.683.755.827.913Urbana y Rural80Colectiva284142113.685.256.828.413Urbana y Rural80Personas en trnsito289144.5115.686.757.828.913Urbana14Casa1155798577899462319.2346739.4231159.6115579.813Urbana14Departamento21824810912487299.265474.443649.621824.813Urbana14Pieza en casa antigua197039851.57881.25910.93940.61970.313Urbana14Mejora, mediagua530222651121208.815906.610604.45302.213Urbana14Rancho, choza676338270.4202.8135.267.613Urbana14Ruca681340.5272.4204.3136.268.113Urbana14Mvil6733.526.820.113.46.713Urbana14Otro tipo de vivienda358217911432.81074.6716.4358.213Urbana14Colectiva35871793.51434.81076.1717.4358.713Urbana14Personas en trnsito359217961436.81077.6718.4359.213Urbana29Casa1117692558846447076.8335307.6223538.4111769.213Urbana29Departamento24356212178197424.873068.648712.424356.213Urbana29Pieza en casa antigua20736103688294.46220.84147.22073.613Urbana29Mejora, mediagua3919719598.515678.811759.17839.43919.713Urbana29Rancho, choza576288230.4172.8115.257.613Urbana29Ruca581290.5232.4174.3116.258.113Urbana29Mvil1025140.830.620.410.213Urbana29Otro tipo de vivienda36611830.51464.41098.3732.2366.113Urbana29Colectiva366618331466.41099.8733.2366.613Urbana29Personas en trnsito36711835.51468.41101.3734.2367.113Urbana44Casa1091169545584.5436467.6327350.7218233.8109116.913Urbana44Departamento24370612185397482.473111.848741.224370.613Urbana44Pieza en casa antigua2028110140.58112.46084.34056.22028.113Urbana44Mejora, mediagua4023520117.51609412070.580474023.513Urbana44Rancho, choza662331264.8198.6132.466.213Urbana44Ruca667333.5266.8200.1133.466.713Urbana44Mvil14974.559.644.729.814.913Urbana44Otro tipo de vivienda38011900.51520.41140.3760.2380.113Urbana44Colectiva380619031522.41141.8761.2380.613Urbana44Personas en trnsito38111905.51524.41143.3762.2381.113Urbana59Casa723382361691289352.8217014.6144676.472338.213Urbana59Departamento13802169010.555208.441406.327604.213802.113Urbana59Pieza en casa antigua833841693335.22501.41667.6833.813Urbana59Mejora, mediagua1607680386430.44822.83215.21607.613Urbana59Rancho, choza455227.5182136.59145.513Urbana59Ruca460230184138924613Urbana59Mvil9748.538.829.119.49.713Urbana59Otro tipo de vivienda1886943754.4565.8377.2188.613Urbana59Colectiva1891945.5756.4567.3378.2189.113Urbana59Personas en trnsito1896948758.4568.8379.2189.613Urbana74Casa377768188884151107.2113330.475553.637776.813Urbana74Departamento733743668729349.622012.214674.87337.413Urbana74Pieza en casa antigua41172058.51646.81235.1823.4411.713Urbana74Mejora, mediagua720436022881.62161.21440.8720.413Urbana74Rancho, choza305152.512291.56130.513Urbana74Ruca31015512493623113Urbana74Mvil361814.410.87.23.613Urbana74Otro tipo de vivienda858429343.2257.4171.685.813Urbana74Colectiva863431.5345.2258.9172.686.313Urbana74Personas en trnsito868434347.2260.4173.686.813Urbana80Casa13430567152.55372240291.52686113430.513Urbana80Departamento3345516727.51338210036.566913345.513Urbana80Pieza en casa antigua1575787.5630472.5315157.513Urbana80Mejora, mediagua2160108086464843221613Urbana80Rancho, choza8743.534.826.117.48.713Urbana80Ruca924636.827.618.49.213Urbana80Mvil843.22.41.60.813Urbana80Otro tipo de vivienda271135.5108.481.354.227.113Urbana80Colectiva276138110.482.855.227.613Urbana80Personas en trnsito281140.5112.484.356.228.113Rural14Casa460842304218433.613825.29216.84608.413Rural14Departamento157.564.531.513Rural14Pieza en casa antigua447223.5178.8134.189.444.713Rural14Mejora, mediagua36091804.51443.61082.7721.8360.913Rural14Rancho, choza1065342.431.821.210.613Rural14Ruca11155.544.433.322.211.113Rural14Mvil5929.523.617.711.85.913Rural14Otro tipo de vivienda964838.428.819.29.613Rural14Colectiva10150.540.430.320.210.113Rural14Personas en trnsito1065342.431.821.210.613Rural29Casa3729518647.51491811188.574593729.513Rural29Departamento1264.83.62.41.213Rural29Pieza en casa antigua459229.5183.6137.791.845.913Rural29Mejora, mediagua277413871109.6832.2554.8277.413Rural29Rancho, choza924636.827.618.49.213Rural29Ruca9748.538.829.119.49.713Rural29Mvil5326.521.215.910.65.313Rural29Otro tipo de vivienda964838.428.819.29.613Rural29Colectiva10150.540.430.320.210.113Rural29Personas en trnsito1065342.431.821.210.613Rural44Casa405202026016208121568104405213Rural44Departamento115.54.43.32.21.113Rural44Pieza en casa antigua493246.5197.2147.998.649.313Rural44Mejora, mediagua27091354.51083.6812.7541.8270.913Rural44Rancho, choza1386955.241.427.613.813Rural44Ruca14371.557.242.928.614.313Rural44Mvil5326.521.215.910.65.313Rural44Otro tipo de vivienda12964.551.638.725.812.913Rural44Colectiva1346753.640.226.813.413Rural44Personas en trnsito13969.555.641.727.813.913Rural59Casa2381311906.59525.27143.94762.62381.313Rural59Departamento105432113Rural59Pieza en casa antigua256128102.476.851.225.613Rural59Mejora, mediagua142071056842628414213Rural59Rancho, choza1547761.646.230.815.413Rural59Ruca15979.563.647.731.815.913Rural59Mvil4522.51813.594.513Rural59Otro tipo de vivienda7135.528.421.314.27.113Rural59Colectiva763830.422.815.27.613Rural59Personas en trnsito8140.532.424.316.28.113Rural74Casa128576428.55142.83857.12571.41285.713Rural74Departamento31.51.20.90.60.313Rural74Pieza en casa antigua1829172.854.636.418.213Rural74Mejora, mediagua711355.5284.4213.3142.271.113Rural74Rancho, choza17386.569.251.934.617.313Rural74Ruca1788971.253.435.617.813Rural74Mvil115.54.43.32.21.113Rural74Otro tipo de vivienda2713.510.88.15.42.713Rural74Colectiva321612.89.66.43.213Rural74Personas en trnsito3718.514.811.17.43.713Rural80Casa401020051604120380240113Rural80Departamento10.50.40.30.20.113Rural80Pieza en casa antigua824132.824.616.48.213Rural80Mejora, mediagua227113.590.868.145.422.713Rural80Rancho, choza482419.214.49.64.813Rural80Ruca5326.521.215.910.65.313Rural80Mvil10.50.40.30.20.113Rural80Otro tipo de vivienda843.22.41.60.813Rural80Colectiva136.55.23.92.61.313Rural80Personas en trnsito1897.25.43.61.8

Prg55.- Copia la planilla de la Prg1 y crea un autofiltro de tal manera que contenga solo los elementos que contengan Permantes entre 500 y 5000RegionAreaAosTipoTotPersonasPermanentesSemipermanentesOtrosViviendasColectivasPobl.en transito13Urbana y Rural14Casa1201882600941480752.8360564.6240376.4120188.213Urbana y Rural14Departamento218263109131.587305.265478.943652.621826.313Urbana y Rural14Pieza en casa antigua2015010075806060454030201513Urbana y Rural14Mejora, mediagua5663128315.522652.416989.311326.25663.113Urbana y Rural14Rancho, choza782391312.8234.6156.478.213Urbana y Rural14Ruca787393.5314.8236.1157.478.713Urbana y Rural14Mvil1266350.437.825.212.613Urbana y Rural14Otro tipo de vivienda367818391471.21103.4735.6367.813Urbana y Rural14Colectiva36831841.51473.21104.9736.6368.313Urbana y Rural14Personas en trnsito368818441475.21106.4737.6368.813Urbana y Rural29Casa1154987577493.5461994.8346496.1230997.4115498.713Urbana y Rural29Departamento24357412178797429.673072.248714.824357.413Urbana y Rural29Pieza en casa antigua2119510597.584786358.542392119.513Urbana y Rural29Mejora, mediagua4197120985.516788.412591.38394.24197.113Urbana y Rural29Rancho, choza668334267.2200.4133.666.813Urbana y Rural29Ruca673336.5269.2201.9134.667.313Urbana y Rural29Mvil15577.56246.53115.513Urbana y Rural29Otro tipo de vivienda37571878.51502.81127.1751.4375.713Urbana y Rural29Colectiva376218811504.81128.6752.4376.213Urbana y Rural29Personas en trnsito37671883.51506.81130.1753.4376.713Urbana y Rural29Ruca377218861508.81131.6754.4377.213Urbana y Rural29Mvil15577.56246.53115.513Urbana y Rural29Otro tipo de vivienda37571878.51502.81127.1751.4375.713Urbana y Rural29Colectiva376218811504.81128.6752.4376.213Urbana y Rural29Personas en trnsito37671883.51506.81130.1753.4376.713Urbana y Rural44Casa1131689565844.5452675.6339506.7226337.8113168.913Urbana y Rural44Departamento243717121858.597486.873115.148743.424371.713Urbana y Rural44Pieza en casa antigua20774103878309.66232.24154.82077.413Urbana y Rural44Mejora, mediagua429442147217177.612883.28588.84294.413Urbana y Rural44Rancho, choza8004003202401608013Urbana y Rural44Ruca805402.5322241.516180.513Urbana y Rural44Mvil20210180.860.640.420.213Urbana y Rural44Otro tipo de vivienda393019651572117978639313Urbana y Rural44Colectiva39351967.515741180.5787393.513Urbana y Rural44Personas en trnsito394019701576118278839413Urbana y Rural59Casa747195373597.5298878224158.514943974719.513Urbana y Rural59Departamento13803169015.555212.441409.327606.213803.113Urbana y Rural59Pieza en casa antigua859442973437.62578.21718.8859.413Urbana y Rural59Mejora, mediagua1749687486998.45248.83499.21749.613Urbana y Rural59Rancho, choza609304.5243.6182.7121.860.913Urbana y Rural59Ruca614307245.6184.2122.861.413Urbana y Rural59Mvil1427156.842.628.414.213Urbana y Rural59Otro tipo de vivienda1957978.5782.8587.1391.4195.713Urbana y Rural59Colectiva1962981784.8588.6392.4196.213Urbana y Rural59Personas en trnsito1967983.5786.8590.1393.4196.713Urbana y Rural74Casa390625195312.5156250117187.57812539062.513Urbana y Rural74Departamento7337736688.529350.822013.114675.47337.713Urbana y Rural74Pieza en casa antigua42992149.51719.61289.7859.8429.913Urbana y Rural74Mejora, mediagua79153957.531662374.51583791.513Urbana y Rural74Rancho, choza478239191.2143.495.647.813Urbana y Rural74Ruca483241.5193.2144.996.648.313Urbana y Rural74Mvil4723.518.814.19.44.713Urbana y Rural74Otro tipo de vivienda885442.5354265.517788.513Urbana y Rural74Colectiva8904453562671788913Urbana y Rural74Personas en trnsito895447.5358268.517989.513Urbana y Rural80Casa13831569157.55532641494.52766313831.513Urbana y Rural80Departamento334561672813382.410036.86691.23345.613Urbana y Rural80Pieza en casa antigua1657828.5662.8497.1331.4165.713Urbana y Rural80Mejora, mediagua23871193.5954.8716.1477.4238.713Urbana y Rural80Rancho, choza13567.55440.52713.513Urbana y Rural80Ruca140705642281413Urbana y Rural80Mvil94.53.62.71.80.913Urbana y Rural80Otro tipo de vivienda279139.5111.683.755.827.913Urbana y Rural80Colectiva284142113.685.256.828.413Urbana y Rural80Personas en trnsito289144.5115.686.757.828.913Urbana14Casa1155798577899462319.2346739.4231159.6115579.813Urbana14Departamento21824810912487299.265474.443649.621824.813Urbana14Pieza en casa antigua197039851.57881.25910.93940.61970.313Urbana14Mejora, mediagua530222651121208.815906.610604.45302.213Urbana14Rancho, choza676338270.4202.8135.267.613Urbana14Ruca681340.5272.4204.3136.268.113Urbana14Mvil6733.526.820.113.46.713Urbana14Otro tipo de vivienda358217911432.81074.6716.4358.213Urbana14Colectiva35871793.51434.81076.1717.4358.713Urbana14Personas en trnsito359217961436.81077.6718.4359.213Urbana29Casa1117692558846447076.8335307.6223538.4111769.213Urbana29Departamento24356212178197424.873068.648712.424356.213Urbana29Pieza en casa antigua20736103688294.46220.84147.22073.613Urbana29Mejora, mediagua3919719598.515678.811759.17839.43919.713Urbana29Rancho, choza576288230.4172.8115.257.613Urbana29Ruca581290.5232.4174.3116.258.113Urbana29Mvil1025140.830.620.410.213Urbana29Otro tipo de vivienda36611830.51464.41098.3732.2366.113Urbana29Colectiva366618331466.41099.8733.2366.613Urbana29Personas en trnsito36711835.51468.41101.3734.2367.113Urbana44Casa1091169545584.5436467.6327350.7218233.8109116.913Urbana44Departamento24370612185397482.473111.848741.224370.613Urbana44Pieza en casa antigua2028110140.58112.46084.34056.22028.113Urbana44Mejora, mediagua4023520117.51609412070.580474023.513Urbana44Rancho, choza662331264.8198.6132.466.213Urbana44Ruca667333.5266.8200.1133.466.713Urbana44Mvil14974.559.644.729.814.913Urbana44Otro tipo de vivienda38011900.51520.41140.3760.2380.113Urbana44Colectiva380619031522.41141.8761.2380.613Urbana44Personas en trnsito38111905.51524.41143.3762.2381.113Urbana59Casa723382361691289352.8217014.6144676.472338.213Urbana59Departamento13802169010.555208.441406.327604.213802.113Urbana59Pieza en casa antigua833841693335.22501.41667.6833.813Urbana59Mejora, mediagua1607680386430.44822.83215.21607.613Urbana59Rancho, choza455227.5182136.59145.513Urbana59Ruca460230184138924613Urbana59Mvil9748.538.829.119.49.713Urbana59Otro tipo de vivienda1886943754.4565.8377.2188.613Urbana59Colectiva1891945.5756.4567.3378.2189.113Urbana59Personas en trnsito1896948758.4568.8379.2189.613Urbana74Casa377768188884151107.2113330.475553.637776.813Urbana74Departamento733743668729349.622012.214674.87337.413Urbana74Pieza en casa antigua41172058.51646.81235.1823.4411.713Urbana74Mejora, mediagua720436022881.62161.21440.8720.413Urbana74Rancho, choza305152.512291.56130.513Urbana74Ruca31015512493623113Urbana74Mvil361814.410.87.23.613Urbana74Otro tipo de vivienda858429343.2257.4171.685.813Urbana74Colectiva863431.5345.2258.9172.686.313Urbana74Personas en trnsito868434347.2260.4173.686.813Urbana80Casa13430567152.55372240291.52686113430.513Urbana80Departamento3345516727.51338210036.566913345.513Urbana80Pieza en casa antigua1575787.5630472.5315157.513Urbana80Mejora, mediagua2160108086464843221613Urbana80Rancho, choza8743.534.826.117.48.713Urbana80Ruca924636.827.618.49.213Urbana80Mvil843.22.41.60.813Urbana80Otro tipo de vivienda271135.5108.481.354.227.113Urbana80Colectiva276138110.482.855.227.613Urbana80Personas en trnsito281140.5112.484.356.228.113Rural14Casa460842304218433.613825.29216.84608.413Rural14Departamento157.564.531.513Rural14Pieza en casa antigua447223.5178.8134.189.444.713Rural14Mejora, mediagua36091804.51443.61082.7721.8360.913Rural14Rancho, choza1065342.431.821.210.613Rural14Ruca11155.544.433.322.211.113Rural14Mvil5929.523.617.711.85.913Rural14Otro tipo de vivienda964838.428.819.29.613Rural14Colectiva10150.540.430.320.210.113Rural14Personas en trnsito1065342.431.821.210.613Rural29Casa3729518647.51491811188.574593729.513Rural29Departamento1264.83.62.41.213Rural29Pieza en casa antigua459229.5183.6137.791.845.913Rural29Mejora, mediagua277413871109.6832.2554.8277.413Rural29Rancho, choza924636.827.618.49.213Rural29Ruca9748.538.829.119.49.713Rural29Mvil5326.521.215.910.65.313Rural29Otro tipo de vivienda964838.428.819.29.613Rural29Colectiva10150.540.430.320.210.113Rural29Personas en trnsito1065342.431.821.210.613Rural44Casa405202026016208121568104405213Rural44Departamento115.54.43.32.21.113Rural44Pieza en casa antigua493246.5197.2147.998.649.313Rural44Mejora, mediagua27091354.51083.6812.7541.8270.913Rural44Rancho, choza1386955.241.427.613.813Rural44Ruca14371.557.242.928.614.313Rural44Mvil5326.521.215.910.65.313Rural44Otro tipo de vivienda12964.551.638.725.812.913Rural44Colectiva1346753.640.226.813.413Rural44Personas en trnsito13969.555.641.727.813.913Rural59Casa2381311906.59525.27143.94762.62381.313Rural59Departamento105432113Rural59Pieza en casa antigua256128102.476.851.225.613Rural59Mejora, mediagua142071056842628414213Rural59Rancho, choza1547761.646.230.815.413Rural59Ruca15979.563.647.731.815.913Rural59Mvil4522.51813.594.513Rural59Otro tipo de vivienda7135.528.421.314.27.113Rural59Colectiva763830.422.815.27.613Rural59Personas en trnsito8140.532.424.316.28.113Rural74Casa128576428.55142.83857.12571.41285.713Rural74Departamento31.51.20.90.60.313Rural74Pieza en casa antigua1829172.854.636.418.213Rural74Mejora, mediagua711355.5284.4213.3142.271.113Rural74Rancho, choza17386.569.251.934.617.313Rural74Ruca1788971.253.435.617.813Rural74Mvil115.54.43.32.21.113Rural74Otro tipo de vivienda2713.510.88.15.42.713Rural74Colectiva321612.89.66.43.213Rural74Personas en trnsito3718.514.811.17.43.713Rural80Casa401020051604120380240113Rural80Departamento10.50.40.30.20.113Rural80Pieza en casa antigua824132.824.616.48.213Rural80Mejora, mediagua227113.590.868.145.422.713Rural80Rancho, choza482419.214.49.64.813Rural80Ruca5326.521.215.910.65.313Rural80Mvil10.50.40.30.20.113Rural80Otro tipo de vivienda843.22.41.60.813Rural80Colectiva136.55.23.92.61.313Rural80Personas en trnsito1897.25.43.61.8

Prg66.- Copia la planilla de la Prg1 y crea un autofiltro de tal manera que contenga solo los elementos que contengan Permantes sobre 6000RegionAreaAosTipoTotPersonasPermanentesSemipermanentesOtrosViviendasColectivasPobl.en transito13Urbana y Rural14Casa1201882600941480752.8360564.6240376.4120188.213Urbana y Rural14Departamento218263109131.587305.265478.943652.621826.313Urbana y Rural14Pieza en casa antigua2015010075806060454030201513Urbana y Rural14Mejora, mediagua5663128315.522652.416989.311326.25663.113Urbana y Rural14Rancho, choza782391312.8234.6156.478.213Urbana y Rural14Ruca787393.5314.8236.1157.478.713Urbana y Rural14Mvil1266350.437.825.212.613Urbana y Rural14Otro tipo de vivienda367818391471.21103.4735.6367.813Urbana y Rural14Colectiva36831841.51473.21104.9736.6368.313Urbana y Rural14Personas en trnsito368818441475.21106.4737.6368.813Urbana y Rural29Casa1154987577493.5461994.8346496.1230997.4115498.713Urbana y Rural29Departamento24357412178797429.673072.248714.824357.413Urbana y Rural29Pieza en casa antigua2119510597.584786358.542392119.513Urbana y Rural29Mejora, mediagua4197120985.516788.412591.38394.24197.113Urbana y Rural29Rancho, choza668334267.2200.4133.666.813Urbana y Rural29Ruca673336.5269.2201.9134.667.313Urbana y Rural29Mvil15577.56246.53115.513Urbana y Rural29Otro tipo de vivienda37571878.51502.81127.1751.4375.713Urbana y Rural29Colectiva376218811504.81128.6752.4376.213Urbana y Rural29Personas en trnsito37671883.51506.81130.1753.4376.713Urbana y Rural29Ruca377218861508.81131.6754.4377.213Urbana y Rural29Mvil15577.56246.53115.513Urbana y Rural29Otro tipo de vivienda37571878.51502.81127.1751.4375.713Urbana y Rural29Colectiva376218811504.81128.6752.4376.213Urbana y Rural29Personas en trnsito37671883.51506.81130.1753.4376.713Urbana y Rural44Casa1131689565844.5452675.6339506.7226337.8113168.913Urbana y Rural44Departamento243717121858.597486.873115.148743.424371.713Urbana y Rural44Pieza en casa antigua20774103878309.66232.24154.82077.413Urbana y Rural44Mejora, mediagua429442147217177.612883.28588.84294.413Urbana y Rural44Rancho, choza8004003202401608013Urbana y Rural44Ruca805402.5322241.516180.513Urbana y Rural44Mvil20210180.860.640.420.213Urbana y Rural44Otro tipo de vivienda393019651572117978639313Urbana y Rural44Colectiva39351967.515741180.5787393.513Urbana y Rural44Personas en trnsito394019701576118278839413Urbana y Rural59Casa747195373597.5298878224158.514943974719.513Urbana y Rural59Departamento13803169015.555212.441409.327606.213803.113Urbana y Rural59Pieza en casa antigua859442973437.62578.21718.8859.413Urbana y Rural59Mejora, mediagua1749687486998.45248.83499.21749.613Urbana y Rural59Rancho, choza609304.5243.6182.7121.860.913Urbana y Rural59Ruca614307245.6184.2122.861.413Urbana y Rural59Mvil1427156.842.628.414.213Urbana y Rural59Otro tipo de vivienda1957978.5782.8587.1391.4195.713Urbana y Rural59Colectiva1962981784.8588.6392.4196.213Urbana y Rural59Personas en trnsito1967983.5786.8590.1393.4196.713Urbana y Rural74Casa390625195312.5156250117187.57812539062.513Urbana y Rural74Departamento7337736688.529350.822013.114675.47337.713Urbana y Rural74Pieza en casa antigua42992149.51719.61289.7859.8429.913Urbana y Rural74Mejora, mediagua79153957.531662374.51583791.513Urbana y Rural74Rancho, choza478239191.2143.495.647.813Urbana y Rural74Ruca483241.5193.2144.996.648.313Urbana y Rural74Mvil4723.518.814.19.44.713Urbana y Rural74Otro tipo de vivienda885442.5354265.517788.513Urbana y Rural74Colectiva8904453562671788913Urbana y Rural74Personas en trnsito895447.5358268.517989.513Urbana y Rural80Casa13831569157.55532641494.52766313831.513Urbana y Rural80Departamento334561672813382.410036.86691.23345.613Urbana y Rural80Pieza en casa antigua1657828.5662.8497.1331.4165.713Urbana y Rural80Mejora, mediagua23871193.5954.8716.1477.4238.713Urbana y Rural80Rancho, choza13567.55440.52713.513Urbana y Rural80Ruca140705642281413Urbana y Rural80Mvil94.53.62.71.80.913Urbana y Rural80Otro tipo de vivienda279139.5111.683.755.827.913Urbana y Rural80Colectiva284142113.685.256.828.413Urbana y Rural80Personas en trnsito289144.5115.686.757.828.913Urbana14Casa1155798577899462319.2346739.4231159.6115579.813Urbana14Departamento21824810912487299.265474.443649.621824.813Urbana14Pieza en casa antigua197039851.57881.25910.93940.61970.313Urbana14Mejora, mediagua530222651121208.815906.610604.45302.213Urbana14Rancho, choza676338270.4202.8135.267.613Urbana14Ruca681340.5272.4204.3136.268.113Urbana14Mvil6733.526.820.113.46.713Urbana14Otro tipo de vivienda358217911432.81074.6716.4358.213Urbana14Colectiva35871793.51434.81076.1717.4358.713Urbana14Personas en trnsito359217961436.81077.6718.4359.213Urbana29Casa1117692558846447076.8335307.6223538.4111769.213Urbana29Departamento24356212178197424.873068.648712.424356.213Urbana29Pieza en casa antigua20736103688294.46220.84147.22073.613Urbana29Mejora, mediagua3919719598.515678.811759.17839.43919.713Urbana29Rancho, choza576288230.4172.8115.257.613Urbana29Ruca581290.5232.4174.3116.258.113Urbana29Mvil1025140.830.620.410.213Urbana29Otro tipo de vivienda36611830.51464.41098.3732.2366.113Urbana29Colectiva366618331466.41099.8733.2366.613Urbana29Personas en trnsito36711835.51468.41101.3734.2367.113Urbana44Casa1091169545584.5436467.6327350.7218233.8109116.913Urbana44Departamento24370612185397482.473111.848741.224370.613Urbana44Pieza en casa antigua2028110140.58112.46084.34056.22028.113Urbana44Mejora, mediagua4023520117.51609412070.580474023.513Urbana44Rancho, choza662331264.8198.6132.466.213Urbana44Ruca667333.5266.8200.1133.466.713Urbana44Mvil14974.559.644.729.814.913Urbana44Otro tipo de vivienda38011900.51520.41140.3760.2380.113Urbana44Colectiva380619031522.41141.8761.2380.613Urbana44Personas en trnsito38111905.51524.41143.3762.2381.113Urbana59Casa723382361691289352.8217014.6144676.472338.213Urbana59Departamento13802169010.555208.441406.327604.213802.113Urbana59Pieza en casa antigua833841693335.22501.41667.6833.813Urbana59Mejora, mediagua1607680386430.44822.83215.21607.613Urbana59Rancho, choza455227.5182136.59145.513Urbana59Ruca460230184138924613Urbana59Mvil9748.538.829.119.49.713Urbana59Otro tipo de vivienda1886943754.4565.8377.2188.613Urbana59Colectiva1891945.5756.4567.3378.2189.113Urbana59Personas en trnsito1896948758.4568.8379.2189.613Urbana74Casa377768188884151107.2113330.475553.637776.813Urbana74Departamento733743668729349.622012.214674.87337.413Urbana74Pieza en casa antigua41172058.51646.81235.1823.4411.713Urbana74Mejora, mediagua720436022881.62161.21440.8720.413Urbana74Rancho, choza305152.512291.56130.513Urbana74Ruca31015512493623113Urbana74Mvil361814.410.87.23.613Urbana74Otro tipo de vivienda858429343.2257.4171.685.813Urbana74Colectiva863431.5345.2258.9172.686.313Urbana74Personas en trnsito868434347.2260.4173.686.813Urbana80Casa13430567152.55372240291.52686113430.513Urbana80Departamento3345516727.51338210036.566913345.513Urbana80Pieza en casa antigua1575787.5630472.5315157.513Urbana80Mejora, mediagua2160108086464843221613Urbana80Rancho, choza8743.534.826.117.48.713Urbana80Ruca924636.827.618.49.213Urbana80Mvil843.22.41.60.813Urbana80Otro tipo de vivienda271135.5108.481.354.227.113Urbana80Colectiva276138110.482.855.227.613Urbana80Personas en trnsito281140.5112.484.356.228.113Rural14Casa460842304218433.613825.29216.84608.413Rural14Departamento157.564.531.513Rural14Pieza en casa antigua447223.5178.8134.189.444.713Rural14Mejora, mediagua36091804.51443.61082.7721.8360.913Rural14Rancho, choza1065342.431.821.210.613Rural14Ruca11155.544.433.322.211.113Rural14Mvil5929.523.617.711.85.913Rural14Otro tipo de vivienda964838.428.819.29.613Rural14Colectiva10150.540.430.320.210.113Rural14Personas en trnsito1065342.431.821.210.613Rural29Casa3729518647.51491811188.574593729.513Rural29Departamento1264.83.62.41.213Rural29Pieza en casa antigua459229.5183.6137.791.845.913Rural29Mejora, mediagua277413871109.6832.2554.8277.413Rural29Rancho, choza924636.827.618.49.213Rural29Ruca9748.538.829.119.49.713Rural29Mvil5326.521.215.910.65.313Rural29Otro tipo de vivienda964838.428.819.29.613Rural29Colectiva10150.540.430.320.210.113Rural29Personas en trnsito1065342.431.821.210.613Rural44Casa405202026016208121568104405213Rural44Departamento115.54.43.32.21.113Rural44Pieza en casa antigua493246.5197.2147.998.649.313Rural44Mejora, mediagua27091354.51083.6812.7541.8270.913Rural44Rancho, choza1386955.241.427.613.813Rural44Ruca14371.557.242.928.614.313Rural44Mvil5326.521.215.910.65.313Rural44Otro tipo de vivienda12964.551.638.725.812.913Rural44Colectiva1346753.640.226.813.413Rural44Personas en trnsito13969.555.641.727.813.913Rural59Casa2381311906.59525.27143.94762.62381.313Rural59Departamento105432113Rural59Pieza en casa antigua256128102.476.851.225.613Rural59Mejora, mediagua142071056842628414213Rural59Rancho, choza1547761.646.230.815.413Rural59Ruca15979.563.647.731.815.913Rural59Mvil4522.51813.594.513Rural59Otro tipo de vivienda7135.528.421.314.27.113Rural59Colectiva763830.422.815.27.613Rural59Personas en trnsito8140.532.424.316.28.113Rural74Casa128576428.55142.83857.12571.41285.713Rural74Departamento31.51.20.90.60.313Rural74Pieza en casa antigua1829172.854.636.418.213Rural74Mejora, mediagua711355.5284.4213.3142.271.113Rural74Rancho, choza17386.569.251.934.617.313Rural74Ruca1788971.253.435.617.813Rural74Mvil115.54.43.32.21.113Rural74Otro tipo de vivienda2713.510.88.15.42.713Rural74Colectiva321612.89.66.43.213Rural74Personas en trnsito3718.514.811.17.43.713Rural80Casa401020051604120380240113Rural80Departamento10.50.40.30.20.113Rural80Pieza en casa antigua824132.824.616.48.213Rural80Mejora, mediagua227113.590.868.145.422.713Rural80Rancho, choza482419.214.49.64.813Rural80Ruca5326.521.215.910.65.313Rural80Mvil10.50.40.30.20.113Rural80Otro tipo de vivienda843.22.41.60.813Rural80Colectiva136.55.23.92.61.313Rural80Personas en trnsito1897.25.43.61.8

Prg77.- Copia la planilla de la Prg1 y crea un autofiltro de tal manera que contenga solo los elementos que contengan Tipo casaRegionAreaAosTipoTotPersonasPermanentesSemipermanentesOtrosViviendasColectivasPobl.en transito13Urbana y Rural14Casa1201882600941480752.8360564.6240376.4120188.213Urbana y Rural14Departamento218263109131.587305.265478.943652.621826.313Urbana y Rural14Pieza en casa antigua2015010075806060454030201513Urbana y Rural14Mejora, mediagua5663128315.522652.416989.311326.25663.113Urbana y Rural14Rancho, choza782391312.8234.6156.478.213Urbana y Rural14Ruca787393.5314.8236.1157.478.713Urbana y Rural14Mvil1266350.437.825.212.613Urbana y Rural14Otro tipo de vivienda367818391471.21103.4735.6367.813Urbana y Rural14Colectiva36831841.51473.21104.9736.6368.313Urbana y Rural14Personas en trnsito368818441475.21106.4737.6368.813Urbana y Rural29Casa1154987577493.5461994.8346496.1230997.4115498.713Urbana y Rural29Departamento24357412178797429.673072.248714.824357.413Urbana y Rural29Pieza en casa antigua2119510597.584786358.542392119.513Urbana y Rural29Mejora, mediagua4197120985.516788.412591.38394.24197.113Urbana y Rural29Rancho, choza668334267.2200.4133.666.813Urbana y Rural29Ruca673336.5269.2201.9134.667.313Urbana y Rural29Mvil15577.56246.53115.513Urbana y Rural29Otro tipo de vivienda37571878.51502.81127.1751.4375.713Urbana y Rural29Colectiva376218811504.81128.6752.4376.213Urbana y Rural29Personas en trnsito37671883.51506.81130.1753.4376.713Urbana y Rural29Ruca377218861508.81131.6754.4377.213Urbana y Rural29Mvil15577.56246.53115.513Urbana y Rural29Otro tipo de vivienda37571878.51502.81127.1751.4375.713Urbana y Rural29Colectiva376218811504.81128.6752.4376.213Urbana y Rural29Personas en trnsito37671883.51506.81130.1753.4376.713Urbana y Rural44Casa1131689565844.5452675.6339506.7226337.8113168.913Urbana y Rural44Departamento243717121858.597486.873115.148743.424371.713Urbana y Rural44Pieza en casa antigua20774103878309.66232.24154.82077.413Urbana y Rural44Mejora, mediagua429442147217177.612883.28588.84294.413Urbana y Rural44Rancho, choza8004003202401608013Urbana y Rural44Ruca805402.5322241.516180.513Urbana y Rural44Mvil20210180.860.640.420.213Urbana y Rural44Otro tipo de vivienda393019651572117978639313Urbana y Rural44Colectiva39351967.515741180.5787393.513Urbana y Rural44Personas en trnsito394019701576118278839413Urbana y Rural59Casa747195373597.5298878224158.514943974719.513Urbana y Rural59Departamento13803169015.555212.441409.327606.213803.113Urbana y Rural59Pieza en casa antigua859442973437.62578.21718.8859.413Urbana y Rural59Mejora, mediagua1749687486998.45248.83499.21749.613Urbana y Rural59Rancho, choza609304.5243.6182.7121.860.913Urbana y Rural59Ruca614307245.6184.2122.861.413Urbana y Rural59Mvil1427156.842.628.414.213Urbana y Rural59Otro tipo de vivienda1957978.5782.8587.1391.4195.713Urbana y Rural59Colectiva1962981784.8588.6392.4196.213Urbana y Rural59Personas en trnsito1967983.5786.8590.1393.4196.713Urbana y Rural74Casa390625195312.5156250117187.57812539062.513Urbana y Rural74Departamento7337736688.529350.822013.114675.47337.713Urbana y Rural74Pieza en casa antigua42992149.51719.61289.7859.8429.913Urbana y Rural74Mejora, mediagua79153957.531662374.51583791.513Urbana y Rural74Rancho, choza478239191.2143.495.647.813Urbana y Rural74Ruca483241.5193.2144.996.648.313Urbana y Rural74Mvil4723.518.814.19.44.713Urbana y Rural74Otro tipo de vivienda885442.5354265.517788.513Urbana y Rural74Colectiva8904453562671788913Urbana y Rural74Personas en trnsito895447.5358268.517989.513Urbana y Rural80Casa13831569157.55532641494.52766313831.513Urbana y Rural80Departamento334561672813382.410036.86691.23345.613Urbana y Rural80Pieza en casa antigua1657828.5662.8497.1331.4165.713Urbana y Rural80Mejora, mediagua23871193.5954.8716.1477.4238.713Urbana y Rural80Rancho, choza13567.55440.52713.513Urbana y Rural80Ruca140705642281413Urbana y Rural80Mvil94.53.62.71.80.913Urbana y Rural80Otro tipo de vivienda279139.5111.683.755.827.913Urbana y Rural80Colectiva284142113.685.256.828.413Urbana y Rural80Personas en trnsito289144.5115.686.757.828.913Urbana14Casa1155798577899462319.2346739.4231159.6115579.813Urbana14Departamento21824810912487299.265474.443649.621824.813Urbana14Pieza en casa antigua197039851.57881.25910.93940.61970.313Urbana14Mejora, mediagua530222651121208.815906.610604.45302.213Urbana14Rancho, choza676338270.4202.8135.267.613Urbana14Ruca681340.5272.4204.3136.268.113Urbana14Mvil6733.526.820.113.46.713Urbana14Otro tipo de vivienda358217911432.81074.6716.4358.213Urbana14Colectiva35871793.51434.81076.1717.4358.713Urbana14Personas en trnsito359217961436.81077.6718.4359.213Urbana29Casa1117692558846447076.8335307.6223538.4111769.213Urbana29Departamento24356212178197424.873068.648712.424356.213Urbana29Pieza en casa antigua20736103688294.46220.84147.22073.613Urbana29Mejora, mediagua3919719598.515678.811759.17839.43919.713Urbana29Rancho, choza576288230.4172.8115.257.613Urbana29Ruca581290.5232.4174.3116.258.113Urbana29Mvil1025140.830.620.410.213Urbana29Otro tipo de vivienda36611830.51464.41098.3732.2366.113Urbana29Colectiva366618331466.41099.8733.2366.613Urbana29Personas en trnsito36711835.51468.41101.3734.2367.113Urbana44Casa1091169545584.5436467.6327350.7218233.8109116.913Urbana44Departamento24370612185397482.473111.848741.224370.613Urbana44Pieza en casa antigua2028110140.58112.46084.34056.22028.113Urbana44Mejora, mediagua4023520117.51609412070.580474023.513Urbana44Rancho, choza662331264.8198.6132.466.213Urbana44Ruca667333.5266.8200.1133.466.713Urbana44Mvil14974.559.644.729.814.913Urbana44Otro tipo de vivienda38011900.51520.41140.3760.2380.113Urbana44Colectiva380619031522.41141.8761.2380.613Urbana44Personas en trnsito38111905.51524.41143.3762.2381.113Urbana59Casa723382361691289352.8217014.6144676.472338.213Urbana59Departamento13802169010.555208.441406.327604.213802.113Urbana59Pieza en casa antigua833841693335.22501.41667.6833.813Urbana59Mejora, mediagua1607680386430.44822.83215.21607.613Urbana59Rancho, choza455227.5182136.59145.513Urbana59Ruca460230184138924613Urbana59Mvil9748.538.829.119.49.713Urbana59Otro tipo de vivienda1886943754.4565.8377.2188.613Urbana59Colectiva1891945.5756.4567.3378.2189.113Urbana59Personas en trnsito1896948758.4568.8379.2189.613Urbana74Casa377768188884151107.2113330.475553.637776.813Urbana74Departamento733743668729349.622012.214674.87337.413Urbana74Pieza en casa antigua41172058.51646.81235.1823.4411.713Urbana74Mejora, mediagua720436022881.62161.21440.8720.413Urbana74Rancho, choza305152.512291.56130.513Urbana74Ruca31015512493623113Urbana74Mvil361814.410.87.23.613Urbana74Otro tipo de vivienda858429343.2257.4171.685.813Urbana74Colectiva863431.5345.2258.9172.686.313Urbana74Personas en trnsito868434347.2260.4173.686.813Urbana80Casa13430567152.55372240291.52686113430.513Urbana80Departamento3345516727.51338210036.566913345.513Urbana80Pieza en casa antigua1575787.5630472.5315157.513Urbana80Mejora, mediagua2160108086464843221613Urbana80Rancho, choza8743.534.826.117.48.713Urbana80Ruca924636.827.618.49.213Urbana80Mvil843.22.41.60.813Urbana80Otro tipo de vivienda271135.5108.481.354.227.113Urbana80Colectiva276138110.482.855.227.613Urbana80Personas en trnsito281140.5112.484.356.228.113Rural14Casa460842304218433.613825.29216.84608.413Rural14Departamento157.564.531.513Rural14Pieza en casa antigua447223.5178.8134.189.444.713Rural14Mejora, mediagua36091804.51443.61082.7721.8360.913Rural14Rancho, choza1065342.431.821.210.613Rural14Ruca11155.544.433.322.211.113Rural14Mvil5929.523.617.711.85.913Rural14Otro tipo de vivienda964838.428.819.29.613Rural14Colectiva10150.540.430.320.210.113Rural14Personas en trnsito1065342.431.821.210.613Rural29Casa3729518647.51491811188.574593729.513Rural29Departamento1264.83.62.41.213Rural29Pieza en casa antigua459229.5183.6137.791.845.913Rural29Mejora, mediagua277413871109.6832.2554.8277.413Rural29Rancho, choza924636.827.618.49.213Rural29Ruca9748.538.829.119.49.713Rural29Mvil5326.521.215.910.65.313Rural29Otro tipo de vivienda964838.428.819.29.613Rural29Colectiva10150.540.430.320.210.113Rural29Personas en trnsito1065342.431.821.210.613Rural44Casa405202026016208121568104405213Rural44Departamento115.54.43.32.21.113Rural44Pieza en casa antigua493246.5197.2147.998.649.313Rural44Mejora, mediagua27091354.51083.6812.7541.8270.913Rural44Rancho, choza1386955.241.427.613.813Rural44Ruca14371.557.242.928.614.313Rural44Mvil5326.521.215.910.65.313Rural44Otro tipo de vivienda12964.551.638.725.812.913Rural44Colectiva1346753.640.226.813.413Rural44Personas en trnsito13969.555.641.727.813.913Rural59Casa2381311906.59525.27143.94762.62381.313Rural59Departamento105432113Rural59Pieza en casa antigua256128102.476.851.225.613Rural59Mejora, mediagua142071056842628414213Rural59Rancho, choza1547761.646.230.815.413Rural59Ruca15979.563.647.731.815.913Rural59Mvil4522.51813.594.513Rural59Otro tipo de vivienda7135.528.421.314.27.113Rural59Colectiva763830.422.815.27.613Rural59Personas en trnsito8140.532.424.316.28.113Rural74Casa128576428.55142.83857.12571.41285.713Rural74Departamento31.51.20.90.60.313Rural74Pieza en casa antigua1829172.854.636.418.213Rural74Mejora, mediagua711355.5284.4213.3142.271.113Rural74Rancho, choza17386.569.251.934.617.313Rural74Ruca1788971.253.435.617.813Rural74Mvil115.54.43.32.21.113Rural74Otro tipo de vivienda2713.510.88.15.42.713Rural74Colectiva321612.89.66.43.213Rural74Personas en trnsito3718.514.811.17.43.713Rural80Casa401020051604120380240113Rural80Departamento10.50.40.30.20.113Rural80Pieza en casa antigua824132.824.616.48.213Rural80Mejora, mediagua227113.590.868.145.422.713Rural80Rancho, choza482419.214.49.64.813Rural80Ruca5326.521.215.910.65.313Rural80Mvil10.50.40.30.20.113Rural80Otro tipo de vivienda843.22.41.60.813Rural80Colectiva136.55.23.92.61.313Rural80Personas en trnsito1897.25.43.61.8

Prg88.- Copia la planilla de la Prg1 y crea un autofiltro de tal manera que contenga solo los elementos que contengan Tipo casa o departamentoRegionAreaAosTipoTotPersonasPermanentesSemipermanentesOtrosViviendasColectivasPobl.en transito13Urbana y Rural14Casa1201882600941480752.8360564.6240376.4120188.213Urbana y Rural14Departamento218263109131.587305.265478.943652.621826.313Urbana y Rural14Pieza en casa antigua2015010075806060454030201513Urbana y Rural14Mejora, mediagua5663128315.522652.416989.311326.25663.113Urbana y Rural14Rancho, choza782391312.8234.6156.478.213Urbana y Rural14Ruca787393.5314.8236.1157.478.713Urbana y Rural14Mvil1266350.437.825.212.613Urbana y Rural14Otro tipo de vivienda367818391471.21103.4735.6367.813Urbana y Rural14Colectiva36831841.51473.21104.9736.6368.313Urbana y Rural14Personas en trnsito368818441475.21106.4737.6368.813Urbana y Rural29Casa1154987577493.5461994.8346496.1230997.4115498.713Urbana y Rural29Departamento24357412178797429.673072.248714.824357.413Urbana y Rural29Pieza en casa antigua2119510597.584786358.542392119.513Urbana y Rural29Mejora, mediagua4197120985.516788.412591.38394.24197.113Urbana y Rural29Rancho, choza668334267.2200.4133.666.813Urbana y Rural29Ruca673336.5269.2201.9134.667.313Urbana y Rural29Mvil15577.56246.53115.513Urbana y Rural29Otro tipo de vivienda37571878.51502.81127.1751.4375.713Urbana y Rural29Colectiva376218811504.81128.6752.4376.213Urbana y Rural29Personas en trnsito37671883.51506.81130.1753.4376.713Urbana y Rural29Ruca377218861508.81131.6754.4377.213Urbana y Rural29Mvil15577.56246.53115.513Urbana y Rural29Otro tipo de vivienda37571878.51502.81127.1751.4375.713Urbana y Rural29Colectiva376218811504.81128.6752.4376.213Urbana y Rural29Personas en trnsito37671883.51506.81130.1753.4376.713Urbana y Rural44Casa1131689565844.5452675.6339506.7226337.8113168.913Urbana y Rural44Departamento243717121858.597486.873115.148743.424371.713Urbana y Rural44Pieza en casa antigua20774103878309.66232.24154.82077.413Urbana y Rural44Mejora, mediagua429442147217177.612883.28588.84294.413Urbana y Rural44Rancho, choza8004003202401608013Urbana y Rural44Ruca805402.5322241.516180.513Urbana y Rural44Mvil20210180.860.640.420.213Urbana y Rural44Otro tipo de vivienda393019651572117978639313Urbana y Rural44Colectiva39351967.515741180.5787393.513Urbana y Rural44Personas en trnsito394019701576118278839413Urbana y Rural59Casa747195373597.5298878224158.514943974719.513Urbana y Rural59Departamento13803169015.555212.441409.327606.213803.113Urbana y Rural59Pieza en casa antigua859442973437.62578.21718.8859.413Urbana y Rural59Mejora, mediagua1749687486998.45248.83499.21749.613Urbana y Rural59Rancho, choza609304.5243.6182.7121.860.913Urbana y Rural59Ruca614307245.6184.2122.861.413Urbana y Rural59Mvil1427156.842.628.414.213Urbana y Rural59Otro tipo de vivienda1957978.5782.8587.1391.4195.713Urbana y Rural59Colectiva1962981784.8588.6392.4196.213Urbana y Rural59Personas en trnsito1967983.5786.8590.1393.4196.713Urbana y Rural74Casa390625195312.5156250117187.57812539062.513Urbana y Rural74Departamento7337736688.529350.822013.114675.47337.713Urbana y Rural74Pieza en casa antigua42992149.51719.61289.7859.8429.913Urbana y Rural74Mejora, mediagua79153957.531662374.51583791.513Urbana y Rural74Rancho, choza478239191.2143.495.647.813Urbana y Rural74Ruca483241.5193.2144.996.648.313Urbana y Rural74Mvil4723.518.814.19.44.713Urbana y Rural74Otro tipo de vivienda885442.5354265.517788.513Urbana y Rural74Colectiva8904453562671788913Urbana y Rural74Personas en trnsito895447.5358268.517989.513Urbana y Rural80Casa13831569157.55532641494.52766313831.513Urbana y Rural80Departamento334561672813382.410036.86691.23345.613Urbana y Rural80Pieza en casa antigua1657828.5662.8497.1331.4165.713Urbana y Rural80Mejora, mediagua23871193.5954.8716.1477.4238.713Urbana y Rural80Rancho, choza13567.55440.52713.513Urbana y Rural80Ruca140705642281413Urbana y Rural80Mvil94.53.62.71.80.913Urbana y Rural80Otro tipo de vivienda279139.5111.683.755.827.913Urbana y Rural80Colectiva284142113.685.256.828.413Urbana y Rural80Personas en trnsito289144.5115.686.757.828.913Urbana14Casa1155798577899462319.2346739.4231159.6115579.813Urbana14Departamento21824810912487299.265474.443649.621824.813Urbana14Pieza en casa antigua197039851.57881.25910.93940.61970.313Urbana14Mejora, mediagua530222651121208.815906.610604.45302.213Urbana14Rancho, choza676338270.4202.8135.267.613Urbana14Ruca681340.5272.4204.3136.268.113Urbana14Mvil6733.526.820.113.46.713Urbana14Otro tipo de vivienda358217911432.81074.6716.4358.213Urbana14Colectiva35871793.51434.81076.1717.4358.713Urbana14Personas en trnsito359217961436.81077.6718.4359.213Urbana29Casa1117692558846447076.8335307.6223538.4111769.213Urbana29Departamento24356212178197424.873068.648712.424356.213Urbana29Pieza en casa antigua20736103688294.46220.84147.22073.613Urbana29Mejora, mediagua3919719598.515678.811759.17839.43919.713Urbana29Rancho, choza576288230.4172.8115.257.613Urbana29Ruca581290.5232.4174.3116.258.113Urbana29Mvil1025140.830.620.410.213Urbana29Otro tipo de vivienda36611830.51464.41098.3732.2366.113Urbana29Colectiva366618331466.41099.8733.2366.613Urbana29Personas en trnsito36711835.51468.41101.3734.2367.113Urbana44Casa1091169545584.5436467.6327350.7218233.8109116.913Urbana44Departamento24370612185397482.473111.848741.224370.613Urbana44Pieza en casa antigua2028110140.58112.46084.34056.22028.113Urbana44Mejora, mediagua4023520117.51609412070.580474023.513Urbana44Rancho, choza662331264.8198.6132.466.213Urbana44Ruca667333.5266.8200.1133.466.713Urbana44Mvil14974.559.644.729.814.913Urbana44Otro tipo de vivienda38011900.51520.41140.3760.2380.113Urbana44Colectiva380619031522.41141.8761.2380.613Urbana44Personas en trnsito38111905.51524.41143.3762.2381.113Urbana59Casa723382361691289352.8217014.6144676.472338.213Urbana59Departamento13802169010.555208.441406.327604.213802.113Urbana59Pieza en casa antigua833841693335.22501.41667.6833.813Urbana59Mejora, mediagua1607680386430.44822.83215.21607.613Urbana59Rancho, choza455227.5182136.59145.513Urbana59Ruca460230184138924613Urbana59Mvil9748.538.829.119.49.713Urbana59Otro tipo de vivienda1886943754.4565.8377.2188.613Urbana59Colectiva1891945.5756.4567.3378.2189.113Urbana59Personas en trnsito1896948758.4568.8379.2189.613Urbana74Casa377768188884151107.2113330.475553.637776.813Urbana74Departamento733743668729349.622012.214674.87337.413Urbana74Pieza en casa antigua41172058.51646.81235.1823.4411.713Urbana74Mejora, mediagua720436022881.62161.21440.8720.413Urbana74Rancho, choza305152.512291.56130.513Urbana74Ruca31015512493623113Urbana74Mvil361814.410.87.23.613Urbana74Otro tipo de vivienda858429343.2257.4171.685.813Urbana74Colectiva863431.5345.2258.9172.686.313Urbana74Personas en trnsito868434347.2260.4173.686.813Urbana80Casa13430567152.55372240291.52686113430.513Urbana80Departamento3345516727.51338210036.566913345.513Urbana80Pieza en casa antigua1575787.5630472.5315157.513Urbana80Mejora, mediagua2160108086464843221613Urbana80Rancho, choza8743.534.826.117.48.713Urbana80Ruca924636.827.618.49.213Urbana80Mvil843.22.41.60.813Urbana80Otro tipo de vivienda271135.5108.481.354.227.113Urbana80Colectiva276138110.482.855.227.613Urbana80Personas en trnsito281140.5112.484.356.228.113Rural14Casa460842304218433.613825.29216.84608.413Rural14Departamento157.564.531.513Rural14Pieza en casa antigua447223.5178.8134.189.444.713Rural14Mejora, mediagua36091804.51443.61082.7721.8360.913Rural14Rancho, choza1065342.431.821.210.613Rural14Ruca11155.544.433.322.211.113Rural14Mvil5929.523.617.711.85.913Rural14Otro tipo de vivienda964838.428.819.29.613Rural14Colectiva10150.540.430.320.210.113Rural14Personas en trnsito1065342.431.821.210.613Rural29Casa3729518647.51491811188.574593729.513Rural29Departamento1264.83.62.41.213Rural29Pieza en casa antigua459229.5183.6137.791.845.913Rural29Mejora, mediagua277413871109.6832.2554.8277.413Rural29Rancho, choza924636.827.618.49.213Rural29Ruca9748.538.829.119.49.713Rural29Mvil5326.521.215.910.65.313Rural29Otro tipo de vivienda964838.428.819.29.613Rural29Colectiva10150.540.430.320.210.113Rural29Personas en trnsito1065342.431.821.210.613Rural44Casa405202026016208121568104405213Rural44Departamento115.54.43.32.21.113Rural44Pieza en casa antigua493246.5197.2147.998.649.313Rural44Mejora, mediagua27091354.51083.6812.7541.8270.913Rural44Rancho, choza1386955.241.427.613.813Rural44Ruca14371.557.242.928.614.313Rural44Mvil5326.521.215.910.65.313Rural44Otro tipo de vivienda12964.551.638.725.812.913Rural44Colectiva1346753.640.226.813.413Rural44Personas en trnsito13969.555.641.727.813.913Rural59Casa2381311906.59525.27143.94762.62381.313Rural59Departamento105432113Rural59Pieza en casa antigua256128102.476.851.225.613Rural59Mejora, mediagua142071056842628414213Rural59Rancho, choza1547761.646.230.815.413Rural59Ruca15979.563.647.731.815.913Rural59Mvil4522.51813.594.513Rural59Otro tipo de vivienda7135.528.421.314.27.113Rural59Colectiva763830.422.815.27.613Rural59Personas en trnsito8140.532.424.316.28.113Rural74Casa128576428.55142.83857.12571.41285.713Rural74Departamento31.51.20.90.60.313Rural74Pieza en casa antigua1829172.854.636.418.213Rural74Mejora, mediagua711355.5284.4213.3142.271.113Rural74Rancho, choza17386.569.251.934.617.313Rural74Ruca1788971.253.435.617.813Rural74Mvil115.54.43.32.21.113Rural74Otro tipo de vivienda2713.510.88.15.42.713Rural74Colectiva321612.89.66.43.213Rural74Personas en trnsito3718.514.811.17.43.713Rural80Casa401020051604120380240113Rural80Departamento10.50.40.30.20.113Rural80Pieza en casa antigua824132.824.616.48.213Rural80Mejora, mediagua227113.590.868.145.422.713Rural80Rancho, choza482419.214.49.64.813Rural80Ruca5326.521.215.910.65.313Rural80Mvil10.50.40.30.20.113Rural80Otro tipo de vivienda843.22.41.60.813Rural80Colectiva136.55.23.92.61.313Rural80Personas en trnsito1897.25.43.61.8

Prg99.- Copia la planilla de la Prg1 y crea un autofiltro de tal manera que contenga solo los elementos que NO contengan Tipo rucaRegionAreaAosTipoTotPersonasPermanentesSemipermanentesOtrosViviendasColectivasPobl.en transito13Urbana y Rural14Casa1201882600941480752.8360564.6240376.4120188.213Urbana y Rural14Departamento218263109131.587305.265478.943652.621826.313Urbana y Rural14Pieza en casa antigua2015010075806060454030201513Urbana y Rural14Mejora, mediagua5663128315.522652.416989.311326.25663.113Urbana y Rural14Rancho, choza782391312.8234.6156.478.213Urbana y Rural14Ruca787393.5314.8236.1157.478.713Urbana y Rural14Mvil1266350.437.825.212.613Urbana y Rural14Otro tipo de vivienda367818391471.21103.4735.6367.813Urbana y Rural14Colectiva36831841.51473.21104.9736.6368.313Urbana y Rural14Personas en trnsito368818441475.21106.4737.6368.813Urbana y Rural29Casa1154987577493.5461994.8346496.1230997.4115498.713Urbana y Rural29Departamento24357412178797429.673072.248714.824357.413Urbana y Rural29Pieza en casa antigua2119510597.584786358.542392119.513Urbana y Rural29Mejora, mediagua4197120985.516788.412591.38394.24197.113Urbana y Rural29Rancho, choza668334267.2200.4133.666.813Urbana y Rural29Ruca673336.5269.2201.9134.667.313Urbana y Rural29Mvil15577.56246.53115.513Urbana y Rural29Otro tipo de vivienda37571878.51502.81127.1751.4375.713Urbana y Rural29Colectiva376218811504.81128.6752.4376.213Urbana y Rural29Personas en trnsito37671883.51506.81130.1753.4376.713Urbana y Rural29Ruca377218861508.81131.6754.4377.213Urbana y Rural29Mvil15577.56246.53115.513Urbana y Rural29Otro tipo de vivienda37571878.51502.81127.1751.4375.713Urbana y Rural29Colectiva376218811504.81128.6752.4376.213Urbana y Rural29Personas en trnsito37671883.51506.81130.1753.4376.713Urbana y Rural44Casa1131689565844.5452675.6339506.7226337.8113168.913Urbana y Rural44Departamento243717121858.597486.873115.148743.424371.713Urbana y Rural44Pieza en casa antigua20774103878309.66232.24154.82077.413Urbana y Rural44Mejora, mediagua429442147217177.612883.28588.84294.413Urbana y Rural44Rancho, choza8004003202401608013Urbana y Rural44Ruca805402.5322241.516180.513Urbana y Rural44Mvil20210180.860.640.420.213Urbana y Rural44Otro tipo de vivienda393019651572117978639313Urbana y Rural44Colectiva39351967.515741180.5787393.513Urbana y Rural44Personas en trnsito394019701576118278839413Urbana y Rural59Casa747195373597.5298878224158.514943974719.513Urbana y Rural59Departamento13803169015.555212.441409.327606.213803.113Urbana y Rural59Pieza en casa antigua859442973437.62578.21718.8859.413Urbana y Rural59Mejora, mediagua1749687486998.45248.83499.21749.613Urbana y Rural59Rancho, choza609304.5243.6182.7121.860.913Urbana y Rural59Ruca614307245.6184.2122.861.413Urbana y Rural59Mvil1427156.842.628.414.213Urbana y Rural59Otro tipo de vivienda1957978.5782.8587.1391.4195.713Urbana y Rural59Colectiva1962981784.8588.6392.4196.213Urbana y Rural59Personas en trnsito1967983.5786.8590.1393.4196.713Urbana y Rural74Casa390625195312.5156250117187.57812539062.513Urbana y Rural74Departamento7337736688.529350.822013.114675.47337.713Urbana y Rural74Pieza en casa antigua42992149.51719.61289.7859.8429.913Urbana y Rural74Mejora, mediagua79153957.531662374.51583791.513Urbana y Rural74Rancho, choza478239191.2143.495.647.813Urbana y Rural74Ruca483241.5193.2144.996.648.313Urbana y Rural74Mvil4723.518.814.19.44.713Urbana y Rural74Otro tipo de vivienda885442.5354265.517788.513Urbana y Rural74Colectiva8904453562671788913Urbana y Rural74Personas en trnsito895447.5358268.517989.513Urbana y Rural80Casa13831569157.55532641494.52766313831.513Urbana y Rural80Departamento334561672813382.410036.86691.23345.613Urbana y Rural80Pieza en casa antigua1657828.5662.8497.1331.4165.713Urbana y Rural80Mejora, mediagua23871193.5954.8716.1477.4238.713Urbana y Rural80Rancho, choza13567.55440.52713.513Urbana y Rural80Ruca140705642281413Urbana y Rural80Mvil94.53.62.71.80.913Urbana y Rural80Otro tipo de vivienda279139.5111.683.755.827.913Urbana y Rural80Colectiva284142113.685.256.828.413Urbana y Rural80Personas en trnsito289144.5115.686.757.828.913Urbana14Casa1155798577899462319.2346739.4231159.6115579.813Urbana14Departamento21824810912487299.265474.443649.621824.813Urbana14Pieza en casa antigua197039851.57881.25910.93940.61970.313Urbana14Mejora, mediagua530222651121208.815906.610604.45302.213Urbana14Rancho, choza676338270.4202.8135.267.613Urbana14Ruca681340.5272.4204.3136.268.113Urbana14Mvil6733.526.820.113.46.713Urbana14Otro tipo de vivienda358217911432.81074.6716.4358.213Urbana14Colectiva35871793.51434.81076.1717.4358.713Urbana14Personas en trnsito359217961436.81077.6718.4359.213Urbana29Casa1117692558846447076.8335307.6223538.4111769.213Urbana29Departamento24356212178197424.873068.648712.424356.213Urbana29Pieza en casa antigua20736103688294.46220.84147.22073.613Urbana29Mejora, mediagua3919719598.515678.811759.17839.43919.713Urbana29Rancho, choza576288230.4172.8115.257.613Urbana29Ruca581290.5232.4174.3116.258.113Urbana29Mvil1025140.830.620.410.213Urbana29Otro tipo de vivienda36611830.51464.41098.3732.2366.113Urbana29Colectiva366618331466.41099.8733.2366.613Urbana29Personas en trnsito36711835.51468.41101.3734.2367.113Urbana44Casa1091169545584.5436467.6327350.7218233.8109116.913Urbana44Departamento24370612185397482.473111.848741.224370.613Urbana44Pieza en casa antigua2028110140.58112.46084.34056.22028.113Urbana44Mejora, mediagua4023520117.51609412070.580474023.513Urbana44Rancho, choza662331264.8198.6132.466.213Urbana44Ruca667333.5266.8200.1133.466.713Urbana44Mvil14974.559.644.729.814.913Urbana44Otro tipo de vivienda38011900.51520.41140.3760.2380.113Urbana44Colectiva380619031522.41141.8761.2380.613Urbana44Personas en trnsito38111905.51524.41143.3762.2381.113Urbana59Casa723382361691289352.8217014.6144676.472338.213Urbana59Departamento13802169010.555208.441406.327604.213802.113