![]() ![]() (Select the chart, then click the 3-dots in the upper right of it. You could also move the chart to it's own tab to make it much larger. You can then hide columns A through G if you just want the chart. The only other setup you need to do is fill in the gray items on the BPC tab which set the "goal" lines and some conditional formatting (green if you are less than or equal to the goal). Just change the 'Form Responses 1' bits to whatever new tab it provides. (for our example we will be doing a blood pressure flowsheet). If you put them in this order you should be able to quickly adjust the formulas on the "Blood Pressure Charts" tab, yellow highlighted cells, to refer to the new tab it creates, "Form Responses 3" probably, and it should be automatic. Using this blood pressure chart: To work out what your blood pressure readings mean, just find your top number (systolic) on the left side of the blood. Google Fit or Apple Health to Complete Provider Order. ![]() The form should have 5 questions that are all "Short answer text" type questions, although you could have the first 4 be numbers if you choose. ![]() To do that go to the Tools menu > Create a new form. ![]() Or, I find it easier to use a form to enter the data. You can manually enter the data on the Blood Pressure Charts tab. You'll want to make a copy of this before doing anything so it isn't shared with the world. Here's one that I made for myself a while back: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |