{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Клиенты","Бонусы","Касса"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":122,"n_cols":14,"rows_kept":122,"cut":false,"hidden":false,"merged":[[4,2,5,2],[4,9,4,12],[4,6,5,6],[4,1,5,1],[4,0,5,0],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,7,5,7]]}
[null,null,null,null,"Save и +","личные","спонсор","спонсор 2"]
[null,null,{"$f":"LARGE(C4:C28300,1)","v":324},null,{"$f":"Бонусы!D11","v":21.632000000000001},{"$f":"Бонусы!F9","v":19.932000000000002},{"$f":"Бонусы!H9","v":49.830000000000005},{"$f":"Бонусы!J9","v":4.9830000000000005}]
[]
[]
["серия","серия","номер карты","ФИО","Дата регистрации","Дата рождения","Адрес","Телефон",null,"Дата покупки"]
[null,null,null,null,null,null,null,null,null,"Бонус","С покуп","к оплате","Бонус 2","Бонус 3"]
[0,0,200,"Иванов Иван Иваныч 0","2015-03-13","00.00.0010","город","8-900-00-10",null,25.1]
[null,null,"201,202,203,204"]
[0,0,"   205 (206, 207 ,208)","Иванов Иван Иваныч 1","2015-03-13","00.00.0000","адрес 1","8-900-00-00",null,1.6]
[0,0,209,"Иванов Иван Иваныч 2","2015-03-13","00.00.0001","адрес 2","8-900-00-01",null,7.7]
[0,0,212,"Иванов Иван Иваныч 3","2015-03-13","00.00.0002","адрес 3","8-900-00-02",null,1.7,"     "]
[0,0,214,"Иванов Иван Иваныч 4","2015-03-13","00.00.0003","адрес 4","8-900-00-03",null,3.6]
[0,0,215,"Иванов Иван Иваныч 5","2015-03-13","00.00.0004","адрес 5","8-900-00-04",null,3.2]
[0,0,216,"Иванов Иван Иваныч 6","2015-03-13","00.00.0005","адрес 6","8-900-00-05",null,1.2]
[0,216,240,"Иванов Иван Иваныч 7","2015-03-13","00.00.0006","адрес 7","8-900-00-06",null,4.5]
[0,0,217,"Иванов Иван Иваныч 8","2015-03-13","00.00.0007","адрес 8","8-900-00-07",null,16.7]
[0,217,218,"Иванов Иван Иваныч 9","2015-03-13","00.00.0008","адрес 9","8-900-00-08",null,4.0999999999999996]
[0,0,219,"Иванов Иван Иваныч 10","2015-03-13","00.00.0009","адрес 10","8-900-00-09",null,21.1]
[0,219,246,"Иванов Иван Иваныч 11","2015-03-13","00.00.0010","адрес 11","8-900-00-10",null,4.7]
[0,0,220,"Иванов Иван Иваныч 12","2015-03-13","00.00.0011","адрес 12","8-900-00-11",null,20.399999999999999]
[0,220,221,"Иванов Иван Иваныч 13","2015-03-13","00.00.0012","адрес 13","8-900-00-12",null,8.1999999999999993]
[0,0,222,"Иванов Иван Иваныч 14","2015-03-13","00.00.0013","адрес 14","8-900-00-13",null,5.5]
[0,0,223,"Иванов Иван Иваныч 15","2015-03-13","00.00.0014","адрес 15","8-900-00-14",null,2.1]
[0,223,237,"Иванов Иван Иваныч 16","2015-03-13","00.00.0015","адрес 16","8-900-00-15",null,0.7]
[0,0,224,"Иванов Иван Иваныч 17","2015-03-13","00.00.0016","адрес 17","8-900-00-16",null,12.3]
[0,0,225,"Иванов Иван Иваныч 18","2015-03-13","00.00.0017","адрес 18","8-900-00-17",null,22.3]
[0,0,226,"Иванов Иван Иваныч 19","2015-03-13","00.00.0018","адрес 19","8-900-00-18",null,2.6]
[0,0,227,"Иванов Иван Иваныч 20","2015-03-13","00.00.0019","адрес 20","8-900-00-19",null,14.1]
[0,0,228,"Иванов Иван Иваныч 21","2015-03-13","00.00.0020","адрес 21","8-900-00-20",null,13.8]
[0,0,229,"Иванов Иван Иваныч 22","2015-03-13","00.00.0021","адрес 22","8-900-00-21",null,5.48]
[0,0,230,"Иванов Иван Иваныч 23","2015-03-13","00.00.0022","адрес 23","8-900-00-22",null,102.8]
[0,230,231,"Иванов Иван Иваныч 24","2015-03-13","00.00.0023","адрес 24","8-900-00-23",null,5.2]
[0,0,232,"Иванов Иван Иваныч 25","2015-03-13","00.00.0024","адрес 25","8-900-00-24",null,21.7]
[0,0,233,"Иванов Иван Иваныч 26","2015-03-13","00.00.0025","адрес 26","8-900-00-25",null,10]
[0,0,234,"Иванов Иван Иваныч 27","2015-03-13","00.00.0026","адрес 27","8-900-00-26",null,5.0999999999999996]
[0,0,235,"Иванов Иван Иваныч 28","2015-03-13","00.00.0027","адрес 28","8-900-00-27",null,0.5]
[0,235,285,"Иванов Иван Иваныч 29","2015-03-13","00.00.0028","адрес 29","8-900-00-28",null,6.1]
[0,0,236,"Иванов Иван Иваныч 30","2015-03-13","00.00.0029","адрес 30","8-900-00-29",null,14.3]
[0,0,238,"Иванов Иван Иваныч 31","2015-03-13","00.00.0030","адрес 31","8-900-00-30",null,1.2]
[0,0,239,"Иванов Иван Иваныч 32","2015-03-13","00.00.0031","адрес 32","8-900-00-31",null,63]
[0,239,241,"Иванов Иван Иваныч 33","2015-03-13","00.00.0032","адрес 33","8-900-00-32",null,4.2]
[0,239,247,"Иванов Иван Иваныч 34","2015-03-13","00.00.0033","адрес 34","8-900-00-33"]
[0,239,242,"Иванов Иван Иваныч 35","2015-03-13","00.00.0034","адрес 35","8-900-00-34",null,0.9]
[0,239,250,"Иванов Иван Иваныч 36","2015-03-13","00.00.0035","адрес 36","8-900-00-35"]
[0,239,251,"Иванов Иван Иваныч 37","2015-03-13","00.00.0036","адрес 37","8-900-00-36"]
[0,239,252,"Иванов Иван Иваныч 38","2015-03-13","00.00.0037","адрес 38","8-900-00-37"]
[0,239,254,"Иванов Иван Иваныч 39","2015-03-13","00.00.0038","адрес 39","8-900-00-38"]
[0,239,255,"Иванов Иван Иваныч 40","2015-03-13","00.00.0039","адрес 40","8-900-00-39"]
[0,239,256,"Иванов Иван Иваныч 41","2015-03-13","00.00.0040","адрес 41","8-900-00-40"]
[0,239,257,"Иванов Иван Иваныч 42","2015-03-13","00.00.0041","адрес 42","8-900-00-41"]
[0,239,267,"Иванов Иван Иваныч 43","2015-03-13","00.00.0042","адрес 43","8-900-00-42",null,0.4]
[0,0,243,"Иванов Иван Иваныч 44","2015-03-13","00.00.0043","адрес 44","8-900-00-43",null,1.2]
[0,0,244,"Иванов Иван Иваныч 45","2015-03-13","00.00.0044","адрес 45","8-900-00-44",null,4.5999999999999996]
[0,0,245,"Иванов Иван Иваныч 46","2015-03-13","00.00.0045","адрес 46","8-900-00-45",null,5]
[0,0,248,"Иванов Иван Иваныч 47","2015-03-13","00.00.0046","адрес 47","8-900-00-46",null,17.3]
[0,0,249,"Иванов Иван Иваныч 48","2015-03-13","00.00.0047","адрес 48","8-900-00-47",null,6.5]
[0,0,253,"Иванов Иван Иваныч 49","2015-03-13","00.00.0048","адрес 49","8-900-00-48",null,9.3000000000000007]
[0,0,258,"Иванов Иван Иваныч 50","2015-03-13","00.00.0049","адрес 50","8-900-00-49",null,1.8]
[0,0,259,"Иванов Иван Иваныч 51","2015-03-13","00.00.0050","адрес 51","8-900-00-50",null,15.8]
[0,0,260,"Иванов Иван Иваныч 52","2015-03-13","00.00.0051","адрес 52","8-900-00-51",null,11.4]
[0,260,261,"Иванов Иван Иваныч 53","2015-03-13","00.00.0052","адрес 53","8-900-00-52",null,1.7]
[0,0,262,"Иванов Иван Иваныч 54","2015-03-13","00.00.0053","адрес 54","8-900-00-53",null,12.9]
[0,0,263,"Иванов Иван Иваныч 55","2015-03-13","00.00.0054","адрес 55","8-900-00-54",null,4]
[0,0,264,"Иванов Иван Иваныч 56","2015-03-13","00.00.0055","адрес 56","8-900-00-55",null,0.5]
[0,0,265,"Иванов Иван Иваныч 57","2015-03-13","00.00.0056","адрес 57","8-900-00-56",null,7]
[0,0,266,"Иванов Иван Иваныч 58","2015-03-13","00.00.0057","адрес 58","8-900-00-57",null,2.2000000000000002]
[0,0,268,"Иванов Иван Иваныч 59","2015-03-13","00.00.0058","адрес 59","8-900-00-58",null,5.8]
[0,0,269,"Иванов Иван Иваныч 60","2015-03-13","00.00.0059","адрес 60","8-900-00-59",null,39.9]
[0,269,270,"Иванов Иван Иваныч 61","2015-03-13","00.00.0060","адрес 61","8-900-00-60"]
[0,0,271,"Иванов Иван Иваныч 62","2015-03-13","00.00.0061","адрес 62","8-900-00-61",null,1.2]
[0,0,272,"Иванов Иван Иваныч 63","2015-03-13","00.00.0062","адрес 63","8-900-00-62",null,8.5]
[0,0,273,"Иванов Иван Иваныч 64","2015-03-13","00.00.0063","адрес 64","8-900-00-63",null,6.1]
[0,0,274,"Иванов Иван Иваныч 65","2015-03-13","00.00.0064","адрес 65","8-900-00-64",null,1.1000000000000001]
[0,0,275,"Иванов Иван Иваныч 66","2015-03-13","00.00.0065","адрес 66","8-900-00-65",null,4.8]
[0,0,276,"Иванов Иван Иваныч 67","2015-03-13","00.00.0066","адрес 67","8-900-00-66",null,14.9]
[0,0,277,"Иванов Иван Иваныч 68","2015-03-13","00.00.0067","адрес 68","8-900-00-67",null,18.5]
[0,0,278,"Иванов Иван Иваныч 69","2015-03-13","00.00.0068","адрес 69","8-900-00-68",null,24]
[0,278,289,"Иванов Иван Иваныч 70","2015-03-13","00.00.0069","адрес 70","8-900-00-69",null,1.9]
[0,278,309,"Иванов Иван Иваныч 71","2015-03-13","00.00.0070","адрес 71","8-900-00-70",null,24.7]
[278,309,310,"Иванов Иван Иваныч 72","2015-03-13","00.00.0071","адрес 72","8-900-00-71",null,3.5]
[0,278,313,"Иванов Иван Иваныч 73","2015-03-13","00.00.0072","адрес 73","8-900-00-72",null,6.3]
[0,278,314,"Иванов Иван Иваныч 74","2015-03-13","00.00.0073","адрес 74","8-900-00-73",null,0.4]
[0,0,279,"Иванов Иван Иваныч 75","2015-03-13","00.00.0074","адрес 75","8-900-00-74",null,9.5]
[0,0,280,"Иванов Иван Иваныч 76","2015-03-13","00.00.0075","адрес 76","8-900-00-75",null,1.1000000000000001]
[0,0,281,"Иванов Иван Иваныч 77","2015-03-13","00.00.0076","адрес 77","8-900-00-76",null,86.8]
[0,0,282,"Иванов Иван Иваныч 78","2015-03-13","00.00.0077","адрес 78","8-900-00-77",null,6.8]
[0,282,283,"Иванов Иван Иваныч 79","2015-03-13","00.00.0078","адрес 79","8-900-00-78",null,9.1999999999999993]
[0,0,284,"Иванов Иван Иваныч 80","2015-03-13","00.00.0079","адрес 80","8-900-00-79",null,28.9]
[0,0,286,"Иванов Иван Иваныч 81","2015-03-13","00.00.0080","адрес 81","8-900-00-80",null,7.3]
[0,0,287,"Иванов Иван Иваныч 82","2015-03-13","00.00.0081","адрес 82","8-900-00-81",null,24.1]
[0,287,304,"Иванов Иван Иваныч 83","2015-03-13","00.00.0082","адрес 83","8-900-00-82",null,8]
[0,0,288,"Иванов Иван Иваныч 84","2015-03-13","00.00.0083","адрес 84","8-900-00-83",null,3.4]
[0,0,290,"Иванов Иван Иваныч 85","2015-03-13","00.00.0084","адрес 85","8-900-00-84",null,1]
[0,0,291,"Иванов Иван Иваныч 86","2015-03-13","00.00.0085","адрес 86","8-900-00-85",null,9]
[0,0,292,"Иванов Иван Иваныч 87","2015-03-13","00.00.0086","адрес 87","8-900-00-86",null,7.3]
[0,0,293,"Иванов Иван Иваныч 88","2015-03-13","00.00.0087","адрес 88","8-900-00-87",null,10.7]
[0,0,294,"Иванов Иван Иваныч 89","2015-03-13","00.00.0088","адрес 89","8-900-00-88",null,17.7]
[0,0,295,"Иванов Иван Иваныч 90","2015-03-13","00.00.0089","адрес 90","8-900-00-89",null,8.6999999999999993]
[0,0,296,"Иванов Иван Иваныч 91","2015-03-13","00.00.0090","адрес 91","8-900-00-90",null,2]
[0,0,297,"Иванов Иван Иваныч 92","2015-03-13","00.00.0091","адрес 92","8-900-00-91",null,11.2]
[0,0,298,"Иванов Иван Иваныч 93","2015-03-13","00.00.0092","адрес 93","8-900-00-92",null,43.5]
[0,298,299,"Иванов Иван Иваныч 94","2015-03-13","00.00.0093","адрес 94","8-900-00-93",null,5.4]
[0,0,300,"Иванов Иван Иваныч 95","2015-03-13","00.00.0094","адрес 95","8-900-00-94",null,21.2]
[0,0,301,"Иванов Иван Иваныч 96","2015-03-13","00.00.0095","адрес 96","8-900-00-95",null,1.8]
[0,0,302,"Иванов Иван Иваныч 97","2015-03-13","00.00.0096","адрес 97","8-900-00-96",null,4.5]
[0,302,303,"Иванов Иван Иваныч 98","2015-03-13","00.00.0097","адрес 98","8-900-00-97",null,1.8]
[0,0,305,"Иванов Иван Иваныч 99","2015-03-13","00.00.0098","адрес 99","8-900-00-98",null,0.6]
[0,0,306,"Иванов Иван Иваныч 100","2015-03-13","00.00.0099","адрес 100","8-900-00-99",null,2.9]
[0,0,307,"Иванов Иван Иваныч 101","2015-03-13","00.00.0100","адрес 101","8-900-00-100",null,4.0999999999999996]
[0,0,308,"Иванов Иван Иваныч 102","2015-03-13","00.00.0101","адрес 102","8-900-00-101",null,9.4]
[0,0,311,"Иванов Иван Иваныч 103","2015-03-13","00.00.0102","адрес 103","8-900-00-102",null,60.5]
[0,311,312,"Иванов Иван Иваныч 104","2015-03-13","00.00.0103","адрес 104","8-900-00-103",null,21.6]
[0,0,315,"Иванов Иван Иваныч 105","2015-03-13","00.00.0104","адрес 105","8-900-00-104",null,31.5]
[0,0,316,"Иванов Иван Иваныч 106","2015-03-13","00.00.0105","адрес 106","8-900-00-105",null,1.3]
[0,0,317,"Иванов Иван Иваныч 107","2015-03-13","00.00.0106","адрес 107","8-900-00-106",null,9.3000000000000007]
[0,0,318,"Иванов Иван Иваныч 108","2015-03-13","00.00.0107","адрес 108","8-900-00-107",null,9.1999999999999993]
[0,0,319,"Иванов Иван Иваныч 109","2015-03-13","00.00.0108","адрес 109","8-900-00-108",null,4.5999999999999996]
[0,0,320,"Иванов Иван Иваныч 110","2015-03-13","00.00.0109","адрес 110","8-900-00-109",null,11.8]
[0,0,321,"Иванов Иван Иваныч 111","2015-03-13","00.00.0110","адрес 111","8-900-00-110"]
[0,0,322,"Иванов Иван Иваныч 112","2015-03-13","00.00.0111","адрес 112","8-900-00-111",null,13.7]
[0,0,323,"Иванов Иван Иваныч 113","2015-03-13","00.00.0112","адрес 113","8-900-00-112",null,11.3]
[0,0,324,"Иванов Иван Иваныч 114","2015-03-13","00.00.0113","адрес 114","8-900-00-113",null,8.6999999999999993]

{"sheet":"Бонусы","index":1,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,0,11,1],[0,0,1,0],[0,4,0,5],[0,6,0,7],[0,8,0,9],[0,3,1,3],[0,2,1,2],[0,1,1,1]]}
["наименование","сумма покупки","накопленный бонус","сумма к начислению","личные",null,"спонсор",null,"спонсор 2"]
[null,null,null,null,"%","руб","%","руб","%","руб"]
["мед, продукты пчеловодства",{"$f":"Касса!A15","v":500},{"$f":"MIN(B3,MIN(C$9,B$9*50%)-SUM(C$2:C2))","v":1.7},{"$f":"IF(C3>0,B3-C3,\"0\")","v":498.3},4,{"$f":"D3*E3%","v":19.932000000000002},10,{"$f":"D3*G3%","v":49.830000000000005},1,{"$f":"D3*I3%","v":4.9830000000000005}]
["чай, кофе",{"$f":"Касса!B15","v":700},{"$f":"MIN(B4,MIN(C$9,B$9*50%)-SUM(C$2:C3))","v":0},"0",4,0,10,0,1,0]
["специи",{"$f":"Касса!C15","v":0},{"$f":"MIN(B5,MIN(C$9,B$9*50%)-SUM(C$2:C4))","v":0},"0",4,0,10,0,1,0]
["посуда",{"$f":"Касса!D15","v":0},{"$f":"MIN(B6,MIN(C$9,B$9*50%)-SUM(C$2:C5))","v":0},"0",4,0,10,0,1,0]
["бальзамы, масла",{"$f":"Касса!E15","v":0},{"$f":"MIN(B7,MIN(C$9,B$9*50%)-SUM(C$2:C6))","v":0},"0",1,0,2.5,0,0.5,0]
["орехи, сухофрукты",{"$f":"Касса!F15","v":0},{"$f":"MIN(B8,MIN(C$9,B$9*50%)-SUM(C$2:C7))","v":0},"0",1,0,2.5,0,0.5,0]
["итого",{"$f":"SUM(B3:B8)","v":1200},{"$f":"C12","v":1.7},{"$f":"SUM(D3:D8)","v":498.3},null,{"$f":"SUM(F3:F8)","v":19.932000000000002},null,{"$f":"SUM(H3:H8)","v":49.830000000000005},null,{"$f":"SUM(J3:J8)","v":4.9830000000000005}]
["% оплаты бонусами",0.5,"оплатили бонусами:",{"$f":"SUM(C3:C8)","v":1.7}]
["можем оплатить бонусами",{"$f":"B9*B10","v":600},"Save и +",{"$f":"C9+F9","v":21.632000000000001}]
["Бонусный баланс",null,1.7]

{"sheet":"Касса","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Мед","Чай","Специи","Посуда","Бальзам","Орехи"]
[500,700]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"SUM(A2:A14)","v":500},700,0,0,0,0]