68

ADA 4 La Captura de Mis Gastos

Embed Size (px)

DESCRIPTION

en esta ada se presenta una tabla dinamica y grafica

Citation preview

portada

Mara Fernanda Quintal Lugo informatica IIADA 4 captua de mis gastos

tabla dinamica producto presio s fechas Queso para nachos lakti- k 1kg $15.904/8/15Chorizo horneado 0.110 kg $47.434/4/15Marinada taquero $132.004/4/15Etiquetas de columnaMilanesa 1.030 Kg$55.524/4/1503/26/2015Total 03/26/201512/10/214Total 12/10/2148/6/03Total 06/08/20033/6/04Total 06/03/20049/2/04Total 02/09/20046/6/05Total 06/06/20057/4/05Total 04/07/20052/3/06Total 03/02/20065/5/06Total 05/05/20066/6/06Total 06/06/20062/5/07Total 05/02/20078/5/07Total 05/08/20072/6/08Total 06/02/20085/5/08Total 05/05/20087/5/08Total 05/07/20083/5/09Total 05/03/20095/2/09Total 02/05/20096/5/09Total 05/06/20099/5/09Total 05/09/20095/6/10Total 06/05/20102/1/11Total 01/02/20112/5/11Total 05/02/20112/6/11Total 06/02/20117/8/13Total 08/07/20131/1/14Total 01/01/20141/2/14Total 02/01/20141/4/14Total 04/01/20141/6/14Total 06/01/20141/11/14Total 11/01/20141/13/14Total 13/01/20141/17/14Total 17/01/20142/3/14Total 03/02/20142/5/14Total 05/02/20142/6/14Total 06/02/20142/12/14Total 12/02/20142/19/14Total 19/02/20145/6/14Total 06/05/20146/4/14Total 04/06/20146/5/14Total 05/06/20146/6/14Total 06/06/20148/19/14Total 19/08/20148/24/14Total 24/08/20149/6/14Total 06/09/20149/9/14Total 09/09/201410/17/14Total 17/10/201411/13/14Total 13/11/201411/24/14Total 24/11/201412/6/14Total 06/12/201412/11/14Total 11/12/20141/2/15Total 02/01/20151/10/15Total 10/01/20151/14/15Total 14/01/20151/30/15Total 30/01/20152/3/15Total 03/02/20152/5/15Total 05/02/20152/9/15Total 09/02/20152/14/15Total 14/02/20152/16/15Total 16/02/20153/3/15Total 03/03/20154/4/15Total 04/04/20154/5/15Total 05/04/20154/8/15Total 08/04/20154/14/15Total 14/04/20154/15/15Total 15/04/20154/16/15Total 16/04/20154/20/15Total 20/04/2015Total generaltrapeador$20.004/4/15BOLSAdeterg bla deterg fre deterg suavallefrut 1ltrfuze te 400mlburn 450mlfuze te 500mlciel mini 300mlpowerade 500mlmineral 1tlmineral 1.5fuze te 453mlcoca cola zero mini lata 235ml fuze te 600mlte cristal 355ml lata mineral 400mlglaceu vitamin water 500mlfuze te 680mlmineral 600mineral powerade 1ltte cristal 1ltcrstal 600mlfuze te 1ltmineral 2ltbevi 1ltrpowerade 600mljugos del valle generosogas 20kg Deltajugos del valle 100mlcablemas telefonoqueso manchego 200gsalchicha fudcoca cola light 355ml chapur abonocrema de ajo desodarante axedeterg fre paquete de bolsas negras gde.vallefrut 2litrsfrutsi 250mlvallefrut 355mlluz papel de bao cotonelljugos del valle 200mlsabores coca cola 355mljugos del valle botellinbebere bevi 240te cristal 600mlchapur abonoluzjugos del valle 1ltrfrutsi 260mlvallefrut 3litrsvallefrut 600mlluz vallefrut 1.5ltrsgas 20kg L.P.cablemas queso alma estela daysisalchicha para asar campestre coca cola zero 235mlagua purificada coca cola zero 355mlcandy plop!pasta colgate luminous whiteAbono telceldawni libre enjuaguedetergente arcoirislapices princesapinolpolegiabevi 236mlcristal 1.5mlabono USATELECOM S DE RL DE CVmochila coca cola mini lata luz cereal hershey`s product. importadodetergente arielpansa respata cruda de resau mandarinaau naranja au toronjabut blanco 1.030 Kgchones versalleChorizo horneado 0.110 kg clubman220Danonino bebibledulces Nerds Wonkafritura jamon virginia fud 0.110 kg jugo Magijumex fresla lechera Nestlelapicera Lic. BikiniMarinada taquero Milanesa 1.030 KgMr. musculonestle bebpaleta payasopapas doritos flamepatitas troceadas pierna sin hueso poet bolsaqueso de bola El Gallo Azulsabritas sprite refrescosuaviteltrapeadorcrujitossabritashilo dental crestrefresco dr. Pepperrefrescocristalnec3sabores coca cola 500mlagua purificadaQueso manchego light k1kg Queso para nachos lakti- k 1kg salsa la Botaneragas 20kg Deltagas 20kg L.P.coca cola de 500MLaceite luceroaceite oleicocloralexcloro cloromax horchata de arroz c/horchata de arroz c/cocojugo tangjugo zukopapel aluminio alpapel higienico charminpapel higienico elitpapel higienico marca chedrahuirefresco con polvo zurepollococa cola oznas medianaLic. Bikini$10.004/4/15Suma de presio s 14.910101044.91212882020111155131313131616101055121288662020141499202013138818181919191916169928828822778379115724.3227.952.228829429414.9101014.949.817173.53.56699991985577777792313513527018185212699294294151528828839939924.3227.952.2255558845459030301014.91010104.9713201991993985595095063.4614.5463.4614.5415612.912.912.955.521047.434.94.99.929.747.4312.912.94.85201013255.5251.224.859.99.911.8351.2211.8313212.912.912.920838.19920.520.5766915.915.9949.82882885767716.9516.955.95.915156.64.48141481110.6152.3777275.74fritura $9.904/4/15fritura $9.904/4/15fritura $9.904/4/15clubman220$4.904/4/15nestle beb$4.854/4/15au naranja $12.904/4/15jumex fres$12.904/4/15au mandarina$12.904/4/15au toronja$12.904/4/15agua purificada$9.004/8/15Abono telcel$30.002/3/15pansa res$63.463/3/15pata cruda de res$14.543/3/15abono USATELECOM S DE RL DE CV$199.002/9/15BOLSA$14.9003/26/2015deterg fre $10.0003/26/2015deterg sua$10.0003/26/2015deterg bla $10.0003/26/2015gas 20kg L.P.$288.0011/24/14gas 20kg L.P.$288.004/14/15salchicha para asar campestre $27.9012/11/14queso alma estela daysi$24.3212/11/14luz$135.008/19/14luz $294.0010/17/14patitas troceadas $11.834/4/15pierna sin hueso $51.224/4/15luz $99.002/19/14cablemas $379.001/6/14cablemas $399.0012/6/14repollo$5.304/16/15aceite lucero$16.954/16/15refresco con polvo zu$3.304/16/15refresco con polvo zu$4.404/16/15refresco con polvo zu$3.304/16/15papel higienico elit$14.004/16/15papel aluminio al$8.004/16/15horchata de arroz c/$15.004/16/15cloro cloromax $5.904/16/15Luz $475.002/16/15candy plop!$45.001/30/15crujitossabritas$9.004/5/15refrescocristalnec3$20.504/5/15paquete de bolsas negras gde.$14.902/3/14deterg fre $10.002/3/14Queso manchego light k1kg $15.904/8/15jamon virginia fud 0.110 kg $47.434/4/15queso de bola El Gallo Azul$132.004/4/15but blanco 1.030 Kg$55.524/4/15lapicera $20.004/4/15chones versalle$10.004/4/15papas doritos flame$9.904/4/15dulces Nerds Wonka$9.904/4/15paleta payaso$9.904/4/15Danonino bebible$4.904/4/15la lechera Nestle$4.854/4/15sprite refresco$12.904/4/15sabritas $12.904/4/15suavitel$12.904/4/15jugo Magi$12.904/4/15salsa la Botanera$9.004/8/15dawni libre enjuague$30.002/3/15cereal hershey`s product. importado$63.463/3/15detergente ariel$14.543/3/15mochila $199.002/9/15lapices princesa$14.902/3/15pinol$10.002/3/15detergente arcoiris$10.002/3/15polegia$10.002/3/15gas 20kg Delta$288.001/2/14gas 20kg Delta$288.004/14/15salchicha fud$27.901/11/14queso manchego 200g$24.321/11/14chapur abono$135.008/19/14chapur abono$294.001/17/14poet bolsa$11.834/4/15Mr. musculo$51.224/4/15papel de bao cotonell$99.002/19/14telefono$379.001/6/14cablemas $399.001/6/14repollo$5.304/16/15aceite oleico$16.954/16/15jugo tang$3.304/16/15jugo zuko$4.404/16/15jugo tang$3.304/16/15papel higienico charmin$14.004/16/15papel higienico marca chedrahui$8.004/16/15horchata de arroz c/coco$15.004/16/15cloralex$5.904/16/15Luz $475.002/16/15pasta colgate luminous white$45.001/30/15hilo dental crest$9.004/5/15refresco dr. Pepper$20.504/5/15crema de ajo $14.902/3/14desodarante axe$10.002/3/14coca cola oznas mediana$7.004/20/15coca cola de 500ML$7.004/15/15coca cola mini lata $5.002/14/15coca cola light 355ml $8.001/13/14coca cola zero 355ml$8.001/14/15coca cola zero 235ml$5.001/2/15sabores coca cola 355ml$7.006/4/14sabores coca cola 500ml$7.004/5/15agua purificada $5.001/10/15jugos del valle 100ml$2.001/4/14jugos del valle 200ml$5.005/6/14jugos del valle botellin$7.006/5/14jugos del valle generoso$9.001/1/14jugos del valle 1ltr$18.008/24/14bebere $7.006/6/14frutsi 250ml$3.502/6/14frutsi 260ml$5.009/6/14vallefrut 355ml$6.002/12/14vallefrut 600ml$9.009/9/14vallefrut 1ltr$12.0012/10/214vallefrut 1.5ltrs$15.0011/13/14vallefrut 2litrs$17.002/5/14vallefrut 3litrs$21.009/6/14bevi 236ml$7.002/5/15bevi 240$7.006/6/14bevi 1ltr$19.002/6/11powerade 500ml$13.007/4/05powerade 600ml$16.007/8/13powerade 1lt$20.006/5/09te cristal 355ml lata $8.002/6/08te cristal 600ml$9.006/6/14te cristal 1lt$13.009/5/09fuze te 400ml$8.008/6/03fuze te 453ml$10.006/6/06fuze te 500ml$11.009/2/04fuze te 600ml$12.008/5/07fuze te 680ml$14.003/5/09fuze te 1lt$18.002/1/11crstal 600ml$8.005/6/10cristal 1.5ml$13.002/5/15burn 450ml$20.003/6/04ciel mini 300ml$5.006/6/05glaceu vitamin water 500ml$20.007/5/08mineral 400ml$6.005/5/08mineral 600mineral $9.005/2/09mineral 1tl$13.002/3/06mineral 1.5$16.005/5/06mineral 2lt$19.002/5/11coca cola zero mini lata 235ml $5.002/5/07

grafico danamico 1fechas (Todas)Etiquetas de filaSuma de presio s Abono telcel30abono USATELECOM S DE RL DE CV199aceite lucero16.95aceite oleico16.95agua purificada9agua purificada 5au mandarina12.9au naranja 12.9au toronja12.9bebere 7bevi 1ltr19bevi 236ml7bevi 2407BOLSA14.9burn 450ml20but blanco 1.030 Kg55.52cablemas 1177candy plop!45cereal hershey`s product. importado63.46chapur abono429chones versalle10Chorizo horneado 0.110 kg 47.43ciel mini 300ml5cloralex5.9cloro cloromax 5.9clubman2204.9coca cola de 500ML7coca cola light 355ml 8coca cola mini lata 5coca cola oznas mediana7coca cola zero 235ml5coca cola zero 355ml8coca cola zero mini lata 235ml 5crema de ajo 14.9cristal 1.5ml13crstal 600ml8crujitossabritas9Danonino bebible4.9dawni libre enjuague30desodarante axe10deterg bla 10deterg fre 20deterg sua10detergente arcoiris10detergente ariel14.54dulces Nerds Wonka9.9fritura 29.7frutsi 250ml3.5frutsi 260ml5fuze te 1lt18fuze te 400ml8fuze te 453ml10fuze te 500ml11fuze te 600ml12fuze te 680ml14gas 20kg Delta288gas 20kg Delta288gas 20kg L.P.576glaceu vitamin water 500ml20hilo dental crest9horchata de arroz c/15horchata de arroz c/coco15jamon virginia fud 0.110 kg 47.43jugo Magi12.9jugo tang6.6jugo zuko4.4jugos del valle 100ml2jugos del valle 1ltr18jugos del valle 200ml5jugos del valle botellin7jugos del valle generoso9jumex fres12.9la lechera Nestle4.85lapicera 20lapices princesa14.9Lic. Bikini10luz135luz 1343Marinada taquero 132Milanesa 1.030 Kg55.52mineral 1tl13mineral 1.516mineral 2lt19mineral 400ml6mineral 600mineral 9mochila 199Mr. musculo51.22nestle beb4.85paleta payaso9.9pansa res63.46papas doritos flame9.9papel de bao cotonell99papel aluminio al8papel higienico charmin14papel higienico elit14papel higienico marca chedrahui8paquete de bolsas negras gde.14.9pasta colgate luminous white45pata cruda de res14.54patitas troceadas 11.83pierna sin hueso 51.22pinol10poet bolsa11.83polegia10powerade 1lt20powerade 500ml13powerade 600ml16queso alma estela daysi24.32queso de bola El Gallo Azul132queso manchego 200g24.32Queso manchego light k1kg 15.9Queso para nachos lakti- k 1kg 15.9refresco dr. Pepper20.5refresco con polvo zu11refrescocristalnec320.5repollo10.6sabores coca cola 355ml7sabores coca cola 500ml7sabritas 12.9salchicha fud27.9salchicha para asar campestre 27.9salsa la Botanera9sprite refresco12.9suavitel12.9te cristal 1lt13te cristal 355ml lata 8te cristal 600ml9telefono379trapeador20vallefrut 1.5ltrs15vallefrut 1ltr12vallefrut 2litrs17vallefrut 355ml6vallefrut 3litrs21vallefrut 600ml9Total general7275.74

grafico dinamico 2Etiquetas de filaSuma de presio s Abono telcel30abono USATELECOM S DE RL DE CV199aceite lucero16.95aceite oleico16.95agua purificada9agua purificada 5au mandarina12.9au naranja 12.9au toronja12.9bebere 7bevi 1ltr19bevi 236ml7bevi 2407BOLSA14.9burn 450ml20but blanco 1.030 Kg55.52cablemas 1177candy plop!45cereal hershey`s product. importado63.46chapur abono429chones versalle10Chorizo horneado 0.110 kg 47.43ciel mini 300ml5cloralex5.9cloro cloromax 5.9clubman2204.9coca cola de 500ML7coca cola light 355ml 8coca cola mini lata 5coca cola oznas mediana7coca cola zero 235ml5coca cola zero 355ml8coca cola zero mini lata 235ml 5crema de ajo 14.9cristal 1.5ml13crstal 600ml8crujitossabritas9Danonino bebible4.9dawni libre enjuague30desodarante axe10deterg bla 10deterg fre 20deterg sua10detergente arcoiris10detergente ariel14.54dulces Nerds Wonka9.9fritura 29.7frutsi 250ml3.5frutsi 260ml5fuze te 1lt18fuze te 400ml8fuze te 453ml10fuze te 500ml11fuze te 600ml12fuze te 680ml14gas 20kg Delta288gas 20kg Delta288gas 20kg L.P.576glaceu vitamin water 500ml20hilo dental crest9horchata de arroz c/15horchata de arroz c/coco15jamon virginia fud 0.110 kg 47.43jugo Magi12.9jugo tang6.6jugo zuko4.4jugos del valle 100ml2jugos del valle 1ltr18jugos del valle 200ml5jugos del valle botellin7jugos del valle generoso9jumex fres12.9la lechera Nestle4.85lapicera 20lapices princesa14.9Lic. Bikini10luz135luz 1343Marinada taquero 132Milanesa 1.030 Kg55.52mineral 1tl13mineral 1.516mineral 2lt19mineral 400ml6mineral 600mineral 9mochila 199Mr. musculo51.22nestle beb4.85paleta payaso9.9pansa res63.46papas doritos flame9.9papel de bao cotonell99papel aluminio al8papel higienico charmin14papel higienico elit14papel higienico marca chedrahui8paquete de bolsas negras gde.14.9pasta colgate luminous white45pata cruda de res14.54patitas troceadas 11.83pierna sin hueso 51.22pinol10poet bolsa11.83polegia10powerade 1lt20powerade 500ml13powerade 600ml16queso alma estela daysi24.32queso de bola El Gallo Azul132queso manchego 200g24.32Queso manchego light k1kg 15.9Queso para nachos lakti- k 1kg 15.9refresco dr. Pepper20.5refresco con polvo zu11refrescocristalnec320.5repollo10.6sabores coca cola 355ml7sabores coca cola 500ml7sabritas 12.9salchicha fud27.9salchicha para asar campestre 27.9salsa la Botanera9sprite refresco12.9suavitel12.9te cristal 1lt13te cristal 355ml lata 8te cristal 600ml9telefono379trapeador20vallefrut 1.5ltrs15vallefrut 1ltr12vallefrut 2litrs17vallefrut 355ml6vallefrut 3litrs21vallefrut 600ml9Total general7275.74

nota

Nota:

Maestra el trabajo se lo estoy entregando hoy porque los tickes me faltaba asi que hoy consegui los tickes .