Abstract: A system and method (100,200) which uses a spreadsheet computer program having linked files in which the network architecture and the network element properties are entered and stored by the user. The overall network configuration information is input into a first, (INPUT) file type (102), which includes general parameters such as the battery terminal voltage, cable temperatures, bus (or node) names and bus interconnection information such as cable sizes and number of conductors per node. Cable impedance tables are available in a second, auxiliary (RESIST) file (112). Detailed loading information is entered in a third, (PANEL) file (128), which includes load description, load type (constant power or constant impedance), and load rating data and load status (on or off), which can be sequenced over time. These spreadsheets, or files, cooperate to automatically set up the appropriate YBUS admittance matrix file (120,124) and interactively compute voltages and currents using fourth type (CALC) files (122,126).