Jagnath_Reddy's blog

Codeforces Progress Tracker Extension — Spreadsheet
By Jagnath_Reddy, 10 months ago, In English

Hello,

I've developed a browser extension that tracks the total time you spend on a problem and updates a Google Sheet or local storage with details such as Problem Name, Rating, Tags, Time Taken, Link to Submission, and Remarks.

This extension places a timer at the top of the problem page, which starts when the user first clicks on the problem. A popup is displayed when a solution is accepted, allowing the user to add a remark.

Installation

  1. Download: Visit the GitHub Link and download the ZIP file.
  2. Extract: Unzip the file to a permanent location on your computer.
  3. Extensions Page: Open chrome://extensions/ for Chrome or Settings and more (…) > Extensions for Edge.
  4. Developer Mode: Enable “Developer mode” at the top right.
  5. Load Extension: Click “Load unpacked” and select the extracted folder.

After loading, you can use the extension without attaching a Google Sheet. The extension also allows you to download the data in CSV or JSON format.

To attach a Google Sheet: 1. Create a new Google Sheet. 2. Add codeforcesprogresstracker@gmail.com as an editor. 3. Extract the Spreadsheet ID from the URL (it's the string of characters that comes after the “/d/” and before the “/edit”).

Happy Programming!

Edit: Extension is now available on Microsoft edge: https://microsoftedge.microsoft.com/addons/detail/paphdbhfcbgccimgfejfndjibabngjbh

  • Vote: I like it
  • +5
  • Vote: I do not like it

»
10 months ago, # |
  Vote: I like it 0 Vote: I do not like it

Good idea, but not updating the sheet

→ Reply
»
10 months ago, # |
  Vote: I like it 0 Vote: I do not like it

The timer keeps running even after submitting the code, I used CP editor to directly submit the code and then did it manual from submission page and no change appeared in google sheet, neither the clock stopped running. I don't know when the pop-up comes down for us to add the remark.

→ Reply
  • »
    »
    10 months ago, # ^ |
      Vote: I like it 0 Vote: I do not like it

    Sadly there is no api in Codeforces to verify if a submission is accepted or not so I had to use scraping kinda technique to know if solution is accepted or not , the normal flow of event should be click on the problem -> submit

    And you can reset the timer if you want I kept it running because people can come up with multiple solutions

    → Reply