dude i filled in my name and email and press access so many times but you shortlist generator is no coming to my email. so I think your link on your website might be broken - just saying
@@MrNoplotproductions @MrNoplotproductions Hi, I'm seeing you have received all of my emails, have you checked your spam folder? If you're still not seeing them, I'll send the link separately. I appreciate you letting me know.
@@itsgeorgevk thank you i received under George vk - have been looking for "filmmaking secrets" as the website I was directed to - I appreciate you man. respect to the max / blessings from Namibia
Although it's been 2011 since this tut was posted, "The Best Shotlist Template" by George Kotelnikov still holds the heavy weight belt and title for the ultimate explanation of a shot list. In my opinion. No I haven't reviewed other shotlist tuts because this is all I need. Thanks G, for this upload as a indie filmmaker this is what I've been using to this day and I also pass this link to my filmmaking friends and producers.
You just made my whole day, ATLDemoReels. I really appreciate it. These are the exact words that push me to continue creating and sharing as much of my knowledge and mistakes as I can. All the best, George V.K.
@@itsgeorgevk thanks I appreciate that George. Trying to figure out how to do another scene because there's multiple scenes that I need to do. And I want to test this out on a real life shoot. After that I'll have to tell you what it's like how it works
@@whothetechknows That’s great. You can either copy and paste the rows of the first scene, or a better way is to duplicate the whole SHEET and do separate scenes in separate sheet tabs. Check out the other shot list video on my channel where I show exactly how to achieve this.
You can either duplicate one of the sheets all together. Or select all the rows (on the left side) that contain a scene, copy and paste below. Boom, another scene created. Hope that helps.
This is incredible Work. You have immediately become my friend in 13 minutes and 18 seconds. Wanton Soup is a great food thought... also great shot list, all other ones that I have seen are soo lacking. Hats off or since I am only one, hat off to ya.
George this is wonderful. I was looking for a good shotlist template online but no fortune until I found this one! This one is indeed the best online and is going to be great for my project.Thank you so much for sharing! =)
This is the ultimate treasure map for indie filmmakers. Thanks for the detailed information and link George. Hay I thought they stopped making Hostess Twinkies in the mid 90's. But....I do know Little Debbie went up on the price from $0.25 to $0.50??!!!! Anyway George you are a DY-NO-MITE Dude!!!!!!!!!! May you have more successful productions.
George, been searching around for a long time for this. I will be shooting my first short film soon and this comes to a great help. It's called The Passage. You might look it up when thing are public. Best Wishes. Thanks
Hey, Thanks for that! I'm looking for a good brief definition of the term shot-list to add to my course, can't find a thing on wikipedia yet.. I thought you might be helpful with that..
Thanks for sharing this with me George, I love it. It's super handy. The only thing I can't figure out is the formula in the shoot time. even if I replicate it. Can you help with that??
Hi, I'm a 1st year BA HONS filmmaker undergraduate at Lancaster University and Blackpool school of arts. One suggestion for you when formulating your minutes (in O13) into hours and minutes at (P13), at the moment your formula in the total time for scene does not format to hours and minutes (hh:mm), if you want to do this, use this formula, this will convert properly into HH:MM . So the formula in P13 would be =TIME(0,O13,0) That's 0 hours, the number of minutes in N13, and 0 seconds. To format the cell as the time format you want (HH:MM). Right-click on the O13 cell, select "format cells" from the drop-down list, select "custom" (in the categories list) scroll up or down in the list to find the hh:mm, left click, then press OK. For example, add minutes into any of the boxes in "set up time (M5 to M12)" to a total of 179 minutes and it produces an output of 02:59. 2 hours 59 minutes. You're welcome, great spreadsheet by the way, I'm using it on my Preparing to Film assignment.
im goin to work as an assistant director in a new movie in india & i was looking for a proper info about shot listing & i just saw this video & this is the best what i got thank u for uploading 👍
This is so helpful, thanks for doing this. I had one question, I noticed there was no field for audio track number. How do you typically keep track of which audio file goes with which take?
Before you do the clap, you announce the shot and scene name and take number and then clap / use the clapperboard. For example: "Sound rolling, shot 7 b, take 2, character name OTS shot, camera rolling, action!" And then you clap and the actors start the scene
Great tool and explanation. What I'm missing for my kind of work is a simple "sound section". Some columns on the audio needed in a particular shot. Handy for one-man-band operation.
Ashish mahobia Search "Film Riot" on TH-cam. Really fun podcast. Otherwise it's all about knowing what you want to learn and doing a simple search. That's how I do it. Best of luck!
Hey George, How did you get each section to represent the colour of the type of camera used at each point if in fact that was what the colours represented ??
Hi, George! I'm not very experienced with spreadsheet software, but I understand the basics of how to use your spreadsheet. It is very helpful, thank you! QUESTION: I see that you have multiple scenes on your example in the video, but the template you have provided only includes a few lines and one scene. How do I add more lines/scenes (and still keep the formatting/calculations)? Thanks again! Jesse
How can you edit the equipment so that typing in said equipment will result in a color change in the cell? For example, if I wanted to change "JIB" to "steadicam" on the top, typing "JIB" in the equipment column still makes the column turn pink.
That's a bit of a convoluted process. If you google "conditional formatting" within Google Sheets, you should find some information on how to do that. Good luck!
George, this was so helpful! Can't thank you enough :) Do you have any other videos on pre-production, or anything of this kind of nature, as I'd love to see how you planned an entire project, as Ideal World looks H-AMAZING!! :D
HI George, I have a school project video and it really helpful for me when found your tut online for a shot list template. My question is for "coverage" tab I dont clearly underdant what is used for? Hope u can have some time to explain what it means to me. Really helpful and informative. Thank so much for your dedication.
George Kotelnikov Thank you so much for the information. I was telling by my professor to prepare a shot list before writing a storyboard. As an experienced producer, would you give us some advice as what we could do before making a movie. I love playing around with camera but very limited about procedure how to make a movie. Organizing before shooting is really important as I devote my time to work on this project.
Hey Brad, good to hear you liked the template! You can either duplicate the sheet, or just select the scene header row and copy/paste it below. Hope that helps!
Good job on the shot list George. I'm also working with a very detailed pre-pro. But my major problem is: I as a director understand this shot list. But when it comes to my 1st ADs, who should understand it too, it is very hard to find ADs that are used to that kind of detail. How are you managing it when you work with different ADs?
I suppose you just pointed out one of the struggles of the film industry. Working with new people is always hard because you don't have the same decorum and common language as with someone that you would usually work with. It's important to hold production meetings prior to shooting so that everyone can get on the same page. Go over every detail of the shotlist with your AD to the point that they are reading your mind. Their job is to know the shotlist better than you, so keep that in mind. Best of luck!
Hey George, Thanks. Well of course I'm holding a lot of PPMs with my ADs and HoDs. But that doesn't always solve the problem of the missing know how of my ADs that I'm getting. (especially if you are shooting a commercial and the production company gives you an AD of their choice) - So most of the time, the know how of my DP and my vision are on a higher level then the know how of ADs. So knowing the shotlist better than me, is in fact not so easy for them, as they simply don't get it if it's a complex sequence shot with a tech crane or something similar. And especially these setups cost a lot of time if a 1st AD is coordinating these things wrong. Maybe it's good to know for you: My Irish film company is working on several setups & concepts to bring HoDs closer together and to speed up communication and working processes in Pre-pro and on set. Seems you are working in the same field?
Okay I am working on my Shot List.. When doing lets say a 10 second duration shot. Would it be considered a 0.1 or is it divided by 60 seconds or by 100 seconds. Thanks much.
It's in decimal form so yeah, you would divide by 60 (seconds). Thus, 10 second duration would be roughly 0.16 but honestly - I wouldn't get boggled down in the details. Just estimate relative to 100% being 1 minute (or one page of script). Half a page = .5; quarter of a page is .25, any shots that are shorter - .1 or .2 would be sufficient. Remember these are just estimates. Good luck!
This is fantastic. one question though: for a 2 camera back and forth dialogue scene, would you count each camera as a different row, or have one row for both cameras filming both actors do a dialogue?
+Sergio Uzurin Great question. I suppose either way works as long as it makes sense to you. Personally, I would probably keep both cameras on their own row, and just merge the cells in the CAMERA column to indicate that these two cameras are A and B, filming different characters/subjects simultaneously.
I'm starting to work with this template. Thanks so much for doing it! Can you explain how you came up with your shoot times in the O column? I don't understand the formula you used, and the resulting number seems too high. But of course, I'm a first time director, so I'm probably under-estimating the amount of time it will take.
It's simply an estimation of the predicted number of takes for any given shot, times the length of each take, with an added 5 minutes in between each take for any adjustments needed. Tack on the setup time for the shot and you have a total estimated time that particular shot will take. Rinse, repeat!
Hi George. Thanks for this! One question. You said the third number in the shot # is "the actual shot number". What do you mean by that? After you have a different SET in that scene, I don't understand what that third number is for. Maybe can you write an example. Thank you again, Tomer
Hi Georges, thank you for sharing this with us all, definitely the best thing out there! I downloaded en excel version of it, but the formula to give the shoot time doesn't work anymore. Can you let me know what it is, I can add it myself manually. Thanks in advance
Great breakdown! Are your servers still up by any chance? I tried to get a copy sent to me but I haven't been emailed it yet and it has been a few hours.
You are so awesome for notifying me. I had the workflow paused because I'm working on some exciting stuff and I guess I got trigger happy. It has resumed and you should now see it in your inbox! Thanks again.
For the script time, setup time and predic # of takes, do I add up my own numbers to get the shoot time or is there an algorithm already plugged into the template to do that for me? Just curious how you got 54 for your shoot time on your first shot? Thank you and awesome video! Really helps me out!
Hey Stefan, You may have to just copy the equation down by dragging the little dot (on the bottom right corner of the selected cell) on the cell that has the equation down. Otherwise, you can also simply copy & paste. Hope that helps!
Thanks for this! How do I add another location to your template? I am trying to cut and paste all the cells but it's not working. I am not very savvy with Google docs.
I personally almost never keep track of which audio goes with which take because I just throw it all into a timeline and let PluralEyes do the work for me. (I have some videos on that as well). But you can easily right add a separate column for the Audio notes. :)
Another question: When I use the template and indicate the equipment used, it doesn't change the color of the whole row, but just the one 'equipment' cell. Is there a way to fix this?
You may have to dig into some Google Sheets tutorials on 'conditional formatting' - I'm not quite sure how to apply that change to the whole row - although that's a great idea. I may have to implement this into the next version. Thanks!
I'm having a problem with this as well. tried what you suggested, and it didn't work. When I add a new scene under the previous, the calculations don't work. Any ideas?
Grab your FREE Shot List Template here: georgevk.com/shotlist 🚀
dude i filled in my name and email and press access so many times but you shortlist generator is no coming to my email. so I think your link on your website might be broken - just saying
sorry i only see now - 12 years ago was this post - understand
@@MrNoplotproductions @MrNoplotproductions Hi, I'm seeing you have received all of my emails, have you checked your spam folder? If you're still not seeing them, I'll send the link separately. I appreciate you letting me know.
@@itsgeorgevk thank you i received under George vk - have been looking for "filmmaking secrets" as the website I was directed to - I appreciate you man. respect to the max / blessings from Namibia
@@itsgeorgevk thank you i received it I was looking for filmmakers secret and not George vk . appreciate you. respect from the Namib desert
Thanks man. You are one of those valuable persons that makes internet better.
You, sir, deserve a medal. Thank you for this.
Glad I was useful. :)
Although it's been 2011 since this tut was posted, "The Best Shotlist Template" by George Kotelnikov still holds the heavy weight belt and title for the ultimate explanation of a shot list. In my opinion. No I haven't reviewed other shotlist tuts because this is all I need. Thanks G, for this upload as a indie filmmaker this is what I've been using to this day and I also pass this link to my filmmaking friends and producers.
You just made my whole day, ATLDemoReels. I really appreciate it. These are the exact words that push me to continue creating and sharing as much of my knowledge and mistakes as I can.
All the best,
George V.K.
This shot list is a life saver. Thank you! Your video is great and I hope that your project turned out well.
Thanks Russell! Means a lot. Glad it could be of use. 👍🏼 Let me know if I can ever help with anything.
@@itsgeorgevk thanks I appreciate that George. Trying to figure out how to do another scene because there's multiple scenes that I need to do. And I want to test this out on a real life shoot. After that I'll have to tell you what it's like how it works
@@whothetechknows That’s great. You can either copy and paste the rows of the first scene, or a better way is to duplicate the whole SHEET and do separate scenes in separate sheet tabs. Check out the other shot list video on my channel where I show exactly how to achieve this.
Here is that video: th-cam.com/video/A0oRipiU04g/w-d-xo.html
Thank you for the template my friend. There are very few people who take initiative when it comes to helping out indie filmmakers
There's just one thing im having a problem with is the inserting of more scenes
Glad I could be of use! Good luck.
You can either duplicate one of the sheets all together. Or select all the rows (on the left side) that contain a scene, copy and paste below. Boom, another scene created. Hope that helps.
George V.K. it does. thanks 😃
This is incredible Work. You have immediately become my friend in 13 minutes and 18 seconds. Wanton Soup is a great food thought... also great shot list, all other ones that I have seen are soo lacking. Hats off or since I am only one, hat off to ya.
Appreciate the kind words. You're the best!
I rarely comment on vids, but this video was really awesome! Thanks George!
aimhassani I appreciate it!
Thanks a lot, George. You really made the whole process really simple and easy. Thanks for sharing the Spreadsheet as well.
You are so welcome. Glad I could help. :)
This WAS great! Helped me make things run smoother!
This is the format I will use from here on. Production absolutely loved the organization of my shotlist. Cheers friend.
Glad I could help. It's been 7 years! :)
Thats a great service to humanity. Keep it up pal :)
Glad I could help out!
Love it! How do you add more rows to a single scene?
George this is wonderful. I was looking for a good shotlist template online but no fortune until I found this one! This one is indeed the best online and is going to be great for my project.Thank you so much for sharing! =)
so surprised that more people havent been here and seen this, thank you.
I used this earlier this year, great way to stay organized.
That’s fantastic! Glad it was helpful.
This is great man. First rate! Thanks for sharing!
I appreciate you! I know it's been 8 years but I just updated the shot list template. Check out the newest video on my channel. Hope it helps. :)
Very Cool and funny! Thanx man...Starting out with Imagefilm and this is a biiiig help! Greez from Lübeck, Germany
I’m glad I could help in some small way, Ronnie!
Thnx! Really needed this!
Thank you so much for the break down!
This is the ultimate treasure map for indie filmmakers. Thanks for the detailed information and link George. Hay I thought they stopped making Hostess Twinkies in the mid 90's. But....I do know Little Debbie went up on the price from $0.25 to $0.50??!!!!
Anyway George you are a DY-NO-MITE Dude!!!!!!!!!! May you have more successful productions.
Thank you very much for that my man, you saved my six 💗
@@m_som You are so welcome brother. 🙏🏼 Glad this could help even over 13 years later.
George, been searching around for a long time for this. I will be shooting my first short film soon and this comes to a great help. It's called The Passage. You might look it up when thing are public. Best Wishes. Thanks
This is GOLD, Thank you for your time George!!
Glad I could help!
Hey, Thanks for that!
I'm looking for a good brief definition of the term shot-list to add to my course, can't find a thing on wikipedia yet.. I thought you might be helpful with that..
Very nice work, George!
This is an incredible resource! Very clear and concise instruction AND comprehensive template! Thanks George! How's the film doing?
Thanks for the kind words, brother!
Thank you George this has been a great help in starting my pre-production for my feature film project. I think you sound great.
@@zahiddar8178 Let me know how that feature film project turned out! 8 years ago. 😅
Thank you! You guys rock.
I appreciate you. :)
Thanks for sharing this with me George, I love it. It's super handy. The only thing I can't figure out is the formula in the shoot time. even if I replicate it. Can you help with that??
Hi, I'm a 1st year BA HONS filmmaker undergraduate at Lancaster University and Blackpool school of arts.
One suggestion for you when formulating your minutes (in O13) into hours and minutes at (P13), at the moment your formula in the total time for scene does not format to hours and minutes (hh:mm), if you want to do this, use this formula, this will convert properly into HH:MM .
So the formula in P13 would be =TIME(0,O13,0)
That's 0 hours, the number of minutes in N13, and 0 seconds.
To format the cell as the time format you want (HH:MM).
Right-click on the O13 cell, select "format cells" from the drop-down list, select "custom" (in the categories list) scroll up or down in the list to find the hh:mm, left click, then press OK.
For example, add minutes into any of the boxes in "set up time (M5 to M12)" to a total of 179 minutes and it produces an output of 02:59. 2 hours 59 minutes. You're welcome, great spreadsheet by the way, I'm using it on my Preparing to Film assignment.
This is amazing! Thank you for your insight, I will implement this in the next version. Doing a little update. Cheers!
im goin to work as an assistant director in a new movie in india & i was looking for a proper info about shot listing & i just saw this video & this is the best what i got thank u for uploading 👍
Glad I could help!
Amazing, thank you! I'm currently using your template to plan one of my shoots for school.
@@sdm282 How did that project go?? 10 years ago!
You are so welcome. Glad I could make you look absolutely badass.
extremely helpful! writing a shotlist was incredibly intimidating before I saw this vid and template :D
I'm so glad I could ease your mind.
Thanks for the template!!!
This is so helpful, thanks for doing this. I had one question, I noticed there was no field for audio track number. How do you typically keep track of which audio file goes with which take?
Before you do the clap, you announce the shot and scene name and take number and then clap / use the clapperboard. For example:
"Sound rolling, shot 7 b, take 2, character name OTS shot, camera rolling, action!" And then you clap and the actors start the scene
Thanks A lot im going to use this best iv seen so far
Well, thank you!
Thanks for sharing this template it helped alot
Thanks for sharing! Really appreciate! Peace!
This is super effing rad. Thank you.
You are so welcome. YOU are super effing rad!
Super helpful. Thanks!
Great tool and explanation. What I'm missing for my kind of work is a simple "sound section". Some columns on the audio needed in a particular shot. Handy for one-man-band operation.
This work flow definitely opens up possibilities for customization. Thanks for watching!
Thank you for this!! gold indeed :)
Thanks a lot for the template! Has helped me big time!!
I'm so glad! Keep shooting!
Very helpful, thanks George.
Thanks for sharing your shot list template and ideas!
Thumbs up!
This is good. Thanks for sharing.
Thanks . I'm a novice and this was very useful. Keep up the great work
Ashish mahobia your words of encouragement are very appreciated!
George V.K. Thanks too. I am 42 and have just started learning film making . Pls suggest some good tutorial sites on film making
Ashish mahobia Search "Film Riot" on TH-cam. Really fun podcast. Otherwise it's all about knowing what you want to learn and doing a simple search. That's how I do it. Best of luck!
Thanks
Hey George,
How did you get each section to represent the colour of the type of camera used at each point if in fact that was what the colours represented ??
+Jeffrey Brathwaite It's called conditional formatting. Here's something to get you started. support.google.com/docs/answer/78413?hl=en
Amazing! thank you so much for this!
YOU are amazing. Thank you for watching. :)
Brother. . . nicely done. . . nicely done indeed.
Goerge, AWESOME. thanx a million, saved me tons of time.
Glad I could help out Ramona! :)
Hi, George! I'm not very experienced with spreadsheet software, but I understand the basics of how to use your spreadsheet. It is very helpful, thank you!
QUESTION:
I see that you have multiple scenes on your example in the video, but the template you have provided only includes a few lines and one scene.
How do I add more lines/scenes (and still keep the formatting/calculations)?
Thanks again!
Jesse
You can easily select the row with the scene title, copy and paste it onto a new row and continue with a new scene. Hope that helps!
Love it ! Thanks Bro !
Dude, thanks for this. This is amazing.
hey George, is really nice of you. but how do you print after all . I am heaving trouble to print after I made the list
THANK YOU SO MUCH MAN !
@@souliyongsayavong4481 YOU ARE SO WELCOME MAN !
How can you edit the equipment so that typing in said equipment will result in a color change in the cell? For example, if I wanted to change "JIB" to "steadicam" on the top, typing "JIB" in the equipment column still makes the column turn pink.
That's a bit of a convoluted process. If you google "conditional formatting" within Google Sheets, you should find some information on how to do that. Good luck!
George, this was so helpful! Can't thank you enough :)
Do you have any other videos on pre-production, or anything of this kind of nature, as I'd love to see how you planned an entire project, as Ideal World looks H-AMAZING!! :D
HI George, I have a school project video and it really helpful for me when found your tut online for a shot list template.
My question is for "coverage" tab I dont clearly underdant what is used for? Hope u can have some time to explain what it means to me.
Really helpful and informative. Thank so much for your dedication.
How much of your script you want that shot to cover. :)
George Kotelnikov Thank you so much for the information. I was telling by my professor to prepare a shot list before writing a storyboard. As an experienced producer, would you give us some advice as what we could do before making a movie. I love playing around with camera but very limited about procedure how to make a movie. Organizing before shooting is really important as I devote my time to work on this project.
George, this fantastic and I'll be sharing it with my students in the film school at DePaul. Maybe I missed this, but how do you create a new scene?
Hey Brad, good to hear you liked the template! You can either duplicate the sheet, or just select the scene header row and copy/paste it below. Hope that helps!
Good job on the shot list George. I'm also working with a very detailed pre-pro. But my major problem is: I as a director understand this shot list. But when it comes to my 1st ADs, who should understand it too, it is very hard to find ADs that are used to that kind of detail. How are you managing it when you work with different ADs?
I suppose you just pointed out one of the struggles of the film industry. Working with new people is always hard because you don't have the same decorum and common language as with someone that you would usually work with. It's important to hold production meetings prior to shooting so that everyone can get on the same page. Go over every detail of the shotlist with your AD to the point that they are reading your mind. Their job is to know the shotlist better than you, so keep that in mind. Best of luck!
Hey George,
Thanks. Well of course I'm holding a lot of PPMs with my ADs and HoDs. But that doesn't always solve the problem of the missing know how of my ADs that I'm getting. (especially if you are shooting a commercial and the production company gives you an AD of their choice) - So most of the time, the know how of my DP and my vision are on a higher level then the know how of ADs. So knowing the shotlist better than me, is in fact not so easy for them, as they simply don't get it if it's a complex sequence shot with a tech crane or something similar. And especially these setups cost a lot of time if a 1st AD is coordinating these things wrong.
Maybe it's good to know for you: My Irish film company is working on several setups & concepts to bring HoDs closer together and to speed up communication and working processes in Pre-pro and on set. Seems you are working in the same field?
Just send them the link to this video so they can get up to speed with the shot list. George does a good job explaining it.
Okay I am working on my Shot List.. When doing lets say a 10 second duration shot. Would it be considered a 0.1 or is it divided by 60 seconds or by 100 seconds. Thanks much.
It's in decimal form so yeah, you would divide by 60 (seconds). Thus, 10 second duration would be roughly 0.16 but honestly - I wouldn't get boggled down in the details. Just estimate relative to 100% being 1 minute (or one page of script). Half a page = .5; quarter of a page is .25, any shots that are shorter - .1 or .2 would be sufficient. Remember these are just estimates. Good luck!
This is fantastic. one question though: for a 2 camera back and forth dialogue scene, would you count each camera as a different row, or have one row for both cameras filming both actors do a dialogue?
+Sergio Uzurin Great question. I suppose either way works as long as it makes sense to you. Personally, I would probably keep both cameras on their own row, and just merge the cells in the CAMERA column to indicate that these two cameras are A and B, filming different characters/subjects simultaneously.
Thank you George!
You are welcome, Esperanza! :)
I'm starting to work with this template. Thanks so much for doing it! Can you explain how you came up with your shoot times in the O column? I don't understand the formula you used, and the resulting number seems too high. But of course, I'm a first time director, so I'm probably under-estimating the amount of time it will take.
It's simply an estimation of the predicted number of takes for any given shot, times the length of each take, with an added 5 minutes in between each take for any adjustments needed. Tack on the setup time for the shot and you have a total estimated time that particular shot will take. Rinse, repeat!
It's starting to make sense to me now. Thanks George!
Thanks a lot...
please update drop down angle :D
and anything..
so faarr gooodddd
Thanks so much for sharing this !!
thanks for the effort!
You're awesome! Thank you!
Great stuff George!
Hi George. Thanks for this! One question. You said the third number in the shot # is "the actual shot number". What do you mean by that? After you have a different SET in that scene, I don't understand what that third number is for. Maybe can you write an example.
Thank you again,
Tomer
Thanx, very good tutorial
Glad I could help!
Hi Georges, thank you for sharing this with us all, definitely the best thing out there! I downloaded en excel version of it, but the formula to give the shoot time doesn't work anymore. Can you let me know what it is, I can add it myself manually. Thanks in advance
I'm updating the shot list template. Be on the lookout, it's coming on Monday!
Yes, it has an equation that takes into account the predicted number of takes, setup time and shot time and plugs it in. Spits out an estimation. :)
Thank you George
Awesome video and great Template!
Great breakdown! Are your servers still up by any chance? I tried to get a copy sent to me but I haven't been emailed it yet and it has been a few hours.
You are so awesome for notifying me. I had the workflow paused because I'm working on some exciting stuff and I guess I got trigger happy. It has resumed and you should now see it in your inbox! Thanks again.
Ah thank you, no worries, all the best
Glad it helped you out! :)
good job very similar to ours I omit a couple of things you have but I add a dialogue column.
Very smart. 👀
Thanks man!!!
thanks.. this was helpful
Is there a download for this shot list rather than just working on it online?
If you open it up in Google docs, then you can select File > Download as > Microsoft Excel
For the script time, setup time and predic # of takes, do I add up my own numbers to get the shoot time or is there an algorithm already plugged into the template to do that for me? Just curious how you got 54 for your shoot time on your first shot? Thank you and awesome video! Really helps me out!
Thanks George!!!
Hey Stefan,
You may have to just copy the equation down by dragging the little dot (on the bottom right corner of the selected cell) on the cell that has the equation down. Otherwise, you can also simply copy & paste. Hope that helps!
Thanks for this! How do I add another location to your template? I am trying to cut and paste all the cells but it's not working. I am not very savvy with Google docs.
You are very welcome. You can duplicate the whole sheet (at the bottom) instead trying to copy the cells individually. Hope that helps!
do you have in this template in excel? thanks!
You can always download that template from Google Doc in Excel format. File > Download as... :)
Legendary.
Yes you are, good sir. 😎
Thanks for this. Thumbs up!
I personally almost never keep track of which audio goes with which take because I just throw it all into a timeline and let PluralEyes do the work for me. (I have some videos on that as well). But you can easily right add a separate column for the Audio notes. :)
Another question:
When I use the template and indicate the equipment used, it doesn't change the color of the whole row, but just the one 'equipment' cell. Is there a way to fix this?
You may have to dig into some Google Sheets tutorials on 'conditional formatting' - I'm not quite sure how to apply that change to the whole row - although that's a great idea. I may have to implement this into the next version. Thanks!
@@itsgeorgevk Do you have a next version yet? ;)
@@TimesComingMedia It is in the works!
I really want to use your template but I can't I receive the template and can see it already but It said I don't have a access to edit
@@pannawatphawatta1511 Hi Pannawat. When you click the link to access the template, are you seeing a big blue button at the top right “USE TEMPLATE”?
youre the man!
I'm having a problem with this as well. tried what you suggested, and it didn't work. When I add a new scene under the previous, the calculations don't work. Any ideas?
Hello great template! Do you still have the template up? When I click the link it says error 404.
Hey kgill113, not sure why that's happening because it's working for me. Perhaps try a different browser, or another computer.
Hey! Please let me know when you put it up.
thanks, very helpful :)
THANK YOU!
You are very welcome. Glad I could help.