{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Wages_Salaries"],"not_rendered":{"charts":0,"images":0,"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":"Wages_Salaries","index":0,"n_rows":63,"n_cols":54,"rows_kept":63,"cut":false,"hidden":false,"merged":[[26,18,26,21],[27,18,27,21],[28,18,28,21],[29,18,29,21],[30,18,30,21],[55,47,55,50],[61,35,61,37],[38,24,38,27],[39,24,39,27],[40,24,40,27],[41,24,41,27],[42,24,42,27],[44,24,44,27],[45,24,45,27],[45,37,45,39],[45,32,45,36],[54,47,54,50],[55,7,55,25],[55,30,55,32],[38,20,38,23],[39,20,39,23],[1,1,5,42],[16,39,16,42],[20,39,20,42],[24,18,24,21],[38,16,38,19],[7,24,7,29],[8,24,8,29],[9,24,9,29],[7,30,7,33],[8,30,8,33],[9,30,9,33],[25,18,25,21],[33,19,33,21],[31,18,31,21],[53,47,53,50],[52,7,52,32],[43,24,43,27],[53,30,53,32],[45,20,45,23],[53,7,53,9],[51,7,51,32],[54,7,54,9],[53,10,53,11],[54,10,54,11],[53,24,53,26],[54,24,54,26],[53,12,53,14],[54,12,54,14],[53,18,53,20],[54,18,54,20],[54,30,54,32],[61,33,61,34],[39,16,39,19],[40,16,40,19],[41,16,41,19],[42,16,42,19],[43,16,43,19],[44,16,44,19],[45,16,45,19],[42,20,42,23],[43,20,43,23],[44,20,44,23],[40,20,40,23],[41,20,41,23],[11,32,11,37],[11,38,11,41],[12,32,12,37],[12,38,12,41],[13,32,13,37],[13,38,13,41]]}
[]
[null,"N3 Lifeskills - Practice Assessment                                                                                                                                                                   Created by Mr.Lafferty@mathsrevision.com "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(AZ6=1,\"weekly\",\"monthly\")","v":"monthly"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BA6","v":"monthly"},{"$f":"ROUND(RAND()*(800-400)+400,1)","v":699.8}]
[null,null,null,{"$f":"\"Q1. (a) Joseph's \"&AZ7&\" wage-slip  is shown opposite.\"","v":"Q1. (a) Joseph's monthly wage-slip  is shown opposite."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross Pay",null,null,null,null,null,{"$f":"AZ8","v":2799.2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AZ6=2,BA8,BA7)","v":2799.2},{"$f":"4*BA7","v":2799.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deductions",null,null,null,null,null,{"$f":"AZ9","v":923.7},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(ROUND(RAND()*(0.35-0.27)+0.27,2)*AZ8,1)","v":923.7}]
[null,null,null,null,"Calculate his NET pay.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NET Pay",null,null,null,null,null,1993.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ8-AZ9","v":1875.4999999999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AZ6=1,\"week\",\"month\")","v":"month"}]
[null,null,null,{"$f":"\"       (b)  Joseph's sells cars and receives a bonus of £\"&AZ12&\" for every car he sells.\"","v":"       (b)  Joseph's sells cars and receives a bonus of £560 for every car he sells."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BONUS",null,null,null,null,null,2655,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AZ8/(BA12+1),0)","v":560},{"$f":"ROUND(RAND()*(9-4)+4,0)","v":4}]
[null,null,null,null,null,{"$f":"\"This \"&AZ11&\" he sells \"&BA12&\" cars.\"","v":"This month he sells 4 cars."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Tax @ \"&AZ13&\"%\"","v":"Tax @ 10%"},null,null,null,null,null,531,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(2-1)+1,0)*10","v":10},{"$f":"BA12*AZ12","v":2240}]
[null,null,null,null,null,{"$f":"\"He must pay tax on his bonus at a rate of \"&AZ13&\"%.   Fill in the bonus part of his wage-slip.\"","v":"He must pay tax on his bonus at a rate of 10%.   Fill in the bonus part of his wage-slip."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual Bonus",null,null,null,null,null,2124,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ13/100*BA13","v":224}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BA13-AZ14","v":2016}]
[]
[null,null,null,{"$f":"\"Q3. Lewis is promised an hourly rate of £\"&TEXT(BA17,\"0.00\")&\".   He gets £\"&TEXT(AZ18,\"0.00\")&\" for \"&BA19&\" hours work. Did he get his promised hourly rate.\"","v":"Q3. Lewis is promised an hourly rate of £8.20.   He gets £352.60 for 43 hours work. Did he get his promised hourly rate."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BB17=1,\"Yes\",\"No\")","v":"Yes"},{"$f":"ROUND(RAND()*(18-7.5)+7.5,1)","v":8.1999999999999993},{"$f":"ROUND(RAND()*(1-0)+0,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BA17*BA19","v":352.59999999999997},{"$f":"IF(BB17=1,BA17,(BA17-0.1))","v":8.1999999999999993}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BA18*BA19","v":352.59999999999997},{"$f":"ROUND(RAND()*(50-25)+25,0)","v":43}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BA20*BA21*52","v":23400},{"$f":"ROUND(RAND()*(18-8)+8,0)","v":18},{"$f":"ROUND(RAND()*(8-2)+2,0)","v":2}]
[null,null,null,{"$f":"\"Q4.   Laura gets a \"&BB20&\"% increase in her annual salary. Her salary last year was £\"&TEXT(AZ20,0)&\". What is her new salary.\"","v":"Q4.   Laura gets a 2% increase in her annual salary. Her salary last year was £23400. What is her new salary."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AZ20+AZ20*BB20/100,2)","v":23868},{"$f":"ROUND(RAND()*(40-15)+15,0)","v":25}]
[]
[]
[null,null,null,{"$f":"\"Q5. Andrew gets paid double time if he works the weekend. His normal hourly rate is £\"&TEXT(AZ24,\"0.00\")&\". Calculate his weekly wage.\"","v":"Q5. Andrew gets paid double time if he works the weekend. His normal hourly rate is £6.40. Calculate his weekly wage."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(20-6)+6,1)","v":6.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours Worked",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(13-6)+6,0)","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monday",null,null,null,{"$f":"AZ25","v":8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(13-6)+6,0)","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tuesday",null,null,null,{"$f":"AZ26","v":8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wednesday",null,null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thursday",null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Friday",null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saturday",null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sunday",null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AZ25:AZ31)+AZ31+AZ30","v":90}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly Salary £",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ32*AZ24","v":576}]
[]
[]
[null,null,null,{"$f":"\"Q6. Derek is paid 'time and half' if he works over 5pm during week days and 'double time' at weekends.\"","v":"Q6. Derek is paid 'time and half' if he works over 5pm during week days and 'double time' at weekends."}]
[null,null,null,null,{"$f":"\"Calculate his weekly wage if his hourly rate is £\"&TEXT(AZ38,\"0.00\")&\".\"","v":"Calculate his weekly wage if his hourly rate is £6.20."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(10-6)+6,1)","v":6.2},{"$f":"1.5*AZ38","v":9.3000000000000007}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Days",null,null,null,"Before 5pm",null,null,null,"After 5pm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(8-5)+5,0)","v":5},{"$f":"ROUND(RAND()*(4-0)+0,0)","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monday",null,null,null,{"$f":"AZ39","v":5},null,null,null,{"$f":"BA39","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(8-5)+5,0)","v":7},{"$f":"ROUND(RAND()*(4-0)+0,0)","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tuesday",null,null,null,{"$f":"AZ40","v":7},null,null,null,{"$f":"BA40","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"ROUND(RAND()*(4-0)+0,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wednesday",null,null,null,8,null,null,null,{"$f":"BA41","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"ROUND(RAND()*(4-0)+0,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thursday",null,null,null,8,null,null,null,{"$f":"BA42","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"ROUND(RAND()*(4-0)+0,0)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Friday",null,null,null,5,null,null,null,{"$f":"BA43","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saturday",null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sunday",null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,"Weekly Salary £  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AZ39:AZ45)+AZ45+AZ44","v":61}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ46*AZ38","v":378.2},{"$f":"SUM(BA39:BA43)*BA38","v":111.60000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ47+BA47+BB47","v":489.8}]
[]
[null,null,null,"Q7. Complete the Wage Slip below :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(1250-592)+592,1)","v":929.8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AZ50*ROUND(RAND()*(0.25-0.2)+0.2,2),2)","v":223.15}]
[null,null,null,null,null,null,null,"Name: Joe Bloggs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AZ50*ROUND(RAND()*(0.18-0.1)+0.1,2),2)","v":139.47}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AZ50*ROUND(RAND()*(0.04-0.02)+0.02,2),2)","v":27.89}]
[null,null,null,null,null,null,null,"Income",null,null,"Basic",null,{"$f":"AZ50","v":929.8},null,null,"O/T",null,null,{"$f":"AZ52","v":139.47},null,null,"Bonus",null,null,{"$f":"AZ54","v":37.19},null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ50+AZ52+AZ54","v":1106.46},null,null,null,{"$f":"ROUND(AZ50*ROUND(RAND()*(0.08-0.02)+0.02,2),2)","v":37.19}]
[null,null,null,null,null,null,null,"Deductions",null,null,"Tax",null,{"$f":"AZ51","v":223.15},null,null,"Nat. Ins.",null,null,{"$f":"AZ53","v":27.89},null,null,"Pension",null,null,{"$f":"AZ55","v":46.49},null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ51+AZ53+AZ55","v":297.53000000000003},null,null,null,{"$f":"ROUND(AZ50*0.05,2)","v":46.49}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net PAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AV54-AV55","v":808.93000000000006}]
[]
[]
[]
[null,null,null,{"$f":"\"Q8. Kerr the car salesperson gets a basic monthly wage of £\"&TEXT(AZ60,\"0.00\")&\" + \"&AZ61&\"% of the total value of the cars he sold.\"","v":"Q8. Kerr the car salesperson gets a basic monthly wage of £585.20 + 4% of the total value of the cars he sold."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(800-500)+500,1)","v":585.20000000000005}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(6-2)+2,0)","v":4}]
[null,null,null,null,{"$f":"\"Calculate his monthly wage if he sold £\"&TEXT(AZ62,0)&\" worth of cars.\"","v":"Calculate his monthly wage if he sold £39100 worth of cars."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"wage £",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(50000-15000)+15000,-2)","v":39100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ60+AZ62*AZ61/100","v":2149.1999999999998}]