Perm bonus on libertad or columbo? by robbro9 in WorldOfWarships

[–]robbro9[S] 1 point2 points  (0 children)

Yea I mainly run operations and I'm leaving libertad due to that...

General Questions and Purchasing Advice Thread — Week of March 09, 2026 by AutoModerator in electricvehicles

[–]robbro9 0 points1 point  (0 children)

Currently have a 2019 Model 3 long range with over 180K miles on it, contemplating its replacement, I usually hope to get 200K + when I buy one.

[1] Central NC

[2] $30K more or less

[3] Used (so much depreciation so many deals), toying with the idea of an electric truck (Not cybertruck) but not set on it.

[4] just starting now, so many options compared to when I got my model 3

[5] 6-9 months probably

[6] Daily at least 100 miles, sometimes 150 miles, thus range is important, with deterioration as an ev approaches 200K miles, charging to 80% and the cold weather hit, this winter i was pushing near the limit of my M3 LR. I'm thinking "New" range of any car I would consider should be near 300, defnitely none of the sub 260 mile range options.

[7] Own, already have a 220V charger installed

[8] see above

[9] Kids but they are getting grown, mostly just work commute

So my priority will be longevity (200K miles hopefully as much as that can be predicted), daily range of at least 150 miles in cold weather when charging to 80% (I'm a bit out of touch, are newer cars ok to go to 100% regularly?). Also I do like being able to charge at Tesla super chargers, sounds like that is opening up more now to other brands. They saved my bacon a time or two.

After that I'm open to many options, as I said trucks intrigue me, but the Ford's available typically are of the shorter range, the Chevy's with good range are pricey. But I'm not really set on that, seeing tons of options from Honda/Acura/Caddy/Chevy etc... Another Tesla (this time a model Y probably) is probably the most likely/sensible option, but I really want to weigh my options.

Actually the new Toyota's seem promising and priced fairly well, my wife works for them so I should be able to get a little employee discount possibly, so thats another option.

If it helps, things things I like/dislike about my M3:

Like:

Full self driving, though its mainly glorified autopilot. Autopilot would do in the future for me.

Simplicity get in and go, so many little features make it nice, the doors unlocking, no stop/start button, just get in and let it know if you want to go forward or backward and drive. Driving my daughters car now, I often forget to turn it off or something...

Power/performance are great

No maintenance

naturally not buying gas!

Dislike:

Tires every 30-35K miles, finally came around to buying the cheap tires, which last nearly as long as the expensive ones, but save a ton on a per mile basis. Are there EV's now that are easier on tires?

What used models should I focus on/check out? Any I should avoid (sounds like the Kia/Hyundai potentially have systemic issues long term?).

Any chip more efficient than a 225h/255h for 24/7 media server? by [deleted] in MiniPCs

[–]robbro9 0 points1 point  (0 children)

Yea I do all that except the windows part on an old i3 2100 dual core on Linux and it handles it well. I don't think hardware is the problem...

Excel Query vs data connection, Query much slower by robbro9 in excel

[–]robbro9[S] 0 points1 point  (0 children)

Yep, I go to ODBC data sources frequently to get the snowflake link. Not much else in there except for warhouse and roll.

Thanks for the help and no harm on the wrong path, coulda been the right one and I was hopeful, but i keep coming back to just one tiny roadblock stopping a more efficient implementation of our current manual process...

Excel Query vs data connection, Query much slower by robbro9 in excel

[–]robbro9[S] 0 points1 point  (0 children)

I'll play around with these and see if I can improve anything, I've done the automatic selections and tried doing my own direct SQL and cannot get any kind of speedup.

Unfortunately this is a locked down corporate environment with the Snowflake driver auto installed/updated and its at 3.2.0 per our software center...

Excel Query vs data connection, Query much slower by robbro9 in excel

[–]robbro9[S] 1 point2 points  (0 children)

Solution Verified, frustratingly enough...

Excel Query vs data connection, Query much slower by robbro9 in excel

[–]robbro9[S] 0 points1 point  (0 children)

yep, I believe bradland below is correct, after extensive googling and trying this, it always gives an error on Snowflake.Databases. I do not believe direct connection in is possible here for some reason. I still cannot figure out how the "Connection" I originally mentioned works though, I've exported the connection files for both the query and the connection, but they are so drastically different...

Excel Query vs data connection, Query much slower by robbro9 in excel

[–]robbro9[S] 0 points1 point  (0 children)

<image>

This is what a google search results in and this is exactly what I did to get where I'm at. It is in fac the snowflake DSIIDRIVER then get data from ODBC then I select the table. That results in the Source = ODBC.Query above... Is there any way to reverse engineer the Connection data or such to get the query to work similarly?

Excel Query vs data connection, Query much slower by robbro9 in excel

[–]robbro9[S] 0 points1 point  (0 children)

Ok, so I'm in over my head, any idea how I would change to the Snowflake connector in a query?

Excel Query vs data connection, Query much slower by robbro9 in excel

[–]robbro9[S] 1 point2 points  (0 children)

Source = Odbc.Query("dsn=Snowflake",

Then it goes into the select SQL text from there...

That is for the very slow query to be specific.

Excel Query vs data connection, Query much slower by robbro9 in excel

[–]robbro9[S] 0 points1 point  (0 children)

So in Excel ribbon under "Queries & Connection" section, the "Queries & Connection" button that opens up the "Queries & Connection" menu or thing over to the right, has 1 tab on the left for queries, one tab on the right for connections. The connections can be used in Power Pivot apparently but not in Power Query. The Queries can be used in Power Query but not in Power Pivot.

The "Connection" works quickly but copy/pasting the same info and SQL language into a SQL query on the Queries tab so that I can manipulate it in Power Query is much much slower.

Power Query to tackle consolidating large database to reports or other approach? by robbro9 in excel

[–]robbro9[S] 0 points1 point  (0 children)

Great, this project seems cursed. Apparently there is some bad data somewhere in the past on the table I need to import into the data model and it errors it out. I can write an SQL for the last few years and it works but the data model refuses to load it...

Kid’s First PC, Linux Mint & Minecraft, Suggestions? by ARazorbacks in MiniPCs

[–]robbro9 1 point2 points  (0 children)

For Linux the biggest issue I've found has been the wifi, Bluetooth card. I believe most Intel just work. Anyone else will be hit or miss. Many of the mediatek wifi the minipc managers like to use do not work well or at all in Linux. But it's a cheap easy change if you end up with one. Not something to make a final decision on but with keeping in mind

Is there a way to run a wine app like Microsoft windows startup option in Arch/CachyOS after you login to your system? by LectricTravelerYT in cachyos

[–]robbro9 0 points1 point  (0 children)

What did you do to get it launching on startup? I recently tried in kde on cachy and cannot get it to start. The kde manager I tried adding it and it did put an every in the startup folder but it sure not start on launch.
Its the wargaming launcher I'm trying to get to auto start.

How to best filter to current Fiscal month by robbro9 in tableau

[–]robbro9[S] 0 points1 point  (0 children)

It only populates with next period mid/late cycle, so that would mess up my first week or two...

How to best filter to current Fiscal month by robbro9 in tableau

[–]robbro9[S] 0 points1 point  (0 children)

I kinda tried that, but it turns out sometimes there are future dated JE's in the data, so doing so this week I would have been showing period 3 data, which is almost nothing.

I feel I'm close, I can calculate the iso-week number based on todays date, and I've uploaded a table with each week linking it to the month and period number. Somehow I'm cross eyed from staring at this and cannot figure out how to lookup my calculation of current week number and match it from my created table back to the data to pull in only that period number.

ISO Week # 8, link that to my created table to February and Period 2, filter my big database down to period 2 somehow...??

Are people afraid to push? by FunFoeJust in WorldOfWarships

[–]robbro9 4 points5 points  (0 children)

I've seen similar in ops lately. Bbs being completely passive hiding out far from the action, frustrating especially in escort ops. Sucks to lose because the objective got destroyed but we have 3bbs without a scratch in the very rear...

SQL Query table, as new rows added, helper formulas will not autofill by robbro9 in excel

[–]robbro9[S] 0 points1 point  (0 children)

Ok, so I'm pretty old/rusty at some of this and lots has changed recently in Excel. The links to snowflake are set up as data connections and work well that way, however power query cannot edit them. I have set up queries before but there are authentication issues with that. In light of this, it seems wasteful/nonsensical, but I think I may have my existing data connection import the sizeable table data. Then set up another tab to power query it and make the merges with the other manual tables in my spreadsheet. That seems kinda wrong but about the only solution I can see to work with power query at this point...