mr. mayor bubba jorts the third
@jortscity
in Jorts City, there's only one rule. PIVOT TO WIKI -> publish.obsidian.md/pivot-point DITCH EXCEL -> @solenoid-ngc.bsky.social 🇺🇸 in milano 🇮🇹 , returning...ASAP?. engineer & PM in energy supply chain manufacturing.
he's Claude, *he's* Claude, *you're* Claude...I'M CLAUDE!! are there any other Claudes I should know about?!
in Solenoid, you can't add $5 + €3 whereas Excel treats them as identical.
between 2 and 3 first image . 4 daily driver in 2nd image with #5 for ice cream
here is an example of what a DMX might look like for deciding between laptops, heavily weighting performance and price and not caring about the screen:
One last Solenoid update before I clock out for the night: the Sparkline node is now more distinguishable from the typical chart node as it can be Minified into this lil guy!! isn't he cute?
Solenoid imports both Recharts and Mermaid.js for its chart libs (so actually there's 2 different ways of rendering Sankey diagrams!) Both support multi-layer, you just use the same IDs in To and From. I'm currently working on implementing freely scalable Display nodes so you can resize em
I've added perfectly normal Sankey and Treemap chart nodes to Solenoid. There is nothing unusual about these nodes.
New Solenoid feature I think will be super duper valuable. The Report Node is a markdown file that turns `=code` into a wireable socket, and ![[name]] embeds any Note from the graph. You can wire all Charts and other values directly into the Report!
New features in Solenoid: The CUBE data type is a recursive object which can itself hold Cubes, but also Frames (typed-column tables with headers), number matrices, lists, and scalar values (it can hold anything). You can drill down to every level by clicking the chip.
I got whiplash reading this post then realizing it came from Chris Murphy lol
Feeling really good about Solenoid. I think I am legit making something I would use over Excel in many cases. fun new feature is actually an Obsidian crossover: Note nodes are Markdown and YAML frontmatter is type-able and functions as usable inputs for the graph! direct file import planned.
more Solenoid stuff. still ironing out auto-expand and arrange functions...really frustrating. anyways, things that do work: 1) palette switcher. Screenshotted is a bundled Muted palette. 2) Cable inspector (lower left)- shows connections. You can quickly nav between input and output nodes.
there's also a large (and slow) Personal Finance example graph for you to try, which pulls in transaction history CSVs, pulls out columns, does pivot tables, has budget alerts, etc etc. it's a beast but it collapses down to this:
i added an image input node to Solenoid as well as an Alert notification system tied to the Alert node.
color picker node ✅ matplotlib syntax parameters chart builder node ✅
other than the fact that none of this is true, it's a nice thought, I suppose
of course, Solenoid wouldn't be an Excel replacement without some nice charts and graphs...
Fable was also able to generalize the solution to work how I wanted it for 90° mode and Spline mode (and other angle increments were I to allow 15°/30°)