Systematics in band-gaps and optical-spectra of 3d transition-metal compounds