{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Tramo_Cunetas","Validaciones"],"not_rendered":{"images":1,"external_links":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Tramo_Cunetas","index":0,"n_rows":24,"n_cols":16,"rows_kept":24,"merged":[[11,0,11,12],[12,0,12,5],[12,6,12,12],[15,0,15,6],[16,0,16,6],[20,0,20,6],[21,0,21,6]]}
[]
["NOTAS:"]
["- Los campos marcados con (*) son obligatorios"]
["- Las celdas en gris no deben rellenarse."]
["- Vídeo de ejemplo de uso ►"]
["- Los elementos de catálogo se asignan por su ID."]
["- La selección de CLIP \"NINGUNO\" equivale a dejar en blanco el dato en esta plantilla."]
[]
[]
["Versión","1.1"]
[]
["CATÁLOGO CUNETAS"]
["Versión",{"$nulls":5},"1.2"]
["ID","Nombre","Pto.control","Pto.fondo","Superior","Completa","En desmonte","En terraplén","Aj.rasante","Aj.despeje","Barra aj.rasante","Barra aj.despeje","Puntos"," ","  ","   "]
[]
[]
["DATOS GLOBALES O POR DEFECTO"]
[null,"ID_Tierra I.","ID_Tránsito I.","ID_Roca I.","ID_Tierra D.","ID_Tránsito D.","ID_Roca D.","Tierra I.","Tránsito I.","Roca I.","Tierra D.","Tránsito D.","Roca D."]
["Globales",false,false,false,false,false,false,{"$f":"B19","v":false},{"$f":"C19","v":false},false,false,false,false]
["Datos ",{"$nulls":6},{"$f":"IF(B20=\"\",\"NINGUNA\",INDEX(CATALOGO[Nombre],MATCH(B20,CATALOGO[ID],0),1))","v":"NINGUNA"},{"$f":"IF(C20=\"\",\"NINGUNA\",INDEX(CATALOGO[Nombre],MATCH(C20,CATALOGO[ID],0),1))","v":"NINGUNA"},{"$f":"IF(D20=\"\",\"NINGUNA\",INDEX(CATALOGO[Nombre],MATCH(D20,CATALOGO[ID],0),1))","v":"NINGUNA"},{"$f":"IF(E20=\"\",\"NINGUNA\",INDEX(CATALOGO[Nombre],MATCH(E20,CATALOGO[ID],0),1))","v":"NINGUNA"},{"$f":"IF(F20=\"\",\"NINGUNA\",INDEX(CATALOGO[Nombre],MATCH(F20,CATALOGO[ID],0),1))","v":"NINGUNA"},{"$f":"IF(G20=\"\",\"NINGUNA\",INDEX(CATALOGO[Nombre],MATCH(G20,CATALOGO[ID],0),1))","v":"NINGUNA"}]
[]
["TABLA"]
["Estación","ID_Tierra I. ","ID_Tránsito I. ","ID_Roca I. ","ID_Tierra D. ","ID_Tránsito D. ","ID_Roca D. ","Tierra I.","Tránsito I.","Roca I.","Tierra D.","Tránsito D.","Roca D."]
[{"$nulls":7},{"$f":"IF(TABLA_ESTACIONES[[#This Row],[ID_Tierra I. ]]=\"\",\"NINGUNA\",INDEX(CATALOGO[Nombre],MATCH(TABLA_ESTACIONES[[#This Row],[ID_Tierra I. ]],CATALOGO[ID],0),1))","v":"NINGUNA"},{"$f":"IF(TABLA_ESTACIONES[[#This Row],[ID_Tránsito I. ]]=\"\",\"NINGUNA\",INDEX(CATALOGO[Nombre],MATCH(TABLA_ESTACIONES[[#This Row],[ID_Tránsito I. ]],CATALOGO[ID],0),1))","v":"NINGUNA"},{"$f":"IF(TABLA_ESTACIONES[[#This Row],[ID_Roca I. ]]=\"\",\"NINGUNA\",INDEX(CATALOGO[Nombre],MATCH(TABLA_ESTACIONES[[#This Row],[ID_Roca I. ]],CATALOGO[ID],0),1))","v":"NINGUNA"},{"$f":"IF(TABLA_ESTACIONES[[#This Row],[ID_Tierra D. ]]=\"\",\"NINGUNA\",INDEX(CATALOGO[Nombre],MATCH(TABLA_ESTACIONES[[#This Row],[ID_Tierra D. ]],CATALOGO[ID],0),1))","v":"NINGUNA"},{"$f":"IF(TABLA_ESTACIONES[[#This Row],[ID_Tránsito D. ]]=\"\",\"NINGUNA\",INDEX(CATALOGO[Nombre],MATCH(TABLA_ESTACIONES[[#This Row],[ID_Tránsito D. ]],CATALOGO[ID],0),1))","v":"NINGUNA"},{"$f":"IF(TABLA_ESTACIONES[[#This Row],[ID_Roca D. ]]=\"\",\"NINGUNA\",INDEX(CATALOGO[Nombre],MATCH(TABLA_ESTACIONES[[#This Row],[ID_Roca D. ]],CATALOGO[ID],0),1))","v":"NINGUNA"}]

{"sheet":"Validaciones","index":1,"n_rows":2,"n_cols":1,"rows_kept":2,"hidden":true}
[{"$f":"TRUE()","v":true}]
[{"$f":"FALSE()","v":false}]