Knowledge Base — ProjectXL
ProjectXL

Practical Guides

Actionable how-to documentation.

Practical

A New Look at Network Diagrams

From Henry Gantt to Activity-on-Edge: How Schedule Visualization Continues to Evolve

Eric Christoph arrow_forward
Practical

Smarter Task Estimating

Traditional estimating methods like PERT and triangular distributions underestimate risk. This article introduces a 10-level risk banding rubric paired with beta distributions and Monte Carlo simulation to produce higher-confidence schedules and drive better team performance.

Eric Christoph arrow_forward
Practical

Extracting Local Task Custom Fields from Project Server with Power Query

A complete Power Query solution for extracting local task custom fields from the ProjectServer API, resolving internal field names and lookup table entries into a clean, pivoted table ready for reporting in Excel or Power BI.

Eric Christoph arrow_forward
Practical

Extracting Project Online Task Data with the ProjectServer API

Before you can extract local custom field data from Project Online tasks, you need to understand what the ProjectServer API actually returns. Spoiler: it's a lot, it's opaque, and it's not pretty.

Eric Christoph arrow_forward
Practical

Accessing the ProjectServer API in Power Query

This is the first of three articles showing how to use Power Query and the ProjectServer API to get project task data from Project Online

Eric Christoph arrow_forward
Practical

Beginner’s Guide: Extracting Project Online Data into Power BI & Excel with Power Query

A step-by-step guide to pulling project task data from the Project Online Reporting API using Power Query in Excel or Power BI. Covers API access, field selection, JSON-to-table conversion, and date format transformations.

Eric Christoph arrow_forward
home Home route Walkthrough forum Forum menu_book Knowledge Base info About payments Pricing