Scoring by Fleets then rolling up the totals per club

We are proposing to score an upcoming regatta by fleets. One boat from
each club will race in fleet. Low point scoring for the fleets. We
will then award points based upon a high point scoring for the best
club overall for all fleets.

Has anyone tried this?

Thanks
Robert