SOFA_KING
Member
It works! And actually completed in much less time than in EZscan. I'll have to compare the two with a stopwatch, but I didn't fall asleep like I usually do with ESscan (laughs).
Unfortunately, I way exceeded the row limit in my old version of Excel (Did newer versions ever expand above that?). If I remove the older data from about 7/2015 to 7/2016, then I can see newer data with the NAC included. After removing unused columns, I get a nice tidy list of all the data needed to analyze trends. And holy cow can it do that when you sort by frequency first, radio ID next, and then date. Great! Having NAC alongside the other data is VERY helpful!
Real magic happens when you sort by radio ID, then frequency, and then date. Now you easily see who uses what frequencies. Wowza! But now you see cross-agency use with the NAC showing (which is not available in EZscan). Crazy!
Thank you Don!
Does anyone have any suggestions on expanding the row limit so I can analyze all of my data? I'm missing out on a lot of user ID's with that limitation.
Phil
Unfortunately, I way exceeded the row limit in my old version of Excel (Did newer versions ever expand above that?). If I remove the older data from about 7/2015 to 7/2016, then I can see newer data with the NAC included. After removing unused columns, I get a nice tidy list of all the data needed to analyze trends. And holy cow can it do that when you sort by frequency first, radio ID next, and then date. Great! Having NAC alongside the other data is VERY helpful!
Real magic happens when you sort by radio ID, then frequency, and then date. Now you easily see who uses what frequencies. Wowza! But now you see cross-agency use with the NAC showing (which is not available in EZscan). Crazy!
Thank you Don!
Does anyone have any suggestions on expanding the row limit so I can analyze all of my data? I'm missing out on a lot of user ID's with that limitation.
Phil