After a period of dryness followed by rain, the roads are slick and oily. There's always a big uptick in road accidents.
Bear that in mind and stay safe folks!
Link to a dummy spreadsheet https://docs.google.com/spreadsheets/d/1veGwaVqaCQB-4YFQHImupGEBAvVNTR_eYqHKV9YUcYc/edit?usp=sharing
Ok so my scenario: I run a poker tournament every month. I have a table of players, which shows how many times they've knocked each other out.
I want another table based on the first table which will show, in each cell:
"Dave's knocked Ewan out three times, and Ewan has knocked Dave out zero times" sort of thing.
I can do that manually for each one using CONCATENATE, so for example =CONCATENATE(C2, " : ", B3) gives a result of 3 : 0 - so far so good.
Here's my problem: If I autofill the columns, it's the cell rows that change for both values, and if I autofill the rows, it's the cell columns that change for both values - but I need autofill to increase the row used in the left hand value (the three in 3:0), whilst increasing the column used in the right-hand value (the zero in 3:0).
Can the table be auto-populated in such a way that the row changes for the first value, whilst the column changes for the second value?
Banana for scale
Nearing the end of an 8 day course of prednisolone tablets to counter a bad flare up. So *this* is how "normal" people's hands feel **all the time**?
They don't know how lucky they are!
For me it's *The Tourist* to *Everything in its Right Place*.
Just the juxtaposition of the very human, warm analogue sound of The Tourist (and that final "ping!") with the sterile digital coldness of Everything in its Right Place.
Makes me feel like the "ping" is death, the full stop of life, and what comes immediately after is the coldness of some weird digital stress-dream afterlife.
Would love to hear yours - doesn't have to be concurrent albums either.
Just watching a Youtuber playing Slay the Spire 2, and this is one of the relics (an in-game item you can find that gives you bonuses etc).
Thought it was pretty cool.
Anyone know how to stop automation doing what it's doing in the screenshots? Basically I have a selected clip with automation, and then want to CTRL+LMB it to copy it somewhere else. When I do that, it acts weirdly, like in the 2nd screenshot (the automation from the left hand clip is also duplicated and shifted along). If I do that again, I get the 3rd screenshot. I end up with automation crossing over itself over three lanes (or more). This can't be intended behaviour (whereas using CTRL+LMB to clone a clip is).
I can copy and paste the clip instead, and this issue won't happen. It'll look like the 4th screenshot - perfect. Just wondering if this is a feature or a bug, and if there's a simple setting somewhere I'm missing that a) will enable me to copy automation with the clip without b) messing up the automation that's already there?
It isn't a huge deal, just would fit my workflow a little better :)
Someone would know where and how it started. And knowing how to make it would be invaluable to any number of countries, both good and bad. Want to find a cure? Understand the cause.
So... A small team goes in and there are the usual unexpected complications - more infected than expected, zombie monkeys (lol) and maybe those naughty Russians also have the same idea? Maybe someone on the team is a double agent, and tries to fuck their team over, whilst trying to get out alive themselves?
Whoever gets in and out first gets the prize. Then blow it up to f*ck and back to make sure no one else can get their hands on the "formula."
I can't imagine that NATO or someone else *wouldn't* attempt this, given what's at stake if someone else got hold of the secrets...
Edit: I'll put this down to my own daftness. It's behaving exactly as I thought it would now but I swear it was doing the weird stretching before. Anyway - move along, nothing to see here.
The following was happening, I swear, but I think I was just being a dumbass...
I'm trying to get an extended drum loop to fit my tempo. I can't though, because when I drag the end of the clip to stretch it, what happens is that the "stretch" isn't consistent across the clip: the end stretches much further than the beginning, if you get what I mean.
Visual representation:
Kick before stretching:
1...2...3...4...5...6... and so on - all spaced equally
Kick after stretching:
1....2.....3..........4.............5..................6................. - much bigger gap between 5 and 6 than 1 and 2, makes aligning the drums to the tempo impossible.
So knowing how customisable Reaper is, I know there must be a setting that changes the stretch behaviour so that the clip stretches equally. Anyone know what that is?
No end of times I've got the perfect sound then deleted the synth or changed the settings like an idiot and not been able to get them back.
​
I'd love it if there were a padlock button on devices and you click it and that prevents that device from being changed, deleted etc until it was deselected again.
​
Please?
Edit: yes I know about undo, but sometimes you'll only realise you've messed up half an hour or more later, after you've made lots of other changes.
Just a warning - myself and my neighbour's cars got hacked last night (both Peugeots).
Doors were open (no damage) so it looks like they cloned the key fob codes (I don't know if that's a thing) or did the old "relay" hack.
Couple of quid stolen and no damage, but I just wanted to remind people not to be lax with your security and not to trust Ring doorbells (apparently thieves can block the wifi signal, rendering them useless).
Keep valuables out of your car, and if you can, keep it safely tucked up in your garage overnight.
Edit: according to Facebook, someone was caught in camera on Celta Rd trying door handles.
Rewatched 28DL a couple of days ago, and I have to admit, I am still struggling to figure out HOW THE HELL a London cab managed to drive OVER the roofs and bonnets of a bunch of cars in a mangled up traffic jam in a tunnel. Frank didn't drive *through* the other cars, he drove *over* them. I know there was a barricade of sorts to begin with, which acts as a sort of ramp, but what then?
Is his taxi Chitty Chitty Bang Bang or something?
Why does your latest advert have to feature a dad being spoken to as if he's an idiot, by his impolite horrible ungrateful child? He does all this stuff and doesn't even get a thanks at the end, just "good"???
Come on folks, I know you think spoilt, rude kids are cool but honestly.
1970 - 1971, and repeated regularly throughout the 70's and 80's
I'm not repeating myself.
A vehicle completely blocks the stairs (you can get it there through the garage OR through the pedestrian double doors (I can't believe it fit through but it took some time). And you can enter the vehicle through one side and exit out the other. Now I just need to get rid of the tires...
Ok so you're comfortable with Extinction mode. 6% sprinters, superhumanly strong, tough zombies that can sometimes open doors, and a chopper that doesn't just come around once... That's become easy. Trivial, almost.
So what are you changing up to make it difficult?
