3,076 questions
3
votes
0
answers
177
views
How to Correct Shape Offsets When Drawing a Bullseye Target in Excel Using VBA
I’m building a bullseye target chart in Excel using VBA macros. Each ring represents a performance range based on an array of percentage values.
The sizing and labeling are working fine, but I’m ...
1
vote
2
answers
94
views
excel search array for partial string match; return cell adjacent to string
I would like to search an array for a cell in the function's row and return the cell adjacent to the matching array row. The array cells contain partial matches with the function's row.
clients
...
- 11
0
votes
1
answer
45
views
How to serialize protobuf message into a pre-allocated byte array with offset in c#? (Protobuf 3.32.0.0)
The methods AI showed me are not working. However, one method mentioned by AI seems to be usable, but it is private：
private CodedOutputStream(byte[] buffer, int offset, int length)
So, how can I ...
- 439
0
votes
0
answers
113
views
Query with limit offset - bad performance despite index
Hsqldb 2.7.4
If I use OFFSET in an index query, the index should be used for offset calculation, as far as I understand the documentation!?
That does not work for me. Any ideas?
SELECT id FROM news ...
- 61
0
votes
1
answer
193
views
How to REALLY auto reset offsets when subscribing to a kafka topic?
I have a topic with 2 partitions which has historic messages. I just made a new consumer group and I'm running 1 flakey consumer. I want reliability (no lost messages) from the point of my first ...
- 2,341
0
votes
0
answers
97
views
How to get the coordinate of Composable element?
I’m working on a Jetpack Compose app where I want a Text item in a LazyColumn become transparent as it scrolls under a semi-transparent TopAppBar. To achieve this, I’m using onGloballyPositioned to ...
- 1
4
votes
2
answers
92
views
Excel Cyclical Offset
I'm attempting to pull in multiples columns (with specific ranges) into a single column. I've been running in circles (pardon the pun) to no avail. Here is my formula thus far on sheet3!A2:
=OFFSET(...
- 91
0
votes
0
answers
76
views
Hasura Documentation Pagination Example Seems Incorrect – Limit vs. Offset
I'm following the Hasura documentation on GraphQL Limit and Offset for pagination, and I noticed something that seems incorrect.
The docs state:
"If we have 50 todos, we could split them into 5 ...
-1
votes
1
answer
55
views
mysql offset doesn't work with multiple tables
Given tables setup like this
tableA {
id = 1
name = 'bob'
id = 2
name = 'sally'
id = 3
name = 'sue'
}
tableB {
id = 1
name = 'bob'
}
If I run this ...
- 854
0
votes
1
answer
129
views
Replace OFFSET formula
=LAMBDA(a,
LET(Range,IF(COLUMNS(a#)>1,a#,OFFSET(a,0,0,1,14)),
Range))(Q339)
The above formula is going to be used at many places. I need to eliminate OFFSET function to improve on speed. If target ...
-1
votes
1
answer
46
views
How can i manage offsets in Kafka at Message Level
This is my code :
@retry(stop=stop_after_attempt(3), wait=wait_fixed(2))
def kafka_consumer(self):
"""Consume messages from Kafka with retry logic."""
...
0
votes
1
answer
116
views
Offset an entire row with .End(xlUp) + offset + .value (in VBA)
I have been searching for similar questions and haven't found this specific one, so apologies if it has already been asked.
I am trying to backtest an idea in finance and run 100's of simulations. My ...
0
votes
1
answer
52
views
Find all matches between two columns and return values from another column horizontally [duplicate]
I am trying to figure out the most efficient way to find all matches of multiple values in one column and return values from another column. Let me try to explain it with images below:
Here I am ...
- 333
1
vote
2
answers
574
views
How do you detect if the user has clicked outside of a composable using Jetpack Compose?
Using Jetpack Compose, I'm trying to create a custom popup without using the built in popup composable because the latter doesn't allow for animated entry. I've got it working mostly. The popup ...
- 275
0
votes
2
answers
109
views
Simplify an Excel array function
I'm creating a excel file where I don't want to use VBA which would model the drawdown of loans (drawn each quarter for varying amount), and the reimbursement schedule of these loans (which are all ...
1
vote
1
answer
91
views
Count in specific ways in Google sheets
I am working on getting some specific counts but cannot figure out how to do it.
I have the following sheet:
Duration for subject 1 is 30 min and 90 min for subject 3
Subject 1
Subject 1
Subject 1
...
- 73
9
votes
1
answer
964
views
How to paste code into the REPL without adding extra spaces on the left [closed]
I am running Python 3.13.1. When I paste code into the Python REPL, Python adds extra spaces at the beginning of every line after the first.
I wrote this code in Notepad and pasted it into Python.
if ...
- 101
0
votes
0
answers
40
views
Using Positioned with Offset.fromDirections in Flutter
I am currently trying to place Image.asset widgets in a circle based on the degrees. I have tried using the Positioned and Offset.from Direction, but the values seem to be off.
I have split the ...
- 139
2
votes
4
answers
236
views
How to align two string's offset given a list of substrings offsets?
Given a and b relating to a list of substrings in c:
a = "how are you ?"
b = "wie gehst's es dir?"
c = [
("how", "wie"),
("are", "gehst's&...
- 123k
0
votes
0
answers
65
views
Scrollable Table With Fixed 1st Row and 1st Column (SwiftUI Project)
I am trying to display a table that can be scrolled horizontally and vertically. The first row contains a columnsHeader, which is fixed, so it should not be scrolled vertically, but only horizontally. ...
- 47
0
votes
1
answer
378
views
OFFSET - MATCH with multiple criterias
I need to include another MATCH criteria inside this formula to add it in the Data Validation for a drop down list:
=OFFSET(Data!$Y$1,MATCH(J$4,Data!$X$2:$X$500,0),0,COUNTIF(Data!$X$2:$X$500,J$4))
...
1
vote
0
answers
37
views
Talend tKafkaInput Consistently Reads Only Partial Messages from Kafka DLQ Despite Correct Configuration
Question: I'm encountering a persistent issue with my Talend jobs involving Kafka and a Dead-Letter Queue (DLQ). I have a real-time job that continuously writes failed messages to a Kafka topic named ...
3
votes
0
answers
51
views
Why does my pieces misalign when placed in the center of my React-based board game?
I'm developing a game in React for study purposes. It was inspired in the game called Trigon: Triangle Block Puzzle for mobile. It has a hexagonal board and the goal is to survive as long as you can, ...
- 31
0
votes
2
answers
60
views
Copy column data to new column, if data exists, use column to the right
I would like to copy a column's data (Example: A2:A10) to C2:C10. However, if C2:C10 already has data, I would like it to copy the data to the next column to the right. In this example that would be ...
- 159
1
vote
0
answers
116
views
Calculating Offset Values in 010 Editor based on variable inputs
I am currently trying to reverse engineer a certain file with a header (that's already done) and a list of entries.
This is the 010 Editor Template so far:
struct FILE {
struct HEADER {
...
- 11
0
votes
1
answer
67
views
Calculate Offset Limit of mask bounds
Hi all I'm trying to set the offset limits so that the image during the dragGesture never exceeds the outlines of the mask...
Thanks to the help of Benzy Neez I obtain a scaleOffset value that I use ...
- 2,823
0
votes
0
answers
78
views
Creating a dynamic range in excel using a variable starting cell
I am trying to create dynamic ranges to be used for excel charts.
I have the following range:
=OFFSET(O7,0,0,1,COUNTA($O$5:$X$5))
cell o7 is expected to change.
I have created the following formula to ...
- 55
0
votes
2
answers
151
views
How do I use offset within a forEach loop in google apps script
I have a range consisting of a variable number of rows and 4 columns (A,B,C,D). I need to loop through each of the rows and add the number in column D to the number in column C and then clear the ...
- 21
0
votes
0
answers
20
views
How to get offset in Assembly (Intel 8086)? [duplicate]
I have a problem with Assembly code. I need to put the offset variable wordl1p into the BX register and copy the contents of the second byte (the high-order byte) of the wordl1p variable into the ...
- 41
-1
votes
2
answers
95
views
AHKv2 Unable to offset excel value with ComObjGet - 'Error: This value of type "String" has no method named "Offset".'
AUTOHOTKEY v2.0.18
I have 2 codes. One works flawlessly and the other, which is almost exactly the same, does not.
Can you identify where I'm going wrong here please?
WORKING - TEST CODE TO GET IT TO ...
- 47
2
votes
1
answer
111
views
How can I set an OFFSET = 100 in nls (Nonlinear Least Squares) coupled with the SSbiexp or SSasympOFF (self-starting) functions in R?
I am using self-starting functions to estimate the best constants for my models in R software. But it does not allow me to constrain my offset (y=100, x=0) to be 100.
The two component exponential ...
- 21
0
votes
0
answers
267
views
Excel Offset (sample every nth row with specific values)
I'm deeply confused about using OFFSET with ROW to grab every nth row of a sheet
I have a marking sheet that looks like this:
And am trying to transfer those grades into a summary sheet where each ...
- 55
2
votes
2
answers
108
views
Can I batch Snowflake json output into separate rows based on LIMIT/OFFSET
I have a query in Snowflake that produces json output in rows. 29,000+ rows. I am using this query to create records in an MDM system. However, this ingestion process is a bit inefficient and costly. ...
- 25
-2
votes
1
answer
110
views
wiremock in java offset 1 hour [closed]
help please.
trying using in wiremock dynamic data
Wiremock editing in intellij idea
"expiresAt": "{{now offset='1 hour' timezone='Australia/Sydney' format='unix'}}",
but got error ...
- 31
0
votes
1
answer
2k
views
I'm experiencing performance issues when using OFFSET in my SQL queries [duplicate]
For instance, consider the following two queries:
SELECT id, CHARACTER_LENGTH(polygon_data)
FROM polygon_data
LIMIT 10 OFFSET 1;
SELECT id, CHARACTER_LENGTH(polygon_data)
FROM polygon_data
WHERE id = ...
1
vote
1
answer
407
views
Offsets in predict.glm(), given that the fitted poisson model already considered offsets - R
I want to predict a fitted poisson glm on newdata, given that it was fitted using offset=log(Exposure), but I get confused with the inclusion of the term "offset" inside of predict.glm(). I ...
- 11
0
votes
1
answer
49
views
Excell Sum array by two conditions one of which is partial text string
I have a table with multiple sheets. In sheet1 I want to sum the values of particular cells from a range in sheet2 by two conditions. Cells that are to be summed are in different rows and columns.
...
0
votes
0
answers
41
views
Find a value from Range in 2 columns, with additional condition
If I use below formula in G2
=INDEX(D:D,MATCH(1,(F2>=B:B)*(F2<=C:C),0))
The output is first matching condition which is XX
Impage
in G3 I want to add one more condition, first match E3 in column ...
1
vote
0
answers
52
views
Kafka Consumer tool - No such element Exception
We have a kafka topic with 2 producers. I am trying to build a simple kafka tool in Java to consume and view the message from the topic. Idea is to get the offset and partition from user and to seek ...
- 11
0
votes
1
answer
304
views
cursor offset while editing code in leetcode.com by edge
one day I find the cursor didn't emege in the right place in my code editor in leetcode.com by microsoft edge, while when I use the chrome to try,the problem vanished. Because I used to use edge as my ...
0
votes
1
answer
252
views
How to infinitely loop and move image in swiftUI in intervals?
So I have an image whose width is greater than screen width. And I wanna move it across the screen in horizontal direction. Currently, I am able to animate it seamlessly but it is a continuous ...
- 553
0
votes
1
answer
22
views
Flutter: customepaint and gesture out of sync when offscreen
I am developing a node editor sort of app, in which you can add nodes and connect them with a noodle connection (like in blender and Unreal engine), I am facing a problem when a node is dragged off ...
- 3
1
vote
1
answer
93
views
Trying to access array offset on value of type bool - PHP 8.1 - Wordpress - Mulivendorx plugin
I get this error when this code is run as a Wordpress code snippet using WP Code plugin. I'm sure it has to do with the code provided by the plugin developer being out of date, not in-line with ...
- 31
2
votes
0
answers
68
views
How do you find how much a simple concave polygon can be deflated/offset before it self intersects?
For reference, I've implemented this algorithm for inflating/deflating polygons: https://www.baeldung.com/cs/polygons-inflating-deflating
However, for joining edges, instead of using rounded corners, ...
- 33
3
votes
0
answers
76
views
Coordinates of text label after applying pos and offset parameters
Suppose I have the following plot:
plot(x=1, y=1, xlim=c(0,2), ylim=c(0,2))
text(x=1, y=1, lab="X", pos=3, offset=2)
How do I find the coordinates of the text label (lab="X") as ...
- 89
1
vote
1
answer
41
views
Return LAST CELL POSITION based on TWO criteria
I'm having trouble returning the LAST CELL POSITION based on two criterias:
cell = "R"
wherever position #1 (above) is found, if this position +3 columns = F2
I found a formula that helped ...
- 33
1
vote
1
answer
78
views
Adding more (3rd) criteria to COUNTIFS
i'm creating a log to record replaced ropes at a climbing gym, with various "averages" output for overview.
i'd like to add an option to filter these "averages" by rope type, ...
- 33
1
vote
1
answer
310
views
Is there any order of precedence in window functions of SQL?
I have a table as follows:
I just want the previous entry for every row from the column 'marks'.
Table structure:
test_id marks
100 55
101 55
102 60
103 58
...
1
vote
1
answer
479
views
Spark streaming + kafka integration, read data from kafka for every 15 minutes and store last read offset using PySpark
Using PySpark, implemented spark streaming + kafka integration. Every run it gives offset from 0.
Need to solve 2 issues:
Reading stream for last 15 mins
Read from last committed offset for each ...
- 438
0
votes
2
answers
48
views
Toggle class of fixed header when hovering specific divs in Javascript
I'm building a site with a fixed header positioned at the top of the window. I'm trying to toggle a class to switch the color of the header when scrolling hover specific divs with the class .is-dark
...
- 451