Post #1: The NPR data relates to the new data but does not go as far as the new data. The new data goes up to November 2017 while the NPR only goes up to February 2017. The NPR numbers reflect total numbers for the VA systems. I came to that conclusion because the numbers on the NPR numbers are close to the numbers from the new data which is a total of the entire system.
Post #2: I highlighted Fayetteville, Little Rock, Memphis and Shreveport’s data and filtered the data by color.
Hermon – You are correct. The VA data has the detail from the clinics whereas the NPR data does not. This spreadsheet looks good: Sorted Fay, LR, Memphis, Shreve. Nice to highlight the medical systems to distinguish from the clinics..
The national data looks good. You did forget to remove a section of headers midway through.
5 of 5 points. Nice job