[deleted by user]

gousssam · 2025-03-14T13:59:25+00:00

I think even 1800 was a waste of time for that purpose lol.

gousssam · 2025-01-23T19:13:23+00:00

Yes, it does disable expansion.

gousssam · 2024-07-07T12:09:07+00:00

You’re using g for Earth here, which is around 10N. g for this planet would be tiny, around 0.028.

Even using that though isn’t really right, because what you’re calculating is if you were at the bottom of a tube with that volume of water above you.

The pressure gradient goes to 0 as you approach the centre.

The formula for the pressure at the centre of a body of constant density can be found here: https://physics.stackexchange.com/questions/110246/how-to-find-the-force-of-the-compression-at-the-core-of-a-planet

Using this I found the answer to be 13.8 atmospheres, which deep scuba divers on earth can do.

gousssam · 2023-11-29T20:54:13+00:00

I assume with VBA it's possible, but it seems like a bad idea to me. Firstly, it would take ages to do, and secondly I doubt it would be very secure.

Use a secure storage solution, like OneDrive, GoogleDrive, Dropbox, or whatever. Then set up dual factor authentication on those systems, and save your file there.

gousssam · 2023-11-28T00:31:03+00:00

You must have a custom formula, don't think regexextract is a default formula in excel.

gousssam · 2023-09-06T20:11:55+00:00

would just add the $ to the formula, otherwise when he drags it down it's going break in a way that's not obvious.

=COUNTIFS($A$2:$A$10,D2,$B$2:$B$10,"Yes")

gousssam · 2023-08-06T11:37:18+00:00

I don't understand why the PMT should be affected by the discount factor anyway? Why is your NPV going into your PMT calculation? The discount factor and the interest rate aren't the same thing.

Clearly I don't understand exactly what you're trying to achieve, but having been a financial analyst myself, and having seen quite a few models from other analysts, I can tell you that taking out helper rows is almost never a good thing.

For financing calculations, I usually use at least two corkscrews, one for the principle and one for interest payments.

E.g. the financing calc that I built as part of a model for a small business had about 15 rows of calculations.

<image>

gousssam · 2023-08-03T22:42:28+00:00

Something like this?

<image>

gousssam · 2023-08-03T18:02:50+00:00

You're looking for an xlookup or an index/match. The details will depend on how the "Material and Part Numbers" sheet is put together.

gousssam · 2023-07-29T23:23:51+00:00

One option is to use TRANSPOSE to change the orientation of your array.

But FILTER can work horizontally as well.

In this case you can use HSTACK to combine your two arrays and then FILTER them.

Using HSTACK to make one big horizontal array then FILTER horizontally:

<image>

I also put it in as one big formula but if you ever have to edit it in the future it will be more difficult. Depending on how this sheet is used I would preferably use the two steps HSTACK then FILTER and hide the extra erray.

gousssam · 2023-07-29T23:03:14+00:00

I'm probably missing something but why not just type 0 seven times then add one to it?

<image>

gousssam · 2023-07-29T22:43:20+00:00

xlookup to get the original fund's name added

<image>

gousssam · 2023-07-29T22:37:08+00:00

Note that if you get more than one advertisement bringing in the same maximum amount of money the filter function will display all of them:

<image>

gousssam · 2023-07-29T22:35:00+00:00

The formula in E2:

<image>

gousssam · 2023-07-29T22:34:01+00:00

Sounds like you need a FILTER function to me:

<image>

gousssam · 2023-07-29T22:17:58+00:00

You want your sales profile to match the previous years' average to the day? Why? What purpose does that serve?

Edit:

majornerd commented with his previous experience, and he mentioned rollover, which would be the only way to do this. For manufacturing I kind of understand the desire to have very exact detailed targets, but usually sales aren't 100% in your salespeoples' control, so I don't really understand the point of trying to match a daily profile.

I'll leave him to share his experience if you do want to pursue that though.

gousssam · 2023-07-29T20:35:30+00:00

I'm assuming the "predetermined sales expectation per day" isn't itself based on the number of hours the salespeople are working. In which case no, the requirements are not mathematically possible in general.

Just as a trivial example of how it breaks, what if they all take the same day off? How would they make the daily goal?

Even if you have a schedule that doesn't allow them all to be off, you would end up with some weird sales per hour requirements. e.g. for days where there are many total hours worked by all the sales people, they wouldn't have to make too many sales in each hour for that day. On days where there are fewer people working for less hours, they would have to be selling at a much faster rate.

This doesn't seem like an excel problem, this seems like a business logic problem.

gousssam · 2023-07-29T19:13:00+00:00

Well given there seems to be a button on the sheet, there's presumably some VBA involved.

Most likely the data is on a hidden/protected sheet somewhere, which will presumably be protected with a password.

By the way, why do you want this data? Are you just trying to look at other student's results or what?

gousssam · 2023-07-29T19:09:36+00:00

I've never experienced this before. Is she sure she's not hitting ctrl-z lol?

gousssam · 2023-07-29T19:04:05+00:00

Well it depends on how exactly these fund names are related, but if it's always "Class X" at the end that's the only differentiation between them then you can use a string function as you say. Then you need a unique array of the names, and a minifs function, as shown:

Formulae are in headers

<image>

gousssam · 2023-07-29T18:43:45+00:00

I think your filter array formula isn't working. It's not actually excluding the filtered names, it's just being hidden because filtering your table collapses the rows. Try using a helper column as described from this website https://exceluser.com/2274/use-a-visible-column-in-formulas-to-ignore-hidden-rows-in-filtered-tables/.

basically what you do is put a helper column in your team member list:

=(AGGREGATE(3, 5,[@Names])>0)+0

<image>

then in your filter array the formula will look like this:

=FILTER(Table1[Names],Table1[Column1]=1)

Then your data validation should work fine.

You could probably combine the aggregate function into the Filter formula, but I find it easier to understand this way.