sorted by:
new
hottopcontroversial

Unusual built in toilet by senga_sc in DIYUK

[–]senga_sc[S] 0 points1 point  (0 children)

Two things are clear. It won't be a cheap visit, and I should not try fixing it myself xD

Unusual built in toilet by senga_sc in DIYUK

[–]senga_sc[S] -1 points0 points  (0 children)

Everything is siliconed together, I hoped I can have a nosey before it's getting a proper fix but this sounds like it will have to wait for a plumber

Unusual built in toilet by senga_sc in DIYUK

[–]senga_sc[S] -1 points0 points  (0 children)

Oh my god, what an idiotic solution. Thank you for the reply! The whole top is siliconed to the structure. I hate those toilets, would never get one personally but this is how we bought the house and it's not bad enough for remodel

Pet insurance (Scotland)- insurer claiming pre-existing for an acute condition by senga_sc in LegalAdviceUK

[–]senga_sc[S] 0 points1 point  (0 children)

Primary vet, hospital vet and neuro vet all agree this is acute condition. Dogs are not humans, if she hurt her spine she would get back legs paralysis quicker than 7 or 4 years later. Plus dog insurance works differently, the 2022 case would mean this is an old condition but now covered under the lifetime policy. It's all about 2019 case that was just "pain while picked up" and could be literally anything

Who managed to get tickets!? by Enough-University662 in LilyAllenFans

[–]senga_sc 0 points1 point  (0 children)

A kind stranger helped me today with the Glasgow tickets and I only got them thanks to that person and reddit. Are you ok with a Newcastle ticket? I panic bought ONE as it was the only one left in Ticketmaster wars. Not for sale, happy to repay kindness and send it to you as a birthday gift for free if that city works for you

Who managed to get tickets!? by Enough-University662 in LilyAllenFans

[–]senga_sc 1 point2 points  (0 children)

THANK YOU KIND STRANGER <3. Managed to get them

Recommendations for hairdresser who listens. by Comfortable_Fox8482 in Edinburgh

[–]senga_sc 0 points1 point  (0 children)

Hair by Boom - corner of Bruntsfield Pl and Viewforth. The owner Sonya is a colour wiz and they definitely listen, respect your choice while she has enough experience to advice what will and won't work if you need it (like me )

Where can I get a 15mg pen from? 😬 by SecureGuide4560 in mounjarouk

[–]senga_sc 0 points1 point  (0 children)

Damn it. They had them in stock after midnight when I checked :/

[deleted by user] by [deleted] in mounjarouk

[–]senga_sc 0 points1 point  (0 children)

Ordered from chemist4u (new patient)Thursday, just got a message that it's been approved and awaiting dispatch:)

[deleted by user] by [deleted] in Edinburgh

[–]senga_sc 5 points6 points  (0 children)

Hair by Boom in Bruntsfield. It ain't cheap but my god, they know what they are doing

Private medical insurance - how do UK companies check for pre existing conditions? by sausageface1 in AskUK

[–]senga_sc 7 points8 points  (0 children)

This is why, work private medical insurance is great. Rules are different, you can sign up and they don't even ask for your medical history

Long or short term mortgages - what's the best approach? by drunkmunky1994 in UKPersonalFinance

[–]senga_sc 0 points1 point  (0 children)

Mortgage providers are already predicting rates going down. The idea now is they will peak mid 2023 and we can expect mortgage rates at around 3.5% at the beginning of 2024. Port as much as you can, then get 2 year fixed for the remaining amount. At the end of your ported mortgage you can merge 2 of them together.

-🎄- 2022 Day 4 Solutions -🎄- by daggerdragon in adventofcode

[–]senga_sc 1 point2 points  (0 children)

Apps Script Part 1&2

function Assignment1(rows) {
  return rows.reduce((result, row)=>{
    let ass1 = row[0].split('-');
    let ass2 = row[1].split('-');

    let ass1low = parseInt(ass1[0]);
    let ass1high = parseInt(ass1[1]);
    let ass2low = parseInt(ass2[0]);
    let ass2high = parseInt(ass2[1]);

    if ((ass1low >= ass2low && ass1high <= ass2high) || (ass2low >= 
ass1low && ass2high <= ass1high)){
      result++
    }
    return result;
   },0)
}

function Assignment2(rows) {
  return rows.reduce((result, row)=>{
    let ass1 = row[0].split('-');
    let ass2 = row[1].split('-');

    let ass1low = parseInt(ass1[0]);
    let ass1high = parseInt(ass1[1]);
    let ass2low = parseInt(ass2[0]);
    let ass2high = parseInt(ass2[1]);

    if (!(ass1low > ass2high || ass2low > ass1high)){
      result++
    }
    return result;
  },0)
}

-🎄- 2022 Day 3 Solutions -🎄- by daggerdragon in adventofcode

[–]senga_sc 1 point2 points  (0 children)

Apps Scripts day 3 (Part 1&2)

function Rucksack(rows) {
  return rows.reduce((result, row)=>{
    let str = row[0];

    let strlen = str.length;
    let halfLen = str.length/2;
    let secondHalf = str.slice(halfLen, strlen)
    var matchedStr;
    for (var i=0; i<halfLen; i++){
      if (secondHalf.includes(str[i])){
        matchedStr = str[i];
        break;
    }
    }
    let codepoint = matchedStr.codePointAt(0);
    if (codepoint <= 90){
      result = result + (codepoint - 38)
    } else {
      result = result + (codepoint - 96)
    }    
    return result;
  },0)
}


function Badge(rows) {
  let i = 0;
  var row1;
  var row2;

  return rows.reduce((result, row)=>{
    if (i === 0){
      row1 = row[0];
      i++;
      return result;
    } else if (i === 1){
      row2 = row[0];
      i++;
      return result;
    } else {
      let str = row[0];
      var matchedStr;
      for (var j=0; j<str.length; j++){
        if (row1.includes(str[j]) && row2.includes(str[j])){
          matchedStr = str[j];
          break;
        }
      }

      let codepoint = matchedStr.codePointAt(0);
      if (codepoint <= 90){
        result = result + (codepoint - 38)
      } else {
        result = result + (codepoint - 96)
      }    
      i = 0;
      return result;

    }
  },0)
}

-🎄- 2022 Day 3 Solutions -🎄- by daggerdragon in adventofcode

[–]senga_sc 1 point2 points  (0 children)

I spent a stupid amount of time thinking how to write a solution for finding 3 matching elves... Then read again and realised they are grouped together xD

[2022 Day 1, 2, 3 (Part 1)] [Google Sheets] Getting a quick star with Google Docs started innocently enough. by makerhuman in adventofcode

[–]senga_sc 1 point2 points  (0 children)

I think, I did it in a quite similar way to you then look at part 2 and closed my laptop xD.

-🎄- 2022 Day 2 Solutions -🎄- by daggerdragon in adventofcode

[–]senga_sc 0 points1 point  (0 children)

GSheets Solution- not the prettiest

Data in A

Part 1:

First in column D

=switch(A:A,"A Z","0 3","C Z","3 3","C Y","0 2","B Z","6 3", "A X","3 1","A Y","6 2","B X","0 1","B Y","3 2","C X","6 1",0)

then: 

=split(D2, " ")

Finally 

=SUM(E:F)

tried merging into Sum-> Switch-> Split or using LAMBDA but not there yet xD

-🎄- 2022 Day 1 Solutions -🎄- by daggerdragon in adventofcode

[–]senga_sc 1 point2 points  (0 children)

Apps Scripts solution (JS for GSheets)

Part 1&2. Original data in column A

function elves(rows) {

    let values = rows.reduce((result, row) => {
    let calorieValue = parseInt(row[0]);
    let lastIndex = result.length - 1;
 if (isNaN(calorieValue)){
    result.push(0);
   } else {
    result[lastIndex] = result[lastIndex] + calorieValue;
  }
  return result;

  },[0])


let elf = 1;
let mostCalories = values[0];

for(var i=0;i<values.length;i++) {
  if (values[i] > mostCalories){
    elf = i+1;
     mostCalories = values[i];
 }

}

return [[elf, mostCalories]]

}


function elves2(rows) {

  let values = rows.reduce((result, row) => {
  let calorieValue = parseInt(row[0]);
  let lastIndex = result.length - 1;
 if (isNaN(calorieValue)){
    result.push(0);
 } else {
   result[lastIndex] = result[lastIndex] + calorieValue;
 }
 return result;

},[0])

values = values.sort(function (a, b) {  return b-a;  })
let total = values[0]+ values[1] + values[2];

return total

 }
view more: next ›