Automatable

A task performed by Producers and Directors

Compile scripts, program notes, and other material related to productions.

R&D OpportunityWorkers want it · AI can't yet

Not yet. Workers want this automated (3.4/5), but experts rate today's AI capability at only 2.33/5, the technology isn't there. It's an R&D Opportunity.

Do you want this task automated?

Worker desire to automate3.4/5

How much the people who do this task want AI to take it over (avg of 5 workers).

AI capability today2.3/5

How capable experts rate current AI at this task (avg of 3 experts).

How much human involvement should stay?

The Human Agency Scale (H1–H5) captures how much human direction workers think this task should keep.

H3Equal human–AI partnership

Why workers want this automated

  • Frees up time for higher-value work80%
  • Helps handle larger scale80%
  • It's repetitive40%
  • Reduces human error40%

How to automate this

Workers want this gone, but today's tools only get part of the way. Automate the edges.

Analyzing & processing data

Let the spreadsheet or a BI tool do the math and the charts.

  1. 1Set up formulas and pivot tables once, so the numbers you need to compile scripts, program notes, and other material related to productions recalculate themselves.
  2. 2Connect a free dashboard so reports refresh themselves (Looker Studio, Power BI).
  3. 3Use AI to summarise the findings, but keep the numbers in the spreadsheet.

Tools that can help

Excel / Google SheetsLooker Studio or Power BIAI assistant

Know a better way, or spot an error?

Share how you automate this in real life, or correct the data. Reviewed before publishing.

This is 1 of 11 tasks studied for Producers and Directors, where workers want 36% of tasks automated.