How to convert Text to spreadsheet to Google Calendar

the company posts all employee info as one GIGANTIC spreadsheet. it takes a long time to load, and is very unorganized.

I'm trying to import events from IXE Toal view

which looks like this before posting
http://www.qpc.com/Eu/Images/IEXTota...eduler-lge.gif

into a
Google Calendar readable format

which would look like this
https://docs.google.com/spreadsheet/...UE&usp=sharing

following this guide
http://n8henrie.com/2013/05/spreadsheet-to-calendar/

right now i have copied all info from {nonadmn} as a txt file. here it is times.txt

also the ''Open Time TIME PM TIME PM'' serves no purpose to me

I'm trying to
export to a readable format for Google Calender and have had no luck for two weeks. so finally, I'm turning to people who understand macros, spreadsheets, and data editing.

Any ideas guys?

How to read it.

Agent name Agent id

Date Start End Scheduled Activity Start End <-- this line shows as headers in the spreadsheet.

11/16/14 Off Off means do not work on that day.

11/18/14 1:00 PM 9:30 PM Open Time 1:00 PM 2:45 PM

Date- Time start, time stop, open time1:00 PM 2:45 PM is again, pointless.

Break Time start time end
and so on.

I'm trying to get each item to show as a Google Calender event.