HCMC Speech Pathology,
Post PTSD Treament Program
Part of the PTSD treatment included speech pathology. I was assigned to Abby Sorenson. My understanding is that patients with PTSD benefit from skills such as creating To-Do lists and other things speech pathologists are trained in.
We’ve met several times. I realize I’m not a typical patient, as when she suggested a 2Do list, as I refer to them, she was unaware of my carefully crafted 2Do lists for each of my projects. I use Excel worksheets with a combination of symbols and titles for each column. The symbols help as visual is easier for me. to follow.
Link: https://prod.hennepinhealthcare.org/sites/default/files/news/Forster-Abby.jpg
Sample of My 2Do Excel Sheets:
Project Name: 2Dos
Vision: ◔⁀◔ Website that viewers love and learn about how to help vulnerable adults dealing with complex disabilities.
Emoji + Symbol above each Column Title.
Columns: Task Id, Project Milestone. Tasks to Accoumplish the Milestonee,
ID Format = T for Task + Project Initial(s) + 0000;
📖 ✍️Dropdown:❗Critical, 🔴 High, 🟠 Concerning, 🔹 Low (Visual Only), 🔴 (Bulletproof), Could be ⚠ (Visual Only)Dropdown: Emergency ⛑️, Critical ❗, Moderate 🟡, Low 🟢Dropdown: Not Started ◯, In Progress ⇄, On Hold ❚❚, Concerned ⚆, Waiting on Others ⏳, Completed ✪, Deferred ➤, Canceled ⊠Dropdown + Conditional Formatting Rules for Progress Bar Colors (Select Dropdown Judgement Call Option) 0%, 20%, 40%, 60%, 80%, or 100% Dropdown: High Concern !!!, Moderate Concern !!, Low Concern !, No Concern, - UnassessedFormat: d:hh:mm Days, Hours, MinutesFormat: 1) Select column or cells 2) Go to: Home → Format → Format Cells (or press Cmd + 1), 3) Choose: Number tab → Custom, 4) in Type field, paste: YYYY"_"MMDDConditional Formatting: Rule to Turn Red for Past Target Date, # of Day Left (Formula: =IF(P8="✪ Circled White Star U+272A Not Completed", IF(ISNUMBER(N8), IF(N8<TODAY(), "⚠️ Past Due", N8-TODAY() & " days left"), ""), "") then Ignore Error if that appears as indicator; Dropdown + Conditional Formatting Rules - Green for Completed: 👍 Completed, 👎 Not Completed; Lock Closed 🔒 (Not Bulletproof)Date Format: 1900.01.11 -- SEE Note in 2Dos Dropdowns WkshetDropdown: YesDependencies; NoDependenciesComplete These Task IDs (e.g., "TA003") Before This TaskDropdown: No, Y-Daily, Y-Weekly, Y-MonthlyDropdown: 🟢 ⊢ No; ⊢ Yes - Known, Need to Decide; 🔍 Yes-Unclear, Need Info; ◯ Unknown; √ Decision MadeDropdown: 🔍 Research More Info; 👥 Consult Someone; ∴ Have Info / Need to Decide; 🟢 No ConsiderationsWhat or Who is Preventing ProgressFormat 'Currency': Dollar AmountDropdown: Yes/NoFormula: Actual minus Estimated; Format'Currency'; Conditional Formatting: Positive = Red, At of Minus-GreenFormat: 'Currency': Formula & Conditional Formatting: Green = At-Under Budget, Red= OverSelf, Attorney, Contractor, TRM, Others☏ Phone 🌐 Web Search 📍Location 👤 Visual Only SEE ⦿⦿ Apple Contacts App: [Contact Name], ⦿⦿ 📄 SEE (List Specific Doc Name - Section)Row 5of6 Safe Symbol(18 pt, Bold, Centered)✦▲⊞▤⊟※➣⊢⬢◈⬟◐◥! ⧖⊥\√ ⊣?⊣⇶⇄⥀ ↻◈∴ ⬛~$$!$±$👥 Row 6of6 Column Label - 11 pt, Bold, Center: Col 1 = Project ID (To allow formulas to access multiple project worksheets), Col 2 is Task IDTask ID TagProject MilestoneTasks (Actionable Steps to Each Milestone)Task TypeNotesTask Specific Files(Hyperlink If Possible)Date Added (May Not Be Start)AuthorPriorityRisk LevelStatusProgressConcern LevelEst. Time to CompleteTarget DateStrict Deadline? Days Left?Completed?Date CompletedDependencies?List DependenciesRecurring?Decision Required?Considerations?BlockersEstimated CostCost Concerns?Actual CostBudget VarianceWho's InvolvedInfo Resources