{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"macros":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":12,"n_cols":21,"rows_kept":12,"merged":[[1,14,1,15],[1,17,1,20],[2,14,2,15]]}
[null,"Gross Pay","Pension","After pension","Tax-free","Taxable at 20%","Taxable at 40%","Tax at 45%","National Insurance-free","National Insurance at 12%","National Insurance at 2%","Net Income Yearly","Monthly pay"]
[null,{"$f":"IF(A4=1,RANDBETWEEN(8000,11850),IF(A4=2,RANDBETWEEN(11850,46350),IF(A4=3,RANDBETWEEN(46350,100000),\"User Error\")))","v":{"v":12868,"d":"£12,868.00"}},null,{"$f":"B2-C3","v":{"v":12868,"d":"£12,868.00"}},{"$f":"IF(D2>11850,11850,D2)","v":{"v":11850,"d":"£11,850.00"}},{"$f":"IF(D2>11850,IF(D2>46350,(46350-11850),D2-E2),0)","v":{"v":1018,"d":"£1,018.00"}},{"$f":"IF(D2>46350,IF(D2>150000,(150000-46350),D2-46350),0)","v":{"v":0,"d":"£0.00"}},{"$f":"IF(D2>150000,(D2-150000),0)","v":{"v":0,"d":"£0.00"}},{"v":8424,"d":"£8,424.00"},{"$f":"IF(D2>I2,IF(D2<46350,(D2-I2),(46350-I2)),0)","v":{"v":4444,"d":"£4,444.00"}},{"$f":"IF(D2>46350,D2-46350,0)","v":{"v":0,"d":"£0.00"}},{"$f":"D2-(F3+G3+H3+J3+K3)","v":{"v":12131.12,"d":"£12,131.12"}},{"$f":"L2/12","v":{"v":1010.9266666666667,"d":"£1,010.93"}},null,"Average tax rate",null,null,"Monthly payslip"]
["DEDUCTIONS",null,{"$f":"B2*C2","v":{"v":0,"d":"£0.00"}},null,null,{"$f":"0.2*F2","v":{"v":203.60000000000002,"d":"£203.60"}},{"$f":"0.4*G2","v":{"v":0,"d":"£0.00"}},{"$f":"0.45*H2","v":{"v":0,"d":"£0.00"}},null,{"$f":"0.12*J2","v":{"v":533.28,"d":"£533.28"}},{"$f":"0.02*K2","v":{"v":0,"d":"£0.00"}},{"$nulls":3},{"$f":"SUM(F3:K3)/B2","v":{"v":0.05726453217283183,"d":"5.7%"}},null,null,"Gross pay",null,null,{"$f":"B2/12","v":{"v":1072.3333333333333,"d":"£1,072.33"}}]
[{"$f":"RANDBETWEEN(1,3)","v":2},{"$nulls":16},"Tax",null,{"$f":"(F3+G3)/12","v":{"v":16.96666666666667,"d":"£16.97"}}]
[{"$nulls":17},"NI",null,{"$f":"(J3+K3)/12","v":{"v":44.44,"d":"£44.44"}}]
[{"$nulls":17},"Total deductions",null,null,{"$f":"T4+T5","v":{"v":61.406666666666666,"d":"£61.41"}}]
[]
[{"$nulls":17},"NET PAY",null,null,{"$f":"U3-U6","v":{"v":1010.9266666666666,"d":"£1,010.93"}}]
[]
[]
[]
["press this button to randomly generate a new income between £6000 and £100000",null,"press this button to randomly generate a new income between £6000 and £99998","press this button to randomly generate a new income between £6000 and £99999"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}