Spreadsheet: 182784d1348601053-consolidation-and-pivot-tables-template
Sheet: INITIATION

Initiation
 |  |  |  |  |  |  | WORK ORDER |  | START DATE |  | COMPLETION DATE |  | DRAFT REPORT |  |  | FINAL REPORT
Identifier | School | Boro | FY | Requestor | Manager | Consultant | Initiation Sub. Date | Initiation Assign Date | Original Forecast Date | Actual Date | Original Forecast Date | Actual Date | Original Forecast Received Date | Actual Receive Date | Distribute Date | Original Forecast Received Date | Actual Receive Date | Distribute Date | STATUS & REMARKS | WIP
78962 | Project 1 | X | 2013 | [NAME] | [NAME] | XYZ Partners | 2012-09-11 00:00:00 | 2012-09-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Yes
78556 | Project 7 | M | 2013 | [NAME] | [NAME] | ABC Corp | 2012-09-05 00:00:00 | 2012-09-05 00:00:00 |  | 2012-09-10 00:00:00 |  | 2012-09-14 00:00:00 |  |  |  |  |  |  |  | Yes
74225 | Project 3 | Q | 2013 | [NAME] | George | VBA Inc. | 2012-08-14 00:00:00 | 2012-08-14 00:00:00 |  | 2012-08-20 00:00:00 |  | 2012-08-30 00:00:00 |  | 2012-09-12 00:00:00 |  |  |  |  |  | Yes
32885 | Project 25 | K | 2013 | Martin | George | VBA Inc. | 2012-08-08 00:00:00 | 2012-08-08 00:00:00 |  | 2012-08-17 00:00:00 |  | 2012-08-21 00:00:00 |  | 2012-09-05 00:00:00 |  |  |  |  |  | Yes
Capacity | IS 137 (Additional Work) | Q | 2013 | TBD |  | Montrose | 2012-08-09 00:00:00 | 2012-08-09 00:00:00 |  |  |  |  |  | 2012-08-16 00:00:00 |  |  | 2012-08-28 00:00:00 |  | [NAME] 08/20/12 - SUBMITTED FOR REVIEW, AWAITING THE APPROVAL TO SEND THE HARDPRINTS | No
12558 | PS 73 | X | 2013 | A. Nabar |  | Montrose | 2012-08-06 00:00:00 | 2012-08-07 00:00:00 |  | 2012-08-14 00:00:00 |  | 2012-08-23 00:00:00 |  | 2012-08-29 00:00:00 |  |  | 2012-09-12 00:00:00 |  | [NAME] 08/20/12 - FIELD WORK IN PROGRESS | No
5514 | PS 254 | Q | 2012 | [NAME] |  | Montrose | 2012-07-19 00:00:00 | 2012-07-24 00:00:00 |  |  |  |  |  | 2012-08-29 00:00:00 |  |  | 2012-08-29 00:00:00 |  | [NAME] 08/20/12 - DRAFTING IN PROGESS 08/06/12 - PENDING MOBILIZATION | No
Capacity | PS 290 | Q | 2012 | R. Mifflin |  | Tectonic | 2012-06-12 00:00:00 | 2012-06-12 00:00:00 |  | 2012-06-14 00:00:00 |  | 2012-06-14 00:00:00 |  |  |  |  | 2012-06-15 00:00:00 |  | 07/16/12 - Final dwg - COMPLETED | No
14583 | PS 164 | K | 2013 | [NAME] |  | Tectonic | 2012-07-03 00:00:00 | 2012-07-11 00:00:00 |  |  |  |  |  |  |  |  | 2012-08-07 00:00:00 |  | 08/13/12 - Final dwg - COMPLETED 08/06/12 - Field Work -COMPLETED.  Drafting ( dwg. or [NAME]) in Progress 07/23/12 - Field Work -COMPLETED.  Drafting ( dwg. or [NAME]) in Progress 07/16/12 - Scheduled for 07/17/12 | No
14473 | PS 132 | Q | 2013 | [NAME] |  | Montrose | 2012-07-11 00:00:00 | 2012-07-11 00:00:00 |  | 2012-07-23 00:00:00 |  | 2012-08-02 00:00:00 |  | 2012-08-22 00:00:00 |  |  | 2012-08-22 00:00:00 |  | 08/20/12 - COMPLETED 08/06/12 - DRAFTING IN PROGRESS  07/23/12 - FIELD WORK IN PROGRESS 07/16/12 - JOB IN PROGRESS | No
Capacity | IS 137 | Q | 2013 | TBD |  | Montrose | 2012-07-10 00:00:00 | 2012-07-11 00:00:00 |  |  |  |  |  |  |  |  |  |  | 08/06/12 - COMPLETED 07/23/12 - DESCRIPTION COMPLETED 7/25/2012 07/16/12 - JOB IN PROGRESS | No
14339 | PS/IS 375 | M | 2013 | [NAME] |  | Montrose | 2012-07-05 00:00:00 | 2012-07-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | 07/23/12 - SEE MIKE DIRAC (JOB ON HOLD, MAY NOT BE NEEDED) 07/16/12 - JOB IN PROGRESS | No
Capacity | PS 170 Addition | K | 2012 | [NAME] |  | HAKS | 2012-06-22 00:00:00 | 2012-06-22 00:00:00 |  | 2012-06-29 00:00:00 |  | 2012-07-11 00:00:00 |  | 2012-08-23 00:00:00 |  |  | 2012-08-24 00:00:00 |  | 09/03/12 - Proposal submitted for ATP on 06/26/12. Field work completed. Drafting in progress. Progress drawing submitted on 07/20/12. Waiting for Electric and Cable TV record maps. Received Electric record maps. Preliminary Draft Drawings Submitted on 08/23/12 for review and comments. Final drawings submitted on 08/24/12. 08/20/12 - See previous comment 08/13/12 - See previous comment 08/06/12 -  See previous comment 07/23/12 - Proposal submitted for ATP on 06/26/12. Field work completed. Drafting in progress. Progress drawing submitted on 07/20/12. 07/16/12 - Proposal submitted for ATP on 06/26/12. Field work completed. Drafting in progress. 06/25/12 - Proposal submitted for ATP on 06/26/12. | No
14551 | PS 146 | M | 2012 | [NAME] |  | Montrose | 2012-06-06 00:00:00 | 2012-06-07 00:00:00 |  | 2012-07-17 00:00:00 |  | 2012-07-19 00:00:00 |  | 2012-08-20 00:00:00 |  |  | 2012-08-20 00:00:00 |  | [NAME] 08/20/12 - WAITING FOR A SKETCH FROM THE SCA 08/06/12 - SUBMITTED FOR REVIEW 07/23/12 - DRAFTING IN PROGRESS 07/16/12 - JOB IN PROGRESS 06/25/12 - awaiting clarification on instruction from the SCA | No
Capacity | PS 106 | X | 2012 | [NAME] |  | Montrose | 2012-06-26 00:00:00 | 2012-06-26 00:00:00 |  | 2012-07-12 00:00:00 |  | 2012-07-13 00:00:00 |  | 2012-07-25 00:00:00 |  |  | 2012-07-25 00:00:00 |  | COMPLETED 07/23/12 - DRAFTING IN PROGRESS 07/16/12 - DRAFTING IN PROGRESS 06/25/12 - fieldwork in progress | No
14131 | PS 78 | X | 2012 | [NAME] |  | HAKS | 2012-04-10 00:00:00 | 2012-04-11 00:00:00 |  | 2012-04-23 00:00:00 |  | 2012-05-14 00:00:00 |  | 2012-05-29 00:00:00 |  |  | 2012-08-24 00:00:00 |  | 09/03/12 - Proposal Submitted for ATP on 04/12/12. Field work completed. Preliminary Draft Drawings Submitted on 05/29/12 for review and comments. Waiting for Cable TV record maps. Final drawings submitted on 08/24/12. 08/20/12 - See previous comment 08/13/12 - See previous comment 08/06/12 -  See previous comment 07/23/12 - Proposal Submitted for ATP on 04/12/12. Field work completed. Preliminary Draft Drawings Submitted on 05/29/12 for review and comments. Waiting for Cable TV record maps. 07/16/12 - See previous comment 06/25/12 - Proposal Submitted for ATP on 04/12/12. Field work completed. Preliminary Draft Drawings Submitted on 05/29/12 for review and comments. Waiting for Cable TV record maps. 05/14/12 - Proposal Submitted for ATP on 04/12/12. Field work completed. 04/30/12 - See previous comment 04/23/12 - Proposal Submitted for ATP on 04/12/12. Field work in progress. 04/16/12 - Proposal Submitted for ATP on 04/12/12. | No
14040 | PS 191 | M | 2012 | [NAME] |  | HAKS | 2012-03-05 00:00:00 | 2012-03-05 00:00:00 |  | 2012-03-19 00:00:00 |  | 2012-03-30 00:00:00 |  | 2012-04-06 00:00:00 |  |  | 2012-08-24 00:00:00 |  | 09/04/12 - Proposal Submitted for ATP on 03/06/12. Field work completed. Preliminary Draft Drawings Submitted on 4/6/12 for review and comments. Resent request for Cable TV record maps. Waiting for Cable TV record maps. Final drawings submitted on 08/24/12. 08/20/12 - See previous comment 08/13/12 - See previous comment 08/06/12 -  See previous comment 07/23/12 - See previous comment 07/16/12 - See previous comment 06/25/12 - Proposal Submitted for ATP on 03/06/12. Field work completed. Preliminary Draft Drawings Submitted on 4/6/12 for review and comments. Resent request for Cable TV record maps. Waiting for Cable TV record maps 05/14/12 - See previous comment 04/30/12 - See previous comment 04/23/12 - Proposal Submitted for ATP on 03/06/12. Field work completed. Preliminary Draft Drawings Submitted on 4/6/12 for review and comments. Waiting for Cable TV record maps. 04/16/12 - Proposal Submitted for ATP on 03/06/12. Field work completed. Preliminary Draft Drawings Submitted on 4/6/12 for review and comments. Waiting for Cable TV record maps. 04/02/12 - Proposal Submitted for ATP on 03/06/12. Field work completed. Drafting in progress. 03/19/12 - Proposal Submitted for ATP on 03/06/12. Field work in progress. | No
14359 | PS 9 | M | 2012 | [NAME] |  | HAKS | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 |  | 2/6/2012, 03/12/12 |  | 2/24/2012, 03/21/12 |  | 3/9/2012, 03/27/12 |  |  | 2012-09-05 00:00:00 |  | 09/10/12 - Proposal Submitted for ATP on 01/12/12. Field work completed. Preliminary Draft Drawings Submitted on 3/9/12 for review and comments. Request for additional survey area received on 3/12/12. Proposal for additional survey area submitted on 3/16/12. Field work completed for additional survey area. Preliminary Draft Drawings for additional survey area submitted on 3/27/12 for review and comments. Waiting for SCA request to submit final drawing. Final drawings submitted on 09/05/12. 09/03/12 - Proposal Submitted for ATP on 01/12/12. Field work completed. Preliminary Draft Drawings Submitted on 3/9/12 for review and comments. Request for additional survey area received on 3/12/12. Proposal for additional survey area submitted on 3/16/12. Field work completed for additional survey area. Preliminary Draft Drawings for additional survey area submitted on 3/27/12 for review and comments. Waiting for SCA request to submit final drawing. Final drawings will be submitted on 09/04/12. 08/20/12 - See previous comment 08/06/12 -  See previous comment 07/23/12 - See previous comment 07/16/12 - See previous comment 06/25/12 - Proposal Submitted for ATP on 01/12/12. Field work completed. Preliminary Draft Drawings Submitted on 3/9/12 for review and comments. Request for additional survey area received on 3/12/12. Proposal for additional survey area submitted on 3/16/12. Field work completed for additional survey area. Preliminary Draft Drawings for additional survey area submitted on 3/27/12 for review and comments. Waiting for SCA request to submit final drawing. 05/14/12 - See previous comment 04/30/12 - See previous comment 04/23/12 - Proposal Submitted for ATP on 01/12/12. Field work completed. Preliminary Draft Drawings Submitted on 3/9/12 for review and comments. Request for additional survey area received on 3/12/12. Proposal for additional survey area submitted on 3/16/12. Field work completed for additional survey area. Preliminary Draft Drawings for additional survey area submitted on 3/27/12 for review and comments. Waiting for request to submit final drawing. 04/16/12 - See previous comment 04/02/12 - Proposal Submitted for ATP on 01/12/12. Field work completed. Preliminary Draft Drawings Submitted on 3/9/12 for review and comments. Request for additional survey area received on 3/12/12. Proposal for additional survey area submitted on 3/16/12. Field work completed for additional survey area. Preliminary Draft Drawings for additional survey area submitted on 3/27/12 for review and comments. 03/19/12 - Proposal Submitted for ATP on 01/12/12. Field work completed. Preliminary Draft Drawings Submitted on 3/9/12 for review and comments. Request for additional survey area received on 3/12/12. Proposal for additional survey area submitted on 3/16/12. Field work in progress for additional survey area. 03/05/12 - Proposal Submitted for ATP on 01/12/12. Field work completed. Drafting in progress. 02/06/12 - Proposal Submitted for ATP on 01/12/12. Field work in progress. 01/23/12 - Proposal Submitted for ATP on 01/12/12. | No
14348 | PS 72 | X | 2012 | [NAME] |  | HAKS | 2011-12-22 00:00:00 | 2011-12-27 00:00:00 |  | 2012-01-19 00:00:00 |  | 2012-02-03 00:00:00 |  | 2012-02-17 00:00:00 |  |  | 2012-05-07 00:00:00 |  | COMPLETED 07/16/12 - See previous comment 06/25/12 - Proposal Submitted for ATP on 01/06/12. Field work completed. Drafting in progress. Waiting for Cable TV record maps. Preliminary Draft Drawings Submitted on 2/17/12 for review and comments. Final drawing submitted on 5/7/12. 05/14/12 - See previous comment 04/23/12 - See previous comment 04/16/12 - See previous comment 04/02/12 - See previous comment 03/19/12 - Proposal Submitted for ATP on 12/27/11.  Field work completed. Drafting in progress. Waiting for Cable TV record maps. Received Cable TV record maps. Preliminary Draft Drawings Submitted on 3/6/12 for review and comments. 03/05/12 - Proposal Submitted for ATP on 12/27/11.  Field work completed. Drafting in progress. Waiting for Cable TV record maps. Received Cable TV record maps. Preliminary drawing will be submitted on 3/6/12. 02/06/12 - Proposal Submitted for ATP on 12/27/11.  Field work completed. Drafting in progress. Waiting for Cable TV record maps. 01/23/12 - Proposal Submitted for ATP on 12/27/11.  Field work completed. Drafting in progress. Waiting for Electric, Gas & Telephone record maps. 01/09/12 - Proposal Submitted for ATP on 12/27/11.  Field work in Progress 01/03/12 - Proposal Submitted for ATP on 12/27/11. | No
14329 | PS 100 | K | 2012 | R. Mifflin |  | HAKS | 2011-12-14 00:00:00 | 2011-12-14 00:00:00 |  | 2011-12-21 00:00:00 |  | 2012-01-06 00:00:00 |  | 2/3/2012, 02/27/12 |  |  | 2012-05-07 00:00:00 |  | 08/06/12 - Proposal Submitted for ATP on 01/06/12. Field work completed. Drafting in progress. Waiting for Cable TV record maps. Preliminary Draft Drawings Submitted on 2/17/12 for review and comments. Final drawing submitted on 5/7/12. 06/25/12 - Proposal Submitted for ATP on 12/27/11.  Field work completed. Drafting in progress. Waiting for Cable TV record maps. Received Cable TV record maps. Preliminary Draft Drawings Submitted on 3/6/12 for review and comments. Waiting for SCA request to submit final drawing. 05/14/12 - See previous comment 04/30/12 - See previous comment 04/23/12 - See previous comment 04/16/12 - Proposal Submitted for ATP on 12/14/11. Field work completed. Drafting in progress. Waiting for Gas & Telephone record maps. Progress drawing submitted on 02/03/2012. Waiting for Telephone record maps. Received comments from Architect on 2/27/12. Incorporated Comments by Architects and Submitted Revised Preliminary Drawing on 2/27/12. Waiting for request to submit final drawing. 04/02/12 - See previous comment 03/19/12 - See previous comment 03/05/12 - Proposal Submitted for ATP on 12/14/11. Field work completed. Drafting in progress. Waiting for Gas & Telephone record maps. Progress drawing submitted on 02/03/2012. Waiting for Telephone record maps. Received comments from Architect on 2/27/12. Incorporated Comments by Architects and Submitted Revised Preliminary Drawing on 2/27/12. 02/06/12 - Proposal Submitted for ATP on 12/14/11. Field work completed. Drafting in progress. Waiting for Gas & Telephone record maps. Progress drawing submitted on 02/03/2012. Waiting for Telephone record maps. 01/23/12 - Proposal Submitted for ATP on 12/14/11. Field work completed. Drafting in progress. Waiting for Gas & Telephone record maps. 01/09/12 - Proposal Submitted for ATP on 12/14/11. Field work completed. Drafting in progress. 01/03/12 - Proposal Submitted for ATP on 12/14/11. Field work in Progress | No