funded-report-assistant

Tracker lint, source-referenced progress reports and review packs for a funded R&D project. By Pavan Yadav Annappa. Code on GitHub

All project data on these pages is fictional. "eDrive-X" and Partners A-D are generated by a seeded script; no real company, person or project data is used.

Sample tracker + minutes

The input: data/edrive-x/tracker.xlsx (status values with mixed case and some DD.MM.YYYY dates on purpose) and seven meeting minutes. Eight inconsistencies were planted, listed in data/edrive-x/planted.json.

Sheet Meta

RowKeyValue
1ProjecteDrive-X (FICTIONAL example project)
2Full titleFictional demonstrator for a GaN-based eDrive inverter and eAxle integration
3FundingFictional national R&D programme (example data only)
4ConsortiumPartner A (coordinator), Partner B, Partner C, Partner D (all fictional)
5Project start2025-07-01
6Project end2027-12-31
7As of2026-07-10
8NoteAll content is generated by fra.generator. No real company, person or project data.
9Seed11

Sheet WorkPackages

RowWPTitleLeadStartEndPlanned PM totalPlanned PM to dateActual PM to dateStatus
2WP1Project management and reportingPartner A2025-07-012027-12-313614.713.6 active
3WP2Requirements and eAxle system architecturePartner A2025-07-012026-06-30303045.9finished
4WP3GaN power module and gate driverPartner C2025-09-012027-03-316434.737.3 active
5WP4Inverter control softwarePartner B2025-10-012027-06-30522321.4 active
6WP5eAxle integration and thermal designPartner B2026-01-012027-09-305817.316.3active
7WP6Test bench validation and disseminationPartner D2026-04-012027-12-31446.96.7active

Sheet Milestones

RowIDWPTitleDue dateActual dateStatusEvidence
2M1WP2Requirements specification released11.10.2025delayed
3M2WP3Gate driver concept reviewed2026-01-112025-12-31done https://share.example.org/edrive-x/evidence/M2.pdf
4M3WP3First GaN half-bridge samples tested2026-02-06delayed
5M4WP2System architecture frozen2026-04-092026-04-17Done
6M5WP6Test bench specification released20.07.2026in progress
7M6WP3Power module design freeze2026-08-28 planned
8M7WP6Test bench commissioned2026-09-07in progress
9M8WP4Control software architecture defined2026-11-04planned
10M9WP5Thermal concept reviewed23.11.2026planned
11M10WP5eAxle integration concept frozen06.03.2027planned
12M11WP1Project handbook released16.03.2027Planned
13M12WP1Interim report submitted2027-04-22 planned
14M13WP4Field-oriented control running on target2027-05-21planned
15M14WP5First eAxle prototype assembled2027-08-12planned

Sheet ActionItems

RowIDWPMilestoneDescriptionOwnerDue dateStatusLast updateSource
2A-001WP2M4Define the DC-link voltage rangeSystems engineer (Partner A)2025-09-14Closed2025-09-06MR-01
3A-002WP1Circulate the review meeting agendaCoordinator (Partner A)2025-08-13 closed2025-08-11MR-01
4A-003WP2Agree the mechanical interface of the eAxleSystems engineer (Partner A)2025-08-18closed 2025-08-13MR-01
5A-004WP1Update the dissemination planProject office (Partner A)2025-12-17Closed2025-12-08MR-02
6A-005WP2Close open points in the interface control documentLead WP2 (Partner A)2025-10-27Cancelled18.10.2025MR-02
7A-006WP3M2Check dV/dt limits against the motor insulation specLead WP3 (Partner C)2026-08-12open2025-11-21MR-02
8A-007WP1Upload signed minutes to the project shareProject office (Partner A)2025-12-14 closed14.12.2025MR-03
9A-008WP4Document the PWM timing assumptionsLead WP4 (Partner B)04.01.2026closed2025-12-25MR-03
10A-009WP4Add overcurrent shutdown test casesLead WP4 (Partner B)2026-02-16closed2026-02-15MR-03
11A-011WP2M4Review safety requirements with WP4Lead WP2 (Partner A)2026-03-10 closed2026-03-09MR-04
12A-012WP1Collect person-month figures from partnersProject office (Partner A)2026-03-05Closed2026-03-03MR-02
13A-013WP1Circulate the review meeting agendaCoordinator (Partner A)2026-05-14closed2026-05-09MR-05
14A-014WP1Prepare input for the interim reportProject office (Partner A)03.07.2026 closed2026-06-23MR-05
15A-015WP5Agree the busbar routingThermal engineer (Partner B)15.06.2026Closed2026-06-14MR-05
16A-016WP3Run the double-pulse test campaignLead WP3 (Partner C)16.07.2026 in progress2026-07-09MR-06
17A-017WP6Order the power analyserLead WP6 (Partner D)11.07.2026open 20.06.2026MR-06
18A-018WP6M5Define the validation test matrixLead WP6 (Partner D)2026-08-05In progress2026-06-21MR-06
19A-019WP4Port the current controller to the target MCULead WP4 (Partner B)2026-06-23 closed2026-06-13MR-06
20A-020WP1Prepare input for the interim report2026-08-21Open2026-07-01MR-06
21A-021WP1Collect person-month figures from partnersProject office (Partner A)2026-08-09in progress 2026-06-27MR-07
22A-022WP6M5Prepare the conference abstractLead WP6 (Partner D)2026-10-15In progress25.06.2026MR-07
23A-023WP4Add overcurrent shutdown test casesLead WP4 (Partner B)2026-08-20open 2026-06-30MR-07
24A-024WP1M11Update the dissemination planProject office (Partner A)27.04.2026In progress2026-07-09MR-07
25A-025WP2M1Agree recovery plan for M1Lead WP2 (Partner A)2026-08-01in progress 2026-06-15MR-07
26A-026WP3M3Agree recovery plan for M3Lead WP3 (Partner C)2026-08-10in progress01.07.2026MR-07

Sheet Risks

RowIDWPDescriptionProbabilityImpactMitigationOwnerStatus
2R-01WP2Late changes to interface requirements24Freeze the interface with a formal change processLead WP2 (Partner A)Closed
3R-02WP4Target MCU resources too small for the control loop43 Lead WP4 (Partner B)watching
4R-03WP3Switching losses higher than expected44Plan an extra layout iteration in the scheduleLead WP3 (Partner C)Open
5R-04WP6Dynamometer slot not available in time43Book the bench slot six months aheadLead WP6 (Partner D)open
6R-05WP6Measurement equipment calibration expired43Track calibration dates in the bench logLead WP6 (Partner D)watching

Meeting minutes

minutes/2025-07-15_MR-01.md
# MR-01 Kick-off meeting - 2025-07-15

Project: eDrive-X (FICTIONAL example project)
Meeting: MR-01
Date: 2025-07-15
Type: kick-off meeting
Milestone: -
Attendees: Partner A (coordinator), Partner B, Partner C, Partner D

## Status of actions

- none

## Milestones reviewed

- none

## Decisions

- D-01-1 [WP1]: Reporting template v2 is used for all partner inputs

## New action items

Format: id | WP | milestone | owner | due date | description

- A-001 | WP2 | M4 | Systems engineer (Partner A) | due 2025-09-14 | Define the DC-link voltage range
- A-002 | WP1 | - | Coordinator (Partner A) | due 2025-08-13 | Circulate the review meeting agenda
- A-003 | WP2 | - | Systems engineer (Partner A) | due 2025-08-18 | Agree the mechanical interface of the eAxle
minutes/2025-09-27_MR-02.md
# MR-02 Progress meeting - 2025-09-27

Project: eDrive-X (FICTIONAL example project)
Meeting: MR-02
Date: 2025-09-27
Type: progress meeting
Milestone: -
Attendees: Partner A (coordinator), Partner B, Partner C, Partner D

## Status of actions

- A-001: closed. Done, result filed on the project share.
- A-002: closed. Done, result filed on the project share.
- A-003: closed. Done, result filed on the project share.

## Milestones reviewed

- none

## Decisions

- D-02-1 [WP2]: Peak motor power target stays at 250 kW
- D-02-2 [WP1]: Next review meeting moves online

## New action items

Format: id | WP | milestone | owner | due date | description

- A-004 | WP1 | - | Project office (Partner A) | due 2025-12-17 | Update the dissemination plan
- A-005 | WP2 | - | Lead WP2 (Partner A) | due 2025-10-27 | Close open points in the interface control document
- A-006 | WP3 | M2 | Lead WP3 (Partner C) | due 2025-11-21 | Check dV/dt limits against the motor insulation spec
minutes/2025-11-22_MR-03.md
# MR-03 Milestone review - 2025-11-22

Project: eDrive-X (FICTIONAL example project)
Meeting: MR-03
Date: 2025-11-22
Type: milestone review
Milestone: M1
Attendees: Partner A (coordinator), Partner B, Partner C, Partner D

## Status of actions

- A-004: in progress. Work ongoing, update at next meeting.
- A-005: cancelled. No longer needed.
- A-006: closed. Done, result filed on the project share.

## Milestones reviewed

- M1 (WP2): Requirements specification released, due 2025-10-11

## Decisions

- D-03-1 [WP4]: Field weakening is tested in phase 2
- D-03-2 [WP1]: The project share is the single place for evidence

## New action items

Format: id | WP | milestone | owner | due date | description

- A-007 | WP1 | - | Project office (Partner A) | due 2025-12-14 | Upload signed minutes to the project share
- A-008 | WP4 | - | Lead WP4 (Partner B) | due 2026-01-04 | Document the PWM timing assumptions
- A-009 | WP4 | - | Lead WP4 (Partner B) | due 2026-02-16 | Add overcurrent shutdown test cases
minutes/2026-01-25_MR-04.md
# MR-04 Milestone review - 2026-01-25

Project: eDrive-X (FICTIONAL example project)
Meeting: MR-04
Date: 2026-01-25
Type: milestone review
Milestone: M2
Attendees: Partner A (coordinator), Partner B, Partner C, Partner D

## Status of actions

- A-004: closed. Done, result filed on the project share.
- A-007: closed. Done, result filed on the project share.
- A-008: closed. Done, result filed on the project share.
- A-009: in progress. Work ongoing, update at next meeting.

## Milestones reviewed

- M2 (WP3): Gate driver concept reviewed, due 2026-01-11

## Decisions

- D-04-1 [WP1]: Partners report person-months every quarter
- D-04-2 [WP3]: Switching frequency target is 40 kHz

## New action items

Format: id | WP | milestone | owner | due date | description

- A-010 | WP3 | - | Lead WP3 (Partner C) | due 2026-05-01 | Check dV/dt limits against the motor insulation spec
- A-011 | WP2 | M4 | Lead WP2 (Partner A) | due 2026-03-10 | Review safety requirements with WP4
- A-012 | WP1 | - | Project office (Partner A) | due 2026-03-05 | Collect person-month figures from partners
minutes/2026-03-28_MR-05.md
# MR-05 Milestone review - 2026-03-28

Project: eDrive-X (FICTIONAL example project)
Meeting: MR-05
Date: 2026-03-28
Type: milestone review
Milestone: M3
Attendees: Partner A (coordinator), Partner B, Partner C, Partner D

## Status of actions

- A-009: closed. Done, result filed on the project share.
- A-010: in progress. Work ongoing, update at next meeting.
- A-011: closed. Done, result filed on the project share.
- A-012: closed. Done, result filed on the project share.

## Milestones reviewed

- M3 (WP3): First GaN half-bridge samples tested, due 2026-02-06

## Decisions

- D-05-1 [WP4]: Control loop runs at 20 kHz

## New action items

Format: id | WP | milestone | owner | due date | description

- A-013 | WP1 | - | Coordinator (Partner A) | due 2026-05-14 | Circulate the review meeting agenda
- A-014 | WP1 | - | Project office (Partner A) | due 2026-07-03 | Prepare input for the interim report
- A-015 | WP5 | - | Thermal engineer (Partner B) | due 2026-06-15 | Agree the busbar routing
minutes/2026-05-27_MR-06.md
# MR-06 Milestone review - 2026-05-27

Project: eDrive-X (FICTIONAL example project)
Meeting: MR-06
Date: 2026-05-27
Type: milestone review
Milestone: M4
Attendees: Partner A (coordinator), Partner B, Partner C, Partner D

## Status of actions

- A-010: closed. Done, result filed on the project share.
- A-013: closed. Done, result filed on the project share.
- A-014: in progress. Work ongoing, update at next meeting.
- A-015: in progress. Work ongoing, update at next meeting.

## Milestones reviewed

- M4 (WP2): System architecture frozen, due 2026-04-09

## Decisions

- D-06-1 [WP3]: A second GaN sample supplier is qualified
- D-06-2 [WP4]: AUTOSAR is not used for the demonstrator software

## New action items

Format: id | WP | milestone | owner | due date | description

- A-016 | WP3 | - | Lead WP3 (Partner C) | due 2026-07-16 | Run the double-pulse test campaign
- A-017 | WP6 | - | Lead WP6 (Partner D) | due 2026-07-11 | Order the power analyser
- A-018 | WP6 | M5 | Lead WP6 (Partner D) | due 2026-08-05 | Define the validation test matrix
- A-019 | WP4 | - | Lead WP4 (Partner B) | due 2026-06-23 | Port the current controller to the target MCU
- A-020 | WP1 | - | Coordinator (Partner A) | due 2026-08-21 | Prepare input for the interim report
minutes/2026-07-03_MR-07.md
# MR-07 Progress meeting - 2026-07-03

Project: eDrive-X (FICTIONAL example project)
Meeting: MR-07
Date: 2026-07-03
Type: progress meeting
Milestone: -
Attendees: Partner A (coordinator), Partner B, Partner C, Partner D

## Status of actions

- A-014: closed. Done, result filed on the project share.
- A-015: closed. Done, result filed on the project share.
- A-016: in progress. Work ongoing, update at next meeting.
- A-017: in progress. Work ongoing, update at next meeting.
- A-018: in progress. Work ongoing, update at next meeting.
- A-019: closed. Done, result filed on the project share.
- A-020: in progress. Work ongoing, update at next meeting.

## Milestones reviewed

- none

## Decisions

- none

## New action items

Format: id | WP | milestone | owner | due date | description

- A-021 | WP1 | - | Project office (Partner A) | due 2026-08-09 | Collect person-month figures from partners
- A-022 | WP6 | M5 | Lead WP6 (Partner D) | due 2026-10-15 | Prepare the conference abstract
- A-023 | WP4 | - | Lead WP4 (Partner B) | due 2026-08-20 | Add overcurrent shutdown test cases
- A-024 | WP1 | M11 | Project office (Partner A) | due 2026-08-27 | Update the dissemination plan
- A-025 | WP2 | M1 | Lead WP2 (Partner A) | due 2026-08-01 | Agree recovery plan for M1
- A-026 | WP3 | M3 | Lead WP3 (Partner C) | due 2026-08-10 | Agree recovery plan for M3

Pre-rendered by scripts/build_site.py from the files in the repository.