AutosumaSueldos MensualesCdigoEmpleadoSueldo BasePremioSubtotal1Campoverde Guambaa Nestorio$220.00$100.00$320.002GALARRAGA VELARDE JUAN CARLOS$250.00$120.00$370.003Medina Medina Lizbeth$400.00$100.00$500.004Vargas Maldonado Jos Angel$500.00$80.00$580.005Vargas Maldonado Jos Angel$250.00$90.00$340.006RAMIREZ COFRE WASHINGTON F.$100.00$10.00$110.007Rios Pearreta Eduardo M.$590.00$30.00$620.008Len Chenche Betsy Maribel$450.00$45.00$495.009Panchano Valencia Rocio$254.00$52.00$306.0010Pacheco Prez Jess Edison$165.00$63.00$228.0011Cueva Franco Antonio Franklin$245.00$41.00$286.0012Garzozi Buchdid Joseph Franklin$123.00$100.00$223.0013BUSTAMANTE GURUMENDI MANUEL$325.00$80.00$405.0014JIMENEZ FREIRE AMADA GERMANIA$311.00$75.00$386.0015CONFORME MUENTES LORENZA AMADA$351.00$85.00$436.0016PEREZ CASCANTE LUCILA$391.00$95.00$486.0017Larrea Feijoo Yadira Violeta$431.00$41.00$472.0018Martillo Moscoso Lidia Josefina$471.00$52.00$523.0019Alcvar Villegas Guido Benito$511.00$63.00$574.0020Moran Rojas Maria Elvira$551.00$42.00$593.0021MURILLO CARDENAS BETTY NANCY$591.00$62.00$653.0022Alava Garcs Jacinto A.$631.00$74.00$705.0023COBEA LEYTON WILSON HENRY$671.00$85.00$756.0024LASIO MORELLO MARIA VIRGINIA$711.00$12.00$723.0025Pacheco Lpez Toms Elicerio$751.00$10.00$761.0026MATEO BORBOR HERMOGENES MARCELINO$791.00$100.00$891.0027Nuez Alcvar Amada Elsa$831.00$12.00$843.0028Murillo Correa Hctor$400.00$125.00$525.0029DE LA CRUZ JIMENEZ ENRIQUE ERNESTO$100.00$10.00$110.0030Vera Castillo Hugo Anbal$200.00$30.00$230.0031CEDEO CEDEO PATRICIA MILDRED$300.00$45.00$345.0032LEON ASCENCIO MOISES ENRIQUE$400.00$52.00$452.0033OJEDA MORALES BLANCA PATRICIA$500.00$63.00$563.0034CONFORME ACOSTA DALIA$600.00$41.00$641.0035Lucero Mancilla Jimmy Xavier$700.00$30.00$730.0036YAGUAL GONZABAY CELSO FERNANDO$800.00$58.00$858.0037Campusano Castro Manuel Inocente$900.00$95.00$995.0038Castillo Lucio Dino$125.00$41.00$166.0039Paladines Castellanos Josue Stanli$198.00$52.00$250.0040ALVARADO LOZADA JUAN$250.00$35.00$285.0041SALVADOR ANDRADE CARLOS EDUARDO$100.00$15.00$115.0042CIRES MORAN FREDDY XAVIER$200.00$25.00$225.0043Nuez Torres Ruby del Rocio$300.00$14.00$314.0044Portalanza Alexandra$400.00$25.00$425.0045Velsquez Rendn Elsa Brgida$150.00$60.00$210.0046Merino Torres Fabrizio$150.00$58.00$208.0047Cobea Leyton Wilson Henrry$150.00$74.00$224.0048HERRERA ULLOA MARTHA DEL ROCIO$150.00$85.00$235.0049PANCHANA CHALEN PILAR$150.00$45.00$195.0050Lam Alcvar Cinthia Gioconda$150.00$52.00$202.0051PIEDRAHITA COBOS SILVIA MARIA$150.00$63.00$213.0052CHANABA RUIZ ALEJANDRO$150.00$41.00$191.0053CIRES QUINTERO EVELYN SCARLETH$150.00$30.00$180.0054Meja Luna Jacqueline Narcisa$150.00$58.00$208.0055PRECIADO JACOME GINGER BRIGIDA$150.00$95.00$245.0056Zevallos Ramirez Gonzalo$150.00$41.00$191.0057Pilay Escalante Oswaldo A.$180.00$52.00$232.0058ESPINOZA FAJARDO ALBA ROSA$180.00$35.00$215.0059PIZARRO ESPINOZA PIEDAD MAURICIA$180.00$15.00$195.0060SILVA DELGADO ALEXANDRA$180.00$25.00$205.0061Valle Snchez Maribel Irwinka$180.00$14.00$194.0062Tanqueo Tierra Silvia Elena$180.00$25.00$205.0063SILVA DELGADO YANIRE$180.00$60.00$240.0064Freire Daz Freddy$180.00$45.00$225.0065FERNANDEZ RUIZ VICTOR HUGO$180.00$52.00$232.0066Rigail Cedeo Alberto Enrique$180.00$63.00$243.0067Ruiz Correa Yonis Leonardo$180.00$41.00$221.0068Huacon Murillo Robin Octavio$180.00$30.00$210.0069Gallegos Chacn Germn$180.00$58.00$238.0070CALVAS ESPINOSA MARIA ELENA$180.00$95.00$275.0071RANGEL DONOSO NESTOR DUGLAS$180.00$41.00$221.0072CARPIO SARANGO BELLA NANCY$180.00$52.00$232.0073Lindao Eugenio Shirley Cecibel$180.00$35.00$215.0074Espinoza Crdenas Alex David$180.00$15.00$195.0075RUIZ BURGOS JOHN BELU$180.00$25.00$205.0076MATOVELLE VILLAMAR RUTH$450.00$14.00$464.0077GILER CASTILLO PILAR$254.00$25.00$279.0078Villacs Vega Igor Alexis$125.00$60.00$185.0079BARCOS FARIAS DIOGENES DAVID$325.00$40.00$365.0080MORENO RAMIREZ ALVARO LEOPOLDO$124.00$85.00$209.0081ECHEVERRIA FIGUEROA KENNY LUCIANO$254.00$74.00$328.0082Rivera San Lucas Silvia Mara$217.00$58.00$275.0083Cevallos Oganov Manuel E.$545.00$254.00$799.00$25,853.00$4,565.00$30,418.00

1.- Sacar el Subtotal multiplincando Sueldo Base por el Premio( Aplicar Frmula =C6*D6

2.- Aplicar Autosuma Para sacar un Total General al final

PracticaSueldos MensualesCdigoEmpleadoTotal IngresosTotal EgresosNeto1Campoverde Guambaa Nestorio$220.00$100.00$320.002GALARRAGA VELARDE JUAN CARLOS$250.00$120.00$370.003Medina Medina Lizbeth$400.00$100.00$500.004Vargas Maldonado Jos Angel$500.00$80.00$580.005Vargas Maldonado Jos Angel$250.00$90.00$340.006RAMIREZ COFRE WASHINGTON F.$100.00$10.00$110.007Rios Pearreta Eduardo M.$590.00$30.00$620.008Len Chenche Betsy Maribel$450.00$45.00$495.009Panchano Valencia Rocio$254.00$52.00$306.0010Pacheco Prez Jess Edison$165.00$63.00$228.0011Cueva Franco Antonio Franklin$245.00$41.00$286.0012Garzozi Buchdid Joseph Franklin$123.00$100.00$223.0013BUSTAMANTE GURUMENDI MANUEL$325.00$80.00$405.0014JIMENEZ FREIRE AMADA GERMANIA$311.00$75.00$386.0015CONFORME MUENTES LORENZA AMADA$351.00$85.00$436.0016PEREZ CASCANTE LUCILA$391.00$95.00$486.0017Larrea Feijoo Yadira Violeta$431.00$41.00$472.0018Martillo Moscoso Lidia Josefina$471.00$52.00$523.0019Alcvar Villegas Guido Benito$511.00$63.00$574.0020Moran Rojas Maria Elvira$551.00$42.00$593.0021MURILLO CARDENAS BETTY NANCY$591.00$62.00$653.0022Alava Garcs Jacinto A.$631.00$74.00$705.0023COBEA LEYTON WILSON HENRY$671.00$85.00$756.0024LASIO MORELLO MARIA VIRGINIA$711.00$12.00$723.0025Pacheco Lpez Toms Elicerio$751.00$10.00$761.0026MATEO BORBOR HERMOGENES MARCELINO$791.00$100.00$891.0027Nuez Alcvar Amada Elsa$831.00$12.00$843.0028Murillo Correa Hctor$400.00$125.00$525.0029DE LA CRUZ JIMENEZ ENRIQUE ERNESTO$100.00$10.00$110.0030Vera Castillo Hugo Anbal$200.00$30.00$230.0031CEDEO CEDEO PATRICIA MILDRED$300.00$45.00$345.0032LEON ASCENCIO MOISES ENRIQUE$400.00$52.00$452.0033OJEDA MORALES BLANCA PATRICIA$500.00$63.00$563.0034CONFORME ACOSTA DALIA$600.00$41.00$641.0035Lucero Mancilla Jimmy Xavier$700.00$30.00$730.0036YAGUAL GONZABAY CELSO FERNANDO$800.00$58.00$858.0037Campusano Castro Manuel Inocente$900.00$95.00$995.0038Castillo Lucio Dino$125.00$41.00$166.0039Paladines Castellanos Josue Stanli$198.00$52.00$250.0040ALVARADO LOZADA JUAN$250.00$35.00$285.0041SALVADOR ANDRADE CARLOS EDUARDO$100.00$15.00$115.0042CIRES MORAN FREDDY XAVIER$200.00$25.00$225.0043Nuez Torres Ruby del Rocio$300.00$14.00$314.0044Portalanza Alexandra$400.00$25.00$425.0045Velsquez Rendn Elsa Brgida$150.00$60.00$210.0046Merino Torres Fabrizio$150.00$58.00$208.0047Cobea Leyton Wilson Henrry$150.00$74.00$224.0048HERRERA ULLOA MARTHA DEL ROCIO$150.00$85.00$235.0049PANCHANA CHALEN PILAR$150.00$45.00$195.0050Lam Alcvar Cinthia Gioconda$150.00$52.00$202.0051PIEDRAHITA COBOS SILVIA MARIA$150.00$63.00$213.0052CHANABA RUIZ ALEJANDRO$150.00$41.00$191.0053CIRES QUINTERO EVELYN SCARLETH$150.00$30.00$180.0054Meja Luna Jacqueline Narcisa$150.00$58.00$208.0055PRECIADO JACOME GINGER BRIGIDA$150.00$95.00$245.0056Zevallos Ramirez Gonzalo$150.00$41.00$191.0057Pilay Escalante Oswaldo A.$180.00$52.00$232.0058ESPINOZA FAJARDO ALBA ROSA$180.00$35.00$215.0059PIZARRO ESPINOZA PIEDAD MAURICIA$180.00$15.00$195.0060SILVA DELGADO ALEXANDRA$180.00$25.00$205.0061Valle Snchez Maribel Irwinka$180.00$14.00$194.0062Tanqueo Tierra Silvia Elena$180.00$25.00$205.0063SILVA DELGADO YANIRE$180.00$60.00$240.0064Freire Daz Freddy$180.00$45.00$225.0065FERNANDEZ RUIZ VICTOR HUGO$180.00$52.00$232.0066Rigail Cedeo Alberto Enrique$180.00$63.00$243.0067Ruiz Correa Yonis Leonardo$180.00$41.00$221.0068Huacon Murillo Robin Octavio$180.00$30.00$210.0069Gallegos Chacn Germn$180.00$58.00$238.0070CALVAS ESPINOSA MARIA ELENA$180.00$95.00$275.0071RANGEL DONOSO NESTOR DUGLAS$180.00$41.00$221.0072CARPIO SARANGO BELLA NANCY$180.00$52.00$232.0073Lindao Eugenio Shirley Cecibel$180.00$35.00$215.0074Espinoza Crdenas Alex David$180.00$15.00$195.0075RUIZ BURGOS JOHN BELU$180.00$25.00$205.0076MATOVELLE VILLAMAR RUTH$450.00$14.00$464.0077GILER CASTILLO PILAR$254.00$25.00$279.0078Villacs Vega Igor Alexis$125.00$60.00$185.0079BARCOS FARIAS DIOGENES DAVID$325.00$40.00$365.0080MORENO RAMIREZ ALVARO LEOPOLDO$124.00$85.00$209.0081ECHEVERRIA FIGUEROA KENNY LUCIANO$254.00$74.00$328.0082Rivera San Lucas Silvia Mara$217.00$58.00$275.0083Cevallos Oganov Manuel E.$545.00$254.00$799.00$25,853.00$4,565.00$30,418.00

1.- Aplicar Frmula para sacar el Neto a Pagar por Empleado2.-Aplicar Auto Suma para Totalizar el Neto

MximoCODIGOPRODUCTOCOSTO1015Acido sacamancha14.161000Archivador Ideal grande30.24333.202005Bolgrafo Bic Azul0.802002Borrador blanco pelikan PZ 200.135001Desinfectante para pisos2.875002Diskettes imation 2HD1.897000Franela1.488011Grapadora Swingline 4448.9617013Papel Higinico Jumbo Scott2.2217006Pos-it 3M 1.5 varios colores4.6821007Tijeras0.2221000Toallas de mano15.0819009Respirador para polvo 3M10.961101Guantes de lana20.292818Shampoo para alfombras15.6817043Platos desechables P-60.8514031Matriz TRI510/CR1610201.601023Agua ALPORT S.A4.645090Desengrasante alcalino2.8880109Acido Muritico3.368055Hojas (Kimberly) T/A4 Blanco/Titanio52.805694Acid cleaner (Limpiador cido)5.381024AGUA ACRISTAL C.A.27.5920051Balde0.9910104Pilas Energizer Alcalina AA4.3010106Hojas Xerox T/A 4 110% Blancura333.2010107Goma en Barra UHU2.2010108Toner Workcentre M15 PDG-162084184.5310113Pos. it 3x3 Acua15.7211115Te Aromatico con Miel1.0710124Hojas 75gr. Norma48.001021001Toalla Megaroll8.62120540Leche La Vaquita 480gr.10.3621158Marcador P/F Uniball0.4813051Insect. Mata Cucarachas Raid 400 cm32.34101012Ambiental en barra TIPS4.5713451Vasos Plstico de 7 onz.2.582051Lpiz porta mina con Logo Espol grip Bic 0.702.6012055Toner Samsung ML 1610D267.2015242Etiquetas adhesiva T-151.8515023Te Aromatico Gourmet3.4615026Limnisdor de Alfombra4.4816241BOLIGRAFO ESPOL MODELO JOYA1.1216242BOLIGRAFO ESPOL MODELO BU24.2116248Funda 30x36 Natural10.98Valor Mximo333.20

1.- Aplicar Funcin : Men Insertar, Funcin, seleccionar categora todas, seleccionar MAX

MnimoCODIGOPRODUCTOCOSTO1015Acido sacamancha14.161000Archivador Ideal grande30.242005Bolgrafo Bic Azul0.802002Borrador blanco pelikan PZ 200.135001Desinfectante para pisos2.875002Diskettes imation 2HD1.897000Franela1.488011Grapadora Swingline 4448.9617013Papel Higinico Jumbo Scott2.2217006Pos-it 3M 1.5 varios colores4.6821007Tijeras0.2221000Toallas de mano15.0819009Respirador para polvo 3M10.961101Guantes de lana20.292818Shampoo para alfombras15.6817043Platos desechables P-60.8514031Matriz TRI510/CR1610201.601023Agua ALPORT S.A4.645090Desengrasante alcalino2.8880109Acido Muritico3.368055Hojas (Kimberly) T/A4 Blanco/Titanio52.805694Acid cleaner (Limpiador cido)5.381024AGUA ACRISTAL C.A.27.5920051Balde0.9910104Pilas Energizer Alcalina AA4.3010106Hojas Xerox T/A 4 110% Blancura333.2010107Goma en Barra UHU2.2010108Toner Workcentre M15 PDG-162084184.5310113Pos. it 3x3 Acua15.7211115Te Aromatico con Miel1.0710124Hojas 75gr. Norma48.001021001Toalla Megaroll8.62120540Leche La Vaquita 480gr.10.3621158Marcador P/F Uniball0.4813051Insect. Mata Cucarachas Raid 400 cm32.34101012Ambiental en barra TIPS4.5713451Vasos Plstico de 7 onz.2.582051Lpiz porta mina con Logo Espol grip Bic 0.702.6012055Toner Samsung ML 1610D267.2015242Etiquetas adhesiva T-151.8515023Te Aromatico Gourmet3.4615026Limnisdor de Alfombra4.4816241BOLIGRAFO ESPOL MODELO JOYA1.1216242BOLIGRAFO ESPOL MODELO BU24.2116248Funda 30x36 Natural10.98Valor Mnimo0.13

1.- Aplicar Funcin : Men Insertar, Funcin, seleccionar categora todas, seleccionar MIN

PromedioEstudiantesCalificacin 1Calificacin 2Calificacin 3SUBTOTALPromedioCampoverde Guambaa Nestorio2018185618.67GALARRAGA VELARDE JUAN CARLOS2020206020.00Medina Medina Lizbeth1020205016.67Vargas Maldonado Jos Angel1219195016.67Vargas Maldonado Jos Angel1518185117.00RAMIREZ COFRE WASHINGTON F.1618185217.33Rios Pearreta Eduardo M.1817175217.33Len Chenche Betsy Maribel1916165117.00Panchano Valencia Rocio1414144214.00Pacheco Prez Jess Edison1212113511.67Cueva Franco Antonio Franklin1313123812.67Garzozi Buchdid Joseph Franklin1515205016.67BUSTAMANTE GURUMENDI MANUEL1919195719.00JIMENEZ FREIRE AMADA GERMANIA1414194715.67CONFORME MUENTES LORENZA AMADA1515194916.33PEREZ CASCANTE LUCILA1212184214.00Larrea Feijoo Yadira Violeta1717175117.00Martillo Moscoso Lidia Josefina1820165418.00Alcvar Villegas Guido Benito2020125217.33Moran Rojas Maria Elvira2020135317.67MURILLO CARDENAS BETTY NANCY1920155418.00Alava Garcs Jacinto A.1820195719.00COBEA LEYTON WILSON HENRY1820145217.33LASIO MORELLO MARIA VIRGINIA1712154414.67Pacheco Lpez Toms Elicerio1612124013.33MATEO BORBOR HERMOGENES MARCELINO1420175117.00

PracticaFuncionFECHA HOY3/12/14CORPORACION DE FINANZAS INTERNASULTIMO INGRESOREGISTRO DEL PERSONALNOMBRE DEL EMPLEADOTELF (Ext)NUM. DPTO.NUM. OFIC.NOMBRE DEL DEPARTAMENTOFECHA DE INGRESOSUELDO BASICOCATEGORIA SALARIAL1Lombeida, Jorge2822220SISTEMAS2-Dec-87$ 940.00AYUDANTE2Jcome, Fausto2812220SISTEMAS20-Dec-87$ 860.00AYUDANTE3Aguirre, Faustino2801210PROGRAMACION17-Jan-88$ 485.00OBRERO4Alvarez, Alfredo2754120CAJA2-Jan-88$ 750.00AYUDANTE5Dominguez, Michelle2713130PERSONAL22-Mar-88$ 985.00AYUDANTE6Bonilla, Rene2835110VENTAS21-Apr-88$ 1,195.00JEFE7Norton, Peter2741210PROGRAMACION3-May-88$ 280.00OBRERO8Perkings, Anthony2704120CAJA14-Jan-90$ 1,776.00SUBGERENTE9Escobar, Nelson2792220SISTEMAS12-Jan-90$ 295.00OBRERO10Rojas, isabel2786230GERENCIA1-Mar-90$ 580.00AUXILIAR11Paladines, Alexandra2763130PERSONAL12-Dec-86$ 1,400.00JEFE12Solrzano, Nayeth2773130PERSONAL12-Dec-86$ 1,850.00SUBGERENTEDEPT.OFCNOMBRERANGOCATEGORIA1210PROGRAMACION$ 200.00OBRERO2220SISTEMAS$ 500.00AUXILIAR3130PERSONAL$ 700.00AYUDANTE4120CAJA$ 1,000.00JEFE5110VENTAS$ 1,500.00SUBGERENTE6230GERENCIA$ 2,000.00GERENTEOBTENER EL MAXIMO SUELDO$ 1,776.00MAX$ 2,000.00OBTENER EL MINIMO SUELDO$ 280.00MIN$ 200.00OBTENER EL PROMEDIO DE LOS SUELDOS$ 949.67PROMEDIO$ 983.33CONTAR CUANTOS TRABAJADORES HAYCONTAR