{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Données brutes","Graphiques","Consommation","SSA3","SSA1","SSA2","PG1","SSA4","PG2","PR","PS"],"not_rendered":{"charts":8,"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Données brutes","index":0,"n_rows":275,"n_cols":13,"rows_kept":275}
["date_heure","index_SSA3","index_SSA1","index_SSA2","index_PG1","index_PG2","index_PR","index_PS","index_SSA4","Created"]
["2020-03-04T07:08:00",374564,{"$nulls":7},"2020-03-04T08:12:54"]
["2020-03-04T06:53:00",{"$nulls":5},572263,604145,null,"2020-03-04T08:12:52"]
["2020-03-04T06:48:00",null,929682,127239,668115,575377,{"$nulls":3},"2020-03-04T08:12:32"]
["2020-03-03T07:22:00",{"$nulls":5},571636,603540,null,"2020-03-04T08:12:53"]
["2020-03-03T07:20:00",null,929682,127143,666300,573248,{"$nulls":3},"2020-03-02T22:59:40"]
["2020-03-03T05:48:00",374564,{"$nulls":7},"2020-03-03T08:49:09"]
["2020-03-02T07:54:00",{"$nulls":5},570950,602911,null,"2020-03-02T07:40:12"]
["2020-03-02T07:07:00",null,929682,127045,664563,571251,{"$nulls":3},"2020-03-02T07:40:02"]
["2020-03-02T06:15:00",374564,{"$nulls":7},"2020-03-02T07:40:19"]
["2020-03-01T06:25:00",{"$nulls":5},570230,602245,null,"2020-03-02T07:40:09"]
["2020-03-01T06:21:00",null,null,126948,662662,569152,{"$nulls":3},"2020-03-02T07:39:57"]
["2020-02-29T09:19:00",374564,{"$nulls":7},"2020-03-02T07:40:17",null,"Formule1",{"$f":"MIN(A:A)","v":"2019-11-12T06:11:00"}]
["2020-02-29T07:23:00",374564,{"$nulls":7},"2020-03-02T07:40:15",null,"Formule2",{"$f":"VLOOKUP($E$2,A:B,2,)","v":{"$error":"#N/A"}}]
["2020-02-29T06:57:00",{"$nulls":5},569532,601649,null,"2020-03-02T07:40:06",null,"Formule3",{"$f":"B2-F2","v":374564}]
["2020-02-29T06:30:00",null,929682,126847,660886,567481,{"$nulls":3},"2020-03-02T07:39:53",null,"Formule4",{"$f":"G2-G3","v":-572263}]
["2020-02-28T07:37:00",374564,{"$nulls":7},"2020-02-28T06:56:31",null,"Formule5",{"$f":"H2/24","v":0}]
["2020-02-28T07:26:00",{"$nulls":5},568862,601058,null,"2020-02-28T06:56:29",null,"Formule6",{"$f":"I2*9","v":0}]
["2020-02-28T06:26:00",null,null,126759,659196,565754,{"$nulls":3},"2020-02-28T06:56:25"]
["2020-02-27T07:00:00",{"$nulls":5},568176,600405,null,"2020-02-26T23:36:15"]
["2020-02-27T06:47:00",null,null,126647,657168,563566,{"$nulls":3},"2020-02-26T22:36:11"]
["2020-02-27T06:46:00",374564,{"$nulls":7},"2020-02-26T23:21:10"]
["2020-02-26T06:13:00",null,929682,126549,655352,561481,{"$nulls":3},"2020-02-26T07:49:55"]
["2020-02-26T06:07:00",{"$nulls":5},5675027,599836,null,"2020-02-25T21:58:23"]
["2020-02-26T06:07:00",374563,{"$nulls":7},"2020-02-25T22:18:22"]
["2020-02-25T08:08:00",374563,{"$nulls":7},"2020-02-25T07:01:42"]
["2020-02-25T06:46:00",{"$nulls":5},566810,599255,null,"2020-02-25T07:01:35"]
["2020-02-25T05:47:00",null,929682,126451,653574,559420,{"$nulls":3},"2020-02-25T07:01:15"]
["2020-02-24T06:30:00",{"$nulls":5},566143,598657,null,"2020-02-25T07:01:32"]
["2020-02-24T06:25:00",null,929683,128358,651649,557399,{"$nulls":3},"2020-02-25T07:01:11"]
["2020-02-24T06:22:00",374563,{"$nulls":7},"2020-02-25T07:01:49"]
["2020-02-23T06:35:00",3745635,{"$nulls":7},"2020-02-25T07:01:40"]
["2020-02-23T06:32:00",null,929682,126262,649701,555347,{"$nulls":3},"2020-02-25T07:01:23"]
["2020-02-23T06:06:00",{"$nulls":5},565512,598106,null,"2020-02-25T07:01:30"]
["2020-02-22T07:28:00",{"$nulls":5},564905,597566,null,"2020-02-25T07:01:27"]
["2020-02-22T06:35:00",null,929682,126163,647823,553271,{"$nulls":3},"2020-02-25T07:01:07"]
["2020-02-22T06:01:00",374563,{"$nulls":7},"2020-02-25T07:01:48"]
["2020-02-21T06:31:00",null,929682,126060,645920,551098,{"$nulls":3},"2020-02-21T07:10:42"]
["2020-02-21T06:29:00",{"$nulls":5},564308,597007,null,"2020-02-25T07:01:38"]
["2020-02-21T05:40:00",374563,{"$nulls":7},"2020-02-25T07:01:46"]
["2020-02-20T05:44:00",null,929682,125958,644059,549164,{"$nulls":3},"2020-02-25T07:01:19"]
["2020-02-20T05:38:00",{"$nulls":5},563666,596440,null,"2020-02-20T07:59:10"]
["2020-02-19T07:04:00",{"$nulls":5},563047.2,595894.3,null,"2020-02-20T07:59:09"]
["2020-02-19T07:00:00",374563,{"$nulls":7},"2020-02-20T07:59:26"]
["2020-02-19T06:53:00",null,929682,125870,642263,547125,{"$nulls":3},"2020-02-20T07:58:39"]
["2020-02-18T06:45:00",374563,{"$nulls":7},"2020-02-20T07:59:25"]
["2020-02-18T06:45:00",null,929682.94,125769.05,640368.2,544910.1,{"$nulls":3},"2020-02-20T07:58:38"]
["2020-02-18T06:45:00",{"$nulls":5},562420,595344,null,"2020-02-20T07:59:09"]
["2020-02-17T06:57:00",{"$nulls":5},561738,594776,null,"2020-02-20T07:59:08"]
["2020-02-17T06:55:00",374563,{"$nulls":7},"2020-02-20T07:59:24"]
["2020-02-17T06:54:00",null,929682,125673,638546,542830,{"$nulls":3},"2020-02-20T07:58:36"]
["2020-02-16T07:37:00",null,929682,125578,636625,541373,{"$nulls":3},"2020-02-20T07:58:35"]
["2020-02-16T07:37:00",374563,{"$nulls":7},"2020-02-20T07:59:23"]
["2020-02-16T07:37:00",{"$nulls":5},561030,594190,null,"2020-02-20T07:59:07"]
["2020-02-15T06:41:00",374563,{"$nulls":7},"2020-02-20T07:59:23"]
["2020-02-15T06:38:00",null,929882,125467,634497,539334,{"$nulls":3},"2020-02-20T07:58:34"]
["2020-02-15T06:11:00",{"$nulls":5},560256,593563,null,"2020-02-20T07:59:06"]
["2020-02-14T08:46:00",374563,{"$nulls":7},"2020-02-20T07:59:22"]
["2020-02-14T06:34:00",{"$nulls":5},559598,593010,null,"2020-02-20T07:59:06"]
["2020-02-14T06:19:00",null,null,125368,632641,537240,{"$nulls":3},"2020-02-20T07:58:32"]
["2020-02-13T07:31:00",374563,{"$nulls":7},"2020-02-20T07:59:22"]
["2020-02-13T07:31:00",{"$nulls":5},558926,592418,null,"2020-02-20T07:59:05"]
["2020-02-13T06:11:00",null,929682,125253,630724,535473,{"$nulls":3},"2020-02-20T07:58:31"]
["2020-02-12T07:28:00",374563,{"$nulls":7},"2020-02-20T07:59:21"]
["2020-02-12T06:54:00",null,929682,125158,628894,533325,{"$nulls":3},"2020-02-20T07:58:30"]
["2020-02-12T06:19:00",{"$nulls":5},558284,591831,null,"2020-02-20T07:59:04"]
["2020-02-11T07:35:00",{"$nulls":5},557666,591266,null,"2020-02-20T07:59:03"]
["2020-02-11T06:24:00",374563,{"$nulls":7},"2020-02-20T07:59:20"]
["2020-02-11T06:22:00",null,929682,125059,626976,531149,{"$nulls":3},"2020-02-20T07:58:29"]
["2020-02-10T05:48:00",374562,{"$nulls":7},"2020-02-20T07:59:20"]
["2020-02-10T05:43:00",null,929682,124960,625022,529466,{"$nulls":3},"2020-02-20T07:58:28"]
["2020-02-10T05:43:00",{"$nulls":5},556912,590646,null,"2020-02-20T07:59:03"]
["2020-02-09T07:09:00",374562,{"$nulls":7},"2020-02-20T07:59:19"]
["2020-02-09T05:50:00",{"$nulls":5},556239,590063,null,"2020-02-20T07:59:02"]
["2020-02-09T05:46:00",null,929682,124862,623087,528082,{"$nulls":3},"2020-02-20T07:58:26"]
["2020-02-08T07:23:00",{"$nulls":5},555627,589528,null,"2020-02-20T07:59:00"]
["2020-02-08T06:25:00",null,929692,124764,621360,526124,{"$nulls":3},"2020-02-20T07:58:25"]
["2020-02-08T06:17:00",374562,{"$nulls":7},"2020-02-20T07:59:19"]
["2020-02-07T06:19:00",374562,{"$nulls":7},"2020-02-20T07:59:18"]
["2020-02-07T06:16:00",null,929682,124658,619471,524031,{"$nulls":3},"2020-02-20T07:58:24"]
["2020-02-07T06:09:00",{"$nulls":5},554988,588917,null,"2020-02-20T07:58:59"]
["2020-02-06T06:30:00",null,929682,124559,617610,521961,{"$nulls":3},"2020-02-20T07:58:23"]
["2020-02-05T07:58:00",374562,{"$nulls":7},"2020-02-20T07:59:18"]
["2020-02-05T07:57:00",{"$nulls":5},553837,587880,null,"2020-02-20T07:58:58"]
["2020-02-05T06:52:00",null,0,124464,615857,519957,{"$nulls":3},"2020-02-20T07:58:21"]
["2020-02-04T06:03:00",null,0,124361,613940,517691,{"$nulls":3},"2020-02-20T07:58:20"]
["2020-02-04T05:54:00",{"$nulls":5},553124,587269,null,"2020-02-20T07:58:58"]
["2020-02-04T05:52:00",374562,{"$nulls":7},"2020-02-20T07:59:17"]
["2020-02-03T06:41:00",374562,{"$nulls":7},"2020-02-20T07:59:16"]
["2020-02-03T06:30:00",null,929682,124269,612077,515724,{"$nulls":3},"2020-02-20T07:58:19"]
["2020-02-03T06:26:00",{"$nulls":5},552407,5666758,null,"2020-02-20T07:58:57"]
["2020-02-02T06:41:00",null,929682,124178,6101628,5138365,{"$nulls":3},"2020-02-20T07:58:19"]
["2020-02-02T06:38:00",574562,{"$nulls":7},"2020-02-20T07:59:16"]
["2020-02-02T06:38:00",{"$nulls":5},551692,586077,null,"2020-02-20T07:58:56"]
["2020-02-01T06:22:00",null,929682,124080,608228,511865,{"$nulls":3},"2020-02-20T07:58:17"]
["2020-02-01T06:20:00",374562,{"$nulls":7},"2020-02-20T07:59:15"]
["2020-02-01T06:03:00",{"$nulls":5},550974,585466,null,"2020-02-20T07:58:56"]
["2020-01-31T06:42:00",{"$nulls":5},550273,584844,null,"2020-02-20T07:58:55"]
["2020-01-31T06:17:00",374562,{"$nulls":7},"2020-02-20T07:59:15"]
["2020-01-31T05:28:00",null,null,123980,606254,509819,{"$nulls":3},"2020-02-20T07:58:16"]
["2020-01-30T07:31:00",null,929682,123892,604517,508002,{"$nulls":3},"2020-02-20T07:58:14"]
["2020-01-30T07:30:00",374562,{"$nulls":7},"2020-02-20T07:59:14"]
["2020-01-30T07:07:00",{"$nulls":5},549632,584280,null,"2020-02-20T07:58:54"]
["2020-01-29T06:22:00",null,929682,123791,602686,505693,{"$nulls":3},"2020-02-20T07:58:13"]
["2020-01-29T06:17:00",374562,{"$nulls":7},"2020-02-20T07:59:13"]
["2020-01-29T06:13:00",{"$nulls":5},549011,583690,null,"2020-02-20T07:58:53"]
["2020-01-28T06:41:00",{"$nulls":5},548407.5,583116.6,null,"2020-02-20T07:58:53"]
["2020-01-27T08:32:00",374562,{"$nulls":7},"2020-02-20T07:59:13"]
["2020-01-25T07:56:00",{"$nulls":5},546738,581444,null,"2020-02-20T07:58:52"]
["2020-01-25T07:01:00",374562,{"$nulls":7},"2020-02-20T07:59:12"]
["2020-01-25T06:47:00",null,929682,123397,59483,497873,{"$nulls":3},"2020-02-20T07:51:54"]
["2020-01-24T06:21:00",374561,{"$nulls":7},"2020-02-20T07:59:12"]
["2020-01-24T06:18:00",null,929682.94,123292.96,592812.2,495598.8,{"$nulls":3},"2020-02-20T07:51:53"]
["2020-01-23T06:31:00",null,929682,123186,590786,493315,{"$nulls":3},"2020-02-20T07:51:52"]
["2020-01-22T05:44:00",{"$nulls":5},545414,579865,null,"2020-02-20T07:58:51"]
["2020-01-21T05:41:00",{"$nulls":5},544986,579375,null,"2020-02-20T07:58:50"]
["2020-01-20T07:07:00",{"$nulls":8},"2020-02-20T07:58:49"]
["2020-01-19T06:29:00",{"$nulls":5},544045,578383,null,"2020-02-20T07:58:49"]
["2020-01-18T07:06:00",374561,{"$nulls":7},"2020-02-20T07:53:09"]
["2020-01-17T06:54:00",{"$nulls":5},542810,577254,null,"2020-02-20T07:58:47"]
["2020-01-16T06:23:00",{"$nulls":5},542156,576659,null,"2020-02-20T07:58:47"]
["2020-01-15T06:41:00",null,929682.9,122360.42,575844.1,476422.3,{"$nulls":3},"2020-02-20T07:51:51"]
["2020-01-15T06:40:00",374561,{"$nulls":7},"2020-02-20T07:53:09"]
["2020-01-14T06:38:00",{"$nulls":5},540732,575419,null,"2020-02-20T07:58:48"]
["2020-01-14T06:35:00",374561.756,{"$nulls":7},"2020-02-20T07:53:08"]
["2020-01-13T07:51:00",{"$nulls":5},540064,574836,null,"2020-02-20T07:58:46"]
["2020-01-13T06:54:00",null,929682,122158,572052,472965,{"$nulls":3},"2020-02-20T07:51:50"]
["2020-01-13T06:54:00",374561,{"$nulls":7},"2020-02-20T07:53:08"]
["2020-01-12T08:49:00",{"$nulls":5},539412,0,null,"2020-02-20T07:58:45"]
["2020-01-12T06:52:00",374561,{"$nulls":7},"2020-02-20T07:53:07"]
["2020-01-12T06:04:00",null,929682,122060,570088,470934,{"$nulls":3},"2020-02-20T07:51:48"]
["2020-01-11T07:22:00",null,929682,121961,568182,468822,{"$nulls":3},"2020-02-20T07:51:47"]
["2020-01-10T06:29:00",374561,{"$nulls":7},"2020-02-20T07:53:06"]
["2020-01-09T05:50:00",374561,{"$nulls":7},"2020-02-20T07:53:06"]
["2020-01-09T05:49:00",null,929682,121758,564243,464880,{"$nulls":3},"2020-02-20T07:51:46"]
["2020-01-09T05:46:00",{"$nulls":5},537445,3.55,null,"2020-02-20T07:58:44"]
["2020-01-08T08:14:00",null,929682.94,121666.65,562463.9,463010.7,{"$nulls":3},"2020-02-20T07:51:45"]
["2020-01-08T07:48:00",374561,{"$nulls":7},"2020-02-20T07:53:05"]
["2020-01-08T06:45:00",{"$nulls":5},536849,571999,null,"2020-02-20T07:58:43"]
["2020-01-07T06:48:00",374561.46,{"$nulls":7},"2020-02-20T07:53:04"]
["2020-01-07T06:41:00",{"$nulls":5},536236,571429,null,"2020-02-20T07:58:42"]
["2020-01-07T06:33:00",null,929682,121560,560394,460779,{"$nulls":3},"2020-02-20T07:51:44"]
["2020-01-06T07:22:00",{"$nulls":5},535746,570900,null,"2020-02-20T07:58:41"]
["2020-01-06T06:50:00",374561,{"$nulls":7},"2020-02-20T07:53:04"]
["2020-01-06T06:04:00",null,929682,121453,558403,458631,{"$nulls":3},"2020-02-20T07:51:43"]
["2020-01-05T06:46:00",{"$nulls":5},535221,570381,298313,"2020-02-20T07:52:34"]
["2020-01-05T06:44:00",null,929682,121353,556473,456543,{"$nulls":3},"2020-02-20T07:51:42"]
["2020-01-05T06:44:00",374561,{"$nulls":7},"2020-02-20T07:53:03"]
["2020-01-04T07:23:00",null,929682,121250,554571,454417,{"$nulls":3},"2020-02-20T07:51:41"]
["2020-01-04T06:22:00",{"$nulls":5},534613.2,569825,0,"2020-02-20T07:52:34"]
["2020-01-04T06:18:00",374561,{"$nulls":7},"2020-02-20T07:53:03"]
["2020-01-03T07:30:00",{"$nulls":5},534007,569278,298313,"2020-02-20T07:52:33"]
["2020-01-03T06:38:00",null,929682,121148,552876,452450,{"$nulls":3},"2020-02-20T07:51:39"]
["2020-01-03T06:30:00",374561,{"$nulls":7},"2020-02-20T07:53:02"]
["2020-01-02T07:33:00",{"$nulls":5},533420,568716,298313,"2020-02-20T07:52:32"]
["2020-01-02T07:07:00",374561,{"$nulls":7},"2020-02-20T07:53:01"]
["2020-01-02T06:38:00",null,929682,121048,550667,450242,{"$nulls":3},"2020-02-20T07:51:38"]
["2019-12-31T06:32:00",{"$nulls":5},532327,567607,298313,"2020-02-20T07:52:31"]
["2019-12-31T06:19:00",374561,{"$nulls":7},"2020-02-20T07:53:01"]
["2019-12-31T06:15:00",{"$nulls":3},546923,445988,{"$nulls":3},"2020-02-20T07:51:37"]
["2019-12-30T06:29:00",374561,{"$nulls":7},"2020-02-20T07:53:00"]
["2019-12-30T06:26:00",{"$nulls":5},531845,567084,298313,"2020-02-20T07:52:30"]
["2019-12-30T04:52:00",null,929682,120731,544928,443816,{"$nulls":3},"2020-02-20T07:51:36"]
["2019-12-29T06:01:00",{"$nulls":5},531258,566506,298313,"2020-02-20T07:52:30"]
["2019-12-29T06:00:00",374561,{"$nulls":7},"2020-02-20T07:53:00"]
["2019-12-29T05:50:00",null,929682,120629,543031,441718,{"$nulls":3},"2020-02-20T07:51:35"]
["2019-12-28T07:25:00",{"$nulls":5},530596,565971,298313,"2020-02-20T07:52:29"]
["2019-12-28T06:51:00",null,929682,120535,541317,439663,{"$nulls":3},"2020-02-20T07:51:33"]
["2019-12-28T06:50:00",374561,{"$nulls":7},"2020-02-20T07:52:59"]
["2019-12-27T06:46:00",null,929682,120439,539633,437695,{"$nulls":3},"2020-02-20T07:51:32"]
["2019-12-27T06:40:00",{"$nulls":5},529864.8,565370.4,298313.51,"2020-02-20T07:52:28"]
["2019-12-27T06:37:00",374561,{"$nulls":7},"2020-02-20T07:52:59"]
["2019-12-26T06:39:00",{"$nulls":5},529221,564793,298313,"2020-02-20T07:52:27"]
["2019-12-25T05:32:00",null,929682,120236,535621,433232,{"$nulls":3},"2020-02-20T07:51:31"]
["2019-12-25T05:22:00",374561,{"$nulls":7},"2020-02-20T07:52:59"]
["2019-12-25T05:22:00",{"$nulls":5},528493,564153,298313,"2020-02-20T07:52:27"]
["2019-12-24T07:51:00",{"$nulls":8},"2020-02-20T07:52:26"]
["2019-12-24T06:41:00",null,929682,120124,533845,43129,{"$nulls":3},"2020-02-20T07:51:29"]
["2019-12-24T06:33:00",374560,{"$nulls":7},"2020-02-20T07:52:58"]
["2019-12-23T06:26:00",374560,{"$nulls":7},"2020-02-20T07:52:57"]
["2019-12-23T06:26:00",null,929682,119981,531870,429224,{"$nulls":3},"2020-02-20T07:51:28"]
["2019-12-23T06:23:00",{"$nulls":5},527210,563164,298313,"2020-02-20T07:52:25"]
["2019-12-22T05:58:00",null,929682,119839,530155,427542,{"$nulls":3},"2020-02-20T07:51:27"]
["2019-12-22T05:57:00",374560,{"$nulls":7},"2020-02-20T07:52:56"]
["2019-12-22T05:57:00",{"$nulls":5},526442,562593,298313,"2020-02-20T07:52:24"]
["2019-12-21T07:02:00",374560,{"$nulls":7},"2020-02-25T07:01:44"]
["2019-12-21T07:02:00",374560,{"$nulls":7},"2020-02-20T07:52:55"]
["2019-12-21T06:01:00",{"$nulls":5},5257159,562041,298313,"2020-02-20T07:52:24"]
["2019-12-21T05:59:00",null,929682,119696,528377,425827,{"$nulls":3},"2020-02-20T07:51:26"]
["2019-12-20T06:33:00",{"$nulls":5},524951,561492,298313,"2020-02-20T07:52:23"]
["2019-12-19T06:03:00",{"$nulls":5},524195,560942,298313,"2020-02-20T07:52:22"]
["2019-12-18T06:52:00",374560,{"$nulls":7},"2020-02-20T07:52:55"]
["2019-12-17T08:52:00",{"$nulls":8},"2020-02-20T07:52:54"]
["2019-12-15T06:34:00",{"$nulls":5},521472,558890,298313,"2020-02-20T07:52:22"]
["2019-12-14T08:06:00",{"$nulls":8},"2020-02-20T07:52:21"]
["2019-12-14T06:22:00",374530,{"$nulls":7},"2020-02-20T07:52:53"]
["2019-12-13T07:06:00",null,929882,115873,514471,410297,{"$nulls":3},"2020-02-20T07:51:25"]
["2019-12-13T06:56:00",{"$nulls":5},519983,557816,298313,"2020-02-20T07:52:20"]
["2019-12-12T06:37:00",374530,{"$nulls":7},"2020-02-20T07:52:53"]
["2019-12-11T06:17:00",{"$nulls":5},518684,556797,298313,"2020-02-20T07:52:20"]
["2019-12-10T10:01:00",null,929682,118581,509106,407720,{"$nulls":3},"2020-02-20T07:51:24"]
["2019-12-08T06:29:00",374559,{"$nulls":7},"2020-02-20T07:52:52"]
["2019-12-07T06:38:00",{"$nulls":5},516109,554885,298313,"2020-02-20T07:52:19"]
["2019-12-06T06:37:00",null,929682,118172,501425,396230,{"$nulls":3},"2020-02-20T07:51:23"]
["2019-12-05T07:48:00",{"$nulls":6},554016,null,"2020-02-20T07:52:18"]
["2019-12-04T08:18:00",374559,{"$nulls":7},"2020-02-20T07:52:51"]
["2019-12-04T06:14:00",null,929682,117954,497377,391707,{"$nulls":3},"2020-02-20T07:51:21"]
["2019-12-04T06:10:00",{"$nulls":5},514619,553537,298313,"2020-02-20T07:52:17"]
["2019-12-03T06:34:00",{"$nulls":5},514113,553101,298313,"2020-02-20T07:52:16"]
["2019-12-03T06:30:00",374559.76,{"$nulls":7},"2020-02-20T07:52:50"]
["2019-12-03T06:29:00",null,929682,117851,495486,389548,{"$nulls":3},"2020-02-20T07:51:20"]
["2019-12-02T07:32:00",{"$nulls":5},513592,552680,0,"2020-02-20T07:52:15"]
["2019-12-02T07:32:00",{"$nulls":5},513592,552680,0,"2020-02-20T07:52:16"]
["2019-12-02T06:52:00",374559,{"$nulls":7},"2020-02-20T07:52:49"]
["2019-12-02T06:01:00",null,929682,117747,493689,387486,{"$nulls":3},"2020-02-20T07:51:19"]
["2019-12-01T06:41:00",{"$nulls":5},512951,552171,298313.51,"2020-02-20T07:52:14"]
["2019-12-01T06:40:00",374559,{"$nulls":7},"2020-02-20T07:52:50"]
["2019-12-01T06:39:00",null,929682,117640,491835,385425,{"$nulls":3},"2020-02-20T07:51:16"]
["2019-11-30T08:33:00",{"$nulls":5},512320,551692,298313,"2020-02-20T07:52:13"]
["2019-11-30T06:54:00",374559,{"$nulls":7},"2020-02-20T07:52:48"]
["2019-11-30T06:22:00",null,929682.9,117538.25,489984.2,383298,{"$nulls":3},"2020-02-20T07:51:18"]
["2019-11-29T07:58:00",{"$nulls":5},511550,551173,298313,"2020-02-20T07:52:12"]
["2019-11-29T06:55:00",374559,{"$nulls":7},"2020-02-20T07:52:48"]
["2019-11-29T06:48:00",{"$nulls":3},488170,381211,{"$nulls":3},"2020-02-20T07:51:17"]
["2019-11-28T06:29:00",374559,{"$nulls":7},"2020-02-20T07:52:47"]
["2019-11-28T05:54:00",{"$nulls":5},510687,550583,298313,"2020-02-20T07:52:11"]
["2019-11-28T05:53:00",null,929682,117341,486329,379084,{"$nulls":3},"2020-02-20T07:51:15"]
["2019-11-27T07:07:00",{"$nulls":5},509898,550038,298313,"2020-02-20T07:52:10"]
["2019-11-27T06:59:00",{"$nulls":8},"2020-02-20T07:52:46"]
["2019-11-27T06:58:00",null,929682,117249,484653,377376,{"$nulls":3},"2020-02-20T07:51:14"]
["2019-11-26T09:10:00",null,929682,117154,482973,375621,{"$nulls":3},"2020-02-20T07:51:13"]
["2019-11-26T07:45:00",374559,{"$nulls":7},"2020-02-20T07:52:45"]
["2019-11-25T06:08:00",374559,{"$nulls":7},"2020-02-20T07:52:44"]
["2019-11-25T06:08:00",{"$nulls":5},508318,548928,null,"2020-02-20T07:52:09"]
["2019-11-25T05:59:00",null,929682,117041,481056,373359,{"$nulls":3},"2020-02-20T07:51:11"]
["2019-11-24T07:02:00",null,929682,116942,479345,371323,{"$nulls":3},"2020-02-20T07:51:10"]
["2019-11-24T07:01:00",{"$nulls":5},509090.3,null,298313.51,"2020-02-20T07:52:10"]
["2019-11-24T06:48:00",{"$nulls":5},504654,548426,298313,"2020-02-20T07:52:08"]
["2019-11-23T06:35:00",null,0,116839,477632,369266,{"$nulls":3},"2020-02-20T07:51:09"]
["2019-11-23T06:34:00",{"$nulls":5},506904,547863,298313,"2020-02-20T07:52:07"]
["2019-11-23T06:15:00",374559,{"$nulls":7},"2020-02-20T07:52:43"]
["2019-11-22T06:46:00",{"$nulls":5},506221,547327,298313,"2020-02-20T07:52:06"]
["2019-11-22T06:22:00",null,929683,116732,475952,367247,{"$nulls":3},"2020-02-20T07:51:08"]
["2019-11-22T06:15:00",374559,{"$nulls":7},"2020-02-20T07:52:42"]
["2019-11-21T16:58:00",{"$nulls":8},"2020-02-20T07:52:06"]
["2019-11-21T16:58:00",{"$nulls":8},"2020-02-20T07:52:05"]
["2019-11-21T16:57:00",{"$nulls":8},"2020-02-20T07:52:04"]
["2019-11-21T07:02:00",null,929682,116631,474135,365228,{"$nulls":3},"2020-02-20T07:51:06"]
["2019-11-21T06:59:00",{"$nulls":5},505639,546841,298313,"2020-02-20T07:52:04"]
["2019-11-21T06:50:00",374559,{"$nulls":7},"2020-02-20T07:52:41"]
["2019-11-20T07:35:00",{"$nulls":5},505005,546337,298313,"2020-02-20T07:52:03"]
["2019-11-20T07:30:00",374559,{"$nulls":7},"2020-02-20T07:52:40"]
["2019-11-20T06:21:00",null,null,116523,472232,363013,{"$nulls":3},"2020-02-20T07:51:05"]
["2019-11-19T08:32:00",{"$nulls":5},504430,545881,298313,"2020-02-20T07:52:02"]
["2019-11-19T05:28:00",374559,{"$nulls":7},"2020-02-20T07:52:39"]
["2019-11-19T05:21:00",null,929682,116415,470505,360989,{"$nulls":3},"2020-02-20T07:51:04"]
["2019-11-18T07:02:00",374559,{"$nulls":7},"2020-02-20T07:52:39"]
["2019-11-18T06:06:00",null,929682,116318,368842,358965,{"$nulls":3},"2020-02-20T07:51:03"]
["2019-11-18T06:02:00",{"$nulls":5},503767,545365,298313,"2020-02-20T07:52:01"]
["2019-11-17T06:11:00",null,929682,116206,466992,356693,{"$nulls":3},"2020-02-20T07:51:01"]
["2019-11-17T06:07:00",374559,{"$nulls":7},"2020-02-20T07:52:38"]
["2019-11-17T05:56:00",{"$nulls":5},503162.1,544876.5,298313.51,"2020-02-20T07:52:01"]
["2019-11-16T07:22:00",{"$nulls":5},502582,544407,298313,"2020-02-20T07:52:00"]
["2019-11-16T06:13:00",374559,{"$nulls":7},"2020-02-20T07:52:37"]
["2019-11-16T06:13:00",null,929682,116093,465041,354462,{"$nulls":3},"2020-02-20T07:51:00"]
["2019-11-15T06:58:00",{"$nulls":5},501943,543894,null,"2020-02-20T07:51:59"]
["2019-11-15T06:56:00",null,929682,115991,463249,352364,{"$nulls":3},"2020-02-20T07:50:59"]
["2019-11-15T06:50:00",374559,{"$nulls":7},"2020-02-20T07:52:37"]
["2019-11-14T11:11:00",{"$nulls":5},501326,543390,null,"2020-02-20T07:51:58"]
["2019-11-13T09:16:00",{"$nulls":5},500601,542822,298313,"2020-02-20T07:51:57"]
["2019-11-13T06:38:00",null,929683,115774,459433,348260,{"$nulls":3},"2020-02-20T07:50:58"]
["2019-11-13T06:38:00",374559,{"$nulls":7},"2020-02-20T07:52:36"]
["2019-11-12T08:45:00",{"$nulls":8},"2020-02-20T07:51:56"]
["2019-11-12T06:17:00",null,929682,115669,457612,346106,{"$nulls":3},"2020-02-20T07:50:56"]
["2019-11-12T06:11:00",374559,{"$nulls":7},"2020-02-20T07:52:36"]

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

{"sheet":"Consommation","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"SSA3","index":3,"n_rows":87,"n_cols":10,"rows_kept":87}
["date_heure","index_SSA3",null,null,"date jour0","total ssa3 jour0","différence  compteur jour 0","difference 24h","Débit/h dernière 24h","Debit x9"]
["2020-03-04T07:08:00",374564,null,null,{"$f":"MIN(A:A)","v":"2019-11-12T06:11:00"},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},{"$f":"B2-F2","v":5},{"$f":"G2-G3","v":0},{"$f":"H2/24","v":0},{"$f":"I2*9","v":0}]
["2020-03-03T05:48:00",374564,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},{"$f":"B3-F3","v":5},{"$f":"G3-G4","v":0},{"$f":"H3/24","v":0},{"$f":"I3*9","v":0}]
["2020-03-02T06:15:00",374564,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},5,0,0,0]
["2020-02-29T09:19:00",374564,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},5,0,0,0]
["2020-02-29T07:23:00",374564,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},5,0,0,0]
["2020-02-28T07:37:00",374564,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},5,0,0,0]
["2020-02-27T06:46:00",374564,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},5,1,0.041666666666666664,0.375]
["2020-02-26T06:07:00",374563,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},4,0,0,0]
["2020-02-25T08:08:00",374563,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},4,0,0,0]
["2020-02-24T06:22:00",374563,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},4,-3371072,-140461.33333333334,-1264152]
["2020-02-23T06:35:00",3745635,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},3371076,3371072,140461.33333333334,1264152]
["2020-02-22T06:01:00",374563,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},4,0,0,0]
["2020-02-21T05:40:00",374563,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},4,0,0,0]
["2020-02-19T07:00:00",374563,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},4,0,0,0]
["2020-02-18T06:45:00",374563,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},4,0,0,0]
["2020-02-17T06:55:00",374563,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},4,0,0,0]
["2020-02-16T07:37:00",374563,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},4,0,0,0]
["2020-02-15T06:41:00",374563,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},4,0,0,0]
["2020-02-14T08:46:00",374563,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},4,0,0,0]
["2020-02-13T07:31:00",374563,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},4,0,0,0]
["2020-02-12T07:28:00",374563,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},4,0,0,0]
["2020-02-11T06:24:00",374563,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},4,1,0.041666666666666664,0.375]
["2020-02-10T05:48:00",374562,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},3,0,0,0]
["2020-02-09T07:09:00",374562,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},3,0,0,0]
["2020-02-08T06:17:00",374562,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},3,0,0,0]
["2020-02-07T06:19:00",374562,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},3,0,0,0]
["2020-02-05T07:58:00",374562,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},3,0,0,0]
["2020-02-04T05:52:00",374562,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},3,0,0,0]
["2020-02-03T06:41:00",374562,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},3,-200000,-8333.333333333334,-75000]
["2020-02-02T06:38:00",574562,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},200003,200000,8333.333333333334,75000]
["2020-02-01T06:20:00",374562,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},3,0,0,0]
["2020-01-31T06:17:00",374562,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},3,0,0,0]
["2020-01-30T07:30:00",374562,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},3,0,0,0]
["2020-01-29T06:17:00",374562,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},3,0,0,0]
["2020-01-27T08:32:00",374562,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},3,0,0,0]
["2020-01-25T07:01:00",374562,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},3,1,0.041666666666666664,0.375]
["2020-01-24T06:21:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,0,0,0]
["2020-01-18T07:06:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,0,0,0]
["2020-01-15T06:40:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,-0.7559999999939464,-0.031499999999747764,-0.2834999999977299]
["2020-01-14T06:35:00",374561.756,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2.7559999999939464,0.7559999999939464,0.031499999999747764,0.2834999999977299]
["2020-01-13T06:54:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,0,0,0]
["2020-01-12T06:52:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,0,0,0]
["2020-01-10T06:29:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,0,0,0]
["2020-01-09T05:50:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,0,0,0]
["2020-01-08T07:48:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,-0.46000000002095476,-0.019166666667539783,-0.17250000000785803]
["2020-01-07T06:48:00",374561.46,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2.4600000000209548,0.46000000002095476,0.019166666667539783,0.17250000000785803]
["2020-01-06T06:50:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,0,0,0]
["2020-01-05T06:44:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,0,0,0]
["2020-01-04T06:18:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,0,0,0]
["2020-01-03T06:30:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,0,0,0]
["2020-01-02T07:07:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,0,0,0]
["2019-12-31T06:19:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,0,0,0]
["2019-12-30T06:29:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,0,0,0]
["2019-12-29T06:00:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,0,0,0]
["2019-12-28T06:50:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,0,0,0]
["2019-12-27T06:37:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,0,0,0]
["2019-12-25T05:22:00",374561,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},2,1,0.041666666666666664,0.375]
["2019-12-24T06:33:00",374560,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},1,0,0,0]
["2019-12-23T06:26:00",374560,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},1,0,0,0]
["2019-12-22T05:57:00",374560,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},1,0,0,0]
["2019-12-21T07:02:00",374560,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},1,0,0,0]
["2019-12-21T07:02:00",374560,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},1,0,0,0]
["2019-12-18T06:52:00",374560,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},1,30,1.25,11.25]
["2019-12-14T06:22:00",374530,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},-29,0,0,0]
["2019-12-12T06:37:00",374530,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},-29,-29,-1.2083333333333333,-10.875]
["2019-12-08T06:29:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},{"$f":"B67-F67","v":0},{"$f":"G67-G68","v":0},{"$f":"H67/24","v":0},{"$f":"I67*9","v":0}]
["2019-12-04T08:18:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,-0.7600000000093132,-0.03166666666705472,-0.28500000000349246]
["2019-12-03T06:30:00",374559.76,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0.7600000000093132,0.7600000000093132,0.03166666666705472,0.28500000000349246]
["2019-12-02T06:52:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,0,0,0]
["2019-12-01T06:40:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,0,0,0]
["2019-11-30T06:54:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,0,0,0]
["2019-11-29T06:55:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,0,0,0]
["2019-11-28T06:29:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,0,0,0]
["2019-11-26T07:45:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,0,0,0]
["2019-11-25T06:08:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,0,0,0]
["2019-11-23T06:15:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,0,0,0]
["2019-11-22T06:15:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,0,0,0]
["2019-11-21T06:50:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,0,0,0]
["2019-11-20T07:30:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,0,0,0]
["2019-11-19T05:28:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,0,0,0]
["2019-11-18T07:02:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,0,0,0]
["2019-11-17T06:07:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,0,0,0]
["2019-11-16T06:13:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,0,0,0]
["2019-11-15T06:50:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,0,0,0]
["2019-11-13T06:38:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,0,0,0]
["2019-11-12T06:11:00",374559,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":374559},0,{"$f":"G87-#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"SSA1","index":4,"n_rows":79,"n_cols":10,"rows_kept":79}
["date_heure","index_SSA1",null,null,"date jour 0","total ssa1 jour0","différence  compteur jour 0","difference 24h","Débit/h dernière 24h","Debit x9"]
["2020-03-04T06:48:00",929682,null,null,{"$f":"MIN(A:A)","v":"2019-11-12T06:17:00"},{"$f":"VLOOKUP($E$2,A:B,2,)","v":929682},{"$f":"B2-F2","v":0},{"$f":"G2-G3","v":0},{"$f":"H2/24","v":0},{"$f":"I2*9","v":0}]
["2020-03-03T07:20:00",929682,{"$nulls":3},929682,{"$f":"B3-F3","v":0},{"$f":"G3-G4","v":0},{"$f":"H3/24","v":0},{"$f":"I3*9","v":0}]
["2020-03-02T07:07:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-02-29T06:30:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-02-26T06:13:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-02-25T05:47:00",929682,{"$nulls":3},929682,0,-1,-0.041666666666666664,-0.375]
["2020-02-24T06:25:00",929683,{"$nulls":3},929682,1,1,0.041666666666666664,0.375]
["2020-02-23T06:32:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-02-22T06:35:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-02-21T06:31:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-02-20T05:44:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-02-19T06:53:00",929682,{"$nulls":3},929682,0,-0.9399999999441206,-0.03916666666433836,-0.35249999997904524]
["2020-02-18T06:45:00",929682.94,{"$nulls":3},929682,0.9399999999441206,0.9399999999441206,0.03916666666433836,0.35249999997904524]
["2020-02-17T06:54:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-02-16T07:37:00",929682,{"$nulls":3},929682,0,-200,-8.333333333333334,-75]
["2020-02-15T06:38:00",929882,{"$nulls":3},929682,200,200,8.333333333333334,75]
["2020-02-13T06:11:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-02-12T06:54:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-02-11T06:22:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-02-10T05:43:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-02-09T05:46:00",929682,{"$nulls":3},929682,0,-10,-0.4166666666666667,-3.75]
["2020-02-08T06:25:00",929692,{"$nulls":3},929682,10,10,0.4166666666666667,3.75]
["2020-02-07T06:16:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-02-06T06:30:00",929682,{"$nulls":3},929682,0,929682,38736.75,348630.75]
["2020-02-05T06:52:00",0,{"$nulls":3},929682,-929682,0,0,0]
["2020-02-04T06:03:00",0,{"$nulls":3},929682,-929682,-929682,-38736.75,-348630.75]
["2020-02-03T06:30:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-02-02T06:41:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-02-01T06:22:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-01-30T07:31:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-01-29T06:22:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-01-25T06:47:00",929682,{"$nulls":3},929682,0,-0.9399999999441206,-0.03916666666433836,-0.35249999997904524]
["2020-01-24T06:18:00",929682.94,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":929682},0.9399999999441206,0.9399999999441206,0.03916666666433836,0.35249999997904524]
["2020-01-23T06:31:00",929682,{"$nulls":3},929682,0,-0.9000000000232831,-0.037500000000970125,-0.33750000000873115]
["2020-01-15T06:41:00",929682.9,{"$nulls":3},929682,0.9000000000232831,0.9000000000232831,0.037500000000970125,0.33750000000873115]
["2020-01-13T06:54:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-01-12T06:04:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-01-11T07:22:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-01-09T05:49:00",929682,{"$nulls":3},929682,0,-0.9399999999441206,-0.03916666666433836,-0.35249999997904524]
["2020-01-08T08:14:00",929682.94,{"$nulls":3},929682,0.9399999999441206,0.9399999999441206,0.03916666666433836,0.35249999997904524]
["2020-01-07T06:33:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-01-06T06:04:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-01-05T06:44:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-01-04T07:23:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-01-03T06:38:00",929682,{"$nulls":3},929682,0,0,0,0]
["2020-01-02T06:38:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-12-30T04:52:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-12-29T05:50:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-12-28T06:51:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-12-27T06:46:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-12-25T05:32:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-12-24T06:41:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-12-23T06:26:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-12-22T05:58:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-12-21T05:59:00",929682,{"$nulls":3},929682,0,-200,-8.333333333333334,-75]
["2019-12-13T07:06:00",929882,{"$nulls":3},929682,200,200,8.333333333333334,75]
["2019-12-10T10:01:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-12-06T06:37:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-12-04T06:14:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-12-03T06:29:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-12-02T06:01:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-12-01T06:39:00",929682,{"$nulls":3},929682,0,-0.9000000000232831,-0.037500000000970125,-0.33750000000873115]
["2019-11-30T06:22:00",929682.9,{"$nulls":3},929682,0.9000000000232831,0.9000000000232831,0.037500000000970125,0.33750000000873115]
["2019-11-28T05:53:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-11-27T06:58:00",929682,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":929682},0,0,0,0]
["2019-11-26T09:10:00",929682,{"$nulls":3},929682,{"$f":"B67-F67","v":0},{"$f":"G67-G68","v":0},{"$f":"H67/24","v":0},{"$f":"I67*9","v":0}]
["2019-11-25T05:59:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-11-24T07:02:00",929682,{"$nulls":3},929682,0,929682,38736.75,348630.75]
["2019-11-23T06:35:00",0,{"$nulls":3},929682,-929682,-929683,-38736.791666666664,-348631.125]
["2019-11-22T06:22:00",929683,{"$nulls":3},929682,1,1,0.041666666666666664,0.375]
["2019-11-21T07:02:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-11-19T05:21:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-11-18T06:06:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-11-17T06:11:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-11-16T06:13:00",929682,{"$nulls":3},929682,0,0,0,0]
["2019-11-15T06:56:00",929682,{"$nulls":3},929682,0,-1,-0.041666666666666664,-0.375]
["2019-11-13T06:38:00",929683,{"$nulls":3},929682,1,1,0.041666666666666664,0.375]
["2019-11-12T06:17:00",929682,{"$nulls":3},929682,0,{"$f":"G79-#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"SSA2","index":5,"n_rows":85,"n_cols":10,"rows_kept":85}
["date_heure","index_SSA2",null,null,"date jour 0","total ssa2 jour0","différence  compteur jour 0","difference 24h","Débit/h dernière 24h","Debit x9"]
["2020-03-04T06:48:00",127239,null,null,{"$f":"MIN(A:A)","v":"2019-11-12T06:17:00"},{"$f":"VLOOKUP($E$2,A:B,2,)","v":115669},{"$f":"B2-F2","v":11570},{"$f":"G2-G3","v":96},{"$f":"H2/24","v":4},{"$f":"I2*9","v":36}]
["2020-03-03T07:20:00",127143,{"$nulls":3},115669,{"$f":"B3-F3","v":11474},{"$f":"G3-G4","v":98},{"$f":"H3/24","v":4.083333333333333},{"$f":"I3*9","v":36.75}]
["2020-03-02T07:07:00",127045,{"$nulls":3},115669,11376,97,4.041666666666667,36.375]
["2020-03-01T06:21:00",126948,{"$nulls":3},115669,11279,101,4.208333333333333,37.875]
["2020-02-29T06:30:00",126847,{"$nulls":3},115669,11178,88,3.6666666666666665,33]
["2020-02-28T06:26:00",126759,{"$nulls":3},115669,11090,112,4.666666666666667,42]
["2020-02-27T06:47:00",126647,{"$nulls":3},115669,10978,98,4.083333333333333,36.75]
["2020-02-26T06:13:00",126549,{"$nulls":3},115669,10880,98,4.083333333333333,36.75]
["2020-02-25T05:47:00",126451,{"$nulls":3},115669,10782,-1907,-79.45833333333333,-715.125]
["2020-02-24T06:25:00",128358,{"$nulls":3},115669,12689,2096,87.33333333333333,786]
["2020-02-23T06:32:00",126262,{"$nulls":3},115669,10593,99,4.125,37.125]
["2020-02-22T06:35:00",126163,{"$nulls":3},115669,10494,103,4.291666666666667,38.625]
["2020-02-21T06:31:00",126060,{"$nulls":3},115669,10391,102,4.25,38.25]
["2020-02-20T05:44:00",125958,{"$nulls":3},115669,10289,88,3.6666666666666665,33]
["2020-02-19T06:53:00",125870,{"$nulls":3},115669,10201,100.94999999999709,4.206249999999879,37.85624999999891]
["2020-02-18T06:45:00",125769.05,{"$nulls":3},115669,10100.050000000003,96.05000000000291,4.002083333333455,36.01875000000109]
["2020-02-17T06:54:00",125673,{"$nulls":3},115669,10004,95,3.9583333333333335,35.625]
["2020-02-16T07:37:00",125578,{"$nulls":3},115669,9909,111,4.625,41.625]
["2020-02-15T06:38:00",125467,{"$nulls":3},115669,9798,99,4.125,37.125]
["2020-02-14T06:19:00",125368,{"$nulls":3},115669,9699,115,4.791666666666667,43.125]
["2020-02-13T06:11:00",125253,{"$nulls":3},115669,9584,95,3.9583333333333335,35.625]
["2020-02-12T06:54:00",125158,{"$nulls":3},115669,9489,99,4.125,37.125]
["2020-02-11T06:22:00",125059,{"$nulls":3},115669,9390,99,4.125,37.125]
["2020-02-10T05:43:00",124960,{"$nulls":3},115669,9291,98,4.083333333333333,36.75]
["2020-02-09T05:46:00",124862,{"$nulls":3},115669,9193,98,4.083333333333333,36.75]
["2020-02-08T06:25:00",124764,{"$nulls":3},115669,9095,106,4.416666666666667,39.75]
["2020-02-07T06:16:00",124658,{"$nulls":3},115669,8989,99,4.125,37.125]
["2020-02-06T06:30:00",124559,{"$nulls":3},115669,8890,95,3.9583333333333335,35.625]
["2020-02-05T06:52:00",124464,{"$nulls":3},115669,8795,103,4.291666666666667,38.625]
["2020-02-04T06:03:00",124361,{"$nulls":3},115669,8692,92,3.8333333333333335,34.5]
["2020-02-03T06:30:00",124269,{"$nulls":3},115669,8600,91,3.7916666666666665,34.125]
["2020-02-02T06:41:00",124178,{"$nulls":3},115669,8509,98,4.083333333333333,36.75]
["2020-02-01T06:22:00",124080,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":115669},8411,100,4.166666666666667,37.5]
["2020-01-31T05:28:00",123980,{"$nulls":3},115669,8311,88,3.6666666666666665,33]
["2020-01-30T07:31:00",123892,{"$nulls":3},115669,8223,101,4.208333333333333,37.875]
["2020-01-29T06:22:00",123791,{"$nulls":3},115669,8122,394,16.416666666666668,147.75]
["2020-01-25T06:47:00",123397,{"$nulls":3},115669,7728,104.0399999999936,4.3349999999997335,39.0149999999976]
["2020-01-24T06:18:00",123292.96,{"$nulls":3},115669,7623.960000000006,106.9600000000064,4.4566666666669335,40.1100000000024]
["2020-01-23T06:31:00",123186,{"$nulls":3},115669,7517,825.5800000000017,34.39916666666674,309.59250000000065]
["2020-01-15T06:41:00",122360.42,{"$nulls":3},115669,6691.419999999998,202.41999999999825,8.434166666666593,75.90749999999935]
["2020-01-13T06:54:00",122158,{"$nulls":3},115669,6489,98,4.083333333333333,36.75]
["2020-01-12T06:04:00",122060,{"$nulls":3},115669,6391,99,4.125,37.125]
["2020-01-11T07:22:00",121961,{"$nulls":3},115669,6292,203,8.458333333333334,76.125]
["2020-01-09T05:49:00",121758,{"$nulls":3},115669,6089,91.35000000000582,3.8062500000002424,34.25625000000218]
["2020-01-08T08:14:00",121666.65,{"$nulls":3},115669,5997.649999999994,106.64999999999418,4.443749999999757,39.99374999999782]
["2020-01-07T06:33:00",121560,{"$nulls":3},115669,5891,107,4.458333333333333,40.125]
["2020-01-06T06:04:00",121453,{"$nulls":3},115669,5784,100,4.166666666666667,37.5]
["2020-01-05T06:44:00",121353,{"$nulls":3},115669,5684,103,4.291666666666667,38.625]
["2020-01-04T07:23:00",121250,{"$nulls":3},115669,5581,102,4.25,38.25]
["2020-01-03T06:38:00",121148,{"$nulls":3},115669,5479,100,4.166666666666667,37.5]
["2020-01-02T06:38:00",121048,{"$nulls":3},115669,5379,317,13.208333333333334,118.875]
["2019-12-30T04:52:00",120731,{"$nulls":3},115669,5062,102,4.25,38.25]
["2019-12-29T05:50:00",120629,{"$nulls":3},115669,4960,94,3.9166666666666665,35.25]
["2019-12-28T06:51:00",120535,{"$nulls":3},115669,4866,96,4,36]
["2019-12-27T06:46:00",120439,{"$nulls":3},115669,4770,203,8.458333333333334,76.125]
["2019-12-25T05:32:00",120236,{"$nulls":3},115669,4567,112,4.666666666666667,42]
["2019-12-24T06:41:00",120124,{"$nulls":3},115669,4455,143,5.958333333333333,53.625]
["2019-12-23T06:26:00",119981,{"$nulls":3},115669,4312,142,5.916666666666667,53.25]
["2019-12-22T05:58:00",119839,{"$nulls":3},115669,4170,143,5.958333333333333,53.625]
["2019-12-21T05:59:00",119696,{"$nulls":3},115669,4027,3823,159.29166666666666,1433.625]
["2019-12-13T07:06:00",115873,{"$nulls":3},115669,204,-2708,-112.83333333333333,-1015.5]
["2019-12-10T10:01:00",118581,{"$nulls":3},115669,2912,409,17.041666666666668,153.375]
["2019-12-06T06:37:00",118172,{"$nulls":3},115669,2503,218,9.083333333333334,81.75]
["2019-12-04T06:14:00",117954,{"$nulls":3},115669,2285,103,4.291666666666667,38.625]
["2019-12-03T06:29:00",117851,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":115669},2182,104,4.333333333333333,39]
["2019-12-02T06:01:00",117747,{"$nulls":3},115669,{"$f":"B67-F67","v":2078},{"$f":"G67-G68","v":107},{"$f":"H67/24","v":4.458333333333333},{"$f":"I67*9","v":40.125}]
["2019-12-01T06:39:00",117640,{"$nulls":3},115669,1971,101.75,4.239583333333333,38.15625]
["2019-11-30T06:22:00",117538.25,{"$nulls":3},115669,1869.25,197.25,8.21875,73.96875]
["2019-11-28T05:53:00",117341,{"$nulls":3},115669,1672,92,3.8333333333333335,34.5]
["2019-11-27T06:58:00",117249,{"$nulls":3},115669,1580,95,3.9583333333333335,35.625]
["2019-11-26T09:10:00",117154,{"$nulls":3},115669,1485,113,4.708333333333333,42.375]
["2019-11-25T05:59:00",117041,{"$nulls":3},115669,1372,99,4.125,37.125]
["2019-11-24T07:02:00",116942,{"$nulls":3},115669,1273,103,4.291666666666667,38.625]
["2019-11-23T06:35:00",116839,{"$nulls":3},115669,1170,107,4.458333333333333,40.125]
["2019-11-22T06:22:00",116732,{"$nulls":3},115669,1063,101,4.208333333333333,37.875]
["2019-11-21T07:02:00",116631,{"$nulls":3},115669,962,108,4.5,40.5]
["2019-11-20T06:21:00",116523,{"$nulls":3},115669,854,108,4.5,40.5]
["2019-11-19T05:21:00",116415,{"$nulls":3},115669,746,97,4.041666666666667,36.375]
["2019-11-18T06:06:00",116318,{"$nulls":3},115669,649,112,4.666666666666667,42]
["2019-11-17T06:11:00",116206,{"$nulls":3},115669,537,113,4.708333333333333,42.375]
["2019-11-16T06:13:00",116093,{"$nulls":3},115669,424,102,4.25,38.25]
["2019-11-15T06:56:00",115991,{"$nulls":3},115669,322,217,9.041666666666666,81.375]
["2019-11-13T06:38:00",115774,{"$nulls":3},115669,105,105,4.375,39.375]
["2019-11-12T06:17:00",115669,{"$nulls":3},115669,0,{"$f":"G85-#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"PG1","index":6,"n_rows":87,"n_cols":10,"rows_kept":87}
["date_heure","index_PG1",null,null,"date jour 0","total pg1 jour0","différence  compteur jour 0","difference 24h","Débit/h dernière 24h","Debit x9"]
["2020-03-04T06:48:00",668115,null,null,{"$f":"MIN(A:A)","v":"2019-11-12T06:17:00"},{"$f":"VLOOKUP($E$2,A:B,2,)","v":457612},{"$f":"B2-F2","v":210503},{"$f":"G2-G3","v":1815},{"$f":"H2/24","v":75.625},{"$f":"I2*9","v":680.625}]
["2020-03-03T07:20:00",666300,{"$nulls":3},457612,{"$f":"B3-F3","v":208688},{"$f":"G3-G4","v":1737},{"$f":"H3/24","v":72.375},{"$f":"I3*9","v":651.375}]
["2020-03-02T07:07:00",664563,{"$nulls":3},457612,206951,1901,79.20833333333333,712.875]
["2020-03-01T06:21:00",662662,{"$nulls":3},457612,205050,1776,74,666]
["2020-02-29T06:30:00",660886,{"$nulls":3},457612,203274,1690,70.41666666666667,633.75]
["2020-02-28T06:26:00",659196,{"$nulls":3},457612,201584,2028,84.5,760.5]
["2020-02-27T06:47:00",657168,{"$nulls":3},457612,199556,1816,75.66666666666667,681]
["2020-02-26T06:13:00",655352,{"$nulls":3},457612,197740,1778,74.08333333333333,666.75]
["2020-02-25T05:47:00",653574,{"$nulls":3},457612,195962,1925,80.20833333333333,721.875]
["2020-02-24T06:25:00",651649,{"$nulls":3},457612,194037,1948,81.16666666666667,730.5]
["2020-02-23T06:32:00",649701,{"$nulls":3},457612,192089,1878,78.25,704.25]
["2020-02-22T06:35:00",647823,{"$nulls":3},457612,190211,1903,79.29166666666667,713.625]
["2020-02-21T06:31:00",645920,{"$nulls":3},457612,188308,1861,77.54166666666667,697.875]
["2020-02-20T05:44:00",644059,{"$nulls":3},457612,186447,1796,74.83333333333333,673.5]
["2020-02-19T06:53:00",642263,{"$nulls":3},457612,184651,1894.8000000000466,78.95000000000194,710.5500000000175]
["2020-02-18T06:45:00",640368.2,{"$nulls":3},457612,182756.19999999995,1822.1999999999534,75.92499999999806,683.3249999999825]
["2020-02-17T06:54:00",638546,{"$nulls":3},457612,180934,1921,80.04166666666667,720.375]
["2020-02-16T07:37:00",636625,{"$nulls":3},457612,179013,2128,88.66666666666667,798]
["2020-02-15T06:38:00",634497,{"$nulls":3},457612,176885,1856,77.33333333333333,696]
["2020-02-14T06:19:00",632641,{"$nulls":3},457612,175029,1917,79.875,718.875]
["2020-02-13T06:11:00",630724,{"$nulls":3},457612,173112,1830,76.25,686.25]
["2020-02-12T06:54:00",628894,{"$nulls":3},457612,171282,1918,79.91666666666667,719.25]
["2020-02-11T06:22:00",626976,{"$nulls":3},457612,169364,1954,81.41666666666667,732.75]
["2020-02-10T05:43:00",625022,{"$nulls":3},457612,167410,1935,80.625,725.625]
["2020-02-09T05:46:00",623087,{"$nulls":3},457612,165475,1727,71.95833333333333,647.625]
["2020-02-08T06:25:00",621360,{"$nulls":3},457612,163748,1889,78.70833333333333,708.375]
["2020-02-07T06:16:00",619471,{"$nulls":3},457612,161859,1861,77.54166666666667,697.875]
["2020-02-06T06:30:00",617610,{"$nulls":3},457612,159998,1753,73.04166666666667,657.375]
["2020-02-05T06:52:00",615857,{"$nulls":3},457612,158245,1917,79.875,718.875]
["2020-02-04T06:03:00",613940,{"$nulls":3},457612,156328,1863,77.625,698.625]
["2020-02-03T06:30:00",612077,{"$nulls":3},457612,154465,-5489551,-228731.29166666666,-2058581.625]
["2020-02-02T06:41:00",6101628,{"$nulls":3},457612,5644016,5493400,228891.66666666666,2060025]
["2020-02-01T06:22:00",608228,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":457612},150616,1974,82.25,740.25]
["2020-01-31T05:28:00",606254,{"$nulls":3},457612,148642,1737,72.375,651.375]
["2020-01-30T07:31:00",604517,{"$nulls":3},457612,146905,1831,76.29166666666667,686.625]
["2020-01-29T06:22:00",602686,{"$nulls":3},457612,145074,543203,22633.458333333332,203701.125]
["2020-01-25T06:47:00",59483,{"$nulls":3},457612,-398129,-533329.2,-22222.05,-199998.44999999998]
["2020-01-24T06:18:00",592812.2,{"$nulls":3},457612,135200.19999999995,2026.1999999999534,84.42499999999806,759.8249999999825]
["2020-01-23T06:31:00",590786,{"$nulls":3},457612,133174,14941.900000000023,622.5791666666677,5603.212500000009]
["2020-01-15T06:41:00",575844.1,{"$nulls":3},457612,118232.09999999998,3792.0999999999767,158.0041666666657,1422.0374999999913]
["2020-01-13T06:54:00",572052,{"$nulls":3},457612,114440,1964,81.83333333333333,736.5]
["2020-01-12T06:04:00",570088,{"$nulls":3},457612,112476,1906,79.41666666666667,714.75]
["2020-01-11T07:22:00",568182,{"$nulls":3},457612,110570,3939,164.125,1477.125]
["2020-01-09T05:49:00",564243,{"$nulls":3},457612,106631,1779.0999999999767,74.1291666666657,667.1624999999913]
["2020-01-08T08:14:00",562463.9,{"$nulls":3},457612,104851.90000000002,2069.9000000000233,86.2458333333343,776.2125000000087]
["2020-01-07T06:33:00",560394,{"$nulls":3},457612,102782,1991,82.95833333333333,746.625]
["2020-01-06T06:04:00",558403,{"$nulls":3},457612,100791,1930,80.41666666666667,723.75]
["2020-01-05T06:44:00",556473,{"$nulls":3},457612,98861,1902,79.25,713.25]
["2020-01-04T07:23:00",554571,{"$nulls":3},457612,96959,1695,70.625,635.625]
["2020-01-03T06:38:00",552876,{"$nulls":3},457612,95264,2209,92.04166666666667,828.375]
["2020-01-02T06:38:00",550667,{"$nulls":3},457612,93055,3744,156,1404]
["2019-12-31T06:15:00",546923,{"$nulls":3},457612,89311,1995,83.125,748.125]
["2019-12-30T04:52:00",544928,{"$nulls":3},457612,87316,1897,79.04166666666667,711.375]
["2019-12-29T05:50:00",543031,{"$nulls":3},457612,85419,1714,71.41666666666667,642.75]
["2019-12-28T06:51:00",541317,{"$nulls":3},457612,83705,1684,70.16666666666667,631.5]
["2019-12-27T06:46:00",539633,{"$nulls":3},457612,82021,4012,167.16666666666666,1504.5]
["2019-12-25T05:32:00",535621,{"$nulls":3},457612,78009,1776,74,666]
["2019-12-24T06:41:00",533845,{"$nulls":3},457612,76233,1975,82.29166666666667,740.625]
["2019-12-23T06:26:00",531870,{"$nulls":3},457612,74258,1715,71.45833333333333,643.125]
["2019-12-22T05:58:00",530155,{"$nulls":3},457612,72543,1778,74.08333333333333,666.75]
["2019-12-21T05:59:00",528377,{"$nulls":3},457612,70765,13906,579.4166666666666,5214.75]
["2019-12-13T07:06:00",514471,{"$nulls":3},457612,56859,5365,223.54166666666666,2011.875]
["2019-12-10T10:01:00",509106,{"$nulls":3},457612,51494,7681,320.0416666666667,2880.375]
["2019-12-06T06:37:00",501425,{"$nulls":3},457612,43813,4048,168.66666666666666,1518]
["2019-12-04T06:14:00",497377,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":457612},39765,1891,78.79166666666667,709.125]
["2019-12-03T06:29:00",495486,{"$nulls":3},457612,{"$f":"B67-F67","v":37874},{"$f":"G67-G68","v":1797},{"$f":"H67/24","v":74.875},{"$f":"I67*9","v":673.875}]
["2019-12-02T06:01:00",493689,{"$nulls":3},457612,36077,1854,77.25,695.25]
["2019-12-01T06:39:00",491835,{"$nulls":3},457612,34223,1850.7999999999884,77.11666666666618,694.0499999999956]
["2019-11-30T06:22:00",489984.2,{"$nulls":3},457612,32372.20000000001,1814.2000000000116,75.59166666666715,680.3250000000044]
["2019-11-29T06:48:00",488170,{"$nulls":3},457612,30558,1841,76.70833333333333,690.375]
["2019-11-28T05:53:00",486329,{"$nulls":3},457612,28717,1676,69.83333333333333,628.5]
["2019-11-27T06:58:00",484653,{"$nulls":3},457612,27041,1680,70,630]
["2019-11-26T09:10:00",482973,{"$nulls":3},457612,25361,1917,79.875,718.875]
["2019-11-25T05:59:00",481056,{"$nulls":3},457612,23444,1711,71.29166666666667,641.625]
["2019-11-24T07:02:00",479345,{"$nulls":3},457612,21733,1713,71.375,642.375]
["2019-11-23T06:35:00",477632,{"$nulls":3},457612,20020,1680,70,630]
["2019-11-22T06:22:00",475952,{"$nulls":3},457612,18340,1817,75.70833333333333,681.375]
["2019-11-21T07:02:00",474135,{"$nulls":3},457612,16523,1903,79.29166666666667,713.625]
["2019-11-20T06:21:00",472232,{"$nulls":3},457612,14620,1727,71.95833333333333,647.625]
["2019-11-19T05:21:00",470505,{"$nulls":3},457612,12893,101663,4235.958333333333,38123.625]
["2019-11-18T06:06:00",368842,{"$nulls":3},457612,-88770,-98150,-4089.5833333333335,-36806.25]
["2019-11-17T06:11:00",466992,{"$nulls":3},457612,9380,1951,81.29166666666667,731.625]
["2019-11-16T06:13:00",465041,{"$nulls":3},457612,7429,1792,74.66666666666667,672]
["2019-11-15T06:56:00",463249,{"$nulls":3},457612,5637,3816,159,1431]
["2019-11-13T06:38:00",459433,{"$nulls":3},457612,1821,1821,75.875,682.875]
["2019-11-12T06:17:00",457612,{"$nulls":3},457612,0,{"$f":"G87-#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"SSA4","index":7,"n_rows":41,"n_cols":10,"rows_kept":41}
["date_heure","index_SSA4",null,null,"date jour 0","total ssa4 jour0","différence  compteur jour 0","difference 24h","Débit/h dernière 24h","Debit x9"]
["2020-01-05T06:46:00",298313,null,null,{"$f":"MIN(A:A)","v":"2019-11-13T09:16:00"},{"$f":"VLOOKUP($E$2,A:B,2,)","v":298313},{"$f":"B2-F2","v":0},{"$f":"G2-G3","v":298313},{"$f":"H2/24","v":12429.708333333334},{"$f":"I2*9","v":111867.375}]
["2020-01-04T06:22:00",0,{"$nulls":3},298313,{"$f":"B3-F3","v":-298313},{"$f":"G3-G4","v":-298313},{"$f":"H3/24","v":-12429.708333333334},{"$f":"I3*9","v":-111867.375}]
["2020-01-03T07:30:00",298313,{"$nulls":3},298313,0,0,0,0]
["2020-01-02T07:33:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-12-31T06:32:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-12-30T06:26:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-12-29T06:01:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-12-28T07:25:00",298313,{"$nulls":3},298313,0,-0.5100000000093132,-0.021250000000388052,-0.19125000000349246]
["2019-12-27T06:40:00",298313.51,{"$nulls":3},298313,0.5100000000093132,0.5100000000093132,0.021250000000388052,0.19125000000349246]
["2019-12-26T06:39:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-12-25T05:22:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-12-23T06:23:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-12-22T05:57:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-12-21T06:01:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-12-20T06:33:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-12-19T06:03:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-12-15T06:34:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-12-13T06:56:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-12-11T06:17:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-12-07T06:38:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-12-04T06:10:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-12-03T06:34:00",298313,{"$nulls":3},298313,0,298313,12429.708333333334,111867.375]
["2019-12-02T07:32:00",0,{"$nulls":3},298313,-298313,0,0,0]
["2019-12-02T07:32:00",0,{"$nulls":3},298313,-298313,-298313.51,-12429.729583333334,-111867.56625]
["2019-12-01T06:41:00",298313.51,{"$nulls":3},298313,0.5100000000093132,0.5100000000093132,0.021250000000388052,0.19125000000349246]
["2019-11-30T08:33:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-11-29T07:58:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-11-28T05:54:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-11-27T07:07:00",298313,{"$nulls":3},298313,0,-0.5100000000093132,-0.021250000000388052,-0.19125000000349246]
["2019-11-24T07:01:00",298313.51,{"$nulls":3},298313,0.5100000000093132,0.5100000000093132,0.021250000000388052,0.19125000000349246]
["2019-11-24T06:48:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-11-23T06:34:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-11-22T06:46:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-11-21T06:59:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-11-20T07:35:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-11-19T08:32:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-11-18T06:02:00",298313,{"$nulls":3},298313,0,-0.5100000000093132,-0.021250000000388052,-0.19125000000349246]
["2019-11-17T05:56:00",298313.51,{"$nulls":3},298313,0.5100000000093132,0.5100000000093132,0.021250000000388052,0.19125000000349246]
["2019-11-16T07:22:00",298313,{"$nulls":3},298313,0,0,0,0]
["2019-11-13T09:16:00",298313,{"$nulls":3},298313,0,{"$f":"G41-#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"PG2","index":8,"n_rows":87,"n_cols":10,"rows_kept":87}
["date_heure","index_PG2",null,null,"date jour 0","total pg2 jour0","différence  compteur jour 0","difference 24h","Débit/h dernière 24h"]
["2020-03-04T06:48:00",575377,null,null,{"$f":"MIN(A:A)","v":"2019-11-12T06:17:00"},{"$f":"VLOOKUP($E$2,A:B,2,)","v":346106},{"$f":"B2-F2","v":229271},{"$f":"G2-G3","v":2129},{"$f":"H2/24","v":88.70833333333333},{"$f":"I2*9","v":798.375}]
["2020-03-03T07:20:00",573248,{"$nulls":3},346106,{"$f":"B3-F3","v":227142},{"$f":"G3-G4","v":1997},{"$f":"H3/24","v":83.20833333333333},{"$f":"I3*9","v":748.875}]
["2020-03-02T07:07:00",571251,{"$nulls":3},346106,225145,2099,87.45833333333333,787.125]
["2020-03-01T06:21:00",569152,{"$nulls":3},346106,223046,1671,69.625,626.625]
["2020-02-29T06:30:00",567481,{"$nulls":3},346106,221375,1727,71.95833333333333,647.625]
["2020-02-28T06:26:00",565754,{"$nulls":3},346106,219648,2188,91.16666666666667,820.5]
["2020-02-27T06:47:00",563566,{"$nulls":3},346106,217460,2085,86.875,781.875]
["2020-02-26T06:13:00",561481,{"$nulls":3},346106,215375,2061,85.875,772.875]
["2020-02-25T05:47:00",559420,{"$nulls":3},346106,213314,2021,84.20833333333333,757.875]
["2020-02-24T06:25:00",557399,{"$nulls":3},346106,211293,2052,85.5,769.5]
["2020-02-23T06:32:00",555347,{"$nulls":3},346106,209241,2076,86.5,778.5]
["2020-02-22T06:35:00",553271,{"$nulls":3},346106,207165,2173,90.54166666666667,814.875]
["2020-02-21T06:31:00",551098,{"$nulls":3},346106,204992,1934,80.58333333333333,725.25]
["2020-02-20T05:44:00",549164,{"$nulls":3},346106,203058,2039,84.95833333333333,764.625]
["2020-02-19T06:53:00",547125,{"$nulls":3},346106,201019,2214.9000000000233,92.28750000000097,830.5875000000087]
["2020-02-18T06:45:00",544910.1,{"$nulls":3},346106,198804.09999999998,2080.0999999999767,86.67083333333237,780.0374999999913]
["2020-02-17T06:54:00",542830,{"$nulls":3},346106,196724,1457,60.708333333333336,546.375]
["2020-02-16T07:37:00",541373,{"$nulls":3},346106,195267,2039,84.95833333333333,764.625]
["2020-02-15T06:38:00",539334,{"$nulls":3},346106,193228,2094,87.25,785.25]
["2020-02-14T06:19:00",537240,{"$nulls":3},346106,191134,1767,73.625,662.625]
["2020-02-13T06:11:00",535473,{"$nulls":3},346106,189367,2148,89.5,805.5]
["2020-02-12T06:54:00",533325,{"$nulls":3},346106,187219,2176,90.66666666666667,816]
["2020-02-11T06:22:00",531149,{"$nulls":3},346106,185043,1683,70.125,631.125]
["2020-02-10T05:43:00",529466,{"$nulls":3},346106,183360,1384,57.666666666666664,519]
["2020-02-09T05:46:00",528082,{"$nulls":3},346106,181976,1958,81.58333333333333,734.25]
["2020-02-08T06:25:00",526124,{"$nulls":3},346106,180018,2093,87.20833333333333,784.875]
["2020-02-07T06:16:00",524031,{"$nulls":3},346106,177925,2070,86.25,776.25]
["2020-02-06T06:30:00",521961,{"$nulls":3},346106,175855,2004,83.5,751.5]
["2020-02-05T06:52:00",519957,{"$nulls":3},346106,173851,2266,94.41666666666667,849.75]
["2020-02-04T06:03:00",517691,{"$nulls":3},346106,171585,1967,81.95833333333333,737.625]
["2020-02-03T06:30:00",515724,{"$nulls":3},346106,169618,-4622641,-192610.04166666666,-1733490.375]
["2020-02-02T06:41:00",5138365,{"$nulls":3},346106,4792259,4626500,192770.83333333334,1734937.5]
["2020-02-01T06:22:00",511865,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":346106},165759,2046,85.25,767.25]
["2020-01-31T05:28:00",509819,{"$nulls":3},346106,163713,1817,75.70833333333333,681.375]
["2020-01-30T07:31:00",508002,{"$nulls":3},346106,161896,2309,96.20833333333333,865.875]
["2020-01-29T06:22:00",505693,{"$nulls":3},346106,159587,7820,325.8333333333333,2932.5]
["2020-01-25T06:47:00",497873,{"$nulls":3},346106,151767,2274.2000000000116,94.75833333333382,852.8250000000044]
["2020-01-24T06:18:00",495598.8,{"$nulls":3},346106,149492.8,2283.7999999999884,95.15833333333285,856.4249999999956]
["2020-01-23T06:31:00",493315,{"$nulls":3},346106,147209,16892.70000000001,703.8625000000005,6334.762500000004]
["2020-01-15T06:41:00",476422.3,{"$nulls":3},346106,130316.29999999999,3457.2999999999884,144.0541666666662,1296.4874999999956]
["2020-01-13T06:54:00",472965,{"$nulls":3},346106,126859,2031,84.625,761.625]
["2020-01-12T06:04:00",470934,{"$nulls":3},346106,124828,2112,88,792]
["2020-01-11T07:22:00",468822,{"$nulls":3},346106,122716,3942,164.25,1478.25]
["2020-01-09T05:49:00",464880,{"$nulls":3},346106,118774,1869.2999999999884,77.88749999999952,700.9874999999956]
["2020-01-08T08:14:00",463010.7,{"$nulls":3},346106,116904.70000000001,2231.7000000000116,92.98750000000048,836.8875000000044]
["2020-01-07T06:33:00",460779,{"$nulls":3},346106,114673,2148,89.5,805.5]
["2020-01-06T06:04:00",458631,{"$nulls":3},346106,112525,2088,87,783]
["2020-01-05T06:44:00",456543,{"$nulls":3},346106,110437,2126,88.58333333333333,797.25]
["2020-01-04T07:23:00",454417,{"$nulls":3},346106,108311,1967,81.95833333333333,737.625]
["2020-01-03T06:38:00",452450,{"$nulls":3},346106,106344,2208,92,828]
["2020-01-02T06:38:00",450242,{"$nulls":3},346106,104136,4254,177.25,1595.25]
["2019-12-31T06:15:00",445988,{"$nulls":3},346106,99882,2172,90.5,814.5]
["2019-12-30T04:52:00",443816,{"$nulls":3},346106,97710,2098,87.41666666666667,786.75]
["2019-12-29T05:50:00",441718,{"$nulls":3},346106,95612,2055,85.625,770.625]
["2019-12-28T06:51:00",439663,{"$nulls":3},346106,93557,1968,82,738]
["2019-12-27T06:46:00",437695,{"$nulls":3},346106,91589,4463,185.95833333333334,1673.625]
["2019-12-25T05:32:00",433232,{"$nulls":3},346106,87126,390103,16254.291666666666,146288.625]
["2019-12-24T06:41:00",43129,{"$nulls":3},346106,-302977,-386095,-16087.291666666666,-144785.625]
["2019-12-23T06:26:00",429224,{"$nulls":3},346106,83118,1682,70.08333333333333,630.75]
["2019-12-22T05:58:00",427542,{"$nulls":3},346106,81436,1715,71.45833333333333,643.125]
["2019-12-21T05:59:00",425827,{"$nulls":3},346106,79721,15530,647.0833333333334,5823.75]
["2019-12-13T07:06:00",410297,{"$nulls":3},346106,64191,2577,107.375,966.375]
["2019-12-10T10:01:00",407720,{"$nulls":3},346106,61614,11490,478.75,4308.75]
["2019-12-06T06:37:00",396230,{"$nulls":3},346106,50124,4523,188.45833333333334,1696.125]
["2019-12-04T06:14:00",391707,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":346106},45601,2159,89.95833333333333,809.625]
["2019-12-03T06:29:00",389548,{"$nulls":3},346106,{"$f":"B67-F67","v":43442},{"$f":"G67-G68","v":2062},{"$f":"H67/24","v":85.91666666666667},{"$f":"I67*9","v":773.25}]
["2019-12-02T06:01:00",387486,{"$nulls":3},346106,41380,2061,85.875,772.875]
["2019-12-01T06:39:00",385425,{"$nulls":3},346106,39319,2127,88.625,797.625]
["2019-11-30T06:22:00",383298,{"$nulls":3},346106,37192,2087,86.95833333333333,782.625]
["2019-11-29T06:48:00",381211,{"$nulls":3},346106,35105,2127,88.625,797.625]
["2019-11-28T05:53:00",379084,{"$nulls":3},346106,32978,1708,71.16666666666667,640.5]
["2019-11-27T06:58:00",377376,{"$nulls":3},346106,31270,1755,73.125,658.125]
["2019-11-26T09:10:00",375621,{"$nulls":3},346106,29515,2262,94.25,848.25]
["2019-11-25T05:59:00",373359,{"$nulls":3},346106,27253,2036,84.83333333333333,763.5]
["2019-11-24T07:02:00",371323,{"$nulls":3},346106,25217,2057,85.70833333333333,771.375]
["2019-11-23T06:35:00",369266,{"$nulls":3},346106,23160,2019,84.125,757.125]
["2019-11-22T06:22:00",367247,{"$nulls":3},346106,21141,2019,84.125,757.125]
["2019-11-21T07:02:00",365228,{"$nulls":3},346106,19122,2215,92.29166666666667,830.625]
["2019-11-20T06:21:00",363013,{"$nulls":3},346106,16907,2024,84.33333333333333,759]
["2019-11-19T05:21:00",360989,{"$nulls":3},346106,14883,2024,84.33333333333333,759]
["2019-11-18T06:06:00",358965,{"$nulls":3},346106,12859,2272,94.66666666666667,852]
["2019-11-17T06:11:00",356693,{"$nulls":3},346106,10587,2231,92.95833333333333,836.625]
["2019-11-16T06:13:00",354462,{"$nulls":3},346106,8356,2098,87.41666666666667,786.75]
["2019-11-15T06:56:00",352364,{"$nulls":3},346106,6258,4104,171,1539]
["2019-11-13T06:38:00",348260,{"$nulls":3},346106,2154,2154,89.75,807.75]
["2019-11-12T06:17:00",346106,{"$nulls":3},346106,0,{"$f":"G87-#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"PR","index":9,"n_rows":93,"n_cols":10,"rows_kept":93}
["date_heure","index_PR",null,null,"date jour 0","total pr jour0","différence  compteur jour 0","difference 24h","Débit/h dernière 24h","Debit x9"]
["2020-03-04T06:53:00",572263,null,null,{"$f":"MIN(A:A)","v":"2019-11-13T09:16:00"},{"$f":"VLOOKUP($E$2,A:B,2,)","v":500601},{"$f":"B2-F2","v":71662},{"$f":"G2-G3","v":627},{"$f":"H2/24","v":26.125},{"$f":"I2*9","v":235.125}]
["2020-03-03T07:22:00",571636,{"$nulls":3},500601,{"$f":"B3-F3","v":71035},{"$f":"G3-G4","v":686},{"$f":"H3/24","v":28.583333333333332},{"$f":"I3*9","v":257.25}]
["2020-03-02T07:54:00",570950,{"$nulls":3},500601,70349,720,30,270]
["2020-03-01T06:25:00",570230,{"$nulls":3},500601,69629,698,29.083333333333332,261.75]
["2020-02-29T06:57:00",569532,{"$nulls":3},500601,68931,670,27.916666666666668,251.25]
["2020-02-28T07:26:00",568862,{"$nulls":3},500601,68261,686,28.583333333333332,257.25]
["2020-02-27T07:00:00",568176,{"$nulls":3},500601,67575,-5106851,-212785.45833333334,-1915069.125]
["2020-02-26T06:07:00",5675027,{"$nulls":3},500601,5174426,5108217,212842.375,1915581.375]
["2020-02-25T06:46:00",566810,{"$nulls":3},500601,66209,667,27.791666666666668,250.125]
["2020-02-24T06:30:00",566143,{"$nulls":3},500601,65542,631,26.291666666666668,236.625]
["2020-02-23T06:06:00",565512,{"$nulls":3},500601,64911,607,25.291666666666668,227.625]
["2020-02-22T07:28:00",564905,{"$nulls":3},500601,64304,597,24.875,223.875]
["2020-02-21T06:29:00",564308,{"$nulls":3},500601,63707,642,26.75,240.75]
["2020-02-20T05:38:00",563666,{"$nulls":3},500601,63065,618.8000000000466,25.783333333335275,232.05000000001746]
["2020-02-19T07:04:00",563047.2,{"$nulls":3},500601,62446.19999999995,627.1999999999534,26.133333333331393,235.19999999998254]
["2020-02-18T06:45:00",562420,{"$nulls":3},500601,61819,682,28.416666666666668,255.75]
["2020-02-17T06:57:00",561738,{"$nulls":3},500601,61137,708,29.5,265.5]
["2020-02-16T07:37:00",561030,{"$nulls":3},500601,60429,774,32.25,290.25]
["2020-02-15T06:11:00",560256,{"$nulls":3},500601,59655,658,27.416666666666668,246.75]
["2020-02-14T06:34:00",559598,{"$nulls":3},500601,58997,672,28,252]
["2020-02-13T07:31:00",558926,{"$nulls":3},500601,58325,642,26.75,240.75]
["2020-02-12T06:19:00",558284,{"$nulls":3},500601,57683,618,25.75,231.75]
["2020-02-11T07:35:00",557666,{"$nulls":3},500601,57065,754,31.416666666666668,282.75]
["2020-02-10T05:43:00",556912,{"$nulls":3},500601,56311,673,28.041666666666668,252.375]
["2020-02-09T05:50:00",556239,{"$nulls":3},500601,55638,612,25.5,229.5]
["2020-02-08T07:23:00",555627,{"$nulls":3},500601,55026,639,26.625,239.625]
["2020-02-07T06:09:00",554988,{"$nulls":3},500601,54387,1151,47.958333333333336,431.625]
["2020-02-05T07:57:00",553837,{"$nulls":3},500601,53236,713,29.708333333333332,267.375]
["2020-02-04T05:54:00",553124,{"$nulls":3},500601,52523,717,29.875,268.875]
["2020-02-03T06:26:00",552407,{"$nulls":3},500601,51806,715,29.791666666666668,268.125]
["2020-02-02T06:38:00",551692,{"$nulls":3},500601,51091,718,29.916666666666668,269.25]
["2020-02-01T06:03:00",550974,{"$nulls":3},500601,50373,701,29.208333333333332,262.875]
["2020-01-31T06:42:00",550273,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":500601},49672,641,26.708333333333332,240.375]
["2020-01-30T07:07:00",549632,{"$nulls":3},500601,49031,621,25.875,232.875]
["2020-01-29T06:13:00",549011,{"$nulls":3},500601,48410,603.5,25.145833333333332,226.3125]
["2020-01-28T06:41:00",548407.5,{"$nulls":3},500601,47806.5,1669.5,69.5625,626.0625]
["2020-01-25T07:56:00",546738,{"$nulls":3},500601,46137,1324,55.166666666666664,496.5]
["2020-01-22T05:44:00",545414,{"$nulls":3},500601,44813,428,17.833333333333332,160.5]
["2020-01-21T05:41:00",544986,{"$nulls":3},500601,44385,941,39.208333333333336,352.875]
["2020-01-19T06:29:00",544045,{"$nulls":3},500601,43444,1235,51.458333333333336,463.125]
["2020-01-17T06:54:00",542810,{"$nulls":3},500601,42209,654,27.25,245.25]
["2020-01-16T06:23:00",542156,{"$nulls":3},500601,41555,1424,59.333333333333336,534]
["2020-01-14T06:38:00",540732,{"$nulls":3},500601,40131,668,27.833333333333332,250.5]
["2020-01-13T07:51:00",540064,{"$nulls":3},500601,39463,652,27.166666666666668,244.5]
["2020-01-12T08:49:00",539412,{"$nulls":3},500601,38811,1967,81.95833333333333,737.625]
["2020-01-09T05:46:00",537445,{"$nulls":3},500601,36844,596,24.833333333333332,223.5]
["2020-01-08T06:45:00",536849,{"$nulls":3},500601,36248,613,25.541666666666668,229.875]
["2020-01-07T06:41:00",536236,{"$nulls":3},500601,35635,490,20.416666666666668,183.75]
["2020-01-06T07:22:00",535746,{"$nulls":3},500601,35145,525,21.875,196.875]
["2020-01-05T06:46:00",535221,{"$nulls":3},500601,34620,607.8000000000466,25.32500000000194,227.92500000001746]
["2020-01-04T06:22:00",534613.2,{"$nulls":3},500601,34012.19999999995,606.1999999999534,25.258333333331393,227.32499999998254]
["2020-01-03T07:30:00",534007,{"$nulls":3},500601,33406,587,24.458333333333332,220.125]
["2020-01-02T07:33:00",533420,{"$nulls":3},500601,32819,1093,45.541666666666664,409.875]
["2019-12-31T06:32:00",532327,{"$nulls":3},500601,31726,482,20.083333333333332,180.75]
["2019-12-30T06:26:00",531845,{"$nulls":3},500601,31244,587,24.458333333333332,220.125]
["2019-12-29T06:01:00",531258,{"$nulls":3},500601,30657,662,27.583333333333332,248.25]
["2019-12-28T07:25:00",530596,{"$nulls":3},500601,29995,731.1999999999534,30.466666666664725,274.19999999998254]
["2019-12-27T06:40:00",529864.8,{"$nulls":3},500601,29263.800000000047,643.8000000000466,26.82500000000194,241.42500000001746]
["2019-12-26T06:39:00",529221,{"$nulls":3},500601,28620,728,30.333333333333332,273]
["2019-12-25T05:22:00",528493,{"$nulls":3},500601,27892,1283,53.458333333333336,481.125]
["2019-12-23T06:23:00",527210,{"$nulls":3},500601,26609,768,32,288]
["2019-12-22T05:57:00",526442,{"$nulls":3},500601,25841,-4730717,-197113.20833333334,-1774018.875]
["2019-12-21T06:01:00",5257159,{"$nulls":3},500601,4756558,4732208,197175.33333333334,1774578]
["2019-12-20T06:33:00",524951,{"$nulls":3},500601,24350,756,31.5,283.5]
["2019-12-19T06:03:00",524195,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":500601},23594,2723,113.45833333333333,1021.125]
["2019-12-15T06:34:00",521472,{"$nulls":3},500601,{"$f":"B67-F67","v":20871},{"$f":"G67-G68","v":1489},{"$f":"H67/24","v":62.041666666666664},{"$f":"I67*9","v":558.375}]
["2019-12-13T06:56:00",519983,{"$nulls":3},500601,19382,1299,54.125,487.125]
["2019-12-11T06:17:00",518684,{"$nulls":3},500601,18083,2575,107.29166666666667,965.625]
["2019-12-07T06:38:00",516109,{"$nulls":3},500601,15508,1490,62.083333333333336,558.75]
["2019-12-04T06:10:00",514619,{"$nulls":3},500601,14018,506,21.083333333333332,189.75]
["2019-12-03T06:34:00",514113,{"$nulls":3},500601,13512,521,21.708333333333332,195.375]
["2019-12-02T07:32:00",513592,{"$nulls":3},500601,12991,0,0,0]
["2019-12-02T07:32:00",513592,{"$nulls":3},500601,12991,641,26.708333333333332,240.375]
["2019-12-01T06:41:00",512951,{"$nulls":3},500601,12350,631,26.291666666666668,236.625]
["2019-11-30T08:33:00",512320,{"$nulls":3},500601,11719,770,32.083333333333336,288.75]
["2019-11-29T07:58:00",511550,{"$nulls":3},500601,10949,863,35.958333333333336,323.625]
["2019-11-28T05:54:00",510687,{"$nulls":3},500601,10086,789,32.875,295.875]
["2019-11-27T07:07:00",509898,{"$nulls":3},500601,9297,1580,65.83333333333333,592.5]
["2019-11-25T06:08:00",508318,{"$nulls":3},500601,7717,-772.2999999999884,-32.179166666666184,-289.61249999999563]
["2019-11-24T07:01:00",509090.3,{"$nulls":3},500601,8489.299999999988,4436.299999999988,184.84583333333285,1663.6124999999956]
["2019-11-24T06:48:00",504654,{"$nulls":3},500601,4053,-2250,-93.75,-843.75]
["2019-11-23T06:34:00",506904,{"$nulls":3},500601,6303,683,28.458333333333332,256.125]
["2019-11-22T06:46:00",506221,{"$nulls":3},500601,5620,582,24.25,218.25]
["2019-11-21T06:59:00",505639,{"$nulls":3},500601,5038,634,26.416666666666668,237.75]
["2019-11-20T07:35:00",505005,{"$nulls":3},500601,4404,575,23.958333333333332,215.625]
["2019-11-19T08:32:00",504430,{"$nulls":3},500601,3829,663,27.625,248.625]
["2019-11-18T06:02:00",503767,{"$nulls":3},500601,3166,604.9000000000233,25.204166666667636,226.83750000000873]
["2019-11-17T05:56:00",503162.1,{"$nulls":3},500601,2561.0999999999767,580.0999999999767,24.170833333332364,217.53749999999127]
["2019-11-16T07:22:00",502582,{"$nulls":3},500601,1981,639,26.625,239.625]
["2019-11-15T06:58:00",501943,{"$nulls":3},500601,1342,617,25.708333333333332,231.375]
["2019-11-14T11:11:00",501326,{"$nulls":3},500601,725,725,30.208333333333332,271.875]
["2019-11-13T09:16:00",500601,{"$nulls":3},500601,0,{"$f":"G93-#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"PS","index":10,"n_rows":93,"n_cols":10,"rows_kept":93}
["date_heure","index_PS",null,null,"date jour 0","total PS jour0","différence  compteur jour 0","difference 24h","Débit/h dernière 24h","Debit x9"]
["2020-03-04T06:53:00",604145,null,null,{"$f":"MIN(A:A)","v":"2019-11-13T09:16:00"},{"$f":"VLOOKUP($E$2,A:B,2,)","v":542822},{"$f":"B2-F2","v":61323},{"$f":"G2-G3","v":605},{"$f":"H2/24","v":25.208333333333332},{"$f":"I2*9","v":226.875}]
["2020-03-03T07:22:00",603540,{"$nulls":3},542822,{"$f":"B3-F3","v":60718},{"$f":"G3-G4","v":629},{"$f":"H3/24","v":26.208333333333332},{"$f":"I3*9","v":235.875}]
["2020-03-02T07:54:00",602911,{"$nulls":3},542822,60089,666,27.75,249.75]
["2020-03-01T06:25:00",602245,{"$nulls":3},542822,59423,596,24.833333333333332,223.5]
["2020-02-29T06:57:00",601649,{"$nulls":3},542822,58827,591,24.625,221.625]
["2020-02-28T07:26:00",601058,{"$nulls":3},542822,58236,653,27.208333333333332,244.875]
["2020-02-27T07:00:00",600405,{"$nulls":3},542822,57583,569,23.708333333333332,213.375]
["2020-02-26T06:07:00",599836,{"$nulls":3},542822,57014,581,24.208333333333332,217.875]
["2020-02-25T06:46:00",599255,{"$nulls":3},542822,56433,598,24.916666666666668,224.25]
["2020-02-24T06:30:00",598657,{"$nulls":3},542822,55835,551,22.958333333333332,206.625]
["2020-02-23T06:06:00",598106,{"$nulls":3},542822,55284,540,22.5,202.5]
["2020-02-22T07:28:00",597566,{"$nulls":3},542822,54744,559,23.291666666666668,209.625]
["2020-02-21T06:29:00",597007,{"$nulls":3},542822,54185,567,23.625,212.625]
["2020-02-20T05:38:00",596440,{"$nulls":3},542822,53618,545.6999999999534,22.73749999999806,204.63749999998254]
["2020-02-19T07:04:00",595894.3,{"$nulls":3},542822,53072.30000000005,550.3000000000466,22.929166666668607,206.36250000001746]
["2020-02-18T06:45:00",595344,{"$nulls":3},542822,52522,568,23.666666666666668,213]
["2020-02-17T06:57:00",594776,{"$nulls":3},542822,51954,586,24.416666666666668,219.75]
["2020-02-16T07:37:00",594190,{"$nulls":3},542822,51368,627,26.125,235.125]
["2020-02-15T06:11:00",593563,{"$nulls":3},542822,50741,553,23.041666666666668,207.375]
["2020-02-14T06:34:00",593010,{"$nulls":3},542822,50188,592,24.666666666666668,222]
["2020-02-13T07:31:00",592418,{"$nulls":3},542822,49596,587,24.458333333333332,220.125]
["2020-02-12T06:19:00",591831,{"$nulls":3},542822,49009,565,23.541666666666668,211.875]
["2020-02-11T07:35:00",591266,{"$nulls":3},542822,48444,620,25.833333333333332,232.5]
["2020-02-10T05:43:00",590646,{"$nulls":3},542822,47824,583,24.291666666666668,218.625]
["2020-02-09T05:50:00",590063,{"$nulls":3},542822,47241,535,22.291666666666668,200.625]
["2020-02-08T07:23:00",589528,{"$nulls":3},542822,46706,611,25.458333333333332,229.125]
["2020-02-07T06:09:00",588917,{"$nulls":3},542822,46095,1037,43.208333333333336,388.875]
["2020-02-05T07:57:00",587880,{"$nulls":3},542822,45058,611,25.458333333333332,229.125]
["2020-02-04T05:54:00",587269,{"$nulls":3},542822,44447,-5079489,-211645.375,-1904808.375]
["2020-02-03T06:26:00",5666758,{"$nulls":3},542822,5123936,5080681,211695.04166666666,1905255.375]
["2020-02-02T06:38:00",586077,{"$nulls":3},542822,43255,611,25.458333333333332,229.125]
["2020-02-01T06:03:00",585466,{"$nulls":3},542822,42644,622,25.916666666666668,233.25]
["2020-01-31T06:42:00",584844,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":542822},42022,564,23.5,211.5]
["2020-01-30T07:07:00",584280,{"$nulls":3},542822,41458,590,24.583333333333332,221.25]
["2020-01-29T06:13:00",583690,{"$nulls":3},542822,40868,573.4000000000233,23.891666666667636,215.02500000000873]
["2020-01-28T06:41:00",583116.6,{"$nulls":3},542822,40294.59999999998,1672.5999999999767,69.6916666666657,627.2249999999913]
["2020-01-25T07:56:00",581444,{"$nulls":3},542822,38622,1579,65.79166666666667,592.125]
["2020-01-22T05:44:00",579865,{"$nulls":3},542822,37043,490,20.416666666666668,183.75]
["2020-01-21T05:41:00",579375,{"$nulls":3},542822,36553,992,41.333333333333336,372]
["2020-01-19T06:29:00",578383,{"$nulls":3},542822,35561,1129,47.041666666666664,423.375]
["2020-01-17T06:54:00",577254,{"$nulls":3},542822,34432,595,24.791666666666668,223.125]
["2020-01-16T06:23:00",576659,{"$nulls":3},542822,33837,1240,51.666666666666664,465]
["2020-01-14T06:38:00",575419,{"$nulls":3},542822,32597,583,24.291666666666668,218.625]
["2020-01-13T07:51:00",574836,{"$nulls":3},542822,32014,574836,23951.5,215563.5]
["2020-01-12T08:49:00",0,{"$nulls":3},542822,-542822,-3.550000000046566,-0.14791666666860692,-1.3312500000174623]
["2020-01-09T05:46:00",3.55,{"$nulls":3},542822,-542818.45,-571995.45,-23833.14375,-214498.29374999998]
["2020-01-08T06:45:00",571999,{"$nulls":3},542822,29177,570,23.75,213.75]
["2020-01-07T06:41:00",571429,{"$nulls":3},542822,28607,529,22.041666666666668,198.375]
["2020-01-06T07:22:00",570900,{"$nulls":3},542822,28078,519,21.625,194.625]
["2020-01-05T06:46:00",570381,{"$nulls":3},542822,27559,556,23.166666666666668,208.5]
["2020-01-04T06:22:00",569825,{"$nulls":3},542822,27003,547,22.791666666666668,205.125]
["2020-01-03T07:30:00",569278,{"$nulls":3},542822,26456,562,23.416666666666668,210.75]
["2020-01-02T07:33:00",568716,{"$nulls":3},542822,25894,1109,46.208333333333336,415.875]
["2019-12-31T06:32:00",567607,{"$nulls":3},542822,24785,523,21.791666666666668,196.125]
["2019-12-30T06:26:00",567084,{"$nulls":3},542822,24262,578,24.083333333333332,216.75]
["2019-12-29T06:01:00",566506,{"$nulls":3},542822,23684,535,22.291666666666668,200.625]
["2019-12-28T07:25:00",565971,{"$nulls":3},542822,23149,600.5999999999767,25.02499999999903,225.22499999999127]
["2019-12-27T06:40:00",565370.4,{"$nulls":3},542822,22548.400000000023,577.4000000000233,24.058333333334303,216.52500000000873]
["2019-12-26T06:39:00",564793,{"$nulls":3},542822,21971,640,26.666666666666668,240]
["2019-12-25T05:22:00",564153,{"$nulls":3},542822,21331,989,41.208333333333336,370.875]
["2019-12-23T06:23:00",563164,{"$nulls":3},542822,20342,571,23.791666666666668,214.125]
["2019-12-22T05:57:00",562593,{"$nulls":3},542822,19771,552,23,207]
["2019-12-21T06:01:00",562041,{"$nulls":3},542822,19219,549,22.875,205.875]
["2019-12-20T06:33:00",561492,{"$nulls":3},542822,18670,550,22.916666666666668,206.25]
["2019-12-19T06:03:00",560942,{"$nulls":3},{"$f":"VLOOKUP($E$2,A:B,2,)","v":542822},18120,2052,85.5,769.5]
["2019-12-15T06:34:00",558890,{"$nulls":3},542822,{"$f":"B67-F67","v":16068},{"$f":"G67-G68","v":1074},{"$f":"H67/24","v":44.75},{"$f":"I67*9","v":402.75}]
["2019-12-13T06:56:00",557816,{"$nulls":3},542822,14994,1019,42.458333333333336,382.125]
["2019-12-11T06:17:00",556797,{"$nulls":3},542822,13975,1912,79.66666666666667,717]
["2019-12-07T06:38:00",554885,{"$nulls":3},542822,12063,869,36.208333333333336,325.875]
["2019-12-05T07:48:00",554016,{"$nulls":3},542822,11194,479,19.958333333333332,179.625]
["2019-12-04T06:10:00",553537,{"$nulls":3},542822,10715,436,18.166666666666668,163.5]
["2019-12-03T06:34:00",553101,{"$nulls":3},542822,10279,421,17.541666666666668,157.875]
["2019-12-02T07:32:00",552680,{"$nulls":3},542822,9858,0,0,0]
["2019-12-02T07:32:00",552680,{"$nulls":3},542822,9858,509,21.208333333333332,190.875]
["2019-12-01T06:41:00",552171,{"$nulls":3},542822,9349,479,19.958333333333332,179.625]
["2019-11-30T08:33:00",551692,{"$nulls":3},542822,8870,519,21.625,194.625]
["2019-11-29T07:58:00",551173,{"$nulls":3},542822,8351,590,24.583333333333332,221.25]
["2019-11-28T05:54:00",550583,{"$nulls":3},542822,7761,545,22.708333333333332,204.375]
["2019-11-27T07:07:00",550038,{"$nulls":3},542822,7216,1110,46.25,416.25]
["2019-11-25T06:08:00",548928,{"$nulls":3},542822,6106,502,20.916666666666668,188.25]
["2019-11-24T06:48:00",548426,{"$nulls":3},542822,5604,563,23.458333333333332,211.125]
["2019-11-23T06:34:00",547863,{"$nulls":3},542822,5041,536,22.333333333333332,201]
["2019-11-22T06:46:00",547327,{"$nulls":3},542822,4505,486,20.25,182.25]
["2019-11-21T06:59:00",546841,{"$nulls":3},542822,4019,504,21,189]
["2019-11-20T07:35:00",546337,{"$nulls":3},542822,3515,456,19,171]
["2019-11-19T08:32:00",545881,{"$nulls":3},542822,3059,516,21.5,193.5]
["2019-11-18T06:02:00",545365,{"$nulls":3},542822,2543,488.5,20.354166666666668,183.1875]
["2019-11-17T05:56:00",544876.5,{"$nulls":3},542822,2054.5,469.5,19.5625,176.0625]
["2019-11-16T07:22:00",544407,{"$nulls":3},542822,1585,513,21.375,192.375]
["2019-11-15T06:58:00",543894,{"$nulls":3},542822,1072,504,21,189]
["2019-11-14T11:11:00",543390,{"$nulls":3},542822,568,568,23.666666666666668,213]
["2019-11-13T09:16:00",542822,{"$nulls":3},542822,0,{"$f":"G93-#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]