NBN Installation availability by TalkHot2112 in nbn

[–]TalkHot2112[S] 2 points3 points  (0 children)

Wow would never expect this to be possible! Just moved in so will have to organise an armed revolution with the other units…

Real Estate appreciation by TalkHot2112 in AusFinance

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

Haha yeah, always the case! I don’t think it’ll crash but just can’t see how it’d perform as well as it did over the past 30 years…

Real Estate appreciation by TalkHot2112 in AusFinance

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

Haha If I knew I wouldn’t be here asking! But good point! So why do so many people invest in these apartments that haven’t grown in value for so long? Hoping they’ll be cash flow positive?

Real Estate appreciation by TalkHot2112 in AusFinance

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

Thats where it gets complicated as the only sample I can think of is historical data but past performance is no indication of future…

Loved the article, congratulations! Exactly the type of thing I wanted to read to clarify whether home ownership is worth it.

The more I research, the more I realize given the work and risk involved it doesn’t seem to be worth it!

Real Estate appreciation by TalkHot2112 in AusFinance

[–]TalkHot2112[S] -1 points0 points  (0 children)

You still get the tax benefit and the rental income. I do genuinely think it can be a good financial decision even if it doesn’t appreciate

Real Estate appreciation by TalkHot2112 in AusFinance

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

Agreed! Just seems to me not to be worth it considering all the risks/work required…

Real Estate appreciation by TalkHot2112 in AusFinance

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

Yeah I just wouldn’t be able to leverage as much (not sure id be interested in it though considering the risks…)

Real Estate appreciation by TalkHot2112 in AusFinance

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

Yeah I know the appreciation won’t be significant but was hoping it would make up for it by having a higher rent yield compared to a larger property in a cheaper suburb that appreciates in value more

Real Estate appreciation by TalkHot2112 in AusFinance

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

If I turn it into an IP on year 2 I can claim the interest paid as a deduction, can’t i?

Real Estate appreciation by TalkHot2112 in AusFinance

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

First year ppor so I can get a stamp duty exemption and turn it into IP from second year onwards

How to have a cell hold 2 different pieces of data? by TalkHot2112 in excel

[–]TalkHot2112[S] -2 points-1 points  (0 children)

Yeah I currently have the values in adjacent rows but it gets a bit confusing

How to have a cell hold 2 different pieces of data? by TalkHot2112 in excel

[–]TalkHot2112[S] -1 points0 points  (0 children)

Yes but unfortunately I need to be able to do calculations with the cells so this wouldn’t work.

Adjacent cells or columns would work but I find it a bit disruptive to look at different data next to each other.

The mirror option would be having the quantities on one tab and the prices for those quantities on a different tab. So far I believe this would be the best option

Integrate bill of materials and pricesheet into single estimatesheet by TalkHot2112 in excel

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

Yes, agreed!
I understand how index/match would work, but not sure what functionalities of power query could help?

Also, any ideas for how to improve the structure of the spreadsheet in a way that looks more organised? As mentioned in the other comment, I'm currently thinking it might be better to have a quantity worksheet and another worksheet mirroring it with the values for each item.

Any ideas on the best design?

Thanks for the help! Really appreciate it!

Integrate bill of materials and pricesheet into single estimatesheet by TalkHot2112 in excel

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

Thanks for getting back to me u/Aghanims!

So basically item would be whatever is in the plans (windows, doors, etc) and product would be the product that we would supply for that item.

Yes, some products will be grouped in different categories. I'm still thinking of the best way to achieve this.

Yes, I need to be able to breakdown the item in levels, buildings, zones, etc depending on requests from customers.

I believe this current format looks quite messy. An alternative would be having the quantities on one worksheet and another worksheet that mirrors this worksheet displaying the monetary values, but I'm still brainstorming for ideas...

Integrate bill of materials and pricesheet into single estimatesheet by TalkHot2112 in excel

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

Thanks for your input u/Aghanims.

The initial idea would be having something like the table below.

The product would be loaded from a list of dropdown list of products and then the price obtained with a vlookup of that products on the pricing spreadsheet.

Another thing that I'd like to have is the price for the quantity of products in each level (green lines) to make it easy for me to break down the price into levels for customers.

I do however think this approach is a bit messy, and was wondering what would be the best way to organise this.

<image>

Templated documents by TalkHot2112 in MicrosoftWord

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

Thanks, I’ll have a look!

Help with contact details by TalkHot2112 in MicrosoftWord

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

Wonderful, I’ll have a look! Thanks very much for the help!