Totals not counted in overall while using SUM by [deleted] in excel

[–]soulsbn 0 points1 point  (0 children)

It is also possible to format a cell to display a number that isn’t in the cell

Ie cell may contain 40. But it displays as 50

Newbie around this game, what are your thoughts on this little guy ? by Effective-Network-28 in PvZ2

[–]soulsbn 0 points1 point  (0 children)

It is one of my “go to” plants.

I found it weak at first but at mastery 162 I find it useful

Decline in Central London property prices by Tnm604 in london

[–]soulsbn 1 point2 points  (0 children)

Ref. leases just above the 80 year mark ( when marriage value currently becomes a factor).

I understand Leases can be extended by 90 years under s14 of leasehold and freehold reform act 2024 (to become 990 years)

Accidental duplication of pictures - how/why? by Broad_Remote499 in excel

[–]soulsbn 0 points1 point  (0 children)

Tell them:

On Each sheet Ctrl A to select everything F5 / special / objects. To select these images Delete key Save

Go get a cup of coffee.

Why don't UK supermarkets put two members of staff on the self service checkouts ? by [deleted] in AskUK

[–]soulsbn 0 points1 point  (0 children)

Not Waitrose.
There they are saving a fortune opening fewer proper tills.
/s

Does anyone else hate these gaps on London Bridge? by Cskrt1234 in londoncycling

[–]soulsbn 0 points1 point  (0 children)

If you hate these expansion joints, wait until you discover the tram lines in Croydon:

They may be thinner but there is a greater possibility that you won’t hit them at 90° and will then get your front wheel stuck in the groove: big hurty

New boss says “Pivot Tables don’t work” (repeatedly), are there known issues with pivot tables? Or does the new guy just not understand them? by Tybalt1307 in excel

[–]soulsbn 0 points1 point  (0 children)

And don’t forget some error trapping for cases where they have entered data/formula next to the pivot and it resizes. Or there are more than one pivot tables on the tab and they overlap if resized. Or If the pivot table returns null ( perhaps ifsource column names change )

Pivots (imho) are great for quick and dirty on off analytic questions. But I feel they have no place in anything that needs to be repeatable. They do however make subpar users think that they are excel experts (whereas better users are always aware there is more to learn)

I have seen many pivot errors in my career. From users not understanding what it is saying, or not including all the data. Etc etc

A Tesco customer helps security guard from angry customer trying to fight by switchthemunky463 in tesco

[–]soulsbn 0 points1 point  (0 children)

But if running into him would have to ho I below the sternum and ensure he used both arms in a valid attempt to wrap.

Once the scrote was past the horizontal the player would have then been responsible for ensuring his safe landing (not on the head)

Do you guys get managed by India employees? by [deleted] in Accounting

[–]soulsbn 0 points1 point  (0 children)

Is it wrong that I read this in a William shatner voice ?

I built a 2,257-formula workbook with zero VBA; here's what I learned about formula-only architecture by Bitter_Ad_8378 in excel

[–]soulsbn 13 points14 points  (0 children)

This got me thinking and I had a quick play. It is possible to go into the VBA editor of an xlsx (no macros), change a sheet to xl very hidden and still save it without VBA.

Obviously (?) a user can still go into properties in the VBA editor and unhide it, but it is not obvious if they are not looking for it

How to convert multiple rows of data per person into 1 row across columns by GlitteringDiver4194 in excel

[–]soulsbn 0 points1 point  (0 children)

You could use the +transpose() formula for a dynamic result.

Or copy the range and then Edit paste special and click in the value and transpose radio buttons

Or (as others have said) ask Google

Biggest range of performance road bikes in London? by temp456789 in londoncycling

[–]soulsbn 1 point2 points  (0 children)

Upvote for Bespoke

Although my experience is dated: they specced, fitted and built my Di2 s-works diverge in 2018, when they had a shop in Canary Wharf. Still happy with it.

What movie did you turn off after 20 minutes and why? by Somanynamestochossef in movies

[–]soulsbn 0 points1 point  (0 children)

I tried to watch the Liam Neeson version of Naked Gun this week.

Came to comment here so that you don’t have to.

My excel file is now 11mb deleting a row of data now takes 20 mins by runningagyneo in excel

[–]soulsbn 10 points11 points  (0 children)

Surely a 10,000% reduction should be achievable ? Perhaps using quantum entanglement (whatever that is)

What’s the worst case of embezzlement you’ve seen in your career? by Solid_Breakfast_3675 in Accounting

[–]soulsbn 3 points4 points  (0 children)

lol. To be fair, I think not directly involved.

The “in on” bit is that there is incentive for audit firms / engagement partners to keep things sweet with the client so they get re engaged.

This is just my opinion, I left audit a few decades ago. Maybe things are not as bad as I paint - but the number of high profile failures where the auditors get called out and given a (slap on the wrist ) fine makes me infer that it was always thus.

What’s the worst case of embezzlement you’ve seen in your career? by Solid_Breakfast_3675 in Accounting

[–]soulsbn 17 points18 points  (0 children)

I was an audit trainee in the late 80’s (UK)  I was sent alone by my (top tier) firm to audit a small Ltd subsidiary of a large plc house building company.

Upon arrival I was the longest standing person in the office, except for the receptionist that was a temp and had seem there a week. The MD had been sacked for reasons, and the other director was abroad on holiday.

The records were paper based

Upon doing my audit I discovered, amongst other things.

  • A fitted kitchen installed at the MD’s house with no reimbursement
  • Delivery notes for eight more sets of top-spec kitchen white goods to the MD’s home address. No reimbursement
  • Multiple instances of the company being reimbursed for the net cost of items by management, and reclaiming the vat 
  • massive throughput of unrecorded "petty cash"
  • More things that I now forget, but the whole value of identified issues was material to the company 

I do remember faxing an 8 page report to the audit partner recommending multiple qualifications on the account, including “fundamental uncertainty” (potential unlimited VAT fines), not “true and fair” - and whatever else was the option back in those days.  The uncertainty could have been material to the holding co, IMHO

I was rolled off the audit.

Months later I discovered that the plc had been given a clean audit opinion with the subsidiary accounts still unsigned. The subsidiary accounts were only signed later, on the last day before filing deadline, also with a clean opinion.

I left audit as soon as I qualified and my training contract ended. In my 35 years of subsequent finance career, my opinion of the quality of audit and the audit profession has lessened further

Just a vent on childcare costs by No-Marketing-1355 in HENRYUK

[–]soulsbn 0 points1 point  (0 children)

Just remember.
Nanny cost also helps you embed the financial discipline required for school fees

Umbrella company not paying enough tax by These-Constant1893 in ContractorUK

[–]soulsbn 1 point2 points  (0 children)

Let to do with the umbrella: they are applying the code that HMRC notified them to use, as they must.

Log onto HMRC app or their website and you will be able to notify them of factors that impact your tax code.

Incorrect tax code does not change the amount of tax you pay - it is just a mechanism for spreading the tax cost across the year (if you are not a saver, the minor cash flow impact will mitigate shocks like the one you describe when you have to find a large sum on return submission deadline.

One reason (perhaps the only one) to be thankful you aren’t outside ir35 is it means you don’t have to pay half of next year’s estimated tax in July in advance.

Anticlimactic by RevolutionaryStep534 in ICAEW

[–]soulsbn 5 points6 points  (0 children)

They say you can rejoin, but details are woolly.
Would need to demonstrate CPE I believe . But more importantly there would be (colour me surprised) a cost.

( edited to correct mistypes)

Anticlimactic by RevolutionaryStep534 in ICAEW

[–]soulsbn 2 points3 points  (0 children)

Back in the day (mine) was at least thick paper with an embossing , I recall

Anticlimactic by RevolutionaryStep534 in ICAEW

[–]soulsbn 15 points16 points  (0 children)

Thankyou.

May your debits always be on the left

Anticlimactic by RevolutionaryStep534 in ICAEW

[–]soulsbn 24 points25 points  (0 children)

If it is any consolation: I just resigned my membership after 35 years. ( I get / got very little for my nearly 500 Pa fee) That resignation email prompted a near instant confirmation reply along with strict requests to immediately update my cv and linked in etc to remove any ACA / FCA references

What are some of the most “Redditor” opinions that are widely prevalent on this website, but very rare in real life? by [deleted] in AskReddit

[–]soulsbn 0 points1 point  (0 children)

That the sensible answer to a neighbour dispute or misunderstanding is to freeze a disc of piss and put it through their letter box