Using the Repertory Table Spreadsheet

The Repertory Table Spreadsheet

MoEML’s Repertory Table Spreadsheet is a schematic way to create a TEI-compliant and XML-encoded repertory table for playhouses. For an example of a table created by the spreadsheet, see the entry on the Cockpit Theatre. To download the repertory table Excel file, click here.
For an example of the type of repertory table that this spreadsheet creates, see the Blackfriars theatre repertory table.

Using the Table

Step 1 Create a list of plays known (or conjectured) to have been performed at the playhouse you are researching. In addition to resources dealing specifically with your playhouse, check Wiggins1 and DEEP.2
Step 2 For each performance, enter in the DEEP number3 (column P) and the Wiggins number4 (column Q).
Step 3 If the play has multiple authors, record each author’s name in separate columns (columns B, D, F).5 A cell will turn red if there are multiple authors entered.
Step 4 Using MoEML’s A-Z index, find each author’s @xml:id (four letters followed by an integer—eg: SHAK1 for William Shakespeare) and put it in the appropriate cell.6 If the author is not in MoEML’s database, leave the XML:ID section blank.
Step 5 If there is anything exceptional or worth noting about the authorship of the play, write a short explanatory note in the NOTES ON AUTHOR(S)? column. Please use full sentences as these comments are rendered as clickable footnotes on the website.
Step 6 Enter the dates of the play’s performance.7
Step 7 If the play has multiple separate performances (eg: 1598, 1602, and 1604) enter each separate date into each respective column; however, if the dates of performance are given as a range (eg: 1598-1604) then enter in the older date in the FROM column and the other in the TO column.
Step 8 If there is anything extraordinary about the dates, enter notes in the NOTES ON PERFORMANCE DATE(S)? cell. Questions of certainty (for instance, if your source puts a ? after the date) or issues around using something other than your main source to date the play (for instance, using DEEP when Gurr does not list the date) would both merit a comment. Again, please use full sentences.
Step 9 Enter the date of the play’s production in DATE: PRODUCTION. If there is anything noteworthy about this date, enter a comment in the NOTES ON PRODUCTION DATE? column.
Step 10 If there is anything you would like the MoEML encoder (not specifically the reader) to know, leave a comment in the COMMENTS FOR MOEML ENCODER column.


  1. The four published volumes of Wiggins’ British Drama cover 1533-1602. Forthcoming volumes will cover the rest of the period up to 1642. For plays after 1602, check the following reference works, readily available in most university libraries: Chambers; Greg; Bentley; and Harbage, Schoenbaum, and Wagonheim. As forthcoming volumes of British Drama are published, we will update the repertory table. (JT)
  2. Note that DEEP records Playbook Attribution and does not constitute an authorative list of all performances that could have occured at a particular playhouse. To generate a list of the plays in DEEP that are associated with your playhouse, click Basic Search, select Search For: Theatre (Playbook Attribution), and then click on your class’ assigned theatre. Copy and paste these results into the spreadsheet; please follow the order given on the spreadsheet. (JT)
  3. To find the DEEP number, press Expand All in the right-hand corner of your search results. Each play’s DEEP number is located under Reference Information on the left-hand corner. (JT)
  4. Wiggins numbers are found on the left-hand side of each play’s entry in British Drama. If your library does not shelve British Drama and it is unavailable through interlibrary loan or if the published volumes do not yet cover the necessary dates, leave this section blank. (JT)
  5. It does not matter if you format the names last-name, first-name or first-name last-name as long as it is consistent. (JT)
  6. The fastest way to do this is CTRL-F on Windows or Linux or CMD-F on Mac. (JT)
  7. We prefer the use of Wiggins’ British Drama. If the published volumes of British Drama have not yet covered the date of your play, use Andrew Gurr’s The Shakespearean Stage, 1574-1642 (any edition, but the 4th is the most recent). If that is not available, you are welcome to use any other reputable source. See MoEML’s list of research resources. Please include a comment in the comments on date section if you use a different source. If all of the performance dates come from the same source, you need only declare it once. If your library does not shelf British Drama and it is unavailable through interlibrary loan, leave this section blank. (JT)


Cite this page

MLA citation

Takeda, Joey, and Janelle Jenstad. Using the Repertory Table Spreadsheet. The Map of Early Modern London, Edition 7.0, edited by Janelle Jenstad, U of Victoria, 05 May 2022,

Chicago citation

Takeda, Joey, and Janelle Jenstad. Using the Repertory Table Spreadsheet. The Map of Early Modern London, Edition 7.0. Ed. Janelle Jenstad. Victoria: University of Victoria. Accessed May 05, 2022.

APA citation

Takeda, J., & Jenstad, J. 2022. Using the Repertory Table Spreadsheet. In J. Jenstad (Ed), The Map of Early Modern London (Edition 7.0). Victoria: University of Victoria. Retrieved from

RIS file (for RefMan, RefWorks, EndNote etc.)

Provider: University of Victoria
Database: The Map of Early Modern London
Content: text/plain; charset="utf-8"

A1  - Takeda, Joey
A1  - Jenstad, Janelle
ED  - Jenstad, Janelle
T1  - Using the Repertory Table Spreadsheet
T2  - The Map of Early Modern London
ET  - 7.0
PY  - 2022
DA  - 2022/05/05
CY  - Victoria
PB  - University of Victoria
LA  - English
UR  -
UR  -
ER  - 

TEI citation

<bibl type="mla"><author><name ref="#TAKE1"><surname>Takeda</surname>, <forename>Joey</forename></name></author>, and <author><name ref="#JENS1"><forename>Janelle</forename> <surname>Jenstad</surname></name></author>. <title level="a">Using the Repertory Table Spreadsheet</title>. <title level="m">The Map of Early Modern London</title>, Edition <edition>7.0</edition>, edited by <editor><name ref="#JENS1"><forename>Janelle</forename> <surname>Jenstad</surname></name></editor>, <publisher>U of Victoria</publisher>, <date when="2022-05-05">05 May 2022</date>, <ref target=""></ref>.</bibl>