Complex formulas for my small business

I have a small business that specializes in live music for weddings/events. We're picking up some speed, and would like to take our accounting/tracking to a more professional level.

I need some help setting up a spreadsheet that will calculate weekly payment amounts based on gigs we get, as we get them, instead of paying ourselves lump sums every time we complete an event (were running out of checks). To say it differently, we would like to pay each employee the total of all our gigs added up (as they come in) and spread that over 26 yearly payments (bi weekly), so that months that we don't have as many events coming in, were still getting enough of a bi weekly check to get by.

I need a setup that can add multiple events together for bi weekly totals (the part i already know how to do), but also drop off once that amount/event has reached its 26 installments if that makes sense.

There are several other things we would like to add to the spreadsheet of course, but thats where my main hangup is right now.

Will gladly pay if someone could walk me through this process, and figure out the best approach.

Thanks
Jason
405.830.8236