Officer Rotation Matching

Intelligent officer-position matching using advanced optimization algorithms

Officer Preferences

REQUIRED

Upload officer names, current positions, and top 3 preferences

Position Preferences

REQUIRED

Upload position names and their top 3 preferred officers

Organization Preferences

OPTIONAL

Upload organizational bonus/penalty adjustments (-3 to +3)

Need Templates?

Officer TemplatePosition TemplateOrg Template

How It Works

Uses Hungarian Algorithm to find optimal matches based on preferences, priorities, and rotation rules.

Learn More

📁Required Files

REQ

officer_preferences.xlsx

Officers + top 3 preferences

REQ

position_preferences.xlsx

Positions + top 3 officers

OPT

org_preferences.xlsx

Bonus/penalty (-3 to +3)

🎯Scoring

🥇 1st choice+3
🥈 2nd choice+2
🥉 3rd choice+1
🔄 Current pos-99

💡Example

John → Manager (Finance)

• John's 1st choice: +3

• Finance's 2nd choice: +2

• Org bonus: +2

= 7 points total

See Full Examples

⚠️Important

  • •All current positions must exist in position file
  • •No duplicate names allowed
  • •Names are case-sensitive

Powered by Hungarian Algorithm • Built for PSD