{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Welcome","Preferences","FORMAT"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":43,"n_cols":13,"rows_kept":43,"cut":false,"hidden":false,"merged":[[40,8,40,10],[41,8,41,10],[42,8,42,10],[37,12,39,14],[40,12,40,14],[41,12,41,14],[42,12,42,14],[0,0,0,11],[3,5,3,6],[1,0,16,0],[1,11,16,11],[37,8,39,10],[17,0,17,11],[1,1,1,10],[2,1,2,10],[4,1,4,10],[5,1,5,10],[6,1,6,10],[8,1,8,10],[10,1,10,10],[12,1,12,10],[14,1,14,10],[16,1,16,10],[15,3,15,9],[7,3,7,9],[9,3,9,9],[11,3,11,9],[13,3,13,9]]}
[]
[null,"MANIFEST IMAGE CREATOR"]
[null,"FOR JMRI"]
[null,null,null,null,null,"MIC4JMRI"]
[null,{"$f":" \"Version \" & Preferences!B2 & \" \" & Preferences!C2 & \" as of \" & Preferences!C3","v":"Version Beta 30 as of 05/09/17"}]
[null,"Select one of the Options"]
[]
[null,null,"Create\nManifest","Click the Create Manifest Button"]
[]
[null,null,"Set\nPrefs","To set Preferences, simply select the Preferences Tab below, and make your changes"]
[]
[null,null,"Set\nFormat","To set Format, simply select the FORMAT Tab below, and make your changes"]
[]
[null,null,"View/\nPrint\nManifest","To View/Print, simply select the Tab below, selecting the train you wish to View/Print"]
[]
[null,null,"Exit ","To Exit, use your normal exit from Excel process. If you want to save the Manifest(s) or any changes you make to Preferences or Format, be certain to Save when Exiting"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"IMAGE NOT FOUND",null,null,null,"IMAGE NOT FOUND"]
[]
[]
[null,null,null,null,null,null,null,null,"Car#: SSAM-87649",null,null,null,"Car#: BN-459512"]
[null,null,null,null,null,null,null,null,"Load: E_Mty",null,null,null,"Load: E_Mty"]
[null,null,null,null,null,null,null,null,"Trk: NW Pea & Bean",null,null,null,"Trk: NW Pea & Bean"]

{"sheet":"Preferences","index":1,"n_rows":37,"n_cols":19,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
["Version #","Beta",30]
["Latest Release",null,"05/09/17"]
["Test Run:","[Y or N]","N",null,"This will provide two special headers at the beginning of the manifest - provide File Name and MIC4JMRI Version Number",null,null,null,null,null,null,null,null,null,null,null,"Possible Record Type Codes"]
["Number of Columns:","[3,4 or 5]",5,null,"Select 3, 4 or 5 columns for Car information",null,null,null,null,null,null,null,null,null,null,null,null,"Code","Use"]
["Include Load:","[Y or N]","Y",null,"Include the Car Load",null,null,null,null,null,null,null,null,null,null,null,null,"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",null,null,null,null,null,null,null,null,null,null,null,null,"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)",null,null,null,null,null,null,null,null,null,null,null,null,"CC","Change Caboose"]
["Row between Size:","[nn.nn]",5,null,"Height of Spacer Row - Set to 0 if no space is desired",null,null,null,null,null,null,null,null,null,null,null,null,"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",null,null,null,null,null,null,null,null,null,null,null,null,"DT","Departure Time"]
["Car Info Row Size:","[nn.nn]",12,null,"Size of Row for RoadName-CarNumber",null,null,null,null,null,null,null,null,null,null,null,null,"DTR","Route Departure Time"]
["Load Row Size:","[nn.nn]",12,null,"Size of Row for Load",null,null,null,null,null,null,null,null,null,null,null,null,"EDT","Estimated Departure Time"]
["Pickup Row Size:","[nn.nn]",12,null,"Size of Row for Pickup Track",null,null,null,null,null,null,null,null,null,null,null,null,"LC","Location Comment"]
["Setout Row Size:","[nn.nn]",12,null,"Size of Row for Setout Track",null,null,null,null,null,null,null,null,null,null,null,null,"LN","Location"]
["Comment Row Size:","[nn.nn]",15,null,"Size of Row for Comments",null,null,null,null,null,null,null,null,null,null,null,null,"LOGO","User supplied Logo"]
["Heading Row Size:","[nn.nn]",15,null,"Size of Row for Headers … Pickups, Setouts, Moves, NoWork",null,null,null,null,null,null,null,null,null,null,null,null,"NW","Mo Work"]
["Exit Location Row Size:","[nn.nn]",15,null,"Size of Row for Leaving a Location",null,null,null,null,null,null,null,null,null,null,null,null,"PC","Pickup Car"]
["Car Destination Location:","[Y or N]","Y",null,"Include row for Car's destination Location",null,null,null,null,null,null,null,null,null,null,null,null,"PL","Pickup Loco"]
["Print HardCopy","[Y or N]","Y","N","Print manifest to paper(or default printer)",null,null,null,null,null,null,null,null,null,null,null,null,"PRNTR","Printer other than default"]
["Print Cell Borders","[Y or N]","N",null,"Print borders around all the cells",null,null,null,null,null,null,null,null,null,null,null,null,"RH","Remove Helper"]
["Save Manifest to File","[Y or N]","Y",null,"Save each manifest to it's own  file for later use (should we put them in a different directory?)",null,null,null,null,null,null,null,null,null,null,null,null,"RLC","Route Location Comment"]
["Page Size ","[nnnn]",660,null,"Set page size for inserting page breaks",null,null,null,null,null,null,null,null,null,null,null,null,"RN","Railroad Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SC","Setout Car"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SL","Setout Loco"]
["Record Types to Use:",null,"DT,LC,LN,NW,PC,PL,RLC,RN,SC,TC,TD,TL,TN,TT,TW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SMC","Missing Car"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SMCM","Missing Car Message"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC","Train Comment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TD","Train Departs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TKCB","Track Comment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TKCP","Track Comment - Pickup"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TKCS","Track Comment - Setout"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TL","Train Length"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TM","Train Manifest Description"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TN","Train Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TT","Train Terminates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TW","Train Weight"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VT","Valid (Date & Time)"]

{"sheet":"FORMAT","index":2,"n_rows":49,"n_cols":26,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,0,48,3],[8,15,9,15],[20,0,20,14],[21,0,21,14],[22,0,22,14],[12,0,12,1],[13,0,13,1],[14,0,14,14],[15,0,15,14],[16,0,16,14],[17,0,17,14],[18,0,18,14],[19,0,19,14],[8,0,9,1],[10,0,10,1],[11,0,11,1],[7,9,7,10],[0,0,0,14],[7,0,7,2],[9,4,9,7],[7,4,7,7],[8,4,8,7],[1,15,3,15],[1,4,4,7],[5,4,5,7],[6,4,6,7],[1,0,3,2],[4,0,4,2],[5,0,5,2],[4,9,4,10],[5,9,5,10],[6,9,6,10],[1,9,2,10],[3,9,3,10],[6,0,6,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hdr-Gen",null,null,null,null,null,null,null,null,null,{"$f":"A1","v":0}]
["4-Wide",null,null,null,"3-Wide",null,null,null,null,"5-Wide",null,null,null,null,null,"Image/\nCar Not\nFound"]
[]
[null,null,null,null,null,null,null,null,null,"Car#: "]
["Car#: ",null,null,null,null,null,null,null,null,"Load: ",null,null,null,null,null,"RN-CN"]
["Load: ",null,null,null,"Car#: ",null,null,null,null,"Frm: ",null,null,null,null,null,"Load-Opt"]
["Trk: ",null,null,null,"Load: ",null,null,null,null,"To: ",null,null,null,null,null,"From-Opt"]
["Trk: ",null,null,null,"Trk: ",null,null,null,null,"?????",null,null,null,null,null,"To-Opt"]
["5-Wide",null,null,null,"Trk: ",null,null,null,null,null,null,null,null,null,null,"Image/Car\nNot Found"]
[null,null,null,null,"?????"]
["Car#: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RN-CN"]
["Load: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Load-Opt"]
["Trk: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"From-Opt"]
["Trk: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To-Opt"]
["Not used at this time. Location has been added to Pickups, Setouts, Moves, & No Work",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hdr-Loc"]
["LOCATION /*/ PICKUPS ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hdr-Pic"]
["LOCATION /*/ SETOUTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hdr-Set"]
["LOCATION /*/ MOVES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HDR-Mov"]
["LOCATION /*/ NO WORK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hdr-NWk"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hdr-Com",null,null,null,null,null,null,null,null,null,{"$f":"A20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hdr-???"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spacer Row"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exit Location"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Trk: "]