Which spreadsheet for which need
run.events has three spreadsheets, each for a different need:
| You need | Use |
|---|---|
| Every speaker and chair, with each time they appear, their room and their e-mail address | Programme by persons |
| Every abstract with its number, day, time, room and session block | Publisher export, sheet Abstracts |
| A list of sessions with their status and answers, without times | Export on the Sessions page |
No spreadsheet holds the whole agenda as it stands, with breaks and placeholders as rows. For that, use the PDF or Word programme.
Every person with their times: Programme by persons
- Publish the agenda, if you have not yet.
- Open Publications, choose Add new, then Programme by persons.
- Decide now whether you need the e-mail addresses: tick E-mail addresses. This cannot be added after the publication is saved.
- If your event asks speakers further questions, add them as columns with Speakers' custom fields.
- Limit the Scope to days or rooms, if you like.
- Save, then choose Generate.
The Excel file has one row per person and slot, with the role, the session, the session block, the day, the start, the end, the room, the confirmation, the registration, the materials and the availability. Chairs of session blocks have rows of their own.
Good to know: the speaker profile has no phone number. If the venue or the technicians need phone numbers, ask speakers for them in a custom question, and add it with Speakers' custom fields.
Every abstract with its slot: Publisher export
The Publisher export writes an Excel file whose sheet Abstracts has one row per session, with the number, the title, the presentation type, the start, the end, the room, the session block, the block's chairs and the labels. Further sheets hold the authors, the affiliations and the materials. See How do I export the abstracts for a journal supplement, with DOIs?.
It lists only the sessions the Book of Abstracts would print: accepted, with a confirmed person, and not hidden on the Print channel.
A quick list of sessions: Export on the Sessions page
On Sessions, Export downloads the sessions in the list as Excel, with their status and the answers to your questions. It has no rooms or times. Use it during the call and the review, before there is a programme.
Related articles