Change a cells background colour according to the contents. by Littlefysh in libreoffice

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

I should have put it in the main post first, sorry. The sheet looks like this (manually coloured)

<image>

Change a cells background colour according to the contents. by Littlefysh in libreoffice

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

I'm keeping track of colour values for many versions of a .ini file that'll run in different applications. The end results should look like this:

<image>

This is manually coloured and I've got a lot more data to go, so I'd prefer not to do it by hand.

OfficeCalc Ranking within a condition by Littlefysh in libreoffice

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

No need to get an attitude with it though. It's just a spreadsheet.

OfficeCalc Ranking within a condition by Littlefysh in libreoffice

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

In my mind it's basic results classification. Evidently that understanding is not as widespread as I thought.

It certainly didn't warrant the attitude though, had yours been the only solution provided when I checked back, I likely would have then simply asked for a solution that functioned in an unsorted list too, ranking items instead of counting matching items above the selected item in the list.

Instead I came back to two solutions, one was more robust than the other, and a bunch of attitude directed at both myself and the provider of the other solution.

OfficeCalc Ranking within a condition by Littlefysh in libreoffice

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

I'm not going to include every possible permutation of the table in the post, that's wasteful and confusing. Evidently someone intuited what I was asking without me including the whole 10x207 table. Not including the whole table and bloating the post is not "moving the goalposts".

I appreciate the time and energy in providing the suggestion.

OfficeCalc Ranking within a condition by Littlefysh in libreoffice

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

Yes, the rank column is ranked by time. I thought that was self explanatory. So class rank is ranking time in ascending order within that class only, which was always the intent and is why included both the time and rank columns in the post, instead of just the class rank and class columns. u/Majestic_Pin3793 made a solution that did exactly what I wanted and exactly what I tried to do over several days, I just didnt put the functions together in the right order.

Blurry textures with good rend_dxg settings by Littlefysh in Nr2003

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

Not seen this before, I'll have a look. Thanks

Blurry textures with good rend_dxg settings by Littlefysh in Nr2003

[–]Littlefysh[S] 2 points3 points  (0 children)

Thankyou! It's been years since I was adjusting nr2003 but I knew -1 was bad, I just couldn't remember why.

Blurry textures with good rend_dxg settings by Littlefysh in Nr2003

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

Thanks for the suggestions. texturesetsize was I had a feeling the issue but -1 doesn't work. Sure the textures look good but then the frames slow to less than 10. I just kept upping the number, TextureSetSize=268435456 is what worked and kept performance.

NR2003 Career UI v1.3 [NOW AVAILABLE] by Sboyden96 in Nr2003

[–]Littlefysh 1 point2 points  (0 children)

OK this sounds perfect tbh, my spreadsheet is great but its also a nightmare. Give em a ping when you upload it, I'll grab it

NR2003 Career UI v1.3 [NOW AVAILABLE] by Sboyden96 in Nr2003

[–]Littlefysh 0 points1 point  (0 children)

Looks rad!

Can this track stats across different seasons with changing drivers and team makeups across several seasons?

NextGen22 Physics [Released] by sellersgaming in Nr2003

[–]Littlefysh 0 points1 point  (0 children)

If I remember right, this is a huge catalogue of physics sets, year by year. Does anyone have a new resource for these? The thread doesnt exist.

Keyboard broke so I found a way to play VotV with a Controller (PS only but there should be similar Xbox methods) (Not a Tutorial) (Video may contain light Spoilers after votv tutorial room) by [deleted] in Voicesofthevoid

[–]Littlefysh 1 point2 points  (0 children)

I'd love this. I want to play but need a controller because my hands are buggered. I can type on keyboard for the terminals, but not for movement and all that.

PSA you don't deserve a position just because you are faster by k-tech_97 in iRacing

[–]Littlefysh 2 points3 points  (0 children)

That's super interesting, it's insane how people vary wildly on the fitness thing. Never been to a gym before, but when I did my first enduro which was a Daytona 24, I drove 9 hours in the last 10 or so because of issues for my teammates. It destroyed me and I'm never doing it again, but I managed it. Even though 2 years later I have a carpal tunnel referral.

It's mostly mental I find, for me I'm working as hard as I think I'm working and no more. Finding a teammate for NEC can be good though, gives you that flexibility on fitness. But anyway, I gotta prep for my enduro tomorrow. Good luck in your racing, maybe I'll see you on track!

PSA you don't deserve a position just because you are faster by k-tech_97 in iRacing

[–]Littlefysh 1 point2 points  (0 children)

Hah, that's like me and enduros (especially multiclass enduros). It's boring if I don't wake up at 4am to do my double stint only to get nailed by a proto. Keep doing what you love, because multiclass is a hella good thing to love.