more methods to prep lot report