Building a excel layout for data collection

LED Solution Dashboard

I could create a user friendly dashboard as per requirement. Refer attached screen shot. A pivot structure or multiple selections are also possible.