Go Back   Aural Moon - Progressive Rock Discussion > Aural Moon Programming > Corner of the Mooniverse
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 06-27-2010, 08:19 AM
OverHillandDale's Avatar
OverHillandDale(Admin) OverHillandDale is offline
Show Host & Administrator
 
Join Date: Jan 2007
Location: Soddy Daisy, Tennessee
Posts: 1,531
Send a message via AIM to OverHillandDale Send a message via Yahoo to OverHillandDale
Help Wanted

Several of you have expressed interest in have a 'master list' of the material played on Corner of the Universe. I would like to comply but just do not have time to do so.

I do, however, have everything in one Excel file and it is set up with worksheets that were meant for me to be able to update. Is there anyone out that with Excel experience that would like to compile that list for me from that workbook.

Let me know.

Gratefully,

Dale
__________________
OverHillandDale


Happiness is a worn pun!
Reply With Quote
  #2  
Old 06-27-2010, 02:20 PM
TheFish's Avatar
TheFish TheFish is offline
No clue anymore
 
Join Date: Jan 2007
Location: Campbell, CA
Posts: 978
Re: Help Wanted

I'm a excel rookie but I think if I apply myself I will be very quickly. Got nothing to do besides. I'll go for it!
__________________
"A lie gets halfway around the world before the truth has a chance to get its pants on." - Winston Churchill

" A dog will look up to you, A cat will look down on you, but a pig will look you straight in the eye" - W. Churchill

"There are three things Money can't buy, Manners, Morals and Integrity." - Me

Last edited by TheFish : 06-27-2010 at 08:40 PM.
Reply With Quote
  #3  
Old 06-27-2010, 05:40 PM
VAXman's Avatar
VAXman(Admin) VAXman is online now
progger propellerhead
 
Join Date: Dec 2003
Location: Presently reside in Jackson (southern) NJ (20 miles east of NEARfest 2002 & 2003
Posts: 2,354
Send a message via AIM to VAXman Send a message via Skype™ to VAXman
Re: Help Wanted

No Opportunity Necessary, No Experience Needed.
__________________
VAXman -- Watcher of the moon, watcher of all.
----------------Mopper of the moon, mopper of all.
-------------------- Aural Moon's Janitorial Services
---------------------and Restroom Supplies, and Techno-patsy --

Cogito ergo iMac.         
Reply With Quote
  #4  
Old 06-27-2010, 07:06 PM
SnardLivesHere SnardLivesHere is offline
Registered User
 
Join Date: Sep 2002
Location: Hill Country of Texas
Posts: 80
Re: Help Wanted

Dale,

I could do it if you aren't in a big hurry. In case Fish gives up.
__________________
Reply With Quote
  #5  
Old 06-27-2010, 08:39 PM
TheFish's Avatar
TheFish TheFish is offline
No clue anymore
 
Join Date: Jan 2007
Location: Campbell, CA
Posts: 978
Re: Help Wanted

Quote:
Originally Posted by SnardLivesHere View Post
Dale,

I could do it if you aren't in a big hurry. In case Fish gives up.
Hey!
__________________
"A lie gets halfway around the world before the truth has a chance to get its pants on." - Winston Churchill

" A dog will look up to you, A cat will look down on you, but a pig will look you straight in the eye" - W. Churchill

"There are three things Money can't buy, Manners, Morals and Integrity." - Me
Reply With Quote
  #6  
Old 06-28-2010, 07:11 AM
OverHillandDale's Avatar
OverHillandDale(Admin) OverHillandDale is offline
Show Host & Administrator
 
Join Date: Jan 2007
Location: Soddy Daisy, Tennessee
Posts: 1,531
Send a message via AIM to OverHillandDale Send a message via Yahoo to OverHillandDale
Re: Help Wanted

Thanks guys. I'll get in touch with you both. I believe I have enough to do for both of you.

I really appreciate it.

In fact, I'll take anyone else that would also like to help.

Thanks.

OverWorkedandDale
__________________
OverHillandDale


Happiness is a worn pun!
Reply With Quote
  #7  
Old 06-28-2010, 09:05 PM
gr8sho92's Avatar
gr8sho92 gr8sho92 is offline
Patron
 
Join Date: Jan 2007
Location: Wellington, FL
Posts: 328
Re: Help Wanted

Quote:
Originally Posted by OverHillandDale View Post
I do, however, have everything in one Excel file ...
Why not just provide the excel as an attachment here?
__________________
Cheers,
Carl
Reply With Quote
  #8  
Old 06-28-2010, 10:04 PM
OverHillandDale's Avatar
OverHillandDale(Admin) OverHillandDale is offline
Show Host & Administrator
 
Join Date: Jan 2007
Location: Soddy Daisy, Tennessee
Posts: 1,531
Send a message via AIM to OverHillandDale Send a message via Yahoo to OverHillandDale
Re: Help Wanted

Quote:
Originally Posted by gr8sho92 View Post
Why not just provide the excel as an attachment here?
Well, that would mean having all the right information in the right places....

Which is what I want them to do for me.

To display it once that is done I will most likely need to put it on a host so it could be linked to. Oh, there's another little job I don't have time for.

Actually my intent is to have it available so people can see what's been played and choose new material accordingly. This is step 2 & 3 in the process, so to speak.

thanks folks.
__________________
OverHillandDale


Happiness is a worn pun!
Reply With Quote
  #9  
Old 06-29-2010, 01:09 AM
TheFish's Avatar
TheFish TheFish is offline
No clue anymore
 
Join Date: Jan 2007
Location: Campbell, CA
Posts: 978
Re: Help Wanted

Damn the torpedoes Mr. Hornblower and let's get on with it!

God I just love that nautical talk.
__________________
"A lie gets halfway around the world before the truth has a chance to get its pants on." - Winston Churchill

" A dog will look up to you, A cat will look down on you, but a pig will look you straight in the eye" - W. Churchill

"There are three things Money can't buy, Manners, Morals and Integrity." - Me
Reply With Quote
  #10  
Old 06-29-2010, 09:02 AM
OverHillandDale's Avatar
OverHillandDale(Admin) OverHillandDale is offline
Show Host & Administrator
 
Join Date: Jan 2007
Location: Soddy Daisy, Tennessee
Posts: 1,531
Send a message via AIM to OverHillandDale Send a message via Yahoo to OverHillandDale
Re: Help Wanted

Quote:
Originally Posted by TheFish View Post
Damn the torpedoes Mr. Hornblower and let's get on with it!

God I just love that nautical talk.
I dont' think Horatio had torpedoes back then, But I get your drift.
But just because I had to look it up, that was David Farrugut during the Civil War that coined that phrase (I'm not correcting - it just got me curious.)
__________________
OverHillandDale


Happiness is a worn pun!
Reply With Quote
  #11  
Old 06-29-2010, 11:29 AM
TheFish's Avatar
TheFish TheFish is offline
No clue anymore
 
Join Date: Jan 2007
Location: Campbell, CA
Posts: 978
Re: Help Wanted

Yes, he did. But I just got done watching 16 hours of HH so it was in the front of my brain. Great miniseries.
__________________
"A lie gets halfway around the world before the truth has a chance to get its pants on." - Winston Churchill

" A dog will look up to you, A cat will look down on you, but a pig will look you straight in the eye" - W. Churchill

"There are three things Money can't buy, Manners, Morals and Integrity." - Me
Reply With Quote
  #12  
Old 06-29-2010, 11:11 PM
SnardLivesHere SnardLivesHere is offline
Registered User
 
Join Date: Sep 2002
Location: Hill Country of Texas
Posts: 80
Re: Help Wanted

Looking forward to seeing the data Dale. I can arrange and sort and manipulate and do whatever you want. Bring it on!
__________________
Reply With Quote
  #13  
Old 06-30-2010, 05:42 AM
OverHillandDale's Avatar
OverHillandDale(Admin) OverHillandDale is offline
Show Host & Administrator
 
Join Date: Jan 2007
Location: Soddy Daisy, Tennessee
Posts: 1,531
Send a message via AIM to OverHillandDale Send a message via Yahoo to OverHillandDale
Re: Help Wanted

Quote:
Originally Posted by SnardLivesHere View Post
Looking forward to seeing the data Dale. I can arrange and sort and manipulate and do whatever you want. Bring it on!
Would you PM your email address to me, can't seem to find it in my contacts.

Thanks.

dale
__________________
OverHillandDale


Happiness is a worn pun!
Reply With Quote
  #14  
Old 12-26-2010, 11:38 PM
OverHillandDale's Avatar
OverHillandDale(Admin) OverHillandDale is offline
Show Host & Administrator
 
Join Date: Jan 2007
Location: Soddy Daisy, Tennessee
Posts: 1,531
Send a message via AIM to OverHillandDale Send a message via Yahoo to OverHillandDale
Re: Help Wanted

I had made this please back in June and we were not able to work out someone to fill in for this task. So, I'm reissuing the plea for help with my excel master sheet.

Anyone care to take a stab at it?

I want to cull all the individual show playlists that are a single worksheet in this workbook. From that I want to have a master "songs / artists played" list AND a list of the Albums played since the beginning.

I'm hoping someone knows a macro or formula that can help collate that info easily and then helps me sort it as I add to it next year.

Then again, maybe I should export to CSV and import to a real DB.

anyway, if anyone can help. Please pm me or email me @ cotm.auralmoon@yahoo.com.

Dale
Quote:
Originally Posted by OverHillandDale View Post
Several of you have expressed interest in have a 'master list' of the material played on Corner of the Universe. I would like to comply but just do not have time to do so.

I do, however, have everything in one Excel file and it is set up with worksheets that were meant for me to be able to update. Is there anyone out that with Excel experience that would like to compile that list for me from that workbook.

Let me know.

Gratefully,

Dale
__________________
OverHillandDale


Happiness is a worn pun!
Reply With Quote
  #15  
Old 12-27-2010, 08:30 AM
VAXman's Avatar
VAXman(Admin) VAXman is online now
progger propellerhead
 
Join Date: Dec 2003
Location: Presently reside in Jackson (southern) NJ (20 miles east of NEARfest 2002 & 2003
Posts: 2,354
Send a message via AIM to VAXman Send a message via Skype™ to VAXman
Re: Help Wanted

Quote:
Originally Posted by OverHillandDale View Post
Several of you have expressed interest in have a 'master list' of the material played on Corner of the Universe. I would like to comply but just do not have time to do so.

I do, however, have everything in one Excel file and it is set up with worksheets that were meant for me to be able to update. Is there anyone out that with Excel experience that would like to compile that list for me from that workbook.

Let me know.

Gratefully,

Dale
*IF* the shows are maintained on the streaming server, I can probably get the info from SAM's MySQL database and present it here. This, of course, requires that you've maintained all of the shows archived in the Mooniverse folder of SAM.
__________________
VAXman -- Watcher of the moon, watcher of all.
----------------Mopper of the moon, mopper of all.
-------------------- Aural Moon's Janitorial Services
---------------------and Restroom Supplies, and Techno-patsy --

Cogito ergo iMac.         
Reply With Quote
  #16  
Old 12-27-2010, 09:51 AM
OverHillandDale's Avatar
OverHillandDale(Admin) OverHillandDale is offline
Show Host & Administrator
 
Join Date: Jan 2007
Location: Soddy Daisy, Tennessee
Posts: 1,531
Send a message via AIM to OverHillandDale Send a message via Yahoo to OverHillandDale
Re: Help Wanted

Quote:
Originally Posted by VAXman View Post
*IF* the shows are maintained on the streaming server, I can probably get the info from SAM's MySQL database and present it here. This, of course, requires that you've maintained all of the shows archived in the Mooniverse folder of SAM.
Ack! *IF* only I had known.....
No, don't think it's archieved properly. Added on material not in library gets removed. But I may consider implementing that somehow for 2011.

Thanks, Vax.
__________________
OverHillandDale


Happiness is a worn pun!
Reply With Quote
  #17  
Old 12-27-2010, 04:05 PM
lotus's Avatar
lotus lotus is offline
Patron
 
Join Date: Jul 2004
Posts: 827
Re: Help Wanted

Quote:
Originally Posted by OverHillandDale View Post
I had made this please back in June and we were not able to work out someone to fill in for this task. So, I'm reissuing the plea for help with my excel master sheet.

Anyone care to take a stab at it?

I want to cull all the individual show playlists that are a single worksheet in this workbook. From that I want to have a master "songs / artists played" list AND a list of the Albums played since the beginning.

I'm hoping someone knows a macro or formula that can help collate that info easily and then helps me sort it as I add to it next year.

Then again, maybe I should export to CSV and import to a real DB.

anyway, if anyone can help. Please pm me or email me @ cotm.auralmoon@yahoo.com.

Dale
I could have a look at it, Dale, pm or mail me the file with instructions what you want to have done and I have a look on it and see what I can do..
__________________
Lotus
****************************************
The light at the end of the tunnel is the light of an oncomming train......

Reply With Quote
  #18  
Old 12-27-2010, 06:05 PM
OverHillandDale's Avatar
OverHillandDale(Admin) OverHillandDale is offline
Show Host & Administrator
 
Join Date: Jan 2007
Location: Soddy Daisy, Tennessee
Posts: 1,531
Send a message via AIM to OverHillandDale Send a message via Yahoo to OverHillandDale
Re: Help Wanted

Quote:
Originally Posted by lotus View Post
I could have a look at it, Dale, pm or mail me the file with instructions what you want to have done and I have a look on it and see what I can do..

Thank you so much for taking a look, Lotus. I have emailed the file to you. Let me know if you don't get it in the morning. Requested needs are listed in the email.

Thanks again!

Dale
__________________
OverHillandDale


Happiness is a worn pun!
Reply With Quote
Reply


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump



All times are GMT -5. The time now is 09:33 AM.