News & Filesharing: Tracking templates
First, some new-news:
There's a great story in Sunday's News & Observer on the progress out at The Lost Colony on rebuilding their costume shop, which was lost to a tragic fire on September 11th of this year. I particularly liked reading about how folks at HBO and in the NC film industry have pitched in with donating production surplus on period projects that have wrapped.
And! It occurred to me that it might be useful to share some of the spreadsheet and form templates i use for labor tracking in my subdepartment with you guys. So, i've created an account on Filecrunch.com (a free hosting service) with some of my frequently-used templates. Here are the first three i've uploaded for open-source sharing.
1.) Download mixing ticket.doc
This is my dye project record form (Word document filetype). Anyone who dyes anything for a mainstage show (me or one of my assistants) fills out this form, attaches swatches, and puts it into the master notebook (or "Crafts Bible"). That way if anyone else needs to reference what was done and how, it's right there on record. It is based on a form used by the Utah Shakespearean Festival in their dyeshop; they have some different categories at the top of theirs for tracking projects (since they have six shows in their shop simultaneously, thus making it more difficult to track what fabric goes to what draper for what show by what deadline). You can add or eliminate whatever entries you need, or devise your own completely different template.
2.) Download hat and mask measurements.xls
This is an Excel spreadsheet i generated for a comprehensive measurement sheet covering both hat-related measurements and facial-feature measurements. This way i was able to make matrices without face casts for masks *&* hat mockups from one measurement sheet.
3.) Download TLP mask tracking spreadsheet.xls
This is another Excel spreadsheet that i made for The Little Prince which tracks the steps of the mask-making process. I left some of the information in it so you can see how anyone could check at a glance on the progress made on any mask.
Feel free to take these templates, adapt them to your own uses for your own record-keeping and project-tracking!
There's a great story in Sunday's News & Observer on the progress out at The Lost Colony on rebuilding their costume shop, which was lost to a tragic fire on September 11th of this year. I particularly liked reading about how folks at HBO and in the NC film industry have pitched in with donating production surplus on period projects that have wrapped.
And! It occurred to me that it might be useful to share some of the spreadsheet and form templates i use for labor tracking in my subdepartment with you guys. So, i've created an account on Filecrunch.com (a free hosting service) with some of my frequently-used templates. Here are the first three i've uploaded for open-source sharing.
1.) Download mixing ticket.doc
This is my dye project record form (Word document filetype). Anyone who dyes anything for a mainstage show (me or one of my assistants) fills out this form, attaches swatches, and puts it into the master notebook (or "Crafts Bible"). That way if anyone else needs to reference what was done and how, it's right there on record. It is based on a form used by the Utah Shakespearean Festival in their dyeshop; they have some different categories at the top of theirs for tracking projects (since they have six shows in their shop simultaneously, thus making it more difficult to track what fabric goes to what draper for what show by what deadline). You can add or eliminate whatever entries you need, or devise your own completely different template.
2.) Download hat and mask measurements.xls
This is an Excel spreadsheet i generated for a comprehensive measurement sheet covering both hat-related measurements and facial-feature measurements. This way i was able to make matrices without face casts for masks *&* hat mockups from one measurement sheet.
3.) Download TLP mask tracking spreadsheet.xls
This is another Excel spreadsheet that i made for The Little Prince which tracks the steps of the mask-making process. I left some of the information in it so you can see how anyone could check at a glance on the progress made on any mask.
Feel free to take these templates, adapt them to your own uses for your own record-keeping and project-tracking!