لینک کوتاه : https://en.magicfile.ir/?p=2480
داشبورد پزشکی برای تجزیه و تحلیل تاریخچه بیمار در اکسل
Interactive data visualization for analyzing health indicators based on medical history data will be useful not only for the doctor, but also for the patient himself. After all, it is the patient who is primarily responsible for his own health. It creates an interest in modernization and improvement. This could serve as a good prototype for a real healthcare software product. That is why macros are not used in it and all tables with formula processing are presented in detail with headers and comments. Feel free to use this prototype to implement the best data visualization ideas for medicine.
To understand the working principle of the medical dashboard template in Excel, we first simulate the situation. We have obtained the basic data from the patient's medical history for a period of 1 month (November 2020). Filling the table in the format is necessary so that the dashboard can depict some basic indicators of the patient's health in the main sheet. week or 5 days and at least 1 day) to obtain their average values. This avoids so-called statistical "noise" and also filters statistical outliers.
نمونه از تصاویر در اجرا
The pattern fill table is on the "Data" tab. And it consists of 17 columns:
- DATE روز جاری در تاریخ است.
- DAY روز هفته است.
- مغز - شاخص های وضعیت مغز (سطح 5 - عالی، 1 - بسیار بد).
- ریه ها - شاخص های سطح وضعیت ریه طبق یک سیستم ارزیابی پنج نقطه ای.
- قلب - شاخص های سلامت قلب.
- معده - وضعیت دستگاه گوارش.
- کلیه - وضعیت فعلی کلیه ها.
- SYSTOLIC - فشار خون سیستولیک.
- DIASTOLIC - مقادیر فشار دیستونیک.
- CELSIUS - درجه حرارت بدن سلسیوس.
- PULSE میانگین ضربان روزانه قلب در دقیقه است.
- Leukocytes - the number of points of deviation from the norm of leukocytes in the blood (value 0 means normal, -3 deviation below the norm, 3 - above the normal limit).
- گلوکز - سطح گلوکز خون.
- هموگلوبین - سطح انحراف از هنجار شاخص هموگلوبین.
- نشاط - نتایج تست های نشاط.
- استرس سطح استرس بیمار است.
- واکنش - شاخص های پاسخ عصبی بیمار.
All data related to the history of the disease are transferred and processed from the table, with sample formulas, in the "Processing" tab:
In modern medicine, it is equally important to assess, monitor and improve indicators of neuropsychological status. Positive therapy is actively gaining popularity and has already proven itself successfully. Resetting the patient's mood allows the secretion of the appropriate vital hormones to be naturally and naturally stimulated.
برای شما کاربر عزیز پیشنهاد دانلود داده می شود