Hi there, this is Terry Austin – long time Castaway, occasional contributor and random chit-chat visitor. <\/p>\n
Allison put out the plea over in the Facebook group for some audio spots during a busy time as she and Steve are off enjoying themselves a MacStock. By the way hope Jeff Gamet managed to deliver that hug from me!<\/p>\n
Let\u2019s start with one of the world\u2019s most serious problems to be solved\u2026. Keeping Mom alive, healthy and happy.<\/p>\n
A few short weeks ago my beloved mother was diagnosed with multiple myeloma, a blood cancer. I am doing my best to spend as much time with her as I can, but I live a four hour drive away.<\/p>\n
One of the most complicated issues she faces with this battle is keeping track of a complex regime of oral medications, injections an infusions that constitute her chemotherapy. Some medications are daily, some must be taken for a few days then paused and restarted later in a 21 day repeating cycle. Of course there are appointments for portal infusions or injections at the clinic. <\/p>\n
It could become overwhelming for anyone\u2026 <\/p>\n
When I was home for a few days I saw the paper calendar she was trying to use to track the confusing regime. After just two days it was a confusing mess.<\/p>\n
She said to me \u201cI just wish I had something I could check off and know it was all done properly\u201d.<\/p>\n
Mom is a pretty darned tech savvy 78 year old. She\u2019s used an iPhone and iPad for about five years now and is comfortable with those.<\/p>\n
Initially I set up her schedule in Calendar and shared her calendar with me so I could help remind her if needed\u2026 That was ok, but still didn\u2019t let her check off items as they were completed.<\/p>\n
Then it hit me – COLLABORATION in iWork!<\/p>\n
I have become a huge fan of Numbers in the past few years in my day job as a professor. I track several things, including grades in Numbers. One of the default spreadsheet templates is a checklist with a simple tap-to-check checkbox option.<\/p>\n
![\"Numbers](\"https:\/\/www.podfeet.com\/blog\/wp-content\/uploads\/2017\/07\/numbers_medicine_schedule.png\" "\\"numbers_medicine_schedule.png\\"")
So\u2026 I proceeded to build a 21 day cycle calendar for Mom in Numbers. Mind you, the inspiration for this hit me about about 10:00 one evening and I sat up in her front guest bedroom until about 1:30 in the morning building the framework of this spreadsheet.<\/p>\n
First I laid out the rows from day 1 to day 21<\/p>\n
Then I put in all of the daily morning and daily evening meds<\/p>\n
I followed those with the phased meds that occurred days 1-4 and days 9-12<\/p>\n
After that, I put in all of the appointments for trips to the clinic.<\/p>\n
At the end of each day I inserted a positive affirmation like \u201cYour family loves you\u201d, \u201cWe love you, Gran\u201d, \u201cBest Mom EVER!\u201d\u2026 She can\u2019t possibly look at this list and not feel all of us right there with her.<\/p>\n
Finally I felt pleased with the results and went off to sleep. First thing next morning I sent a collaboration invite to Mom with edit privileges, and to my sister to view only. Then I walked back to her bedroom and showed her how to accept the invite.<\/p>\n
The Spreadsheet now lives on the first home screen of her iPhone and her iPad.<\/p>\n
Later that day we went for an appointment with her doctor. Mom proudly showed her schedule to her hematologist. The doctor\u2019s eyes popped out and she blurted out \u201cOH MY! Can I please get a copy of that?!?\u201d<\/p>\n
Now, whether I\u2019m at Mom\u2019s or far away at home I can open the schedule and have the assurance of knowing that her meds are on schedule.<\/p>\n
And\u2026 THAT is how Apple helps solve this world-changing problem<\/p>\n","protected":false},"excerpt":{"rendered":"
Hi there, this is Terry Austin – long time Castaway, occasional contributor and random chit-chat visitor. Allison put out the plea over in the Facebook group for some audio spots during a busy time as she and Steve are off enjoying themselves a MacStock. By the way hope Jeff Gamet managed to deliver that hug […]<\/p>\n","protected":false},"author":1,"featured_media":12302,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[147],"tags":[1798,1799,1801,1797,1800,1795,1796],"class_list":["post-12300","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-posts","tag-cancer","tag-caring","tag-collaboration","tag-medicine","tag-mom","tag-numbers","tag-spreadsheet"],"jetpack_featured_media_url":"https:\/\/www.podfeet.com\/blog\/wp-content\/uploads\/2017\/07\/numbers_logo.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/posts\/12300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/comments?post=12300"}],"version-history":[{"count":2,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/posts\/12300\/revisions"}],"predecessor-version":[{"id":12303,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/posts\/12300\/revisions\/12303"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/media\/12302"}],"wp:attachment":[{"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/media?parent=12300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/categories?post=12300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.podfeet.com\/blog\/wp-json\/wp\/v2\/tags?post=12300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}