Nexalis Excel add-in v0.1.3-beta

Read this first: your numbers may change

NEXALIS.LAST, NEXALIS.FETCH and NEXALIS.SAMPLE were returning unscaled
values. Warp10 stores raw readings, and the multiplier/adder that turns them into
real engineering units lives in the Nexalis macros. NEXALIS.SUMMARY went
through those macros and was always correct; the other three issued a plain fetch
and returned the stored number.

On the Demo endpoint that affected 640 of 1,579 series (41%), wrong by factors
between 0.001 and 1000.

So after updating, an existing workbook may show different values for LAST, FETCH
and SAMPLE. That is the fix, not a regression. If a number ever looked wrong
next to the unit NEXALIS.FIND reported for it, this is why. SUMMARY results are
unchanged.

Measured against live Demo on series ir/15163 (multiplier 0.1):

	before	after
NEXALIS.LAST	648.7	64.87
NEXALIS.FETCH	648.6	64.86
NEXALIS.SAMPLE	647.70	64.81

Series with no multiplier are identical either way.

New optional argument

All three functions gain a scaling argument, default TRUE, added as the
last positional slot so every existing formula keeps working untouched. Pass
FALSE if you deliberately want the raw stored values:

=NEXALIS.LAST(endpoint, selector, [labels], [tz], [headers], [scaling])
=NEXALIS.FETCH(endpoint, selector, start, end, [tz], [labels], [headers], [scaling])
=NEXALIS.SAMPLE(endpoint, selector, start, end, step_min, method, [tz], [headers], [scaling])

The Retrieve dialog preserves the setting when you edit an existing formula.

Installing is simpler now

The separate "Trust Nexalis publisher" step is gone. Releases are signed with the
Nexalis LLC EV code-signing certificate, which Windows accepts on its own, so
there is no certificate to install by hand and no SmartScreen warning to click
through. If you previously ran the trust step, the uninstaller still removes it.

Upgrading

Close Excel, run the installer from the zip below, reopen Excel. Check you are on
the new build with =NEXALIS.VERSION(), which should report 0.1.3-beta.

---

SHA-256 of the zip: 17df87c2299b9e84b74b9f627b6ab33f3a947cf56f9234ec929f3ebc201720b0

Nexalis Excel add-in v0.1.2-beta

Dialogs now render correctly at 125% and 150% display scaling, and the add-in
tells you which build it is.

Fixed

• Clipped labels and overlapping controls in the Search, Last value, Raw data,
  Sample data, Summaries and Connections dialogs at high display scaling. The
  dialogs were being drawn at their 100%-scale size while the text rendered up to
  1.5x larger. If you reported this against 0.1.1-beta, this is the build that
  actually fixes it.

Added

• The version is now visible: under the beta icon in the Nexalis ribbon tab (click
  it for build details), at the end of every dialog's title bar, and from
  =NEXALIS.VERSION() in a cell. Please quote it when reporting a problem.
• The installer prints the version it is installing.

Changed

• Builds are now signed with the Nexalis, LLC EV code-signing certificate instead
  of an in-house one. Windows should no longer warn about an unrecognised
  publisher, and "Trust Nexalis publisher.bat" should no longer be needed.

Upgrading: run "Install Nexalis add-in.bat" from this zip, then close Excel
completely and reopen it. Confirm the ribbon shows v0.1.2-beta.

---

SHA-256 of the zip: 5589bab9ac665038c4e1392430bcc1370eaa6a843207893821da1d9d170df057

Nexalis Excel Add-in v0.1.1 (Beta)

Beta fix release — same features as v0.1.0-beta, with correctness and robustness fixes from a full code review.

Fixes

• Connections: renaming a connection can no longer silently overwrite another one, and a case-only rename now actually applies.
• Search: changing a filter's field no longer keeps the previous field's value.
• Installer: updating while Excel is open now shows a clear "close Excel" message instead of the window closing silently; also handles folders with [ ] in the path.
• Dates: relative dates (today-1d, yesterday) are correct around daylight-saving boundaries; Sample's timestamp-column mode no longer stalls when a cell holds relative text.
• Right-click Edit: handles sheet names containing commas and hand-edited filters without failing.
• Assorted number-format and field-name edge cases.

Install / update

1. Download Nexalis-AddIn-beta.zip below and unzip — keep all the files together in one folder.
2. Run Install Nexalis add-in.bat.
3. Fully close and reopen Excel — you'll see the Nexalis tab.

Updating from an earlier beta? Close Excel completely first (check Task Manager for EXCEL.EXE), then run the installer.

Requires 64-bit (x64) Excel. Full guide: docs.nexalis.io.

Beta — for internal evaluation.

Nexalis Excel Add-in v0.1.0 (Beta)

Pull Warp10 / Nexalis time-series data straight into Excel — PI-DataLink style.

What's inside

• Search — browse and filter series (GTS); insert as a live formula or a static list
• Last value, Raw data, Sample data (interpolated at a regular interval or at your own timestamp cells), and Summaries (bucketized aggregates)
• Worksheet functions: NEXALIS.FIND / LAST / FETCH / SAMPLE / SUMMARY / PING / ENDPOINTS
• Per-user install, no admin rights required; self-signed (one-time SmartScreen prompt)

Install

1. Download Nexalis-AddIn-beta.zip below and unzip — keep all the files together in one folder.
2. Run Install Nexalis add-in.bat.
3. Fully close and reopen Excel — you'll see a Nexalis tab in the ribbon.

Requires 64-bit (x64) Excel. See the documentation for the full guide.

Beta — for internal evaluation.