+ Reply to Thread
Results 1 to 1 of 1

Trying to automate a complicated db3>csv conversion, then average, stdeva and total values

  1. #1
    Registered User
    Join Date
    06-08-2012
    Location
    Rochester, NY
    MS-Off Ver
    Excel 2007
    Posts
    1

    Trying to automate a complicated db3>csv conversion, then average, stdeva and total values

    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!
    Last edited by tjk2795; 06-08-2012 at 10:34 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1