{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Welcome","Revisions"],"not_rendered":{"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[0,0,0,11],[1,0,18,0],[1,1,1,10],[1,11,18,11],[2,1,2,10],[3,5,3,6],[4,1,4,6],[4,7,4,10],[5,1,5,10],[6,4,7,9],[8,1,8,10],[8,13,8,14],[9,4,10,9],[11,2,13,2],[11,13,11,14],[12,4,13,9],[14,1,14,10],[15,2,17,2],[15,4,16,9],[18,1,18,10],[19,0,19,11]]}
[]
[null,"MANIFEST CREATOR"]
[null,"FOR JMRI"]
[{"$nulls":5},{"$f":"Revisions!B4","v":"MC3-4JMRI"}]
[null,{"$f":" \"Version \" &  Revisions!B1 & \".\"  & Revisions!B2 & \" as of  \"","v":"Version 7.03d as of  "},{"$nulls":5},{"$f":"Revisions!B3","v":"2023-11-08"}]
[]
[{"$nulls":4},"Click the Create Manifest Button to creat a Manifest (duh)"]
[]
[]
[{"$nulls":4},"Click the Set Preferences Button to Set Preferences"]
[]
[]
[{"$nulls":4},"Click the Set Format Button to Set Format"]
[]
[]
[{"$nulls":4},"Click the Exit Button to Exit the App"]

{"sheet":"Revisions","index":1,"n_rows":256,"n_cols":4,"rows_kept":256,"merged":[[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[11,2,11,9],[12,2,12,9],[15,0,15,1],[19,0,19,1],[22,3,22,12],[23,0,23,1],[27,0,27,1],[32,0,32,1],[34,0,34,1],[36,0,36,1],[38,0,38,1],[41,0,41,1],[43,0,43,1],[111,0,111,1],[112,0,112,1],[113,0,113,1],[142,0,142,1],[144,0,144,1],[146,0,146,1],[148,0,148,1],[150,0,150,1],[152,0,152,1],[154,0,154,1],[157,0,157,1],[159,0,159,1],[161,0,161,1],[163,0,163,1],[166,0,166,1],[168,0,168,1],[170,0,170,1],[173,0,173,1],[175,0,175,1],[177,0,177,1],[179,0,179,1],[181,0,181,1],[184,0,184,1],[186,0,186,1],[188,0,188,1],[190,0,190,1],[192,0,192,1],[195,0,195,1],[198,0,198,1],[200,0,200,1],[202,0,202,1],[205,0,205,1],[208,0,208,1],[210,0,210,1],[212,0,212,1],[215,0,215,1],[217,0,217,1],[220,0,220,1],[224,0,224,1],[228,0,228,1],[230,0,230,1],[233,0,233,1],[235,0,235,1],[238,0,238,1],[241,0,241,1],[244,0,244,1],[248,0,248,1],[250,0,250,1],[254,0,254,1]]}
["Release:","7"]
[null,"03d"]
["Date:","2023-11-08"]
["App:","MC3-4JMRI"]
["==========================================================|"]
["==========================================================|",null,null,{"$f":"B3","v":"2023-11-08"}]
["=====                     MICII4JMRI                 =====|"]
["=====           OFFICIAL RELEASE VERSION 1.0         =====|"]
["=====                      11/15/16                  =====|"]
["==========================================================|"]
["==========================================================|"]
["Version 7.03dc as of 11/08/23",null,"Copy this cell using Copy Values after changing the information In B2, B3, and B4"]
[null,"Added auto backup in Open_Workbook","Copy this row to add comments"]
[null,"Cleaned up some of the debug statements"]
[null,"Logo does work but need to better understand how it works"]
["Version 7.03c as of 11/08/23"]
[null,"Version 7.02 did not exist"]
[null,"csvImages is at the same level as csvManifess and csvSwitchLists"]
[null,"In this way there is only one copy of each car image independent of Manifest or SwitchList"]
["Version 7.03 as of 10/10/23"]
[null,"Version 7.02 did not exist"]
[null,"csvImages is at the same level as csvManifess and csvSwitchLists"]
[null,"In this way there is only one copy of each car image independent of Manifest or SwitchList"]
["Version 7.01 as of 02/03/21"]
[null,"Corrected issue with DT Record when there is a PL Record"]
[null,"This was caused when added the DCC Address Row option"]
[null,"E:\\000-MainDrive\\Desktop\\DC-MC3 DEMO\\csvManifests"]
["Version 7.0 2/3/2021"]
[null,"E:\\OneDrive\\Documents\\Operations\\DansManifestCreator\\csvManifests\\MC3-Home"]
[null,"Read the CSV file and Sort all rows that contain PC (by Location)"]
[null,"Added Preference for selecting to Sort or Not to Sort"]
[null,"Sort Routine Variables are at beginning of DIM statements"]
["Version 6.04 02/02/21"]
[null,"Started The LocationTrack Sort"]
["Version 6.04 02/01/21"]
[null,"Added sort Preference for Pickup Location & Track"]
["Version 6.04 01/08/20"]
[null,"Removed Exits from Get_Pref and Get_Form subroutines"]
["Version 6.03 11/17/19"]
[null,"Tweaked the Main Menu format a bit"]
[null,"Row Height & Button size in White text"]
["Version 6.02 6/23/2019"]
[null,"Set the correct format line for Loco DCC Address"]
["Version 6.00-Update -04/11/19"]
[null,"Working on Missing Cars"]
[null,"Need to move End Of File Processing and set PrintArea"]
[null,"G:\\operations\\FrankWyatt-190621-LLC3-LogoDCCAddress"]
[null,"Added Missing Car Routine"]
["Version 6.00 04/04/19"]
[null,"Fixed double \"Train Originates\" message on when DT record."]
["Version 5.2a 10/07/18"]
[null,"Fixed double \"Train Originates\" message on when DT record."]
["Version 5.2 09/17/18"]
[null,"Cleared out Detination Track on Setout"]
["Version 5.1 09/16/18"]
[null,"Cleaned up the LOGO Error messages for better alignment"]
["Version 5.0 07/16/18"]
[null,"First attempt with MC and LLC Code Combined"]
[]
["Version 4.4k 07/16/18"]
[null,"G:\\operations\\csvManifests\\HomeDirectory-MICII4JMRI-HomeDirectory"]
["Version 4.4j 07/05/18"]
[null,"Added Column selection for Images"]
["Version 4.4i 07/05/18"]
[null,"Modified the Welcome Screen"]
["Version 4.4h 06/20/18"]
[null,"Improve Hyphen process"]
["Version 4.4g 06/18/18"]
[null,"Treat hyphen just as JMRI"]
["Version 4.4f 06/15/18"]
[null,"Treat hyphen just as JMRI"]
["Version 4.4e 06/13/18"]
[null,"Fixed error if TN but no TM for line 74 Manifest for xxxx"]
["Version 4.4d 06/13/18"]
[null,"Fixed error on link to PrefMast worksheet from menu"]
["Version 4.4c 06/05/18","F:\\operations\\csvManifests\\HomeDirectory-MICII4JMRI-HomeDirectory"]
[null,"Further compression of SLC extra character routine"]
["Version 4.4b 06/04/18"]
[null,"Fixed some issues with Destination Location vs Destination Track"]
["Version 4.4a 06/04/18"]
[null,"Added common routine to handle SLC extra characters"]
[null,"Changed Process Detail to use CSV Record Fields"]
["Version 4.4 06/03/18"]
[null,"Changed PrefMast - New secondary version"]
["Version 4.3h 06/03/18"]
[null,"Work on Car Counts"]
["Version 4.3g 06/03/18"]
[null,"Additional work on moving Car Columns"]
["Version 4.3f 06/02/18"]
[null,"Fixed Logo processing"]
["Version 4.3e 05/30/18"]
[null,"Fixed moveable Car Info Columns"]
[null,"Changed method for selecting record types - only 'y' will select."]
[null,"Initial Code for DTR Record Type"]
["Version 4.3d 04/14/18"]
[null,"Added drive path to LOGO filename - need to check if path is there"]
["Version 4.3c 04/14/18","G:\\operations\\csvManifests\\remanifestcreatoriiiissues"]
[null,"Add variable to Workbook_Open Macro"]
["Version 4.3b 04/12/18"]
[null,"Added Error Checking for PrefMast access"]
["Version 4.3 04/07/18"]
[null,"Just In Case after 4.2 testing of LINK"]
["Version 4.2 04/07/18"]
[null,"Display Path on Welcome Screen B19"]
[null,"Run from external drive"]
["Version 4.1 0 04/05/18"]
[null,"Fixed Link process"]
["Version 4.0 - 03/31/18"]
[null,"VBA Code Copied Between MCIII & MICII"]
[null,"Including DCC Address is now a Preference - and its onw line"]
[null,"PL Comment is now a Preference"]
["*************************************"]
["VBA Code is now used for Both MCIII and MICII"]
["*************************************"]
["Version 3.8a - 03/29/18"]
[null,"Changes to DCC Address info on Manifest"]
["Version 3.8 - 03/12/18"]
[null,"Image lookup use the standard Image folder csvImages"]
["Version 3.7 - 03/10/18"]
[null,"Fixed issues with Print Border routine"]
["Version 3.6 - 02/21/18"]
[null,"Another update from MCIII"]
["Version 3.5 - 02/11/18"]
[null,"Clean up Variables and put in Alpha sequence"]
["Version 3.4 - 02/09/18"]
[null,"Tweaks"]
["Version 3.3 - 02/04/18"]
[null,"Code is identical to MCIII"]
["Version 3.2 - Skipped"]
[null,"Added changes made to MCIII"]
["Version 3.1 - 02/03/18"]
[null,"Added changes made to MCIII"]
["Version 3.0- 01/23/18"]
[null,"Changed version to match MCIII"]
["Version 1.A - 01/23/18"]
[null,"Added routine to Show DCC Address"]
["Version 1.9 - 01/22/18"]
[null,"Worked on Page Header Routine - ???"]
["Version 1.8 - 01/21/18"]
[null,"Add PL Record Comment"]
["Version 1.7 - 01/19/18"]
[null,"Added Record Type RC"]
["Version 1.6 - 01/17/18"]
[null,"Removed Stop statement in TC Routine"]
["Version 1.5 - 01/15/18"]
[null,"Made code like MCIII"]
["Version 1.4 - 01/12/18"]
[null,"Made code like MCIII"]
["Version 1.3 - 01/07/18"]
[null,"Change all Pref compares to Left,1,Ucase"]
["Version 1.2 - 01/06/18"]
[null,"Compare Upper Case for Include Images preference"]
["Version 1.1 - 01/05/18"]
[null,"Fixed Page Heading issue"]
["Version 1.0 - 01/04/18"]
[null,"Rought conversion from MCIII4JMRI adding images"]
[null,"Changed Row back to normal size, will increase for Image"]
["Version 2.9 - 12/21/17"]
[null,"Changes to runn with Excel 2003 and below"]
["Version 2.8 - 12/09/17"]
[null,"Fix page numbering problem introduced in 2.7"]
["Version 2.7 - 12/08/17"]
[null,"Setup more Record Types to FORMAT Row"]
["Version 2.6 - 12/08/17"]
[null,"Add Train Number to Manifest Heading"]
[null,"Added MOVE and HOLD counts to Train Departs message"]
["Version 2.5 - 12/07/17"]
[null,"Fix MC Special Comment handling"]
["Version 2.4 - 12/03/17"]
[null,"Fix LOGO processing"]
["Version 2.3 - 12/03/17"]
[null,"Put Car Counts back in"]
[null,"Add MC Message after Train Name"]
["Version 2.2 - 12/01/17"]
[null,"Chage location of FORMAT Rows and add for other Record types"]
["Version 2.1 - 12/01/17"]
[null,"Major Changes to be more like SLCIII"]
["Version 2.0 - 11/26/17"]
[null,"Major Changes to be more like SLCIII"]
["Version 1.A5 - 11/13/17"]
[null,"Added PL/SL Routines"]
["Version 1.A4 - 11/15/17"]
[null,"Changed the counting of Loads and Empties"]
[null,"Added \"jump start value\" in finding Page Header routine"]
["Version 1.A3 - 10/19/17"]
[null,"Added documentation to FORMAT Worksheet"]
["Version 1.A2 - 10/11/17"]
[null,"Added routine for Departure Time - DT Record"]
["Version 1.A1 - 10/05/17"]
[null,"Build Car Info Header from Field sequence settings"]
["Version 1.A - 10/04/17"]
[null,"General Cleanup"]
["Version 1.9h-5 - 10/03/17"]
[null,"Fixed Pref for Printing Car Info Headers"]
[null,"Fixed Reset Variables routine"]
["Version 1.9h-4 - 10/02/17"]
[null,"Removed (comment) Code for Car Info Headers"]
[null,"Removed (comment) Code for Page Breaks"]
["Version 1.9h-3 - 09/28/17"]
[null,"Added Pref for Printing Car Info Headers"]
["Version 1.9h-2 - 09/26/17"]
[null,"Added Pref for SO Destination column"]
["Version 1.9h-1 - 09/25/17"]
[null,"Changed Destination field for Frank"]
[null,"Fixed Bug witgh Logo processing"]
["Version 1.9h - 09/11/17"]
[null,"Add logic for user to select columns for Car Fields"]
[null,"Continue working on User Selectable"]
["Version 1.9g - 01/07/17"]
[null,"Changed order of fields for Frank W."]
["Version 1.9f - 08/30/17"]
[null,"Work on RLC record type"]
["Version 1.9e - 08/29/17"]
[null,"Fixed Link process"]
[null,"Fixed Print Manifest process"]
["Version 1.9d - 08/29/17"]
[null,"Move Type to First position on line"]
["Version 1.9C - 08/27/17"]
[null,"Fixed Comments Routine"]
[null,"Added full departure information"]
["Version 1.9b - 08/24/17"]
[null,"Move Load to Last Position on Line"]
[null,"Fix Space for LOGO"]
[null,"Added Subroutine holders for all Record Types"]
["Version 1.9a - 08/23/17"]
[null,"Inserted Column F to hold Load"]
[null,"Made all other necessary adjustments"]
[null,"Fixed Preference to Print Destination [Y/N]"]
["Version 1.9 - 08/22/17"]
[null,"Incorporate standard Car Info Y/N Preferences"]
["Version 1.8 - 04/01/17"]
[null,"New Method to obtain Record Types to use"]
[null,"Changed Move format to have From & To fields"]
["Version 1.7 - 12/20/16"]
[null,"Fixed Error Msg when running from JMRI Link"]
["Version 1.6 - 12/17/16"]
[null,"Added buttons for all features"]
[null,"with return buttons on applicable pages."]
["Version 1.5 - 12/15/16"]
[null,"Corrected the application name"]
[null,"used at the end of the manifest."]
["Version 1.4 - 12/09/16"]
[null,"Added all possible Record Type"]
[null,"and some general clean up."]
["Version 1.3 - 12/09/16"]
[null,"Added Spacer2 to allow variable height"]
[null,"and to allow Spacer1 to be color filled"]
[null,"to outline a given location"]
["Version 1.2 - 12/08/16"]
[null,"Add Spacer1 to allow variable height"]
["Version 1.1 - 12/08/16"]
[null,"Replace Comment Separater by"]
[null,"looking for line feed character"]
["'"]
["Version 1.0 - 12/05/16"]
[null,"First Production Release"]