I could have written a program to do all the calculating by now. What does Dean have to work or something ? active social life? Kids ? come on
no excuses! Just like load one array as a lookup table for each car class with the correct PAX modifer,
then import the raw data into a 2nd set of arrays (4 or 5 diminsonal, and on each line read populate the pax value as the result of the raw time X the referenced pax modifer [in the look up table] ) probably could be done in just a few lines of code
(tricky lines) but a few lines . then just drop in a bubble sort (or your favorite sort) based upon the last dimenson of the array (PAx adjusted) and save back to csv, maybe have it save a 2nd copy directly to html with the tables written out ...
course maybe you guys don't do programming as your 9 to 5 ... ?