{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["NOMINA","CALCULO ISR","TARIFAS","IMSS","SDI"],"not_rendered":{"macros":1,"defined_names":14},"read":"whole","date_system":"1900"}

{"sheet":"NOMINA","index":0,"n_rows":69,"n_cols":22,"rows_kept":69,"merged":[[1,1,1,21],[2,1,2,21],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,6,3,14],[3,15,3,20],[3,21,4,21],[13,1,13,2],[24,1,24,20],[25,1,25,20],[26,1,27,1],[26,2,27,2],[26,3,27,3],[26,4,27,4],[26,5,27,5],[26,6,27,6],[26,7,27,7],[26,8,27,8],[26,9,27,9],[26,10,27,10],[26,11,27,11],[26,12,27,12],[26,13,27,13],[26,14,27,14],[26,15,27,15],[26,16,27,16],[26,17,27,17],[26,18,27,18],[26,19,27,19],[26,20,27,20]]}
[]
[null,{"$f":"+IMSS!B6","v":"EMPRESA \"X\""}]
[null,"NÓMINA DE SUELDOS DEL PERÍODO X"]
[null,"No.","TRABAJADOR","SALARIO DIARIO","DÍAS TRABAJADOS",null,"PERCEPCIONES",{"$nulls":8},"DEDUCCIONES",{"$nulls":5},"NETO A PAGAR"]
[{"$nulls":6},"SALARIO DEL PERÍODO","PREMIO DE ASISTENCIA","PREMIO DE PUNTUALIDAD","AYUDA DE DESPENSA","TIEMPO EXTRA","OTRAS PERCEPCIONES","PRIMA DOMINICAL","SUBSIDIO AL EMPLEO","TOTAL","ISR","CUOTAS IMSS","CRÈDITOS INFONAVIT","PRÉSTAMOS","OTRAS DEDUCCIONES","TOTAL"]
[null,1,null,368.81,7,null,{"$f":"+E6*D6","v":{"v":2581.67,"d":"2,581.67"}},0,{"$f":"+H6","v":0},0,0,0,0,{"$f":"HLOOKUP(B6,CALCULOISR,21,0)","v":0},{"$f":"SUM(G6:N6)","v":{"v":2581.67,"d":"2,581.67"}},{"$f":"HLOOKUP(B6,CALCULOISR,20,0)","v":{"v":236.97251200000002,"d":"236.97"}},{"$f":"VLOOKUP(B6,IMSS,23,0)","v":{"v":293.46362498630134,"d":"293.46"}},0,0,0,{"$f":"SUM(P6:T6)","v":{"v":530.4361369863013,"d":"530.44"}},{"$f":"+O6-U6","v":{"v":2051.2338630136987,"d":"2,051.23"}}]
[null,2,null,{"v":427.92121586358445,"d":"427.92"},7,null,{"$f":"+E7*D7","v":{"v":2995.448511045091,"d":"2,995.45"}},{"$f":"VLOOKUP(B7,SDI,9,0)*E7*0.1","v":{"v":315.13759677844246,"d":"315.14"}},{"v":315.13759677844246,"d":"315.14"},{"$f":"+UMA*40%*E7","v":{"v":269.416,"d":"269.42"}},{"$f":"+D7/8*2*9","v":{"v":962.822735693065,"d":"962.82"}},0,{"$f":"+D7*0.25","v":{"v":106.98030396589611,"d":"106.98"}},{"$f":"HLOOKUP(B7,CALCULOISR,21,0)","v":0},{"v":4964.942744260938,"d":"4,964.94"},{"$f":"HLOOKUP(B7,CALCULOISR,20,0)","v":{"v":677.4950764470209,"d":"677.50"}},{"v":80.15604709796388,"d":"80.16"},0,0,0,{"v":757.6511235449848,"d":"757.65"},{"v":4207.291620715952,"d":"4,207.29"}]
[null,3,null,{"v":140,"d":"140.00"},6,null,{"$f":"+E8*D8","v":{"v":840,"d":"840.00"}},{"v":88.25753424657535,"d":"88.26"},{"v":88.25753424657535,"d":"88.26"},{"v":230.928,"d":"230.93"},{"$f":"+D8/8*2*9","v":{"v":315,"d":"315.00"}},0,{"$f":"+D8*0.25","v":{"v":35,"d":"35.00"}},0,{"v":1597.4430684931508,"d":"1,597.44"},{"v":36.30909865205481,"d":"36.31"},{"v":24.712109589041095,"d":"24.71"},0,0,0,{"v":61.021208241095906,"d":"61.02"},{"v":1536.421860252055,"d":"1,536.42"}]
[null,4,null,102.68,{"$f":"3+(1/6*3)","v":3.5},null,359.38,{"v":37.710284931506855,"d":"37.71"},{"v":37.710284931506855,"d":"37.71"},{"v":134.708,"d":"134.71"},{"v":231.03000000000003,"d":"231.03"},0,25.67,{"v":53.10842752876712,"d":"53.11"},{"v":879.3169973917808,"d":"879.32"},0,{"v":18.100936767123287,"d":"18.10"},0,0,0,{"v":18.100936767123287,"d":"18.10"},{"v":861.2160606246575,"d":"861.22"}]
[null,5,null,{"v":600,"d":"600.00"},7,null,{"v":4200,"d":"4,200.00"},{"v":441.28767123287673,"d":"441.29"},{"v":441.28767123287673,"d":"441.29"},{"v":269.416,"d":"269.42"},{"v":1350,"d":"1,350.00"},0,{"v":150,"d":"150.00"},0,{"v":6851.991342465754,"d":"6,851.99"},{"v":1079.6976981479454,"d":"1,079.70"},{"v":115.47806794520548,"d":"115.48"},0,0,0,{"v":1195.175766093151,"d":"1,195.18"},{"v":5656.815576372604,"d":"5,656.82"}]
[null,6,null,{"v":720,"d":"720.00"},7,null,{"v":5040,"d":"5,040.00"},{"v":529.5452054794522,"d":"529.55"},{"v":529.5452054794522,"d":"529.55"},{"v":269.416,"d":"269.42"},{"v":1620,"d":"1,620.00"},0,{"v":180,"d":"180.00"},0,{"v":8168.506410958905,"d":"8,168.51"},{"v":1382.5212422575344,"d":"1,382.52"},{"v":140.19017753424657,"d":"140.19"},0,0,0,{"v":1522.7114197917808,"d":"1,522.71"},{"v":6645.794991167124,"d":"6,645.79"}]
[null,7,null,{"v":840,"d":"840.00"},7,null,{"v":5880,"d":"5,880.00"},{"v":618.6082191780821,"d":"618.61"},{"v":618.6082191780821,"d":"618.61"},{"v":269.416,"d":"269.42"},{"v":1890,"d":"1,890.00"},0,{"v":210,"d":"210.00"},0,{"v":9486.632438356166,"d":"9,486.63"},{"v":1685.72368390137,"d":"1,685.72"},{"v":165.12782136986297,"d":"165.13"},0,0,0,{"v":1850.8515052712328,"d":"1,850.85"},{"v":7635.780933084933,"d":"7,635.78"}]
[null,8,null,{"v":960,"d":"960.00"},7,null,{"v":6720,"d":"6,720.00"},{"v":706.9808219178082,"d":"706.98"},{"v":706.9808219178082,"d":"706.98"},{"v":269.416,"d":"269.42"},{"v":2160,"d":"2,160.00"},0,{"v":240,"d":"240.00"},0,{"v":10803.377643835616,"d":"10,803.38"},{"v":2030.1918931506848,"d":"2,030.19"},{"v":189.87215013698628,"d":"189.87"},0,0,0,{"v":2220.064043287671,"d":"2,220.06"},{"v":8583.313600547945,"d":"8,583.31"}]
[null,"TOTAL",null,0,0,null,{"$f":"SUM(G6:G13)","v":{"v":28616.49851104509,"d":"28,616.50"}},{"$f":"SUM(H6:H13)","v":{"v":2737.5273337647436,"d":"2,737.53"}},{"$f":"SUM(I6:I13)","v":{"v":2737.5273337647436,"d":"2,737.53"}},{"$f":"SUM(J6:J13)","v":{"v":1712.716,"d":"1,712.72"}},{"v":8528.852735693064,"d":"8,528.85"},0,{"v":947.6503039658961,"d":"947.65"},{"$f":"SUM(N6:N13)","v":{"v":53.10842752876712,"d":"53.11"}},{"$f":"SUM(O6:O13)","v":{"v":45333.88064576231,"d":"45,333.88"}},{"$f":"SUM(P6:P13)","v":{"v":7128.911204556609,"d":"7,128.91"}},{"$f":"SUM(Q6:Q13)","v":{"v":1027.100935426731,"d":"1,027.10"}},0,{"$f":"SUM(S6:S13)","v":0},{"$f":"SUM(T6:T13)","v":0},{"$f":"SUM(U6:U13)","v":{"v":8156.012139983341,"d":"8,156.01"}},{"$f":"SUM(V6:V13)","v":{"v":37177.86850577897,"d":"37,177.87"}}]
{"$rows_empty":9}
[null,null,"2019-11-30"]
[null,"INSIGNO INTERNACIONAL SA DE CV"]
[null,"AGUINALDOS Y PRIMAVACACIONAL 2022"]
[null,"No.","TRABAJADOR","FECHA INGRESO","SALARIO DIARIO",null,"ANTIGÜEDAD (DIAS)","ANTIGÜEDAD (AÑOS)","VACACIONES (DIAS)","PRIMA VACACIONAL","TOTAL PRIMA VACACIONAL","AGUINALDO (DIAS)","AGUINALDO $","EXENTO (30.4 * UMAS)","SUBTOTAL (RET. ISPT)","LIM. INFERIOR","EXCEDENTE L.I.","% S/ EXCEDENTE","IMPTO. MARGINAL","CUOTA FIJA","TOTAL AGUIALDO"]
[]
[null,1,"ERNESTO JAVIER BAEZ HERNANDEZ","2014-09-17",233.83,{"v":235.0551,"d":"235.06"},{"$f":"NOMINA!$C$24-D29","v":{"v":1900,"d":"1,900"}},{"$f":"G29/365","v":{"v":5.205479452054795,"d":"5.21"}},14,{"$f":"I29*0.25","v":3.5},{"$f":"J29*E29","v":{"v":818.4050000000001,"d":"$818.41"}},15,{"$f":"F29*L29","v":{"v":3525.8265,"d":"3,525.8"}},{"$f":"30.4*UMA","v":{"v":2925.0879999999997,"d":"2,925.1"}},{"$f":"M29-N29","v":{"v":600.7385000000004,"d":"600.7"}},0.01,{"$f":"O29-P29","v":{"v":600.7285000000004,"d":"600.7"}},{"v":0.0192,"d":"1.92%"},{"$f":"R29*Q29","v":{"v":11.533987200000007,"d":"11.5"}},0,{"$f":"M29-S29","v":{"v":3514.2925128,"d":"$3,514.29"}}]
[null,2,"SAUL ELIZARRARAS RAMIREZ","2019-06-10",816.67,{"v":825.585,"d":"825.59"},{"$f":"NOMINA!$C$24-D30","v":173},{"v":0.473972602739726,"d":"0.47"},0,0,0,{"$f":"(G30*15)/365","v":{"v":7.109589041095891,"d":"7"}},{"v":5869.570068493152,"d":"5,869.6"},{"v":2925.0879999999997,"d":"2,925.1"},{"$f":"M30-N30","v":{"v":2944.482068493152,"d":"2,944.5"}},0.01,{"$f":"O30-P30","v":{"v":2944.4720684931517,"d":"2,944.5"}},{"v":0.0192,"d":"1.92%"},{"v":56.533863715068506,"d":"56.5"},0,{"v":5813.036204778083,"d":"$5,813.04"}]
[null,3,"JUVENTINO HERNANDEZ BLAS","2013-09-09",321.43,324.37,{"$f":"NOMINA!$C$24-D31","v":{"v":2273,"d":"2,273"}},{"v":6.227397260273973,"d":"6.23"},14,3.5,{"v":1125.005,"d":"$1,125.01"},15,{"v":4865.55,"d":"4,865.6"},{"v":2925.0879999999997,"d":"2,925.1"},{"$f":"M31-N31","v":{"v":1940.4620000000004,"d":"1,940.5"}},0.01,{"$f":"O31-P31","v":{"v":1940.4520000000005,"d":"1,940.5"}},{"v":0.0192,"d":"1.92%"},{"v":37.256678400000006,"d":"37.3"},0,{"v":4828.2933216,"d":"$4,828.29"}]
[null,4,"LORENA GUADALUPE HERNANDEZ ZUÑIGA","2019-07-10",216.67,216.67,{"$f":"NOMINA!$C$24-D32","v":143},{"v":0.3917808219178082,"d":"0.39"},0,0,0,{"$f":"(G32*15)/365","v":{"v":5.876712328767123,"d":"6"}},{"v":1273.3072602739726,"d":"1,273.3"},{"v":2925.0879999999997,"d":"2,925.1"},0,0.01,0,{"v":0,"d":"0%"},0,0,{"v":1273.3072602739726,"d":"$1,273.31"}]
[null,5,"FRANCISCO MEDINA PEREZ","2019-06-26",171.43,171.43,{"$f":"NOMINA!$C$24-D33","v":157},{"v":0.4301369863013699,"d":"0.43"},0,0,0,{"$f":"(G33*15)/365","v":{"v":6.4520547945205475,"d":"6"}},{"v":1106.0757534246575,"d":"1,106.1"},{"v":2925.0879999999997,"d":"2,925.1"},0,0.01,0,{"v":0,"d":"0%"},0,0,{"v":1106.0757534246575,"d":"$1,106.08"}]
[null,6,"JUAN MARCELO MUÑOZ CALDERILLA","2014-10-20",343.62,{"v":346.9943,"d":"346.99"},{"$f":"NOMINA!$C$24-D34","v":{"v":1867,"d":"1,867"}},{"v":5.115068493150685,"d":"5.12"},14,3.5,{"v":1202.67,"d":"$1,202.67"},15,{"v":5204.9145,"d":"5,204.9"},{"v":2925.0879999999997,"d":"2,925.1"},{"$f":"M34-N34","v":{"v":2279.8265,"d":"2,279.8"}},0.01,{"$f":"O34-P34","v":{"v":2279.8165,"d":"2,279.8"}},{"v":0.0192,"d":"1.92%"},{"v":43.77247679999999,"d":"43.8"},0,{"v":5161.1420232,"d":"$5,161.14"}]
[null,7,"EDGAR DAVID NIETO HERNANDEZ","2017-03-07",246.85,248.33,{"$f":"NOMINA!$C$24-D35","v":998},{"v":2.734246575342466,"d":"2.73"},8,{"v":2,"d":"2.0"},{"v":493.7,"d":"$493.70"},15,{"v":3724.9500000000003,"d":"3,725.0"},{"v":2925.0879999999997,"d":"2,925.1"},{"$f":"M35-N35","v":{"v":799.8620000000005,"d":"799.9"}},0.01,{"$f":"O35-P35","v":{"v":799.8520000000005,"d":"799.9"}},{"v":0.0192,"d":"1.92%"},{"v":15.357158400000008,"d":"15.4"},0,{"v":3709.5928416,"d":"$3,709.59"}]
[null,8,"JUAN JOSE RAMIREZ SALAZAR","2019-05-06",{"v":300,"d":"300.00"},{"v":300,"d":"300.00"},{"$f":"NOMINA!$C$24-D36","v":208},{"v":0.5698630136986301,"d":"0.57"},0,0,0,{"$f":"(G36*15)/365","v":{"v":8.547945205479452,"d":"9"}},{"v":2564.383561643836,"d":"2,564.4"},{"v":2925.0879999999997,"d":"2,925.1"},0,0.01,0,{"v":0,"d":"0%"},0,0,{"v":2564.383561643836,"d":"$2,564.38"}]
[null,9,"JOSE RAFAEL ALEJANDRO ALMANZA","2019-10-14",{"v":200,"d":"200.00"},{"v":200,"d":"200.00"},{"$f":"NOMINA!$C$24-D37","v":47},{"v":0.12876712328767123,"d":"0.13"},0,0,0,{"$f":"(G37*15)/365","v":{"v":1.9315068493150684,"d":"2"}},{"v":386.3013698630137,"d":"386.3"},{"v":2925.0879999999997,"d":"2,925.1"},0,0.01,0,{"v":0,"d":"0%"},0,0,{"v":386.3013698630137,"d":"$386.30"}]
[]
[{"$nulls":10},{"$f":"SUM(K29:K38)","v":{"v":3639.78,"d":"$3,639.78"}},{"$nulls":9},{"$f":"SUM(U29:U38)","v":{"v":28356.42484918356,"d":"$28,356.42"}}]
{"$rows_empty":17}
[null,null,"Tablas ISR 2019 Anuales"]
[null,null,"Límite inferior","Límite superior","Cuota fija",null,"% sobre excedente de límite inferior"]
[null,null,0.01,{"v":6942.2,"d":"6,942.20"},0,null,1.92]
[null,null,{"v":6942.21,"d":"6,942.21"},{"v":58922.16,"d":"58,922.16"},133.28,null,{"v":6.4,"d":"6.40"}]
[null,null,{"v":58922.17,"d":"58,922.17"},{"v":103550.44,"d":"103,550.44"},{"v":3460.01,"d":"3,460.01"},null,10.88]
[null,null,{"v":103550.45,"d":"103,550.45"},{"v":120372.83,"d":"120,372.83"},{"v":8315.57,"d":"8,315.57"},null,{"v":16,"d":"16.00"}]
[null,null,{"v":120372.84,"d":"120,372.84"},{"v":144119.23,"d":"144,119.23"},{"v":11007.14,"d":"11,007.14"},null,17.92]
[null,null,{"v":144119.24,"d":"144,119.24"},{"v":290667.75,"d":"290,667.75"},{"v":15262.49,"d":"15,262.49"},null,21.36]
[null,null,{"v":290667.76,"d":"290,667.76"},{"v":458132.29,"d":"458,132.29"},{"v":46565.26,"d":"46,565.26"},null,23.52]
[null,null,{"v":458132.3,"d":"458,132.30"},{"v":874650,"d":"874,650.00"},{"v":85952.92,"d":"85,952.92"},null,{"v":30,"d":"30.00"}]
[null,null,{"v":874650.01,"d":"874,650.01"},{"v":1166200,"d":"1,166,200.00"},{"v":210908.23,"d":"210,908.23"},null,{"v":32,"d":"32.00"}]
[null,null,{"v":1166200.01,"d":"1,166,200.01"},{"v":3498600,"d":"3,498,600.00"},{"v":304204.21,"d":"304,204.21"},null,{"v":34,"d":"34.00"}]
[null,null,{"v":3498600.01,"d":"3,498,600.01"},"En adelante",{"v":1097220.21,"d":"1,097,220.21"},null,{"v":35,"d":"35.00"}]

{"sheet":"CALCULO ISR","index":1,"n_rows":24,"n_cols":11,"rows_kept":24,"merged":[[1,1,1,10],[2,1,2,10]]}
[]
[null,{"$f":"+NOMINA!B2","v":"EMPRESA \"X\""}]
[null,"DETERMINACIÓN DEL ISR "]
[1,"CONCEPTO",1,2,3,4,5,6,7,8,"TOTAL"]
[2,"SALARIO DEL PERÍODO",{"$f":"VLOOKUP(C4,NOMINA,5,1)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(C5:J5)","v":0}]
[3,"PREMIO DE ASISTENCIA",{"$f":"VLOOKUP(C4,NOMINA,6,1)","v":{"v":2581.67,"d":"2,581.67"}},{"v":2995.448511045091,"d":"2,995.45"},{"v":840,"d":"840.00"},359.38,{"v":4200,"d":"4,200.00"},{"v":5040,"d":"5,040.00"},{"v":5880,"d":"5,880.00"},{"v":6720,"d":"6,720.00"},{"$f":"SUM(C6:J6)","v":{"v":28616.49851104509,"d":"28,616.50"}}]
[4,"PREMIO DE PUNTUALIDAD",{"$f":"VLOOKUP(C4,NOMINA,7,1)","v":0},{"v":315.13759677844246,"d":"315.14"},{"v":88.25753424657535,"d":"88.26"},{"v":37.710284931506855,"d":"37.71"},{"v":441.28767123287673,"d":"441.29"},{"v":529.5452054794522,"d":"529.55"},{"v":618.6082191780821,"d":"618.61"},{"v":706.9808219178082,"d":"706.98"},{"v":2737.5273337647436,"d":"2,737.53"}]
[5,"AYUDA DE DESPENSA",{"$f":"VLOOKUP(C4,NOMINA,8,1)","v":0},{"v":315.13759677844246,"d":"315.14"},{"v":88.25753424657535,"d":"88.26"},{"v":37.710284931506855,"d":"37.71"},{"v":441.28767123287673,"d":"441.29"},{"v":529.5452054794522,"d":"529.55"},{"v":618.6082191780821,"d":"618.61"},{"v":706.9808219178082,"d":"706.98"},{"v":2737.5273337647436,"d":"2,737.53"}]
[6,"TIEMPO EXTRA",{"$f":"VLOOKUP(C4,NOMINA,9,1)","v":0},{"v":269.416,"d":"269.42"},{"v":230.928,"d":"230.93"},{"v":134.708,"d":"134.71"},{"v":269.416,"d":"269.42"},{"v":269.416,"d":"269.42"},{"v":269.416,"d":"269.42"},{"v":269.416,"d":"269.42"},{"v":1712.716,"d":"1,712.72"}]
[7,"OTRAS PERCEPCIONES",{"$f":"VLOOKUP(C4,NOMINA,10,1)","v":0},{"v":962.822735693065,"d":"962.82"},{"v":315,"d":"315.00"},{"v":231.03000000000003,"d":"231.03"},{"v":1350,"d":"1,350.00"},{"v":1620,"d":"1,620.00"},{"v":1890,"d":"1,890.00"},{"v":2160,"d":"2,160.00"},{"v":8528.852735693064,"d":"8,528.85"}]
[8,"PRIMA DOMINICAL",{"$f":"VLOOKUP(C4,NOMINA,11,1)","v":0},0,0,0,0,0,0,0,0]
[9,"TOTAL DE PERCEPCIONES",{"$f":"SUM(C4:C11)","v":{"v":2582.67,"d":"2,582.67"}},{"$f":"SUM(D4:D11)","v":{"v":4859.962440295041,"d":"4,859.96"}},{"v":1565.4430684931508,"d":"1,565.44"},{"v":804.5385698630137,"d":"804.54"},{"v":6706.991342465754,"d":"6,706.99"},{"v":7994.506410958905,"d":"7,994.51"},{"v":9283.632438356166,"d":"9,283.63"},{"v":10571.377643835616,"d":"10,571.38"},{"v":44369.12191426764,"d":"44,369.12"}]
[10,"TIEMPO EXTRA EXENTO",{"$f":"IF(C9/2>UMA*5,UMA*5,C9/2)","v":0},{"v":134.708,"d":"134.71"},{"v":115.464,"d":"115.46"},{"v":67.354,"d":"67.35"},{"v":134.708,"d":"134.71"},{"v":134.708,"d":"134.71"},{"v":134.708,"d":"134.71"},{"v":134.708,"d":"134.71"},0]
[11,"PRIMA DOMINICAL EXENTA",{"$f":"IF(C11>UMA,UMA,C11)","v":0},0,0,0,0,0,0,0,0]
[12,"BASE GRAVABLE",{"$f":"+C12-C13-C14","v":{"v":2582.67,"d":"2,582.67"}},{"$f":"+D12-D13-D14","v":{"v":4725.254440295042,"d":"4,725.25"}},{"$f":"+E12-E13-E14","v":{"v":1449.9790684931509,"d":"1,449.98"}},{"v":737.1845698630136,"d":"737.18"},{"v":6572.283342465755,"d":"6,572.28"},{"v":7859.798410958905,"d":"7,859.80"},{"v":9148.924438356165,"d":"9,148.92"},{"v":10436.669643835616,"d":"10,436.67"},0]
[13,"LIMITE INFERIOR",{"$f":"VLOOKUP(C15,ISRS,1,1)","v":{"v":2573.56,"d":"2,573.56"}},{"$f":"VLOOKUP(D15,ISRS,1,1)","v":{"v":3081.27,"d":"3,081.27"}},{"v":1259.73,"d":"1,259.73"},148.41,{"v":6214.47,"d":"6,214.47"},{"v":6214.47,"d":"6,214.47"},{"v":6214.47,"d":"6,214.47"},{"v":9794.83,"d":"9,794.83"},0]
[14,"EXCEDENTE DEL L.I.",{"$f":"+C15-C16","v":{"v":9.110000000000127,"d":"9.11"}},{"$f":"+D15-D16","v":{"v":1643.9844402950416,"d":"1,643.98"}},{"v":190.24906849315084,"d":"190.25"},{"v":588.7745698630137,"d":"588.77"},{"v":357.81334246575443,"d":"357.81"},{"v":1645.328410958905,"d":"1,645.33"},{"v":2934.454438356165,"d":"2,934.45"},{"v":641.8396438356158,"d":"641.84"},0]
[15,"% SOBRE EL EXCEDENTE",{"$f":"VLOOKUP(C15,ISRS,4,1)","v":{"v":0.1792,"d":"17.92%"}},{"$f":"VLOOKUP(D15,ISRS,4,1)","v":{"v":0.2136,"d":"21.36%"}},{"v":0.1088,"d":"10.88%"},{"v":0.064,"d":"6.40%"},{"v":0.2352,"d":"23.52%"},{"v":0.2352,"d":"23.52%"},{"v":0.2352,"d":"23.52%"},{"v":0.3,"d":"30.00%"},0]
[16,"IMPUESTO MARGINAL",{"$f":"+C18*C17","v":{"v":1.6325120000000228,"d":"1.63"}},{"$f":"+D18*D17","v":{"v":351.1550764470209,"d":"351.16"}},{"v":20.69909865205481,"d":"20.70"},{"v":37.681572471232876,"d":"37.68"},{"v":84.15769814794544,"d":"84.16"},{"v":386.9812422575344,"d":"386.98"},{"v":690.18368390137,"d":"690.18"},{"v":192.55189315068472,"d":"192.55"},0]
[17,"CUOTA FIJA",{"$f":"VLOOKUP(C15,ISRS,3,1)","v":235.34},{"$f":"VLOOKUP(D15,ISRS,3,1)","v":326.34},73.99,2.87,995.54,995.54,995.54,{"v":1837.64,"d":"1,837.64"},0]
[18,"ISR DEL PERÍODO",{"$f":"+C20+C19","v":{"v":236.97251200000002,"d":"236.97"}},{"$f":"+D20+D19","v":{"v":677.4950764470209,"d":"677.50"}},{"v":94.68909865205481,"d":"94.69"},{"v":40.55157247123287,"d":"40.55"},{"v":1079.6976981479454,"d":"1,079.70"},{"v":1382.5212422575344,"d":"1,382.52"},{"v":1685.72368390137,"d":"1,685.72"},{"v":2030.1918931506848,"d":"2,030.19"},0]
[19,"SUBSIDIO AL EMPLEO",{"$f":"VLOOKUP(C15,SUBSIDIOS,3,1)","v":0},0,58.38,93.66,0,0,0,0,0]
[20,"ISR A RETENER",{"$f":"IF(C21>C22,C21-C22,0)","v":{"v":236.97251200000002,"d":"236.97"}},{"$f":"IF(D21>D22,D21-D22,0)","v":{"v":677.4950764470209,"d":"677.50"}},{"v":36.30909865205481,"d":"36.31"},0,{"v":1079.6976981479454,"d":"1,079.70"},{"v":1382.5212422575344,"d":"1,382.52"},{"v":1685.72368390137,"d":"1,685.72"},{"v":2030.1918931506848,"d":"2,030.19"},{"$f":"SUM(C23:J23)","v":{"v":7128.911204556609,"d":"7,128.91"}}]
[21,"SUBSIDIO PAGADO",{"$f":"IF(C22>C21,C22-C21,0)","v":0},{"$f":"IF(D22>D21,D22-D21,0)","v":0},0,{"v":53.10842752876712,"d":"53.11"},0,0,0,0,{"v":53.10842752876712,"d":"53.11"}]

{"sheet":"TARIFAS","index":2,"n_rows":27,"n_cols":15,"rows_kept":27,"merged":[[1,1,1,4],[1,6,1,9],[1,11,1,14]]}
[]
[null,"TARIFA MENSUAL ISR",{"$nulls":4},"TARIFA QUINCENAL",{"$nulls":4},"TARIFA SEMANAL"]
[null,"Límite Inferior","Límite Superior","Cuota Fija","% sobre excente de límite inferior",null,"Límite Inferior","Límite Superior","Cuota Fija","% sobre excente de límite inferior",null,"Límite Inferior","Límite Superior","Cuota Fija","% sobre excente de límite inferior"]
[null,0.01,644.58,0,{"v":0.0192,"d":"1.92%"},null,0.01,{"v":318,"d":"318.00"},{"$f":"+D4/30.4*15","v":0},{"v":0.0192,"d":"1.92%"},null,0.01,{"v":148.4,"d":"148.40"},{"$f":"+D4/30.4*7","v":0},{"v":0.0192,"d":"1.92%"}]
[null,644.59,{"v":5470.92,"d":"5,470.92"},12.38,{"v":0.064,"d":"6.40%"},null,318.01,{"v":2699.4,"d":"2,699.40"},6.15,{"v":0.064,"d":"6.40%"},null,148.41,{"v":1259.72,"d":"1,259.72"},2.87,{"v":0.064,"d":"6.40%"}]
[null,{"v":5470.93,"d":"5,470.93"},{"v":9614.66,"d":"9,614.66"},321.26,{"v":0.1088,"d":"10.88%"},null,{"v":2699.41,"d":"2,699.41"},{"v":4744.05,"d":"4,744.05"},158.55,{"v":0.1088,"d":"10.88%"},null,{"v":1259.73,"d":"1,259.73"},{"v":2213.89,"d":"2,213.89"},73.99,{"v":0.1088,"d":"10.88%"}]
[null,{"v":9614.67,"d":"9,614.67"},{"v":11176.62,"d":"11,176.62"},{"v":772.1,"d":"772.10"},{"v":0.16,"d":"16.00%"},null,{"v":4744.06,"d":"4,744.06"},{"v":5514.75,"d":"5,514.75"},{"v":381,"d":"381.00"},{"v":0.16,"d":"16.00%"},null,{"v":2213.9,"d":"2,213.90"},{"v":2573.55,"d":"2,573.55"},{"v":177.8,"d":"177.80"},{"v":0.16,"d":"16.00%"}]
[null,{"v":11176.63,"d":"11,176.63"},{"v":13381.47,"d":"13,381.47"},{"v":1022.01,"d":"1,022.01"},{"v":0.1792,"d":"17.92%"},null,{"v":5514.76,"d":"5,514.76"},{"v":6602.7,"d":"6,602.70"},{"v":504.3,"d":"504.30"},{"v":0.1792,"d":"17.92%"},null,{"v":2573.56,"d":"2,573.56"},{"v":3081.26,"d":"3,081.26"},235.34,{"v":0.1792,"d":"17.92%"}]
[null,{"v":13381.48,"d":"13,381.48"},{"v":26988.5,"d":"26,988.50"},{"v":1417.12,"d":"1,417.12"},{"v":0.2136,"d":"21.36%"},null,{"v":6602.71,"d":"6,602.71"},{"v":13316.7,"d":"13,316.70"},{"v":699.3,"d":"699.30"},{"v":0.2136,"d":"21.36%"},null,{"v":3081.27,"d":"3,081.27"},{"v":6214.46,"d":"6,214.46"},326.34,{"v":0.2136,"d":"21.36%"}]
[null,{"v":26988.51,"d":"26,988.51"},{"v":42537.58,"d":"42,537.58"},{"v":4323.58,"d":"4,323.58"},{"v":0.2352,"d":"23.52%"},null,{"v":13316.71,"d":"13,316.71"},{"v":20988.9,"d":"20,988.90"},{"v":2133.3,"d":"2,133.30"},{"v":0.2352,"d":"23.52%"},null,{"v":6214.47,"d":"6,214.47"},{"v":9794.82,"d":"9,794.82"},995.54,{"v":0.2352,"d":"23.52%"}]
[null,{"v":42537.59,"d":"42,537.59"},{"v":81211.25,"d":"81,211.25"},{"v":7980.73,"d":"7,980.73"},{"v":0.3,"d":"30.00%"},null,{"v":20988.91,"d":"20,988.91"},{"v":40071.3,"d":"40,071.30"},{"v":3937.8,"d":"3,937.80"},{"v":0.3,"d":"30.00%"},null,{"v":9794.83,"d":"9,794.83"},{"v":18699.94,"d":"18,699.94"},{"v":1837.64,"d":"1,837.64"},{"v":0.3,"d":"30.00%"}]
[null,{"v":81211.26,"d":"81,211.26"},{"v":108281.67,"d":"108,281.67"},{"v":19582.83,"d":"19,582.83"},{"v":0.32,"d":"32.00%"},null,{"v":40071.31,"d":"40,071.31"},{"v":53428.5,"d":"53,428.50"},{"v":9662.55,"d":"9,662.55"},{"v":0.32,"d":"32.00%"},null,{"v":18699.95,"d":"18,699.95"},{"v":24933.3,"d":"24,933.30"},{"v":4509.19,"d":"4,509.19"},{"v":0.32,"d":"32.00%"}]
[null,{"v":108281.68,"d":"108,281.68"},{"v":324845.01,"d":"324,845.01"},{"v":28245.36,"d":"28,245.36"},{"v":0.34,"d":"34.00%"},null,{"v":53428.51,"d":"53,428.51"},{"v":160285.35,"d":"160,285.35"},{"v":13936.8,"d":"13,936.80"},{"v":0.34,"d":"34.00%"},null,{"v":24933.31,"d":"24,933.31"},{"v":74799.83,"d":"74,799.83"},{"v":6503.84,"d":"6,503.84"},{"v":0.34,"d":"34.00%"}]
[null,{"v":324845.02,"d":"324,845.02"},"En adelante",{"v":101876.9,"d":"101,876.90"},{"v":0.35,"d":"35.00%"},null,{"v":160285.36,"d":"160,285.36"},"En adelante",{"v":50268.15,"d":"50,268.15"},{"v":0.35,"d":"35.00%"},null,{"v":74799.84,"d":"74,799.84"},"En adelante",{"v":23458.47,"d":"23,458.47"},{"v":0.35,"d":"35.00%"}]
[]
[null,"Para Ingresos de:","Hasta Ingresos de:","Cantidad de subsidio para el empleo mensual",null,null,"Para Ingresos de:","Hasta Ingresos de:","Cantidad de subsidio para el empleo mensual",null,null,"Para Ingresos de:","Hasta Ingresos de:","Cantidad de subsidio para el empleo mensual"]
[null,0.01,{"v":1768.96,"d":"1,768.96"},407.02,null,null,0.01,872.85,200.85,null,null,0.01,407.33,93.73]
[null,{"v":1768.97,"d":"1,768.97"},{"v":2653.38,"d":"2,653.38"},406.83,null,null,872.86,{"v":1309.2,"d":"1,309.20"},{"v":200.7,"d":"200.70"},null,null,407.34,610.96,93.66]
[null,{"v":2653.39,"d":"2,653.39"},{"v":3472.84,"d":"3,472.84"},406.62,null,null,{"v":1309.21,"d":"1,309.21"},{"v":1713.6,"d":"1,713.60"},{"v":200.7,"d":"200.70"},null,null,610.97,799.68,93.66]
[null,{"v":3472.85,"d":"3,472.85"},{"v":3537.87,"d":"3,537.87"},392.77,null,null,{"v":1713.61,"d":"1,713.61"},{"v":1745.7,"d":"1,745.70"},{"v":193.8,"d":"193.80"},null,null,799.69,814.66,90.44]
[null,{"v":3537.88,"d":"3,537.88"},{"v":4446.15,"d":"4,446.15"},382.46,null,null,{"v":1745.71,"d":"1,745.71"},{"v":2193.75,"d":"2,193.75"},{"v":188.7,"d":"188.70"},null,null,814.67,{"v":1023.75,"d":"1,023.75"},88.06]
[null,{"v":4446.16,"d":"4,446.16"},{"v":4717.18,"d":"4,717.18"},354.23,null,null,{"v":2193.76,"d":"2,193.76"},{"v":2327.55,"d":"2,327.55"},174.75,null,null,{"v":1023.76,"d":"1,023.76"},{"v":1086.19,"d":"1,086.19"},81.55]
[null,{"v":4717.19,"d":"4,717.19"},{"v":5335.42,"d":"5,335.42"},324.87,null,null,{"v":2327.56,"d":"2,327.56"},{"v":2632.65,"d":"2,632.65"},160.35,null,null,{"v":1086.2,"d":"1,086.20"},{"v":1228.57,"d":"1,228.57"},74.83]
[null,{"v":5335.43,"d":"5,335.43"},{"v":6224.67,"d":"6,224.67"},294.63,null,null,{"v":2632.66,"d":"2,632.66"},{"v":3071.4,"d":"3,071.40"},145.35,null,null,{"v":1228.58,"d":"1,228.58"},{"v":1433.32,"d":"1,433.32"},67.83]
[null,{"v":6224.68,"d":"6,224.68"},{"v":7113.9,"d":"7,113.90"},253.54,null,null,{"v":3071.41,"d":"3,071.41"},{"v":3510.15,"d":"3,510.15"},{"v":125.1,"d":"125.10"},null,null,{"v":1433.33,"d":"1,433.33"},{"v":1638.07,"d":"1,638.07"},58.38]
[null,{"v":7113.91,"d":"7,113.91"},{"v":7382.33,"d":"7,382.33"},217.61,null,null,{"v":3510.16,"d":"3,510.16"},{"v":3642.6,"d":"3,642.60"},{"v":107.4,"d":"107.40"},null,null,{"v":1638.08,"d":"1,638.08"},{"v":1699.88,"d":"1,699.88"},50.12]
[null,{"v":7382.34,"d":"7,382.34"},"En adelante",0,null,null,{"v":3642.61,"d":"3,642.61"},"En adelante",{"$f":"+D27/30.4*15","v":0},null,null,{"v":1699.89,"d":"1,699.89"},"En adelante",{"$f":"+D27/30.4*7","v":0}]

{"sheet":"IMSS","index":3,"n_rows":21,"n_cols":27,"rows_kept":21,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4],[5,1,5,26],[6,1,6,26],[7,1,10,1],[7,2,10,2],[7,3,10,3],[7,4,10,4],[7,5,10,5],[7,6,7,14],[7,15,8,16],[7,17,8,17],[7,18,8,18],[7,19,8,20],[7,21,8,21],[7,22,8,23],[7,24,8,24],[7,25,8,26],[8,7,8,8],[8,9,8,10],[8,11,8,12],[8,13,8,14],[9,13,10,13],[9,14,10,14],[9,22,10,22],[9,23,10,23],[9,25,10,25],[9,26,10,26]]}
[]
[null,"SALARIO MÍNIMO",{"$nulls":3},172.87]
[null,"UMA DIARIA",{"$nulls":3},96.22]
[null,"3 UMAS",{"$nulls":3},{"$f":"+F3*3","v":288.65999999999997}]
[]
[null,"EMPRESA \"X\""]
[null,"DETERMINACIÓN DE CUOTAS OBRERO PATRONALES IMSS - INFONAVIT"]
[null,"No.","SALARIO DIARIO","SALARIO DIARIO INTEGRADO","DIAS TRABAJADOS","SALARIO BASE DE COTIZACIÓN","ENFERMEDADES Y MATERNIDAD",{"$nulls":8},"INVALIDEZ Y VIDA",null,"GUARDERIAS","RETIRO","CESANTÍA Y VEJEZ",null,"RIESGO DE TRABAJO","TOTAL",null,"INFONAVIT","TOTAL"]
[{"$nulls":6},"CUOTA FIJA","EXCEDENTE DE 3 UMAS",null,"PRESTACIONES EN DINERO",null,"RESERVA DE PENSIONADOS",null,"TOTAL"]
[{"$nulls":6},"PATRÓN","PATRÓN","TRABAJADOR","PATRÓN","TRABAJADOR","PATRÓN","TRABAJADOR","PATRÓN","TRABAJADOR","PATRÒN","TRABAJADOR","PATRÓN","PATRÓN","PATRÓN ","TRABAJADOR","PATRÓN","PATRÓN","TRABAJADOR","PATRÓN","PATRÓN","TRABAJADOR"]
[{"$nulls":6},{"v":0.204,"d":"20.400%"},{"v":0.011,"d":"1.100%"},{"v":0.004,"d":"0.400%"},{"v":0.007,"d":"0.700%"},{"v":0.0025,"d":"0.250%"},{"v":0.0105,"d":"1.050%"},{"v":0.00375,"d":"0.375%"},null,null,{"v":0.0175,"d":"1.750%"},{"v":0.0065,"d":"0.650%"},{"v":0.01,"d":"1.000%"},{"v":0.02,"d":"2.000%"},{"v":0.0315,"d":"3.150%"},{"v":0.01125,"d":"1.125%"},{"v":0.015984,"d":"1.5984%"},null,null,{"v":0.05,"d":"5%"}]
[null,1,{"$f":"VLOOKUP(B12,NOMINA,3,0)","v":368.81},{"$f":"VLOOKUP(B12,SDI,9,1)","v":{"v":379.32887671232874,"d":"379.33"}},31,{"$f":"+E12*D12","v":{"v":11759.195178082191,"d":"11,759.20"}},{"$f":"+$G$11*E12*SM","v":{"v":1093.22988,"d":"1,093.23"}},{"$f":"IF($D12>TUMA,($D12-TUMA)*H$11*$E12,0)","v":{"v":30.91808695890411,"d":"30.92"}},{"$f":"IF($D12>TUMA,($D12-TUMA)*I$11*$E12,0)","v":{"v":11.242940712328767,"d":"11.24"}},{"$f":"+J$11*$F12","v":{"v":82.31436624657533,"d":"82.31"}},{"$f":"+K$11*$F12","v":{"v":29.39798794520548,"d":"29.40"}},{"$f":"+L$11*$F12","v":{"v":123.47154936986301,"d":"123.47"}},{"v":44.096981917808215,"d":"44.10"},{"$f":"+G12+H12+J12+L12","v":{"v":1329.9338825753423,"d":"1,329.93"}},{"$f":"+I12+K12+M12","v":{"v":84.73791057534245,"d":"84.74"}},{"$f":"+P$11*$F12","v":{"v":205.78591561643836,"d":"205.79"}},{"v":76.43476865753424,"d":"76.43"},{"$f":"+R$11*$F12","v":{"v":117.59195178082192,"d":"117.59"}},{"v":235.18390356164383,"d":"235.18"},{"v":370.414648109589,"d":"370.41"},{"v":132.29094575342464,"d":"132.29"},{"v":187.95897572646575,"d":"187.96"},{"$f":"+N12+P12+R12+S12+T12+V12","v":{"v":2446.869277370301,"d":"2,446.87"}},{"$f":"+O12+Q12+U12","v":{"v":293.46362498630134,"d":"293.46"}},{"$f":"+Y$11*$F12","v":{"v":587.9597589041095,"d":"587.96"}},{"$f":"+Y12+W12","v":{"v":3034.8290362744106,"d":"3,034.83"}},{"$f":"+X12","v":{"v":293.46362498630134,"d":"293.46"}}]
[null,2,{"v":427.92121586358445,"d":"427.92"},{"v":450.1965668263463,"d":"450.20"},7,{"$f":"+E13*D13","v":{"v":3151.375967784424,"d":"3,151.38"}},{"$f":"+$G$11*E13*SM","v":{"v":246.85836,"d":"246.86"}},{"$f":"IF($D13>TUMA,($D13-TUMA)*H$11*$E13,0)","v":{"v":12.438315645628668,"d":"12.44"}},{"v":4.523023871137698,"d":"4.52"},{"$f":"+J$11*$F13","v":{"v":22.05963177449097,"d":"22.06"}},{"v":7.87843991946106,"d":"7.88"},{"v":33.08944766173646,"d":"33.09"},{"v":11.81765987919159,"d":"11.82"},{"$f":"+G13+H13+J13+L13","v":{"v":314.44575508185613,"d":"314.45"}},{"$f":"+I13+K13+M13","v":{"v":24.21912366979035,"d":"24.22"}},{"v":55.149079436227424,"d":"55.15"},{"v":20.483943790598754,"d":"20.48"},{"v":31.51375967784424,"d":"31.51"},{"v":63.02751935568848,"d":"63.03"},{"v":99.26834298520936,"d":"99.27"},{"v":35.45297963757477,"d":"35.45"},{"v":50.37159346906624,"d":"50.37"},{"$f":"+N13+P13+R13+S13+T13+V13","v":{"v":613.7760500058919,"d":"613.78"}},{"$f":"+O13+Q13+U13","v":{"v":80.15604709796388,"d":"80.16"}},{"v":157.56879838922123,"d":"157.57"},{"$f":"+Y13+W13","v":{"v":771.3448483951131,"d":"771.34"}},{"$f":"+X13","v":{"v":80.15604709796388,"d":"80.16"}}]
[null,3,{"v":140,"d":"140.00"},{"v":147.0958904109589,"d":"147.10"},7,{"v":1029.6712328767123,"d":"1,029.67"},{"v":246.85836,"d":"246.86"},0,0,{"v":7.207698630136987,"d":"7.21"},{"v":2.574178082191781,"d":"2.57"},{"v":10.811547945205481,"d":"10.81"},{"v":3.861267123287671,"d":"3.86"},{"v":264.87760657534244,"d":"264.88"},{"v":6.435445205479452,"d":"6.44"},{"v":18.019246575342468,"d":"18.02"},{"v":6.69286301369863,"d":"6.69"},{"v":10.296712328767123,"d":"10.30"},{"v":20.593424657534246,"d":"20.59"},{"v":32.43464383561644,"d":"32.43"},{"v":11.583801369863014,"d":"11.58"},{"v":16.458264986301373,"d":"16.46"},{"v":362.6798989589041,"d":"362.68"},{"v":24.712109589041095,"d":"24.71"},{"v":51.48356164383562,"d":"51.48"},{"v":414.16346060273975,"d":"414.16"},{"v":24.712109589041095,"d":"24.71"}]
[null,4,102.68,{"v":107.74367123287672,"d":"107.74"},7,{"v":754.205698630137,"d":"754.21"},{"v":246.85836,"d":"246.86"},0,0,{"v":5.279439890410959,"d":"5.28"},{"v":1.8855142465753425,"d":"1.89"},{"v":7.91915983561644,"d":"7.92"},{"v":2.8282713698630135,"d":"2.83"},{"v":260.0569597260274,"d":"260.06"},{"v":4.713785616438356,"d":"4.71"},{"v":13.1985997260274,"d":"13.20"},{"v":4.90233704109589,"d":"4.90"},{"v":7.54205698630137,"d":"7.54"},{"v":15.08411397260274,"d":"15.08"},{"v":23.757479506849318,"d":"23.76"},{"v":8.484814109589042,"d":"8.48"},{"v":12.05522388690411,"d":"12.06"},{"v":331.69443380471233,"d":"331.69"},{"v":18.100936767123287,"d":"18.10"},{"v":37.710284931506855,"d":"37.71"},{"v":369.4047187362192,"d":"369.40"},{"v":18.100936767123287,"d":"18.10"}]
[null,5,{"v":600,"d":"600.00"},{"v":630.4109589041096,"d":"630.41"},7,{"v":4412.876712328767,"d":"4,412.88"},{"v":246.85836,"d":"246.86"},{"v":26.31482383561644,"d":"26.31"},{"v":9.56902684931507,"d":"9.57"},{"v":30.89013698630137,"d":"30.89"},{"v":11.032191780821918,"d":"11.03"},{"v":46.33520547945206,"d":"46.34"},{"v":16.548287671232877,"d":"16.55"},{"v":350.3985263013699,"d":"350.40"},{"v":37.14950630136987,"d":"37.15"},{"v":77.22534246575343,"d":"77.23"},{"v":28.683698630136984,"d":"28.68"},{"v":44.12876712328767,"d":"44.13"},{"v":88.25753424657535,"d":"88.26"},{"v":139.00561643835616,"d":"139.01"},{"v":49.644863013698625,"d":"49.64"},{"v":70.53542136986302,"d":"70.54"},{"v":769.5512079452054,"d":"769.55"},{"v":115.47806794520548,"d":"115.48"},{"v":220.64383561643837,"d":"220.64"},{"v":990.1950435616438,"d":"990.20"},{"v":115.47806794520548,"d":"115.48"}]
[null,6,{"v":720,"d":"720.00"},{"v":756.4931506849316,"d":"756.49"},7,{"v":5295.452054794521,"d":"5,295.45"},{"v":246.85836,"d":"246.86"},{"v":36.023152602739735,"d":"36.02"},{"v":13.099328219178085,"d":"13.10"},{"v":37.06816438356165,"d":"37.07"},{"v":13.238630136986304,"d":"13.24"},{"v":55.60224657534248,"d":"55.60"},{"v":19.857945205479453,"d":"19.86"},{"v":375.55192356164383,"d":"375.55"},{"v":46.195903561643846,"d":"46.20"},{"v":92.67041095890413,"d":"92.67"},{"v":34.42043835616439,"d":"34.42"},{"v":52.954520547945215,"d":"52.95"},{"v":105.90904109589043,"d":"105.91"},{"v":166.80673972602742,"d":"166.81"},{"v":59.57383561643836,"d":"59.57"},{"v":84.64250564383563,"d":"84.64"},{"v":878.5351415342467,"d":"878.54"},{"v":140.19017753424657,"d":"140.19"},{"v":264.7726027397261,"d":"264.77"},{"v":1143.3077442739727,"d":"1,143.31"},{"v":140.19017753424657,"d":"140.19"}]
[null,7,{"v":840,"d":"840.00"},{"v":883.7260273972602,"d":"883.73"},7,{"v":6186.082191780821,"d":"6,186.08"},{"v":246.85836,"d":"246.86"},{"v":45.82008410958903,"d":"45.82"},{"v":16.661848767123285,"d":"16.66"},{"v":43.302575342465744,"d":"43.30"},{"v":15.465205479452052,"d":"15.47"},{"v":64.95386301369862,"d":"64.95"},{"v":23.19780821917808,"d":"23.20"},{"v":400.9348824657534,"d":"400.93"},{"v":55.32486246575342,"d":"55.32"},{"v":108.25643835616437,"d":"108.26"},{"v":40.20953424657533,"d":"40.21"},{"v":61.86082191780821,"d":"61.86"},{"v":123.72164383561642,"d":"123.72"},{"v":194.86158904109584,"d":"194.86"},{"v":69.59342465753423,"d":"69.59"},{"v":98.87833775342465,"d":"98.88"},{"v":988.5137133698628,"d":"988.51"},{"v":165.12782136986297,"d":"165.13"},{"v":309.30410958904105,"d":"309.30"},{"v":1297.817822958904,"d":"1,297.82"},{"v":165.12782136986297,"d":"165.13"}]
[null,8,{"v":960,"d":"960.00"},{"v":1009.972602739726,"d":"1,009.97"},7,{"v":7069.808219178081,"d":"7,069.81"},{"v":246.85836,"d":"246.86"},{"v":55.541070410958895,"d":"55.54"},{"v":20.196752876712328,"d":"20.20"},{"v":49.48865753424657,"d":"49.49"},{"v":17.674520547945203,"d":"17.67"},{"v":74.23298630136986,"d":"74.23"},{"v":26.511780821917803,"d":"26.51"},{"v":426.1210742465753,"d":"426.12"},{"v":64.38305424657534,"d":"64.38"},{"v":123.72164383561643,"d":"123.72"},{"v":45.95375342465753,"d":"45.95"},{"v":70.69808219178081,"d":"70.70"},{"v":141.39616438356163,"d":"141.40"},{"v":222.69895890410956,"d":"222.70"},{"v":79.53534246575342,"d":"79.54"},{"v":113.00381457534246,"d":"113.00"},{"v":1097.6397381369861,"d":"1,097.64"},{"v":189.87215013698628,"d":"189.87"},{"v":353.4904109589041,"d":"353.49"},{"v":1451.1301490958901,"d":"1,451.13"},{"v":189.87215013698628,"d":"189.87"}]
[]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26]

{"sheet":"SDI","index":4,"n_rows":20,"n_cols":18,"rows_kept":20,"merged":[[1,1,1,2],[3,1,3,9],[4,1,4,9],[6,15,6,17]]}
[]
[null,"FECHA ACTUAL",null,{"$f":"TODAY()","v":"2022-01-27"}]
[]
[null,{"$f":"+IMSS!B6","v":"EMPRESA \"X\""}]
[null,"DETERMINACIÓN DEL SALARIO DIARIO INTEGRADO"]
[null,"No.","SALARIO DIARIO","FECHA DE INGRESO","ANTIGÜEDAD (AÑOS)","DÍAS DE VACACIONES","PRIMA VACACIONAL","DÍAS DE AGUINALDO","FACTOR DE INTEGRACIÓN","SALARIO DIARIO INTEGRADO"]
[null,1,360.56,"2012-03-25",{"$f":"DATEDIF(D7,$D$2,\"Y\")+(DATEDIF(D7,$D$2,\"YM\")/12)","v":{"v":9.833333333333334,"d":"9.83"}},{"$f":"VLOOKUP(E7,VACACIONES,3,1)","v":{"v":16,"d":"16.00"}},{"$f":"+F7*0.25","v":{"v":4,"d":"4.00"}},{"v":15,"d":"15.00"},{"$f":"+(365+G7+H7)/365","v":{"v":1.0520547945205478,"d":"1.0521"}},{"$f":"+I7*C7","v":{"v":379.32887671232874,"d":"379.33"}},{"$nulls":5},"VACACIONES"]
[null,2,{"$f":"VLOOKUP(B8,NOMINA,3,0)","v":{"v":427.92121586358445,"d":"427.92"}},"2010-01-14",{"$f":"DATEDIF(D8,$D$2,\"Y\")+(DATEDIF(D8,$D$2,\"YM\")/12)","v":{"v":12,"d":"12.00"}},{"v":16,"d":"16.00"},{"$f":"+F8*0.25","v":{"v":4,"d":"4.00"}},{"v":15,"d":"15.00"},{"$f":"+(365+G8+H8)/365","v":{"v":1.0520547945205478,"d":"1.0521"}},{"$f":"+I8*C8","v":{"v":450.1965668263463,"d":"450.20"}},{"$nulls":5},"DESDE","HASTA","DÍAS"]
[null,3,{"v":140,"d":"140.00"},"2015-04-15",6.75,{"v":14,"d":"14.00"},{"v":3.5,"d":"3.50"},{"v":15,"d":"15.00"},{"v":1.0506849315068494,"d":"1.0507"},{"v":147.0958904109589,"d":"147.10"},{"$nulls":5},0,1,6]
[null,4,102.68,"2018-06-18",{"v":3.5833333333333335,"d":"3.58"},{"v":12,"d":"12.00"},{"v":3,"d":"3.00"},{"v":15,"d":"15.00"},{"v":1.0493150684931507,"d":"1.0493"},{"v":107.74367123287672,"d":"107.74"},{"$nulls":5},{"$f":"+Q9+0.01","v":1.01},{"$f":"+Q9+1","v":2},{"$f":"+R9+2","v":8}]
[null,5,{"v":600,"d":"600.00"},"2016-03-15",{"v":5.833333333333333,"d":"5.83"},{"v":14,"d":"14.00"},{"v":3.5,"d":"3.50"},{"v":15,"d":"15.00"},{"v":1.0506849315068494,"d":"1.0507"},{"v":630.4109589041096,"d":"630.41"},{"$nulls":5},{"$f":"+Q10+0.01","v":2.01},{"$f":"+Q10+1","v":3},{"$f":"+R10+2","v":10}]
[null,6,{"v":720,"d":"720.00"},"2017-05-17",{"v":4.666666666666667,"d":"4.67"},{"v":14,"d":"14.00"},{"v":3.5,"d":"3.50"},{"v":15,"d":"15.00"},{"v":1.0506849315068494,"d":"1.0507"},{"v":756.4931506849316,"d":"756.49"},{"$nulls":5},3.01,4,12]
[null,7,{"v":840,"d":"840.00"},"2012-03-31",9.75,{"v":16,"d":"16.00"},{"v":4,"d":"4.00"},{"v":15,"d":"15.00"},{"v":1.0520547945205478,"d":"1.0521"},{"v":883.7260273972602,"d":"883.73"},{"$nulls":5},{"$f":"+Q12+0.01","v":4.01},{"$f":"+Q12+5","v":9},{"$f":"+R12+2","v":14}]
[null,8,{"v":960,"d":"960.00"},"2012-04-01",9.75,{"v":16,"d":"16.00"},{"v":4,"d":"4.00"},{"v":15,"d":"15.00"},{"v":1.0520547945205478,"d":"1.0521"},{"v":1009.972602739726,"d":"1,009.97"},{"$nulls":5},{"$f":"+Q13+0.01","v":9.01},{"$f":"+Q13+5","v":14},{"$f":"+R13+2","v":16}]
[{"$nulls":15},14.01,19,18]
[{"$nulls":15},19.01,24,20]
[{"$nulls":15},24.01,29,22]
[{"$nulls":15},29.01,34,24]
[{"$nulls":15},{"$f":"+Q18+0.01","v":34.01},{"$f":"+Q18+5","v":39},{"$f":"+R18+2","v":26}]
[{"$nulls":15},39.01,{"$f":"+Q19+5","v":44},{"$f":"+R19+2","v":28}]