I have just started working with a company on a variety of different IT issues, mostly Sharepoint 2010. They are going to contract a Sharepoint developer to help with a problem they have been having but I would like to see if anyone had some pointers with this.
The situation is that we have a bunch of printers/copiers/etc entered as items in a list, and each piece of equipment has a usage meter. We track the meters for billing purposes. We would like to be able to track the meter's history of values for each piece of equipment. The meter reads aren't at regular intervals; they occur at varying frequencies. The way we currently track the meters is that we either have someone call the company and get meter reads and then enter them into an Excel spreadsheet, or we have our technicians enter the meter read into a service call ticket when they service or check up on a machine (the service calls are on a separate list).
Ideally we would like to be able to pull up a piece of equipment and see the entire history of meter reads, or choose a time period and see all meter reads on all equipment (or one client's equipment) over that time period, either through list views or through reports.
One suggestion someone had was that we could have a list for each item in the equipment list showing the meter reads, but this seems like way too many lists. Any help would be appreciated.