Raiding the inarticulate since 2010

accelerated academy acceleration agency AI Algorithmic Authoritarianism and Digital Repression archer Archive Archiving artificial intelligence automation Becoming Who We Are Between Post-Capitalism and Techno-Fascism big data blogging capitalism ChatGPT claude Cognitive Triage: Practice, Culture and Strategies Communicative Escalation and Cultural Abundance: How Do We Cope? Corporate Culture, Elites and Their Self-Understandings craft creativity critical realism data science Defensive Elites Digital Capitalism and Digital Social Science Digital Distraction, Personal Agency and The Reflexive Imperative Digital Elections, Party Politics and Diplomacy digital elites Digital Inequalities Digital Social Science Digital Sociology digital sociology Digital Universities elites Fragile Movements and Their Politics Cultures generative AI higher education Interested labour Lacan Listening LLMs margaret archer Organising personal morphogenesis Philosophy of Technology platform capitalism platforms populism Post-Democracy, Depoliticisation and Technocracy post-truth psychoanalysis public engagement public sociology publishing Reading realism reflexivity scholarship sexuality Shadow Mobilization, Astroturfing and Manipulation Social Media Social Media for Academics social media for academics social ontology social theory sociology technology The Content Ecosystem The Intensification of Work The Political Economy of Digital Capitalism The Technological History of Digital Capitalism Thinking trump twitter Uncategorized work writing zizek

Using ChatGPT to fix spreadsheets

I’m putting together the marking plans for our MA, matching first and second markers to student IDs. Obviously I count the markers to ensure the allocations are correct but there’s an annoying discrepancy: 107 students but only 105 markers counted, despite the fact there are marker names next to each student ID. I suspect this is because I’ve left a blank space in next to one of the names (e.g. “Mark ” rather than “Mark”) so it’s not being picked up by my =COUNTIF(C2:C200, “Mark”) formula. But my god do I not want to go through these to manually correct it.

I tried looking on Google but it’s such a specific problem that I’m struggling to find the right answer. Enter ChatGPT. The mundane utility is less the solution (which I would have found eventually through Google or given up and done manually) as much as the ease of articulating the problem in natural language. It’s tiring to parse your search string so an enshittified Google understands it and there’s a wonderful ease in being able to just ask the question.

, ,