Have Rep, will trade for graph construction

[Turtle]

As the title suggests, I need a graph made & I will give rep to anyone who will make it for me. To qualify, I have tried relentlessly to do it myself with the Quatro Pro that is on this machine, and failed miserably. No one in my household has a clue and it's not my machine so I can't add software or modify anything.

 

Below is (some of) the data I collected. I want a simple bar graph for each column & labled with associated dates. This data is taken from the USGS site and records the number of earthquakes above a certain magnitude; for example the first entry shows that on 5/29/06 there were 199 quakes worldwide above 2.5 and 547 quakes in the US above 1.0.

 

This concludes this irregularly sceduled appeal for help. Please return your seats to the upright position. :hyper: :)

 

 

Date_____World_US
5/29/2006|199|547
5/30/2006|209|541
5/31/2006|187|534
6/01/2006|201|566
6/02/2006|214|611
6/03/2006|205|606**1st Quarter Moon
6/04/2006|182|572
6/05/2006|174|564
6/06/2006|170|599
6/07/2006|176|590
6/08/2006|177|581
6/09/2006|181|609
6/10/2006|176|567
6/11/2006|165|542**Full Moon
6/12/2006|152|527
6/13/2006|142|549
6/14/2006|216|655
6/15/2006|241|705
6/16/2006|269|713
6/17/2006|277|711
6/18/2006|294|715**3rd Quarter Moon
6/19/2006|294|708
6/20/2006|312|746
6/21/2006|262|682
6/22/2006|226|647
6/23/2006|210|632
6/24/2006|197|596
6/25/2006|186|557**New Moon
6/26/2006|164|510
6/27/2006|173|514
6/28/2006|180|514
6/29/2006|186|517
6/30/2006|173|552
7/01/2006|166|559
7/02/2006|195|609
7/03/2006|235|661**1st Quarter Moon
7/04/2006|225|682
7/05/2006|207|683
7/06/2006|213|717
7/07/2006|221|670
7/08/2006|232|655
7/09/2006|247|662
7/10/2006|235|666
7/11/2006|248|678**Full Moon
7/12/2006|254|705
7/13/2006|262|722
7/14/2006|256|762
7/15/2006|251|754
7/16/2006|181|654
7/17/2006|167|631**3rd Quarter Moon
7/18/2006|162|579
7/19/2006|206|577
7/20/2006|210|570
7/21/2006|215|559
7/22/2006|214|555
7/23/2006|198|533
7/24/2006|179|504
7/25/2006|177|509**New Moon
7/26/2006|178|529
7/27/2006|164|544
7/28/2006|175|566
7/29/2006|171|545
7/30/2006|177|537
7/31/2006|165|526
8/01/2006|169|559

[InfiniteNow]

As the title suggests, I need a graph made & I will give rep to anyone who will make it for me.

No rep required. You simply must check out the "Text to Columns" functionality in Excel. A life saver for sure. Brotherly Conduct of the You're a good dude kind.

 

Cheers. :)

 

[ATTACH]1189[/ATTACH]

 

 

[C1ay]

Here's a couple of alternate comparative views, no rep required...

[CraigD]

Attached is Microsoft office's table wizard's effort, as a .gif file. Not very imaginative, but seems to get the point.

 

There may be free web apps that can make such graphs equally quickly, but I don't know of any. Docs.google.com doesn't yet, but promises to.

 

... way too slow, it seems - this biz graphics stuff isn't really my bag, but I enjoyed the excuse to try it :)

[Turtle]

You guys rock! :eek2: Apparently I must spread the wealth a bit before getting to Craig & InfiniteNow, but I got a mind like a #4 bear trap for details like this and I got your rainchecks penned. :hihi:

 

I'll try the xls file in my Quatro as it does open some, but it doesn't transfer all features and the graph may not display. Speaking of this not being my machine, I had to wait for the owner to hit the sack before I could check for replies (man you guys are not only good, you're fast! :evil: ), so I cooled my heels by going back to what I know which is pencil & paper. A slide rule makes a handy straightedge too. :doh: :doh: :hyper:

 

Anyway, I started with my earliest data, which was not part of what I gave so at least I'm not repeating. Here's what I got and I'll figure a way to append it with what you fellas worked up. Dare we say the peaks are at syzygies? :doh:

 

PS Gaps in my graph are dates I didn't take records.

[C1ay]

Anyway, I started with my earliest data, which was not part of what I gave so at least I'm not repeating. Here's what I got and I'll figure a way to append it with what you fellas worked up. Dare we say the peaks are at syzygies? :eek2:

 

PS Gaps in my graph are dates I didn't take records.

 

Have you checked the National Earthquake Information Center for your missing data? I think you'll find a wealth of information there to support your endeavor :doh:

[LJP07]

Why bother asking for rep.? :eek2: This site aims to discuss and help peoples problems whatever they might be, if people feel they must give you rep. they will give. People would have helped you anyway. No Offence though :doh:

 

Maybe you knew they wouldn't give rep. as well? There too nice! :evil:

[Turtle]

Why bother asking for rep.? :) This site aims to discuss and help peoples problems whatever they might be, if people feel they must give you rep. they will give. People would have helped you anyway. No Offence though :)

 

Maybe you knew they wouldn't give rep. as well? There too nice! :)

 

? I'm a little unclear on the first sentence, as I wasn't asking for rep for myself. I posted the list and asked for help months ago in the Earthquakes thread and received no response so I thought I 'd try again with some added incentive. The simple fact is I wanted to study the graph and not having it made for problems.

 

I give rep with no expectation of return. :)

 

I was able to open InfiniteNow's xls file in Quattro and both the data & the graph loaded. I have made a copy & renamed it so I can experiment & try to figure out how it's done.

 

A cursory glance of the graphs seems to have the peaks following the Full Moon by about 5 to 7 days, but the New Moon seems to be at troughs. Not what I expected, but I need to get all my data in for a good look-see. I have about 8 months of daily entries & will get it all in a single file ASAP.

 

Many thanks for the help all!!! You are indeed too nice. :) :cup:

[LJP07]

? I'm a little unclear on the first sentence, as I wasn't asking for rep for myself.

 

Actually your right, I made an error.

[CraigD]

While lamenting the lack of a well-known, nice, public graphing tool for these kinds of needs, it occurred to me that we all of us have pretty nice rendering tools at our fingertips: our html browsers!

 

Borrowing a trick from imdb.com's ratings graphs, I've attached Turtle's data imbedded within table tags in a small html file. Anyone with patience and a text editor can edit it to add/remove rows, change values, or fiddle with its format.

 

I borrowed a little more from imdb than its technique - the gray and blue bars use a couple of its tiniest graphics files: http://i.imdb.com/neutral.gif and blue.gif. If you want the TEMP.html to render when you don't have an internet connection (or just feel faintly guilty pirating 1-pixel content and bandwidth from good old imdb ), you should save neutral.gif and blue.gif into the same directory as TEMP.html, and remove the "http://i.imdb.com/" references from TEMP.html.

 

It’s possible to eliminate the use of img elements completely use colspan and bgcolor attributes, but most browsers render tables like this much more inefficiently than they do img elements, leading to noticeable pauses or even crashes of the browser.

 

Now I can lament the world’s lack of appreciating of html, and the degeneration of the browser into a glorified app-launcher & container. If things had gone according to plan, html would have loads of basic graphics rendering elements now, but, alas, things went according to other plans.

TEMP.html

[Turtle]

Borrowing a trick from imdb.com's ratings graphs, I've attached Turtle's data imbedded within table tags in a small html file. Anyone with patience and a text editor can edit it to add/remove rows, change values, or fiddle with its format.

 

 

What a unique view! It keeps the general line of the rise & fall without obscuring the exact values, and the Moon phase tags are clear without confusing the graph. I likey!!!:)

 

So I can add the rest of my data right to that html somehow? :P

 

Many thanks.

[CraigD]

So I can add the rest of my data right to that html somehow?

Yes.

 

Just save a copy of TEMP.html somewhere convenient, then open the file in your favorite text editor (notepad.exe works for me).

 

Each pair of rows is represented by a couple of lines of html like this

 <tr><td>5/29/2006<td nowrap=1><img src=http://i.imdb.com/blue.gif width=199 height=5> 199
<tr><td><td nowrap=1><img src=http://i.imdb.com/neutral.gif width=547 height=5> 547

To add a couple of lines, just copy these 2 lines to wherever in the table you want the new lines, then edit the “5/29/2006” to the new date, change both “199”s to the new US number, both “547”s to the new world number.

 

To get rid of lines, just delete them.

 

You can play around with the table, changing things to see the effect. And, of course, you can insert the “<table> … </table>” into another html document, allowing it to be preceded or followed by text, graphics, have a background graphic, or anything else that can be done in html, which is purtnear anything.

 

It’s handy to open the file in a browser window, and after making an edit, hit “reload” to redisplay it. Not quite like a fancy WYSIWYG html editor, but pretty close.

 

What makes an html table word are basically these 3 tags (formally called elements): <table>; <tr> (table row); and <td> (table data, or cell). What makes this table a graph is the <img> tag. Its width attribute specifies how many pixels wide its displayed. Its src attribs just refer to a couple of 1-pixel graphics – the width and height attribs stretch the graphic to the specified size. The <td> tag’s nowrap attrib prevents the browser from allowing the number following it to be wrapped to a new line, which would ruin the graphs appearance, and the   (non-breakable space) character inserts a space that the browser will always honor. I should probably have but one after each date, to keep the bar from crowding them.

 

There are a lot of other things that can be done with tables. W3C HTML has links to the latest specification, tutorials, and other stuff related to html.

 

You may notice that I didn’t use </td> or </tr> end tags. These tags have been optional since the early days of html – if you don’t use them, the browser assumes that the next <td>, <tr>, or </table> ends the previous <tr> or <td>.

[Turtle]

So I can add the rest of my data right to that html somehow?

 

Yes.

 

Just save a copy of TEMP.html somewhere convenient, then open the file in your favorite text editor (notepad.exe works for me).

 

Each pair of rows is represented by a couple of lines of html like this

 <tr><td>5/29/2006<td nowrap=1><img src=http://i.imdb.com/blue.gif width=199 height=5> 199
<tr><td><td nowrap=1><img src=http://i.imdb.com/neutral.gif width=547 height=5> 547

To add a couple of lines, just copy these 2 lines to wherever in the table you want the new lines, then edit the “5/29/2006” to the new date, change both “199”s to the new US number, both “547”s to the new world number.

 

To get rid of lines, just delete them.

 

Shweet! I followed directions & I have this much working so far. A deep genuflection in your direction Craig! :hihi: Of to work on data entry, and here's my first few edits. I changed the file name in case I made an irrecoverable error. :eek: :hyper:

 

PS Rats! It looked good a minute ago & now the lines are gone! :doh: I'm on it like a boil on a butt! :hyper:

[Turtle]

Have you checked the National Earthquake Information Center for your missing data? I think you'll find a wealth of information there to support your endeavor :hyper:

 

Acknowledged. It is a stub of that page that I collected the data from. I'll poke around to see if they have an archive, but the maps are updated at least every hour & I only took data once a day and generally between 10am & Noon.

 

Here's the exact links:

World Map >>> USGS Earthquake Hazards Program » Latest Earthquakes in the World - Past 7 days

 

US Map >>> USGS Earthquake Hazards Program » Latest Earthquakes in the USA - Past 7 days

 

As soon as I get all my data in I (we) can compare current status with our plot(s).

 

Speaking of the graphing, when I double-click on my edited html file in its folder on disk, it opens as a web-page and everything is correct; however, when I attached it above and open the attached version, the bars have disappeared from the graph!

[Turtle]

...I'll poke around to see if they have an archive, but the maps are updated at least every hour & I only took data once a day and generally between 10am & Noon.

 

Here's the exact links:

World Map >>> USGS Earthquake Hazards Program » Latest Earthquakes in the World - Past 7 days

 

US Map >>> USGS Earthquake Hazards Program » Latest Earthquakes in the USA - Past 7 days

 

First, I am trying to match the Moon phase to the quake activity as a correlation because of geologist Jim Berkland's claim it is a strong predictive aid.

 

Second, in posting the above I realized the map counts are for the last 7 days, so this may account for the graph peaks at the Quarters rather than Full/New where I expected peaks. I'll have a better picture when I get all 8 months of my data input.

 

Thanks again all you contributing graphers. :hihi: :)