{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Información del empleado","Calculadora de nóminas","Nóminas individuales"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Información del empleado","index":0,"n_rows":7,"n_cols":13,"rows_kept":7,"merged":[[1,0,1,12],[2,0,2,5]]}
[]
["Información del empleado"]
["[Nombre de la compañía]"]
["ID de empleado","Nombre del empleado","Salario por horas","Estado de impuestos","Prestación estatal (solicitud de prestación contributiva)","Impuesto estatal","Impuesto sobre la renta (porcentaje según prestación federal)","Impuesto de la seguridad social","Impuesto del seguro médico","Total impuestos retenidos","Deducción del seguro","Otras deducciones regulares","Total de deducciones regulares (excluyendo los impuestos)"]
[1,"Víctor Alcaraz",{"v":10,"d":"10.00 €"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"Tabla1[[#This Row],[Impuesto estatal]]+Tabla1[[#This Row],[Impuesto sobre la renta (porcentaje según prestación federal)]]+Tabla1[[#This Row],[Impuesto de la seguridad social]]+Tabla1[[#This Row],[Impuesto del seguro médico]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"20.00 €"},{"v":40,"d":"40.00 €"},{"$f":"Tabla1[[#This Row],[Deducción del seguro]]+Tabla1[[#This Row],[Otras deducciones regulares]]","v":{"v":60,"d":"60.00 €"}}]
[2,"Federico Tercedor",{"v":13,"d":"13.00 €"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"Tabla1[[#This Row],[Impuesto estatal]]+Tabla1[[#This Row],[Impuesto sobre la renta (porcentaje según prestación federal)]]+Tabla1[[#This Row],[Impuesto de la seguridad social]]+Tabla1[[#This Row],[Impuesto del seguro médico]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"20.00 €"},{"v":52,"d":"52.00 €"},{"$f":"Tabla1[[#This Row],[Deducción del seguro]]+Tabla1[[#This Row],[Otras deducciones regulares]]","v":{"v":72,"d":"72.00 €"}}]
[3,"Elvira Cano",{"v":10,"d":"10.00 €"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"Tabla1[[#This Row],[Impuesto estatal]]+Tabla1[[#This Row],[Impuesto sobre la renta (porcentaje según prestación federal)]]+Tabla1[[#This Row],[Impuesto de la seguridad social]]+Tabla1[[#This Row],[Impuesto del seguro médico]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"20.00 €"},0,{"$f":"Tabla1[[#This Row],[Deducción del seguro]]+Tabla1[[#This Row],[Otras deducciones regulares]]","v":{"v":20,"d":"20.00 €"}}]

{"sheet":"Calculadora de nóminas","index":1,"n_rows":7,"n_cols":11,"rows_kept":7,"merged":[[0,0,1,8],[2,0,2,5]]}
["Calculadora de nóminas"]
[{"$nulls":9},"Final del período:",{"v":45688,"d":"4568800.00%"}]
[{"$f":"'Información del empleado'!$A$3","v":"[Nombre de la compañía]"}]
["ID de empleado","Nombre del empleado","Horas normales de trabajo","Horas de vacaciones","Horas de baja","Horas extra","Pago por horas extra","Pago bruto","Impuestos y deducciones ","Otras deducciones","Pago neto"]
[1,{"$f":"VLOOKUP(A5,Tabla1[],2,FALSE)","v":"Víctor Alcaraz"},{"v":50,"d":"50.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},null,null,{"$f":"(VLOOKUP(A5,Tabla1[],3,FALSE)*(Tabla2[[#This Row],[Horas normales de trabajo]]+Tabla2[[#This Row],[Horas de vacaciones]]+Tabla2[[#This Row],[Horas de baja]])+Tabla2[[#This Row],[Horas extra]]*Tabla2[[#This Row],[Pago por horas extra]])","v":{"v":560,"d":"560.00 €"}},{"$f":"VLOOKUP(A5,Tabla1[],10,FALSE)*Tabla2[[#This Row],[Pago bruto]]+Tabla1[[#This Row],[Total de deducciones regulares (excluyendo los impuestos)]]","v":{"v":273.08000000000004,"d":"273.08 €"}},{"v":20,"d":"20.00 €"},{"$f":"Tabla2[[#This Row],[Pago bruto]]-Tabla2[[#This Row],[Impuestos y deducciones ]]-Tabla2[[#This Row],[Otras deducciones]]","v":{"v":266.91999999999996,"d":"266.92 €"}}]
[2,{"$f":"VLOOKUP(A6,Tabla1[],2,FALSE)","v":"Federico Tercedor"},{"v":40,"d":"40.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"$f":"(VLOOKUP(A6,Tabla1[],3,FALSE)*(Tabla2[[#This Row],[Horas normales de trabajo]]+Tabla2[[#This Row],[Horas de vacaciones]]+Tabla2[[#This Row],[Horas de baja]])+Tabla2[[#This Row],[Horas extra]]*Tabla2[[#This Row],[Pago por horas extra]])","v":{"v":520,"d":"520.00 €"}},{"$f":"VLOOKUP(A6,Tabla1[],10,FALSE)*Tabla2[[#This Row],[Pago bruto]]+Tabla1[[#This Row],[Total de deducciones regulares (excluyendo los impuestos)]]","v":{"v":269.86,"d":"269.86 €"}},{"v":52,"d":"52.00 €"},{"$f":"Tabla2[[#This Row],[Pago bruto]]-Tabla2[[#This Row],[Impuestos y deducciones ]]-Tabla2[[#This Row],[Otras deducciones]]","v":{"v":198.14,"d":"198.14 €"}}]
[3,{"$f":"VLOOKUP(A7,Tabla1[],2,FALSE)","v":"Elvira Cano"},{"v":52,"d":"52.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":2,"d":"2.00"},{"v":20,"d":"20.00 €"},{"$f":"(VLOOKUP(A7,Tabla1[],3,FALSE)*(Tabla2[[#This Row],[Horas normales de trabajo]]+Tabla2[[#This Row],[Horas de vacaciones]]+Tabla2[[#This Row],[Horas de baja]])+Tabla2[[#This Row],[Horas extra]]*Tabla2[[#This Row],[Pago por horas extra]])","v":{"v":560,"d":"560.00 €"}},{"$f":"VLOOKUP(A7,Tabla1[],10,FALSE)*Tabla2[[#This Row],[Pago bruto]]+Tabla1[[#This Row],[Total de deducciones regulares (excluyendo los impuestos)]]","v":{"v":233.08000000000004,"d":"233.08 €"}},{"v":20,"d":"20.00 €"},{"$f":"Tabla2[[#This Row],[Pago bruto]]-Tabla2[[#This Row],[Impuestos y deducciones ]]-Tabla2[[#This Row],[Otras deducciones]]","v":{"v":306.91999999999996,"d":"306.92 €"}}]

{"sheet":"Nóminas individuales","index":2,"n_rows":48,"n_cols":8,"rows_kept":48,"merged":[[1,2,1,7],[13,2,13,7],[25,2,25,7],[38,2,38,7]]}
[]
[null,null,{"$f":"('Información del empleado'!$A$3)","v":"[Nombre de la compañía]"}]
[null,null,"Período:",{"$f":"'Calculadora de nóminas'!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Nombre del empleado",{"$f":"IFERROR(VLOOKUP(H3,Tabla1[],2),\"\")","v":"Víctor Alcaraz"},"ID de empleado",1]
[]
[null,null,"Estado de impuestos",{"$f":"IFERROR(VLOOKUP(H3,Tabla1[],4),\"\")","v":1},"Prestación estatal (solicitud de prestación contributiva)",{"$f":"IFERROR(VLOOKUP(H3,Tabla1[],5,FALSE),\"\")","v":4},"Horas de trabajo",{"$f":"IFERROR(VLOOKUP(H3,Tabla2[],3,FALSE),\"\")","v":50}]
[null,null,"Pago por hora",{"$f":"IFERROR(VLOOKUP(H3,Tabla1[],3,FALSE),\"\")","v":{"v":10,"d":"10.00 €"}},"Pago por horas extra",{"$f":"IFERROR(VLOOKUP(H3,Tabla2[],7,FALSE),\"\")","v":0},"Horas de baja",{"$f":"IFERROR(VLOOKUP(H3,Tabla2[],5,FALSE),\"\")","v":1}]
[null,null,"Impuesto de la seguridad social",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tabla1[],8,FALSE),\"\")*H9,\"\")","v":{"v":35.28,"d":"35.28 €"}},"Impuesto sobre la renta ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tabla1[],7,FALSE),\"\")*H9,\"\")","v":{"v":156.8,"d":"156.80 €"}},"Horas de vacaciones",{"$f":"IFERROR(VLOOKUP(H3,Tabla2[],4,FALSE),\"\")","v":5}]
[null,null,"Impuesto del seguro médico ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tabla1[],9,FALSE),\"\")*H9,\"\")","v":{"v":8.120000000000001,"d":"8.12 €"}},"Impuesto estatal ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tabla1[],6,FALSE),\"\")*H9,\"\")","v":{"v":12.879999999999999,"d":"12.88 €"}},"Horas extra",{"$f":"IFERROR(VLOOKUP(H3,Tabla2[],6,FALSE),\"\")","v":0}]
[null,null,"Deducción del seguro",{"$f":"IFERROR(VLOOKUP(H3,Tabla1[],11,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Otras deducciones regulares",{"$f":"IFERROR(VLOOKUP(H3,Tabla1[],12,FALSE),\"\")","v":{"v":40,"d":"40.00 €"}},"Pago bruto",{"$f":"IFERROR(VLOOKUP(H3,Tabla2[],8,FALSE),\"\")","v":{"v":560,"d":"560.00 €"}}]
[null,null,"Impuestos totales y deducciones regulares ",{"$f":"IFERROR(SUM(F7:F9)+SUM(D7:D9),\"\")","v":{"v":273.08000000000004,"d":"273.08 €"}},"Otras deducciones",{"$f":"IFERROR(VLOOKUP(H3,Tabla2[],10,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Impuestos y deducciones totales ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tabla2[],9,FALSE),\"\")+F10,\"\")","v":{"v":293.08000000000004,"d":"293.08 €"}}]
[{"$nulls":6},"Pago neto",{"$f":"IFERROR(VLOOKUP(H3,Tabla2[],11,FALSE),\"\")","v":{"v":266.91999999999996,"d":"266.92 €"}}]
[]
[]
[null,null,{"$f":"('Información del empleado'!$A$3)","v":"[Nombre de la compañía]"}]
[null,null,"Período:",{"$f":"'Calculadora de nóminas'!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Nombre del empleado",{"$f":"IFERROR(VLOOKUP(H15,Tabla1[],2),\"\")","v":"Federico Tercedor"},"ID de empleado",2]
[]
[null,null,"Estado de impuestos",{"$f":"IFERROR(VLOOKUP(H15,Tabla1[],4),\"\")","v":1},"Prestación estatal (solicitud de prestación contributiva)",{"$f":"IFERROR(VLOOKUP(H15,Tabla1[],5,FALSE),\"\")","v":4},"Horas de trabajo",{"$f":"IFERROR(VLOOKUP(H15,Tabla2[],3,FALSE),\"\")","v":40}]
[null,null,"Pago por hora",{"$f":"IFERROR(VLOOKUP(H15,Tabla1[],3,FALSE),\"\")","v":{"v":13,"d":"13.00 €"}},"Pago por horas extra",{"$f":"IFERROR(VLOOKUP(H15,Tabla2[],7,FALSE),\"\")","v":0},"Horas de baja",{"$f":"IFERROR(VLOOKUP(H15,Tabla2[],5,FALSE),\"\")","v":0}]
[null,null,"Impuesto de la seguridad social",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tabla1[],8,FALSE),\"\")*H21,\"\")","v":{"v":32.76,"d":"32.76 €"}},"Impuesto sobre la renta ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tabla1[],7,FALSE),\"\")*H21,\"\")","v":{"v":145.60000000000002,"d":"145.60 €"}},"Horas de vacaciones",{"$f":"IFERROR(VLOOKUP(H15,Tabla2[],4,FALSE),\"\")","v":0}]
[null,null,"Impuesto del seguro médico ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tabla1[],9,FALSE),\"\")*H21,\"\")","v":{"v":7.54,"d":"7.54 €"}},"Impuesto estatal ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tabla1[],6,FALSE),\"\")*H21,\"\")","v":{"v":11.959999999999999,"d":"11.96 €"}},"Horas extra",{"$f":"IFERROR(VLOOKUP(H15,Tabla2[],6,FALSE),\"\")","v":0}]
[null,null,"Deducción del seguro",{"$f":"IFERROR(VLOOKUP(H15,Tabla1[],11,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Otras deducciones regulares",{"$f":"IFERROR(VLOOKUP(H15,Tabla1[],12,FALSE),\"\")","v":{"v":52,"d":"52.00 €"}},"Pago bruto",{"$f":"IFERROR(VLOOKUP(H15,Tabla2[],8,FALSE),\"\")","v":{"v":520,"d":"520.00 €"}}]
[null,null,"Impuestos totales y deducciones regulares ",{"$f":"IFERROR(SUM(F19:F21)+SUM(D19:D21),\"\")","v":{"v":269.86,"d":"269.86 €"}},"Otras deducciones",{"$f":"IFERROR(VLOOKUP(H15,Tabla2[],10,FALSE),\"\")","v":{"v":52,"d":"52.00 €"}},"Impuestos y deducciones totales ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tabla2[],9,FALSE),\"\")+F22,\"\")","v":{"v":321.86,"d":"321.86 €"}}]
[{"$nulls":6},"Pago neto",{"$f":"IFERROR(VLOOKUP(H15,Tabla2[],11,FALSE),\"\")","v":{"v":198.14,"d":"198.14 €"}}]
[]
[]
[null,null,{"$f":"('Información del empleado'!$A$3)","v":"[Nombre de la compañía]"}]
[null,null,"Período:",{"$f":"'Calculadora de nóminas'!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Nombre del empleado",{"$f":"IFERROR(VLOOKUP(H27,Tabla1[],2),\"\")","v":"Elvira Cano"},"ID de empleado",3]
[]
[null,null,"Estado de impuestos",{"$f":"IFERROR(VLOOKUP(H27,Tabla1[],4),\"\")","v":1},"Prestación estatal (solicitud de prestación contributiva)",{"$f":"IFERROR(VLOOKUP(H27,Tabla1[],5,FALSE),\"\")","v":4},"Horas de trabajo",{"$f":"IFERROR(VLOOKUP(H27,Tabla2[],3,FALSE),\"\")","v":52}]
[null,null,"Pago por hora",{"$f":"IFERROR(VLOOKUP(H27,Tabla1[],3,FALSE),\"\")","v":{"v":10,"d":"10.00 €"}},"Pago por horas extra",{"$f":"IFERROR(VLOOKUP(H27,Tabla2[],7,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Horas de baja",{"$f":"IFERROR(VLOOKUP(H27,Tabla2[],5,FALSE),\"\")","v":0}]
[null,null,"Impuesto de la seguridad social",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tabla1[],8,FALSE),\"\")*H33,\"\")","v":{"v":35.28,"d":"35.28 €"}},"Impuesto sobre la renta ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tabla1[],7,FALSE),\"\")*H33,\"\")","v":{"v":156.8,"d":"156.80 €"}},"Horas de vacaciones",{"$f":"IFERROR(VLOOKUP(H27,Tabla2[],4,FALSE),\"\")","v":0}]
[null,null,"Impuesto del seguro médico ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tabla1[],9,FALSE),\"\")*H33,\"\")","v":{"v":8.120000000000001,"d":"8.12 €"}},"Impuesto estatal ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tabla1[],6,FALSE),\"\")*H33,\"\")","v":{"v":12.879999999999999,"d":"12.88 €"}},"Horas extra",{"$f":"IFERROR(VLOOKUP(H27,Tabla2[],6,FALSE),\"\")","v":2}]
[null,null,"Deducción del seguro",{"$f":"IFERROR(VLOOKUP(H27,Tabla1[],11,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Otras deducciones regulares",{"$f":"IFERROR(VLOOKUP(H27,Tabla1[],12,FALSE),\"\")","v":0},"Pago bruto",{"$f":"IFERROR(VLOOKUP(H27,Tabla2[],8,FALSE),\"\")","v":{"v":560,"d":"560.00 €"}}]
[null,null,"Impuestos totales y deducciones regulares ",{"$f":"IFERROR(SUM(F31:F33)+SUM(D31:D33),\"\")","v":{"v":233.08,"d":"233.08 €"}},"Otras deducciones",{"$f":"IFERROR(VLOOKUP(H27,Tabla2[],10,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Impuestos y deducciones totales ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tabla2[],9,FALSE),\"\")+F34,\"\")","v":{"v":253.08000000000004,"d":"253.08 €"}}]
[{"$nulls":6},"Pago neto",{"$f":"IFERROR(VLOOKUP(H27,Tabla2[],11,FALSE),\"\")","v":{"v":306.91999999999996,"d":"306.92 €"}}]
[]
[]
[]
[null,null,{"$f":"('Información del empleado'!$A$3)","v":"[Nombre de la compañía]"}]
[null,null,"Período:",{"$f":"'Calculadora de nóminas'!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Nombre del empleado",{"$f":"IFERROR(VLOOKUP(H40,Tabla1[],2),\"\")","v":""},"ID de empleado"]
[]
[null,null,"Estado de impuestos",{"$f":"IFERROR(VLOOKUP(H40,Tabla1[],4),\"\")","v":""},"Prestación estatal (solicitud de prestación contributiva)",{"$f":"IFERROR(VLOOKUP(H40,Tabla1[],5,FALSE),\"\")","v":""},"Horas de trabajo",{"$f":"IFERROR(VLOOKUP(H40,Tabla2[],3,FALSE),\"\")","v":""}]
[null,null,"Pago por hora",{"$f":"IFERROR(VLOOKUP(H40,Tabla1[],3,FALSE),\"\")","v":""},"Pago por horas extra",{"$f":"IFERROR(VLOOKUP(H40,Tabla2[],7,FALSE),\"\")","v":""},"Horas de baja",{"$f":"IFERROR(VLOOKUP(H40,Tabla2[],5,FALSE),\"\")","v":""}]
[null,null,"Impuesto de la seguridad social",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tabla1[],8,FALSE),\"\")*H46,\"\")","v":""},"Impuesto sobre la renta ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tabla1[],7,FALSE),\"\")*H46,\"\")","v":""},"Horas de vacaciones",{"$f":"IFERROR(VLOOKUP(H40,Tabla2[],4,FALSE),\"\")","v":""}]
[null,null,"Impuesto del seguro médico ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tabla1[],9,FALSE),\"\")*H46,\"\")","v":""},"Impuesto estatal ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tabla1[],6,FALSE),\"\")*H46,\"\")","v":""},"Horas extra",{"$f":"IFERROR(VLOOKUP(H40,Tabla2[],6,FALSE),\"\")","v":""}]
[null,null,"Deducción del seguro",{"$f":"IFERROR(VLOOKUP(H40,Tabla1[],11,FALSE),\"\")","v":""},"Otras deducciones regulares",{"$f":"IFERROR(VLOOKUP(H40,Tabla1[],12,FALSE),\"\")","v":""},"Pago bruto",{"$f":"IFERROR(VLOOKUP(H40,Tabla2[],8,FALSE),\"\")","v":""}]
[null,null,"Impuestos totales y deducciones regulares ",{"$f":"IFERROR(SUM(F44:F46)+SUM(D44:D46),\"\")","v":0},"Otras deducciones",{"$f":"IFERROR(VLOOKUP(H40,Tabla2[],10,FALSE),\"\")","v":""},"Impuestos y deducciones totales ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tabla2[],9,FALSE),\"\")+F47,\"\")","v":""}]
[{"$nulls":6},"Pago neto",{"$f":"IFERROR(VLOOKUP(H40,Tabla2[],11,FALSE),\"\")","v":""}]