{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Worksheet","SYSTEM FORMULAE","SYSTEM FORMULAE 2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"Worksheet","index":0,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,2,0,6],[3,0,3,1],[21,3,23,6],[16,3,18,6],[26,3,28,6],[31,3,33,6],[11,3,13,6],[1,0,1,1],[6,3,8,6]]}
[null,null,"Using the table of tax rates at the top of the page, calculate the deductions and/or net pay for each person as requested in each question"]
["Variables",null,null,null,"Annual taxable income (£)","Rate"]
["SHOW ANSWERS",false,null,null,"On the first £12 570",0]
["Tax Bands/Rates",null,null,null,"Over £12 570 and up to £50 270",0.2]
["Question involves National Insurance as well as tax",true,null,null,"Over £50 270",0.42]
[{"$f":"CONCATENATE(\"Use current English* rates/bands of \",IF(B5,\"tax.  (National Insurance rates/bands will be randomly chosen)\",\"tax\"))","v":"Use current English* rates/bands of tax.  (National Insurance rates/bands will be randomly chosen)"},1]
[{"$f":"CONCATENATE(\"Use randomly chosen rates/bands of \",IF(B5,\"tax/National Insurance\",\"tax\"))","v":"Use randomly chosen rates/bands of tax/National Insurance"},30,1,"Richard Mitchell earns £1,483 per month and has an annual personal tax allowance of £10,200.                                                                                                                                                                Richard also pays National Insurance at a rate of 8·6% on all monthly income over £708.                                                                                                                                                                  Calculate Richard's annual net pay.                                                                                                                                                                  "]
["Level of Difficulty"]
["Include questions where some tax is paid in the middle or higher bands",false]
["All figures in question are expressed annually (i.e. No monthly figures are stated/requested)",false,null,null,null,null,"£16,995·63"]
[]
[null,null,2,"Paige Campbell earns £15,713 per year and has an annual personal tax allowance of £9,600.                                                                                                                                                                Paige also pays National Insurance at a rate of 12·7% on all annual income over £8,000.                                                                                                                                                                  Calculate Paige's yearly net pay.                                                                                                                                                                  "]
["* English rates used rather than Scottish because Scottish rates have additional bands"]
[]
[null,null,null,null,null,null,"£14,733·45"]
[]
[null,null,3,"Mitchell Lewis earns £1,227 per month and has an annual personal tax allowance of £11,760.                                                                                                                                                                Mitchell also pays National Insurance at a rate of 13·2% on all annual income over £9,800.                                                                                                                                                                  Calculate Mitchell's monthly net pay.                                                                                                                                                                  "]
[]
[]
[null,null,null,null,null,null,"£1,173·13"]
[]
[null,null,4,"Ashley Davies earns £1,881 per month and has a yearly personal tax allowance of £12,660.                                                                                                                                                                Ashley also pays National Insurance at a rate of 10·7% on all monthly income over £879.                                                                                                                                                                  Calculate Ashley's annual total deductions.                                                                                                                                                                  "]
[]
[]
[null,null,null,null,null,null,"£1,286·78"]
[]
[null,null,5,"Jack White earns £23,576 per year and has a yearly personal tax allowance of £11,160.                                                                                                                                                                Jack also pays National Insurance at a rate of 10·7% on all annual income over £9,300.                                                                                                                                                                  Calculate Jack's yearly total deductions.                                                                                                                                                                  "]
[]
[]
[null,null,null,null,null,null,"£1,527·53"]
[]
[null,null,6,"Aaron Wright earns £1,192 per month and has a yearly personal tax allowance of £9,900.                                                                                                                                                                Aaron also pays National Insurance at a rate of 14·5% on all monthly income over £688.                                                                                                                                                                  Calculate Aaron's annual total deductions.                                                                                                                                                                  "]
[]
[]
[null,null,null,null,null,null,"£877·11"]

{"sheet":"SYSTEM FORMULAE","index":1,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,4]]}
[null,"Current English Tax Rates",null,"Tax for this sheet",null,null,null,null,null,"Annual taxable income (£)","Rate"]
[null,12570,0,{"$f":"IF(Worksheet!$B$6=1,B2,RANDBETWEEN(400,800)*50)","v":12570},0,null,null,null,null,{"$f":"CONCATENATE(\"On the first £\",TEXT(D2,\"### ###\"))","v":"On the first £12 570"},{"$f":"E2","v":0}]
[null,50270,0.2,{"$f":"IF(Worksheet!$B$6=1,B3,RANDBETWEEN(180,400)*500)","v":50270},{"$f":"IF(Worksheet!$B$6=1,C3,RANDBETWEEN(E2*100+10,30)/100)","v":0.2},null,null,null,null,{"$f":"CONCATENATE(\"Over £\",TEXT(D2,\"### ###\"),\" and up to £\",TEXT(D3,\"### ###\"))","v":"Over £12 570 and up to £50 270"},{"$f":"E3","v":0.2}]
[null,null,0.42,null,{"$f":"IF(Worksheet!$B$6=1,C4,RANDBETWEEN(E3*100+10,70)/100)","v":0.42},null,null,null,null,{"$f":"CONCATENATE(\"Over £\",TEXT(D3,\"### ###\"))","v":"Over £50 270"},{"$f":"E4","v":0.42}]
[]
[null,null,null,"Annual Income",{"$f":"IF(Worksheet!$B$9,RANDBETWEEN(E7+100+$D$2,1.2*$D$3)/6,RANDBETWEEN(E7+100,E7-100+$D$2)/6)*6","v":24797},{"$f":"E6-E7","v":12437},{"$f":"IF(F6<$D$2,$E$2*F6,IF(F6<$D$3,$E$3*(F6-$D$2)+$E$2*$D$2,$D$2*$E$2+$D$3*$E$3+$E$4*(F6-$D$3)))","v":0},1,{"$f":"CONCATENATE(B7,\" \",B8,\" earns £\",TEXT(IF(D9=1,E6,E6/12),IF(AND(D9=2,E6/12<1000),\"######\",\"###,###\")),\" per \",IF(D9=1,\"year\",\"month\"),\" and has \",CHOOSE(RANDBETWEEN(1,2),\"a yearly\",\"an annual\"),\" personal tax allowance of £\",TEXT(E7,\"###,###\"),\".                                                                                                                                                                \",IF(Worksheet!$B$5,CONCATENATE(B7,\" also pays National Insurance at a rate of \",C8*100,\"% on all \",IF(F8=1,\"annual\",\"monthly\"),\" income over £\",IF(F8=1,TEXT(E8,\"###,###\"),TEXT(E8/12,IF(E8/12<1000,\"######\",\"###,###\"))),\".                                                                                                                                                                  \"),\"\"),CONCATENATE(\"Calculate \",B7,\"'s \",IF(F9=1,CHOOSE(RANDBETWEEN(1,2),\"yearly\",\"annual\"),\"monthly\"),IF(E9=1,IF(Worksheet!$B$5,\" total deductions\",\" tax\"),\" net pay\"),\".                                                                                                                                                                  \"))","v":"Joe Hughes earns £24,797 per year and has an annual personal tax allowance of £12,360.                                                                                                                                                                Joe also pays National Insurance at a rate of 7.9% on all monthly income over £858.                                                                                                                                                                  Calculate Joe's monthly net pay.                                                                                                                                                                  "}]
[null,{"$f":"INDEX('SYSTEM FORMULAE 2'!A$2:A$201,RANDBETWEEN(1,200))","v":"Joe"},null,"Tax Allowance",{"$f":"RANDBETWEEN(800/6,1300/6)*60","v":12360},"NI allowance month/ann"]
[null,{"$f":"INDEX('SYSTEM FORMULAE 2'!C$2:C$43,RANDBETWEEN(1,42))","v":"Hughes"},{"$f":"(RANDBETWEEN(5,20)+RANDBETWEEN(1,9)/10)/100","v":7.9000000000000001E-2},"NI Allowance",{"$f":"E7/6*5","v":10300},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":2},{"$f":"IF(Worksheet!$B$5,(E6-E8)*C8,0)","v":1145.2629999999999}]
[null,null,null,{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":1},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":2},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":2},null,null,null,null,null,{"$f":"TEXT(IF(E9=1,G6+G8,E6-G6-G8)/IF(F9=2,12,1),\"£#,###.00\")","v":"£1,970.98"}]
[null,null,null,"earnings month/year","net pay/ded","final ans year/month"]
[null,null,null,"Annual Income",{"$f":"IF(Worksheet!$B$9,RANDBETWEEN(E12+100+$D$2,1.2*$D$3)/6,RANDBETWEEN(E12+100,E12-100+$D$2)/6)*6","v":19307},{"$f":"E11-E12","v":7847},{"$f":"IF(F11<$D$2,$E$2*F11,IF(F11<$D$3,$E$3*(F11-$D$2)+$E$2*$D$2,$D$2*$E$2+$D$3*$E$3+$E$4*(F11-$D$3)))","v":0},2,{"$f":"CONCATENATE(B12,\" \",B13,\" earns £\",TEXT(IF(D14=1,E11,E11/12),IF(AND(D14=2,E11/12<1000),\"######\",\"###,###\")),\" per \",IF(D14=1,\"year\",\"month\"),\" and has \",CHOOSE(RANDBETWEEN(1,2),\"a yearly\",\"an annual\"),\" personal tax allowance of £\",TEXT(E12,\"###,###\"),\".                                                                                                                                                                \",IF(Worksheet!$B$5,CONCATENATE(B12,\" also pays National Insurance at a rate of \",C13*100,\"% on all \",IF(F13=1,\"annual\",\"monthly\"),\" income over £\",IF(F13=1,TEXT(E13,\"###,###\"),TEXT(E13/12,IF(E13/12<1000,\"######\",\"###,###\"))),\".                                                                                                                                                                  \"),\"\"),CONCATENATE(\"Calculate \",B12,\"'s \",IF(F14=1,CHOOSE(RANDBETWEEN(1,2),\"yearly\",\"annual\"),\"monthly\"),IF(E14=1,IF(Worksheet!$B$5,\" total deductions\",\" tax\"),\" net pay\"),\".                                                                                                                                                                  \"))","v":"Jordan Thomas earns £19,307 per year and has a yearly personal tax allowance of £11,460.                                                                                                                                                                Jordan also pays National Insurance at a rate of 16.4% on all monthly income over £796.                                                                                                                                                                  Calculate Jordan's monthly total deductions.                                                                                                                                                                  "}]
[null,{"$f":"INDEX('SYSTEM FORMULAE 2'!A$2:A$201,RANDBETWEEN(1,200))","v":"Jordan"},null,"Tax Allowance",{"$f":"RANDBETWEEN(800/6,1300/6)*60","v":11460},"NI allowance month/ann"]
[null,{"$f":"INDEX('SYSTEM FORMULAE 2'!C$2:C$43,RANDBETWEEN(1,42))","v":"Thomas"},{"$f":"(RANDBETWEEN(5,20)+RANDBETWEEN(1,9)/10)/100","v":0.16399999999999998},"NI Allowance",{"$f":"E12/6*5","v":9550},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":2},{"$f":"IF(Worksheet!$B$5,(E11-E13)*C13,0)","v":1600.1479999999997}]
[null,null,null,{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":1},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":1},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":2},null,null,null,null,null,{"$f":"TEXT(IF(E14=1,G11+G13,E11-G11-G13)/IF(F14=2,12,1),\"£#,###.00\")","v":"£133.35"}]
[null,null,null,"earnings month/year","net pay/ded","final ans year/month"]
[null,null,null,"Annual Income",{"$f":"IF(Worksheet!$B$9,RANDBETWEEN(E17+100+$D$2,1.2*$D$3)/6,RANDBETWEEN(E17+100,E17-100+$D$2)/6)*6","v":10250},{"$f":"E16-E17","v":1310},{"$f":"IF(F16<$D$2,$E$2*F16,IF(F16<$D$3,$E$3*(F16-$D$2)+$E$2*$D$2,$D$2*$E$2+$D$3*$E$3+$E$4*(F16-$D$3)))","v":0},3,{"$f":"CONCATENATE(B17,\" \",B18,\" earns £\",TEXT(IF(D19=1,E16,E16/12),IF(AND(D19=2,E16/12<1000),\"######\",\"###,###\")),\" per \",IF(D19=1,\"year\",\"month\"),\" and has \",CHOOSE(RANDBETWEEN(1,2),\"a yearly\",\"an annual\"),\" personal tax allowance of £\",TEXT(E17,\"###,###\"),\".                                                                                                                                                                \",IF(Worksheet!$B$5,CONCATENATE(B17,\" also pays National Insurance at a rate of \",C18*100,\"% on all \",IF(F18=1,\"annual\",\"monthly\"),\" income over £\",IF(F18=1,TEXT(E18,\"###,###\"),TEXT(E18/12,IF(E18/12<1000,\"######\",\"###,###\"))),\".                                                                                                                                                                  \"),\"\"),CONCATENATE(\"Calculate \",B17,\"'s \",IF(F19=1,CHOOSE(RANDBETWEEN(1,2),\"yearly\",\"annual\"),\"monthly\"),IF(E19=1,IF(Worksheet!$B$5,\" total deductions\",\" tax\"),\" net pay\"),\".                                                                                                                                                                  \"))","v":"Alice Taylor earns £854 per month and has a yearly personal tax allowance of £8,940.                                                                                                                                                                Alice also pays National Insurance at a rate of 7.8% on all annual income over £7,450.                                                                                                                                                                  Calculate Alice's monthly net pay.                                                                                                                                                                  "}]
[null,{"$f":"INDEX('SYSTEM FORMULAE 2'!A$2:A$201,RANDBETWEEN(1,200))","v":"Alice"},null,"Tax Allowance",{"$f":"RANDBETWEEN(800/6,1300/6)*60","v":8940},"NI allowance month/ann"]
[null,{"$f":"INDEX('SYSTEM FORMULAE 2'!C$2:C$43,RANDBETWEEN(1,42))","v":"Taylor"},{"$f":"(RANDBETWEEN(5,20)+RANDBETWEEN(1,9)/10)/100","v":7.8E-2},"NI Allowance",{"$f":"E17/6*5","v":7450},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":1},{"$f":"IF(Worksheet!$B$5,(E16-E18)*C18,0)","v":218.4}]
[null,null,null,{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":2},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":2},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":2},null,null,null,null,null,{"$f":"TEXT(IF(E19=1,G16+G18,E16-G16-G18)/IF(F19=2,12,1),\"£#,###.00\")","v":"£835.97"}]
[null,null,null,"earnings month/year","net pay/ded","final ans year/month"]
[null,null,null,"Annual Income",{"$f":"IF(Worksheet!$B$9,RANDBETWEEN(E22+100+$D$2,1.2*$D$3)/6,RANDBETWEEN(E22+100,E22-100+$D$2)/6)*6","v":17879},{"$f":"E21-E22","v":9179},{"$f":"IF(F21<$D$2,$E$2*F21,IF(F21<$D$3,$E$3*(F21-$D$2)+$E$2*$D$2,$D$2*$E$2+$D$3*$E$3+$E$4*(F21-$D$3)))","v":0},4,{"$f":"CONCATENATE(B22,\" \",B23,\" earns £\",TEXT(IF(D24=1,E21,E21/12),IF(AND(D24=2,E21/12<1000),\"######\",\"###,###\")),\" per \",IF(D24=1,\"year\",\"month\"),\" and has \",CHOOSE(RANDBETWEEN(1,2),\"a yearly\",\"an annual\"),\" personal tax allowance of £\",TEXT(E22,\"###,###\"),\".                                                                                                                                                                \",IF(Worksheet!$B$5,CONCATENATE(B22,\" also pays National Insurance at a rate of \",C23*100,\"% on all \",IF(F23=1,\"annual\",\"monthly\"),\" income over £\",IF(F23=1,TEXT(E23,\"###,###\"),TEXT(E23/12,IF(E23/12<1000,\"######\",\"###,###\"))),\".                                                                                                                                                                  \"),\"\"),CONCATENATE(\"Calculate \",B22,\"'s \",IF(F24=1,CHOOSE(RANDBETWEEN(1,2),\"yearly\",\"annual\"),\"monthly\"),IF(E24=1,IF(Worksheet!$B$5,\" total deductions\",\" tax\"),\" net pay\"),\".                                                                                                                                                                  \"))","v":"Naomi Anderson earns £1,490 per month and has an annual personal tax allowance of £8,700.                                                                                                                                                                Naomi also pays National Insurance at a rate of 13.9% on all monthly income over £604.                                                                                                                                                                  Calculate Naomi's annual net pay.                                                                                                                                                                  "}]
[null,{"$f":"INDEX('SYSTEM FORMULAE 2'!A$2:A$201,RANDBETWEEN(1,200))","v":"Naomi"},null,"Tax Allowance",{"$f":"RANDBETWEEN(800/6,1300/6)*60","v":8700},"NI allowance month/ann"]
[null,{"$f":"INDEX('SYSTEM FORMULAE 2'!C$2:C$43,RANDBETWEEN(1,42))","v":"Anderson"},{"$f":"(RANDBETWEEN(5,20)+RANDBETWEEN(1,9)/10)/100","v":0.13900000000000001},"NI Allowance",{"$f":"E22/6*5","v":7250},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":2},{"$f":"IF(Worksheet!$B$5,(E21-E23)*C23,0)","v":1477.431}]
[null,null,null,{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":2},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":2},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":1},null,null,null,null,null,{"$f":"TEXT(IF(E24=1,G21+G23,E21-G21-G23)/IF(F24=2,12,1),\"£#,###.00\")","v":"£16,401.57"}]
[null,null,null,"earnings month/year","net pay/ded","final ans year/month"]
[null,null,null,"Annual Income",{"$f":"IF(Worksheet!$B$9,RANDBETWEEN(E27+100+$D$2,1.2*$D$3)/6,RANDBETWEEN(E27+100,E27-100+$D$2)/6)*6","v":18768},{"$f":"E26-E27","v":7128},{"$f":"IF(F26<$D$2,$E$2*F26,IF(F26<$D$3,$E$3*(F26-$D$2)+$E$2*$D$2,$D$2*$E$2+$D$3*$E$3+$E$4*(F26-$D$3)))","v":0},5,{"$f":"CONCATENATE(B27,\" \",B28,\" earns £\",TEXT(IF(D29=1,E26,E26/12),IF(AND(D29=2,E26/12<1000),\"######\",\"###,###\")),\" per \",IF(D29=1,\"year\",\"month\"),\" and has \",CHOOSE(RANDBETWEEN(1,2),\"a yearly\",\"an annual\"),\" personal tax allowance of £\",TEXT(E27,\"###,###\"),\".                                                                                                                                                                \",IF(Worksheet!$B$5,CONCATENATE(B27,\" also pays National Insurance at a rate of \",C28*100,\"% on all \",IF(F28=1,\"annual\",\"monthly\"),\" income over £\",IF(F28=1,TEXT(E28,\"###,###\"),TEXT(E28/12,IF(E28/12<1000,\"######\",\"###,###\"))),\".                                                                                                                                                                  \"),\"\"),CONCATENATE(\"Calculate \",B27,\"'s \",IF(F29=1,CHOOSE(RANDBETWEEN(1,2),\"yearly\",\"annual\"),\"monthly\"),IF(E29=1,IF(Worksheet!$B$5,\" total deductions\",\" tax\"),\" net pay\"),\".                                                                                                                                                                  \"))","v":"Kelsey Hall earns £1,564 per month and has an annual personal tax allowance of £11,640.                                                                                                                                                                Kelsey also pays National Insurance at a rate of 10.1% on all monthly income over £808.                                                                                                                                                                  Calculate Kelsey's monthly net pay.                                                                                                                                                                  "}]
[null,{"$f":"INDEX('SYSTEM FORMULAE 2'!A$2:A$201,RANDBETWEEN(1,200))","v":"Kelsey"},null,"Tax Allowance",{"$f":"RANDBETWEEN(800/6,1300/6)*60","v":11640},"NI allowance month/ann"]
[null,{"$f":"INDEX('SYSTEM FORMULAE 2'!C$2:C$43,RANDBETWEEN(1,42))","v":"Hall"},{"$f":"(RANDBETWEEN(5,20)+RANDBETWEEN(1,9)/10)/100","v":0.10099999999999999},"NI Allowance",{"$f":"E27/6*5","v":9700},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":2},{"$f":"IF(Worksheet!$B$5,(E26-E28)*C28,0)","v":915.86799999999994}]
[null,null,null,{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":2},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":2},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":2},null,null,null,null,null,{"$f":"TEXT(IF(E29=1,G26+G28,E26-G26-G28)/IF(F29=2,12,1),\"£#,###.00\")","v":"£1,487.68"}]
[null,null,null,"earnings month/year","net pay/ded","final ans year/month"]
[null,null,null,"Annual Income",{"$f":"IF(Worksheet!$B$9,RANDBETWEEN(E32+100+$D$2,1.2*$D$3)/6,RANDBETWEEN(E32+100,E32-100+$D$2)/6)*6","v":15522},{"$f":"E31-E32","v":3882},{"$f":"IF(F31<$D$2,$E$2*F31,IF(F31<$D$3,$E$3*(F31-$D$2)+$E$2*$D$2,$D$2*$E$2+$D$3*$E$3+$E$4*(F31-$D$3)))","v":0},6,{"$f":"CONCATENATE(B32,\" \",B33,\" earns £\",TEXT(IF(D34=1,E31,E31/12),IF(AND(D34=2,E31/12<1000),\"######\",\"###,###\")),\" per \",IF(D34=1,\"year\",\"month\"),\" and has \",CHOOSE(RANDBETWEEN(1,2),\"a yearly\",\"an annual\"),\" personal tax allowance of £\",TEXT(E32,\"###,###\"),\".                                                                                                                                                                \",IF(Worksheet!$B$5,CONCATENATE(B32,\" also pays National Insurance at a rate of \",C33*100,\"% on all \",IF(F33=1,\"annual\",\"monthly\"),\" income over £\",IF(F33=1,TEXT(E33,\"###,###\"),TEXT(E33/12,IF(E33/12<1000,\"######\",\"###,###\"))),\".                                                                                                                                                                  \"),\"\"),CONCATENATE(\"Calculate \",B32,\"'s \",IF(F34=1,CHOOSE(RANDBETWEEN(1,2),\"yearly\",\"annual\"),\"monthly\"),IF(E34=1,IF(Worksheet!$B$5,\" total deductions\",\" tax\"),\" net pay\"),\".                                                                                                                                                                  \"))","v":"Amy Mitchell earns £15,522 per year and has a yearly personal tax allowance of £11,640.                                                                                                                                                                Amy also pays National Insurance at a rate of 5.1% on all monthly income over £808.                                                                                                                                                                  Calculate Amy's yearly total deductions.                                                                                                                                                                  "}]
[null,{"$f":"INDEX('SYSTEM FORMULAE 2'!A$2:A$201,RANDBETWEEN(1,200))","v":"Amy"},null,"Tax Allowance",{"$f":"RANDBETWEEN(800/6,1300/6)*60","v":11640},"NI allowance month/ann"]
[null,{"$f":"INDEX('SYSTEM FORMULAE 2'!C$2:C$43,RANDBETWEEN(1,42))","v":"Mitchell"},{"$f":"(RANDBETWEEN(5,20)+RANDBETWEEN(1,9)/10)/100","v":5.0999999999999997E-2},"NI Allowance",{"$f":"E32/6*5","v":9700},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":2},{"$f":"IF(Worksheet!$B$5,(E31-E33)*C33,0)","v":296.92199999999997}]
[null,null,null,{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":1},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":1},{"$f":"IF(Worksheet!$B$10,1,RANDBETWEEN(1,2))","v":1},null,null,null,null,null,{"$f":"TEXT(IF(E34=1,G31+G33,E31-G31-G33)/IF(F34=2,12,1),\"£#,###.00\")","v":"£296.92"}]
[null,null,null,"earnings month/year","net pay/ded","final ans year/month"]

{"sheet":"SYSTEM FORMULAE 2","index":2,"n_rows":201,"n_cols":3,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
["Names","1998 baby names - http://www.statistics.gov.uk/statbase/Product.asp?vlnk=15282"]
["Jack",null,"Smith"]
["Thomas",null,"Wilson"]
["James",null,"Jones"]
["Daniel",null,"Campbell"]
["Josh",null,"Williams"]
["Matthew",null,"Brown"]
["Samuel",null,"Taylor"]
["Callum",null,"Kelly"]
["Joseph",null,"Davies"]
["Jordan",null,"Johnston"]
["Connor",null,"Evans"]
["Ryan",null,"Robertson"]
["Luke",null,"Moore"]
["William",null,"Thomas"]
["Harry",null,"Thomson"]
["Ben",null,"Roberts"]
["George",null,"Johnson"]
["Lewis",null,"Smyth"]
["Alexander",null,"Lewis"]
["Oliver",null,"Stewart"]
["Adam",null,"Anderson"]
["Jake",null,"Hughes"]
["Michael",null,"Scott"]
["Liam",null,"Wright"]
["Nathan",null,"Docherty"]
["Kieran",null,"Murray"]
["Jacob",null,"MacDonald"]
["Cameron",null,"Reid"]
["Ben",null,"Taylor"]
["Mohammed",null,"Clark"]
["Aaron",null,"Ross"]
["Christopher",null,"Young"]
["Bradley",null,"Mitchell"]
["Jamie",null,"Watson"]
["Charlie",null,"Paterson"]
["Brandon",null,"Morrison"]
["Robert",null,"Jackson"]
["Kyle",null,"Wood"]
["David",null,"Hall"]
["Owen",null,"Green"]
["Charles",null,"White"]
["Andrew",null,"Walker"]
["Reece",null,"Carlyle"]
["Edward",null,"Forbes"]
["Dylan",null,"Glen"]
["Alex",null,"Davidson"]
["Ethan",null,"McDonald"]
["Jonathan",null,"McGrath"]
["Sam",null,"MacInnes"]
["Louis"]
["Max"]
["Dominic"]
["John"]
["Ashley"]
["Rhys"]
["Henry"]
["Conor"]
["Joe"]
["Tyler"]
["Scott"]
["Sean"]
["Nick"]
["Ross"]
["Morgan"]
["Elliot"]
["Patrick"]
["Peter"]
["Billy"]
["Mark"]
["Stephen"]
["Alfie"]
["Harrison"]
["Lee"]
["Anthony"]
["Mitchell"]
["Joel"]
["Toby"]
["Paul"]
["Jay"]
["Jason"]
["Aidan"]
["Richard"]
["Mohammad"]
["Isaac"]
["Declan"]
["Josh"]
["Steven"]
["Marcus"]
["Muhammad"]
["Elliott"]
["Harvey"]
["Tom"]
["Christian"]
["Kane"]
["Shane"]
["Leon"]
["Shaun"]
["Corey"]
["Ellis"]
["Kai"]
["Natalie"]
["Abbie"]
["Francesca"]
["Melissa"]
["Katherine"]
["Harriet"]
["Imogen"]
["Jodie"]
["Gemma"]
["Kayleigh"]
["Lily"]
["Jennifer"]
["Kate"]
["Stephanie"]
["Daisy"]
["Niamh"]
["Millie"]
["Aimee"]
["Kirsty"]
["Hollie"]
["Rosie"]
["Jordan"]
["Mollie"]
["Alisha"]
["Mia"]
["Isobel"]
["Tia"]
["Ellen"]
["Erin"]
["Bethan"]
["Sian"]
["Alicia"]
["Rhiannon"]
["Ashleigh"]
["Catherine"]
["Madeleine"]
["Isabelle"]
["Kelsey"]
["Sophia"]
["Isabella"]
["Naomi"]
["Yasmin"]
["Freya"]
["Morgan"]
["Robyn"]
["Isabel"]
["Maisie"]
["Poppy"]
["Rachael"]
["Chantelle"]
["Chloe"]
["Emily"]
["Megan"]
["Jessica"]
["Sophie"]
["Charlotte"]
["Hannah"]
["Lauren"]
["Rebecca"]
["Lucy"]
["Amy"]
["Georgia"]
["Katie"]
["Bethany"]
["Emma"]
["Olivia"]
["Courtney"]
["Shannon"]
["Eleanor"]
["Jade"]
["Ellie"]
["Abigail"]
["Holly"]
["Molly"]
["Laura"]
["Alice"]
["Sarah"]
["Caitlin"]
["Rachel"]
["Elizabeth"]
["Amber"]
["Paige"]
["Georgina"]
["Danielle"]
["Grace"]
["Nicole"]
["Natasha"]
["Ella"]
["Chelsea"]
["Leah"]
["Victoria"]
["Anna"]
["Phoebe"]
["Samantha"]
["Zoe"]
["Alexandra"]
["Jasmine"]
["Amelia"]
["Louise"]
["Lydia"]