Fomula
A formula is what User:Satomi uses to judge the challenges. They determine how the entries are scored and stuff.
List of formulas
- Challenge 1: Competitors -
=(D2*4)+(E2*5)-(4*F2^2)+(G2*40)+(H2*2)+I2+(J2*2)+(K2*1)+((L2-1)*2)
- Challenge 2: Teams -
=((C2*5)+(D2*6)-(4*E2^2)+((F2+G2)*7)+H2+(I2*2)+J2+((K2-1)*2))/(L2-2)
- Challenge 3: Edit War -
=((C2*7)+(D2*8)-(5*E2^2)+(40*H2)+(K2/2)+((roundup(128*(MIN(L2:M2)/MAX(L2:M2))))/(1+G2))+(N2/100))*(6-LEN(ABS(I2)))-(J2/10)+(J3/10)+(if(MOD(I2,101)>0,0,101))+(0.2*ABS(N2-N1)/(1+G2))+(3*abs(K2-K1))+(F1*400)
- Challenge 4: Things -
=(E2*8)+(F2*9)-(4*G2^2)+75*(H2-1+I2-1)+CEILING(75*J2/(J2+K2+1))+((CEILING(SQRT(L2))+(M2*2)+N2-1)/10)
- Challenge 5: To Be Confused... -
=(((E2*9)+(F2*10)-(4*G2^2)+(ceiling(SQRT(H2)*5))+(J2*51)+(ceiling(SQRT(I2)*4)))/M2)+(K2*5)+(CEILING((L2/LEN(D2))*64))
- Challenge 6: Unwanted Pages -
=ARRAYFORMULA((E2:E64*10)+(F2:F64*11)-(G2:G64^2)-(L2:L64/100)+(ceiling(H2:H64/1000,0.01))+(I2:I64*40)+(63*J2:J64)+(K2:K64)+CEILING(10*(M2:M64/N2:N64),0.01))
- Challenge 7: Discussions -
=ARRAYFORMULA((E2:E51*11)+(F2:F51*12)-(G2:G51^2)+iferror(ceiling(49*2*(0.5-abs((H2:H51/(H2:H51+I2:I51))-0.5))))+(H2:H51+I2:I51)+((J2:J51+K2:K51)*2)+((L2:L51+M2:M51)*20)+((N2:N51^2)*14)+iferror(ceiling(20*(abs(O2:O51-P2:P51)/(O2:O51+P2:P51))))+Q2:Q51)
- Challenge 8: Who is this? -
=ARRAYFORMULA((((D2:D11*12)+(E2:E11*13)-(F2:F11^2))/I2:I11)+((G2:G11+H2:H11)*45))
List of other formulas
-
- from
-
- from