Datos

NCLINICAPATERNOMATERNONOMBRENOMBRE COMPLETO
mjbe: mjbe:=CONCATENAR(C3," ",D3," ",E3)MAYUSCULA
mjbe: mjbe:=MAYUSC(F3)MINUSCULA
mjbe: mjbe:=MINUSC(G3)NOMBRE PROPIO
mjbe: mjbe:=NOMPROPIO(G3)IZQUIERDA
mjbe: mjbe:=IZQUIERDA(I3,7)DERECHA
mjbe: mjbe:=DERECHA(I3,5)EXTRAE
mjbe: mjbe:=EXTRAE(G3,2,9)LONGITUD
mjbe: mjbe:=LARGO(I3)ES TEXTO
mjbe: mjbe:=ESTEXTO(Q3)ES NUMERO
mjbe: mjbe:=ESNUMERO(Q3)SEXOEST.CIVILN DEHIJOSFECHA DEINGRESOFECHADE SALIDADIAS ENHOSPITAL
mjbe: mjbe:=S3-R3COSTOPOR DIADIAGNOSTICOTIPO DESANGREPABELLONSALACAMACODIGOMEDICOOTROS GASTOSIMPUESTOGASTOS ADMINISTRATIVOSMORASDSCTOSUBTOTAL
mjbe: mjbe:=V3*U3NETO APAGAR
mjbe: mjbe:=AC3+AD3+AE3+AF3-AG3+AH31HC10antoinosihuinchadalmaantoino sihuincha dalmaANTOINO SIHUINCHA DALMAantoino sihuincha dalmaAntoino Sihuincha DalmaAntoinoDalmaAnt23TRUEFV13/11/103/18/10740PARTORH-EE253724060100102102HC20acuapinedomarianaacua pinedo marianaACUA PINEDO MARIANAacua pinedo marianaAcua Pinedo MarianaAcua PrianaAcuFS34/11/094/24/091340ANEMIAA DD12893405012040503HC30aguileramendozajoelaguilera mendoza joelAGUILERA MENDOZA JOELaguilera mendoza joelAguilera Mendoza JoelAguiler JoelAguMV35/6/105/7/10140COLICOSBGG165135504HC40aguileramanayrosioaguilera manay rosioAGUILERA MANAY ROSIOaguilera manay rosioAguilera Manay RosioAguilerRosioAguFC49/27/0711/4/073840INFECCION ESTOMACALRH-DD374740409040505HC50aguileracruiseyesseniaaguilera cruise yesseniaAGUILERA CRUISE YESSENIAaguilera cruise yesseniaAguilera Cruise YesseniaAguilerseniaAguFC35/6/075/18/071240INFECCION ESTOMACALABCC17654040900506HC60allerrojasmerlyaller rojas merlyALLER ROJAS MERLYaller rojas merlyAller Rojas MerlyAller RMerlyAllFC110/17/0711/26/074040TUBERCULOSISA CG164940401600507HC70apasaunocccarmelinaapasa unocc carmelinaAPASA UNOCC CARMELINAapasa unocc carmelinaApasa Unocc CarmelinaApasa UelinaApaFC31/6/101/11/10540PARTORH+DD137127404010040508HC80ataullucosalazarkattyataulluco salazar kattyATAULLUCO SALAZAR KATTYataulluco salazar kattyAtaulluco Salazar KattyAtaulluKattyAtaFV26/9/076/19/0740INFECCION ESTOMACALRH+DD234240609040509HC90ataullucocabanaceciliaataulluco cabana ceciliaATAULLUCO CABANA CECILIAataulluco cabana ceciliaAtaulluco Cabana CeciliaAtaulluciliaAtaFC34/10/074/20/0740TUBERCOLOSISBBB11634040201005010HC100barridovillaFuertececiliabarrido villaFuerte ceciliaBARRIDO VILLAFUERTE CECILIAbarrido villafuerte ceciliaBarrido Villafuerte CeciliaBarridociliaBarFS112/6/0812/21/0840INTOXICACIONA DD9855405020405011HC110barridolunajulianabarrido luna julianaBARRIDO LUNA JULIANAbarrido luna julianaBarrido Luna JulianaBarridolianaBarFC57/26/087/29/0840QUEMADURASRH+DD71125404020405012HC120barriosrojascarlosbarrios rojas carlosBARRIOS ROJAS CARLOSbarrios rojas carlosBarrios Rojas CarlosBarriosarlosBarMD64/2/074/16/0740COLICOSRH+BB65220701401005013HC130belloquispedanielabello quispe danielaBELLO QUISPE DANIELAbello quispe danielaBello Quispe DanielaBello QnielaBelFS41/9/091/24/0940CANCER AL PULMONRH+DD1071429405020405014HC140cabanaquispececiliacabana quispe ceciliaCABANA QUISPE CECILIAcabana quispe ceciliaCabana Quispe CeciliaCabana ciliaCabFC212/28/081/16/0940AMPUTACION DE MIEMBRO SUPERIORRH-DD10382404020405015HC150cabanasotelooscarcabana sotelo oscarCABANA SOTELO OSCARcabana sotelo oscarCabana Sotelo OscarCabana OscarCabMD28/21/088/27/0840PULMONIAABDD76935207020405016HC160cabanabarridoraquelcabana barrido raquelCABANA BARRIDO RAQUELcabana barrido raquelCabana Barrido RaquelCabana aquelCabFC24/12/075/1/0740INFECCION ESTOMACALABBB6214040901005017HC170cabrerayoveracynthiacabrera yovera cynthiaCABRERA YOVERA CYNTHIAcabrera yovera cynthiaCabrera Yovera CynthiaCabreranthiaCabFV510/7/0711/15/0740ANEMIARH-CG1553406012005018HC180camaclimacheFannycamac limache FannyCAMAC LIMACHE FANNYFC310/22/0810/28/0840DERRAME CEREBRALRH+DD8947404080405019HC190camacaguilerajoelcamac aguilera joelCAMAC AGUILERA JOELMC55/21/085/24/0840TUBERCOLOSISRH+DD5942204020405020HC200camacespejomayracamac espejo mayraCAMAC ESPEJO MAYRAFC52/13/072/16/0740INFECCION ESTOMACALOAA5254040901105021HC210cardenasmugaroxanacardenas muga roxanaCARDENAS MUGA ROXANAFC18/31/089/8/0840QUEMADURASODD78639404020405022HC220carrerosilvafatimacarrero silva fatimaCARRERO SILVA FATIMAFD19/27/0711/4/0740QUEMADURASOAG14224070201105023HC230carrioncabanamanuelcarrion cabana manuelCARRION CABANA MANUELMS311/26/0812/9/0840DESGARRO MUSCULARODD96145205020405024HC240carrionmontalvojudhitcarrion montalvo judhitCARRION MONTALVO JUDHITFC27/14/087/19/0840PARTOBDD69294040100405025HC250carrionsanchezyosselyncarrion sanchez yosselynCARRION SANCHEZ YOSSELYNFC13/17/073/23/0740INFECCION ESTOMACALBAA8624040901105026HC260casasorellanajasmincasas orellana jasminCASAS ORELLANA JASMINFC31/1/081/9/0840TUBERCOLOSISODD4258404020405027HC270casasmendozajulianacasas mendoza julianaCASAS MENDOZA JULIANAFC25/24/076/3/0740QUEMADURASBDD15256404020405028HC280castillamontalvolissethcastilla montalvo lissethCASTILLA MONTALVO LISSETHFD31/21/101/29/1040PULMONIAA DD1402625407020405029HC290cataacuamarianacata acua marianaCATA ACUA MARIANAFS16/7/076/17/0740ANEMIAABDD22154050120405030HC300catarealclaracata real claraCATA REAL CLARAFD64/8/074/19/0740PARTOA BB145540701001005031HC310cautimarquezrosacauti marquez rosaCAUTI MARQUEZ ROSAFS212/11/0812/27/0840AMPUTACION DE MIEMBROI INFERIORBDD9926405020405032HC320cautigutirrezmarianacauti gutirrez marianaCAUTI GUTIRREZ MARIANAFD38/1/088/3/0840ANEMIAODD727274070120405033HC330caycho pacheco joselinecaycho pacheco joselineCAYCHO PACHECO JOSELINEFV29/17/0710/24/0740TUBERCOLOSISRH+CG136840602005034HC340cestopardocamilocesto pardo camiloCESTO PARDO CAMILOMC31/11/101/17/1040HEPATITIS ODD138148204020405035HC350chamcacordobacarlachamca cordoba carlaCHAMCA CORDOBA CARLAFC23/15/073/20/0740INFECCION ESTOMACALA AA7554040901105036HC360chavezsolizjaquelinchavez soliz jaquelinCHAVEZ SOLIZ JAQUELINFS310/7/0810/10/0840INFLUENZAA DD86423405020405037HC370chavezpuertasenriquechavez puertas enriqueCHAVEZ PUERTAS ENRIQUEMD15/6/085/8/0840TRAUMATISMOA DD5673207020405038HC380chavez noriegadeysychavez noriega deysyCHAVEZ NORIEGA DEYSYFV19/7/0710/13/0740PARTOABAG125740601001105039HC390chuqimezvaldiviezoalbertochuqimez valdiviezo albertoCHUQIMEZ VALDIVIEZO ALBERTOMS111/16/0811/27/0840TUBERCULOSISABDD945652050160405040HC400chuqimezpardoFabiolachuqimez pardo FabiolaCHUQIMEZ PARDO FABIOLAFV37/2/087/9/0840ANEMIARH-DD67924060140405041HC410colinaFuertehaysimincolina Fuerte haysiminCOLINA FUERTE HAYSIMINFS13/7/103/15/1040QUISTEOEE243645405020105042HC420colinaataullucoroxanacolina ataulluco roxanaCOLINA ATAULLUCO ROXANAFV64/8/094/21/0940QUEMADURASRH-DD12742406020405043HC430collado anton caritocollado anton caritoCOLLADO ANTON CARITOFS18/28/0710/2/0740COLICOSBBE344440501401005044HC440coluchilojanmiguelcoluchi lojan miguelCOLUCHI LOJAN MIGUELMD31/18/091/30/0940INTOXICACIONA DD110135207020405045HC450coluchiroquedanielacoluchi roque danielaCOLUCHI ROQUE DANIELAFC59/7/0710/13/0740INTOXICACIONRH+DD3552404020405046HC460cordobahuamanraquelcordoba huaman raquelCORDOBA HUAMAN RAQUELFV29/30/0810/14/0840TRAUMATISMOODD844550406020405047HC470cordobarojasnelycordoba rojas nelyCORDOBA ROJAS NELYFS25/2/085/4/0840INFECCION ESTOMACALODD54528405090405048HC480corimanyacautialbertocorimanya cauti albertoCORIMANYA CAUTI ALBERTOFS14/14/075/4/0740INFECCION ESTOMACALRH+BB16624050901005049HC490cruisegutirrezyesseniacruise gutirrez yesseniaCRUISE GUTIRREZ YESSENIAFS22/5/092/11/0940HEPATITIS A DD11683405020405050HC500encisosantarosajoelenciso santarosa joelENCISO SANTAROSA JOELMD25/2/095/15/0940INFECCION ESTOMACALBDD13516207090405051HC510encisopardojoeenciso pardo joeENCISO PARDO JOEMV14/29/095/12/0940AMPUTACION DE MIEMBROI INFERIORA DD13425206020405052HC520espejochamcajaquelinespejo chamca jaquelinESPEJO CHAMCA JAQUELINFD29/20/0810/2/0840INFECCION ESTOMACALABDD82647407090405053HC530espejoquispemarianaespejo quispe marianaESPEJO QUISPE MARIANAFS24/28/085/2/0840TUBERCULOSISABDD52844050160405054HC540espejocamacraquelespejo camac raquelESPEJO CAMAC RAQUELFS83/25/074/4/0740TUBERCOLOSISRH-AA121644050201105055HC550estabridisrojasmariaestabridis rojas mariaESTABRIDIS ROJAS MARIAFS13/23/103/27/1040INFECCION ESTOMACALABEE28405405090105056HC560estabridisrojasneriestabridis rojas neriESTABRIDIS ROJAS NERIFC24/20/095/3/0940DESGARRO MUSCULARRH+DD131652404020405057HC570FernandezunoccjenniFerFernandez unocc jenniFerFERNANDEZ UNOCC JENNIFERFV22/23/103/6/1040DERRAME CEREBRALBEE213339406080105058HC580FernandezvillaFuertemariaFernandez villaFuerte mariaFERNANDEZ VILLAFUERTE MARIAFS13/30/094/12/0940INTOXICACIONABDD12434405020405059HC590FernandezacuadeysiFernandez acua deysiFERNANDEZ ACUA DEYSIFS31/19/081/24/0840TUBERCULOSISBDD451194050160405060HC600FernandezFernandezmariaFernandez Fernandez mariaFERNANDEZ FERNANDEZ MARIAFC45/30/076/9/0740COLICOSODD18884040140405061HC610FuertesalazarcinthiaFuerte salazar cinthiaFUERTE SALAZAR CINTHIAFS31/25/081/29/0840COLICOSABDD46454050140405062HC620FuerteorellanajaquelinFuerte orellana jaquelinFUERTE ORELLANA JAQUELINFC16/1/076/11/0740DESGARRO MUSCULARRH-DD1952404020405063HC630gallardolunayaninagallardo luna yaninaGALLARDO LUNA YANINAFC21/31/102/10/1040DERRAME CEREBRALABEE162829404080105064HC640garciacasasjudhitgarcia casas judhitGARCIA CASAS JUDHITFC32/14/092/17/0940CANCER AL PULMONRH+DD11952404020405065HC650garciarojascarlosgarcia rojas carlosGARCIA ROJAS CARLOSMS21/15/091/28/0940CANCER DE MAMARH-DD109433205020405066HC660garciatorrescamilogarcia torres camiloGARCIA TORRES CAMILOMV11/6/091/22/0940PULMONIAABDD106427206020405067HC670garciaataullucomanuelgarcia ataulluco manuelGARCIA ATAULLUCO MANUELMC412/21/081/8/0940INFECCION ESTOMACALRH+DD101747204090405068HC680garciapuellamariagarcia puella mariaGARCIA PUELLA MARIAFC38/11/088/15/0840COLICOSA DD745314040140405069HC690gonsalescolinahaysimingonsales colina haysiminGONSALES COLINA HAYSIMINFV31/13/081/19/0840ANEMIAA DD44434060120405070HC700gonsalespiakarinagonsales pia karinaGONSALES PIA KARINAFD35/28/076/7/0740TUBERCULOSISRH+DD17474070160405071HC710gonsalesmontenegromonicagonsales montenegro monicaGONSALES MONTENEGRO MONICAFC44/10/074/28/0740AMPUTACION DE MIEMBRO INFERIORBBB4524040201005072HC720gutierrezcamacangelogutierrez camac angeloGUTIERREZ CAMAC ANGELOMC64/28/104/29/1040ANEMIARH-GG1449312040120705073HC730gutierrezpalominokeicogutierrez palomino keicoGUTIERREZ PALOMINO KEICOFC25/2/075/10/0740COLICOSA CC1555404014005074HC740gutierrezvalverdejosegutierrez valverde joseGUTIERREZ VALVERDE JOSEMC33/31/074/13/0740TUBERCULOSISABBB95420401601005075HC750gutirrezrojascarmelinagutirrez rojas carmelinaGUTIRREZ ROJAS CARMELINAFS25/14/105/15/1040CANCER DE MAMARH+GG185339405020705076HC760gutirrezorellanalugianagutirrez orellana lugianaGUTIRREZ ORELLANA LUGIANAFC210/17/0711/26/0740TRAUMATISMOBDD3956404020405077HC770gutirrezsilvayurigutirrez silva yuriGUTIRREZ SILVA YURIFS55/10/075/26/0740COLICOSOCC1995405014005078HC780hilariolunacarmenhilario luna carmenHILARIO LUNA CARMENFD11/1/101/5/1040INFECCION ESTOMACALABDD13614407090405079HC790huamansantoskarinahuaman santos karinaHUAMAN SANTOS KARINAFS54/6/074/22/0740CANCER DE MAMARH-BB17454050201005080HC800huamanchavezjuanhuaman chavez juanHUAMAN CHAVEZ JUANMS03/19/073/26/0740TRAUMATISMOABAA91032050201104081HC810huamaniespejojosehuamani espejo joseHUAMANI ESPEJO JOSEMC310/12/0810/16/0840PULMONIABDD87121204020405082HC820huamanigutierrezangelohuamani gutierrez angeloHUAMANI GUTIERREZ ANGELOMC45/11/085/12/0840COLICOSBDD57992040140405083HC830huertasmontalvodavidhuertas montalvo davidHUERTAS MONTALVO DAVIDMC51/27/092/5/0940INFECCION ESTOMACALRH+DD113941204090405084HC840ingacarrionvictoringa carrion victorINGA CARRION VICTORMC29/25/0810/8/0840INFECCION ESTOMACALRH+DD83949204090405085HC850ingapardokattyinga pardo kattyINGA PARDO KATTYFS24/30/085/3/0840COLICOSRH+DD53574050140405086HC860jaraingaroxanajara inga roxanaJARA INGA ROXANAFD32/16/072/18/0740INFECCION ESTOMACALRH-AA6734070901105087HC870jeripuertasmanueljeri puertas manuelJERI PUERTAS MANUELMS61/21/092/1/0940AMPUTACION DE MIEMBROI INFERIORBDD111437205020405088HC880jerijarajuanjeri jara juanJERI JARA JUANMS29/15/089/26/0840COLICOSBDD813452050140405089HC890jeritorresroxanajeri torres roxanaJERI TORRES ROXANAFV24/26/085/1/0840ANEMIABDD514164060120405090HC900juan de dios manyavilcaerikajuan de dios manyavilca erikaJUAN DE DIOS MANYAVILCA ERIKAFV58/16/088/21/0840TRAUMATISMOA CE334640602005091HC910limachemendozajaquelinlimache mendoza jaquelinLIMACHE MENDOZA JAQUELINFS23/29/074/10/0740ANEMIABBB65640501201005092HC920lisengutierrezlewislisen gutierrez lewisLISEN GUTIERREZ LEWISMD21/24/092/3/0940INFECCION ESTOMACALABDD112439207090405093HC930litano ramoselizabethlitano ramos elizabethLITANO RAMOS ELIZABETHFS38/11/088/15/0840INFECCION ESTOMACALRH-AE322554050901105094HC940lojanhuamaninerilojan huamani neriLOJAN HUAMANI NERIFC64/20/104/21/1040TUBERCOLOSISRH+GG124727404020705095HC950lojanlisenlewislojan lisen lewisLOJAN LISEN LEWISMD24/28/075/2/0740ANEMIAOCC1384207012005096HC960lopezrojascarloslopez rojas carlosLOPEZ ROJAS CARLOSMD310/17/0810/22/0840CANCER AL PULMONABDD889826207020405097HC970lopezrojascarlalopez rojas carlaLOPEZ ROJAS CARLAFC19/5/089/14/0840ANEMIARH-DD795414040120405098HC980lopezmontalvojoelopez montalvo joeLOPEZ MONTALVO JOEMV25/16/085/18/0840PARTOABDD58852060100405099HC990lopezsaenzjaquelinlopez saenz jaquelinLOPEZ SAENZ JAQUELINFC22/12/082/13/0840ANEMIARH-DD494740401204050100HC1000lunachuqimezmaricarmenluna chuqimez maricarmenLUNA CHUQIMEZ MARICARMENFS55/30/105/31/1040QUEMADURA DE PRIMER GRADOBGG225764050207050101HC1010lunavalverdeisabelluna valverde isabelLUNA VALVERDE ISABELFS35/10/105/11/1040DESGARRO MUSCULARABGG1752374050207050102HC1020lunasalvatierrahaydeluna salvatierra haydeLUNA SALVATIERRA HAYDEFD210/7/0711/15/0740INFECCION ESTOMACALA DD38554070904050103HC1030lunacestocamiloluna cesto camiloLUNA CESTO CAMILOMV18/8/079/10/0740COLICOSA DD327320601404050104HC1040lunapenisaleFabiolaluna penisale FabiolaLUNA PENISALE FABIOLAFC35/8/075/22/0740TRAUMATISMORH+CC1832404020050105HC1050lunahuamanijaquelinluna huamani jaquelinLUNA HUAMANI JAQUELINFS23/21/073/29/0740COLICOSRH+AA10126405014011050106HC1060lunalopezmarialuna lopez mariaLUNA LOPEZ MARIAFD62/4/072/10/0740PARTOBAA242407010011050107HC1070manaygutirrezrosiomanay gutirrez rosioMANAY GUTIRREZ ROSIOFS12/5/102/16/1040HEPATITIS RH+EE1729314050201050108HC1080manaypardocristinamanay pardo cristinaMANAY PARDO CRISTINAFC11/12/091/26/0940DERRAME CEREBRALODD10814314040804050109HC1090maravillasaenzenriquemaravilla saenz enriqueMARAVILLA SAENZ ENRIQUEMC26/15/076/25/0740COLICOSA DD261520401404050110HC1100maravillagarciacamilomaravilla garcia camiloMARAVILLA GARCIA CAMILOMV24/16/074/23/0740TUBERCULOSISOCC7132060160050111HC1110marquezestabridismariamarquez estabridis mariaMARQUEZ ESTABRIDIS MARIAFC62/6/082/8/0840PULMONIAODD484554040204050112HC1120marquezcolinaroxanamarquez colina roxanaMARQUEZ COLINA ROXANAFS26/5/076/15/0740PARALISIS FACIALBDD21194050204050113HC1130marquezgarciamanuelmarquez garcia manuelMARQUEZ GARCIA MANUELMS24/18/074/18/0740COLICOSRH-BB324205014010050114HC1140martinezmaravillarosamartinez maravilla rosaMARTINEZ MARAVILLA ROSAFC312/31/081/18/0940HEPATITIS A DD1045204040204050115HC1150martinezlunamayramartinez luna mayraMARTINEZ LUNA MAYRAFD48/26/089/2/0840ANEMIARH+DD7743740701204050116HC1160mejiafigueroasalymejia figueroa salyMEJIA FIGUEROA SALYFD48/6/088/9/0840INFECCION ESTOMACALOAB168740709011050117HC1170mendozagonsalesjulianamendoza gonsales julianaMENDOZA GONSALES JULIANAFV32/20/092/21/0940COLICOSRH-DD1216740601404050118HC1180mendozabarriosmauriciomendoza barrios mauricioMENDOZA BARRIOS MAURICIOMV411/1/0811/9/0840TUBERCOLOSISRH-DD91522060204050119HC1190mendozasantarosakeicomendoza santarosa keicoMENDOZA SANTAROSA KEICOFS16/15/086/23/0840DESGARRO MUSCULARABDD641444050204050120HC1200mendozagutirrezcarmelinamendoza gutirrez carmelinaMENDOZA GUTIRREZ CARMELINAFD35/31/086/5/0840ANEMIARH-DD617740701204050121HC1210mendozachuqimezFannymendoza chuqimez FannyMENDOZA CHUQIMEZ FANNYFC34/4/074/19/0740DESGARRO MUSCULAROBB104540402010050122HC1220mestanza sabujo dianamestanza sabujo dianaMESTANZA SABUJO DIANAFV18/1/088/3/0840AMPUTACION DE MIEMBROI INFERIORRH+AC137540602011050123HC1230montalbogutierrezkarinamontalbo gutierrez karinaMONTALBO GUTIERREZ KARINAFS410/27/0811/3/0840PARTOODD9054840501004050124HC1240montalbolunacarmenmontalbo luna carmenMONTALBO LUNA CARMENFC35/26/085/30/0840QUEMADURASODD60854040204050125HC1250montaloespejolissethmontalo espejo lissethMONTALO ESPEJO LISSETHFC13/31/104/2/1040INFECCION ESTOMACALOEE304254040901050126HC1260montaloquispeangelomontalo quispe angeloMONTALO QUISPE ANGELOMV24/26/095/9/0940INTOXICACIONRH-DD1339872060204050127HC1270montalvomontalbojoemontalvo montalbo joeMONTALVO MONTALBO JOEMS35/2/105/3/1040TUBERCULOSISA GG15503320501607050128HC1280montalvogallardoyaninamontalvo gallardo yaninaMONTALVO GALLARDO YANINAFC29/17/0710/24/0740AMPUTACION DE MIEMBROI INFERIORODD361254040204050129HC1290montalvorojasisamarmontalvo rojas isamarMONTALVO ROJAS ISAMARFD25/4/075/14/0740INFECCION ESTOMACALBCC1645407090050130HC1300montenegrocorimanyaclaramontenegro corimanya claraMONTENEGRO CORIMANYA CLARAFD212/1/0812/15/0840CANCER DE MAMARH-DD9714574070204050131HC1310montenegroaguilerayulimontenegro aguilera yuliMONTENEGRO AGUILERA YULIFV17/20/087/24/0840TUBERCOLOSISABDD703204060204050132HC1320moreno bedon pamelamoreno bedon pamelaMORENO BEDON PAMELAFS57/26/087/29/0840INTOXICACIONABCB692405020050133HC1330mugarojasjhonatanmuga rojas jhonatanMUGA ROJAS JHONATANMC22/7/072/12/0740INFECCION ESTOMACALABAA39320409011050134HC1340murrietaluna mariamurrieta luna mariaMURRIETA LUNA MARIAFV24/8/074/19/0740CANCER DE MAMARH+CG2025406020050135HC1350orellanagonsalesjasminorellana gonsales jasminORELLANA GONSALES JASMINFD22/27/103/9/1040PULMONIAABEE2234414070201050136HC1360orellanapuellalugianaorellana puella lugianaORELLANA PUELLA LUGIANAFS12/15/102/28/1040PULMONIARH-EE1931354050201050137HC1370orellanamarquezjaquelinorellana marquez jaquelinORELLANA MARQUEZ JAQUELINFV24/2/094/15/0940PARTORH+DD12525740601004050138HC1380orellanaFernandezmarianaorellana Fernandez marianaORELLANA FERNANDEZ MARIANAFS13/24/094/6/0940DESGARRO MUSCULARA DD122554050204050139HC1390palominoaguilerakeicopalomino aguilera keicoPALOMINO AGUILERA KEICOFS41/30/092/7/0940QUEMADURA DE SEGUNDO GRADOODD1146434050204050140HC1400pardosanchezkattypardo sanchez kattyPARDO SANCHEZ KATTYFD54/12/104/13/1040COLICOSBEE33452040701401050141HC1410pardocastillalissethpardo castilla lissethPARDO CASTILLA LISSETHFD28/28/0710/2/0740CANCER DE MAMAABDD34254070204050142HC1420pardohilariocarmenpardo hilario carmenPARDO HILARIO CARMENFC26/23/077/3/0740ANEMIAODD307840401204050143HC1430pardocoluchimiguelpardo coluchi miguelPARDO COLUCHI MIGUELMV14/24/074/27/0740ANEMIAABCC11612060120050144HC1440pariaevangelistalizbethparia evangelista lizbethPARIA EVANGELISTA LIZBETHFV17/20/087/24/0840CANCER DE MAMABCC1235406020050145HC1450penisaletoledoFabiolapenisale toledo FabiolaPENISALE TOLEDO FABIOLAFC22/8/092/13/0940INFLUENZABDD1171494040204050146HC1460peraltacoluchielthonperalta coluchi elthonPERALTA COLUCHI ELTHONMD31/16/101/23/1040INFLUENZARH-DD13925202070204050147HC1470perezunoccyuliperez unocc yuliPEREZ UNOCC YULIFS32/17/092/19/0940DERRAME CEREBRALODD1203654050804050148HC1480pinedorivasplatanelypinedo rivasplata nelyPINEDO RIVASPLATA NELYFS16/11/076/21/0740INFECCION ESTOMACALODD24554050904050149HC1490pinedomartinezrosapinedo martinez rosaPINEDO MARTINEZ ROSAFV54/12/074/21/0740QUEMADURASABCC535406020050150HC1500piacasasmaripia casas mariPIA CASAS MARIFS22/19/103/3/1040CANCER AL PULMONA EE2032374050201050151HC1510piaFuertekarinapia Fuerte karinaPIA FUERTE KARINAFD43/27/094/9/0940CANCER DE MAMABDD123264070204050152HC1520piscohuincho rosapisco huincho rosaPISCO HUINCHO ROSAFS47/14/087/19/0840DESGARRO MUSCULARA CB469405020050153HC1530puellavalverdejuanpuella valverde juanPUELLA VALVERDE JUANMC15/22/105/23/1040AMPUTACION DE MIEMBROI INFERIORRH-GG2055432040207050154HC1540puellaFernandezjenniFerpuella Fernandez jenniFerPUELLA FERNANDEZ JENNIFERFD212/26/071/4/0840PARTORH+DD412740701004050155HC1550puellaperezyulipuella perez yuliPUELLA PEREZ YULIFS15/22/076/1/0740TUBERCOLOSISA CC2185405020050156HC1560puertaslopezenriquepuertas lopez enriquePUERTAS LOPEZ ENRIQUEMS64/24/104/25/1040QUEMADURASOGG1348292050207050157HC1570puertashuertasdavidpuertas huertas davidPUERTAS HUERTAS DAVIDMS24/30/075/6/0740TUBERCULOSISRH-CC14722050160050158HC1580quirozcamachocesarquiroz camacho cesarQUIROZ CAMACHO CESARMD51/25/081/29/0840CANCER AL PULMONBAG185320702011050159HC1590quispecordobamarianaquispe cordoba marianaQUISPE CORDOBA MARIANAFV54/8/104/9/1040TRAUMATISMOA EE324454060201050160HC1600quispeencisojoelquispe enciso joelQUISPE ENCISO JOELMS26/21/077/1/0740QUEMADURASRH+DD295472050204050161HC1610quispeestabridisneriquispe estabridis neriQUISPE ESTABRIDIS NERIFS46/13/076/23/0740TRAUMATISMORH-DD25874050204050162HC1620quispegarciacarlosquispe garcia carlosQUISPE GARCIA CARLOSMC34/22/074/26/0740PULMONIABCC1034204020050163HC1630quispetorresanabelquispe torres anabelQUISPE TORRES ANABELFS14/14/074/22/0740ANEMIARH+CC6424050120050164HC1640ramirez mallaopomacarmenramirez mallaopoma carmenRAMIREZ MALLAOPOMA CARMENFC27/8/087/14/0840COLICOSRH-BC1143404014010050165HC1650ramoscristobalnataliramos cristobal nataliRAMOS CRISTOBAL NATALIFC37/2/087/9/0840TUBERCULOSISOBC1052404016010050166HC1660realpinedoclarareal pinedo claraREAL PINEDO CLARAFV112/26/081/14/0940QUEMADURA DE SEGUNDO GRADOODD102584060204050167HC1670realcasasjhonatanreal casas jhonatanREAL CASAS JHONATANMS18/16/088/21/0840DESGARRO MUSCULARBDD758332050204050168HC1680rivasplatalopezFabiolarivasplata lopez FabiolaRIVASPLATA LOPEZ FABIOLAFC13/19/103/24/1040INFECCION ESTOMACALBEE273994040901050169HC1690rivasplatamaravillanelyrivasplata maravilla nelyRIVASPLATA MARAVILLA NELYFS14/17/094/30/0940COLICOSABDD1302540501404050170HC1700rodriguez sosalizbethrodriguez sosa lizbethRODRIGUEZ SOSA LIZBETHFC46/26/087/4/0840ANEMIARH+BB778404012010050171HC1710rojaschaveznelyrojas chavez nelyROJAS CHAVEZ NELYFV54/16/104/17/1040PARTOABEE34462540601001050172HC1720rojaslunaisamarrojas luna isamarROJAS LUNA ISAMARFV12/2/092/9/0940AMPUTACION DE MIEMBRO SUPERIORRH-DD1155454060204050173HC1730rojashuamanraquelrojas huaman raquelROJAS HUAMAN RAQUELFC411/11/0811/21/0840ANEMIABDD934940401204050174HC1740rojascamacyosselynrojas camac yosselynROJAS CAMAC YOSSELYNFD19/10/089/20/0840TUBERCULOSISA DD8044340701604050175HC1750rojasunoccyesseniarojas unocc yesseniaROJAS UNOCC YESSENIAFS16/26/087/4/0840PARALISIS FACIALODD66684050204050176HC1760rojaspuelladavidrojas puella davidROJAS PUELLA DAVIDMV16/10/086/17/0840COLICOSBDD638620601404050177HC1770rojasmontalolissethrojas montalo lissethROJAS MONTALO LISSETHFC14/24/084/30/0840QUEMADURASA DD50554040204050178HC1780rojasmontaloangelorojas montalo angeloROJAS MONTALO ANGELOMV16/17/076/27/0740PARTOBDD277620601004050179HC1790rojasjerimanuelrojas jeri manuelROJAS JERI MANUELMS24/26/074/28/0740QUEMADURASRH+CC1296205020050180HC1800rojasbellodanielarojas bello danielaROJAS BELLO DANIELAFC14/18/074/24/0740COLICOSRH-CC8564040140050181HC1810rojasmontalboangelorojas montalbo angeloROJAS MONTALBO ANGELOMC63/27/074/7/0740QUEMADURASA BB58120402010050182HC1820rojasjerioscarrojas jeri oscarROJAS JERI OSCARMC32/10/072/14/0740INFECCION ESTOMACALRH+AA45420409011050183HC1830romanpuma de villaizannelinaroman puma de villaizan nelinaROMAN PUMA DE VILLAIZAN NELINAFV34/4/074/19/0740DERRAME CEREBRALABAG192940608011050184HC1840roqueaguileradanielaroque aguilera danielaROQUE AGUILERA DANIELAFC31/26/102/4/1040CANCER AL PULMONBEE1527274040201050185HC1850saenzjerijaquelinsaenz jeri jaquelinSAENZ JERI JAQUELINFV13/27/103/30/1040INFECCION ESTOMACALRH+EE294124060901050186HC1860saenztorresenriquesaenz torres enriqueSAENZ TORRES ENRIQUEMS14/23/095/6/0940CANCER DE MAMAODD132252050204050187HC1870salazarmarquezcinthiasalazar marquez cinthiaSALAZAR MARQUEZ CINTHIAFS43/15/103/21/1040INFECCION ESTOMACALA EE263834050901050188HC1880salazarquispekattysalazar quispe kattySALAZAR QUISPE KATTYFV24/14/094/27/0940TUBERCULOSISBDD1298940601604050189HC1890salazarde la vegaaliciasalazar de la vega aliciaSALAZAR DE LA VEGA ALICIAFS26/20/086/29/0840QUEMADURASABBC96740502010050190HC1900salvatierratoledohaydesalvatierra toledo haydeSALVATIERRA TOLEDO HAYDEFD22/10/102/22/1040INFLUENZAOEE1830334070201050191HC1910sanchezlunaangelosanchez luna angeloSANCHEZ LUNA ANGELOMC310/5/0810/20/0840HEPATITIS RH-DD858262040204050192HC1920sanchezlojannerisanchez lojan neriSANCHEZ LOJAN NERIFV25/4/085/5/0840INFECCION ESTOMACALRH-DD55524060904050193HC1930sanchezdipaz melisasanchez dipaz melisaSANCHEZ DIPAZ MELISAFS54/16/074/23/0740TUBERCOLOSISBCC884405020050194HC1940sandoval quispecarensandoval quispe carenSANDOVAL QUISPE CARENFD24/6/074/22/0740PARTOA CC7264070100050195HC1950santarosarojaskeicosantarosa rojas keicoSANTAROSA ROJAS KEICOFC45/26/105/27/1040FRACTURAA GG2156454040207050REALIZAR FORMULAS PARA LA SIGUIENTES PREGUNTASREALIZAR FORMULAS PARA LAS SIGUIENTES PREGUNTAS UTILIZANDO FUNCION CORTAR.SI UTILIZANDO FUNCION

1. N DE MUJERES1441. sumar gastos administrativos de toda las mujeres2102. N DE VARONES 512. sumar gastos administrativos de todo los hombres26403. N DE CASADAS 643. Sumar gastos administrativos de pacientes que sean viudos 4. N SOLTEROS605. N DE PACIENTES CON ANEMIA195. sumar otros gastos de pacientes que sean casados86506. N DE PACIENTES CON PARTO136. sumar moras de pacientes con hijos7. N DE PACIENTES CON QUEMADURAS137. sumar descuento de paciente sin hijos8. N DE PACIENTES CON TRAUMATISMO88. sumar subtotal de pacientes con anemia9. N DE PACIENTES DE PABELLON A179. sumar neto a pagar de pacientes de cancer de mama10. N DE PACIENTES CON HIJOS19410. sumar gastos administrativos de pacientes que esten en pabellon A11. N DE PACIENTES SIN HIJOS111. sumar moras de pacientes con hijos12. sumar mora de pacientes que tengas la sangre ERH negativo13. sumar descuento de pacientes que tengas la sangre ERH POSITIVOERROR:#REF!ERROR:#REF!

Hoja14/23/149/8/004/24/144/25/144/26/144/27/144/28/14