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

{"sheet":"TramoFerrocarril_Balasto","index":0,"n_rows":40,"n_cols":20,"rows_kept":40,"merged":[[12,0,12,10],[13,0,13,3],[13,4,13,10],[16,0,16,19],[17,0,17,7],[18,0,18,2],[18,3,18,7],[21,0,21,19],[22,0,22,8],[23,0,23,3],[23,4,23,8],[26,0,26,19],[27,0,27,7],[28,0,28,2],[28,3,28,7],[31,0,31,19],[32,0,32,16],[36,0,36,6],[37,0,37,16]]}
[]
["NOTAS:"]
["- Los campos marcados con (*) son obligatorios."]
["- Las celdas en gris no deben rellenarse."]
["- La primera y última fila de la TABLA siempre tienen que tener todos sus datos rellenos (excepto los elementos de catálogo, que pueden quedar vacíos)."]
["- 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 PLUMAS"]
["Versión",{"$nulls":3},"1.1"]
["ID","Nombre (*)","Pattern","Rojo","Verde","Azul","Pattern imp.","Rojo imp.","Verde imp.","Azul imp.","Ancho","Columna1","Columna2","Columna3","Columna4","Columna5","Columna6","Columna7","Columna8","Columna9"]
[]
[]
["CATÁLOGO TRAVIESAS"]
["Versión:     ",null,null,"1.1",{"$nulls":4}," ","  ","   "]
["ID","Nombre (*)","Altura (mm)","Anchura (mm)","Separación entre traviesas (mm)","X anclaje (mm)","Y anclaje (mm)","Puntos (mm)","Columna3","Columna4","Columna5","Columna12","Columna23","Columna34","Columna45","Columna56","Columna6","Columna7","Columna8","Columna9"]
[]
[]
["CATÁLOGO CARRILES"]
["Versión",{"$nulls":3},"1.1"]
["ID","Nombre (*)","Alto (mm)","Giro","X anclaje (mm)","Y anclaje (mm)","X replanteo (mm)","Y replanteo (mm)","Puntos (mm)","Columna1","Columna2","Columna12","Columna23","Columna3","Columna4","Columna5","Columna6","Columna7","Columna8","Columna9"]
[]
[]
["CATÁLOGO GÁLIBOS"]
["Versión",null,null,"1.1"]
["ID","Nombre (*)","X anclaje","Y anclaje","Gira con peralte","Puntos","ID_Pluma","Pluma","Columna1","Columna2","Columna3","Columna12","Columna23","Columna34","Columna4","Columna5","Columna6","Columna7","Columna8","Columna9"]
[{"$nulls":7},{"$f":"IF(CATALOGO_GALIBOS[[#This Row],[ID_Pluma]]=\"\",\"NINGUNA\",INDEX(CATALOGO_PLUMAS[Nombre (*)],MATCH(CATALOGO_GALIBOS[[#This Row],[ID_Pluma]],CATALOGO_PLUMAS[ID],0),1))","v":"NINGUNA"}]
[]
["DATOS GLOBALES O POR DEFECTO"]
[null,"Hom.ext.I.","Hom.int.I.","Hom.int.D.","Hom.ext.D.","Ancho vía","Entreeje I.","Entreeje D.","Esp.min.","Tal.ext.I.","Tal.int.I.","Tal.int.D.","Tal.ext.D.","Cota bal.","ID_Traviesa","ID_Carril","ID_Gálibo","Traviesa","Carril","Gálibo"]
["Globales",false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,{"$f":"O35","v":false},{"$f":"P35","v":false},{"$f":"Q35","v":false}]
["Datos",{"v":1.1,"d":"1.100"},{"v":1.1,"d":"1.100"},{"v":1.1,"d":"1.100"},{"v":1.1,"d":"1.100"},1.435,{"v":2.25,"d":"2.250"},{"v":2.25,"d":"2.250"},{"v":0.3,"d":"0.300"},{"v":1.5,"d":"1.500"},{"v":1.5,"d":"1.500"},{"v":1.5,"d":"1.500"},{"v":1.5,"d":"1.500"},0.198,{"$nulls":3},{"$f":"IF(O36=\"\",\"NINGUNA\",INDEX(CATALOGO_TRAVIESAS[Nombre (*)],MATCH(O36,CATALOGO_TRAVIESAS[ID],0),1))","v":"NINGUNA"},{"$f":"IF(P36=\"\",\"NINGUNA\",INDEX(CATALOGO_CARRILES[Nombre (*)],MATCH(P36,CATALOGO_CARRILES[ID],0),1))","v":"NINGUNA"},{"$f":"IF(Q36=\"\",\"NINGUNA\",INDEX(CATALOGO_GALIBOS[Nombre (*)],MATCH(Q36,CATALOGO_GALIBOS[ID],0),1))","v":"NINGUNA"}]
[]
["TABLA"]
["Estación","Hom.ext.I.","Hom.int.I.","Hom.int.D.","Hom.ext.D.","Ancho vía","Entreeje I.","Entreeje D.","Esp.min.","Tal.ext.I.","Tal.int.I.","Tal.int.D.","Tal.ext.D.","Cota bal.","ID_Traviesa","ID_Carril","ID_Gálibo","Traviesa","Carril","Gálibo"]
[{"$nulls":17},{"$f":"IF(TABLA_ESTACIONES[[#This Row],[ID_Traviesa]]=\"\",\"NINGUNA\",INDEX(CATALOGO_TRAVIESAS[Nombre (*)],MATCH(TABLA_ESTACIONES[[#This Row],[ID_Traviesa]],CATALOGO_TRAVIESAS[ID],0),1))","v":"NINGUNA"},{"$f":"IF(TABLA_ESTACIONES[[#This Row],[ID_Carril]]=\"\",\"NINGUNA\",INDEX(CATALOGO_CARRILES[Nombre (*)],MATCH(TABLA_ESTACIONES[[#This Row],[ID_Carril]],CATALOGO_CARRILES[ID],0),1))","v":"NINGUNA"},{"$f":"IF(TABLA_ESTACIONES[[#This Row],[ID_Gálibo]]=\"\",\"NINGUNA\",INDEX(CATALOGO_GALIBOS[Nombre (*)],MATCH(TABLA_ESTACIONES[[#This Row],[ID_Gálibo]],CATALOGO_GALIBOS[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}]