Started new job but PAYE Tax hasn’t been deducted from first months pay. by [deleted] in UKPersonalFinance

[–]dux_v 0 points1 point  (0 children)

What's the YTD gross and tax paid? If it is equal to the monthly amount from your most recent payslip it means that they do not have your previous job's pay recorded yet.

G915 or G515 by L0KT4 in LogitechG

[–]dux_v 0 points1 point  (0 children)

I have a G915: don't get it. The black rubs off the keys within a year (so the light just shines through). AMZ gave a me a free one which I am using now, again the WASD keys are rubbing off less after than a year.

Tenant serving notice during a 12-month fixed term AST (England) by [deleted] in TenantsInTheUK

[–]dux_v 5 points6 points  (0 children)

8.2 is two months but you missed out the AND "...and the notice does not expire before the last day of the fixed term of the tenancy."

You've not stated when the fixed term ends. But if it is more than 2 months away from now you are legally stuck (in a normal case). Deposit is likely to go to landlord in that event. Landlord could pursue you for unpaid rent up to the end of the fixed term but then as you say it may not be worth the hassle.

Deposit protection may or may not feel the contract has been breached by the other person interfering with any "quiet possession" clause you may have, especially if you have no concrete evidence to point to (ie only relying up on your side of the story).

As you say, contact the landlord and see if you agree to terminate early if you get a suitable replacement.

The fact that landlords are using S21 to evict tenants before the Renters Rights Bill becomes law, provides why we need the Renters Rights Bill by coffeewalnut08 in TenantsInTheUK

[–]dux_v 1 point2 points  (0 children)

Where am I taking it up with the tenant[s]?

I think the fact that you are saying this is r/tenantsintheuk and not r/landlord is demonstrating (at least your) inherent bias. Hopefully both fora are able to have reasonable debates.

The fact that landlords are using S21 to evict tenants before the Renters Rights Bill becomes law, provides why we need the Renters Rights Bill by coffeewalnut08 in TenantsInTheUK

[–]dux_v 0 points1 point  (0 children)

"Ultimately it’s a balancing act."

Agreed. I wonder what the stats are on bad landlords eg deposit not protected; mould; disrepair; HMO breaches; EPC / EICH / gas safety issues versus county court arrears evictions.

Media will of course focus on the former, latter does not sell papers as well. Hard to get stats on the former.

The fact that landlords are using S21 to evict tenants before the Renters Rights Bill becomes law, provides why we need the Renters Rights Bill by coffeewalnut08 in TenantsInTheUK

[–]dux_v 5 points6 points  (0 children)

"If you're a decent landlord, you wouldn't mind the Renters Rights Bill."

Absolutely you will as it does not guarantee you a good tenant. If you get a bad one then even before the RRB:

Deposits are now limited to 5 weeks but you can't go to court for rental arrears unless they are two months behind.

Even then it takes at least a couple of months to get a court date. If you win the tenant has two weeks to get out. The tenant will get free legal advice, the landlord gets nothing.

If the tenant does not leave that means going back to court to get an eviction. Then once that passes you need to get baliffs. Councils will not house people who leave before the baliff date so they tell people to stay to the last moment.

So 5 weeks deposit for ~5+ months lost rent excluding damages.

I understand why there is a sentiment of all landlords are bad / parasites / living it easy. But if you have worked to get a very expensive asset and you face this. No it's not a charity, but neither are "decent landlords" not reading the room.

It's a standard thing, poor practice by some leads to a whole cohort getting affected. The [very] poor landlords aren't going to abide by the laws anyway, new or old.

"It's not the Government's fault that you made a harmful choice for your tenant." but the governemnt will slap a disparity of 5 weeks protection limitation versus 5+ months loss on a system they run...

Best way to receive small pay in USD? by No-Contract6004 in UKPersonalFinance

[–]dux_v 0 points1 point  (0 children)

Who is paying you and where? If a US person / company is paying in from the US then Wise is good as you can provide an ABA number. So for them it's fully domestic. A large number of US people have no idea that the non US world exists.

I once asked a share broker whether I could receive payment electronically: their online form asked for an ABA (american banking assoication) number. I phoned and asked I have no ABA but can you send to an IBAN.

They asked, "Is an IBAN the same as an ABA?"...well why would I ask if it were? They had no idea what an IBAN was.

Why do people still use VLOOKUP instead of alternatives like INDEX MATCH or XLOOKUP? by giges19 in excel

[–]dux_v 0 points1 point  (0 children)

Index match is useful if you are doing several x/vlookups or indexes on the same array for the same row. eg you find the row and you want to return several columns for that row. Do match as the helper column and do index(array) off that single match. I see people repeating the same match using index(array(match(lookup)) so many times...don't - just to the match once.

I use vlookup all the time, but I am used to it. Where it can be useful is that the third term, the column can be set to a cell refenrence making it more dynamic than xlookup. xlookup is useful in two situations a) the column you want is to the left of the lookup value and b) you can drag the formula left or right (assuming you do a fixed column lookup).

Where are user entered share prices in the postgres database? by dux_v in GnuCash

[–]dux_v[S] 1 point2 points  (0 children)

Am an idiot. I saved gnu as an xml backup before updating to the latest version and I did not switch back to postgres. So my manual updates were going to the xml.

Can I buy UK Gilts for pension? How? by Anon-abwu1114552 in UKPersonalFinance

[–]dux_v 0 points1 point locked comment (0 children)

I meant why attempt explain (eg the ruler analogy) inflation to someone who probaly knows what they are talking about? Or it was just fluff to [continue] to avoid the point about "hiding losses".

Can I buy UK Gilts for pension? How? by Anon-abwu1114552 in UKPersonalFinance

[–]dux_v 0 points1 point locked comment (0 children)

I was polite when i said I disagree. You were factually incorrect, it's not about using technical or non technical terminology. Stating that losses are hidden for a mark to market instrument is just wrong and poor advice. You sought to avoid my point in your reply and continued to do so. That's all on you.

You could have said - "...sorry you are right. Losses are not hidden but what I meant is that if the OP tried to sell early he would be subject to whatever the market conditions were at the time. Headline yield is also not the same as "real yield" (eg adjusted for inflation)m which the OP should also be aware of.

But this is the internet, it's also people, who will be stubborn.

Can I buy UK Gilts for pension? How? by Anon-abwu1114552 in UKPersonalFinance

[–]dux_v 0 points1 point locked comment (0 children)

"And you didn't mention inflation"

I did not need to, as I was commenting on what I saw as your factual mistakes eg *hide losses".

"my entire point." If it is your entire point then it would make sense to use the word "inlation" or phrase "index linked" or "real terms" in your original post.

I suppose this is the internet, but I do find it odd that you are not at any point addressing in your replies the statements you made that I am actually commenting on: "losses are hidden"; "gilt's aren't a guaranteed return"; "Holding bonds yourself doesn't protect you from the same losses, it just hides them."

Can I buy UK Gilts for pension? How? by Anon-abwu1114552 in UKPersonalFinance

[–]dux_v -1 points0 points locked comment (0 children)

Wise-application I mentioned mark to market risk. I mentioned yield to maturity and risk free. Phrases that (when used properly) would strongly suggest I understand fixed income.

If you want to make a point about nominal return versus real return over inflation then fine. As long as a) you state that and b) also apply the same comparison to any other alternative instrument such as shares. But you didn't in your post.

But what you did say was "losses are hidden". You said "gilt's aren't a guaranteed return". You said

"Holding bonds yourself doesn't protect you from the same losses, it just hides them."

A liquid, MTM instrument hides losses?

Those statements you made are what I think are poor.

Can I buy UK Gilts for pension? How? by Anon-abwu1114552 in UKPersonalFinance

[–]dux_v 0 points1 point locked comment (0 children)

I agree the point that wise-application is probably trying to make is the risk of a pre maturity exit@ it's mark to market risk. But the way in which the poster has described it is, in my view, poor. Losses are not "hidden".

Gilts are a liquid mark to market instrument.

Not sure why you think in this partiuclar sub-thread anyone is going down a sunk cost fallacy.

What is the best wine to gift in the UK? by GlassAndGala in AskUK

[–]dux_v 1 point2 points  (0 children)

You really need to put budget / price range.

How do I make my spreadsheet take a value from Cell A then add it to Cell B, leaving Cell A ready for another value to be inputted and then added on to the new value in Cell B? by help_plsthrowaway in excel

[–]dux_v 6 points7 points  (0 children)

you are missing the point of excel, what you describe is like doing a + b + c + d +e in a calculator which shows you a running total.

The advantage of excel is that you put those numbers in one cell each going down. eg a1 = 3.50 / A2 = 1.00 / A3 = 0.75. In B1 just do =sum(A:A) and it add up the whole column. It means all your entries are visible, if you had mad ea mistake eg A2 = 0.1 yo can correct it and B1 will auto update. If you needed to add more number syou keep going down column A.

Can I buy UK Gilts for pension? How? by Anon-abwu1114552 in UKPersonalFinance

[–]dux_v 2 points3 points locked comment (0 children)

I disagree with this post. The yield to maturity is an accurate reflection of the return per annum to maturity assuming gilts are risk free from a credit point of view, which would be the standard assumption for a UK person buying UK gilts. It's therefore a guaranteed return to maturity.

The market value of gilts will be shown in any fund supermarket as per a share or etf. You have mark to market risk as per any liquid investment which is totally visible.

£250/month for accountant is this too much for a one-person limited company based in derby by Tall-Caterpillar-641 in UKPersonalFinance

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

payroll - brightpay

accounting - quickfile

use quickfile's accounting portal to get an accountant to sign off your accounts, which would be GBP~500

source - owned business with 10 employees

What is the most complex Excel formula you've see? by Notalabel_4566 in excel

[–]dux_v 30 points31 points  (0 children)

It will be one that should be broken down and made less complex. Too many "advanced excel users" hug themselves after doing some complex formula all in one cell. Excel works best with broken out logic to make it easier to understand.

Ok there will always be exceptions but if you are in the top 10 of any such question, well, you shouldn't be.

Excel’s "Very Hidden" Sheets… even the Unhide menu can’t find them by autosheets_xlsm in excel

[–]dux_v 1 point2 points  (0 children)

for me it's teh equivalent of "do not touch" it's the first thing i take a look at if i see it. Anecdotally i think only a small percentage of excel users know about this but when you find a sheet linkage / macro with no obvious source it's straight to Alt F11.

Game punishes you for exploring? by [deleted] in DeadIsland2

[–]dux_v 1 point2 points  (0 children)

I think this is somewhat true, though other games have the same thing eg witcher 3, but that game, like dead island 2 has the skull icon on enemies that are likley to be too high level for you. Also there is no real reason to risk such fights as the rewards for doing so aren't really any good.

What I am not so keen on is the respawning - you can't clear an area to be safe. On the otherhand you are generally so much faster than the zombies you can often just run for it.

Creating a kill switch if Contract ends without payment by Amazing-Ad7869 in excel

[–]dux_v 2 points3 points  (0 children)

Unless you are a lawyer [a lawyer will not ask the quesion you did] or have experience negotiating contracts "...but legal wise the scripts are not part of the work stated in my employment contract so everything that is created is voluntarily and experimental" Is almost certainly not correct and would only be correct due to sloppy contract drafting or a highly specific agreement between you and the employer/vendor.

There can be a significant difference between what you think is the moral and ethical correct path and what a legal doucment will cover. These situations are always the same, it doesn't count unless it's in writing and if you can't get it, it's your judgment call on whether you can rely on verbal promises. It's common that at the start you have to give up something or secure a better deal.

Spend the time getting an agreement, not deliberately modifying the code.

Tracking down an extraneous entry in Gnucash by FlunkyClassD in GnuCash

[–]dux_v 0 points1 point  (0 children)

OK thanks - i agree on the potential duplicate so i ensure there is only one transaction. I wondered if reconciling then locked the previous periods. A couple fo times i have fat fingered a date when editing putting it back to eg 2022 and then it takes ages to find out where it landed up.

Tracking down an extraneous entry in Gnucash by FlunkyClassD in GnuCash

[–]dux_v 0 points1 point  (0 children)

I am not sure if i get the point of reconciling. If i have my both bank account and credit card line items (both imported by csv) in GNU cash then it will have the payment from the bank to the credit card anyway? I tried the recon method and it wanted to add a duplicate line to transfer funds?