adding more summary tables

added converting design table from long to wide
created location_mod table