Dr Andrew Brint has recently been awarded £22,000 through Ofgem’s Innovative Funding Initiative to help CE-Electric solve a problem. Utility distribution network owners need to ensure that their networks (electricity, water, gas, roads) are maintained to a sufficient level to meet their service requirements. However asset condition information for items such as individual 11kV switchgear is collected infrequently over long periods of time. This means that a recently determined overall condition index is often only known for a proportion of the assets. Detailed knowledge of the conditions of the other assets stems from when they were last inspected which typically could be 10 years ago. However, it is important to be able to accurately estimate the number of assets currently in each overall condition index interval (e.g. between 0 and 1, between 1 and 2, etc.) for planning purposes. Hence information from the older inspections of items that have not recently been inspected, is still important but is just less reliable than information from items that have recently been observed. Combining these sources of information together is not a problem covered by standard statistical theory. Consequently the project developed a number of estimation procedures and compared their performance in a variety of circumstances with the aim of identifying a technique (or techniques) that was easy to implement in Excel and that provided accurate predictions.