Who wins the “Error” battle: Spreadsheets or ProcureTech implementations?

Posted on May 5, 2025

0


Regarding your first question, I use a 4-Model Agent-based assessment tool that leverages my RAM 1998 to 2025 framework architecture logic.

As for the trajectory, Zaven Avagyan, look closely at the following graph, considering the following four scenarios:

🤔 Original forecast with Excel alone
🤔 With Python in Excel
🤔 Slower AI/ProcureTech adoption
🤔 80% generational AI/ProcureTech failure rate

In an updated graph, if the ProcureTech initiative failure rate remains fixed at 80% from 2025 to 2045, continued spreadsheet decline may stall or even reverse due to failed transitions.

We must ask prospective ProcureTech solution providers why they believe they can reverse the high initiative failure rate of the past few decades. I ffhtey can’r reverse the initiative failure and improve on it dramatically will it ever be EOL time for spreadsheets?

A Question of Errors

One of the top criticisms of spreadsheets is human error during data entry. My research shows that some place it as high as 88%. In fact, this propensity for entry errors is why many are championing the digitalization of the procurement process. If developed and implemented correctly there is merit in this error-free position.

But is procurement’s digitlization error free?

Let’s check out what my preliminary 4-Model Agent-based assessment tool that leverages my RAM framework architecture logic presents:

MODEL 1

Comparison Table

MetricSpreadsheet ErrorsProcureTech Implementation FailuresProcurement Impact
Error/Failure Rate88% of spreadsheets contain errors, with 10–25% of data entries (cells) erroneous in procurement due to manual input. Sources: Forbes (2014), Gartner (2023), Projective Group (2024), Conexiom (2020).30–40% of implementations fail or partially fail (e.g., budget overruns, underutilization). Sources: Whatfix (2021, 33% ERP failure rate), Ataccama (2022, 88% integration projects fail), Felix.net (2019).Spreadsheets: High error rates lead to inaccurate supplier data (e.g., pricing errors under 145% Chinese tariffs), causing overpayments and missed savings. ProcureTech: Failures delay automation, forcing reliance on error-prone spreadsheets, hindering tariff-driven supplier diversification and ESG compliance.
Estimated Cost$9.7–14 million annually per organization, with 5–10% contract overruns in procurement. High-profile cases up to $6 billion (e.g., JPMorgan Chase, 2012). Sources: Gartner (2019, 2023), IBM (2019, $3.1T US total), Procurementsoftware.site (2022).$5–20 million per failure for mid-size firms, with 5–15% of annual spend in missed savings. Major failures up to $100 million (e.g., Hershey’s ERP, 1999). Sources: Whatfix (2021), Ataccama (2022), Kissflow (2025).Spreadsheets: Costs include overpayments (e.g., duplicate vendor pricing), missed rebates, and compliance penalties (e.g., ESG violations). Example: Errors in tariff cost modeling inflate budgets. ProcureTech: Costs include wasted licenses, rework, and lost savings from delayed analytics, impacting 2025’s tariff mitigation and ESG tracking (66% prioritize by 2028).
Primary CausesManual data entry, complex formulas, lack of audit trails. Procurement-specific: Errors in vendor records, material master data, or tariff calculations. Sources: Procurementsoftware.site (2022), Conexiom (2020), Solving Finance (2023).Poor data quality, inadequate training, scope creep, resistance to change. Procurement-specific: Inaccurate vendor data, user reversion to Excel. Sources: Felix.net (2019), Kissflow (2025), Ataccama (2022).Spreadsheets: Manual errors disrupt procurement efficiency, e.g., incorrect supplier pricing under 10% universal tariffs leads to suboptimal contracts. ProcureTech: Failures prolong reliance on spreadsheets, delaying real-time analytics for tariff strategies and ESG compliance, increasing operational risks.
Key RisksFinancial losses (overpayments, missed savings), compliance violations (e.g., GDPR, ESG), operational inefficiencies (30% time wasted verifying data). Sources: Forbes (2023), CIPS, Projective Group (2024).Wasted investment, delayed benefits, continued reliance on error-prone tools, compliance risks from “dark purchasing.” Sources: Kissflow (2025), Felix.net (2019), Whatfix (2021).Spreadsheets: Errors risk non-compliance with 2025’s ESG regulations and financial losses from tariff miscalculations, undermining procurement strategy. ProcureTech: Failures delay digital transformation, exposing firms to tariff volatility (e.g., $100B Canadian tariffs) and regulatory penalties, with indirect costs from lost competitiveness.

Conclusion

The table compares spreadsheet errors (88% of spreadsheets, 10–25% of data entries, costing $9.7–14M annually) and ProcureTech implementation failures (30–40% rate, costing $5–20M per failure), highlighting their significant financial and operational impacts on procurement. Spreadsheet errors drive overpayments and compliance risks, while ProcureTech failures delay digitalization, both critical in 2025’s tariff and ESG landscape. These findings support the prior projection (87.5% to 33% by 2045), as errors accelerate ProcureTech adoption, but failures sustain Excel Python’s role.

MODEL 2

Summary Comparison Table

MetricSpreadsheetsProcureTech Implementations
Error/Failure Rate~88% have errors~70–80% fail to meet expectations
Serious Error Rate~30%~50% have major consequences
Cost Per Incident$10K–$100M+$1M–$10M+
Annual Industry Loss Estimate$7–10B+ globally$20–30B+ globally
Root CauseHuman error, lack of controlsIntegration complexity, poor change mgmt

Conclusion

While spreadsheets are risky due to human error, failed ProcureTech initiatives can be far more expensive, especially when they derail strategic procurement transformations.

However, successful ProcureTech not only reduces spreadsheet risk—it also unlocks automation, spend control, and resilience.

MODEL 3

Comparative Analysis

MetricSpreadsheetsProcureTech Implementations
Error/Failure Rate94–95% of spreadsheets70–80% of initiatives
Cost Impact$1.53B/year (U.S. economy)$750K–$9M+ per failure
Primary CausesManual data entry, poor trainingScope creep, integration issues
Sector ImpactFinance, healthcare, procurementGlobal enterprises, supply chains

Conclusion

  1. Spreadsheet Errors are nearly universal (94–95%) and costly due to cascading inaccuracies, especially in large datasets.
  2. ProcureTech Failures are less frequent (70–80%) but far more financially damaging per incident, often exceeding millions in losses.
  3. Root Causes Differ: Spreadsheet errors stem from human oversight, while ProcureTech failures often result from misaligned processes or poor stakeholder collaboration.

Organizations face significant risks in both manual spreadsheet reliance and ProcureTech adoption, underscoring the need for robust quality controls and strategic implementation frameworks

MODEL 4

Conclusion

30

Posted in: Commentary