Log in

No account? Create an account
Automation of casting matrices - Sally's Journal
October 18th, 2009
10:31 pm


Previous Entry Share Next Entry
Automation of casting matrices

(22 comments | Leave a comment)

[User Picture]
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.
Powered by LiveJournal.com