{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Test","Analize","Comparison","Chart(all)","Chart(low)","Structures","MemUsage"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Chart(all)","index":3,"reason":"not_a_worksheet"},{"sheet":"Chart(low)","index":4,"reason":"not_a_worksheet"}],"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":"Test","index":0,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Type","DDA1V","DDC","A2A2V","DA2S","A2A2A1V","DA2V","CA2V","DA1S","A1UU"]
[1000]
[2000]
[3000]
[4000,null,null,null,null,null,null,null,null,null,null,"Придётся подождать пару минут."]
[5000,null,null,null,null,null,null,null,null,null,null,"Если хотите снять ограничение в 5000 элементов, то правьте массив Sizes в коде."]
[10000,null,null,null,null,null,null,null,null,null,null,"Все циклы от 1000 до 70000 обычно занимают около 40 минут."]
[20000]
[30000]
[40000]
[50000]
[60000]
[70000]

{"sheet":"Analize","index":1,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Структура","Лаконичность","Понят\nность","Затраты памяти","Ско\nрость",null,"Время","Память"]
[null,"DDA1V",1,1,3,1,null,1,3.2008376397902909]
[null,"DDC",1,1,3,1,null,1.025502172407279,3.2173154908807748]
[null,"A2A2V",3,2,2,1,null,1.6797430892261194,2.2162713836163199]
[null,"DA2S",3,2,2,2,null,2.4754108683332285,1.2935263760668159]
[null,"A2A2A1V",3,3,1,2,null,2.7200428184623133,1]
[null,"DA2V",2,2,2,3,null,4.9607077639947104,2.1998081860434131]
[null,"CA2V",2,2,2,3,null,5.3152824129462877,2.1915617277662442]
[null,"DA1S",2,2,1,3,null,5.8437755808828156,1.0216418330738366]
[null,"A1UU",3,3,1,3,null,14.27202317234431,1.19876401992949]

{"sheet":"Comparison","index":2,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Type","DDA1V","DDC","A2A2V","DA2S","A2A2A1V","DA2V","CA2V","DA1S","A1UU"]
[null,1000,172,156,281,483,468,983,1123,1108,78]
[null,2000,312,312,624,982,968,1950,2246,2059,234]
[null,3000,484,484,936,1513,1513,2980,3416,2902,452]
[null,4000,624,655,1294,1966,2090,3978,4571,4306,749]
[null,5000,796,812,1607,2480,2636,4977,5787,5897,1154]
[null,10000,1622,1700,3401,4961,5475,10078,12667,13105,4430]
[null,20000,3542,4477,7082,10514,12059,22043,30545,27488,21996]
[null,30000,6006,5662,10983,15522,17690,31341,35677,30265,39359]
[null,40000,7785,8018,14695,21060,23743,42495,47596,40623,71355]
[null,50000,10218,10483,18735,26895,30264,53743,59826,58064,113179]
[null,60000,12995,13322,22511,32698,36223,65614,71651,75786,164410]
[null,70000,15881,16286,26676,39312,43197,78781,84412,92805,226654]

{"sheet":"Structures","index":5,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[4,6,5,6],[4,10,5,10],[4,9,5,9]]}
[]
[]
[null,null,null,null,"DDA1V","DDC","A2A2V","DA2S","A2A2A1V","DA2V","CA2V","DA1S","A1UU"]
[null,null,null,"L1","Dictionary","Dictionary","Array 2D","Dictionary","Array 2D","Dictionary","Collection","Dictionary","Array 2D"]
[null,null,null,"L2","Dictionary","Dictionary","Array 2D","Array 2D","Array 2D","Array 2D","Array 2D","Array 1D","UDT"]
[null,null,null,"L3","Array 1D","Class",null,"String","Array 1D",null,null,"String","UDT"]

{"sheet":"MemUsage","index":6,"n_rows":64,"n_cols":20,"rows_kept":64,"cut":false,"hidden":false,"merged":[[18,11,22,15],[58,1,58,6],[58,7,58,8],[59,1,60,1],[59,2,60,2],[59,3,60,3],[59,4,60,4],[59,6,59,7],[59,8,60,8],[51,1,51,6],[51,7,51,8],[52,1,53,1],[52,2,53,2],[52,3,53,3],[52,4,53,4],[52,6,52,7],[52,8,53,8],[44,1,44,6],[44,7,44,8],[45,1,46,1],[45,2,46,2],[45,3,46,3],[45,4,46,4],[45,6,45,7],[45,8,46,8],[37,1,37,6],[37,7,37,8],[38,1,39,1],[38,2,39,2],[38,3,39,3],[38,4,39,4],[38,6,38,7],[38,8,39,8],[30,1,30,6],[30,7,30,8],[31,1,32,1],[31,2,32,2],[31,3,32,3],[31,4,32,4],[31,6,31,7],[31,8,32,8],[10,4,11,4],[17,4,18,4],[23,1,23,6],[23,7,23,8],[24,1,25,1],[24,2,25,2],[24,3,25,3],[24,4,25,4],[24,6,24,7],[24,8,25,8],[16,1,16,6],[16,7,16,8],[17,1,18,1],[17,2,18,2],[17,3,18,3],[17,6,17,7],[17,8,18,8],[2,1,2,6],[2,7,2,8],[9,1,9,6],[9,7,9,8],[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,6,10,7],[10,8,11,8],[3,6,3,7],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,8,4,8],[3,4,4,4]]}
[null,"N=",70000,null,null,"M=",20]
[]
[null,"DA1S",null,null,null,null,null,{"$f":"SUM(I6:I8)","v":69441024},null,null,null,"DDA1V","DDC","A2A2V","DA2S","A2A2A1V","DA2V","CA2V","DA1S","A1UU"]
[null,"Level","Type","Structures","Elements, Items","Structure","Element",null,"Total",null,1000,3109024,3125024,2152028,1257024,971028,2137024,2128512,993024,1160024]
[null,null,null,null,null,"Overhead","Overhead","Data",null,null,2000,6217024,6249024,4304028,2513024,1942028,4273024,4256512,1985024,2320024]
[null,"L1","Dictionary",1,{"$f":"CountL1","v":70000},1024,16,12,{"$f":"(E6*(G6+H6)+F6)*D6","v":1961024},null,3000,9325024,9373024,6456028,3769024,2913028,6409024,6384512,2977024,3480024]
[null,"L2","Array D1",{"$f":"CountL1","v":70000},{"$f":"CountL2","v":20},24,0,4,{"$f":"(E7*(G7+H7)+F7)*D7","v":7280000},null,4000,12433024,12497024,8608028,5025024,3884028,8545024,8512512,3969024,4640024]
[null,"L3","String",{"$f":"CountL1","v":70000},{"$f":"CountL2","v":20},0,10,33,{"$f":"(E8*(G8+H8)+F8)*D8","v":60200000},null,5000,15541024,15621024,10760028,6281024,4855028,10681024,10640512,4961024,5800024]
[null,null,null,null,null,null,null,null,null,null,10000,31081024,31241024,21520028,12561024,9710028,21361024,21280512,9921024,11600024]
[null,"DA2S",null,null,null,null,null,{"$f":"SUM(I13:I15)","v":87921024},null,null,20000,62161024,62481024,43040028,25121024,19420028,42721024,42560512,19841024,23200024]
[null,"Level","Type","Structures","Elements, Items","Structure","Element",null,"Total",null,30000,93241024,93721024,64560028,37681024,29130028,64081024,63840512,29761024,34800024]
[null,null,null,null,null,"Overhead","Overhead","Data",null,null,40000,124321024,124961024,86080028,50241024,38840028,85441024,85120512,39681024,46400024]
[null,"L1","Dictionary",1,{"$f":"CountL1","v":70000},1024,16,12,{"$f":"(E13*(G13+H13)+F13)*D13","v":1961024},null,50000,155401024,156201024,107600028,62801024,48550028,106801024,106400512,49601024,58000024]
[null,"L2","Array D2",{"$f":"CountL1","v":70000},{"$f":"CountL2*2","v":40},28,0,4,{"$f":"(E14*(G14+H14)+F14)*D14","v":13160000},null,60000,186481024,187441024,129120028,75361024,58260028,128161024,127680512,59521024,69600024]
[null,"L3","String",{"$f":"CountL1","v":70000},{"$f":"CountL2*2","v":40},0,10,16,{"$f":"(E15*(G15+H15)+F15)*D15","v":72800000},null,70000,217561024,218681024,150640028,87921024,67970028,149521024,148960512,69441024,81200024]
[]
[null,"DDA1V",null,null,null,null,null,{"$f":"SUM(I20:I22)","v":217561024},null,null,null,{"$f":"$H$17","v":217561024},{"$f":"$H$59","v":218681024},{"$f":"$H$24","v":150640028},{"$f":"$H$10","v":87921024},{"$f":"$H$31","v":67970028},{"$f":"$H$38","v":149521024},{"$f":"$H$45","v":148960512},{"$f":"$H$3","v":69441024},{"$f":"$H$52","v":81480024}]
[null,"Level","Type","Structures","Elements, Items","Structure","Element",null,"Total"]
[null,null,null,null,null,"Overhead","Overhead","Data",null,null,null,"Это примерные затраты памяти. \nТочными инструментами контроля памяти VBA не располагает, поэтому тут есть известная доля моей фантазии и здравого смысла."]
[null,"L1","Dictionary",1,{"$f":"CountL1","v":70000},1024,16,4,{"$f":"(E20*(G20+H20)+F20)*D20","v":1401024}]
[null,"L2","Dictionary",{"$f":"CountL1","v":70000},{"$f":"CountL2","v":20},1024,16,12,{"$f":"(E21*(G21+H21)+F21)*D21","v":110880000}]
[null,"L3","Array D1",{"$f":"CountL1","v":70000},{"$f":"CountL2","v":20},24,54,20,{"$f":"(E22*(G22+H22)+F22)*D22","v":105280000}]
[]
[null,"A2A2V",null,null,null,null,null,{"$f":"SUM(I27:I29)","v":150640028}]
[null,"Level","Type","Structures","Elements, Items","Structure","Element",null,"Total"]
[null,null,null,null,null,"Overhead","Overhead","Data"]
[null,"L1","Array D2",1,{"$f":"CountL1*2","v":140000},28,17,5,{"$f":"(E27*(G27+H27)+F27)*D27","v":3080028}]
[null,"L2","Array D2",{"$f":"CountL1","v":70000},{"$f":"CountL2*4","v":80},28,19,7,{"$f":"(E28*(G28+H28)+F28)*D28","v":147560000}]
[null,"L3",null,null,null,null,null,null,{"$f":"(E29*(G29+H29)+F29)*D29","v":0}]
[]
[null,"A2A2A1V",null,null,null,null,null,{"$f":"SUM(I34:I36)","v":67970028}]
[null,"Level","Type","Structures","Elements, Items","Structure","Element",null,"Total"]
[null,null,null,null,null,"Overhead","Overhead","Data"]
[null,"L1","Array D2",1,{"$f":"CountL1*2","v":140000},28,17,5,{"$f":"(E34*(G34+H34)+F34)*D34","v":3080028}]
[null,"L2","Array D2",{"$f":"CountL1","v":70000},{"$f":"CountL2*2","v":40},28,17,3,{"$f":"(E35*(G35+H35)+F35)*D35","v":57960000}]
[null,"L3","Array D1",{"$f":"CountL1","v":70000},3,24,18,7,{"$f":"(E36*(G36+H36)+F36)*D36","v":6930000}]
[]
[null,"DA2V",null,null,null,null,null,{"$f":"SUM(I41:I43)","v":149521024}]
[null,"Level","Type","Structures","Elements, Items","Structure","Element",null,"Total"]
[null,null,null,null,null,"Overhead","Overhead","Data"]
[null,"L1","Dictionary",1,{"$f":"CountL1","v":70000},1024,16,12,{"$f":"(E41*(G41+H41)+F41)*D41","v":1961024}]
[null,"L2","Array D2",{"$f":"CountL1","v":70000},{"$f":"CountL2*4","v":80},28,19,7,{"$f":"(E42*(G42+H42)+F42)*D42","v":147560000}]
[null,"L3",null,null,null,null,null,null,{"$f":"(E43*(G43+H43)+F43)*D43","v":0}]
[]
[null,"CA2V",null,null,null,null,null,{"$f":"SUM(I48:I50)","v":148960512}]
[null,"Level","Type","Structures","Elements, Items","Structure","Element",null,"Total"]
[null,null,null,null,null,"Overhead","Overhead","Data"]
[null,"L1","Collection",1,{"$f":"CountL1","v":70000},512,8,12,{"$f":"(E48*(G48+H48)+F48)*D48","v":1400512}]
[null,"L2","Array D2",{"$f":"CountL1","v":70000},{"$f":"CountL2*4","v":80},28,19,7,{"$f":"(E49*(G49+H49)+F49)*D49","v":147560000}]
[null,"L3",null,null,null,null,null,null,{"$f":"(E50*(G50+H50)+F50)*D50","v":0}]
[]
[null,"A1UU",null,null,null,null,null,{"$f":"SUM(I55:I57)","v":81480024}]
[null,"Level","Type","Structures","Elements, Items","Structure","Element",null,"Total"]
[null,null,null,null,null,"Overhead","Overhead","Data"]
[null,"L1","Array D1",1,{"$f":"CountL1","v":70000},24,0,4,{"$f":"(E55*(G55+H55)+F55)*D55","v":280024}]
[null,"L2","UDT",{"$f":"CountL1","v":70000},20,20,20,37,{"$f":"(E56*(G56+H56)+F56)*D56","v":81200000}]
[null,"L3",null,null,null,null,null,null,{"$f":"(E57*(G57+H57)+F57)*D57","v":0}]
[]
[null,"DDC",null,null,null,null,null,{"$f":"SUM(I62:I64)","v":218681024}]
[null,"Level","Type","Structures","Elements, Items","Structure","Element",null,"Total"]
[null,null,null,null,null,"Overhead","Overhead","Data"]
[null,"L1","Dictionary",1,{"$f":"CountL1","v":70000},1024,16,4,{"$f":"(E62*(G62+H62)+F62)*D62","v":1401024}]
[null,"L2","Dictionary",{"$f":"CountL1","v":70000},{"$f":"CountL2","v":20},1024,16,4,{"$f":"(E63*(G63+H63)+F63)*D63","v":99680000}]
[null,"L3","Class",{"$f":"CountL1*CountL2","v":1400000},1,32,{"$f":"10+10","v":20},{"$f":"20+8+4","v":32},{"$f":"(E64*(G64+H64)+F64)*D64","v":117600000}]