# NZ Facility Scoring Formula

## Scoring System:
XXLarge + Apples/Citrus = 100 (as per Jonny's example)

### Size Points:
- XXLarge: 50 points
- XLarge: 40 points  
- Large: 30 points
- Mid: 20 points
- Small-Mid: 10 points
- Small: 5 points
- Unknown/Not a facility: 0 points

### Produce Bonus:
- Has Apples OR Citrus: +50 points
- No Apples/Citrus: +0 points

### Examples:
- XXLarge + Apples = 50 + 50 = 100 ✓
- XLarge + Apples = 40 + 50 = 90
- Large + Apples = 30 + 50 = 80
- Mid + Apples = 20 + 50 = 70
- XXLarge + Vegetables only = 50 + 0 = 50
- Small + Apples = 5 + 50 = 55

## Google Sheets Formula:
=IF(OR(G2="Unknown - Call", G2="Not a facility", G2=""), 0, 
  (IF(REGEXMATCH(G2, "XXLarge"), 50, 
   IF(REGEXMATCH(G2, "XLarge"), 40,
   IF(G2="Large", 30,
   IF(G2="Mid", 20,
   IF(REGEXMATCH(G2, "Small-Mid"), 10,
   IF(G2="Small", 5, 0)))))) +
  IF(OR(REGEXMATCH(LOWER(H2), "apple"), REGEXMATCH(LOWER(H2), "citrus")), 50, 0)))