Skip to content
Fixcelo

Sample report

Explore the full analysis of a synthetic workbook: inventory, dependency map, findings, fragility index and remediation plan.

Analysis of a synthetic workbook containing no client data. The sample exceeds the fixed-price diagnostic scope.

Download PDF reportDownload sample workbookJSON

Sheet inventory

SheetVisibilityFormulasPopulated cells
Prehledvisible1325
Kalkulacevisible4455
Kalkulace_starahidden2235
Kalkulace (2)visible2025
NEPOUZIVATvisible1319
zaloha_2018very hidden1019
List1visible1011
Pokushidden67
Milanvisible1519
cenik_finalvisible3643
cenik_final_2visible2429
Vstupyvisible2164
Kurzyvisible724
Sazbyhidden018
Materialvisible6478
Mzdyvery hidden1829
Rezievisible2429
Marzevisible2129
Vyroba_Avisible3036
Vyroba_Bvisible3036
Vyroba_Cvisible3036
Sestavavisible3746
Souhrnvisible1430
Exporthidden1519
Data_importvery hidden811
pomocnehidden1113
tempvisible56
List1 (2)visible89
Kontrolavisible1228
Archiv_2017very hidden811
Poznamkyvisible312
Ceník_2019visible1822
Sheet1hidden45
zaloha_2018 (2)very hidden1013

Dependency matrix

Each row reads from the corresponding column. Numbers show reference counts; axes follow calculation order.

Dependency matrixEach row reads from the corresponding column. Numbers show reference counts; axes follow calculation order.KurzyKurzySazbySazbyVstupyVstupyData_importData_import8Kalkulace_staraKalkulace_stara117List1List110List1 (2)List1 (2)8MaterialMaterial1455MzdyMzdy612NEPOUZIVATNEPOUZIVAT112RezieRezie1812Vyroba_AVyroba_A1266PokusPokus5Vyroba_BVyroba_B1266Vyroba_CVyroba_C1266SestavaSestava11866MarzeMarze618SouhrnSouhrn2211111121KalkulaceKalkulace25112247Kalkulace (2)Kalkulace (2)20MilanMilan510cenik_finalcenik_final18cenik_final_2cenik_final_2612Ceník_2019Ceník_201918temptemp5zaloha_2018zaloha_201810Archiv_2017Archiv_20178zaloha_2018 (2)zaloha_2018 (2)10ExportExport55KontrolaKontrola113111114111PoznamkyPoznamky2PrehledPrehled141111Sheet1Sheet14pomocnepomocne101

Fragility index: 63 / 100

A higher value indicates more difficult safe changes. This is a weighted structural indicator, not an error probability.

index = min(100, Σ cap × min(1, Σ weight × min(1, value / reference)))

ComponentPoints / cap
Workbook size6.3 / 12
Sheet dependencies14.0 / 14
Hidden and similar structures9.1 / 10
Hard-coded values8.3 / 10
Volatility6.2 / 8
Errors and references8.6 / 16
External dependencies1.9 / 8
Macros4.6 / 10
Data hygiene1.5 / 8
Sheet protection2.4 / 4

Download source JSON snapshot: JSON

Findings and recommendations

CHYBA-01 · Stored error values

Count: 6 · critical

Cells contain error values that may affect dependent calculations. Trace the source and check its impact.

Examples from the source workbook
  • Prehled!D4 = #REF!
  • Kalkulace_stara!D12 = #REF!
  • Kalkulace_stara!D13 = #DIV/0!
  • NEPOUZIVAT!C5 = #VALUE!
  • NEPOUZIVAT!C6 = #N/A
  • Kontrola!E8 = #N/A

CYKL-01 · Circular references

Count: 2 · critical

A calculation returns to its own input through dependent cells. Check the intended logic and iteration settings; remove unintended cycles.

Examples from the source workbook
  • Kontrola!C22 → pomocne!B2
  • Kontrola!C20 → Kontrola!C21

CHYBA-02 · Broken formula references

Count: 1 · critical

Formulas contain invalid references. Restore the intended reference using source records and verify the results.

Examples from the source workbook
  • Kalkulace_stara!F4 (#REF!)

Findings and recommendations

KONST-01 · Hard-coded values in formulas

Count: 84 · high

The tool flagged possible business constants. Check their purpose and move changing rates to documented inputs. Some flagged values may be legitimate.

Examples from the source workbook
  • Kalkulace!F4: 21, 100
  • Kalkulace!G4: 1.21
  • Kalkulace!H4: 1000, 1.35, 1850, 1.3350000000000002, 2, 2700, 1.32, 3, 3550, 1.3050000000000002, 4, 4400, 1.29, 5, 5250, 1.2750000000000001, 6, 6100, 1.26, 7, 6950, 1.245, 8, 7800, 1.23, 9, 8650, 1.215, 10, 9500, 1.2000000000000002, 11, 10350, 1.185, 12
  • Kalkulace!F5: 21, 100
  • Kalkulace!G5: 1.21
  • Kalkulace!H5: 1.35
  • Kalkulace!F6: 21, 100
  • Kalkulace!G6: 1.21

TEXT-01 · Numbers stored as text

Count: 8 · high

Text data types may alter sums or lookups. Check the values’ purpose and standardise data types.

Examples from the source workbook
  • Vstupy!C7 = '231'
  • Vstupy!C10 = '342 '
  • Vstupy!C13 = '453-'
  • Vstupy!C15 = '527'
  • Vstupy!C21 = '749 '
  • Vstupy!C23 = '823'
  • Vstupy!C28 = '1008-'
  • Vstupy!C31 = '1 480'

NEKONZ-01 · Inconsistent formula pattern

Count: 8 · high

A formula differs from surrounding cells. Compare it with the intended logic; the exception may be deliberate.

Examples from the source workbook
  • Kalkulace!E10
  • Kalkulace!G10
  • Material!F4
  • Material!F7
  • Material!F10
  • Material!F13
  • Material!F16
  • pomocne!B2

Findings and recommendations

NAZEV-01 · Invalid named ranges

Count: 6 · high

Some names refer to invalid targets. Check their use in formulas and macros before repair or removal.

Examples from the source workbook
  • KURZ_STARY → 'zaloha_2017'!$B$2 (missing sheet: zaloha_2017)
  • CENIK_2015 → 'Kalkulace_2015'!$A$1:$F$50 (missing sheet: Kalkulace_2015)
  • SAZBA_DPH_2013 → 'Sazby_2013'!$B$1 (missing sheet: Sazby_2013)
  • PREHLED_STARY → 'Prehled (2)'!$A$1 (missing sheet: Prehled (2))
  • MARZE_STARA → #REF!$B$2 (reference contains #REF!)
  • VSTUPY_ARCHIV → 'Vstupy_2015'!$A$4:$E$33 (missing sheet: Vstupy_2015)

SKRYT-02 · Very hidden sheets

Count: 5 · high

These sheets cannot be shown through Excel’s normal Unhide menu. Check their purpose and document dependencies; visibility is controlled through sheet properties.

Examples from the source workbook
  • zaloha_2018
  • Mzdy
  • Data_import
  • Archiv_2017
  • zaloha_2018 (2)

VBA-02 · Potentially risky VBA constructs

Count: 4 · high

The code contains constructs requiring review, such as suppressed errors or fixed paths. Assess them in context before execution.

Examples from the source workbook
  • On Error Resume Next 3×
  • GoTo 1×
  • On Error GoTo 1×

Findings and recommendations

EXT-01 · External links

Count: 3 · high

Calculations read data from other files. Verify source availability, cached value freshness and update procedures.

Examples from the source workbook
  • Kurzy!B7
  • Kurzy!B8
  • Material!H4

VYHLED-01 · Lookups without error handling

Count: 2 · high

A lookup may return an error when a key is missing. Define the expected behaviour and a visible indication of missing values.

Examples from the source workbook
  • NEPOUZIVAT!D4: VLOOKUP
  • Kontrola!B10: VLOOKUP

DLOUHY-01 · Long or deeply nested formulas

Count: 1 · high

Complex formulas make review and changes difficult. Split them into documented steps and compare results before and after.

Examples from the source workbook
  • Kalkulace!H4 (723 characters, nesting 12, 12× IF)

Findings and recommendations

VBA-01 · Macros present

Count: 1 · high

The workbook contains a VBA project. Document module purposes, execution conditions and dependencies. The presence of macros alone is not an error.

Examples from the source workbook
  • ThisWorkbook.Workbook_Open
  • modKalkulace.PrepocitatCenik
  • modKalkulace.NacistKurz
  • modKalkulace.SkrytPomocneListy

VOLAT-01 · Volatile functions

Count: 38 · medium

These functions may recalculate frequently and increase calculation work. Review their necessity and dependent formulas.

Examples from the source workbook
  • Prehled!A2: NOW
  • Prehled!D5: OFFSET
  • Prehled!D6: INDIRECT
  • Prehled!B12: TODAY
  • Pokus!A4: OFFSET
  • Pokus!B4: INDIRECT
  • Pokus!A5: OFFSET
  • Pokus!A6: OFFSET

SKRYT-01 · Hidden sheets

Count: 6 · medium

Hidden sheets may participate in calculations. Check their contents and dependencies before changing or deleting them.

Examples from the source workbook
  • Kalkulace_stara
  • Pokus
  • Sazby
  • Export
  • pomocne
  • Sheet1

Findings and recommendations

SLOUC-01 · Merged cells in data

Count: 3 · medium

Merged cells may complicate sorting and processing. Check their purpose and use a regular data structure where appropriate.

Examples from the source workbook
  • Kalkulace!B15:D15 (1×3)
  • Kalkulace!B7:C7 (1×2)
  • Sestava!A10:A12 (3×1)

DUP-01 · Similarly named sheets

Count: 3 · medium

Similar names may indicate working copies. Compare contents and use; names alone do not prove duplication.

Examples from the source workbook
  • Ceník_2019, cenik_final, cenik_final_2
  • Kalkulace, Kalkulace (2), Kalkulace_stara
  • List1, List1 (2)

ZAMEK-01 · Protected sheets

Count: 3 · medium

Sheet protection may restrict changes. Check who manages it and which cells should be editable. Sheet protection does not encrypt the file.

Examples from the source workbook
  • Kalkulace (password)
  • cenik_final (password)
  • Sazby (password)

Findings and recommendations

TEXT-02 · Dates stored as text

Count: 2 · medium

Text dates may be interpreted differently across environments. Check the format and intended value before conversion.

Examples from the source workbook
  • Vstupy!G7 = '1.2.2019'
  • Vstupy!G8 = '2019/02/01'

VBA-03 · Locked VBA project

Count: 1 · medium

The project lock restricts normal access to edit code. Agree authorised access and password management before follow-up work.

Examples from the source workbook
  • password-protected project

FORMAT-01 · Extensive conditional formatting

Count: 396 · low

Numerous rules make maintenance harder and may increase workbook overhead. Consolidate overlaps after checking the intended appearance.

Examples from the source workbook
  • Prehled: B4:B13 × B5:B13
  • Prehled: B5:B13 × B6:B13
  • Prehled: B6:B13 × B7:B13
  • Prehled: B7:B13 × B8:B13
  • Prehled: B8:B13 × B9:B13

Remediation plan

Estimates for this synthetic sample come from the analyser’s plan. Cost equals estimated hours × CZK 2,500 excl. VAT. The scope of an actual assignment is agreed in advance.

When follow-up work is ordered within 60 days of report delivery, the diagnostic fee is credited against an engagement of at least CZK 25,000 excl. VAT. This larger sample workbook would be quoted individually.

1. Stored error values; Broken formula references

Estimated hours: 5–9 · Cost excl. VAT: 12500–22500 CZK

Cells contain error values that may affect dependent calculations. Trace the source and check its impact.

Formulas contain invalid references. Restore the intended reference using source records and verify the results.

2. Circular references

Estimated hours: 3–5 · Cost excl. VAT: 7500–12500 CZK

A calculation returns to its own input through dependent cells. Check the intended logic and iteration settings; remove unintended cycles.

3. Hard-coded values in formulas

Estimated hours: 8–14 · Cost excl. VAT: 20000–35000 CZK

The tool flagged possible business constants. Check their purpose and move changing rates to documented inputs. Some flagged values may be legitimate.

4. Hidden sheets; Very hidden sheets; Similarly named sheets

Estimated hours: 6–10 · Cost excl. VAT: 15000–25000 CZK

Hidden sheets may participate in calculations. Check their contents and dependencies before changing or deleting them.

These sheets cannot be shown through Excel’s normal Unhide menu. Check their purpose and document dependencies; visibility is controlled through sheet properties.

Similar names may indicate working copies. Compare contents and use; names alone do not prove duplication.

5. Numbers stored as text; Dates stored as text

Estimated hours: 2–4 · Cost excl. VAT: 5000–10000 CZK

Text data types may alter sums or lookups. Check the values’ purpose and standardise data types.

Text dates may be interpreted differently across environments. Check the format and intended value before conversion.

Remediation plan

Estimates for this synthetic sample come from the analyser’s plan. Cost equals estimated hours × CZK 2,500 excl. VAT. The scope of an actual assignment is agreed in advance.

When follow-up work is ordered within 60 days of report delivery, the diagnostic fee is credited against an engagement of at least CZK 25,000 excl. VAT. This larger sample workbook would be quoted individually.

6. Lookups without error handling; Inconsistent formula pattern

Estimated hours: 4–7 · Cost excl. VAT: 10000–17500 CZK

A lookup may return an error when a key is missing. Define the expected behaviour and a visible indication of missing values.

A formula differs from surrounding cells. Compare it with the intended logic; the exception may be deliberate.

7. Invalid named ranges; External links

Estimated hours: 5–8 · Cost excl. VAT: 12500–20000 CZK

Some names refer to invalid targets. Check their use in formulas and macros before repair or removal.

Calculations read data from other files. Verify source availability, cached value freshness and update procedures.

8. Macros present; Potentially risky VBA constructs; Locked VBA project

Estimated hours: 4–7 · Cost excl. VAT: 10000–17500 CZK

The workbook contains a VBA project. Document module purposes, execution conditions and dependencies. The presence of macros alone is not an error.

The code contains constructs requiring review, such as suppressed errors or fixed paths. Assess them in context before execution.

The project lock restricts normal access to edit code. Agree authorised access and password management before follow-up work.

9. Long or deeply nested formulas

Estimated hours: 4–7 · Cost excl. VAT: 10000–17500 CZK

Complex formulas make review and changes difficult. Split them into documented steps and compare results before and after.

10. Volatile functions; Extensive conditional formatting; Merged cells in data; Protected sheets

Estimated hours: 4–8 · Cost excl. VAT: 10000–20000 CZK

These functions may recalculate frequently and increase calculation work. Review their necessity and dependent formulas.

Numerous rules make maintenance harder and may increase workbook overhead. Consolidate overlaps after checking the intended appearance.

Merged cells may complicate sorting and processing. Check their purpose and use a regular data structure where appropriate.

Sheet protection may restrict changes. Check who manages it and which cells should be editable. Sheet protection does not encrypt the file.

Method limitations

  • The tool reads saved values without recalculation and does not confirm result accuracy.
  • VBA is read as source text where available. Macros are not run and compiled code is not assessed.
  • Power Query, data models and connections are recorded only; their internal logic is not examined.
  • Pivot caches are not compared with source data.
  • Charts, shapes, controls and embedded objects are not read.
  • Shared formulas are reconstructed using relative shifts; dynamic arrays may not be covered fully.
  • Constant detection is heuristic and may flag legitimate values.
  • Function name translations are incomplete. Source formulas retain their stored English names.
  • Cycle detection has size limits. Any truncation is recorded in the source snapshot.
  • Analysis needs to be complemented by behaviour checks in actual Excel. This sample has so far only been checked in LibreOffice.

Sheet names, formulas and technical identifiers are preserved as recorded in the source.

Surman s.r.o. · Company ID 29267421 · jaroslav@surman.cz