We have been tasked to gather weekly meter data: multiple meters (3-10) for each utility (water, electricity, natural gas) at each of the 60 plants.
What is the best way to gather multiple data points from mulitple plants all at once? We are unsure how to format this correctly.
The plants will have to entrer Meter Name, Meter Number, Meter Reading for each utility every week. We do not have each plant's specific number of meters, nor do we have their meter names. It would be nice to gather this data from them first then have the sheet formatted using this data for them to select each time based on which plant they are at.
Does it make sense for each plant to have a worksheet or each utility (electricity, water, natural gas) to have its own sheet and the plant is a drop down selection?
How can we set this up to use the task reminders with the weeks set? but then how do they add multiple meters to that particular week? Or do we just use web forms to add new rows for each meter and have these sent out on a recurring basis through Outlook?