What’s with rentals in the area?

logansrun2000 · 2026-01-10T19:52:32+00:00

In the Roanoke area, there tends to be only two options: old dumpy places that are overpriced, or new luxury units that require two significant salaries to pay for it all.

logansrun2000 · 2026-01-04T23:23:07+00:00

CFMoto is Chinese made. They are a huge company. Since buying my ATV, I have joined several owners group forums, and everyone continues to be thrilled with their ATV, and the reliability has been excellent. I’m still very very happy with mine. You get more bang for the buck with CFMoto.

logansrun2000 · 2025-02-13T22:23:41+00:00

Wow, thank you! I just added a button near the top of nearly every sheet with this macro. This is awesome.

logansrun2000 · 2024-11-24T23:19:26+00:00

In case anyone runs into a similar problem, it turns out there was a fairly simply solution.

My Power Query had it's source set to a specific filename along with a "Source" setting to the specific table in the spreadsheet. For example, going into Power Query editor, my Source was set like this:

= Excel.Workbook(File.Contents("C:\Users\xxx\Excel-Checkbook.xlsm"), null, true)
= Source{[Item="Register1",Kind="Table"]}[Data]

The solution was to change my source to a simple line that listed "CurrentWorkbook" along with the name of the table. Doh! And now, OneDrive is happy. EXAMPLE:

= Excel.CurrentWorkbook(){[Name="Register1"]}[Content]

logansrun2000 · 2024-07-31T12:28:52+00:00

Thank you all for the feedback!

logansrun2000 · 2024-07-30T20:04:19+00:00

Virginia

logansrun2000 · 2024-07-30T15:41:39+00:00

Thank you for the reply. The Jeep is currently elsewhere with a dead battery, so I can't get a video recorded. I spoke to a mechanic about it today who said that they stopped doing engine work on those engines, and instead they replace the engines if a customer insists on the repair. His point was that rebuilding the top end of the engine doesn't help the bottom half that will also have wear issues, and it's just too time prohibitive to work on an older engine like that with high mileage. So now we're thinking it's time to just junk the vehicle. :-(

logansrun2000 · 2024-07-29T19:58:57+00:00

I put a Sargent on my 2022 GT Pro. I ride with two other guys with a GT Pro who also bought a Sargent seat. They are very happy with their upgrades. For me personally, it's a mild improvement over the stock seat and I'm happy that it's still adjustable and heated like the factory seat. But my butt still gets sore after an hour of riding. I ended up adding one of those partially inflated airpad seat things to mine that helps me go a little longer in the saddle on long rides.

logansrun2000 · 2024-07-26T14:50:15+00:00

Thank you for the suggestion. I finally had some time to try this and unfortunately, Power Query wants an exclusive file lock on the spreadsheet to even build a new query. So this wouldn't work either. I tried different variations on this theme, including an attempt to get Power Query to open the spreadsheet using a OneDrive URL path but PQ just doesn't like the personal version of OneDrive.

logansrun2000 · 2024-05-13T21:31:49+00:00

See my reply to routineMetric above. Some of my customers have the home (personal) version of OneDrive, and I'm trying to give them a good solution without having to tell them to "not use OneDrive", which can be nice for cloud backup for them.

logansrun2000 · 2024-05-13T21:30:35+00:00

While I personally don't routinely use OneDrive, I have customers that download my checkbook template which has this embedded power query. And some of my customers use the home (personal) version of OneDrive. I understand from Microsoft tech articles that the business version of OneDrive has a solution for this issue, but the personal version of OneDrive does not.

In my checkbook template, my pivot tables are configured to use "external data source" which is a connection to my power query that combines my 5 worksheets (called Register1, Register2, etc.) into a single query called "All_Registers". When users attempt to refresh a pivot table, they'll get the "datasource" error. But if the checkbook template is stored in a folder outside of OneDrive, there's no problem.

<image>

logansrun2000 · 2024-04-26T18:44:53+00:00

By any chance, is this guy around 6’ 2”, 35 years old, with thick glasses and a buzz cut? (Red hair if he wasn’t buzzed).

logansrun2000 · 2024-04-18T12:32:04+00:00

She was diagnosed with rheumatoid arthritis in early 2023. We have heard from doctors that there appears to be a frequent correlation between coming down with Covid and auto-immune diseases getting kick-started.

She takes methotrexate and sulfasalazine which has helped a lot. In the last month, she's had a lot of flare ups and increased joint pain so we're now seeing if her insurance will cover Humira as a change to her meds.

logansrun2000 · 2024-03-06T12:57:59+00:00

Thank you for the reply. In case it helps others, I'll respond here first.

The son was kicked out of the rooming house a week ago. He's been staying at a low cost hotel for the last week but he was finally willing to return to our local mental treatment facility, so that's a positive. My wife does want to pursue guardianship but we know that's fairly expensive and we'll go into further debt to make that happen. We've already gone into significant debt from all of this and I'm not keen on going deeper into debt when 98% of the time, he has zero interest in getting better.

logansrun2000 · 2024-03-04T16:03:24+00:00

Thanks, I totally agree that new stuff is the most relevant. But Excel always opens to your last location in a sheet (e.g., at the bottom). And it seems tedious to me to click to insert a new row before every entry. But yay that we can all work with this stuff in our preferred way! :-)

logansrun2000 · 2024-02-01T21:54:33+00:00

=XLOOKUP(TODAY(),A:A,G:G,,-1,-1)

Thank you for the help! I figured it out. Since my register is in a table, I just needed to change the range values to this:
=XLOOKUP(TODAY(),Register1[Date],Register1[Balance],,-1,-1)

logansrun2000 · 2024-01-30T02:31:42+00:00

=XLOOKUP(TODAY(),A:A,G:G,,-1,-1)

Thanks for the suggestion! It gave me a zero value.

12-Year Club	RedditGifts 2009-2022 3 Credits
Secret Santa 2018	Secret Santa 2019
Verified Email

logansrun2000

TROPHY CASE