Hello everyone.
I am currently working on a monitoring system for electrical infrastructure in my city using Google tools.
We collect operational reports from field teams and dispatchers through Google Forms. The data is stored and analyzed in Google Sheets.
We also use Google Apps Script to automate processing and generate daily reports.
Our dataset contains many repeated transformer station numbers and operational records. We want to aggregate the data and calculate risk indicators to monitor infrastructure conditions.
What would be the best approach to structure and analyze this kind of operational dataset in Google Sheets?
Any advice or best practices would be greatly appreciated.
Thank you.