Home | Blogs | rmaclean's blog

AA Rates

Sat, 03/01/2008 - 21:05 |  Robert MacLean

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 find the AA rate. Well imagine my surprise when I didn't find one 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 each time someone joins/leaves have to update it). 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 (it's attached). 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

funny attachment

Submitted by Craig on Wed, 10/07/2009 - 12:03.
Visitor's picture

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

Excel spread sheet

Submitted by Sheila on Tue, 08/04/2009 - 09:39.
Visitor's picture
Hi I am unable to open or download your excel spreadsheet. Could you possibly assist? Thanks Sheila

AA rates

Submitted by Hein on Wed, 04/30/2008 - 19:49.
Visitor's picture

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.

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, 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.

More information about formatting options

Free Visual Studio training
StackOverflowServerFaultSuperUser Loading my StackExchange stats...
I am a community lead in this group.
We discuss SharePoint, Office and all things IW.
Twitter
Loading my tweets...
Contact Me | RSS Feed | Back to top


(C) SADev.co.za, SADev and the content here is copyright 2001-2010 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 Barone, Budge & Dominick. 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.