Project Overview
Securing pharmaceutical drug-pricing and HEOR Excel models is essential for life-sciences consultancies whose core commercial value sits inside proprietary reimbursement benchmarks and elasticity equations. When multinational pharmaceutical and biotech companies launch a new therapy across Southeast Asia, they rely on complex Excel workbooks to model patient co-pay elasticity, hospital formulary discounts, Managed Entry Agreements (MEAs), and International Reference Pricing (IRP) cross-border spillover risks. A leading Southeast Asian life-sciences consultancy had built the region's most comprehensive Excel/VBA pricing and HEOR modelling suite, backed by proprietary reimbursement benchmarks gathered from hundreds of ASEAN drug launches.
The consultancy faced a recurring revenue challenge: after licensing the workbook for a single country launch (for example, Singapore), client teams could easily unlock the spreadsheet, copy the hidden benchmark tables for Malaysia, Thailand, and Vietnam, and reuse the VBA elasticity solver across future launches without extending their licence. Partnering with our custom Excel add-in engineering team →, the firm moved both its pricing algorithms and its ASEAN payer benchmark datasets into a compiled C++ calculation engine with country-scoped per-calculation licensing—while keeping desktop Excel as the user interface.
Preserving the Excel Launch Dashboard While Removing Exposed IP
Pharma market-access directors depend on Excel's flexibility to build board-ready launch packs, sensitivity tables, and payer negotiation scenarios. Following the architecture described in our guide on turning Excel and VBA models into a protected, licensable product →, we kept the exact Excel dashboard, scenario sliders, and waterfall charts intact while removing every proprietary formula and dataset from the workbook file.
- Zero Formulas or Benchmarks in the Sheet: All multi-step elasticity equations, VBA solver macros, and hidden ASEAN country benchmark sheets were deleted from the distributed
.xlsxworkbook. - 100% Offline Desktop Execution: All calculations run locally on the user's machine inside a compiled C++ process, satisfying strict pharmaceutical data-privacy rules that prohibit sending unreleased drug pricing to external cloud servers.
| Capability | Legacy HEOR Workbook (.xlsm) |
Protected XLL + C++ Pricing Engine |
|---|---|---|
| ASEAN Payer Benchmark Data | 6 country benchmark tables on hidden sheets; copied after first project | AES-GCM encrypted per market inside the compiled C++ executable |
| Elasticity & Rebate Solver | Exposed worksheet formulas and unlockable VBA routines | Compiled C++ machine code called via =HEOR.OPTIMAL_REBATE() |
| Market-by-Market Entitlements | All 6 ASEAN countries unlocked for every recipient | Cryptographic per-country check; unlicensed markets return #LICENCE |
| Client IT Footprint | Macro security warnings; prone to accidental formula edits | Zero-install folder/USB launcher opening a fresh verified sheet every start |
Compiled C++ HEOR Solver & Custom XLL Worksheet Functions
We translated the consultancy's non-linear pricing algorithms and VBA macros into a standalone, compiled C++ calculation engine linked to Excel through a thin native .xll add-in.
- Native Custom Worksheet Formulas: Analysts interact with the protected engine using intuitive Excel formulas such as
=HEOR.OPTIMAL_REBATE(market, indication, list_price),=HEOR.SPILLOVER_RISK(launch_sequence), and=HEOR.UPTAKE_CURVE(copay_tier). - Automatic Lifecycle Supervision: The XLL add-in automatically starts and monitors the companion C++ engine process. If the engine process is terminated externally, it restarts seamlessly; when Excel closes, the engine exits automatically.
Have a similar challenge?
Our experts can help you build custom integrations and plugins tailored to your business workflows.
Country- and Indication-Scoped Per-Calculation Licensing
To enable tiered commercial licensing across Southeast Asia, we embedded cryptographic entitlement checks directly inside the C++ calculation engine's formula evaluation pipeline—building on the same calculation-locked architecture proven in our Southeast Asian actuarial C++ engine case study →.
- Encrypted ASEAN Benchmark Vault: Payer willingness-to-pay curves and hospital formulary discount tables for Singapore, Malaysia, Thailand, Vietnam, Indonesia, and the Philippines are encrypted per market inside the compiled binary.
- Cell-Level Entitlement Enforcement: Every time Excel recalculates, the engine checks whether the user's hardware dongle or signed licence file includes the requested country code. If a client licensed only for Singapore and Malaysia changes the country dropdown to Thailand, the formula cells immediately return
#LICENCE—prompting a seamless subscription upgrade without breaking the rest of the workbook.
Automated Reference Testing & Zero-Install Deployment
In health-economics and payer negotiations, even a fraction of a percent in calculation drift is unacceptable. We paired the migration with rigorous automated verification and frictionless corporate deployment.
- Zero-Difference Parity Suite: An automated test runner compared the new C++ engine side by side against the consultancy's original Excel/VBA reference workbooks across 300+ multi-country launch scenarios, confirming zero variance across every NPV, budget-impact, and rebate output.
- Zero-Install Portable Package: Delivered as a self-contained folder with a portable launcher that opens a fresh, verified master workbook on each start—requiring no admin rights, no MSI installer, and no Windows Registry modifications on pharma client laptops.
Key Challenges
Exposed ASEAN Payer Benchmark Tables
Proprietary country-by-country payer willingness-to-pay thresholds, hospital discount tiers, and patient elasticity curves were stored on hidden Excel sheets that clients could easily extract.
Readable VBA Pricing & Rebate Solvers
Non-linear rebate-tier optimisation and cross-border reference-pricing spillover rules written in VBA could be unlocked and copied in minutes.
No Per-Country Licence Enforcement
The consultancy wanted to license the workbook by individual ASEAN country market and therapy area, which was impossible to enforce inside a standard .xlsm file.
Strict Offline Pharma Data-Privacy Rules
Pharma market-access executives refused to upload sensitive pre-launch drug pricing assumptions to a third-party cloud web app and needed the model to remain 100% offline inside desktop Excel.
Results & Outcomes
By moving their calculation brain and ASEAN benchmark tables out of VBA and into a compiled C++ engine with a thin XLL bridge, the consultancy transitioned from one-off project deliverables to a tiered, country-by-country annual licensing model across Southeast Asia.
100% Concealed Payer Benchmarks & Logic
Every ASEAN willingness-to-pay threshold, hospital formulary discount table, and non-linear rebate solver was removed from the spreadsheet and encrypted inside the compiled C++ engine.
Tiered 6-Market Country Licensing
Cell-level cryptographic entitlement checks allowed the consultancy to license Singapore, Malaysia, Thailand, Vietnam, Indonesia, and the Philippines individually, returning #LICENCE whenever an unlicensed market is queried.
Zero Calculation Variance Across 300+ Scenarios
Automated side-by-side reference tests confirmed exact numerical parity between the compiled C++ engine and the original Excel/VBA HEOR workbooks.
Zero-Install Offline Pharma Compliance
Market-access teams run the entire suite 100% offline from a local folder or USB drive with zero admin rights or registry entries, satisfying strict pharmaceutical data-security audits.
