{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["1. Info","2. STAFF RATES","3. Staff Salaries","4. CASHFLOW","5. Q1","6. Q2","7. Q3","8. Q4","9. FINANCIAL YEAR END"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"1. Info","index":0,"n_rows":52,"n_cols":1,"rows_kept":52,"cut":false,"hidden":false,"merged":[[28,3,28,9]]}
[" Guidance on Cash Flow for Pre-schools; Full daycare; Out of school Provision"]
[]
["Managing your finances (money) is crucial to the success of your childcare business.\nIt is vital to know your actual financial situation to manage any financial risk so that you protect your business and do not spend money that you don’t have. "]
[]
["Cash Flow"]
["A cash flow spreadsheet allows you to enter all your income (money that you receive) and expenditure (money that you pay out) for a 12 month period (or financial year). The result of this (income minus expenditure) will indicate whether your business will either break even (you made enough just to cover your expenditure), make a profit/surplus (your income is more than your expenditure) or a loss/deficit (your income is less than your expenditure)."]
[]
["Cash Flow Forecast"]
["A cash flow forecast uses exactly the same format but it is used to predict your income and expenditure for a 12 month period (or financial year). For example, for every month in your spreadsheet, you estimate how much income you are likely to receive and estimate how much money is expected to go out. Your cash flow forecast should represent your setting’s expected finances for the year(s). "]
[]
["You need a cash flow/cash flow forecast to help you to:"]
["•   track your growth\n•   plan ahead for the coming year(s) – are any projects being planned now or in the future? Will you have enough finance to make them happen? Are there are upcoming changes to the needs of families that could affect your business?\n•   be aware of where your business stands financially\n•   access additional funding\n•  allow you to anticipate short falls - the clear, completed document will help you identify peaks and drops (i.e. if parental fees drop, this may indicate a reduction in child attendance and vice versa) With this information you can then take the steps needed to rectify the situation before it becomes a serious problem. This may mean allocating additional resources to marketing your service etc and budgeting for this. \n\n\n"]
["Useful things to remember:"]
["1.      The production of a cash flow should be carried out monthly, year on year."]
["2.     We advise that you complete this cashflow for the full financial year that you are in.  This may mean completing some months that have already gone with 'actual' figures and then completing the remaining months with 'predicted' figures"]
["3.      Complete the cash flow to the best of your knowledge. Make sure that you input your figures to show where you estimate money coming in (income) and going out (expenditure) against the months that they are expected - whilst this not 100% accurate, it should provide an insight into your overall financial position."]
["4.      To keep the cash-flow up to date, we recommend you complete the 'actuals' each month, so you can identify if there are any areas of expenditure that are higher or lower than expected.   "]
["5.      Do not underestimate your likely costs, even if you are concerned it makes your running costs look high."]
["6.      Remember to add 7% – 9% inflation to your estimated costs if you’re projecting for future years (salaries, rent, food etc)."]
["7.      If you are applying for s106 Captial funding from Essex County Council, you need to produce a forecast for three years.  If the cashflow is showing that the business will not break even by the end of year 3, then you should reconsider your business model, and whether you have a viable business."]
["8.  If you are a school applying for funding or to lower your age of admission you will need to complete 3 years cash flow forecasts:"]
["8.1 You are receiving income and have expenditure directly relating to the provision (out-of-school club / pre-school /maintained nursery) that you are running."]
["8.2 If you are an Essex County Council maintained nursery: you receive Funded Early Education Entitlement funding for the children that are attending and you will need to show this. You main item of expenditure will be your staffing costs. Other items of expenditure could be resources. In your Section 251, the rent & rates figure and your lump sum figure are abated proportionately for your nursery, as this proportion is intended to be covered by part of the Free Entitlement funding. The proportion of the abatement is based on the number of children in your nursery as Full Time Equivalents (FTE) as a proportion of the whole school pupil numbers as FTEs, as at the January census. It is up to you as a school to decide whether you allocate proportions of any other costs to your nursery."]
["8.3 You may be receiving government funding for some other places / elements in your provision, and this needs to be shown."]
["8.4 If you are looking to include fundraising as part of your project income, please only input actuals funds received."]
[]
[]
["Using the cash flow template"]
["The cash flow template contains nine tabs."]
["What we require is the information from tab 4: ‘CASHFLOW’"]
["The tabs that you need to complete are 2, 3 and 4.  The later tabs can be used to compare your estimated figures with your actual figures."]
["Once tab 2: ‘STAFF RATES’ has been completed, it will pull through the figures into tab 2: ‘STAFF SALARIES’. "]
["It will automatically calculate the staff costs for the year and give you a break down of this per month."]
["Once checked, and you feel that this is correct to the best of your knowledge, you can move on to tab 4: ‘CASHFLOW’"]
["The information above will automatically be pulled into the ‘wages and salaries’ section and will also estimate holiday cover and staff training costs."]
[]
["This method works if you pay your staff the same amount each month.  If the amount your staff are paid varies each month based on the number of hours worked, you will need to overwrite the formula on the tab 4 ‘CASHFLOW’ with your actual numbers for each month. "]
[]
["NB:  Where figures are automatically entered that are not appropriate to your business = Overwrite the formula "]
["Select the appropriate cell(s), the cell you would like to alter should now have a black border around it. Now enter the figure that is realistic to your business. "]
[]
["Complete the rest of the ‘CASHFLOW’ as normal. Refer to tips"]
[]
["To complete your cash flow, you must enter your opening balance. If this is not entered your cash flow will be deemed as incomplete"]
[]
["Remember this is your document to work out the financial position of your business, so adapt it to represent the income and expenditure of the business."]
[]
["If you would like advice or need guidance with completing your cash flow forecast or additionally need advice, guidance and support for any other business need, please call the"]
["Early Years and Childcare Business Management Consultancy Team:"]
["Rosemary Newall - West Quadrant - email: Rosemary.newell@essex.gov.uk"]
["Gemma Eva - South Quadrant - email: Gemma.eva@essex.gov.uk"]
["Alan Haylock - North & Mid Quadrant - email: alan.haylock@essex.gov.uk "]

{"sheet":"2. STAFF RATES","index":1,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":false,"merged":[[6,2,6,5],[2,2,2,10],[2,11,2,14],[2,15,2,17],[4,2,4,10],[4,15,4,17],[5,7,5,8]]}
[]
[]
[null,null,"Setting Name: ",null,null,null,null,null,null,null,null,"Date Form Completed"]
[]
[null,null,"Staff Salary Rates",null,null,null,null,null,null,null,null,null,null,null,null,"Please type in the rate of pay increase"]
[null,null,null,null,null,null,null,{"$f":"IF(I7=0, \"Please insert NI Rate\", \"\")","v":"Please insert NI Rate"},null,null,{"$f":"IF(L7=0, \"Please insert Pension Rate\", \"\")","v":"Please insert Pension Rate"}]
[null,null,"Please complete all the white boxes below for each position that you have ",null,null,null,null,"NI Rate",null,null,"Pension Rate",null,null,8,null,"Increase rate",null,0]
[]
[null,null,1,2,3,4,null,5,null,6,null,null,null,7]
[]
[null,null,"Staff Roles                    The headings below can be amended","Hourly Rate","No hours Per Week","No weeks Per Year","Annual  salary","Standard NI Rate YES /NO","National Insurance","Pension YES / NO","Pension","Staff Costs per Person",null,"No of staff",null,"Plus Annual Increase",null,"Total Staff Costs"]
[]
[null,null,"Manager",null,null,null,{"$f":"D13*E13*F13","v":0},null,{"$f":"IF(H13=\"yes\",G13*$I$7,0)","v":0},null,{"$f":"IF(J13=\"yes\",G13*$L$7,0)","v":0},{"$f":"G13+I13+K13","v":0},null,null,null,{"$f":"L13*$R$7","v":0},null,{"$f":"(L13+P13)*N13","v":0}]
[]
[null,null,"Babies Supervisor",null,null,null,{"$f":"D15*E15*F15","v":0},null,{"$f":"IF(H15=\"yes\",G15*$I$7,0)","v":0},null,{"$f":"IF(J15=\"yes\",G15*$L$7,0)","v":0},{"$f":"G15+I15+K15","v":0},null,null,null,{"$f":"L15*$R$7","v":0},null,{"$f":"(L15+P15)*N15","v":0}]
[]
[null,null,"Babies Nursery Worker",null,null,null,{"$f":"D17*E17*F17","v":0},null,{"$f":"IF(H17=\"yes\",G17*$I$7,0)","v":0},null,{"$f":"IF(J17=\"yes\",G17*$L$7,0)","v":0},{"$f":"G17+I17+K17","v":0},null,null,null,{"$f":"L17*$R$7","v":0},null,{"$f":"(L17+P17)*N17","v":0}]
[]
[null,null,"Key worker",null,null,null,{"$f":"D19*E19*F19","v":0},null,{"$f":"IF(H19=\"yes\",G19*$I$7,0)","v":0},null,{"$f":"IF(J19=\"yes\",G19*$L$7,0)","v":0},{"$f":"G19+I19+K19","v":0},null,null,null,{"$f":"L19*$R$7","v":0},null,{"$f":"(L19+P19)*N19","v":0}]
[]
[null,null,"2s-3s Supervisor",null,null,null,{"$f":"D21*E21*F21","v":0},null,{"$f":"IF(H21=\"yes\",G21*$I$7,0)","v":0},null,{"$f":"IF(J21=\"yes\",G21*$L$7,0)","v":0},{"$f":"G21+I21+K21","v":0},null,null,null,{"$f":"L21*$R$7","v":0},null,{"$f":"(L21+P21)*N21","v":0}]
[]
[null,null,"2s-3s Deputy",null,null,null,{"$f":"D23*E23*F23","v":0},null,{"$f":"IF(H23=\"yes\",G23*$I$7,0)","v":0},null,{"$f":"IF(J23=\"yes\",G23*$L$7,0)","v":0},{"$f":"G23+I23+K23","v":0},null,null,null,{"$f":"L23*$R$7","v":0},null,{"$f":"(L23+P23)*N23","v":0}]
[]
[null,null,"2s-3s Nursery Worker",null,null,null,{"$f":"D25*E25*F25","v":0},null,{"$f":"IF(H25=\"yes\",G25*$I$7,0)","v":0},null,{"$f":"IF(J25=\"yes\",G25*$L$7,0)","v":0},{"$f":"G25+I25+K25","v":0},null,null,null,{"$f":"L25*$R$7","v":0},null,{"$f":"(L25+P25)*N25","v":0}]
[]
[null,null,"Key worker",null,null,null,{"$f":"D27*E27*F27","v":0},null,{"$f":"IF(H27=\"yes\",G27*$I$7,0)","v":0},null,{"$f":"IF(J27=\"yes\",G27*$L$7,0)","v":0},{"$f":"G27+I27+K27","v":0},null,null,null,{"$f":"L27*$R$7","v":0},null,{"$f":"(L27+P27)*N27","v":0}]
[]
[null,null,"3s-4s Supervisor",null,null,null,{"$f":"D29*E29*F29","v":0},null,{"$f":"IF(H29=\"yes\",G29*$I$7,0)","v":0},null,{"$f":"IF(J29=\"yes\",G29*$L$7,0)","v":0},{"$f":"G29+I29+K29","v":0},null,null,null,{"$f":"L29*$R$7","v":0},null,{"$f":"(L29+P29)*N29","v":0}]
[]
[null,null,"3s-4s Deputy",null,null,null,{"$f":"D31*E31*F31","v":0},null,{"$f":"IF(H31=\"yes\",G31*$I$7,0)","v":0},null,{"$f":"IF(J31=\"yes\",G31*$L$7,0)","v":0},{"$f":"G31+I31+K31","v":0},null,null,null,{"$f":"L31*$R$7","v":0},null,{"$f":"(L31+P31)*N31","v":0}]
[]
[null,null,"3s-4s Nursery Worker",null,null,null,{"$f":"D33*E33*F33","v":0},null,{"$f":"IF(H33=\"yes\",G33*$I$7,0)","v":0},null,{"$f":"IF(J33=\"yes\",G33*$L$7,0)","v":0},{"$f":"G33+I33+K33","v":0},null,null,null,{"$f":"L33*$R$7","v":0},null,{"$f":"(L33+P33)*N33","v":0}]
[]
[null,null,"Cook",null,null,null,{"$f":"D35*E35*F35","v":0},null,{"$f":"IF(H35=\"yes\",G35*$I$7,0)","v":0},null,{"$f":"IF(J35=\"yes\",G35*$L$7,0)","v":0},{"$f":"G35+I35+K35","v":0},null,null,null,{"$f":"L35*$R$7","v":0},null,{"$f":"(L35+P35)*N35","v":0}]
[]
[null,null,"Cleaner",null,null,null,{"$f":"D37*E37*F37","v":0},null,{"$f":"IF(H37=\"yes\",G37*$I$7,0)","v":0},null,{"$f":"IF(J37=\"yes\",G37*$L$7,0)","v":0},{"$f":"G37+I37+K37","v":0},null,null,null,{"$f":"L37*$R$7","v":0},null,{"$f":"(L37+P37)*N37","v":0}]
[]
[null,null,"Driver",null,null,null,{"$f":"D39*E39*F39","v":0},null,{"$f":"IF(H39=\"yes\",G39*$I$7,0)","v":0},null,{"$f":"IF(J39=\"yes\",G39*$L$7,0)","v":0},{"$f":"G39+I39+K39","v":0},null,null,null,{"$f":"L39*$R$7","v":0},null,{"$f":"(L39+P39)*N39","v":0}]
[]
[null,null,null,null,null,null,{"$f":"SUM(G13:G39)","v":0},null,null,null,null,{"$f":"SUM(L13:L39)","v":0},null,{"$f":"SUM(N13:N38)","v":0},null,{"$f":"SUM(P13:P39)","v":0},null,{"$f":"SUM(R13:R39)","v":0}]

{"sheet":"3. Staff Salaries","index":2,"n_rows":41,"n_cols":17,"rows_kept":41,"cut":false,"hidden":false,"merged":[[6,2,6,8],[6,9,6,13],[40,13,40,14],[2,2,2,9],[2,12,2,13],[2,14,2,16],[4,2,4,9]]}
[]
[]
[null,null,{"$f":"'2. STAFF RATES'!C3","v":"Setting Name: "},null,null,null,null,null,null,null,null,null,"Date Form Completed",null,{"$f":"'2. STAFF RATES'!P3","v":"00:00:00"}]
[]
[null,null,"Staff Salaries"]
[]
[null,null,"ALL OF THESE FIGURES ARE CARRIED IN FROM THE STAFF RATES PAGE",null,null,null,null,null,null," Figures are inclusive of % increase. If you require figures without increase insert a 0 (zero) in the rate increase box on previous page "]
[]
[null,null,null,"April","May","June","July","August","September","October","November","December","January","February","March",null,"Total Staff Costs"]
[]
[null,null,{"$f":"'2. STAFF RATES'!C13","v":"Manager"},{"$f":"'2. STAFF RATES'!$R$13/12","v":0},{"$f":"'2. STAFF RATES'!$R$13/12","v":0},{"$f":"'2. STAFF RATES'!$R$13/12","v":0},{"$f":"'2. STAFF RATES'!$R$13/12","v":0},{"$f":"'2. STAFF RATES'!$R$13/12","v":0},{"$f":"'2. STAFF RATES'!$R$13/12","v":0},{"$f":"'2. STAFF RATES'!$R$13/12","v":0},{"$f":"'2. STAFF RATES'!$R$13/12","v":0},{"$f":"'2. STAFF RATES'!$R$13/12","v":0},{"$f":"'2. STAFF RATES'!$R$13/12","v":0},{"$f":"'2. STAFF RATES'!$R$13/12","v":0},{"$f":"'2. STAFF RATES'!$R$13/12","v":0},null,{"$f":"SUM(D11:P11)","v":0}]
[]
[null,null,{"$f":"'2. STAFF RATES'!C15","v":"Babies Supervisor"},{"$f":"'2. STAFF RATES'!$R$15/12","v":0},{"$f":"'2. STAFF RATES'!$R$15/12","v":0},{"$f":"'2. STAFF RATES'!$R$15/12","v":0},{"$f":"'2. STAFF RATES'!$R$15/12","v":0},{"$f":"'2. STAFF RATES'!$R$15/12","v":0},{"$f":"'2. STAFF RATES'!$R$15/12","v":0},{"$f":"'2. STAFF RATES'!$R$15/12","v":0},{"$f":"'2. STAFF RATES'!$R$15/12","v":0},{"$f":"'2. STAFF RATES'!$R$15/12","v":0},{"$f":"'2. STAFF RATES'!$R$15/12","v":0},{"$f":"'2. STAFF RATES'!$R$15/12","v":0},{"$f":"'2. STAFF RATES'!$R$15/12","v":0},null,{"$f":"SUM(D13:P13)","v":0}]
[]
[null,null,{"$f":"'2. STAFF RATES'!C17","v":"Babies Nursery Worker"},{"$f":"'2. STAFF RATES'!$R$17/12","v":0},{"$f":"'2. STAFF RATES'!$R$17/12","v":0},{"$f":"'2. STAFF RATES'!$R$17/12","v":0},{"$f":"'2. STAFF RATES'!$R$17/12","v":0},{"$f":"'2. STAFF RATES'!$R$17/12","v":0},{"$f":"'2. STAFF RATES'!$R$17/12","v":0},{"$f":"'2. STAFF RATES'!$R$17/12","v":0},{"$f":"'2. STAFF RATES'!$R$17/12","v":0},{"$f":"'2. STAFF RATES'!$R$17/12","v":0},{"$f":"'2. STAFF RATES'!$R$17/12","v":0},{"$f":"'2. STAFF RATES'!$R$17/12","v":0},{"$f":"'2. STAFF RATES'!$R$17/12","v":0},null,{"$f":"SUM(D15:P15)","v":0}]
[]
[null,null,{"$f":"'2. STAFF RATES'!C19","v":"Key worker"},{"$f":"'2. STAFF RATES'!$R$19/12","v":0},{"$f":"'2. STAFF RATES'!$R$19/12","v":0},{"$f":"'2. STAFF RATES'!$R$19/12","v":0},{"$f":"'2. STAFF RATES'!$R$19/12","v":0},{"$f":"'2. STAFF RATES'!$R$19/12","v":0},{"$f":"'2. STAFF RATES'!$R$19/12","v":0},{"$f":"'2. STAFF RATES'!$R$19/12","v":0},{"$f":"'2. STAFF RATES'!$R$19/12","v":0},{"$f":"'2. STAFF RATES'!$R$19/12","v":0},{"$f":"'2. STAFF RATES'!$R$19/12","v":0},{"$f":"'2. STAFF RATES'!$R$19/12","v":0},{"$f":"'2. STAFF RATES'!$R$19/12","v":0},null,{"$f":"SUM(D17:P17)","v":0}]
[]
[null,null,{"$f":"'2. STAFF RATES'!C21","v":"2s-3s Supervisor"},{"$f":"'2. STAFF RATES'!$R$21/12","v":0},{"$f":"'2. STAFF RATES'!$R$21/12","v":0},{"$f":"'2. STAFF RATES'!$R$21/12","v":0},{"$f":"'2. STAFF RATES'!$R$21/12","v":0},{"$f":"'2. STAFF RATES'!$R$21/12","v":0},{"$f":"'2. STAFF RATES'!$R$21/12","v":0},{"$f":"'2. STAFF RATES'!$R$21/12","v":0},{"$f":"'2. STAFF RATES'!$R$21/12","v":0},{"$f":"'2. STAFF RATES'!$R$21/12","v":0},{"$f":"'2. STAFF RATES'!$R$21/12","v":0},{"$f":"'2. STAFF RATES'!$R$21/12","v":0},{"$f":"'2. STAFF RATES'!$R$21/12","v":0},null,{"$f":"SUM(D19:P19)","v":0}]
[]
[null,null,{"$f":"'2. STAFF RATES'!C23","v":"2s-3s Deputy"},{"$f":"'2. STAFF RATES'!$R$23/12","v":0},{"$f":"'2. STAFF RATES'!$R$23/12","v":0},{"$f":"'2. STAFF RATES'!$R$23/12","v":0},{"$f":"'2. STAFF RATES'!$R$23/12","v":0},{"$f":"'2. STAFF RATES'!$R$23/12","v":0},{"$f":"'2. STAFF RATES'!$R$23/12","v":0},{"$f":"'2. STAFF RATES'!$R$23/12","v":0},{"$f":"'2. STAFF RATES'!$R$23/12","v":0},{"$f":"'2. STAFF RATES'!$R$23/12","v":0},{"$f":"'2. STAFF RATES'!$R$23/12","v":0},{"$f":"'2. STAFF RATES'!$R$23/12","v":0},{"$f":"'2. STAFF RATES'!$R$23/12","v":0},null,{"$f":"SUM(D21:P21)","v":0}]
[]
[null,null,{"$f":"'2. STAFF RATES'!C25","v":"2s-3s Nursery Worker"},{"$f":"'2. STAFF RATES'!$R$25/12","v":0},{"$f":"'2. STAFF RATES'!$R$25/12","v":0},{"$f":"'2. STAFF RATES'!$R$25/12","v":0},{"$f":"'2. STAFF RATES'!$R$25/12","v":0},{"$f":"'2. STAFF RATES'!$R$25/12","v":0},{"$f":"'2. STAFF RATES'!$R$25/12","v":0},{"$f":"'2. STAFF RATES'!$R$25/12","v":0},{"$f":"'2. STAFF RATES'!$R$25/12","v":0},{"$f":"'2. STAFF RATES'!$R$25/12","v":0},{"$f":"'2. STAFF RATES'!$R$25/12","v":0},{"$f":"'2. STAFF RATES'!$R$25/12","v":0},{"$f":"'2. STAFF RATES'!$R$25/12","v":0},null,{"$f":"SUM(D23:P23)","v":0}]
[]
[null,null,{"$f":"'2. STAFF RATES'!C27","v":"Key worker"},{"$f":"'2. STAFF RATES'!$R$27/12","v":0},{"$f":"'2. STAFF RATES'!$R$27/12","v":0},{"$f":"'2. STAFF RATES'!$R$27/12","v":0},{"$f":"'2. STAFF RATES'!$R$27/12","v":0},{"$f":"'2. STAFF RATES'!$R$27/12","v":0},{"$f":"'2. STAFF RATES'!$R$27/12","v":0},{"$f":"'2. STAFF RATES'!$R$27/12","v":0},{"$f":"'2. STAFF RATES'!$R$27/12","v":0},{"$f":"'2. STAFF RATES'!$R$27/12","v":0},{"$f":"'2. STAFF RATES'!$R$27/12","v":0},{"$f":"'2. STAFF RATES'!$R$27/12","v":0},{"$f":"'2. STAFF RATES'!$R$27/12","v":0},null,{"$f":"SUM(D25:P25)","v":0}]
[]
[null,null,{"$f":"'2. STAFF RATES'!C29","v":"3s-4s Supervisor"},{"$f":"'2. STAFF RATES'!$R$29/12","v":0},{"$f":"'2. STAFF RATES'!$R$29/12","v":0},{"$f":"'2. STAFF RATES'!$R$29/12","v":0},{"$f":"'2. STAFF RATES'!$R$29/12","v":0},{"$f":"'2. STAFF RATES'!$R$29/12","v":0},{"$f":"'2. STAFF RATES'!$R$29/12","v":0},{"$f":"'2. STAFF RATES'!$R$29/12","v":0},{"$f":"'2. STAFF RATES'!$R$29/12","v":0},{"$f":"'2. STAFF RATES'!$R$29/12","v":0},{"$f":"'2. STAFF RATES'!$R$29/12","v":0},{"$f":"'2. STAFF RATES'!$R$29/12","v":0},{"$f":"'2. STAFF RATES'!$R$29/12","v":0},null,{"$f":"SUM(D27:P27)","v":0}]
[]
[null,null,{"$f":"'2. STAFF RATES'!C31","v":"3s-4s Deputy"},{"$f":"'2. STAFF RATES'!$R$31/12","v":0},{"$f":"'2. STAFF RATES'!$R$31/12","v":0},{"$f":"'2. STAFF RATES'!$R$31/12","v":0},{"$f":"'2. STAFF RATES'!$R$31/12","v":0},{"$f":"'2. STAFF RATES'!$R$31/12","v":0},{"$f":"'2. STAFF RATES'!$R$31/12","v":0},{"$f":"'2. STAFF RATES'!$R$31/12","v":0},{"$f":"'2. STAFF RATES'!$R$31/12","v":0},{"$f":"'2. STAFF RATES'!$R$31/12","v":0},{"$f":"'2. STAFF RATES'!$R$31/12","v":0},{"$f":"'2. STAFF RATES'!$R$31/12","v":0},{"$f":"'2. STAFF RATES'!$R$31/12","v":0},null,{"$f":"SUM(D29:P29)","v":0}]
[]
[null,null,{"$f":"'2. STAFF RATES'!C33","v":"3s-4s Nursery Worker"},{"$f":"'2. STAFF RATES'!$R$33/12","v":0},{"$f":"'2. STAFF RATES'!$R$33/12","v":0},{"$f":"'2. STAFF RATES'!$R$33/12","v":0},{"$f":"'2. STAFF RATES'!$R$33/12","v":0},{"$f":"'2. STAFF RATES'!$R$33/12","v":0},{"$f":"'2. STAFF RATES'!$R$33/12","v":0},{"$f":"'2. STAFF RATES'!$R$33/12","v":0},{"$f":"'2. STAFF RATES'!$R$33/12","v":0},{"$f":"'2. STAFF RATES'!$R$33/12","v":0},{"$f":"'2. STAFF RATES'!$R$33/12","v":0},{"$f":"'2. STAFF RATES'!$R$33/12","v":0},{"$f":"'2. STAFF RATES'!$R$33/12","v":0},null,{"$f":"SUM(D31:P31)","v":0}]
[]
[null,null,{"$f":"'2. STAFF RATES'!C35","v":"Cook"},{"$f":"'2. STAFF RATES'!$R$35/12","v":0},{"$f":"'2. STAFF RATES'!$R$35/12","v":0},{"$f":"'2. STAFF RATES'!$R$35/12","v":0},{"$f":"'2. STAFF RATES'!$R$35/12","v":0},{"$f":"'2. STAFF RATES'!$R$35/12","v":0},{"$f":"'2. STAFF RATES'!$R$35/12","v":0},{"$f":"'2. STAFF RATES'!$R$35/12","v":0},{"$f":"'2. STAFF RATES'!$R$35/12","v":0},{"$f":"'2. STAFF RATES'!$R$35/12","v":0},{"$f":"'2. STAFF RATES'!$R$35/12","v":0},{"$f":"'2. STAFF RATES'!$R$35/12","v":0},{"$f":"'2. STAFF RATES'!$R$35/12","v":0},null,{"$f":"SUM(D33:P33)","v":0}]
[]
[null,null,{"$f":"'2. STAFF RATES'!C37","v":"Cleaner"},{"$f":"'2. STAFF RATES'!$R$37/12","v":0},{"$f":"'2. STAFF RATES'!$R$37/12","v":0},{"$f":"'2. STAFF RATES'!$R$37/12","v":0},{"$f":"'2. STAFF RATES'!$R$37/12","v":0},{"$f":"'2. STAFF RATES'!$R$37/12","v":0},{"$f":"'2. STAFF RATES'!$R$37/12","v":0},{"$f":"'2. STAFF RATES'!$R$37/12","v":0},{"$f":"'2. STAFF RATES'!$R$37/12","v":0},{"$f":"'2. STAFF RATES'!$R$37/12","v":0},{"$f":"'2. STAFF RATES'!$R$37/12","v":0},{"$f":"'2. STAFF RATES'!$R$37/12","v":0},{"$f":"'2. STAFF RATES'!$R$37/12","v":0},null,{"$f":"SUM(D35:P35)","v":0}]
[]
[null,null,{"$f":"'2. STAFF RATES'!C39","v":"Driver"},{"$f":"'2. STAFF RATES'!$R$39/12","v":0},{"$f":"'2. STAFF RATES'!$R$39/12","v":0},{"$f":"'2. STAFF RATES'!$R$39/12","v":0},{"$f":"'2. STAFF RATES'!$R$39/12","v":0},{"$f":"'2. STAFF RATES'!$R$39/12","v":0},{"$f":"'2. STAFF RATES'!$R$39/12","v":0},{"$f":"'2. STAFF RATES'!$R$39/12","v":0},{"$f":"'2. STAFF RATES'!$R$39/12","v":0},{"$f":"'2. STAFF RATES'!$R$39/12","v":0},{"$f":"'2. STAFF RATES'!$R$39/12","v":0},{"$f":"'2. STAFF RATES'!$R$39/12","v":0},{"$f":"'2. STAFF RATES'!$R$39/12","v":0},null,{"$f":"SUM(D37:P37)","v":0}]
[]
[null,null,"TOTAL PER MONTH",{"$f":"SUM(D11:D37)","v":0},{"$f":"SUM(E11:E37)","v":0},0,0,0,0,0,0,0,0,0,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total staff cost                        (Fully Staffed Year 1)",null,null,{"$f":"SUM(Q11:Q39)","v":0}]

{"sheet":"4. CASHFLOW","index":3,"n_rows":120,"n_cols":19,"rows_kept":120,"cut":false,"hidden":false,"merged":[[99,16,99,17],[99,1,99,5],[99,9,99,15],[99,7,99,8],[2,7,2,8],[12,7,12,15],[8,1,9,1],[2,13,4,18],[6,3,6,17],[4,3,4,10],[2,3,2,5],[4,1,6,1]]}
[]
[]
[null,null,null,"Date completed",null,null,null,{"$f":"'3. Staff Salaries'!O3","v":"00:00:00"},null,null,null,null,null,"Cashflow Forecast"]
[]
[null,{"$f":"IF(B9=0, \"Please select the year using the drop down menu below\", \"\")","v":"Please select the year using the drop down menu below"},null,{"$f":"'3. Staff Salaries'!C3","v":"Setting Name: "}]
[]
[null,null,null,"Only complete the white boxes below which apply to your setting.  Whilst this is only a forecast of income and expenditure, When completing the figures, please try to be as accurate as possible about the amount of income you expect to receive and when it is due, and also the amounts of expenditure and when they are due to go out."]
[]
[null,null,null,"Month 1","Month 2","Month 3",null,"Month 4","Month 5","Month 6",null,"Month 7","Month 8","Month 9",null,"Month 10","Month 11","Month 12","Totals"]
[]
[]
[]
[null,"Income",null,null,"Text can be changed",null,null,"PLEASE ENTER FIGURES IN WHITE BOXES ONLY "]
[]
[null,"Early Education Entitlement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D15:R15)","v":0}]
[null,"Fees From parents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D16:R16)","v":0}]
[null,"Bank Loans",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Local Authority Grants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Early Years Partnership Grants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Own funds (Reserves)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Asset Disposal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Room Lettings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Fund Raising",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Donations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Bank interest",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"TOTAL INCOME ",null,{"$f":"SUM(D15:D26)","v":0},{"$f":"SUM(E15:E26)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,0]
[]
[null,"Expenditure"]
[]
[null,"Wages & Salaries",null,{"$f":"'3. Staff Salaries'!D39","v":0},{"$f":"'3. Staff Salaries'!E39","v":0},{"$f":"'3. Staff Salaries'!F39","v":0},null,{"$f":"'3. Staff Salaries'!G39","v":0},{"$f":"'3. Staff Salaries'!H39","v":0},{"$f":"'3. Staff Salaries'!I39","v":0},null,{"$f":"'3. Staff Salaries'!J39","v":0},{"$f":"'3. Staff Salaries'!K39","v":0},{"$f":"'3. Staff Salaries'!L39","v":0},null,{"$f":"'3. Staff Salaries'!M39","v":0},{"$f":"'3. Staff Salaries'!N39","v":0},{"$f":"'3. Staff Salaries'!O39","v":0},{"$f":"SUM(D32:R32)","v":0}]
[null,"Holiday Cover",null,{"$f":"D32/100*5","v":0},{"$f":"E32/100*5","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,0]
[null,"Overtime",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Staff  Training",null,{"$f":"D32/100*1.5","v":0},{"$f":"E32/100*1.5","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,0]
[null,"Other On-costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Staff Costs",null,{"$f":"SUM(D32:D37)","v":0},{"$f":"SUM(E32:E37)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S32:S37)","v":0}]
[null,"Rent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D39:R39)","v":0}]
[null,"Day to Day Maintenance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Electricity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Gas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Business Rates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Water",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Cleaning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Premises",null,{"$f":"SUM(D39:D47)","v":0},{"$f":"SUM(E39:E47)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S39:S47)","v":0}]
[null,"Building Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:R49)","v":0}]
[null,"Contents Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D50:R50)","v":0}]
[null,"Employment Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D51:R51)","v":0}]
[null,"Total Insurance",null,{"$f":"SUM(D49:D51)","v":0},{"$f":"SUM(E49:E51)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S49:S51)","v":0}]
[]
[null,"Telephone Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D54:R54)","v":0}]
[null,"Postage ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Printing & Stationery",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Membership Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Bank Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Professional Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other Administration Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Subscriptions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Loan Repayments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"HP Payments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Office Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Administration",null,{"$f":"SUM(D54:D66)","v":0},{"$f":"SUM(E54:E66)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S54:S66)","v":0}]
[null,"Consumables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D68:R68)","v":0}]
[null,"Visits & Trips out ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Catering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Misc / Sundries",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Repairs & renewals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Activity & Material Costs",null,{"$f":"SUM(D68:D73)","v":0},{"$f":"SUM(E68:E73)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S68:S73)","v":0}]
[null,"Volunteer Subsistence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D75:R75)","v":0}]
[null,"Volunteer Travel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D76:R76)","v":0}]
[null," Total Volunteer Costs",null,{"$f":"SUM(D75:D76)","v":0},{"$f":"SUM(E75:E76)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S75:S76)","v":0}]
[null,"Advertising / Promotions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D78:R78)","v":0}]
[null,"Market Research",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D79:R79)","v":0}]
[null,"Total Advertising",null,{"$f":"SUM(D78:D79)","v":0},{"$f":"SUM(E78:E79)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S78:S79)","v":0}]
[null,"Vehicle Tax",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D81:R81)","v":0}]
[null,"Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Petrol / Oil",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Vehicle Maintenance / MOT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Mileage Costs Paid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other Travel costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Transport",null,{"$f":"SUM(D81:D87)","v":0},{"$f":"SUM(E81:E87)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S81:S87)","v":0}]
[null,"Quality Assurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D89:R89)","v":0}]
[null,"I",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D90:R90)","v":0}]
[null,"ii",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D91:R91)","v":0}]
[null,"Total Quality Assurance",null,{"$f":"SUM(D90:D91)","v":0},{"$f":"SUM(E90:E91)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(S89:S91)","v":0}]
[null,"TOTAL REVENUE EXPENDITURE",null,{"$f":"D38+D48+D52+D67+D74+D77+D80+D88+D92","v":0},{"$f":"E38+E48+E52+E67+E74+E77+E80+E88+E92","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,0]
[]
[null,"Opening balance",null,null,{"$f":"D98","v":0},{"$f":"E98","v":0},null,{"$f":"F98","v":0},0,0,null,{"$f":"J98","v":0},0,0,null,{"$f":"N98","v":0},0,0,{"$f":"R98","v":0}]
[null,"Total Income",null,{"$f":"D28","v":0},{"$f":"E28","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(D96:R96)","v":0}]
[null,"Total Expenditure",null,{"$f":"D93","v":0},{"$f":"E93","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,{"$f":"SUM(D97:R97)","v":0}]
[null,"Closing balance",null,{"$f":"D95+D96-D97","v":0},0,0,null,0,0,0,null,0,0,0,null,0,0,{"$f":"R95+R96-R97","v":0}]
[]
[null,{"$f":"IF(D95=0,\"PLEASE ENTER OPENING BALANCE\",\"OPENING BALANCE OK\")","v":"PLEASE ENTER OPENING BALANCE"},null,null,null,null,null,{"$f":"IF(Q100=\"LOSS\",\"WARNING\",\"GOOD NEWS\")","v":"GOOD NEWS"},null,"The cashflow forecast is currently indicating that you will make a",null,null,null,null,null,null,{"$f":"IF(S100<0,\"LOSS\",IF(S100>0,\"PROFIT\",IF(S100=0,\"BREAK EVEN\")))","v":"BREAK EVEN"},{"$f":"IF(S97>S96,\"LOSS\",IF(S97<S96,\"PROFIT\",IF(S97=S96,\"BREAK EVEN\")))","v":"BREAK EVEN"},{"$f":"S96-S97","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Year 1"]
[null,"Year 2"]
[null,"Year 3"]
[null,"Year 4"]
[null,"Year 5"]
[null,"Year 6"]
[null,"Year 7"]
[null,"Year 8"]
[null,"Year 9"]
[null,"Year 10"]

{"sheet":"5. Q1","index":4,"n_rows":100,"n_cols":16,"rows_kept":100,"cut":false,"hidden":false,"merged":[[4,0,4,1],[2,11,4,15],[9,6,9,7],[9,9,9,10],[2,7,2,9],[6,3,6,14],[4,3,4,9],[2,4,2,6],[9,1,10,1],[9,3,9,4],[99,9,99,15],[9,14,10,14],[12,9,12,14],[97,9,97,15],[9,12,9,13]]}
[]
[]
[null,{"$f":"IF(H3=0, \"Please insert date completed\", \"\")","v":"Please insert date completed"},null,null,"Date completed",null,null,{"$f":"'4. CASHFLOW'!H3","v":"00:00:00"},null,null,null,"Actual Expenditure"]
[]
[null,null,null,{"$f":"'4. CASHFLOW'!D5","v":"Setting Name: "}]
[]
[null," ",null,"The figures in the blue boxes are your budgets which are brought in from the cashflow forecast. Only complete the white boxes below which apply to your setting, these are your actuals for each month. The column at the end will give you an indication of how you are performing against your budget."]
[]
[]
[null,{"$f":"'4. CASHFLOW'!B9","v":0},null,"APRIL",null,null,"MAY",null,null,"JUNE",null,null,"TOTAL",null,"Variance"]
[null,null,null,"Budget","Actual",null,"Budget","Actual",null,"Budget","Actual",null,"Budget","Actual"]
[null,null,null,null," "]
[null,"Income",null,null,null,null,null,null,null,"Quarterly Return Q1"]
[]
[null,{"$f":"'4. CASHFLOW'!$B15","v":"Early Education Entitlement"},null,{"$f":"'4. CASHFLOW'!$D15","v":0},null,null,{"$f":"'4. CASHFLOW'!$E15","v":0},null,null,{"$f":"'4. CASHFLOW'!$F15","v":0},null,null,{"$f":"D15+G15+J15","v":0},{"$f":"E15+H15+K15","v":0},{"$f":"N15-M15","v":0},{"$f":"IF(O15=0,\"OK\",IF(O15>0,\"Credit\",IF(O15<0,\"Defecit\")))","v":"OK"}]
[null,{"$f":"'4. CASHFLOW'!$B16","v":"Fees From parents"},null,{"$f":"'4. CASHFLOW'!$D16","v":0},null,null,{"$f":"'4. CASHFLOW'!$E16","v":0},null,null,{"$f":"'4. CASHFLOW'!$F16","v":0},null,null,{"$f":"D16+G16+J16","v":0},0,{"$f":"N16-M16","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B17","v":"Bank Loans"},null,{"$f":"'4. CASHFLOW'!$D17","v":0},null,null,{"$f":"'4. CASHFLOW'!$E17","v":0},null,null,{"$f":"'4. CASHFLOW'!$F17","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B18","v":"Local Authority Grants"},null,{"$f":"'4. CASHFLOW'!$D18","v":0},null,null,{"$f":"'4. CASHFLOW'!$E18","v":0},null,null,{"$f":"'4. CASHFLOW'!$F18","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B19","v":"Early Years Partnership Grants"},null,{"$f":"'4. CASHFLOW'!$D19","v":0},null,null,{"$f":"'4. CASHFLOW'!$E19","v":0},null,null,{"$f":"'4. CASHFLOW'!$F19","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B20","v":"Own funds (Reserves)"},null,{"$f":"'4. CASHFLOW'!$D20","v":0},null,null,{"$f":"'4. CASHFLOW'!$E20","v":0},null,null,{"$f":"'4. CASHFLOW'!$F20","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B21","v":"Asset Disposal"},null,{"$f":"'4. CASHFLOW'!$D21","v":0},null,null,{"$f":"'4. CASHFLOW'!$E21","v":0},null,null,{"$f":"'4. CASHFLOW'!$F21","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B22","v":"Room Lettings"},null,{"$f":"'4. CASHFLOW'!$D22","v":0},null,null,{"$f":"'4. CASHFLOW'!$E22","v":0},null,null,{"$f":"'4. CASHFLOW'!$F22","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B23","v":"Fund Raising"},null,{"$f":"'4. CASHFLOW'!$D23","v":0},null,null,{"$f":"'4. CASHFLOW'!$E23","v":0},null,null,{"$f":"'4. CASHFLOW'!$F23","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B24","v":"Donations"},null,{"$f":"'4. CASHFLOW'!$D24","v":0},null,null,{"$f":"'4. CASHFLOW'!$E24","v":0},null,null,{"$f":"'4. CASHFLOW'!$F24","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B25","v":"Bank interest"},null,{"$f":"'4. CASHFLOW'!$D25","v":0},null,null,{"$f":"'4. CASHFLOW'!$E25","v":0},null,null,{"$f":"'4. CASHFLOW'!$F25","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B26","v":0},null,{"$f":"'4. CASHFLOW'!$D26","v":0},null,null,{"$f":"'4. CASHFLOW'!$E26","v":0},null,null,{"$f":"'4. CASHFLOW'!$F26","v":0},null,null,0,0,0,"OK"]
[]
[null,"TOTAL INCOME ",null,{"$f":"SUM(D15:D27)","v":0},{"$f":"SUM(E15:E27)","v":0},null,{"$f":"SUM(G15:G27)","v":0},{"$f":"SUM(H15:H27)","v":0},null,{"$f":"SUM(J15:J27)","v":0},{"$f":"SUM(K15:K27)","v":0},null,{"$f":"SUM(M15:M27)","v":0},{"$f":"SUM(N15:N27)","v":0},{"$f":"SUM(O15:O27)","v":0},{"$f":"IF(O28=0,\"OK\",IF(O28>0,\"Credit\",IF(O28<0,\"Defecit\")))","v":"OK"}]
[]
[null,"Expenditure"]
[]
[null,{"$f":"'4. CASHFLOW'!$B32","v":"Wages & Salaries"},null,{"$f":"'4. CASHFLOW'!$D32","v":0},null,null,{"$f":"'4. CASHFLOW'!$E32","v":0},null,null,{"$f":"'4. CASHFLOW'!$F32","v":0},null,null,{"$f":"D32+G32+J32","v":0},0,{"$f":"M32-N32","v":0},{"$f":"IF(O32=0,\"OK\",IF(O32>0,\"Underspent\",IF(O32<0,\"Overspent\")))","v":"OK"}]
[null,{"$f":"'4. CASHFLOW'!$B33","v":"Holiday Cover"},null,{"$f":"'4. CASHFLOW'!$D33","v":0},null,null,{"$f":"'4. CASHFLOW'!$E33","v":0},null,null,{"$f":"'4. CASHFLOW'!$F33","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B34","v":"Overtime"},null,{"$f":"'4. CASHFLOW'!$D34","v":0},null,null,{"$f":"'4. CASHFLOW'!$E34","v":0},null,null,{"$f":"'4. CASHFLOW'!$F34","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B35","v":"Staff  Training"},null,{"$f":"'4. CASHFLOW'!$D35","v":0},null,null,{"$f":"'4. CASHFLOW'!$E35","v":0},null,null,{"$f":"'4. CASHFLOW'!$F35","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B36","v":"Other On-costs"},null,{"$f":"'4. CASHFLOW'!$D36","v":0},null,null,{"$f":"'4. CASHFLOW'!$E36","v":0},null,null,{"$f":"'4. CASHFLOW'!$F36","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B37","v":"Other "},null,{"$f":"'4. CASHFLOW'!$D37","v":0},null,null,{"$f":"'4. CASHFLOW'!$E37","v":0},null,null,{"$f":"'4. CASHFLOW'!$F37","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B38","v":"Total Staff Costs"},null,{"$f":"SUM(D32:D37)","v":0},{"$f":"SUM(E32:E37)","v":0},null,{"$f":"SUM(G32:G37)","v":0},{"$f":"SUM(H32:H37)","v":0},null,{"$f":"SUM(J32:J37)","v":0},{"$f":"SUM(K32:K37)","v":0},null,{"$f":"SUM(M32:M37)","v":0},{"$f":"SUM(N32:N37)","v":0},{"$f":"SUM(O32:O37)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B39","v":"Rent"},null,{"$f":"'4. CASHFLOW'!$D39","v":0},null,null,{"$f":"'4. CASHFLOW'!$E39","v":0},null,null,{"$f":"'4. CASHFLOW'!$F39","v":0},null,null,{"$f":"D39+G39+J39","v":0},0,{"$f":"M39-N39","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B40","v":"Day to Day Maintenance"},null,{"$f":"'4. CASHFLOW'!$D40","v":0},null,null,{"$f":"'4. CASHFLOW'!$E40","v":0},null,null,{"$f":"'4. CASHFLOW'!$F40","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B41","v":"Electricity"},null,{"$f":"'4. CASHFLOW'!$D41","v":0},null,null,{"$f":"'4. CASHFLOW'!$E41","v":0},null,null,{"$f":"'4. CASHFLOW'!$F41","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B42","v":"Gas"},null,{"$f":"'4. CASHFLOW'!$D42","v":0},null,null,{"$f":"'4. CASHFLOW'!$E42","v":0},null,null,{"$f":"'4. CASHFLOW'!$F42","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B43","v":"Business Rates"},null,{"$f":"'4. CASHFLOW'!$D43","v":0},null,null,{"$f":"'4. CASHFLOW'!$E43","v":0},null,null,{"$f":"'4. CASHFLOW'!$F43","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B44","v":"Water"},null,{"$f":"'4. CASHFLOW'!$D44","v":0},null,null,{"$f":"'4. CASHFLOW'!$E44","v":0},null,null,{"$f":"'4. CASHFLOW'!$F44","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B45","v":"Cleaning"},null,{"$f":"'4. CASHFLOW'!$D45","v":0},null,null,{"$f":"'4. CASHFLOW'!$E45","v":0},null,null,{"$f":"'4. CASHFLOW'!$F45","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B46","v":"Other"},null,{"$f":"'4. CASHFLOW'!$D46","v":0},null,null,{"$f":"'4. CASHFLOW'!$E46","v":0},null,null,{"$f":"'4. CASHFLOW'!$F46","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B47","v":"Other"},null,{"$f":"'4. CASHFLOW'!$D47","v":0},null,null,{"$f":"'4. CASHFLOW'!$E47","v":0},null,null,{"$f":"'4. CASHFLOW'!$F47","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B48","v":"Total Premises"},null,{"$f":"SUM(D39:D47)","v":0},{"$f":"SUM(E39:E47)","v":0},null,{"$f":"SUM(G39:G47)","v":0},{"$f":"SUM(H39:H47)","v":0},null,{"$f":"SUM(J39:J47)","v":0},{"$f":"SUM(K39:K47)","v":0},null,{"$f":"SUM(M39:M47)","v":0},{"$f":"SUM(N39:N47)","v":0},{"$f":"SUM(O39:O47)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B49","v":"Building Insurance"},null,{"$f":"'4. CASHFLOW'!$D49","v":0},null,null,{"$f":"'4. CASHFLOW'!$E49","v":0},null,null,{"$f":"'4. CASHFLOW'!$F49","v":0},null,null,{"$f":"D49+G49+J49","v":0},0,{"$f":"M49-N49","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B50","v":"Contents Insurance"},null,{"$f":"'4. CASHFLOW'!$D50","v":0},null,null,{"$f":"'4. CASHFLOW'!$E50","v":0},null,null,{"$f":"'4. CASHFLOW'!$F50","v":0},null,null,0,0,{"$f":"M50-N50","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B51","v":"Employment Insurance"},null,{"$f":"'4. CASHFLOW'!$D51","v":0},null,null,{"$f":"'4. CASHFLOW'!$E51","v":0},null,null,{"$f":"'4. CASHFLOW'!$F51","v":0},null,null,0,0,{"$f":"M51-N51","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B52","v":"Total Insurance"},null,{"$f":"SUM(D49:D51)","v":0},{"$f":"SUM(E49:E51)","v":0},null,{"$f":"SUM(G49:G51)","v":0},{"$f":"SUM(H49:H51)","v":0},null,{"$f":"SUM(J49:J51)","v":0},{"$f":"SUM(K49:K51)","v":0},null,{"$f":"SUM(M49:M51)","v":0},{"$f":"SUM(N49:N51)","v":0},{"$f":"SUM(O49:O51)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B54","v":"Telephone Charges"},null,{"$f":"'4. CASHFLOW'!$D54","v":0},null,null,{"$f":"'4. CASHFLOW'!$E54","v":0},null,null,{"$f":"'4. CASHFLOW'!$F54","v":0},null,null,{"$f":"D53+G53+J53","v":0},0,{"$f":"M53-N53","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B55","v":"Postage "},null,{"$f":"'4. CASHFLOW'!$D55","v":0},null,null,{"$f":"'4. CASHFLOW'!$E55","v":0},null,null,{"$f":"'4. CASHFLOW'!$F55","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B56","v":"Printing & Stationery"},null,{"$f":"'4. CASHFLOW'!$D56","v":0},null,null,{"$f":"'4. CASHFLOW'!$E56","v":0},null,null,{"$f":"'4. CASHFLOW'!$F56","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B57","v":"Membership Fees"},null,{"$f":"'4. CASHFLOW'!$D57","v":0},null,null,{"$f":"'4. CASHFLOW'!$E57","v":0},null,null,{"$f":"'4. CASHFLOW'!$F57","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B58","v":"Bank Charges"},null,{"$f":"'4. CASHFLOW'!$D58","v":0},null,null,{"$f":"'4. CASHFLOW'!$E58","v":0},null,null,{"$f":"'4. CASHFLOW'!$F58","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B59","v":"Professional Fees"},null,{"$f":"'4. CASHFLOW'!$D59","v":0},null,null,{"$f":"'4. CASHFLOW'!$E59","v":0},null,null,{"$f":"'4. CASHFLOW'!$F59","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B60","v":"Other Administration Costs"},null,{"$f":"'4. CASHFLOW'!$D60","v":0},null,null,{"$f":"'4. CASHFLOW'!$E60","v":0},null,null,{"$f":"'4. CASHFLOW'!$F60","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B61","v":"Subscriptions"},null,{"$f":"'4. CASHFLOW'!$D61","v":0},null,null,{"$f":"'4. CASHFLOW'!$E61","v":0},null,null,{"$f":"'4. CASHFLOW'!$F61","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B62","v":"Loan Repayments"},null,{"$f":"'4. CASHFLOW'!$D62","v":0},null,null,{"$f":"'4. CASHFLOW'!$E62","v":0},null,null,{"$f":"'4. CASHFLOW'!$F62","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B63","v":"HP Payments"},null,{"$f":"'4. CASHFLOW'!$D63","v":0},null,null,{"$f":"'4. CASHFLOW'!$E63","v":0},null,null,{"$f":"'4. CASHFLOW'!$F63","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B64","v":"Office Equipment"},null,{"$f":"'4. CASHFLOW'!$D64","v":0},null,null,{"$f":"'4. CASHFLOW'!$E64","v":0},null,null,{"$f":"'4. CASHFLOW'!$F64","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B65","v":"Other"},null,{"$f":"'4. CASHFLOW'!$D65","v":0},null,null,{"$f":"'4. CASHFLOW'!$E65","v":0},null,null,{"$f":"'4. CASHFLOW'!$F65","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B66","v":"Other"},null,{"$f":"'4. CASHFLOW'!$D66","v":0},null,null,{"$f":"'4. CASHFLOW'!$E66","v":0},null,null,{"$f":"'4. CASHFLOW'!$F66","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B67","v":"Total Administration"},null,{"$f":"SUM(D53:D65)","v":0},{"$f":"SUM(E53:E65)","v":0},null,{"$f":"SUM(G53:G65)","v":0},{"$f":"SUM(H53:H65)","v":0},null,{"$f":"SUM(J53:J65)","v":0},{"$f":"SUM(K53:K65)","v":0},null,{"$f":"SUM(M53:M65)","v":0},{"$f":"SUM(N53:N65)","v":0},{"$f":"SUM(O53:O65)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B68","v":"Consumables"},null,{"$f":"'4. CASHFLOW'!$D68","v":0},null,null,{"$f":"'4. CASHFLOW'!$E68","v":0},null,null,{"$f":"'4. CASHFLOW'!$F68","v":0},null,null,{"$f":"D67+G67+J67","v":0},0,{"$f":"M67-N67","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B69","v":"Visits & Trips out "},null,{"$f":"'4. CASHFLOW'!$D69","v":0},null,null,{"$f":"'4. CASHFLOW'!$E69","v":0},null,null,{"$f":"'4. CASHFLOW'!$F69","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B70","v":"Catering"},null,{"$f":"'4. CASHFLOW'!$D70","v":0},null,null,{"$f":"'4. CASHFLOW'!$E70","v":0},null,null,{"$f":"'4. CASHFLOW'!$F70","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B71","v":"Misc / Sundries"},null,{"$f":"'4. CASHFLOW'!$D71","v":0},null,null,{"$f":"'4. CASHFLOW'!$E71","v":0},null,null,{"$f":"'4. CASHFLOW'!$F71","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B72","v":"Repairs & renewals"},null,{"$f":"'4. CASHFLOW'!$D72","v":0},null,null,{"$f":"'4. CASHFLOW'!$E72","v":0},null,null,{"$f":"'4. CASHFLOW'!$F72","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B73","v":"Other"},null,{"$f":"'4. CASHFLOW'!$D73","v":0},null,null,{"$f":"'4. CASHFLOW'!$E73","v":0},null,null,{"$f":"'4. CASHFLOW'!$F73","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B74","v":"Total Activity & Material Costs"},null,{"$f":"SUM(D67:D72)","v":0},{"$f":"SUM(E67:E72)","v":0},null,{"$f":"SUM(G67:G72)","v":0},{"$f":"SUM(H67:H72)","v":0},null,{"$f":"SUM(J67:J72)","v":0},{"$f":"SUM(K67:K72)","v":0},null,{"$f":"SUM(M67:M72)","v":0},{"$f":"SUM(N67:N72)","v":0},{"$f":"SUM(O67:O72)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B75","v":"Volunteer Subsistence"},null,{"$f":"'4. CASHFLOW'!$D75","v":0},null,null,{"$f":"'4. CASHFLOW'!$E75","v":0},null,null,{"$f":"'4. CASHFLOW'!$F75","v":0},null,null,{"$f":"D74+G74+J74","v":0},{"$f":"E74+H74+K74","v":0},{"$f":"M74-N74","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B76","v":"Volunteer Travel"},null,{"$f":"'4. CASHFLOW'!$D76","v":0},null,null,{"$f":"'4. CASHFLOW'!$E76","v":0},null,null,{"$f":"'4. CASHFLOW'!$F76","v":0},null,null,{"$f":"D75+G75+J75","v":0},{"$f":"E75+H75+K75","v":0},{"$f":"M75-N75","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B77","v":" Total Volunteer Costs"},null,{"$f":"SUM(D74:D75)","v":0},{"$f":"SUM(E74:E75)","v":0},null,{"$f":"SUM(G74:G75)","v":0},{"$f":"SUM(H74:H75)","v":0},null,{"$f":"SUM(J74:J75)","v":0},{"$f":"SUM(K74:K75)","v":0},null,{"$f":"SUM(M74:M75)","v":0},{"$f":"SUM(N74:N75)","v":0},{"$f":"SUM(O74:O75)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B78","v":"Advertising / Promotions"},null,{"$f":"'4. CASHFLOW'!$D78","v":0},null,null,{"$f":"'4. CASHFLOW'!$E78","v":0},null,null,{"$f":"'4. CASHFLOW'!$F78","v":0},null,null,{"$f":"D77+G77+J77","v":0},{"$f":"E77+H77+K77","v":0},{"$f":"M77-N77","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B79","v":"Market Research"},null,{"$f":"'4. CASHFLOW'!$D79","v":0},null,null,{"$f":"'4. CASHFLOW'!$E79","v":0},null,null,{"$f":"'4. CASHFLOW'!$F79","v":0},null,null,{"$f":"D78+G78+J78","v":0},{"$f":"E78+H78+K78","v":0},{"$f":"M78-N78","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B80","v":"Total Advertising"},null,{"$f":"SUM(D77:D78)","v":0},{"$f":"SUM(E77:E78)","v":0},null,{"$f":"SUM(G77:G78)","v":0},{"$f":"SUM(H77:H78)","v":0},null,{"$f":"SUM(J77:J78)","v":0},{"$f":"SUM(K77:K78)","v":0},null,{"$f":"SUM(M77:M78)","v":0},{"$f":"SUM(N77:N78)","v":0},{"$f":"SUM(O77:O78)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B81","v":"Vehicle Tax"},null,{"$f":"'4. CASHFLOW'!$D81","v":0},null,null,{"$f":"'4. CASHFLOW'!$E81","v":0},null,null,{"$f":"'4. CASHFLOW'!$F81","v":0},null,null,{"$f":"D80+G80+J80","v":0},0,{"$f":"M80-N80","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B82","v":"Insurance"},null,{"$f":"'4. CASHFLOW'!$D82","v":0},null,null,{"$f":"'4. CASHFLOW'!$E82","v":0},null,null,{"$f":"'4. CASHFLOW'!$F82","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B83","v":"Petrol / Oil"},null,{"$f":"'4. CASHFLOW'!$D83","v":0},null,null,{"$f":"'4. CASHFLOW'!$E83","v":0},null,null,{"$f":"'4. CASHFLOW'!$F83","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B84","v":"Vehicle Maintenance / MOT"},null,{"$f":"'4. CASHFLOW'!$D84","v":0},null,null,{"$f":"'4. CASHFLOW'!$E84","v":0},null,null,{"$f":"'4. CASHFLOW'!$F84","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B85","v":"Mileage Costs Paid"},null,{"$f":"'4. CASHFLOW'!$D85","v":0},null,null,{"$f":"'4. CASHFLOW'!$E85","v":0},null,null,{"$f":"'4. CASHFLOW'!$F85","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B86","v":"Other Travel costs"},null,{"$f":"'4. CASHFLOW'!$D86","v":0},null,null,{"$f":"'4. CASHFLOW'!$E86","v":0},null,null,{"$f":"'4. CASHFLOW'!$F86","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B87","v":"Other"},null,{"$f":"'4. CASHFLOW'!$D87","v":0},null,null,{"$f":"'4. CASHFLOW'!$E87","v":0},null,null,{"$f":"'4. CASHFLOW'!$F87","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!$B88","v":"Total Transport"},null,{"$f":"SUM(D80:D86)","v":0},{"$f":"SUM(E80:E86)","v":0},null,{"$f":"SUM(G80:G86)","v":0},{"$f":"SUM(H80:H86)","v":0},null,{"$f":"SUM(J80:J86)","v":0},{"$f":"SUM(K80:K86)","v":0},null,{"$f":"SUM(M80:M86)","v":0},{"$f":"SUM(N80:N86)","v":0},{"$f":"SUM(O80:O86)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B89","v":"Quality Assurance"},null,{"$f":"'4. CASHFLOW'!$D89","v":0},null,null,{"$f":"'4. CASHFLOW'!$E89","v":0},null,null,{"$f":"'4. CASHFLOW'!$F89","v":0},null,null,{"$f":"D88+G88+J88","v":0},0,{"$f":"M88-N88","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B90","v":"I"},null,{"$f":"'4. CASHFLOW'!$D90","v":0},null,null,{"$f":"'4. CASHFLOW'!$E90","v":0},null,null,{"$f":"'4. CASHFLOW'!$F90","v":0},null,null,0,0,{"$f":"M89-N89","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B91","v":"ii"},null,{"$f":"'4. CASHFLOW'!$D91","v":0},null,null,{"$f":"'4. CASHFLOW'!$E91","v":0},null,null,{"$f":"'4. CASHFLOW'!$F91","v":0},null,null,0,0,{"$f":"M90-N90","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!$B92","v":"Total Quality Assurance"},null,{"$f":"SUM(D88:D90)","v":0},{"$f":"SUM(E88:E90)","v":0},null,{"$f":"SUM(G88:G90)","v":0},{"$f":"SUM(H88:H90)","v":0},null,{"$f":"SUM(J88:J90)","v":0},{"$f":"SUM(K88:K90)","v":0},null,{"$f":"SUM(M88:M90)","v":0},{"$f":"SUM(N88:N90)","v":0},{"$f":"SUM(O88:O90)","v":0},"OK"]
[null,"TOTAL REVENUE EXPENDITURE",null,{"$f":"SUM(D91,D87,D79,D76,D73,D66,D52,D48,D38)","v":0},{"$f":"SUM(E91,E87,E79,E76,E73,E66,E52,E48,E38)","v":0},null,{"$f":"SUM(G91,G87,G79,G76,G73,G66,G52,G48,G38)","v":0},{"$f":"SUM(H91,H87,H79,H76,H73,H66,H52,H48,H38)","v":0},null,{"$f":"SUM(J91,J87,J79,J76,J73,J66,J52,J48,J38)","v":0},{"$f":"SUM(K91,K87,K79,K76,K73,K66,K52,K48,K38)","v":0},null,{"$f":"SUM(M91,M87,M79,M76,M73,M66,M52,M48,M38)","v":0},{"$f":"SUM(N91,N87,N79,N76,N73,N66,N52,N48,N38)","v":0},{"$f":"SUM(O91,O87,O79,O76,O73,O66,O52,O48,O38)","v":0},"OK"]
[]
[null,"Total Income",null,{"$f":"D28","v":0},{"$f":"E28","v":0},null,{"$f":"G28","v":0},{"$f":"H28","v":0},null,{"$f":"J28","v":0},{"$f":"K28","v":0},null,{"$f":"M28","v":0},{"$f":"N28","v":0},{"$f":"O28","v":0},{"$f":"IF(O94=0,\"OK\",IF(O94>0,\"Credit\",IF(O94<0,\"Defecit\")))","v":"OK"}]
[null,"Total Expenditure",null,{"$f":"D92","v":0},{"$f":"E92","v":0},null,{"$f":"G92","v":0},{"$f":"H92","v":0},null,{"$f":"J92","v":0},{"$f":"K92","v":0},null,{"$f":"M92","v":0},{"$f":"N92","v":0},{"$f":"O92","v":0},{"$f":"IF(O95=0,\"OK\",IF(O95>0,\"Underspent\",IF(O95<0,\"Overspent\")))","v":"OK"}]
[null,"Closing balance",null,{"$f":"D94-D95","v":0},{"$f":"E94-E95","v":0},null,{"$f":"G94-G95","v":0},{"$f":"H94-H95","v":0},null,{"$f":"J94-J95","v":0},{"$f":"K94-K95","v":0},null,{"$f":"M94-M95","v":0},{"$f":"N94-N95","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(N94<M94,\"WARNING YOUR INCOME IS LESS THAN BUDGETED\",\"YOUR INCOME IS OK\")","v":"YOUR INCOME IS OK"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(N95>M95,\"WARNING YOUR EXPENDITURE IS MORE THAN YOUR BUDGET\",\"YOUR EXPENDITURE IS OK\")","v":"YOUR EXPENDITURE IS OK"}]

{"sheet":"6. Q2","index":5,"n_rows":100,"n_cols":18,"rows_kept":100,"cut":false,"hidden":false,"merged":[[2,4,2,6],[2,7,2,9],[2,11,4,15],[4,3,4,10],[99,9,99,15],[9,14,10,14],[12,9,12,14],[97,9,97,15],[4,0,4,1],[9,12,9,13],[9,1,10,1],[9,3,9,4],[9,6,9,7],[9,9,9,10],[6,3,6,14]]}
[null,null,null," "]
[]
[null,{"$f":"IF(H3=0, \"Please insert date completed\", \"\")","v":"Please insert date completed"},null,null,"Date completed",null,null,{"$f":"'4. CASHFLOW'!H3","v":"00:00:00"},null,null,null,"Actual Expenditure",null,null,null,null,null," "]
[]
[null,null,null,{"$f":"'3. Staff Salaries'!C3","v":"Setting Name: "}]
[]
[null,null,null,"The figures in the blue boxes are your budgets which are brought in from the cashflow forecast. Only complete the white boxes below which apply to your setting, these are your actuals for each month. The column at the end will give you an indication of how you are performing against your budget."]
[]
[]
[null,{"$f":"'4. CASHFLOW'!B9","v":0},null,"JULY",null,null,"AUGUST",null,null,"SEPTEMBER",null,null,"TOTAL",null,"Variance"]
[null,null,null,"Budget","Actual",null,"Budget","Actual",null,"Budget","Actual",null,"Budget","Actual"]
[]
[null,"Income",null,null,null,null,null,null,null,"Quarterly Return Q2"]
[]
[null,{"$f":"'4. CASHFLOW'!B15","v":"Early Education Entitlement"},null,{"$f":"'4. CASHFLOW'!$H15","v":0},null,null,{"$f":"'4. CASHFLOW'!$I15","v":0},null,null,{"$f":"'4. CASHFLOW'!$J15","v":0},null,null,{"$f":"D15+G15+J15","v":0},{"$f":"E15+H15+K15","v":0},{"$f":"N15-M15","v":0},{"$f":"IF(O15=0,\"OK\",IF(O15>0,\"Credit\",IF(O15<0,\"Defecit\")))","v":"OK"}]
[null,{"$f":"'4. CASHFLOW'!B16","v":"Fees From parents"},null,{"$f":"'4. CASHFLOW'!$H16","v":0},null,null,{"$f":"'4. CASHFLOW'!$I16","v":0},null,null,{"$f":"'4. CASHFLOW'!$J16","v":0},null,null,{"$f":"D16+G16+J16","v":0},0,{"$f":"N16-M16","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B17","v":"Bank Loans"},null,{"$f":"'4. CASHFLOW'!$H17","v":0},null,null,{"$f":"'4. CASHFLOW'!$I17","v":0},null,null,{"$f":"'4. CASHFLOW'!$J17","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B18","v":"Local Authority Grants"},null,{"$f":"'4. CASHFLOW'!$H18","v":0},null,null,{"$f":"'4. CASHFLOW'!$I18","v":0},null,null,{"$f":"'4. CASHFLOW'!$J18","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B19","v":"Early Years Partnership Grants"},null,{"$f":"'4. CASHFLOW'!$H19","v":0},null,null,{"$f":"'4. CASHFLOW'!$I19","v":0},null,null,{"$f":"'4. CASHFLOW'!$J19","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B20","v":"Own funds (Reserves)"},null,{"$f":"'4. CASHFLOW'!$H20","v":0},null,null,{"$f":"'4. CASHFLOW'!$I20","v":0},null,null,{"$f":"'4. CASHFLOW'!$J20","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B21","v":"Asset Disposal"},null,{"$f":"'4. CASHFLOW'!$H21","v":0},null,null,{"$f":"'4. CASHFLOW'!$I21","v":0},null,null,{"$f":"'4. CASHFLOW'!$J21","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B22","v":"Room Lettings"},null,{"$f":"'4. CASHFLOW'!$H22","v":0},null,null,{"$f":"'4. CASHFLOW'!$I22","v":0},null,null,{"$f":"'4. CASHFLOW'!$J22","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B23","v":"Fund Raising"},null,{"$f":"'4. CASHFLOW'!$H23","v":0},null,null,{"$f":"'4. CASHFLOW'!$I23","v":0},null,null,{"$f":"'4. CASHFLOW'!$J23","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B24","v":"Donations"},null,{"$f":"'4. CASHFLOW'!$H24","v":0},null,null,{"$f":"'4. CASHFLOW'!$I24","v":0},null,null,{"$f":"'4. CASHFLOW'!$J24","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B25","v":"Bank interest"},null,{"$f":"'4. CASHFLOW'!$H25","v":0},null,null,{"$f":"'4. CASHFLOW'!$I25","v":0},null,null,{"$f":"'4. CASHFLOW'!$J25","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B26","v":0},null,{"$f":"'4. CASHFLOW'!$H26","v":0},null,null,{"$f":"'4. CASHFLOW'!$I26","v":0},null,null,{"$f":"'4. CASHFLOW'!$J26","v":0},null,null,0,0,0,"OK"]
[]
[null,"TOTAL INCOME ",null,{"$f":"SUM(D15:D27)","v":0},{"$f":"SUM(E15:E27)","v":0},null,{"$f":"SUM(G15:G27)","v":0},{"$f":"SUM(H15:H27)","v":0},null,{"$f":"SUM(J15:J27)","v":0},{"$f":"SUM(K15:K27)","v":0},null,{"$f":"SUM(M15:M27)","v":0},{"$f":"SUM(N15:N27)","v":0},{"$f":"SUM(O15:O27)","v":0},{"$f":"IF(O28=0,\"OK\",IF(O28>0,\"Credit\",IF(O28<0,\"Defecit\")))","v":"OK"}]
[]
[null,"Expenditure"]
[]
[null,{"$f":"'4. CASHFLOW'!B32","v":"Wages & Salaries"},null,{"$f":"'4. CASHFLOW'!$H32","v":0},null,null,{"$f":"'4. CASHFLOW'!$I32","v":0},null,null,{"$f":"'4. CASHFLOW'!$J32","v":0},null,null,{"$f":"D32+G32+J32","v":0},0,{"$f":"M32-N32","v":0},{"$f":"IF(O32=0,\"OK\",IF(O32>0,\"Underspent\",IF(O32<0,\"Overspent\")))","v":"OK"}]
[null,{"$f":"'4. CASHFLOW'!B33","v":"Holiday Cover"},null,{"$f":"'4. CASHFLOW'!$H33","v":0},null,null,{"$f":"'4. CASHFLOW'!$I33","v":0},null,null,{"$f":"'4. CASHFLOW'!$J33","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B34","v":"Overtime"},null,{"$f":"'4. CASHFLOW'!$H34","v":0},null,null,{"$f":"'4. CASHFLOW'!$I34","v":0},null,null,{"$f":"'4. CASHFLOW'!$J34","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B35","v":"Staff  Training"},null,{"$f":"'4. CASHFLOW'!$H35","v":0},null,null,{"$f":"'4. CASHFLOW'!$I35","v":0},null,null,{"$f":"'4. CASHFLOW'!$J35","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B36","v":"Other On-costs"},null,{"$f":"'4. CASHFLOW'!$H36","v":0},null,null,{"$f":"'4. CASHFLOW'!$I36","v":0},null,null,{"$f":"'4. CASHFLOW'!$J36","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B37","v":"Other "},null,{"$f":"'4. CASHFLOW'!$H37","v":0},null,null,{"$f":"'4. CASHFLOW'!$I37","v":0},null,null,{"$f":"'4. CASHFLOW'!$J37","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B38","v":"Total Staff Costs"},null,{"$f":"SUM(D32:D37)","v":0},{"$f":"SUM(E32:E37)","v":0},null,{"$f":"SUM(G32:G37)","v":0},{"$f":"SUM(H32:H37)","v":0},null,{"$f":"SUM(J32:J37)","v":0},{"$f":"SUM(K32:K37)","v":0},null,{"$f":"SUM(M32:M37)","v":0},{"$f":"SUM(N32:N37)","v":0},{"$f":"SUM(O32:O37)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B39","v":"Rent"},null,{"$f":"'4. CASHFLOW'!$H39","v":0},null,null,{"$f":"'4. CASHFLOW'!$I39","v":0},null,null,{"$f":"'4. CASHFLOW'!$J39","v":0},null,null,{"$f":"D39+G39+J39","v":0},0,{"$f":"M39-N39","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B40","v":"Day to Day Maintenance"},null,{"$f":"'4. CASHFLOW'!$H40","v":0},null,null,{"$f":"'4. CASHFLOW'!$I40","v":0},null,null,{"$f":"'4. CASHFLOW'!$J40","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B41","v":"Electricity"},null,{"$f":"'4. CASHFLOW'!$H41","v":0},null,null,{"$f":"'4. CASHFLOW'!$I41","v":0},null,null,{"$f":"'4. CASHFLOW'!$J41","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B42","v":"Gas"},null,{"$f":"'4. CASHFLOW'!$H42","v":0},null,null,{"$f":"'4. CASHFLOW'!$I42","v":0},null,null,{"$f":"'4. CASHFLOW'!$J42","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B43","v":"Business Rates"},null,{"$f":"'4. CASHFLOW'!$H43","v":0},null,null,{"$f":"'4. CASHFLOW'!$I43","v":0},null,null,{"$f":"'4. CASHFLOW'!$J43","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B44","v":"Water"},null,{"$f":"'4. CASHFLOW'!$H44","v":0},null,null,{"$f":"'4. CASHFLOW'!$I44","v":0},null,null,{"$f":"'4. CASHFLOW'!$J44","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B45","v":"Cleaning"},null,{"$f":"'4. CASHFLOW'!$H45","v":0},null,null,{"$f":"'4. CASHFLOW'!$I45","v":0},null,null,{"$f":"'4. CASHFLOW'!$J45","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B46","v":"Other"},null,{"$f":"'4. CASHFLOW'!$H46","v":0},null,null,{"$f":"'4. CASHFLOW'!$I46","v":0},null,null,{"$f":"'4. CASHFLOW'!$J46","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B47","v":"Other"},null,{"$f":"'4. CASHFLOW'!$H47","v":0},null,null,{"$f":"'4. CASHFLOW'!$I47","v":0},null,null,{"$f":"'4. CASHFLOW'!$J47","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B48","v":"Total Premises"},null,{"$f":"SUM(D39:D47)","v":0},{"$f":"SUM(E39:E47)","v":0},null,{"$f":"SUM(G39:G47)","v":0},{"$f":"SUM(H39:H47)","v":0},null,{"$f":"SUM(J39:J47)","v":0},{"$f":"SUM(K39:K47)","v":0},null,{"$f":"SUM(M39:M47)","v":0},{"$f":"SUM(N39:N47)","v":0},{"$f":"SUM(O39:O47)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B49","v":"Building Insurance"},null,{"$f":"'4. CASHFLOW'!$H49","v":0},null,null,{"$f":"'4. CASHFLOW'!$I49","v":0},null,null,{"$f":"'4. CASHFLOW'!$J49","v":0},null,null,{"$f":"D49+G49+J49","v":0},0,{"$f":"M49-N49","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B50","v":"Contents Insurance"},null,{"$f":"'4. CASHFLOW'!$H50","v":0},null,null,{"$f":"'4. CASHFLOW'!$I50","v":0},null,null,{"$f":"'4. CASHFLOW'!$J50","v":0},null,null,0,0,{"$f":"M50-N50","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B51","v":"Employment Insurance"},null,{"$f":"'4. CASHFLOW'!$H51","v":0},null,null,{"$f":"'4. CASHFLOW'!$I51","v":0},null,null,{"$f":"'4. CASHFLOW'!$J51","v":0},null,null,0,0,{"$f":"M51-N51","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B52","v":"Total Insurance"},null,{"$f":"SUM(D49:D51)","v":0},{"$f":"SUM(E49:E51)","v":0},null,{"$f":"SUM(G49:G51)","v":0},{"$f":"SUM(H49:H51)","v":0},null,{"$f":"SUM(J49:J51)","v":0},{"$f":"SUM(K49:K51)","v":0},null,{"$f":"SUM(M49:M51)","v":0},{"$f":"SUM(N49:N51)","v":0},{"$f":"SUM(O49:O51)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B54","v":"Telephone Charges"},null,{"$f":"'4. CASHFLOW'!$H54","v":0},null,null,{"$f":"'4. CASHFLOW'!$I54","v":0},null,null,{"$f":"'4. CASHFLOW'!$J54","v":0},null,null,{"$f":"D53+G53+J53","v":0},0,{"$f":"M53-N53","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B55","v":"Postage "},null,{"$f":"'4. CASHFLOW'!$H55","v":0},null,null,{"$f":"'4. CASHFLOW'!$I55","v":0},null,null,{"$f":"'4. CASHFLOW'!$J55","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B56","v":"Printing & Stationery"},null,{"$f":"'4. CASHFLOW'!$H56","v":0},null,null,{"$f":"'4. CASHFLOW'!$I56","v":0},null,null,{"$f":"'4. CASHFLOW'!$J56","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B57","v":"Membership Fees"},null,{"$f":"'4. CASHFLOW'!$H57","v":0},null,null,{"$f":"'4. CASHFLOW'!$I57","v":0},null,null,{"$f":"'4. CASHFLOW'!$J57","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B58","v":"Bank Charges"},null,{"$f":"'4. CASHFLOW'!$H58","v":0},null,null,{"$f":"'4. CASHFLOW'!$I58","v":0},null,null,{"$f":"'4. CASHFLOW'!$J58","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B59","v":"Professional Fees"},null,{"$f":"'4. CASHFLOW'!$H59","v":0},null,null,{"$f":"'4. CASHFLOW'!$I59","v":0},null,null,{"$f":"'4. CASHFLOW'!$J59","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B60","v":"Other Administration Costs"},null,{"$f":"'4. CASHFLOW'!$H60","v":0},null,null,{"$f":"'4. CASHFLOW'!$I60","v":0},null,null,{"$f":"'4. CASHFLOW'!$J60","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B61","v":"Subscriptions"},null,{"$f":"'4. CASHFLOW'!$H61","v":0},null,null,{"$f":"'4. CASHFLOW'!$I61","v":0},null,null,{"$f":"'4. CASHFLOW'!$J61","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B62","v":"Loan Repayments"},null,{"$f":"'4. CASHFLOW'!$H62","v":0},null,null,{"$f":"'4. CASHFLOW'!$I62","v":0},null,null,{"$f":"'4. CASHFLOW'!$J62","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B63","v":"HP Payments"},null,{"$f":"'4. CASHFLOW'!$H63","v":0},null,null,{"$f":"'4. CASHFLOW'!$I63","v":0},null,null,{"$f":"'4. CASHFLOW'!$J63","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B64","v":"Office Equipment"},null,{"$f":"'4. CASHFLOW'!$H64","v":0},null,null,{"$f":"'4. CASHFLOW'!$I64","v":0},null,null,{"$f":"'4. CASHFLOW'!$J64","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B65","v":"Other"},null,{"$f":"'4. CASHFLOW'!$H65","v":0},null,null,{"$f":"'4. CASHFLOW'!$I65","v":0},null,null,{"$f":"'4. CASHFLOW'!$J65","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B66","v":"Other"},null,{"$f":"'4. CASHFLOW'!$H66","v":0},null,null,{"$f":"'4. CASHFLOW'!$I66","v":0},null,null,{"$f":"'4. CASHFLOW'!$J66","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B67","v":"Total Administration"},null,{"$f":"SUM(D53:D65)","v":0},{"$f":"SUM(E53:E65)","v":0},null,{"$f":"SUM(G53:G65)","v":0},{"$f":"SUM(H53:H65)","v":0},null,{"$f":"SUM(J53:J65)","v":0},{"$f":"SUM(K53:K65)","v":0},null,{"$f":"SUM(M53:M65)","v":0},{"$f":"SUM(N53:N65)","v":0},{"$f":"SUM(O53:O65)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B68","v":"Consumables"},null,{"$f":"'4. CASHFLOW'!$H68","v":0},null,null,{"$f":"'4. CASHFLOW'!$I68","v":0},null,null,{"$f":"'4. CASHFLOW'!$J68","v":0},null,null,{"$f":"D67+G67+J67","v":0},0,{"$f":"M67-N67","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B69","v":"Visits & Trips out "},null,{"$f":"'4. CASHFLOW'!$H69","v":0},null,null,{"$f":"'4. CASHFLOW'!$I69","v":0},null,null,{"$f":"'4. CASHFLOW'!$J69","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B70","v":"Catering"},null,{"$f":"'4. CASHFLOW'!$H70","v":0},null,null,{"$f":"'4. CASHFLOW'!$I70","v":0},null,null,{"$f":"'4. CASHFLOW'!$J70","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B71","v":"Misc / Sundries"},null,{"$f":"'4. CASHFLOW'!$H71","v":0},null,null,{"$f":"'4. CASHFLOW'!$I71","v":0},null,null,{"$f":"'4. CASHFLOW'!$J71","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B72","v":"Repairs & renewals"},null,{"$f":"'4. CASHFLOW'!$H72","v":0},null,null,{"$f":"'4. CASHFLOW'!$I72","v":0},null,null,{"$f":"'4. CASHFLOW'!$J72","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B73","v":"Other"},null,{"$f":"'4. CASHFLOW'!$H73","v":0},null,null,{"$f":"'4. CASHFLOW'!$I73","v":0},null,null,{"$f":"'4. CASHFLOW'!$J73","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B74","v":"Total Activity & Material Costs"},null,{"$f":"SUM(D67:D72)","v":0},{"$f":"SUM(E67:E72)","v":0},null,{"$f":"SUM(G67:G72)","v":0},{"$f":"SUM(H67:H72)","v":0},null,{"$f":"SUM(J67:J72)","v":0},{"$f":"SUM(K67:K72)","v":0},null,{"$f":"SUM(M67:M72)","v":0},{"$f":"SUM(N67:N72)","v":0},{"$f":"SUM(O67:O72)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B75","v":"Volunteer Subsistence"},null,{"$f":"'4. CASHFLOW'!$H75","v":0},null,null,{"$f":"'4. CASHFLOW'!$I75","v":0},null,null,{"$f":"'4. CASHFLOW'!$J75","v":0},null,null,{"$f":"D74+G74+J74","v":0},{"$f":"E74+H74+K74","v":0},{"$f":"M74-N74","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B76","v":"Volunteer Travel"},null,{"$f":"'4. CASHFLOW'!$H76","v":0},null,null,{"$f":"'4. CASHFLOW'!$I76","v":0},null,null,{"$f":"'4. CASHFLOW'!$J76","v":0},null,null,{"$f":"D75+G75+J75","v":0},{"$f":"E75+H75+K75","v":0},{"$f":"M75-N75","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B77","v":" Total Volunteer Costs"},null,{"$f":"SUM(D74:D75)","v":0},{"$f":"SUM(E74:E75)","v":0},null,{"$f":"SUM(G74:G75)","v":0},{"$f":"SUM(H74:H75)","v":0},null,{"$f":"SUM(J74:J75)","v":0},{"$f":"SUM(K74:K75)","v":0},null,{"$f":"SUM(M74:M75)","v":0},{"$f":"SUM(N74:N75)","v":0},{"$f":"SUM(O74:O75)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B78","v":"Advertising / Promotions"},null,{"$f":"'4. CASHFLOW'!$H78","v":0},null,null,{"$f":"'4. CASHFLOW'!$I78","v":0},null,null,{"$f":"'4. CASHFLOW'!$J78","v":0},null,null,{"$f":"D77+G77+J77","v":0},{"$f":"E77+H77+K77","v":0},{"$f":"M77-N77","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B79","v":"Market Research"},null,{"$f":"'4. CASHFLOW'!$H79","v":0},null,null,{"$f":"'4. CASHFLOW'!$I79","v":0},null,null,{"$f":"'4. CASHFLOW'!$J79","v":0},null,null,{"$f":"D78+G78+J78","v":0},{"$f":"E78+H78+K78","v":0},{"$f":"M78-N78","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B80","v":"Total Advertising"},null,{"$f":"SUM(D77:D78)","v":0},{"$f":"SUM(E77:E78)","v":0},null,{"$f":"SUM(G77:G78)","v":0},{"$f":"SUM(H77:H78)","v":0},null,{"$f":"SUM(J77:J78)","v":0},{"$f":"SUM(K77:K78)","v":0},null,{"$f":"SUM(M77:M78)","v":0},{"$f":"SUM(N77:N78)","v":0},{"$f":"SUM(O77:O78)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B81","v":"Vehicle Tax"},null,{"$f":"'4. CASHFLOW'!$H81","v":0},null,null,{"$f":"'4. CASHFLOW'!$I81","v":0},null,null,{"$f":"'4. CASHFLOW'!$J81","v":0},null,null,{"$f":"D80+G80+J80","v":0},0,{"$f":"M80-N80","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B82","v":"Insurance"},null,{"$f":"'4. CASHFLOW'!$H82","v":0},null,null,{"$f":"'4. CASHFLOW'!$I82","v":0},null,null,{"$f":"'4. CASHFLOW'!$J82","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B83","v":"Petrol / Oil"},null,{"$f":"'4. CASHFLOW'!$H83","v":0},null,null,{"$f":"'4. CASHFLOW'!$I83","v":0},null,null,{"$f":"'4. CASHFLOW'!$J83","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B84","v":"Vehicle Maintenance / MOT"},null,{"$f":"'4. CASHFLOW'!$H84","v":0},null,null,{"$f":"'4. CASHFLOW'!$I84","v":0},null,null,{"$f":"'4. CASHFLOW'!$J84","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B85","v":"Mileage Costs Paid"},null,{"$f":"'4. CASHFLOW'!$H85","v":0},null,null,{"$f":"'4. CASHFLOW'!$I85","v":0},null,null,{"$f":"'4. CASHFLOW'!$J85","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B86","v":"Other Travel costs"},null,{"$f":"'4. CASHFLOW'!$H86","v":0},null,null,{"$f":"'4. CASHFLOW'!$I86","v":0},null,null,{"$f":"'4. CASHFLOW'!$J86","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B87","v":"Other"},null,{"$f":"'4. CASHFLOW'!$H87","v":0},null,null,{"$f":"'4. CASHFLOW'!$I87","v":0},null,null,{"$f":"'4. CASHFLOW'!$J87","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B88","v":"Total Transport"},null,{"$f":"SUM(D80:D86)","v":0},{"$f":"SUM(E80:E86)","v":0},null,{"$f":"SUM(G80:G86)","v":0},{"$f":"SUM(H80:H86)","v":0},null,{"$f":"SUM(J80:J86)","v":0},{"$f":"SUM(K80:K86)","v":0},null,{"$f":"SUM(M80:M86)","v":0},{"$f":"SUM(N80:N86)","v":0},{"$f":"SUM(O80:O86)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B89","v":"Quality Assurance"},null,{"$f":"'4. CASHFLOW'!$H89","v":0},null,null,{"$f":"'4. CASHFLOW'!$I89","v":0},null,null,{"$f":"'4. CASHFLOW'!$J89","v":0},null,null,{"$f":"D88+G88+J88","v":0},0,{"$f":"M88-N88","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B90","v":"I"},null,{"$f":"'4. CASHFLOW'!$H90","v":0},null,null,{"$f":"'4. CASHFLOW'!$I89","v":0},null,null,{"$f":"'4. CASHFLOW'!$J90","v":0},null,null,0,0,{"$f":"M89-N89","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B91","v":"ii"},null,{"$f":"'4. CASHFLOW'!$H91","v":0},null,null,{"$f":"'4. CASHFLOW'!$I90","v":0},null,null,{"$f":"'4. CASHFLOW'!$J91","v":0},null,null,0,0,{"$f":"M90-N90","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B92","v":"Total Quality Assurance"},null,{"$f":"SUM(D88:D90)","v":0},{"$f":"SUM(E88:E90)","v":0},null,{"$f":"SUM(G88:G90)","v":0},{"$f":"SUM(H88:H90)","v":0},null,{"$f":"SUM(J88:J90)","v":0},{"$f":"SUM(K88:K90)","v":0},null,{"$f":"SUM(M88:M90)","v":0},{"$f":"SUM(N88:N90)","v":0},{"$f":"SUM(O88:O90)","v":0},"OK"]
[null,"TOTAL REVENUE EXPENDITURE",null,{"$f":"SUM(D91,D87,D79,D76,D73,D66,D52,D48,D38)","v":0},{"$f":"SUM(E91,E87,E79,E76,E73,E66,E52,E48,E38)","v":0},null,{"$f":"SUM(G91,G87,G79,G76,G73,G66,G52,G48,G38)","v":0},{"$f":"SUM(H91,H87,H79,H76,H73,H66,H52,H48,H38)","v":0},null,{"$f":"SUM(J91,J87,J79,J76,J73,J66,J52,J48,J38)","v":0},{"$f":"SUM(K91,K87,K79,K76,K73,K66,K52,K48,K38)","v":0},null,{"$f":"SUM(M91,M87,M79,M76,M73,M66,M52,M48,M38)","v":0},{"$f":"SUM(N91,N87,N79,N76,N73,N66,N52,N48,N38)","v":0},{"$f":"SUM(O91,O87,O79,O76,O73,O66,O52,O48,O38)","v":0},"OK"]
[]
[null,"Total Income",null,{"$f":"D28","v":0},{"$f":"E28","v":0},null,{"$f":"G28","v":0},{"$f":"H28","v":0},null,{"$f":"J28","v":0},{"$f":"K28","v":0},null,{"$f":"M28","v":0},{"$f":"N28","v":0},{"$f":"O28","v":0},{"$f":"IF(O94=0,\"OK\",IF(O94>0,\"Credit\",IF(O94<0,\"Defecit\")))","v":"OK"}]
[null,"Total Expenditure",null,{"$f":"D92","v":0},{"$f":"E92","v":0},null,{"$f":"G92","v":0},{"$f":"H92","v":0},null,{"$f":"J92","v":0},{"$f":"K92","v":0},null,{"$f":"M92","v":0},{"$f":"N92","v":0},{"$f":"O92","v":0},{"$f":"IF(O95=0,\"OK\",IF(O95>0,\"Underspent\",IF(O95<0,\"Overspent\")))","v":"OK"}]
[null,"Closing balance",null,{"$f":"D94-D95","v":0},{"$f":"E94-E95","v":0},null,{"$f":"G94-G95","v":0},{"$f":"H94-H95","v":0},null,{"$f":"J94-J95","v":0},{"$f":"K94-K95","v":0},null,{"$f":"M94-M95","v":0},{"$f":"N94-N95","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(N94<M94,\"WARNING YOUR INCOME IS LESS THAN BUDGETED\",\"YOUR INCOME IS OK\")","v":"YOUR INCOME IS OK"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(N95>M95,\"WARNING YOUR EXPENDITURE IS MORE THAN YOUR BUDGET\",\"YOUR EXPENDITURE IS OK\")","v":"YOUR EXPENDITURE IS OK"}]

{"sheet":"7. Q3","index":6,"n_rows":100,"n_cols":16,"rows_kept":100,"cut":false,"hidden":false,"merged":[[2,4,2,6],[2,7,2,9],[2,11,4,15],[4,3,4,10],[99,9,99,15],[9,14,10,14],[12,9,12,14],[97,9,97,15],[4,0,4,1],[9,12,9,13],[9,1,10,1],[9,3,9,4],[9,6,9,7],[9,9,9,10],[6,3,6,14]]}
[]
[]
[null,{"$f":"IF(H3=0, \"Please insert date completed\", \"\")","v":"Please insert date completed"},null,null,"Date completed",null,null,{"$f":"'4. CASHFLOW'!H3","v":"00:00:00"},null,null,null,"Actual Expenditure"]
[]
[null,null,null,{"$f":"'3. Staff Salaries'!C3","v":"Setting Name: "}]
[]
[null,null,null,"The figures in the blue boxes are your budgets which are brought in from the cashflow forecast. Only complete the white boxes below which apply to your setting, these are your actuals for each month. The column at the end will give you an indication of how you are performing against your budget."]
[]
[]
[null,{"$f":"'4. CASHFLOW'!B9","v":0},null,"OCTOBER",null,null,"NOVEMBER",null,null,"DECEMBER",null,null,"TOTAL",null,"Variance"]
[null,null,null,"Budget","Actual",null,"Budget","Actual",null,"Budget","Actual",null,"Budget","Actual"]
[]
[null,"Income",null,null,null,null,null,null,null,"Quarterly Return Q3"]
[]
[null,{"$f":"'4. CASHFLOW'!B15","v":"Early Education Entitlement"},null,{"$f":"'4. CASHFLOW'!$L15","v":0},null,null,{"$f":"'4. CASHFLOW'!$M15","v":0},null,null,{"$f":"'4. CASHFLOW'!$N15","v":0},null,null,{"$f":"D15+G15+J15","v":0},{"$f":"E15+H15+K15","v":0},{"$f":"N15-M15","v":0},{"$f":"IF(O15=0,\"OK\",IF(O15>0,\"Credit\",IF(O15<0,\"Defecit\")))","v":"OK"}]
[null,{"$f":"'4. CASHFLOW'!B16","v":"Fees From parents"},null,{"$f":"'4. CASHFLOW'!$L16","v":0},null,null,{"$f":"'4. CASHFLOW'!$M16","v":0},null,null,{"$f":"'4. CASHFLOW'!$N16","v":0},null,null,{"$f":"D16+G16+J16","v":0},0,{"$f":"N16-M16","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B17","v":"Bank Loans"},null,{"$f":"'4. CASHFLOW'!$L17","v":0},null,null,{"$f":"'4. CASHFLOW'!$M17","v":0},null,null,{"$f":"'4. CASHFLOW'!$N17","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B18","v":"Local Authority Grants"},null,{"$f":"'4. CASHFLOW'!$L18","v":0},null,null,{"$f":"'4. CASHFLOW'!$M18","v":0},null,null,{"$f":"'4. CASHFLOW'!$N18","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B19","v":"Early Years Partnership Grants"},null,{"$f":"'4. CASHFLOW'!$L19","v":0},null,null,{"$f":"'4. CASHFLOW'!$M19","v":0},null,null,{"$f":"'4. CASHFLOW'!$N19","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B20","v":"Own funds (Reserves)"},null,{"$f":"'4. CASHFLOW'!$L20","v":0},null,null,{"$f":"'4. CASHFLOW'!$M20","v":0},null,null,{"$f":"'4. CASHFLOW'!$N20","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B21","v":"Asset Disposal"},null,{"$f":"'4. CASHFLOW'!$L21","v":0},null,null,{"$f":"'4. CASHFLOW'!$M21","v":0},null,null,{"$f":"'4. CASHFLOW'!$N21","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B22","v":"Room Lettings"},null,{"$f":"'4. CASHFLOW'!$L22","v":0},null,null,{"$f":"'4. CASHFLOW'!$M22","v":0},null,null,{"$f":"'4. CASHFLOW'!$N22","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B23","v":"Fund Raising"},null,{"$f":"'4. CASHFLOW'!$L23","v":0},null,null,{"$f":"'4. CASHFLOW'!$M23","v":0},null,null,{"$f":"'4. CASHFLOW'!$N23","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B24","v":"Donations"},null,{"$f":"'4. CASHFLOW'!$L24","v":0},null,null,{"$f":"'4. CASHFLOW'!$M24","v":0},null,null,{"$f":"'4. CASHFLOW'!$N24","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B25","v":"Bank interest"},null,{"$f":"'4. CASHFLOW'!$L25","v":0},null,null,{"$f":"'4. CASHFLOW'!$M25","v":0},null,null,{"$f":"'4. CASHFLOW'!$N25","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B26","v":0},null,{"$f":"'4. CASHFLOW'!$L26","v":0},null,null,{"$f":"'4. CASHFLOW'!$M26","v":0},null,null,{"$f":"'4. CASHFLOW'!$N26","v":0},null,null,0,0,0,"OK"]
[]
[null,"TOTAL INCOME ",null,{"$f":"SUM(D15:D27)","v":0},{"$f":"SUM(E15:E27)","v":0},null,{"$f":"SUM(G15:G27)","v":0},{"$f":"SUM(H15:H27)","v":0},null,{"$f":"SUM(J15:J27)","v":0},{"$f":"SUM(K15:K27)","v":0},null,{"$f":"SUM(M15:M27)","v":0},{"$f":"SUM(N15:N27)","v":0},{"$f":"SUM(O15:O27)","v":0},{"$f":"IF(O28=0,\"OK\",IF(O28>0,\"Credit\",IF(O28<0,\"Defecit\")))","v":"OK"}]
[]
[null,"Expenditure"]
[]
[null,{"$f":"'4. CASHFLOW'!B32","v":"Wages & Salaries"},null,{"$f":"'4. CASHFLOW'!$L32","v":0},null,null,{"$f":"'4. CASHFLOW'!$M32","v":0},null,null,{"$f":"'4. CASHFLOW'!$N32","v":0},null,null,{"$f":"D32+G32+J32","v":0},0,{"$f":"M32-N32","v":0},{"$f":"IF(O32=0,\"OK\",IF(O32>0,\"Underspent\",IF(O32<0,\"Overspent\")))","v":"OK"}]
[null,{"$f":"'4. CASHFLOW'!B33","v":"Holiday Cover"},null,{"$f":"'4. CASHFLOW'!$L33","v":0},null,null,{"$f":"'4. CASHFLOW'!$M33","v":0},null,null,{"$f":"'4. CASHFLOW'!$N33","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B34","v":"Overtime"},null,{"$f":"'4. CASHFLOW'!$L34","v":0},null,null,{"$f":"'4. CASHFLOW'!$M34","v":0},null,null,{"$f":"'4. CASHFLOW'!$N34","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B35","v":"Staff  Training"},null,{"$f":"'4. CASHFLOW'!$L35","v":0},null,null,{"$f":"'4. CASHFLOW'!$M35","v":0},null,null,{"$f":"'4. CASHFLOW'!$N35","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B36","v":"Other On-costs"},null,{"$f":"'4. CASHFLOW'!$L36","v":0},null,null,{"$f":"'4. CASHFLOW'!$M36","v":0},null,null,{"$f":"'4. CASHFLOW'!$N36","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B37","v":"Other "},null,{"$f":"'4. CASHFLOW'!$L37","v":0},null,null,{"$f":"'4. CASHFLOW'!$M37","v":0},null,null,{"$f":"'4. CASHFLOW'!$N37","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B38","v":"Total Staff Costs"},null,{"$f":"SUM(D32:D37)","v":0},{"$f":"SUM(E32:E37)","v":0},null,{"$f":"SUM(G32:G37)","v":0},{"$f":"SUM(H32:H37)","v":0},null,{"$f":"SUM(J32:J37)","v":0},{"$f":"SUM(K32:K37)","v":0},null,{"$f":"SUM(M32:M37)","v":0},{"$f":"SUM(N32:N37)","v":0},{"$f":"SUM(O32:O37)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B39","v":"Rent"},null,{"$f":"'4. CASHFLOW'!$L39","v":0},null,null,{"$f":"'4. CASHFLOW'!$M39","v":0},null,null,{"$f":"'4. CASHFLOW'!$N39","v":0},null,null,{"$f":"D39+G39+J39","v":0},0,{"$f":"M39-N39","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B40","v":"Day to Day Maintenance"},null,{"$f":"'4. CASHFLOW'!$L40","v":0},null,null,{"$f":"'4. CASHFLOW'!$M40","v":0},null,null,{"$f":"'4. CASHFLOW'!$N40","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B41","v":"Electricity"},null,{"$f":"'4. CASHFLOW'!$L41","v":0},null,null,{"$f":"'4. CASHFLOW'!$M41","v":0},null,null,{"$f":"'4. CASHFLOW'!$N41","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B42","v":"Gas"},null,{"$f":"'4. CASHFLOW'!$L42","v":0},null,null,{"$f":"'4. CASHFLOW'!$M42","v":0},null,null,{"$f":"'4. CASHFLOW'!$N42","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B43","v":"Business Rates"},null,{"$f":"'4. CASHFLOW'!$L43","v":0},null,null,{"$f":"'4. CASHFLOW'!$M43","v":0},null,null,{"$f":"'4. CASHFLOW'!$N43","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B44","v":"Water"},null,{"$f":"'4. CASHFLOW'!$L44","v":0},null,null,{"$f":"'4. CASHFLOW'!$M44","v":0},null,null,{"$f":"'4. CASHFLOW'!$N44","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B45","v":"Cleaning"},null,{"$f":"'4. CASHFLOW'!$L45","v":0},null,null,{"$f":"'4. CASHFLOW'!$M45","v":0},null,null,{"$f":"'4. CASHFLOW'!$N45","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B46","v":"Other"},null,{"$f":"'4. CASHFLOW'!$L46","v":0},null,null,{"$f":"'4. CASHFLOW'!$M46","v":0},null,null,{"$f":"'4. CASHFLOW'!$N46","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B47","v":"Other"},null,{"$f":"'4. CASHFLOW'!$L47","v":0},null,null,{"$f":"'4. CASHFLOW'!$M47","v":0},null,null,{"$f":"'4. CASHFLOW'!$N47","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B48","v":"Total Premises"},null,{"$f":"SUM(D39:D47)","v":0},{"$f":"SUM(E39:E47)","v":0},null,{"$f":"SUM(G39:G47)","v":0},{"$f":"SUM(H39:H47)","v":0},null,{"$f":"SUM(J39:J47)","v":0},{"$f":"SUM(K39:K47)","v":0},null,{"$f":"SUM(M39:M47)","v":0},{"$f":"SUM(N39:N47)","v":0},{"$f":"SUM(O39:O47)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B49","v":"Building Insurance"},null,{"$f":"'4. CASHFLOW'!$L49","v":0},null,null,{"$f":"'4. CASHFLOW'!$M49","v":0},null,null,{"$f":"'4. CASHFLOW'!$N49","v":0},null,null,{"$f":"D49+G49+J49","v":0},0,{"$f":"M49-N49","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B50","v":"Contents Insurance"},null,{"$f":"'4. CASHFLOW'!$L50","v":0},null,null,{"$f":"'4. CASHFLOW'!$M50","v":0},null,null,{"$f":"'4. CASHFLOW'!$N50","v":0},null,null,0,0,{"$f":"M50-N50","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B51","v":"Employment Insurance"},null,{"$f":"'4. CASHFLOW'!$L51","v":0},null,null,{"$f":"'4. CASHFLOW'!$M51","v":0},null,null,{"$f":"'4. CASHFLOW'!$N51","v":0},null,null,0,0,{"$f":"M51-N51","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B52","v":"Total Insurance"},null,{"$f":"SUM(D49:D51)","v":0},{"$f":"SUM(E49:E51)","v":0},null,{"$f":"SUM(G49:G51)","v":0},{"$f":"SUM(H49:H51)","v":0},null,{"$f":"SUM(J49:J51)","v":0},{"$f":"SUM(K49:K51)","v":0},null,{"$f":"SUM(M49:M51)","v":0},{"$f":"SUM(N49:N51)","v":0},{"$f":"SUM(O49:O51)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B54","v":"Telephone Charges"},null,{"$f":"'4. CASHFLOW'!$L54","v":0},null,null,{"$f":"'4. CASHFLOW'!$M54","v":0},null,null,{"$f":"'4. CASHFLOW'!$N54","v":0},null,null,{"$f":"D53+G53+J53","v":0},0,{"$f":"M53-N53","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B55","v":"Postage "},null,{"$f":"'4. CASHFLOW'!$L55","v":0},null,null,{"$f":"'4. CASHFLOW'!$M55","v":0},null,null,{"$f":"'4. CASHFLOW'!$N55","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B56","v":"Printing & Stationery"},null,{"$f":"'4. CASHFLOW'!$L56","v":0},null,null,{"$f":"'4. CASHFLOW'!$M56","v":0},null,null,{"$f":"'4. CASHFLOW'!$N56","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B57","v":"Membership Fees"},null,{"$f":"'4. CASHFLOW'!$L57","v":0},null,null,{"$f":"'4. CASHFLOW'!$M57","v":0},null,null,{"$f":"'4. CASHFLOW'!$N57","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B58","v":"Bank Charges"},null,{"$f":"'4. CASHFLOW'!$L58","v":0},null,null,{"$f":"'4. CASHFLOW'!$M58","v":0},null,null,{"$f":"'4. CASHFLOW'!$N58","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B59","v":"Professional Fees"},null,{"$f":"'4. CASHFLOW'!$L59","v":0},null,null,{"$f":"'4. CASHFLOW'!$M59","v":0},null,null,{"$f":"'4. CASHFLOW'!$N59","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B60","v":"Other Administration Costs"},null,{"$f":"'4. CASHFLOW'!$L60","v":0},null,null,{"$f":"'4. CASHFLOW'!$M60","v":0},null,null,{"$f":"'4. CASHFLOW'!$N60","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B61","v":"Subscriptions"},null,{"$f":"'4. CASHFLOW'!$L61","v":0},null,null,{"$f":"'4. CASHFLOW'!$M61","v":0},null,null,{"$f":"'4. CASHFLOW'!$N61","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B62","v":"Loan Repayments"},null,{"$f":"'4. CASHFLOW'!$L62","v":0},null,null,{"$f":"'4. CASHFLOW'!$M62","v":0},null,null,{"$f":"'4. CASHFLOW'!$N62","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B63","v":"HP Payments"},null,{"$f":"'4. CASHFLOW'!$L63","v":0},null,null,{"$f":"'4. CASHFLOW'!$M63","v":0},null,null,{"$f":"'4. CASHFLOW'!$N63","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B64","v":"Office Equipment"},null,{"$f":"'4. CASHFLOW'!$L64","v":0},null,null,{"$f":"'4. CASHFLOW'!$M64","v":0},null,null,{"$f":"'4. CASHFLOW'!$N64","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B65","v":"Other"},null,{"$f":"'4. CASHFLOW'!$L65","v":0},null,null,{"$f":"'4. CASHFLOW'!$M65","v":0},null,null,{"$f":"'4. CASHFLOW'!$N65","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B66","v":"Other"},null,{"$f":"'4. CASHFLOW'!$L66","v":0},null,null,{"$f":"'4. CASHFLOW'!$M66","v":0},null,null,{"$f":"'4. CASHFLOW'!$N66","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B67","v":"Total Administration"},null,{"$f":"SUM(D53:D65)","v":0},{"$f":"SUM(E53:E65)","v":0},null,{"$f":"SUM(G53:G65)","v":0},{"$f":"SUM(H53:H65)","v":0},null,{"$f":"SUM(J53:J65)","v":0},{"$f":"SUM(K53:K65)","v":0},null,{"$f":"SUM(M53:M65)","v":0},{"$f":"SUM(N53:N65)","v":0},{"$f":"SUM(O53:O65)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B68","v":"Consumables"},null,{"$f":"'4. CASHFLOW'!$L68","v":0},null,null,{"$f":"'4. CASHFLOW'!$M68","v":0},null,null,{"$f":"'4. CASHFLOW'!$N68","v":0},null,null,{"$f":"D67+G67+J67","v":0},0,{"$f":"M67-N67","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B69","v":"Visits & Trips out "},null,{"$f":"'4. CASHFLOW'!$L69","v":0},null,null,{"$f":"'4. CASHFLOW'!$M69","v":0},null,null,{"$f":"'4. CASHFLOW'!$N69","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B70","v":"Catering"},null,{"$f":"'4. CASHFLOW'!$L70","v":0},null,null,{"$f":"'4. CASHFLOW'!$M70","v":0},null,null,{"$f":"'4. CASHFLOW'!$N70","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B71","v":"Misc / Sundries"},null,{"$f":"'4. CASHFLOW'!$L71","v":0},null,null,{"$f":"'4. CASHFLOW'!$M71","v":0},null,null,{"$f":"'4. CASHFLOW'!$N71","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B72","v":"Repairs & renewals"},null,{"$f":"'4. CASHFLOW'!$L72","v":0},null,null,{"$f":"'4. CASHFLOW'!$M72","v":0},null,null,{"$f":"'4. CASHFLOW'!$N72","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B73","v":"Other"},null,{"$f":"'4. CASHFLOW'!$L73","v":0},null,null,{"$f":"'4. CASHFLOW'!$M73","v":0},null,null,{"$f":"'4. CASHFLOW'!$N73","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B74","v":"Total Activity & Material Costs"},null,{"$f":"SUM(D67:D72)","v":0},{"$f":"SUM(E67:E72)","v":0},null,{"$f":"SUM(G67:G72)","v":0},{"$f":"SUM(H67:H72)","v":0},null,{"$f":"SUM(J67:J72)","v":0},{"$f":"SUM(K67:K72)","v":0},null,{"$f":"SUM(M67:M72)","v":0},{"$f":"SUM(N67:N72)","v":0},{"$f":"SUM(O67:O72)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B75","v":"Volunteer Subsistence"},null,{"$f":"'4. CASHFLOW'!$L75","v":0},null,null,{"$f":"'4. CASHFLOW'!$M75","v":0},null,null,{"$f":"'4. CASHFLOW'!$N75","v":0},null,null,{"$f":"D74+G74+J74","v":0},{"$f":"E74+H74+K74","v":0},{"$f":"M74-N74","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B76","v":"Volunteer Travel"},null,{"$f":"'4. CASHFLOW'!$L76","v":0},null,null,{"$f":"'4. CASHFLOW'!$M76","v":0},null,null,{"$f":"'4. CASHFLOW'!$N76","v":0},null,null,{"$f":"D75+G75+J75","v":0},{"$f":"E75+H75+K75","v":0},{"$f":"M75-N75","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B77","v":" Total Volunteer Costs"},null,{"$f":"SUM(D74:D75)","v":0},{"$f":"SUM(E74:E75)","v":0},null,{"$f":"SUM(G74:G75)","v":0},{"$f":"SUM(H74:H75)","v":0},null,{"$f":"SUM(J74:J75)","v":0},{"$f":"SUM(K74:K75)","v":0},null,{"$f":"SUM(M74:M75)","v":0},{"$f":"SUM(N74:N75)","v":0},{"$f":"SUM(O74:O75)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B78","v":"Advertising / Promotions"},null,{"$f":"'4. CASHFLOW'!$L78","v":0},null,null,{"$f":"'4. CASHFLOW'!$M78","v":0},null,null,{"$f":"'4. CASHFLOW'!$N78","v":0},null,null,{"$f":"D77+G77+J77","v":0},{"$f":"E77+H77+K77","v":0},{"$f":"M77-N77","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B79","v":"Market Research"},null,{"$f":"'4. CASHFLOW'!$L79","v":0},null,null,{"$f":"'4. CASHFLOW'!$M79","v":0},null,null,{"$f":"'4. CASHFLOW'!$N79","v":0},null,null,{"$f":"D78+G78+J78","v":0},{"$f":"E78+H78+K78","v":0},{"$f":"M78-N78","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B80","v":"Total Advertising"},null,{"$f":"SUM(D77:D78)","v":0},{"$f":"SUM(E77:E78)","v":0},null,{"$f":"SUM(G77:G78)","v":0},{"$f":"SUM(H77:H78)","v":0},null,{"$f":"SUM(J77:J78)","v":0},{"$f":"SUM(K77:K78)","v":0},null,{"$f":"SUM(M77:M78)","v":0},{"$f":"SUM(N77:N78)","v":0},{"$f":"SUM(O77:O78)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B81","v":"Vehicle Tax"},null,{"$f":"'4. CASHFLOW'!$L81","v":0},null,null,{"$f":"'4. CASHFLOW'!$M81","v":0},null,null,{"$f":"'4. CASHFLOW'!$N81","v":0},null,null,{"$f":"D80+G80+J80","v":0},0,{"$f":"M80-N80","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B82","v":"Insurance"},null,{"$f":"'4. CASHFLOW'!$L82","v":0},null,null,{"$f":"'4. CASHFLOW'!$M82","v":0},null,null,{"$f":"'4. CASHFLOW'!$N82","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B83","v":"Petrol / Oil"},null,{"$f":"'4. CASHFLOW'!$L83","v":0},null,null,{"$f":"'4. CASHFLOW'!$M83","v":0},null,null,{"$f":"'4. CASHFLOW'!$N83","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B84","v":"Vehicle Maintenance / MOT"},null,{"$f":"'4. CASHFLOW'!$L84","v":0},null,null,{"$f":"'4. CASHFLOW'!$M84","v":0},null,null,{"$f":"'4. CASHFLOW'!$N84","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B85","v":"Mileage Costs Paid"},null,{"$f":"'4. CASHFLOW'!$L85","v":0},null,null,{"$f":"'4. CASHFLOW'!$M85","v":0},null,null,{"$f":"'4. CASHFLOW'!$N85","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B86","v":"Other Travel costs"},null,{"$f":"'4. CASHFLOW'!$L86","v":0},null,null,{"$f":"'4. CASHFLOW'!$M86","v":0},null,null,{"$f":"'4. CASHFLOW'!$N86","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B87","v":"Other"},null,{"$f":"'4. CASHFLOW'!$L87","v":0},null,null,{"$f":"'4. CASHFLOW'!$M87","v":0},null,null,{"$f":"'4. CASHFLOW'!$N87","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B88","v":"Total Transport"},null,{"$f":"SUM(D80:D86)","v":0},{"$f":"SUM(E80:E86)","v":0},null,{"$f":"SUM(G80:G86)","v":0},{"$f":"SUM(H80:H86)","v":0},null,{"$f":"SUM(J80:J86)","v":0},{"$f":"SUM(K80:K86)","v":0},null,{"$f":"SUM(M80:M86)","v":0},{"$f":"SUM(N80:N86)","v":0},{"$f":"SUM(O80:O86)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B89","v":"Quality Assurance"},null,{"$f":"'4. CASHFLOW'!$L89","v":0},null,null,{"$f":"'4. CASHFLOW'!$M89","v":0},null,null,{"$f":"'4. CASHFLOW'!$N89","v":0},null,null,{"$f":"D88+G88+J88","v":0},0,{"$f":"M88-N88","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B90","v":"I"},null,{"$f":"'4. CASHFLOW'!$L90","v":0},null,null,{"$f":"'4. CASHFLOW'!$M90","v":0},null,null,{"$f":"'4. CASHFLOW'!$N90","v":0},null,null,0,0,{"$f":"M89-N89","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B91","v":"ii"},null,{"$f":"'4. CASHFLOW'!$L91","v":0},null,null,{"$f":"'4. CASHFLOW'!$M91","v":0},null,null,{"$f":"'4. CASHFLOW'!$N91","v":0},null,null,0,0,{"$f":"M90-N90","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B92","v":"Total Quality Assurance"},null,{"$f":"SUM(D88:D90)","v":0},{"$f":"SUM(E88:E90)","v":0},null,{"$f":"SUM(G88:G90)","v":0},{"$f":"SUM(H88:H90)","v":0},null,{"$f":"SUM(J88:J90)","v":0},{"$f":"SUM(K88:K90)","v":0},null,{"$f":"SUM(M88:M90)","v":0},{"$f":"SUM(N88:N90)","v":0},{"$f":"SUM(O88:O90)","v":0},"OK"]
[null,"TOTAL REVENUE EXPENDITURE",null,{"$f":"SUM(D91,D87,D79,D76,D73,D66,D52,D48,D38)","v":0},{"$f":"SUM(E91,E87,E79,E76,E73,E66,E52,E48,E38)","v":0},null,{"$f":"SUM(G91,G87,G79,G76,G73,G66,G52,G48,G38)","v":0},{"$f":"SUM(H91,H87,H79,H76,H73,H66,H52,H48,H38)","v":0},null,{"$f":"SUM(J91,J87,J79,J76,J73,J66,J52,J48,J38)","v":0},{"$f":"SUM(K91,K87,K79,K76,K73,K66,K52,K48,K38)","v":0},null,{"$f":"SUM(M91,M87,M79,M76,M73,M66,M52,M48,M38)","v":0},{"$f":"SUM(N91,N87,N79,N76,N73,N66,N52,N48,N38)","v":0},{"$f":"SUM(O91,O87,O79,O76,O73,O66,O52,O48,O38)","v":0},"OK"]
[]
[null,"Total Income",null,{"$f":"D28","v":0},{"$f":"E28","v":0},null,{"$f":"G28","v":0},{"$f":"H28","v":0},null,{"$f":"J28","v":0},{"$f":"K28","v":0},null,{"$f":"M28","v":0},{"$f":"N28","v":0},{"$f":"O28","v":0},{"$f":"IF(O94=0,\"OK\",IF(O94>0,\"Credit\",IF(O94<0,\"Defecit\")))","v":"OK"}]
[null,"Total Expenditure",null,{"$f":"D92","v":0},{"$f":"E92","v":0},null,{"$f":"G92","v":0},{"$f":"H92","v":0},null,{"$f":"J92","v":0},{"$f":"K92","v":0},null,{"$f":"M92","v":0},{"$f":"N92","v":0},{"$f":"O92","v":0},{"$f":"IF(O95=0,\"OK\",IF(O95>0,\"Underspent\",IF(O95<0,\"Overspent\")))","v":"OK"}]
[null,"Closing balance",null,{"$f":"D94-D95","v":0},{"$f":"E94-E95","v":0},null,{"$f":"G94-G95","v":0},{"$f":"H94-H95","v":0},null,{"$f":"J94-J95","v":0},{"$f":"K94-K95","v":0},null,{"$f":"M94-M95","v":0},{"$f":"N94-N95","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(N94<M94,\"WARNING YOUR INCOME IS LESS THAN BUDGETED\",\"YOUR INCOME IS OK\")","v":"YOUR INCOME IS OK"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(N95>M95,\"WARNING YOUR EXPENDITURE IS MORE THAN YOUR BUDGET\",\"YOUR EXPENDITURE IS OK\")","v":"YOUR EXPENDITURE IS OK"}]

{"sheet":"8. Q4","index":7,"n_rows":100,"n_cols":16,"rows_kept":100,"cut":false,"hidden":false,"merged":[[2,4,2,6],[2,7,2,9],[2,11,4,15],[4,3,4,10],[99,9,99,15],[9,14,10,14],[12,9,12,14],[97,9,97,15],[4,0,4,1],[9,12,9,13],[9,1,10,1],[9,3,9,4],[9,6,9,7],[9,9,9,10],[6,3,6,14]]}
[]
[]
[null,{"$f":"IF(H3=0, \"Please insert date completed\", \"\")","v":"Please insert date completed"},null,null,"Date completed",null,null,{"$f":"'4. CASHFLOW'!H3","v":"00:00:00"},null,null,null,"Actual Expenditure"]
[]
[null,null,null,{"$f":"'3. Staff Salaries'!C3","v":"Setting Name: "}]
[]
[null,null,null,"The figures in the blue boxes are your budgets which are brought in from the cashflow forecast. Only complete the white boxes below which apply to your setting, these are your actuals for each month. The column at the end will give you an indication of how you are performing against your budget."]
[]
[]
[null,{"$f":"'4. CASHFLOW'!B9","v":0},null,"JANUARY",null,null,"FEBRUARY",null,null,"MARCH",null,null,"TOTAL",null,"Variance"]
[null,null,null,"Budget","Actual",null,"Budget","Actual",null,"Budget","Actual",null,"Budget","Actual"]
[]
[null,"Income",null,null,null,null,null,null,null,"Quarterly Return Q4"]
[]
[null,{"$f":"'4. CASHFLOW'!B15","v":"Early Education Entitlement"},null,{"$f":"'4. CASHFLOW'!$P15","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q15","v":0},null,null,{"$f":"'4. CASHFLOW'!$R15","v":0},null,null,{"$f":"D15+G15+J15","v":0},{"$f":"E15+H15+K15","v":0},{"$f":"N15-M15","v":0},{"$f":"IF(O15=0,\"OK\",IF(O15>0,\"Credit\",IF(O15<0,\"Defecit\")))","v":"OK"}]
[null,{"$f":"'4. CASHFLOW'!B16","v":"Fees From parents"},null,{"$f":"'4. CASHFLOW'!$P16","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q16","v":0},null,null,{"$f":"'4. CASHFLOW'!$R16","v":0},null,null,{"$f":"D16+G16+J16","v":0},0,{"$f":"N16-M16","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B17","v":"Bank Loans"},null,{"$f":"'4. CASHFLOW'!$P17","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q17","v":0},null,null,{"$f":"'4. CASHFLOW'!$R17","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B18","v":"Local Authority Grants"},null,{"$f":"'4. CASHFLOW'!$P18","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q18","v":0},null,null,{"$f":"'4. CASHFLOW'!$R18","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B19","v":"Early Years Partnership Grants"},null,{"$f":"'4. CASHFLOW'!$P19","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q19","v":0},null,null,{"$f":"'4. CASHFLOW'!$R19","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B20","v":"Own funds (Reserves)"},null,{"$f":"'4. CASHFLOW'!$P20","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q20","v":0},null,null,{"$f":"'4. CASHFLOW'!$R20","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B21","v":"Asset Disposal"},null,{"$f":"'4. CASHFLOW'!$P21","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q21","v":0},null,null,{"$f":"'4. CASHFLOW'!$R21","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B22","v":"Room Lettings"},null,{"$f":"'4. CASHFLOW'!$P22","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q22","v":0},null,null,{"$f":"'4. CASHFLOW'!$R22","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B23","v":"Fund Raising"},null,{"$f":"'4. CASHFLOW'!$P23","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q23","v":0},null,null,{"$f":"'4. CASHFLOW'!$R23","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B24","v":"Donations"},null,{"$f":"'4. CASHFLOW'!$P24","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q24","v":0},null,null,{"$f":"'4. CASHFLOW'!$R24","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B25","v":"Bank interest"},null,{"$f":"'4. CASHFLOW'!$P25","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q25","v":0},null,null,{"$f":"'4. CASHFLOW'!$R25","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B26","v":0},null,{"$f":"'4. CASHFLOW'!$P26","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q26","v":0},null,null,{"$f":"'4. CASHFLOW'!$R26","v":0},null,null,0,0,0,"OK"]
[]
[null,"TOTAL INCOME ",null,{"$f":"SUM(D15:D27)","v":0},{"$f":"SUM(E15:E27)","v":0},null,{"$f":"SUM(G15:G27)","v":0},{"$f":"SUM(H15:H27)","v":0},null,{"$f":"SUM(J15:J27)","v":0},{"$f":"SUM(K15:K27)","v":0},null,{"$f":"SUM(M15:M27)","v":0},{"$f":"SUM(N15:N27)","v":0},{"$f":"SUM(O15:O27)","v":0},{"$f":"IF(O28=0,\"OK\",IF(O28>0,\"Credit\",IF(O28<0,\"Defecit\")))","v":"OK"}]
[]
[null,"Expenditure"]
[]
[null,{"$f":"'4. CASHFLOW'!B32","v":"Wages & Salaries"},null,{"$f":"'4. CASHFLOW'!$P32","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q32","v":0},null,null,{"$f":"'4. CASHFLOW'!$R32","v":0},null,null,{"$f":"D32+G32+J32","v":0},0,{"$f":"M32-N32","v":0},{"$f":"IF(O32=0,\"OK\",IF(O32>0,\"Underspent\",IF(O32<0,\"Overspent\")))","v":"OK"}]
[null,{"$f":"'4. CASHFLOW'!B33","v":"Holiday Cover"},null,{"$f":"'4. CASHFLOW'!$P33","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q33","v":0},null,null,{"$f":"'4. CASHFLOW'!$R33","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B34","v":"Overtime"},null,{"$f":"'4. CASHFLOW'!$P34","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q34","v":0},null,null,{"$f":"'4. CASHFLOW'!$R34","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B35","v":"Staff  Training"},null,{"$f":"'4. CASHFLOW'!$P35","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q35","v":0},null,null,{"$f":"'4. CASHFLOW'!$R35","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B36","v":"Other On-costs"},null,{"$f":"'4. CASHFLOW'!$P36","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q36","v":0},null,null,{"$f":"'4. CASHFLOW'!$R36","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B37","v":"Other "},null,{"$f":"'4. CASHFLOW'!$P37","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q37","v":0},null,null,{"$f":"'4. CASHFLOW'!$R37","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B38","v":"Total Staff Costs"},null,{"$f":"SUM(D32:D37)","v":0},{"$f":"SUM(E32:E37)","v":0},null,{"$f":"SUM(G32:G37)","v":0},{"$f":"SUM(H32:H37)","v":0},null,{"$f":"SUM(J32:J37)","v":0},{"$f":"SUM(K32:K37)","v":0},null,{"$f":"SUM(M32:M37)","v":0},{"$f":"SUM(N32:N37)","v":0},{"$f":"SUM(O32:O37)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B39","v":"Rent"},null,{"$f":"'4. CASHFLOW'!$P39","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q39","v":0},null,null,{"$f":"'4. CASHFLOW'!$R39","v":0},null,null,{"$f":"D39+G39+J39","v":0},0,{"$f":"M39-N39","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B40","v":"Day to Day Maintenance"},null,{"$f":"'4. CASHFLOW'!$P40","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q40","v":0},null,null,{"$f":"'4. CASHFLOW'!$R40","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B41","v":"Electricity"},null,{"$f":"'4. CASHFLOW'!$P41","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q41","v":0},null,null,{"$f":"'4. CASHFLOW'!$R41","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B42","v":"Gas"},null,{"$f":"'4. CASHFLOW'!$P42","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q42","v":0},null,null,{"$f":"'4. CASHFLOW'!$R42","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B43","v":"Business Rates"},null,{"$f":"'4. CASHFLOW'!$P43","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q43","v":0},null,null,{"$f":"'4. CASHFLOW'!$R43","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B44","v":"Water"},null,{"$f":"'4. CASHFLOW'!$P44","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q44","v":0},null,null,{"$f":"'4. CASHFLOW'!$R44","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B45","v":"Cleaning"},null,{"$f":"'4. CASHFLOW'!$P45","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q45","v":0},null,null,{"$f":"'4. CASHFLOW'!$R45","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B46","v":"Other"},null,{"$f":"'4. CASHFLOW'!$P46","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q46","v":0},null,null,{"$f":"'4. CASHFLOW'!$R46","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B47","v":"Other"},null,{"$f":"'4. CASHFLOW'!$P47","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q47","v":0},null,null,{"$f":"'4. CASHFLOW'!$R47","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B48","v":"Total Premises"},null,{"$f":"SUM(D39:D47)","v":0},{"$f":"SUM(E39:E47)","v":0},null,{"$f":"SUM(G39:G47)","v":0},{"$f":"SUM(H39:H47)","v":0},null,{"$f":"SUM(J39:J47)","v":0},{"$f":"SUM(K39:K47)","v":0},null,{"$f":"SUM(M39:M47)","v":0},{"$f":"SUM(N39:N47)","v":0},{"$f":"SUM(O39:O47)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B49","v":"Building Insurance"},null,{"$f":"'4. CASHFLOW'!$P49","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q49","v":0},null,null,{"$f":"'4. CASHFLOW'!$R49","v":0},null,null,{"$f":"D49+G49+J49","v":0},0,{"$f":"M49-N49","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B50","v":"Contents Insurance"},null,{"$f":"'4. CASHFLOW'!$P50","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q50","v":0},null,null,{"$f":"'4. CASHFLOW'!$R50","v":0},null,null,0,0,{"$f":"M50-N50","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B51","v":"Employment Insurance"},null,{"$f":"'4. CASHFLOW'!$P51","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q51","v":0},null,null,{"$f":"'4. CASHFLOW'!$R51","v":0},null,null,0,0,{"$f":"M51-N51","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B52","v":"Total Insurance"},null,{"$f":"SUM(D49:D51)","v":0},{"$f":"SUM(E49:E51)","v":0},null,{"$f":"SUM(G49:G51)","v":0},{"$f":"SUM(H49:H51)","v":0},null,{"$f":"SUM(J49:J51)","v":0},{"$f":"SUM(K49:K51)","v":0},null,{"$f":"SUM(M49:M51)","v":0},{"$f":"SUM(N49:N51)","v":0},{"$f":"SUM(O49:O51)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B54","v":"Telephone Charges"},null,{"$f":"'4. CASHFLOW'!$P54","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q54","v":0},null,null,{"$f":"'4. CASHFLOW'!$R54","v":0},null,null,{"$f":"D53+G53+J53","v":0},0,{"$f":"M53-N53","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B55","v":"Postage "},null,{"$f":"'4. CASHFLOW'!$P55","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q55","v":0},null,null,{"$f":"'4. CASHFLOW'!$R55","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B56","v":"Printing & Stationery"},null,{"$f":"'4. CASHFLOW'!$P56","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q56","v":0},null,null,{"$f":"'4. CASHFLOW'!$R56","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B57","v":"Membership Fees"},null,{"$f":"'4. CASHFLOW'!$P57","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q57","v":0},null,null,{"$f":"'4. CASHFLOW'!$R57","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B58","v":"Bank Charges"},null,{"$f":"'4. CASHFLOW'!$P58","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q58","v":0},null,null,{"$f":"'4. CASHFLOW'!$R58","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B59","v":"Professional Fees"},null,{"$f":"'4. CASHFLOW'!$P59","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q59","v":0},null,null,{"$f":"'4. CASHFLOW'!$R59","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B60","v":"Other Administration Costs"},null,{"$f":"'4. CASHFLOW'!$P60","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q60","v":0},null,null,{"$f":"'4. CASHFLOW'!$R60","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B61","v":"Subscriptions"},null,{"$f":"'4. CASHFLOW'!$P61","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q61","v":0},null,null,{"$f":"'4. CASHFLOW'!$R61","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B62","v":"Loan Repayments"},null,{"$f":"'4. CASHFLOW'!$P62","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q62","v":0},null,null,{"$f":"'4. CASHFLOW'!$R62","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B63","v":"HP Payments"},null,{"$f":"'4. CASHFLOW'!$P63","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q63","v":0},null,null,{"$f":"'4. CASHFLOW'!$R63","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B64","v":"Office Equipment"},null,{"$f":"'4. CASHFLOW'!$P64","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q64","v":0},null,null,{"$f":"'4. CASHFLOW'!$R64","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B65","v":"Other"},null,{"$f":"'4. CASHFLOW'!$P65","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q65","v":0},null,null,{"$f":"'4. CASHFLOW'!$R65","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B66","v":"Other"},null,{"$f":"'4. CASHFLOW'!$P66","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q66","v":0},null,null,{"$f":"'4. CASHFLOW'!$R66","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B67","v":"Total Administration"},null,{"$f":"SUM(D53:D65)","v":0},{"$f":"SUM(E53:E65)","v":0},null,{"$f":"SUM(G53:G65)","v":0},{"$f":"SUM(H53:H65)","v":0},null,{"$f":"SUM(J53:J65)","v":0},{"$f":"SUM(K53:K65)","v":0},null,{"$f":"SUM(M53:M65)","v":0},{"$f":"SUM(N53:N65)","v":0},{"$f":"SUM(O53:O65)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B68","v":"Consumables"},null,{"$f":"'4. CASHFLOW'!$P68","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q68","v":0},null,null,{"$f":"'4. CASHFLOW'!$R68","v":0},null,null,{"$f":"D67+G67+J67","v":0},0,{"$f":"M67-N67","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B69","v":"Visits & Trips out "},null,{"$f":"'4. CASHFLOW'!$P69","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q69","v":0},null,null,{"$f":"'4. CASHFLOW'!$R69","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B70","v":"Catering"},null,{"$f":"'4. CASHFLOW'!$P70","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q70","v":0},null,null,{"$f":"'4. CASHFLOW'!$R70","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B71","v":"Misc / Sundries"},null,{"$f":"'4. CASHFLOW'!$P71","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q71","v":0},null,null,{"$f":"'4. CASHFLOW'!$R71","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B72","v":"Repairs & renewals"},null,{"$f":"'4. CASHFLOW'!$P72","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q72","v":0},null,null,{"$f":"'4. CASHFLOW'!$R72","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B73","v":"Other"},null,{"$f":"'4. CASHFLOW'!$P73","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q73","v":0},null,null,{"$f":"'4. CASHFLOW'!$R73","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B74","v":"Total Activity & Material Costs"},null,{"$f":"SUM(D67:D72)","v":0},{"$f":"SUM(E67:E72)","v":0},null,{"$f":"SUM(G67:G72)","v":0},{"$f":"SUM(H67:H72)","v":0},null,{"$f":"SUM(J67:J72)","v":0},{"$f":"SUM(K67:K72)","v":0},null,{"$f":"SUM(M67:M72)","v":0},{"$f":"SUM(N67:N72)","v":0},{"$f":"SUM(O67:O72)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B75","v":"Volunteer Subsistence"},null,{"$f":"'4. CASHFLOW'!$P75","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q75","v":0},null,null,{"$f":"'4. CASHFLOW'!$R75","v":0},null,null,{"$f":"D74+G74+J74","v":0},{"$f":"E74+H74+K74","v":0},{"$f":"M74-N74","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B76","v":"Volunteer Travel"},null,{"$f":"'4. CASHFLOW'!$P76","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q76","v":0},null,null,{"$f":"'4. CASHFLOW'!$R76","v":0},null,null,{"$f":"D75+G75+J75","v":0},{"$f":"E75+H75+K75","v":0},{"$f":"M75-N75","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B77","v":" Total Volunteer Costs"},null,{"$f":"SUM(D74:D75)","v":0},{"$f":"SUM(E74:E75)","v":0},null,{"$f":"SUM(G74:G75)","v":0},{"$f":"SUM(H74:H75)","v":0},null,{"$f":"SUM(J74:J75)","v":0},{"$f":"SUM(K74:K75)","v":0},null,{"$f":"SUM(M74:M75)","v":0},{"$f":"SUM(N74:N75)","v":0},{"$f":"SUM(O74:O75)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B78","v":"Advertising / Promotions"},null,{"$f":"'4. CASHFLOW'!$P78","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q78","v":0},null,null,{"$f":"'4. CASHFLOW'!$R78","v":0},null,null,{"$f":"D77+G77+J77","v":0},{"$f":"E77+H77+K77","v":0},{"$f":"M77-N77","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B79","v":"Market Research"},null,{"$f":"'4. CASHFLOW'!$P79","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q79","v":0},null,null,{"$f":"'4. CASHFLOW'!$R79","v":0},null,null,{"$f":"D78+G78+J78","v":0},{"$f":"E78+H78+K78","v":0},{"$f":"M78-N78","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B80","v":"Total Advertising"},null,{"$f":"SUM(D77:D78)","v":0},{"$f":"SUM(E77:E78)","v":0},null,{"$f":"SUM(G77:G78)","v":0},{"$f":"SUM(H77:H78)","v":0},null,{"$f":"SUM(J77:J78)","v":0},{"$f":"SUM(K77:K78)","v":0},null,{"$f":"SUM(M77:M78)","v":0},{"$f":"SUM(N77:N78)","v":0},{"$f":"SUM(O77:O78)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B81","v":"Vehicle Tax"},null,{"$f":"'4. CASHFLOW'!$P81","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q81","v":0},null,null,{"$f":"'4. CASHFLOW'!$R81","v":0},null,null,{"$f":"D80+G80+J80","v":0},0,{"$f":"M80-N80","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B82","v":"Insurance"},null,{"$f":"'4. CASHFLOW'!$P82","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q82","v":0},null,null,{"$f":"'4. CASHFLOW'!$R82","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B83","v":"Petrol / Oil"},null,{"$f":"'4. CASHFLOW'!$P83","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q83","v":0},null,null,{"$f":"'4. CASHFLOW'!$R83","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B84","v":"Vehicle Maintenance / MOT"},null,{"$f":"'4. CASHFLOW'!$P84","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q84","v":0},null,null,{"$f":"'4. CASHFLOW'!$R84","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B85","v":"Mileage Costs Paid"},null,{"$f":"'4. CASHFLOW'!$P85","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q85","v":0},null,null,{"$f":"'4. CASHFLOW'!$R85","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B86","v":"Other Travel costs"},null,{"$f":"'4. CASHFLOW'!$P86","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q86","v":0},null,null,{"$f":"'4. CASHFLOW'!$R86","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B87","v":"Other"},null,{"$f":"'4. CASHFLOW'!$P87","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q87","v":0},null,null,{"$f":"'4. CASHFLOW'!$R87","v":0},null,null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B88","v":"Total Transport"},null,{"$f":"SUM(D80:D86)","v":0},{"$f":"SUM(E80:E86)","v":0},null,{"$f":"SUM(G80:G86)","v":0},{"$f":"SUM(H80:H86)","v":0},null,{"$f":"SUM(J80:J86)","v":0},{"$f":"SUM(K80:K86)","v":0},null,{"$f":"SUM(M80:M86)","v":0},{"$f":"SUM(N80:N86)","v":0},{"$f":"SUM(O80:O86)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B89","v":"Quality Assurance"},null,{"$f":"'4. CASHFLOW'!$P89","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q89","v":0},null,null,{"$f":"'4. CASHFLOW'!$R89","v":0},null,null,{"$f":"D88+G88+J88","v":0},0,{"$f":"M88-N88","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B90","v":"I"},null,{"$f":"'4. CASHFLOW'!$P90","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q90","v":0},null,null,{"$f":"'4. CASHFLOW'!$R90","v":0},null,null,0,0,{"$f":"M89-N89","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B91","v":"ii"},null,{"$f":"'4. CASHFLOW'!$P91","v":0},null,null,{"$f":"'4. CASHFLOW'!$Q91","v":0},null,null,{"$f":"'4. CASHFLOW'!$R91","v":0},null,null,0,0,{"$f":"M90-N90","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B92","v":"Total Quality Assurance"},null,{"$f":"SUM(D88:D90)","v":0},{"$f":"SUM(E88:E90)","v":0},null,{"$f":"SUM(G88:G90)","v":0},{"$f":"SUM(H88:H90)","v":0},null,{"$f":"SUM(J88:J90)","v":0},{"$f":"SUM(K88:K90)","v":0},null,{"$f":"SUM(M88:M90)","v":0},{"$f":"SUM(N88:N90)","v":0},{"$f":"SUM(O88:O90)","v":0},"OK"]
[null,"TOTAL REVENUE EXPENDITURE",null,{"$f":"SUM(D91,D87,D79,D76,D73,D66,D52,D48,D38)","v":0},{"$f":"SUM(E91,E87,E79,E76,E73,E66,E52,E48,E38)","v":0},null,{"$f":"SUM(G91,G87,G79,G76,G73,G66,G52,G48,G38)","v":0},{"$f":"SUM(H91,H87,H79,H76,H73,H66,H52,H48,H38)","v":0},null,{"$f":"SUM(J91,J87,J79,J76,J73,J66,J52,J48,J38)","v":0},{"$f":"SUM(K91,K87,K79,K76,K73,K66,K52,K48,K38)","v":0},null,{"$f":"SUM(M91,M87,M79,M76,M73,M66,M52,M48,M38)","v":0},{"$f":"SUM(N91,N87,N79,N76,N73,N66,N52,N48,N38)","v":0},{"$f":"SUM(O91,O87,O79,O76,O73,O66,O52,O48,O38)","v":0},"OK"]
[]
[null,"Total Income",null,{"$f":"D28","v":0},{"$f":"E28","v":0},null,{"$f":"G28","v":0},{"$f":"H28","v":0},null,{"$f":"J28","v":0},{"$f":"K28","v":0},null,{"$f":"M28","v":0},{"$f":"N28","v":0},{"$f":"O28","v":0},{"$f":"IF(O94=0,\"OK\",IF(O94>0,\"Credit\",IF(O94<0,\"Defecit\")))","v":"OK"}]
[null,"Total Expenditure",null,{"$f":"D92","v":0},{"$f":"E92","v":0},null,{"$f":"G92","v":0},{"$f":"H92","v":0},null,{"$f":"J92","v":0},{"$f":"K92","v":0},null,{"$f":"M92","v":0},{"$f":"N92","v":0},{"$f":"O92","v":0},{"$f":"IF(O95=0,\"OK\",IF(O95>0,\"Underspent\",IF(O95<0,\"Overspent\")))","v":"OK"}]
[null,"Closing balance",null,{"$f":"D94-D95","v":0},{"$f":"E94-E95","v":0},null,{"$f":"G94-G95","v":0},{"$f":"H94-H95","v":0},null,{"$f":"J94-J95","v":0},{"$f":"K94-K95","v":0},null,{"$f":"M94-M95","v":0},{"$f":"N94-N95","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(N94<M94,\"WARNING YOUR INCOME IS LESS THAN BUDGETED\",\"YOUR INCOME IS OK\")","v":"YOUR INCOME IS OK"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(N95>M95,\"WARNING YOUR EXPENDITURE IS MORE THAN YOUR BUDGET\",\"YOUR EXPENDITURE IS OK\")","v":"YOUR EXPENDITURE IS OK"}]

{"sheet":"9. FINANCIAL YEAR END","index":8,"n_rows":100,"n_cols":19,"rows_kept":100,"cut":false,"hidden":false,"merged":[[97,9,97,18],[99,9,99,18],[12,9,12,17],[4,0,4,1],[9,12,9,13],[9,15,9,16],[9,17,10,17],[6,3,6,17],[9,1,10,1],[9,3,9,4],[2,11,4,17],[9,6,9,7],[9,9,9,10],[2,4,2,6],[2,7,2,9],[4,3,4,10]]}
[]
[]
[null,{"$f":"IF(H3=0, \"Please insert date completed\", \"\")","v":"Please insert date completed"},null,null,"Date completed",null,null,{"$f":"'4. CASHFLOW'!H3","v":"00:00:00"},null,null,null,"Actual Expenditure"]
[]
[null,null,null,{"$f":"'3. Staff Salaries'!C3","v":"Setting Name: "}]
[]
[null,null,null,"This spreadsheet is a summary of your 4 quarters. The figures in the blue boxes are your budgets which are brought in from the cashflow forecast. There is nothing to complete on this sheet as the white boxes are brought in from each quarter you have completed. The column at the end will give you an indication of how you are performing against your budget."]
[]
[]
[null,{"$f":"'4. CASHFLOW'!B9","v":0},null,"Q1",null,null,"Q2",null,null,"Q3",null,null,"Q4",null,null,"TOTAL",null,"Variance"]
[null,null,null,"Budget","Actual",null,"Budget","Actual",null,"Budget","Actual",null,"Budget","Actual",null,"Budget","Actual"]
[]
[null,"Income",null,null,null,null,null,null,null,"SUMMARY"]
[]
[null,{"$f":"'4. CASHFLOW'!B15","v":"Early Education Entitlement"},null,{"$f":"'5. Q1'!M15","v":0},{"$f":"'5. Q1'!N15","v":0},null,{"$f":"'6. Q2'!M15","v":0},{"$f":"'6. Q2'!N15","v":0},null,{"$f":"'7. Q3'!M15","v":0},{"$f":"'7. Q3'!N15","v":0},null,{"$f":"'8. Q4'!M15","v":0},{"$f":"'8. Q4'!N15","v":0},null,{"$f":"D15+G15+J15+M15","v":0},{"$f":"E15+H15+K15+N15","v":0},{"$f":"Q15-P15","v":0},{"$f":"IF(R15=0,\"OK\",IF(R15>0,\"Credit\",IF(R15<0,\"Defecit\")))","v":"OK"}]
[null,{"$f":"'4. CASHFLOW'!B16","v":"Fees From parents"},null,{"$f":"'5. Q1'!M16","v":0},{"$f":"'5. Q1'!N16","v":0},null,{"$f":"'6. Q2'!M16","v":0},{"$f":"'6. Q2'!N16","v":0},null,{"$f":"'7. Q3'!M16","v":0},{"$f":"'7. Q3'!N16","v":0},null,{"$f":"'8. Q4'!M16","v":0},{"$f":"'8. Q4'!N16","v":0},null,{"$f":"D16+G16+J16+M16","v":0},0,{"$f":"Q16-P16","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B17","v":"Bank Loans"},null,{"$f":"'5. Q1'!M17","v":0},{"$f":"'5. Q1'!N17","v":0},null,{"$f":"'6. Q2'!M17","v":0},{"$f":"'6. Q2'!N17","v":0},null,{"$f":"'7. Q3'!M17","v":0},{"$f":"'7. Q3'!N17","v":0},null,{"$f":"'8. Q4'!M17","v":0},{"$f":"'8. Q4'!N17","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B18","v":"Local Authority Grants"},null,{"$f":"'5. Q1'!M18","v":0},{"$f":"'5. Q1'!N18","v":0},null,{"$f":"'6. Q2'!M18","v":0},{"$f":"'6. Q2'!N18","v":0},null,{"$f":"'7. Q3'!M18","v":0},{"$f":"'7. Q3'!N18","v":0},null,{"$f":"'8. Q4'!M18","v":0},{"$f":"'8. Q4'!N18","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B19","v":"Early Years Partnership Grants"},null,{"$f":"'5. Q1'!M19","v":0},{"$f":"'5. Q1'!N19","v":0},null,{"$f":"'6. Q2'!M19","v":0},{"$f":"'6. Q2'!N19","v":0},null,{"$f":"'7. Q3'!M19","v":0},{"$f":"'7. Q3'!N19","v":0},null,{"$f":"'8. Q4'!M19","v":0},{"$f":"'8. Q4'!N19","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B20","v":"Own funds (Reserves)"},null,{"$f":"'5. Q1'!M20","v":0},{"$f":"'5. Q1'!N20","v":0},null,{"$f":"'6. Q2'!M20","v":0},{"$f":"'6. Q2'!N20","v":0},null,{"$f":"'7. Q3'!M20","v":0},{"$f":"'7. Q3'!N20","v":0},null,{"$f":"'8. Q4'!M20","v":0},{"$f":"'8. Q4'!N20","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B21","v":"Asset Disposal"},null,{"$f":"'5. Q1'!M21","v":0},{"$f":"'5. Q1'!N21","v":0},null,{"$f":"'6. Q2'!M21","v":0},{"$f":"'6. Q2'!N21","v":0},null,{"$f":"'7. Q3'!M21","v":0},{"$f":"'7. Q3'!N21","v":0},null,{"$f":"'8. Q4'!M21","v":0},{"$f":"'8. Q4'!N21","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B22","v":"Room Lettings"},null,{"$f":"'5. Q1'!M22","v":0},{"$f":"'5. Q1'!N22","v":0},null,{"$f":"'6. Q2'!M22","v":0},{"$f":"'6. Q2'!N22","v":0},null,{"$f":"'7. Q3'!M22","v":0},{"$f":"'7. Q3'!N22","v":0},null,{"$f":"'8. Q4'!M22","v":0},{"$f":"'8. Q4'!N22","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B23","v":"Fund Raising"},null,{"$f":"'5. Q1'!M23","v":0},{"$f":"'5. Q1'!N23","v":0},null,{"$f":"'6. Q2'!M23","v":0},{"$f":"'6. Q2'!N23","v":0},null,{"$f":"'7. Q3'!M23","v":0},{"$f":"'7. Q3'!N23","v":0},null,{"$f":"'8. Q4'!M23","v":0},{"$f":"'8. Q4'!N23","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B24","v":"Donations"},null,{"$f":"'5. Q1'!M24","v":0},{"$f":"'5. Q1'!N24","v":0},null,{"$f":"'6. Q2'!M24","v":0},{"$f":"'6. Q2'!N24","v":0},null,{"$f":"'7. Q3'!M24","v":0},{"$f":"'7. Q3'!N24","v":0},null,{"$f":"'8. Q4'!M24","v":0},{"$f":"'8. Q4'!N24","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B25","v":"Bank interest"},null,{"$f":"'5. Q1'!M25","v":0},{"$f":"'5. Q1'!N25","v":0},null,{"$f":"'6. Q2'!M25","v":0},{"$f":"'6. Q2'!N25","v":0},null,{"$f":"'7. Q3'!M25","v":0},{"$f":"'7. Q3'!N25","v":0},null,{"$f":"'8. Q4'!M25","v":0},{"$f":"'8. Q4'!N25","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B26","v":0},null,{"$f":"'5. Q1'!M26","v":0},{"$f":"'5. Q1'!N26","v":0},null,{"$f":"'6. Q2'!M26","v":0},{"$f":"'6. Q2'!N26","v":0},null,{"$f":"'7. Q3'!M26","v":0},{"$f":"'7. Q3'!N26","v":0},null,{"$f":"'8. Q4'!M26","v":0},{"$f":"'8. Q4'!N26","v":0},null,0,0,0,"OK"]
[]
[null,"TOTAL INCOME ",null,{"$f":"SUM(D15:D27)","v":0},{"$f":"SUM(E15:E27)","v":0},null,{"$f":"SUM(G15:G27)","v":0},{"$f":"SUM(H15:H27)","v":0},null,{"$f":"SUM(J15:J27)","v":0},{"$f":"SUM(K15:K27)","v":0},null,{"$f":"SUM(M15:M27)","v":0},{"$f":"SUM(N15:N27)","v":0},null,{"$f":"SUM(P15:P27)","v":0},{"$f":"SUM(Q15:Q27)","v":0},{"$f":"SUM(R15:R27)","v":0},{"$f":"IF(R28=0,\"OK\",IF(R28>0,\"Credit\",IF(R28<0,\"Defecit\")))","v":"OK"}]
[]
[null,"Expenditure"]
[]
[null,{"$f":"'4. CASHFLOW'!B32","v":"Wages & Salaries"},null,{"$f":"'5. Q1'!M32","v":0},{"$f":"'5. Q1'!N32","v":0},null,{"$f":"'6. Q2'!M32","v":0},{"$f":"'6. Q2'!N32","v":0},null,{"$f":"'7. Q3'!M32","v":0},{"$f":"'7. Q3'!N32","v":0},null,{"$f":"'8. Q4'!M32","v":0},{"$f":"'8. Q4'!N32","v":0},null,{"$f":"D32+G32+J32+M32","v":0},0,{"$f":"P32-Q32","v":0},{"$f":"IF(R32=0,\"OK\",IF(R32>0,\"Underspent\",IF(R32<0,\"Overspent\")))","v":"OK"}]
[null,{"$f":"'4. CASHFLOW'!B33","v":"Holiday Cover"},null,{"$f":"'5. Q1'!M33","v":0},{"$f":"'5. Q1'!N33","v":0},null,{"$f":"'6. Q2'!M33","v":0},{"$f":"'6. Q2'!N33","v":0},null,{"$f":"'7. Q3'!M33","v":0},{"$f":"'7. Q3'!N33","v":0},null,{"$f":"'8. Q4'!M33","v":0},{"$f":"'8. Q4'!N33","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B34","v":"Overtime"},null,{"$f":"'5. Q1'!M34","v":0},{"$f":"'5. Q1'!N34","v":0},null,{"$f":"'6. Q2'!M34","v":0},{"$f":"'6. Q2'!N34","v":0},null,{"$f":"'7. Q3'!M34","v":0},{"$f":"'7. Q3'!N34","v":0},null,{"$f":"'8. Q4'!M34","v":0},{"$f":"'8. Q4'!N34","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B35","v":"Staff  Training"},null,{"$f":"'5. Q1'!M35","v":0},{"$f":"'5. Q1'!N35","v":0},null,{"$f":"'6. Q2'!M35","v":0},{"$f":"'6. Q2'!N35","v":0},null,{"$f":"'7. Q3'!M35","v":0},{"$f":"'7. Q3'!N35","v":0},null,{"$f":"'8. Q4'!M35","v":0},{"$f":"'8. Q4'!N35","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B36","v":"Other On-costs"},null,{"$f":"'5. Q1'!M36","v":0},{"$f":"'5. Q1'!N36","v":0},null,{"$f":"'6. Q2'!M36","v":0},{"$f":"'6. Q2'!N36","v":0},null,{"$f":"'7. Q3'!M36","v":0},{"$f":"'7. Q3'!N36","v":0},null,{"$f":"'8. Q4'!M36","v":0},{"$f":"'8. Q4'!N36","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B37","v":"Other "},null,{"$f":"'5. Q1'!M37","v":0},{"$f":"'5. Q1'!N37","v":0},null,{"$f":"'6. Q2'!M37","v":0},{"$f":"'6. Q2'!N37","v":0},null,{"$f":"'7. Q3'!M37","v":0},{"$f":"'7. Q3'!N37","v":0},null,{"$f":"'8. Q4'!M37","v":0},{"$f":"'8. Q4'!N37","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B38","v":"Total Staff Costs"},null,{"$f":"SUM(D32:D37)","v":0},{"$f":"SUM(E32:E37)","v":0},null,{"$f":"SUM(G32:G37)","v":0},{"$f":"SUM(H32:H37)","v":0},null,{"$f":"SUM(J32:J37)","v":0},{"$f":"SUM(K32:K37)","v":0},null,{"$f":"SUM(M32:M37)","v":0},{"$f":"SUM(N32:N37)","v":0},null,{"$f":"SUM(P32:P37)","v":0},{"$f":"SUM(Q32:Q37)","v":0},{"$f":"SUM(R32:R37)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B39","v":"Rent"},null,{"$f":"'5. Q1'!M39","v":0},{"$f":"'5. Q1'!N39","v":0},null,{"$f":"'6. Q2'!M39","v":0},{"$f":"'6. Q2'!N39","v":0},null,{"$f":"'7. Q3'!M39","v":0},{"$f":"'7. Q3'!N39","v":0},null,{"$f":"'8. Q4'!M39","v":0},{"$f":"'8. Q4'!N39","v":0},null,{"$f":"D39+G39+J39+M39","v":0},0,{"$f":"P39-Q39","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B40","v":"Day to Day Maintenance"},null,{"$f":"'5. Q1'!M40","v":0},{"$f":"'5. Q1'!N40","v":0},null,{"$f":"'6. Q2'!M40","v":0},{"$f":"'6. Q2'!N40","v":0},null,{"$f":"'7. Q3'!M40","v":0},{"$f":"'7. Q3'!N40","v":0},null,{"$f":"'8. Q4'!M40","v":0},{"$f":"'8. Q4'!N40","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B41","v":"Electricity"},null,{"$f":"'5. Q1'!M41","v":0},{"$f":"'5. Q1'!N41","v":0},null,{"$f":"'6. Q2'!M41","v":0},{"$f":"'6. Q2'!N41","v":0},null,{"$f":"'7. Q3'!M41","v":0},{"$f":"'7. Q3'!N41","v":0},null,{"$f":"'8. Q4'!M41","v":0},{"$f":"'8. Q4'!N41","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B42","v":"Gas"},null,{"$f":"'5. Q1'!M42","v":0},{"$f":"'5. Q1'!N42","v":0},null,{"$f":"'6. Q2'!M42","v":0},{"$f":"'6. Q2'!N42","v":0},null,{"$f":"'7. Q3'!M42","v":0},{"$f":"'7. Q3'!N42","v":0},null,{"$f":"'8. Q4'!M42","v":0},{"$f":"'8. Q4'!N42","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B43","v":"Business Rates"},null,{"$f":"'5. Q1'!M43","v":0},{"$f":"'5. Q1'!N43","v":0},null,{"$f":"'6. Q2'!M43","v":0},{"$f":"'6. Q2'!N43","v":0},null,{"$f":"'7. Q3'!M43","v":0},{"$f":"'7. Q3'!N43","v":0},null,{"$f":"'8. Q4'!M43","v":0},{"$f":"'8. Q4'!N43","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B44","v":"Water"},null,{"$f":"'5. Q1'!M44","v":0},{"$f":"'5. Q1'!N44","v":0},null,{"$f":"'6. Q2'!M44","v":0},{"$f":"'6. Q2'!N44","v":0},null,{"$f":"'7. Q3'!M44","v":0},{"$f":"'7. Q3'!N44","v":0},null,{"$f":"'8. Q4'!M44","v":0},{"$f":"'8. Q4'!N44","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B45","v":"Cleaning"},null,{"$f":"'5. Q1'!M45","v":0},{"$f":"'5. Q1'!N45","v":0},null,{"$f":"'6. Q2'!M45","v":0},{"$f":"'6. Q2'!N45","v":0},null,{"$f":"'7. Q3'!M45","v":0},{"$f":"'7. Q3'!N45","v":0},null,{"$f":"'8. Q4'!M45","v":0},{"$f":"'8. Q4'!N45","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B46","v":"Other"},null,{"$f":"'5. Q1'!M46","v":0},{"$f":"'5. Q1'!N46","v":0},null,{"$f":"'6. Q2'!M46","v":0},{"$f":"'6. Q2'!N46","v":0},null,{"$f":"'7. Q3'!M46","v":0},{"$f":"'7. Q3'!N46","v":0},null,{"$f":"'8. Q4'!M46","v":0},{"$f":"'8. Q4'!N46","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B47","v":"Other"},null,{"$f":"'5. Q1'!M47","v":0},{"$f":"'5. Q1'!N47","v":0},null,{"$f":"'6. Q2'!M47","v":0},{"$f":"'6. Q2'!N47","v":0},null,{"$f":"'7. Q3'!M47","v":0},{"$f":"'7. Q3'!N47","v":0},null,{"$f":"'8. Q4'!M47","v":0},{"$f":"'8. Q4'!N47","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B48","v":"Total Premises"},null,{"$f":"SUM(D39:D47)","v":0},{"$f":"SUM(E39:E47)","v":0},null,{"$f":"SUM(G39:G47)","v":0},{"$f":"SUM(H39:H47)","v":0},null,{"$f":"SUM(J39:J47)","v":0},{"$f":"SUM(K39:K47)","v":0},null,{"$f":"SUM(M39:M47)","v":0},{"$f":"SUM(N39:N47)","v":0},null,{"$f":"SUM(P39:P47)","v":0},{"$f":"SUM(Q39:Q47)","v":0},{"$f":"SUM(R39:R47)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B49","v":"Building Insurance"},null,{"$f":"'5. Q1'!M49","v":0},{"$f":"'5. Q1'!N49","v":0},null,{"$f":"'6. Q2'!M49","v":0},{"$f":"'6. Q2'!N49","v":0},null,{"$f":"'7. Q3'!M49","v":0},{"$f":"'7. Q3'!N49","v":0},null,{"$f":"'8. Q4'!M49","v":0},{"$f":"'8. Q4'!N49","v":0},null,{"$f":"D49+G49+J49+M49","v":0},0,{"$f":"P49-Q49","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B50","v":"Contents Insurance"},null,{"$f":"'5. Q1'!M50","v":0},{"$f":"'5. Q1'!N50","v":0},null,{"$f":"'6. Q2'!M50","v":0},{"$f":"'6. Q2'!N50","v":0},null,{"$f":"'7. Q3'!M50","v":0},{"$f":"'7. Q3'!N50","v":0},null,{"$f":"'8. Q4'!M50","v":0},{"$f":"'8. Q4'!N50","v":0},null,0,0,{"$f":"P50-Q50","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B51","v":"Employment Insurance"},null,{"$f":"'5. Q1'!M51","v":0},{"$f":"'5. Q1'!N51","v":0},null,{"$f":"'6. Q2'!M51","v":0},{"$f":"'6. Q2'!N51","v":0},null,{"$f":"'7. Q3'!M51","v":0},{"$f":"'7. Q3'!N51","v":0},null,{"$f":"'8. Q4'!M51","v":0},{"$f":"'8. Q4'!N51","v":0},null,0,0,{"$f":"P51-Q51","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B52","v":"Total Insurance"},null,{"$f":"SUM(D49:D51)","v":0},{"$f":"SUM(E49:E51)","v":0},null,{"$f":"SUM(G49:G51)","v":0},{"$f":"SUM(H49:H51)","v":0},null,{"$f":"SUM(J49:J51)","v":0},{"$f":"SUM(K49:K51)","v":0},null,{"$f":"SUM(M49:M51)","v":0},{"$f":"SUM(N49:N51)","v":0},null,{"$f":"SUM(P49:P51)","v":0},{"$f":"SUM(Q49:Q51)","v":0},{"$f":"SUM(R49:R51)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B54","v":"Telephone Charges"},null,{"$f":"'5. Q1'!M53","v":0},{"$f":"'5. Q1'!N53","v":0},null,{"$f":"'6. Q2'!M53","v":0},{"$f":"'6. Q2'!N53","v":0},null,{"$f":"'7. Q3'!M53","v":0},{"$f":"'7. Q3'!N53","v":0},null,{"$f":"'8. Q4'!M53","v":0},{"$f":"'8. Q4'!N53","v":0},null,{"$f":"D53+G53+J53+M53","v":0},0,{"$f":"P53-Q53","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B55","v":"Postage "},null,{"$f":"'5. Q1'!M54","v":0},{"$f":"'5. Q1'!N54","v":0},null,{"$f":"'6. Q2'!M54","v":0},{"$f":"'6. Q2'!N54","v":0},null,{"$f":"'7. Q3'!M54","v":0},{"$f":"'7. Q3'!N54","v":0},null,{"$f":"'8. Q4'!M54","v":0},{"$f":"'8. Q4'!N54","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B56","v":"Printing & Stationery"},null,{"$f":"'5. Q1'!M55","v":0},{"$f":"'5. Q1'!N55","v":0},null,{"$f":"'6. Q2'!M55","v":0},{"$f":"'6. Q2'!N55","v":0},null,{"$f":"'7. Q3'!M55","v":0},{"$f":"'7. Q3'!N55","v":0},null,{"$f":"'8. Q4'!M55","v":0},{"$f":"'8. Q4'!N55","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B57","v":"Membership Fees"},null,{"$f":"'5. Q1'!M56","v":0},{"$f":"'5. Q1'!N56","v":0},null,{"$f":"'6. Q2'!M56","v":0},{"$f":"'6. Q2'!N56","v":0},null,{"$f":"'7. Q3'!M56","v":0},{"$f":"'7. Q3'!N56","v":0},null,{"$f":"'8. Q4'!M56","v":0},{"$f":"'8. Q4'!N56","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B58","v":"Bank Charges"},null,{"$f":"'5. Q1'!M57","v":0},{"$f":"'5. Q1'!N57","v":0},null,{"$f":"'6. Q2'!M57","v":0},{"$f":"'6. Q2'!N57","v":0},null,{"$f":"'7. Q3'!M57","v":0},{"$f":"'7. Q3'!N57","v":0},null,{"$f":"'8. Q4'!M57","v":0},{"$f":"'8. Q4'!N57","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B59","v":"Professional Fees"},null,{"$f":"'5. Q1'!M58","v":0},{"$f":"'5. Q1'!N58","v":0},null,{"$f":"'6. Q2'!M58","v":0},{"$f":"'6. Q2'!N58","v":0},null,{"$f":"'7. Q3'!M58","v":0},{"$f":"'7. Q3'!N58","v":0},null,{"$f":"'8. Q4'!M58","v":0},{"$f":"'8. Q4'!N58","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B60","v":"Other Administration Costs"},null,{"$f":"'5. Q1'!M59","v":0},{"$f":"'5. Q1'!N59","v":0},null,{"$f":"'6. Q2'!M59","v":0},{"$f":"'6. Q2'!N59","v":0},null,{"$f":"'7. Q3'!M59","v":0},{"$f":"'7. Q3'!N59","v":0},null,{"$f":"'8. Q4'!M59","v":0},{"$f":"'8. Q4'!N59","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B61","v":"Subscriptions"},null,{"$f":"'5. Q1'!M60","v":0},{"$f":"'5. Q1'!N60","v":0},null,{"$f":"'6. Q2'!M60","v":0},{"$f":"'6. Q2'!N60","v":0},null,{"$f":"'7. Q3'!M60","v":0},{"$f":"'7. Q3'!N60","v":0},null,{"$f":"'8. Q4'!M60","v":0},{"$f":"'8. Q4'!N60","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B62","v":"Loan Repayments"},null,{"$f":"'5. Q1'!M61","v":0},{"$f":"'5. Q1'!N61","v":0},null,{"$f":"'6. Q2'!M61","v":0},{"$f":"'6. Q2'!N61","v":0},null,{"$f":"'7. Q3'!M61","v":0},{"$f":"'7. Q3'!N61","v":0},null,{"$f":"'8. Q4'!M61","v":0},{"$f":"'8. Q4'!N61","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B63","v":"HP Payments"},null,{"$f":"'5. Q1'!M62","v":0},{"$f":"'5. Q1'!N62","v":0},null,{"$f":"'6. Q2'!M62","v":0},{"$f":"'6. Q2'!N62","v":0},null,{"$f":"'7. Q3'!M62","v":0},{"$f":"'7. Q3'!N62","v":0},null,{"$f":"'8. Q4'!M62","v":0},{"$f":"'8. Q4'!N62","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B64","v":"Office Equipment"},null,{"$f":"'5. Q1'!M63","v":0},{"$f":"'5. Q1'!N63","v":0},null,{"$f":"'6. Q2'!M63","v":0},{"$f":"'6. Q2'!N63","v":0},null,{"$f":"'7. Q3'!M63","v":0},{"$f":"'7. Q3'!N63","v":0},null,{"$f":"'8. Q4'!M63","v":0},{"$f":"'8. Q4'!N63","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B65","v":"Other"},null,{"$f":"'5. Q1'!M64","v":0},{"$f":"'5. Q1'!N64","v":0},null,{"$f":"'6. Q2'!M64","v":0},{"$f":"'6. Q2'!N64","v":0},null,{"$f":"'7. Q3'!M64","v":0},{"$f":"'7. Q3'!N64","v":0},null,{"$f":"'8. Q4'!M64","v":0},{"$f":"'8. Q4'!N64","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B66","v":"Other"},null,{"$f":"'5. Q1'!M65","v":0},{"$f":"'5. Q1'!N65","v":0},null,{"$f":"'6. Q2'!M65","v":0},{"$f":"'6. Q2'!N65","v":0},null,{"$f":"'7. Q3'!M65","v":0},{"$f":"'7. Q3'!N65","v":0},null,{"$f":"'8. Q4'!M65","v":0},{"$f":"'8. Q4'!N65","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B67","v":"Total Administration"},null,{"$f":"SUM(D53:D65)","v":0},{"$f":"SUM(E53:E65)","v":0},null,{"$f":"SUM(G53:G65)","v":0},{"$f":"SUM(H53:H65)","v":0},null,{"$f":"SUM(J53:J65)","v":0},{"$f":"SUM(K53:K65)","v":0},null,{"$f":"SUM(M53:M65)","v":0},{"$f":"SUM(N53:N65)","v":0},null,{"$f":"SUM(P53:P65)","v":0},{"$f":"SUM(Q53:Q65)","v":0},{"$f":"SUM(R53:R65)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B68","v":"Consumables"},null,{"$f":"'5. Q1'!M67","v":0},{"$f":"'5. Q1'!N67","v":0},null,{"$f":"'6. Q2'!M67","v":0},{"$f":"'6. Q2'!N67","v":0},null,{"$f":"'7. Q3'!M67","v":0},{"$f":"'7. Q3'!N67","v":0},null,{"$f":"'8. Q4'!M67","v":0},{"$f":"'8. Q4'!N67","v":0},null,{"$f":"D67+G67+J67+M67","v":0},0,{"$f":"P67-Q67","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B69","v":"Visits & Trips out "},null,{"$f":"'5. Q1'!M68","v":0},{"$f":"'5. Q1'!N68","v":0},null,{"$f":"'6. Q2'!M68","v":0},{"$f":"'6. Q2'!N68","v":0},null,{"$f":"'7. Q3'!M68","v":0},{"$f":"'7. Q3'!N68","v":0},null,{"$f":"'8. Q4'!M68","v":0},{"$f":"'8. Q4'!N68","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B70","v":"Catering"},null,{"$f":"'5. Q1'!M69","v":0},{"$f":"'5. Q1'!N69","v":0},null,{"$f":"'6. Q2'!M69","v":0},{"$f":"'6. Q2'!N69","v":0},null,{"$f":"'7. Q3'!M69","v":0},{"$f":"'7. Q3'!N69","v":0},null,{"$f":"'8. Q4'!M69","v":0},{"$f":"'8. Q4'!N69","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B71","v":"Misc / Sundries"},null,{"$f":"'5. Q1'!M70","v":0},{"$f":"'5. Q1'!N70","v":0},null,{"$f":"'6. Q2'!M70","v":0},{"$f":"'6. Q2'!N70","v":0},null,{"$f":"'7. Q3'!M70","v":0},{"$f":"'7. Q3'!N70","v":0},null,{"$f":"'8. Q4'!M70","v":0},{"$f":"'8. Q4'!N70","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B72","v":"Repairs & renewals"},null,{"$f":"'5. Q1'!M71","v":0},{"$f":"'5. Q1'!N71","v":0},null,{"$f":"'6. Q2'!M71","v":0},{"$f":"'6. Q2'!N71","v":0},null,{"$f":"'7. Q3'!M71","v":0},{"$f":"'7. Q3'!N71","v":0},null,{"$f":"'8. Q4'!M71","v":0},{"$f":"'8. Q4'!N71","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B73","v":"Other"},null,{"$f":"'5. Q1'!M72","v":0},{"$f":"'5. Q1'!N72","v":0},null,{"$f":"'6. Q2'!M72","v":0},{"$f":"'6. Q2'!N72","v":0},null,{"$f":"'7. Q3'!M72","v":0},{"$f":"'7. Q3'!N72","v":0},null,{"$f":"'8. Q4'!M72","v":0},{"$f":"'8. Q4'!N72","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B74","v":"Total Activity & Material Costs"},null,{"$f":"SUM(D67:D72)","v":0},{"$f":"SUM(E67:E72)","v":0},null,{"$f":"SUM(G67:G72)","v":0},{"$f":"SUM(H67:H72)","v":0},null,{"$f":"SUM(J67:J72)","v":0},{"$f":"SUM(K67:K72)","v":0},null,{"$f":"SUM(M67:M72)","v":0},{"$f":"SUM(N67:N72)","v":0},null,{"$f":"SUM(P67:P72)","v":0},{"$f":"SUM(Q67:Q72)","v":0},{"$f":"SUM(R67:R72)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B75","v":"Volunteer Subsistence"},null,{"$f":"'5. Q1'!M74","v":0},{"$f":"'5. Q1'!N74","v":0},null,{"$f":"'6. Q2'!M74","v":0},{"$f":"'6. Q2'!N74","v":0},null,{"$f":"'7. Q3'!M74","v":0},{"$f":"'7. Q3'!N74","v":0},null,{"$f":"'8. Q4'!M74","v":0},{"$f":"'8. Q4'!N74","v":0},null,{"$f":"D74+G74+J74+M74","v":0},{"$f":"E74+H74+K74+N74","v":0},{"$f":"P74-Q74","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B76","v":"Volunteer Travel"},null,{"$f":"'5. Q1'!M75","v":0},{"$f":"'5. Q1'!N75","v":0},null,{"$f":"'6. Q2'!M75","v":0},{"$f":"'6. Q2'!N75","v":0},null,{"$f":"'7. Q3'!M75","v":0},{"$f":"'7. Q3'!N75","v":0},null,{"$f":"'8. Q4'!M75","v":0},{"$f":"'8. Q4'!N75","v":0},null,{"$f":"D75+G75+J75+M75","v":0},{"$f":"E75+H75+K75+N75","v":0},{"$f":"P75-Q75","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B77","v":" Total Volunteer Costs"},null,{"$f":"SUM(D74:D75)","v":0},{"$f":"SUM(E74:E75)","v":0},null,{"$f":"SUM(G74:G75)","v":0},{"$f":"SUM(H74:H75)","v":0},null,{"$f":"SUM(J74:J75)","v":0},{"$f":"SUM(K74:K75)","v":0},null,{"$f":"SUM(M74:M75)","v":0},{"$f":"SUM(N74:N75)","v":0},null,{"$f":"SUM(P74:P75)","v":0},{"$f":"SUM(Q74:Q75)","v":0},{"$f":"SUM(R74:R75)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B78","v":"Advertising / Promotions"},null,{"$f":"'5. Q1'!M77","v":0},{"$f":"'5. Q1'!N77","v":0},null,{"$f":"'6. Q2'!M77","v":0},{"$f":"'6. Q2'!N77","v":0},null,{"$f":"'7. Q3'!M77","v":0},{"$f":"'7. Q3'!N77","v":0},null,{"$f":"'8. Q4'!M77","v":0},{"$f":"'8. Q4'!N77","v":0},null,{"$f":"D77+G77+J77+M77","v":0},{"$f":"E77+H77+K77+N77","v":0},{"$f":"P77-Q77","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B79","v":"Market Research"},null,{"$f":"'5. Q1'!M78","v":0},{"$f":"'5. Q1'!N78","v":0},null,{"$f":"'6. Q2'!M78","v":0},{"$f":"'6. Q2'!N78","v":0},null,{"$f":"'7. Q3'!M78","v":0},{"$f":"'7. Q3'!N78","v":0},null,{"$f":"'8. Q4'!M78","v":0},{"$f":"'8. Q4'!N78","v":0},null,{"$f":"D78+G78+J78+M78","v":0},{"$f":"E78+H78+K78+N78","v":0},{"$f":"P78-Q78","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B80","v":"Total Advertising"},null,{"$f":"SUM(D77:D78)","v":0},{"$f":"SUM(E77:E78)","v":0},null,{"$f":"SUM(G77:G78)","v":0},{"$f":"SUM(H77:H78)","v":0},null,{"$f":"SUM(J77:J78)","v":0},{"$f":"SUM(K77:K78)","v":0},null,{"$f":"SUM(M77:M78)","v":0},{"$f":"SUM(N77:N78)","v":0},null,{"$f":"SUM(P77:P78)","v":0},{"$f":"SUM(Q77:Q78)","v":0},{"$f":"SUM(R77:R78)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B81","v":"Vehicle Tax"},null,{"$f":"'5. Q1'!M80","v":0},{"$f":"'5. Q1'!N80","v":0},null,{"$f":"'6. Q2'!M80","v":0},{"$f":"'6. Q2'!N80","v":0},null,{"$f":"'7. Q3'!M80","v":0},{"$f":"'7. Q3'!N80","v":0},null,{"$f":"'8. Q4'!M80","v":0},{"$f":"'8. Q4'!N80","v":0},null,{"$f":"D80+G80+J80+M80","v":0},0,{"$f":"P80-Q80","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B82","v":"Insurance"},null,{"$f":"'5. Q1'!M81","v":0},{"$f":"'5. Q1'!N81","v":0},null,{"$f":"'6. Q2'!M81","v":0},{"$f":"'6. Q2'!N81","v":0},null,{"$f":"'7. Q3'!M81","v":0},{"$f":"'7. Q3'!N81","v":0},null,{"$f":"'8. Q4'!M81","v":0},{"$f":"'8. Q4'!N81","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B83","v":"Petrol / Oil"},null,{"$f":"'5. Q1'!M82","v":0},{"$f":"'5. Q1'!N82","v":0},null,{"$f":"'6. Q2'!M82","v":0},{"$f":"'6. Q2'!N82","v":0},null,{"$f":"'7. Q3'!M82","v":0},{"$f":"'7. Q3'!N82","v":0},null,{"$f":"'8. Q4'!M82","v":0},{"$f":"'8. Q4'!N82","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B84","v":"Vehicle Maintenance / MOT"},null,{"$f":"'5. Q1'!M83","v":0},{"$f":"'5. Q1'!N83","v":0},null,{"$f":"'6. Q2'!M83","v":0},{"$f":"'6. Q2'!N83","v":0},null,{"$f":"'7. Q3'!M83","v":0},{"$f":"'7. Q3'!N83","v":0},null,{"$f":"'8. Q4'!M83","v":0},{"$f":"'8. Q4'!N83","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B85","v":"Mileage Costs Paid"},null,{"$f":"'5. Q1'!M84","v":0},{"$f":"'5. Q1'!N84","v":0},null,{"$f":"'6. Q2'!M84","v":0},{"$f":"'6. Q2'!N84","v":0},null,{"$f":"'7. Q3'!M84","v":0},{"$f":"'7. Q3'!N84","v":0},null,{"$f":"'8. Q4'!M84","v":0},{"$f":"'8. Q4'!N84","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B86","v":"Other Travel costs"},null,{"$f":"'5. Q1'!M85","v":0},{"$f":"'5. Q1'!N85","v":0},null,{"$f":"'6. Q2'!M85","v":0},{"$f":"'6. Q2'!N85","v":0},null,{"$f":"'7. Q3'!M85","v":0},{"$f":"'7. Q3'!N85","v":0},null,{"$f":"'8. Q4'!M85","v":0},{"$f":"'8. Q4'!N85","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B87","v":"Other"},null,{"$f":"'5. Q1'!M86","v":0},{"$f":"'5. Q1'!N86","v":0},null,{"$f":"'6. Q2'!M86","v":0},{"$f":"'6. Q2'!N86","v":0},null,{"$f":"'7. Q3'!M86","v":0},{"$f":"'7. Q3'!N86","v":0},null,{"$f":"'8. Q4'!M86","v":0},{"$f":"'8. Q4'!N86","v":0},null,0,0,0,"OK"]
[null,{"$f":"'4. CASHFLOW'!B88","v":"Total Transport"},null,{"$f":"SUM(D80:D86)","v":0},{"$f":"SUM(E80:E86)","v":0},null,{"$f":"SUM(G80:G86)","v":0},{"$f":"SUM(H80:H86)","v":0},null,{"$f":"SUM(J80:J86)","v":0},{"$f":"SUM(K80:K86)","v":0},null,{"$f":"SUM(M80:M86)","v":0},{"$f":"SUM(N80:N86)","v":0},null,{"$f":"SUM(P80:P86)","v":0},{"$f":"SUM(Q80:Q86)","v":0},{"$f":"SUM(R80:R86)","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B89","v":"Quality Assurance"},null,{"$f":"'5. Q1'!M88","v":0},{"$f":"'5. Q1'!N88","v":0},null,{"$f":"'6. Q2'!M88","v":0},{"$f":"'6. Q2'!N88","v":0},null,{"$f":"'7. Q3'!M88","v":0},{"$f":"'7. Q3'!N88","v":0},null,{"$f":"'8. Q4'!M88","v":0},{"$f":"'8. Q4'!N88","v":0},null,{"$f":"D88+G88+J88+M88","v":0},0,{"$f":"P88-Q88","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B90","v":"I"},null,{"$f":"'5. Q1'!M89","v":0},{"$f":"'5. Q1'!N89","v":0},null,{"$f":"'6. Q2'!M89","v":0},{"$f":"'6. Q2'!N89","v":0},null,{"$f":"'7. Q3'!M89","v":0},{"$f":"'7. Q3'!N89","v":0},null,{"$f":"'8. Q4'!M89","v":0},{"$f":"'8. Q4'!N89","v":0},null,0,0,{"$f":"P89-Q89","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B91","v":"ii"},null,{"$f":"'5. Q1'!M90","v":0},{"$f":"'5. Q1'!N90","v":0},null,{"$f":"'6. Q2'!M90","v":0},{"$f":"'6. Q2'!N90","v":0},null,{"$f":"'7. Q3'!M90","v":0},{"$f":"'7. Q3'!N90","v":0},null,{"$f":"'8. Q4'!M90","v":0},{"$f":"'8. Q4'!N90","v":0},null,0,0,{"$f":"P90-Q90","v":0},"OK"]
[null,{"$f":"'4. CASHFLOW'!B92","v":"Total Quality Assurance"},null,{"$f":"SUM(D88:D90)","v":0},{"$f":"SUM(E88:E90)","v":0},null,{"$f":"SUM(G88:G90)","v":0},{"$f":"SUM(H88:H90)","v":0},null,{"$f":"SUM(J88:J90)","v":0},{"$f":"SUM(K88:K90)","v":0},null,{"$f":"SUM(M88:M90)","v":0},{"$f":"SUM(N88:N90)","v":0},null,{"$f":"SUM(P88:P90)","v":0},{"$f":"SUM(Q88:Q90)","v":0},{"$f":"SUM(R88:R90)","v":0},"OK"]
[null,"TOTAL REVENUE EXPENDITURE",null,{"$f":"SUM(D91,D87,D79,D76,D73,D66,D52,D48,D38)","v":0},{"$f":"SUM(E91,E87,E79,E76,E73,E66,E52,E48,E38)","v":0},null,{"$f":"SUM(G91,G87,G79,G76,G73,G66,G52,G48,G38)","v":0},{"$f":"SUM(H91,H87,H79,H76,H73,H66,H52,H48,H38)","v":0},null,{"$f":"SUM(J91,J87,J79,J76,J73,J66,J52,J48,J38)","v":0},{"$f":"SUM(K91,K87,K79,K76,K73,K66,K52,K48,K38)","v":0},null,{"$f":"SUM(M91,M87,M79,M76,M73,M66,M52,M48,M38)","v":0},{"$f":"SUM(N91,N87,N79,N76,N73,N66,N52,N48,N38)","v":0},null,{"$f":"SUM(P91,P87,P79,P76,P73,P66,P52,P48,P38)","v":0},{"$f":"SUM(Q91,Q87,Q79,Q76,Q73,Q66,Q52,Q48,Q38)","v":0},{"$f":"SUM(R91,R87,R79,R76,R73,R66,R52,R48,R38)","v":0},"OK"]
[]
[null,"Total Income",null,{"$f":"D28","v":0},{"$f":"E28","v":0},null,{"$f":"G28","v":0},{"$f":"H28","v":0},null,{"$f":"J28","v":0},{"$f":"K28","v":0},null,{"$f":"M28","v":0},{"$f":"N28","v":0},null,{"$f":"P28","v":0},{"$f":"Q28","v":0},{"$f":"R28","v":0},{"$f":"IF(R94=0,\"OK\",IF(R94>0,\"Credit\",IF(R94<0,\"Defecit\")))","v":"OK"}]
[null,"Total Expenditure",null,{"$f":"D92","v":0},{"$f":"E92","v":0},null,{"$f":"G92","v":0},{"$f":"H92","v":0},null,{"$f":"J92","v":0},{"$f":"K92","v":0},null,{"$f":"M92","v":0},{"$f":"N92","v":0},null,{"$f":"P92","v":0},{"$f":"Q92","v":0},{"$f":"R92","v":0},{"$f":"IF(R95=0,\"OK\",IF(R95>0,\"Underspent\",IF(R95<0,\"Overspent\")))","v":"OK"}]
[null,"Closing balance",null,{"$f":"D94-D95","v":0},{"$f":"E94-E95","v":0},null,{"$f":"G94-G95","v":0},{"$f":"H94-H95","v":0},null,{"$f":"J94-J95","v":0},{"$f":"K94-K95","v":0},null,{"$f":"M94-M95","v":0},{"$f":"N94-N95","v":0},null,{"$f":"P94-P95","v":0},{"$f":"Q94-Q95","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Q94<P94,\"WARNING YOUR INCOME IS LESS THAN BUDGETED\",\"YOUR INCOME IS OK\")","v":"YOUR INCOME IS OK"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Q95>P95,\"WARNING YOUR EXPENDITURE IS MORE THAN YOUR BUDGET\",\"YOUR EXPENDITURE IS OK\")","v":"YOUR EXPENDITURE IS OK"}]