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

    • Perfect, I'll get to it this winter then at the same time as I weld on my anti squat kit. 
    • Alright so my 32 only has one temperature no matter what degree you set it to. I’ve tried disconnecting the servo motor arm and moving it either direction and got no change. I’ve fixed the leak in my AC and re charged it and with it on and clutch engaged it still blows hot even though the low pressure pipe going to the firewall is ice cold. Both heater core hoses are hot while running as well. Diagnostic code showed 24 for intake air temperature sensor. Anybody got any ideas?
    • I said Garrett style. Not Garrett genuine. And something in the G30 550 range is what you want. Not those pokey little old fashioned T28 sized things. The intake ports in the head are small. There is little benefit in fattening up the runners and leaving ths actual ports small. Just run what you've got. And on the subject of Nistune vs Haltech etc..... You know you can control the transmission with decent standalone ECUs these days, right? No need to keep any of that old Nissan bullshit. Don't get me wrong - I use Nistune on my Neo. But it is a DET, so the number of bodges and workarounds I had to do to make it work in a chassis without ABS, TCS, etc, is quite small compared to the herniated arsehole you will have trying to make it work on a motor that doesn't have some of the things that the turbo ECU wants to see. Just easier to bite the bullet and go aftermarket outright.      
    • Hmm. Only when the f**king thing is actually working. Still can't find the leak. And that's with dye being put in the last 3 times!
×
×
  • Create New...