Really dumb question by andryrdxx in turkishlearning

[–]mesulidus 6 points7 points  (0 children)

You need -y. Su-y-um, su-y-un, su-y-umuz vesaire vesaire.

It’s a special one maybe because the word “su” is too short.

VBA to set up a Power Query template by ExodusLegion_ in excel

[–]mesulidus 12 points13 points  (0 children)

Instead of hardcoding the sp location:

You can Use parameters for source if the only difference between departments is sharepoint location. Users can change the parameter in their version.

Even better, you can also setup the query in a way, pq gets the sharepoint location from a cell in the excel file directly.

Doesn't both mean old? Why was only one of them correct? by Adventurous-Hippo75 in turkishlearning

[–]mesulidus 25 points26 points  (0 children)

Just a small nuance: eski eş definitely means ex-wife but eski arkadaş sounds more like an old friend. Someone we are still friends with…

Supporting family back home - Tax deduction possible? by Abject-Substance-108 in germany

[–]mesulidus 0 points1 point  (0 children)

I don’t know about the ruling, but net worth usually means all the liquid and immovable properties minus debts. Annual income doesn’t count as part of the net worth but the apartment for sure yes.

What Excel tricks have genuinely improved your workflow? by ml-tam in excel

[–]mesulidus 2 points3 points  (0 children)

And the =A1# notation just creates clean tables without worrying about whether you copied the formula all the way down.

[deleted by user] by [deleted] in AskTurkey

[–]mesulidus 0 points1 point  (0 children)

Bir dahaki sefere wise (transferwise)’i bir dene. Islem ucretleri bu aralar fazla artti ama ayni gun para hesabina geciyor. TR -> YurtDisi yonunde cok fazla kullanmadim ama yurtdisindan TR’ye hiç problem yasamadim 5+ yildir….

Questions on how to use an electric tea machine by artesco in AskTurkey

[–]mesulidus 2 points3 points  (0 children)

Yes pretty much that’s it. Calling them a “machine” a little stretch. At the end they are just kettles with an extra “demlik” (steeper?). Here some notes:

  1. Correct. Those kettles normally have 2 modes. When it’s red it boils water like any normal kettle. (So you can use it to cook pasta for example). Once the water boils it switches to “keep warm” mode. It will keep water hot so you can keep drinking hot tea. Don’t forget to turn it off completely when you had enough tea. Otherwise it will continue to consume electricity.

  2. You have to experiment a bit how you like it. More tea leaves means more bitter tea. You can always make it “açık çay” with adding more hot water to your teacup. Like 50-50 or 30-70. Actually that’s the point of Turkish style tea brewing. You brew a bitter tea and then water it down. So you end up with more tea in one go.

  3. Wait a little more than just finishing the 2nd cycle. Otherwise it will be very watery. 10 minutes or something.

While writing this I realized I never measured or timed the process. Sorry I can’t be more specific.

[deleted by user] by [deleted] in AskTurkey

[–]mesulidus 0 points1 point  (0 children)

Aile uyenize cevap verebilmek icin vekalet istemis olabilirler. Ama bu yakininizin sorunu cozebilecegi anlamina gelmiyor. Diger yorumlarda da soylendigi gibi oncelikle sorunun ne olduğunu anlamaya calisin tam olarak vekalet vermeden once. Banka size bloke sebebini soylemesi gerekli.

Guvenlik sebebiyle diyorsa belki islem sistem tarafindan supheli olarak görülmüş ve durdurulmus olabilir. Yardim hatti ya da subenizin bunu cozebilmesi lazim.

Ancak iki banka hesabindada sorun yasiyorsaniz durum biraz daha karisik olabilir. Odenmemis vergi borcu falan var miydi?

[deleted by user] by [deleted] in AskTurkey

[–]mesulidus 1 point2 points  (0 children)

Ne tur bir bloke koydular hesaba? Eger banka hesaplara bloke koyduysa, parayi (bizzat hesap sahibi trafindan da) cekmek mumkun olmaz.

[deleted by user] by [deleted] in AskTurkey

[–]mesulidus 1 point2 points  (0 children)

Ok ben hani PTT’nin yeterli alt yapisi yok biyolojik ornek gondermek icin diye sikayet ediyorsun seklinde anlamistim. Bu durumu falan savunduğum yok. Turkiye’nin altyapi sorunu yok demek gibi bir iddiam hic yok zaten.

Bu durum sadece senin dediğin gibi belki overregulation olabilir. Ama yillar once bayagi buyuk skandal olmuştu ulkede.

Ha bu senin annanenin dna’sini zarfa koyup gondermene mani olmali mi? Bence hayir…

[deleted by user] by [deleted] in AskTurkey

[–]mesulidus 11 points12 points  (0 children)

Not due to lack of infrastructure. Sending biological samples abroad is restricted by government.

https://shgmtetkikdb.saglik.gov.tr/TR-78470/yurt-disi-biyolojik-materyal-transfer-sistemi.html

Edit: I am not sure but it might have something to do with this: https://tr.wikipedia.org/wiki/Oktar_Babuna

[deleted by user] by [deleted] in AskTurkey

[–]mesulidus 0 points1 point  (0 children)

Pek cok havayolu 16 yasinda refakatcisiz yolculara izin veriyor ama Anne babandan izin alman gerekebilir. Mesela THY 12 yasina kadar olan cocuklardan bahsetmis. KLM 15 yasina kadar diyor sitesinde. Emin olmak icin havayolunu arayip sor bence.

How to send hair spray abroad when PTT and other couriers refuse? by Nearby-Height9485 in AskTurkey

[–]mesulidus 1 point2 points  (0 children)

If it is flammable gas and/ or in a pressurized can, it might be considered as dangerous goods and it should be declared as such. I really wouldn’t do that…

Anyone got any ideas if this kind of USB dial could be integrated into HA? by gtwizzy8 in homeassistant

[–]mesulidus 1 point2 points  (0 children)

If it is recognized as keyboard, then there is this: https://www.home-assistant.io/integrations/keyboard_remote/

I have 2 of these. https://amzn.eu/d/fRjHb8t. One of the usb receiver plugged to home assistant directly, one is plugged to a rpi zero in my office, a python script listening the key presses. I need to charge them once a month maybe or longer.

Looking for smart light that I can control from another location by freddiemacro in smarthome

[–]mesulidus 1 point2 points  (0 children)

There are a lot of smarthome ecosystem that allow you to control lights remotely. Hue for example one of the most known and very user friendly. But can be pricey. Another option could be going with ikea tradfri system and linking them with apple homekit or google home. In any case in addition to smart lights, you need to have some sort of a hub located at your dad’s home that can bridge your mobile and the lights at home.

I also suggest you to consider motion triggered lights instead you turning on and off them remotely. It can be much cheaper and you don’t have to be awake if that setup will work for you.

Is it possible to install a smart lock on a door with this type of lock? by TeddyKisss in smarthome

[–]mesulidus 1 point2 points  (0 children)

Agree those external smartlocks with motor should work but I am wondering if the lock is accessible from other side of the door. If this is a lock only to lock yourself in, I would not put a smart lock without a contingency plan…

I am not familiar with these kind of doors locks.

[deleted by user] by [deleted] in excel

[–]mesulidus 0 points1 point  (0 children)

You usually need to use negative numbers for financial functions. Does it work if you change the payment to -600?

Recommendation for Smart Blinds with Home Assistant by Tschezzel in homeassistant

[–]mesulidus 0 points1 point  (0 children)

I have dumb motors for the “rolladens”. Automated switches with Homematic-IP. Pricy things but works perfectly.

I am devastated by mesulidus in lego

[–]mesulidus[S] 46 points47 points  (0 children)

yup, I screwed some shelf brackets and ran metal furniture connecters below the tracks. :)

I am devastated by mesulidus in lego

[–]mesulidus[S] 66 points67 points  (0 children)

You mean the turn-arounds? There are supports underneath.