I work my excel spreadsheet every day. I plug my numbers in every day. Its a complicated beast but it shows me whether I’m making money short term, medium term and long term.
I’m a complete slouch. I know only the tiniest fraction of what excel has available
I’ll bet the guys who really know their stuff can do some amazing things.
There was likely vote theft in Virginia. It was THE ONLY state where late results went pro-Clinton and were from urban rather than rural areas.
I knew then if Trump didn’t make vote integrity his #1 issue he would be cheated in 2020.
I have various nicknames regarding Excel. The sanitized one is Excel God, the NSFW one is Excel Porn Star
It’s funny, I would learn something new and my coworkers would look at me as if I were a wizard.
These guys are really amazing.
“I’m a complete slouch. I know only the tiniest fraction of what excel has available”
I used to test clerical applicants on Office as part of the hiring process. I would ask them what they thought their level was. No one I tested came close to their perceived level. They had no idea what the programs could actually do. I have respect for the few who know what they don’t know.
When it gets to that point I always import it into a SQL Server database (free as long as your DB is no larger than 1 GB) and build views and SQL scripts to perform the calculations. So budgeting and most investing is still tracked mainly in Excel. But the 5% of my portfolio where I do swing trading, it's all tracked in SQL Server with most of my buy and sell decisions (call it my crude AI) derived by complex views and SQL statements.
The same with my energy project (making my house more energy efficient, installing solar, when it was time to replace my wife's car I replaced it with an EV). Each month when I get a power bill I use Excel to record the kWh bought from the grid that month, the kWh sold to the grid (been doing that only 2 months), the amount of the power bill and other data fields from the power statement, odometer reading from the EV (to track miles driven that month), how much gas cost at nearby gas stations (to track how much I would have spent in gas had I gotten her an ICE), etc. But to really know what's going on intimately enough to optimize my configuration settings in my solar inverters as the seasons change, I import telemetry from my inverters (which export as Excel spreadsheet .xlsx files with rows in 5-minute candles) into a SQL Server database and go to town on the data. In the past 365 days I pulled only 18.8% of our power from the grid (81.2% was provided by solar and battery storage). I think at this point I've about maxed out how optimized it can be -- only have to wait a year to see what the results will be, which I expect to be about 85% free power average through the year. It'd probably be closer to 75% free power if I didn't do that extra analysis (which now is no work because the complex views and .sql script for the reports are written, I just run them and look at the output). Without using Excel or SQL, I probably would be only about 60% or so free power.
I, too, know enough Excel to be competent (old wheezer that I am, I’ve been at it since its first appearance).
But I wish I knew just 1% of what these whizzes know. I’d be so doggone proud.
I want to know if they have a Special Olympics for folks who have uh...
challenges....
;-)
I plugged in “Bidenomics” in to my spreadsheet and it shows a massive loss the past three years and an infinite loop in the future.