US Natural Gas: Lessons from BP's Tight Gas Facility in Wamsutter WY
Posted by Gail the Actuary on June 3, 2008 - 10:00am
Topic: Supply/Production
Tags: American Petroleum Institute, coal bed methane, drilling rigs, Haynesville shale, natural gas, tight gas, unconventional natural gas [list all tags]
I recently visited BP America's tight gas facility in Wamsutter, Wyoming on a trip paid for by the American Petroleum Institute. I was the only representative of internet media on the trip. The other reporters on the trip were from AP-Cheyenne, Casper Star-Tribune, and Natural Gas Weekly. On the trip, we spent a day and a half listening to presentations and touring facilities. We also stayed overnight at the facility BP built for visiting workers.

In this post, I will tell a little about what I learned. I will also look at prospects for the future -- both in terms of being able to expand operations and threats to maintaining current production levels.
BP America's Wamsutter Operation - Early Years
The Wamsutter gas field is located in southwestern Wyoming. It is about 55 miles long and 35 miles wide. BP America has had operations there since the mid 1970s. BP is not the only operator in this field, but it is the largest one.
Wamsutter's gas is tight gas -- It has low permeability (.01 md) and low porosity (< 12%). Hydraulic fracturing ("fracing") is needed to get the natural gas out. Compared to conventional gas, wells need to be spaced closer together because gas does not travel far in such a tight formation. The initial internal pressure of a well can be high, but drops off quickly. Natural gas production also start off high, but quickly drops. Wamsutter gas is sweet gas--without H2S (hydrogen sulfide).
The produced natural gas has water with it. Once the pressure of a well declines, external energy inputs are required to separate the gas from the water. The energy source BP and other companies in the Wamsutter gas field have been using for many years is electricity from solar panels. BP is now considering adding windmills as an additional source of external energy.
The reservoir depth is about 10,000 feet. At this depth, there is a layer 500 feet thick, about 20% of which is pay. The productive portion is found in strata as thin as 10 feet thick. The productive strata (the "net pay") together add up to about 60 to 100 feet of the 500 foot layer.
In the early years, BP's approach to extracting natural gas was similar to that used for conventional gas. Individual vertical wells were drilled, with 8 wells per square mile (80 acre spacing). From the air, the arrangement looked like this:

This arrangement was very costly to service and maintain, in part because BP was responsible for building the roads to the wells. In addition, service people needed to visit each well individually. Pipelines were needed to each well. Separate tanks and other infrastructure were also needed for each well.
Besides well arrangements, BP followed industry practice in other respects. When prices were relatively high, it would rent more drilling rigs and increase the number of wells drilled. When prices decreased, it would lay off workers, stop renting rigs, and let production level off or fall.
BP America's 2005 Wamsutter Investment Program
In 2005, BP made a decision to change the way it managed the Wamsutter gas field. Instead of simply following the conventional gas drilling model, it would put together its own model, one more in line with maximizing productivity as a tight gas facility. BP announced that it was planning to invest $2.2 billion in the field, to raise production from 125 million to 250 million cubic feet a day, before 2010. Of this, $120 million was investment in improving technology.
One of the major things BP decided to change was well spacing. Instead of drilling eight separate wells on individual pads within an area one mile square, it would consolidate up to eight wells onto a single pad, and arrange the pipes so they still drained the same area one mile square. This way, much less land would be disturbed and many fewer roads would be needed. Other infrastructure could also be consolidated and servicing costs would go down.
In order to make this change, BP needed drilling rigs that would drill "deviated" wells - that is, wells that angled off, then down, so that the surface portion of the wells could be placed on a single pad, while the wells themselves were spaced out, like the legs of a daddy long legs spider. The drilling rigs also needed to be capable of drilling one well, and then moving to the next, without being taken apart, transported a few feet, and put back together again. Since rigs are rented by the day, the several days that rigs are out of service during the take-down and set-up would add greatly to the cost.
In order to get rigs of the proper specifications, BP found it was necessary to work with manufacturers to produce rigs suited to its needs and then sign long-term leases on the rigs. BP decided to lease seven rigs--three from Helmerich & Payne, and four from Nabors, at rates averaging approximately $30,000 a day.

Besides having the proper specifications, the new drilling rigs are much more automated. The "dog houses" are air conditioned and relatively quiet. Operators need to be highly trained individuals, instead of traditional "roughnecks".

As part of the 2005 initiative, BP made a decision to staff at a fixed level--the level of operations that the seven drilling rigs on long-term contracts could support. With this approach, there would be no more lay-offs, even if the price of natural gas declined. Besides fitting with the long-term contracts on the rigs, this approach had the benefit of providing a more stable working environment for employees.
Prior to the 2005 initiative, the community of Wamsutter had a population of 261, and had few amenities. The homes were mobile homes, each with its own well. BP decided that this needed to change, if Wamsutter was to be an inviting place for educated workers to live. Starting in 2005, BP began helping Wamsutter add services. Some of the projects BP has helped fund include water and sewer systems, road improvements, a day care, and a park.

In order to have educated workers, BP has also contributed $500,000 to Western Wyoming Community College, to enhance the college's oil and gas technology program and $5 million to University of Wyoming's School of Energy Resources.
Other Technology Enhancements
Besides shifting from individual wells to grouped wells, BP has been pursuing other types of research:
• Remote monitoring. Years back, service people needed to drive around in a truck to check each well individually. Now most of the relevant information is transmitted electronically, so that a visit is required only if there is a problem.
• Electrification of wells. Electricity is needed at the well site to separate natural gas from the water produced with it and to transmit monitoring information to the office. The original approach, used by BP and others, was to use a single solar panel and battery for each well. Now that BP is grouping wells on a pad, BP uses a larger grouping of solar panels together with several batteries, to provide longer backup. BP is considering adding a windmill to some pads, as an additional source of energy.
• Cordless seismic imaging. BP has worked with outside contractors on what it calls Firefly(R) land seismic imaging system. With the old technology, seismic imaging systems needed to be plugged into electric power at a proposed well site. This was a problem, since there are no electric power lines in most areas being tested. The new system uses battery operated units which transmit signals to the office.
• Horizontal wells. BP's current wells are basically vertical wells, adjusted for the need to have the surface units located on a single pad. BP is planning to test horizontal wells, to see how the economics of these wells compare with the current approach.
Well Productivity
The written material we were provided indicates that with BP's new technology, hydrocarbon recovery has been increased by up to 40% and drilling costs have been reduced by up to 50%. I do not know to what base this comparison is being made, but I can believe that costs have been brought down substantially.
We were not provided with an estimate of the expected recovery per well, but I tried to compute one from various information given at the presentation. I came up with a range of about 900 million to 2 billion cubic feet of natural gas per well. This seems like a fairly respectable level, compared to estimates for other natural gas producers.
One figure that is fairly easy to calculate is average annual gas production per operating well, including wells that were drilled years ago. In this calculation, only natural gas "not associated" with petroleum production is used. One can compare this statistic to statewide averages, using EIA statistics for natural gas production and number of wells.
For BP Wamsutter, the information provided suggests the average annual production per operating well is currently about 68 million cubic feet per well ((240 million x 365 days)/1,282 wells). If wells have an average life of 30 years, and this average continues to hold, this would suggest ultimate recovery averaging just over 2.0 billion (=30 x 68 million) cubic feet per well. One could get a similar number with a 40 year life and a lower annual average.
One thing I noticed when looking at EIA data is how much average production per well varies from state to state (Figure 6). Ohio, Pennsylvania, and West Virginia all have very low averages--about 3 or 4 million cubic feet per year. I expect this production is coal bed methane. If these wells have a 40 year life span, one might expect ultimate recovery of 140 million cubic feet per well (=40 x 3.5). I find it hard to believe that wells with this low level of productivity could be profitable. Yet developers seem to view these wells as at least marginally profitable--the number of wells in these states has been increasing in recent years.
In contrast, Figure 6 shows Wyoming's average annual production per well is above the US average (excluding these states with very low average production rates). BPs Wamsutter's average of 68 million cubic feet is in line with both the Wyoming average and the US average excluding Ohio, Pennsylvania, and West Virginia.

Production Costs
We were not given an accounting of costs that go into producing BP's tight gas, but it appears that drilling costs are a smaller percentage of the total than for conventional gas. Items which would contribute to BPs costs include the following:
• Drilling costs. We were told that the individual wells costs in excess of $2 million. I am not certain which costs are rolled into this calculation. The seven drilling rigs are rented at rates averaging $30,000 a day, and these seven drilling rigs in total drill 150 to 170 wells a year.
• Seismic imaging. Imaging is needed at each proposed well site.
• "Fracing" of wells. BP uses two portable rigs for this operation. I would presume these rigs are considerably less expensive than the seven drilling rigs on long-term lease.
• Long term lease for the large amount of land held. Costs may be low, since the same land can be used for agricultural purposes (grazing cattle, etc.)
• Roads to service the wells. Roads are gravel and need to be regraded when affected by washing.
• Travel of service people to wells. We were told that while this amounted to 1,000,000 miles per month in the past, it has been reduced to 800,000 miles per month through greater use of long distance monitoring.
• Technology research. BP has allocated $120 million for research, over a five year period.
• Well infrastructure and replacements. Each well or group of wells contains equipment for separating the extracted material into its components, holding tanks, monitoring equipment, solar panels, and battery back-ups. If wells have a 40 year life, replacements will be needed for many reasons--corrosion, solar panel theft, battery life, etc.
• Pipelines and compressors. Pipelines are needed for natural gas transmission. Compressors use natural gas for power, since electricity is rarely available in Wyoming.
• Office. Building for people overseeing natural gas production. Also warehouse for supplies.
• Residence facility. Since nearby living facilities are very limited, BP built a residence facility for workers who desire to stay there. It provides meals, recreation and laundry for up to 200 workers. The cost is at least partly offset by charges to workers using the facility.
• Assistance to Wamsutter. BP has been active in setting up a city a water system, building a day care, and finding a person to coordinate town development. Part of this is funded by BP; part is funded by Wyoming state agencies.
• Funding for University Training Programs. Noted previously.
• Taxes. Material provided indicates that in Wyoming (not just Wamsutter), these were $60 million in 2005, plus $170 million in federal royalties.
• Cost of money. Most of the expenses are front end expenses. Either funds need to be borrowed, or there is an opportunity cost in using funds that might be invested elsewhere.
We were told that in total, there are 750 to 900 workers at the BP site in a typical month. Of these, only 150 are actually BP employees. The rest are contractors of various types.
Future Prospects for BP Wamsutter
The company generally seems to be well situated. It is taking an approach of trying to learn as it goes, and incorporating new technology to hold down costs.
The company says that it has produced about 3 trillion cubic feet of natural gas since 1977. This represents less than 20% of the resource available in BP's portion of Wamsutter field. We were told that gas wells from the 1970s are still flowing.
To date, the spacing of the wells has been one well per 80 acres. BP has filed for approval to change the spacing to one well for 40 acres, and is in the process of getting necessary approvals. With this spacing, BP can put up to 16 wells on a pad, instead on 8. It can also add infill wells to previously drilled areas. BP's research indicates that in some portions of the field, flow rates will be adequate with the closer spacing.
Based on what BP has done to date, BP seems to be in a good position to increase production in the future, if it chooses to. For example, it could decide to increase the number of drilling rigs it operates by one or two in say, 2011. If it were to make such a decision, it would need to order new rigs sufficiently in advance, and sign additional long term leases. It might need to make increases in other areas as well--more employees, more support for the Wamsutter community, greater office space, and perhaps a larger residence for visiting workers.
I don't know whether BP would choose to make such an increase in production, however. With its current "level load" philosophy, BP could choose not to add capacity. Instead, it might extend the number of years over which it can produce gas further into the future.
I think issues which would tend to hold back BPs Wamsutter production are peak oil issues and possibility water shortages.
Wamsutter is in a remote location. At present, it has a population of about 600. It does not have a grocery store, any medical services, or a hotel. Many of the workers live as far as 70 miles away, in order to have basic services. Even those who live nearby make many long car trips to purchase necessities. All of this is very oil dependent.
BP Wamsutter's natural gas operations are also quite petroleum dependent. The service people visit the wells in trucks; the drilling rigs are powered by diesel fuel. Grading of roads requires diesel. All of the supplies are brought by truck from distant locations. Visitors generally fly into Rock Springs, a tiny airport 70 miles away. Cutbacks in the availability of oil could affect all of these oil uses.
Regarding water scarcity, Wamsutter is in the Red Desert. It gets 8 inches of rain a year. The Rock Springs newspaper was full of stories about water issues when I visited. For example, it talked about well levels for existing homeowners dropping when new wells are added. Clearly, Wamsutter cannot be self-sufficient in growing its own food. It will need to have nearly everything brought in by truck. If residents try to pump more than the aquifer can handle, there could be a serious problem. Increasing the number of resident is likely to make the water problems worse, sooner.
Possibility of Others Ramping Up Production
What is the possibility of others jumping in and ramping up production in another tight stands location?
Shale gas is different, but I don't know how different. I suspect that some of the issues might be similar with Hayneville shale, which now seems to have the possibility of increased production.
My guess would be that if anyone wants to ramp up production quickly, it will not be easy. The number of rotary drilling rigs in use for natural gas in North America has stagnated in the last year. One reason for this may be the competition from oil, since the higher price is drawing rigs toward oil. Another reason may be that the more popular rig types are already close to full utilization. If this is the case, a company wishing to ramp up production quickly might need to make do with whatever happens to be available, even if it is not optimal for the particular application.

Three of the rigs used by BP are manufactured by Helmerich & Payne. A check of its website indicates that in the past year, its land rigs were 97% utilized.
Clearly trained workers are another issue, especially with unconventional gas. Unconventional gas is expanding so rapidly that there are not enough workers to go around.
I have listed some other costs that BP has encountered, such as building roads, getting pipelines laid, and doing seismic testing. Depending on the location, a new company would need to deal with many of these issues. These are likely to take time and money, and may delay production.
I would expect that much of the research would be skipped, so as to start production quickly. Because of the important role technology plays, this could easily mean the difference between a profitable operation and an unprofitable one.
Putting these things together, it seems like ramping up production of tight gas will be a challenge. There is likely to be a delay of at least three years just to get all of the basics covered. Skipping research puts the new producer at risk of a much lower profitability level. And of course, the new producer will have to deal with the impacts of peak oil, just as BP will.
Previous Post
An earlier post I wrote, giving background information, can be found here:
US Natural Gas: The Role of Unconventional Gas
BP Presentation
BP provided a press version of one of the presentations that I saw. I have permission to post it:



1 acre = 0.0015625 sq mile
So 8 wells/sq mile
or
8 wells/acre ?
Which is it? Otherwise a nice article.
It is 8 wells per section. A section is 640 acres.
A BP presentation I found on the internet had the 1 mile by 1 mile graphic. I presume 640 acres is equivalent to 1 mile by 1 mile, but haven't checked.
I found the place I said "per acre" instead of "per square mile" and fixed it.
Correct, in terms of area, 640 Acres = 1 square mile = 1 Section
http://www.metric-conversions.org/area/acres-to-square-miles.htm
Land survey Jargon (In US and Canada):
A square mile, or an acre, can be any shape, but a Section (as in a Section of a Township) must be a square with a side length of 1 mile.
A Township is a square shape with a side length of 6 miles i.e. contains 36 Sections.
Thanks again for all you do Gail. Your efforts have enhanced the TOD experience greatly.
Could they not design the facility to be self sustaining through NG use,Electricity generation, NG powered transportation, etc?
I suppose they could use the natural gas to be sustainable, but they haven't started yet.
BP mentioned that some types of drilling rigs run on natural gas rather than diesel. I am not sure if they could get the type of drilling rig they needed on this basis. Perhaps their current rigs could be adapted to run on natural gas.
When I visited Shell's offshore drilling platform, it had a big electrical power plant built in that ran off produced natural gas. It powered all of the operations on the platform. The same thing could be done in Wamsutter, if someone got to work and did it.
I think there is a possibility on the NG transportation, but one has to get started on it in advance. Part of the problem is all of the workers need to be housed and fed, and the food has to come from somewhere. There are a lot of necessary chains that could break down. Lieblig's law of the minimum is what may come into play rather quickly. If by any chance there is rationing, some part of the chain is likely to get left out.
If a gas field's energy inputs could be suddenly and miraculously switched over to natural gas, the EROEI calculation could be replaced by a simpler figure for net gas "exported" to the world from this field.
If a time were to arrive when much or all of the field's gas output would be consumed for its own operation, there would clearly be no further benefit to keeping the field in production.
I'm curious as to whether transportation of equipment, personnel and energy products themselves is actually a significant factor in EROEI and/or profitability. If so, then the geography of production and consumption is likely to play an increasingly important role in energy economics.
Maybe it will emerge after a sufficiently detailed analysis that local solar and wind installations are more competitive than expected when compared with distant sources of fossil energy. One can hope.
I guess there is a gas plant hanging around out there.
A green one, that grows gas?
" Two natural gas wells plus solar panel"
well that's something to think about.
I was surprised to see solar panels everywhere I went. It wasn't just BP gas wells with them. Gas wells operated by other folks had them also. I believe they said they had been doing this since the late 1970s.
These solar panels are sitting on the ground, unguarded, in an area where there are very few people. It would be very easy to walk off with them, and I understand that this has happened from time to time. As people have more need for solar panels, I expect this will be more of a problem. This may be why BP is looking at windmills.
do the solar panels provide ALL the electricity needed to run the pumps, etc? I assume that it is also grid connected? or not....?
What grid? We are in the middle of nowhere.
I think there may be some natural gas burned for some portion of the energy in the separation process. I am not entirely clear on this. I could probably get a clarification.
There are some waste gasses that are burned. I know that there was mention of the possibility of using these for energy, but there seems to be a problem with regulators not liking this approach so far.
Like Gail said, these are not grid connected. As such, they require unusually large batteries to maintain reserves during the winter months. In fact, they typically mount the solar panels vertically, since that way they shed snow, and the only important months to consider angle of incidence is December/January. Until recently photovoltaic panels on oil and gas wells were the #1 source of demand in Canada.
I suspect the interest in windmills is to try and get more winter energy, and hence scale back the battery packs.
"do the solar panels provide ALL the electricity needed to run the pumps?"
gas wells are not usually equiped with pumps.
if you are refering to compressors, no these are fueled with ng(hundreds or thousands of hp).
it would appear that the solar panels are for monitoring and control equipment.
What you say sounds right. I received a copy of one of the presentations this afternoon, and was trying to understand what it says about electrification.
According to the presentation, electricity is used for monitoring and for what BP calls "automation". Automation may be monitoring, translated to some action when the monitored results are out of a specified range--perhaps what you call "control equipment".
In the description of electrical use, I also found reference to something saying "power for gas lift pilots". BP has a pilot program in which it is temporarily pumping some of the gas back in (I think) in an attempt to raise production. This is related to deliquification. See slide 14 of the presentation. This may be another use of the electricity.
You mention natural gas being used to run compressors. One use of the compressors would be to make gas move through the pipes. Would compression also provide power for the separation process (into condensate, natural gas, water, and waste gasses), or does this happen some other way? I was originally under the impression that electricity was somehow used in the separation process, but I could be wrong on that. Perhaps it was only the pilot gas lift problem that was being referred to.
In other installations that I've seen, the solar cells provide power for two purposes...
This requires very little power. You could put a small genset at the wellpad, but that would be equally expensive, less reliable (more moving parts), more polluting (noise as well as CO2), it would cut into your revenue stream, and (important!) it would have problems providing cold start service (no gas => no power).
The solar cells and microwave save you from having to run power and C&I cabling to every wellpad - a considerable cost (and theft risk!) in such a geographically spread-out operation. Solar couldn't provide anything like enough power for any serious process or lift energy input, though you might be able to do something along those lines with windmills.
"Pilots" in Gail's context probably refers to pilot valves (small valves which allow the main valves to be opened by flow or process pressure).
thanks. very interesting.
I wonder what % of our gas (conv/unconv) is off the grid like that and requires ecosystem services (solar flows) to harvest fossil fuels....?
Clearly everything offshore is off grid. I think they pretty much burn natural gas for power, though.
I am not sure how one would go about quantifying the rest. Most of the Colorado/Wyoming/Utah/Montana natural gas production would be off grid, and much of Canada that is not in major cities.
Natural gas wells are so spread out that it probably does not make sense to string electricity to them, unless it is already there (Barnett Shale in Dallas?). I would wonder if some of the shale gas production from Eastern states will end up being off grid. It is very expensive and time-consuming to get electrical grid wires put up, if wires are not there already.
Pennsylvania is so heavily populated and has such extensive infrastructure (from power to phones to water to gas to taverns for the workers) that you can handle things pretty well. The gas in Pennsylvania has the advantage that it is very close to markets and does not have to depend on a pipeline to move it.
They sometimes don't even bring the gas to market, they just power a diesel generator with the power on site for factories, schools, etc. The waste heat comes in handy during winters.
You seem to be talking about building electric power plants (often with cogeneration, to share waste heat) at the location of the gas. I knew that this was done with coal; I hadn't thought about it with gas.
The thing that then needs to be built is electric transmission lines. I have seen comments that when new gas power plants are built, the plants can be up in 18 months but the transmission lines can take 5 to 10 years. Hopefully the problem is not that bad, but lagging transmission lines can be a problem.
i think your questions were pretty well answered by the posters upthread.
bp is using gas lift, meaning that some of the wells are producing liquids, either free water or condensate. in a gas lift operation, dry gas is injected into the tubing casing anulus to lighten and accelerate the flow stream, allowing the well to flow. this would require a compressor on site or nearby.
dehydration would require electrical imputs as well. dehydration is probably accomplished either by cooling the gas stream or by desiccation(glycol absorption). in a desiccation cycle, heating would also be required. the heat cycle would be fired by ng. another means of dehydration uses a "molecular seive". at the very least electricity would be used for operating the process and control equipment.
those are probably dehydrators shown in the photo.
that kind of flips things a bit. we rely on solar for our natural gas and maybe soon wind. any geothermal prospects for these wells?
Geothermal I think is a way of making electricity. You need transmission wires for electricity, and that would get very expensive. That is the reason for local generation-solar or wind.
I'm talking on-site geothermal like they do with some oil wells I've seen.
I was not aware that on-site geothermal is used with some oil wells. It would seem like there would have to be "hot rocks" fairly close below the wells. One would have to have a drilling rig that could dig the well of the appropriate depth. Where is geothermal used with oil wells?
Where is geothermal used with oil wells?
AFAIK, nowhere. Anyone care to quote a counterexample? Anyone care to quote several counterexamples?
Edited after posting - OK, john15 below quotes two (his first link seems dead), but the scale is tiny
Geothermal wells produce large volumes of dry steam, wet steam or at least boiling water from hot, fractured igneous rock. Lots of heat. There isn't enough thermal energy in oil well or gas well effuent to make it anywhere near economic to harness it - even if the price of electrical power goes up by an order of magnitude.
IIRC the really hot petroleum basins are on failed rift axes (e.g. North Sea) or hotspots like the South China Sea. Offshore operators aren't going faff around retrofitting heat exchangers, turbogenerators and condensers to production platforms.
Scale is tiny because demand is tiny. Only enough power for one oil or gas well. At this level you consider thermoelectric or solar. The thermoelectric power of condensing the steam from the gas stream is enough to pump the water out of the condenser and into a nearby stream or sump. Solar and a battery seems to be cheaper at this time.
Also, please keep in mind that in this Wyoming case, the area is a literal desert. Any water used for goethermal or other steam cycle processes would likely have to be transported to the site. Solar or wind are being used as Gail noted in the main article. One reason for this is the lack of water. Another is that the use of an outside energy source is small during ordinary production and only on demand for safety shut-off.
I had a video of geothermal coupled with an oil well but I can't find it.
here are some links.
http://peswiki.com/index.php/Directory:Geothermal_Oil_Wells
http://www.renewableenergyworld.com/rea/news/story?id=49161
http://www.hydrogencarsnow.com/blog2/index.php/hydrogen-production/geoth...
the youtube vid is no more.
I find it highly unlikely that they are looking at windmills. Import grain to export flour? Use wind power to directly pump ... water? natural gas mebbe?
Like I say, I find windmills unlikely.
Perhaps wind turbines?
It is quite windy there. I think there are talking about little windmills, that would help keep the bank of batteries for each natural gas well grouping charged. They may be more like the windmills we used to expect on each farm for pumping water for animals.
If they are turbines generating electricity, they are not called windmills ... windmills translate wind power into direct mechanical energy for a device, like a water pump or, as in the source of the term, grain mill.
You are talking about wind turbines.
Windmill is still a useful term ,as without using it it is difficult to differentiate between the nacelle on a wind tower and the complete structure.
A wind turbine, strictly speaking, excludes this.
Words do change in their application, you know, and no-one seriously imagines that any corn is ground in a modern array.
Gail,
Thanks very much for this, this has allowed me to better understand tight gas.
Do you or anybody know what's happening to me in the following picture?
I went to the link you posted for spreadsheet data on Nat Gas from the EIA. I copied column A (1967-2006) and B (U.S. Natural Gas Gross Withdrawals from Gas Wells (MMcf).
But when I pasted them into a new excel sheet, what was supposed to start at 1967, instead started at 1971. The production column pasted in ok.
Also, the 2 EIA data columns only go to 2006, I selected and copied only the 1967 -2006 info, but my new spreadsheet pasted-in info up to 2010. WTF?
Please help anyone, do I have some preference selected that I shouldn't? This has happened before.
I had some similar problems when I tried copying from Baker Hughes data.
In that case, the Excel date data seemed to be in a different format between the two spreadsheets. (I don't know if this had to do with MacIntosh vs PC, or new version of Excel vs old version of Excel). When I looked closely at the data, I realized that the copied number were skipping groups of dates, so the numbers were not lining up properly. It was as if the dates were recorded as a formula, and the new spreadsheet was interpreting the formula incorrectly.
For what it is worth, I was also using information from Table 6.4 found here. One thing I found annoying was changing definitions between sources regarding where the offshore gas is. This is one reason I did not try to look at Texas and Louisiana.
Thanks Gail. What I did was just use the downloaded EIA sheet for pasting additional data into. When pasting between EIA sheets all went well. Although I wish I could figure this problem out.
Again, nice work.