{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Valorización ","Instrucciones","Control de Cambios ","Datos base","Variables rurales ","Variables urbanas"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Valorización ","index":0,"n_rows":62,"n_cols":14,"rows_kept":62,"cut":false,"hidden":false,"merged":[[43,4,43,5],[43,7,43,8],[1,3,4,4],[1,5,2,7],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[3,5,3,7],[4,5,4,7]]}
[]
[null,null,null,null,null,"FORMATO PLANTILLA  METODOLOGÍA DE BIENES DE DIFÍCIL ADMINISTRACIÓN",null,null,"Código:  401,08,15-46"]
[null,null,null,null,null,null,null,null,"Versión: 01"]
[null,null,null,null,null," PROCESO REPARACIÓN INTEGRAL",null,null,"Fecha: 21/06/2022"]
[null,null,null,null,null,"METODOLOGÍA DE IDENTIFICACIÓN DEL ESTADO DE DIFÍCIL ADMINISTRACIÓN DE LOS BIENES INMUEBLES ADMINISTRADOS POR EL FRV",null,null,"Página: 1 de 1"]
[]
[]
[null,null,null,null,"Código FRV","IU2063SEC2123"]
[null,null,null,null,"Folio de matrícula inmobiliario",126465]
[null,null,null,null,"Nombre del Bien Inmueble","LA FLORIDA"]
[null,null,null,null,null,null,null," "]
[]
[null,null,2]
[]
[]
[null,null,null,null,"Estimación de renta inicial",800000]
[]
[]
[]
[null,{"$f":"+IF(C20,1,0)","v":1},true,null,null,null,null,null,null,null,true,{"$f":"+IF(K20,1,0)","v":1},true,{"$f":"+IF(M20,1,0)","v":1}]
[]
[null,{"$f":"+IF(C22,1,0)","v":1},true,null,null,null,null,null,null,null,true,1]
[]
[null,1,true,null,null,null,null,null,null,null,true,1]
[]
[null,1,true,null,null,null,null,null,null,null,true,1]
[]
[]
[null,null,null,null,"Selección de variables"]
[]
[null,null,1,null,"Vías de acceso",null,"Disponibilidad de Agua -Rural",null,null,null,2]
[]
[null,null,3,null,"Estado de conservación de vías ",null,"Orden Publico",null,null,null,1]
[]
[null,null,4,null,"Clase de topografía",null,"Estado de Conservación de las construcciones",null,null,null,5]
[]
[null,null,8,null,"Uso del suelo",null,"Vetustez",null,null,null,4]
[]
[null,null,3,null,"Clase Agrológica",null,"Servicios públicos",null,null,null,3]
[]
[]
[null,null,null,null,"Resultados obtenidos por variable"]
[]
[null,null,null,null,"RURAL",null,null,"URBANO"]
[null,null,null,null,"Vías de acceso",{"$f":"+IF(AND($C$13=1,$B$20=1,$B$22=1,$B$24=1,$B$26=1,$L$20=1,$L$22=1),IF(C31+C33=2,'Variables rurales '!H18,IF('Valorización '!C31+'Valorización '!C33=3,'Variables rurales '!H19,IF('Valorización '!C31+'Valorización '!C33=4,'Variables rurales '!H20,IF('Valorización '!C31+'Valorización '!C33=5,'Variables rurales '!H23,IF('Valorización '!C31+'Valorización '!C33=6,'Variables rurales '!H26,\"\"))))),\"\")","v":""},null,"Vías de acceso",{"$f":"+IF(AND($C$13=2,$B$20=1,$B$22=1,$B$24=1,$L$20=1,$L$24=1,$L$26=1,$N$20=1),($C$31+$C$33)/'Variables urbanas'!$G$29,\"\")","v":0.1111111111111111}]
[null,null,null,null,"Topografía",{"$f":"+IF(AND($C$13=1,$C$13=1,$B$20=1,$B$22=1,$B$24=1,$B$26=1,$L$20=1,$L$22=1),(IF('Valorización '!$C$35=1,'Variables rurales '!$F$33,IF('Valorización '!$C$35=2,'Variables rurales '!$F$34,IF('Valorización '!$C$35=3,'Variables rurales '!$F$35,IF('Valorización '!$C$35=4,'Variables rurales '!$F$36,IF('Valorización '!$C$35=5,'Variables rurales '!$F$37,IF('Valorización '!$C$35=6,'Variables rurales '!$F$38,IF('Valorización '!$C$35=7,'Variables rurales '!$F$39,IF('Valorización '!$C$35=8,'Variables rurales '!$F$40,IF('Valorización '!$C$35=9,'Variables rurales '!$F$41,\"\")))))))))),\"\")","v":""},null,"Topografía",{"$f":"+IF(AND($C$13=2,$B$20=1,$B$22=1,$B$24=1,$L$20=1,$L$24=1,$L$26=1,$N$20=1),(IF('Valorización '!$C$35=1,'Variables urbanas'!$E$34,IF('Valorización '!$C$35=2,'Variables urbanas'!$E$35,IF('Valorización '!$C$35=3,'Variables urbanas'!$E$36,IF('Valorización '!$C$35=4,'Variables urbanas'!$E$37,IF('Valorización '!$C$35=5,'Variables urbanas'!$E$38,IF('Valorización '!$C$35=6,'Variables urbanas'!$E$39,IF('Valorización '!$C$35=7,'Variables urbanas'!$E$40,IF('Valorización '!$C$35=8,'Variables urbanas'!$E$41,IF('Valorización '!$C$35=9,'Variables urbanas'!$E$42,\"\")))))))))),\"\")","v":0.08}]
[null,null,null,null,"Uso del suelo",{"$f":"+IF(AND($C$13=1,$C$13=1,$B$20=1,$B$22=1,$B$24=1,$B$26=1,$L$20=1,$L$22=1),(IF('Valorización '!$C$37=1,'Variables rurales '!$G$47,IF('Valorización '!$C$37=2,'Variables rurales '!$G$48,IF('Valorización '!$C$37=3,'Variables rurales '!$G$49,IF('Valorización '!$C$37=4,'Variables rurales '!$G$50,\"\"))))),\"\")","v":""},null,"Uso del suelo",{"$f":"+(IF(AND($C$13=2,$B$20=1,$B$22=1,$B$24=1,$L$20=1,$L$24=1,$L$26=1,$N$20=1),(IF('Valorización '!$C$37=5,'Variables urbanas'!$F$48,IF('Valorización '!$C$37=6,'Variables urbanas'!$F$49,IF('Valorización '!$C$37=7,'Variables urbanas'!$F$50,IF('Valorización '!$C$37=8,'Variables urbanas'!$F$51,\"\"))))),\"\"))","v":0.1}]
[null,null,null,null,"Disponibiidad de agua",{"$f":"+IF(AND($C$13=1,$C$13=1,$B$20=1,$B$22=1,$B$24=1,$B$26=1,$L$20=1,$L$22=1),(IF($K$31=1,'Variables rurales '!$G$56,IF('Valorización '!$K$31=2,'Variables rurales '!$G$57,IF('Valorización '!$K$31=3,'Variables rurales '!G58,IF('Valorización '!$K$31=4,'Variables rurales '!G59,IF($K$31=5,'Variables rurales '!$G$60,\"\")))))),\"\")","v":""},null,"Orden público",{"$f":"+(IF(AND($C$13=2,$B$20=1,$B$22=1,$B$24=1,$L$20=1,$L$24=1,$L$26=1,$N$20=1),(IF($K$33=1,'Variables urbanas'!$F$90,IF('Valorización '!$K$33=2,'Variables urbanas'!$F$91,\"\"))),\"\"))","v":0.2}]
[null,null,null,null,"Orden público",{"$f":"+IF(AND($C$13=1,$C$13=1,$B$20=1,$B$22=1,$B$24=1,$B$26=1,$L$20=1,$L$22=1),(IF($K$33=1,'Variables rurales '!$G$65,IF('Valorización '!$K$33=2,'Variables rurales '!$G$66,\"\"))),\"\")","v":""},null,"Vetustez",{"$f":"+IF(AND($C$13=2,$B$20=1,$B$22=1,$B$24=1,$L$20=1,$L$24=1,$L$26=1,$N$20=1),IF($K$37=1,'Variables urbanas'!$F$57,IF('Valorización '!$K$37=2,'Variables urbanas'!$F$58,IF('Valorización '!$K$37=3,'Variables urbanas'!$F$59,IF('Valorización '!$K$37=4,'Variables urbanas'!$F$60,IF('Valorización '!$K$37=5,'Variables urbanas'!$F$61,\"\"))))),\"\")","v":0.26666666666666666}]
[null,null,null,null,"Clase agrológica del suelo",{"$f":"+IF(AND($C$13=1,$C$13=1,$B$20=1,$B$22=1,$B$24=1,$B$26=1,$L$20=1,$L$22=1),(IF($C$39=1,'Variables rurales '!$G$71,IF('Valorización '!$C$39=2,'Variables rurales '!$G$72,IF('Valorización '!$C$39=3,'Variables rurales '!$G$73,IF('Valorización '!$C$39=4,'Variables rurales '!$G$74,IF('Valorización '!$C$39=5,'Variables rurales '!$G$75,IF('Valorización '!$C$39=6,'Variables rurales '!$G$76,IF('Valorización '!$C$39=7,'Variables rurales '!$G$77,IF('Variables rurales '!$G$77,IF('Valorización '!$C$39=8,'Variables rurales '!$G$78,\"\")))))))))),\"\")","v":""},null,"Estado de conservación de las construcciones",{"$f":"+IF(AND($C$13=2,$B$20=1,$B$22=1,$B$24=1,$L$20=1,$L$24=1,$N$20=1),IF($K$35=1,'Variables urbanas'!$F$67,IF('Valorización '!$K$35=2,'Variables urbanas'!$F$68,IF('Valorización '!$K$35=3,'Variables urbanas'!$F$69,IF('Valorización '!$K$35=4,'Variables urbanas'!$F$70,IF('Valorización '!$K$35=5,'Variables urbanas'!$F$71,\"\"))))),\"\")","v":0.34}]
[null,null,null,null,null,null,null,"Servicios públicos",{"$f":"+IF(AND($C$13=2,$B$20=1,$B$22=1,$B$24=1,$L$20=1,$L$24=1,$L$26=1,$N$20=1),IF($K$39=1,'Variables urbanas'!$F$78,IF('Valorización '!$K$39=2,'Variables urbanas'!$F$79,IF('Valorización '!$K$39=3,'Variables urbanas'!$F$80,IF('Valorización '!$K$39=4,'Variables urbanas'!$F$81,IF('Valorización '!$K$39=5,'Variables urbanas'!$F$82,\"\"))))),\"\")","v":0.15}]
[]
[null,null,null,null,"Porcentaje de afectación",{"$f":"+IFERROR(IF(C13=1,($F$45*'Variables rurales '!$G$6)+('Valorización '!$F$46*'Variables rurales '!$G$7)+('Valorización '!$F$47*'Variables rurales '!$G$8)+('Valorización '!$F$48*'Variables rurales '!$G$9)+('Valorización '!$F$49*'Variables rurales '!$G$10)+('Valorización '!$F$50*'Variables rurales '!$G$11),('Valorización '!$I$45*'Variables urbanas'!$F$6)+('Valorización '!$I$46*'Variables urbanas'!$F$7)+('Valorización '!$I$47*'Variables urbanas'!$F$8)+('Valorización '!$I$48*'Variables urbanas'!$F$12)+('Valorización '!$I$49*'Variables urbanas'!$F$9)+('Valorización '!$I$50*'Variables urbanas'!$F$10)+('Valorización '!$I$51*'Variables urbanas'!$F$11)),\"\")","v":0.18855555555555556}]
[]
[null,null,null,null,"Valor de renta de bien de difícil administración",{"$f":"+IFERROR(F16-(F16*F53),\"\")","v":649155.5555555555}]
[]
[]
[null,null,null,null,"Avaluador"]
[]
[null,null,null,null,"___________________________"]
[null,null,null,null,"Nombre"]
[null,null,null,null,"N° RAA-AVAL:"]

{"sheet":"Instrucciones","index":1,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[1,1,1,13],[16,2,16,4],[17,2,17,4],[18,2,18,4],[23,6,23,9],[16,6,16,9],[17,6,17,9],[18,6,18,9],[19,6,19,9],[20,6,20,9],[21,6,21,9],[22,6,22,9]]}
[]
[null,"INSTRUCCIONES DE METODOLOGÍA DE BIENES DE DIFÍCIL ADMINISTRACIÓN"]
[]
[]
[null,null,"1. CÓDIGO FRV, FOLIO DE MATRÍCULA INMOBILIARIO, NOMBRE DEL BIEN INMUEBLE"]
[null,null,"Se debe diligenciar el código FRV, el número de folio de matrícula inmobiliario del bien y el nombre del bien inmueble"]
[]
[null,null,"2. TIPO DE BIEN"]
[null,null,"Se debe seleccionar el tipo de bien (rural o urbano) "]
[]
[null,null,"3. AVALÚO DE RENTA INICIAL"]
[null,null,"Se debe diligenciar el valor de renta inicial establecido por el avaluador "]
[]
[null,null,"4. VARIABLES"]
[null,null,"Se deben seleccionar todas las variables que aplican para el cálculo de renta de acuerdo al tipo de bien inmueble (rural o urbano)"]
[]
[null,null,"Variables Rurales",null,null,null,"Variables Urbanas"]
[null,null,"Vías de acceso",null,null,null,"Vías de acceso"]
[null,null,"Topografía",null,null,null,"Topografía"]
[null,null,"Uso del suelo",null,null,null,"Uso del suelo"]
[null,null,"Disponibiidad de agua",null,null,null,"Vetustez"]
[null,null,"Orden público",null,null,null,"Estado de conservación de las construcciones"]
[null,null,"Clase agrológica del suelo",null,null,null,"Servicios públicos"]
[null,null,null,null,null,null,"Orden público"]
[]
[null,null,"5.SELECCIÓN DE VARIABLES"]
[null,null,"Se debe seleccionar la opción correcta para cada tipo de variable de acuerdo a las características del bien inmueble"]
[]
[null,null,"6. RESULTADOS OBTENIDOS POR VARIABLE"]
[null,null,"La plantilla calcula de manera automática los porcentajes de afectación por cada variable según aplique a bienes urbanos o rurales"]
[]
[null,null,"7. VALOR DE DESCUENTO OBTENIDO DE LA METODOLOGÍA"]
[null,null,"La plantilla calcula de manera automática el porcentaje de afectación que se debe aplicar al valor inicial de renta de acuerdo a las variables aplicadas"]
[]
[null,null,"8. VALOR FINAL DE RENTA DE INMUEBLE"]
[null,null,"La plantilla calcula de manera automática el valor final de renta, una vez aplicado el porcentaje de afectación al valor inicial de renta del inmueble"]
[]
[null,null,"9. AVALUADOR"]
[null,null,"La persona encargada de realizar la avaluación a través de la plantilla debe diligenciar su nombre y firma"]

{"sheet":"Control de Cambios ","index":2,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2]]}
["Versión","Fecha de Cambio","Descripción de la modificación"]
[]
["V1","2022-06-21","Creación del Formato"]

{"sheet":"Datos base","index":3,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Tipo de inmueble","Variables","Vías de acceso","Estado de conservación de vías","Clase de togopografía","Uso del suelo ","Disponibilidad del agua ","Orden público","Estado de conservación de construcciones","Vetustez","Clase Agrológica","Servicios públicos"]
["Urbano","Vías de acceso","Primaria","Bueno","A nivel","Uso de Protección","Distrito de Riego","Bueno","Clase 1","0 a 10","Clase Agrológica I","Sin servicios"]
["Rural","Topografía","Secundaria","Regular","Plana","Uso Agropecuario","Cuerpo Hídrico","Malo","Clase 2","11 a 30","Clase Agrológica II","Servicios Básicos Incompletos"]
[null,"Uso del suelo","Terciaria","Malo","Ligeramente plana","Uso Recreativo","Riego Artesanal","N/A","Clase 3","31 a 50","Clase Agrológica III","Servicios Básicos Completos"]
[null,"Disponibiidad de agua","N/A","N/A","Ligeramente inclinada","Otros Rurales","Jagüey",null,"Clase 4","51 a 75","Clase Agrológica IV","Servicios Básicos y Complementarios"]
[null,"Orden público",null,null,"Moderadamente inclinada","Uso Dotacional","No disponibilidad de recurso hídrico",null,"Clase 5","76 a 100","Clase Agrológica V","Servicios Básicos Completos y complementarios"]
[null,"Clase agrológica del suelo",null,null,"Fuertemente inclinada","Uso Residencial","N/A",null,"N/A","N/A","Clase Agrológica VI","N/A"]
[null,"Vetustez",null,null,"Ligeramente escarpada o Ligeramente empinada","Uso Comercial y de Servicios",null,null,null,null,"Clase Agrológica VII"]
[null,"Estado de conservación de las construcciones",null,null,"Moderadamente escarpada o M. empinada","Otros Urbanos",null,null,null,null,"Clase Agrológica VIII"]
[null,"Servicios públicos",null,null,"Fuertemente escarpada o Fuertemente empinada","N/A",null,null,null,null,"N/A"]
[null,null,null,null,"N/A"]

{"sheet":"Variables rurales ","index":4,"n_rows":79,"n_cols":8,"rows_kept":79,"cut":false,"hidden":true,"merged":[[52,2,52,9],[61,2,61,9],[67,2,67,9],[13,2,13,9],[29,2,29,9],[2,2,2,9],[43,2,43,9],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,6]]}
[]
[]
[null,null,"VARIABLES RURALES"]
[]
[null,null,null,null,null,"Variables Rurales","Porcentaje"]
[null,null,null,null,null,"Vías de acceso",0.2]
[null,null,null,null,null,"Topografía",0.2]
[null,null,null,null,null,"Uso del suelo",0.15]
[null,null,null,null,null,"Disponibiidad de agua",0.2]
[null,null,null,null,null,"Orden público",0.2]
[null,null,null,null,null,"Clase agrológica del suelo",0.05]
[null,null,null,null,null,null,{"$f":"SUM(G6:G11)","v":1}]
[]
[null,null,"VÍAS DE ACCESO"]
[]
[null,null,"Clasificación de las vías rurales","Puntuación","Estado de conservación","Puntuación","Calificación ∑ (Clasificación de vías+ Estado de Conservación)","Porcentaje"]
[null,null,null,null,null,null,null,"%"]
[null,null,"Primarias",1,"Bueno",1,{"$f":"+D18+F18","v":2},0]
[null,null,"Primarias",1,"Regular",2,{"$f":"+D19+F19","v":3},0.05]
[null,null,"Primarias",1,"Malo",3,{"$f":"+D20+F20","v":4},0.1]
[null,null,"Secundarías",2,"Bueno",1,3,0.05]
[null,null,"Secundarías",2,"Regular",2,4,0.1]
[null,null,"Secundarías",2,"Malo",3,5,0.15]
[null,null,"Terciarías",3,"Bueno",1,4,0.1]
[null,null,"Terciarías",3,"Regular",2,5,0.15]
[null,null,"Terciarías",3,"Malo",3,6,0.3]
[null,null,null,{"$f":"SUM(D18:D26)","v":18},null,null,36,{"$f":"SUM(H18:H26)","v":1}]
[]
[]
[null,null,"TOPOGRAFÍA"]
[]
[null,null,"Clase de topografía Rural","%",null,"Porcentaje %"]
[null,null,"A nivel","0-1",1,0,1]
[null,null,"Plana","0-3",2,0.02,2]
[null,null,"Ligeramente plana","1-3",3,0.04,3]
[null,null,"Ligeramente inclinada","3-7",4,0.06,4]
[null,null,"Moderadamente inclinada","7-12",5,0.09,5]
[null,null,"Fuertemente inclinada","12-25",6,{"$f":"+E38/$E$42","v":0.13333333333333333},6]
[null,null,"Ligeramente escarpada o Ligeramente empinada","25-50",7,0.15555555555555556,7]
[null,null,"Moderadamente escarpada o M. empinada","50-75",8,0.2,8]
[null,null,"Fuertemente escarpada o Fuertemente empinada","› 75",9,0.3,9]
[null,null,null,null,{"$f":"SUM(E33:E41)","v":45},{"$f":"SUM(F33:F41)","v":0.99888888888888894}]
[]
[null,null,"USO DEL SUELO"]
[]
[null,null,null,null,null,"Uso del Suelo Rural","Porcentaje %"]
[null,null,null,null,null,"Uso de Protección",0.5,1]
[null,null,null,null,null,"Uso Agropecuario",0.25,2]
[null,null,null,null,null,"Uso Recreativo",0.2,3]
[null,null,null,null,null,"Otros Rurales",0.05,4]
[null,null,null,null,null,null,{"$f":"SUM(G47:G50)","v":1}]
[]
[null,null,"DISPONIBILIDAD DE AGUA"]
[]
[null,null,null,null,null,"Disponibilidad de Agua -Rural","Porcentaje %"]
[null,null,null,null,null,"Distrito de Riego",0.03,1]
[null,null,null,null,null,"Cuerpo Hídrico",7.0000000000000007E-2,2]
[null,null,null,null,null,"Riego Artesanal",0.15,3]
[null,null,null,null,null,"Jagüey",0.25,4]
[null,null,null,null,null,"No disponibilidad de recurso hídrico",0.5,5]
[null,null,null,null,null,null,{"$f":"SUM(G56:G60)","v":1}]
[null,null,"ORDEN PÚBLICO"]
[]
[null,null,null,null,null,"Orden Público","Porcentaje %"]
[null,null,null,null,null,"Bueno",0.1,1]
[null,null,null,null,null,"Malo",0.9,2]
[null,null,null,null,null,null,{"$f":"SUM(G65:G66)","v":1}]
[null,null,"CLASE AGROLÓGICA DEL SUELO"]
[]
[null,null,null,null,null,"Clase Agrológica","Porcentaje %"]
[null,null,null,null,null,"Clase Agrológica I",0,1]
[null,null,null,null,null,"Clase Agrológica II",0.02,2]
[null,null,null,null,null,"Clase Agrológica III",0.04,3]
[null,null,null,null,null,"Clase Agrológica IV",0.08,4]
[null,null,null,null,null,"Clase Agrológica V",0.13,5]
[null,null,null,null,null,"Clase Agrológica VI",0.16,6]
[null,null,null,null,null,"Clase Agrológica VII",0.17,7]
[null,null,null,null,null,"Clase Agrológica VIII",0.4,8]
[null,null,null,null,null,null,{"$f":"SUM(G71:G78)","v":1}]

{"sheet":"Variables urbanas","index":5,"n_rows":92,"n_cols":9,"rows_kept":92,"cut":false,"hidden":true,"merged":[[2,2,2,8],[14,2,14,8],[86,2,86,8],[17,2,18,2],[17,3,18,3],[17,4,18,4],[17,5,18,5],[17,6,18,6],[30,2,30,8],[44,2,44,8],[53,2,53,8],[63,2,63,8],[74,2,74,8]]}
[]
[]
[null,null,"VARIABLES URBANAS"]
[]
[null,null,null,null,"Variables urbanas","Porcentaje"]
[null,null,null,null,"Vías de acceso",0.05]
[null,null,null,null,"Topografía",0.05]
[null,null,null,null,"Uso del suelo",0.25]
[null,null,null,null,"Vetustez",0.03]
[null,null,null,null,"Estado de conservación de las construcciones",0.2]
[null,null,null,null,"Servicios públicos",0.12]
[null,null,null,null,"Orden público",0.3]
[null,null,null,null,null,{"$f":"SUM(F6:F12)","v":1}]
[]
[null,null,"VÍAS DE ACCESO"]
[]
[]
[null,null,"Clasificación de las vías urbanas","Puntuación","Estado de conservación","Puntuación","Calificación ∑ (Clasificación de vías+ Estado de Conservación)","Porcentaje"]
[null,null,null,null,null,null,null,"%"]
[null,null,"Primarias",1,"Bueno",1,{"$f":"+D20+F20","v":2},{"$f":"+G20/$G$29","v":5.5555555555555552E-2},1]
[null,null,"Primarias",1,"Regular",2,{"$f":"+D21+F21","v":3},{"$f":"+G21/$G$29","v":8.3333333333333329E-2},2]
[null,null,"Primarias",1,"Malo",3,4,0.1111111111111111,3]
[null,null,"Secundarías",2,"Bueno",1,3,8.3333333333333329E-2,4]
[null,null,"Secundarías",2,"Regular",2,4,0.1111111111111111,5]
[null,null,"Secundarías",2,"Malo",3,5,0.1388888888888889,6]
[null,null,"Terciarías",3,"Bueno",1,4,0.1111111111111111,7]
[null,null,"Terciarías",3,"Regular",2,5,0.1388888888888889,8]
[null,null,"Terciarías",3,"Malo",3,6,{"$f":"+G28/$G$29","v":0.16666666666666666},9]
[null,null,null,{"$f":"SUM(D20:D28)","v":18},null,{"$f":"SUM(F20:F28)","v":18},{"$f":"SUM(G20:G28)","v":36},{"$f":"SUM(H20:H28)","v":0.99999999999999989}]
[]
[null,null,"TOPOGRAFÍA"]
[]
[null,null,"Clase de topografía Urbana","%","Porcentaje %"]
[null,null,"A nivel","0-1",0,1]
[null,null,"Plana","0-3",0.02,2]
[null,null,"Ligeramente plana","1-3",0.05,3]
[null,null,"Ligeramente inclinada","3-7",0.08,4]
[null,null,"Moderadamente inclinada","7-12",0.1111111111111111,5]
[null,null,"Fuertemente inclinada","12-25",0.13333333333333333,6]
[null,null,"Ligeramente escarpada o Ligeramente empinada","25-50",0.15555555555555556,7]
[null,null,"Moderadamente escarpada o M. empinada","50-75",0.2,8]
[null,null,"Fuertemente escarpada o Fuertemente empinada","› 75",0.25,9]
[null,null,null,null,{"$f":"SUM(E34:E42)","v":1}]
[]
[null,null,"USO DEL SUELO"]
[]
[null,null,null,null,"Uso del Suelo Urbano","Porcentaje %"]
[null,null,null,null,"Uso Dotacional",0.4,1]
[null,null,null,null,"Uso Residencial",0.3,2]
[null,null,null,null,"Uso Comercial y de Servicios",0.2,3]
[null,null,null,null,"Otros Urbanos",0.1,4]
[null,null,null,null,null,{"$f":"SUM(F48:F51)","v":0.99999999999999989}]
[]
[null,null,"VETUSTEZ"]
[]
[null,null,null,null,"Vetustez","Porcentaje %"]
[null,null,null,null,"0 a10",0.04,1]
[null,null,null,null,"11 a 30",{"$f":"+G58/$G$62","v":0.13333333333333333},2]
[null,null,null,null,"31 a 50",0.2,3]
[null,null,null,null,"51 a 75",0.26666666666666666,4]
[null,null,null,null,"76    100",0.36,5]
[null,null,null,null,null,{"$f":"SUM(F57:F61)","v":1},{"$f":"SUM(G57:G61)","v":15}]
[]
[null,null,"ESTADO DE CONSERVACIÓN DE CONSTRUCCIONES"]
[]
[null,null,null,null,"Estado de Conservación de las construcciones","Porcentaje %"]
[null,null,null,null,"Clase 1",0.03,1]
[null,null,null,null,"Clase 2",0.15,2]
[null,null,null,null,"Clase 3",0.22,3]
[null,null,null,null,"Clase 4",0.26,4]
[null,null,null,null,"Clase 5",0.34,5]
[null,null,null,null,null,{"$f":"SUM(F67:F71)","v":1}]
[null,null,null,null,null,null,{"$f":"SUM(G67:G72)","v":15}]
[]
[null,null,"SERVICIOS PÚBLICOS"]
[]
[null,null,null,null,"Disponibilidad Servicios Públicos ","Porcentaje %"]
[null,null,null,null,"Sin servicios",0.47,1]
[null,null,null,null,"Servicios Básicos Incompletos",0.3,2]
[null,null,null,null,"Servicios Básicos Completos",0.15,3]
[null,null,null,null,"Servicios Básicos y Complementarios",0.08,4]
[null,null,null,null,"Servicios Básicos Completos y complementarios",0,5]
[]
[null,null,null,null,null,{"$f":"SUM(F78:F83)","v":1},{"$f":"SUM(G78:G83)","v":15}]
[]
[]
[null,null,"ORDEN PÚBLICO"]
[]
[null,null,null,null,"Orden Publico","Porcentaje %"]
[null,null,null,null,"Bueno",0.2,1]
[null,null,null,null,"Malo",0.8,2]
[null,null,null,null,null,{"$f":"SUM(F90:F91)","v":1},{"$f":"SUM(G90:G91)","v":3}]