{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["пример"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"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":"пример","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.402740108542936},{"$f":"D2+RAND()","v":36.650050168468461},0.60815355403477889,0.40336654159280683,62.96099041960796,55.20803983267934]
[null,"арбуз",{"$f":"C3+RAND()","v":19.542150285152971},{"$f":"D3+RAND()","v":0.26530868906271077},24.453254992807114,27.726933250682549,39.984062689372692,40.72529113598447]
[null,"капуста",{"$f":"C4+RAND()","v":6.6257351037935952E-2},5.6838445768377213,4.5391183167416491,11.684687347408101,0.81393389376152292,16.465777462082578]
[null,"морковь",{"$f":"C5+RAND()","v":9.1919909661979791},12.907079428166416,0.25626015936868907,8.8002607165969309,13.229227824041006,14.639447642068712]
[null,"картофель",{"$f":"C6+RAND()","v":22.077707088745992},0.60182852123009944,34.650596168593097,27.868754459536166,0.44679206353398992,25.139802248151518]
[]
[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.402740108542936}]
[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.077707088745992}]
[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.542150285152971}]
[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.650050168468461}]
[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.907079428166416}]
[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.6838445768377213}]
[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.650596168593097}]
[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.453254992807114}]
[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.5391183167416491}]
[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.868754459536166}]
[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.726933250682549}]
[3,null,{"$f":"INDEX($B$9:$H$13,MATCH(E27,F$9:F$13,0),1)","v":"капуста"},11,11.684687347408101]