I'm stumped. Maybe I've lost my mind, but I cannot figure out how to design a database for the attached. My coworker has 5 people who visit our rec sites daily, several times throughout the day. Each person carries these data entry forms with them and hand writes the numbers of visitors, cars, etc. at each location for each visit that day (they may visit each site 2 - 5 times a day.. could be more).
At the end of the day, all the sheets are gathered and one person manually averages the numbers for the day and enters the average number on a master sheet. Then the boss has to take each of these master daily sheets and manually enter the numbers into another spreadsheet where he can make graphs to show trends.
What he wants is a database that will store these numbers so he can run reports. He wants the data entry screen to look pretty much like what it does now (the attached spreadsheet). He doesn't want drop downs to pick sites since they visit every site every day.
He said it's fine if they still have to manually calculate the average and then only enter the daily average for each site.
He wants to be able to run reports showing the number of visitors for each site daily, weekly, monthly, etc.
Originally I thought we should keep this in Excel, but I'm not sure how to set it up so these non-computer savvy people can enter their daily numbers and easily run reports to show what the boss wants to show.