The Family Care Spreadsheet

The cells were color-coded. The worrying was not.

Three days before Gloria Nolan’s hip replacement, her son Kevin sent the family a link to a spreadsheet.

The file was called MOM CARE MASTER—FINAL. It contained five color-coded tabs, fourteen dropdown menus, and a column labeled UNFORESEEN NEEDS, which was empty because nobody had foreseen any.

“This should keep everything organized,” Kevin announced during the family video call.

Gloria leaned closer to her tablet. “I didn’t know my hip required its own accounting department.”

Her doctor expected the surgery to go well. Gloria was seventy-eight, stubborn in all medically useful ways, and determined to recover at home. For several weeks, however, she would need help with meals, medications, physical therapy, laundry, transportation, and anything located below knee level.

Gloria’s oldest daughter, Beth, lived ten minutes away. Kevin lived forty minutes away and was, in his own words, “good with systems.” Their younger sister, Amy, lived two hours away but had volunteered to handle telephone calls, insurance questions, and appointment scheduling.

Kevin shared his screen. “Blue is me. Yellow is Amy. Green is Beth.”

“What color am I?” Gloria asked.

“Gray.”

“Why gray?”

“You’re the care recipient, not a task owner.”

Gloria folded her arms. “I can still make toast.”

Kevin added TOAST—SELF-MANAGED to the meal tab.

The spreadsheet covered six weeks. Each row included a date, task, assigned person, priority level, completion status, and notes. Kevin had created a dropdown menu with the options NOT STARTED, IN PROGRESS, COMPLETE, and WAITING ON THIRD PARTY.

Gloria read the last one twice. “Is the third party the undertaker?”

“No, Mom.”

“I’m just trying to understand the system.”

Kevin explained that overdue tasks would automatically turn red.

“I know what red means,” Gloria said. “I owned a checkbook before you were born.”

Beth watched her siblings debate whether medication reminders belonged under HEALTHCARE or DAILY SUPPORT. She had spent the previous two weeks calling the surgeon, borrowing a shower chair, moving a bedroom lamp, and removing every rug Gloria insisted had never caused anyone trouble.

The spreadsheet looked beautiful. For the first time, Beth thought maybe this wouldn't all fall on her.

This Community Is Powered by You
What started as a small circle has grown into something much bigger, and it’s all because of readers like you.
Every time you forward this email, post it on socials, or bring someone new into the fold, you’re helping build one of the most passionate, independent communities out there.
Want to keep the momentum going?
Share this newsletter with someone who should be part of this conversation.

Thank you for being here. It means everything.

Gloria’s surgery went well. She came home on Friday afternoon with a walker, two ice packs, four prescriptions, and twelve pages of instructions printed in type small enough to qualify as a vision test.

Beth drove her home, helped her change clothes, arranged the pill bottles on the kitchen counter, and heated the soup Amy had sent through a delivery service.

At 6:14, Beth’s phone chimed. Kevin had updated the spreadsheet. TRANSPORTATION HOME FROM HOSPITAL—COMPLETE. At 6:16, it chimed again. EVENING MEAL—COMPLETE.

Beth was still washing the soup bowl.

The first weekend went smoothly. Kevin came Saturday morning and installed a temporary handrail beside the back steps. He stayed for three hours, fixed a dripping bathroom faucet, and labeled the refrigerator shelves with blue painter’s tape. He marked all three tasks complete before leaving the driveway.

Amy called Gloria twice a day. She also spent forty-five minutes arguing with the insurance company about a physical-therapy copayment. That earned her two yellow cells and a note documenting the confirmation number.

Beth handled the spaces between the cells. She noticed Gloria couldn't carry a cup of coffee while using the walker. She replaced the batteries in the television remote. She found the left compression sock behind the recliner and convinced Gloria that wearing only the right one was not “close enough.” None of those things appeared on the spreadsheet.

The Spaces Between the Cells

On Monday morning, Kevin assigned himself the prescription refill. At noon, he added a note. “Beth can pick up since she is already nearby.” Beth was not already nearby. She was at work.

The pharmacy was six minutes from Gloria’s house, so everyone treated it as though it were inside Beth’s kitchen. She picked up the prescription after work. The pharmacist said the insurance company would not cover it until the following day.

Beth called the doctor, called the insurance company, called the pharmacy again, and waited on hold long enough to hear the instrumental version of “Lean on Me” four times. At 7:42 that evening, Kevin marked the prescription COMPLETE. Beth made herself a peanut-butter sandwich for dinner.

By the second week, the spreadsheet had become more detailed, and the care had become less evenly divided. Amy scheduled Gloria’s follow-up appointment from two hours away. Beth drove her there. Kevin ordered groceries online. Beth carried them inside, put them away, and returned the low-sodium soup because Gloria said it tasted like “water that had heard about chicken.”

Amy arranged for a home-health nurse. Beth changed her work schedule to be there when the nurse arrived. It was the third time in six workdays she had rearranged her hours, and her supervisor had started asking how long the arrangement would last.

Kevin added a new column called TASK OWNER to distinguish the person responsible for a task from the person physically performing it. This improvement resulted in Kevin owning several tasks Beth performed.

Whenever anyone asked how things were going, Kevin said, “Pretty well. Almost everything is green.” He was referring to the spreadsheet. Beth was beginning to dislike the color green.

Every request seemed small on its own. Could she stop by before work and make sure Gloria had eaten? Could she bring the mail inside? Could she put the clean sheets on the bed? Could she look for the physical therapist’s business card? It was often faster to do something than to explain why she could not, so Beth kept saying yes. She also kept updating the spreadsheet because Kevin sent reminders when she did not.

On Thursday evening, Beth sat at Gloria’s kitchen table entering completion dates while her mother watched a game show in the next room. From the television, an audience applauded a woman who had correctly guessed the price of a refrigerator.

Gloria called from the recliner. “Are you working?”

“I’m updating your care spreadsheet.”

“I thought you were providing the care.”

“Apparently, I’m in charge of documenting it too.”

Gloria was quiet for a moment. “Is there a box you can check for looking tired?”

Beth glanced at the dark window above the sink. Her hair had come loose from its clip, and a pale crease marked her cheek where she had rested her face against her hand. “No.”

“There should be.”

Beth closed the laptop. “I’m fine.”

Gloria gave her the same look Beth had been giving her for two weeks whenever she said exactly that.

By Friday morning, Beth was not fine. She woke with a fever, a sore throat, and an ache behind her eyes. She sent one message to the family group. “I’m sick. I can’t go to Mom’s today.”

Kevin responded first. “Understood. Which tasks need to be reassigned?”

Beth stared at the message, then she typed: “All of them.” She turned off her phone and went back to sleep.

All of Them

At nine o’clock, Gloria called Kevin. “Do you know where Beth is?”

“She’s sick.”

“I know that. Do you know where my medication list is?”

Kevin opened the spreadsheet. “It says the list is in the kitchen binder.”

“There are three binders.”

“Did you check the one labeled medical?”

“That one contains appliance warranties.”

At ten o’clock, Gloria called again. The physical therapist had moved her appointment earlier. At ten-fifteen, the pharmacy called about a prescription. At ten-thirty, Gloria remembered that her clean sheets were still in the dryer.

Kevin looked at the spreadsheet. According to the spreadsheet, laundry was complete. He called Gloria. “It says the sheets were washed.”

“They were.”

“And dried?”

“Yes.”

“Then what is the problem?”

“They’re still in the dryer.”

Kevin waited.

Gloria waited longer.

“Mom, the spreadsheet says laundry is complete.”

“Then ask the spreadsheet to put the fitted sheet on my bed.”

Kevin drove to Gloria’s house. Amy left home at the same time and arrived shortly after noon.

By then, Kevin had found the medication list inside a grocery bag beneath the telephone, discovered the prescription wasn't ready, and tried to put the fitted sheet on the bed. He had secured three corners. Whenever he pulled the fourth into place, one of the others escaped.

Amy found him standing beside the bed holding a corner of the sheet in each hand. “What are you doing?”

“Laundry.”

“This looks more like hostage negotiation.”

Gloria called from the living room. “The physical therapist needs my medication list.”

“I found it,” Kevin shouted.

“That’s last month’s.”

Kevin looked down at the paper. “Where is this month’s?”

“Beth knows.”

By four o’clock, Amy had called the doctor twice, rescheduled a follow-up appointment, and explained to the insurance company that Gloria Nolan had not received a knee replacement, no matter what their records claimed.

Kevin had picked up the prescription, taken out the trash, washed three dishes, retrieved the mail, and moved a potted violet from the windowsill because Gloria believed it was receiving “discouraging light.”

They had also made lunch. Gloria rejected the first sandwich because Kevin used mustard. She rejected the second because Amy cut it diagonally. “I’m recovering from surgery,” she said. “I haven’t become a different person.”

The Notes Column

By early evening, Kevin and Amy sat at the kitchen table with the spreadsheet open between them. Four tasks had occupied most of their day. None had gone according to the notes.

Amy scrolled through the rows. “Why is Beth’s name in the comments on my insurance task?”

“Because she had Mom’s card.”

“It’s also on your pharmacy task.”

“She was nearby.”

“She wasn’t nearby. She was at work.”

Kevin continued scrolling. Beth’s name appeared in the notes thirty-one times.

Ask Beth for the door code. Beth knows which entrance. Beth has the insurance card. Beth can drop this off. Beth will remind Mom. Beth may need to follow up. Beth can handle if necessary. Even the emergency plan listed Beth as the primary contact. The backup number was Beth’s office.

Kevin leaned back. “We didn’t divide the work.”

Amy looked at the green cells covering the screen. “We divided the credit.”

Gloria had entered the kitchen quietly with her walker. “No,” she said. “You divided the chores. Beth carried the worrying.”

Neither of them answered.

Starting Over

The following evening, after Beth’s fever broke, the siblings held another family meeting. There was no screen sharing.

Kevin apologized first. Amy apologized second. Beth tried to tell them it was all right, but Gloria interrupted her. “It isn’t.”

Beth looked down at her hands. “I know I kept saying yes,” she said. “But nobody ever asked what yes was costing me.”

Kevin closed the laptop. They began again. This time, they did not assign isolated tasks. They assigned whole days.

On Kevin’s days, he handled meals, medication, transportation, phone calls, and whatever unexpected need came up. If the pharmacy rejected a prescription, the physical therapist changed the schedule, or a fitted sheet refused to cooperate, it was his problem to solve.

Amy took every other weekend and several weekday afternoons. She arranged to work remotely from Gloria’s house twice a month. On those days, the phone calls, errands, questions, and things nobody had thought to schedule belonged to her.

They also added scheduled time when Beth wasn't the first call, the backup call, or the person everyone called to locate the thing they couldn't find.

Gloria took back the responsibilities she could safely manage herself. She watered her violets, made her own toast, and insisted on folding towels because, as she explained, “There are still some things a woman should not have to watch her children do badly.”

The revised spreadsheet had fewer colors and no dropdown menus. Kevin removed the TASK OWNER column. Amy added a column for the actual time each responsibility required. Beth deleted the phrase that appeared most often in the notes: “Ask Beth what needs to be done.”

The spreadsheet was no longer beautiful. There were gaps, corrections, and honest estimates. Some cells remained unfinished. Others contained notes such as TOOK TWO HOURS or PHARMACY STILL CONFUSED. For the first time, it showed the work as it really was.

Two weeks later, Gloria stood in front of the printed schedule hanging on her refrigerator. She pointed to a purple block. “What does purple mean?”

“Kevin is responsible that day,” Beth said.

Gloria picked up the kitchen trash and handed it to him. “Good. Purple can take this outside.”