{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Inicio","Tarifas_Congestion","Parquimetros","Marchamos_auto","Gasolinas","Marchamos_moto","Info_tablas"],"not_rendered":{"charts":1,"images":8,"macros":1,"external_links":0,"defined_names":10,"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":"Inicio","index":0,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,0,31,4],[6,0,6,11],[4,0,5,4],[1,5,2,11],[22,3,22,4],[7,0,7,2],[0,0,2,4],[3,0,3,4],[14,0,16,2],[8,0,13,2],[17,0,21,2],[23,0,24,2],[27,0,28,2],[25,0,26,2],[29,0,29,2],[22,0,22,2]]}
["ESTIMACIONES REALIZADAS PARA LOS MECANISMOS DE FINANCIAMIENTO SELECIONADOS"]
[null,null,null,null,null,"METODOLOGÍA"]
[]
["Esta hoja presenta de manera resumida las estimaciones realizadas por el ITDP. Los cálculos detallados se incluyen en las hojas 2 a 5."]
["Instrucciones de uso: 1) Haga click en la celda verde (D8) y seleccione el mecanismo que desea consultar. 2) Vea los datos que se utilizaron para los cálculos en la celdas \"Inputs\". 3) Vea los resultados que arrojaron las estimaciones en las celdas \"outputs\". 4)  Vea el potencial de generación de ingresos en las celdas \"Ingresos esperados al año\". 5) En la imagen (derecha) se muestra la metodología de cada mecanismo"]
[]
[]
["Seleccione un mecanismo:",null,null,null,null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"tarifc\",IF(D8=\"Parquímetros\",\"estacio\",IF(D8=\"Impuesto único a los combustibles\",\"impg\",IF(D8=\"Impuesto a la propiedad de vehículo\",\"impa\",\"Otro\"))))","v":"Otro"}]
["Inputs:",null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"Cantidad de cruces al año en la Ruta 27\",IF(D8=\"Parquímetros\",\"Cantidad de cajones de estacionamiento en San José\",IF(D8=\"Impuesto único a los combustibles\",\"Ingresos que reciben las municipalidades (dólares)\",IF(D8=\"Impuesto a la propiedad de vehículo\",\"Impuesto a la propiedad de vehículo\",\"En espera de datos\"))))","v":"En espera de datos"},{"$f":"IF(D9=\"Cantidad de cruces al año en la Ruta 27\",SUM(Tarifas_Congestion!C34:K45),IF(D9=\"Cantidad de cajones de estacionamiento en San José\",Parquimetros!C4,IF(D9=\"Ingresos que reciben las municipalidades (dólares)\",Gasolinas!C15,IF(D9=\"Impuesto a la propiedad de vehículo\",Marchamos_auto!I3,\"En espera de datos\"))))","v":"En espera de datos"}]
[null,null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"Ingresos anuales en la Ruta 27 (dólares)\",IF(D8=\"Parquímetros\",\"Tarifa por hora (colones)\",IF(D8=\"Impuesto único a los combustibles\",\"Porcentaje dedicado a movilidad urbana sustentable \",IF(D8=\"Impuesto a la propiedad de vehículo\",\"Porcentaje dedicado a movilidad urbana sustentable\",\"En espera de datos\"))))","v":"En espera de datos"},{"$f":"IF(D10=\"Ingresos anuales en la Ruta 27 (dólares)\",SUM(Tarifas_Congestion!C7:K18),IF(D10=\"Tarifa por hora (colones)\",Parquimetros!E4,IF(D10=\"Porcentaje dedicado a movilidad urbana sustentable \",Gasolinas!K13,IF(D10=\"Porcentaje dedicado a movilidad urbana sustentable\",Marchamos_auto!B13,\"En espera de datos\"))))","v":"En espera de datos"}]
[null,null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"Porcentaje de autos que viajan en hora pico\",IF(D8=\"Parquímetros\",\"Elasticidad precio-demanda\",IF(D8=\"Impuesto único a los combustibles\",\"Porcentaje dedicado a movilidad urbana sustentable \",IF(D8=\"Impuesto a la propiedad de vehículo\",\"Porcentaje dedicado a movilidad urbana sustentable\",\"En espera de datos\"))))","v":"En espera de datos"},{"$f":"IF(D11=\"Porcentaje de autos que viajan en hora pico\",Tarifas_Congestion!G47,IF(D11=\"Elasticidad precio-demanda\",Parquimetros!J3,IF(D11=\"Porcentaje dedicado a movilidad urbana sustentable \",Gasolinas!L13,IF(D11=\"Porcentaje dedicado a movilidad urbana sustentable\",Marchamos_auto!B14,\"En espera de datos\"))))","v":"En espera de datos"}]
[null,null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"Porcentaje de autos que viajan en hora valle\",IF(D8=\"Parquímetros\",\"\",IF(D8=\"Impuesto único a los combustibles\",\"Porcentaje dedicado a movilidad urbana sustentable \",IF(D8=\"Impuesto a la propiedad de vehículo\",\"Porcentaje dedicado a movilidad urbana sustentable\",\"En espera de datos\"))))","v":"En espera de datos"},{"$f":"IF(D12=\"Porcentaje de autos que viajan en hora valle\",Tarifas_Congestion!G48,IF(D12=\"Tarifa óptima por hora (colones)\",Parquimetros!F15,IF(D12=\"Porcentaje dedicado a movilidad urbana sustentable \",Gasolinas!M13,IF(D12=\"Porcentaje dedicado a movilidad urbana sustentable\",Marchamos_auto!B15,IF(D12=\"\",\"\",\"En espera de datos\")))))","v":"En espera de datos"}]
[null,null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"Elasticidad precio-demanda\",IF(D8=\"Parquímetros\",\"\",IF(D8=\"Impuesto a la propiedad de vehículo\",\"Porcentaje dedicado a movilidad urbana sustentable\",IF(D8=\"Impuesto único a los combustibles\",\"Porcentaje dedicado a movilidad urbana sustentable \",\"\"))))","v":""},{"$f":"IF(D13=\"Porcentaje dedicado a movilidad urbana sustentable\",Marchamos_auto!B16,IF(D13=\"\",\"\",IF(D13=\"Elasticidad precio-demanda\",Tarifas_Congestion!C47,IF(D13=\"Porcentaje dedicado a movilidad urbana sustentable \",Gasolinas!N13,\"\"))))","v":""}]
[null,null,null,{"$f":"IF(D8=\"Parquímetros\",\"\",IF(D8=\"Impuesto a la propiedad de vehículo\",\"Porcentaje dedicado a movilidad urbana sustentable\",IF(D8=\"Impuesto único a los combustibles\",\"Porcentaje dedicado a movilidad urbana sustentable \",\"\")))","v":""},{"$f":"IF(D14=\"Elasticidad precio-demanda\",Tarifas_Congestion!C47,IF(D14=\"\",\"\",IF(D14=\"Porcentaje dedicado a movilidad urbana sustentable\",Marchamos_auto!B17,IF(D14=\"Porcentaje dedicado a movilidad urbana sustentable \",Gasolinas!O13,\"\"))))","v":""}]
["Outputs:",null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"Cantidad de cruces al año en la Ruta 27 con TC\",IF(D8=\"Parquímetros\",\"Tarifa óptima por hora (colones)\",IF(D8=\"Impuesto único a los combustibles\",\"\",IF(D8=\"Impuesto a la propiedad de vehículo\",\"\",\"En espera de datos\"))))","v":"En espera de datos"},{"$f":"IF(D15=\"Cantidad de cruces al año en la Ruta 27 con TC\",SUM(Tarifas_Congestion!C58:K69,Tarifas_Congestion!M58:U69),IF(D15=\"Tarifa óptima por hora (colones)\",Parquimetros!F15,IF(D15=\"Supuesto: 4% a movilidad urbana sustentable\",Gasolinas!G15,IF(D15=\"Supuesto: 2% a movilidad urbana sustentable\",Marchamos_auto!C16,IF(D15=\"\",\"\",\"En espera de datos\")))))","v":"En espera de datos"}]
[null,null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"Cruces en hora pico al año\",IF(D8=\"Parquímetros\",\"\",IF(D8=\"Impuesto a la propiedad de vehículo\",\"\",IF(D8=\"Impuesto único a los combustibles\",\"\",\"En espera de datos\"))))","v":"En espera de datos"},{"$f":"IF(D16=\"Cruces en hora pico al año\",SUM(Tarifas_Congestion!C58:K69),IF(D16=\"\",\"\",\"En espera de datos\"))","v":"En espera de datos"}]
[null,null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"Cruces en hora valle al año\",IF(D8=\"Parquímetros\",\"\",IF(D8=\"Impuesto a la propiedad de vehículo\",\"\",IF(D8=\"Impuesto único a los combustibles\",\"\",\"En espera de datos\"))))","v":"En espera de datos"},{"$f":"IF(D17=\"Cruces en hora valle al año\",Tarifas_Congestion!M70,IF(D17=\"\",\"\",\"En espera de datos\"))","v":"En espera de datos"}]
["Ingresos esperados al año:",null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"Ingresos extra anuales en la Ruta 27 por TC (dólares)\",IF(D8=\"Parquímetros\",\"Ingresos extra al año (dólares)\",IF(OR(D8=\"Impuesto a la propiedad de vehículo\",D8=\"Impuesto único a los combustibles\"),\"Si se le dedica \"&E10&\" implica un ingreso de:\",\"En espera de datos\")))","v":"En espera de datos"},{"$f":"IF(D18=\"Ingresos extra anuales en la Ruta 27 por TC (dólares)\",Tarifas_Congestion!L111,IF(D18=\"Ingresos extra al año (dólares)\",Parquimetros!F8,IF(D18=\"Si se le dedica 0.5% implica un ingreso de:\",Marchamos_auto!C13,IF(D18=\"Si se le dedica 1.0% implica un ingreso de:\",Gasolinas!D15,\"En espera de datos\"))))","v":"En espera de datos"}]
[null,null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"\",IF(D8=\"Parquímetros\",\"\",IF(OR(D8=\"Impuesto a la propiedad de vehículo\",D8=\"Impuesto único a los combustibles\"),\"Si se le dedica \"&E11&\" implica un ingreso de:\",\"En espera de datos\")))","v":"En espera de datos"},{"$f":"IF(D19=\"Ingresos extra anuales en la Ruta 27 por TC (dólares)\",Tarifas_Congestion!L112,IF(D19=\"Ingresos extra al año (dólares)\",Parquimetros!F9,IF(D19=\"Si se le dedica 0.8% implica un ingreso de:\",Marchamos_auto!C14,IF(D19=\"\",\"\",IF(D19=\"Si se le dedica 2.0% implica un ingreso de:\",Gasolinas!E15,\"En espera de datos\")))))","v":"En espera de datos"}]
[null,null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"\",IF(D8=\"Parquímetros\",\"\",IF(OR(D8=\"Impuesto a la propiedad de vehículo\",D8=\"Impuesto único a los combustibles\"),\"Si se le dedica \"&E12&\" implica un ingreso de:\",\"En espera de datos\")))","v":"En espera de datos"},{"$f":"IF(D20=\"Si se le dedica 1.0% implica un ingreso de:\",Marchamos_auto!C15,IF(D20=\"Si se le dedica 3.0% implica un ingreso de:\",Gasolinas!F15,\"\"))","v":""}]
[null,null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"\",IF(D8=\"Parquímetros\",\"\",IF(OR(D8=\"Impuesto a la propiedad de vehículo\",D8=\"Impuesto único a los combustibles\"),\"Si se le dedica \"&E13&\" implica un ingreso de:\",\"En espera de datos\")))","v":"En espera de datos"},{"$f":"IF(D21=\"Si se le dedica 2.0% implica un ingreso de:\",Marchamos_auto!C16,IF(D21=\"Si se le dedica 4.0% implica un ingreso de:\",Gasolinas!G15,\"\"))","v":""}]
[null,null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"\",IF(D8=\"Parquímetros\",\"\",IF(OR(D8=\"Impuesto a la propiedad de vehículo\",D8=\"Impuesto único a los combustibles\"),\"Si se le dedica \"&E14&\" implica un ingreso de:\",\"En espera de datos\")))","v":"En espera de datos"},{"$f":"IF(D22=\"Ingresos extra anuales en la Ruta 27 por TC (dólares)\",Tarifas_Congestion!L115,IF(D22=\"Ingresos extra al año (dólares)\",Parquimetros!F12,IF(D22=\"Si se le dedica 3.0% implica un ingreso de:\",Marchamos_auto!C17,IF(D22=\"\",\"\",IF(D22=\"Si se le dedica 5.0% implica un ingreso de:\",Gasolinas!H15,\"En espera de datos\")))))","v":"En espera de datos"}]
[null,null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"Análisis por caseta\",IF(OR(D8=\"Impuesto único a los combustibles\",D8=\"Impuesto a la propiedad de vehículo\"),\"No aplica (celdas vacías)\",IF(D8=\"Parquímetros\",\"Incremento de cajones\",\"En espera de datos\")))","v":"En espera de datos"}]
[{"$f":"IF(D8=\"Tarifas de congestión\",\"Seleccione una caseta de la celda E24 y un mes de la celda E25 para ver resultados desagregados\",\"No aplica (celdas vacías)\")","v":"No aplica (celdas vacías)"},null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"Caseta\",\"\")","v":""}]
[null,null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"Mes\",\"\")","v":""}]
[{"$f":"IF(OR(D8=\"Impuesto a la propiedad de vehículo\",D8=\"Impuesto único a los combustibles\"),\"No aplica (celdas vacías)\",\"Input\")","v":"Input"},null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"Cantidad de autos durante \"&E25,IF(D8=\"Parquímetros\",\"Incremento de cajones de estacionamiento a \",IF(D8=\"Impuesto único a los combustibles\",\"\",IF(D8=\"Impuesto a la propiedad de vehículo\",\"\",\"En espera de datos\"))))","v":"En espera de datos"},{"$f":"IF(D26=\"Cantidad de autos durante \"&E25,VLOOKUP(E25,Tarifas_Congestion!B34:K45,MATCH(Inicio!E24,Tarifas_Congestion!B33:K33,0),FALSE),IF(D26=\"Incremento de cajones de estacionamiento a \",Parquimetros!C5,\"\"))","v":""}]
[null,null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"Tarifa actual (colones)\",IF(D8=\"Parquímetros\",D10,IF(D8=\"Impuesto único a los combustibles\",\"\",IF(D8=\"Impuesto a la propiedad de vehículo\",\"\",\"En espera de datos\"))))","v":"En espera de datos"},{"$f":"IF(D27=\"Tarifa actual (colones)\",VLOOKUP(E24,Info_tablas!B10:E18,2,FALSE),IF(D27=\"Tarifa por hora (colones)\",E10,IF(D27=\"Con 0.8% de lo que reciben\",E11/750000,IF(D27=\"Con 2% de lo que reciben\",E11/750000,\"\"))))","v":""}]
[{"$f":"IF(OR(D8=\"Impuesto a la propiedad de vehículo\",D8=\"Impuesto único a los combustibles\"),\"No aplica (celdas vacías)\",\"Output\")","v":"Output"},null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"Tarifa congestión hora pico (colones)\",IF(D8=\"Parquímetros\",\"Supuesto\",IF(D8=\"Impuesto único a los combustibles\",\"\",IF(D8=\"Impuesto a la propiedad de vehículo\",\"\",\"En espera de datos\"))))","v":"En espera de datos"},{"$f":"IF(D28=\"Tarifa congestión hora pico (colones)\",VLOOKUP(Inicio!E24,Info_tablas!B10:E18,3,FALSE),IF(D28=\"Supuesto\",\"Mismo nivel de uso de los cajones\",IF(D28=\"Con 3% de lo que reciben\",E12/750000,IF(D28=\"Con 1% de lo que reciben\",E12/750000,\"\"))))","v":""}]
[null,null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"Tarifa congestión hora valle (colones)\",IF(D8=\"Parquímetros\",\"Ingresos generados por incremento de lugares (dólares)\",IF(D8=\"Impuesto único a los combustibles\",\"\",IF(D8=\"Impuesto a la propiedad de vehículo\",\"\",\"En espera de datos\"))))","v":"En espera de datos"},{"$f":"IF(D29=\"Tarifa congestión hora valle (colones)\",VLOOKUP(Inicio!E24,Info_tablas!B10:E18,4,FALSE),IF(D29=\"Ingresos generados por incremento de lugares (dólares)\",Parquimetros!F5*0.0018,IF(D29=\"Con 4% de lo que reciben\",E15/750000,IF(D29=\"Con 2% de lo que reciben\",E15/750000,\"\"))))","v":""}]
[{"$f":"IF(OR(D8=\"Impuesto a la propiedad de vehículo\",D8=\"Impuesto único a los combustibles\"),\"No aplica (celdas vacías)\",\"Ingresos esperados al año\")","v":"Ingresos esperados al año"},null,null,{"$f":"IF(D8=\"Tarifas de congestión\",\"Ingresos extra generados en \"&E25&\" por la caseta \"&E24&\" (dólares) \",IF(D8=\"Parquímetros\",\"Ingresos extra al año (dólares)\",IF(D8=\"Impuesto único a los combustibles\",\"\",IF(D8=\"Impuesto a la propiedad de vehículo\",\"\",\"En espera de datos\"))))","v":"En espera de datos"},{"$f":"IF(D30=\"Ingresos extra generados en \"&E25&\" por la caseta \"&E24&\" (dólares) \",VLOOKUP(E25,Tarifas_Congestion!B99:K111,MATCH(Inicio!E24,Tarifas_Congestion!B98:K98,0),0),IF(D30=\"Ingresos extra al año (dólares)\",Parquimetros!J8,IF(D30=\"Con 5% de lo que reciben\",E18/750000,IF(D30=\"Con 3% de lo que reciben\",E18/750000,\"\"))))","v":""}]
["Estas estimaciones fueron realizados de manera interna por ITDP, si tiene alguna duda favor de contactar a: isaac.medina@itdp.com o santiago.fernandez@itdp.org"]

{"sheet":"Tarifas_Congestion","index":1,"n_rows":111,"n_cols":21,"rows_kept":111,"cut":false,"hidden":false,"merged":[[98,0,110,0],[0,0,0,20],[45,12,45,17],[46,13,46,17],[49,0,51,0],[57,0,68,0],[71,0,82,0],[84,0,95,0],[4,0,17,0],[19,0,30,0],[33,0,44,0],[46,0,47,0],[46,4,47,4],[46,3,47,3],[56,11,68,11],[31,1,31,10],[47,13,47,17],[48,13,48,17],[54,1,55,1],[56,12,56,20],[96,2,96,10],[48,1,48,10],[56,2,56,10],[70,2,70,10],[83,2,83,10]]}
["Caso: Ruta 27"]
[null,null,null,null,null,null,null,null,"Porcentaje de autos y motos"]
[null,2017,80513442]
[null,null,{"$f":"C3*0.9","v":72462097.799999997}]
["Ingresos en dólares por mes y por caseta reportados por el Consejo Nacional de Concesiones (CNC)","Casetas","escazú","ciudad colón","san rafael","guacima","siquiares","intercambio atenas","atenas","intercambio pozon","pozon"]
[null,"Tarifa de vehículos livinos por caseta",370,180,560,420,440,370,740,180,560]
[null,"enero",2235470,224327,1403758,53083,230152,98205,1365084,54898,954816]
[null,"febrero",2189748,197065,1385482,48394,204294,94895,1126174,48120,787471]
[null,"marzo",2414440,225433,1468219,53165,222237,101052,1225208,54884,848531]
[null,"abril",2032487,214846,1297907,47809,207969,84279,1245173,54408,871303]
[null,"mayo",2215575,232294,1307451,49181,206059,94229,1113244,48743,768279]
[null,"junio",2202226,236334,1239827,51565,216829,97851,1101562,49222,760092]
[null,"julio",2159296,242058,1255180,52255,229395,93757,1264137,53425,870453]
[null,"agosto",2203276,240095,1240664,51296,225544,97166,1141830,50739,786956]
[null,"septiembre",2087276,230298,1179363,47447,221192,93100,1098104,46300,758684]
[null,"octubre",2166398,237891,1208865,48549,258689,96901,1210704,46432,861776]
[null,"noviembre",2231507,244775,1304033,53035,249226,99410,1201526,51346,842615]
[null,"diciembre",2221353,250820,1350322,59407,261748,102500,1335575,57935,942992]
[null,"Casetas","escazú","ciudad colón","san rafael","guacima","siquiares","intercambio atenas","atenas","intercambio pozon","pozon","Total al mes"]
["De acuerdo al CNC, el 90 % de los ingresos de la vía provienen de los vehículos livianos. Estos ingresos están en colones","enero",{"$f":"C7*0.9/0.0018","v":1117735000},{"$f":"D7*0.9/0.0018","v":112163500.00000001},701879000,26541500.000000004,115076000.00000001,49102500,682542000.00000012,27449000.000000004,477408000,{"$f":"SUM(C20:K20)","v":3309896500}]
[null,"febrero",{"$f":"C8*0.9/0.0018","v":1094874000},98532500,692741000,24197000,102147000,47447500,563087000,24060000,393735500,{"$f":"SUM(C21:K21)","v":3040821500}]
[null,"marzo",{"$f":"C9*0.9/0.0018","v":1207220000},112716500.00000001,734109500.00000012,26582500,111118500.00000001,50526000,612604000,27442000,424265500,3306584500]
[null,"abril",{"$f":"C10*0.9/0.0018","v":1016243500},107423000,648953500,23904500,103984500,42139500.000000007,622586500,27204000.000000004,435651500.00000006,3028090500]
[null,"mayo",{"$f":"C11*0.9/0.0018","v":1107787500},116147000,653725500.00000012,24590500,103029500,47114500.000000007,556622000,24371500.000000004,384139500,3017527500]
[null,"junio",{"$f":"C12*0.9/0.0018","v":1101113000},118167000,619913500,25782500,108414500,48925500.000000007,550781000,24611000.000000004,380046000.00000006,2977754000]
[null,"julio",{"$f":"C13*0.9/0.0018","v":1079648000},121029000.00000001,627590000,26127500,114697500,46878500,632068500,26712500,435226500.00000006,3109978000]
[null,"agosto",{"$f":"C14*0.9/0.0018","v":1101638000},120047500,620332000.00000012,25648000,112772000,48583000.000000007,570915000,25369500,393478000,3018783000]
[null,"septiembre",{"$f":"C15*0.9/0.0018","v":1043638000.0000001},115149000.00000001,589681500,23723500.000000004,110596000.00000001,46550000,549052000,23150000,379342000,2880882000]
[null,"octubre",{"$f":"C16*0.9/0.0018","v":1083199000},118945500,604432500,24274500,129344500,48450500.000000007,605352000.00000012,23216000.000000004,430888000,3068102500]
[null,"noviembre",{"$f":"C17*0.9/0.0018","v":1115753500},122387500,652016500,26517500,124613000,49705000,600763000.00000012,25673000,421307500,3138736500]
[null,"diciembre",{"$f":"C18*0.9/0.0018","v":1110676500},125410000,675161000,29703500.000000004,130874000.00000001,51250000,667787500,28967500,471496000.00000006,3291326000]
[null,"Cantidad de autos livianos"]
[null,null,"escazú","ciudad colón","san rafael","guacima","siquiares","intercambio atenas","atenas","intercambio pozon","pozon"]
["Se dividieron los ingresos por la tarifa de cada caseta para conocer la cantidad de vehiculos ligeros que cruzaron al mes por cada caseta","enero",{"$f":"C20/$C$6","v":3020905.4054054054},{"$f":"D20/$D$6","v":623130.55555555562},{"$f":"E20/$E$6","v":1253355.357142857},{"$f":"F20/$F$6","v":63194.047619047626},{"$f":"G20/$G$6","v":261536.36363636368},{"$f":"H20/$H$6","v":132709.45945945947},{"$f":"I20/$I$6","v":922354.0540540542},{"$f":"J20/$J$6","v":152494.44444444447},{"$f":"K20/$K$6","v":852514.28571428568}]
[null,"febrero",2959118.9189189188,547402.77777777775,1237037.5,57611.904761904763,232152.27272727274,128236.48648648648,760928.37837837834,133666.66666666666,703099.10714285716]
[null,"marzo",3262756.7567567569,626202.77777777787,1310909.8214285716,63291.666666666664,252542.0454545455,136556.75675675675,827843.2432432432,152455.55555555556,757616.96428571432]
[null,"abril",2746604.054054054,596794.4444444445,1158845.5357142857,56915.476190476191,236328.40909090909,113890.54054054056,841333.10810810816,151133.33333333334,777949.10714285728]
[null,"mayo",2994020.2702702703,645261.11111111112,1167366.9642857146,58548.809523809527,234157.95454545456,127336.48648648651,752191.89189189184,135397.22222222225,685963.39285714284]
[null,"junio",2975981.0810810812,656483.33333333337,1106988.392857143,61386.904761904763,246396.59090909091,132231.08108108109,744298.64864864864,136727.77777777781,678653.57142857148]
[null,"julio",2917967.5675675673,672383.33333333337,1120696.4285714286,62208.333333333336,260676.13636363635,126698.64864864865,854146.62162162166,148402.77777777778,777190.17857142864]
[null,"agosto",2977400,666930.5555555555,1107735.7142857146,61066.666666666664,256300,131305.40540540541,771506.7567567568,140941.66666666666,702639.28571428568]
[null,"septiembre",2820643.2432432435,639716.66666666674,1053002.6785714286,56484.523809523816,251354.5454545455,125810.81081081081,741962.16216216213,128611.11111111111,677396.42857142852]
[null,"octubre",2927564.8648648649,660808.33333333337,1079343.75,57796.428571428572,293964.77272727271,130947.29729729732,818043.24324324343,128977.7777777778,769442.85714285716]
[null,"noviembre",3015550,679930.5555555555,1164315.1785714286,63136.904761904763,283211.36363636365,134337.83783783784,811841.89189189207,142627.77777777778,752334.82142857148]
[null,"diciembre",3001828.3783783782,696722.22222222225,1205644.642857143,70722.619047619053,297440.90909090912,138513.51351351352,902415.54054054059,160930.55555555556,841957.14285714296]
[null,null,null,null,null,null,"UK ","ZMVM","US-transport ",null,null,null,"Estudios utilizados para calcular la cantidad de autos que viajan en hora pico"]
["Elasticidad precio-demanda","70% hora pico",0.34,null,"Cantidad de autos que viajan por hora del día","hora pico",0.52,{"$f":"52.23/100","v":0.52229999999999999},0.47,null,null,null,"UK","HPM (6-9:59) y HPT(4:7:59)https://www.gov.uk/government/statistical-data-sets/nts05-trips"]
[null,"30% hora valle",0.1,null,null,"hora valle",{"$f":"1-G47","v":0.48},{"$f":"1-H47","v":0.47770000000000001},{"$f":"1-I47","v":0.53},null,null,null,"ZMVM","HPM (6-9:59) y HPT(4:7:59) Encuesta Origen Destino 2017"]
[null,null,null,null,null,null,null,null,null,null,null,null,"US","HPM (6-8:59) y HPT(4-6:59) https://nhts.ornl.gov/assets/2017_nhts_summary_travel_trends.pdf"]
["Tarifas de congestión propuestas","Hora del día","escazú","ciudad colón","san rafael","guacima","siquiares","intercambio atenas","atenas","intercambio pozon","pozon"]
[null,"Hora pico",{"$f":"C6+(C6/2)","v":555},{"$f":"D6+(D6/2)","v":270},840,630,660,555,1110,270,840]
[null,"Hora valle",{"$f":"C6-C6*0.1","v":333},{"$f":"D6-D6*0.1","v":162},504,378,396,333,666,162,504]
[null,null,{"$f":"(C51-C6)/C6","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,{"$f":"(C52-C6)/C6","v":-0.1},{"$f":"(D52-D6)/D6","v":-0.1},-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1]
[null,"Cambio % demanda",{"$f":"C53*$C$47","v":0.17},{"$f":"D53*$C$47","v":0.17},0.17,0.17,0.17,0.17,0.17,0.17,0.17]
[null,null,{"$f":"C54*$C$48","v":-1.0000000000000002E-2},{"$f":"D54*$C$48","v":-1.0000000000000002E-2},-1.0000000000000002E-2,-1.0000000000000002E-2,-1.0000000000000002E-2,-1.0000000000000002E-2,-1.0000000000000002E-2,-1.0000000000000002E-2,-1.0000000000000002E-2]
[null,null,"Autos que podrían cruzar en Hora pico",null,null,null,null,null,null,null,null,"Cantidad de autos que podrían cruzar en hora valle por cada una de las casetas","Autos que podrían cruzar en Hora valle"]
["Cantidad de autos que podrían cruzar en hora pico por cada una de las casetas","enero",{"$f":"(C34*$G$47)+(-$C$55*(C34*$G$47))","v":1303822.7729729731},{"$f":"(D34*$G$47)+(-$C$55*(D34*$G$47))","v":268943.14777777781},540948.1721428571,27274.550952380952,112879.09454545457,57277.402702702704,398088.00972972985,65816.602222222238,367945.16571428569,null,{"$f":"(C34*$G$48)+(-$C$56*(C34*$G$48))","v":1464534.9405405405},{"$f":"(D34*$G$48)+(-$C$56*(D34*$G$48))","v":302093.69333333336},607626.67714285711,30636.474285714288,126792.8290909091,64337.545945945945,447157.24540540541,73929.306666666671,413298.92571428569]
[null,"febrero",{"$f":"(C35*$G$47)+(-$C$55*(C35*$G$47))","v":1277155.7254054055},236259.03888888887,533905.38500000001,24865.298095238097,100196.92090909091,55346.867567567569,328416.68810810812,57690.533333333326,303457.57464285719,null,1434580.8518918918,{"$f":"(D35*$G$48)+(-$C$56*(D35*$G$48))","v":265380.86666666664},{"$f":"(E35*$G$48)+(-$C$56*(E35*$G$48))","v":599715.78},{"$f":"(F35*$G$48)+(-$C$56*(F35*$G$48))","v":27930.251428571428},{"$f":"(G35*$G$48)+(-$C$56*(G35*$G$48))","v":112547.42181818181},{"$f":"(H35*$G$48)+(-$C$56*(H35*$G$48))","v":62169.048648648641},{"$f":"(I35*$G$48)+(-$C$56*(I35*$G$48))","v":368898.0778378378},{"$f":"(J35*$G$48)+(-$C$56*(J35*$G$48))","v":64801.599999999991},{"$f":"(K35*$G$48)+(-$C$56*(K35*$G$48))","v":340862.44714285713}]
[null,"marzo",{"$f":"(C36*$G$47)+(-$C$55*(C36*$G$47))","v":1408205.8162162162},270269.11888888892,565788.67892857152,27316.683333333331,108997.14681818185,58937.896216216206,357297.14378378377,65799.817777777775,326987.48178571434,null,1581784.4756756758,303583.10666666669,635529.08142857149,30683.799999999996,122432.38363636365,66202.715675675674,401338.40432432434,73910.453333333338,367292.70428571425]
[null,"abril",{"$f":"(C37*$G$47)+(-$C$55*(C37*$G$47))","v":1185434.3097297298},257576.48222222223,500157.73321428569,24564.719523809526,101999.34136363637,49155.157297297308,363119.3694594595,65229.146666666675,335762.8346428572,null,1331553.6454054052,289325.94666666671,561808.31571428571,27592.622857142855,114572.01272727271,55214.134054054062,407878.29081081081,73269.440000000002,377149.72714285721]
[null,"mayo",{"$f":"(C38*$G$47)+(-$C$55*(C38*$G$47))","v":1292219.1486486488},278494.69555555558,503835.58178571443,25269.666190476193,101062.57318181818,54958.427567567582,324646.02054054057,58437.441111111126,296061.80035714281,null,1451501.027027027,312822.58666666667,565939.50428571436,28384.462857142858,113519.77636363637,61732.728648648656,364662.62918918912,65640.573333333348,332555.05285714287]
[null,"junio",{"$f":"(C39*$G$47)+(-$C$55*(C39*$G$47))","v":1284433.4345945949},283338.20666666667,477776.19035714288,26494.588095238098,106344.76863636365,57070.934594594604,321239.29675675672,59011.708888888905,292906.88142857142,null,1442755.628108108,318263.12,536667.97285714292,29760.37142857143,119453.06727272728,64105.628108108111,360835.98486486485,66285.626666666678,329011.25142857147]
[null,"julio",{"$f":"(C40*$G$47)+(-$C$55*(C40*$G$47))","v":1259394.802162162},290200.64666666673,483692.57857142866,26849.116666666669,112507.82045454545,54683.136756756765,368649.68189189187,64050.638888888891,335435.28107142862,null,1414630.6767567566,325971.44,543313.62857142859,30158.6,126375.79090909089,61423.504864864866,414090.28216216218,71945.666666666657,376781.79857142858]
[null,"agosto",{"$f":"(C41*$G$47)+(-$C$55*(C41*$G$47))","v":1285045.8399999999},287847.22777777776,478098.7342857144,26356.373333333333,110619.08,56671.412972972976,332982.31621621625,60830.423333333325,303259.1157142857,null,1443443.52,323327.93333333329,537030.27428571437,29605.119999999995,124254.24,63656.86054054054,374026.47567567567,68328.52,340639.52571428567]
[null,"septiembre",{"$f":"(C42*$G$47)+(-$C$55*(C42*$G$47))","v":1217389.623783784},276101.71333333338,454475.95607142866,24378.72047619048,108484.62181818184,54299.945945945947,320230.86918918916,55508.555555555555,292364.29857142858,null,1367447.8443243245,310134.64,510495.6985714286,27383.697142857145,121856.68363636365,60993.08108108108,359703.25621621619,62350.666666666664,328401.78857142857]
[null,"octubre",{"$f":"(C43*$G$47)+(-$C$55*(C43*$G$47))","v":1263536.9956756756},285204.87666666671,465844.76250000001,24944.938571428575,126875.19590909091,56516.853513513532,353067.4637837839,55666.808888888896,332091.53714285715,null,1419283.4464864866,320359.88,523265.85,28019.708571428571,142514.1218181818,63483.249729729745,396587.36432432436,62528.426666666674,373025.89714285714]
[null,"noviembre",{"$f":"(C44*$G$47)+(-$C$55*(C44*$G$47))","v":1301511.3799999999},293458.02777777775,502518.43107142864,27249.888095238101,122234.02454545454,57980.210810810815,350390.96054054063,61558.148888888893,324707.70892857143,null,1461938.64,329630.33333333331,564459.99857142859,30608.771428571428,137300.86909090911,65126.983783783784,393580.94918918924,69145.946666666656,364731.92142857146]
[null,"diciembre",{"$f":"(C45*$G$47)+(-$C$55*(C45*$G$47))","v":1295589.128108108},300705.31111111114,520356.22785714286,30523.882380952382,128375.49636363637,59782.432432432433,389482.54729729734,69457.627777777772,363388.7028571429,null,1455286.3978378377,337770.93333333335,584496.52285714296,34286.325714285718,144199.35272727275,67151.351351351361,437491.05405405408,78019.133333333331,408180.82285714289]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M58:U69)","v":40302557.702488579}]
[null,null,"Ingresos por tarifas de congestión"]
["Se multiplicó la cantidad de autos que podrían cruzar en hora pico por la tarifa de hora pico más la cantidad de autos que podrían cruzar en hora valle por la tarifa de hora valle","enero",{"$f":"C58*$C$51+M58*$C$52","v":1211311774.2},{"$f":"D58*$D$51+N58*$D$52","v":121553828.22000001},{"$f":"E58*$E$51+O58*$E$52","v":760640309.87999988},{"$f":"F58*$F$51+P58*$F$52","v":28763554.380000003},{"$f":"G58*$G$51+Q58*$G$52","v":124710162.72000003},{"$f":"H58*$H$51+R58*$H$52","v":53213361.299999997},{"$f":"I58*$I$51+S58*$I$52","v":739684416.24000013},{"$f":"J58*$J$51+T58*$J$52","v":29747030.280000009},{"$f":"K58*$K$51+U58*$K$52","v":517376597.75999999}]
[null,"febrero",{"$f":"C59*$C$51+M59*$C$52","v":1186536851.28},{"$f":"D59*$D$51+N59*$D$52","v":106781640.89999999},{"$f":"E59*$E$51+O59*$E$52","v":750737276.51999998},{"$f":"F59*$F$51+P59*$F$52","v":26222772.84},{"$f":"G59*$G$51+Q59*$G$52","v":110698746.84},{"$f":"H59*$H$51+R59*$H$52","v":51419804.699999996},{"$f":"I59*$I$51+S59*$I$52","v":610228643.63999999},{"$f":"J59*$J$51+T59*$J$52","v":26074303.199999996},{"$f":"K59*$K$51+U59*$K$52","v":426699036.06000006}]
[null,"marzo",1308288458.4000001,122153125.38000001,795569147.34000015,28807986.899999999,120421340.82000002,54756036.719999999,663891206.88,29739444.240000002,459785007.66000003]
[null,"abril",1101323405.8199999,116416453.56,703283887.01999998,25905784.740000002,112690082.33999999,45667418.940000013,674709441.77999997,29481518.880000003,472124243.58000004]
[null,"mayo",1200531469.5,125870826.84,708455398.86000013,26649216.660000004,111655129.73999999,51058925.940000013,603222393.83999991,26411881.980000004,416299658.93999994]
[null,"junio",1193298180.3600001,128059941.23999999,671812658.22000003,27941010.900000002,117490961.94000001,53021542.860000007,596892385.31999993,26671432.920000006,411863451.12]
[null,"julio",1170036130.5599999,131161547.88000001,680131834.80000007,28314894.299999997,124299974.69999999,50803168.020000011,684985274.81999993,28948870.5,471663662.58000004]
[null,"agosto",1193867133.3599999,130097876.69999999,672266195.0400002,27795250.559999995,122213271.84,52650368.760000005,618712003.80000007,27493434.539999999,426419978.15999997]
[null,"septiembre",1131011373.3600001,124789274.28,639049635.18000007,25709631.420000002,119855097.12000003,50447166,595018633.43999994,25088118,411100512.24000001]
[null,"octubre",1173884420.28,128903617.26000002,655035588.89999998,26306761.140000001,140173221.53999999,52506775.860000014,656032069.44000018,25159643.520000003,466961943.36000001]
[null,"noviembre",1209164383.02,132633781.5,706603321.38000011,28737545.100000001,135045600.35999998,53866302.600000009,651058878.36000013,27822343.559999999,456579363.89999998]
[null,"diciembre",1203662336.5799999,135909325.19999999,731685478.92000008,32190277.020000003,141830771.28000003,55540650,723694669.5,31392659.100000001,510969645.12000006]
[null,null,"Ingresos extra por tarifas de congestión (colones)"]
["Ingresos extra generados por la aplicación de tarifas de congestión en colones","enero",{"$f":"C72-C20","v":93576774.200000048},{"$f":"D72-D20","v":9390328.2199999988},58761309.879999876,2222054.379999999,9634162.7200000137,4110861.299999997,57142416.24000001,2298030.2800000049,39968597.75999999]
[null,"febrero",91662851.279999971,{"$f":"D73-D21","v":8249140.8999999911},57996276.519999981,2025772.8399999999,8551746.8400000036,3972304.6999999955,47141643.639999986,2014303.1999999955,32963536.060000062]
[null,"marzo",101068458.4000001,9436625.3799999952,61459647.340000033,2225486.8999999985,9302840.8200000077,4230036.7199999988,51287206.879999995,2297444.2400000021,35519507.660000026]
[null,"abril",85079905.819999933,8993453.5600000024,54330387.019999981,2001284.7400000021,8705582.3399999887,3527918.9400000051,52122941.779999971,2277518.879999999,36472743.579999983]
[null,"mayo",92743969.5,9723826.8400000036,54729898.860000014,2058716.6600000039,8625629.7399999946,3944425.9400000051,46600393.839999914,2040381.9800000004,32160158.939999938]
[null,"junio",92185180.360000134,9892941.2399999946,51899158.220000029,2158510.9000000022,9076461.9400000125,4096042.8599999994,46111385.319999933,2060432.9200000018,31817451.119999945]
[null,"julio",90388130.559999943,10132547.879999995,52541834.800000072,2187394.299999997,9602474.6999999881,3924668.0200000107,52916774.819999933,2236370.5,36437162.579999983]
[null,"agosto",92229133.359999895,10050376.699999988,51934195.040000081,2147250.5599999949,9441271.8400000036,4067368.7599999979,47797003.800000072,2123934.5399999991,32941978.159999967]
[null,"septiembre",87373373.360000014,9640274.2799999863,49368135.180000067,1986131.4199999981,9259097.1200000197,3897166,45966633.439999938,1938118,31758512.24000001]
[null,"octubre",90685420.279999971,9958117.2600000203,50603088.899999976,2032261.1400000006,10828721.539999992,4056275.8600000069,50680069.440000057,1943643.5199999996,36073943.360000014]
[null,"noviembre",93410883.019999981,10246281.5,54586821.380000114,2220045.1000000015,10432600.359999985,4161302.6000000089,50295878.360000014,2149343.5599999987,35271863.899999976]
[null,"diciembre",92985836.579999924,10499325.199999988,56524478.920000076,2486777.0199999996,10956771.280000016,4290650,55907169.5,2425159.1000000015,39473645.120000005]
[null,null,"Ingresos extra por tarifas de congestión (dólares)"]
[null,null,"escazú","ciudad colón","san rafael","guacima","siquiares","intercambio atenas","atenas","intercambio pozon","pozon"]
["Ingresos extra generados por la aplicación de tarifas de congestión en dólares","enero",{"$f":"C85*0.0018","v":168438.19356000007},{"$f":"D85*0.0018","v":16902.590795999997},105770.35778399977,3999.6978839999979,17341.492896000025,7399.5503399999943,102856.34923200001,4136.4545040000085,71943.475967999984]
[null,"febrero",{"$f":"C86*0.0018","v":164993.13230399994},14848.453619999984,104393.29773599996,3646.3911119999998,15393.144312000006,7150.1484599999922,84854.958551999967,3625.7457599999921,59334.364908000112]
[null,"marzo",{"$f":"C87*0.0018","v":181923.22512000016},16985.925683999991,110627.36521200006,4005.8764199999973,16745.113476000013,7614.0660959999977,92316.972383999993,4135.3996320000033,63935.113788000046]
[null,"abril",{"$f":"C88*0.0018","v":153143.83047599989},16188.216408000004,97794.696635999964,3602.3125320000036,15670.04821199998,6350.2540920000092,93821.295203999951,4099.5339839999979,65650.93844399997]
[null,"mayo",{"$f":"C89*0.0018","v":166939.14509999999},17502.888312000006,98513.817948000025,3705.6899880000069,15526.133531999991,7099.9666920000091,83880.708911999842,3672.6875640000007,57888.286091999886]
[null,"junio",{"$f":"C90*0.0018","v":165933.32464800024},17807.294231999989,93418.484796000048,3885.3196200000039,16337.631492000022,7372.8771479999987,83000.493575999877,3708.779256000003,57271.4120159999]
[null,"julio",{"$f":"C91*0.0018","v":162698.6350079999},18238.586183999992,94575.302640000125,3937.3097399999947,17284.454459999979,7064.4024360000194,95250.194675999883,4025.4668999999999,65586.892643999963]
[null,"agosto",{"$f":"C92*0.0018","v":166012.44004799981},18090.678059999977,93481.551072000148,3865.0510079999908,16994.289312000004,7321.2637679999962,86034.606840000124,3823.0821719999981,59295.56068799994]
[null,"septiembre",{"$f":"C93*0.0018","v":157272.07204800003},17352.493703999975,88862.643324000121,3575.0365559999964,16666.374816000036,7014.8987999999999,82739.940191999893,3488.6124,57165.322032000018]
[null,"octubre",{"$f":"C94*0.0018","v":163233.75650399993},17924.611068000035,91085.560019999961,3658.0700520000009,19491.698771999985,7301.2965480000121,91224.124992000099,3498.5583359999991,64933.098048000022]
[null,"noviembre",{"$f":"C95*0.0018","v":168139.58943599995},18443.306700000001,98256.278484000199,3996.0811800000024,18778.680647999972,7490.3446800000156,90532.581048000022,3868.8184079999974,63489.355019999952]
[null,"diciembre",{"$f":"C96*0.0018","v":167374.50584399985},{"$f":"D96*0.0018","v":18898.785359999976},101744.06205600014,4476.1986359999992,19722.188304000028,7723.17,100632.9051,4365.2863800000023,71052.561216000002,"Ingresos extra al año en dólares"]
[null,"Total",{"$f":"SUM(C99:C110)","v":1986101.8500959997},{"$f":"SUM(D99:D110)","v":209183.83012799994},1178523.4177080004,46353.034727999999,205951.25023200005,86902.239060000036,1087145.1307079997,46448.425296000009,757546.38086399972,{"$f":"SUM(C111:K111)","v":5604155.558819999}]

{"sheet":"Parquimetros","index":2,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,0,4,0],[6,0,25,0],[27,0,28,0]]}
[]
["Información sobre cajones de estacionamientos y parámetros utilizados","Muncipalidad","Número de cajones de estacionamiento","Número de cajones de estacionamiento (motos)","Costo del estacionómetro por hora (CRC)","Ingresos al año por estacionómetros (CRC)","Uso al año en horas","Uso promedio (h) por cajon","Rotación al día (horario que funciona)","Elasticidad precio-demanda","Cambio precio"]
[null,"Liberia",1000,160,700,null,null,null,null,0.39,0.5]
[null,"San José",3000,null,840,{"$f":"637.76*1000000","v":637760000},{"$f":"F4/E4","v":759238.09523809527},{"$f":"G4/C4","v":253.07936507936509},{"$f":"H4/130","v":1.946764346764347}]
[null,"San José (Escenario 1)",4000,null,840,{"$f":"G5*E5","v":850346666.66666675},{"$f":"H5*C5","v":1012317.4603174604},{"$f":"H4","v":253.07936507936509},{"$f":"I4","v":1.946764346764347},{"$f":"K3*J3","v":0.19500000000000001}]
[]
["Considerando la elasticidad precio de la demanda se estimaron los cambios en el ingreso de San José, CR","Cambio en el precio",null,"Cambio en la demanda","Ingresos por cambios en precio y demanda","Ingresos extra generados por incrementos en tarifas",null,null,null,"Ingresos extra generados por incrementos en cajones de estacionamiento"," "]
[null,{"$f":"(B9-$B$14/7)","v":7.1428571428571536E-2},0.1,{"$f":"B8*$K$3","v":3.5714285714285768E-2},{"$f":"($G$4+(-D8*$G$4))*($E$4+$E$4*B8)","v":658910204.08163273},{"$f":"(MAX(E8:E26)-F4)*0.0018","v":143496.0000000002},"<- Tarifas",null,"Cantidad->",{"$f":"(F5-F4)*0.0018","v":382656.00000000012}]
[null,{"$f":"(B10-$B$14/7)","v":0.14285714285714296},0.15,7.142857142857148E-2,{"$f":"($G$4+(-D9*$G$4))*($E$4+$E$4*B9)","v":676806530.61224496}]
[null,{"$f":"(B11-$B$14/7)","v":0.21428571428571438},0.2,0.10714285714285719,{"$f":"($G$4+(-D10*$G$4))*($E$4+$E$4*B10)","v":691448979.59183669}]
[null,0.28571428571428581,0.25,0.1428571428571429,702837551.02040815]
[null,0.35714285714285721,0.3,0.1785714285714286,710972244.89795923]
[null,0.4285714285714286,0.35,0.2142857142857143,715853061.22448981]
[null,0.5,0.4,0.25,{"$f":"($G$4+(-D14*$G$4))*($E$4+$E$4*B14)","v":717480000.00000012}]
[null,{"$f":"(B14+$B$14/7)","v":0.5714285714285714},0.45,0.2857142857142857,{"$f":"($G$4+(-D15*$G$4))*($E$4+$E$4*B15)","v":715853061.22448981},{"$f":"E4+B14*E4","v":1260}]
[null,{"$f":"(B15+$B$14/7)","v":0.64285714285714279},0.5,0.3214285714285714,710972244.89795923]
[null,0.71428571428571419,0.55000000000000004,0.3571428571428571,702837551.02040827]
[null,0.78571428571428559,0.6,0.39285714285714279,691448979.59183681]
[null,{"$f":"(B18+$B$14/7)","v":0.85714285714285698},0.65,0.42857142857142849,{"$f":"($G$4+(-D19*$G$4))*($E$4+$E$4*B19)","v":676806530.61224496},{"$f":"G4+(-D19*G4)","v":433850.3401360545},{"$f":"E4+E4*B19","v":1560}]
[null,0.92857142857142838,0.7,0.46428571428571419,{"$f":"($G$4+(-D20*$G$4))*($E$4+$E$4*B20)","v":658910204.08163285}]
[null,0.99999999999999978,0.75,0.49999999999999989,{"$f":"($G$4+(-D21*$G$4))*($E$4+$E$4*B21)","v":637760000}]
[null,1.0714285714285712,0.8,0.53571428571428559,613355918.367347]
[null,1.1428571428571426,0.85,0.57142857142857129,585697959.18367362]
[null,1.214285714285714,0.9,0.60714285714285698,554786122.44897985]
[null,1.2857142857142854,0.95,0.64285714285714268,520620408.16326547]
[null,{"$f":"(B25+$B$14/7)","v":1.3571428571428568},1,0.67857142857142838,483200816.32653087]
[]
["Estudios utilizados","Título","Parkin price elasticity","Price elasticity of on-street parking demand—a case study from Seattle","The price elasticity of parking: A meta-analysis"]
[null,"Link","https://www.q-park.com/blogs/newsitem/13740/parking-price-elasticity","http://onlinepubs.trb.org/onlinepubs/conferences/2012/4thITM/Papers-A/0117-000111.pdf","https://www.researchgate.net/publication/331443775_The_price_elasticity_of_parking_A_meta-analysis"]

{"sheet":"Marchamos_auto","index":3,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,13],[1,0,8,0],[11,0,16,0]]}
[null,"Este impuesto es que no tiene ninguna relación con la capacidad de consumo de combustible de los diferentes vehículos, incluso vehículos con mayor capacidad de consumo de combustibles tienen un impuesto fijo en moneda local desde la creación de la ley en 1987, como es el caso de los autobuses o los camiones de carga. Más bien los vehículos de uso particular y de mayor cilindrada, pero más antigüedad, se benefician de una reducción paulatina del valor fiscal, en función de la fórmula que se aplica para ajustar estos valores en el tiempo, según lo dispone la propia ley"]
["Funcionamiento del Marchamo","Valor autos","Tasa",null,null,"Millones de colones","Colones","Dólares"]
[null,"Hasta 310,000",26200,null,"Ingresos por Marchamo (2019)",240000,{"$f":"F3*1000000","v":240000000000},{"$f":"I3","v":455400000},{"$f":"4554000*100","v":455400000}]
[null,"Sobre el exceso de 310,000 y hasta 1,220,000",1.2E-2]
[null,"Sobre el exceso de 1,220,000 y hasta 2,420,000",1.4999999999999999E-2]
[null,"Sobre el exceso de 2,420,000 y hasta 3,650,000",0.02]
[null,"Sobre el exceso de 3,650,000 y hasta 4,550,000 ",2.5000000000000001E-2]
[null,"Sobre el exceso de 4,550,000  y hasta 5,460,000 ",0.03]
[null,"Sobre el exceso de 5,460,000 ",3.5000000000000003E-2]
[]
[]
["Cálculos de distintos porcentajes dedicados a la Movilidad Urbana Sustentable","Porcentaje etiquetado para MUS","Recursos dedicados a MUS"]
[null,"0.5%",2277000]
[null,"0.8%",3415500]
[null,"1.0%",4554000]
[null,"2.0%",9108000]
[null,"3.0%",13662000]

{"sheet":"Gasolinas","index":4,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[[7,1,7,10],[9,1,10,10],[8,1,8,10],[21,2,21,6],[0,0,5,0],[7,0,10,0],[12,0,14,0],[16,0,19,0],[21,1,22,1],[21,0,24,0],[12,3,12,7],[12,1,13,1],[12,2,13,2]]}
["Información sobre el consumo de gasolina y el destino de los ingresos del estado","Tipo de gasolina","Litros consumidos","Costo litro de combstible (USD)","INGRESO (USD)","Impuesto Único a los Combustibles","Caja única del Estado. Ministerio de Hacienda","CONAVI","Muncipalidades","Fondo Forestal","Universidad de Costa Rica"]
[null,null,null,1,null,{"$f":"1/3","v":0.33333333333333331},0.48599999999999999,0.2175,0.2225,3.5000000000000003E-2,0.01]
[null,null,1,{"$f":"744*0.0018","v":1.3391999999999999},{"$f":"D3*C3","v":1.3391999999999999},{"$f":"E3*(1/3)","v":0.44639999999999996},{"$f":"F3*$G$2","v":0.21695039999999999},{"$f":"F3*$H$2","v":9.7091999999999998E-2},null,{"$f":"F3*$J$2","v":1.5624000000000001E-2},{"$f":"F3*$K$2","v":4.4640000000000001E-3}]
[null,"Gasolina Plus + super",1295694000,{"$f":"652*0.0018","v":1.1736},{"$f":"D4*C4","v":1520626478.3999999},{"$f":"E4*(1/3)","v":506875492.79999995},{"$f":"F4*$G$2","v":246341489.50079998},{"$f":"F4*$H$2","v":110245419.68399999},{"$f":"F4*$I$2","v":112779797.14799999},{"$f":"F4*$J$2","v":17740642.248},{"$f":"F4*$K$2","v":5068754.9279999994}]
[null,"Diesel",1233245000,{"$f":"561*0.0018","v":1.0098},{"$f":"D5*C5","v":1245330801},{"$f":"E5*(1/3)","v":415110267},{"$f":"F5*$G$2","v":201743589.76199999},{"$f":"F5*$H$2","v":90286483.072500005},{"$f":"F5*$I$2","v":92362034.407499999},{"$f":"F5*$J$2","v":14528859.345000001},{"$f":"F5*$K$2","v":4151102.67}]
[null,"Total",{"$f":"SUM(C4:C5)","v":2528939000},null,{"$f":"SUM(E4:E5)","v":2765957279.3999996},{"$f":"E6*(1/3)","v":921985759.79999983},{"$f":"F6*$G$2","v":448085079.26279992},{"$f":"F6*$H$2","v":200531902.75649998},205141831.55549997,{"$f":"F6*$J$2","v":32269501.592999998},{"$f":"F6*$K$2","v":9219857.5979999993}]
[]
["Información relevante proveniente de la Ley N° 8114 de Simplificación y Eficiencia Tributarias."," Un veintidós coma veinticinco por ciento (22,25%) a favor de las municipalidades, para la atención de la red vial cantonal, monto que será priorizado conforme a lo establecido en el plan vial de conservación y desarrollo (quinquenal) de cada municipalidad."]
[null,"Dicha red vial está compuesta por todos los caminos y calles bajo administración de los gobiernos locales, inventariados y georeferenciados como rutas cantonales por estas, y que constan en los registros oficiales del Ministerio Obras Públicas y Transportes (MOPT), así como por toda la infraestructura complementaria, siempre que se encuentre en terrenos de dominio público y cumpla los requisitos de ley.\nAsimismo, se considerarán como parte de la red vial cantonal las aceras, ciclovías, pasos, rutas peatonales, áreas verdes y de ornato, que se encuentran dentro del derecho de vía y demás elementos de infraestructura de seguridad vial entrelazadas a las calles locales y caminos cantonales, el señalamiento vertical y horizontal, los puentes y demás estructuras de drenaje y retención y las obras geotécnicas o de otra naturaleza asociadas con los caminos."]
[null,"La ejecución de dichos recursos se realizará, de preferencia, bajo la modalidad participativa de ejecución de obras. Conforme lo establece el Reglamento de esta Ley, el destino de los recursos lo propondrá, a cada concejo municipal, una junta vial cantonal o distrital, en su caso, nombrada por el mismo concejo, la cual estará integrada por representantes del gobierno local, el MOPT y la comunidad, por medio de convocatoria pública y abierta."]
[]
[]
["Cálculos de distintos porcentajes dedicados a la Movilidad Urbana Sustentable",null,"USD","Porcentaje etiquetado para MUS del ingreso que reciben las municipalidades",null,null,null,null,null,null,{"$f":"TEXT(D14,\"0.0%\")","v":"1.0%"},{"$f":"TEXT(E14,\"0.0%\")","v":"2.0%"},{"$f":"TEXT(F14,\"0.0%\")","v":"3.0%"},{"$f":"TEXT(G14,\"0.0%\")","v":"4.0%"},{"$f":"TEXT(H14,\"0.0%\")","v":"5.0%"}]
[null,null,null,0.01,0.02,0.03,0.04,0.05]
[null,"El ingreso para las municipalidades es :",{"$f":"I6","v":205141831.55549997},{"$f":"$C$15*D14","v":2051418.3155549997},{"$f":"$C$15*E14","v":4102836.6311099995},{"$f":"$C$15*F14","v":6154254.9466649992},{"$f":"$C$15*G14","v":8205673.262219999},{"$f":"$C$15*H14","v":10257091.577775},null,{"$f":"C15/8","v":25642728.944437496}]
[]
["Costo de algunos proyectos realizados en San José, Costa Rica para fines ilustrativos",null,"colones (millones)","colones","USD (2018)"]
[null,"Mantenimiento y construcción vial (San José CR)",1359.5,{"$f":"C18*1000000","v":1359500000},{"$f":"D18*0.0018","v":2447100},"DE TODO LO QUE DEDICAN A MANTENIMIENTO"]
[null,"Se construyen 50 obras viales en el cantón entre las cuales: -Construcción de aceras, -Cordón de caño, cunetas, -Gradas, -Rampas",103.2,{"$f":"C19*1000000","v":103200000},{"$f":"D19*0.0018","v":185760},null,{"$f":"F20/13","v":281630.76923076925}]
[null,"13 km ciclovía entre San José y Montes de Oca",113,{"$f":"C20*1000000","v":113000000},{"$f":"D20*0.0018","v":203400},{"$f":"E20*18","v":3661200},{"$f":"E20/H6","v":1.0143024486581702E-3},{"$f":"H6*0.01","v":2005319.0275649999}]
[]
["Cantidad de proyectos similares a los de San José con distintios porcentajes dedicados a MUS",null,"Cantidad de proyectos similares que se podrían hacer con los ingresos etiquetados"]
[null,null,0.01,0.02,0.03,0.04,0.05]
[null,"Ciclovías similares a la construida entre San José y Montes de Oca (13 km)",{"$f":"D15/$E$20","v":10.085635769690263},{"$f":"E15/$E$20","v":20.171271539380527},30.256907309070794,40.342543078761054,50.428178848451324]
[null,"50 obras viales en el cantón entre las cuales: -Construcción de aceras, -Cordón de caño, cunetas, -Gradas, -Rampas",{"$f":"D15/$E$19","v":11.043380251695735},{"$f":"E15/$E$19","v":22.086760503391471},33.130140755087204,44.173521006782941,55.216901258478678]

{"sheet":"Marchamos_moto","index":5,"n_rows":60,"n_cols":22,"rows_kept":60,"cut":false,"hidden":true,"merged":[[42,0,42,1],[1,0,1,4],[0,0,0,4],[17,5,17,9],[17,4,23,4],[42,2,47,2],[48,5,48,9],[17,11,17,15],[27,4,33,4],[27,5,27,9],[27,10,33,10],[27,11,27,15],[17,10,23,10]]}
["Infomración necesaria"]
["Artículo 9. - Tarifas del Impuesto. Las tarifas del impuesto son progresivas, y se aplicarán de conformidad con los tramos de la tabla establecida en el inciso f), numeral 1) del artículo 9 de la Ley N° 7088 de 30 de noviembre de 1987."]
[]
["Motocicleta","Monto del impuesto","Monto en letras"]
["De hasta 90 cc","¢700,00","Setecientos colones"]
["Más de 90 cc y hasta 125 cc","¢1.500,00","Mil quinientos colones"]
["Más de 125 cc y hasta 200 cc","¢3.000,00","Tres mil colones"]
["Más de 200 cc y hasta 450 cc","¢8.000,00","Ocho mil colones"]
["Más de 450 cc","¢15.000,00","Quince mil colones"]
[]
["Descuentos por año acumulable","año "]
[0.2,1]
[0.1,2]
[0.1,3]
[0.1,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.8212290502793292E-4,1.3043478260869566E-3,2.0066889632107021E-3,3.5476718403547672E-3,4.1599548694461501E-3]
[0.2,5]
[null,null,null,null,null,{"$f":"A12","v":0.2},{"$f":"F17+A13","v":0.30000000000000004},{"$f":"G17+A14","v":0.4},{"$f":"H17+A15","v":0.5},{"$f":"I17+A16","v":0.7}]
[null,null,null,null,"Impuesto a pagar los siguientes años","año",null,null,null,null,"Porcentaje respecto del valor de la motocicleta","año"]
["Supongamos una moto 2019","Precio","Impuesto","% respecto del valor",null,1,2,3,4,5,null,1,2,3,4,5]
["Crux-REV",895000,700,{"$f":"C20/B20","v":7.8212290502793292E-4},null,{"$f":"C20-C20*$F$17","v":560},{"$f":"C20-C20*$G$17","v":490},{"$f":"C20-C20*$H$17","v":420},{"$f":"C20-C20*$I$17","v":350},{"$f":"C20-C20*$J$17","v":210.00000000000006},null,{"$f":"F20/B20","v":6.2569832402234633E-4},{"$f":"G20/B20","v":5.4748603351955304E-4},{"$f":"H20/B20","v":4.6927374301675975E-4},{"$f":"I20/B20","v":3.9106145251396646E-4},{"$f":"J20/B20","v":2.3463687150837996E-4}]
["RAY ZR",1150000,1500,{"$f":"C21/B21","v":1.3043478260869566E-3},null,{"$f":"C21-C21*$F$17","v":1200},{"$f":"C21-C21*$G$17","v":1050},{"$f":"C21-C21*$H$17","v":900},{"$f":"C21-C21*$I$17","v":750},{"$f":"C21-C21*$J$17","v":450},null,{"$f":"F21/B21","v":1.0434782608695651E-3},{"$f":"G21/B21","v":9.1304347826086959E-4},{"$f":"H21/B21","v":7.8260869565217395E-4},{"$f":"I21/B21","v":6.5217391304347831E-4},{"$f":"J21/B21","v":3.9130434782608698E-4}]
["FZN 150",1495000,3000,{"$f":"C22/B22","v":2.0066889632107021E-3},null,2400,2100,1800,1500,900,null,1.605351170568562E-3,1.4046822742474917E-3,1.2040133779264214E-3,1.0033444816053511E-3,6.0200668896321068E-4]
["FZ 250 Fi",2255000,8000,3.5476718403547672E-3,null,6400,5600,4800,4000,2400,null,2.8381374722838137E-3,2.483370288248337E-3,2.1286031042128603E-3,1.7738359201773836E-3,1.0643015521064302E-3]
["YZF R6",9670000,15000,1.5511892450879006E-3,null,12000,10500,9000,7500,4500,null,1.2409513960703205E-3,1.0858324715615306E-3,9.3071354705274046E-4,7.7559462254395031E-4,4.6535677352637023E-4]
[]
[]
[null,null,null,null,null,{"$f":"A12","v":0.2},{"$f":"F27+A13","v":0.30000000000000004},{"$f":"G27+A14","v":0.4},{"$f":"H27+A15","v":0.5},{"$f":"I27+A16","v":0.7}]
[null,null,null,null,"Impuesto a pagar los siguientes años","año",null,null,null,null,"Porcentaje respecto del valor de la motocicleta","año"]
["Supongamos una moto 2019","Precio","Impuesto","% respecto del valor",null,1,2,3,4,5,null,1,2,3,4,5]
["Crux-REV",895000,700,{"$f":"C30/B30","v":7.8212290502793292E-4},null,{"$f":"C30-C30*$F$17","v":560},{"$f":"C30-C30*$G$17","v":490},{"$f":"C30-C30*$H$17","v":420},{"$f":"C30-C30*$I$17","v":350},{"$f":"C30-C30*$J$17","v":210.00000000000006},null,{"$f":"F30/B30","v":6.2569832402234633E-4},{"$f":"G30/B30","v":5.4748603351955304E-4},{"$f":"H30/B30","v":4.6927374301675975E-4},{"$f":"I30/B30","v":3.9106145251396646E-4},{"$f":"J30/B30","v":2.3463687150837996E-4}]
["RAY ZR",1150000,1500,{"$f":"C31/B31","v":1.3043478260869566E-3},null,{"$f":"C31-C31*$F$17","v":1200},{"$f":"C31-C31*$G$17","v":1050},{"$f":"C31-C31*$H$17","v":900},{"$f":"C31-C31*$I$17","v":750},{"$f":"C31-C31*$J$17","v":450},null,{"$f":"F31/B31","v":1.0434782608695651E-3},{"$f":"G31/B31","v":9.1304347826086959E-4},{"$f":"H31/B31","v":7.8260869565217395E-4},{"$f":"I31/B31","v":6.5217391304347831E-4},{"$f":"J31/B31","v":3.9130434782608698E-4}]
["FZN 150",1495000,3000,{"$f":"C32/B32","v":2.0066889632107021E-3},null,2400,2100,1800,1500,900,null,1.605351170568562E-3,1.4046822742474917E-3,1.2040133779264214E-3,1.0033444816053511E-3,6.0200668896321068E-4]
["FZ 250 Fi",2255000,8000,3.5476718403547672E-3,null,6400,5600,4800,4000,2400,null,2.8381374722838137E-3,2.483370288248337E-3,2.1286031042128603E-3,1.7738359201773836E-3,1.0643015521064302E-3]
["YZF R6",9670000,{"$f":"B34*D34","v":40227.199999999997},4.1599999999999996E-3,null,32181.759999999998,28159.039999999994,24136.32,20113.599999999999,12068.16,null,3.3279999999999998E-3,2.9119999999999992E-3,2.496E-3,2.0799999999999998E-3,1.248E-3]
[]
[null,null,null,null,{"$f":"B30*0.01/33","v":271.21212121212119}]
[2015,{"$f":"B38/1.23","v":55069.918699186994},null,null,{"$f":"B31*0.01/33","v":348.4848484848485}]
[2016,67736,null,null,453.030303030303]
[2017,{"$f":"B38*1.23","v":83315.28},null,null,683.33333333333337]
[2018,{"$f":"B39*1.23","v":102477.7944},null,null,2930.3030303030305]
[2019,126047.687112]
[]
["supuesto de market share",null,"MARKET Share de moto"]
["De hasta 90 cc",35]
["Más de 90 cc y hasta 125 cc",25]
["Más de 125 cc y hasta 200 cc",20]
["Más de 200 cc y hasta 450 cc",15]
["Más de 450 cc",5]
[null,null,null,null,null,"año"]
[null,"Cantidad motos","Impuesto actual","Impuestos propuesto",null,1,2,3,4,5]
["Crux-REV",{"$f":"$B$41*(B44/100)","v":44116.690489199995},{"$f":"B51*C20","v":30881683.342439998},{"$f":"B51*C30","v":30881683.342439998},null,{"$f":"B51*F30","v":24705346.673951998},{"$f":"B51*G30","v":21617178.339707997},{"$f":"B51*H30","v":18529010.005463999},{"$f":"B51*I30","v":15440841.671219999},{"$f":"B51*J30","v":9264505.0027320012}]
["RAY ZR",{"$f":"$B$41*(B45/100)","v":31511.921778},{"$f":"B52*C21","v":47267882.667000003},{"$f":"B52*C31","v":47267882.667000003},null,{"$f":"B52*F31","v":37814306.133599997},{"$f":"B52*G31","v":33087517.866900001},{"$f":"B52*H31","v":28360729.600200001},{"$f":"B52*I31","v":23633941.333500002},{"$f":"B52*J31","v":14180364.800100001}]
["FZN 150",25209.537422400001,75628612.267200008,75628612.267200008,null,60502889.813760005,52940028.58704,45377167.360320002,37814306.133600004,22688583.680160001]
["FZ 250 Fi",18907.153066799998,151257224.53439999,151257224.53439999,null,121005779.62751998,105880057.17407998,90754334.720639989,75628612.267199993,45377167.360319994]
["YZF R6",{"$f":"$B$41*(B48/100)","v":6302.3843556000002},{"$f":"B55*C24","v":94535765.334000006},{"$f":"B55*C34","v":253527275.94959232},"Impuesto 1",{"$f":"B55*F24","v":75628612.267200008},{"$f":"B55*G24","v":66175035.733800001},{"$f":"B55*H24","v":56721459.200400002},{"$f":"B55*I24","v":47267882.667000003},{"$f":"B55*J24","v":28360729.600200001}]
[null,null,null,null,"Impuesto 2",{"$f":"B55*F34","v":202821820.75967386},{"$f":"B55*G34","v":177469093.16471457},{"$f":"B55*H34","v":152116365.56975541},{"$f":"B55*I34","v":126763637.97479616},{"$f":"B55*J34","v":76058182.784877703}]
["Diferencia en 2019 por ajuste (colones)",{"$f":"(D55-C55)","v":158991510.6155923},null,null,"diff",{"$f":"F56-F55","v":127193208.49247386},{"$f":"G56-G55","v":111294057.43091458},95394906.36935541,79495755.30779615,47697453.184677705]
["Diferencia en 2019 por ajuste (USD)",{"$f":"B57*0.0018","v":286184.71910806611}]
["Diferencia acumulada por ajuste (colones)",{"$f":"SUM(F57:J57)","v":461075380.78521764}]
["Diferenca acumulada por ajuste (USD)",{"$f":"B59*0.0018","v":829935.68541339168}]

{"sheet":"Info_tablas","index":6,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Tarifas de congestión"]
[null,"Parquímetros"]
[null,"Impuesto a la propiedad de vehículo"]
[null,"Impuesto único a los combustibles"]
[null,"Patentes"]
[null,"Contribuciones especiales"]
[]
[null,"caseta","tarifa actual","Hora pico","Hora valle"]
[null,"escazú",370,555,333]
[null,"ciudad colón",180,270,162]
[null,"san rafael",560,840,504]
[null,"guacima",420,630,378]
[null,"siquiares",440,660,396]
[null,"intercambio atenas",370,555,333]
[null,"atenas",740,1110,666]
[null,"intercambio pozon",180,270,162]
[null,"pozon",560,840,504]
[]
[null,"Mes"]
[null,"enero"]
[null,"febrero"]
[null,"marzo"]
[null,"abril"]
[null,"mayo"]
[null,"junio"]
[null,"julio"]
[null,"agosto"]
[null,"septiembre"]
[null,"octubre"]
[null,"noviembre"]
[null,"diciembre"]