|
From the Example above
(NOTE Columns
A to J
appear on the PARADE SQUARE)
Player One has
1921 current points before
calculation is started
Player Two has
1172 current points before
calculation is started
Player One receives a TV
THUS
J=IF(Q2=3,(V2+K2),IF(Q2=2,(V2+K2),IF(Q2=0,V2+K2,IF(Q2=1,K2+U2,"error"))))+Q2
K= Current Player One Grading
(MANUAL INPUT)
L= Current Player Two Grading
(MANUAL INPUT)
M=
N=
O=1 (One point for the TV - MANUAL
INPUT)
P=
Q=SUM(M2:P2)
R=L2-K2
S=ROUND(R2/25,0)
T==IF(Q2=3,(30+S2),IF(Q2=-1,-20+S2,IF(Q2=0,S2,IF(Q2=2,20+S2,IF(Q2=1,(S2+20)/2,0)))))
U=IF(AND(Q2=0,T2<-10),-10,IF(AND(Q2=0,T2>10),10,T2))
V=IF(AND(Q2=-1,T2>-20),-20,IF(AND(Q2=3,T2<20),20,IF(AND(Q2=2,T2<10),10,IF(AND(Q2=1,T2<5),5,T2))))
THUS J=1917
ADDITION SCENARIOS FOR THE ABOVE EXAMPLE
Based on Player ONE
having a GRADE of 1921 starting
POINTS
Based on Player TWO
having a GRADE of 1172 starting
POINTS
RESULTS POSSIBLE FOR PLAYER ONE
If Player ONE received a
BV the calculation result is 1944
(+23 points)
If Player ONE received a
V the calculation result is 1933
(+12 points)
If Player ONE received a
TV the calculation result is 1917
(-4 points)
If Player ONE received a
L the calculation result is 1891
(-30 points)
RESULTS POSSIBLE FOR PLAYER TWO
If Player TWO received a
BV the calculation result is 1235
(+63 points)
If Player TWO received a
V the calculation result is 1224
(+52 points)
If Player TWO received a
TV the calculation result is 1198
(+26 points)
If Player TWO received a
L the calculation result is 1202
(+30 points)
Players closer to equal
"Grades" would result in numbers closer to this
BV=30, V=20, TV=10, L=0
Addition Examples
Columns J thru V
|