{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Production Budget"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Production Budget","index":0,"n_rows":183,"n_cols":6,"rows_kept":183,"cut":false,"hidden":false,"merged":[[159,0,160,4],[159,5,160,5],[161,0,161,5],[170,0,170,5],[0,1,0,5],[175,0,176,0],[175,1,176,1],[61,5,62,5],[61,0,62,4],[125,0,126,4],[125,5,126,5],[168,0,169,4],[168,5,169,5]]}
["MADE OF TRUTH: BFI DOC SOCIETY SHORTS PROGRAMME","Production Title"]
[]
["WHAT","DETAILS","INVOICE Ref Code ","PROJECTED COST","UNIT or DAYS","PROJECTED TOTAL "]
["Production Crew"]
[]
["PRODUCER"]
[null,null,null,0,0,{"$f":"SUM(D7*E7)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F7)","v":0}]
[]
["DIRECTOR"]
[null,null,null,0,0,{"$f":"SUM(D11*E11)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F11)","v":0}]
[]
["WRITER"]
[null,null,null,0,0,{"$f":"SUM(D15*E15)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F15)","v":0}]
[]
["CAMERA"]
[null,null,null,0,0,{"$f":"SUM(D19*E19)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D20*E20)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D21*E21)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F19:F21)","v":0}]
[]
["SOUND"]
[null,null,null,0,0,{"$f":"SUM(D25*E25)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D26*E26)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D27*E27)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D28*E28)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F25:F28)","v":0}]
[]
["LIGHTING"]
[null,null,null,0,0,{"$f":"SUM(D32*E32)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D33*E33)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D34*E34)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F32:F34)","v":0}]
[]
["EDITOR"]
[null,null,null,0,0,{"$f":"SUM(D38*E38)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F38)","v":0}]
[]
["ART DEPT/COSTUME/MAKE-UP"]
[null,null,null,0,0,{"$f":"SUM(D42*E42)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D43*E43)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D44*E44)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F42:F44)","v":0}]
[]
["COMPOSER"]
[null,null,null,0,0,{"$f":"SUM(D48*E48)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D49*E49)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F48:F49)","v":0}]
[]
["RESEARCHER"]
[null,null,null,0,0,{"$f":"SUM(D53*E53)","v":0}]
[null,null,null,0,0,{"$f":"D54*E54","v":0}]
[null,null,null,0,0,{"$f":"D55*E55","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F53:F55)","v":0}]
[]
["RUNNERS/ASSISTANTS"]
[null,null,null,0,0,{"$f":"SUM(D59*E59)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F59)","v":0}]
[]
["CREW SUB TOTAL ",null,null,null,null,{"$f":"SUM(F60,F56,F50,F45,F39,F35,F29,F22,F16,F12,F8)","v":0}]
[]
[]
["Production Costs "]
[]
["INSURANCE"]
[null,null,null,0,0,{"$f":"SUM(D68*E68)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F68)","v":0}]
[]
["LEGALS"]
[null,null,null,0,0,{"$f":"SUM(D72*E72)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D73*E73)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D74*E74)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F72:F74)","v":0}]
[]
["CONTRIBUTORS"]
[null,null,null,0,0,{"$f":"SUM(D78*E78)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D79*E79)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D80*E80)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F78:F80)","v":0}]
[]
["CAST/NARRATOR/EXTRAS"]
[null,null,null,0,0,{"$f":"SUM(D84*E84)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D85*E85)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D86*E86)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F84:F86)","v":0}]
[]
["TRAVEL/ACCOMODATIONS/MEALS"]
[null,null,null,0,0,{"$f":"SUM(D90*E90)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D91*E91)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D92*E92)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F90:F92)","v":0}]
[]
["OTHER"]
[null,null,null,0,0,{"$f":"SUM(D96*E96)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F96)","v":0}]
[]
["EQUIP - CAMERA              \n(inc Hard drives) "]
[null,null,null,0,0,{"$f":"SUM(D100*E100)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D101*E101)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F100:F101)","v":0}]
[]
["EQUIP - LIGHTING"]
[null,null,null,0,0,{"$f":"SUM(D105*E105)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D106*E106)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F105:F106)","v":0}]
[]
["EQUIP - SOUND"]
[null,null,null,0,0,{"$f":"SUM(D110*E110)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D111*E111)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D112*E112)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F110:F112)","v":0}]
[]
["SET DESIGN / BUILD"]
[null,null,null,0,0,{"$f":"SUM(D116*E116)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D117*E117)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D118*E118)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F116:F118)","v":0}]
[]
["LOCATIONS"]
[null,null,null,0,0,0]
[null,null,null,0,0,{"$f":"SUM(D123*E123)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F122:F123)","v":0}]
[]
["PRODUCTION COSTS SUB TOTAL",null,null,null,null,{"$f":"SUM(F124+F119+F113+F107+F102+F97+F93+F87+F81+F75+F69)","v":0}]
[]
[]
["Post Production"]
[]
["OFF LINE EDIT"]
[null,null,null,0,0,{"$f":"SUM(D132*E132)","v":0}]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
["Total ",null,null,null,null,{"$f":"SUM(F132:F137)","v":0}]
[]
["DELIVERY MATERIALS"]
[null,null,null,0,0,{"$f":"SUM(D141*E141)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D142*E142)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D143*E143)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F141:F143)","v":0}]
[]
["FINISHING POST (ON-LINE,GRADE, SOUND MIX)"]
[null,null,null,0,0,{"$f":"SUM(D147*E147)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D148*E148)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D149*E149)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D150*E150)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D151*E151)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F147:F151)","v":0}]
[]
["MISC"]
[null,null,null,0,0,{"$f":"SUM(D155*E155)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D156*E156)","v":0}]
[null,null,null,0,0,{"$f":"SUM(D157*E157)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F155:F157)","v":0}]
[]
["POST- PRODUCTION EXPENSES SUB TOTAL",null,null,null,null,{"$f":"SUM(F158+F152+F144+F138)","v":0}]
[]
[]
["OVERHEAD/CONTINGENCY"]
[]
["OVERHEAD/CONTINGENCY"]
["Overhead/Contingency",null,null,0,0,{"$f":"SUM(D166*E166)","v":0}]
["Total ",null,null,null,null,{"$f":"SUM(F166)","v":0}]
[]
["OVERHEAD/CONTINGENCY SUB TOTAL",null,null,null,null,{"$f":"SUM(F167)","v":0}]
[]
[]
[]
["OVERALL Total inc VAT ",{"$f":"SUM(F169+F160+F126+F62)","v":0}]
["AMOUNT REQUESTED FROM BFI DOC SOCIETY",0]
["OTHER FINANCE NEEDED",0]
["BUDGET TOTAL",{"$f":"SUM(B174+B175)","v":0}]
[]
[]
[]
[]
["NB: Overall total inclu. VAT must equal Budget Total"]
["PLEASE DOUBLECHECK YOUR FORMULAS"]
["MAXIMUM AMOUNT REQUESTED FROM BFI DOC SOCIETY IS £11,250"]