Need help scripting from excel to working schedule table

[jantorre]

The airline we model, releases the complete seasonal program in excel spreadsheet.

These are for the hole seasons, and we want to try make a script to extract flights for a given week/period within the season, for example, 1 week in May, 1 week in July, 1 week in September.

This would save us a great deal of manual labour, and would free up time to do other stuff with our airline.

For the season we are in now, I manualy removed duplicates, adjusted for active/inactive within the season etc. I want to make this more effective.

Anyway, the format for the spreadsheet is like this:

FltNo From To Freq STC ACT DEP STD ARR STA Config
DY118 30MAR12 30MAR12	 5 J 73H BGO 1810 AES 1855 Y186
DY118 13APR12 27APR12	 5 J 73H BGO 1810 AES 1855 Y186
DY118 29APR12 22JUN12	 5 7 J 73H BGO 1810 AES 1855 Y186
DY118 19AUG12 19AUG12	 7 J 733 BGO 1810 AES 1855 Y148
DY118 24AUG12 26OCT12	 5 7 J 73H BGO 1810 AES 1855 Y186
DY119 30MAR12 30MAR12	 5 J 73H AES 1915 BGO 2000 Y186
DY119 13APR12 22JUN12	 5 J 73H AES 1915 BGO 2000 Y186
DY119 24AUG12 26OCT12	 5 J 73H AES 1915 BGO 2000 Y186

(Day 7 is Sunday , 0 in VMS)

So what we want to do is that, if we select a week in May, the script would extract every flight in that period and compile it in a csv format for import to our system.

Probably a massive task, but if somebody is capable and interested in giving us a hand, send me a pm or mail me @ jantore(youknowwhattoputhere)virtualnorwegian.net / skype jan.tore.elvheim

Cheers

PS. If somebody knows any other way to get up to date schedule data ready for VMS in an easy "effortless" way, please give me a shout.

I know somebody gets data from forexample Innovata, how does this work?

A tool to extract the timetable from amadeus would be very cool

[MBrown]

Simpilot offers a service I believe and you get a ready built csv with all the routes of your airline ready to import! You'd have to ask him