Wikipedia:Administrator elections/SecurePoll setup

Wikipedia:Administrator elections/SecurePoll setup

simplify instructions for formatting the results, since there are templates & other automations in place now.

← Previous revision Revision as of 00:54, 23 April 2026
Line 69: Line 69:
*** Format Support / (Support + Oppose) as percent, with 2 decimal points.
*** Format Support / (Support + Oppose) as percent, with 2 decimal points.
*** Add a column for "Result". Anyone whose Support / (Support + Oppose) column is >=70%, and whose Support column is >= 20, is "Elected". Anyone else is "Not elected". Formula is =IF(AND(E2>=0.7,D2>=20),"Elected","Not elected").
*** Add a column for "Result". Anyone whose Support / (Support + Oppose) column is >=70%, and whose Support column is >= 20, is "Elected". Anyone else is "Not elected". Formula is =IF(AND(E2>=0.7,D2>=20),"Elected","Not elected").
*** [[Wikipedia:Administrator recall#Re-request for adminship|Recall candidates have a 55% support threshold]], not 70%. Modify the formula for any recall candidates.
**** [[Wikipedia:Administrator recall#Re-request for adminship|Recall candidates have a 55% support threshold]], not 70%. Modify the formula for any recall candidates.
*** Left align all
*** Left align all.
*** Bold italic underline header row
*** Bold italic underline header row.
*** In cell A1, type "Candidate"
*** In cell A1, type "Candidate".
*** Sort by Support / (Support + Oppose), highest to lowest.
*** Sort by Support / (Support + Oppose), highest to lowest.
*** Change the column order for columns B, C, D to support, abstain, oppose.
*** Change the column order for columns B, C, D to support, abstain, oppose.
** In a sandbox, copy paste from Microsoft Excel into the Visual Editor. Visual Editor will automatically format this as a table for you.
** In a sandbox, copy paste from Microsoft Excel into the Visual Editor. Visual Editor will automatically format this as a table for you.
** Format the wikicode table:
** Format the wikicode table:
*** Replace the top of the table and the heading row with {{TL|Administrator election result header row|May 2026}}.
*** Add sortable to make the columns sortable: {| class="wikitable sortable".
*** Convert each candidate row to use {{TL|Administrator election result candidate row}}.
*** Change all the cells in the first row to start with exclamation marks. This will format them, and make them sortable (example: ! Candidate).
*** Replace the bottom of the table with {{TL|End}}.
*** Highlight rows of elected editors green: |- style="background: #cfc;".
* Post the table onwiki (copy paste from your sandbox to the results page).
*** Wikilink usernames {{AdEResCandRw|Username goes here}}
*** Change heading to Support /
(Support + Oppose)
.
*** Sign
*** Add a section for scrutineers to sign. Use a level 4 heading.
*** Add the sentence "Results are preliminary until all 3 scrutineers sign."
* Post the tally/results onwiki (copy paste from your sandbox to the results page).
* Inform the scrutineers.
* Inform the scrutineers.
* The scrutineers each sign off on the results onwiki (confirming that the tally was copy pasted from SecurePoll accurately by the election clerk). See [[#Instructions for scrutineers]] below.
* The scrutineers each sign off on the results onwiki (confirming that the tally was copy pasted from SecurePoll accurately by the election clerk). See [[#Instructions for scrutineers]] below.