How do I set up project development software to track permits, land, and interconnection milestones across multiple renewable sites?

To track permits, land, and interconnection milestones across multiple renewable energy sites, you’ll want a project development system that combines:

1. A single master project database
2. Standardized milestone templates
3. Workflow/status tracking
4. Document management
5. Reporting/dashboarding
6. Role-based updates and audit trail

Here’s a practical setup.

---

1) Define the core structure

Create one record for each site/project, and then break it into tracked workstreams:

• Permitting
• Land / real estate
• Interconnection
• Environmental / studies
• Community / stakeholder
• Engineering
• Commercial / offtake
• Construction readiness

For each site, capture:

• Project name
• Location
• Technology type
• MW capacity
• Utility / ISO
• County/state
• Current phase
• Target COD
• Owner / manager
• Key risk level

---

2) Build a milestone framework for each workstream

Use a consistent milestone list so every project is tracked the same way.

Permitting milestones

• Jurisdictional review complete
• Permitting matrix created
• Application submitted
• Completeness review passed
• Public notice issued
• Hearing completed
• Permit approved
• Permit conditions closed

Land milestones

• Site identified
• Site control initiated
• Option/lease drafted
• Lease signed
• Title review complete
• Easements secured
• Survey complete
• Access agreement executed

Interconnection milestones

• Queue application submitted
• Study agreement executed
• Feasibility study complete
• System impact study complete
• Facilities study complete
• Interconnection agreement received
• Interconnection agreement executed
• Deposit paid
• Network upgrade scope confirmed

Each milestone should have:

• Status: Not started / In progress / Complete / Blocked
• Owner
• Due date
• Actual completion date
• Dependency
• Notes / comments
• Risk flag

---

3) Choose the right software setup

Option A: Project management platform

Use tools like:

• Monday.com
• Smartsheet
• Asana
• Airtable
• Microsoft Project / Planner
• Jira Work Management

Best if you want:

• Simple task tracking
• Gantt charts
• Automated reminders
• Custom fields
• Dashboards

Option B: Database + workflow system

Use:

• Airtable
• Smartsheet
• Microsoft Lists + Power BI
• Notion with databases

Best if you need:

• Portfolio-level tracking
• Strong filtering and views
• Easy milestone templates
• Flexible reporting across many sites

Option C: Enterprise solution

Use:

• Procore
• Unanet
• Oracle Primavera
• Custom Power Apps / Salesforce-based system

Best if you need:

• More users
• Approval workflows
• Audit trails
• ERP/finance integration
• Complex program management

---

4) Design the data model

At minimum, set up these tables/modules:

A. Projects table

One row per site.

Fields:

• Project ID
• Project name
• Region
• MW
• Phase
• PM
• Status
• COD target
• Priority
• Risk level

B. Milestones table

One row per milestone.

Fields:

• Project ID
• Workstream
• Milestone name
• Planned date
• Forecast date
• Actual date
• Status
• Owner
• Dependency
• Comments

C. Documents table

Track:

• Permit applications
• Lease agreements
• Title reports
• Interconnection study reports
• Utility correspondence
• Maps / exhibits
• Certificates / approvals

Fields:

• Project ID
• Document type
• Version
• Upload date
• Expiration date
• Approval status
• Link/location

D. Issues / risks table

Track:

• Delay reason
• Probability
• Impact
• Mitigation
• Escalation owner
• Due date

---

5) Standardize status codes and color rules

Use the same colors everywhere:

• Green = Complete / on track
• Yellow = At risk / pending soon
• Red = Delayed / blocked
• Gray = Not started / inactive

And define milestone aging rules:

• Overdue by 0–14 days: yellow
• Overdue by 15+ days: red
• Due within 30 days: orange/yellow
• Complete: green

This makes portfolio reviews much easier.

---

6) Create portfolio dashboards

You should be able to answer these questions instantly:

• Which projects are closest to NTP/COD?
• Which permits are overdue?
• Which sites are waiting on land signatures?
• Which interconnection studies are delayed?
• Which projects are blocked by utility or county actions?
• What is the next 90-day critical path?

Useful dashboard widgets:

• Count of projects by phase
• Milestones due in next 30/60/90 days
• Overdue milestones by workstream
• Sites with blocked interconnection
• Sites lacking site control
• Permit approval pipeline
• COD slippage vs baseline

---

7) Automate alerts and workflow

Set up automation for:

• Due date reminders
• Escalation when a milestone is overdue
• Notifications when a document expires
• Approval requests when a permit is submitted
• Weekly status summary emails
• Change log for milestone updates

Examples:

• “If interconnection study due date is within 14 days, notify PM.”
• “If permit application status = blocked, assign to regional lead.”
• “If lease expiration is within 60 days, alert land manager.”

---

8) Use a monthly or weekly update cadence

For multi-site renewable portfolios, require each project lead to update:

• Milestone status
• Forecast dates
• Risks/issues
• Key documents
• Next 30-day actions

Then run a portfolio review:

• What changed since last week?
• Which milestones slipped?
• What decisions are needed?
• What external dependencies exist?

---

9) Build templates for each project type

Different technologies have different milestones:

• Solar
• Wind
• Battery storage
• Hybrid projects
• Transmission-only or gen-tie projects

Create templates with:

• Common milestone sets
• Technology-specific milestones
• State/utility-specific permit steps
• Queue-specific interconnection steps

This saves time and ensures consistency.

---

10) Add document and version control

Use a shared repository structure:

• 01 Permitting
• 02 Land
• 03 Interconnection
• 04 Environmental
• 05 Engineering
• 06 Commercial
• 07 Agreements
• 08 Maps and GIS

Require:

• Naming conventions
• Version numbers
• Approval dates
• Expiration tracking
• Link back to project record

---

11) Include GIS or site maps if possible

If you’re managing multiple land parcels and utility touchpoints, add:

• Parcel maps
• Easement routes
• Substation locations
• Queue point coordinates
• Environmental constraint overlays

This can be done through:

• ArcGIS
• QGIS
• Google Earth layers
• Power BI map visuals
• Airtable/Smartsheet links to GIS files

---

12) Define governance

Assign ownership clearly:

• Project manager: overall milestone accountability
• Land manager: site control and easements
• Permitting lead: permit schedule and agency interactions
• Interconnection lead: queue/study/agreement status
• Document controller: file management and version control
• Program manager: portfolio reporting and escalations

Set rules for:

• Who can edit dates
• Who approves changes
• How escalations happen
• How baseline schedule changes are documented

---

13) Recommended simplest implementation

If you want a fast, practical setup:

Use Airtable or Smartsheet with:

• Projects table
• Milestones table
• Documents table
• Issues table
• Dashboard views

Then add:

• Gantt view
• Calendar view
• Kanban by status
• Automated reminders
• Weekly PDF or email report

This is often enough for a renewable development team without needing a full enterprise system.

---

14) Example minimum fields to start with

Projects

• Project ID
• Project Name
• State
• County
• MW
• Technology
• PM
• Phase
• COD Target

Milestones

• Project ID
• Workstream
• Milestone
• Planned Date
• Forecast Date
• Actual Date
• Status
• Owner
• Notes

Documents

• Project ID
• Doc Type
• Doc Name
• Version
• Upload Date
• Expiration Date
• Link

Risks

• Project ID
• Risk
• Severity
• Likelihood
• Mitigation
• Owner
• Due Date

---

15) Best practice: track both baseline and forecast

For each milestone, keep:

• Baseline date = original plan
• Forecast date = current expected completion
• Actual date = when completed

This allows you to measure slippage and know whether a project is trending worse or improving.

---

If you want, I can also give you:

1. a sample Airtable/Smartsheet schema,
2. a renewable project milestone template, or
3. a dashboard layout for portfolio reporting.