Jump to content
SAU Community

Mugabetown - Whoretownin' At It's Worst.

t5iv

By t5iv,
in Queensland

 Share

Recommended Posts

  • Replies 24.4k
  • Created
  • Last Reply

Top Posters In This Topic

  • Ants

    5677

  • Captain Natro

    2067

  • t5iv

    1789

  • Cadmoon

    1709

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

Smity42
Smity42

FYP

Cadmoon
Cadmoon

Some bored car photos from today

Smity42
Smity42

Become a member, you tight-a*se

Posted Images

MagicMikeZ32 Veteran

MagicMikeZ32

Posted
Posted

=SUMPRODUCT(--('Cost Table Info'!$A$2:$A$23000='Cost Tables'!$B$222),--('Cost Table Info'!$C$2:$C$23000='Cost Tables'!$B227)*('Cost Table Info'!$I$2:$I$23000))

Ants Grand Master

Ants

Posted
Posted

That is the stuff I look at all day everyday...

Surprised you don't do similar!

mate I do but in different formats

Where you deal with costings, budgeting etc... I deal with other matters

=IF(E101>180000,(+E101-180000)*0.45+54547,IF(E101>80000,(+E101-80000)*0.37+17547,IF(E101>37000,(+E101-37000)*0.325+3572,IF(E101>6000,(+E101-18200)*0.19,0))))

=IF(E101>17795,+E101*0.015,0)

=-IF(E101>67750,0,IF(E101>30000,(E101-30000)*0.04-1500,-1500))

and my formulas make more sense :P

t5iv Grand Master

t5iv

Posted
  • Author
Posted

mate I do but in different formats

Where you deal with costings, budgeting etc... I deal with other matters

=IF(E101>180000,(+E101-180000)*0.45+54547,IF(E101>80000,(+E101-80000)*0.37+17547,IF(E101>37000,(+E101-37000)*0.325+3572,IF(E101>6000,(+E101-18200)*0.19,0))))

=IF(E101>17795,+E101*0.015,0)

=-IF(E101>67750,0,IF(E101>30000,(E101-30000)*0.04-1500,-1500))

and my formulas make more sense :P

The first one is a tax table but looks like the 12/13FY table as the rates are wrong for this year.

Second is FBT?

Third?

MagicMikeZ32 Veteran

MagicMikeZ32

Posted
Posted

Pfft, simple equations :P

But yay, excel worksheet peoples!

Man we have fancy linked workbooks that do selectable dashboards with graphs and tables and stuff.

Even have one that sends an email on the users behalf ;)

Ants Grand Master

Ants

Posted
Posted

The first one is a tax table but looks like the 12/13FY table as the rates are wrong for this year.

Second is FBT?

Third?

2013/14 individual tax rates mate

Individual Medicare Levy threshold 2008/09

LITO for 2011/12

picked from random spreadsheets

t5iv Grand Master

t5iv

Posted
  • Author
Posted

2013/14 individual tax rates mate

Individual Medicare Levy threshold 2008/09

LITO for 2011/12

picked from random spreadsheets

Sure? The lowest bracket is $18k now and you've got it as $6k? every chance that I'm wrong here.... I hate Excel.

Ants Grand Master

Ants

Posted
Posted

Sure? The lowest bracket is $18k now and you've got it as $6k? every chance that I'm wrong here.... I hate Excel.

hmmmm.... its actually $18.2k mate.

and that entry level bracket (6k) should be 18.2K

  • Like 1

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing


  • Latest Posts

    • drifter17a
      Skyline R34 Suspension Drama

      By drifter17a · Posted

      I have replaced everything on my r34 including suspension to Miester R, all rear subframe bushes to poly, all arms to metal adjustable and same in front.   only thing I haven't touched is the front lower control arm. Should I? what improvement can i expect ? I mean the one on the link below?   Car drives perfectly, it is just me thinking everything is either puly bush or hard bearing type so should also do lower control arm front but do I really need it ? https://www.japspeed.co.uk/product/suspension/adjustable-arms/nissan-200sx-s13-s14-s15-skyline-r32-r33-r34-adjustable-suspension-front-lower-control-arms/?gad_source=1&gclid=Cj0KCQiAo5u6BhDJARIsAAVoDWs5V_PauQPf0kx3zFCaA4tOC9Q7JSIsfJWma_jAPN2f1sJA686djOwaAidgEALw_wcB
    • Duncan
      Who has a Infiniti Q60, Q50 (V37)?

      By Duncan · Posted

      Thanks for the link.....but I'm still not totally understanding (a bit slow). So as long as the host unit supports carplay or android auto, you plug the unit to a USB C port, and then change the AV source?  Does the unit run its own apps (eg I could run Real Dash or Torque etc) or does it rely on a host phone and just run Android Auto from the phone (which is very limited compared to full Android?). And, does the touch screen work for the apps? Only the bottom screen or the top screen as well? The 4g wifi looks like a good feature if you have kids with devices in the car (noting none of the versions seem to support 700mhz Telstra)
    • Duncan
      Thinking of getting a Q50 300hp and just tuning it instead of getting the Q50 Red or 400R

      By Duncan · Posted

      Mate, if Australian build quality was an eye opener, wait until you try a Chrysler. If you need space and fuel economy (and you don't want to hit the track) a fuga hybrid is the way to go. Similar power to the 400r (270kw), roomy, comfortable, good on fuel, great build quality
    • GTSBoy
      Thinking of getting a Q50 300hp and just tuning it instead of getting the Q50 Red or 400R

      By GTSBoy · Posted

      Um...self respect?
    • GTSBoy
      Alpha omega racing bracket

      By GTSBoy · Posted

      Um...that thing looks terrible. I'd be looking for replacements tout de suite. WTF is it made of? Die cast cardboard?
×
×
  • Create New...