Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IF(
- OR(
- E1<>E2,
- E2=1,
- (ROW()>3)
- *(OFFSET($A$1,(ROW()-1)-1,COLUMN()-1)="")
- *(E2=2),
- (ROW()>4)
- *(CONCATENATE(IFERROR(OFFSET($A$1,(ROW()-1)-2,COLUMN()-1),""),
- OFFSET($A$1,(ROW()-1)-1,COLUMN()-1))="")
- *(E2=3),
- (ROW()>5)
- *(CONCATENATE(IFERROR(OFFSET($A$1,(ROW()-1)-3,COLUMN()-1),""),
- IFERROR(OFFSET($A$1,(ROW()-1)-2,COLUMN()-1),""),
- OFFSET($A$1,(ROW()-1)-1,COLUMN()-1))="")
- *(E2=4),
- (ROW()>6)
- *(CONCATENATE(IFERROR(OFFSET($A$1,(ROW()-1)-4,COLUMN()-1),""),
- IFERROR(OFFSET($A$1,(ROW()-1)-3,COLUMN()-1),""),
- IFERROR(OFFSET($A$1,(ROW()-1)-2,COLUMN()-1),""),
- OFFSET($A$1,(ROW()-1)-1,COLUMN()-1))="")
- *(E2=5)
- (ROW()>7)
- *(CONCATENATE(IFERROR(OFFSET($A$1,(ROW()-1)-5,COLUMN()-1),""),
- IFERROR(OFFSET($A$1,(ROW()-1)-4,COLUMN()-1),""),
- IFERROR(OFFSET($A$1,(ROW()-1)-3,COLUMN()-1),""),
- IFERROR(OFFSET($A$1,(ROW()-1)-2,COLUMN()-1),""),
- OFFSET($A$1,(ROW()-1)-1,COLUMN()-1))="")
- *(E2=6)
- ),
- IF(
- E2=1,
- IF(V2="W",98*T2-98,-100),
- IF(
- E2=2,
- IF(OR(V2="W",V3="W"),(((1/T2)/(1/T2+1/T3)*98)*T2)-98,-100),
- IF(
- E2=3,
- IF(OR(V2="W",V3="W",V4="W"),(((1/T2)/(1/T2+1/T3+1/T4)*98)*T2)-98,-100),
- IF(
- E2=4,
- IF(OR(V2="W",V3="W",V4="W",V5="W"),(((1/T2)/(1/T2+1/T3+1/T4+1/T5)*98)*T2)-98,-100),
- IF(
- E2=5,
- IF(OR(V2="W",V3="W",V4="W",V5="W",v6="W"),(((1/T2)/(1/T2+1/T3+1/T4+1/T5+1/T6)*98)*T2)-98,-100),
- IF(
- E2=6,
- IF(OR(V2="W",V3="W",V4=“W”,V5=“W",V6="W", V7="W"),(((1/T2)/(1/T2+1/T3+1/T4+1/T5+1/T6+1/T7)*98)*T2)-98,-100),
- ""
- )
- )
- )
- )
- )
- ),
- ""
- )
Add Comment
Please, Sign In to add comment