{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["How to Guide ","EXAMPLE Budget vs Actual","1. Budget vs Actual","2. Risk Analysis","3. Project Report","4. Claim Form"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":50,"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":"How to Guide ","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,22,2],[25,1,25,2],[30,1,30,2],[1,1,1,2],[2,1,2,2],[4,1,4,2],[13,1,13,2],[18,1,18,2],[21,1,21,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) and tab 2 (columns B-F) 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. Tabs 1 and 3 will need updating and this will be discussed further in your offer. "]
[]
[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,"Tab 2","Risk Analysis"]
[null,null,"On this tab you should identify the risks, constraints and dependencies in delivering the project and outline how these will be managed. Please see examples given for guidance. "]
[null,"Tab 3. ","Project Report"]
[null,null,"In this section, you will report on the progress of your project. At application stage we expect you to complete columns B-I. If successful, you will be expected to update ScreenSkills on your project each period when claiming funds, as well as any variance in participant numbers and finances.\n"]
[null,"Tab 4.","Claim Form"]
[null,null,"Once you have completed the update for each period in tab 1, the Claim form will work out how much you are owed based on formulae. This is for ScreenSKills use only, all formulae should NOT be changed.  When making a claim we require you to print this page off and sign it, before scanning the signed copy and returning it to us. This confirms that you are happy with the amount to be claimed.  Please do not alter any of the formulae on this form."]
[null,"Final reports"]
[null,null,"Final narrative report for all awards"]
[null,null,"You are expected to complete a final narrative report once your training/programme ends, this information will be circulated with your offer if successful.  This should tell us about what went well with the programme and how it could be improved.  This report should 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,null,"Independent Audit (for grants of £50k and over)"]
[null,null,"If the total value of your ScreenSkills grant is £50,000 or greater, your project will need to be audited upon completion by an external auditor.  Please contact the Fund Team for further information on audit requirements.  This cost should be factored into your budget (evaluation section). "]
[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":false,"merged":[[151,8,152,18],[153,2,153,5],[154,2,154,4],[155,2,155,4],[156,2,156,4],[2,8,4,15],[95,1,95,4],[108,1,108,4],[121,1,121,4],[134,1,134,4],[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],[8,1,8,6],[9,5,9,6],[18,1,18,4],[19,5,19,6],[28,1,28,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],[7,14,7,15],[4,2,4,3],[4,4,4,5],[5,2,5,3],[5,4,5,5],[6,8,6,9],[6,10,6,11],[0,20,1,20],[1,2,1,3],[1,4,1,5],[2,2,2,3],[2,4,2,5],[3,2,3,3],[3,4,3,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 vs Actual","index":2,"n_rows":175,"n_cols":22,"rows_kept":175,"cut":false,"hidden":false,"merged":[[156,2,156,4],[1,4,1,5],[2,4,2,5],[3,4,3,5],[4,4,4,5],[5,4,5,5],[134,1,134,4],[108,1,108,4],[95,1,95,4],[155,2,155,4],[154,2,154,4],[147,1,147,4],[151,2,152,5],[0,20,1,20],[8,1,8,6],[38,1,38,4],[42,1,42,6],[121,1,121,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],[18,1,18,4],[7,8,7,9],[6,8,6,9],[28,1,28,4],[30,1,30,4],[151,8,152,18],[6,14,6,15],[153,2,153,5],[7,10,7,11],[7,12,7,13],[7,14,7,15],[6,10,6,11],[6,12,6,13],[56,1,56,4],[35,1,35,4],[69,1,69,4],[82,1,82,4],[19,5,19,6]]}
[]
[null,null,"Organisation Name:",null,"Please add"]
[null,null,"Project Title:",null,"Please add"]
[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,"Please add"]
[null,null,"Project end date:",null,"Please add"]
[null,"Budget vs Actual",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,"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,null,null,null,null,{"$f":"E12*D12","v":0},{"$f":"IF($F$150=0,\"\",F12/$F$150)","v":""},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,null,null,null,null,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,"",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,{"$f":"E18*D18","v":0},"",null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total (A)",null,null,null,{"$f":"SUM(F12:F18)","v":0},0,null,0,0,0,0,0,0,0,0,{"$f":"SUM(Q12:Q18)","v":0},0,0]
[]
[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,null,null,null,null,{"$f":"E22*D22","v":0},{"$f":"IF($F$150=0,\"\",F22/$F$150)","v":""},null,null,null,null,null,null,null,null,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":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I22:$P22)","v":0},{"$f":"F22-R22","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,{"$f":"E24*D24","v":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,{"$f":"E26*D26","v":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 (B)",null,null,null,{"$f":"SUM(F22:F28)","v":0},0,null,0,0,0,0,0,0,0,0,{"$f":"SUM(Q22:Q28)","v":0},0,0]
[]
[null,"Partnership Funding Subtotal (Cash & In-kind) (A+B)",null,null,null,{"$f":"F19+F29","v":0},{"$f":"G29+G19","v":0},null,{"$f":"I19+I29","v":0},0,0,0,0,0,0,0,{"$f":"Q19+Q29","v":0},0,0]
[]
[]
[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,null,{"$f":"E35","v":0},{"$f":"IF($F$150=0,\"\",F35/$F$150)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($I$11:$P$11,\"*budget*\",$I35:$P35)","v":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I35:$P35)","v":0},{"$f":"F35-R35","v":0}]
[null,"Total ScreenSkills Funding (C)",null,null,null,{"$f":"SUM(F35:F35)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Project Income TOTAL (Partnership Funding Total + ScreenSkills Total) (A+B+C)",null,null,null,{"$f":"F31+F36","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[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,null,null,null,null,{"$f":"E46*D46","v":0},{"$f":"IF($F$150=0,\"\",F46/$F$150)","v":""},null,null,null,null,null,null,null,null,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":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I46:$P46)","v":0},{"$f":"F46-R46","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*\",$I47:$P47)=F47,SUMIF($I$11:$P$11,\"*budget*\",$I47:$P47),\"Error in Period Budget\")","v":0},0,{"$f":"F47-R47","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(F46:F56)","v":0},0,null,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":"E60*D60","v":0},{"$f":"IF($F$150=0,\"\",F60/$F$150)","v":""},null,null,null,null,null,null,null,null,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":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I60:$P60)","v":0},{"$f":"F60-R60","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(F60:F69)","v":0},0,null,0,0,0,0,0,0,0,0,{"$f":"SUM(Q60:Q69)","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":"E73*D73","v":0},{"$f":"IF($F$150=0,\"\",F73/$F$150)","v":""},null,null,null,null,null,null,null,null,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":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I73:$P73)","v":0},{"$f":"F73-R73","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(F73:F82)","v":0},0,null,0,0,0,0,0,0,0,0,{"$f":"SUM(Q73:Q82)","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":"E86*D86","v":0},{"$f":"IF($F$150=0,\"\",F86/$F$150)","v":""},null,null,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":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I86:$P86)","v":0},{"$f":"F86-R86","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(F86:F95)","v":0},0,null,0,0,0,0,0,0,0,0,{"$f":"SUM(Q86:Q95)","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":"E99*D99","v":0},{"$f":"IF($F$150=0,\"\",F99/$F$150)","v":""},null,null,null,null,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":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I99:$P99)","v":0},{"$f":"F99-R99","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(F99:F108)","v":0},0,null,0,0,0,0,0,0,0,0,{"$f":"SUM(Q99:Q108)","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":"E112*D112","v":0},{"$f":"IF($F$150=0,\"\",F112/$F$150)","v":""},null,null,null,null,null,null,null,null,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":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I112:$P112)","v":0},{"$f":"F112-R112","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(F112:F121)","v":0},0,null,0,0,0,0,0,0,0,0,{"$f":"SUM(Q112:Q121)","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":"E125*D125","v":0},{"$f":"IF($F$150=0,\"\",F125/$F$150)","v":""},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,"",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(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,null,null,null,null,{"$f":"E138*D138","v":0},{"$f":"IF($F$150=0,\"\",F138/$F$150)","v":""},null,null,null,null,null,null,null,null,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":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I138:$P138)","v":0},{"$f":"F138-R138","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*\",$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,"",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(F138:F147)","v":0},0,null,0,0,0,0,0,0,0,0,{"$f":"SUM(Q138:Q147)","v":0},0,0]
[]
[null,"TOTAL PROJECT EXPENDITURE - ( C )",null,null,null,{"$f":"F57+F70+F83+F96+F109+F135+F122+F148","v":0},{"$f":"G57+G70+G83+G96+G109+G135+G122+G148","v":0},null,{"$f":"I148+I135+I122+I109+I96+I83+I57+I70","v":0},0,0,0,0,0,0,0,{"$f":"Q148+Q135+Q122+Q109+Q96+Q83+Q57+Q70","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":"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":0},null,null,{"$f":"I39","v":0},0,0,0,0,0,0,0,{"$f":"SUMIF($I$11:$P$11,\"*budget*\",$I155:$P155)","v":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I155:$P155)","v":0},{"$f":"F155-R155","v":0}]
[null,null,"Total Project Expenditure",null,null,{"$f":"F150","v":0},null,null,{"$f":"I150","v":0},0,0,0,0,0,0,0,{"$f":"SUMIF($I$11:$P$11,\"*budget*\",$I156:$P156)","v":0},{"$f":"SUMIF($I$11:$P$11,\"*actual*\",$I156:$P156)","v":0},{"$f":"F156-R156","v":0}]
[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,{"$f":"Q155-Q156","v":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":"2. Risk Analysis","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"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":4,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":false,"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 vs Actual'!E2","v":"Please add"},null,null,"Colour code progress:"]
[null,"Project title:",{"$f":"'1. Budget vs Actual'!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":5,"n_rows":87,"n_cols":5,"rows_kept":87,"cut":false,"hidden":false,"merged":[[18,1,18,2],[0,1,0,5],[4,2,4,4],[5,2,5,4],[6,2,6,4],[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[15,1,15,2],[15,3,15,4],[2,2,2,4],[31,1,31,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[28,1,28,2],[30,1,30,2],[29,1,29,2],[41,1,41,2],[41,3,41,4],[34,1,34,2],[39,1,39,2],[39,3,40,4],[40,1,40,2]]}
[]
[]
[null,"Claim Form","ScreenSkills USE ONLY"]
[]
[null,"Organisation Name:",{"$f":"'1. Budget vs Actual'!E2","v":"Please add"}]
[null,"Project Title:",{"$f":"'1. Budget vs Actual'!E3","v":"Please add"}]
[null,"Project Ref No:",{"$f":"'1. Budget vs Actual'!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,"£","%"]
[null,"Projected total expenditure",null,{"$f":"'1. Budget vs Actual'!F150","v":0},1]
[null,"Agreed Grant",null,{"$f":"'1. Budget vs Actual'!F36","v":0},{"$f":"D20/D19","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"ACTUALS",null,"£","%"]
[null,"Total Actual Spend To Date",null,{"$f":"'1. Budget vs Actual'!R150","v":0},{"$f":"D24/D19","v":{"$error":"#DIV/0!"}}]
[null,"Total Actual Income Partnership Funding CASH ",null,{"$f":"'1. Budget vs Actual'!R19","v":0},{"$f":"D25/D19","v":{"$error":"#DIV/0!"}}]
[null,"Total Actual Income Partnership Funding IN-KIND",null,{"$f":"'1. Budget vs Actual'!R29","v":0},{"$f":"D26/D19","v":{"$error":"#DIV/0!"}}]
[null,"ScreenSkills funds claimed to date ",null,{"$f":"'1. Budget vs Actual'!R36","v":0},{"$f":"D27/D19","v":{"$error":"#DIV/0!"}}]
[]
[null,"(Surplus)/Deficit At End Of Previous Period",null,{"$f":"D24-D25-D26-D27","v":0},{"$f":"D29/D19","v":{"$error":"#DIV/0!"}}]
[]
[null,"Final 10% Retention",null,{"$f":"D20*0.1","v":0},{"$f":"IF(D31=0,\"\",D31/D19)","v":""}]
[null,"Remaining Grant to Claim during project less 10% retention",null,{"$f":"D20-D27-D31","v":0},{"$f":"IF(D32=0,\"\",D32/D19)","v":""}]
[]
[]
[null,"Total Amount Due:",null,{"$f":"D29","v":0}]
[]
[]
[]
[]
[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"]