Exporting to .csv

Question

I am trying to determine which gobos are used most often in a remount for a certain show. I thought the easiest way to do this might be to export to .csv. However, when I do this I hit the limit in Excel for the number of rows allowed for a particular excel file before I even get to the cue section. I tried only exporting the cues instead of exporting the whole showfile, but that just gave me a blank document. 
 Is there something I am doing wrong, or is there an easier way to get to my end result rather that exporting to a .csv? Thanks in advance! -Kalen

sk8rs_dad · Accepted Answer

Possible? Yes. 
 Practical? It depends on your spreadsheet wizardry skills. 
 The CSV file contains all the information. However it is organized as a list of cues, and a separate list of channel moves. It would take some clever manipulation to reorganize the data so you can see the levels in a given cue, and even more clever coding to work out all the tracking behaviours, and still more clever coding to colorize everything. It's not impossible but it would be a lot of work. 
 It is not clear to me how replicating the blind spreadsheet view would be the fastest way to determine which gobos are used most often. Assuming you are trying to determine which specific channels have non-zero levels then the CSV is likely your best bet. 
 Based on your first post, I would suggest upgrading to a more recent version of Excel, or possibly Libre Office where the limit you are hitting on maximum number of rows goes away. You could also use a text editor to extract just the cue information from the CSV and hope that gets you under the maximum number of rows for the version of Excel you are running.