semana 2

34
 CONTROL DE SUELDOS DE EMPLEADOS CODIGO APELLIDOS NOMBRES NOMBRE CO FECHA DE IN SUELDO 1 Morales Medina José Manel !"1#$ 1%$$ & 'a(ala San)os Ner* An)onio !!+$$ &%$$ ! ,l(aro Orellana Es(in Os(aldo !%-#& &!$$ - Bran Ra./re0 Mirna er2ni3a !%+#! &&%$ % ,l(are0 Cr0 T4el.a Jane)) !%$!% &$$$ " Or)e5a Gerra Moni3a !!!1- !$$$ 6 Godo* Mar)/ne0 Jan Manel !%-+- &!$$ # Morales Mendo0a Allan José !-#6- &$$$ + Ar.as Me7/a 8illia. Adol9o !!1"# !%$$ 1$ T oledo 'a.ora Ir0: Rena)a !%+#1 &$$$

Upload: styvflores

Post on 04-Nov-2015

214 views

Category:

Documents


0 download

DESCRIPTION

ps3

TRANSCRIPT

Hoja1CONTROL DE SUELDOS DE EMPLEADOSCODIGOAPELLIDOSNOMBRESNOMBRE COMPLETOFECHA DE INGRESOSUELDOENEROFEBREROMARZOABRILMAYOJUNIOTOTAL SEMESTREPROMEDIO SEMESTRECOMISIONESBONIFICACIONSUELDO GENERALIGSSISRSUELDO - DESCUENTOS1Morales MedinaJos Manuel361801500670069007500870076008300212.52Zavala SantosNery Antonio339002500600070004500830080005200212.53lvaro OrellanaEsvin Osvaldo354822300680080006000990078008000212.54Bran RamrezMirna Vernica359832250740075007000880047408600212.55lvarez CruzThelma Janett350352000930099008000950097009200212.56Ortega GuerraMonica 333143000550040006500820039007000212.57Godoy MartnezJuan Manuel354942300550060008000590058009000212.58Morales MendozaAllan Josu348742000820054007000860063008900212.59Armas MejaWilliam Adolfo331683500710091009000660059007000212.510Toledo ZamoraIrz Renata359812000550045008000590058005500212.5

Hoja2EncabezadoSecuenciaProveedorTipoNodocFechaMontoGasto76492549438401470977/2/02400.003876502549438401641658/1/02400.003876512549438401703669/2/02400.0038765225494384017619810/2/02400.0038765325494384018730411/6/02400.0038765425494384119680512/3/02400.003876552549438400832612/3/02400.003876562549438402184002/6/03400.003876572549438402242553/5/03400.00387658254943840115844/11/03400.00387659254943840123845/19/03400.003876602549438402553066/6/03400.00386109126532476010376311/16/0329.7516109226532476019287611/3/0313.5016109326532476014784811/21/038.051610942653247601375697/5/0339.351610952653247608065510/6/0317.5516109626532476020787011/4/038.9516109726532476018538110/9/0311.60161098904945010307912/12/0363.003610999049450842467/29/0325.00361100265324760892207/26/0323.6016110173781060513227/13/0316.66161102265324760899107/31/0323.5516110373781060481097/6/0330.1416110473781060310977/17/034.7516110553547650155868/1/034.653161106265324760901878/1/038.401611072653247601810448/2/0331.30161108452158702176098/29/0317.003611092653247601727558/18/0322.501611107378106070428/18/034.7516111173781140709637/23/03103.4216111226532476021265511/22/0317.201611136683890860307/4/0320.953161114904945012893712/19/0311.7536111526532476115085712/4/039.95161116904945012712912/17/0375.2536111773781060564462/12/0432.901611182653247601670907/6/0395.501611192653247601718743/7/0435.5516112073781060797765/23/0456.7116112190494504594529/9/036.403611221277434006892110/10/0334.68176112390494501393851/5/0454.75361124904945013642212/30/031.50361125904945013642012/30/0367.75361126904945013214212/20/0362.5036112726532476019676712/27/039.10161128904945010630211/19/0311.25361129747058401354012/2/038.2534611302653247602675835/22/044.101611311277434005262411/3/043.851761132737810601430112/28/035.35161133737810601931312/28/0330.52161134452158707667710/16/039.0036113590494504568199/5/0310.8036113645215870440888/5/0311.5036113773781060128419/16/034.751611382653247601517447/3/0321.2016113973781140748847/2/0350.65161140904945010425611/17/0340.503611412653247601712689/19/0315.30161142452158702934812/10/0410.50361143452158702934822/10/0410.5036114490494501634412/9/0414.0036114590494501441281/12/0459.253611462653247612148391/3/047.501611472653247602500994/30/045.751611482653247602162331/18/0475.2016114990494501686242/16/0462.7536115045215870148601/4/0445.2536115126532476014623911/15/0351.15161152904945010198611/13/0311.25361153452158702176088/29/0317.00361154452158708566711/4/039.0036115590494501657242/12/0416.00361156904945013211112/23/0311.7536115726532476022158112/20/0322.40161158502212605748712/20/0322.48361159737810603352611/16/0323.14161160738362201070710/30/0365.004261161452158708791011/10/0323.25361162904945010193511/13/0314.50361163452158708791811/10/0310.0036116426532476010919112/21/0322.80161165737810604364112/21/0316.461611664521587010140312/10/0318.00361167604941010284312/2/03209.00361168904945010228411/14/0319.00361169904945010269611/14/0311.2536117073781060113329/15/0344.111611717291108012113311/12/03373.00361172737810603041610/26/0359.05161173737810603042010/26/036.251611742653247601895828/31/0391.7016117514940450034053610/20/03610.19161176737810604223510/20/0397.40161177737810611499010/13/03104.051611783209430578966/11/042,396.8116611793209430578976/11/041,533.56166118054640640294737/5/0319.90361181546406401388433/6/0439.2036118216898206063537/17/0315.003611834119118010218/9/031.4024611844119118022411/19/041.602461185411911801089477/19/035.152461186411911801204069/6/030.70246118775254430117747/5/0315.00361188302910028477/9/034.8517611893029100168839/27/033.7017611905464064010785910/12/0317.2036119130291002184510/27/034.00176119241191180425611/7/030.7024611934119118014637112/28/031.9524611944119118014637012/28/032.002461195411911801124418/2/034.902461196411911801188458/30/034.902461197411911801141648/10/032.10246119830291002415111/10/03116.7017611994119118063017/28/031.0024612004119118054932/15/041.602461201411911801108657/27/032.102461202411911801204639/6/031.7524612034119118072478/1/030.7024612044119118073838/7/030.702461205302910073128/2/035.9017612064119118055027/16/030.7024612071207229041499/13/0321.50461208411911801533031/25/042.0024612091198452K1707927/23/0315.003461210411911801107197/26/031.052461211411911801107187/26/031.052461212411911801107207/26/031.05246121330291001883810/8/034.701761214302910059427/26/037.601761215411911801153428/15/035.6024612164119118013833411/23/033.0524612171191661302746258/31/0318.7596121890494503261652/22/0436.2536121925898825032967/21/03160.00156122073781140938819/28/035.75161221736449049138012/2/0314.2066122233062160253286710/22/0312.001612234190378022569/2/037.50316122445425702315077/5/0362.35116122544361102657012/1/0324.253161226487302502031023/26/04100.00366122778569700529/19/0325.00361228244472003302313/5/04140.0036122953016290139787/19/0325.31436123055670680469539/27/0346.002461231149394520213767/5/03325.001461232736449049093311/29/037.0566123327034712068148/10/03243.00361234979767044431/4/045,898.004612351599703003354/23/0411,000.00186123653656510442512/28/0492.00361237411911801153438/15/032.102461238531427501119438/17/035.259612397269455023723010/11/0316.0017612407269455126110012/21/0313.25176124130291002320711/5/034.0017612421198452K0704457/22/0318.00346124345215870440808/5/0315.50361244737811401313647/13/0344.10161245737810603850511/23/0319.06161246265324760916768/8/0311.60161247238277690551422/27/0450.00961248274077050328812/20/04299.004161249238277690553843/1/04100.00961250799636504315204/5/0489.00361251799636504164212/21/0435.00361252108899805148512/12/0336.5036125337180690640851/3/04117.0036125490494501723329/13/0355.00361255448265401359412/1/03165.0066125633062160233893110/29/0312.001612572698670103527/8/0321.5017612583209430439338/8/032,698.9816612594119118018541/15/040.8024612604119118082823/10/040.8024612615464064011284210/26/0312.702461262546406401398404/8/0418.702461263411911801728274/25/041.602461264411911801209289/8/033.502461265222706120357011/30/0415.0034612664119118014636912/28/033.302461267411911801515981/18/040.8024612684119118013215110/26/030.702461269411911801550192/1/041.7024612704119118060862/19/041.2024612714119118113996311/30/034.00246127230291002677911/25/033.7017612734119118013552511/9/031.75246127451308910289311/26/0343.2536127530291002677711/25/0338.85176127630291002677811/25/033.70176127730291001933810/11/034.00176127830291001823310/4/034.001761279411911801221219/13/032.452461280411911801221209/13/031.752461281529631501171647/5/0317.50161282411911801172148/23/034.2024612834119118067612/25/040.8024612844119118075103/23/040.80246128530291002259110/31/033.6017612863029100734941/24/0419.5017612874119118018139/18/031.4024612884119118012829/10/031.402461289411911806609/4/031.4024612904119118056572/16/040.6024612914119118033771/28/041.20246129241191180489111/13/030.7024612935464064010763710/11/036.95246129453142750128247/4/033.259612954119118013035110/18/031.5024612964119118012713810/4/031.5024612974119118012713910/4/031.502461298411911801256419/28/030.7024612993797112074819/27/039.9536130030291001860710/7/036.601761301411911801478071/4/044.002461302411911811053507/5/034.50246130330291002455011/12/033.5017613044119118016661633/21/042.00246130581859720508683/7/0465.5036130672890490491054/6/044.003461307411911801580682/14/042.0024613084119118044603/6/041.2024613094119118064492/23/040.8024613104119118013035010/18/034.5024613114119118096628/27/030.7024613124119118011619/9/030.70246131354640640982768/3/036.952461314708779904139612/29/0313.996613155464064012023112/3/0318.602461316281551060177948/26/0370.00246131730291002107310/22/034.0017613183029100712351/10/044.00176131926532476021765812/7/039.40161320487302501997542/16/04100.003661321726945501296619/7/037.3817613228033590187147/5/0346.004461323181790601191007/22/037.003461324411911801171698/23/031.402461325487302501955291/12/04100.00366132619101830320889/20/03169.0046132727017982092734/5/0440.0040613281277434004553307/8/0364.35176132972694550479937/20/036.27176133072694550479967/20/0312.33176169673011405858752/1/04522.20476169773011405858763/1/04289.82476169873011415858774/1/04289.82476169973011405858785/1/04289.8247713319049450666816/14/0470.7537133273781060927726/20/0428.7917133373781060935496/20/049.00171334195559620688764/19/0441.0031713351912747018209212/3/03112.0016713361490877802611312/3/0312.001671337617970302230512/3/0340.00167133861797030203107/30/031,055.001671339507214K01246812/18/0350.003371340507214K01399711/20/03100.0033713411277190202656694/17/04100.0097134299259290886605/21/0492.00371343808349502506667/26/0350.009713448083495030821511/18/0350.009713451692245K025011610/22/03100.009713461692245K03318054/29/04100.009713471692245K03344275/5/0450.009713481692245K02164078/11/03100.00971349930687016436512/16/0350.009713501692245K03377005/12/0450.0097135161797030251322/17/04242.001671352904945013499510/19/0397.40371353904945089223/19/0489.003713545130891043244/26/0429.403713555130891032214/19/0456.903713569049450494405/19/0465.00371357513089107186/9/0417.953713585130891047636/9/0410.003713597383967040248/8/03108.90371360904945131116512/21/03170.003713619049450200944/15/04100.00371362904945054400811/30/03129.003713632808959602059911/30/03139.981471364904945056548611/23/0399.0037136590494504178/30/03139.9037136651308910899411/30/0323.4537136790494503013248/15/03111.303713684808894021583/6/04185.001471369336336140363810/9/0350.003371370336336140434110/23/0350.00337137190494504735457/25/03100.6037137290494506034461/13/04123.253713735314275028093711/7/0350.00971374137952609364511/9/03100.0037137573781060240982/15/04103.20171376737810607387/23/0326.3717137773781060736715/3/04172.6717137873781060653755/5/04135.6617137973781060803745/10/0424.7017138073781060771415/16/04375.7017138173781060571692/1/04118.54171382737810604329912/19/03478.91171383737810603436211/7/0316.63171384737810603507611/10/0388.5317138573781060779364/30/0448.00171386258988250605912/24/03120.00157138773781060661193/27/0439.5617138873781060510971/16/043.20171389737810604860712/29/03173.8217139073781060803435/1/0427.12171391737810612685510/8/0374.32171392737810601234417/8/0362.0317139373781060192089/7/0372.18171394737810603663811/15/0342.47171395737810602951310/20/03323.91171396737810603663911/15/0320.3017139773781060544571/21/0417.97171398737810602599910/5/0314.7117139973781060795434/28/0436.7617140073781060703254/14/0435.9517140173781060116327/26/0324.9517140273781060794955/6/0434.4817140373781060540605/9/04492.3317140473781060727134/29/0478.4717140573781060717733/28/04180.3217140673781060484312/17/04128.7217140773781060684323/14/04205.3817140873781060821185/8/0439.271714097378106034312/10/0350.0017141073781060791155/5/0481.72171411737810604527412/16/0325.5017141273781060624322/20/0493.4617141373781060656893/25/0439.5617141473781060174199/1/03476.5817141573781060653493/6/04311.4217141673781060224659/21/0328.5717141773781060124498/10/0314.6617141873781060734816/14/04519.7817141973781060779694/30/0425.801714207378106023677/6/03531.611714217378106097688/30/03101.9017142273781061730674/2/0411.901714237378106050349/13/03107.1017142473781060718884/2/04413.101714257378106080857/23/0315.8017142673781060293912/2/03153.1017142773781060108938/4/0358.4917142873781060109228/22/03650.0017142973781060424083/6/0438.9517143073781060717004/24/04186.401714311494609203344647/6/036.00971432737810604085412/1/0347.3217143373781060621962/23/04106.471714347378106091937/19/0333.20171435737810603954312/7/0383.101714367378106038897/9/0332.55171437737810604611012/20/03105.6517143873781060884216/10/0428.5717143973781060887586/12/0453.7817144073781060905736/12/0482.32171441737810603279511/1/0348.4917144273781060870146/5/0490.7117144373781060549781/23/0433.4517144473781060153318/23/03117.1417144573781060513151/21/0498.7417144673781060532091/16/04304.96171447737810604557512/27/0389.5317144873781060646283/20/0414.5917144973781140807778/29/0344.2017145073781060157539/27/03596.5817145173781060482081/8/0433.62171452737810603055710/24/03140.5817145373781061619912/18/0442.151714547378106075807/21/03217.88171455737810604733911/3/0323.8017145673781060747195/7/04206.521714571494609204892012/6/04100.009714587378106025148/1/03592.1517145973781060545042/4/0413.7217146073781060752264/18/04112.73171461737810604777512/24/03221.4517146273781060720914/27/0432.4917146373781060658953/26/0418.2017146473781060728684/27/0424.2517146573781060216059/26/03305.6017146673781060174399/1/0318.40171467737810602940810/19/0390.1517146873781060711883/31/0444.21171469737810602532110/2/0322.97171470737810604951312/31/03137.6517147173781060625504/15/0461.77171472737810601287412/7/0360.6517147373781060105478/23/034.751714741494609204069378/27/03100.0097147573781060651055/4/0488.1717147673781060206339/14/03537.71171477737810604798/16/03459.8817147873781060767584/25/04135.14171479737810604932012/31/0390.73171480737810603486911/3/03259.92171481737810604442512/22/03259.9817148273781060884206/10/047.90171483737810602848210/15/03109.9617148473781061527971/15/0441.5217148573781060472351/4/04150.7217148673781060452323/14/04323.811714877378106079008/25/0335.05171488737810604305012/23/0333.43171489737810603564111/12/034.08171490737810603512011/10/0320.02171491737810604055212/1/03169.5317149273781060573982/16/0457.7617149373781060105028/23/0347.9017149473781060757234/13/0419.3717149573781060633542/24/04115.95171496737810603097510/26/0323.86171497737810603253711/2/0355.09171498737810602599810/5/03332.0917149973781060447064/24/04503.37171500737810604764112/24/03165.26171501737810604303012/8/0365.0517150273781060758774/21/04123.161715037378106050017/14/03335.17171504737810603224110/30/0328.4117150573781060328066/9/047.06171506737810603688311/16/03458.48171507538207606493110/16/0327.7241715085699908010316910/26/0394.002471509536565103216621/10/04102.00371510737249301670259/14/03119.97117151190494501592472/22/0459.003715125699908016782911/8/0379.00247151390494502186898/3/031.503715149049450442705/11/0465.0037151554640641271188/7/0362.00247151666727702504018/29/0375.051671517904945058038112/13/03104.00371518904945025974711/23/0328.00371519904945025974811/23/0320.003715204146972017380110/15/0311.5017152190494502235008/16/03107.4037152290494501757815/29/0470.753715235130891087481/8/0423.9537152490494504567373/16/0418.00371525104729901025323/7/0437.80371526526585106025212/19/0358.75371527904945024411311/4/03106.603715285747400108909/7/0394.951571529532615K013035512/19/0319.90371530800215001838668/16/0329.7037153140266400709082/4/047.0037153211626910125692710/19/0391.002471533538207606425210/7/0323.7041715344822706010395111/29/0325.05177153513795260835849/7/03100.003715367378106020267/1/03189.05171537733574106547411/26/03227.8037153873781060518251/11/04170.30171539737810602819210/15/0318.1517154073781060755814/20/0485.2417154173781060108489/9/0335.11171542737810604899412/30/0379.8117154373781060224649/21/038.02171544737810603560011/5/0335.9017154573781060665743/28/045.76171546737810611290812/13/0397.15171547737810603508911/10/0367.8217154873781060748444/8/04152.71171549737810602426610/6/0310.84171550569990801347563/2/0485.002471551737810603564211/12/0312.2017155273781060687933/21/04178.66171553737810604614812/19/034.67171554737810603555010/10/03115.8517155573781060202349/20/0379.1917155638817920762478/23/0332.083171557737810604787212/24/0360.67171558737810603643511/8/03163.62171559737810602847311/28/0335.15171560737810602699311/19/0353.04171561737810602832510/17/036.85171562104729906845812/10/0319.9037156373781060174078/31/0342.381715645130891012125/4/0415.753715659049450295657/6/03136.30371566389007401325317/10/03126.003715679049450560403/16/0489.00371568737810603953912/7/03175.3937156973781060777734/21/0438.8417157090494504688617/19/03104.0037157190494506325042/25/04118.0037157290494501832799/19/0378.7037157390494505994991/7/04183.00371574904945055136911/4/0384.00371575904945061353/13/04100.003715769049450363594/28/04100.003715779049451140493/30/04100.003715789049450187434/11/04127.00371579904945018060511/10/0399.3037158090494504933448/28/0369.0037158190494504489481/24/04112.003715825130891092933/12/0415.95371583531427503328932/15/0450.0097158473781060920096/26/0430.371715851692245K03397575/17/04100.009715861692245K02364939/23/0350.009715871692245K03018302/19/0450.009715886882544026503510/18/03100.0097158934093330969299/29/0330.009715901692245K03031262/23/04100.009715911692245K03528776/15/04100.0097159234093330855008/19/03100.00971593808349502912010/25/0350.00971594571802301912461/15/04100.009715951692245K03350235/6/04100.0097159666727702926892/19/0419.241671597507214K0130001/2/0450.003371598507214K01080111/6/0350.0033715991955569505932012/29/03129.0015716003363361401028/1/0350.00337160182199900231213/17/0425.00457160282199900365917/25/0320.00457160333633614014478/28/0350.00337160433633614069422/27/0450.0033716053363361407918/14/0350.00337160633633614022339/11/0350.003371607507214K0124917/18/0350.00337160860801111325057/7/03169.991571609904945074223/4/04149.003716109049450447278/22/0347.503716111692245K03170193/25/04100.009716121692245K03228334/6/04100.009716131725868501110077/17/03100.009716141692245K03445835/27/0460.009716151692245K026282611/20/03100.009716161692245K01983427/2/03100.009716171692245K03105223/10/04100.009716181692245K02277409/4/0350.009716191692245K025287610/28/03100.009716201692245K026659311/28/03100.009716211692245K02023867/11/03100.009716221692245K02073347/22/03100.009716231692245K03120463/14/04100.0097162417258685015458812/21/0350.009716251692245K03417365/21/04100.009716261328132106716511/10/0382.009716271692245K03511796/10/0450.00971628851933103257582/16/04100.00971629571802301994332/2/04100.009716301692245K02147638/7/03100.009716311692245K03089763/6/04100.0097163234093330937389/19/03100.0097163334093330801677/29/03100.009716341692245K025527211/3/0350.00971635808349502326810/11/0350.009716365624975063455/18/04350.0030716375718023016448911/25/03100.009716389049450458569/5/0355.803716391692245K13141103/18/04100.009716401692245K027441412/16/03100.009716411692245K024391910/8/03100.009716421692245K02250328/29/03100.009716431692245K02008337/8/03100.0097164434093330896359/2/0365.009716451692245K024118610/2/03100.009716461692245K027141412/9/03100.009716471692245K02889441/23/04100.00971648808349502446110/14/03100.009716491692245K026976012/5/03100.0097165034093330956079/25/0335.009716515718023015307810/31/0350.009716523409333011653412/2/0350.00971653340933309930310/6/0350.009716541692245K02825611/8/04100.009716551692245K03281774/21/04100.0097165634093330913699/9/03100.009716571692245K02290509/6/03100.009716581692245K03198353/31/04100.00971659571802302049522/13/0450.009716601725868501191138/16/0365.0097166190494507215576/18/0486.0037166290494501802026/25/0470.753716631692245K03546166/18/0450.009716641692245K03593676/28/0450.009716651692245K03571346/23/04100.009716663264450428424/29/04112.745716673264450253382/27/04122.175716683264450190862/4/04122.1657166932644502022110/3/03134.0457167032644512851311/7/03145.855716713264450221912/2/03132.39571672326445013147/8/03126.17571673326445065248/1/03138.46571674326445095351/2/04139.445716753264450541246/4/04195.8457167699292900387454/15/0498.00327167799292900296933/12/0450.00327167899292900270938312/16/0453.86327167999292900510912/12/0348.003271680992929002283310/15/0346.0032716819929290013167/8/0329.0032716829929290065258/1/0320.00327168399292900158249/16/0341.0032716849929290095372/1/0429.00327168599292900566766/14/0473.00327168633065180387484/15/0444.53467168733065180296843/12/0438.62467168833065180510712/12/0327.2046716893306518030157/17/0360.514671690330651803144911/19/0372.7346716912549438403498394/30/04407.0038716922549438403578726/16/04407.003871693254943840177153/30/04426.00387169433633614074653/12/0450.0033716951692245K03245424/13/04100.0097170073781060550192/6/041.7017170173781060550202/6/0422.0117170273781060588562/7/0468.47171703737810604451812/23/0341.1317170473781060280022/29/0478.401717057378106153296/8/048.4017170673781060634882/28/04448.22171707125125080237212/9/03134.00171708737810604186912/20/0339.4517170973781060588572/7/04388.8517171073781060579982/6/0433.5317171173781060283781/3/04113.9417171273781060223565/15/04355.001717139049450162676/30/04146.0037171490494506208642/7/0495.2537171590494502732083/10/0499.503717161692245K01350162/14/04140.009717171251599K02349791/31/0450.00971718569990802015392/29/0415.002471719507214K0107046/6/0450.0033717202646551506671/12/04375.0025717212646551506501/11/04625.002571722330651805143569/19/0393.36467172341582880119594/19/04200.00107172441582880121776/25/04450.00107172541582880120785/28/04200.0010717264081765046554/14/0452.00107172744247940475012/29/03135.001071728337854027284/22/041,424.361071729195559620344531/10/042,450.25317173090494501748135/22/0470.75371731452158702166985/29/0441.503

** con la formula countif o contarsi indiqueme cuantas facturas hay que sean tipo 1** con la formula sumaif o sumasi indiqueme cuanto suman las facturas cuyo tipo sea 1** con la formula sumaif o sumasi indiqueme cuanto suman las facturas cuyo tipo de gasto sea 1** calcule subtotales ** con los subtotales calculados realice una grafica de barras ** ejecute un macro en el cual se realice un filtro avanzado y asigneloa un boton

Hoja3