Numerical Investigations of Power Distribution Network
This paper numerically evaluates the voltage drop, the current rating of the network, the voltage profile, the total active and reactive power losses, and the current rating of short circuits. The calculations of these parameters are performed at both sending and receiving ends of a practical feeder in an extensive network in Hamadan city in Iran, with more than 180 load points. Regarding the desired parameters, the best Substations is selected to supply the feeder. The numerical analyses are formulated in Microsoft Excel software. The numerical results highlight the fact that there is a good agreement between numerical outcomes and published data in which professional software is used. It is shown that the proposed numerical method can be utilized with excellent outcomes instead of studying power distribution networks using professional commercial software. The outcomes ensure that the numerical results are satisfactorily accurate, and the evaluation of the distribution network can be conducted in a short time. Besides, due to the compatibility of data, the results can be post-processed effortlessly in other software such as MATLAB. Consequently, compared to the conventional methods, the numerical proposed method is predominantly cost-effective in terms of evaluation of power distribution networks.
 Musti, K. and R.B. Ramkhelawan, Power system load flow analysis using Microsoft excel. Spreadsheets in Education (eJSiE), 2012. 6(1): p. 1.
 Bissell, C. and D. Chapman. Spreadsheets as a learning aid in engineering education. in CAEE 93 Int. Conf. Computer-Aided Engineering Education. 1993.
 Philavanh, B, S. Premrudeepreechacharn, and J. Triyangkulsri. Power and voltage control of central-I transmission network in Lao PDR using Excel's solver. in Power System Technology, 2004. PowerCon 2004. 2004 International Conference on. 2004. IEEE.
 Yamani, A. and A. Kharab, Use of a spreadsheet program in electromagnetics. IEEE Transactions on Education, 2001. 44(3): p. 292-297.
 El-Hajj, A. and K.Y. Kabalan, Time domain analysis of linear systems using spreadsheets. IEEE Transactions on Education, 1995. 38(4): p. 317-320.
 El‐Hajj, A., K.Y. Kabalan, and S. El‐Haj Mahmoud, An improved spreadsheet toolbox for simulating digital networks. Computer Applications in Engineering Education, 2001. 9(2): p. 78-86.
 Ibrahim, D., Teaching Science and Mathematics Subjects Using the Excel Spreadsheet Package. Online Submission, 2009.
 Bissell, C., Spreadsheets in the teaching of information engineering. Engineering Science and Education Journal, 1994. 3(2): p. 89-96.
 Shapiro, F.R., The use of a spreadsheet for sinusoidal steady-state transmission line and optics problems. IEEE Transactions on Education, 1993. 36(2): p. 269-272.
 Xu, W., et al., Using spreadsheet software as a platform for power system analysis. IEEE Computer Applications in Power, 1999. 12(1): p. 41-45.
 Lau, M. and S. Kuruganty. The Use of Spreadsheets in Teaching the Power-Flow Problem. in American Society for Engineering Education. 2009. American Society for Engineering Education.
 Acarnley, P., Power system load flow analysis using an Excel Workbook. International journal of electrical engineering education, 2005. 42(2): p. 185-202.
 Lau, M.A. and S. Kuruganty, Spreadsheet implementations for solving Power-Flow problems. Spreadsheets in Education (eJSiE), 2008. 3 (1): p. 3.
 Insu Kim, Ronald G.Harley. The transient-state effect of the reactive power control of photovoltaic systems on a distribution network. Electrical Power & Energy Systems, Volume 99, 2018, Pages 630-637.
 Gibran Agundis-Tinajero,Juan Segundo-Ramírez,Nancy Visairo-Cruz,Mehdi Savaghebi,Josep M.Guerrero,Emilio Barocio. Power flow modeling of islanded AC microgrids with hierarchical control. Electrical Power & Energy Systems, Volume 105, 2019, Pages 28-36.
 Antonio Zecchino, Mattia Marinelli. Analytical assessment of voltage support via reactive power from new electric vehicles supply equipment in radial distribution grids with voltage-dependent loads. Electrical Power and Energy Systems 97 (2018) 17–27.
 K. Muthukumar, S. Jayalalitha. Optimal placement and sizing of distributed generators and shunt capacitors for power loss minimization in radial distribution networks using hybrid heuristic search optimization technique. Electrical Power and Energy Systems 78 (2016) 299–319.
 Mohammad Sadegh Javadi, Ali Esmaeel Nezhad, Pierluigi Siano, Miadreza Shafie-khah, João P.S. Catalão. Shunt capacitor placement in radial distribution networks considering switching transients decision making approach. Electrical Power and Energy Systems 92 (2017) 167–180.
 H. Kiani Rad, Z. Moravej. An approach for simultaneous distribution, sub-transmission, and transmission networks expansion planning. Electrical Power and Energy Systems 91 (2017) 166–182.
 Yaser Raeisi-Gahrooei, Amin Khodabakhshian, Rahmat-Allah Hooshmand. A new stratified random sample customer selection for load research study in distribution networks. Electrical Power and Energy Systems 97 (2018) 363–371.
 M.R. Shakarami, H. Beiranvand, A. Beiranvand, E. Sharifipour. A recursive power flow method for radial distribution networks: Analysis, solvability and convergence. Electrical Power and Energy Systems 86 (2017) 71–80.
 Giambattista Gruosso, Paolo Maffezzoni, Zheng Zhang, Luca Daniel. Probabilistic load flow methodology for distribution networks including loads uncertainty. Electrical Power and Energy Systems 106 (2019) 392–400.