Universidad Anáhuac México Norte

Ana Isabel Morales Di Donna

Practica Excel #2

Prof. Carlos Delgado

22 de Febrero 2011

REPORTE

Esta práctica se realzo sobre tablas en Excel que nos permitieran ver la información de 25

personas en cuanto a ingresos anuales, gastos médicos, colegiaturas, viáticos y egresos. De esta

forma obtuvimos los ingresos anuales, los deducibles, montos monetarios de diferentes gastos e

ingresos.

nombre apellido direccion correo electronico ingresos anuales deducibles total grabable ingresos a pagar

Ana Morales bosques a@hotmail.com $2,333,331.00 $79,034.00 $2,254,297.00 $360,687.52 Isabel Di Donna lomas i@hotmail.com $2,666,664.00 $480,525.00 $2,186,139.00 $349,782.24 Gabriela Cecin interlomas g@hotmail.com $2,999,997.00 $13,002.00 $2,986,995.00 $477,919.20 Paola Said santa fe p@hotmail.com $1,999,998.00 $588,012.00 $1,411,986.00 $225,917.76

Maria De Alba vista hermosa m@hotmail.com $1,666,665.00 $32,633.00 $1,634,032.00 $261,445.12

Fernanda Herrera satelite f@hotmail.com $1,333,332.00 $30,193.00 $1,303,139.00 $208,502.24 Pilar Aparicio cuajimalpa pi@hotmail.com $999,999.00 $115,346.00 $884,653.00 $141,544.48

Jose Olivares tecamachalco j@hotmail.com $666,666.00 $24,687.00 $641,979.00 $102,716.64 Andres quezada vesares an@hotmail.com $3,333,333.00 $566,212.00 $2,767,121.00 $442,739.36 Carlos Treviño retama c@hotmail.com $1,703,682.00 $496,083.00 $1,207,599.00 $193,215.84 Victor Mariscal coyoacan v@hotmail.com $2,962,962.00 $628,677.00 $2,334,285.00 $373,485.60 Manuel Villaseñor bosques ma@hotmail.com $370,332.00 $24,465.00 $345,867.00 $55,338.72 Ignacio Lopez lomas ig@hotmail.com $233,286,969.00 $3,528,489.00 $229,758,480.00 $36,761,356.80 Benjamin Polidura interlomas b@hotmail.com $21,754,011.00 $104,048.00 $21,649,963.00 $3,463,994.08 Renata Blando santa fe r@hotmail.com $10,370,325.00 $437,023.00 $9,933,302.00 $1,589,328.32

Pamela Samano vista hermosa pam@hotmail.com $1,626,732.00 $36,209.00 $1,590,523.00 $254,483.68

Alejandra Camara satelite al@hotmail.com $1,370,343.00 $69,456.00 $1,300,887.00 $208,141.92 Daniel Rion cuajimalpa da@hotmail.com $1,033,035.00 $70,546.00 $962,489.00 $153,998.24

Santiago Arguelles tecamachalco sa@hotmail.com $100,303,032.00 $162,603.00 $100,140,429.00 $16,022,468.64 Paulina Huber vesares pu@hotmail.com $6,697,035.00 $59,953.00 $6,637,082.00 $1,061,933.12 Bernardo Diaz retama ber@hotmail.com $13,639,296.00 $9,247.00 $13,630,049.00 $2,180,807.84 Javier Torres coyoacan j@hotmail.com $703,629.00 $4,803.00 $698,826.00 $111,812.16 Patricio Perez bosques pat@hotmail.com $6,973,329.00 $491,084.00 $6,482,245.00 $1,037,159.20 Elias Martinez lomas e@hotmail.com $703,638.00 $102,514.00 $601,124.00 $96,179.84 Roberto Phillipe santa fe ro@hotmail.com $2,367,000.00 $61,532.00 $2,305,468.00 $368,874.88

Empezamos por ingresar los datos de 25 personas: nombre, apellido, e-mail, teléfonos. Después

de esto sacamos los gastos de cada persona en cuantas colegiaturas, gastos médicos y

simplemente con un copiado de celda pasamos todos los totales a una base de datos dando como

resultado la visualización de estos en 1 hoja.

nombre apellidos ingresos base horas extra comisiones viaticos aguinaldo total ingresos Ana Morales $777,777.00 $136,110.98 $1,270,483.46 $145,672.00 $1,555,554.00 $2,333,331.00 Isabel Di Donna $888,888.00 $155,555.40 $1,270,483.46 $906,644.00 $1,777,776.00 $2,666,664.00 Gabriela Cecin $999,999.00 $174,999.83 $1,270,483.46 $761,210.00 $1,999,998.00 $2,999,997.00 Paola Said $666,666.00 $116,666.55 $1,270,483.46 $880,114.00 $1,333,332.00 $1,999,998.00 Maria De Alba $555,555.00 $97,222.13 $1,270,483.46 $92,386.00 $1,111,110.00 $1,666,665.00 Fernanda Herrera $444,444.00 $77,777.70 $1,270,483.46 $3,922,687.00 $888,888.00 $1,333,332.00 Pilar Aparicio $333,333.00 $58,333.28 $1,270,483.46 $139,906.00 $666,666.00 $999,999.00 Jose Olivares $222,222.00 $38,888.85 $1,270,483.46 $612,391.00 $444,444.00 $666,666.00 Andres quezada $1,111,111.00 $194,444.43 $1,270,483.46 $5,710,267.00 $2,222,222.00 $3,333,333.00 Carlos Treviño $567,894.00 $99,381.45 $1,270,483.46 $255,790.00 $1,135,788.00 $1,703,682.00 Victor Mariscal $987,654.00 $172,839.45 $1,270,483.46 $675,911.00 $1,975,308.00 $2,962,962.00 Manuel Villaseñor $123,444.00 $21,602.70 $1,270,483.46 $619,658.00 $246,888.00 $370,332.00 Ignacio Lopez $77,762,323.00 $13,608,406.53 $1,270,483.46 $55,395.00 $155,524,646.00 $233,286,969.00 Benjamin Polidura $7,251,337.00 $1,268,983.98 $1,270,483.46 $842,255.00 $14,502,674.00 $21,754,011.00 Renata Blando $3,456,775.00 $604,935.63 $1,270,483.46 $157,579.00 $6,913,550.00 $10,370,325.00 Pamela Samano $542,244.00 $94,892.70 $1,270,483.46 $95,711.00 $1,084,488.00 $1,626,732.00 Alejandra Camara $456,781.00 $79,936.68 $1,270,483.46 $671,142.00 $913,562.00 $1,370,343.00 Daniel Rion $344,345.00 $60,260.38 $1,270,483.46 $4,327,558.00 $688,690.00 $1,033,035.00 Santiago Arguelles $33,434,344.00 $5,851,010.20 $1,270,483.46 $96,169.00 $66,868,688.00 $100,303,032.00 Paulina Huber $2,232,345.00 $390,660.38 $1,270,483.46 $515,323.00 $4,464,690.00 $6,697,035.00 Bernardo Diaz $4,546,432.00 $795,625.60 $1,270,483.46 $136,797.00 $9,092,864.00 $13,639,296.00 Javier Torres $234,543.00 $41,045.03 $1,270,483.46 $12,591.00 $469,086.00 $703,629.00 Patricio Perez $2,324,443.00 $406,777.53 $1,270,483.46 $20,717.00 $4,648,886.00 $6,973,329.00 Elias Martinez $234,546.00 $41,045.55 $1,270,483.46 $375,490.00 $469,092.00 $703,638.00 Roberto Phillipe $789,000.00 $138,075.00 $1,270,483.46 $43,340.00 $1,578,000.00 $2,367,000.00

En esta tabla después de ingresar las cantidades necesarias sumamos y hicimos ciado de algunas

celdas como en este caso la de viáticos.

nombres apellido comidas viaticos colegiaturas pasatiempos gastos medicos total deducibles Ana Morales $3,532,537.00 $145,672.00 $12,000.00 $9,659,483.00 $67,034.00 $79,034.00 Isabel Di Donna $678,664.00 $906,644.00 $12,000.00 $357,574.00 $468,525.00 $480,525.00 Gabriela Cecin $2,543,658.00 $761,210.00 $12,000.00 $3,263,768.00 $1,002.00 $13,002.00 Paola Said $368,980.00 $880,114.00 $12,000.00 $46,314,321.00 $576,012.00 $588,012.00 Maria De Alba $43,668.00 $92,386.00 $24,000.00 $547,588.00 $8,633.00 $32,633.00 Fernanda Herrera $43,707,699.00 $3,922,687.00 $24,000.00 $214,324.00 $6,193.00 $30,193.00 Pilar Aparicio $6,783,626.00 $139,906.00 $24,000.00 $545,447.00 $91,346.00 $115,346.00 Jose Olivares $657,900.00 $612,391.00 $24,000.00 $21,156.00 $687.00 $24,687.00 Andres quezada $3,547,679.00 $5,710,267.00 $24,000.00 $436,679.00 $542,212.00 $566,212.00 Carlos Treviño $36,769.00 $255,790.00 $24,000.00 $5,444,578.00 $472,083.00 $496,083.00 Victor Mariscal $3,267.00 $675,911.00 $24,000.00 $3,243,574.00 $604,677.00 $628,677.00 Manuel Villaseñor $454,769.00 $619,658.00 $24,000.00 $6,599.00 $465.00 $24,465.00 Ignacio Lopez $365,676,909.00 $55,395.00 $29,000.00 $63,643,787.00 $3,499,489.00 $3,528,489.00 Benjamin Polidura $546,868.00 $842,255.00 $29,000.00 $34,543,758.00 $75,048.00 $104,048.00 Renata Blando $334,325.00 $157,579.00 $29,000.00 $4,367.00 $408,023.00 $437,023.00 Pamela Samano $787,745.00 $95,711.00 $29,000.00 $780,568.00 $7,209.00 $36,209.00 Alejandra Camara $1,243,346.00 $671,142.00 $66,000.00 $66,590.00 $3,456.00 $69,456.00 Daniel Rion $4,366,586.00 $4,327,558.00 $66,000.00 $432,568.00 $4,546.00 $70,546.00 Santiago Arguelles $5,467,580.00 $96,169.00 $66,000.00 $43,887.00 $96,603.00 $162,603.00 Paulina Huber $54,656,767.00 $515,323.00 $56,000.00 $43,686,509.00 $3,953.00 $59,953.00 Bernardo Diaz $254,325.00 $136,797.00 $0.00 $468,809.00 $9,247.00 $9,247.00 Javier Torres $8,987,998.00 $12,591.00 $0.00 $878,758.00 $4,803.00 $4,803.00 Patricio Perez $564,357,586.00 $20,717.00 $0.00 $47,547.00 $491,084.00 $491,084.00 Elias Martinez $436,477.00 $375,490.00 $0.00 $5,366,589.00 $102,514.00 $102,514.00 Roberto Phillipe $546,567.00 $43,340.00 $0.00 $476,980.00 $61,532.00 $61,532.00

En esta tabla ingresamos las cantidades inventadas, pegamos de la misma manera los viáticos, las

colegiaturas y los gastos médicos. Sumamos las colegiaturas y los gastos médicos para obtener el

total de deducibles.

nombres apellidos apellidos padre nivel escolar monto anual total

mariana Morales Morales primaria $108,000.00 $12,000.00 $12,000.00 yolanda Di Donna Di Donna primaria $108,000.00 $12,000.00 $12,000.00 estefania Cecin Cecin primaria $108,000.00 $12,000.00 $12,000.00 allison Said Said primaria $108,000.00 $12,000.00 $12,000.00 lucia De Alba De Alba primaria $108,000.00 $12,000.00 $24,000.00 renzo De Alba De Alba primaria $108,000.00 $12,000.00

uchhi Herrera Herrera primaria $108,000.00 $12,000.00 $24,000.00 sergio Herrera Herrera primaria $108,000.00 $12,000.00

pedro Aparicio Aparicio primaria $108,000.00 $12,000.00 $24,000.00 jorge Aparicio Aparicio primaria $108,000.00 $12,000.00

fernanda Olivares Olivares primaria $108,000.00 $12,000.00 $24,000.00 migel Olivares Olivares primaria $108,000.00 $12,000.00

maria quezada quezada primaria $108,000.00 $12,000.00 $24,000.00 sofia quezada quezada primaria $108,000.00 $12,000.00

monica Treviño Treviño primaria $108,000.00 $12,000.00 $24,000.00 bruno Treviño Treviño primaria $108,000.00 $12,000.00

charles Mariscal Mariscal primaria $108,000.00 $12,000.00 $24,000.00 alexandra Mariscal Mariscal primaria $108,000.00 $12,000.00

andrea Villaseñor Villaseñor primaria $108,000.00 $12,000.00 $24,000.00 maximilian Villaseñor Villaseñor primaria $108,000.00 $12,000.00

manuela Lopez Lopez primaria $108,000.00 $12,000.00 $29,000.00 pilar Lopez Lopez secundaria $153,000.00 $17,000.00

cristina Polidura Polidura primaria $108,000.00 $12,000.00 $29,000.00 juan Polidura Polidura secundaria $153,000.00 $17,000.00

constanza Blando Blando primaria $108,000.00 $12,000.00 $29,000.00 pablo Blando Blando secundaria $153,000.00 $17,000.00

camila Samano Samano primaria $108,000.00 $12,000.00 $29,000.00 regina Samano Samano secundaria $153,000.00 $17,000.00

rodolfo Camara Camara bachillerato $198,000.00 $22,000.00 $66,000.00 ofelia Camara Camara bachillerato $198,000.00 $22,000.00

valeria Camara Camara bachillerato $198,000.00 $22,000.00 lucila Rion Rion bachillerato $198,000.00 $22,000.00 $66,000.00

verito Rion Rion bachillerato $198,000.00 $22,000.00 irene Rion Rion bachillerato $198,000.00 $22,000.00 nuria Arguelles Arguelles bachillerato $198,000.00 $22,000.00 $66,000.00

daniela Arguelles Arguelles bachillerato $198,000.00 $22,000.00 isabella Arguelles Arguelles bachillerato $198,000.00 $22,000.00 fernando Huber Huber secundaria $153,000.00 $17,000.00 $56,000.00

jean Huber Huber secundaria $153,000.00 $17,000.00 Anna Huber Huber bachillerato $198,000.00 $22,000.00

Ingresamos los nombres de los hijos y su nivel escolar, obtuvimos multiplicando el precio de nivel

por 9 el monto anual y por medio de la fórmula de SI el total.

nombres apellidos consultas analisis intervenciones total Ana Morales $3,467.00 $63,567.00

$67,034.00

Isabel Di Donna $637.00

$467,888.00 $468,525.00 Gabriela Cecin $546.00

$456.00 $1,002.00

Paola Said $4,768.00 $565,768.00 $5,476.00 $576,012.00 Maria De Alba

$5,367.00 $3,266.00 $8,633.00

Fernanda Herrera $536.00

$5,657.00 $6,193.00 Pilar Aparicio $47,657.00

$43,689.00 $91,346.00

Jose Olivares

$3,465,467.00 $67,467.00 $3,532,934.00 Andres quezada

$536,567.00 $5,645.00 $542,212.00

Carlos Treviño

$467,758.00 $4,325.00 $472,083.00 Victor Mariscal $566,869.00 $34,343.00 $3,465.00 $604,677.00 Manuel Villaseñor $5,467.00 $4,325,356.00 $366.00 $4,331,189.00 Ignacio Lopez $3,265,436.00 $233,465.00 $588.00 $3,499,489.00 Benjamin Polidura $69,684.00

$5,364.00 $75,048.00

Renata Blando $364,378.00

$43,645.00 $408,023.00 Pamela Samano

$3,647.00 $3,562.00 $7,209.00

Alejandra Camara

$3,456.00 $3,456.00 Daniel Rion $5,676,869.00 $4,365.00 $8,767.00 $5,690,001.00 Santiago Arguelles $578.00 $28,689.00 $67,336.00 $96,603.00 Paulina Huber

$486.00 $3,467.00 $3,953.00

Bernardo Diaz $333.00 $4,567.00 $4,347.00 $9,247.00 Javier Torres $436.00

$4,367.00 $4,803.00

Patricio Perez $54,647.00

$436,437.00 $491,084.00 Elias Martinez

$34,647.00 $67,867.00 $102,514.00

Roberto Phillipe $54,767.00

$6,765.00 $61,532.00

Ingresamos las cantidades de consultas, análisis, intervenciones y las sumamos para obtener el

total.

nombre apellido transporte aereo

transporte terrestre

perdiem + hospedaje

gastos de representacion total

Ana Morales $22,222.00

$88,888.00 $34,562.00 $145,672.00 Isabel Di Donna $3,333.00 $667,843.00 $234,234.00 $1,234.00 $906,644.00 Gabriela Cecin $4,444.00 $45,678.00 $654,290.00 $56,798.00 $761,210.00 Paola Said $5,555.00 $63,235.00 $765,545.00 $45,779.00 $880,114.00 Maria De Alba $6,666.00 $3,453.00 $35,689.00 $46,578.00 $92,386.00 Fernanda Herrera

$465,789.00 $3,221,442.00 $235,456.00 $3,922,687.00

Pilar Aparicio

$98,273.00 $35,853.00 $5,780.00 $139,906.00 Jose Olivares $7,777.00 $2,223.00 $34,585.00 $567,806.00 $612,391.00 Andres quezada $2,222.00 $22,345.00 $5,679,000.00 $6,700.00 $5,710,267.00 Carlos Treviño $34,680.00 $86,543.00 $122,222.00 $12,345.00 $255,790.00 Victor Mariscal

$4,567.00 $3,456.00 $667,888.00 $675,911.00

Manuel Villaseñor

$32,546.00 $232,545.00 $354,567.00 $619,658.00 Ignacio Lopez $5,678.00 $35,464.00 $9,897.00 $4,356.00 $55,395.00 Benjamin Polidura $809,643.00 $3,567.00 $25,367.00 $3,678.00 $842,255.00 Renata Blando

$87,896.00 $69,678.00 $5.00 $157,579.00

Pamela Samano

$54,356.00 $36,678.00 $4,677.00 $95,711.00 Alejandra Camara

$567,898.00 $35,346.00 $67,898.00 $671,142.00

Daniel Rion

$1,223.00 $989.00 $4,325,346.00 $4,327,558.00 Santiago Arguelles $46,700.00 $23,455.00 $2,579.00 $23,435.00 $96,169.00 Paulina Huber $13,566.00 $586.00 $45,625.00 $455,546.00 $515,323.00 Bernardo Diaz

$4,574.00 $9,879.00 $122,344.00 $136,797.00

Javier Torres

$5,790.00 $4,366.00 $2,435.00 $12,591.00 Patricio Perez

$4,213.00 $6,758.00 $9,746.00 $20,717.00

Elias Martinez

$3,568.00 $367,565.00 $4,357.00 $375,490.00 Roberto Phillipe $9,999.00 $865.00 $25,577.00 $6,899.00 $43,340.00

Ingresamos los gastos de transportes y representación y los sumamos para obtener el total.

Después hicimos un copiado de resultados en las celdas correspondientes y acabamos la práctica.

CONCLUSIONES

Práctica de Excel en donde practicamos suma, resta, copy-paste, entendimiento y orden de datos,

elaboración de tablas.