{"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":[[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],[4,0,4,7]],"flags":["formulas_cached_only"]}
["Explanation of variances – pro forma "]
["Name of smaller authority: "]
["County area (local councils and parish meetings only): "]
["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,"2022/23",null,"2023/24","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,22083,null,21882,{"$nulls":6},"Explanation of % variance from PY opening balance not required - Balance brought forward agrees"]
[]
["2 Precept or Rates and Levies",null,null,7033,null,7433,400,0.05687473339968719,0,1,0,"NO"," "]
[]
["3 Total Other Receipts",null,null,10036,null,5758,-4278,0.4262654444001594,1,0,1,"YES"," ","Reimbursement received from Village Hall for maintenance works carried out."]
[]
["4 Staff Costs",null,null,4016,null,4301,285,0.07096613545816734,0,1,0,"NO"," "]
[]
["5 Loan Interest/Capital Repayment",{"$nulls":5},0,0,0,0,0,"NO"," "]
[]
["6 All Other Payments",null,null,13254,null,11177,-2077,0.1567074090840501,1,0,1,"YES"," ","Payments made to contractors for works carried out at the Village Hall."]
[]
["7 Balances Carried Forward",null,null,21882,null,19595,{"$nulls":6},"VARIANCE EXPLANATION NOT REQUIRED"]
[]
["8 Total Cash and Short Term Investments",null,null,21882,null,19585,{"$nulls":6},"VARIANCE EXPLANATION NOT REQUIRED"]
[]
["9 Total Fixed Assets plus Other Long Term Investments and Assets",null,null,57000,null,58969,1969,0.03454385964912281,0,1,0,"NO"," "]
[]
["10 Total Borrowings",{"$nulls":5},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)"]