Const firstCell = "C4:aaa4"

=ПРОСМОТР($V$6;
((U8-U8*(90-СТРОКА($10:$899))%)-T8-
(((U8-U8*(90-СТРОКА($10:$899))%)*$J$6)+
((U8-U8*(90-СТРОКА($10:$899))%)*I8%)+
L8+
(ЕСЛИ(ИЛИ(E8>=25;H8>=200);500;ЕСЛИ((U8-U8*(90-СТРОКА($10:$899))%)*5,5%<13;13;МИН((U8-U8*(90-СТРОКА($10:$899))%)*5,5%;300))))+
((U8-U8*(90-СТРОКА($10:$899))%)*$Q$6)+
((U8-U8*(90-СТРОКА($10:$899))%)*R8)))
/(U8-U8*(90-СТРОКА($10:$899))%);(90-1-СТРОКА($10:$899))%*100)-3

(offset as number) =>
 let
  URL = "https://api-seller.ozon.ru/v2/posting/fbo/list", 
  Client_Id = Number.ToText(Excel.CurrentWorkbook(){[Name = "Client_Id"]}[Content]{0}[Column1]), 
  API_Key = Excel.CurrentWorkbook(){[Name = "API_Key"]}[Content]{0}[Column1], 
  from = Excel.CurrentWorkbook(){[Name = "frooom"]}[Content]{0}[Column1], 
  to = Excel.CurrentWorkbook(){[Name = "tooo"]}[Content]{0}[Column1], 
  Headers = [#"Content-Type" = "application/json", #"Client-Id" = Client_Id, #"Api-Key" = API_Key], 
  Body = "{""dir"":""ASC"",""filter"":{""since"":"""&from&"T00:00:00.000Z"",""status"":"""",""to"":"""&to&"T23:59:00.000Z""},""limit"":1000,""offset"":"&Number.ToText(offset)&",""translit"":true,""with"":{""analytics_data"":true,""financial_data"": false}}", 
  Response = Function.InvokeAfter(() => Json.Document(Web.Contents(URL, [Content = Text.ToBinary(Body), Headers = Headers])),#duration(0, 0, 0, 0.2))[result], 
  ToTable = Table.FromRecords(Response)
 in
  ToTable

let
 Source = List.Generate(() => 
[Result = try GetOrders(0) otherwise null, page = 0], 
each [Result] <> null, 
each [Result = try GetOrders([page] + 1000) otherwise null, page = [page] + 1000], 
each [Result]), 
 Table = Table.Buffer(Table.Combine(Source))
in
Table

let
  URL = "https://api-seller.ozon.ru/v2/posting/fbo/list", 
 Client_Id = "xxx", 
 API_Key = "xxxxxxxxxxxxxxxxxxxxx", 
  DateFrom = Excel.CurrentWorkbook(){[Name = "Ord_fbO_OZN_DateFrom"]}[Content]{0}[Column1], 
  DateTo = Excel.CurrentWorkbook(){[Name = "Ord_fbO_OZN_DateTo"]}[Content]{0}[Column1], 
  Headers = [#"Content-Type" = "application/json", #"Client-Id" = Client_Id, #"Api-Key" = API_Key], 
  Body = "{""dir"":""ASC"",""filter"":{""since"":"""&DateFrom&"T00:00:00.000Z"",""status"":"""",""to"":"""&DateTo&"T23:59:00.000Z""},""limit"":1000,""offset"":0,""translit"":true,""with"":{""analytics_data"":false,""financial_data"": false}}", 
  Response = Function.InvokeAfter(() => Json.Document(Web.Contents(URL, [Content = Text.ToBinary(Body), Headers = Headers])),#duration(0, 0, 0, 0.2))[result], 
  ToTable = Table.FromRecords(Response)
in 
ToTable