Jeremy has provided a crosswalk from a refined spreadsheet.  In order to get everything into Apollo the following is needed:

• the information from the one column that was lost (duration)
• URLs for PDF files
• URLs for PDF thumbnails
• URLs for PDF transcriptions
• URLs for video files (webm)
• URLs for streaming videos
• URLs for video poster images
• URLs for video thumbnail images

Currently this content resides in a web server (webm files), a streaming server (streaming urls) and fedora 3 (everything else).

Apollo will be the system that captures the relationships between all of these pieces, so it may not be necessary to capture those relationships elsewhere.