Looking For Formula

[M50Paul]

I was looking to build a table with odds for certain hands in seven card stud. It is a standard 52 card deck with 8 people playing. Below are 3 hands that I would appreciate you showing me the formula to calculate the odds of completing the flush. There are 8 players of which 4 fold after the first 3 cards are dealt. The (XX) represents the hole or down cards for each player. The (AcKc) are my down cards so I know what they are. The small letter after the cards represent the suites (c=clubs, h=hearts, s=spades, and d=diamonds). For each of the 3 hands below what are my odds of making the flush by the 7th card at 3rd , 4th, and 5th streets?
Thank you in advance!



Hand 1

Player 1st 3 Cards 4th St 5th St
A(me) (AcKc)2c 6c 6h
B (XX)Qh Qc Th
C (XX)Td F
D (XX)3s F
E (XX)Qd Jd Tc
F (XX)As 9h 8d
G (XX)Js F
H (XX)5h F


Hand 2

Player 1st 3 Cards 4th St 5th St
A(me) (AcKc)2c 6c 6h
B (XX)Qs Qc Th
C (XX)Td F
D (XX)3s F
E (XX)Qc Jd Tc
F (XX)As 9c 8d
G (XX)Js F
H (XX)5h F


Hand 3

Player 1st 3 Cards 4th St 5th St
A(me) (AcKc)2c 6c 6h
B (XX)Qs Qc Th
C (XX)Td F
D (XX)3s F
E (XX)Qh Jc Tc
F (XX)As 9c 8d
G (XX)Js F
H (XX)5h F

[M50Paul]

Appologize for the garbled hand alingment. When I type it in and review under the typed section it is aligned correctly. Not sure what happened