Hey guys, I am trying to automate a process for work that will save me a week or so of tedious, repetitive clicking. If anyone out there has any idea how I might be able to do this I would really appreciate it. So, I have a little over 600 .db3 files in 65 different folders, labeled 01-65, and the file naming convention is 01_1LPM_1, 01_2LPM_1, 01_5LPM_1, then 10, 20, and 40. Then 02_1LPM_1, 02_2LPM_1, etc, all the way through 65_40LPM_1. Basically I'm trying to automate the process of converting these into .csv files via sqlite database browser, then export those into excel, average column C starting at C2 and going to infinity (because column C has varying row values from 0-1000 total values), then get the stdeva of C, then the number of total values in column C, and export those three numbers into another spreadsheet in the correct column and row for their respective values. I know its really complicated and I'm using 2 instances of excel, and sqlite, so it's going to probably require some scripting or maybe a batch file, but it would save me a ton of work. Any ideas on how I might be able to accomplish this? I think it might work if I have a slightly different script for each LPM value. That way it will just do all of the 1lpm files, then the 2's, etc. Thanks!
Bookmarks