Mugabetown - Whoretownin' At It's Worst.

[MagicMikeZ32]

=IFERROR(VLOOKUP($A17,'sub register 230914'!$A$22:$CI$141,26,FALSE),0)

[MagicMikeZ32]

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

someones hacked into Mikes account

this gives me the opportunity to liaise with my good admin / moderator friends and boot Mike out of SAU

[MagicMikeZ32]

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

Surprised you don't do similar!

[Ants]

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

[t5iv]

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

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?

[sneakey pete]

Pfft, simple equations

But yay, excel worksheet peoples!

[MagicMikeZ32]

Pfft, simple equations

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]

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]

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]

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

[Cadmoon]

Screamer pipe.

[Ants]

Screamer pipe.

scream her with yer pipe?

[Cadmoon]

Scream into her pipe?

[sneakey pete]

Screamer pipes mike. Doo eet.

[Cadmoon]

Screamer pipe mike. Doo eet.

FYP.

I might, but internal gate is shit for a screamer pipe.

[Cadmoon]

Pete, you in Brisbane on the 15th of November?

[sneakey pete]

Can't be sure yet. Rostered to work but talk of doing a longer swing which would push my rnr there. Is there a good reason for me to do so?

[Cadmoon]

It's the date I'm looking at holding the charity cruise.

[sneakey pete]

Looks like i'll be doing a 3 week swing then!

Edit: any idea how long until its finalized?