ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Priorities for Treatment – Data Collection (CANS)
2
PurposeCollect “Priorities for Treatment” fields with drop-downs, date validation, and automated checks to reduce entry errors.
3
4
Steps
5
1.Open the tab that matches the assessment you are entering (CANS 0–5 or CANS 6–20).
6
2.Complete all required (*) fields. CANS Completion Date and Priorities for Treatment Completion Date must be a valid date; Status and the “Number of … Prioritized” fields are drop-downs.
7
3.Enter at least 2 (up to 5) Needs and Strengths. Each selected Need and Strength requires a Rating.
8
4.Review “Completeness Checks” at the bottom of the data collection sheet: counts should match the numbers you selected.
9
5.Red cells indicate missing required information, duplicates, or mismatched counts.
10
6.Name the Excel file using this naming convention: CANS_Year_Month_Department_Episode type. For example: CANS_2026_January_BHS CBO CARELINK EDGEWOOD CHILDREN'S OUTPATIENT_Edgewood CYF MH Outpatient
11
7.Quality Management is waiting on an IT solution for submitting the completed Excel files. While we wait, please submit the completed excel files by emailing them SECURELY to Petra Jerman from Quality Management at petra.jerman@sfdph.org. We will update the submission instructions once we have an IT solution. Please submit the January 12-31,2026 data no later than February 7, 2026.
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100