Project Master is a dashboard for viewing IT project schedules, resource assignments, and capacity data. Project data syncs automatically from Azure DevOps.
URL: resourcescheduler.z19.web.core.windows.net/scheduler.html
Sign in with your Streck Microsoft account. The app opens to the Schedule tab by default.
The main view showing all IT projects on a Gantt-style timeline.
Use the filter bar at the top to narrow what's shown:
Each row shows a project. Click a column header to sort.
| Column | Description |
|---|---|
| Project | Project name — click to open details |
| Pri | Priority (1 = highest) |
| Category | Active, New, On Hold, or Closed |
| Health | On Track, At Risk, or Off Track |
| Start | Start date |
| Target | Target date |
| ADO % | Work item completion percentage from ADO |
Use the Columns button in the filter bar to show or hide columns.
To the right of the table is a timeline visualization:
Click any project name to open a detail panel showing:
Start date, target date, duration, state, priority, health, project manager
Area path, link to open the project directly in Azure DevOps
Who is assigned, their allocation percentage, and date ranges
Milestone names, health status, dates, and story completion counts
Monthly utilization per assigned person, color-coded green / yellow / red
Total work items, active/closed/new counts, and a progress bar
A capacity heatmap showing each person's monthly utilization across all assigned projects.
Each row is a person; each column is a month. The number in each cell is their total utilization percentage.
| Color | Range | Meaning |
|---|---|---|
| 67% | Under 80% | Healthy capacity |
| 92% | 80 – 100% | Near capacity |
| 115% | Over 100% | Over-allocated |
An alert banner at the top lists anyone currently over-allocated.
Click a person's name to see:
A table of all project milestones with filters for Project, Health, and Team.
Each row shows: milestone title, parent project, team, health status, start/target dates, and story completion progress.
Click a row to jump to that project's detail panel.
A sortable, filterable table of all projects with a broader set of columns than the Schedule tab.
Project, Team, State, Health, PM, Start, Target (flagged if overdue), Progress %, Priority, and Milestone counts. Click any column header to sort.
A high-level dashboard summarizing portfolio health at a glance.
Count of active projects by health status
Projects by state: Active, New, On Hold, Closed
Average utilization across all people
People assigned beyond 100% and which months
Next 8 milestones due (not yet complete)
Active projects flagged At Risk or Off Track
Projects past their target date
Projects due within the next 30 days
Projects closed in the last 30/90 days
Average utilization: current month + next 2
AI-generated observations about the project portfolio, refreshed periodically.
Use the filter pills and severity dropdown to focus on what matters. Click an insight row to jump to the related project.
Shows Azure resource costs for IT applications.
| Control | What It Does |
|---|---|
| Search box | Search projects or people across all tabs |
| Sync ADO | Manually trigger a fresh data pull from Azure DevOps |
| Theme toggle | Switch between light and dark mode |
| Sign out | Ends your session |
| Key | Action |
|---|---|
| 1 | Switch to Schedule tab |
| 2 | Switch to People tab |
| S | Sync from ADO |
| Esc | Close the detail panel |
| ↑ ↓ | Navigate between project rows (Schedule tab) |
Project Master pulls project data from Azure DevOps automatically. Here's how ADO structures map to what you see in the app.
The sync queries 8 ADO team projects: Streck, LabVantage, CRM, SyteLine, DataWarehouse, Reliance, Streck Sites, and Intake.
Each "project" in the scheduler corresponds to an AreaLevel2 path in ADO — the second level of the area hierarchy. For example, in the Streck team project, the area path Streck\Statslink becomes the "Statslink" project in the scheduler.
The unique key for each project is the combination of team project and area name, like Streck\Statslink or CRM\CRM Upgrade.
Certain area paths are automatically excluded: General Support, Archived, and any areas starting with ADO. Admins can exclude additional areas from Settings.
Each project in ADO has a Project work item type (a custom WIT). The sync queries all Project WITs and matches them to their AreaLevel2 path. From each Project WI, the scheduler pulls:
| ADO Field | Shows Up As |
|---|---|
| System.State | Category (Active, New, On Hold, Closed) |
| Microsoft.VSTS.Common.Priority | Priority (1–4) |
| Custom.ProjectScheduleHealth | Health (On Track, At Risk, Off Track) |
| Microsoft.VSTS.Scheduling.StartDate | Start Date |
| Microsoft.VSTS.Scheduling.TargetDate | Target Date |
| Microsoft.VSTS.Common.ClosedDate | Closed Date |
| System.AssignedTo | Project Manager |
| Custom.ApplicationName | Application |
For each area path, the sync also counts all child work items (Epics, Features, User Stories, Issues, Bugs, Tasks) grouped by state:
The ADO % column is calculated from story points when available (closed points / total points). If no story points are estimated, it falls back to a simple item count ratio (closed / total).
The list of people in the scheduler comes from work item assignments — anyone with an Assigned To on a work item under a project's area path is included. Team membership APIs are not used; only actual assignment data drives the people list.
Milestones are a separate ADO work item type (Milestone). The sync pulls all Milestones, matches them to their AreaLevel2 path, and fetches their child item counts via hierarchy links. The health field comes from Custom.MilestoneHealth.
The sync runs automatically when you open the app and the data is more than an hour old. You can also trigger it manually with the Sync ADO button. A typical sync makes ~20 API calls to ADO and takes a few seconds.