{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Variances"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Variances","index":0,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,0,4,7],[18,0,18,2],[20,0,20,2],[0,0,0,10],[24,0,24,2],[26,0,26,2],[28,0,28,2],[10,0,10,2],[12,0,12,2],[14,0,14,2],[16,0,16,2]],"flags":["formulas_cached_only"]}
["Explanation of variances – pro forma "]
["Name of smaller authority: ",null,"Great Comberton Parish Council"]
["County area (local councils and parish meetings only): ",null,"Worcestershire"]
["Insert figures from Section 2 of the AGAR in all Blue highlighted boxes "]
["Next, please provide full explanations, including numerical values, for the following that will be flagged in the green boxes where relevant:\n• variances of more than 15% between totals for individual boxes (except variances of less than £200); \n• New from 2020/21 onwards: variances of £100,000 or more require explanation regardless of the % variation year on year;\n"]
[]
[]
[null,null,null,"2023/24",null,"2024/25","Variance","Variance",null,null,null,"Explanation Required?","Automatic responses trigger below based on figures input, DO NOT OVERWRITE THESE BOXES","Explanation from smaller authority (must include narrative and supporting figures)"]
[null,null,null,"£",null,"£","£","%"]
[]
["1 Balances Brought Forward",null,null,5855,null,6898,{"$nulls":6},"Explanation of % variance from PY opening balance not required - Balance brought forward agrees"]
[]
["2 Precept or Rates and Levies",null,null,4912,null,5300,388,0.07899022801302931,0,1,0,"NO"," "]
[]
["3 Total Other Receipts",null,null,3511,null,4092,581,0.16547992025064084,0,1,1,"YES"," ","Community Infrastructure Neighbourhood Fund received @ £1.074 for the period 1/10/23-31/3/24"]
[]
["4 Staff Costs",null,null,4146,null,4051,-95,0.02291365171249397,0,0,0,"NO"," "]
[]
["5 Loan Interest/Capital Repayment",null,null,0,null,0,0,0,0,0,0,"NO"," "]
[]
["6 All Other Payments",null,null,3234,null,4316,1082,0.33457019171304886,0,1,1,"YES"," ","Purchases for: new gate at Brailles Orchard @ £600, Community AED training @ £100, new defibrillator battery @ £300"]
[]
["7 Balances Carried Forward",null,null,6898,null,7923,{"$nulls":6},"VARIANCE EXPLANATION NOT REQUIRED"]
[]
["8 Total Cash and Short Term Investments",null,null,6898,null,7923,{"$nulls":6},"VARIANCE EXPLANATION NOT REQUIRED"]
[]
["9 Total Fixed Assets plus Other Long Term Investments and Assets",null,null,2754,null,2754,0,0,0,0,0,"NO"," "]
[]
["10 Total Borrowings",null,null,0,null,0,0,0,0,0,0,"NO"," "]
[]
[null,null,"Rounding errors of up to £2 are tolerable"]
[]
[null,null,"Variances of £200 or less are tolerable"]
[]
[null,null,"BOX 10 VARIANCE EXPLANATION NOT REQUIRED IF CHANGE CAN BE EXPLAINED BY BOX 5 (CAPITAL PLUS INTEREST PAYMENT)"]