{"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":[[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],[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],[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],[1,1,5,42],[16,39,16,42],[20,39,20,42],[8,25,8,28],[24,18,24,21],[7,31,7,33],[7,25,7,28],[7,36,7,39],[12,25,12,28],[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],[33,19,33,21],[31,18,31,21],[8,36,8,39],[8,31,8,33],[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]]}
[]
[null,"N4 Lifeskills - Wages & Salaries                                                                                                                                                                   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,{"$f":"ROUND(RAND()*(9-5)+5,0)*5","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()*(20-8)+8,1)","v":19.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,null,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*AZ5","v":772}]
[null,null,null,{"$f":"\"Q1. Chris gets paid an hourly rate of £\"&TEXT(AZ6,\"0.00\")&\" as a mechanic.\"","v":"Q1. Chris gets paid an hourly rate of £19.30 as a mechanic."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly",null,null,null,null,null,"Monthly",null,null,null,null,"Annually"]
[null,null,null,null,{"$f":"\" He works \"&AZ5&\" hours a week.\"","v":" He works 40 hours a 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,{"$f":"AZ7","v":772}]
[null,null,null,null,{"$f":"\"Calculate his weekly, monthly and annual salary.\"","v":"Calculate his weekly, monthly and annual 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(AZ11/12,2)","v":3345.33}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"52*AZ9","v":40144}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":12.1}]
[null,null,null,{"$f":"\"Q2. Jordan gets paid annual salary of £\"&TEXT(BA14,\"0.00\")&\".\"","v":"Q2. Jordan gets paid annual salary of £16988.40."},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":12.1},{"$f":"ROUND(RAND()*(50-25)+25,0)","v":27}]
[null,null,null,null,{"$f":"\"He works \"&BA13&\" hours a week. Calculate his hourly rate.\"","v":"He works 27 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":16988.399999999998}]
[]
[]
[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 £16.40.   He gets £426.40 for 26 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":16.399999999999999},{"$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":426.4},{"$f":"IF(BB17=1,BA17,(BA17-0.1))","v":16.299999999999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":423.79999999999995},{"$f":"ROUND(RAND()*(50-25)+25,0)","v":26}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":10296},{"$f":"ROUND(RAND()*(18-8)+8,0)","v":9},{"$f":"ROUND(RAND()*(8-2)+2,0)","v":8}]
[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 8% increase in her annual salary. Her salary last year was £10296. 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":11119.68},{"$f":"ROUND(RAND()*(40-15)+15,0)","v":22}]
[]
[]
[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 £13.70. 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":13.7}]
[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":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monday",null,null,null,{"$f":"AZ25","v":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,{"$f":"ROUND(RAND()*(13-6)+6,0)","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tuesday",null,null,null,{"$f":"AZ26","v":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,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wednesday",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,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thursday",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,"Friday",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,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saturday",null,null,null,6,null,null,null,null,null,null,null,null,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":78}]
[]
[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":1068.5999999999999}]
[]
[]
[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.60."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.6},{"$f":"1.5*AZ38","v":9.8999999999999986}]
[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":2}]
[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":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,{"$f":"ROUND(RAND()*(8-5)+5,0)","v":7},{"$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,"Tuesday",null,null,null,{"$f":"AZ40","v":7},null,null,null,{"$f":"BA40","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,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,"Wednesday",null,null,null,7,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,6,{"$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,"Thursday",null,null,null,6,null,null,null,{"$f":"BA42","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,6,{"$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,6,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,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sunday",null,null,null,7,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":402.59999999999997},{"$f":"SUM(BA39:BA43)*BA38","v":128.69999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":531.29999999999995}]
[]
[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":1217.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":292.25}]
[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":170.48}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":36.53}]
[null,null,null,null,null,null,null,"Income",null,null,"Basic",null,{"$f":"AZ50","v":1217.7},null,null,"O/T",null,null,{"$f":"AZ52","v":170.48},null,null,"Bonus",null,null,{"$f":"AZ54","v":24.35},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":1412.53},null,null,null,{"$f":"ROUND(AZ50*ROUND(RAND()*(0.08-0.02)+0.02,2),2)","v":24.35}]
[null,null,null,null,null,null,null,"Deductions",null,null,"Tax",null,{"$f":"AZ51","v":292.25},null,null,"Nat. Ins.",null,null,{"$f":"AZ53","v":36.53},null,null,"Pension",null,null,{"$f":"AZ55","v":60.89},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":389.66999999999996},null,null,null,{"$f":"ROUND(AZ50*0.05,2)","v":60.89}]
[null,null,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":1022.86}]
[]
[]
[]
[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 £762.70 + 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":762.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(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 £37100 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":37100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":2246.6999999999998}]