Determine the valence intensity of the following tweet, considering the mental state of the author. Assign a real number between 0 and 1, where 0 denotes extremely negative and 1 denotes extremely positive.
Tweet: 5 goals in 87 appearances last season between McKay, Holt and Windass! Simply is horrific! Get midfield balance sorted and team will fire!