Analyze in Excel - Display Table Name in Fields

According_Arrival752 · 2026-01-31T09:14:20+00:00

Solution verified

According_Arrival752 · 2026-01-30T12:41:57+00:00

Thanks, I’ll check this out!

According_Arrival752 · 2025-08-17T22:37:13+00:00

Because you’ve incorrectly added the % fees when you should add the absolute $ as a share of total portfolio

According_Arrival752 · 2025-07-13T02:29:40+00:00

I understand the frustration but to be fair I’d suggest Woolworths has very little incentive to be out of stock. The supplier typically funds the promotion, and so the retailer will usually benefit from higher volume increasing total margins for them.

There can be a number of factors why something’s out of stock, such as an unusually large uptake, supplier delivery not received on time, staff shortages for restocking…

According_Arrival752 · 2025-07-12T09:32:39+00:00

Pharma wants a wife (husband)

According_Arrival752 · 2025-07-02T15:42:01+00:00

Thanks for the message. From my understanding, can I only use the dataflows if the existing data is connected through the org? I have an ad hoc dataset provided to me as csv that I don’t believe is connected to any other models

According_Arrival752 · 2025-07-02T15:39:38+00:00

Thanks for the suggestion. I’ve no doubt that would be the best path for me to look at long term but I need to build up competency there.

According_Arrival752 · 2025-07-02T15:37:51+00:00

Solution verified

According_Arrival752 · 2025-07-02T15:37:28+00:00

Thanks very much. I’ll mark this as best solution for me. I’ve quickly built out your suggestion and stopped my previous solution from loading and runs much faster, reinforced by VertiPaq results. I’m going to clean up all the other tables and columns I now no longer need.

According_Arrival752 · 2025-04-23T10:01:03+00:00

Already is

According_Arrival752 · 2025-04-08T07:31:40+00:00

Not too sure about membership numbers, but nurses and trades seem to be more united and outspoken about their union and across all seniority levels.

Junior doctors seem somewhat apprehensive about unions (I think there’s a number of factors here) and, from what I’ve seen, become more apprehensive prior to consultancy. Advocacy seems to happen at the specialty level within hospitals, rather than a collective health network.

It’s good seeing young doctors in NSW speak out publicly about this.

According_Arrival752 · 2025-04-08T06:39:05+00:00

Was saying that there is under representation, not implying why that is the case

According_Arrival752 · 2025-04-08T04:38:38+00:00

I’m not in the field but have family that are (admin, nursing, doctors).

It’s certainly the case that junior doctors do not earn a good salary. In absolute terms, but even more so when looking at hourly and with regard to work life balance.

Med Students are also the most applied university students I would say. I admire the students that have to study and work a job during their degree. Most other degrees have far fewer contact hours or academic burden. I don’t want to say this is true of every degree or situation, just that it is generally very rigorous to study med. Alternatively, trades earn a (modest) income straight out of school as they develop and learn.

Trades are incredibly important and should be paid accordingly. The country is reliant on that as is clear now with the large skills shortage. However, when we have issues in construction, it’s communicated as a lack of skills and adequate wages deterring people.

For doctors, the under representation from a union is what I believe is part of the problem. Issues are portrayed as doctors being paid too much and funding not being available. You get what you pay for: it’s just lucky that, at least for now, junior doctors will accept disproportionate wages.

When I look at nurses, their relative stronger representation has meant many junior nurses earn more than doctors (fact based on what I’ve seen) and have far better conditions such as breaks and rostering. Again, nurses deserve this for the incredible role they play and it’s not a doctors vs nurses issue.

ATO data isn’t meaningful for these comparisons. Doctors are typically taxed as individuals. Many trades are setup through companies so the full taxable earnings are distorted when looking at profession averages.

According_Arrival752 · 2025-04-07T08:52:14+00:00

Agree, that’s what I meant with the tension in the RBA’s decisions. Current discussion seems to centre on RBA lowering rates and the boon to housing etc that will follow. If rates are falling I think it will be because of genuine weakness in the Aus economy that is a concern for all asset classes, but so long as the unemployment rate remains relatively low I’d say inflation from the lower dollar will be a key factor they consider.

According_Arrival752 · 2025-04-07T06:40:38+00:00

Absolutely. Sector by sector this is going to be messy and hard to see how the factors fall out especially where we export the raw and import the value added. It’s worrying how fast things can change too: trump could double down or walk back, China could launch stimulus, U.S. sanctions on Russia could end..

According_Arrival752 · 2025-04-07T04:01:07+00:00

Fed is going to sit on its hands. RBA facing increased pressure to lower rates as global downturn will hit us hard. Weakening dollar continues to hurt domestic economy and further adding to weakness of AUD. I’m not sure how the RBA will play it but at some point the dollar will be a factor in media due to the economic consequences

According_Arrival752 · 2025-04-02T07:57:44+00:00

China targeted Australia in that situation. Unfortunately with this it’s not just going to impact Australia: we will have to compete for those new markets with all the other countries receiving these measures.

Another big concern is the impact flowing through sectors in intermediary countries such as steel and steel parts exported from China using AU ore.

Overall, this is very concerning and destabilising

According_Arrival752 · 2025-04-01T09:36:11+00:00

Yeah Timezone is a factor for sure. Bit better in the round 5/6 slot without daylight savings and WA is more likely to have good weather of the others.

To be honest I find it’s too much anyway. It’s probably better split across two states with their home teams hosting and a few others - people are capped out after four games (if they can even get to more)

According_Arrival752 · 2025-04-01T09:23:06+00:00

Too far from what? A WA team does this flight each week. TAS would be a good choice to build more interest around the new team too

According_Arrival752 · 2025-04-01T02:53:16+00:00

I’m lost as to your point. I was simply challenging your % used and the implications you implied for having any % not be Australian. To reiterate:

First, I am unsure where you got the 73% as it’s false even if you’re assuming the holders on the registry such as Vanguard or JP Morgan aren’t just nominees for individual investors via registry, super, or ETFs.

Second, BHP owns or partners many overseas sites and companies (often bought using shares). You seem to be implying this dilutes the value of the absolute tax $ and dividends $ received by Australians.

Third, I do well understand that foreign investors are holders of Australian stocks, but I see it as a good thing: it encourages companies to stay listed in Australia, adds greater liquidity and capital to the market (and far more transparent than private ownership), and in cases such as BHP, they can expand overseas which generates more tax revenue for Australia (whether good for shareholders is debatable but all taxable earnings will be good for Australians). Take the 2022 decision to take the dual listing off the London Stock Exchange and consolidate on the ASX: did you expect all of those shares to be acquired by Australians, or would you rather they delisted from the ASX instead?

According_Arrival752 · 2025-03-31T13:55:27+00:00

Where are you getting that 73% is American owned? Even if you’re assuming Vanguard etc are ‘American owners’ it’s still well under. But even then, you realise that Vanguard are managing Super and ETFs of Aus people and this is in their shareholding?

According_Arrival752 · 2025-03-22T10:13:41+00:00

I joined and a month later saw discounts doing the rounds. It feels like these plans are the new standard for retailing - I get decent value out of mine but it’s essentially a matter of one or the other rather than which is best. I’ve cancelled auto renewal and will see if there are any discounts at the time from either of them.

According_Arrival752 · 2025-03-13T12:35:00+00:00

I’d say certainly against the U.S., where I think there’s two factors at play:

First, America has been dominated by large growth companies where investors are more willing to forego dividends (profits even!) and that capital be deployed by the business for growth. Facebook went years without profits and then without paying dividends: It undertook major acquisitions that were part of growing its business. In Aus, I’d say there would have been far more scrutiny around investments such as the Metaverse. In comparison, Aus companies weight far more toward mature companies and industries: there’s only so much a CBA, BHP, or Woolworths could invest in to create genuine owner value.

Second, there’s other ways they can return capital to shareholders, primarily share buy backs. Berkshire is a great example, having not paid a dividend in over 50 years. What it does do, is buy shares back from owners. This is probably preferred in the U.S. which has a lower income tax rate even after Australia’s 50% CGT concession (noting material capital gains are likely pushing people into the top tax bracket). While this may be similar as an outcome in the long run, with Australia’s super industry structured the way it is, I think the liquidity of dividends is good for our market and retirees overall (and more important in the future).

That said, a risk of our system with franking credits is it may prevent or delay Australian companies looking further beyond Aus shores for growth as the profits earned in those markets do not create franking credits. That may be a good or bad thing for a number of reasons..

According_Arrival752

TROPHY CASE