Draggable formula suggestions for D3 and D4 linear interpolation

Loading data from Talking to Chatbots Dataset reddgr/talking-to-chatbots-chats

😎 suggest a draggable formula for D3 that interpolates linearly the blank values

the table with the table numbers and the table numbers
🤖 =IF(C3<>“”,C3,
LET(
curX,B3,
x1,LOOKUP(2,1/($C$3:C3<>“”),$B$3:B3),
y1,LOOKUP(2,1/($C$3:C3<>“”),$C$3:C3),
nextRow,MATCH(TRUE,INDEX($C4:$C$100<>“”,0),0)+3,
x2,INDEX($B:$B,nextRow),
y2,INDEX($C:$C,nextRow),
y1+(curX – x1)*(y2 – y1)/(x2 – x1)
)
)
😎 No. D3 is just C3, obviously. MAke a formula for D4 downwards, looks extremely easy
[Message flagged as bad_response]
🤖 =IF(C4<>“”,C4, C$3+(B4 – B$3)*((C$6 – C$3)/(B$6 – B$3)))

Hugging Face Dataset Metrics

All the conversation prompts, responses, and metrics are available to download and explore on Hugging Face dataset reddgr/talking-to-chatbots-chats: