# GeoLynx — Benefit Analysis

**Prepared for:** [Client Name]
**Date:** [Date]
**Prepared by:** [Your Name]

---

## Executive Summary

GeoLynx replaces a fragmented set of spreadsheets, manual GIS processes, and disconnected tracking tools with a single, purpose-built platform for fibre network deployment. This document quantifies the operational time savings and risk reductions delivered by GeoLynx against the equivalent manual workflows.

**Headline numbers** *(update with actuals)*

| Metric | Value |
|---|---|
| Estimated hours saved per week | [X hrs/week] |
| Estimated FTE equivalent | [X FTE] |
| Projects actively managed | [X] |
| Wayleave accounts tracked | [X] |
| Premises under management | [X] |

---

## Methodology

Time estimates are based on representative task durations for a team managing [X] concurrent projects and [X] wayleave accounts. "Manual" means the previous/alternative approach using spreadsheets, standalone GIS tools (QGIS/ArcGIS), and email/phone coordination. Times marked *(estimate)* should be validated against actual team timesheets or task logs.

---

## 1. Project Management

### 1.1 Project Setup & Status Tracking

**Manual process:** Create a new row/tab in a master spreadsheet. Populate project fields. Share with team by email. Update status manually as work progresses. No single source of truth — version conflicts common.

| Task | Manual (per project) | GeoLynx | Saving |
|---|---|---|---|
| Create new project record | 20 min | 3 min | 17 min |
| Update project status | 5 min (find + update + share) | 30 sec | ~4.5 min |
| Assign project manager / supplier | 5 min | 1 min | 4 min |
| Add journal note / team update | 10 min (email chain) | 1 min | 9 min |
| **Per project, first month** | **~60 min** | **~10 min** | **~50 min** |

**At [X] active projects:** estimated [X hrs] saved per month on project administration alone.

**Additional benefits:**
- Single source of truth — no conflicting spreadsheet versions
- Complete audit trail automatically maintained for every change (BDUK / Ofcom compliance)
- Parent/child project hierarchy enables large programmes to be broken into phases without losing portfolio visibility

---

### 1.2 Premises List Management

**Manual process:** Build a premises list in Excel by exporting UPRN data from an external source, cross-referencing against OS AddressBase, manually classifying MDU/SDU, calculating cable metres in a spreadsheet formula.

| Task | Manual | GeoLynx | Saving |
|---|---|---|---|
| Build premises list for a new area (500 premises) | 3–4 hrs | 20 min (bulk Excel upload + UPRN lookup) | ~3 hrs |
| Update MDU/SDU classification | 30 min | 2 min (inline edit) | 28 min |
| Calculate cable metre totals | 15 min (spreadsheet formulas) | Automatic | 15 min |
| Export premises to Excel/CSV | 10 min (format + clean) | 1 min | 9 min |

**Notes:** *(Update with actual premise volumes and team feedback)*

---

## 2. Interactive Mapping & GIS

### 2.1 Map-based Network Design

**Manual process:** Switch between a GIS desktop tool (QGIS/ArcGIS), a spreadsheet, and a separate project tracker. Changes in one tool must be manually reflected in the others. Sharing map files requires exporting to GeoPackage/Shapefile and distributing by email.

| Task | Manual | GeoLynx | Saving |
|---|---|---|---|
| Draw project boundary | 15 min (open QGIS, load layers, draw, export) | 3 min (draw inline on project map) | 12 min |
| View premises on map | 20 min (join UPRN data to spatial layer in QGIS) | Instant (built-in) | 20 min |
| Edit a network feature attribute | 10 min (open attribute table in QGIS, find row, edit, save) | 30 sec (click feature → inline edit) | ~9.5 min |
| Share updated map with colleague | 10 min (export + email) | Instant (shared live platform) | 10 min |
| Generate A3 PDF map for stakeholder | 45 min (QGIS print composer) | 2 min (one-click export) | 43 min |

**At [X] map exports per month:** estimated [X hrs] saved.

---

### 2.2 Auto Cable Routing

**Manual process:** Manually trace cable routes along duct infrastructure in a GIS tool, referencing Openreach PIA data in a separate viewer. Calculate distances manually. Re-do routing if a blockage is discovered.

| Task | Manual | GeoLynx | Saving |
|---|---|---|---|
| Route a cable from cabinet to premises cluster (1 route) | 45–90 min | 2–5 min (auto-route with configurable parameters) | ~60 min |
| Re-route around a blockage | 30–60 min | 3 min (adjust weighting + re-run) | ~45 min |
| **Per project (average [X] routes)** | **[X hrs]** | **[X hrs]** | **[X hrs]** |

**Notes:** Auto-routing includes civils-avoidance weighting and blockage-avoidance weighting. Results can be previewed before committing. *(Validate route count and time with planning team.)*

---

## 3. Wayleave Management

### 3.1 Wayleave Tracking & Negotiation

**Manual process:** Maintain a wayleave tracker spreadsheet (one row per landowner/account). Email-based communication with BDMs. No integrated view of which premises are covered by each wayleave. Signed agreements stored in a shared drive with no linkage to the tracker.

| Task | Manual | GeoLynx | Saving |
|---|---|---|---|
| Create a new wayleave account | 10 min (add to spreadsheet, create folder in drive) | 2 min | 8 min |
| Update negotiation status | 5 min (find row, update, re-share) | 30 sec | ~4.5 min |
| Link premises to a wayleave account | 30 min (cross-reference UPRN lists) | 5 min (stocklist editor) | 25 min |
| Upload signed agreement | 5 min (drive upload + update tracker) | 2 min (upload within account record) | 3 min |
| View which projects include a wayleave's premises | 1–2 hrs (manual cross-referencing) | Instant (linked projects tab) | ~90 min |
| Add journal note / communication log | 10 min (email + update notes column) | 1 min | 9 min |

**At [X] active wayleave accounts:** estimated [X hrs] saved per month on wayleave administration.

**Compliance benefit:** Complete, timestamped audit log per account — no reconstructing history from email chains for dispute resolution or regulatory review.

---

### 3.2 Land Registry Integration

**Manual process:** Search GOV.UK Land Registry individually for each property or freeholder. Note title numbers and ownership details in a spreadsheet. Manually create wayleave account records from search results.

| Task | Manual | GeoLynx | Saving |
|---|---|---|---|
| Find freeholder for a property | 5–10 min (Land Registry portal, manual search) | 30 sec (integrated search with autocomplete) | ~8 min |
| Identify how many premises a freeholder controls | 30–60 min (multiple searches, cross-reference) | Instant (premise count per freeholder, built-in) | ~45 min |
| Create wayleave account from registry data | 15 min (copy details manually across systems) | 1 min (direct workflow link from search results) | 14 min |

**For an estate of [X] properties requiring wayleave:** estimated [X hrs] saved on initial landowner identification.

---

## 4. Strategic Analysis

### 4.1 Distance Analysis

**Manual process:** Work through a premises stocklist in Excel, cross-referencing each address against one or more target address lists row by row. Confirm proximity by manually looking up premises in Google Maps to visually assess whether locations are close enough to be relevant. At any meaningful scale this process is impractical — at 40,000 premises it is effectively impossible to complete accurately without bespoke tooling.

| Task | Manual | GeoLynx | Saving |
|---|---|---|---|
| Run proximity analysis (40,000 premises vs 1 target dataset) | Not reliably achievable — manual Excel cross-reference + Google Maps spot-checks at this volume would take weeks and still produce incomplete results | < 2 min (automated batch processing with real-time progress) | Weeks → minutes |
| Run multi-target analysis (40,000 premises vs 3 datasets simultaneously) | Not feasible without bespoke tooling | < 2 min | Full task saved |
| Export results | N/A — no reliable output exists from manual process | 2 min | — |
| Heading alignment detection (co-location analysis) | Not feasible manually | Built-in | Full task saved |
| Re-run after dataset update | Restart entire process | < 2 min | Full task saved per re-run |

**At 40,000 premises:** the manual approach — cross-referencing addresses in Excel and spot-checking locations in Google Maps — does not scale to this volume. It would produce incomplete, unreliable results over the course of days or weeks. GeoLynx completes the same analysis with spatial precision in under 2 minutes, including heading alignment detection for co-location identification. This is not a time saving — it is a capability that simply does not exist without GeoLynx.

**Notes:** GeoLynx handles heading/azimuth alignment detection to identify co-location potential — a capability that would require bespoke GIS scripting to replicate manually. *(Record how many analysis runs are performed per month and update estimates.)*

---

### 4.2 Opportunity Management

**Manual process:** Identify candidate projects by reviewing a portfolio spreadsheet. Manually plot on a map to assess adjacency. Bundle into an opportunity document. Run each cable route individually in QGIS, with no awareness of shared infrastructure. Compile results into a separate cost/routing summary spreadsheet. Repeat from scratch for every scenario considered.

#### How the GeoLynx Opportunity Builder works

1. **Create projects** in GeoLynx as normal (individual fibre deployment areas)
2. **Create an opportunity** and add the anchor project — GeoLynx immediately checks for additional projects within 1,000m and surfaces them as suggestions, so related work is never overlooked
3. **Add projects** to the opportunity (from the auto-suggested list or manually); the live map updates to show all selected project boundaries together
4. **Select a connection point** on one of the projects (e.g. an existing POP or cabinet) — this becomes the hub all routes are calculated from
5. **Run routing** — GeoLynx routes each project to the connection point iteratively, applying increasing cost weighting to duct sections that have already been routed. This means later routes naturally share already-planned infrastructure rather than duplicating it, building an optimised, shared-route plan across the entire opportunity automatically
6. **Review the output** — GeoLynx surfaces the full routing summary: total route distance, metres of shared duct, metres of unique duct per project, and the combined network map — everything needed to produce a cost estimate or BDUK submission

| Task | Manual | GeoLynx | Saving |
|---|---|---|---|
| Identify projects within 1,000m of a target | 1–2 hrs (manual map review) | ~2 min (auto-suggest on opportunity creation) | ~90 min |
| Bundle projects into an opportunity | 30 min (compile into document/spreadsheet) | ~5 min | ~25 min |
| Route all projects to a shared connection point | 2–4 hrs per project in QGIS, no shared-route awareness, manual result compilation | < 1 min (iterative weighted auto-routing across all projects simultaneously) | **2–4 hrs per project** |
| Identify shared vs unique duct (cost optimisation) | Not feasible without bespoke scripting | Built-in output summary | Full task saved |
| Re-run for a different connection point scenario | Repeat full manual routing process | < 1 min (change connection point, re-run) | 2–4 hrs per scenario |

**Key differentiator:** The iterative cost-weighting approach means GeoLynx finds the naturally shared infrastructure across a bundle of projects automatically — something that would require custom GIS scripting or manual route comparison to replicate. For an opportunity with [X] projects, this single feature saves an estimated [X hrs] per opportunity assessment.

---

## 5. Reporting & Analytics

### 5.1 Management Reporting

**Manual process:** Extract data from multiple spreadsheets and trackers. Consolidate in a master workbook. Build charts manually. Distribute by email. Repeat weekly/monthly — same effort each cycle.

| Task | Manual (per report cycle) | GeoLynx | Saving |
|---|---|---|---|
| Build wayleave pipeline report | 2–3 hrs | Instant (pre-built interactive reports) | ~2.5 hrs |
| Build planning progress report | 2–3 hrs | Instant | ~2.5 hrs |
| Build build progress report | 2–3 hrs | Instant | ~2.5 hrs |
| Cost-per-premise analysis | 3–4 hrs (data gathering + calculation) | Instant | ~3.5 hrs |
| Regional breakdown report | 2–3 hrs | Instant | ~2.5 hrs |
| **Monthly reporting burden** | **~15–20 hrs** | **< 1 hr (review + export)** | **~15–19 hrs/month** |

---

## 6. Collaboration & Audit

### 6.1 Team Coordination

**Manual process:** Status updates via email or meetings. No central record of decisions or actions. Version control managed manually (file naming conventions). Onboarding a new team member requires briefing from another person.

| Benefit | Manual | GeoLynx |
|---|---|---|
| Team status visibility | Weekly email update or meeting | Real-time, always current |
| Activity history | Email search / memory | Automatic timestamped journal per entity |
| Onboarding a new team member to a project | 2–4 hrs of briefing | Self-service: journal + audit log tells the full story |
| Regulatory documentation readiness (BDUK, Ofcom) | Compile from emails/files (days) | Instant — all changes logged automatically |

---

## 7. Summary — Estimated Monthly Time Savings

*(Fill in actuals once baseline data is available. The figures below are illustrative estimates based on the task breakdowns above.)*

| Function | Est. Hours Saved / Month |
|---|---|
| Project administration | [X] hrs |
| Premises list management | [X] hrs |
| GIS / mapping tasks | [X] hrs |
| Auto cable routing | [X] hrs |
| Wayleave management | [X] hrs |
| Land Registry lookups | [X] hrs |
| Strategic distance analysis | [X] hrs |
| Management reporting | [X] hrs |
| **Total** | **[X] hrs/month** |
| **FTE equivalent** (at 37.5 hrs/week) | **[X] FTE** |

---

## 8. Risk & Quality Benefits

Beyond raw time savings, GeoLynx reduces risk in ways that are harder to quantify but materially important:

| Risk / Quality Factor | Without GeoLynx | With GeoLynx |
|---|---|---|
| Data inconsistency | Multiple spreadsheet versions; conflicts common | Single source of truth |
| Audit trail gaps | Reconstructed from emails; incomplete | Complete, automatic, tamper-evident |
| BDUK / Ofcom compliance | Manual documentation effort; risk of gaps | Always audit-ready |
| Wayleave disputes | No definitive record of negotiation history | Full timestamped trail per account |
| Staff turnover | Institutional knowledge lost when staff leave | Full history stored against every entity |
| Routing errors | Manual routing errors possible on complex networks | Algorithm-validated routes |
| Missed SLAs *(with Task System)* | No systematic tracking | SLA due dates calculated and surfaced automatically |

---

## 9. Next Steps

- [ ] Validate time estimates against [Client Name]'s actual team activity logs
- [ ] Agree baseline metrics (active projects, accounts, premises) for ongoing measurement
- [ ] Schedule quarterly benefit review to track realised savings against this analysis
- [ ] Identify any manual workflows not yet replaced by GeoLynx — candidate areas for development

---

*Document owner: [Your Name] | Review date: [Date + 3 months]*



| Item# | Task Category                   | Task                                                                     | Manual Notes                                                                                                    | Qty. Per Month | Manual Time (Mins) | Manual Time (Hours) | GeoLynx Time | Time Saved Per Task | Time Saved | Hours Saved |
| ----- | ------------------------------- | ------------------------------------------------------------------------ | --------------------------------------------------------------------------------------------------------------- | -------------- | ------------------ | ------------------- | ------------ | ------------------- | ---------- | ----------- |
| 1     | Project Management              | Create new project record                                                | Create project files, directory on network drive etc.                                                           | 50             | 5                  | 0.1                 | 1            | 4                   | 200        | 3.3         |
| 2     | Project Management              | Update project status                                                    | Find files, open, update, save, close                                                                           | 150            | 5                  | 0.1                 | 0.5          | 5                   | 675        | 11.3        |
| 3     | Project Management              | Assign project manager / supplier                                        | Send emails                                                                                                     | 50             | 5                  | 0.1                 | 0.5          | 5                   | 225        | 3.8         |
| 4     | Project Management              | Add journal note / team update                                           | Assumes sending manual emails to keep everyone involved updated                                                 | 200            | 10                 | 0.2                 | 0.5          | 10                  | 1900       | 31.7        |
| 6     | Premise List Management         | Calculate cable metre totals                                             | Review Plans, sum total cable distanced                                                                         | 10             | 15                 | 0.3                 | 0            | 15                  | 150        | 2.5         |
| 7     | Premise List Management         | Export premises to Excel/CSV                                             | Assumes the file to export alrrady exists on a network drive                                                    | 50             | 2                  | 0.0                 | 1            | 1                   | 50         | 0.8         |
| 8     | Premise List Management         | Match Stocklists To UPRN (10000) Premises                                | Assumes going line by line manually looking up addresses on a service like SearchLand, exporting, checking etc. | 1              | 600                | 10.0                | 2            | 598                 | 598        | 10.0        |
| 10    | Project Network Planning        | View premises on map                                                     | Overlay uprn data on a map manually, visualised with QGIS or other online tool                                  | 50             | 20                 | 0.3                 | 0            | 20                  | 1000       | 16.7        |
| 16    | Strategic Analysis              | Run multi-target analysis (40,000 premises vs 3 datasets simultaneously) | Manual checking on google maps or similar. Not feasible without bespoke tooling                                 | 2              | 4500               | 75.0                | 2            | 4498                | 8996       | 149.9       |
| 17    | Strategic Analysis              | Export results                                                           | N/A — no reliable output exists from manual process                                                             | 1              | 2                  | 0.0                 | 1            | 1                   | 1          | 0.0         |
| 19    | Strategic Analysis              | Re-run after dataset update                                              | Restart entire process                                                                                          | 1              | 4500               | 75.0                | 2            | 4498                | 4498       | 75.0        |
| 20    | Opportunity Creation & Analysos | Identify projects within 1,000m of a target                              | Manual map review                                                                                               | 19             | 120                | 2.0                 | 1            | 119                 | 2261       | 37.7        |
| 21    | Opportunity Creation & Analysos | Bundle projects into an opportunity                                      | Copy pasting screenshots to powerpoint or similar                                                               | 19             | 30                 | 0.5                 | 5            | 25                  | 475        | 7.9         |
| 22    | Opportunity Creation & Analysos | Route all projects to a shared connection point                          | Manual route measuring on map service like google maps, PIA portal or similar                                   | 19             | 240                | 4.0                 | 1            | 239                 | 4541       | 75.7        |
| 24    | Opportunity Creation & Analysos | Re-run for a different connection point scenario                         | Restart entire process                                                                                          | 0              | 240                | 4.0                 | 1            | 239                 | 0          | 0.0         |