Spreadsheet: 836242d1689198910-combination-countifs-sumifs-book1_r2
Sheet: RawData

Contact | Project | Task | % Complete | Start | Finish | Prev. Month Start | Prev. Month Finish | Actual Start | Actual Finish | [NAME] | Basline Finish | Forecast Finish | Completed As Planned | Missed Tasks | Completed Early
Doe, J. | PA | Task_51 | 0.93 | 2022-08-16 00:00:00 | 2022-10-24 00:00:00 | NA | NA | 2022-08-16 00:00:00 | NA | NA | NA | 0 | 0 | 0 | 0
Doe, J. | PA | Task_52 | 0 | 2022-10-25 00:00:00 | 2022-10-27 00:00:00 | NA | NA | NA | NA | NA | NA | 1 | 1 | 0 | 0
Doe, J. | PC | Task_53 | 0 | 2022-10-27 00:00:00 | 2022-10-29 00:00:00 | NA | NA | NA | NA | NA | NA | 0 | 0 | 0 | 0
Doe, J. | PD | Task_54 | 0 | 2022-10-30 00:00:00 | 2022-11-08 00:00:00 | NA | NA | NA | NA | NA | NA | 0 | 0 | 0 | 0
Doe, J. | PD | Task_55 | 0 | 2022-11-08 00:00:00 | 2022-11-10 00:00:00 | NA | NA | NA | NA | NA | NA | 0 | 0 | 0 | 0
Doe, J. | PD | Task_56 | 0 | 2022-10-27 00:00:00 | 2022-11-02 00:00:00 | 2022-10-27 00:00:00 | 2022-11-02 00:00:00 | NA | NA | 2022-08-29 00:00:00 | 2022-09-02 00:00:00 | 1 | 0 | 1 | 0
Doe, J. | PD | Task_57 | 0 | 2022-11-14 00:00:00 | 2022-11-15 00:00:00 | NA | NA | NA | NA | NA | NA | 0 | 0 | 0 | 0
Doe, J. | PD | Task_58 | 0 | 2022-11-15 00:00:00 | 2022-11-19 00:00:00 | NA | NA | NA | NA | NA | NA | 0 | 0 | 0 | 0
Doe, J. | PD | Task_59 | 0 | 2022-11-19 00:00:00 | 2022-11-20 00:00:00 | NA | NA | NA | NA | NA | NA | 0 | 0 | 0 | 0
Doe, J. | PE | Task_60 | 0 | 2022-11-21 00:00:00 | 2022-11-21 00:00:00 | NA | NA | NA | NA | NA | NA | 1 | 0 | 0 | 1
Doe, J. | PE | Task_1176 | 1 | 2021-01-04 00:00:00 | 2022-06-30 00:00:00 | 2021-01-04 00:00:00 | 2022-06-30 00:00:00 | 2021-01-04 00:00:00 | 2022-06-30 00:00:00 | NA | NA | 0 | 0 | 0 | 0
Doe, J. | PE | [NAME] | 0.93 | 2021-01-04 00:00:00 | 2022-12-01 00:00:00 | 2021-01-04 00:00:00 | 2022-12-01 00:00:00 | 2021-01-04 00:00:00 | NA | NA | NA | 0 | 0 | 0 | 0
Doe, J. | PE | Task_1184 | 0.93 | 2021-01-04 00:00:00 | 2022-12-01 00:00:00 | 2021-01-04 00:00:00 | 2022-12-01 00:00:00 | 2021-01-04 00:00:00 | NA | NA | NA | 0 | 0 | 0 | 0
Doe, J. | PE | Task_1186 | 0.93 | 2021-01-04 00:00:00 | 2022-12-01 00:00:00 | 2021-01-04 00:00:00 | 2022-12-01 00:00:00 | 2021-01-04 00:00:00 | NA | NA | NA | 0 | 0 | 0 | 0
Smith, M. | PA | Task_1187 | 0.93 | 2021-01-04 00:00:00 | 2022-12-01 00:00:00 | 2021-01-04 00:00:00 | 2022-12-01 00:00:00 | 2021-01-04 00:00:00 | NA | NA | NA | 0 | 0 | 0 | 0
Smith, M. | PA | Task_1188 | 0.93 | 2021-01-04 00:00:00 | 2022-12-01 00:00:00 | 2021-01-04 00:00:00 | 2022-12-01 00:00:00 | 2021-01-04 00:00:00 | NA | NA | NA | 0 | 0 | 0 | 0
Smith, M. | PC | Task_1857 | 1 | 2022-09-12 00:00:00 | 2022-09-26 00:00:00 | 2022-09-12 00:00:00 | 2022-09-26 00:00:00 | 2022-09-12 00:00:00 | 2022-09-26 00:00:00 | 2022-08-08 00:00:00 | 2022-08-12 00:00:00 | 0 | 0 | 0 | 0
Smith, M. | PD | Task_1866 | 0 | 2022-10-27 00:00:00 | 2022-11-02 00:00:00 | 2022-10-27 00:00:00 | 2022-11-02 00:00:00 | NA | NA | 2022-08-29 00:00:00 | 2022-09-02 00:00:00 | 1 | 0 | 1 | 0
Smith, M. | PD | Task_1876 | 0 | 2022-10-31 00:00:00 | 2022-11-03 00:00:00 | 2022-10-31 00:00:00 | 2022-11-03 00:00:00 | NA | NA | 2022-09-27 00:00:00 | 2022-09-30 00:00:00 | 1 | 0 | 0 | 1
Smith, M. | PD | Task_1889 | 0 | 2022-11-11 00:00:00 | 2022-11-17 00:00:00 | 2022-11-11 00:00:00 | 2022-11-17 00:00:00 | NA | NA | 2022-10-18 00:00:00 | 2022-10-24 00:00:00 | 1 | 0 | 0 | 1
Vader, D. | PB | Task_1890 | 0 | 2022-11-18 00:00:00 | 2022-11-28 00:00:00 | 2022-11-18 00:00:00 | 2022-11-28 00:00:00 | NA | NA | 2022-10-25 00:00:00 | 2022-10-31 00:00:00 | 0 | 0 | 0 | 0
Vader, D. | PD | [NAME] | 0 | 2023-01-25 00:00:00 | 2023-01-30 00:00:00 | 2023-01-25 00:00:00 | 2023-01-30 00:00:00 | NA | NA | 2022-12-08 00:00:00 | 2022-12-13 00:00:00 | 0 | 0 | 0 | 0
Vader, D. | PD | Task_1986 | 1 | 2022-01-24 00:00:00 | 2022-09-28 00:00:00 | 2022-01-24 00:00:00 | 2022-09-28 00:00:00 | 2022-01-24 00:00:00 | 2022-09-28 00:00:00 | NA | NA | 0 | 0 | 0 | 0
Vader, D. | PE | Task_1987 | 1 | 2022-02-28 00:00:00 | 2022-08-26 00:00:00 | 2022-02-28 00:00:00 | 2022-08-26 00:00:00 | 2022-02-28 00:00:00 | 2022-08-26 00:00:00 | NA | NA | 0 | 0 | 0 | 0
Vader, D. | PE | Task_1988 | 1 | 2022-03-08 00:00:00 | 2022-09-26 00:00:00 | 2022-03-08 00:00:00 | 2022-09-26 00:00:00 | 2022-03-08 00:00:00 | 2022-09-26 00:00:00 | NA | NA | 0 | 0 | 0 | 0
Vader, D. | PE | [NAME] | 1 | 2022-09-20 00:00:00 | 2022-09-29 00:00:00 | 2022-09-20 00:00:00 | 2022-09-29 00:00:00 | 2022-09-20 00:00:00 | 2022-09-29 00:00:00 | NA | NA | 0 | 0 | 0 | 0
Vader, D. | PE | Task_2081 | 1 | 2022-10-03 00:00:00 | 2022-10-12 00:00:00 | 2022-10-03 00:00:00 | 2022-10-12 00:00:00 | 2022-10-03 00:00:00 | 2022-10-12 00:00:00 | NA | NA | 1 | 1 | 0 | 0
Vader, D. | PE | Task_2082 | 0.33 | 2022-10-12 00:00:00 | 2022-10-26 00:00:00 | NA | NA | 2022-10-12 00:00:00 | NA | NA | NA | 1 | 0 | 1 | 0
[NAME], [NAME] | PA | Task_2083 | 0.2 | 2022-10-13 00:00:00 | 2022-10-26 00:00:00 | 2022-10-13 00:00:00 | 2022-10-26 00:00:00 | 2022-10-13 00:00:00 | NA | NA | NA | 1 | 1 | 0 | 0
[NAME], [NAME] | PA | Task_2084 | 0 | 2022-10-27 00:00:00 | 2022-11-16 00:00:00 | 2022-10-27 00:00:00 | 2022-11-16 00:00:00 | NA | NA | NA | NA | 0 | 0 | 0 | 0
[NAME], [NAME] | PC | Task_2085 | 0 | 2022-11-29 00:00:00 | 2022-11-29 00:00:00 | 2022-11-29 00:00:00 | 2022-11-29 00:00:00 | NA | NA | NA | NA | 0 | 0 | 0 | 0
[NAME], [NAME] | PD | Task_1877 | 0 | 2022-10-31 00:00:00 | 2022-11-04 00:00:00 | 2022-11-01 00:00:00 | 2022-11-07 00:00:00 | NA | NA | 2022-09-27 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], [NAME] | PD | Task_1878 | 0 | 2022-11-03 00:00:00 | 2022-11-16 00:00:00 | 2022-11-01 00:00:00 | 2022-11-14 00:00:00 | NA | NA | 2022-09-27 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], [NAME] | PD | Task_1879 | 0 | 2022-11-17 00:00:00 | 2022-12-02 00:00:00 | 2022-11-15 00:00:00 | 2022-11-30 00:00:00 | NA | NA | 2022-10-11 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], [NAME] | PD | Task_1880 | 0 | 2022-12-05 00:00:00 | 2022-12-16 00:00:00 | 2022-12-01 00:00:00 | 2022-12-14 00:00:00 | NA | NA | 2022-10-25 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], [NAME] | PD | Task_1881 | 0 | 2022-11-03 00:00:00 | 2022-11-23 00:00:00 | 2022-11-01 00:00:00 | 2022-11-21 00:00:00 | NA | NA | 2022-09-27 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], [NAME] | PD | Task_1882 | 0 | 2022-11-28 00:00:00 | 2022-12-09 00:00:00 | 2022-11-22 00:00:00 | 2022-12-07 00:00:00 | NA | NA | 2022-10-18 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], [NAME] | PE | Task_1883 | 0 | 2022-12-12 00:00:00 | 2023-01-03 00:00:00 | 2022-12-08 00:00:00 | 2022-12-21 00:00:00 | NA | NA | 2022-11-01 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], P. | PE | Task_1885 | 0 | 2023-01-04 00:00:00 | 2023-01-10 00:00:00 | 2022-12-22 00:00:00 | 2023-01-06 00:00:00 | NA | NA | 2022-11-15 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], P. | PE | Task_1886 | 0 | 2022-10-21 00:00:00 | 2022-10-27 00:00:00 | 2022-11-01 00:00:00 | 2022-11-07 00:00:00 | NA | NA | 2022-09-27 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], P. | PE | Task_1887 | 0 | 2022-10-28 00:00:00 | 2022-11-03 00:00:00 | 2022-11-08 00:00:00 | 2022-11-14 00:00:00 | NA | NA | 2022-10-04 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], P. | PE | Task_1888 | 0 | 2022-11-04 00:00:00 | 2022-11-10 00:00:00 | 2022-11-15 00:00:00 | 2022-11-21 00:00:00 | NA | NA | 2022-10-11 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], P. | PA | Task_1889 | 0 | 2022-11-11 00:00:00 | 2022-11-17 00:00:00 | 2022-11-22 00:00:00 | 2022-11-30 00:00:00 | NA | NA | 2022-10-18 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], P. | PA | Task_1890 | 0 | 2022-11-18 00:00:00 | 2022-11-28 00:00:00 | 2022-12-01 00:00:00 | 2022-12-07 00:00:00 | NA | NA | 2022-10-25 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], P. | PC | Task_1891 | 0 | 2022-11-11 00:00:00 | 2022-11-17 00:00:00 | 2022-11-22 00:00:00 | 2022-12-21 00:00:00 | NA | NA | 2022-10-18 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], P. | PD | Task_1892 | 0 | 2022-11-18 00:00:00 | 2022-11-28 00:00:00 | 2022-12-01 00:00:00 | 2022-01-20 00:00:00 | NA | NA | 2022-10-25 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], P. | PD | Task_1893 | 0 | 2022-12-19 00:00:00 | 2023-01-03 00:00:00 | 2022-12-15 00:00:00 | 2022-02-24 00:00:00 | NA | NA | 2022-11-08 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], P. | PD | [NAME] | 0 | 2023-01-04 00:00:00 | 2023-01-24 00:00:00 | 2022-12-22 00:00:00 | 2023-01-06 00:00:00 | NA | NA | 2022-11-15 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], P. | PD | Task_1895 | 0 | 2023-01-25 00:00:00 | 2023-02-28 00:00:00 | 2023-01-23 00:00:00 | 2023-01-27 00:00:00 | NA | NA | 2022-12-08 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], P. | PD | Task_1896 | 0 | 2023-01-04 00:00:00 | 2023-01-10 00:00:00 | 2022-12-22 00:00:00 | 2023-03-03 00:00:00 | NA | NA | 2022-11-15 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], P. | PD | Task_1897 | 0 | 2023-01-11 00:00:00 | 2023-01-31 00:00:00 | 2023-01-09 00:00:00 | 2023-01-13 00:00:00 | NA | NA | 2022-11-22 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], P. | PE | Task_1898 | 0 | 2023-03-01 00:00:00 | 2023-03-07 00:00:00 | 2023-02-27 00:00:00 | 2023-01-20 00:00:00 | NA | NA | 2023-01-23 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], R. | PA | Task_1899 | 0 | 2023-01-11 00:00:00 | 2023-01-17 00:00:00 | 2023-01-09 00:00:00 | 2023-01-26 00:00:00 | NA | NA | 2022-11-22 00:00:00 |  | 1 | 1 | 0 | 0
[NAME], R. | PB | Task_1900 | 0 | 2023-01-18 00:00:00 | 2023-01-24 00:00:00 | 2023-01-16 00:00:00 | 2023-01-27 00:00:00 | NA | NA | 2022-12-01 00:00:00 |  | 1 | 1 | 0 | 0
[NAME], R. | PC | [NAME] | 0 | 2023-01-25 00:00:00 | 2023-01-30 00:00:00 | 2023-01-23 00:00:00 | 2023-03-10 00:00:00 | NA | NA | 2022-12-08 00:00:00 |  | 1 | 1 | 0 | 0
[NAME], R. | PD | Task_1902 | 0 | 2023-01-25 00:00:00 | 2023-01-31 00:00:00 | 2023-01-23 00:00:00 | 2023-03-24 00:00:00 | NA | NA | 2022-12-08 00:00:00 |  | 1 | 0 | 1 | 0
[NAME], R. | PE | Task_1903 | 0 | 2023-03-01 00:00:00 | 2023-03-14 00:00:00 | 2023-02-27 00:00:00 | 2023-04-07 00:00:00 | NA | NA | 2023-01-23 00:00:00 |  | 1 | 0 | 1 | 0
[NAME], R. | PE | Task_1904 | 0 | 2023-03-15 00:00:00 | 2023-03-28 00:00:00 | 2023-03-13 00:00:00 | 2023-02-10 00:00:00 | NA | NA | 2023-02-06 00:00:00 |  | 1 | 1 | 0 | 0
[NAME], R. | PE | Task_1905 | 0 | 2023-03-29 00:00:00 | 2023-04-11 00:00:00 | 2023-03-27 00:00:00 | 2023-02-24 00:00:00 | NA | NA | 2023-02-20 00:00:00 |  | 1 | 0 | 0 | 1
Lincoln, A. | PD | Task_1906 | 0 | 2023-02-01 00:00:00 | 2023-02-14 00:00:00 | 2023-01-30 00:00:00 | 2023-03-10 00:00:00 | NA | NA | 2022-12-15 00:00:00 |  | 1 | 0 | 1 | 0
[NAME], F. | PA | Task_1907 | 0 | 2023-02-15 00:00:00 | 2023-02-28 00:00:00 | 2023-02-13 00:00:00 | 2023-02-24 00:00:00 | NA | NA | 2023-01-09 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], F. | PB | Task_1908 | 0 | 2023-03-01 00:00:00 | 2023-03-14 00:00:00 | 2023-02-27 00:00:00 | 2023-03-10 00:00:00 | NA | NA | 2023-01-23 00:00:00 |  | 0 | 0 | 0 | 0
[NAME], F. | PD | Task_1909 | 0 | 2023-01-25 00:00:00 | 2023-02-07 00:00:00 | 2023-01-23 00:00:00 | 2023-02-03 00:00:00 | NA | NA | 2022-12-08 00:00:00 |  | 0 | 0 | 0 | 0
Nuts, D. | PD | Task_1910 | 0 | 2023-04-12 00:00:00 | 2023-04-18 00:00:00 | 2023-04-10 00:00:00 | 2023-04-14 00:00:00 | NA | NA | 2023-03-06 00:00:00 |  | 1 | 1 | 0 | 0