{"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":[[33,19,33,21],[31,18,31,21],[26,18,26,21],[27,18,27,21],[28,18,28,21],[29,18,29,21],[30,18,30,21],[25,18,25,21],[12,20,12,23],[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],[8,25,8,28],[24,18,24,21],[7,25,7,28],[12,25,12,28],[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],[38,16,38,19],[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]]}
[]
[null,"N3 Lifeskills - Practice Questions                                                                                                                                                                   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,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-1)+1,0)*10","v":40},{"$f":"IF(AZ5=60,25,AZ5)","v":40}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(15-3)+3,0)*100","v":700}]
[]
[null,null,null,{"$f":"\"Q1. Joseph weekly wage is £\"&TEXT(AZ6,0)&\". His brother Luke earns \"&BA5&\"% more than him.\"","v":"Q1. Joseph weekly wage is £700. His brother Luke earns 40% more than him."}]
[null,null,null,null,{"$f":"\" How much does his brother earn each week ?\"","v":" How much does his brother earn each week ?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,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":"AZ6+(BA5/100*AZ6)","v":980}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-7.2)+7.2,1)","v":16.5}]
[null,null,null,{"$f":"\"Q2. Jordan gets paid annual salary of £\"&TEXT(BA14,\"0.00\")&\".\"","v":"Q2. Jordan gets paid annual salary of £37752.00."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,{"$f":"BA12","v":16.5},{"$f":"ROUND(RAND()*(50-25)+25,0)","v":44}]
[null,null,null,null,{"$f":"\"He works \"&BA13&\" hours a week. Calculate his hourly rate.\"","v":"He works 44 hours a week. Calculate his 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":"BA12*BA13*52","v":37752}]
[]
[]
[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 £13.60.   He gets £530.40 for 39 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":"No"},{"$f":"ROUND(RAND()*(18-7.5)+7.5,1)","v":13.6},{"$f":"ROUND(RAND()*(1-0)+0,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":530.4},{"$f":"IF(BB17=1,BA17,(BA17-0.1))","v":13.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":526.5},{"$f":"ROUND(RAND()*(50-25)+25,0)","v":39}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":9828},{"$f":"ROUND(RAND()*(18-8)+8,0)","v":9},{"$f":"ROUND(RAND()*(8-2)+2,0)","v":6}]
[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 6% increase in her annual salary. Her salary last year was £9828. 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":10417.68},{"$f":"ROUND(RAND()*(40-15)+15,0)","v":21}]
[]
[]
[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 £17.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":17.399999999999999}]
[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":12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tuesday",null,null,null,{"$f":"AZ26","v":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,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wednesday",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,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thursday",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,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Friday",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,8]
[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,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sunday",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,{"$f":"SUM(AZ25:AZ31)+AZ31+AZ30","v":86}]
[]
[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":1496.3999999999999}]
[]
[]
[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 £8.90."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":8.9},{"$f":"1.5*AZ38","v":13.350000000000001}]
[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":7},{"$f":"ROUND(RAND()*(4-0)+0,0)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monday",null,null,null,{"$f":"AZ39","v":7},null,null,null,{"$f":"BA39","v":3},null,null,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":1}]
[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":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":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wednesday",null,null,null,5,null,null,null,{"$f":"BA41","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"ROUND(RAND()*(4-0)+0,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thursday",null,null,null,7,null,null,null,{"$f":"BA42","v":0},null,null,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":4}]
[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":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,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saturday",null,null,null,7,null,null,null,null,null,null,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":57}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":507.3},{"$f":"SUM(BA39:BA43)*BA38","v":146.85000000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":654.15000000000009}]
[]
[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":1074.7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":247.18}]
[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":171.95}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":32.24}]
[null,null,null,null,null,null,null,"Income",null,null,"Basic",null,{"$f":"AZ50","v":1074.7},null,null,"O/T",null,null,{"$f":"AZ52","v":171.95},null,null,"Bonus",null,null,{"$f":"AZ54","v":32.24},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":1278.8900000000001},null,null,null,{"$f":"ROUND(AZ50*ROUND(RAND()*(0.08-0.02)+0.02,2),2)","v":32.24}]
[null,null,null,null,null,null,null,"Deductions",null,null,"Tax",null,{"$f":"AZ51","v":247.18},null,null,"Nat. Ins.",null,null,{"$f":"AZ53","v":32.24},null,null,"Pension",null,null,{"$f":"AZ55","v":53.74},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":333.16},null,null,null,{"$f":"ROUND(AZ50*0.05,2)","v":53.74}]
[null,null,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":945.73}]
[]
[]
[]
[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 £529.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":529.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 £27300 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":27300}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":1621.2}]