- The data is the same but the new data is more current. The new data goes to November 2017 while the NPR data goes to February 2017. The NPR data reflects totals for the entire system. It can be double-checked by comparing the total appointments from the new data, which totals the entire system, to the NPR data. The numbers are fairly similar.
- Found the cities then filled the cells with green then filtered it by color.
Kayla – This is correct, the VA data has the details on the clinics whereas the NPR data only totals the VA Health Systems.
I was hoping you would filter the sheet by the VISN numbers and extract the Arkansas data that way.
National data looks fine except there’s an extra row of headings midway through that should be removed.
5 of 5 points. Nice work.