Chris Constantine-Armstrong
@rhodium103.bsky.social
🖥️ Digital Arts and Crafts
🧑🏫 Reformed Education Academic
🧪 Officially Former Chemist
📊 Spreadsheet Apologist
🎨 Occasional Artist
⚔️ Warhammer Adjacent
📜 SFHEA
🙋🏻♂️he/they
Professional shitposting account: @[email protected]
🧑🏫 Reformed Education Academic
🧪 Officially Former Chemist
📊 Spreadsheet Apologist
🎨 Occasional Artist
⚔️ Warhammer Adjacent
📜 SFHEA
🙋🏻♂️he/they
Professional shitposting account: @[email protected]
Extracting it from here and recognising the groupings, the and, the or, they either... Then adding in one that recognises anyone saying "at least one of..." or "any two from..." and "60 credits at level 1".
Absolutely insane task to take on just as an experiment. Cannot recommend.
Absolutely insane task to take on just as an experiment. Cannot recommend.
![A very convoluted piece of text that says Core Chemistry 1 (CHEM1078) AND EITHER Mathematical and Experimental Tools required in Chemistry (CHEM1111) OR [Single Mathematics A (MATH1561) AND Single Mathematics B (MATH1571)] OR [Calculus I (MATH1061) AND Linear Algebra I (MATH1071)].](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:f6kw4jhsoz7rizvv7vjxlv7b/bafkreicijrwozzgk5micom6zzlnj3uwfbh3binou4ygsmlo3hbvdhblop4@jpeg)
December 9, 2025 at 9:41 PM
Extracting it from here and recognising the groupings, the and, the or, they either... Then adding in one that recognises anyone saying "at least one of..." or "any two from..." and "60 credits at level 1".
Absolutely insane task to take on just as an experiment. Cannot recommend.
Absolutely insane task to take on just as an experiment. Cannot recommend.
After a couple of weeks and a frightening amount of regular expressions, I've finally got a working system to visualise module pre-requisites, list and map assessments across a programme, and highlight skills and attributes, using only the raw free text field data for 1700+ modules.
December 9, 2025 at 9:19 PM
After a couple of weeks and a frightening amount of regular expressions, I've finally got a working system to visualise module pre-requisites, list and map assessments across a programme, and highlight skills and attributes, using only the raw free text field data for 1700+ modules.
#AdventOfCode Day 6 in #Excel
*Conceptually* trivial but the calc engine doesn't like arrays going in multiple directions at once. So the obvious approach of doing a BYCOL() and switching between SUM/PRODUCT doesn't work.
Putting it the other way around, however, does work.
*Conceptually* trivial but the calc engine doesn't like arrays going in multiple directions at once. So the obvious approach of doing a BYCOL() and switching between SUM/PRODUCT doesn't work.
Putting it the other way around, however, does work.
December 6, 2025 at 11:48 PM
#AdventOfCode Day 6 in #Excel
*Conceptually* trivial but the calc engine doesn't like arrays going in multiple directions at once. So the obvious approach of doing a BYCOL() and switching between SUM/PRODUCT doesn't work.
Putting it the other way around, however, does work.
*Conceptually* trivial but the calc engine doesn't like arrays going in multiple directions at once. So the obvious approach of doing a BYCOL() and switching between SUM/PRODUCT doesn't work.
Putting it the other way around, however, does work.
#AdventOfCode Day 5 in #Excel.
The tricksy one here is separating the input, because unfortunately MATCH("", A:A) doesn't find where the blank space is to split the two bits.
MATCH(TRUE, INDEX(ISBLANK(), 0), 0) works around it.
Presumably there's a more efficient way 🤷♂️
The tricksy one here is separating the input, because unfortunately MATCH("", A:A) doesn't find where the blank space is to split the two bits.
MATCH(TRUE, INDEX(ISBLANK(
Presumably there's a more efficient way 🤷♂️
December 5, 2025 at 2:19 PM
#AdventOfCode Day 5 in #Excel.
The tricksy one here is separating the input, because unfortunately MATCH("", A:A) doesn't find where the blank space is to split the two bits.
MATCH(TRUE, INDEX(ISBLANK(), 0), 0) works around it.
Presumably there's a more efficient way 🤷♂️
The tricksy one here is separating the input, because unfortunately MATCH("", A:A) doesn't find where the blank space is to split the two bits.
MATCH(TRUE, INDEX(ISBLANK(
Presumably there's a more efficient way 🤷♂️
#AdventOfCode Day 4 in #Excel.
Still needs two cells because I'm referencing the split input (well, the concatenated-then-split-then-wrapped input because Reasons) using OFFSET(). (same issue as in Day 2)
Still needs two cells because I'm referencing the split input (well, the concatenated-then-split-then-wrapped input because Reasons) using OFFSET(). (same issue as in Day 2)
December 4, 2025 at 2:12 PM
#AdventOfCode Day 4 in #Excel.
Still needs two cells because I'm referencing the split input (well, the concatenated-then-split-then-wrapped input because Reasons) using OFFSET(). (same issue as in Day 2)
Still needs two cells because I'm referencing the split input (well, the concatenated-then-split-then-wrapped input because Reasons) using OFFSET(). (same issue as in Day 2)
#AdventOfCode Day 2 in #Excel. I got it down to *two* cells. The array engine isn't clever enough to just substitute one bit of code into the other. There's probably some workaround involving processing the input differently, but it gets the answer.
December 2, 2025 at 11:52 AM
#AdventOfCode Day 2 in #Excel. I got it down to *two* cells. The array engine isn't clever enough to just substitute one bit of code into the other. There's probably some workaround involving processing the input differently, but it gets the answer.
#AdventOfCode Day 1 done in a way that will hopefully utterly infuriate a lot of people.
December 1, 2025 at 4:32 PM
#AdventOfCode Day 1 done in a way that will hopefully utterly infuriate a lot of people.
From On This Day last year.
For... various reasons... I will not be partaking in this nonsense this year, but if anyone else is getting ready, may I suggest the "don't talk to Health and Safety about the #Chemistree" approach.
For... various reasons... I will not be partaking in this nonsense this year, but if anyone else is getting ready, may I suggest the "don't talk to Health and Safety about the #Chemistree" approach.
November 14, 2025 at 12:29 PM
From On This Day last year.
For... various reasons... I will not be partaking in this nonsense this year, but if anyone else is getting ready, may I suggest the "don't talk to Health and Safety about the #Chemistree" approach.
For... various reasons... I will not be partaking in this nonsense this year, but if anyone else is getting ready, may I suggest the "don't talk to Health and Safety about the #Chemistree" approach.
I promised some #ViCEPHEC / #ViCEPHEC25 people I'd dump a load of this in a folder. It's on an as-is basis. I'll work on curating and making it better later.
durhamuniversity-my.sharepoint.com/:f:/g/person...
durhamuniversity-my.sharepoint.com/:f:/g/person...
August 29, 2025 at 2:34 PM
I promised some #ViCEPHEC / #ViCEPHEC25 people I'd dump a load of this in a folder. It's on an as-is basis. I'll work on curating and making it better later.
durhamuniversity-my.sharepoint.com/:f:/g/person...
durhamuniversity-my.sharepoint.com/:f:/g/person...
Couldn't decide. Picked both.
June 2, 2025 at 9:43 AM
Couldn't decide. Picked both.
Ah, yes, more top quality chemistry content.
March 15, 2025 at 7:43 PM
Ah, yes, more top quality chemistry content.
Possibly my greatest contribution to #Chemistry.
February 18, 2025 at 6:52 PM
Possibly my greatest contribution to #Chemistry.
Finally cleaned that image of Flasky.
January 19, 2025 at 3:07 PM
Finally cleaned that image of Flasky.
I can try to clean this up and put effort into it later.
December 13, 2024 at 9:44 AM
I can try to clean this up and put effort into it later.
Cleaning out my office and found these conference/symposium chairing signs for keeping speakers to time. I thought I'd lost them!
November 27, 2024 at 12:51 PM
Cleaning out my office and found these conference/symposium chairing signs for keeping speakers to time. I thought I'd lost them!
November 25, 2024 at 7:15 PM
I think we're good to reveal the whole Christmas #Chemistree at Hull.
100 pieces of glassware (I think) in total. No liquids in it this time as I've dangled lights into the flasks instead.
100 pieces of glassware (I think) in total. No liquids in it this time as I've dangled lights into the flasks instead.
November 21, 2024 at 4:24 PM
I think we're good to reveal the whole Christmas #Chemistree at Hull.
100 pieces of glassware (I think) in total. No liquids in it this time as I've dangled lights into the flasks instead.
100 pieces of glassware (I think) in total. No liquids in it this time as I've dangled lights into the flasks instead.
Just finished Babel, or The Neccessity of Violence, and oh boy *personally* *attacked*.
September 27, 2024 at 5:06 PM
Just finished Babel, or The Neccessity of Violence, and oh boy *personally* *attacked*.
Ah, that works. Because I've usually gone for:
September 24, 2024 at 7:51 PM
Ah, that works. Because I've usually gone for:
There it is!
September 9, 2024 at 7:04 PM
There it is!