Aural Moon - Progressive Rock Discussion

Aural Moon - Progressive Rock Discussion (http://auralmoon.com/forum/index.php)
-   Corner of the Mooniverse (http://auralmoon.com/forum/forumdisplay.php?f=33)
-   -   Help Wanted (http://auralmoon.com/forum/showthread.php?t=4656)

OverHillandDale 06-27-2010 08:19 AM

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

TheFish 06-27-2010 02:20 PM

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!

VAXman 06-27-2010 05:40 PM

Re: Help Wanted
 
No Opportunity Necessary, No Experience Needed.

SnardLivesHere 06-27-2010 07:06 PM

Re: Help Wanted
 
Dale,

I could do it if you aren't in a big hurry. In case Fish gives up.

TheFish 06-27-2010 08:39 PM

Re: Help Wanted
 
Quote:

Originally Posted by SnardLivesHere (Post 43627)
Dale,

I could do it if you aren't in a big hurry. In case Fish gives up.

Hey! O_o ;)

OverHillandDale 06-28-2010 07:11 AM

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 :notsure:

gr8sho92 06-28-2010 09:05 PM

Re: Help Wanted
 
Quote:

Originally Posted by OverHillandDale (Post 43620)
I do, however, have everything in one Excel file ...

Why not just provide the excel as an attachment here?

OverHillandDale 06-28-2010 10:04 PM

Re: Help Wanted
 
Quote:

Originally Posted by gr8sho92 (Post 43638)
Why not just provide the excel as an attachment here?

Well, that would mean having all the right information in the right places....:notsure:

:eureka: 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. :flutter:

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.

TheFish 06-29-2010 01:09 AM

Re: Help Wanted
 
Damn the torpedoes Mr. Hornblower and let's get on with it! :salute

God I just love that nautical talk.:rockband:

OverHillandDale 06-29-2010 09:02 AM

Re: Help Wanted
 
Quote:

Originally Posted by TheFish (Post 43641)
Damn the torpedoes Mr. Hornblower and let's get on with it! :salute

God I just love that nautical talk.:rockband:

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.) :headscrat

TheFish 06-29-2010 11:29 AM

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. :D

SnardLivesHere 06-29-2010 11:11 PM

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!

OverHillandDale 06-30-2010 05:42 AM

Re: Help Wanted
 
Quote:

Originally Posted by SnardLivesHere (Post 43658)
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 12-26-2010 11:38 PM

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 (Post 43620)
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


VAXman 12-27-2010 08:30 AM

Re: Help Wanted
 
Quote:

Originally Posted by OverHillandDale (Post 43620)
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.

OverHillandDale 12-27-2010 09:51 AM

Re: Help Wanted
 
Quote:

Originally Posted by VAXman (Post 45002)
*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.

lotus 12-27-2010 04:05 PM

Re: Help Wanted
 
Quote:

Originally Posted by OverHillandDale (Post 45000)
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..

OverHillandDale 12-27-2010 06:05 PM

Re: Help Wanted
 
Quote:

Originally Posted by lotus (Post 45004)
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


All times are GMT -5. The time now is 09:27 PM.

Integrated by BBpixel Team 2025 :: jvbPlugin R1011.362.1
Powered by vBulletin Version 3.6.2
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.