{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Рис. 1","Рис. 2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Рис. 1","index":0,"n_rows":209,"n_cols":48,"rows_kept":209,"cut":false,"hidden":false,"merged":[]}
["Rep","Invoice","Amount",null,"Rep",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43]
["R104",1002,9985,null,"R100",{"$f":"VLOOKUP($E2,$A$2:$C$209,3,FALSE)","v":9916},{"$f":"VLOOKUPNTH($E2,$A$2:$C$209,3,G$1)","v":"9761"},{"$f":"VLOOKUPNTH($E2,$A$2:$C$209,3,H$1)","v":"9572"},{"$f":"VLOOKUPNTH($E2,$A$2:$C$209,3,I$1)","v":"9371"},{"$f":"VLOOKUPNTH($E2,$A$2:$C$209,3,J$1)","v":"8627"},"8522","7664","7477","6853","6232","6173","5833","5780","5709","5482","5447","4575","4170","4114","3852","3709",{"$f":"VLOOKUPNTH($E2,$A$2:$C$209,3,AA$1)","v":"3418"},"3140","2907","2676","2526","2461","2323","2194","2154","1814","1648","1440","1406","1143","931",{"$f":"VLOOKUPNTH($E2,$A$2:$C$209,3,AP$1)","v":"732"},"705","602","196","Not Found","Not Found","Not Found"]
["R102",1099,9980,null,"R101",{"$f":"VLOOKUP($E3,$A$2:$C$209,3,FALSE)","v":9970},{"$f":"VLOOKUPNTH($E3,$A$2:$C$209,3,G$1)","v":"9791"},{"$f":"VLOOKUPNTH($E3,$A$2:$C$209,3,H$1)","v":"9747"},{"$f":"VLOOKUPNTH($E3,$A$2:$C$209,3,I$1)","v":"9713"},"9509","9073","8805","8635","8392","8381","8372","8135","7718","7402","7263","7241","6515","6457","6122","6051","5638","5507","5276","5206","4797","4626","4336","4210","4167","3992","3866","3245","3227","2897","2587","2527","2517","2157","2108","2093","2015","1655","1609"]
["R101",1016,9970,null,"R102",{"$f":"VLOOKUP($E4,$A$2:$C$209,3,FALSE)","v":9980},{"$f":"VLOOKUPNTH($E4,$A$2:$C$209,3,G$1)","v":"9843"},{"$f":"VLOOKUPNTH($E4,$A$2:$C$209,3,H$1)","v":"9744"},"9547","9520","9175","8658","8261","7439","7424","6664","6644","6553","6443","6334","6315","4879","4868","4594","4524","4517","4484","4478","4355","4326","4266","4231","3798","3592","3258","2916","2698","2117","1020","851","Not Found","Not Found","Not Found","Not Found","Not Found","Not Found","Not Found","Not Found"]
["R100",1040,9916,null,"R103",{"$f":"VLOOKUP($E5,$A$2:$C$209,3,FALSE)","v":9781},"9560","9258","9077","8980","8555","8551","8386","8179","7917","7824","7125","7095","6615","6598","6530","6315","6124","5939","5641","5511","5245","5084","5057","5042","4782","4004","3805","3244","3119","1251","1114","868","738","727","689","418","374","Not Found","Not Found","Not Found","Not Found","Not Found"]
["R102",1130,9843,null,"R104",{"$f":"VLOOKUP($E6,$A$2:$C$209,3,FALSE)","v":9985},"9626","9553","9394","9176","8358","8159","7613","7449","7076","6683","6650","6252","6084","5531","5225","4976","4896","3751","3678","3654","3136","2668","1990","1771","853","795","597","472","429","134","Not Found","Not Found","Not Found","Not Found","Not Found","Not Found","Not Found","Not Found","Not Found","Not Found","Not Found","Not Found"]
["R101",1108,9791,null,"R105",{"$f":"VLOOKUP($E7,$A$2:$C$209,3,FALSE)","v":8937},8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,{"$f":"VLOOKUP($E7,$A$2:$C$209,3,FALSE)","v":8937},8937,8937,{"$f":"VLOOKUP($E7,$A$2:$C$209,3,FALSE)","v":8937},{"$f":"VLOOKUP($E7,$A$2:$C$209,3,FALSE)","v":8937},8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,8937,8937]
["R103",1082,9781]
["R100",1017,9761]
["R101",1187,9747]
["R102",1115,9744]
["R101",1128,9713]
["R104",1042,9626]
["R100",1047,9572]
["R103",1127,9560]
["R104",1044,9553]
["R102",1041,9547]
["R102",1169,9520]
["R101",1190,9509]
["R104",1203,9394]
["R100",1129,9371]
["R103",1105,9258]
["R104",1112,9176]
["R102",1185,9175]
["R103",1120,9077]
["R101",1157,9073]
["R103",1184,8980]
["R105",1089,8937]
["R101",1207,8805]
["R102",1117,8658]
["R101",1078,8635]
["R100",1056,8627]
["R103",1036,8555]
["R103",1122,8551]
["R100",1152,8522]
["R101",1138,8392]
["R103",1048,8386]
["R101",1080,8381]
["R101",1206,8372]
["R104",1057,8358]
["R102",1179,8261]
["R103",1148,8179]
["R104",1090,8159]
["R101",1024,8135]
["R103",1093,7917]
["R105",1144,7873]
["R103",1205,7824]
["R101",1004,7718]
["R100",1037,7664]
["R104",1091,7613]
["R100",1072,7477]
["R104",1189,7449]
["R102",1011,7439]
["R102",1202,7424]
["R101",1201,7402]
["R105",1119,7376]
["R105",1103,7302]
["R101",1140,7263]
["R101",1046,7241]
["R103",1050,7125]
["R103",1116,7095]
["R104",1192,7076]
["R100",1097,6853]
["R104",1174,6683]
["R102",1159,6664]
["R104",1071,6650]
["R102",1146,6644]
["R103",1111,6615]
["R103",1183,6598]
["R105",1087,6577]
["R102",1104,6553]
["R103",1039,6530]
["R101",1113,6515]
["R101",1168,6457]
["R102",1125,6443]
["R102",1018,6334]
["R102",1065,6315]
["R103",1147,6315]
["R104",1100,6252]
["R100",1060,6232]
["R100",1134,6173]
["R103",1182,6124]
["R101",1063,6122]
["R104",1005,6084]
["R101",1064,6051]
["R103",1008,5939]
["R100",1124,5833]
["R100",1167,5780]
["R100",1038,5709]
["R103",1163,5641]
["R101",1145,5638]
["R104",1077,5531]
["R103",1026,5511]
["R101",1059,5507]
["R100",1001,5482]
["R100",1133,5447]
["R101",1085,5276]
["R103",1123,5245]
["R104",1162,5225]
["R101",1015,5206]
["R103",1176,5084]
["R103",1007,5057]
["R103",1069,5042]
["R104",1164,4976]
["R104",1197,4896]
["R102",1062,4879]
["R102",1154,4868]
["R101",1194,4797]
["R103",1106,4782]
["R101",1143,4626]
["R102",1020,4594]
["R100",1141,4575]
["R105",1160,4529]
["R102",1121,4524]
["R102",1034,4517]
["R102",1158,4484]
["R102",1181,4478]
["R102",1101,4355]
["R101",1107,4336]
["R102",1023,4326]
["R102",1081,4266]
["R102",1096,4231]
["R101",1088,4210]
["R105",1031,4174]
["R100",1102,4170]
["R101",1058,4167]
["R100",1114,4114]
["R105",1200,4032]
["R103",1022,4004]
["R101",1083,3992]
["R101",1132,3866]
["R100",1137,3852]
["R103",1126,3805]
["R102",1098,3798]
["R104",1003,3751]
["R105",1092,3716]
["R100",1170,3709]
["R104",1010,3678]
["R104",1161,3654]
["R102",1191,3592]
["R100",1030,3418]
["R105",1006,3301]
["R102",1153,3258]
["R101",1043,3245]
["R103",1012,3244]
["R101",1061,3227]
["R105",1177,3213]
["R100",1094,3140]
["R104",1009,3136]
["R103",1070,3119]
["R102",1136,2916]
["R100",1171,2907]
["R101",1051,2897]
["R105",1110,2855]
["R102",1086,2698]
["R100",1186,2676]
["R104",1053,2668]
["R101",1118,2587]
["R101",1188,2527]
["R100",1084,2526]
["R101",1028,2517]
["R100",1068,2461]
["R100",1166,2323]
["R100",1075,2194]
["R101",1195,2157]
["R100",1052,2154]
["R102",1208,2117]
["R101",1033,2108]
["R101",1035,2093]
["R101",1074,2015]
["R104",1142,1990]
["R105",1109,1870]
["R100",1049,1814]
["R104",1055,1771]
["R105",1029,1762]
["R101",1066,1655]
["R100",1076,1648]
["R101",1073,1609]
["R105",1032,1559]
["R100",1149,1440]
["R105",1151,1418]
["R100",1173,1406]
["R103",1180,1251]
["R105",1013,1246]
["R100",1139,1143]
["R103",1014,1114]
["R105",1178,1069]
["R102",1198,1020]
["R100",1155,931]
["R101",1095,921]
["R103",1175,868]
["R104",1156,853]
["R102",1131,851]
["R104",1199,795]
["R103",1027,738]
["R100",1025,732]
["R103",1054,727]
["R100",1067,705]
["R103",1135,689]
["R100",1045,602]
["R104",1193,597]
["R105",1165,549]
["R104",1196,472]
["R104",1172,429]
["R103",1204,418]
["R101",1150,380]
["R103",1021,374]
["R100",1019,196]
["R104",1079,134]

{"sheet":"Рис. 2","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Rep","Name","Region",null,null,"Region","Rep","Name"]
["R104",{"$f":"VLOOKNEW(A2,$G$2:$H$6,2,FALSE)","v":"Edwards"},{"$f":"VLOOKNEW(A2,$G$2:$G$6,-1,FALSE)","v":"East"},null,null,"East","R100","Adams"]
["R102",{"$f":"VLOOKNEW(A3,$G$2:$H$6,2,FALSE)","v":"Clinton"},{"$f":"VLOOKNEW(A3,$G$2:$G$6,-1,FALSE)","v":"East"},null,null,"East","R102","Clinton"]
["R101","Bush","West",null,null,"East","R104","Edwards"]
["R100","Adams","East",null,null,"West","R101","Bush"]
["R102","Clinton","East",null,null,"West","R103","Delano"]
["R101","Bush","West"]
["R103","Delano","West"]
["R100","Adams","East"]
["R101","Bush","West"]