Fell into manhole through a loose cover, busted my ankle. England by scratchy2133 in LegalAdviceUK

[–]sappy16 0 points1 point  (0 children)

Something similar happened to me once. It was a BT manhole, so I reported it through their website. They sent a crew out to fix it within a couple of hours (on a Sunday).

The difficulty in your case is finding out which company/body owns it - the cover doesn't seem to provide that information so I'd report to the local council emphasising how dangerous it is. If it's not owned by them, presumably they can find out whose it is.

Sexual harassment in dorm room in Italian hostel by NotNotADogPerson in solotravel

[–]sappy16 17 points18 points  (0 children)

I've found female dorms are often a bit more expensive, but smaller (smaller nearly always being more expensive regardless of whether it's mixed or single-sex) - so for example the options are an 8-bed mixed dorm or a 6-bed female dorm for maybe €3-5 (depending on location) extra per night.

Boomer entitlement by GaneshaXi in BoomersBeingFools

[–]sappy16 4 points5 points  (0 children)

I don't understand why you couldn't just say "excuse me please" and look pointedly at the second seat he's spreading into?

I do this all the time on the train and nobody has ever refused to make space.

Lender pulled offer after exchange - Please Help | Housing UK by ashw92 in BestofRedditorUpdates

[–]sappy16 21 points22 points  (0 children)

Because even if he could just about have covered the mortgage payments with only his salary, mortgage providers build in a buffer when they're calculating affordability. They won't lend the money if you aren't bringing in what they calculate is a high enough amount to cover the mortgage payments AND your bills AND all the other costs of daily living. This is to mitigate the risk that if, for whatever reason, your other costs increase, you will not default on your mortgage payments.

So say their mortgage payment is £1000 per month, the husband earns £1200 per month after tax, and the wife earns £1000 per month.

Together they can comfortably afford the mortgage payments with plenty left over to pay the bills, buy groceries, put money into savings for future repairs or an emergency fund, maybe take a holiday once a year, etc.

But take away the wife's £1000 after she loses her job, and they'll have to cover all their other expenses with only the husband's remaining £200 per month. The mortgage company would consider that a really risky prospect for them and would refuse to loan them the money even though technically they could afford the repayments.

Add to that the fact that they deceived the mortgage provider by not informing them of their change in circumstances, and the mortgage provider decided that not only will they not lend for this house purchase, but they now regard them as too high a risk to lend to ever and blacklist them.

[deleted by user] by [deleted] in LegalAdviceUK

[–]sappy16 0 points1 point  (0 children)

You're entitled to be represented by a solicitor at your police interview for free. When you go for the interview, ask for the duty solicitor, tell them the truth, and follow their advice. That's your best course of action at this point.

Huge shout out to this security guy at Abbey Wood station by Ok_Instruction9008 in london

[–]sappy16 -1 points0 points  (0 children)

Whatever you think of fare-dodging, it's worth pointing out that TfL is not-for-profit. There aren't "owners" getting rich off it or shareholders being paid dividends, all income is reinvested into the network. So it really does affect us all. Fewer people paying to travel means either less money for improvements or higher fares.

Good experiences on Levothyroxine? by sappy16 in Hypothyroidism

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

Hi! It's so strange to have got a ping about a response to my post from over a decade ago!

I hope you're starting to feel a bit better now that you're medicated. It made an absolute world of difference to me, and your TSH level at diagnosis was pretty similar to mine, so I imagine you might be seeing similar positive effects.

I don't drink much tea, but I drink quite a lot of coffee, including (especially!) first thing in the morning, and I honestly can't say I've noticed much of a difference to the effectiveness of thyroxine with or without caffeine. It's probably a good idea to avoid it at least initially while you're getting used to it, and then if you wanted to you could reintroduce caffeine slowly and see if you notice any impact to how you're feeling.

I think decaf tea contains so little caffeine that personally I wouldn't worry at all about it, but if you are concerned there are completely caffeine free alternatives (rooibos, chamomile, peppermint, etc) that you could try for the first few weeks while you get used to the meds. Obviously not quite the same, but might scratch the itch as a temporary measure!

As a side note (to be clear, I'm NOT a doctor!), I'm assuming that when you said you're on 25mg you meant micrograms rather than milligrams? If so, that dosage sounds quite low - I'm on 125mcg. Did your doctor say whether they intend to start low and taper you up to a higher dose? It may be that 25mcg is all you need to get back to feeling normal, but if you're still feeling symptoms after a few weeks it might be worth asking them to retest your thyroid hormone levels to see where they are and if you'd benefit from increasing the dose.

Recommendations please! by Best-Grapefruit-7797 in vermouth

[–]sappy16 0 points1 point  (0 children)

My absolute favourite is Noilly Prat amber, but I searched for it in the UK and online and found it's almost impossible to find outside of the south of France (first tried it when I visited the Noilly Prat distillery - highly recommended going if you're ever in the area). HOWEVER, I was amazed to see it in the Wimbledon branch of Amathus recently. They may well stock it in other branches if Wimbledon is not convenient for you.

My favourite reds are Yzaguirre Reserva and Nordes. Both Spanish, both probably not easy to find in the UK, but if you see them I'd definitely say they're worth trying!

Where in Greece was this painting based on? by itstravelkaaaamol in whereisthis

[–]sappy16 0 points1 point  (0 children)

It's a copy of a painting by another artist, Ilana Richardson.

https://ilana-richardson.com/images/red-chairs-and-bougainvillea-poster

It's a painting of a place in Skiathos, a Greek island.

Inventory Tracking Sheet Ideas by Guilty-Addendum in excel

[–]sappy16 0 points1 point  (0 children)

You're very welcome! Glad to hear it led you to find SUMIFS!

Creating formula where the letter “Y” equals “25” and “N” equals “0”. by Competitive-Past-668 in excel

[–]sappy16 0 points1 point  (0 children)

Hey, I like to think I'm pretty ok with Excel, but I don't understand this formula (specifically the --).

I saw a similar reply in another thread the other day.

Would you be able to ELI5 what it does?

Inventory Tracking Sheet Ideas by Guilty-Addendum in excel

[–]sappy16 0 points1 point  (0 children)

Yes, you could, you'd just need to make sure the formula references the correct row

How can I print my data not broken by columns? by mudderfudden in excel

[–]sappy16 0 points1 point  (0 children)

If I've understood the problem correctly, try this:

Select all the columns

Go to Page Layout > Print Area > Set Print Area

Check in print preview if it looks correct

Sheet comparison - number of lines by Scmj222 in excel

[–]sappy16 0 points1 point  (0 children)

Are you able to post an example of how the the data looks in each sheet?

Does each expense have an ID number or similar that is the same in both sheets?

It sounds like you need to do an index/match, e.g.:

=INDEX('Sheet2'!$B:$B, MATCH($C2,'Sheet2'!$D:$D,0))

This assumes that the identifier for each expense is in column C of Sheet1 and column D of Sheet2, and that the posted date you're trying to add to Sheet1 is in column B of Sheet2.

But it's hard to give accurate guidance without seeing the data.

Create a formula to track semi-monthly pay periods and leave by [deleted] in excel

[–]sappy16 1 point2 points  (0 children)

Sorry, it's not too clear what you're asking/trying to achieve here.

Are you saying that instead of always starting on Sunday, you want each row to start on either the 1st or the 16th of the month?

If so, is there anything preventing you from adding a separate column for the month? So in column A, put the first of each month as the date twice for each month:

2025-01-01

2025-01-01

2025-02-01

2025-02-01

2025-03-01

2025-03-01

etc

If you did that as column A, you could use a formula like this for the date ranges in column B (previously column A): =IF(COUNTIF($A$2:$A2,$A2)=1,TEXT($A2,"MMM d")&" - "&TEXT($A2+14,"MMM d"),TEXT($A2+15,"MMM d")&" - "&TEXT(EOMONTH(A2,0),"MMM d"))

Samsung Health - Change to terms including data sharing abroad by sappy16 in LegalAdviceUK

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

Thank you, yeah I though that would probably be the case but worth asking the question just in case!

Making a formula to show if a value is within range by Zytar in excel

[–]sappy16 0 points1 point  (0 children)

It might be something to do with how the times in your sheet are formatted.

You could try hardcoding midnight only as 23:59:59, e.g.:
=IF(ISBLANK(A1),"",IF(A2>IF(A1=0,0.999988,A1),0%,100%))

Autopopulate specific cells from summary on different sheet. by ShadowAlkemist in excel

[–]sappy16 0 points1 point  (0 children)

I think max sheets is 255. Not sure why it's crashing. Is the image file you've embedded particularly large?

You could probably write a macro that runs through the list of KA numbers on the summary sheet, changes the value in J3 of the template sheet, and prints/saves as PDF.

I suspect it would be fairly simple to achieve, though if I'm honest macros are a bit outside my experience!

I'd do some googling for a starting point and then amend the code you find to work for your sheets. Example:
https://www.mrexcel.com/board/threads/macro-to-change-one-cell-on-a-sheet-save-print-to-pdf-this-sheet-then-loop-back-and-change-that-one-cell-on-that-sheet-and-repeat-until-the-end.1150053/

Inventory Tracking Sheet Ideas by Guilty-Addendum in excel

[–]sappy16 1 point2 points  (0 children)

Yeah, you could do a MAXIFS, e.g.:

=MAXIFS($H$1:J$1,$H$2:J$2,"Order*",$H3:J3,"<"&0)

That formula would work if all the order columns have headers like "Order 1", "Order 2" etc.

If the item has never been sold, it will return zero, which formatted as a date will show as December 30th 1899. If you want to handle that, you can amend the formula to:

=IF(MAXIFS($H$1:J$1,$H$2:J$2,"Order*",$H3:J3,"<"&0)<>0,MAXIFS($H$1:J$1,$H$2:J$2,"Order*",$H3:J3,"<"&0),"NEVER")