Formula
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"
MSA Statement Approval
Research lock_open
Business & Human Rights Resource Centre
m2
MSA statement signed
Research lock_open
Business & Human Rights Resource Centre
m3
Modern Slavery Statement
Research lock_open
Business & Human Rights Resource Centre
statement