Math - Formula + Expression ?
Hi?
Here is a small excerpt of my dataset. I could do it using Excel, but it would take too much time and could potentially lead to errors.
This dataset is the result of three different races (RNO). Each time, a rating was established for the first-place finisher. This rating will not change.
Now I want to calculate the rating for the 2nd and 3rd place finishers of each race. This rating will take into account the distance of the race and the winner’s times (TIME), (TPS EP), and (400F).
I want to creat new columns : EP1 ; LF1; SR1
This the excel formula for each column :
SR1 = (1-(WINTIME/HORSETIME)^(RACE_DIST/1000))*1000
Example for RNO1=> (1- (95,08/95,15)^(1600/1000))*1000
same formula for the 3rd but HORSE_TIME change
EP1 = (1-(71,41/71,93)^(1200/1000))*1000
LF1 = (1-(23,67/23,22)^(400/1000))*1000
Is it doable? Considering there are many races and often more than 10 runners.
Thanks
Br