Spreadsheets on Jeremy's web site

As at: 11/3/8 (50 spreadsheets)

Encryption and security

OTP.XLS One-time pad generator
Use with: VIGENERE.DOC A tabular form of standard schoolboy coding wheel.
Or with: VIG52VAR.XLS Automatic 62-character Vigenere table generator with sheet for automatically completing a table using manually-selected character order.
PRIMES.XLS Graph of density of occurrence of primes (which are used to produce keys in some encryption systems).
DICE3.XLS Study of probability for similar reason to above (ie: using random data to produce OTPs).
SEAL.XLS Large file! 1.15Mb! Spreadsheet for generating unique, complex, random, backgrounds to print on A4 sticky labels and cut out as seals to apply over keyholes. Run sheet through printer repeatedly for complex intersections - offset page in printer to render unrepeatable.
SEAL2.XLS Another complex background generator. Better page coverage. Seems to need reformatting, in Norwich library. No idea why. Original was fine. To reformat, add axes back, rescale, and remove axes. Designed to save ink. May still be OK without reformatting if you overprint in two orientations.
CELTKNOT.XLS Another seal spreadsheet. A single simple Celtic knotwork design repeated over the page in rainbow colours.
SEALBAKE.XLS And another - repeated sine waves over the page - also rainbow colours.
BINGOPAD.XLS One time pad created using a bingo machine and stats on it.
BINGBALL.XLS Production stats on some FIMO balls I made for the bingo machine to speed up one time pad creation.

Sport and games

RUGBY.XLS Sheet for noting events in rugby matches.
CHESLEN.XLS Analysis of length of 'great' chess games.
DICE3.XLS Agents of chance - dice (loaded, straight, enclosed, pop), roulette, computers.
SHODOKU.XLS A sudoku grid to complete.

Science and technology

Weather

NR1WTH26.XLS Norwich weather from NR1 1PF, '02 to '06. Full dataset with charts. 1.4Mb (just fits onto a 1.44Mb floppy!), 31 charts, 169pp total - _DON'T_ press 'print all' unless you mean it!
NCHWETH4.XLS Weather data recorded by myself in 2002.
PRESSCON.XLS Pressure conversion, mbar/inches Hg.
HYGRO.XLS Hygrometer reading lookup table, with graphs.
HYGRO2.XLS Same as above, but just the main table.

Domestic

ELECTIM2.XLS Electricity purchases from 12/2004 to 11/2006, with radar chart showing cost per week for each month. Note savings produced by economy measures adopted this summer (about August onwards).
ELECSAV2.XLS Electricity savings lookup table (savings for any given wattage per day, week, year). Now updated for Powergen rates at 6/11/6. 'Average charged rate' (ie: pence/kWh figure for whole bill) is now just an estimate based on previous figures.
WASH3042.XLS How hot does the glass door of a washing machine get during a boil wash?
KETB3042.XLS How hot does the surface of a kettle get when it boils?
OVEN.XLS Comparative performance of a type K thermocouple and a 99p mechanical oven thermometer in a Glen Domino electric oven - how to speed up setting of cheap epoxy resin glue safely.
WATRUSEB.XLS Water bills for the last seven years. Shows recent savings due to water economy measures.
TOILETUS.XLS Water use associated with flushing the toilet - 290 days' data. Savings made, trends, etc. TOILETB.XLS Updated file with 496 days' data.

Medical

WEIGHTZ.XLS Updated weight file. Now holds 4 years, 4 months' data.
WEIGHT4.XLS My weight since leaving hospital in 2003 (first part on Risperdal Consta, second on Olanzapine).
Plus earlier versions: WEIGHT3.XLS, WEIGHT2.XLS, WEIGHT.XLS (2001).
UVEXP.XLS My exposure to a 60W sunlamp, Jan '03.

Photography

EXPSURS.XLS Night photography exposures.

Reading company reports

COREPORT.XLT Template for company reports.
LAURA.XLS Laura Ashley accounts.
NFLKCN.XLS Norfolk Constabulary accounts
NMHCT.XLS Norfolk Mental Health Care NHS Trust accounts (the Trust has since changed its name to Norfolk & Waveney Mental Health Care Partnership).
For background and explanatory documents, see: REPORTS.HTM

Transport

HONDA2.XLS Mileage chart for Honda C90 moped
roselane170402.xls Parking against time in the (now demolished) Rose Lane car park.

Postage

STAMPS.XLS How to use 1st and 2nd class stamps more efficiently (use with diet scales - £3 approx). At the time of writing, this is outdated, however, when I update it, I usually just replace the old file with another of the same name.
I have just received the Royal Mail guide to the entirely new pricing structure, which takes into account size, as well as weight and which comes into operation on 21/8/6. So, I won't update the above spreadsheet, but may do something similar for the new system. Find details of the new system at: www.royalmail.com/size.

Politics

DHONDT.XLS Calculate who gets seats and when in proportional elections (eg: European).
DHONDT2.XLS Eastern Region European Election projections,
PWR2004.XLS Who got what in Norwich local elections, 2004
VOTING52.XLS Who voted when in 2002 General Elections
voting2030502.xls As above, but with better trending
whogotwhat030502.xls Who got what for how much, 2002.

Miscellaneous

KSTFEST.XLS Attendance at King Street Festival, 2004.
PGCSERV.XLS Breakdown of Parmentergate Court service charge, 2002/3.
encountersanonymised.250402.xls Study of how many people I knew from my place of work versus how many people I saw in total, when I went into town (2002). Anyone who now has a Poundland 'Click' perfume counter (for counting the number of looks one gets) may finally find a use for it, doing this! :)