Spreadsheet: 276024d1383731458-rather-complicated-lookup-problem-containing-2-linked-sheets-lookup
Sheet: Authorisation

Name | Function | Reports to | Function | Sign authorisation
 |  |  |  | Expense reports | Raw material & supplies production | Raw material & supplies production trial | Bocom and adv. sales promotion | Debit and credit memo's | Maintenance | Utilities and telephone | Office supplies | IT material/contracts | Airline tickets | Employee benefits | National and local taks | Others | Transportation contracts for goods | Labor contacts
Select person | No person selected | No person selected | No person selected | n.v.t. | n.v.t. | n.v.t. | n.v.t. | n.v.t. | n.v.t. | n.v.t. | n.v.t. | n.v.t. | n.v.t. | n.v.t. | n.v.t. | n.v.t. | n.v.t. | n.v.t.
Person 1 | Manager 1 | Chief 1 | Production manager 1 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 2 | Manager 2 | Chief 2 | Production manager 2 | 1500 | - | - | - | - | 6250 | - | 1250 | - | - | - | - | - | - | -
Person 3 | Manager 3 | Chief 3 | Production manager 3 | 2500 | - | 10000 | 20000 | 20000 | - | - | 2500 | - | 5000 | - | - | 1000 | - | own staff
Person 4 | Manager 4 | Chief 4 | Production manager 4 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 5 | Manager 5 | Chief 5 | Production manager 5 | 1500 | - | - | - | - | 12500 | 150000 | 1250 | - | 1250 | - | - | - | - | -
Person 6 | Manager 6 | Chief 6 | Production manager 6 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 7 | Manager 7 | Chief 7 | Production manager 7 | - | - | - | - | - | 1500 | - | - | - | - | - | - | - | - | -
Person 8 | Manager 8 | Chief 8 | Production manager 8 | - | - | - | - | - | 1500 | - | - | - | - | - | - | - | - | -
Person 9 | Manager 9 | Chief 9 | Production manager 9 | - | - | - | - | - | 1500 | - | - | - | - | - | - | - | - | -
Person 10 | Manager 10 | Chief 10 | Production manager 10 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 11 | Manager 11 | Chief 11 | Production manager 11 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 12 | Manager 12 | Chief 12 | Production manager 12 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 13 | Manager 13 | Chief 13 | Production manager 13 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 14 | Manager 14 | Chief 14 | Production manager 14 | 1500 | - | - | - | - | - | - | - | - | - | 20000 | - | - | - | -
Person 15 | Manager 15 | Chief 15 | Production manager 15 | - | - | - | - | - | - | - | - | - | - | 10000 | - | - | - | -
Person 16 | Manager 16 | Chief 16 | Production manager 16 | - | - | - | - | - | - | - | - | - | - | 10000 | - | - | - | -
Person 17 | Manager 17 | Chief 17 | Production manager 17 | - | - | - | - | - | - | - | - | - | - | 10000 | - | - | - | -
Person 18 | Manager 18 | Chief 18 | Production manager 18 | 1500 | - | - | - | - | 12500 | - | 1250 | - | 1250 | - | - | - | - | -
Person 19 | Manager 19 | Chief 19 | Production manager 19 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 20 | Manager 20 | Chief 20 | Production manager 20 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 21 | Manager 21 | Chief 21 | Production manager 21 | 1500 | - | - | - | - | 12500 | - | 1250 | - | 1250 | - | - | - | Unlimited | -
Person 22 | Manager 22 | Chief 22 | Production manager 22 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 23 | Manager 23 | Chief 23 | Production manager 23 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 24 | Manager 24 | Chief 24 | Production manager 24 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 25 | Manager 25 | Chief 25 | Production manager 25 | 2500 | - | - | - | 250000 | - | 250000 | 5000 | 10000 | 2500 | 40000 | 50000 | 1000 | - | own staff
Person 26 | Manager 26 | Chief 26 | Production manager 26 | 1250 | - | - | - | - | - | - | 1250 | - | 1250 | - | - | 500 | - | -
Person 27 | Manager 27 | Chief 27 | Production manager 27 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 28 | Manager 28 | Chief 28 | Production manager 28 | 1500 | - | 5000 | - | - | - | - | - | - | - | - | - | - | - | -
Person 29 | Manager 29 | Chief 29 | Production manager 29 | 100 | 2500 | 0.5 | 0.5 | 0.5 | 0.5 | - | 250 | 0.5 | 0.5 | 0.5 | - | 0.5 | - | -
Person 30 | Manager 30 | Chief 30 | Production manager 30 | 100 | unlimited | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 31 | Manager 31 | Chief 31 | Production manager 31 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 32 | Manager 32 | Chief 32 | Production manager 32 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 33 | Manager 33 | Chief 33 | Production manager 33 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 34 | Manager 34 | Chief 34 | Production manager 34 | 1250 | - | 5000 | 10000 | 10000 | - | - | 1250 | - | 2500 | - | - | 500 | - | -
Person 35 | Manager 35 | Chief 35 | Production manager 35 | 1250 | - | 5000 | 10000 | 10000 | - | - | 1250 | - | 2500 | - | - | 500 | - | -
Person 36 | Manager 36 | Chief 36 | Production manager 36 | - | - | 2500 | 7500 | 7500 | - | - | - | - | - | - | - | - | - | -
Person 37 | Manager 37 | Chief 37 | Production manager 37 | - | - | - | 5000 | 5000 | - | - | - | - | - | - | - | - | - | -
Person 38 | Manager 38 | Chief 38 | Production manager 38 | - | - | - | 5000 | 5000 | - | - | - | - | - | - | - | - | - | -
Person 39 | Manager 39 | Chief 39 | Production manager 39 | - | - | - | 5000 | 5000 | - | - | - | - | - | - | - | - | - | -
Person 40 | Manager 40 | Chief 40 | Production manager 40 | - | - | - | 5000 | 5000 | - | - | - | - | - | - | - | - | - | -
Person 41 | Manager 41 | Chief 41 | Production manager 41 | 1250 | - | 5000 | 10000 | 10000 | - | - | 1250 | - | 2500 | - | - | 500 | - | -
Person 42 | Manager 42 | Chief 42 | Production manager 42 | - | - | 2500 | 7500 | 7500 | - | - | - | - | - | - | - | - | - | -
Person 43 | Manager 43 | Chief 43 | Production manager 43 | 2500 | Unlimited | 10000 | - | 100000 | 25000 | 250000 | 5000 | - | 5000 | 40000 | 50000 | 1000 | Unlimited | own staff
Person 44 | Manager 44 | Chief 44 | Production manager 44 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 45 | Manager 45 | Chief 45 | Production manager 45 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Person 46 | Manager 46 | Chief 46 | Production manager 46 | 500 | - | - | - | - | - | - | 2500 | 2500 | - | - | - | - | - | -