I do monitoring of some infrastructure for a private company. specifically, my job is to move around and identify non-functioning system along a defined route. all these systems have unique identification numbers.
a typical report, submitted at the end of the month looks the attached file. the comma (,) separating the figures simply indicates that several faults occurred along the same cubicle. for instance B3 means faults occurred on system numbered 20,23 and 25 and all these system take feed from the same cubicle.
several of such faults occur in a month. my job is to find out the regularity of such faults and assess the response of the company to resolving the faults. faults are deemed chronic
when the same report is filed by us for three successive days. so, for instance, if faults are reported on systems 20,23 and 25 for three days or more, the fault is chronic. the fault is still considered chronic if one of these figures (either 20 or 23 or 25) is a fault detected in three days of monitoring.
For now, I crudely have to scan through the entire worksheet and manually pick out these chronic faults and highlight them with colour.
How do i sort out, determine, pick out these chronic faults using excel functions. I'd welcome suggestions on other ways of analysing this same data.
I want the gurus to handle this for me
a typical report, submitted at the end of the month looks the attached file. the comma (,) separating the figures simply indicates that several faults occurred along the same cubicle. for instance B3 means faults occurred on system numbered 20,23 and 25 and all these system take feed from the same cubicle.
several of such faults occur in a month. my job is to find out the regularity of such faults and assess the response of the company to resolving the faults. faults are deemed chronic
when the same report is filed by us for three successive days. so, for instance, if faults are reported on systems 20,23 and 25 for three days or more, the fault is chronic. the fault is still considered chronic if one of these figures (either 20 or 23 or 25) is a fault detected in three days of monitoring.
For now, I crudely have to scan through the entire worksheet and manually pick out these chronic faults and highlight them with colour.
How do i sort out, determine, pick out these chronic faults using excel functions. I'd welcome suggestions on other ways of analysing this same data.
I want the gurus to handle this for me