{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Inicio","Ejercicio","Calcular","INPC","Recargos","Efectua_Calculo","Memoria de Calculo","Mem Calc"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":23,"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":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[19,2,19,3],[21,2,21,3],[7,2,7,5]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Periodo 1998-2014"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Captura de Recargos"]
[]
[null,null,"Captura INPC"]

{"sheet":"Ejercicio","index":1,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,4,0,6],[2,0,2,5],[2,6,2,9],[16,0,16,1],[4,6,4,9],[5,6,5,9],[7,7,7,9],[9,7,9,9],[8,0,8,1],[15,7,15,9],[14,7,14,9],[11,0,11,1]]}
["Protasio Guerra y Asociados, S.C.",null,null,null,"pgasc@pgasc.com"]
[]
["IMPUESTOS DEL EJERCICIO FISCAL",null,null,null,null,null,"Actualizado a"]
[]
["Empresa:","*","-",null,null,null,{"$f":"INPC!AC56","v":"INPC: Diciembre de 2013"}]
["Por el ejercicio de:              ","*","-",null,null,null,{"$f":"Recargos!J223","v":"RECARGOS: Diciembre de 2014"}]
[]
[null,null,null,"Actuali-",null,null,null,"De 1998 a 2014"]
["CALCULOS",null,"Impuestos","cación","Recargos","Total"]
[null,null,null,{"$f":"Efectua_Calculo!J29","v":1.0355000000000001},{"$f":"Recargos!AA208/100","v":0.12429999999999997},null,null,"Se debió de efectuar el pago"]
[]
["Impuestos del Ejercicio",null,null,null,null,null,null,"Mes",2,"*"]
["Impuesto sobre la renta","*",0,{"$f":"+ROUND((C13*$D$10)-C13,0)","v":0},{"$f":"IF($E$10=\"error\",0,ROUND((C13+D13)*$E$10,0))","v":0},{"$f":"SUM(C13:E13)","v":0},null,"Año",2013,"*"]
["Ietu/Impac","*",0,{"$f":"+ROUND((C14*$D$10)-C14,0)","v":0},{"$f":"IF($E$10=\"error\",0,ROUND((C14+D14)*$E$10,0))","v":0},{"$f":"SUM(C14:E14)","v":0}]
["-","*",0,{"$f":"+ROUND((C15*$D$10)-C15,0)","v":0},{"$f":"IF($E$10=\"error\",0,ROUND((C15+D15)*$E$10,0))","v":0},{"$f":"SUM(C15:E15)","v":0},null,"Se realizará el pago"]
[]
["Otros Calculos Anuales",null,null,null,null,null,null,"Dia",19]
["ISR sueldos","*",0,{"$f":"+ROUND((C18*$D$10)-C18,0)","v":0},{"$f":"IF($E$10=\"error\",0,ROUND((C18+D18)*$E$10,0))","v":0},{"$f":"SUM(C18:E18)","v":0},null,{"$f":"+H12","v":"Mes"},1,"*"]
["-","*",0,0,0,0,null,{"$f":"+H13","v":"Año"},2014,"*"]
["-","*",0,0,0,0]
["-","*",0,0,0,0,null,"Memoria"]
["-","*",0,0,0,0,null,"de Cálculo"]
["-","*",0,0,0,0,null,{"$f":"IF(D10=0,\"Verifique correcta captura de INPC\",\"\")","v":""}]
[]
[null,"Totales",{"$f":"SUM(C13:C23)","v":0},{"$f":"SUM(D13:D23)","v":0},{"$f":"SUM(E13:E23)","v":0},{"$f":"SUM(F13:F23)","v":0},null,"Regresa al Menú Anterior"]
[]
["Articulo 21 del CFF"]
["Articulo 17-A del CFF"]

{"sheet":"Calcular","index":2,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[24,0,24,1],[8,0,8,1],[14,7,14,9],[11,0,11,1],[2,6,2,9],[16,0,16,1],[0,0,0,2],[0,4,0,6],[7,7,7,9],[9,7,9,9],[2,0,2,5],[4,6,4,9],[5,6,5,9]]}
["Protasio Guerra y Asociados, S.C.",null,null,null,"pgasc@pgasc.com"]
[]
["IMPUESTOS PROVISIONALES, DEFINITIVOS Y ENTERO DE RETENCIONES MENSALES",null,null,null,null,null,"Actualizado a"]
[]
["Empresa:","*","-",null,null,null,{"$f":"INPC!AC56","v":"INPC: Diciembre de 2013"}]
["Período:                      ","*","-",null,null,null,{"$f":"Recargos!J223","v":"RECARGOS: Diciembre de 2014"}]
[]
[null,null,null,"Actuali-",null,null,null,"De 1998 a 2014"]
["CALCULOS",null,"Impuestos","cación","Recargos","Total"]
[null,null,null,{"$f":"Efectua_Calculo!J14","v":1.0169999999999999},{"$f":"Recargos!I221/100","v":4.5199999999999997E-2},null,null,"Se debió de efectuar el pago"]
[]
["Pagos Prov. o Definitivos",null,null,null,null,null,null,"Mes",1,"*"]
["Impuesto sobre la renta","*",0,{"$f":"+ROUND((C13*$D$10)-C13,0)","v":0},{"$f":"IF($E$10=\"error\",0,ROUND((C13+D13)*$E$10,0))","v":0},{"$f":"SUM(C13:E13)","v":0},null,"Año",2013,"*"]
["Impac/Ietu","*",0,{"$f":"+ROUND((C14*$D$10)-C14,0)","v":0},{"$f":"IF($E$10=\"error\",0,ROUND((C14+D14)*$E$10,0))","v":0},{"$f":"SUM(C14:E14)","v":0}]
["Impuesto al valor agregado","*",0,{"$f":"+ROUND((C15*$D$10)-C15,0)","v":0},0,{"$f":"SUM(C15:E15)","v":0},null,"Se realizará el pago"]
[]
["Retenciones",null,null,null,null,null,null,"Día",15,"*"]
["ISR sueldos","*",0,{"$f":"+ROUND((C18*$D$10)-C18,0)","v":0},0,{"$f":"SUM(C18:E18)","v":0},null,{"$f":"+H12","v":"Mes"},5,"*"]
["ISR asimilables","*",0,0,0,0,null,{"$f":"+H13","v":"Año"},2013,"*"]
["ISR honorarios","*",0,0,0,0]
["ISR arrendamiento","*",0,0,0,0,null,"Memoria"]
["ISR extranjero","*",0,0,0,0,null,"de Cálculo"]
["IVA retenido","*",0,0,0,0]
[]
["Otros",null,null,null,null,null,null,{"$f":"IF(D10=0,\"Verifique correcta captura de INPC\",\"\")","v":""}]
["Iespys","*",0,{"$f":"+ROUND((C26*$D$10)-C26,0)","v":0},0,{"$f":"SUM(C26:E26)","v":0}]
["Iscas","*",0,{"$f":"+ROUND((C27*$D$10)-C27,0)","v":0},0,{"$f":"SUM(C27:E27)","v":0},null,"Regresa al Menú Anterior"]
["-","*",0,{"$f":"+ROUND((C28*$D$10)-C28,0)","v":0},0,{"$f":"SUM(C28:E28)","v":0}]
["-","*",0,{"$f":"+ROUND((C29*$D$10)-C29,0)","v":0},0,{"$f":"SUM(C29:E29)","v":0}]
[]
[null,"Totales",{"$f":"SUM(C13:C29)","v":0},{"$f":"SUM(D13:D29)","v":0},{"$f":"SUM(E13:E29)","v":0},{"$f":"SUM(F13:F29)","v":0}]
[]
["Articulo 21 del CFF"]
["Articulo 17-A del CFF"]

{"sheet":"INPC","index":3,"n_rows":56,"n_cols":30,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,0,1,2],[1,3,1,5]]}
[" "]
["Indice Nacional del Precios al Consumidor",null,null,"INPC Base = 2a Quincena Diciembre de 2010",null,null,"Regresar al Menú de Cálculo"]
[]
["Año","Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre",null,null,"Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre"]
[]
[1969,1.5434126596E-2,1.5489521629000001E-2,1.5504809914E-2,1.5546833732E-2,1.5546833732E-2,1.5602235662000001E-2,1.5661457938000001E-2,1.5678656395999999E-2,1.5825753553000001E-2,1.5991959342000001E-2,1.5993869514999998E-2,1.6114224242E-2]
[1970,1.6236489141999998E-2,1.6234578969000001E-2,1.6282340204E-2,1.6303352112999998E-2,1.6337742132999999E-2,1.6437084950999999E-2,1.6517319137000001E-2,1.6593732975999999E-2,1.6633853516999999E-2,1.6639584036999999E-2,1.6729375987E-2,1.6870742623E-2]
[1971,1.7036948412E-2,1.710763173E-2,1.7172584527E-2,1.7260466302999999E-2,1.7296766496999998E-2,1.7375090509000001E-2,1.7361719293999999E-2,1.7520277492000001E-2,1.7577589594999998E-2,1.7594788053E-2,1.7623440657E-2,1.7707502085999999E-2]
[1972,1.7785826098000002E-2,1.7841228027999999E-2,1.7938660671999999E-2,1.8051374703999999E-2,1.8087668001999999E-2,1.8221393943999999E-2,1.8290173983999999E-2,1.8410528711000001E-2,1.8494583243999999E-2,1.8507954459000001E-2,1.8628309185999999E-2,1.8691358706E-2]
[1973,1.8962630937E-2,1.9119285856999998E-2,1.9287401818999999E-2,1.9593064069999999E-2,1.9801300572999999E-2,1.9963679118E-2,2.0475667699E-2,2.0804258929000001E-2,2.1299049051E-2,2.1572238351E-2,2.1837786957000001E-2,2.2686000564999999E-2]
[1974,2.3497920876E-2,2.4029011191999999E-2,2.4214325612000001E-2,2.4542909945999999E-2,2.4735865060000001E-2,2.4980394861E-2,2.5341459042000001E-2,2.5608917820999999E-2,2.5899298684E-2,2.6413190542E-2,2.7146786839999999E-2,2.7358843689999999E-2]
[1975,2.7708446828999998E-2,2.7861274506000001E-2,2.8037031162999999E-2,2.8273920269E-2,2.8652182908E-2,2.9139332335999999E-2,2.9372401095E-2,2.9626488659999999E-2,2.9842358961000001E-2,2.9995193534E-2,3.0205340210999999E-2,3.0451780184999999E-2]
[1976,3.1040182603999999E-2,3.1620944328999999E-2,3.1930426927000002E-2,3.2153944818999997E-2,3.2379372884000002E-2,3.2509278478000003E-2,3.2784377952000003E-2,3.3097680897999998E-2,3.4226731396E-2,3.6154324095000002E-2,3.7787715584000001E-2,3.8735272010000002E-2]
[1977,3.9969395847000003E-2,4.0851999476000003E-2,4.1564576968999997E-2,4.2193099929E-2,4.2563714976999997E-2,4.3085254424999997E-2,4.3572410749E-2,4.4466475419E-2,4.5255473647E-2,4.5601256439000003E-2,4.6099866907999998E-2,4.6737940736000003E-2]
[1978,4.7777199286000001E-2,4.8463034348999998E-2,4.8967375339000002E-2,4.9511843765999999E-2,4.9997083019999999E-2,5.0684828256999999E-2,5.1544509803000002E-2,5.2058408556000003E-2,5.2652541496000002E-2,5.3290615324E-2,5.3838897201999997E-2,5.4295483853000003E-2]
[1979,5.6223076551999998E-2,5.7031176514999997E-2,5.7804886457999999E-2,5.8322605559999997E-2,5.9086771530999997E-2,5.9742036920999997E-2,6.0466075454999997E-2,6.1381158930999997E-2,6.2133856964999998E-2,6.3218966574999994E-2,6.4032797059999993E-2,6.5165661010000001E-2]
[1980,6.8342658934000003E-2,6.9922558667000007E-2,7.1361091764000004E-2,7.2608579919999999E-2,7.3793032349000004E-2,7.5256397702000002E-2,7.7357836883999997E-2,7.8960658700000005E-2,7.9837538703000005E-2,8.1046816492000004E-2,8.2452876639E-2,8.4615448270000004E-2]
[1981,8.7341590063999996E-2,8.9486970134000005E-2,9.1401184721000006E-2,9.3462510257999995E-2,9.4876204202000006E-2,9.6202023267000003E-2,9.7896547205999995E-2,9.9913931853999993E-2,0.101772751408,0.10403084551,0.106032941874,0.108887079089]
[1982,0.114297331963,0.118788687911,0.123127202389,0.12980023170300001,0.13709605345699999,0.14370030273100001,0.151105018171,0.16806172550000001,0.17703296945800001,0.18621053284899999,0.19562498534600001,0.21651520898099999]
[1983,0.240074262308,0.25295800376499999,0.26520176122099998,0.28199226276299999,0.29422264900400003,0.30536410528699998,0.32046199306299999,0.33290060891099998,0.34314609035100002,0.35453206953900002,0.37535352692500001,0.391412349238]
[1984,0.41627811989300001,0.43824772261799999,0.45697919496900002,0.47674801569500003,0.49255657768599997,0.51038252432499998,0.52711381048600003,0.54209707405499996,0.55824568831800003,0.57775087750800003,0.59757892051100003,0.62295858991999997]
[1985,0.669169260687,0.69696940274300001,0.72397673311999999,0.74625390827000004,0.76393275085699996,0.78306540792900003,0.81033636984299995,0.84576283505600003,0.87954062049600001,0.91295161123500002,0.95507211077599996,1.0200906746289999]
[1986,1.1102768510409999,1.159637770407,1.213537800059,1.276894312924,1.347852309793,1.434370511609,1.505939839876,1.626004668547,1.7235497093359999,1.822069042086,1.9451714122179999,2.0988229951799999]
[1987,2.2687626488660002,2.432470571604,2.5932250212049999,2.8201194306719999,3.032724052326,3.2521201478489998,3.515516574376,3.8028388558269999,4.0533687462500003,4.391158068587,4.7394679649410003,5.4394787294929996]
[1988,6.2805515298629997,6.8043966403010003,7.1528364491460001,7.3729947935700002,7.5156481970579998,7.6689711887899996,7.7969775537370003,7.8687073503749998,7.9136934550699998,7.9740563673600002,8.0807694137770003,8.2493717873569992]
[1989,8.4513125512889999,8.5660015171050006,8.6588622537289996,8.7883530028340004,8.9093176335909998,9.0175188776180004,9.1077203354179996,9.1944888044519999,9.2824226172830002,9.4197039782639997,9.5519246895110008,9.8742875328420006]
[1990,10.350838773075999,10.585225779758,10.771835580257999,10.935778488824999,11.126616006840999,11.371676415217999,11.579059911870001,11.776352671829001,11.944221449111,12.115933957645,12.437616696434,12.829619358264001]
[1991,13.156630205568,13.386308075828,13.577210546641,13.719437933150999,13.853553757248999,13.998919931316999,14.1226298125,14.220917993559,14.362585630253999,14.529631026183999,14.890406287712,15.240897864329]
[1992,15.517902070849001,15.701758987125,15.861556329433,16.002952687000001,16.108466006495998,16.217494452221999,16.319893816415998,16.420153531063001,16.562988421728001,16.682252798025001,16.820858067896999,17.060370670215999]
[1993,17.274369884079,17.415502610111002,17.516998351872001,17.618012674726,17.718721335329001,17.818102266693,17.903728314013001,17.999553984815002,18.132863626020001,18.207023453070001,18.287329032569001,18.426767234662002]
[1994,18.569623144131999,18.665129781468,18.761104466496,18.852987077021002,18.944076868970001,19.03886901864,19.123304889905999,19.212436519484001,19.349075986290998,19.450651969134,19.554633143235002,19.726139318544]
[1995,20.468620185776,21.336132926013999,22.593921331191002,24.39428249881,25.413863095033001,26.220434064532,26.754964051499002,27.198750022412,27.761362884707001,28.332572548668001,29.031205912573,29.977045058028999]
[1996,31.054701826733002,31.779507671726002,32.479096225855997,33.402392654452001,34.011237206319002,34.565062228903997,35.056417169494999,35.522363781178001,36.090325763896999,36.540798135339998,37.094432119879002,38.282127940254]
[1997,39.266557170736,39.926409411569999,40.423304503734002,40.860021998028003,41.232932116431002,41.598773765110998,41.961176680710999,42.334277844055002,42.861548309462002,43.204083068415002,43.687414321475003,44.299506554585001]
[1998,45.263303462448,46.055737478708998,46.595234496217998,47.031187831436,47.405817312930999,47.966137697999002,48.428645590395,48.894210125988998,49.687217256384002,50.399223414452003,51.291762400612001,52.543265583085997]
[1999,53.870120615833002,54.594080220393998,55.101291477316003,55.606974416086999,55.941485494403999,56.309046499278999,56.681192465503003,57.000229296683997,57.550997682965999,57.915502044644001,58.430545944156997,59.015892575148001,null,{"$f":"IF(SUM(B36:M36)=0,0,IF(M36=0,\"*\",IF(B37=0,\"*\",\"@\")))","v":"@"}]
[2000,59.808326584512997,60.338844724266004,60.673355802583004,61.018565121747997,61.246666912621997,61.609451911207998,61.849780261079999,62.189640459821,62.643933633536001,63.07530200051,63.614607979973997,64.303307262108007,null,"@"]
[2001,64.659787943149993,64.616994979759994,65.026393744008999,65.354409466736996,65.504375883541002,65.659309337783995,65.488710598360001,65.876712887810001,66.489951356085001,66.790457310723994,67.042057015577996,67.134902470813003,null,"@"]
[2002,67.754636301573001,67.711079179107998,68.057434733438001,68.429198616676004,68.567893678497995,68.902213711873998,69.100011723086993,69.362746788218999,69.779950763035004,70.087509395709006,70.654355126781994,70.961913759455996,null,"@"]
[2003,71.248784591725993,71.446697882259002,71.897691931067996,72.020439546798997,71.788046588927003,71.847351616751993,71.951480212118994,72.167322929668003,72.596939584726996,72.863122616593003,73.46789598174,73.783729734575999,null,"@"]
[2004,74.2423093102,74.686407425541006,74.939488183818,75.052581492694003,74.864322509016006,74.984311751359996,75.180845855198996,75.644942177597997,76.270403343148999,76.798631846800006,77.453745526263006,77.613731182722006,null,"@"]
[2005,77.616489556109002,77.875087061160002,78.226090074683,78.504685786791995,78.307462089606005,78.232296414803997,78.538475860784999,78.632260555949998,78.947404715439006,79.141180445890996,79.710784550350994,80.200395826581001,null,{"$f":"IF(SUM(B42:M42)=0,0,IF(M42=0,\"*\",IF(B43=0,\"*\",\"@\")))","v":"@"},{"$f":"IF(B42=0,0,IF(C42=0,1,0))","v":0},{"$f":"IF(C42=0,0,IF(D42=0,2,0))","v":0},{"$f":"IF(D42=0,0,IF(E42=0,3,0))","v":0},{"$f":"IF(E42=0,0,IF(F42=0,4,0))","v":0},{"$f":"IF(F42=0,0,IF(G42=0,5,0))","v":0},{"$f":"IF(G42=0,0,IF(H42=0,6,0))","v":0},{"$f":"IF(H42=0,0,IF(I42=0,7,0))","v":0},{"$f":"IF(I42=0,0,IF(J42=0,8,0))","v":0},{"$f":"IF(J42=0,0,IF(K42=0,9,0))","v":0},{"$f":"IF(K42=0,0,IF(L42=0,10,0))","v":0},{"$f":"IF(L42=0,0,IF(M42=0,11,0))","v":0},{"$f":"IF(M42=0,0,IF(B43=0,12,0))","v":0},null,{"$f":"IF(O42=0,0,SUM(P42:AA42))","v":0},{"$f":"IF(O42=\"*\",A42,0)","v":0}]
[2006,80.670698489100999,80.794135698179005,80.895505920158996,81.014115975809005,80.653458655430995,80.723107583458003,80.944467047781998,81.357533462516997,82.178839138559994,82.538117272245003,82.971181894037002,83.451138863411998,null,{"$f":"IF(SUM(B43:M43)=0,0,IF(M43=0,\"*\",IF(B44=0,\"*\",\"@\")))","v":"@"},{"$f":"IF(B43=0,0,IF(C43=0,1,0))","v":0},{"$f":"IF(C43=0,0,IF(D43=0,2,0))","v":0},{"$f":"IF(D43=0,0,IF(E43=0,3,0))","v":0},{"$f":"IF(E43=0,0,IF(F43=0,4,0))","v":0},{"$f":"IF(F43=0,0,IF(G43=0,5,0))","v":0},{"$f":"IF(G43=0,0,IF(H43=0,6,0))","v":0},{"$f":"IF(H43=0,0,IF(I43=0,7,0))","v":0},{"$f":"IF(I43=0,0,IF(J43=0,8,0))","v":0},{"$f":"IF(J43=0,0,IF(K43=0,9,0))","v":0},{"$f":"IF(K43=0,0,IF(L43=0,10,0))","v":0},{"$f":"IF(L43=0,0,IF(M43=0,11,0))","v":0},{"$f":"IF(M43=0,0,IF(B44=0,12,0))","v":0},null,{"$f":"IF(O43=0,0,SUM(P43:AA43))","v":0},{"$f":"IF(O43=\"*\",A43,0)","v":0}]
[2007,83.882134705164006,84.116596443077995,84.298649086634001,84.248308772317003,83.837311137621995,83.937991766254996,84.294511526552995,84.637929013261001,85.295111472765001,85.627495465924,86.231579237724006,86.588098998020996,null,{"$f":"IF(SUM(B44:M44)=0,0,IF(M44=0,\"*\",IF(B45=0,\"*\",\"@\")))","v":"@"},{"$f":"IF(B44=0,0,IF(C44=0,1,0))","v":0},{"$f":"IF(C44=0,0,IF(D44=0,2,0))","v":0},{"$f":"IF(D44=0,0,IF(E44=0,3,0))","v":0},{"$f":"IF(E44=0,0,IF(F44=0,4,0))","v":0},{"$f":"IF(F44=0,0,IF(G44=0,5,0))","v":0},{"$f":"IF(G44=0,0,IF(H44=0,6,0))","v":0},{"$f":"IF(H44=0,0,IF(I44=0,7,0))","v":0},{"$f":"IF(I44=0,0,IF(J44=0,8,0))","v":0},{"$f":"IF(J44=0,0,IF(K44=0,9,0))","v":0},{"$f":"IF(K44=0,0,IF(L44=0,10,0))","v":0},{"$f":"IF(L44=0,0,IF(M44=0,11,0))","v":0},{"$f":"IF(M44=0,0,IF(B45=0,12,0))","v":0},null,{"$f":"IF(O44=0,0,SUM(P44:AA44))","v":0},{"$f":"IF(O44=\"*\",A44,0)","v":0}]
[2008,86.989442325859997,87.248039830912006,87.880396929930001,88.080379000503001,87.985215118645002,88.349320405756998,88.841690055374002,89.354747505396006,89.963658430622999,90.576706915931993,91.606269782709006,92.240695661768001,null,{"$f":"IF(SUM(B45:M45)=0,0,IF(M45=0,\"*\",IF(B46=0,\"*\",\"@\")))","v":"@"},{"$f":"IF(B45=0,0,IF(C45=0,1,0))","v":0},{"$f":"IF(C45=0,0,IF(D45=0,2,0))","v":0},{"$f":"IF(D45=0,0,IF(E45=0,3,0))","v":0},{"$f":"IF(E45=0,0,IF(F45=0,4,0))","v":0},{"$f":"IF(F45=0,0,IF(G45=0,5,0))","v":0},{"$f":"IF(G45=0,0,IF(H45=0,6,0))","v":0},{"$f":"IF(H45=0,0,IF(I45=0,7,0))","v":0},{"$f":"IF(I45=0,0,IF(J45=0,8,0))","v":0},{"$f":"IF(J45=0,0,IF(K45=0,9,0))","v":0},{"$f":"IF(K45=0,0,IF(L45=0,10,0))","v":0},{"$f":"IF(L45=0,0,IF(M45=0,11,0))","v":0},{"$f":"IF(M45=0,0,IF(B46=0,12,0))","v":0},null,{"$f":"IF(O45=0,0,SUM(P45:AA45))","v":0},{"$f":"IF(O45=\"*\",A45,0)","v":0}]
[2009,92.454469599277004,92.658589229930996,93.19164488701,93.517822540048002,93.245433168060998,93.417141911415001,93.671601856384996,93.895719694096002,94.366711949963005,94.652203595540001,95.143194058464005,95.536951859487999,null,{"$f":"IF(SUM(B46:M46)=0,0,IF(M46=0,\"*\",IF(B47=0,\"*\",\"@\")))","v":"@"},{"$f":"IF(B46=0,0,IF(C46=0,1,0))","v":0},{"$f":"IF(C46=0,0,IF(D46=0,2,0))","v":0},{"$f":"IF(D46=0,0,IF(E46=0,3,0))","v":0},{"$f":"IF(E46=0,0,IF(F46=0,4,0))","v":0},{"$f":"IF(F46=0,0,IF(G46=0,5,0))","v":0},{"$f":"IF(G46=0,0,IF(H46=0,6,0))","v":0},{"$f":"IF(H46=0,0,IF(I46=0,7,0))","v":0},{"$f":"IF(I46=0,0,IF(J46=0,8,0))","v":0},{"$f":"IF(J46=0,0,IF(K46=0,9,0))","v":0},{"$f":"IF(K46=0,0,IF(L46=0,10,0))","v":0},{"$f":"IF(L46=0,0,IF(M46=0,11,0))","v":0},{"$f":"IF(M46=0,0,IF(B47=0,12,0))","v":0},null,{"$f":"IF(O46=0,0,SUM(P46:AA46))","v":0},{"$f":"IF(O46=\"*\",A46,0)","v":0}]
[2010,96.575479439774,97.134050050685005,97.823643397488993,97.511947204733005,96.897519532732005,96.867177425471994,97.077503396246996,97.347134394847004,97.857433471481997,98.461517243282003,99.250412032024997,99.742092088296005,null,{"$f":"IF(SUM(B47:M47)=0,0,IF(M47=0,\"*\",IF(B48=0,\"*\",\"@\")))","v":"@"},{"$f":"IF(B47=0,0,IF(C47=0,1,0))","v":0},{"$f":"IF(C47=0,0,IF(D47=0,2,0))","v":0},{"$f":"IF(D47=0,0,IF(E47=0,3,0))","v":0},{"$f":"IF(E47=0,0,IF(F47=0,4,0))","v":0},{"$f":"IF(F47=0,0,IF(G47=0,5,0))","v":0},{"$f":"IF(G47=0,0,IF(H47=0,6,0))","v":0},{"$f":"IF(H47=0,0,IF(I47=0,7,0))","v":0},{"$f":"IF(I47=0,0,IF(J47=0,8,0))","v":0},{"$f":"IF(J47=0,0,IF(K47=0,9,0))","v":0},{"$f":"IF(K47=0,0,IF(L47=0,10,0))","v":0},{"$f":"IF(L47=0,0,IF(M47=0,11,0))","v":0},{"$f":"IF(M47=0,0,IF(B48=0,12,0))","v":0},null,{"$f":"IF(O47=0,0,SUM(P47:AA47))","v":0},{"$f":"IF(O47=\"*\",A47,0)","v":0}]
[2011,100.22799999999999,100.604,100.797,100.789,100.04600000000001,100.041,100.521,100.68,100.92700000000001,101.608,102.70699999999999,103.551,null,"@",0,0,0,0,0,0,0,0,0,0,0,0,null,0,0]
[2012,104.28400000000001,104.496,104.556,104.22799999999999,103.899,104.378,104.964,105.279,105.74299999999999,106.27800000000001,107,107.246,null,"@",0,0,0,0,0,0,0,0,0,0,0,0,null,0,0]
[2013,107.678,108.208,109.002,109.074,108.711,108.645,108.60899999999999,108.91800000000001,109.328,109.848,110.872,111.508,null,"*",0,0,0,0,0,0,0,0,0,0,0,12,null,12,2013]
[2014,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(SUM(B51:M51)=0,0,IF(M51=0,\"*\",IF(B52=0,\"*\",\"@\")))","v":0},{"$f":"IF(B51=0,0,IF(C51=0,1,0))","v":0},{"$f":"IF(C51=0,0,IF(D51=0,2,0))","v":0},{"$f":"IF(D51=0,0,IF(E51=0,3,0))","v":0},{"$f":"IF(E51=0,0,IF(F51=0,4,0))","v":0},{"$f":"IF(F51=0,0,IF(G51=0,5,0))","v":0},{"$f":"IF(G51=0,0,IF(H51=0,6,0))","v":0},{"$f":"IF(H51=0,0,IF(I51=0,7,0))","v":0},{"$f":"IF(I51=0,0,IF(J51=0,8,0))","v":0},{"$f":"IF(J51=0,0,IF(K51=0,9,0))","v":0},{"$f":"IF(K51=0,0,IF(L51=0,10,0))","v":0},{"$f":"IF(L51=0,0,IF(M51=0,11,0))","v":0},{"$f":"IF(M51=0,0,IF(B52=0,12,0))","v":0},null,{"$f":"IF(O51=0,0,SUM(P51:AA51))","v":0},{"$f":"IF(O51=\"*\",A51,0)","v":0}]
[]
[null,null,null,null,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(AC42:AC51)","v":12},{"$f":"SUM(AD42:AD51)","v":2013}]
[]
[]
[null,null,null,null,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":"CONCATENATE(\"INPC: \",VLOOKUP(AC53,Meses,2),\" de \",AD53)","v":"INPC: Diciembre de 2013"}]

{"sheet":"Recargos","index":4,"n_rows":223,"n_cols":27,"rows_kept":223,"cut":false,"hidden":false,"merged":[]}
["Año","Mes","Mes",null,"Recargos",null,null,null,"Para PP",null,null,{"$f":"Calcular!I12","v":1},{"$f":"Calcular!I13","v":2013},{"$f":"CONCATENATE(TEXT(M1,0),RIGHT(\"00\"&TEXT(L1,0),2))","v":"201301"},null,null,null,null,null,null,null,null,{"$f":"Ejercicio!I12","v":2},{"$f":"Ejercicio!I13","v":2013},{"$f":"CONCATENATE(TEXT(X1,0),RIGHT(\"00\"&TEXT(W1+1,0),2))","v":"201303"}]
[null,null,null,null,null,null,null,null,0,null,{"$f":"Calcular!I17","v":15},{"$f":"Calcular!I18","v":5},{"$f":"Calcular!I19","v":2013},{"$f":"IF(K2>17,CONCATENATE(TEXT(M2,0),RIGHT(\"00\"&TEXT(L2,0),2)),IF(L2=1,CONCATENATE(TEXT(M2-1,0),TEXT(12,0)),CONCATENATE(TEXT(M2,0),RIGHT(\"00\"&TEXT(L2-1,0),2))))","v":"201304"},null,null,null,null,null,null,null,null,{"$f":"Ejercicio!I18","v":1},{"$f":"Ejercicio!I19","v":2014},{"$f":"CONCATENATE(TEXT(X2,0),RIGHT(\"00\"&TEXT(W2,0),2))","v":"201401"},null,0]
[1998,1,{"$f":"VLOOKUP(B3,Meses,2)","v":"Enero"},{"$f":"+CONCATENATE(TEXT(A3,0),RIGHT(\"00\"&TEXT(B3,0),2))","v":"199801"},2.48,null,null,3,{"$f":"IF($N$2<$N$1,0,IF(I2=0,IF(D3=$N$1,E3,0),IF(D3>$N$2,0,E3)))","v":0},null,null,null,null,null,null,null,null,{"$f":"H3","v":3},{"$f":"D3","v":"199801"},{"$f":"E3","v":2.48},null,null,null,null,null,null,{"$f":"IF(AA2=0,IF(D3=$Y$1,E3,0),IF(D3>$Y$2,0,E3))","v":0}]
[1998,2,"Febrero",{"$f":"+CONCATENATE(TEXT(A4,0),RIGHT(\"00\"&TEXT(B4,0),2))","v":"199802"},1.74,null,null,{"$f":"H3+1","v":4},0,null,null,null,null,null,null,null,null,{"$f":"H4","v":4},{"$f":"D4","v":"199802"},{"$f":"E4","v":1.74},null,null,null,null,null,null,{"$f":"IF(AA3=0,IF(D4=$Y$1,E4,0),IF(D4>$Y$2,0,E4))","v":0}]
[1998,3,"Marzo","199803",0.44,null,null,{"$f":"H4+1","v":5},0,null,null,null,null,null,null,null,null,5,"199803",0.44,null,null,null,null,null,null,0]
[1998,4,"Abril","199804",1.22,null,null,6,0,null,null,null,null,null,null,null,null,6,"199804",1.22,null,null,null,null,null,null,0]
[1998,5,"Mayo","199805",2.31,null,null,7,0,null,null,null,null,null,1,"Enero",null,7,"199805",2.31,null,null,null,null,null,null,0]
[1998,6,"Junio","199806",2.4500000000000002,null,null,8,0,null,null,null,null,null,2,"Febrero",null,8,"199806",2.4500000000000002,null,null,null,null,null,null,0]
[1998,7,"Julio","199807",2.54,null,null,9,0,null,null,null,null,null,3,"Marzo",null,9,"199807",2.54,null,null,null,null,null,null,0]
[1998,8,"Agosto","199808",2.25,null,null,10,0,null,null,null,null,null,4,"Abril",null,10,"199808",2.25,null,null,null,null,null,null,0]
[1998,9,"Septiembre","199809",2.66,null,null,11,0,null,null,null,null,null,5,"Mayo",null,11,"199809",2.66,null,null,null,null,null,null,0]
[1998,10,"Octubre","199810",3,null,null,12,0,null,null,null,null,null,6,"Junio",null,12,"199810",3,null,null,null,null,null,null,0]
[1998,11,"Noviembre","199811",3,null,null,13,0,null,null,null,null,null,7,"Julio",null,13,"199811",3,null,null,null,null,null,null,0]
[1998,12,"Diciembre","199812",3,null,null,14,0,null,null,null,null,null,8,"Agosto",null,14,"199812",3,null,null,null,null,null,null,0]
[1999,1,"Enero","199901",3,null,null,15,0,null,null,null,null,null,9,"Septiembre",null,15,"199901",3,null,null,null,null,null,null,0]
[1999,2,"Febrero","199902",3,null,null,16,0,null,null,null,null,null,10,"Octubre",null,16,"199902",3,null,null,null,null,null,null,0]
[1999,3,"Marzo","199903",2.92,null,null,17,0,null,null,null,null,null,11,"Noviembre",null,17,"199903",2.92,null,null,null,null,null,null,0]
[1999,4,"Abril","199904",3,null,null,18,0,null,null,null,null,null,12,"Diciembre",null,18,"199904",3,null,null,null,null,null,null,0]
[1999,5,"Mayo","199905",3,null,null,19,0,null,null,null,null,null,null,null,null,19,"199905",3,null,null,null,null,null,null,0]
[1999,6,"Junio","199906",2.85,null,null,20,0,null,null,null,null,null,null,null,null,20,"199906",2.85,null,null,null,null,null,null,0]
[1999,7,"Julio","199907",3,null,null,21,0,null,null,null,null,null,null,null,null,21,"199907",3,null,null,null,null,null,null,0]
[1999,8,"Agosto","199908",3,null,null,22,0,null,null,null,null,null,null,null,null,22,"199908",3,null,null,null,null,null,null,0]
[1999,9,"Septiembre","199909",3,null,null,23,0,null,null,null,null,null,null,null,null,23,"199909",3,null,null,null,null,null,null,0]
[1999,10,"Octubre","199910",3,null,null,24,0,null,null,null,null,null,null,null,null,24,"199910",3,null,null,null,null,null,null,0]
[1999,11,"Noviembre","199911",2.7,null,null,25,0,null,null,null,null,null,null,null,null,25,"199911",2.7,null,null,null,null,null,null,0]
[1999,12,"Diciembre","199912",2.92,null,null,26,0,null,null,null,null,null,null,null,null,26,"199912",2.92,null,null,null,null,null,null,0]
[2000,1,"Enero","200001",2.23,null,null,27,0,null,null,null,null,null,null,null,null,27,"200001",2.23,null,null,null,null,null,null,0]
[2000,2,"Febrero","200002",2.0099999999999998,null,null,28,0,null,null,null,null,null,null,null,null,28,"200002",2.0099999999999998,null,null,null,null,null,null,0]
[2000,3,"Marzo","200003",1.47,null,null,29,0,null,null,null,null,null,null,null,null,29,"200003",1.47,null,null,null,null,null,null,0]
[2000,4,"Abril","200004",2.0699999999999998,null,null,30,0,null,null,null,null,null,null,null,null,30,"200004",2.0699999999999998,null,null,null,null,null,null,0]
[2000,5,"Mayo","200005",2.15,null,null,31,0,null,null,null,null,null,null,null,null,31,"200005",2.15,null,null,null,null,null,null,0]
[2000,6,"Junio","200006",2,null,null,32,0,null,null,null,null,null,null,null,null,32,"200006",2,null,null,null,null,null,null,0]
[2000,7,"Julio","200007",2.4300000000000002,null,null,33,0,null,null,null,null,null,null,null,null,33,"200007",2.4300000000000002,null,null,null,null,null,null,0]
[2000,8,"Agosto","200008",2.39,null,null,34,0,null,null,null,null,null,null,null,null,34,"200008",2.39,null,null,null,null,null,null,0]
[2000,9,{"$f":"VLOOKUP(B35,Meses,2)","v":"Septiembre"},"200009",2.31,null,null,35,{"$f":"IF($N$2<$N$1,0,IF(I34=0,IF(D35=$N$1,E35,0),IF(D35>$N$2,0,E35)))","v":0},null,null,null,null,null,null,null,null,35,"200009",2.31,null,null,null,null,null,null,0]
[2000,10,"Octubre","200010",2.2999999999999998,null,null,36,0,null,null,null,null,null,null,null,null,36,"200010",2.2999999999999998,null,null,null,null,null,null,0]
[2000,11,"Noviembre","200011",2.06,null,null,37,0,null,null,null,null,null,null,null,null,37,"200011",2.06,null,null,null,null,null,null,0]
[2000,12,"Diciembre","200012",2.2200000000000002,null,null,38,0,null,null,null,null,null,null,null,null,38,"200012",2.2200000000000002,null,null,null,null,null,null,0]
[2001,1,"Enero","200101",2.2200000000000002,null,null,39,0,null,null,null,null,null,null,null,null,39,"200101",2.2200000000000002,null,null,null,null,null,null,0]
[2001,2,"Febrero","200102",1.83,null,null,40,0,null,null,null,null,null,null,null,null,40,"200102",1.83,null,null,null,null,null,null,0]
[2001,3,"Marzo","200103",2.66,null,null,41,0,null,null,null,null,null,null,null,null,41,"200103",2.66,null,null,null,null,null,null,0]
[2001,4,"Abril","200104",3,null,null,42,0,null,null,null,null,null,null,null,null,42,"200104",3,null,null,null,null,null,null,0]
[2001,5,"Mayo","200105",2.2999999999999998,null,null,43,0,null,null,null,null,null,null,null,null,43,"200105",2.2999999999999998,null,null,null,null,null,null,0]
[2001,6,"Junio","200106",2.31,null,null,44,0,null,null,null,null,null,null,null,null,44,"200106",2.31,null,null,null,null,null,null,0]
[2001,7,"Julio","200107",2.42,null,null,45,0,null,null,null,null,null,null,null,null,45,"200107",2.42,null,null,null,null,null,null,0]
[2001,8,"Agosto","200108",2.1,null,null,46,0,null,null,null,null,null,null,null,null,46,"200108",2.1,null,null,null,null,null,null,0]
[2001,9,"Septiembre","200109",2.78,null,null,47,0,null,null,null,null,null,null,null,null,47,"200109",2.78,null,null,null,null,null,null,0]
[2001,10,"Octubre","200110",1.28,null,null,48,0,null,null,null,null,null,null,null,null,48,"200110",1.28,null,null,null,null,null,null,0]
[2001,11,"Noviembre","200111",0.98,null,null,49,0,null,null,null,null,null,null,null,null,49,"200111",0.98,null,null,null,null,null,null,0]
[2001,12,"Diciembre","200112",1.62,null,null,50,0,null,null,null,null,null,null,null,null,50,"200112",1.62,null,null,null,null,null,null,0]
[2002,1,"Enero","200201",1.55,null,null,51,0,null,null,null,null,null,null,null,null,51,"200201",1.55,null,null,null,null,null,null,0]
[2002,2,"Febrero","200202",1.79,null,null,52,0,null,null,null,null,null,null,null,null,52,"200202",1.79,null,null,null,null,null,null,0]
[2002,3,"Marzo","200203",0.62,null,null,53,0,null,null,null,null,null,null,null,null,53,"200203",0.62,null,null,null,null,null,null,0]
[2002,4,"Abril","200204",2.2200000000000002,null,null,54,0,null,null,null,null,null,null,null,null,54,"200204",2.2200000000000002,null,null,null,null,null,null,0]
[2002,5,"Mayo","200205",1.29,null,null,55,0,null,null,null,null,null,null,null,null,55,"200205",1.29,null,null,null,null,null,null,0]
[2002,6,"Junio","200206",1.04,null,null,56,0,null,null,null,null,null,null,null,null,56,"200206",1.04,null,null,null,null,null,null,0]
[2002,7,"Julio","200207",1.67,null,null,57,0,null,null,null,null,null,null,null,null,57,"200207",1.67,null,null,null,null,null,null,0]
[2002,8,"Agosto","200208",1.32,null,null,58,0,null,null,null,null,null,null,null,null,58,"200208",1.32,null,null,null,null,null,null,0]
[2002,9,"Septiembre","200209",1.61,null,null,59,0,null,null,null,null,null,null,null,null,59,"200209",1.61,null,null,null,null,null,null,0]
[2002,10,"Octubre","200210",1.38,null,null,60,0,null,null,null,null,null,null,null,null,60,"200210",1.38,null,null,null,null,null,null,0]
[2002,11,"Noviembre","200211",1.1399999999999999,null,null,61,0,null,null,null,null,null,null,null,null,61,"200211",1.1399999999999999,null,null,null,null,null,null,0]
[2002,12,"Diciembre","200212",1.43,null,null,62,0,null,null,null,null,null,null,null,null,62,"200212",1.43,null,null,null,null,null,null,0]
[2003,1,"Enero","200301",2.0099999999999998,null,null,63,0,null,null,null,null,null,null,null,null,63,"200301",2.0099999999999998,null,null,null,null,null,null,0]
[2003,2,"Febrero","200302",2.15,null,null,64,0,null,null,null,null,null,null,null,null,64,"200302",2.15,null,null,null,null,null,null,0]
[2003,3,"Marzo","200303",1.94,null,null,65,0,null,null,null,null,null,null,null,null,65,"200303",1.94,null,null,null,null,null,null,0]
[2003,4,"Abril","200304",2.0699999999999998,null,null,66,0,null,null,null,null,null,null,null,null,66,"200304",2.0699999999999998,null,null,null,null,null,null,0]
[2003,5,{"$f":"VLOOKUP(B67,Meses,2)","v":"Mayo"},"200305",2.12,null,null,67,{"$f":"IF($N$2<$N$1,0,IF(I66=0,IF(D67=$N$1,E67,0),IF(D67>$N$2,0,E67)))","v":0},null,null,null,null,null,null,null,null,67,"200305",2.12,null,null,null,null,null,null,0]
[2003,6,"Junio",{"$f":"+CONCATENATE(TEXT(A68,0),RIGHT(\"00\"&TEXT(B68,0),2))","v":"200306"},1.97,null,null,68,0,null,null,null,null,null,null,null,null,{"$f":"H68","v":68},{"$f":"D68","v":"200306"},{"$f":"E68","v":1.97},null,null,null,null,null,null,{"$f":"IF(AA67=0,IF(D68=$Y$1,E68,0),IF(D68>$Y$2,0,E68))","v":0}]
[2003,7,"Julio","200307",1.76,null,null,{"$f":"H68+1","v":69},0,null,null,null,null,null,null,null,null,69,"200307",1.76,null,null,null,null,null,null,0]
[2003,8,"Agosto","200308",1.61,null,null,70,0,null,null,null,null,null,null,null,null,70,"200308",1.61,null,null,null,null,null,null,0]
[2003,9,"Septiembre","200309",1.55,null,null,71,0,null,null,null,null,null,null,null,null,71,"200309",1.55,null,null,null,null,null,null,0]
[2003,10,"Octubre","200310",1.52,null,null,72,0,null,null,null,null,null,null,null,null,72,"200310",1.52,null,null,null,null,null,null,0]
[2003,11,"Noviembre","200311",1.52,null,null,73,0,null,null,null,null,null,null,null,null,73,"200311",1.52,null,null,null,null,null,null,0]
[2003,12,"Diciembre","200312",1.49,null,null,74,0,null,null,null,null,null,null,null,null,74,"200312",1.49,null,null,null,null,null,null,0]
[2004,1,"Enero","200401",1.1299999999999999,null,null,75,0,null,null,null,null,null,null,null,null,75,"200401",1.1299999999999999,null,null,null,null,null,null,0]
[2004,2,"Febrero","200402",1.1299999999999999,null,null,76,0,null,null,null,null,null,null,null,null,76,"200402",1.1299999999999999,null,null,null,null,null,null,0]
[2004,3,"Marzo","200403",1.1299999999999999,null,null,77,0,null,null,null,null,null,null,null,null,77,"200403",1.1299999999999999,null,null,null,null,null,null,0]
[2004,4,"Abril","200404",1.1299999999999999,null,null,78,0,null,null,null,null,null,null,null,null,78,"200404",1.1299999999999999,null,null,null,null,null,null,0]
[2004,5,"Mayo","200405",1.1299999999999999,null,null,79,0,null,null,null,null,null,null,null,null,79,"200405",1.1299999999999999,null,null,null,null,null,null,0]
[2004,6,"Junio","200406",1.1299999999999999,null,null,80,0,null,null,null,null,null,null,null,null,80,"200406",1.1299999999999999,null,null,null,null,null,null,0]
[2004,7,"Julio","200407",1.1299999999999999,null,null,81,0,null,null,null,null,null,null,null,null,81,"200407",1.1299999999999999,null,null,null,null,null,null,0]
[2004,8,"Agosto","200408",1.1299999999999999,null,null,82,0,null,null,null,null,null,null,null,null,82,"200408",1.1299999999999999,null,null,null,null,null,null,0]
[2004,9,"Septiembre","200409",1.1299999999999999,null,null,83,0,null,null,null,null,null,null,null,null,83,"200409",1.1299999999999999,null,null,null,null,null,null,0]
[2004,10,"Octubre","200410",1.1299999999999999,null,null,84,0,null,null,null,null,null,null,null,null,84,"200410",1.1299999999999999,null,null,null,null,null,null,0]
[2004,11,"Noviembre","200411",1.1299999999999999,null,null,85,0,null,null,null,null,null,null,null,null,85,"200411",1.1299999999999999,null,null,null,null,null,null,0]
[2004,12,"Diciembre","200412",1.1299999999999999,null,null,86,0,null,null,null,null,null,null,null,null,86,"200412",1.1299999999999999,null,null,null,null,null,null,0]
[2005,1,"Enero","200501",1.1299999999999999,null,null,87,0,null,null,null,null,null,null,null,null,87,"200501",1.1299999999999999,null,null,null,null,null,null,0]
[2005,2,"Febrero","200502",1.1299999999999999,null,null,88,0,null,null,null,null,null,null,null,null,88,"200502",1.1299999999999999,null,null,null,null,null,null,0]
[2005,3,"Marzo","200503",1.1299999999999999,null,null,89,0,null,null,null,null,null,null,null,null,89,"200503",1.1299999999999999,null,null,null,null,null,null,0]
[2005,4,"Abril","200504",1.1299999999999999,null,null,90,0,null,null,null,null,null,null,null,null,90,"200504",1.1299999999999999,null,null,null,null,null,null,0]
[2005,5,"Mayo","200505",1.1299999999999999,null,null,91,0,null,null,null,null,null,null,null,null,91,"200505",1.1299999999999999,null,null,null,null,null,null,0]
[2005,6,"Junio","200506",1.1299999999999999,null,null,92,0,{"$f":"IF(E92>0,IF(E93=0,B92,0),0)","v":0},{"$f":"IF(J92=0,0,A92)","v":0},null,null,null,null,null,null,92,"200506",1.1299999999999999,null,null,null,null,null,null,0]
[2005,7,"Julio","200507",1.1299999999999999,null,null,93,0,0,0,null,null,null,null,null,null,93,"200507",1.1299999999999999,null,null,null,null,null,null,0]
[2005,8,"Agosto","200508",1.1299999999999999,null,null,94,0,0,0,null,null,null,null,null,null,94,"200508",1.1299999999999999,null,null,null,null,null,null,0]
[2005,9,"Septiembre","200509",1.1299999999999999,"Regresa al Menú Anterior",null,95,0,0,0,null,null,null,null,null,null,95,"200509",1.1299999999999999,null,null,null,null,null,null,0]
[2005,10,"Octubre","200510",1.1299999999999999,null,null,96,0,0,0,null,null,null,null,null,null,96,"200510",1.1299999999999999,null,null,null,null,null,null,0]
[2005,11,"Noviembre","200511",1.1299999999999999,null,null,97,0,0,0,null,null,null,null,null,null,97,"200511",1.1299999999999999,null,null,null,null,null,null,0]
[2005,12,"Diciembre","200512",1.1299999999999999,null,null,98,0,0,0,null,null,null,null,null,null,98,"200512",1.1299999999999999,null,null,null,null,null,null,0]
[2006,1,{"$f":"VLOOKUP(B99,Meses,2)","v":"Enero"},"200601",1.1299999999999999,null,null,99,{"$f":"IF($N$2<$N$1,0,IF(I98=0,IF(D99=$N$1,E99,0),IF(D99>$N$2,0,E99)))","v":0},0,0,null,null,null,null,null,null,99,"200601",1.1299999999999999,null,null,null,null,null,null,0]
[2006,2,"Febrero","200602",1.1299999999999999,null,null,100,0,0,0,null,null,null,null,null,null,100,"200602",1.1299999999999999,null,null,null,null,null,null,0]
[2006,3,"Marzo","200603",1.1299999999999999,null,null,101,0,0,0,null,null,null,null,null,null,101,"200603",1.1299999999999999,null,null,null,null,null,null,0]
[2006,4,"Abril","200604",1.1299999999999999,null,null,102,0,0,0,null,null,null,null,null,null,102,"200604",1.1299999999999999,null,null,null,null,null,null,0]
[2006,5,"Mayo","200605",1.1299999999999999,null,null,103,0,{"$f":"IF(E103>0,IF(E104=0,B103,0),0)","v":0},0,null,null,null,null,null,null,103,"200605",1.1299999999999999,null,null,null,null,null,null,0]
[2006,6,"Junio","200606",1.1299999999999999,null,null,104,0,0,0,null,null,null,null,null,null,104,"200606",1.1299999999999999,null,null,null,null,null,null,0]
[2006,7,"Julio","200607",1.1299999999999999,null,null,105,0,0,0,null,null,null,null,null,null,105,"200607",1.1299999999999999,null,null,null,null,null,null,0]
[2006,8,"Agosto","200608",1.1299999999999999,null,null,106,0,0,0,null,null,null,null,null,null,106,"200608",1.1299999999999999,null,null,null,null,null,null,0]
[2006,9,"Septiembre","200609",1.1299999999999999,null,null,107,0,0,0,null,null,null,null,null,null,107,"200609",1.1299999999999999,null,null,null,null,null,null,0]
[2006,10,"Octubre","200610",1.1299999999999999,null,null,108,0,0,0,null,null,null,null,null,null,108,"200610",1.1299999999999999,null,null,null,null,null,null,0]
[2006,11,"Noviembre","200611",1.1299999999999999,null,null,109,0,0,0,null,null,null,null,null,null,109,"200611",1.1299999999999999,null,null,null,null,null,null,0]
[2006,12,"Diciembre","200612",1.1299999999999999,null,null,110,0,0,0,null,null,null,null,null,null,110,"200612",1.1299999999999999,null,null,null,null,null,null,0]
[2007,1,"Enero","200701",1.1299999999999999,null,null,111,0,0,0,null,null,null,null,null,null,111,"200701",1.1299999999999999,null,null,null,null,null,null,0]
[{"$f":"A111","v":2007},2,"Febrero","200702",1.1299999999999999,null,null,112,0,0,0,null,null,null,null,null,null,112,"200702",1.1299999999999999,null,null,null,null,null,null,0]
[{"$f":"A112","v":2007},3,"Marzo","200703",1.1299999999999999,null,null,113,0,0,0,null,null,null,null,null,null,113,"200703",1.1299999999999999,null,null,null,null,null,null,0]
[2007,4,"Abril","200704",1.1299999999999999,null,null,114,0,0,0,null,null,null,null,null,null,114,"200704",1.1299999999999999,null,null,null,null,null,null,0]
[2007,5,"Mayo","200705",1.1299999999999999,null,null,115,0,0,0,null,null,null,null,null,null,115,"200705",1.1299999999999999,null,null,null,null,null,null,0]
[2007,6,"Junio","200706",1.1299999999999999,null,null,116,0,0,0,null,null,null,null,null,null,116,"200706",1.1299999999999999,null,null,null,null,null,null,0]
[2007,7,"Julio","200707",1.1299999999999999,"Regresa al Menú Anterior",null,117,0,0,0,null,null,null,null,null,null,117,"200707",1.1299999999999999,null,null,null,null,null,null,0]
[2007,8,"Agosto","200708",1.1299999999999999,null,null,118,0,0,0,null,null,null,null,null,null,118,"200708",1.1299999999999999,null,null,null,null,null,null,0]
[2007,9,"Septiembre","200709",1.1299999999999999,null,null,119,0,0,0,null,null,null,null,null,null,119,"200709",1.1299999999999999,null,null,null,null,null,null,0]
[2007,10,"Octubre","200710",1.1299999999999999,null,null,120,0,0,0,null,null,null,null,null,null,120,"200710",1.1299999999999999,null,null,null,null,null,null,0]
[2007,11,"Noviembre","200711",1.1299999999999999,null,null,121,0,0,0,null,null,null,null,null,null,121,"200711",1.1299999999999999,null,null,null,null,null,null,0]
[2007,12,"Diciembre","200712",1.1299999999999999,null,null,122,0,0,0,null,null,null,null,null,null,122,"200712",1.1299999999999999,null,null,null,null,null,null,0]
[2008,1,"Enero","200801",1.1299999999999999,null,null,123,0,0,0,null,null,null,null,null,null,123,"200801",1.1299999999999999,null,null,null,null,null,null,0]
[2008,2,"Febrero","200802",1.1299999999999999,null,null,124,0,0,{"$f":"IF(J124=0,0,A124)","v":0},null,null,null,null,null,null,124,"200802",1.1299999999999999,null,null,null,null,null,null,0]
[2008,3,"Marzo","200803",1.1299999999999999,null,null,125,0,0,0,null,null,null,null,null,null,125,"200803",1.1299999999999999,null,null,null,null,null,null,0]
[2008,4,"Abril","200804",1.1299999999999999,null,null,126,0,0,0,null,null,null,null,null,null,126,"200804",1.1299999999999999,null,null,null,null,null,null,0]
[2008,5,"Mayo","200805",1.1299999999999999,null,null,127,0,0,0,null,null,null,null,null,null,127,"200805",1.1299999999999999,null,null,null,null,null,null,0]
[2008,6,"Junio","200806",1.1299999999999999,null,null,128,0,0,0,null,null,null,null,null,null,128,"200806",1.1299999999999999,null,null,null,null,null,null,0]
[2008,7,"Julio","200807",1.1299999999999999,null,null,129,0,0,0,null,null,null,null,null,null,129,"200807",1.1299999999999999,null,null,null,null,null,null,0]
[2008,8,"Agosto","200808",1.1299999999999999,null,null,130,0,0,0,null,null,null,null,null,null,130,"200808",1.1299999999999999,null,null,null,null,null,null,0]
[2008,9,{"$f":"VLOOKUP(B131,Meses,2)","v":"Septiembre"},"200809",1.1299999999999999,null,null,131,{"$f":"IF($N$2<$N$1,0,IF(I130=0,IF(D131=$N$1,E131,0),IF(D131>$N$2,0,E131)))","v":0},0,0,null,null,null,null,null,null,131,"200809",1.1299999999999999,null,null,null,null,null,null,0]
[2008,10,"Octubre",{"$f":"+CONCATENATE(TEXT(A132,0),RIGHT(\"00\"&TEXT(B132,0),2))","v":"200810"},1.1299999999999999,null,null,132,0,0,0,null,null,null,null,null,null,{"$f":"H132","v":132},{"$f":"D132","v":"200810"},{"$f":"E132","v":1.1299999999999999},null,null,null,null,null,null,{"$f":"IF(AA131=0,IF(D132=$Y$1,E132,0),IF(D132>$Y$2,0,E132))","v":0}]
[2008,11,"Noviembre","200811",1.1299999999999999,null,null,{"$f":"H132+1","v":133},0,0,0,null,null,null,null,null,null,133,"200811",1.1299999999999999,null,null,null,null,null,null,0]
[2008,12,"Diciembre","200812",1.1299999999999999,null,null,134,0,0,0,null,null,null,null,null,null,134,"200812",1.1299999999999999,null,null,null,null,null,null,0]
[2009,1,"Enero","200901",1.1299999999999999,"Regresa al Menú Anterior",null,135,0,0,0,null,null,null,null,null,null,135,"200901",1.1299999999999999,null,null,null,null,null,null,0]
[2009,2,"Febrero","200902",1.1299999999999999,null,null,136,0,0,0,null,null,null,null,null,null,136,"200902",1.1299999999999999,null,null,null,null,null,null,0]
[2009,3,"Marzo","200903",1.1299999999999999,null,null,137,0,0,0,null,null,null,null,null,null,137,"200903",1.1299999999999999,null,null,null,null,null,null,0]
[2009,4,"Abril","200904",1.1299999999999999,null,null,138,0,0,0,null,null,null,null,null,null,138,"200904",1.1299999999999999,null,null,null,null,null,null,0]
[2009,5,"Mayo","200905",1.1299999999999999,null,null,139,0,0,0,null,null,null,null,null,null,139,"200905",1.1299999999999999,null,null,null,null,null,null,0]
[2009,6,"Junio","200906",1.1299999999999999,null,null,140,0,0,0,null,null,null,null,null,null,140,"200906",1.1299999999999999,null,null,null,null,null,null,0]
[2009,7,"Julio","200907",1.1299999999999999,null,null,141,0,0,0,null,null,null,null,null,null,141,"200907",1.1299999999999999,null,null,null,null,null,null,0]
[2009,8,"Agosto","200908",1.1299999999999999,null,null,142,0,0,0,null,null,null,null,null,null,142,"200908",1.1299999999999999,null,null,null,null,null,null,0]
[2009,9,"Septiembre","200909",1.1299999999999999,null,null,143,0,0,0,null,null,null,null,null,null,143,"200909",1.1299999999999999,null,null,null,null,null,null,0]
[2009,10,"Octubre","200910",1.1299999999999999,null,null,144,0,0,0,null,null,null,null,null,null,144,"200910",1.1299999999999999,null,null,null,null,null,null,0]
[2009,11,"Noviembre","200911",1.1299999999999999,null,null,145,0,0,0,null,null,null,null,null,null,145,"200911",1.1299999999999999,null,null,null,null,null,null,0]
[2009,12,"Diciembre","200912",1.1299999999999999,null,null,146,0,0,0,null,null,null,null,null,null,146,"200912",1.1299999999999999,null,null,null,null,null,null,0]
[2010,1,{"$f":"VLOOKUP(B147,Meses,2)","v":"Enero"},{"$f":"+CONCATENATE(TEXT(A147,0),RIGHT(\"00\"&TEXT(B147,0),2))","v":"201001"},1.1299999999999999,null,null,147,{"$f":"IF($N$2<$N$1,0,IF(I146=0,IF(D147=$N$1,E147,0),IF(D147>$N$2,0,E147)))","v":0},{"$f":"IF(E147>0,IF(E148=0,B147,0),0)","v":0},{"$f":"IF(J147=0,0,A147)","v":0},null,null,null,null,null,null,{"$f":"H147","v":147},{"$f":"D147","v":"201001"},{"$f":"E147","v":1.1299999999999999},null,null,null,null,null,null,{"$f":"IF(AA146=0,IF(D147=$Y$1,E147,0),IF(D147>$Y$2,0,E147))","v":0}]
[2010,2,"Febrero","201002",1.1299999999999999,null,null,148,0,0,0,null,null,null,null,null,null,148,"201002",1.1299999999999999,null,null,null,null,null,null,0]
[2010,3,"Marzo","201003",1.1299999999999999,null,null,149,0,0,0,null,null,null,null,null,null,149,"201003",1.1299999999999999,null,null,null,null,null,null,0]
[2010,4,"Abril","201004",1.1299999999999999,null,null,150,0,0,0,null,null,null,null,null,null,150,"201004",1.1299999999999999,null,null,null,null,null,null,0]
[2010,5,"Mayo","201005",1.1299999999999999,null,null,151,0,0,0,null,null,null,null,null,null,151,"201005",1.1299999999999999,null,null,null,null,null,null,0]
[2010,6,"Junio","201006",1.1299999999999999,null,null,152,0,0,0,null,null,null,null,null,null,152,"201006",1.1299999999999999,null,null,null,null,null,null,0]
[2010,7,"Julio","201007",1.1299999999999999,null,null,153,0,0,0,null,null,null,null,null,null,153,"201007",1.1299999999999999,null,null,null,null,null,null,0]
[2010,8,"Agosto","201008",1.1299999999999999,null,null,154,0,0,0,null,null,null,null,null,null,154,"201008",1.1299999999999999,null,null,null,null,null,null,0]
[2010,9,"Septiembre","201009",1.1299999999999999,null,null,155,0,0,0,null,null,null,null,null,null,155,"201009",1.1299999999999999,null,null,null,null,null,null,0]
[2010,10,"Octubre","201010",1.1299999999999999,null,null,156,0,0,0,null,null,null,null,null,null,156,"201010",1.1299999999999999,null,null,null,null,null,null,0]
[2010,11,"Noviembre","201011",1.1299999999999999,null,null,157,0,0,0,null,null,null,null,null,null,157,"201011",1.1299999999999999,null,null,null,null,null,null,0]
[2010,12,"Diciembre","201012",1.1299999999999999,"Regresa al Menú Anterior",null,158,0,0,0,null,null,null,null,null,null,158,"201012",1.1299999999999999,null,null,null,null,null,null,0]
[2011,1,"Enero","201101",1.1299999999999999,null,null,159,0,0,0,null,null,null,null,null,null,159,"201101",1.1299999999999999,null,null,null,null,null,null,0]
[2011,2,"Febrero","201102",1.1299999999999999,null,null,160,0,0,0,null,null,null,null,null,null,160,"201102",1.1299999999999999,null,null,null,null,null,null,0]
[2011,3,"Marzo","201103",1.1299999999999999,null,null,161,0,0,0,null,null,null,null,null,null,161,"201103",1.1299999999999999,null,null,null,null,null,null,0]
[2011,4,"Abril","201104",1.1299999999999999,null,null,162,0,0,0,null,null,null,null,null,null,162,"201104",1.1299999999999999,null,null,null,null,null,null,0]
[2011,5,"Mayo","201105",1.1299999999999999,null,null,163,0,0,0,null,null,null,null,null,null,163,"201105",1.1299999999999999,null,null,null,null,null,null,0]
[2011,6,"Junio","201106",1.1299999999999999,null,null,164,0,0,0,null,null,null,null,null,null,164,"201106",1.1299999999999999,null,null,null,null,null,null,0]
[2011,7,"Julio","201107",1.1299999999999999,null,null,165,0,0,0,null,null,null,null,null,null,165,"201107",1.1299999999999999,null,null,null,null,null,null,0]
[2011,8,"Agosto","201108",1.1299999999999999,null,null,166,0,0,0,null,null,null,null,null,null,166,"201108",1.1299999999999999,null,null,null,null,null,null,0]
[2011,9,"Septiembre","201109",1.1299999999999999,null,null,167,0,0,0,null,null,null,null,null,null,167,"201109",1.1299999999999999,null,null,null,null,null,null,0]
[2011,10,"Octubre","201110",1.1299999999999999,null,null,168,0,0,0,null,null,null,null,null,null,168,"201110",1.1299999999999999,null,null,null,null,null,null,0]
[2011,11,"Noviembre","201111",1.1299999999999999,null,null,169,0,0,0,null,null,null,null,null,null,169,"201111",1.1299999999999999,null,null,null,null,null,null,0]
[2011,12,"Diciembre","201112",1.1299999999999999,null,null,170,0,0,0,null,null,null,null,null,null,170,"201112",1.1299999999999999,null,null,null,null,null,null,0]
[2012,1,"Enero","201201",1.1299999999999999,null,null,171,0,0,0,null,null,null,null,null,null,171,"201201",1.1299999999999999,null,null,null,null,null,null,0]
[2012,2,"Febrero","201202",1.1299999999999999,null,null,172,0,0,0,null,null,null,null,null,null,172,"201202",1.1299999999999999,null,null,null,null,null,null,0]
[2012,3,"Marzo","201203",1.1299999999999999,null,null,173,0,0,0,null,null,null,null,null,null,173,"201203",1.1299999999999999,null,null,null,null,null,null,0]
[2012,4,"Abril","201204",1.1299999999999999,null,null,174,0,0,0,null,null,null,null,null,null,174,"201204",1.1299999999999999,null,null,null,null,null,null,0]
[2012,5,"Mayo","201205",1.1299999999999999,null,null,175,0,0,0,null,null,null,null,null,null,175,"201205",1.1299999999999999,null,null,null,null,null,null,0]
[2012,6,"Junio","201206",1.1299999999999999,null,null,176,0,0,0,null,null,null,null,null,null,176,"201206",1.1299999999999999,null,null,null,null,null,null,0]
[{"$f":"A176","v":2012},7,"Julio","201207",1.1299999999999999,null,null,177,0,0,0,null,null,null,null,null,null,177,"201207",1.1299999999999999,null,null,null,null,null,null,0]
[2012,8,"Agosto","201208",1.1299999999999999,null,null,178,0,0,0,null,null,null,null,null,null,178,"201208",1.1299999999999999,null,null,null,null,null,null,0]
[2012,9,"Septiembre","201209",1.1299999999999999,null,null,179,0,0,0,null,null,null,null,null,null,179,"201209",1.1299999999999999,null,null,null,null,null,null,0]
[2012,10,"Octubre","201210",1.1299999999999999,"Regresa al Menú Anterior",null,180,0,0,0,null,null,null,null,null,null,180,"201210",1.1299999999999999,null,null,null,null,null,null,0]
[2012,11,"Noviembre","201211",1.1299999999999999,null,null,181,0,0,0,null,null,null,null,null,null,181,"201211",1.1299999999999999,null,null,null,null,null,null,0]
[2012,12,"Diciembre","201212",1.1299999999999999,null,null,182,0,0,0,null,null,null,null,null,null,182,"201212",1.1299999999999999,null,null,null,null,null,null,0]
[2013,1,"Enero","201301",1.1299999999999999,null,null,183,1.1299999999999999,0,0,null,null,null,null,null,null,183,"201301",1.1299999999999999,null,null,null,null,null,null,0]
[{"$f":"A183","v":2013},2,"Febrero","201302",1.1299999999999999,null,null,184,1.1299999999999999,0,0,null,null,null,null,null,null,184,"201302",1.1299999999999999,null,null,null,null,null,null,0]
[2013,3,"Marzo","201303",1.1299999999999999,null,null,185,1.1299999999999999,0,0,null,null,null,null,null,null,185,"201303",1.1299999999999999,null,null,null,null,null,null,1.1299999999999999]
[2013,4,"Abril","201304",1.1299999999999999,null,null,186,1.1299999999999999,0,0,null,null,null,null,null,null,186,"201304",1.1299999999999999,null,null,null,null,null,null,1.1299999999999999]
[2013,5,"Mayo","201305",1.1299999999999999,null,null,187,0,0,0,null,null,null,null,null,null,187,"201305",1.1299999999999999,null,null,null,null,null,null,1.1299999999999999]
[2013,6,"Junio","201306",1.1299999999999999,null,null,188,0,0,0,null,null,null,null,null,null,188,"201306",1.1299999999999999,null,null,null,null,null,null,1.1299999999999999]
[2013,7,"Julio","201307",1.1299999999999999,null,null,189,0,0,0,null,null,null,null,null,null,189,"201307",1.1299999999999999,null,null,null,null,null,null,1.1299999999999999]
[2013,8,"Agosto","201308",1.1299999999999999,null,null,190,0,0,0,null,null,null,null,null,null,190,"201308",1.1299999999999999,null,null,null,null,null,null,1.1299999999999999]
[2013,9,"Septiembre","201309",1.1299999999999999,null,null,191,0,0,0,null,null,null,null,null,null,191,"201309",1.1299999999999999,null,null,null,null,null,null,1.1299999999999999]
[2013,10,"Octubre","201310",1.1299999999999999,null,null,192,0,0,0,null,null,null,null,null,null,192,"201310",1.1299999999999999,null,null,null,null,null,null,1.1299999999999999]
[2013,11,"Noviembre","201311",1.1299999999999999,null,null,193,0,0,0,null,null,null,null,null,null,193,"201311",1.1299999999999999,null,null,null,null,null,null,1.1299999999999999]
[2013,12,"Diciembre","201312",1.1299999999999999,null,null,194,0,0,0,null,null,null,null,null,null,194,"201312",1.1299999999999999,null,null,null,null,null,null,1.1299999999999999]
[2014,1,{"$f":"VLOOKUP(B195,Meses,2)","v":"Enero"},{"$f":"+CONCATENATE(TEXT(A195,0),RIGHT(\"00\"&TEXT(B195,0),2))","v":"201401"},1.1299999999999999,null,null,195,{"$f":"IF($N$2<$N$1,0,IF(I194=0,IF(D195=$N$1,E195,0),IF(D195>$N$2,0,E195)))","v":0},{"$f":"IF(E195>0,IF(E196=0,B195,0),0)","v":0},{"$f":"IF(J195=0,0,A195)","v":0},null,null,null,null,null,null,{"$f":"H195","v":195},{"$f":"D195","v":"201401"},{"$f":"E195","v":1.1299999999999999},null,null,null,null,null,null,1.1299999999999999]
[{"$f":"A195","v":2014},2,"Febrero","201402",1.1299999999999999,null,null,196,0,0,0,null,null,null,null,null,null,196,"201402",1.1299999999999999,null,null,null,null,null,null,0]
[2014,3,"Marzo","201403",1.1299999999999999,null,null,{"$f":"H196+1","v":197},0,0,0,null,null,null,null,null,null,197,"201403",1.1299999999999999,null,null,null,null,null,null,0]
[2014,4,"Abril","201404",1.1299999999999999,null,null,198,0,0,0,null,null,null,null,null,null,198,"201404",1.1299999999999999,null,null,null,null,null,null,0]
[2014,5,"Mayo","201405",1.1299999999999999,null,null,199,0,0,0,null,null,null,null,null,null,199,"201405",1.1299999999999999,null,null,null,null,null,null,0]
[2014,6,"Junio","201406",1.1299999999999999,null,null,200,0,0,0,null,null,null,null,null,null,200,"201406",1.1299999999999999,null,null,null,null,null,null,0]
[2014,7,"Julio","201407",1.1299999999999999,null,null,201,0,0,0,null,null,null,null,null,null,201,"201407",1.1299999999999999,null,null,null,null,null,null,0]
[2014,8,"Agosto","201408",1.1299999999999999,null,null,202,0,0,0,null,null,null,null,null,null,202,"201408",1.1299999999999999,null,null,null,null,null,null,0]
[2014,9,"Septiembre","201409",1.1299999999999999,null,null,203,0,0,0,null,null,null,null,null,null,203,"201409",1.1299999999999999,null,null,null,null,null,null,0]
[2014,10,"Octubre","201410",1.1299999999999999,"Regresa al Menú Anterior",null,204,0,0,0,null,null,null,null,null,null,204,"201410",1.1299999999999999,null,null,null,null,null,null,0]
[2014,11,"Noviembre","201411",1.1299999999999999,null,null,205,0,0,0,null,null,null,null,null,null,205,"201411",1.1299999999999999,null,null,null,null,null,null,0]
[2014,12,"Diciembre","201412",1.1299999999999999,null,null,206,0,12,2014,null,null,null,null,null,null,206,"201412",1.1299999999999999,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,207,{"$f":"IF($N$2<$N$1,0,IF(I206=0,IF(D207=$N$1,E207,0),IF(D207>$N$2,0,E207)))","v":0},{"$f":"IF(E207>0,IF(E208=0,B207,0),0)","v":0},{"$f":"IF(J207=0,0,A207)","v":0},null,null,null,null,null,null,{"$f":"H207","v":207},{"$f":"D207","v":0},{"$f":"E207","v":0}]
[null,null,null,null,null,null,null,208,0,0,0,null,null,null,null,null,null,208,0,0,null,null,null,null,null,null,{"$f":"SUM(AA2:AA206)","v":12.429999999999996}]
[null,null,null,null,null,null,null,209,0,0,0,null,null,null,null,null,null,209,0,0]
[null,null,null,null,null,null,null,210,0,0,0,null,null,null,null,null,null,210,0,0]
[null,null,null,null,null,null,null,211,0,0,0,null,null,null,null,null,null,211,0,0]
[null,null,null,null,null,null,null,212,0,0,0,null,null,null,null,null,null,212,0,0]
[null,null,null,null,null,null,null,213,0,0,0,null,null,null,null,null,null,213,0,0]
[null,null,null,null,null,null,null,214,0,0,0,null,null,null,null,null,null,214,0,0]
[null,null,null,null,null,null,null,215,0,0,0,null,null,null,null,null,null,215,0,0]
[null,null,null,null,null,null,null,216,0,0,0,null,null,null,null,null,null,216,0,0]
[null,null,null,null,null,null,null,217,0,0,0,null,null,null,null,null,null,217,0,0]
[null,null,null,null,null,null,null,218,0,0,0,null,null,null,null,null,null,218,0,0]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I2:I218)","v":4.5199999999999996},{"$f":"SUM(J92:J218)","v":12},{"$f":"SUM(K92:K218)","v":2014}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"RECARGOS: \",VLOOKUP(J221,Meses,2),\" de \",K221)","v":"RECARGOS: Diciembre de 2014"}]

{"sheet":"Efectua_Calculo","index":5,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[2,1,2,3],[17,1,17,4],[0,1,0,3]]}
[null,"ACTUALIZACIÓN"]
[]
[null,"PAGOS Y ENTEROS PROVISIONALES"]
[]
[null,"Se debió de haber pagado en el mes",null,null,{"$f":"Calcular!I12","v":1},null,"INPC mas antiguo",null,null,{"$f":"VLOOKUP(I6,INPC,I7+1)","v":107.246},null,null,{"$f":"CONCATENATE(\"17/\",RIGHT(\"00\"&TEXT(E5,0),2),\"/\",TEXT(E6,0))","v":"17/01/2013"},{"$f":"DATEVALUE(M5)","v":41291}]
[null,"Del año",null,null,{"$f":"Calcular!I13","v":2013},null,"Año base",null,{"$f":"IF(E5=1,E6-1,E6)","v":2012},null,null,null,{"$f":"CONCATENATE(RIGHT(\"00\"&TEXT(E8,0),2),\"/\",RIGHT(\"00\"&TEXT(E9,0),2),\"/\",TEXT(E10,0))","v":"15/05/2013"},{"$f":"DATEVALUE(M6)","v":41409}]
[null,null,null,null,null,null,"Mes base",null,{"$f":"IF(E5=1,12,E5-1)","v":12}]
[null,"Se pagara el día",null,null,{"$f":"Calcular!I17","v":15},null,null,null,null,null,null,null,null,{"$f":"N6-N5","v":118}]
[null,"Del mes",null,null,{"$f":"Calcular!I18","v":5},null,"INPC mas reciente",null,null,{"$f":"IF(N8<32,J5,VLOOKUP(I10,INPC,I11+1))","v":109.074}]
[null,"Del año",null,null,{"$f":"Calcular!I19","v":2013},null,"Año Base",null,{"$f":"IF(N8<32,I6,IF(E8>9,IF(E9=1,E10-1,E10),IF(E9<3,E10-1,E10)))","v":2013}]
[null,null,null,null,null,null,"Mes Base:",null,{"$f":"IF(N8<32,I7,IF(E8>9,IF(E9=1,12,E9-1),IF(E9=1,11,IF(E9=2,12,E9-2))))","v":4}]
[]
[]
[null,null,null,null,null,null,"Factor de actualización",null,null,{"$f":"IF(J5>J9,1,ROUND(INT(ABS((J9/J5)*10000))/10000,4))","v":1.0169999999999999}]
[]
[]
[]
[null,"PAGOS EN DECLARACIONES ANUALES"]
[]
[null,"Se debió de haber pagado en el mes",null,null,{"$f":"Ejercicio!I12","v":2},null,"INPC mas antiguo",null,null,{"$f":"VLOOKUP(I21,INPC,I22+1)","v":107.678}]
[null,"Del año",null,null,{"$f":"Ejercicio!I13","v":2013},null,"Año base",null,{"$f":"IF(E20=1,E21-1,E21)","v":2013}]
[null,null,null,null,null,null,"Mes base",null,{"$f":"E20-1","v":1}]
[null,"Se pagara el día",null,null,{"$f":"Ejercicio!I17","v":19}]
[null,"Del mes",null,null,{"$f":"Ejercicio!I18","v":1},null,"INPC mas reciente",null,null,{"$f":"IF(F32=F36,J20,VLOOKUP(I25,INPC,I26+1))","v":111.508}]
[null,"Del año",null,null,{"$f":"Ejercicio!I19","v":2014},null,"Año Base",null,{"$f":"IF(E23>9,IF(E24=1,E25-1,E25),IF(E24<3,E25-1,E25))","v":2013}]
[null,null,null,null,null,null,"Mes Base:",null,{"$f":"IF(E23>9,IF(E24=1,12,E24-1),IF(E24=1,11,IF(E24=2,12,E24-2)))","v":12}]
[]
[]
[null,null,null,null,null,null,"Factor de actualización",null,null,{"$f":"IF(J20>J24,1,IF(J20=0,1,ROUND(INT(ABS((J24/J20)*10000))/10000,4)))","v":1.0355000000000001}]
[]
[]
[null,null,null,null,{"$f":"CONCATENATE(TEXT(E21,0),RIGHT(\"00\"&TEXT(E20,0),2))","v":"201302"},{"$f":"VLOOKUP(E32,Recargos,5)","v":184}]
[null,null,null,null,{"$f":"CONCATENATE(TEXT(E25,0)&RIGHT(\"00\"&TEXT(E24,0),2))","v":"201401"},{"$f":"VLOOKUP(E33,Recargos,5)","v":195}]
[null,null,null,null,{"$f":"IF(E23<10,IF(E24=2,12,IF(E24=1,11,E24-1)),E24-1)","v":0}]
[null,null,null,null,{"$f":"IF(E23<10,IF(E24>2,E25,E25-1),E25)","v":2014}]
[null,null,null,null,{"$f":"CONCATENATE(TEXT(E35,0),RIGHT(\"00\"&TEXT(E34,0),2))","v":"201400"},{"$f":"IF(E36<=E32,F32,VLOOKUP(E36,Recargos,5))","v":194}]

{"sheet":"Memoria de Calculo","index":6,"n_rows":153,"n_cols":19,"rows_kept":153,"cut":false,"hidden":false,"merged":[[3,1,3,7],[13,1,13,7],[0,0,0,7]]}
["IMPUESTOS PROVISIONALES, DEFINITIVOS Y ENTERO DE RETENCIONES MENSALES",null,null,null,null,null,null,null,null,2013]
[null,null,null,null,null,null,"Regresa al menú Anterior"]
[]
[null,"CALCULO DEL FACTOR DE ACTUALIZACION"]
[]
[]
[null,null,null,null,null,null,"INPC",null,"Factor"]
[]
[null,"Mes mas reciente:",null,{"$f":"VLOOKUP(Efectua_Calculo!I11,Meses,2)","v":"Abril"},{"$f":"Efectua_Calculo!I10","v":2013},null,{"$f":"VLOOKUP(Efectua_Calculo!I10,INPC,Efectua_Calculo!I11+1)","v":109.074},null,{"$f":"Efectua_Calculo!J14","v":1.0169999999999999}]
[null,"Mes mas antiguo:",null,{"$f":"VLOOKUP(Efectua_Calculo!I7,Meses,2)","v":"Diciembre"},{"$f":"Efectua_Calculo!I6","v":2012},null,{"$f":"VLOOKUP(Efectua_Calculo!I6,INPC,Efectua_Calculo!I7+1)","v":107.246}]
[]
["       (No se actualizan los importes por períodos menores a un mes (Art 17-A 1er. párrafo CFF)"]
[]
[null,"SUMA DE RECARGOS"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Recargos!N1","v":"201301"},{"$f":"Recargos!N2","v":"201304"},null,{"$f":"IF(N16<M16,0,VLOOKUP(M16,Recargos,5))","v":183},{"$f":"IF(P16=0,0,VLOOKUP(P16,Rec,2))","v":"201301"},{"$f":"IF(Q16=0,\"-\",VLOOKUP(VALUE(RIGHT(Q16,2)),Meses,2)&\" de \"&LEFT(Q16,4))","v":"Enero de 2013"},{"$f":"IF(P16=0,0,VLOOKUP(P16,Rec,3))","v":1.1299999999999999}]
[null,{"$f":"R16","v":"Enero de 2013"},null,{"$f":"S16","v":1.1299999999999999},null,null,"Total de Recargos",null,{"$f":"SUM(D17:D153)/100","v":4.5199999999999997E-2},null,null,null,null,null,null,{"$f":"IF(P16=0,0,IF((P16+1)>$N$21,0,P16+1))","v":184},{"$f":"IF(P17=0,0,VLOOKUP(P17,Rec,2))","v":"201302"},{"$f":"IF(Q17=0,\"-\",VLOOKUP(VALUE(RIGHT(Q17,2)),Meses,2)&\" de \"&LEFT(Q17,4))","v":"Febrero de 2013"},1.1299999999999999]
[null,{"$f":"R17","v":"Febrero de 2013"},null,{"$f":"S17","v":1.1299999999999999},null,null,null,null,null,null,null,null,{"$f":"RIGHT(M16,2)","v":"01"},{"$f":"RIGHT(N16,2)","v":"04"},null,{"$f":"IF(P17=0,0,IF((P17+1)>$N$21,0,P17+1))","v":185},{"$f":"IF(P18=0,\"-\",VLOOKUP(P18,Rec,2))","v":"201303"},{"$f":"IF(Q18=\"-\",\"-\",VLOOKUP(VALUE(RIGHT(Q18,2)),Meses,2)&\" de \"&LEFT(Q18,4))","v":"Marzo de 2013"},1.1299999999999999]
[null,"Marzo de 2013",null,1.1299999999999999,null,null,null,null,null,null,null,null,{"$f":"LEFT(M16,4)","v":"2013"},{"$f":"LEFT(N16,4)","v":"2013"},null,186,"201304","Abril de 2013",1.1299999999999999]
[null,"Abril de 2013",null,1.1299999999999999,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,{"$f":"IF(N16<M16,0,VLOOKUP(N16,Recargos,5))","v":186},null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",{"$f":"IF(P48=0,0,VLOOKUP(P48,Rec,3))","v":0}]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P50=0,\"-\",VLOOKUP(P50,Rec,2))","v":"-"},{"$f":"IF(Q50=\"-\",\"-\",VLOOKUP(VALUE(RIGHT(Q50,2)),Meses,2)&\" de \"&LEFT(Q50,4))","v":"-"},0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",{"$f":"IF(P80=0,0,VLOOKUP(P80,Rec,3))","v":0}]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,{"$f":"R81","v":"-"},null,{"$f":"S81","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P81=0,0,IF((P81+1)>$N$21,0,P81+1))","v":0},{"$f":"IF(P82=0,\"-\",VLOOKUP(P82,Rec,2))","v":"-"},{"$f":"IF(Q82=\"-\",\"-\",VLOOKUP(VALUE(RIGHT(Q82,2)),Meses,2)&\" de \"&LEFT(Q82,4))","v":"-"},0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",{"$f":"IF(P112=0,0,VLOOKUP(P112,Rec,3))","v":0}]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P114=0,\"-\",VLOOKUP(P114,Rec,2))","v":"-"},{"$f":"IF(Q114=\"-\",\"-\",VLOOKUP(VALUE(RIGHT(Q114,2)),Meses,2)&\" de \"&LEFT(Q114,4))","v":"-"},0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,{"$f":"R117","v":"-"},null,{"$f":"S117","v":0},null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",{"$f":"IF(P144=0,0,VLOOKUP(P144,Rec,3))","v":0}]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P145=0,0,IF((P145+1)>$N$21,0,P145+1))","v":0},{"$f":"IF(P146=0,\"-\",VLOOKUP(P146,Rec,2))","v":"-"},{"$f":"IF(Q146=\"-\",\"-\",VLOOKUP(VALUE(RIGHT(Q146,2)),Meses,2)&\" de \"&LEFT(Q146,4))","v":"-"},0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]
[null,"-",null,0,null,null,null,null,null,null,null,null,null,null,null,0,"-","-",0]

{"sheet":"Mem Calc","index":7,"n_rows":153,"n_cols":19,"rows_kept":153,"cut":false,"hidden":false,"merged":[[3,1,3,7],[13,1,13,7],[0,0,0,5]]}
["IMPUESTOS DEL EJERCICIO FISCAL"]
[null,null,null,null,null,null,"Regresa al menú Anterior"]
[]
[null,"CALCULO DEL FACTOR DE ACTUALIZACION"]
[]
[]
[null,null,null,null,null,null,"INPC",null,"Factor"]
[]
[null,"Mes mas reciente:",null,{"$f":"VLOOKUP(Efectua_Calculo!I26,Meses,2)","v":"Diciembre"},{"$f":"Efectua_Calculo!I25","v":2013},null,{"$f":"VLOOKUP(Efectua_Calculo!I25,INPC,Efectua_Calculo!I26+1)","v":111.508},null,{"$f":"Efectua_Calculo!J29","v":1.0355000000000001}]
[null,"Mes mas antiguo:",null,{"$f":"VLOOKUP(Efectua_Calculo!I22,Meses,2)","v":"Enero"},{"$f":"Efectua_Calculo!I21","v":2013},null,{"$f":"VLOOKUP(Efectua_Calculo!I21,INPC,Efectua_Calculo!I22+1)","v":107.678}]
[]
["       (No se actualizan los importes por períodos menores a un mes (Art 17-A 1er. párrafo CFF)"]
[]
[null,"SUMA DE RECARGOS"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Recargos!Y1","v":"201303"},{"$f":"Recargos!Y2","v":"201401"},null,{"$f":"VLOOKUP(M16,Recargos,5)","v":185},{"$f":"IF(P16=0,0,VLOOKUP(P16,Rec,2))","v":"201303"},{"$f":"IF(Q16=0,0,VLOOKUP(VALUE(RIGHT(Q16,2)),Meses,2)&\" de \"&LEFT(Q16,4))","v":"Marzo de 2013"},{"$f":"VLOOKUP(P16,Rec,3)","v":1.1299999999999999}]
[null,{"$f":"R16","v":"Marzo de 2013"},null,{"$f":"S16","v":1.1299999999999999},null,null,"Total de Recargos",null,{"$f":"SUM(D17:D153)/100","v":0.12429999999999997},null,null,null,null,null,null,{"$f":"IF((P16+1)>$N$21,0,P16+1)","v":186},{"$f":"IF(P17=0,\"-\",VLOOKUP(P17,Rec,2))","v":"201304"},{"$f":"IF(Q17=\"-\",\"-\",VLOOKUP(VALUE(RIGHT(Q17,2)),Meses,2)&\" de \"&LEFT(Q17,4))","v":"Abril de 2013"},{"$f":"IF(R17=\"-\",\"-\",VLOOKUP(P17,Rec,3))","v":1.1299999999999999}]
[null,{"$f":"R17","v":"Abril de 2013"},null,{"$f":"S17","v":1.1299999999999999},null,null,null,null,null,null,null,null,{"$f":"RIGHT(M16,2)","v":"03"},{"$f":"RIGHT(N16,2)","v":"01"},null,{"$f":"IF(P17=0,0,IF((P17+1)>$N$21,0,P17+1))","v":187},{"$f":"IF(P18=0,\"-\",VLOOKUP(P18,Rec,2))","v":"201305"},{"$f":"IF(Q18=\"-\",\"-\",VLOOKUP(VALUE(RIGHT(Q18,2)),Meses,2)&\" de \"&LEFT(Q18,4))","v":"Mayo de 2013"},1.1299999999999999]
[null,"Mayo de 2013",null,1.1299999999999999,null,null,null,null,null,null,null,null,{"$f":"LEFT(M16,4)","v":"2013"},{"$f":"LEFT(N16,4)","v":"2014"},null,{"$f":"IF(P18=0,0,IF((P18+1)>$N$21,0,P18+1))","v":188},"201306","Junio de 2013",1.1299999999999999]
[null,"Junio de 2013",null,1.1299999999999999,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P19=0,0,IF((P19+1)>$N$21,0,P19+1))","v":189},"201307","Julio de 2013",1.1299999999999999]
[null,"Julio de 2013",null,1.1299999999999999,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(N16,Recargos,5)","v":195},null,{"$f":"IF(P20=0,0,IF((P20+1)>$N$21,0,P20+1))","v":190},"201308","Agosto de 2013",1.1299999999999999]
[null,"Agosto de 2013",null,1.1299999999999999,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P21=0,0,IF((P21+1)>$N$21,0,P21+1))","v":191},"201309","Septiembre de 2013",1.1299999999999999]
[null,"Septiembre de 2013",null,1.1299999999999999,null,null,null,null,null,null,null,null,null,null,null,192,"201310","Octubre de 2013",1.1299999999999999]
[null,"Octubre de 2013",null,1.1299999999999999,null,null,null,null,null,null,null,null,null,null,null,193,"201311","Noviembre de 2013",1.1299999999999999]
[null,"Noviembre de 2013",null,1.1299999999999999,null,null,null,null,null,null,null,null,null,null,null,194,"201312","Diciembre de 2013",1.1299999999999999]
[null,"Diciembre de 2013",null,1.1299999999999999,null,null,null,null,null,null,null,null,null,null,null,195,"201401","Enero de 2014",1.1299999999999999]
[null,"Enero de 2014",null,1.1299999999999999,null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-",{"$f":"IF(R49=\"-\",\"-\",VLOOKUP(P49,Rec,3))","v":"-"}]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P50=0,\"-\",VLOOKUP(P50,Rec,2))","v":"-"},{"$f":"IF(Q50=\"-\",\"-\",VLOOKUP(VALUE(RIGHT(Q50,2)),Meses,2)&\" de \"&LEFT(Q50,4))","v":"-"},"-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-",{"$f":"IF(R81=\"-\",\"-\",VLOOKUP(P81,Rec,3))","v":"-"}]
[null,{"$f":"R81","v":"-"},null,{"$f":"S81","v":"-"},null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P82=0,\"-\",VLOOKUP(P82,Rec,2))","v":"-"},{"$f":"IF(Q82=\"-\",\"-\",VLOOKUP(VALUE(RIGHT(Q82,2)),Meses,2)&\" de \"&LEFT(Q82,4))","v":"-"},"-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P85=0,0,IF((P85+1)>$N$21,0,P85+1))","v":0},"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-",{"$f":"IF(R113=\"-\",\"-\",VLOOKUP(P113,Rec,3))","v":"-"}]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P114=0,\"-\",VLOOKUP(P114,Rec,2))","v":"-"},{"$f":"IF(Q114=\"-\",\"-\",VLOOKUP(VALUE(RIGHT(Q114,2)),Meses,2)&\" de \"&LEFT(Q114,4))","v":"-"},"-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,{"$f":"R117","v":"-"},null,{"$f":"S117","v":"-"},null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-",{"$f":"IF(R145=\"-\",\"-\",VLOOKUP(P145,Rec,3))","v":"-"}]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P146=0,\"-\",VLOOKUP(P146,Rec,2))","v":"-"},{"$f":"IF(Q146=\"-\",\"-\",VLOOKUP(VALUE(RIGHT(Q146,2)),Meses,2)&\" de \"&LEFT(Q146,4))","v":"-"},"-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,0,"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P149=0,0,IF((P149+1)>$N$21,0,P149+1))","v":0},"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P150=0,0,IF((P150+1)>$N$21,0,P150+1))","v":0},"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P151=0,0,IF((P151+1)>$N$21,0,P151+1))","v":0},"-","-","-"]
[null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P152=0,0,IF((P152+1)>$N$21,0,P152+1))","v":0},"-","-","-"]