Spreadsheet: 767410d1644448175-age-based-wage-rate-calculation-age-based-wages
Sheet: Sheet1

First name | Date of birth | Age | Pay rate | should be |  | age | % | casual pay rate | 24.96 | regular pay rate
Abbey | 2006-02-16 00:00:00 |  | 11.23 |  |  |  |  | Mon-Sat | Sun | Mon-Sat | Sunday rate
Lucas | 2007-01-12 00:00:00 |  | 11.23 |  |  | >16 | 0.45
[NAME] | 2006-08-01 00:00:00 |  | 11.23 |  |  | 16 | 0.5
Angelica | 2005-10-06 00:00:00 |  | 12.48 |  |  | 17 | 0.6
Isabelle | 2005-03-01 00:00:00 |  | 12.48 |  |  | 18 | 0.7
[NAME] | 2005-09-30 00:00:00 |  | 11.23 |  |  | 19 | 0.8
Lachlan | 2005-07-20 00:00:00 |  | 12.48 |  |  | 20 | 1
Lola | 2005-05-17 00:00:00 |  | 12.48
Matilda | 2005-06-26 00:00:00 |  | 12.48
[NAME] | 2005-07-05 00:00:00 |  | 12.48
Nathan | 2005-06-21 00:00:00 |  | 12.48
[NAME] | 2005-08-08 00:00:00 |  | 12.48
Remy | 2005-11-28 00:00:00 |  | 11.23
Roc | 2005-10-23 00:00:00 |  | 12.48
Chloe | 2004-08-31 00:00:00 |  | 14.98
[NAME] | 2004-08-04 00:00:00 |  | 14.98
[NAME] | 2004-12-11 00:00:00 |  | 12.48
Molly | 2004-08-16 00:00:00 |  | 14.98
Saoirse | 2005-02-03 00:00:00 |  | 12.48
Sascha | 2005-01-05 00:00:00 |  | 12.48
Shyla | 2004-10-31 00:00:00 |  | 14.97
[NAME] | 2003-09-19 00:00:00 |  | 17.47
[NAME] | 2004-02-01 00:00:00 |  | 14.98
Manisha | 2002-03-03 00:00:00 |  | 24.96
Priyanka | 1991-03-12 00:00:00
Priyanka | 1991-03-12 00:00:00
Priyanka | 1991-03-12 00:00:00
Rajani | 1991-11-15 00:00:00
Rajani | 1991-11-15 00:00:00
Rajani | 1991-11-15 00:00:00
Rajani | 1991-11-15 00:00:00
Yogendra | 1991-07-23 00:00:00
Yogendra | 1991-07-23 00:00:00
Yogendra | 1991-07-23 00:00:00
Yogendra | 1991-07-23 00:00:00
Sanju | 1990-11-02 00:00:00 |  | 24.96
Sanju | 1990-11-02 00:00:00
Sanju | 1990-11-02 00:00:00
Sanju | 1990-11-02 00:00:00
Arjun | 1989-09-22 00:00:00 |  | 24.96
Nirajan | 1989-09-30 00:00:00 |  | 70000
Sabin | 1989-04-09 00:00:00 |  | 24.96
Som | 1989-07-23 00:00:00 |  | 24.96
Arjun | 1989-09-22 00:00:00
Arjun | 1989-09-22 00:00:00
Nirajan | 1989-09-30 00:00:00
Nirajan | 1989-09-30 00:00:00
Nirajan | 1989-09-30 00:00:00
Sabin | 1989-04-09 00:00:00
Sabin | 1989-04-09 00:00:00
Sabin | 1989-04-09 00:00:00
Sabin | 1989-04-09 00:00:00
Som | 1989-07-23 00:00:00
Som | 1989-07-23 00:00:00
Som | 1989-07-23 00:00:00
Som | 1989-07-23 00:00:00
Som | 1989-07-23 00:00:00
[NAME] | 1988-05-31 00:00:00 |  | 27.21
Sonya | 1988-08-22 00:00:00 |  | 82400
[NAME] | 1988-03-02 00:00:00 |  | 82400
Tsatsral | 1988-09-18 00:00:00 |  | 24.96
[NAME] | 1988-05-31 00:00:00
[NAME] | 1988-05-31 00:00:00
[NAME] | 1988-05-31 00:00:00
[NAME] | 1988-05-31 00:00:00
[NAME] | 1988-05-31 00:00:00
[NAME] | 1988-05-31 00:00:00
Sonya | 1988-08-22 00:00:00
Sonya | 1988-08-22 00:00:00
Sonya | 1988-08-22 00:00:00
[NAME] | 1988-03-02 00:00:00
[NAME] | 1988-03-02 00:00:00
[NAME] | 1988-03-02 00:00:00
[NAME] | 1988-03-02 00:00:00
Tsatsral | 1988-09-18 00:00:00
Tsatsral | 1988-09-18 00:00:00
[NAME] | 1987-05-25 00:00:00 |  | 75000
Keshav | 1987-11-26 00:00:00 |  | 100000
Kriti | 1988-02-02 00:00:00 |  | 24.24
Utsav Man | 1987-04-07 00:00:00 |  | 82000
[NAME] | 1987-10-06 00:00:00
[NAME] | 1987-05-25 00:00:00
[NAME] | 1987-05-25 00:00:00
[NAME] | 1987-05-25 00:00:00
[NAME] | 1987-05-25 00:00:00
[NAME] | 1987-05-25 00:00:00
Keshav | 1987-11-26 00:00:00
Keshav | 1987-11-26 00:00:00
Keshav | 1987-11-26 00:00:00
Keshav | 1987-11-26 00:00:00
Kriti | 1988-02-02 00:00:00
Kriti | 1988-02-02 00:00:00
Utsav Man | 1987-04-07 00:00:00
Utsav Man | 1987-04-07 00:00:00
Utsav Man | 1987-04-07 00:00:00
Utsav Man | 1987-04-07 00:00:00
Utsav Man | 1987-04-07 00:00:00
Utsav Man | 1987-04-07 00:00:00
Utsav Man | 1987-04-07 00:00:00
[NAME] | 1987-10-06 00:00:00
Deepak | 1987-02-07 00:00:00 |  | 100000
Guru | 1986-10-05 00:00:00 |  | 100000
[NAME] | 1986-07-24 00:00:00 |  | 24.96
Prajwal | 1986-07-27 00:00:00 |  | 85000
Prakash | 1986-04-11 00:00:00 |  | 82000
Rajeev | 1986-04-09 00:00:00 |  | 75000
Sabuj | 1986-05-11 00:00:00 |  | 75000
Deepak | 1987-02-07 00:00:00
Deepak | 1987-02-07 00:00:00
Deepak | 1987-02-07 00:00:00
Deepak | 1987-02-07 00:00:00
Guru | 1986-10-05 00:00:00
Guru | 1986-10-05 00:00:00
Guru | 1986-10-05 00:00:00
Guru | 1986-10-05 00:00:00
[NAME] | 1986-07-24 00:00:00
[NAME] | 1986-07-24 00:00:00
[NAME] | 1986-07-24 00:00:00
Prajwal | 1986-07-27 00:00:00
Prajwal | 1986-07-27 00:00:00
Prajwal | 1986-07-27 00:00:00
Prajwal | 1986-07-27 00:00:00
Prakash | 1986-04-11 00:00:00
Prakash | 1986-04-11 00:00:00
Prakash | 1986-04-11 00:00:00
Prakash | 1986-04-11 00:00:00
Rajeev | 1986-04-09 00:00:00
Rajeev | 1986-04-09 00:00:00
Rajeev | 1986-04-09 00:00:00
Sabuj | 1986-05-11 00:00:00
[NAME] | 1985-03-26 00:00:00 |  | 24.96
[NAME] | 1985-08-12 00:00:00 |  | 145000
[NAME] | 1985-06-02 00:00:00 |  | 85000
[NAME] | 1985-09-19 00:00:00 |  | 24.96
Leigh | 1985-08-24 00:00:00 |  | 72000
[NAME] | 1985-03-26 00:00:00
[NAME] | 1985-03-26 00:00:00
[NAME] | 1985-03-26 00:00:00
[NAME] | 1985-03-26 00:00:00
[NAME] | 1985-08-12 00:00:00
[NAME] | 1985-08-12 00:00:00
[NAME] | 1985-08-12 00:00:00
[NAME] | 1985-06-02 00:00:00
[NAME] | 1985-06-02 00:00:00
[NAME] | 1985-06-02 00:00:00
[NAME] | 1985-09-19 00:00:00
[NAME] | 1985-09-19 00:00:00
Leigh | 1985-08-24 00:00:00
Leigh | 1985-08-24 00:00:00
Leigh | 1985-08-24 00:00:00
Leigh | 1985-08-24 00:00:00
[NAME] | 1984-09-15 00:00:00 |  | 24.96
Myrsini | 1984-02-13 00:00:00 |  | 75000
[NAME] | 1984-09-15 00:00:00
[NAME] | 1984-09-15 00:00:00
[NAME] | 1984-09-15 00:00:00
Myrsini | 1984-02-13 00:00:00
Asmi | 1983-09-02 00:00:00 |  | 70000
Asmi | 1983-09-02 00:00:00
Asmi | 1983-09-02 00:00:00
Asmi | 1983-09-02 00:00:00
Asmi | 1983-09-02 00:00:00
Micah | 1981-05-31 00:00:00 |  | 24.96
Saroj | 1981-09-22 00:00:00 |  | 100000
Sujita | 1981-10-13 00:00:00 |  | 80000
Sunil | 1982-01-23 00:00:00 |  | 85000
Micah | 1981-05-31 00:00:00
Micah | 1981-05-31 00:00:00
Saroj | 1981-09-22 00:00:00
Saroj | 1981-09-22 00:00:00
Saroj | 1981-09-22 00:00:00
Saroj | 1981-09-22 00:00:00
Saroj | 1981-09-22 00:00:00
Saroj | 1981-09-22 00:00:00
Saroj | 1981-09-22 00:00:00
Sujita | 1981-10-13 00:00:00
Sujita | 1981-10-13 00:00:00
Sujita | 1981-10-13 00:00:00
Sujita | 1981-10-13 00:00:00
Sunil | 1982-01-23 00:00:00
Sunil | 1982-01-23 00:00:00
Sunil | 1982-01-23 00:00:00
Binod | 1980-10-12 00:00:00 |  | 74000
Marjorie | 1980-03-20 00:00:00 |  | 24.96
Narinder | 1981-01-17 00:00:00 |  | 23.53
[NAME] | 1980-03-10 00:00:00 |  | 24.96
Teerawit | 1980-09-30 00:00:00 |  | 26
Binod | 1980-10-12 00:00:00
Binod | 1980-10-12 00:00:00
Binod | 1980-10-12 00:00:00
Binod | 1980-10-12 00:00:00
Marjorie | 1980-03-20 00:00:00
Marjorie | 1980-03-20 00:00:00
Marjorie | 1980-03-20 00:00:00
Narinder | 1981-01-17 00:00:00
Narinder | 1981-01-17 00:00:00
[NAME] | 1980-03-10 00:00:00
[NAME] | 1980-03-10 00:00:00
Teerawit | 1980-09-30 00:00:00
Teerawit | 1980-09-30 00:00:00
Teerawit | 1980-09-30 00:00:00
Carmen | 1978-07-30 00:00:00 |  | 24.96
Pharadorn | 1978-04-22 00:00:00 |  | 70000
Carmen | 1978-07-30 00:00:00
Carmen | 1978-07-30 00:00:00
Pharadorn | 1978-04-22 00:00:00
Pharadorn | 1978-04-22 00:00:00
Pharadorn | 1978-04-22 00:00:00
Pharadorn | 1978-04-22 00:00:00
Salauni | 1975-11-11 00:00:00 |  | 24.96
Shradha | 1975-08-11 00:00:00 |  | 24.96
[NAME] | 1975-08-15 00:00:00 |  | 31
[NAME] | 1975-03-30 00:00:00 |  | 24.96
Salauni | 1975-11-11 00:00:00
Salauni | 1975-11-11 00:00:00
Salauni | 1975-11-11 00:00:00
Salauni | 1975-11-11 00:00:00
Shradha | 1975-08-11 00:00:00
Shradha | 1975-08-11 00:00:00
Shradha | 1975-08-11 00:00:00
[NAME] | 1975-08-15 00:00:00
[NAME] | 1975-08-15 00:00:00
[NAME] | 1975-08-15 00:00:00
[NAME] | 1975-08-15 00:00:00
[NAME] | 1975-03-30 00:00:00
[NAME] | 1975-03-30 00:00:00
Wahyu | 1973-09-20 00:00:00 |  | 79310
Wahyu | 1973-09-20 00:00:00
Wahyu | 1973-09-20 00:00:00
[NAME] | 1970-10-23 00:00:00 |  | 38625
[NAME] | 1970-10-23 00:00:00
[NAME] | 1970-10-23 00:00:00
[NAME] | 1970-10-23 00:00:00
[NAME] | 1970-10-23 00:00:00
Shayne | 1969-03-18 00:00:00 |  | 24.96
Shayne | 1969-03-18 00:00:00
[NAME] | 1964-04-19 00:00:00 |  | 24.96
[NAME] | 1964-04-19 00:00:00
[NAME] | 1964-04-19 00:00:00
[NAME] | 1964-04-19 00:00:00
Kai | 1963-06-03 00:00:00 |  | 25.55
Kai | 1963-06-03 00:00:00
Kai | 1963-06-03 00:00:00
Kai | 1963-06-03 00:00:00
Maral | 1960-02-14 00:00:00 |  | 100000
Maral | 1960-02-14 00:00:00
Suzanne | 1956-11-23 00:00:00 |  | 100000
Suzanne | 1956-11-23 00:00:00
Suzanne | 1956-11-23 00:00:00
[NAME]
[NAME]