{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cuotas TD RO","Cálculos TD RO"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Cuotas TD RO","index":0,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[14,2,14,3],[12,2,12,3],[13,2,13,3],[5,2,5,3],[3,2,3,7],[7,6,7,7],[27,2,27,4],[9,2,9,7],[26,2,26,7],[24,2,24,3],[10,6,10,7],[19,2,19,3],[10,2,11,3],[10,4,11,4],[22,2,22,3],[23,2,23,3],[15,2,15,3],[21,2,21,3],[20,2,20,3],[16,2,16,3],[17,2,17,3],[18,2,18,3]]}
["Calculadora para trabajadores del hogar"]
[]
[]
[null,null,"Instrucciones: Selecciona el mes que deseas calcular, captura tu salario mensual, el nombre del patrón y los días que laboras durante el mes con cada uno."]
[]
[null,null,"Mes a calcular",null,"Mayo",null,"Días del periodo",{"$f":"VLOOKUP(E6,'Cálculos TD RO'!J1:K12,2,FALSE)","v":31}]
[]
[null,null,"Salario Mensual"]
[]
[null,null,{"$f":"IF(OR(E8<'Cálculos TD RO'!$E$1, E8>'Cálculos TD RO'!$E$2),\"El salario mensual mínimo debe ser de \" & TEXT('Cálculos TD RO'!$E$1, \"$##,###.00\") & \", y el máximo de \" & TEXT('Cálculos TD RO'!$E$2, \"$##,###.00\"),\"\")","v":"El salario mensual mínimo debe ser de $3,183.08, y el máximo de $65,479.75"}]
[null,null,"Nombre del empleador",null,"Días laborados en el mes",null,"Cuotas"]
[null,null,null,null,null,null,"Empleado","Empleador"]
[null,null,"Luis Rubén Martínez Castañeda",null,1,null,{"$f":"IF(OR(E13=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!D38)","v":""},{"$f":"IF(OR(E13=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!E38)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(E14=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!D39)","v":""},{"$f":"IF(OR(E14=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!E39)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(E15=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!D40)","v":""},{"$f":"IF(OR(E15=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!E40)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(E16=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!D41)","v":""},{"$f":"IF(OR(E16=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!E41)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(E17=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!D42)","v":""},{"$f":"IF(OR(E17=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!E42)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(E18=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!D43)","v":""},{"$f":"IF(OR(E18=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!E43)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(E19=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!D44)","v":""},{"$f":"IF(OR(E19=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!E44)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(E20=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!D45)","v":""},{"$f":"IF(OR(E20=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!E45)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(E21=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!D46)","v":""},{"$f":"IF(OR(E21=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!E46)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(E22=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!D47)","v":""},{"$f":"IF(OR(E22=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!E47)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(E23=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!D48)","v":""},{"$f":"IF(OR(E23=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!E48)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(E24=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!D49)","v":""},{"$f":"IF(OR(E24=\"\", $E$25=0, $E$8<'Cálculos TD RO'!$E$1),\"\", 'Cálculos TD RO'!E49)","v":""}]
[null,null,"Número de días",null,{"$f":"SUM(E13:E24)","v":1},null,{"$f":"IF(OR($E$25=0, $E$8<'Cálculos TD RO'!$E$1), \"\",SUM(G13:G24))","v":""},{"$f":"IF(OR($E$25=0,$E$8<'Cálculos TD RO'!$E$1),\"\",SUM(H13:H24))","v":""}]
[]
[null,null,{"$f":"IF(E25=0,\"El número total de días laborados debe ser de al menos 1 día.\",\"\")","v":""}]
[null,null,null,null,null,null,"Total a pagar",{"$f":"SUM(G25:H25)","v":0}]

{"sheet":"Cálculos TD RO","index":1,"n_rows":51,"n_cols":20,"rows_kept":51,"cut":false,"hidden":true,"merged":[[27,0,27,2]]}
["S.M.D.F.",null,null,102.68,{"$f":"D1*'Cuotas TD RO'!H6","v":3183.0800000000004},null,null,null,null,"Enero",31]
["UMA",null,null,{"$f":" IF(UPPER('Cuotas TD RO'!$E$6) = \"ENERO\",80.6,84.49)","v":84.49},{"$f":"D2*25*'Cuotas TD RO'!H6","v":65479.75},null,null,null,null,"Febrero",28]
["LÍMITE S.B.C.",null,null,25,null,null,null,null,null,"Marzo",31]
["LÍMITE S.B.C. SUBSIDIO",null,null,0,null,null,null,null,null,"Abril",30]
["Subsidio",null,null,0,null,null,null,null,null,"Mayo",31]
[null,null,null,null,null,null,null,null,null,"Junio",30]
[null,null,null,"Prima",null,null,null,null,null,"Julio",31]
["C.F.",null,null,0.20399999999999999,null,null,null,null,null,"Agosto",31]
["Exc. Pat.",null,null,1.1000000000000001E-2,null,null,null,null,null,"Septiembre",30]
["Exc. Ob.",null,null,4.0000000000000001E-3,null,null,null,null,null,"Octubre",31]
["P.D. Pat.",null,null,6.9999999999999993E-3,null,null,null,null,null,"Noviembre",30]
["P.D. Ob.",null,null,2.5000000000000001E-3,null,null,null,null,null,"Diciembre",31]
["G.M.P. Pat.",null,null,1.0500000000000001E-2]
["G.M.P. Ob.",null,null,3.7499999999999999E-3]
["R.T.",null,null,5.4355000000000002E-3]
["I.V. Pat.",25,{"$f":"+B16*D2","v":2112.25},1.7500000000000002E-2]
["I.V. Ob.",25,{"$f":"+B17*D2","v":2112.25},6.2500000000000003E-3]
["G.P.S.",null,null,0.01]
["Retiro",null,null,0.02]
["C.V. Pat.",null,null,3.15E-2]
["C.V. Obr.",null,null,1.125E-2]
["Aport. Pat. INFONAVIT",null,null,0]
[]
[]
["Salario","25 VSMDF","ART 28 Y 25 TRANS","Días","Aus.","Inc.","C.F.","Exc. Pat.","Exc. Ob.","P.D. Pat.","P.D. Ob.","G.M.P. Pat.","G.M.P. Ob.","R.T.","I.V. Pat.","I.V. Ob.","G.P.S.","Patronal","Obrera","Total COP"]
[{"$f":"formatoSUA('Cuotas TD RO'!E8/D26)","v":0},{"$f":"IF(A26>($B$16*$D$2),$B$16*$D$2,A26)","v":0},{"$f":"IF(A26>($B$16*$D$2),$B$16*$D$2,A26)","v":0},{"$f":"VLOOKUP('Cuotas TD RO'!$E$6,$J$1:$K$12,2,FALSE)","v":31},0,0,{"$f":"formatoSUA($D$2*(D26-F26)*$D$8)","v":534.30999999999995},{"$f":"formatoSUA(IF(B26>(3*$D$2),((B26-(3*$D$2))*(D26-F26)*$D$9),0))","v":0},{"$f":"formatoSUA(IF(B26>(3*$D$2),((B26-(3*$D$2))*(D26-F26)*$D$10),0))","v":0},{"$f":"formatoSUA(B26*(D26-F26)*$D$11)","v":0},{"$f":"formatoSUA(B26*(D26-F26)*$D$12)","v":0},{"$f":"formatoSUA(B26*(D26-F26)*$D$13)","v":0},{"$f":"formatoSUA(B26*(D26-F26)*$D$14)","v":0},{"$f":"formatoSUA(B26*(D26-(E26+F26))*$D$15)","v":0},{"$f":"formatoSUA(C26*(D26-(E26+F26))*$D$16)","v":0},{"$f":"formatoSUA(C26*(D26-(E26+F26))*$D$17)","v":0},{"$f":"formatoSUA(B26*(D26-(E26+F26))*$D$18)","v":0},{"$f":"G26+H26+J26+L26+N26+O26+Q26","v":534.30999999999995},{"$f":"I26+K26+M26+P26","v":0},{"$f":"R26+S26","v":534.30999999999995}]
[{"$f":"A26","v":0},{"$f":"IF(A27>($D$4*$D$2),$D$4*$D$2,A27)","v":0},{"$f":"IF(A27>($D$4*$D$2),$D$4*$D$2,A27)","v":0},{"$f":"D26","v":31},0,0,{"$f":"TRUNC(formatoSUA($D$2*(D27-F27)*$D$8)*$D$5,2)","v":0},{"$f":"TRUNC(formatoSUA(IF(B27>(3*$D$2),((B27-(3*$D$2))*(D27-F27)*$D$9),0))*$D$5,2)","v":0},{"$f":"TRUNC(formatoSUA(IF(B27>(3*$D$2),((B27-(3*$D$2))*(D27-F27)*$D$10),0))*$D$5,2)","v":0},{"$f":"TRUNC(formatoSUA(B27*(D27-F27)*$D$11)*$D$5,2)","v":0},{"$f":"TRUNC(formatoSUA(B27*(D27-F27)*$D$12)*$D$5,2)","v":0},{"$f":"TRUNC(formatoSUA(B27*(D27-F27)*$D$13)*$D$5,2)","v":0},{"$f":"TRUNC(formatoSUA(B27*(D27-F27)*$D$14)*$D$5,2)","v":0},{"$f":"TRUNC(formatoSUA(B27*(D27-(E27+F27))*$D$15)*$D$5,2)","v":0},{"$f":"TRUNC(formatoSUA(C27*(D27-(E27+F27))*$D$16)*$D$5,2)","v":0},{"$f":"TRUNC(formatoSUA(C27*(D27-(E27+F27))*$D$17)*$D$5,2)","v":0},{"$f":"TRUNC(formatoSUA(B27*(D27-(E27+F27))*$D$18)*$D$5,2)","v":0},{"$f":"G27+H27+J27+L27+N27+O27+Q27","v":0},{"$f":"I27+K27+M27+P27","v":0},{"$f":"R27+S27","v":0}]
["TOTAL",null,null,{"$f":"D27","v":31},{"$f":"SUM(E26:E27)","v":0},{"$f":"SUM(F26:F27)","v":0},{"$f":"G26-G27","v":534.30999999999995},{"$f":"H26-H27","v":0},0,0,0,0,0,0,0,0,0,534.30999999999995,0,534.30999999999995]
[]
[]
["Salario","25 VSMDF","20 VSMDF","Días","Aus.","Inc.","Retiro","C.V. Pat.","C.V. Obr.","SUMA RCV","Aportación","Tot. Pat.","Tot. Obr.","TOTAL RCV INFONAVIT"]
[{"$f":"A26","v":0},{"$f":"IF(A32>($B$16*$D$2),$B$16*$D$2,A32)","v":0},{"$f":"IF(A32>($D$3*$D$2),$D$3*$D$2,A32)","v":0},{"$f":"D26","v":31},0,0,{"$f":"formatoSUA(B32*(D32-E32)*D$19)","v":0},{"$f":"formatoSUA(B32*(D32-(E32+F32))*D$20)","v":0},{"$f":"formatoSUA(B32*(D32-(E32+F32))*D$21)","v":0},{"$f":"+I32+H32+G32","v":0},{"$f":"formatoSUA(B32*(D32-E32)*D$22)","v":0},{"$f":"G32+H32+K32","v":0},{"$f":"I32","v":0},{"$f":"L32+M32","v":0}]
[{"$f":"A27","v":0},{"$f":"IF(A33>($D$4*$D$2),$D$4*$D$2,A33)","v":0},{"$f":"IF(A33>($D$4*$D$2),$D$4*$D$2,A33)","v":0},{"$f":"D32","v":31},0,0,{"$f":"TRUNC(formatoSUA(B33*(D33-E33)*D$19)*$D$5,2)","v":0},{"$f":"TRUNC(formatoSUA(B33*(D33-(E33+F33))*D$20)*$D$5,2)","v":0},{"$f":"TRUNC(formatoSUA(B33*(D33-(E33+F33))*D$21)*$D$5,2)","v":0},{"$f":"+I33+H33+G33","v":0},{"$f":"TRUNC(formatoSUA(B33*(D33-E33)*D$22)*$D$5,2)","v":0},{"$f":"G33+H33+K33","v":0},{"$f":"I33","v":0},{"$f":"L33+M33","v":0}]
[null,null,null,null,null,null,{"$f":"G32-G33","v":0},{"$f":"H32-H33","v":0},{"$f":"I32-I33","v":0},{"$f":"J32-J33","v":0},{"$f":"K32-K33","v":0},{"$f":"G34+H34+K34","v":0},{"$f":"I34","v":0},{"$f":"L34+M34","v":0}]
[]
[]
[]
[1,{"$f":"'Cuotas TD RO'!E13","v":1},{"$f":"B38/$B$50","v":1},{"$f":"IF($D$1=$A$26,0,formatoSUA(C38*$D$50))","v":0},{"$f":"IF($D$1=$A$26,formatoSUA(C38*$D$50)+formatoSUA(C38*$E$50),formatoSUA(C38*$E$50))","v":534.30999999999995}]
[2,{"$f":"'Cuotas TD RO'!E14","v":0},0,{"$f":"IF($D$1=$A$26,0,IF(B40= 0,$D$50-SUM(D38),formatoSUA(C39*$D$50)))","v":0},{"$f":"IF($D$1=$A$26,IF(B40= 0,$D$50-SUM(D38),formatoSUA(C39*$D$50))+IF(B40= 0,$E$50-SUM(E38),formatoSUA(C39*$E$50)),IF(B40= 0,$E$50-SUM(E38),formatoSUA(C39*$E$50)))","v":0}]
[3,{"$f":"'Cuotas TD RO'!E15","v":0},0,{"$f":"IF($D$1=$A$26,0,IF(B41= 0,$D$50-SUM(D38:D39),formatoSUA(C40*$D$50)))","v":0},{"$f":"IF($D$1=$A$26,IF(B41= 0,$D$50-SUM(D38:D39),formatoSUA(C40*$D$50))+IF(B41= 0,$E$50-SUM(E38:E39),formatoSUA(C40*$E$50)),IF(B41= 0,$E$50-SUM(E38:E39),formatoSUA(C40*$E$50)))","v":0}]
[4,{"$f":"'Cuotas TD RO'!E16","v":0},0,{"$f":"IF($D$1=$A$26,0,IF(B42= 0,$D$50-SUM(D38:D40),formatoSUA(C41*$D$50)))","v":0},{"$f":"IF($D$1=$A$26,IF(B42= 0,$D$50-SUM(D38:D40),formatoSUA(C41*$D$50))+IF(B42= 0,$E$50-SUM(E38:E40),formatoSUA(C41*$E$50)),IF(B42= 0,$E$50-SUM(E38:E40),formatoSUA(C41*$E$50)))","v":0}]
[5,{"$f":"'Cuotas TD RO'!E17","v":0},0,{"$f":"IF($D$1=$A$26,0,IF(B43= 0,$D$50-SUM(D38:D41),formatoSUA(C42*$D$50)))","v":0},{"$f":"IF($D$1=$A$26,IF(B43= 0,$D$50-SUM(D38:D41),formatoSUA(C42*$D$50))+IF(B43= 0,$E$50-SUM(E38:E41),formatoSUA(C42*$E$50)),IF(B43= 0,$E$50-SUM(E38:E41),formatoSUA(C42*$E$50)))","v":0}]
[6,{"$f":"'Cuotas TD RO'!E18","v":0},0,{"$f":"IF($D$1=$A$26,0,IF(B44= 0,$D$50-SUM(D38:D42),formatoSUA(C43*$D$50)))","v":0},{"$f":"IF($D$1=$A$26,IF(B44= 0,$D$50-SUM(D38:D42),formatoSUA(C43*$D$50))+IF(B44= 0,$E$50-SUM(E38:E42),formatoSUA(C43*$E$50)),IF(B44= 0,$E$50-SUM(E38:E42),formatoSUA(C43*$E$50)))","v":0}]
[7,{"$f":"'Cuotas TD RO'!E19","v":0},0,{"$f":"IF($D$1=$A$26,0,IF(B45= 0,$D$50-SUM(D38:D43),formatoSUA(C44*$D$50)))","v":0},{"$f":"IF($D$1=$A$26,IF(B45= 0,$D$50-SUM(D38:D43),formatoSUA(C44*$D$50))+IF(B45= 0,$E$50-SUM(E38:E43),formatoSUA(C44*$E$50)),IF(B45= 0,$E$50-SUM(E38:E43),formatoSUA(C44*$E$50)))","v":0}]
[8,{"$f":"'Cuotas TD RO'!E20","v":0},0,{"$f":"IF($D$1=$A$26,0,IF(B46= 0,$D$50-SUM(D38:D44),formatoSUA(C45*$D$50)))","v":0},{"$f":"IF($D$1=$A$26,IF(B46= 0,$D$50-SUM(D38:D44),formatoSUA(C45*$D$50))+IF(B46= 0,$E$50-SUM(E38:E44),formatoSUA(C45*$E$50)),IF(B46= 0,$E$50-SUM(E38:E44),formatoSUA(C45*$E$50)))","v":0}]
[9,{"$f":"'Cuotas TD RO'!E21","v":0},0,{"$f":"IF($D$1=$A$26,0,IF(B47= 0,$D$50-SUM(D38:D45),formatoSUA(C46*$D$50)))","v":0},{"$f":"IF($D$1=$A$26,IF(B47= 0,$D$50-SUM(D38:D45),formatoSUA(C46*$D$50))+IF(B47= 0,$E$50-SUM(E38:E45),formatoSUA(C46*$E$50)),IF(B47= 0,$E$50-SUM(E38:E45),formatoSUA(C46*$E$50)))","v":0}]
[10,{"$f":"'Cuotas TD RO'!E22","v":0},0,{"$f":"IF($D$1=$A$26,0,IF(B48= 0,$D$50-SUM(D38:D46),formatoSUA(C47*$D$50)))","v":0},{"$f":"IF($D$1=$A$26,IF(B48= 0,$D$50-SUM(D38:D46),formatoSUA(C47*$D$50))+IF(B48= 0,$E$50-SUM(E38:E46),formatoSUA(C47*$E$50)),IF(B48= 0,$E$50-SUM(E38:E46),formatoSUA(C47*$E$50)))","v":0}]
[11,{"$f":"'Cuotas TD RO'!E23","v":0},0,{"$f":"IF($D$1=$A$26,0,IF(B49= 0,$D$50-SUM(D38:D47),formatoSUA(C48*$D$50)))","v":0},{"$f":"IF($D$1=$A$26,IF(B49= 0,$D$50-SUM(D38:D47),formatoSUA(C48*$D$50))+IF(B49= 0,$E$50-SUM(E38:E47),formatoSUA(C48*$E$50)),IF(B49= 0,$E$50-SUM(E38:E47),formatoSUA(C48*$E$50)))","v":0}]
[12,{"$f":"'Cuotas TD RO'!E24","v":0},0,{"$f":"IF($D$1=$A$26,0,$D$50-SUM(D38:D48))","v":0},{"$f":"IF($D$1=$A$26,$D$50-SUM(D38:D48)+$E$50-SUM(E38:E48),$E$50-SUM(E38:E48))","v":0}]
["total",{"$f":"SUM(B38:B49)","v":1},null,{"$f":"S28+M34","v":0},{"$f":"R28+L34","v":534.30999999999995}]
[null,"VERIFICA",null,{"$f":"SUM(D38:D49)","v":0},{"$f":"SUM(E38:E49)","v":534.30999999999995}]