{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["2м"],"not_rendered":{"charts":0,"images":0,"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":"2м","index":0,"n_rows":153,"n_cols":24,"rows_kept":153,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,{"$f":"INT(MAX(G:G))","v":7}]
[null,"номер","фамилия","ДР","город"]
[null,346,"а",null,"Пенза",{"$f":"G3&\"|\"&COUNTIF(E$3:E3,E3)","v":"5,003|1"},{"$f":"ROUND(COUNTIF(E:E,E3)+MATCH(E3,E$1:E3,)/1000,3)","v":5.0030000000000001},{"$f":"IFERROR((1+$F$1-COLUMN(A1))*1000+LARGE($G:$G,IF(COLUMN(A1)>$F$1,\"\",ROW(H1)*$F$1-$F$1+COLUMN(A1))),\"\")","v":7007.0050000000001},{"$f":"IFERROR((1+$F$1-COLUMN(B1))*1000+LARGE($G:$G,IF(COLUMN(B1)>$F$1,\"\",ROW(I1)*$F$1-$F$1+COLUMN(B1))),\"\")","v":6007.0050000000001},5007.0050000000001,4007.0050000000001,3007.0050000000001,2007.0050000000001,1007.005,"","","",{"$f":"ROUND(MOD(LARGE(H:Q,ROW(R1))/1000,1)*1000,3)","v":7.0049999999999999},{"$f":"R3&\"|\"&COUNTIF(R$3:R3,R3)","v":"7,005|1"},{"$f":"MATCH(S3,F:F,)","v":5},{"$f":"INDEX(B:B,$T3)","v":345},{"$f":"INDEX(C:C,$T3)","v":"с"},0,"Калуга"]
[null,283,"в",null,"Тула",{"$f":"G4&\"|\"&COUNTIF(E$3:E4,E4)","v":"2,004|1"},{"$f":"ROUND(COUNTIF(E:E,E4)+MATCH(E4,E$1:E4,)/1000,3)","v":2.004},{"$f":"IFERROR((1+$F$1-COLUMN(A2))*1000+LARGE($G:$G,IF(COLUMN(A2)>$F$1,\"\",ROW(H2)*$F$1-$F$1+COLUMN(A2))),\"\")","v":7005.0129999999999},{"$f":"IFERROR((1+$F$1-COLUMN(B2))*1000+LARGE($G:$G,IF(COLUMN(B2)>$F$1,\"\",ROW(I2)*$F$1-$F$1+COLUMN(B2))),\"\")","v":6005.0129999999999},{"$f":"IFERROR((1+$F$1-COLUMN(C2))*1000+LARGE($G:$G,IF(COLUMN(C2)>$F$1,\"\",ROW(J2)*$F$1-$F$1+COLUMN(C2))),\"\")","v":5005.0129999999999},{"$f":"IFERROR((1+$F$1-COLUMN(D2))*1000+LARGE($G:$G,IF(COLUMN(D2)>$F$1,\"\",ROW(K2)*$F$1-$F$1+COLUMN(D2))),\"\")","v":4005.0129999999999},{"$f":"IFERROR((1+$F$1-COLUMN(E2))*1000+LARGE($G:$G,IF(COLUMN(E2)>$F$1,\"\",ROW(L2)*$F$1-$F$1+COLUMN(E2))),\"\")","v":3005.0129999999999},{"$f":"IFERROR((1+$F$1-COLUMN(F2))*1000+LARGE($G:$G,IF(COLUMN(F2)>$F$1,\"\",ROW(M2)*$F$1-$F$1+COLUMN(F2))),\"\")","v":2005.0029999999999},{"$f":"IFERROR((1+$F$1-COLUMN(G2))*1000+LARGE($G:$G,IF(COLUMN(G2)>$F$1,\"\",ROW(N2)*$F$1-$F$1+COLUMN(G2))),\"\")","v":1005.003},{"$f":"IFERROR((1+$F$1-COLUMN(H2))*1000+LARGE($G:$G,IF(COLUMN(H2)>$F$1,\"\",ROW(O2)*$F$1-$F$1+COLUMN(H2))),\"\")","v":""},{"$f":"IFERROR((1+$F$1-COLUMN(I2))*1000+LARGE($G:$G,IF(COLUMN(I2)>$F$1,\"\",ROW(P2)*$F$1-$F$1+COLUMN(I2))),\"\")","v":""},{"$f":"IFERROR((1+$F$1-COLUMN(J2))*1000+LARGE($G:$G,IF(COLUMN(J2)>$F$1,\"\",ROW(Q2)*$F$1-$F$1+COLUMN(J2))),\"\")","v":""},{"$f":"ROUND(MOD(LARGE(H:Q,ROW(R2))/1000,1)*1000,3)","v":5.0129999999999999},{"$f":"R4&\"|\"&COUNTIF(R$3:R4,R4)","v":"5,013|1"},{"$f":"MATCH(S4,F:F,)","v":13},{"$f":"INDEX(B:B,$T4)","v":72},{"$f":"INDEX(C:C,$T4)","v":"с"},{"$f":"INDEX(D:D,$T4)","v":0},{"$f":"INDEX(E:E,$T4)","v":"Курск"}]
[null,345,"с",null,"Калуга",{"$f":"G5&\"|\"&COUNTIF(E$3:E5,E5)","v":"7,005|1"},{"$f":"ROUND(COUNTIF(E:E,E5)+MATCH(E5,E$1:E5,)/1000,3)","v":7.0049999999999999},7005.0029999999997,6005.0029999999997,5005.0029999999997,4002.0079999999998,3002.0079999999998,2002.0060000000001,1002.006,"","","",5.0030000000000001,{"$f":"R5&\"|\"&COUNTIF(R$3:R5,R5)","v":"5,003|1"},3,346,"а",0,"Пенза"]
[null,141,"д",null,"Качканар",{"$f":"G6&\"|\"&COUNTIF(E$3:E6,E6)","v":"2,006|1"},{"$f":"ROUND(COUNTIF(E:E,E6)+MATCH(E6,E$1:E6,)/1000,3)","v":2.0059999999999998},7002.0039999999999,6002.0039999999999,5001.0230000000001,4001.0219999999999,3001.0070000000001,"","","","","",2.004,{"$f":"R6&\"|\"&COUNTIF(R$3:R6,R6)","v":"2,004|1"},4,283,"в",0,"Тула"]
[null,264,"а",null,"Серов",{"$f":"G7&\"|\"&COUNTIF(E$3:E7,E7)","v":"1,007|1"},{"$f":"ROUND(COUNTIF(E:E,E7)+MATCH(E7,E$1:E7,)/1000,3)","v":1.0069999999999999},"","","","","","","","","","",7.0049999999999999,{"$f":"R7&\"|\"&COUNTIF(R$3:R7,R7)","v":"7,005|2"},12,226,"в",0,"Калуга"]
[null,367,"в",null,"Екатеринбург",{"$f":"G8&\"|\"&COUNTIF(E$3:E8,E8)","v":"2,008|1"},{"$f":"ROUND(COUNTIF(E:E,E8)+MATCH(E8,E$1:E8,)/1000,3)","v":2.008},"","","","","","","","","","",5.0129999999999999,{"$f":"R8&\"|\"&COUNTIF(R$3:R8,R8)","v":"5,013|2"},14,341,"д",0,"Курск"]
[null,136,"с",null,"Качканар",{"$f":"G9&\"|\"&COUNTIF(E$3:E9,E9)","v":"2,006|2"},{"$f":"ROUND(COUNTIF(E:E,E9)+MATCH(E9,E$1:E9,)/1000,3)","v":2.0059999999999998},"","","","","","","","","","",5.0030000000000001,{"$f":"R9&\"|\"&COUNTIF(R$3:R9,R9)","v":"5,003|2"},11,380,"а",0,"Пенза"]
[null,368,"д",null,"Екатеринбург",{"$f":"G10&\"|\"&COUNTIF(E$3:E10,E10)","v":"2,008|2"},{"$f":"ROUND(COUNTIF(E:E,E10)+MATCH(E10,E$1:E10,)/1000,3)","v":2.008},"","","","","","","","","","",2.004,{"$f":"R10&\"|\"&COUNTIF(R$3:R10,R10)","v":"2,004|2"},16,34,"в",0,"Тула"]
[null,380,"а",null,"Пенза",{"$f":"G11&\"|\"&COUNTIF(E$3:E11,E11)","v":"5,003|2"},{"$f":"ROUND(COUNTIF(E:E,E11)+MATCH(E11,E$1:E11,)/1000,3)","v":5.0030000000000001},"","","","","","","","","","",7.0049999999999999,{"$f":"R11&\"|\"&COUNTIF(R$3:R11,R11)","v":"7,005|3"},18,225,"д",0,"Калуга"]
[null,226,"в",null,"Калуга",{"$f":"G12&\"|\"&COUNTIF(E$3:E12,E12)","v":"7,005|2"},{"$f":"ROUND(COUNTIF(E:E,E12)+MATCH(E12,E$1:E12,)/1000,3)","v":7.0049999999999999},"","","","","","","","","","",5.0129999999999999,{"$f":"R12&\"|\"&COUNTIF(R$3:R12,R12)","v":"5,013|3"},15,82,"а",0,"Курск"]
[null,72,"с",null,"Курск",{"$f":"G13&\"|\"&COUNTIF(E$3:E13,E13)","v":"5,013|1"},{"$f":"ROUND(COUNTIF(E:E,E13)+MATCH(E13,E$1:E13,)/1000,3)","v":5.0129999999999999},"","","","","","","","","","",5.0030000000000001,{"$f":"R13&\"|\"&COUNTIF(R$3:R13,R13)","v":"5,003|3"},17,384,"с",0,"Пенза"]
[null,341,"д",null,"Курск",{"$f":"G14&\"|\"&COUNTIF(E$3:E14,E14)","v":"5,013|2"},{"$f":"ROUND(COUNTIF(E:E,E14)+MATCH(E14,E$1:E14,)/1000,3)","v":5.0129999999999999},"","","","","","","","","","",1.0229999999999999,{"$f":"R14&\"|\"&COUNTIF(R$3:R14,R14)","v":"1,023|1"},23,318,"а",0,"Новоуральск"]
[null,82,"а",null,"Курск",{"$f":"G15&\"|\"&COUNTIF(E$3:E15,E15)","v":"5,013|3"},{"$f":"ROUND(COUNTIF(E:E,E15)+MATCH(E15,E$1:E15,)/1000,3)","v":5.0129999999999999},"","","","","","","","","","",7.0049999999999999,{"$f":"R15&\"|\"&COUNTIF(R$3:R15,R15)","v":"7,005|4"},20,343,"в",0,"Калуга"]
[null,34,"в",null,"Тула",{"$f":"G16&\"|\"&COUNTIF(E$3:E16,E16)","v":"2,004|2"},{"$f":"ROUND(COUNTIF(E:E,E16)+MATCH(E16,E$1:E16,)/1000,3)","v":2.004},"","","","","","","","","","",5.0129999999999999,{"$f":"R16&\"|\"&COUNTIF(R$3:R16,R16)","v":"5,013|4"},19,57,"а",0,"Курск"]
[null,384,"с",null,"Пенза",{"$f":"G17&\"|\"&COUNTIF(E$3:E17,E17)","v":"5,003|3"},{"$f":"ROUND(COUNTIF(E:E,E17)+MATCH(E17,E$1:E17,)/1000,3)","v":5.0030000000000001},"","","","","","","","","","",2.008,{"$f":"R17&\"|\"&COUNTIF(R$3:R17,R17)","v":"2,008|1"},8,367,"в",0,"Екатеринбург"]
[null,225,"д",null,"Калуга",{"$f":"G18&\"|\"&COUNTIF(E$3:E18,E18)","v":"7,005|3"},{"$f":"ROUND(COUNTIF(E:E,E18)+MATCH(E18,E$1:E18,)/1000,3)","v":7.0049999999999999},"","","","","","","","","","",1.022,{"$f":"R18&\"|\"&COUNTIF(R$3:R18,R18)","v":"1,022|1"},22,200,"д",0,"Лесной"]
[null,57,"а",null,"Курск",{"$f":"G19&\"|\"&COUNTIF(E$3:E19,E19)","v":"5,013|4"},{"$f":"ROUND(COUNTIF(E:E,E19)+MATCH(E19,E$1:E19,)/1000,3)","v":5.0129999999999999},"","","","","","","","","","",7.0049999999999999,{"$f":"R19&\"|\"&COUNTIF(R$3:R19,R19)","v":"7,005|5"},26,316,"д",0,"Калуга"]
[null,343,"в",null,"Калуга",{"$f":"G20&\"|\"&COUNTIF(E$3:E20,E20)","v":"7,005|4"},{"$f":"ROUND(COUNTIF(E:E,E20)+MATCH(E20,E$1:E20,)/1000,3)","v":7.0049999999999999},"","","","","","","","","","",5.0129999999999999,{"$f":"R20&\"|\"&COUNTIF(R$3:R20,R20)","v":"5,013|5"},25,73,"с",0,"Курск"]
[null,379,"с",null,"Пенза",{"$f":"G21&\"|\"&COUNTIF(E$3:E21,E21)","v":"5,003|4"},{"$f":"ROUND(COUNTIF(E:E,E21)+MATCH(E21,E$1:E21,)/1000,3)","v":5.0030000000000001},"","","","","","","","","","",2.008,{"$f":"R21&\"|\"&COUNTIF(R$3:R21,R21)","v":"2,008|2"},10,368,"д",0,"Екатеринбург"]
[null,200,"д",null,"Лесной",{"$f":"G22&\"|\"&COUNTIF(E$3:E22,E22)","v":"1,022|1"},{"$f":"ROUND(COUNTIF(E:E,E22)+MATCH(E22,E$1:E22,)/1000,3)","v":1.022},"","","","","","","","","","",1.0069999999999999,{"$f":"R22&\"|\"&COUNTIF(R$3:R22,R22)","v":"1,007|1"},7,264,"а",0,"Серов"]
[null,318,"а",null,"Новоуральск",{"$f":"G23&\"|\"&COUNTIF(E$3:E23,E23)","v":"1,023|1"},{"$f":"ROUND(COUNTIF(E:E,E23)+MATCH(E23,E$1:E23,)/1000,3)","v":1.0229999999999999},"","","","","","","","","","",7.0049999999999999,{"$f":"R23&\"|\"&COUNTIF(R$3:R23,R23)","v":"7,005|6"},27,340,"а",0,"Калуга"]
[null,381,"в",null,"Пенза",{"$f":"G24&\"|\"&COUNTIF(E$3:E24,E24)","v":"5,003|5"},{"$f":"ROUND(COUNTIF(E:E,E24)+MATCH(E24,E$1:E24,)/1000,3)","v":5.0030000000000001},"","","","","","","","","","",5.0030000000000001,{"$f":"R24&\"|\"&COUNTIF(R$3:R24,R24)","v":"5,003|4"},21,379,"с",0,"Пенза"]
[null,73,"с",null,"Курск",{"$f":"G25&\"|\"&COUNTIF(E$3:E25,E25)","v":"5,013|5"},{"$f":"ROUND(COUNTIF(E:E,E25)+MATCH(E25,E$1:E25,)/1000,3)","v":5.0129999999999999},"","","","","","","","","","",2.0059999999999998,{"$f":"R25&\"|\"&COUNTIF(R$3:R25,R25)","v":"2,006|1"},6,141,"д",0,"Качканар"]
[null,316,"д",null,"Калуга",{"$f":"G26&\"|\"&COUNTIF(E$3:E26,E26)","v":"7,005|5"},{"$f":"ROUND(COUNTIF(E:E,E26)+MATCH(E26,E$1:E26,)/1000,3)","v":7.0049999999999999},"","","","","","","","","","",7.0049999999999999,{"$f":"R26&\"|\"&COUNTIF(R$3:R26,R26)","v":"7,005|7"},28,342,"в",0,"Калуга"]
[null,340,"а",null,"Калуга",{"$f":"G27&\"|\"&COUNTIF(E$3:E27,E27)","v":"7,005|6"},{"$f":"ROUND(COUNTIF(E:E,E27)+MATCH(E27,E$1:E27,)/1000,3)","v":7.0049999999999999},"","","","","","","","","","",5.0030000000000001,{"$f":"R27&\"|\"&COUNTIF(R$3:R27,R27)","v":"5,003|5"},24,381,"в",0,"Пенза"]
[null,342,"в",null,"Калуга",{"$f":"G28&\"|\"&COUNTIF(E$3:E28,E28)","v":"7,005|7"},{"$f":"ROUND(COUNTIF(E:E,E28)+MATCH(E28,E$1:E28,)/1000,3)","v":7.0049999999999999},"","","","","","","","","","",2.0059999999999998,{"$f":"R28&\"|\"&COUNTIF(R$3:R28,R28)","v":"2,006|2"},9,136,"с",0,"Качканар"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,33]