{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["пример","Лист1"],"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.519713331422018},{"$f":"D2+RAND()","v":36.948069227170024},0.23984833983847376,0.47727316991749036,62.353829852630405,55.85288972514941]
[null,"арбуз",{"$f":"C3+RAND()","v":19.395287252550755},{"$f":"D3+RAND()","v":0.64979994776940619},24.555289297005128,27.769559001104014,39.494256646705551,40.330888993173254]
[null,"капуста",{"$f":"C4+RAND()","v":0.8468289730316072},5.3405491133450509,4.7492895827965356,11.413093700260726,0.25293265710738977,16.600461277517542]
[null,"морковь",{"$f":"C5+RAND()","v":9.5439331732487585},12.008654015360584,0.32537686549743561,8.2434953307045884,13.030743967384119,14.548432146005005]
[null,"картофель",{"$f":"C6+RAND()","v":22.965772592633108},0.4014001470103763,34.024559099259534,27.628469770682312,0.1074920671415982,25.430693081319966]
[]
[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.519713331422018}]
[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.965772592633108}]
[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.395287252550755}]
[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.948069227170024}]
[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.008654015360584}]
[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.3405491133450509}]
[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.024559099259534}]
[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.555289297005128}]
[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.7492895827965356}]
[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.769559001104014}]
[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.628469770682312}]
[3,null,{"$f":"INDEX($B$9:$H$13,MATCH(E27,F$9:F$13,0),1)","v":"капуста"},11,11.413093700260726]

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