{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист 1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":2,"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":"Лист 1","index":0,"n_rows":10,"n_cols":54,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Это расчетом делается","Это вручную было сделано","Координаты","Latitude","Longitude","Distance","РАНГ","Что искать","Поискпоз","x2","y2","Расстояние","РАНГ","Что искать","Поискпоз","x3","y3","Расстояние","РАНГ","Что искать","Поискпоз","x4","y4","Расстояние","РАНГ","Что искать","Поискпоз","x5","y5","Расстояние","РАНГ","Что искать","Поискпоз","x6","y6","Расстояние","РАНГ","Что искать","Поискпоз","x7","y7","Расстояние","РАНГ","Что искать","Поискпоз","x8","y8","Расстояние","РАНГ","Что искать","Поискпоз","x9","y9","Расстояние"]
[null,1,"59.985255, 30.341011",{"$f":"--SUBSTITUTE(LEFTB(C2,9),\".\",\",\")","v":59.985255000000002},{"$f":"--SUBSTITUTE(RIGHTB(C2,9),\".\",\",\")","v":30.341011000000002},{"$f":"ROUND(ACOS(SIN(D$2*PI()/180)*SIN(D2*PI()/180)+COS(D$2*PI()/180)*COS(D2*PI()/180)*COS((E$2-E2)*PI()/180))*6371.21,3)+0.000001*ROW()","v":1.9999999999999999E-6},{"$f":"RANK(F2,F$2:F$10,1)","v":1},2,{"$f":"MATCH(H2,G$2:G$10,)","v":2},{"$f":"INDEX(D$2:D$10,I2)","v":59.979793999999998},{"$f":"INDEX(E$2:E$10,I2)","v":30.336252999999999},{"$f":"ROUND(ACOS(SIN(J$2*PI()/180)*SIN(J2*PI()/180)+COS(J$2*PI()/180)*COS(J2*PI()/180)*COS((K$2-K2)*PI()/180))*6371.21,3)+0.000001*ROW()","v":1.9999999999999999E-6},{"$f":"RANK(L2,L$2:L$10,1)","v":1},2,{"$f":"MATCH(N2,M$2:M$10,)","v":2},{"$f":"INDEX(J$2:J$10,O2)","v":59.979675},{"$f":"INDEX(K$2:K$10,O2)","v":30.357741000000001},{"$f":"ROUND(ACOS(SIN(P$2*PI()/180)*SIN(P2*PI()/180)+COS(P$2*PI()/180)*COS(P2*PI()/180)*COS((Q$2-Q2)*PI()/180))*6371.21,3)+0.000001*ROW()","v":1.9999999999999999E-6},{"$f":"RANK(R2,R$2:R$10,1)","v":1},2,{"$f":"MATCH(T2,S$2:S$10,)","v":2},{"$f":"INDEX(P$2:P$10,U2)","v":59.971522999999998},{"$f":"INDEX(Q$2:Q$10,U2)","v":30.319662999999998},{"$f":"ROUND(ACOS(SIN(V$2*PI()/180)*SIN(V2*PI()/180)+COS(V$2*PI()/180)*COS(V2*PI()/180)*COS((W$2-W2)*PI()/180))*6371.21,3)+0.000001*ROW()","v":1.9999999999999999E-6},{"$f":"RANK(X2,X$2:X$10,1)","v":1},2,{"$f":"MATCH(Z2,Y$2:Y$10,)","v":3},{"$f":"INDEX(V$2:V$10,AA2)","v":59.962679000000001},{"$f":"INDEX(W$2:W$10,AA2)","v":30.311135},{"$f":"ROUND(ACOS(SIN(AB$2*PI()/180)*SIN(AB2*PI()/180)+COS(AB$2*PI()/180)*COS(AB2*PI()/180)*COS((AC$2-AC2)*PI()/180))*6371.21,3)+0.000001*ROW()","v":1.9999999999999999E-6},{"$f":"RANK(AD2,AD$2:AD$10,1)","v":1},2,{"$f":"MATCH(AF2,AE$2:AE$10,)","v":3},{"$f":"INDEX(AB$2:AB$10,AG2)","v":59.950246},{"$f":"INDEX(AC$2:AC$10,AG2)","v":30.303008999999999},{"$f":"ROUND(ACOS(SIN(AH$2*PI()/180)*SIN(AH2*PI()/180)+COS(AH$2*PI()/180)*COS(AH2*PI()/180)*COS((AI$2-AI2)*PI()/180))*6371.21,3)+0.000001*ROW()","v":1.9999999999999999E-6},{"$f":"RANK(AJ2,AJ$2:AJ$10,1)","v":1},2,{"$f":"MATCH(AL2,AK$2:AK$10,)","v":2},{"$f":"INDEX(AH$2:AH$10,AM2)","v":59.957248},{"$f":"INDEX(AI$2:AI$10,AM2)","v":30.337662000000002},{"$f":"ROUND(ACOS(SIN(AN$2*PI()/180)*SIN(AN2*PI()/180)+COS(AN$2*PI()/180)*COS(AN2*PI()/180)*COS((AO$2-AO2)*PI()/180))*6371.21,3)+0.000001*ROW()","v":1.9999999999999999E-6},{"$f":"RANK(AP2,AP$2:AP$10,1)","v":1},2,{"$f":"MATCH(AR2,AQ$2:AQ$10,)","v":2},{"$f":"INDEX(AN$2:AN$10,AS2)","v":60.033982999999999},{"$f":"INDEX(AO$2:AO$10,AS2)","v":30.330392},{"$f":"ROUND(ACOS(SIN(AT$2*PI()/180)*SIN(AT2*PI()/180)+COS(AT$2*PI()/180)*COS(AT2*PI()/180)*COS((AU$2-AU2)*PI()/180))*6371.21,3)+0.000001*ROW()","v":1.9999999999999999E-6},{"$f":"RANK(AV2,AV$2:AV$10,1)","v":1},2,{"$f":"MATCH(AX2,AW$2:AW$10,)","v":2},{"$f":"INDEX(AT$2:AT$10,AY2)","v":59.844205000000002},{"$f":"INDEX(AU$2:AU$10,AY2)","v":30.344273000000001},{"$f":"ROUND(ACOS(SIN(AZ$2*PI()/180)*SIN(AZ2*PI()/180)+COS(AZ$2*PI()/180)*COS(AZ2*PI()/180)*COS((BA$2-BA2)*PI()/180))*6371.21,3)+0.000001*ROW()","v":1.9999999999999999E-6}]
[null,2,"59.979794, 30.336253",{"$f":"--SUBSTITUTE(LEFTB(C3,9),\".\",\",\")","v":59.979793999999998},{"$f":"--SUBSTITUTE(RIGHTB(C3,9),\".\",\",\")","v":30.336252999999999},{"$f":"ROUND(ACOS(SIN(D$2*PI()/180)*SIN(D3*PI()/180)+COS(D$2*PI()/180)*COS(D3*PI()/180)*COS((E$2-E3)*PI()/180))*6371.21,3)+0.000001*ROW()","v":0.66200300000000001},{"$f":"RANK(F3,F$2:F$10,1)","v":2},3,{"$f":"MATCH(H3,G$2:G$10,)","v":5},{"$f":"INDEX(D$2:D$10,I3)","v":59.979675},{"$f":"INDEX(E$2:E$10,I3)","v":30.357741000000001},{"$f":"ROUND(ACOS(SIN(J$2*PI()/180)*SIN(J3*PI()/180)+COS(J$2*PI()/180)*COS(J3*PI()/180)*COS((K$2-K3)*PI()/180))*6371.21,3)+0.000001*ROW()","v":1.1960029999999999},{"$f":"RANK(L3,L$2:L$10,1)","v":2},3,{"$f":"MATCH(N3,M$2:M$10,)","v":3},{"$f":"INDEX(J$2:J$10,O3)","v":59.971522999999998},{"$f":"INDEX(K$2:K$10,O3)","v":30.319662999999998},{"$f":"ROUND(ACOS(SIN(P$2*PI()/180)*SIN(P3*PI()/180)+COS(P$2*PI()/180)*COS(P3*PI()/180)*COS((Q$2-Q3)*PI()/180))*6371.21,3)+0.000001*ROW()","v":2.3040029999999998},{"$f":"RANK(R3,R$2:R$10,1)","v":2},3,{"$f":"MATCH(T3,S$2:S$10,)","v":4},{"$f":"INDEX(P$2:P$10,U3)","v":59.957248},{"$f":"INDEX(Q$2:Q$10,U3)","v":30.337662000000002},{"$f":"ROUND(ACOS(SIN(V$2*PI()/180)*SIN(V3*PI()/180)+COS(V$2*PI()/180)*COS(V3*PI()/180)*COS((W$2-W3)*PI()/180))*6371.21,3)+0.000001*ROW()","v":1.877003},{"$f":"RANK(X3,X$2:X$10,1)","v":3},3,{"$f":"MATCH(Z3,Y$2:Y$10,)","v":2},{"$f":"INDEX(V$2:V$10,AA3)","v":59.957248},{"$f":"INDEX(W$2:W$10,AA3)","v":30.337662000000002},{"$f":"ROUND(ACOS(SIN(AB$2*PI()/180)*SIN(AB3*PI()/180)+COS(AB$2*PI()/180)*COS(AB3*PI()/180)*COS((AC$2-AC3)*PI()/180))*6371.21,3)+0.000001*ROW()","v":1.5950029999999999},{"$f":"RANK(AD3,AD$2:AD$10,1)","v":3},3,{"$f":"MATCH(AF3,AE$2:AE$10,)","v":2},{"$f":"INDEX(AB$2:AB$10,AG3)","v":59.957248},{"$f":"INDEX(AC$2:AC$10,AG3)","v":30.337662000000002},{"$f":"ROUND(ACOS(SIN(AH$2*PI()/180)*SIN(AH3*PI()/180)+COS(AH$2*PI()/180)*COS(AH3*PI()/180)*COS((AI$2-AI3)*PI()/180))*6371.21,3)+0.000001*ROW()","v":2.0810029999999999},{"$f":"RANK(AJ3,AJ$2:AJ$10,1)","v":2},3,{"$f":"MATCH(AL3,AK$2:AK$10,)","v":3},{"$f":"INDEX(AH$2:AH$10,AM3)","v":60.033982999999999},{"$f":"INDEX(AI$2:AI$10,AM3)","v":30.330392},{"$f":"ROUND(ACOS(SIN(AN$2*PI()/180)*SIN(AN3*PI()/180)+COS(AN$2*PI()/180)*COS(AN3*PI()/180)*COS((AO$2-AO3)*PI()/180))*6371.21,3)+0.000001*ROW()","v":8.5420029999999993},{"$f":"RANK(AP3,AP$2:AP$10,1)","v":2},3,{"$f":"MATCH(AR3,AQ$2:AQ$10,)","v":3},{"$f":"INDEX(AN$2:AN$10,AS3)","v":59.844205000000002},{"$f":"INDEX(AO$2:AO$10,AS3)","v":30.344273000000001},{"$f":"ROUND(ACOS(SIN(AT$2*PI()/180)*SIN(AT3*PI()/180)+COS(AT$2*PI()/180)*COS(AT3*PI()/180)*COS((AU$2-AU3)*PI()/180))*6371.21,3)+0.000001*ROW()","v":21.117003},{"$f":"RANK(AV3,AV$2:AV$10,1)","v":2}]
[null,8,"60.033983, 30.330392",60.033982999999999,30.330392,5.4510039999999993,8,4,8,59.971522999999998,30.319662999999998,1.3030039999999998,3,4,4,59.962679000000001,30.311135,3.2090040000000002,4,4,3,59.962679000000001,30.311135,1.092004,2,4,4,59.950246,30.303008999999999,1.455004,2,4,4,60.033982999999999,30.330392,9.4350040000000011,3,4,4,59.844205000000002,30.344273000000001,12.576004000000001,3]
[null,7,"59.957248, 30.337662",59.957248,30.337662000000002,3.1200049999999999,6,5,6,59.962679000000001,30.311135,2.361005,4,5,5,59.957248,30.337662000000002,2.7330049999999999,3,5,5,59.950246,30.303008999999999,2.5410049999999997,4,5,5,60.033982999999999,30.330392,8.0010049999999993,4,5,5,59.844205000000002,30.344273000000001,12.014004999999999,4]
[null,3,"59.979675, 30.357741",59.979675,30.357741000000001,1.1190059999999999,3,6,4,59.957248,30.337662000000002,2.508006,5,6,6,59.950246,30.303008999999999,4.471006,5,6,6,60.033982999999999,30.330392,6.971006,5,6,6,59.844205000000002,30.344273000000001,13.303006000000002,5]
[null,5,"59.962679, 30.311135",59.962679000000001,30.311135,3.0110070000000002,5,7,9,59.950246,30.303008999999999,3.771007,6,7,7,60.033982999999999,30.330392,6.2270070000000004,6,7,7,59.844205000000002,30.344273000000001,14.224007,6]
[null,9,"59.844205, 30.344273",59.844205000000002,30.344273000000001,15.686007999999999,9,8,3,60.033982999999999,30.330392,6.0350080000000004,7,8,8,59.844205000000002,30.344273000000001,15.083008,7]
[null,4,"59.971523, 30.319663",59.971522999999998,30.319662999999998,1.935009,4,9,7,59.844205000000002,30.344273000000001,15.084009,8]
[null,6,"59.950246, 30.303009",59.950246,30.303008999999999,4.4300099999999993,7]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}