Developing automated methods to estimate spectrally resolved direct normal irradiance for solar energy applications