{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Captura","Cálculo para imprimir","Salarios mínimos"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Captura","index":0,"n_rows":49,"n_cols":21,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C7>1900,IF(E7<>\"\",\"Seleccione una Zona geográfica válida para el año de salida\",\"Seleccione la zona geográfica\"),\"\")","v":""}]
[null,"Captura de Datos : Empleado",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zona Libre de la Frontera Norte",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-01-01",null,null,null,null,"Resto del país",3]
[null,"Datos del Empleado",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2021-01-12"}]
[null,"Nombre de Trabajor:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"C7","v":"00:00:00"},{"$f":"DAY(1)","v":1},{"$f":"MONTH(1)","v":1},{"$f":"YEAR(N5)","v":1900},{"$f":"DATE(Q5,P5,O5)","v":"1900-01-01"}]
[null,"Fecha de Ingreso:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"C7-C6","v":0},"Días Totales"]
[null,"Fecha de Salida:",null,"Zona geográfica:",null,null,null,null,null,null,null,null,null,365,"Días al año"]
[null,"Antigüedad:",{"$f":"IF(C7<>\"\",CONCATENATE(N8,\" \",O8,\" y \",N9,\" \",O9),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC(N6/365)","v":0},{"$f":"IF(N8=1,\"Año\",\"Años\")","v":"Años"},{"$f":"N8+1","v":1}]
[null,"Salario Cuota Diaria:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MOD(N6,365)","v":0},{"$f":"IF(N9=1,\"dia\",\"dias\")","v":"dias"}]
[null,"Doble del mínimo:",{"$f":"IFERROR(VLOOKUP(Q5,'Salarios mínimos'!$B:$D,VLOOKUP($E$7,$T$2:$U$3,2,0),FALSE)*2,$U$1)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C6>R5,C7-C6,C7-R5)","v":-1},{"$f":"CONCATENATE(\"Días en año \",Q5)","v":"Días en año 1900"}]
[null,"Prestaciones","Prestaciones Ley"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N8=1,J16,IF(N8=2,J17,IF(N8=3,J18,IF(N8=4,J19,IF(N8>=50,J29,IF(N8>=45,J28,IF(N8>=40,J27,IF(N8>=35,J26,IF(N8>=30,J25,IF(N8>=25,J24,IF(N8>=20,J23,IF(N8>=15,J22,IF(N8>=10,J21,IF(N8>=5,J20,\"\"))))))))))))))","v":""},"Dias de Vacaciones de año completo"]
[null,"Liquidación",null,null,null,null,null,"Superiores a Ley","Prestaciones Ley",{"$f":"+C11","v":"Prestaciones Ley"},null,null,null,{"$f":"IF(P8=1,J16,IF(P8=2,J17,IF(P8=3,J18,IF(P8=4,J19,IF(P8>=50,J29,IF(P8>=45,J28,IF(P8>=40,J27,IF(P8>=35,J26,IF(P8>=30,J25,IF(P8>=25,J24,IF(P8>=20,J23,IF(P8>=15,J22,IF(P8>=10,J21,IF(P8>=5,J20,\"\"))))))))))))))","v":6},"Dias de Vacaciones menores a un año"]
[null,{"$f":"IF(N8>=1,CONCATENATE(\"Vacaciones año \",N8),\"\")","v":""},{"$f":"IF(D14=\"Eliminar\",0,IF(N8>=1,(N12*C9),0))","v":0},"Agregar",null,"Prima Vacacional","Porcentaje",0.25,0.25,{"$f":"IF($C$11=\"Superiores a Ley\",H14,I14)","v":0.25},null,null,null,{"$f":"N13*N9/365","v":0}]
[null,{"$f":"IF(N8>=1,CONCATENATE(\"Prima Vacacional año \",N8),\"\")","v":""},{"$f":"IF(D15=\"Eliminar\",0,IF(N8>=1,(N12*C9)*J14,0))","v":0},"Agregar",null,"Aguinaldo","Dias",15,15,{"$f":"IF($C$11=\"Superiores a Ley\",H15,I15)","v":15},null,null,null,{"$f":"FIXED(N14,2)","v":"0.00"}]
[null,{"$f":"CONCATENATE(\"Vacaciones proporcionales año \",IF(N8+1>0,N8+1,\" \"))","v":"Vacaciones proporcionales año 1"},{"$f":"IFERROR(IF(D16=\"Eliminar\",0,N15*C9),0)","v":0},"Agregar",null,"vacaciones año 1","Dias",6,6,6]
[null,{"$f":"CONCATENATE(\"Prima Vacacional proporcional año \",IF(N8+1>0,N8+1,\" \"))","v":"Prima Vacacional proporcional año 1"},{"$f":"IFERROR(IF(D17=\"Eliminar\",0,N15*C9*J14),0)","v":0},"Agregar",null,"vacaciones año 2","Dias",8,8,8]
[null,{"$f":"CONCATENATE(\"Aguinaldo Prop \",IF(Q5>1901,Q5,\" \"),\":\")","v":"Aguinaldo Prop  :"},{"$f":"IF(D18=\"Eliminar\",0,N10*J15/N7*C9)","v":0},"Agregar",null,"vacaciones año 3","Dias",10,10,10]
[null,"Prima de Antigüedad:",{"$f":"IFERROR(IF(D19=\"Eliminar\",0,IF(C9<C10,((12*N8)+(12*N9/365))*C9,((12*N8)+(12*N9/365))*C10)),0)","v":0},"Agregar",null,"vacaciones año 4","Dias",12,12,12]
[null,null,null,null,null,"vacaciones año 5-9","Dias",14,14,14]
[null,null,null,null,null,"vacaciones año 10-14","Dias",16,16,16]
[null,null,null,null,null,"vacaciones año 15-19","Dias",18,18,18]
[null,null,null,null,null,"vacaciones año 20-24","Dias",20,20,20]
[null,"otro",null,null,null,"vacaciones año 25-29","Dias",22,22,22]
[null,"Total Liquidación:",{"$f":"SUM(C14:C24)","v":0},null,null,"vacaciones año 30-34","Dias",24,24,24]
[null,null,null,null,null,"vacaciones año 35-39","Dias",26,26,26]
[null,"Indemnización",null,null,null,"vacaciones año 40-44","Dias",28,28,28]
[null,"PPD Aguinaldo:",{"$f":"IF(D28=\"Eliminar\",0,J15*C9/365)","v":0},"Agregar",null,"vacaciones año 45-49","Dias",30,30,30]
[null,"PPD Prima Vacacional:",{"$f":"IFERROR(IF(D29=\"Eliminar\",0,N13*C9*J14/365),0)","v":0},"Agregar",null,"vacaciones año 50-54","Dias",32,32,32]
[]
[]
[]
[]
[]
[null,"Salario diario integrado:",{"$f":"SUM(C28:C34)+C9","v":0}]
[null,"Indemnización 90 días:",{"$f":"90*C35","v":0}]
[null,"Propuesta convenio",{"$f":"+D37*C35+C25","v":0},90,"Días de indemnización"]
[]
[null,"Hoja de cálculo diseñada por:"]
[null,"Lic. Rene B. Mireles Tejeda"]
[null,"rene@mirelesabogados.com"]
[null,"www.mirelesabogados.com"]
[null,"Oficina 686-252-7610"]
[]
[]
[]
[]
[]
[null,null,null,null,null,0]

{"sheet":"Cálculo para imprimir","index":1,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,2,0,5],[1,2,1,5],[2,2,2,5],[46,1,48,5],[4,0,4,5],[43,1,44,1],[43,2,44,2],[43,3,44,5],[41,1,42,1],[41,2,42,2]]}
[null,null,"Abogados especialistas en Derecho Laboral"]
[null,null,"Teléfono 686-252-7610"]
[null,null,"www.mirelesabogados.com"]
[]
["Cálculo de Prestaciones Laborales"]
[]
[null,"Datos del Trabajador",null,null,null,{"$f":"\"Fecha del cálculo: \"&TEXT(TODAY(),\"dd/mm/aaaa\")","v":"Fecha del cálculo: 12/01/2021"}]
[null,"Nombre:",{"$f":"IF(Captura!C5<>\"\",Captura!C5,\"\")","v":""}]
[]
[null,"Fecha de Ingreso:",{"$f":"IF(Captura!C6<>\"\",Captura!C6,\"\")","v":""}]
[null,"Fecha de Salida:",{"$f":"IF(Captura!C7<>\"\",Captura!C7,\"\")","v":""}]
[null,"Antigüedad:",{"$f":"IF(Captura!C8<>\"\",Captura!C8,\"\")","v":""}]
[null,"Salario Cuota Diaria:",{"$f":"Captura!C9","v":0}]
[null,"Doble del salario mínimo:",{"$f":"Captura!C10","v":""}]
[]
[null,"Liquidación",null,null,null,null,null,null," "]
[]
[null,{"$f":"Captura!B14","v":""},{"$f":"Captura!C14","v":0}]
[null,{"$f":"Captura!B15","v":""},{"$f":"Captura!C15","v":0}]
[null,{"$f":"Captura!B16","v":"Vacaciones proporcionales año 1"},{"$f":"Captura!C16","v":0}]
[null,{"$f":"Captura!B17","v":"Prima Vacacional proporcional año 1"},{"$f":"Captura!C17","v":0}]
[null,{"$f":"Captura!B18","v":"Aguinaldo Prop  :"},{"$f":"Captura!C18","v":0}]
[null,{"$f":"Captura!B19","v":"Prima de Antigüedad:"},{"$f":"Captura!C19","v":0}]
[null,{"$f":"IF(Captura!B20<>\"\",Captura!B20,\"\")","v":""},{"$f":"Captura!C20","v":0}]
[null,{"$f":"IF(Captura!B21<>\"\",Captura!B21,\"\")","v":""},{"$f":"Captura!C21","v":0}]
[null,{"$f":"IF(Captura!B22<>\"\",Captura!B22,\"\")","v":""},{"$f":"Captura!C22","v":0}]
[null,{"$f":"IF(Captura!B23<>\"\",Captura!B23,\"\")","v":""},{"$f":"Captura!C23","v":0}]
[null,{"$f":"IF(Captura!B24<>\"\",Captura!B24,\"\")","v":"otro"},{"$f":"Captura!C24","v":0}]
[null,"Total Liquidación:",{"$f":"Captura!C25","v":0}]
[]
[null,"Indemnización"]
[]
[null,"PPD Aguinaldo:",{"$f":"Captura!C28","v":0}]
[null,"PPD Prima Vacacional:",{"$f":"Captura!C29","v":0}]
[null,{"$f":"IF(Captura!B30<>\"\",Captura!B30,\"\")","v":""},{"$f":"Captura!C30","v":0}]
[null,{"$f":"IF(Captura!B31<>\"\",Captura!B31,\"\")","v":""},{"$f":"Captura!C31","v":0}]
[null,{"$f":"IF(Captura!B32<>\"\",Captura!B32,\"\")","v":""},{"$f":"Captura!C32","v":0}]
[null,{"$f":"IF(Captura!B33<>\"\",Captura!B33,\"\")","v":""},{"$f":"Captura!C33","v":0}]
[null,{"$f":"IF(Captura!B34<>\"\",Captura!B34,\"\")","v":""},{"$f":"Captura!C34","v":0}]
[null,"Salario diario integrado:",{"$f":"Captura!C35","v":0}]
[null,"Indemnización 90 días:",{"$f":"Captura!C36","v":0}]
[null,"Total de Liquidación e Indemnización al 100%:",{"$f":"C41+C29","v":0}]
[]
[null,"Propuesta de convenio",{"$f":"Captura!C37","v":0},{"$f":" \"La presente propuesta incluye \" & Captura!D37 & \" días de indemnización, más la liquidación.\"","v":"La presente propuesta incluye 90 días de indemnización, más la liquidación."}]
[]
[null,"Observaciones"]
[]
[]
[]
[null,"Hoja de cálculo diseñada por:  ","Lic. René B. Mireles Tejeda"]
[null,null,"rene@mirelesabogados.com"]
[null,null,"Oficina: 686-252-7610"]
[null,null,"www.mirelesabogados.com"]

{"sheet":"Salarios mínimos","index":2,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Histórico de salarios mínimos"]
[]
[null,"Año","ZLFN","Resto del país"]
[null,2016,73.040000000000006,73.040000000000006]
[null,2017,80.040000000000006,80.040000000000006]
[null,2018,88.36,88.36]
[null,2019,176.72,102.68]
[null,2020,185.56,123.22]
[null,2021,213.39,141.69999999999999]
[null,2022]
[null,2023]
[null,2024]
[null,2025]
[null,2026]
[null,2027]
[null,2028]
[null,2029]
[null,2030]
[null,2031]
[null,2032]
[null,2033]
[null,2034]
[null,2035]