script to create input data for analysis