et
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Дата", type date}, {"Дата правильная", type date}, {"Номер счета/МФО", type number}, {"Имя клиента/ИНН", type text}})
in
    #"Changed Type"

let
    Source = Excel.CurrentWorkbook(){[Name="Сотрудники_1"]}[Content],
    #"Filtered Rows" = Table.SelectRows(Source, each ([Dismissal date] = null)),
    #"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows",{{"Start date", type date}})
in
    #"Changed Type"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Column1", "Column2", "Column3"}, {{"Count", each _, type table [Column1=nullable number, Column2=nullable number, Column3=nullable number, Column4=nullable text]}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Count],"Index",1,1)),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Count"}),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Columns", "Custom", {"Column4", "Index"}, {"Custom.Column4", "Custom.Index"}),
    #"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Expanded Custom", {{"Custom.Index", type text}}, "lt-LT"), List.Distinct(Table.TransformColumnTypes(#"Expanded Custom", {{"Custom.Index", type text}}, "lt-LT")[Custom.Index]), "Custom.Index", "Custom.Column4")
in
    #"Pivoted Column"

let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}})
in
    #"Changed Type"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Column1", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Column1.1", "Column1.2", "Column1.3"}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Split Column by Delimiter", {}, "Attribute", "Value"),
    #"Removed Columns" = Table.RemoveColumns(#"Unpivoted Columns",{"Attribute"})
in
    #"Removed Columns"

let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Предмет проверки", type text}, {"Дата сегодняшнего дня", type date}, {"Предыдущая проверка", type date}, {"Остаток дней", Int64.Type}, {"Следующая проверка", type date}, {"Интервал проверки", Int64.Type}}),
    #"Sorted Rows" = Table.Sort(#"Changed Type",{{"Следующая проверка", Order.Ascending}})
in
    #"Sorted Rows"

=COUNTIF(B$1:B2;B2)

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Replaced Value" = Table.ReplaceValue(Source," ","",Replacer.ReplaceText,{"ТЕКСТ"}),
    #"Split Column by Position" = Table.SplitColumn(#"Replaced Value", "ТЕКСТ", Splitter.SplitTextByRepeatedLengths(1), {"ТЕКСТ.1", "ТЕКСТ.2", "ТЕКСТ.3", "ТЕКСТ.4", "ТЕКСТ.5", "ТЕКСТ.6", "ТЕКСТ.7", "ТЕКСТ.8", "ТЕКСТ.9", "ТЕКСТ.10", "ТЕКСТ.11", "ТЕКСТ.12", "ТЕКСТ.13"})
in
    #"Split Column by Position"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Filtered Rows" = Table.SelectRows(Source, each ([Column2] = "открыт")),
    #"Grouped Rows" = Table.Group(#"Filtered Rows", {"Column1"}, {{"Count", each Table.RowCount(_), Int64.Type}})
in
    #"Grouped Rows"

=SUMPRODUCT(--(DAY(A2:A100)=DAY(TODAY()))*(MONTH(A2:A100)=MONTH(TODAY())))

=SUMPRODUCT(--(E15:E218<>0))

let
    Source = Excel.CurrentWorkbook(){[Name="пример"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"столбец1", type text}, {"дата1", Int64.Type}, {"дата2", Int64.Type}, {"дата3", Int64.Type}, {"дата4", Int64.Type}}),
    #"Replaced Value" = Table.ReplaceValue(#"Changed Type",null,0,Replacer.ReplaceValue,{"дата1", "дата2", "дата3", "дата4"}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Replaced Value", {"столбец1"}, "Attribute", "Value"),
    #"Sorted Rows" = Table.Sort(#"Unpivoted Other Columns",{{"столбец1", Order.Ascending}, {"Attribute", Order.Ascending}})
in
    #"Sorted Rows"

let    Source = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Столбец1", type date}})
in
    #"Changed Type"

=PERCENTILE.EXC(B2:B9;PERCENTRANK.EXC(A2:A9;E2;ROWS($A$3:$A$9)))

let
    Source = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Артикул", Int64.Type}, {"Номенклатура", type text}, {"Признак", Int64.Type}, {"Цена", Int64.Type}}),
    #"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Changed Type", {{"Признак", type text}}, "lt-LT"), List.Distinct(Table.TransformColumnTypes(#"Changed Type", {{"Признак", type text}}, "lt-LT")[Признак]), "Признак", "Цена")
in
    #"Pivoted Column"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Transposed Table" = Table.Transpose(Source),
    #"Added Index" = Table.AddIndexColumn(#"Transposed Table", "Index", 0, 1),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Added Index", {"Index"}, "Attribute", "Value"),
    #"Removed Columns" = Table.RemoveColumns(#"Unpivoted Other Columns",{"Index", "Attribute"})
in
    #"Removed Columns"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", Int64.Type}, {"Column2", Int64.Type}, {"Column3", Int64.Type}, {"Column4", Int64.Type}, {"Column5", Int64.Type}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Column1", "Column2", "Column3", "Column4"}, {{"Count", each _, type table [Column1=number, Column2=number, Column3=number, Column4=number, Column5=number]}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Count],"Index",1,1)),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Count"}),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Columns", "Custom", {"Column5", "Index"}, {"Custom.Column5", "Custom.Index"}),
    #"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Expanded Custom", {{"Custom.Index", type text}}, "lt-LT"), List.Distinct(Table.TransformColumnTypes(#"Expanded Custom", {{"Custom.Index", type text}}, "lt-LT")[Custom.Index]), "Custom.Index", "Custom.Column5")
in
    #"Pivoted Column"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Split Column by Delimiter" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByDelimiter(" ", QuoteStyle.Csv), {"Column1.1", "Column1.2", "Column1.3", "Column1.4"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Column1.1", type text}, {"Column1.2", type text}, {"Column1.3", type text}, {"Column1.4", type text}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Column1.1", "Column1.2", "Column1.3"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each ([Column1.4] <> null)),
    #"Split Column by Delimiter1" = Table.SplitColumn(#"Filtered Rows", "Column1.4", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, true), {"Column1.4.1", "Column1.4.2"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter1",{{"Column1.4.1", type text}, {"Column1.4.2", type text}}),
    #"Removed Columns1" = Table.RemoveColumns(#"Changed Type1",{"Column1.4.1"}),
    #"Replaced Value" = Table.ReplaceValue(#"Removed Columns1","#","",Replacer.ReplaceText,{"Column1.4.2"}),
    #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","</a>","",Replacer.ReplaceText,{"Column1.4.2"}),
    #"Split Column by Delimiter2" = Table.SplitColumn(#"Replaced Value1", "Column1.4.2", Splitter.SplitTextByDelimiter(";>", QuoteStyle.Csv), {"Column1.4.2.1", "Column1.4.2.2"}),
    #"Changed Type2" = Table.TransformColumnTypes(#"Split Column by Delimiter2",{{"Column1.4.2.1", type text}, {"Column1.4.2.2", type text}})
in
    #"Changed Type2"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}, {"иванов", Int64.Type}, {"петров", Int64.Type}, {"сидоров", Int64.Type}, {"кошкин", Int64.Type}, {"собачкин", Int64.Type}, {"остаток", Int64.Type}}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Column1", "остаток"}, "Attribute", "Value"),
    #"Reordered Columns" = Table.ReorderColumns(#"Unpivoted Other Columns",{"Column1", "Value", "остаток", "Attribute"}),
    #"Renamed Columns" = Table.RenameColumns(#"Reordered Columns",{{"Value", "Массаа"}, {"Attribute", "Исполнитель"}, {"Column1", "Дата"}})
in
    #"Renamed Columns"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Duplicated Column" = Table.DuplicateColumn(Source, "Column1", "Column1 - Copy"),
    #"Extracted First Characters" = Table.TransformColumns(#"Duplicated Column", {{"Column1 - Copy", each Text.Start(_, 2), type text}}),
    #"Grouped Rows" = Table.Group(#"Extracted First Characters", {"Column1 - Copy"}, {{"Count", each _, type table [Column1=text, #"Column1 - Copy"=text]}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Count],"Index",1,1)),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Column1", "Index"}, {"Custom.Column1", "Custom.Index"}),
    #"Removed Columns" = Table.RemoveColumns(#"Expanded Custom",{"Count"}),
    #"Pivoted Column" = Table.Pivot(#"Removed Columns", List.Distinct(#"Removed Columns"[#"Column1 - Copy"]), "Column1 - Copy", "Custom.Column1"),
    #"Removed Columns1" = Table.RemoveColumns(#"Pivoted Column",{"Custom.Index"})
in
    #"Removed Columns1"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type number}, {"Column2", type number}, {"Column3", type number}, {"Column4", type number}, {"Column5", type number}, {"Column6", type number}, {"Column7", type number}, {"Column8", type number}, {"Column9", type number}, {"Column10", type number}, {"Column11", type number}, {"Column12", type number}, {"Column13", type number}, {"Column14", type number}, {"Column15", type number}, {"Column16", type number}, {"Column17", type number}, {"Column18", type number}, {"Column19", type number}, {"Column20", type number}, {"Column21", type number}, {"Column22", type number}, {"Column23", type number}, {"Column24", type number}})
in
    #"Changed Type"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ФИО", type text}, {"Дата", type date}, {"Рейс", type text}}),
    #"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Changed Type", {{"Дата", type text}}, "lt-LT"), List.Distinct(Table.TransformColumnTypes(#"Changed Type", {{"Дата", type text}}, "lt-LT")[Дата]), "Дата", "Рейс")
in
    #"Pivoted Column"