I have modified the SplineBeam spreadsheet to allow input of a single span (simply supported or with end constraints), and to optionally allow input of the position of intermediate nodes, rather than dividing each span into equal segment lengths. This allows loads to be applied at their precise location, and output of results at the point of maximum deflection.
Download SplineBeam2_2.zip (includes full open source code)
Pingback: Daily Download 4: Continuous Beam Analysis | Newton Excel Bach, not (just) an Excel Blog