Work Text:
This tool exists to help you easily create custom mute lists via skins until AO3 finishes implementing their native solution. The ao3 site skin generated by this spreadsheet will hide works by the users listed from your search results, filters, etc.
Getting started
First make a copy of the spreadsheet. (The original spreadsheet is read only to prevent chaos.)
Adding a user to the Mute List
To add a user to the block list you need to add their user id number to the column titled "ID" on the "User List" sheet. To make things easier I also added a Username field to help you remember who has the given Id but it isn't a necessary field. You can find a user's id number on a user's profile page or you can use the "Get User ID" sheet.
Using the "Get User Id" Sheet
To get the id number of a user simply paste a link to the user into the column labeled "URL" it doesn't matter if you link the dashboard, profile, works, or some other page. As long as the URL contains "archiveofourown.org/users/USER/" where USER is their username it will work. The sheet will then populate the "Username" and "ID" columns (for a username it selects the first from the list of psueds which can be somewhat arbitrary). You can then copy those fields to the "User List" sheet. Just make sure when you paste you paste values only (under "Paste special") otherwise you might copy the formula by accident.
There are only 10 lines here because the formulas to pull the user id number based on the user URL are relatively expensive, so this sheet is only meant as a staging ground. Once you have the id's you can copy them over to the "User List" and safely delete the URL in the "Get User ID" sheet or replace it with another one.
Adding a work to the Mute List
To add a work to the mute list simply paste a link to the work into the "Fic Link" column of the "Work List" sheet. The sheet will extract the work id for you.
Getting the Skin
Once you have entered items on your user and work list you can then go to the "Script Generation" tab and look at the item under "Full Skin" this will be your muting skin! Just copy it and paste it into the CSS section of a work skin then remove the quotation marks from the start and end. (The quotes are an unfortunate side effect of using a spreadsheet to generate them.)
For more information about using work skins check out the archive's FAQ here.