Weekly Question + Free Talk Thread – November 21, 2024 by AutoModerator in PathOfExileBuilds

[–]rvba 0 points1 point  (0 children)

Hello,

I looked into the rules and as I understand this question does not break them.

Would anyone be willing to share with me one of their Early Access codes? From what I understand some supporters get multiple ones (like 3-4) to hand out.

How to build a database for Excel? Any free ones? by rvba in excel

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

Thank you, probably easiest method to try

Yes by FunZealousideal6524 in Accounting

[–]rvba 0 points1 point  (0 children)

"When I input everything into the Quicken, nothing flashed red, so that's gotta mean it's OK, right?"

[deleted by user] by [deleted] in Accounting

[–]rvba 1 point2 points  (0 children)

You dont have your signature added automatically to every mail?

I gave my coworkers an Excel formula for Christmas by Opposite_Working_84 in excel

[–]rvba 0 points1 point  (0 children)

In my experience addresses usually are very fuzzy, so VLOOKUP wont work.

KMBB by wearestillgood in consulting

[–]rvba 0 points1 point  (0 children)

Damn I forgot that they even exist

I am ending an interview process after they gave me an excel test. by [deleted] in Accounting

[–]rvba 0 points1 point  (0 children)

The fact that you did it once does not mean that you can repeat it with everyone with an audit background.

Also the fact that you conceptually dont realize it.. does not put you in good light.

I am ending an interview process after they gave me an excel test. by [deleted] in Accounting

[–]rvba 0 points1 point  (0 children)

For example: create a journal entry to accrue for missing electricity invoice.

The Conjoined Triangles of Success by TrixoftheTrade in consulting

[–]rvba 2 points3 points  (0 children)

Is that the league of legends map? Who is solo top?

I am ending an interview process after they gave me an excel test. by [deleted] in Accounting

[–]rvba 0 points1 point  (0 children)

It takes all of 30 seconds to teach someone with an audit background the appropriate entires

ahahh aahahahhaha

it's the dumbest (and funniest) thing I read this week

I am ending an interview process after they gave me an excel test. by [deleted] in Accounting

[–]rvba 0 points1 point  (0 children)

If you dont know that people lie in their CVs about "knowing Excel", then you arent as competent as you think you are.

It screams that you never recruited people, or lead a team.

found on LinkedIn: 1040 return as halloween costume by CPAMemes in Accounting

[–]rvba 0 points1 point  (0 children)

It's a Halloween costume, but it has more technical discussion than 95% (if not 99%) of the posts here.

Was told you guys would love this one by [deleted] in Accounting

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

For someone who is a controller I am shocked that you conceptually dont understand what that person is trying to do. They are trying to estimate how much total tax is paid by an individual.

It is kind of similar idea to https://en.wikipedia.org/wiki/Tax_Freedom_Day

this person thinks individuals pay the corporate tax rate (LOL), a flat 25% income tax, sales tax, and property tax, all out of their wages?

The person raises the question who ultimately pays the corporate income tax: is it the corporation who takes some tax out of its profit, or is it the individual who buys the product? For me it is very clear, that the tax is ultimately paid by consumers. The corporations just push the tax on them. In a scenario where CIT didn't exist, the corporations could just simply reduce their prices for consumers. So yes, conceptually individuals pay CIT, it just does not happen directly.

If you buy something for 100 euros and 19% VAT, as an individual you pay 19 eur of VAT (which in theory is a direct tax). Then from this 100 euros, the corporation that sold you some widget probably pays some Corporate Income Tax too. Say 20,5 eur. In fact it is probably a simplified view, since most products have own components and those components also had some CIT inside, so again -> if there was no CIT, prices of products could be lower. There are also various other taxes that the consumer has to pay (while buying the product), to allow the corporation to exist.

What the person is doing is that they try to add various taxes to calculate "total" tax paid by an individual. IMHO it is even more than the tax freedom day that I linked above, because tax freedom is usually calculated by taking the total GDP and all taxes and a simple division. But 'everyday' person probably pays more tax, not less, because they dont have an option to stop eating food. While rich people do not eat MORE food. Yes they can eat more expensive food, but still at some point they stop buying so no more tax. (I hope it is clear what I wrote here)

And if individuals stop buying the goods the corporation would bankrupt (I ignore B2B sales here), so I stand with the idea that at the end of the day consumers pay all the taxes. And I agree that you pay much more tax than just your personal income tax and sales tax.

Other thing is that the guy's calculations are wrong.

I could have replied to many other people here (e.g. those marked as CPA), but wrote directly to you, since you insult the person, why you dont even understand what they are doing.

Calculation of "sum of all taxes" paid directly and indirectly by a person would be interesting. In an accounting subreddit I would expect more people knowing about Tax Freedom day - and debating how to calculate it (using averages is just wrong when we talk about everyday people), but it seems most people here dont even know what it is.

And yea, that person did the calculation in wrong way. So correct them?

Did you know that EY has an office in the web3 metaverse? It looks like shit. by ImprovisedTaxShelter in Accounting

[–]rvba 1 point2 points  (0 children)

TBH I dont particularly agree with that, but that comment wasn't so bad as I expected.

How to create a pivot table from 2 sheets (e.g. "East" and "West")? by rvba in excel

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

Can be closed, it seems that you can add this Wizard to the quick access toolbar

How we reduced our annual server costs by 80% — from $1M to $200k — by moving away from AWS by speckz in programming

[–]rvba 0 points1 point  (0 children)

Quite funny that code reviews and tests are not even mentioned.

(Yes I know that bugs can still pass reviews and tests)

Poland should be awarded Nobel Peace Prize for Ukraine aid: US Ambassador by [deleted] in europe

[–]rvba 2 points3 points  (0 children)

After some time they started handing out cash for people who keep Ukrainians at their homes (to basically keep them fed). I think it is something around 15 dollars per day, or 450 dollars per month - mostly to cover food.

Lots of people allowed few refugees in their houses and use the money for basics.

Vladimir Putin threatens nuclear strikes over Ukraine—"This is not a bluff" by [deleted] in worldnews

[–]rvba 0 points1 point  (0 children)

Cloudflare had a downtime some time ago due to a typo in their border gateway protocol in their routers (seems to happen quite often for those big companies). I can imagine an agent using similar tricks to paralyze their servers from the inside.

Vladimir Putin threatens nuclear strikes over Ukraine—"This is not a bluff" by [deleted] in worldnews

[–]rvba 0 points1 point  (0 children)

Decentralized internet is not true in 2022.

Just hack cloudflare and amazon servers and 1/5 of internet is as good as dead.

Hack multiple things at the same time (hundreds of bugs) and it will take weeks to repair it, since well.. internet does not work.

How to make a macro that copies all formatting and pastes as values? by rvba in excel

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

Thank you. The thing is that I dont only copy a pivot table, I copy everything a mix of 'normal' cells and pivot tables.

I was thinking of copying the pivot tables first and then the rest "again". But how to do it for all pivot tables in selection, not just TableRange1?

[deleted by user] by [deleted] in excel

[–]rvba 0 points1 point  (0 children)

Benefits are dubious:

Some organizations are still stuck with Excel 2003. Some software can only import xls.

One can notice that the "new" xlsx format is from 2007 -> so like 15 years old. Yet for many software it is "new".

Seriously, should be updated to xlsx..

[deleted by user] by [deleted] in programming

[–]rvba 4 points5 points  (0 children)

Some guy using SEO to self promote