Membership numbers are being duplicated from previous years by somebody, but who? Clerks, Presbyteries, PCUSA. The problem is not just churches that have left for EPC/NW but churches that have not filed the statistics.
I proofed some of the ones that the formulas found by checking google and concluded that they are active because there website shows them to be a NCD. So I added that as a criteria for active.