adding updates to the popanalysis workbook.