That was the result of a lot of work the last three weeks,...
That was the result of a lot of work the last three weeks, in which (Francis) analyzed what had been happening.
That was the result of a lot of work the last three weeks, in which (Francis) analyzed what had been happening.