{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main Calculator","Calendar - Option A","Calendar - Option B"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":2,"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":"Main Calculator","index":0,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,1,4,12],[12,5,12,6],[21,5,21,6],[29,5,29,6],[10,5,10,12],[8,1,8,13],[6,1,6,12]]}
[]
[null,"Maternity Pay Calculator (Revised April 2022)"]
[null,"(Please ensure you enable macros in order for the calculator to work fully)"]
[]
[null,"If you are on University of Glasgow terms and conditions you can use this calculator to gain an overall estimate of your earnings during your period of maternity leave. You can also view calendar illustrations for each option by clicking the buttons provided."]
[]
[null,"Please Note - This calculator will only provide an approximate gross maternity pay entitlement based on the information you enter and is intended to show illustrative examples of how your pay may differ depending on the option you choose. This is a basic calculator and does not take account of deductions such as tax, national insurance, pension contributions etc. It can therefore not be relied upon for providing a definitive forecast for maternity pay. Please contact Payroll or your local HR Team if you have any specific queries."]
[]
[null,"(SMP is paid at the rate set by the Government, or 90% of average weekly earnings if  weekly earnings exceed the SMP amount - for those eligible to receive it)"]
[]
[null,"Please enter the required details below:",null,null,null,"The tables below show how your pay may be split across the different options available (subject to eligibility):"]
[]
[null,null,null,null,null,"Option A",null,null,null,null,null,"Totals"]
[null,"Continuous Service Date",null,null,null,null,"9 weeks at:",null,{"$f":"C19","v":" "},"(Full Pay)",null,{"$f":"IF(I14=\" \", \" \", (9*I14))","v":" "}]
[null,"Baby's Due Date",null,null,null,"then…","18 weeks at:",null,{"$f":"IF(C21=\" \", \" \", IF(C21=\"Yes\", C28, (C19/2)))","v":" "},"(Half pay + SMP)",null,{"$f":"IF(I15=\" \", \" \", (18*I15))","v":" "}]
[null,"Maternity Leave Start Date",null,null,null,"then…","12 weeks at:",null,{"$f":"IF(C21=\"Yes\", C27, \"N/A\")","v":"N/A"},"(SMP Only)",null,{"$f":"IF(C21=\"Yes\",(12*I16),\"N/A\")","v":"N/A"}]
[null,"Qualifying Week",{"$f":"IF(C15=0, \" \", SUM(C15-105))","v":" "},null,null,"then…","13 weeks at:",null,0,"(Unpaid)",null,0]
[null,"Annual Salary (Actual)",0]
[null,"Weekly Salary",{"$f":"IF(C18=0, \" \", (C18/52.14))","v":" "},null,null,null,null,null,null,null,"Total Received:",{"$f":"SUM(L14:L17)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"(Gross)"]
[null,"Entitled to SMP",{"$f":"IF(C18=0, \" \", IF(AND(C17-C14>=182, C23=\"Met\"), \"Yes\", \"No\"))","v":" "}]
[null,"Current rate of SMP",172.48,null,null,"Option B",null,null,null,null,null,"Totals"]
[null,"Lower Earnings Limit ",{"$f":"IF(C18=0, \" \", (IF(C19>116, \"Met\", \"Not Met\")))","v":" "},null,null,null,"18 weeks at:",null,{"$f":"C19","v":" "},"(Full Pay)",null,{"$f":"IF(I23=\" \", \" \", (18*I23))","v":" "}]
[null,"Earnings less than SMP?",{"$f":"IF(C19<C22, \"Yes\", \"No\")","v":"No"},null,null,"then…","21 weeks at:",null,{"$f":"IF(C21=\"Yes\", C27, \"N/A\")","v":"N/A"},"(SMP Only)",null,{"$f":"IF(C21=\"Yes\", (21*I24), \"N/A\")","v":"N/A"}]
[null,"SMP Service",{"$f":"IF(C18=0,\" \",(IF(C17-C14>169,\"Yes\",\"No\")))","v":" "},null,null,"then…","13 weeks at:",null,0,"(Unpaid)",null,0]
[null,"90% weekly pay",{"$f":"C19*0.9","v":{"$error":"#VALUE!"}}]
[null,"Ensure SMP not exceeded",{"$f":"IF(C26<C22, C26, C22)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Total Received:",{"$f":"SUM(L23:L25)","v":0}]
[null,"Figure to use (half and SMP)",{"$f":"IF(((C19/2)+C27)>C19, C19, ((C19/2)+C27))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,"(Gross)"]
[null,"ALERTS"]
[]
[null,{"$f":"IF(C25=\"No\", \"Your length of service does not entitle you to (SMP)\", \" \")","v":" "}]
[null,{"$f":"IF(C23=\"Not Met\", \"Your earnings are not sufficient to meet the Lower Earnings Limit for payment of SMP\", \" \")","v":" "}]

{"sheet":"Calendar - Option A","index":1,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[[6,10,7,10],[30,10,31,10],[18,5,19,5],[20,5,21,5],[22,5,23,5],[24,5,25,5],[30,5,31,5],[18,10,19,10],[22,0,23,0],[24,0,25,0],[26,0,27,0],[28,0,29,0],[30,0,31,0],[6,5,7,5],[8,5,9,5],[10,5,11,5],[12,5,13,5],[14,5,15,5],[16,5,17,5],[26,5,27,5],[28,5,29,5],[22,1,23,1],[24,1,25,1],[26,1,27,1],[28,1,29,1],[30,1,31,1],[6,6,7,6],[8,6,9,6],[10,6,11,6],[12,6,13,6],[14,6,15,6],[16,6,17,6],[18,6,19,6],[20,6,21,6],[22,6,23,6],[24,6,25,6],[26,6,27,6],[28,6,29,6],[30,6,31,6],[16,1,17,1],[18,1,19,1],[20,1,21,1],[24,2,25,3],[26,2,27,3],[28,2,29,3],[30,2,31,3],[6,0,7,0],[8,0,9,0],[10,0,11,0],[12,0,13,0],[14,0,15,0],[16,0,17,0],[18,0,19,0],[20,0,21,0],[5,2,5,3],[6,2,7,3],[6,1,7,1],[5,0,5,1],[8,1,9,1],[10,1,11,1],[12,1,13,1],[14,1,15,1],[6,7,7,8],[8,7,9,8],[10,7,11,8],[12,7,13,8],[26,7,27,8],[30,7,31,8],[28,7,29,8],[18,12,19,13],[16,2,17,3],[18,2,19,3],[20,2,21,3],[22,2,23,3],[8,2,9,3],[10,2,11,3],[12,2,13,3],[14,2,15,3],[28,11,29,11],[22,11,23,11],[26,11,27,11],[6,11,7,11],[10,11,11,11],[18,11,19,11],[28,10,29,10],[22,10,23,10],[14,12,15,13],[28,12,29,13],[14,7,15,8],[16,7,17,8],[18,7,19,8],[20,7,21,8],[26,10,27,10],[16,11,17,11],[16,10,17,10],[16,12,17,13],[20,11,21,11],[20,10,21,10],[20,12,21,13],[26,12,27,13],[2,0,3,14],[30,12,31,13],[22,7,23,8],[24,7,25,8],[5,5,5,6],[5,7,5,8],[5,10,5,11],[5,12,5,13],[30,11,31,11],[6,12,7,13],[24,11,25,11],[24,10,25,10],[24,12,25,13],[22,12,23,13],[8,11,9,11],[8,10,9,10],[8,12,9,13],[10,10,11,10],[10,12,11,13],[14,11,15,11],[12,11,13,11],[12,10,13,10],[12,12,13,13],[14,10,15,10]]}
["Weekly Calendar - Option A"]
[]
["Please Note - This calendar is for general illustrative purposes only. Your gross pay may vary subject to when payroll dates fall each month. Other factors such as tax, national insurance, pension contributions etc will affect your actual pay and are not accounted for in this illustration. Weeks 40 to 52 are unpaid. Please contact Payroll or your local HR Team if you have any specific queries."]
[]
[]
["Week Ending",null,"Gross Pay",null,null,"Week Ending",null,"Gross Pay",null,null,"Week Ending",null,"Gross Pay"]
[1,{"$f":"'Main Calculator'!C16+6","v":"1900-01-06"},{"$f":"'Main Calculator'!$I$14","v":" "},null,null,14,{"$f":"B31+7","v":"1900-04-06"},{"$f":"'Main Calculator'!$I$15","v":" "},null,null,27,{"$f":"G31+7","v":"1900-07-06"},{"$f":"'Main Calculator'!$I$15","v":" "}]
[]
[2,{"$f":"B7+7","v":"1900-01-13"},{"$f":"'Main Calculator'!$I$14","v":" "},null,null,15,{"$f":"G7+7","v":"1900-04-13"},{"$f":"'Main Calculator'!$I$15","v":" "},null,null,28,{"$f":"L7+7","v":"1900-07-13"},{"$f":"'Main Calculator'!$I$16","v":"N/A"}]
[]
[3,{"$f":"B9+7","v":"1900-01-20"},{"$f":"'Main Calculator'!$I$14","v":" "},null,null,16,{"$f":"G9+7","v":"1900-04-20"},{"$f":"'Main Calculator'!$I$15","v":" "},null,null,29,{"$f":"L9+7","v":"1900-07-20"},{"$f":"'Main Calculator'!$I$16","v":"N/A"}]
[]
[4,{"$f":"B11+7","v":"1900-01-27"},{"$f":"'Main Calculator'!$I$14","v":" "},null,null,17,{"$f":"G11+7","v":"1900-04-27"},{"$f":"'Main Calculator'!$I$15","v":" "},null,null,30,{"$f":"L11+7","v":"1900-07-27"},{"$f":"'Main Calculator'!$I$16","v":"N/A"}]
[]
[5,{"$f":"B13+7","v":"1900-02-03"},{"$f":"'Main Calculator'!$I$14","v":" "},null,null,18,{"$f":"G13+7","v":"1900-05-04"},{"$f":"'Main Calculator'!$I$15","v":" "},null,null,31,{"$f":"L13+7","v":"1900-08-03"},{"$f":"'Main Calculator'!$I$16","v":"N/A"}]
[]
[6,{"$f":"B15+7","v":"1900-02-10"},{"$f":"'Main Calculator'!$I$14","v":" "},null,null,19,{"$f":"G15+7","v":"1900-05-11"},{"$f":"'Main Calculator'!$I$15","v":" "},null,null,32,{"$f":"L15+7","v":"1900-08-10"},{"$f":"'Main Calculator'!$I$16","v":"N/A"}]
[]
[7,{"$f":"B17+7","v":"1900-02-17"},{"$f":"'Main Calculator'!$I$14","v":" "},null,null,20,{"$f":"G17+7","v":"1900-05-18"},{"$f":"'Main Calculator'!$I$15","v":" "},null,null,33,{"$f":"L17+7","v":"1900-08-17"},{"$f":"'Main Calculator'!$I$16","v":"N/A"}]
[]
[8,{"$f":"B19+7","v":"1900-02-24"},{"$f":"'Main Calculator'!$I$14","v":" "},null,null,21,{"$f":"G19+7","v":"1900-05-25"},{"$f":"'Main Calculator'!$I$15","v":" "},null,null,34,{"$f":"L19+7","v":"1900-08-24"},{"$f":"'Main Calculator'!$I$16","v":"N/A"}]
[]
[9,{"$f":"B21+7","v":"1900-03-02"},{"$f":"'Main Calculator'!$I$14","v":" "},null,null,22,{"$f":"G21+7","v":"1900-06-01"},{"$f":"'Main Calculator'!$I$15","v":" "},null,null,35,{"$f":"L21+7","v":"1900-08-31"},{"$f":"'Main Calculator'!$I$16","v":"N/A"}]
[]
[10,{"$f":"B23+7","v":"1900-03-09"},{"$f":"'Main Calculator'!$I$15","v":" "},null,null,23,{"$f":"G23+7","v":"1900-06-08"},{"$f":"'Main Calculator'!$I$15","v":" "},null,null,36,{"$f":"L23+7","v":"1900-09-07"},{"$f":"'Main Calculator'!$I$16","v":"N/A"}]
[]
[11,{"$f":"B25+7","v":"1900-03-16"},{"$f":"'Main Calculator'!$I$15","v":" "},null,null,24,{"$f":"G25+7","v":"1900-06-15"},{"$f":"'Main Calculator'!$I$15","v":" "},null,null,37,{"$f":"L25+7","v":"1900-09-14"},{"$f":"'Main Calculator'!$I$16","v":"N/A"}]
[]
[12,{"$f":"B27+7","v":"1900-03-23"},{"$f":"'Main Calculator'!$I$15","v":" "},null,null,25,{"$f":"G27+7","v":"1900-06-22"},{"$f":"'Main Calculator'!$I$15","v":" "},null,null,38,{"$f":"L27+7","v":"1900-09-21"},{"$f":"'Main Calculator'!$I$16","v":"N/A"}]
[]
[13,{"$f":"B29+7","v":"1900-03-30"},{"$f":"'Main Calculator'!$I$15","v":" "},null,null,26,{"$f":"G29+7","v":"1900-06-29"},{"$f":"'Main Calculator'!$I$15","v":" "},null,null,39,{"$f":"L29+7","v":"1900-09-28"},{"$f":"'Main Calculator'!$I$16","v":"N/A"}]

{"sheet":"Calendar - Option B","index":2,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[25,7,26,8],[25,10,26,10],[27,11,28,11],[27,12,28,12],[29,10,30,10],[29,11,30,11],[29,12,30,12],[29,0,30,0],[29,1,30,1],[29,2,30,3],[29,5,30,5],[29,6,30,6],[29,7,30,8],[27,0,28,0],[27,1,28,1],[27,2,28,3],[27,5,28,5],[27,6,28,6],[27,7,28,8],[27,10,28,10],[25,11,26,11],[21,10,22,10],[21,11,22,11],[21,12,22,12],[25,12,26,12],[23,11,24,11],[23,12,24,12],[23,0,24,0],[23,1,24,1],[23,2,24,3],[23,5,24,5],[23,6,24,6],[23,7,24,8],[23,10,24,10],[21,0,22,0],[21,1,22,1],[21,2,22,3],[21,5,22,5],[21,6,22,6],[21,7,22,8],[25,0,26,0],[25,1,26,1],[25,2,26,3],[25,5,26,5],[25,6,26,6],[19,0,20,0],[19,1,20,1],[19,2,20,3],[19,5,20,5],[19,6,20,6],[19,7,20,8],[19,10,20,10],[19,11,20,11],[19,12,20,12],[17,0,18,0],[17,1,18,1],[17,2,18,3],[17,5,18,5],[17,6,18,6],[17,7,18,8],[17,10,18,10],[17,11,18,11],[17,12,18,12],[13,10,14,10],[13,11,14,11],[13,12,14,12],[15,0,16,0],[15,1,16,1],[15,2,16,3],[15,5,16,5],[15,6,16,6],[15,7,16,8],[15,10,16,10],[13,0,14,0],[13,1,14,1],[13,2,14,3],[13,5,14,5],[13,6,14,6],[13,7,14,8],[15,11,16,11],[15,12,16,12],[11,0,12,0],[11,1,12,1],[11,2,12,3],[11,5,12,5],[11,6,12,6],[11,7,12,8],[11,10,12,10],[11,11,12,11],[11,12,12,12],[7,11,8,11],[7,12,8,12],[9,0,10,0],[9,1,10,1],[9,2,10,3],[9,5,10,5],[9,6,10,6],[9,7,10,8],[9,10,10,10],[9,11,10,11],[9,12,10,12],[7,0,8,0],[7,1,8,1],[7,2,8,3],[7,5,8,5],[7,6,8,6],[7,7,8,8],[7,10,8,10],[5,0,6,0],[5,1,6,1],[5,2,6,3],[5,5,6,5],[5,6,6,6],[5,7,6,8],[2,0,3,14],[4,0,4,1],[4,2,4,3],[4,5,4,6],[4,7,4,8],[4,10,4,11],[5,10,6,10],[5,11,6,11],[5,12,6,12]]}
["Weekly Calendar - Option B"]
[]
["Please Note - This calendar is for general illustrative purposes only. Your gross pay may vary subject to when payroll dates fall each month. Other factors such as tax, national insurance, pension contributions, etc will affect your actual pay and are not accounted for in this illustration. Weeks 40 to 52 are unpaid. Please contact Payroll or your local HR Team if you have any specific queries."]
[]
["Week Ending",null,"Gross Pay",null,null,"Week Ending",null,"Gross Pay",null,null,"Week Ending",null,"Gross Pay"]
[1,{"$f":"'Main Calculator'!C16+6","v":"1900-01-06"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,14,{"$f":"B30+7","v":"1900-04-06"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,27,{"$f":"G30+7","v":"1900-07-06"},{"$f":"'Main Calculator'!$I$24","v":"N/A"}]
[]
[2,{"$f":"B6+7","v":"1900-01-13"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,15,{"$f":"G6+7","v":"1900-04-13"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,28,{"$f":"L6+7","v":"1900-07-13"},{"$f":"'Main Calculator'!$I$24","v":"N/A"}]
[]
[3,{"$f":"B8+7","v":"1900-01-20"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,16,{"$f":"G8+7","v":"1900-04-20"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,29,{"$f":"L8+7","v":"1900-07-20"},{"$f":"'Main Calculator'!$I$24","v":"N/A"}]
[]
[4,{"$f":"B10+7","v":"1900-01-27"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,17,{"$f":"G10+7","v":"1900-04-27"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,30,{"$f":"L10+7","v":"1900-07-27"},{"$f":"'Main Calculator'!$I$24","v":"N/A"}]
[]
[5,{"$f":"B12+7","v":"1900-02-03"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,18,{"$f":"G12+7","v":"1900-05-04"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,31,{"$f":"L12+7","v":"1900-08-03"},{"$f":"'Main Calculator'!$I$24","v":"N/A"}]
[]
[6,{"$f":"B14+7","v":"1900-02-10"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,19,{"$f":"G14+7","v":"1900-05-11"},{"$f":"'Main Calculator'!$I$24","v":"N/A"},null,null,32,{"$f":"L14+7","v":"1900-08-10"},{"$f":"'Main Calculator'!$I$24","v":"N/A"}]
[]
[7,{"$f":"B16+7","v":"1900-02-17"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,20,{"$f":"G16+7","v":"1900-05-18"},{"$f":"'Main Calculator'!$I$24","v":"N/A"},null,null,33,{"$f":"L16+7","v":"1900-08-17"},{"$f":"'Main Calculator'!$I$24","v":"N/A"}]
[]
[8,{"$f":"B18+7","v":"1900-02-24"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,21,{"$f":"G18+7","v":"1900-05-25"},{"$f":"'Main Calculator'!$I$24","v":"N/A"},null,null,34,{"$f":"L18+7","v":"1900-08-24"},{"$f":"'Main Calculator'!$I$24","v":"N/A"}]
[]
[9,{"$f":"B20+7","v":"1900-03-02"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,22,{"$f":"G20+7","v":"1900-06-01"},{"$f":"'Main Calculator'!$I$24","v":"N/A"},null,null,35,{"$f":"L20+7","v":"1900-08-31"},{"$f":"'Main Calculator'!$I$24","v":"N/A"}]
[]
[10,{"$f":"B22+7","v":"1900-03-09"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,23,{"$f":"G22+7","v":"1900-06-08"},{"$f":"'Main Calculator'!$I$24","v":"N/A"},null,null,36,{"$f":"L22+7","v":"1900-09-07"},{"$f":"'Main Calculator'!$I$24","v":"N/A"}]
[]
[11,{"$f":"B24+7","v":"1900-03-16"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,24,{"$f":"G24+7","v":"1900-06-15"},{"$f":"'Main Calculator'!$I$24","v":"N/A"},null,null,37,{"$f":"L24+7","v":"1900-09-14"},{"$f":"'Main Calculator'!$I$24","v":"N/A"}]
[]
[12,{"$f":"B26+7","v":"1900-03-23"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,25,{"$f":"G26+7","v":"1900-06-22"},{"$f":"'Main Calculator'!$I$24","v":"N/A"},null,null,38,{"$f":"L26+7","v":"1900-09-21"},{"$f":"'Main Calculator'!$I$24","v":"N/A"}]
[]
[13,{"$f":"B28+7","v":"1900-03-30"},{"$f":"'Main Calculator'!$I$23","v":" "},null,null,26,{"$f":"G28+7","v":"1900-06-29"},{"$f":"'Main Calculator'!$I$24","v":"N/A"},null,null,39,{"$f":"L28+7","v":"1900-09-28"},{"$f":"'Main Calculator'!$I$24","v":"N/A"}]