{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Maternity Cost Estimator"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Maternity Cost Estimator","index":0,"n_rows":63,"n_cols":16,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Terms"]
[null,"Pension Status"]
[null,"Annual Salary",null,"Please enter Pro Rata Salary where applicable"]
[null,"Maternity Start Date"]
[null,"SMP Rate",138.18,null,"This calculator makes a number of simplifying assumptions about maternity pay to provide a forecast. The actual cost may differ…"]
[null,null,null,null,"This calculator uses a custom function to calculate Employers NI and will not work if macros are disabled…"]
[null,null,null,null,"Do Not Ever use this calculator to inform an employee how much maternity pay she will receive!",null,null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(P12:P63)","v":0}]
[]
[null,null,null,null,"Week","Start Date","Teachers Contractual Maternity Pay","Blue Book Contractual Maternity Pay","Statutory Maternity Pay","Total Maternity Pay","Employers Pension Cont. Teachers","Employers Pension Cont. LGPS","Employers NI","Total Cost","HMRC Recoveries","Final Cost to School"]
[null,null,null,null,1,{"$f":"IF(C6>0,C6,\"\")","v":""},{"$f":"IF($C$3=\"Teachers T&C\",($C$5/52.143)-I12,0)","v":0},0,{"$f":"($C$5/52.143)*0.9","v":0},{"$f":"SUM(G12:I12)","v":0},{"$f":"IF($C$4=\"Teachers Pension Scheme\",J12*0.141,0)","v":0},{"$f":"IF($C$4=\"LGPS 50/50\",J12*0.105,\nIF($C$4=\"LGPS\",J12*0.21,0))","v":0},{"$f":"empnimaternityversion(J12,$C$4)","v":0},{"$f":"SUM(J12:M12)","v":0},{"$f":"I12*0.92","v":0},{"$f":"N12-O12","v":0}]
[null,null,null,null,2,{"$f":"IF(ISERROR(F12+7),\"\",F12+7)","v":""},{"$f":"IF($C$3=\"Teachers T&C\",($C$5/52.143)-I13,0)","v":0},0,0,{"$f":"SUM(G13:I13)","v":0},{"$f":"IF($C$4=\"Teachers Pension Scheme\",J13*0.141,0)","v":0},{"$f":"IF($C$4=\"LGPS 50/50\",J13*0.105,\nIF($C$4=\"LGPS\",J13*0.21,0))","v":0},{"$f":"empnimaternityversion(J13,$C$4)","v":0},{"$f":"SUM(J13:M13)","v":0},{"$f":"I13*0.92","v":0},{"$f":"N13-O13","v":0}]
[null,null,null,null,3,{"$f":"IF(ISERROR(F13+7),\"\",F13+7)","v":""},{"$f":"IF($C$3=\"Teachers T&C\",($C$5/52.143)-I14,0)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,4,"",{"$f":"IF($C$3=\"Teachers T&C\",($C$5/52.143)-I15,0)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,5,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,6,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,7,"",{"$f":"IF($C$3=\"Teachers T&C\",IF((($C$5/104.286)+I18)>($C$5/52.143),($C$5/52.143)-I18,$C$5/104.286),0)","v":0},{"$f":"IF($C$3=\"Blue Book\",IF((($C$5/104.286)+I18)>($C$5/52.143),($C$5/52.143)-I18,$C$5/104.286),0)","v":0},{"$f":"IF($I$12>$C$7,$C$7,$I$12)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,8,"",{"$f":"IF($C$3=\"Teachers T&C\",IF((($C$5/104.286)+I19)>($C$5/52.143),($C$5/52.143)-I19,$C$5/104.286),0)","v":0},{"$f":"IF($C$3=\"Blue Book\",IF((($C$5/104.286)+I19)>($C$5/52.143),($C$5/52.143)-I19,$C$5/104.286),0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,9,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,10,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,11,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,12,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,13,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,14,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,15,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,16,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,17,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,18,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,19,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,20,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,21,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,22,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,23,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,24,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,25,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,26,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,27,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,28,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,29,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,30,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,31,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,32,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,33,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,34,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,35,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,36,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,37,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,38,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,39,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,40,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,41,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,42,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,43,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,44,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,45,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,46,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,47,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,48,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,49,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,50,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,51,"",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,52,"",0,0,0,0,0,0,0,0,0,0]