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

    • lol the 2nd one boss, thank you for pointing this out. I feel as i spend more time here this intro message is some thing i will always make me laugh and shake my head at. Perfect Intro:  I have the vehicle  
    • R34DE as in R34 with an RB25DE? So did you get this? Or you planning to?  I'm not really sure what you're saying. 
    • Possibly avoid using a Cometic one unless the deck/head surface are perfectly flat. I did have a look just then and forgiving gaskets such as Tomei or Nitto don't exist for the FJ20, however the Bar-Tek or Kameari ones look good and might do the trick.
    • Because pipe threads for pipe things. M threads for bolt things. Throw some teflon sealant onto it and dust your hands off knowing you did the right thing, instead of going twice around the block to achieve a result using the wrong things. Of course, all of these solutions are ignoring the fact that the minimum thread pitch we're talking about here is 1.25mm, with the 1/4" in NPT or BPS being out around 1.4mm. You will need to know that the boss you're tapping has enough thickness for at least a few threads. That's one of the reasons that 1/8" is commonly used - because the pitch is <1mm. And why would you look to use 1/4" NPT in a BSP country anyway? Ugh.
    • Just throwing around ideas, does it need to be in the compressor cover? Why not the hot side piping?
×
×
  • Create New...