The flood routing is very important in design and management of reservoir, one of the common method is trial in table. Combined with the actual needs in projects, the paper invented a program by fully using the powerful function of excel, which solved the problem that how to route flood by program and improve the accuracy and speed of calculation.