MKB Indie Radio logo

Admin help guide

MKB Indie Radio

Top 100 Listener Chart Poll

Simple guide

How to use the admin area

This page explains the admin screen in plain English. Use one tab at a time, check the preview, then save your change.

1
Dashboard
Check how the chart is doing. This tab does not change anything.
2
Import MKB Spreadsheet
Upload your existing Excel file. Green highlighted rows are detected as latest releases.
3
Spreadsheet / Full Stats
Download the weekly report with Top 10, Middle 80, Bottom 10 and movement stats.
4
Weekly Tools
Prepare the next chart week, archive the bottom entries, and manage the Monday update window.
5
Add New Releases
Add new songs from submissions, including artist name and artwork.

Admin tabs

What each tab is for

Open admin area
Dashboard

Look only. No changes.

Use this first. It shows total votes, moved up, moved down, non-movers, new entries and anything that may need archiving.

Live Visual Editor

Edit the full voting page in one place.

Change page wording, colours, logos, social links, the sharing preview, artists, songs, artwork, order and vote totals. The phone preview responds as you type. Nothing changes publicly until you press Save & publish changes.

Listener Map

See where current-week votes are coming from.

The map uses approximate IP geolocation. It works without an API key by default; an optional IPinfo token can be added in this tab.

Traffic & Vote Security

Review traffic and suspicious votes safely.

See recent chart/embed traffic, IP activity, risk hints and recent votes. Flag keeps a vote counted while you review it. Reject excludes it from the live total but preserves the audit record. Ban future blocks new votes from that IP without deleting history.

Import MKB Spreadsheet

Use your existing Excel file.

Upload the workbook you already use. Click Preview first. The importer reads the Top Ten Tracker sheet and marks green highlighted rows as latest releases.

Spreadsheet / Full Stats

Download your report.

Use this to download the CSV spreadsheet after voting closes. It gives you the full chart breakdown for the week, including latest-release status.

Weekly Tools

Prepare the next week.

Use this during the Monday update window. It can prepare a new week, reset votes, save previous ranks and help archive entries.

Add New Releases

Add brand new submissions.

Use this after removing the bottom entries. Add the song title, artist name, music style and artwork.

Create Chart

Only used when starting a new chart.

You usually do not need this every week. Use it only if you want to create a fresh Top 100 chart poll.

EMBED

Put the complete chart on other websites/apps.

Choose embed colours and display options, preview the result, then copy the iframe or JavaScript embed code.

Backup & Restore

Protect and move your chart data.

Create full JSON backups, export portable CSV data and restore safely. Vote security flags and bans are included in full JSON backups.

Previews

Check what listeners see.

Use this before sharing links. It lets you check the public poll and live wall preview.

Live editor

Editing the page safely

1. Preview as you type

Open the Live Visual Editor and use the phone preview on the right. On a mobile or tablet, the preview moves below the controls.

2. Social and sharing

Add only the social accounts you want displayed. Set the sharing title, description and image so Facebook, WhatsApp, X and other services can show a branded preview.

3. Artists and songs

Search the list, edit each track, use the arrows to reorder it, upload replacement artwork or add a new entry. Only tick Delete when you intend to remove that entry and its vote records.

Important: Changing a vote total is available for genuine corrections. Normal listener votes are added automatically, so do not edit totals during live voting unless necessary.

Monday process

What to do each week

Wait until voting closes

Voting closes Monday at 10:30am. Do not make final weekly changes before this time, because listeners may still vote.

Preview your MKB spreadsheet

Open Import MKB Spreadsheet, upload your current Excel file, and choose Preview only. Check that the green latest releases have been found.

Open Spreadsheet / Full Stats

Download the CSV spreadsheet. Keep this as your weekly record before making changes.

Review the zones

Check the Top 10, Middle 80 and Bottom 10. The Top 10 are highlighted. The Middle 80 stay in. The Bottom 10 are the replacement candidates.

Archive what needs removing

Archive tracks that reached the 10-week number-one rule. Then archive the Bottom 10 if you are replacing them with new submissions.

Add new releases

Go to Add New Releases. Add each new song, artist name, style and artwork image. Use the preview before saving.

Prepare the new week

Use Prepare Monday Refresh. This saves previous ranks, resets votes for the new week and opens the next chart period.

Check the public poll

Open the Previews tab and check the voter page and live wall. When happy, share the website and Facebook/group link.

Boxes explained

What the main boxes mean

Box nameWhat it means
Song / Title NameThe name of the track listeners will vote for. Example: Heartbreak Highway.
Artist / MusicianThe singer, musician, band or act name. Example: Sarah Blue & The Roadlights.
StyleThe music type. Example: Country, Americana, Celtic, Folk, Western, Rockabilly, Singer-songwriter.
PositionThe chart number you are giving the track when setting up or importing.
Previous RankWhere the song was last week. Use 0 for a brand new release. This helps show moved up, moved down, new or non-mover.
Weeks at #1How many weeks the track has held the number-one position. When it reaches 10 weeks, it should be archived.
Weeks on PollHow many weeks the track has been in the Top 100 chart.
Image URLA web link to the artist artwork image. Use this only when the image is already hosted online.
Upload ImageChoose the artist artwork from your computer. This is usually the easiest option.
Votes per dayHow many times one listener can vote per day. Your chart uses 3 votes per day.
Import MKB SpreadsheetUpload your existing Excel workbook. The system reads the Top Ten Tracker sheet and treats green highlighted rows as latest releases.
Latest ReleaseThis means the row was highlighted green in your spreadsheet. It will appear in the CSV as Latest Release = YES.

Spreadsheet

What the CSV report tells you

Movement stats

The CSV shows whether each track moved up, moved down, stayed in the same place, or is a brand new entry.

  • Moved up: the track climbed higher.
  • Moved down: the track dropped lower.
  • Non-mover: the track stayed in the same place.
  • New: previous rank is 0.
  • Latest Release: this came from a green highlighted spreadsheet row.

Zone stats

The CSV separates the chart into Top 10, Middle 80 and Bottom 10 so you can quickly decide what to keep or replace.

  • Top 10: highlighted chart leaders.
  • Middle 80: stay in the chart and fight for Top 10.
  • Bottom 10: replacement candidates.
  • Archive: reached the 10-week #1 rule.
Example of how to read the chart
♪
Heartbreak HighwaySarah Blue · Moved up 3 places · Top 10 highlighted
#4
♪
Glasgow MoonlightThe River Saints · Non-mover · Middle 80 stay zone
#42
♪
Last Train HomeJohnny North · Moved down 7 places · Bottom 10 replacement candidate
#96

Rules

Keep / replace / archive

Keep these

Keep the Top 10 and Middle 80 unless they have reached a special archive rule. The Middle 80 are still active and fighting to reach the Top 10.

Replace these

The Bottom 10 are normally replaced with new artists from submissions. Also archive any number-one track that has completed 10 weeks at the top.