May 01 2021 01:30 PM
May 01 2021 03:31 PM
I find it surprising, in all candor, that you're asking this question now, on May 1 of 2021. Covid is not new, nor is the data gathering process. One of the first things I helped another user with on this site, well over a year ago now, had to do with tracking data on Covid-related work being done by fire fighters.
Anyway, I would in your place be asking how your counterparts in other states and regions have solved the same problem.
And I certainly wouldn't be using Power Point in any way in the data gathering phase of things; maybe in reporting, but that's a total misuse of Power Point.
Have you considered creating a standard form in in Google Sheets for those who submit data to you? That would be one way to standardize, and have multiple users entering in the same place....
You don't have an easy task, for sure........
If you desire more help, might I suggest you post some sample sheets that show what all the data is that you need, and how it's formatted now, how you'd like it, etc....
May 05 2021 11:55 PM
May 06 2021 06:22 AM
May 09 2021 02:15 PM
May 09 2021 04:06 PM
Hi @saddi2u,
as suggested my @mathetes try using Microsoft Forms or google from to collect the data with your selected data-point, this will ease your data entry and your can quickly analyze the data.
Microsoft Forms are best to collect the data.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.
May 10 2021 02:10 AM