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

    • It was roughly 3.5 hours.    car went in around 11:00 and I was done around 2:30 He did the initial runs, install the BC and then Nistune install and tune.  The best part was sitting in the lobby and hearing the skyline on full throttle at the dyno 😂😂
    • Glad it all went smooth. How long did the tuning process take?
    • Yeah that was kind of the same feedback my tuner gave me.  the boost tee is until I can sort out my plan for the electronic boost controller and what I’d get, where I’d mount the dash etc.  I’m happy with this until I can figure it out. Not a big fan of the A-pillar gauges. I’d like to get a clean install of the boost gauge - something digital like GFB.  Something like that might fit neatly where the ashtray is and look clean. I feel like replacing the OEM triple gauge is a bit extreme for a weekender like my skyline. And it’s not making crazy power to need all the additional sensors/gauges. 
    • I'm about to swap my box to Tremec T56 Magnum F & initially thinking of re-using my DCS twin plate (can get it re centred for the bigger spline) but it's been called out the box will be noisy (rattle) as the clutch is unsprung.  So I'm doing as much research as possible. I'm not so worried about holding the power as I'll go the track version which on paper will hold the maybe 1000hp I make. It's the longevity I worry about. DCS told me they don't use a sprung centre as it's just something that can break. The uni clutch has a very complicated sprung centre. Any one had or heard about any issues with it failing? Thanks in advance.
    • Auto is at least 10% (from my real, actual experience with different torque converters and manual on the same setup) ~185rwkw at 11.6psi (peak!) is entirely what one would expect without a FMIC or anything else on the intake, it does bleed off towards the higher RPM so it's what, 9psi there? Note: There is nothing that can be done about this with a manual boost tee. If you want to hold it steady and gain more top end, well - You will need electronic boost control.....
×
×
  • Create New...