{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":0,"comments":1,"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":"Лист1","index":0,"n_rows":126,"n_cols":22,"rows_kept":126,"cut":false,"hidden":false,"merged":[[87,12,87,19],[47,3,48,3],[47,8,47,10],[47,11,47,12],[68,3,69,3],[68,8,68,10],[68,11,68,12],[5,3,6,3],[5,8,5,10],[5,11,5,12],[26,3,27,3],[26,8,26,10],[26,11,26,12],[24,12,24,16],[89,8,89,10],[89,11,89,12],[110,3,111,3],[110,8,110,10],[110,11,110,12],[89,3,90,3]]}
[null,null,null,"время вкл. Нагрева",{"$f":"IF(ISNA(VLOOKUP(D8,[1]Jun!$H:$I,2,0)),\"\",VLOOKUP(D8,[1]Jun!$H:$I,2,0))","v":"01:30"}]
[null,null,null,"время вкл. Эл-ра",{"$f":"IF(ISNA(VLOOKUP(D8,[1]Jun!$H:$J,3,0)),\"\",VLOOKUP(D8,[1]Jun!$H:$J,3,0))","v":"03:00"},null,{"$f":"D8","v":42385.8}]
[null,null,null,"время остановки "]
[null,null,null,"Дата","2024-06-01","Цикл №",1,null,null,"NaOH",null,{"$f":"VLOOKUP2caind([2]Jun!$A$1:$G$10000,1,\"NaOH/1\",COUNTIF($E$3:E4,E4),7,E4,[2]Jun!$K$1:$K$10000)","v":22},null,"Вот тут всё правильно пишет.",null,null,null,22,"то что должно",null,null,{"$f":"COUNTIF($E$3:E4,E4)","v":1}]
[]
[null,null,null,"Показания сумматора","проток",null,"Au, мг/л",null,"Ag, мг/л",null,null,"Извлечение, %"]
[null,null,null,null,null,"вход","выход","Осаждено, Гр","вход","выход","Осаждено, Гр","Au","Ag"]
[null,{"$f":"IF($E$2=\"\",\"\",E2)","v":"03:00"},0,{"$f":"IFERROR(VLOOKUP(G4&\"/1 \"&C8&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42385.8},null,null,null,{"$f":"IFERROR((F8-G8)*E8,\"\")","v":0},null,null,{"$f":"IFERROR((I8-J8)*E8,\"\")","v":0},{"$f":"IFERROR((F8-G8)/F8*100,\"\")","v":""},{"$f":"IFERROR((I8-J8)/I8*100,\"\")","v":""}]
[null,{"$f":"IF(D9=\"\",\"\",IFERROR(B8+1/24,\"\"))","v":"04:00:00"},1,{"$f":"IFERROR(VLOOKUP(G4&\"/1 \"&C9&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42389.599999999999},{"$f":"IF(D9=\"\",\"\",D9-D8)","v":3.7999999999956344},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C9&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":47.876399999999997},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C9&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":31.212029999999999},63.324605999927243,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C9&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":13.32052},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C9&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":9.9520099999999996},12.800337999985297,{"$f":"IFERROR((F9-G9)/F9*100,\"\")","v":34.807065694162468},{"$f":"IFERROR((I9-J9)/I9*100,\"\")","v":25.288126889941235}]
[null,{"$f":"IF(D10=\"\",\"\",IFERROR(B9+1/24,\"\"))","v":"05:00:00"},2,{"$f":"IFERROR(VLOOKUP(G4&\"/1 \"&C10&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42392.95},3.3499999999985448,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C10&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":82.735330000000005},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C10&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":41.778480000000002},137.20544749994042,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C10&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":18.76906},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C10&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":8.82456},33.314074999985529,49.503458800490677,52.983473866032718]
[null,"06:00:00",3,{"$f":"IFERROR(VLOOKUP(G4&\"/1 \"&C11&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42396.23},3.2800000000061118,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C11&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":89.175470000000004},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C11&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":45.433799999999998},143.47267760026736,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C11&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":17.039580000000001},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C11&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":8.1149100000000001},29.272917600054548,49.051235726596119,52.376114904240602]
[null,"07:00:00",4,{"$f":"IFERROR(VLOOKUP(G4&\"/1 \"&$C12&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42399.68},3.4499999999970896,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C12&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":103.36799999999999},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C12&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":47.105670000000003},194.10503849983621,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C12&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":14.569839999999999},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C12&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":7.0095099999999997},26.083138499977995,54.429156025075457,51.890274704457973]
[null,"08:00:00",5,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&C13&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42403.26},3.5800000000017462,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C13&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":104.497},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C13&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":36.119030000000002},244.79313260011943,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C13&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":10.90123},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C13&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":3.9323600000000001},24.948554600012169,65.435342641415545,63.927373333100945]
[null,"09:00:00",6,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C14&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42406.61},3.3499999999985448,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C14&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":88.922060000000002},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C14&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":33.229179999999999},186.57114799991896,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C14&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":6.7657600000000002},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C14&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":2.9938899999999999},12.635764499994512,62.631117632677423,55.749391051411813]
[null,"10:00:00",7,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C15&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42409.93},{"$f":"IF(D15=\"\",\"\",D15-D14)","v":3.319999999999709},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C15&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":78.269580000000005},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C15&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":29.16854},163.01545279998572,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C15&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":3.5871},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C15&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":1.28159},7.6542931999993291,62.733235568658984,64.27225335229015]
[null,"11:00:00",8,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C16&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42413.39},{"$f":"IF(D16=\"\",\"\",D16-D15)","v":3.4599999999991269},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C16&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":59.099269999999997},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C16&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":24.654019999999999},119.18056499996993,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C16&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.96192},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C16&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0.48120000000000002},1.6632911999995803,58.283714841147791,49.9750499001996]
[null,"12:00:00",9,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C17&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42416.91},{"$f":"IF(D17=\"\",\"\",D17-D16)","v":3.5200000000040745},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C17&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":47.038379999999997},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C17&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":17.11459},105.33174080012192,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C17&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.83494000000000002},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C17&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0.37108000000000002},1.6327872000018899,63.615689996126569,55.556087862600897]
[null,"13:00:00",10,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C18&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42420.35},3.4399999999950523,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C18&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":39.499630000000003},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C18&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":16.13663},80.368719999884419,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C18&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.27165},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C18&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0},0.93447599999865594,59.147389481876168,100]
[null,"14:00:00",11,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C19&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42423.82},3.4700000000011642,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C19&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":30.462890000000002},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C19&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":15.11192},53.267865900017881,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C19&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.41000999999999999},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C19&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0},1.4227347000004773,50.392362641889854,100]
[null,"15:00:00",12,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C20&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42427.53},3.7099999999991269,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C20&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":30.517389999999999},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C20&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":15.08001},57.27267979998652,{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C20&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.14637},{"$f":"IFERROR(VLOOKUP($G$4&\"/1 \"&$C20&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0},0.54303269999987225,50.585518617417804,100]
[null,null,null,null,null,null,null,{"$f":"SUM(H8:H20)","v":1547.9090744999758},null,null,{"$f":"SUM(K8:K20)","v":152.90540320000989}]
[null,null,null,"время вкл. Нагрева",{"$f":"IF(ISNA(VLOOKUP(D29,[1]Jun!$H:$I,2,0)),\"\",VLOOKUP(D29,[1]Jun!$H:$I,2,0))","v":"16:40"}]
[null,null,null,"время вкл. Эл-ра",{"$f":"IF(ISNA(VLOOKUP(D29,[1]Jun!$H:$J,3,0)),\"\",VLOOKUP(D29,[1]Jun!$H:$J,3,0))","v":"18:00"},null,{"$f":"D29","v":42435.49}]
[null,null,null,"время остановки "]
[null,null,null,"Дата",{"$f":"IF(E23=\"\",\"\",IF(E23<=INDEX(E:E,MAX(IF(D$1:D22=\"время вкл. Эл-ра\",ROW(D$1:D22)))),1,0)+INDEX(E:E,MAX(IF(D$1:D24=\"Дата\",ROW(D$1:D24)))))","v":"2024-06-01"},"Цикл №",{"$f":"G4+1","v":2},null,null,"NaOH, г/л",null,{"$f":"VLOOKUP2caind([2]Jun!$A$1:$G$10000,1,\"NaOH/1\",COUNTIF($E$3:E25,E25),7,E25,[2]Jun!$K$1:$K$10000)","v":18},"Здесь  ставит тоже самое число ",null,null,null,null,18,"то что должно"]
[]
[null,null,null,"Показания сумматора","проток",null,"Au, мг/л",null,"Ag, мг/л",null,null,"Извлечение, %"]
[null,null,null,null,null,"вход","выход","Осаждено, Гр","вход","выход","Осаждено, Гр","Au","Ag"]
[null,{"$f":"IF($E$23=\"\",\"\",E23)","v":"18:00"},0,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C29&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42435.49},null,null,null,{"$f":"IFERROR((F29-G29)*E29,\"\")","v":0},null,null,{"$f":"IFERROR((I29-J29)*E29,\"\")","v":0},{"$f":"IFERROR((F29-G29)/F29*100,\"\")","v":""},{"$f":"IFERROR((I29-J29)/I29*100,\"\")","v":""}]
[null,{"$f":"IF(D30=\"\",\"\",IFERROR(B29+1/24,\"\"))","v":"19:00:00"},1,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C30&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42439.17},{"$f":"IF(D30=\"\",\"\",D30-D29)","v":3.680000000000291},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C30&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":67.491320000000002},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C30&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":31.8689},131.09050560001037,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C30&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":18.277740000000001},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C30&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":8.4147499999999997},36.295803200002879,{"$f":"IFERROR((F30-G30)/F30*100,\"\")","v":52.780742768107082},{"$f":"IFERROR((I30-J30)/I30*100,\"\")","v":53.961758948316373}]
[null,{"$f":"IF(D31=\"\",\"\",IFERROR(B30+1/24,\"\"))","v":"20:00:00"},2,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C31&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42442.64},3.4700000000011642,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C31&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":96.351849999999999},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C31&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":37.085839999999997},205.65305470006899,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C31&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":21.35491},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C31&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":5.9650100000000004},53.402953000017916,61.509986575244788,72.067266965770401]
[null,"21:00:00",3,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C32&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42445.97},3.3300000000017462,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C32&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":105.816},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C32&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":39.36101},221.29511670011607,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C32&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":18.337199999999999},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C32&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":6.1431500000000003},40.606186500021288,62.802402283208593,{"$f":"IFERROR((I32-J32)/I32*100,\"\")","v":66.498974761686625}]
[null,"22:00:00",4,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C33&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42449.42},3.4499999999970896,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C33&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":96.340710000000001},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C33&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":36.6858},205.8094394998264,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C33&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":15.55963},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C33&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":5.5555500000000002},34.514075999970885,61.920770565215889,{"$f":"IFERROR((I33-J33)/I33*100,\"\")","v":64.29510213289133}]
[null,"23:00:00",5,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C34&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42452.87},3.4500000000043656,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C34&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":80.092309999999998},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C34&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":30.165590000000002},172.24718400021794,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C34&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":8.4839599999999997},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C34&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":3.1445799999999999},18.420861000023312,62.336471503943379,{"$f":"IFERROR((I34-J34)/I34*100,\"\")","v":62.934997336149635}]
[null,0.99999999999999978,6,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C35&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42456.27},3.3999999999941792,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C35&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":73.533950000000004},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C35&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":21.044},178.46582999969451,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C35&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":6.2688899999999999},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C35&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":2.2527699999999999},13.654807999976622,71.381926307508309,64.064292083606517]
[null,1.0416666666666665,7,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C36&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42460},{"$f":"IF(D36=\"\",\"\",D36-D35)","v":3.7300000000032014},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C36&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":61.276940000000003},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C36&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":21.76634},{"$f":"IFERROR((F36-G36)*E36,\"\")","v":147.37453800012651},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C36&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":2.6746099999999999},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C36&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":1.7517199999999999},3.4423797000029546,64.478741921512409,34.505591469410497]
[null,1.0833333333333333,8,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C37&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42463.32},{"$f":"IF(D37=\"\",\"\",D37-D36)","v":3.319999999999709},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C37&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":51.047150000000002},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C37&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":17.227679999999999},{"$f":"IFERROR((F37-G37)*E37,\"\")","v":112.28064039999016},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C37&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":2.0162399999999998},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C37&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0.79483999999999999},4.055047999999644,66.251436172244681,60.578105781057815]
[null,1.125,9,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C38&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42466.77},{"$f":"IF(D38=\"\",\"\",D38-D37)","v":3.4499999999970896},{"$f":"IFERROR(VLOOKUP(G$25&\"/1 \"&$C38&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":47.197369999999999},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C38&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":14.19661},113.85262199990396,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C38&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":1.1757500000000001},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C38&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0},4.0563374999965784,69.920760415251948,100]
[null,1.1666666666666667,10,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C39&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42470.01},3.2400000000052387,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C39&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":36.306849999999997},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C39&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":12.98188},75.572902800122179,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C39&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":1.07829},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C39&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0.76987000000000005},0.99928080000161545,64.243992524826581,28.602695007836477]
[null,1.2083333333333335,11,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C40&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42473.59},3.5799999999944703,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C40&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":27.501349999999999},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C40&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":10.753640000000001},59.956801799907382,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C40&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.82403999999999999},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C40&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0},2.9500631999954434,60.897774109270998,100]
[null,1.2500000000000002,12,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C41&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42476.88},3.2900000000008731,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C41&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":25.011340000000001},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C41&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":8.4240899999999996},54.572052500014486,{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C41&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.27039000000000002},{"$f":"IFERROR(VLOOKUP(G25&\"/1 \"&$C41&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0.14668},0.40700590000010806,66.318917738913626,45.752431672768964]
[null,null,null,null,null,null,null,{"$f":"SUM(H29:H41)","v":1678.170687999999},null,null,{"$f":"SUM(K29:K41)","v":212.80480280000924}]
[null,null,null,"время вкл. Нагрева",{"$f":"IF(ISNA(VLOOKUP(D50,[1]Jun!$H:$I,2,0)),\"\",VLOOKUP(D50,[1]Jun!$H:$I,2,0))","v":"07:40"}]
[null,null,null,"время вкл. Эл-ра",{"$f":"IF(ISNA(VLOOKUP(D50,[1]Jun!$H:$J,3,0)),\"\",VLOOKUP(D50,[1]Jun!$H:$J,3,0))","v":"09:00"},null,{"$f":"D50","v":42484.9}]
[null,null,null,"время остановки "]
[null,null,null,"Дата",{"$f":"IF(E44=\"\",\"\",IF(E44<=INDEX(E:E,MAX(IF(D$1:D43=\"время вкл. Эл-ра\",ROW(D$1:D43)))),1,0)+INDEX(E:E,MAX(IF(D$1:D45=\"Дата\",ROW(D$1:D45)))))","v":"2024-06-02"},"Цикл №",3,null,null,"NaOH, г/л",null,{"$f":"VLOOKUP2caind([2]Jun!$A$1:$G$10000,1,\"NaOH/1\",COUNTIF($E$3:E46,E46),7,E46,[2]Jun!$K$1:$K$10000)","v":""},null,"Тут не пишет ничего.",null,"потому что да за 02.06 нет данных NaOH/1"]
[]
[null,null,null,"Показания сумматора","проток",null,"Au, мг/л",null,"Ag, мг/л",null,null,"Извлечение, %"]
[null,null,null,null,null,"вход","выход","Осаждено, Гр","вход","выход","Осаждено, Гр","Au","Ag"]
[null,{"$f":"IF($E$44=\"\",\"\",E44)","v":"09:00"},0,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C50&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42484.9},null,null,null,{"$f":"IFERROR((F50-G50)*E50,\"\")","v":0},null,null,{"$f":"IFERROR((I50-J50)*E50,\"\")","v":0},{"$f":"IFERROR((F50-G50)/F50*100,\"\")","v":""},{"$f":"IFERROR((I50-J50)/I50*100,\"\")","v":""}]
[null,{"$f":"IF(D51=\"\",\"\",IFERROR(B50+1/24,\"\"))","v":"10:00:00"},1,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C51&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42488.38},{"$f":"IF(D51=\"\",\"\",D51-D50)","v":3.4799999999959255},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C51&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":36.948129999999999},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C51&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":24.927299999999999},41.832488399951018,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C51&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":11.17848},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C51&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":4.6420399999999997},22.746811199973369,{"$f":"IFERROR((F51-G51)/F51*100,\"\")","v":32.534339356281365},{"$f":"IFERROR((I51-J51)/I51*100,\"\")","v":58.473423935991299}]
[null,{"$f":"IF(D52=\"\",\"\",IFERROR(B51+1/24,\"\"))","v":"11:00:00"},2,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C52&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42491.94},3.5600000000049477,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C52&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":68.140640000000005},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C52&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":33.947879999999998},121.7262256001692,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C52&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":16.615559999999999},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C52&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":6.1266600000000002},37.340484000051887,50.179687188144996,63.126972548623087]
[null,"12:00:00",3,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C53&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42495.54},3.5999999999985448,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C53&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":86.250960000000006},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C53&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":42.943980000000003},155.90512799993698,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C53&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":16.25986},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C53&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":7.8751800000000003},30.184847999987795,50.210432440404141,{"$f":"IFERROR((I53-J53)/I53*100,\"\")","v":51.566741657062231}]
[null,"13:00:00",4,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C54&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42499.1},3.5599999999976717,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C54&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":71.639259999999993},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C54&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":45.503030000000003},93.044978799939116,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C54&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":10.790990000000001},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C54&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":6.3970200000000004},15.642533199989771,36.483109959538936,{"$f":"IFERROR((I54-J54)/I54*100,\"\")","v":40.718877507995103}]
[null,"14:00:00",5,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C55&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42502.65},3.5500000000029104,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C55&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":69.290840000000003},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C55&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":36.33137},117.00611850009594,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C55&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":8.5195799999999995},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C55&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":4.4785399999999997},14.345692000011761,47.566850106016901,{"$f":"IFERROR((I55-J55)/I55*100,\"\")","v":47.432385164526892}]
[null,"15:00:00",6,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C56&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42506.16},3.5100000000020373,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C56&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":59.163319999999999},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C56&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":30.250389999999999},101.48438430005891,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C56&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":4.7066400000000002},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C56&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":3.0813000000000001},5.7049434000033115,48.869688178418656,34.532915200652695]
[null,"16:00:00",7,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C57&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42509.760000000002},{"$f":"IF(D57=\"\",\"\",D57-D56)","v":3.5999999999985448},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C57&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":63.923439999999999},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C57&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":31.264859999999999},{"$f":"IFERROR((F57-G57)*E57,\"\")","v":117.57088799995248},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C57&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":4.2724799999999998},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C57&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":2.4138999999999999},6.6908879999972948,51.090147839352831,43.50119836722466]
[null,"17:00:00",8,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C58&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42513.32},{"$f":"IF(D58=\"\",\"\",D58-D57)","v":3.5599999999976717},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C58&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":59.153219999999997},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C58&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":26.05714},{"$f":"IFERROR((F58-G58)*E58,\"\")","v":117.82204479992295},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C58&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":2.1937199999999999},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C58&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":1.8707400000000001},1.1498087999992475,55.949752185933413,14.722936382035986]
[null,"18:00:00",9,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C59&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42517.03},{"$f":"IF(D59=\"\",\"\",D59-D58)","v":3.7099999999991269},{"$f":"IFERROR(VLOOKUP(G$46&\"/1 \"&$C59&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":50.130830000000003},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C59&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":21.200099999999999},107.33300829997475,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C59&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":1.8238300000000001},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C59&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":1.39696},1.5836876999996277,57.710454823907767,23.405141926605005]
[null,"19:00:00",10,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C60&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42520.51},3.4800000000032014,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C60&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":44.349609999999998},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C60&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":19.27169},87.271161600080276,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C60&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":1.38686},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C60&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0.43953999999999999},3.2966736000030328,56.54597639077322,68.306822606463513]
[null,"20:00:00",11,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C61&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42523.89},3.3799999999973807,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C61&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":41.896050000000002},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C61&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":15.040480000000001},90.771826599929653,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C61&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":1.61497},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C61&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":1.1854800000000001},1.4516761999988748,64.100482026348544,26.594302061338599]
[null,"21:00:00",12,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C62&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42527.26},3.3700000000026193,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C62&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":35.98977},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C62&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":13.511480000000001},75.751837300058881,{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C62&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.83718999999999999},{"$f":"IFERROR(VLOOKUP(G46&\"/1 \"&$C62&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0},2.821330300002193,62.457442767764292,100]
[null,null,null,null,null,null,null,{"$f":"SUM(H50:H62)","v":1227.5200902000702},null,null,{"$f":"SUM(K50:K62)","v":142.95937640001816}]
[null,null,null,"время вкл. Нагрева",{"$f":"IF(ISNA(VLOOKUP(D71,[1]Jun!$H:$I,2,0)),\"\",VLOOKUP(D71,[1]Jun!$H:$I,2,0))","v":"22:30"}]
[null,null,null,"время вкл. Эл-ра",{"$f":"IF(ISNA(VLOOKUP(D71,[1]Jun!$H:$J,3,0)),\"\",VLOOKUP(D71,[1]Jun!$H:$J,3,0))","v":"00:00"},null,{"$f":"D71","v":42535.74}]
[null,null,null,"время остановки "]
[null,null,null,"Дата",{"$f":"IF(E65=\"\",\"\",IF(E65<=INDEX(E:E,MAX(IF(D$1:D64=\"время вкл. Эл-ра\",ROW(D$1:D64)))),1,0)+INDEX(E:E,MAX(IF(D$1:D66=\"Дата\",ROW(D$1:D66)))))","v":"2024-06-03"},"Цикл №",{"$f":"G46+1","v":4},null,null,"NaOH, г/л",null,{"$f":"VLOOKUP2caind([2]Jun!$A$1:$G$10000,1,\"NaOH/1\",COUNTIF($E$3:E67,E67),7,E67,[2]Jun!$K$1:$K$10000)","v":21},null,"верно"]
[]
[null,null,null,"Показания сумматора","проток",null,"Au, мг/л",null,"Ag, мг/л",null,null,"Извлечение, %"]
[null,null,null,null,null,"вход","выход","Осаждено, Гр","вход","выход","Осаждено, Гр","Au","Ag"]
[null,{"$f":"IF($E$65=\"\",\"\",E65)","v":"00:00"},0,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C71&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42535.74},null,null,null,{"$f":"IFERROR((F71-G71)*E71,\"\")","v":0},null,null,{"$f":"IFERROR((I71-J71)*E71,\"\")","v":0},{"$f":"IFERROR((F71-G71)/F71*100,\"\")","v":""},{"$f":"IFERROR((I71-J71)/I71*100,\"\")","v":""}]
[null,{"$f":"IF(D72=\"\",\"\",IFERROR(B71+1/24,\"\"))","v":"01:00:00"},1,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C72&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42539.040000000001},{"$f":"IF(D72=\"\",\"\",D72-D71)","v":3.3000000000029104},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C72&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":59.9283},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C72&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":28.705179999999999},103.03629600009087,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C72&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":15.34149},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C72&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":7.9199599999999997},24.491049000021601,{"$f":"IFERROR((F72-G72)/F72*100,\"\")","v":52.100793781902709},{"$f":"IFERROR((I72-J72)/I72*100,\"\")","v":48.375548919954973}]
[null,{"$f":"IF(D73=\"\",\"\",IFERROR(B72+1/24,\"\"))","v":"02:00:00"},2,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C73&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42542.61},3.569999999999709,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C73&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":89.92671},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C73&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":45.645519999999998},158.08384829998712,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C73&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":20.068010000000001},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C73&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":9.2333200000000009},38.679843299996847,49.241421152847693,53.989857489606599]
[null,"03:00:00",3,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C74&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42546.11},3.5,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C74&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":105.901},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C74&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":49.129910000000002},198.69881499999997,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C74&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":16.685690000000001},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C74&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":7.9556399999999998},30.555175000000006,53.607699644007134,{"$f":"IFERROR((I74-J74)/I74*100,\"\")","v":52.320581288517296}]
[null,"04:00:00",4,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C75&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42549.62},3.5100000000020373,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C75&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":96.519729999999996},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C75&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":34.951360000000001},216.1049787001254,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C75&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":12.00536},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C75&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":6.1950200000000004},20.394293400011833,63.788377775196835,{"$f":"IFERROR((I75-J75)/I75*100,\"\")","v":48.397882279248599}]
[null,"05:00:00",5,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C76&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42553.21},3.5899999999965075,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C76&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":76.895359999999997},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C76&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":31.498940000000001},162.97314779984143,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C76&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":6.0780700000000003},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C76&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":5.2566100000000002},2.9490413999971312,59.036618074224499,{"$f":"IFERROR((I76-J76)/I76*100,\"\")","v":13.515145432678466}]
[null,"06:00:00",6,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C77&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42556.54},3.3300000000017462,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C77&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":58.462319999999998},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C77&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":27.916730000000001},101.71681470005333,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C77&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":3.8468900000000001},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C77&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":1.5836300000000001},7.5366558000039516,52.248337048546823,58.833499268240054]
[null,"07:00:00",7,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C78&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42560.01},{"$f":"IF(D78=\"\",\"\",D78-D77)","v":3.4700000000011642},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C78&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":42.447479999999999},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C78&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":22.837440000000001},{"$f":"IFERROR((F78-G78)*E78,\"\")","v":68.046838800022826},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C78&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":1.1104700000000001},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C78&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0.89988000000000001},0.73074730000024535,46.198360892095359,18.964042252379627]
[null,"08:00:00",8,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C79&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42563.43},{"$f":"IF(D79=\"\",\"\",D79-D78)","v":3.4199999999982538},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C79&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":43.124699999999997},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C79&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":18.716699999999999},{"$f":"IFERROR((F79-G79)*E79,\"\")","v":83.475359999957377},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C79&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":1.2437199999999999},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C79&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0.96067000000000002},0.96803099999950548,56.598654599336342,22.758337889557129]
[null,"09:00:00",9,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C80&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42566.92},{"$f":"IF(D80=\"\",\"\",D80-D79)","v":3.4899999999979627},{"$f":"IFERROR(VLOOKUP(G$67&\"/1 \"&$C80&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":43.67163},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C80&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":15.485889999999999},98.368232599942587,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C80&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.38736999999999999},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C80&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0},1.3519212999992107,64.540160282544988,100]
[null,"10:00:00",10,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C81&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42570.400000000001},3.4800000000032014,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C81&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":40.269559999999998},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C81&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":12.124000000000001},97.946548800090099,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C81&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.33904000000000001},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C81&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0.31342999999999999},8.9122800000082061E-2,69.892891802145343,7.5536809815950985]
[null,"11:00:00",11,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C82&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42573.79},3.3899999999994179,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C82&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":24.32544},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C82&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":11.32996},44.05467719999244,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C82&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.24464},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C82&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0},0.82932959999985756,53.423411868397864,100]
[null,"12:00:00",12,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C83&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42577.17},3.3799999999973807,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C83&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":27.802140000000001},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C83&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":9.3682700000000008},62.306480599951712,{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C83&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.29996},{"$f":"IFERROR(VLOOKUP(G67&\"/1 \"&$C83&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0.27934999999999999},6.9661799999946067E-2,66.303780931971417,6.8709161221496258]
[null,null,null,null,null,null,null,{"$f":"SUM(H71:H83)","v":1394.8120385000552},null,null,{"$f":"SUM(K71:K83)","v":128.64487170003022}]
[null,null,null,"время вкл. Нагрева",{"$f":"IF(ISNA(VLOOKUP(D92,[1]Jun!$H:$I,2,0)),\"\",VLOOKUP(D92,[1]Jun!$H:$I,2,0))","v":"13:40"}]
[null,null,null,"время вкл. Эл-ра",{"$f":"IF(ISNA(VLOOKUP(D92,[1]Jun!$H:$J,3,0)),\"\",VLOOKUP(D92,[1]Jun!$H:$J,3,0))","v":"15:00"},null,{"$f":"D92","v":42585.45}]
[null,null,null,"время остановки "]
[null,null,null,"Дата",{"$f":"IF(E86=\"\",\"\",IF(E86<=INDEX(E:E,MAX(IF(D$1:D85=\"время вкл. Эл-ра\",ROW(D$1:D85)))),1,0)+INDEX(E:E,MAX(IF(D$1:D87=\"Дата\",ROW(D$1:D87)))))","v":"2024-06-03"},"Цикл №",5,null,null,"NaOH, г/л",null,{"$f":"VLOOKUP2caind([2]Jun!$A$1:$G$10000,1,\"NaOH/1\",COUNTIF($E$3:E88,E88),7,E88,[2]Jun!$K$1:$K$10000)","v":19},"не верно  ставит тот же результат а должен второе число ставить ",null,null,null,null,null,null,null,19]
[]
[null,null,null,"Показания сумматора","проток",null,"Au, мг/л",null,"Ag, мг/л",null,null,"Извлечение, %"]
[null,null,null,null,null,"вход","выход","Осаждено, Гр","вход","выход","Осаждено, Гр","Au","Ag"]
[null,{"$f":"IF($E$86=\"\",\"\",E86)","v":"15:00"},0,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C92&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42585.45},null,null,null,{"$f":"IFERROR((F92-G92)*E92,\"\")","v":0},null,null,{"$f":"IFERROR((I92-J92)*E92,\"\")","v":0},{"$f":"IFERROR((F92-G92)/F92*100,\"\")","v":""},{"$f":"IFERROR((I92-J92)/I92*100,\"\")","v":""}]
[null,{"$f":"IF(D93=\"\",\"\",IFERROR(B92+1/24,\"\"))","v":"16:00:00"},1,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C93&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42588.82},{"$f":"IF(D93=\"\",\"\",D93-D92)","v":3.3700000000026193},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C93&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":54.29927},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C93&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":31.1785},77.916994900060558,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C93&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":12.628550000000001},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C93&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":6.2255000000000003},21.578278500016772,{"$f":"IFERROR((F93-G93)/F93*100,\"\")","v":42.580259366286136},{"$f":"IFERROR((I93-J93)/I93*100,\"\")","v":50.702970649837077}]
[null,{"$f":"IF(D94=\"\",\"\",IFERROR(B93+1/24,\"\"))","v":"17:00:00"},2,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C94&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42592.31},3.4899999999979627,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C94&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":108.96},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C94&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":51.590350000000001},200.2200784998831,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C94&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":19.646159999999998},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C94&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":9.8792799999999996},34.086411199980098,52.652028267254039,49.713939008946269]
[null,"18:00:00",3,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C95&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42595.67},3.3600000000005821,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C95&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":109.988},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C95&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":44.286230000000003},220.75794720003822,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C95&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":17.436409999999999},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C95&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":7.1780299999999997},34.468156800005964,59.735398407098948,{"$f":"IFERROR((I95-J95)/I95*100,\"\")","v":58.833096950576405}]
[null,"19:00:00",4,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C96&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42599.19},3.5200000000040745,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C96&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":100.062},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C96&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":47.098179999999999},186.43264640021579,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C96&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":11.279870000000001},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C96&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":6.4385199999999996},17.041552000019731,52.931002778277467,{"$f":"IFERROR((I96-J96)/I96*100,\"\")","v":42.920264151980483}]
[null,"20:00:00",5,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C97&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42602.59},3.3999999999941792,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C97&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":83.826250000000002},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C97&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":32.84854},173.32421399970329,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C97&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":7.5912899999999999},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C97&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":5.1639299999999997},8.2530239999858708,60.813539911423931,{"$f":"IFERROR((I97-J97)/I97*100,\"\")","v":31.975593081017855}]
[null,"21:00:00",6,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C98&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42606.05},3.4600000000064028,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C98&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":72.764120000000005},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C98&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":27.93233},155.11799340028708,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C98&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":3.9923899999999999},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C98&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":3.97437},6.2349200000115117E-2,61.612495279266767,0.45135870994566973]
[null,"22:00:00",7,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C99&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42609.5},{"$f":"IF(D99=\"\",\"\",D99-D98)","v":3.4499999999970896},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C99&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":54.392020000000002},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C99&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":23.32695},{"$f":"IFERROR((F99-G99)*E99,\"\")","v":107.17449149990959},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C99&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":2.48062},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C99&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":1.9069799999999999},1.9790579999983311,57.113286103365901,23.124863945304003]
[null,"23:00:00",8,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C100&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42612.800000000003},{"$f":"IF(D100=\"\",\"\",D100-D99)","v":3.3000000000029104},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C100&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":50.849550000000001},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C100&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":20.571670000000001},{"$f":"IFERROR((F100-G100)*E100,\"\")","v":99.917004000088113},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C100&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":1.5839799999999999},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C100&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0.50436999999999999},3.5627130000031419,59.544047095795335,68.158057551231707]
[null,0.99999999999999967,9,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C101&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42616.34},{"$f":"IF(D101=\"\",\"\",D101-D100)","v":3.5399999999935972},{"$f":"IFERROR(VLOOKUP(G$88&\"/1 \"&$C101&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":39.813099999999999},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C101&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":15.270379999999999},86.881228799842859,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C101&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":1.69503},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C101&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0.84443000000000001},3.0111239999945538,61.644835493844994,50.182002678418669]
[null,1.0416666666666663,10,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C102&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42619.72},3.3800000000046566,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C102&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":40.086849999999998},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C102&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":12.37589},93.663044800129043,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C102&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":1.88788},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C102&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0},6.3810344000087911,69.127307333951165,100]
[null,1.083333333333333,11,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C103&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42623.05},3.3300000000017462,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C103&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":36.177599999999998},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C103&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":12.081659999999999},80.239480200042067,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C103&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.54932000000000003},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C103&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0.20941000000000001},1.1319003000005936,66.604584052010082,61.878322289375966]
[null,1.1249999999999998,12,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C104&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42626.3},3.25,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C104&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":28.650089999999999},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C104&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":6.9269800000000004},70.600107499999993,{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C104&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.79512000000000005},{"$f":"IFERROR(VLOOKUP(G88&\"/1 \"&$C104&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0},2.5841400000000001,75.822135288231209,100]
[null,null,null,null,null,null,null,{"$f":"SUM(H92:H104)","v":1552.2452312001997},null,null,{"$f":"SUM(K92:K104)","v":134.13974140001395}]
[null,null,null,"время вкл. Нагрева",{"$f":"IF(ISNA(VLOOKUP(D113,[1]Jun!$H:$I,2,0)),\"\",VLOOKUP(D113,[1]Jun!$H:$I,2,0))","v":"04:00"}]
[null,null,null,"время вкл. Эл-ра",{"$f":"IF(ISNA(VLOOKUP(D113,[1]Jun!$H:$J,3,0)),\"\",VLOOKUP(D113,[1]Jun!$H:$J,3,0))","v":"06:00"},null,{"$f":"D113","v":42634.15}]
[null,null,null,"время остановки "]
[null,null,null,"Дата",{"$f":"IF(E107=\"\",\"\",IF(E107<=INDEX(E:E,MAX(IF(D$1:D106=\"время вкл. Эл-ра\",ROW(D$1:D106)))),1,0)+INDEX(E:E,MAX(IF(D$1:D108=\"Дата\",ROW(D$1:D108)))))","v":"2024-06-04"},"Цикл №",{"$f":"G88+1","v":6},null,null,"NaOH, г/л",null,{"$f":"VLOOKUP2caind([2]Jun!$A$1:$G$10000,1,\"NaOH/1\",COUNTIF($E$3:E109,E109),7,E109,[2]Jun!$K$1:$K$10000)","v":22},null,"верно"]
[]
[null,null,null,"Показания сумматора","проток",null,"Au, мг/л",null,"Ag, мг/л",null,null,"Извлечение, %"]
[null,null,null,null,null,"вход","выход","Осаждено, Гр","вход","выход","Осаждено, Гр","Au","Ag"]
[null,{"$f":"IF($E$107=\"\",\"\",E107)","v":"06:00"},0,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C113&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42634.15},null,null,null,{"$f":"IFERROR((F113-G113)*E113,\"\")","v":0},null,null,{"$f":"IFERROR((I113-J113)*E113,\"\")","v":0},{"$f":"IFERROR((F113-G113)/F113*100,\"\")","v":""},{"$f":"IFERROR((I113-J113)/I113*100,\"\")","v":""}]
[null,{"$f":"IF(D114=\"\",\"\",IFERROR(B113+1/24,\"\"))","v":"07:00:00"},1,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C114&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42637.39},{"$f":"IF(D114=\"\",\"\",D114-D113)","v":3.2399999999979627},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C114&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":50.731110000000001},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C114&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":26.564170000000001},78.30088559995076,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C114&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":13.167479999999999},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C114&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":5.0968200000000001},26.148938399983557,{"$f":"IFERROR((F114-G114)/F114*100,\"\")","v":47.637317614379029},{"$f":"IFERROR((I114-J114)/I114*100,\"\")","v":61.292365737407614}]
[null,{"$f":"IF(D115=\"\",\"\",IFERROR(B114+1/24,\"\"))","v":"08:00:00"},2,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C115&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42640.73},3.3400000000037835,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C115&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":67.878010000000003},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C115&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":35.072510000000001},109.57037000012413,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C115&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":12.789110000000001},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C115&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":6.5742200000000004},20.757732600023516,48.330085104144921,48.595171986166356]
[null,"09:00:00",3,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C116&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42644.2},3.4699999999938882,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C116&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":74.870949999999993},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C116&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":45.608370000000001},101.54115259982113,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C116&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":9.5989799999999992},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C116&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":6.1139799999999997},12.092949999978698,39.084023910475288,{"$f":"IFERROR((I116-J116)/I116*100,\"\")","v":36.305940839547532}]
[null,"10:00:00",4,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C117&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42647.68},3.4800000000032014,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C117&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":73.831959999999995},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C117&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":38.81474},121.85992560011209,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C117&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":8.1611899999999995},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C117&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":4.0263400000000003},14.389278000013235,47.428268191715347,{"$f":"IFERROR((I117-J117)/I117*100,\"\")","v":50.664792756938624}]
[null,"11:00:00",5,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C118&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42651.19},3.5100000000020373,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C118&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":75.091260000000005},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C118&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":29.59693},159.6850983000927,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C118&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":4.6139000000000001},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C118&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":2.2028500000000002},8.4627855000049124,60.585386368533435,{"$f":"IFERROR((I118-J118)/I118*100,\"\")","v":52.256225752617091}]
[null,"12:00:00",6,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C119&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42654.6},3.4099999999962165,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C119&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":59.307290000000002},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C119&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":21.83182},127.79135269985822,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C119&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":2.96373},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C119&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":1.49779},4.9988553999944534,63.188640047454534,49.462670351212829]
[null,"13:00:00",7,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C120&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42658.11},{"$f":"IF(D120=\"\",\"\",D120-D119)","v":3.5100000000020373},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C120&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":53.659939999999999},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C120&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":9.62453},{"$f":"IFERROR((F120-G120)*E120,\"\")","v":154.5642891000897},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C120&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.74163999999999997},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C120&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0.49925000000000003},0.85078890000049356,82.063845021071586,32.682972870934677]
[null,"14:00:00",8,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C121&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42661.59},{"$f":"IF(D121=\"\",\"\",D121-D120)","v":3.4799999999959255},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C121&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":47.714410000000001},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C121&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":13.31976},{"$f":"IFERROR((F121-G121)*E121,\"\")","v":119.69338199985985},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C121&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.82874999999999999},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C121&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0.60646},0.77356919999909424,72.08440804360778,26.822322775263952]
[null,"15:00:00",9,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C122&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42665.120000000003},{"$f":"IF(D122=\"\",\"\",D122-D121)","v":3.5300000000061118},{"$f":"IFERROR(VLOOKUP(G$109&\"/1 \"&$C122&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":32.54318},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C122&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":11.735709999999999},73.450369100127176,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C122&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.60848000000000002},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C122&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0},2.1479344000037188,63.938035557680607,100]
[null,"16:00:00",10,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C123&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42668.67},3.5499999999956344,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C123&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":28.792719999999999},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C123&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":8.7060099999999991},71.30782049991231,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C123&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.3977},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C123&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0.28661999999999999},0.39433399999951513,69.763155408728323,27.930600955494096]
[null,"17:00:00",11,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C124&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42672.18},3.5100000000020373,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C124&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":23.970220000000001},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C124&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":7.8728899999999999},56.501628300032792,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C124&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.32530999999999999},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C124&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0},1.1418381000006628,67.155537162362293,100]
[null,"18:00:00",12,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C125&\"-*\",[1]Jun!$A:$H,8,),\"\")","v":42675.64},3.4599999999991269,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C125&\"-1\",[1]Jun!$A:$C,2,),\"\")","v":21.748619999999999},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C125&\"-2\",[1]Jun!$A:$C,2,),\"\")","v":5.8981199999999996},54.842729999986162,{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C125&\"-1\",[1]Jun!$A:$C,3,),\"\")","v":0.54317000000000004},{"$f":"IFERROR(VLOOKUP(G109&\"/1 \"&$C125&\"-2\",[1]Jun!$A:$C,3,),\"\")","v":0.20455999999999999},1.1715905999997047,72.880486210159546,62.339599020564471]
[null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(H113:H125),\"\")","v":1229.109003799967},null,null,{"$f":"IFERROR(SUM(K113:K125),\"\")","v":93.330595100001574},null,null,null,"ну и так далее "]