http://qs1969.pair.com?node_id=488688

guice has asked for the wisdom of the Perl Monks concerning the following question:

I have a programming delima that I'm not sure how to approach this.

I have a SQL table with a number of number with application name and epoch time/date stored for each one. And I have an excel file saying "for X apps I need data for M-F 7am-8pm, Sat 8am-6pm, Sun 9am-1pm", etc. The times and dates can very with each application.

I'm trying to figure out what would be the best way to tackle this problem:
1 - Storing of the application and time range values (retain simple human editability).
2 - How to gather such data (although, I suspect I can write some ugly SQL statement).

Anybody have thoughts on how to approach this?

Thanks

Updated: Updated title. This isn't an excel thing; ingore the Excel peice. I'm not parsing an Excel document. They will be editing the date/time brackets per the format I give them.

-- philip
We put the 'K' in kwality!