Variable | Metric | Value | Year |
---|---|---|---|
m2 | Research lock_open
|
No value | 2021 |
m3 | Research lock_open
|
No value | 2021 |
m1 | Formula
|
No | 2021 |
statement | Research lock_open
|
Yes - Australian Modern Slavery Act | 2021 |
uk_msa_assessed | Formula
|
No | 2021 |
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
"No"
else if c6 || c7
"No - but non-UK statement"
else
"Unknown"