15:58:23	 From MN SSB Matt Bechel : One thing about table formats, many built in Excel Table formats do not have proper color contrast. for WCAG. The black and grey is a pretty safe choice.
16:02:55	 From AZ1A - Erin Pawlus : Love it!  Beautiful.
16:05:23	 From Mitake Burts : If you want the mapping by something more specific than county - you can also run the Patron Summary by location using sort by Postal Code instead of sort by county
16:05:41	 From MN1A - Dan Malosh : Were there some counties in other states outside of NC that also got "NC" added to it? If so, what did it do with that data? Did it just ignore it?
16:08:36	 From MO1A-Lori Brown : Can you change the color for better contrast?
16:10:35	 From Maureen Dorosinski -FL1A : How do you get it to fill in the ones that are blank but have a value?
16:13:09	 From Jay Maruska : FYI: NC has 100 counties.
16:14:14	 From Maureen Dorosinski -FL1A : Got it!! Thanks!
16:14:38	 From Maureen Dorosinski -FL1A : Reacted to "Got it!! Thanks!" with 🥳
16:20:47	 From MS1A - Evan Theilman : I believe in most cases you can also use CTRL+A to select all data in an unformatted sheet to make it easier to make a table.
16:26:37	 From Mitake Burts : Instead of depending on the copy paste to keep everything in the same order - you can use the VLOOKUP function to pull the data from one sheet on to your main sheet
16:27:42	 From MA1A Emily Zieg : I believe VLOOKUP has been deprecated by XLOOKUP
16:49:32	 From markel.crumpler : What data did you find displaying in this way to be the most helpful in your operation
16:49:46	 From Barnaby Camp : Can you post these to the forum?
16:50:02	 From Ricardo C. CA1C : No questions, this is helpful. I will have to review the training again, this is a lot of useful information.
16:50:12	 From NY2A Kimberly Scofield : Reacted to "No questions, this..." with 👍
16:50:18	 From markel.crumpler : Do you keep all data in one excel file or do you split by month/yeat
16:50:21	 From Maureen Dorosinski -FL1A : Do you have this information in instruction sheet format? In steps?
16:50:33	 From NY2A Kimberly Scofield : Reacted to "Do you have this i..." with 👍
16:50:37	 From GA1A KHaun : We use that basic report plus a monthly inventory to predict when we'll need to reorder cartridges
16:51:09	 From MN1A - Dan Malosh : Reacted to "No questions, this is helpful. I will have to review the training again, this is a lot of useful information." with 👍
16:52:09	 From MI1A Caitlin : I was playing around with the map report, and oddly, with my report, it showed the whole US when I added the State column, but showed just Michigan when I deleted that new column. Unfortunately the Michigan map is just awful.
16:52:14	 From Maureen Dorosinski -FL1A : That's what I'm looking for!!!
16:52:23	 From MI1A Susan Greene : Do you use excel and this information for machine reporting?
16:53:48	 From Mitake Burts : One of the things with County data - it is based on the shipping addresses - so if you have patrons with transferred address you may get more counties than in just your state — which is part of why you’d want to make sure you select the state you are interested in
16:54:31	 From Mitake Burts : If you are still getting out of state counties - we will probably want to check your county code file for cleanup.
16:55:03	 From MI1A Caitlin : It was just when I had the column with "MI" on every row that it did it.
16:58:50	 From Ricardo C. CA1C : Sometimes you can have a patron with a temporary address that could be why some results outside state/service area
16:59:13	 From Juliet Relyea : Thank you. Great information!
16:59:49	 From MI1A Caitlin : No, there were no other addresses. It was weird, but there were no highlighted areas in other spots in the country. The rest of the map was blank, but it showed it anyway.
17:00:21	 From MA1A Emily Zieg : Thank you for the presentation!
17:00:24	 From SD1A- Kathleen Slocum : Thank you
17:00:27	 From MI1A Caitlin : Thank you!