I love Amazon AWS, but I'm tearing my hair out over the obscure usage data they give you. All they seem to have is either an extremely high level summary that just shows you your total monthly cost for each service, or a very hard to read spreadsheet that gives you very detailed usage data but leaves out really obvious things like the cost of each line item (it only shows you the amount of usage, so you have to go and find the rate for each service separately and then multiply rate x usage to get the cost).
Does anybody know of any tools or services that give you better insight into AWS usage data, e.g. total bandwidth cost in and out of AWS per day, or EC2 instance cost per day per instance ? Ideally I'd like to be able to pull the data programatically, so that I don't have to download a spreadsheet and massage it manually.