Estimate Work Orders Per Year

[wsnyder]

Hi,

Using O365.

I have:
Install Date of new equipment over various dates (fairly recent)
Repair records for the equipment since the install date
Some equipment is no new, no repairs as of yet.

How can I use the data to estimate a number of repairs/equipment/year?

Thanks,
-Lou

 

[levy77]

You could look at using the =FORECAST() function, this may not be that accurate for what you want but worth a try I suppose.