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

{"sheet":"Welcome","index":0,"n_rows":17,"n_cols":6,"rows_kept":17,"merged":[[0,0,0,11],[1,0,19,0],[1,1,1,10],[1,11,19,11],[2,1,2,10],[3,5,3,6],[4,1,4,10],[5,1,5,10],[6,3,6,9],[7,3,7,9],[8,1,8,10],[9,3,10,9],[11,1,11,10],[12,3,13,9],[15,1,15,10],[16,3,17,9],[18,1,18,10],[19,1,19,10],[20,0,20,11]]}
[]
[null,{"$f":"Preferences!A1","v":"MANIFEST CREATOR II"}]
[null,"FOR JMRI"]
[{"$nulls":5},{"$f":"Preferences!B1","v":"MC2-4JMRI"}]
[null,{"$f":" \"Version \" &  Preferences!B2 & \" \"  & Preferences!C2 & \" as of \" & Preferences!C3","v":"Version  2.0 as of 04/04/19"}]
[null,"Select one of the Options"]
[{"$nulls":3},"Click the Create Manifest Button to creat a Manifest (duh)"]
[]
[]
[{"$nulls":3},"Allows changing of various  Record Types to be included from the CSV File to Process."]
[]
[]
[{"$nulls":3},"Change default values for the  the various lines used for the output. "]
[]
[]
[]
[{"$nulls":3},"Exit the program when finished creating Manifests"]

{"sheet":"Revisions","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Preferences","index":2,"n_rows":41,"n_cols":22,"rows_kept":41,"merged":[[0,1,0,2],[3,4,3,15],[3,16,3,20],[4,4,4,15],[4,18,4,20],[5,4,5,15],[5,18,5,20],[6,4,6,15],[6,18,6,20],[7,4,7,15],[7,18,7,20],[8,4,8,15],[8,18,8,20],[9,4,9,14],[9,18,9,20],[10,4,10,15],[10,18,10,20],[11,4,11,15],[11,18,11,20],[12,4,12,15],[12,18,12,20],[13,4,13,14],[13,18,13,20],[14,4,14,14],[14,18,14,20],[15,18,15,20],[16,4,16,14],[16,18,16,20],[17,4,17,14],[17,18,17,20],[18,4,18,14],[18,18,18,20],[19,4,19,14],[19,18,19,20],[20,4,20,14],[20,18,20,20],[21,4,21,15],[21,18,21,20],[22,4,22,14],[22,18,22,20],[23,4,23,14],[23,18,23,20],[24,4,24,14],[24,18,24,20],[25,4,25,14],[25,18,25,20],[26,4,26,15],[26,18,26,20],[27,4,27,15],[27,18,27,20],[28,18,28,20],[29,18,29,20],[30,18,30,20],[31,18,31,20],[32,4,32,14],[32,18,32,20],[33,18,33,20],[34,18,34,20],[35,18,35,20],[36,18,36,20],[37,18,37,20],[38,18,38,20],[39,18,39,20],[40,18,40,20]]}
["MANIFEST CREATOR II","MC2-4JMRI"]
["Version #",null,"2.0"]
["Latest Release",null,"04/04/19"]
["Test Run:","[Y or N]","N","Default=N","Provide special headers at the end of the switch list - listing Preferences used to build the Switch List",{"$nulls":11},"Place an 'X' beside Record Types to Use"]
["Number of Columns:","[3,4 or 5]",5,null,"Select 3, 4 or 5 columns for Car information",{"$nulls":11},"USE","CODE","RECORD TYPES"]
["Include Load:","[Y or N]","Y",null,"Include the Car Load",{"$nulls":12},"AH","Add Helper"]
["Include Track:","[Y or N]","Y",null,"Include the Track - Pickup Track for Pickups, Setout Track for Setouts and Both for MOVEs",{"$nulls":11},"X","AT","Arrival Time"]
["Row between Images:","[Y or N]","Y",null,"Would you like Spacer Row between one set of Cars and the Next (not required-just set Space Row Height to zero (0)",{"$nulls":12},"CC","Change Caboose"]
["Row between Size:","[nn.nn]",5,null,"Height of Spacer Row - Set to 0 if no space is desired",{"$nulls":12},"CL","Change Loco"]
["Image Row Size (x2):","[nn.nn]",15,null,"Size of Rows used for Image - there are 2 Rows, this is the height of just one of the two Rows",{"$nulls":11},"X","DT","Departure Time",null,null,"Default"]
["Car Info Row Size:","[nn.nn]",15,null,"Size of Row for RoadName-CarNumber",{"$nulls":11},"X","DTR","Route Departure Time"]
["Load Row Size:","[nn.nn]",15,null,"Size of Row for Load",{"$nulls":11},"X","EDT","Estimated Departure Time"]
["Pickup Row Size:","[nn.nn]",15,null,"Size of Row for Pickup Track",{"$nulls":12},"HOLD","Other Cars at Location"]
["Setout Row Size:","[nn.nn]",15,null,"Size of Row for Setout Track",{"$nulls":11},"X","LC","Location Comment",null,null,"Default"]
["Comment Row Size:","[nn.nn]",15,null,"Size of Row for Comments",{"$nulls":11},"X","LN","Location",null,null,"Default"]
["Heading Row Size:","[nn.nn]",15,{"$nulls":14},"LOGO","Include a LOGO"]
["Exit Location Row Size:","[nn.nn]",15,null,"Size of Row for Leaving a Location",{"$nulls":11},"X","NW","Mo Work",null,null,"Default"]
["LOGO:","[Y or N]","N",null,"Include row for Car's destination Location",{"$nulls":11},"X","PC","Pickup Car",null,null,"Default"]
["Print Preview:","[Y or N]","Y","Default=Y","Preview Manifest",{"$nulls":11},"X","PL","Pickup Loco",null,null,"Default"]
["Print HardCopy","[Y or N]","Y","Default=Y","Print manifest to paper(or default printer)",{"$nulls":12},"PRNTR","Printer other than default"]
["Ask To Print HardCopy:","[Y or N]","Y","Default=Y","Ask if the manifest should still be printer after being Previewed. ",{"$nulls":11},"X","RC","Route Coment",null,null,"Default"]
["Print Cell Borders","[Y or N]","N","Default=N","Print borders around all the cells",{"$nulls":12},"RH","Remove Helper"]
["Save Manifest to File","[Y or N]","N","Default=N","Save each manifest to it's own  file for later use (should we put them in a different directory?)",{"$nulls":11},"X","RLC","Route Location Comment",null,null,"Default"]
["Comment Separator:","3 char","/*/",null,"Used to split Comments into separate lines",{"$nulls":11},"X","RN","Railroad Name",null,null,"Default"]
["Record Types to Use:","NA","NA",null,"Select the Record Types you would like to include by placing an 'X'  by the Record Type in the 'USE' Column ===>",{"$nulls":11},"X","SC","Setout Car",null,null,"Default"]
["Line Length:","nn",60,null,"Number of characters that will fit on one row …",{"$nulls":11},"X","SL","Setout Loco",null,null,"Default"]
["LOGO:","[Y/N]","Y","Default=Y","Would you like a LOGO. It can be the none, JMRI Logo, your LOGO, or one specified in the LOGO Record Type …",{"$nulls":11},"x","SMC","Missing Car"]
["LOGO File Name:","JMRI_LOGO_Trans.png",null,null,"LOGO-Western Bay RR logo.jpg",{"$nulls":11},"x","SMCM","Missing Car Message"]
["Show Destination on Pickups:","[Y or N]","N","Default=N","If Y, the destination can be used for Blocking",{"$nulls":11},"X","TC","Train Comment",null,null,"Default"]
["Show Car Load:","[Y or N]","Y","Default=Y",{"$nulls":12},"X","TD","Train Departs",null,null,"Default"]
["Show Car Type:","[Y or N]","Y","Default=Y",{"$nulls":13},"TKCB","Track Comment"]
["Show Car Color:","[Y or N]","Y","Default=N",{"$nulls":13},"TKCP","Track Comment - Pickup"]
["MC Message:","[Y or N]","Y","Default=N","Handle Equipment with Care/*/Have Fun",{"$nulls":12},"TKCS","Track Comment - Setout"]
[{"$nulls":16},"X","TL","Train Length",null,null,"Default"]
[{"$nulls":16},"X","TM","Train Manifest Description",null,null,"Default"]
[{"$nulls":16},"X","TN","Train Name",null,null,"Default"]
[{"$nulls":17},"TRUN","Truncate - No output if SWL"]
[{"$nulls":16},"X","TT","Train Terminates",null,null,"Default"]
[{"$nulls":16},"X","TW","Train Weight",null,null,"Default"]
[{"$nulls":17},"VT","Valid (Date & Time)"]
[{"$nulls":16},"X","CREW","Add line for assigned crew",null,null,"MC Add In"]

{"sheet":"FORMAT","index":3,"n_rows":30,"n_cols":21,"rows_kept":30,"merged":[[0,1,0,5],[1,1,1,5],[2,1,2,3],[2,4,2,5],[3,1,3,3],[3,4,3,5],[4,1,4,5],[5,1,5,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[15,1,15,3],[15,4,15,5],[16,2,16,3],[17,1,17,5],[18,1,18,5],[19,1,19,5],[20,1,20,5],[23,1,23,5],[24,1,24,5],[26,1,26,5],[27,1,27,5],[29,1,29,5],[31,1,31,5]]}
[null,"Manifest & Switch List - Page /*/",{"$nulls":10},15,"Header Data & Blank Line",1,null,null,"Broadway",12,"Bold"]
[null,"/*/",{"$nulls":10},15,"Blank with overline",2,null,null,"Copper Black",11,"Bold","Courier New"]
[null,"Throttle #:",null,null,"Train:",{"$nulls":7},15,"Consist Header",3,null,null,"Copper Black",11,"Bold","Courier New"]
[null,"Departs:",null,null,"Origin:",{"$nulls":7},15,"Departs Header",4,null,null,"Copper Black",9,"Normal","Courier New"]
[null,"Manifest Leaving /*/",{"$nulls":10},15,"Location",5,null,null,"Copper Black",11,"Bold","Courier New"]
[{"$nulls":12},15,"Route Location Comment",6,null,null,"Courier New",9,"Normal"]
[null,"RN","CAR #","LOAD (Haz)","TRACK from",{"$nulls":7},15,"Pickup",7,null,null,"M+ 1M",9,"Normal"]
[null,"RN","CAR #","LOAD (Haz)","TRACK from",{"$nulls":7},15,"Setout",8,null,null,"M+ 1M",9,"Normal"]
[null,"RN","CAR #","LOAD (Haz)","TRACK from",{"$nulls":7},15,"Move-From Line",9,null,null,"M+ 1M",9,"Bold"]
[null,"No Work @ /*/",{"$nulls":10},15,"No Work",10,null,null,"Copper Black",11,"Normal","Courier New"]
[null,"Normal Comment Can Go Here",{"$nulls":10},15,"Comment",11,null,null,"Courier New",9,"Normal","Arial Narrow"]
[null,"Depart /*/",{"$nulls":10},15,"Departs",12,null,null,"Copper Black",11,"Normal","Courier New"]
[null,"Terminate /*/",{"$nulls":10},15,"Terminate",13,null,null,"Copper Black",11,"Normal","Courier New"]
[{"$nulls":3},"Move To:","TRACK to",{"$nulls":7},15,"Move-To Line",14,null,null,"M+ 1M",9,"Bold"]
[{"$nulls":3},"Send To:","TRACK to",{"$nulls":7},15,"Pickup-To Line",15,null,null,"M+ 1M",9,"Normal"]
[{"$nulls":12},15,"Consist/Departs Data",16,null,null,"Courier New",9,"Normal"]
[null,"RN","CAR INFO",null,"TRACK","X",{"$nulls":6},15,"Headers Row Info",17,null,null,"Courier New",12,"Bold"]
[null,"Arrive /*/",{"$nulls":10},15,"Arrives",18,null,null,"Copper Black",11,"Bold","Courier New"]
[null,"PICKUPS for /*/",{"$nulls":10},15,"PICKUPs Header",19,null,null,"Copper Black",11,"Normal","Courier New"]
[null,"SETOUTS for /*/",{"$nulls":10},15,"SETOUTS Header",20,null,null,"Copper Black",11,"Normal","Courier New"]
[null,"MOVES for /*/",{"$nulls":10},15,"MOVEs Header",21,null,null,"Copper Black",11,"Normal","Courier New"]
[null,"RN","LOCO #","TYPE","TRACK",{"$nulls":7},15,"Pickup Loco",22,null,null,"M+ 1M",9,"Bold/Italic"]
[null,"RN","LOCO #","TYPE","TRACK",{"$nulls":7},15,"Setout Loco",23,null,null,"M+ 1M",9,"Normal"]
[null,"HELPER: /*/",{"$nulls":10},15,"Add Helper",24,null,null,"Courier New",9,"Normal"]
[null,"LOCOs for /*/",{"$nulls":10},15,"Header for Locos",25,null,null,"Copper Black",11,"Bold","Courier New"]
[null,"RN","LOCO #","TYPE","TRACK",{"$nulls":7},15,"Setout Loco",26,null,null,"M+ 1M",9,"Bold/Italic"]
[null,"Centered Comment Can Go Here",{"$nulls":10},15,"Comment-Centered",27,null,null,"Courier New",9,"Normal"]
[null,"HOLDS for /*/",{"$nulls":10},15,"HOLDs Header",28,null,null,"Copper Black",11,"Normal","Courier New"]
[null,"RN","CAR #","LOAD (Haz)","TRACK",{"$nulls":7},15,"HOLD",29,null,null,"M+ 1M",9,"Bold"]
[null,"CREW:",{"$nulls":10},15,"CREW Line *",30,null,null,"Copper Black",11,"Normal"]