reformat spreadsheet input and grab jobs number