{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["пример","Лист1"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"пример","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[14,7,14,8]]}
["№","продукт","Январь","Февраль","Март","Апрель","Май","Июнь"]
[1,"тыква",35,36,0,0,62,55]
[2,"арбуз",19,0,24,27,39,40]
[3,"капуста",0,5,4,11,0,16]
[4,"морковь",9,12,0,8,13,14]
[5,"картофель",22,0,34,27,0,25]
[]
[null,"   Таблица 1.  Плюс случайные числа (снятие проблемы повторов)"]
[null,"тыква",{"$f":"C2+RAND()","v":35.569459227432944},{"$f":"D2+RAND()","v":36.527633180811151},0.98686901780416114,0.83123031250346913,62.657882593553275,55.76807285511353]
[null,"арбуз",{"$f":"C3+RAND()","v":19.363232492998087},{"$f":"D3+RAND()","v":0.11437911304461779},24.411513608443787,27.077470202296809,39.181325694832729,40.507250079932305]
[null,"капуста",{"$f":"C4+RAND()","v":0.43358953475428408},5.442448620652061,4.6374403433253892,11.861323788567852,0.61793241653388797,16.132719439232087]
[null,"морковь",{"$f":"C5+RAND()","v":9.9486988094382482},12.760077686610154,0.59217267973275245,8.8122310638545258,13.046087243377423,14.956567170719657]
[null,"картофель",{"$f":"C6+RAND()","v":22.245142145138864},0.77921393927772797,34.905363342003206,27.415970755285656,0.5307773076006026,25.162234481439487]
[]
[null,"   Таблица 2.  индекс() + поискпоз() в табл.1 / восстановление данных"]
[1,"янв",{"$f":"INDEX($B$9:$H$13,MATCH(E16,C$9:C$13,0),1)","v":"тыква"},{"$f":"ROUNDDOWN(E16,0)","v":35},{"$f":"LARGE($C$9:$C$13,$A16)","v":35.569459227432944}]
[2,null,{"$f":"INDEX($B$9:$H$13,MATCH(E17,C$9:C$13,0),1)","v":"картофель"},{"$f":"ROUNDDOWN(E17,0)","v":22},{"$f":"LARGE($C$9:$C$13,$A17)","v":22.245142145138864}]
[3,null,{"$f":"INDEX($B$9:$H$13,MATCH(E18,C$9:C$13,0),1)","v":"арбуз"},{"$f":"ROUNDDOWN(E18,0)","v":19},{"$f":"LARGE($C$9:$C$13,$A18)","v":19.363232492998087}]
[1,"фев",{"$f":"INDEX($B$9:$H$13,MATCH(E19,D$9:D$13,0),1)","v":"тыква"},36,{"$f":"LARGE($D$9:$D$13,$A19)","v":36.527633180811151}]
[2,null,{"$f":"INDEX($B$9:$H$13,MATCH(E20,D$9:D$13,0),1)","v":"морковь"},12,{"$f":"LARGE($D$9:$D$13,$A20)","v":12.760077686610154}]
[3,null,{"$f":"INDEX($B$9:$H$13,MATCH(E21,D$9:D$13,0),1)","v":"капуста"},5,{"$f":"LARGE($D$9:$D$13,$A21)","v":5.442448620652061}]
[1,"мар",{"$f":"INDEX($B$9:$H$13,MATCH(E22,E$9:E$13,0),1)","v":"картофель"},34,{"$f":"LARGE($E$9:$E$13,$A22)","v":34.905363342003206}]
[2,null,{"$f":"INDEX($B$9:$H$13,MATCH(E23,E$9:E$13,0),1)","v":"арбуз"},24,{"$f":"LARGE($E$9:$E$13,$A23)","v":24.411513608443787}]
[3,null,{"$f":"INDEX($B$9:$H$13,MATCH(E24,E$9:E$13,0),1)","v":"капуста"},4,{"$f":"LARGE($E$9:$E$13,$A24)","v":4.6374403433253892}]
[1,"апр",{"$f":"INDEX($B$9:$H$13,MATCH(E25,F$9:F$13,0),1)","v":"картофель"},27,{"$f":"LARGE($F$9:$F$13,$A25)","v":27.415970755285656}]
[2,null,{"$f":"INDEX($B$9:$H$13,MATCH(E26,F$9:F$13,0),1)","v":"арбуз"},27,{"$f":"LARGE($F$9:$F$13,$A26)","v":27.077470202296809}]
[3,null,{"$f":"INDEX($B$9:$H$13,MATCH(E27,F$9:F$13,0),1)","v":"капуста"},11,11.861323788567852]

{"sheet":"Лист1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}