Class or Training Schedule Planner
Coordinate sessions, rooms, and instructors.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Create a workbook to schedule classes or training sessions without conflicts. Organization: [ORGANIZATION]. Sessions or courses: [SESSIONS]. Instructors and their availability: [INSTRUCTORS]. Rooms or online platforms: [RESOURCES]. Participant limits and enrolment: [CAPACITY]. Spreadsheet app: [SPREADSHEET_APP]. Return: 1. Sheet design: Sessions | Instructors | Rooms | Participants | Timetable | Conflicts | Waitlist | Changes. 2. Sessions table columns: ID | Course | Date | Start | End | Instructor | Room | Capacity | Enrolled | Status. 3. Formulas (for my app): detect instructor double booking, room double booking (overlap logic: the start of one is before the end of another and the end is after the start), enrolled greater than capacity, and instructor availability outside their stated hours. 4. Timetable view: weekly grid pulling sessions with a lookup formula; a participant schedule view filtered by name. 5. Waitlist logic: order by sign-up time and a formula to show who is next when a seat opens. 6. Change log and message templates for rescheduling: audience, what changed, what to do next. 7. Sample data with one deliberate conflict and the expected flags to test the formulas. 8. A weekly maintenance checklist and permissions advice (who can edit what). Include notes on protecting participant data.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.