{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Basic_Percentages","Harder_Percentages"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Basic_Percentages","index":0,"n_rows":93,"n_cols":54,"rows_kept":93,"cut":false,"hidden":false,"merged":[[92,18,92,20],[72,15,72,17],[72,18,72,20],[74,18,74,20],[89,32,89,34],[80,32,80,34],[83,32,83,34],[86,18,86,20],[77,32,77,34],[70,13,70,17],[70,18,70,20],[68,18,68,20],[69,15,69,16],[69,18,69,20],[71,18,71,20],[68,15,68,16],[67,15,67,16],[67,18,67,20],[59,18,59,20],[59,15,59,17],[55,12,55,17],[55,18,55,20],[56,12,56,17],[56,18,56,20],[57,18,57,20],[66,15,66,16],[66,18,66,20],[57,13,57,17],[58,18,58,20],[61,18,61,20],[43,35,43,38],[53,12,53,17],[53,18,53,20],[54,12,54,17],[54,18,54,20],[48,35,48,38],[21,18,21,21],[33,35,33,38],[38,35,38,38],[23,18,23,21],[25,18,25,21],[27,18,27,21],[13,18,13,21],[19,18,19,21],[15,18,15,21],[17,18,17,21],[11,18,11,21],[1,1,5,42],[7,16,7,17],[9,18,9,21]]}
[]
[null,"     Level 4+ Maths - Percentages                                                                                                                                                                   Created by Mr.Lafferty@mathsrevision.com "]
[]
[]
[]
[]
[]
[null,null,"Calculate the following percentages."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(949-567)+567),0)","v":857}]
[null,null,{"$f":"\"Q1.  10%   of   £\"&AZ9","v":"Q1.  10%   of   £857"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,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(AZ9/10,2)","v":85.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()*(949-567)+567),0)","v":567}]
[null,null,{"$f":"\"Q2.  50%   of   £\"&AZ11","v":"Q2.  50%   of   £567"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,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/2,2)","v":283.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":"ROUND((RAND()*(949-567)+567),0)","v":934}]
[null,null,{"$f":"\"Q3.  25%   of   £\"&AZ13","v":"Q3.  25%   of   £934"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,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(AZ13/4,2)","v":233.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":"ROUND((RAND()*(199-99)+99),0)*3","v":465}]
[null,null,{"$f":"\"Q4.  33 \"&BB16&\" %   of   £\"&AZ15","v":"Q4.  33 ⅓ %   of   £465"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,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":"AZ15/3","v":155},null,"⅓"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(89-69)+69),0)*5","v":420}]
[null,null,{"$f":"\"Q5.  20%   of   £\"&AZ17","v":"Q5.  20%   of   £420"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,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":"AZ17/5","v":84}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-6)+6),0)*20","v":180}]
[null,null,{"$f":"\"Q6.  5%   of   £\"&AZ19","v":"Q6.  5%   of   £180"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,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":"AZ19/20","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((RAND()*(19-9)+9),0)*6","v":102},null,"⅔"]
[null,null,{"$f":"\"Q7.  66 \"&BB21&\" %   of   £\"&AZ21","v":"Q7.  66 ⅔ %   of   £102"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,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":"AZ21/3*2","v":68}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(89-69)+69),0)*5","v":420}]
[null,null,{"$f":"\"Q8.  15%   of   £\"&AZ23","v":"Q8.  15%   of   £420"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,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":"AZ23*0.15","v":63}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(89-69)+69),0)*5","v":410},{"$f":"ROUND(RAND()*(9-3)+3,0)","v":9}]
[null,null,{"$f":"\"Q9.  \"&BA25&\"%   of   £\"&AZ25","v":"Q9.  9%   of   £410"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,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":"AZ25*BA25/100","v":36.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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((RAND()*(89-69)+69),0)*5","v":365},{"$f":"ROUND(RAND()*(9-3)+3,0)","v":6}]
[null,null,{"$f":"\"Q10.  \"&BA27&\"%   of   £\"&AZ27","v":"Q10.  6%   of   £365"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,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":"AZ27*BA27/100","v":21.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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(2-1)+1,0)*10","v":10}]
[null,null,{"$f":"\"Q11.  In a sale everything is reduced by \"&AZ31&\"%. How much is the discount if an item is priced at  £\"&TEXT(AZ32,\"0.00\")&\" before the sale.\"","v":"Q11.  In a sale everything is reduced by 10%. How much is the discount if an item is priced at  £79.31 before the sale."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(80.9-20.41)+20.41,2)","v":79.31}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( answer to nearest penny)",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(AZ31*AZ32/100,2)","v":7.93}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(2-1)+1,0)*10","v":20}]
[null,null,{"$f":"\"Q12.  In a sale everything is reduced by \"&AZ36&\"%. What is the sale price if an item is priced at  £\"&TEXT(AZ37,\"0.00\")&\" before the sale.\"","v":"Q12.  In a sale everything is reduced by 20%. What is the sale price if an item is priced at  £30.68 before the sale."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(80.9-20.41)+20.41,2)","v":30.68}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( answer to nearest penny)",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(AZ37-AZ36*AZ37/100,2)","v":24.54}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(3-1)+1,0)*20","v":40}]
[null,null,{"$f":"\"Q13.   A shop had a sale that gave \"&AZ41&\" % off everything.\"","v":"Q13.   A shop had a sale that gave 40 % off everything."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( answer to nearest penny)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(150-20)+20,0)","v":28}]
[]
[null,null,null,null,{"$f":"\" How much is the discount on an item that cost  £\"&AZ42&\" before the sale.\"","v":" How much is the discount on an item that cost  £28 before the sale."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AZ42*AZ41/100,2)","v":11.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,null,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()*(3-1)+1,0)*20","v":40}]
[null,null,{"$f":"\"Q14.  A shop had a sale that gave \"&AZ46&\"% off everything.\"","v":"Q14.  A shop had a sale that gave 40% off everything."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( answer to nearest penny)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(50.99-20.22)+20.99,2)","v":43.44}]
[]
[null,null,null,null,{"$f":"\"How much do I pay now for an item that was £\"&TEXT(AZ47,\"0.00\")&\" before the sale. \"","v":"How much do I pay now for an item that was £43.44 before the sale. "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AZ47-AZ47*AZ46/100,2)","v":26.06}]
[]
[]
[null,null,"Q15. Below is Natalie's shopping list. Calculate the total bill."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Milk",null,null,null,null,null,{"$f":"ROUND(RAND()*(0.5-0.25)+0.25,1)","v":0.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Newspaper",null,null,null,null,null,{"$f":"ROUND(RAND()*(0.9-0.39)+0.39,1)","v":0.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Bread",null,null,null,null,null,{"$f":"ROUND(RAND()*(1.2-0.85)+0.85,1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fruit",null,null,null,null,null,{"$f":"ROUND(RAND()*(1.3-0.7)+0.7,1)","v":1.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,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(2-1)+1,0)*10","v":20}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub - Total £",null,null,null,null,null,null,null,null,null,null,null,null,null,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(SUM(S54:U57),2)","v":3.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Discount @\"&AZ57&\"%\"","v":"Discount @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,{"$f":"ROUND(AZ58*AZ57/100,2)","v":0.64}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,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(AZ58-AZ59,2)","v":2.56}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(2-1)+1,0)*10","v":10}]
[null,null,null,null,{"$f":"\"How much change do I get from £\"&AZ61&\".\"","v":"How much change do I get from £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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AZ61-AZ60,2)","v":7.44}]
[]
[]
[null,null,"Q16. Below is part of a shopping list. Fill in the missing values and then calculate the total bill."]
[null,null,null,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()*(4-2)+2,0)","v":3},"Tin of Beans @",null,null,null,null,null,{"$f":"ROUND(RAND()*(0.6-0.2)+0.2,1)","v":0.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,{"$f":"ROUND(P67*I67,2)","v":0.9}]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(6-2)+2,0)","v":6},"Cans of Juice @",null,null,null,null,null,{"$f":"ROUND(RAND()*(0.6-0.3)+0.3,1)","v":0.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,null,null,null,{"$f":"ROUND(P68*I68,2)","v":3.6}]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(6-2)+2,0)","v":6},"Pints of Milk @",null,null,null,null,null,{"$f":"ROUND(RAND()*(0.6-0.3)+0.3,1)","v":0.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,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(P69*I69,2)","v":2.4}]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(10-2)+2,0)","v":6},"Rolls @",null,null,null,null,null,{"$f":"ROUND(RAND()*(0.2-0.1)+0.1,1)","v":0.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,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(P70*I70,2)","v":1.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub - Total £",null,null,null,null,null,null,null,null,null,null,null,null,null,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(SUM(AZ67:AZ70),2)","v":8.1},{"$f":"ROUND(RAND()*(2-1)+1,0)*10","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Discount @\"&BA71&\"%\"","v":"Discount @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,null,null,null,null,null,null,{"$f":"ROUND(AZ71*BA71/100,2)","v":0.81}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,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(AZ71-AZ72,2)","v":7.29}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(2-1)+1,0)*10","v":20}]
[null,null,null,null,{"$f":"\"How much change do I get from £\"&AZ74&\".\"","v":"How much change do I get from £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,{"$f":"ROUND(AZ74-AZ73,2)","v":12.71}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(210-70)+70,1)","v":203.5},{"$f":"ROUND(RAND()*(5-1)+1,0)*10","v":10}]
[null,null,{"$f":"\"Q17.   An item has increased in value by \"&BA77&\"% . It was £\"&TEXT(AZ77,\"0.00\")&\". What is the new price.\"","v":"Q17.   An item has increased in value by 10% . It was £203.50. What is the new price."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AZ77+AZ77*BA77/100,2)","v":223.85}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(500-129)+129,1)","v":209.3},{"$f":"ROUND(RAND()*(5-1)+1,0)*10","v":40}]
[null,null,{"$f":"\"Q18.   An item has decreased in value by \"&BA80&\"% . It was £\"&TEXT(AZ80,\"0.00\")&\". What is the new price.\"","v":"Q18.   An item has decreased in value by 40% . It was £209.30. What is the new price."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AZ80-AZ80*BA80/100,2)","v":125.58}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(45.99-20.69)+20.69,1)*2","v":66.2},{"$f":"ROUND(RAND()*(2-1)+1,0)*5","v":10}]
[null,null,{"$f":"\"Q19.   An electricity bill is  £\"&TEXT(AZ83,\"0.00\")&\"  + VAT @ \"&BA83&\"% . How much is the total cost.\"","v":"Q19.   An electricity bill is  £66.20  + VAT @ 10% . How much is the total cost."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AZ83+AZ83*BA83/100,2)","v":72.819999999999993}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"ROUNDUP(AZ84,-1)","v":80}]
[null,null,null,null,{"$f":"\"How much change to I get from £\"&AZ86&\".\"","v":"How much change to I get from £80."},null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,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(AZ86-AZ84,2)","v":7.18}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(25.99-15.69)+15.69,1)*2","v":45.4},{"$f":"ROUND(RAND()*(2-1)+1,0)*5","v":5}]
[null,null,{"$f":"\"Q20.  An internet deal is  £\"&TEXT(AZ89,\"0.00\")&\"  + VAT @ \"&BA89&\"% . How much is the total cost.\"","v":"Q20.  An internet deal is  £45.40  + VAT @ 5% . How much is the total cost."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AZ89+AZ89*BA89/100,2)","v":47.67}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"ROUNDUP(AZ90,-1)","v":50}]
[null,null,null,null,{"$f":"\"How much change to I get from £\"&AZ92&\".\"","v":"How much change to I get from £50."},null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,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(AZ92-AZ90,2)","v":2.33}]

{"sheet":"Harder_Percentages","index":1,"n_rows":39,"n_cols":52,"rows_kept":39,"cut":false,"hidden":false,"merged":[[23,25,23,33],[28,25,28,33],[1,1,5,42],[9,18,9,21],[11,18,11,21],[17,18,17,21],[13,18,13,21],[15,18,15,21],[38,35,38,38],[23,35,23,38],[28,35,28,38],[33,35,33,38],[31,33,31,41]]}
[]
[null,"     Level 4+ Maths - Percentages                                                                                                                                                                   Created by Mr.Lafferty@mathsrevision.com "]
[]
[]
[]
[]
[]
[null,null,"Calculate the following percentages to 2 decimal places."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(94-56)+56),0)*10","v":650}]
[null,null,{"$f":"\"Q1.   \"&AY10&\"%   of   £\"&AZ9","v":"Q1.   67.5%   of   £650"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,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()*(17.5-1)+1),1)*5","v":67.5},{"$f":"ROUND(AY10/100*AZ9,2)","v":438.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(94-56)+56),0)*10","v":880}]
[null,null,{"$f":"\"Q2.   \"&AY12&\"%   of   £\"&AZ11","v":"Q2.   35%   of   £880"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,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()*(16.5-1)+1),1)*5","v":35},{"$f":"ROUND(AY12/100*AZ11,2)","v":308}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(94-56)+56),0)*10","v":750}]
[null,null,{"$f":"\"Q3.   \"&AY14&\"%   of   £\"&AZ13","v":"Q3.   53%   of   £750"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,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()*(16.5-1)+1),1)*5","v":53},{"$f":"ROUND(AY14/100*AZ13,2)","v":397.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":"ROUND((RAND()*(94-56)+56),0)*10","v":700}]
[null,null,{"$f":"\"Q4.   \"&AY16&\"%   of   £\"&AZ15","v":"Q4.   78.5%   of   £700"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,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()*(16.5-1)+1),1)*5","v":78.5},{"$f":"ROUND(AY16/100*AZ15,2)","v":549.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":"ROUND((RAND()*(94-56)+56),0)*10","v":770}]
[null,null,{"$f":"\"Q5.   \"&AY18&\"%   of   £\"&AZ17","v":"Q5.   28.5%   of   £770"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,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()*(16.5-1)+1),1)*5","v":28.5},{"$f":"ROUND(AY18/100*AZ17,2)","v":219.45}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(7.5-1)+1),1)*5","v":34}]
[null,null,{"$f":"\"Q6.   In a sale everything is reduced by \"&AZ21&\"% .\"","v":"Q6.   In a sale everything is reduced by 34% ."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-20)+20,0)","v":697}]
[null,null,null,null,{"$f":"\"How much is the discount if an item is priced at  £\"&AZ22&\" before the sale.\"","v":"How much is the discount if an item is priced at  £697 before the sale."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( answer to nearest penny)",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(AZ22*AZ21/100,2)","v":236.98}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(7.5-1)+1),1)*5","v":23}]
[null,null,{"$f":"\"Q7.   In a sale everything is reduced by \"&AZ26&\"%.\"","v":"Q7.   In a sale everything is reduced by 23%."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-20)+20,0)","v":296}]
[null,null,null,null,{"$f":"\"What is the sale price if an item is priced at  £\"&AZ27&\" before the sale.\"","v":"What is the sale price if an item is priced at  £296 before the sale."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( answer to nearest penny)",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(AZ27-AZ27*AZ26/100,2)","v":227.92}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(7.5-1)+1),1)*5","v":17}]
[null,null,{"$f":"\"Q8.   A shop had a sale that gave \"&AZ31&\"% off everything.\"","v":"Q8.   A shop had a sale that gave 17% off everything."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( answer to nearest penny)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(7800-1000)+1000,-2)","v":5400}]
[]
[null,null,null,null,{"$f":"\" How much is the discount on an item that cost  £\"&AZ32&\" before the sale.\"","v":" How much is the discount on an item that cost  £5400 before the sale."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AZ32*AZ31/100,2)","v":918}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(7.5-1)+1),1)*5","v":6.5}]
[null,null,{"$f":"\"Q9.  A shop had a sale that gave \"&AZ36&\"% off everything.\"","v":"Q9.  A shop had a sale that gave 6.5% off everything."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( answer to nearest penny)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(5800-2000)+2000,-2)","v":3200}]
[]
[null,null,null,null,{"$f":"\" How much do I pay now for an item that was £\"&AZ37&\" before the sale.\"","v":" How much do I pay now for an item that was £3200 before the sale."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AZ37-AZ37*AZ36/100,2)","v":2992}]