| |
 |
|
|
Science Forum Index » Geology - Earthquakes Forum » Spread Sheets
Page 1 of 1
|
| Author |
Message |
| Weatherlawyer |
 Posted: Mon Mar 24, 2008 9:31 pm |
|
|
|
Guest
|
I have added a list of lunar phases to Google Spread sheets. It is
available at:
http://spreadsheets.google.com/pub?key=p_WU4hvc6p3XkQl_cIURANA&output=ods
as an "Open Office" sheet.
The last column indicates which hour the phase fell or falls on. You
create your own version if you want to sort them into similar hours or
spells. And you can do that by sorting them by that last columns.
I'd have done it myself only one loses the year if you do them en
bloc. You'd have to sort them year by year to be able to make sense of
the results |
|
|
| Back to top |
|
| Guest |
| Posted: Tue Mar 25, 2008 2:56 pm |
|
|
|
|
On Mar 25, 12:31 am, Weatherlawyer <Weatherlaw...@hotmail.com> wrote:
Quote: I have added a list of lunar phases to Google Spread sheets. It is
available at:http://spreadsheets.google.com/pub?key=p_WU4hvc6p3XkQl_cIURANA&output...
as an "Open Office" sheet.
The last column indicates which hour the phase fell or falls on. You
create your own version if you want to sort them into similar hours or
spells. And you can do that by sorting them by that last columns.
I'd have done it myself only one loses the year if you do them en
bloc. You'd have to sort them year by year to be able to make sense of
the results
I have one which lists full and new moon date and time from 1768 to
2015 and each one has a year so you can sort the whole file at once.
It's in comma separated format so Excel can read it too.
Roger |
|
|
| Back to top |
|
| Weatherlawyer |
| Posted: Wed Mar 26, 2008 12:07 am |
|
|
|
Guest
|
On Mar 26, 12:56 am, rog...@lpbroadband.net wrote:
Quote: On Mar 25, 12:31 am, Weatherlawyer <Weatherlaw...@hotmail.com> wrote:
I have added a list of lunar phases to Google Spread sheets. It is
available at:http://spreadsheets.google.com/pub?key=p_WU4hvc6p3XkQl_cIURANA&output...
as an "Open Office" sheet.
The last column indicates which hour the phase fell or falls on. You
create your own version if you want to sort them into similar hours or
spells. And you can do that by sorting them by that last columns.
I'd have done it myself only one loses the year if you do them en
bloc. You'd have to sort them year by year to be able to make sense of
the results
Which I would have posted to share on Google Docs only the damn thing
only allows a small quota of data imported. The file I am working on
is humongous. I shall have to find a web page to store it on or offer
an e-mail of it.
Quote: I have one which lists full and new moon date and time from 1768 to
2015 and each one has a year so you can sort the whole file at once.
It's in comma separated format so Excel can read it too.
You can download the full set going back millenia at:
http://sunearth.gsfc.nasa.gov/eclipse/LEmono/TLE2008Feb21/TLE2008Feb21.html
Courtesy of Mr Fred Espenak.
No apologies for the length of the following:
I had quite a job sorting them until I realised how you can save them
in "text" format by pasting as "Paste Special". In Calc (ODF.) The
process is to highlight the shown example by clicking the
representative sheet in the top right hand cell and selecting Text
from the drop down menu.
Badly designed feature in my opinion but characteristic of all spread
sheets I gather.
You choose cell separators in the same menu box (the default is Tab)
but space delimits can be chosen as can one of your own choice.
You can also choose to merge delimiters if there ar too many spaces.
You may want to save text separately in Writer (ODF) if you choose the
latter.
A major problem with ODF and large files is that they tend to hang (in
imitation of BSOD) on Windows boxes. No idea how well behaved it is on
Linux, Mac or Unix.
The trick then, is to allow the bloody things plenty of time to sort
themselves out each time you highlight, each time you copy and each
time you paste. It's like playing with a 486 box after using a quad
core. And this is with 1 GB of RAM on a twin quad.
(AMD; what do Intel chipsets do? I bet they have less strictures,
being in bed with the evil Lord of the Dark Side.)
You have to wait until your PC stops gurgling/choking, each step of
the way.
****
The point is that I want to analyse the data against a backdrop of
severe storms and with large magnitude earthquakes. And I really do
find it all quite a drag. If I was able to manage DataBase, I think I
might be a lot happier. I have just discovered how to invert the
columns by selecting the time cells only and opening them in another
sheet, delimiting by colons and then assigning each hour a letter.
Frustrating there too as the damned programme defaults to this year's
date (and arses-up all the times.) Save as text then copy and paste
special. The same is necessary for moving between spread sheet and
word processor.
(And if you moan about the problem you get overly defensive fan boys
telling you it is the one every default uses so it must be the ideal.
(Feckwits!!!!!!))
Putting the letter at the start of the data for the year then allows
me to sort them all into similar times of phases. Except that the
minutes vary by 59. Which means a time of phase at 1 minute past 5
o'clock is lumped with the times which include one minute to 6
o'clock.
I need to narrow the number of phases down by dividing them into
blocks of ten (or twelve and an half minute sections.) These can then
be merged into 20 or 25 minute intervals and somehow sorted so that
times of phases at ten (or twelve and an half) minutes to an hour are
grouped with times at ten (or twelve and an half) past.
But even with that data, it will be missing this sort of thing:
"An early spring storm system advanced out of the Southern Plains in
mid-March 2008, causing widespread flooding. Strong southerly winds
developed ahead of an area of low pressure located over the Southern
High Plains and drew moisture up from the Gulf of Mexico across Texas
and Louisiana. This warm, moist air collided with a frontal boundary
(the boundary between two air masses of different temperature,
pressure, or humidity) that draped across central Texas into central
Missouri. The convergence produced repeated bouts of thunderstorms and
heavy rain from central Texas through Oklahoma and into Kansas and
Missouri.
This image shows rainfall totals for March 13-20, 2008, based on
output from the near-real-time, Multi-satellite Precipitation Analysis
(MPA) at NASA Goddard Space Flight Center. The analysis is based in
part on data from the Tropical Rainfall Measuring Mission (TRMM)
satellite. Rain extends from central Texas northeastward up into
southern Pennsylvania. The highest rainfall totals (shown in red) are
about 200 millimeters (about 8 inches) and are located over western
Arkansas. A broad area of rainfall of at least 100 mm (about 4 inches,
shown in yellow) covers most of southern Missouri, northwestern
Arkansas, and eastern Oklahoma, with embedded higher amounts on the
order 150 mm (about 6 inches, shown in orange). TRMM does not observe
rainfall with the same level of detail as ground-based rain gauges or
weather radars; instead it sees a broad area at one time. Locally,
there were reports of up to a foot of rain in parts of Missouri. At
least 13 deaths were being blamed on the weather, and numerous rivers
were at or above flood stage across the Midwest.
The ongoing La Niņa (cooler-than-normal ocean temperatures across the
central Pacific) may have contributed to the intense rain event. La
Niņa and its more famous counterpart, El Niņo, can impact U.S. weather
by altering the patterns of the jet stream, especially in the Northern
Hemisphere cold season. On average for this time of year, strong to
moderate La Niņa events are linked to above-normal rainfall from East
Texas and northern Louisiana up through Arkansas and the Tennessee and
Ohio Valleys.
Since 1997, TRMM has been measuring rainfall over the global tropics
using a combination of passive microwave and active radar sensors.
Scientists can use TRMM data to calibrate rainfall estimates from
other satellites. TRMM is a joint mission of NASA and the Japanese
Space Agency, JAXA."
http://earthobservatory.nasa.gov/Newsroom/NewImages/images.php3?img_id=17971 |
|
|
| Back to top |
|
| Weatherlawyer |
| Posted: Wed Mar 26, 2008 2:24 pm |
|
|
|
Guest
|
Name Identifier Basin Start Date End Date 1-minute MSW 10-
minute MSW
Mindulle 10W NWP 23/06/08 04/07/08 125 90
Tingting 11W NWP 25/06/08 04/07/08 75 85
- 02E NEP 02/07/08 03/07/08 25 -
- 01C NEP 05/07/08 05/07/08 25 -
Blas 03E NEP 12/07/08 15/07/08 50 -
Kompasu 12W NWP 13/07/08 16/07/08 45 45
Celia 04E NEP 19/07/08 25/07/08 70 -
Name Identifier Basin Start Date End Date 1-minute MSW 10-
minute MSW
Mindulle 10W NWP 23 June 04 July 125 90
Tingting 11W NWP 25 June 04 July 75 85
- 02E NEP 02 July 03 July 25 -
- 01C NEP 05 July 05 July 25 -
Blas 03E NEP 12 July 15 July 50 -
Kompasu 12W NWP 13 July 16 July 45 45
Celia 04E NEP 19 July 25 July 70 - |
|
|
| Back to top |
|
| Weatherlawyer |
| Posted: Fri Mar 28, 2008 12:25 am |
|
|
|
Guest
|
On Mar 26, 12:56 am, rog...@lpbroadband.net wrote:
Quote: On Mar 25, 12:31 am, Weatherlawyer <Weatherlaw...@hotmail.com> wrote:
I have added a list of lunar phases to Google Spread sheets. It is
available at:http://spreadsheets.google.com/pub?key=p_WU4hvc6p3XkQl_cIURANA&output...
as an "Open Office" sheet.
The last column indicates which hour the phase fell or falls on. You
create your own version if you want to sort them into similar hours or
spells. And you can do that by sorting them by that last columns.
I'd have done it myself only one loses the year if you do them en
bloc. You'd have to sort them year by year to be able to make sense of
the results
I have one which lists full and new moon date and time from 1768 to
2015 and each one has a year so you can sort the whole file at once.
It's in comma separated format so Excel can read it too.
The degree of difficulty is encompassed with this data archive site:
http://www.gdacs.org/cyclones/?q=2007&submit=Search
(Maybe 2007 is an unfortunate choice of example. 2006 seems better set
out.)
Originally set up to co-ordinate disaster response, it houses lists of
tropical storm data that can be pasted directly to a spreadsheet. Nice
one.
But last time I looked at it, it held all the years on one page IIRC
and had similar data errors to those of the MetO.
Maybe they have rectified that too. Time to extract my full compliment
of digits.
Anyone know what these people do: http://ghrsst.jpl.nasa.gov/index.html
?
They seem set up to warn about glowballs.
I hope not. |
|
|
| Back to top |
|
| Weatherlawyer |
| Posted: Sat Mar 29, 2008 1:16 am |
|
|
|
Guest
|
On Mar 28, 10:25 am, Weatherlawyer <Weatherlaw...@hotmail.com> wrote:
Quote: On Mar 26, 12:56 am, rog...@lpbroadband.net wrote:
On Mar 25, 12:31 am, Weatherlawyer <Weatherlaw...@hotmail.com> wrote:
I have added a list of lunar phases to Google Spread sheets. It is
available at:http://spreadsheets.google.com/pub?key=p_WU4hvc6p3XkQl_cIURANA&output...
as an "Open Office" sheet.
The last column indicates which hour the phase fell or falls on. You
create your own version if you want to sort them into similar hours or
spells. And you can do that by sorting them by that last columns.
I'd have done it myself only one loses the year if you do them en
bloc. You'd have to sort them year by year to be able to make sense of
the results
I have one which lists full and new moon date and time from 1768 to
2015 and each one has a year so you can sort the whole file at once.
It's in comma separated format so Excel can read it too.
The degree of difficulty is encompassed with this data archive site:http://www.gdacs.org/cyclones/?q=2007&submit=Search
(Maybe 2007 is an unfortunate choice of example. 2006 seems better set
out.)
When I first came across this site a while back I couldn't get the
data format to save as seen at the site. Yesterday it was doing fine.
Then I updated Open Office which updated Java and now the format is
crap again.
I wonder if I can uninstall the Java and return to my older OOo
version? |
|
|
| Back to top |
|
| |
|
Page 1 of 1
All times are GMT - 5 Hours
The time now is Tue Oct 14, 2008 8:15 am
|
|