preparing data for usd497