ABCDEFGHIJKLMNOPQRSTUV
1
2
About this documentNew rules
3
This spreadsheet is used by the ACT Task Force to track rules through their lifecycle. It pulls data from different sources, so that is kept up to date automatically. This sheet consists of a Rule Tracker tab, and one or more Survey tabs. Feedback from the ARIA Working Group is available in this GitHub Discussion:
4
https://github.com/w3c/aria/discussions/1850
5
6
The Rule Tracker tab lists all rules currently tracked. New rules must be added manually. Each rule has a status. These include:
7
8
14Update neededAn issue blocks the rule from being a proposed rule.
9
0SurveyingPart of an survey, either in progress or under discussion
10
7Survey ReadyImplemented, and with no open issues
11
2Ready for CFCAgreed on during a call, but requires wider approval from the ACT Task Force
12
2Ready for WGApproved by ACT, ready for AG to review
13
34PublishedThe rule has been published as an approved rule. It must be accepted by AG first.
14
19ProposedThe rule has been copied to the wcag-act-rules github repository
15
8WaitingOn hold for some reason documented in the notes
16
7DeprecatedThis rule is no longer supported
17
18
Surveys
19
The survey tabs are filled out with data from the survey form. The data is filtered from a hidden Survey results tab, using the Rule ID, and Start date.
20
Survey form:
https://forms.gle/3iZypCufqNe3Kko97
21
22
Actions
23
Grant access
Ask Wilco (wilco.fiers@deque.com)
24
Add a new rule
Add the rule ID in the first empty cell of the Rule ID column. The rest of the fields will automatically be populated. New rules should automatically show up under the "New rules" field in this sheet.
25
Open a Survey
1. Duplicate an existing survey
2. Rename the survey tab
3. Fill in the Rule ID
4. Fill in the start date, to avoid
26
Close a survey
If there is more than one survey tab, delete the tab. If there is not, delete the rule ID and Start date.
27
See hidden sheets
Select the sheet from the "All sheets" icon, before the sheet tabs. Remember to hide the tab again when you are done through the context menu of the tab.
28
29
Imported JSON data
30
The rule data in this spread sheet is imported dynamically from a JSON file in the wcag-act-rules GitHub repository. This information is placed in a hidden "Rule Data" tab, which the Rule Tracker tab uses to look up various bits of information. The import uses a custom function, defined in Tools > Script editor. This is accessed through the following raw github URL. If this URL ever needs to change, update the following field:
31
Raw Git URL
https://raw.githubusercontent.com/w3c/wcag-act-rules/master/wcag-mapping.json
32
33
Issue numbers are imported through the GitHub API. This is done by importing the 1000 most recently open issues. A COUNTIF function is then used to see how many issue titles include the rule ID. Issues are stored in the hidden GH Issues tab, and imported from the following URL:
34
GitHub Issues API
https://api.github.com/repos/act-rules/act-rules.github.io/issues?state=open&per_page=100&page=0
35
36
Data Cache / Updates
37
The imported JSON data is cached by the spreadsheet. Cache can be forced to update by editing the import URLs above. Focus on the cell with the URL to the JSON file. Double click it, or press enter to go into edit mode. Then press enter again to exit. This forces the spreadsheet to reload data.
38
39
Survey Sheets
40
Survey sheets are created by filtering data from the hidden Survey results tab. A filter function is used at the top rows of the tab, which filters out up to 9 survey responses that have the same rule ID, and that were submitted after the starting date of the survey.
41
42
Data is filled out using some the MOD function to work out what row to pull the data from. This works because each question has the same number of open rows for answers. row and column references are all linked. Adding rows / columns to the sheet should not effect the functions, provided the same number of rows is used consistently.
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