{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Notes","agency","calendar","calendar_dates","routes","stops","stop_times","trips","feed_info","shapes","fare_attributes","fare_rules","transfers"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":6,"comments":2,"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":"Notes","index":0,"n_rows":89,"n_cols":9,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
["File info:","ImportExport","version 20210401"]
[]
["Notes:",null,null,"This workbook will manage all data required to generate a GTFS data set. Data must be entered in the tabs listed below as \"required\". Data is generated with Action buttons. Also available are import buttons, if needed. "]
[]
["Tabs:","Title","Supports & links to specification","Requird/Optional",null,null,null,null,"`"]
[null,"agency","agency.txt","Required"]
[]
[null,"calendar","calendar.txt","Required"]
[]
[null,"calendar_dates","calendar_dates.txt","Optional \nRequired if there are exceptions for the service_ids defined in the calendar tab. Open this link for holidays."]
[]
[null,"routes","routes.txt","Required \nA route is a group of trips that are displayed to riders as a single service."]
[]
[null,"stops","stops.txt","Required"]
[]
[null,"stop_times","stop_times.txt","Required"]
[]
[null,"trips","trips.txt","Required \nA trip is a sequence of two or more stops that occurs at specific times."]
[]
[null,"feed_Info","feed_info.txt","Required"]
[]
[null,"shapes","shapes.txt","Optional Defines routes lines on a map. \nRequired if providing continuous_pick-up or drop-off services. "]
[]
[null,"fare_attributes","fare_attributes.txt","Optional"]
[]
[null,"fare_rules","fare_rules.txt","Optional\nFor examples of fare types: "]
[null,null,null,"https://code.google.com/p/googletransitdatafeed/wiki/FareExamples "]
[]
[null,"transfers","transfers.txt","Optional"]
[]
["Actions:"]
[null,null,null,"Exports GTFS data from this Excel file to .txt files."]
[]
[null,null,null,"Calculates distance between trip stops and trip shape_ids and identifies when stops are out of order. Must have at least one shape_id defined to run. Data will display in the stop_times tab. To include all shapes when publishing a fully valid GTFS always run this macro and choose all shapes \"*\" and \"1\" before generating export of GTFS (green) button."]
[]
[null,null,null,"Combines and reconfirms a valid shape_id is numbered one to N (last point on the shape) when shapes have been split, combined or edited. This data displays in the shapes tab."]
[]
[null,null,null,"Replaces an untimed stop (shown with \"*\") with a calculated time, based on the distance between stops. "]
[]
[null,null,null,"Displays in the stops tab which stop_ids and shape_id are used (or not) by which routes and trips."]
[]
[null,null,null,"Exports all shape files (if available) to KML file or clipboard."]
[]
[]
["Import:"]
[null,null,null,"Imports text and appends to existing data."]
[null,null,null,"Imports GTFS data from Excel files; options to delete existing data from all GTFS sheets, or just imported sheets."]
[null,"Notes: When importing data from another Excel file, the files names should be different to avoid confusion. "]
[null,"The tab and column names in both files must be identical for the macro to work. "]
["Assistance:","support@nationalrtap.org","888.589.6821"]
[]
[null,"GTFS Tables Processed:","agency|calendar|calendar_dates|fare_attributes|fare_rules|frequencies|routes|shapes|stops|stop_times|trips|transfers|feed_info|"]
["Code changes:"]
[null,20090120,"Added KML to clipboard in double click support"]
[null,20090128,"Added support for pasting Google Earth driving directions as shape records"]
[null,20090213,"Bug fixes to KML import (double click to capture lines on shape tab)"]
[null,20090213,"Added GPX paste at end of shapes"]
[null,20090224,"Bug fixes"]
[null,20090303,"Rewrote trip export QA"]
[null,20090326,"Fix problems with: Export All Shapes; removing data from all rows on import; Calc shape distance traveled for all shapes"]
[null,20100122,"Bugs: Import XLS was deleting header rows"]
[null,20100811,"KML shape paste from Google Earth routine recoded"]
[null,20101115,"Remove spaces from CSV export of blank cells"]
[null,"201103xx","Add support for optional GTFS tables"]
[null,null,"    add table name to 'GTFS Tables Processed' list above and add sheet with the desired columns"]
[null,null,"    can add columns to the right of existing columns for experimental fields"]
[null,"20110423","Fixed import dialog"]
[null,20110603,"Fixed bug in KML export"]
[null,20110909,"Fixed bug when QA columns missing from stop_times sheet"]
[null,20130301,"Made column index references dynamic"]
[null,20130308,"Added/Updated feet_info tab"]
[null,null,"On import added code to prevent leading zeros from being removed from color columns in route"]
[null,20130411,"Updated column headings to match June 20, 2012  GTFS spec"]
[null,null,"Fixed bugs in Stops Where Used - duplicates result in message, processing continues."]
[null,20150901,"Updated column headings to match February 15, 2015  GTFS spec"]
[null,20150914,"Bug fix for importing to GTFs sheets w/o data rows"]
[null,null,"Added Interpolation macro for stop_times"]
[null,20150915,"stop_times - all calculated columns are deleted for each 'Calculate shape_dist_traveled…' run"]
[null,20150918,"perform checks for missing data while doing calc for distance traveled for stop_times"]
[null,20151002,"Interpolation - fixed midnight crossover "]
[null,null,"Added prompting to ImportXLS for more control"]
[null,20151005,"fixed midnight crossover again :("]
[null,20151009,"Add error messages for missing stops"]
[null,20170330,"Fixes to Stops where used, added Shapes to results"]
[null,20170407,"For Stops Where Used - detects blank rows at bottom"]
[null,20180831,"Update column headings to match August 31, 2018 GTFS spec"]
[null,20180906,"Fixes UTF-8 encoded file manipulations and number separator."]
[null,20200515,"Adds continuous_stops (pick-up/drop-off)"]
[null,20210201,"Refresh Macros as named and subdue tab colors"]

{"sheet":"agency","index":1,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["agency_id","agency_name","agency_url","agency_timezone","agency_lang","agency_phone","agency_fare_url","agency_email"]
["MCT","Muskogee County Transit","https://www.muskogeecountytransit.org","America/Chicago","en","(918)682-1721","https://www.muskogeecountytransit.org/routes","muskogeecountytransitsocial@gmail.com"]

{"sheet":"calendar","index":2,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["service_id","monday","tuesday","wednesday","thursday","friday","saturday","sunday","start_date","end_date"]
["mtwtf",1,1,1,1,1,0,0,"20240101","20301231"]
["sat",0,0,0,0,0,0,0,"20240101","20301231"]
["sun",0,0,0,0,0,0,0,"20240101","20301231"]

{"sheet":"calendar_dates","index":3,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["service_id","date","exception_type"]

{"sheet":"routes","index":4,"n_rows":4,"n_cols":12,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["route_id","agency_id","route_short_name","route_long_name","route_desc","route_type","route_url","route_color","route_text_color","route_sort_order","continuous_pickup","continuous_drop_off"]
["NE","MCT","East","East Route",null,3,"https://www.google.com/maps/d/edit?mid=1svSIFZp06f-ZUVsYKe9cno6c8GWoDKg&usp=sharing"]
["SW","MCT","Southwest","Southwest",null,3,"https://www.google.com/maps/d/edit?mid=1uddmbMg7ydAik-6bXvsTqmY1JuOeAvE&usp=sharing"]
["NW","MCT","Northwest","Northwest",null,3,"https://www.google.com/maps/d/edit?mid=1k0J12KFMFP2kFN7Sr3cK8G6lhhWNfZc&usp=sharing"]

{"sheet":"stops","index":5,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["stop_id","stop_code","stop_name","stop_desc","stop_lat","stop_lon","zone_id","stop_url","location_type","parent_station","stop_timezone","wheelchair_boarding"]
["nw01",null,"Arrowhead Mall",null,35.753,-95.37]
["nw02",null,"North 7th Street & Court Street",null,35.752989999999997,-95.376410000000007]
["nw03",null,"North 15th Street & Court Street",null,35.756300000000003,-95.385239999999996]
["nw04",null,"North 33rd Street & West Broadway",null,35.756030000000003,-95.403739999999999]
["nw05",null,"Honor Heights Towers",null,35.757579999999997,-95.411190000000005]
["nw06",null,"Jack C. Montgomery VA Medical Center",null,35.765500000000003,-95.414529999999999]
["nw07",null,"Port City Acres",null,35.771210000000004,-95.407979999999995]
["nw08",null,"3131 Military Blvd",null,35.76652,-95.401390000000006]
["nw09",null,"Social Security Administration",null,35.769300000000001,-95.394229999999993]
["nw10",null,"Walmart Supercenter",null,35.772399999999998,-95.37294]
["nw11",null,"Aldi",null,35.771140000000003,-95.366470000000007]
["nw12",null,"Austin Heights",null,35.772449999999999,-95.358490000000003]
["nw13",null,"Summer Ridge Apartments",null,35.767319999999998,-95.359939999999995]
["nw14",null,"Green Country Behavioral Health",null,35.755270000000003,-95.366050000000001]

{"sheet":"stop_times","index":6,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["trip_id","arrival_time","departure_time","stop_id","stop_sequence","stop_headsign","pickup_type","drop_off_type","continuous_pickup","continuous_drop_off","shape_dist_traveled","timepoint","*shape_id","*seq#","*Dist(m)","*Comment"]
["nw001",null,null,"nw_01",1]
["nw002",null,null,"nw_02",2]
["nw003",null,null,"nw_03",3]
["nw004",null,null,"nw_04",4]
["nw005",null,null,"nw_05",5]
["nw006",null,null,"nw_06",6]
["nw007",null,null,"nw_07",7]
["nw008",null,null,"nw_08",8]
["nw009",null,null,"nw_09",9]
["nw010",null,null,"nw_10",10]
["nw011",null,null,"nw_11",11]
["nw012",null,null,"nw_12",12]
["nw013",null,null,"nw_13",13]
["nw014",null,null,"nw_14",14]

{"sheet":"trips","index":7,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["route_id","service_id","trip_id","trip_headsign","direction_id","block_id","shape_id","wheelchair_accessible","bikes_allowed"]
["nw","mtwtf","nw_arrowhead","Northwest"]
["nw","mtwtf","nw_north7th","Northwest"]
["nw","mtwtf","nw_north15th","Northwest"]
["nw","mtwtf","nw_33rd","Northwest"]
["nw","mtwtf","nw_hht","Northwest"]
["nw","mtwtf","nw_jcmvm","Northwest"]
["nw","mtwtf","nw_pa","Northwest"]
["nw","mtwtf","nw_triad","Northwest"]
["nw","mtwtf","nw_ssa","Northwest"]
["nw","mtwtf","nw_ws","Northwest"]
["nw","mtwtf","nw_aldi","Northwest"]
["nw","mtwtf","nw_ah","Northwest"]
["nw","mtwtf","nw_sra","Northwest"]
["nw","mtwtf","nw_gcbh","Northwest"]

{"sheet":"feed_info","index":8,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["feed_publisher_name","feed_publisher_url","feed_lang","feed_start_date","feed_end_date","feed_version","feed_contact_email","feed_contact_url"]
["MCT","https://muskogeecountytransit.org","en",20240101,20301231,20240205,"cmorgan@muskogeecountytransit.org"]

{"sheet":"shapes","index":9,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["shape_id","shape_pt_lat","shape_pt_lon","shape_pt_sequence","shape_dist_traveled"]

{"sheet":"fare_attributes","index":10,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["fare_id","price","currency_type","payment_method","transfers","agency_id","transfer_duration"]

{"sheet":"fare_rules","index":11,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["fare_id","route_id","origin_id","destination_id","contains_id"]

{"sheet":"transfers","index":12,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["from_stop_id","to_stop_id","transfer_type","min_transfer_time"]