{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[45,2,45,11],[42,4,42,11],[43,4,43,11],[44,4,44,11],[42,2,42,3],[43,2,43,3],[44,2,44,3],[0,2,0,11],[38,2,38,4],[39,2,39,4],[41,2,41,11],[40,2,40,4],[40,5,40,11]]}
[null,null,"Расчет начальной (максимальной) цены договора (начальной (максимальной) цены единицы товара, работы, услуги) методом сопоставления рыночных цен (анализ рынка)"]
[null,null,"№ п/п","Наименование товара, работы, услуги","Количество товара, объем работы, услуги","Коммерческое предложение № ______ от _________20___ г.","Коммерческое предложение № ______ от _________20___ г.","Коммерческое предложение № ______ от _________20___ г.","Коммерческое предложение № ______ от _________20___ г.","Коммерческое предложение № ______ от _________20___ г.","Среднее значение цены за единицу товара, работы, услуги, руб.","Минимальное значение цены за единицу товара, работы, услуги, руб."]
[null,null,1,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(AVERAGE(F3:J3),2),0)","v":0},{"$f":"MIN(F3:J3)","v":0}]
[null,null,2,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(AVERAGE(F4:J4),2),0)","v":0},{"$f":"MIN(F4:J4)","v":0}]
[null,null,3,null,null,null,null,null,null,null,0,0]
[null,null,4,null,null,null,null,null,null,null,0,0]
[null,null,5,null,null,null,null,null,null,null,0,0]
[null,null,6,null,null,null,null,null,null,null,0,0]
[null,null,7,null,null,null,null,null,null,null,0,0]
[null,null,8,null,null,null,null,null,null,null,0,0]
[null,null,9,null,null,null,null,null,null,null,0,0]
[null,null,10,null,null,null,null,null,null,null,0,0]
[null,null,11,null,null,null,null,null,null,null,0,0]
[null,null,12,null,null,null,null,null,null,null,0,0]
[null,null,13,null,null,null,null,null,null,null,0,0]
[null,null,14,null,null,null,null,null,null,null,0,0]
[null,null,15,null,null,null,null,null,null,null,0,0]
[null,null,16,null,null,null,null,null,null,null,0,0]
[null,null,17,null,null,null,null,null,null,null,0,0]
[null,null,18,null,null,null,null,null,null,null,0,0]
[null,null,19,null,null,null,null,null,null,null,0,0]
[null,null,20,null,null,null,null,null,null,null,0,0]
[null,null,21,null,null,null,null,null,null,null,0,0]
[null,null,22,null,null,null,null,null,null,null,0,0]
[null,null,23,null,null,null,null,null,null,null,0,0]
[null,null,24,null,null,null,null,null,null,null,0,0]
[null,null,25,null,null,null,null,null,null,null,0,0]
[null,null,26,null,null,null,null,null,null,null,0,0]
[null,null,27,null,null,null,null,null,null,null,0,0]
[null,null,28,null,null,null,null,null,null,null,0,0]
[null,null,29,null,null,null,null,null,null,null,0,0]
[null,null,30,null,null,null,null,null,null,null,0,0]
[null,null,31,null,null,null,null,null,null,null,0,0]
[null,null,32,null,null,null,null,null,null,null,0,0]
[null,null,33,null,null,null,null,null,null,null,0,0]
[null,null,34,null,null,null,null,null,null,null,0,0]
[null,null,35,null,null,null,null,null,null,null,0,0]
[null,null,"…",null,null,null,null,null,null,null,0,0]
[null,null,"Итого",null,null,{"$f":"IF(SUMPRODUCT($E$3:$E$38,F3:F38)=0,\"\",SUMPRODUCT($E$3:$E$38,F3:F38))","v":""},{"$f":"IF(SUMPRODUCT($E$3:$E$38,G3:G38)=0,\"\",SUMPRODUCT($E$3:$E$38,G3:G38))","v":""},{"$f":"IF(SUMPRODUCT($E$3:$E$38,H3:H38)=0,\"\",SUMPRODUCT($E$3:$E$38,H3:H38))","v":""},{"$f":"IF(SUMPRODUCT($E$3:$E$38,I3:I38)=0,\"\",SUMPRODUCT($E$3:$E$38,I3:I38))","v":""},{"$f":"IF(SUMPRODUCT($E$3:$E$38,J3:J38)=0,\"\",SUMPRODUCT($E$3:$E$38,J3:J38))","v":""}]
[null,null,"Коэффициент отклонения от минимального значения цены",null,null,{"$f":"IFERROR(((F39-MIN(E39:I39))/MIN(E39:I39)),0)","v":0},{"$f":"IFERROR(((G39-MIN(F39:J39))/MIN(F39:J39)),0)","v":0},{"$f":"IFERROR(((H39-MIN(F39:J39))/MIN(F39:J39)),0)","v":0},{"$f":"IFERROR(((I39-MIN(F39:J39))/MIN(F39:J39)),0)","v":0},{"$f":"IFERROR(((J39-MIN(F39:J39))/MIN(F39:J39)),0)","v":0},"-","-"]
[null,null,"Количество ценовых значений",null,null,{"$f":"IF(F39=\"\",0,1)+IF(G39=\"\",0,1)+IF(H39=\"\",0,1)+IF(I39=\"\",0,1)+IF(J39=\"\",0,1)","v":0}]
[null,null,"Вариант обоснования начальной (максимальной) цены договора (начальной (максимальной) цены единицы товара, работы, услуги) выбраный Заказчиком: "]
[null,null,"Cреднеарифметическое значение цен",null,{"$f":"IFERROR(SUMPRODUCT(E3:E38,K3:K38),0)","v":0}]
[null,null,"Минимальное значение цен",null,{"$f":"IFERROR(SUMPRODUCT(E3:E38,L3:L38),0)","v":0}]
[null,null,"Минимальное значение цен по коммерческому предложению",null,{"$f":"MIN(F39:J39)","v":0}]
[null,null,{"$f":"IF(MAX(F40:J40)>=25%,\"для обоснования начальной (максимальной) цены договора может использоваться только минимальное значение цен (минимальное значение цен по коммерческому предложению), так как коэффициент отклонения от минимального значения цен превышает 25%\",\"для обоснования начальной (максимальной) цены договора могут использоваться минимальное значение цен либо среднеарифметическое значение цен (за исключением закупок у единственного поставщика (подрядчика, исполнителя))\")","v":"для обоснования начальной (максимальной) цены договора могут использоваться минимальное значение цен либо среднеарифметическое значение цен (за исключением закупок у единственного поставщика (подрядчика, исполнителя))"}]
[]
[null,null,null,"Примечание","Выделено цветом"]
[null,null,null,"Ввод данных"]
[null,null,null,"Данные формируются автоматически"]

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

{"sheet":"Лист3","index":2,"n_rows":196,"n_cols":6,"rows_kept":196,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,132.6,85,87]
[null,null,null,142.80000000000001,105,108]
[null,null,null,220.8,220,224]
[null,null,null,230.4,164,168]
[null,null,null,230.4,300,306]
[null,null,null,46.8,50,51]
[null,null,null,36,44,45]
[null,null,null,28.8,23,24]
[null,null,null,15.6,30,31]
[null,null,null,172.8,185,189]
[null,null,null,357,455,464]
[null,null,null,122.4,80,82]
[null,null,null,21.6,14,15]
[null,null,null,48,50,51]
[null,null,null,318,325,332]
[null,null,null,426,430,438]
[null,null,null,444,1100,1122]
[null,null,null,3096,1850,1883]
[null,null,null,636,640,653]
[null,null,null,798,2350,2396]
[null,null,null,1932,1750,1784]
[null,null,null,3864,3200,3262]
[null,null,null,912,1300,1326]
[null,null,null,816,1300,1323]
[null,null,null,1800,1600,1631]
[null,null,null,1854,2550,2600]
[null,null,null,819.6,800,816]
[null,null,null,498,540,551]
[null,null,null,2442,980,998]
[null,null,null,408,340,347]
[null,null,null,61.2,38,39]
[null,null,null,51,40,41]
[null,null,null,132,115,118]
[null,null,null,126,76,78]
[null,null,null,127.2,310,317]
[null,null,null,230.4,210,215]
[null,null,null,150,112,114]
[null,null,null,78,65,67]
[null,null,null,2602.8000000000002,2500,2549]
[null,null,null,810,700,714]
[null,null,null,360,327,334]
[null,null,null,405,306,312]
[null,null,null,402,291,297]
[null,null,null,2160,2550,2600]
[null,null,null,116.4,450,459]
[null,null,null,36,75,77]
[null,null,null,3,2.5,3]
[null,null,null,9,5.9,7]
[null,null,null,3.6,2.7,3]
[null,null,null,2.4,2.2000000000000002,3]
[null,null,null,34.200000000000003,30.4,31]
[null,null,null,13.2,12,13]
[null,null,null,86.4,95,97]
[null,null,null,270,330,336]
[null,null,null,75.599999999999994,52,54]
[null,null,null,186,155,158]
[null,null,null,94.8,131,134]
[null,null,null,72,65,67]
[null,null,null,103.2,38,39]
[null,null,null,75.599999999999994,50,51]
[null,null,null,211.2,220,224]
[null,null,null,129.6,85,87]
[null,null,null,57.6,51,52]
[null,null,null,103.2,110,113]
[null,null,null,112.8,160,164]
[null,null,null,297.60000000000002,280,286]
[null,null,null,315,318,325]
[null,null,null,144,115,118]
[null,null,null,1896,1330,1356]
[null,null,null,618,650,663]
[null,null,null,178.2,122,125]
[null,null,null,1706.4,1700,1733]
[null,null,null,3564,4040,4119]
[null,null,null,2066.4,1800,1835]
[null,null,null,186,350,357]
[null,null,null,270,200,204]
[null,null,null,1692,2000,2036]
[null,null,null,57.6,48,49]
[null,null,null,36,35,36]
[null,null,null,220.8,165,169]
[null,null,null,126,100,102]
[null,null,null,993.6,850,867]
[null,null,null,2214,1850,1886]
[null,null,null,17760,12385,12603]
[null,null,null,480,276,282]
[null,null,null,135,150,153]
[null,null,null,162,350,357]
[null,null,null,1902,1650,1679]
[null,null,null,224.4,320,326]
[null,null,null,78,67,69]
[null,null,null,223.2,180,184]
[null,null,null,182.4,623,636]
[null,null,null,124.2,130,133]
[null,null,null,15,13.5,14]
[null,null,null,12,13.5,14]
[null,null,null,717.6,550,560]
[null,null,null,37.200000000000003,49.3,51]
[null,null,null,78,65,67]
[null,null,null,621,2200,2239]
[null,null,null,945,620,633]
[null,null,null,144,99,101]
[null,null,null,60,68,70]
[null,null,null,60,68,70]
[null,null,null,306,185,189]
[null,null,null,588,300,306]
[null,null,null,960,491,501]
[null,null,null,626.4,650,662]
[null,null,null,180,155,158]
[null,null,null,2802,1700,1733]
[null,null,null,159.6,120,123]
[null,null,null,2190,2450,2498]
[null,null,null,2550,2380,2427]
[null,null,null,28.8,25.1,26]
[null,null,null,62.4,52.7,54]
[null,null,null,216,185,189]
[null,null,null,73.2,55,57]
[null,null,null,109.2,105,108]
[null,null,null,252,157,161]
[null,null,null,264,230,235]
[null,null,null,180,210,215]
[null,null,null,54,70,72]
[null,null,null,583.20000000000005,360,367]
[null,null,null,162,130,133]
[null,null,null,120,81.5,84]
[null,null,null,330,296,302]
[null,null,null,114,125,128]
[null,null,null,192,190,194]
[null,null,null,132,140,143]
[null,null,null,207.6,105,108]
[null,null,null,321.60000000000002,170,174]
[null,null,null,138,150,153]
[null,null,null,108,125,128]
[null,null,null,558,645,658]
[null,null,null,597.6,747.5,762]
[null,null,null,360,1900,1937]
[null,null,null,144,650,663]
[null,null,null,276,237,242]
[null,null,null,1080,1120,1140]
[null,null,null,438,266,272]
[null,null,null,180,160,164]
[null,null,null,718.2,830,847]
[null,null,null,294,400,408]
[null,null,null,254.4,232,237]
[null,null,null,540,850,867]
[null,null,null,4.8,5,6]
[null,null,null,10.199999999999999,9,10]
[null,null,null,28.8,29,30]
[null,null,null,24,27,28]
[null,null,null,2244,2540,2590]
[null,null,null,240,250,255]
[null,null,null,240,540,550]
[null,null,null,414,596,608]
[null,null,null,134.4,174,178]
[null,null,null,318,239.5,245]
[null,null,null,456,324,331]
[null,null,null,32.4,27,28]
[null,null,null,150,100,102]
[null,null,null,702,1400,1425]
[null,null,null,240,980,999]
[null,null,null,45,55,57]
[null,null,null,64.8,81,83]
[null,null,null,72,103,105]
[null,null,null,192,290,296]
[null,null,null,302.39999999999998,359,366]
[null,null,null,240,239,244]
[null,null,null,201.6,91.25,94]
[null,null,null,240,97.5,100]
[null,null,null,235.2,300,306]
[null,null,null,199.8,210,215]
[null,null,null,15,122.81,126]
[null,null,null,14.4,145,148]
[null,null,null,259.2,279,285]
[null,null,null,307.2,380,387]
[null,null,null,68.400000000000006,35,36]
[null,null,null,134.4,249,254]
[null,null,null,398.4,301,307]
[null,null,null,297,233,238]
[null,null,null,1350,1490,1519]
[null,null,null,1350,2315,2360]
[null,null,null,1350,2315,2360]
[null,null,null,216,88.79,91]
[null,null,null,660,423,431]
[null,null,null,660,419,428]
[null,null,null,972,826,842]
[null,null,null,972,720,733]
[null,null,null,1047.5999999999999,583,595]
[null,null,null,1047.5999999999999,689,703]
[null,null,null,97.2,78,80]
[null,null,null,96,78,80]
[null,null,null,394.2,369,377]
[null,null,null,297.60000000000002,290,296]