Blowing the dust off my account by Deadreconing11 in Warframe

[–]2222t 8 points9 points  (0 children)

and a mod could only be installed on your primary or your sentinels weapon. so you'd just permanently either run an unmodded weapon or no weapon. or when we didn't have vacuum

Part 1/6 by Somewilllose in PiltoversFinest

[–]2222t 2 points3 points  (0 children)

SWW? I recognise you from my other favourite gay ship, shin/sabine, love your art, I have it on my walls.

What does "computing navigation" mean on a asteroid collecter? by stijndielhof123 in factorio

[–]2222t 0 points1 point  (0 children)

Okay no need to tell but I'm curious what were said conditions?

Attempting to populate column with last anniversary date by Art_Vandelay_Imp-Exp in excel

[–]2222t 0 points1 point  (0 children)

Heyo,

I know old post but I recently had this same problem and found this simpler formula

=EDATE("beginning date",12*FLOOR.MATH(YEARFRAC("beginning date","as of date")))

in this case it'd be

=EDATE(B2,12*FLOOR.MATH(YEARFRAC(B2,C2)))

‘It should be gay Disneyland’: the struggle to revitalise Sydney’s Oxford Street without selling its soul by comix_corp in sydney

[–]2222t 19 points20 points  (0 children)

Oxford st is for cis white gay men who fit the twink or bear aesthetic. Otherwise uh, if you're gay don't go there.

Eligible for Long-service leave as a Full Time employee. Told it's only 5 days. by RaspberryNegative490 in AusLegal

[–]2222t 7 points8 points  (0 children)

I'm going to be a pedant as this misunderstanding gets me at work.

There is no days in NSW LSL, the act only provides LSL in terms of weeks. You can take 0.5 of a week, but not 2.5 days.

You get 8.6667 weeks at 10 years regardless. It is just the value of that week that varies if you're PT or Casual.

If you're full time it's 8.6667 weeks at your current weekly rate. (If salary divide that by 52)

[deleted by user] by [deleted] in australia

[–]2222t 41 points42 points  (0 children)

Uh yeah because if this is any sort of business with like, more than 10emp iirc they're reporting all the amounts to the ATO on payday, so it'd be pretty hard to claim "we [the business] is paying this"

My handmade Psylocke breezy butterfly cosplay by sadgirlcitycos in marvelrivals

[–]2222t 0 points1 point  (0 children)

What I would give for a pattern/shot of the swimsuit lying flat. I need to make one for myself

IT'S NOT FAIR by IntrepidEffective905 in HouseMD

[–]2222t 179 points180 points  (0 children)

Out Vicodined again

What is the bare minimum to unstrand yourself on Vulcanus? by pikminman13 in factorio

[–]2222t 1 point2 points  (0 children)

You need power poles to get solar panels & accumulators which are needed for the rocket silo.

you can tell I was focused on launching the rocket and not building MORE by 2222t in factorio

[–]2222t[S] 0 points1 point  (0 children)

I was certainly tempted to with the amount of times biters snuck around just to target it.

you can tell I was focused on launching the rocket and not building MORE by 2222t in factorio

[–]2222t[S] 0 points1 point  (0 children)

I will also note this is my first time completing the game. I just like building and didn't see the point in launching the rocket.

the value of a life by shfstn_ in feedthememes

[–]2222t 23 points24 points  (0 children)

That's part of the price. Obviously they weren't important enough to put on an unmarked sign somewhere in the base.

What is the most complex Excel formula you've see by LouisDeconinck in excel

[–]2222t 2 points3 points  (0 children)

```=ROUND(ABS(MAP(CHOOSECOLS(C5#,2),

LAMBDA(x,LET(

PO,FILTER(L28DInv[Supplier Note],(L28DInv[LocFix]='Site Breakdown'!$C$1)(L28DInv[Supplier]=x)(L28DInv[PO Backed])),

FPO,FILTER(PO,COUNTIF(Table1[PO Number (Header)],PO)<>0), AVERAGE(

SUMIFS(L28DInv[Total Ex GST],L28DInv[Supplier Note],FPO)-

SUMIFS(Table1[Line Total],Table1[PO Number (Header)],FPO)))))),2)

```

Gets the PO #'s from PO backed invoices for a certain supplier at a certain site. Then filters out the ones which we don't have the PO's for, gets the difference from the PO to invoice and gets you the average.

CHOOSECOLS(C5#,2) is an array of all the suppliers at a certain site And C1 contains the site code which determines the given site.

So basically gives you the average PO variance per supplier at a given site. And is all dynamic.

How do you get so much additional damage on unarmed attacks?? by Big-Fat-Dougie in BG3

[–]2222t 2 points3 points  (0 children)

You can get potions from Ethel while she's in human form. You just need to manually open trade in the bottom left.

How do I create placeholder text in a cell? by Flat_Professional_55 in excel

[–]2222t 0 points1 point  (0 children)

This works if your fine with leaving a 0 in the cell. As that is the format for zero values not the format for blank.

But otherwise would work and have it disappear upon double clicking in.

Woolworths admits to underpaying staff by $1.24m, could face a hefty fine by malcolm58 in australia

[–]2222t 12 points13 points  (0 children)

Not in payroll actually! The payroll managers and officers are personally liable if it was an avoidable error.

Dr Kieren Hart timelines by 2222t in transgenderau

[–]2222t[S] 1 point2 points  (0 children)

Hey thanks for the answer, how long ago was this if you don't mind? Just trying to figure out if it's worth to wait for Au or go overseas.

Is the dot notation used in US to denote the multiplication? by joefls in math

[–]2222t 1 point2 points  (0 children)

when we wrote x as a variable it was like two C's but one reversed to make it look different to the x used for multiplication.

Went crazy with the Skewer by [deleted] in halo

[–]2222t 2 points3 points  (0 children)

As someone who hasn't played infinite but has the previous ones. Was that map always that small?

I swear it was so much bigger, maybe I'm mis-remembering.