are you a data nerd?
do you have less free time than the duckling?
follow these simple fun steps
Code: Select all
~RECEIVER~~~~~~~~~~~~~~~~~
GIVER~TehBrawlGuy~Taly~Punreader~MariaR~DeasVail~Espeonage~Dunnstral~Nahdia~the worst~Pine~Shoshin~Fire Assassin~Lovebird~Chara~ManWithNoName~Vaxkiller~PenguinPower~NicoRobin
TehBrawlGuy~10~1~10~8~5~0~9~6~2~10~7~4~5~6~3~4~0~0
Taly~5~10~10~6~6~0~2~4~9~5~8~1~3~10~7~0~0~4
Punreader~0~10~10~6~4~6~9~8~5~0~7~5~2~10~1~4~0~3
MariaR~9~4~10~10~5~10~5~0~8~2~4~3~0~6~6~1~7~0
DeasVail~3~10~10~0~10~2~4~5~9~4~8~5~1~6~7~6~0~0
Espeonage~9~8~4~5~6~10~10~4~7~0~3~0~1~5~2~10~6~0
Dunnstral~2~9~7~6~4~8~10~5~5~4~3~10~0~10~6~0~1~0
Nahdia~4~5~10~3~5~6~2~10~7~4~6~9~1~10~0~0~8~0
the worst~6~10~5~8~6~9~2~7~10~4~3~1~0~10~0~4~5~0
Pine~10~9~0~~~~~0~~10~~8~~10~~~0~
Shoshin~8~10~5~0~6~3~6~4~9~1~10~2~0~10~7~5~0~4
Fire Assassin~8~2~3~9~5~0~4~10~7~4~6~10~1~10~6~0~4~0
Lovebird~~~~~~~~~~~~~~~~~~
Chara~10~10~8~6~5~4~5~9~7~0~6~4~3~10~0~0~2~1
ManWithNoName~10~10~4~1~0~0~6~5~7~4~8~5~3~9~10~6~0~2
Vaxkiller~0~0~7~0~6~4~2~10~5~10~4~9~5~3~6~10~8~1
PenguinPower~9~0~0~10~8~7~10~3~6~2~4~4~5~0~5~6~10~1
NicoRobin~4~6~0~8~8~20~14~12~12~20~0~0~2~16~10~10~18~10
~AVERAGE~AVERAGE~AVERAGE~AVERAGE~AVERAGE~AVERAGE~AVERAGE~AVERAGE~AVERAGE~AVERAGE~AVERAGE~AVERAGE~AVERAGE~AVERAGE~AVERAGE~AVERAGE~AVERAGE~AVERAGE
~=AVERAGE(R[-19]C:R[-2]C)~=AVERAGE(R[-19]C:R[-2]C)~=AVERAGE(R[-19]C:R[-2]C)~=AVERAGE(R[-19]C:R[-2]C)~=AVERAGE(R[-19]C:R[-2]C)~=AVERAGE(R[-19]C:R[-2]C)~=AVERAGE(R[-19]C:R[-2]C)~=AVERAGE(R[-19]C:R[-2]C)~=AVERAGE(R[-19]C:R[-2]C)~=AVERAGE(R[-19]C:R[-2]C)~=AVERAGE(R[-19]C:R[-2]C)~=AVERAGE(R[-19]C:R[-2]C)~=AVERAGE(R[-19]C:R[-2]C)~=AVERAGE(R[-19]C:R[-2]C)~=AVERAGE(R[-19]C:R[-2]C)~=AVERAGE(R[-19]C:R[-2]C)~=AVERAGE(R[-19]C:R[-2]C)~=AVERAGE(R[-19]C:R[-2]C)
~TENS~TENS~TENS~TENS~TENS~TENS~TENS~TENS~TENS~TENS~TENS~TENS~TENS~TENS~TENS~TENS~TENS~TENS
~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)~=COUNTIF(R[-21]C:R[-4]C,10)+COUNTIF(R[-21]C:R[-4]C,20)
~ZEROES~ZEROES~ZEROES~ZEROES~ZEROES~ZEROES~ZEROES~ZEROES~ZEROES~ZEROES~ZEROES~ZEROES~ZEROES~ZEROES~ZEROES~ZEROES~ZEROES~ZEROES
~=COUNTIF(R[-23]C:R[-6]C,0)~=COUNTIF(R[-23]C:R[-6]C,0)~=COUNTIF(R[-23]C:R[-6]C,0)~=COUNTIF(R[-23]C:R[-6]C,0)~=COUNTIF(R[-23]C:R[-6]C,0)~=COUNTIF(R[-23]C:R[-6]C,0)~=COUNTIF(R[-23]C:R[-6]C,0)~=COUNTIF(R[-23]C:R[-6]C,0)~=COUNTIF(R[-23]C:R[-6]C,0)~=COUNTIF(R[-23]C:R[-6]C,0)~=COUNTIF(R[-23]C:R[-6]C,0)~=COUNTIF(R[-23]C:R[-6]C,0)~=COUNTIF(R[-23]C:R[-6]C,0)~=COUNTIF(R[-23]C:R[-6]C,0)~=COUNTIF(R[-23]C:R[-6]C,0)~=COUNTIF(R[-23]C:R[-6]C,0)~=COUNTIF(R[-23]C:R[-6]C,0)~=COUNTIF(R[-23]C:R[-6]C,0)
step 1: in Excel go to File > Options > Formulas > R1C1 reference style
step 2: copy above code, paste into a blank worksheet. select column A
step 3: data tab, text to columns
step 4: Delimited > Next > Tick Other, enter a tilde (~) in the box > Next > Finish
step 5: reverse step 1; un-select R1C1 (if you value your sanity in ongoing spreadsheet adventures)