Two contracts.
One difference.
A test of detail over two loan contracts. The client’s schedule is on the left, what each contract actually says goes in the middle, and the right-hand block is an Excel formula comparing the two. Pick a cell, drag a rectangle over the contract, and the value lands in it.
The extraction runs in your browser here, the same way it runs inside Excel on the Local tier. One of the two does not agree.
Six steps, about a minute. You can take over at any point.
Snip
Documents
Workbook
Engagement 2451 › Loans › Contracts
No documents yet. Drag the contracts into the add-in, or use Import documents.
What just happened
What the workbook stores.
Every word on every contract is indexed with its coordinates, and your rectangle picks up the words inside it. Swiss formats such as 1’850’000.00 are read as amounts. The check columns are ordinary Excel formulas over the two blocks beside them, so a difference is found rather than asserted. The workbook keeps the document, a cell address, a page number and four coordinates — never a second copy of the contract.