m/KanzlAI-mGMT
1
0
Fork 0
Code Issues 2 Pull Requests Actions Packages Projects Releases Wiki Activity

Web-based Patentprozesskostenrechner — law firm cost calculator tool #2

New Issue
Open
opened 2026-03-31 15:15:09 +00:00 by mAi · 0 comments
mAi commented 2026-03-31 15:15:09 +00:00
Collaborator
Copy Link

Context

An Excel-based patent litigation cost calculator (Patentprozesskostenrechner.xlsm) exists in the HL work repo. Full analysis has been completed — all formulas, fee tables, VBA logic, and data model are documented.

Goal: Build a modern, web-based version as a proper Kanzlei tool — cleaner UX, responsive, shareable, and extensible beyond the Excel limitations.

Source Material

  • Excel file: HL/mWorkRepo:6 - material/Patentprozesskostenrechner.xlsm (© 2021 M. Siebels)
  • Full analysis: HL/mWorkRepo:6 - material/Patentprozesskostenrechner - Analysis.md (312 lines, covers everything below)

What the Excel Does

Jurisdiction: German national courts (LG, OLG, BGH, BPatG, DPMA). No UPC coverage yet.

Proceeding types:

  1. Infringement (Verletzungsverfahren): LG → OLG → BGH (NZB + Revision)
  2. Nullity (Nichtigkeitsverfahren): BPatG → BGH
  3. Cancellation (Löschungsverfahren): DPMA → BPatG
  4. Security for costs (Prozesskostensicherheit)

Inputs:

  • Streitwert (amount in dispute): 500 – 30M EUR
  • VAT rate (19%, 16%, 0%)
  • Per instance: fee schedule version (2005/2013/2021/2025/current), number of attorneys + patent attorneys, oral hearing yes/no, expert fees, termination type
  • Number of clients (for fee multiplier)

Fee schedules: GKG (court fees) + RVG (attorney fees) with 5 historical versions. Core VBA function mGebuehrensatz() computes base 1.0 fee via step-table lookup.

Outputs: Per-instance cost breakdowns + totals for full litigation path.

Requirements for Web Version

  1. Single-page JS app — vanilla JS or minimal framework, no heavy dependencies
  2. All calculation logic from the Excel (GKG/RVG fee schedules, multipliers, per-instance subtotals)
  3. Add UPC fee schedule — highest value-add over the Excel (UPC has its own fee structure)
  4. Clean, professional design — suitable as a Kanzlei knowledge tool
  5. Responsive — desktop + tablet
  6. Input form with all parameters from the Excel
  7. Output: clear cost breakdown, per-instance totals, comparison between venues
  8. Print-friendly view for sharing with clients
  9. Bilingual — German primary, English option
  10. Fix 3 bugs found in the Excel analysis (see analysis doc for details)
  11. Deploy-ready as a static site

Known Bugs in Excel (to fix in web version)

See the analysis doc for specifics — 3 formula/logic bugs were identified.

Architecture Notes from Analysis

  • The Excel has a hidden "Engine" sheet — an incomplete refactoring toward a data-driven architecture. The web version should complete this: fee tables as JSON data, calculation logic as pure functions.
  • Fee schedule tables should be easy to update (new versions added regularly when GKG/RVG change).
  • Consider making it embeddable (iframe-friendly) for firm intranet integration.
## Context An Excel-based patent litigation cost calculator (`Patentprozesskostenrechner.xlsm`) exists in the HL work repo. Full analysis has been completed — all formulas, fee tables, VBA logic, and data model are documented. **Goal:** Build a modern, web-based version as a proper Kanzlei tool — cleaner UX, responsive, shareable, and extensible beyond the Excel limitations. ## Source Material - **Excel file:** `HL/mWorkRepo:6 - material/Patentprozesskostenrechner.xlsm` (© 2021 M. Siebels) - **Full analysis:** `HL/mWorkRepo:6 - material/Patentprozesskostenrechner - Analysis.md` (312 lines, covers everything below) ## What the Excel Does **Jurisdiction:** German national courts (LG, OLG, BGH, BPatG, DPMA). No UPC coverage yet. **Proceeding types:** 1. Infringement (Verletzungsverfahren): LG → OLG → BGH (NZB + Revision) 2. Nullity (Nichtigkeitsverfahren): BPatG → BGH 3. Cancellation (Löschungsverfahren): DPMA → BPatG 4. Security for costs (Prozesskostensicherheit) **Inputs:** - Streitwert (amount in dispute): 500 – 30M EUR - VAT rate (19%, 16%, 0%) - Per instance: fee schedule version (2005/2013/2021/2025/current), number of attorneys + patent attorneys, oral hearing yes/no, expert fees, termination type - Number of clients (for fee multiplier) **Fee schedules:** GKG (court fees) + RVG (attorney fees) with 5 historical versions. Core VBA function `mGebuehrensatz()` computes base 1.0 fee via step-table lookup. **Outputs:** Per-instance cost breakdowns + totals for full litigation path. ## Requirements for Web Version 1. **Single-page JS app** — vanilla JS or minimal framework, no heavy dependencies 2. **All calculation logic** from the Excel (GKG/RVG fee schedules, multipliers, per-instance subtotals) 3. **Add UPC fee schedule** — highest value-add over the Excel (UPC has its own fee structure) 4. **Clean, professional design** — suitable as a Kanzlei knowledge tool 5. **Responsive** — desktop + tablet 6. **Input form** with all parameters from the Excel 7. **Output:** clear cost breakdown, per-instance totals, comparison between venues 8. **Print-friendly** view for sharing with clients 9. **Bilingual** — German primary, English option 10. **Fix 3 bugs** found in the Excel analysis (see analysis doc for details) 11. **Deploy-ready** as a static site ## Known Bugs in Excel (to fix in web version) See the analysis doc for specifics — 3 formula/logic bugs were identified. ## Architecture Notes from Analysis - The Excel has a hidden "Engine" sheet — an incomplete refactoring toward a data-driven architecture. The web version should complete this: fee tables as JSON data, calculation logic as pure functions. - Fee schedule tables should be easy to update (new versions added regularly when GKG/RVG change). - Consider making it embeddable (iframe-friendly) for firm intranet integration.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
No items
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
mAi m
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: m/KanzlAI-mGMT#2
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?