{"text_format":"1","workbook":"xlsx","n_sheets":31,"sheets":["Project Management Main","CHECKLISTS ---->","Planning Task List","Schematic Design Task List","Design Development Task List","Construction Document Task List","Bidding Task List","Pre-construction Task List","Construction Task List","Close-out Task List","PROCESS MAPS ---->","CP Delivery Phases","Planning Process","Schematic Design Process","Design Development Process","Construction Docs Process","Bidding Process","Pre-Construction Process","Construction Process","Closeout Process","PM TOOLS---->","Project Status Reports","Project Planning Partners List","Issues Log","Deviations Log","Project A3","Team Contact List","Drop-down lists","CODING --->","THIS_CP","ACTIVE_CPS"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":32,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Project Management Main","index":0,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[[22,13,24,13],[41,13,41,14],[42,13,42,14],[43,13,43,14],[36,12,36,14],[37,12,37,14],[38,12,38,14],[39,12,39,14],[40,13,40,14],[31,12,31,14],[32,12,32,14],[33,12,33,14],[34,12,34,14],[35,12,35,14],[39,2,39,4],[39,6,39,10],[33,2,33,4],[25,2,25,4],[29,6,29,10],[28,2,28,4],[27,2,27,4],[43,6,43,10],[9,9,10,9],[6,2,6,10],[26,2,26,4],[6,12,6,14],[24,2,24,4],[23,2,23,4],[13,2,13,4],[13,6,13,10],[8,7,8,8],[10,3,10,8],[20,12,20,14],[21,2,21,4],[22,2,22,4],[24,6,24,10],[29,12,29,14]]}
[]
[]
[]
[]
[]
[]
[null,null,"Project Information",null,null,null,null,null,null,null,null,null,"Internal Team"]
[]
[null,null,"Project Number",null,null,null,"Current Phase",{"$f":"IF(THIS_CP!C2=FALSE,\" \",THIS_CP!C2)","v":{"$error":"#N/A"}},null,null,null,null,"Project Manager",{"$f":"IF(THIS_CP!D2=FALSE,\" \",THIS_CP!D2)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null," ",null,"Customer",{"$f":"IF(THIS_CP!E2=FALSE,\" \",THIS_CP!E2)","v":{"$error":"#N/A"}}]
[null,null,"Project Name",{"$f":"IF(THIS_CP!B2=FALSE,\" \",THIS_CP!B2)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Architect",{"$f":"THIS_CP!F2","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Interior Designer",{"$f":"IF(THIS_CP!G2=FALSE,\" \",THIS_CP!G2)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Landscape Architect",{"$f":"IF(THIS_CP!H2=FALSE,\" \",THIS_CP!H2)","v":{"$error":"#N/A"}}]
[null,null,"Budget",null,null,null,"Schedule - Planned Dates",null,null,null,null,null,"Civil Engineer",{"$f":"IF(THIS_CP!I2=FALSE,\" \",THIS_CP!I2)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"Start","End","% complete",null,null,"Mechanical Engineer",{"$f":"IF(THIS_CP!J2=FALSE,\" \",THIS_CP!J2)","v":{"$error":"#N/A"}}]
[null,null,"Estimated Cost",{"$f":"THIS_CP!Q$2","v":{"$error":"#N/A"}},null,null,"Planning",{"$f":"THIS_CP!T$2","v":{"$error":"#N/A"}},{"$f":"THIS_CP!U$2","v":{"$error":"#N/A"}},{"$f":"THIS_CP!V$2","v":{"$error":"#N/A"}},null,null,"Electrical Engineer",{"$f":"IF(THIS_CP!K2=FALSE,\" \",THIS_CP!K2)","v":{"$error":"#N/A"}}]
[null,null,"Total Assigned Budget",{"$f":"THIS_CP!R$2","v":{"$error":"#N/A"}},null,null,"Estimate",{"$f":"THIS_CP!W$2","v":{"$error":"#N/A"}},{"$f":"THIS_CP!X$2","v":{"$error":"#N/A"}},{"$f":"THIS_CP!Y$2","v":{"$error":"#N/A"}},null,null,"Construction Rep",{"$f":"IF(THIS_CP!L2=FALSE,\" \",THIS_CP!L2)","v":{"$error":"#N/A"}}]
[null,null,"Total Expended to Date",{"$f":"THIS_CP!S$2","v":{"$error":"#N/A"}},null,null,"Design",{"$f":"THIS_CP!Z$2","v":{"$error":"#N/A"}},{"$f":"THIS_CP!AA$2","v":{"$error":"#N/A"}},{"$f":"THIS_CP!AB$2","v":{"$error":"#N/A"}},null,null,"Project Administrator",{"$f":"IF(THIS_CP!M2=FALSE,\" \",THIS_CP!M2)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Bidding",{"$f":"THIS_CP!AC$2","v":{"$error":"#N/A"}},{"$f":"THIS_CP!AD$2","v":{"$error":"#N/A"}},{"$f":"THIS_CP!AE$2","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Construction",{"$f":"THIS_CP!AF$2","v":{"$error":"#N/A"}},{"$f":"THIS_CP!AG$2","v":{"$error":"#N/A"}},{"$f":"THIS_CP!AH$2","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Occupancy",{"$f":"THIS_CP!AI$2","v":{"$error":"#N/A"}},{"$f":"THIS_CP!AJ$2","v":{"$error":"#N/A"}},{"$f":"THIS_CP!AK$2","v":{"$error":"#N/A"}},null,null,"Vendors and Delivery Method"]
[null,null,"Project Management",null,null,null,"Closed",{"$f":"THIS_CP!AL$2","v":{"$error":"#N/A"}},{"$f":"THIS_CP!AM$2","v":{"$error":"#N/A"}},{"$f":"THIS_CP!AN$2","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Consultant",{"$f":"IF(THIS_CP!N2=FALSE,\" \",THIS_CP!N2)","v":{"$error":"#N/A"}}]
[null,null,"Communication Plan"]
[null,null,"Schedule Worksheet",null,null,null,"Bidding Phase"]
[null,null,"Budget Cost Summary",null,null,null,null,null,null,null,null,null,"Constructor",{"$f":"IF(THIS_CP!O2=FALSE,\" \",THIS_CP!O2)","v":{"$error":"#N/A"}}]
[null,null,"Project Information Form (A3)",null,null,null,null,null,null,null,null,null,"Delivery Method",{"$f":"IF(THIS_CP!P2=FALSE,\" \",THIS_CP!P2)","v":{"$error":"#N/A"}}]
[null,null,"Standards Deviation Log"]
[null,null,"Team Contact List"]
[null,null,null,null,null,null,"Construction Phase",null,null,null,null,null,"Resources"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Capital Project Delivery Procedures"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Unifier Project Management Help"]
[null,null,"Planning Phase",null,null,null,null,null,null,null,null,null,"Unifier login"]
[null,null,null,null,null,null,null,null,null,null,null,null,"FAMIS login"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Meridian explorer"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Facilities Information Tool (FIT)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MSU Standards for Construction"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MSU Find People page"]
[null,null,"Design Phase",null,null,null,"Close-out Phase",null,null,null,null,null,"Capital Project Delivery Processes"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Planning","Bidding"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Schematic Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Design Development"]
[null,null,null,null,null,null,"Final Payment Submittals / Closeout Checklist",null,null,null,null,null,"Construction Docs"]

{"sheet":"CHECKLISTS ---->","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Project Checklists"]

{"sheet":"Planning Task List","index":2,"n_rows":97,"n_cols":7,"rows_kept":97,"cut":false,"hidden":false,"merged":[[2,5,2,6],[3,5,3,6],[84,0,96,0],[5,0,9,0],[13,0,40,0],[42,0,57,0],[71,0,82,0],[59,0,69,0]]}
[]
[{"$f":"\"Project Number: \" &proj_id","v":"Project Number: "}]
[{"$f":"\"Project Name: \" &proj_nm","v":{"$error":"#N/A"}},null,null,null,null,"Planning - Detailed Task List"]
[null,null,null,null,null,"Planning Process Flowchart"]
["Milestone","Item","Description","Status","Assignee","Due Date or Completion Date","Notes and Resources"]
["Verify initial project information","P1","Account number identified in FAMIS Accounts tab"]
[null,"P2","Funding source for project account number"]
[null,"P3","Proof of project approval"]
[null,"P4","EST COST in FAMIS Details tab equals funding amount"]
[null,"P5","Assignments of internal team members"]
[]
["Accept Project","P6","Receive design status memo from PDC Business Office"]
[]
["Collect project information","P7","Review scope on Service Request and/or correspondence"]
[null,"P8","Review scope on Preliminary Cost Assessment with Estimator",null,null,null,"Preliminary Cost Assessment"]
[null,"P9","Start a list of out-of-scope items"]
[null,"P10","Review initial schedule considerations"]
[null,"P11","Review preliminary study or condition assessment"]
[null,"P12","See Client Representative for background information"]
[null,"P13","Call Customer to briefly discuss scope, schedule and budget"]
[null,"P14","Verify project title in FAMIS/Unifier describes scope; if revision needed, notify PDC Business Office and Unifier Support",null,null,null,"pdc_contracts_requests@ipf.msu.edu"]
[null,"P15","Verify accuracy of new building/addition name with FIS",null,null,null,"Facility Information Systems (FIS)"]
[null,"P16","Identify internal team members (ID, LA, CE, ME, EE, PR, etc)"]
[null,"P17","Informal meeting with internal team, assign tasks"]
[null,"P18","Prepare agenda"]
[null,"P19","Issue meeting minutes"]
[null,"P20","Review potential adjacencies, opportunities, conflicts:"]
[null,"P21","Projects in estimating, study, design or construction phase",null,null,null,"Facilities Information Tool"]
[null,"P22","Existing condition drawings in Meridian archives"]
[null,"P23","Capital Renewal (JIT) maintenance projects",null,null,null,"Capital Renewal List"]
[null,"P24","Retro-CX and Owners Performance Requirements (OPR)"]
[null,"P25","Hazardous material survey from EHS",null,null,null,"Environmental Health and Safety (EHS)"]
[null,"P26","Maintenance services for related project requests"]
[null,"P27","Customer (RHS, Athletics, FPSM) master plan"]
[null,"P28","MSU Campus Master Plan",null,null,null,"Campus Master Plan"]
[null,"P29","See Planning Partners to assist in identifying potential scope",null,null,null,"Project Planning Partners (process)"]
[null,"P30","Determine if new addressing or road naming will be needed",null,null,null,"Campus Addressing and Road Naming"]
[null,"P31","Draft preliminary owner schedule",null,null,null,"Schedule Worksheet for Major Projects"]
[null,"P32","Consider long-lead delivery, time allowance for off-gassing of materials, coordination with classroom events, etc."]
[null,"P33","Draft Capital Project Information Form (A3)",null,null,null,"Project A3"]
[null,"P34","Draft project communication plan",null,null,null,"Capital Project Communication Guidelines"]
[]
["Contact Customer","P35","Call Customer to schedule on-site meeting"]
[null,"P36","On-site Customer meeting, with key internal team members"]
[null,"P37","Share Customer Guide to Capital Projects with Customer",null,null,null,"Customer guide to Capital Projects"]
[null,"P38","Schedule on-site meeting with agenda:"]
[null,"P39","Review summary of work scope (reference PCA if available)"]
[null,"P40","Discuss out-of-scope items with customer"]
[null,"P41","Discuss project budget"]
[null,"P42","Verify funding source and account number with customer"]
[null,"P43","Discuss project schedule"]
[null,"P44","Explain BOT project approval process and timeline"]
[null,"P45","Discuss logistic risks"]
[null,"P46","Discuss unique project attributes or elements"]
[null,"P47","Discuss potential need for Condition Assessment",null,null,null,"Condition Assessment"]
[null,"P48","Obtain or draft Program Statement"]
[null,"P49","Discuss and understand project goals /KPIs"]
[null,"P50","Issue meeting minutes"]
[]
["Internal team meeting","P51","Identify internal team members; confirm assignments"]
[null,"P52","Discuss roles and expectations internal team members"]
[null,"P53","Task internal team members with contacting specific planning partners (ex: Electrical Engineer to communicate with fire alarm partner)"]
[null,"P54","Schedule internal team meeting with agenda:"]
[null,"P55","Review project information"]
[null,"P56","Review project work scope"]
[null,"P57","Discuss project schedule",null,null,null,"Schedule Worksheet for Major Projects (template)"]
[null,"P58","Review project budget"]
[null,"P59","Issue meeting minutes"]
[null,"P60","Edit project communication plan"]
[null,"P61","Enter planned design end date in FAMIS"]
[]
["Campus Infrastructure Planning Workgroup (CIPWG) - required prior to Board of Trustee Approval to Plan (Step 1)","P62","Identify preliminary project schedule"]
[null,"P63","Enter BOT Step 1 date in FAMIS",null,null,null,"FAMIS Capital Project Data"]
[null,"P64","Identify project budget (TBD or range)"]
[null,"P65","Enter current estimate, low estimated cost, and high estimated cost in FAMIS; identify range of costs for CIPWG 1 or indicate \"TBD\""]
[null,"P66","Identify project scope"]
[null,"P67","Update Capital Project Information Form (A3)",null,null,null,"Project A3"]
[null,"P68","Create CIPWG 1 slide presentation",null,null,null,"CIPWG1 Presentation (template)"]
[null,"P69","Obtain Customer approval of slide presentation and A3"]
[null,"P70","Determine presenter (Project Manager and/or Customer)"]
[null,"P71","Create CIPWG 1 in Unifier; attach A3 and slide presentation",null,null,null,"CIPWG1 (instructions)"]
[null,"P72","Present project at CIPWG meeting"]
[null,"P73","Address comments from CIPWG committee members"]
[]
["Board of Trustee Approval to Plan (Step 1)","P74","Confirm preliminary project schedule"]
[null,"P75","Validate BOT Step 1 date in FAMIS"]
[null,"P76","Confirm project budget (TBD or range)"]
[null,"P77","Validate current estimate, low estimated cost, and high estimated cost in FAMIS; identify range of costs for BOT Step 1 or indicate \"TBD\""]
[null,"P78","Confirm project scope"]
[null,"P79","Update Capital Project Information Form (A3)",null,null,null,"Project A3"]
[null,"P80","Create BOT Step 1 slide presentation",null,null,null,"BOT Step 1 Presentation (template)"]
[null,"P81","Obtain Customer approval of slide presentation"]
[null,"P82","Create BOT Step 1 in Unifier; attach slide presentation",null,null,null,"BOT Step 1 (instructions)"]
[null,"P83","E-mail slide presentation to Jannene Andrews"]
[null,"P84","Review Resolution Letter prepared by Contract Administrator"]
[null,"P85","Enter Project Update note in Unifier Project Information form",null,null,null,"Project Information (instructions)"]
[null,"P86","Contact the planning partners that may have involvement based on the work scope, using the Project Planning Partners List, the Project Team Establishment e-mail template, and the appropriate Contact Groups in the PDC Project Planning Partners address bok in Outlook",null,null,null,"Project Planning Partners List"]

{"sheet":"Schematic Design Task List","index":3,"n_rows":188,"n_cols":11,"rows_kept":188,"cut":false,"hidden":false,"merged":[[14,0,25,0],[54,0,63,0],[65,0,75,0],[2,5,2,6],[3,5,3,6],[5,0,12,0],[41,0,52,0],[178,0,187,0],[146,0,148,0],[150,0,154,0],[156,0,163,0],[165,0,171,0],[173,0,176,0],[77,0,88,0],[129,0,144,0],[108,0,127,0],[90,0,100,0],[27,0,39,0],[102,0,106,0]]}
[]
[{"$f":"\"Project Number: \" &proj_id","v":"Project Number: "}]
[{"$f":"\"Project Name: \" &proj_nm","v":{"$error":"#N/A"}},null,null,null,null,"Schematic Design - Detailed Task List"]
[null,null,null,null,null,"SD Process Flowchart"]
["Milestone","Item","Description","Status","Assignee","Due Date or Completion Date","Notes"]
["Procurement Strategy - Consultant / Construction Manager","SD1","Determine source of design services - in-house or Consultant",null,null,null,null,null,null,null,"Status Drop-down"]
[null,"SD2","Determine project delivery method",null,null,null,null,null,null,null,"Status Drop-down"]
[null,"SD3","Options: General Contractor or Design Bid & Build (GC), Construction Manager(CM), Internal Construction Manager (ICM), Integrated Project Delivery (IPD), IPF Self-performed (IPF) or To Be Determined (TBD)"]
[null,"SD4","If GC, determine if Base Contractors only",null,null,null,"Base Contractors"]
[null,"SD5","Involve Project Representative and Customer in decision"]
[null,"SD6","Review with Project Delivery Supervisors, Contract Administrator and PDC Director"]
[null,"SD7","Select short list of consultants to interview"]
[null,"SD8","Consider procuring Consultant and CM as a team",null,null,null,null,null,null,null,"Not Started"]
[]
["Programming","SD9","Identify programming team"]
[null,"SD10","Identify business needs"]
[null,"SD11","Identify space requirements"]
[null,"SD12","Site Selection"]
[null,"SD13","Program development"]
[null,"SD14","Confirm project scope"]
[null,"SD15","Final program confirmation"]
[null,"SD16","Project schedule development"]
[null,"SD17","Owners Project Requirements (OPR) - unique to MSU"]
[null,"SD18","Define project goal"]
[null,"SD19","Involve Planning Partners - unique to MSU",null,null,null,"Project Planning Partners List"]
[null,"SD20","Output: Building Program"]
[]
["Consultant Selection (N/A if design in-house)","SD21","Request proposal from selected consultant (PO, Minor)",null,null,null,"AE Proposal (template)"]
[null,"SD22","For Major project:",null,null,null,"Selection Procedure for Professional Service Consultants"]
[null,"SD23","Issue Advertisement and Questionnaire for AE Services",null,null,null,"Advertisement and Questionnaire for AE Services (template)"]
[null,"SD24","Establish ad hoc evaluation committee"]
[null,"SD25","Review AE responses"]
[null,"SD26","Select short list of consultants to interview"]
[null,"SD27","Issue AE Request for Presentation Letters to short-list firms",null,null,null,"AE Request for Presentation (template)"]
[null,"SD28","Consultant presentations"]
[null,"SD29","Meet with selection committee to select consultant"]
[null,"SD30","Review consultant selection with Contract Administrator"]
[null,"SD31","Recommend selected A/E firm to PDC Director"]
[null,"SD32","Review AE proposal from selected consultant"]
[null,"SD33","Issue AE Rejection Letters to interviewed firms not selected",null,null,null,"AE Rejection (template)"]
[]
["Contract Process for Professional Services (N/A if design in-house)","SD34","Prepare Contract Information for CPA"]
[null,"SD35","Prepare Vendor Choice Justification Letter"]
[null,"SD36","Obtain the following documents from the Consultant"]
[null,"SD37","Unifier System - Vendor Information",null,null,null,"Vendor Information (template)"]
[null,"SD38","AE Proposal (lump sum or hourly basis)",null,null,null,"AE Proposal (template)"]
[null,"SD39","Create Contract Request record in Unifier, with attachments",null,null,null,"Contract Request (instructions)"]
[null,"SD40","Track progress of Contracting record in Unifier"]
[null,"SD41","Review SOV details in PO-Construction Contract in Unifier"]
[null,"SD42","Issue Letter of Intent, if applicable",null,null,null,"Letter of Intent (template)"]
[null,"SD43","Issue keys to Consultant, using Key Signout to Contractor form",null,null,null,"Key Signout to Contractor (form)"]
[null,"SD44","Track consultant contract deliverables"]
[null,"SD45","Review and process payment applications from Consultant"]
[]
["Construction Manager Selection (N/A if construction by General Contractor)","SD46","Issue Advertisement and Questionnaire for CM Services",null,null,null,"Advertisement and Questionnaire for CM Services (template)"]
[null,"SD47","Establish ad hoc evaluation committee"]
[null,"SD48","Review CM responses"]
[null,"SD49","Select short list of construction managers to interview"]
[null,"SD50","Issue CM Request for Presentation Letters to short-list firms"]
[null,"SD51","Construction Manager presentations"]
[null,"SD52","Meet with selection committee to select CM"]
[null,"SD53","Review CM selection with Contract Administrator"]
[null,"SD54","Recommend selected CM firm to PDC Director"]
[null,"SD55","Request proposal from selected CM"]
[]
["Contract Process for Construction Manager (N/A if construction by General Contractor)","SD56","Prepare Vendor Choice Justification Letter"]
[null,"SD57","Obtain the following documents from the CM"]
[null,"SD58","CM Proposal"]
[null,"SD59","Unifier System - Vendor Information",null,null,null,"Vendor Information (template)"]
[null,"SD60","Create Contract Request record in Unifier, with attachments",null,null,null,"Contract Request (instructions)"]
[null,"SD61","Track progress of Contracting record in Unifier",null,null,null,"Contracting (process)"]
[null,"SD62","Review SOV details in PO-Construction Contract in Unifier"]
[null,"SD63","Issue Letter of Intent, if applicable",null,null,null,"Letter of Intent (template)"]
[null,"SD64","Issue keys to CM, using Key Signout to Contractor form",null,null,null,"Key Signout to Contractor (form)"]
[null,"SD65","Track CM contract deliverables"]
[null,"SD66","Review payment applications from CM"]
[]
["Preliminary meeting with Consultant (N/A if design in-house)","SD67","Request CD from FIS containing as-built drawings of the project"]
[null,"SD68","Schedule preliminary meeting with Consultant"]
[null,"SD69","Prepare agenda"]
[null,"SD70","Include Construction Manager if applicable"]
[null,"SD71","At meeting, provide project scope, budget and schedule"]
[null,"SD72","Confirm project schedule / project plan"]
[null,"SD73","Explain Facility Asset Data Exchange (FADE) process"]
[null,"SD74","Identify role and responsibilities of consultant team members"]
[null,"SD75","Identify role and responsibilities of CM team members"]
[null,"SD76","Clarify expectations"]
[null,"SD77","Issue meeting minutes"]
[null,"SD78","Provide CD with as-built drawings to the Consultant"]
[]
["Design Kick-off Meeting with Customer","SD79","Schedule design kick-off meeting with Customer"]
[null,"SD80","Include stakeholders (incl those identified by Customer)"]
[null,"SD81","Include Consultant"]
[null,"SD82","Include Construction Manager"]
[null,"SD83","Include internal team members"]
[null,"SD84","Example: Include PDC Mechanical Engineer"]
[null,"SD85","Identify design to be performed in-house (example: LA, ID)"]
[null,"SD86","Schedule Design Kick-Off meeting with agenda",null,null,null,"Design Kick-Off Meeting Agenda (template)"]
[null,"SD87","Update communication plan"]
[null,"SD88","Update Capital Project Information Form (A3)",null,null,null,"Project A3"]
[null,"SD89","Publish minutes from design kick-off meeting, attach A3",null,null,null,"Design Kick-Off Meeting Minutes (template)"]
[]
["Contract Process for minor vendor (ex: site survey, soil borings)","SD90","Prepare Vendor Choice Justification Letter, if cost >= $10,000"]
[null,"SD91","Obtain the following documents from the vendor:"]
[null,"SD92","Vendor Proposal (lump sum or hourly basis)"]
[null,"SD93","Unifier System - Vendor Information",null,null,null,"Vendor Information (template)"]
[null,"SD94","Create Contract Request record in Unifier, with attachments",null,null,null,"Contract Request (instructions)"]
[]
["Schematic Design - Communications and Management","SD95","Manage communications between all team members"]
[null,"SD96","For projects designed in-house, coordinate with  internal team members on all deliverables"]
[null,"SD97","Engage internal team members (SMEs) as needed at meetings"]
[null,"SD98","Arrange for site survey",null,null,null,"Surveys (Site and As-Built)"]
[null,"SD99","Schedule recurring design progress meetings with internal team"]
[null,"SD100","Engage Customer as needed"]
[null,"SD101","Coordinate special requirements for internal team members"]
[null,"SD102","Preliminary airflow measurements by Cx (to ME)"]
[null,"SD103","Engage project planning parters as needed for meetings",null,null,null,"Project Planning Partners List"]
[null,"SD104","Invite Quality Assurance Skilled Trades Representatives to SD progress meetings to review specific work scope",null,null,null,"Quality Assurance Skilled Trades (reference)"]
[null,"SD105","Discuss project with IT Services",null,null,null,"Information Technology Services (reference)"]
[null,"SD106","For projects involving removed or new assets (materials and equipment), contact IPF Preventive Maintenance Manager for equipment ID numbers",null,null,null,"Design Phase - Equipment ID"]
[null,"SD107","For department-owned equipment, discuss required ongoing maintenance requirements with customer and review optional equipment"]
[null,"SD108","Engage Client Representative as needed"]
[null,"SD109","Verify accuracy of FAMIS data. Send e-mail to pdc_contracts_requests@ipf.msu.edu regarding any change to information in the General, Accounts, Budget, Work Orders and PO tabs, or to change the Project Type in the Details tab"]
[null,"SD110","Monitor progress of schematic design"]
[null,"SD111","Revise Project Update note in Unifier Project Information (major)",null,null,null,"Project Information (instructions)"]
[null,"SD112","Confirm project goal is being met"]
[null,"SD113","Risk analysis and decision making"]
[null,"SD114","Forecasting"]
[]
["Schematic Design - Project Scope","SD115","Coordinate procurement of minor vendors providing design services (ex: site survey, commissioning agent)",null,null,null,"Survey Bid Tabulation & Proposals (Site Survey & As-Builts)"]
[null,"SD116","Coordinate FFE procurement plan"]
[null,"SD117","Manage project work scope"]
[null,"SD118","Update list of out-of-scope items"]
[null,"SD119","Request periodic schematic design documents from consultant"]
[null,"SD120","Validate compliance with program statement and OPR"]
[null,"SD121","Identify energy conservation measures using energy modeling; involve Mechanical Engineer, Energy Educators, and IPF Building Performance Services in discussions"]
[null,"SD122","Discuss  equipment requiring maintenance with customer"]
[null,"SD123","Obtain Design Intent document from consultant"]
[null,"SD124","Review code compliance issues"]
[null,"SD125","Determine if new addressing or road naming will be needed",null,null,null,"Campus Addressing and Road Naming (process)"]
[null,"SD126","If new entity addressing is needed, review with IPF FIS/GIS"]
[null,"SD127","If project includes new road, contact MSU Facility Design Team and review with EVP, Legal Counsel and FPSM"]
[null,"SD128","For new addressing or road naming, submit proposed addressing and/or road naming to the Addressing Committee"]
[null,"SD129","For new addressing or road naming, review approved addressing and road naming with CIPWG committee (at Step 2 at the latest)"]
[null,"SD130","Obtain SD Standards Deviation Log from consultant",null,null,null,"Project Standards Deviation Log"]
[]
["Schematic Design - Project Schedule","SD131","Manage project schedule",null,null,null,"Schedule Worksheet for Major Projects"]
[null,"SD132","Request owner schedule from Consultant or CM"]
[null,"SD133","Evaluate affect of design scope changes on the schedule"]
[]
["Schematic Design - Project Budget","SD134","Manage project budget",null,null,null,"Budget Cost Summary (template)"]
[null,"SD135","Evaluate affect of desigin scope changes on the budget"]
[null,"SD136","Identify potential value-engineering items"]
[null,"SD137","Request cost estimate from Consultant or CM"]
[null,"SD138","Review current project budget with Customer"]
[]
["Schematic Design - Interim CIPWG and Construction Junction","SD139","Interim CIPWG presentation 3 months before BOT Step 2"]
[null,"SD140","Create slide presentation for interim CIPWG. Note: Use the BOT Title for the graphics. BOT Title can be found in the Description field on the General Tab in FAMIS.",null,null,null,"Major Project - BOT Title Instructions"]
[null,"SD141","Review slide presentation with Customer"]
[null,"SD142","E-mail slide presentation to Jannen Andrews"]
[null,"SD143","Present project at interim CIPWG meeting"]
[null,"SD144","Address interim CIPWG committee review comments"]
[null,"SD145","Construction Junction 2 months before BOT Step 2"]
[null,"SD146","Provide project materials to IPF Communications"]
[]
["Schematic Design - CIPWG 2","SD147","Schedule CIPWG 2 presentation 2 months before BOT Step 2"]
[null,"SD148","Create slide presentation for CIPWG 2. Note: Use the BOT Title for the graphics. BOT Title can be found in the Description field on the General Tab in FAMIS.",null,null,null,"CIPWG2 Presentation (template)"]
[null,"SD149","Review slide presentation with Customer"]
[null,"SD150","For new addressing or road naming, review approved addressing and road naming with CIPWG committee (at Step 2 at the latest)"]
[null,"SD151","Create CIPWG 2 record in Unifier, attach slides and A3"]
[null,"SD152","Present project at CIPWG 2 meeting"]
[null,"SD153","Address CIPWG 2 committee review comments"]
[]
["Schematic Design - BOT Step 2","SD154","Create slide presentation for BOT Step 2 - Authorization to Proceed. Note: Use the BOT Title for the graphics. BOT Title can be found in the Description field on the General Tab in FAMIS.",null,null,null,"BOT Step 2 Presentation (template)"]
[null,"SD155","For new addressing or road naming, include information in BOT Step 2 resolution"]
[null,"SD156","Review slide presentation with Customer"]
[null,"SD157","Create BOT Step 2 in Unifier, attach slides and Budget Cost Summary",null,null,null,"BOT Step 2 (instructions)"]
[]
["Schematic Design - Plan Review","SD158","Verify titleblock on all sheets of review set complies with MSU standards and has accurate FAMIS project name and number; also check cover sheet",null,null,null,"Instructions for Formatting Project Drawings"]
[null,"SD159","Forward FADE spreadsheet to Building Performance for asset identification numbers and space numbering"]
[null,"SD160","Issue schematic design documents for review by Customer, internal team members and planning partners; using Unifier transmittal process"]
[null,"SD161","Issue schematic design documents for review by Quality Assurance Skilled Trades Representatives, using Transmittal form; allow 2 week review period"]
[null,"SD162","Ensure review comments addressed in SD documents"]
[null,"SD163","Respond to all plan review comments in Unifier",null,null,null,"Plan Review (process)"]
[null,"SD164","Direct Consultant to incorporate asset identification numbers and space numbering from FADE spreadsheet into project documents"]
[null,"SD165","Schedule end-of-schematic meeting with Customer to review scope, schedule and budget before moving into Design Development (DD) phase",null,null,null,"Bid Document Approval by Customer (form)"]
[null,"SD166","Prepare agenda"]
[null,"SD167","Issue meeting minutes"]

{"sheet":"Design Development Task List","index":4,"n_rows":94,"n_cols":7,"rows_kept":94,"cut":false,"hidden":false,"merged":[[2,5,2,6],[3,5,3,6],[75,0,80,0],[82,0,93,0],[47,0,68,0],[5,0,12,0],[14,0,45,0],[70,0,73,0]]}
[]
[{"$f":"\"Project Number: \" &proj_id","v":"Project Number: "}]
[{"$f":"\"Project Name: \" &proj_nm","v":{"$error":"#N/A"}},null,null,null,null,"Design Development - Detailed Task List"]
[null,null,null,null,null,"DD Process Flowchart"]
["Milestone","Item","Description","Status","Assignee","Due Date or Completion Date","Notes"]
["Design Development Progress Meeting with Customer","DD1","Schedule design development progress meeting with Customer"]
[null,"DD2","Include Consultant"]
[null,"DD3","Include Construction Manager"]
[null,"DD4","Include internal team members (ex: if heavy mechanical)"]
[null,"DD5","Prepare Design Development Meeting Agenda"]
[null,"DD6","Update communication plan"]
[null,"DD7","Update Capital Project Information Form (A3)",null,null,null,"Project A3"]
[null,"DD8","Publish minutes from design progress meeting, attach A3"]
[]
["Design Development - Communications and Management","DD9","Manage communications between all team members"]
[null,"DD10","For projects designed in-house (no consultant), coordinate with  internal team members on all deliverables"]
[null,"DD11","Schedule design progress meetings"]
[null,"DD12","Prepare agenda"]
[null,"DD13","Issue meeting minutes"]
[null,"DD14","Engage Customer as needed"]
[null,"DD15","Engage internal team members as needed"]
[null,"DD16","Review construction impact with Project Representative"]
[null,"DD17","Invite Quality Assurance Skilled Trades Representatives to DD progress meetings to review specific work scope",null,null,null,"Quality Assurance Skilled Trades (reference)"]
[null,"DD18","Engage project planning parters as needed for meetings",null,null,null,"Project Planning Partners List"]
[null,"DD19","IPF Building Performance Services"]
[null,"DD20","Commissioning Agent"]
[null,"DD21","Campus Sanitarian, food service facilities or equipment",null,null,null,"Food Service Establishment Design and Construction"]
[null,"DD22","Classroom Planning Group via Dan Klann, instructional space",null,null,null,"Instructional Space Guidelines"]
[null,"DD23","MSU Fire Marshal, life or fire safety issues"]
[null,"DD24","State Fire Marshal, life or fire safety issues. Coordinate communication via MSU Fire Marshal"]
[null,"DD25","East Lansing Fire Department, fire safety"]
[null,"DD26","Pool mechanics, projects involving pools"]
[null,"DD27","IPF Telecomm, projects involving Telecommunications, coordinate location of target Communication Room (show construction plans)"]
[null,"DD28","Custodial Department Manager, custodial-related issues"]
[null,"DD29","Coordinate State News distribution boxes with Marty Sturgeon (ph. 432-3000, mjs@msu.edu)"]
[null,"DD30","Maranda Holtsclaw, new assets requiring preventive maintenance"]
[null,"DD31","Brick Committee, new brick work"]
[null,"DD32","Engage Client Representative as needed"]
[null,"DD33","Coordinate Art on Campus design with Art on Campus committee"]
[null,"DD34","Verify accuracy of FAMIS data. Send e-mail to pdc_contracts_requests@ipf.msu.edu regarding any change to information in the General, Accounts, Budget, Work Orders and PO tabs, or to change the Project Type in the Details tab"]
[null,"DD35","Monitor progress of design development"]
[null,"DD36","Confirm project goal is being met"]
[null,"DD37","Revise Project Update note in Unifier Project Information (major)",null,null,null,"Project Information (instructions)"]
[null,"DD38","Continuous value engineering"]
[null,"DD39","Risk analysis and decision making"]
[null,"DD40","Forecasting"]
[]
["Design Development - Project Scope","DD41","Manage project work scope"]
[null,"DD42","Identify work by owner, obtain commitments"]
[null,"DD43","       Update list of out-of-scope items"]
[null,"DD44","Coordinate room numbering with IPF FIS"]
[null,"DD45","Effect of project design and construction on adjacent spaces"]
[null,"DD46","Verify fire rating of walls, doors, ceilings and other architectural and structural barriers. Existing and new conditions must comply with current life safety codes"]
[null,"DD47","Re-assess energy conservation measures using energy modeling; involve Mechanical Engineer, Energy Educators, and IPF Building Performance Services in discussions"]
[null,"DD48","Evaluate status of project's energy consumption analysis, code comliance, and efficiency goals"]
[null,"DD49","Evaluate the building's energy consumption; review requirements from the customer for hours of operation of all HVAC systems; limit extending run hours of existing equipment for only a portion of the space served"]
[null,"DD50","Schedule Sustainability Work Session for Project Team to work on specific strategies for meeting sustainability goals"]
[null,"DD51","Review progress on salvage, reuse, and recylcling options; as well as options for materials with recycled content"]
[null,"DD52","Identify occupant relocation requirements"]
[null,"DD53","Review current site survey or arrange for new site survey",null,null,null,"Surveys (Site and As-Built)"]
[null,"DD54","Campus Master Plan, review design with Steve Troost, discuss easement requirements",null,null,null,"Campus Master Plan"]
[null,"DD55","Fill out or obtain LEED Checklist from Consultant; determine level of LEED certification for project",null,null,null,"LEED Checklist"]
[null,"DD56","Re-confirm Program Statement with Customer"]
[null,"DD57","Validate project scope complies with Program Statement  "]
[null,"DD58","Validate project scope complies with OPR"]
[null,"DD59","Request 50% complete design documents from consultant"]
[null,"DD60","Obtain updated Design Intent document from consultant"]
[null,"DD61","Review code compliance issues"]
[null,"DD62","Request Standard Deviations Log from consultant",null,null,null,"Project Standards Deviation Log"]
[]
["Design Development - Project Schedule","DD63","Manage project schedule",null,null,null,"Schedule Worksheet for Major Projects"]
[null,"DD64","Identify potential restrictions on construction schedule; ex: classrooms or conference roms in the work area that may be affected by construction noise"]
[null,"DD65","Request updated schedule from Consultant or CM"]
[null,"DD66","Evaluate affect of design scope changes on the schedule"]
[]
["Design Development - Project Budget","DD67","Manage project budget",null,null,null,"Budget Cost Summary"]
[null,"DD68","Evaluate affect of design scope changes on the budget"]
[null,"DD69","Request cost estimate from Consultant or CM"]
[null,"DD70","Update list of potential value-engineering items"]
[null,"DD71","Identify potential add/or deduct alternate items"]
[null,"DD72","Review current project budget with Customer"]
[]
["Design Development - Plan Review","DD73","Verify titleblock on all sheets of review set complies with MSU standards and has accurate FAMIS project name and number; also check cover sheet",null,null,null,"Instructions for Formatting Project Drawings"]
[null,"DD74","Forward FADE spreadsheet to Building Performance to review current asset identification numbers and space numbering"]
[null,"DD75","Verify specifications comply with MSU standards and has accurate FAMIS project name and number",null,null,null,"Instructions for Formatting Project Specifications"]
[null,"DD76","Present project at Tuesday project meeting with IPF Maintenance Services for review and potential acceptance as a self-performed project"]
[null,"DD77","For a self-performed project, use the Construction Document Checklist to ensure drawings contain sufficient level of detail",null,null,null,"Self-Performed Capital Projects - Construction Document Checklist"]
[null,"DD78","Issue design development documents for review by Customer, internal team members and planning partners; using Unifier transmittal process"]
[null,"DD79","Issue design development documents for review by Quality Assurance Skilled Trades Representatives, using Transmittal form",null,null,null,"Quality Assurance Skilled Trades Rep Review Transmittal"]
[null,"DD80","Manage modifications to design development documents based on all review comments"]
[null,"DD81","Direct Consultant to update asset identification numbers and space numbering from FADE spreadsheet into project documents as needed"]
[null,"DD82","Schedule end-of-design development meeting with Customer to review scope, schedule and budget before moving into Construction Documents (CD) phase",null,null,null,"Design Development Approval by Customer"]
[null,"DD83","Prepare agenda"]
[null,"DD84","Issue meeting minutes"]

{"sheet":"Construction Document Task List","index":5,"n_rows":89,"n_cols":7,"rows_kept":89,"cut":false,"hidden":false,"merged":[[2,5,2,6],[3,5,3,6],[74,0,88,0],[5,0,12,0],[14,0,42,0],[44,0,61,0],[63,0,65,0],[67,0,72,0]]}
[]
[{"$f":"\"Project Number: \" &proj_id","v":"Project Number: "}]
[{"$f":"\"Project Name: \" &proj_nm","v":{"$error":"#N/A"}},null,null,null,null,"Construction Documents - Detailed Task List"]
[null,null,null,null,null,"CD Process Flowchart"]
["Milestone","Item","Description","Status","Assignee","Due Date or Completion Date","Notes"]
["Construction Documents Progress Meeting with Customer","CD1","Schedule construction documents progress meeting with Customer"]
[null,"CD2","Include Consultant"]
[null,"CD3","Include Construction Manager"]
[null,"CD4","Include internal team members (ex: if heavy mechanical)"]
[null,"CD5","Prepare Construction Documents Meeting Agenda"]
[null,"CD6","Update communication plan"]
[null,"CD7","Update Capital Project Information Form (A3)",null,null,null,"Project A3"]
[null,"CD8","Publish minutes from design progress meeting, attach A3"]
[]
["Construction Documents - Communications and Management","CD9","Manage communications between all team members"]
[null,"CD10","For projects designed in-house (no consultant), coordinate with  internal team members on all deliverables"]
[null,"CD11","Schedule design progress meetings"]
[null,"CD12","Engage Customer as needed"]
[null,"CD13","Engage internal team members as needed for meetings"]
[null,"CD14","Review construction impact with Project Representative"]
[null,"CD15","Invite Quality Assurance Skilled Trades Representatives to  CD progress meetings to review specific work scope",null,null,null,"Quality Assurance Skilled Trades (reference)"]
[null,"CD16","For projects including pedestrian, bicyclist and/or motorist closures and detours, provide information to FIS as soon as it is known, for the Construction Detours Map. Keep FIS informed of any changes during the design or construction phase"]
[null,"CD17","Engage project planning parters as needed for meetings",null,null,null,"Project Planning Partners List"]
[null,"CD18","IPF Building Performance Services"]
[null,"CD19","Commissioning Agent, review construction documents"]
[null,"CD20","Stephanie O'Donnell at DPPS, parking, staging, road closures, traffic issues"]
[null,"CD21","Campus Sanitarian and Ingham County Department of Health (Food Service), food service facilities or equipment",null,null,null,"Food Service Establishment Design and Construction"]
[null,"CD22","MSU Fire Marshal"]
[null,"CD23","State Fire Marshal"]
[null,"CD24","East Lansing Fire Department"]
[null,"CD25","FM Global - university insurance company"]
[null,"CD26","Ingham County Department of Health, pool projects"]
[null,"CD27","Pool mechanics"]
[null,"CD28","Engage Client Representative as needed"]
[null,"CD29","Verify accuracy of FAMIS data. Send e-mail to pdc_contracts_requests@ipf.msu.edu regarding any change to information in the General, Accounts, Budget, Work Orders and PO tabs, or to change the Project Type in the Details tab"]
[null,"CD30","Monitor progress of construction documents"]
[null,"CD31","Confirm project goal is being met"]
[null,"CD32","Discuss  equipment requiring maintenance with customer"]
[null,"CD33","Review code compliance issues"]
[null,"CD34","Revise Project Update note in Unifier Project Information (major)",null,null,null,"Project Information (instructions)"]
[null,"CD35","Continuous value engineering"]
[null,"CD36","Risk analysis and decision making"]
[null,"CD37","Forecasting"]
[]
["Construction Documents - Project Scope","CD38","Manage project work scope"]
[null,"CD39","Finalize list of out-of-scope items"]
[null,"CD40","Finalize energy conservation measures using energy modeling; involve Mechanical Engineer, Energy Educators, and IPF Building Performance Services in discussions; obtain Energy Impact Statement from Consultant"]
[null,"CD41","Obtain Code Summary from Consultant"]
[null,"CD42","Identify materials to be delivered to MSU Surplus & Recycling",null,null,null,"Surplus and Recycling"]
[null,"CD43","Coordinate moving and set-up requirements with IPF Custodial Services, after discussion with Customer regarding occupant relocation"]
[null,"CD44","Verify there is a site plan for construction phase (lay down area, dumpsters, crane lift locations, etc.)"]
[null,"CD45","Validate compliance with program statement and OPR"]
[null,"CD46","Fill out or obtain LEED Checklist from Consultant; verify level of LEED certification for project",null,null,null,"LEED Checklist"]
[null,"CD47","Finalize room numbering with IPF FIS"]
[null,"CD48","Request 90%+ complete design documents from consultant"]
[null,"CD49","Arrange for site signage (Major projects only)",null,null,null,"Construction Site Signage"]
[null,"CD50","Request graphic elements (logos and rendering) from Consultant and Construction Manager for construction site signage"]
[null,"CD51","Consolidate graphic elements (logos and rendering) for construction site signage and send to IPF Communications Manager"]
[null,"CD52","Review graphics fro construction site signage and send to Customer and PDC Director for review and approval"]
[null,"CD53","Review approval comments from Customer and PDC Director for construction site signage; request revisions to rendering as needed and re-submit to Communications Manager for approval"]
[null,"CD54","Obtain final Design Intent document from consultant"]
[null,"CD55","Request Standard Deviations Log from consultant",null,null,null,"Project Standards Deviation Log"]
[]
["Construction Documents - Project Schedule","CD56","Manage project schedule",null,null,null,"Schedule Worksheet for Major Projects (template)"]
[null,"CD57","Request updated schedule from Consultant or CM"]
[null,"CD58","Evaluate affect of design scope changes on the schedule"]
[]
["Construction Documents - Project Budget","CD59","Manage project budget",null,null,null,"Budget Cost Summary"]
[null,"CD60","Evaluate affect of design scope changes on the budget"]
[null,"CD61","Finalize list of potential value-engineering items"]
[null,"CD62","Request cost estimate from Consultant or CM"]
[null,"CD63","Identify potential add/or deduct alternate items"]
[null,"CD64","Review current project budget with Customer"]
[]
["Construction Documents - Plan Review","CD65","Verify titleblock on all sheets of review set complies with MSU standards and has accurate FAMIS project name and number; also check cover sheet",null,null,null,"Instructions for Formatting Project Drawings"]
[null,"CD66","Forward FADE spreadsheet to Building Performance to review final asset identification numbers and space numbering"]
[null,"CD67","If Self-performed project, create Project Request",null,null,null,"Project Request (template)"]
[null,"CD68","For a self-performed project, use the Construction Document Checklist to ensure drawings contain sufficient level of detail",null,null,null,"Self-Performed Capital Projects - Construction Document Checklist"]
[null,"CD69","For Base Contractor project, ensure all required submittals are listed on project drawings"]
[null,"CD70","Verify specifications comply with MSU standards and has accurate FAMIS project name and number",null,null,null,"Instructions for Formatting Project Specifications"]
[null,"CD71","If GC delivery, create front end documents and Division 1",null,null,null,"Front End Document (template)"]
[null,"CD72","List all required submittals in Division 1",null,null,null,"Division 1 (template)"]
[null,"CD73","Issue construction documents for review by Customer, internal team members and planning partners; using Unifier transmittal process"]
[null,"CD74","Issue construction documents for review by Quality Assurance Skilled Trades Representatives, using Transmittal form",null,null,null,"Quality Assurance Skilled Trades Rep Review Transmittal"]
[null,"CD75","Manage modifications to construction documents based on all review comments",null,null,null,"Plan Review (process)"]
[null,"CD76","Direct Consultant to update asset identification numbers and space numbering from FADE spreadsheet into final project documents"]
[null,"CD77","Schedule end-of-construction documents meeting with Customer to review scope, schedule and budget before moving into Bidding phase",null,null,null,"Bid Document Approval by Customer"]
[null,"CD78","Prepare agenda"]
[null,"CD79","Issue meeting minutes"]

{"sheet":"Bidding Task List","index":6,"n_rows":79,"n_cols":7,"rows_kept":79,"cut":false,"hidden":false,"merged":[[58,0,70,0],[72,0,78,0],[27,0,30,0],[2,5,2,6],[3,5,3,6],[32,0,42,0],[5,0,25,0],[44,0,56,0]]}
[]
[{"$f":"\"Project Number: \" &proj_id","v":"Project Number: "}]
[{"$f":"\"Project Name: \" &proj_nm","v":{"$error":"#N/A"}},null,null,null,null,"Bidding Phase - Detailed Task List"]
[null,null,null,null,null,"Bidding Process Flowchart"]
["Milestone","Item","Description","Status","Assignee","Due Date or Completion Date","Notes"]
["Manage Bidding - General Contractor (GC)","B1","Compile bid documents, including specifications and drawings",null,null,null,"Instructions for Formatting Project Specifications"]
[null,"B2","Request 100% complete bid set of drawings and specifications from the Consultant (or combine documents from in-house design team members)"]
[null,"B3","Obtain electronic set of bid documents from consultant"]
[null,"B4","Schedule bid opening with Contract Administrator (minor, major)"]
[null,"B5","Schedule pre-bid contractor walk-thru"]
[null,"B6","Invite \"Construction Project\" calendar to walk-thru and bid dates, to avoid conflicts with other projects"]
[null,"B7","Submit bid set drawings and specifications using the Bidding Documents process in Uniifer. Allow minimum 10 days for this process.",null,null,null,"Bidding Documents (process)"]
[null,"B8","If project requires state fire marshal review, prepare and submit an Application for Fire Safety Plan Examination to the Bureau of Fire Safety"]
[null,"B9","Attend pre-bid contractor walk-thru on site",null,null,null,"Sign-in Sheet (template)"]
[null,"B10","Issue Addenda as needed during bidding period",null,null,null,"Addendum (template)"]
[null,"B11","Attend bid opening with Contract Adminstrator (minor, major)"]
[null,"B12","Fill out the Bid Summary for Minor and Major Projects",null,null,null,"Bid Summary (template)"]
[null,"B13","Schedule post-bid review"]
[null,"B14","Based on the contractor bids, create the project budget"]
[null,"B15","Use the Budget Cost Summary",null,null,null,"Budget Cost Summary (template)"]
[null,"B16","Work with the Project Representative to finalize the budget"]
[null,"B17","Review FAMIS to ensure all costs are covered in the budget"]
[null,"B18","If over budget, value engineering or seek additional funding"]
[null,"B19","Notify low bidder"]
[null,"B20","Request Insurance, Sub-contractor's List, Unifier System - Vendor Information, and any other required documents",null,null,null,"Vendor Information (template)"]
[null,"B21","Confirm construction schedule"]
[]
["BOT Step 3 - General Contractor (GC)","B22","Contact the Customer for final project budget approval"]
[null,"B23","Create slide presentation for BOT Step 3 - Contract and Award Note: Use the BOT Title for the graphics. BOT Title can be found in the Description field on the General Tab in FAMIS.",null,null,null,"BOT Step 3 Presentation (template)"]
[null,"B24","Review slide presentation with Customer"]
[null,"B25","Create BOT Step 3 in Unifier; attach slides and Budget Cost Summary",null,null,null,"BOT Step 3 (instructions)"]
[]
["Contract Process for General Contractor (GC)","B26","Prepare Vendor Choice Justification Letter"]
[null,"B27","Create Contract Request record in Unifier, with attachments",null,null,null,"Contract Request (instructions)"]
[null,"B28","Contractor Bids",null,null,null,"Contractor Bids (reference)"]
[null,"B29","Vendor Choice Justification Letter"]
[null,"B30","Quotation Summary",null,null,null,"Quotation Summary (template)"]
[null,"B31","Bid Summary for Minor and Major Projects"]
[null,"B32","Contract Information for CPA"]
[null,"B33","Budget Cost Summary"]
[null,"B34","Unifier System - Vendor Information"]
[null,"B35","Track progress of Contracting record in Unifier",null,null,null,"Contracting (process)"]
[null,"B36","Review SOV details in PO-Construction Contract in Unifier"]
[]
["Manage Bidding - Construction Manager (CM)","B37","Review bid packages"]
[null,"B38","Atend trade contractor pre-bid walk-thru meetings"]
[null,"B39","Attend post-bid review"]
[null,"B40","Based on the trade contractor bids, create the project budget"]
[null,"B41","Use the Budget Cost Summary",null,null,null,"Budget Cost Summary (template)"]
[null,"B42","Work with the Project Representative to finalize the budget"]
[null,"B43","Review FAMIS to ensure all costs are covered in the budget"]
[null,"B44","If over budget, value engineering or seek additional funding"]
[null,"B45","Construction manager deliverables"]
[null,"B46","Trade contractor deliverables"]
[null,"B47","Confirm construction schedule"]
[null,"B48","Contact the Customer for final project budget approval"]
[null,"B49","Review and approve buy-out change orders",null,null,null,"Change Management (process)"]
[]
["Manage Bidding - Internal Construction Manager (ICM)","B50","Review bid packages"]
[null,"B51","Attend trade contractor pre-bid walk-thru meetings"]
[null,"B52","Attend post-bid review"]
[null,"B53","Based on the trade contractor bids, create the project budget"]
[null,"B54","Use the Budget Cost Summary",null,null,null,"Budget Cost Summary (template)"]
[null,"B55","Work with the Project Representative to finalize the budget"]
[null,"B56","Review FAMIS to ensure all costs are covered in the budget"]
[null,"B57","If over budget, value engineering or seek additional funding"]
[null,"B58","Internal Construction Manager deliverables"]
[null,"B59","Trade contractor deliverables"]
[null,"B60","Confirm construction schedule"]
[null,"B61","Contact the Customer for final project budget approval"]
[null,"B62","Review and approve buy-out change orders",null,null,null,"Change Management (process)"]
[]
["Post-Bid","B63","Schedule post-bid review meeting"]
[null,"B64","Prepare agenda"]
[null,"B65","Issue meeting minutes"]
[null,"B66","Value engineering"]
[null,"B67","Update Project Update note in Unifier Project Information form",null,null,null,"Project Information (instructions)"]
[null,"B68","Verify funding plan in FAMIS"]
[null,"B69","Issue Project Requests to IPF Maintenance Services or othe rIPF Department for work by owner",null,null,null,"Project Request (template)"]

{"sheet":"Pre-construction Task List","index":7,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[[2,5,2,6],[3,5,3,6],[8,0,14,0],[16,0,29,0],[57,0,60,0],[31,0,33,0],[35,0,39,0],[41,0,54,0],[5,0,6,0]]}
[]
[{"$f":"\"Project Number: \" &proj_id","v":"Project Number: "}]
[{"$f":"\"Project Name: \" &proj_nm","v":{"$error":"#N/A"}},null,null,null,null,"Pre-construction Phase - Detailed Task List"]
[]
["Milestone","Item","Description","Status","Assignee","Due Date or Completion Date","Notes"]
["Contracts","PC1","Issue Letter of Intent if needed to expedite non-construction activities",null,null,null,"Letter of Intent (template)"]
[null,"PC2","Ensure bonds, insurance and contract are ALL in place prior to mobilization of contractor on site",null,null,null,"Insurance (instructions)"]
[]
["Pre-Construction Phase Communications","PC3","Create construction communication plan",null,null,null,"Capital Project Communication Guidelines"]
[null,"PC4","Inform Project Administrator of anticipated mobilization date, as soon as possible (this is a trigger for the Project Administrator to change the project status to RELCON and update FAMIS and Unifier data)"]
[null,"PC5","Issue notice to building occupants"]
[null,"PC6","Engage project planning parters as needed",null,null,null,"Project Planning Partners List"]
[null,"PC7","Arrange for town hall meeting on projects impacting community"]
[null,"PC8","Coordinate installation of construction signage",null,null,null,"Construction Site Signage"]
[null,"PC9","Coordinate installation of detour / lot closure / etc. signage"]
[]
["Pre-Construction Project Meetings","PC10","Schedule pre-construction meeting with internal team"]
[null,"PC11","Schedule construction kick-off meeting"]
[null,"PC12","Prepare pre-construction meeting agenda",null,null,null,"Pre-Construction Packet (template)"]
[null,"PC13","Send emergency contact list to PDC Business Office"]
[null,"PC14","Contractor's affadavit",null,null,null,"Contractor's affadavit, waiver of lien, and wage statement"]
[null,"PC15","Fill out key distribution form",null,null,null,"Key Signout to Contractor (form)"]
[null,"PC16","Issue hazard communication notice",null,null,null,"Notice - Hazardous Communication"]
[null,"PC17","Start Final Payment Submittals / Closeout Checklist",null,null,null,"Contractor's Final Payment / Submittals / Closeout Checklist (template)"]
[null,"PC18","Give Backflow preventer inventory list template to contractor",null,null,null,"Backflow Preventer Inventory List"]
[null,"PC19","Give Backflow Test Report template to contractor",null,null,null,"Backflow Preventer Installation and Test Report"]
[null,"PC20","Process Contractor's confined space entry as needed",null,null,null,"Contractor Checklist for Confined Space Entry"]
[null,"PC21","Explain Facility Asset Data Exchange (FADE) process at pre-con meeting"]
[null,"PC22","Issue Contractor parking permits",null,null,null,"Contractor Parking Permit Request Form"]
[null,"PC23","Issue minutes from construction kick-off meeting"]
[]
["Pre-Construction Budget Maintenance","PC24","Review itemized budget; confirm FAMIS/Unifier match"]
[null,"PC25","Identify work orders",null,null,null,"Work Orders (reference)"]
[null,"PC26"]
[]
["Pre-Construction Schedule Maintenance","PC27","Verify long-lead items are addressed in the schedule"]
[null,"PC28","Finalize contractor's schedule"]
[null,"PC29","Consider activities at construction site and adjoining buildings"]
[null,"PC30","Set percent complete on Construction line in FAMIS schedule to 1% when mobilization occurs"]
[null,"PC31","Update owner's schedule; modify dates in FAMIS schedule as needed"]
[]
["Pre-Construction Site Logistics","PC32","Parking"]
[null,"PC33","Staging"]
[null,"PC34","Recycling"]
[null,"PC35","Dumpsters"]
[null,"PC36","Tree / plant protection"]
[null,"PC37","Site fencing"]
[null,"PC38","Lift plan"]
[null,"PC39","Pedestrian traffic"]
[null,"PC40","Egress"]
[null,"PC41","Construction signage",null,null,null,"Construction Site Signage"]
[null,"PC42","Fire exit plans"]
[null,"PC43","Fire extinguishers"]
[null,"PC44","Soil erosion, as approved by permit",null,null,null,"Soil Erosion (reference)"]
[null,"PC45","Detours"]
[null,"PC46","Barricading"]
[]
["Pre-Construction Quality Control","PC47","Soil erosion permits",null,null,null,"Soil Erosion (reference)"]
[null,"PC48","Mock-ups"]
[null,"PC49","Review fire marshal review / approval documents"]
[null,"PC50","Other permits",null,null,null,"Permits (reference)"]

{"sheet":"Construction Task List","index":8,"n_rows":65,"n_cols":7,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,5,2,6],[3,5,3,6],[48,0,64,0],[35,0,46,0],[5,0,9,0],[11,0,19,0],[21,0,27,0],[29,0,33,0]]}
[]
[{"$f":"\"Project Number: \" &proj_id","v":"Project Number: "}]
[{"$f":"\"Project Name: \" &proj_nm","v":{"$error":"#N/A"}},null,null,null,null,"Construction Phase - Detailed Task List"]
[]
["Milestone","Item","Description","Status","Assignee","Due Date or Completion Date","Notes"]
["Construction Phase Communications","C1","Issue utility shutdown notice(s)",null,null,null,"Notice - Utility Shutdown (template)"]
[null,"C2","Prepare and distribute construction status reports",null,null,null,"Customer Status Report"]
[null,"C3","Review Requests for Information (RFI) log",null,null,null,"RFI (process)"]
[null,"C4","Engage project planning parters as needed",null,null,null,"Project Planning Partners List"]
[null,"C5","Update Project Update note in Unifier Project Information form",null,null,null,"Project Information (instructions)"]
[]
["Construction Project Meetings","C6","Create agendas for progress meetings"]
[null,"C7","Conduct Progress meetings"]
[null,"C8","Review status of FADE spreadsheet at each progress meeting"]
[null,"C9","Distribute minutes from progess meetings"]
[null,"C10","Conduct internal PDC team huddles"]
[null,"C11","Huddle with consultant"]
[null,"C12","Conduct Commissioning meetings"]
[null,"C13","Conduct internal meeting with customer"]
[null,"C14","Conduct pre-install meetings"]
[]
["Construction Budget Maintenance","C14","Review payment applications and invoices; back-up documents",null,null,null,"Payment Applications (process)"]
[null,"C15","Review change management records and back-up documents",null,null,null,"Change Management (process)"]
[null,"C16","Create budget adjustments as needed",null,null,null,"Budget Adjustment (process)"]
[null,"C17","Identify and input potential cost records; close-out when done",null,null,null,"Potential Costs (process)"]
[null,"C18","Monitor current costs to date"]
[null,"C19","Track and manage contingency"]
[null,"C20","Set up work orders",null,null,null,"Work Orders (reference)"]
[]
["Construction Schedule Maintenance","C21","Coordinate construction with building activities"]
[null,"C22","Monitor owner's schedule; update FAMIS versions"]
[null,"C23","Review progress to date with baseline schedule"]
[null,"C24","Coordinate around special events"]
[null,"C25","Coordinate work by owner"]
[]
["Construction Site Logistics","C26","Move construction site signage or other site signage as needed"]
[null,"C27","Assist customer with their responsibilities:"]
[null,"C28","* key series with IPF key shop"]
[null,"C29","* electronic access with DPPS"]
[null,"C30","* phone numbers, entertainment / cable tv with telecomm"]
[null,"C31","* owner furnished equipment or furniture"]
[null,"C32","Arrange for installation of construction cores"]
[null,"C33","Engage DPPS with programming electronic card access"]
[null,"C34","Establish / issue parking criteria"]
[null,"C35","Coordinate move out and move in"]
[null,"C36","Coordinate site restoration"]
[null,"C37","Coordinate room numbering and signage"]
[]
["Construction Quality Control","C38","Confirm contractor's job specific safety plan"]
[null,"C39","Review / update project data in FAMIS and Unifier"]
[null,"C40","Monitor site cleaning"]
[null,"C41","Schedule commissioning and test-and-balance with Cx Agent"]
[null,"C42","Transmit test and balance report to consultant and internal Mechanical Engineer"]
[null,"C43","Review consultant field report"]
[null,"C44","Review and forward submittals",null,null,null,"Submittals (process)"]
[null,"C45","Send contractor's fire safety drawings and design documents to Fire marshal"]
[null,"C46","Send contractor's fire safety drawings to FM Global"]
[null,"C47","Review monitoring test results"]
[null,"C48","Provide stamp to contractor for concrete / sidewalk"]
[null,"C49","Conduct internal site inspections"]
[null,"C50","Arrange for external site inspections for permits"]
[null,"C51","Order site survey from FIS",null,null,null,"Site Surveys (reference)"]
[null,"C52","Site inspections - Quality Assurance Skilled Trades Representatives",null,null,null,"Trade Specific Construction Representative Closeout Checklist"]
[null,"C53","Create punchlist"]
[null,"C54","Manage deliverables identified by LEED Certification",null,null,null,"LEED Checklist"]

{"sheet":"Close-out Task List","index":9,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,5,2,6],[3,5,3,6],[35,0,37,0],[31,0,33,0],[5,0,8,0],[10,0,15,0],[17,0,21,0],[23,0,25,0],[27,0,29,0]]}
[]
[{"$f":"\"Project Number: \" &proj_id","v":"Project Number: "}]
[{"$f":"\"Project Name: \" &proj_nm","v":{"$error":"#N/A"}},null,null,null,null,"Close-out Phase - Detailed Task List"]
[]
["Milestone","Item","Description","Status","Assignee","Due Date or Completion Date","Notes"]
["Close-out Phase Contracts","CO1","Receive as-built drawings - forward to internal team members for review",null,null,null,"Project Close-out (procedure)"]
[null,"CO2","Receive operation and maintenance manuals - forward to internal team members for review",null,null,null,"Project Close-out (procedure)"]
[null,"CO3","Receive certificate of substantial completion if required",null,null,null,"Certificate of Substantial Completion (process)"]
[null,"CO4","Receive equipment and material warranties - forward to internal team members for review",null,null,null,"Equipment / Material Warranties (process)"]
[]
["Close-out Phase Communications","CO5","Submit substantial completion notice to IPF",null,null,null,"Substantial Completion Notice to IPF (template)"]
[null,"CO6","Complete Contractor Rating by Owner",null,null,null,"Contractor Rating by Owner (instructions)"]
[null,"CO7","Complete Consultant Rating by Owner",null,null,null,"Consultant Rating by Owner (instructions)"]
[null,"CO8","Send all hard copy project files to FIS"]
[null,"CO9","Discuss  equipment requiring maintanence with customer"]
[null,"CO10","Move all project e-mail messages into the project-specific Public Folders/PDC Project E-mails folder in Outlook",null,null,null,"PDC Project Email Public Folders"]
[]
["Close-out Project Meetings","CO11","Coordinate warranty period meetings (3, 6, 10 months)"]
[null,"CO12","Coordinate customer training"]
[null,"CO13","Walk-thru with Customer"]
[null,"CO14","Conduct lessons learned meeting"]
[null,"CO15","Conduct tours on request"]
[]
["Close-out Budget Maintenance","CO16","Close work orders"]
[null,"CO17","Validate final project cost"]
[null,"CO18","Send final budget to customer (when CP is closed)"]
[]
["Close-out Schedule Maintenance","CO19","Update FAMIS schedule and % complete"]
[null,"CO20"]
[null,"CO21"]
[]
["Close-out Site Logistics","CO22","Contact key shop for final coring"]
[null,"CO23","Create key numbering list"]
[null,"CO24","Finalize site restoration"]
[]
["Close-out Quality Control","CO25","Confirm completion of punch lists "]
[null,"CO26","Review final payment "]
[null,"CO27","Complete close-out checklist",null,null,null,"Contractor's Final Payment / Submittals / Closeout Checklist (template)"]

{"sheet":"PROCESS MAPS ---->","index":10,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Process Maps"]

{"sheet":"CP Delivery Phases","index":11,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Capital Project Delivery Process"]

{"sheet":"Planning Process","index":12,"n_rows":3,"n_cols":16,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,15,2,16]]}
[]
[null,null,null,null,"Planning Phase - Process with Milestones"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planning Task List"]

{"sheet":"Schematic Design Process","index":13,"n_rows":2,"n_cols":16,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Schematic Design (SD) Phase - Process with Milestones",null,null,null,null,null,null,null,null,null,null,null,null,null,"SD Task List"]

{"sheet":"Design Development Process","index":14,"n_rows":3,"n_cols":16,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Design Development (DD) Phase - Process with Milestones"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DD Task List"]

{"sheet":"Construction Docs Process","index":15,"n_rows":4,"n_cols":16,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Construction Documents (CD) Phase - Process with Milestones"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CD Task List"]

{"sheet":"Bidding Process","index":16,"n_rows":2,"n_cols":15,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Bidding Phase - Process with Milestones",null,null,null,null,null,null,null,null,null,null,null,null,"Bidding Task List"]

{"sheet":"Pre-Construction Process","index":17,"n_rows":6,"n_cols":15,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Pre-Construction Phase - Process with Milestones",null,null,null,null,null,null,null,null,null,null,null,null,"Pre-construction Task List"]
[]
[]
[]
[null,"Flowchart is under construction"]

{"sheet":"Construction Process","index":18,"n_rows":7,"n_cols":15,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Construction Phase - Process with Milestones",null,null,null,null,null,null,null,null,null,null,null,null,"Construction Task List"]
[]
[]
[]
[]
[null,"Flowchart is under construction"]

{"sheet":"Closeout Process","index":19,"n_rows":6,"n_cols":15,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Closeout Phase - Process with Milestones",null,null,null,null,null,null,null,null,null,null,null,null,"Close-out Task List"]
[]
[]
[]
[null,"Flowchart is under construction"]

{"sheet":"PM TOOLS---->","index":20,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Project Management Tools"]

{"sheet":"Project Status Reports","index":21,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[6,0,6,2]]}
[]
[{"$f":"\"Project Number: \" &proj_id","v":"Project Number: "},"Project Status Reports"]
[{"$f":"\"Project Name: \" &proj_nm","v":{"$error":"#N/A"}}]
[]
[]
[]
["Customer Construction Report"]
["Username: IPFUser, Password: IPFUser123$"]
["Search by Capital Project number"]
[]
["Capital Projects Reporting"]
["This is an online report database created by IT Services to allow real-time report access, with live updates."]
["Webpate address is https://sql.ipf.msu.edu/Reports/browse/IPF%20Custom%20Reports/Capital%20Projects%20Reporting"]
["Go to the report named \"Cost Sheet\" (make it a favorite by clicking on three dots and selecting \"Add to Favorites\")"]
["Search by Capital Project number"]
[]
["Project Status Report"]
["This report is currently e-mailed to the Project Delivery team supervisors who share it with the project teams."]
[]
["Cost Sheet Full Budget"]
["This is a User-Defined Report that exists in each project in Unifier."]

{"sheet":"Project Planning Partners List","index":22,"n_rows":99,"n_cols":9,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Project Number: \" &proj_id","v":"Project Number: "}]
[{"$f":"\"Project Name: \" &proj_nm","v":{"$error":"#N/A"}}]
[null,null,null,"Project Planning Partners List"]
["S E R V I C E","O F F I C E","Supervisor and/or Alternate","Design and Construction Notes","On the Team?","P R I M A R Y                      C O N T A C T","Office Phone","E-mail Address","GROUP"]
["Accessibility ","Resource Center for Persons with Disabilities","Mike Hudson",null,null,"Virginia Martz","353-9642  355-1293","martzvir@msu.edu","MSU"]
["Air Handlers & Boilers","Project Services","Shawn Kelly",null,null,"Mike Bingham","884-3631","mbingham@ipf.msu.edu","IPF"]
["Alterations & Improvements","Maintenance Services","Mark Lutkenhoff",null,null,"Mark Lutkenhoff","432-0537","mlutkenhoff@ipf.msu.edu","IPF"]
["Archeology - project excavation","Anthropology Social Science",null,null,null,"Lynne Goldstein","353-4704","lynneg@msu.edu","MSU"]
["Architectural - Carpentry, Door Hardware, Elevators, Firestopping, Insulation, Painting/Coating, Penetrations through rated construction","Building Performance Services","Jason Vallance",null,null,"Mark Geahan","432-7103","mgeahan@ipf.msu.edu","IPF"]
["Architectural - Coatings/Toppings/Grout, Foundation, Masonry, Penetrations through masonry, Roofing, Waterproofing","Building Performance Services","Jason Vallance",null,null,"Ron Williams","884-4980","rwilliams@ipf.msu.edu","IPF"]
["Art on Campus","Campus Planning","Lynda Boomer",null,null,"Steve Troost","884-0773","troost@ipf.msu.edu","IPF"]
["Building Steam & Heating Systems","Project Services","Shawn Kelly",null,null,"Scott Kyes","432-0539","skyes@ipf.msu.edu","IPF"]
["Building Steam & Heating Systems","Building Performance Services","Jason Vallance",null,null,"Mike Carreri","432-7103","mcarreri@ipf.msu.edu","IPF"]
["Building Steam & Heating - Impact to RHS Facilities","RHS - Planning & Projects Office","Vennie Gore",null,null,"Diane Barker                     (+Bill Whitbeck)","884-6451   432-0371","barker@rhs.msu.edu","MSU"]
["Campus Planning","Campus Planning","Lynda Boomer",null,null,"Steve Troost","884-0773","troosts@msu.edu","IPF"]
["Capital Renewal (formerly known as Just-in Time or JIT)","Building Performance Services","Jason Vallance",null,null,"Kelsey Oosterhoff","517-884-6665","oosterk@msu.edu","IPF"]
["CATV/Fiber Optic Services - Relocation, Temporary Services, New Installation","Telecommunication Systems","Jeff Carpenter",null,null,"Don Mintz","432-5966","dmintz@ipf.msu.edu","IPF"]
["Classroom & Academic Alterations, Space Assignment","Facilities Planning & Space Management, OPB","Provost",null,null,"Barb Kranz","353-5062","kranzb@msu.edu","MSU"]
["Classroom & Space Assignment in RHS Buildings","RHS - Space Coordination and Review Committee","Vennie Gore",null,null,"Jane Emery, Chair","884-6451","emeryj@rhs.msu.edu","MSU"]
["Cleaning Building Interiors","Custodial Services","Adam Lawver",null,null,"Brandon Baswell","432-0548","bbaswell@ipf.msu.edu","IPF"]
["Commissioning - New Construction","Building Performance Services","Jason Vallance",null,null,"Martin McDonough","884-7292","mmcdonough@ipf.msu.edu","IPF"]
["Commissioning - Ongoing","Building Performance Services","Jason Vallance",null,null,"Jared Parker","884-6666","jparker@ipf.msu.edu","IPF"]
["Commissioning, Sustainability & Energy in RHS Buildings","RHS - Planning and Projects Office","Diane Barker",null,null,"Carla Iansiti","884-0626","iansiti@rhs.msu.edu","MSU"]
["Communications","Communications","Jennifer Battle",null,null,"Michelle Lavra","432-3624","mlavra@ipf.msu.edu","IPF"]
["Contracts & Procurement","Planning, Design and Construction","Lynda Boomer",null,null,"Jack Mumma","884-0772","mumma@msu.edu","IPF"]
["Door Hardware","Project Services","Shawn Kelly",null,null,"Greg Pierce","432-0535","gpierce@ipf.msu.edu","IPF"]
["Electrical - Power, High voltage, Telecommunications, Fire Alarm","Building Performance Services","Jason Vallance",null,null,"Bill Zlotek","432-7103","bzlotek@ipf.msu.edu","IPF"]
["Electrical Distribution (including High Voltage)","Maintenance Services","John Nurenberg",null,null,"Dan Bell","432-0566","dbell@ipf.msu.edu","IPF"]
["Electronics & Security Access","Maintenance Services","John Nurenberg",null,null,"Keith Spitzley","884-3696","kspitzley@ipf.msu.edu","IPF"]
["Elevators","Maintenance Services","John Nurenberg",null,null,"Kevin Bragg","432-0514","kbragg@ipf.msu.edu","IPF"]
["Energy Impact","Energy & Environment","TBD",null,null,"TBD",null,null,"IPF"]
["Equipment I.D.# Assignment","Building Performance Services","Jason Vallance",null,null,"Maranda Holtsclaw","432-0542","mholtsclaw@ipf.msu.edu","iPF"]
["Events Coordination","Custodial Services",null,null,null,"Michael Mitchner","432-0547","mmitchner@ipf.msu.edu","IPF"]
["Fire Alarms    ","Building Performance Services","Jason Vallance",null,null,"Randy Evans","449-1829","revans@ipf.msu.edu","IPF"]
["Fire Alarms","Maintenance Services","John Nurenberg",null,null,"Keith Spitzley","884-3696","kspitzley@ipf.msu.edu","IPF"]
["Fire Safety Review - Alarms, Sprinklers, Means of Egress, Bldg. Evacuation Maps, Roof Replacement","MSU Police - Fire Marshal","Dave Trexler",null,null,"Denis Zietlow","432-1587","zietlow@msu.edu","MSU"]
["Fire Suppression","Maintenance Services","John Nurenberg",null,null,"Corey Morris","432-7103","cmorris@ipf.msu.edu","IPF"]
["Food Service Facilities & Equipment","University Physician's Office","David Weismantel",null,null,"Betty                               Wernette-Babian","355-9700","wernett2@msu.edu","MSU"]
["Food Vending & Sparty's stores","RHS Culinary Services","Guy Procopio",null,null,"Bill Kost","355-4550","kost@msu.edu","MSU"]
["Glass Shop","Building Performance Services","Jason Vallance",null,null,"Ron Williams","884-4980","rwilliams@ipf.msu.edu","IPF"]
["Hazardous Materials - Asbestos Testing & Abatement","Project Services","Shawn Kelly",null,null,"Matthew Smith","353-5386","masmith@ipf.msu.edu","IPF"]
["Hazardous Materials Compliance                   (Asbestos, Lead & PCB)","EHS","Mary Lindsey-Frary",null,null,"Dan Lyons","353-8956","lyonsda4@msu.edu","MSU"]
["HVAC Controls","Building Performance Services","Jason Vallance",null,null,"Bill Lakos","432-0530","wjlakos@ipf.msu.edu","IPF"]
["HVAC Controls","Building Performance Services","Jason Vallance",null,null,"Martin McDonough","884-7292","mmcdonough@ipf.msu.edu","IPF"]
["HVAC Controls","Planning, Design and Construction","John LeFevre",null,null,"Bryan Anderson",null,"banderson@ipf.msu.edu","IPF"]
["HVAC Controls","Project Services","Shawn Kelly",null,null,"Ryan Gallagher","884-3889","rgallagher@ipf.msu.edu","IPF"]
["HVAC Controls","Building Performance Services","Jason Vallance",null,null,"Dale Seddon","884-2508","dseddon@ipf.msu.edu","IPF"]
["Key Shop","Maintenance Services","Keith Spitzley",null,null,"Stephen Glass","353-1760","sglass@ipf.msu.edu","IPF"]
["Laboratory Spaces - All aspects","EHS","Dave Erickson",null,null,"Genevieve Cottrell","432-8715","cottre36@ehs.msu.edu","MSU"]
["Laboratory Spaces - Fume Hood","EHS","Genevieve Cottrell",null,null,"Dave Erickson","355-6545","erickson@msu.edu","MSU"]
["Liability","Risk Management","Matt McCabe",null,null,"Bobbi Boland","355-5022","bolandb@ctlr.msu.edu","MSU"]
["Masonry & Foundations","Maintenance Services","Mark Lutkenhoff",null,null,"Ron Williams","884-4980","rwilliams@ipf.msu.edu","IPF"]
["Mechanical Services","Maintenance Services","Stacy Nurenberg",null,null,"Sam Fortino","432-0505","sfortino@ipf.msu.edu","IPF"]
["Mechanical - Plumbing and Piping Insulation, Plumbing Piping, Plumbing Pumps, Process Piping","Building Performance Services","Jason Vallance",null,null,"Doug Speight","432-7103","dspeight@ipf.msu.edu","IPF"]
["Mechanical - Air Conditioning Systems, Air Handlers, Boilers, HVAC Controls, HVAC Pumps, Refrigeration, Sheet Metal, Water Treatment","Building Performance Services","Jason Vallance",null,null,"Mike Carreri","432-7103","mcarreri@ipf.msu.edu","IPF"]
["Paint & Coatings","Project Services","Shawn Kelly",null,null,"Greg Pierce","432-0535","gpierce@ipf.msu.edu","IPF"]
["Parking - Temporary, New & Alterations","MSU Police","John Prush",null,null,"Stephanie O'Donnell","432-2005","odonnell@police.msu.edu","MSU"]
["Plumbing & Piping Insulation","Project Services","Shawn Kelly",null,null,"TBD",null,null,"IPF"]
["Process Piping","Project Services","Shawn Kelly",null,null,"Scott Kyes","432-0539","skyes@ipf.msu.edu","IPF"]
["Pumps & Refrigeration, Absorption/Chillers, Cooling Towers; Water Treatment","Project Services","Shawn Kelly",null,null,"Brian North","884-8463","bnorth@ipf.msu.edu","IPF"]
["Recycling, Surplus Store","Surplus Store and Recycling","Bob Ellerhorst",null,null,"Kris Jolley","432-9446","jolleykr@msu.edu","IPF"]
["RHS Projects - Health & Safety Issues","RHS - Planning & Projects Office","Diane Barker",null,null,"Joe Petroff","884-2598","petroff@rhs.msu.edu","MSU"]
["RHS Projects - Interior Design by RHS","RHS - Planning & Projects Office","Diane Barker",null,null,"Bill Whitbeck","432-0371","barker@rhs.msu.edu","MSU"]
["RHS Projects - Technology ","RHS - Information Services","Michael Dawisha",null,null,"Paul Heberlein","355-4656","heberle1@rhs.msu.edu","MSU"]
["Roads, City of East Lansing","City of East Lansing","Carl Fedders",null,null,"Carl Fedders","319-6928","cfedders@cityofeastlansing.com","Off-Campus"]
["Roads, City of Lansing","City of Lansing","Chad Gamble",null,null,"Dan Danke","483-4461","ddanke@lansingmi.gov","Off-Campus"]
["Roads, Ingham County","Ingham County Rd. Commission","William Conklin",null,null,"Robert Peterson","676-9722","rpeterson@inghamcrc.org","Off-Campus"]
["Roads, State of Michigan","MDOT",null,null,null,"Jack Rick","750-0435","rickj@michigan.gov","Off-Campus"]
["Roads/Circulation Impact to RHS Facilities","RHS - Planning & Projects","Vennie Gore",null,null,"Diane Barker                     ","884-6451","barker@rhs.msu.edu","MSU"]
["Roofing ","Building Performance Services","Jason Vallance",null,null,"Ron Williams","884-4980","rwilliams@ipf.msu.edu","IPF"]
["Room & Wayfinding Signage","Maintenance Services","Deb Russell",null,null,"Kay Steele","432-2468","ksteele@ipf.msu.edu","IPF"]
["Room Numbering (including reconfiguration)","Planning, Design and Construction","Lorena Griffin",null,null,"Scott Friend","353-2368","sfriend@ipf.msu.edu","IPF"]
["Security Design","MSU Police","John Prush",null,null,"Denni Kraft","353-1965","kraftd@police.msu.edu","MSU"]
["Security Installation & Maintenance","Maintenance Services","John Nurenberg",null,null,"Keith Spitzley","884-3696","kspitzley@ipf.msu.edu","IPF"]
["Set-up","Maintenance Services","Jeff Groll",null,null,"Jim Peaney","432-6537","jbpeaney@ipf.msu.edu","IPF"]
["Sheet Metal ","Project Services","Shawn Kelly",null,null,"Mike Bingham","884-3631","mbingham@ipf.msu.edu","IPF"]
["Site Survey","Planning, Design and Construction","John LeFevre",null,null,"Jeff West","432-0110","jwest@ipf.msu.edu","IPF"]
["Soil Erosion","Building Performance Services","Jason Vallance",null,null,"Ray Wieber","432-7103","rwieber@ipf.msu.edu","IPF"]
["Soil Erosion & Sedimentation - East Lansing","City of East Lansing","Bob Scheurman",null,null,"Jack Schineman","337-9459","jschine@cityofeastlansing.com  ","Off-Campus"]
["Soil Erosion & Sedimentation - Ingham County","Ingham County Drain Commission","Pat Lindemann",null,null,"Paul Pratt (+ Carla Closs & Randy Abbott)","676-8391","da_pratt@ingham.org","Off-Campus"]
["Storm Water Management","Planning, Design and Construction","John LeFevre",null,null,"Dave Wilber","884-2186","dwilber@ipf.msu.edu","IPF"]
["Street Light Distribution","Maintenance Services","John Nurenberg",null,null,"Dan Bell","432-0566","jmnuren@ipf.msu.edu","IPF"]
["Structural Services (roofing, structural, alterations and improvements)","Maintenance Services","Mark Lutkenhoff",null,null,"Wayne Buck","432-0511","wbuck@ipf.msu.edu","IPF"]
["Sustainability","Sustainability","Ann Erhardt",null,null,"Ann Erhardt","884-7003","aerhardt@ipf.msu.edu","IPF"]
["Technology - ALL SYSTEMS","IT Services - Project Management and Integration Services","Kevin Kuss",null,null,"Steve Crippen","432-7306","crippen3@msu.edu","MSU"]
["Technology - Audio /Visual","IT Services - Teaching & Learning","Annette McLane",null,null,"Steve Jowett","355-7657","ITservices.TL.PMO@campusad.msu.edu","MSU"]
["Technology - Networking & WIFI","IT Services - Infrastructure","Jim Green",null,null,"#1 - Aimee Houghton                 #2 - Lih-Er Wey","884-3084   432-2936","ITservices.Infrastructure.PMO@campusad.msu.edu","MSU"]
["Telephone Services - Emergency Phones","Telecommunication Systems","Jeff Carpenter",null,null,"Don Mintz","432-5966","dmintz@ipf.msu.edu","IPF"]
["Title IX issues","Office of Institutional Equity","Jessica Norris",null,null,"Jessica Norris","353-3922","jrnorris@msu.edu","MSU"]
["Title IX issues","General Counsel's Office","Kristine Zayko",null,null,"Kristine Zayko","353-1726","zayko@msu.edu","MSU"]
["Traffic/Parking Design - Temporary & New","MSU Police","John Prush",null,null,"Stephanie O'Donnell","432-2005","odonnell@police.msu.edu","MSU"]
["Tree Protection/Removal, Landscaping,  Lawn Repair, Exterior signage removal/installation, Pavement repair","Landscape Services","Adam Lawver",null,null,"Matt Bailey","648-6857","mbailey@ipf.msu.edu","IPF"]
["Utility Distribution - Sewers, Steam, Water, Chilled Water","Building Performance Services","Jason Vallance",null,null,"Ray Wieber","432-7103","rwieber@ipf.msu.edu","IPF"]
["Utility Distribution - Sewers, Steam, Water, Chilled Water","Maintenance Services","Stacy Nurenberg",null,null,"Sam Fortino","432-0505","sfortino@ipf.msu.edu","IPF"]
["Utility Meters","Power & Water","Bob Ellerhorst",null,null,"Rick Johnson","355-3314","rjohnson@ipf.msu.edu","IPF"]
["Waste Management - Environmental","EHS","Kevin Eisenbeis",null,null,"Tom Grover","355-6651","grovert@msu.edu","MSU"]
["Water Intrusion, Mold","Project Services","Shawn Kelly",null,null,"Paul Coonrod","353-2931","pcoonrod@ipf.msu.edu","IPF"]
[]
["Updated:  October 17, 2017"]

{"sheet":"Issues Log","index":23,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"\"Project Number: \" &proj_id","v":"Project Number: "}]
[{"$f":"\"Project Name: \" &proj_nm","v":{"$error":"#N/A"}},null,null,null,null,null,"Issues Log"]
[]
[]
["Issue #","Entry Date","Entered By","Category (S=Scope, B=Budget, S=Schedule, O=Other)","Issue Description","Priority (H, M, L)","Action Manager","Target Resolution Date","Status (U=Unassigned, A=Assigned, C=Closed)","Description of Action Taken"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]

{"sheet":"Deviations Log","index":24,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,0,4,1],[8,1,8,2],[8,6,8,8],[6,0,6,4],[5,4,5,8],[5,0,5,3]]}
[]
[{"$f":"\"Project Number: \" &proj_id","v":"Project Number: "}]
[{"$f":"\"Project Name: \" &proj_nm","v":{"$error":"#N/A"}},null,null,null,null,null,"Deviations Log"]
[]
["<Current Date of Log>"]
["<Description and date of document set, ex: Bid Documents>",null,null,null,"Does the project deviate from MSU standards?  _______No    ________Yes, see below"]
["<CONSULTANT NAME> PROJECT NO:  XXX"]
[]
["ITEM ","STANDARDS REFERENCE",null,"DESCRIPTION","STANDARDS REQUIRE","PROPOSED APPROACH, REASON FOR NON-CONFORMANCE, ","ACCEPTED (A) OR REJECTED (R)"]
["NO","SECTION","PART",null,null,"AND DESCRIPTION OF POTENTIAL IMPACT","A/R","DATE","NAME"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Instructions for use:"]
["1.  Include adequate detail to clearly explain decision to deviate from MSU standards."]
["2.  Review log at each design meeting, and submit with each progress payment."]
["3.  Accepted By/Rejected By signatures or initials must be from the Senior Architect, Landscape Architect, Civil Engineer, Mechanical Engineer or Electrical Engineer at MSU, and the Customer."]

{"sheet":"Project A3","index":25,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[45,8,52,9],[7,3,18,3],[20,3,31,3],[33,3,44,3],[1,5,1,9]]}
[]
[null,null,null,"Report Date:",null,{"$f":"proj_nm","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"TODAY()","v":"2019-12-12"},null,{"$f":"proj_id","v":0}]
[]
[]
[]
[]
[null,"Program Needs",null,null,null,"Dept/Name","E-mail",null,"Milestone","Date(s)"]
[]
[null,null,null,null,null,"Customer(s):",null,null,"CIPWG 1"]
[null,"Project Goals",null,null,null,null,null,null,"BOT Step 1"]
[null,null,null,null,null,null,null,null,"Consultant Procurement"]
[null,null,null,null,null,null,null,null,"Schematic Design draft"]
[null,"Affected Units",null,null,null,null,null,null,"Schematic Design estimate"]
[null,null,null,null,null,null,null,null,"CIPWG materials due"]
[null,null,null,null,null,"Executive Sponsor(s):",null,null,"Interim CIPWG"]
[null,"Project Scope",null,null,null,null,null,null,"DD review and estimate"]
[null,null,null,null,null,null,null,null,"CIPWG materials due"]
[null,null,null,null,null,null,null,null,"CIPWG 2"]
[null,"Out of Scope",null,null,null,null,null,null,"BOT materials due"]
[null,null,null,null,null,null,null,null,"BOT Step 2"]
[null,null,null,null,null,"PDC Project Team:",null,null,"90% review set due"]
[null,"Consistency with Campus Master Plan (variance required?)",null,null,null,null,null,null,"90% review meeting"]
[null,null,null,null,null,null,null,null,"Bid set to MSU"]
[null,null,null,null,null,null,null,null,"Bid Period"]
[null,"Capital Renewal (JIT) Maintenance",null,null,null,null,null,null,"BOT materials due"]
[null,null,null,null,null,null,null,null,"BOT Step 3"]
[null,null,null,null,null,null,null,null,"Construction"]
[null,"Utilities"]
[]
[]
[null,"Parking",null,null,null,"Professional Services Team:"]
[]
[null,null,null,null,null,null,null,null,"Milestone","Budget"]
[null,"Circulation",null,null,null,null,null,null,"BOT Step 1","$$$"]
[null,null,null,null,null,null,null,null,"Design Development","$$$"]
[null,null,null,null,null,null,null,null,"BOT Step 2","$$$"]
[null,"Safety and Security",null,null,null,null,null,null,"Construction Documents","$$$"]
[null,null,null,null,null,null,null,null,"BOT Step 3","$$$"]
[null,null,null,null,null,"Subject Matter Experts:",null,null,"Funded Amount","$$$"]
[null,"Energy and Sustainability"]
[]
[]
[null,"Storm Water Management"]
[]
[]
[null,"Hazardous Building Materials Review"]

{"sheet":"Team Contact List","index":26,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"\"Project Number: \" &proj_id","v":"Project Number: "}]
[{"$f":"\"Project Name: \" &proj_nm","v":{"$error":"#N/A"}},null,null,null,null,"Team Contact List"]
[]
[]
["Name","Role","Company","Office Phone","Cell Phone","E-mail Address"]

{"sheet":"Drop-down lists","index":27,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
["Not Started"]
["In Progress"]
["Complete"]
["NA"]

{"sheet":"CODING --->","index":28,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"THIS_CP","index":29,"n_rows":2,"n_cols":40,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["CP  NO","DESCRIPTION","STATUS","PROJ MGR","CUSTOMER","ARCH","INT DES","LANDSC ARCH","CIVIL ENG","MECH ENG","ELEC ENG","CONST REP","PROJ ADMIN","CONSULTANT","CONSTRUCTOR","DELIVERY METHOD","EST COST","PLANNED_TOTAL","ACTUAL_TOTAL","PLANNED_PLANNING_START","PLANNED_PLANNING_END","PLANNING_PERCENT_COMPLETE","PLANNED_ESTIMATE_START","PLANNED_ESTIMATE_END","ESTIMATE_PERCENT_COMPLETE","PLANNED_DESIGN_START","PLANNED_DESIGN_END","DESIGN_PERCENT_COMPLETE","PLANNED_BID_START","PLANNED_BID_END","BID_PERCENT_COMPLETE","PLANNED_CONSTRUCTION_START","PLANNED_CONSTRUCTION_END","CONSTRUCTION_PERCENT_COMPLETE","PLANNED_OCCUPANCY_START","PLANNED_OCCUPANCY_END","OCCUPANCY_PERCENT_COMPLETE","PLANNED_CLOSED_START","PLANNED_CLOSED_END","CLOSED_PERCENT_COMPLETE"]
[{"$f":"proj_id","v":0},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!B:B),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!C:C),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!AB:AB),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!AC:AC),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!AD:AD),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!AE:AE),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!AF:AF),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!AG:AG),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!AH:AH),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!AI:AIB),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!AJ:AJ),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!AK:AK),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(Table_ExternalData_1[CONSULTANT]),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!AM:AM),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!AN:AN),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!D:D),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!E:E),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!F:F),0)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!G:G),0) = \"\", \"\", VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!G:G),0) )","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!H:H),0) = \"\", \"\", VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!H:H),0) )","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!I:I),0)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!J:J),0) = \"\", \"\", VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!J:J),0) )","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!K:K),0) = \"\", \"\", VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!K:K),0) )","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!L:L),0)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!M:M),0) = \"\", \"\", VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!M:M),0) )","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!N:N),0) = \"\", \"\", VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!N:N),0) )","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!O:O),0)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!P:P),0) = \"\", \"\", VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!P:P),0) )","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!Q:Q),0) = \"\", \"\", VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!Q:Q),0) )","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!R:R),0)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!S:S),0) = \"\", \"\", VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!S:S),0) )","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!T:T),0) = \"\", \"\", VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!T:T),0) )","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!U:U),0)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!V:V),0) = \"\", \"\", VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!V:V),0) )","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!W:W),0) = \"\", \"\", VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!W:W),0) )","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!X:X),0)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!Y:Y),0) = \"\", \"\", VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!Y:Y),0) )","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!Z:Z),0) = \"\", \"\", VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!Z:Z),0) )","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!AA:AA),0)","v":{"$error":"#N/A"}}]

{"sheet":"ACTIVE_CPS","index":30,"n_rows":361,"n_cols":40,"rows_kept":361,"cut":false,"hidden":false,"merged":[]}
["PROJECT_NUMBER","PROJECT_NAME","STATUS","EST_COST","PLANNED_TOTAL","ACTUAL_TOTAL","PLANNING_PLANNED_START_DATE","PLANNING_PLANNED_END_DATE","PLANNING_PERCENT_COMPLETE","ESTIMATE_PLANNED_START_DATE","ESTIMATE_PLANNED_END_DATE","ESTIMATE_PERCENT_COMPLETE","DESIGN_PLANNED_START_DATE","DESIGN_PLANNED_END_DATE","DESIGN_PERCENT_COMPLETE","BID_PLANNED_START_DATE","BID_PLANNED_END_DATE","BID_PERCENT_COMPLETE","CONST_PLANNED_START_DATE","CONST_PLANNED_END_DATE","CONST_PERCENT_COMPLETE","OCCUP_PLANNED_START_DATE","OCCUP_PLANNED_END_DATE","OCCUP_PERCENT_COMPLETE","CLOSED_PLANNED_START_DATE","CLOSED_PLANNED_END_DATE","CLOSED_PERCENT_COMPLETE","PROJECT_MANAGER","CUSTOMER","ARCHITECT","INTERIOR_DESIGNER","LANDSCAPE_ARCHITECT","CIVIL_ENGINEER","MECHANICAL_ENGINEER","ELECTRICAL_ENGINEER","CONTRUCTION_REP","PROJECT_ADMIN","CONSULTANT","CONSTRUCTOR","DELIVERY_METHOD"]
["CP14358","KEDZIE HALL - ALTERATIONS TO ROOMS N331A AND N331B","IN DES","120,000",120000,0,null,null,null,null,null,null,"2017-08-24","2018-03-30",70,{"$f":"VLOOKUP(proj_id,ACTIVE_CPS!1:1048576,COLUMN(ACTIVE_CPS!J:J),0)","v":{"$error":"#N/A"}},null,null,"2018-05-14","2018-08-17",null,"2018-08-17","2019-05-17",null,"2019-05-17","2019-08-17",null,"CHARLANDB","THOMAS HARPSTEAD","CHARLANDB","LOCKWOODC","-","-","GOERGES","HALSEYG","LUTKENHOFFM",null,"IPF","IPF","IPF - IPF SELF-PERFORMED"]
["CP17240","FRIB - CRYOGENIC ASSEMBLY - CONSTRUCT ORIGINAL BUILDING","IN DES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KOLPJ",null,"KOLPJ",null,null,null,null,null,null,null,null,null,"TBD - TO BE DETERMINED"]
["CP16110","PLANT AND SOIL SCIENCE  - ALTERATIONS TO ROOMS A398A AND A398B","RELCON","68,000",68000,60688,null,null,null,"2016-04-01","2016-05-16",null,null,null,null,null,null,null,"2016-09-28","2016-11-15",20,null,null,null,null,null,null,"O'BRIENI","LORRI BUSICK","-","-","-","-","-","-","-",null,"IPF","IPF","DB - DESIGN BUILD"]
["CP16203","COMMUNICATION ARTS - REPLACE ROOFS 1, 2, 3, 6, 7, 14 AND 15","OUTBID","2,200,000",2200000,20070,null,null,null,null,null,null,"2016-07-27","2018-01-31",100,"2017-10-20","2017-11-09",null,"2018-05-14","2018-08-17",null,"2018-08-17","2019-05-17",null,"2019-05-17","2019-08-17",null,"CHARLANDB","LYNDA BOOMER","CHARLANDB","-","KINNEYD","LEFEVREJ","-","-","GOTTSCHALKK","ROBIN MCVAY","ROOFING TECHNOLOGIES",null,"GC - DESIGN BID & BUILD"]
["CP13351","1855 PLACE - CONSTRUCT ORIGINAL BUILDINGS","SUBSTCOMP","156,700,000",156700000,138127265,null,null,null,null,null,null,"2014-01-01","2015-06-30",100,null,null,null,"2015-07-01","2017-07-31",97,"2017-08-31","2018-08-31",null,"2018-08-31","2019-01-30",null,"TEMPLER","BILL WHITBECK","TEMPLER","-","WILBERD","LEFEVREJ","FRANCISD","BEACHK","LINEBAUGHA","LAURIE BRINKER","KENNETH NEUMANN / JOEL SMITH & ASSOC INC","WALBRIDGE ALDINGER","CM - CONSTRUCTION MANAGER"]
["CP17253","MSU COLLEGE OF LAW - REPLACE FREIGHT ELEVATOR #3","IN DES","420,000",420000,0,null,null,null,null,null,null,"2017-12-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GOTTSCHALK","LYNDA BOOMER","KASDORFJ","-","-","-","-","HALSEYG","GOTTSCHALK","LAURIE BRINKER",null,null,"TBD - TO BE DETERMINED"]
["CP15051","KRESGE ART - DUST AND EXHAUST SYSTEM FOR WORK SPACES","RELCON","40,000",25000,17849,null,null,null,"2016-01-25","2016-03-10",100,"2016-03-01","2016-04-12",100,null,null,null,"2016-06-27","2016-07-18",97,"2016-07-18","2017-04-18",null,"2017-04-18","2017-07-18",null,"O'BRIENI","BRIAN KIRSCHENSTEINER","-","-","-","-","O'BRIENI","-","-",null,"DICLEMENTE SIEGEL DESIGN INC","IPF","DB - DESIGN BUILD"]
["CP15256","CLINICAL CENTER-CLINIC - RADIOPHARMACEUTICAL FRIB INSTALLATION","SUBSTCOMP","239,812",239812,227247,null,null,null,"2015-10-16","2015-11-30",null,"2016-05-02","2016-07-11",null,"2016-07-11","2016-07-25",null,"2016-08-12","2016-10-31",100,"2016-10-31","2016-12-31",100,"2016-12-31","2017-12-31",100,"WILSONT","BRYAN N HARRIS","KASDORFJ","-","WAHLT","LEFEVREJ","HOPPERS","HOWARDK","WILSONT","EARLINE SOLOMON","SITE DESIGN SOLUTIONS LLC","MOORE-TROSPER CONSTRUCTION CO","GC - DESIGN BID & BUILD"]
["CP18008","LIFE SCIENCE - ALTERATIONS TO LABS B234 AND B238","IN DES","500,000",500000,0,null,null,null,"2018-01-11","2018-02-25",100,"2018-02-26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHARLANDB","JUDE DYE","CHARLANDB","-","-","-","HOPPERS","-","KRAMERN"]
["CP13266","DUFFY DAUGHERTY - IMPLEMENT ENERGY CONSERVATION MEASURES","RELCON","35,800",66000,31704,null,null,null,null,null,null,"2013-09-26","2015-08-21",100,null,null,null,"2017-08-08","2018-04-22",80,"2018-04-22","2019-01-22",null,"2019-01-22","2019-04-22",null,"FRANCISD","DAN BOLLMAN","-","-","-","-","GOERGES","BONKJ","SEDDOND",null,"IPF","IPF","DB - DESIGN BUILD"]
["CP02033","CONSTRUCTION STANDARDS","STUDY",null,0,39100,null,null,null,null,null,null,"2016-05-16","2018-12-10",null,null,null,null,null,null,null,null,null,null,null,null,null,"HOPPERS","R NESTLE","-","-","-","-","HOPPERS","-","-",null,null,null,"TBD - TO BE DETERMINED"]
["CP14071","BIOMEDICAL PHYSICAL SCIENCES - ENERGY, CONTROLS AND INSULATION REPAIRS","RELCON","244,655",244655,272056,null,null,null,null,null,null,"2014-03-03","2015-03-20",100,null,null,null,"2015-05-01","2016-02-01",61,"2016-02-01","2016-11-01",null,"2016-11-01","2017-02-01",null,"FRANCISD","DAN BOLLMAN","-","-","-","-","FRANCISD","-","SEDDOND",null,"IPF","IPF","DB - DESIGN BUILD"]
["CP15217","KELLOGG CENTER - ALTERATIONS TO ROOMS 61, 62 AND CORNICHE ROOM","SUBSTCOMP","530,000",530000,489092,null,null,null,null,null,null,"2015-09-09","2015-09-15",null,"2015-10-07","2015-10-22",100,"2015-12-01","2016-02-29",99,"2016-02-29","2017-02-28",100,"2017-02-28","2017-05-31",null,"DURKINK","REBECCA SELESKY","-","-","-","-","-","-","VANZEEJ","LAURIE BRINKER","IPF","LAUX CONSTRUCTION COMPANY","GC - DESIGN BID & BUILD"]
["CP15250","IM SPORTS-WEST - REPLACE POOL AND LOCKER ROOM HVAC SYSTEMS","SUBSTCOMP","3,995,000",3995000,3527000,null,null,null,null,null,null,"2015-10-06","2016-08-25",100,"2016-11-21","2016-11-30",100,"2017-05-08","2017-09-22",97,"2017-09-25","2018-06-25",null,"2018-06-25","2018-09-25",null,"HOPPERS","LYNDA BOOMER","-","-","WAHL","LEFEVREJ","HOPPERS/ANDERSONB","BONKJ","COOLC","ROBIN MCVAY","PETER BASSO ASSOCIATES INC","LAUX CONSTRUCTION COMPANY","GC - DESIGN BID & BUILD"]
["CP14219","TB SIMON POWER PLANT - NATURAL GAS METER STAND REPLACEMENT","SUBSTCOMP","990,000",990000,630111,null,null,null,null,null,null,"2014-07-16","2015-07-31",100,null,null,null,"2015-07-31","2015-12-31",99,"2015-12-31","2018-03-31",null,"2018-03-31","2018-06-30",null,"BARNESC","DAN BOLLMAN","-","-","WILBERD","-","-","FRAZEER","BARNESC","ROBIN MCVAY","CONSUMERS ENERGY","CONSUMERS ENERGY","CM - CONSTRUCTION MANAGER"]
["CP14331","KELLOGG CENTER - UPGRADE CHILLED WATER SYSTEM CONTROLS","RELCON","180,000",180000,58444,null,null,null,null,null,null,"2014-10-23","2018-01-17",100,null,null,null,"2018-02-01","2019-04-05",0,"2019-04-05","2020-01-05",null,"2019-01-01","2019-04-01",null,"ANDERSONB","LYNDA BOOMER","-","-","-","-","ANDERSONB","-","ANDERSONB",null,"EAS",null,"GC - DESIGN BID & BUILD"]
["CP15282","STEAM DISTRIBUTION - REPLACE DETERIORATED CONDENSATE RETURN ANCHOR AND PIPING IN VAULT 258 (BRESLIN)","RELCON","520,000",520000,223926,null,null,null,null,null,null,"2015-10-29","2017-02-01",100,"2017-02-01","2017-02-16",100,"2017-03-30","2017-07-21",70,"2017-07-21","2018-04-21",null,"2018-07-21","2018-07-21",null,"GARDNERM","LYNDA BOOMER","-","-","KINNEYD","GARDNERM","GARDNERM","-","VANZEEJ","LAURIE BRINKER","FISHBECK, THOMPSON, CARR & HUBER","GUNTHORPE PLUMBING & HEATING INC","DB - DESIGN BUILD"]
["CP14169","KELLOGG CENTER - FIRST FLOOR MASTER PLAN","STUDY",null,228255,221535,null,null,null,null,null,null,"2014-06-03","2016-04-30",null,null,null,null,null,null,null,null,null,null,null,null,null,"DURKINK","BILL WHITBECK","-","-","-","-","-","-","DURKINK","LAURIE BRINKER","BERNATH-COAKLEY ASSOC ARCHITECT INC","-","TBD - TO BE DETERMINED"]
["CP16247","MSU FCU - CRESCENT ROAD - ALTERATIONS TO THE ELECTRICAL SYSTEM","IN DES",null,null,null,null,null,null,null,null,null,"2016-08-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BEACHK","ANNETTE CAWLEY","-","-","-","-","-","BEACHK","-","LAURIE BRINKER",null,null,"TBD - TO BE DETERMINED"]
["CP17070","HUBBARD HALL - ALTERATIONS TO NORTH PASSENGER ELEVATORS","OUTBID","830,000",830000,192,null,null,null,"2017-04-10","2017-05-25",100,"2017-11-30","2017-12-08",100,"2017-12-08","2018-01-18",100,"2018-05-07","2018-11-23",null,"2018-11-23","2019-08-23",null,"2019-08-23","2019-11-23",null,"KASDORFJ","BILL WHITBECK","KASDORFJ","-","-","-","-","-","COOLC","LAURIE BRINKER",null,null,"GC - DESIGN BID & BUILD"]
["CP11243","BIO ENGINEERING FACILITY - CONSTRUCT ORIGINAL BUILDING","SUBSTCOMP","71,800,000",71800000,68097920,null,null,null,null,null,null,"2011-09-19","2013-12-01",null,null,null,null,"2013-07-10","2015-10-30",97,"2015-10-30","2016-07-30",null,"2016-07-30","2016-10-30",null,"GOTTSCHALK","JEFF KASDORF","KASDORFJ","WHITBECKD","WILBERD","-","O'BRIENI","FRAZEER","O'BRIENI","JANNENE ANDREWS","INTEGRATED DESIGN SOLUTIONS","CLARK CONSTRUCTION COMPANY","CM - CONSTRUCTION MANAGER"]
["CP17120","BRESLIN - REPLACE PRACTICE FLOOR","SUBSTCOMP","399,223",399223,374793,null,null,null,null,null,null,"2017-05-01","2017-07-05",100,"2017-05-01","2017-05-23",100,"2017-07-05","2017-08-31",97,"2017-09-04","2017-09-04",null,"2018-05-31","2018-08-31",null,"VANZEEJ","GREG IANNI","-","-","-","-","-","-","VANZEEJ","LAURIE BRINKER","N/A","BARTON MALOW","DB - DESIGN BUILD"]
["CP15166","SEWER DISTRIBUTION - EAST LANSING CAPITAL IMPROVEMENTS","STUDY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEFEVREJ","LYNDA BOOMER","LEFEVREJ","-","-","GARDNERM","-","-","-",null,"IPF","-","TBD - TO BE DETERMINED"]
["CP16101","PLANT BIOLOGY - ALTERATIONS TO ROOMS 362, 363 AND 364","SUBSTCOMP","440,000",482000,482524,null,null,null,"2016-03-25","2016-05-09",null,"2016-10-05","2017-01-05",100,null,null,null,"2017-02-27","2017-05-30",98,"2017-05-30","2018-03-01",null,"2018-03-01","2018-05-30",null,"HOPPERS","TRACEY BARNER","PRIDEM","WHITBECKD","-","-","ANDERSONB","-","KRAMERN","LAURIE BRINKER","TMP ASSOCIATES INC","NIELSEN COML CONSTRUCTION CO INC","DB - DESIGN BUILD"]
["CP15015","SPARTAN STADIUM - INSTALLATION OF PERMANENT FIELD LIGHTING","SUBSTCOMP","2,500,000",2050001,2022311,null,null,null,"2015-01-19","2015-06-30",100,"2016-02-05","2016-07-29",100,"2016-07-29","2016-08-29",null,"2017-02-20","2017-07-28",97,"2017-07-28","2018-04-28",null,"2018-04-28","2018-07-28",null,"BONKJ","LINDA BAUGHMAN","-","-","WAHLT","LEFEVREJ","-","BONKJ","VANZEEJ","ROBIN MCVAY","IPF","BARTON MALOW COMPANY","DB - DESIGN BUILD"]
["CP15065","MSU SCENE SHOP - PERFORMING ARTS TEACHING LABORATORY - CONSTRUCT ORIGINAL BUILDING","SUBSTCOMP","2,512,910",2512910,2342659,null,null,null,null,null,null,"2015-02-26","2015-09-30",100,"2015-07-30","2015-08-18",null,"2015-09-18","2015-12-31",97,"2016-01-11","2017-02-11",null,"2017-02-11","2017-10-31",null,"DURKINK","LISA SUDIA","GARDNERM","-","WILBERD","LEFEVREJ","FRANCISD","BEACHK","DURKINK","ROBIN MCVAY","BERNATH-COAKLEY ASSOC ARCHITECT INC","IPF","ICM - INTERNAL CONSTRUCTION MANAGER"]
["CP16159","PACKAGING - INSTALL CHEMICAL FUME HOOD IN ROOM 167","SUBSTCOMP","470,000",470000,376762,null,null,null,"2016-06-27","2016-08-11",null,"2016-08-18","2016-11-30",100,"2017-01-10","2017-02-02",100,"2017-02-13","2017-12-31",97,"2017-12-31","2018-09-30",null,"2018-09-30","2018-12-31",null,"ANDERSONB","AARON WALWORTH","-","-","-","-","ANDERSONB","-","ANDERSONB","LAURIE BRINKER","IPF","NIELSEN COML CONSTRUCTION CO INC","GC - DESIGN BID & BUILD"]
["CP16164","PLANT BIOLOGY - ALTERATIONS TO ROOMS 35 AND 35A-C","RELCON","110,000",110000,15758,null,null,null,"2016-07-11","2016-08-25",null,"2016-11-08","2017-11-30",100,null,null,null,"2017-12-11","2018-03-01",20,"2018-03-01","2018-12-01",null,"2018-12-01","2019-03-01",null,"KRAMERN","DARLENE JOHNSON","CHARLANDB","-","-","-","HOPPERS","PRIDEM","KRAMERN",null,null,"IPF","DB - DESIGN BUILD"]
["CP16158","METEOROLOGIAL TOWER - DEMOLITION","IN DES","110,000",110000,0,null,null,null,"2016-06-24","2016-08-08",null,"2016-12-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WILSONT","LYNDA BOOMER","-","-","-","-","-","-","WILSONT",null,null,null,"TBD - TO BE DETERMINED"]
["CP17140","FOOD SCIENCE - ALTERATIONS TO ROOMS 124, 124A-F, 124J, 217 AND 217A-W","IN DES","3,800,000",3800000,16158,null,null,null,"2017-10-01","2017-12-01",100,"2018-01-06","2018-05-10",30,null,null,null,"2018-05-15","2018-12-15",0,"2018-12-15","2019-09-15",null,"2019-09-15","2019-12-15",null,"ANDERSONB","MARY WEINZWEIG","KASDORFJ","-","-","-","ANDERSONB","HOWARDK","ANDERSONB",null,null,"NIELSEN","DB - DESIGN BUILD"]
["CP18000","2018-2019 CAPITAL RENEWAL","IN DES",null,null,null,null,null,null,null,null,null,"2017-08-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GARDNERM"]
["CP17043","ELECTRICAL DISTRIBUTION AND VARIOUS BUILDINGS - 2017-2018 CAPITAL RENEWAL","STUDY",null,null,null,null,null,null,null,null,null,"2017-03-06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GARDNERM","LYNDA BOOMER","-","-","-","GARDNERM","-","-","-",null,"-","-","TBD - TO BE DETERMINED"]
["CP17103","BRIDGES - FARM LANE BRIDGE STRUCTURAL REPAIRS","IN DES",null,75000,0,null,null,null,null,null,null,"2017-05-24","2018-04-24",15,null,null,null,"2018-05-30","2018-07-30",null,"2018-07-30","2019-04-30",null,"2019-04-30","2019-07-30",null,"LEFEVREJ","LYNDA BOOMER","-","-","-","LEFEVREJ","-","-","-",null,null,null,"TBD - TO BE DETERMINED"]
["CP17192","ANTHONY HALL - RENOVATIONS TO LAB B260","RELCON","110,000",110000,13015,null,null,null,"2017-09-14","2017-10-29",100,"2017-11-28","2018-02-08",100,null,null,null,"2018-02-15","2018-05-30",5,"2018-05-30","2019-02-15",null,"2019-02-15","2019-05-30",null,"KRAMERN","JANET IRELAND","KRAMERN","-","-","-","HOPPERS","PRIDEM","KRAMERN",null,null,"IPF","TBD - TO BE DETERMINED"]
["CP17223","PARKING RAMP 5-COMM ARTS - ANNUAL MAINTENANCE 2018","IN DES",null,null,null,null,null,null,null,null,null,"2017-10-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GOTTSCHALKK","STEPHANIE O'DONNELL","-","-","-","GARDNERM","-","-","GOTTSCHALKK",null,null,null,"TBD - TO BE DETERMINED"]
["CP17236","TRANSPORTATION-OPERATIONS - CONSTRUCT ORIGINAL BUILDING","STUDY",null,null,null,null,null,null,null,null,null,"2017-11-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DURKINK",null,"-","-","WILBERD","TROTTERM","-","-","DURKINK",null,null,null,"TBD - TO BE DETERMINED"]
["CP16095","CLINICAL CENTER-CLINIC - ALTERATIONS TO ROOM E135A","SUBSTCOMP","30,000",35000,32044,null,null,null,null,null,null,"2016-03-15","2016-03-30",100,null,null,null,"2016-06-09","2016-06-30",99,"2016-06-30","2017-06-30",null,"2017-06-30","2017-09-30",null,"WILSONT","BRYAN HARRIS","WILSONT","-","-","-","-","-","WILSONT",null,"IPF","NIELSEN COML CONSTRUCTION CO INC","DB - DESIGN BUILD"]
["CP17179","PLANT BIOLOGY - ALTERATIONS TO ROOMS 264, 264A, 266 AND 266A","IN DES","390,000",390000,0,null,null,null,null,null,null,"2017-08-22","2018-04-01",50,null,null,null,null,null,null,null,null,null,null,null,null,"KRAMERN","TRACEY BARNER","KRAMERN","-","-","-","ANDERSONB","HOWARDK","KRAMERN","LAURIE BRINKER",null,null,"TBD - TO BE DETERMINED"]
["CP15108","CLINICAL CENTER-OFFICE/LAB  - RENOVATION OF THIRD FLOOR CENTER SECTION","RELCON","980,000",980000,862083,null,null,null,"2015-04-10","2015-06-25",null,"2015-09-18",null,null,null,null,null,"2016-04-18","2016-06-30",96,"2016-06-30","2016-12-31",null,"2016-12-31","2017-03-30",null,"DURKINK","AMY L BAKER","KASDORFJ","WHITBECKD","-","-","-","-","DURKINK","LAURIE BRINKER","MATRIX CONSULTING ENGINEERS INC","IPF","ICM - INTERNAL CONSTRUCTION MANAGER"]
["CP16177","HUBBARD HALL - ALTERATIONS TO SOUTH HUBBARD PASSENGER ELEVATORS","SUBSTCOMP","800,000",800000,682297,null,null,null,null,null,null,"2016-07-18","2017-03-03",100,"2017-02-16","2017-02-23",null,"2017-05-09","2017-08-11",97,"2017-08-11","2018-05-11",null,"2018-05-11","2018-08-11",null,"KASDORFJ","BILL WHITBECK","KASDORFJ","-","-","-","-","-","COOLC","LAURIE BRINKER","BERNATH-COAKLEY ASSOC ARCHITECT INC","NIELSEN COML CONSTRUCTION CO INC","DB - DESIGN BUILD"]
["CP17155","WATER DISTRIBUTION - REPLACE WATER SERVICE TO DAIRY CATTLE TEACHING & RES COMPLEX","SUBSTCOMP","255,000",255000,151772,null,null,null,null,null,null,"2017-07-25","2017-08-08",100,null,null,null,"2017-08-21","2017-11-30",97,"2017-11-30","2018-08-30",null,"2018-08-30","2018-11-30",null,"GARDNERM","LYNDA BOOMER","-","-","-","TROTTERM","GARDNERM","-","GARDNERM","LAURIE BRINKER","IPF","GRANGER CONSTRUCTION","TBD - TO BE DETERMINED"]
["CP17049","KEDZIE HALL - ALTERATIONS TO ROOM N101","STUDY",null,0,5600,null,null,null,null,null,null,"2017-03-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PENNOCKK","LISA SUDIA","PENNOCKK","-","-","LEFEVREJ","-","-","-",null,"CTRE INC/MAYOTTE GROUP ARCHITECTS","-","TBD - TO BE DETERMINED"]
["CP17152","LINTON HALL - ALTERATIONS TO ROOMS 10, 10A AND 10B","OUTBID","110,000",110000,18701,null,null,null,null,null,null,"2017-07-20","2017-11-30",75,"2017-12-08","2018-01-04",null,"2017-12-18","2018-02-28",null,"2018-02-28","2018-11-28",null,"2018-11-28","2019-02-28",null,"CHARLANDB","KATHLEEN ROGERS","CHARLANDB","-","-","-","ANDERSONB","HOWARDK","LUTKENHOFFM",null,"IPF",null,"IPF - IPF SELF-PERFORMED"]
["CP16192","VETERINARY MEDICAL CENTER - REPLACE HVAC-1 AND HVAC-21","IN DES","2,000,000",2000000,209,null,null,null,null,null,null,"2016-07-02","2019-11-30",10,null,null,null,null,null,null,null,null,null,null,null,null,"HOPPERS","LYNDA BOOMER","-","-","-","-","FRANCISD","-","-","ROBIN MCVAY",null,"-","CM - CONSTRUCTION MANAGER"]
["CP17139","LIFE SCIENCE - RENOVATIONS TO ROOM B307","OUTBID","450,000",450000,33949,null,null,null,null,null,null,"2017-09-04","2018-01-05",100,"2018-01-08","2018-01-25",50,"2018-02-19","2018-06-01",null,"2018-06-01","2019-03-01",null,"2019-03-01","2019-06-01",null,"POSTMAM","ERICA LANGE","CHARLANDB","-","-","-","ANDERSONB","HOWARDK","POSTMAM","LAURIE BRINKER","MAYOTTE/CTR"]
["CP18001","MSU COLLEGE OF LAW - REPLACE PASSENGER ELEVATORS #1 AND #2","IN DES","840,000",840000,0,null,null,null,null,null,null,"2018-01-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GOTTSCHALK","LYNDA BOOMER","KASDORFJ","-","-","-","-","HALSEYG","GOTTSCHALK",null,null,null,"TBD - TO BE DETERMINED"]
["CP17015","AKERS HALL AND VARIOUS BUILDINGS - STAIRWELL STUDY","STUDY",null,null,null,null,null,null,null,null,null,"2017-01-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KASDORFJ","BILL WHITBECK","MULLENB","-","-","-","-","-","KASDORFJ",null,"IPF","-","TBD - TO BE DETERMINED"]
["CP16264","TB SIMON POWER PLANT -  INSTALL EMERGENCY PULL STATIONS SYSTEM STUDY","STUDY",null,null,null,null,null,null,null,null,null,"2016-09-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BARNESC","BOB ELLERHORST","-","-","-","-","-","HOWARDK","BARNESC",null,"IPF","-","TBD - TO BE DETERMINED"]
["CP17199","TB SIMON POWER PLANT - INSTALL REVERSE OSMOSIS","IN DES","1,000,000",1000000,0,null,null,null,null,null,null,"2017-10-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BARNESC","LYNDA BOOMER","-","-","-","-","FRANCISD","BEACHK","BARNESC","ROBIN MCVAY",null,null,"DB - DESIGN BUILD"]
["CP16146","BRESLIN - REPLACEMENT OF LOCKERS IN MEN'S BASKETBALL LOCKER ROOM","SUBSTCOMP","635,000",635000,520656,null,null,null,null,null,null,"2016-05-27","2016-12-28",100,"2016-01-25","2016-01-25",100,"2017-05-29","2017-07-09",97,"2017-07-09","2018-04-09",null,"2018-04-09","2018-07-09",null,"VANZEEJ","GREG IANNI","KASDORFJ","-","-","-","-","BONKJ","VANZEEJ","LAURIE BRINKER","INTEGRATED DESIGN SOLUTIONS","BARTON MALOW COMPANY","CM - CONSTRUCTION MANAGER"]
["CP16224","MORRILL HALL OF AGRICULTURE - HVAC AND ALTERATIONS IN SUITES 108 AND 109","RELCON","831,000",623000,628690,null,null,null,"2016-08-09","2016-09-23",100,"2017-09-24","2018-02-09",100,"2017-02-20","2017-03-03",100,"2017-04-17","2017-07-26",98,"2017-07-25","2017-07-25",100,null,null,null,"O'BRIENI","TONIA DUMONT","-","-","-","-","-","-","O'BRIENI","LAURIE BRINKER","MATRIX CONSULTING ENGINEERS INC","LAUX CONSTRUCTION COMPANY","GC - DESIGN BID & BUILD"]
["CP15079","PARKING RAMPS 1, 2, 3, 5 & 6 - RESTORATION 2015 & 2016","SUBSTCOMP","803,000",803000,733735,null,null,null,null,null,null,"2015-03-18","2015-06-15",100,"2015-05-29","2015-06-11",null,"2015-07-09","2016-08-22",97,"2016-08-22","2017-05-22",null,"2017-05-22","2017-08-22",null,"GARDNERM","STEPHANIE O'DONNELL","-","-","-","GARDNERM","-","-","RHODESA","ROBIN MCVAY","WALKER PARKING CONSULTANTS","RAM CONSTRUCTION SERVICES OF MICH INC","GC - DESIGN BID & BUILD"]
["CP17031","STUDENT SERVICES - RENOVATION TO ROOM 147","SUBSTCOMP","28,000",28000,23135,null,null,null,null,null,null,"2017-02-15","2017-03-24",100,null,null,null,"2017-04-03","2017-04-28",99,"2017-05-01","2018-02-01",null,"2018-02-01","2018-05-01",null,"CHARLANDB","CAROL STIER","CHARLANDB","-","-","-","-","HOWARDK","GEISENHAVERD",null,"IPF","IPF","TBD - TO BE DETERMINED"]
["CP14254","BRODY HALL - REPLACE KITCHEN GREASE INTERCEPTOR","SUBSTCOMP","372,875",372875,332672,null,null,null,"2014-08-14","2014-09-28",100,"2016-09-21","2016-12-01",100,"2017-01-20","2017-02-21",null,"2017-05-08","2017-05-23",99,"2017-05-23","2018-02-23",null,"2018-02-23","2018-05-23",null,"O'BRIENI","MARK BOWLING","-","-","WAHLT","LEFEVREJ","O'BRIENI","-","O'BRIENI","LAURIE BRINKER","PETER BASSO ASSOCIATES INC","CENTRAL EXCAVATING LLC","DB - DESIGN BUILD"]
["CP13180","CLINICAL CENTER-ANIMAL - UPGRADES TO ULAR CAGE WASH AREA C124, C124A AND C132","SUBSTCOMP","830,000",830000,829021,null,null,null,"2015-02-09","2015-03-26",100,"2015-10-16","2016-01-01",100,"2016-03-20","2016-03-20",100,"2016-05-01","2017-03-30",98,"2017-03-30","2017-12-30",null,"2017-12-30","2018-03-30",null,"HOPPERS","BRIAN JESPERSEN","-","-","-","-","HOPPERS","HOWARDK","WILSONT","LAURIE BRINKER","PETER BASSO ASSOCIATES INC","CLARK CONSTRUCTION COMPANY","CM - CONSTRUCTION MANAGER"]
["CP16011","HANNAH ADMINISTRATION - ALTERATIONS TO THIRD FLOOR RESTROOMS","IN DES",null,null,null,null,null,null,null,null,null,"2016-01-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POSTMAM","LYNDA BOOMER","PENNOCKK","-","-","-","-","-","POSTMAM",null,"EAS",null,"DB - DESIGN BUILD"]
["CP17197","TB SIMON POWER PLANT- RICE - CONSTRUCT ORIGINAL BUILDING","IN DES","40,000,000",40000000,12344,null,null,null,null,null,null,"2017-10-30","2018-09-07",1,null,null,null,"2018-09-10","2019-12-31",null,"2019-12-31","2020-09-30",null,"2020-09-30","2020-12-31",null,"BARNESC","LYNDA BOOMER","-","-","WAHLT","TROTTERM","FRANCISD","BEACHK","BARNESC","ROBIN MCVAY",null,null,"DB - DESIGN BUILD"]
["CP13274","ENG RESEARCH COMPLEX - IMPLEMENT ENERGY CONSERVATION MEASURES","IN DES","683,000",683000,27234,null,null,null,null,null,null,"2013-09-26","2017-10-01",80,null,null,null,"2017-11-01","2018-04-01",0,"2018-04-01","2019-01-01",null,"2019-01-01","2019-04-01",null,"ANDERSONB","DAN BOLLMAN","-","-","-","-","ANDERSONB","ANDERSONB","ANDERSONB","ROBIN MCVAY","FISHBECK, THOMPSON, CARR & HUBER",null,"GC - DESIGN BID & BUILD"]
["CP14080","NATURAL AREAS - FLOOD RESPONSE PLAN MEASURES - KELLOGG CENTER","STUDY",null,0,1437,null,null,null,null,null,null,"2014-03-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GARDNERM","JOE PETROFF","-","-","-","TROTTERM","-","-","-",null,"IPF","-","DB - DESIGN BUILD"]
["CP14333","STUDENT SERVICES - MECHANICAL CONTROL AND LIGHTING ECM UPGRADES","RELCON","395,000",395000,50470,null,null,null,null,null,null,"2014-10-23","2016-07-15",100,null,null,null,"2016-09-01","2018-06-01",21,"2018-06-01","2019-03-01",null,"2019-03-01","2019-06-01",null,"FRANCISD","LYNDA BOOMER","-","-","-","-","GOERGES","-","GALLAGHERR","ROBIN MCVAY","DLZ MICHIGAN INC","IPF","DB - DESIGN BUILD"]
["CP17153","SPARTAN VILLAGE - COMMUNITY CNTR - UTILITY SUPPORT FOR DECOMMISSIONING","RELCON","192,100",192100,110158,null,null,null,null,null,null,"2017-07-24","2017-10-01",100,null,null,null,"2017-10-15","2018-06-01",50,"2018-06-01","2019-03-01",null,"2019-03-01","2019-06-01",null,"TROTTERM","BILL WHITBECK","DURKINK","-","-","TROTTERM","TROTTERM","-","TROTTERM",null,"IPF - SELF PERFORMED","IPF","IPF - IPF SELF-PERFORMED"]
["CP17217","KELLOGG CENTER - ALTERATIONS TO ROOMS 125B-D","RELCON","150,006",150006,4348,null,null,null,null,null,null,"2017-10-16","2017-12-01",100,null,null,null,"2017-12-21","2018-03-30",70,"2018-03-30","2018-12-21",null,"2018-12-21","2019-03-30",null,"DURKINK","REBECCA SELESKY","-","-","-","-","-","-","VANZEEJ","EARLINE SOLOMON","BERNATH COAKLEY","NIELSEN COML CONSTRUCTION CO I","ICM - INTERNAL CONSTRUCTION MANAGER"]
["CP16105","COOK HALL & VARIOUS BLDGS - ACCESSIBILITY MODIFICATIONS","STUDY",null,null,null,null,null,null,null,null,null,"2016-03-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PENNOCKK","LYNDA BOOMER","PENNOCKK","-","KINNEYD","-","-","-","RHODESA",null,"IPF","-","TBD - TO BE DETERMINED"]
["CP16239","ERICKSON HALL - ALTERATIONS TO SUITES 114 AND 118","IN DES","550,000",132000,8599,null,null,null,"2016-08-23","2017-06-02",100,"2017-04-17","2018-04-27",25,null,null,null,null,null,null,null,null,null,null,null,null,"WILSONT","JAKE LATHROP","CHARLANDB","-","-","-","GOERGES","HALSEYG","WILSONT","LAURIE BRINKER","-",null,"DB - DESIGN BUILD"]
["CP17115","PATHWAYS - SERVICE ROAD - CONNECT SIDEWALK TO NORTH SIDE OF HAGADORN INTERSECTION","SUBSTCOMP","100,000",100000,70596,null,null,null,null,null,null,"2017-04-18","2017-04-25",100,null,null,null,"2017-05-08","2017-06-05",97,"2017-06-05","2017-09-05",null,"2017-09-05","2017-12-05",null,"WILBERD","LYNDA BOOMER","-","-","WILBERD","-","-","-","-",null,null,null,"TBD - TO BE DETERMINED"]
["CP17059","BIOMEDICAL PHYSICAL SCIENCES - ALTERATIONS TO ROOM B108","IN DES",null,0,8509,null,null,null,"2017-03-27","2017-06-30",100,"2017-06-13","2018-02-08",95,null,null,null,"2018-04-02","2018-08-15",null,"2018-08-15","2019-05-15",null,"2019-05-15","2019-08-15",null,"KRAMERN","MARC CONLIN","KRAMERN","-","-","-","HOPPERS","PRIDEM","KRAMERN","LAURIE BRINKER","PETER BASSO ASSOCIATES INC",null,"TBD - TO BE DETERMINED"]
["CP17123","RADIOLOGY - ALTERATIONS TO ROOMS D117, D118, D119, D120 AND D121","IN DES","462,000",0,1099,null,null,null,null,null,null,"2017-06-12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WILSONT","COLLEEN HAMMOND","KASDORFJ","-","-","-","HOPPERS","HALSEYG","WILSONT","LAURIE BRINKER","C2AE","TBD","GC - DESIGN BID & BUILD"]
["CP16210","SPARTAN STADIUM - STRUCTURAL INSPECTION 2016-17","IN DES",null,0,0,null,null,null,null,null,null,"2016-08-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GARDNERM","LINDA BAUGHMAN","-","-","-","GARDNERM","-","-","GARDNERM",null,null,null,"DB - DESIGN BUILD"]
["CP16171","VETERINARY MEDICAL CENTER - ALTERATIONS TO ROOM E100 AND CORRIDOR","SUBSTCOMP","1,500,000",1500000,1053594,null,null,null,null,null,null,"2016-07-12","2017-02-28",null,null,null,null,"2017-03-22","2017-08-04",97,"2017-08-04","2018-05-04",null,"2018-05-04","2018-08-04",null,"GOTTSCHALK","LISA SUDIA","PENNOCKK","LOCKWOODC","-","-","-","KLANND","GOTTSCHALK","LAURIE BRINKER","MAYOTTE GROUP ARCHITECTS","GRANGER CONSTRUCTION CO","CM - CONSTRUCTION MANAGER"]
["CP16170","WELLS HALL - ALTERATIONS TO ROOM B122","SUBSTCOMP","80,000",80000,64249,null,null,null,null,null,null,"2016-07-12","2017-04-17",100,null,null,null,"2017-05-31","2017-07-20",97,"2017-07-20","2018-04-30",null,"2018-04-30","2018-07-20",null,"KLANND","LISA SUDIA","-","LOCKWOODC","-","-","-","KLANND","-","EARLINE SOLOMON","SOUNDSCAPE ENGINEERING LLC","IPF","DB - DESIGN BUILD"]
["CP14270","FOUNTAINS AND POOLS - RENOVATIONS TO FOUNTAIN AND PLAZA","STUDY",null,null,null,null,null,null,null,null,null,"2014-08-27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KINNEYD","KERRY GERNERT","-","-","KINNEYD","-","-","-","-",null,"IPF","-","TBD - TO BE DETERMINED"]
["CP16145","CLINICAL CENTER-OFFICE/LAB - INSTALL DATA AND ELECTRICAL ON SECOND FLOOR","IN DES",null,0,8945,null,null,null,null,null,null,"2016-05-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DURKINK","RON PRANICA","-","-","-","-","-","-","DURKINK",null,null,"IPF","ICM - INTERNAL CONSTRUCTION MANAGER"]
["CP16204","ROADS - TROWBRIDGE ROAD - REPAVING HARRISON RD. TO OYER","SUBSTCOMP","940,000",940000,797810,null,null,null,null,null,null,"2016-07-27","2017-06-02",100,"2017-01-17","2017-02-09",null,"2017-06-05","2017-07-28",97,null,null,null,"2017-10-27","2018-01-31",null,"WAHLT","LYNDA BOOMER","-","-","WAHLT","LEFEVRE","-","-","WAHLT","ROBIN MCVAY","IPF","MICHIGAN PAVING & MATERIALS","GC - DESIGN BID & BUILD"]
["CP16166","FARRALL HALL - ALTERATIONS TO ROOM 116","SUBSTCOMP","350,000",360000,255478,null,null,null,null,null,null,"2016-07-11","2017-04-17",100,null,null,0,"2017-04-27","2017-08-04",97,"2017-08-04","2018-05-04",null,"2018-05-04","2018-08-04",null,"ANDERSONB","LISA SUDIA","-","-","-","-","ANDERSONB","HOWARDK","ANDERSONB","LAURIE BRINKER","DEE CRAMER INC","IPF","IPF - IPF SELF-PERFORMED"]
["CP17095","SNYDER PHILLIPS HALL  - REPLACE GREASE TRAP","IN DES","450,000",450000,4050,null,null,null,"2017-05-17","2017-07-31",100,"2017-10-12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"O'BRIENI","SUE BRANDT",null,"-","WAHLT","TROTTERM","FRANCISD",null,"O'BRIENI",null,null,null,"TBD - TO BE DETERMINED"]
["CP12132","ELECTRICAL DISTRIBUTION - FRIB - 25MW ELECTRICAL DUCT BANK","RELCON","26,000,000",26000000,3107606,null,null,null,null,null,null,null,null,null,"2013-04-12","2013-04-12",null,"2013-05-06","2016-09-30",75,"2016-09-30","2016-09-30",null,"2016-12-16","2016-12-16",null,"BULLB","B. BULL",null,null,null,null,"NGUYENP","FRAZEER",null,null,"SMITHGROUP/JJR","BARTON MALOW","CM - CONSTRUCTION MANAGER"]
["CP17080","STREET LIGHT DISTRIBUTION - UPGRADE PARKING LOTS 83, 89, 91, 92 AND 100 TO LED","IN DES","450,000",450000,450000,null,null,null,null,null,null,"2017-04-27","2018-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,"BARNESC","LYNDA BOOMER","BARNESC","-","-","-","-","BEACHK","BARNESC","LAURIE BRINKER",null,"IPF","CM - CONSTRUCTION MANAGER"]
["CP17117","WATER DISTRIBUTION - REPLACE CAST IRON WATER MAIN ADJACENT TO BUSINESS COLLEGE","SUBSTCOMP","250,000",250000,190363,null,null,null,null,null,null,"2017-05-30","2017-09-01",100,null,null,null,"2017-10-01","2017-11-01",97,"2017-11-02","2018-07-01",null,"2018-07-02","2018-10-02",null,"ABDEL-AZIM","LYNDA BOOMER","ABDEL-AZIM","-","KINNEYD","TROTTERM","HOPPER/ANDERSON","BEACHK","RHODESA","ROBIN MCVAY","FISHBECK, THOMPSON, CARR & HUBER","CLARK CONSTRUCTION COMPANY","CM - CONSTRUCTION MANAGER"]
["CP15240","FEE HALL - REPLACEMENT OF AIR HANDLER 2ES","SUBSTCOMP","780,275",780275,763256,null,null,null,null,null,null,"2015-10-02","2016-06-01",100,"2016-06-03","2016-06-14",100,"2016-09-06","2018-02-28",97,"2018-02-28","2018-11-28",null,"2018-11-28","2019-02-28",null,"ANDERSONB","LYNDA BOOMER","-","-","-","-","ANDERSONB","-","ANDERSONB","LAURIE BRINKER","MATRIX CONSULTING ENGINEERS INC","NIELSEN COML CONSTRUCTION CO INC","DB - DESIGN BUILD"]
["CP18016","CHM-FLINT - RENOVATE CAPITAL THEATRE LEASE SPACE","IN DES","500,000",0,0,null,null,null,null,null,null,"2018-01-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEMPLER","BRIAN JESPERSEN","-","-",null,"-","-","-","TEMPLER",null,"GAZALL, LEWIS & ASSOCIATES","SORENSEN GROSS CONSTRUCTION","TBD - TO BE DETERMINED"]
["CP13307","PLANTING - CAMPUS TREE RENEWAL FUND - FRIB","RELCON","160,000",160000,107196,null,null,null,null,null,null,"2013-11-05","2015-09-25",50,null,null,null,"2014-05-01","2018-11-30",60,null,null,null,"2019-08-30","2019-11-30",null,"WAHLT","LYNDA BOOMER","-","-","WAHLT","-","-","-","LAWVERA",null,"IPF","IPF","DB - DESIGN BUILD"]
["CP14036","MUSEUM - HVAC ALTERATIONS TO SUITE 26","IN DES","40,000",40000,0,null,null,null,"2014-02-06","2014-06-15",100,"2017-08-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANDERSONB","MICHAEL SECORD",null,"-","-","-","ANDERSONB","HOWARDK","ANDERSONB"]
["CP14069","BESSEY - ENERGY, CONTROLS AND VFD CONVERSIONS","SUBSTCOMP","262,000",262000,166397,null,null,null,null,null,null,"2014-03-03","2016-04-15",100,null,null,null,"2016-08-01","2017-10-01",97,"2017-10-01","2018-07-01",null,"2018-07-01","2018-10-01",null,"FRANCISD","DAN BOLLMAN","-","-","-","-","GOERGES","-","GALLAGHERR","ROBIN MCVAY","DLZ MICHIGAN INC","IPF","DB - DESIGN BUILD"]
["CP17171","ART AND MONUMENTS - CONSTRUCT COLUMBARIUM AT ALUMNI CHAPEL","STUDY",null,null,null,null,null,null,null,null,null,"2017-12-11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RHODESA","JANE MILLER","KASDORF",null,"KINNEYD",null,null,null,"RHODESA",null,null,null,"TBD - TO BE DETERMINED"]
["CP17173","ELECTRICAL DISTRIBUTION - INSTALL LIGHTED CROSSWALK SIGN AT PARKING LOT 63W BRESLIN","IN DES",null,null,null,null,null,null,null,null,null,"2017-08-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VANZEEJ","STEPHANIE O'DONNELL","-","-","KINNEYD","LEFEVREJ","-","-","VANZEEJ"]
["CP16269","FOOD SCIENCE - UPGRADE LIGHTING AND FINISHES IN LAB 227","SUBSTCOMP","115,000",129000,124984,null,null,null,"2016-09-28","2016-11-12",100,"2017-05-17","2017-08-09",100,null,null,null,"2017-09-15","2017-11-15",97,"2017-11-15","2018-08-15",null,"2018-08-15","2018-11-15",null,"KRAMERN","JIM PETSKA","CHARLANDB","-","-","-","HOPPERS","PRIDEM","KRAMERN","EARLINE SOLOMON","IPF / ENGINEERING APPLICATIONS INC","NIELSEN COML CONSTRUCTION CO INC","ICM - INTERNAL CONSTRUCTION MANAGER"]
["CP16272","GILTNER HALL - ALTERATIONS TO ROOMS 153 AND 153A","SUBSTCOMP","135,000",135000,132162,null,null,null,"2016-10-04","2017-04-07",100,"2017-04-14","2017-06-01",100,null,null,null,"2017-08-09","2017-08-31",98,"2017-08-31","2018-05-30",null,"2018-05-30","2018-08-30",null,"PRIDEM","DEBRA MILLS","CHARLANDB","WHITBECKD","-","-","GOERGES","PRIDEM","KRAMERN","EARLINE SOLOMON","IPF","NIELSEN CONSTRUCTION","DB - DESIGN BUILD"]
["CP15226","DUFFY DAUGHERTY-SAAC - REPLACE LIGHTS AT INDOOR PRACTICE BUILDING","RELCON","400,000",400000,335275,null,null,null,null,null,null,"2015-09-21","2016-12-09",100,null,null,null,"2017-01-01","2017-07-01",95,"2017-07-01","2018-04-01",null,"2018-04-01","2018-07-01",null,"HOWARDK","GREG IANNI","-","-","-","-","-","HOWARDK","IPF","LAURIE BRINKER","IPF","IPF","DB - DESIGN BUILD"]
["CP17224","PARKING RAMP 6-GRAND RIVER - ANNUAL MAINTENANCE 2018","IN DES",null,null,null,null,null,null,null,null,null,"2017-10-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GOTTSCHALKK","STEPHANIE O'DONNELL","-","-","-","GARDNERM","-","-","GOTTSCHALKK",null,null,null,"TBD - TO BE DETERMINED"]
["CP16055","DEMONSTRATION HALL - BARRIER FREE RESTROOMS ON FIRST FLOOR","RELCON","225,000",225000,194296,null,null,null,null,null,null,"2016-02-09","2016-08-31",100,null,null,null,"2016-07-23","2018-03-30",70,"2018-03-30","2018-06-30",null,"2018-06-30","2019-03-30",null,"GOTTSCHALK","KERRY GERNERT","PENNOCKK","LOCKWOODC","-","-","HOPPERS","BEACHK","GOTTSCHALK","EARLINE SOLOMON","BERNATH-COAKLEY ASSOC ARCHITECT INC","NIELSEN COML CONSTRUCTION CO INC","GC - DESIGN BID & BUILD"]
["CP16221","STEAM DISTRIBUTION - 16-17 MAJOR REPAIRS TO CAMPUS STEAM TUNNEL PIPE SUPPORTS AND ANCHORS","RELCON","510,000",510000,147445,null,null,null,null,null,null,"2016-08-04","2017-08-30",15,"2017-06-12","2017-06-30",null,"2017-05-08","2018-08-30",40,"2018-08-30","2019-05-30",null,"2019-05-30","2019-08-30",null,"GARDNERM","LYNDA BOOMER","-","-","-","TROTTERM","GARDNERM","-","GARDNERM","LAURIE BRINKER","IPF","GRANGER CONSTRUCTION CO","DB - DESIGN BUILD"]
["CP18040","NATURAL SCIENCE - ALTERATIONS TO BUILDING ENTRANCES","STUDY",null,null,null,null,null,null,null,null,null,"2018-02-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KASDORFJ","CHELSEA LITWILLER","KASDORFJ","-","-","LEFEVREJ","-","-","-",null,null,null,"TBD - TO BE DETERMINED"]
["CP16345","HUBBARD HALL - REPLACE DOMESTIC COLD WATER PIPING","RELCON","550,000",550000,1085,null,null,null,"2017-01-04","2017-02-18",100,"2017-12-07","2018-01-07",100,"2018-01-24","2018-02-08",100,"2018-05-07","2018-08-17",0,"2018-08-17","2019-05-17",null,"2019-05-17","2019-08-17",null,"ANDERSONB","SUE BRANDT","ANDERSONB","-","-","-","ANDERSONB","ANDERSONB","ANDERSONB","LAURIE BRINKER",null,"NIELSEN","GC - DESIGN BID & BUILD"]
["CP16295","PARKING RAMP 1-SHAW LANE AND VARIOUS BUILDINGS - RAMPS 1, 2, 3 & 6 RESTORATION  2017","SUBSTCOMP","395,807",395807,281537,null,null,null,null,null,null,"2016-11-03","2017-03-01",100,"2017-03-14","2017-03-28",null,"2017-05-08","2017-08-04",97,"2017-08-04","2018-05-04",null,"2018-05-04","2018-08-04",null,"RHODESA","STEPHANIE O'DONNELL","-","-","-","GARDNERM","-","-","RHODESA","LAURIE BRINKER","WALKER PARKING CONSULTANTS","D C BYERS COMPANY","DB - DESIGN BUILD"]
["CP14012","NATURAL RESOURCES - HVAC ALTERATIONS IN ROOMS 168 AND 169","SUBSTCOMP","155,000",155000,119756,null,null,null,"2014-01-27","2014-09-30",100,"2016-01-15","2016-04-15",100,null,null,null,"2016-06-20","2016-08-15",97,"2016-08-15","2017-05-15",null,"2017-05-15","2017-08-15",null,"O'BRIENI","JULI KERR","-","-","-","-","FRANCISD","-","-",null,"WILLIAM A KIBBE & ASSOCIATES INC","JOHN E GREEN COMPANY","DB - DESIGN BUILD"]
["CP16004","LIBRARY - REPLACE EXTERIOR DOORS TO MAIN CORRIDOR AND SOUTH CONNECTOR EXTERIOR WINDOWS","SUBSTCOMP","120,000",135000,100565,null,null,null,"2016-01-08","2016-02-22",100,"2016-04-19","2016-05-10",100,null,null,null,"2016-06-01","2016-08-15",97,"2016-08-15","2017-05-15",100,"2017-05-15","2018-08-15",null,"KASDORFJ","JIM HENSLEY","KASDORFJ","-","-","-","-","-","-",null,"IPF","IPF","DB - DESIGN BUILD"]
["CP13252","SEWER DISTRIBUTION SYSTEM - STORM SANITARY SEWER SYSTEM MODIFICATIONS (PHASES I &2)","RELCON","600,000",600000,615035,null,null,null,null,null,null,"2013-09-16","2014-03-07",100,null,null,null,"2013-09-16","2018-12-31",85,"2018-12-31","2019-09-30",null,"2019-09-30","2019-12-31",null,"LEFEVREJ","DAN BOLLMAN","-","-","-","LEFEVREJ","-","-","LEFEVREJ",null,"IPF","IPF","GC - DESIGN BID & BUILD"]
["CP14086","CONSTRUCTION STANDARDS REVIEW - 2014","STUDY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOOMERL",null,"-","-","-","-","-","-","-",null,"-","-","TBD - TO BE DETERMINED"]
["CP17048","MANLY MILES - RENOVATION TO ROOM 15 AND 15A","SUBSTCOMP","146,000",146000,114180,null,null,null,"2017-03-16","2017-04-30",100,"2017-04-17","2017-07-01",100,"2017-07-01","2017-08-01",null,"2017-08-01","2017-09-01",97,"2017-09-01","2017-12-01",null,"2017-12-01","2018-03-01",null,"WILSONT","JAKE LATHROP","CHARLANDB","LOCKWOODC","-","-","-","HOWARDK","WILSONT","EARLINE SOLOMON","IPF","NIELSEN CONSTRUCTION","DB - DESIGN BUILD"]
["CP17208","ENGINEERING - ALTERATIONS TO ROOMS 2243, 2245 AND 2250","IN DES","285,000",285000,317,null,null,null,null,null,null,"2017-10-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KLANND","LISA SUDIA","-","LOCKWOODC","-","-","-","KLANND",null,"LAURIE BRINKER",null,"IPF","TBD - TO BE DETERMINED"]
["CP17042","FEE HALL - RENOVATIONS TO ROOMS A307, A308 AND A309","SUBSTCOMP","22,000",22000,25511,null,null,null,"2017-03-02","2017-05-01",100,"2017-05-02","2017-05-25",100,null,null,null,"2017-08-21","2017-09-30",99,"2017-09-30","2018-06-30",null,"2018-06-30","2018-09-30",null,"CHARLANDB","JESSSELYN NELSON","CHARLANDB","-","-","-","GOERGES","HOWARDK","-","EARLINE SOLOMON","IPF","IPF","IPF - IPF SELF-PERFORMED"]
["CP18038","CHEMISTRY - ALTERATIONS TO ROOMS 221, 223 AND 224A","IN DES","750,000",null,null,null,null,null,null,null,null,"2018-02-07",null,50,null,null,null,null,null,null,null,null,null,null,null,null,"KRAMERN","DALTON HARDISTY","KRAMERN","-","-","-","HOPPERS","PRIDEM","KRAMERN"]
["CP16234","NISBET - RENOVATE ROOM 327","RELCON","55,000",55000,24627,null,null,null,"2016-08-18","2016-10-02",100,"2017-10-19","2017-12-15",100,null,null,null,"2018-01-08","2018-03-09",10,"2018-03-10","2018-12-10",null,"2018-12-10","2019-03-10",null,"CHARLANDB","TERESA BULOCK","CHARLANDB","-","-","-","GOERGES","HOWARDK","LUTKENHOFFM",null,"IPF","IPF","IPF - IPF SELF-PERFORMED"]
["CP18034","TB SIMON POWER PLANT - SITE MODIFICATIONS","STUDY",null,null,null,null,null,null,null,null,null,"2018-01-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BARNESC","BOB ELLERHORST","-",null,"WAHLT",null,"-","-","BARNESC",null,null,null,"TBD - TO BE DETERMINED"]
["CP17055","ENGINEERING - ALTERATIONS TO ROOM 2553","SUBSTCOMP","65,000",65000,42879,null,null,null,"2017-03-27","2017-05-11",null,"2017-06-14","2017-07-07",100,null,null,null,"2017-07-12","2017-08-18",97,"2017-08-18","2018-05-18",null,"2018-05-18","2018-08-18",null,"GOERGES","LINDSAY BURNS","-","LOCKWOODC","-","-","GOERGES","HOWARDK","GOERGES",null,"IPF","IPF/GUNTHORPE/LAKE STATE/INTEGRITY INTERIORS","TBD - TO BE DETERMINED"]
["CP17066","PLANT BIOLOGY - ALTERATIONS TO SUITE 239","RELCON","325,000",325000,28479,null,null,null,"2017-04-06","2017-05-21",100,"2017-07-31","2017-11-30",100,null,null,null,"2017-12-15","2018-02-28",40,"2018-02-28","2018-11-28",null,"2018-11-28","2019-02-28",null,"KRAMERN","TRACEY BARNER","KRAMERN","-","-","-","ANDERSONB","HOWARDK","KRAMERN","LAURIE BRINKER",null,"IPF","TBD - TO BE DETERMINED"]
["CP17110","HORSE RESEARCH- ARENA AND BARN - REPLACE ALL ROOFS","OUTBID","524,000",524000,92,null,null,null,null,null,null,"2017-05-24","2018-01-31",100,"2017-12-20","2018-01-23",null,"2018-04-09","2018-07-09",null,"2018-07-09","2019-04-09",null,"2019-04-09","2019-07-09",null,"CHARLANDB","LYNDA BOOMER","CHARLANDB","-","-","-","-","-","CHARLANDB","LAURIE BRINKER","IPF",null,"GC - DESIGN BID & BUILD"]
["CP14263","ENGINEERING - IMPLEMENT ENERGY CONSERVATION MEASURES","SUBSTCOMP","591,000",591000,538914,null,null,null,null,null,null,"2014-08-22","2016-04-01",100,null,null,null,"2017-03-01","2017-11-10",97,"2017-11-10","2018-08-10",null,"2018-08-10","2018-11-10",null,"FRANCISD","JEFF CURTISS","-","-","-","-","FRANCISD","-","GALLAGHERR","ROBIN MCVAY","PETER BASSO ASSOCIATES INC","IPF","GC - DESIGN BID & BUILD"]
["CP17135","CASE HALL - 17-18 ENERGY CONSERVATION MEASURES","IN DES","250,000",250000,27076,null,null,null,null,null,null,"2017-07-06",null,7,null,null,null,null,null,null,null,null,null,null,null,null,"FRANCISD","JASON VALLANCE","-","-","-","-","FRANCISD","-","SEDDOND","LAURIE BRINKER",null,null,"TBD - TO BE DETERMINED"]
["CP12380","STEAM DISTRIBUTION - EAST CAMPUS - MISCELLANEOUS REPAIRS -2014","RELCON","500,000",500000,441682,null,null,null,null,null,null,"2014-01-17","2016-04-16",50,null,null,null,"2016-05-01","2017-06-30",null,"2017-06-30","2018-03-30",null,"2018-03-30","2018-06-30",null,"GARDNERM","SCOTT GARDNER","LEFEVREJ","-","WILBERD","TROTTERM","GARDNERM","-","GARDNERM","ROBIN MCVAY","FISHBECK, THOMPSON, CARR & HUBER","PROJECT SERVICES","GC - DESIGN BID & BUILD"]
["CP13271","FOOD SCIENCE - IMPLEMENT ENERGY CONSERVATION MEASURES","RELCON","589,000",589000,429698,null,null,null,null,null,null,"2013-09-26","2015-10-09",100,"2016-05-25","2016-06-09",null,"2016-06-30","2018-12-01",95,"2018-12-01","2019-09-01",null,"2019-09-01","2019-12-01",null,"ANDERSONB","DAN BOLLMAN","-","-","-","-","ANDERSONB","-","ANDERSONB","ROBIN MCVAY","IPF","LAUX CONSTRUCTION COMPANY","GC - DESIGN BID & BUILD"]
["CP17112","BIOCHEMISTRY - UPGRADE PCB TRANSFORMERS AND ELECTRICAL EQUIPMENT","IN DES","950,000",950000,0,null,null,null,null,null,null,"2017-05-25","2018-01-30",1,null,null,null,"2019-04-30","2019-09-01",null,"2019-09-01","2019-12-30",null,"2019-12-30","2020-01-30",null,"BONKJ","LYNDA BOOMER","-","-","-","-","-","BEACHK","-","ROBIN MCVAY",null,null,"TBD - TO BE DETERMINED"]
["CP16091","TB SIMON POWER PLANT - ALTERATIONS TO ROOM 108, BREAK ROOM AND LOCKER ROOM","SUBSTCOMP","270,000",269999,247423,null,null,null,"2016-03-14","2016-05-31",100,"2016-09-08","2016-12-29",100,"2017-01-12","2017-02-02",null,"2017-03-06","2017-04-28",99,"2017-04-28","2018-02-28",null,"2018-02-28","2018-05-31",null,"BARNESC","BOB ELLERHORST","CHARLANDB","-","-","-","ANDERSONB","HOWARDK","BARNESC","LAURIE BRINKER","IPF","MOORE-TROSPER CONSTRUCTION CO","DB - DESIGN BUILD"]
["CP16217","COMMUNICATION ARTS - CONVERT AHU 1 AND 2","SUBSTCOMP","120,000",150000,144325,null,null,null,null,null,null,"2016-08-04","2016-11-10",100,"2016-11-10","2016-11-29",100,"2016-12-12","2017-11-01",98,"2017-11-01","2018-08-01",null,"2018-08-01","2018-11-01",null,"ANDERSONB","LYNDA BOOMER","-","-","-","-","ANDERSONB","-","ANDERSONB","EARLINE SOLOMON","IPF","DEE CRAMER INC","GC - DESIGN BID & BUILD"]
["CP15254","CENTER INTEGRATIVE PLANT SYS-LAB AND VARIOUS BUILDINGS - LAB RENOVATION PLANNING","STUDY",null,null,null,null,null,null,null,null,null,"2015-10-09","2016-12-01",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRIDEM","BARB KRANZ","KASDORFJ","-","-","GARDNERM","-","BEACHK","GOTTSCHALK",null,"IPF","-","TBD - TO BE DETERMINED"]
["CP15281","BRIDGES - LIBRARY - RESURFACING AND REPLACEMENT OF LAND SPAN RAILINGS","SUBSTCOMP","615,000",615000,546324,null,null,null,null,null,null,"2015-10-29","2017-04-21",100,"2017-03-01","2017-03-23",null,"2017-05-31","2017-08-18",97,null,null,null,"2017-08-25","2018-01-26",null,"WAHLT","LYNDA BOOMER","-","-","KINNEYD","LEFEVREJ","-","BEACHK","WAHLT","LAURIE BRINKER","IPF","GRAND RIVER CONSTRUCTION INC","DB - DESIGN BUILD"]
["CP16000","SECCHIA CENTER - RENOVATIONS TO SEVENTH FLOOR","SUBSTCOMP","990,000",995500,948603,null,null,null,null,null,null,"2015-01-07","2015-09-14",100,null,null,null,"2015-09-14","2016-02-15",99,"2016-02-15","2016-11-15",null,"2016-11-15","2017-01-15",null,"TEMPLER","LYNDA BOOMER","TEMPLER","-","-","-","-","-","TEMPLER","LAURIE BRINKER","AECOM GREAT LAKES INC","CHRISTMAN COMPANY","CM - CONSTRUCTION MANAGER"]
["CP16071","COMMUNICATION ARTS - ALERATIONS TO ROOM 18","IN DES","100,000",100000,0,null,null,null,"2016-03-01","2016-04-15",null,"2017-07-31","2018-03-30",70,null,null,null,"2018-05-14","2018-08-17",null,"2018-08-17","2019-05-17",null,"2019-05-17","2019-08-17",null,"GOTTSCHALK","RICH TIBBALS","CHARLANDB","LOCKWOODC","-","-","ANDERSONB","HOWARDK","GOTTSCHALK",null,null,null,"TBD - TO BE DETERMINED"]
["CP16323","LANDON HALL - AIR CONDITION ROOM G15","RELCON","42,400",42400,43439,null,null,null,null,null,null,"2016-12-12","2017-04-12",100,null,null,null,"2017-04-12",null,null,null,null,null,null,null,null,"GOERGES","MARK BOWLING","-","-","-","-","GOERGES","HOWARDK","NORTHB",null,"IPF","IPF","IPF - IPF SELF-PERFORMED"]
["CP17151","WONDERS HALL - TEACHING, LEARNING AND STUDENT SUPPORT RENOVATIONS","IN DES","13,000,000",13000000,57,null,null,null,null,null,null,"2018-02-16","2018-12-31",1,"2018-12-17","2019-01-18",null,"2018-12-17","2019-12-17",null,"2019-12-17","2020-09-17",null,"2020-09-17","2020-12-17",null,"POSTMAM","LISA SUDIA","PENNOCKK","-","-","-","HOPPERS","BEACHK","POSTMAM","LAURIE BRINKER",null,null,"CM - CONSTRUCTION MANAGER"]
["CP17175","INTERNATIONAL CENTER - RENOVATION TO SUITES 205, 207 AND 211","IN DES","200,000",200000,0,null,null,null,null,null,null,"2017-08-16","2018-03-30",25,null,null,null,"2018-01-15","2018-04-15",null,"2018-04-15","2019-01-15",null,"2019-01-15","2019-04-15",null,"POSTMAM","MICHAEL STOKES","CHARLANDB","WHITBECKD","-","-","GOERGES","HALSEYG","POSTMAM",null,"IPF",null,"IPF - IPF SELF-PERFORMED"]
["CP18007","HOLMES HALL - ALTERATIONS TO ROOM W5","IN DES",null,null,null,null,null,null,null,null,null,"2018-01-11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KLANND","LISA SUDIA","-","-","-","-","-","KLANND",null,null,null,null,"TBD - TO BE DETERMINED"]
["CP15252","STEAM DISTRIBUTION - REPAIR TUNNEL WALL AND LID (NW OF COMM ARTS)","SUBSTCOMP","225,000",225000,152187,null,null,null,null,null,null,"2015-10-07","2015-10-14",100,null,null,null,"2017-07-05","2017-07-31",97,"2017-07-31","2018-02-23",null,"2018-05-25","2018-08-25",null,"GARDNERM","LYNDA BOOMER","-","-","WILBERD","TROTTERM","GARDNERM","-","GARDNERM","EARLINE SOLOMON","FISHBECK, THOMPSON, CARR & HUBER","GRANGER CONSTRUCTION","DB - DESIGN BUILD"]
["CP17019","STUDENT SERVICES - ALTERATIONS TO ROOM 344","SUBSTCOMP","14,000",14000,9353,null,null,null,"2017-01-27","2017-03-13",100,"2017-05-02","2017-05-24",100,null,null,null,"2017-05-11","2017-07-28",99,"2017-07-28","2018-04-28",null,"2018-04-28","2018-07-28",null,"CHARLANDB","SHELLY HARBENSKI","CHARLANDB","WHITBECKD","-","-","-","HOWARDK","-",null,"IPF","IPF","TBD - TO BE DETERMINED"]
["CP17060","NATURAL SCIENCE - ALTERATIONS TO ROOMS 39 AND 39A","SUBSTCOMP","130,000",130000,130540,null,null,null,null,null,null,"2017-03-30","2017-08-23",100,null,null,null,"2017-09-06","2017-12-30",97,"2017-12-30","2018-09-30",null,"2018-09-30","2018-12-30",null,"KRAMERN","DEBRA MILLS","CHARLANDB","-","-","-","HOPPERS","-","KRAMERN",null,"IPF / ENGINEERING APPLICATIONS INC","IPF","DB - DESIGN BUILD"]
["CP17183","FEE HALL - ALTERATIONS TO ROOM E102","RELCON","115,000",115000,39480,null,null,null,null,null,null,"2017-08-28","2017-11-17",100,null,null,null,"2017-12-11","2018-02-28",null,"2018-02-28","2018-11-28",null,"2018-11-28","2019-02-28",null,"CHARLANDB",null,"CHARLANDB","LOCKWOODC","-","-",null,"HOWARDK",null,null,"IPF","IPF","TBD - TO BE DETERMINED"]
["CP08359","ELECTRICAL DISTRIBUTION - SUBSTATION METERING","RELCON","1,000,000",1000000,1150582,null,null,null,null,null,null,"2008-09-10","2009-06-03",null,null,null,null,"2009-04-13","2012-06-30",80,"2012-03-31","2012-03-31",null,"2012-03-31","2012-06-30",null,"FRAZEER","RICK JOHNSON","-","-","-","-","-","FRAZEER","JOHNSONR",null,"IPF","HATZEL & BUEHLER INC","GC - DESIGN BID & BUILD"]
["CP16218","TB SIMON POWER PLANT - CONTROL ROOM HVAC MODIFICATIONS","IN DES","400,000",400000,-694,null,null,null,null,null,null,"2016-08-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BARNESC","LYNDA BOOMER",null,"-","-","-","GOERGES","HOWARDK","BARNESC","LAURIE BRINKER",null,null,"TBD - TO BE DETERMINED"]
["CP16112","BRESLIN - RENOVATE WOMENS BASKETBALL OFFICES AT BERKOWITZ","SUBSTCOMP","937,000",937000,889967,null,null,null,null,null,null,"2016-04-01","2016-06-30",100,"2016-06-15","2016-06-30",100,"2016-06-21","2016-10-21",98,"2016-10-21","2017-10-21",100,"2017-10-21","2018-01-21",null,"VANZEEJ","LINDA K BAUGHMAN","DURKINK","-","-","-","-","-","VANZEEJ","LAURIE BRINKER","INTEGRATED DESIGN SOLUTIONS","LAUX CONSTRUCTION COMPANY","ICM - INTERNAL CONSTRUCTION MANAGER"]
["CP14085","KELLOGG CENTER - FLOOD ELEVATION CERTIFICATION","STUDY",null,null,null,null,null,null,null,null,null,"2014-03-28","2014-08-31",null,null,null,null,null,null,null,null,null,null,null,null,null,"GARDNERM","CHELSEA HORSLEY","-","-","-","GARDNERM","-","-","GARDNERM",null,"IPF","-","GC - DESIGN BID & BUILD"]
["CP16028","CENTRAL SERVICES - ALTERATIONS TO ROOM 117","SUBSTCOMP","260,000",260000,224328,null,null,null,null,null,null,"2016-01-27","2016-09-30",100,"2016-10-04","2016-10-07",null,"2017-04-03","2017-07-14",97,"2017-07-14","2018-04-14",null,"2018-04-14","2018-07-14",null,"GOTTSCHALK","ERIC BOATMAN","PENNOCKK","-","KINNEYD","-","-","-","GOTTSCHALK","LAURIE BRINKER","IPF","NIELSEN COML CONSTRUCTION CO INC","GC - DESIGN BID & BUILD"]
["CP17169","IM SPORTS-CIRCLE - CONSTRUCT MULTI-PURPOSE ROOMS, CLASSROOMS AND WELLNESS SPACE","IN DES","10,000,000",10000000,2977,null,null,null,null,null,null,"2017-08-08",null,null,null,null,null,"2017-08-08","2019-04-30",null,null,null,null,null,null,null,"GARDNERM","LYNDA BOOMER","KASDORFJ","WHITBECKD","WAHLT","GARDNERM","HOPPERS","HALSEYG",null,"ROBIN MCVAY","TMP","GRANGER CONSTRUCTION","CM - CONSTRUCTION MANAGER"]
["CP16167","CASE HALL - ALTERATIONS TO ROOM 331","RELCON","70,000",70000,51342,null,null,null,null,null,null,"2016-07-11","2017-03-28",100,null,null,null,"2017-05-08","2017-06-30",95,"2017-06-30","2018-03-30",null,"2018-03-30","2018-06-30",null,"KLANND","LISA SUDIA","-","LOCKWOODC","-","-","-","KLANND","-",null,"IPF","IPF","DB - DESIGN BUILD"]
["CP16199","IM SPORTS-CIRCLE AND VARIOUS BUILDINGS - AQUATICS FACILITY ASSESSMENT","STUDY","200,000",200000,31120,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOPPERS","LYNDA BOOMER","-","-","-","-","HOPPERS","-","COOLC",null,null,null,"TBD - TO BE DETERMINED"]
["CP16258","NATURAL SCIENCE - ALTERATIONS TO ROOMS 240, 240A, 240B, 240C, 241, 241A AND 241B","SUBSTCOMP","210,000",210000,203012,null,null,null,"2016-09-15","2017-04-14",100,"2017-03-24","2017-07-01",100,null,null,null,"2017-07-30","2017-12-15",97,"2017-12-15","2018-09-15",null,"2018-09-15","2019-12-15",null,"KRAMERN","MARIAH MEEK","CHARLANDB","WHITBECKD","-","-","HOPPERS","-","KRAMERN","EARLINE SOLOMON","IPF/ENGINEERING APPLICATIONS INC","NIELSEN COML CONSTRUCTION CO INC","TBD - TO BE DETERMINED"]
["CP16219","STEAM DISTRIBUTION - REPLACE ADSCO/BELLOW EXPANSION JOINTS - POWER PLANT TO VAULT 180 - PHASE 2","RELCON","600,000",570000,349586,null,null,null,null,null,null,"2016-08-04","2017-08-30",100,null,null,null,"2017-07-14","2018-08-17",10,"2018-08-18","2019-04-26",null,"2019-04-27","2019-07-27",null,"GARDNERM","LYNDA BOOMER","-","-","-","TROTTERM","GARDNERM","-","GARDNERM","LAURIE BRINKER","IPF","IPF/GRANGER","DB - DESIGN BUILD"]
["CP13157","SEWER DISTRIBUTION - EMERGENCY REPAIR AND ABANDON 21\" PRESSURE SEWER","STUDY",null,0,133974,null,null,null,null,null,null,"2016-07-30","2016-07-30",null,null,null,null,null,null,null,null,null,null,null,null,null,"GARDNERM","SCOTT GARDNER","GARDNERM","-","-","TROTTERM","-","-","TBD",null,"IPF","-","GC - DESIGN BID & BUILD"]
["CP13270","CIPS - IMPLEMENT ENERGY CONSERVATION MEASURES","IN DES","116,000",116000,0,null,null,null,null,null,null,"2013-09-26","2017-09-30",70,null,null,null,"2017-10-01","2018-01-15",0,"2018-01-15","2018-10-15",null,"2018-10-15","2019-01-15",null,"ANDERSONB","DAN BOLLMAN","-","-","-","-","ANDERSONB","HOWARDK","-",null,null,null,"DB - DESIGN BUILD"]
["CP14217","BUSINESS COLLEGE - ADDITION NO. 2 - PAVILION","RELCON","62,000,000",62000000,18425003,null,null,null,null,null,null,"2014-07-15","2017-02-28",100,null,null,null,"2017-06-12","2019-06-20",15,"2019-06-21","2020-10-10",null,"2020-10-10","2021-03-21",null,"ABDEL-AZIM","LISA SUDIA","ABDEL-AZIM","WHITBECKD","KINNEYD","TROTTERM","HOPPERS/ANDERSONB","BEACHK","RHODESA","ROBIN MCVAY","FISHBECK, THOMPSON, CARR & HUBER","CLARK CONSTRUCTION COMPANY","CM - CONSTRUCTION MANAGER"]
["CP17077","MUSIC BUILDING - ADDITION NO. 3","IN DES","35,000,000",35000000,420176,null,null,null,null,null,null,"2017-04-24","2018-04-13",10,null,null,null,"2018-04-13","2019-08-01",null,"2019-08-01","2020-08-01",null,"2020-08-01","2020-11-01",null,"WILSONT","BARB KRANZ","PENNOCKK","WHITBECKD","KINNEYD","TROTTERM","HOPPERS","HOWARDK","WILSONT","ROBIN MCVAY","TMP","CHRISTMAN CO","CM - CONSTRUCTION MANAGER"]
["CP17184","PARKING - LOT 62 - IM WEST - RECONSTRUCT LOT 62","IN DES",null,0,5800,null,null,null,null,null,null,"2017-08-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TROTTERM","STEPHANIE O'DONNELL","-","-","WILBERD","TROTTERM","-","HALSEYG",null,null,null,null,"TBD - TO BE DETERMINED"]
["CP16304","INTERDISCIPLINARY SCIENCE & TECHNOLOGY - CONSTRUCT ORIGINAL BUILDING","RELCON","100,000,000",100000000,30367151,null,null,null,null,null,null,"2016-11-21","2017-08-01",100,"2017-03-25","2017-04-10",100,"2017-04-10","2019-07-01",35,"2019-07-01","2020-04-01",null,"2020-04-01","2020-04-01",null,"TEMPLER","LYNDA BOOMER","KASDORFJ","-","WILBERD","LEFEVREJ","NESTLER","BEACHK","COOLC","ROBIN MCVAY","SMITHGROUP JJR INC / PETER BASSO ASSOCIATES INC","CLARK/ROCKFORD JOINT VENTURE","CM - CONSTRUCTION MANAGER"]
["CP16344","OLIN HEALTH CENTER - STUDENT HEALTH","RELCON","3,600,000",3600000,2499648,null,null,null,"2017-01-04","2017-02-18",100,"2017-02-17","2017-05-18",100,null,null,null,"2017-06-30","2017-08-01",40,"2017-08-01","2018-05-01",null,"2018-05-01","2018-08-08",null,"ABDEL-AZIM","LYNDA BOOMER","ABDEL-AZIM","-","-","-","FRANCISD","HOWARDK","WILSONT","ROBIN MCVAY","TMP ASSOCIATES INC","GRANGER CONSTRUCTION CO","DB - DESIGN BUILD"]
["CP12317","WELL HOUSE NO 33 - CONSTRUCT ORIGINAL BUILDING","RELCON","920,000",920000,372310,null,null,null,null,null,null,"2012-12-17","2014-07-30",100,"2014-08-02","2014-08-26",100,"2014-11-10","2018-06-30",36,"2018-06-30","2018-09-30",null,"2018-09-30","2019-06-30",null,"GOTTSCHALK","ROBERT NESTLE","-","-","WILBERD","LEFEVREJ","-","BONKJ","GOTTSCHALK","ROBIN MCVAY","IPF","PEERLESS MIDWEST INC","GC - DESIGN BID & BUILD"]
["CP17166","DEMONSTRATION HALL - ALTERATIONS TO MULTI-USE COURT FLOOR","IN DES","2,150,000",2820000,2888,null,null,null,null,null,null,"2017-08-08",null,null,null,null,null,"2017-08-08","2018-08-30",null,null,null,null,null,null,null,"GARDNERM","LYNDA BOOMER","KASDORFJ","-","WAHLT","GARNDERM","HOPPERS","HOWARDK","VANZEEJ","ROBIN MCVAY","TMP","GRANGER CONSTRUCTION","DB - DESIGN BUILD"]
["CP16343","REGIONAL CHILLED WATER PLANT - REPLACE TWO SULFURIC ACID TANKS","IN DES","150,000",150000,0,null,null,null,"2017-01-03","2017-02-17",100,"2017-05-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"O'BRIENI","LYNDA BOOMER","O'BRIEN","-","-","-","-","-","O'BRIENI",null,"CAPITAL CONSULTANTS INC",null,"TBD - TO BE DETERMINED"]
["CP13230","BESSEY HALL - IMPLEMENT ENERGY CONSERVATION MEASURES","RELCON","750,000",750000,736737,null,null,null,null,null,null,"2013-08-28","2016-05-30",100,null,null,null,"2016-06-01","2018-05-01",90,"2018-05-01","2019-02-01",null,"2019-02-01","2019-05-01",null,"FRANCISD","DAN BOLLMAN","KASDORFJ","-","-","-","GOERGES","BONKJ","SEDDOND","ROBIN MCVAY","DICLEMENTE SIEGEL DESIGN INC","IPF","DB - DESIGN BUILD"]
["CP16213","VETERINARY MEDICAL CENTER - MISCELLANEOUS ITEMS FOR ACCREDITATION","SUBSTCOMP","255,000",255000,151728,null,null,null,"2016-08-04","2016-08-04",100,"2016-10-10","2016-11-01",100,"2016-11-02","2016-11-17",100,"2016-12-05","2017-12-06",97,"2017-12-06","2018-09-06",98,"2018-09-06","2018-12-06",null,"POSTMAM","LYNDA BOOMER","KASDORFJ","-","-","-","-","-","POSTMAM","LAURIE BRINKER","IPF","MICHIELUTTI BROS INC","GC - DESIGN BID & BUILD"]
["CP16292","MUSIC PRACTICE - ALTERATIONS TO ROOM 102","IN DES","55,000",104500,0,null,null,null,"2016-10-21","2016-12-05",null,"2017-08-03","2018-05-01",null,null,null,null,null,null,null,null,null,null,"2016-12-29","2016-12-29",null,"KLANND","CHARLES ROBERTS","-","-","-","-","-","KLANND",null,null,null,null,"TBD - TO BE DETERMINED"]
["CP17053","KELLOGG CENTER - FACILITY ASSESSMENT","STUDY",null,0,10,null,null,null,null,null,null,"2017-03-24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WILSONT","BILL WHITBECK","WILSONT","-","-","-","-","-","-",null,"IPF","-","TBD - TO BE DETERMINED"]
["CP18039","CHILDREN'S GARDEN - GARDEN KIOSK","STUDY",null,null,null,null,null,null,null,null,null,"2018-02-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PENNOCKK","JESSICA WRIGHT","PENNOCKK","-","KINNEYD","-","-","-","-",null,"EAST ARBOR",null,"TBD - TO BE DETERMINED"]
["CP16285","COOK HALL - BUILDING RENOVATION AND ADDITION NO. 1","IN DES","4,800,000",4800000,153195,null,null,null,null,null,null,"2017-02-08","2017-12-05",25,"2018-01-01","2018-02-28",null,"2018-03-01","2018-10-31",null,"2018-10-31","2019-07-31",null,"2019-07-31","2019-10-31",null,"ABDEL-AZIM","LINDSAY GRAY","ABDEL-AZIM","WHITBECKD","WILBERD","LEFEVREJ","FRANCISD","BEACHK","LINEBAUGHA","ROBIN MCVAY","HOPKINSBURNS DESIGN STUDIO","CHRISTMAN COMPANY","DB - DESIGN BUILD"]
["CP13267","PSYCHOLOGY - IMPLEMENT ENERGY CONSERVATION MEASURES","RELCON","113,000",113000,79656,null,null,null,null,null,null,"2013-09-26","2015-03-27",100,null,null,null,"2015-05-15","2016-09-30",77,"2016-09-30","2017-06-30",null,"2017-06-30","2017-09-30",null,"FRANCISD","DAN BOLLMAN","-","-","-","-","FRANCISD","HOWARDK","SEDDOND",null,"MACMILLAN ASSOCIATES INC","IPF","DB - DESIGN BUILD"]
["CP15068","COMMUNICATION DISTRIBUTION - UPGRADE CAMPUS WIRELESS NETWORK","STUDY",null,null,null,null,null,null,null,null,null,"2015-03-04","2016-02-28",null,null,null,null,null,null,null,null,null,null,null,null,null,"KLANND","LYNDA BOOMER","-","-","-","-","-","KLANND","-",null,"IPF","-","TBD - TO BE DETERMINED"]
["CP15223","COMMUNICATION ARTS  - TIER ONE DATA ROOM EXPANSION IN ROOM 16","SUBSTCOMP","575,000",575000,481891,null,null,null,"2015-09-16","2015-10-31",100,"2015-11-05","2016-04-01",100,"2016-04-25","2016-05-17",null,"2017-03-30","2017-08-02",95,"2017-08-02","2018-05-02",null,"2018-05-02","2018-08-02",null,"O'BRIENI","BOB GRESS","-","-","-","-","O'BRIENI","-","GOTTSCHALK","LAURIE BRINKER","CTRE INC","NIELSEN COML CONSTRUCTION CO INC","GC - DESIGN BID & BUILD"]
["CP16100","KELLOGG CENTER - PHASE 6A AND 6B - NEW FRONT REGISTRATION DESK AND CORRIDOR RENOVATION","SUBSTCOMP","891,000",891000,731110,null,null,null,null,null,null,"2016-03-23",null,100,"2016-08-19","2016-09-01",null,"2016-09-22","2017-05-01",97,"2017-01-31","2018-01-31",null,"2018-01-31","2018-04-30",null,"DURKINK","SUE M BRANDT","DURKINK","-","-","-","-","-","VANZEEJ","LAURIE BRINKER","N/A","IPF","CM - CONSTRUCTION MANAGER"]
["CP16198","REGIONAL CHILLED WATER PLANT - IMPLEMENT ENERGY CONSERVATION MEASURES","RELCON","710,000",710000,368517,null,null,null,null,null,null,"2016-07-21","2016-09-30",100,null,null,null,"2016-10-01","2018-07-20",45,"2018-07-20","2019-04-20",null,"2019-04-20","2019-07-20",null,"FRANCISD","LYNDA BOOMER","-","-","-","-","FRANCISD","-","SEDDOND","LAURIE BRINKER","IPF","IPF","DB - DESIGN BUILD"]
["CP16097","VETERINARY MEDICAL CENTER - ALTERATIONS TO ROOMS G106 AND G106C","SUBSTCOMP","340,826",340826,203076,null,null,null,"2016-03-22","2016-05-06",100,"2016-07-18","2017-01-30",100,"2017-02-01","2017-02-20",100,"2017-05-08","2017-08-18",98,"2017-08-18","2018-05-18",98,"2018-05-18","2018-08-18",null,"POSTMAM","FAYE WATSON","KASDORFJ","-","-","-","-","-","POSTMAM","LAURIE BRINKER","HKS INC","MOORE-TROSPER CONSTRUCTION CO","TBD - TO BE DETERMINED"]
["CP17104","CENTER FOR INTEGRATIVE PLANT SYS-LAB - REPLACE HYDRONIC HEATING SYSTEM SERVING GREENHOUSES","RELCON","500,000",500000,115017,null,null,null,null,null,null,"2017-05-24","2017-08-08",100,null,null,null,"2017-08-08","2018-08-17",1,"2018-08-17","2018-12-14",null,"2018-12-14","2019-03-14",null,"FRANCISD","LYNDA BOOMER","-","-","-","-","FRANCISD","-","-","LAURIE BRINKER","IPF","IPF","IPF - IPF SELF-PERFORMED"]
["CP16240","SHAW HALL - SANITARY DRAIN SYSTEM STUDY","STUDY",null,0,38499,null,null,null,null,null,null,"2016-08-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DURKINK","BILL WHITBECK","-","-","-","LEFEVREJ","-","-","DURKINK",null,"-","GUNTHORPE PLUMBING & HEATING INC","TBD - TO BE DETERMINED"]
["CP17210","ANTHONY HALL - RENOVATION OF ROOMS 1235, 1255, 1257 AND 1260","IN DES",null,null,null,null,null,null,null,null,null,"2017-10-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KLANND","LISA SUDIA","-","LOCKWOODC","-","-","-","KLANND",null,null,null,null,"TBD - TO BE DETERMINED"]
["CP11295","CLINICAL CENTER - C-WING - HVAC RENOVATION AND ADDITION 1","SUBSTCOMP","8,500,000",8500000,8468846,null,null,null,null,null,null,"2011-12-12","2014-04-30",100,null,null,null,"2014-04-15","2017-04-30",99,"2017-05-01","2018-02-01",100,"2018-02-01","2018-05-01",null,"HOPPERS","MICHELE HICKS","KASDORFJ","-","WILBERD","-","HOPPERS","HOWARDK","WILSONT","LAURIE BRINKER","PETER BASSO ASSOCIATES INC","CLARK CONSTRUCTION COMPANY","CM - CONSTRUCTION MANAGER"]
["CP16013","AUDITORIUM - MAIN AUDITORIUM UPGRADES","IN DES",null,null,null,null,null,null,null,null,null,"2016-01-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KASDORFJ","LYNDA BOOMER","KASDORFJ","-","-","-","WILSONT","-","WILSONT","LAURIE BRINKER",null,null,"TBD - TO BE DETERMINED"]
["CP09133","AUDITORIUM - ALTERATIONS TO FAIRCHILD THEATRE","SUBSTCOMP","20,000,000",20000000,19564816,null,null,null,"2009-04-21","2009-06-05",null,"2011-06-14","2012-06-29",100,"2012-07-09","2012-08-02",null,"2012-09-10","2013-10-25",97,"2013-10-25","2015-11-15",null,"2015-11-15","2017-12-31",null,"WILSONT","72660","WILSONT","-","KINNEYD","-","HOPPERS","HOWARDK","WILSONT","ROBIN MCVAY","SMITHGROUP JJR INC","CHRISTMAN COMPANY","CM - CONSTRUCTION MANAGER"]
["CP16250","VETERINARY MEDICAL CENTER - ALTERATIONS TO SUITE D100","SUBSTCOMP","135,000",184637,38495,null,null,null,"2016-09-01","2016-09-19",100,"2016-09-19","2016-12-25",100,"2017-04-27","2017-05-04",100,"2017-07-01","2018-02-02",97,"2018-02-02","2018-11-02",null,"2018-11-02","2019-02-02",null,"POSTMAM","SEAN YANCEY","KASDORFJ","-","-","-","-","-","POSTMAM","EARLINE SOLOMON","ANIMAL ARTS DESIGN STUDIOS INC","LAUX CONSTRUCTION COMPANY","GC - DESIGN BID & BUILD"]
["CP17030","STUDENT SERVICES - RENOVATE ROOMS 315 AND 316","SUBSTCOMP","6,000",6000,8756,null,null,null,null,null,null,"2017-02-15","2017-03-02",100,null,null,null,"2017-04-05","2017-05-01",99,"2017-05-01","2018-02-01",null,"2018-02-01","2018-05-01",null,"CHARLANDB","KATHLEEN SMITH","CHARLANDB","-","-","-","-","HOWARDK","CHARLANDB",null,"IPF","IPF","DB - DESIGN BUILD"]
["CP17078","PARKING RAMP 8 - WILSON RD - CONSTRUCT ORIGINAL BUILDING","STUDY",null,0,11059,null,null,null,null,null,null,"2017-04-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WILBERD","STEPHANIE O'DONNELL","KASDORFJ","-","WILBERD","TROTTERM","-","BEACHK","LINEBAUGHA"]
["CP14218","T.B. SIMON POWER PLANT - UPGRADE UTILITY SUBSTATION","SUBSTCOMP","24,000,000",24000000,23891344,null,null,null,null,null,null,"2014-07-16","2016-02-05",100,null,null,null,"2016-01-11","2017-03-31",97,"2017-03-31","2018-03-31",null,"2018-03-31","2018-06-30",null,"BARNESC","DAN BOLLMAN","-","-","WILBERD","-","-","FRAZEER","BARNESC","ROBIN MCVAY","CONSUMERS ENERGY","CONSUMERS ENERGY","CM - CONSTRUCTION MANAGER"]
["CP17198","TB SIMON POWER PLANT -  INSTALL MEDIUM PRESSURE STEAM BOILER","IN DES","7,000,000",7000000,0,null,null,null,null,null,null,"2017-10-30","2018-10-26",1,null,null,null,"2018-10-29","2019-12-31",null,"2019-12-31","2020-09-30",null,"2020-09-30","2020-12-31",null,"BARNESC","LYNDA BOOMER","-","-","WAHLT","GARDNERM","FRANCISD","BEACHK","BARNESC","ROBIN MCVAY",null,null,"DB - DESIGN BUILD"]
["CP16150","EXECUTIVE DEVELOPMENT - ALTERATIONS TO ROOMS D10 - D20","SUBSTCOMP","35,000",35000,31131,null,null,null,"2016-06-09","2016-07-24",100,"2017-06-08","2017-07-01",100,null,null,null,"2017-07-15","2017-10-31",97,"2017-10-31","2018-07-31",null,"2018-07-31","2018-10-31",null,"MULLENB","JEFFERY MAGNUSON","-","-","-","-","-","-","MULLENB","EARLINE SOLOMON","IPF","NIELSEN COML CONSTRUCTION CO INC","GC - DESIGN BID & BUILD"]
["CP16194","STUDENT SERVICES - REPLACE WINDOWS, HVAC UPGRADES AND WATERPROOFING","IN DES","5,700,000",5350000,194325,null,null,null,null,null,null,"2017-07-21","2017-12-01",100,"2017-12-01","2018-01-15",85,"2018-04-01","2018-11-30",null,"2018-11-30","2019-08-30",null,"2019-08-30","2019-11-30",null,"COOLC","LYNDA BOOMER","PENNOCKK","-","WILBERD","-","FRANCISD","HALSEYG","COOLC","ROBIN MCVAY","WTA","CHRISTMAN CONSTRUCTORS","CM - CONSTRUCTION MANAGER"]
["CP16252","MCDONEL HALL - REPLACE ROOM C107 HVAC SYSTEM","SUBSTCOMP","740,000",740000,620954,null,null,null,null,null,null,"2016-09-08","2017-03-24",100,"2017-03-27","2017-03-27",100,"2017-05-08","2017-08-17",97,"2017-08-18","2018-05-18",null,"2018-05-18","2018-08-18",null,"HOPPERS","LISA SUDIA","PENNOCKK","LOCKWOODC","WILBERD","GARDNERM","HOPPERS","KLANND","COOLC","LAURIE BRINKER","PETER BASSO ASSOCIATES INC","GRANGER CONSTRUCTION CO","TBD - TO BE DETERMINED"]
["CP16064","CASE HALL - REPLACE DOMESTIC WATER PIPING","SUBSTCOMP","400,000",400000,281924,null,null,null,null,null,null,"2016-02-22","2016-12-31",100,"2017-02-20","2017-02-20",100,"2017-05-30","2017-08-10",99,"2017-08-10","2018-05-10",100,"2018-05-10","2018-08-10",null,"POSTMAM","AARON MINNIS","-","-","-","LEFEVREJ","ANDERSONB","HOWARDK","ANDERSONB","LAURIE BRINKER","IPF","NIELSEN COML CONSTRUCTION CO INC","DB - DESIGN BUILD"]
["CP16274","SPARTAN VILLAGE - ALTERATIONS TO UNITS 1612E, 1616A, 1619A, 1619B, 1622B AND 1622C","SUBSTCOMP","550,000",550000,523399,null,null,null,null,null,null,"2016-10-06","2017-03-17",100,null,null,null,"2017-04-01","2017-09-30",99,"2017-09-30","2018-06-30",null,"2018-06-30","2018-09-30",null,"CHARLANDB","BILL WHITBECK","CHARLANDB","-","-","-","GOERGES","HOWARDK","VANAKENB","LAURIE BRINKER","IPF / ENGINEERING APPLICATIONS INC","IPF","DB - DESIGN BUILD"]
["CP17160","CLINICAL CENTER-CLINIC - ALTERATIONS TO ROOM A101","IN DES",null,0,2199,null,null,null,null,null,null,"2017-08-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FRANCISD","JANA JIRAK",null,null,null,null,"FRANCISD",null,null,null,null,null,"TBD - TO BE DETERMINED"]
["CP17235","TRAUMATIC BRAIN INJURY RESEARCH - CONSTRUCT ORIGINAL BUILDING","IN DES",null,null,null,null,null,null,null,null,null,"2017-11-08","2018-02-28",5,null,null,null,null,null,null,null,null,null,null,null,null,"MULLENB","TOM VOICE","MULLENB","-","TROOSTS","-",null,null,"MULLENB",null,null,null,"TBD - TO BE DETERMINED"]
["CP16190","ENGINEERING - REPLACE ELEVATORS 4 AND 5","RELCON","845,000",845000,663116,null,null,null,null,null,null,"2016-07-21","2017-02-23",100,"2017-02-23","2017-03-14",null,"2017-04-26","2018-01-31",10,"2018-01-31","2018-10-31",null,"2018-10-31","2019-01-31",null,"KASDORFJ","LYNDA BOOMER","KASDORFJ","-","-","-","-","-","WILSONT","LAURIE BRINKER","BERNATH-COAKLEY ASSOC ARCHITECT INC/ENGINEERING APPLICATIONS INC","NIELSEN COML CONSTRUCTION CO INC","GC - DESIGN BID & BUILD"]
["CP15232","STEAM DISTRIBUTION - REPAIR/REPLACE STEAM VAULT 180 - STRUCTURAL FLOOR ANCHORS","RELCON","950,000",870000,391562,null,null,null,null,null,null,"2015-09-30","2016-04-29",100,null,null,null,"2017-07-10","2018-08-18",10,"2018-08-18","2019-05-18",null,"2019-05-18","2019-08-18",null,"GARDNERM","LYNDA BOOMER","-","-","-","TROTTERM","GARDNERM","-","GARDNERM","LAURIE BRINKER","FISHBECK, THOMPSON, CARR & HUBER","GRANGER CONSTRUCTION CO","DB - DESIGN BUILD"]
["CP15236","BUSINESS COLLEGE - VAV CONVERSION AND CONTROLS ECM UPGRADES","RELCON","439,500",439500,123347,null,null,null,null,null,null,"2015-09-30","2017-04-01",100,null,null,null,"2017-05-01","2018-09-30",55,"2018-09-30","2018-10-30",null,"2018-10-30","2019-01-30",null,"FRANCISD","LYNDA BOOMER","-","-","-","-","GOERGES","-","TBD","LAURIE BRINKER","MATRIX CONSULTING ENGINEERS INC","IPF","DB - DESIGN BUILD"]
["CP16222","WATER DISTRIBUTION - WATER SERVICE TO YAKELEY HALL","SUBSTCOMP","240,000",240000,172022,null,null,null,null,null,null,"2016-08-04","2017-06-11",25,null,null,null,"2017-07-14","2017-08-11",97,"2017-08-11","2018-05-11",null,"2018-05-11","2018-08-11",null,"GARDNERM","LYNDA BOOMER","-","-","-","TROTTERM","GARDNERM","-","-","JANNENE ANDREWS","IPF","GRANGER CONSTRUCTION CO","DB - DESIGN BUILD"]
["CP16003","LIFE SCIENCE - ALTERATIONS TO LAB B330","SUBSTCOMP","425,047",500000,287151,null,null,null,"2016-01-07","2016-05-04",100,"2016-05-23","2016-11-21",100,"2016-11-22","2016-12-14",100,"2017-01-16","2017-04-26",99,"2017-04-26","2018-01-26",98,"2018-01-26","2018-04-26",null,"POSTMAM","BRIAN JESPERSEN","CHARLANDB","-","-","-","ANDERSONB","-","POSTMAM","LAURIE BRINKER","MATRIX CONSULTING ENGINEERS INC","NIELSEN COML CONSTRUCTION CO INC","GC - DESIGN BID & BUILD"]
["CP16265","HOLMES HALL - REPLACE DOMESTIC COLD WATER PIPING","OUTBID","415,000",641800,1196,null,null,null,"2016-09-22","2016-11-06",null,"2017-01-19","2018-02-01",100,"2018-01-12","2018-02-08",100,"2018-05-07","2018-08-17",0,"2018-08-17","2019-05-17",null,"2019-05-17","2019-08-17",null,"ANDERSONB","MIKE HICKS","ANDERSONB","-","-","-","ANDERSONB","ANDERSONB","ANDERSONB","LAURIE BRINKER","MICHIGAN STATE UNIVERSITY","GUNTHORPE","GC - DESIGN BID & BUILD"]
["CP16341","STUDENT SERVICES - ALTERATIONS TO ROOMS 309, 311 AND 318","SUBSTCOMP","26,000",26000,47439,null,null,null,"2016-12-29","2017-02-12",100,"2017-02-20","2017-03-31",100,null,null,null,"2017-05-15","2017-08-11",97,"2017-08-14","2018-05-14",null,"2018-05-14","2018-08-14",null,"CHARLANDB","ERIK MAILLARD","CHARLANDB","-","-","-","-","HOWARDK","SMITHM",null,"IPF","IPF","TBD - TO BE DETERMINED"]
["CP15299","BRESLIN - INSTALL FOOD SERVICE EQUIPMENT","SUBSTCOMP","803,196",803196,728369,null,null,null,null,null,null,"2015-11-19","2015-11-19",100,"2015-12-11","2015-12-11",100,"2016-01-01","2017-08-28",97,"2017-08-28","2018-05-28",null,"2018-05-28","2018-08-28",null,"BONKJ","BILL WHITBECK","-","-","-","-","-","BONKJ","VANZEEJ","LAURIE BRINKER","BIGELOW/ROSETTI","BARTON MALOW COMPANY","CM - CONSTRUCTION MANAGER"]
["CP16336","BIOMEDICAL PHYSICAL SCIENCES - ALTERATIONS TO ROOM 4160","SUBSTCOMP","110,000",110000,83593,null,null,null,"2016-12-20","2017-02-03",100,"2017-04-27","2017-08-31",100,null,null,null,"2017-09-18","2018-01-10",97,"2018-01-10","2018-10-10",null,"2018-10-10","2019-01-10",null,"KRAMERN","DENISE ELWART","KRAMERN","-","-","-","HOPPERS","PRIDEM","KRAMERN",null,"TMP ASSOCIATES INC / PETER BASSO ASSOCIATES INC","NIELSEN CML CONSTRUCTION CO INC","ICM - INTERNAL CONSTRUCTION MANAGER"]
["CP17098","MICH BIOTECH INSTITUTE - ALTERATIONS TO CHILLERS IN ROOM B138","IN DES",null,null,null,null,null,null,null,null,null,"2017-05-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BEACHK","PHIL HEGGE","-","-","-","-","-","BEACHK","-",null,null,null,"TBD - TO BE DETERMINED"]
["CP16318","WHARTON - RENOVATIONS AND GREAT HALL SEATING REPLACEMENT","OUTBID","1,500,000",1500000,68397,null,null,null,null,null,null,"2016-12-07",null,100,"2017-07-12","2017-07-12",null,"2018-05-15","2018-09-14",null,"2018-09-14","2019-06-14",null,"2019-06-14","2019-09-14",null,"KOLPJ","JARROD BRADFORD","-","-","-","-","WILSONT","-","KOLPJ","ROBIN MCVAY","SMITHGROUP JJR INC","IPF-ICM","ICM - INTERNAL CONSTRUCTION MANAGER"]
["CP07171","NATURAL AREAS - FLOOD RESPONSE PLANNING 2016","STUDY",null,0,231250,null,null,null,null,null,null,"2007-04-23","2015-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,"GARDNERM","BOLLMAND","GARDNERM","-","-","TROTTERM","GARDNERM","-","-",null,"IPF","FISHBECK, THOMPSON, CARR & HUBER","TBD - TO BE DETERMINED"]
["CP14122","DUFFY DAUGHERTY FOOTBALL - S.A.A.C. - RENOVATE LOCKER ROOM AND TRAINING ROOM","SUBSTCOMP","5,944,000",5944000,5902078,null,null,null,null,null,null,"2014-04-25","2014-09-30",null,"2014-12-03","00:00:00",null,"2015-01-01","2015-07-17",98,"2015-07-07","2016-07-17",null,"2016-07-17","2017-07-31",null,"KASDORFJ","GREG IANNI","KASDORFJ","-","-","-","HOPPERS","BONKJ","DURKINK","ROBIN MCVAY","INTEGRATED DESIGN SOLUTIONS","IPF","ICM - INTERNAL CONSTRUCTION MANAGER"]
["CP14286","PUBLIC SAFETY - FEASIBILITY STUDY FOR TELECOM SPACE","STUDY",null,20000,20000,null,null,null,"2014-09-15","2014-10-30",null,"2014-10-24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KASDORFJ","ANNE PHILLIPS","KASDORFJ","-","-","-","HOPPERS","BONKJ","-",null,"IPF","ANN ARBOR ARCHITECTS COLLABORATIVE","TBD - TO BE DETERMINED"]
["CP17186","COWLES HOUSE - ELEVATOR AND INTERIOR RENOVATIONS","IN DES",null,100000,9600,null,null,null,null,null,null,"2017-09-11","2018-12-14",30,null,null,null,"2018-12-17","2020-03-20",null,"2020-03-20","2020-12-31",null,"2020-12-31","2021-03-31",null,"BARNESC","BARB KRANZ","PENNOCKK","LOCKWOODC","KINNEYD","-","FRANCISD","HOWARDK","BARNESC","ROBIN MCVAY","HOPKINSBURNS DESIGN STUDIO","THE CHRISTMAN COMPANY","CM - CONSTRUCTION MANAGER"]
["CP17106","FEE HALL - REPLACE EXHAUST SYSTEM IN CENTER WING","SUBSTCOMP","640,000",640000,459189,null,null,null,null,null,null,"2017-05-24","2017-08-13",100,"2017-08-13","2017-08-29",100,"2017-09-18","2018-01-10",97,"2018-01-10","2018-10-10",null,"2018-10-10","2019-01-10",null,"ANDERSONB","LYNDA BOOMER","-","-","-","LEFEVREJ","ANDERSONB","HOWARDK","ANDERSONB","LAURIE BRINKER",null,"MOORE TROSPER","TBD - TO BE DETERMINED"]
["CP17023","BERKEY HALL - TECHNOLOGY UPGRADES IN ROOMS 12C, 100, 103, 108, 122 AND 314","RELCON","48,000",48000,36572,null,null,null,null,null,null,"2017-02-06","2017-03-28",100,null,null,null,"2017-05-08","2017-06-30",null,"2017-06-30","2018-03-30",null,"2018-03-30","2018-06-30",null,"KLANND","STEVE JOWETT","-","LOCKWOODC","-","-","-","KLANND","-",null,"IPF","IPF","DB - DESIGN BUILD"]
["CP16135","PLANT BIOLOGY - FUME HOOD EXHAUST STUDY","RELCON","95,000",95000,31449,null,null,null,null,null,null,"2016-05-10","2017-04-25",100,null,null,null,"2017-06-09","2018-02-01",95,"2018-02-01","2018-11-01",0,"2018-11-01","2019-02-01",0,"ANDERSONB","ANDERSONB","ANDERSONB","-","-","-","ANDERSONB","ANDERSONB","ANDERSONB","EARLINE SOLOMON","IPF","DEE CRAMER INC","TBD - TO BE DETERMINED"]
["CP16320","CASE HALL - IMPROVE VENTILATION IN ROOM 129F","SUBSTCOMP","38,000",38000,41562,null,null,null,null,null,null,"2016-12-12","2017-04-12",100,null,null,null,"2017-05-01","2017-11-01",97,"2017-11-01","2018-08-01",null,"2018-08-01","2018-11-01",null,"FRANCISD","MARK BOWLING","-","-","-","-","FRANCISD","-","NORTHB",null,"IPF","IPF","IPF - IPF SELF-PERFORMED"]
["CP17074","BUSINESS COLLEGE - MOVE LEAR CENTER ROOMS 145, 146, 147, 148, 149, 150, 151 AND 152 TO OWEN HALL","SUBSTCOMP","200,000",236000,208002,null,null,null,null,null,null,"2017-04-19","2017-04-24",100,null,null,null,"2017-04-25","2017-08-22",97,"2017-08-22","2018-05-22",null,"2018-05-22","2018-08-22",null,"RHODESA","LISA SUDIA","ABDEL-AZIM","WHITBECKD","-","-","-","-","RHODESA","EARLINE SOLOMON","IPF","NIELSEN COML CONSTRUCTION CO INC","TBD - TO BE DETERMINED"]
["CP17040","PLANT BIOLOGY - ALTERATIONS TO LABS 337, 342, 366 AND 366A","SUBSTCOMP","62,000",62000,43942,null,null,null,"2017-02-28","2017-04-14",null,"2017-07-31","2017-09-30",100,null,null,null,"2017-11-01","2018-01-30",97,"2018-01-30","2018-10-30",null,"2018-10-30","2019-01-30",null,"KRAMERN","TRACEY BARNER","CHARLANDB","-","-","-","ANDERSONB","HOWARDK","KRAMERN",null,"ENGINEERING APPLICATIONS INC","IPF","TBD - TO BE DETERMINED"]
["CP15120","GRAND RAPIDS RESEARCH CENTER - AUXILLARY PROPERTY DEVELOPMENT - P3","STUDY",null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEMPLER","DICK TEMPLE","-","-","-","-","-","-","-",null,null,null,"TBD - TO BE DETERMINED"]
["CP16165","GILTNER HALL - ALTERATIONS TO CLASSROOM 146 AND ROOM 150","RELCON","815,000",815000,689711,null,null,null,null,null,null,"2016-07-11",null,100,null,null,null,"2017-05-15","2017-08-30",95,"2017-08-30","2018-05-30",null,"2018-05-30","2018-08-30",null,"HOPPERS","LISA SUDIA","PENNOCKK","LOCKWOODC","WAHLT","GARDNERM","HOPPERS","KLANND","GOTTSCHALK","LAURIE BRINKER","PETER BASSO ASSOCIATES INC","LAUX CONSTRUCTION COMPANY","TBD - TO BE DETERMINED"]
["CP17133","SCIENCE, TECHNOLOGY, ENGINEERING AND MATHEMATICS - CONSTRUCT ORIGINAL BUILDING","IN DES","72,500,000",72500000,347080,null,null,null,null,null,null,"2017-06-29","2018-03-30",1,null,null,null,null,null,null,null,null,null,null,null,null,"GOTTSCHALK","BARBARA KRANZ","KASDORFJ","LOCKWOODC","KINNEYD","GARDNERM","HOPPERS","HALSEYG","GOTTSCHALK","ROBIN MCVAY",null,null,"CM - CONSTRUCTION MANAGER"]
["CP14385","STEAM DISTRIBUTION - INFRASTRUCTURE IMPROVEMENTS - EAST CAMPUS LOOP","STUDY","100,000",100000,20394,null,null,null,null,null,null,"2014-12-01","2015-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,"GARDNERM","ROBERT NESTLE","-","-","-","TROTTERM","GARDNERM","-","GARDNERM","ROBIN MCVAY","FISHBECK, THOMPSON, CARR & HUBER","-","GC - DESIGN BID & BUILD"]
["CP16174","VETERINARY MEDICAL CENTER-EQUINE - MCPHAIL RENOVATIONS TO ROOMS 2, 7 AND 9-21","RELCON","800,000",800000,7997,null,null,null,"2016-07-13","2016-09-19",100,"2016-10-17","2017-12-01",100,"2017-12-01","2017-12-14",100,"2018-01-15","2018-04-30",45,"2018-04-30","2019-01-30",null,"2019-01-30","2019-04-30",null,"POSTMAM","FAYE WATSON","KASDORFJ","-","-","-","HOPPERS","HOWARDK","POSTMAM","LAURIE BRINKER",null,"NIELSEN COML CONSTRUCTION","DB - DESIGN BUILD"]
["CP16238","WATER DISTRIBUTION - SMART WATER METERS 2016-2017","RELCON","767,000",767000,262002,null,null,null,null,null,null,"2016-08-23","2016-09-23",100,null,null,null,"2016-09-23","2017-09-23",20,"2017-09-23","2018-06-23",null,"2018-06-23","2018-09-23",null,"GOERGES","RICK JOHNSON","-","-","-","-","GOERGES","-","GOERGES",null,"IPF","IPF","DB - DESIGN BUILD"]
["CP15067","ELECTRICAL DISTRIBUTION - UPGRADE NORTHWEST ZONE","SUBSTCOMP","2,500,000",2500001,1261001,null,null,null,null,null,null,"2015-03-04","2015-10-01",100,"2016-03-22","2016-05-03",null,"2016-02-14","2016-08-31",98,"2016-08-31","2017-05-31",null,"2017-05-31","2017-08-31",null,"BONKJ","LYNDA BOOMER","-","-","WAHLT","-","-","BEACHK","NURENBERGJ","ROBIN MCVAY","IPF","IPF","DB - DESIGN BUILD"]
["CP17039","BUSINESS COLLEGE - EPPLEY - REPLACE RESTROOM PARTITIONS","SUBSTCOMP","16,000",16000,15431,null,null,null,null,null,null,"2017-02-27","2017-04-07",100,null,null,null,"2017-04-27","2017-06-02",99,"2017-06-05","2018-03-05",null,"2018-03-05","2018-06-05",null,"CHARLANDB","JOHN WAGNER","CHARLANDB","-","-","-","-","-","CHARLANDB",null,"IPF","PAYNE ROSSO COMPANY","GC - DESIGN BID & BUILD"]
["CP16090","ERICKSON HALL - ALTERATIONS TO ROOM 252","IN DES",null,null,null,null,null,null,null,null,null,"2016-03-11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PENNOCKK","JAKE LATHROP","PENNOCKK","-","-","-","-","-","-",null,"EAS","PP-BUILDING SERVICES","DB - DESIGN BUILD"]
["CP17109","CHEMISTRY - REPLACE ELEVATORS 1 AND 2","OUTBID","860,000",860000,186,null,null,null,null,null,null,"2017-05-24",null,null,"2017-12-08","2018-01-18",null,"2018-05-07","2018-11-23",null,"2018-11-23","2019-02-23",null,"2019-02-23","2019-11-23",null,"KASDORFJ","LYNDA BOOMER","KASDORFJ","-","-","-","-","-","-","ROBIN MCVAY",null,null,"DB - DESIGN BUILD"]
["CP16069","COMPUTER CENTER - ALTERATIONS TO ROOMS 509 AND 510","SUBSTCOMP","90,000",90000,43405,null,null,null,"2016-02-23","2016-04-08",100,"2016-09-08","2016-11-10",100,null,null,null,"2017-01-10","2017-03-31",98,"2017-03-31","2017-12-31",100,"2017-12-31","2018-03-31",null,"CHARLANDB","JAMIE COLLEEN PAYNE","CHARLANDB","-","-","-","-","-","VANAKENB",null,"ENGINEERING APPLICATIONS INC","IPF","DB - DESIGN BUILD"]
["CP17073","PACKAGING - ALTERATIONS TO ROOM 128 TO INSTALL INCLINE IMPACT TESTING MACHINE","IN DES","22,000",22000,1411,null,null,null,"2017-04-19","2017-06-03",100,"2017-06-08","2017-08-31",100,null,null,null,"2017-09-01","2018-03-31",80,null,null,null,null,null,null,"MULLENB","AARON WALWORTH","-","-","-","LEFEVREJ","-","-","-",null,"-",null,"TBD - TO BE DETERMINED"]
["CP17100","PATHWAYS - KELLOGG BIKE PATH","OUTBID","240,000",240000,344,null,null,null,null,null,null,"2017-05-22","2018-02-01",100,"2018-02-01","2018-02-15",null,"2018-05-07","2018-07-23",null,"2018-07-23","2019-04-23",null,"2019-04-23","2019-07-23",null,"KINNEYD","LYNDA BOOMER","-","-","KINNEYD","TROTTERM","-","HOWARDK","-",null,null,null,"TBD - TO BE DETERMINED"]
["CP17119","OLDS HALL - ALTERATIONS TO SUITE 101","SUBSTCOMP",null,20501,22475,null,null,null,"2017-06-02","2017-07-17",100,"2017-07-10","2017-08-10",100,null,null,null,"2017-08-21","2017-10-31",97,"2017-10-31","2018-07-31",null,"2018-07-31","2018-10-31",null,"O'BRIENI","LINDSAY GRAY","O'BRIENI","WHITBECKD","-","-","-","-","-",null,"IPF","NIELSEN COML CONSTRUCTION CO INC","TBD - TO BE DETERMINED"]
["CP17237","MULTI-PURPOSE ARENA - CONSTRUCT ORIGINAL BUILDING","STUDY",null,0,0,null,null,null,null,null,null,"2017-11-13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VANZEEJ",null,"KASDORFJ","-","KINNEYD","GARDNERM","HOPPERS","BEACHK","VANZEEJ",null,null,null,"TBD - TO BE DETERMINED"]
["CP11349","ROADS - WILSON ROAD EXTENSION","OUTBID","11,100,000",11100000,1098979,null,null,null,null,null,null,"2015-10-20","2017-10-16",100,"2017-10-16","2017-11-13",null,"2018-03-15","2018-11-15",null,"2018-11-15","2019-08-15",null,"2019-08-15","2019-11-15",null,"WILBERD","SCOTT GARDNER","LEFEVREJ","-","WILBERD","TROTTERM","GARDNERM","BEACHK","LINEBAUGHA","ROBIN MCVAY","WADE TRIM",null,"GC - DESIGN BID & BUILD"]
["CP16187","SEWER DISTRIBUTION - MODIFY STORM SEWER AT MANLY MILES LOT 86","SUBSTCOMP","650,000",650000,649991,null,null,null,null,null,null,"2016-07-21","2017-04-05",100,"2017-04-05","2017-04-26",null,"2017-05-30","2017-07-07",97,"2017-07-28","2018-04-30",null,"2018-04-30","2018-07-30",null,"WILBERD","LYNDA BOOMER","-","-","WILBERD","LEFEVREJ","-","-","BARNESC","LAURIE BRINKER","FISHBECK, THOMPSON, CARR & HUBER","CENTRAL EXCAVATING LLC","DB - DESIGN BUILD"]
["CP17196","COMPUTER CENTER - ALTERATIONS TO ROOMS 120, 201, 212, 315, 316, 317, 405 AND 514","SUBSTCOMP","561,777",568000,116026,null,null,null,null,null,null,"2017-09-29","2017-10-23",100,null,null,null,"2017-10-23","2017-11-17",97,"2017-11-17","2018-08-17",0,"2018-08-17","2018-11-17",0,"VANZEEJ","JAMIE PAYNE","PENNOCKK",null,null,null,null,null,"VANZEEJ","LAURIE BRINKER",null,"GRANGER","DB - DESIGN BUILD"]
["CP17000","DATA CENTER - INSTALL LOAD BANK","SUBSTCOMP","200,000",200000,142300,null,null,null,null,null,null,"2017-01-05","2017-03-31",null,null,null,null,"2017-05-08","2017-12-31",97,"2017-12-31","2018-09-30",null,"2018-09-30","2018-12-31",null,"GARDNERM","BARB KRANZ","-","-","WILBERD","GARDNERM","-","BEACHK","BARNESC","EARLINE SOLOMON",null,"ASCO POWER TECHNOLOGIES LP","CM - CONSTRUCTION MANAGER"]
["CP17065","WATER DISTRIBUTION - EAST CAMPUS WATER MAIN LOOP","RELCON","985,000",985000,855442,null,null,null,null,null,null,"2017-04-05","2017-04-05",null,null,null,null,"2017-05-01","2017-09-30",95,"2017-09-30","2018-06-30",null,"2018-06-30","2018-09-30",null,"GARDNERM","LYNDA BOOMER","-","-","WILBERD","TROTTERM","-","-","GARDNERM","LAURIE BRINKER","IPF","CLARK-ROCKFORD JOINT VENTURE","CM - CONSTRUCTION MANAGER"]
["CP17114","STEAM DISTRIBUTION - 17-18 MAJOR REPAIRS TO CAMPUS STEAM TUNNEL PIPE SUPPORTS AND ANCHORS","IN DES","840,000",840000,0,null,null,null,null,null,null,"2017-05-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GARDNERM","LYNDA BOOMER","-","-","-","TROTTERM","GARDNERM","-","LINEBAUGHA","ROBIN MCVAY",null,null,"DB - DESIGN BUILD"]
["CP13275","LIBRARY - IMPLEMENT ENERGY CONSERVATION MEASURES","SUBSTCOMP","792,000",792000,255269,null,null,null,null,null,null,"2013-09-26","2016-04-01",100,null,null,null,"2016-12-01","2017-12-30",97,"2017-12-30","2018-09-15",null,"2018-09-15","2018-12-15",null,"FRANCISD","DAN BOLLMAN","-","-","-","-","GOERGES","BEACHK","WILSONT","ROBIN MCVAY","CTRE INC","IPF","DB - DESIGN BUILD"]
["CP17044","MSU COLLEGE OF LAW - ALTERATIONS TO ROOMS 200 AND 215-221","SUBSTCOMP","400,000",400000,389554,null,null,null,null,null,null,"2017-03-08","2017-05-15",100,null,null,null,"2017-05-15","2017-08-25",97,"2017-08-25","2018-05-25",null,"2018-05-25","2018-08-25",null,"RHODESA","ANDREW MIDGLEY","KASDORFJ","WHITBECKD","WHITBECKD","-","GOERGES","HOWARDK","RHODESA","LAURIE BRINKER","WTA ARCHITECTS","NIELSEN CONSTRUCTION","TBD - TO BE DETERMINED"]
["CP17149","CHM-FLINT - RENOVATE MEZZANINE B","RELCON","996,000",996000,417686,null,null,null,null,null,null,"2017-07-17","2017-10-30",100,null,null,null,"2017-10-11","2018-03-15",35,null,null,null,null,null,null,"TEMPLER","BARBARA FORNEY","-","-","-","-","-","-","TEMPLER","LAURIE BRINKER",null,"SORENSEN GROSS CONSTRUCTION","TBD - TO BE DETERMINED"]
["CP17157","PLANT AND SOIL SCIENCE - ALTERATIONS TO SUITE A494, ROOMS A496, A498, A498A-E","RELCON","185,000",185000,18500,null,null,null,"2017-07-26","2018-02-09",null,"2017-12-20","2018-02-08",100,null,null,null,"2018-02-12","2018-05-30",5,"2018-05-30","2019-02-12",null,"2019-02-12","2019-05-12",null,"KRAMERN","GEORGE SMITH","KRAMERN","-","-","-","HOPPERS","PRIDEM","KRAMERN",null,null,"IPF","TBD - TO BE DETERMINED"]
["CP17222","PARKING RAMP 1-SHAW LANE - ANNUAL MAINTENANCE 2018","IN DES",null,null,null,null,null,null,null,null,null,"2017-10-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GOTTSCHALKK","STEPHANIE O'DONNELL","-","-","-","GARDNERM","-","-","GOTTSCHALKK",null,null,null,"TBD - TO BE DETERMINED"]
["CP16182","VETERINARY MEDICAL CENTER - REPLACE HVAC-15 AT ANATOMY LAB","RELCON","320,000",750000,0,null,null,null,null,null,null,"2016-07-21","2017-12-30",100,"2017-01-10","2018-02-01",100,"2018-06-18","2018-08-17",0,"2018-08-17","2019-05-17",0,"2019-05-17","2019-08-17",0,"ANDERSONB","LYNDA BOOMER","ANDERSONB","-","-","-","ANDERSONB","HALSEYG","ANDERSONB","LAURIE BRINKER","IPF","SHAW-WINKLER","GC - DESIGN BID & BUILD"]
["CP16193","WHARTON - REPLACE ROOFS 1, 2, 3 AND 4","SUBSTCOMP","1,750,000",1750000,1380128,null,null,null,null,null,null,"2016-07-21","2017-01-06",100,"2017-01-09","2017-01-31",100,"2017-06-26","2017-09-22",97,"2017-09-22","2018-06-22",null,"2018-06-22","2018-09-22",null,"CHARLANDB","LYNDA BOOMER","CHARLANDB","-","-","-","-","-","KOLPJ","ROBIN MCVAY","ROOFING TECHNOLOGY ASSOCIATES, LTD","NATIONAL ROOFING AND SHEET METAL COMPANY","GC - DESIGN BID & BUILD"]
["CP16322","FOOD SAFETY TOXICOLOGY - ADD PCW PUMP #5 TO THE OS GENERATOR SYSTEM","STUDY",null,null,null,null,null,null,null,null,null,"2016-12-12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BEACHK","PAULA PALMITER","-","-","-","-","-","-","-",null,"IPF","-","TBD - TO BE DETERMINED"]
["CP17167","IM SPORTS-WEST - REPLACEMENT OF INDOOR TURF SURFACE IN ROOM 161","IN DES","3,300,000",3100000,3750,null,null,null,null,null,null,"2017-08-08",null,null,null,null,null,"2017-08-08","2018-08-30",null,null,null,null,null,null,null,"GARDNERM","LYNDA BOOMER","KASDORFJ","-","WAHLT","GARDNERM","HOPPERS","HOWARDK","VANZEEJ","ROBIN MCVAY","TMP","GRANGER CONSTRUCTION","DB - DESIGN BUILD"]
["CP17168","IM SPORTS-EAST - RENOVATIONS AND RESURFACE INDOOR TRACK","IN DES","2,150,000",4300000,2473,null,null,null,null,null,null,"2017-08-08",null,null,null,null,null,"2017-08-08","2018-08-30",null,null,null,null,null,null,null,"GARDNERM","LYNDA BOOMER","KASDORFJ","-","WAHLT","GARNDERM","HOPPERS","HALSEYG","VANZEEJ","ROBIN MCVAY",null,"GRANGER CONSTRUCTION","DB - DESIGN BUILD"]
["CP16124","TB SIMON POWER PLANT - PLANT MODERNIZATION","STUDY",null,null,null,null,null,null,null,null,null,"2016-04-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BARNESC","LYNDA BOOMER","-","-","WAHLT","-","-","BEACHK","BARNESC","ROBIN MCVAY","IPF","-","TBD - TO BE DETERMINED"]
["CP16338","WILSON HALL - ALTERATIONS TO VARIOUS SHOWERS","SUBSTCOMP","113,000",113000,51698,null,null,null,null,null,null,"2016-12-21","2017-03-15",100,"2017-04-01","2017-04-18",null,"2017-05-13","2017-08-31",97,"2017-08-31","2018-05-30",null,"2018-05-30","2018-08-30",null,"KASDORFJ","BILL WHITBECK","KASDORFJ","-","-","-","ANDERSONB","-","WILSONT",null,"IPF","MOORE TROSPER CONSTRUCTION","GC - DESIGN BID & BUILD"]
["CP17105","COMMUNICATION ARTS - 17-18 ENERGY CONSERVATION MEASURES","RELCON","260,000",260000,111611,null,null,null,null,null,null,"2017-05-24","2017-11-27",100,null,null,null,"2017-11-27",null,null,null,null,null,null,null,null,"FRANCISD","LYNDA BOOMER","-","-","-","-","FRANCISD","-","-","LAURIE BRINKER",null,"IPF","TBD - TO BE DETERMINED"]
["CP16249","BIOCHEMISTRY AND VARIOUS BUILDINGS - RESTROOM RENOVATIONS","RELCON","590,000",590000,538087,null,null,null,null,null,null,"2016-08-31","2017-03-10",100,"2017-03-06","2017-03-22",null,"2017-05-11","2018-01-31",95,"2018-01-31","2018-10-31",null,"2018-10-31","2019-01-31",null,"CHARLANDB",null,"CHARLANDB","-","-","-","FRANCISD","HOWARDK","CHARLANDB","LAURIE BRINKER","IPF","GRANGER CONSTRUCTION CO","GC - DESIGN BID & BUILD"]
["CP14168","ENG RESEARCH-HULETT RD - ADDITION 2 - FOOD PROCESSING INNOVATION CENTER","RELCON","5,400,000",5400000,3566441,null,null,null,null,null,null,"2014-06-03","2014-12-31",100,"2017-01-03","2017-01-24",100,"2017-04-16","2018-02-16",97,"2017-02-16","2018-09-16",null,"2018-09-16","2018-12-16",null,"RHODESA","DAN BOLLMAN","PENNOCKK","LOCKWOODC","WILBERD","LEFEVREJ","FRANCISD","BONKJ","RHODESA","ROBIN MCVAY","DAN VOS CONSTRUCTION COMPANY INC","DEMARIA BUILDING COMPANY INC","GC - DESIGN BID & BUILD"]
["CP16236","OLD BOTANY - BARRIER-FREE STUDY","STUDY",null,0,0,null,null,null,null,null,null,"2016-08-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PENNOCKK","LINDSAY GRAY","PENNOCKK","-","KINNEYD","-","-","-","-",null,"HOPKINSBURNS DESIGN STUDIO","-","TBD - TO BE DETERMINED"]
["CP16298","SPARTAN STADIUM - ADDITION 6 - SOUTH END ZONE","SUBSTCOMP","13,000,000",13000000,12554984,null,null,null,null,null,null,"2016-12-17","2017-04-30",100,null,null,null,"2017-02-18","2017-08-21",97,"2017-08-21","2018-05-21",null,"2018-05-21","2018-08-21",null,"GARDNERM","GREG IANNI","ABDEL-AZIMA","-","KINNEYD","GARDNERM","FRANCISD","BEACHK","VANZEEJ","ROBIN MCVAY","INTEGRATED DESIGN SOLUTIONS","GRANGER CONSTRUCTION CO","DB - DESIGN BUILD"]
["CP13308","DATA CENTER - BUSINESS CONTINUITY AND HIGH PERFORMANCE COMPUTING","SUBSTCOMP","46,000,000",46000000,36374419,null,null,null,null,null,null,"2016-05-02","2016-10-30",100,null,null,null,"2016-10-10","2018-03-31",97,"2018-03-31","2018-12-31",null,"2018-12-31","2019-03-31",null,"GARDNERM","DAN BOLLMAN","KASDORFJ","-","WILBERD","GARDNERM","FRANCISD/ANDERSONB","BEACHK","BARNESC","ROBIN MCVAY","CH2M HILL ENGINEERS INC","HOLDER CONSTRUCTION GROUP LLC","CM - CONSTRUCTION MANAGER"]
["CP17201","DOW FOUNDATION - CHILLER REPLACEMENT","RELCON","750,000",750000,693,null,null,null,null,null,null,"2017-10-03","2018-12-18",null,null,null,null,"2018-01-04","2018-04-04",null,"2018-04-05","2018-08-05",null,"2018-08-06","2018-12-30",null,"RHODESA","LYNDA BOOMER","-","-","-","-","FRANCISD","HOWARDK","RHODESA","LAURIE BRINKER","MCMILLIAN","SPENCE BROTHERS","TBD - TO BE DETERMINED"]
["CP14206","AKERS GOLF – INTERCOLLEGIATE GOLF COMPLEX  - CONSTRUCT ORIGINAL BUILDING","SUBSTCOMP","6,044,000",6044000,6123784,null,null,null,null,null,null,"2014-06-25","2015-05-01",100,"2015-03-16","2015-04-06",null,"2016-04-01","2016-12-31",98,"2016-03-11","2016-12-11",null,"2016-12-11","2017-03-11",null,"KASDORFJ","GREG IANNI","KASDORFJ","-","WAHLT","LEFEVREJ","FRANCISD","HOWARDK","WILSONT","ROBIN MCVAY","TMP ASSOCIATES INC","FRANK REWOLD AND SON INC","CM - CONSTRUCTION MANAGER"]
["CP16241","FEE HALL - ECM AND CONTROL IMPROVEMENTS","SUBSTCOMP","175,000",214000,202278,null,null,null,null,null,null,"2016-08-25","2016-11-10",100,"2016-11-10","2016-11-29",100,"2017-03-09","2017-05-30",97,"2017-05-30","2017-08-30",null,"2017-05-30","2017-08-30",null,"ANDERSONB","LYNDA BOOMER","-","-","-","-","ANDERSONB","-","ANDERSONB","EARLINE SOLOMON","IPF","SHAW-WINKLER INC","GC - DESIGN BID & BUILD"]
["CP16279","ERICKSON HALL - TECHNOLOGY UPGRADES TO ROOMS 133D AND 133E","RELCON","40,000",40000,24392,null,null,null,null,null,null,"2016-10-10","2017-04-11",100,null,null,null,"2017-06-01","2017-08-30",90,"2017-08-30","2018-05-30",null,"2018-05-30","2018-08-30",null,"KLANND","CHARLES RUGGIERO","-","-","-","-","-","KLANND","-",null,"IPF","IPF","DB - DESIGN BUILD"]
["CP17145","PACKAGING - INSTALL AUTOMATIC TRANSFER SWITCHGEAR","IN DES","200,000",0,0,null,null,null,null,null,null,"2017-07-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BEACHK","LYNDA BOOMER","-","-","-","-","-","BEACHK","BEACHK",null,"-","IPF PROJECT SERVICES","IPF - IPF SELF-PERFORMED"]
["CP16197","SHAW HALL - IMPLEMENT ENERGY CONSERVATION MEASURES","IN DES","300,000",300000,0,null,null,null,null,null,null,"2016-07-21","2017-10-01",7,null,null,null,null,null,null,null,null,null,null,null,null,"FRANCISD","LYNDA BOOMER","-","-","-","-","FRANCISD","-","TBD","LAURIE BRINKER","IPF",null,"TBD - TO BE DETERMINED"]
["CP18014","BRESLIN - UPGRADES TO WOMEN'S BASKETBALL LOCKER ROOM","IN DES",null,null,null,null,null,null,null,null,null,"2018-01-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VANZEEJ","GREG IANNI","BONKJ","-","-","-","HOPPERS","BONKJ","VANZEEJ",null,"ROSSETTI",null,"CM - CONSTRUCTION MANAGER"]
["CP16189","PACKAGING - REPLACEMENT OF AIR HANDLERS 4 AND 5","RELCON","800,000",940000,698061,null,null,null,null,null,null,"2016-07-21","2017-02-16",100,"2017-02-16","2017-02-23",100,"2017-04-10","2017-08-04",50,"2017-08-18","2018-05-18",null,"2018-05-18","2018-08-18",null,"ANDERSONB","LYNDA BOOMER","-","-","-","-","ANDERSONB","HOWARDK","ANDERSONB","LAURIE BRINKER","IPF","NIELSEN COML CONSTRUCTION CO INC","GC - DESIGN BID & BUILD"]
["CP17087","GILTNER HALL - ALTERATIONS TO ROOM 162","SUBSTCOMP","70,000",55000,47462,null,null,null,"2017-05-04","2017-06-18",100,"2017-06-01","2017-07-25",100,"2017-07-25","2017-08-09",100,"2017-08-28","2017-11-17",97,"2017-11-17","2018-02-17",null,"2018-02-17","2018-05-17",null,"CHARLANDB","LINDSEY BROWNLEE","CHARLANDB","-","-","-","GOERGES","HOWARDK","GOTTSCHALKK","EARLINE SOLOMON","IPF","NIELSEN COML CONSTRUCTION","GC - DESIGN BID & BUILD"]
["CP17247","SHAW LANE POWER PLANT - REUSE STUDY","STUDY",null,0,7600,null,null,null,null,null,null,"2017-12-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GOTTSCHALKK",null,"KASDORFJ","-","-","-","-","BEACHK","GOTTSCHALKK",null,null,null,"TBD - TO BE DETERMINED"]
["CP16042","ENG RESEARCH COMPLEX - ADDITION 4 AND RENOVATIONS (FRAUNHOFER LAB)","RELCON","6,700,000",6700000,4269939,null,null,null,null,null,null,"2016-02-05","2017-03-31",100,null,null,null,"2017-03-10","2018-03-30",60,"2018-03-30","2018-06-30",null,"2018-06-30","2019-03-30",null,"GOTTSCHALK","NESTOR DEOCAMPO","KASDORFJ","WHITBECKD","WILBERD","-","ANDERSONB","BEACHK","GOTTSCHALK","ROBIN MCVAY","C2AE","MILLER-DAVIS COMPANY","CM - CONSTRUCTION MANAGER"]
["CP18031","DOBIE TOWER TV/FM TRANS - REMOVE AND REPLACE LOOVER SYSTEM","IN DES",null,50000,323,null,null,null,"2018-01-30","2018-03-16",100,null,null,null,null,null,null,"2018-02-19","2018-03-15",null,"2018-03-15","2018-12-15",null,"2018-12-15","2019-03-15",null,"O'BRIENI","GARY BLIEVERNICHT",null,null,null,null,null,null,"O'BRIENI"]
["CP16214","LIFE SCIENCE - MAJOR HVAC STUDY","STUDY","150,000",150000,9950,null,null,null,null,null,null,"2016-08-04","2017-08-04",10,null,null,null,null,null,null,null,null,null,null,null,null,"HOPPERS","LYNDA BOOMER","-","-","-","-","HOPPERS","-","-",null,"PETER BASSO ASSOCIATES INC","-","DB - DESIGN BUILD"]
["CP16128","INTERNATIONAL CENTER - REVITALIZATION PROJECT","IN DES","4,000,000",4000000,222782,null,null,null,null,null,null,"2016-05-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POSTMAM","LYNDA BOOMER","PENNOCKK","-","-","-","FRANCISD","HOWARDK","POSTMAM","ROBIN MCVAY","INTEGRATED DESIGN SOLUTIONS","GRANGER CONSTRUCTION","CM - CONSTRUCTION MANAGER"]
["CP16163","UNIV RESEARCH CONTAINMENT - FEASIBILITY STUDY FOR ABSL-3/ACL-3 CONTAINMENT","STUDY","300,000",300000,41874,null,null,null,null,null,null,"2016-07-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOPPERS","JAMIE WILLARD","KASDORFJ","-","-","-","HOPPERS","HOWARDK","KRAMERN",null,"PETER BASSO ASSOCIATES INC","-","TBD - TO BE DETERMINED"]
["CP16202","BIOCHEMISTRY - REPLACE WINDOWS","IN DES","1,600,000",1600000,48596,null,null,null,null,null,null,"2016-07-27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PENNOCKK","LYNDA BOOMER","PENNOCKK","LOCKWOODC","WAHLT","-","-","-","BARNESC","ROBIN MCVAY","HAMILTON ANDERSON","TOOLES","CM - CONSTRUCTION MANAGER"]
["CP14362","GRAND RAPIDS PRESS BUILDING - DEMOLITION","SUBSTCOMP","1,200,000",3000000,661944,null,null,null,null,null,null,"2014-11-12","2015-03-01",null,null,null,null,"2015-03-01","2015-12-30",97,"2015-06-17","2016-07-16",null,"2016-07-16","2016-10-16",null,"TEMPLER","JACK MUMMA","TEMPLER","-","-","-","-","-","MORGANM","ROBIN MCVAY","SMITHGROUP JJR INC","DEMOLITIAN CONTRACTORS INC","CM - CONSTRUCTION MANAGER"]
["CP17017","BIOMEDICAL PHYSICAL SCIENCES -  RENOVATION TO LAB 1219","SUBSTCOMP","480,000",479999,396040,null,null,null,null,null,null,"2017-01-26","2017-02-25",100,null,null,null,"2017-05-01","2017-08-01",97,"2017-08-01","2018-05-01",null,"2018-05-01","2018-08-01",null,"HOPPERS","MARC CONLIN","KRAMERN","-","-","-","HOPPERS","PRIDEM","KRAMERN","LAURIE BRINKER","PETER BASSO ASSOCIATES INC","NIELSEN COML CONSTRUCTION CO INC","TBD - TO BE DETERMINED"]
["CP18033","TB SIMON POWER PLANT - DISTRIBUTION BUS RELIABILITY AND EXPANSION","IN DES","1,300,000",0,1167,null,null,null,null,null,null,"2018-01-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JOHNSONR","BOB ELLERHORST","-","-","-","-","-","BEACHK","JOHNSONR",null,"BLACK & VEATCH",null,"IPF - IPF SELF-PERFORMED"]
["CP17189","DETROIT INNOVATION AND LEARNING CENTER - CONSTRUCT ORIGINAL BUILDING","IN DES","200,000",0,2806,null,null,null,null,null,null,"2017-09-07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TROOSTS","BARB KRANZ","-","-","-","-","-","-","DURKINK",null,"JW DESIGN, LLC"]
["CP17028","PLANT AND SOIL SCIENCE - ALTERATIONS TO ROOMS A261 AND B131","IN DES","872,000",750000,8334,null,null,null,"2017-02-09","2017-03-26",100,"2017-07-26","2018-03-01",90,null,null,null,"2018-03-15","2018-08-01",null,"2018-08-01","2019-05-01",null,"2019-05-01","2019-08-01",null,"KRAMERN","GEORGE SMITH","KRAMERN","WHITBECKD","-","-","HOPPERS","PRIDEM","KRAMERN","LAURIE BRINKER","TMP",null,"TBD - TO BE DETERMINED"]
["CP17029","STUDENT SERVICES - ALTERATIONS TO SUITE 110","RELCON","185,000",185000,193184,null,null,null,"2017-02-15","2017-04-01",100,"2017-06-15","2017-09-22",100,null,null,null,"2017-09-29","2017-12-21",10,"2017-12-21","2018-09-21",null,"2018-09-21","2018-12-21",null,"CHARLANDB","KATHLEEN SMITH","CHARLANDB","TBD","-","-","FRANCISD","HOWARDK","VANAKENB",null,"IPF/EAI","IPF","IPF - IPF SELF-PERFORMED"]
["CP15200","UNION - IMPLEMENT ENERGY CONSERVATION MEASURES","SUBSTCOMP","658,514",659000,581312,null,null,null,null,null,null,"2015-08-14","2016-10-01",100,"2016-10-06","2016-10-27",100,"2016-11-01","2017-08-01",97,"2017-08-01","2018-05-01",null,"2018-05-01","2018-08-01",null,"RHODESA","LYNDA BOOMER","-","-","-","-","FRANCISD","-","RHODESA","LAURIE BRINKER","PETER BASSO ASSOCIATES INC","NIELSEN COML CONSTRUCTION CO INC","GC - DESIGN BID & BUILD"]
["CP16276","CLINICAL CENTER-ANIMAL - ALTERATIONS TO ROOMS CM125, CM213 AND CM224","SUBSTCOMP","300,000",300000,291963,null,null,null,null,null,null,"2016-10-06","2017-01-16",100,"2017-01-16","2017-01-16",100,"2017-01-17","2017-04-30",97,"2017-04-30","2018-01-30",null,"2018-01-30","2018-04-30",null,"HOPPERS","JR HAYWOOD","-","-","-","-","HOPPERS","-","HOPPERS","LAURIE BRINKER","PETER BASSO ASSOCIATES INC","CLARK CONSTRUCTION COMPANY","DB - DESIGN BUILD"]
["CP14148","FRIB - ADDITION 16 - OFFICE","RELCON","29,400,000",29400000,628571,null,null,null,null,null,null,"2014-08-01","2015-02-28",null,null,null,null,"2015-03-01","2016-04-30",1,"2016-04-30","2016-07-31",null,"2016-07-31","2017-03-31",null,"BULLB",null,"BULLB","-","-","-","-","-","BULLB",null,"TBD",null,"CM - CONSTRUCTION MANAGER"]
["CP16049","DOW FOUNDATION - STEM LEARNING CENTER","SUBSTCOMP","881,740",881740,735326,null,null,null,null,null,null,"2016-02-04","2016-06-25",100,null,null,null,"2016-10-03","2017-01-09",97,"2017-04-15","2018-01-15",null,"2018-01-15","2018-04-15",null,"RHODESA","BARB KRANZ","RHODESA","-","-","-","-","-","RHODESA","LAURIE BRINKER","WTA ARCHITECTS","SPENCE BROTHERS","GC - DESIGN BID & BUILD"]
["CP16340","VETERINARY MEDICAL CENTER - MECHANICAL CAPITAL RENEWAL FOR SUITE E100","SUBSTCOMP","525,000",525000,370717,null,null,null,null,null,null,"2016-12-22","2017-02-28",100,null,null,null,"2017-03-22","2018-09-21",85,"2018-09-21","2018-11-25",null,"2018-11-25","2019-02-28",null,"GOTTSCHALK","LYNDA BOOMER","-","-","-","-","FRANCISD","KLANND","GOTTSCHALK","LAURIE BRINKER","CTRE INC","GRANGER CONSTRUCTION CO","CM - CONSTRUCTION MANAGER"]
["CP16216","MUSIC - REPLACE HV 1, 3 AND 4 - STUDY","STUDY","75,000",75000,19331,null,null,null,null,null,null,"2016-08-04","2017-08-04",10,null,null,null,null,null,null,null,null,null,null,null,null,"HOPPERS","LYNDA BOOMER","-","-","-","-","HOPPERS","-","-","JANNENE ANDREWS","PETER BASSO ASSOCIATES INC/TMP ASSOCIATES INC","-","DB - DESIGN BUILD"]
["CP14149","T.B. SIMON POWER PLANT - SWITCH HOUSE - CONSTRUCT ORIGINAL BLDG & ELECT CONNECTION TO POWER PLANT","IN DES","11,500,000",11500000,253996,null,null,null,null,null,null,"2014-09-01","2015-11-30",null,null,null,null,"2015-01-01","2016-01-31",null,"2016-01-31","2016-09-30",null,"2016-09-30","2017-03-31",null,"FRAZEER",null,"-","-","-","-","-","FRAZEER","-",null,"BLACK & VEATCH",null,"CM - CONSTRUCTION MANAGER"]
["CP17220","PARKING RAMP 3-WHARTON - ANNUAL MAINTENANCE 2018","IN DES",null,null,null,null,null,null,null,null,null,"2017-10-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GOTTSCHALKK","STEPHANIE O'DONNELL","-","-","-","GARDNERM","-","-","GOTTSCHALKK",null,null,null,"TBD - TO BE DETERMINED"]
["CP15198","ERICKSON HALL - IMPLEMENT ENERGY CONSERVATION MEASURES","RELCON","225,000",226500,245389,null,null,null,null,null,null,"2015-08-14","2016-02-28",100,null,null,null,"2016-02-28","2017-09-01",61,"2017-09-01","2018-06-01",null,"2018-06-01","2018-09-01",null,"FRANCISD","LYNDA BOOMER","-","-","-","-","GOERGES","-","SEDDOND",null,"IPF","IPF","DB - DESIGN BUILD"]
["CP14123","BRESLIN - BERKOWITZ - RENOVATIONS TO BASKETBALL OFFICES","SUBSTCOMP","3,800,000",3800000,3440391,null,null,null,null,null,null,"2014-04-25","2015-03-01",100,"2015-03-17","2015-03-31",null,"2015-04-20","2015-08-21",98,"2015-08-28","2016-08-28",null,"2016-08-28","2017-08-31",null,"DURKINK","GREG IANNI","KASDORFJ","WHITBECKD","WAHLT","-","HOPPERS","BONKJ","VANZEEJ","ROBIN MCVAY","INTEGRATED DESIGN SOLUTIONS","IPF","ICM - INTERNAL CONSTRUCTION MANAGER"]
["CP15139","TB SIMON POWER PLANT - COAL YARD RESTORATION STUDY","STUDY",null,null,null,null,null,null,null,null,null,"2015-06-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BARNESC","BOB ELLERHORST","-","-","WILBERD","LEFEVREJ","-","-","BARNESC",null,"IPF","-","TBD - TO BE DETERMINED"]
["CP16086","WATER TREATMENT PLANT AND TOWER - CONSTRUCT ORIGINAL BUILDNGS","IN DES","23,000,000",23000000,519463,null,null,null,null,null,null,"2016-12-16","2018-02-28",95,"2018-04-10","2018-04-10",null,"2018-06-20","2019-12-15",null,null,null,null,"2019-12-15","2020-12-15",null,"NESTLER","MIKE TRACY","ABDEL-AZIM","-","WILBERD","GARDNERM","FRANCISD","BEACHK","BARNESC","ROBIN MCVAY","FISHBECK, THOMPSON, CARR & HUBER",null,"GC - DESIGN BID & BUILD"]
["CP16263","PARKING RAMP 1-SHAW LANE - STRUCTURAL REPAIR 2016","SUBSTCOMP","225,000",223625,175624,null,null,null,null,null,null,"2016-09-19","2016-11-01",null,null,null,null,"2016-09-07","2017-03-15",65,"2016-03-15","2017-07-01",null,"2018-02-01","2018-05-03",null,"RHODESA","LYNDA BOOMER","-","-","-","LEFEVREJ","-","-","RHODESA","EARLINE SOLOMON","RAM CONSTRUCTION SERVICES OF MICH INC","GRANGER CONSTRUCTION CO","GC - DESIGN BID & BUILD"]
["CP17064","BIO ENGINEERING - ALTERATIONS TO ROOMS 1230 AND 1702","IN DES",null,532660,77344,null,null,null,"2017-04-05","2017-07-31",100,"2017-08-22","2017-10-09",100,null,null,null,null,null,null,null,null,null,null,null,null,"O'BRIENI","PAULA PALMITER","O'BRIENI","-","-","-","-","-","O'BRIENI","LAURIE BRINKER","INTEGRATED DESIGN SOLUTIONS",null,"TBD - TO BE DETERMINED"]
["CP17206","PARKING RAMP 4-KELLOGG - MAINTENANCE SPRING 2018","STUDY",null,null,null,null,null,null,null,null,null,"2017-10-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RHODESA","DANIEL CLINE","-","-","-","GARDNERM","-","-","RHODESA",null,null,null,"TBD - TO BE DETERMINED"]
["CP15267","PARKING - LOT 63 - BRESLIN","SUBSTCOMP","1,500,000",1500000,1397565,null,null,null,null,null,null,"2015-10-21","2016-04-30",100,"2016-05-15","2016-05-15",100,"2017-06-01","2017-08-25",97,"2017-08-25","2018-05-25",null,"2018-05-25","2018-08-25",null,"VANZEEJ",null,"-","-","KINNEYD","GARDNERM","-","BONKJ","VANZEEJ","LAURIE BRINKER","ROSSETTI ASSOCIATES INC","BARTON MALOW COMPANY","CM - CONSTRUCTION MANAGER"]
["CP16103","JENISON FIELDHOUSE - RENOVATIONS","IN DES","6,000,000",6000000,370500,null,null,null,null,null,null,"2016-03-28","2017-09-30",30,null,null,null,null,null,null,null,null,null,null,null,null,"KASDORFJ","LINDA BAUGHMAN","KASDORFJ","-","-","-","HOPPERS","HOWARDK","POSTMAM","ROBIN MCVAY","INTEGRATED ARCHITECTURE","MILLER-DAVIS COMPANY","CM - CONSTRUCTION MANAGER"]
["CP17209","CASE HALL - ALTERATIONS TO ROOMS 335A, 335B AND 336","IN DES","270,000",270000,0,null,null,null,null,null,null,"2017-10-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KLANND","LISA SUDIA","-","LOCKWOODC","-","-","-","KLANND",null,"LAURIE BRINKER",null,"IPF","TBD - TO BE DETERMINED"]
["CP16188","SITE FURNISHINGS - SECURITY FENCING AROUND TB SIMON POWER PLANT","IN DES","750,000",750000,6800,null,null,null,null,null,null,"2017-10-13","2018-09-07",35,"2018-09-10","2018-09-21",null,"2018-10-08","2019-03-29",null,"2019-03-29","2019-12-31",null,"2019-12-31","2020-03-31",null,"BARNESC","LYNDA BOOMER","-","-","WAHLT","-","-","-","WAHLT","LAURIE BRINKER","TBD","TBD","ICM - INTERNAL CONSTRUCTION MANAGER"]
["CP15105","ELECTRICAL DISTRIBUTION - CAMPUS RENEWABLE ENERGY","SUBSTCOMP","2,500,000",2500001,2344021,null,null,null,null,null,null,"2015-04-08","2017-03-28",100,null,null,null,"2017-03-04","2017-12-31",97,"2017-12-31","2018-09-30",null,"2018-09-30","2018-12-31",null,"BARNESC","LYNDA BOOMER","-","-","WILBERD","-","-","BEACHK","BARNESC","ROBIN MCVAY","BLACK AND VEATCH LTD OF MICHIGAN","ALTERRA","DB - DESIGN BUILD"]
["CP15069","ANGELL UNIVERSITY SERVICES - ALTERATIONS TO SUITES 100 AND 101","SUBSTCOMP","850,000",943521,223010,null,null,null,null,null,null,"2017-06-12","2017-09-27",100,"2017-09-28","2017-10-19",100,"2017-11-27","2018-01-31",75,"2018-01-31","2018-10-31",null,"2018-10-31","2019-01-30",null,"POSTMAM","GLEN DEYOUNG","CHARLANDB","WHITBECKD","-","-","FRANCISD","HOWARDK","POSTMAM","ROBIN MCVAY","IPF/EAI","MOORE-TROSPER CONSTRUCTION CO.","DB - DESIGN BUILD"]
["CP14110","BRESLIN - ADDITION NO. 2","SUBSTCOMP","50,000,000",50000000,48956519,null,null,null,null,null,null,"2015-04-16","2015-11-30",100,"2015-09-11","2015-11-11",100,"2016-01-01","2017-08-28",97,"2017-08-28","2018-02-01",null,"2018-02-01","2018-05-01",null,"BONKJ","BILL WHITBECK","ABDEL-AZIM","WHITBECKD","KINNEYD","TROTTERM","HOPPERS/ANDERSONB","BONKJ","VANZEEJ","LAURIE BRINKER","ROSSETTI ASSOCIATES INC","BARTON MALOW COMPANY","CM - CONSTRUCTION MANAGER"]
["CP15022","ENGINEERING - ADDITION 5 - ALTERATIONS TO SUITE 1515","SUBSTCOMP","7,800,000",7800000,7282121,null,null,null,null,null,null,"2015-01-23","2015-12-19",100,null,null,null,"2016-01-15","2016-07-31",97,"2016-08-19","2017-10-31",null,"2017-10-31","2018-01-31",null,"WILSONT","BARBARA KRANZ","KASDORFJ","WHITBECKD","KINNEYD","LEFEVREJ","ANDERSONB","BEACHK","WILSONT","ROBIN MCVAY","NIAGARA MURANO","CHRISTMAN COMPANY","CM - CONSTRUCTION MANAGER"]
["CP16195","WELLS HALL - REPLACE INDUCTION UNITS IN BUILDING SECTIONS C AND D","IN DES","6,000,000",6000000,54170,null,null,null,null,null,null,"2017-02-06","2017-10-31",70,null,null,null,"2017-10-31","2018-12-31",null,"2018-12-31","2019-06-30",null,"2019-06-30","2019-09-30",null,"WILSONT","LYNDA BOOMER","-","-","-","-","FRANCISD","-","WILSONT","ROBIN MCVAY","PETER BASSO ASSOCIATES","MILLER DAVIS","CM - CONSTRUCTION MANAGER"]
["CP17250","DUFFY DAUGHERTY-SAAC - ENCLOSE SKANDALARIS CENTER ROOFTOP PATIO","STUDY",null,0,0,null,null,null,null,null,null,"2017-12-14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VANZEEJ","GREG IANNI","KASDORFJ","-","KINNEYD","-","HOPPERS","BONKJ","VANZEEJ",null,null,null,"TBD - TO BE DETERMINED"]
["CP17088","OLIN HEALTH CENTER - THIRD FLOOR WINDOW AIR CONDITIONER REPLACEMENTS","IN DES",null,null,null,null,null,null,null,null,null,"2017-05-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ABDEL-AZIM","LINDSAY GRAY","ABDEL-AZIM","-","-","-","WILSONT","-","WILSONT",null,null,null,"TBD - TO BE DETERMINED"]
["CP16118","BUSINESS COLLEGE - ALTERATIONS TO DEAN'S SUITE ROOMS N516-N520","IN DES","850,000",850000,694,null,null,null,"2016-04-14","2016-08-31",null,"2017-03-16","2017-10-20",10,null,null,null,null,null,null,null,null,null,null,null,null,"RHODESA","JOHN A WAGNER","ABDEL-AZIM","-","-","-","HOPPERS","HOWARDK","RHODESA","LAURIE BRINKER","FTCH",null,"TBD - TO BE DETERMINED"]
["CP16200","PLANT BIOLOGY - HVAC STUDY FOR LABORATORIES","STUDY","110,000",110000,655,null,null,null,null,null,null,"2016-07-25","2017-08-30",10,null,null,null,null,null,null,null,null,null,null,null,null,"ANDERSONB","LYNDA BOOMER","-","-","-","-","ANDERSONB","-","-","JANNENE ANDREWS","NOVUS ENVIRONMENTAL INC","-","DB - DESIGN BUILD"]
["CP17108","SPARTAN STADIUM - DOMESTIC WATER BOOSTER PUMP REPLACEMENT","RELCON","400,000",400000,96112,null,null,null,null,null,null,"2017-05-24","2017-08-08",100,null,null,null,"2017-08-08","2018-06-08",null,"2018-06-08","2018-07-14",null,"2018-07-14","2018-10-14",null,"FRANCISD","LYNDA BOOMER","-","-","-","-","FRANCISD","-","-","LAURIE BRINKER",null,"IPF","TBD - TO BE DETERMINED"]
["CP17165","SERVICE RD FIELD-RESTROOM & STORAGE - CONSTRUCT ORIGINAL BUILDING","IN DES","10,100,000",10100000,21940,null,null,null,null,null,null,"2017-08-08","2018-03-01",75,null,null,null,"2018-02-19","2018-08-17",null,"2018-08-18","2019-05-31",null,"2019-05-31","2019-08-16",null,"WAHLT","LYNDA BOOMER","KASDORFJ","-","WAHLT","GARDNERM","HOPPERS","BEACHK","VANZEEJ","ROBIN MCVAY",null,null,"DB - DESIGN BUILD"]
["CP18018","VETERINARY MEDICAL CENTER - A-WING - SECOND FLOOR LOCKER ROOM STUDY","STUDY",null,0,0,null,null,null,null,null,null,"2018-01-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POSTMAM","SEAN YANCEY","KASDORFJ","-","-","-","ANDERSONB","HALSEYG","POSTMAM",null,null,null,"TBD - TO BE DETERMINED"]
["CP14381","VETERINARY MEDICAL CENTER - ALTERATIONS TO ROOM A213","SUBSTCOMP","448,047",448047,397714,null,null,null,"2015-11-20","2016-01-04",100,"2016-09-26","2017-03-03",100,"2017-04-10","2017-04-27",100,"2017-06-01","2017-08-17",98,"2017-08-17","2018-05-17",98,"2018-05-17","2018-08-17",null,"POSTMAM","FAYE WATSON","KASDORFJ","WHITBECKD","-","-","-","KLANND","POSTMAM","LAURIE BRINKER","CAPITAL CONSULTANTS INC","MOORE-TROSPER CONSTRUCTION CO","GC - DESIGN BID & BUILD"]
["CP15032","LINTON HALL - ALTERATIONS TO RESTROOMS 213, 311, 322 AND 327","SUBSTCOMP","285,000",285000,306433,null,null,null,"2015-02-02","2015-04-30",100,"2015-05-26","2015-09-30",100,null,null,null,"2016-02-15","2017-03-30",97,"2017-03-30","2017-12-30",null,"2017-12-30","2018-03-30",null,"CHARLANDB","DEBRA MANSEL","CHARLANDB","WHITBECKD","-","-","GOSSELING","HOWARDK","VANAKENB","LAURIE BRINKER","IPF/CTRE INC","IPF","DB - DESIGN BUILD"]
["CP17033","COMMUNICATION ARTS - ALTERATIONS TO CLASSROOMS 151, 155, 161, 165, 171, 173 AND 175","IN DES","380,000",380000,1085,null,null,null,"2017-02-15","2017-04-01",null,"2017-08-28","2018-03-31",5,null,null,null,null,null,null,null,null,null,null,null,null,"KLANND","LISA SUDIA","-","LOCKWOODC","-","-","-","KLANND","-","LAURIE BRINKER",null,"IPF","DB - DESIGN BUILD"]
["CP17091","ELECTRICAL DISTRIBUTION - DAIRY RESEARCH COMPLEX","IN DES","2,000,000",2000000,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BEACHK","LYNDA BOOMER",null,"-","-","TROTTERM",null,"BEACHK","BELLD","ROBIN MCVAY","IPF - SELF PERFORMED","IPF - SELF PERFORMED","IPF - IPF SELF-PERFORMED"]
["CP14335","OYER SPEECH AND HEARING - VENTILATION AND LIGHTING ECM UPGRADES","RELCON","30,000",30000,10365,null,null,null,null,null,null,"2014-10-23","2017-05-01",100,null,null,null,"2017-05-15","2018-02-16",60,"2018-02-16","2018-12-18",null,"2018-12-18","2019-02-16",null,"ANDERSONB","LYNDA BOOMER","-","-","-","-","ANDERSONB","HOWARDK","ANDERSONB",null,"IPF","IPF","GC - DESIGN BID & BUILD"]
["CP17024","WELLS HALL - TECHNOLOGY UPGRADES IN ROOMS A108, A122, A130, A222, A228, A230, A232, A234 AND A308","RELCON","72,000",72000,48806,null,null,null,null,null,null,"2017-02-06","2017-03-28",100,null,null,null,"2017-05-30","2017-07-07",null,"2017-07-07","2018-04-20",null,"2018-04-20","2018-07-20",null,"KLANND","STEVE JOWETT","-","LOCKWOODC","-","-","-","KLANND","-",null,"IPF","IPF","DB - DESIGN BUILD"]
["CP17021","SPARTAN STADIUM - SOUTH END ZONE - CONCESSION STAND BUILD OUT","IN DES",null,0,68400,null,null,null,null,null,null,"2017-02-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GARDNERM","BILL WHITBECK","-","-","-","GARDNERM","FRANCISD","BEACHK","VANZEEJ","LAURIE BRINKER",null,null,"TBD - TO BE DETERMINED"]
["CP16220","STEAM DISTRIBUTION - VENTILATION FOR SECURITY WALKTHROUGHS","IN DES","350,000",350000,0,null,null,null,null,null,null,"2016-08-04","2017-05-30",15,null,null,null,null,null,null,null,null,null,null,null,null,"GARDNERM","LYNDA BOOMER","-","-","-","TROTTERM","-","-","GARDNERM","LAURIE BRINKER",null,null,"DB - DESIGN BUILD"]
["CP17229","VETERINARY MEDICAL CENTER - ALTERATIONS TO 2ND FLOOR A-BLDG LOCKER ROOMS","STUDY","1,500,000",1500000,0,null,null,null,"2017-10-31","2017-12-15",100,"2017-11-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POSTMAM","SEAN YANCEY","-","-","-","-","O'BRIENI","-","POSTMAM",null,null,null,"TBD - TO BE DETERMINED"]
["CP18003","BUSINESS COLLEGE - EPPLEY - ENERGY CONSERVATION MEASURES","IN DES","4,308,000",0,3343,null,null,null,null,null,null,"2018-01-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RHODESA","LYNDA BOOMER","ABDEL-AZIM","WHITBECKD","KINNEYD","TROTTERM","FRANCISD","HALSEYG","RHODESA","ROBIN MCVAY","FISHBECK, THOMPSON, CARR AND HUBER","CLARK CONSTRUCTION","CM - CONSTRUCTION MANAGER"]
["CP16172","BESSEY HALL - ALTERATIONS TO FIRST AND SECOND FLOORS","SUBSTCOMP","2,900,000",2900000,2110096,"2016-10-28","2016-11-22",100,null,null,null,"2016-11-22","2017-02-13",100,"2017-02-18","2017-03-13",100,"2017-05-08","2017-08-16",97,"2017-08-16","2018-05-16",98,"2018-05-16","2018-12-16",null,"POSTMAM","LISA SUDIA","PENNOCKK","LOCKWOODC","-","-","-","KLANND","POSTMAM","ROBIN MCVAY","MAYOTTE GROUP ARCHITECTS/CTRE INC","GRANGER CONSTRUCTION CO","CM - CONSTRUCTION MANAGER"]
["CP17202","SPARTAN STADIUM - REMOVAL OF NET POLES","STUDY",null,null,null,null,null,null,null,null,null,"2017-10-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BONKJ","LINDA BAUGHMAN","-","-","-","LEFEVREJ","-","-","VANZEEJ",null,null,null,"TBD - TO BE DETERMINED"]
["CP14319","HUBBARD HALL - REPLACE FREIGHT ELEVATOR","SUBSTCOMP","340,000",340000,339136,null,null,null,"2014-10-15","2014-11-29",null,"2016-01-15","2017-01-15",100,null,null,null,"2017-05-22","2017-08-11",99,"2017-08-11","2018-05-11",null,"2018-05-04","2018-08-04",null,"KASDORFJ","BILL WHITBECK","KASDORFJ","-","-","-","-","-","COOLC","LAURIE BRINKER","BERNATH-COAKLEY ASSOC ARCHITECT INC/ENGINEERING APPLICATIONS INC","NIELSEN COML CONSTRUCTION CO INC","TBD - TO BE DETERMINED"]
["CP17113","MUNN ICE ARENA - REPLACE FIRE ALARM SYSTEM","IN DES","675,000",675000,0,null,null,null,null,null,null,"2017-05-25","2017-12-31",25,null,null,null,null,null,null,null,null,null,null,null,null,"HOWARDK","LYNDA BOOMER","-","-","-","-","-","HOWARDK","-","ROBIN MCVAY",null,"IPF","DB - DESIGN BUILD"]
["CP16181","WATER DISTRIBUTION - REPLACE WATER SERVICE MAIN TO THE COMPUTER CENTER","SUBSTCOMP","470,000",470000,310005,null,null,null,null,null,null,"2016-07-21","2017-08-30",100,null,null,null,"2017-07-05","2017-08-11",97,"2017-08-11","2018-05-11",null,"2018-05-11","2018-08-11",null,"GARDNERM","LYNDA BOOMER","-","-","-","TROTTERM","GARDNERM","-","GARDNERM","LAURIE BRINKER","IPF","GRANGER CONSTRUCTION CO","DB - DESIGN BUILD"]
["CP15193","PARKING  - LOT 92 - RECONSTRUCTION AND EXPANSION","SUBSTCOMP","1,420,000",1420000,1270177,null,null,null,"2015-08-07","2015-09-21",null,"2015-09-14","2016-12-19",100,"2016-12-19","2017-01-16",100,"2017-05-08","2017-07-28",97,"2017-07-28","2018-04-25",null,"2018-04-25","2018-07-25",null,"WILBERD","STEPHANIE O'DONNELL","-","-","WILBERD","LEFEVREJ","-","-","BARNESC","ROBIN MCVAY","IPF","CAROL'S EXCAVATING INC","GC - DESIGN BID & BUILD"]
["CP15216","ELECTRICAL DISTRIBUTION - INSTALL FIELD LIGHTS AT DEMARTIN SOCCER STADIUM OLD COLLEGE FIELD","SUBSTCOMP","762,685",762685,735215,null,null,null,null,null,null,"2016-10-28","2017-03-24",100,null,null,null,"2017-03-02","2017-07-28",99,null,null,null,"2017-07-14","2017-12-31",null,"WAHLT","GREG IANNI","-","-","WAHLT","LEFEVREJ","-","BEACHK","WAHLT","LAURIE BRINKER","IPF","BARTON MALOW COMPANY","DB - DESIGN BUILD"]
["CP15055","ABRAMS PLANETARIUM - ADDITION 1 - CLASSROOM & CATERING","IN DES",null,2000000,10074,null,null,null,"2015-02-20","2015-04-06",100,"2018-02-14","2018-07-03",0,null,null,null,null,null,null,null,null,null,null,null,null,"VANZEEJ","MARC CONLIN","PENNOCKK","-","KINNEYD","TROTTERM","FRANCISD","HOWARDK","VANZEEJ","LAURIE BRINKER",null,null,"TBD - TO BE DETERMINED"]
["CP15204","REGIONAL CHILLED WATER PLANT - CONSTRUCT A RESTROOM","SUBSTCOMP","70,000",70000,99770,null,null,null,null,null,null,"2015-08-25","2015-11-15",100,null,null,null,"2016-06-15","2016-09-15",97,"2016-09-15","2017-06-15",null,"2017-06-15","2017-09-15",null,"KASDORFJ","BOB ADAMS","KASDORFJ","-","-","-","HOPPERS","HOWARDK","ADAMSR",null,"IPF","IPF","DB - DESIGN BUILD"]
["CP15206","LIBRARY - RENOVATIONS TO SECOND FLOOR FOR SPECIAL COLLECTIONS","STUDY",null,0,9408,null,null,null,null,null,null,"2016-10-03",null,null,null,null,null,null,null,null,null,null,null,"2017-02-28",null,null,"O'BRIENI","JIM HENSLEY","KASDORFJ","-","-","-","HOPPERS","-","GOTTSCHALK","LAURIE BRINKER","IPF/NIAGARA MURANO","-","TBD - TO BE DETERMINED"]
["CP15301","CLINCIAL CENTER-CLINIC - ALTERATIONS TO WOMEN'S RESTROOM A133","IN DES","40,000",35000,0,null,null,null,"2015-11-19","2016-01-03",100,"2018-02-02","2018-05-18",0,null,null,null,null,null,null,null,null,null,null,null,null,"CHARLANDB","ULRIC FULLER","CHARLANDB","-","-","-","ANDERSONB","HALSEYG",null,null,null,null,"TBD - TO BE DETERMINED"]
["CP16196","SEWER DISTRIBUTION - SANITARY AND STORM SEWER - REPAIR ALLOWANCE STUDY","STUDY","300,000",300000,25613,null,null,null,null,null,null,"2016-07-21",null,20,null,null,null,null,null,null,null,null,null,null,null,null,"TROTTERM","LYNDA BOOMER","-","-","KINNEYD","LEFEVREJ","-","-","-","LAURIE BRINKER","IPF","IPF","TBD - TO BE DETERMINED"]
["CP16207","PLANT BIOLOGY - ALTERATIONS TO ROOMS 37, 37A AND 38A","RELCON","140,000",140000,14000,null,null,null,"2017-04-19","2017-06-03",100,"2017-06-29","2017-10-30",100,null,null,null,"2017-11-01","2018-02-28",35,"2018-02-28","2018-11-30",null,"2018-11-30","2019-02-28",null,"KRAMERN","DARLENE JOHNSON","CHARLANDB","-","-","-","HOPPERS","PRIDEM","KRAMERN",null,null,"IPF","IPF - IPF SELF-PERFORMED"]
["CP17012","PARKING - LOT 111 - WOODLOT DRIVE - ORIGINAL CONSTRUCTION","IN DES",null,0,25460,null,null,null,null,null,null,"2017-01-20","2018-02-15",10,"2018-03-01","2018-04-05",null,"2018-05-07","2018-12-01",null,"2018-12-01","2019-09-01",null,"2019-09-01","2019-12-01",null,"WILBERD","STEPHANIE O'DONNELL","-","-","CAOY","TROTTERM","-","HALSEYG","COOLC","LAURIE BRINKER",null,null,"CM - CONSTRUCTION MANAGER"]
["CP16287","MUSIC - ADD SUPPLEMENTAL COOLING IN ROOM 128","IN DES","36,000",50000,0,null,null,null,"2016-10-19","2016-12-03",null,"2016-12-12",null,46,null,null,null,null,null,null,null,null,null,null,null,null,"WILSONT","CHARLES ROBERTS","-","-","-","-","FRANCISD","-","WILSONT",null,null,null,"TBD - TO BE DETERMINED"]
["CP13156","GRAND RAPIDS RESEARCH CENTER - CONSTRUCT ORIGINAL BUILDING","SUBSTCOMP","85,100,000",85100000,79835875,null,null,null,null,null,null,"2014-01-17","2015-04-30",100,null,null,null,"2015-02-15","2017-07-15",97,"2017-11-01","2017-12-01",null,"2018-09-01","2018-12-01",null,"TEMPLER","DAN BOLLMAN","TEMPLER","WHITBECKD","-","-","NGUYENP","BONKJ","MORGANM","ROBIN MCVAY","SMITHGROUP JJR INC","CLARK/ROCKFORD JOINT VENTURE","CM - CONSTRUCTION MANAGER"]
["CP14079","NATURAL AREAS - FLOOD RESPONSE PLAN MEASURES - BRODY COMPLEX","STUDY",null,null,null,null,null,null,null,null,null,"2014-03-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GARDNERM","JOE PETROFF","-","-","-","TROTTERM","GARDNERM","-","-",null,"IPF","-","TBD - TO BE DETERMINED"]
["CP17161","BRESLIN - SOUND SYSTEM FEASIBILITY STUDY","STUDY",null,0,259,null,null,null,null,null,null,"2017-08-03","2018-08-03",null,null,null,null,null,null,null,null,null,null,null,null,null,"BONKJ","SUE BRANDT","-","-","-","-","-","BONKJ",null,null,"ANTHONY JAMES PARTNERS LLC",null,"TBD - TO BE DETERMINED"]
["CP16083","ATHLETIC FIELDS - RALPH YOUNG TRACK - REPLACE FIELD HOCKEY PLAYING SURFACE","SUBSTCOMP","1,450,000",1450000,1241024,null,null,null,null,null,null,"2016-03-09","2017-04-30",100,null,null,null,"2017-05-15","2017-08-01",97,null,null,null,"2018-08-01","2018-11-01",null,"WAHLT","LINDA BAUGHMAN","-","-","WAHLT","-","-","BONKJ","VANZEEJ","ROBIN MCVAY","SPORTS FIELDS INC","IPF","ICM - INTERNAL CONSTRUCTION MANAGER"]
["CP17116","PATHWAYS - ADA TRANSITION PLAN - SHAW LANE","RELCON","681,000",681000,518654,null,null,null,null,null,null,"2017-05-26","2018-06-23",75,null,null,null,"2017-05-26","2018-06-30",75,"2018-06-30","2019-03-30",null,"2019-03-30","2018-10-26",null,"WILBERD","LYNDA BOOMER","-","-","WILBERD","-","-","-","-","LAURIE BRINKER",null,null,"TBD - TO BE DETERMINED"]
["CP14092","VETERINARY MEDICAL CENTER - TEMPORARY COOLING FOR ROOM A222B","IN DES","18,500",18500,0,null,null,null,"2014-04-04","2014-08-31",100,"2014-08-15","2015-07-12",70,"2015-07-12","2015-07-27",null,null,null,null,null,null,null,null,null,null,"FRANCISD","RUSS SOMERS","-","-","-","-","FRANCISD","-","POSTMAM",null,"EAS","PP-PROJECT SERVICES","DB - DESIGN BUILD"]
["CP17001","COMMUNICATION AND ELECTRICAL DISTRIBUTION - SERVICES TO MSU FCU (IBM) BUILDINGK","SUBSTCOMP","665,000",610000,559680,null,null,null,null,null,null,"2017-01-05","2017-04-21",100,null,null,null,"2017-05-29","2017-09-30",97,"2017-09-30","2018-06-30",null,"2018-06-30","2018-09-30",null,"GARDNERM","BARB KRANZ","-","-","WILBERD","GARDNERM","-","BEACHK","BARNESC","LAURIE BRINKER","CH2M HILL ENGINEERS INC","HOLDER CONSTRUCTION GROUP LLC","CM - CONSTRUCTION MANAGER"]
["CP14292","DUFFY DAUGHERTY FOOTBALL-SAAC - ROOM A100 SOUND DAMPENING","RELCON","12,000",12000,11030,null,null,null,"2014-12-08","2015-01-22",null,"2015-07-13","2015-09-01",100,null,null,null,null,null,98,null,null,null,null,null,null,"PENNOCKK","SARA WOODRUFF","PENNOCKK","LOCKWOODC","-","-","O'BRIENI","-","RAMIREZM",null,"IPF","IPF","DB - DESIGN BUILD"]
["CP15242","FEE HALL - REPLACE FREIGHT ELEVATOR","SUBSTCOMP","295,000",350000,281811,null,null,null,null,null,null,"2015-10-02","2016-05-15",100,"2016-02-19","2016-03-17",100,"2016-09-14","2016-12-14",99,"2016-12-14","2017-09-14",100,"2017-09-14","2017-12-14",null,"KASDORFJ","LYNDA BOOMER","KASDORFJ","-","-","-","HOPPERS","-","POSTMAM","LAURIE BRINKER","BERNATH-COAKLEY ASSOC ARCHITECT INC/ENGINEERING APPLICATIONS INC","NIELSEN COML CONSTRUCTION CO INC","GC - DESIGN BID & BUILD"]
["CP17256","PATHWAYS - RED CEDAR GREENWAY - FARM LANE TO BOGUE","IN DES","440,000",45000,0,null,null,null,null,null,null,"2017-12-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WAHLT","BARB WILBER","-","-","KINNEYD","TROTTERM","-","-","RHODESA","LAURIE BRINKER",null,null,"TBD - TO BE DETERMINED"]
["CP09298","FRIB - FACILITY FOR RARE ISOTOPE BEAM","RELCON","730,000,000",640500000,3988928,null,null,null,null,null,null,"2009-09-25","2014-09-30",null,null,null,null,"2011-04-01","2015-03-02",3,"2015-03-03","2015-09-02",null,"2015-09-03","2016-03-02",null,"BULLB","72660","KASDORFJ","-","WILBERD","THRONSONC","NGUYENP","FRAZEER","BULLB",null,"SMITHGROUP JJR INC","BARTON MALOW COMPANY","CM - CONSTRUCTION MANAGER"]
["CP15249","KRESGE ART - REPLACE FIRE ALARM SYSTEM","RELCON","550,000",550000,72592,null,null,null,null,null,null,"2015-10-06","2017-04-01",100,null,null,null,"2018-02-01","2019-06-30",0,"2019-06-30","2020-03-30",null,"2020-03-30","2020-06-30",null,"HOWARDK","LYNDA BOOMER","-","-","-","-","-","HOWARDK","-","LAURIE BRINKER","IPF","IPF","DB - DESIGN BUILD"]
["CP16002","NATURAL SCIENCE - ALTERATIONS TO ROOMS 137, 138 AND 139","SUBSTCOMP","400,000",400000,399552,null,null,null,null,null,null,"2016-01-07","2016-04-02",100,"2016-04-08","2016-04-27",null,"2016-06-03","2016-08-19",99,"2016-08-19","2017-10-19",null,"2017-10-19","2017-11-19",null,"COOLC","ANDREW MIDGLEY","CHARLANDB","-","-","-","FRANCISD","HOWARDK","COOLC","LAURIE BRINKER","IPF/ENGINEERING APPLICATIONS INC","J PEREZ CONSTRUCTION INC","GC - DESIGN BID & BUILD"]
["CP15327","SEWER DISTRIBUTION - STORMWATER, ASSET MANAGEMENT AND WASTEWATER (SAW) GRANT","STUDY","2,438,824",2438824,788966,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEFEVREJ","LYNDA BOOMER","LEFEVREJ","-","-","GARDNERM","-","-","-","ROBIN MCVAY","FISHBECK, THOMPSON, CARR & HUBER","-","TBD - TO BE DETERMINED"]
["CP17101","ABRAMS PLANETARIUM - ENTRANCE PORTICO","STUDY",null,null,null,null,null,null,null,null,null,"2017-05-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PENNOCKK","MARC CONLIN","PENNOCKK","-","KINNEYD","TROTTERM","-","-","-",null,"IPF","-","TBD - TO BE DETERMINED"]
["CP17200","WILSON HALL - STUDENT ROOM SHOWER REPLACEMENTS","IN DES",null,null,null,null,null,null,null,null,null,"2017-10-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WILSONT","BILL WHITBECK","KASDORFJ","-","-","-",null,"-","WILSONT",null,null,null,"TBD - TO BE DETERMINED"]
["CP17026","WILLS HOUSE - BARRIER FREE, LIFE SAFETY/CODE IMPROV. AND INTERIOR PROGRAMMATIC IMPROVEMENTS","RELCON","977,301",977301,57421,null,null,null,"2017-02-09","2017-03-26",null,"2017-06-19","2017-11-27",100,null,null,null,"2017-11-27","2018-02-28",60,"2018-02-28","2018-11-28",null,"2018-11-28","2019-02-28",null,"VANZEEJ","LINDSAY GRAY","PENNOCKK","LOCKWOODC","KINNEYD","-","HOPPERS","HOWARDK","VANZEEJ","LAURIE BRINKER","EAST ARBOR","GRANGER CONSTRUCTION","CM - CONSTRUCTION MANAGER"]
["CP16120","FOOD SAFETY TOXICOLOGY - RENOVATE ROOMS 218B AND 218C","SUBSTCOMP","700,000",700000,671011,null,null,null,"2016-04-14","2016-05-27",null,"2016-05-27","2016-08-30",100,null,null,null,"2016-09-15","2017-03-30",98,"2017-03-30","2017-12-30",null,"2017-12-30","2018-03-30",null,"HOPPERS","NESTOR DEOCAMPO","KRAMERN","-","-","-","HOPPERS/ANDERSONB","PRIDEM","KRAMERN","LAURIE BRINKER","PETER BASSO ASSOCIATES INC","NIELSEN COML CONSTRUCTION CO INC","GC - DESIGN BID & BUILD"]
["CP17211","JENISON FIELDHOUSE - RENOVATIONS TO ROOMS 305 AND 340","IN DES",null,null,null,null,null,null,null,null,null,"2017-10-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POSTMAM","LISA SUDIA","-","LOCKWOODC","-","-","-","KLANND","POSTMAM",null,null,null,"TBD - TO BE DETERMINED"]
["CP13269","FOOD SAFETY AND TOXICOLOGY - IMPLEMENT ENERGY CONSERVATION MEASURES","SUBSTCOMP","47,000",47000,43026,null,null,null,null,null,null,"2013-09-26","2016-12-31",100,null,null,null,"2017-01-01","2017-05-01",97,"2017-05-01","2018-01-01",null,null,null,null,"ANDERSONB","DAN BOLLMAN","-","-","-","-","ANDERSONB","-","ANDERSONB",null,"IPF","QUALITY AIR SERVICE INC","DB - DESIGN BUILD"]
["CP16303","KELLOGG BIO-GULL LAKE - GREENHOUSE STRUCTURAL STUDY","STUDY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEFEVREJ","ANDREW FOGIEL","-","-","-","LEFEVERJ","-","-","-",null,"IPF","-","TBD - TO BE DETERMINED"]
["CP16226","HUBBARD HALL - EXTERIOR MASONRY RESTORATION AND WINDOW REPLACEMENT - PHASE 3","IN DES","2,500,000",2500000,112513,null,null,null,null,null,null,"2017-08-11","2017-12-15",100,"2017-12-15","2018-01-15",100,"2018-05-07","2018-08-01",null,"2018-08-01","2019-05-01",null,"2019-05-01","2019-08-01",null,"COOLC","LYNDA BOOMER","-","-","-","LEFEVREJ","-","-","COOLC","ROBIN MCVAY","WTA","NEILSEN CONSTRUCTION","CM - CONSTRUCTION MANAGER"]
["CP17136","FEE HALL - ALTERATIONS TO ROOM E202","STUDY",null,0,1150,null,null,null,null,null,null,"2017-07-06","2018-02-27",100,null,null,null,null,null,null,null,null,null,"2018-02-27","2018-02-27",null,"ANDERSONB","M B COUREY","-","-","-","-","ANDERSONB","-","-",null,"NIELSEN COML CONSTRUCTION CO INC","-"]
["CP15234","STEAM DISTRIBUTION - REPLACE ADSCO EXPANSION JOINTS FROM POWER PLANT TO ENGR VAULT - PHASE 1 OF 3","RELCON","680,000",680000,524759,null,null,null,null,null,null,"2015-09-30","2016-04-29",100,null,null,null,"2017-07-05","2018-06-29",15,"2018-06-29","2019-03-29",null,"2019-03-29","2019-06-29",null,"GARDNERM","LYNDA BOOMER","-","-","-","TROTTERM","GARDNERM","-","GARDNERM","LAURIE BRINKER","FISHBECK, THOMPSON, CARR & HUBER","GRANGER CONSTRUCTION CO","DB - DESIGN BUILD"]
["CP17111","AUDITORIUM - INSTALL HVAC SYSTEM FOR BLACK BOX THEATRE","IN DES","800,000",800000,13018,null,null,null,null,null,null,"2017-05-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WILSONT","LYNDA BOOMER","-","-","-","-","ANDERSONB","HOWARDK","WILSONT","ROBIN MCVAY",null,null,"DB - DESIGN BUILD"]
["CP17194","LINTON HALL - ALTERATIONS TO ROOM 113","IN DES",null,null,null,null,null,null,null,null,null,"2017-09-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ABDEL-AZIM","LINDSAY GRAY","ABDEL-AZIM","-","-","-","FRANCISD","HALSEYG","WILSONT",null,null,null,"TBD - TO BE DETERMINED"]
["CP15220","MUSIC PRACTICE - WINDOW REPLACEMENT","SUBSTCOMP","1,500,000",1500000,1261710,null,null,null,null,null,null,"2015-09-10","2016-04-30",null,null,null,null,"2016-05-09","2016-08-05",98,"2016-08-05","2017-04-30",null,"2017-04-30","2017-07-30",null,"DURKINK","DAN BOLLMAN","PENNOCKK","WHITBECKD","WAHLT","-","ANDERSONB","-","DURKINK","ROBIN MCVAY","IPF","DEMARIA BUILDING COMPANY INC","CM - CONSTRUCTION MANAGER"]
["CP16044","OFFICE COMPLEX - MAIN BUILDING AND ANNEX BUILDING - RENOVATIONS","STUDY","300,000",7370000,288986,null,null,null,"2016-02-02","2016-03-18",null,"2016-02-29","2016-07-15",100,null,null,null,"2016-05-15","2017-08-31",97,null,null,null,null,null,null,"MULLENB","KERRY GERNERT","MULLENB","-","-","-","-","-","-","ROBIN MCVAY","IPF","-","TBD - TO BE DETERMINED"]
["CP17050","TB SIMON POWER PLANT - CAMPUS ENERGY STORAGE","STUDY",null,null,null,null,null,null,null,null,null,"2017-03-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BARNESC","LYNDA BOOMER","-","-","-","-","-","BEACHK","-",null,"IPF","-","TBD - TO BE DETERMINED"]
["CP18026","FRIB - CRYOGENIC ASSEMBLY - LOCATE EXISTING UTILITIES FOR CAB","IN DES",null,null,null,null,null,null,null,null,null,"2018-01-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GARDNERM","JESSICA KOLP",null,null,null,"GARDNERM",null,"BEACHK","GARDNERM",null,null,null,"TBD - TO BE DETERMINED"]
["CP17035","ALUMNI CHAPEL - FACILITY AUDIT AND NEW ORGAN","STUDY","15,000",15000,22780,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RHODESA","SUE BRANDT","KASDORFJ","-","KINNEYD","-","FRANCISD","HOWARDK","RHODESA",null,"MAYOTTE GROUP ARCHITECTS","-","TBD - TO BE DETERMINED"]
["CP17093","BIO ENGINEERING AND VARIOUS BUILDINGS – EVALUATE HEALTH SCIENCES DINING FOR SOUTH EAST DISTRICT","STUDY","30,000",0,15190,null,null,null,null,null,null,"2017-05-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEMPLER","LYNDA BOOMER","KASDORFJ","-","WILBERD","-","NESTLER","BEACHK","COOLC",null,"THE BAKER GROUP","-","TBD - TO BE DETERMINED"]
["CP12129","FRIB SRF HIGH BAY","SUBSTCOMP","15,500,000",15500000,483394,null,null,null,null,null,null,"2012-06-25","2013-10-25",null,"2012-02-21","2013-11-15",null,"2013-03-21","2014-05-15",45,"2015-10-10","2015-10-10",null,null,null,null,"BULLB",null,"-",null,"WILBERD",null,"NGUYENP","FRAZEER","TODD ELKIN",null,"SMITHGROUP/JJR","BARTON MALOW","CM - CONSTRUCTION MANAGER"]
["CP17054","INFRASTRUCTURE PLANNING FACILITIES - STRATEGIC INITIATIVES AND ICT RENOVATIONS","IN DES","235,000",235000,66171,null,null,null,null,null,null,"2017-03-24","2018-02-12",30,null,null,null,"2018-03-12","2018-09-12",null,"2018-09-12","2019-06-12",null,"2019-06-12","2019-09-12",null,"KASDORFJ","LYNDA BOOMER","KASDORFJ","WHITBECKD","-","-","-","KLANND","-",null,null,null,"TBD - TO BE DETERMINED"]
["CP17068","KELLOGG CENTER - FIRST FLOOR AMENITIES AND SPACE RENOVATIONS","IN DES","530,795",530796,0,null,null,null,null,null,null,"2017-04-06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DURKINK","SUE BRANDT","-","-","-","-","-","-","DURKINK","LAURIE BRINKER",null,null,"TBD - TO BE DETERMINED"]
["CP13239","NATURAL RESOURCES - ALTERATIONS TO ROOMS 308 AND 308A","RELCON","35,000",35000,44176,null,null,null,"2016-03-30","2016-05-14",null,"2016-10-28","2017-01-30",100,null,null,null,null,null,null,null,null,null,null,null,null,"PENNOCKK","SUE CHATTERLEY","PENNOCKK","-","-","-","ANDERSONB","HOWARDK","-",null,"IPF","IPF","DB - DESIGN BUILD"]
["CP08261","PLANT AND SOIL SCIENCES (ADDITION 1) & CHEMISTRY - COOLING TOWER","SUBSTCOMP","45,300,000",45300000,45129598,null,null,null,null,null,null,"2008-07-02","2010-09-30",100,"2010-03-25","2010-04-15",null,"2010-05-10","2011-10-30",98,"2012-01-13","2013-09-30",null,"2014-03-31","2015-06-30",null,"ANDERSONB",null,"-","-","KINNEYD","GARDNERM","ANDERSONB","HOWARDK","LINEBAUGHA","ROBIN MCVAY","SMITHGROUP JJR INC","CHRISTMAN CONSTRUCTORS INC","CM - CONSTRUCTION MANAGER"]
["CP15211","GILTNER HALL - ALTERATIONS TO SUITES 100, 152 AND 178","RELCON","185,000",185000,196921,null,null,null,"2015-09-09","2015-10-24",100,"2016-04-11","2016-12-30",100,null,null,null,"2017-05-03","2017-08-01",80,"2017-08-01","2017-11-01",null,"2017-11-01","2018-08-01",null,"GOTTSCHALK","JAMIN VILLARREAL","KASDORFJ","LOCKWOODC","-","-","-","-","GOTTSCHALK",null,"IPF","IPF","DB - DESIGN BUILD"]
["CP15174","VETERINARY MEDICAL CENTER - FELINE FRIENDLY ACCREDITATION STUDY","STUDY","54,000",54000,39615,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POSTMAM","SEAN YANCEY","KASDORFJ","-","-","-","-","-","POSTMAM",null,"ANIMAL ARTS DESIGN STUDIOS INC","-","TBD - TO BE DETERMINED"]
["CP17216","ALL SEASON RINK - CONSTRUCT ORIGINAL BUILDING","IN DES","3,200,000",0,20,null,null,null,null,null,null,"2017-10-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GARDNERM","LYNDA BOOMER","KASDORFJ","-","WAHLT","TROTTERM","FRANCISD","BEACHK","VANZEEJ","ROBIN MCVAY","TMP","GRANGER CONSTRUCTION","DB - DESIGN BUILD"]
["CP18006","TB SIMON POWER PLANT - COAL HOPPERS DEMOLITION","IN DES","336,000",336000,0,null,null,null,null,null,null,"2018-01-11","2018-06-22",20,null,null,null,"2018-06-25","2018-10-31",null,"2018-10-31","2019-07-31",null,"2019-07-31","2019-10-31",null,"BARNESC","BOB ELLERHORST","-","-","WAHLT",null,"-","-","BARNES","ROBIN MCVAY",null,null,"TBD - TO BE DETERMINED"]
["CP15199","OWEN GRADUATE HALL - IMPLEMENT ENERGY CONSERVATION MEASURES","IN DES","405,000",405000,0,null,null,null,null,null,null,"2015-08-14","2018-02-01",40,null,null,null,"2018-04-01","2018-08-15",0,"2018-08-15","2019-05-15",null,"2019-05-15","2019-08-15",null,"ANDERSONB","LYNDA BOOMER","-","-","-","-","ANDERSONB","-","-","LAURIE BRINKER",null,null,"DB - DESIGN BUILD"]
["CP16209","ENG RESEARCH COMPLEX - INSTALL NEW FUME HOOD AND SNORKEL IN LAB A16","SUBSTCOMP","50,000",81000,68832,null,null,null,"2016-08-01","2016-09-15",100,"2017-05-04","2017-06-10",100,"2017-06-15","2017-07-01",100,"2017-08-31","2017-12-20",97,"2017-12-20","2018-09-20",null,"2018-09-20","2018-12-20",null,"ANDERSONB","LORI LARNER","-","-","-","-","ANDERSONB","ANDERSONB","ANDERSONB","EARLINE SOLOMON","IPF","DEE CRAMER","ICM - INTERNAL CONSTRUCTION MANAGER"]
["CP16300","ELECTRICAL DISTRIBUTION - INSTALL ADDITIONAL CONDUITS FROM POWER PLANT TO HARRISON ROAD","SUBSTCOMP","298,684",298684,295366,null,null,null,null,null,null,"2016-11-18",null,null,null,null,null,"2016-11-26","2017-06-09",97,"2017-06-09","2018-03-09",null,"2018-03-09","2018-06-09",null,"GARDNERM","DAN BOLLMAN","-","-","WILBERD","GARDNERM","-","BEACHK","BARNESC","LAURIE BRINKER","CH2M HILL ENGINEERS INC","HOLDER CONSTRUCTION GROUP LLC","CM - CONSTRUCTION MANAGER"]
["CP17071","LINTON HALL - ALTERATIONS TO SUITE 110 AND ROOM 119","IN DES",null,null,null,null,null,null,null,null,null,"2017-04-10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ABDEL-AZIM","LINDSAY GRAY","-","-","-","-","-","HOWARDK","-",null,null,null,"TBD - TO BE DETERMINED"]
["CP17221","PARKING RAMP 2-AUDITORIUM RD - ANNUAL MAINTENANCE 2018","IN DES",null,null,null,null,null,null,null,null,null,"2017-10-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GOTTSCHALKK","STEPHANIE O'DONNELL","-","-","-","GARDNERM","-","-","GOTTSCHALKK",null,null,null,"TBD - TO BE DETERMINED"]