The O&M database

[norsenerd]

I have completed the O&M strip database that was talked abotu a while back. It lists each stip, the characters it it, as well as a few other statistics for each strip. It took me 5 days but it's finaly here.<br><br>It is an MS Excel document so you have to be able to read Excel documents to make any use fo it:<br><br><a href='http://home.earthlink.net/~bschwab17/Oz ... Millie.xls' target='_blank'>http://home.earthlink.net/~bschwab17/Oz ... br><br>The key for it is here:<br><br><a href='http://home.earthlink.net/~bschwab17/Oz ... atakey.txt' target='_blank'>http://home.earthlink.net/~bschwab17/Oz ... ><br><br>I will update it once a week, on Mondays. Until for some reason I sotp. In September and October I will add a Storyline and a Punchline columns to better asist with searches but after going therough the achrives witha comb I shoudl wait a bit before oign it again. I have toehr stuff to do and my head hurts.<br><br>Here are a few statistics compiled form this:<br><br>1541 strips (including re runs)<br><br>5986 Pannels<br><br>average of 3.88<br><br>Ozy: 1070 <br>Millie: 1070<br>Llewellyn: 376<br>Avery: 223<br>Ms. Mudd: 216<br>Stephan: 110<br>Timulty: 101<br>Felicia: 90<br>Locke: 79<br>Isolde: 56<br>Ms. Sorkowitz: 38<br>Jeremy: 32<br>Principal Beau Vine: 31<br>Dr. I. Wahnsinnig: 26<br>Mr. Larnblatt: 13<br><br><br><br>I would apreshate being notified of any errors that exist, or admentments and sugestions.<br><br>I wait your praise and critisims.<br><br><br><br>Edit: It was nice veing the stirps this closly. I got a much mroe intamite fealing witht he stirps and realy was able to aprecite how it eveolved. There is so much for me to sya but I need to recouporate before I do.

[NHJ BV]

Wow, nice work <!--emo&:)--><img src='http://definecynical.mancubus.net/forum ... /smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /><!--endemo-->

[simon]

Indeed, I'm very impressed. <!--emo&:)--><img src='http://definecynical.mancubus.net/forum ... /smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /><!--endemo-->

[Muninn]

Impressive.

[UltimateVG]

DAMN YOU NORSENERD! I was working the exact same thing in MySQL.<br><br>But good job anyways. You could convert that into a MySQL database and make a online database. That in alone would make for a good O&M fansite.

[norsenerd]

I will add astiricks in the Special colum to designate if there exists one of Cigian's colorings.

[Zylo]

Holy...friggin'...crap.<br><br>I'm speechless. You rock, N^2. You rock like no one has ever rocked before.

[Ozymandias]

Looks like a lotta hard work <!--emo&:)--><img src='http://definecynical.mancubus.net/forum ... /smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /><!--endemo--><br><br>Just one question about the blue text in row 73 and 1394

[norsenerd]

Why, that's the one with the blue stirng <!--emo&:P--><img src='http://definecynical.mancubus.net/forum ... tongue.gif' border='0' style='vertical-align:middle' alt='tongue.gif' /><!--endemo-->

[Ozymandias]

I thought of that, but thought that you wouldn't just pick one out. Having said that I gave someone some blue string and it worked.<br><br>Will be more than happy to add complete scripts for all strips to aid quoting from strips (will take a while tho be warned)

[Ozymandias]

Some suggestions and whatnot:<br><br>In 'Ozy Adjusts' (3rd June 1998) theres a girl who taunts Ozy (unsucessfully). She's not in the other characters.<br><br>Could the dates be hyperlinks pls? It would save me time and all.

[norsenerd]

I didn;t include her because she dosn;t have a name for one. I basicly included other characters if they have either a name or are a prominet part of one of the main characters life. Like Averys Mother who is unnamed.

[Ozymandias]

OK, fair play

[norsenerd]

Also the dates are close to how the pictures are listed. ad om before the humber and get rid fo the dashes.and make sure the corect directory is in the sapce before had: eg: 2003-05-20transerfs to <a href='http://www.ozyandmillie.org/2003/om20030520.html' target='_blank'>http://www.ozyandmillie.org/2003/om2003 ... ><br><br>I will inlcude a hyperlick column in my next update.

[Ozymandias]

thx m8