{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Variances","Reserves"],"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":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,0,4,7],[18,0,18,2],[20,0,20,2],[0,0,0,10],[25,0,25,2],[27,0,27,2],[29,0,29,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: "]
["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• a breakdown of approved reserves on the next tab if the total reserves (Box 7) figure is more than twice the annual precept/rates & levies value (Box 2).\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,22907,null,15617,{"$nulls":6},"Explanation of % variance from PY opening balance not required - Balance brought forward agrees"]
[]
["2 Precept or Rates and Levies",null,null,16155,null,17771,1616,0.10003095017022594,0,1,0,"NO"," "]
[]
["3 Total Other Receipts",null,null,7026,null,7101,75,0.01067463706233988,0,0,0,"NO"," "]
[]
["4 Staff Costs",null,null,7247,null,6001,-1246,0.17193321374361806,1,0,1,"YES","20% reduction in staff hours"]
[]
["5 Loan Interest/Capital Repayment",null,null,0,null,0,0,0,0,0,0,"NO"," "]
[]
["6 All Other Payments",null,null,23224,null,18858,-4366,0.18799517740268687,1,0,1,"YES","No legal fees, election costs or grant applications total £1,560 in previous year"]
[]
["7 Balances Carried Forward",null,null,15617,null,15630,{"$nulls":6},"VARIANCE EXPLANATION NOT REQUIRED"]
[{"$nulls":11},"NO"," "]
[]
["8 Total Cash and Short Term Investments",null,null,15617,null,15630,{"$nulls":6},"VARIANCE EXPLANATION NOT REQUIRED"]
[]
["9 Total Fixed Assets plus Other Long Term Investments and Assets",null,null,51824,null,51824,0,0,0,0,0,"NO"," "]
[]
["10 Total Borrowings",null,null,0,null,0,0,0,0,0,0,"NO"," "]

{"sheet":"Reserves","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Explanation for ‘high’ reserves"]
["(Please complete the highlighted boxes.)"]
["Box 7 is more than twice Box 2 because the authority held the following breakdown of reserves at the year end:"]
[]
[null,null,null,"£","£","£"]
["Earmarked reserves:"]
[null,"Reserve 1"]
[null,"Reserve 2"]
[null,"Reserve 3"]
[null,"Reserve 4"]
[null,"Reserve 5"]
[null,"Reserve 6"]
[null,"Reserve 7"]
[{"$nulls":4},0]
[]
["General reserve"]
[{"$nulls":4},0]
["Total reserves (must agree to Box 7)",{"$nulls":4},0]