Jump to content
SAU Community

Mugabetown - Whoretownin' At It's Worst.


Recommended Posts

=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))

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

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?

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 ;)

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

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.

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



  • Latest Posts

    • You now say stumble, but you said cut out before. Will it slow rev through the cut/stumble? What gap were your spark plugs set to when you them in?
    • I had double clamped all the pipes but I checked them over any way, everything tight and secure. feels and sounds like a electrical short/failure, as it is an abrupt and aggressive stumble, that instantly comes and goes right at 4k mark...like clock work fuel pump and filter are new new coils and plugs injectors where cleaned and tested 200 miles plus ago no black smoke cleaned MAF   same results, other ideas? some other sensor?  
    • Yes, just without the annoying use of the word hybrid. We stopped using that term 20 years ago when we realised it meant different things to different people. Even "highflow" can represent more than one way of achieving the goal of getting more flow out of a turbo. But at least it says what it does on the box.
    • OH, when they say "solid buckets", I always interpeted that as "shimless". (Which is not the same as the "shimness word I invented above to represent the same idea that the buckets act as shims also!!). Still the same problem though. So it appears that buying a "kit" from Tomei is a two step process. Makes sense. Doesn't make sense in the context of a "kit" though.
    • Wanted to add some of my R33 GTST  R34 GTR wheels, 18x9 ET30 with 255/35/R18 PS4S'   BBS RE-V7 029 18x9.5 ET22 with 255/35/R18 PS4S' Needs a bit of camber   
×
×
  • Create New...