#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 194
Default Math Formula

I guess I need to get a life or something. Been watching this thing on
global warming and I need to see some numbers to believe what is being said.
Al Gore has said that if either Anartica or Greenland were to melt
completely the oceans would raise 40 feet. He even showed maps of the ares
that would be underwater if that were to happen.
The area of Greenland is 836,330 sq Miles.
The area of Anactica is 5,500,00 sq miles
The area of the oceans of the world is 196,935,000sq miles(surface of the
earth)*.71(percent of the area of the earths surface that is
water)=139,823,850sq miles.
My question is how do I figure out how many feet of ice above sea level is
required on either of these places to raise the water level of all the oceans
40 ft?
Not home work guys, would love to be in school but that was over to many
years ago. Just trying to see if these "facts" can be validated.

Mike Rogers
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default Math Formula

I think you're asking the wrong question.

1) The relevant question is: What is the volume of water required to raise
sea levels by (say) 40 feet?
2) Does Antarctica and Greenland have an amount of water equal to that volume?

I don't know how you would answer question 2, however, because ice
compressed a mile or so below the surface ice has a much higher density than
the surface ice, so converting the volume of ice to the density of liquid
water is at best an estimate.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mike Rogers" wrote:

I guess I need to get a life or something. Been watching this thing on
global warming and I need to see some numbers to believe what is being said.
Al Gore has said that if either Anartica or Greenland were to melt
completely the oceans would raise 40 feet. He even showed maps of the ares
that would be underwater if that were to happen.
The area of Greenland is 836,330 sq Miles.
The area of Anactica is 5,500,00 sq miles
The area of the oceans of the world is 196,935,000sq miles(surface of the
earth)*.71(percent of the area of the earths surface that is
water)=139,823,850sq miles.
My question is how do I figure out how many feet of ice above sea level is
required on either of these places to raise the water level of all the oceans
40 ft?
Not home work guys, would love to be in school but that was over to many
years ago. Just trying to see if these "facts" can be validated.

Mike Rogers

  #4   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Math Formula

I will round a bunch
40 feet = .007576 miles
..007576*140,000,000 = 1,000,000 cubic miles of water
total surface area antartica 5,500,000 square miles
1,000,000/5,500,000 *5280 just under 1000 feet
Total surface area green land 800,000 square miles
1,000,000/800,000 * 5280
6600 feet thick
the ice sheets in Greenland and antartica are estimated as being over 2
miles thick



"Mike Rogers" wrote:

I guess I need to get a life or something. Been watching this thing on
global warming and I need to see some numbers to believe what is being said.
Al Gore has said that if either Anartica or Greenland were to melt
completely the oceans would raise 40 feet. He even showed maps of the ares
that would be underwater if that were to happen.
The area of Greenland is 836,330 sq Miles.
The area of Anactica is 5,500,00 sq miles
The area of the oceans of the world is 196,935,000sq miles(surface of the
earth)*.71(percent of the area of the earths surface that is
water)=139,823,850sq miles.
My question is how do I figure out how many feet of ice above sea level is
required on either of these places to raise the water level of all the oceans
40 ft?
Not home work guys, would love to be in school but that was over to many
years ago. Just trying to see if these "facts" can be validated.

Mike Rogers

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 194
Default Math Formula

bj

Thanks for the input. I used your "rounded" formate to do my calculations.
What I understand you are saying is that: If there is over two miles of ice,
I am assuming that is at its thickest point, then the 6687.49 feet would
probably be within the average thickness over the entire area. So it is
probibly a believeable statement to sat that if it were to melt it would add
40 feet to the oceans.

It still does not seem to fit when one considers the fact that Greenland is
..60% of the size of the water area and Antartica is 3.93% of the water area.
I am not saying it is not right, just that the proportions seem wrong. I
will "ponder" it some more and post back if I need to. Thanks again for your
help, it is greatly appreciated!!!!

Mike Rogers


"bj" wrote:

I will round a bunch
40 feet = .007576 miles
.007576*140,000,000 = 1,000,000 cubic miles of water
total surface area antartica 5,500,000 square miles
1,000,000/5,500,000 *5280 just under 1000 feet
Total surface area green land 800,000 square miles
1,000,000/800,000 * 5280
6600 feet thick
the ice sheets in Greenland and antartica are estimated as being over 2
miles thick



"Mike Rogers" wrote:

I guess I need to get a life or something. Been watching this thing on
global warming and I need to see some numbers to believe what is being said.
Al Gore has said that if either Anartica or Greenland were to melt
completely the oceans would raise 40 feet. He even showed maps of the ares
that would be underwater if that were to happen.
The area of Greenland is 836,330 sq Miles.
The area of Anactica is 5,500,00 sq miles
The area of the oceans of the world is 196,935,000sq miles(surface of the
earth)*.71(percent of the area of the earths surface that is
water)=139,823,850sq miles.
My question is how do I figure out how many feet of ice above sea level is
required on either of these places to raise the water level of all the oceans
40 ft?
Not home work guys, would love to be in school but that was over to many
years ago. Just trying to see if these "facts" can be validated.

Mike Rogers



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 194
Default Math Formula

Dave F

Thanks for the post. As I research this I am finding there are a lot of
variables. I think your point €śat best an estimate€ť is what I am going to
end up with. Thanks for the thoughts.

Mike Rogers


"Dave F" wrote:

I think you're asking the wrong question.

1) The relevant question is: What is the volume of water required to raise
sea levels by (say) 40 feet?
2) Does Antarctica and Greenland have an amount of water equal to that volume?

I don't know how you would answer question 2, however, because ice
compressed a mile or so below the surface ice has a much higher density than
the surface ice, so converting the volume of ice to the density of liquid
water is at best an estimate.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mike Rogers" wrote:

I guess I need to get a life or something. Been watching this thing on
global warming and I need to see some numbers to believe what is being said.
Al Gore has said that if either Anartica or Greenland were to melt
completely the oceans would raise 40 feet. He even showed maps of the ares
that would be underwater if that were to happen.
The area of Greenland is 836,330 sq Miles.
The area of Anactica is 5,500,00 sq miles
The area of the oceans of the world is 196,935,000sq miles(surface of the
earth)*.71(percent of the area of the earths surface that is
water)=139,823,850sq miles.
My question is how do I figure out how many feet of ice above sea level is
required on either of these places to raise the water level of all the oceans
40 ft?
Not home work guys, would love to be in school but that was over to many
years ago. Just trying to see if these "facts" can be validated.

Mike Rogers

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 194
Default Math Formula

Sandy Mann

That is an area that I think I will leave to some one else. <g The
variables there would be endless. The first one that hits me is how deep
would the temp change go and what are the steps in that temp according to
depth? Then what part would the ocean currents play in the mix? Good thought
tho. Thanks!!

Mike Rogers

"Sandy Mann" wrote:

According to one programme I saw on global warming, the expansion of the
oceans due to the rising temperature of the water will have a much greater
effect than the melting in all of the ice at both poles.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Mike Rogers" wrote in message
...
I guess I need to get a life or something. Been watching this thing on
global warming and I need to see some numbers to believe what is being
said.
Al Gore has said that if either Anartica or Greenland were to melt
completely the oceans would raise 40 feet. He even showed maps of the
ares
that would be underwater if that were to happen.
The area of Greenland is 836,330 sq Miles.
The area of Anactica is 5,500,00 sq miles
The area of the oceans of the world is 196,935,000sq miles(surface of the
earth)*.71(percent of the area of the earths surface that is
water)=139,823,850sq miles.
My question is how do I figure out how many feet of ice above sea level is
required on either of these places to raise the water level of all the
oceans
40 ft?
Not home work guys, would love to be in school but that was over to many
years ago. Just trying to see if these "facts" can be validated.

Mike Rogers




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel math formula dan Excel Worksheet Functions 4 October 30th 06 04:51 PM
simple math formula Gabriel Excel Discussion (Misc queries) 3 August 25th 06 03:25 PM
math formula with upper and lower limits on data but also ranges kenneth Excel Worksheet Functions 3 February 8th 06 01:10 PM
In Excel, I need a date math formula... Lisa Excel Discussion (Misc queries) 2 December 3rd 04 12:13 AM
How do I do math on a cell name in formula? Mark Mulik Excel Worksheet Functions 3 November 23rd 04 03:43 PM


All times are GMT +1. The time now is 06:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"