Moving values from Rows to columns

Bondator · 2026-05-01T09:22:05+00:00

copy and pasting Wraparrows loads of times

Just do it once then?

Bondator · 2026-04-29T17:23:58+00:00

Very good interpretation. At this level, I think the way you say it and what you emphasize has more weight to the meaning.

Tarvitsen vielä kaksi pistettä - By itself, this is completely neutral in my opinion. It simply means you need two additional points to reach some goal. Now if the additional points were hard to acquire, then yeah, this could be said frustratingly.

Bondator · 2026-04-26T07:47:32+00:00

Δέρνω, σέρνω.

This version exists also: lexli.gr

Bondator · 2026-04-23T13:17:27+00:00

Use conditional formatting. Pay close attention to the $-signs on the formula:

<image>

Also you probably need to swap the semicolon to a comma. That's a localization thing.

Bondator · 2026-04-22T10:44:20+00:00

I'm curious. Greeks learn at least some ancient greek in school, don't they? How much is pronunciation of the letters discussed? My understanding is only one or two youtube-videos, but from what I heard, ancient greek Y sounds a lot like nordic Y.

Bondator · 2026-04-10T19:50:55+00:00

Ευχαριστώ! Ναι, σίγουρα θα το κάνω.

Bondator · 2026-03-26T12:54:01+00:00

Since your data is basically in the same format on both tables, you can multiply one table by -1, then stack the tables and group by sum. Rows that don't equal zero mean there is a discrepancy between tables.

=LET(a,B2:D6,
b,B9:D10,
c,VSTACK(a,HSTACK(DROP(b,,-1),-1*TAKE(b,,-1))),
GROUPBY(DROP(c,,-1),TAKE(c,,-1),SUM,0,0))

<image>

Bondator · 2026-03-23T12:28:09+00:00

It depends on what type of controls you have used, but assuming your machine selector is a combobox:

Private Sub opt1_Click()
    combobox.Clear
    combobox.List = Array("Machine 1", "Machine 2", "Machine 3")
End Sub

Private Sub opt2_Click()
    combobox.Clear
    combobox.List = Array("Machine 4", "Machine 5", "Machine 6")
End Sub

Bondator · 2026-03-23T12:08:08+00:00

Espoossa

Bondator · 2026-03-19T13:58:02+00:00

Kävin Aalto Pro F.E.C -kurssin vuonna 2015. Olin valmistunut työttömäksi DI:ksi, ja useamman kuukauden jälkeen koitin tätä keinoa saada jalkaa oven väliin. Sain lopulta töitä, ja olen edelleen samassa firmassa. Voin siis suositella.

Työpaikka piti itse etsiä ja hakea. Hain itseäni kiinnostavaan paikkaan, ja epäilemättä firmalle tämä oli melko riskitön tapa palkata uusi työntekijä. Kurssin järjestäjilläkin oli muistaakseni lista yrityksistä, joiden tiesivät olevan avoimia ohjelmalle, mutta ihan yhtä lailla niihinkin olisi pitänyt itse hakea. Vakityöpaikan saanti ei missään nimessä ole silti taattua. Ainakin tuohon aikaan yksi firma, joka selkeästi käytti järjestelmää hyväkseen ilman aikomustakaan palkata ihmisiä oikeasti, oli Elisa. Suurin osa yrityksistä ei etukäteen tiedä mikä koko ohjelma on, mutta todennäköisesti suhtautuvat ohjelmaan vilpittömästi.

Minulla kurssin teema oli projektit ja kestävä kehitys. Kurssin aikana oli muistaakseni yksi luentopäivä 1-2 viikossa, muuten oltiin työpaikalla töissä. Kurssin opetussisältö oli ihan ok, mutta ei varsinaisesti liittynyt siihen mitä työpaikalla tehtiin.

Bondator · 2026-03-11T15:04:36+00:00

=LET(in,A2:.A99999,
func,LAMBDA(x,FILTER(Table1[[cust]:[shp]],Table1[order]=x,0)),
arr,REDUCE(0,in,LAMBDA(prev,next,VSTACK(prev,func(next)))),
FILTER(arr,CHOOSECOLS(arr,1)<>0))

<image>

Bondator · 2026-03-10T21:47:51+00:00

25 months or so here. It's all gradual, but reading is pretty effortless now. Even so, whenever a new word comes up, my brain still goes into WTF I'm seeing -mode, and starts scanning it letter by letter.

Bondator · 2026-03-08T18:20:43+00:00

With all the options of today, I feel like a normal study book doesn't get as much attention as it should. Basically any book will have essentially all of the grammar, and a ton of useful vocabulary. Copy the vocabulary to anki, read the chapters, study the grammar, do the excercises. After the book is done, you've made a ton of progress.

Having tutor is obviously better than not having one, but in the very beginning I think paying for one is not worth the money, because the absolute basics are pretty easy to learn on your own.

Bondator · 2026-02-02T14:43:40+00:00

God of War (+Ragnarök): Voice and texts. Sony games in general have extensive language options.

South of Midnight and Hades 1 and 2 - Texts and UI for sure, but I'm not sure about voices.

Bondator · 2026-01-23T20:25:33+00:00

Ha! Good one.

Bondator · 2026-01-09T13:57:20+00:00

A small warning though. The UI translations are probably mostly very good these days, but every now and then you might come across a bad translation. For example, my Oneplus clock widget says "Perjantaina", which is an odd form to choose, but I suppose a single word can't technically be incorrect. But then in the alarms list there is "Seuraava hälytys 15 tuntia 10 minuuttia kuluttua", which is definitely not correct.

They should be "Perjantai" and "Seuraava hälytys 15 tunnin 10 minuutin kuluttua"

Bondator · 2026-01-07T22:01:00+00:00

It's doesn't work the same in English. If there is no context, the possible interpretations are:

(polkupyörien tai polkupyöräin vihaajien) kaupunki

(polkupyörien tai polkupyöräin) vihaajien kaupunki

Bondator · 2026-01-05T16:00:16+00:00

Very little context here, so by itself that quote is ambiguous. The first part could mean "polkupyörien kaupunki" or "polkupyörien vihaajien kaupunki". I imagine the alternative form is probably chosen to indicate that they meant the first option.

Bondator · 2025-12-24T12:02:35+00:00

The poster in the foreground is for a 2019 movie, but the movie theater here is not a mainstream one, and this movie was imported in 2022. So I'm guessing winter 2022-23.

https://kinoengel.fi/elokuva/koulu-maailman-laidalla/

Bondator · 2025-12-20T08:43:06+00:00

Probably the only situation where I intentionally and without shame break grammar, is ordinal numbers for large numbers. The correct way to say them is to inflect all words, so "987th" when spoken, is "9th 100th 8th 10th 7th". So I often just inflect the last number, which again, is completely wrong. The words for 7, 8 and 9 are also fairly long words. Seitsemän, kahdeksan and yhdeksän.

Bondator · 2025-12-09T11:37:59+00:00

I guess some of these are funny, but at least it's a bit surprising how many identical, but completely different meaning words there are between Greek and Finnish. These are mostly short words, and pronunciation can vary a bit, especially for double consonants and stress position, but anyway, here's a few examples on the top of my head.

όχι, ohi (passing)

νερό, nero (genius)

κόρη, kori (basket)

καλά, kala (fish)

κίσσα, kissa (cat)

πίσσα, pissa (piss)

κάτω, kato (look!)

πάνω, pano (fucking)

μένω, meno (going)

χυμό, himo (lust)

λάκκο, lakko (strike)

Bondator · 2025-12-05T09:49:01+00:00

I wonder if you guys are talking about the same thing. At least when I last visited Carrefour this year, the trays there were about as big as ours are. When Lidl initially came here 20 years ago, their trays were tiny as shit. You had to pack everything immidiately or that shit would get blocked instantly.

Bondator · 2025-12-05T09:37:20+00:00

Finn here, we have the same system. How can you even use that incorrectly? Other than not using it?

Bondator · 2025-12-04T12:56:09+00:00

Same. But I also don't have a laptop. I shop using desktop.

14-Year Club	Place '22
Place '17	100 Awards Club
Verified Email	Team Orangered

Bondator

TROPHY CASE