• 27 Posts
  • 1.18K Comments
Joined 2 years ago
cake
Cake day: July 12th, 2023

help-circle
  • Yeah it varies from one airport to another. It can also depends on layover time. In Hong Kong (on my way from Aus to Vietnam) I had to leave through customs to get to another part of the airport and enter through customs to get my connection. I was fingerprinted and facemapped both ways.

    If I had been leaving via a gate closer to where I arrived, I wouldn’t have had to do that.

    Similar happened when connecting in Kuala Lumpur where the layover was 9 hours due to typhoon and the airline forced me to leave the airport, allegedly to go to a hotel they comped me, but I doubled back and snuck into a closed off area where someone forgot to lock out an elevator to sleep for a bit. They force you to leave the airport so there are fewer people just milling about for hours.






  • ‘The soldiers had red eyes, and they were singing and dancing. They slaughtered the priest, cut him to pieces, removed his heart and liver and cooked them. The rest of the group had to pay money or eat the human flesh to be allowed to leave. Another four men, three women and three children were killed.’ Among the dead was a pregnant woman who was gutted.






  • I must find the monstrous function which indexes virtual arrays that I implemented in a Google sheet of mine when I discovered there’s no limit to how reckless you can be in a single cell.

    Edit: Here it is: ARRAYFORMULA(IFERROR((INDEX('Invoice History'!$A$7:$A$44, SMALL(IF(($G$3='Invoice History'!$D$7:$D$44)*('Invoice History'!$F$7:$F$44="Unpaid"), MATCH(ROW('Invoice History'!$A$7:$A$44), ROW('Invoice History'!$A$7:$A$44)), ""), ROW(A1))))))

    According to my documentation, it is used for “Looking up a value on a row, on another sheet, where two other values on that row match the given criteria”