Excel for good: Helping people track their medical information in one place

By
Published 04-15-2020 08:00 AM 3,048 Views
Microsoft

Our story this week comes from our Excel MVP Yolanda Cuesta in Spain.  Wanting to help people keep track of which doctors/specialists they need to see, upcoming visits, drug prescriptions, etc., Yolanda built an app that brings all this information together in one place – on their mobile – using Microsoft Excel and PowerApps.  In her own words,

 

“He creado con Power apps [sic] medical info una sencilla aplicación, app, con la herramienta de Microsoft Power apps [sic], en concreto sirve para llevar un registro de la información médica.

 

“Lo que quería es tener recopilado y en todo momento la información sobre las diferentes consultas en diferentes especialidades médicas y los resultados de las mismas.

 

“Esto porque me había dado cuenta de que sobre todo para las personas más mayores les es difícil recordar todos los especialistas médicos a los que tienen que acudir, las citas sucesivas, lugar donde son las consultas, las indicaciones de medicación,…

 

“Y pensé que tenerlo todo en una app en el móvil serviría de apoyo y recordatorio de los diferentes tratamientos y de la evolución.

 

“Conocía la posibilidad de crear aplicaciones para el móvil con Microsoft Power apps [sic] y como desde Excel se podía usar alguna de las ya pre-creadas para llevar a cabo mi proyecto.”

 

Read more >

excelcontabilidadytic.com/power-apps-medical-info-con-excel

 

Have a story to share with us? Add them to the comments below.

 

Cuong
Microsoft

 

2 Comments
Occasional Visitor

Como corrijo este mensaje de Excel, el nombre ya existe en la hoja de destino nombre anterior: enero, pero yo estoy escribiendo nombre de un equipo. este  mensaje me sale cuando habro en un procesador de 64 bits, y este programa fue creado en 32 bits.

 

Wilson320_1-1587690881071.png

 

Microsoft

Wilson, el error te aparece porque estás usando el mismo nombre de rango en la hoja de origen y en la de destino.  Entonces cuando mueves o pegas información, Excel te advierte que el nombre de rango ya existe.  Para no ver el error, puedes evitar usar el mismo nombre de rango en ambas hojas.  En Excel para Windows, puedes ir a Fórmulas -> Administrador de nombres, y editar el nombre o borrar el nombre de rango.

%3CLINGO-SUB%20id%3D%22lingo-sub-1308262%22%20slang%3D%22en-US%22%3EExcel%20for%20good%3A%20Helping%20people%20track%20their%20medical%20information%20in%20one%20place%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1308262%22%20slang%3D%22en-US%22%3E%3CP%3EOur%20story%20this%20week%20comes%20from%20our%20Excel%20MVP%20%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5000455%3FfullName%3DYolanda%2520Cuesta%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EYolanda%20Cuesta%3C%2FA%3E%20in%20Spain.%26nbsp%3B%20Wanting%20to%20help%20people%20keep%20track%20of%20which%20doctors%2Fspecialists%20they%20need%20to%20see%2C%20upcoming%20visits%2C%20drug%20prescriptions%2C%20etc.%2C%20Yolanda%20built%20an%20app%20that%20brings%20all%20this%20information%20together%20in%20one%20place%20%E2%80%93%20on%20their%20mobile%20%E2%80%93%20using%20Microsoft%20Excel%20and%20PowerApps.%26nbsp%3B%20In%20her%20own%20words%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E2%80%9CHe%20creado%20con%20Power%20apps%20%5Bsic%5D%20medical%20info%20una%20sencilla%20aplicaci%C3%B3n%2C%20app%2C%20con%20la%20herramienta%20de%20Microsoft%20Power%20apps%20%5Bsic%5D%2C%20en%20concreto%20sirve%20para%20llevar%20un%20registro%20de%20la%20informaci%C3%B3n%20m%C3%A9dica.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E2%80%9CLo%20que%20quer%C3%ADa%20es%20tener%20recopilado%20y%20en%20todo%20momento%20la%20informaci%C3%B3n%20sobre%20las%20diferentes%20consultas%20en%20diferentes%20especialidades%20m%C3%A9dicas%20y%20los%20resultados%20de%20las%20mismas.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E2%80%9CEsto%20porque%20me%20hab%C3%ADa%20dado%20cuenta%20de%20que%20sobre%20todo%20para%20las%20personas%20m%C3%A1s%20mayores%20les%20es%20dif%C3%ADcil%20recordar%20todos%20los%20especialistas%20m%C3%A9dicos%20a%20los%20que%20tienen%20que%20acudir%2C%20las%20citas%20sucesivas%2C%20lugar%20donde%20son%20las%20consultas%2C%20las%20indicaciones%20de%20medicaci%C3%B3n%2C%E2%80%A6%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E2%80%9CY%20pens%C3%A9%20que%20tenerlo%20todo%20en%20una%20app%20en%20el%20m%C3%B3vil%20servir%C3%ADa%20de%20apoyo%20y%20recordatorio%20de%20los%20diferentes%20tratamientos%20y%20de%20la%20evoluci%C3%B3n.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E2%80%9CConoc%C3%ADa%20la%20posibilidad%20de%20crear%20aplicaciones%20para%20el%20m%C3%B3vil%20con%20Microsoft%20Power%20apps%20%5Bsic%5D%20y%20como%20desde%20Excel%20se%20pod%C3%ADa%20usar%20alguna%20de%20las%20ya%20pre-creadas%20para%20llevar%20a%20cabo%20mi%20proyecto.%E2%80%9D%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERead%20more%20%26gt%3B%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-center%22%3E%3CA%20href%3D%22https%3A%2F%2Fexcelcontabilidadytic.com%2Fpower-apps-medical-info-con-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Eexcelcontabilidadytic.com%2Fpower-apps-medical-info-con-excel%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHave%20a%20story%20to%20share%20with%20us%3F%20Add%20them%20to%20the%20comments%20below.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECuong%3CBR%20%2F%3EMicrosoft%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1308262%22%20slang%3D%22en-US%22%3E%3CP%3EOur%20story%20this%20week%20comes%20from%20our%20Excel%20MVP%20%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5000455%3FfullName%3DYolanda%2520Cuesta%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3EYolanda%20Cuesta%3C%2FA%3E%20in%20Spain.%26nbsp%3B%20Wanting%20to%20help%20people%20keep%20track%20of%20which%20doctors%2Fspecialists%20they%20need%20to%20see%2C%20upcoming%20visits%2C%20drug%20prescriptions%2C%20etc.%2C%20Yolanda%20built%20an%20app%20that%20brings%20all%20this%20information%20together%20in%20one%20place%20%E2%80%93%20on%20their%20mobile%20%E2%80%93%20using%20Microsoft%20Excel%20and%20PowerApps.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1308262%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBlog%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20good%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1334324%22%20slang%3D%22es-ES%22%3ERe%3A%20Excel%20for%20good%3A%20Helping%20people%20track%20their%20medical%20information%20in%20one%20place%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1334324%22%20slang%3D%22es-ES%22%3E%3CP%3EAs%20I%20correct%20this%20Excel%20message%2C%20the%20name%20already%20exists%20in%20the%20target%20sheet%20previous%20name%3A%20January%2C%20but%20I%20am%20typing%20a%20computer%20name.%20this%20message%20comes%20out%20when%20I'm%20on%20a%2064-bit%20processor%2C%20and%20this%20program%20was%20created%20in%2032-bit.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Wilson320_1-1587690881071.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186366i7971B3C862F1C800%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Wilson320_1-1587690881071.png%22%20alt%3D%22Wilson320_1-1587690881071.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1337884%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20good%3A%20Helping%20people%20track%20their%20medical%20information%20in%20one%20place%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337884%22%20slang%3D%22en-US%22%3E%3CP%3EWilson%2C%20el%20error%20te%20aparece%20porque%20est%C3%A1s%20usando%20el%20mismo%20nombre%20de%20rango%20en%20la%20hoja%20de%20origen%20y%20en%20la%20de%20destino.%26nbsp%3B%20Entonces%20cuando%20mueves%20o%20pegas%20informaci%C3%B3n%2C%20Excel%20te%20advierte%20que%20el%20nombre%20de%20rango%20ya%20existe.%26nbsp%3B%20Para%20no%20ver%20el%20error%2C%20puedes%20evitar%20usar%20el%20mismo%20nombre%20de%20rango%20en%20ambas%20hojas.%26nbsp%3B%20En%20Excel%20para%20Windows%2C%20puedes%20ir%20a%26nbsp%3BF%C3%B3rmulas%20-%26gt%3B%20Administrador%20de%20nombres%2C%20y%20editar%20el%20nombre%20o%20borrar%20el%20nombre%20de%20rango.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎Apr 15 2020 08:00 AM
Updated by: