Good for you! I would remind you however that any project or investment can be justified by tweaking the numbers, the data you choose to input, and/or just ignoring other factors that you don't want to consider.
Although I greatly admire your number crunching prowess, that has very little to do with your computing hardware and everything to do with utilizing the clever grey matter between your ears. I hate to tell you... but all you need to use Microsoft SQL Server is just about any X64 processor and anything over about 2GBs of RAM.
I remember writing programs in Lotus 123’s advanced macro programming language about 40 years ago and running them on an IBM AT compatible computer. Lotus 123 and a vintage computer that could handle most of what you describe fairly efficiently. And it was very easy to program.
“That's for an all-electric house, and charging an EV to drive it on average 1,200 miles per month (home charged miles, not counting road-side charger miles if we take it on a trip).”
EVs have their uses... taking them on a trip is not one of them. You are no doubt aware that if you want to take a trip of more than a few hundred miles and all you have is an EV... you would be better off renting an ICE vehicle about 90% of the time.
Now don't get me wrong... I have put together several electric and gas-powered bicycles and have a capable folding electric bike that we stow in our airplane, so I have taken advantage of vehicles using alternative energy on many occasions. It is just that with rapid depreciation, the limitations, and unpredictable long term battery longevity they are not a good solution for most people's needs.
As a long-term user of lithium based rechargeable batteries I would advise you never to go below 20% of EV's battery capacity and do not leave them charged above 80% unless you plan on using them in the next few days. If you do not follow these guidelines, you will be lucky to get 5 good years out of them let alone 10.
I do appreciate you sharing your insight and accomplishments.
I respectfully disagree. I was running MSSQL on a 4GB laptop and it was slow as Christmas. Especially when calculating SMA' and EMA's of ETF prices based on intraday and closing prices across thousands of ticker symbols. It's a world of difference running on a 32GB RAM (32MHz clock speed), 4-core/8 thread 2.8GHz processor with a SSD having a 500 KB/s transfer rate.
EVs have their uses... taking them on a trip is not one of them. You are no doubt aware that if you want to take a trip of more than a few hundred miles and all you have is an EV... you would be better off renting an ICE vehicle about 90% of the time.
It depends on many factors. If your wife wants to stop every 200 miles and walk around for 10-15 minutes, taking an EV takes no more time than taking a gas car. LOL At least if you travel in the areas we have. There are couple of places we have our eye on that we'll take the gas pickup (because those areas have few fast charging options).
As far as cost goes, again it depends. If we rent a cabin over 200 miles away (call it a 500-mile round trip), the first half of the trip is free from our home charge. If it's a cabin with a NEMA 14-50 outlet by the driveway (advertising to EV owners), then we charge enough to make it home. No cost for our miles.
Obviously, that changes if it's a much longer trip, no free chargers at hotels we stop at along the way, and no free charger at our destination. On a long trip like that, the only free miles we get are the ones we charged from home. Last year's road trip from Alabama to New Brunswick, Canada and back was cheaper to have the EV only because we stayed there for 2 months and had very cheap charging at our destination.
But I read that road-side charging costs in California cost even more than their gas does. So driving 1,000 miles there might cost a lot more in an EV than in a gas car. If we did road trips there we'd probably use the gas pickup instead of the EV car.