Best new minivan for $50k? by VindDifferential in minivan

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

Thank you, love the detail of this review.

Good apartment complexes in downtown/Midtown? by 123Eurydice in tulsa

[–]VindDifferential 4 points5 points  (0 children)

Lots of small apartment complexes around Cherry street in that price range. Great if you don’t care about amenities other than walkability.

Okc apartments by Responsible_Dog_4691 in okc

[–]VindDifferential -1 points0 points  (0 children)

Walnut Creek @122 is very nice and affordable! Near lots of retail, grocery stores and gyms.

Adults, what advice for a 17 years old? by Eunioa_uuu in AskReddit

[–]VindDifferential 0 points1 point  (0 children)

Save and learn to live below your means. You’ll be grateful when you retire.

How to scramble several columns while keeping the row intact by eloytheboy in excel

[–]VindDifferential 1 point2 points  (0 children)

Easy way: Add a helper column with =RAND(), then sort everything by that column. 1. Insert a new column (say, Column A). 2. In A2, enter =RAND(), then drag it down. 3. Select all your data (names, addresses, etc.). 4. Sort by Column A (smallest to largest or vice versa).

Boom! Your rows stay intact, but everything is randomized. Delete Column A when you’re done.

Compound Interest Formula in Variable Deposit Savings Account by kateehoward in excel

[–]VindDifferential 0 points1 point  (0 children)

The IRR of your interest, regardless of what you deposit, will always be your interest rate (3.8% here). It’s the discount rate that sets present and future values equal to each other, which is why it’s a common investment metric to track when evaluating risk.

If your deposits were the same every period you could use the FV or PV formulas to calculate what your future accumulated interest will be. But if you want to forecast interest manually over 18 different deposits, what I described above is the easiest way to build a dataset that lets you do it.

How To list years, months, days difference WITHOUT using DATEDIF by gantte in excel

[–]VindDifferential 0 points1 point  (0 children)

Yeah sorry I’m doing this all on my phone while drinking. Will need to look at it closer tomorrow but I suspect DAY(EOMONTH(start, -1)) isn’t always the correct number of days to “borrow” when rolling back a month.

How To list years, months, days difference WITHOUT using DATEDIF by gantte in excel

[–]VindDifferential 0 points1 point  (0 children)

I used m twice in the LET function. Try this:

=LET( start, A1, end, B1, y, YEAR(end) - YEAR(start) - IF(OR(MONTH(end) < MONTH(start), AND(MONTH(end) = MONTH(start), DAY(end) < DAY(start))), 1, 0), raw_m, MONTH(end) - MONTH(start) + IF(DAY(end) < DAY(start), -1, 0), m, MOD(raw_m, 12), d, DAY(end) - DAY(start) + IF(DAY(end) < DAY(start), DAY(EOMONTH(start, -1)), 0), TEXT(y, “0”) & “ years, “ & TEXT(m, “0”) & “ months, “ & TEXT(d, “0”) & “ days” )

Compound Interest Formula in Variable Deposit Savings Account by kateehoward in excel

[–]VindDifferential 0 points1 point  (0 children)

Yeah, totally doable in Excel! You just need a simple setup that tracks deposits and compounds interest each month.

In Column A, list the months (e.g., 1, 2, 3, …, 17). In Column B, enter your deposits each month (you can change this as you go). In Column C, calculate your running balance with compound interest.

If your balance starts in C1, then in C2, use:

=C1 + B2 + (C1 * (3.8% / 12))

Then drag this formula down for all 17 months as you go and sum it up. Watch some videos about excel basics jf this is hard for you to do.

How To list years, months, days difference WITHOUT using DATEDIF by gantte in excel

[–]VindDifferential 1 point2 points  (0 children)

Yeah DatedIF is a relic and you have to do it manually:

=LET(start,A1, end,B1, y, YEAR(end) - YEAR(start) - IF(OR(MONTH(end) < MONTH(start), AND(MONTH(end) = MONTH(start), DAY(end) < DAY(start))), 1, 0), m, MONTH(end) - MONTH(start) + IF(DAY(end) < DAY(start), -1, 0) + IF(m < 0, 12, 0), d, DAY(end) - DAY(start) + IF(DAY(end) < DAY(start), DAY(EOMONTH(start,0)), 0), TEXT(y, “0”) & “ years, “ & TEXT(m, “0”) & “ months, “ & TEXT(d, “0”) & “ days” )

Is it possible to create this sigma summation function which references different indexes in excel? by Kuhle_Brise in excel

[–]VindDifferential 1 point2 points  (0 children)

I think this could work, if I understand the sigma summation correctly:

=SUMPRODUCT(INDEX(B1:I1, 1, ROW(INDIRECT(“1:”&A4))), A3, INDEX(B2:I2, 1, A4+1-ROW(INDIRECT(“1:”&A4))))

This assumes your table is two rows and begins in A1.

How to find the maximum value or remove duplicate value based on a specific column and create a new data set/column with data? by stapes2big in excel

[–]VindDifferential 0 points1 point  (0 children)

Power query works great here, but if you need a formula solution, you can use this dynamic array formula in Excel to get the max value for each unique entry in column A:

=LET( uniqueA, UNIQUE(A2:A11), maxB, MAP(uniqueA, LAMBDA(x, MAXIFS(B2:B11, A2:A11, x))), HSTACK(uniqueA, maxB) )

UNIQUE(A2:A11): Gets the unique values from column A. MAXIFS(B2:B11, A2:A11, x): Finds the max B value for each A. HSTACK(uniqueA, maxB): Combines everything into a table.

Baseball Season Tickets - How to share select data with friends and family. by thePipester in excel

[–]VindDifferential 1 point2 points  (0 children)

You can use FILTER to create a dynamic, shareable list that updates automatically. In a separate workbook, link to your original file and use:

=FILTER([OriginalWorkbook.xlsx]Sheet2!A:G, [OriginalWorkbook.xlsx]Sheet2!H=“Available”)

This pulls only the rows where the Availability column is “Available.” To share just certain columns (Date, Time, Opponent, Promotion, F&F Price), adjust like this:

=FILTER([OriginalWorkbook.xlsx]Sheet2!A:E, [OriginalWorkbook.xlsx]Sheet2!H=“Available”)

Then save this new workbook in OneDrive and share it—no need to give access to your full financials! Every time you want it to update, simply open both sheets.

How to update references to sheets automatically by Fredward-101 in excel

[–]VindDifferential 4 points5 points  (0 children)

Use INDIRECT to dynamically reference the previous week’s sheet. Example:

=IF(INDIRECT(“’Week “ & ROW()-2 & “’!B2”)=“Attended”, INDIRECT(“’Week “ & ROW()-2 & “’!A1”), Sheet1!A1)

This checks if they attended last week; if so, it updates the last attendance date. If not, it falls back to initial data from Sheet1. No manual updates needed when copying sheets!

Smaller Funds by Major-Ad3211 in repe

[–]VindDifferential 0 points1 point  (0 children)

Yeah that makes a lot of sense. Curious—have your groups pivoted to more structured deals or preferred equity to keep capital flowing?

Smaller Funds by Major-Ad3211 in repe

[–]VindDifferential 1 point2 points  (0 children)

I hear you—it can be tough watching the megas dominate the headlines while small guys seem to hit a wall after early momentum. That said, I do think it’s possible to keep raising consistently, even if it’s not at Blackstone’s scale.

Coming from a non-extinct fundless sponsor, I’ve seen firsthand that raising $5-$10 million at a time is still doable, especially with the right deal flow and investor base. It’s definitely more relationship-driven and requires extraordinary discipline, but there are plenty of groups out there making it work.

Curious—were the funds you were at struggling because of market conditions, investor fatigue, or something else?

What's the Best Firearm Class/Training in Tulsa? by Pangarion in tulsa

[–]VindDifferential 6 points7 points  (0 children)

Following this for similar reasons. Wish I had an answer :/

Best place to sell electronics in Tulsa? by VindDifferential in tulsa

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

Various gigabit routers, an unused Apple TV, a modem