{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Данные","ЧТо получится","Макрос"],"not_rendered":{"charts":0,"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":17,"n_cols":22,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,11,1,11]]}
["Дата",null,1,2,3,4,5,6,null,null,null,"Дата",null,7,8,9,10,11,12,13,14,15]
[null,"Итого, руб,","А","Б","В","Г","Д","Е","Прочие",null,null,null,"Итого по рынку, руб.","Ж","З","И","К","Л","М","Н","О","П"]
[]
["06.07.2021, вт",100000,8.0199999999999994E-2,7.4399999999999994E-2,null,1.43E-2,0.33210000000000001,2.2000000000000001E-3,0.49680000000000002,null,null,"06.07.2021, вт",100000,1.32E-2,0.26119999999999999,0.01,1.2E-2,8.5900000000000004E-2,2.3400000000000001E-2,8.8700000000000001E-2,null,2.3E-3]
["07.07.2021, ср",100000,0.24560000000000001,0.1651,1.0999999999999999E-2,8.1100000000000005E-2,0.1105,null,0.38669999999999999,null,null,"07.07.2021, ср",100000,null,0.1459,6.6E-3,3.4799999999999998E-2,2.4799999999999999E-2,0.11749999999999999,3.1399999999999997E-2,4.4999999999999997E-3,2.1100000000000001E-2]
["08.07.2021, чт",100000,0.2399,0.1283,null,2.7799999999999998E-2,0.19059999999999999,1.1000000000000001E-3,0.4123,null,null,"08.07.2021, чт",100000,1.15E-2,0.1182,4.9500000000000002E-2,3.3E-3,3.8699999999999998E-2,6.9599999999999995E-2,0.1217]
["09,07,2021, пт",100000,0.21890000000000001,0.1105,3.8E-3,1.2500000000000001E-2,0.15240000000000001,null,0.50190000000000001,null,null,"09,07,2021, пт",100000,null,0.20230000000000001,3.8199999999999998E-2,3.8399999999999997E-2,1.7000000000000001E-2,0.126,6.8099999999999994E-2,1.0699999999999999E-2]
["10,07,2021, сб",100000,0.33660000000000001,0.1024,null,1.37E-2,0.15110000000000001,null,0.3962,null,null,"10,07,2021, сб",100000,null,0.31509999999999999,null,null,null,8.1199999999999994E-2]
["12,07,2021, пн",100000,9.1499999999999998E-2,0.20849999999999999,2.4299999999999999E-2,2.5399999999999999E-2,0.1331,2.2000000000000001E-3,0.51500000000000001,null,null,"12,07,2021, пн",100000,null,0.1447,1.18E-2,null,4.1300000000000003E-2,5.0200000000000002E-2,0.24890000000000001,1.9E-3,1.6299999999999999E-2]
["13,07,2021, вт",100000,0.1956,0.1041,null,2.86E-2,0.11749999999999999,3.7000000000000002E-3,0.55049999999999999,null,null,"13,07,2021, вт",100000,null,0.18240000000000001,6.1400000000000003E-2,null,null,0.14499999999999999,0.16170000000000001]
["14,07,2021, ср",100000,0.18690000000000001,0.1361,1.84E-2,3.6499999999999998E-2,0.19550000000000001,4.0000000000000001E-3,0.42259999999999998,null,null,"14,07,2021, ср",100000,5.7000000000000002E-3,8.1000000000000003E-2,7.1999999999999998E-3,1.2E-2,0.1429,0.1128,5.2900000000000003E-2,5.3E-3,2.8E-3]
["15,07,2021, чт",100000,0.15179999999999999,6.7900000000000002E-2,null,1.01E-2,0.1033,null,0.66690000000000005,null,null,"15,07,2021, чт",100000,null,0.1313,8.14E-2,2.0199999999999999E-2,2.5700000000000001E-2,0.29120000000000001,0.1172]
["16,07,2021, пт",100000,0.1739,0.24529999999999999,null,1.4999999999999999E-2,0.15509999999999999,null,0.41070000000000001,null,null,"16,07,2021, пт",100000,null,0.1648,3.3E-3,6.8999999999999999E-3,3.2199999999999999E-2,0.1115,9.1200000000000003E-2]
["19.07.2021, пн",100000,0.24979999999999999,0.1724,null,2.7400000000000001E-2,0.1217,2.8999999999999998E-3,0.42580000000000001,null,null,"19.07.2021, пн",100000,null,0.121,6.1000000000000004E-3,7.3000000000000001E-3,7.5700000000000003E-2,0.1139,8.1000000000000003E-2,1.35E-2]
["20.07.2021, вт",100000,0.39379999999999998,3.9E-2,null,2.3999999999999998E-3,0.33650000000000002,null,0.2283,null,null,"20.07.2021, вт",100000,null,0.13150000000000001,1.3299999999999999E-2,null,1.43E-2,5.9299999999999999E-2,3.2000000000000002E-3,null,4.7000000000000002E-3]
["21.07.2021, ср",100000,0.13200000000000001,6.9599999999999995E-2,4.7999999999999996E-3,5.7000000000000002E-3,0.33429999999999999,null,0.4536,null,null,"21.07.2021, ср",100000,null,0.10349999999999999,2.64E-2,null,6.0299999999999999E-2,0.19159999999999999,6.7199999999999996E-2]
["22.07.2021, чт",100000,0.1069,8.1699999999999995E-2,2.7E-2,1.04E-2,0.12230000000000001,4.5999999999999999E-3,0.64710000000000001,null,null,"22.07.2021, чт",100000,null,0.14580000000000001,0.15240000000000001,null,0.2051,9.7900000000000001E-2,4.5900000000000003E-2]

{"sheet":"ЧТо получится","index":1,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Сюда скопировать в таком формате"]
[]
[]
["Дата","Пост-к","Итого по рынку","%"]
["06.07.2021, вт","А",100000,8.0199999999999994E-2]
["06.07.2021, вт","Б",100000,7.4399999999999994E-2]
["06.07.2021, вт","В",100000]
["06.07.2021, вт","Г",100000,1.43E-2]
["06.07.2021, вт","Д",100000,0.33210000000000001]
["06.07.2021, вт","Е",100000,2.2000000000000001E-3]
["06.07.2021, вт","Ж",100000,1.32E-2]
["06.07.2021, вт","З",100000,0.26119999999999999]
["06.07.2021, вт","И",100000,0.01]
["06.07.2021, вт","К",100000,1.2E-2]
["06.07.2021, вт","Л",100000,8.5900000000000004E-2]
["06.07.2021, вт","М",100000,2.3400000000000001E-2]
["06.07.2021, вт","Н",100000,8.8700000000000001E-2]
["06.07.2021, вт","О",100000]
["06.07.2021, вт","П",100000,2.3E-3]

{"sheet":"Макрос","index":2,"n_rows":211,"n_cols":4,"rows_kept":211,"cut":false,"hidden":false,"merged":[]}
[]
["06.07.2021, вт","А",100000,8.0199999999999994E-2]
["06.07.2021, вт","Б",100000,7.4399999999999994E-2]
["06.07.2021, вт","В",100000]
["06.07.2021, вт","Г",100000,1.43E-2]
["06.07.2021, вт","Д",100000,0.33210000000000001]
["06.07.2021, вт","Е",100000,2.2000000000000001E-3]
["06.07.2021, вт","Ж",100000,1.32E-2]
["06.07.2021, вт","З",100000,0.26119999999999999]
["06.07.2021, вт","И",100000,0.01]
["06.07.2021, вт","К",100000,1.2E-2]
["06.07.2021, вт","Л",100000,8.5900000000000004E-2]
["06.07.2021, вт","М",100000,2.3400000000000001E-2]
["06.07.2021, вт","Н",100000,8.8700000000000001E-2]
["06.07.2021, вт","О",100000]
["06.07.2021, вт","П",100000,2.3E-3]
["07.07.2021, ср","А",100000,0.24560000000000001]
["07.07.2021, ср","Б",100000,0.1651]
["07.07.2021, ср","В",100000,1.0999999999999999E-2]
["07.07.2021, ср","Г",100000,8.1100000000000005E-2]
["07.07.2021, ср","Д",100000,0.1105]
["07.07.2021, ср","Е",100000]
["07.07.2021, ср","Ж",100000]
["07.07.2021, ср","З",100000,0.1459]
["07.07.2021, ср","И",100000,6.6E-3]
["07.07.2021, ср","К",100000,3.4799999999999998E-2]
["07.07.2021, ср","Л",100000,2.4799999999999999E-2]
["07.07.2021, ср","М",100000,0.11749999999999999]
["07.07.2021, ср","Н",100000,3.1399999999999997E-2]
["07.07.2021, ср","О",100000,4.4999999999999997E-3]
["07.07.2021, ср","П",100000,2.1100000000000001E-2]
["08.07.2021, чт","А",100000,0.2399]
["08.07.2021, чт","Б",100000,0.1283]
["08.07.2021, чт","В",100000]
["08.07.2021, чт","Г",100000,2.7799999999999998E-2]
["08.07.2021, чт","Д",100000,0.19059999999999999]
["08.07.2021, чт","Е",100000,1.1000000000000001E-3]
["08.07.2021, чт","Ж",100000,1.15E-2]
["08.07.2021, чт","З",100000,0.1182]
["08.07.2021, чт","И",100000,4.9500000000000002E-2]
["08.07.2021, чт","К",100000,3.3E-3]
["08.07.2021, чт","Л",100000,3.8699999999999998E-2]
["08.07.2021, чт","М",100000,6.9599999999999995E-2]
["08.07.2021, чт","Н",100000,0.1217]
["08.07.2021, чт","О",100000]
["08.07.2021, чт","П",100000]
["09,07,2021, пт","А",100000,0.21890000000000001]
["09,07,2021, пт","Б",100000,0.1105]
["09,07,2021, пт","В",100000,3.8E-3]
["09,07,2021, пт","Г",100000,1.2500000000000001E-2]
["09,07,2021, пт","Д",100000,0.15240000000000001]
["09,07,2021, пт","Е",100000]
["09,07,2021, пт","Ж",100000]
["09,07,2021, пт","З",100000,0.20230000000000001]
["09,07,2021, пт","И",100000,3.8199999999999998E-2]
["09,07,2021, пт","К",100000,3.8399999999999997E-2]
["09,07,2021, пт","Л",100000,1.7000000000000001E-2]
["09,07,2021, пт","М",100000,0.126]
["09,07,2021, пт","Н",100000,6.8099999999999994E-2]
["09,07,2021, пт","О",100000,1.0699999999999999E-2]
["09,07,2021, пт","П",100000]
["10,07,2021, сб","А",100000,0.33660000000000001]
["10,07,2021, сб","Б",100000,0.1024]
["10,07,2021, сб","В",100000]
["10,07,2021, сб","Г",100000,1.37E-2]
["10,07,2021, сб","Д",100000,0.15110000000000001]
["10,07,2021, сб","Е",100000]
["10,07,2021, сб","Ж",100000]
["10,07,2021, сб","З",100000,0.31509999999999999]
["10,07,2021, сб","И",100000]
["10,07,2021, сб","К",100000]
["10,07,2021, сб","Л",100000]
["10,07,2021, сб","М",100000,8.1199999999999994E-2]
["10,07,2021, сб","Н",100000]
["10,07,2021, сб","О",100000]
["10,07,2021, сб","П",100000]
["12,07,2021, пн","А",100000,9.1499999999999998E-2]
["12,07,2021, пн","Б",100000,0.20849999999999999]
["12,07,2021, пн","В",100000,2.4299999999999999E-2]
["12,07,2021, пн","Г",100000,2.5399999999999999E-2]
["12,07,2021, пн","Д",100000,0.1331]
["12,07,2021, пн","Е",100000,2.2000000000000001E-3]
["12,07,2021, пн","Ж",100000]
["12,07,2021, пн","З",100000,0.1447]
["12,07,2021, пн","И",100000,1.18E-2]
["12,07,2021, пн","К",100000]
["12,07,2021, пн","Л",100000,4.1300000000000003E-2]
["12,07,2021, пн","М",100000,5.0200000000000002E-2]
["12,07,2021, пн","Н",100000,0.24890000000000001]
["12,07,2021, пн","О",100000,1.9E-3]
["12,07,2021, пн","П",100000,1.6299999999999999E-2]
["13,07,2021, вт","А",100000,0.1956]
["13,07,2021, вт","Б",100000,0.1041]
["13,07,2021, вт","В",100000]
["13,07,2021, вт","Г",100000,2.86E-2]
["13,07,2021, вт","Д",100000,0.11749999999999999]
["13,07,2021, вт","Е",100000,3.7000000000000002E-3]
["13,07,2021, вт","Ж",100000]
["13,07,2021, вт","З",100000,0.18240000000000001]
["13,07,2021, вт","И",100000,6.1400000000000003E-2]
["13,07,2021, вт","К",100000]
["13,07,2021, вт","Л",100000]
["13,07,2021, вт","М",100000,0.14499999999999999]
["13,07,2021, вт","Н",100000,0.16170000000000001]
["13,07,2021, вт","О",100000]
["13,07,2021, вт","П",100000]
["14,07,2021, ср","А",100000,0.18690000000000001]
["14,07,2021, ср","Б",100000,0.1361]
["14,07,2021, ср","В",100000,1.84E-2]
["14,07,2021, ср","Г",100000,3.6499999999999998E-2]
["14,07,2021, ср","Д",100000,0.19550000000000001]
["14,07,2021, ср","Е",100000,4.0000000000000001E-3]
["14,07,2021, ср","Ж",100000,5.7000000000000002E-3]
["14,07,2021, ср","З",100000,8.1000000000000003E-2]
["14,07,2021, ср","И",100000,7.1999999999999998E-3]
["14,07,2021, ср","К",100000,1.2E-2]
["14,07,2021, ср","Л",100000,0.1429]
["14,07,2021, ср","М",100000,0.1128]
["14,07,2021, ср","Н",100000,5.2900000000000003E-2]
["14,07,2021, ср","О",100000,5.3E-3]
["14,07,2021, ср","П",100000,2.8E-3]
["15,07,2021, чт","А",100000,0.15179999999999999]
["15,07,2021, чт","Б",100000,6.7900000000000002E-2]
["15,07,2021, чт","В",100000]
["15,07,2021, чт","Г",100000,1.01E-2]
["15,07,2021, чт","Д",100000,0.1033]
["15,07,2021, чт","Е",100000]
["15,07,2021, чт","Ж",100000]
["15,07,2021, чт","З",100000,0.1313]
["15,07,2021, чт","И",100000,8.14E-2]
["15,07,2021, чт","К",100000,2.0199999999999999E-2]
["15,07,2021, чт","Л",100000,2.5700000000000001E-2]
["15,07,2021, чт","М",100000,0.29120000000000001]
["15,07,2021, чт","Н",100000,0.1172]
["15,07,2021, чт","О",100000]
["15,07,2021, чт","П",100000]
["16,07,2021, пт","А",100000,0.1739]
["16,07,2021, пт","Б",100000,0.24529999999999999]
["16,07,2021, пт","В",100000]
["16,07,2021, пт","Г",100000,1.4999999999999999E-2]
["16,07,2021, пт","Д",100000,0.15509999999999999]
["16,07,2021, пт","Е",100000]
["16,07,2021, пт","Ж",100000]
["16,07,2021, пт","З",100000,0.1648]
["16,07,2021, пт","И",100000,3.3E-3]
["16,07,2021, пт","К",100000,6.8999999999999999E-3]
["16,07,2021, пт","Л",100000,3.2199999999999999E-2]
["16,07,2021, пт","М",100000,0.1115]
["16,07,2021, пт","Н",100000,9.1200000000000003E-2]
["16,07,2021, пт","О",100000]
["16,07,2021, пт","П",100000]
["19.07.2021, пн","А",100000,0.24979999999999999]
["19.07.2021, пн","Б",100000,0.1724]
["19.07.2021, пн","В",100000]
["19.07.2021, пн","Г",100000,2.7400000000000001E-2]
["19.07.2021, пн","Д",100000,0.1217]
["19.07.2021, пн","Е",100000,2.8999999999999998E-3]
["19.07.2021, пн","Ж",100000]
["19.07.2021, пн","З",100000,0.121]
["19.07.2021, пн","И",100000,6.1000000000000004E-3]
["19.07.2021, пн","К",100000,7.3000000000000001E-3]
["19.07.2021, пн","Л",100000,7.5700000000000003E-2]
["19.07.2021, пн","М",100000,0.1139]
["19.07.2021, пн","Н",100000,8.1000000000000003E-2]
["19.07.2021, пн","О",100000,1.35E-2]
["19.07.2021, пн","П",100000]
["20.07.2021, вт","А",100000,0.39379999999999998]
["20.07.2021, вт","Б",100000,3.9E-2]
["20.07.2021, вт","В",100000]
["20.07.2021, вт","Г",100000,2.3999999999999998E-3]
["20.07.2021, вт","Д",100000,0.33650000000000002]
["20.07.2021, вт","Е",100000]
["20.07.2021, вт","Ж",100000]
["20.07.2021, вт","З",100000,0.13150000000000001]
["20.07.2021, вт","И",100000,1.3299999999999999E-2]
["20.07.2021, вт","К",100000]
["20.07.2021, вт","Л",100000,1.43E-2]
["20.07.2021, вт","М",100000,5.9299999999999999E-2]
["20.07.2021, вт","Н",100000,3.2000000000000002E-3]
["20.07.2021, вт","О",100000]
["20.07.2021, вт","П",100000,4.7000000000000002E-3]
["21.07.2021, ср","А",100000,0.13200000000000001]
["21.07.2021, ср","Б",100000,6.9599999999999995E-2]
["21.07.2021, ср","В",100000,4.7999999999999996E-3]
["21.07.2021, ср","Г",100000,5.7000000000000002E-3]
["21.07.2021, ср","Д",100000,0.33429999999999999]
["21.07.2021, ср","Е",100000]
["21.07.2021, ср","Ж",100000]
["21.07.2021, ср","З",100000,0.10349999999999999]
["21.07.2021, ср","И",100000,2.64E-2]
["21.07.2021, ср","К",100000]
["21.07.2021, ср","Л",100000,6.0299999999999999E-2]
["21.07.2021, ср","М",100000,0.19159999999999999]
["21.07.2021, ср","Н",100000,6.7199999999999996E-2]
["21.07.2021, ср","О",100000]
["21.07.2021, ср","П",100000]
["22.07.2021, чт","А",100000,0.1069]
["22.07.2021, чт","Б",100000,8.1699999999999995E-2]
["22.07.2021, чт","В",100000,2.7E-2]
["22.07.2021, чт","Г",100000,1.04E-2]
["22.07.2021, чт","Д",100000,0.12230000000000001]
["22.07.2021, чт","Е",100000,4.5999999999999999E-3]
["22.07.2021, чт","Ж",100000]
["22.07.2021, чт","З",100000,0.14580000000000001]
["22.07.2021, чт","И",100000,0.15240000000000001]
["22.07.2021, чт","К",100000]
["22.07.2021, чт","Л",100000,0.2051]
["22.07.2021, чт","М",100000,9.7900000000000001E-2]
["22.07.2021, чт","Н",100000,4.5900000000000003E-2]
["22.07.2021, чт","О",100000]
["22.07.2021, чт","П",100000]