{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CCC Pay Calculator","Input"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":10,"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":"CCC Pay Calculator","index":0,"n_rows":61,"n_cols":11,"rows_kept":61,"cut":false,"hidden":false,"merged":[[43,3,43,8],[10,2,14,10],[25,3,26,8],[35,3,36,7],[32,3,33,8],[36,8,36,10]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Part-time and TTO "]
[]
[null,null,null,null,null,null,null,null,null,null,"Pay Calculator"]
[]
[]
[]
[null,null,"This calculator works out your gross pay for the part-time and / or part year that you work.  Gross pay is the amount paid before deductions for Tax, National Insurance and Pension Fund contribution.  If you receive additional increments for weekend working enter the Spinal Column Number that includes the number of weekend increments."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"If you are on Coventry Terms & Conditions you may enter the:"]
[null,null,null,null,null,null,null,null,"Spinal Column Number: "]
[]
[null,null,null,null,null,null,null,null,"or enter the Full Time Equivalent Pay for any Terms & Conditions £: "]
[]
[]
[]
[null,null,null,"Full Time is 37 hours a week, if you are contracted to work fewer hours each week, enter the number of hours:"]
[]
[]
[]
[]
[null,null,null,"If you work Term Time Only (TTO):"]
[]
[null,null,null,"Enter the number of weeks that you work each year, including any fraction.  If you work the whole year, leave blank."]
[]
[]
[null,null,null,"Select your length of continuous Local Government Service (this affects holiday and therefore pay):   "]
[]
[]
[]
[]
[]
[null,null,null,"If you receive a Shift Allowance:"]
[]
[null,null,null,"Select the percentage shift rate:    "]
[]
[]
[null,null,{"$f":"IF(Input!B54<>\"\",Input!B54,IF(Input!B55<>\"\",Input!B55,IF(Input!B56<>\"\",Input!B56,\"\")))","v":"WARNING: Invalid scp, check new pay spine"}]
[]
[]
[null,null,null,null,"Full time pay is:  ",{"$f":"Input!C12","v":{"$error":"#N/A"}},{"$f":"IF(J20<>\"\",Input!E1,\"pa\")","v":"pa"}]
[]
[null,null,null,null,"Based on:  ",{"$f":"Input!C19","v":37},{"$f":"IF(Input!C24=\"all\",\" hours a week for the whole year\",CONCATENATE(\" hours a week and for \",Input!C22,\" weeks a year\"))","v":" hours a week for the whole year"}]
[]
[null,null,null,null,"and:  ",{"$f":"J44","v":0}," shift allowance"]
[]
[null,null,null,null,"Pro-rata pay is:  ",{"$f":"Input!C35","v":{"$error":"#N/A"}}," a year"]
[null,null,null,null,"or:  ",{"$f":"Input!C36","v":{"$error":"#N/A"}}," a month"]
[]
[]
[]
[null,null,"v6.6 2026/27"]

{"sheet":"Input","index":1,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"  [2026/27]",3.3000000000000002E-2,null,"New Pay Spine",null,null,"Shift Payments"]
[null,null,null,null,"scp","£","scp"]
[null,"Select Service for TTO","Working Days pa",null,null,null,null,null,null,null,"None"]
[null,null,null,null,3,25614,3,null,null,null,1.4999999999999999E-2]
[null,"1. Under 5-years service",224.71440000000001,null,4,26016,4,null,null,null,0.1]
[null,"2. Over 5-years service",219.71440000000001,null,5,26427,5,null,null,null,0.14000000000000001]
[null,null,null,null,6,26847,6,null,null,null,0.2]
[null,"FTE Pay",null,null,7,27274,7]
[null,"Scp entry value",{"$f":"VLOOKUP('CCC Pay Calculator'!J20,scp_val,2,FALSE)","v":{"$error":"#N/A"}},null,8,27709,8]
[null,"Other entry £",{"$f":"'CCC Pay Calculator'!J22","v":0},null,9,28153,9]
[null,null,null,null,10,28608,10]
[null,"Carry Back = Max",{"$f":"MAX(C9:C10)","v":{"$error":"#N/A"}},null,11,29071,11]
[null,null,null,null,12,29542,12]
[null,"Check only one entry",{"$f":"COUNTIF(C9:C10,\">0\")","v":0},null,13,30023,13,null,null,null,"Changes 2019/20"]
[null,null,null,null,14,30515,14,null,null,null,"Overlay new pay spine"]
[null,null,null,null,15,31015,15,null,null,null,"Amend named arrays to new number of rows"]
[null,"Hours",null,null,16,31525,16,null,null,null,"Add Warn 3"]
[null,"Input hours",{"$f":"'CCC Pay Calculator'!J27","v":0},null,17,32046,17]
[null,"Set to 37 if  >37 or zero",{"$f":"IF(C18>37,37,IF(C18=0,37,C18))","v":37},null,18,32578,18,null,null,null,"2021-02-01"]
[null,null,null,null,19,33119,19,null,null,null,"Add: input of percentage + upper text"]
[null,null,null,null,20,33673,20]
[null,"Working weeks pa",{"$f":"'CCC Pay Calculator'!J34","v":0},null,21,34237,21,null,null,null,"2022-11-01"]
[null,"Working days pa",{"$f":"C22*5","v":0},null,22,34811,22,null,null,null,"Overlay new pay spine"]
[null,"Carry Back",{"$f":"IF(C22=0,\"all\",C22)","v":"all"},null,23,35570,23]
[null,null,null,null,24,36581,24,null,null,null,"2023-04-01"]
[null,null,null,null,25,37563,25,null,null,null,"Reduce Working Days by 1 day for 2023/24 in line with NJC pay agreement 2022/23 "]
[null,"Pay pro-rata to hours",{"$f":"C12*C19/37","v":{"$error":"#N/A"}},"pa",26,38510,26]
[null,null,null,null,27,39481,27,null,null,null,"2023-11-01"]
[null,"Working days pa",{"$f":"VLOOKUP(Hol_Scheme,TTO_service,2,FALSE)","v":{"$error":"#N/A"}},null,28,40444,28,null,null,null,"Overlay new pay spine: £1925 increase SCP 2 - 43; 3.88% increase SCP 44 - 49"]
[null,null,null,null,29,41177,29,null,null,null,"Remove SCP1 for 2023/24 in line with NJC pay agreement 2022/23 "]
[null,"Pay to TTO",{"$f":"IFERROR(C27*C23/C29,C27)","v":{"$error":"#N/A"}},"pa",30,42123,30]
[null,null,null,null,31,43149,31,null,null,null,"2024-10-01"]
[null,"Shift",{"$f":"IF(OR('CCC Pay Calculator'!J44=\"\",'CCC Pay Calculator'!J44=\"None\"),1,(1+'CCC Pay Calculator'!J44))","v":1},null,32,44253,32,null,null,null,"Overlay new pay spine: £1290 increase SCP 2 - 43; 2.50% increase SCP 44 - 49"]
[null,null,null,null,33,45529,33]
[null,"Pay to Shift",{"$f":"C31*C33","v":{"$error":"#N/A"}},null,34,46579,34,null,null,null,"2025-08-01"]
[null," =  ",{"$f":"C35/12","v":{"$error":"#N/A"}},null,35,47665,35,null,null,null,"Overlay new pay spine: 3.2% increase"]
[null,null,null,null,36,48738,36]
[null,null,null,null,37,49817,37,null,null,null,"2026-08-01"]
[null,null,null,null,38,50908,38,null,null,null,"Overlay new pay spine: 3.3% increase"]
[null,null,null,null,39,51928,39,null,null,null,"Remove SCP 2"]
[null,null,null,null,40,53051,40]
[null,null,null,null,41,54143,41]
[null,null,null,null,42,55224,42]
[null,null,null,null,43,56293,43]
[null,null,null,null,44,57221,44]
[null,null,null,null,45,58254,45]
[null,null,null,null,46,59297,46]
[null,null,null,null,47,60304,47]
[null,null,null,null,48,61321,48]
[null,null,null,null,49,62349,49]
[null,null,null,null,50,65326,50]
[]
[]
[null,{"$f":"IF(C14>1,\"WARNING: only make one entry for pay rate.\",\"\")","v":""}]
[null,{"$f":"IF(C22<>0,IF(Hol_Scheme=\"\",\"Warning - you must select your length of LG service\",\"\"),\"\")","v":""}]
["Warn 1:",{"$f":"IF(ISERROR(C9),\"WARNING: Invalid scp, check new pay spine\",\"\")","v":"WARNING: Invalid scp, check new pay spine"}]
["Warn 2:"]
["Warn 3:"]