{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":2},"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":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["часов",6,2000,{"$f":"B1*C1","v":12000}]
["людей",{"$f":"COUNTA(B8:B19)","v":11},100,{"$f":"C2*MAX(B2-8,0)","v":300}]
[null,null,"\"цена вопроса\"",{"$f":"SUM(D1:D2)","v":12300}]
[null,null,"\"цена вопроса\" за час на человека",{"$f":"D3/SUM(C8:C19)","v":198.38709677419354}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПРОВЕРКА"]
[]
[null,"Кто","Сколько","Уже внес","Внести",null,"Кому","Сколько",null,"Кто","Сколько",null,"Кто","Кому","Сколько",null,null,"Названия строк","Сумма по полю Сколько"]
[1,"Вася",6,4000,{"$f":"IF(ISTEXT(B8),$D$4*C8-D8,\"\")","v":-2809.677419354839},null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(SMALL(IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),ROW(A1)),IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),0)),\"\")","v":"Петя"},{"$f":"IFERROR(-INDEX($E$8:$E$19,MATCH(G8,$B$8:$B$19,0)),\"\")","v":2809.677419354839},null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(LARGE(IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),ROW(A1)),IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),0)),\"\")","v":"Аня"},{"$f":"IFERROR(INDEX($E$8:$E$19,MATCH(J8,$B$8:$B$19,0)),\"\")","v":1190.3225806451612},null,{"$f":"J8","v":"Аня"},{"$f":"G8","v":"Петя"},{"$f":"MIN(H8,K8)","v":1190.3225806451612},null,null,"Вася",2809.677419354839]
[2,"Петя",6,4000,{"$f":"IF(ISTEXT(B9),$D$4*C9-D9,\"\")","v":-2809.677419354839},null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(SMALL(IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),ROW(A2)),IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),0)),\"\")","v":"Вася"},{"$f":"IFERROR(-INDEX($E$8:$E$19,MATCH(G9,$B$8:$B$19,0)),\"\")","v":2809.677419354839},null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(LARGE(IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),ROW(A2)),IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),0)),\"\")","v":"Люба"},{"$f":"IFERROR(INDEX($E$8:$E$19,MATCH(J9,$B$8:$B$19,0)),\"\")","v":1190.3225806451612},null,{"$f":"IFERROR(IF(SUMIF($M$7:M8,M8,$O$7:O8)<INDEX($K$8:$K$19,MATCH(M8,$J$8:$J$19,0)),M8,INDEX($J$8:$J$19,MATCH(M8,$J$8:$J$19,0)+1)),\"\")","v":"Люба"},{"$f":"IFERROR(IF(SUMIF($N$7:N8,N8,$O$7:O8)<INDEX($H$8:$H$19,MATCH(N8,$G$8:$G$19,0)),N8,INDEX($G$8:$G$19,MATCH(N8,$G$8:$G$19,0)+1)),\"\")","v":"Петя"},{"$f":"IFERROR(MIN(INDEX($K$8:$K$19,MATCH(M9,$J$8:$J$19,0))-SUMIF($M$7:M8,M9,$O$7:O8),INDEX($H$8:$H$19,MATCH(N9,$G$8:$G$19,0))-SUMIF($N$7:N8,N9,$O$7:O8)),\"\")","v":1190.3225806451612},null,null,"Оля",809.67741935483741]
[3,"Коля",6,500,690.32258064516122,null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(SMALL(IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),ROW(A3)),IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),0)),\"\")","v":"Оля"},809.67741935483878,null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(LARGE(IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),ROW(A3)),IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),0)),\"\")","v":"Наташа"},1190.3225806451612,null,{"$f":"IFERROR(IF(SUMIF($M$7:M9,M9,$O$7:O9)<INDEX($K$8:$K$19,MATCH(M9,$J$8:$J$19,0)),M9,INDEX($J$8:$J$19,MATCH(M9,$J$8:$J$19,0)+1)),\"\")","v":"Наташа"},{"$f":"IFERROR(IF(SUMIF($N$7:N9,N9,$O$7:O9)<INDEX($H$8:$H$19,MATCH(N9,$G$8:$G$19,0)),N9,INDEX($G$8:$G$19,MATCH(N9,$G$8:$G$19,0)+1)),\"\")","v":"Петя"},{"$f":"IFERROR(MIN(INDEX($K$8:$K$19,MATCH(M10,$J$8:$J$19,0))-SUMIF($M$7:M9,M10,$O$7:O9),INDEX($H$8:$H$19,MATCH(N10,$G$8:$G$19,0))-SUMIF($N$7:N9,N10,$O$7:O9)),\"\")","v":429.03225806451655},null,null,"Петя",2809.677419354839]
[4,"Настя",2,null,396.77419354838707,null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(SMALL(IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),ROW(A4)),IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),0)),\"\")","v":""},"",null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(LARGE(IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),ROW(A4)),IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),0)),\"\")","v":"Ира"},890.32258064516122,null,{"$f":"IFERROR(IF(SUMIF($M$7:M10,M10,$O$7:O10)<INDEX($K$8:$K$19,MATCH(M10,$J$8:$J$19,0)),M10,INDEX($J$8:$J$19,MATCH(M10,$J$8:$J$19,0)+1)),\"\")","v":"Наташа"},{"$f":"IFERROR(IF(SUMIF($N$7:N10,N10,$O$7:O10)<INDEX($H$8:$H$19,MATCH(N10,$G$8:$G$19,0)),N10,INDEX($G$8:$G$19,MATCH(N10,$G$8:$G$19,0)+1)),\"\")","v":"Вася"},{"$f":"IFERROR(MIN(INDEX($K$8:$K$19,MATCH(M11,$J$8:$J$19,0))-SUMIF($M$7:M10,M11,$O$7:O10),INDEX($H$8:$H$19,MATCH(N11,$G$8:$G$19,0))-SUMIF($N$7:N10,N11,$O$7:O10)),\"\")","v":761.29032258064467},null,null,"Общий итог",6429.0322580645152]
[5,"Таня",6,500,690.32258064516122,null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(SMALL(IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),ROW(A5)),IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),0)),\"\")","v":""},"",null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(LARGE(IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),ROW(A5)),IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),0)),\"\")","v":"Коля"},690.32258064516122,null,{"$f":"IFERROR(IF(SUMIF($M$7:M11,M11,$O$7:O11)<INDEX($K$8:$K$19,MATCH(M11,$J$8:$J$19,0)),M11,INDEX($J$8:$J$19,MATCH(M11,$J$8:$J$19,0)+1)),\"\")","v":"Ира"},{"$f":"IFERROR(IF(SUMIF($N$7:N11,N11,$O$7:O11)<INDEX($H$8:$H$19,MATCH(N11,$G$8:$G$19,0)),N11,INDEX($G$8:$G$19,MATCH(N11,$G$8:$G$19,0)+1)),\"\")","v":"Вася"},{"$f":"IFERROR(MIN(INDEX($K$8:$K$19,MATCH(M12,$J$8:$J$19,0))-SUMIF($M$7:M11,M12,$O$7:O11),INDEX($H$8:$H$19,MATCH(N12,$G$8:$G$19,0))-SUMIF($N$7:N11,N12,$O$7:O11)),\"\")","v":890.32258064516122}]
[6,"Юля",6,1000,190.32258064516122,null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(SMALL(IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),ROW(A6)),IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),0)),\"\")","v":""},"",null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(LARGE(IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),ROW(A6)),IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),0)),\"\")","v":"Таня"},690.32258064516122,null,{"$f":"IFERROR(IF(SUMIF($M$7:M12,M12,$O$7:O12)<INDEX($K$8:$K$19,MATCH(M12,$J$8:$J$19,0)),M12,INDEX($J$8:$J$19,MATCH(M12,$J$8:$J$19,0)+1)),\"\")","v":"Коля"},{"$f":"IFERROR(IF(SUMIF($N$7:N12,N12,$O$7:O12)<INDEX($H$8:$H$19,MATCH(N12,$G$8:$G$19,0)),N12,INDEX($G$8:$G$19,MATCH(N12,$G$8:$G$19,0)+1)),\"\")","v":"Вася"},{"$f":"IFERROR(MIN(INDEX($K$8:$K$19,MATCH(M13,$J$8:$J$19,0))-SUMIF($M$7:M12,M13,$O$7:O12),INDEX($H$8:$H$19,MATCH(N13,$G$8:$G$19,0))-SUMIF($N$7:N12,N13,$O$7:O12)),\"\")","v":690.32258064516122}]
[7,"Аня",6,null,1190.3225806451612,null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(SMALL(IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),ROW(A7)),IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),0)),\"\")","v":""},"",null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(LARGE(IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),ROW(A7)),IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),0)),\"\")","v":"Настя"},396.77419354838707,null,{"$f":"IFERROR(IF(SUMIF($M$7:M13,M13,$O$7:O13)<INDEX($K$8:$K$19,MATCH(M13,$J$8:$J$19,0)),M13,INDEX($J$8:$J$19,MATCH(M13,$J$8:$J$19,0)+1)),\"\")","v":"Таня"},{"$f":"IFERROR(IF(SUMIF($N$7:N13,N13,$O$7:O13)<INDEX($H$8:$H$19,MATCH(N13,$G$8:$G$19,0)),N13,INDEX($G$8:$G$19,MATCH(N13,$G$8:$G$19,0)+1)),\"\")","v":"Вася"},{"$f":"IFERROR(MIN(INDEX($K$8:$K$19,MATCH(M14,$J$8:$J$19,0))-SUMIF($M$7:M13,M14,$O$7:O13),INDEX($H$8:$H$19,MATCH(N14,$G$8:$G$19,0))-SUMIF($N$7:N13,N14,$O$7:O13)),\"\")","v":467.74193548387211},null,null,"Названия строк","Сумма по полю Сколько"]
[8,"Люба",6,null,1190.3225806451612,null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(SMALL(IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),ROW(A8)),IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),0)),\"\")","v":""},"",null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(LARGE(IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),ROW(A8)),IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),0)),\"\")","v":"Юля"},190.32258064516122,null,{"$f":"IFERROR(IF(SUMIF($M$7:M14,M14,$O$7:O14)<INDEX($K$8:$K$19,MATCH(M14,$J$8:$J$19,0)),M14,INDEX($J$8:$J$19,MATCH(M14,$J$8:$J$19,0)+1)),\"\")","v":"Таня"},{"$f":"IFERROR(IF(SUMIF($N$7:N14,N14,$O$7:O14)<INDEX($H$8:$H$19,MATCH(N14,$G$8:$G$19,0)),N14,INDEX($G$8:$G$19,MATCH(N14,$G$8:$G$19,0)+1)),\"\")","v":"Оля"},{"$f":"IFERROR(MIN(INDEX($K$8:$K$19,MATCH(M15,$J$8:$J$19,0))-SUMIF($M$7:M14,M15,$O$7:O14),INDEX($H$8:$H$19,MATCH(N15,$G$8:$G$19,0))-SUMIF($N$7:N14,N15,$O$7:O14)),\"\")","v":222.58064516128911},null,null,"Аня",1190.3225806451612]
[9,"Ира",6,300,890.32258064516122,null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(SMALL(IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),ROW(A9)),IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),0)),\"\")","v":""},"",null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(LARGE(IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),ROW(A9)),IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),0)),\"\")","v":""},"",null,{"$f":"IFERROR(IF(SUMIF($M$7:M15,M15,$O$7:O15)<INDEX($K$8:$K$19,MATCH(M15,$J$8:$J$19,0)),M15,INDEX($J$8:$J$19,MATCH(M15,$J$8:$J$19,0)+1)),\"\")","v":"Настя"},{"$f":"IFERROR(IF(SUMIF($N$7:N15,N15,$O$7:O15)<INDEX($H$8:$H$19,MATCH(N15,$G$8:$G$19,0)),N15,INDEX($G$8:$G$19,MATCH(N15,$G$8:$G$19,0)+1)),\"\")","v":"Оля"},{"$f":"IFERROR(MIN(INDEX($K$8:$K$19,MATCH(M16,$J$8:$J$19,0))-SUMIF($M$7:M15,M16,$O$7:O15),INDEX($H$8:$H$19,MATCH(N16,$G$8:$G$19,0))-SUMIF($N$7:N15,N16,$O$7:O15)),\"\")","v":396.77419354838707},null,null,"Ира",890.32258064516122]
[10,"Наташа",6,null,1190.3225806451612,null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(SMALL(IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),ROW(A10)),IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),0)),\"\")","v":""},"",null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(LARGE(IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),ROW(A10)),IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),0)),\"\")","v":""},"",null,{"$f":"IFERROR(IF(SUMIF($M$7:M16,M16,$O$7:O16)<INDEX($K$8:$K$19,MATCH(M16,$J$8:$J$19,0)),M16,INDEX($J$8:$J$19,MATCH(M16,$J$8:$J$19,0)+1)),\"\")","v":"Юля"},{"$f":"IFERROR(IF(SUMIF($N$7:N16,N16,$O$7:O16)<INDEX($H$8:$H$19,MATCH(N16,$G$8:$G$19,0)),N16,INDEX($G$8:$G$19,MATCH(N16,$G$8:$G$19,0)+1)),\"\")","v":"Оля"},{"$f":"IFERROR(MIN(INDEX($K$8:$K$19,MATCH(M17,$J$8:$J$19,0))-SUMIF($M$7:M16,M17,$O$7:O16),INDEX($H$8:$H$19,MATCH(N17,$G$8:$G$19,0))-SUMIF($N$7:N16,N17,$O$7:O16)),\"\")","v":190.32258064516122},null,null,"Коля",690.32258064516122]
[11,"Оля",6,2000,-809.67741935483878,null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(SMALL(IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),ROW(A11)),IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),0)),\"\")","v":""},"",null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(LARGE(IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),ROW(A11)),IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),0)),\"\")","v":""},"",null,{"$f":"IFERROR(IF(SUMIF($M$7:M17,M17,$O$7:O17)<INDEX($K$8:$K$19,MATCH(M17,$J$8:$J$19,0)),M17,INDEX($J$8:$J$19,MATCH(M17,$J$8:$J$19,0)+1)),\"\")","v":""},{"$f":"IFERROR(IF(SUMIF($N$7:N17,N17,$O$7:O17)<INDEX($H$8:$H$19,MATCH(N17,$G$8:$G$19,0)),N17,INDEX($G$8:$G$19,MATCH(N17,$G$8:$G$19,0)+1)),\"\")","v":"Оля"},{"$f":"IFERROR(MIN(INDEX($K$8:$K$19,MATCH(M18,$J$8:$J$19,0))-SUMIF($M$7:M17,M18,$O$7:O17),INDEX($H$8:$H$19,MATCH(N18,$G$8:$G$19,0))-SUMIF($N$7:N17,N18,$O$7:O17)),\"\")","v":""},null,null,"Люба",1190.3225806451612]
[12,null,null,null,"",null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(SMALL(IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),ROW(A12)),IF($E$8:$E$19<0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),0)),\"\")","v":""},"",null,{"$f":"IFERROR(INDEX($B$8:$B$19,MATCH(LARGE(IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),ROW(A12)),IFERROR(IF($E$8:$E$19>0,$E$8:$E$19-ROW($E$8:$E$19)%%%,\"\"),\"\"),0)),\"\")","v":""},"",null,{"$f":"IFERROR(IF(SUMIF($M$7:M18,M18,$O$7:O18)<INDEX($K$8:$K$19,MATCH(M18,$J$8:$J$19,0)),M18,INDEX($J$8:$J$19,MATCH(M18,$J$8:$J$19,0)+1)),\"\")","v":""},{"$f":"IFERROR(IF(SUMIF($N$7:N18,N18,$O$7:O18)<INDEX($H$8:$H$19,MATCH(N18,$G$8:$G$19,0)),N18,INDEX($G$8:$G$19,MATCH(N18,$G$8:$G$19,0)+1)),\"\")","v":"Оля"},{"$f":"IFERROR(MIN(INDEX($K$8:$K$19,MATCH(M19,$J$8:$J$19,0))-SUMIF($M$7:M18,M19,$O$7:O18),INDEX($H$8:$H$19,MATCH(N19,$G$8:$G$19,0))-SUMIF($N$7:N18,N19,$O$7:O18)),\"\")","v":""},null,null,"Настя",396.77419354838707]
[null,"Итого:",null,{"$f":"SUM(D8:D19)","v":12300},null,null,null,{"$f":"SUM(H8:H19)","v":6429.032258064517},null,null,{"$f":"SUM(K8:K19)","v":6429.0322580645152},null,null,null,null,null,null,"Наташа",1190.3225806451612]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Юля",190.32258064516122]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Таня",690.32258064516122]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Общий итог",6429.0322580645152]