Code Monkey home page Code Monkey logo

web's People

Contributors

epeeme avatar

Stargazers

 avatar

Watchers

 avatar  avatar

Forkers

seigel

web's Issues

EFC Country Performance

Table of EFC cadet events each broken down by place finish (1st, 2nd, 3rd, L8, L16, etc) and total average finishing position at country level. Experiment with heat map to see if that improves visualisation. Also, find old code that sort of produced this data but at a much higher level.

European Junior Championships missing results

The following are missing from the FIE site and weren't found on the waybackmachine scrape of the FIE archive.

Championnats d’Europe juniors | Amsterdam(NED) | Start: 03-11-2008 End: 08-11-2008
Championnats d’Europe juniors | Prague(CZE) | Start: 29-10-2007 End: 04-11-2007
Championnats d’Europe juniors | Poznan(POL) | Start: 04-11-2006 End: 09-11-2006

EFC historical results (pre-2010)

Start to track down and import data between 2005 & 2010 based on Rodneys archive of what was a selected cadet event. Non selected events should also be found but will need to compile a list somehow of all seasons - possibly from the waybackmachine archives of the EFC site.

How to send results page

Describe in detail the formats that can be imported as standard and those that are not acceptable. To be used to send to anyone that requests results be included from pdf attachments, region web sites, word docs and CSV files / spreadsheets.

Canonical links

Google is identifying some pages as having duplicate content - this may be down to either scripts being blocked by robots.txt (removed) or not having a <link rel="canonical" href="https://example.com/page.php" /> tag in the header. This tag needs adding to at least the fencer, event & result pages.

Club Performance

Graphs to show year on year average finishing position, number of competitions, active fencers, ...

Create logo assets

Create various sized logo assets for use on all social media platforms.

Cadet Rankings

In essence, recreate what Rodney does ... including BRC events and nominated EFC/JWC events. As the mechanism for ranking changes almost every year, a considerable amount of flexibility needs to be built into this to allow for future changes to the ranking and selection formula.

British Fencing result parser

Investigate a way of pulling results from the British Fencing page. I recall they are stored in XML or JSON in the source, so it may he possible to run a query on all the data and then parse that for the result needed.

Regional results

Warwick Age Group Epee
Beds, Bucks .... County
Hertfordshire County Youth
......

Merge fencer records interface

Create a simple interface that speeds up the process of merging duplicate fencer records.

/tools

include secure pass key

Club page

Make it easier to find club fencers with a dropdown for all clubs that loads the club page directly, rather than having to navigate via the results pages.

Cadet & Junior Euros Analysis

Was 2020 GBRs best ever?

SELECT Year, results.dateID, CAST(AVG(entries) AS Integer) AS entries, CAST(AVG(eventPosition) AS Integer) AS position, AVG((100 / entries) * eventPosition) AS averagePosition, SUM(CASE WHEN eventPosition = 1 THEN 1 ELSE 0 END) AS first, SUM(CASE WHEN eventPosition = 2 THEN 1 ELSE 0 END) AS second, SUM(CASE WHEN eventPosition = 3 THEN 1 ELSE 0 END) AS third, SUM(CASE WHEN eventPosition > 3 AND eventPosition < 9 THEN 1 ELSE 0 END) AS last8, SUM(CASE WHEN eventPosition > 8 AND eventPosition < 17 THEN 1 ELSE 0 END) AS last16, SUM(CASE WHEN eventPosition > 16 AND eventPosition < 33 THEN 1 ELSE 0 END) AS last32, SUM(CASE WHEN eventPosition > 32 AND eventPosition < 65 THEN 1 ELSE 0 END) AS last64, SUM(CASE WHEN eventPosition > 64 AND eventPosition < 129 THEN 1 ELSE 0 END) AS last128 FROM results INNER JOIN eventData ON eventData.eventID = results.eventID AND results.dateID = eventData.dateID AND eventData.catID = results.eventCat INNER JOIN eventDates ON eventDates.eventID = eventData.eventID AND eventDates.ID = results.dateID WHERE results.eventID = 199 AND results.fencerClubID = 415 AND results.eventCat = 21 GROUP BY Year ORDER BY averagePosition ASC

Club pages

Recreate the club pages and link appropriately from all other pages. New format to be implemented that expands on what was offered on the old site.

Review the need for contact data - maybe just social links?

301 Redirects

via Google Analytics

First detected: 30-Oct-2019 08:13:28

Property epee.me is receiving data from redundant hostnames. Some of the redundant hostnames are:

epee.me

www.epee.me

Redundant hostnames are counted as separate rows in reports, so hits that are going to the same page on your site from different hostnames will be split into multiple rows. With data split across multiple rows, traffic to specific pages will appear lower than it actually is.

To avoid this problem, consider setting up a 301 redirect from one of your redundant hostnames to the other, or create a search-and-replace filter that strips "www." from hostnames.

Google Tag Assistant Recordings can help you verify that your redirect is set up correctly, or that your filter is working as intended.

Site map generator

Create an XML site map that has links to every result and fencer. Should run as a (weekly) cron job in line with Google Search console settings for frequency.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.