![]() ![]() That's where you're right to think that a full relational database is more likely to meet your need. The problem you might encounter-more likely "will encounter"-is if you start giving radiotherapy to a patient high on the sequence of the core Patient List, and they interfere with the sequence already established. You can set up similar criteria for the chemo group, and so forth. Now, this will continue to add new patients for whom a "Yes" is entered in the RT column. Here's what the formula for the Radiotherapy group looks like: I've added it to two of your detailed treatment sheets here in this. Thanks for any FILTER function may be what you're looking for. I've put together a very small dummy book to try and illustrate what I'm getting at. In terms of scale this would be relatively few rows (60 so far, around 200 patients a year) but a lot of columns to record the various events of interest. Similarly I've had a quick look in PowerApps and not sure I've got anything like the skills for that! Would it be feasible to do this in Excel with vlookup or other rules? I have access to Access but it's beyond me I think. Is it possible to set up a rule so that as a I add a new patient to the main list, and then tick the treatment boxes 'chemo' and 'radiotherapy', that the basic demographics would then be copied into a new line in the chemo and radiotherapy sheets automatically? I'd like to set up separate worksheets for each of the treatment types so that I can gather the relevant data, but would like the records to be linked to save duplication of typing (as I type this I increasingly see this needs to be a relational database I think.) and to try and keep one unified set of data. In my main sheet I have the list to which I add every new patient I see (Name, DoB, ID number) and details of their cancer (site, stage, type etc) and then their first treatment (date seen, radiotherapy or chemo or immunotherapy).īecause patients often have more than one type of treatment at various times and in various sequences to record all the important events in one sheet is messy at best. ![]() This template can be used at home or even by medical practitioners, such as nutritionists, cardiologists and general physicians.I have a small spreadsheet with all of my patients but am struggling to set up a more efficient set of sheets and possibly a dashboard, rather than it just be a simple and fairly ineffective list. From here you can easily see if you are maintaining a healthy BP or not. The second worksheet is the Blood Pressure Chart tab where the information from the Blood Pressure Table is automatically generated into a chart so you can see at first glance the trends of your blood pressure over a certain period of time. View Trends Based on Data Over a Period of Time The physician’s number is also indicated in case of emergency situations. There are also markers for calling the physician if the levels of systolic and diastolic BP is above a set level. This worksheet also has a header for the patient’s Name, Target Blood Pressure: Systolic and diastolic blood pressure. This worksheet has a table with column headers such as Date, Time, Systolic, Diastolic, Heart Rate and Comment. One worksheet, the Blood Pressure Data, is used for typing in daily blood pressure measurements. This health tracker contains two worksheets that each has specific functions. Track Blood Pressure and Heart Rate Levels The Free Blood Pressure Tracker Template for Excel is specially designed for tracking blood pressure so you can monitor it for yourself or a family member, or show it at your next visit to your physician. Microsoft Excel can help you automatically generate visual charts to help you see trends when it comes to your blood pressure levels on a daily basis. If you are one who is health conscious, wanting to live a healthier lifestyle, or needing to keep track of your blood pressure for medical reasons, then you would need a tracker that will easily help you keep yourself updated.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |