morning

Morning :)

How are you feeling today?

Slow, the cough is still there... and I think the intestines are slightly upset for whatever reason. I have a stomach ache :/

Yeah, sounds familiar

it's a bit of a wallop to your system, everything goes out of whack

Yep. I still haven't really regained my appetite either. I have breakfast (already at a later point than usual), then lunch at around 3/4PM, and then I don't feel like dinner at all...

I've mostly done some fruit about an hour or two before bed, just for vitamins, but otherwise...

gf actually went out and bought vitamin C pills for that reason :x

the only thing remaining right now is that my throat still feels rough, the mucal layer probably still hasn't restored itself

Oh, I have some multivitamins :)

I think my sense of smell is almost fully back now

Oof. I'm glad I at least don't have that, I hate sore throats.

that's what it started with :(

Yeah, same here ;)

Get well soon :)

Not too soon :P The reduced appetite is a great way of losing some weight XD

@Tinkeringbell :D

Ooh, nice! Just emptied the mail box, and there's something from the municipality that lets you order some energy saving stuff, and get a refund for half of it. klik-aan-klik-uit here I come XD

Anyone good at calculating how much wattage you need for a 'stekkerdoos'? XD

I can't say i know what a stekkerdoos is haha

umm... it's not the power strip that draws power, it's what you connect to it

and that's just adding up what's on the stickers

and staying below what the sticker on the power strip mentions is its max

@MiG Yeah, so a thing has a max of 2300 watt. I think I should be fine because whenever I have turned on everything on that strip, it doesn't use more than 2.3 kWh (an hour)? :P

I don't have stickers to add up XD That's too much work XD

It's basically TV, Nintendo Switch doc, and the receiver for the TV.

(And the Sonos sound bar)

kWh = a measure of energy (so power over time), kW is a measure of power - only the second one matters here

prob just fine, only things with heating or cooling elements in them draw loads of power

like the water heater, AC unit, electric stove, iron, hair curler etc etc etc

Yeah, I've basically read that if you have an appliance that draws 1000W, it should use 1kWh :P

I'm going to order it. If it blows, it was only half price :P

the maths is pretty hard to argue with here

Fingers crossed :)

It's ordered, now the webshop needs to hurry up and send me my receipts, so I can declare them and get half my money back!

Do you ever do that thing where you learn a smarter excel method to do a thing and you feel dumb for not thinking of it sooner?

Not really, I don't use Excel all that much XD

fair enough lol, do you ever have it with coding?

Yeah, sometimes. Mostly not feel dumb for not thinking of it sooner, but for not asking if there wasn't a better way sooner :)

now that is interesting

(It's usually not me that comes up with the way to do things smarter, so I can not feel dumb for not thinking of it sooner ;) )

@Tinkeringbell actually no

You measure for peak load with some other complex math

Yeah, dad said that math was wrong too? Most online calculators seem to suggest that's how it works though XD

He also said the power strip will work, so it's still ordered ;)

@Tinkeringbell if you measure one hour... how long doesn't matter for electric appliances, just what the power is (so Watt / kilowatt) - too much power through the power strip and it'll warm up (and if it's way too much it might cause a fire)

IKEA has pretty cheap ones that do 2300W, I got a bunch of those

@AlexRobinson not very often (I'm building models in excel so they tend to be pretty complex), but I do enjoy finding solutions to problems :)

what are you working on and what did you discover?

Funnily enough I just sent out a CO2 impact model to the JS of a European research fund :)

built it in google sheets first, then had to fix all the things that broke because of exporting to xlsx :/

@MiG actually no

It should blow a fuse or trip a breaker

They don't all come with those

......

and the fuse or breaker in the central fuse box tends to be rated higher, for example 3500W

so hooking up 2500W to a 1000W rated power strip will probably become aua

Uhhh oh yeah

Y'all didn't over engineer your sockets and wiring

sockets and wiring are fine, there's regulations for anything that goes into the wall

@JourneymanGeek Excuse me? I will let you know that I have 3-fase power here, which is by definition overengineered for a small apartment XD

it's the stuff people hook up to it, like a 1000W rated power strip, that may cause surprises when absentmindedly picked up years later and used for a curling iron or washing machine

@Tinkeringbell that's standard for the kitchen and wash room :)

@MiG No, it's not. A lot of people now get in trouble wanting it for their homes, with heat pumps and electric cooking, but it's nowhere near standard. The grid operator I work for can't even keep up with the requests for three phase electric power connections, due to a shortage of the appropriate smart meters and cables.

surprised to hear that, all the homes I've lived in so far came with them

this one as well, we have two in the wash room and one in the kitchen

The district attorney will point out the accused works for a grid operator and is confusing kWh with kW btw :P :P :P

@Tinkeringbell UK plugs are 13a 240W min, and we use 20A 240W plugs for some things....

@MiG just a tiny thing, but some data we have to do with dates is stored in a csv file and the "date" looks like 'dd-mm-yyyy hr:min:s UTC' and i came up with a simpler way to get it into a usable format compared to what i was doing

@MiG I can make sure no one draws a 10kV 3fase line connected to a 400V single phase one in their maps without having to know all the itty bits about Kw and KWh, and I'm not confusing the two... just wondering how to calculate back from kWh to W :P

@Tinkeringbell 1 Joule is 1 Watt per second :)

@AlexRobinson Isn't there an appropriate filter for that?

@JourneymanGeek I did some googling, and it's apparently usual for new homes to have 3fase power connections. Given that there are way fewer new homes than old ones here, I still maintain it's not 'standard' :P

I tried, but despite excel being famous for assuming things are dates that aren't... it is only happy calling it text

@Tinkeringbell define 'new'... I think the number of homes built after 1945 vastly outweigh the ones from before then :)

@AlexRobinson ah, there's functions that turn text into something else... What was your solution?

@MiG "Een woning wordt als nieuw beschouwd tot en met 31 december van het tweede jaar dat volgt op het jaar van de eerste ingebruikname van de woning: bv. als een woning voor het eerst bewoond werd op 14 februari 2016, dan is er nog sprake van nieuwbouw tot en met 31 december 2018."

There, a definition of new!

and if the length is fixed you can always macgyver a few LEFT() and RIGHT() together and separate those into columns

@Tinkeringbell a definition of new yeah :P

I'm wondering what year three phase connectors became common :)

The legal definition of new! :D

@MiG thats what i was doing initially, but i discovered the "datevalue" function so i can just LEFT the ddmmyyyy and datevalue it rather than cutting it back and forth

@Tinkeringbell :rolleyes:

@AlexRobinson ah yes, that one :)

my default modus operandi after adding a number of helper columns is usually "this is ridiculously complex" or "this breaks a lot", and then I start googling... end up on SE as well sometimes :)

I like smoothly operating models, added some fault detection to the JS one above that lights up cells that don't contain formulas but values for example

surprisingly those survived the conversion from google sheets to xlsx

i still get thrown on occasion with the small differences with google sheets and xslx - like when you press enter on a cell

it's really efficient working together on the same document though - I was adding functionality and fixing stuff, and a colleague in the UK was doublechecking and updating all the input data - I started out in excel, moved to google docs for that reason and then exported again for submission (and then went on to fix the conversion errors) - but it wouldn't have been done in time otherwise

i love google sheets, especially as it is free to use and super easily accessible

I used it with some friends to keep a variety of DnD related documents up to date

well, it's great for research collaboration too

just gotta make sure you don't include GDPR and other sensitive data, it's google after all and hosted in the US

Oh i'm sure there are far better uses than my silly spreadsheets that are largely for sharing gaming related information... but as someone who doesn't do research i still love the functionality

yep, same

I get that GDPR is a really good thing but it is a headache sometimes

definitely still things that break, had to find a workaround for conditional formatting that relied on an array on a different tab for example... easily done in excel in contrast

@AlexRobinson I'm happy with it - from a research perspective yes it's a pain, but at the end of the day it's not my data, so it's also my responsibility to take good care of it

and it's a blanket thing, so it applies to the facebooks and the googles of this world just as much (and there I'm even more happy with GDPR)

I get you, and i certainly agree for social media etc even though i don't really use it

I think i'm gonna round up and say i'm done with work for the day, it was nice talking and i'll see you around :)

o7

FML... I ordered that power strip and a few more things this afternoon because the municipality offered a cashback (it specifically mentioned energy saving power strips and single plugs that you can turn off as covered)... I went to fill in the form, and they have no section for 'energy saving power strips'. They have for all the other categories mentioned as covered by that cashback policy... but not the power strips/plugs.

I guess that means the order will have to be returned to sender ._.

Or the form is buggy, fingers crossed it's just the form. I sent an e-mail, I hope to get a reply fast or I will probably have to make a ... shudder ... phone call ... tomorrow.

you don't like phone calls? :)

Not much, no. There's always something that doesn't go according to plan, most often I come up with more questions/remarks right after hanging up XD