add a manual preparation silo method in case the spreadsheet is irresponsive