v1.2.0
Windows (portable): download solenoid-1.2.0-windows-x64.exe below and run it. Unsigned, so SmartScreen warns — More info → Run anyway.
Units
- Real units on values: per-element lists, per-column frames (
Name (unit)headers lock), one-per-matrix, per-cell cubes #UNIT!on mismatch across Arithmetic / Math / Expression / Aggregate / SUMIFS / Get Column / REDUCE·BYROW·BYCOL- FC authors the unit, Convert re-bases;
10 m ÷ 2 m→ 5:1 ratio,m × m→ m²,SUM(5 km, 3)→ 8 km - Trig reads the incoming angle unit (deg / rad / Auto); custom units are opaque dimensions;
$5 ≠ 5€
What-if
- Monte Carlo run mode: ± spread in, mean ± sd + histogram out, seeded
- By-Row run mode; Goal Seek bounds / tolerance / max-iters; Simulation "Stop when" + convergence readout
- Series sparkline on card and in drill-in
- Tornado keeps and marks divergent inputs; fuzzer + Problems panel itemize per-cell errors; "+ Clamp" pre-seeded
Charts & visuals
- Waterfall, Candlestick, Boxplot, Calendar heatmap, Waffle, Contour, Vector Field, 7-Segment
- Surface: orbitable 3-D mesh; Grid Interpolate: bilinear + thin-plate spline with forecast
- INTERPOLATE lookup node; all figures embed live in Reports
Controls
- Point Plotter, Curve (monotone spline), Grid Painter, SVG Picker
- Drag-to-scrub every number field (Shift coarse / Alt fine)
Tables
- Fill Down/Up, Replace Values, Merge Columns, Promote/Demote Headers, Drop Blank Rows
- Head first/last/skip/range; Add Index two-way → coordinate-bordered grid
- Stable sorts (chain for multi-key); Filter is-blank/not-blank; EXPAND null pad
- Table Input keeps blank rows + unparseable text verbatim; MUNIT blank toggle; WORKDAY/NETWORKDAYS holidays
Documents
- Obsidian import (vault note → live typed source) and export (Notes/Reports → markdown + rasterized figures)
documentsocket; Reference data-model chapter; widget nodes (weather, geocode, FX, holidays, TZ, QR)
Formulas & chrome
- Autocomplete arg hints + parameter bar;
IF(x=0,,x)omitted args parse as blank; SCAN/REDUCE bind LAMBDA by name - Add menu no-scrollbar panes + exact-name ranking; Frame socket glyph; Socket Reference hover pills
- Forced scientific past 12 digits / below 1e-4; per-column popup format+unit controls; Color Blend node
Known issues
- Composite drill-in: no grouping / Cleanup / Autofit / Navigator / lasso yet; top toolbar drives the main canvas
- Hairline header/body seam at some zooms (cosmetic); no cable collision avoidance
- Browser Data Feed is CORS-limited (desktop fetches natively); Android status bar won't tint to accent
Full Changelog: v1.1.5...v1.2.0