{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["пример"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"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":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["ДАНО:",null,null,null,null,null,null,null,null,"НАДО:",null,null,null,null,"при помощи SQL:"]
["Клиент","Дата начала сделки","Дата окончания сделки 1","Дата окончания сделки 2","Срочность сделки 1","Срочность сделки 2","Валюта договора","Сумма сделки в валюте договора",null,"Клиент","Валюта договора","Средневзвешенная срочность по сумме сделки 1","Средневзвешенная срочность по сумме сделки 2",null,"Клиент","Валюта договора","Средневзвешенная срочность по сумме сделки 1","Средневзвешенная срочность по сумме сделки 2"]
["ООО БЕРЛИН","2014-06-03","2015-06-04","2015-05-04",{"$f":"C3-B3","v":366},{"$f":"D3-B3","v":335},"USD",807015.04,null,"ООО БЕРЛИН","RUR",{"$f":"SUMPRODUCT(H4:H6,E4:E6)/SUM(H4:H6)","v":155.51117738238932},{"$f":"SUMPRODUCT(H4:H6,F4:F6)/SUM(H4:H6)","v":179.03429860237162},null,"ООО БЕРЛИН","RUR",156,179]
["ООО БЕРЛИН","2010-02-09","2011-02-09","2011-06-09",{"$f":"C4-B4","v":365},{"$f":"D4-B4","v":485},"RUR",7314640,null,"ООО БЕРЛИН","USD",{"$f":"E4","v":365},{"$f":"F4","v":485},null,"ООО БЕРЛИН","USD",366,335]
["ООО БЕРЛИН","2010-09-30","2010-12-30","2010-12-30",91,91,"RUR",17000000,null,"ООО МОСКВА","EUR",{"$f":"SUMPRODUCT($H$15:$H$16,E15:E16)/SUM(H15:H16)","v":120},{"$f":"SUMPRODUCT($H$15:$H$16,F15:F16)/SUM(H15:H16)","v":151},null,"ООО ЛОНДОН","EUR",585,581]
["ООО БЕРЛИН","2010-09-30","2011-01-30","2011-01-30",122,{"$f":"D6-B6","v":122},"RUR",13000000,null,"ООО МОСКВА","RUR",{"$f":"SUMPRODUCT($H$7:$H$16,E7:E16)/SUM($H$7:$H$16)","v":159.54237288135593},{"$f":"SUMPRODUCT($H$7:$H$16,F7:F16)/SUM($H$7:$H$16)","v":171.0084745762712},null,"ООО ЛОНДОН","RUR",360,508]
["ООО МОСКВА","2010-10-01","2011-01-01","2011-01-11",92,102,"USD",6000000,null,"ООО МОСКВА","USD",{"$f":"E7","v":92},{"$f":"F7","v":102},null,"ООО ЛОНДОН","USD",365,366]
["ООО МОСКВА","2010-10-04","2011-02-04","2011-02-04",123,123,"RUR",2000000,null,null,null,null,null,null,"ООО МОСКВА","EUR",120,151]
["ООО МОСКВА","2010-12-27","2011-03-27","2011-05-27",90,151,"RUR",3500000,null,null,null,null,null,null,"ООО МОСКВА","RUR",176,184]
["ООО МОСКВА","2010-12-27","2011-03-27","2011-03-27",90,90,"RUR",13500000,null,null,null,null,null,null,"ООО МОСКВА","USD",92,102]
["ООО МОСКВА","2011-01-11","2011-04-11","2011-04-11",90,90,"RUR",6000000,null,null,null,null,null,null,"ООО ПАРИЖ","EUR",275,275]
["ООО МОСКВА","2011-01-24","2011-05-24","2011-06-24",120,151,"RUR",5000000,null,null,null,null,null,null,"ООО ПАРИЖ","RUR",577,581]
["ООО МОСКВА","2011-02-01","2011-06-01","2011-06-01",120,120,"RUR",2000000]
["ООО МОСКВА","2011-02-03","2012-02-03","2012-02-03",365,365,"RUR",13000000]
["ООО МОСКВА","2011-01-24","2011-05-24","2011-06-24",{"$f":"C15-B15","v":120},{"$f":"D15-B15","v":151},"EUR",5000000]
["ООО МОСКВА","2011-01-24","2011-05-24","2011-06-24",{"$f":"C16-B16","v":120},{"$f":"D16-B16","v":151},"EUR",3000000]
["ООО ПАРИЖ","2011-03-24","2011-06-24","2011-06-24",92,92,"RUR",3500000]
["ООО ПАРИЖ","2011-03-24","2011-06-24","2011-07-24",92,122,"RUR",3500000]
["ООО ПАРИЖ","2011-03-24","2011-06-24","2011-06-24",92,92,"RUR",3000000]
["ООО ПАРИЖ","2011-03-25","2011-06-25","2011-06-27",92,94,"RUR",4000000]
["ООО ПАРИЖ","2011-03-25","2011-06-25","2011-06-27",92,94,"RUR",3000000]
["ООО ПАРИЖ","2011-04-06","2011-07-06","2011-07-06",91,91,"RUR",3000000]
["ООО ПАРИЖ","2011-04-06","2011-07-06","2011-07-06",91,91,"RUR",3000000]
["ООО ПАРИЖ","2011-05-27","2011-08-27","2011-08-29",92,94,"RUR",13000000]
["ООО ПАРИЖ","2011-07-07","2015-06-16","2015-06-16",1440,1440,"RUR",24914019.75]
["ООО ПАРИЖ","2010-08-12","2011-05-12","2011-05-12",273,273,"EUR",3000000]
["ООО ПАРИЖ","2010-02-10","2010-07-31","2010-08-02",171,173,"RUR",8500000]
["ООО ПАРИЖ","2011-12-05","2012-11-25","2012-12-26",356,387,"RUR",2565919.5299999998]
["ООО ПАРИЖ","2011-12-20","2012-09-20","2012-09-20",275,275,"EUR",10000000]
["ООО ЛОНДОН","2012-08-16","2014-02-16","2014-02-16",549,549,"EUR",3700000]
["ООО ЛОНДОН","2012-08-29","2014-02-28","2014-02-28",548,548,"EUR",2400000]
["ООО ЛОНДОН","2012-09-04","2014-03-04","2014-03-04",546,546,"EUR",1400000]
["ООО ЛОНДОН","2012-09-12","2014-03-12","2014-04-12",546,577,"EUR",1320000]
["ООО ЛОНДОН","2013-01-23","2014-01-17","2014-01-17",359,359,"RUR",4341200.28]
["ООО ЛОНДОН","2013-07-04","2014-07-04","2014-07-04",365,365,"EUR",500000]
["ООО ЛОНДОН","2013-08-08","2014-08-08","2014-08-08",365,365,"EUR",500000]
["ООО ЛОНДОН","2013-08-29","2015-09-18","2015-10-18",750,780,"EUR",2000000]
["ООО ЛОНДОН","2013-09-25","2015-09-25","2015-09-25",730,730,"EUR",2000000]
["ООО ЛОНДОН","2013-09-30","2015-09-30","2015-01-30",730,487,"EUR",1000000]
["ООО ЛОНДОН","2014-04-30","2015-04-30","2015-05-01",365,366,"USD",320275.24]
["ООО ЛОНДОН","2014-01-29","2015-07-29","2015-07-29",546,546,"EUR",2000000]
["ООО ЛОНДОН","2014-02-06","2015-08-06","2015-08-06",546,546,"EUR",1500000]
["ООО ЛОНДОН","2014-02-07","2015-08-07","2015-08-07",546,546,"EUR",2000000]
["ООО ЛОНДОН","2014-02-10","2015-02-05","2015-08-05",360,541,"RUR",26795457.579999998]
["ООО ЛОНДОН","2014-02-20","2015-10-18","2015-10-18",605,605,"EUR",1200000]
["ООО ЛОНДОН","2014-02-25","2015-10-18","2015-10-18",600,600,"EUR",730000]
["ООО ЛОНДОН","2014-03-06","2015-09-18","2015-10-18",561,591,"EUR",700000]
["ООО ЛОНДОН","2014-05-23","2015-05-23","2015-05-26",365,368,"RUR",1587229.51]
["ООО ЛОНДОН","2014-03-17","2015-09-17","2015-10-17",549,579,"EUR",870000]