w3ya_24 <- fd_2024 |>
dplyr:: filter (Call == "W3YA" ) |>
dplyr:: mutate (year = 2024 )
w3ya_23 <- fd_2023 |>
dplyr:: filter (Call == "W3YA" ) |>
dplyr:: mutate (year = 2023 )
w3ya_22 <- fd_2022 |>
dplyr:: filter (CALL == "W3YA" ) |>
dplyr:: mutate (year = 2022 ) |>
dplyr:: rename (Call = CALL)
w3ya_21 <- fd_2021 |>
dplyr:: filter (CALL == "W3YA" ) |>
dplyr:: mutate (year = 2021 ) |>
dplyr:: rename (Call = CALL, ` Power Multiplier ` = Pwr_Mult,
` FINAL SCORE ` = Score)
w3ya_20 <- fd_2020 |>
dplyr:: filter (CALL == "W3YA" ) |>
dplyr:: mutate (year = 2020 ) |>
dplyr:: rename (Call = CALL, ` Power Multiplier ` = ` Pwr- Mult ` ,
` FINAL SCORE ` = SCORE,
` Transmitters ` = ` Xmtrs ` )
w3ya_19 <- fd_2019 |>
dplyr:: filter (CALL == "W3YA" ) |>
dplyr:: mutate (year = 2019 ) |>
dplyr:: rename (Call = CALL,
` Transmitters ` = ` Xmtrs ` )
w3ya_18 <- fd_2018 |>
dplyr:: filter (CALL == "W3YA" ) |>
dplyr:: mutate (year = 2018 ) |>
dplyr:: rename (Call = CALL,
` TOTAL QSOs ` = ` TOTAL QSOS ` ,
` Participants ` = ` Number of Participants ` ,
` Transmitters ` = ` Number of Transmitters ` )
w3ya_17 <- fd_2017 |>
dplyr:: filter (` CALL (does not include checklogs) ` == "W3YA" ) |>
dplyr:: mutate (year = 2017 ) |>
dplyr:: rename (Call = ` CALL (does not include checklogs) ` ,
` TOTAL QSOs ` = ` TOTAL QSOS ` ,
` Participants ` = ` Number of Participants ` ,
` Transmitters ` = ` Number of Transmitters ` )
w3ya_16 <- fd_2016 |>
dplyr:: filter (CALL == "W3YA" ) |>
dplyr:: mutate (year = 2016 ) |>
dplyr:: rename (Call = ` CALL ` ,
` TOTAL QSOs ` = ` TOTAL QSOS ` ,
` Participants ` = ` Number of Participants ` ,
` Transmitters ` = ` Number of Transmitters ` )
w3ya_15 <- fd_2015 |>
dplyr:: filter (CALL == "W3YA" ) |>
dplyr:: mutate (year = 2015 ) |>
dplyr:: rename (Call = ` CALL ` ,
` TOTAL QSOs ` = ` TOTAL QSOS ` ,
` Participants ` = ` Number of Participants ` )
w3ya_14 <- fd_2014 |>
dplyr:: filter (CALL == "W3YA" ) |>
dplyr:: mutate (year = 2014 ) |>
dplyr:: rename (Call = ` CALL ` ,
` TOTAL QSOs ` = ` TOTAL QSOS ` ,
` Participants ` = ` Number of Participants ` )
w3ya_13 <- fd_2013 |>
dplyr:: filter (CALL == "W3YA" ) |>
dplyr:: mutate (year = 2013 ) |>
dplyr:: rename (Call = ` CALL ` ,
` TOTAL QSOs ` = ` TOTAL QSOS ` ,
` Participants ` = ` Number of Participants ` )
w3ya_12 <- fd_2012 |>
dplyr:: filter (CALL == "W3YA" ) |>
dplyr:: mutate (year = 2012 ) |>
dplyr:: rename (Call = ` CALL ` ,
` TOTAL QSOs ` = ` TOTAL QSOS ` ,
` Participants ` = ` Number of Participants ` )
w3ya_11 <- fd_2011 |>
dplyr:: filter (CALL == "W3YA" ) |>
dplyr:: mutate (year = 2011 ) |>
dplyr:: rename (Call = ` CALL ` ,
` TOTAL QSOs ` = ` TOTAL QSOS ` ,
` Participants ` = ` Number of Participants ` )
w3ya_10 <- fd_2010 |>
dplyr:: filter (CALL == "W3YA" ) |>
dplyr:: mutate (year = 2010 ) |>
dplyr:: rename (Call = ` CALL ` ,
` TOTAL QSOs ` = ` TOTAL QSOS ` ,
` Participants ` = ` Number of Participants ` )
w3ya <- purrr:: list_rbind (list (w3ya_24,
w3ya_23,
w3ya_22,
w3ya_21,
w3ya_19,
w3ya_18,
w3ya_17,
w3ya_16,
w3ya_15,
w3ya_14,
w3ya_13,
w3ya_12,
w3ya_11,
w3ya_10))
w3ya <- w3ya |>
dplyr:: select (- c (` GOTA CALL ` , ` GOTA Call ` ,
` CLUB NAME ` )) |>
dplyr:: rename (score = ` FINAL SCORE ` ,
cw_qsos = ` TOTAL CW QSOs ` ,
dig_qsos = ` TOTAL DIGITAL QSOs ` ,
ph_qsos = ` TOTAL PHONE QSOs ` ,
tot_qsos = ` TOTAL QSOs ` ,
bonus = ` BONUS POINTS ` ,
n_particip = ` Participants ` ,
n_xmtrs = ` Transmitters ` )