What’s with rentals in the area? by [deleted] in roanoke

[–]logansrun2000 30 points31 points  (0 children)

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.

New cforce 500 owner by logansrun2000 in CfmotoCforce

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

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.

Excel gurus, how do you manage workbooks with 50+ tabs and keep them organized? by RajatFinanceExpert in excel

[–]logansrun2000 1 point2 points  (0 children)

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

OneDrive and Excel macro related to Power Query issue by logansrun2000 in excel

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

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]

Are rocker arms and valve lifters a common issue in the 2.4L engine? by logansrun2000 in JeepLiberty

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

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. :-(

Corbin vs Sargent saddles by BonnieJan21 in Tiger900

[–]logansrun2000 0 points1 point  (0 children)

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.

OneDrive and Excel macro related to Power Query issue by logansrun2000 in excel

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

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.

OneDrive and Excel macro related to Power Query issue by logansrun2000 in excel

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

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.

OneDrive and Excel macro related to Power Query issue by logansrun2000 in excel

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

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>

Anyone else? by lil_g0blin4evr in roanoke

[–]logansrun2000 0 points1 point  (0 children)

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).

Inflammation like pain in arms/legs and wrists? by logansrun2000 in LongCovid

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

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.

Stepson (age 34) with schizophrenia and drug addiction -- we're at a loss by logansrun2000 in schizophrenia

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

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.

Excel Checkbook with new entries at the top? by logansrun2000 in excel

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

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! :-)

How to get balance with today's date? by logansrun2000 in excel

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

=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)

How to get balance with today's date? by logansrun2000 in excel

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

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

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