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
- Download: Visit the GitHub Link and download the ZIP file.
- Extract: Unzip the file to a permanent location on your computer.
- Extensions Page: Open
chrome://extensions/for Chrome orSettings and more (…) > Extensionsfor Edge. - Developer Mode: Enable “Developer mode” at the top right.
- 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 [email protected] 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
Good idea, but not updating the sheet
Can you tell me how you submitted the solution?
Pasted the code and submitted it.Now that I think about it, it could have been that you have to accept the access granted in the bots' email.
Its fine, can you check out this video https://youtu.be/LelkZkh8krA?si=PE6_j7X7JZHR0Ux6 . Please let me know if this still doesn't work , thanks
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.
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