Formula logic:
If the company:
- provides a homepage link to their modern slavery statement (any year), and
- the statement has been explicitly approved by the board of directors, and
- the statement has been signed by the appropriate person (CEO, Director, Managing Director, or Chairman)
Then "Yes" they did meet the minimum requirements of the UK MSA.
If they did not meet one or multiple of the criteria listed above, then "No" they did not meet the minimum requirements of the UK MSA.
m3Options = [ "Signed by CEO" "Signed by Director" "Signed by Managing Director" "Signed by Chairman" ] c1 = uk_msa_assessed == "Yes" c2 = m1 == "Yes" c3 = m2 == "Approved by Board" c4 = [m3].flat().filter( (v) -> m3Options.includes v).length statement = [statement].flat() c5 = isKnown(statement) && (statement.includes "Yes - UK Modern Slavery Act") c6 = isKnown(statement) && (statement.includes "Yes - Australian Modern Slavery Act") c7 = isKnown(statement) && (statement.includes "Yes - California Transparency in Supply Chains Act") if c2 && c3 && c4 if c1 && c5 "Yes" else if c6 || c7 "Yes - but non-UK statement" else "Yes - but statement partially assessed" else if c5 && (m1 != "Unknown") if c1 "No" else "No - but statement partially assessed" else if (c6 || c7) && (m1 != "Unknown") "No - but non-UK statement" else "Unknown"
Research lock_open
m2
Research lock_open
m3
Research lock_open
statement
Topics
Options