{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["INPC"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"INPC","index":0,"n_rows":70,"n_cols":24,"rows_kept":70,"cut":false,"hidden":false,"merged":[[2,12,5,14]]}
[null,"DETERMINACIÓN DE FACTOR DE ACTUALIZACIÓN"]
[null,"(Celdas Editables)"]
[null,"Modificar celdas sombreadas color amarillo",null,null,null,null,null,null,null,null,null,null,"Tomar nota de los comentarios en cada celda",null,null,null,null,null,null,"Importe Histórico",2972]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mes a actualizar","2021-12-31",{"$f":"+INDEX(inpc,MATCH(Q6,B14:B70,0),MATCH(P6,B15:N15,0))","v":117.30800000000001}]
[null,null,null,null,null,null,null,null,"Autor: Mario Beltrán",null,null,null,null,null,null,{"$f":"+PROPER(VLOOKUP(MONTH(C9),P10:Q21,2))","v":"Mar"},{"$f":"+YEAR(C9)","v":2022},null,null,"Fecha de Pago","2022-03-31",{"$f":"+INDEX(inpc,MATCH(Q5,B14:B70,0),MATCH(P5,B15:N15,0))","v":120.15900000000001},{"$f":"+TRUNC((V5/V4),4)","v":1.0243},"No modificar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+PROPER(VLOOKUP(MONTH(C10),P10:Q21,2))","v":"Dic"},{"$f":"+YEAR(C10)","v":2021},null,null,"Porcentaje de Recargos",1.47E-2,"No modificar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meses de incumplimiento",{"$f":"+DATEDIF(C10,C9,\"m\")+1","v":4},{"$f":"+U7*U6","v":5.8799999999999998E-2},"No modificar"]
[null,null,"Cantidad a actualizar",null,null,{"$f":"+U3","v":2972},"No modificar",null,null,null,null,null,null,null,null,null,null,null,null,null,"No modificar"]
[null,null,{"$f":"+U5","v":"2022-03-31"},null,{"$f":"+INDEX(inpc,MATCH(Q5,B14:B70,0),MATCH(P5,B15:N15,0))","v":120.15900000000001},"No modificar",null,null,"www.mariobeltran.mx",null,null,null,null,null,null,"Número","Mes"]
[null,"Entre:",{"$f":"+U4","v":"2021-12-31"},null,{"$f":"+INDEX(inpc,MATCH(Q6,B14:B70,0),MATCH(P6,B15:N15,0))","v":117.30800000000001},"No modificar",null,null,null,null,null,null,null,null,null,1,"ENE"]
[null,"Igual:","Factor de Actualización",null,null,{"$f":"+IF((E9/E10)>1,TRUNC((E9/E10),4),1)","v":1.0243},"No modificar",null,"#excelparaimpuestos",null,null,null,null,null,null,2,"FEB",null,null,"Importe Histórico",{"$f":"+F8","v":2972},"No modificar"]
[null,null,"Importe Actualizado",null,null,{"$f":"+F8*F11","v":3044.2195999999999},"No modificar",null,null,null,null,null,null,null,null,3,"MAR",null,null,"Actualización",{"$f":"+ROUND((F12-F8),0)","v":72},"No modificar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"ABR",null,null,"Importe Actualizado",{"$f":"+U11+U12","v":3044},"No modificar"]
[null,"INPC (Índice Nacional de Precios al Consumidor)",null,null,null,null,null,null,null,null,null,null,null,null,null,5,"MAY",null,null,"Recargos",{"$f":"ROUND((IF(C9>C10,DATEDIF(C10,C9,\"m\")+1,0))*1.47%*U13,0)","v":179},"No modificar"]
[null,null,"ENE","FEB","MAR","ABR","MAY","JUN","JUL","AGO","SEP","OCT","NOV","DIC",null,6,"JUN",null,null,"Importe a Pagar",{"$f":"+U13+U14","v":3223},"No modificar"]
[null,2023,127.336,128.04599999999999,128.38900000000001,128.363,128.084,128.214,"-","-","-","-","-","-",null,7,"JUL"]
[null,2022,118.002,118.98099999999999,120.15900000000001,120.809,121.02200000000001,122.044,122.94799999999999,123.803,124.571,125.276,125.997,126.47799999999999,null,8,"AGO"]
[null,2021,110.21,110.907,111.824,112.19,112.419,113.018,113.682,113.899,114.601,115.56100000000001,116.884,117.30800000000001,null,9,"SEP"]
[null,2020,106.447,106.889,106.83799999999999,105.755,106.16200000000001,106.74299999999999,107.444,107.867,108.114,108.774,108.85599999999999,109.271,null,10,"OCT"]
[null,2019,103.108,103.07899999999999,103.476,103.53100000000001,103.233,103.29900000000001,103.687,103.67,103.94199999999999,104.503,105.346,105.934,null,11,"NOV"]
[null,2018,98.795000000000002,99.171374,99.492157000000006,99.154847000000004,98.994079999999997,99.376464999999996,99.909000000000006,100.492,100.917,101.44,102.303,103.02,null,12,"DIC"]
[null,2017,93.603881999999999,94.144779999999997,94.722488999999996,94.838932999999997,94.725493999999998,94.963639999999998,95.322736000000006,95.793768,96.093514999999996,96.698268999999996,97.695173999999994,98.272882999999993]
[null,2016,89.386381,89.777781000000004,89.910000999999994,89.625277999999994,89.225615000000005,89.324027999999998,89.556914000000006,89.809332999999995,90.357743999999997,90.906154000000001,91.616833999999997,92.039034999999998]
[null,2015,87.110102999999995,87.275377000000006,87.630717000000004,87.403840000000002,86.967365999999998,87.113107999999997,87.240819999999999,87.424875,87.752419000000003,88.203918999999999,88.685468,89.046818000000002]
[null,2014,84.519052000000002,84.733157000000006,84.965292000000005,84.806779000000006,84.535578999999998,84.682072000000005,84.914958999999996,85.219965000000002,85.596339999999998,86.069626,86.763778000000002,87.188984000000005]
[null,2013,80.892781999999997,81.290942999999999,81.887433000000001,81.941523000000004,81.668819999999997,81.619237999999996,81.592192999999995,81.824327999999994,82.132339999999999,82.522987999999998,83.292265,83.770058000000006]
[null,2012,78.343048999999993,78.502313999999998,78.547388999999995,78.300979999999996,78.053819000000004,78.413667000000004,78.853897000000003,79.090540000000004,79.439119000000005,79.841036000000003,80.383437000000001,80.568242999999995]
[null,2011,75.295991000000001,75.578460000000007,75.723450999999997,75.717440999999994,75.159263999999993,75.155507999999998,75.516107000000005,75.635554999999997,75.821112999999997,76.332712000000001,77.158332999999999,77.792384999999996]
[null,2010,72.552046000000004,72.971671000000001,73.489725000000007,73.255565000000004,72.793977999999996,72.771182999999994,72.929190000000006,73.131749999999997,73.515110000000007,73.968925999999996,74.561581000000004,74.930954]
[null,2009,69.456148999999996,69.609493999999998,70.009950000000003,70.254990000000006,70.050358000000003,70.179354000000004,70.370515999999995,70.538883999999996,70.892715999999993,71.107191,71.476045999999997,71.771855000000002]
[null,2008,65.350564000000006,65.544833999999994,66.019891000000001,66.170126999999994,66.098635000000002,66.372168000000002,66.742058999999998,67.127492000000004,67.584935000000002,68.045485999999997,68.818942000000007,69.295552000000001]
[null,2007,63.016207999999999,63.192346999999998,63.329113,63.291294999999998,62.982534000000001,63.058169999999997,63.326005000000002,63.583995999999999,64.077703,64.327404999999999,64.781221000000002,65.049055999999993]
[null,2006,60.603625999999998,60.696357999999996,60.772511999999999,60.861617000000003,60.590674999999997,60.642997999999999,60.809294000000001,61.119608999999997,61.736612000000001,62.006518999999997,62.331856999999999,62.692424000000003]
[null,2005,58.309159999999999,58.503430999999999,58.767121000000003,58.976415000000003,58.828251000000002,58.771782999999999,59.001800000000003,59.072254999999998,59.309005999999997,59.45458,59.882492999999997,60.250312000000001]
[null,2004,55.774317000000003,56.107945000000001,56.298071,56.383032,56.241602999999998,56.331744999999998,56.479390000000002,56.828040999999999,57.297916999999998,57.694747,58.186898999999997,58.307088]
[null,2003,53.525441000000001,53.674121999999997,54.012929999999997,54.105144000000003,53.93056,53.975112000000003,54.053339000000001,54.215490000000003,54.538238,54.738207000000003,55.192542000000003,55.429811000000001]
[null,2002,50.900472000000001,50.867750000000001,51.127948000000004,51.407235,51.511429,51.762585999999999,51.911180999999999,52.108559999999997,52.421984000000002,52.653036,53.078876999999999,53.309930000000001]
[null,2001,48.575476000000002,48.543328000000002,48.850887999999998,49.097309000000003,49.209969999999998,49.326363999999998,49.198202000000002,49.489688000000001,49.950381,50.176135000000002,50.365149000000002,50.434899000000001]
[null,2000,44.93083,45.32938,45.580680999999998,45.840018000000001,46.011378999999998,46.283920000000002,46.464466000000002,46.719785000000002,47.061072000000003,47.385136000000003,47.790287999999997,48.307670999999999]
[null,1999,40.469769999999997,41.013643000000002,41.394683999999998,41.774577000000001,42.025877000000001,42.302005999999999,42.581580000000002,42.821255000000001,43.235017999999997,43.508851,43.895775999999998,44.335515999999998]
[null,1998,34.003923999999998,34.599238,35.004533000000002,35.332042000000001,35.613481,36.034419999999997,36.381878,36.731631999999998,37.327376000000001,37.862268999999998,38.532786000000002,39.472974000000001]
[null,1997,29.498885999999999,29.994598,30.367889000000002,30.695972000000001,30.976119000000001,31.250957,31.523211,31.803502000000002,32.199612999999999,32.456941,32.820042000000001,33.279874999999997]
[null,1996,23.329754000000001,23.874262000000002,24.399826000000001,25.093450000000001,25.550841999999999,25.966902000000001,26.336030999999998,26.686071999999999,27.112750999999999,27.451167999999999,27.867083000000001,28.759336000000001]
[null,1995,15.376991,16.028707000000001,16.973617000000001,18.326132999999999,19.092089999999999,19.698024,20.099588000000001,20.432981000000002,20.855643000000001,21.284762000000001,21.809608000000001,22.520167000000001]
[null,1994,13.950374999999999,14.022124,14.094225,14.163251000000001,14.231681999999999,14.302894999999999,14.366327,14.433287,14.535937000000001,14.612245,14.690360999999999,14.819203999999999]
[null,1993,12.977320000000001,13.083345,13.159594,13.235480000000001,13.311137,13.385797,13.450123,13.522112,13.622261,13.677973,13.738301999999999,13.843055]
[null,1992,11.657778,11.7959,11.915948,12.022171,12.101438,12.183344999999999,12.260272000000001,12.335592,12.442897,12.532494,12.636620000000001,12.816553000000001]
[null,1991,9.8838799999999996,10.056425000000001,10.19984,10.306687999999999,10.407442,10.516648,10.609584,10.683422999999999,10.789849999999999,10.915343,11.186374000000001,11.449680000000001]
[null,1990,7.7760369999999996,7.9521199999999999,8.0923099999999994,8.2154720000000001,8.3588380000000004,8.5429390000000005,8.6987349999999992,8.8469499999999996,8.9730609999999995,9.1020599999999998,9.3437230000000007,9.6382139999999996]
[null,1989,6.349024,6.4351839999999996,6.5049450000000002,6.6022239999999996,6.6930990000000001,6.7743849999999997,6.8421479999999999,6.9073330000000004,6.9733929999999997,7.0765250000000002,7.1758550000000003,7.4180299999999999]
[null,1988,4.7182459999999997,5.111783,5.3735470000000003,5.5389410000000003,5.646109,5.7612920000000001,5.8574570000000001,5.9113429999999996,5.9451390000000002,5.9904859999999998,6.0706540000000002,6.1973159999999998]
[null,1987,1.7044010000000001,1.827386,1.948153,2.1186060000000002,2.2783250000000002,2.443146,2.641022,2.8568720000000001,3.0450810000000001,3.298845,3.560511,4.086392]
[null,1986,0.83409199999999994,0.871174,0.91166700000000001,0.95926299999999998,1.01257,1.0775669999999999,1.1313329999999999,1.2215309999999999,1.2948120000000001,1.368824,1.4613039999999999,1.576735]
[null,1985,0.50271100000000002,0.52359599999999995,0.54388499999999995,0.56062100000000004,0.57390200000000002,0.58827600000000002,0.60876300000000005,0.63537699999999997,0.66075200000000001,0.68585200000000002,0.71749499999999999,0.76634000000000002]
[null,1984,0.31272800000000001,0.32923200000000002,0.343304,0.35815599999999997,0.37003200000000003,0.38342300000000001,0.39599299999999998,0.40724900000000003,0.41937999999999998,0.43403399999999998,0.44892900000000002,0.46799600000000002]
[null,1983,0.18035499999999999,0.19003400000000001,0.19923199999999999,0.21184600000000001,0.22103400000000001,0.229404,0.24074599999999999,0.25009100000000001,0.25778699999999999,0.26634099999999999,0.28198299999999998,0.294047]
[null,1982,8.5865999999999998E-2,8.924E-2,9.2498999999999998E-2,9.7512000000000001E-2,0.102993,0.10795399999999999,0.11351700000000001,0.12625600000000001,0.132995,0.13988999999999999,0.14696300000000001,0.162656]
[null,1981,6.5615000000000007E-2,6.7226999999999995E-2,6.8665000000000004E-2,7.0212999999999998E-2,7.1275000000000005E-2,7.2271000000000002E-2,7.3543999999999998E-2,7.5060000000000002E-2,7.6455999999999996E-2,7.8153E-2,7.9657000000000006E-2,8.1800999999999999E-2]
[null,1980,5.1341999999999999E-2,5.2528999999999999E-2,5.3609999999999998E-2,5.4546999999999998E-2,5.5437E-2,5.6536000000000003E-2,5.8115E-2,5.9318999999999997E-2,5.9977999999999997E-2,6.0886000000000003E-2,6.1941999999999997E-2,6.3566999999999999E-2]
[null,1979,4.2236999999999997E-2,4.2845000000000001E-2,4.3425999999999999E-2,4.3815E-2,4.4388999999999998E-2,4.4880999999999997E-2,4.5425E-2,4.6112E-2,4.6677999999999997E-2,4.7493E-2,4.8104000000000001E-2,4.8956E-2]
[null,1978,3.5892E-2,3.6408000000000003E-2,3.6787E-2,3.7196E-2,3.7560000000000003E-2,3.8077E-2,3.8723E-2,3.9108999999999998E-2,3.9555E-2,4.0034E-2,4.0446000000000003E-2,4.0788999999999999E-2]
[null,1977,3.0027000000000002E-2,3.0689999999999999E-2,3.1224999999999999E-2,3.1697000000000003E-2,3.1975999999999997E-2,3.2368000000000001E-2,3.2733999999999999E-2,3.3404999999999997E-2,3.3998E-2,3.4257999999999997E-2,3.4632000000000003E-2,3.5111999999999997E-2]
[null,1976,2.3318999999999999E-2,2.3754999999999998E-2,2.3987999999999999E-2,2.4156E-2,2.4324999999999999E-2,2.4423E-2,2.4629000000000002E-2,2.4865000000000002E-2,2.5713E-2,2.7161000000000001E-2,2.8388E-2,2.9100000000000001E-2]
[null,1975,2.0816000000000001E-2,2.0931000000000002E-2,2.1062999999999998E-2,2.1240999999999999E-2,2.1524999999999999E-2,2.1891000000000001E-2,2.2065999999999999E-2,2.2256999999999999E-2,2.2419000000000001E-2,2.2533999999999998E-2,2.2692E-2,2.2877000000000002E-2]
[null,1974,1.7652999999999999E-2,1.8051999999999999E-2,1.8190999999999999E-2,1.8438E-2,1.8582999999999999E-2,1.8766000000000001E-2,1.9037999999999999E-2,1.9238999999999999E-2,1.9456999999999999E-2,1.9843E-2,2.0393999999999999E-2,2.0552999999999998E-2]
[null,1973,1.4246E-2,1.4363000000000001E-2,1.4489999999999999E-2,1.4718999999999999E-2,1.4876E-2,1.4997999999999999E-2,1.5382E-2,1.5629000000000001E-2,1.6001000000000001E-2,1.6206000000000002E-2,1.6406E-2,1.7042999999999999E-2]
[null,1972,1.3362000000000001E-2,1.3403E-2,1.3476E-2,1.3561E-2,1.3587999999999999E-2,1.3689E-2,1.374E-2,1.3831E-2,1.3894E-2,1.3904E-2,1.3993999999999999E-2,1.4042000000000001E-2]
[null,1971,1.2799E-2,1.2852000000000001E-2,1.2900999999999999E-2,1.2966999999999999E-2,1.2994E-2,1.3053E-2,1.3043000000000001E-2,1.3162E-2,1.3205E-2,1.3218000000000001E-2,1.324E-2,1.3303000000000001E-2]
[null,1970,1.2198000000000001E-2,1.2196E-2,1.2232E-2,1.2248E-2,1.2274E-2,1.2348E-2,1.2409E-2,1.2466E-2,1.2496E-2,1.2500000000000001E-2,1.2567999999999999E-2,1.2674E-2]
[null,1969,1.1594999999999999E-2,1.1636000000000001E-2,1.1648E-2,1.1679999999999999E-2,1.1679999999999999E-2,1.1721000000000001E-2,1.1766E-2,1.1779E-2,1.1889E-2,1.2014E-2,1.2015E-2,1.2106E-2]