Attachment C - Tank Data Sheet.xlsx

XLSX spreadsheet 110 KB Posted Feb 19, 2025

Attached to: API Fuel Tank Inspection - Wright Patterson, AFB Federal contract opportunity
Solicitation number: W9128F25QA018
Issued by: Department of the Army Corps of Engineers Engineering District Omaha

About this file

Written by GovTribe AI · Feb 19, 2025

This file is a tank data sheet template containing multiple sections for recording detailed information about fuel storage tanks and related infrastructure. The template includes fields for capturing tank specifications (capacity, dimensions, construction details), inspection information (dates, conditions, recommendations), safety features (alarms, containment, leak detection), and contact information for facility personnel. While the template itself is blank, it appears to be designed for use in government fuel tank management and inspection programs based on fields referencing DLA Energy, Army Corps of Engineers, and military facilities. No specific tank data or requirements are populated in this template.

View the file

Other files for this federal contract opportunity

Other files attached to API Fuel Tank Inspection - Wright Patterson, AFB, newest first.
File	Type	Posted
Attachment A - General Installation Security Requirements.pdf	PDF	Feb 19, 2025
Attachment J - Previous Inspection Report.pdf	PDF	Feb 19, 2025
Attachment G - Return To Service Letter.docx	DOCX document	Feb 19, 2025
Wage Determination.pdf	PDF	Feb 19, 2025
Attachment 1 - CLIN Schedule.pdf	PDF	Feb 19, 2025
Attachment B - Fuel Storage Tank List.xlsx	XLSX spreadsheet	Feb 19, 2025
Attachment E - Inspection Teleconference Briefing Template.docx	DOCX document	Feb 19, 2025
Attachment F - API Internal Inspection Template.docx	DOCX document	Feb 19, 2025
Attachment 2 - Performance Work Statement (PWS).pdf	PDF	Feb 19, 2025
Attachment 4-Addendum to 52.212-1.pdf	PDF	Feb 19, 2025
Attachment D - Monthly Contractors Progress Management and Status Report.xlsx	XLSX spreadsheet	Feb 19, 2025
Combined Synopsis-Solicitation Wright Patterson AFB.pdf	PDF	Feb 19, 2025

Show all 12

On GovTribe

Work with this file on GovTribe

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

PMP

Defense Logistics Agency
Energy Division (DLA-E)
Project Management Plan (PMP)
Construct Product Containment Areas, Replace Secondary Containment Areas (Fort Indiantown Gap, PA)
DLA-E Project Number P-006858-08
November 2010
US Army Corps
Of Engineers®
Omaha District
PROJECT CONCEPT DOCUMENT
I. General Information
	DLA-E Project Name:	Construct Product Containment Areas, Replace Secondary Containment Areas (Fort Indiantown Gap, PA)
	DLA-E Project Number:	P-006858-08
	DLA-E Project Manager:	Rick Rivera
	DLA-E Contact Information:	(703) 767-8286; rick.rivera@dla.mil
	Date:	12-Nov-10
Section One – Customer Goals
II. BUSINESS JUSTIFICATION (State the reason this project is needed and what problem or issue the project will resolve. Describe the impacts to the organization if the project is not approved.)
	Upgrades and repairs to the fueling facilities and supporting systems are required to prevent a fuel release that could contaminate the soil and groundwater or start a fire that could damage the fuel equipment and injure personnel.
III. PROJECT DESCRIPTION (Provide a high-level overview of the project objectives. Include a brief list of desired project outcomes.)
	Project Objectives:

Identify and resolve deficiencies such that the installation will avoid potential fuel releases that could harm the environment and personnel. Upgrades/repairs will comply with Federal, State, and Local Standards.

Minor Repair and Minor Construction activities will include but not be limited to the following:

- install a secondary spill containment at the JP-8 truck issue racks;

- install three (3) ground vehicle refueling stations;

- replace secondary spill containment for three (3) 6,000 gallon refuelers;

- install pipe supports;

- repair emergency fuel shutoff switches; and

- install tank overfill protection system.

Desired Project Outcomes:

- Provide detailed trip report to stakeholders for review and approval

- Receive necessary review comments and approvals from stakeholders

- Develop 35% design and cost estimate

- Prepare and distribute RFP to Fuels MATOCs

- Perform repairs in quality-focused manner

- Complete work by 11-Nov-2011

IV. PROJECT COSTS (Provide high-level estimates if known.)
	$885,868.17 ($65,619.84 for SIOH)
V. TIMEFRAME
	Is there a critical completion date?	YES	NO	Date required:	N/A
	Desired completion date if not critical:	11-Nov-11
Section Two – USACE Project Information
VI. PLANNING ESTIMATES (Provide a high-level estimate of project completion.)
	$1,150,000 (including additional deficiencies identified during site visit)
VII. BUSINESS AREAS IMPACTED (List all business units impacted by this project.)
	- Special Projects (Project Management)

- Design Branch (Mechanical Engineering, Civil Engineering, Electrical Engineering)

- Cost Engineering (Cost Estimation)

- Program Analysts (Budgeting)

- Contracting (Contract Management)

Section Three: Review Committee
V. SELECTION COMMITTEE REVIEW
	Date of Review:
	Comments:
	Project Reviewed/Denied:
	Project Priority:
IX. SIGNATURES OF REVIEW COMMITTEE

PROJECT CHARTER
I. GENERAL INFORMATION
	DLA-E Project Name:	Construct Product Containment Areas, Replace Secondary Containment Areas (Fort Indiantown Gap, PA)
	DLA-E Project Number:	P-006858-08
	DLA-E Project Manager:	Rick Rivera
	Date:	12-Nov-10
II. PROJECT OVERVIEW (Describe the product or service of the project, the reason the project was undertaken, and the purpose of the project)
	Identify and validate any existing deficiencies in fueling facilities that may result in a fuel release that could contaminate the soil and groundwater or start a fire that could damage the fuel equipment and injure personnel. Prepare designs detailing the necessary upgrades and/or repairs to the fueling facilities, and execute those repairs.
III. PROJECT OBJECTIVES (Describe the overall objectives of the project and what factors will determine the success of the project.)
	Identify and resolve deficiencies such that the installation will avoid potential fuel releases that could harm the environment and personnel. Upgrades/repairs will comply with Federal, State, and Local Standards.

Minor Repair and Minor Construction activities will include but not be limited to the following:

- install a secondary spill containment at the JP-8 truck issue racks;

- install three (3) ground vehicle refueling stations;

- replace secondary spill containment for three (3) 6,000 gallon refuelers;

- install pipe supports;

- repair emergency fuel shutoff switches; and

- install tank overfill protection system.

IV. BUSINESS JUSTIFICATION (State the reason this project is needed and what problem or issue the project will resolve. Describe the impacts to the organization if the project is not approved.)
	Upgrades and repairs to the fueling facilities and supporting systems are required to prevent a fuel release that could contaminate the soil and groundwater or start a fire that could damage the fuel equipment and injure personnel.
V. RESOURCE COSTS AND ESTIMATES (Provide cost estimates if known, including monies already expended such as a feasibility study or consulting time.)
	- Project Management: $4,500

- Mechanical Engineering: $6,000

- Civil Engineering: $6,000

- Electrical Engineering: $3,000

- Cost Estimating: $2,500

- Budgeting: $1,000

- Contract Management: $3,500

VI. ROLES AND RESPONSIBILITIES (List the stakeholders and their responsibilities.)
	- Gregory Etter: Project Manager, POL-DX

- Michael Deeker: Civil Engineer, POL-DX

- Joseph Pesek: Mechanical Engineer, POL-DX

- James Hugar, Team Lead, Army Petroleum Center VII. Signatures (Include signature lines for the project sponsor, project manager, key stakeholders, customers, and vendors.)

VIII. Attachments (List the attachments to the charter here.)
	Sign in sheet for site visit to Fort Indiantown Gap, PA (XX-Sep-2010)
PROJECT KICK-OFF MEETING AGENDA
I. GENERAL INFORMATION
	DLA-E Project Name:	Construct Product Containment Areas, Replace Secondary Containment Areas (Fort Indiantown Gap, PA)
	DLA-E Project Number:	P-006858-08
	USACE Project Manager:	Gregory Etter
	Date:	XX-Sep-2010
II. AGENDA ITEMS
	1. Introductions	Review MIPRs and project description
	2. Project charter
	3. Project purpose	Review MIPRs and project description
	4. Project objectives	Review MIPRs and project description
	5. Roles and responsibilities	Role of POL-DX
	6. Questions
PROJECT SCOPE STATEMENT
I. GENERAL INFORMATION
	DLA-E Project Name:	Construct Product Containment Areas, Replace Secondary Containment Areas (Fort Indiantown Gap, PA)
	DLA-E Project Number:	P-006858-08
	USACE Project Manager:	Gregory Etter
	Date:	12-Nov-10
II. PROJECT OVERVIEW (Describe the product or service of the project, the reason the project was undertaken, and the purpose of the project.)
	Identify and validate any existing deficiencies in fueling facilities that may result in a fuel release that could contaminate the soil and groundwater or start a fire that could damage the fuel equipment and injure personnel. Prepare designs detailing the necessary upgrades and/or repairs to the fueling facilities, and execute those repairs.
III. PROJECT GOALS AND OBJECTIVES (Describe the project goals using the SMART (Specific, Measureable, Agreed to, Realistic, Time Bound) formula. These goals will be used to measure and determine the project’s success at its conclusion.)
	Project Goals:

- Provide detailed trip report to stakeholders for review and approval

- Receive necessary review comments and approvals from stakeholders

- Develop 35% design and cost estimate

- Prepare and distribute RFP to Fuels MATOCs

- Perform repairs in quality-focused manner

- Complete work by 11-Nov-2011

Project Objectives:

Minor Repair and Minor Construction activities will include but not be limited to the following:

- install a secondary spill containment at the JP-8 truck issue racks;

- install three (3) ground vehicle refueling stations;

- replace secondary spill containment for three (3) 6,000 gallon refuelers;

- install pipe supports;

- repair emergency fuel shutoff switches; and

- install tank overfill protection system.

IV. COMPREHENSIVE LIST OF PROJECT DELIVERABLES (These are the products or services that must be produced in order to fulfill the goals of the project. Deliverables should have measureable, verifiable results and outcomes. Identify critical success factors.)
	- Site visit with members of the POL-DX;

- Trip report including deficiency description and recommended solutions;

- Final (Draft) SOW for review;

- RTA (Final Draft) SOW for distribution to Fuels MATOC pool of contractors;

- Award amount for project execution by Fuels MATOC;

- Contractor kickoff meeting at installation;

- Construction completion.

V. COMPREHENSIVE LIST OF PROJECT REQUIREMENTS (Requirements are the specifications of the deliverables.)
	- Designs and constructed upgrades/repairs should be in compliance with existing Federal, State, and Local standards;

- Design and construction efforts shall be derived from approvals by DLA-E and APC to remedy identified deficiencies.

VI. EXCLUSIONS FROM SCOPE (List all deliverables or requirements that are not part of this project.)
	N/A
VII. TIME AND COST ESTIMATE (Include initial estimates of time and resources. These are estimates only and will be updated after additional project planning activities are completed.)
	- Total time estimate: 415 days

- Site Visit: 4 days

- Trip Report prepared, reviewed, and approved by DLA-E and APC: 28 days

- RTA SOW prepared, reviewed, and distributed to Fuels MATOC contractors: 90 days

- Bids received and Task Order awarded: 45 days

- Construction: 248 days

- Total cost estimate: $1,150,000 (including additional deficiencies identified during site visit) VIII. ROLES AND RESPONSIBILITIES (Include a roles-and-responsibilities chart, detailing project responsibilities.)

IX. ASSUMPTIONS (List all project assumptions.)

X. CONSTRAINTS (List all project constraints.)

XI. SIGNATURES (Include signatures for the project sponsor, project manager, key stakeholders, customers, and vendors.)

COMMUNICATIONS PLAN
I. GENERAL INFORMATION
	DLA-E Project Name:	Construct Product Containment Areas, Replace Secondary Containment Areas (Fort Indiantown Gap, PA)
	DLA-E Project Number:	P-006858-08
	USACE Project Manager:	Gregory Etter
	Date:	12-Nov-10

	COMMUNICATION	RECIPIENTS		METHOD	TIMING	PREPARED BY
	Draft Trip Report	- Army Petroleum Center;
- Charles Rickard;		e-mail	Upon completion	Mike Deeker, Joe Pesek
	Final RFP	- Army Petroleum Center;
- Charles Rickard;		e-mail, FTP	Upon completion	Mike Deeker, Joe Pesek, Doug Larsen
	RTA RFP	MATOC Contractors		e-mail, FTP	Upon completion	Mike Deeker, Joe Pesek, Doug Larsen

RESOURCES, MATERIALS, SUPPLIES, AND EQUIPMENT LIST
I. GENERAL INFORMATION
	DLA-E Project Name:		Construct Product Containment Areas, Replace Secondary Containment Areas (Fort Indiantown Gap, PA)
	DLA-E Project Number:		P-006858-08
	USACE Project Manager:		Gregory Etter
	Date:		12-Nov-10
II. RESOURCES, MATERIALS, SUPPLIES, AND EQUIPMENT NEEDED
TASK		MATERIALS NEEDED		QUANTITY	APPROXIMATE COST
Perform site visit		Mechanical, Civil engineers		1 EA	$1,200 per day

QUALITY MANAGEMENT PLAN
I. GENERAL INFORMATION
	DLA-E Project Name:	Construct Product Containment Areas, Replace Secondary Containment Areas (Fort Indiantown Gap, PA)
	DLA-E Project Number:	P-006858-08
	USACE Project Manager:	Gregory Etter
	Date:	12-Nov-10
II. PROJECT OVERVIEW (Provide an overview of the project, including its primary goals.)
	Identify and validate any existing deficiencies in fueling facilities that may result in a fuel release that could contaminate the soil and groundwater or start a fire that could damage the fuel equipment and injure personnel. Prepare designs detailing the necessary upgrades and/or repairs to the fueling facilities, and execute those repairs.
III. QUALITY STANDARDS AND REGULATIONS (Note any quality policies, standards, or regulations the project team will be required to follow.)
	Ensure that recommendations and preliminary designs conform to current design requirements and safety standards.
IV. QUALITY CRITERIA (Provide a detailed list of the quality criteria needed to consider the deliverables complete and correct. Include each deliverable and its quality criteria.)
	- Conforms to preliminary design requirements;

- Meets safety standards;

- Completed on time;

- System performs as required by the Installation;

V. QUALITY ASSURANCE PRODECURES (List the activities and processes that will be used to monitor adherence to the quality criteria.)
	- Initial kickoff meeting by member of Omaha District to explain project goals and quality requirements;

- Daily oversight performed by local District;

- Unscheduled visits by Omaha District representative(s);

VI. QUALITY MANAGEMENT ROLES AND RESPONSIBILITIES (Include a roles and responsibility chart detailing who’s responsible for which quality activities.)
	- Technical quality: POL-DX (Mike Deeker, Joe Pesek);

- Execution quality: Rapid Response representative (Todd Wolpert);

- Overall project quality: Project Manager (Greg Etter) VII. SIGNATURES (Include signature lines for the project sponsor, project manager, and those responsible for quality assurance and review.)

PROJECT STATUS REPORT
I. GENERAL INFORMATION
	DLA-E Project Name:	Construct Product Containment Areas, Replace Secondary Containment Areas (Fort Indiantown Gap, PA)
	DLA-E Project Number:	P-006858-08
	USACE Project Manager:	Gregory Etter
	Date:	12-Nov-10
II. PROGRESS MADE SINCE LAST REPORTING PERIOD
	- Site visit performed on XX-XX-2010;

- Supplemental maps and surveys provided by Installation;

- Trip report distributed on XX-XX-2010;

III. SCHEDULED AND ACTUAL COMPLETION DATES
	XXXXXXXX
IV. PROGRESS EXPECTED THIS REPORTING PERIOD NOT COMPLETED

V. PROGRESS EXPECTED NEXT REPORTING PERIOD
	- Comments on trip report due XX-XX-2010;

- Final RFP distributed for review and comment;

VI. ISSUES
	- None
ACTION ITEM LOG
I. GENERAL INFORMATION
	DLA-E Project Name:
	DLA-E Project Number:
	USACE Project Manager:
II. ACTION ITEM LOG
ID	DATE REPORTED	ACTION ITEM	ASSIGNED TO	DATE RESOLVED

CHANGE REQUEST FORM
I. GENERAL INFORMATION
	DLA-E Project Name:
	DLA-E Project Number:
	Requestor Name:
	Requestor’s Contact Info:
	Date of Request:
	Date Request Approved/Denied:
Section One – Change Request Information
II. DESCRIPTION OF CHANGE REQUEST (Include a detailed description of the requested scope change.)

III. BUSINESS JUSTIFICATION FOR CHANGE (Describe how the business, project, or product will benefit from the requested change.)

IV. IMPACTS OF NOT MAKING THE CHANGE (Describe how the business, project, or product will be impacted if the change is not made.)

V. ALTERNATIVES TO CHANGE (Describe any known alternatives to the change.)

Section Two – Project Manager Input

VI. IMPACTS OF THE CHANGE (Describe the impacts of this change to the project schedule, budget, and quality.)

VII. ALTERNATIVES TO CHANGE (Describe alternative solutions to the change.)

VIII. RECOMMENDATIONS TO THE CHANGE CONTROL BOARD (Describe the project manager’s recommendation to approve or deny the change. Include justification for the recommendation.)

Section Three – Change Control Board
Recommendation: (Include a discussion concerning the goals of the project. Does this change significantly impact the goals of the project such that the project goals can no longer be met? Should this change be considered a new project or phase two of the existing project, etc.)
	Date of Review:
	Signature:
QUALITY MANAGEMENT PLAN
I. GENERAL INFORMATION
	DLA-E Project Name:	Construct Product Containment Areas, Replace Secondary Containment Areas (Fort Indiantown Gap, PA)
	DLA-E Project Number:	P-006858-08
	USACE Project Manager:	Gregory Etter
	Date:	12-Nov-10
II. PROJECT OVERVIEW (Describe the final product or service of the project, the reason the project was undertaken, and the purpose of the project. Include a description of the business problem that was solved by implementing the project.)
	Identify and validate any existing deficiencies in fueling facilities that may result in a fuel release that could contaminate the soil and groundwater or start a fire that could damage the fuel equipment and injure personnel. Prepare designs detailing the necessary upgrades and/or repairs to the fueling facilities, and execute those repairs.
III. PROJECT GOALS AND OBJECTIVES (Identify the goals that were met during this project and compare them to the goals on the scope statement.)
	Project Goals:

- Provide detailed trip report to stakeholders for review and approval

- Receive necessary review comments and approvals from stakeholders

- Develop 35% design and cost estimate

- Prepare and distribute RFP to Fuels MATOCs

- Perform repairs in quality-focused manner

- Complete work by 11-Nov-2011 Project Objectives:

Minor Repair and Minor Construction activities will include but not be limited to the following:

- install a secondary spill containment at the JP-8 truck issue racks;

- install three (3) ground vehicle refueling stations;

- replace secondary spill containment for three (3) 6,000 gallon refuelers;

- install pipe supports;

- repair emergency fuel shutoff switches; and

- install tank overfill protection system.

IV. PROJECT DELIVERABLES AND MILESTONES (Identify the major deliverables or milestones met, their due dates according to the final plan, their actual delivery dates, and stakeholder acceptance dates.)
	XXXXXXX
V. PROJECT BUDGET (Give a final overview of the project budget and variances from the budget.)
	$885,868.17 total, with $65,619.84 set aside for SIOH
VI. QUALITY ASSURANCE (Document acceptance of the quality criteria and inspections.)

VII. COMMENTS (Include any information that reminds stakeholders of agreements made concerning deliverables that were moved to phase two of the project, major problems that were encountered and how they were resolved, risk events that need further explanation, etc.)

VIII. FINAL ACCEPTANCE AND SIGNATURES (Provide a way for each stakeholder to indicate their acceptance of the project and sign their name.)
	Accept / Decline	Stakeholder Name:
	Accept / Decline	Stakeholder Name:
	Accept / Decline	Stakeholder Name:
	Accept / Decline	Stakeholder Name:
	Accept / Decline	Stakeholder Name:
	Accept / Decline	Stakeholder Name:

mailto:rick.rivera@dla.mil Project Status Report

4/7/11	Week Ending	12-Feb-22
Confidential and proprietary information - Not for distribution beyond initial recipients

PROJECT NAME: Replace Roadway, Install Dispenser and Spill Containment Area, and Construct Canopies

Current Health	Green	Project Manager	31-Dec-99	Phone
Prior Health	Green	Project Sponsor	31-Dec-99	Phone
Schedule Health	Green	Customer Contact	31-Dec-99	Phone
PROJECT DESCRIPTION/SCOPE	Demolish and Repair roadway.

Percent of Project Schedule Completed
25-Mar-00	% Complete

Project Expense / Budget to date
$ 80,000.00	Budget (K)
$ 62,000.00	Expense to date (K)

	Progress of Phases
		Validation (Trip)	Trip Report Completed	Trip Report Comments Due	PASB Submitted	Final SOW	Final AOW
Comments Due	RTA SOW	Proposal
Due	Tech.
Analysis	Source
Selection	Award Date	NTP
	Projected Date	03/15/04	04/21/04	07/01/04	07/01/04	07/01/04	07/01/04	07/01/04
	Actual Date	04/15/04	05/15/04	07/30/04	07/30/04	07/30/04	07/30/04	07/30/04

PROJECT STATUS (Date / Provide project status here. Leave old status reports to build a chronology of project status) (Example: 04/07/04 Project on track. Testing scheduled using the ABC environment)

SECTION 2. PROJECT BUDGET / COST TRACKING
Funding Document(s)	$	Date	Change #	Comments
SP0600MRXXXXXX
SP0600MRXXXXXX				(enter revised budget if approved through change process)
SP0600MRXXXXXX
SP0600MRXXXXXX
Total Budget	$0

SECTION 3. PROJECT INFORMATION (insert lines when needed)
DATE	ACCOMPLISHMENTS (DESCRIPTION)

DATE DECISIONS MADE

DATE ISSUES/ACTION ITEMS ASSIGNED TO DUE DATE

RISK/UPDATE		TRIGGER (Event to watch for)	MITIGATION PLAN	Probability	Impact	Risk Index
						31-Dec-99
						31-Dec-99
						31-Dec-99
						31-Dec-99
						31-Dec-99
DATE	CONCERNS REQUIRING MANAGEMENT ATTENTION				DATE RESOLVED

CHANGE # CHANGE

	SECTION 4. PROJECT SCHEDULE (PROJECT TIMELINE OR MILESTONES) (insert lines where needed)
	ITEM			START DATE	TARGET FINISH
DATE	ACTUAL FINISH DATE	ITEM STATUS/ HEALTH	COMMENTS

	Green
	Green
	Green
	Red
	Green
	Yellow
	Red
	Green
	Yellow
	Red
	Green
	Yellow
	Red
	Green
	Yellow
	Red
	Green
	Yellow
	Red
	Green
	Yellow
	Red
	Green
	Yellow
1) Office Button/Excel Options/Popular/Top options for working with Excel -
Check box Show Developer tab in Ribbon
2) Click Developer Tab
3) In Controls group click Insert
4) In Active X controls click on the bottom rightmost icon - More controls
5) Select Calendar Control 12.0 and click OK
6) Draw a box on the spreadsheet about 10 rows high and 5 columns wide
7) Right click on the calendar and select Properties
8) Change LinkedCell (blank) to be the cell you want the date to be in (A1,
G6 for example)
9) Click Design Mode in Controls group to exit Design Mode and have the
calendar work
10) Click on a date in the calendar and you should see that date in the cell
you entered in step 8
11) To make further changes click Developer tab, Controls group, Design
Mode, Click the calendar and change whatever

	Green
	Yellow
Make sure the Developer tab is showing in the ribbon (the toolbar at the top of the page). If it isn't, then click the "Office" button at the top left, then choose "Excel Options". This will bring up a pop up window. Put a check mark in the "Show Developer Tab in the Ribbon" option, then click "OK".	Red
2-Jan-00
Click on the "Developer" tab. Click on the small arrow below the "Insert" tab and choose "ActiveX Controls". Click the last icon in the list ("More controls").
3-Jan-00
Choose "Calendar Control" and press "OK".
4-Jan-00
Click on a cell in your worksheet where you would like to place the calendar. Click the "Design Mode" button to turn off design mode and return to normal operation.

80000 62000 http://www.ehow.com/how_5745005_add-down-calendar-excel-2007.html GanttChart Gantt Chart 31-Dec-99

[Project Name]

[Company Name]

Today's Date:

3/6/11

Sunday

(vertical red line)

Project Lead:

John Doe

[42]

Start Date:

1/1/11

Saturday

[42]

First Day of Week (Mon=2):

2-Jan-00

12/27/10

12/28/10

12/29/10

12/30/10

12/31/10

1/1/11

1/2/11

1/3/11

1/4/11

1/5/11

1/6/11

1/7/11

1/8/11

1/9/11

1/10/11

1/11/11

1/12/11

1/13/11

1/14/11

1/15/11

1/16/11

1/17/11

1/18/11

1/19/11

1/20/11

1/21/11

1/22/11

1/23/11

1/24/11

1/25/11

1/26/11

1/27/11

1/28/11

1/29/11

1/30/11

1/31/11

2/1/11

2/2/11

2/3/11

2/4/11

2/5/11

2/6/11

2/7/11

2/8/11

2/9/11

2/10/11

2/11/11

2/12/11

2/13/11

2/14/11

2/15/11

2/16/11

2/17/11

2/18/11

2/19/11

2/20/11

2/21/11

2/22/11

2/23/11

2/24/11

2/25/11

2/26/11

2/27/11

2/28/11

3/1/11

3/2/11

3/3/11

3/4/11

3/5/11

3/6/11

3/7/11

3/8/11

3/9/11

3/10/11

3/11/11

3/12/11

3/13/11

3/14/11

3/15/11

3/16/11

3/17/11

3/18/11

3/19/11

3/20/11

3/21/11

3/22/11

3/23/11

3/24/11

3/25/11

3/26/11

3/27/11

3/28/11

3/29/11

3/30/11

3/31/11

4/1/11

4/2/11

4/3/11

4/4/11

4/5/11

4/6/11

4/7/11

4/8/11

4/9/11

4/10/11

4/11/11

4/12/11

4/13/11

4/14/11

4/15/11

4/16/11

4/17/11

4/18/11

4/19/11

4/20/11

4/21/11

4/22/11

4/23/11

4/24/11

4/25/11

4/26/11

4/27/11

4/28/11

4/29/11

4/30/11

5/1/11

5/2/11

5/3/11

5/4/11

5/5/11

5/6/11

5/7/11

5/8/11

5/9/11

5/10/11

5/11/11

5/12/11

5/13/11

5/14/11

5/15/11

5/16/11

5/17/11

5/18/11

5/19/11

5/20/11

5/21/11

5/22/11

5/23/11

5/24/11

5/25/11

5/26/11

5/27/11

5/28/11

5/29/11

5/30/11

5/31/11

6/1/11

6/2/11

6/3/11

6/4/11

6/5/11

6/6/11

6/7/11

6/8/11

6/9/11

6/10/11

6/11/11

6/12/11

6/13/11

6/14/11

6/15/11

6/16/11

6/17/11

6/18/11

6/19/11

6/20/11

6/21/11

6/22/11

6/23/11

6/24/11

6/25/11

6/26/11

6/27/11

6/28/11

6/29/11

6/30/11

7/1/11

7/2/11

7/3/11

7/4/11

7/5/11

7/6/11

7/7/11

7/8/11

7/9/11

7/10/11

7/11/11

7/12/11

7/13/11

7/14/11

7/15/11

7/16/11

7/17/11

7/18/11

7/19/11

7/20/11

7/21/11

7/22/11

7/23/11

7/24/11

7/25/11

7/26/11

7/27/11

7/28/11

7/29/11

7/30/11

7/31/11

8/1/11

8/2/11

8/3/11

8/4/11

8/5/11

8/6/11

8/7/11

8/8/11

8/9/11

8/10/11

8/11/11

8/12/11

8/13/11

8/14/11

8/15/11

8/16/11

8/17/11

8/18/11

8/19/11

8/20/11

8/21/11

WBS

Jon: Work Breakdown Structure Level 1: 1, 2, 3, ...

Level 2: 1.1, 1.2, 1.3, ...

Level 3: 1.1.1, 1.1.2, 1.1.3, …

The WBS is automatically entered, but the formulas are different for different levels.	Tasks	Task
Lead	Start

Jon: Start Date Enter the starting date for this task. To associate the start date with the end of another task, enter a formula in the start date that refers to the end date of that task. End Jon: End Date The ending date is calculated by adding the Duration (calendar days) to the Start date minus 1 day, because the task duration is from the beginning of the Start day to the end of the End day.

Duration (Days) Jon: Duration (Calendar Days) Enter the number of calendar days for the given task. Refer to the Working Days column or use a calendar to determine the corresponding working days. The duration is from the beginning of the Start date to the ending of the End Date.

When the duration is calculated, it is calculated as End Date minus the Start Date plus 1 day, so that a task starting and ending on the same day has a duration of 1 day. % Complete Jon: Percent Complete Update the status of this task by entering the percent complete (between 0% and 100%). Working Days Jon: Working Days Counts the number of working days using the NETWORKDAYS() formula, which excludes weekends. When planning work based upon the number of working days, adjust the Duration until the desired # of working days is reached. Days Complete Jon: Calendar Days Complete This column is calculated by multiplying the Duration by the %Complete and rounding down to the nearest integer. Days Remaining Jon: Calendar Days Remaining This column is calculated by subtracting the Days Complete from the Duration.

Jon: Work Breakdown Structure Level 1: 1, 2, 3, ...

Level 2: 1.1, 1.2, 1.3, ...

Level 3: 1.1.1, 1.1.2, 1.1.3, … The WBS is automatically entered, but the formulas are different for different levels.

Jon: Start Date Enter the starting date for this task. To associate the start date with the end of another task, enter a formula in the start date that refers to the end date of that task.

Jon: End Date The ending date is calculated by adding the Duration (calendar days) to the Start date minus 1 day, because the task duration is from the beginning of the Start day to the end of the End day.

Jon: Duration (Calendar Days) Enter the number of calendar days for the given task. Refer to the Working Days column or use a calendar to determine the corresponding working days. The duration is from the beginning of the Start date to the ending of the End Date.

When the duration is calculated, it is calculated as End Date minus the Start Date plus 1 day, so that a task starting and ending on the same day has a duration of 1 day.

Jon: Percent Complete Update the status of this task by entering the percent complete (between 0% and 100%).

Jon: Working Days

Counts the number of working days using the NETWORKDAYS() formula, which excludes weekends. When planning work based upon the number of working days, adjust the Duration until the desired # of working days is reached.				27 - Dec - 10							03 - Jan - 11	10 - Jan - 11	17 - Jan - 11	24 - Jan - 11	31 - Jan - 11	07 - Feb - 11	14 - Feb - 11	21 - Feb - 11	28 - Feb - 11	07 - Mar - 11	14 - Mar - 11	21 - Mar - 11	28 - Mar - 11	04 - Apr - 11	11 - Apr - 11	18 - Apr - 11	25 - Apr - 11	02 - May - 11	09 - May - 11	16 - May - 11	23 - May - 11	30 - May - 11	06 - Jun - 11	13 - Jun - 11	20 - Jun - 11	27 - Jun - 11	04 - Jul - 11	11 - Jul - 11	18 - Jul - 11	25 - Jul - 11	01 - Aug - 11	08 - Aug - 11	15 - Aug - 11
	1-Jan-00	Task Category 1	John	1/05/09	1/14/11	740	0%	530	0	740
	1.1	Sub Task level 2		1/05/09	1/05/09	1	0%	1	0	1
	1.2	Sub Task level 2		1/05/09	1/05/09	1	0%	1	0	1
	1.2.1	Sub Task level 3		1/09/11	1/14/11	1	0%	5	0	1
	1.2.2	Sub Task level 3		1/05/09	1/05/09	1	0%	1	0	1
	1.3	Sub Task level 2		1/05/09	1/05/09	1	0%	1	0	1
	1.4	Sub Task level 2		1/05/09	1/05/09	1	0%	1	0	1
	2-Jan-00	Task Category 2	Jane	1/05/09	2/22/11	779	25%	557	194	585
	2.1	Sub Task level 2		1/05/09	1/11/09	7	25%	5	1	6
	2.2	Sub Task level 2		2/14/11	2/22/11	7	25%	7	1	6
	2.3	Sub Task level 2		1/05/09	1/11/09	7	25%	5	1	6
	2.4	Sub Task level 2		1/05/09	1/11/09	7	25%	5	1	6
	3-Jan-00	Task Category 3	Bill	1/05/09	2/07/09	34	50%	25	17	17
	3.1	Sub Task level 2		1/12/09	1/17/09	6	50%	5	3	3
	3.2	Sub Task level 2		1/19/09	1/24/09	6	50%	5	3	3
	3.3	Sub Task level 2		1/26/09	1/31/09	6	50%	5	3	3
	3.4	Sub Task level 2		2/02/09	2/07/09	6	50%	5	3	3
	4-Jan-00	Task Category 4	Bill	1/05/09	1/05/09	1	0%	1	0	1
	4.1	Sub Task level 2		1/05/09	1/05/09	1	0%	1	0	1
	4.2	Sub Task level 2		1/05/09	1/05/09	1	0%	1	0	1
	4.3	Sub Task level 2		1/05/09	1/05/09	1	0%	1	0	1
	4.4	Sub Task level 2		1/05/09	1/05/09	1	0%	1	0	1

TEMPLATE ROWS: Copy and insert the entire section, or just the specific sub tasks, depending on which level you want to use (formulas are different for different WBS levels)
1-Jan-00	Task Category 1	1/05/09	1/05/09	1	0%	1	0	1
1.1	Sub Task level 2	1/05/09	1/05/09	1	0%	1	0	1
1.2	Sub Task level 2	1/05/09	1/05/09	1	0%	1	0	1
1.2.1	Level 3 Task	1/05/09	1/05/09	1	0%	1	0	1
1.2.2	Level 3 Task	1/05/09	1/05/09	1	0%	1	0	1
1.2.2.1	Level 4 task	1/05/09	1/05/09	1	0%	1	0	1
1.3	Sub Task level 2	1/05/09	1/05/09	1	0%	1	0	1
1.4	Sub Task level 2	1/05/09	1/05/09	1	0%	1	0	1

HELP

- Modify the GREEN cells and the Tasks, and Task Lead columns.

- The number of weeks shown in the gantt chart is limited by the maximum number of columns available in Excel.

- The Start Date that you choose determines the first week in the gantt chart.

- Change the first day of the week via cell K8

- Use the slider to adjust the range of dates shown in the gantt chart.

- Only 34 weeks (7 1/2 months) can be shown/printed at one time, because each week uses up 7 columns.

Q: The Working Days column shows "###". How do I fix that?

You need to install the Analysis ToolPak add-in that comes with Excel. Go to Tools > Add-ins, and select Analysis ToolPak.

Q: How do I make Task 2 start the day after the end of Task 1?

Use the following formula for the start date of Task 2:

=EndDate+1 where EndDate is the reference to the cell containing the end date of task 1

Q: How do I add/insert tasks and subtasks?

Copy the entire ROW (or a group of rows) for the type of task(s) you want to add and then right-click on the row where you want to insert the new tasks, then select Insert Copied Cells. You can copy rows from within the gantt chart, or copy rows from the Template Rows.

Important Note: When inserting a new subtask after the last subtask or before the first subtask, you will need to update the formulas for calculating the Level 1 %Complete and Duration (see below) to include the new subtask, because the ranges won't automatically expand to include the additional row.

Q: How do I calculate the %Complete for a Level 1 task based upon the %Complete of all of the associated subtasks?

Example: If Task 1 is on row 10 and the subtasks are on rows 11-14, use the following formula:

=SUMPRODUCT(F11:F14,G11:G14)/SUM(F11:F14)

Q: How do I calculate the Duration for a Level 1 task based upon the largest end date of a sub task?

Example: If the Level 1 task is on row 10 and the sub tasks are on rows 11-14, use the following formula

=MAX(D11:D14)-C10+1

Q: How can I include holidays in the calculation of the Working Days?

You can add a list of holidays to exclude in the NETWORKDAYS function. See Excel's help (F1) for more information.

Q: How do I change the print settings?

Select the entire range of cells that you want to print and then go to File > Print Area > Set Print Area. Then go to File > Page Setup or File > Print Preview and adjust the Scaling and Page Orientation as desired.

Q: How do I use grouping?

You can expand or collapse a group of rows using Excel's "Group and Outline" feature. To define a group of rows, select the rows and go to Data > Group and Outline and select Group ...

Q: How do I change the background color of the bars in the Gantt Chart?

The colors used for the bars in the Gantt Chart are set using Conditional Formatting. The simplest approach for Excel 2002/2003 would be to change the colors via the color palette. Go to Tools > Options > Color tab. Or, you can select all of the cells in the Gantt Chart and go to Format > Conditional Formatting to change the colors.

Sheet1

DATA FIELD	DESCRIPTION
Facility Number
Service
Location
State / Country
City
Inspection Firm
Inspector
Inspection Date
Tank Capacity
Working Capacity
Tank Contents
Manufacturer
Date of Construction
Tank Serial Number
Tank Diameter
Tank Length / Height
Tank Life
Last Formal Inspection
Date of Last Formal Inspection
Tank Condition
Recommended Time Until Next Formal Inspection
Material
Tank Type
Level Alarms
Roof Type
Type of Internal Floating Roof
Type of Internal Floating Roof Seal
Piping Type
Tank Corrosion control
Secondary Containment
Percent Secondary Containment
Leak Detection
Overflow Protection
Vapor control
SPCC
Permit to Operate
Organization
Pressure Vessel
STI
Latitude
Longitude
Chemical Abstract Number
Usage
Color
Primary Contact Name
Primary Contact Phone
Secondary Contact Name
Secondary Contact Phone
Facility Manager Name
Facility Manager Phone
Environmental POC Name
Environmental POC Phone
Environmental POC email
POC Date
Repair Cost
Risk
Legible Name Plate
Status
Date Inactive / Removed

image1.gif image2.png

File details come from the government source that posted it. Updated Feb 19, 2025.