PrincipalANTIGEDADTOTAL GANADOAGUINALDO$ 258.61Fecha Inicio8/18/14Antepenultimo mes$ 700.00DOBLE AGUINALDO$ 517.22Fecha Fin12/31/14Penultimo mes$ 700.00Meses Trabajados4Ultimo mes$ 700.00Dias Trabajados13Promedio$ 700.00*Ingrese los datos solo en las celdas amarillas

Planilla aguinaldoPLANILLA DE AGUINALDOSTotal GanadoNroIDNombre CompletoFecha InicioFecha FinMeses trabajadosDias TrabajadosTotal G. Mes 1Total G. Mes 2Total G. Mes 3PromedioAguinaldo a Pagar1123456pepe perez02/28/201309/28/2013629800.00 $800.00 $800.00 $800.00 $464.44 $2678910luis fuentes05/17/201312/31/2013714700.00 $700.00 $700.00 $700.00 $435.56 $3654321maria avila01/01/201312/31/2013120500.00 $500.00 $600.00 $533.33 $533.33 $412/31/20130.00 $0.00 $512/31/20130.00 $0.00 $612/31/20130.00 $0.00 $712/31/20130.00 $0.00 $812/31/20130.00 $0.00 $912/31/20130.00 $0.00 $1012/31/20130.00 $0.00 $1112/31/20130.00 $0.00 $1212/31/20130.00 $0.00 $1312/31/20130.00 $0.00 $1412/31/20130.00 $0.00 $1512/31/20130.00 $0.00 $1612/31/20130.00 $0.00 $1712/31/20130.00 $0.00 $1812/31/20130.00 $0.00 $1912/31/20130.00 $0.00 $2012/31/20130.00 $0.00 $2112/31/20130.00 $0.00 $Total1,433.33 $

Sheet3