Features › Technical specification
Feature · Technical specification
Only its author can read it. Now every developer can.
A Key User's Excel often holds the whole logic of a process. Project Intelligence Framework reads every formula and every value, and produces a review file the Key User corrects and signs, and a complete specification for the developers.
Project Intelligence Framework is in continuous development. Some features may work differently from what this film shows.
What the specification holds
The logic, laid out.
Inputs, tables and outputs
What the user enters, the reference tables used, and every result.
Calculations in plain language
Every formula, explained in a sentence the Key User can check.
Test cases
Today's values become mandatory test cases for the developer.
Inconsistencies
A value typed over a formula, a row calculated differently: flagged.
Questions
What the Excel cannot say is asked: of the Key User, and of the requester, from the output format to its recipients and timing.
For the developers
Current process, target solution with diagrams, data sources, calculation rules, output, test cases, open questions and effort drivers.
The result
- The Key User needs no technical experience.
- The developer gets everything needed to build it right.
What you need
- A project with the governance document switched on
- The Key User's Excel, in the project's Governance/Input folder
- A Microsoft 365 work account
How to use it
- Before you start: the Key User places the Excel in Governance/Input and lists it as “Technical specification” in the Attachments sheet.
- Command: type “/” in Claude and choose
/bid-pmo:pif-tech-spec, followed by the file name. - In your own words: “Build the technical specification for Pricing calculator.xlsx in AB-001.”
- Manual: Technical specification from Excel.