Create New Spreadsheet Content

Follow the instructions either under update an existing spreadsheet in place or prepare a new spreadsheet to accomplish the indicated goal.

Update an Existing Spreadsheet in Place

You'll need to have run a query at Issuezilla to get the issues you want to include in the spreadsheet. The BugParty page probably contains the query you want; if not, a wide range of queries can be constructed using the BugScheduleMacro or the (undocumented) TempBugHack macro (put the macro instantiation in a page to run it; it can be in a preview page if you don't plan to keep it). If those don't cover it, you can construct a query at Issuezilla the hard way.
On the Issuezilla "Issue list" page that's the result of the query, select the "Format as XML" button.
On the "Format as XML" page, tick the "Download as file" radio button, change the filename if you wish, and select the "Generate XML" button to download the file to your computer.
On your computer, run bin/xmlagenda.py from the SCons distribution. It has one optional parameter, the filename to be converted; the default is issues.xml if no parameter is present. This will create editlist.csv in the current directory.
If you want to keep the CSV file, rename it or it will be overwritten the next time you do this. It needs to end in .csv but otherwise there are no naming restrictions.

Open the spreadsheet to be updated. Make sure you are logged in as a r/w user.
From the "File" menu, select "Upload new version...".
On the pop-up requestor, select "Browse" and choose the CSV file you just created.

Click on the column header for the last (empty) column (usually column H).
From the "Delete" menu, select "Delete column".
Click and sweep out all the remaining column headers (usually A to G).
From the "Format" menu, choose "Plain text".
From the "Align" menu, choose "top".
Click on the column header for the "Pri" column (usually column E).
From the "Align" menu, choose "center" (not "middle").
Click and sweep out the first two column headers.
From the "Align" menu, choose "right".
Select the row header for the first row.
Select "Bold" from the menu bar.
Grab the header marker (just above the "1" for the first row; do NOT grab the bar anywhere else or you will be uploading this spreadsheet again) and move it between the "1" and "2".
Click on any cell (i.e., anywhere so that neither a complete row or column is selected)
The lines between the column headers are selectable; with care you can grab them and change the width of the columns. ID, Votes, and Pri should be as tight as you dare make them; leave a reasonable space for the others and make the last column as wide as you have space.

You'll need to have run a query at Issuezilla to get the issues you want to include in the spreadsheet. The BugParty page probably contains the query you want; if not, a wide range of queries can be constructed using the BugScheduleMacro or the (undocumented) TempBugHack macro (put the macro instantiation in a page to run it; it can be in a preview page if you don't plan to keep it). If those don't cover it, you can construct a query at Issuezilla the hard way.
On the Issuezilla "Issue list" page that's the result of the query, select the "Format as XML" button.
On the "Format as XML" page, tick the "Download as file" radio button, change the filename if you wish, and select the "Generate XML" button to download the file to your computer.
On your computer, run bin/xmlagenda.py from the SCons distribution. It has one optional parameter, the filename to be converted; the default is issues.xml if no parameter is present. This will create editlist.csv in the current directory.
If you want to keep the CSV file, rename it or it will be overwritten the next time you do this. It needs to end in .csv but otherwise there are no naming restrictions.

Go to Google's upload page.
Select "Browse" and choose the CSV file you just created.
Choose a name for the spreadsheet if needed.
Push the "Upload File" button to upload the file and display the new spreadsheet. The read-only URL for this spreadsheet is now in your URL selector box.

Click on the column header for the last (empty) column (usually column H).
From the "Delete" menu, select "Delete column".
Click and sweep out all the remaining column headers (usually A to G).
From the "Format" menu, choose "Plain text".
From the "Align" menu, choose "top".
Click on the column header for the "Pri" column (usually column E).
From the "Align" menu, choose "center" (not "middle").
Click and sweep out the first two column headers.
From the "Align" menu, choose "right".
Select the row header for the first row.
Select "Bold" from the menu bar.
Grab the header marker (just above the "1" for the first row; do NOT grab the bar anywhere else or you will be uploading this spreadsheet again) and move it between the "1" and "2".
Click on any cell (i.e., anywhere so that neither a complete row or column is selected)
The lines between the column headers are selectable; with care you can grab them and change the width of the columns. ID, Votes, and Pri should be as tight as you dare make them; leave a reasonable space for the others and make the last column as wide as you have space.

Push the "Share" tab.
Tick the checkbox beside "Anyone can view this document" and then SIT ON YOUR HANDS until it responds (up to a minute!).
Enter your own Google account in the "Invite people" box and then click the "Invite Collaborators" button.
In the pop-up pane, fill in the message box as you see fit and click the "Send Invitation" button.
In short order, you should receive mail from Google with the read-write link. Publish the read-only and read-write links as you see fit.