Mutt
Nothing obvious
Just highlight and delete cells A3 to A 10 and B3 to B10 to blank the cells then enter your Type designator(eg B737, LJ40) in say A3 and the distance in B3 hit enter, it should fill in the rest of the line. Then add as many lines as you want. We only have one aircraft type to fill in.
It seems to have a hidden database of aircraft type designators.
At the end of a year I copy and paste the spreadsheet so I can actually use it but there are probably better ways.
Enjoy!

Mike Echo

Aha....... Makes sense..... Just glad that I don't have to deal with it...... :)

Mutt

EU-ETS
 

So, it's been suspended then for international operators:

EU Commission freezes EU carbon emissions law for airlines | Reuters

That helps the industry no end...

Finally some common sense prevails. Apparently will be reintroduced in one year if ICAO do not come up with a global emissions solution.....:mad:

Once again, in the EU, then get penalised for it!

It does seem like yet another knife in the back for us all in Europe.

It will be nice to know that non-EU operators will be able to fly around in Europe (obviously fully obeying cabotage requirements) not incurring the charge though, making us all even less competitive...

Will be interesting to see what happens come November 2013, I suspect ICAO won't have done anything and imagine it will get extended again.

Daifly, your statement is not completly right. The ETS will be charged to all airlines for flights taking place in the EU. No charges for the flights from and to the EU

Maybe it's just bad journalism (or unclear legislation!) but the next line reads:

Wonder how much carbon has been generated by humans discussing this scheme.

Not so fast, firstly it has to be ratified by all 27 EU States, and it does not apply to inter EU flights, ops normal according to them. See below press release from Universal.

I don't believe this will go ahead as EU states will see it as anti competitive to EU airlines.
Miss Hedergard is trying to back peddle but still not enough as she is trying to safe face, no EU State is brave enough to impound a Chinese airliner for not complying.

Mexican standoff methinks!




Today’s press release by the European Commission (EC) (attached) and subsequent new material include a lot of information and statements regarding EU-ETS that should be reviewed carefully.

The EU Commissioner for Climate Action, Connie Hedegaard, has shown through her statement a willingness by the EC to compromise with respect to EU-ETS requirements for Aviation Activities that occurred during the 2012 monitoring year. The proposal that Commissioner Hedegaard has recommended via conference call, would remove the requirement for operators to Monitor, Report, and Verify CO2 emissions and Surrender Carbon Allowances for international flights to or from the EU (i.e. KTEB-EGGW), but maintains that all current obligations for any operations within the EU (ie. EGGW-LFPB) remain intact.

There are three important items to note regarding this “Stop the Clock” proposal:

1. This proposal would have to be ratified by all 27 EU Member States to become effective

2. All operators are still responsible for Monitoring, Reporting, and Verifying CO2 emissions for intra-EU activity, and surrendering the appropriate amount of Carbon Allowances by current posted deadlines

3. It is only a temporary measure to “create a positive atmosphere” around the negotiations with ICAO, to create a global greenhouse gas reduction scheme and not a permanent change to the EC Directive

In summary, the international aviation community must continue to prepare for compliance with EU-ETS as presently constituted until an official resolution is reached regarding this proposal or any other proposal of its nature.

If this proposed measure were to be implemented, operators would still be responsible for all phases of EU-ETS for intra-EU activity. To comply with these regulations, operators need to have systems and procedures in place to Monitor, Report, and Verify CO2 emissions, and surrender Carbon Allowances. Establishing a Carbon Registry/Aircraft Operator Holding Account to bank and surrender allowances should still be the top priority for operators captured by the scheme.

NBAA Welcomes Final Passage Of EU-ETS Prohibition Act
 

So now President Obama has signed it into Law.

What is the implication for N reg opertors and what are they doing now? Can you just stop with all the ETS rubbish or do you still comply?:rolleyes:




The National Business Aviation Association issued the following news release:

The National Business Aviation Association (NBAA) today thanked President Barack Obama and members of both houses of Congress for their work in passing the European Union Emissions Trading Scheme (EU-ETS) Prohibition Act.

President Obama signed the measure (S. 1956) into law today.

"With final passage of this act, the president and Congress stand as one in declaring that the EU-ETS is an overreach, it's wrong and it won't fly with operators based here in the United States," said NBAA President and CEO Ed Bolen. "This is an issue that should rightfully be decided within the framework of the International Civil Aviation Organization (ICAO). With passage of this measure, the United States government has said with clarity and conviction that it will stand in favor of international law and against the unilateral imposition of one region's will upon the rest of the world."

EU-ETS was unilaterally imposed on the aviation industry by the 27 member states of the European Union as a market-based solution to greenhouse gas emissions. Aviation operators were to have begun purchasing carbon credits for exchange on the open market by the end of April 2013. It was estimated that EU-ETS would cost the U.S. aviation industry $3.1 billion and thousands of jobs over the next decade.

Final passage of S. 1956 comes just a few weeks after EU Climate Commissioner Connie Hedegaard announced the planned suspension of EU-ETS enforcement on operators based outside of Europe. Hedegaard said she was encouraged by what she viewed as solid progress made on development of a market-based emissions control system during a Nov.9 ICAO summit.

"Together, NBAA views these developments as extremely positive for our industry here in the U.S. and for aviation cooperation worldwide," Bolen said.

Anyone else get this in their email?

"EU ETS Compliance Deadline 31st March 2013 - ETS.aero Introduction and Brochure"

How does this affect biz jet operators ?

The way I'm understanding this,
1) The EU suspension for 12 months will make almost no difference to Biz-Jet operators. You only save on the into and out of sectors all the others inside the member states still have to be accounted for. For us this is only about 6 sectors a year (BIKF-CYYR) In some ways this has complicated matters as these have to be removed. However, if the Suspension is lifted next year then you will still have to pay for these sectors. What this has done is lift the international airlines out of the scheme for a year and maybe reduce some of the pressure on the EU.

2) EU-ETS Prohibition Act --S. 1956 would direct the Secretary of Transportation to prohibit an operator of a civil aircraft of the United States from participating in the European Union’s emissions trading scheme in any case in which the Secretary determines the prohibition to be in the public interest, and would also provide the Secretary of Transportation with the authority to ensure that U.S. aircraft operators are not penalized or harmed by the E.U.’s unilateral emissions trading scheme.

This is where I can see the Biz-Jet (N reg) operators getting between a "rock and a hard place". Much as I dislike the thought, the EU countries do have the right to legislate on what happens in their airspace and could ban or impound aircraft if the Operater does not comply within the EU. Whether
the US Secretary of Transportation would bring trade sanctions and finance to help a lone Operator I seriously doubt. Hopefully, some clarification can be obtained from NBAA as I just cannot work out how all this would be enforced.

Mattman has encompassed most of the options.

Anybody any other thoughs?

M.E.

The above posters seem to have got it spot on :cool:
I recently had a chance to quiz BA's environment chap about this - he said that the ETS suspension is so that the ICAO meeting in October next year can come up with a workable solution.
If not, ETS will be re-introduced in some form, apparently.

Mike Echo: we also discussed the situation with the Chinese and US airlines refusing to comply, and he agreed with my suggestion that, obviously, any scheme where there is widespread dissent and disobedience is unworkable; you can't ban / impound every non-EU airline / aircraft for something like this.

If ETS is re-introduced, it looks like it will be intra-EU only, for the time being, as a first step. Otherwise, it will defer to ICAO. :}

Just a thought - as far as I am aware - the Channel Islands are outside EU-ETS.

Is there any margin on longer EU sectors out of the UK / Ireland or say from Northern Europe en route Spain/Portugal to make a quick techstop at Guernsey or Jersey so that the flight is split into two sectors from and to a non EU-ETS airport?

Before you go changing anything
 

Just a warning to one man band'ers that are struggling with the paperwork, don't remove those international flights just yet. EU States have to ratify Mrs Hedergaards plan to pacify. Now apparently there is a backlash from the local airlines that this is a little unfair.
Either way, your going to end up having to do the grunt work paper wise and play ETS trader later.

Man I wish I could just fly.

NJE1MD - I'm probably wrong but I suspect with the longest sector in the EU to be around 4 hrs there would be no advantage in stopping in the Channel Isles. I haven't done the sums but the additional cost of handling etc may offset any savings in the EU-ETS charges/tax.

mattman - I learnt a long time ago not to throw away/delete anything. I'm just keeping my head down and doing all the recording. I would be amazed if all 27 Countries agreed.

My biggest worry is what may happen with N reg operators when the US sorts out the regulation banning us from taking part.
M.E.

Do you mean there really are people that ARE actually paying it????

I have to ask who has finished with this cr@p and surrendered there cO2.

Just had a real heated argument with out national authority telling me to return 4 of my free allowances (only four at current market rates €12.00) in a given deadline but they need 12 working days to achieve this but the deadline is the 30th April.

Anybody else had similar results.:rolleyes:

I've resisted this scheme (dragged kicking & screaming) but did the bare essential to remain in compliance.

We had our plan approved, then they told us we needed to become carbon traders. That was a show-stopper (we're an aviation op, not into trading carbon credits and the dislosure requirements are cumbersome & invasive); despite some resistance and opposition we were able to appoint a proxy to conduct the carbon trading on our behalf.

No credits (we still had our heels dug in), we've adopted the derogation stance (only report inter-European sectors). We got the verification done about a month back and conducted a spot-trade on the purchase of our assessed EUA's (a couple of hundred) due for 2012 recently. So I see us as having done enough to keep these bureaucratic clowns at bay.

We're a Private US-registered global operation that was assigned the UK (we spend quite a bit of time there) for EU-ETS purposes.

I still maintain that it's a giant crock of sh1te however that in itself is not a reason not to be in compliance. My dealings with the ETS folk have clearly shown them to be a crowd of sanctamonious creeps (they send you a bill to cover their operating expenses) - I could imagine nothing worse than to deal with them if they were able to show that you were not in compliance with this ridiculous scheme.

4HP