thread: Happy BMI Day!
View Single Post
Old 2nd July 2019
  #43
Quote:
Originally Posted by Etch-A-Sketch View Post
Man... Mac Finder advanced search, Excel pivot tables and Excel vLookup tables would have been your best friends. It would allow you to do all of this in minutes instead of weeks.

Or learning a little python scripting would have made this SUPER easy to the point where you could just run a script file and point it at all the cue sheets and PRO reports and within 30 seconds you'd have an output spreadsheet with all the information you want/need parsed out of the cue sheets and reports.

Setting it up and getting it to work right might take you a few days or a week... but once it's up and running you could process/check thousands of cue sheets and PRO statements simultaneously.
Do you know of a class out there to show me how to do this sort of task?