NAME[1] ENGRAVED Location 2020 2021 2022 2023
REGATTA TROPHIES     None given No regatta due to Covid    
Regatta Trophy (Forward Challenge Cup) or Individual Challenge Trophy   M Baker Due to Covid   C Dennis C Dennis  
Ladies Cup 84 A Bray A Lea     K Lamb K Lamb  
Novice (formally 12' National Trophy up to 1979) 85 Garett M Davey     L Scholes E Hawkins
     
OTHERS
Presented at  AGM        
Water Rat   Club   S Pischke[2] J Watson-Evans ?
Enterprise Cup (Sprint PH) 86 Halling P Halling   G Thompson R| Wheeler J Watson-Evans
Main 12' Trophy (Summer PH)  79 Halling G Thompson   G Thompson G Thompson R Wheeler
Main Handicap Trophy (Spring PH) 88 Halling G Thompson   R Wheeler J Watson-Evans R Wheeler
Main GP Trophy (Most Crewed)   B Lavery   L Archer E Mason E Mason
Cruiser Trophy (Autumn PH) 77 Anderson N Knowles   G Thompson R Wheeler S Pischke
Cundy Trophy (long distance PH) 86 R Page T Hilton   G Thompson M Baker S Pischke
Young Helmsman Cup 85 Garrett Club   C Pischke L Scholes ?
Saturday Trophy  (SPA PH) 85 Richards  G Thompson   G Thompson C Dennis R Wheeler
Summer Afternoon (Most Races)   Missing   C Pischke M Gatehouse C Dennis
Charles's Broken Boom  (BH Results)   G Thompson   G Thompson S Pischke S Pischke
Tumbling Waters (Improved)   J Watson-Evans   S Pischke C Dennis ?
Laser Cup (Laser PH)       J Watson-Evans S Pischke S Pischke
Early Bird (Early Bird PH)       G Thompson S Pischke S Pischke
Bent Pintle (Bosun PH)       K Knowles N Knowles N Knowles
Sunrise (Sunrise PH)       G Thompson N Knowles N Knowles
         
NAME ENGRAVED Location 2020 2021 2022 2023
RACE SERIES        
Autumn Series BH       G Thompson S Pischke S Pischke
                         PH       G Thompson R Wheeler S Pischke
Bosun Series BH       K Knowles K Knowles K Knowles
                      PH       K Knowles K Knowles K Knowles
Early Bird Series BH       M Baker S Piscke S Piscke
                            PH       G Thompson S Piscke S Piscke
LaserSeries BH       J Watson-Evans S Piscke S Piscke
                   PH       J Watson-Evans S Piscke S Piscke
SPA Series BH       G Thompson J Watson-Evans R Wheeler
                  PH       G Thompson J Watson-Evans R Wheeler
Spring Series BH       M Baker J Watson-Evans R Wheeler
                       PH       R Wheeler J Watson-Evans R Wheeler
Sprint Series BH       G Thompson R Wheeler J Watson-Evans
                    PH       G Thompson R Wheeler J Watson-Evans
Summer Series BH       G Thompson G Thompson K Knowles
                       PH       G Thompson S Piscke R Wheeler
Sunrise Series BH       G Thompson J Watson-Evans K Knowles
                    PH       G Thompson S Piscke K Knowles
         
Most 
Most Races, no rank       C Piscke M Gatehouse C Dennis
Most Crewing, no rank       L Archer E Mason E Mason
Most improved helm       S Pischke C Dennis  
NAME ENGRAVED Location 2020 2021 2022 2023
Using Office 2002
Edit Title etc in trophies2000-Template.htm To out put HTML for web site make a copy of the sheet to the end, delete columns B & C (NOT Hide), Save as HTML inserting into trophies20y0-Template.htm and save as trophies20y0-.html.htm & Rename .html  
Edit out Font and Align as specified in the HTML template.
When done delete the copy sheet
To update the web page MUST Save as Web Page using Excel 97 (uses only .HTM, rename to .html) (Although Excel 2002 will insert a table into an existing HTML file the output is very large)
Follow find/replace  instructions in trophies2000-.html
09Dec2012 Using Libre Office Calc, strange things are happening; see things that shouldn't and if copy/Paste 2012 into a new blank dock pastes another sheet in. 
1 Hide columns B & C
2 Export, saves as an xhtml file;  rename as html. GRID isn't saved and there are extra rows
3 Use Komposer to Delete rows not required and in Extended Table properties add Border 1, CellPadding 3
4 Only the table has a border not the cells. Haven't found how to add borders to the cells, or how to customise the html Calc creates.
16Dec2013 Used Office 97 in VM Win XP
20Jun2016 Used Libre office Calc In trophies2010Template-.htm(l) copy From <HTML> to start of table then uses Kompozer to paste in trophies2010-.html to create the headings etc.. change Name column width to 134px and Year columns to 65px.
Use EditPad Most row heights are wrong so to replace all 'height="nnn" ' with blank.
Open "…\Trophies\TROPHIES.XLS" in LO Calc.>Tab TROPHY HOLDERS 2010->RC Move/Copy Sheet>Copy to New Document>Delete columns B and C>Delete all rows after last NAME>Save a Copy as HTML 
"…\WebRoot\raceresults\trophies\trophies2010-Calc.html">Open trophies2010-Calc.html in EditPad>Replace all ‘height="*" ‘ with null using Regular Expressions ‘height="^\d+$” ‘  but may need RegEditPro
From ...\WebRoot\raceresults\trophies\trophies2010-Template.htm" copy from <meta name=”Authur”… to before </body> and paste into trophies2010-Calc.html  between after</style> and after <body>
03Aug2018 Used Excel 2010 Very easy. Copy existing XLS and html files. Edit copy xls file delete columns B & C. Select range, Save As Html to tropies2016-.html; it will add to the end. In Komposer delete old table and align new table Left. 
27Nov2019 Used Excel 2010 Problem because saving by Excel created a …_files folder linked to html so couldn't copy/paste it; don't think it is needed, omitting folder may have slowed loading.
Kompozer can't edit table, select table, Delete and Publish/Add Excel added new table.
11Nov2023 Use Excell 2019 Copy existing TROPHIES.sxls and Trophies-2016.html files (Webroot\...\Trophiies\) to Trophies
[1]
To out put HTML for web site make a copy of the sheet to the end, delete columns B & C, Save as HTML inserting into trophies2000-0.htm and save as trophies2000-0?.html. 
Edit out Font and Align as specified in the HTML template.
When done delete the copy sheet.
[2]
Richard Cannon:
While recovering from a capsize Steve was hit on the head very hard and needed treatment.