========================================================================
 FlySense - Data Dedup and Anomaly Detection   v1.0.0
 Windows desktop tool. Runs 100% on your own computer. No cloud, no upload.
========================================================================

WHAT IT DOES
------------
1) DEDUP                 Find rows that were entered twice and get a list you
                         can safely delete.
2) ANOMALY DETECTION      Find rows that clearly differ from the rest of the
                         table (typos, wrong decimal point, impossible values).
3) SMART RECONCILIATION   Compare two tables (for example your system records
                         against a bank statement or supplier statement) and
                         split the result into 6 sheets:
                           Summary / Reconciled / Amount mismatch /
                           Split-merge / Only in Table A / Only in Table B
                         Professional edition only.

SUPPORTED FILES: .csv (UTF-8 or GBK auto-detected) and .xlsx

------------------------------------------------------------------------
GETTING STARTED (3 steps)
------------------------------------------------------------------------
Step 1  Double-click  FlySense.exe
Step 2  The first run asks for a license key. Click [Copy machine ID] and
        send that code to your supplier (it is not personal data - it is
        derived from your motherboard and CPU).
Step 3  Paste the license key you receive into the box and click
        [Activate and start].

You only do this once. The key is bound to this computer, so a key from
another PC will not work. Changing PC or reinstalling Windows means you
need a new key - contact your supplier.

A free trial is included. During the trial every feature is unlocked so you
can test batch processing before you buy.

------------------------------------------------------------------------
USING IT
------------------------------------------------------------------------
Single file
  1. Click [Choose data file] and pick your .csv / .xlsx
  2. Pick Dedup, Anomaly detection or Smart reconciliation on the left
  3. Click [Start]
  4. Click [Export results] to save an Excel file

Whole folder (batch)
  1. Switch to batch mode, click [Choose folder]
  2. Every spreadsheet inside is processed (tick "Include subfolders" to
     go deeper)
  3. A summary report is produced automatically:
     "Company data summary report.xlsx"

Hidden files, "~$" temporary files and hidden folders are skipped on
purpose.

Smart reconciliation
  1. Choose Table A (your system) and Table B (bank / supplier)
  2. Pick the key columns that identify a transaction (company name,
     invoice number, customer name ...)
  3. Pick the amount columns to check
  4. Set the tolerance (for example 0.01 = amounts may differ by a cent)
  5. Click [Start reconciliation], then [Export results]

Optional: an alias table (two columns: standard name, alias) lets the tool
match "Northwind Trading" with "Northwind Trading Co., Ltd.".

Your original files are never modified. FlySense only reads them.

------------------------------------------------------------------------
COMMAND LINE (Professional edition)
------------------------------------------------------------------------
Silent mode is meant for scheduled jobs and IT automation - no window at
all:

  FlySense.exe --input "D:\Data" --mode all --output "D:\Out"

  --input  <path>  file or folder to process (required)
  --mode   <mode>  dedup | detect | all        (default all)
  --output <path>  where results go            (default: <input>\FlySense_output)
  --anomaly <mode> auto, or 0.1-10 (percentage of rows to flag)
  --version / --help

The run log is written to run_log.txt inside the output folder, one line
per file.

Exit codes (for scripts):
  0 = everything succeeded
  1 = some files failed, or bad arguments / paths
  2 = not licensed (the free trial is over too)
  3 = insufficient permission: this PC holds a Personal license and silent
      command-line mode is a Professional feature

------------------------------------------------------------------------
DIFFERENCES BETWEEN EDITIONS
------------------------------------------------------------------------
Personal        Graphical interface, one file at a time: dedup and anomaly
                detection.
Professional    Everything in Personal, plus batch processing of a whole
                folder, the summary report, silent command-line mode, and
                Smart reconciliation.

------------------------------------------------------------------------
FREQUENTLY ASKED
------------------------------------------------------------------------
"Excel says the file is in use."
  Close the Excel file with the same name and run again.

"My CSV shows garbled text."
  Save it as UTF-8 or as .xlsx in Excel and try again. Old .xls files are
  not supported - convert with "Save as .xlsx" first.

"My antivirus warns about the exe."
  Small unsigned programs often trigger a warning. The file is not signed
  with a paid certificate, which is the only reason. You can verify it by
  submitting it to virustotal.com or running it inside Windows Sandbox.

"Where is my license stored?"
  %LOCALAPPDATA%\FlySense\license.dat (hidden folder). Delete that file to
  unregister this computer.

"Do you upload my data?"
  Never. See PRIVACY.txt. FlySense does not connect to the internet.

"Both tables are large - reconciliation is slow."
  Reconciliation compares every row of A with every row of B. Split the
  data into smaller tables (by month, by supplier) and reconcile in batches.

------------------------------------------------------------------------
FILES IN THIS PACKAGE
------------------------------------------------------------------------
  FlySense.exe                 the program
  README.txt                   this file
  PRIVACY.txt                  what data stays where
  EULA.txt                     license terms
  FlySense-file-info.txt       build date and SHA-256 fingerprint
  en-ui-screenshot.png         what the window looks like
  examples\                    sample CSV/XLSX to try the features

========================================================================