update the spill amount based on latest data
fix bug which was double counting today