latest consolidation scripts with john crawford changes