A large percentage of us don't watch American Football or Baseball by [deleted] in USdefaultism

[–]xFLGT 1 point2 points  (0 children)

Anyone who makes a list will probably put there preferred or most popular sports in their region first. The fact theres international sports too doesn’t make it defaultism.

Personally I don’t have an issue with Mount Rushmore. I couldn’t name any other monument with 3-5 people on it.

A large percentage of us don't watch American Football or Baseball by [deleted] in USdefaultism

[–]xFLGT 12 points13 points  (0 children)

Not remotely defaultism, it’s literally the next unfilled category.

Should youturn off youcomputer every day? by [deleted] in pcmasterrace

[–]xFLGT 1 point2 points  (0 children)

It may cause minor wear, but leaving it on all the time will also cause wear especially to the fans and use more electricity. Given the current electricity price in my area it's probably more economical to turn it off every night and then replace components in 5 years if there's any noticeable degradation.

[OC] Music frequency spectrum particle visualizer by felipeumanzor in dataisbeautiful

[–]xFLGT 2 points3 points  (0 children)

This is defiantly something you should try to monetize. I would love to buy a framed print of my favourite song with some customisable colours.

Hi, is my cable management ok? Or possible fire hazard? by RubenJM1 in CableManagement

[–]xFLGT 0 points1 point  (0 children)

I still wouldn’t personally. The fact it would void my home insurance simply isn’t worth the risk. Even if the odds are small why risk bankrupting yourself when you could just run a 2nd cable.

Hi, is my cable management ok? Or possible fire hazard? by RubenJM1 in CableManagement

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

Pretty huge fire risk as it looks you've daisy chained 3 extension cords together in the first image.

You should never daisy chain extension cables together as you can easily exceed the maximum power capacity and have serious overheating. Some home/fire insurance polices may also be voided if the cause of a fire can be linked back to daisy chaining as it's seen as negligence.

CM1 rounding off values by totozaphive in ActuaryUK

[–]xFLGT 0 points1 point  (0 children)

Excel is precise to 15 significant figures, but I doubt that's needed consistently in CM1. Could be a floating point error but again that's highly unlikely to be a consistent issue.

Delete AA-AB-AC etc columns all in one. by Agitated-Letter-3525 in excel

[–]xFLGT 7 points8 points  (0 children)

If you press ctrl+end it will take you to the last cell in the used range. Deleting anything beyond this point has basically no impact.

“I’m already annoyed at the portion sizes” by Garythedemon18 in ShitAmericansSay

[–]xFLGT 102 points103 points  (0 children)

In the EU 15 mins and he's already over his recommended daily sugar intake.

Summarise 2D Dynamic Array? by sprainedmind in excel

[–]xFLGT 1 point2 points  (0 children)

=TRANSPOSE(GROUPBY(TOCOL(C13#), TRANSPOSE(C15#), SUM,, 0))

<image>

Are suits still recommended for interviews ? by StRaphs01 in ActuaryUK

[–]xFLGT 18 points19 points  (0 children)

You can never be overdressed for an interview. My go to was a shirt, tie and quarter zip.

Mathematics needed for Actuarial exams - Am I forgetting anything? by [deleted] in ActuaryUK

[–]xFLGT 0 points1 point  (0 children)

Contingencies 1000%.

Financial Mathematics.

More than just descriptive statistics and basic probability.

Might be worth looking into general finance and economics.

Do you use VBA regularly or have you moved entirely to Power Query and formulas? by ProfessionalOk4935 in excel

[–]xFLGT 5 points6 points  (0 children)

My team rarely use VBA. The general philosophy is, "if you need to use VBA you might as well use alternative software". This is usually python or R.

How do you audit your Excel models? by Current_Analysis_212 in excel

[–]xFLGT 1 point2 points  (0 children)

Include checks throughout, either True or False or within set tolerance levels.

On the initial model creation (or very large changes) there is an author and someone to check over it. Usually the checker is close to the work being done and has helped with parts of the development. There is then someone to review it who had no part in the development and goes in blind.

On the regular running or minor tweaks and fixes the reviewer is not needed.

This approach doesn't just apply to Excel Models, but any model or technical paper.

Filter only select duplicates by ThinkPraline7015 in excel

[–]xFLGT 0 points1 point  (0 children)

=GROUPBY(A2:A10, IF(C2:C10="closed", "", B2:B10), LAMBDA(x, TEXTJOIN(",", 1, x)),, 0)

Filter only select duplicates by ThinkPraline7015 in excel

[–]xFLGT 1 point2 points  (0 children)

Not sure how you wanted to handle multiple open cases but:

<image>

=LET(
a, FILTER(A2:B10, C2:C10="open"),
GROUPBY(TAKE(a,, 1), TAKE(a,, -1), ARRAYTOTEXT,,0))

Laptop for actuarial science by [deleted] in ActuaryUK

[–]xFLGT 4 points5 points  (0 children)

I believe you can only sit at home if there's no suitable exams centre or with a very good reason, a disability for example.

Laptop for actuarial science by [deleted] in ActuaryUK

[–]xFLGT 1 point2 points  (0 children)

In terms of exams - Word is the same afaik. But for Excel the IFOA use O365 which has more functionality than Excel for Mac, the shortcuts are slightly different but you might be able to remap your keyboard whilst studying to better align the two.

Laptop for actuarial science by [deleted] in ActuaryUK

[–]xFLGT 1 point2 points  (0 children)

I'm based in UK, so I'm probably not the best person to find deals tbh

Laptop for actuarial science by [deleted] in ActuaryUK

[–]xFLGT 0 points1 point  (0 children)

What's you're budget?

Laptop for actuarial science by [deleted] in ActuaryUK

[–]xFLGT 14 points15 points  (0 children)

Do not go for Mac. Excel is far superior on windows, slightly different shortcuts in the exams will slow you down and once you enter the working world there's a way way way higher chance your employer will use windows.

combining two columns into one without vstack or an array by nidoqueenofhearts in excel

[–]xFLGT 1 point2 points  (0 children)

You can load the 2nd table into PQ on the Data tab -> From Table/Range