updated to include letter code valuation transformation