{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Descripción de propuesta","Descripción situación actual"],"not_rendered":{"charts":0,"images":2,"macros":0,"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":"Descripción de propuesta","index":0,"n_rows":38,"n_cols":38,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,24]]}
[null,null,null,null,null,"Convocatoria Nacional No.10/17 para apoyar proyectos de bajo carbono en transporte"]
[null,"Descripción de vehiculos Propuestos"]
[null,"# id. Ruta","Tipo de vehiculo:        1. No articulado       2. Articulado              3. BRT         *Escribir directamente en la celda si no encuentra la opción deseada","Marca del vehículo","Año-modelo del vehículo","Peso vehicular bruto\n(kg)","Capacidad del tanque de combustible\n(l)","Potencia\n(HP)","Longitud del  vehiculo\n(m)","Tipo de certificación (EPA 2010,  Euro VI, u otros)","Combustible del vehículo:     1.Diesel          2.Gas Natural   3.GLP      4.Gasolina   5.Hibrído.     *Escribir directamente en la celda si no encuentra la opción deseada","Número de vehículos\n(#)","Distancia total del recorrido de la ruta\n(km)","Recorridos diarios promedio esperados por cada vehículo\n(#)","Distancia  diaria estimada recorrida en la ruta\n(km)","Distancia  semanal estimada recorrida en la ruta\n(km)","Distancia  mensual estimada recorrida en la ruta\n(km)","Distancia  anual estimada recorrida en la ruta\n(km)","Combustible promedio que se estima utilizar por día en la ruta (lt)","Número de pasajeros esperados diariamente por ruta\n(#)","Número de pasajeros  esperados por semana en la ruta\n(#)","Número de pasajeros  esperados por mes en la ruta\n(#)","Número de pasajeros  esperados por año en la ruta\n(#)","Capacidad de pasajeros sentados del vehículo\n(#)","Capacidad de pasajeros parados del vehículo\n(#)","Total de pasajeros por marca de vehiculo","Total de combustible usado por día recorridos (lt)"]
[null,null,null,null,null,null,null,null,null,"xxx","xxx",null,null,null,{"$f":"L4*M4*N4","v":0},{"$f":"O4*7","v":0},{"$f":"P4*4","v":0},{"$f":"O4*365","v":0},null,null,null,null,null,null,null,{"$f":"(Y4+X4)*L4","v":0},{"$f":"L4*S4","v":0},null,null,null,null,null,null,"No articulado",null,"Diesel",null,"EPA 2010"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L5*M5*N5","v":0},{"$f":"O5*7","v":0},{"$f":"P5*4","v":0},{"$f":"O5*365","v":0},null,null,null,null,null,null,null,0,{"$f":"Y5+X5","v":0},null,null,null,null,null,null,"Articulado",null,"Gas Natural",null,"Euro VI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,"BRT",null,"GLP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Gasolina"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Híbrido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,0,0]
[]
[null,"*Llenar las celdas de color verde y las celdas de color naranja se despliega una lista en la cual se puede seleccionar el dato o agregarlo directamente.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AA4:AA37)","v":0}]

{"sheet":"Descripción situación actual","index":1,"n_rows":38,"n_cols":37,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,23]]}
[null,null,null,null,null,"Convocatoria Nacional No.10/17 para apoyar proyectos de bajo carbono en transporte"]
[null,"Descripción de vehiculos actuales"]
[null,"# id. Ruta","Tipo de vehiculo:    1. No articulado.   2. Articulado.              3. BRT.        *Escribir directamente en la celda si no encuentra la opción deseada","Marca del vehículo","Año-modelo del vehículo","Peso vehicular bruto\n(kg)","Capacidad del tanque de combustible\n(l)","Potencia\n(HP)","Longuitd del  vehiculo (m)","Combustible del vehículo:    1.Diesel.         2.Gas Natural.   3.GLP.     4.Gasolina.   5.Hibrído.     *Escribir directamente en la celda si no encuentra la opción deseada","Número de vehículos\n(#)","Distancia total del recorrido de la ruta\n(km)","Recorridos diarios promedio por cada vehículo\n(#)","Distancia diaria recorrida en la ruta\n(km)","Distancia semanal recorrida en la ruta (km)","Distancia mensual recorrida en la ruta (km)","Distancia   anual recorrida en la ruta\n(km)","Combustible promedio  utilizado por día en la ruta (lt)","Número de pasajeros diarios en la ruta\n(#)","Número de pasajeros por semana en la ruta\n(#)","Número de pasajeros por mes en la ruta\n(#)","Número de pasajeros por año en la ruta\n(#)","Capacidad de pasajeros sentados por vehículo\n(#)","Capacidad de pasajeros parados por vehículo\n(#)","Total de pasajeros por marca de vehiculo","Total de combustible usado por día recorridos (lt)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M4*L4*K4","v":0},{"$f":"N4*7","v":0},{"$f":"O4*4","v":0},{"$f":"N4*365","v":0},null,null,null,null,null,null,null,{"$f":"(W4+#REF!)*D4","v":{"$error":"#REF!"}},{"$f":"R4","v":0},null,null,null,null,null,null,null,null,null,null,"Diesel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M5*L5*K5","v":0},{"$f":"N5*7","v":0},{"$f":"O5*4","v":0},{"$f":"N5*365","v":0},null,null,null,null,null,null,null,{"$f":"(W5+#REF!)*D5","v":{"$error":"#REF!"}},0,null,null,null,null,null,null,null,null,null,null,"Gas Natural"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W6+#REF!)*D6","v":{"$error":"#REF!"}},0,null,null,null,null,null,null,null,null,null,null,"GLP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W7+#REF!)*D7","v":{"$error":"#REF!"}},0,null,null,null,null,null,null,null,null,"No articulado",null,"Gasolina"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W8+#REF!)*D8","v":{"$error":"#REF!"}},0,null,null,null,null,null,null,null,null,"Articulado",null,"Hibrído"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W9+#REF!)*D9","v":{"$error":"#REF!"}},0,null,null,null,null,null,null,null,null,"BRT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W10+#REF!)*D10","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W11+#REF!)*D11","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W12+#REF!)*D12","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W13+#REF!)*D13","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W14+#REF!)*D14","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W15+#REF!)*D15","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W16+#REF!)*D16","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W17+#REF!)*D17","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W18+#REF!)*D18","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W19+#REF!)*D19","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W20+#REF!)*D20","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W21+#REF!)*D21","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W22+#REF!)*D22","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W23+#REF!)*D23","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W24+#REF!)*D24","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W25+#REF!)*D25","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W26+#REF!)*D26","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W27+#REF!)*D27","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W28+#REF!)*D28","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W29+#REF!)*D29","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W30+#REF!)*D30","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W31+#REF!)*D31","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W32+#REF!)*D32","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W33+#REF!)*D33","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W34+#REF!)*D34","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W35+#REF!)*D35","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W36+#REF!)*D36","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,{"$f":"(W37+#REF!)*D37","v":{"$error":"#REF!"}},0]
[null,"*Llenar las celdas de color verde y las celdas de color naranja se despliega una lista en la cual se puede seleccionar el dato o agregarlo directamente.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z4:Z37)","v":0}]