finish back end prep_sheet calculation