{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Worksheet","SYSTEM FORMULAE 2","SYSTEM FORMULAE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Worksheet","index":0,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,3,0,8],[5,0,5,1]]}
[null,null,null,"Complete these weekly or monthly payslips and calculate the net pay"]
[]
[null,null,null,"Name","Employee number","Month","Date","Tax Code","NI Number"]
[null,null,null,"Ashleigh McGrath",14,3,"2023-06-23","506H","WM 35 97 12 B"]
[]
["Variables",null,null,"                                                  BASIC PAY",null,null,null,"                   DEDUCTIONS",null,9]
["SHOW ANSWERS",false,null,null,"Hourly wage","Hours worked","TOTAL",null,"TOTAL",10]
["Find totals",1,null,"Basic hours",8,15,120,"Tax",72.2,8]
["Some totals given",null,null,"Night shift",12,11,132,"National Insurance",32.799999999999997,9]
[null,null,null,"Evenings",16,7,112,"Pension",27.200000000000003]
[null,null,null,null,null,"GROSS PAY",364,"TOTAL DEDUCTIONS",132.19999999999999]
[]
[null,null,null,null,null,null,null,"NET PAY ",231.8]
[]
[null,null,null,"Name","Employee number","Month","Date","Tax Code","NI Number"]
[null,null,null,"Ellis Campbell",5621,1,"2023-04-23","407L","EH 51 69 33 D"]
[]
[null,null,null,"                                                  BASIC PAY",null,null,null,"                   DEDUCTIONS",null,22]
[null,null,null,null,"Hourly wage","Hours worked","TOTAL",null,"TOTAL",20]
[null,null,null,"Basic hours",10,20,200,"Tax",98,21]
[null,null,null,"Night shift",15,6,90,"National Insurance",44.2,22]
[null,null,null,"Evenings",20,10,200,"Pension",28.7]
[null,null,null,null,null,"GROSS PAY",490,"TOTAL DEDUCTIONS",170.89999999999998]
[]
[null,null,null,null,null,null,null,"NET PAY ",319.10000000000002]
[]
[null,null,null,"Name","Employee number","Week","Date","Tax Code","NI Number"]
[null,null,null,"Jay Mitchell",927445,12,"2023-03-24","484L","GK 69 13 37 A"]
[]
[null,null,null,"                                                  BASIC PAY",null,null,null,"                   DEDUCTIONS",null,34]
[null,null,null,null,"Hourly wage","Hours worked","TOTAL",null,"TOTAL",32]
[null,null,null,"Basic hours",17,29,493,"Tax",164.6,33]
[null,null,null,"Saturday",25.5,9,229.5,"National Insurance",74.599999999999994,32]
[null,null,null,"Sunday",34,3,102,"Pension",42.4]
[null,null,null,null,null,"GROSS PAY",824.5,"TOTAL DEDUCTIONS",281.59999999999997]
[]
[null,null,null,null,null,null,null,"NET PAY ",542.90000000000009]

{"sheet":"SYSTEM FORMULAE 2","index":1,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Name","Employee number",{"$f":"CHOOSE(RANDBETWEEN(1,2),\"Week\",\"Month\")","v":"Month"},"Date","Tax Code","NI Number"]
[null,null,null,{"$f":"CONCATENATE(INDEX('SYSTEM FORMULAE'!A$2:A$201,RANDBETWEEN(1,200)),INDEX('SYSTEM FORMULAE'!C$2:C$50,RANDBETWEEN(1,49)))","v":"Alfie Wright"},{"$f":"IF(RAND()<0.3,RANDBETWEEN(1,99),IF(RAND()<0.35,RANDBETWEEN(100,9999),RANDBETWEEN(10000,999999)))","v":242400},{"$f":"IF(F3=\"Month\",MOD(MONTH(G4)+9,12),WEEKNUM(G4))","v":1},{"$f":"TODAY()+RANDBETWEEN(-50,50)","v":"2023-04-02"},{"$f":"CONCATENATE(RANDBETWEEN(400,700),CHOOSE(RANDBETWEEN(1,2),\"H\",\"L\"))","v":"431H"},{"$f":"CONCATENATE(CHOOSE(RANDBETWEEN(1,20),\"A\",\"B\",\"C\",\"E\",\"G\",\"H\",\"J\",\"K\",\"L\",\"M\",\"N\",\"O\",\"P\",\"R\",\"S\",\"T\",\"W\",\"X\",\"Y\",\"Z\"),CHOOSE(RANDBETWEEN(1,20),\"A\",\"B\",\"C\",\"E\",\"G\",\"H\",\"J\",\"K\",\"L\",\"M\",\"N\",\"O\",\"P\",\"R\",\"S\",\"T\",\"W\",\"X\",\"Y\",\"Z\"),\" \",RANDBETWEEN(1,9),RANDBETWEEN(1,9),\" \",RANDBETWEEN(1,9),RANDBETWEEN(1,9),\" \",RANDBETWEEN(1,9),RANDBETWEEN(1,9),\" \",CHOOSE(RANDBETWEEN(1,4),\"A\",\"B\",\"C\",\"D\"))","v":"XJ 25 98 58 A"}]
[]
[null,null,null,"                                                  BASIC PAY",null,null,null,"                   DEDUCTIONS",null,{"$f":"IF(D10=\"\",\"\",3*ROW(G8)+3-J7-J8)","v":9}]
[null,null,null,null,"Hourly wage","Hours worked","TOTAL",null,"TOTAL",{"$f":"IF(D10=\"\",RANDBETWEEN(ROW(G8),ROW(G8)+1),RANDBETWEEN(ROW(G8),ROW(G8)+2))","v":8}]
[null,null,null,"Basic hours",{"$f":"RANDBETWEEN(6,20)","v":7},{"$f":"RANDBETWEEN(10,35)","v":21},{"$f":"E8*F8","v":147},"Tax",{"$f":"INT(0.2*G11)+0.1*RANDBETWEEN(0,9)","v":63.6},{"$f":"IF(D10=\"\",IF(J7=ROW(G8),ROW(G8)+1,ROW(G8)),IF(J7=ROW(G8),RANDBETWEEN(ROW(G8)+1,ROW(G8)+2),IF(J7=ROW(G8)+2,RANDBETWEEN(ROW(G8),ROW(G8)+1),CHOOSE(RANDBETWEEN(1,2),ROW(G8),ROW(G8)+2))))","v":10}]
[null,null,null,{"$f":"CHOOSE(RANDBETWEEN(1,3),\"Saturday\",\"Night shift\",\"Time-and-a-half\")","v":"Saturday"},{"$f":"1.5*E8","v":10.5},{"$f":"RANDBETWEEN(1,12)","v":12},{"$f":"E9*F9","v":126},"National Insurance",{"$f":"INT(0.09*G11)+0.1*RANDBETWEEN(0,9)","v":28.6},{"$f":"RANDBETWEEN(ROW(G8),ROW(G8)+2)","v":10}]
[null,null,null,{"$f":"IF(D9=\"Saturday\",\"Sunday\",IF(D9=\"Night shift\",CHOOSE(RANDBETWEEN(1,2),\"Evenings\",\"\"),\"Double time\"))","v":"Sunday"},{"$f":"IF(D10=\"\",\"\",2*E8)","v":14},{"$f":"IF(D10=\"\",\"\",RANDBETWEEN(1,12))","v":3},{"$f":"IF(D10=\"\",\"\",E10*F10)","v":42},"Pension",{"$f":"INT(0.05*G11)+0.1*RANDBETWEEN(0,99)","v":17.600000000000001}]
[null,null,null,null,null,"GROSS PAY",{"$f":"SUM(G8:G10)","v":315},"TOTAL DEDUCTIONS",{"$f":"SUM(I8:I10)","v":109.80000000000001}]
[]
[null,null,null,null,null,null,null,"NET PAY ",{"$f":"G11-I11","v":205.2}]
[]
[null,null,null,"Name","Employee number",{"$f":"CHOOSE(RANDBETWEEN(1,2),\"Week\",\"Month\")","v":"Month"},"Date","Tax Code","NI Number"]
[null,null,null,{"$f":"CONCATENATE(INDEX('SYSTEM FORMULAE'!A$2:A$201,RANDBETWEEN(1,200)),INDEX('SYSTEM FORMULAE'!C$2:C$43,RANDBETWEEN(1,42)))","v":"Ellis Morrison"},{"$f":"IF(RAND()<0.3,RANDBETWEEN(1,99),IF(RAND()<0.35,RANDBETWEEN(100,9999),RANDBETWEEN(10000,999999)))","v":2257},{"$f":"IF(F15=\"Month\",MOD(MONTH(G16)+9,12),WEEKNUM(G16))","v":2},{"$f":"TODAY()+RANDBETWEEN(-50,50)","v":"2023-05-11"},{"$f":"CONCATENATE(RANDBETWEEN(400,700),CHOOSE(RANDBETWEEN(1,2),\"H\",\"L\"))","v":"491L"},{"$f":"CONCATENATE(CHOOSE(RANDBETWEEN(1,20),\"A\",\"B\",\"C\",\"E\",\"G\",\"H\",\"J\",\"K\",\"L\",\"M\",\"N\",\"O\",\"P\",\"R\",\"S\",\"T\",\"W\",\"X\",\"Y\",\"Z\"),CHOOSE(RANDBETWEEN(1,20),\"A\",\"B\",\"C\",\"E\",\"G\",\"H\",\"J\",\"K\",\"L\",\"M\",\"N\",\"O\",\"P\",\"R\",\"S\",\"T\",\"W\",\"X\",\"Y\",\"Z\"),\" \",RANDBETWEEN(1,9),RANDBETWEEN(1,9),\" \",RANDBETWEEN(1,9),RANDBETWEEN(1,9),\" \",RANDBETWEEN(1,9),RANDBETWEEN(1,9),\" \",CHOOSE(RANDBETWEEN(1,4),\"A\",\"B\",\"C\",\"D\"))","v":"XR 63 73 99 B"}]
[]
[null,null,null,"                                                  BASIC PAY",null,null,null,"                   DEDUCTIONS",null,{"$f":"IF(D22=\"\",\"\",3*ROW(G20)+3-J19-J20)","v":20}]
[null,null,null,null,"Hourly wage","Hours worked","TOTAL",null,"TOTAL",{"$f":"IF(D22=\"\",RANDBETWEEN(ROW(G20),ROW(G20)+1),RANDBETWEEN(ROW(G20),ROW(G20)+2))","v":22}]
[null,null,null,"Basic hours",{"$f":"RANDBETWEEN(6,20)","v":15},{"$f":"RANDBETWEEN(10,35)","v":25},{"$f":"E20*F20","v":375},"Tax",{"$f":"INT(0.2*G23)+0.1*RANDBETWEEN(0,9)","v":120.6},{"$f":"IF(D22=\"\",IF(J19=ROW(G20),ROW(G20)+1,ROW(G20)),IF(J19=ROW(G20),RANDBETWEEN(ROW(G20)+1,ROW(G20)+2),IF(J19=ROW(G20)+2,RANDBETWEEN(ROW(G20),ROW(G20)+1),CHOOSE(RANDBETWEEN(1,2),ROW(G20),ROW(G20)+2))))","v":21}]
[null,null,null,{"$f":"CHOOSE(RANDBETWEEN(1,3),\"Saturday\",\"Night shift\",\"Time-and-a-half\")","v":"Saturday"},{"$f":"1.5*E20","v":22.5},{"$f":"RANDBETWEEN(1,12)","v":6},{"$f":"E21*F21","v":135},"National Insurance",{"$f":"INT(0.09*G23)+0.1*RANDBETWEEN(0,9)","v":54.1},{"$f":"RANDBETWEEN(ROW(G20),ROW(G20)+2)","v":22}]
[null,null,null,{"$f":"IF(D21=\"Saturday\",\"Sunday\",IF(D21=\"Night shift\",CHOOSE(RANDBETWEEN(1,2),\"Evenings\",\"\"),\"Double time\"))","v":"Sunday"},{"$f":"IF(D22=\"\",\"\",2*E20)","v":30},{"$f":"IF(D22=\"\",\"\",RANDBETWEEN(1,12))","v":3},{"$f":"IF(D22=\"\",\"\",E22*F22)","v":90},"Pension",{"$f":"INT(0.05*G23)+0.1*RANDBETWEEN(0,99)","v":36.6}]
[null,null,null,null,null,"GROSS PAY",{"$f":"SUM(G20:G22)","v":600},"TOTAL DEDUCTIONS",{"$f":"SUM(I20:I22)","v":211.29999999999998}]
[]
[null,null,null,null,null,null,null,"NET PAY ",{"$f":"G23-I23","v":388.70000000000005}]
[]
[null,null,null,"Name","Employee number",{"$f":"CHOOSE(RANDBETWEEN(1,2),\"Week\",\"Month\")","v":"Week"},"Date","Tax Code","NI Number"]
[null,null,null,{"$f":"CONCATENATE(INDEX('SYSTEM FORMULAE'!A$2:A$201,RANDBETWEEN(1,200)),INDEX('SYSTEM FORMULAE'!C$2:C$43,RANDBETWEEN(1,42)))","v":"Isabelle Paterson"},{"$f":"IF(RAND()<0.3,RANDBETWEEN(1,99),IF(RAND()<0.35,RANDBETWEEN(100,9999),RANDBETWEEN(10000,999999)))","v":6781},{"$f":"IF(F27=\"Month\",MOD(MONTH(G28)+9,12),WEEKNUM(G28))","v":12},{"$f":"TODAY()+RANDBETWEEN(-50,50)","v":"2023-03-20"},{"$f":"CONCATENATE(RANDBETWEEN(400,700),CHOOSE(RANDBETWEEN(1,2),\"H\",\"L\"))","v":"426H"},{"$f":"CONCATENATE(CHOOSE(RANDBETWEEN(1,20),\"A\",\"B\",\"C\",\"E\",\"G\",\"H\",\"J\",\"K\",\"L\",\"M\",\"N\",\"O\",\"P\",\"R\",\"S\",\"T\",\"W\",\"X\",\"Y\",\"Z\"),CHOOSE(RANDBETWEEN(1,20),\"A\",\"B\",\"C\",\"E\",\"G\",\"H\",\"J\",\"K\",\"L\",\"M\",\"N\",\"O\",\"P\",\"R\",\"S\",\"T\",\"W\",\"X\",\"Y\",\"Z\"),\" \",RANDBETWEEN(1,9),RANDBETWEEN(1,9),\" \",RANDBETWEEN(1,9),RANDBETWEEN(1,9),\" \",RANDBETWEEN(1,9),RANDBETWEEN(1,9),\" \",CHOOSE(RANDBETWEEN(1,4),\"A\",\"B\",\"C\",\"D\"))","v":"AJ 74 86 66 D"}]
[]
[null,null,null,"                                                  BASIC PAY",null,null,null,"                   DEDUCTIONS",null,{"$f":"IF(D34=\"\",\"\",3*ROW(G32)+3-J31-J32)","v":32}]
[null,null,null,null,"Hourly wage","Hours worked","TOTAL",null,"TOTAL",{"$f":"IF(D34=\"\",RANDBETWEEN(ROW(G32),ROW(G32)+1),RANDBETWEEN(ROW(G32),ROW(G32)+2))","v":33}]
[null,null,null,"Basic hours",{"$f":"RANDBETWEEN(6,20)","v":16},{"$f":"RANDBETWEEN(10,35)","v":21},{"$f":"E32*F32","v":336},"Tax",{"$f":"INT(0.2*G35)+0.1*RANDBETWEEN(0,9)","v":131.9},{"$f":"IF(D34=\"\",IF(J31=ROW(G32),ROW(G32)+1,ROW(G32)),IF(J31=ROW(G32),RANDBETWEEN(ROW(G32)+1,ROW(G32)+2),IF(J31=ROW(G32)+2,RANDBETWEEN(ROW(G32),ROW(G32)+1),CHOOSE(RANDBETWEEN(1,2),ROW(G32),ROW(G32)+2))))","v":34}]
[null,null,null,{"$f":"CHOOSE(RANDBETWEEN(1,3),\"Saturday\",\"Night shift\",\"Time-and-a-half\")","v":"Time-and-a-half"},{"$f":"1.5*E32","v":24},{"$f":"RANDBETWEEN(1,12)","v":12},{"$f":"E33*F33","v":288},"National Insurance",{"$f":"INT(0.09*G35)+0.1*RANDBETWEEN(0,9)","v":59.2},{"$f":"RANDBETWEEN(ROW(G32),ROW(G32)+2)","v":33}]
[null,null,null,{"$f":"IF(D33=\"Saturday\",\"Sunday\",IF(D33=\"Night shift\",CHOOSE(RANDBETWEEN(1,2),\"Evenings\",\"\"),\"Double time\"))","v":"Double time"},{"$f":"IF(D34=\"\",\"\",2*E32)","v":32},{"$f":"IF(D34=\"\",\"\",RANDBETWEEN(1,12))","v":1},{"$f":"IF(D34=\"\",\"\",E34*F34)","v":32},"Pension",{"$f":"INT(0.05*G35)+0.1*RANDBETWEEN(0,99)","v":41.1}]
[null,null,null,null,null,"GROSS PAY",{"$f":"SUM(G32:G34)","v":656},"TOTAL DEDUCTIONS",{"$f":"SUM(I32:I34)","v":232.20000000000002}]
[]
[null,null,null,null,null,null,null,"NET PAY ",{"$f":"G35-I35","v":423.79999999999995}]

{"sheet":"SYSTEM FORMULAE","index":2,"n_rows":201,"n_cols":3,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
["Names","1998 baby names - http://www.statistics.gov.uk/statbase/Product.asp?vlnk=15282"]
["Jack ",null,"Smith"]
["Thomas ",null,"Wilson"]
["James ",null,"Jones"]
["Daniel ",null,"Campbell"]
["Josh ",null,"Williams"]
["Matthew ",null,"Brown"]
["Samuel ",null,"Taylor"]
["Callum ",null,"Kelly"]
["Joseph ",null,"Davies"]
["Jordan ",null,"Johnston"]
["Connor ",null,"Evans"]
["Ryan ",null,"Robertson"]
["Luke ",null,"Moore"]
["William ",null,"Thomas"]
["Harry ",null,"Thomson"]
["Ben ",null,"Roberts"]
["George ",null,"Johnson"]
["Lewis ",null,"Smyth"]
["Alexander ",null,"Lewis"]
["Oliver ",null,"Stewart"]
["Adam ",null,"Anderson"]
["Jake ",null,"Hughes"]
["Michael ",null,"Scott"]
["Liam ",null,"Wright"]
["Nathan ",null,"Docherty"]
["Kieran ",null,"Murray"]
["Jacob ",null,"MacDonald"]
["Cameron ",null,"Reid"]
["Ben ",null,"Taylor"]
["Mohammed ",null,"Clark"]
["Aaron ",null,"Ross"]
["Christopher ",null,"Young"]
["Bradley ",null,"Mitchell"]
["Jamie ",null,"Watson"]
["Charlie ",null,"Paterson"]
["Brandon ",null,"Morrison"]
["Robert ",null,"Jackson"]
["Kyle ",null,"Wood"]
["David ",null,"Hall"]
["Owen ",null,"Green"]
["Charles ",null,"White"]
["Andrew ",null,"Walker"]
["Reece ",null,"Carlyle"]
["Edward ",null,"Forbes"]
["Dylan ",null,"Glen"]
["Alex ",null,"Davidson"]
["Ethan ",null,"McDonald"]
["Jonathan ",null,"McGrath"]
["Sam ",null,"MacInnes"]
["Louis "]
["Max "]
["Dominic "]
["John "]
["Ashley "]
["Rhys "]
["Henry "]
["Conor "]
["Joe "]
["Tyler "]
["Scott "]
["Sean "]
["Nick "]
["Ross "]
["Morgan "]
["Elliot "]
["Patrick "]
["Peter "]
["Billy "]
["Mark "]
["Stephen "]
["Alfie "]
["Harrison "]
["Lee "]
["Anthony "]
["Mitchell "]
["Joel "]
["Toby "]
["Paul "]
["Jay "]
["Jason "]
["Aidan "]
["Richard "]
["Mohammad "]
["Isaac "]
["Declan "]
["Josh "]
["Steven "]
["Marcus "]
["Muhammad "]
["Elliott "]
["Harvey "]
["Tom "]
["Christian "]
["Kane "]
["Shane "]
["Leon "]
["Shaun "]
["Corey "]
["Ellis "]
["Kai "]
["Natalie "]
["Abbie "]
["Francesca "]
["Melissa "]
["Katherine "]
["Harriet "]
["Imogen "]
["Jodie "]
["Gemma "]
["Kayleigh "]
["Lily "]
["Jennifer "]
["Kate "]
["Stephanie "]
["Daisy "]
["Niamh "]
["Millie "]
["Aimee "]
["Kirsty "]
["Hollie "]
["Rosie "]
["Jordan "]
["Mollie "]
["Alisha "]
["Mia "]
["Isobel "]
["Tia "]
["Ellen "]
["Erin "]
["Bethan "]
["Sian "]
["Alicia "]
["Rhiannon "]
["Ashleigh "]
["Catherine "]
["Madeleine "]
["Isabelle "]
["Kelsey "]
["Sophia "]
["Isabella "]
["Naomi "]
["Yasmin "]
["Freya "]
["Morgan "]
["Robyn "]
["Isabel "]
["Maisie "]
["Poppy "]
["Rachael "]
["Chantelle "]
["Chloe "]
["Emily "]
["Megan "]
["Jessica "]
["Sophie "]
["Charlotte "]
["Hannah "]
["Lauren "]
["Rebecca "]
["Lucy "]
["Amy "]
["Georgia "]
["Katie "]
["Bethany "]
["Emma "]
["Olivia "]
["Courtney "]
["Shannon "]
["Eleanor "]
["Jade "]
["Ellie "]
["Abigail "]
["Holly "]
["Molly "]
["Laura "]
["Alice "]
["Sarah "]
["Caitlin "]
["Rachel "]
["Elizabeth "]
["Amber "]
["Paige "]
["Georgina "]
["Danielle "]
["Grace "]
["Nicole "]
["Natasha "]
["Ella "]
["Chelsea "]
["Leah "]
["Victoria "]
["Anna "]
["Phoebe "]
["Samantha "]
["Zoe "]
["Alexandra "]
["Jasmine "]
["Amelia "]
["Louise "]
["Lydia "]