Matching / 03

CKAMUS

Create Keywords And Match (User Selection)

Match two independent lists

Connect differently worded items and flag ambiguous matches.

Consulting service · scoped deliverable

CKAMUS: Match two independent lists
MEWO / CKAMUSAPPLICATION BLUEPRINT
Reference volume200 items
Manual → tool-assisted30 h → 7 min
Time released29.88 h
Price for the stated volume16,654.07 RUB

MEWO model for the stated volume. This estimates an individual operation; actual delivery time including preparation and review depends on the source data.

01 / THE PROBLEM

The same item can be described differently in an estimate, contract and register. Manual reconciliation takes time.

INPUT / WHAT TO PROVIDE

Two Excel lists with text descriptions, selected ranges and a similarity threshold.

→
OUTPUT / WHAT YOU RECEIVE

A mapping table with row references, similarity scores and statuses. Version 2 prevents reusing a lookup item.

02 / THE WORKFLOW

How your task becomes
a finished result.

  1. 01

    Normalize the text and extract keywords

  2. 02

    Compare records using Jaccard similarity

  3. 03

    Select the best matches and assign statuses

  4. 04

    Review low scores and ambiguous items

↳ Conditions of use

Text similarity does not establish technical equivalence. A low threshold produces more false matches; word order is not considered.

03 / DEMONSTRATIONS

See it in action.

Videos load only after a click. If embedded playback is unavailable, open the original on its platform.

↗
↗
↗
↗
↗
↗
↗
↗
↗
↗
↗
↗
↗
↗
↗
↗
04 / ESTIMATE

Estimate your workload.

YOUR SCENARIO

Let’s put numbers to it.

Preparation and review, h

Client hours reduce the service cost. Provider hours increase it. Both count toward the workflow time.

Linear estimate using the MEWO model. Reference volume: 200 items. Actual time and cost depend on the source materials.

29.9 h

potentially available for other tasks

Manual30 h
Automated + review7 min
Effort reduction
99.6%
Value of released capacity (manual baseline)
25,568.1 RUB
Modeled service price
16,654.07 RUB
Total service cost
42,222.17 RUB

The manual baseline is all manual hours multiplied by the entered rate. Total = manual baseline + modeled price + (provider hours − client hours) × rate.

Calculation method and assumptions

Manual and automated effort scale with volume. Estimated time saved is manual effort minus automation, preparation and review. The manual baseline is manual hours multiplied by the entered hourly rate. The modeled price equals 852.27 × (0.65 × manual hours + 0.35 × automated hours). The total adds the manual baseline, modeled price and review adjustment: (provider hours − client hours) × the entered hourly rate. Amounts are rounded for display.

The model uses a reference rate of RUB 852.27/hour. The entered hourly rate applies to the manual baseline and review hours.

NEXT STEP

Does this fit your task?

First, we agree the inputs, review criteria and deliverable. The software remains the service provider’s working tool.

MEWO / CONTACT

Start with your task.

Describe the repetitive work. We will agree the inputs, outcome and price.

No files, passwords or confidential data. Scope and terms are agreed before payment.

Email directly mr.vozgoment@ya.ru