ABRAM
v1.1.0

Advanced Scheduling, Master Book, and Financials

Welcome to the latest release of the Automated Booking and Resource Allocation Management network. This update introduces comprehensive improvements to our production scheduling engine, a centralized breakdown element tracking system, and powerful spreadsheet-based financial tools.

Here is everything new, improved, and ready to use in this release.

1. Advanced Production Scheduling & Interactive Stripboards

We have rebuilt the production scheduling interface to support a high-density, interactive experience mirroring physical stripboards while adding real-time automation.

  • Classic Stripboard View: A horizontal view mimicking physical production stripboards with color-coded scene strips. Scene parameters—including scene numbers, page counts, estimated shoot times, locations, and cast numbers—are instantly readable at a glance.
    • Exterior Day: Amber color preset.
    • Exterior Night: Emerald color preset.
    • Interior Day: White/zinc color preset.
    • Interior Night: Blue color preset.
  • Focused Day View: A column-based, Kanban-style view that allows production managers to focus on individual shoot days or view multiple days side-by-side.
  • Drag-and-Drop Sequencing: Fully interactive reordering of scenes and schedule items across shoot days with drag-and-drop support.
  • Scheduled Non-Scene Events (Inline Banners): Add company moves, meals, rehearsals, equipment setups, and script readings directly into the shooting timeline with custom durations and descriptions.
  • Interactive Call & Wrap Time Editors: Quickly adjust shoot day details including dates, call times, wrap times, locations, and logistics notes, with automatic timeline updates.
  • Crew Turnaround Violation Alerts: Safety warning flags automatically alert managers if consecutive shoot days violate rest windows (gaps below 12 hours) for booked crew members.

2. AI-Assisted Schedule Optimization

Our scheduling assistant has been upgraded to help automate stripboard sequencing while respecting complex production constraints.

  • Interactive AI Sort Board: Optimize shoot schedules using multiple strategies:
    • Optimize Sequence Only: Reorders scenes for optimal continuity and location grouping within their current days.
    • Distribute into Existing Days: Re-evaluates and balances scenes across the active shoot schedule.
    • Create New Days as Needed: Dynamically generates new shoot days to accommodate scenes while respecting daily working hour constraints.
  • Custom Prompt-Based Preferences: Write free-text prompts to guide the AI optimizer (e.g., "prioritize outdoor scenes first", "keep cast member X's scenes grouped together").
  • Schedule Preview: Inspect a detailed preview of the proposed schedule, including the AI's reasoning, days created, and scenes assigned, before committing changes.

3. Day Out of Days (DOOD) Grid & Overrides

The Day Out of Days (DOOD) view has been expanded to provide granular schedule mapping for all production assets, cast, and crew.

  • Unified Cast, Crew, & Element DOOD: A central grid to track booking statuses (Work, Hold, Drop, Start, Finish, etc.) across the entire shoot schedule.
  • Dynamic Status Calculations: Automatically calculates total work days, hold days, drop days, start/finish indexes, and flags scheduling conflicts.
  • Interactive Override Codes: Override automatically computed statuses for individual days directly from the grid cells (e.g., manually changing a Work day to a Hold day).
  • Customizable Booking Rules: Configure parameters per element/cast member, including day rates, hold permissions, and minimum release gap days (minimum drop/pickup intervals).
  • Multi-Category Filters: Quickly view DOOD grids filtered by Cast, Crew, or specific production categories (Props, Wardrobe, Vehicles, etc.).
  • Dual-Orientation Layouts: Toggle between vertical and horizontal grids for maximum readability.

4. Centralized Master Book of Elements

This release introduces a centralized ledger for breakdown elements, making it easier to manage physical and digital assets.

  • Master Breakdown Inventory: A consolidated view of all production elements (Props, Wardrobe, Vehicles, Locations, Cast, etc.) across the project.
  • Intelligent Usage Mapping: Displays exactly which scenes and which call sheet shoot days/dates each element is linked to.
  • Consolidated Merging Tool: Consolidate duplicate elements or fix typos. It automatically updates all scene and schedule associations from the source element to the target element.

5. Roster ROI & Utilization Analytics

Roster management is now backed by comprehensive financial and capacity analytics, helping organizations track efficiency and costs.

  • Roster ROI Dashboard: Real-time financial analytics dashboard for crew and talent rosters.
  • Headline Financial Metrics: Track key metrics including:
    • Revenue per Head: Average revenue generated per active roster member.
    • Bench Cost: The financial cost of underutilized or unstaffed team members.
    • Gross Margin %: Resource billing margins against baseline labor/talent costs.
    • Rate Efficiency %: Comparison of contracted billing rates against effective operational rates.
  • Roster Member Breakdown Table: Detailed table listing individual crew member utilization rates, hourly cost/billing rates, and gross margin contributions.
  • Advanced Analytics Tabs: Switch between Utilization Trends, Capacity Planning Heatmaps, Project Distribution, Role Utilization, and At-Risk alerts.

6. Configurable Financial Spreadsheets & Multi-Page Budgets

The budgeting system has been upgraded to support massive budgets with spreadsheet-style flexibility.

  • Multi-Page Budgeting: Support for larger budgets by organizing items across multiple sheets or tabs. Create, rename, delete pages, and assign line items to specific pages (with automatic fallback reallocation when pages are deleted).
  • Flexible Grouping & Group Folders: Group financial line items dynamically by Work Package, Category, Custom Metadata Groups, or view as a flat list.
  • Summary Group Folders: Clean header rows for each group displaying aggregated cost (Internal), price (External), and markup totals (color-coded to indicate profit margin health).
  • Centered Budget Settings: Centered configuration panel modal for managing global fringes, custom groups, and Range of Magnitude (ROM) budget parameters (minimum/maximum budget boundaries and confidence ratings).
  • Client View Mode: Replaces the redundant "Team view" preview toggles for non-manager roles, simplifying presentation of project financials to clients.

7. CSV Budget Import Tool

Managers can now ingest external budgets directly into the spreadsheet using an interactive mapping tool.

  • CSV File Uploader: Built-in parser to upload external budget sheets directly.
  • Dynamic Column Mapping: Maps columns from raw CSV files to standard budget database fields (Description, Category, Quantity, Unit, Cost Rate, Price Rate, Group/Tag).
  • Destination Assignment: Route imported items directly into selected Work Packages and Budget Pages.
  • Interactive Data Previewer: Displays mapped rows, checks mapping validity, and flags missing required fields before executing the import.