March 2, 2013

'Casper' Spreadsheet Template Makes Call Sheets and Production Reports Fast, Easy, and Free

Production reports, call sheets, time logs, and schedules are a very necessary aspect of a shoot's organization. On smaller productions with a limited crew, you may be responsible for producing these documents yourself. Thanks to a developer called ThinkCrew, you now have access to a tool that makes creating these production docs that much easier. It's called Casper, and it's a totally free set of templates for Microsoft Office Excel designed for production management. Dynamic scripting under the hood means Casper automates the process for you, filling in relevant data across multiple documents as you input it. Read on to check out Casper, plus some videos breaking down this useful toolset.

Here's the info straight from ThinkCrew regarding Casper:

Introducing Casper!

Casper is an Excel workbook that contains a Call Sheet, Production Report, Exhibit G and Hot Cost Report. All of the documents contained in Casper talk to each other, nearly eliminating the need to retype data that you've already entered. The in-times from the call sheet are automatically applied to the Production Report, which in turn supplies out-time information to the Hot Cost Report. Casper can free you from the prison of your paperwork and allow you to get back to the rest of your job.

You don't need to have any special knowledge of Excel to use Casper. The software is designed to be very easy to understand and comfortable to use. Everything just makes sense in Casper... which comes with an illustrated manual that covers literally every area of the file.

Casper Minimum System Requirements

Microsoft Excel for Mac 2011 if you have a Mac
Microsoft Excel for Windows 2010 if you have a Windows PC
Casper may run in other versions of Excel but it has only been tested in the above versions.

If you have Microsoft Office Excel 2010/11 but you're not convinced Casper suits your needs, check out this brief demo of the workbook below:

We encourage you to give the workbook a go -- it is free, after all -- and let us know about your experiences using it. If you are giving Casper a shot, here's a few more videos from ThinkCrew to get you started:

The next video goes into the workflow by which Casper imports data output from Movie Magic Scheduling:

Moving forward, I hope ThinkCrew will consider implementing Casper in a Google Docs spreadsheet format. Even though Casper is free, MS Office isn't -- and I had a heck of a time trying to find a Windows machine with Office 2010, though this may not be an issue for you. Even putting that experience aside, though, I see cloud read/write access and distribution to be the one feature that would make Casper a monument in efficiency and convenience. This is especially true given the type of organization Casper strives to facilitate. Everyone's got smartphones these days, so there'd be virtually no way any crew member could be out of the loop.

Just to test it, I uploaded the Casper Excel document to Google Drive, hoping its automatic conversion would make this dream a reality instantaneously. No such luck, but folks with experience in scripting for Google Docs (who also have Excel 2010/11) can take a look at Casper and let us know how feasible emulating the system would be elsewhere, particularly on the cloud and Google Docs specifically. ThinkCrew also seems receptive to feedback, so this isn't outside the realm of possibility. Whatever the case, it's admittedly hard to complain when they are offering the templates completely free of charge!

If you think it may be useful for future projects of yours, give ThinkCrew's Casper a try and let us know your thoughts in the comments below!

Links:

Your Comment

14 Comments

How to look professional, serious and organised to your crew and cast 101

March 2, 2013

2
Reply
Tyler

But what about the cameras?

March 2, 2013

1
Reply
Julian

Compatible w/ Apple Numbers?

March 2, 2013

0
Reply
Tim

oh man, im pre producing my first short film at the moment , just finished the script, at THIS IS exactly what i needed, MANY THANKS !

March 3, 2013

0
Reply

What a great find. Do they have a version that will work on Numbers for Mac?

March 3, 2013

1
Reply
Jorge Cayon

ThinkCrew here to answer a few of your questions! First, thanks to everyone for your support -- really makes our day.

Casper was written specifically to take advantage of the tools that exist in Excel 2010/11 because that's the software that most ADs and accountants have been using in the film industry. The syntax that Google Docs and Numbers use differs significantly from what Excel uses, which is why opening Casper in those programs doesn't work.

We have researched Google Docs and Numbers and we are happy to announce that it appears that both of those platforms could accomplish the same things that Excel does, with some hefty rewriting on our part. This is something we may do if we find enough support in the community for it.

Hit us up on Facebook and let us know what you think!

March 3, 2013

1
Reply

Really cool. So aside from the obvious benefit of it being free (assuming you already own Microsoft office) what are the key differences between this and something like Adobe Story?

March 3, 2013

0
Reply

I was just looking for shot list templates and such today...perfect timing!

March 3, 2013

0
Reply
maghoxfr

Sounds like an awesome product! I will be testing it out on 2 shorts that I am the 1st AD on. Email me and I can provide any feedback you might want!

-Keith
keith.wagner.az@gmail
@keithrwagner

March 3, 2013

1
Reply

It would be beyond amazing if ThinkCrew could program this to work with Google Drive

March 3, 2013

-1
Reply
tom

Second that!

March 3, 2013

-2
Reply
avatar
Ryan Koo
Founder
Writer/Director

Third.... and include Dropbox for that matter.

March 5, 2013

1
Reply

This is amazing. Has anyone tested to see if it works with SkyDrive, which is Microsoft's version of GoogleDrive? They also have a webapp, essentially solving what people here are asking about.

March 4, 2013

-2
Reply

lol who uses sky drive

March 6, 2013

1
Reply
Tyler