Job Description
**Description:**
I need an Excel workbook that produces a DOT-style progress schedule similar to a two-page sample I will provide. The deliverable should include:
1. **Sheet 1 – Bar Chart Schedule (Gantt/Bar Chart):**
* Stacked bar Gantt schedule showing activities over calendar dates.
* Activities listed vertically, time shown horizontally with gridlines (weekly/monthly).
* Uses a helper start offset + duration method so bars appear at the correct dates.
* Clean, printable layout (letter or 11x17—tell me what you prefer).
* Header fields at top (Project, Contract #, County, Date, Contractor).
2. **Sheet 2 – Progress Curve (S-Curve):**
* Line chart showing **cumulative planned % complete (0–100%)** over time (calendar days or weekly points).
* Curve should be driven from the same schedule logic using **weights (%) by activity or work group** totaling 100%.
* Clean, printable layout matching the bar schedule styling.
**Inputs I will provide:**
* A ...
I need an Excel workbook that produces a DOT-style progress schedule similar to a two-page sample I will provide. The deliverable should include:
1. **Sheet 1 – Bar Chart Schedule (Gantt/Bar Chart):**
* Stacked bar Gantt schedule showing activities over calendar dates.
* Activities listed vertically, time shown horizontally with gridlines (weekly/monthly).
* Uses a helper start offset + duration method so bars appear at the correct dates.
* Clean, printable layout (letter or 11x17—tell me what you prefer).
* Header fields at top (Project, Contract #, County, Date, Contractor).
2. **Sheet 2 – Progress Curve (S-Curve):**
* Line chart showing **cumulative planned % complete (0–100%)** over time (calendar days or weekly points).
* Curve should be driven from the same schedule logic using **weights (%) by activity or work group** totaling 100%.
* Clean, printable layout matching the bar schedule styling.
**Inputs I will provide:**
* A ...
Ready to Apply?
Take the next step in your AI career. Submit your application to Confidential today.
Submit Application