{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Información del empleado","Calculadora de nómina","Recibos de pago individuales"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Información del empleado","index":0,"n_rows":28,"n_cols":14,"rows_kept":28,"merged":[[1,1,1,10]],"flags":["formulas_cached_only"]}
[]
[null,"Información del empleado"]
[null,"Identificación del Empleado","Nombre","Salario por Horas","Estado Fiscal","Asignación Federal (de W-4)","Impuesto Estatal (Porcentaje)","Impuesto sobre la Renta Federal (Porcentaje con base en la asignación federal)","Seguro Social (Porcentaje)","Impuestos Salud (Porcentaje)","Total de Impuestos Retenidos (Porcentaje)","Deducción \ndel Seguro\n(Dólares)","Otras Deducciones\nRegulares\n(Dólares)","Total de Deducciones Regulares (sin contar impuestos, en dólares)"]
[null,1,"Jay Adams",{"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%"},{"v":0.38050000000000006,"d":"38.05%"},{"v":20,"d":"$20.00"},{"v":40,"d":"$40.00"},{"v":60,"d":"$60.00"}]
[null,2,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,3,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,4,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,5,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,6,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,7,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,8,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,9,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,10,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,11,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,12,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,13,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,14,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,15,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,16,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,17,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,18,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,19,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,20,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,21,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,22,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,23,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,24,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]
[null,25,{"$nulls":8},{"v":0,"d":"0.00%"},null,null,{"v":0,"d":"$0.00"}]

{"sheet":"Calculadora de nómina","index":1,"n_rows":28,"n_cols":12,"rows_kept":28,"flags":["formulas_cached_only"]}
[]
[null,"Calculadora de nómina",{"$nulls":8},"Periodo finalizado al:","2004-02-01"]
[null,"Identificación del Empleado","Nombre del Empleado","Horas de Trabajo Regulares","Horas de Vacaciones","Horas de Enfermedad","Horas de Tiempo Extra","Tarifa para Horas Extra","Pago Bruto","Impuestos y Deducciones ","Otras\nDeducciones","Pago Neto"]
[null,1,"Jay Adams",50,5,1,null,null,{"v":560,"d":"$560.00"},{"v":273.08000000000004,"d":"$273.08"},{"v":20,"d":"$20.00"},{"v":266.91999999999996,"d":"$266.92"}]
[null,2,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,3,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,4,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,5,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,6,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,7,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,8,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,9,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,10,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,11,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,12,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,13,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,14,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,15,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,16,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,17,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,18,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,19,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,20,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,21,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,22,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,23,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,24,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,25,0,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]

{"sheet":"Recibos de pago individuales","index":2,"n_rows":47,"n_cols":8,"rows_kept":47,"flags":["formulas_cached_only"]}
[]
[null,null,"[Nombre de la Compañía]"]
[null,null,"Periodo:","2004-02-01","Nombre del Empleado","Jay Adams","Identificación del Empleado",1]
[]
[null,null,"Estado Fiscal",1,"Asignación federal (de W-4)",4,"Horas laboradas",50]
[null,null,"Tarifa por hora",{"v":10,"d":"$10.00"},"Tarifa para horas extra",{"v":0,"d":"$0.00"},"Horas de enfermedad",1]
[null,null,"Seguro Social",{"v":35.28,"d":"$35.28"},"Impuesto sobre la renta federal ",{"v":156.8,"d":"$156.80"},"Horas de vacaciones",5]
[null,null,"Medicare ",{"v":8.120000000000001,"d":"$8.12"},"Impuesto estatal ",{"v":12.879999999999999,"d":"$12.88"},"Horas de tiempo extra",0]
[null,null,"Deducción del seguro",{"v":20,"d":"$20.00"},"Otras deducciones regulares",{"v":40,"d":"$40.00"},"Pago bruto",{"v":560,"d":"$560.00"}]
[null,null,"Total de impuestos y deducciones regulares ",{"v":273.08000000000004,"d":"$273.08"},"Otras deducciones",{"v":20,"d":"$20.00"},"Total de impuestos y deducciones ",{"v":293.08000000000004,"d":"$293.08"}]
[{"$nulls":6},"Pago Neto",{"v":266.91999999999996,"d":"$266.92"}]
[]
[]
[null,null,"[Nombre de la Compañía]"]
[null,null,"Periodo:","2004-02-01","Nombre del Empleado",0,"Identificación del Empleado",2]
[]
[null,null,"Estado fiscal",0,"Asignación federal (de W-4)",0,"Horas laboradas",0]
[null,null,"Tarifa por hora",{"v":0,"d":"$0.00"},"Tarifa para horas extra",{"v":0,"d":"$0.00"},"Horas de enfermedad",0]
[null,null,"Seguro Social",{"v":0,"d":"$0.00"},"Impuesto sobre la renta federal ",{"v":0,"d":"$0.00"},"Horas de vacaciones",0]
[null,null,"Medicare ",{"v":0,"d":"$0.00"},"Impuesto estatal ",{"v":0,"d":"$0.00"},"Horas de tiempo extra",0]
[null,null,"Deducción del seguro",{"v":0,"d":"$0.00"},"Otras deducciones regulares",{"v":0,"d":"$0.00"},"Pago bruto",{"v":0,"d":"$0.00"}]
[null,null,"Total de impuestos y deducciones regulares ",{"v":0,"d":"$0.00"},"Otras deducciones",{"v":0,"d":"$0.00"},"Total de impuestos y deducciones ",{"v":0,"d":"$0.00"}]
[{"$nulls":6},"Pago Neto",{"v":0,"d":"$0.00"}]
[]
[]
[null,null,"[Nombre de la Compañía]"]
[null,null,"Periodo:","2004-02-01","Nombre del Empleado",0,"Identificación del Empleado",3]
[]
[null,null,"Estado fiscal",0,"Asignación federal (de W-4)",0,"Horas laboradas",0]
[null,null,"Tarifa por hora",{"v":0,"d":"$0.00"},"Tarifa para horas extra",{"v":0,"d":"$0.00"},"Horas de enfermedad",0]
[null,null,"Seguro Social",{"v":0,"d":"$0.00"},"Impuesto sobre la renta federal ",{"v":0,"d":"$0.00"},"Horas de vacaciones",0]
[null,null,"Medicare ",{"v":0,"d":"$0.00"},"Impuesto estatal ",{"v":0,"d":"$0.00"},"Horas de tiempo extra",0]
[null,null,"Deducción del seguro",{"v":0,"d":"$0.00"},"Otras deducciones regulares",{"v":0,"d":"$0.00"},"Pago bruto",{"v":0,"d":"$0.00"}]
[null,null,"Total de impuestos y deducciones regulares ",{"v":0,"d":"$0.00"},"Otras deducciones",{"v":0,"d":"$0.00"},"Total de impuestos y deducciones ",{"v":0,"d":"$0.00"}]
[{"$nulls":6},"Pago Neto",{"v":0,"d":"$0.00"}]
[]
[]
[null,null,"[Nombre de la Compañía]"]
[null,null,"Periodo:","2004-02-01","Nombre del Empleado",0,"Identificación del Empleado",4]
[]
[null,null,"Estado fiscal",0,"Asignación federal (de W-4)",0,"Horas laboradas",0]
[null,null,"Tarifa por hora",{"v":0,"d":"$0.00"},"Tarifa para horas extra",{"v":0,"d":"$0.00"},"Horas de enfermedad",0]
[null,null,"Seguro Social",{"v":0,"d":"$0.00"},"Impuesto sobre la renta federal ",{"v":0,"d":"$0.00"},"Horas de vacaciones",0]
[null,null,"Medicare ",{"v":0,"d":"$0.00"},"Impuesto estatal ",{"v":0,"d":"$0.00"},"Horas de tiempo extra",0]
[null,null,"Deducción del seguro",{"v":0,"d":"$0.00"},"Otras deducciones regulares",{"v":0,"d":"$0.00"},"Pago bruto",{"v":0,"d":"$0.00"}]
[null,null,"Total de impuestos y deducciones regulares ",{"v":0,"d":"$0.00"},"Otras deducciones",{"v":0,"d":"$0.00"},"Total de impuestos y deducciones ",{"v":0,"d":"$0.00"}]
[{"$nulls":6},"Pago Neto",{"v":0,"d":"$0.00"}]