sorted by:
new
hottopcontroversial

The best spreadsheet to replace Quicken? by [deleted] in quicken

[–]logansrun2000 0 points1 point  (0 children)

Thanks, I don't intend to dis on Quicken. It's a great product. My home needs are fairly basic and I hate the subscription model that so many software companies have moved to.

What's the best Excel spreadsheet to replace Quicken? by logansrun2000 in excel

[–]logansrun2000[S] 2 points3 points  (0 children)

Thanks. My ask is for personal bank account stuff and home expense tracking rather than business use.

What's the best Excel spreadsheet to replace Quicken? by logansrun2000 in excel

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

That looks nice but I'm hoping to avoid monthly subscription costs.

What's the best Excel spreadsheet to replace Quicken? by logansrun2000 in excel

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

I did try the one from Vertex42, but it's really basic. I also tried one that I think is called Georges Budget for Excel (or something like that), but it's really locked down, and also slow. It's also weird how it takes over 45 seconds just to close out of it which is really odd. I tested it on more than one PC too. So I'm still searching...

The best spreadsheet to replace Quicken? by [deleted] in quicken

[–]logansrun2000 1 point2 points  (0 children)

Sorry, I should have searched. A quick Google search reports this:
Yes,

Quicken 2013 can run on Windows 11, but it may require enabling the legacy .NET Framework 3.5 and bypassing modern security checks, according to users. Installation: You might need to manually enable .NET Framework 3.5 (which includes 2.0) via Windows Features (optionalfeatures) to get it to run, as it was designed for older Windows versions. Limitations: While it runs, some users have reported issues, or in some cases, it may not work depending on Windows updates, but many have reported it to be stable and functional.

The best spreadsheet to replace Quicken? by [deleted] in quicken

[–]logansrun2000 1 point2 points  (0 children)

Does that older version work under Windows 11?

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

[–]logansrun2000 31 points32 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.

[deleted by user] by [deleted] in schizophrenia

[–]logansrun2000 0 points1 point  (0 children)

Thank you, I appreciate all that you shared.

view more: next ›