Home | Blogs | rmaclean's blog

AA Rates

Sat, 03/01/2008 - 21:05 |  Robert MacLean
NOTE: This was developed in March 2008 and the calculations are no longer accurate. They are close but not exactly right.
Update 11 August 2011: Want this as an app for your smartphone? Click here

A personal annoyance at the moment is the use of the term AA rates. It seems companies love to tell employees they pay at AA rates or charge customers at AA Rates. However due to a recent annoying experence I decided to read up on this, and to findout what the AA rate actually is.

Well imagine my surprise when I didn't find one magic overall AA rate! What I did find is there is a AA rate per vehicle, so how you get one rate is beyond me (I guess you could take the avg value of everyone in the company, but that sounds like too much work for admin/financial staff who need to update it each time someone joins/leaves).

Anyway I decided to take that and some of the Excel skills I have been taught recently and build a nice Excel speadsheet (2007 version) which works it out for you (download below). You can get the details on the rules and the fuel price (which you will need) from the AA site.

AttachmentSize
AARates.xlsx30.5 KB
Tags: Annoyances

I always hear AA rates and have googled all sites please help,how do I find a calculator or formula to commercial heavy duty charging and factors affecting change in rate.If any AA rate where is it straight link please

Submitted by Muzi on Sun, 07/24/2011 - 22:01.

Hi I dont know if you found what you have been looking for. I am in the same position needs the running cost for heavy duty trucks and double cab diesel ldv's
Maybe you can help
Thank you Cindy

Submitted by Cindy Nel on Thu, 11/17/2011 - 12:45.
In the post is the spreadsheet which is a calculator for the AA Rates. There is no such thing as "commercial heavy duty" rates - there is one AA Rate with many factors like vehicle type that influnence it. So the above will work for any need you have. You can see the formula too in the spreadsheet.
Submitted by Robert MacLean on Tue, 11/22/2011 - 08:58.
In the post is the spreadsheet which is a calculator for the AA Rates. There is no such thing as "commercial heavy duty" rates - there is one AA Rate with many factors like vehicle type that influnence it. So the above will work for any need you have. You can see the formula too in the spreadsheet.
Submitted by Robert MacLean on Mon, 07/25/2011 - 13:17.

It seems even with 2007 it does not open your spreadsheet.

Submitted by Craig on Wed, 10/07/2009 - 12:03.
Hi I am unable to open or download your excel spreadsheet. Could you possibly assist? Thanks Sheila
Submitted by Sheila on Tue, 08/04/2009 - 09:39.

Hi,

Thanks for your insight on this issue. I am having a bit of a struggle with my co at the moment and would like to use your formula to check how my rate that I am getting compares to the "AA" rates. I tried to use your formula but it wont allow me to put the fuel price in. Could you please assist me with this?

If need be you can reply to heinkrause@vodamail.co.za.

Regards.

Hein.

Submitted by Hein on Wed, 04/30/2008 - 19:49.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account associated with the e-mail address you provide, it will be used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
  • Syntax highlight code surrounded by the <pre class="brush: lang">...</pre> tags, where lang is one of the following language brushes: as3, applescript, bash, csharp, coldfusion, cpp, css, delphi, diff, erlang, groovy, jscript, java, javafx, perl, php, plain, powershell, python, ruby, sass, scala, sql, vb, xml.

More information about formatting options

Twitter
Loading my tweets...
Contact Me | RSS Feed | Back to top


© SADev.co.za, SADev and the content here is copyright 2001-2012 Robert MacLean unless otherwise stated. Content reuse license: Creative Commons Attribution 2.5 South Africa License. Disclose Policy: Disclosure. Disclaimer: The views expressed here reflect the views of the authors alone, and do not necessarily reflect the views of any of their organizations, my customers and clients, employers, sponsors, or contributors. In particular, the views expressed here do not necessarily reflect those of the BBD (my employer) or Microsoft. All information and downloads are available without warranty and any use of such information or downloads is at your own risk. Use common sense. If you don't like what is written then do not read it.