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;". |
|||
| ⚫ | |||
*** Wikilink usernames |
|||
*** Change heading to . |
|||
*** Sign |
|||
*** Add a section for scrutineers to sign. Use a level 4 heading. |
|||
*** Add the sentence "Results are preliminary until all 3 scrutineers sign." |
|||
| ⚫ | |||
* 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. |
||