Help Wanted

[OverHillandDale(Admin)]

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]

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(Admin)]

No Opportunity Necessary, No Experience Needed.

[SnardLivesHere]

Dale,

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

[TheFish]

Originally Posted by SnardLivesHere

Dale,

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

Hey!

[OverHillandDale(Admin)]

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

[gr8sho92]

Originally Posted by OverHillandDale

I do, however, have everything in one Excel file ...

Why not just provide the excel as an attachment here?

[OverHillandDale(Admin)]

Originally Posted by gr8sho92

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.

[TheFish]

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

God I just love that nautical talk.

[OverHillandDale(Admin)]

Originally Posted by TheFish

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

[TheFish]

Yes, he did. But I just got done watching 16 hours of HH so it was in the front of my brain. Great miniseries.

[SnardLivesHere]

Looking forward to seeing the data Dale. I can arrange and sort and manipulate and do whatever you want. Bring it on!

[OverHillandDale(Admin)]

Originally Posted by SnardLivesHere

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(Admin)]

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

Originally Posted by OverHillandDale

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(Admin)]

Originally Posted by OverHillandDale

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(Admin)]

Originally Posted by VAXman

*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]

Originally Posted by OverHillandDale

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(Admin)]

Originally Posted by lotus

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