CODEFORCES PROBLEMS ANALYZER

THIS IS A GOOGLE SPREADSHEET THAT CAN GENERATE CODEFORCES PROBLEMS WITH DESCRIPTION AND ANALYSIS.

Sample Pictures

Main Problem Details Interface

Control Panel and Analysis Segment

This is the page where we store the loaded data to reduce the time spent searching for the same data repeatedly.

FEATURES

• Search for problems based on two values: Contest Division and Problem Number.
• Option to set the number of contests to retrieve using the "Number of Data" field in the control panel.
• Set your Codeforces handle to get the problem verdict and solving analytics.
• Get the count of distinct ratings and their frequency within the search range.
• Retrieve distinct tags and their count for all problems within the search range.
• Create an additional sheet called ProblemCache to save problem details for future use, reducing operation time.

INSTALLATION

• First, open this Sheet and go to "File -> Make a Copy." This will create a copy of the sheet in your Google Drive.

• Scroll right in the sheet to find a segment called "Control Panel." This is the main part that controls the sheet data.

  • Fill your data in the Control Panel as shown and submit :

  • It will ask for permission to modify the data in the sheet. Click "OK."

  • This is safe. Click the "Advanced" option below:

• Now you're ready to search for anything using the control panel.

Warning

If you change the Handle name Make sure to click on the " Reset Cache " it will delete all the previous handle cache or you will get previous handle cache data in your search.

Important

You need to click in the submit button to get the update data .This is the only way to update sheet data

Note

IT WILL TAKE SOME TIME TO LOAD THE DATA DEPENDING ON THE DATA SIZE

Caution

DON'T CHANGE ANYTHING IF YOU DON'T KNOW WHAT'S GOING ON JUST USE THE CONTROL PANEL