When we deal with freelancers, we keep lists. That’s what makes the most sense. But we also need people to sign documents. I’ve seen a lot of people typing someone’s information twice because of that. Not only is this a waste of https://buycbdproducts.com but it also invites typos (we’re all Read more…
This is a short post about a tiny, but useful feature. Naming a range is, simply put, the ability to give a name to one of several cells. This name can then be used instead of the alpha numeric reference to the cell. Named ranges can be used in formulas Read more…
Just like excel spreadsheets can be connected together, Google Sheets offer the option to link data. Except it’s a lot better because you don’t need to open both documents to get a live feed. Uses Importing data serves three main purposes as far as I can see it: It’s a way to Read more…
Along with great tools, communication is what makes the difference between a well executed show and well…a shitshow. There’s either a lack of communication, bad communication, or straight up no communication at all (flashback to me getting hired as a 2nd AD, getting no prep, arriving on set and getting Read more…
Setup What is a cost report, if not a filtered and organized list of items? Generating cost reports is, for some reason, troublesome for many. Every production department is of course backed by one or several production accountants, who’s responsibilities include generating these reports. But in practice, all the information Read more…
it’s a lot easier to spot information with color than with anything else. We all know that red is bad, and green is good! I’m going to show you how conditional formatting can help you and your team in every day documents. Edit: I just finished a video showing you how Read more…
No one likes filing. It’s time consuming and doesn’t add any value to the production. But, we’ve all received that call from a random crew member, 6 months after wrap, inquiring about a check for $42 and 3 peanuts that might not have been cut. And that’s when filing pays Read more…
Wouldn’t it be great if the account coding appeared by itself whenever a position is selected in your crew list? Vlookup is one of excel/google sheet’s most useful formulas. It’s used in many situations, and looks like pure magic if you’re not familiar with it. There are tons of tutorials Read more…
One of the key issues with new media production companies is the sheer amount of unique projects. Each project needs to be recorded somewhere and referenced for each cost impacting it. Based on my experience, here is a good workflow to keep track and make projects accessible: Project initiation Set up an Read more…
Have you ever wanted to have a dropdown menu for the positions in your crew list? Well that’s what we’re doing today! This is extremely useful since it will: Save you time by removing some data entry insure that you always use the same nomenclature, and thus making filtering and Read more…