some mostly R functions for data manipulation on reconcile data