Automation of casting matrices - Sally's Journal
Automation of casting matrices|
|Date:||October 19th, 2009 04:41 pm (UTC)|| |
[As a side point, go through that list of character names and sort them to make them unique. The play has a cast list already, but it would be good to double check it, and should be fairly easy at this point. Err, except I don't know how you'd do that.]
If I had the data in excel in (for sake of argument column A, starting at cell A1), I'd:
a) sort the character names alphabetically
b) put a formula in B1 of '=A1=A2'
c) copy the formula in B1 all the way down the column.
d) copy and paste values for the column B
e) sort columns A and B alphabetically by the contents of B
The top of column A now contains all the character names come up with.
I followed essentially the same process when setting 'The Importance of Being Earnest' for four actors, except I did the matrix by means of a piece of paper with lines on in when characters spoke. The matrix is probably a better solution, but less visualisable.