mcbishop

Or update price signals, to disincentive overnight charging. ...Assuming people have easy access to daytime charging.

For one thing, we could overbuild (cheap) solar. A big portion of summer solar production might be curtailed... and that might be okay.

Okay, thanks. If this is correct... it's unsettling and not cool.

What that means?

I'm pretty sure that modifying a cell's number format never affects the underlying value.

I love your comment. I'm guessing that it'd be very difficult to clone Excel's relatively-new dynamic-array-formula functionality (with comparable performance).

Thanks for the thoughtful feedback. Air cooled is lower cost I think. And, obviously, a smaller battery pack is lower cost. ...There are trade offs.

This reminds me of the excellent book: Making Things Right... "An enriching and poetic tribute to manual labour."

> ...truly terrible [battery pack] design (Nissan Leaf)...

Source please.

Yup, I'm sure a lot of people are trickle charging their EVs with 16-gauge extension cords.

Agreed. And might as well use one-syllable words that are pleasant to read / write (e.g. bob, tom, box, rack, sun).

tl;dr For urban homes, A PV system or community wind farm participation is more practical.

Its outage shows me how much I now rely on ChatGPT during novel programming. I've been smashing that refresh button like a lab rat with a pellet lever.

I'm wondering if full Desktop Excel (with VBA) will be compatible with this.

"Thermal fleet" ...I like that term. I think Jigar was referring specifically to behind-the-meter flexible-load control. Yes, pre-heating (and pre-cooling) turns the building and the hot-water tank into thermal energy storage (with no occupant impact, if done right).

Jigar Shah, quoted in the article, once said:

> Load flexibility is the giant issue nobody is talking about.

I wonder if some jurisdictions assume people prefer having the light go far and wide, for security / safety.

Thanks for your detailed write ups!

I hear you. Wrapping stuff in less-quirky functions... is a slippery slope to building a framework with a new object model (on top of the current object model). With that said, I love the hell out of VBA.

Sorting is fine in VBA. But, I admit, it'd be sweet to have lambdas.

There are quirks in JavaScript too right? When I hit a VBA quirk, I write a rectifying function around that quirky functionality. I use the custom function going forward, and never deal with that quirk again. I agree that there are a lot of quirks, and the Excel object model is byzantine. Relying on vanilla VBA / object model isn't a good idea. But, with some investment, one can be very effective in VBA. The syntax is simple / clean.

It depends on the user. I use the basic VBA components to build my own features (exactly how I want them). I'm happy that Microsoft isn't meddling.

VBA is a lovely language, that supports object-oriented programming (with composition... no inheritance). It has deep access to and control of Excel. It's mature and stable (Microsoft is no longer significantly changing it). "Real programmers" hate on it largely because of all the amateur spaghetti VBA code written by the business people (that the programmers are occasionally asked to debug).

There are now "power control systems" (software) that can dynamically turn on / off "flexible loads" to keep the total electrical current under a specified maximum. ... Without negatively impacting occupants. "Smart panel" examples: Span, Lumin, Savant.

Thanks a lot for doing this project. Your blog post got me excited.

If I had one, I'd name it "Sick 'em" (like Ralph Nader named his dog).

VBA's OOP doesn't have inheritance, so I had to use composition. Now I understand that the constraint resulted in better code.

This really resonates. I've thrown away a lot of money, speculating on what future me will need.

Could one use case be: Precisely identifying framing members (studs, rafters) behind stucco, thick lath & plaster, and roof shingles? That would be super valuable for construction work.

People in hard times don't get addicted to psychedelics in the way they might get addicted to other drugs (e.g. crack, heroin).

Also, I'm skeptical that decriminalization has caused more pain and suffering than the mass imprisonments.