Hi Mom,
I've reviewed the last three years' Timeline spreadsheet, and one critical timeframe is the period after the Bio(or Bio Walk-in) and before receiving the CPO, particularly when the interview is waived or the IL (indicating that the background check is likely complete).
I suggest adding two columns to the spreadsheet:
1."CPO - Bio" with this formula:
=IF(ISDATE(AD3), IF(AND(ISDATE(W3), ISDATE(X3)), AD3-MIN(W3, X3), IF(OR(ISDATE(W3), ISDATE(X3)), AD3-IF(ISDATE(W3), W3, X3), "N/A")), "N/A")
2."Interview Notice Received Date - Bio" with this formula:
=IF(ISDATE(Y3), IF(AND(ISDATE(W3), ISDATE(X3)), Y3-MIN(W3, X3), IF(OR(ISDATE(W3), ISDATE(X3)), Y3-IF(ISDATE(W3), W3, X3), "N/A")), "N/A")
I would appreciate it if you could add these columns to the spreadsheet for everyone's benefit. Of course, I can conduct my own analysis for 2024, but I cannot access the data for 2023 and 2022 as it is locked.
Thank you for your consideration.