Spreadsheet: 600373d1543647575-goal-seek-to-find-nearest-answer-20181115-upload-to-ef2
Sheet: Payroll Test

 |  |  |  | -139312
` | Employee Code | Date Engaged | Minimum wage | Surplus over minimum wage | Seniority actual | Base salary for tax 1 | Tax 1 (flat 3.5%) | Base salary for tax 2 | No. of eligible dependants | Dependants  relief | Tax 2 | Net salary tax 2 | Family allowance p/m | Housing allowance p/m | Transport allowance p/m | Total net pay (local) |  | Total net pay (local) | Taux | Total [NAME]
 | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1660
 | 1 | 2012-10-23 00:00:00 | 183950 | 72150.3671510449 | 10483 |  |  |  | 7 |  |  |  |  | 24625 | 41600 |  |  |  |  | 203
 | 2 | 2013-06-03 00:00:00 | 673257 | -126673.1865284974 | 31974 |  |  |  | 7 |  |  |  |  | 58570 | 62400 |  |  |  |  | 380
 | 5 | 2013-09-13 00:00:00 | 673257 |  | 31974 |  |  |  | 6 |  |  |  |  | 57213 | 62400 |  |  |  |  | 368
 | 6 | 2013-09-17 00:00:00 | 673257 |  | 31974 |  |  |  | 0 |  |  |  |  | 83218 | 62400 |  |  |  |  | 455
 | 8 | 2013-11-20 00:00:00 | 673257 |  | 31974 |  |  |  | 7 |  |  |  |  | 70933 | 62400 |  |  |  |  | 436.5
 | 9 | 2014-01-09 00:00:00 | 244653.5 |  | 9293 |  |  |  | 5 |  |  |  |  | 31247 | 41600 |  |  |  |  | 217.5
 | 10 | 2014-01-20 00:00:00 | 244653.5 |  | 9293 |  |  |  | 1 |  |  |  |  | 33337 | 41600 |  |  |  |  | 211.5
 | 11 | 2014-01-23 00:00:00 | 244653.5 |  | 9293 |  |  |  | 2 |  |  |  |  | 32191 | 41600 |  |  |  |  | 211.5
 | 12 | 2014-03-10 00:00:00 | 378937 |  | 14397 |  |  |  | 9 |  |  |  |  | 37378 | 41600 |  |  |  |  | 265.5
 | 13 | 2014-03-10 00:00:00 | 435961.5 |  | 16565 |  |  |  | 7 |  |  |  |  | 63570 | 41600 |  |  |  |  | 373.5
 | 14 | 2014-05-21 00:00:00 | 283283 |  | 10761 |  |  |  | 7 |  |  |  |  | 31255 | 41600 |  |  |  |  | 227.5
 | 15 | 2014-05-21 00:00:00 | 435961.5 |  | 16565 |  |  |  | 7 |  |  |  |  | 58594 | 41600 |  |  |  |  | 351
 | 17 | 2014-10-13 00:00:00 | 244653.5 |  | 9293 |  |  |  | 6 |  |  |  |  | 32495 | 41600 |  |  |  |  | 228.5
 | 19 | 2014-10-20 00:00:00 | 244653.5 |  | 9293 |  |  |  | 7 |  |  |  |  | 30763 | 41600 |  |  |  |  | 225.5
 | 20 | 2014-10-21 00:00:00 | 435961.5 |  | 16565 |  |  |  | 6 |  |  |  |  | 57736 | 41600 |  |  |  |  | 342
 | 21 | 2014-10-21 00:00:00 | 776269 |  | 29494 |  |  |  | 1 |  |  |  |  | 128209 | 62400 |  |  |  |  | 639.5
 | 22 | 2014-10-23 00:00:00 | 244653.5 |  | 9293 |  |  |  | 8 |  |  |  |  | 28977 | 41600 |  |  |  |  | 222
 | 23 | 2014-11-11 00:00:00 | 327431 |  | 12438 |  |  |  | 5 |  |  |  |  | 34414 | 41600 |  |  |  |  | 231.5
 | 25 | 2014-11-18 00:00:00 | 583121.5 |  | 22156 |  |  |  | 0 |  |  |  |  | 60614 | 41600 |  |  |  |  | 325.5
 | 27 | 2014-12-12 00:00:00 | 776269 |  | 22120 |  |  |  | 0 |  |  |  |  | 103880 | 62400 |  |  |  |  | 523
 | 28 | 2014-12-12 00:00:00 | 244653.5 |  | 6970 |  |  |  | 8 |  |  |  |  | 31957 | 41600 |  |  |  |  | 232.5
 | 29 | 2015-02-24 00:00:00 | 673257 |  | 19184 |  |  |  | 0 |  |  |  |  | 79365 | 62400 |  |  |  |  | 420.5
 | 30 | 2015-03-14 00:00:00 | 244653.5 |  | 6970 |  |  |  | 3 |  |  |  |  | 38080 | 41600 |  |  |  |  | 234
 | 31 | 2015-03-14 00:00:00 | 244653.5 |  | 6970 |  |  |  | 9 |  |  |  |  | 29578 | 41600 |  |  |  |  | 226.5
 | 32 | 2013-08-15 00:00:00 | 1962699.96 |  | 112000 |  |  |  | 2 |  |  |  |  | 168000 | 0 |  |  |  |  | 766.5
 | 36 | 2015-09-15 00:00:00 | 244653.5 |  | 6970 |  |  |  | 9 |  |  |  |  | 39835 | 41600 |  |  |  |  | 273
 | 37 | 2015-08-24 00:00:00 | 327431 |  | 9328 |  |  |  | 3 |  |  |  |  | 44374 | 41600 |  |  |  |  | 256
 | 38 | 2015-08-24 00:00:00 | 378937 |  | 10798 |  |  |  | 1 |  |  |  |  | 49406 | 41600 |  |  |  |  | 272.5
 | 39 | 2015-09-15 00:00:00 | 244653.5 |  | 6970 |  |  |  | 3 |  |  |  |  | 38470 | 41600 |  |  |  |  | 229.5
 | 40 | 2015-06-01 00:00:00 | 897676 |  | 25577 |  |  |  | 4 |  |  |  |  | 340564 | 62400 |  |  |  |  | 1632.5
 | 41 | 2015-01-02 00:00:00 | 673257 |  | 19184 |  |  |  | 4 |  |  |  |  | 55606 | 62400 |  |  |  |  | 334
 | 42 | 2013-10-08 00:00:00 | 897676 |  | 42629 |  |  |  | 1 |  |  |  |  | 274973 | 62400 |  |  |  |  | 1265
 | 44 | 2014-01-02 00:00:00 | 283283 |  | 10761 |  |  |  | 7 |  |  |  |  | 27830 | 41600 |  |  |  |  | 211.5
 | 45 | 2008-06-05 00:00:00 | 897676 |  | 85259 |  |  |  | 5 |  |  |  |  | 237939 | 62400 |  |  |  |  | 1270
 | 46 | 2015-12-07 00:00:00 | 244653.5 |  | 4646 |  |  |  | 9 |  |  |  |  | 33475 | 41600 |  |  |  |  | 234
 | 47 | 2015-12-07 00:00:00 | 244653.5 |  | 4646 |  |  |  | 2 |  |  |  |  | 39842 | 41600 |  |  |  |  | 230.5
 | 48 | 2015-12-07 00:00:00 | 244653.5 |  | 4646 |  |  |  | 2 |  |  |  |  | 39842 | 41600 |  |  |  |  | 230.5
 | 51 | 2010-04-01 00:00:00 | 1962699.96 |  | 179200 |  |  |  | 1 |  |  |  |  | 382968 | 62400 |  |  |  |  | 1790
 | 54 | 2016-01-11 00:00:00 | 378937 |  | 7198 |  |  |  | 7 |  |  |  |  | 44288 | 41600 |  |  |  |  | 271.5
 | 58 | 2015-05-19 00:00:00 | 283283 |  | 8071 |  |  |  | 2 |  |  |  |  | 39736 | 41600 |  |  |  |  | 230
 | 60 | 2016-01-26 00:00:00 | 244653.5 |  | 4646 |  |  |  | 0 |  |  |  |  | 39842 | 41600 |  |  |  |  | 220
 | 62 | 2016-01-26 00:00:00 | 244653.5 |  | 4646 |  |  |  | 0 |  |  |  |  | 39842 | 41600 |  |  |  |  | 220
 | 64 | 2016-03-02 00:00:00 | 1962699.96 |  | 44800 |  |  |  | 4 |  |  |  |  | 1323352 | 62400 |  |  |  |  | 5144
 | 66 | 2016-04-20 00:00:00 | 673257 |  | 12789 |  |  |  | 5 |  |  |  |  | 156047 | 62400 |  |  |  |  | 751
 | 67 | 2016-06-27 00:00:00 | 244653.5 |  | 4646 |  |  |  | 4 |  |  |  |  | 39733 | 41600 |  |  |  |  | 236
 | 68 | 2016-06-27 00:00:00 | 244653.5 |  | 4646 |  |  |  | 5 |  |  |  |  | 35966 | 41600 |  |  |  |  | 224.5
 | 69 | 2016-06-27 00:00:00 | 244653.5 |  | 4646 |  |  |  | 4 |  |  |  |  | 38470 | 41600 |  |  |  |  | 230.5
 | 70 | 2016-06-27 00:00:00 | 327431 |  | 6219 |  |  |  | 3 |  |  |  |  | 43111 | 41600 |  |  |  |  | 245
 | 71 | 2016-06-27 00:00:00 | 244653.5 |  | 4646 |  |  |  | 4 |  |  |  |  | 37214 | 41600 |  |  |  |  | 224.5
 | 72 | 2016-06-27 00:00:00 | 244653.5 |  | 4646 |  |  |  | 3 |  |  |  |  | 37214 | 41600 |  |  |  |  | 219.5
 | 73 | 2016-06-27 00:00:00 | 327431 |  | 6219 |  |  |  | 2 |  |  |  |  | 45739 | 41600 |  |  |  |  | 256
 | 74 | 2016-07-30 00:00:00 | 435961.5 |  | 8282 |  |  |  | 9 |  |  |  |  | 75161 | 41600 |  |  |  |  | 429
 | 87 | 2016-09-26 00:00:00 | 673257 |  | 12789 |  |  |  | 0 |  |  |  |  | 155641 | 62400 |  |  |  |  | 749.5
 | 88 | 2016-09-26 00:00:00 | 673257 |  | 12789 |  |  |  | 5 |  |  |  |  | 149027 | 62400 |  |  |  |  | 748.5
 | 89 | 2016-09-26 00:00:00 | 435961.5 |  | 8282 |  |  |  | 0 |  |  |  |  | 88600 | 41600 |  |  |  |  | 433
 | 90 | 2017-02-06 00:00:00 | 673257 |  | 6394 |  |  |  | 0 |  |  |  |  | 83335 | 62400 |  |  |  |  | 421.5
 | 92 | 2017-02-06 00:00:00 | 244653.5 |  | 2323 |  |  |  | 3 |  |  |  |  | 37518 | 41600 |  |  |  |  | 216
 | 94 | 2017-02-06 00:00:00 | 244653.5 |  | 2323 |  |  |  | 6 |  |  |  |  | 33774 | 41600 |  |  |  |  | 215.5
 | 96 | 2017-03-21 00:00:00 | 776269 |  | 7373 |  |  |  | 2 |  |  |  |  | 159861 | 62400 |  |  |  |  | 729
 | 97 | 2017-06-09 00:00:00 | 183950 |  | 1747 |  |  |  | 4 |  |  |  |  | 27947 | 41600 |  |  |  |  | 180
 | 98 | 2017-06-09 00:00:00 | 244653.5 |  | 2323 |  |  |  | 3 |  |  |  |  | 40045 | 41600 |  |  |  |  | 227
 | 99 | 2017-06-09 00:00:00 | 244653.5 |  | 2323 |  |  |  | 0 |  |  |  |  | 40154 | 41600 |  |  |  |  | 216.5
 | 100 | 2017-06-09 00:00:00 | 244653.5 |  | 2323 |  |  |  | 3 |  |  |  |  | 40045 | 41600 |  |  |  |  | 227
 | 101 | 2017-06-09 00:00:00 | 244653.5 |  | 2323 |  |  |  | 2 |  |  |  |  | 40147 | 41600 |  |  |  |  | 227
 | 102 | 2017-06-09 00:00:00 | 244653.5 |  | 2323 |  |  |  | 6 |  |  |  |  | 40045 | 41600 |  |  |  |  | 243
 | 103 | 2017-06-09 00:00:00 | 244653.5 |  | 2323 |  |  |  | 3 |  |  |  |  | 37518 | 41600 |  |  |  |  | 216
 | 105 | 2017-06-09 00:00:00 | 244653.5 |  | 2323 |  |  |  | 3 |  |  |  |  | 37518 | 41600 |  |  |  |  | 216
 | 106 | 2017-06-21 00:00:00 | 1962699.96 |  | 22400 |  |  |  | 5 |  |  |  |  | 941659 | 62400 |  |  |  |  | 3606
 | 108 | 2017-08-21 00:00:00 | 1197514.5 |  | 11374 |  |  |  | 0 |  |  |  |  | 531461 | 62400 |  |  |  |  | 2047.5
 | 110 | 2017-10-21 00:00:00 | 673257 |  | 6394 |  |  |  | 0 |  |  |  |  | 83897 | 62400 |  |  |  |  | 421
 | 111 | 2017-10-21 00:00:00 | 1962699.96 |  | 22400 |  |  |  | 2 |  |  |  |  | 531324 | 62400 |  |  |  |  | 2059
 | 112 | 2017-12-21 00:00:00 | 776269 |  | 0 |  |  |  | 0 |  |  |  |  | 188721 | 62400 |  |  |  |  | 811.5
 | 113 | 2017-12-21 00:00:00 | 244653.5 |  | 0 |  |  |  | 3 |  |  |  |  | 23923 | 41600 |  |  |  |  | 161.5
 | 114 | 2017-12-21 00:00:00 | 244653.5 |  | 0 |  |  |  | 7 |  |  |  |  | 20397 | 41600 |  |  |  |  | 166.5
 | 115 | 2017-12-21 00:00:00 | 244653.5 |  | 0 |  |  |  | 4 |  |  |  |  | 36262 | 41600 |  |  |  |  | 211.5
 | 116 | 2017-12-21 00:00:00 | 244653.5 |  | 0 |  |  |  | 5 |  |  |  |  | 35022 | 41600 |  |  |  |  | 211.5
 | 117 | 2017-12-21 00:00:00 | 244653.5 |  | 0 |  |  |  | 3 |  |  |  |  | 37526 | 41600 |  |  |  |  | 211.5
 | 118 | 2017-12-21 00:00:00 | 183950 |  | 0 |  |  |  | 9 |  |  |  |  | 26325 | 41600 |  |  |  |  | 211.5
 | 119 | 2018-02-06 00:00:00 | 244653.5 |  | 0 |  |  |  | 6 |  |  |  |  | 32261 | 41600 |  |  |  |  | 211.5
 | 120 | 2018-02-06 00:00:00 | 244653.5 |  | 0 |  |  |  | 3 |  |  |  |  | 23930 | 41600 |  |  |  |  | 161.5
 | 122 | 2018-03-21 00:00:00 | 244653.5 |  | 0 |  |  |  | 0 |  |  |  |  | 40147 | 41600 |  |  |  |  | 211.5
 | 123 | 2018-03-21 00:00:00 | 244653.5 |  | 0 |  |  |  | 0 |  |  |  |  | 40147 | 41600 |  |  |  |  | 211.5
 | 124 | 2018-03-21 00:00:00 | 244653.5 |  | 0 |  |  |  | 0 |  |  |  |  | 40147 | 41600 |  |  |  |  | 211.5
 | 125 | 2018-03-21 00:00:00 | 244653.5 |  | 0 |  |  |  | 1 |  |  |  |  | 26317 | 41600 |  |  |  |  | 161.5
 | 126 | 2018-04-21 00:00:00 | 244653.5 |  | 0 |  |  |  | 1 |  |  |  |  | 40045 | 41600 |  |  |  |  | 211.5
 | 127 | 2018-04-21 00:00:00 | 244653.5 |  | 0 |  |  |  | 1 |  |  |  |  | 40045 | 41600 |  |  |  |  | 211.5
 | 128 | 2018-04-21 00:00:00 | 244653.5 |  | 0 |  |  |  | 2 |  |  |  |  | 38782 | 41600 |  |  |  |  | 211.5
 | 129 | 2018-04-21 00:00:00 | 283283 |  | 0 |  |  |  | 2 |  |  |  |  | 38836 | 41600 |  |  |  |  | 211.5
 | 130 | 2018-04-21 00:00:00 | 283283 |  | 0 |  |  |  | 1 |  |  |  |  | 38446 | 41600 |  |  |  |  | 211.5
 | 131 | 2018-04-21 00:00:00 | 244653.5 |  | 0 |  |  |  | 2 |  |  |  |  | 26309 | 41600 |  |  |  |  | 166.5
 | 132 | 2018-04-21 00:00:00 | 244653.5 |  | 0 |  |  |  | 5 |  |  |  |  | 22745 | 41600 |  |  |  |  | 166.5