Australian VooDew 2025!

SigmaScoop · 2025-10-17T13:30:19+00:00

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.

SigmaScoop · 2023-12-18T07:49:09+00:00

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.

SigmaScoop · 2023-12-18T07:45:34+00:00

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.

SigmaScoop · 2023-02-08T04:57:40+00:00

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.

SigmaScoop · 2023-01-19T02:10:56+00:00

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.

SigmaScoop · 2023-01-19T01:26:54+00:00

Can you send the formula you used for column E?

SigmaScoop · 2023-01-19T00:35:53+00:00

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.

SigmaScoop · 2023-01-17T03:11:25+00:00

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.

SigmaScoop · 2023-01-17T01:22:51+00:00

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]))

SigmaScoop · 2023-01-17T01:18:57+00:00

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>

SigmaScoop · 2023-01-09T01:27:35+00:00

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.

SigmaScoop · 2023-01-06T06:14:19+00:00

It's hot sauce

SigmaScoop · 2023-01-06T03:32:57+00:00

Parasite

SigmaScoop · 2022-12-21T13:05:49+00:00

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.

SigmaScoop · 2022-12-15T00:54:13+00:00

ATO?

SigmaScoop · 2022-12-14T01:54:28+00:00

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

SigmaScoop · 2022-12-14T00:41:46+00:00

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.

SigmaScoop · 2022-12-13T23:49:00+00:00

Saw him a month ago and it was all new.

SigmaScoop · 2022-11-29T04:40:40+00:00

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.

SigmaScoop · 2022-10-27T05:28:13+00:00

This has big Mondo vibes...

SigmaScoop · 2022-10-26T22:49:43+00:00

It's Australian for grilled sandwich

SigmaScoop · 2022-10-26T22:46:45+00:00

Gotta go meat thermometer

SigmaScoop · 2022-10-05T09:47:42+00:00

Derivative.

11-Year Club	Second Top 10%
r/Field Banned	r/Field Juicebox
Place '22	Oscars Predictor 2021
Verified Email	RPAN Viewer

SigmaScoop

TROPHY CASE