first attempt at rank spreadhseet transform