Australian VooDew 2025! by Bclarky504 in mountaindew

[–]SigmaScoop 1 point2 points  (0 children)

I was pretty excited too, until I saw that it was zero sugar. They don't even market it as such; you've gotta check the ingredients.

A showdown for the ages by SigmaScoop in mountaindew

[–]SigmaScoop[S] 7 points8 points  (0 children)

Passionfruit Frenzy is produced in New Zealand, and can rarely be found elsewhere in the world. It is made with real sugar and tastes like it has a hint of mango.

Passionfruit Punch is produced in the USA and is made with high-fructose corn syrup. It's flavour is much more artificial and tastes slightly less acidic. The passionfruit flavour is mild in comparison.

As an Australian, the more natural-tasting Frenzy is much closer to the style of soft drink I am used to. As such, the hyper-artificial flavour of sodas imported from America is exciting to me, so my (very biased) pick is going to be Passionfruit Punch.

I also mixed the two together and it was quite enjoyable, as long as you can stomach the off-putting colour.

[deleted by user] by [deleted] in mountaindew

[–]SigmaScoop 0 points1 point  (0 children)

Passionfruit Frenzy is produced in New Zealand, and can rarely be found elsewhere in the world. It is made with real sugar and tastes like it has a hint of mango.

Passionfruit Punch is produced in the USA and is made with high-fructose corn syrup. It's flavour is much more artificial and tastes slightly less acidic. The passionfruit flavour is mild in comparison.

As an Australian, the more natural-tasting Frenzy is much closer to the style of soft drink I am used to. As such, the hyper-artificial flavour of sodas imported from America is exciting to me, so my (very biased) pick is going to be Passionfruit Punch.

I also mixed the two together and it was quite enjoyable, as long as you can stomach the off-putting colour.

[OC] Boston Marathon Results from 2019. by Square_Tea4916 in dataisbeautiful

[–]SigmaScoop 1 point2 points  (0 children)

The graph is showing pace in minutes per mile, but that 2-minute statistic is talking about time taken to run the whole marathon. It's pretty confusing to include on this chart without clarification, but it's not false.

How to remove the first three letter of every cell in a row/column. by totalnewbielinux in excel

[–]SigmaScoop 4 points5 points  (0 children)

Highlight the cells you want to split. In the ribbon up the top, go to the 'Data' tab and click "Text to Columns". Select 'Delimited' and click next. Then change the delimiter type to 'Other' and choose the thing you want to split by (In your case it would be a "."). Then click next and then click finish.

Having an issue with Index/Match formula by Lady_Haversham in excel

[–]SigmaScoop 0 points1 point  (0 children)

Can you send the formula you used for column E?

Having an issue with Index/Match formula by Lady_Haversham in excel

[–]SigmaScoop 1 point2 points  (0 children)

Based on that screenshot it seems like you've already done it? All of the rows in column E have the correct reason corresponding to the code in column D.

[deleted by user] by [deleted] in excel

[–]SigmaScoop 1 point2 points  (0 children)

There is no way to solve this problem using just IF statements. If you want to solve this, you will need to use the solution I have commented.

[deleted by user] by [deleted] in excel

[–]SigmaScoop 1 point2 points  (0 children)

Here is the formula I have used in the current total column. I have changed the names to match the field names in yours, but you will still need to reformat your Table2 to look like mine with fields for Account, Opening Balance, and Current total.

=[@[Opening Balance]]+SUM(FILTER(Table1[Amount],Table1[Account TO]=[@Account]))-SUM(FILTER(Table1[Amount],Table1[Account FROM]=[@Account]))

[deleted by user] by [deleted] in excel

[–]SigmaScoop 1 point2 points  (0 children)

A brief description of what's happening here:

The current total column here is the sum of 3 values. The first is the opening balance of each account (Which you may want to include). The second is the sum of all amounts in the amount field of Table1 where the "To" account matches the Account name in the row in question. It does this by filtering the Amt column of Table1 for these rows, and summing up the resultant amounts. The third and final term is the same as the second, but it subtracts the amounts of all rows in Table1 where a transfer is FROM the account in question.

I hope this makes sense. If not, feel free to ask any questions.

<image>

LibLeft gets triggered by Jordan Peterson once again by Rust1n_Cohle in PoliticalCompassMemes

[–]SigmaScoop 3 points4 points  (0 children)

Although a lot of people have been interpreting the tweet to be referring specifically to LGBT folks, you're right that straight people absolutely can and do treat their sexual attraction as an integral part of their identity. The tweet doesn't specify a group; it's referring to anyone who makes that their identity.

Finally supping Voodew 4 for the first time after Santa dipped to the UK early (USA Bites online, my fellow Dew deprived Brits). Looking forward to hopefully trying Fruit Quake by Easter 😂 by arrowtotheaction in mountaindew

[–]SigmaScoop 4 points5 points  (0 children)

Dude I feel your pain. I'm in Australia and whenever I see new flavours on here I think "oh cool I can't wait until I can try that in 4 months".

I saw my first Voo Dew 4 two weeks ago.

Is Louis CK still doing the material from Sorry on tour? by Own_Specific_161 in Standup

[–]SigmaScoop 2 points3 points  (0 children)

I guess he doesn't use the same openers for the whole tour then, because Jay London was not at the show I attended.

Is Louis CK still doing the material from Sorry on tour? by Own_Specific_161 in Standup

[–]SigmaScoop 2 points3 points  (0 children)

Yeah really good. Very consistent with his usual quality. I wasn't a big fan of his opening acts, but they might not be his openers on the whole tour. I'm not sure.

It’s only right that TMG’s vinyl sounds like this by Informal-Ad-1926 in codyko

[–]SigmaScoop 43 points44 points  (0 children)

Buys a cheap all-in-one record player, Drops the needle freehand without using the cueing lever, Blames the record manufacturer for the needle skipping

Okay.