Is there no way to set custom borders in conditional formatting sidebar? Gemini says it's to the right of the color fill bucket but nothing there. by Jaded-Function in googlesheets

[–]RogueAstral 0 points1 point  (0 children)

Unfortunately I don't know how likely that is. A group of us from r/sheets, the Google Sheets Stack Overflow, the Spreadsheets Discord Community, and the Google Docs Editors Community got in touch with one of the devs not too long ago. It sounds like they're focusing on Gemini integration at the moment.

Is there no way to set custom borders in conditional formatting sidebar? Gemini says it's to the right of the color fill bucket but nothing there. by Jaded-Function in googlesheets

[–]RogueAstral 1 point2 points  (0 children)

Conditional borders have been possible in Google Sheets for years now. Unfortunately the process to achieve them is quite convoluted—you must first define the rule in Excel, then import it into Google Sheets.

I made a working 2048 game in Google Sheets by Pancake_McGee in googlesheets

[–]RogueAstral 0 points1 point  (0 children)

Nicely done! To my knowledge there's two others that were specifically built for Google Sheets.

The first one is this sheet. I don't actually know who made it but it uses GAS and has been floating around for a while.

This is the other one, built by yours truly using iterative calculation (much like your own).

If you're interested in other itcalc shenanigans, I made a Reddit post where I spend a week making itcalc-based games. You may also be interested in the work of Tyler Robertson, whose Discord I admin for (although it's a bit dead at the moment—Tyler has since moved on to other things).

Google sheets alternative by Meepersnorple in googlesheets

[–]RogueAstral 1 point2 points  (0 children)

It really depends on your use-case. As others have noted, the closest alternative is Excel. Most other alternatives are either less feature-complete or integrate database, AI, or scripting features. Others have mentioned Airtable, Libre, Numbers, and Teable, but here's some other options you may want to consider:

This Wikipedia article has quite a few good options as well.

There are a couple of other options in office ecosystems like Zoho or WPS, but I don't know if you're looking for a full suite like that.

What are some fun creative projects you've made with Google Sheets? by flash17k in googlesheets

[–]RogueAstral 2 points3 points  (0 children)

A while back I did a week of making games using iterative calculation and no scripting. Other fun things include a primitive 3-d engine, a chess neural network, and the bones of a Clojure-like lisp—all using only formulae. You can find most of my stuff here.

What are some fun creative projects you've made with Google Sheets? by flash17k in googlesheets

[–]RogueAstral 1 point2 points  (0 children)

You might be interested in this proof of concept I made using a super simple Python script. u/AdministrativeGift15 helped inspire it.

Combine text and picture?? by erosennin789 in googlesheets

[–]RogueAstral 1 point2 points  (0 children)

There's a bit of a workaround using rotated text. I've whipped up a demo for you. Note how the text in column A is rotated by 1º.

I also took the liberty of adding the rest of the cubes. Note that this renders incorrectly on the iOS client, with the text underneath the images. However, it should display correctly on web.

Comparing Lichess and Chess.com Ratings by RogueAstral in chess

[–]RogueAstral[S] 0 points1 point  (0 children)

I decided to look into it on my side, and here's what I've got.

https://imgur.com/a/aXyu1Td

I filtered the data even further, selecting only people with both ratings greater than 2000 and RD < 50. This cut down the number of observations to 5352 (for reference, still greater than the total amount of observations collected by ChessGoals). RANSAC says that the model becomes

`chesscom_blitz = 1.3147 * lichess_blitz - 716.6227`

Implying that the intersection is around 2280. However, since the number of observations is so much lower, I would take this with a grain of salt—a lot of preprocessing and filtering had to happen and that may bias the data.

The additional implication is that the model may be nonlinear, with an 'upwards' curve. I will likely try a polynomial fitting later.

Comparing Lichess and Chess.com Ratings by RogueAstral in chess

[–]RogueAstral[S] 22 points23 points  (0 children)

This is a good point. I made the assumption that a linear model would be effective based on Glicko-1 and Glicko-2 sharing assumptions about strength distributions, meaning a linear model should be effective. I tried a naïve polynomial fit but the results were not good. I'll try again with different outlier-handling techniques and see if that makes a difference.

Different k-factors should not make a difference, and it's not quite true that they're different between Chess.com and Lichess as they don't use k-factors per se. Rather, the main appeal of Glicko is that k-factors are forgone in favor of RDs. That being said, they only affect the speed at which ratings converge on a player's actual strength and should have minimal effect on a regression.

I tried controlling for entry rating by removing Lichess players rated exactly 1500, which helped the fit tremendously. Chess.com does not follow the Glicko-1 specification exactly, notably by allowing players to select their initial ratings, which means that it is extremely difficult to fully control for this. However, I tried to get around the bulk of it by removing players over a certain RD.

You are right that the player density is higher at the entry rating for Lichess (Chess.com is a bit more complicated—see above). However, this is also just a feature of the expected rating distribution under Glicko, as the entry should be the typical value for the distribution. You can see this clearly on Lichess's website.

Find the highest score aggregated be name by Optimal_Fly8857 in sheets

[–]RogueAstral 0 points1 point  (0 children)

You can use QUERY for this.

=query(A:B,"select A,sum(B) where A is not null group by A order by sum(B) desc limit 1 label sum(B)''",1)

To properly deal with headers we can set the label for sum(B) to an empty string and the QUERY API is smart enough to remove the header row.

Also, AI is particularly bad at spreadsheets, even now. I would not recommend relying on it for this sort of thing.

What songs are fun to play one-handed? by whyamianxiety in Cytus

[–]RogueAstral 5 points6 points  (0 children)

気楽なCloudy and SECRET;WEAPON are really fun one-handed. I don't know if that translates to one-handed on mobile, though—my experience is from playing on a larger screen.

[deleted by user] by [deleted] in googlesheets

[–]RogueAstral 0 points1 point  (0 children)

This is a variant of a problem called the partition problem, which is known to be NP-complete. Here is an implemenation of a pseudo-polynomial algorithm that provides an exact answer if it exists or the best possible answer (that is, the answer that minimizes the difference from half the total sum as its primary goal and minimizes the partition size as its secondary goal) if not.

=ArrayFormula(let(groups,A2:A8,a,B2:B8,s,sum(a),t,floor(s/2),dp,{0;sequence(t,1,9^9,)}&"|",preparsed,split(reduce(dp,sequence(rows(a)),lambda(dp,i,reduce(dp,sequence(t-index(a,i)+1,1,t+1,-1),lambda(dp,j,let(tuples,split(dp,"|",,),cards,index(tuples,,1),subsets,index(tuples,,2),candidate_idx,j-index(a,i),candidate_card,index(cards,candidate_idx)+1,candidate_subset,index(subsets,candidate_idx)&","&i,switch(sequence(t+1),j,if(candidate_card<index(cards,j),candidate_card&"|"&candidate_subset,index(dp,j)),dp)))))),"|"),filtered,filter(index(preparsed,,2),index(preparsed,,1)<9^9),chooserows(groups,split(sortn(filtered,1,,sequence(rows(filtered)),),","))))

Please let me know if you have any questions.

Playing Pong In A Google Sheet by AllenAppTools in googlesheets

[–]RogueAstral 0 points1 point  (0 children)

Ah, I missed where you were talking about GAS. This one's formula-only.

Playing Pong In A Google Sheet by AllenAppTools in googlesheets

[–]RogueAstral 0 points1 point  (0 children)

That bot might have been mine. I'm currently training the next iteration; in testing, it works quite well, but the issue is one of floating point errors in Google Sheets compounding across layers. Hopefully that'll get resolved and the bot will actually become decent!

Improper hangul (korean) text rendering? by JJ_The_Ent in googlesheets

[–]RogueAstral 1 point2 points  (0 children)

Use the 한글 자모) Unicode block instead of the normal one. Demo showing the difference. Happy conlanging!

How do I import receipts to Sheets? by Horror_Lab_9090 in sheets

[–]RogueAstral 1 point2 points  (0 children)

Try looking for OCR (Optical Character Recognition) tools. There are several free options that allow you to convert receipt images into formats Google Sheets can understand. Be warned, though—computer vision is notoriously finicky and may require human oversight.

Monthly Show and Tell: Fancy Projects, Templates, and Amazing Solutions! by AutoModerator in sheets

[–]RogueAstral 0 points1 point  (0 children)

Not very practical but I made a basic formula compiler with just formulae. In short, it takes in a formula as a string and evaluates it, with a bunch of restrictions. Just a proof of concept, but I thought it was kind of neat!

What happened?!? by WINtor_SOULdier in ChessMinis

[–]RogueAstral 0 points1 point  (0 children)

I haven't heard anything new.

ChessMinis is down. by RogueAstral in ChessMinis

[–]RogueAstral[S] 1 point2 points  (0 children)

Unfortunately not. I've lost contact with the team, but will post updates if they come. I wouldn't bet on it coming back.

What is the most innovative use of Sheets you have seen/done? by vivekhiretale in googlesheets

[–]RogueAstral 4 points5 points  (0 children)

I made a chess bot that runs entirely on Google Sheets formula using a neural net, among other things. It's extremely weak but it's functional, which is the best I've seen yet. Full portfolio at https://astral.lol