{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["weekly","monthly","source"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"weekly","index":0,"n_rows":26,"n_cols":7,"rows_kept":26,"flags":["formulas_cached_only"]}
["measurementTime","Motorway","Rural 'A' Roads","Urban 'A' Roads","Minor Rural Roads","Minor Urban Roads","Weekly Miles Total"]
["2015-01-11",1103773053.50326,1510577937.04225,868651664.621992,750984219.326478,1135419727.54607,5369406602.04006]
["2019-01-06",1049914689.575,1524456327.65937,717575218.784827,665162329.559927,924290427.367987,4881398992.94136]
["2016-09-25",1478962802.99013,2101704176.24977,1128755298.24078,1041989975.10592,1433970420.66635,7185382673.24422]
["2018-10-07",1345734642.85208,1953981320.59351,919756471.987074,852575927.260656,1184714968.28867,6256763330.97463]
["2015-12-27",1111251798.72797,1540572377.33509,804955970.822795,717111637.700338,1011338711.39204,5185230495.97825]
["2018-12-23",1281652062.86332,1860934623.06025,875958559.821137,811977087.552269,1128299989.21201,5958822322.50198]
["2016-06-05",1181028724.85752,1664743980.46898,936463040.12763,836983028.479746,1205848976.40732,5825067750.34121]
["2020-02-02",1238650245.18755,1805935887.68885,854357520.834442,778219709.902962,1109502213.05453,5786665576.67509]
["2019-10-13",1341057771.13263,1955244723.65138,924992989.015358,842560354.44124,1201232204.72163,6265088042.96955]
["2017-05-07",1342675275.3578,1961062672.8028,1010349492.75156,915323511.845126,1405272932.27265,6634683885.03853]
["2019-02-10",1293878178.33966,1872282314.69625,942056448.23068,840137135.436333,1270901999.38727,6219256076.0902]
["2016-03-06",1272455227.03893,1755920085.38194,982675324.515004,870479490.69471,1264575444.51513,6146105572.14571]
["2018-01-14",1247162899.14437,1785770459.39652,898173455.806293,825639602.130042,1235054157.64791,5991800574.1178]
["2019-09-29",1324400648.10537,1952561203.12764,942542340.036171,875298209.849251,1256844375.16201,6351646776.27294]
["2014-11-30",1162233146.08073,1613087658.82772,859236242.54466,750813348.173254,1088827537.25458,5474197932.8742]
["2020-03-22",1064295030.56609,1551728260.86769,734096220.691569,668675740.51374,953326168.015435,4972121420.66033]
["2019-03-17",1348900497.76692,1951901337.0291,982117507.827164,875864064.449076,1324947254.14283,6483730661.2151]
["2019-04-21",1354413229.2241,1993137720.47436,1013598249.36665,907844753.286792,1370292513.04358,6639286465.39549]
["2016-12-11",1352450296.01734,1901797312.45558,978719557.30721,893456347.834167,1206937504.6212,6333361018.23551]
["2016-08-28",1497844789.80833,2128536731.11285,1143166169.57524,1055293109.52881,1452277987.64907,7277118787.66546]
["2014-06-22",1266794339.20276,1770400785.37888,1031256212.57924,881310606.401861,1352998751.24219,6302760694.80494]
["2017-11-26",868150403.536165,1243233151.36208,590701333.768909,557706755.434195,787740555.466574,4047532199.56314]
["2020-03-08",1251569470.36084,1824771949.33921,863268540.900873,786336606.263006,1121074413.50127,5847020980.37202]
["2020-03-29",692177525.380605,1009185796.06563,477428617.851644,434881593.973674,620007543.872975,3233681077.1483]
["2014-06-29",1276862167.63344,1784471018.25657,1039452105.38916,888314808.824311,1363751687.90513,6352851788.00862]

{"sheet":"monthly","index":1,"n_rows":26,"n_cols":7,"rows_kept":26,"flags":["formulas_cached_only"]}
["measurementTime","Motorway","Rural 'A' Roads","Urban 'A' Roads","Minor Rural Roads","Minor Urban Roads","Monthly Miles Total"]
["2019-01-31",5457119611.93906,7896623275.40497,3973260238.29402,3543400696.64916,5360214231.76687,26230618054.0541]
["2020-02-29",5173433474.45295,7542798469.85438,3568369533.37564,3250367013.0719,4634024746.93478,24168993237.7178]
["2016-01-31",5098715602.26164,7035954543.16727,3937570377.79757,3488002773.17584,5067141391.0495,24627384687.4518]
["2019-06-30",5822001602.05619,8567585395.16625,4356994235.08628,3902408433.41576,5890259364.04621,28539249029.7707]
["2019-09-30",5800240537.51507,8551282920.73973,4127884033.29679,3833386948.61318,5504376417.05421,27817170857.186]
["2016-04-30",5041727944.73492,7106674097.34023,3997694365.30213,3573021244.22441,5147683839.96435,24866801491.566]
["2019-12-31",5261421119.70422,7671083308.00775,3629058906.14492,3305647928.75293,4712838348.68155,24580049611.32]
["2017-06-30",5933745807.61034,8666613310.58155,4465083387.52137,4045130755.51406,6210386475.01648,29320959736.2817]
["2016-07-31",6179672865.72528,8781724762.4441,4716371821.17062,4353833079.84574,5991677465.40249,30023279994.5516]
["2015-09-30",5444760768.51946,7583694176.41463,4136087330.45293,3716373054.38691,5374657291.31337,26255572621.0873]
["2019-07-31",6102564716.75951,8996998848.17043,4343040481.43219,4033193414.47785,5791279360.4365,29267076821.2418]
["2015-11-30",5567831535.49983,7718905359.76177,4033162640.69612,3593026166.9158,5067225607.01907,25980151309.8926]
["2016-05-31",4943021896.28192,6967540902.2371,3919428219.63796,3503069273.01099,5046903405.93502,24379963697.103]
["2017-02-28",5422548657.67063,7576755311.18908,4139949831.47468,3657284069.49057,5223182980.778,26019720850.6354]
["2018-08-31",6168242873.42383,9142207422.08044,4461969586.30058,4177230978.33222,5933993416.00383,29883644276.1762]
["2019-11-30",5606190058.26264,8173751919.68575,3866862867.95892,3522259506.06534,5021659908.12435,26190724260.1275]
["2018-07-31",6144465577.04909,9106966109.46438,4444769619.39824,4161128619.6807,5911119102.681,29768449028.3086]
["2019-04-30",5814215009.81599,8556126742.53867,4351167005.9269,3897189186.6167,5882381480.97579,28501079425.874]
["2018-05-31",5797708601.83559,8477583027.5162,4367729532.83571,3913246589.0984,5898366736.13906,28454634487.4621]
["2017-08-31",6792859285.82435,9944581248.41625,4859563810.7074,4640601366.15459,6692096845.5657,32929702556.7076]
["2014-05-31",5425788530.72173,7582778023.88566,4416958583.7977,3774728724.49681,5795009402.38705,26995263265.2889]
["2015-04-30",5907549063.33156,8163873771.45151,4723859465.48381,4071955646.56898,6208040419.56162,29075278366.3583]
["2015-05-31",5862241071.68926,8101260880.61634,4687629790.04869,4040725752.33963,6160427807.21948,28852285301.8745]
["2014-08-31",5616232899.10961,7854020412.7457,4352107169.5456,3907328689.01343,5673707987.46336,27403397157.8777]
["2016-11-30",5878458115.44695,8266208287.47732,4254028367.13596,3883429752.78996,5245983227.45814,27528107750.3083]

{"sheet":"source","index":2,"n_rows":26,"n_cols":9,"rows_kept":26,"flags":["formulas_cached_only"]}
["trafficFlow_<=5.2","trafficFlow_>11.6","trafficFlow_>5.2<=6.6","trafficFlow_>6.6<=11.6","trafficSpeed","common_ID","trafficTotal","measurementTime","trafficFlow_"]
[115,2,4,2,53,"5065/1",123,"2018-05-03T19:44:00"]
[46,3,5,2,43,"9514/2",56,"2017-10-31T18:44:00"]
[424,34,28,28,50,"7640/1",514,"2019-07-19T08:29:00"]
[134,11,9,15,53,"5656/1",169,"2019-11-28T07:59:00"]
[150,0,9,6,38,"9314/1",165,"2018-07-30T16:59:00"]
[284,10,13,6,65,"7529/2",313,"2019-11-23T14:44:00"]
[3,1,0,2,46,"5080/1",6,"2017-08-21T02:59:00"]
[1,0,2,2,26,"5587/1",5,"2015-07-22T04:14:00"]
[401,16,30,19,48,"9321/3",466,"2018-06-26T08:29:00"]
[{"$nulls":5},"7651/1",null,"2017-04-21T16:29:59"]
[158,6,9,5,70,"5038/1",178,"2018-02-27T19:29:00"]
[{"$nulls":5},"8403/2",null,"2018-08-21T23:29:59"]
[108,29,12,2,57,"6060/2",151,"2018-12-20T22:59:00"]
[{"$nulls":5},"9941/1",null,"2015-08-12T12:29:59"]
[613,29,35,25,64,"6259/2",702,"2016-07-06T18:44:00"]
[{"$nulls":5},"5764/1",null,"2016-08-02T20:44:59"]
[139,0,8,1,52,"7285/1",148,"2018-03-19T13:14:00"]
[14,2,2,1,53,"6271/1",19,"2015-09-26T02:59:00"]
[243,0,12,8,67,"7110/2",263,"2017-09-03T15:44:00"]
[50,4,4,1,71,"6317/1",59,"2017-02-04T23:59:00"]
[15,2,1,1,51,"5887/1",19,"2019-08-01T00:44:00"]
[17,1,1,0,63,"5510/2",19,"2018-07-28T02:44:00"]
[47,21,10,12,63,"8535/2",90,"2015-12-16T05:29:00"]
[{"$nulls":5},"7622/1",null,"2020-01-03T05:59:59"]
[127,1,4,2,50,"7613/1",134,"2018-09-16T18:59:00"]