Building a CV with a Spreadsheet

Susan Vanderplas

2024-02-15

Workflow

Building a CV

.tex file EducationExperiencePublications... .pdf file SusanVanderplas CurriculumVitae 343DHardinHallNorthWing3310HoldregeStreetLincoln,NE68483-0961 402-472-7290 a susan.vanderplas@unl.edu a srvanderplas Education 2015 • PhD , Statistics ,IowaStateUniversity Dissertation:ThePerceptionofStatisticalGraphics 2011 • MS , Statistics ,IowaStateUniversity 2009 • BS , Psychology&AppliedMathematicalSciences ,TexasA&MUniversity ProfessionalExperience 2020 AssistantProfessor , StatisticsDepartment ,UniversityofNebraska,Lincoln 2018 2019 ResearchAssistantProfessor , CenterforStatisticsandApplicationsinForensicEvidence ,IowaStateUniversity 2015 2019 StatisticalAnalyst/Consultant , NebraskaPublicPowerDistrict 2015 2015 Postdoc , IowaStateUniversityOfficeoftheVicePresidentforResearch Publications Studentadviseesindicatedwith ∗ .Contributionpercentagesestimatedfromgitcontributionsusing gitfame wherepossible.Notallprojectshavegithubrepositoriesforwhichthisismeaningful.Mostofthesepapersarehighlycollaborative,andintellectualcontributionsaretypicallysharedbetweenallauthors. PeerReviewedPublications 19. 2023 • VanderPlas , Susan ,Ge,Yawei ∗ ,Unwin,Antony,andHofmann,Heike(Mar.2023).“PenguinsGoParallel:agrammarofgraphicsframeworkforgeneralizedparallelcoordinateplots”.In: JournalofComputationalandGraphicalStatistics . doi : 10.1080/10618600.2023.2195462 . Contribution: Writing(50%) . 18. 2023 • Zemmels,Joseph ∗ , Vanderplas , Susan ,andHofmann,Heike(Feb.9,2023).“AStudyinReproducibility:TheCongruentMatchingCellsAlgorithmandcmcRpackage”.In: RJournal 14(4),pp.79–102. doi : 10.32614/RJ-2023-014 . Contribution: Programmingandanalysis(10%),Writing(20%),Advising(40%) . 17. 2023 • Robinson,Emily ∗ ,Howard,Reka,and VanderPlas , Susan (Jan.2023).“YouDrawIt:Imple-mentationofvisuallyfittedtrendswithr2d3”.In: JournalofDataScience . issn :1680-743X. doi : 10.6339/22-JDS1083 . Contribution: Writing(10%),Advising(80%) . 16. 2022 • Bradford,Denise ∗ and VanderPlas , Susan (Dec.2022).“ExploringRuralShrinkSmartThroughGuidedDiscoveryDashboards”.In: JournalofDataScience ,pp.1–12. issn :1680-743X. doi : 10.6339/22-JDS1080 . Contribution: Programmingandanalysis(10%),Writing(10%),Advising(100%) . 15. 2022 • Wilhelm,Adalbertand VanderPlas , Susan (Nov.2022).“VisualNarrativesoftheCovid-19pandemic”.In: JournalofDataScience,Statistics,andVisualisation 2.7,pp.84–113. doi : 10. 1/ 9

Building a CV

When you get tired of updating publications manually…

.pdf file SusanVanderplas CurriculumVitae 343DHardinHallNorthWing3310HoldregeStreetLincoln,NE68483-0961 402-472-7290 a susan.vanderplas@unl.edu a srvanderplas Education 2015 • PhD , Statistics ,IowaStateUniversity Dissertation:ThePerceptionofStatisticalGraphics 2011 • MS , Statistics ,IowaStateUniversity 2009 • BS , Psychology&AppliedMathematicalSciences ,TexasA&MUniversity ProfessionalExperience 2020 AssistantProfessor , StatisticsDepartment ,UniversityofNebraska,Lincoln 2018 2019 ResearchAssistantProfessor , CenterforStatisticsandApplicationsinForensicEvidence ,IowaStateUniversity 2015 2019 StatisticalAnalyst/Consultant , NebraskaPublicPowerDistrict 2015 2015 Postdoc , IowaStateUniversityOfficeoftheVicePresidentforResearch Publications Studentadviseesindicatedwith ∗ .Contributionpercentagesestimatedfromgitcontributionsusing gitfame wherepossible.Notallprojectshavegithubrepositoriesforwhichthisismeaningful.Mostofthesepapersarehighlycollaborative,andintellectualcontributionsaretypicallysharedbetweenallauthors. PeerReviewedPublications 19. 2023 • VanderPlas , Susan ,Ge,Yawei ∗ ,Unwin,Antony,andHofmann,Heike(Mar.2023).“PenguinsGoParallel:agrammarofgraphicsframeworkforgeneralizedparallelcoordinateplots”.In: JournalofComputationalandGraphicalStatistics . doi : 10.1080/10618600.2023.2195462 . Contribution: Writing(50%) . 18. 2023 • Zemmels,Joseph ∗ , Vanderplas , Susan ,andHofmann,Heike(Feb.9,2023).“AStudyinReproducibility:TheCongruentMatchingCellsAlgorithmandcmcRpackage”.In: RJournal 14(4),pp.79–102. doi : 10.32614/RJ-2023-014 . Contribution: Programmingandanalysis(10%),Writing(20%),Advising(40%) . 17. 2023 • Robinson,Emily ∗ ,Howard,Reka,and VanderPlas , Susan (Jan.2023).“YouDrawIt:Imple-mentationofvisuallyfittedtrendswithr2d3”.In: JournalofDataScience . issn :1680-743X. doi : 10.6339/22-JDS1083 . Contribution: Writing(10%),Advising(80%) . 16. 2022 • Bradford,Denise ∗ and VanderPlas , Susan (Dec.2022).“ExploringRuralShrinkSmartThroughGuidedDiscoveryDashboards”.In: JournalofDataScience ,pp.1–12. issn :1680-743X. doi : 10.6339/22-JDS1080 . Contribution: Programmingandanalysis(10%),Writing(10%),Advising(100%) . 15. 2022 • Wilhelm,Adalbertand VanderPlas , Susan (Nov.2022).“VisualNarrativesoftheCovid-19pandemic”.In: JournalofDataScience,Statistics,andVisualisation 2.7,pp.84–113. doi : 10. 1/ 9 .tex file EducationExperiencePublications... .bib file

Updating a CV

Part of the problem…

If CVs were more like data…

New Workflow

.xlsx file _teac.tex _pres.tex _exp.tex _edu.tex .bib file .tex TemplateBasic Info... .pdf file SusanVanderplas CurriculumVitae 343DHardinHallNorthWing3310HoldregeStreetLincoln,NE68483-0961 402-472-7290 a susan.vanderplas@unl.edu a srvanderplas Education 2015 • PhD , Statistics ,IowaStateUniversity Dissertation:ThePerceptionofStatisticalGraphics 2011 • MS , Statistics ,IowaStateUniversity 2009 • BS , Psychology&AppliedMathematicalSciences ,TexasA&MUniversity ProfessionalExperience 2020 AssistantProfessor , StatisticsDepartment ,UniversityofNebraska,Lincoln 2018 2019 ResearchAssistantProfessor , CenterforStatisticsandApplicationsinForensicEvidence ,IowaStateUniversity 2015 2019 StatisticalAnalyst/Consultant , NebraskaPublicPowerDistrict 2015 2015 Postdoc , IowaStateUniversityOfficeoftheVicePresidentforResearch Publications Studentadviseesindicatedwith ∗ .Contributionpercentagesestimatedfromgitcontributionsusing gitfame wherepossible.Notallprojectshavegithubrepositoriesforwhichthisismeaningful.Mostofthesepapersarehighlycollaborative,andintellectualcontributionsaretypicallysharedbetweenallauthors. PeerReviewedPublications 19. 2023 • VanderPlas , Susan ,Ge,Yawei ∗ ,Unwin,Antony,andHofmann,Heike(Mar.2023).“PenguinsGoParallel:agrammarofgraphicsframeworkforgeneralizedparallelcoordinateplots”.In: JournalofComputationalandGraphicalStatistics . doi : 10.1080/10618600.2023.2195462 . Contribution: Writing(50%) . 18. 2023 • Zemmels,Joseph ∗ , Vanderplas , Susan ,andHofmann,Heike(Feb.9,2023).“AStudyinReproducibility:TheCongruentMatchingCellsAlgorithmandcmcRpackage”.In: RJournal 14(4),pp.79–102. doi : 10.32614/RJ-2023-014 . Contribution: Programmingandanalysis(10%),Writing(20%),Advising(40%) . 17. 2023 • Robinson,Emily ∗ ,Howard,Reka,and VanderPlas , Susan (Jan.2023).“YouDrawIt:Imple-mentationofvisuallyfittedtrendswithr2d3”.In: JournalofDataScience . issn :1680-743X. doi : 10.6339/22-JDS1083 . Contribution: Writing(10%),Advising(80%) . 16. 2022 • Bradford,Denise ∗ and VanderPlas , Susan (Dec.2022).“ExploringRuralShrinkSmartThroughGuidedDiscoveryDashboards”.In: JournalofDataScience ,pp.1–12. issn :1680-743X. doi : 10.6339/22-JDS1080 . Contribution: Programmingandanalysis(10%),Writing(10%),Advising(100%) . 15. 2022 • Wilhelm,Adalbertand VanderPlas , Susan (Nov.2022).“VisualNarrativesoftheCovid-19pandemic”.In: JournalofDataScience,Statistics,andVisualisation 2.7,pp.84–113. doi : 10. 1/ 9 \include{}

R Code

  • Get updated information
    (if using google sheets)
  • Build LaTeX entries for each row with glue or paste0 or sprintf
  • Write lines to a TeX file
    (escaping any special characters)

(Xe)LaTeX

  • Main tex file:
    • basic info (name, address, etc.)
    • packages, options, special definitions
    • Input statements to add R-created tex files for each section
  • For publications, use .bib file + biber
    • could add code and manage with spreadsheet… I just didn’t

moderncv + moderntimeline

Classic

Casual

Banking

Old Style

Fancy

Timeline

LaTeX

Basic Command Structure

tldatecventrytlcventrycventry command \ date info fields {start}{end}{year}{start--end} or {year} {field1}{field2}{field3}{field4}{field5}