# Workbook to editor comparison

The original Munka1 A1:P37 logic matches the current implementation snapshot. The quotation is **374,500 Ft: 191,000 Ft labor + 25,000 Ft transport + 158,500 Ft materials**. All 18 source formulas independently reproduce their cached values. All 96 input fields across the 16 original work rows match the template.

Status: source arithmetic, cell coverage and the corrected local layout are verified. Final deployed screenshots, viewport measurements and independent visual review remain pending. This document does not mark D2.1, D2.2 or D6.1 fully accepted.

## Visual comparison

| Original source reconstruction | Current local editor snapshot |
| --- | --- |
| ![Source reconstruction with original embedded header restored](source-reference-reconstructed.png) | ![Isolated local editor at 950 px table width](editor-snapshot-reference.png) |

The left image is a **reconstruction**, not a native Excel screenshot. Artifact Tool imported the unchanged workbook, but omitted its embedded image during the first render. The original JPEG bytes were restored in memory at the exact DrawingML anchor. Shared strings were re-applied for display. Font substitution, locale-specific number punctuation and stage-number punctuation can differ from Excel. Cell values, formulas, merged ranges, dimensions and complete source styles are recorded exactly in the JSON evidence. No workbook was exported or overwritten.

The right image is an isolated rendering of the recorded source snapshot at a 950 px table width, with its actual auto-growing textarea behavior and computed totals. It is not a deployed portal screenshot or a claim about the adjacent PDF. Both images omit the private workbook filename. The workbook grid contains no customer name or street address. The embedded header contains only the approved company's public branding and terms. The local editor uses synthetic customer fields.

## What is preserved and what changes

- A:H retain the eight quotation roles. I is a narrow spacer. J carries total labels. K:L, M:N and O:P are the three original settlement pairs. Stages 4/5 extend horizontally only when added.
- Source rows 1–21 and 25–37 remain in order: **34 of 37 rows**. Only the three empty spacer rows 22–24 are removed. Blank Pótmunka rows 29–32 remain inspectable.
- The full original work-start and payment terms are editable inside A1:H1. Their text matches the embedded-image transcription in terms.json and the template exactly. The source Pótmunka paragraph matches after trimming one trailing space, including the original spelling.
- Source A27:C27 is one Munkanem heading. B28/C28 hold unit and quantity. This grouping was restored after the first audit found the general header pattern reused here.
- The isolated **ö** at A5 is not a work item. It is explicitly omitted. **M5 = 180,000 Ft remains unmapped**, is outside every source settlement sum, is not a payment, and is absent from new-proposal defaults.
- The header image becomes the compact approved logo plus editable original terms. Print-oriented row heights and 8–48 pt font sizes become a compact 11 px minimum working grid. Black source borders, blue headline totals and red paid values become neutral text with green group and total backgrounds. This is an explicit screen/brand adaptation, not pixel parity.
- Source quantity/unit/transport headings may shorten to Menny., Egység and Szállítás while their roles remain unchanged. Settlement Anyagköltség becomes **Anyag és szállítás**, the accepted clarification which includes transport once. Currency symbols are consolidated in the row-1 “Összegek: Ft” label.
- The source's tall total-cell rowspans flatten to compact single rows. The totals remain in source order. Additional descriptive labels (Elszámolt munka, Végösszeg, Beérkezett összesen, Még elszámolandó) occupy originally blank cells. Még elszámolandó means quotation total minus settled work. Tartozás still means settled work minus received payments.
- Source rows with no included formula remain excluded rather than becoming zero-priced work. Disabled labor/material components display blank. Enabled explicit zero displays 0. Unknown included prices remain unknown, and their row total is unresolved. The first audit's H7 not-applicable-to-zero display issue was corrected.
- Selection controls and stable row IDs replace the source's implicit formula-presence selection. Four empty Pótmunka rows can become real rows. A compact add-row control in a blank slot is a deliberate interaction extension.
- Beneath source row 37, table-native extensions retain synthetic customer name/address, settlement dates, requested amounts, and dated payment amount/date/note history. Requested money is not received money. The paid totals at K35/M35/O35 now sum dated records rather than being untraceable direct inputs. These extensions retain earlier accepted behavior and add no invoicing workflow.

## Arithmetic oracle

| Check | Independent outcome |
| --- | --- |
| D33, F33, G33, D35 | 191,000 / 25,000 / 158,500 / 374,500 Ft |
| K34, K36, K37 in original | 0 / 0 / 0 Ft |
| Change only source-row-6 quantity 3 → 4 | 203,000 labor + 25,000 transport + 173,000 materials = 401,000 Ft. All three rates/transport input unchanged. |
| Five synthetic stages | 15,000 settled, 17,500 requested, 5,500 received, 9,500 debt, 359,500 not yet settled |
| Unverified M5 in a new proposal | No 180,000 value, no pre-existing payment, no copied allocation |

All 18 formulas were evaluated directly from source cells by an independent extractor, including source merged-cell blanks. The model checks separately exercise quantity changes, unknown/excluded/zero states and five-stage payment reconciliation. The original formulas are stored without rewriting them.

## Source rows and compact-screen geometry

These measured screen heights come from the isolated 950 px table. They are not a substitute for the final 1251×1174 / 1440×900 deployed viewport checks. At this width all inspected editable text fits its control and the minimum computed text size is 11 px. The full work-start/payment text measures 36 / 48 px high, with scroll height equal to client height.

| Source row | Source height | Local screen height | Meaning / disposition |
| --- | ---: | ---: | --- |
| 1 | 241.5 pt | 131.00 px | Logo, work-start/payment terms, settlement title |
| 2 | 62.25 pt | 19.00 px | Quotation title and three numbered settlement pairs |
| 3 | 36.75 pt | 18.00 px | Quotation/settlement headings |
| 4 | 43.5 pt | 18.00 px | Quotation/settlement headings |
| 5 | 6 pt | 13.64 px | Thin blank row. A5 marker and unverified M5 omitted explicitly |
| 6 | 48.75 pt | 25.00 px | Original work item and aligned settlement allocation cells |
| 7 | 48.75 pt | 17.00 px | Original work item and aligned settlement allocation cells |
| 8 | 48.75 pt | 17.00 px | Original work item and aligned settlement allocation cells |
| 9 | 53.25 pt | 25.00 px | Original work item and aligned settlement allocation cells |
| 10 | 53.25 pt | 17.00 px | Original work item and aligned settlement allocation cells |
| 11 | 53.25 pt | 17.00 px | Original work item and aligned settlement allocation cells |
| 12 | 53.25 pt | 17.00 px | Original work item and aligned settlement allocation cells |
| 13 | 53.25 pt | 17.00 px | Original work item and aligned settlement allocation cells |
| 14 | 53.25 pt | 17.00 px | Original work item and aligned settlement allocation cells |
| 15 | 41.25 pt | 17.00 px | Original work item and aligned settlement allocation cells |
| 16 | 53.25 pt | 17.00 px | Original work item and aligned settlement allocation cells |
| 17 | 42.75 pt | 17.00 px | Original work item and aligned settlement allocation cells |
| 18 | 42.75 pt | 17.00 px | Original work item and aligned settlement allocation cells |
| 19 | 42.75 pt | 17.00 px | Original work item and aligned settlement allocation cells |
| 20 | 42.75 pt | 17.00 px | Original work item and aligned settlement allocation cells |
| 21 | 42.75 pt | 17.00 px | Original work item and aligned settlement allocation cells |
| 22 | 32.25 pt | removed | Removed blank spacer |
| 23 | 39 pt | removed | Removed blank spacer |
| 24 | 39 pt | removed | Removed blank spacer |
| 25 | 39 pt | 16.00 px | Pótmunka section title |
| 26 | 48 pt | 27.00 px | Exact Pótmunka definition |
| 27 | 42 pt | 18.00 px | Pótmunka heading groups, including A27:C27 |
| 28 | 57 pt | 18.00 px | Pótmunka heading groups, including A27:C27 |
| 29 | 9.75 pt | 12.00 px | Four retained blank Pótmunka slots |
| 30 | 21 pt | 12.00 px | Four retained blank Pótmunka slots |
| 31 | 21 pt | 12.00 px | Four retained blank Pótmunka slots |
| 32 | 21 pt | 12.00 px | Four retained blank Pótmunka slots |
| 33 | 21 pt | 16.00 px | Labor, transport, material and six settlement component totals |
| 34 | 35.25 pt | 16.00 px | Total settled work |
| 35 | 35.25 pt | 16.00 px | Quotation total and each settlement paid total |
| 36 | 24 pt | 16.00 px | Total paid |
| 37 | 24 pt | 16.00 px | Debt (settled minus paid), plus unsettled quotation amount |

## Source columns

Source widths are Excel character units. Screen widths are measured CSS pixels at the isolated 950 px table width. Every A:P column remains represented.

| Column | Source width | Local screen width | Role |
| --- | ---: | ---: | --- |
| A | 34.1406 | 209.00 px | Work description |
| B | 5.71094 | 32.30 px | Unit |
| C | 5.28516 | 32.30 px | Quantity |
| D | 10.2852 | 55.09 px | Labor rate |
| E | 10.4258 | 64.59 px | Quantity × labor rate |
| F | 12.4258 | 55.09 px | Transport total, counted once |
| G | 12 | 55.09 px | Material rate |
| H | 11 | 64.59 px | Quantity × material rate |
| I | 2.28516 | 9.50 px | Spacer |
| J | 17.1406 | 52.25 px | Totals labels |
| K | 15.1406 | 50.19 px | Settlement 1 labor |
| L | 15.1406 | 50.19 px | Settlement 1 materials and transport |
| M | 15.1406 | 50.19 px | Settlement 2 labor |
| N | 15.1406 | 50.19 px | Settlement 2 materials and transport |
| O | 15.1406 | 50.19 px | Settlement 3 labor |
| P | 15.1406 | 50.25 px | Settlement 3 materials and transport |

## Exact cell and style evidence

- [Full 592-cell source map](workbook-full-map.json): original value type, raw value, decoded value, formula, style ID, complete font/fill/border/format/alignment records, merges, rows, columns, theme and drawing anchor.
- [Every-cell difference ledger](cell-difference-ledger.json): all 592 source positions, explicit disposition, destination and current computed editor style. The 48 cells from removed blank rows 22–24 are explicitly accounted for. All other 544 positions map to a rendered logical cell.
- [Flat source cells](all-cells.csv) and [flat difference ledger](cell-difference-ledger.csv).
- [Source formula and input oracle](formula-oracle.json) and [independent model checks](model-oracle-checks.json).
- [Local editor computed styles](editor-snapshot-style-map.json): actual spans, text, control values, dimensions, font sizes, colors, borders and row/column widths.

Source SHA256: `83cba0f76118a349ee7aaec4ddd89ea57dfe32b81ef690edc6a1370557005650`.

Audited implementation SHA256:
- `sheet.js`: `9cce96e16a8d46087c083d8393963011802effa7a319f035da7bff7ffb85f69e`
- `model.js`: `8a7aa8f8a9c1d123f47e5a23a504cabb821b6a513d49fa5b5bcf6f9e0c58d3bf`
- `template.json`: `872608ebaaffa30f5a1bab530017e3ab5a32d3d7ccb592d144a630d7aade5bb2`
- `terms.json`: `d3c5336dc91c93e3ba516f9b4dae771a30bd162cfd33d2267b7c7ef6325ac66d`
- `app.css`: `428ea18e87ee89efd1e7fc5d14d5ebd39c52ac7297f21628c602e991517471eb`
- `app.js`: `96642032210f729fb569b1189e86aba399dba1114783e6ad7c521f5fa61f40e2`
- `sidebar.css`: `a88e77382251f871bf42026ab866a3ed5c5da923e661bb64839f10519e4980b2`

## Every nonblank source cell

All 128 nonblank cells are listed below. The JSON/CSV evidence also includes every blank and style-only position.

| Cell | Source value | Source formula | Style ID | Editor destination | Disposition |
| --- | --- | --- | ---: | --- | --- |
| K1 | Elszámolás |  | 105 | Row 1 settlement heading | compact_screen |
| A2 | Árajánlat |  | 91 | A2 | compact_screen |
| K2 | 1. |  | 108 | K2 | compact_screen |
| M2 | 2. |  | 108 | M2 | compact_screen |
| O2 | 3. |  | 108 | O2 | compact_screen |
| A3 | Munkanem |  | 124 | A3 quotation header | compact_screen |
| B3 | Menyiségi  / egység |  | 120 | B3 quotation header | compact_screen |
| C3 | Mennyiség |  | 121 | C3 quotation header | compact_screen |
| D3 | Munkadíj |  | 87 | D3 quotation header | compact_screen |
| F3 | Szállítási díj |  | 56 | F3 quotation header | compact_screen |
| G3 | Anyagköltség |  | 97 | G3 quotation header | compact_screen |
| K3 | Munkadíj |  | 63 | K3 settlement component | accepted_label_clarification |
| L3 | Anyagköltség |  | 64 | L3 settlement component | accepted_label_clarification |
| M3 | Munkadíj |  | 65 | M3 settlement component | accepted_label_clarification |
| N3 | Anyagköltség |  | 66 | N3 settlement component | accepted_label_clarification |
| O3 | Munkadíj |  | 63 | O3 settlement component | accepted_label_clarification |
| P3 | Anyagköltség |  | 66 | P3 settlement component | accepted_label_clarification |
| D4 | Egységár |  | 24 | D4 quotation header | compact_screen |
| E4 | Összesen |  | 25 | E4 quotation header | compact_screen |
| F4 | Összesen |  | 26 | F4 quotation header | compact_screen |
| G4 | Egységár |  | 19 | G4 quotation header | compact_screen |
| H4 | Összesen |  | 20 | H4 quotation header | compact_screen |
| A5 | ö |  | 94 | Blank row 5 | explicit_nonbusiness_omission |
| M5 | 180000 |  | 77 | No field/payment | explicit_unmapped_omission |
| A6 | Komposzt és tőzeg behordás, terítés |  | 27 | row source-6 / description | preserved_logic |
| B6 | m3 |  | 28 | row source-6 / unit | preserved_logic |
| C6 | 3 |  | 29 | row source-6 / quantity | preserved_logic |
| D6 | 12000 |  | 30 | row source-6 / labor | preserved_logic |
| E6 | 36000 | C6*D6 | 31 | row source-6 / calculated labor | preserved_logic |
| F6 | 25000 |  | 32 | row source-6 / transport | preserved_logic |
| G6 | 14500 |  | 33 | row source-6 / material | preserved_logic |
| H6 | 43500 | C6*G6 | 34 | row source-6 / calculated material | preserved_logic |
| A7 | Rotálás |  | 27 | row source-7 / description | preserved_logic |
| B7 | db |  | 28 | row source-7 / unit | preserved_logic |
| C7 | 1 |  | 29 | row source-7 / quantity | preserved_logic |
| D7 | 35000 |  | 30 | row source-7 / labor | preserved_logic |
| E7 | 35000 | C7*D7 | 31 | row source-7 / calculated labor | preserved_logic |
| A8 | Vízforrás kialakítása |  | 27 | row source-8 / description | preserved_logic |
| B8 | db |  | 28 | row source-8 / unit | preserved_logic |
| C8 | 1 |  | 29 | row source-8 / quantity | preserved_logic |
| D8 | ? |  | 119 | row source-8 / labor | preserved_logic |
| A9 | Öntözőrendszer telepítés, 1 zóna, csepegtető |  | 5 | row source-9 / description | preserved_logic |
| B9 | db |  | 1 | row source-9 / unit | preserved_logic |
| C9 | 1 |  | 15 | row source-9 / quantity | preserved_logic |
| D9 | 120000 |  | 16 | row source-9 / labor | preserved_logic |
| E9 | 120000 | C9*D9 | 13 | row source-9 / calculated labor | preserved_logic |
| G9 | 115000 |  | 12 | row source-9 / material | preserved_logic |
| H9 | 115000 | C9*G9 | 2 | row source-9 / calculated material | preserved_logic |
| A10 | Kerti kút kialakítása |  | 5 | row source-10 / description | preserved_logic |
| B10 | db |  | 1 | row source-10 / unit | preserved_logic |
| C10 | 1 |  | 15 | row source-10 / quantity | preserved_logic |
| D10 | ? |  | 77 | row source-10 / labor | preserved_logic |
| A11 | Kézi földmunka |  | 5 | row source-11 / description | preserved_logic |
| B11 | m2 |  | 1 | row source-11 / unit | preserved_logic |
| C11 | 1 |  | 15 | row source-11 / quantity | preserved_logic |
| D11 | 650 |  | 16 | row source-11 / labor | preserved_logic |
| A12 | esővíz elvezetés, szikkasztás |  | 5 | row source-12 / description | preserved_logic |
| B12 | db |  | 1 | row source-12 / unit | preserved_logic |
| C12 | 1 |  | 15 | row source-12 / quantity | preserved_logic |
| D12 | ? |  | 77 | row source-12 / labor | preserved_logic |
| A13 | tipegő lerakás |  | 5 | row source-13 / description | preserved_logic |
| B13 | db |  | 1 | row source-13 / unit | preserved_logic |
| C13 | 1 |  | 15 | row source-13 / quantity | preserved_logic |
| D13 | ? |  | 77 | row source-13 / labor | preserved_logic |
| A14 | Kerti kiülő kialakítása |  | 5 | row source-14 / description | preserved_logic |
| B14 | m2 |  | 1 | row source-14 / unit | preserved_logic |
| C14 | 1 |  | 15 | row source-14 / quantity | preserved_logic |
| D14 | ? |  | 77 | row source-14 / labor | preserved_logic |
| A15 | Kerti világítás kialakítása |  | 5 | row source-15 / description | preserved_logic |
| B15 | db |  | 1 | row source-15 / unit | preserved_logic |
| C15 | 1 |  | 15 | row source-15 / quantity | preserved_logic |
| D15 | ? |  | 77 | row source-15 / labor | preserved_logic |
| A16 | Mulcs/apríték behordás, terítés |  | 5 | row source-16 / description | preserved_logic |
| B16 | m3 |  | 1 | row source-16 / unit | preserved_logic |
| C16 | 1 |  | 15 | row source-16 / quantity | preserved_logic |
| D16 | 12000 |  | 16 | row source-16 / labor | preserved_logic |
| A17 | növényültetés 1l konténer |  | 5 | row source-17 / description | preserved_logic |
| B17 | db |  | 1 | row source-17 / unit | preserved_logic |
| C17 | 1 |  | 15 | row source-17 / quantity | preserved_logic |
| D17 | 450 |  | 16 | row source-17 / labor | preserved_logic |
| A18 | növényültetés 2-3l konténer |  | 5 | row source-18 / description | preserved_logic |
| B18 | db |  | 1 | row source-18 / unit | preserved_logic |
| C18 | 1 |  | 15 | row source-18 / quantity | preserved_logic |
| D18 | 620 |  | 16 | row source-18 / labor | preserved_logic |
| A19 | növényültetés 5-7l konténer |  | 5 | row source-19 / description | preserved_logic |
| B19 | db |  | 1 | row source-19 / unit | preserved_logic |
| C19 | 1 |  | 15 | row source-19 / quantity | preserved_logic |
| D19 | 940 |  | 16 | row source-19 / labor | preserved_logic |
| A20 | növényültetés 10-15l konténer |  | 5 | row source-20 / description | preserved_logic |
| B20 | db |  | 1 | row source-20 / unit | preserved_logic |
| C20 | 1 |  | 15 | row source-20 / quantity | preserved_logic |
| D20 | 1350 |  | 16 | row source-20 / labor | preserved_logic |
| A21 | növényültetés 20-30l konténer |  | 5 | row source-21 / description | preserved_logic |
| B21 | db |  | 1 | row source-21 / unit | preserved_logic |
| C21 | 1 |  | 15 | row source-21 / quantity | preserved_logic |
| D21 | 2600 |  | 16 | row source-21 / labor | preserved_logic |
| A25 | Pótmunka |  | 99 | row 25 Pótmunka | compact_screen |
| A26 | Minden olyan munka, ami az eredeti árajánlatban nem szerepel, menet közben változott, új ígényként merült fel, előre nem lehetett pontosan felmérni, vagy a munkavégzés mennyisége, ideje, módja, jelentős mértékben módosult.  |  | 102 | row 26 extra definition | compact_screen |
| A27 | Munkanem |  | 87 | Pótmunka header A27:C28 | resolved_extra_header_grouping |
| D27 | Munkadíj |  | 88 | D27 quotation header | compact_screen |
| F27 | Szállítási díj |  | 57 | F27 quotation header | compact_screen |
| G27 | Anyagköltség |  | 89 | G27 quotation header | compact_screen |
| B28 | Menyiségi  / egység |  | 17 | Pótmunka header A27:C28 | resolved_extra_header_grouping |
| C28 | Mennyiség |  | 18 | Pótmunka header A27:C28 | resolved_extra_header_grouping |
| D28 | Egységár |  | 36 | D28 quotation header | compact_screen |
| E28 | Összesen |  | 37 | E28 quotation header | compact_screen |
| F28 | Összesen |  | 38 | F28 quotation header | compact_screen |
| G28 | Egységár |  | 39 | G28 quotation header | compact_screen |
| H28 | Összesen |  | 37 | H28 quotation header | compact_screen |
| D33 | 191000 | SUM(E6:E33) | 82 | labor total | preserved_formula_meaning |
| F33 | 25000 | SUM(F6:F32) | 82 | transport total | preserved_formula_meaning |
| G33 | 158500 | SUM(H6:H33) | 82 | material total | preserved_formula_meaning |
| J33 | Összesen: |  | 109 | J33 | preserved_label |
| K33 | 0 | SUM(K6:K32) | 80 | stage 1 component total | preserved_formula_meaning |
| L33 | 0 | SUM(L6:L32) | 80 | stage 1 component total | preserved_formula_meaning |
| M33 | 0 | SUM(M6:M32) | 80 | stage 2 component total | preserved_formula_meaning |
| N33 | 0 | SUM(N6:N32) | 80 | stage 2 component total | preserved_formula_meaning |
| O33 | 0 | SUM(O6:O32) | 80 | stage 3 component total | preserved_formula_meaning |
| P33 | 0 | SUM(P6:P32) | 80 | stage 3 component total | preserved_formula_meaning |
| K34 | 0 | SUM(K33:P33) | 110 | all-stage settled total | preserved_formula_meaning |
| D35 | 374500 | D33+F33+G33 | 81 | quotation grand total | preserved_formula_meaning |
| J35 | Kifizetve: |  | 109 | J35 | preserved_label |
| K35 | 0 |  | 114 | stage 1 received total | accepted_payment_history_extension |
| M35 | 0 |  | 114 | stage 2 received total | accepted_payment_history_extension |
| O35 | 0 |  | 114 | stage 3 received total | accepted_payment_history_extension |
| K36 | 0 | K35+M35+O35 | 116 | all dated payments received | preserved_formula_meaning |
| J37 | Tartozás: |  | 79 | J37 | preserved_label |
| K37 | 0 | K34-K36 | 111 | settled minus received debt | preserved_formula_meaning |

## Header readability adaptation, source e3433f9

The compact screen table keeps the same total width, source column order and business meaning. Its work-description column uses 19.2% instead of the earlier 22%, and unit/quantity each use 4.8% instead of 3.4%. This transfers 2.8 percentage points within the existing table so the Egység and Menny. headings fit at 11px without overlapping adjacent labels. No source column, input or calculation is removed. Mobile keeps a 960px horizontally scrollable sheet rather than compressing the full desktop grid into 390px. These are explicit screen geometry adaptations, not changes to the workbook's arithmetic or commercial content. Final deployed fit is recorded separately in the geometry receipt.