Spreadsheet: 732237d1620835096-count-days-in-phase-by-using-milestone-dates-days-in-phase-v4
Sheet: Details

 |  |  |  | 1 | 2 |  | 3 |  | 4 |  | 5 |  | 6
 |  | Request ID | Process Phase | Project Created On | Implementation Solution Proposal Approved (A) | Days | Funding Complete (A) | Days | Build Complete (A) | Days | Deployment Complete (A) | Days | Project Closed Out (A) | Days
 |  | 1 | Deploy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Project Created On | Date Conditions
 |  | 2 | Deploy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Implementation Solution Proposal Approved (A) | 2 minus 1 = days in phase
 |  | 3 | Close |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Funding Complete (A) | 3 minus 2 = days in phase
 |  | 4 | Deploy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Build Complete (A) | 4 minus 3 = days in phase
 |  | 5 | Build |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | Deployment Complete (A) | 5 minus 4 = days in phase
 |  | 6 | Design and Funding |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Project Closed Out (A) | 6 minus 5 = days in phase
 |  | 7 | Close
 |  | 8 | Deploy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Conditions:
 |  | 9 | Build |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | IF both Date Conditions met, stop counting
 |  | 10 | Deploy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | IF one date met and next milestone date blank, keep counting
 |  | 11 | Deploy |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | IF error, blank
 |  | 12 | Build
 |  | 13 | Build
 |  | 14 | Build
 |  | 15 | Build
 |  | 16 | Build
 |  | 17 | Deploy
 |  | 18 | Build
 |  | 19 | Build
 |  | 20 | Build
 |  | 21 | Deploy
 |  | 22 | Deploy
 |  | 23 | Build
 |  | 24 | Consultation and Assessment
 |  | 25 | Consultation and Assessment
 |  | 26 | Build
 |  | 27 | Build
 |  | 28 | Design and Funding
 |  | 29 | Close
 |  | 30 | Consultation and Assessment
 |  | 31 | Consultation and Assessment
 |  | 32 | Consultation and Assessment
 |  | 33 | Deploy
 |  | 34 | Consultation and Assessment
 |  | 35 | Consultation and Assessment
 |  | 36 | Consultation and Assessment
 |  | 37 | Consultation and Assessment
 |  | 38 | Consultation and Assessment
 |  | 39 | Close
 |  | 40 | Consultation and Assessment
 |  | 41 | Build
 |  | 42 | Build
 |  | 43 | Build
 |  | 44 | Consultation and Assessment
 |  | 45 | Consultation and Assessment
 |  | 46 | Consultation and Assessment
 |  | 47 | Consultation and Assessment
 |  | 48 | Close
 |  | 49 | Design and Funding
 |  | 50 | Design and Funding
 |  | 51 | Consultation and Assessment
 |  | 52 | Close
 |  | 53 | Close
 |  | 54 | Consultation and Assessment
 |  | 55 | Deploy
 |  | 56 | Consultation and Assessment
 |  | 57 | Consultation and Assessment
 |  | 58 | Close
 |  | 59 | Design and Funding
 |  | 60 | Close
 |  | 61 | Close
 |  | 62 | Design and Funding
 |  | 63 | Close
 |  | 64 | Consultation and Assessment
 |  | 65 | Close
 |  | 66 | Design and Funding
 |  | 67 | Build
 |  | 68 | Build
 |  | 69 | Consultation and Assessment
 |  | 70 | Build
 |  | 71 | Build
 |  | 72 | Design and Funding
 |  | 73 | Consultation and Assessment
 |  | 74 | Consultation and Assessment
 |  | 75 | Consultation and Assessment
 |  | 76 | Close
 |  | 77 | Deploy
 |  | 78 | Deploy
 |  | 79 | Close
 |  | 80 | Close
 |  | 81 | Close
 |  | 82 | Close
 |  | 83 | Consultation and Assessment
 |  | 84 | Consultation and Assessment
 |  | 85 | Consultation and Assessment
 |  | 86 | Consultation and Assessment
 |  | 87 | Consultation and Assessment
 |  | 88 | Consultation and Assessment
 |  | 89 | Design and Funding
 |  | 90 | Deploy
 |  | 91 | Deploy
 |  | 92 | Deploy
 |  | 93 | Build
 |  | 94 | Consultation and Assessment
 |  | 95 | Close
 |  | 96 | Close
 |  | 97 | Build
 |  | 98 | Build
 |  | 99 | Close
 |  | 100 | Close
 |  | 101 | Deploy
 |  | 102 | Close
 |  | 103 | Build
 |  | 104 | Deploy
 |  | 105 | Consultation and Assessment
 |  | 106 | Deploy
 |  | 107 | Deploy
 |  | 108 | Consultation and Assessment
 |  | 109 | Consultation and Assessment
 |  | 110 | Build
 |  | 111 | Deploy
 |  | 112 | Consultation and Assessment
 |  | 113 | Close
 |  | 114 | Close
 |  | 115 | Close
 |  | 116 | Close
 |  | 117 | Build
 |  | 118 | Build
 |  | 119 | Close
 |  | 120 | Close
 |  | 121 | Deploy
 |  | 122 | Deploy
 |  | 123 | Consultation and Assessment
 |  | 124 | Close
 |  | 125 | Close
 |  | 126 | Consultation and Assessment
 |  | 127 | Design and Funding
 |  | 128 | Deploy
 |  | 129 | Close
 |  | 130 | Close
 |  | 131 | Design and Funding
 |  | 132 | Close
 |  | 133 | Consultation and Assessment
 |  | 134 | Build
 |  | 135 | Build
 |  | 136 | Build
 |  | 137 | Build
 |  | 138 | Consultation and Assessment
 |  | 139 | Close
 |  | 140 | Deploy
 |  | 141 | Deploy
 |  | 142 | Build
 |  | 143 | Build
 |  | 144 | Build
 |  | 145 | Build
 |  | 146 | Build
 |  | 147 | Deploy
 |  | 148 | Deploy
 |  | 149 | Close
 |  | 150 | Consultation and Assessment
 |  | 151 | Consultation and Assessment
 |  | 152 | Design and Funding
 |  | 153 | Consultation and Assessment
 |  | 154 | Consultation and Assessment
 |  | 155 | Consultation and Assessment
 |  | 156 | Consultation and Assessment
 |  | 157 | Consultation and Assessment
 |  | 158 | Close
 |  | 159 | Build
 |  | 160 | Deploy
 |  | 161 | Close
 |  | 162 | Consultation and Assessment
 |  | 163 | Deploy
 |  | 164 | Build
 |  | 165 | Consultation and Assessment
 |  | 166 | Deploy
 |  | 167 | Build
 |  | 168 | Build
 |  | 169 | Close
 |  | 170 | Build
 |  | 171 | Build
 |  | 172 | Build
 |  | 173 | Close
 |  | 174 | Consultation and Assessment
 |  | 175 | Consultation and Assessment
 |  | 176 | Build
 |  | 177 | Consultation and Assessment
 |  | 178 | Consultation and Assessment
 |  | 179 | Consultation and Assessment
 |  | 180 | Consultation and Assessment
 |  | 181 | Consultation and Assessment
 |  | 182 | Consultation and Assessment
 |  | 183 | Consultation and Assessment
 |  | 184 | Consultation and Assessment
 |  | 185 | Close
 |  | 186 | Consultation and Assessment
 |  | 187 | Consultation and Assessment
 |  | 188 | Consultation and Assessment
 |  | 189 | Consultation and Assessment
 |  | 190 | Consultation and Assessment
 |  | 191 | Consultation and Assessment
 |  | 192 | Deploy
 |  | 193 | Close
 |  | 194 | Design and Funding
 |  | 195 | Consultation and Assessment
 |  | 196 | Build
 |  | 197 | Build
 |  | 198 | Build
 |  | 199 | Build
 |  | 200 | Build
 |  | 201 | Build
 |  | 202 | Build
 |  | 203 | Build
 |  | 204 | Build
 |  | 205 | Build
 |  | 206 | Build
 |  | 207 | Build
 |  | 208 | Build
 |  | 209 | Build
 |  | 210 | Consultation and Assessment
 |  | 211 | Consultation and Assessment
 |  | 212 | Deploy
 |  | 213 | Consultation and Assessment
 |  | 214 | Close
 |  | 215 | Close
 |  | 216 | Consultation and Assessment
 |  | 217 | Deploy
 |  | 218 | Close
 |  | 219 | Deploy
 |  | 220 | Deploy
 |  | 221 | Close
 |  | 222 | Deploy
 |  | 223 | Close
 |  | 224 | Consultation and Assessment
 |  | 225 | Deploy
 |  | 226 | Build
 |  | 227 | Deploy
 |  | 228 | Consultation and Assessment
 |  | 229 | Consultation and Assessment
 |  | 230 | Deploy
 |  | 231 | Consultation and Assessment
 |  | 232 | Build
 |  | 233 | Consultation and Assessment
 |  | 234 | Close
 |  | 235 | Deploy
 |  | 236 | Design and Funding
 |  | 237 | Consultation and Assessment
 |  | 238 | Close
 |  | 239 | Deploy
 |  | 240 | Close
 |  | 241 | Consultation and Assessment
 |  | 242 | Consultation and Assessment
 |  | 243 | Design and Funding
 |  | 244 | Deploy
 |  | 245 | Design and Funding
 |  | 246 | Design and Funding
 |  | 247 | Close
 |  | 248 | Close
 |  | 249 | Consultation and Assessment
 |  | 250 | Close
 |  | 251 | Close
 |  | 252 | Build
 |  | 253 | Deploy
 |  | 254 | Consultation and Assessment
 |  | 255 | Consultation and Assessment
 |  | 256 | Design and Funding
 |  | 257 | Design and Funding
 |  | 258 | Design and Funding
 |  | 259 | Design and Funding
 |  | 260 | Design and Funding
 |  | 261 | Close
 |  | 262 | Design and Funding
 |  | 263 | Consultation and Assessment
 |  | 264 | Design and Funding
 |  | 265 | Consultation and Assessment
 |  | 266 | Consultation and Assessment
 |  | 267 | Consultation and Assessment
 |  | 268 | Consultation and Assessment
 |  | 269 | Close
 |  | 270 | Consultation and Assessment
 |  | 271 | Design and Funding
 |  | 272 | Consultation and Assessment
 |  | 273 | Consultation and Assessment
 |  | 274 | Consultation and Assessment
 |  | 275 | Consultation and Assessment
 |  | 276 | Close
 |  | 277 | Design and Funding
 |  | 278 | Consultation and Assessment
 |  | 279 | Design and Funding
 |  | 280 | Deploy
 |  | 281 | Close
 |  | 282 | Close
 |  | 283 | Consultation and Assessment
 |  | 284 | Build
 |  | 285 | Close
 |  | 286 | Close
 |  | 287 | Close
 |  | 288 | Consultation and Assessment
 |  | 289 | Consultation and Assessment
 |  | 290 | Consultation and Assessment
 |  | 291 | Consultation and Assessment
 |  | 292 | Consultation and Assessment
 |  | 293 | Consultation and Assessment
 |  | 294 | Consultation and Assessment
 |  | 295 | Consultation and Assessment
 |  | 296 | Consultation and Assessment
 |  | 297 | Consultation and Assessment
 |  | 298 | Consultation and Assessment
 |  | 299 | Consultation and Assessment
 |  | 300 | Close
 |  | 301 | Consultation and Assessment
 |  | 302 | Consultation and Assessment
 |  | 303 | Consultation and Assessment
 |  | 304 | Consultation and Assessment
 |  | 305 | Consultation and Assessment
 |  | 306 | Consultation and Assessment
 |  | 307 | Consultation and Assessment
 |  | 308 | Consultation and Assessment
 |  | 309 | Consultation and Assessment
 |  | 310 | Consultation and Assessment
 |  | 311 | Consultation and Assessment
 |  | 312 | Build
 |  | 313 | Consultation and Assessment
 |  | 314 | Consultation and Assessment
 |  | 315 | Consultation and Assessment
 |  | 316 | Consultation and Assessment
 |  | 317 | Build
 |  | 318 | Build
 |  | 319 | Close
 |  | 320 | Build
 |  | 321 | Build
 |  | 322 | Build
 |  | 323 | Deploy
 |  | 324 | Consultation and Assessment
 |  | 325 | Deploy
 |  | 326 | Design and Funding
 |  | 327 | Consultation and Assessment
 |  | 328 | Consultation and Assessment
 |  | 329 | Consultation and Assessment
 |  | 330 | Consultation and Assessment
 |  | 331 | Design and Funding
 |  | 332 | Consultation and Assessment
 |  | 333 | Consultation and Assessment
 |  | 334 | Design and Funding
 |  | 335 | Consultation and Assessment
 |  | 336 | Consultation and Assessment
 |  | 337 | Consultation and Assessment
 |  | 338 | Consultation and Assessment
 |  | 339 | Consultation and Assessment
 |  | 340 | Consultation and Assessment
 |  | 341 | Consultation and Assessment
 |  | 342 | Consultation and Assessment
 |  | 343 | Consultation and Assessment
 |  | 344 | Consultation and Assessment
 |  | 345 | Build
 |  | 346 | Consultation and Assessment
 |  | 347 | Consultation and Assessment
 |  | 348 | Consultation and Assessment
 |  | 349 | Consultation and Assessment
 |  | 350 | Consultation and Assessment
 |  | 351 | Consultation and Assessment
 |  | 352 | Consultation and Assessment
 |  | 353 | Consultation and Assessment
 |  | 354 | Consultation and Assessment
 |  | 355 | Consultation and Assessment
 |  | 356 | Consultation and Assessment
 |  | 357 | Consultation and Assessment
 |  | 358 | Consultation and Assessment
 |  | 359 | Consultation and Assessment
 |  | 360 | Consultation and Assessment
 |  | 361 | Consultation and Assessment
 |  | 362 | Consultation and Assessment
 |  | 363 | Consultation and Assessment
 |  | 364 | Consultation and Assessment
 |  | 365 | Consultation and Assessment
 |  | 366 | Design and Funding
 |  | 367 | Design and Funding
 |  | 368 | Design and Funding
 |  | 369 | Consultation and Assessment
 |  | 370 | Build
 |  | 371 | Close
 |  | 372 | Design and Funding
 |  | 373 | Build
 |  | 374 | Build
 |  | 375 | Design and Funding
 |  | 376 | Design and Funding
 |  | 377 | Consultation and Assessment
 |  | 378 | Consultation and Assessment
 |  | 379 | Build
 |  | 380 | Build
 |  | 381 | Design and Funding
 |  | 382 | Build
 |  | 383 | Close
 |  | 384 | Build
 |  | 385 | Build
 |  | 386 | Build
 |  | 387 | Build
 |  | 388 | Build
 |  | 389 | Deploy
 |  | 390 | Design and Funding
 |  | 391 | Build
 |  | 392 | Deploy
 |  | 393 | Consultation and Assessment
 |  | 394 | Consultation and Assessment
 |  | 395 | Consultation and Assessment
 |  | 396 | Consultation and Assessment
 |  | 397 | Build
 |  | 398 | Build
 |  | 399 | Build
 |  | 400 | Consultation and Assessment
 |  | 401 | Close
 |  | 402 | Consultation and Assessment
 |  | 403 | Close
 |  | 404 | Build
 |  | 405 | Deploy
 |  | 406 | Consultation and Assessment
 |  | 407 | Deploy
 |  | 408 | Design and Funding
 |  | 409 | Design and Funding
 |  | 410 | Consultation and Assessment
 |  | 411 | Design and Funding
 |  | 412 | Consultation and Assessment
 |  | 413 | Build
 |  | 414 | Build
 |  | 415 | Design and Funding
 |  | 416 | Deploy
 |  | 417 | Consultation and Assessment
 |  | 418 | Consultation and Assessment
 |  | 419 | Consultation and Assessment
 |  | 420 | Design and Funding
 |  | 421 | Consultation and Assessment
 |  | 422 | Build
 |  | 423 | Consultation and Assessment
 |  | 424 | Consultation and Assessment
 |  | 425 | Design and Funding
 |  | 426 | Consultation and Assessment
 |  | 427 | Consultation and Assessment
 |  | 428 | Consultation and Assessment
 |  | 429 | Consultation and Assessment
 |  | 430 | Consultation and Assessment
 |  | 431 | Consultation and Assessment
 |  | 432 | Design and Funding
 |  | 433 | Design and Funding
 |  | 434 | Consultation and Assessment
 |  | 435 | Consultation and Assessment
 |  | 436 | Consultation and Assessment
 |  | 437 | Consultation and Assessment
 |  | 438 | Consultation and Assessment
 |  | 439 | Consultation and Assessment
 |  | 440 | Build
 |  | 441 | Consultation and Assessment
 |  | 442 | Consultation and Assessment
 |  | 443 | Design and Funding
 |  | 444 | Design and Funding
 |  | 445 | Consultation and Assessment
 |  | 446 | Consultation and Assessment
 |  | 447 | Consultation and Assessment
 |  | 448 | Consultation and Assessment
 |  | 449 | Consultation and Assessment
 |  | 450 | Build
 |  | 451 | Consultation and Assessment
 |  | 452 | Consultation and Assessment
 |  | 453 | Consultation and Assessment
 |  | 454 | Consultation and Assessment
 |  | 455 | Consultation and Assessment
 |  | 456 | Build
 |  | 457 | Consultation and Assessment
 |  | 458 | Consultation and Assessment
 |  | 459 | Consultation and Assessment
 |  | 460 | Design and Funding
 |  | 461 | Consultation and Assessment
 |  | 462 | Consultation and Assessment
 |  | 463 | Design and Funding
 |  | 464 | Consultation and Assessment
 |  | 465 | Consultation and Assessment
 |  | 466 | Consultation and Assessment
 |  | 467 | Consultation and Assessment
 |  | 468 | Consultation and Assessment
 |  | 469 | Consultation and Assessment
 |  | 470 | Consultation and Assessment
 |  | 471 | Consultation and Assessment
 |  | 472 | Build
 |  | 473 | Consultation and Assessment
 |  | 474 | Consultation and Assessment
 |  | 475 | Consultation and Assessment
 |  | 476 | Design and Funding
 |  | 477 | Consultation and Assessment
 |  | 478 | Consultation and Assessment
 |  | 479 | Consultation and Assessment
 |  | 480 | Consultation and Assessment
 |  | 481 | Consultation and Assessment
 |  | 482 | Consultation and Assessment
 |  | 483 | Consultation and Assessment
 |  | 484 | Consultation and Assessment
 |  | 485 | Consultation and Assessment
 |  | 486 | Consultation and Assessment
 |  | 487 | Design and Funding
 |  | 488 | Consultation and Assessment
 |  | 489 | Consultation and Assessment
 |  | 490 | Consultation and Assessment
 |  | 491 | Design and Funding
 |  | 492 | Consultation and Assessment
 |  | 493 | Consultation and Assessment
 |  | 494 | Consultation and Assessment
 |  | 495 | Consultation and Assessment
 |  | 496 | Consultation and Assessment
 |  | 497 | Consultation and Assessment
 |  | 498 | Consultation and Assessment
 |  | 499 | Consultation and Assessment
 |  | 500 | Consultation and Assessment
 |  | 501 | Consultation and Assessment
 |  | 502 | Consultation and Assessment
 |  | 503 | Consultation and Assessment
 |  | 504 | Consultation and Assessment
 |  | 505 | Close
 |  | 506 | Consultation and Assessment
 |  | 507 | Consultation and Assessment
 |  | 508 | Consultation and Assessment
 |  | 509 | Consultation and Assessment
 |  | 510 | Consultation and Assessment
 |  | 511 | Design and Funding
 |  | 512 | Consultation and Assessment
 |  | 513 | Consultation and Assessment
 |  | 514 | Consultation and Assessment
 |  | 515 | Consultation and Assessment
 |  | 516 | Consultation and Assessment
 |  | 517 | Consultation and Assessment
 |  | 518 | Consultation and Assessment
 |  | 519 | Consultation and Assessment
 |  | 520 | Consultation and Assessment
 |  | 521 | Consultation and Assessment
 |  | 522 | Consultation and Assessment
 |  | 523 | Consultation and Assessment
 |  | 524 | Consultation and Assessment
 |  | 525 | Consultation and Assessment
 |  | 526 | Consultation and Assessment
 |  | 527 | Consultation and Assessment
 |  | 528 | Design and Funding
 |  | 529 | Consultation and Assessment
 |  | 530 | Consultation and Assessment
 |  | 531 | Consultation and Assessment
 |  | 532 | Consultation and Assessment
 |  | 533 | Consultation and Assessment
 |  | 534 | Consultation and Assessment
 |  | 535 | Consultation and Assessment
 |  | 536 | Consultation and Assessment
 |  | 537 | Consultation and Assessment
 |  | 538 | Consultation and Assessment
 |  | 539 | Consultation and Assessment
 |  | 540 | Consultation and Assessment
 |  | 541 | Build
 |  | 542 | Consultation and Assessment
 |  | 543 | Consultation and Assessment
 |  | 544 | Consultation and Assessment
 |  | 545 | Consultation and Assessment
 |  | 546 | Design and Funding
 |  | 547 | Consultation and Assessment
 |  | 548 | Consultation and Assessment
 |  | 549 | Consultation and Assessment
 |  | 550 | Consultation and Assessment
 |  | 551 | Design and Funding
 |  | 552 | Consultation and Assessment
 |  | 553 | Design and Funding
 |  | 554 | Consultation and Assessment
 |  | 555 | Consultation and Assessment
 |  | 556 | Consultation and Assessment
 |  | 557 | Consultation and Assessment
 |  | 558 | Consultation and Assessment
 |  | 559 | Consultation and Assessment
 |  | 560 | Consultation and Assessment
 |  | 561 | Consultation and Assessment
 |  | 562 | Consultation and Assessment
 |  | 563 | Consultation and Assessment
 |  | 564 | Consultation and Assessment
 |  | 565 | Consultation and Assessment
 |  | 566 | Consultation and Assessment
 |  | 567 | Consultation and Assessment
 |  | 568 | Consultation and Assessment
 |  | 569 | Consultation and Assessment
 |  | 570 | Consultation and Assessment
 |  | 571 | Consultation and Assessment
 |  | 572 | Design and Funding
 |  | 573 | Consultation and Assessment
 |  | 574 | Consultation and Assessment
 |  | 575 | Consultation and Assessment
 |  | 576 | Consultation and Assessment
 |  | 577 | Consultation and Assessment
 |  | 578 | Consultation and Assessment
 |  | 579 | Build
 |  | 580 | Consultation and Assessment
 |  | 581 | Consultation and Assessment
 |  | 582 | Consultation and Assessment
 |  | 583 | Consultation and Assessment
 |  | 584 | Consultation and Assessment
 |  | 585 | Consultation and Assessment
 |  | 586 | Consultation and Assessment
 |  | 587 | Consultation and Assessment
 |  | 588 | Consultation and Assessment
 |  | 589 | Consultation and Assessment
 |  | 590 | Consultation and Assessment
 |  | 591 | Consultation and Assessment
 |  | 592 | Consultation and Assessment
 |  | 593 | Consultation and Assessment
 |  | 594 | Design and Funding
 |  | 595 | Consultation and Assessment
 |  | 596 | Consultation and Assessment
 |  | 597 | Consultation and Assessment
 |  | 598 | Consultation and Assessment
 |  | 599 | Consultation and Assessment
 |  | 600 | Consultation and Assessment
 |  | 601 | Consultation and Assessment
 |  | 602 | Consultation and Assessment
 |  | 603 | Consultation and Assessment
 |  | 604 | Consultation and Assessment
 |  | 605 | Consultation and Assessment
 |  | 606 | Consultation and Assessment
 |  | 607 | Consultation and Assessment
 |  | 608 | Consultation and Assessment