Guest
home
beatmaps
rankings
community
store
help
forum
  1. Forums
  2. osu!
  3. Development

Automated Tournament Spreadsheet

posted
Total Posts
11
Unbound-
21 posts
Joined April 2015
Topic Starter
Unbound-
So while I was waiting for another tournament mappool to release, I figured i`d make this.
You need to paste the beatmap link to the correct location, and all the other beatmap data is filled automatically using importxml function and regular expressions.
For the formulas to work you need to make sure that your spreadsheet locale is set to United States.(File -> Spreadsheet settings)

Spreadsheet here: https://docs.google.com/spreadsheets/d/1blv5pXFPhJvcJKGFVTLNz5FKMcvb4zjnjqAeWDoUzwI/edit?usp=sharing
I made an instruction video here: https://www.youtube.com/watch?v=_8l6bHOwijg
Hope you find it useful.

Edit: Added catch support. Also i HIGHLY recommend to replace formulas with actual values if they are correct.
Last edited by Unbound- , edited 4 times in total.
Pennek
493 posts
Joined December 2013
Pennek
Thanks this is great
DeletedUser_11633961
DeletedUser_11633961
So, I think there's a problem with the star rating. It never shows the correct star rating. For some reason it looks at the Taiko star rating rather than the standard star rating... (for single diff maps) For maps with multiple diffs, it seems to look at the star rating from two diffs down.

There also seems to be some problems with the time calculation...
Last edited by DeletedUser_11633961 , edited 2 times in total.
Unbound-
21 posts
Joined April 2015
Topic Starter
Unbound-

Spectre HD wrote:

So, I think there's a problem with the star rating. It never shows the correct star rating. For some reason it looks at the Taiko star rating rather than the standard star rating... (for single diff maps) For maps with multiple diffs, it seems to look at the star rating from two diffs down.

There also seems to be some problems with the time calculation...
Someone actually still uses it, *surprised pikachu face*. Well, either way, I fixed star rating and length, have fun.
Giai tich 2
150 posts
Joined November 2016
Giai tich 2
DT Length should be *0.67, not *0.77
And it seems that it will show error on Name, Artist, SR, BPM, ... (BG shown up normally) when entering a link of some maps (Error: Result too large)
Example: beatmapsets/873264#osu/1825504
https://osu.ppy.sh/beatmapsets/320118#osu/714001
Last edited by Giai tich 2 , edited 3 times in total.
Unbound-
21 posts
Joined April 2015
Topic Starter
Unbound-

Giai tich 2 wrote:

DT Length should be *0.67, not *0.77
And it seems that it will show error on Name, Artist, SR, BPM, ... (BG shown up normally) when entering a link of some maps (Error: Result too large)
Example: beatmapsets/873264#osu/1825504
https://osu.ppy.sh/beatmapsets/320118#osu/714001
Changed DT to 0.67, as for results too large error, the google`s importxml function has some limit on amount of data I can import, so it doesnt work on some maps. This could maybe be solved with a desktop scraping application or using osu api to get beatmap data, but im too lazy.
-NOBLE-
8 posts
Joined May 2016
-NOBLE-
This is absolutely awesome! Have tried it out and works well with osu! Standard beatmaps, but for some reason when using the same cells and formulas when importing beatmaps to the sheet for osu!Catch, it seems to populate everything except the Star rating and Length. Is there anything to add to the formulas to make it populate these correctly perhaps?
Unbound-
21 posts
Joined April 2015
Topic Starter
Unbound-

-NOBLE- wrote:

This is absolutely awesome! Have tried it out and works well with osu! Standard beatmaps, but for some reason when using the same cells and formulas when importing beatmaps to the sheet for osu!Catch, it seems to populate everything except the Star rating and Length. Is there anything to add to the formulas to make it populate these correctly perhaps?
Added Catch support! Look at new tab, though im not sure if hr/dt changes to difficulty work the same as they do in STD.
Last edited by Unbound- , edited 1 time in total.
-NOBLE-
8 posts
Joined May 2016
-NOBLE-
Awesome! Cheers for that! Have gone through and added the setup to our tournament sheet in use at the moment. Granted, I am using an import range from another restricted sheet with all the information, so nothing really gets leaked that we don't want to.

The formulas do work well, however on Convert maps (as in those that are normally made for Standard mode) don't work with the current calculations, they produce a number that is close, but not 100%, so those for convert maps I have to modify manually at this stage, but thats all good. Also, the main host wanted the full numbers for DT and HR once they were applied, so again, slightly manual on that part as well, but, just comes down to host preference really.

The sheet that it is on is located here: https://docs.google.com/spreadsheets/d/1bQ9DazkZfBWYDqCUh8IH2Fi8JaXT-XAEc8NHJytKh2I/edit?usp=sharing

Thanks once again for all your help :)
raikoh
102 posts
Joined July 2015
raikoh

Unbound- wrote:

So while I was waiting for another tournament mappool to release, I figured i`d make this.
You need to paste the beatmap link to the correct location, and all the other beatmap data is filled automatically using importxml function and regular expressions.
For the formulas to work you need to make sure that your spreadsheet locale is set to United States.(File -> Spreadsheet settings)

Spreadsheet here: https://docs.google.com/spreadsheets/d/1blv5pXFPhJvcJKGFVTLNz5FKMcvb4zjnjqAeWDoUzwI/edit?usp=sharing
I made an instruction video here: https://www.youtube.com/watch?v=_8l6bHOwijg
Hope you find it useful.

Edit: Added catch support. Also i HIGHLY recommend to replace formulas with actual values if they are correct.
Hi there,

I know this was made a long time ago but I still find this the easiest automated mappool generator to use. However, there are some issues when inputting very select beatmaps. I get an error of "Result too large" seemingly at random depending on the map. For example this map and this map always generates this error no matter what. Is there anything special to do with these maps that doesn't allow for the formula to work or am I doing something wrong? Hopefully you still play the game so you can answer me lol.

Thank you!
Last edited by raikoh , edited 1 time in total.
Unbound-
21 posts
Joined April 2015
Topic Starter
Unbound-

StayR wrote:

Unbound- wrote:

So while I was waiting for another tournament mappool to release, I figured i`d make this.
You need to paste the beatmap link to the correct location, and all the other beatmap data is filled automatically using importxml function and regular expressions.
For the formulas to work you need to make sure that your spreadsheet locale is set to United States.(File -> Spreadsheet settings)

Spreadsheet here: https://docs.google.com/spreadsheets/d/1blv5pXFPhJvcJKGFVTLNz5FKMcvb4zjnjqAeWDoUzwI/edit?usp=sharing
I made an instruction video here: https://www.youtube.com/watch?v=_8l6bHOwijg
Hope you find it useful.

Edit: Added catch support. Also i HIGHLY recommend to replace formulas with actual values if they are correct.
Hi there,

I know this was made a long time ago but I still find this the easiest automated mappool generator to use. However, there are some issues when inputting very select beatmaps. I get an error of "Result too large" seemingly at random depending on the map. For example this map and this map always generates this error no matter what. Is there anything special to do with these maps that doesn't allow for the formula to work or am I doing something wrong? Hopefully you still play the game so you can answer me lol.

Thank you!
Nothing wrong, just google limits the amount of imported data. Can't do anything about it, so you`ll just have to fill those in manually
Please sign in to reply.

New reply

0
1 / 11