added pull from manual addtions table
updated rank table