completed location calculations up to row 5