{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["How to Guide ","EXAMPLE Budget vs Actual","Chart1","1. Budget","2. Risk Analysis","3. Project Report","4. Claim Form","Sheet1"],"not_rendered":{"charts":2,"images":4,"macros":1,"external_links":2,"defined_names":50,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Chart1","index":2,"reason":"not_a_worksheet"}],"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":"How to Guide ","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,1,14,2],[17,1,17,2],[22,1,22,2],[1,1,1,2],[2,1,2,2],[4,1,4,2],[7,1,7,2],[10,1,10,2],[13,1,13,2]]}
[]
[null,"Project and Budget Report"]
[null,"This document is used as part of your application for funding, and if successful, also for reporting.\nAPPLICATION: When applying for funding, we will need to see tab 1 (columns B-G) completed.\nSUCESSFULL APPLICATIONS:  In tab 1, click on \"Open Periods\" button and populate the budget figure in relevant periods in line with figures in column 'F'.\nREPORTING: If your application is successful, you will use this document to submit funding claims and provide project updates."]
[]
[null,"There are 6 sections to complete:"]
[null,"Tab 1.","Budget Vs Actual"]
[null,null,"Please insert your project budget (columns B-G at application stage). If your applicaiton is successful, you will be required to include your projected cashflow for each period (this will be outlined in the contract). This will allow you to plan when you require your grant instalments from ScreenSkills. When reporting, you will record your actual spend (actual column) next to your forecasted spend (budget column) on each line of your approved budget. You will then be asked to submit the corresponding proof of expenditure for randomly selected expenses.  You can define the number of claims you wish to make when creating your cashflow, this can depend on the length of your project and your cashflow needs, please add dates as you see fit. Please do not amend any formulae in this document."]
[null,"Final reports"]
[null,null,"Final narrative report for all awards"]
[null,null,"You are not expected to complete a bespoke final narrative report for us once your training/programme ends, we would however appreciate a copy of any final narrative report you will provide for your majority funder.  Preferably this report would draw on feedback from participants, facilitators and industry partners, collected during the project, about their views on the organisation and delivery of the programme. Please speak to your ScreenSkills contact if you require further information."]
[null,"Notes"]
[null,null,"VAT"]
[null,null,"If you are VAT-registered, please note that this funding is out of scope and therefore no VAT can be claimed against any costs which you might incur on this programme. You may wish to seek additional guidance from HMRC."]
[null,"Need any help? "]
[null,"If you have any questions or run into any problems using the Project and Budget report \nplease contact the Fund Team 020 7713 9800"]

{"sheet":"EXAMPLE Budget vs Actual","index":1,"n_rows":175,"n_cols":22,"rows_kept":175,"cut":false,"hidden":true,"merged":[[151,8,152,18],[153,2,153,5],[154,2,154,4],[155,2,155,4],[156,2,156,4],[30,1,30,4],[6,12,6,13],[6,14,6,15],[7,8,7,9],[7,10,7,11],[7,12,7,13],[8,1,8,6],[9,5,9,6],[18,1,18,4],[19,5,19,6],[28,1,28,4],[7,14,7,15],[6,10,6,11],[147,1,147,4],[151,2,152,5],[35,1,35,4],[38,1,38,4],[42,1,42,6],[56,1,56,4],[69,1,69,4],[82,1,82,4],[95,1,95,4],[108,1,108,4],[121,1,121,4],[134,1,134,4],[4,2,4,3],[4,4,4,5],[5,2,5,3],[5,4,5,5],[6,8,6,9],[2,8,4,15],[3,2,3,3],[3,4,3,5],[0,20,1,20],[1,2,1,3],[1,4,1,5],[2,2,2,3],[2,4,2,5]]}
[]
[null,null,"Organisation Name:",null,"Trainers R Us"]
[null,null,"Project Title:",null,"Camera Skills",null,null,null,"This is an example budget and cashflow. \nIt shows the level of detail that is required for the breakdown of a project budget. "]
[null,null,"Project Ref No:",null,"ScreenSkills generated",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click button to fill in the budget per period if your application is successful"]
[null,null,"Project start date:",null,"2022-01-04"]
[null,null,"Project end date:",null,"2022-12-31"]
[null,"Budget vs Actual",null,null,null,null,null,null,"Jan - Mar 22",null,"Apr - Jun 22",null,"Jul - Sep 22",null,"Oct - Dec 22"]
[null,null,null,null,null,null,null,null,"Period 1",null,"Period 2 ",null,"Period 3",null,"Period 4"]
[null,"PARTNERSHIP FUNDING (INCOME) BUDGET"]
[]
[null,"Partnership Funding CASH - (Source)\nDescription/Details","Units\ne.g. days","Number","Unit Income £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,"Participants' Fees (20 participants x £300)","Participants",20,300,{"$f":"E12*D12","v":6000},{"$f":"IF($F$150=0,\"\",F12/$F$150)","v":0.23828435266084194},null,null,null,2000,null,4000,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I12:$P12)=F12,SUMIF($I$11:$P$11,\"*budget*\",$I12:$P12),\"Error in Period Budget\")","v":6000},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I12:$P12)","v":0},{"$f":"F12-R12","v":6000}]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I13:$P13)=F13,SUMIF($I$11:$P$11,\"*budget*\",$I13:$P13),\"Error in Period Budget\")","v":0},0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total (A)",null,null,null,{"$f":"SUM(F12:F18)","v":6000},0.23828435266084194,null,0,0,2000,0,4000,0,0,0,{"$f":"SUM(Q12:Q18)","v":6000},0,6000]
[]
[null,"Partnership Funding 'IN-KIND' SUPPORT - (Source)\nDescription/Details","Units\ne.g. days","Number","Unit Income £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,"Camera equipment loan by Camera Inc. (20 cameras)","Days",6,1000,{"$f":"E22*D22","v":6000},{"$f":"IF($F$150=0,\"\",F22/$F$150)","v":0.23828435266084194},null,null,null,2000,null,2000,null,2000,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I22:$P22)=F22,SUMIF($I$11:$P$11,\"*budget*\",$I22:$P22),\"Error in Period Budget\")","v":6000},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I22:$P22)","v":0},{"$f":"F22-R22","v":6000}]
[null,"Room Hire (Conference Centre Edinburgh)","Days",6,175,1050,4.1699761715647342E-2,null,null,null,350,null,350,null,350,null,1050,0,1050]
[null,"Website updating by our web developers (Web Inc.)",null,1,350,350,1.3899920571882446E-2,null,350,null,null,null,null,null,null,null,350,0,350]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,{"$f":"E26*D26","v":0},0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total (B)",null,null,null,{"$f":"SUM(F22:F28)","v":7400},0.29388403494837173,null,350,0,2350,0,2350,0,2350,0,{"$f":"SUM(Q22:Q28)","v":7400},0,7400]
[]
[null,"Partnership Funding Subtotal (Cash & In-kind) (A+B)",null,null,null,{"$f":"F19+F29","v":13400},{"$f":"G29+G19","v":0.5321683876092137},null,{"$f":"I19+I29","v":350},0,4350,0,6350,0,2350,0,13400,0,13400]
[]
[]
[null,"ScreenSkills Funding",null,null,null,"Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,"ScreenSkills Funding",null,null,11780,{"$f":"E35","v":11780},{"$f":"IF($F$150=0,\"\",F35/$F$150)","v":0.46783161239078636},null,2962.5,null,3847.5,null,397.5,null,4572.5,null,{"$f":"SUMIF($I$11:$P$11,\"*budget*\",$I35:$P35)","v":11780},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I35:$P35)","v":0},{"$f":"F35-R35","v":11780}]
[null,"Total ScreenSkills Funding (C)",null,null,null,{"$f":"SUM(F35:F35)","v":11780},0.46783161239078636,null,2962.5,0,3847.5,0,397.5,0,4572.5,0,11780,0,11780]
[]
[]
[null,"Project Income TOTAL (Partnership Funding Total + ScreenSkills Total) (A+B+C)",null,null,null,{"$f":"F31+F36","v":25180},1,null,3312.5,0,8197.5,0,6747.5,0,6922.5,0,25180,0,25180]
[]
[]
[]
[null,"PROJECT EXPENDITURE BUDGET",null,null,null,null,null,null,null," ",null," ",null," ",null," "," "," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "]
[null,"Training (speakers, venue hire, travel for those delivering training etc)","Units\ne.g. days","Number","Unit Cost £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,"Trainer fee - Adam Smith"," Days",6,700,{"$f":"E46*D46","v":4200},{"$f":"IF($F$150=0,\"\",F46/$F$150)","v":0.16679904686258937},null,null,null,1400,null,1400,null,1400,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I46:$P46)=F46,SUMIF($I$11:$P$11,\"*budget*\",$I46:$P46),\"Error in Period Budget\")","v":4200},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I46:$P46)","v":0},{"$f":"F46-R46","v":4200}]
[null,"Course manual for 20 participants",null,20,10,200,7.9428117553613977E-3,null,200,null,null,null,null,null,null,null,200,0,200]
[null,"Course tutor's travel costs to Edinburgh from Glasgow for 6 days training","Days ",6,50,300,1.1914217633042097E-2,null,null,null,125,null,125,null,50,null,300,0,300]
[null,"Technical assistant for 6 days training","Days",6,200,1200,4.765687053216839E-2,null,null,null,400,null,400,null,400,null,1200,0,1200]
[null,"Subsistence for participants ","6 days for 21 ppl",6,105,630,2.5019857029388404E-2,null,null,null,210,null,210,null,210,null,630,0,630]
[null,"Room Hire (Conference Centre Edinburgh) (In Kind)","Days",6,175,1050,4.1699761715647342E-2,null,null,null,350,null,350,null,350,null,1050,0,1050]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total ",null,null,null,{"$f":"SUM(F46:F56)","v":7580},0.30103256552819696,null,200,0,2485,0,2485,0,2410,0,7580,0,7580]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "]
[null,"Project Management (e.g. Intenal managers, administrators)","Units\ne.g. days","Number","Unit Cost £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,"Project Manager 2 days per week for 4 mths","Days",20,250,{"$f":"E60*D60","v":5000},{"$f":"IF($F$150=0,\"\",F60/$F$150)","v":0.19857029388403494},null,1250,null,1250,null,1250,null,1250,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I60:$P60)=F60,SUMIF($I$11:$P$11,\"*budget*\",$I60:$P60),\"Error in Period Budget\")","v":5000},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I60:$P60)","v":0},{"$f":"F60-R60","v":5000}]
[null,"Project Coordinator 1 day per month for 4 mths","Days",11,150,1650,6.5528196981731526E-2,null,412.5,null,412.5,null,412.5,null,412.5,null,1650,0,1650]
[null,"Travel to Edinburgh (return) ","Director + Coordinator",2,225,450,1.7871326449563147E-2,null,null,null,450,null,null,null,null,null,450,0,450]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total ",null,null,null,{"$f":"SUM(F60:F69)","v":7100},0.28196981731532961,null,1662.5,0,2112.5,0,1662.5,0,1662.5,0,{"$f":"SUM(Q60:Q69)","v":7100},0,7100]
[]
[null,"Overheads (rent, light, heating etc)","Units\ne.g. days","Number","Unit Cost £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,"10% of office rent ",null,12,100,{"$f":"E73*D73","v":1200},{"$f":"IF($F$150=0,\"\",F73/$F$150)","v":4.765687053216839E-2},null,300,null,300,null,300,null,300,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I73:$P73)=F73,SUMIF($I$11:$P$11,\"*budget*\",$I73:$P73),\"Error in Period Budget\")","v":1200},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I73:$P73)","v":0},{"$f":"F73-R73","v":1200}]
[null,"Lighting ",null,12,50,600,2.3828435266084195E-2,null,150,null,150,null,150,null,150,null,600,0,600]
[null,"Heating",null,12,50,600,2.3828435266084195E-2,null,150,null,150,null,150,null,150,null,600,0,600]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total ",null,null,null,{"$f":"SUM(F73:F82)","v":2400},9.5313741064336779E-2,null,600,0,600,0,600,0,600,0,{"$f":"SUM(Q73:Q82)","v":2400},0,2400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "]
[null,"Marketing/Recruitment ","Units\ne.g. days","Number","Unit Cost £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,"Art work design",null,1,500,{"$f":"E86*D86","v":500},{"$f":"IF($F$150=0,\"\",F86/$F$150)","v":1.9857029388403495E-2},null,500,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I86:$P86)=F86,SUMIF($I$11:$P$11,\"*budget*\",$I86:$P86),\"Error in Period Budget\")","v":500},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I86:$P86)","v":0},{"$f":"F86-R86","v":500}]
[null,"Website (in kind)",null,1,350,350,1.3899920571882446E-2,null,350,null,null,null,null,null,null,null,350,0,350]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total ",null,null,null,{"$f":"SUM(F86:F95)","v":850},3.3756949960285942E-2,null,850,0,0,0,0,0,0,0,{"$f":"SUM(Q86:Q95)","v":850},0,850]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "]
[null,"Access Support (Childcare cost, Disability Support, Hardship)","Units\ne.g. days","Number","Unit Cost £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,"Travel costs for participants with access needs","Participants",5,200,{"$f":"E99*D99","v":1000},{"$f":"IF($F$150=0,\"\",F99/$F$150)","v":3.971405877680699E-2},null,null,null,1000,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I99:$P99)=F99,SUMIF($I$11:$P$11,\"*budget*\",$I99:$P99),\"Error in Period Budget\")","v":1000},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I99:$P99)","v":0},{"$f":"F99-R99","v":1000}]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total ",null,null,null,{"$f":"SUM(F99:F108)","v":1000},3.971405877680699E-2,null,0,0,1000,0,0,0,0,0,{"$f":"SUM(Q99:Q108)","v":1000},0,1000]
[]
[null,"Equipment ","Units\ne.g. days","Number","Unit Cost £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,"Camera equipment loan by Camera Inc. (20 cameras) (in kind)","Days",6,1000,{"$f":"E112*D112","v":6000},{"$f":"IF($F$150=0,\"\",F112/$F$150)","v":0.23828435266084194},null,null,null,2000,null,2000,null,2000,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I112:$P112)=F112,SUMIF($I$11:$P$11,\"*budget*\",$I112:$P112),\"Error in Period Budget\")","v":6000},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I112:$P112)","v":0},{"$f":"F112-R112","v":6000}]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total ",null,null,null,{"$f":"SUM(F112:F121)","v":6000},0.23828435266084194,null,0,0,2000,0,2000,0,2000,0,{"$f":"SUM(Q112:Q121)","v":6000},0,6000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "]
[null,"Other (please provide breakdown of any costs that do not fit into other areas of ths budget)","Units\ne.g. days","Number","Unit Cost £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,null,null,null,null,{"$f":"E125*D125","v":0},{"$f":"IF($F$150=0,\"\",F125/$F$150)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I125:$P125)=F125,SUMIF($I$11:$P$11,\"*budget*\",$I125:$P125),\"Error in Period Budget\")","v":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I125:$P125)","v":0},{"$f":"F125-R125","v":0}]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total ",null,null,null,{"$f":"SUM(F125:F134)","v":0},0,null,0,0,0,0,0,0,0,0,{"$f":"SUM(Q125:Q134)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "]
[null,"Evaluation (for projects where ScreenSkills fuding amounts to £50,000 + only will require and independent audit. Remember to budget for this)","Units\ne.g. days","Number","Unit Cost £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,"Project Evaluation by Project Manager to work on narrative report","Days",1,250,{"$f":"E138*D138","v":250},{"$f":"IF($F$150=0,\"\",F138/$F$150)","v":9.9285146942017476E-3},null,null,null,null,null,null,null,250,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I138:$P138)=F138,SUMIF($I$11:$P$11,\"*budget*\",$I138:$P138),\"Error in Period Budget\")","v":250},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I138:$P138)","v":0},{"$f":"F138-R138","v":250}]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I139:$P139)=F139,SUMIF($I$11:$P$11,\"*budget*\",$I139:$P139),\"Error in Period Budget\")","v":0},0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total ",null,null,null,{"$f":"SUM(F138:F147)","v":250},9.9285146942017476E-3,null,0,0,0,0,0,0,250,0,{"$f":"SUM(Q138:Q147)","v":250},0,250]
[]
[null,"TOTAL PROJECT EXPENDITURE - ( C )",null,null,null,{"$f":"F57+F70+F83+F96+F109+F135+F122+F148","v":25180},{"$f":"G57+G70+G83+G96+G109+G135+G122+G148","v":1},null,{"$f":"I148+I135+I122+I109+I96+I83+I57+I70","v":3312.5},0,8197.5,0,6747.5,0,6922.5,0,25180,0,25180]
[]
[null,null,"ScreenSkills USE ONLY",null,null,null,null,null,"ScreenSkills USE ONLY"]
[]
[null,null,"Project Summary",null,null,null,null,null,{"$f":"I137","v":"Budget P1 (£)"},"Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance"]
[null,null,"Total Project Income",null,null,{"$f":"F39","v":25180},null,null,{"$f":"I39","v":3312.5},0,8197.5,0,6747.5,0,6922.5,0,{"$f":"SUMIF($I$11:$P$11,\"*budget*\",$I155:$P155)","v":25180},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I155:$P155)","v":0},{"$f":"F155-R155","v":25180}]
[null,null,"Total Project Expenditure",null,null,{"$f":"F150","v":25180},null,null,{"$f":"I150","v":3312.5},0,8197.5,0,6747.5,0,6922.5,0,{"$f":"SUMIF($I$11:$P$11,\"*budget*\",$I156:$P156)","v":25180},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I156:$P156)","v":0},{"$f":"F156-R156","v":25180}]
[null,null,"Total Project Cost (expenditure minus income)",null,null,{"$f":"F156-F155","v":0},null,null,{"$f":"I155-I156","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"Narrative on Overheads & Project Management Costs"]
[null,"Please use this section to tell us how you have calculated your overheads and project management costs:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Notes to the Budget"]

{"sheet":"1. Budget","index":3,"n_rows":197,"n_cols":20,"rows_kept":197,"cut":false,"hidden":false,"merged":[[178,2,178,4],[1,4,1,5],[2,4,2,5],[3,4,3,5],[4,4,4,5],[5,4,5,5],[156,1,156,4],[130,1,130,4],[117,1,117,4],[177,2,177,4],[176,2,176,4],[169,1,169,4],[173,2,174,5],[42,1,42,4],[44,1,44,6],[171,1,171,4],[0,20,1,20],[8,1,8,6],[34,1,34,4],[38,1,38,6],[143,1,143,4],[1,2,1,3],[2,2,2,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[9,5,9,6],[12,1,12,4],[7,8,7,9],[6,8,6,9],[20,1,20,4],[173,8,174,18],[6,14,6,15],[175,2,175,5],[7,10,7,11],[7,12,7,13],[7,14,7,15],[6,10,6,11],[6,12,6,13],[78,1,78,4],[91,1,91,4],[104,1,104,4],[13,5,13,6],[22,1,22,6],[32,1,32,4]]}
[]
[null,null,"Organisation Name:",null,"Please add"]
[null,null,"Project Title:",null,"Please add"]
[null,null,"Project Ref No:",null,"ScreenSkills generated"]
[null,null,"Project start date:",null,"Please add"]
[null,null,"Project end date:",null,"Please add"]
[null,"Budget",null,null,null,null,null,null,"Date to be added \ne.g. Jan - Mar 22",null,"Date to be added",null,"Date to be added",null,"Date to be added"]
[null,null,null,null,null,null,null,null,"Period 1",null,"Period 2 ",null,"Period 3",null,"Period 4"]
[null," Project Budget"]
[]
[null,"Total Project Budget Please provide the total cost of this project.",null,null,"Amount","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,"Total Project Budget",null,null,null,{"$f":"E12","v":0},1,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I12:$P12)=F12,SUMIF($I$11:$P$11,\"*budget*\",$I12:$P12),\"Error in Period Budget\")","v":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I12:$P12)","v":0},{"$f":"F12-R12","v":0}]
[null,"Total ",null,null,null,{"$f":"SUM(F12:F12)","v":0},{"$f":"SUM(G12:G12)","v":1},null,{"$f":"SUM(I12:I12)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"Contributing Funders (Income) Please list all of the income streams for this project other than ScreenSkills.",null,null,"Amount","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,null,null,null,null,{"$f":"E16","v":0},{"$f":"F16/F12","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I16:$P16)=F16,SUMIF($I$11:$P$11,\"*budget*\",$I16:$P16),\"Error in Period Budget\")","v":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I16:$P16)","v":0},{"$f":"F16-R16","v":0}]
[null,null,null,null,null,{"$f":"E17","v":0},{"$f":"F17/F13","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F18/F13","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F19/F13","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F20/F13","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total ",null,null,null,{"$f":"SUM(F16:F20)","v":0},{"$f":"SUM(G16:G20)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(I16:I20)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"IN-KIND EXPENDITURE"]
[]
[null,"Partnership Expenditure 'IN-KIND' SUPPORT - (Source)\nDescription/Details","Units\ne.g. days","Number","Unit Income £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,null,null,null,null,{"$f":"E26*D26","v":0},{"$f":"IF($F$172=0,\"\",F26/$F$172)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I26:$P26)=F26,SUMIF($I$11:$P$11,\"*budget*\",$I26:$P26),\"Error in Period Budget\")","v":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I26:$P26)","v":0},{"$f":"F26-R26","v":0}]
[null,null,null,null,null,0,{"$f":"IF($F$172=0,\"\",F27/$F$172)","v":""},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I30:$P30)=F30,SUMIF($I$11:$P$11,\"*budget*\",$I30:$P30),\"Error in Period Budget\")","v":0},0,{"$f":"F30-R30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I31:$P31)=F31,SUMIF($I$11:$P$11,\"*budget*\",$I31:$P31),\"Error in Period Budget\")","v":0},0,{"$f":"F31-R31","v":0}]
[]
[null,"Partnership Funding Subtotal (Expenditure) (C)",null,null,null,{"$f":"SUM(F26:F32)","v":0},0,null,{"$f":"SUM(I26:I32)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(Q26:Q32)","v":0},0,0]
[]
[null,"Project in-kind Income & Expenditure (A+B+C)",null,null,null,{"$f":"#REF!-F33","v":{"$error":"#REF!"}},{"$f":"#REF!-G33","v":{"$error":"#REF!"}},null,{"$f":"#REF!-I33","v":{"$error":"#REF!"}},{"$f":"#REF!-J33","v":{"$error":"#REF!"}},{"$f":"#REF!-K33","v":{"$error":"#REF!"}},{"$f":"#REF!-L33","v":{"$error":"#REF!"}},{"$f":"#REF!-M33","v":{"$error":"#REF!"}},{"$f":"#REF!-N33","v":{"$error":"#REF!"}},{"$f":"#REF!-O33","v":{"$error":"#REF!"}},{"$f":"#REF!-P33","v":{"$error":"#REF!"}},{"$f":"#REF!-Q33","v":{"$error":"#REF!"}},{"$f":"#REF!-R33","v":{"$error":"#REF!"}},{"$f":"#REF!-S33","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,"SCREENSKILLS FUNDING",null,null,null,null,null,null,null," ",null," ",null," ",null," "," "," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "]
[null,"ScreenSkills Funding (Income)",null,null,"Amount","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,"SceenSkills Funding",null,null,null,{"$f":"E42","v":0},{"$f":"F42/F12","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($I$11:$P$11,\"*budget*\",$I42:$P42)","v":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I42:$P42)","v":0},{"$f":"F42-R42","v":0}]
[null,"Total",null,null,null,{"$f":"F42","v":0},{"$f":"SUM(G42:G42)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(I42:I42)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"SCREENSKILLS GRANT EXPENDITURE"]
[]
[null,"Description (Training, Project Management, Overheads, etc)","Units\ne.g. days","Number","Unit Cost £","Total (£)","% of ScreenSkills Grant",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,null,null,null,null,{"$f":"E48*D48","v":0},{"$f":"F48/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I48:$P48)=F48,SUMIF($I$11:$P$11,\"*budget*\",$I48:$P48),\"Error in Period Budget\")","v":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I48:$P48)","v":0},{"$f":"F48-R48","v":0}]
[null,null,null,null,null,{"$f":"E49*D49","v":0},{"$f":"F49/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I49:$P49)=F49,SUMIF($I$11:$P$11,\"*budget*\",$I49:$P49),\"Error in Period Budget\")","v":0},0,{"$f":"F49-R49","v":0}]
[null,null,null,null,null,{"$f":"E50*D50","v":0},{"$f":"F50/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F51/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,{"$f":"E52*D52","v":0},{"$f":"F52/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F53/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F54/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F55/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F56/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F57/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,{"$f":"E58*D58","v":0},{"$f":"F58/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F59/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I59:$P59)=F59,SUMIF($I$11:$P$11,\"*budget*\",$I59:$P59),\"Error in Period Budget\")","v":0},0,{"$f":"F59-R59","v":0}]
[null,null,null,null,null,0,{"$f":"F60/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F61/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,{"$f":"E62*D62","v":0},{"$f":"F62/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F63/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F64/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F65/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F66/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F67/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F68/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F69/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F70/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F71/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F72/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F73/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F74/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F75/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,{"$f":"F76/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,{"$f":"E77*D77","v":0},{"$f":"F77/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I77:$P77)=F77,SUMIF($I$11:$P$11,\"*budget*\",$I77:$P77),\"Error in Period Budget\")","v":0},0,{"$f":"F77-R77","v":0}]
[null,null,null,null,null,0,{"$f":"F78/F43","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total ",null,null,null,{"$f":"SUM(F48:F78)","v":0},{"$f":"SUM(G48:G78)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(I48:I78)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "]
[null,"Project Management (e.g. Intenal managers, administrators)","Units\ne.g. days","Number","Unit Cost £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,null,null,null,null,{"$f":"E82*D82","v":0},{"$f":"IF($F$172=0,\"\",F82/$F$172)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I82:$P82)=F82,SUMIF($I$11:$P$11,\"*budget*\",$I82:$P82),\"Error in Period Budget\")","v":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I82:$P82)","v":0},{"$f":"F82-R82","v":0}]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total ",null,null,null,{"$f":"SUM(F82:F91)","v":0},0,null,0,0,0,0,0,0,0,0,{"$f":"SUM(Q82:Q91)","v":0},0,0]
[]
[null,"Overheads (rent, light, heating etc)","Units\ne.g. days","Number","Unit Cost £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,null,null,null,null,{"$f":"E95*D95","v":0},{"$f":"IF($F$172=0,\"\",F95/$F$172)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I95:$P95)=F95,SUMIF($I$11:$P$11,\"*budget*\",$I95:$P95),\"Error in Period Budget\")","v":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I95:$P95)","v":0},{"$f":"F95-R95","v":0}]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total ",null,null,null,{"$f":"SUM(F95:F104)","v":0},0,null,0,0,0,0,0,0,0,0,{"$f":"SUM(Q95:Q104)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "]
[null,"Marketing/Recruitment ","Units\ne.g. days","Number","Unit Cost £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,null,null,null,null,{"$f":"E108*D108","v":0},{"$f":"IF($F$172=0,\"\",F108/$F$172)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I108:$P108)=F108,SUMIF($I$11:$P$11,\"*budget*\",$I108:$P108),\"Error in Period Budget\")","v":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I108:$P108)","v":0},{"$f":"F108-R108","v":0}]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total ",null,null,null,{"$f":"SUM(F108:F117)","v":0},0,null,0,0,0,0,0,0,0,0,{"$f":"SUM(Q108:Q117)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "]
[null,"Access Support (Childcare cost, Disability Support, Hardship)","Units\ne.g. days","Number","Unit Cost £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,null,null,null,null,{"$f":"E121*D121","v":0},{"$f":"IF($F$172=0,\"\",F121/$F$172)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I121:$P121)=F121,SUMIF($I$11:$P$11,\"*budget*\",$I121:$P121),\"Error in Period Budget\")","v":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I121:$P121)","v":0},{"$f":"F121-R121","v":0}]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total ",null,null,null,{"$f":"SUM(F121:F130)","v":0},0,null,0,0,0,0,0,0,0,0,{"$f":"SUM(Q121:Q130)","v":0},0,0]
[]
[null,"Equipment ","Units\ne.g. days","Number","Unit Cost £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,null,null,null,null,{"$f":"E134*D134","v":0},{"$f":"IF($F$172=0,\"\",F134/$F$172)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I134:$P134)=F134,SUMIF($I$11:$P$11,\"*budget*\",$I134:$P134),\"Error in Period Budget\")","v":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I134:$P134)","v":0},{"$f":"F134-R134","v":0}]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total ",null,null,null,{"$f":"SUM(F134:F143)","v":0},0,null,0,0,0,0,0,0,0,0,{"$f":"SUM(Q134:Q143)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "]
[null,"Other (please provide breakdown of any costs that do not fit into other areas of ths budget)","Units\ne.g. days","Number","Unit Cost £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,null,null,null,null,{"$f":"E147*D147","v":0},{"$f":"IF($F$172=0,\"\",F147/$F$172)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I147:$P147)=F147,SUMIF($I$11:$P$11,\"*budget*\",$I147:$P147),\"Error in Period Budget\")","v":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I147:$P147)","v":0},{"$f":"F147-R147","v":0}]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total ",null,null,null,{"$f":"SUM(F147:F156)","v":0},0,null,0,0,0,0,0,0,0,0,{"$f":"SUM(Q147:Q156)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "]
[null,"Evaluation (for projects where ScreenSkills fuding amounts to £50,000 + only will require and independent audit. Remember to budget for this)","Units\ne.g. days","Number","Unit Cost £","Total (£)","% of project costs",null,"Budget P1 (£)","Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance (£)","Reason for any difference +/- £1,000"]
[null,null,null,null,null,{"$f":"E160*D160","v":0},{"$f":"IF($F$172=0,\"\",F160/$F$172)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I160:$P160)=F160,SUMIF($I$11:$P$11,\"*budget*\",$I160:$P160),\"Error in Period Budget\")","v":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I160:$P160)","v":0},{"$f":"F160-R160","v":0}]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMIF($I$11:$P$11,\"*budget*\",$I161:$P161)=F161,SUMIF($I$11:$P$11,\"*budget*\",$I161:$P161),\"Error in Period Budget\")","v":0},0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total Expenditure ( E )",null,null,null,{"$f":"SUM(F160:F169)","v":0},0,null,0,0,0,0,0,0,0,0,{"$f":"SUM(Q160:Q169)","v":0},0,0]
[]
[null,"TOTAL SPEND",null,null,null,{"$f":"F79","v":0},{"$f":"G79+G92+G105+G118+G131+G157+G144+G170","v":{"$error":"#DIV/0!"}},null,{"$f":"I170+I157+I144+I131+I118+I105+I79+I92","v":0},0,0,0,0,0,0,0,{"$f":"Q170+Q157+Q144+Q131+Q118+Q105+Q79+Q92","v":0},0,0]
[]
[null,null,"ScreenSkills USE ONLY",null,null,null,null,null,"ScreenSkills USE ONLY"]
[]
[null,null,"Project Summary",null,null,null,null,null,{"$f":"I159","v":"Budget P1 (£)"},"Actuals P1 (£)","Budget P2 (£)","Actuals P2 (£)","Budget P3 (£)","Actuals P3 (£)","Budget P4 (£)","Actuals P4 (£)","Total Budget","Total Actual","Variance"]
[null,null,"Total Project Income",null,null,{"$f":"F43","v":0},null,null,{"$f":"I35","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUMIF($I$11:$P$11,\"*budget*\",$I177:$P177)","v":{"$error":"#REF!"}},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I177:$P177)","v":{"$error":"#REF!"}},{"$f":"F177-R177","v":{"$error":"#REF!"}}]
[null,null,"Total Project Expenditure",null,null,{"$f":"F172","v":0},null,null,{"$f":"I172","v":0},0,0,0,0,0,0,0,{"$f":"SUMIF($I$11:$P$11,\"*budget*\",$I178:$P178)","v":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I178:$P178)","v":0},{"$f":"F178-R178","v":0}]
[null,null,"Total Project Cost (expenditure minus income)",null,null,{"$f":"F178-F177","v":0},null,null,{"$f":"I177-I178","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"Q177-Q178","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"Narrative on Overheads & Project Management Costs"]
[null,"Please use this section to tell us how you have calculated your overheads and project management costs:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Notes to the Budget"]

{"sheet":"2. Risk Analysis","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":true,"merged":[[2,1,2,5],[3,1,3,5]]}
[]
[null,"Risk Analysis"]
[null,"On this tab you should identify the risks, constraints and dependencies in delivering the project and outline how these will be managed.\n\nPlease describe how these risks will be monitored and reported. "]
[null,"This is an example please complete the table below this one"]
[null,"Risk","Description of Impact","How to Mitigate risk","Course of action if risk becomes reality (i.e. what is flexible, what are our limits)","High/Medium/low"]
[null,"Participants\nAbility to recruit the target number that have the required level of skills/experience.","The course is aimed at tutoring 8 participants- with specific area of expertise in the camera department.\n\nWith high-fee commitment's to industry expert tutors of £20K the right calibre of participants should be recruited. \n\nThe number of participants, their availability, calibre of participants and applicants are relying on word of mouth and marketing to the industry.","Assess the response from the high level talent.\n\nLower the participant’s level- more intermediate than high level/ supervisor types.\n\nTargeted marketing\n\nLook at all key personnel involved availability in running at a later date.\n","Reassess participant targets\n\nCould lower target to 6 participants or participant grade\n\n\n","Medium. \n"]
[null,"Course Content \nIs the course curriculum the right level for participants?","The course is split in to 2 parts- first two weeks are craft and technical based; the second part is aimed at on-set working practices with seminars and masterclasses. ","Securing the key industry professionals to feed in to structure\n\nAttract the intermediate level talent\n\nFinding the right tutors to complement the overall aims of the project. ","Could make the first part of the course one week followed by one week of the masterclass \n\nTutors to review curriculum once participants are recruited to ensure suitabiilty","Medium. \n"]
[null,"Training providers\nDo the tutors have the required skills/experience?","Experienced training providers taking on and delivering the first course/pilot.","Ensure recruitment process is robust\n\nUtilise network of contacts for suitable recommendations\n\nUse companies that have been used before\n","Give as much support/ advice and help as possible and be more involved in having a presence during the course.","Low.  \n\nThe company are experienced Training providers with a good track record of delivering training in this sector."]
[null,"Dates\nThe chosen dates result in low applicant numbers","Is August an appropriate time for key industry talent to take training?\n\nHigh level Participants availability\n\nTutors availabilty","Ensure detailed research is conducted and key industry figures are consulted.\n\nAsk key industry personnel about timings against the greenlight/ pre-production start dates\n\nConsider time of date and length of course","Our limit is to run the course in current financial year\n\nSummer productions could have a  knock on effect for both participants and tutors.\n\nCould lower the participant criteria to ensure numbers. ","Medium/High\n\n"]
[]
[null,"Risk","Description of Impact","How to Mitigate risk","Course of action if risk becomes reality (i.e. what is flexible, what are our limits)","High/Medium/low"]

{"sheet":"3. Project Report","index":5,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":true,"merged":[[61,1,62,1],[61,2,62,2],[61,3,62,3],[45,1,46,1],[23,3,24,3],[23,1,24,1],[34,1,35,1],[61,4,62,4],[23,4,24,4],[45,2,46,2],[11,2,12,2],[45,4,46,4],[34,4,35,4],[45,3,46,3],[34,3,35,3],[34,2,35,2],[9,1,9,8],[11,1,12,1],[11,4,12,4],[11,3,12,3],[23,2,24,2]]}
[]
[null,"Project Details"]
[]
[null,"The name of your organisation:",{"$f":"'1. Budget'!E2","v":"Please add"},null,null,"Colour code progress:"]
[null,"Project title:",{"$f":"'1. Budget'!E3","v":"Please add"},null,null,"ON TARGET"]
[null,"Project start date:",null,"Project end date:",null,"MINOR ISSUES"]
[null,"Course start date:",null,"Course end date:",null,"SERIOUS ISSUES"]
[null,"Closing date for applications:",null,null,null,"NO CHANGE"]
[]
[null,"Please report on your activity when submitting your claim for that period. Please use the colour coding shown above. "]
[null,"PARTICIPANT NUMBERS"]
[null,"Activity","Expected Date for completion","What will success look like?","How will this be measured?","Period 1","Period 2","Period 3","Period 4"]
[null,null,null,null,null,"Progress, including any unexpected results or budget variance updated with each claim","Progress, including any unexpected results or budget variance updated with each claim","Progress, including any unexpected results or budget variance updated with each claim","Progress, including any unexpected results or budget variance updated with each claim"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TRAINING"]
[null,"Activity","Course / Session Dates","What will success look like?","How will this be measured?","Period 1","Period 2","Period 3","Period 4"]
[null,null,null,null,null,"Progress, including any unexpected results or budget variance updated with each claim","Progress, including any unexpected results or budget variance updated with each claim","Progress, including any unexpected results or budget variance updated with each claim","Progress, including any unexpected results or budget variance updated with each claim"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PROJECT MANAGEMENT"]
[null,"Activity","Expected Date for completion","What will success look like?","How will this be measured?","Period 1","Period 2","Period 3","Period 4"]
[null,null,null,null,null,"Progress, including any unexpected results or budget variance updated with each claim","Progress, including any unexpected results or budget variance updated with each claim","Progress, including any unexpected results or budget variance updated with each claim","Progress, including any unexpected results or budget variance updated with each claim"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"MARKETING / RECRUITMENT"]
[null,"Activity","Expected Date for completion","What will success look like?","How will this be measured?","Period 1","Period 2","Period 3","Period 4"]
[null,null,null,null,null,"Progress, including any unexpected results or budget variance updated with each claim","Progress, including any unexpected results or budget variance updated with each claim","Progress, including any unexpected results or budget variance updated with each claim","Progress, including any unexpected results or budget variance updated with each claim"]
[null,"Marketing"]
[]
[]
[]
[]
[]
[null,"Recruitment"]
[]
[]
[]
[]
[]
[]
[null,"EVALUATION"]
[null,"Learning Outcomes (Stated in your application)","Expected Date for completion","What will success look like?","How will this be measured?","Period 1","Period 2","Period 3","Period 4"]
[null,null,null,null,null,"Progress, including any unexpected results or budget variance updated with each claim","Progress, including any unexpected results or budget variance updated with each claim","Progress, including any unexpected results or budget variance updated with each claim","Progress, including any unexpected results or budget variance updated with each claim"]

{"sheet":"4. Claim Form","index":6,"n_rows":89,"n_cols":5,"rows_kept":89,"cut":false,"hidden":true,"merged":[[0,1,0,5],[4,2,4,4],[5,2,5,4],[6,2,6,4],[10,2,10,4],[2,2,2,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[15,1,15,2],[15,3,15,4],[18,1,18,2],[20,1,20,2],[17,1,17,2],[34,1,34,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[28,1,28,2],[31,1,31,2],[33,1,33,2],[32,1,32,2],[27,1,27,2],[29,1,29,2],[43,1,43,2],[43,3,43,4],[37,1,37,2],[41,1,41,2],[41,3,42,4],[42,1,42,2]]}
[]
[]
[null,"Claim Form"]
[]
[null,"Organisation Name:",{"$f":"'1. Budget'!E2","v":"Please add"}]
[null,"Project Title:",{"$f":"'1. Budget'!E3","v":"Please add"}]
[null,"Project Ref No:",{"$f":"'1. Budget'!E4","v":"ScreenSkills generated"}]
[]
[null,"Payments will be deposited in the following account:"]
[]
[null,"Bank Name: ","Please enter "]
[null,"Account Name: ","Please enter "]
[null,"Sort Code: ","Please enter "]
[null,"Account Number: ","Please enter "]
[]
[null,"Period for which funds are requested:"]
[]
[null,"SUMMARY"]
[null,"Budget"]
[null,"Total Budget Income Partnership Funding cash ",null,{"$f":"'1. Budget'!F13","v":0}]
[null,"Total Budget Income Partnership Funding in-kind support",null,{"$f":"'1. Budget'!F21","v":0}]
[null,"Total ScreenSkills Grant Funding",null,{"$f":"'1. Budget'!F42","v":0}]
[null,"Total Budget Project Spend",null,{"$f":"'1. Budget'!F172","v":0}]
[]
[null,"ACTUALS",null,"£","%"]
[null,"Total Actual Expenditure Partnership Funding CASH ",null,{"$f":"'1. Budget'!R13","v":0},{"$f":"D26/#REF!","v":{"$error":"#REF!"}}]
[null,"Total Actual Income Partnership Funding IN-KIND",null,{"$f":"'1. Budget'!R21","v":0},{"$f":"D27/#REF!","v":{"$error":"#REF!"}}]
[null,"Total Actual Partnership Funding IN-KIND",null,{"$f":"'1. Budget'!#REF!","v":{"$error":"#REF!"}},{"$f":"D28/#REF!","v":{"$error":"#REF!"}}]
[null,"ScreenSkills funds claimed to date ",null,null,{"$f":"D30/#REF!","v":{"$error":"#REF!"}}]
[null,"Total Actual Spend To Date",null,{"$f":"'1. Budget'!#REF!","v":{"$error":"#REF!"}},{"$f":"D31/#REF!","v":{"$error":"#REF!"}}]
[]
[null,"(Surplus)/Deficit At End Of Previous Period",null,{"$f":"#REF!-D26-D27-D30","v":{"$error":"#REF!"}},{"$f":"D32/#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Final 10% Retention",null,{"$f":"#REF!*0.1","v":{"$error":"#REF!"}},{"$f":"IF(D34=0,\"\",D34/#REF!)","v":{"$error":"#REF!"}}]
[null,"Remaining Grant to Claim during project less 10% retention",null,{"$f":"#REF!-D30-D34","v":{"$error":"#REF!"}},{"$f":"IF(D35=0,\"\",D35/#REF!)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Total Amount Due:",null,{"$f":"D32","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,"Signed by Grantee:",null,"Date: "]
[null,"Position: "]
[null,"ScreenSkills Internal Authorisation: ",null,"Date:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"For ScreenSkills use only"]
[]
[null,"Payment will be made according to the Contract Payment Schedule."]
[]
[null,"Claim examined.  I certify there is proper authority for the activity funded and no item in this claim has previously been passed for payment:"]
[null,"I certify that the activity has been carried out satisfactorily, the outcomes have been achieved and are satisfactory, the amounts claimed have been "]
[null,"checked and are correct and the terms and conditions of the Agreement expressed or implied have been met:"]
[]
[null,"Position:"]
[]
[]
[null,"Signature:"]
[]
[]
[null,"To be paid from:"]
[null,"Lottery","R2100"]
[null,"SIF","R2000"]

{"sheet":"Sheet1","index":7,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
["TM workings"]
[]
["Total expenditure",43636.650000000009]
[]
["SSkills paid to date",28227.05]
["Cash",0]
["Kind",1850]
["Difference",13559.600000000009]
[]
["Agreed award",64425]
["max based on %",42259.16837655018]
[]
["balance based on grant",36197.949999999997]
["balance based on %",14032.118376550181]
[]
["FINAL PAYMENT",13559.600000000009]