Method for conducting line model selection and economic estimation of power distribution network through EXCEL

The invention discloses a method for conducting line model selection and economic estimation of a power distribution network through the EXCEL. After a transmission medium, the transmission distance and a line load are determined according to a plan of the power distribution network, parameters and the investment costs of wires with different cross sections are found through the EXCEL, and economic loading areas of the wires are calculated; according to the load of the plan of the power distribution network,, the wires are selected in the economic loading areas, a plan scheme is determined, and finally economic estimation is carried out; a wire set with the lowest annual total cost in the using period is selected. According to the method, the other economic loading areas are considered in the wire selecting process, and the best economical efficiency is achieved; meanwhile, when the scheme is planned, the wires with the slightly-large cross sections are selected, the reliability and the safety of the system are improved, and the method is of great significance in improving the power grid service level and increasing power grid earnings. In addition, a line model selection database is built through the method, and data supports are provided for the economical efficiency for regularly checking lines and updating the lines in the future.