Formula
= signature_accepted_values = ["Signed by CEO", "Signed by Director", "Signed by Managing Director", "Signed by Chairman"]
supply_chain_disclosure_accepted_values = ["Geographical", "Facility/Supplier"]
risk_identification_accepted_values = ["Geographic","Resource", "Workforce","Industry"]
incident_remediation_accepted_values = ["Worker remediation", "Corrective action plan", "Senior management", "Cancel contracts"]
grievance_mechanism_accepted_values = ["Hotline, Email, Contact Form (direct employees)", "Hotline, Email, Contact Form (supply chain workers)", "Whistleblower protection (direct employees)", "Whistleblower protection (supply chain workers)", "Focal Point (direct employees)", "Focal Point (supply chain workers)"]
risk_assessment_accepted_values = [ "Risk-based questionnaires", "Use of risk management tool or software", "Conducting desk research"]
risk_management_accepted_values = ["Audits of suppliers (self- reporting)", "Audits of suppliers (independent)", "On-site visits (self- reporting)", "On-site visits (independent)"]
policy_revised_not_accepted_values = ["No", "In Development"]
c1 = signature_accepted_values.includes signature
c2 = board_approval == "Approved by Board"
c3 = registry_submission == "Yes"
c4 = organizational_structure == "Yes"
c5 = supply_chain_disclosure_accepted_values.some((v)=> supply_chain_disclosure.indexOf(v) >= 0)
c6 = risk_identification_accepted_values.some((v) => risk_identification.indexOf(v) >= 0)
c7 = grievance_mechanism_accepted_values.some((v) => grievance_mechanism.indexOf(v) >= 0)
c8 = kpis_effectiveness == "Yes"
c9 = consultation_process == "Yes"
c10 = risk_assessment_accepted_values.some((v) => risk_assessment.indexOf(v) >= 0)
c11 = risk_management_accepted_values.some((v) => risk_management.indexOf(v) >= 0)
c12 = incident_remediation_accepted_values.some((v) => incident_remediation.indexOf(v) >= 0)
c13 = assessed_statement == "Yes"
c14 = isKnown(statement) && (statement.includes "Yes - UK Modern Slavery Act")
c15 = isKnown(statement) && (statement.includes "Yes - Australian Modern Slavery Act")
c16 = isKnown(statement) && (statement.includes "Yes - California Transparency in Supply")
c17 = kpis_business == "Yes"
c18 = policy_revised_not_accepted_values.some((v) => policy_revised.indexOf(v) == 0)
c19 = incidents_identified == "Yes"
if c1 && c2 && c3 && (c4 || c5) && (c18 || c12 || c19 || c7) && (c10 || c11 || c6) && (c8 || c17) && c9
if c13 && c15
"Yes"
else if c14 || c16
"Yes - but non-AUS statement"
else
"Yes - but statement partially assessed"
else if c15
if c13
"No"
else
"No - but statement partially assessed"
else if (c14 || c16)
"No - but non-AUS statement"
else
"Unknown"