Stack Overflow
Stack Overflow

Questions tagged [offset]

The relational position of an entity, when compared to another entity with fixed position. Typically used, for example, to define location within a file or byte buffer from which information should be read.

3019 questions
0
votes
2 answers

how to use group by with offset and fetch rows only on oracle

I want to to make sum of amount of certain rows using offset clause and fetch next rows only and using group by but it gives error, i used the below query select sum(amount), column1 from table1 where column1 = '000000000' and column2 =0 group by…
MuhammedF
  • 9
  • 2
0
votes
0 answers

Height parameter of offset not working Excel

Good afternoon, I am using the following formula to calculate the average of a dynamic range. The range should be the range that contains the next 3 values in a list > 0 (Range could be higher than 3 if there are…
Almudena
  • 1
0
votes
3 answers

SQL Server T-SQL Rows to Columns

I am not sure If I'm doing it correctly but my requirement was to create a view display rows into columns using TSQL. Column number is fixed. Rows will never exceed the number of columns. Limit in Col2 is 3. No limit in Col 1. Currently my SQL is…
Seigfred Mondez
  • 17
  • 5
0
votes
1 answer

How to make a delay for several candles, while the beginning of the entry was behind the red line. Standard delay cannot do this

The usual delay methods don't have the effect I want. The delay I'm looking for should follow the red line of her level. But the usual delay just moves forward by one bar. Offset, Changing the timeframe didn't help either. The desired result in…
Poulo
  • 11
  • 2
0
votes
1 answer

Excel SUMIF Offset

I have a spreadsheet that is used for inventory planning. It has, in columns, 5 weeks (per month) followed by a month total, then another 5 weeks, followed by another month total, and so on for 12 months. Each week column is labelled "Wk 1", "Wk…
ScanGuard
  • 1
  • 1
0
votes
0 answers

Undefined offset: 2 (View: C:\inetpub\wwwroot\SHDEPHA Portal\resources\views\travel_requests\form.blade.php) on Laravel

Below is my blade codes, the error shows thats its caused by line 307 of the codes. …
mikidadi kipolelo
  • 1
0
votes
1 answer

VBA To Loop Not Entire range, but for specific cells(range) excludes some cells

I wrote below code. It works, however, I want to modify this line Set rng = Application.Intersect(Target, Me.Range("M30:AM53")) If Not rng Is Nothing Then 'only loop though any cells in M30:AM53 To not entire renge(M30:AM53) but to specific…
Rkw17
  • 1
  • 2
0
votes
0 answers

PHP substr() with large negative offset returns the first character

According to the substr() manual If string is less than offset characters long, an empty string will be returned. But with negative offset substr("abc",-9,1) the function returns a Mathematically speaking, a negative is always less than any…
Szél Lajos
  • 449
  • 4
  • 11
0
votes
1 answer

Excel VBA - Subscript Out of Range Error (Run Time: Error 9)

I'm getting a runtime error (9) Subscript out of range when trying to use Cells.Find Function. According to the official documentation, there's only few possible causes: referenced a nonexistent array element declared an array but didn't specify…
Marvster
  • 11
  • 2
0
votes
1 answer

Excel count with fixed increment

I have a large table of more than 2000 rows, and 5 columns. The values of these cells are either 1 or 0. For each column I want to be able to count the number of 1s in blocks of 20 rows starting from the first row. Example: For each column count the…
Eg It
  • 5
  • 2
0
votes
2 answers

Assembly Language: Memory Bytes and Offsets

I am confused as to how memory is stored when declaring variables in assembly language. I have this block of sample code: val1 db 1,2 val2 dw 1,2 val3 db '12' From my study guide, it says that the total number of bytes required in memory to…
raphnguyen
  • 3,565
  • 18
  • 56
  • 74
0
votes
0 answers

How to offset polygon edges at different values?

I have a list of point2D that makes a closed polygon. I can offset the edges outside or inside of the polygon. But i wanna offset the edges with different values. For example this is my polygon: [[ 25 0] [ 0 25] [ 0 75] [ 25 100] [ 75…
user3132616
  • 67
  • 1
  • 6
0
votes
1 answer

VBA Range.Offset Error 1004 Range beyond scope of sheet Dynamic Range

When the schedule is new and empty, the offset moves beyond the scope of the sheet and gives error 1004. Needs a way to dynamically move up from the initially selected cell without error. Some production lines drastically jump around the schedule…
Lumpyness
  • 43
  • 7
0
votes
1 answer

Jetpack Compose: Usage of Offset in PointerScope

I'm having issues understanding how exactly Offset works in Compose, specifically in the PointerScope onTap callback function to track the exact location where the user tapped on a UI element. Use Case User is presented an image. Whenever the user…
Felix
  • 101
  • 6
0
votes
1 answer

Using proportions as an offset in a binomial (glm) model

I am trying to test the effect of a treatment on the proportions of juveniles in a population of migrating birds. The birds were counted and identified as juveniles or adults daily, but the treatment was only on every second day. Days without…
Yael Lehnardt
  • 101
1 2 3
…
99
100