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

    • 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   
    • Lamb roast on Saturday will be different 🥲
    • They are under bucket shims. Tomei provides a test shim kit and then any measurement of shim required. 
    • I always wondered how you were supposed to buy a set of 24 buckets and somehow magically have every single one of them yield exactly the desired clearance. I would have thought you'd need to assemble a cam with either 12 "sample" or "example" buckets of known top thickness (or a single such sample/example 12 times over!!) measure clearances at every valve, and then do the usual math to work out what the actual "shimness" of each bucket needed to be, before buying the required buckets to make up he thicknesses that you didn't have on hand.
    • I now seem to be limited in power due to my rev limit/hydraulic lifters in my built RB25. I'm looking into converting over to Tomei solid lifters. Question for anyone that has done the conversion. I was always under the impression that when using the Tomei solid lifter conversion, you would also require new valves (Longer or shorter stems, I can't remember which).  I don't know where I got this idea, as so far I see no mention of this in any of the Tomei documentation. It just states I need the Tomei solid buckets, solid lifter cams and upgraded springs. As my head is already built, all I would need is another set of 1000$ Kelford cams, 500$ buckets and about 4H hours of my time installing and I'm off to the races!?!? There's no way it's that simple, I must be missing something? 
×
×
  • Create New...