{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Wages_Money"],"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_Money","index":0,"n_rows":73,"n_cols":53,"rows_kept":73,"cut":false,"hidden":false,"merged":[[69,24,69,26],[12,25,12,28],[12,21,12,23],[31,18,31,20],[33,18,33,20],[38,18,38,20],[25,18,25,20],[26,12,26,17],[26,18,26,20],[38,15,38,16],[55,24,55,26],[55,13,55,15],[27,12,27,17],[1,1,5,42],[16,39,16,42],[19,8,19,9],[20,39,20,42],[8,21,8,23],[8,25,8,28],[25,12,25,17],[53,4,53,11],[55,9,55,11],[56,9,56,11],[55,4,55,8],[56,4,56,8],[30,18,30,20],[58,4,58,8],[53,12,53,27],[51,4,51,27],[58,9,58,11],[41,18,41,20],[27,18,27,20],[28,12,28,17],[28,18,28,20],[29,13,29,17],[29,18,29,20],[46,18,46,20],[39,15,39,16],[39,18,39,20],[40,15,40,16],[40,18,40,20],[42,13,42,17],[41,15,41,16],[14,51,14,52],[72,24,72,26],[70,24,70,26],[64,12,64,27],[66,14,66,19],[71,24,71,26],[56,24,56,26],[57,24,57,26],[68,24,68,26],[31,15,31,17],[42,18,42,20],[43,18,43,20],[44,15,44,17],[44,18,44,20]]}
[]
[null,"N5 Lifeskills - Money Matters 1 Practice                                                                                                                                                                                                                                             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()*(150-72)+75,1)","v":78.400000000000006},{"$f":"CONCATENATE(AZ7,\"0\")","v":"78.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()*(3-1)+1,0)*5","v":10}]
[null,null,null,{"$f":"\"Q1.   An office table costs £ \"&BA7&\" plus \"&AZ8&\" % VAT.\"","v":"Q1.   An office table costs £ 78.40 plus 10 % VAT."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"answer",null,null,"£",null,null,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(AZ7+AZ7*AZ8/100,2)","v":86.24}]
[null,null,null,null,"How much do I pay in total?",null,null,null,null,null,null,null,"( to the 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,null,null,null,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()*(150-72)+75,1)","v":94.6},{"$f":"CONCATENATE(AZ11,\"0\")","v":"94.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,null,null,null,null,null,{"$f":"ROUND(RAND()*(3-1)+1,0)*5","v":5}]
[null,null,null,{"$f":"\"Q2.  A DAB radio costs £ \"&BA11&\" plus \"&AZ12&\" % + VAT.\"","v":"Q2.  A DAB radio costs £ 94.60 plus 5 % + VAT."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"answer",null,null,"£",null,null,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+AZ11*AZ12/100,2)","v":99.33}]
[null,null,null,null,"How much do I pay in total?",null,null,null,null,null,null,null,"( to the 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,null,null,null,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()*(900-145)+145,0)","v":641}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(1.9-0.3)+0.3,1)*5","v":7.5}]
[null,null,null,{"$f":"\"Q3.  Sean has £\"&AZ15&\" in the bank . How much will he have next year if he earns \"&AZ16&\" % in interest. ( to the nearest penny)\"","v":"Q3.  Sean has £641 in the bank . How much will he have next year if he earns 7.5 % in interest. ( to the 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,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AZ15+AZ15*AZ16/100,2)","v":689.08}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(2900-2145)+2145,0)","v":2839}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(1.9-0.3)+0.3,1)*5","v":2.5}]
[null,null,null,{"$f":"\"Q4.  Laura has £ \"&AZ19&\" in the bank. How much will he have next year if he earns \"&AZ20&\" % in interest. ( to the nearest penny)\"","v":"Q4.  Laura has £ 2839 in the bank. How much will he have next year if he earns 2.5 % in interest. ( to the 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,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AZ19+AZ19*AZ20/100,2)","v":2909.98}]
[]
[]
[null,null,null,"Q5. 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.4}]
[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":0.9}]
[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":0.9}]
[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(S26:U29),2)","v":2.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"VAT @ \"&BA32&\" %\"","v":"VAT @ 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,{"$f":"ROUND(AZ30*BA32/100,2)","v":0.26}]
[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(AZ30+AZ31,2)","v":2.86},{"$f":"ROUND(RAND()*(3-1)+1,0)*5","v":10}]
[]
[null,null,null,{"$f":"\"(b)  How much change do I get from £\"&BA34&\".\"","v":"(b)  How much change do I get from £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,{"$f":"ROUND(BA34-AZ32,2)","v":2.14},{"$f":"ROUND(RAND()*(2-1)+1,0)*5","v":5}]
[]
[]
[null,null,null,"Q6. 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.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(P39*I39,2)","v":1.2}]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(6-2)+2,0)","v":4},"Cans of Juice @",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(P40*I40,2)","v":1.6}]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(6-2)+2,0)","v":3},"Pints of Milk @",null,null,null,null,null,{"$f":"ROUND(RAND()*(0.6-0.3)+0.3,1)","v":0.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,{"$f":"ROUND(P41*I41,2)","v":1.5}]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(10-2)+2,0)","v":4},"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(P42*I42,2)","v":0.8}]
[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(AZ39:AZ42),2)","v":5.0999999999999996},{"$f":"ROUND(RAND()*(3-1)+1,0)*5","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"VAT @ \"&BA43&\" %\"","v":"VAT @ 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,{"$f":"ROUND(AZ43*BA43/100,2)","v":0.51}]
[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(AZ43+AZ44,2)","v":5.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":"ROUND(RAND()*(2-1)+1,0)*10","v":10}]
[null,null,null,{"$f":"\"(b)  How much change to I get from £ \"&AZ46&\".\"","v":"(b)  How much change to 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,null,{"$f":"ROUND(AZ46-AZ45,2)","v":4.3899999999999997}]
[]
[]
[null,null,null,"Q7. Complete the Electricity bill below :"]
[]
[null,null,null,null,"MacFergus Scottish Electricity Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(8999-5001)+5001,0)","v":8989}]
[null,null,null,null,"Householder :- Mrs Bissett",null,null,null,null,null,null,null,"Period :- Jan 1st - March 30th 2010",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(1200-400)+400,0)","v":685}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,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":"AZ53-AZ54","v":8304}]
[null,null,null,null,"Present Reading",null,null,null,null,{"$f":"AZ53","v":8989},null,null,null,null,null,null,{"$f":"\"units at \"&AZ57&\" p / unit\"","v":"units at 15.2 p / unit"},null,null,null,null,null,null,null,null,null,null,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()*(8999-5001)+5001,0)","v":5364}]
[null,null,null,null,"Previous Reading",null,null,null,null,{"$f":"AZ55","v":8304},null,null,null,null,null,null,null,null,{"$f":"\"VAT @ \"&BA57&\" %\"","v":"VAT @ 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,{"$f":"ROUND(RAND()*(16.9-9.9)+9.9,1)","v":15.2},{"$f":"ROUND(RAND()*(9-6)+6,0)","v":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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AZ57*AZ54/100,2)","v":104.12}]
[null,null,null,null,"Units Used :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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*BA57/100,2)","v":6.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":"AZ58+AZ59","v":110.37}]
[]
[]
[null,null,"Q8. Part of the bill from Nathan's Garage Repairs is shown below. Complete the bill."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Nathan's Garage Repair Services"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Date :",null,{"$f":"NOW()","v":"2015-03-14T14:56:07.720"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,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()*(499.5-50.01)+50.01,2)","v":222.91}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parts",null,null,null,null,null,{"$f":"AZ68","v":222.91},null,null,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()*(499.5-50.01)+50.01,2)","v":313.58}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Labour",null,null,null,null,null,{"$f":"AZ69","v":313.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,{"$f":"AZ68+AZ69","v":536.49}]
[null,null,null,null,null,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,{"$f":"ROUND(AZ70*20/100,2)","v":107.3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAT @ 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,{"$f":"AZ70+AZ71","v":643.79}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,"£"]