Identifying Participation rate % based on rewards received

English
#1

Is there anything obvious why this formula
=INDEX(A8:A68, MATCH(MIN(ABS(D8:D68-E6)), ABS(D8:D68-E6), 0)) why this would not work in Calc when E6 has a value of say 162 which should return a value of 97 in E5 where this formula belongs.

|PR%|Reward pool|Tokens held|Rewards received per thousand||
|100|676040637|4278738206|158.00000||
|99|676040637|4235950823.94|159.59596||
|98|676040637|4193163441.88|161.22449||
|97|676040637|4150376059.82|162.88660||
|96|676040637|4107588677.76|164.58333||
|95|676040637|4064801295.7|166.31579||
|94|676040637|4022013913.64|168.08511||

#2

What is actually so difficult about attaching a calc file?

#3

Hahaa I wanted to but could not see the attachment link? But now I see it is the Upload link, sorry. But thanks for asking?

Participation rate.ods (33.7 KB)

#4

So that 97 comes out, I use the following formula:
=INDEX(A8:A108;MATCH(E6;INT(D8:D108);1))

#5

PKG Legendary stuff thank you so much for your help, I appreciate it. Do you know how I can make this more accurate as it using whole numbers in column A for the percentages? If I put 350 into E5 then a somewhat inaccurate 46 shows in E5?

#6

350 does not appear in the list, so the next smaller value is given.

Match()

1 Like
#7

Ok thank you for that. Is there any way that you know to tweak this to be more accurate in situations like that?
I guess if I made the Column A decimal steps in between the whole numbers
ie 45.1, 45.2, 45.3, 45.4, 45.5 etc that would probably do it??? What do you think?

#9

Just try it out.

#10

Ok that worked perfectly thank you for everything.
45.1 Corresponding PR% to number at E6
350 Rewards per 1000 actually received
As a backstory I spent all day trying to get ChatGPT to come up with the correct formula when I should have just asked you. I will mark your formula as the Solution

#11

Natural intelligence beats the artificial variety every day.

#12

So it appears and that is a good thing. :smiley:

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.