{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Notes","Totals","Detail","Personnel","Crew","Comparison","Schedule","Assumptions","Parameters"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":55,"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":"Notes","index":0,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Notes for using this template"]
[]
["If you get a #NAME error under the holiday calculation in the Personnel Sheet please follow these steps:"]
["      Tools > Add-Ins > Tick the box next to Analysis ToolPak"]
[]
["If you need to unprotect any sheet, select Tools > Protection > Unprotect"]

{"sheet":"Totals","index":1,"n_rows":73,"n_cols":13,"rows_kept":73,"cut":false,"hidden":false,"merged":[[23,8,23,9],[24,8,24,9],[2,4,2,7],[3,4,3,7],[4,4,4,7],[7,4,7,5],[41,8,41,9],[32,8,32,9],[33,8,33,9],[25,8,25,9],[26,8,26,9],[27,8,27,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[31,8,31,9],[36,8,36,9],[37,8,37,9],[38,8,38,9],[39,8,39,9],[40,8,40,9],[48,8,48,9],[15,8,15,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9],[42,8,42,9],[43,8,43,9],[46,8,46,9],[47,8,47,9],[44,8,44,9],[45,8,45,9],[34,8,34,9],[35,8,35,9]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Detail Page"]
[null,null,null,null,"ITV STUDIOS",null,null,null,null,null,null,null,"Personnel"]
[null,null,null,null,"FACTUAL / ENTERTAINMENT",null,null,null,null,null,null,null,"Crew"]
[null,null,null,null,"Programme Budget",null,null,null,null,null,null,null,"Comparison"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Schedule"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Assumptions"]
[null,null,null,"Programme Name:",null,null,null,{"$f":"TODAY()","v":"2014-02-11"}]
[null,null,null,"Programme Number:"]
[null,null,null,"Episodes in series:",null," ",null,"Broadcaster"]
[null,null,null,"Episode Length:",null,null,null,"Tape Delivery"]
[null,null,null,"Version:",null,null,null,"Currency"]
[null,null,null,"No. of Transmissions:"]
[]
[]
[null,null,null,"Categories",null,"Episode","Series",null,"Notes"]
[null,null,null,null,null,{"$f":"IF(I12=\"EUR\",\"€\",IF(OR(I12=\"AUD\",I12=\"USD\"),\"$\",\"£\"))","v":"£"},{"$f":"IF(I12=\"EUR\",\"€\",IF(OR(I12=\"AUD\",I12=\"USD\"),\"$\",\"£\"))","v":"£"}]
[null,null,"01","Scripts/ Formats/Development",null,{"$f":"IF(ISERROR(ROUND(G18/Eps,2)),0,(ROUND(G18/Eps,2)))","v":0},{"$f":"VLOOKUP(C18&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"02","Producer/Director",null,0,{"$f":"VLOOKUP(C19&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"03","Artists",null,0,{"$f":"VLOOKUP(C20&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"04","Presenters/Interviewees/Contributors",null,0,{"$f":"VLOOKUP(C21&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"05","Production Unit Salaries",null,0,{"$f":"VLOOKUP(C22&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"06","Assistant Directors/Continuity",null,0,{"$f":"VLOOKUP(C23&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"07","Crew - Camera",null,0,{"$f":"VLOOKUP(C24&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"08","Crew - Sound",null,0,{"$f":"VLOOKUP(C25&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"09","Crew - Lighting",null,0,{"$f":"VLOOKUP(C26&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"10","Crew - Art Department",null,0,{"$f":"VLOOKUP(C27&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"11","Crew - Wardrobe/Make Up/Hair",null,0,{"$f":"VLOOKUP(C28&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"12","Crew - Animation",null,0,{"$f":"VLOOKUP(C29&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"13","Crew - Edit",null,0,{"$f":"VLOOKUP(C30&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"14","Materials - Art Department",null,0,{"$f":"VLOOKUP(C31&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"15","Materials - Wardrobe/Make Up /Hair",null,0,{"$f":"VLOOKUP(C32&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"16","Production Equipment",null,0,{"$f":"VLOOKUP(C33&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"17","Facility Packages ",null,0,{"$f":"VLOOKUP(C34&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"18","Studio & Outside Broadcasts",null,0,{"$f":"VLOOKUP(C35&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"19","Other Production Facilities",null,0,{"$f":"VLOOKUP(C36&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"20","Film/Tape Stock",null,0,{"$f":"VLOOKUP(C37&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"21","Animation Pre Production",null,0,{"$f":"VLOOKUP(C38&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"22","Post Production",null,0,{"$f":"VLOOKUP(C39&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"23","Library Film Archive",null,0,{"$f":"VLOOKUP(C40&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"24","Graphics",null,0,{"$f":"VLOOKUP(C41&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"25","Music",null,0,{"$f":"VLOOKUP(C42&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"26","Travel/Transport",null,0,{"$f":"VLOOKUP(C43&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"27","Hotel/Living",null,0,{"$f":"VLOOKUP(C44&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"28","Other Production Costs",null,0,{"$f":"VLOOKUP(C45&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"29","Finance/Legal",null,0,{"$f":"VLOOKUP(C46&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"30","Production Overheads",null,0,{"$f":"VLOOKUP(C47&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"31","Theatrical Performances",null,0,{"$f":"VLOOKUP(C48&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[null,null,"32","Contingency",null,0,{"$f":"VLOOKUP(C49&\"Sub-Total\",Detail!$B:$I,8,0)","v":0}]
[]
[]
[null,null,null,""]
[null,null,null,"Total Production Costs",null,{"$f":"SUM(F18:F51)","v":0},{"$f":"SUM(G18:G51)","v":0}]
[]
[null,null,null,"Overheads",7.4999999999999997E-2,{"$f":"ROUND(F53*$E55,2)","v":0},{"$f":"ROUND(G53*$E55,2)","v":0}]
[]
[null,null,null,"Subtotal",null,{"$f":"F53+F55","v":0},{"$f":"G53+G55","v":0}]
[]
[null,null,null,"PRODUCTION FEE",0.1,{"$f":"ROUND(F57*$E59,2)","v":0},{"$f":"ROUND(G57*$E59,2)","v":0}]
[null,null,null,"INSURANCE",7.4999999999999997E-3,{"$f":"ROUND(F53*$E60,2)","v":0},{"$f":"ROUND(G53*$E60,2)","v":0}]
[]
[]
[null,null,null,"Efficiency"]
[null,null,null,"TOTAL COST",{"$f":"Currency","v":"£"},{"$f":"SUM(F57:F63)","v":0},{"$f":"SUM(G57:G63)","v":0}]
[]
[null,null,null,null,null,{"$f":"Detail!H544-F53","v":0},{"$f":"Detail!I544-G53","v":0},{"$f":"IF(AND(F66=0,G66=0),\"\",\"Check against Detail page - values do not match\")","v":""}]
[]
[]
[null,null,null,"Executive Producer:",null,null,"Pre Production"]
[null,null,null,"Series Producer:",null,null,"Production"]
[null,null,null,"Production Executive:",null,null,"Post Production"]
[null,null,null,"Production Manager:",null,null,"Delivery"]
[null,null,null,"Production Accountant:"]

{"sheet":"Detail","index":2,"n_rows":546,"n_cols":11,"rows_kept":546,"cut":false,"hidden":false,"merged":[[378,3,378,4],[300,3,300,4],[19,3,19,4],[28,3,28,4],[52,3,52,4],[66,3,66,4],[333,3,333,4],[325,3,325,4],[201,3,201,4],[220,3,220,4],[234,3,234,4],[263,3,263,4],[75,3,75,4],[87,3,87,4],[104,3,104,4],[115,3,115,4],[348,3,348,4],[128,3,128,4],[156,3,156,4],[173,3,173,4],[184,3,184,4],[274,3,274,4],[389,3,389,4],[401,3,401,4],[419,3,419,4],[453,3,453,4],[478,3,478,4],[543,8,544,8],[503,3,503,4],[515,3,515,4],[528,3,528,4],[535,3,535,4],[541,3,541,4],[543,1,544,6],[543,7,544,7]]}
[null,"Back to Totals Page",null,{"$f":"Name","v":0}]
[null,null,null,{"$f":"Number","v":0}]
[null,null,null,"Budget Detail"]
[]
[null,"Code","Description","Information","Unit","Occ","Rate",{"$f":"\"Per Ep \"&Currency","v":"Per Ep £"},{"$f":"\"Series \"&Currency","v":"Series £"}]
[null,null,null,null,null,null,null,null,{"$f":"I20","v":0}]
[null,"01","Scripts/Formats/Development",null,null,null,null,{"$f":"IF(H20=0,0,\"Ep\")","v":0},{"$f":"IF(I20=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"01A",{"$f":"VLOOKUP(LEFT(B9,3),Parameters!E:F,2,0)","v":"Writers Fees"},null,null,"Occ",0,{"$f":"IF(ISERROR(ROUND(I9/Eps,2)),0,ROUND(I9/Eps,2))","v":0},{"$f":"ROUND(E9*G9,2)","v":0}]
[null,"01B",{"$f":"VLOOKUP(LEFT(B10,3),Parameters!E:F,2,0)","v":"Writers Repeat Fees"},null,0,"Occ",0,0,{"$f":"ROUND(E10*G10,2)","v":0}]
[null,"01C",{"$f":"VLOOKUP(LEFT(B11,3),Parameters!E:F,2,0)","v":"Writers Pension"},null,0,"Occ",0,0,0]
[null,"01D",{"$f":"VLOOKUP(LEFT(B12,3),Parameters!E:F,2,0)","v":"Scripts Team"},null,0,"Occ",0,0,0]
[null,"01E",{"$f":"VLOOKUP(LEFT(B13,3),Parameters!E:F,2,0)","v":"Consultancy - Scripts"},null,0,"Occ",0,0,0]
[null,"01F",{"$f":"VLOOKUP(LEFT(B14,3),Parameters!E:F,2,0)","v":"Rights / Format Fees"},null,0,"Occ",0,0,0]
[null,"01G",{"$f":"VLOOKUP(LEFT(B15,3),Parameters!E:F,2,0)","v":"Uncommissioned Writers"},null,0,"Occ",0,0,0]
[null,"01H",{"$f":"VLOOKUP(LEFT(B16,3),Parameters!E:F,2,0)","v":"Options"},null,0,"Occ",0,0,0]
[null,"01I",{"$f":"VLOOKUP(LEFT(B17,3),Parameters!E:F,2,0)","v":"Development Costs"},null,0,"Occ",0,0,0]
[null,"01J",{"$f":"VLOOKUP(LEFT(B18,3),Parameters!E:F,2,0)","v":"Storyboards"},null,0,"Occ",0,0,0]
[null,"01K",{"$f":"VLOOKUP(LEFT(B19,3),Parameters!E:F,2,0)","v":"Create Advance Payment"},null,0,"Occ",0,0,0]
[null,{"$f":"B7&D20","v":"01Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H8:H19)","v":0},{"$f":"SUM(I8:I19)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I20","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I29","v":0}]
[null,"02","Producer/Director Salaries","Update Personnel",null,null,null,{"$f":"IF(H29=0,0,\"Ep\")","v":0},{"$f":"IF(I29=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"02","Basic Salaries",null,{"$f":"VLOOKUP($B25&\" Totals\",Personnel!$A:$AB,12,0)+ROUND((VLOOKUP($B25&\" Totals\",Personnel!$A:$AB,14,0)/5),1)","v":0},"Weeks",null,{"$f":"IF(ISERROR(ROUND(I25/Eps,2)),0,ROUND(I25/Eps,2))","v":0},{"$f":"VLOOKUP($B25&\" Totals\",Personnel!$A:$AB,20,0)","v":0}]
[null,null,"Pension",null,1,"Occ",{"$f":"VLOOKUP($B25&\" Totals\",Personnel!$A:$AB,24,0)","v":0},{"$f":"IF(ISERROR(ROUND(I26/Eps,2)),0,ROUND(I26/Eps,2))","v":0},{"$f":"ROUND(E26*G26,2)","v":0}]
[null,null,"Holiday",null,1,"Occ",{"$f":"VLOOKUP($B25&\" Totals\",Personnel!$A:$AB,26,0)","v":0},{"$f":"IF(ISERROR(ROUND(I27/Eps,2)),0,ROUND(I27/Eps,2))","v":0},{"$f":"ROUND(E27*G27,2)","v":0}]
[null,null,"National Insurance",null,1,"Occ",{"$f":"VLOOKUP($B25&\" Totals\",Personnel!$A:$AB,22,0)","v":0},{"$f":"IF(ISERROR(ROUND(I28/Eps,2)),0,ROUND(I28/Eps,2))","v":0},{"$f":"ROUND(E28*G28,2)","v":0}]
[null,{"$f":"B23&D29","v":"02Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H24:H28)","v":0},{"$f":"ROUND(SUM(I24:I28),2)","v":0},null,{"$f":"IF(AND((VLOOKUP($B25&\" Totals\",Personnel!$A:$AB,28,0)-I29)>-1,(VLOOKUP($B25&\" Totals\",Personnel!$A:$AB,28,0)-I29)<1),\"\",\"Check Personnel Page - Totals do not match\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"I29","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I53","v":0}]
[null,"03","Artists",null,null,null,null,{"$f":"IF(H53=0,0,\"Ep\")","v":0},{"$f":"IF(I53=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"03A",{"$f":"VLOOKUP(LEFT(B34,3),Parameters!E:F,2,0)","v":"Performers Fees"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I34/Eps,2)),0,ROUND(I34/Eps,2))","v":0},{"$f":"ROUND(E34*G34,2)","v":0}]
[null,"03B",{"$f":"VLOOKUP(LEFT(B35,3),Parameters!E:F,2,0)","v":"Performers Repeat Fees"},null,0,"Occ",0,0,{"$f":"ROUND(E35*G35,2)","v":0}]
[null,"03C",{"$f":"VLOOKUP(LEFT(B36,3),Parameters!E:F,2,0)","v":"Performers Holiday Pay"},null,0,"Occ",0,0,{"$f":"ROUND(E36*G36,2)","v":0}]
[null,"03D",{"$f":"VLOOKUP(LEFT(B37,3),Parameters!E:F,2,0)","v":"Performers National Insurance (13.8%)"},null,0,"Occ",0,0,{"$f":"ROUND(E37*G37,2)","v":0}]
[null,"03E",{"$f":"VLOOKUP(LEFT(B38,3),Parameters!E:F,2,0)","v":"Production Days"},null,0,"Occ",0,0,0]
[null,"03F",{"$f":"VLOOKUP(LEFT(B39,3),Parameters!E:F,2,0)","v":"Make-Up / Wardrobe Attendance Days"},null,0,"Occ",0,0,0]
[null,"03G",{"$f":"VLOOKUP(LEFT(B40,3),Parameters!E:F,2,0)","v":"Rehearsal/Stand-By Days"},null,0,"Occ",0,0,0]
[null,"03H",{"$f":"VLOOKUP(LEFT(B41,3),Parameters!E:F,2,0)","v":"Performers Overtime"},null,0,"Occ",0,0,0]
[null,"03I",{"$f":"VLOOKUP(LEFT(B42,3),Parameters!E:F,2,0)","v":"Stunts"},null,0,"Occ",0,0,0]
[null,"03J",{"$f":"VLOOKUP(LEFT(B43,3),Parameters!E:F,2,0)","v":"Choreographer"},null,0,"Occ",0,0,0]
[null,"03K",{"$f":"VLOOKUP(LEFT(B44,3),Parameters!E:F,2,0)","v":"Chaperones / Tutors"},null,0,"Occ",0,0,0]
[null,"03L",{"$f":"VLOOKUP(LEFT(B45,3),Parameters!E:F,2,0)","v":"Puppeteers"},null,0,"Occ",0,0,0]
[null,"03M",{"$f":"VLOOKUP(LEFT(B46,3),Parameters!E:F,2,0)","v":"Extras / Walk-Ons"},null,0,"Occ",0,0,0]
[null,"03N",{"$f":"VLOOKUP(LEFT(B47,3),Parameters!E:F,2,0)","v":"Doubles & Stand-Ins"},null,0,"Occ",0,0,0]
[null,"03O",{"$f":"VLOOKUP(LEFT(B48,3),Parameters!E:F,2,0)","v":"Dancers"},null,0,"Occ",0,0,0]
[null,"03P",{"$f":"VLOOKUP(LEFT(B49,3),Parameters!E:F,2,0)","v":"Backing Vocals"},null,0,"Occ",0,0,0]
[null,"03Q",{"$f":"VLOOKUP(LEFT(B50,3),Parameters!E:F,2,0)","v":"Warm-Up Artist"},null,0,"Occ",0,0,{"$f":"ROUND(E50*G50,2)","v":0}]
[null,"03R",{"$f":"VLOOKUP(LEFT(B51,3),Parameters!E:F,2,0)","v":"Performers National Insurance (13.8%)"},null,0,"Occ",0,0,{"$f":"ROUND(E51*G51,2)","v":0}]
[null,"03S",{"$f":"VLOOKUP(LEFT(B52,3),Parameters!E:F,2,0)","v":"Performers Guarentees"},null,0,"Occ",0,0,0]
[null,{"$f":"B32&D53","v":"03Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H33:H52)","v":0},{"$f":"SUM(I33:I52)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I53","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I67","v":0}]
[null,"04","Presenters / Interviewees / Contributors",null,null,null,null,{"$f":"IF(H67=0,0,\"Ep\")","v":0},{"$f":"IF(I67=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"04A",{"$f":"VLOOKUP(LEFT(B58,3),Parameters!E:F,2,0)","v":"Presenters"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I58/Eps,2)),0,ROUND(I58/Eps,2))","v":0},{"$f":"ROUND(E58*G58,2)","v":0}]
[null,"04B",{"$f":"VLOOKUP(LEFT(B59,3),Parameters!E:F,2,0)","v":"Contributors"},null,0,"Occ",0,0,{"$f":"ROUND(E59*G59,2)","v":0}]
[null,"04C",{"$f":"VLOOKUP(LEFT(B60,3),Parameters!E:F,2,0)","v":"Narrators / Voice-Overs"},null,0,"Occ",0,0,{"$f":"ROUND(E60*G60,2)","v":0}]
[null,"04D",{"$f":"VLOOKUP(LEFT(B61,3),Parameters!E:F,2,0)","v":"Guests / Interviewees"},null,0,"Occ",0,0,0]
[null,"04E",{"$f":"VLOOKUP(LEFT(B62,3),Parameters!E:F,2,0)","v":"Consultants"},null,0,"Occ",0,0,0]
[null,"04F","Location Facilitators",null,0,"Occ",0,0,0]
[null,"04G",{"$f":"VLOOKUP(LEFT(B64,3),Parameters!E:F,2,0)","v":"Deaf Signer"},null,0,"Occ",0,0,0]
[null,"04H",{"$f":"VLOOKUP(LEFT(B65,3),Parameters!E:F,2,0)","v":"Weather Presenter"},null,0,"Occ",0,0,0]
[null,"04I",{"$f":"VLOOKUP(LEFT(B66,3),Parameters!E:F,2,0)","v":"Psychologist"},null,0,"Occ",0,0,0]
[null,{"$f":"B56&D67","v":"04Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H57:H66)","v":0},{"$f":"SUM(I57:I66)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I67","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I76","v":0}]
[null,"05","Production Unit Salaries","Update Personnel",null,null,null,{"$f":"IF(H76=0,0,\"Ep\")","v":0},{"$f":"IF(I76=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"05","Basic Salaries",null,{"$f":"VLOOKUP($B72&\" Totals\",Personnel!$A:$AB,12,0)+ROUND((VLOOKUP($B72&\" Totals\",Personnel!$A:$AB,14,0)/5),1)","v":0},"Weeks",null,{"$f":"IF(ISERROR(ROUND(I72/Eps,2)),0,ROUND(I72/Eps,2))","v":0},{"$f":"VLOOKUP($B72&\" Totals\",Personnel!$A:$AB,20,0)","v":0}]
[null,null,"Pension",null,1,"Occ",{"$f":"VLOOKUP($B72&\" Totals\",Personnel!$A:$AB,24,0)","v":0},{"$f":"IF(ISERROR(ROUND(I73/Eps,2)),0,ROUND(I73/Eps,2))","v":0},{"$f":"ROUND(E73*G73,2)","v":0}]
[null,null,"Holiday",null,1,"Occ",{"$f":"VLOOKUP($B72&\" Totals\",Personnel!$A:$AB,26,0)","v":0},{"$f":"IF(ISERROR(ROUND(I74/Eps,2)),0,ROUND(I74/Eps,2))","v":0},{"$f":"ROUND(E74*G74,2)","v":0}]
[null,null,"National Insurance",null,1,"Occ",{"$f":"VLOOKUP($B72&\" Totals\",Personnel!$A:$AB,22,0)","v":0},{"$f":"IF(ISERROR(ROUND(I75/Eps,2)),0,ROUND(I75/Eps,2))","v":0},{"$f":"ROUND(E75*G75,2)","v":0}]
[null,{"$f":"B70&D76","v":"05Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H71:H75)","v":0},{"$f":"ROUND(SUM(I71:I75),2)","v":0},null,{"$f":"IF(AND((VLOOKUP($B72&\" Totals\",Personnel!$A:$AB,28,0)-I76)>-1,(VLOOKUP($B72&\" Totals\",Personnel!$A:$AB,28,0)-I76)<1),\"\",\"Check Personnel Page - Totals do not match\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"I76","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I88","v":0}]
[null,"06","Assistant Directors / Continuity","Update Crew",null,null,null,{"$f":"IF(H88=0,0,\"Ep\")","v":0},{"$f":"IF(I88=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"06A",{"$f":"VLOOKUP(LEFT(B81,3),Parameters!E:F,2,0)","v":"1st Assistant Director"},null,{"$f":"SUMIF(Crew!A:A,B81,Crew!F:F)","v":0},"Days",{"$f":"IF(ISERROR(I81/E81),0,(I81/E81))","v":0},{"$f":"IF(ISERROR(ROUND(I81/Eps,2)),0,ROUND(I81/Eps,2))","v":0},{"$f":"SUMIF(Crew!A:A,B81,Crew!N:N)","v":0}]
[null,"06B",{"$f":"VLOOKUP(LEFT(B82,3),Parameters!E:F,2,0)","v":"2nd Assistant Director"},null,{"$f":"SUMIF(Crew!A:A,B82,Crew!F:F)","v":0},"Days",{"$f":"IF(ISERROR(I82/E82),0,(I82/E82))","v":0},0,{"$f":"SUMIF(Crew!A:A,B82,Crew!N:N)","v":0}]
[null,"06C",{"$f":"VLOOKUP(LEFT(B83,3),Parameters!E:F,2,0)","v":"3rd Assistant Director"},null,{"$f":"SUMIF(Crew!A:A,B83,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B83,Crew!N:N)","v":0}]
[null,"06D",{"$f":"VLOOKUP(LEFT(B84,3),Parameters!E:F,2,0)","v":"Floor Manager"},null,{"$f":"SUMIF(Crew!A:A,B84,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B84,Crew!N:N)","v":0}]
[null,"06E",{"$f":"VLOOKUP(LEFT(B85,3),Parameters!E:F,2,0)","v":"Assistant Floor Manager"},null,{"$f":"SUMIF(Crew!A:A,B85,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B85,Crew!N:N)","v":0}]
[null,"06F",{"$f":"VLOOKUP(LEFT(B86,3),Parameters!E:F,2,0)","v":"Location / Production Runner"},null,{"$f":"SUMIF(Crew!A:A,B86,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B86,Crew!N:N)","v":0}]
[null,"06G",{"$f":"VLOOKUP(LEFT(B87,3),Parameters!E:F,2,0)","v":"Continuity / Script Supervisor"},null,{"$f":"SUMIF(Crew!A:A,B87,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B87,Crew!N:N)","v":0}]
[null,{"$f":"B79&D88","v":"06Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H80:H87)","v":0},{"$f":"SUM(I80:I87)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I88","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I105","v":0}]
[null,"07","Crew - Camera","Update Crew",null,null,null,{"$f":"IF(H105=0,0,\"Ep\")","v":0},{"$f":"IF(I105=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"07A",{"$f":"VLOOKUP(LEFT(B93,3),Parameters!E:F,2,0)","v":"Director of Photography"},null,{"$f":"SUMIF(Crew!A:A,B93,Crew!F:F)","v":0},"Days",{"$f":"IF(ISERROR(I93/E93),0,(I93/E93))","v":0},{"$f":"IF(ISERROR(ROUND(I93/Eps,2)),0,ROUND(I93/Eps,2))","v":0},{"$f":"SUMIF(Crew!A:A,B93,Crew!N:N)","v":0}]
[null,"07B",{"$f":"VLOOKUP(LEFT(B94,3),Parameters!E:F,2,0)","v":"Camera Supervisor"},null,{"$f":"SUMIF(Crew!A:A,B94,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B94,Crew!N:N)","v":0}]
[null,"07C",{"$f":"VLOOKUP(LEFT(B95,3),Parameters!E:F,2,0)","v":"Camera Operator"},null,{"$f":"SUMIF(Crew!A:A,B95,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B95,Crew!N:N)","v":0}]
[null,"07D",{"$f":"VLOOKUP(LEFT(B96,3),Parameters!E:F,2,0)","v":"HD Camera Operator"},null,{"$f":"SUMIF(Crew!A:A,B96,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B96,Crew!N:N)","v":0}]
[null,"07E",{"$f":"VLOOKUP(LEFT(B97,3),Parameters!E:F,2,0)","v":"Camera Assistant / Trainee"},null,{"$f":"SUMIF(Crew!A:A,B97,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B97,Crew!N:N)","v":0}]
[null,"07F",{"$f":"VLOOKUP(LEFT(B98,3),Parameters!E:F,2,0)","v":"Key Grips"},null,{"$f":"SUMIF(Crew!A:A,B98,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B98,Crew!N:N)","v":0}]
[null,"07G",{"$f":"VLOOKUP(LEFT(B99,3),Parameters!E:F,2,0)","v":"Grips / Assistant Grips"},null,{"$f":"SUMIF(Crew!A:A,B99,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B99,Crew!N:N)","v":0}]
[null,"07H",{"$f":"VLOOKUP(LEFT(B100,3),Parameters!E:F,2,0)","v":"Vision Controller / Supervisor"},null,{"$f":"SUMIF(Crew!A:A,B100,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B100,Crew!N:N)","v":0}]
[null,"07I",{"$f":"VLOOKUP(LEFT(B101,3),Parameters!E:F,2,0)","v":"Vision Mixer"},null,{"$f":"SUMIF(Crew!A:A,B101,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B101,Crew!N:N)","v":0}]
[null,"07J",{"$f":"VLOOKUP(LEFT(B102,3),Parameters!E:F,2,0)","v":"Vision Engineer"},null,{"$f":"SUMIF(Crew!A:A,B102,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B102,Crew!N:N)","v":0}]
[null,"07K",{"$f":"VLOOKUP(LEFT(B103,3),Parameters!E:F,2,0)","v":"Focus Puller"},null,{"$f":"SUMIF(Crew!A:A,B103,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B103,Crew!N:N)","v":0}]
[null,"07L",{"$f":"VLOOKUP(LEFT(B104,3),Parameters!E:F,2,0)","v":"Clapper Loader"},null,{"$f":"SUMIF(Crew!A:A,B104,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B104,Crew!N:N)","v":0}]
[null,{"$f":"B91&D105","v":"07Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H92:H104)","v":0},{"$f":"SUM(I92:I104)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I105","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I116","v":0}]
[null,"08","Crew - Sound","Update Crew",null,null,null,{"$f":"IF(H116=0,0,\"Ep\")","v":0},{"$f":"IF(I116=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"08A",{"$f":"VLOOKUP(LEFT(B110,3),Parameters!E:F,2,0)","v":"Sound Supervisor"},null,{"$f":"SUMIF(Crew!A:A,B110,Crew!F:F)","v":0},"Days",{"$f":"IF(ISERROR(I110/E110),0,(I110/E110))","v":0},{"$f":"IF(ISERROR(ROUND(I110/Eps,2)),0,ROUND(I110/Eps,2))","v":0},{"$f":"SUMIF(Crew!A:A,B110,Crew!N:N)","v":0}]
[null,"08B",{"$f":"VLOOKUP(LEFT(B111,3),Parameters!E:F,2,0)","v":"Sound Recordist"},null,{"$f":"SUMIF(Crew!A:A,B111,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B111,Crew!N:N)","v":0}]
[null,"08C",{"$f":"VLOOKUP(LEFT(B112,3),Parameters!E:F,2,0)","v":"HD Sound Recordist"},null,{"$f":"SUMIF(Crew!A:A,B112,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B112,Crew!N:N)","v":0}]
[null,"08D",{"$f":"VLOOKUP(LEFT(B113,3),Parameters!E:F,2,0)","v":"Sound Assistant"},null,{"$f":"SUMIF(Crew!A:A,B113,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B113,Crew!N:N)","v":0}]
[null,"08E",{"$f":"VLOOKUP(LEFT(B114,3),Parameters!E:F,2,0)","v":"Sound Technician"},null,{"$f":"SUMIF(Crew!A:A,B114,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B114,Crew!N:N)","v":0}]
[null,"08F",{"$f":"VLOOKUP(LEFT(B115,3),Parameters!E:F,2,0)","v":"Boom Op / Sound Maintenance Engineer"},null,{"$f":"SUMIF(Crew!A:A,B115,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B115,Crew!N:N)","v":0}]
[null,{"$f":"B108&D116","v":"08Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H109:H115)","v":0},{"$f":"SUM(I109:I115)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I116","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I129","v":0}]
[null,"09","Crew - Lighting","Update Crew",null,null,null,{"$f":"IF(H129=0,0,\"Ep\")","v":0},{"$f":"IF(I129=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"09A",{"$f":"VLOOKUP(LEFT(B121,3),Parameters!E:F,2,0)","v":"Lighting Gaffer"},null,{"$f":"SUMIF(Crew!A:A,B121,Crew!F:F)","v":0},"Days",{"$f":"IF(ISERROR(I121/E121),0,(I121/E121))","v":0},{"$f":"IF(ISERROR(ROUND(I121/Eps,2)),0,ROUND(I121/Eps,2))","v":0},{"$f":"SUMIF(Crew!A:A,B121,Crew!N:N)","v":0}]
[null,"09B",{"$f":"VLOOKUP(LEFT(B122,3),Parameters!E:F,2,0)","v":"Lighting Director"},null,{"$f":"SUMIF(Crew!A:A,B122,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B122,Crew!N:N)","v":0}]
[null,"09C",{"$f":"VLOOKUP(LEFT(B123,3),Parameters!E:F,2,0)","v":"Lighting Dailies"},null,{"$f":"SUMIF(Crew!A:A,B123,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B123,Crew!N:N)","v":0}]
[null,"09D",{"$f":"VLOOKUP(LEFT(B124,3),Parameters!E:F,2,0)","v":"Chargehand Electrician / Best Boy"},null,{"$f":"SUMIF(Crew!A:A,B124,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B124,Crew!N:N)","v":0}]
[null,"09E",{"$f":"VLOOKUP(LEFT(B125,3),Parameters!E:F,2,0)","v":"Electrician"},null,{"$f":"SUMIF(Crew!A:A,B125,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B125,Crew!N:N)","v":0}]
[null,"09F",{"$f":"VLOOKUP(LEFT(B126,3),Parameters!E:F,2,0)","v":"Generator Operator"},null,{"$f":"SUMIF(Crew!A:A,B126,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B126,Crew!N:N)","v":0}]
[null,"09G",{"$f":"VLOOKUP(LEFT(B127,3),Parameters!E:F,2,0)","v":"Console Operator"},null,{"$f":"SUMIF(Crew!A:A,B127,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B127,Crew!N:N)","v":0}]
[null,"09H",{"$f":"VLOOKUP(LEFT(B128,3),Parameters!E:F,2,0)","v":"Picture Co-Ordinator"},null,{"$f":"SUMIF(Crew!A:A,B128,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B128,Crew!N:N)","v":0}]
[null,{"$f":"B119&D129","v":"09Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H120:H128)","v":0},{"$f":"SUM(I120:I128)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I129","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I157","v":0}]
[null,"10","Crew - Art Department","Update Crew",null,null,null,{"$f":"IF(H157=0,0,\"Ep\")","v":0},{"$f":"IF(I157=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"10A",{"$f":"VLOOKUP(LEFT(B134,3),Parameters!E:F,2,0)","v":"Designer"},null,{"$f":"SUMIF(Crew!A:A,B134,Crew!F:F)","v":0},"Days",{"$f":"IF(ISERROR(I134/E134),0,(I134/E134))","v":0},{"$f":"IF(ISERROR(ROUND(I134/Eps,2)),0,ROUND(I134/Eps,2))","v":0},{"$f":"SUMIF(Crew!A:A,B134,Crew!N:N)","v":0}]
[null,"10B",{"$f":"VLOOKUP(LEFT(B135,3),Parameters!E:F,2,0)","v":"Art Director"},null,{"$f":"SUMIF(Crew!A:A,B135,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B135,Crew!N:N)","v":0}]
[null,"10C",{"$f":"VLOOKUP(LEFT(B136,3),Parameters!E:F,2,0)","v":"Standby Art Director"},null,{"$f":"SUMIF(Crew!A:A,B136,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B136,Crew!N:N)","v":0}]
[null,"10D",{"$f":"VLOOKUP(LEFT(B137,3),Parameters!E:F,2,0)","v":"Design Assistant"},null,{"$f":"SUMIF(Crew!A:A,B137,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B137,Crew!N:N)","v":0}]
[null,"10E",{"$f":"VLOOKUP(LEFT(B138,3),Parameters!E:F,2,0)","v":"Design Runner"},null,{"$f":"SUMIF(Crew!A:A,B138,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B138,Crew!N:N)","v":0}]
[null,"10F",{"$f":"VLOOKUP(LEFT(B139,3),Parameters!E:F,2,0)","v":"Rigger"},null,{"$f":"SUMIF(Crew!A:A,B139,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B139,Crew!N:N)","v":0}]
[null,"10G",{"$f":"VLOOKUP(LEFT(B140,3),Parameters!E:F,2,0)","v":"Prop Buyer"},null,{"$f":"SUMIF(Crew!A:A,B140,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B140,Crew!N:N)","v":0}]
[null,"10H",{"$f":"VLOOKUP(LEFT(B141,3),Parameters!E:F,2,0)","v":"Property Master"},null,{"$f":"SUMIF(Crew!A:A,B141,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B141,Crew!N:N)","v":0}]
[null,"10I",{"$f":"VLOOKUP(LEFT(B142,3),Parameters!E:F,2,0)","v":"Props / Set Storekeeper"},null,{"$f":"SUMIF(Crew!A:A,B142,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B142,Crew!N:N)","v":0}]
[null,"10J",{"$f":"VLOOKUP(LEFT(B143,3),Parameters!E:F,2,0)","v":"Dressing Props"},null,{"$f":"SUMIF(Crew!A:A,B143,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B143,Crew!N:N)","v":0}]
[null,"10K",{"$f":"VLOOKUP(LEFT(B144,3),Parameters!E:F,2,0)","v":"Standby Props"},null,{"$f":"SUMIF(Crew!A:A,B144,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B144,Crew!N:N)","v":0}]
[null,"10L",{"$f":"VLOOKUP(LEFT(B145,3),Parameters!E:F,2,0)","v":"Props Dailies"},null,{"$f":"SUMIF(Crew!A:A,B145,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B145,Crew!N:N)","v":0}]
[null,"10M",{"$f":"VLOOKUP(LEFT(B146,3),Parameters!E:F,2,0)","v":"Carpenter"},null,{"$f":"SUMIF(Crew!A:A,B146,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B146,Crew!N:N)","v":0}]
[null,"10N",{"$f":"VLOOKUP(LEFT(B147,3),Parameters!E:F,2,0)","v":"Painter"},null,{"$f":"SUMIF(Crew!A:A,B147,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B147,Crew!N:N)","v":0}]
[null,"10O",{"$f":"VLOOKUP(LEFT(B148,3),Parameters!E:F,2,0)","v":"Construction Manager / Scenic Supervisor"},null,{"$f":"SUMIF(Crew!A:A,B148,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B148,Crew!N:N)","v":0}]
[null,"10P",{"$f":"VLOOKUP(LEFT(B149,3),Parameters!E:F,2,0)","v":"Construction Labour"},null,{"$f":"SUMIF(Crew!A:A,B149,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B149,Crew!N:N)","v":0}]
[null,"10Q",{"$f":"VLOOKUP(LEFT(B150,3),Parameters!E:F,2,0)","v":"Scenic Artist"},null,{"$f":"SUMIF(Crew!A:A,B150,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B150,Crew!N:N)","v":0}]
[null,"10R",{"$f":"VLOOKUP(LEFT(B151,3),Parameters!E:F,2,0)","v":"Signwriter"},null,{"$f":"SUMIF(Crew!A:A,B151,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B151,Crew!N:N)","v":0}]
[null,"10S",{"$f":"VLOOKUP(LEFT(B152,3),Parameters!E:F,2,0)","v":"Stagehand / Chargehand"},null,{"$f":"SUMIF(Crew!A:A,B152,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B152,Crew!N:N)","v":0}]
[null,"10T",{"$f":"VLOOKUP(LEFT(B153,3),Parameters!E:F,2,0)","v":"Drapesman"},null,{"$f":"SUMIF(Crew!A:A,B153,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B153,Crew!N:N)","v":0}]
[null,"10U",{"$f":"VLOOKUP(LEFT(B154,3),Parameters!E:F,2,0)","v":"Safety Co-Ordinator"},null,{"$f":"SUMIF(Crew!A:A,B154,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B154,Crew!N:N)","v":0}]
[null,"10V",{"$f":"VLOOKUP(LEFT(B155,3),Parameters!E:F,2,0)","v":"Plumber"},null,{"$f":"SUMIF(Crew!A:A,B155,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B155,Crew!N:N)","v":0}]
[null,"10W",{"$f":"VLOOKUP(LEFT(B156,3),Parameters!E:F,2,0)","v":"Environmental Conservation"},null,{"$f":"SUMIF(Crew!A:A,B156,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B156,Crew!N:N)","v":0}]
[null,{"$f":"B132&D157","v":"10Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H133:H156)","v":0},{"$f":"SUM(I133:I156)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I157","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I174","v":0}]
[null,"11","Crew - Wardrobe / Make-Up / Hair","Update Crew",null,null,null,{"$f":"IF(H174=0,0,\"Ep\")","v":0},{"$f":"IF(I174=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"11A",{"$f":"VLOOKUP(LEFT(B162,3),Parameters!E:F,2,0)","v":"Costume Designer"},null,{"$f":"SUMIF(Crew!A:A,B162,Crew!F:F)","v":0},"Days",{"$f":"IF(ISERROR(I162/E162),0,(I162/E162))","v":0},{"$f":"IF(ISERROR(ROUND(I162/Eps,2)),0,ROUND(I162/Eps,2))","v":0},{"$f":"SUMIF(Crew!A:A,B162,Crew!N:N)","v":0}]
[null,"11B",{"$f":"VLOOKUP(LEFT(B163,3),Parameters!E:F,2,0)","v":"Costume Supervisor"},null,{"$f":"SUMIF(Crew!A:A,B163,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B163,Crew!N:N)","v":0}]
[null,"11C",{"$f":"VLOOKUP(LEFT(B164,3),Parameters!E:F,2,0)","v":"Assistant Costume Designer"},null,{"$f":"SUMIF(Crew!A:A,B164,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B164,Crew!N:N)","v":0}]
[null,"11D",{"$f":"VLOOKUP(LEFT(B165,3),Parameters!E:F,2,0)","v":"Costume Assistant"},null,{"$f":"SUMIF(Crew!A:A,B165,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B165,Crew!N:N)","v":0}]
[null,"11E",{"$f":"VLOOKUP(LEFT(B166,3),Parameters!E:F,2,0)","v":"Costume Dailies"},null,{"$f":"SUMIF(Crew!A:A,B166,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B166,Crew!N:N)","v":0}]
[null,"11F",{"$f":"VLOOKUP(LEFT(B167,3),Parameters!E:F,2,0)","v":"Dresser"},null,{"$f":"SUMIF(Crew!A:A,B167,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B167,Crew!N:N)","v":0}]
[null,"11G",{"$f":"VLOOKUP(LEFT(B168,3),Parameters!E:F,2,0)","v":"Make-Up Designer"},null,{"$f":"SUMIF(Crew!A:A,B168,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B168,Crew!N:N)","v":0}]
[null,"11H",{"$f":"VLOOKUP(LEFT(B169,3),Parameters!E:F,2,0)","v":"Make-Up Supervisor"},null,{"$f":"SUMIF(Crew!A:A,B169,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B169,Crew!N:N)","v":0}]
[null,"11I",{"$f":"VLOOKUP(LEFT(B170,3),Parameters!E:F,2,0)","v":"Make-Up Artist"},null,{"$f":"SUMIF(Crew!A:A,B170,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B170,Crew!N:N)","v":0}]
[null,"11J",{"$f":"VLOOKUP(LEFT(B171,3),Parameters!E:F,2,0)","v":"Make-Up Assistant"},null,{"$f":"SUMIF(Crew!A:A,B171,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B171,Crew!N:N)","v":0}]
[null,"11K",{"$f":"VLOOKUP(LEFT(B172,3),Parameters!E:F,2,0)","v":"Make-Up Daillies"},null,{"$f":"SUMIF(Crew!A:A,B172,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B172,Crew!N:N)","v":0}]
[null,"11L",{"$f":"VLOOKUP(LEFT(B173,3),Parameters!E:F,2,0)","v":"Hairdresser"},null,{"$f":"SUMIF(Crew!A:A,B173,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B173,Crew!N:N)","v":0}]
[null,{"$f":"B160&D174","v":"11Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H161:H173)","v":0},{"$f":"SUM(I161:I173)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I174","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I185","v":0}]
[null,"12","Crew - Animation","Update Crew",null,null,null,{"$f":"IF(H185=0,0,\"Ep\")","v":0},{"$f":"IF(I185=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"12A",{"$f":"VLOOKUP(LEFT(B179,3),Parameters!E:F,2,0)","v":"Model Animators"},null,{"$f":"SUMIF(Crew!A:A,B179,Crew!F:F)","v":0},"Days",{"$f":"IF(ISERROR(I179/E179),0,(I179/E179))","v":0},{"$f":"IF(ISERROR(ROUND(I179/Eps,2)),0,ROUND(I179/Eps,2))","v":0},{"$f":"SUMIF(Crew!A:A,B179,Crew!N:N)","v":0}]
[null,"12B",{"$f":"VLOOKUP(LEFT(B180,3),Parameters!E:F,2,0)","v":"Flash Animators / 2D Animators"},null,{"$f":"SUMIF(Crew!A:A,B180,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B180,Crew!N:N)","v":0}]
[null,"12C",{"$f":"VLOOKUP(LEFT(B181,3),Parameters!E:F,2,0)","v":"CGI / 3D Animators"},null,{"$f":"SUMIF(Crew!A:A,B181,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B181,Crew!N:N)","v":0}]
[null,"12D",{"$f":"VLOOKUP(LEFT(B182,3),Parameters!E:F,2,0)","v":"Drawn Animators"},null,{"$f":"SUMIF(Crew!A:A,B182,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B182,Crew!N:N)","v":0}]
[null,"12E",{"$f":"VLOOKUP(LEFT(B183,3),Parameters!E:F,2,0)","v":"Overseas Animation"},null,{"$f":"SUMIF(Crew!A:A,B183,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B183,Crew!N:N)","v":0}]
[null,"12F",{"$f":"VLOOKUP(LEFT(B184,3),Parameters!E:F,2,0)","v":"Overseas Supervisor"},null,{"$f":"SUMIF(Crew!A:A,B184,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B184,Crew!N:N)","v":0}]
[null,{"$f":"B177&D185","v":"12Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H178:H184)","v":0},{"$f":"SUM(I178:I184)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I185","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I202","v":0}]
[null,"13","Crew - Edit","Update Crew",null,null,null,{"$f":"IF(H202=0,0,\"Ep\")","v":0},{"$f":"IF(I202=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"13A",{"$f":"VLOOKUP(LEFT(B190,3),Parameters!E:F,2,0)","v":"Post Production Supervisor"},null,{"$f":"SUMIF(Crew!A:A,B190,Crew!F:F)","v":0},"Days",{"$f":"IF(ISERROR(I190/E190),0,(I190/E190))","v":0},{"$f":"IF(ISERROR(ROUND(I190/Eps,2)),0,ROUND(I190/Eps,2))","v":0},{"$f":"SUMIF(Crew!A:A,B190,Crew!N:N)","v":0}]
[null,"13B",{"$f":"VLOOKUP(LEFT(B191,3),Parameters!E:F,2,0)","v":"Editor"},null,{"$f":"SUMIF(Crew!A:A,B191,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B191,Crew!N:N)","v":0}]
[null,"13C",{"$f":"VLOOKUP(LEFT(B192,3),Parameters!E:F,2,0)","v":"Editor Overtime"},null,{"$f":"SUMIF(Crew!A:A,B192,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B192,Crew!N:N)","v":0}]
[null,"13D",{"$f":"VLOOKUP(LEFT(B193,3),Parameters!E:F,2,0)","v":"Assistant Editor"},null,{"$f":"SUMIF(Crew!A:A,B193,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B193,Crew!N:N)","v":0}]
[null,"13E",{"$f":"VLOOKUP(LEFT(B194,3),Parameters!E:F,2,0)","v":"VT Editor"},null,{"$f":"SUMIF(Crew!A:A,B194,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B194,Crew!N:N)","v":0}]
[null,"13F",{"$f":"VLOOKUP(LEFT(B195,3),Parameters!E:F,2,0)","v":"Dubbing Editor"},null,{"$f":"SUMIF(Crew!A:A,B195,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B195,Crew!N:N)","v":0}]
[null,"13G",{"$f":"VLOOKUP(LEFT(B196,3),Parameters!E:F,2,0)","v":"Dubbing Assistant"},null,{"$f":"SUMIF(Crew!A:A,B196,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B196,Crew!N:N)","v":0}]
[null,"13H",{"$f":"VLOOKUP(LEFT(B197,3),Parameters!E:F,2,0)","v":"Dubbing Mixer"},null,{"$f":"SUMIF(Crew!A:A,B197,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B197,Crew!N:N)","v":0}]
[null,"13I",{"$f":"VLOOKUP(LEFT(B198,3),Parameters!E:F,2,0)","v":"Post Production Assistant / Runner"},null,{"$f":"SUMIF(Crew!A:A,B198,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B198,Crew!N:N)","v":0}]
[null,"13J",{"$f":"VLOOKUP(LEFT(B199,3),Parameters!E:F,2,0)","v":"Transfer Assistant"},null,{"$f":"SUMIF(Crew!A:A,B199,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B199,Crew!N:N)","v":0}]
[null,"13K",{"$f":"VLOOKUP(LEFT(B200,3),Parameters!E:F,2,0)","v":"Telecine Engineer"},null,{"$f":"SUMIF(Crew!A:A,B200,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B200,Crew!N:N)","v":0}]
[null,"13L",{"$f":"VLOOKUP(LEFT(B201,3),Parameters!E:F,2,0)","v":"Captions Operator"},null,{"$f":"SUMIF(Crew!A:A,B201,Crew!F:F)","v":0},"Days",0,0,{"$f":"SUMIF(Crew!A:A,B201,Crew!N:N)","v":0}]
[null,{"$f":"B188&D202","v":"13Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H189:H201)","v":0},{"$f":"SUM(I189:I201)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I202","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I221","v":0}]
[null,"14","Materials - Art Department",null,null,null,null,{"$f":"IF(H221=0,0,\"Ep\")","v":0},{"$f":"IF(I221=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"14A",{"$f":"VLOOKUP(LEFT(B207,3),Parameters!E:F,2,0)","v":"Sets and Scenery"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I207/Eps,2)),0,ROUND(I207/Eps,2))","v":0},{"$f":"ROUND(E207*G207,2)","v":0}]
[null,"14B",{"$f":"VLOOKUP(LEFT(B208,3),Parameters!E:F,2,0)","v":"Props Purchased"},null,0,"Occ",0,0,0]
[null,"14C",{"$f":"VLOOKUP(LEFT(B209,3),Parameters!E:F,2,0)","v":"Props Hired"},null,0,"Occ",0,0,0]
[null,"14D",{"$f":"VLOOKUP(LEFT(B210,3),Parameters!E:F,2,0)","v":"Sets and Props Storage"},null,0,"Occ",0,0,0]
[null,"14E",{"$f":"VLOOKUP(LEFT(B211,3),Parameters!E:F,2,0)","v":"Sets and Props Transport"},null,0,"Occ",0,0,0]
[null,"14F",{"$f":"VLOOKUP(LEFT(B212,3),Parameters!E:F,2,0)","v":"Action Vehicles"},null,0,"Occ",0,0,0]
[null,"14G",{"$f":"VLOOKUP(LEFT(B213,3),Parameters!E:F,2,0)","v":"Special Effects - Materials - Art Dept"},null,0,"Occ",0,0,{"$f":"ROUND(E213*G213,2)","v":0}]
[null,"14H",{"$f":"VLOOKUP(LEFT(B214,3),Parameters!E:F,2,0)","v":"Star Cloth"},null,0,"Occ",0,0,0]
[null,"14I",{"$f":"VLOOKUP(LEFT(B215,3),Parameters!E:F,2,0)","v":"Scoring Equipment"},null,0,"Occ",0,0,0]
[null,"14J",{"$f":"VLOOKUP(LEFT(B216,3),Parameters!E:F,2,0)","v":"Art Department Consumables"},null,0,"Occ",0,0,0]
[null,"14K",{"$f":"VLOOKUP(LEFT(B217,3),Parameters!E:F,2,0)","v":"Animals and Handlers"},null,0,"Occ",0,0,0]
[null,"14L",{"$f":"VLOOKUP(LEFT(B218,3),Parameters!E:F,2,0)","v":"Props - Loss and Damage"},null,0,"Occ",0,0,0]
[null,"14M",{"$f":"VLOOKUP(LEFT(B219,3),Parameters!E:F,2,0)","v":"Armourer"},null,0,"Occ",0,0,{"$f":"ROUND(E219*G219,2)","v":0}]
[null,"14N",{"$f":"VLOOKUP(LEFT(B220,3),Parameters!E:F,2,0)","v":"Construction Workshop"},null,0,"Occ",0,0,{"$f":"ROUND(E220*G220,2)","v":0}]
[null,{"$f":"B205&D221","v":"14Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H206:H220)","v":0},{"$f":"SUM(I206:I220)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I221","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I235","v":0}]
[null,"15","Materials - Wardrobe / Make-Up / Hair",null,null,null,null,{"$f":"IF(H235=0,0,\"Ep\")","v":0},{"$f":"IF(I235=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"15A",{"$f":"VLOOKUP(LEFT(B226,3),Parameters!E:F,2,0)","v":"Costumes Purchased"},"supplied by little woods",0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I226/Eps,2)),0,ROUND(I226/Eps,2))","v":0},{"$f":"ROUND(E226*G226,2)","v":0}]
[null,"15B",{"$f":"VLOOKUP(LEFT(B227,3),Parameters!E:F,2,0)","v":"Costumes Hired"},null,0,"Occ",0,0,{"$f":"ROUND(E227*G227,2)","v":0}]
[null,"15C",{"$f":"VLOOKUP(LEFT(B228,3),Parameters!E:F,2,0)","v":"Costumes Sundries"},null,0,"Occ",0,0,0]
[null,"15D",{"$f":"VLOOKUP(LEFT(B229,3),Parameters!E:F,2,0)","v":"Costumes / Make-up Box Allowances"},null,0,"Occ",0,0,0]
[null,"15E",{"$f":"VLOOKUP(LEFT(B230,3),Parameters!E:F,2,0)","v":"Artist Dress Allowance"},null,0,"Occ",0,0,0]
[null,"15F",{"$f":"VLOOKUP(LEFT(B231,3),Parameters!E:F,2,0)","v":"Make-Up"},null,0,"Occ",0,0,0]
[null,"15G",{"$f":"VLOOKUP(LEFT(B232,3),Parameters!E:F,2,0)","v":"Wigs"},null,0,"Occ",0,0,0]
[null,"15H",{"$f":"VLOOKUP(LEFT(B233,3),Parameters!E:F,2,0)","v":"Hair Cuts"},null,0,"Occ",0,0,0]
[null,"15I",{"$f":"VLOOKUP(LEFT(B234,3),Parameters!E:F,2,0)","v":"Prosthetics"},null,0,"Occ",0,0,0]
[null,{"$f":"B224&D235","v":"15Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H225:H234)","v":0},{"$f":"SUM(I225:I234)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I235","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I264","v":0}]
[null,"16","Production Equipment",null,null,null,null,{"$f":"IF(H264=0,0,\"Ep\")","v":0},{"$f":"IF(I264=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"16A",{"$f":"VLOOKUP(LEFT(B240,3),Parameters!E:F,2,0)","v":"Camera Equipment"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I240/Eps,2)),0,ROUND(I240/Eps,2))","v":0},{"$f":"ROUND(E240*G240,2)","v":0}]
[null,"16B",{"$f":"VLOOKUP(LEFT(B241,3),Parameters!E:F,2,0)","v":"Steadicam"},null,0,"Occ",0,0,{"$f":"ROUND(E241*G241,2)","v":0}]
[null,"16C",{"$f":"VLOOKUP(LEFT(B242,3),Parameters!E:F,2,0)","v":"DV Hire"},null,0,"Occ",0,0,{"$f":"ROUND(E242*G242,2)","v":0}]
[null,"16D",{"$f":"VLOOKUP(LEFT(B243,3),Parameters!E:F,2,0)","v":"Camera Consumables"},null,0,"Occ",0,0,{"$f":"ROUND(E243*G243,2)","v":0}]
[null,"16E",{"$f":"VLOOKUP(LEFT(B244,3),Parameters!E:F,2,0)","v":"Grip Equipment"},null,0,"Occ",0,0,0]
[null,"16F",{"$f":"VLOOKUP(LEFT(B245,3),Parameters!E:F,2,0)","v":"Sound Equipment"},null,0,"Occ",0,0,0]
[null,"16G",{"$f":"VLOOKUP(LEFT(B246,3),Parameters!E:F,2,0)","v":"Sound Consumables"},null,0,"Occ",0,0,0]
[null,"16H",{"$f":"VLOOKUP(LEFT(B247,3),Parameters!E:F,2,0)","v":"Lighting Equipment"},null,0,"Occ",0,0,0]
[null,"16I",{"$f":"VLOOKUP(LEFT(B248,3),Parameters!E:F,2,0)","v":"HD Equipment"},null,0,"Occ",0,0,0]
[null,"16J",{"$f":"VLOOKUP(LEFT(B249,3),Parameters!E:F,2,0)","v":"Lighting Consumables"},null,0,"Occ",0,0,0]
[null,"16K",{"$f":"VLOOKUP(LEFT(B250,3),Parameters!E:F,2,0)","v":"Autocue"},null,0,"Occ",0,0,0]
[null,"16L",{"$f":"VLOOKUP(LEFT(B251,3),Parameters!E:F,2,0)","v":"Projector"},null,0,"Occ",0,0,0]
[null,"16M",{"$f":"VLOOKUP(LEFT(B252,3),Parameters!E:F,2,0)","v":"Towers & Cherry Pickers"},null,0,"Occ",0,0,0]
[null,"16N",{"$f":"VLOOKUP(LEFT(B253,3),Parameters!E:F,2,0)","v":"Techno Crane / Cranes inc Jimmy Jib"},null,0,"Occ",0,0,0]
[null,"16O",{"$f":"VLOOKUP(LEFT(B254,3),Parameters!E:F,2,0)","v":"Scaffolding"},null,0,"Occ",0,0,0]
[null,"16P",{"$f":"VLOOKUP(LEFT(B255,3),Parameters!E:F,2,0)","v":"Electrical  Equipment"},null,0,"Occ",0,0,0]
[null,"16Q",{"$f":"VLOOKUP(LEFT(B256,3),Parameters!E:F,2,0)","v":"Generators"},null,0,"Occ",0,0,0]
[null,"16R",{"$f":"VLOOKUP(LEFT(B257,3),Parameters!E:F,2,0)","v":"Walkie Talkies"},null,0,"Occ",0,0,0]
[null,"16S",{"$f":"VLOOKUP(LEFT(B258,3),Parameters!E:F,2,0)","v":"Wide Angle Lens"},null,0,"Occ",0,0,0]
[null,"16T",{"$f":"VLOOKUP(LEFT(B259,3),Parameters!E:F,2,0)","v":"Miscellaneous Production Equipment"},null,0,"Occ",0,0,0]
[null,"16U",{"$f":"VLOOKUP(LEFT(B260,3),Parameters!E:F,2,0)","v":"Jimmy Jib"},null,0,"Occ",0,0,{"$f":"ROUND(E260*G260,2)","v":0}]
[null,"16V",{"$f":"VLOOKUP(LEFT(B261,3),Parameters!E:F,2,0)","v":"Covert Filming Equipment"},null,0,"Occ",0,0,{"$f":"ROUND(E261*G261,2)","v":0}]
[null,"16W",{"$f":"VLOOKUP(LEFT(B262,3),Parameters!E:F,2,0)","v":"CGI Animation Computer Equipment"},null,0,"Occ",0,0,{"$f":"ROUND(E262*G262,2)","v":0}]
[null,"16X",{"$f":"VLOOKUP(LEFT(B263,3),Parameters!E:F,2,0)","v":"Low Loaders / A Frames"},null,0,"Occ",0,0,{"$f":"ROUND(E263*G263,2)","v":0}]
[null,{"$f":"B238&D264","v":"16Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H239:H263)","v":0},{"$f":"SUM(I239:I263)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I264","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I275","v":0}]
[null,"17","Facility Packages",null,null,null,null,{"$f":"IF(H275=0,0,\"Ep\")","v":0},{"$f":"IF(I275=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"17A",{"$f":"VLOOKUP(LEFT(B269,3),Parameters!E:F,2,0)","v":"Facility Packages"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I269/Eps,2)),0,ROUND(I269/Eps,2))","v":0},{"$f":"ROUND(E269*G269,2)","v":0}]
[null,"17B",{"$f":"VLOOKUP(LEFT(B270,3),Parameters!E:F,2,0)","v":"Camera Crews (Incl. Equipment)"},null,null,"Occ",null,0,0]
[null,"17B",{"$f":"VLOOKUP(LEFT(B271,3),Parameters!E:F,2,0)","v":"Camera Crews (Incl. Equipment)"},null,null,"Occ",null,0,0]
[null,"17C",{"$f":"VLOOKUP(LEFT(B272,3),Parameters!E:F,2,0)","v":"Video Stringers"},null,0,"Occ",0,0,0]
[null,"17D",{"$f":"VLOOKUP(LEFT(B273,3),Parameters!E:F,2,0)","v":"Second Unit"},null,0,"Occ",0,0,0]
[null,"17E",{"$f":"VLOOKUP(LEFT(B274,3),Parameters!E:F,2,0)","v":"Second Camera"},null,0,"Occ",0,0,0]
[null,{"$f":"B267&D275","v":"17Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H268:H274)","v":0},{"$f":"SUM(I268:I274)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I275","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I301","v":0}]
[null,"18","Studios / Outside Broadcast",null,null,null,null,{"$f":"IF(H301=0,0,\"Ep\")","v":0},{"$f":"IF(I301=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"18A",{"$f":"VLOOKUP(LEFT(B280,3),Parameters!E:F,2,0)","v":"Studio"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I280/Eps,2)),0,ROUND(I280/Eps,2))","v":0},{"$f":"ROUND(E280*G280,2)","v":0}]
[null,"18B",{"$f":"VLOOKUP(LEFT(B281,3),Parameters!E:F,2,0)","v":"Sound Mobile"},null,0,"Occ",0,0,{"$f":"ROUND(E281*G281,2)","v":0}]
[null,"18C",{"$f":"VLOOKUP(LEFT(B282,3),Parameters!E:F,2,0)","v":"Studio Security"},null,0,"Occ",0,0,0]
[null,"18D",{"$f":"VLOOKUP(LEFT(B283,3),Parameters!E:F,2,0)","v":"Audiences and Tickets"},null,0,"Occ",0,0,0]
[null,"18E",{"$f":"VLOOKUP(LEFT(B284,3),Parameters!E:F,2,0)","v":"VT Engineer"},null,0,"Occ",0,0,0]
[null,"18F",{"$f":"VLOOKUP(LEFT(B285,3),Parameters!E:F,2,0)","v":"Studio Crew"},null,0,"Occ",0,0,0]
[null,"18G",{"$f":"VLOOKUP(LEFT(B286,3),Parameters!E:F,2,0)","v":"Technical Supervisor"},null,0,"Occ",0,0,0]
[null,"18H",{"$f":"VLOOKUP(LEFT(B287,3),Parameters!E:F,2,0)","v":"Engineer"},null,0,"Occ",0,0,0]
[null,"18I",{"$f":"VLOOKUP(LEFT(B288,3),Parameters!E:F,2,0)","v":"Technical Assistant"},null,0,"Occ",0,0,0]
[null,"18J",{"$f":"VLOOKUP(LEFT(B289,3),Parameters!E:F,2,0)","v":"CTF / MCR Labour"},null,0,"Occ",0,0,0]
[null,"18K",{"$f":"VLOOKUP(LEFT(B290,3),Parameters!E:F,2,0)","v":"OB Unit"},null,0,"Occ",0,0,0]
[null,"18L",{"$f":"VLOOKUP(LEFT(B291,3),Parameters!E:F,2,0)","v":"OB Security"},null,0,"Occ",0,0,0]
[null,"18M",{"$f":"VLOOKUP(LEFT(B292,3),Parameters!E:F,2,0)","v":"Power"},null,0,"Occ",0,0,0]
[null,"18N",{"$f":"VLOOKUP(LEFT(B293,3),Parameters!E:F,2,0)","v":"Cranes"},null,0,"Occ",0,0,{"$f":"ROUND(E293*G293,2)","v":0}]
[null,"18O",{"$f":"VLOOKUP(LEFT(B294,3),Parameters!E:F,2,0)","v":"Air Conditioning"},null,0,"Occ",0,0,{"$f":"ROUND(E294*G294,2)","v":0}]
[null,"18P",{"$f":"VLOOKUP(LEFT(B295,3),Parameters!E:F,2,0)","v":"Waste Disposal"},null,0,"Occ",0,0,{"$f":"ROUND(E295*G295,2)","v":0}]
[null,"18Q",{"$f":"VLOOKUP(LEFT(B296,3),Parameters!E:F,2,0)","v":"Studio and OB Consumables"},null,0,"Occ",0,0,{"$f":"ROUND(E296*G296,2)","v":0}]
[null,"18R",{"$f":"VLOOKUP(LEFT(B297,3),Parameters!E:F,2,0)","v":"Water"},null,0,"Occ",0,0,0]
[null,"18S",{"$f":"VLOOKUP(LEFT(B298,3),Parameters!E:F,2,0)","v":"Commentary Positions"},null,0,"Occ",0,0,0]
[null,"18T",{"$f":"VLOOKUP(LEFT(B299,3),Parameters!E:F,2,0)","v":"Lines Bookings"},null,0,"Occ",0,0,0]
[null,"18U",{"$f":"VLOOKUP(LEFT(B300,3),Parameters!E:F,2,0)","v":"Lines Feeds"},null,0,"Occ",0,0,0]
[null,{"$f":"B278&D301","v":"18Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H279:H300)","v":0},{"$f":"SUM(I279:I300)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I301","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I326","v":0}]
[null,"19","Other Production Facilities",null,null,null,null,{"$f":"IF(H326=0,0,\"Ep\")","v":0},{"$f":"IF(I326=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"19A",{"$f":"VLOOKUP(LEFT(B306,3),Parameters!E:F,2,0)","v":"Location  Facility Fees"},"filming fees @ venues",0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I306/Eps,2)),0,ROUND(I306/Eps,2))","v":0},{"$f":"ROUND(E306*G306,2)","v":0}]
[null,"19B",{"$f":"VLOOKUP(LEFT(B307,3),Parameters!E:F,2,0)","v":"Location Security"},null,0,"Occ",0,0,{"$f":"ROUND(E307*G307,2)","v":0}]
[null,"19C",{"$f":"VLOOKUP(LEFT(B308,3),Parameters!E:F,2,0)","v":"Catering - Dining Bus / Fuel"},null,0,"Occ",0,0,0]
[null,"19D",{"$f":"VLOOKUP(LEFT(B309,3),Parameters!E:F,2,0)","v":"Catering - Meals"},null,0,"Occ",0,0,0]
[null,"19E",{"$f":"VLOOKUP(LEFT(B310,3),Parameters!E:F,2,0)","v":"Catering - Labour / Overtime"},null,0,"Occ",0,0,0]
[null,"19F",{"$f":"VLOOKUP(LEFT(B311,3),Parameters!E:F,2,0)","v":"Honey Wagon /  Portaloos"},null,0,"Occ",0,0,0]
[null,"19G",{"$f":"VLOOKUP(LEFT(B312,3),Parameters!E:F,2,0)","v":"Make-Up / Wardrobe Trailers"},null,0,"Occ",0,0,0]
[null,"19H",{"$f":"VLOOKUP(LEFT(B313,3),Parameters!E:F,2,0)","v":"Service Vehicles"},null,0,"Occ",0,0,0]
[null,"19I",{"$f":"VLOOKUP(LEFT(B314,3),Parameters!E:F,2,0)","v":"Winnebagoes"},null,0,"Occ",0,0,0]
[null,"19J",{"$f":"VLOOKUP(LEFT(B315,3),Parameters!E:F,2,0)","v":"Other Hired Transport"},null,0,"Occ",0,0,0]
[null,"19K",{"$f":"VLOOKUP(LEFT(B316,3),Parameters!E:F,2,0)","v":"Helicopter / Boat Hire"},null,0,"Occ",0,0,{"$f":"ROUND(E316*G316,2)","v":0}]
[null,"19L",{"$f":"VLOOKUP(LEFT(B317,3),Parameters!E:F,2,0)","v":"Satellite Links"},null,0,"Occ",0,0,{"$f":"ROUND(E317*G317,2)","v":0}]
[null,"19M",{"$f":"VLOOKUP(LEFT(B318,3),Parameters!E:F,2,0)","v":"Telecom Lines / Cable Fees"},null,0,"Occ",0,0,{"$f":"ROUND(E318*G318,2)","v":0}]
[null,"19N",{"$f":"VLOOKUP(LEFT(B319,3),Parameters!E:F,2,0)","v":"Playouts"},null,0,"Occ",0,0,0]
[null,"19O",{"$f":"VLOOKUP(LEFT(B320,3),Parameters!E:F,2,0)","v":"Medical / Health & Safety"},null,0,"Occ",0,0,0]
[null,"19P",{"$f":"VLOOKUP(LEFT(B321,3),Parameters!E:F,2,0)","v":"Facilities Deal"},null,0,"Occ",0,0,0]
[null,"19Q",{"$f":"VLOOKUP(LEFT(B322,3),Parameters!E:F,2,0)","v":"Facilities Fuel"},null,0,"Occ",0,0,0]
[null,"19R",{"$f":"VLOOKUP(LEFT(B323,3),Parameters!E:F,2,0)","v":"Other Hired Facilities"},null,0,"Occ",0,0,0]
[null,"19S",{"$f":"VLOOKUP(LEFT(B324,3),Parameters!E:F,2,0)","v":"Rehearsal Rooms"},null,null,"Occ",null,0,0]
[null,"19T",{"$f":"VLOOKUP(LEFT(B325,3),Parameters!E:F,2,0)","v":"Readthrough Facilities"},null,0,"Occ",0,0,0]
[null,{"$f":"B304&D326","v":"19Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H305:H325)","v":0},{"$f":"SUM(I305:I325)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I326","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I334","v":0}]
[null,"20","Film / Tape Stock",null,null,null,null,{"$f":"IF(H334=0,0,\"Ep\")","v":0},{"$f":"IF(I334=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"20A",{"$f":"VLOOKUP(LEFT(B331,3),Parameters!E:F,2,0)","v":"Tape Stock"},null,null,"Occ",null,{"$f":"IF(ISERROR(ROUND(I331/Eps,2)),0,ROUND(I331/Eps,2))","v":0},{"$f":"ROUND(E331*G331,2)","v":0}]
[null,"20B",{"$f":"VLOOKUP(LEFT(B332,3),Parameters!E:F,2,0)","v":"Film Stock"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I332/Eps,2)),0,ROUND(I332/Eps,2))","v":0},{"$f":"ROUND(E332*G332,2)","v":0}]
[null,"20C",{"$f":"VLOOKUP(LEFT(B333,3),Parameters!E:F,2,0)","v":"Sound Tape Stock"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I333/Eps,2)),0,ROUND(I333/Eps,2))","v":0},{"$f":"ROUND(E333*G333,2)","v":0}]
[null,{"$f":"B329&D334","v":"20Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H330:H333)","v":0},{"$f":"SUM(I330:I333)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I334","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I349","v":0}]
[null,"21","Animation Pre Production",null,null,null,null,{"$f":"IF(H349=0,0,\"Ep\")","v":0},{"$f":"IF(I349=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"21A",{"$f":"VLOOKUP(LEFT(B339,3),Parameters!E:F,2,0)","v":"Voice Record Studio"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I339/Eps,2)),0,ROUND(I339/Eps,2))","v":0},{"$f":"ROUND(E339*G339,2)","v":0}]
[null,"21B",{"$f":"VLOOKUP(LEFT(B340,3),Parameters!E:F,2,0)","v":"Voice Record Expenses"},null,0,"Occ",0,0,{"$f":"ROUND(E340*G340,2)","v":0}]
[null,"21C",{"$f":"VLOOKUP(LEFT(B341,3),Parameters!E:F,2,0)","v":"Cut Track"},null,0,"Occ",0,0,0]
[null,"21D",{"$f":"VLOOKUP(LEFT(B342,3),Parameters!E:F,2,0)","v":"Dialogue Assembly"},null,0,"Occ",0,0,0]
[null,"21E",{"$f":"VLOOKUP(LEFT(B343,3),Parameters!E:F,2,0)","v":"Dialogue Fine Cut"},null,0,"Occ",0,0,0]
[null,"21F",{"$f":"VLOOKUP(LEFT(B344,3),Parameters!E:F,2,0)","v":"Barsheets"},null,0,"Occ",0,0,0]
[null,"21G",{"$f":"VLOOKUP(LEFT(B345,3),Parameters!E:F,2,0)","v":"Animatics"},null,0,"Occ",0,0,0]
[null,"21H",{"$f":"VLOOKUP(LEFT(B346,3),Parameters!E:F,2,0)","v":"X-Sheets"},null,0,"Occ",0,0,{"$f":"ROUND(E346*G346,2)","v":0}]
[null,"21I",{"$f":"VLOOKUP(LEFT(B347,3),Parameters!E:F,2,0)","v":"Layouts"},null,0,"Occ",0,0,{"$f":"ROUND(E347*G347,2)","v":0}]
[null,"21J",{"$f":"VLOOKUP(LEFT(B348,3),Parameters!E:F,2,0)","v":"Slugging"},null,0,"Occ",0,0,{"$f":"ROUND(E348*G348,2)","v":0}]
[null,{"$f":"B337&D349","v":"21Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H338:H348)","v":0},{"$f":"SUM(I338:I348)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I349","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I379","v":0}]
[null,"22","Post Production",null,null,null,null,{"$f":"IF(H379=0,0,\"Ep\")","v":0},{"$f":"IF(I379=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"22A",{"$f":"VLOOKUP(LEFT(B354,3),Parameters!E:F,2,0)","v":"Logging / Digitising"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I354/Eps,2)),0,ROUND(I354/Eps,2))","v":0},{"$f":"ROUND(E354*G354,2)","v":0}]
[null,"22B",{"$f":"VLOOKUP(LEFT(B355,3),Parameters!E:F,2,0)","v":"Neg Processing / Transfer / Sync"},null,0,"Occ",0,0,{"$f":"ROUND(E355*G355,2)","v":0}]
[null,"22E",{"$f":"VLOOKUP(LEFT(B356,3),Parameters!E:F,2,0)","v":"Avid / Lightworks Offline"},null,0,"Occ",0,0,0]
[null,"22G",{"$f":"VLOOKUP(LEFT(B357,3),Parameters!E:F,2,0)","v":"Conform / Online"},null,0,"Occ",0,0,0]
[null,"22J",{"$f":"VLOOKUP(LEFT(B358,3),Parameters!E:F,2,0)","v":"Grade / Telecine"},null,0,"Occ",0,0,0]
[null,"22F",{"$f":"VLOOKUP(LEFT(B359,3),Parameters!E:F,2,0)","v":"Memory"},null,0,"Occ",0,0,0]
[null,"22C",{"$f":"VLOOKUP(LEFT(B360,3),Parameters!E:F,2,0)","v":"Avid / Lightworks Online"},null,0,"Occ",0,0,0]
[null,"22D",{"$f":"VLOOKUP(LEFT(B361,3),Parameters!E:F,2,0)","v":"Linear Online"},null,0,"Occ",0,0,0]
[null,"22H",{"$f":"VLOOKUP(LEFT(B362,3),Parameters!E:F,2,0)","v":"Negative Cutting"},null,0,"Occ",0,0,{"$f":"ROUND(E362*G362,2)","v":0}]
[null,"22I",{"$f":"VLOOKUP(LEFT(B363,3),Parameters!E:F,2,0)","v":"Sound Conform / Tracklay"},null,0,"Occ",0,0,0]
[null,"22K",{"$f":"VLOOKUP(LEFT(B364,3),Parameters!E:F,2,0)","v":"Dub / Mix"},null,0,"Occ",0,0,0]
[null,"22L",{"$f":"VLOOKUP(LEFT(B365,3),Parameters!E:F,2,0)","v":"Voice-Over / ADR"},null,0,"Occ",0,0,0]
[null,"22M",{"$f":"VLOOKUP(LEFT(B366,3),Parameters!E:F,2,0)","v":"Lay Back"},null,0,"Occ",0,0,0]
[null,"22N",{"$f":"VLOOKUP(LEFT(B367,3),Parameters!E:F,2,0)","v":"Standards Conversion"},null,0,"Occ",0,0,0]
[null,"22O",{"$f":"VLOOKUP(LEFT(B368,3),Parameters!E:F,2,0)","v":"Final Assembly"},null,0,"Occ",0,0,0]
[null,"22P",{"$f":"VLOOKUP(LEFT(B369,3),Parameters!E:F,2,0)","v":"Rostrum"},null,0,"Occ",0,0,0]
[null,"22Q",{"$f":"VLOOKUP(LEFT(B370,3),Parameters!E:F,2,0)","v":"Post Production Special Effects"},null,0,"Occ",0,0,0]
[null,"22R",{"$f":"VLOOKUP(LEFT(B371,3),Parameters!E:F,2,0)","v":"Post Production Packages"},null,0,"Occ",0,0,{"$f":"ROUND(E371*G371,2)","v":0}]
[null,"22S",{"$f":"VLOOKUP(LEFT(B372,3),Parameters!E:F,2,0)","v":"Post Production Tapes"},null,0,"Occ",0,0,{"$f":"ROUND(E372*G372,2)","v":0}]
[null,"22T",{"$f":"VLOOKUP(LEFT(B373,3),Parameters!E:F,2,0)","v":"Transfers"},null,0,"Occ",0,0,0]
[null,"22U",{"$f":"VLOOKUP(LEFT(B374,3),Parameters!E:F,2,0)","v":"Media Management"},null,0,"Occ",0,0,0]
[null,"22V",{"$f":"VLOOKUP(LEFT(B375,3),Parameters!E:F,2,0)","v":"Technical Check"},null,0,"Occ",0,0,0]
[null,"22W",{"$f":"VLOOKUP(LEFT(B376,3),Parameters!E:F,2,0)","v":"HD Facilities"},null,0,"Occ",0,0,0]
[null,"22X",{"$f":"VLOOKUP(LEFT(B377,3),Parameters!E:F,2,0)","v":"Desk Top Editing"},null,0,"Occ",0,0,0]
[null,"22Y",{"$f":"VLOOKUP(LEFT(B378,3),Parameters!E:F,2,0)","v":"International Version"},null,null,"Occ",null,0,0]
[null,{"$f":"B352&D379","v":"22Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H353:H378)","v":0},{"$f":"SUM(I353:I378)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I379","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I390","v":0}]
[null,"23","Library / Film Archive",null,null,null,null,{"$f":"IF(H390=0,0,\"Ep\")","v":0},{"$f":"IF(I390=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"23A",{"$f":"VLOOKUP(LEFT(B384,3),Parameters!E:F,2,0)","v":"Archive Royalties"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I384/Eps,2)),0,ROUND(I384/Eps,2))","v":0},{"$f":"ROUND(E384*G384,2)","v":0}]
[null,"23B",{"$f":"VLOOKUP(LEFT(B385,3),Parameters!E:F,2,0)","v":"Archive / Stills Processing"},null,0,"Occ",0,0,0]
[null,"23C",{"$f":"VLOOKUP(LEFT(B386,3),Parameters!E:F,2,0)","v":"Stills Royalties"},null,0,"Occ",0,0,0]
[null,"23D",{"$f":"VLOOKUP(LEFT(B387,3),Parameters!E:F,2,0)","v":"Library Facilities"},null,0,"Occ",0,0,0]
[null,"23E",{"$f":"VLOOKUP(LEFT(B388,3),Parameters!E:F,2,0)","v":"Research Materials"},null,0,"Occ",0,0,0]
[null,"23F",{"$f":"VLOOKUP(LEFT(B389,3),Parameters!E:F,2,0)","v":"Finders Fees"},null,0,"Occ",0,0,0]
[null,{"$f":"B382&D390","v":"23Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H383:H389)","v":0},{"$f":"SUM(I383:I389)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I390","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I402","v":0}]
[null,"24","Graphics",null,null,null,null,{"$f":"IF(H402=0,0,\"Ep\")","v":0},{"$f":"IF(I402=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"24A",{"$f":"VLOOKUP(LEFT(B395,3),Parameters!E:F,2,0)","v":"Graphics - In Programme"},null,null,"Occ",null,{"$f":"IF(ISERROR(ROUND(I395/Eps,2)),0,ROUND(I395/Eps,2))","v":0},{"$f":"ROUND(E395*G395,2)","v":0}]
[null,"24B",{"$f":"VLOOKUP(LEFT(B396,3),Parameters!E:F,2,0)","v":"Titles"},null,0,"Occ",0,0,0]
[null,"24C",{"$f":"VLOOKUP(LEFT(B397,3),Parameters!E:F,2,0)","v":"Animation"},null,0,"Occ",0,0,0]
[null,"24D",{"$f":"VLOOKUP(LEFT(B398,3),Parameters!E:F,2,0)","v":"Crew - Graphics"},null,0,"Occ",0,0,0]
[null,"24E",{"$f":"VLOOKUP(LEFT(B399,3),Parameters!E:F,2,0)","v":"Desk Top Publishing"},null,0,"Occ",0,0,0]
[null,"24F",{"$f":"VLOOKUP(LEFT(B400,3),Parameters!E:F,2,0)","v":"Rostrum"},null,0,"Occ",0,0,0]
[null,"24G",{"$f":"VLOOKUP(LEFT(B401,3),Parameters!E:F,2,0)","v":"Scoring Package"},null,0,"Occ",0,0,0]
[null,{"$f":"B393&D402","v":"24Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H394:H401)","v":0},{"$f":"SUM(I394:I401)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I402","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I420","v":0}]
[null,"25","Music",null,null,null,null,{"$f":"IF(H420=0,0,\"Ep\")","v":0},{"$f":"IF(I420=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"25A",{"$f":"VLOOKUP(LEFT(B407,3),Parameters!E:F,2,0)","v":"Composed Music"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I407/Eps,2)),0,ROUND(I407/Eps,2))","v":0},{"$f":"ROUND(E407*G407,2)","v":0}]
[null,"25B",{"$f":"VLOOKUP(LEFT(B408,3),Parameters!E:F,2,0)","v":"Musical Director"},null,0,"Occ",0,0,{"$f":"ROUND(E408*G408,2)","v":0}]
[null,"25C",{"$f":"VLOOKUP(LEFT(B409,3),Parameters!E:F,2,0)","v":"Hired Musicians"},null,0,"Occ",0,0,0]
[null,"25D",{"$f":"VLOOKUP(LEFT(B410,3),Parameters!E:F,2,0)","v":"PPL / VPL"},null,0,"Occ",0,0,0]
[null,"25E",{"$f":"VLOOKUP(LEFT(B411,3),Parameters!E:F,2,0)","v":"Signature Tune"},null,0,"Occ",0,0,0]
[null,"25F",{"$f":"VLOOKUP(LEFT(B412,3),Parameters!E:F,2,0)","v":"Recording Studios"},null,0,"Occ",0,0,0]
[null,"25G",{"$f":"VLOOKUP(LEFT(B413,3),Parameters!E:F,2,0)","v":"Tape Usage"},null,0,"Occ",0,0,0]
[null,"25H",{"$f":"VLOOKUP(LEFT(B414,3),Parameters!E:F,2,0)","v":"Instruments"},null,0,"Occ",0,0,0]
[null,"25I",{"$f":"VLOOKUP(LEFT(B415,3),Parameters!E:F,2,0)","v":"Doubling"},null,0,"Occ",0,0,0]
[null,"25J",{"$f":"VLOOKUP(LEFT(B416,3),Parameters!E:F,2,0)","v":"Porterage"},null,0,"Occ",0,0,0]
[null,"25K",{"$f":"VLOOKUP(LEFT(B417,3),Parameters!E:F,2,0)","v":"Arranging"},null,0,"Occ",0,0,{"$f":"ROUND(E417*G417,2)","v":0}]
[null,"25L",{"$f":"VLOOKUP(LEFT(B418,3),Parameters!E:F,2,0)","v":"Copying"},null,0,"Occ",0,0,{"$f":"ROUND(E418*G418,2)","v":0}]
[null,"25M",{"$f":"VLOOKUP(LEFT(B419,3),Parameters!E:F,2,0)","v":"Music - Other"},null,0,"Occ",0,0,{"$f":"ROUND(E419*G419,2)","v":0}]
[null,{"$f":"B405&D420","v":"25Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H406:H419)","v":0},{"$f":"SUM(I406:I419)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I420","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I454","v":0}]
[null,"26","Travel / Transport",null,null,null,null,{"$f":"IF(H454=0,0,\"Ep\")","v":0},{"$f":"IF(I454=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"26A",{"$f":"VLOOKUP(LEFT(B425,3),Parameters!E:F,2,0)","v":"Coach & Minibus Hire"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I425/Eps,2)),0,ROUND(I425/Eps,2))","v":0},{"$f":"ROUND(E425*G425,2)","v":0}]
[null,"26B",{"$f":"VLOOKUP(LEFT(B426,3),Parameters!E:F,2,0)","v":"Cars / Car Hire (UK)"},null,null,"Occ",null,0,0]
[null,"26C",{"$f":"VLOOKUP(LEFT(B427,3),Parameters!E:F,2,0)","v":"Fuel"},null,0,"Occ",0,0,0]
[null,"26D",{"$f":"VLOOKUP(LEFT(B428,3),Parameters!E:F,2,0)","v":"Carriage / Taxis / Bikes"},null,null,"Occ",null,0,0]
[null,"26E",{"$f":"VLOOKUP(LEFT(B429,3),Parameters!E:F,2,0)","v":"Freight, Customs & Excess Baggage"},null,0,"Occ",0,0,0]
[null,"26F",{"$f":"VLOOKUP(LEFT(B430,3),Parameters!E:F,2,0)","v":"Carnets / Permits / Visas"},null,0,"Occ",0,0,0]
[null,"26G",{"$f":"VLOOKUP(LEFT(B431,3),Parameters!E:F,2,0)","v":"UK Mileage"},null,0,"Occ",0,0,0]
[null,"26H",{"$f":"VLOOKUP(LEFT(B432,3),Parameters!E:F,2,0)","v":"UK Air Fares"},null,0,"Occ",0,0,0]
[null,"26I",{"$f":"VLOOKUP(LEFT(B433,3),Parameters!E:F,2,0)","v":"UK Rail Fares"},null,0,"Occ",0,0,0]
[null,"26J",{"$f":"VLOOKUP(LEFT(B434,3),Parameters!E:F,2,0)","v":"UK Ferries"},null,0,"Occ",0,0,0]
[null,"26K",{"$f":"VLOOKUP(LEFT(B435,3),Parameters!E:F,2,0)","v":"UK Taxis"},null,0,"Occ",0,0,{"$f":"ROUND(E435*G435,2)","v":0}]
[null,"26L",{"$f":"VLOOKUP(LEFT(B436,3),Parameters!E:F,2,0)","v":"UK Other Travel"},null,null,"Occ",null,{"$f":"IF(ISERROR(ROUND(I436/Eps,2)),0,ROUND(I436/Eps,2))","v":0},{"$f":"ROUND(E436*G436,2)","v":0}]
[null,"26L",{"$f":"VLOOKUP(LEFT(B437,3),Parameters!E:F,2,0)","v":"UK Other Travel"},null,null,"Occ",null,{"$f":"IF(ISERROR(ROUND(I437/Eps,2)),0,ROUND(I437/Eps,2))","v":0},{"$f":"ROUND(E437*G437,2)","v":0}]
[null,"26L",{"$f":"VLOOKUP(LEFT(B438,3),Parameters!E:F,2,0)","v":"UK Other Travel"},null,null,"Occ",null,{"$f":"IF(ISERROR(ROUND(I438/Eps,2)),0,ROUND(I438/Eps,2))","v":0},{"$f":"ROUND(E438*G438,2)","v":0}]
[null,"26L",{"$f":"VLOOKUP(LEFT(B439,3),Parameters!E:F,2,0)","v":"UK Other Travel"},null,null,"Occ",null,{"$f":"IF(ISERROR(ROUND(I439/Eps,2)),0,ROUND(I439/Eps,2))","v":0},{"$f":"ROUND(E439*G439,2)","v":0}]
[null,"26L",{"$f":"VLOOKUP(LEFT(B440,3),Parameters!E:F,2,0)","v":"UK Other Travel"},null,null,"Occ",null,0,0]
[null,"26M",{"$f":"VLOOKUP(LEFT(B441,3),Parameters!E:F,2,0)","v":"Overseas Air Fares"},null,0,"Occ",0,0,0]
[null,"26N",{"$f":"VLOOKUP(LEFT(B442,3),Parameters!E:F,2,0)","v":"Overseas Rail Fares"},null,0,"Occ",0,0,0]
[null,"26O",{"$f":"VLOOKUP(LEFT(B443,3),Parameters!E:F,2,0)","v":"Overseas Ferries"},null,0,"Occ",0,0,0]
[null,"26P",{"$f":"VLOOKUP(LEFT(B444,3),Parameters!E:F,2,0)","v":"Overseas Taxis"},null,0,"Occ",0,0,0]
[null,"26Q",{"$f":"VLOOKUP(LEFT(B445,3),Parameters!E:F,2,0)","v":"Overseas Car Hire"},null,0,"Occ",0,0,0]
[null,"26R",{"$f":"VLOOKUP(LEFT(B446,3),Parameters!E:F,2,0)","v":"Overseas Fuel"},null,0,"Occ",0,0,0]
[null,"26S",{"$f":"VLOOKUP(LEFT(B447,3),Parameters!E:F,2,0)","v":"Overseas Other Travel"},null,0,"Occ",0,0,0]
[null,"26T",{"$f":"VLOOKUP(LEFT(B448,3),Parameters!E:F,2,0)","v":"Awards Ceremonies Travel & Transport"},null,0,"Occ",0,0,{"$f":"ROUND(E448*G448,2)","v":0}]
[null,"26U",{"$f":"VLOOKUP(LEFT(B449,3),Parameters!E:F,2,0)","v":"Writers Expenses"},null,0,"Occ",0,0,0]
[null,"26V",{"$f":"VLOOKUP(LEFT(B450,3),Parameters!E:F,2,0)","v":"Presenters Expenses"},null,0,"Occ",0,0,0]
[null,"26W",{"$f":"VLOOKUP(LEFT(B451,3),Parameters!E:F,2,0)","v":"Performers Travel"},null,0,"Occ",0,0,{"$f":"ROUND(E451*G451,2)","v":0}]
[null,"26X",{"$f":"VLOOKUP(LEFT(B452,3),Parameters!E:F,2,0)","v":"Other Artist Expenses"},null,0,"Occ",0,0,{"$f":"ROUND(E452*G452,2)","v":0}]
[null,"26Y",{"$f":"VLOOKUP(LEFT(B453,3),Parameters!E:F,2,0)","v":"UK Parking"},null,0,"Occ",0,0,0]
[null,{"$f":"B423&D454","v":"26Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H424:H453)","v":0},{"$f":"SUM(I424:I453)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I454","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I479","v":0}]
[null,"27","Hotel / Living",null,null,null,null,{"$f":"IF(H479=0,0,\"Ep\")","v":0},{"$f":"IF(I479=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"27A",{"$f":"VLOOKUP(LEFT(B459,3),Parameters!E:F,2,0)","v":"Hospitality"},null,null,"Occ",null,{"$f":"IF(ISERROR(ROUND(I459/Eps,2)),0,ROUND(I459/Eps,2))","v":0},{"$f":"ROUND(E459*G459,2)","v":0}]
[null,"27B",{"$f":"VLOOKUP(LEFT(B460,3),Parameters!E:F,2,0)","v":"Foreign Staff Expenses"},null,0,"Occ",0,0,{"$f":"ROUND(E460*G460,2)","v":0}]
[null,"27C",{"$f":"VLOOKUP(LEFT(B461,3),Parameters!E:F,2,0)","v":"Crew Meals"},null,0,"Occ",0,0,0]
[null,"27D",{"$f":"VLOOKUP(LEFT(B462,3),Parameters!E:F,2,0)","v":"UK Accommodation Allowances"},null,0,"Occ",0,0,0]
[null,"27E",{"$f":"VLOOKUP(LEFT(B463,3),Parameters!E:F,2,0)","v":"UK Per Diems"},null,null,"Occ",null,0,0]
[null,"27F",{"$f":"VLOOKUP(LEFT(B464,3),Parameters!E:F,2,0)","v":"UK Meal Allowances"},null,0,"Occ",0,0,0]
[null,"27G",{"$f":"VLOOKUP(LEFT(B465,3),Parameters!E:F,2,0)","v":"UK Hotel Bills"},null,null,"Occ",null,0,0]
[null,"27H",{"$f":"VLOOKUP(LEFT(B466,3),Parameters!E:F,2,0)","v":"UK Meal Bills"},null,0,"Occ",0,0,0]
[null,"27I",{"$f":"VLOOKUP(LEFT(B467,3),Parameters!E:F,2,0)","v":"UK Entertaining & Gratuities"},null,0,"Occ",0,0,0]
[null,"27J",{"$f":"VLOOKUP(LEFT(B468,3),Parameters!E:F,2,0)","v":"UK Other Hotel & Living"},null,0,"Occ",0,0,0]
[null,"27K",{"$f":"VLOOKUP(LEFT(B469,3),Parameters!E:F,2,0)","v":"Overseas Accommodation Allowances"},null,0,"Occ",0,0,{"$f":"ROUND(E469*G469,2)","v":0}]
[null,"27L",{"$f":"VLOOKUP(LEFT(B470,3),Parameters!E:F,2,0)","v":"Overseas Per Diems"},null,0,"Occ",0,0,{"$f":"ROUND(E470*G470,2)","v":0}]
[null,"27M",{"$f":"VLOOKUP(LEFT(B471,3),Parameters!E:F,2,0)","v":"Overseas Meal Allowances"},null,0,"Occ",0,0,{"$f":"ROUND(E471*G471,2)","v":0}]
[null,"27N",{"$f":"VLOOKUP(LEFT(B472,3),Parameters!E:F,2,0)","v":"Overseas Hotel Bills"},null,0,"Occ",0,0,{"$f":"ROUND(E472*G472,2)","v":0}]
[null,"27O",{"$f":"VLOOKUP(LEFT(B473,3),Parameters!E:F,2,0)","v":"Overseas Meal Bills"},null,0,"Occ",0,0,0]
[null,"27P",{"$f":"VLOOKUP(LEFT(B474,3),Parameters!E:F,2,0)","v":"Overseas Entertaining & Gratuities"},null,0,"Occ",0,0,0]
[null,"27Q",{"$f":"VLOOKUP(LEFT(B475,3),Parameters!E:F,2,0)","v":"Overseas Other Hotel & Living"},null,0,"Occ",0,0,0]
[null,"27R",{"$f":"VLOOKUP(LEFT(B476,3),Parameters!E:F,2,0)","v":"Phone Expenses"},null,0,"Occ",0,0,0]
[null,"27S",{"$f":"VLOOKUP(LEFT(B477,3),Parameters!E:F,2,0)","v":"Awards Ceremonies Hotel & Living"},null,0,"Occ",0,0,0]
[null,"27T",{"$f":"VLOOKUP(LEFT(B478,3),Parameters!E:F,2,0)","v":"Performers Hotel/living"},null,0,"Occ",0,0,0]
[null,{"$f":"B457&D479","v":"27Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H458:H478)","v":0},{"$f":"SUM(I458:I478)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I479","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I504","v":0}]
[null,"28","Other Production Costs",null,null,null,null,{"$f":"IF(H504=0,0,\"Ep\")","v":0},{"$f":"IF(I504=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"28A",{"$f":"VLOOKUP(LEFT(B484,3),Parameters!E:F,2,0)","v":"Prizes"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I484/Eps,2)),0,ROUND(I484/Eps,2))","v":0},{"$f":"ROUND(E484*G484,2)","v":0}]
[null,"28B",{"$f":"VLOOKUP(LEFT(B485,3),Parameters!E:F,2,0)","v":"Surveys & Opinion Polls"},null,0,"Occ",0,0,{"$f":"ROUND(E485*G485,2)","v":0}]
[null,"28C",{"$f":"VLOOKUP(LEFT(B486,3),Parameters!E:F,2,0)","v":"Newspapers and Books"},null,0,"Occ",0,0,0]
[null,"28D",{"$f":"VLOOKUP(LEFT(B487,3),Parameters!E:F,2,0)","v":"Search Engines"},null,0,"Occ",0,0,0]
[null,"28E",{"$f":"VLOOKUP(LEFT(B488,3),Parameters!E:F,2,0)","v":"Transcriptions & Translations"},null,0,"Occ",0,0,0]
[null,"28F",{"$f":"VLOOKUP(LEFT(B489,3),Parameters!E:F,2,0)","v":"Recce Costs"},null,0,"Occ",0,0,0]
[null,"28G",{"$f":"VLOOKUP(LEFT(B490,3),Parameters!E:F,2,0)","v":"Advertising"},null,0,"Occ",0,0,0]
[null,"28H",{"$f":"VLOOKUP(LEFT(B491,3),Parameters!E:F,2,0)","v":"Cleaning"},null,0,"Occ",0,0,0]
[null,"28I",{"$f":"VLOOKUP(LEFT(B492,3),Parameters!E:F,2,0)","v":"Stationery"},null,0,"Occ",0,0,0]
[null,"28J",{"$f":"VLOOKUP(LEFT(B493,3),Parameters!E:F,2,0)","v":"Duplicating / Printing"},null,0,"Occ",0,0,0]
[null,"28K",{"$f":"VLOOKUP(LEFT(B494,3),Parameters!E:F,2,0)","v":"Office Equipment"},null,0,"Occ",0,0,{"$f":"ROUND(E494*G494,2)","v":0}]
[null,"28L",{"$f":"VLOOKUP(LEFT(B495,3),Parameters!E:F,2,0)","v":"Phones / Fax"},null,0,"Occ",0,0,{"$f":"ROUND(E495*G495,2)","v":0}]
[null,"28M",{"$f":"VLOOKUP(LEFT(B496,3),Parameters!E:F,2,0)","v":"Mobile Phones"},null,0,"Occ",0,0,{"$f":"ROUND(E496*G496,2)","v":0}]
[null,"28N",{"$f":"VLOOKUP(LEFT(B497,3),Parameters!E:F,2,0)","v":"Press / Photography"},null,0,"Occ",0,0,{"$f":"ROUND(E497*G497,2)","v":0}]
[null,"28O",{"$f":"VLOOKUP(LEFT(B498,3),Parameters!E:F,2,0)","v":"Postage"},null,0,"Occ",0,0,0]
[null,"28P",{"$f":"VLOOKUP(LEFT(B499,3),Parameters!E:F,2,0)","v":"Press Association Fees"},null,0,"Occ",0,0,0]
[null,"28Q",{"$f":"VLOOKUP(LEFT(B500,3),Parameters!E:F,2,0)","v":"Programme Back-Up"},null,0,"Occ",0,0,0]
[null,"28R",{"$f":"VLOOKUP(LEFT(B501,3),Parameters!E:F,2,0)","v":"Protective Clothing"},null,0,"Occ",0,0,{"$f":"ROUND(E501*G501,2)","v":0}]
[null,"28S",{"$f":"VLOOKUP(LEFT(B502,3),Parameters!E:F,2,0)","v":"Sundries"},null,0,"Occ",0,0,{"$f":"ROUND(E502*G502,2)","v":0}]
[null,"28T",{"$f":"VLOOKUP(LEFT(B503,3),Parameters!E:F,2,0)","v":"Newspapers & Magazines - Home Delivery"},null,0,"Occ",0,0,0]
[null,{"$f":"B482&D504","v":"28Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H483:H503)","v":0},{"$f":"SUM(I483:I503)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I504","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I516","v":0}]
[null,"29"," Finance / Legal",null,null,null,null,{"$f":"IF(H516=0,0,\"Ep\")","v":0},{"$f":"IF(I516=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"29A",{"$f":"VLOOKUP(LEFT(B509,3),Parameters!E:F,2,0)","v":"Insurance"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I509/Eps,2)),0,ROUND(I509/Eps,2))","v":0},{"$f":"ROUND(E509*G509,2)","v":0}]
[null,"29B",{"$f":"VLOOKUP(LEFT(B510,3),Parameters!E:F,2,0)","v":"Legal Fees / Services"},null,0,"Occ",0,0,0]
[null,"29C",{"$f":"VLOOKUP(LEFT(B511,3),Parameters!E:F,2,0)","v":"Compliance Costs"},null,0,"Occ",0,0,0]
[null,"29D",{"$f":"VLOOKUP(LEFT(B512,3),Parameters!E:F,2,0)","v":"Neg Checking"},null,0,"Occ",0,0,0]
[null,"29E",{"$f":"VLOOKUP(LEFT(B513,3),Parameters!E:F,2,0)","v":"Budget Preparation"},null,null,"Occ",null,0,0]
[null,"29F",{"$f":"VLOOKUP(LEFT(B514,3),Parameters!E:F,2,0)","v":"Rebate Processing"},null,0,"Occ",0,0,0]
[null,"29G",{"$f":"VLOOKUP(LEFT(B515,3),Parameters!E:F,2,0)","v":"Interest Charges / Cost Of Money"},null,0,"Occ",0,0,0]
[null,{"$f":"B507&D516","v":"29Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H508:H515)","v":0},{"$f":"SUM(I508:I515)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I516","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I529","v":0}]
[null,"30","Production Overheads",null,null,null,null,{"$f":"IF(H529=0,0,\"Ep\")","v":0},{"$f":"IF(I529=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"30A",{"$f":"VLOOKUP(LEFT(B521,3),Parameters!E:F,2,0)","v":"Production Office"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I521/Eps,2)),0,ROUND(I521/Eps,2))","v":0},{"$f":"ROUND(E521*G521,2)","v":0}]
[null,"30B",{"$f":"VLOOKUP(LEFT(B522,3),Parameters!E:F,2,0)","v":"Computer Services / IT Support"},null,0,"Occ",0,0,{"$f":"ROUND(E522*G522,2)","v":0}]
[null,"30C",{"$f":"VLOOKUP(LEFT(B523,3),Parameters!E:F,2,0)","v":"Financial Processing / Wages / Banking"},null,0,"Occ",0,0,{"$f":"ROUND(E523*G523,2)","v":0}]
[null,"30D",{"$f":"VLOOKUP(LEFT(B524,3),Parameters!E:F,2,0)","v":"Production Audit"},null,0,"Occ",0,0,0]
[null,"30E",{"$f":"VLOOKUP(LEFT(B525,3),Parameters!E:F,2,0)","v":"Production Contracts"},null,0,"Occ",0,0,0]
[null,"30F-01",{"$f":"VLOOKUP(LEFT(B526,3),Parameters!E:F,2,0)","v":"Miscellaneous Overheads"},null,0,"Occ",0,0,0]
[null,"30G",{"$f":"VLOOKUP(LEFT(B527,3),Parameters!E:F,2,0)","v":"PACT Levy"},null,0,"Occ",0,0,0]
[null,"30F-00",{"$f":"VLOOKUP(LEFT(B528,3),Parameters!E:F,2,0)","v":"Miscellaneous Overheads"},"Business Affairs Overheads",{"$f":"ROUND((Eps*Totals!E11)/60,1)","v":0},"Hours",1500,0,0]
[null,{"$f":"B519&D529","v":"30Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H520:H528)","v":0},{"$f":"SUM(I520:I528)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I529","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I536","v":0}]
[null,"31","Theatrical Performances",null,null,null,null,{"$f":"IF(H536=0,0,\"Ep\")","v":0},{"$f":"IF(I536=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"31A",{"$f":"VLOOKUP(LEFT(B534,3),Parameters!E:F,2,0)","v":"Theatre Hire"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I534/Eps,2)),0,ROUND(I534/Eps,2))","v":0},{"$f":"ROUND(E534*G534,2)","v":0}]
[null,"31B",{"$f":"VLOOKUP(LEFT(B535,3),Parameters!E:F,2,0)","v":"Theatre Contras"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I535/Eps,2)),0,ROUND(I535/Eps,2))","v":0},{"$f":"ROUND(E535*G535,2)","v":0}]
[null,{"$f":"B532&D536","v":"31Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H533:H535)","v":0},{"$f":"SUM(I533:I535)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I536","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I542","v":0}]
[null,"32","Contingency",null,null,null,null,{"$f":"IF(H542=0,0,\"Ep\")","v":0},{"$f":"IF(I542=0,0,\"Series\")","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"32A",{"$f":"VLOOKUP(LEFT(B541,3),Parameters!E:F,2,0)","v":"Contingency"},null,0,"Occ",0,{"$f":"IF(ISERROR(ROUND(I541/Eps,2)),0,ROUND(I541/Eps,2))","v":0},{"$f":"ROUND(E541*G541,2)","v":0}]
[null,{"$f":"B539&D542","v":"32Sub-Total"},null,"Sub-Total",null,null,null,{"$f":"SUM(H540:H541)","v":0},{"$f":"SUM(I540:I541)","v":0}]
[]
[null,{"$f":"\"GRAND TOTAL \"&Currency","v":"GRAND TOTAL £"},null,null,null,null,null,{"$f":"SUMIF($D$1:$D$543,\"Sub-Total\",H$1:H$543)","v":0},{"$f":"SUMIF($D$1:$D$543,\"Sub-Total\",I$1:I$543)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"IF(AND(H546=0,I546=0),\"\",\"Check against Totals page - values do not match\")","v":""},{"$f":"Totals!F53-H544","v":0},{"$f":"Totals!G53-I544","v":0}]

{"sheet":"Personnel","index":3,"n_rows":75,"n_cols":28,"rows_kept":75,"cut":false,"hidden":false,"merged":[[0,0,0,2],[2,0,2,1],[3,0,3,1],[7,0,7,1],[6,0,6,1],[29,25,30,25],[74,27,75,27],[74,16,75,16],[74,17,75,17],[74,19,75,19],[74,21,75,21],[74,23,75,23],[74,25,75,25],[29,27,30,27],[29,16,30,16],[29,23,30,23],[74,0,75,7],[74,11,75,11],[74,13,75,13],[29,21,30,21],[29,11,30,11],[29,13,30,13],[29,0,30,7],[29,17,30,17],[29,19,30,19]]}
["Personnel Breakdown",null,null,"Back to detail page"]
[]
["Prog Name:",null,{"$f":"Name","v":0}]
["Prog Number:",null,{"$f":"Number","v":0}]
["Eps:",null,{"$f":"Eps","v":0}]
[]
["Personnel Total:",null,{"$f":"AB30+AB75","v":0}]
["Personnel per ep:",null,{"$f":"IF(ISERROR(ROUND(C7/C5,2)),0,(ROUND(C7/C5,2)))","v":0}]
[]
["* Complete yellow cells *"]
[]
["Code","Full Code","Role","Name","Dates","Contract","Pension","Daily / Weekly / One Fee","Week No. From","Week\nNo. To","Weekly Rate","No. of Weeks","Daily Rate","No. of Days","One Fee",null,"Hol days inc bank hol","Hols to be taken (inc bank hol)",null,{"$f":"\"Basic - \"&Currency","v":"Basic - £"},null,{"$f":"\"NI - \"&Currency","v":"NI - £"},null,{"$f":"\"Pension - \"&Currency","v":"Pension - £"},null,{"$f":"\"Hol - \"&Currency","v":"Hol - £"},null,{"$f":"\"TOTAL COST  \"&Currency","v":"TOTAL COST  £"}]
["02","Producer/Director Salaries"]
[{"$f":"IF(ISERROR(VLOOKUP(C14,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C14,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A14=\"-\",\"-\",IF((COUNTIF($A14:$A$14,$A14)-1)<10,$A14&\"-0\"&(COUNTIF($A14:$A$14,$A14)-1),$A14&\"-\"&(COUNTIF($A14:$A$14,$A14)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(I14=0,J14=0),0,IF(J14<I14,53-I14+J14,J14-I14+1))","v":0},null,null,null,null,{"$f":"MROUND(IF(AND(F14=\"Schedule D\",H14=\"Daily\"),(N14/5)*0.54,IF(AND(F14=\"PAYE\",H14=\"Daily\"),(N14/5)*0.63,IF(AND(F14=\"Schedule D\",H14=\"Weekly\"),L14*0.54,IF(AND(F14=\"PAYE\",H14=\"Weekly\"),L14*0.63,0)))),0.5)","v":0},0,null,{"$f":"ROUND(IF($H14=\"Weekly\",($L14*$K14),IF($H14=\"Daily\",($N14*$M14),$O14)),2)","v":0},null,{"$f":"IF(ISERROR(ROUND(IF(F14=\"PAYE\",(T14+Z14)*13.8%,0),2)),0,(ROUND(IF(F14=\"PAYE\",(T14+Z14)*13.8%,0),2)))","v":0},null,{"$f":"IF(ISERROR(ROUND($T14*$G14,2)),0,ROUND($T14*$G14,2))","v":0},null,{"$f":"IF(ISERROR(ROUND((IF($F14=\"Schedule D\",($T14*10.77%)/Q14*(Q14-R14),IF($F14=\"PAYE\",($T14*12.69%)/Q14*(Q14-R14),0))),2)),0,(ROUND((IF($F14=\"Schedule D\",($T14*10.77%)/Q14*(Q14-R14),IF($F14=\"PAYE\",($T14*12.69%)/Q14*(Q14-R14),0))),2)))","v":0},null,{"$f":"T14+V14+X14+Z14","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C15,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C15,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A15=\"-\",\"-\",IF((COUNTIF($A$15:$A15,$A15)-1)<10,$A15&\"-0\"&(COUNTIF($A$15:$A15,$A15)-1),$A15&\"-\"&(COUNTIF($A$15:$A15,$A15)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(I15=0,J15=0),0,IF(J15<I15,53-I15+J15,J15-I15+1))","v":0},null,null,null,null,0,0,null,{"$f":"ROUND(IF($H15=\"Weekly\",($L15*$K15),IF($H15=\"Daily\",($N15*$M15),$O15)),2)","v":0},null,{"$f":"IF(ISERROR(ROUND(IF(F15=\"PAYE\",(T15+Z15)*13.8%,0),2)),0,(ROUND(IF(F15=\"PAYE\",(T15+Z15)*13.8%,0),2)))","v":0},null,{"$f":"IF(ISERROR(ROUND($T15*$G15,2)),0,ROUND($T15*$G15,2))","v":0},null,{"$f":"IF(ISERROR(ROUND((IF($F15=\"Schedule D\",($T15*10.77%)/Q15*(Q15-R15),IF($F15=\"PAYE\",($T15*12.69%)/Q15*(Q15-R15),0))),2)),0,(ROUND((IF($F15=\"Schedule D\",($T15*10.77%)/Q15*(Q15-R15),IF($F15=\"PAYE\",($T15*12.69%)/Q15*(Q15-R15),0))),2)))","v":0},null,{"$f":"T15+V15+X15+Z15","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C16,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C16,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A16=\"-\",\"-\",IF((COUNTIF($A$15:$A16,$A16)-1)<10,$A16&\"-0\"&(COUNTIF($A$15:$A16,$A16)-1),$A16&\"-\"&(COUNTIF($A$15:$A16,$A16)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(I16=0,J16=0),0,IF(J16<I16,53-I16+J16,J16-I16+1))","v":0},null,null,null,null,0,0,null,0,null,{"$f":"IF(ISERROR(ROUND(IF(F16=\"PAYE\",(T16+Z16)*13.8%,0),2)),0,(ROUND(IF(F16=\"PAYE\",(T16+Z16)*13.8%,0),2)))","v":0},null,0,null,{"$f":"IF(ISERROR(ROUND((IF($F16=\"Schedule D\",($T16*10.77%)/Q16*(Q16-R16),IF($F16=\"PAYE\",($T16*12.69%)/Q16*(Q16-R16),0))),2)),0,(ROUND((IF($F16=\"Schedule D\",($T16*10.77%)/Q16*(Q16-R16),IF($F16=\"PAYE\",($T16*12.69%)/Q16*(Q16-R16),0))),2)))","v":0},null,{"$f":"T16+V16+X16+Z16","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C17,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C17,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A17=\"-\",\"-\",IF((COUNTIF($A$15:$A17,$A17)-1)<10,$A17&\"-0\"&(COUNTIF($A$15:$A17,$A17)-1),$A17&\"-\"&(COUNTIF($A$15:$A17,$A17)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C18,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C18,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A18=\"-\",\"-\",IF((COUNTIF($A$15:$A18,$A18)-1)<10,$A18&\"-0\"&(COUNTIF($A$15:$A18,$A18)-1),$A18&\"-\"&(COUNTIF($A$15:$A18,$A18)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C19,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C19,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A19=\"-\",\"-\",IF((COUNTIF($A$15:$A19,$A19)-1)<10,$A19&\"-0\"&(COUNTIF($A$15:$A19,$A19)-1),$A19&\"-\"&(COUNTIF($A$15:$A19,$A19)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C20,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C20,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A20=\"-\",\"-\",IF((COUNTIF($A$15:$A20,$A20)-1)<10,$A20&\"-0\"&(COUNTIF($A$15:$A20,$A20)-1),$A20&\"-\"&(COUNTIF($A$15:$A20,$A20)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C21,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C21,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A21=\"-\",\"-\",IF((COUNTIF($A$15:$A21,$A21)-1)<10,$A21&\"-0\"&(COUNTIF($A$15:$A21,$A21)-1),$A21&\"-\"&(COUNTIF($A$15:$A21,$A21)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C22,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C22,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A22=\"-\",\"-\",IF((COUNTIF($A$15:$A22,$A22)-1)<10,$A22&\"-0\"&(COUNTIF($A$15:$A22,$A22)-1),$A22&\"-\"&(COUNTIF($A$15:$A22,$A22)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C23,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C23,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A23=\"-\",\"-\",IF((COUNTIF($A$15:$A23,$A23)-1)<10,$A23&\"-0\"&(COUNTIF($A$15:$A23,$A23)-1),$A23&\"-\"&(COUNTIF($A$15:$A23,$A23)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C24,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C24,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A24=\"-\",\"-\",IF((COUNTIF($A$15:$A24,$A24)-1)<10,$A24&\"-0\"&(COUNTIF($A$15:$A24,$A24)-1),$A24&\"-\"&(COUNTIF($A$15:$A24,$A24)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C25,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C25,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A25=\"-\",\"-\",IF((COUNTIF($A$15:$A25,$A25)-1)<10,$A25&\"-0\"&(COUNTIF($A$15:$A25,$A25)-1),$A25&\"-\"&(COUNTIF($A$15:$A25,$A25)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C26,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C26,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A26=\"-\",\"-\",IF((COUNTIF($A$15:$A26,$A26)-1)<10,$A26&\"-0\"&(COUNTIF($A$15:$A26,$A26)-1),$A26&\"-\"&(COUNTIF($A$15:$A26,$A26)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C27,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C27,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A27=\"-\",\"-\",IF((COUNTIF($A$15:$A27,$A27)-1)<10,$A27&\"-0\"&(COUNTIF($A$15:$A27,$A27)-1),$A27&\"-\"&(COUNTIF($A$15:$A27,$A27)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C28,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C28,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A28=\"-\",\"-\",IF((COUNTIF($A$15:$A28,$A28)-1)<10,$A28&\"-0\"&(COUNTIF($A$15:$A28,$A28)-1),$A28&\"-\"&(COUNTIF($A$15:$A28,$A28)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C29,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C29,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A29=\"-\",\"-\",IF((COUNTIF($A$15:$A29,$A29)-1)<10,$A29&\"-0\"&(COUNTIF($A$15:$A29,$A29)-1),$A29&\"-\"&(COUNTIF($A$15:$A29,$A29)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"A13&\" TOTALS\"","v":"02 TOTALS"},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L13:L29)","v":0},null,{"$f":"SUM(N13:N29)","v":0},null,null,{"$f":"SUM(Q13:Q29)","v":0},{"$f":"SUM(R13:R29)","v":0},null,{"$f":"SUM(T13:T29)","v":0},null,{"$f":"SUM(V13:V29)","v":0},null,{"$f":"SUM(X13:X29)","v":0},null,{"$f":"SUM(Z13:Z29)","v":0},null,{"$f":"ROUND(SUM(AB13:AB29),2)","v":0}]
[]
[]
[]
["Code","Full Code","Role","Name","Dates","Contract","Pension","Daily / Weekly / One Fee","Week No. From","Week\nNo. To","Weekly Rate","No. of Weeks","Daily Rate","No. of Days","One Fee",null,"Hol days inc bank hol","Hols to be taken (inc bank hol)",null,{"$f":"\"Basic - \"&Currency","v":"Basic - £"},null,{"$f":"\"NI - \"&Currency","v":"NI - £"},null,{"$f":"\"Pension - \"&Currency","v":"Pension - £"},null,{"$f":"\"Hol - \"&Currency","v":"Hol - £"},null,{"$f":"\"TOTAL COST  \"&Currency","v":"TOTAL COST  £"}]
["05","Production Unit Salaries"]
[{"$f":"IF(ISERROR(VLOOKUP(C36,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C36,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A36=\"-\",\"-\",IF((COUNTIF($A$36:$A36,$A36)-1)<10,$A36&\"-0\"&(COUNTIF($A$36:$A36,$A36)-1),$A36&\"-\"&(COUNTIF($A$36:$A36,$A36)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(I36=0,J36=0),0,IF(J36<I36,53-I36+J36,J36-I36+1))","v":0},null,null,null,null,{"$f":"MROUND(IF(AND(F36=\"Schedule D\",H36=\"Daily\"),(N36/5)*0.54,IF(AND(F36=\"PAYE\",H36=\"Daily\"),(N36/5)*0.63,IF(AND(F36=\"Schedule D\",H36=\"Weekly\"),L36*0.54,IF(AND(F36=\"PAYE\",H36=\"Weekly\"),L36*0.63,0)))),0.5)","v":0},0,null,{"$f":"ROUND(IF($H36=\"Weekly\",($L36*$K36),IF($H36=\"Daily\",($N36*$M36),$O36)),2)","v":0},null,{"$f":"IF(ISERROR(ROUND(IF(F36=\"PAYE\",(T36+Z36)*13.8%,0),2)),0,(ROUND(IF(F36=\"PAYE\",(T36+Z36)*13.8%,0),2)))","v":0},null,{"$f":"IF(ISERROR(ROUND($T36*$G36,2)),0,ROUND($T36*$G36,2))","v":0},null,{"$f":"IF(ISERROR(ROUND((IF($F36=\"Schedule D\",($T36*10.77%)/Q36*(Q36-R36),IF($F36=\"PAYE\",($T36*12.69%)/Q36*(Q36-R36),0))),2)),0,(ROUND((IF($F36=\"Schedule D\",($T36*10.77%)/Q36*(Q36-R36),IF($F36=\"PAYE\",($T36*12.69%)/Q36*(Q36-R36),0))),2)))","v":0},null,{"$f":"T36+V36+X36+Z36","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C37,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C37,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A37=\"-\",\"-\",IF((COUNTIF($A$36:$A37,$A37)-1)<10,$A37&\"-0\"&(COUNTIF($A$36:$A37,$A37)-1),$A37&\"-\"&(COUNTIF($A$36:$A37,$A37)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(I37=0,J37=0),0,IF(J37<I37,53-I37+J37,J37-I37+1))","v":0},null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,{"$f":"T37+V37+X37+Z37","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C38,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C38,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A38=\"-\",\"-\",IF((COUNTIF($A$36:$A38,$A38)-1)<10,$A38&\"-0\"&(COUNTIF($A$36:$A38,$A38)-1),$A38&\"-\"&(COUNTIF($A$36:$A38,$A38)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(I38=0,J38=0),0,IF(J38<I38,53-I38+J38,J38-I38+1))","v":0},null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,{"$f":"T38+V38+X38+Z38","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C39,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C39,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A39=\"-\",\"-\",IF((COUNTIF($A$36:$A39,$A39)-1)<10,$A39&\"-0\"&(COUNTIF($A$36:$A39,$A39)-1),$A39&\"-\"&(COUNTIF($A$36:$A39,$A39)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C40,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C40,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A40=\"-\",\"-\",IF((COUNTIF($A$36:$A40,$A40)-1)<10,$A40&\"-0\"&(COUNTIF($A$36:$A40,$A40)-1),$A40&\"-\"&(COUNTIF($A$36:$A40,$A40)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C41,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C41,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A41=\"-\",\"-\",IF((COUNTIF($A$36:$A41,$A41)-1)<10,$A41&\"-0\"&(COUNTIF($A$36:$A41,$A41)-1),$A41&\"-\"&(COUNTIF($A$36:$A41,$A41)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C42,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C42,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A42=\"-\",\"-\",IF((COUNTIF($A$36:$A42,$A42)-1)<10,$A42&\"-0\"&(COUNTIF($A$36:$A42,$A42)-1),$A42&\"-\"&(COUNTIF($A$36:$A42,$A42)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C43,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C43,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A43=\"-\",\"-\",IF((COUNTIF($A$36:$A43,$A43)-1)<10,$A43&\"-0\"&(COUNTIF($A$36:$A43,$A43)-1),$A43&\"-\"&(COUNTIF($A$36:$A43,$A43)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C44,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C44,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A44=\"-\",\"-\",IF((COUNTIF($A$36:$A44,$A44)-1)<10,$A44&\"-0\"&(COUNTIF($A$36:$A44,$A44)-1),$A44&\"-\"&(COUNTIF($A$36:$A44,$A44)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C45,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C45,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A45=\"-\",\"-\",IF((COUNTIF($A$36:$A45,$A45)-1)<10,$A45&\"-0\"&(COUNTIF($A$36:$A45,$A45)-1),$A45&\"-\"&(COUNTIF($A$36:$A45,$A45)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C46,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C46,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A46=\"-\",\"-\",IF((COUNTIF($A$36:$A46,$A46)-1)<10,$A46&\"-0\"&(COUNTIF($A$36:$A46,$A46)-1),$A46&\"-\"&(COUNTIF($A$36:$A46,$A46)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C47,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C47,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A47=\"-\",\"-\",IF((COUNTIF($A$36:$A47,$A47)-1)<10,$A47&\"-0\"&(COUNTIF($A$36:$A47,$A47)-1),$A47&\"-\"&(COUNTIF($A$36:$A47,$A47)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(I47=0,J47=0),0,IF(J47<I47,53-I47+J47,J47-I47+1))","v":0},null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,{"$f":"T47+V47+X47+Z47","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C48,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C48,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A48=\"-\",\"-\",IF((COUNTIF($A$36:$A48,$A48)-1)<10,$A48&\"-0\"&(COUNTIF($A$36:$A48,$A48)-1),$A48&\"-\"&(COUNTIF($A$36:$A48,$A48)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C49,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C49,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A49=\"-\",\"-\",IF((COUNTIF($A$36:$A49,$A49)-1)<10,$A49&\"-0\"&(COUNTIF($A$36:$A49,$A49)-1),$A49&\"-\"&(COUNTIF($A$36:$A49,$A49)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C50,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C50,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A50=\"-\",\"-\",IF((COUNTIF($A$36:$A50,$A50)-1)<10,$A50&\"-0\"&(COUNTIF($A$36:$A50,$A50)-1),$A50&\"-\"&(COUNTIF($A$36:$A50,$A50)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C51,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C51,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A51=\"-\",\"-\",IF((COUNTIF($A$36:$A51,$A51)-1)<10,$A51&\"-0\"&(COUNTIF($A$36:$A51,$A51)-1),$A51&\"-\"&(COUNTIF($A$36:$A51,$A51)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C52,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C52,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A52=\"-\",\"-\",IF((COUNTIF($A$36:$A52,$A52)-1)<10,$A52&\"-0\"&(COUNTIF($A$36:$A52,$A52)-1),$A52&\"-\"&(COUNTIF($A$36:$A52,$A52)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C53,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C53,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A53=\"-\",\"-\",IF((COUNTIF($A$36:$A53,$A53)-1)<10,$A53&\"-0\"&(COUNTIF($A$36:$A53,$A53)-1),$A53&\"-\"&(COUNTIF($A$36:$A53,$A53)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C54,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C54,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A54=\"-\",\"-\",IF((COUNTIF($A$36:$A54,$A54)-1)<10,$A54&\"-0\"&(COUNTIF($A$36:$A54,$A54)-1),$A54&\"-\"&(COUNTIF($A$36:$A54,$A54)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C55,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C55,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A55=\"-\",\"-\",IF((COUNTIF($A$36:$A55,$A55)-1)<10,$A55&\"-0\"&(COUNTIF($A$36:$A55,$A55)-1),$A55&\"-\"&(COUNTIF($A$36:$A55,$A55)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C56,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C56,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A56=\"-\",\"-\",IF((COUNTIF($A$36:$A56,$A56)-1)<10,$A56&\"-0\"&(COUNTIF($A$36:$A56,$A56)-1),$A56&\"-\"&(COUNTIF($A$36:$A56,$A56)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C57,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C57,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A57=\"-\",\"-\",IF((COUNTIF($A$36:$A57,$A57)-1)<10,$A57&\"-0\"&(COUNTIF($A$36:$A57,$A57)-1),$A57&\"-\"&(COUNTIF($A$36:$A57,$A57)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C58,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C58,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A58=\"-\",\"-\",IF((COUNTIF($A$36:$A58,$A58)-1)<10,$A58&\"-0\"&(COUNTIF($A$36:$A58,$A58)-1),$A58&\"-\"&(COUNTIF($A$36:$A58,$A58)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C59,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C59,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A59=\"-\",\"-\",IF((COUNTIF($A$36:$A59,$A59)-1)<10,$A59&\"-0\"&(COUNTIF($A$36:$A59,$A59)-1),$A59&\"-\"&(COUNTIF($A$36:$A59,$A59)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C60,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C60,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A60=\"-\",\"-\",IF((COUNTIF($A$36:$A60,$A60)-1)<10,$A60&\"-0\"&(COUNTIF($A$36:$A60,$A60)-1),$A60&\"-\"&(COUNTIF($A$36:$A60,$A60)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C61,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C61,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A61=\"-\",\"-\",IF((COUNTIF($A$36:$A61,$A61)-1)<10,$A61&\"-0\"&(COUNTIF($A$36:$A61,$A61)-1),$A61&\"-\"&(COUNTIF($A$36:$A61,$A61)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C62,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C62,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A62=\"-\",\"-\",IF((COUNTIF($A$36:$A62,$A62)-1)<10,$A62&\"-0\"&(COUNTIF($A$36:$A62,$A62)-1),$A62&\"-\"&(COUNTIF($A$36:$A62,$A62)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C63,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C63,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A63=\"-\",\"-\",IF((COUNTIF($A$36:$A63,$A63)-1)<10,$A63&\"-0\"&(COUNTIF($A$36:$A63,$A63)-1),$A63&\"-\"&(COUNTIF($A$36:$A63,$A63)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C64,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C64,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A64=\"-\",\"-\",IF((COUNTIF($A$36:$A64,$A64)-1)<10,$A64&\"-0\"&(COUNTIF($A$36:$A64,$A64)-1),$A64&\"-\"&(COUNTIF($A$36:$A64,$A64)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C65,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C65,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A65=\"-\",\"-\",IF((COUNTIF($A$36:$A65,$A65)-1)<10,$A65&\"-0\"&(COUNTIF($A$36:$A65,$A65)-1),$A65&\"-\"&(COUNTIF($A$36:$A65,$A65)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C66,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C66,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A66=\"-\",\"-\",IF((COUNTIF($A$36:$A66,$A66)-1)<10,$A66&\"-0\"&(COUNTIF($A$36:$A66,$A66)-1),$A66&\"-\"&(COUNTIF($A$36:$A66,$A66)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C67,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C67,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A67=\"-\",\"-\",IF((COUNTIF($A$36:$A67,$A67)-1)<10,$A67&\"-0\"&(COUNTIF($A$36:$A67,$A67)-1),$A67&\"-\"&(COUNTIF($A$36:$A67,$A67)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C68,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C68,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A68=\"-\",\"-\",IF((COUNTIF($A$36:$A68,$A68)-1)<10,$A68&\"-0\"&(COUNTIF($A$36:$A68,$A68)-1),$A68&\"-\"&(COUNTIF($A$36:$A68,$A68)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C69,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C69,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A69=\"-\",\"-\",IF((COUNTIF($A$36:$A69,$A69)-1)<10,$A69&\"-0\"&(COUNTIF($A$36:$A69,$A69)-1),$A69&\"-\"&(COUNTIF($A$36:$A69,$A69)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C70,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C70,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A70=\"-\",\"-\",IF((COUNTIF($A$36:$A70,$A70)-1)<10,$A70&\"-0\"&(COUNTIF($A$36:$A70,$A70)-1),$A70&\"-\"&(COUNTIF($A$36:$A70,$A70)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C71,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C71,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A71=\"-\",\"-\",IF((COUNTIF($A$36:$A71,$A71)-1)<10,$A71&\"-0\"&(COUNTIF($A$36:$A71,$A71)-1),$A71&\"-\"&(COUNTIF($A$36:$A71,$A71)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C72,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C72,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A72=\"-\",\"-\",IF((COUNTIF($A$36:$A72,$A72)-1)<10,$A72&\"-0\"&(COUNTIF($A$36:$A72,$A72)-1),$A72&\"-\"&(COUNTIF($A$36:$A72,$A72)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C73,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C73,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A73=\"-\",\"-\",IF((COUNTIF($A$36:$A73,$A73)-1)<10,$A73&\"-0\"&(COUNTIF($A$36:$A73,$A73)-1),$A73&\"-\"&(COUNTIF($A$36:$A73,$A73)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"IF(ISERROR(VLOOKUP(C74,Parameters!$B:$C,2,0)),\"-\",VLOOKUP(C74,Parameters!$B:$C,2,0))","v":"-"},{"$f":"IF($A74=\"-\",\"-\",IF((COUNTIF($A$36:$A74,$A74)-1)<10,$A74&\"-0\"&(COUNTIF($A$36:$A74,$A74)-1),$A74&\"-\"&(COUNTIF($A$36:$A74,$A74)-1)))","v":"-"},null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"A35&\" TOTALS\"","v":"05 TOTALS"},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L35:L74)","v":0},null,{"$f":"SUM(N35:N74)","v":0},null,null,{"$f":"SUM(Q35:Q74)","v":0},{"$f":"SUM(R35:R74)","v":0},null,{"$f":"SUM(T35:T74)","v":0},null,{"$f":"SUM(V35:V74)","v":0},null,{"$f":"SUM(X35:X74)","v":0},null,{"$f":"SUM(Z35:Z74)","v":0},null,{"$f":"ROUND(SUM(AB35:AB74),2)","v":0}]

{"sheet":"Crew","index":4,"n_rows":152,"n_cols":15,"rows_kept":152,"cut":false,"hidden":false,"merged":[[7,0,7,1],[19,9,20,9],[0,0,0,2],[2,0,2,1],[3,0,3,1],[6,0,6,1],[19,11,20,11],[19,13,20,13],[19,0,20,7],[38,0,39,7],[38,9,39,9],[38,11,39,11],[38,13,39,13],[51,0,52,7],[51,9,52,9],[51,11,52,11],[51,13,52,13],[66,0,67,7],[66,9,67,9],[66,11,67,11],[66,13,67,13],[96,0,97,7],[96,9,97,9],[96,11,97,11],[96,13,97,13],[115,0,116,7],[115,9,116,9],[115,11,116,11],[115,13,116,13],[128,0,129,7],[128,9,129,9],[128,11,129,11],[128,13,129,13],[147,0,148,7],[147,9,148,9],[147,11,148,11],[147,13,148,13]]}
["Crew Breakdown"]
["Back to Detail Page"]
["Prog Name:",null,{"$f":"Name","v":0}]
["Prog Number:",null,{"$f":"Number","v":0}]
["Eps:",null,{"$f":"Eps","v":0}]
[]
[{"$f":"\"Crew Tot (\"&Currency&\"):\"","v":"Crew Tot (£):"},null,{"$f":"SUM(N:N)/2","v":0}]
[{"$f":"\"Crew per ep (\"&Currency&\"):\"","v":"Crew per ep (£):"},null,{"$f":"IF(ISERROR(ROUND(C7/C5,2)),0,(ROUND(C7/C5,2)))","v":0}]
[]
[]
["Code","Full Code","Role","Name","Dates","No. Of Days","Daily Rate","Nat Ins @ 13.8%?",null,{"$f":"\"Basic - \"&Currency","v":"Basic - £"},null,{"$f":"\"NI - \"&Currency","v":"NI - £"},null,{"$f":"\"Total - \"&Currency","v":"Total - £"},"Filter"]
["06 -","ASSISTANT DIRECTORS/CONTINUITY",null,null,null,null,null,null,null,"Basic",null,{"$f":"L11","v":"NI - £"},null,{"$f":"N11","v":"Total - £"},{"$f":"IF(N20=0,0,1)","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C13,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C13,Parameters!$F:$G,2,0))","v":"06A"},{"$f":"IF($A13=\"-\",\"-\",IF((COUNTIF($A$13:$A13,$A13)-1)<10,$A13&\"-0\"&(COUNTIF($A$13:$A13,$A13)-1),$A13&\"-\"&(COUNTIF($A$13:$A13,$A13)-1)))","v":"06A-00"},"1st Assistant Director",null,null,null,null,null,null,{"$f":"ROUND(F13*G13,2)","v":0},null,{"$f":"ROUND(IF(H13=\"Yes\",J13*13.8%,0),2)","v":0},null,{"$f":"J13+L13","v":0},{"$f":"IF(N13=0,0,1)","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C14,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C14,Parameters!$F:$G,2,0))","v":"06B"},{"$f":"IF($A14=\"-\",\"-\",IF((COUNTIF($A$13:$A14,$A14)-1)<10,$A14&\"-0\"&(COUNTIF($A$13:$A14,$A14)-1),$A14&\"-\"&(COUNTIF($A$13:$A14,$A14)-1)))","v":"06B-00"},"2nd Assistant Director",null,null,null,null,null,null,{"$f":"ROUND(F14*G14,2)","v":0},null,{"$f":"ROUND(IF(H14=\"Yes\",J14*13.8%,0),2)","v":0},null,{"$f":"J14+L14","v":0},{"$f":"IF(N14=0,0,1)","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C15,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C15,Parameters!$F:$G,2,0))","v":"06C"},{"$f":"IF($A15=\"-\",\"-\",IF((COUNTIF($A$13:$A15,$A15)-1)<10,$A15&\"-0\"&(COUNTIF($A$13:$A15,$A15)-1),$A15&\"-\"&(COUNTIF($A$13:$A15,$A15)-1)))","v":"06C-00"},"3rd Assistant Director",null,null,null,null,null,null,{"$f":"ROUND(F15*G15,2)","v":0},null,{"$f":"ROUND(IF(H15=\"Yes\",J15*13.8%,0),2)","v":0},null,{"$f":"J15+L15","v":0},0]
[{"$f":"IF(ISERROR(VLOOKUP(C16,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C16,Parameters!$F:$G,2,0))","v":"06D"},{"$f":"IF($A16=\"-\",\"-\",IF((COUNTIF($A$13:$A16,$A16)-1)<10,$A16&\"-0\"&(COUNTIF($A$13:$A16,$A16)-1),$A16&\"-\"&(COUNTIF($A$13:$A16,$A16)-1)))","v":"06D-00"},"Floor Manager",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C17,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C17,Parameters!$F:$G,2,0))","v":"06E"},{"$f":"IF($A17=\"-\",\"-\",IF((COUNTIF($A$13:$A17,$A17)-1)<10,$A17&\"-0\"&(COUNTIF($A$13:$A17,$A17)-1),$A17&\"-\"&(COUNTIF($A$13:$A17,$A17)-1)))","v":"06E-00"},"Assistant Floor Manager",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C18,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C18,Parameters!$F:$G,2,0))","v":"06F"},{"$f":"IF($A18=\"-\",\"-\",IF((COUNTIF($A$13:$A18,$A18)-1)<10,$A18&\"-0\"&(COUNTIF($A$13:$A18,$A18)-1),$A18&\"-\"&(COUNTIF($A$13:$A18,$A18)-1)))","v":"06F-00"},"Location / Production Runner",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C19,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C19,Parameters!$F:$G,2,0))","v":"06G"},{"$f":"IF($A19=\"-\",\"-\",IF((COUNTIF($A$13:$A19,$A19)-1)<10,$A19&\"-0\"&(COUNTIF($A$13:$A19,$A19)-1),$A19&\"-\"&(COUNTIF($A$13:$A19,$A19)-1)))","v":"06G-00"},"Continuity / Script Supervisor",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"A12&\" TOTAL\"","v":"06 - TOTAL"},null,null,null,null,null,null,null,null,{"$f":"SUM(J12:J19)","v":0},null,{"$f":"SUM(L12:L19)","v":0},null,{"$f":"SUM(N12:N19)","v":0},{"$f":"IF(N20=0,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O20","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J20","v":0},null,null,null,null,{"$f":"IF(N20=0,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J22","v":0},null,null,null,null,{"$f":"O22","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J23","v":0},null,null,null,null,{"$f":"O23","v":0}]
["Code","Full Code","Role","Name","Dates","No. Of Days","Daily Rate","Nat Ins @ 13.8%?",null,{"$f":"\"Basic - \"&Currency","v":"Basic - £"},null,{"$f":"\"NI - \"&Currency","v":"NI - £"},null,{"$f":"\"Total - \"&Currency","v":"Total - £"},{"$f":"IF(N39=0,0,1)","v":0}]
["07-","CREW - CAMERA",null,null,null,null,null,null,null,"Basic",null,null,null,null,{"$f":"O25","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C27,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C27,Parameters!$F:$G,2,0))","v":"07A"},{"$f":"IF($A27=\"-\",\"-\",IF((COUNTIF($A$27:$A27,$A27)-1)<10,$A27&\"-0\"&(COUNTIF($A$27:$A27,$A27)-1),$A27&\"-\"&(COUNTIF($A$27:$A27,$A27)-1)))","v":"07A-00"},"Director of Photography",null,null,null,null,null,null,{"$f":"ROUND(F27*G27,2)","v":0},null,{"$f":"ROUND(IF(H27=\"Yes\",J27*13.8%,0),2)","v":0},null,{"$f":"J27+L27","v":0},{"$f":"IF(N27=0,0,1)","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C28,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C28,Parameters!$F:$G,2,0))","v":"07B"},{"$f":"IF($A28=\"-\",\"-\",IF((COUNTIF($A$27:$A28,$A28)-1)<10,$A28&\"-0\"&(COUNTIF($A$27:$A28,$A28)-1),$A28&\"-\"&(COUNTIF($A$27:$A28,$A28)-1)))","v":"07B-00"},"Camera Supervisor",null,null,null,null,null,null,{"$f":"ROUND(F28*G28,2)","v":0},null,{"$f":"ROUND(IF(H28=\"Yes\",J28*13.8%,0),2)","v":0},null,{"$f":"J28+L28","v":0},{"$f":"IF(N28=0,0,1)","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C29,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C29,Parameters!$F:$G,2,0))","v":"07C"},{"$f":"IF($A29=\"-\",\"-\",IF((COUNTIF($A$27:$A29,$A29)-1)<10,$A29&\"-0\"&(COUNTIF($A$27:$A29,$A29)-1),$A29&\"-\"&(COUNTIF($A$27:$A29,$A29)-1)))","v":"07C-00"},"Camera Operator",null,null,null,null,null,null,{"$f":"ROUND(F29*G29,2)","v":0},null,{"$f":"ROUND(IF(H29=\"Yes\",J29*13.8%,0),2)","v":0},null,{"$f":"J29+L29","v":0},0]
[{"$f":"IF(ISERROR(VLOOKUP(C30,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C30,Parameters!$F:$G,2,0))","v":"07D"},{"$f":"IF($A30=\"-\",\"-\",IF((COUNTIF($A$27:$A30,$A30)-1)<10,$A30&\"-0\"&(COUNTIF($A$27:$A30,$A30)-1),$A30&\"-\"&(COUNTIF($A$27:$A30,$A30)-1)))","v":"07D-00"},"HD Camera Operator",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C31,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C31,Parameters!$F:$G,2,0))","v":"07E"},{"$f":"IF($A31=\"-\",\"-\",IF((COUNTIF($A$27:$A31,$A31)-1)<10,$A31&\"-0\"&(COUNTIF($A$27:$A31,$A31)-1),$A31&\"-\"&(COUNTIF($A$27:$A31,$A31)-1)))","v":"07E-00"},"Camera Assistant / Trainee",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C32,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C32,Parameters!$F:$G,2,0))","v":"07F"},{"$f":"IF($A32=\"-\",\"-\",IF((COUNTIF($A$27:$A32,$A32)-1)<10,$A32&\"-0\"&(COUNTIF($A$27:$A32,$A32)-1),$A32&\"-\"&(COUNTIF($A$27:$A32,$A32)-1)))","v":"07F-00"},"Key Grips",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C33,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C33,Parameters!$F:$G,2,0))","v":"07G"},{"$f":"IF($A33=\"-\",\"-\",IF((COUNTIF($A$27:$A33,$A33)-1)<10,$A33&\"-0\"&(COUNTIF($A$27:$A33,$A33)-1),$A33&\"-\"&(COUNTIF($A$27:$A33,$A33)-1)))","v":"07G-00"},"Grips / Assistant Grips",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C34,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C34,Parameters!$F:$G,2,0))","v":"07H"},{"$f":"IF($A34=\"-\",\"-\",IF((COUNTIF($A$27:$A34,$A34)-1)<10,$A34&\"-0\"&(COUNTIF($A$27:$A34,$A34)-1),$A34&\"-\"&(COUNTIF($A$27:$A34,$A34)-1)))","v":"07H-00"},"Vision Controller / Supervisor",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C35,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C35,Parameters!$F:$G,2,0))","v":"07I"},{"$f":"IF($A35=\"-\",\"-\",IF((COUNTIF($A$27:$A35,$A35)-1)<10,$A35&\"-0\"&(COUNTIF($A$27:$A35,$A35)-1),$A35&\"-\"&(COUNTIF($A$27:$A35,$A35)-1)))","v":"07I-00"},"Vision Mixer",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C36,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C36,Parameters!$F:$G,2,0))","v":"07J"},{"$f":"IF($A36=\"-\",\"-\",IF((COUNTIF($A$27:$A36,$A36)-1)<10,$A36&\"-0\"&(COUNTIF($A$27:$A36,$A36)-1),$A36&\"-\"&(COUNTIF($A$27:$A36,$A36)-1)))","v":"07J-00"},"Vision Engineer",null,null,null,null,null,null,{"$f":"ROUND(F36*G36,2)","v":0},null,{"$f":"ROUND(IF(H36=\"Yes\",J36*13.8%,0),2)","v":0},null,{"$f":"J36+L36","v":0},0]
[{"$f":"IF(ISERROR(VLOOKUP(C37,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C37,Parameters!$F:$G,2,0))","v":"07K"},{"$f":"IF($A37=\"-\",\"-\",IF((COUNTIF($A$27:$A37,$A37)-1)<10,$A37&\"-0\"&(COUNTIF($A$27:$A37,$A37)-1),$A37&\"-\"&(COUNTIF($A$27:$A37,$A37)-1)))","v":"07K-00"},"Focus Puller",null,null,null,null,null,null,{"$f":"ROUND(F37*G37,2)","v":0},null,{"$f":"ROUND(IF(H37=\"Yes\",J37*13.8%,0),2)","v":0},null,{"$f":"J37+L37","v":0},0]
[{"$f":"IF(ISERROR(VLOOKUP(C38,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C38,Parameters!$F:$G,2,0))","v":"07L"},{"$f":"IF($A38=\"-\",\"-\",IF((COUNTIF($A$27:$A38,$A38)-1)<10,$A38&\"-0\"&(COUNTIF($A$27:$A38,$A38)-1),$A38&\"-\"&(COUNTIF($A$27:$A38,$A38)-1)))","v":"07L-00"},"Clapper Loader",null,null,null,null,null,null,{"$f":"ROUND(F38*G38,2)","v":0},null,{"$f":"ROUND(IF(H38=\"Yes\",J38*13.8%,0),2)","v":0},null,{"$f":"J38+L38","v":0},0]
[{"$f":"A26&\" TOTAL\"","v":"07- TOTAL"},null,null,null,null,null,null,null,null,{"$f":"SUM(J26:J38)","v":0},null,{"$f":"SUM(L26:L38)","v":0},null,{"$f":"SUM(N26:N38)","v":0},{"$f":"IF(N39=0,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O39","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J39","v":0},null,null,null,null,{"$f":"IF(N39=0,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J41","v":0},null,null,null,null,{"$f":"O41","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J42","v":0},null,null,null,null,{"$f":"O42","v":0}]
["Code","Full Code","Role","Name","Dates","No. Of Days","Daily Rate","Nat Ins @ 13.8%?",null,{"$f":"\"Basic - \"&Currency","v":"Basic - £"},null,{"$f":"\"NI - \"&Currency","v":"NI - £"},null,{"$f":"\"Total - \"&Currency","v":"Total - £"},{"$f":"IF(N52=0,0,1)","v":0}]
["08 -","CREW - SOUND",null,null,null,null,null,null,null,"Basic",null,null,null,null,{"$f":"O44","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C46,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C46,Parameters!$F:$G,2,0))","v":"08A"},{"$f":"IF($A46=\"-\",\"-\",IF((COUNTIF($A$46:$A46,$A46)-1)<10,$A46&\"-0\"&(COUNTIF($A$46:$A46,$A46)-1),$A46&\"-\"&(COUNTIF($A$46:$A46,$A46)-1)))","v":"08A-00"},"Sound Supervisor",null,null,null,null,null,null,{"$f":"ROUND(F46*G46,2)","v":0},null,{"$f":"ROUND(IF(H46=\"Yes\",J46*13.8%,0),2)","v":0},null,{"$f":"J46+L46","v":0},{"$f":"IF(N46=0,0,1)","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C47,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C47,Parameters!$F:$G,2,0))","v":"08B"},{"$f":"IF($A47=\"-\",\"-\",IF((COUNTIF($A$46:$A47,$A47)-1)<10,$A47&\"-0\"&(COUNTIF($A$46:$A47,$A47)-1),$A47&\"-\"&(COUNTIF($A$46:$A47,$A47)-1)))","v":"08B-00"},"Sound Recordist",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C48,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C48,Parameters!$F:$G,2,0))","v":"08C"},{"$f":"IF($A48=\"-\",\"-\",IF((COUNTIF($A$46:$A48,$A48)-1)<10,$A48&\"-0\"&(COUNTIF($A$46:$A48,$A48)-1),$A48&\"-\"&(COUNTIF($A$46:$A48,$A48)-1)))","v":"08C-00"},"HD Sound Recordist",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C49,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C49,Parameters!$F:$G,2,0))","v":"08D"},{"$f":"IF($A49=\"-\",\"-\",IF((COUNTIF($A$46:$A49,$A49)-1)<10,$A49&\"-0\"&(COUNTIF($A$46:$A49,$A49)-1),$A49&\"-\"&(COUNTIF($A$46:$A49,$A49)-1)))","v":"08D-00"},"Sound Assistant",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C50,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C50,Parameters!$F:$G,2,0))","v":"08E"},{"$f":"IF($A50=\"-\",\"-\",IF((COUNTIF($A$46:$A50,$A50)-1)<10,$A50&\"-0\"&(COUNTIF($A$46:$A50,$A50)-1),$A50&\"-\"&(COUNTIF($A$46:$A50,$A50)-1)))","v":"08E-00"},"Sound Technician",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C51,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C51,Parameters!$F:$G,2,0))","v":"08F"},{"$f":"IF($A51=\"-\",\"-\",IF((COUNTIF($A$46:$A51,$A51)-1)<10,$A51&\"-0\"&(COUNTIF($A$46:$A51,$A51)-1),$A51&\"-\"&(COUNTIF($A$46:$A51,$A51)-1)))","v":"08F-00"},"Boom Op / Sound Maintenance Engineer",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"A45&\" TOTAL\"","v":"08 - TOTAL"},null,null,null,null,null,null,null,null,{"$f":"SUM(J45:J51)","v":0},null,{"$f":"SUM(L45:L51)","v":0},null,{"$f":"SUM(N45:N51)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O52","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J52","v":0},null,null,null,null,{"$f":"IF(N52=0,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J54","v":0},null,null,null,null,{"$f":"O54","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J55","v":0},null,null,null,null,{"$f":"O55","v":0}]
["Code","Full Code","Role","Name","Dates","No. Of Days","Daily Rate","Nat Ins @ 13.8%?",null,{"$f":"\"Basic - \"&Currency","v":"Basic - £"},null,{"$f":"\"NI - \"&Currency","v":"NI - £"},null,{"$f":"\"Total - \"&Currency","v":"Total - £"},{"$f":"IF(N67=0,0,1)","v":0}]
["09 -","CREW LIGHTING",null,null,null,null,null,null,null,"Basic",null,null,null,null,{"$f":"O57","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C59,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C59,Parameters!$F:$G,2,0))","v":"09A"},{"$f":"IF($A59=\"-\",\"-\",IF((COUNTIF($A$59:$A59,$A59)-1)<10,$A59&\"-0\"&(COUNTIF($A$59:$A59,$A59)-1),$A59&\"-\"&(COUNTIF($A$59:$A59,$A59)-1)))","v":"09A-00"},"Lighting Gaffer",null,null,null,null,null,null,{"$f":"ROUND(F59*G59,2)","v":0},null,{"$f":"ROUND(IF(H59=\"Yes\",J59*13.8%,0),2)","v":0},null,{"$f":"J59+L59","v":0},{"$f":"IF(N59=0,0,1)","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C60,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C60,Parameters!$F:$G,2,0))","v":"09B"},{"$f":"IF($A60=\"-\",\"-\",IF((COUNTIF($A$59:$A60,$A60)-1)<10,$A60&\"-0\"&(COUNTIF($A$59:$A60,$A60)-1),$A60&\"-\"&(COUNTIF($A$59:$A60,$A60)-1)))","v":"09B-00"},"Lighting Director",null,null,null,null,null,null,{"$f":"ROUND(F60*G60,2)","v":0},null,{"$f":"ROUND(IF(H60=\"Yes\",J60*13.8%,0),2)","v":0},null,{"$f":"J60+L60","v":0},{"$f":"IF(N60=0,0,1)","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C61,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C61,Parameters!$F:$G,2,0))","v":"09C"},{"$f":"IF($A61=\"-\",\"-\",IF((COUNTIF($A$59:$A61,$A61)-1)<10,$A61&\"-0\"&(COUNTIF($A$59:$A61,$A61)-1),$A61&\"-\"&(COUNTIF($A$59:$A61,$A61)-1)))","v":"09C-00"},"Lighting Dailies",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C62,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C62,Parameters!$F:$G,2,0))","v":"09D"},{"$f":"IF($A62=\"-\",\"-\",IF((COUNTIF($A$59:$A62,$A62)-1)<10,$A62&\"-0\"&(COUNTIF($A$59:$A62,$A62)-1),$A62&\"-\"&(COUNTIF($A$59:$A62,$A62)-1)))","v":"09D-00"},"Chargehand Electrician / Best Boy",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C63,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C63,Parameters!$F:$G,2,0))","v":"09E"},{"$f":"IF($A63=\"-\",\"-\",IF((COUNTIF($A$59:$A63,$A63)-1)<10,$A63&\"-0\"&(COUNTIF($A$59:$A63,$A63)-1),$A63&\"-\"&(COUNTIF($A$59:$A63,$A63)-1)))","v":"09E-00"},"Electrician",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C64,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C64,Parameters!$F:$G,2,0))","v":"09F"},{"$f":"IF($A64=\"-\",\"-\",IF((COUNTIF($A$59:$A64,$A64)-1)<10,$A64&\"-0\"&(COUNTIF($A$59:$A64,$A64)-1),$A64&\"-\"&(COUNTIF($A$59:$A64,$A64)-1)))","v":"09F-00"},"Generator Operator",null,null,null,null,null,null,{"$f":"ROUND(F64*G64,2)","v":0},null,{"$f":"ROUND(IF(H64=\"Yes\",J64*13.8%,0),2)","v":0},null,{"$f":"J64+L64","v":0},0]
[{"$f":"IF(ISERROR(VLOOKUP(C65,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C65,Parameters!$F:$G,2,0))","v":"09G"},{"$f":"IF($A65=\"-\",\"-\",IF((COUNTIF($A$59:$A65,$A65)-1)<10,$A65&\"-0\"&(COUNTIF($A$59:$A65,$A65)-1),$A65&\"-\"&(COUNTIF($A$59:$A65,$A65)-1)))","v":"09G-00"},"Console Operator",null,null,null,null,null,null,{"$f":"ROUND(F65*G65,2)","v":0},null,{"$f":"ROUND(IF(H65=\"Yes\",J65*13.8%,0),2)","v":0},null,{"$f":"J65+L65","v":0},0]
[{"$f":"IF(ISERROR(VLOOKUP(C66,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C66,Parameters!$F:$G,2,0))","v":"09H"},{"$f":"IF($A66=\"-\",\"-\",IF((COUNTIF($A$59:$A66,$A66)-1)<10,$A66&\"-0\"&(COUNTIF($A$59:$A66,$A66)-1),$A66&\"-\"&(COUNTIF($A$59:$A66,$A66)-1)))","v":"09H-00"},"Picture Co-Ordinator",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"A58&\" TOTAL\"","v":"09 - TOTAL"},null,null,null,null,null,null,null,null,{"$f":"SUM(J58:J66)","v":0},null,{"$f":"SUM(L58:L66)","v":0},null,{"$f":"SUM(N58:N66)","v":0},{"$f":"IF(N67=0,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O67","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J67","v":0},null,null,null,null,{"$f":"IF(N67=0,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J69","v":0},null,null,null,null,{"$f":"O69","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J70","v":0},null,null,null,null,{"$f":"O70","v":0}]
["Code","Full Code","Role","Name","Dates","No. Of Days","Daily Rate","Nat Ins @ 13.8%?",null,{"$f":"\"Basic - \"&Currency","v":"Basic - £"},null,{"$f":"\"NI - \"&Currency","v":"NI - £"},null,{"$f":"\"Total - \"&Currency","v":"Total - £"},{"$f":"IF(N97=0,0,1)","v":0}]
["10 -","CREW ART DEPT",null,null,null,null,null,null,null,"Basic",null,null,null,null,{"$f":"O72","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C74,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C74,Parameters!$F:$G,2,0))","v":"10A"},{"$f":"IF($A74=\"-\",\"-\",IF((COUNTIF($A$74:$A74,$A74)-1)<10,$A74&\"-0\"&(COUNTIF($A$74:$A74,$A74)-1),$A74&\"-\"&(COUNTIF($A$74:$A74,$A74)-1)))","v":"10A-00"},"Designer",null,null,null,null,null,null,{"$f":"ROUND(F74*G74,2)","v":0},null,{"$f":"ROUND(IF(H74=\"Yes\",J74*13.8%,0),2)","v":0},null,{"$f":"J74+L74","v":0},{"$f":"IF(N74=0,0,1)","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C75,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C75,Parameters!$F:$G,2,0))","v":"10B"},{"$f":"IF($A75=\"-\",\"-\",IF((COUNTIF($A$74:$A75,$A75)-1)<10,$A75&\"-0\"&(COUNTIF($A$74:$A75,$A75)-1),$A75&\"-\"&(COUNTIF($A$74:$A75,$A75)-1)))","v":"10B-00"},"Art Director",null,null,null,null,null,null,{"$f":"ROUND(F75*G75,2)","v":0},null,{"$f":"ROUND(IF(H75=\"Yes\",J75*13.8%,0),2)","v":0},null,{"$f":"J75+L75","v":0},{"$f":"IF(N75=0,0,1)","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C76,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C76,Parameters!$F:$G,2,0))","v":"10C"},{"$f":"IF($A76=\"-\",\"-\",IF((COUNTIF($A$74:$A76,$A76)-1)<10,$A76&\"-0\"&(COUNTIF($A$74:$A76,$A76)-1),$A76&\"-\"&(COUNTIF($A$74:$A76,$A76)-1)))","v":"10C-00"},"Standby Art Director",null,null,null,null,null,null,{"$f":"ROUND(F76*G76,2)","v":0},null,{"$f":"ROUND(IF(H76=\"Yes\",J76*13.8%,0),2)","v":0},null,{"$f":"J76+L76","v":0},0]
[{"$f":"IF(ISERROR(VLOOKUP(C77,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C77,Parameters!$F:$G,2,0))","v":"10D"},{"$f":"IF($A77=\"-\",\"-\",IF((COUNTIF($A$74:$A77,$A77)-1)<10,$A77&\"-0\"&(COUNTIF($A$74:$A77,$A77)-1),$A77&\"-\"&(COUNTIF($A$74:$A77,$A77)-1)))","v":"10D-00"},"Design Assistant",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C78,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C78,Parameters!$F:$G,2,0))","v":"10E"},{"$f":"IF($A78=\"-\",\"-\",IF((COUNTIF($A$74:$A78,$A78)-1)<10,$A78&\"-0\"&(COUNTIF($A$74:$A78,$A78)-1),$A78&\"-\"&(COUNTIF($A$74:$A78,$A78)-1)))","v":"10E-00"},"Design Runner",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C79,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C79,Parameters!$F:$G,2,0))","v":"10F"},{"$f":"IF($A79=\"-\",\"-\",IF((COUNTIF($A$74:$A79,$A79)-1)<10,$A79&\"-0\"&(COUNTIF($A$74:$A79,$A79)-1),$A79&\"-\"&(COUNTIF($A$74:$A79,$A79)-1)))","v":"10F-00"},"Rigger",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C80,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C80,Parameters!$F:$G,2,0))","v":"10G"},{"$f":"IF($A80=\"-\",\"-\",IF((COUNTIF($A$74:$A80,$A80)-1)<10,$A80&\"-0\"&(COUNTIF($A$74:$A80,$A80)-1),$A80&\"-\"&(COUNTIF($A$74:$A80,$A80)-1)))","v":"10G-00"},"Prop Buyer",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C81,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C81,Parameters!$F:$G,2,0))","v":"10H"},{"$f":"IF($A81=\"-\",\"-\",IF((COUNTIF($A$74:$A81,$A81)-1)<10,$A81&\"-0\"&(COUNTIF($A$74:$A81,$A81)-1),$A81&\"-\"&(COUNTIF($A$74:$A81,$A81)-1)))","v":"10H-00"},"Property Master",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C82,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C82,Parameters!$F:$G,2,0))","v":"10I"},{"$f":"IF($A82=\"-\",\"-\",IF((COUNTIF($A$74:$A82,$A82)-1)<10,$A82&\"-0\"&(COUNTIF($A$74:$A82,$A82)-1),$A82&\"-\"&(COUNTIF($A$74:$A82,$A82)-1)))","v":"10I-00"},"Props / Set Storekeeper",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C83,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C83,Parameters!$F:$G,2,0))","v":"10J"},{"$f":"IF($A83=\"-\",\"-\",IF((COUNTIF($A$74:$A83,$A83)-1)<10,$A83&\"-0\"&(COUNTIF($A$74:$A83,$A83)-1),$A83&\"-\"&(COUNTIF($A$74:$A83,$A83)-1)))","v":"10J-00"},"Dressing Props",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C84,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C84,Parameters!$F:$G,2,0))","v":"10K"},{"$f":"IF($A84=\"-\",\"-\",IF((COUNTIF($A$74:$A84,$A84)-1)<10,$A84&\"-0\"&(COUNTIF($A$74:$A84,$A84)-1),$A84&\"-\"&(COUNTIF($A$74:$A84,$A84)-1)))","v":"10K-00"},"Standby Props",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C85,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C85,Parameters!$F:$G,2,0))","v":"10L"},{"$f":"IF($A85=\"-\",\"-\",IF((COUNTIF($A$74:$A85,$A85)-1)<10,$A85&\"-0\"&(COUNTIF($A$74:$A85,$A85)-1),$A85&\"-\"&(COUNTIF($A$74:$A85,$A85)-1)))","v":"10L-00"},"Props Dailies",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C86,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C86,Parameters!$F:$G,2,0))","v":"10M"},{"$f":"IF($A86=\"-\",\"-\",IF((COUNTIF($A$74:$A86,$A86)-1)<10,$A86&\"-0\"&(COUNTIF($A$74:$A86,$A86)-1),$A86&\"-\"&(COUNTIF($A$74:$A86,$A86)-1)))","v":"10M-00"},"Carpenter",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C87,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C87,Parameters!$F:$G,2,0))","v":"10N"},{"$f":"IF($A87=\"-\",\"-\",IF((COUNTIF($A$74:$A87,$A87)-1)<10,$A87&\"-0\"&(COUNTIF($A$74:$A87,$A87)-1),$A87&\"-\"&(COUNTIF($A$74:$A87,$A87)-1)))","v":"10N-00"},"Painter",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C88,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C88,Parameters!$F:$G,2,0))","v":"10O"},{"$f":"IF($A88=\"-\",\"-\",IF((COUNTIF($A$74:$A88,$A88)-1)<10,$A88&\"-0\"&(COUNTIF($A$74:$A88,$A88)-1),$A88&\"-\"&(COUNTIF($A$74:$A88,$A88)-1)))","v":"10O-00"},"Construction Manager / Scenic Supervisor",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C89,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C89,Parameters!$F:$G,2,0))","v":"10P"},{"$f":"IF($A89=\"-\",\"-\",IF((COUNTIF($A$74:$A89,$A89)-1)<10,$A89&\"-0\"&(COUNTIF($A$74:$A89,$A89)-1),$A89&\"-\"&(COUNTIF($A$74:$A89,$A89)-1)))","v":"10P-00"},"Construction Labour",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C90,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C90,Parameters!$F:$G,2,0))","v":"10Q"},{"$f":"IF($A90=\"-\",\"-\",IF((COUNTIF($A$74:$A90,$A90)-1)<10,$A90&\"-0\"&(COUNTIF($A$74:$A90,$A90)-1),$A90&\"-\"&(COUNTIF($A$74:$A90,$A90)-1)))","v":"10Q-00"},"Scenic Artist",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C91,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C91,Parameters!$F:$G,2,0))","v":"10R"},{"$f":"IF($A91=\"-\",\"-\",IF((COUNTIF($A$74:$A91,$A91)-1)<10,$A91&\"-0\"&(COUNTIF($A$74:$A91,$A91)-1),$A91&\"-\"&(COUNTIF($A$74:$A91,$A91)-1)))","v":"10R-00"},"Signwriter",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C92,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C92,Parameters!$F:$G,2,0))","v":"10S"},{"$f":"IF($A92=\"-\",\"-\",IF((COUNTIF($A$74:$A92,$A92)-1)<10,$A92&\"-0\"&(COUNTIF($A$74:$A92,$A92)-1),$A92&\"-\"&(COUNTIF($A$74:$A92,$A92)-1)))","v":"10S-00"},"Stagehand / Chargehand",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C93,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C93,Parameters!$F:$G,2,0))","v":"10T"},{"$f":"IF($A93=\"-\",\"-\",IF((COUNTIF($A$74:$A93,$A93)-1)<10,$A93&\"-0\"&(COUNTIF($A$74:$A93,$A93)-1),$A93&\"-\"&(COUNTIF($A$74:$A93,$A93)-1)))","v":"10T-00"},"Drapesman",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C94,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C94,Parameters!$F:$G,2,0))","v":"10U"},{"$f":"IF($A94=\"-\",\"-\",IF((COUNTIF($A$74:$A94,$A94)-1)<10,$A94&\"-0\"&(COUNTIF($A$74:$A94,$A94)-1),$A94&\"-\"&(COUNTIF($A$74:$A94,$A94)-1)))","v":"10U-00"},"Safety Co-Ordinator",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C95,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C95,Parameters!$F:$G,2,0))","v":"10V"},{"$f":"IF($A95=\"-\",\"-\",IF((COUNTIF($A$74:$A95,$A95)-1)<10,$A95&\"-0\"&(COUNTIF($A$74:$A95,$A95)-1),$A95&\"-\"&(COUNTIF($A$74:$A95,$A95)-1)))","v":"10V-00"},"Plumber",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C96,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C96,Parameters!$F:$G,2,0))","v":"10W"},{"$f":"IF($A96=\"-\",\"-\",IF((COUNTIF($A$74:$A96,$A96)-1)<10,$A96&\"-0\"&(COUNTIF($A$74:$A96,$A96)-1),$A96&\"-\"&(COUNTIF($A$74:$A96,$A96)-1)))","v":"10W-00"},"Environmental Conservation",null,null,null,null,null,null,{"$f":"ROUND(F96*G96,2)","v":0},null,{"$f":"ROUND(IF(H96=\"Yes\",J96*13.8%,0),2)","v":0},null,{"$f":"J96+L96","v":0},0]
[{"$f":"A73&\" TOTAL\"","v":"10 - TOTAL"},null,null,null,null,null,null,null,null,{"$f":"SUM(J73:J96)","v":0},null,{"$f":"SUM(L73:L96)","v":0},null,{"$f":"SUM(N73:N96)","v":0},{"$f":"IF(N97=0,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O97","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J97","v":0},null,null,null,null,{"$f":"IF(N97=0,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J99","v":0},null,null,null,null,{"$f":"O99","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J100","v":0},null,null,null,null,{"$f":"O100","v":0}]
["Code","Full Code","Role","Name","Dates","No. Of Days","Daily Rate","Nat Ins @ 13.8%?",null,{"$f":"\"Basic - \"&Currency","v":"Basic - £"},null,{"$f":"\"NI - \"&Currency","v":"NI - £"},null,{"$f":"\"Total - \"&Currency","v":"Total - £"},{"$f":"IF(N116=0,0,1)","v":0}]
["11 -","CREW - WARDROBE/MAKE UP/HAIR",null,null,null,null,null,null,null,"Basic",null,null,null,null,{"$f":"O102","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C104,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C104,Parameters!$F:$G,2,0))","v":"11A"},{"$f":"IF($A104=\"-\",\"-\",IF((COUNTIF($A$104:$A104,$A104)-1)<10,$A104&\"-0\"&(COUNTIF($A$104:$A104,$A104)-1),$A104&\"-\"&(COUNTIF($A$104:$A104,$A104)-1)))","v":"11A-00"},"Costume Designer",null,null,null,null,null,null,{"$f":"ROUND(F104*G104,2)","v":0},null,{"$f":"ROUND(IF(H104=\"Yes\",J104*13.8%,0),2)","v":0},null,{"$f":"J104+L104","v":0},{"$f":"IF(N104=0,0,1)","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C105,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C105,Parameters!$F:$G,2,0))","v":"11B"},{"$f":"IF($A105=\"-\",\"-\",IF((COUNTIF($A$104:$A105,$A105)-1)<10,$A105&\"-0\"&(COUNTIF($A$104:$A105,$A105)-1),$A105&\"-\"&(COUNTIF($A$104:$A105,$A105)-1)))","v":"11B-00"},"Costume Supervisor",null,null,null,null,null,null,{"$f":"ROUND(F105*G105,2)","v":0},null,{"$f":"ROUND(IF(H105=\"Yes\",J105*13.8%,0),2)","v":0},null,{"$f":"J105+L105","v":0},{"$f":"IF(N105=0,0,1)","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C106,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C106,Parameters!$F:$G,2,0))","v":"11C"},{"$f":"IF($A106=\"-\",\"-\",IF((COUNTIF($A$104:$A106,$A106)-1)<10,$A106&\"-0\"&(COUNTIF($A$104:$A106,$A106)-1),$A106&\"-\"&(COUNTIF($A$104:$A106,$A106)-1)))","v":"11C-00"},"Assistant Costume Designer",null,null,null,null,null,null,{"$f":"ROUND(F106*G106,2)","v":0},null,{"$f":"ROUND(IF(H106=\"Yes\",J106*13.8%,0),2)","v":0},null,{"$f":"J106+L106","v":0},0]
[{"$f":"IF(ISERROR(VLOOKUP(C107,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C107,Parameters!$F:$G,2,0))","v":"11D"},{"$f":"IF($A107=\"-\",\"-\",IF((COUNTIF($A$104:$A107,$A107)-1)<10,$A107&\"-0\"&(COUNTIF($A$104:$A107,$A107)-1),$A107&\"-\"&(COUNTIF($A$104:$A107,$A107)-1)))","v":"11D-00"},"Costume Assistant",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C108,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C108,Parameters!$F:$G,2,0))","v":"11E"},{"$f":"IF($A108=\"-\",\"-\",IF((COUNTIF($A$104:$A108,$A108)-1)<10,$A108&\"-0\"&(COUNTIF($A$104:$A108,$A108)-1),$A108&\"-\"&(COUNTIF($A$104:$A108,$A108)-1)))","v":"11E-00"},"Costume Dailies",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C109,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C109,Parameters!$F:$G,2,0))","v":"11F"},{"$f":"IF($A109=\"-\",\"-\",IF((COUNTIF($A$104:$A109,$A109)-1)<10,$A109&\"-0\"&(COUNTIF($A$104:$A109,$A109)-1),$A109&\"-\"&(COUNTIF($A$104:$A109,$A109)-1)))","v":"11F-00"},"Dresser",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C110,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C110,Parameters!$F:$G,2,0))","v":"11G"},{"$f":"IF($A110=\"-\",\"-\",IF((COUNTIF($A$104:$A110,$A110)-1)<10,$A110&\"-0\"&(COUNTIF($A$104:$A110,$A110)-1),$A110&\"-\"&(COUNTIF($A$104:$A110,$A110)-1)))","v":"11G-00"},"Make-Up Designer",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C111,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C111,Parameters!$F:$G,2,0))","v":"11H"},{"$f":"IF($A111=\"-\",\"-\",IF((COUNTIF($A$104:$A111,$A111)-1)<10,$A111&\"-0\"&(COUNTIF($A$104:$A111,$A111)-1),$A111&\"-\"&(COUNTIF($A$104:$A111,$A111)-1)))","v":"11H-00"},"Make-Up Supervisor",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C112,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C112,Parameters!$F:$G,2,0))","v":"11I"},{"$f":"IF($A112=\"-\",\"-\",IF((COUNTIF($A$104:$A112,$A112)-1)<10,$A112&\"-0\"&(COUNTIF($A$104:$A112,$A112)-1),$A112&\"-\"&(COUNTIF($A$104:$A112,$A112)-1)))","v":"11I-00"},"Make-Up Artist",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C113,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C113,Parameters!$F:$G,2,0))","v":"11J"},{"$f":"IF($A113=\"-\",\"-\",IF((COUNTIF($A$104:$A113,$A113)-1)<10,$A113&\"-0\"&(COUNTIF($A$104:$A113,$A113)-1),$A113&\"-\"&(COUNTIF($A$104:$A113,$A113)-1)))","v":"11J-00"},"Make-Up Assistant",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C114,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C114,Parameters!$F:$G,2,0))","v":"11K"},{"$f":"IF($A114=\"-\",\"-\",IF((COUNTIF($A$104:$A114,$A114)-1)<10,$A114&\"-0\"&(COUNTIF($A$104:$A114,$A114)-1),$A114&\"-\"&(COUNTIF($A$104:$A114,$A114)-1)))","v":"11K-00"},"Make-Up Daillies",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C115,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C115,Parameters!$F:$G,2,0))","v":"11L"},{"$f":"IF($A115=\"-\",\"-\",IF((COUNTIF($A$104:$A115,$A115)-1)<10,$A115&\"-0\"&(COUNTIF($A$104:$A115,$A115)-1),$A115&\"-\"&(COUNTIF($A$104:$A115,$A115)-1)))","v":"11L-00"},"Hairdresser",null,null,null,null,null,null,{"$f":"ROUND(F115*G115,2)","v":0},null,{"$f":"ROUND(IF(H115=\"Yes\",J115*13.8%,0),2)","v":0},null,{"$f":"J115+L115","v":0},0]
[{"$f":"A103&\" TOTAL\"","v":"11 - TOTAL"},null,null,null,null,null,null,null,null,{"$f":"SUM(J103:J115)","v":0},null,{"$f":"SUM(L103:L115)","v":0},null,{"$f":"SUM(N103:N115)","v":0},{"$f":"IF(N116=0,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O116","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J116","v":0},null,null,null,null,{"$f":"IF(N116=0,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J118","v":0},null,null,null,null,{"$f":"O118","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J119","v":0},null,null,null,null,{"$f":"O119","v":0}]
["Code","Full Code","Role","Name","Dates","No. Of Days","Daily Rate","Nat Ins @ 13.8%?",null,{"$f":"\"Basic - \"&Currency","v":"Basic - £"},null,{"$f":"\"NI - \"&Currency","v":"NI - £"},null,{"$f":"\"Total - \"&Currency","v":"Total - £"},{"$f":"IF(N129=0,0,1)","v":0}]
["12 -","CREW - ANIMATION",null,null,null,null,null,null,null,"Basic",null,null,null,null,{"$f":"O121","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C123,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C123,Parameters!$F:$G,2,0))","v":"12A"},{"$f":"IF($A123=\"-\",\"-\",IF((COUNTIF($A$123:$A123,$A123)-1)<10,$A123&\"-0\"&(COUNTIF($A$123:$A123,$A123)-1),$A123&\"-\"&(COUNTIF($A$123:$A123,$A123)-1)))","v":"12A-00"},"Model Animators",null,null,null,null,null,null,{"$f":"ROUND(F123*G123,2)","v":0},null,{"$f":"ROUND(IF(H123=\"Yes\",J123*13.8%,0),2)","v":0},null,{"$f":"J123+L123","v":0},{"$f":"IF(N123=0,0,1)","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C124,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C124,Parameters!$F:$G,2,0))","v":"12B"},{"$f":"IF($A124=\"-\",\"-\",IF((COUNTIF($A$123:$A124,$A124)-1)<10,$A124&\"-0\"&(COUNTIF($A$123:$A124,$A124)-1),$A124&\"-\"&(COUNTIF($A$123:$A124,$A124)-1)))","v":"12B-00"},"Flash Animators / 2D Animators",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C125,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C125,Parameters!$F:$G,2,0))","v":"12C"},{"$f":"IF($A125=\"-\",\"-\",IF((COUNTIF($A$123:$A125,$A125)-1)<10,$A125&\"-0\"&(COUNTIF($A$123:$A125,$A125)-1),$A125&\"-\"&(COUNTIF($A$123:$A125,$A125)-1)))","v":"12C-00"},"CGI / 3D Animators",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C126,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C126,Parameters!$F:$G,2,0))","v":"12D"},{"$f":"IF($A126=\"-\",\"-\",IF((COUNTIF($A$123:$A126,$A126)-1)<10,$A126&\"-0\"&(COUNTIF($A$123:$A126,$A126)-1),$A126&\"-\"&(COUNTIF($A$123:$A126,$A126)-1)))","v":"12D-00"},"Drawn Animators",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C127,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C127,Parameters!$F:$G,2,0))","v":"12E"},{"$f":"IF($A127=\"-\",\"-\",IF((COUNTIF($A$123:$A127,$A127)-1)<10,$A127&\"-0\"&(COUNTIF($A$123:$A127,$A127)-1),$A127&\"-\"&(COUNTIF($A$123:$A127,$A127)-1)))","v":"12E-00"},"Overseas Animation",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C128,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C128,Parameters!$F:$G,2,0))","v":"12F"},{"$f":"IF($A128=\"-\",\"-\",IF((COUNTIF($A$123:$A128,$A128)-1)<10,$A128&\"-0\"&(COUNTIF($A$123:$A128,$A128)-1),$A128&\"-\"&(COUNTIF($A$123:$A128,$A128)-1)))","v":"12F-00"},"Overseas Supervisor",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"A122&\" TOTAL\"","v":"12 - TOTAL"},null,null,null,null,null,null,null,null,{"$f":"SUM(J122:J128)","v":0},null,{"$f":"SUM(L122:L128)","v":0},null,{"$f":"SUM(N122:N128)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O129","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J129","v":0},null,null,null,null,{"$f":"IF(N129=0,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J131","v":0},null,null,null,null,{"$f":"O131","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J132","v":0},null,null,null,null,{"$f":"O132","v":0}]
["Code","Full Code","Role","Name","Dates","No. Of Days","Daily Rate","Nat Ins @ 13.8%?",null,{"$f":"\"Basic - \"&Currency","v":"Basic - £"},null,{"$f":"\"NI - \"&Currency","v":"NI - £"},null,{"$f":"\"Total - \"&Currency","v":"Total - £"},{"$f":"IF(N148=0,0,1)","v":0}]
["13 -","CREW - EDIT",null,null,null,null,null,null,null,"Basic",null,null,null,null,{"$f":"O134","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C136,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C136,Parameters!$F:$G,2,0))","v":"13A"},{"$f":"IF($A136=\"-\",\"-\",IF((COUNTIF($A$136:$A136,$A136)-1)<10,$A136&\"-0\"&(COUNTIF($A$136:$A136,$A136)-1),$A136&\"-\"&(COUNTIF($A$136:$A136,$A136)-1)))","v":"13A-00"},"Post Production Supervisor",null,null,null,null,null,null,{"$f":"ROUND(F136*G136,2)","v":0},null,{"$f":"ROUND(IF(H136=\"Yes\",J136*13.8%,0),2)","v":0},null,{"$f":"J136+L136","v":0},{"$f":"IF(N136=0,0,1)","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C137,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C137,Parameters!$F:$G,2,0))","v":"13B"},{"$f":"IF($A137=\"-\",\"-\",IF((COUNTIF($A$136:$A137,$A137)-1)<10,$A137&\"-0\"&(COUNTIF($A$136:$A137,$A137)-1),$A137&\"-\"&(COUNTIF($A$136:$A137,$A137)-1)))","v":"13B-00"},"Editor",null,null,null,null,null,null,{"$f":"ROUND(F137*G137,2)","v":0},null,{"$f":"ROUND(IF(H137=\"Yes\",J137*13.8%,0),2)","v":0},null,{"$f":"J137+L137","v":0},{"$f":"IF(N137=0,0,1)","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(C138,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C138,Parameters!$F:$G,2,0))","v":"13C"},{"$f":"IF($A138=\"-\",\"-\",IF((COUNTIF($A$136:$A138,$A138)-1)<10,$A138&\"-0\"&(COUNTIF($A$136:$A138,$A138)-1),$A138&\"-\"&(COUNTIF($A$136:$A138,$A138)-1)))","v":"13C-00"},"Editor Overtime",null,null,null,null,null,null,{"$f":"ROUND(F138*G138,2)","v":0},null,{"$f":"ROUND(IF(H138=\"Yes\",J138*13.8%,0),2)","v":0},null,{"$f":"J138+L138","v":0},0]
[{"$f":"IF(ISERROR(VLOOKUP(C139,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C139,Parameters!$F:$G,2,0))","v":"13D"},{"$f":"IF($A139=\"-\",\"-\",IF((COUNTIF($A$136:$A139,$A139)-1)<10,$A139&\"-0\"&(COUNTIF($A$136:$A139,$A139)-1),$A139&\"-\"&(COUNTIF($A$136:$A139,$A139)-1)))","v":"13D-00"},"Assistant Editor",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C140,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C140,Parameters!$F:$G,2,0))","v":"13E"},{"$f":"IF($A140=\"-\",\"-\",IF((COUNTIF($A$136:$A140,$A140)-1)<10,$A140&\"-0\"&(COUNTIF($A$136:$A140,$A140)-1),$A140&\"-\"&(COUNTIF($A$136:$A140,$A140)-1)))","v":"13E-00"},"VT Editor",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C141,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C141,Parameters!$F:$G,2,0))","v":"13F"},{"$f":"IF($A141=\"-\",\"-\",IF((COUNTIF($A$136:$A141,$A141)-1)<10,$A141&\"-0\"&(COUNTIF($A$136:$A141,$A141)-1),$A141&\"-\"&(COUNTIF($A$136:$A141,$A141)-1)))","v":"13F-00"},"Dubbing Editor",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C142,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C142,Parameters!$F:$G,2,0))","v":"13G"},{"$f":"IF($A142=\"-\",\"-\",IF((COUNTIF($A$136:$A142,$A142)-1)<10,$A142&\"-0\"&(COUNTIF($A$136:$A142,$A142)-1),$A142&\"-\"&(COUNTIF($A$136:$A142,$A142)-1)))","v":"13G-00"},"Dubbing Assistant",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C143,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C143,Parameters!$F:$G,2,0))","v":"13H"},{"$f":"IF($A143=\"-\",\"-\",IF((COUNTIF($A$136:$A143,$A143)-1)<10,$A143&\"-0\"&(COUNTIF($A$136:$A143,$A143)-1),$A143&\"-\"&(COUNTIF($A$136:$A143,$A143)-1)))","v":"13H-00"},"Dubbing Mixer",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C144,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C144,Parameters!$F:$G,2,0))","v":"13I"},{"$f":"IF($A144=\"-\",\"-\",IF((COUNTIF($A$136:$A144,$A144)-1)<10,$A144&\"-0\"&(COUNTIF($A$136:$A144,$A144)-1),$A144&\"-\"&(COUNTIF($A$136:$A144,$A144)-1)))","v":"13I-00"},"Post Production Assistant / Runner",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C145,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C145,Parameters!$F:$G,2,0))","v":"13J"},{"$f":"IF($A145=\"-\",\"-\",IF((COUNTIF($A$136:$A145,$A145)-1)<10,$A145&\"-0\"&(COUNTIF($A$136:$A145,$A145)-1),$A145&\"-\"&(COUNTIF($A$136:$A145,$A145)-1)))","v":"13J-00"},"Transfer Assistant",null,null,null,null,null,null,0,null,0,null,0,0]
[{"$f":"IF(ISERROR(VLOOKUP(C146,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C146,Parameters!$F:$G,2,0))","v":"13K"},{"$f":"IF($A146=\"-\",\"-\",IF((COUNTIF($A$136:$A146,$A146)-1)<10,$A146&\"-0\"&(COUNTIF($A$136:$A146,$A146)-1),$A146&\"-\"&(COUNTIF($A$136:$A146,$A146)-1)))","v":"13K-00"},"Telecine Engineer",null,null,null,null,null,null,{"$f":"ROUND(F146*G146,2)","v":0},null,{"$f":"ROUND(IF(H146=\"Yes\",J146*13.8%,0),2)","v":0},null,{"$f":"J146+L146","v":0},0]
[{"$f":"IF(ISERROR(VLOOKUP(C147,Parameters!$F:$G,2,0)),\"-\",VLOOKUP(C147,Parameters!$F:$G,2,0))","v":"13L"},{"$f":"IF($A147=\"-\",\"-\",IF((COUNTIF($A$136:$A147,$A147)-1)<10,$A147&\"-0\"&(COUNTIF($A$136:$A147,$A147)-1),$A147&\"-\"&(COUNTIF($A$136:$A147,$A147)-1)))","v":"13L-00"},"Captions Operator",null,null,null,null,null,null,{"$f":"ROUND(F147*G147,2)","v":0},null,{"$f":"ROUND(IF(H147=\"Yes\",J147*13.8%,0),2)","v":0},null,{"$f":"J147+L147","v":0},0]
[{"$f":"A135&\" TOTAL\"","v":"13 - TOTAL"},null,null,null,null,null,null,null,null,{"$f":"SUM(J135:J147)","v":0},null,{"$f":"SUM(L135:L147)","v":0},null,{"$f":"SUM(N135:N147)","v":0},{"$f":"IF(N148=0,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O148","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J148","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J150","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J151","v":0}]

{"sheet":"Comparison","index":5,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[9,2,9,3],[10,2,10,3],[1,3,1,7],[2,3,2,7],[5,3,5,9],[6,3,6,9],[8,2,8,3],[8,4,8,5],[29,2,29,3],[30,2,30,3],[31,2,31,3],[12,2,12,3],[13,2,13,3],[26,2,26,3],[27,2,27,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[14,2,14,3],[15,2,15,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[28,2,28,3],[32,2,32,3],[33,2,33,3],[42,2,42,3],[43,2,43,3],[36,2,36,3],[37,2,37,3],[40,2,40,3],[41,2,41,3],[38,2,38,3],[39,2,39,3],[34,2,34,3],[35,2,35,3]]}
[]
[null,null,null,{"$f":"Totals!E3","v":"ITV STUDIOS"},null,null,null,null,null,null,null,"Back to Totals Page"]
[null,null,null,{"$f":"Totals!E4","v":"FACTUAL / ENTERTAINMENT"}]
[]
[]
[null,null,"Programme Name:",{"$f":"Name","v":0}]
[null,null,"Programme Number:",{"$f":"Number","v":0}]
[]
[null,null,null,null,"Current Budget",null,null,"Prior Year",null,"Variance"]
[null,"Code","Categories",null,"Episode","Series",null,"Budget",null,"increase/decrease",null,"Notes"]
[null,null,null,null,{"$f":"Currency","v":"£"},{"$f":"Currency","v":"£"},null,{"$f":"Currency","v":"£"},null,{"$f":"Currency","v":"£"}]
[]
[null,{"$f":"Totals!C18","v":"01"},{"$f":"Totals!D18","v":"Scripts/ Formats/Development"},null,{"$f":"Totals!F18","v":0},{"$f":"Totals!G18","v":0},null,null,null,{"$f":"H13-F13","v":0}]
[null,{"$f":"Totals!C19","v":"02"},{"$f":"Totals!D19","v":"Producer/Director"},null,{"$f":"Totals!F19","v":0},{"$f":"Totals!G19","v":0},null,null,null,{"$f":"H14-F14","v":0}]
[null,{"$f":"Totals!C20","v":"03"},{"$f":"Totals!D20","v":"Artists"},null,{"$f":"Totals!F20","v":0},{"$f":"Totals!G20","v":0},null,null,null,0]
[null,{"$f":"Totals!C21","v":"04"},{"$f":"Totals!D21","v":"Presenters/Interviewees/Contributors"},null,{"$f":"Totals!F21","v":0},{"$f":"Totals!G21","v":0},null,null,null,0]
[null,{"$f":"Totals!C22","v":"05"},{"$f":"Totals!D22","v":"Production Unit Salaries"},null,{"$f":"Totals!F22","v":0},{"$f":"Totals!G22","v":0},null,null,null,0]
[null,{"$f":"Totals!C23","v":"06"},{"$f":"Totals!D23","v":"Assistant Directors/Continuity"},null,{"$f":"Totals!F23","v":0},{"$f":"Totals!G23","v":0},null,null,null,0]
[null,{"$f":"Totals!C24","v":"07"},{"$f":"Totals!D24","v":"Crew - Camera"},null,{"$f":"Totals!F24","v":0},{"$f":"Totals!G24","v":0},null,null,null,0]
[null,{"$f":"Totals!C25","v":"08"},{"$f":"Totals!D25","v":"Crew - Sound"},null,{"$f":"Totals!F25","v":0},{"$f":"Totals!G25","v":0},null,null,null,0]
[null,{"$f":"Totals!C26","v":"09"},{"$f":"Totals!D26","v":"Crew - Lighting"},null,{"$f":"Totals!F26","v":0},{"$f":"Totals!G26","v":0},null,null,null,0]
[null,{"$f":"Totals!C27","v":"10"},{"$f":"Totals!D27","v":"Crew - Art Department"},null,{"$f":"Totals!F27","v":0},{"$f":"Totals!G27","v":0},null,null,null,0]
[null,{"$f":"Totals!C28","v":"11"},{"$f":"Totals!D28","v":"Crew - Wardrobe/Make Up/Hair"},null,{"$f":"Totals!F28","v":0},{"$f":"Totals!G28","v":0},null,null,null,0]
[null,{"$f":"Totals!C29","v":"12"},{"$f":"Totals!D29","v":"Crew - Animation"},null,{"$f":"Totals!F29","v":0},{"$f":"Totals!G29","v":0},null,null,null,0]
[null,{"$f":"Totals!C30","v":"13"},{"$f":"Totals!D30","v":"Crew - Edit"},null,{"$f":"Totals!F30","v":0},{"$f":"Totals!G30","v":0},null,null,null,0]
[null,{"$f":"Totals!C31","v":"14"},{"$f":"Totals!D31","v":"Materials - Art Department"},null,{"$f":"Totals!F31","v":0},{"$f":"Totals!G31","v":0},null,null,null,0]
[null,{"$f":"Totals!C32","v":"15"},{"$f":"Totals!D32","v":"Materials - Wardrobe/Make Up /Hair"},null,{"$f":"Totals!F32","v":0},{"$f":"Totals!G32","v":0},null,null,null,0]
[null,{"$f":"Totals!C33","v":"16"},{"$f":"Totals!D33","v":"Production Equipment"},null,{"$f":"Totals!F33","v":0},{"$f":"Totals!G33","v":0},null,null,null,0]
[null,{"$f":"Totals!C34","v":"17"},{"$f":"Totals!D34","v":"Facility Packages "},null,{"$f":"Totals!F34","v":0},{"$f":"Totals!G34","v":0},null,null,null,0]
[null,{"$f":"Totals!C35","v":"18"},{"$f":"Totals!D35","v":"Studio & Outside Broadcasts"},null,{"$f":"Totals!F35","v":0},{"$f":"Totals!G35","v":0},null,null,null,0]
[null,{"$f":"Totals!C36","v":"19"},{"$f":"Totals!D36","v":"Other Production Facilities"},null,{"$f":"Totals!F36","v":0},{"$f":"Totals!G36","v":0},null,null,null,0]
[null,{"$f":"Totals!C37","v":"20"},{"$f":"Totals!D37","v":"Film/Tape Stock"},null,{"$f":"Totals!F37","v":0},{"$f":"Totals!G37","v":0},null,null,null,0]
[null,{"$f":"Totals!C38","v":"21"},{"$f":"Totals!D38","v":"Animation Pre Production"},null,{"$f":"Totals!F38","v":0},{"$f":"Totals!G38","v":0},null,null,null,0]
[null,{"$f":"Totals!C39","v":"22"},{"$f":"Totals!D39","v":"Post Production"},null,{"$f":"Totals!F39","v":0},{"$f":"Totals!G39","v":0},null,null,null,0]
[null,{"$f":"Totals!C40","v":"23"},{"$f":"Totals!D40","v":"Library Film Archive"},null,{"$f":"Totals!F40","v":0},{"$f":"Totals!G40","v":0},null,null,null,0]
[null,{"$f":"Totals!C41","v":"24"},{"$f":"Totals!D41","v":"Graphics"},null,{"$f":"Totals!F41","v":0},{"$f":"Totals!G41","v":0},null,null,null,0]
[null,{"$f":"Totals!C42","v":"25"},{"$f":"Totals!D42","v":"Music"},null,{"$f":"Totals!F42","v":0},{"$f":"Totals!G42","v":0},null,null,null,0]
[null,{"$f":"Totals!C43","v":"26"},{"$f":"Totals!D43","v":"Travel/Transport"},null,{"$f":"Totals!F43","v":0},{"$f":"Totals!G43","v":0},null,null,null,0]
[null,{"$f":"Totals!C44","v":"27"},{"$f":"Totals!D44","v":"Hotel/Living"},null,{"$f":"Totals!F44","v":0},{"$f":"Totals!G44","v":0},null,null,null,0]
[null,{"$f":"Totals!C45","v":"28"},{"$f":"Totals!D45","v":"Other Production Costs"},null,{"$f":"Totals!F45","v":0},{"$f":"Totals!G45","v":0},null,null,null,0]
[null,{"$f":"Totals!C46","v":"29"},{"$f":"Totals!D46","v":"Finance/Legal"},null,{"$f":"Totals!F46","v":0},{"$f":"Totals!G46","v":0},null,null,null,0]
[null,{"$f":"Totals!C47","v":"30"},{"$f":"Totals!D47","v":"Production Overheads"},null,{"$f":"Totals!F47","v":0},{"$f":"Totals!G47","v":0},null,null,null,0]
[null,{"$f":"Totals!C48","v":"31"},{"$f":"Totals!D48","v":"Theatrical Performances"},null,{"$f":"Totals!F48","v":0},{"$f":"Totals!G48","v":0},null,null,null,0]
[null,{"$f":"Totals!C49","v":"32"},{"$f":"Totals!D49","v":"Contingency"},null,{"$f":"Totals!F49","v":0},{"$f":"Totals!G49","v":0},null,null,null,0]
[null,null,"TOTAL PRODUCTION COSTS",null,{"$f":"SUM(E13:E44)","v":0},{"$f":"SUM(F13:F44)","v":0},null,{"$f":"SUM(H13:H44)","v":0},null,{"$f":"SUM(J13:J44)","v":0}]

{"sheet":"Schedule","index":6,"n_rows":39,"n_cols":36,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,0,1,2]]}
[{"$f":"Totals!E3","v":"ITV STUDIOS"}]
[{"$f":"Totals!E4","v":"FACTUAL / ENTERTAINMENT"}]
["Back to Totals Sheet"]
[{"$f":"Name","v":0}]
[{"$f":"Number","v":0}]
[]
["Budget Production Schedule"]
[]
["Weeks (calendar)",1,{"$f":"B9+1","v":2},{"$f":"C9+1","v":3},4,5,6,7,8,9,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,{"$f":"Y9+1","v":16},17,18,19,20,21,22,23,24,25,26]
["Date"]
["Pre Production"]
["Shoot"]
["View"]
["Offline "]
["Final Post"]
["Delivery"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Executive Producer"]
["Porducer / Director"]
["casting producer"]
["AP"]
["Researcher"]
["Logger/Runner"]
["PM ( part time  )"]
["Production Co-Ordinator"]
["Production Manager"]
["Production Executive"]
["PA (Paperwork)"]
["Production Accountant"]
[]
["Total Desks",{"$f":"SUM(B26:B38)","v":0},{"$f":"SUM(C26:C38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R26:R38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Assumptions","index":7,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Name","v":0}]
[{"$f":"Number","v":0}]
[]
["Back to Totals Page"]
[]
["Assumption Details:"]

{"sheet":"Parameters","index":8,"n_rows":407,"n_cols":7,"rows_kept":407,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,"01A","Writers Fees",{"$f":"E2","v":"01A"}]
[null,null,null,null,"01B","Writers Repeat Fees",{"$f":"E3","v":"01B"}]
[null,null,null,null,"01C","Writers Pension","01C"]
["02A","Executive Producer","02A",null,"01D","Scripts Team","01D"]
["02B","Series Producer","02B",null,"01E","Consultancy - Scripts","01E"]
["02C","Producer","02C",null,"01F","Rights / Format Fees","01F"]
["02D","Assistant Producers","02D",null,"01G","Uncommissioned Writers","01G"]
["02E","Producer/Director","02E",null,"01H","Options","01H"]
["02F","Director","02F",null,"01I","Development Costs","01I"]
["02G","Series Editor","02G",null,"01J","Storyboards","01J"]
["02H","Deputy Editor","02H",null,"01K","Create Advance Payment","01K"]
[null,null,null,null,"02A","Executive Producer","02A"]
["05A","Associate Producer","05A",null,"02B","Series Producer","02B"]
["05B","Line Producer","05B",null,"02C","Producer","02C"]
["05C","Production Manager","05C",null,"02D","Assistant Producer","02D"]
["05D","Location Manager","05D",null,"02E","Producer / Director","02E"]
["05E","Assistant Location Manager","05E",null,"02F","Director","02F"]
["05F","Unit Manager","05F",null,"02G","Series Editor","02G"]
["05G","Unit Assistant","05G",null,"02H","Deputy Editor","02H"]
["05H","Production Executive","05H",null,"03A","Performers Fees","03A"]
["05I","Production Co-ordinator","05I",null,"03B","Performers Repeat Fees","03B"]
["05J","Production Secretary","05J",null,"03C","Performers Holiday Pay","03C"]
["05K","Production Assistant","05K",null,"03D","Performers National Insurance (13.8%)","03D"]
["05L","Runner","05L",null,"03E","Production Days","03E"]
["05M","Production Accountant","05M",null,"03F","Make-Up / Wardrobe Attendance Days","03F"]
["05N","Assistant Accountant","05N",null,"03G","Rehearsal/Stand-By Days","03G"]
["05O","Researcher","05O",null,"03H","Performers Overtime","03H"]
["05P","Film Researcher","05P",null,"03I","Stunts","03I"]
["05Q","Research Assistant","05Q",null,"03J","Choreographer","03J"]
["05R","Librarian","05R",null,"03K","Chaperones / Tutors","03K"]
["05S","Logger","05S",null,"03L","Puppeteers","03L"]
["05T","Stage Manager","05T",null,"03M","Extras / Walk-Ons","03M"]
["05U","Casting Director","05U",null,"03N","Doubles & Stand-Ins","03N"]
["05V","Bulletin Controller","05V",null,"03O","Dancers","03O"]
["05W","Programme Operative","05W",null,"03P","Backing Vocals","03P"]
["05X","Web Designer","05X",null,"03Q","Warm-Up Artist","03Q"]
["05Y","Journalist","05Y",null,"03R","Performers National Insurance (13.8%)","03R"]
["05Z","Admin Functions","05Z",null,"03S","Performers Guarentees","03S"]
["05AA","Drivers","05AA",null,"04A","Presenters","04A"]
["05AB","Phone-In Staff","05AB",null,"04B","Contributors","04B"]
["05AC","Ushers / Stewards","05AC",null,"04C","Narrators / Voice-Overs","04C"]
["05AD","Work Experience","05AD",null,"04D","Guests / Interviewees","04D"]
["05AE","Celebrity Booker","05AE",null,"04E","Consultants","04E"]
["05AF","Question Setter","05AF",null,"04F","Foreign Staff Fees","04F"]
["05AG","Question Verifier","05AG",null,"04G","Deaf Signer","04G"]
[null,null,null,null,"04H","Weather Presenter","04H"]
[null,null,null,null,"04I","Psychologist","04I"]
[null,null,null,null,"05A","Associate Producer","05A"]
[null,null,null,null,"05B","Line Producer","05B"]
[null,null,null,null,"05C","Production Manager","05C"]
[null,null,null,null,"05D","Location Manager","05D"]
[null,null,null,null,"05E","Assistant Location Manager","05E"]
[null,null,null,null,"05F","Unit Manager","05F"]
[null,null,null,null,"05G","Unit Assistant","05G"]
[null,null,null,null,"05H","Production Executive","05H"]
[null,null,null,null,"05I","Production Co-Ordinator","05I"]
[null,null,null,null,"05J","Production Secretary","05J"]
[null,null,null,null,"05K","Production Assistant","05K"]
[null,null,null,null,"05L","Runner","05L"]
[null,null,null,null,"05M","Production Accountant","05M"]
[null,null,null,null,"05N","Assistant Accountant","05N"]
[null,null,null,null,"05O","Researcher","05O"]
[null,null,null,null,"05P","Film Researcher","05P"]
[null,null,null,null,"05Q","Research Assistant","05Q"]
[null,null,null,null,"05R","Librarian","05R"]
[null,null,null,null,"05S","Logger",{"$f":"E67","v":"05S"}]
[null,null,null,null,"05T","Stage Manager","05T"]
[null,null,null,null,"05U","Casting Director","05U"]
[null,null,null,null,"05V","Bulletin Controller","05V"]
[null,null,null,null,"05W","Programme Operative","05W"]
[null,null,null,null,"05X","Web Designer","05X"]
[null,null,null,null,"05Y","Journalist","05Y"]
[null,null,null,null,"05Z","Admin Functions","05Z"]
[null,null,null,null,"05AA","Drivers","05AA"]
[null,null,null,null,"05AB","Phone-In Staff","05AB"]
[null,null,null,null,"05AC","Ushers / Stewards","05AC"]
[null,null,null,null,"05AD","Work Experience","05AD"]
[null,null,null,null,"05AE","Celebrity Booker","05AE"]
[null,null,null,null,"05AF","Question Setter","05AF"]
[null,null,null,null,"05AG","Question Verifier","05AG"]
[null,null,null,null,"06A","1st Assistant Director","06A"]
[null,null,null,null,"06B","2nd Assistant Director","06B"]
[null,null,null,null,"06C","3rd Assistant Director","06C"]
[null,null,null,null,"06D","Floor Manager","06D"]
[null,null,null,null,"06E","Assistant Floor Manager","06E"]
[null,null,null,null,"06F","Location / Production Runner","06F"]
[null,null,null,null,"06G","Continuity / Script Supervisor","06G"]
[null,null,null,null,"07A","Director of Photography","07A"]
[null,null,null,null,"07B","Camera Supervisor","07B"]
[null,null,null,null,"07C","Camera Operator","07C"]
[null,null,null,null,"07D","HD Camera Operator","07D"]
[null,null,null,null,"07E","Camera Assistant / Trainee","07E"]
[null,null,null,null,"07F","Key Grips","07F"]
[null,null,null,null,"07G","Grips / Assistant Grips","07G"]
[null,null,null,null,"07H","Vision Controller / Supervisor","07H"]
[null,null,null,null,"07I","Vision Mixer","07I"]
[null,null,null,null,"07J","Vision Engineer","07J"]
[null,null,null,null,"07K","Focus Puller","07K"]
[null,null,null,null,"07L","Clapper Loader","07L"]
[null,null,null,null,"08A","Sound Supervisor","08A"]
[null,null,null,null,"08B","Sound Recordist","08B"]
[null,null,null,null,"08C","HD Sound Recordist","08C"]
[null,null,null,null,"08D","Sound Assistant","08D"]
[null,null,null,null,"08E","Sound Technician","08E"]
[null,null,null,null,"08F","Boom Op / Sound Maintenance Engineer","08F"]
[null,null,null,null,"09A","Lighting Gaffer","09A"]
[null,null,null,null,"09B","Lighting Director","09B"]
[null,null,null,null,"09C","Lighting Dailies","09C"]
[null,null,null,null,"09D","Chargehand Electrician / Best Boy","09D"]
[null,null,null,null,"09E","Electrician","09E"]
[null,null,null,null,"09F","Generator Operator","09F"]
[null,null,null,null,"09G","Console Operator","09G"]
[null,null,null,null,"09H","Picture Co-Ordinator","09H"]
[null,null,null,null,"10A","Designer","10A"]
[null,null,null,null,"10B","Art Director","10B"]
[null,null,null,null,"10C","Standby Art Director","10C"]
[null,null,null,null,"10D","Design Assistant","10D"]
[null,null,null,null,"10E","Design Runner","10E"]
[null,null,null,null,"10F","Rigger","10F"]
[null,null,null,null,"10G","Prop Buyer","10G"]
[null,null,null,null,"10H","Property Master","10H"]
[null,null,null,null,"10I","Props / Set Storekeeper","10I"]
[null,null,null,null,"10J","Dressing Props","10J"]
[null,null,null,null,"10K","Standby Props","10K"]
[null,null,null,null,"10L","Props Dailies","10L"]
[null,null,null,null,"10M","Carpenter","10M"]
[null,null,null,null,"10N","Painter","10N"]
[null,null,null,null,"10O","Construction Manager / Scenic Supervisor","10O"]
[null,null,null,null,"10P","Construction Labour","10P"]
[null,null,null,null,"10Q","Scenic Artist",{"$f":"E131","v":"10Q"}]
[null,null,null,null,"10R","Signwriter","10R"]
[null,null,null,null,"10S","Stagehand / Chargehand","10S"]
[null,null,null,null,"10T","Drapesman","10T"]
[null,null,null,null,"10U","Safety Co-Ordinator","10U"]
[null,null,null,null,"10V","Plumber","10V"]
[null,null,null,null,"10W","Environmental Conservation","10W"]
[null,null,null,null,"11A","Costume Designer","11A"]
[null,null,null,null,"11B","Costume Supervisor","11B"]
[null,null,null,null,"11C","Assistant Costume Designer","11C"]
[null,null,null,null,"11D","Costume Assistant","11D"]
[null,null,null,null,"11E","Costume Dailies","11E"]
[null,null,null,null,"11F","Dresser","11F"]
[null,null,null,null,"11G","Make-Up Designer","11G"]
[null,null,null,null,"11H","Make-Up Supervisor","11H"]
[null,null,null,null,"11I","Make-Up Artist","11I"]
[null,null,null,null,"11J","Make-Up Assistant","11J"]
[null,null,null,null,"11K","Make-Up Daillies","11K"]
[null,null,null,null,"11L","Hairdresser","11L"]
[null,null,null,null,"12A","Model Animators","12A"]
[null,null,null,null,"12B","Flash Animators / 2D Animators","12B"]
[null,null,null,null,"12C","CGI / 3D Animators","12C"]
[null,null,null,null,"12D","Drawn Animators","12D"]
[null,null,null,null,"12E","Overseas Animation","12E"]
[null,null,null,null,"12F","Overseas Supervisor","12F"]
[null,null,null,null,"13A","Post Production Supervisor","13A"]
[null,null,null,null,"13B","Editor","13B"]
[null,null,null,null,"13C","Editor Overtime","13C"]
[null,null,null,null,"13D","Assistant Editor","13D"]
[null,null,null,null,"13E","VT Editor","13E"]
[null,null,null,null,"13F","Dubbing Editor","13F"]
[null,null,null,null,"13G","Dubbing Assistant","13G"]
[null,null,null,null,"13H","Dubbing Mixer","13H"]
[null,null,null,null,"13I","Post Production Assistant / Runner","13I"]
[null,null,null,null,"13J","Transfer Assistant","13J"]
[null,null,null,null,"13K","Telecine Engineer","13K"]
[null,null,null,null,"13L","Captions Operator","13L"]
[null,null,null,null,"14A","Sets and Scenery","14A"]
[null,null,null,null,"14B","Props Purchased","14B"]
[null,null,null,null,"14C","Props Hired","14C"]
[null,null,null,null,"14D","Sets and Props Storage","14D"]
[null,null,null,null,"14E","Sets and Props Transport","14E"]
[null,null,null,null,"14F","Action Vehicles","14F"]
[null,null,null,null,"14G","Special Effects - Materials - Art Dept","14G"]
[null,null,null,null,"14H","Star Cloth","14H"]
[null,null,null,null,"14I","Scoring Equipment","14I"]
[null,null,null,null,"14J","Art Department Consumables","14J"]
[null,null,null,null,"14K","Animals and Handlers","14K"]
[null,null,null,null,"14L","Props - Loss and Damage","14L"]
[null,null,null,null,"14M","Armourer","14M"]
[null,null,null,null,"14N","Construction Workshop","14N"]
[null,null,null,null,"15A","Costumes Purchased","15A"]
[null,null,null,null,"15B","Costumes Hired","15B"]
[null,null,null,null,"15C","Costumes Sundries","15C"]
[null,null,null,null,"15D","Costumes / Make-up Box Allowances","15D"]
[null,null,null,null,"15E","Artist Dress Allowance","15E"]
[null,null,null,null,"15F","Make-Up","15F"]
[null,null,null,null,"15G","Wigs","15G"]
[null,null,null,null,"15H","Hair Cuts","15H"]
[null,null,null,null,"15I","Prosthetics","15I"]
[null,null,null,null,"16A","Camera Equipment","16A"]
[null,null,null,null,"16B","Steadicam","16B"]
[null,null,null,null,"16C","DV Hire","16C"]
[null,null,null,null,"16D","Camera Consumables","16D"]
[null,null,null,null,"16E","Grip Equipment",{"$f":"E195","v":"16E"}]
[null,null,null,null,"16F","Sound Equipment","16F"]
[null,null,null,null,"16G","Sound Consumables","16G"]
[null,null,null,null,"16H","Lighting Equipment","16H"]
[null,null,null,null,"16I","HD Equipment","16I"]
[null,null,null,null,"16J","Lighting Consumables","16J"]
[null,null,null,null,"16K","Autocue","16K"]
[null,null,null,null,"16L","Projector","16L"]
[null,null,null,null,"16M","Towers & Cherry Pickers","16M"]
[null,null,null,null,"16N","Techno Crane / Cranes inc Jimmy Jib","16N"]
[null,null,null,null,"16O","Scaffolding","16O"]
[null,null,null,null,"16P","Electrical  Equipment","16P"]
[null,null,null,null,"16Q","Generators","16Q"]
[null,null,null,null,"16R","Walkie Talkies","16R"]
[null,null,null,null,"16S","Wide Angle Lens","16S"]
[null,null,null,null,"16T","Miscellaneous Production Equipment","16T"]
[null,null,null,null,"16U","Jimmy Jib","16U"]
[null,null,null,null,"16V","Covert Filming Equipment","16V"]
[null,null,null,null,"16W","CGI Animation Computer Equipment","16W"]
[null,null,null,null,"16X","Low Loaders / A Frames","16X"]
[null,null,null,null,"17A","Facility Packages","17A"]
[null,null,null,null,"17B","Camera Crews (Incl. Equipment)","17B"]
[null,null,null,null,"17C","Video Stringers","17C"]
[null,null,null,null,"17D","Second Unit","17D"]
[null,null,null,null,"17E","Second Camera","17E"]
[null,null,null,null,"18A","Studio","18A"]
[null,null,null,null,"18B","Sound Mobile","18B"]
[null,null,null,null,"18C","Studio Security","18C"]
[null,null,null,null,"18D","Audiences and Tickets","18D"]
[null,null,null,null,"18E","VT Engineer","18E"]
[null,null,null,null,"18F","Studio Crew","18F"]
[null,null,null,null,"18G","Technical Supervisor","18G"]
[null,null,null,null,"18H","Engineer","18H"]
[null,null,null,null,"18I","Technical Assistant","18I"]
[null,null,null,null,"18J","CTF / MCR Labour","18J"]
[null,null,null,null,"18K","OB Unit","18K"]
[null,null,null,null,"18L","OB Security","18L"]
[null,null,null,null,"18M","Power","18M"]
[null,null,null,null,"18N","Cranes","18N"]
[null,null,null,null,"18O","Air Conditioning","18O"]
[null,null,null,null,"18P","Waste Disposal","18P"]
[null,null,null,null,"18Q","Studio and OB Consumables","18Q"]
[null,null,null,null,"18R","Water","18R"]
[null,null,null,null,"18S","Commentary Positions","18S"]
[null,null,null,null,"18T","Lines Bookings","18T"]
[null,null,null,null,"18U","Lines Feeds","18U"]
[null,null,null,null,"19A","Location  Facility Fees","19A"]
[null,null,null,null,"19B","Location Security","19B"]
[null,null,null,null,"19C","Catering - Dining Bus / Fuel","19C"]
[null,null,null,null,"19D","Catering - Meals","19D"]
[null,null,null,null,"19E","Catering - Labour / Overtime","19E"]
[null,null,null,null,"19F","Honey Wagon /  Portaloos","19F"]
[null,null,null,null,"19G","Make-Up / Wardrobe Trailers","19G"]
[null,null,null,null,"19H","Service Vehicles","19H"]
[null,null,null,null,"19I","Winnebagoes","19I"]
[null,null,null,null,"19J","Other Hired Transport","19J"]
[null,null,null,null,"19K","Helicopter / Boat Hire","19K"]
[null,null,null,null,"19L","Satellite Links","19L"]
[null,null,null,null,"19M","Telecom Lines / Cable Fees","19M"]
[null,null,null,null,"19N","Playouts","19N"]
[null,null,null,null,"19O","Medical / Health & Safety","19O"]
[null,null,null,null,"19P","Facilities Deal","19P"]
[null,null,null,null,"19Q","Facilities Fuel","19Q"]
[null,null,null,null,"19R","Other Hired Facilities","19R"]
[null,null,null,null,"19S","Rehearsal Rooms",{"$f":"E259","v":"19S"}]
[null,null,null,null,"19T","Readthrough Facilities","19T"]
[null,null,null,null,"20A","Tape Stock","20A"]
[null,null,null,null,"20B","Film Stock","20B"]
[null,null,null,null,"20C","Sound Tape Stock","20C"]
[null,null,null,null,"21A","Voice Record Studio","21A"]
[null,null,null,null,"21B","Voice Record Expenses","21B"]
[null,null,null,null,"21C","Cut Track","21C"]
[null,null,null,null,"21D","Dialogue Assembly","21D"]
[null,null,null,null,"21E","Dialogue Fine Cut","21E"]
[null,null,null,null,"21F","Barsheets","21F"]
[null,null,null,null,"21G","Animatics","21G"]
[null,null,null,null,"21H","X-Sheets","21H"]
[null,null,null,null,"21I","Layouts","21I"]
[null,null,null,null,"21J","Slugging","21J"]
[null,null,null,null,"22A","Logging / Digitising","22A"]
[null,null,null,null,"22B","Neg Processing / Transfer / Sync","22B"]
[null,null,null,null,"22C","Avid / Lightworks Online","22C"]
[null,null,null,null,"22D","Linear Online","22D"]
[null,null,null,null,"22E","Avid / Lightworks Offline","22E"]
[null,null,null,null,"22F","Memory","22F"]
[null,null,null,null,"22G","Conform / Online","22G"]
[null,null,null,null,"22H","Negative Cutting","22H"]
[null,null,null,null,"22I","Sound Conform / Tracklay","22I"]
[null,null,null,null,"22J","Grade / Telecine","22J"]
[null,null,null,null,"22K","Dub / Mix","22K"]
[null,null,null,null,"22L","Voice-Over / ADR","22L"]
[null,null,null,null,"22M","Lay Back","22M"]
[null,null,null,null,"22N","Standards Conversion","22N"]
[null,null,null,null,"22O","Final Assembly","22O"]
[null,null,null,null,"22P","Rostrum","22P"]
[null,null,null,null,"22Q","Post Production Special Effects","22Q"]
[null,null,null,null,"22R","Post Production Packages","22R"]
[null,null,null,null,"22S","Post Production Tapes","22S"]
[null,null,null,null,"22T","Transfers","22T"]
[null,null,null,null,"22U","Media Management","22U"]
[null,null,null,null,"22V","Technical Check","22V"]
[null,null,null,null,"22W","HD Facilities","22W"]
[null,null,null,null,"22X","Desk Top Editing","22X"]
[null,null,null,null,"22Y","International Version","22Y"]
[null,null,null,null,"23A","Archive Royalties","23A"]
[null,null,null,null,"23B","Archive / Stills Processing","23B"]
[null,null,null,null,"23C","Stills Royalties","23C"]
[null,null,null,null,"23D","Library Facilities","23D"]
[null,null,null,null,"23E","Research Materials","23E"]
[null,null,null,null,"23F","Finders Fees","23F"]
[null,null,null,null,"24A","Graphics - In Programme","24A"]
[null,null,null,null,"24B","Titles","24B"]
[null,null,null,null,"24C","Animation","24C"]
[null,null,null,null,"24D","Crew - Graphics","24D"]
[null,null,null,null,"24E","Desk Top Publishing","24E"]
[null,null,null,null,"24F","Rostrum","24F"]
[null,null,null,null,"24G","Scoring Package","24G"]
[null,null,null,null,"25A","Composed Music","25A"]
[null,null,null,null,"25B","Musical Director","25B"]
[null,null,null,null,"25C","Hired Musicians","25C"]
[null,null,null,null,"25D","PPL / VPL","25D"]
[null,null,null,null,"25E","Signature Tune","25E"]
[null,null,null,null,"25F","Recording Studios","25F"]
[null,null,null,null,"25G","Tape Usage","25G"]
[null,null,null,null,"25H","Instruments","25H"]
[null,null,null,null,"25I","Doubling","25I"]
[null,null,null,null,"25J","Porterage","25J"]
[null,null,null,null,"25K","Arranging","25K"]
[null,null,null,null,"25L","Copying",{"$f":"E323","v":"25L"}]
[null,null,null,null,"25M","Music - Other","25M"]
[null,null,null,null,"26A","Coach & Minibus Hire","26A"]
[null,null,null,null,"26B","Cars / Car Hire (UK)","26B"]
[null,null,null,null,"26C","Fuel","26C"]
[null,null,null,null,"26D","Carriage / Taxis / Bikes","26D"]
[null,null,null,null,"26E","Freight, Customs & Excess Baggage","26E"]
[null,null,null,null,"26F","Carnets / Permits / Visas","26F"]
[null,null,null,null,"26G","UK Mileage","26G"]
[null,null,null,null,"26H","UK Air Fares","26H"]
[null,null,null,null,"26I","UK Rail Fares","26I"]
[null,null,null,null,"26J","UK Ferries","26J"]
[null,null,null,null,"26K","UK Taxis","26K"]
[null,null,null,null,"26L","UK Other Travel","26L"]
[null,null,null,null,"26M","Overseas Air Fares","26M"]
[null,null,null,null,"26N","Overseas Rail Fares","26N"]
[null,null,null,null,"26O","Overseas Ferries","26O"]
[null,null,null,null,"26P","Overseas Taxis","26P"]
[null,null,null,null,"26Q","Overseas Car Hire","26Q"]
[null,null,null,null,"26R","Overseas Fuel","26R"]
[null,null,null,null,"26S","Overseas Other Travel","26S"]
[null,null,null,null,"26T","Awards Ceremonies Travel & Transport","26T"]
[null,null,null,null,"26U","Writers Expenses","26U"]
[null,null,null,null,"26V","Presenters Expenses","26V"]
[null,null,null,null,"26W","Performers Travel","26W"]
[null,null,null,null,"26X","Other Artist Expenses","26X"]
[null,null,null,null,"26Y","UK Parking","26Y"]
[null,null,null,null,"27A","Hospitality","27A"]
[null,null,null,null,"27B","Foreign Staff Expenses","27B"]
[null,null,null,null,"27C","Crew Meals","27C"]
[null,null,null,null,"27D","UK Accommodation Allowances","27D"]
[null,null,null,null,"27E","UK Per Diems","27E"]
[null,null,null,null,"27F","UK Meal Allowances","27F"]
[null,null,null,null,"27G","UK Hotel Bills","27G"]
[null,null,null,null,"27H","UK Meal Bills","27H"]
[null,null,null,null,"27I","UK Entertaining & Gratuities","27I"]
[null,null,null,null,"27J","UK Other Hotel & Living","27J"]
[null,null,null,null,"27K","Overseas Accommodation Allowances","27K"]
[null,null,null,null,"27L","Overseas Per Diems","27L"]
[null,null,null,null,"27M","Overseas Meal Allowances","27M"]
[null,null,null,null,"27N","Overseas Hotel Bills","27N"]
[null,null,null,null,"27O","Overseas Meal Bills","27O"]
[null,null,null,null,"27P","Overseas Entertaining & Gratuities","27P"]
[null,null,null,null,"27Q","Overseas Other Hotel & Living","27Q"]
[null,null,null,null,"27R","Phone Expenses","27R"]
[null,null,null,null,"27S","Awards Ceremonies Hotel & Living","27S"]
[null,null,null,null,"27T","Performers Hotel/living","27T"]
[null,null,null,null,"28A","Prizes","28A"]
[null,null,null,null,"28B","Surveys & Opinion Polls","28B"]
[null,null,null,null,"28C","Newspapers and Books","28C"]
[null,null,null,null,"28D","Search Engines","28D"]
[null,null,null,null,"28E","Transcriptions & Translations","28E"]
[null,null,null,null,"28F","Recce Costs","28F"]
[null,null,null,null,"28G","Advertising","28G"]
[null,null,null,null,"28H","Cleaning","28H"]
[null,null,null,null,"28I","Stationery","28I"]
[null,null,null,null,"28J","Duplicating / Printing","28J"]
[null,null,null,null,"28K","Office Equipment","28K"]
[null,null,null,null,"28L","Phones / Fax","28L"]
[null,null,null,null,"28M","Mobile Phones","28M"]
[null,null,null,null,"28N","Press / Photography","28N"]
[null,null,null,null,"28O","Postage","28O"]
[null,null,null,null,"28P","Press Association Fees","28P"]
[null,null,null,null,"28Q","Programme Back-Up","28Q"]
[null,null,null,null,"28R","Protective Clothing",{"$f":"E387","v":"28R"}]
[null,null,null,null,"28S","Sundries","28S"]
[null,null,null,null,"28T","Newspapers & Magazines - Home Delivery","28T"]
[null,null,null,null,"29A","Insurance","29A"]
[null,null,null,null,"29B","Legal Fees / Services","29B"]
[null,null,null,null,"29C","Compliance Costs","29C"]
[null,null,null,null,"29D","Neg Checking","29D"]
[null,null,null,null,"29E","Budget Preparation","29E"]
[null,null,null,null,"29F","Rebate Processing","29F"]
[null,null,null,null,"29G","Interest Charges / Cost Of Money","29G"]
[null,null,null,null,"30A","Production Office","30A"]
[null,null,null,null,"30B","Computer Services / IT Support","30B"]
[null,null,null,null,"30C","Financial Processing / Wages / Banking","30C"]
[null,null,null,null,"30D","Production Audit","30D"]
[null,null,null,null,"30E","Production Contracts","30E"]
[null,null,null,null,"30F","Miscellaneous Overheads","30F"]
[null,null,null,null,"30G","PACT Levy","30G"]
[null,null,null,null,"31A","Theatre Hire","31A"]
[null,null,null,null,"31B","Theatre Contras","31B"]
[null,null,null,null,"32A","Contingency","32A"]
[null,null,null,null,"97A","Contingency","97A"]