Teknique Large Universal Remote (T052)

I picked up a Teknique T052 Large Universal Remote from a bin a while ago, but as it was sans instructions I hadn't got around to making it work with the telly until yesterday. It took me a stupid amount of googling, so here's the info that I found:

  • Turn on your TV.
  • Hold down "SET" and press the "TV" button and release.
  • Press "SET" again. The red light on the remote should be blinking on and off.
  • Press the power button several times.
  • Eventually, your TV should turn off. When it does, press "TV" again to save the setting.

This works for the "SAT", "VCR" and "DVD" buttons, as well as "TV".

...

Bring it, don't bin it

At the end of the academic year at the University of Sheffield, most students move out of their accommodation and end up leaving things behind. Sheffield City Council provides students with a “red sack” service to cope with the extra waste.

This June at the end of term, my partner and I went for a bit of a womble along my road to see what we could pick up. Amongst the bags we found: crockery, cutlery (including kitchen knives), cookware (frying pans, saucepans, woks, baking sheets/tins), kitchen appliances (including George Foreman grills, sandwich makers, toasters and kettles), televisions, DVD players, Freeview boxes, satellite decoders, speakers, games console accessories, lamps, clothes, fancy dress outfits and bedding. Hundreds of pounds' worth of stuff, going straight to landfill.

I picked up a few odds and ends for myself and friends (including my now-favourite red dress), but there was no way I could save everything that I found. Being a "don't mourn, organise" sort of person, at the start of this year I sent out some feelers to the students' union officers about setting up a recycling scheme, and boy did I get a response!

Continue reading Bring it, don't bin it

...

Data Collection Macro

I mentioned in my last post that I've made a little macro for Microsoft Excel 2003 (I think it works in earlier versions, 2007 and OpenOffice Calc, but haven't tested extensively), which helps collate data from lab instruments which spit out individual tab/comma separated text files.

An example of its use: I was taking readings from six different samples at intervals of a few hours. The machine (a fluorimeter) spits out text files with all the information it's gathered, from which I only needed one line (one particular wavelength I was interested in). This macro picks up just the line you need from the file.

Notes:

  • Files must be named "X-YYYY" where "X" is a single digit number representing which sample you are testing and "YYYY" is a four digit number (i.e. 0001 to 9999) representing the number of readings you have taken. The numbers need to be consecutive (1-0001, 1-0002, etc.)
  • You need to know which row you are looking for out of the text file. The easiest way to do this is to import it into Excel/Calc and scroll down until you find it, then note the number.
  • If the text file has any extension other than .txt you need to edit the macro a little. Follow the instructions below for getting the spreadsheet, then press Alt + F11, open up the macro using the bar on the left and search for ".txt" in the code. Replace ".txt" with the file extension and save.

The simple option for using it is to download this Excel spreadsheet, and open it up. (you may have to enable macros) then press Ctrl+Shift+W.

Enter the appropriate information into the pop-up box. Then save the resulting file.

WARNING: The macro will fall over if your naming of files isn't consistent.

To have it at your disposal all the time, save the file in the "XLStart" folder. If you installed Microsoft Office in the default location, you'll find "XLStart" under "C:\Program Files\Microsoft Office\Office" + whatever version of Office you have. Then press Window > Hide. Then whenever you open Excel and press Ctrl+Shift+W, the macro will run.

If you want just the macro itself, download this Visual Basic file.

I hope this ends up being useful to someone - it sure saved me a lot of faffing. If I've been unclear please ask for clarification.

...