Spreadsheet: 113134d1309110839-modify-formula-to-not-execute-if-cell-contains-certain-text-example-2
Sheet: List

PSP40604 | Certificate IV in Government (Fraud Control) | PSP41504 REQUIRED |  | PSP41404 REQUIRED |  | PSP40606 REQUIRED |  | PSP51704 REQUIRED
PSP41504 | Certificate IV in Government (Investigations) | PSPETHC401A | Uphold and support the values and principles of public service | PSPETHC401A | Uphold and support the values and principles of public service | PSPETHC401A | Uphold and support the values and principles of public service | PSPETHC501B | Promote the values and ethos of public service
PSP41404 | Certificate IV in Government (Statutory Compliancel) | PSPGOV412A | Use advanced workplace communication strategies | PSPGOV402B | Deliver and monitor service to clients | PSPGOV402B | Deliver and monitor service to clients | PSPGOV503B | Coordinate resource allocation and usage
PSP51704 | Diploma of Government Investigations) | PSPLEGN401A | Encourage compliance with legislation in the public sector | PSPGOV408A | Value diversity | PSPGOV408A | Value diversity | PSPGOV512A | Use complex workplace communication strategies
Select Here |  | PSPREG401C | Exercise regulatory powers | PSPGOV412A | Use advanced workplace communication strategies | PSPGOV412A | Use advanced workplace communication strategies | PSPLEGN501B | Promote compliance with legislation in the public sector
 |  | PSPREG404C | Investigate non-compliance | PSPGOV422A | Apply government processes | PSPGOV422A | Apply government processes | PSPREG502A | Coordinate investigation processes
 |  | PSPREG407B | Produce formal record of interview | PSPLEGN401A | Encourage compliance with legislation in the public sector | PSPLEGN401A | Encourage compliance with legislation in the public sector | PUAPOL024A | Conduct investigations
 |  | PSPREG411A | Gather information through interviews | PSPPOL404A | Support policy implementation | PSPPOL404A | Support policy implementation | PUAPOL028A | Manage investigation information processes
 |  | PSPREG412A | Gather and manage evidence | PSPREG401C | Exercise regulatory powers | PSPFRAU401B | Monitor data for indicators of fraud | PUAPOL030A | Review and evaluate major investigations
 |  | PSPREG418A | Advise on progress of investigations | PSPOHS301A | Contribute to workplace safety | PSPFRAU407B | Conduct fraud control awareness sessions | PUAPOL001A | Maintain operational safety
 |  | PSPREG419A | Finalise and report on investigations |  |  | PSPREG415A | Receive and validate data
 |  | PSPOHS301A | Contribute to workplace safety |  |  | PSPREG416A | Conduct data analysis
 |  |  |  |  |  | PSPOHS301A | Contribute to workplace safety
 |  |  |  |  |  |  |  | IF C7=[NAME] (PSP41404)
 | Electives | Electives |  |  |  |  |  | PSP41404 Related Required Units |  | PSP40604 Related Required Units
 | PSPETHC401A [NAME] and support the values and principles of public service | PSPETHC401A | Uphold and support the values and principles of public service |  |  |  |  | PSPETHC401A |  | PSPETHC401A
 | PSPETHC501B Promote the values and ethos of public service | PSPETHC501B | Promote the values and ethos of public service |  |  |  |  | PSPGOV412A |  | PSPGOV412A
 | PSPFRAU401B Monitor data for indicators of fraud | PSPFRAU401B | Monitor data for indicators of fraud |  |  |  |  | PSPLEGN401A |  | PSPLEGN401A
 | PSPFRAU407B Conduct fraud control awareness sessions | PSPFRAU407B | Conduct fraud control awareness sessions |  |  |  |  | PSPREG401C |  | PSPOHS301A
 | PSPGOV402B Deliver and monitor service to clients | PSPGOV402B | Deliver and monitor service to clients |  |  |  |  | PSPOHS301A
 | PSPGOV402B Deliver and monitor service to clients | PSPGOV402B | Deliver and monitor service to clients
 | PSPGOV408A Value diversity | PSPGOV408A | Value diversity
 | PSPGOV412A Use advanced workplace communication strategies | PSPGOV412A | Use advanced workplace communication strategies
 | PSPGOV422A Apply government processes | PSPGOV422A | Apply government processes
 | PSPGOV503B Coordinate resource allocation and usage | PSPGOV503B | Coordinate resource allocation and usage
 | PSPGOV512A Use complex workplace communication strategies | PSPGOV512A | Use complex workplace communication strategies
 | PSPLEGN401A Encourage compliance with legislation in the public sector | PSPLEGN401A | Encourage compliance with legislation in the public sector
 | PSPLEGN501B Promote compliance with legislation in the public sector | PSPLEGN501B | Promote compliance with legislation in the public sector |  |  |  |  | PSP41404 Other Required Units |  | PSP41404 Other Required Units | PSP41504 Required used as Electives
 | PSPOHS301A Contribute to workplace safety | PSPOHS301A | Contribute to workplace safety |  |  |  |  | PSPGOV402B |  | PSPGOV402B | PSPREG404C
 | PSPPOL404A Support policy implementation | PSPPOL404A | Support policy implementation |  |  |  |  | PSPGOV408A |  | PSPGOV408A | PSPREG407B
 | PSPREG401C Exercise regulatory powers | PSPREG401C | Exercise regulatory powers |  |  | Yes |  | PSPGOV422A |  | PSPGOV422A | PSPREG411A
 | PSPREG402C Promote client compliance | PSPREG402C | Promote client compliance |  |  | No |  | PSPPOL404A |  | PSPPOL404A | PSPREG412A
 | PSPREG403B Assess compliance | PSPREG403B | Assess compliance |  |  |  |  |  |  | PSPFRAU401B | PSPREG418A
 | PSPREG404C Investigate non-compliance | PSPREG404C | Investigate non-compliance |  |  |  |  |  |  | PSPFRAU407B | PSPREG419A
 | PSPREG405B Act on non-compliance | PSPREG405B | Act on non-compliance |  |  |  |  |  |  | PSPREG415A
 | PSPREG406C Make arrests | PSPREG406C | Make arrests |  |  |  |  |  |  | PSPREG416A
 | PSPREG407B Produce formal record of interview | PSPREG407B | Produce formal record of interview |  |  |  |  | IF C7=PSP41404 (PSP40604) |  | IF C7=PSP41404 (PSP40604)
 | [NAME] search and seizure | [NAME] | Conduct search and seizure |  |  |  |  | PSP40604 Related Required Units |  | PSP40604 Other Required Units | PSP41404 Required used as Electives
 | PSPREG409B Prepare a brief of evidence | PSPREG409B | Prepare a brief of evidence |  |  |  |  | PSPETHC401A |  | PSPFRAU401B | PSPREG401C
 | PSPREG410B Give evidence | PSPREG410B | Give evidence |  |  |  |  | PSPGOV402B |  | PSPFRAU407B
 | PSPREG411A Gather information through interviews | PSPREG411A | Gather information through interviews |  |  |  |  | PSPGOV408A |  | PSPREG415A
 | PSPREG412A [NAME] and manage evidence | PSPREG412A | Gather and manage evidence |  |  |  |  | PSPGOV412A |  | PSPREG416A
 | PSPREG413A Undertake inspections and monitoring | PSPREG413A | Undertake inspections and monitoring |  |  |  |  | PSPGOV422A
 | PSPREG414A Conduct surveillance | PSPREG414A | Conduct surveillance |  |  |  |  | PSPLEGN401A
 | [NAME] and validate data | PSPREG415A | Receive and validate data |  |  |  |  | PSPPOL404A
 | PSPREG416A Conduct data analysis | PSPREG416A | Conduct data analysis |  |  |  |  | PSPOHS301A
 | PSPREG417A Undertake compliance audits | PSPREG417A | Undertake compliance audits
 | PSPREG418A Advise on progress of investigations | PSPREG418A | Advise on progress of investigations
 | PSPREG419A [NAME] and report on investigations | PSPREG419A | Finalise and report on investigations
 | PSPREG502A Coordinate investigation processes | PSPREG502A | Coordinate investigation processes
 | PUAPOL001A Maintain operational safety | PUAPOL001A | Maintain operational safety |  |  |  |  | IF C7=PSP41504 (PSP40604) |  | IF C7=PSP41404 (PSP41504) | IF C7=PSP40604 (PSP41404) | IF C7=PSP40604 (PSP41404)
 | PUAPOL024A Conduct investigations | PUAPOL024A | Conduct investigations |  |  |  |  | PSP40604 Related Required Units |  | PSP41504 Related Required Units | PSP41404 Related Required Units | PSP41404 Other Required Units
 | PUAPOL028A Manage investigation information processes | PUAPOL028A | Manage investigation information processes |  |  |  |  | PSPETHC401A |  | PSPETHC401A | PSPETHC401A | PSPREG401C
 | PUAPOL030A Review and evaluate major investigations | PUAPOL030A | Review and evaluate major investigations |  |  |  |  | PSPGOV412A |  | PSPGOV412A | PSPGOV402B
 | PSPLEGN501B  Promote compliance with legislation in the public sector | PSPLEGN501B | Promote compliance with legislation in the public seCtor |  |  |  |  | PSPLEGN401A |  | PSPLEGN401A | PSPGOV408A
 | PSPREG201A Carry out inspections and monitoring under guidance | PSPREG201A | Carry out inspections and monitoring under guidance |  |  |  |  | PSPOHS301A |  | PSPREG401C | PSPGOV412A
 | PSPREG301A  Undertake routine inspections and monitoring | PSPREG301A | Undertake routine inspections and monitoring |  |  |  |  |  |  | PSPOHS301A | PSPGOV422A
 | PSPREG503A Supervise and carry out complex inspections and monitoring |  |  |  |  |  |  |  |  |  | PSPLEGN401A
 | PSPWPI601B Improve compliance through industry partnerships |  |  |  |  |  |  |  |  |  | PSPPOL404A
 |  |  |  |  |  |  |  |  |  |  | PSPOHS301A