Foodware Scorecard

We are collecting data in a Google form on the compliance by local businesses with our local city foodware reduction ordinance. We would like to automate the translation of this data into a formated table and score card. This seems like a task for a someone who is super adept wit graphics and macros in sheets/excell.