Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.
Current status: https://keepboardsalive.com/
Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
If we do not hit our goal we will be forced to close the site.
Current status: https://keepboardsalive.com/
Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum
Private Group for paid up members of Boards.ie. Join the club.
Private Group for paid up members of Boards.ie. Join the club.
What the Loungers did Next... [off topic chat]
Comments
-
-
PhysiologyRocks wrote: »Teeth are gone - feeling great!
Only taking paracetamol and anti-inflammatories. They gave me some super-strong ones too, but I haven't needed them yet.
Hope all good with you guys!
Glad you're feeling well PR.I found a good website for online food diary keeping. It's got a lot of good tips.
Weigh2Live
Still feeling hunger pangs but I'm going to try to silence them with decaff green tea. Most likely I'm just thirsty. Bleh.
Would you consider doing a blog McChubbin? A couple of the ladies from the WW thread have them and use them as a sort of food diary.
Hope everyone's well 0 -
-
I thought that said bong
what!
:pac:
Stupid logic diagram I did missed out one possible scenario so I'd to trawl through my insanely nested if - statements to fix it up and count the brackets
hmph :mad:
Now I've to fix up the associating ones
Counting the brackets is easily the worst part, drives me insane
0 -
-
Advertisement
-
Counting the brackets is easily the worst part, drives me insane
=IF(Q169="","",IF(ISBLANK(VLOOKUP($B169,'name.xls'!$AD$2:$AQ$2250,14,0)),
IF(Q169<$BN$3,$BN$3,IF(Q169>$BN$3,IF(Q169=$D$3,"",
IF(ISBLANK(VLOOKUP($B169,'name.xls'!$AD$2:$AN$2250,11,0)),$D$3,
VLOOKUP($B169,'name.xls'!$AD$2:$AN$2250,11,0))),
IF(VLOOKUP($B169,'name.xls'!$AD$2:$AN$2250,11,0)>$BN$3,
VLOOKUP($B169,'name.xls'!$AD$2:$AN$2250,11,0),$D$3))),
IF(VLOOKUP($B169,'name.xls'!$AD$2:$AQ$2250,14,0)>$BN$3,
IF(Q169>=$BN$3,VLOOKUP($B169,'name.xls'!$AD$2:$AN$2250,11,0),$BN$3),
VLOOKUP($B169,'name.xls'!$AD$2:$AQ$2250,14,0))))
Ilyana that's great though! 0 -
-
=IF(Q169="","",IF(ISBLANK(VLOOKUP($B169,'name.xls'!$AD$2:$AQ$2250,14,0)),
IF(Q169<$BN$3,$BN$3,IF(Q169>$BN$3,IF(Q169=$D$3,"",
IF(ISBLANK(VLOOKUP($B169,'name.xls'!$AD$2:$AN$2250,11,0)),$D$3,
VLOOKUP($B169,'name.xls'!$AD$2:$AN$2250,11,0))),
IF(VLOOKUP($B169,'name.xls'!$AD$2:$AN$2250,11,0)>$BN$3,
VLOOKUP($B169,'name.xls'!$AD$2:$AN$2250,11,0),$D$3))),
IF(VLOOKUP($B169,'name.xls'!$AD$2:$AQ$2250,14,0)>$BN$3,
IF(Q169>=$BN$3,VLOOKUP($B169,'name.xls'!$AD$2:$AN$2250,11,0),$BN$3),
VLOOKUP($B169,'name.xls'!$AD$2:$AQ$2250,14,0))))
Ilyana that's great though!
Haha I miss working :P0 -
-
Give me Matlab/R/Python with Numpy any day of the week, fúck Excel. :pac:=IF(Q169="","",IF(ISBLANK(VLOOKUP($B169,'name.xls'!$AD$2:$AQ$2250,14,0)),
IF(Q169<$BN$3,$BN$3,IF(Q169>$BN$3,IF(Q169=$D$3,"",
IF(ISBLANK(VLOOKUP($B169,'name.xls'!$AD$2:$AN$2250,11,0)),$D$3,
VLOOKUP($B169,'name.xls'!$AD$2:$AN$2250,11,0))),
IF(VLOOKUP($B169,'name.xls'!$AD$2:$AN$2250,11,0)>$BN$3,
VLOOKUP($B169,'name.xls'!$AD$2:$AN$2250,11,0),$D$3))),
IF(VLOOKUP($B169,'name.xls'!$AD$2:$AQ$2250,14,0)>$BN$3,
IF(Q169>=$BN$3,VLOOKUP($B169,'name.xls'!$AD$2:$AN$2250,11,0),$BN$3),
VLOOKUP($B169,'name.xls'!$AD$2:$AQ$2250,14,0))))
Ilyana that's great though!0 -
Advertisement
-
angeldelight wrote: »Only one more sleep til I go on my holidays!! Yayyy! I see many many strawberry daiquiris in my future
0 -
angeldelight wrote: »Only one more sleep til I go on my holidays!! Yayyy! I see many many strawberry daiquiris in my future
Me too 0 -
-
-
-
-
-
-
-
-
Advertisement
-
Ah yeah I'm OK thanks. Luckily it was relatively low speed. I was going straight and she was coming from the opposite direction, waiting to turn right then moved into my path to turn so it was really me crashing into her(on my side of the road). I was going at about 30k at the time though. Luckily(?) it was a people carrier so the bonnet was higher and rather than going over it as I would have a smaller car I landed on it and slid to the ground. My face is a bit bashed up and I'm getting a bit achy now.
I'm meant to be doing a half Ironman at the weekend though 0 -
-
Ouch
Have a bath tonight if you can, to relax your muscles. Hopefully you won't need to see a doctor or anything! After I crashed my mum's car, I had a bath and a glass of wine to help me relax and I honestly think it helped!
Any excuse for a glass of wine :pac:0 -
-
Ilyana 2.0 wrote: »Any excuse for a glass of wine :pac:
A sentiment I can fully agree with :pac:
Will be cooking with wine later, of course a nice big glass of it with dinner too 0 -
RQ!
My god. I actually banned* Mike from cycling after the 3rd time he got hit. I really wasn't able for any more! He has terrible balance anyway so I don't think he was doing himself any favours by adding 2 wheels to himself.
*begged him to give up is probably more accurate.
When she sat me down my thoughts were ''crap, can't ring mum, she'll go ape''
It happened literally 2 minutes from where my sister lives and my bro in law doesn't work Tuesdays so I put the SOS in to them instead of waking my poor mother up with it. 7 months since the last time I was hit. Nightmare, I know she worries sick about me going out on the bike but it has to be done. Can't afford to run a car at the moment.lilmissprincess wrote: »Jesus RQ! Did the driver check you were okay?
Yeah she and another woman got out of their cars can ran over to me. I was lying on the ground and saw people running towards me and thought "sh*t better get up before someone calls an ambulance"
I'd just passed through a lollipop lady and the poor kids got an awful shock could hear one of them start to bawl crying. 0 -
hey everyone!
I've really lost track of this places, everything's moving so fast. just wanted you to know I'm still alive I've been posting a lot more on the Rock & Metal forum lately
any big news I missed out on?0 -
-
-
Advertisement
-
WHAT A DAY!
*breathes*
I'm absolutely bet into this office-y dress I'm wearing today It fitted me perfectly exactly 12 months ago... Life is after getting too cosy for me altogether!
RQ I hope you're ok after that ordeal - I'm terrified of cycling in urban areas! Too many drivers just don't seem to give a flying...0
https://www.youtube.com/watch?v=yZD4heGsPks
This discussion has been closed.
Advertisement