{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["APP Calculator","background sheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"APP Calculator","index":0,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[34,0,34,7],[23,3,23,4],[9,9,11,9],[9,10,11,10],[35,0,35,7],[33,0,33,7],[6,9,6,10],[9,0,11,1],[17,3,18,4],[17,5,18,5],[0,0,3,7],[15,0,19,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[5,3,5,7],[6,3,6,7],[7,3,7,7],[21,3,21,4],[26,3,31,7],[25,3,25,7]]}
["         APP Calculator (LGPS)"]
[]
[]
[]
[]
["Member name"]
["NINO",null,null,null,null,null,null,null,null,"Part month calc"]
["Pay Reference",null,null,null,null,null,null,null,null,"Days Required","Pick from drop down"]
[null,null,null,null,null,null,null,null,null,"Days in month","Pick from drop down"]
["Basic pay in 3 full months prior to reduction/no pay applying",null,null,"Month 1",null,null,null,null,null,"Pro rata month - based on above",{"$f":"IF(K9=\"Pick from Drop Down\",\"0\",SUM(F22/K9)*K8)","v":"0"}]
[null,null,null,"Month 2"]
[null,null,null,"Month 3"]
[]
[null,null,null,"Annual APP Figure",null,{"$f":"SUM(F10:F12)*4","v":0}]
[]
["Plus any REGULAR LUMP SUMS in the full 12 months prior to the reduction/no pay applying (if applicable)",null,null,"Plus Regular lump sums",null,{"$f":"SUM(B21:B32)","v":0}]
[]
[null,null,null,"Annual APP figure including regular lump sums",null,{"$f":"SUM(F14+F16)","v":0}]
[]
[]
["Month 1"]
["Month 2",null,null,"Monthly APP ",null,{"$f":"SUM(F18/12)","v":0}]
["Month 3"]
["Month 4",null,null,"Dates APP Applicable ",null,null,"to"]
["Month 5"]
["Month 6",null,null,"Comments"]
["Month 7"]
["Month 8"]
["Month 9"]
["Month 10"]
["Month 11"]
["Month 12"]
[]
["Further guidance on APP is available in the employer section of the website"]
["It is found under the LGPS Employer Guides section"]
["The document is named Assumed Pensionable Pay - quick guide"]

{"sheet":"background sheet","index":1,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Pick from drop down",null,"Pick from drop down",null,"Pick from drop down"]
[28,null,1,null,1]
[29,null,2,null,2]
[30,null,3,null,3]
[31,null,4,null,4]
[null,null,5,null,5]
[null,null,6,null,6]
[null,null,7,null,7]
[null,null,8,null,8]
[null,null,9,null,9]
[null,null,10,null,10]
[null,null,11,null,11]
[null,null,12,null,12]
[null,null,null,null,13]
[null,null,null,null,14]
[null,null,null,null,15]
[null,null,null,null,16]
[null,null,null,null,17]
[null,null,null,null,18]
[null,null,null,null,19]
[null,null,null,null,20]
[null,null,null,null,21]
[null,null,null,null,22]
[null,null,null,null,23]
[null,null,null,null,24]
[null,null,null,null,25]
[null,null,null,null,26]
[null,null,null,null,27]
[null,null,null,null,28]
[null,null,null,null,29]
[null,null,null,null,30]
[null,null,null,null,31]