The dispersal of protoplanetary discs – II: photoevaporation models with observationally derived irradiating spectra