{"text_format":"3","workbook":"xlsb","n_sheets":3,"sheets":["Instructions","LIST","SampleInfo"],"not_rendered":{"macros":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only","passed_over":{"ids":[37,38,1024],"n":864}}

{"sheet":"Instructions","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"flags":["formulas_cached_only"]}
["Notes"]
[1,"This is an OpenSource utility to organize the image files, based on the creation date and GPS coordinates if available in the image file."]
[2,"This is implemented by Prasad Bodas (prasadbodas2000@gmail.com) by using the various source codes in Visual Basic in Excel as available from internet."]
[3,"Do not rename any of the worksheets in this workbook."]
[4,"Your files are important, make sure you have a backup in some folder, different than the working folder."]
[5,"Save this excel workbook in some suitable folder"]
[6,"Specify the file name pattern to work on, e.g. *.jpg, *.bmp only one at a time"]
[7,"Copy all the source files in a suitable folder and enter the complete folder name in cell B2 of sheet LIST"]
[8,"Enter the target folder name in cell B3 of sheet LIST, this target folder MUST be precreated manually before running the utility."]
[9,"Folder names must be complete with drive letter and last \\ character (e.g. c:\\test\\pic\\)"]
[10,"The image file metadata contains too many fields, a sample of which can be seen in Sheet SampleInfo"]
[11,"Current funtionality only copies the source files to the target folder with a  name prefix of the format YYYYMMDD_HHMM_<original_file_name.ext>"]
[12,"If the file selected by the search criteria is not an image file and/or it does not have image information tags associated with the file then the file will be as such moved to the target folder."]
[13,"In such a case a hardcoded datetime prefix can be specified in Cell I1 of sheet LIST. Whatever value entered there will be prefixed to the file if datetime information not found."]
[14,"After the setup as above is completed click the button Reorganize provided in the sheet -> List"]
[15,"If files from more locations are to be processed then at a time specify the source and target folder, run the utility and then change to new source and target folder and re-run."]
[16,"If required the excel workbook can be copied one copy per set of source and target folder so as to keep track / list of all files if required in a tabular form in excel."]

{"sheet":"LIST","index":1,"n_rows":8,"n_cols":89,"rows_kept":8,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,3]],"flags":["formulas_cached_only"]}
["Extension","*.jpg",null,null,"Debug",false,null,"Default Date time","00000000_000000"]
["Source","d:\\pic\\_folder1\\",null,null,"Fill MetaData",false]
["Target","d:\\pic\\_folder1\\copy\\"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66]
["Seq","Folder","Fname","NewName","Date","Time","MetaData","Latitude","Longitude","Param","Value","Param","Value","Param","Value","Param","Value","Param","Value","Param","Value","Param","Value","Param","Value"]
[1,"d:\\pic\\_folder1\\","aIMG-20170821-WA0006.jpg",{"$nulls":3},"ERROR_NO_EXIFDATA   (0x8004CAA0)\r\n\r\nvbExifReader: File contains no EXIF data.",null,null,1,"59.5 KB",2,"JPG File",3,"11/04/2018 19:40",4,"11/04/2018 19:40",5,"11/04/2018 19:41",6,"A",9,"Image",10,"Administrators",11,"Picture",19,"Unrated",31,"‪720 x 1280‬",53,"INMUCHLP02217 (this computer)",155,"aIMG-20170821-WA0006.jpg",160,"24",161,"‎96 dpi",162,"‎720 pixels",163,"‎96 dpi",164,"‎1280 pixels",173,"No",176,"_folder1",177,"D:\\pic\\_folder1",178,"_folder1 (D:\\pic)",180,"D:\\pic\\_folder1\\aIMG-20170821-WA0006.jpg",182,"JPG File",188,"Unresolved",269,"Not shared"]
[2,"d:\\pic\\_folder1\\","Test (1).jpg","20180411_101644_Test (1).jpg","20180411","101644",null,19.209722222222222,72.98305555555555,1,"1.81 MB",2,"JPG File",3,"11/04/2018 10:25",4,"11/04/2018 10:25",5,"11/04/2018 10:25",6,"A",9,"Image",10,"Administrators",11,"Picture",12,"‎11/‎04/‎2018 ‏‎10:16",19,"Unrated",30,"SM-N900",31,"‪4128 x 2322‬",32,"samsung",35,"N900XXSEBPL3",53,"INMUCHLP02217 (this computer)",155,"Test (1).jpg",160,"24",161,"‎72 dpi",162,"‎4128 pixels",163,"‎72 dpi",164,"‎2322 pixels",173,"No",176,"_folder1",177,"D:\\pic\\_folder1",178,"_folder1 (D:\\pic)",180,"D:\\pic\\_folder1\\Test (1).jpg",182,"JPG File",188,"Unresolved",230,"0220",233,"Normal",235,"f/2.2",237,"‎4 mm",238,"31",243,"2.27",244,"Center Weighted Average",245,"Rotate 270 degrees",247,"Normal program",250,"Auto",269,"Not shared"]
[3,"d:\\pic\\_folder1\\","Test.jpg","20180411_101644_Test.jpg","20180411","101644",null,19.209722222222222,72.98305555555555,1,"1.81 MB",2,"JPG File",3,"11/04/2018 10:25",4,"11/04/2018 10:24",5,"11/04/2018 10:25",6,"A",9,"Image",10,"Administrators",11,"Picture",12,"‎11/‎04/‎2018 ‏‎10:16",19,"Unrated",30,"SM-N900",31,"‪4128 x 2322‬",32,"samsung",35,"N900XXSEBPL3",53,"INMUCHLP02217 (this computer)",155,"Test.jpg",160,"24",161,"‎72 dpi",162,"‎4128 pixels",163,"‎72 dpi",164,"‎2322 pixels",173,"No",176,"_folder1",177,"D:\\pic\\_folder1",178,"_folder1 (D:\\pic)",180,"D:\\pic\\_folder1\\Test.jpg",182,"JPG File",188,"Unresolved",230,"0220",233,"Normal",235,"f/2.2",237,"‎4 mm",238,"31",243,"2.27",244,"Center Weighted Average",245,"Rotate 270 degrees",247,"Normal program",250,"Auto",269,"Not shared"]

{"sheet":"SampleInfo","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"flags":["formulas_cached_only"]}
["1:1.69 MB\n2:JPG File\n3:10/04/2018 19:30\n4:10/04/2018 19:30\n5:10/04/2018 19:30\n6:A\n9:Image\n10:Administrators\n11:Picture\n12:?10/?04/?2018 ??18:14\n19:Unrated\n30:Redmi Note 4\n31:?3120 x 4160?\n32:Xiaomi\n35:mido-user 7.0 NRD90M V9.2.1.0.NCFMIEK release-keys\n53:INMUCHLP02217 (this computer)\n155:IMG_20180410_181411.jpg\n160:24\n161:?72 dpi\n162:?3120 pixels\n163:?72 dpi\n164:?4160 pixels\n173:No\n176:_folder1\n177:D:\\pic\\_folder1\n178:_folder1 (D:\\pic)\n180:D:\\pic\\_folder1\\IMG_20180410_181411.jpg\n182:JPG File\n188:Unresolved\n230:0220\n233:Unknown\n234:?1/33 sec.\n235:f/2\n236:No flash, compulsory\n237:?4 mm\n238:21\n239:ISO-250\n244:Center Weighted Average\n247:Not defined\n250:Auto\n269:Not shared\n"]