Wait a second, I just remembered that vals and excel do not work always work well together. You may want to do a search on that.
The more control over the individual lights the better. If you can also control the timing of each light so you can create patterns, you are golden
Say 4 lights for 60% of the day and the other 2 for a 3-4 hour noon burst.
Or if too much, run 2 or 3 lights on each part of the day. You can also have natural darker areas, as I know the gars are ambush predators and will appreciate the eel grass beds........