<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Ranis2023</title>
    <description>The latest articles on DEV Community by Ranis2023 (@ranis2023).</description>
    <link>https://dev.to/ranis2023</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4257988%2F004b8245-60cb-46c9-af85-b1aa8a3da680.png</url>
      <title>DEV Community: Ranis2023</title>
      <link>https://dev.to/ranis2023</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/ranis2023"/>
    <language>en</language>
    <item>
      <title>Reconciling two Excel workbooks offline with a local Windows AI assistant</title>
      <dc:creator>Ranis2023</dc:creator>
      <pubDate>Sat, 21 Nov 2026 22:18:51 +0000</pubDate>
      <link>https://dev.to/ranis2023/reconciling-two-excel-workbooks-offline-with-a-local-windows-ai-assistant-17bb</link>
      <guid>https://dev.to/ranis2023/reconciling-two-excel-workbooks-offline-with-a-local-windows-ai-assistant-17bb</guid>
      <description>&lt;p&gt;What should a local language model do when a user asks, “What changed in these two spreadsheets?” A plausible answer is easy to produce. A result that survives a row reorder and points back to both source cells takes a different implementation.&lt;/p&gt;

&lt;p&gt;In OSTUM Desktop, the chat routes that request to a local workbook reader. The user chooses the original file, the revised file and a key column on each sheet. A price such as 90 or 100 comes from the spreadsheet cells. The model doesn't have to infer a price from a text excerpt.&lt;/p&gt;

&lt;h2&gt;
  
  
  A four-product test
&lt;/h2&gt;

&lt;p&gt;The two downloadable workbooks have the same sheet, called &lt;strong&gt;Прайс&lt;/strong&gt; (price list). Column A is &lt;strong&gt;Артикул&lt;/strong&gt; (product code), column B is the price. Row 2 contains a code that happens to look like a cell reference: &lt;strong&gt;A17&lt;/strong&gt;. Its price is actually in &lt;strong&gt;B2&lt;/strong&gt;.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;A17 went from 90 to 100 RUB. Check B2 in both books.&lt;/li&gt;
&lt;li&gt;D42 was removed. Check A5 in the original.&lt;/li&gt;
&lt;li&gt;E53 was added. Check A5 in the revision.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Two other products, B24 and C31, exchanged positions. Their values stayed the same. We ran these exact files through the 5.7.0 comparison engine and obtained three differences. A row-by-row comparison would also have reported changes against the two moved products.&lt;/p&gt;

&lt;h2&gt;
  
  
  Put the reviewer before the write
&lt;/h2&gt;

&lt;p&gt;The review window shows the old value, the new value and both source addresses. Saving produces a separate report workbook. The operation also checks the revisions of the input files before writing. If someone changes a source after the preview, the comparison must be refreshed.&lt;/p&gt;

&lt;p&gt;For a weekly report, a named recipe remembers which sheets and key columns to use. The next run still asks for a fresh pair of files. This lets the user review this week's inputs without maintaining a folder of hard-coded source paths.&lt;/p&gt;

&lt;h2&gt;
  
  
  Reproduce it
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://ranis2023.github.io/ostum-desktop/en/excel/" rel="noopener noreferrer"&gt;Download the two sample XLSX files and follow the walkthrough&lt;/a&gt;. The Windows interface is in Russian, and the English guide spells out the relevant controls. Basic local chat is free and works without an account. The Excel workspace is a Pro feature with a one-time check of a subscription to the developer's Telegram channel. The app code is MIT-licensed. &lt;a href="https://github.com/Ranis2023/ostum-desktop" rel="noopener noreferrer"&gt;Source and Windows release&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;This is a maintainer article prepared with AI assistance. The sample data is synthetic. The workbook comparison above was checked with the project's own engine.&lt;/p&gt;

</description>
      <category>opensource</category>
      <category>windows</category>
      <category>excel</category>
      <category>abotwrotethis</category>
    </item>
  </channel>
</rss>
